<?php
include "func.cgi";//発注実績閲覧6402b.php（日付指定）
myopen();

//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();

//１ページ数
$pageset = 50;

//納品ステータス
$codedata5 = dbselect("cname,code","`".$company."code`","codekind = 5","code",-1);
//オプション
$codedata104 = dbselect("cname,code","`".$company."code`","codekind = 104 and code > 0","codeid",-1);

//レコードの指定
if ($_POST[pagenum] == "") {
	$page = 1;
} else {
	$page = (int)$_POST[pagenum];
}

//データ取得数
$limit = " LIMIT ".($pageset*($page  - 1)).",$pageset";

$strsql = "";
//検索処理
$sw = trim(mb_convert_kana($_POST[searchword],'KV'));  //全て全角へ変換
if ($sw<>"") {
	$strsqlsw = " AND searchword like '%".$sw."%'";
}

//納品先の絞込み
//ブランド
if($userdata[brand] <> "") {
	$whereselectin = "SELECT distinct shozokuid FROM `".$company."shozokumaster` WHERE brand in (".$userdata["brand"].")";
	$strsqlshozoku = dbselectin($whereselectin," and main.shozokuid in ");
	$tenpodata = dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster` as main","1=1".$strsqlshozoku,"shozokuid",-1);
}

$tenpodataAll = $tenpodata;
//納品先コードの設定
if ($userdata["kengen"] == 50) {
	$strsqltenpo = " AND main.shozokuid='".$userdata["shozokuid"]."'";
	$shozokuid = $userdata["shozokuid"];
	$tenpodata =dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster`","shozokuid = '".$shozokuid."'",-1,-1);
} elseif ($_POST[shop]<>"") {
	$shop = $_POST[shop];
	$strsqlshop = "search like '%".$shop."%'"; 
	$tenpodata2 = dbselect("shozokuname,shozokuid,gyotaiid,centerid","`".$company."shozokumaster` as main",$strsqlshop.$strsql20,"shozokuid",-1);
Testecho($strsqldbselect);
	$strsqlshop = " and ".$strsqlshop;
	if (sizeof($tenpodata2) == 1) {
		$shozokuid = $tenpodata2[0][1];
		$strsqltenpo = " AND main.shozokuid='".$shozokuid."'";
	} elseif(sizeof($tenpodata2) == 0) {
		$shozokuid = "";
		$tenpodata = array(array("該当データありません",""));
	} else {
		$shozokuid = "";
		$tenpodata = $tenpodata2 ;
	}
} elseif($_POST[tenpo]<>"") {
	$shozokuid = $_POST[tenpo];
	$strsqltenpo = " AND main.shozokuid='".$shozokuid."'";
//	$shozokuid = "";
}

//区分の指定
if($_POST[gyotai]<>"") {
	$strsqlgyotai  = " AND main.gyotaiid='$_POST[gyotai]'";
}
//ブランド
$strsqlgyotai  .= $strsqlshozoku;

//納品
if ($_POST[startdate]<>""){
	$strsqldate  = " and main.deliverdate >= '".$_POST[startdate]."'";
	$strsqldate .= " and main.deliverdate <= '".$_POST[enddate]."'";
	$startdate = $_POST[startdate]; $enddate = $_POST[enddate];
} else {
	$startdate = date("Y-m-d");
	$enddate = date("Y-m-d",strtotime ("6 day"));
	$strsqldate  = " and main.deliverdate >= '".$startdate."'";
	$strsqldate .= " and main.deliverdate <= '".$enddate."'";
}
//並び順
$strsqlorder = " order by os.shozokuid,os.deliverdate desc ,os.shohincd";

//受注データ
/*$strsql="SELECT main.ordermainid,sheet.shohincd,sheet.orderqty,sheet.orderid_flg ,main.checkedflg,main.inputdatetime,main.centerid,main.gyotaiid,main.shozokuid,sheet.memo,shu.shukkaqty 
FROM (`".$company."ordermain` AS main inner join `".$company."ordersheet` AS sheet 
USING(ordermainid) ) LEFT JOIN `".$company."salesdetail` AS sde on (shu.orderid = sheet.orderid)
WHERE 1 = 1 ".$strsqltenpo.$strsqlcenter.$strsqlgyotai.$strsqldate." GROUP BY sheet.orderid";*/

$strsql="SELECT main.deliverdate,main.ordermainid,sheet.shohincd,sheet.orderqty,sheet.orderid,main.checkedflg,main.shozokuid,sheet.memo,sheet.memo2,shu.shukkaqty ,shu.price_piece,shu.price_piece3,shu.price_total,shu.price_total3,sheet.orderprice,'' as memo3,shu.totalgram,shu.shukkaid,shu.memoadd 
FROM ((`".$company."ordermain` AS main inner join `".$company."ordersheet` AS sheet 
USING(ordermainid) ) LEFT JOIN `".$company."shukka` AS shu on (shu.orderid = sheet.orderid))
WHERE 1 = 1 ".$strsqltenpo.$strsqlcenter.$strsqlgyotai.$strsqldate.$strsql20." GROUP BY sheet.orderid,shukkaid
UNION
SELECT deliverdate,0,shohincd,0,orderid,0,shozokuid,memo,memo2,shukkaqty,price_piece,price_piece3,price_total,price_total3,cominprice_piece,memo3,totalgram,shukkaid,memoadd 
FROM `".$company."shukka` as main 
WHERE orderid = 0 ".$strsqltenpo.$strsqlcenter.$strsqlgyotai.$strsqldate.$strsql20."
";
$strsql = "SELECT os.* ,sm.makercode,sm.shohinmei,sm.kikaku,sm.shohin_string2  FROM `".$company."shohinmaster` as sm ,($strsql) as os WHERE sm.shohincd=os.shohincd ".$strsqlsw.$strsqlmaker." ".$strsqlorder;
Testecho ($strsql);
//ダウンロード
if ($_POST[disp2] <>""){
	if ($userdata["kengen"]>=20) {
		$strdate = Sjis("発注".date("Ymd-Gi").".csv");
	} else {
		$strdate = Sjis("受注".date("Ymd-Gi").".csv");
	} 
	header("Content-type: application/octet-stream");
	header("Content-Disposition: attachment; filename=$strdate");
	header("Connection: close");
	ob_end_clean();

	echo Sjis("No,\"納品先\",\"商品コード\",\"商品名\",\"発注数\",\"納品数\",\"納品日\",\"特記\",\"重量\",\"単価\",\"小計\",\"加工単価\",\"加工小計\",\"合計\"")."\n";
	#データ取得
	$result=@mysql_query($strsql,$my_con);
	$i=1;

	while ($data = mysql_fetch_array($result)) {
		echo $i.",";
	//	echo Sprint(GetList($centerdata,$data[centerid]));
		echo Sprint($data[shozokuid]." ".GetList($tenpodataAll,$data[shozokuid]));
		echo Sprint($data["shohincd"]);
		if($data["shohincd"] == "0") {
			echo Sprint($data["memo3"]); 
		} else {
			echo Sprint($data["shohinmei"]);
		}
		echo Sprint($data["orderqty"]);
		echo Sprint($data["shukkaqty"]);
		echo Sprint($data["deliverdate"]);
		echo Sprint(str_replace("<br>","",$data["memo"].$data["memoadd"].GetList($codedata104,$data["memo2"],0)));
		if($data["totalgram"] >0) {
			echo Sprint($data["totalgram"]);
		} else {
			echo Sprint(''); 
		}
		echo Sprint($data["price_piece"]);
		echo Sprint($data["price_total"]);
		echo Sprint($data["price_piece3"]);
		echo Sprint($data["price_total3"]);
		echo Sprint($data["price_total"] + $data["price_total3"]);
		echo "\n";
		$i++;
	}
	myclose();
	exit;
}
//納品作業日の特定
if($userdata["hacchutime"] == 0) {
	//00:00は必ず当日
	$deliverdate = 1;
} elseif($userdata["hacchutime"] <= (int)date("Gi")) {
	//締め時間を過ぎている時は翌日
	$deliverdate = 1;
} else {
	//締め時間前は当日
	$deliverdate = 0;
}
//カートの情報取得（カート内分、発注確定分）
$cartdata["cart"] = dbselect("count(distinct(cart.ordercartid)),sum(cart.cartqty),sum(ss.nohinprice * cart.cartqty)","`".$company."shohinmaster` AS sm INNER JOIN `".$company."ordercart` AS cart USING(shohincd),`".$company."shozokushohin` AS ss","ss.shozokuid = cart.shozokuid and cartflg = 0 and ss.shohincd = cart.shohincd and cart.deliverdate >=DATE_ADD(CURDATE(),INTERVAL $deliverdate DAY) and cart.shozokuid= '".$userdata[shozokuid]."' ",-1,1);
Testecho($strsqldbselect);
$cartdata["kakutei"] = dbselect("count(distinct(cart.ordercartid)),sum(cart.cartqty),sum(ss.nohinprice * cart.cartqty)","`".$company."shohinmaster` AS sm INNER JOIN `".$company."ordercart` AS cart USING(shohincd),`".$company."shozokushohin` AS ss","ss.shozokuid = cart.shozokuid and cartflg = 1 and ss.shohincd = cart.shohincd and cart.deliverdate >= DATE_ADD(CURDATE(),INTERVAL $deliverdate DAY) and cart.shozokuid= '".$userdata[shozokuid]."'",-1,1);
Testecho($strsqldbselect);

if ($userdata["kengen"]>20) {$title= "発注閲覧";} else {$title=  "受注閲覧";} 
$result=@mysql_query($strsql,$my_con);
$maxrow=@mysql_num_rows($result);
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.margin50 {
	width: 160px;
	FONT-SIZE: 12px;
	margin-left :8px;
	margin-right :8px;
}
.margin20 {
	width: 70px;
	FONT-SIZE: 12px;
	margin-left :20px;
	margin-right :0px;
}
.font12{
	font-size: 12px;
}
.border1 {/*グローバルナビゲーションボタン*/
	height: 70px;
	width:740px;
}
<?php
	if($smartphone == 2) {
?>
SELECT {
	FONT-SIZE: 18px;
	margin:5px;
}
.box1 {
	FONT-SIZE: 18px;
	margin:5px;
}
.margin50 {
	width: 200px;
	FONT-SIZE: 18px;
	margin:2px;
}
<?php
}
?>
-->
</style>	
<title>発注システム</title>
</head>
<script type="text/javascript" src="js/jquery-132.js"></script>
<script type="text/JavaScript" src="js/backToTop.js"></script>
<SCRIPT LANGUAGE="JavaScript">
<!--

function submitForm( page ,order ) {
  form = document.FormGetSubmit
  form.pagenum.value= page
  form.order.value= order
  FormGetSubmit.submit()
}
function submitALL2() {
  form = document.sww
  sww.submit()
}
-->
</SCRIPT>
<body>
<table cellpadding=0 margin=0 width="740"><tr><td width="270"><a href="6400b.php"><img src="images/fishtitle.gif" border=0></a></td><td align="right"><span class="font12"><?php echo $userdata["shozokuname"]." ".$userdata["name"];   ?></span><input type="button" onClick="location.href='index.php?logout=0100'" value="ログアウト" name="button" class="margin50"></td></tr><tr><td colspan="2"><img src="images/titleline.gif" border=0 width="920"></td></tr></table>
<DIV class="pagetitleipad">
<form action="6401b.php#fragment-4" method="post" name="edit1" target="_top" style="margin: 0px;" >
<input type="hidden" name="tenpo" value="<?php echo $shozokuid; //納品先 ?>">
<input type="hidden" name="mode" value="">
	<input type="button" onClick="location.href='6400b.php'" value="商品を追加する" name="button" class="margin50" <?php if(!(FunctionUseCheck("6400b"))) echo "disabled";?>>
	<input type="button" name="showcart"  onclick="document.edit1.mode.value = 2;document.edit1.submit();buttondisabled1();" value="カートを見る<?php if($cartdata["cart"][0][0] > 0) {echo "(".$cartdata["cart"][0][0]."点)"; } ?>"  class="margin50" <?php if((!(FunctionUseCheck("6401b"))) or ($cartdata["cart"][0][0] == 0)) {echo "*disabled"; } ?>>
	<input type="button" name="editorder" onclick="document.edit1.mode.value = 1;document.edit1.submit();buttondisabled1();" value="発注の確認・訂正<?php if($cartdata["kakutei"][0][0] > 0) {echo "(".$cartdata["kakutei"][0][0]."点)"; } ?>"class="margin50" <?php if(!(FunctionUseCheck("6400b"))) {echo "disabled"; } ?>>
	
	<input type="button" onClick="location.href='6402b.php'" value="注文実績閲覧" name="button" class="margin50" disabled>

	</DIV>
</form>

<div class="border1">
<form action="6402b.php#fragment-4" method="post" name="sww" target="_top">
<?php InputItem(2,1,-1,2,2,$shozokuid,1); //納品先 ?>
<!--	<span class="border1box">
	ブランド<br>
	<select name="brand" onchange="document.sww.Submit.disabled=true;submitALL2();return false;">
	<?php PrintSelectList($list,$_POST[brand],0); ?>
	</select>
	</span>
-->
	<span class="border1box">
<?php 
	//セレクトリスト（開始日）
	PrintSelectDay5(IntervalDay(-5,1,2),2,"startdate",$startdate,"納品日（期間指定）<br>",-1);
	?>
 ～ 
<?php 
	//セレクトリスト（終了日）
	PrintSelectDay5(IntervalDay(-5,1,2),12,"enddate",$enddate,"",-1);
?>
	</span>
<?php showSearchbox($sw,1,-1); //商品検索 ?>
<?php showSearchBotton(-1,-1,-1); //検索ボタン ?>
	<span class="border1box">
	<br>
	<input type="submit" name="disp2" value="ダウンロード" class="margin50" <?php if($maxrow == 0) echo "disabled"; ?>>
	</span>
</form>
</div>
<div class="floatclear">&nbsp;</div><br><br>
<?php 
//１ページ分
$strsql .= $limit;
$result=@mysql_query($strsql,$my_con);

ShowNavBar2($maxrow,$pageset,$page,"500",1);
if ($maxrow == 0) {
	//start NG
	PrintMsg("","この条件での該当データはありませんでした。",700);
} else {
?>
<div class="floatclear">&nbsp;<br></div>
<table id="data-table">
<tr>
<th>#</th>
<?php 
//カラム行
$rows = mysql_num_fields($result);
//タイトル行の表示
//タイトルを自動で出す場合
//for ($i=0;$i<$rows;$i++) {
//	echo "<td class=\"border3\">".mysql_field_name($result, $i)."</td>\n";
//}
?>
<th>納品日</th>
<th>納品先</th>
<th>商品コード</th>
<th>商品名</th>
<th>発注数</th>
<th>発注単位</th>
<th>納品数</th>
<th>重量</th>
<th>価格単位</th>
<th>注文単価</th>
<th>単価</th>
<th>小計</th>
<th>加工単価</th>
<th>加工小計</th>
<th>合計</th>
<th>オプション</th>
<th>特記</th>
<?php
	Testecho3("主ID",3);
	Testecho3("明細ID",3);
	Testecho3("納品ID",3);
?>
</tr>
<?php 

	$j = $pageset*($page  - 1);
	while ($data = mysql_fetch_array($result)) {
?>
<tr> 
	<td><?php echo ($j+1);// ?></td>
	<td><?php echo $data["deliverdate"]; ?></td>
	<td><?php echo $data[shozokuid]." "; PrintList($tenpodataAll,$data[shozokuid],0); ?></td>
	<td><?php echo $data["shohincd"]; ?></td>
	<td><?php if($data["shohincd"] == "0") {echo $data["memo3"]; } else {echo $data["shohinmei"]; } ?></td>
	<td class="rt"><?php echo number_format($data["orderqty"],1); ?></td>
	<td><?php echo $data["kikaku"]; ?></td>
	<td class="rt"><?php if( $data["shukkaqty"] == "") { echo "0"; } else { echo $data["shukkaqty"];} ?></td>
	<td class="rt"><?php if($data["totalgram"] > 0) { echo number_format($data["totalgram"],2) ; } ?></td>
	<td><?php echo $data["shohin_string2"]; ?></td>
	<td class="rt"><?php echo number_format($data["orderprice"],0) ; ?></td>
	<td class="rt"><?php echo number_format($data["price_piece"],0) ; ?></td>
	<td class="rt"><?php echo number_format($data["price_total"],0) ; ?></td>
	<td class="rt"><?php echo number_format($data["price_piece3"],0) ; ?></td>
	<td class="rt"><?php echo number_format($data["price_total3"],0) ; ?></td>
	<td class="rt"><?php echo number_format($data["price_total"] + $data["price_total3"],0) ; ?></td>
	<td><?php echo PrintList($codedata104,$data["memo2"],0); ?></td>
	<td><?php echo nl2br(htmlspecialchars($data["memo"].$data["memoadd"])); ?></td>
<?php
	Testecho3($data["ordermainid"],2);
	Testecho3($data["orderid"],2);
	Testecho3($data["shukkaid"],2);
?>
</tr>
<?php 
		$j++;
	}
}
?>

	</table>
<div class="floatclear">&nbsp;</div>

<?php 
	ShowNavBar2($maxrow,$pageset,$page,"500",1);
?>
<br>

<FORM METHOD="POST" name="FormGetSubmit" action="6402b.php#fragment-4">
<INPUT type="hidden" name="page"        value="">
<INPUT type="hidden" name="disp"        value="page">
<input type="hidden" name="maker" value="<?php echo $_POST[maker]; //サプライヤー ?>">
<input type="hidden" name="center" value="<?php echo $_POST[center]; //センター ?>">
<input type="hidden" name="gyotai" value="<?php echo $_POST[gyotai]; //区分 ?>">
<input type="hidden" name="tenpo" value="<?php echo $_POST[tenpo]; //納品先 ?>">
<INPUT type="hidden" name="order"                value="">
<INPUT type="hidden" name="pagenum"                value="">
<INPUT type="hidden" name="searchword"          value="<?php echo $sw; //検索語 ?>">
<INPUT type="hidden" name="startdate"              value="<?php echo $startdate; //開始日?>">
<INPUT type="hidden" name="enddate"              value="<?php echo $enddate; //終了日?>">
<input type="hidden" name="type" value="<?php echo $zaikotype; //在庫型 ?>"><br>
</DIV>
</FORM><?php// Menu4($_SERVER['PHP_SELF']); ?>
<p><a href="#titletop" onclick="backToTop(); return false" id="noprintarea">▲このページの先頭へ</a>
<?php 
if ($userdata["kengen"] <40) {
?><p><input type="button" onClick="location.href='0100.php'" value="管理画面へ" name="button" class="box1">
<?php
}
//Menu4($_SERVER['PHP_SELF']); ?>
</body>
</html>
<?php 
Function Sprint($str) {
	echo "\"".Sjis($str)."\",";
}
myclose();
Testecho($strsql);
?>