정세찬_우리산전

우리산전 문의게시판 List

1. 문의게시판: 공개글, 비밀글 분류; 관리자페이지에서 문의 답변 가능

include_once "./__RootDir__.php";
        include_once "./_lib/_header.php";

$banner_path = "customer";
        $banner_title = "INQUIRY";
        $banner_text = "작은 이익보다는 고객에게 감동을 안겨주는 <br>큰 노력을 계속 하겠습니다";
        $category_name = "고객지원";
        $page_name = "문의게시판";
        $category_page ="e1_notice";
        $this_page = "e3_inquiry";
        include_once("header.php");
        include_once("sub_banner.php");

$page						= xssClean($_GET["page"]);
        $bid							= xssClean($_GET["bid"]);
        $s_keyfield				= xssClean($_GET["s_keyfield"]);
        $s_keyword			= xssClean($_GET["s_keyword"]);

$bid="qna";

$nowpage = "e3_inquiry";

if(!$page) $page = 1;
        if(!$size) $size = 10;

if($s_keyword){
        	if($s_keyfield=="all"){
        		$search_query .=" and (bd_title like '%".$s_keyword."%' || bd_content like '%".$s_keyword."%' || bd_writer like '%".$s_keyword."%' || bd_name like '%".$s_keyword."%'  ) ";
        	}
        	else if($s_keyfield=="bd_writer" ){
        		$search_query .=" and (bd_writer like '%".$s_keyword."%' || bd_name like '%".$s_keyword."%'  ) ";
        	}
        	else{
        		$search_query .=" and ".$s_keyfield."  like '%".$s_keyword."%' ";
        	}
        }

$search_query .= " and bd_id = '".$bid."' ";

$query = "select count(*)  as cnt from  ( select a.*, (select ad_name".$admin_language." from sm_admin where a.bd_regid =  ad_id) as bd_writer    from sm_board a ) as temp  where 1=1 ".$bd_language_query ." "  . $search_query;
        $row = mysqli_fetch_assoc(query($query));

$affect_num = $row["cnt"];

if($affect_num > 0) {
        	if($page > ceil($affect_num / $size)) $page = ceil($affect_num / $size);
        	$start_num = ($page - 1) * $size;

$query = "select * from (select a.*, (select ad_name".$admin_language." from sm_admin where a.bd_regid =  ad_id) as bd_writer  , (select ad_name".$admin_language." from sm_admin where a.bd_answer_id =  ad_id) as answer from sm_board a ) as temp where 1=1 ".$bd_language_query ." ". $search_query . " order by bd_notice desc, bd_idx desc  limit ".$start_num.", ".$size;

$result = query($query);
        }
        $getvalue = "s_keyfield=".$s_keyfield."&s_keyword=".$s_keyword;

<section class="sub_page sub_padding inquiry">
        	<div class="title_box">
        		<h2> echo $page_name; </h2>
        		<p>작은 이익보다는 고객에게 감동을 안겨주는 <br class="hidden-xs">큰 노력을 계속 하겠습니다</p>
        	</div>

<div class="board_table inquiry_table">
        				<table>
        					<thead>
        						<tr>
        							<th>NO</th>
        							<th>TITLE</th>
        							<th>WRITER</th>
        							<th>DATE</th>
        						</tr>
        					</thead>
        					<tbody>
        						php

if($affect_num > 0) {
        							$count = $affect_num - ($page - 1) * $size;
        							while($row = mysqli_fetch_assoc($result)){

<tr>
        									<td>=$row["bd_notice"]=="Y"?"<font color='blue'>[공지]</font>":$count</td>
        									<td>

if($row["bd_pw_yn"]=="Y"){

<a href="./=$nowpage_pw.php?idx==$row["bd_idx"]&page==$page&=$getvalue" ><img class="lock_icon" src="images/icons/lock_icon.png" alt="">=$row["bd_title"]</a>

}
        										else{

<a href="./=$nowpage_view.php?idx==$row["bd_idx"]&page==$page&=$getvalue" >=$row["bd_title"]</a>

}

</td>
        									<td>

if($row["bd_regtype"]=="A"){
        											echo $row["bd_writer"];
        										}
        										else{
        											echo $row["bd_name"];
        										}

</td>
        									<td>=str_replace("-",".",substr($row["bd_regdate"],0,10))</td>
        								</tr>

if($row["bd_state"]=="end")	{

if($row["bd_pw_yn"]=="Y"){

<a href="./=$nowpage_pw.php?idx==$row["bd_idx"]&page==$page&=$getvalue" >=$row["bd_answer_title"]</a>

}
        											else{

<a href="./=$nowpage_view.php?idx==$row["bd_idx"]&page==$page&=$getvalue" >=$row["bd_answer_title"]</a>

}

</td>
        										<td>=$row["bd_answe_writer"]</td>
        										<td>=str_replace("-",".",substr($row["bd_answer_date"],0,10))</td>
        									</tr>

}
        								$count--;
        							}
        						}
        						else {
        							echo "<tr><td colspan=\"10\" align=\"center\">등록(검색)된 정보가 없습니다.</td></tr>";
        						}

</tbody>
        				</table>

</div>

<ul class="list_num">
        			 user_paging($_SERVER["PHP_SELF"]."?".$getvalue, $affect_num, $page, $size);
        		</ul>
        	</div>

</section>
         include_once("footer.php");