| 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"] < 2) {
echo "[未]";
$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."]"; ?> |
$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; ?> |