<?php  //5310.php	ピッキングリスト出力（トータル）
/*****************************************************************************
// 変更履歴：
---	2017/01/20	更新	全ブラウザ対応	Ohyamna
---	2017/02/09	更新	エアアロマ対応	Yoshinaga
---	2017/02/15	更新	個人Customer対応	Hayashi&Yoshinaga
---	2017/03/03	更新	物流用商品コードcenter_shohincdと在庫表示変更	Ohyama
---	2017/06/03	更新	バーコード表示変更	Ohyama
*****************************************************************************
*/
include "func.cgi";
myopen();

//何アイテムで改ページするか
$pagekaigyo = 8;  
//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();
$companydata = dbselect("companyname,companyid","company",-1,-1,-1);

//対象データ取得
if ($_POST[picktimes]=="") {
	//ピック指定無し
	$strwhere = " WHERE ";
} elseif($_POST[id] <> "") {
	//引当状況確認からの遷移は緊急分も出す
	$strwhere = " WHERE picktimes IN ('$_POST[picktimes]',99) and ";
} else {
	$strwhere = " WHERE picktimes ='$_POST[picktimes]' and ";
}
$strwhere .= "operatedate = DATE_ADD( CURDATE() , INTERVAL ".$_POST[chgday]." DAY ) AND centerid='".$_POST[center]."'";

//流通型の条件指定 count_off=1は送料等
$strsqlmaker = " sm.count_off = 0 and sm.ryutu_type in (";
foreach($_POST[ryutu_type] as $key => $val){
	$strsqlmaker .= $val.",";
}
$strsqlmaker .= "-9) ";

//ルート
$strsql = "UPDATE `".$company."shukka` AS shu,`".$company."shozokumaster` AS sho
SET shu.route = sho.route WHERE shu.shozokuid = sho.shozokuid and shu.operatedate = DATE_ADD( CURDATE() , INTERVAL ".$_POST[chgday]." DAY )";
//全数
$result=@mysql_query($strsql,$my_con);
mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
Testecho ($strsql.mysql_affected_rows().$_SERVER['SCRIPT_NAME'].":".__LINE__);

//サプライヤーコード
if ($_POST[maker]<>""){
	$strsqlmaker .= " and shu.supplyerid = '$_POST[maker]' ";
}

//温度
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 ($orderby==2) {
	//商品順
	$strorder = " ORDER BY code,route,shohincd,shomi,waitingflg";
} else {
	//ロケーション順
	$strorder = " ORDER BY code,route,shohincd,shomi,waitingflg";
}
//期限管理
$codedata8 = dbselect("cname,code","`".$company."code`","codekind = 8","code",-1);
//ピッキングデータ
$strsql = "SELECT shohincd,sum(shukkaqty) as shukkaqty,sum(orderqty) as orderqty,supplyerid,shukkadate,operatedate,picktimes,lotnum,shomi,min(zanzaiko) AS zanzaiko,waitingflg,route,count(shukkaid) as CNT  FROM `".$company."shukka` ".$strwhere." group by shohincd,route,supplyerid";
$strsqlnozaiko = "SELECT shohincd,sum(shukkaqty) as shukkaqty,sum(orderqty) as orderqty,shukkadate,operatedate,picktimes,shomi,min(zanzaiko) AS zanzaiko,waitingflg,route FROM `".$company."shukka` ".$strwhere." and orderqty>0 group by shohincd,shomi";


//商品マスタをJOIN
$strsql = "SELECT shohincd,shohincd2,shohincd3,shukkaqty,orderqty,shukkadate,operatedate,shomiflg,kikaku,irisuu,aisuu,nisugata,shohinmei,code,pg.lotnum,pg.supplyerid,pg.shomi,picktimes,zanzaiko,waitingflg,sm.makercode,sm.makercode2,route,pg.CNT  FROM ($strsql) as pg LEFT JOIN `".$company."shohinmaster` AS sm USING (shohincd) WHERE ".$strsqlmaker.$strorder;
$strsqlnozaiko = "SELECT shohincd,shukkaqty,orderqty,shukkadate,operatedate,kikaku,irisuu,aisuu,nisugata,shohinmei,code,pg.shomi,picktimes,zanzaiko,waitingflg,route FROM ($strsqlnozaiko) as pg LEFT JOIN `".$company."shohinmaster` AS sm USING (shohincd) WHERE ".$strsqlmaker.$strorder;

//温度帯データの取得
$codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1);

?><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" / >
<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 
//グロスリスト

//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 class=\"border3\">".mysql_field_name($result, $i)."</td>\n";
	}
?>
	</tr>
<?php 

	$j = $pageset*($page  - 1);
	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=1;$i=0;$maime=0;//$chgflg=-1;$line行数　$iデータ件数
$result=@mysql_query($strsql,$my_con);
$row1=@mysql_num_rows($result);
Testecho ($strsql." ROW=".mysql_affected_rows().$_SERVER['SCRIPT_NAME'].":".__LINE__);
while ($data = mysql_fetch_array($result)) {
	if(($prevcode<>$data["code"]) or ($line==$pagekaigyo) or ($prevroute <> $data[route])) {
		if ($prevcode<>$data["code"]) {
			//改ページから何枚目か
			$maime=1;
			$line=1;
		} elseif ($line==$pagekaigyo) {
			//改ページから何枚目か
			$maime++;
			$line=1;
		} else {
			$maime=1;
		}
		if ($i>0) {
			//格納していた商品ヘッダを出力
			echo $strshohin_head1;
			echo $intshohingross;
			echo $strshohin_head2;

			//商品詳細を出力
			echo $strshohin_detail;
			$intshohingross = "";$strshohin_detail="";$strshohin_head1="";$strshohin_head2="";
			echo "</table></div>\n<div class=\"pagenum\">&nbsp;</div>\n";  //改ページ
		}
?>
<div id="container">
	作業日:<?php echo ($data["operatedate"]); // ?>　
	出荷日:<?php echo ($data["shukkadate"]); // ?>　残在庫表示は<?php echo date("Y-m-d"); // ?>時点
	<div id="header">
	<h6>ピッキングリスト【グロス】  <?php PrintList($makerdata,$_POST["maker"],0);//PrintList($codedata,$data["code"],0)."級"; //温度帯 ?></h6>
	</div>
	<div id="subnavR">
<?php
$no = date("Ymd",strtotime ("".$orderdate." day"))."/".$_POST[center]."/".$data[supplyerid]; //予定日＋センター＋サプライヤー 
//$no = "N$".$data[makercode2]."C$".$data[route]; //荷主＋ROUTE
$no = '12345';
var_dump("変換前:".$no);
$no = mb_strtoupper($no);?>
<?php
var_dump($no);
?>
		<IMG SRC ="bar.php?code=<?php echo $no ; ?>" style='margin:0 8mm 0 3mm;'><br>
		<IMG SRC="/images/3box.gif" style='margin:0 3mm 0 3mm;'><br>
	</div>
	<div id="subnav">
	<h2>温度帯 : <?php PrintList($codedata,$data["code"],0); // ?> <br>
	<h2>荷主 : <?php echo $data["makercode2"].":";PrintList($companydata,$data["makercode2"],0); // ?> <br>
	<h2>ルート : <?php echo $data["route"]; // ?> <br>
	<?php  echo ($data["picktimes"]); // ?>回目<?php  echo "【".$maime."枚目】"; // ?>　<?php PrintList($centerdata,$_POST[center],0); // echo "【".$page."枚目】"; // ?></h2>
	</div>
<?
		echo "<div id=\"main\">\n";	//テーブルヘッダ
		echo "<table>\n";
		echo "<tr>\n";
		echo "	<th colspan=\"2\" id=\"cell110\">&nbsp;商品コード<br>&nbsp;商品名</th>\n";
		echo "	<th colspan=\"3\" id=\"cell30\">規格</th>\n";
		echo "	<th id=\"cell15\" class=\"cen\">数量</th>\n";
		echo "	<th id=\"cell15\">&nbsp;</th>\n";
		echo "</tr>\n";
	} else {
		$line++;
	}

	if(($line==1) or ($prevshohin<>$data["shohincd"])) {
		
		if(($line>1) ) {
			//１行目は出力しない
			//格納していた商品ヘッダを出力
			echo $strshohin_head1;
			echo $intshohingross;;
			echo $strshohin_head2;

			//商品詳細を出力
			echo $strshohin_detail;
			echo "<tr>\n\t<td colspan=\"7\"><HR SiZE=6 noshade color=\"black\"></td></tr>\n";//商品分け区分線
			$intshohingross = "";$strshohin_detail="";$strshohin_head1="";$strshohin_head2="";
		}
		//商品が違ったら格納する
		$strshohin_head1  = "<tr>\n";
		$strshohin_head1 .= "	<td colspan=\"2\" id=\"cell110\" class=\"noline\"><h2>".$data{$shohincd_get}." ".GetListData($makerdata,$data["supplyerid"],0)."&nbsp;&nbsp;&nbsp;<IMG SRC ='bar.php?code=".$data["shohincd"]."&number=no&size=20' align='middle' style='margin:0 2mm 0 2mm;'></h2></td>\n";
		$strshohin_head1 .= "	<td colspan=\"3\" id=\"cell30\" class=\"noline\"><h2>".$data["kikaku"]."　</h2></td>\n";
		$strshohin_head1 .= "	<td rowspan=\"2\" id=\"cell15\" class=\"topcen\"><SPAN class=\"h4\">";

		$strshohin_head2  = "</SPAN>".$data["nisugata"]."</td>\n";
		$strshohin_head2 .= "	<td id=\"cell15\" class=\"noline\">&nbsp;</td>\n";
		$strshohin_head2 .= "</tr>\n";
		$strshohin_head2 .=  "<tr>\n";
		$strshohin_head2 .= "	<td colspan=\"2\" id=\"cell110\" class=\"top\"><h4>".$data["shohinmei"]."　</h4></td>\n";
		$strshohin_head2 .= "	<td colspan=\"3\" id=\"cell30\" class=\"topcen\"><h2>合 [".$data["aisuu"]."] 入 [".$data["irisuu"]."]</h2></td>\n";
		$strshohin_head2 .= "	<td id=\"cell15\" class=\"top\">&nbsp;</td>\n";
		$strshohin_head2 .= "</tr>\n";
		$strshohin_head2 .= "<tr>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">&nbsp;&nbsp;&nbsp;ロケーション</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">".GetList($codedata8,$data["shomiflg"])."</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">合数</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">CS</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">バラ</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">数量</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">残(全在)</th>\n";
		$strshohin_head2 .=  "</tr>\n";
	}
	//出荷総数
	$intshohingross += (int)$data["shukkaqty"] + (int)$data["orderqty"];

	//LOT分離
	$strsql2 = "SELECT loccode,SUM(shukkaqty) as shukkaqty,SUM(orderqty) as orderqty ,shomi,lotnum FROM `".$company."shukka` WHERE 
		shohincd = '".$data["shohincd"]."' and route = '".$data["route"]."' and operatedate = '".$data["operatedate"]."' and picktimes = '".$data["picktimes"]."' 
	GROUP BY lotnum ORDER BY shomi";
	$result2=mysql_query($strsql2,$my_con);
	$row2=@mysql_num_rows($result2);
//		mysql_sql_log($strsql2,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__);
	Testecho ($strsql2.mysql_affected_rows().$_SERVER['SCRIPT_NAME'].":".__LINE__);
	

	//在庫データ全
	$stockdataA = dbselect("SUM(nonreserveqty)","`".$company."stockdata`","centerid='".$_POST[center]."' AND shohincd ='".$data[shohincd]."' GROUP BY shohincd",-1,-1);
	for($ii = 0;$ii < $row2;$ii++){
		$data2=@mysql_fetch_array($result2);
		//商品詳細を格納
		$strshohin_detail .="<tr>\n";
		if($data["loccode"] == "") {
			$strshohin_detail .="	<td id=\"cell40\" class=\"cen\">--</td>\n";
		} else {
			$strshohin_detail .="	<td id=\"cell40\" class=\"cen\"><h4>".$data["loccode"]."<IMG SRC ='bar.php?code=".$data["loccode"]."&number=no&size=20' align='middle' hspace ='12'></h4></td>\n";
		}
		if($data2["shomi"]=="") {
			$strshohin_detail .="	<td id=\"cell70\" class=\"cen\"><h4>&nbsp;</h4>";
		} else {
			$strshohin_detail .="	<td id=\"cell70\" class=\"cen\"><h4>".$data2["shomi"]."</h4><IMG SRC =\"bar.php?code=D$".substr(str_replace("-","",$data2["shomi"]),2,6)."&size=18&number=no\"  style=\"margin:0 2mm 0 2mm; align;middle;\">";
		}
		$inttotalbara=(int)$data2["shukkaqty"] + (int)$data2["orderqty"];  //総バラ数 orderqtyは欠品分のみ
		$intaisuu = floor($inttotalbara / ($data["aisuu"]*$data["irisuu"]));   //合数
		$intcase = floor(($inttotalbara % ($data["aisuu"]*$data["irisuu"])) / $data["irisuu"]);  //ケース
		$intbara = ($inttotalbara % ($data["aisuu"]*$data["irisuu"])) % $data["irisuu"];  //バラ
		if ($intaisuu==0) {$intaisuu="&nbsp;";}
		if ($intcase==0) {$intcase="&nbsp;";}
		if ($intbara==0) {$intbara="&nbsp;";}
		if ($data["aisuu"] == 1) {$intcase = $intaisuu;$intaisuu = ""; }

		//在庫データ
		$stockdata = dbselect("nonreserveqty","`".$company."stockdata`","centerid='".$_POST[center]."' AND shohincd ='".$data[shohincd]."' AND lotnum ='".$data2[lotnum]."'",-1,-1);

		$strshohin_detail .="	<td id=\"cell10\" class=\"cen\"><h4>".$intaisuu."</h2></td>\n";
		$strshohin_detail .="	<td id=\"cell10\" class=\"cen\"><h4>".$intcase."</h2></td>\n";
		$strshohin_detail .="	<td id=\"cell10\" class=\"cen\"><h4>".$intbara."</h2></td>\n";
		$strshohin_detail .="	<td id=\"cell15\" class=\"cen\"><SPAN class=\"h2\">".((int)$data2["shukkaqty"]+ (int)$data2["orderqty"])."</SPAN>".$data["nisugata"]."</td>\n";
		$strshohin_detail .="	<td id=\"cell15\" class=\"cenborder\"><SPAN class=\"h4\">".(int)$stockdata[0][0]."<br>(".(int)$stockdataA[0][0].")"."</SPAN></td>\n";
	//	$strshohin_detail .="	<td id=\"cell15\" class=\"cenborder\"><SPAN class=\"h4\">".$data["zanzaiko"]."</SPAN></td>\n";
	//	$strshohin_detail .="	<td id=\"cell15\" class=\"cenborder\"><SPAN class=\"h4\">".$data["zanzaiko"]."</SPAN>".$data["nisugata"]."</td>\n";
		$strshohin_detail .="</tr>";
	}
	if ($chgflg==1) {
		echo "";
	}
	$prevroute=$data["route"];
	$prevcode=$data["code"];
	$prevshohin=$data["shohincd"].$data["supplyerid"];
	$i++;
}
//格納していた商品ヘッダを出力
echo $strshohin_head1;
echo $intshohingross;
echo $strshohin_head2;

//商品詳細を出力
echo $strshohin_detail;

?>
</table>
</div>
<?php



//入荷待ちのみを再出力

//start リストを表示するかどうかdebug時のみ
if ($_COOKIE[testmode]=="1") {
	$result=@mysql_query($strsqlnozaiko,$my_con);
	$errcode =mysql_errno();
Testecho ("test:".$y." $errcode ".$strsqlnozaiko);  #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 class=\"border3\">".mysql_field_name($result, $i)."</td>\n";
	}
?>
	</tr>
<?php 

	$j = $pageset*($page  - 1);
	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 } 
$chgflg=-1;$line=1;$i=0;$maime=0;//$chgflg=-1;$line行数　$iデータ件数
$intshohingross = "";$strshohin_detail="";$strshohin_head1="";$strshohin_head2="";$prevcode="";
$result=@mysql_query($strsqlnozaiko,$my_con);
$row2=@mysql_num_rows($result);
if ($row2>0) {
echo "<div class=\"pagenum\">&nbsp;&nbsp;</div>";  //
while ($data = mysql_fetch_array($result)) {
	if(($prevcode<>$data["code"]) or ($line==$pagekaigyo)) {
		if ($prevcode<>$data["code"]) {
			//改ページから何枚目か
			$maime=1;
			$line=1;
		} elseif ($line==$pagekaigyo) {
			//改ページから何枚目か
			$maime++;
			$line=1;
		} else {
			$maime=1;
		}
		if ($i>0) {
			//格納していた商品ヘッダを出力
			echo $strshohin_head1;
			echo $intshohingross;
			echo $strshohin_head2;

			//商品詳細を出力
			echo $strshohin_detail;
			$intshohingross = "";$strshohin_detail="";$strshohin_head1="";$strshohin_head2="";
			echo "</table></div>\n<div class=\"pagenum\">&nbsp;&nbsp;</div>\n";  //改ページ
		}
?>
<div id="container">
	作業日:<?php echo ($data["operatedate"]); // ?>　
	出荷日:<?php echo ($data["shukkadate"]); // ?>　
	<div id="header">
	<h6>ピッキングリスト【グロス】【入荷待ち】 <?php //PrintList($codedata,$data["code"],0)."級"; //温度帯 ?></h6>
	</div>
	<div id="subnavR">
		<IMG SRC="/images/3box.gif"><br>
	</div>
	<div id="subnav">
	<h2>温度帯 : <?php PrintList($codedata,$data["code"],0); // ?> <br>
	<?php  echo ($data["picktimes"]); // ?>回目<?php  echo "【".$maime."枚目】"; // ?>　<?php PrintList($centerdata,$_POST[center],0); // echo "【".$page."枚目】"; // ?></h2>	</div>
<?
		echo "<div id=\"main\">\n";	//テーブルヘッダ
		echo "<table>\n";
		echo "<tr>";
		echo "	<th colspan=\"2\" id=\"cell110\">&nbsp;商品コード<br>&nbsp;商品名</th>\n";
		echo "	<th colspan=\"3\" id=\"cell30\">規格</th>\n";
		echo "	<th id=\"cell15\" class=\"cen\">数量</th>\n";
		echo "	<th id=\"cell15\">&nbsp;</th>\n";
		echo "</tr>\n";
	} else {
		$line++;
	}

	if(($line==1) or ($prevshohin<>$data["shohincd"])) {
		
		if(($line>1) ) {
			//１行目は出力しない
			//格納していた商品ヘッダを出力
			echo $strshohin_head1;
			echo $intshohingross;;
			echo $strshohin_head2;

			//商品詳細を出力
			echo $strshohin_detail;
			echo "<tr><td colspan=\"7\"><HR SiZE=6 noshade color=\"black\"></td></tr>\n";//商品分け区分線
			$intshohingross = "";$strshohin_detail="";$strshohin_head1="";$strshohin_head2="";
		}
		//商品が違ったら格納する
		$strshohin_head1  = "<tr>\n";
		$strshohin_head1 .= "	<td colspan=\"2\" id=\"cell110\" class=\"noline\"><h2>".$data["shohincd"]."</h2></td>\n";
		$strshohin_head1 .= "	<td colspan=\"3\" id=\"cell30\" class=\"noline\"><h2>".$data["kikaku"]."　</h2></td>\n";
		$strshohin_head1 .= "	<td rowspan=\"2\" id=\"cell15\" class=\"topcen\"><SPAN class=\"h4\">";

		$strshohin_head2  = "</SPAN>".$data["nisugata"]."</td>\n";
		$strshohin_head2 .= "	<td id=\"cell15\" class=\"noline\">&nbsp;</td>\n";
		$strshohin_head2 .= "</tr>\n";
		$strshohin_head2 .=  "<tr>\n";
		$strshohin_head2 .= "	<td colspan=\"2\" id=\"cell110\" class=\"top\"><h4>".$data["shohinmei"]."</h4></td>\n";
		$strshohin_head2 .= "	<td colspan=\"3\" id=\"cell30\" class=\"topcen\"><h2>合 [".$data["aisuu"]."] 入 [".$data["irisuu"]."]</h2></td>\n";
		$strshohin_head2 .= "	<td id=\"cell15\" class=\"top\">&nbsp;</td>\n";
		$strshohin_head2 .= "</tr>\n";
		$strshohin_head2 .= "<tr>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">&nbsp;&nbsp;&nbsp;ロケーション</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">賞味期限</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">合数</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">CS</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">バラ</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">数量</th>\n";
		$strshohin_head2 .=  "	<th class=\"nolinecen\">残在庫</th>\n";
		$strshohin_head2 .=  "</tr>\n";
	}
	//出荷総数
	$intshohingross += (int)$data["shukkaqty"] + (int)$data["orderqty"];

	//商品詳細を格納
	$strshohin_detail .="	<td id=\"cell40\" class=\"cen\"><h4>".$data["loccode"]."</h4></td>\n";
	if($data["shomi"]=="") {
		$strshohin_detail .="	<td id=\"cell70\" class=\"cen\"><h4>&nbsp;</h4>";
	} else {
		$strshohin_detail .="	<td id=\"cell70\" class=\"cen\"><h4>".date("Y/m/d",strtotime($data["shomi"]))."</h4>";
	}
/*
	if ($data["waitingflg"]==1) {
		$strshohin_detail .="入荷待ち";
	}
	$strshohin_detail .="</td>\n";
*/
	$inttotalbara=(int)$data["shukkaqty"] + (int)$data["orderqty"];  //総バラ数 orderqtyは欠品分のみ
	$intaisuu = floor($inttotalbara / ($data["aisuu"]*$data["irisuu"]));   //合数
	$intcase = floor(($inttotalbara % ($data["aisuu"]*$data["irisuu"])) / $data["irisuu"]);  //ケース
	$intbara = ($inttotalbara % ($data["aisuu"]*$data["irisuu"])) % $data["irisuu"];  //バラ
	if ($intaisuu==0) {$intaisuu="&nbsp;";}
	if ($intcase==0) {$intcase="&nbsp;";}
	if ($intbara==0) {$intbara="&nbsp;";}

	$strshohin_detail .="	<td id=\"cell10\" class=\"cen\"><h2>".$intaisuu."</h2></td>\n";
	$strshohin_detail .="	<td id=\"cell10\" class=\"cen\"><h2>".$intcase."</h2></td>\n";
	$strshohin_detail .="	<td id=\"cell10\" class=\"cen\"><h2>".$intbara."</h2></td>\n";
	$strshohin_detail .="	<td id=\"cell15\" class=\"cen\"><SPAN class=\"h4\">".($data["shukkaqty"]+ (int)$data["orderqty"])."</SPAN>".$data["nisugata"]."</td>\n";
	$strshohin_detail .="	<td id=\"cell15\" class=\"cenborder\"><SPAN class=\"h4\">".$data["zanzaiko"]."</SPAN>".$data["nisugata"]."</td>\n";
	$strshohin_detail .="</tr>";

	if ($chgflg==1) {
		echo "";
	}
	$prevcode=$data["code"];
	$prevshohin=$data["shohincd"];
	$i++;
}
//格納していた商品ヘッダを出力
echo $strshohin_head1;
echo $intshohingross;
echo $strshohin_head2;

//商品詳細を出力
echo $strshohin_detail;
?>
</table>
</div>
<?php
}
 if(($row1 + $row2) ==0) { ?>
対象データがありません。
<?php } else { ?>
<div id="buttonarea">
   <input type="button" value="印刷" onclick="javascript:window.print();" />
   <input type="button" onClick="javascript:window.close();" value="閉じる" class="box1">
</div>
<?php
//ステータステーブルをUPDATE
DataUpdate($company."status","statusid",$_POST[id],"grosstime","now()");

//$strsql = "UPDATE `".$company."status` SET grosstime=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 ("GROSSステータスデータに実施されました。".$errcode." ".$strsql."\n<br>");  #debug

 } ?>
</body>
</html>
<?php 
myclose();
Testecho($strsql);
Testecho($strsqlnozaiko);
Function Sprint($str) {
	echo "<td id=\"cell8\"><h2>".$str."</td>";
}


?>