<?include "$DOCUMENT_ROOT/conf/conf_dir.php";?>
<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
<?
//상품한번만 살수 있게
$uid = get_db("SELECT A.uid FROM shop_order_photobook A ,shop_ordergoods B WHERE A.uid = B.parent and B.goodsuid='$goodsuid' and A.o_email='$r_email' and A.orderstep < 6");
if($uid) {
	echo"<script>alert('既に予約しました.');location.href='./confirm.php';</script>";
	exit;
}

//$nan_tmp ="M";
if($mode == "order_proc"){
	//예약번호
	$nan = explode(' ',microtime());
	$_cartid = $nan_tmp.$nan[1] . substr($nan[0],2,3);
	// 예약함.
	$orderstep = "1";
	$r_email = trim($r_email);

	//결제체크
	$ckind = "1";
	$bank ="三菱東京UFJ銀行";

	$tmpID = get_db("select max(mbruid) from `shop_order_photobook`")+1;

	$query = "INSERT INTO `shop_order_photobook`
	(`uid`, `orderid`, `orderstep`, `price`, `tack`, `goodsuid`,`mbruid`,
	`o_name`, `o_email`, `o_tel`, `o_zip`, `o_addr`, `r_name`, `r_email`,`r_tel`, `r_zip`, `r_addr`,
	`ckind`, `bank`, `b_name`,`tid`, `escr`,`memo`, `d_regis`, `d_bank`, `d_tack`, `is_mobile`)

		VALUES

	(NULL, '$_cartid', '$orderstep', '$total_price','$deliradio','$goodsuid','$tmpID',
	'$r_name', '$r_email','$r_tel','$r_zip','$r_addr','$r_name', '$r_email','$r_tel', '$r_zip', '$r_addr',
	'$ckind', '$bank', '$b_name','$r_password', '$escr', '$memo','$date[totime]', '', '', '0')";

	$result = mysql_query($query,$db_con);
	//부모 idx 값 가져오기
	$p_idx = get_db("select uid from shop_order_photobook where mbruid='$tmpID' and orderid='$_cartid'");

	if($p_idx)
	{
	//상품등록 나중에 for문으로 등록
	//echo "<br><br>";

			$sub_query = "INSERT INTO `shop_ordergoods_photobook`
			(`uid`, `parent`, `mbruid`, `orderstep`, `goodsuid`, `goodsname`, `options`, `buynum`, `price`,`d_regis`, `d_bank`, `d_tack`)
				VALUES
			(NULL, '$p_idx', '$tmpID', '$orderstep', '1', 'JAE JOONG PHOTO BOOK', '1', '$goods_cnt', '5940','$date[totime]',  '', '')";
		//echo "$sub_query<br>";

		$result = mysql_query($sub_query,$db_con);



	}

mysql_close();
}else{
echo "<script>alert('error.');parent.location.href='/jaejoong_photobook/';</script>";
}


echo "<script>alert('商品注文になりました.');parent.location.href='/jaejoong_photobook/confirm.php?orderNum=$_cartid';</script>";
?>