<?php
include "func.cgi";//発注実績閲覧6202.php
myopen();

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

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

//出荷ステータス
$codedata5 = dbselect("cname,code","`".$company."code`","codekind = 5","code",-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."%'";
	$strsqlshohin = "SELECT shohincd FROM `".$company."shohinmaster` WHERE searchword like '%".$sw."%'";
	$strsqlshohin2 = dbselectin($strsqlshohin,"sheet.shohincd in ");
} else {
	$strsqlshohin2 = " 1 = 1 ";
}
//納品先の絞込み
$tenpodata2 = $tenpodata;
//納品先コードの設定
if ($userdata["kengen"] == 50) {
	$strsqltenpo = " AND main.shozokuid='".$userdata["shozokuid"]."'";
	$shozokuid = $userdata["shozokuid"];
} elseif ($_POST[shop]<>"") {
	$shop = $_POST[shop];
	$strsqlshop = "search like '%".$shop."%'"; 
	$tenpodata = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`",$strsqlshop,"shozokuid",-1);
	if (sizeof($tenpodata) == 1) {
		$shozokuid = $tenpodata[0][1];
		$strsqltenpo = " AND main.shozokuid='".$shozokuid."'";
	}
} elseif($_POST[tenpo]<>"") {
	$shozokuid = $_POST[tenpo];
	$strsqltenpo = " AND main.shozokuid='".$shozokuid."'";
//	$shozokuid = "";
}
if($company == "cool_") {
	if(substr($userdata["tid"],0,1) == "K") {
		$strsql2 =" and main.shozokuid > 5000 ";
		$tenpodata = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`","shozokuid > 5000","shozokuid",-1);
	 }elseif(substr($userdata["tid"],0,1) == "A") {
		$strsql2 = " and main.shozokuid < 2000 ";
		$tenpodata = dbselect("shozokuname,shozokuid","`".$company."shozokumaster`","shozokuid < 2000","shozokuid",-1);
	}
}

//サプライヤーコード
if ($userdata["kengen"] == 40) {
	$strsqlmaker = " AND sm.makercode='".$userdata["companyid"]."'";
} elseif($_POST[maker]<>"") {
	$strsqlmaker = " AND sm.makercode='$_POST[maker]'";
}

//センターコード
if ($userdata["kengen"] == 30) {
	$strsqlcenter = " AND main.centerid='".$userdata["companyid"]."'";
} elseif($_POST[center]<>"") {
	$strsqlcenter = " AND main.centerid='$_POST[center]'";
}

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

//発注日
if ($_POST[startdate]<>""){
	$strsqldate  = " and main.inputdatetime >= '$_POST[startdate] 00:00:00'";
	$strsqldate .= " and main.inputdatetime <= '$_POST[enddate] 23:59:59'";
	$startdate = $_POST[startdate]; $enddate = $_POST[enddate];
} else {
	$startdate = date("Y-m-d");
	$enddate = date("Y-m-d");
	$strsqldate  = " and main.inputdatetime >= '".$startdate." 00:00:00'";
	$strsqldate .= " and main.inputdatetime <= '".$enddate." 23:59:59'";
}
//並び順
$strsqlorder = " order by os.centerid,os.shozokuid,os.inputdatetime 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,sde.shukkaqty 
FROM (`".$company."ordermain` AS main inner join `".$company."ordersheet` AS sheet 
USING(ordermainid) ) LEFT JOIN `".$company."salesdetail` AS sde on (sde.orderid = sheet.orderid)
WHERE 1 = 1 ".$strsqltenpo.$strsqlcenter.$strsqlgyotai.$strsqldate." GROUP BY sheet.orderid";*/

$strsql="SELECT main.ordermainid,sheet.shohincd,sheet.orderqty,sheet.orderid,sheet.orderid_flg ,main.checkedflg,main.inputdatetime,main.centerid,main.gyotaiid,main.shozokuid,sheet.memo,sheet.memo2,sde.shukkaqty ,sheet.staffid,staff.staff_name ,sheet.creater 
FROM ((`".$company."ordermain` AS main inner join `".$company."ordersheet` AS sheet 
USING(ordermainid) ) LEFT JOIN `".$company."salesdetail` AS sde on (sde.orderid = sheet.orderid))
 LEFT JOIN `".$company."staff` AS staff on (sheet.staffid = staff.staffid)
WHERE ".$strsqlshohin2.$strsqltenpo.$strsqlcenter.$strsqlgyotai.$strsqldate.$strsql2." GROUP BY sheet.orderid";

$strsql = "SELECT os.shohincd,os.orderqty,os.shukkaqty,checkedflg,os.inputdatetime,os.centerid,os.gyotaiid,os.shozokuid,sm.makercode,sm.shohinmei,sm.nisugata,os.memo,os.memo2,os.orderid,os.orderid_flg,os.staffid,os.staff_name,os.ordermainid,os.creater  FROM `".$company."shohinmaster` as sm ,($strsql) as os WHERE sm.shohincd=os.shohincd ".$strsqlmaker." ".$strsqlorder;
//ダウンロード
if ($_POST[dl3] <>""){
	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");
	header("Cache-Control: public");
	header("Pragma: public");
	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($tenpodata2,$data[shozokuid]));
		echo Sprint(GetList($makerdata,$data[makercode]));
		echo Sprint($data["shohincd"]);
		echo Sprint($data["shohinmei"]);
		echo Sprint((int)$data["orderqty"]);
		if((floor($data["orderid_flg"] / 10) == 2) or ($data["orderid_flg"] > 32)) {
			echo Sprint((int)$data["shukkaqty"]);
		} else {
			echo ",";
		}
		if(((floor($data["orderid_flg"] / 10) == 2) or ($data["orderid_flg"] > 32)) and ((int)$data["orderqty"] > (int)$data["shukkaqty"])) {
			echo Sprint((int)$data["orderqty"] - (int)$data["shukkaqty"]);
		} else {
			echo Sprint("");
		}

		echo Sprint(strftime("%G-%m-%d",strtotime($data[inputdatetime])));
		echo Sprint($data["memo"]);
		echo Sprint($data["orderid_flg"].".".GetList($codedata5,$data["orderid_flg"],0));
		echo Sprint(str_replace("<br>","",$data["memo"].$data["memo2"]));
		echo Sprint(GetList($userlist,$data["creater"]));
		echo "\n";
		$i++;
	}
	myclose();
	exit;
}

if ($userdata["kengen"]>20) {$title= "発注閲覧";} else {$title=  "受注閲覧";} 
$result=@mysql_query($strsql,$my_con);
$maxrow=@mysql_num_rows($result);
//店舗以外のユーザーリスト
$userlist = dbselect("name,tid","usermaster as um INNER JOIN userrole as ur USING(tid) WHERE roleid in(1,2,3,4,5,6,8,10,11)",-1,"tid",-1);
$tenpodata = $tenpodata2;
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link href="css.css" rel="stylesheet" type="text/css">
<?php title(); ?>
</head>
<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>
<?php Honbutitle3("$title",$_SERVER['PHP_SELF']); ?>
<div class="border1">
<form action="6202.php#fragment-4" method="post" name="sww" target="_top">
<?php InputItem(2,1,-1,2,2,$shozokuid,1); //納品先 ?>
	<form action="6312.php#fragment-4" method="post" name="sww" target="_top">
<!--	<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),1,"startdate",$startdate,"発注日（期間指定）<br>",-1);
	?>
 ～ 
<?php 
	//セレクトリスト（終了日）
	PrintSelectDay5(IntervalDay(-5,1,2),1,"enddate",$enddate,"",-1);
?>
	</span>
<?php showSearchbox($sw,1,-1); //商品検索 ?>
<?php showSearchBotton(-1,-1,-1); //検索ボタン ?>
	<span class="border1box">
	<br>
	<input type="submit" name="dl3" value="ダウンロード" class="box1a" <?php if($maxrow == 0) echo "disabled"; ?>>
	</span>
</form>
</div>
<?php 
//１ページ分
$strsql .= $limit;
$result=@mysql_query($strsql,$my_con);

ShowNavBar2($maxrow,$pageset,$page,"500",1);
if ($maxrow == 0) {
	//start NG
	PrintMsg("","この条件での該当データはありませんでした。",700);
} else {
?>
<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>
<?php if ($userdata["kengen"] <> 50) { ?>
<th>サプライヤー</th>
<?php } ?>
<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);
?>
</tr>
<?php 

	$j = $pageset*($page  - 1);
	while ($data = mysql_fetch_array($result)) {
?>
<tr> 
	<td><?php echo ($j+1);// ?></td>
	<td><?php PrintList($tenpodata2,$data[shozokuid],0); ?></td>
<?php if ($userdata["kengen"] <> 50) { ?>
	<td><?php PrintList($makerdata,$data[makercode],0); ?></td>
<?php } ?>
	<td><?php echo $data["shohincd"]; ?></td>
	<td><?php echo $data["shohinmei"]; ?></td>
	<td class="rt"><?php echo number_format((int)$data["orderqty"]); ?></td>
	<td class="rt"><?php if((floor($data["orderid_flg"] / 10) == 2) or ($data["orderid_flg"] > 32)) {echo (int)$data["shukkaqty"];} ?></td>
	<td><?php echo $data["nisugata"]; ?></td>
	<td><?php echo $data["inputdatetime"]; ?></td>
	<td><?php echo $data["memo"]; ?></td>
	<td class="rt">
<?php 
		if(((floor($data["orderid_flg"] / 10) == 2) or ($data["orderid_flg"] > 32)) and ((int)$data["orderqty"] > (int)$data["shukkaqty"])) {
			echo ((int)$data["orderqty"] - (int)$data["shukkaqty"]);
		} 
?>
	</td>
	<td>
<?php 
		echo $data["orderid_flg"]." ";
		PrintList($codedata5,$data["orderid_flg"],0);
		echo $data["memo2"]." ";
?>
	<td><?php echo GetList($userlist,$data["creater"]); ?></td>
<?php
	Testecho3($data["ordermainid"],2);
	Testecho3($data["orderid"],2);
?>
</tr>
<?php 
		$j++;
	}
}
?>

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

<FORM METHOD="POST" name="FormGetSubmit" action="6202.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']); ?>
</body>
</html>
<?php 
Function Sprint($str) {
	echo "\"".Sjis($str)."\",";
}
myclose();
Testecho($strsql);
?>