<?php  //グロス＋種まき帳票 6425.php
/*****************************************************************************
// 2016/05/21
// 関連データベース・テーブル
// 参照：
// 	出荷実績	shukka
// 	受注データ	ordermain,ordersheet
// 	在庫データ	stockdatat
// 	商品マスタ	shohinmaster
// 	場所マスタ company（センター）
// 変更履歴：
---	2016/05/27		Ohyama
---	2016/07/20	修正	同一商品複数サプライヤー対応	Ohyama
---	2017/01/20	修正	全ブラウザ対応	ohyama
---	2017/02/07	修正	ハイブリッド対応	ohyama　shukkaTableにname,customerid追加
---	2017/02/09	修正	ハイブリッド対応	Yoshinaga
---	2017/02/17	更新	個人（カスタマ）の改修	Hayashi&Yoshinaga
---	2017/03/03	更新	物流用商品コードcenter_shohincdと在庫表示変更	Ohyama
*****************************************************************************/

include "func.cgi";
myopen();

//何アイテムで改ページするか
$pagekaigyo = 10;  
//何明細で改ページするか
$pagekaigyo2 = 19;  
//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();

//supplyerid 挿入
$strsql = "UPDATE cool_shukka as a,cool_shohinmaster as sm set a.supplyerid = sm.makercode WHERE a.shohincd=sm.shohincd and a.supplyerid is null and operatedate > DATE_ADD(CURDATE(),INTERVAL -5 DAY)";
$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);

//流通型の条件指定
$strsqlmaker .= "sm.ryutu_type in (";
foreach($_POST[ryutu_type] as $key => $val){
	$strsqlmaker .= $val.",";
}
$strsqlmaker .= "-9)";

//サプライヤーコード
if ($_POST[maker]<>""){
	if($_POST["grouping"] == "1") {
		$strsqlmaker .= " and pg.supplyerid = '$_POST[maker]' ";
	} else {
		$strsqlmaker .= " and pg.supplyerid = '$_POST[maker]' ";
	}
}
if ($userdata["supplyerid2"]<> ""){
	if($_POST["grouping"] == "1") {
		$strsqlmaker .= " and pg.supplyerid in (".$userdata["supplyerid2"].") ";
	} else {
		$strsqlmaker .= " and pg.supplyerid in (".$userdata["supplyerid2"].") ";
	}
}

//温度
if ($_POST[code]<>"") {
	$strsqlmaker .= "and sm.code in(";
	foreach($_POST[code] as $key => $val){
		$strsqlmaker .= $val.",";
	}
	$strsqlmaker .= "-9) ";
}
//物流用商品コード設定　2017/3/3
if($settingdata["center_shohincd"] <> "") {
	$shohincd_get = $settingdata["center_shohincd"];
} else {
	$shohincd_get = "shohincd";
}


//対象データ取得
if ($_POST[picktimes]=="") {
	//ピック指定無し
	$strwhere = " WHERE ";
} elseif($_POST[id] <> "") {
	//引当状況確認からの遷移は緊急分も出す
	$strwhere = " WHERE shu.picktimes IN ('$_POST[picktimes]',99) and ";
} else {
	$strwhere = " WHERE shu.picktimes ='$_POST[picktimes]' and ";
}
$strwhere .= " DC_TC in (0,1) AND shu.operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND shu.centerid='".$_POST[center]."' and shukkaqty>0 ";

//表示順 商品順 ロケーションの最小
$strorder = " ORDER BY sm.ryutu_type,sm.code,pg.supplyerid,loccode,shohincd";

//温度帯データの取得
$codedata = dbselect("substring(cname,1,2),code","`".$company."code`","codekind = '1'","code",-1);
//流通型データの取得
$codedata10 = dbselect("substring(cname,1,2),code","`".$company."code`","codekind = '10'","code",-1);


/*
商品単位 {  //出荷データ、商品情報 $data1
	//賞味期限単位合計は5430.php  出荷データ,出荷合計数 $data2  賞味期限別に集計する必要がある 出荷データはロット別だが、ロットやロケは関係ない
	商品情報＋ピック総量
	納品先別{  //店名、ルート  出荷データ、所属マスタ $data3  出荷データはロット別だが、ロットやロケは関係ない
		納品先別表示
	}
}
*/
//商品単位の出荷データ
$strsql = "SELECT shohincd,supplyerid,shukkaqty,customerid,name,operatedate,shukkadate,deliverdate,picktimes,loccode FROM `".$company."shukka` AS shu ".$strwhere." ";
$strsql ="SELECT sm.ryutu_type,shohincd,shohincd2,shohincd3,sum(shukkaqty) as shukkaqty,pg.supplyerid,min(loccode) as loccode,operatedate,shukkadate,deliverdate,kikaku,irisuu,aisuu,nisugata,centernisugata,shohinmei,code,shomiflg,customerid,name FROM ($strsql) as pg INNER JOIN `".$company."shohinmaster` AS sm USING (shohincd) WHERE ".$strsqlmaker." GROUP BY sm.shohincd,pg.supplyerid ".$strorder;
Testecho ($y." $errcode ".$strsql);  #debug

//サプライヤー
$whereselectin = "SELECT distinct(supplyerid) FROM `".$company."shukka` WHERE DC_TC in (0,1,2) AND operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) ";
$strsqlwhere = dbselectin($whereselectin,"companyid in ");
//$makerdata = dbselect("companyname,companyid","company",$strsqlwhere,-1,-1);
Testecho ($y." $errcode ".$strsqldbselect);  #debug
?><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="report.css">
<link rel="stylesheet" type="text/css" href="reportprint.css" media="print" / >
<style type="text/css">
<!--
.position40{
	position: absolute;
	left :40mm;
}
.position100{
	position: absolute;
	left :100mm;
}
th{
	BORDER:1px solid black;
}
td{
	BORDER:1px solid black;
}
#main td.noline2{
	border-top: 1px solid #000000;
	border-bottom: 1px solid #000000;
	border-right: 0px solid #000000;
	text-align: right;
}
#main td.noline3{
	border-top: 1px solid #000000;
	border-bottom: 1px solid #000000;
	border-left: 0px solid #000000;
	text-align: center;
}
h2 {
	font-size: 18px;
}
h4 {
	font-size: 23px;
}

-->
</style>
<TITLE>LogiGate<?php //echo $systemname; ?> 出力:<?php echo date("Y/m/d",strtotime ("".$_POST[chgday]." day")); ?><?php //echo $_POST[picktimes]."回目"; ?></TITLE>
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
-->
</SCRIPT>
<BODY leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="focus()">

<?php 
if($_POST["maker"] == "") {
//	echo "サプライヤーを指定して下さい。";
//	exit;	
}

//start リストを表示するかどうかdebug時のみ
if ($_COOKIE[testmode]=="1") {
	$result=@mysql_query($strsql,$my_con);
	$errcode =mysql_errno();
Testecho ($y." $errcode ".$strsql);  #debug
mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__);
?>
	<table><tr>
<?php 
	//カラム行
	$rows = mysql_num_fields($result);
	//タイトル行の表示
	echo "<td class=\"border3\">#</td>\n";
	for ($i=0;$i<$rows;$i++) {
		echo "<td".mysql_field_name($result, $i)."</td>\n";
	}
?>
	</tr>
<?php 

	$j = 0;
	while ($data = mysql_fetch_array($result)) {
	?>
	<tr> 
		<td><?php echo ($j+1);// ?></td>
	<?php 
		for ($i=0;$i<$rows;$i++) {
			echo "<td>".$data[$i]."</td>\n";
		}
	?>
	</tr>
	<?php 
		$j++;

} //END 
?>
</table>
------------------------------------------<p>
<?php } //debug時のみ ?><div id="buttonarea">
   <input type="button" value="印刷" onclick="javascript:window.print();" >
   <input type="button" onClick="javascript:window.opener = window;window.close();" value="閉じる" class="box1">
</div><?php 
$chgflg=-1;$line=0;$line2=0;$i=0;$page=1;
$result=@mysql_query($strsql,$my_con);
Testecho ("LINE ".__LINE__." ".$y." ".$strsql);  //debug
mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__);
while ($data = mysql_fetch_array($result)) {

	//line=商品　line2=明細行
	if(($line==$pagekaigyo) or ($line2 > $pagekaigyo2)) {
		//行数が改ページに達していたら
		$page++;
		echo "\t</table>\n</div>\n<div class=\"pagenum\">&nbsp;</div>\n";
		$line=1;
		$line2=1;
	} elseif($i>0) {
		//最初でない
//		$page++;
//		echo "\t</table>\n</div>\n<div class=\"pagenum\">&nbsp;</div>\n";
		$line++;
	} else {
		//行数が改ページに達していない
		$line++;
	}
?>
<?
	if($line==1) {
?>
<div id="container">
	作業日:<?php echo ($data["operatedate"]); // ?>　
	出荷日:<?php echo ($data["shukkadate"]); // ?>　
	納品日:<?php echo ($data["deliverdate"]); // ?>　残在庫表示は<?php echo date("Y-m-d"); // ?>時点
	<div id="header">
		<h6>グロス＋種まきリスト　&nbsp;Page:<?php echo  $page;//PrintList($makerdata,$_POST["maker"],0);//PrintList($codedata,$data["code"],0)."級"; // ?></h6>
	</div>
	<div id="subnav">
		納品日：<?php echo $data["deliverdate"];//echo strftime("%G年%m月%d日 (%a)",strtotime($data["deliverdate"])); ?>
	</div>
	<div id="subnavR">
<?php
		$honbudata = dbselect("companyname,postcode,address1,address2,address3,tel,fax,memo","company","companyid='".$data["supplyerid"]."'",-1,-1);//
?>
				<?php echo $honbudata[0][0]; ?>
			
		<!-- IMG SRC="/images/3box.gif" "印鑑欄" --><br>
	</div>
<?
		echo "<div id=\"main\">\n";	//テーブルヘッダ
		echo "<table>\n";
		echo "<tr>";
		echo "	<th colspan=\"1\" id=\"cell300\">No</th>\n";
		echo "	<th colspan=\"2\" id=\"cell300\">&nbsp;ＣＤ　商品名　ロケーション　【規格】</th>\n";
		echo "	<th colspan=\"1\" id=\"cell300\">数量</th>\n";
		echo "	<th colspan=\"1\" id=\"cell300\">単位</th>\n";
		echo "	<th id=\"cell15\" class=\"cen\"></th>\n";
		echo "</tr>\n";
	}
	//商品ヘッダ
	$line2++;
	$strshohin_head1  = "<tr>\n";
	$stock = dbselect("sum(nonreserveqty),location","`".$company."stockdata`","nonreserveqty > 0 and shohincd ='".$data["shohincd"]."' AND centerid='".$_POST[center]."'",-1,-1);
	if((int)$stock[0][0] > 0) {$st = "<nobr>(残".(int)$stock[0][0].")</nobr>";} else {$st = "<nobr>(-)</nobr>";} 

	$strshohin_head1 .= "	<td colspan=\"1\" id=\"cell10\" class=\"noline\"><h2>".($line)."　</h2></td>\n";
	$strshohin_head1 .= "	<td colspan=\"1\" id=\"cell20\" class=\"noline\"><h2>".$data{$shohincd_get}." [".GetListData($codedata,$data["code"],0)."][".GetListData($codedata10,$data["ryutu_type"],0)."]</h2></td>\n";
	$strshohin_head1 .= "	<td colspan=\"1\" id=\"cell100\" class=\"noline\"><h4>".$data["loccode"]."</h4><h4>".$data["shohinmei"]."【".$data["kikaku"]."】　<font size=1>".GetListData($makerdata,$data["supplyerid"],0)."</h4></td>\n";
	$strshohin_head1 .= "	<td rowspan=\"1\" id=\"cell20\" class=\"noline\"><SPAN class=\"h4\">計 ";
	$strshohin_head1 .= str_replace(".0","",$data["shukkaqty"]);
	$strshohin_head1 .= "	</td>\n";
	$strshohin_head1 .= "	<td colspan=\"2\" id=\"cell30\" class=\"noline\">".$data["nisugata"]."&nbsp;　".$st."</td>\n";
	$strshohin_head1 .= "</tr>\n";

	echo $strshohin_head1;

?>
<?php
	//納品先単位の出荷データ（納品先グロス）
	$strsql3 = "SELECT SUM(shukkaqty) as shukkaqty ,shu.shozokuid,shu.deliveryid,shu.route,shu.memo,shu.memoadd,shu.customerid,shu.name,
case when pay_kubun <> '80'  then 1 else 2 end as code1 FROM `".$company."shukka` AS shu INNER JOIN `".$company."ordermain` AS om USING(ordermainid) ".$strwhere." AND shohincd='".$data["shohincd"]."' AND shu.supplyerid = '".$data["supplyerid"]."' GROUP BY shu.memo,shu.memoadd,shu.shozokuid,shu.customerid ORDER BY code1,shu.shozokuid ,shu.ordermainid ,shu.memo,shu.route";
	$result3=@mysql_query($strsql3,$my_con);
Testecho ("LINE ".__LINE__." ".$y." ".$strsql3);  //debug
mysql_sql_log2($strsql3,$_SERVER['SCRIPT_NAME'].":".__LINE__);

	$cnt = 1;
	while ($data3 = mysql_fetch_array($result3)) {
		$line2++;

		//商品詳細を格納
		$strshohin_detail  ="<tr>\n";
		$strshohin_detail .="<td id=\"cell10\"><nobr><I>".$line."-".$cnt."</I></nobr></td>";
		if ( $data3["shozokuid"] != 0 ) {
$shozokudata = dbselect("shozokuname","`".$company."shozokumaster` ","shozokuid =".$data3[shozokuid],-1,-1);
			$strshohin_detail .="	<td id=\"cell20\" colspan=\"1\" class=\"lt\"><h2>&nbsp;".$data3["shozokuid"]." ".$data3["route"]."</h2></td>";
			$strshohin_detail .="	<td id=\"cell120\" colspan=\"2\" class=\"lt\"><h2>&nbsp;<nobr>".$shozokudata[0][0];
		} else {
			$strshohin_detail .="	<td id=\"cell20\" colspan=\"1\" class=\"lt\"><h2>&nbsp;".$data3["customerid"]."".$data3["route"]."</h2></td>";
			$strshohin_detail .="	<td id=\"cell120\" colspan=\"2\" class=\"lt\"><h2>&nbsp;<nobr>".$data3["name"];
		}
		if($data3["memo"].$data3["memoadd"] <> "") {
			$strshohin_detail .= "【".$data3["memo"].$data3["memoadd"]."】";
		}
		$strshohin_detail .= "</nobr></h4></td>\n";

		$inttotalbara=$data3["shukkaqty"];  //総バラ数

		$strshohin_detail .="	<td id=\"cell15\" class=\"noline2\"><SPAN class=\"h4\">".str_replace(".0","",$inttotalbara)."</SPAN></td><td id=\"cell15\" class=\"noline3\">".$data["nisugata"]."</td>\n";
		$strshohin_detail .="</tr>";

		//商品詳細を出力
		echo $strshohin_detail;
		$cnt++;
	}
	$i++;
}
?>
</table>
</div>

<?php if($i==0) {?>
対象データがありません。抽出条件（温度帯、流通型、バッチ番号（通常は１）、日付を確認ください。）
<?php } else { 
//ステータステーブルをUPDATE
DataUpdate($company."status","statusid",$_POST[id],"tanemakitime","now()");

$strsql = "UPDATE `".$company."status` SET tanemakitime=NOW() WHERE gyotaiid='".$_POST[gyotai]."' AND  operatedate =DATE_ADD(CURDATE(),INTERVAL ".$_POST[chgday]." DAY) AND picktimes='".$_POST[picktimes]."' LIMIT 1";
$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
Testecho ("ステータスデータに実施されました。".$errcode." ".$strsql."\n<br>");  #debug

?>
<div id="buttonarea">
   <input type="button" value="印刷" onclick="javascript:window.print();" />
   <input type="button" onClick="javascript:window.close();" value="閉じる" class="box1">
</div>
<?php } ?>
</body>
</html>
<?php 
myclose();
Testecho($strsql);
?>