\n";
echo "";
echo " 商品コード
商品名 | \n";
echo " 規格 | \n";
echo " | \n";
echo " | \n";
echo "
\n";
$strshohin_head2 = "\n";
$strshohin_head2 .= " | ロケーション（特記） | \n";
$strshohin_head2 .= " 管理日付 | \n";
$strshohin_head2 .= " 合数 | \n";
$strshohin_head2 .= " CS | \n";
$strshohin_head2 .= " バラ | \n";
$strshohin_head2 .= " 数量 | \n";
$strshohin_head2 .= " | \n";
$strshohin_head2 .= "
\n";
echo $strshohin_head2;$strshohin_head2="";
//賞味期限、入荷待ち単位の出荷データ（商品グロス+商品マスタ）
$strsql2 = "SELECT shu2.shohincd,shu2.shukkaqty,shu2.pagenumber,shu2.orderid,shu2.memo,shu2.memo4,shu.loccode,shu.shomi,shu.zanzaiko FROM `".$company."shukka` as shu2,`".$company."shukka` as shu WHERE shu2.picktimes = '".$data["picktimes"]."' AND shu2.shukkaqty>0 and shu2.shozokuid='".$data["shozokuid"]."' AND shu.shukkaid=shu2.shukkaid and shu2.pagenumber='".$data["pagenumber"]."' and shu2.operatedate = DATE_ADD( CURDATE() , INTERVAL ".$_POST[chgday]." DAY ) ";
$strsql2 = "SELECT shu.*,sho.shohinmei, irisuu,aisuu,sho.code,ryutu_type, kikaku,nisugata,price_sell,sho.centernisugata,sho.shomiflg FROM ($strsql2) AS shu INNER JOIN `".$company."shohinmaster` AS sho USING (shohincd) GROUP BY shu.shohincd ORDER BY sho.code,shu.loccode,shu.shohincd";
$totalamount = 0;
$result2=@mysql_query($strsql2,$my_con);
Testecho ("LINE ".__LINE__." ".$y." ".$strsql2); //debug
mysql_sql_log2($strsql2,$_SERVER['SCRIPT_NAME'].":".__LINE__);
while ($data2 = mysql_fetch_array($result2)) {
$strshohin_head1 = "\n";
$strshohin_head1 .= " ".substr($data2["shohincd"],0,6)." ".substr($data2["shohincd"],6,10).""." ![](bar.php?code=".$data2["shohincd"]."&number=no&size=18) | \n\n";
$strshohin_head1 .= " ".$data2["kikaku"]." | \n";
$strshohin_head1 .= " ";
$strshohin_head2 = "".$data2["nisugata"]." | \n";
$strshohin_head2 .= " | \n";
$strshohin_head2 .= "
\n";
$strshohin_head2 .= "\n";
$strshohin_head2 .= " ".$data2["shohinmei"]." | \n";
$strshohin_head2 .= " 合 [".$data2["aisuu"]."] 入 [".$data2["irisuu"]."] | \n";
$strshohin_head2 .= " | \n";
$strshohin_head2 .= "
\n";
//出荷総数
$intshohingross += (int)$data["shukkaqty"] + (int)$data["orderqty"];
echo $strshohin_head1;
echo $strshohin_head2;
//商品詳細を格納
$strshohin_detail ="\n";
$strshohin_detail .=" ".$data2["loccode"]."![](\"bar.php?code=".$data2["loccode"]."&size=18&number=no\") | \n";
if($data2["shomi"]=="") {
$strshohin_detail .=" ";
} else {
$strshohin_detail .=" | ".Printshomi($data2["shomiflg"],5).$data2["shomi"]."![](\"bar.php?code=D$".substr(str_replace("-","",$data2["shomi"]),2,6)."&size=18&number=no\") ";
}
$inttotalbara=(int)$data2["shukkaqty"] + (int)$data2["orderqty"]; //総バラ数 orderqtyは欠品分のみ
$intaisuu = floor($inttotalbara / ($data2["aisuu"]*$data2["irisuu"])); //合数
$intcase = floor(($inttotalbara % ($data2["aisuu"]*$data2["irisuu"])) / $data2["irisuu"]); //ケース
$intbara = ($inttotalbara % ($data2["aisuu"]*$data2["irisuu"])) % $data2["irisuu"]; //バラ
if ($intaisuu==0) {$intaisuu=" ";}
if ($intcase==0) {$intcase=" ";}
if ($intbara==0) {$intbara=" ";}
$strshohin_detail .=" | ".$intaisuu.$data2["centernisugata"]." | \n";
if($data2["aisuu"] == 1) {
$strshohin_detail .=" ".$intcase." | \n";
} else {
$strshohin_detail .=" ".$intcase."cs | \n";
}
if(($data2["aisuu"] == 1) and ($data2["irisuu"] == 1)){
$strshohin_detail .=" | \n";
} else {
$strshohin_detail .=" ".$intbara.$data2["nisugata"]." | \n";
}
$strshohin_detail .=" ".($data2["shukkaqty"]+ (int)$data2["orderqty"])."".$data2["nisugata"]." | \n";
$strshohin_detail .=" | \n";
//$strshohin_detail .=" ".$data2["zanzaiko"]."".$data2["nisugata"]." | \n";
$strshohin_detail .="
";
if ($chgflg==1) {
echo "";
}
// echo $strshohin_detail;
//出荷データ（納品先グロス）
$strsql3 = "SELECT sum(shukkaqty) as shukkaqty, loccode,shomi FROM `".$company."shukka` AS shu ".$strwhere." AND shozokuid = '".$data["shozokuid"]."' AND shohincd='".$data2["shohincd"]."' GROUP BY shomi ORDER BY shomi";
$result3=@mysql_query($strsql3,$my_con);
Testecho ("LINE ".__LINE__." ".$y." ".$strsql3); //debug
mysql_sql_log2($strsql3,$_SERVER['SCRIPT_NAME'].":".__LINE__);
while ($data3 = mysql_fetch_array($result3)) {
//商品詳細を格納
$strshohin_detail ="\n";
$strshohin_detail .=" ".$data3["loccode"].$data2["memo"]."![](\"bar.php?code=".$data3["loccode"]."&size=18&number=no\") | \n";
if($data3["shomi"]=="") {
$strshohin_detail .=" ";
} else {
$strshohin_detail .=" | ".Printshomi($data2["shomiflg"],5).$data3["shomi"]."![](\"bar.php?code=D$".substr(str_replace("-","",$data3["shomi"]),2,6)."&size=18&number=no\") ";
}
$inttotalbara=(int)$data3["shukkaqty"] + (int)$data3["orderqty"]; //総バラ数 orderqtyは欠品分のみ
$intaisuu = floor($inttotalbara / ($data2["aisuu"]*$data2["irisuu"])); //合数
$intcase = floor(($inttotalbara % ($data2["aisuu"]*$data2["irisuu"])) / $data2["irisuu"]); //ケース
$intbara = ($inttotalbara % ($data2["aisuu"]*$data2["irisuu"])) % $data2["irisuu"]; //バラ
if ($intaisuu==0) {$intaisuu=" ";}
if ($intcase==0) {$intcase=" ";}
if ($intbara==0) {$intbara=" ";}
$strshohin_detail .=" | ".$intaisuu.$data2["centernisugata"]." | \n";
if($data2["aisuu"] == 1) {
$strshohin_detail .=" ".$intcase." | \n";
} else {
$strshohin_detail .=" ".$intcase."cs | \n";
}
if(($data2["aisuu"] == 1) and ($data2["irisuu"] == 1)){
$strshohin_detail .=" | \n";
} else {
$strshohin_detail .=" ".$intbara.$data2["nisugata"]." | \n";
}
$strshohin_detail .=" ".($data3["shukkaqty"]+ (int)$data3["orderqty"])."".$data2["nisugata"]." | \n";
$strshohin_detail .=" | \n";
//$strshohin_detail .=" ".$data3["zanzaiko"]."".$data3["nisugata"]." | \n";
$strshohin_detail .="
";
if ($chgflg==1) {
echo "";
}
//商品詳細を出力
echo $strshohin_detail;
}
$i++;
$line++;
}
$page++;
?>
&number=no&size=20" style='margin:0 3mm 0 3mm;'> ルート：