<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";?>
<script type="text/JavaScript">
function goPage(page)
{
	var f = document.form;
	f.page.value = page;
	f.action = '/admin/news.php';
	f.submit();
}
</script>

<script src="/share/js/formcheck.js" type="text/javascript"></script>
<script type="text/javascript">
function go_View(document_no, seq) {
	var f = document.form;
	f.idx.value = document_no;
	f.page.value = seq;
	f.action = 'qna_write.php';
	f.submit();
}

function go_Write() {
	var f = document.form;
	f.action = 'qna_write.php';
	f.submit();
}

function goLang(lang_code) {
	var f = document.form;
	f.lang_code.value = lang_code;
	f.action = 'news.php';
	f.submit();
}

function go_Modify(document_no) {
	var f = document.form;
	f.idx.value = document_no;
	f.action = 'qna_write.php';
	f.submit();
}

function go_Delete(idxval) {
	if(confirm("등록된 글이 삭제 됩니다.\n삭제하시겠습니까?")) {
		var f = document.form;
		f.mode.value = 'del';
		f.idx.value = idxval;
		f.action = './Proc/qna_proc.php';
		f.submit();
	}
}
function searchChk() {
	//검색
	document.form.action = "./qnalist.php";
	document.form.submit();
}
</script>
<div id="contents">
	<h2>QnA</h2>
	<div id="content">
	<form name="form" method="post" target="_self" onsubmit="return false;" >
	<input type="hidden" name="idx">
	<input type="hidden" name="mode">
	<input type="hidden" name="page" value="">
	<fieldset>
		<select name="gubun">
			<option value="0"	<?if($gubun == "0")	echo "selected"; ?>>all</option>
			<option value="1"	<?if($gubun == "1")	echo "selected"; ?>>その他</option>
			<option value="2"	<?if($gubun == "2")	echo "selected"; ?>>入金確認</option>
			<option value="3"	<?if($gubun == "3")	echo "selected"; ?>>GOODS払い戻し要請</option>
			<option value="4"	<?if($gubun == "4")	echo "selected"; ?>>GOODS取り消し</option>
		</select>
		<select name="key">
			<option value="user_id"	<?if($key == "user_id")	echo "selected"; ?>>ID</option>
			<option value="username"	<?if($key == "username")	echo "selected"; ?>>name</option>
			<option value="subject"	<?if($key == "subject")	echo "selected"; ?>>title</option>
			<option value="reg_date"	<?if($key == "reg_date")	echo "selected"; ?>>date</option>
			<option value="contents"	<?if($key == "contents")	echo "selected"; ?>>content</option>
			<option value="email"	<?if($key == "email")	echo "selected"; ?>>mail</option>
		</select>
		<input type="text" name="key_word" class="type-text" size="20"  maxlength="20" value="<?=$key_word?>"  onKeyPress="if(event.keyCode==13) if(event.keyCode==13) searchChk();">
		<select name="key2">
			<option value="all"	<?if($key2 == "all")	echo "selected"; ?>>all</option>
			<option value=""	<?if($key2 == "")	echo "selected"; ?>>未決</option>
			<option value="1"	<?if($key2 == "1")	echo "selected"; ?>>解決済み</option>
			<option value="2"	<?if($key2 == "2")	echo "selected"; ?>>PASS</option>
		</select>
		<input type="button" value="검색"class="btn_blue" onClick="searchChk();" />
		<a href="/admin/qnalist.php"><input type="button" value="취소" class="btn_blue" onClick="location.href='./qnalist.php';" /></a>
	</fieldset>
	</form>
	<table summary="관리자모드 게시판입니다" cellspacing="0" width="1000">
		<colgroup>
			<col width="65"/>
			<col width="80"/>
			<col />
			<col  width="110"/>
			<col  width="110"/>

			<col width="75" />
		</colgroup>
 		<thead>
			<tr>
				<th>No</th>
				<th>sort</th>
				<th>Title</th>
				<th>ID</th>
				<th>Date</th>
				<th>Action</th>
			</tr>
		</thead>
		<tbody>

 <?
		// =============================================== Query
		$tableName = "qna";

		if(!$pageCount) $pageCount = 20;

		$show_one_page			= $pageCount;
		$show_view_page			= 10;

		$page     = ( $page ) ? $page : 1;
		$offset   = ($page-1)*$show_one_page;

		if($key_word) {
			$key_word = str_replace(" ","",$key_word);
			$where = "AND $key LIKE '%$key_word%'";




		}
		if($gubun != 0) $where .= "AND general_setting='$gubun'";

		if($key2 != "all") $where .= "AND original_no='$key2'";

		$order_by = ' ORDER BY no desc,original_no asc';
		$url_tail = "&tab=$tab&tabs=$tabs&key=$key&key2=$key2&gubun=$gubun&order_by=$order_by";

		$query_limit  = "limit $offset,$show_one_page";

		$QUERY_TOTAL = "SELECT count(*) FROM board_$tableName where  is_delete ='N'  $where $order_by";
		 $QUERY_PAGE  = "SELECT *,
		 (SELECT id FROM blacklist WHERE id=user_id) as BLCNT
		 FROM board_$tableName where  is_delete ='N' $where $order_by $query_limit";
		//SELECT *, DATE_FORMAT(writedate, '%Y.%m.%d') AS date FROM tour_community WHERE 1=1 and idx not in (1179,1186) ORDER BY sort DESC ,depth ASC limit 0,15
		//echo $QUERY_PAGE;

		$total_count  = get_db($QUERY_TOTAL);
		$total_page   = ceil( $total_count / $show_one_page);
		$start_num    = $total_count - $offset;  //
		$viewlist2     = ( !$total_count ) ? "" : Get_viewpage2($page,$total_count,$show_one_page,$show_view_page,$url_tail);

		$result= mysql_query($QUERY_PAGE,$db_con);
		if(!$result) {
			error("DB_ERROR");
			exit;
		}
		$total = mysql_affected_rows();
?>
<?
	if(!$total){
		//echo "<tr><td colspan='$colsNum' align=center  height='50px'>등록된 정보가 없습니다.</td></tr>";
		echo "<tr><td colspan=5>登録された情報がございません</dl></li>";

	}else{
		for($i=0; $i<$total; $i++) {
			$Num = $start_num - $i;
			$row = mysql_fetch_array($result);
			$regdate = substr($row[reg_date],0,10);
			if($row[general_setting] == 1){
				$gubunName = "その他";
			}else if($row[general_setting] == 2){
				$gubunName = "入金確認";
			}else if($row[general_setting] == 3){
				$gubunName = "GOODS払い戻し要請";
			}else if($row[general_setting] == 4){
				$gubunName = "GOODS取り消し";
			}


?>
			<tr>
				<td><?=$Num?></td>

				<td><a href="javascript:go_View(<?=$row[no]?>,<?=$page?>);">[<?=$gubunName?>]</a></td>
				<td class="depth"><a href="javascript:go_View(<?=$row[no]?>,<?=$page?>);"><?=$row[subject]?></a></td>
				<td><?if(($row[BLCNT] == $row[user_id]) && $row[user_id] !="") echo "<img src='/images/jin.gif'/>";?><?=$row[user_id]?></td>
				<td><?=$row[reg_date]?></td>

				<td><?if($row[original_no] == 1){?>
						<span class="btn_blue">&nbsp;解決済み&nbsp;</span>
						<?}else if($row[original_no] == 2){?>
						<span class="btn_yellow">&nbsp;PASS&nbsp;</span>
						<?}else{?>
						<span class="btn_red">&nbsp;未決&nbsp;</span>
						<?}?>
				</td>
			</tr>
<?
		}
	}
?>


		</tbody>
		</table>
		<!--div class="btn">
			<a href="javascript:go_Write();" class="btn_blue">등록하기</a>
		</div-->

	</div>
		<div class="page_list">
		<!--  prev/next_std -->
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
</div>
<p></p>
</body>
</html>