|
include "../../com/l_menu08.html";?>
include "../../com/lt_quick.html";?>
|
 |
Home > °í°´¼¾ÅÍ > °øÁö»çÇ× |
//°Ë»öÀÎ °æ¿ì
if($find == 'title') {
$where = " WHERE AQ_TITLE LIKE '%$search%'";
} else if ($find == 'content') {
$where = " WHERE AQ_CONTENT LIKE '%$search%'";
}
if($where == '') { $where = " WHERE "; }else{ $where = $where." AND "; }
$where = $where."AQ_NOTICE != 'Y'";
$nowtime=date(Ymd);
//Àüü ·¹ÄÚµå¼ö
$query = "SELECT COUNT(*) AS CNT from NOTICEBOARD $where";
$result = mysql_query($query,$G_CONNECT);
$total_record = mysql_result($result,0,0);
//ÇÑ ÆäÀÌÁö´ç Ãâ·ÂÇÒ ¼ö
$num_per_page = 20;
//ÇÑ ºí·°´ç Ãâ·ÂÇÒ À̵¿ ÆäÀÌÁöÀÇ °¹¼ö
$page_per_block = 8;
//ÇöÀç ÆäÀÌÁö
if($page == '') $page = 1;
//Àüü ÆäÀÌÁö¼ö
$total_page = ceil($total_record/$num_per_page);
//ÀüüÆäÀÌÁö¼ö º¸´Ù ÇöÀçÆäÀÌÁö°¡ Å©´Ù¸é ÀüüÆäÀÌÁö¼ö·Î ¼³Á¤
if($total_page < $page) {
$page = $total_page;
}
if($total_page == 0) {
$page = 1;
}
//ÃÑ ºí·°¼ö
$total_block = ceil($total_page/$page_per_block);
$block = ceil($page/$page_per_block);
$first_page = ($block-1)*$page_per_block;
$last_page = $block*$page_per_block;
if($total_block <= $block) {
$last_page = $total_page;
}
//ÁöÁ¤ÇÑ ÆäÀÌÁö¿¡ ´ëÇÏ¿© Ãâ·ÂÇÒ ·¹ÄÚµå ¹øÈ£ÀÇ ¹üÀ§ °áÁ¤
if($total_record == 0) {
$first = 1;
$last = 0;
}else {
$first = $num_per_page*($page-1);
$last = $num_per_page*$page;
}
?>
 |
=$total_record;?> |
|
 |
=$page;?>/=$total_page;?> |
|
|
//¸ñ·ÏÀ» ²¨³»¿Â´Ù.
$query = "SELECT AQ_NAME, AQ_IDX,AQ_HIT,AQ_TITLE,AQ_FDATE FROM NOTICEBOARD where AQ_NOTICE = 'Y' order by AQ_IDX desc";
$result = mysql_query($query,$G_CONNECT);
//ÆäÀÌÁö¸¸Å ¸ñ·Ï ¾²±â
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$tmp_fdate = substr($row[AQ_FDATE],0,4)."-".substr($row[AQ_FDATE],4,2)."-".substr($row[AQ_FDATE],6,2);
?>
| |
 |
|
=rfn_kstrcut($row[AQ_TITLE], 42, '...');?> if ($tmp_fdate1 == $nowtime) { ?> } ?> |
|
=$tmp_fdate;?> |
|
|
} ?>
//¸ñ·ÏÀ» ²¨³»¿Â´Ù.
$query = "SELECT * FROM NOTICEBOARD $where order by AQ_IDX desc limit $first, $num_per_page";
$result = mysql_query($query,$G_CONNECT);
$curr_row_cnt = mysql_num_rows($result); //ÇöÀç ÆäÀÌÁö¿¡¼ º¸¿©ÁÙ ·¹ÄÚµå ¼ö(À§ Äõ¸® °á°ú ¼ö)
//±Û¹øÈ£
$tmp_num = $total_record - ($num_per_page *($page-1));
//ÆäÀÌÁö¸¸Å ¸ñ·Ï ¾²±â
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$tmp_fdate = substr($row[AQ_FDATE],0,4)."-".substr($row[AQ_FDATE],4,2)."-".substr($row[AQ_FDATE],6,2);
$tmp_fdate1 = substr($row[AQ_FDATE],0,4).substr($row[AQ_FDATE],4,2).substr($row[AQ_FDATE],6,2);
$name=htmlspecialchars($row[AQ_NAME]);
//¿À´Ã³¯Â¥ ±¸Çϱâ
$today = mktime (0,0,0,date("m") ,date("d"),date("Y"));
$today_year = date("Y",$today); $today_month = date("m",$today); $today_day = date("d",$today);
//±Û¾´ ³¯Â¥ ±¸Çϱâ
$fdate_year = substr($row[AQ_FDATE],0,4); $fdate_month = substr($row[AQ_FDATE],4,2); $fdate_day = substr($row[AQ_FDATE],6,2);
$timestamp = strtotime("$today_year-$today_month-$today_day 00:00:00")-strtotime("$fdate_year-$fdate_month-$fdate_day 00:00:00");
$tmp_usetime = intval($timestamp/60/60);
?>
| |
echo $tmp_num-- ?> |
|
=rfn_kstrcut($row[AQ_TITLE], 42, '...');?> if ($tmp_usetime == 0 || $tmp_usetime == 24) { ?> } ?> |
|
=$tmp_fdate;?> |
|
|
}
if($curr_row_cnt == 0) {
echo "
| ³»¿ëÀÌ ¾ø½À´Ï´Ù. |
|
";
}
?>
if($block > 1) { $my_page = $first_page; echo" "; }else{ echo" "; } ?>
if($page > 1) { $my_page = $page - 1; echo" "; }else{ echo" "; } ?>
|
for($i = $first_page+1; $i <= $last_page ; $i++) {
if($i == $page) {
?>
echo $i;?> .
} else { ?>
echo $i;?> if ($last_page != $i) { ?> . } ?>
} ?>
}
?>
|
//´ÙÀ½
if($page < $total_page)
{
$my_page = $page + 1;
echo" ";
}else{
echo" ";
}
?>
//ºí·°Ç¥Çö - ´ÙÀ½*°³
if($block < $total_block)
{
$my_page = $last_page+1;
echo" ";
}else{
echo" ";
}
?>
|
|
if ($SES_MEM_LEVEL == '003' or $SES_MEM_LEVEL == '002') { ?>
 |
|
} ?>
 |
|
|
|
| |