"") { $operatedate =$_POST[chgday]; } else { $operatedate =0; } $shukkadate = $operatedate+1; //締め処理 //ShimeSet1($operatedate); //臨時 $strsql = "update ".$company."shukka as shu,".$company."shozokumaster as sho set shu.brand = sho.brand,shu.gyotaiid= sho.gyotaiid where shu.shozokuid=sho.shozokuid and shu.brand = '' and operatedate =curdate()"; $result=mysql_query($strsql,$my_con); $errcode =@mysql_errno(); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //臨時 $strsql = "update ".$company."shukka as shu,".$company."shohinmaster as sm set shu.supplyerid= sm.makercode where sm.shohincd = shu.shohincd and (shu.supplyerid = '' or shu.supplyerid is null) AND shu.operatedate = curdate()"; $result=mysql_query($strsql,$my_con); $errcode =@mysql_errno(); Testecho ($y." $NG row=".mysql_affected_rows()." ".$strsql."
"); #debug mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); //全数が出荷確定済みなら、ステータスを更新する商品マスターが有る分のみ $dataflg = dbselect("sum(Case when shu.shukkaflg >= 2 then 1 else 0 end) as c,count(shu.shukkaid),shu.gyotaiid,shu.centerid,shu.picktimes","`".$company."shukka` as shu INNER JOIN `".$company."shohinmaster` USING(shohincd)","shu.DC_TC in(0,1) AND shu.operatedate=DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and shu.shukkaqty > 0 GROUP BY shu.operatedate,shu.centerid,shu.gyotaiid,shu.picktimes having c > 0",-1,-1); Testecho ("STATUS = ".$strsqldbselect); For ($ii = 0 ; $ii < sizeof($dataflg) ; $ii++) { if((int)$dataflg[$ii][0] == (int)$dataflg[$ii][1]) { //ステータステーブルをUPDATE $strsql10 = "UPDATE `".$company."status` set status = 5 WHERE status <= 4 and keppinqty = 0 and operatedate = DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and gyotaiid= '".$dataflg[$ii][2]."' and centerid = '".$dataflg[$ii][3]."' "; // $strsql10 = "UPDATE `".$company."status` set status = 5 WHERE status <= 4 and operatedate = DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and gyotaiid= '".$dataflg[$ii][2]."' and centerid = '".$dataflg[$ii][3]."' AND picktimes ='".$dataflg[$ii][4]."'"; $result=@mysql_query($strsql10,$my_con); Testecho ("LINE 30 ".__LINE__." ".$y." ROWS=".mysql_affected_rows()." ".$strsql10); //debug mysql_sql_log($strsql10,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); } else { Testecho("No");//DC_TCが通過品のまま残っているものがある } } $strsql10 = "UPDATE `".$company."status` set status = 1 WHERE operatedate = DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) AND hikiateqty is null"; $result=@mysql_query($strsql10,$my_con); Testecho ("LINE ".__LINE__." ".$y." ROWS=".mysql_affected_rows()." ".$strsql10); //debug mysql_sql_log($strsql10,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); if(($_POST[cancel] == "YES") and ($_POST[kariexecute] == "X19818798456adaFSFGG6-46546546")) { //仮引当取消 $centerid = $_POST[center]; include "5901.php"; /// $strsq = "update koto_shozokumaster set picktimes = 1 ,centerid= '$centerid'"; /// $result=@mysql_query($strsq,$my_con); } elseif(($_POST[cancel] == "") and ($_POST[kariexecute] == "X19818798456adaFSFGG6-46546546")) { //仮引当実行 $centerid = $_POST[center]; include "5900.php"; /// $strsq = "update koto_shozokumaster set picktimes = ".($_POST[picktimes] + 1)." ,centerid= '$centerid'"; /// $result=@mysql_query($strsq,$my_con); /// $strsq = "insert into koto_status(operatedate,centerid,picktimes) values('2013-3-6','".$centerid."' ,".($_POST[picktimes] + 1).")"; /// $result=@mysql_query($strsq,$my_con); } elseif(($_POST[cancel] == "rerun") and ($_POST[kariexecute] == "X19818798456adaFSFGG6-46546546")) { //仮引当実行(緊急） $centerid = $_POST[center]; include "5905.php"; } elseif ($_POST[honexecute]=="Z445668446456-44647254566") { //本引当実行引当確定 $centerid = $_POST[center]; include "5800.php"; // include "5517a.php"; $strsql = "UPDATE `".$company."status` SET status=6 WHERE status=5 AND centerid='".$_POST[center]."' AND operatedate =DATE_ADD(CURDATE(),INTERVAL $operatedate DAY)"; $result = @mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("受注確定がステータスデータに実施されました。".$errcode." ".$strsql."\n
"); #debug } elseif($_POST[juexecute]=="7456s45s6664dfs495we895efs6") { //受注確定実行 $operatedatecome =$operatedate + 1; if ((int)$settingdata["comein_datacreate"] == 1) { //入荷データを受注データから作成 $strsql = "INSERT into `".$company."comeindata`(centerid,shohincd,hacchuid,comeindate,comeinqty,creater,createdate) SELECT centerid,shohincd,orderid,DATE_ADD(CURDATE(),INTERVAL $operatedatecome DAY),sum(orderqty),'SYSTEM',now() FROM `".$company."ordersheet` AS os INNER JOIN `".$company."shohinmaster` AS sm USING(shohincd),`".$company."ordermain` as main WHERE main.ordermainid=os.ordermainid and operatedate = DATE_ADD(CURDATE(),INTERVAL $operatedate DAY) and checkedflg <=3 and ryutu_type = 2 GROUP BY shohincd,centerid"; $result=@mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("通過型発注が入庫に追加されました。".$errcode." ".$strsql."\n
"); #debug } $strsql = "UPDATE `".$company."ordermain` as om,`".$company."shozokumaster` as sho SET checkedflg=3 WHERE om.shozokuid = sho.shozokuid and sho.picktimes = '".$_POST[picktimes]."' and om.gyotaiid='".$_POST[gyotai]."' and om.centerid='".$_POST[center]."' and om.checkedflg in (1,2) and operatedate =DATE_ADD(CURDATE(),INTERVAL $operatedate DAY)"; $result=@mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("受注確定が受注データに実施されました。".$errcode." ".$strsql."\n
"); #debug $strsql = "UPDATE `".$company."status` SET status = 2 WHERE picktimes = '".$_POST[picktimes]."' and centerid='".$_POST[center]."' AND operatedate =DATE_ADD(CURDATE(),INTERVAL $operatedate DAY)"; $result=@mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("受注確定がステータスデータに実施されました。".$errcode." ".$strsql."\n
"); #debug } elseif ($_POST[juexecute ]== "7adffdafdsgad8954695efs6") { //通過出荷データ作成 $centerid = $_POST[center]; $picktimes = $_POST["picktimes"]; include "5906.php"; // $strsql = "UPDATE `".$company."status` SET status=6 WHERE status=5 AND gyotaiid='".$_POST[gyotai]."' AND centerid='".$_POST[center]."' AND operatedate =DATE_ADD(CURDATE(),INTERVAL $operatedate DAY)"; // $result = @mysql_query($strsql,$my_con); mysql_sql_log($strsql,mysql_affected_rows(),$_SERVER['SCRIPT_NAME'].":".__LINE__); Testecho ("受注確定がステータスデータに実施されました。".$errcode." ".$strsql."\n
"); #debug } $strsqlwhere ="operatedate=DATE_ADD(CURDATE(),INTERVAL $operatedate DAY)"; //ステータスデータにデータ挿入 MakeStatusData($operatedate); //センター限定 if($userdata["centerid"] <> "") { if(strpos($userdata["centerid"], "'") === false) { $strsqlcenter = " AND st.centerid = '".$userdata["centerid"]."' "; } else { $strsqlcenter = " AND st.centerid in (".$userdata["centerid"].") "; } } else { } $strsql = "SELECT statusid, st.centerid, gname,gyo.gyotaiid, status,picktimes, hikiateqty, keppinqty,keppinfixqty, grosstime, tanemakitime, nouhintime,nouhintime2, st.updatetime,hacchutime FROM `".$company."gyotai` AS gyo LEFT JOIN `".$company."status` AS st USING ( gyotaiid ) WHERE $strsqlwhere $strsqlcenter ORDER BY st.centerid,picktimes"; Testecho ($strsql); #debug $result=@mysql_query($strsql,$my_con); ?>

更新:

=1) { //処理は業態単位で1回であるため==1の場合4 ?>

No	物流センター	状況	欠品件数 (処理済)	処理	帳票
	";PrintList($centerdata,$data[centerid],0); ?>	締め処理時刻:"; if ((int)$data[hacchutime] < 1000) { echo substr($data[hacchutime],0,1).":".substr($data[hacchutime],1,2); } else { echo substr($data[hacchutime],0,2).":".substr($data[hacchutime],2,2); } //未処理データ $norundata = dbselect("count(statusid),operatedate","`".$company."status`","gyotaiid='".$data[gyotaiid]."' and status < 6 and operatedate < DATE_ADD(CURDATE(),INTERVAL ".$operatedate." DAY) and centerid ='".$data[centerid]."' ","operatedate,status","1"); Testecho($strsqldbselect); if(($data[picktimes] > 0) and ($norundata[0][0] == 0)) { $norundata = dbselect("count(statusid),operatedate","`".$company."status`","gyotaiid='".$data[gyotaiid]."' and status < 6 and picktimes < ".$data[picktimes]." and operatedate = DATE_ADD(CURDATE(),INTERVAL ".$operatedate." DAY) and centerid ='".$data[centerid]."' ","operatedate,status","1"); } } elseif($data[status]==1) { //未処理データ $norundata = dbselect("count(statusid),operatedate","`".$company."status`","gyotaiid='".$data[gyotaiid]."' and status < 6 and operatedate < DATE_ADD(CURDATE(),INTERVAL ".$operatedate." DAY) and centerid ='".$data[centerid]."' ","operatedate,status","1"); Testecho($strsqldbselect); if(($data[picktimes] > 0) and ($norundata[0][0] == 0)) { $norundata = dbselect("count(statusid),operatedate","`".$company."status`","gyotaiid='".$data[gyotaiid]."' and status < 6 and picktimes < ".$data[picktimes]." and operatedate = DATE_ADD(CURDATE(),INTERVAL ".$operatedate." DAY) and centerid ='".$data[centerid]."' ","operatedate,status","1"); } } elseif($data[status]==5) { //欠品商品で現時点で欠品が解消されていない（＝入荷確定されていない）リスト　出荷数(出荷実績テーブルの出荷数)＞在庫数のリスト $outofstock = dbselect("a.shohincd,(shukka - ifnull(zaiko,0)) as sabun,a.lotnum ","(SELECT shohincd,sum(`shukkaqty`) as shukka,lotnum FROM `".$company."shukka` WHERE picktimes = '".$data[picktimes]."' and operatedate = DATE_ADD(CURDATE(),INTERVAL ".$operatedate." DAY) and gyotaiid='".$data[gyotaiid]."' and centerid = '".$data[centerid]."' GROUP BY lotnum) as a LEFT JOIN (SELECT shohincd,sum(`stockqty`) as zaiko,lotnum FROM `".$company."stockdata` WHERE DC_TC < 2 AND validflg=1 and centerid = '".$data[centerid]."' GROUP BY lotnum ) as b on a.lotnum = b.lotnum HAVING sabun>0",-1,-1,-1); Testecho($strsqldbselect); for ($pi = 0; $pi < sizeof($outofstock); $pi++) { $strmsgout .= "LOT:".$outofstock[$pi][2]." 商品コード:".$outofstock[$pi][0]." 現在の欠品数:".$outofstock[$pi][1]."\\n"; } } if((int)$settingdata["daily_total_execute"] == 1) { //日次処理をまとめて行う $norundata = dbselect("count(statusid),operatedate","`".$company."status`","gyotaiid='".$data[gyotaiid]."' and status > 1 and status < 6 and operatedate <= DATE_ADD(CURDATE(),INTERVAL ".$operatedate." DAY) and operatedate > DATE_ADD(CURDATE(),INTERVAL ".($operatedate - 6)." DAY) and centerid ='".$data[centerid]."' ","operatedate,status","1"); Testecho($strsqldbselect); } //入荷予定未処理 2016/10/17 if((int)$settingdata["comeindata_nonfix_al"] == 1) { //入荷予定未処理時エラー $nonfixcomeindata = dbselect("min(comeindate),count(comeindate)","`".$company."comeindata`","comeinflg = 0 and comeindate < DATE_ADD(CURDATE(),INTERVAL ".$operatedate." DAY) and centerid ='".$data[centerid]."' ",-1,1); Testecho($strsqldbselect); if($nonfixcomeindata[0][1] > 0) { $strComeinAlert = $nonfixcomeindata[0][0]."の入荷予定が未確定のため受注確定出来ません。"; } else { } } ?>	"") echo "(".$data[keppinfixqty].")"; ?>	"") {?> > > >
				> > >	>
				> > 0) { PrintStatus5000b("3456",$data[status],"5200");} else {echo " disabled";} ?> >	> >
				> >	> > >
				> >
>
> >納品先別:
>納品書:

ただいま処理中ですこのままお待ちください

ただいま処理中です
このままお待ちください