$query="INSERT INTO SDSTOCLSTB( DV_CD --
, DEAL_DAY --
, STO_CLS_GB --
, PROD_CD --
, IN_QTY --
, IN_RTN_QTY --
, OUT_QTY --
, OUT_RTN_QTY --
, STO_CTL_QTY --
, STO_QTY --
, REG_DTIME --
, REG_ID --
)
SELECT DV_CD
, FIN_DAY
, '$STO_CLS_GB'
, '$PROD_CD[$i]'
, 0,0,0,0,0,0
, $_sysdate14
, '$_Z[user_id]'
FROM FDFINTB
WHERE DV_CD = '$_Z[dv_cd]'
AND FIN_DAY >= '$DEAL_DAY'
AND FIN_DAY NOT IN (SELECT DEAL_DAY FROM SDSTOCLSTB
WHERE DV_CD = '$_Z[dv_cd]'
AND STO_CLS_GB = '$STO_CLS_GB'
AND PROD_CD = '$PROD_CD[$i]'
AND DEAL_DAY >= '$DEAL_DAY'
GROUP BY DEAL_DAY) " ;
|
|
|