"") { $lotdata = dbselect("lotnum,shomi,stockdate,nonreserveqty","`".$company."stockdata`","shohincd='".$_GET["cd"]."'","shomi",1); $lotnum = $lotdata[0][0]; } elseif($_GET[lot] <> "") { $lotnum = $_GET[lot]; $lotdata = dbselect("lotnum,shomi,stockdate,nonreserveqty","`".$company."stockdata`","lotnum='".$lotnum."'","shomi",1); } else { $lotnum = $_POST[lot]; $lotdata = dbselect("lotnum,shomi,stockdate,nonreserveqty","`".$company."stockdata`","lotnum='".$lotnum."'","shomi",1); } if($lotnum[0][0] > 0 ) { } else { $lotdata = dbselect("lotnum,shomi,stockdate,nonreserveqty","`".$company."stockdata`","shohincd='".trim($lotnum)."'","lotnum DESC",1); $lotnum = $lotdata[0][0]; } if($lotnum < 10000) { } else { $lotdata = dbselect("count(lotnum)","`".$company."stockdata`","lotnum='".$lotnum."'",-1,-1); if($lotdata[0][0] == 0) { $lotdata = dbselect("lotnum,shomi,stockdate,nonreserveqty","`".$company."stockdata`","shohincd='".$lotnum."'","shomi",1); $lotnum = $lotdata[0][0]; } } if($_GET["dsql"] <> "") { $strsql = "update `".$company."shukka` SET lotnum = '".$_GET["newlot"]."',shomi = '".$_GET["shomi"]."', stockdate = '".$_GET["stockdate"]."' where shukkaid = '".$_GET["shukkaid"]."' limit 1"; $result=@mysql_query($strsql,$my_con); echo $strsql." ".mysql_affected_rows()."件
"; $strsql = "update `".$company."stockdata` SET nonreserveqty = nonreserveqty + ".(int)$_GET["qty"].", stockqty = stockqty + ".(int)$_GET["qty"]." where lotnum = '".$_GET["lot"]."' limit 1"; $result=@mysql_query($strsql,$my_con); echo $strsql." ".mysql_affected_rows()."件
"; $strsql = "update `".$company."stockdata` SET nonreserveqty = nonreserveqty - ".(int)$_GET["qty"].", stockqty = stockqty - ".(int)$_GET["qty"]." where lotnum = '".$_GET["newlot"]."' limit 1"; $result=@mysql_query($strsql,$my_con); echo $strsql." ".mysql_affected_rows()."件
"; $strsql = "update `".$company."stockdata` SET validflg = 1 WHERE nonreserveqty > 0 and validflg = 0"; $result=@mysql_query($strsql,$my_con); echo $strsql." ".mysql_affected_rows()."件
"; $strsql = "update `".$company."stockdata` SET validflg = 0 WHERE nonreserveqty = 0 and validflg = 1"; $result=@mysql_query($strsql,$my_con); echo $strsql." ".mysql_affected_rows()."件
"; } elseif($_GET["dsql2"] <> "") { $strsql = "update `".$company."stockarrange` SET arrangeqty = 0 where arrangeid = '".$_GET["arrangeid"]."' limit 1"; $result=@mysql_query($strsql,$my_con); echo $strsql." ".mysql_affected_rows()."件
"; } //商品コードのWHERE句 $strdata = dbselect("shohincd","`".$company."comeinfix`","lotnum='".$lotnum."'",-1,-1); $shohincd = $strdata[0][0]; $shohindata = dbselect("shohinmei,shohincd","`".$company."shohinmaster`","shohincd='".$shohincd."'",-1,-1); $yukolot = dbselect("lotnum,shomi,stockdate,nonreserveqty","`".$company."stockdata`","shohincd='".$shohincd."' and nonreserveqty > 0 and lotnum != '".$lotnum."'","shomi,lotnum",1); $targetdate = "'".$_POST[targetdate]."'"; if($_POST["SSH"] <> "") { $strsql2 = $_POST["SSH"]; $result=@mysql_query($strsql2,$my_con); $strsql2 = $_POST["SSH2"]; $result=@mysql_query($strsql2,$my_con); Testecho("JUSTIFY ".$strsql2); } //項目が埋まっている if(($_POST["inold"] <> "") and ($_POST["innew"] <> "") and ($_POST["kanold"] <> "") and ($_POST["kannew"] <> "")){ //日付が正しい $shohindatax = dbselect("shohincd","`".$company."comeinfix`","shohincd='".$shohincd."' and kakuteidate = '".$_POST["inold"]."' and shomi='".$_POST["kanold"]."'",-1,-1); //Testecho ($strsqldbselect); //var_dump($shohindatax); if(sizeof($shohindata)){ //OK $strsql2 = "UPDATE `".$company."comeinfix` SET kakuteidate='".$_POST["innew"]."', shomi='".$_POST["kannew"]."' WHERE lotnum = $lotnum"; $result=@mysql_query($strsql2,$my_con); $strmsg .= "入荷実績変更 ".mysql_affected_rows()."件
"; $strsql2 = "UPDATE `".$company."shukka` SET stockdate='".$_POST["innew"]."', shomi='".$_POST["kannew"]."',shukkaflg = 3 WHERE operatedate"; $strsql2 = "UPDATE `".$company."stockdata` SET stockdate='".$_POST["innew"]."', shomi='".$_POST["kannew"]."' WHERE lotnum = $lotnum"; $result=@mysql_query($strsql2,$my_con); $strmsg .= "在庫変更 ".mysql_affected_rows()."件
"; $strsql2 = "UPDATE `".$company."salesdetail` SET stockdate='".$_POST["innew"]."', shomi='".$_POST["kannew"]."' WHERE lotnum = $lotnum"; $result=@mysql_query($strsql2,$my_con); $strmsg .= "納品実績変更 ".mysql_affected_rows()."件
"; $strsql2 = "UPDATE `".$company."stockarrange` SET stockdate='".$_POST["innew"]."', shomi='".$_POST["kannew"]."' WHERE lotnum = $lotnum"; $result=@mysql_query($strsql2,$my_con); $strmsg .= "在庫調整実績変更 ".mysql_affected_rows()."件
"; $strsql2 = "UPDATE `".$company."transdata` SET stockdate='".$_POST["innew"]."', shomi='".$_POST["kannew"]."' WHERE lotnum = $lotnum"; $result=@mysql_query($strsql2,$my_con); $strmsg .= "在庫移動変更 ".mysql_affected_rows()."件
"; //履歴の書き込み $strsql2 = "INSERT INTO `".$company."comeinfix_update` (shohincd,lotnum,shomiold,shominew,stockdateold,stockdatenew,creater) values('$shohincd',$lotnum,'".$_POST["inold"]."','".$_POST["innew"]."', '".$_POST["kanold"]."', '".$_POST["kannew"]."','".$userdata["tid"]."')"; $result=@mysql_query($strsql2,$my_con); $strmsg .= "履歴作成 ".mysql_affected_rows()."件
"; // echo ("LINE ".__LINE__." $k ROWS= ".mysql_affected_rows()." ".$strsql2." ERRCD=".mysql_errno()."
"); } else { Testecho("日付正しくない"); } } //リストを取り出す $strsql1 = "SELECT lotnum, comeinfixqty ,shomi,kakuteidate,centerid FROM `".$company."comeinfix` WHERE shohincd='".$shohincd."' and lotnum = $lotnum"; $strsql2 = "SELECT lotnum, shukkaqty,shozokuid,operatedate,shukkadate,shukkaflg,shukkaid,centerid,operatedate - curdate() as sa FROM `".$company."shukka` WHERE shohincd='".$shohincd."' and lotnum = $lotnum ORDER BY shukkadate"; $strsql3 = "SELECT lotnum, arrangeqty,arrangedate,biko,arrangeid,centerid FROM `".$company."stockarrange` WHERE shohincd='".$shohincd."' and lotnum = $lotnum ORDER BY arrangedate"; $strsql4 = "SELECT lotnum, transqty,transdate,centerid FROM `".$company."transdata` WHERE shohincd='".$shohincd."' and lotnum = $lotnum ORDER BY transdate" ; $strsql5 = "SELECT lotnum, stockqty,nonreserveqty,centerid FROM `".$company."stockdata` WHERE shohincd='".$shohincd."' and lotnum = $lotnum" ; ?>
まずLOT番号だけを入れて表示します
強制変更するときは以下の項目全て入力して更新ボタンで実行します
LOT/CD
入荷日
管理日
変更する入荷日
変更する管理日
LOT 入荷数 入荷日 管理日付 出荷 出荷総数 調整 調整総数 移動 移動総数 理論値 現在有効在庫 現在在庫
".$data["comeinfixqty"]."".$data["kakuteidate"]."".$data["shomi"]; $inttotal = $data["comeinfixqty"]; //echo $strsql1; ?> [未]"; $intqty += $data["shukkaqty"]; $noshukkaqty += $data["shukkaqty"]; } elseif($data["shukkaflg"] < 3) { echo "[確]"; $intqty += $data["shukkaqty"]; } else { $intqty += $data["shukkaqty"]; } echo "[".$data["shukkaid"]."]"; if($userdata["kengen"] < 6) { echo "[".$yukolot[0][0]."] [non".$yukolot[0][3]."]"; } echo "
"; } $inttotal -= $intqty; echo "
".$intqty; echo "
[".$noshukkaqty."]"; ?>
"; $intqty += $data["arrangeqty"]; if($userdata["kengen"] < 6) { echo "[".$data["arrangeid"]."]
"; } } $inttotal += $intqty; // echo "[".$data["arrangeid "]."]"; echo "
".$intqty; ?> "; $intqty += $data["transqty"]; } $inttotal -= $intqty; echo "".$intqty; ?> (int)$data["nonreserveqty"]) { PrintMsg((int)$data["nonreserveqty"],"",50); } else { PrintMsg("",(int)$data["nonreserveqty"],50); } //echo $strsql1; ?>
0) { $strsql = "UPDATE ".$company."stockdata SET stockqty = $zaikototal ,nonreserveqty = $inttotal,validflg=1 WHERE lotnum = $lotnum;"; $strsql2 = "UPDATE ".$company."shukka SET shukkaflg = 3 WHERE operatedate < curdate() and lotnum = $lotnum;"; } else { $strsql = "UPDATE ".$company."stockdata SET stockqty = $zaikototal ,nonreserveqty = $inttotal,validflg=0 WHERE lotnum = $lotnum;"; $strsql2 = "UPDATE ".$company."shukka SET shukkaflg = 3 WHERE operatedate < curdate() and lotnum = $lotnum;"; } ?>
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $shukka = (int)GetListData($datashukka,$data["lotnum"],0); echo ""; $arrange = (int)GetListData($dataarrange,$data["lotnum"],0); echo ""; $trans = (int)GetListData($datatrans,$data["lotnum"],0); echo ""; if((int)$data["comeinfixqty"] - $shukka + $arrange - $trans - (int)$data["nonreserveqty"]) { echo ""; } else { echo ""; } echo ""; if($data["stockqty"] > 0) $s["p"] += $data["stockqty"]; $s["ci"] += $data["comeinfixqty"]; $s["st"] += $data["stockqty"]; $s["no"] += $data["nonreserveqty"]; } ?>
center LOT 入荷日 入荷備考 賞味 入荷数 現在有効在庫 現在在庫 有効 入庫作成 総出 総調 総移 +
".$data["centerid"]."".$data["lotnum"]."".$data["stockdate"]."".$data["biko"]."".$data["shomi"]."".$data["comeinfixqty"]."".$data["nonreserveqty"]."".$data["stockqty"]."".$data["validflg"]."".$data["creater"]."".(int)$shukka."".(int)$arrange."".(int)$trans."NG
-
date_add(curdate(), INTERVAL -50 DAY) and shohincd = '".$shohindata[0][1]."' order by operatedate,shomi" ; $result=@mysql_query($strsql5,$my_con);$intqty = 0;$c = 1; //echo $strsql5; while ($data = @mysql_fetch_array($result)){ if($shomi <> $data["shomi"]) {$c="";} else {$c="";} echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $intqty +=$data["shukkaqty"]; echo "\r\n"; $shomi = $data["shomi"]; } echo ""; echo ""; echo "\r\n"; ?>
CENTER ID 出荷店舗 作業日 賞味 LOT
".$data["centerid"]."".$data["shukkaid"]."".$data["shozokuid"]."".GetListData($tenpodata,$data["shozokuid"],0)."".$data["operatedate"]."".$data["shomi"]." $c ".$data["lotnum"]."".str_replace(".0","",$data["shukkaqty"])."
".str_replace(".0","",$intqty)."