$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"].") "; } } //物流用商品コード設定　2017/3/3 if($settingdata["center_shohincd"] <> "") { $shohincd_get = $settingdata["center_shohincd"]; } else { $shohincd_get = "shohincd"; } //温度 if ($_POST[code]<>"") { $strsqlmaker .= "and sm.code in("; foreach($_POST[code] as $key => $val){ $strsqlmaker .= $val.","; } $strsqlmaker .= "-9) "; } //対象データ取得 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 .= "shu.shozokuid <> '0' AND operatedate = DATE_ADD( CURDATE() , INTERVAL $_POST[chgday] DAY ) AND shu.centerid='".$_POST[center]."' and shukkaqty>0 "; //表示順 商品順 ロケーションの最小 $strorder = " ORDER BY code,loccode,shohincd"; //温度帯データの取得 $codedata = dbselect("cname,code","`".$company."code`","codekind = '1'","code",-1); /* 商品単位 { //出荷データ、商品情報 $data1 //賞味期限単位合計は5430.php 出荷データ,出荷合計数 $data2 賞味期限別に集計する必要がある 出荷データはロット別だが、ロットやロケは関係ない 商品情報＋ピック総量 納品先別{ //店名、ルート 出荷データ、所属マスタ $data3 出荷データはロット別だが、ロットやロケは関係ない 納品先別表示 } } */ //商品単位の出荷データ $strsql = "SELECT shohincd,shukkaqty,operatedate,shukkadate,deliverdate,picktimes,loccode FROM `".$company."shukka` AS shu ".$strwhere." "; $strsql ="SELECT shohincd,shohincd2,shohincd3,sum(shukkaqty) as shukkaqty,min(loccode) as loccode,operatedate,shukkadate,deliverdate,kikaku,irisuu,aisuu,nisugata,centernisugata,shohinmei,code,shomiflg,sm.makercode FROM ($strsql) as pg INNER JOIN `".$company."shohinmaster` AS sm USING (shohincd) WHERE ".$strsqlmaker." GROUP BY sm.shohincd ".$strorder; Testecho ($y." $errcode ".$strsql); #debug ?> LogiGate<?php //echo $systemname; ?> 出力:<?php echo date("Y/m/d",strtotime ("".$_POST[chgday]." day")); ?><?php //echo $_POST[picktimes]."回目"; ?> #\n"; for ($i=0;$i<$rows;$i++) { echo "\n"; } ?> ".$data[$i]."\n"; } ?>
------------------------------------------

\n\n
 
\n"; $line=1; } elseif($i>0) { //最初でない $page++; echo "\t\n\n
 
\n"; $line++; } else { //行数が改ページに達していない $line++; } ?>
作業日:　 出荷日:　 納品日:　印刷日： \n"; //テーブルヘッダ echo "\n"; echo ""; echo " \n"; echo " \n"; echo " \n"; echo "\n"; $strshohin_head1 = "\n"; $strshohin_head1 .= " \n"; $strshohin_head1 .= " \n"; $strshohin_head1 .= " \n"; $strshohin_head2 .= "\n"; $strshohin_head2 .= "\n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= "\n"; $strshohin_head2 .= "\n";//商品分け区分線 $strshohin_head2 .= "\n"; $strshohin_head2 .= " \n"; $strshohin_head2 .= " \n"; if($data["aisuu"] == 1) { $strshohin_head2 .= " \n"; } else { $strshohin_head2 .= " \n"; } if(($data["aisuu"] == 1) and ($data["irisuu"] == 1)){ $strshohin_head2 .= " \n"; } else { $strshohin_head2 .= " \n"; } $strshohin_head2 .= " \n"; $strshohin_head2 .= "\n"; echo $strshohin_head1; echo $strshohin_head2; ?> \n"; $strshohin_detail .=" \n"; $inttotalbara=$data3["shukkaqty"]; //総バラ数 $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=" ";} if ($intcase==0) {$intcase=" ";} if ($intbara==0) {$intbara=" ";} $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=" \n"; $strshohin_detail .=""; //商品詳細を出力 echo $strshohin_detail; } $i++; } ?>
 商品コード
 商品名		規格数量

".$data{$shohincd_get}."　".GetListData($makerdata,$data["makercode"],0)."

".$data["kikaku"]."　

"; $strshohin_head1 .= str_replace(".0","",$data["shukkaqty"]); $strshohin_head2 = "".$data["nisugata"]."

".$data["shohinmei"]."

合 [".$data["aisuu"]."] 入 [".$data["irisuu"]."]

納品先(特記)配送ルート".$data["centernisugata"]."CS".$data["nisugata"]."数量

".$data3["shozokuid"]."".GetList($deliverydata,$data3["deliveryid"])."".$data3["route"]."

".$data3["shozokuname"]; if($data3["memo"] <> "") { $strshohin_detail .= "
(".$data3["memo"].")"; } $strshohin_detail .= "

".$intaisuu."

".$intcase."

".$intbara."

".str_replace(".0","",$inttotalbara)."".$data["nisugata"]."
対象データがありません。バッチ番号（通常は１）、日付を確認ください。 "); #debug ?>