"") {
$lotdata = dbselect("lotnum,shomi,stockdate,nonreserveqty","`".$company."stockdata`","shohincd='".$_GET["cd"]."'","shomi",1);
$lotnum = $lotdata[0][0];
} elseif($_GET[lot] <> "") {
$lotnum = $_GET[lot];
} else {
$lotnum = $_POST[lot];
}
if($lotnum < 7000) {
} 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","shomi",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 = 4 WHERE lotnum = $lotnum";
$result=@mysql_query($strsql2,$my_con);
$strmsg .= "出荷実績変更 ".mysql_affected_rows()."件
";
$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 lotnum = $lotnum";
$strsql2 = "SELECT lotnum, shukkaqty,shozokuid,operatedate,shukkadate,shukkaflg,shukkaid,centerid FROM `".$company."shukka` WHERE lotnum = $lotnum ORDER BY shukkadate";
$strsql3 = "SELECT lotnum, arrangeqty,arrangedate,biko,arrangeid,centerid FROM `".$company."stockarrange` WHERE lotnum = $lotnum ORDER BY arrangedate";
$strsql4 = "SELECT lotnum, transqty,transdate,centerid FROM `".$company."transdata` WHERE lotnum = $lotnum ORDER BY transdate" ;
$strsql5 = "SELECT lotnum, stockqty,nonreserveqty,centerid FROM `".$company."stockdata` WHERE lotnum = $lotnum" ;
?>
| LOT | 入荷数 | 入荷日 | 管理日付 | 出荷 | 出荷総数 | 調整 | 調整総数 | 移動 | 移動総数 | 理論値 | 現在有効在庫 | 現在在庫 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
$result=@mysql_query($strsql1,$my_con);
$data = @mysql_fetch_array($result) ;
echo "[".$data["centerid"]."] ".$data["comeinfixqty"]." | ".$data["kakuteidate"]." | ".$data["shomi"]; $inttotal = $data["comeinfixqty"]; //echo $strsql1; ?> |
$result=@mysql_query($strsql2,$my_con);$intqty = 0;
while ($data = @mysql_fetch_array($result)){
echo $data["shukkaqty"]." ".$data["operatedate"]." [".$data["shozokuid"]." ";
PrintList($tenpodata,$data["shozokuid"],0);
echo "[".$data["centerid"]."]";
if($data["shukkaflg"] < 3) {
echo "[未]";
$intqty += $data["shukkaqty"];
$noshukkaqty += $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."]"; ?> |
$result=@mysql_query($strsql3,$my_con);$intqty = 0;
while ($data = @mysql_fetch_array($result)) {
echo $data["arrangeqty"]." ".$data["arrangedate"]." ".$data["biko"]." [".$data["arrangeid"]."] [".$data["centerid"]."] "; $intqty += $data["arrangeqty"]; if($userdata["kengen"] < 6) { echo "[".$data["arrangeid"]."] "; } } $inttotal += $intqty; // echo "[".$data["arrangeid "]."]"; echo " | ".$intqty; ?> |
$result=@mysql_query($strsql4,$my_con);$intqty = 0;
while ($data = @mysql_fetch_array($result)) {
echo $data["transqty"]." ".$data["transdate"]." "; $intqty += $data["transqty"]; } $inttotal -= $intqty; echo " | ".$intqty; ?> | $result=@mysql_query($strsql5,$my_con); $data = @mysql_fetch_array($result); if($inttotal <> (int)$data["nonreserveqty"]) { PrintMsg((int)$data["nonreserveqty"],"",50); } else { PrintMsg("",(int)$data["nonreserveqty"],50); } //echo $strsql1; ?> |