GetLoginPkid();
$LoginName = $webhelper->GetLoginName();
//LoginCheck
$PageCode = "050101";
$sno = "7"; //완공사례
//$title = "완공사례";
$title = "완공사례";
$PageUrl = "/gallery/completion_case01.php";
$PageName = "completion_case01";
$b_cate = "건축갤러리 상담신청"; //상담카테고리
//Parameter
$page = $webhelper->RequestFilter("page", 0, false);
$sch_b_show = $webhelper->RequestFilter("sch_b_show", 20, false);
$searchKey = $webhelper->RequestFilter("searchKey", -1, false);
$pkid = $webhelper->RequestFilter("pkid", 0, false);
$Parameter = "?page=$page&sch_b_show=$sch_b_show&searchKey=" . urlencode($searchKey);
//Parameter Check
if ($webhelper->isNull($page)) $page = 1;
if ($webhelper->isNull($sch_b_show)) $sch_b_show = "";
if ($webhelper->isNull($searchKey)) $searchKey = "";
if ($webhelper->isNull($pkid)) $pkid = 0;
$dbhelper->dbOpen();
//카테고리
$sql = "SELECT * FROM Web_board_set WHERE sno='$sno'";
$Cate = $dbhelper->RunSQLReturnOneRow($sql);
if($Cate["bs_cate"] != "")
$CateArray=explode("|",$Cate["bs_cate"]);
if($pkid > 0)
{
$sql = "select * from Web_board_data d left join Web_member m on d.mb_uid = m.mb_uid left join Web_board_set s on d.sno=s.sno where bno = $pkid ";
$View = $dbhelper->RunSQLReturnOneRow($sql);
$ViewCateArray = explode("|",$View["b_cate"]);
$ViewEtc3Array = explode("|",$View["b_etc3"]);
$sql = "select * from Web_board_file where bf_kind = 'board' and bno = ". $pkid ." order by bfno asc, bf_datetime desc";
$ViewFileList = $dbhelper->RunSQLReturnRows($sql);
$sql = "select * from Web_board_comment where bno = ". $pkid ." order by Bc_step , bc_step_reply";
$ViewCommentList = $dbhelper->RunSQLReturnRows($sql);
if ( $View['b_conn_url1'] ) {
$bno = $View['b_conn_url1'];
$sql = "select *, (select bf_file from Web_board_file f where f.bno = d.bno and f.bf_kind = 'board' and bfno = 0 order by bf_datetime desc limit 1 ) bf_file from Web_board_data d left join Web_member m on d.mb_uid = m.mb_uid left join Web_board_set s on d.sno=s.sno where bno = '$bno' ";
$View1 = $dbhelper->RunSQLReturnOneRow($sql);
}
if ( $View['b_conn_url2'] ) {
$bno = $View['b_conn_url2'];
$sql = "select *, (select bf_file from Web_board_file f where f.bno = d.bno and f.bf_kind = 'board' and bfno = 0 order by bf_datetime desc limit 1 ) bf_file from Web_board_data d left join Web_member m on d.mb_uid = m.mb_uid left join Web_board_set s on d.sno=s.sno where bno = '$bno' ";
$View2 = $dbhelper->RunSQLReturnOneRow($sql);
}
if ( $View['b_conn_url3'] ) {
$bno = $View['b_conn_url3'];
$sql = "select *, (select bf_file from Web_board_file f where f.bno = d.bno and f.bf_kind = 'board' and bfno = 0 order by bf_datetime desc limit 1 ) bf_file from Web_board_data d left join Web_member m on d.mb_uid = m.mb_uid left join Web_board_set s on d.sno=s.sno where bno = '$bno' ";
$View3 = $dbhelper->RunSQLReturnOneRow($sql);
}
if ( $View['b_conn_url4'] ) {
$bno = $View['b_conn_url4'];
$sql = "select *, (select bf_file from Web_board_file f where f.bno = d.bno and f.bf_kind = 'board' and bfno = 0 order by bf_datetime desc limit 1 ) bf_file from Web_board_data d left join Web_member m on d.mb_uid = m.mb_uid left join Web_board_set s on d.sno=s.sno where bno = '$bno' ";
$View4 = $dbhelper->RunSQLReturnOneRow($sql);
}
if ( $View['b_conn_url5'] ) {
$bno = $View['b_conn_url5'];
$sql = "select *, (select bf_file from Web_board_file f where f.bno = d.bno and f.bf_kind = 'board' and bfno = 0 order by bf_datetime desc limit 1 ) bf_file from Web_board_data d left join Web_member m on d.mb_uid = m.mb_uid left join Web_board_set s on d.sno=s.sno where bno = '$bno' ";
$View5 = $dbhelper->RunSQLReturnOneRow($sql);
}
}
$dbhelper->dbClose();
if($ViewFileList != null && count($ViewFileList) > 0) {
$i = 0;
foreach ($ViewFileList as $row){
if ( $row["bf_file"] ) {
$str = "";
$tmp = $webhelper->GetImageExplode( $row["bf_file"] );
$row['file'] = "/common/download.php?code=".$View['bs_code']."&pkid=".$View['bno'];
//$str .= "add_file(\"