入庫かんばん　出力時間:<?php echo date("Y/m/d H:i:s") ; ?>

"") { $centercode=$_POST[center]; } else { $centercode=$_POST[centercode]; } if ($_POST["PRINT"] <>"") { //7400から商品指定 $strshohin = " AND sm.shohincd in ('1'"; for ($x=0; $x <(int)$_POST[maxrow];$x++) { if($_POST{"print".$x}<>"") { $strshohin .= ",'".$_POST{"shohin".$x}."'"; } } $strshohin .= ")"; Testecho("商品指定 ".$strshohin." ".__LINE__); //商品データをメインに、サプライヤーマスタ内部接続、、入荷数、入庫予定日のリストを取り出す //0 cd.centercode/1 mname/2 sm.shohincd/3 shohinmei/4 comeinqty/5 comeindate/6 cd.shomi/7 kakuteiqty/8 comeinflg/9 passqty /10 shomiflg/11.location /12 sm.code/13 sm.kikaku/14 sm.irisu /15 aisuu /16 nisugata/17 makercode $strsql = "SELECT centerid,sm.shohincd,shohinmei,sm.shomiflg,sl.loccode,sm.code,sm.kikaku,sm.irisuu,sm.aisuu,sm.centernisugata,sm.makercode FROM `".$company."shohinmaster` AS sm,`".$company."shohinlocation` AS sl WHERE sl.centerid='".$centercode."' and sm.shohincd=sl.shohincd ".$strshohin; //echo $strsql; } else { $strsqlcenter = " and cd.centerid='".$centercode."' "; //サプライヤーリストの取得 //サプライヤーコード if ($_POST[maker]<>""){ $strsqlmaker = " and sm.makercode = '$_POST[maker]' "; } //流通型の条件指定 $strsqlmaker .= "and sm.ryutu_type in("; foreach($_POST[ryutu_type] as $key => $val){ $strsqlmaker .= $val.","; } $strsqlmaker .= "0) "; //温度 $strsqlmaker .= "and sm.code in("; foreach($_POST[code] as $key => $val){ $strsqlmaker .= $val.","; } $strsqlmaker .= "0) "; //表示順 $strsqlorder = " order by makercode,cd.loccode,cd.shomi desc"; //商品データをメインに、サプライヤーマスタ内部接続、入荷テーブル内部接続で、入荷数、入庫予定日のリストを取り出す //0 cd.centercode/1 mname/2 sm.shohincd/3 shohinmei/4 comeinqty/5 comeindate/6 cd.shomi/7 kakuteiqty/8 comeinflg/9 passqty /10 shomiflg/11.location /12 sm.code/13 sm.kikaku/14 sm.irisu /15 aisuu /16 nisugata/17 makercode $strsql = "SELECT cd.centerid,companyname,sm.shohincd,shohinmei,comeinqty,comeindate,cd.shomi,comeinflg,sm.shomiflg,cd.loccode,sm.code,sm.kikaku,sm.irisuu,sm.aisuu,sm.centernisugata,sm.makercode,sm.shomiflg FROM `".$company."shohinmaster` AS sm INNER JOIN `".$company."comeindata` AS cd ON sm.shohincd=cd.shohincd and cd.comeindate =DATE_ADD(CURDATE(),INTERVAL $orderdate DAY) ,company AS mm WHERE sm.makercode=mm.companyid ".$strsqlcenter.$strsqlmaker.$strsqlorder; } //全数 $result=@mysql_query($strsql,$my_con); $maxrow=@mysql_num_rows($result); Testecho ($strsql); mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__); ?> 入庫かんばん　出力時間:<?php echo date("Y/m/d H:i:s") ; ?>

-1) { echo "

"; } else { $chgflg=1; } ?>

70){ ?>

合

入

規

入荷日

"") {echo date("Y/m/d",strtotime($data["comeindate"]));} else { //入庫日 ?>

3) PrintShomi($data["shomiflg"],1); ?>

"") {echo date("Y/m/d",strtotime($data["shomi"]));} else { //賞味期限 ?>