<?include "./mypage_left.php";?>
<?
	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 = '$mIdx' and is_delete ='N' $where $CoWhere $order_by");
	$QUERY_PAGE  = "SELECT * FROM board_qna where user_no = '$mIdx' 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();
?>

 <style>
.article2 			{float:right;}
.article2 h3 {text-align:left; font-size:16px; color:#000;}
.article2 ul.qna_ti {width:580px; height:26px; line-height:26px; margin-top:18px; background:url(/images/member/ul_bg.gif) repeat-x; border-top:1px solid #d3d3d3; border-bottom:1px solid #d3d3d3; color:#676767; text-align:left; font-weight:bold;}
.article2 ul.qna_ti li {float:left;}
.article2 ul.qna_ti li.number {width:56px; border-right:1px solid #d3d3d3; text-align:center;}
.article2 ul.qna_ti li.title {width:271px; padding-left:11px; border-left:1px solid #fff; border-right:1px solid #d3d3d3;}
.article2 ul.qna_ti li.date3 {width:133px; border-left:1px solid #fff; border-right:1px solid #d3d3d3; text-align:center;}
.article2 ul.qna_ti li.treat {width:102px; border-left:1px solid #fff; text-align:center;}

.article2 dl {width:580px; margin:0 0 27px 0; padding:0;}
.article2 dt {width:580px; height:28px; line-height:28px; color:#999; border-bottom:1px solid #d3d3d3; background:#fff;}
.article2 dt ul.dt_ti {width:580px; overflow:hidden;}
.article2 dt ul.dt_ti li {float:left;}
.article2 dt ul.dt_ti li.number_s {width:57px;}
.article2 dt ul.dt_ti li.title_s {width:276px; padding-left:8px; text-align:left;}
.article2 dt ul.dt_ti li.title_s span {color:#ec6da2; font-weight:bold;}
.article2 dt ul.dt_ti li.date_s {width:134px; font-weight:bold;}
.article2 dt ul.dt_ti li.treat_s {width:104px; font-weight:bold;}
.article2 dt ul.dt_ti li.treat_s span.blue {color:#3398cc;}
.article2 dt ul.dt_ti li.treat_s span.pink {color:#ec6da2;}

.article2 dd {width:580px; text-align:left; line-height:22px; background:#fff;}
.article2 dd span {font-weight:bold;}
.article2 dd p {width:506px; margin:0; padding:14px 14px 14px 77px; color:#999;}

.article2 dd h4 {color:#999; margin-top:10px;}
.article2 dd h4 span.blue {color:#3398cc; padding-left:65px;}
.article2 dd p.answer span.pad_left {padding-left:15px; font-weight:normal;}
	</style>


	<div class="mypg_center"></div>
	<div class="mypg_right">
		<div class="article2">		<!--	article area	-->
			<h3>Q&amp;A</h3>
			<ul class="qna_ti">
			<li class="number">番号</li>
			<li class="title">タイトル</li>
			<li class="date3">記入日</li>
			<li class="treat">処理</li>
			</ul>
			<dl>

			<!--dt>
				<ul class="dt_ti">
				<li class="number_s">2</li>
				<li class="title_s">
					<span class="q">Q</span>
					Test Article Test Article Test Article Test Article
				</li>
				<li class="date_s">2012-04-13</li>
				<li class="treat_s"><span class="blue">未決</span></li>
				</ul>
			</dt-->
			<?
				if(!$total){
					echo "<dt>登録された情報がございません</dt>";
				}else{
					for($i=0; $i<$total_count; $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";
						}
				?>
			<dt>
				<a href="javascript:chklist('<?=$Num?>');">
				<ul class="dt_ti">
				<li class="number_s"><?=$Num?></li>
				<li class="title_s">
					<span class="q">Q</span>
					<?=$row[subject]?>
				</li>
				<li class="date_s"><?=$created?></li>
				<li class="treat_s">
					<?if($row[original_no] == 1){?>
						<span class="pink">回答済み</span>
					<?}else{?>
						<span class="blue">未回答</span>
					<?}?>
				</li>
				</ul>
				</a>
			</dt>
			<dd id="list<?=$Num?>" style="display:none;">
				<p>
				<span>[質問内容]</span><br />
				<?=$row[contents]?>
				</p>
				<h4>
				<?if($row[original_no] == 1){?>
				<span class="blue">A</span>
				&nbsp;[回答内容] &nbsp;&nbsp;&nbsp;<?=substr($row[modify_date],0,10)?>
				</h4>
				<p>
				<?=$row[reply_content]?>
				</p>
				<?}?>
			</dd>
			<?
					$Num--;
					}
				}
				?>
			</dl>
			<div class="btn_extension_b"><a href="/member/?tab=12&tabs=6&mode=write"><img src="/images/member/btn_write.gif" style="cursor:pointer"/></a></div>
		</div>		<!--	/article	-->
	</div>		<!--	mypg_right	-->
</div>		<!--	mypg_cont	-->
<script>
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';
	}
}
</script>