<?php

	include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";

	//$PAGE_GUBUN =	"";

	include $_SERVER['DOCUMENT_ROOT']."/pages/inc_top.php";

		// =============================================== Query
			if(!$pageCount) $pageCount = 25;
			$show_one_page			= $pageCount;
			$show_view_page			= 10;

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

			if($key_word) {
				if($key == "jname" || $key == "jname2" || $key == "nickname"){
					$key_word = str_replace(" ","",$key_word);
					$where = "AND $key like '%".$key_word."%' ";
				}else{
					$key_word = str_replace(" ","",$key_word);
					$where = "AND UPPER(".$key.") like '%".strtoupper($key_word)."%' ";
				}
			}


			if($tabs == 2){
				$order_by = ' ORDER BY member_code desc ,m_startdate DESC';
			}else{
				$order_by = ' ORDER BY no DESC';
			}
			if($sort == '1'){
				$order_by = ' ORDER BY m_enddate asc';
			}

			$url_tail = "&tab=$tab&tabs=$tabs&key=$key&order_by=$order_by&LK=$LK&sort=$sort";



			if(!$key_word) {
				$query_limit  = "limit $offset,$show_one_page";
			}
			$total_count  = get_db("SELECT count(*) FROM board_qna where user_no = '$sessionIDX' and is_delete ='N' $where $CoWhere $order_by");
			$QUERY_PAGE  = "SELECT * FROM board_qna where user_no = '$sessionIDX' and is_delete ='N' $where $CoWhere $order_by $query_limit";

				//echo $QUERY_PAGE."<br>";

			$total_page   = ceil( $total_count / $show_one_page);
			$viewlist2     = ( !$total_count ) ? "" : Get_viewpage2($page,$total_count,$show_one_page,$show_view_page,$url_tail);
			$start_num    = $total_count - $offset;  //
			$result= mysql_query($QUERY_PAGE,$db_con);
			if(!$result) {
				error("DB_ERROR");
				exit;
			}
			$total = mysql_affected_rows();
	?>

 <div id="page_index">
  <a href="default.php">HOME</a> > QnA
 </div>

 <div id="sub_content_box">
	<?include"./inc_mypage_tab.php";?>
	<div style="text-align:left;">※タイトルをクリックすると内容を確認できます。</div>
  <table width="100%" class="basic_table">
   <colgroup>
					<col width="10%" />
					<col width="13%" />
					<col width="" />
					<col width="13%" />
					<col width="13%" />
   </colgroup>
   <thead>
    <tr>
     <th class="title_le">番号</th>
     <th class="title_le">カテゴリー</th>
     <th class="title_le">タイトル</th>
     <th class="title_le">記入日</th>
				 <th class="title_le">処理</th>
    </tr>
   </thead>
   <tbody>
				<?
				if(!$total){

						echo "<tr><td colspan='5' align=center  height='50px'>登録された情報がございません。</td></tr>";

				}else{
					for($i=0; $i<$total; $i++) {
						$Num = $start_num - $i;
						$row = mysql_fetch_array($result);
						$created = substr($row[reg_date],0,10);
						$resub = Get_dbres("select tel from user_profiles where user_id = '$row[id]'");
						$rows	= mysql_fetch_array($resub);
						if($row[mChk] == 1){
							$bgColor ="#dddddd";
						}else{
							$bgColor ="#ffffff";
						}
						switch($row[general_setting]){
							case "1":
								$qubunName ="その他";break;
							case "2":
								$qubunName ="入金確認";break;
							case "3":
								$qubunName ="GOODS払い戻し要請";break;
							case "4":
								$qubunName ="GOODS取り消し";break;
						}
				?>
				<tr>
					<td class="ls"><?=$Num?></td>
					<td class="ls"><a href="javascript:chklist('<?=$Num?>');">[<?=$qubunName?>]</a></td>
					<td class="ls_le"><span class="q">Q.</span><a href="javascript:chklist('<?=$Num?>');"><?=$row[subject]?> </a></td>
					<td class="ls"><?=$created?></td>
					<td class="ls"><?	if($row[original_no]){	?>
						<span class="pink">解決済み</span>
					<? }else{ ?>
						<span class="blue">未決</span>
					<?	}	?>			</td>

				</tr>
				<tr id="list<?=$Num?>" style="display:none;">
					<td colspan="5"	class="ls_txt" style="padding:10px; line-height:17px; text-align:left;">
						<span>[質問内容]</span><br /><?=$row[contents]?><br />
					<?	if($row[original_no]){?>
					<strong><span class="blue">A</span>&nbsp;[答え内容] &nbsp;&nbsp;&nbsp;<?=substr($row[modify_date],0,10)?></strong><br /><?=$row[reply_content]?>
					<?	}	?>

					</td>
				</tr>
				<?
					$Num--;
					}
				}
				?>
    <tr>
    	<td colspan="5" class="bottom_ce" >

						<ul class="gal_list_area" style="padding-top:5px;">
       <li class="result">(全<?=$total_count?>件)</li>
       <li><?=$viewlist?></li>
       <li class="search" style="float:right;">
       <? if($_SESSION[S_LEVEL]){ ?>
        <a href="./qna_write.php" id="btn">■ 書き込み ■</a>
       <? } ?>
       </li>
						</ul>

     </td>
    </tr>

	  </tbody>
		</table>
 </div>




<?php
  include"inc_footer.php";
?>
<script type="text/javascript">
	<!--
	function chklist(val){
		if(document.all("list"+val).style.display == "none"){
			$('#list'+val).fadeIn('slow');
			//document.all("list"+val).style.display='';
			//document.all("listBtn"+val).src='/images/sub/btn_fold_on.gif';
		}else{
			$('#list'+val).fadeOut('slow');
			//document.all("list"+val).style.display='none';
			//document.all("listBtn"+val).src='/images/sub/btn_fold_off.gif';
		}
	}
	function formChange(val,mode){
		if(mode == "del"){
			if(confirm("削除しましょうか？")){

			} else {
				return false;
			}

		}
		//내용변경
		document.form.idx.value = val;
		document.form.mode.value = mode;
		if(mode == 'write' || mode == 'proc'){
			document.form.method = "post";
		}else{
			document.form.method = "get";
		}
		document.form.action = "<?=$php_self?>";
		document.form.submit();

	}

	function board_proc(mode) {
		//document.form.idx.value = val;
		document.form.mode.value = mode;
		document.form.action = "<?=$php_self?>";
		document.form.submit();
	}
	-->
</script>
</body>
</html>