"") { $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("日付正しくない"); } } //リストを取り出す $lotnum = $_POST[lot]; $strsql1 = "SELECT lotnum, comeinfixqty ,shomi,kakuteidate FROM `".$company."comeinfix` WHERE lotnum = $lotnum"; $strsql2 = "SELECT lotnum, shukkaqty,shozokuid,operatedate,shukkadate,shukkaflg,shukkaid FROM `".$company."shukka` WHERE lotnum = $lotnum ORDER BY shukkadate"; $strsql3 = "SELECT lotnum, arrangeqty,arrangedate,biko,arrangeid FROM `".$company."stockarrange` WHERE lotnum = $lotnum ORDER BY arrangedate"; $strsql4 = "SELECT lotnum, transqty,transdate FROM `".$company."transdata` WHERE lotnum = $lotnum ORDER BY transdate" ; $strsql5 = "SELECT lotnum, stockqty,nonreserveqty FROM `".$company."stockdata` WHERE lotnum = $lotnum" ; Testecho( $strsql);//debug ?>

まずLOT番号だけを入れて表示します
強制変更するときは以下の項目全て入力して更新ボタンで実行します

LOT	入荷数	入荷日	管理日付	出荷	出荷総数	調整	調整総数	移動	移動総数	理論値	現在有効在庫	現在在庫
		".$data["kakuteidate"]."	".$data["shomi"]; $inttotal = $data["comeinfixqty"]; //echo $strsql1; ?>	[未]"; $intqty += $data["shukkaqty"]; $noshukkaqty += $data["shukkaqty"]; } else { $intqty += $data["shukkaqty"]; } echo "[".$data["shukkaid"]."]"; echo " "; } $inttotal -= $intqty; echo "	".$intqty; echo " [".$noshukkaqty."]"; ?>	"; $intqty += $data["arrangeqty"]; } $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 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 lotnum = $lotnum;"; } ?>