<?php

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

	//$PAGE_GUBUN =	"";

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

?>

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

<div id="sub_content_box">
<?include"./inc_mypage_tab.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)."%' ";
				}
			}
		$where .="and goodsuid !=1";

			if($tabs == 2){
				$order_by = ' ORDER BY member_code desc ,m_startdate DESC';
			}else{
				$order_by = ' ORDER BY uid DESC';
			}

			$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 shop_order where mbruid = '$sessionIDX' $where $CoWhere $order_by");
			$QUERY_PAGE  = "SELECT * FROM shop_order where  mbruid = '$sessionIDX' $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();
		?>


			<!--	article area	-->
			<table width="100%" class="basic_table">
   	<colgroup>
    	<col width="15%"  />
    	<col width="50%"  />
    	<col width="15%"  />
    	<col width="10%"  />
    	<col width="10%"  />
    </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">状態/情報</td>
     </tr>
    </thead>
    </tbody>
				<?
				if(!$total){
					echo "<tr><td colspan=5 style='padding:10px' align='center'>登録された情報がございません</dt>";
				}else{
					for($i=0; $i<$total_count; $i++) {
						$Num = $start_num - $i;
						$row = mysql_fetch_array($result);
						$created = substr($row[d_regis ],0,10);
						$reqry = "select * from shop_ordergoods where mbruid = '$sessionIDX' and parent='$row[uid]'";
						$resub= mysql_query($reqry,$db_con);
						//$resub = Get_dbres("select * from shop_ordergoods where mbruid = '$sessionIDX' and parent='$row[uid]'");
						//$rows	= mysql_fetch_array($resub);

						switch($row[orderstep]) {
							case "1" :
								$flag1 = "<font color='#FF9966'>注文受付</font>"; //주문접수
								break;
							case "2" :
								//$flag1 = "<font color='#FF0099'>入金完了</font><br/><br/><a href='/html_store/store_receipt.html?orderid=$row[orderid]' target='_blank'>[領収証]</a>"; //입금완료
								$flag1 = "<font color='#FF0099'>入金完了</font>";
								break;
							case "3" :
								$flag1 = "<font color='#9933FF'>配送準備</font>"; //배송준비
								break;
							case "4" :
								$flag1 = "<font color='#F25745'>商品発送</font>"; //상품발송
								break;
							case "5" :
								$flag1 = "<font color='#F25745'>配送完了</font>"; //배송완료
								break;
							case "6" :
								$flag1 = "<font color='#929292'>注文取り消し</font>"; //주문취소
								break;
							case "7" :
								$flag1 = "<font color='#929292'>払い戻し要請</font>"; //환불요청
								break;
							case "8" :
								$flag1 = "<font color='#929292'>払い戻し完了</font>"; //환불완료
								break;
						}
				?>

				<tr>
					<td class="ls"><a href="javascript:chklist('<?=$Num?>');"><?=$row[orderid]?></a></td>
					<td class="ls_le">
					<?while($rows=mysql_fetch_array($resub)){?>
					<?=$rows[goodsname]?>(<?=$rows[buynum]?>個)<br/>
					<?}?></td>
					<td class="ls"><?=number_format($row[price])?>円</td>
					<td class="ls"><?=$created?></td>
					<td class="ls"><b><?=$flag1?></b></td>
				</tr>
				</a>
				<tr id="list<?=$Num?>" style="display:none;"  >
					<td colspan="5">

     	<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="e5e5e5">
       <colgroup>
        <col width="50%" />
        <col width="50%" />
       </colgroup>
       <tr>
        <td width="50%">決済情報</td>
        <td>受取人情報</td>
       </tr>
							<tr bgcolor="f3f3f3">
								<td align="left" style="line-height:18px;">

   						<table width="100%" border="0" cellspacing="0" cellpadding="0">
										<colgroup>
          	<col width="30%" />
          	<col width="70%" />
          </colgroup>
          <tr>
           <td>・予約番号</td>
           <td><span style="color:#c00"><?=$row[orderid]?></span></td>
          </tr>

									<tr>
										<td>・NAME</td>
										<td><span style="color:#c00"><?=$row[o_name]?></span></td>
									</tr>

									<tr>
										<td>・銀行名</td>
										<td>三菱東京UFJ銀行</td>
									</tr>
									<tr>
										<td>・支店名</td>
										<td>世田谷支店（店番:130）</td>
									</tr>
									<tr>
										<td>・口座番号</td>
										<td>(普通) 0027348</td>
									</tr>
									<tr>
										<td>・預金者名</td>
										<td>(株)ルック・コリア・ジャパン</td>
									</tr>
									<tr>
										<td>・ 入 金 額</td>
										<td><span style="color:#c00"><?=number_format($row[price])?></span>円</td>
									</tr>
								</table>

							</td>
							<td align="left" style="padding:2px;">

 							<?if($row[tack] == 0 && $row[goodsuid] == 1){?>
									<table width="290" border="0" >
          <tr>
           <td width="290">現地受領 <td>
          </tr>
         </table>
							<?}else{?>

								<table width="100%" border="0" >
         <colgroup>
          <col width="30%" />
          <col width="70%" />
         </colgroup>
									<tr>
									<td>・受取人</td>
									<td><?=$row[r_name]?></td>
								</tr>
								<tr>
									<td>・郵便番号</td>
									<td><?=$row[r_zip]?></td>
								</tr>
								<tr>
									<td>・住所</td>
									<td><?=$row[r_addr]?></td>
								</tr>
								<tr>
									<td>・電話番号</td>
									<td><?=$row[r_tel]?></td>
								</tr>
								<tr>
									<td>・メモ</td>
									<td><?=$row[memo]?></td>
								</tr>
								<tr>
									<td>・電子メール</td>
									<td><?=$row[o_email]?></td>
								</tr>
							</table>
							<?}?>

							</td>
						</tr>
					</table>
					</td>
				</tr>
				<?
					$Num--;
					}
				}
				?>
				<tr>
					<td colspan="5" align="left" style="padding:20px;">
						<h2>* ご注文案内</h2>
						<p style="margin:6px 0 0 0; line-height:18px;">
						状態/情報は「注文受付」⇒「入金完了」⇒「配送準備」⇒「商品発送」⇒「配送完了」となります。<br />
					「予約番号」をクリックすると決済情報や受領人情報がご確認頂けます。<br />
					ご注文の取り消し・交換・払い戻しのお申込はQ&A掲示板をご利用下さい。<br />
					<span style="color:#C00">入金者名（ご依頼人名）は必ず予約番号でご入力下さい。</span>(ご入金の確認が速やかに処理できる為)<br />
					ご入金期限を過ぎたご予約は中止とさせて頂きますので予めご了承くださいませ。<br />
					ご予約番号をクリックするとお振込先の確認が可能です。<br />
					ご入金後の商品内容の変更、追加はご遠慮ください。<br />
					</p>
					</td>
				</tr>
    </tbody>
			</table>


<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';
	}
}

var type="";
function fade(div_id) {
	if(type == "On") {
		$('#'+div_id).fadeOut('slow');
		type="";
	}else{
		$('#'+div_id).fadeIn('slow');
		type="On";
	}
}
function fade2(div_id) {
	if(type == "On") {
		$('#'+div_id).fadeOut('slow');
		type="";
	}else{
		$('#'+div_id).fadeIn('slow');
		type="On";
	}
}

//var getState= parent.divframe.document.getElementById("player").PlayState;
</SCRIPT>

</div>
<?
  include"inc_footer.php";
?>

</body>
</html>