<?     
    //db connect
    require('../inc/db_connect.inc');
	include '../site_inc/Template_.class.php';
	include '../lib/include/board_config.php';  // 테이블 명
    
    $tpl = new Template_; 
    $tpl->define(array( 
       'topMenu' =>'lib/include/menu.htm', 
       'index'   =>'board/index.htm', 
    ));

    // 메뉴 페이지
	include '../lib/include/menu.php';

	$tpl->assign('gubun', $gubun);

	$titleImage = "sub".$gubun;
	$tpl->assign('titleImage', $titleImage);

	$tpl->assign('loginCheck', $kd_loginCheck);

	// 왼쪽 타이틀 칼라
	$leftMenuTdColor1 = '#237583';
	$leftMenuTdColor2 = '#33B5C4';
	$leftMenuTdImage = "left2_3.gif";
	
	// 왼쪽 메뉴 타이틀 이미지
	if($gubun <= 20) {
		$tpl->assign('leftMenuTitleImage', 'left3_3.gif');
	} else if(($gubun >= 21) and ($gubun <= 30)) {
		$tpl->assign('leftMenuTitleImage', 'left3_33.gif');
	} else if(($gubun == 41)) {
		$tpl->assign('leftMenuTitleImage', 'left3_1.gif');
		$leftMenuTdColor1 = '#6666FF';
		$leftMenuTdImage = "left2_4.gif";
		$leftMenuTdColor2 = '#A5B4FA';
	}

	// 왼쪽 타이틀 칼라
	$tpl->assign('leftMenuTdColor1', $leftMenuTdColor1);
	$tpl->assign('leftMenuTdColor2', $leftMenuTdColor2);

	// 왼쪽 td 이미지
	$tpl->assign('leftMenuTdImage', $leftMenuTdImage);

	// 회수별
	if($gubun == 3) {
		if(!$code) $code = '-1';
		$tpl->assign('gisu_txt', '조회할 회수를 선택하시면 됩니다.');

		$date_yy = Date("Y");
	    $last_gisu = $date_yy - 1945 + 1 ;

	    $gubun_loop = array();
		$strlen = strlen($last_gisu);

		$gubun_loop[] = array (
				'seq'    => '-1',
				'title'  => "회수선택",
				'select' => ''
			);

		for($i=1; $i<=$last_gisu; $i++) {
			$null = "";
			for($s=0; $s < ($strlen - strlen($i)); $s++)
				$null .= "&nbsp;&nbsp;";
			$gisutxt = $null.$i;

			if($i == $code) $select = "selected";
			else $select = "";

		    $gubun_loop[] = array (
				'seq'    => $i,
				'title'  => $gisutxt." 회",
				'select' => $select
			);
		}
		$tpl->assign('gubun_loop', $gubun_loop);
	}

	// 지역별
	if($gubun == 4) {
		$que = " select * from make_area order by seq ";
		$res = mysql_query($que, $connect);
		$gubun_loop = array();

		$gubun_loop[] = array (
				'seq'    => '',
				'title'  => '전체보기',
				'select' => ''
			);

		while($row = mysql_fetch_array($res)) {
			$title = $row[title];

			if($row[seq] == $code) $select = "selected";
			else $select = "";

			$gubun_loop[] = array (
				'seq'    => $row[seq],
				'title'  => $title,
				'select' => $select
			);
		}
		$tpl->assign('gubun_loop', $gubun_loop);
	}

	// 동호회
	if($gubun == 5) {
		$que = " select * from make_cafe order by seq ";
		$res = mysql_query($que, $connect);
		$gubun_loop = array();
		$gubun_loop[] = array (
				'seq'    => '',
				'title'  => '전체보기',
				'select' => ''
			);

		while($row = mysql_fetch_array($res)) {
			$title = $row[title];

			if($row[seq] == $code) $select = "selected";
			else $select = "";

			$gubun_loop[] = array (
				'seq'   => $row[seq],
				'title' => $title,
				'select' => $select
			);
		}
		$tpl->assign('gubun_loop', $gubun_loop);
	}

	// 이미지 리사이즈
	function getReImageSize($max_w, $max_h, $fwidth, $fheight) {
		$ori_width  = $fwidth;
		$ori_height = $fheight;

		$rate_h = $fheight/$max_h; 
		$rate_w = $fwidth/$max_w; 

		$rate = $rate_w; 

		if(($fheight>=$max_h && $fwidth>=$max_w && $rate_w<$rate_h) || ($fheight>=$max_h && $fwidth<$max_w) || ($fheight<$max_h && $fwidth<$max_w && $rate_w<$rate_h) ) $rate = $rate_h; 

		$resize_h = $fheight/$rate; 
		$resize_w = $fwidth/$rate; 

		if($resize_h > $fheight) $ori_height = $fheight; 
		else $ori_height = $resize_h; 

		if($resize_w > $fwidth) $ori_width = $fwidth; 
		else $ori_width = $resize_w; 

		$resize = array($ori_width, $ori_height); 

		return $resize;
	}

    // data view
	if($view == 'y') {
		$que = " update $docTable[$gubun] set count=count+1 where seq = '$seq' ";
		mysql_query($que, $connect);

		$que = " select * from $docTable[$gubun] 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","<br>",$row[content]);
//		else $content = $row[content];
		$content = stripslashes($row[content]);
		
		$tpl->assign('v_seq',     $row[seq]);
		$tpl->assign('v_gisu',    $row[gisu]);
		$tpl->assign('v_title',   $row[title]);
		$tpl->assign('v_name',    $row[name]);
		$tpl->assign('v_regdate', $regdate);
		$tpl->assign('v_count',   $row[count]);
		$tpl->assign('v_content', $content);
		$tpl->assign('v_del',     $del);   
		$tpl->assign('v_image',   $row[image]); 

		if($row[image]) {
			$fsize   = getimagesize("./photo_image/".$row[image]); 
			$fwidth  = $fsize[0];
			$fheight = $fsize[1];  
		
			$resize = getReImageSize(700, 600, $fwidth, $fheight);

			$width  = $resize[0];
			$height = $resize[1];

			$tpl->assign('v_width', $width);   
			$tpl->assign('v_height', $height); 
		}

		// 아이디 체크 - 아이디가 있으면 해당 아이디만 삭제, 수정 버튼
		$btn_visible = false;
		if(($kd_userid == $row[userid]) or !$row[userid]) $btn_visible = true;
		$tpl->assign('btn_visible', $btn_visible); 
		
		$modify_check = false;
		if($kd_userid and ($kd_userid == $row[userid])) $modify_check = true;
		$tpl->assign('modify_check', $modify_check);
	}

	$scale = 15; 
    $page_scale = 10; 
	if(!$start) $start= 0 ;
    $page =  floor($start/($scale*$page_scale)) ; 

	// sql
	$sql = '';
	if($code) {
		if($gubun=='3') $sql = " where gisu = '$code' ";
		else if(($gubun=='4') or ($gubun='5')) $sql = " where code = '$code' ";
	}
	if($word && ($code <> '')) {
		if($gubun=='3') $sql = " and code = '$code' ";
		else if(($gubun=='4') or ($gubun='5')) $sql = " and code = '$code' ";
	}

	if($word) $que = " select * from $docTable[$gubun] where $field like '%$word%' $sql order by main desc, thread desc, pos asc";
	else $que = " select * from $docTable[$gubun] $sql order by main desc, thread desc, pos asc ";

	if($gisu) {
		$que  = " select * from $docTable[$gubun] where gisu = '$gisu' ";

		if($word) $que .= " and $field like '%$word%' ";
		
		$que .= " order by main desc, thread desc, pos asc";
	}

	$res   = mysql_query($que, $connect );
    $total = mysql_affected_rows();  
    $last  = floor($total/$scale); 

	if($start) $n = $total-$start; 
	else $n = $total; 

	if($total < $scale) $tdHeight = "height=550";
	else $tdHeight = "";
	$tpl->assign('tdHeight', $tdHeight);

	$list_loop = array();
	for($i=$start ; $i< $start+$scale ; $i++) {
	    if($i< $total ) { 
			mysql_data_seek($res, $i);
            $row = mysql_fetch_array($res);

			$no = $n;
			$name = $row[name];
			if((strlen($name) < 7) && ($row[gisu] >0)) $name = $name."(".$row[gisu]."회)";

			$regdate = substr($row[regdate],0,4)."/".substr($row[regdate],4,2)."/".substr($row[regdate],6,2);
			if($seq == $row[seq]) {
				$no = "<font color='#0000FF' ><b>→</font>";
				$fontBold = "<b>";
			} else $fontBold = "";

			$re = "";
			if ($row[depth] != 0 ) {
				for($j=1;$j <=$row[depth];$j++)  
					$re = $re."&nbsp;&nbsp;";
				$re = $re."<img src='./images/ref.gif'>";
			}

			$dotImage = "dot.gif";
			if($row[main] == '1') {
				$no = '공지';
				$dotImage = "dot_gray.gif";
			}

			if(($i % 5) == 4) $na = "</tr><tr bgcolor=#FFFFFF>";
			else $na = "";

			$list_loop[] = array (
				'no'       => $no,
				'seq'      => $row[seq],
				're'       => $re,
				'title'    => $row[title],
				'name'     => $name,
				'regdate'  => $regdate,
				'count'    => $row[count],
				'p_image'  => $row[image],
				'fontBold' => $fontBold,
				'na'       => $na,
				'code'     => $row[code],
				'gisu'     => $row[gisu],
				'dotImage' => $dotImage
			);
			$n--;
		} // end if		
	} // end for
	$tpl->assign('list_loop', $list_loop);

	if($total == 0) {
		$datano = "<tr bgcolor='#FFFFFF'><td height=20 background='images/dot.gif' align=center colspan=5><b>조회할 회수를 선택하시면 됩니다.</td></tr>";
		$tpl->assign('datano', $datano);
	}

	// 페이지 부분
	$para = "gubun=$gubun";
	if($total > $scale) { 
		if( $start+1 >  $scale*$page_scale ) { 
	        $pre_start = ($page-1)*$scale*$page_scale ;  
			$prePage = "<a href='$PHP_SELF?start=$pre_start&$para'>[이전10개]</a>";
			$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 = "[<a href='$PHP_SELF?start=$ln&$para'>$vk</a>]";
				else $nowPage = "[&nbsp;<b>$vk</b>&nbsp;]";  
				$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 = "<a href='$PHP_SELF?start=$n_start&$para'>[다음10개]</a>";
            $tpl->assign('nextPage', $nextPage);
		}
	}

	$tpl->assign('code', $code);
	$tpl->assign('start', $start);
	$tpl->assign('view', $view);

	$tpl->print_('index'); 

	mysql_close($connect);
?>