<?php //在庫推移
if ($_POST[dl] ==""){
	header('pragma: no-cache');
	header("Cache-Control: no-cache, must-revalidate");
}
include "func.cgi";
myopen();
//再チェック
SecurityCheck();
PostData();

//センターコード
//センター権限の時はそのセンターを使用する。
//センター権限以外の時は指定された使用センターを使用する。
$strsql = "honbuid = '".$userdata["honbuid"]."'";
if ($userdata["kengen"] == 30) {  //10Tradex,20本部、30センター、40サプライヤー、50納品先
	$strsqlcenter = " and centerid = '".$userdata["companyid"]."'";
	$center_code = $userdata["companyid"];
} elseif ($_POST[center]<>"") {
	$strsqlcenter = " and centerid = '$_POST[center]'";
	$center_code = $_POST[center];
}

//検索用語のＷＨＥＲＥ句
if ($_POST[searchword]<>"") {
	//$strsqljoin = " and sm.searchword like '%".$sw."%'";
	$sw = Eucjp($_POST[searchword]);
	$sw = mb_convert_kana($sw,'KV', "UTF-8");  //全て全角へ変換
	$strsqljoin = " searchword like '%".$sw."%'";
} else {
	$strsqljoin = " 1=1 ";
}

if ($userdata["kengen"] == 40) {  //10Tradex,20本部、30センター、40サプライヤー、50納品先
//	$strsql = "SELECT shohincd FROM `".$company."shohinmaster` WHERE makercode ='".$userdata["companyid"]."'";
//	$strsqlmaker = dbselectin($strsql,"and shohincd in ");
	//商品リスト
	$shohindata = dbselect("shohinmei,shohincd","`".$company."shohinmaster`","makercode='".$userdata["companyid"]."' and ".$strsqljoin,"shohincd",-1);
} else {
	$shohindata = dbselect("shohinmei,shohincd","`".$company."shohinmaster`",$strsqljoin,"shohincd",-1);
}
if(sizeof($shohindata)==0){
//	商品が無しの場合
	if ($userdata["kengen"] == 40) {  //10Tradex,20本部、30センター、40サプライヤー、50納品先
		//商品リスト
		$shohindata = dbselect("shohinmei,shohincd","`".$company."shohinmaster`","makercode='".$userdata["companyid"]."'","shohincd",-1);
	} else {
		$shohindata = dbselect("shohinmei,shohincd","`".$company."shohinmaster`",-1,"shohincd",-1);
	}
}

//商品コードのＷＨＥＲＥ句
$shohincd="'".$_POST[shohincd]."'";

//最初の在庫
$tanadata = dbselect("DATE_FORMAT(tanahisdate,'%Y-%m-%d'),tanahistoryid","`".$company."tanahistory`","tanahisdate >='".date("2012-01-10")."' ".$strsqlcenter,"tanahisdate",-1);
$zaikodata = dbselect("sum(stockqty)","`".$company."tana`","shohincd= $shohincd  and tanahistoryid='".$tanadata[0][1]."' ".$strsqlcenter." GROUP BY shohincd",-1,-1);
Testecho("初期在庫". $zaikodata[0][0]);//debug
$startdate = "DATE_ADD('".$tanadata[0][0]."',INTERVAL 1 DAY)";

//年月リスト
$monthlist = dbselect("distinct(date_format(date,'%Y年%m月')),date_format(date,'%Y-%m-01')","calendar","date between ".$startdate." AND CURDATE()","1",-1);
if($_POST[monthrange]=="") {
	$monthrange = $monthlist[(sizeof($monthlist)-1)][1];
} else {
	$monthrange = $_POST[monthrange];
}
//リストを取り出す
//在庫テーブル、センターマスタ、商品マスタ
//出荷判定ＯＫ，本部指定、


//入荷
$strsql0 = "SELECT * from (SELECT * FROM calendar as ca WHERE ca.date  between ".$startdate." and CURDATE())  as ca 
LEFT JOIN  (select shohincd, sum(comeinfixqty) as comeinqty ,kakuteidate from `".$company."comeinfix` 
WHERE shohincd = $shohincd $strsqlmaker $strsqlcenter GROUP BY kakuteidate,shohincd) AS d1 
ON  ca.date=d1.kakuteidate order by ca.date";


//出荷確定
$strsql1 = "SELECT * from (SELECT * FROM calendar as ca WHERE ca.date  between ".$startdate." and CURDATE())  as ca 
LEFT JOIN  (select shohincd, sum(shukkaqty) as shukkaqty ,operatedate from `".$company."shukka` where shukkaflg>=3 and shohincd = $shohincd $strsqlmaker $strsqlcenter GROUP BY operatedate,shohincd ) AS d1 ON  ca.date=d1.operatedate order by ca.date";

//調整
$strsql2 = "SELECT * from (SELECT * FROM calendar as ca WHERE ca.date  between ".$startdate." and CURDATE())  as ca 
LEFT JOIN  (select shohincd, sum(arrangeqty) as arrangeqty ,arrangedate from `".$company."stockarrange` WHERE stockarrangeflg>0 AND shohincd = $shohincd $strsqlmaker $strsqlcenter GROUP BY arrangedate ,shohincd ) AS d1 ON  ca.date=d1.arrangedate order by ca.date";

//出荷停止
$strsql4 = "SELECT * from (SELECT * FROM calendar as ca WHERE ca.date  between ".$startdate." and CURDATE())  as ca 
LEFT JOIN  (select shohincd, sum(stockqty) as stockqty ,stopdate from `".$company."stockdata` WHERE validflg=2 AND shohincd = $shohincd $strsqlmaker $strsqlcenter GROUP BY stopdate ,shohincd) AS d1 ON  ca.date=d1.stopdate order by ca.date";

//移動出荷
$strsql6 = "SELECT * from (SELECT * FROM calendar as ca WHERE ca.date  between ".$startdate." and CURDATE())  as ca 
LEFT JOIN  (select shohincd, sum(transqty) as transqty ,transdate from `".$company."transdata` WHERE transflg>0 AND shohincd = $shohincd $strsqlmaker $strsqlcenter GROUP BY transdate ,shohincd) AS d1 ON  ca.date=d1.transdate order by ca.date";

//マスタ
$strsql3 = "SELECT shohinmei,shohincd from `".$company."shohinmaster` WHERE shohincd=$shohincd $strsqlmaker";

Testecho( $strsql0);//debug
Testecho( $strsql1);//debug
Testecho( $strsql2);//debug
Testecho( $strsql3);//debug
Testecho( $strsql4);//debug
Testecho( $strsql6);//debug

$result0=@mysql_query($strsql0,$my_con);
mysql_sql_log2($strsql0,$_SERVER['SCRIPT_NAME'].":".__LINE__);
$result1=@mysql_query($strsql1,$my_con);
mysql_sql_log2($strsql1,$_SERVER['SCRIPT_NAME'].":".__LINE__);
$result2=@mysql_query($strsql2,$my_con);
mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__);
$result3=@mysql_query($strsql3,$my_con);
mysql_sql_log2($strsql3,$_SERVER['SCRIPT_NAME'].":".__LINE__);
$result4=@mysql_query($strsql4,$my_con);
mysql_sql_log2($strsql4,$_SERVER['SCRIPT_NAME'].":".__LINE__);
$result6=@mysql_query($strsql6,$my_con);
mysql_sql_log2($strsql6,$_SERVER['SCRIPT_NAME'].":".__LINE__);

$data3=@mysql_fetch_array($result3);

if ($_POST[dl] <>""){
	$strdate = Sjis("在庫閲覧日別データ".$data3["shohincd"].$data3["shohinmei"].date("Y-m-d").".csv");
	header("Content-type: application/octet-stream");
	header("Content-Disposition: attachment; filename=$strdate");
	header("Connection: close");
	ob_end_clean();
	#データ取得
	Sprint("在庫閲覧日別データ");
	Sprint($data3["shohincd"]);
	Sprint($data3["shohinmei"]);
	echo date("Y/m/d G:i")."\n";

	Sprint("日付");
	Sprint("前日在庫");
	Sprint("入庫数(+)");
	Sprint("出荷数(-)");
	Sprint("調整数(-)");
	Sprint("移動数(-)");
	Sprint("停止数(-)");
	Sprint("当日末在庫");
	echo "\n";

	$zan = (int)$zaikodata[0][0];
	while ($data0=@mysql_fetch_array($result0)) {
		$data1=@mysql_fetch_array($result1);
		$data2=@mysql_fetch_array($result2);
		$data4=@mysql_fetch_array($result4);
		echo $data0["date"].","; //日付
		echo $zan.",";
		echo (int)$data0["comeinqty"];  $zan += (int)$data0["comeinqty"];//入庫
		echo ",";
		echo (int)$data1["shukkaqty"];  $zan -= (int)$data1["shukkaqty"];//出荷
		echo ",";
		echo (int)$data2["arrangeqty"]; $zan += (int)$data2["arrangeqty"];//調整数
		echo ",";
		echo (int)$data6["transqty"]; $zan -= (int)$data6["transqty"];//移動数
		echo ",";
		echo (int)$data4["stockqty"]; $zan -= (int)$data4["stockqty"];//出荷停止数
		echo ",";
		echo $zan; //調整後数
		echo "\n";
	}
	myclose();
	die;
}

?><html>
<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 openNewWindowB(cd) {
  form = document.FormDetailSubmit
  form.targetdate.value= cd
  FormDetailSubmit.submit()
}
-->
</SCRIPT>
<BODY leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="focus()">
<?php Honbutitle3("在庫推移（日別）",$_SERVER['PHP_SELF']); ?>
<div class="border1">
<form action="0406.php#fragment-3" method="post" name="codechange" target="_top">
		<?php if ($userdata["kengen"] <> 30) { ?>
		<span class="border1box2">
		<select name="center" onChange="window.document.codechange.submit();">
		<?  PrintSelectList($centerdata,$_POST[center],0); ?>
		</select>
		</span>
		<?php } ?>
		<span class="border1box2">
			<input type=text size="10" maxlength="20"  name="searchword" value="" onChange="window.document.codechange.shohincd.value=null;window.document.codechange.submit();">
		</span>
		<span class="border1box2">
		<select name="shohincd" onChange="window.document.codechange.submit();">
		<?php if($_POST[shohincd]=="") { ?><option value="xx">選択してください</option><?php } ?>
		<?php  PrintSelectList2($shohindata,$_POST[shohincd],0); ?>
		</select>
		</span>
		<span class="border1box2">
		<select name="monthrange" onChange="window.document.codechange.submit();">
		<?php  PrintSelectList($monthlist,$monthrange,0); ?>
		</select>
		</span>
		<span class="border1box2">
		<input type="submit" name="dl" value="ダウンロード" class="box1" <?php if($_POST[shohincd]=="") { echo "disabled"; } ?>>
		</span>
</form>
<form action="3000.php#fragment-3" method="post" name="3000back" target="_top">
		<span class="border1box2">
		<INPUT type="hidden" name="pagenum"        value="<? echo $_POST[pagenum]; // ?>">
		<INPUT type="hidden" name="order"          value="">
		<INPUT type="hidden" name="center"     value="<? echo $_POST[center]; // ?>">
		<INPUT type="hidden" name="searchword"     value="<? echo $_POST[searchword]; //検索語 ?>">
		<INPUT type="hidden" name="zaikotype"     value="<? echo $_POST[zaikotype]; //在庫有り ?>">
		<input type="submit" value="在庫一覧へ戻る" name="3000" class="box1">
		</span>
</form>
</div>
<?php if($_POST[shohincd]<>"") { ?>
<table id="data-table">
<tr> 
	<th>日付</th>
	<th>前日在庫</th>
	<th>入庫数(+)</th>
	<th>出荷数(-)</th>
	<th>調整数(+)</th>
	<th>移動数(-)</th>
	<th>停止数(-)</th>
	<th>当日末在庫</th>
</tr>
<?php 
$zan = (int)$zaikodata[0][0];$counti=0;
while ($data0=@mysql_fetch_array($result0)) {
	$data1=@mysql_fetch_array($result1);
	$data2=@mysql_fetch_array($result2);
	$data4=@mysql_fetch_array($result4);
	$data6=@mysql_fetch_array($result6);

		if(($data0["date"]<$monthrange) or ($counti>31)) {
			$zan += (int)$data0["comeinqty"];//入庫
			$zan -= (int)$data1["shukkaqty"];//出荷 
			$zan += (int)$data2["arrangeqty"];//調整数
			$zan -= (int)$data6["transqty"];//移動出荷数
			$zan -= (int)$data4["stockqty"];//出荷停止
		} else {
?>
	<tr> 
	    <td><a href="#" onClick="openNewWindowB('<? echo $data0["date"]; ?>')"><?php  echo $data0["date"]; //日付 ?></a></td>
	    <td class="rt"><?php  echo $zan; //前日在庫 ?></td>
	    <td class="rt"><?php  echo (int)$data0["comeinqty"];  $zan += (int)$data0["comeinqty"];//入庫 ?></td>
	    <td class="rt"><?php  echo (int)$data1["shukkaqty"];  $zan -= (int)$data1["shukkaqty"];//出荷 ?></td>
	    <td class="rt"><?php  echo (int)$data2["arrangeqty"]; $zan += (int)$data2["arrangeqty"];//調整数 ?></td>
	    <td class="rt"><?php  echo (int)$data6["transqty"];  $zan -= (int)$data6["transqty"];//移動出荷数 ?></td>
	    <td class="rt"><?php  echo (int)$data4["stockqty"];  $zan -= (int)$data4["stockqty"];//出荷停止 ?></td>
	    <td class="rt"><?php echo $zan; //調整後数 ?></td>
	</tr> 
<?php
		$counti++;
	}
}
?>
<tr> 
	<th>日付</td>
	<th>前日在庫</td>
	<th>入庫数(+)</td>
	<th>出荷数(-)</td>
	<th>調整数(+)</td>
	<th>移動数(-)</td>
	<th>停止数(-)</td>
	<th>当日末在庫</td>
</tr>
</table>
<?php } ?>
</DIV>
<FORM METHOD="POST" name="FormDetailSubmit" action="0407.php#fragment-3">
<INPUT type="hidden" name="shohincd"        value="<? echo $_POST[shohincd]; ?>">
<INPUT type="hidden" name="targetdate"        value="">
</FORM>

<?php Menu4($_SERVER['PHP_SELF']); ?>
</body>
</html>
<?php                                      
myclose();
Function Sprint($str) {
	echo "\"".Sjis($str)."\",";
}
Testecho( $strsqla);//debug
Testecho( $strsql);//debug
?>