<?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 uid DESC';
	}

	$url_tail = "&tab=$tab&tabs=$tabs&key=$key&order_by=$order_by&LK=$LK&sort=$sort";
	$CoWhere .="AND (d_regis > '201401010000' or orderstep != 6)";


	if(!$key_word) {
		$query_limit  = "limit $offset,$show_one_page";
	}
	//echo "SELECT count(*) FROM shop_order where mbruid = '$sessionIDX' $where $CoWhere $order_by";
	$total_count  = get_db("SELECT count(*) FROM shop_order where mbruid = '$sessionIDX' $where $CoWhere $order_by");

	$QUERY_PAGE  = "SELECT *,(select name from shop_product where uid =goodsuid) as goodsuidname FROM shop_order where  mbruid = '$sessionIDX' $where $CoWhere $order_by";

		//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 class="mypg_center"></div>
	<div class="mypg_right">
		<div class="article2">		<!--	article area	-->
			<h3>GOODS ORDER LIST</h3><br/>
			<table width="100%" border="0" cellpadding="1" cellspacing="2">
				<tr height="30" align="center" bgcolor="E5EDF5">
					<td>予約番号</td>
					<td width="32%">商品名</td>
					<td>決済額</td>
					<td>注文日付</td>
					<td width="100">状態/情報</td>

				</tr>
				<?
				if(!$total){
					echo "<tr><td colspan=5 style='padding:10px'>登録された情報がございません</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);
						$created = substr($row[d_regis],0,4)."-".substr($row[d_regis],4,2)."-".substr($row[d_regis],6,2);
						$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" :
								if($row[goodsuid] == "46" || $row[goodsuid] == "58"){
								$flag1 = "<font color='#FF0099'>入金完了</font><br/><a href='/store/store_receipt.html?orderid=$row[orderid]' target='_blank'>[領収証]</a>";
								}else{
								$flag1 = "<font color='#FF0099'>入金完了</font>"; //입금완료
								}
								break;
							case "3" :
								if($row[goodsuid] == "46" || $row[goodsuid] == "58"){
								$flag1 = "<font color='#9933FF'>配送準備</font><br/><a href='/store/store_receipt.html?orderid=$row[orderid]' target='_blank'>[領収証]</a>";
								}else{
								$flag1 = "<font color='#9933FF'>配送準備</font>"; //배송준비
								}
								break;
							case "4" :
								if($row[goodsuid] == "46" || $row[goodsuid] == "58"){
								$flag1 = "<font color='#F25745'>商品発送</font><br/><a href='/store/store_receipt.html?orderid=$row[orderid]' target='_blank'>[領収証]</a>";
								}else{
								$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 height="30" align="center" bgcolor="ffffff">
					<td width='170'><a href="javascript:chklist('<?=$Num?>');"><span style="color:#c00"><?=$row[orderid]?></span><br><br>
					<?=$row[goodsuidname]?><br><br>
					</a></td>

					<td align="left" style="padding-left:5px;">

					<?while($rows=mysql_fetch_array($resub)){?>
					<?=$rows[goodsname]?>(<?=$rows[buynum]?>個)<br/>
					<?}?></td>
					<td><?=number_format($row[price])?>円</td>
					<td><?=$created?></td>
					<td><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">
						<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">
									<tr>
										<td width="60">・予約番号</td>
										<td width="4">：</td>
										<td><span style="color:#c00"><?=$row[orderid]?></span></td>
									</tr>
									<tr>
										<td>・ 銀 行 名</td>
										<td width="6">：</td>
										<td>株式会社三菱UFJ銀行</td>
									</tr>
									<tr>
										<td>・ 支 店 名</td>
										<td width="6">：</td>
										<td>世田谷支店（店番:130）</td>
									</tr>
									<tr>
										<td>・口座番号</td>
										<td width="6">：</td>
										<td>（普通）0053199</td>
									</tr>
									<tr>
										<td>・預金者名</td>
										<td width="6">：</td>
										<td>㈱ルック・コリア・ジャパン</td>
									</tr>
									<tr>
										<td>・ 入 金 額</td>
										<td width="6">：</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] == 30){?>
							<table width="290" border="0" >
								<tr>
									<td width="290">現地受領
									<?if($row[orderstep] == 2){?>
									: &nbsp;領収書を印刷する→
									<a href='/store/store_receipt.html?orderid=$row[orderid]' target='_blank'>[領収証]</a>
									<?}?>
									<td>
								</tr>
							</table>
								<?}else{?>
							<table width="100%" border="0" >
								<tr>
									<td width="70">・ 受 取 人</td>
									<td width="5">：</td>
									<td><?=$row[r_name]?></td>
								</tr>
								<tr>
									<td>・郵便番号</td>
									<td>：</td>
									<td><?=$row[r_zip]?></td>
								</tr>
								<tr>
									<td>・住　　所</td>
									<td>：</td>
									<td><?=$row[r_addr]?></td>
								</tr>
								<tr>
									<td>・電話番号</td>
									<td>：</td>
									<td><?=$row[r_tel]?></td>
								</tr>
								<tr>
									<td>・メ　　モ</td>
									<td>：</td>
									<td><?=$row[memo]?></td>
								</tr>
								<tr>
									<td>・電子メール</td>
									<td>：</td>
									<td><?=$row[o_email]?></td>
								</tr>
							</table>
							<?}?>
							</td>
						</tr>
					</table>
					</td>
				</tr>
				<?
					$Num--;
					}
				}
				?>
				<tr>
					<td colspan="5" bgcolor="efefef" 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>

						<!--状態/情報는 주문접수 -> '입금완료' -> '배송준비' -> '상품발송' -> '배송완료' 로 이루어 집니다.<br/>
						[예약번호]를 클릭하시면 결제정보와 배송정보를 확인하실 수 있으며 주문취소/교환요청/환불요청은 QnA 게시판을 이용해 주세요. <br/>
						<font color=red>* 입금자명은 꼭 예약번호로 해주세요.</font>(빠른 '입금완료'로 처리 됩니다.)<br/>
						상품발송 후에는 환불이 안됩니다.<br/>
						<br/-->

					</td>
				</tr>
			</table>
		</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>