//db connect
require('../inc/db_connect.inc');
include '../site_inc/Template_.class.php';
$tpl = new Template_;
$tpl->define(array(
'topMenu' =>'lib/include/menu.htm',
'leftMenu' =>'dong_news/leftMenu.htm',
'index' =>'dong_news/index.htm',
));
// »ó´Ü ¸Þ´º ÆäÀÌÁö
include '../lib/include/menu.php';
// ¿ÞÂÊ ¸Þ´º ÆäÀÌÁö
include './leftMenu.php';
$tpl->assign('CheckId', $kd_loginCheck);
if($pageGubun == 0) {
$docTable = 'gongji';
$docImage = 'sub1.gif';
}
if($pageGubun == 1) {
$docTable = 'news';
$docImage = 'sub2.gif';
}
if($pageGubun == 2) {
$docTable = 'hs_news';
$docImage = 'sub4.gif';
}
$tpl->assign('docImage', $docImage);
$tpl->assign('pageGubun', $pageGubun);
// µ¿¹®°æÁ¶»ç ¿¡´Â ±â¼ö
if($pageGubun == 2) {
$date_yy = Date("Y");
$last_gisu = $date_yy - 1945 + 1 ;
$gisu_loop = array();
$strlen = strlen($last_gisu);
for($i=1; $i<=$last_gisu; $i++) {
$null = "";
for($s=0; $s < ($strlen - strlen($i)); $s++)
$null .= " ";
$gisutxt = $null.$i;
if($i == $gisu) $select = "selected";
else $select = "";
$gisu_loop[] = array (
'seq' => $i,
'title' => $gisutxt." ȸ",
'select' => $select
);
}
$tpl->assign('gisu_loop', $gisu_loop);
}
// ############### data view start ###########################
if($seq) {
// count update
$que = " update $docTable set count = count + 1 where seq = '$seq' ";
mysql_query($que, $connect);
$que = " select * from $docTable where seq = '$seq' ";
$res = mysql_query($que, $connect);
$row = mysql_fetch_array($res);
$regdate = substr($row[regdate],0,4)."/".substr($row[regdate],4,2)."/".substr($row[regdate],6,2);
if(strlen(trim($row[regdate])) > 8) $regdate = $regdate." ".substr($row[regdate],8,2).":".substr($row[regdate],10,2);
if($row[html] == 'n') $content = ereg_replace("\n","
",$row[content]);
else $content = $row[content];
$tpl->assign('seq', $seq);
$tpl->assign('title', $row[title]);
$tpl->assign('name', $row[name]);
$tpl->assign('regdate', $regdate);
$tpl->assign('count', $row[count]);
$tpl->assign('content', $content);
$tpl->assign('gisu', $row[gisu]);
}
// ############### data view end ###########################
$scale = 20; // 1ÆäÀÌÁö´ç »Ñ·ÁÁÙ ÀÚ·á¼ö¸¦ 10À¸·Î ÇÑ´Ù.
$page_scale = 10; // ¹Ø¿¡ º¸¿©ÁÖ´Â 1ȸé´ç ÆäÀÌÁö¼ö
if(!$start){ $start= 0 ;} //Á¦ÀÏ Ã³À½ Á¢±ÙÇÏ´Â °Å¶ó¸é º¸¿©ÁÙ ½ÃÀÛ ·¹Äڵ带 0 À¸·Î ÇÑ´Ù.
$page= floor($start/($scale*$page_scale)) ;
$whereGisu = "";
if($word) {
if($gisu) $whereGisu = " and gisu='$gisu' ";
$que = "select * from $docTable where $field like '%$word%' $whereGisu order by seq desc ";
} else {
if($gisu) $whereGisu = " where gisu='$gisu' ";
$que="select * from $docTable $whereGisu order by seq desc " ;
}
$res = mysql_query($que, $connect);
$total = mysql_affected_rows(); // ÃÑ ·¹Äڵ尹¼ö¸¦ ¸®ÅÏÇÑ´Ù.
$last=floor($total/$scale); // ȸéÇÏ´Ü [1] [2] .. ¸¶Áö¸·¹øÈ£
if($total < $scale) $tdHeight = "height=550";
else $tdHeight = "";
$tpl->assign('tdHeight', $tdHeight);
if($start) $n = $total-$start;
else $n = $total;
$list_loop = array();
for($i=$start ; $i< $start+$scale ; $i++) {
if($i< $total )
{
mysql_data_seek($res, $i);
$row = mysql_fetch_array($res);
$regdate = substr($row[regdate],0,4)."/".substr($row[regdate],4,2)."/".substr($row[regdate],6,2);
$no = $n;
if($seq == $row[seq]) {
$no = "¡æ";
$fontBold = "";
} else $fontBold = "";
$list_loop[] = array (
'no' => $no,
'seq' => $row[seq],
'title' => $row[title],
'name' => $row[name],
'regdate' => $regdate,
'count' => $row[count],
'fontBold' => $fontBold,
'gisu' => $row[gisu],
);
$n--;
} //if
} //for
$tpl->assign('list_loop', $list_loop);
// ÆäÀÌÁö ºÎºÐ
$para = "pageGubun=$pageGubun";
if($total > $scale) {
if( $start+1 > $scale*$page_scale ) {
$pre_start = ($page-1)*$scale*$page_scale ;
$prePage = "[ÀÌÀü10°³]";
$tpl->assign('prePage', $prePage);
}
$page_loop = array();
for($vj=0; $vj < $page_scale ; $vj++) {
$ln = ($page * $page_scale + $vj)*$scale ;
$vk= $page * $page_scale + $vj+1 ;
if($ln < $total) {
if($ln!=$start) $nowPage = "[$vk]";
else $nowPage = "[ $vk ]";
$page_loop[] = array ('page' => $nowPage);
}
}
$tpl->assign('page_loop', $page_loop);
if($total > (($page+1)*$scale*$page_scale)) {
$n_start = ($page+1)*$scale*$page_scale ;
$nextPage = "[´ÙÀ½10°³]";
$tpl->assign('nextPage', $nextPage);
}
}
$tpl->assign('view', $view);
$tpl->assign('start', $start);
$tpl->print_('index');
mysql_close($connect);
?>