<?php  //6412.php	ピッキングリスト出力（トータル）鮮魚
/*****************************************************************************
// 変更履歴：
---	2018/08/07	更新	残在庫表示変更	Ohyamna
*****************************************************************************
*/
include "func.cgi";
myopen();
//訂正	2016/05/26	グロス集計を商品CDだけにした（location,と温度は外した
//訂正	2017/01/12	全ブラウザ対応	ohyama
//何アイテムで改ページするか
$pagekaigyo = 16;  
//再チェック
SecurityCheck();
PostData();
FunctionUseCheck2();
//var_dump($makerdata);
//ブランド区分を入れる
$strsql ="Update cool_shukka as om ,cool_shozokumaster as sho SET om.brand = sho.brand WHERE om.shozokuid = sho.shozokuid and om.brand =''";
$result=@mysql_query($strsql,$my_con);
$strsqlall .= "ROW=".mysql_affected_rows()." ".$strsql."\n";

//対象データ取得
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]."'  ";

if($_POST[brand] <> "") {
	$brand = $_POST["brand"];
	$strwhere .= " and brand='$brand'";
} else {
}

if($userdata[brand] <> "") {
	$strwhere .= " and brand in(".$userdata[brand].")";
} else {
}

//流通型の条件指定
$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 sm.makercodeG = '$_POST[maker]' ";
	} else {
		$strsqlmaker .= " and sm.makercode = '$_POST[maker]' ";
	}
}
if ($userdata["supplyerid2"]<> ""){
	if($_POST["grouping"] == "1") {
		$strsqlmaker .= " and sm.makercodeG in (".$userdata["supplyerid2"].") ";
	} else {
		$strsqlmaker .= " and sm.makercode in (".$userdata["supplyerid2"].") ";
	}
}

//温度
if ($_POST[code]<>"") {
	$strsqlmaker .= "and sm.code in(";
	foreach($_POST[code] as $key => $val){
		$strsqlmaker .= $val.",";
	}
	$strsqlmaker .= "-9) ";
}


//表示順
if ($orderby==2) {
	//商品順
	$strorder = " ORDER BY ryutu_type,code,shohincd,loccode,shomi,waitingflg";
} else {
	//ロケーション順
	$strorder = " ORDER BY ryutu_type,code DESC,sm.location,loccode,shohincd,shomi,waitingflg";
}

//ピッキングデータ
$strsql = "SELECT shohincd,sum(shukkaqty) as shukkaqty,shukkadate,operatedate,picktimes,loccode,shomi,min(zanzaiko) AS zanzaiko,waitingflg FROM `".$company."shukka` ".$strwhere." group by shohincd,loccode,shomi";
$strsql = "SELECT shohincd,sum(shukkaqty) as shukkaqty,shukkadate,operatedate,picktimes,loccode,shomi,min(zanzaiko) AS zanzaiko,waitingflg FROM `".$company."shukka` ".$strwhere." group by shohincd";
//$strsqlnozaiko = "SELECT shohincd,sum(shukkaqty) as shukkaqty,sum(orderqty) as orderqty,shukkadate,operatedate,picktimes,loccode,shomi,min(zanzaiko) AS zanzaiko,waitingflg FROM `".$company."shukka` ".$strwhere." and orderqty>0 group by shohincd,loccode,shomi";


//商品マスタをJOIN
$strsql = "SELECT shohincd,sm.ryutu_type,centernisugata,shomiflg,shukkaqty,shukkadate,operatedate,kikaku,irisuu,aisuu,nisugata,shohinmei,code,loccode,pg.shomi,picktimes,zanzaiko,waitingflg,sm.makercode,sm.location 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,loccode,pg.shomi,picktimes,zanzaiko,waitingflg 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);
//流通型データの取得
$codedata10 = dbselect("cname,code","`".$company."code`","codekind = '10'","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);
while ($data = mysql_fetch_array($result)) {
	if(($prevcode<>$data["code"]) or ($prev_type<>$data["ryutu_type"]) or ($line==$pagekaigyo)) {
		if (($prevcode<>$data["code"]) or ($prev_type<>$data["ryutu_type"])) {
			//改ページから何枚目か
			$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"]."&nbsp;"); PrintList($makerdata,$_POST["maker"],0);// ?>　
	<div id="header">
	<h6>ピッキングリスト【グロス】 <?php PrintList($makerdata,$_POST["maker"],0);//PrintList($codedata,$data["code"],0)."級"; //温度帯 ?></h6>
	</div>
	<div id="subnavR">
		<IMG SRC="/images/3box.gif" height="60">
	</div>
	<div id="subnav">
	<h2><?php PrintList($codedata,$data["code"],0); // ?> 　<?php PrintList($codedata10,$data["ryutu_type"],0); // ?> 　<?php PrintList($centerdata,$_POST[center],0);  ?><br>
	<?php  echo ($data["picktimes"]); // ?>回目<?php  echo "【".$maime."枚目】"; // ?></h2>
	</div>
</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";
		$stock = dbselect("sum(nonreserveqty)","`".$company."stockdata`","nonreserveqty > 0 and shohincd ='".$data["shohincd"]."' AND centerid='".$_POST[center]."'",-1,-1);		if((int)$stock[0][0] > 0) {
	$zanzaiko = " : ".floor((int)$stock[0][0] / $data["irisuu"])."cs";
	if((int)$data["irisuu"] > 1) {
	$zanzaiko .= "/".floor((int)$stock[0][0] % $data["irisuu"])."<font size=-1>".$data["nisugata"]."</font>";}
$st = "(残".(int)$stock[0][0].$zanzaiko.")";
} else {
$st = "(-)";} 
		$strshohin_head1 .= "	<td colspan=\"2\" id=\"cell110\" class=\"noline\"><h2>".$data["shohincd"]."&nbsp;：".$data["location"]."&nbsp;　".$st."　<font size=-1>".GetListData($makerdata,$data["makercode"],0)."</font></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["kikaku"]."</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></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";
		if($data["aisuu"] == 1) {
			$strshohin_head2 .=  "	<th class=\"nolinecen\"></th>\n";
		} else {
			$strshohin_head2 .=  "	<th class=\"nolinecen\"></th>\n";
		}
		if(($data["aisuu"] == 1) and ($data["irisuu"] == 1)){
			$strshohin_head2 .=  "	<th class=\"nolinecen\"></th>\n";
		} else {
			$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 += $data["shukkaqty"] ;

	//商品詳細を格納
/*	$strshohin_detail .="<tr>\n";
	$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=$data["shukkaqty"] ;  //総バラ数 
	$intaisuu = ($inttotalbara / ($data["aisuu"]*$data["irisuu"]));   //合数
	$intcase = (($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></h2></td>\n";
	$strshohin_detail .="	<td id=\"cell10\" class=\"cen\"><h2></h2></td>\n";
	$strshohin_detail .="	<td id=\"cell10\" class=\"cen\"><h2></h2></td>\n";
	$strshohin_detail .="	<td id=\"cell15\" class=\"cen\"><SPAN class=\"h4\">".($data["shukkaqty"]+ $data["orderqty"])."</SPAN>".$data["kikaku"]."</td>\n";
	$strshohin_detail .="	<td id=\"cell15\" class=\"cenborder\"><SPAN class=\"h4\">".$data["zanzaiko"]."</SPAN></td>\n";
	$strshohin_detail .="</tr>";

	if ($chgflg==1) {
		echo "";
	}
*/
	$prevcode=$data["code"];
	$prev_type=$data["ryutu_type"];
	$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>";
}


?>