<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";?>
<script type="text/javascript" src="./js/Calendar_x.js"></script>
<link href="/admin/css/order.css" type="text/css" rel="stylesheet" />
<div id="main"><script type="text/JavaScript">
function goPage(page)
{
	var f = document.form;
	f.page.value = page;
	f.action = '/admin/site_management/Calculate.asp';
	f.submit();
}

function searchChk() {
	//검색
	document.form.action = "<?=$php_self?>";
	document.form.submit();
}
</script>

<script src="/share/js/formcheck.js" type="text/javascript"></script>
<script type="text/javascript">
function go_Downxls() {
	var f = document.form;
	f.action = 'down_xls.asp';
	f.submit();
}
</script>
<?
	// =============================================== Query
	$tableName = "product";

	if(!$pageCount) $pageCount = 5;

	$show_one_page			= $pageCount;
	$show_view_page			= 10;

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

	if($key_word) {
		$key_word = str_replace(" ","",$key_word);
		$where = "AND $key LIKE '%$key_word%'";
	}

	if($flag ==0){
		$where3 = "and orderstep not in(6,7,8)";
		$where2 = "and b.orderstep not in(6,7,8)";
		$titleName = "전체";
	}else if($flag ==2){
		$where3 = "and orderstep in (2,3,4,5)";
		$where2 = "and b.orderstep in (2,3,4,5)";
		$titleName = "입금완료";
	}else{
		$where3 = "and orderstep='1'";
		$where2 = "and b.orderstep='1'";
		$titleName = "주문접수";
	}
	if($goodsproduct){
			$where .=" and uid ='$goodsproduct' ";
	}
	if($start_date && $end_date){
		$where2 .=" and b.d_bank >='$start_date' and  b.d_bank <='$end_date'";
	}

 if($GOODS_IDX == 16) $where .= "AND uid in (95)";
 else if($GOODS_IDX == 17) $where .= "AND uid in (96)";
 else if($GOODS_IDX == 18) $where .= "AND uid in (97)";
 else if($GOODS_IDX == 19) $where .= "AND uid in (98)";
 else if($GOODS_IDX == 20) $where .= "AND uid in (99)";

	$order_by = ' ORDER BY uid DESC';
	$url_tail = "&act=$act&tabs=$tabs&key=$key&order_by=$order_by";

	$query_limit  = "limit $offset,$show_one_page";

	$QUERY_TOTAL = "SELECT count(*) FROM shop_product where 1=1 $where $order_by";
	$QUERY_PAGE  = "SELECT * FROM shop_product where 1=1 $where $order_by $query_limit";

	$total_count  = get_db($QUERY_TOTAL);
	$Num = $total_count - $offset;
	$total_page   = ceil( $total_count / $show_one_page);
	$start_num    = $total_count - $offset;  //
	$viewlist2     = ( !$total_count ) ? "" : Get_viewpage2($page,$total_count,$show_one_page,$show_view_page,$url_tail);

	$result= mysql_query($QUERY_PAGE,$db_con);
	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	$total = mysql_affected_rows();

	?>



<div id="contents">
	<h2>정산관리 <?=$titleName?></h2>
	<!-- Search -->
	<div class="search">
		<fieldset>
			<p>
				<form name="form" method="post" target="_self" onsubmit="return false;" >
				<select name='goodsproduct'>
					<option value=''>전체</option>
					<?
					$QUERY_product  = "SELECT uid,addinfo FROM shop_product order by uid desc";
					$results= mysql_query($QUERY_product,$db_con);
						while($array=mysql_fetch_array($results)){
					?>
					<option value='<?=$array[uid]?>' <?if($goodsproduct == $array[uid]){ echo "selected";}?>><?=$array[addinfo]?></option>
					<?
						}
					?>
				</select>
				<select name='flag'>
					<option value='0' <?if($flag == '0'){ echo "selected";}?>>전체</option>
					<option value='1' <?if($flag == '1'){ echo "selected";}?>>주문접수</option>
					<option value='2' <?if($flag == '2'){ echo "selected";}?>>입금완료</option>
				</select>
				<!--추가 날짜 선택-->
				<input type="text" name="start_date" size="17" value="<?echo $start_date?>" onclick="createCalendarDiv(document.all.start_date)">
				~
				<input type="text" name="end_date" size="17" value="<?echo $end_date?>" onclick="createCalendarDiv(document.all.end_date)">
				<!--추가 날짜 선택-->

				<input type="submit" value="검색" onclick="javascript:searchChk();" />
				</form>
				<!--input type="text" name="startDT" class="startdate" value="2012-11-12" />
				~
				<input type="text" name="endDT" class="enddate" value="2012-11-12" />

				<input type="button" value="Download Excel" class="btn-blue" onclick="go_Downxls();"-->
				<!--div>* 먼저 기간으로 검색을 하신 후 원하는 자료일 경우 다운로드 버튼을 클릭해 주십시요.</div>
				<div>* KCP 자료를 기준으로 산출한 내용이 아니므로 KCP와 오차가 발생할 수 있습니다.</div-->
			</p>
		</fieldset>
	</div>

	<table cellspacing="0" class="list">
		<thead>
			<tr >
				<th>상품</th>
				<th>가격(￥)</th>
				<!--<th>총수량</th>-->
				<th>수량</th>
				<!--<th>재고</th>-->
				<th>상품수익(￥)</th>
				<th>배송비(￥)</th>
				<th>총매출(￥)</th>
				<th>총매출(₩*rate)</th>
				<th>rate</th>
			</tr>
		</thead>
		<tbody>
<?
		if(!$total){
		//echo "<tr><td colspan='$colsNum' align=center height=50px>등록된 정보가 없습니다.</td></tr>";
		echo "<tr><td colspan='8' align=center height=50px>登録された情報がございませ</td></tr>";
	}else{
		for($i=0; $i<$total; $i++) {
			$row = mysql_fetch_array($result);

			if($row[shop_rate]){
				$shop_rate =	$row[shop_rate];
			}else{
				$shop_rate ="10.85";
			}
			//$sunprice = $rows[sumprice] - $rows[tackprice];
			$QUERY_PAGE  = "SELECT * FROM shop_product_opt  where product_prt = '$row[uid]' order by uid ";
			$resub= mysql_query($QUERY_PAGE,$db_con);
			$totals = mysql_affected_rows();
			if($totals == 0){
				$resub = Get_dbres("select sum(a.price) as sumprice,sum(b.buynum) as sumbuynum,sum(a.tack) as tackprice from shop_order as a  join shop_ordergoods as b on a.uid = b.parent where b.goodsuid='$row[uid]'and a.mbruid !=0 $where2");
				$rows	= mysql_fetch_array($resub);
				$goodsSumPrice = $row[price] * $rows[sumbuynum];


				$wonprice = $rows[sumprice] *$shop_rate;
?>
			<tr>
				<td style="text-align:left;padding-left:20px;"><?=$row[name]?></td>
				<td><?=number_format($row[price])?></td>
				<!--<td><?=number_format($row[amount])?></td>-->
				<td><?=number_format($rows[sumbuynum])?></td>
				<td><?=number_format($goodsSumPrice)?></td>
				<td><?=number_format($rows[tackprice])?></td>
				<td><?=number_format($rows[sumprice])?></td>
				<td><?=number_format($wonprice)?></td>
				<td><?=$shop_rate?></td>
			</tr>
<?
			$sumprice_total = $rows[sumprice] + $sumprice_total;
			$wonprice_total = $wonprice+ $wonprice_total;
			$Num--;
			}else{
				$k=0;
				$tmpsumprice_1 =0;
				while($rows1=mysql_fetch_array($resub))
				{

					if($start_date && $end_date){
						//echo "select sum(b.buynum) as sumbuynum from shop_order as a join shop_ordergoods as b on a.uid=b.parent where 1=1 $where2 and b.goodsuid='$row[uid]'and b.options ='$rows1[uid]' and a.mbruid !=0";
							$sumbuynum = Get_db("select sum(b.buynum) as sumbuynum from shop_order as a join shop_ordergoods as b on a.uid=b.parent where 1=1 $where2 and b.goodsuid='$row[uid]'and b.options ='$rows1[uid]' and a.mbruid !=0");
						}else{
							$sumbuynum = Get_db("select sum(buynum) as sumbuynum from shop_ordergoods where options ='$rows1[uid]' and mbruid !=0 $where3");
							if($rows1[uid] == 97 && $flag != 1) $sumbuynum = $sumbuynum -13;
						}


					//4000장 줄임 전체,입금완료일때 줄임
					if ($row[uid]	 == 86 && $flag!=1) {
						$sumbuynum = $sumbuynum-4000;
						$where3 .= "and mbruid not like '%2%'";
					}

					$goodsSumPrice = $rows1[optPrice] * $sumbuynum;
					$tmpsumprice_1 = $tmpsumprice_1+$goodsSumPrice;




					if($k==$totals-1){
						$sumtack = Get_db("SELECT sum(tack) FROM `shop_order` WHERE goodsuid='$row[uid]' and mbruid !=0 $where3");
						$tmptackprice = $sumtack;
						$tmpsumprice = $tmpsumprice_1+$tmptackprice;
						$tmpwonprice = $tmpsumprice *$shop_rate;
					}else{

						$tmptackprice = 0;
						$tmpsumprice= 0;
						$tmpwonprice = 0;
						//$shop_rate ="";
					}



					if($rows1[display]==1){
						$tmpbgColor ="background-color:#B2CCFF;";
					}else{
						$tmpbgColor ="";
					}
					$jego = $rows1[amount]-$sumbuynum;
?>
			<tr >
				<td  style="text-align:left;padding-left:20px;<?=$tmpbgColor?>"><?=$rows1[optName]?></td>
				<td><?=number_format($rows1[optPrice])?></td>
				<!--<td><?=number_format($rows1[amount])?></td>-->
				<td><?=number_format($sumbuynum)?></td>
				<!--<td><?=number_format($jego)?></td>-->
				<td><?=number_format($goodsSumPrice)?></td>
				<td><?=number_format($tmptackprice)?></td>
				<td><?=number_format($tmpsumprice)?></td>
				<td><?=number_format($tmpwonprice)?></td>
				<td><?=$shop_rate?></td>
			</tr>
<?
				$sumprice_total = $goodsSumPrice + $sumprice_total;
				$wonprice_total = $tmpwonprice+ $wonprice_total;
				$k++;
				}
			}
		}
	}
?>
			<tr>
				<td>합계</td>
				<!--<td></td>-->
				<td></td>
				<td></td>
				<td>￥ <?=number_format($sumprice_total)?></td>
				<td></td>
				<td></td>
				<td>₩ <?=number_format($wonprice_total)?></td>
				<td></td>
			</tr>




		</tbody>
	</table>
 <div class="page_list">
		<!--  prev/next_std -->
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
</div>
<!-- footer -->
</div>
</div>
</body>
</html>