<?session_start();
	require_once "$DOCUMENT_ROOT/board/lib/PDBC.inc";
	require_once "$DOCUMENT_ROOT/lib/class.OSSTEM_Smarty.inc";
	require_once "$DOCUMENT_ROOT/lib/class.myFunction.inc";

	$smarty = new OSSTEM_Smarty;
	$table	=	"TB_GALLERY";
	$file_table	=	"TB_GALLERY_FILES";
	$bbs_info[index]	=	2;

	if(!$mode || $mode == "list"){	
		$sql	=	"SELECT no,gid,subject,date,hit FROM $table ";
		$where	 =	" WHERE 1=1 ";
		$order  = " ORDER BY date DESC";
		if($gid) $where.= " AND gid='$gid' ";

		//페이징 
		$list_num = 10;
		if($page < 1) $page=1;		
		$start = ($list_num*($page-1));
		$limit	 =" LIMIT $start , $list_num";	

		$data =	 $PDBC->getAll("$sql$where$order$limit");
		$cnt	= count($data);

		//전체 사진 갯수 
		$total = $PDBC->getOne("SELECT count(*) as t_cnt FROM $table ");

		// 페이징 
		if($page < 1) $page=1;
		//총글수 구하기
		//		$total = $rec_count[total];
		//검색 시작 row, 끝 row 구하기
		if ($total <= $list_num || $page == 1)
			$begin_row  = 0;
		else
			$begin_row = (($page-1)*$list_num);

		$param  =  "gno=$gno";
		$PageList= $myFunction->PageIndex1($total, $list_num, $param, $page) ;
		//순서	-	사용않음
		$index_num = $total-(($page-1)*$list_num);

		//해당사진갯수
		$p_qry	=	"select count(*) as pics  from $file_table where gno = ? ";
		$sth = $PDBC->prepare("$p_qry");

		for($i=0;$i<$cnt;$i++){
			$res		=	$PDBC->execute($sth, $data[$i][no]);
			$row		=	$res->fetchRow(DB_FETCHMODE_ORDERED);
			$data[$i][pics]	=	$row[0];
			$data[$i][idx]	=	$index_num--;			 
//			$index_num--;
		}


		if (PEAR::isError($data)) {
			die($data->getMessage());
		}

		$smarty->assign("PageList",$PageList);
		$smarty->assign("index_num",$index_num);

		$output	=	'gallery.tpl';		
		$smarty->assign("rowData",$data);

	}elseif($mode == "read"){
		$g_rlt	=	$PDBC->query("SELECT * FROM $table WHERE no=$gno");
		$g_rlt->fetchInto($g_data);

		//읽은것 업데이트 
		$g_read_sql = "update $table set hit=hit+1  WHERE no=$gno";
		$PDBC->query($g_read_sql);

		$list_num = 12;

		if($page < 1) $page=1;
		
		$start = ($list_num*($page-1));

		$sql	=	"SELECT * FROM $file_table ";
		$where	 =	" WHERE gno=$gno";
		$limit	 =" LIMIT $start , $list_num";
		$data =	 $PDBC->getAll("$sql$where$limit");
		$rows = 3;
		$cols =4;

		$array = array_fill(0, 12 ,"");

		if (PEAR::isError($data)) {
			die($data->getMessage());
		}

		//전체 사진 갯수 
		// $total = $PDBC->getOne("SELECT count(*) as t_cnt FROM $table ");

		// 페이징 
		$total = $PDBC->getOne("SELECT * FROM $file_table WHERE gno=$gno ");
		//총글수 구하기
		//		$total = $rec_count[total];
		//검색 시작 row, 끝 row 구하기
		if ($total <= $list_num || $page == 1)
			$begin_row  = 0;
		else
			$begin_row = (($page-1)*$list_num);

		$param  =  "mode=read&gno=$gno";
		$PageList= $myFunction->PageIndex1($total, $list_num, $param, $page) ;
		//순서	-	사용않음


		$output	=	'gallery_view2.tpl';		
		$smarty->assign("PageList",$PageList);
		$smarty->assign("array",$array);
		$smarty->assign("g_data",$g_data);
		$smarty->assign("rowData",$data);

	}elseif($mode == "insert"){
		
		if(!$gid) $gid='osstem';
		$smarty->assign("mode","$mode");	
		$smarty->assign("gid","$gid");

		$output	=	'gallery_input.tpl';		
	}elseif($mode == "modify"){	
		$output	=	'';		
	}

	$smarty->assign('aboutCLASS3','m2');
	$smarty->assign('overCLASS3',' class=link2 ');

	$smarty->assign("company_over_img",2);
	$smarty->assign("gid",$gid);
	$smarty->assign("gno",$gno);
	$smarty->display($output);


?>