$val){ $strTypeWhere .= $val.","; if($val == 1) { $strmsg .= " 在庫型"; } else { $strmsg .= " 通過型"; } } $strTypeWhere .= "99) "; //サプライヤーコード if ($_POST[maker]<>"") { $strsqlmaker = " and sm.makercode = '$_POST[maker]'"; } //温度 $strsqlmaker .= "and sm.code in("; foreach($_POST[code] as $key => $val){ $strsqlmaker .= $val.","; } $strsqlmaker .= "99) "; //ロケーション $strsql = "update `".$company."comeindata` as cd,`".$company."shohinlocation` as sl SET cd.loccode = sl.loccode where cd.shohincd = sl.shohincd and cd.centerid = sl.centerid and cd.comeindate >= DATE_ADD(CURDATE(),INTERVAL $orderdate DAY) and cd.loccode =''"; $result=mysql_query($strsql,$my_con); $errcode =mysql_errno();//if ($errcode==0) $okcount++; mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ($strsql.mysql_affected_rows().$_SERVER['SCRIPT_NAME'].":".__LINE__); //表示順 $strsqlorder = " order by makercode,sm.code,cd.loccode,sm.shohincd,cd.shomi,comeinid"; //商品データをメインに、サプライヤーマスタ内部接続、入荷テーブル内部接続で、入荷数、入荷予定日のリストを取り出す $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.nisugata,sm.centernisugata,sm.makercode,cd.kubun 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.$strTypeWhere .$strsqlmaker.$strsqlorder; //全数 $result=@mysql_query($strsql,$my_con); $maxrow=@mysql_num_rows($result); mysql_sql_log2($strsql,$_SERVER['SCRIPT_NAME'].":".__LINE__); ?> 入荷予定リスト<?php //echo "LogiGate 出力時間 ".date("Y/m/d H:i:s") ; ?>


$data["makercode"]) or ($prevcode<>$data["code"]) or ($line==$pagekaigyo)) { if ($chgflg>-1) { echo "
  
"; $i=1;$line=1; } ?>

作業日 :

 
 		 
 		 
 
"") { $shomi=date("Y/m/d",strtotime($data["shomi"]));} else {$shomi="";} //null対策 ?>
No. ロケーション 温
度		 商品コード 商品名
規格		 期限　(賞味/製造/入荷) 入荷数 総バラ


[]×

//

".$data["centernisugata"]; ?> 

";if ($intbara <> " ") {echo $data["nisugata"]; } ?> 

".$str.""; } ?>