$c_chkSql = $c_chkFlag == "OK" ? "": "AND (B.BSTOQTY + (A.INQTY + A.REGOODQTYY + A.REGOODQTYN + A.REPRODQTY ) - ( A.OUTQTY + A.AUTHQTY + A.ADDQTY + A.SAMPLEQTY + A.EATQTY + A.ABOQTY  + A.INOUTQTY ) ) <>  A.STOQTY " ;

$query   = "
        -- 창고수불원장에서 입고와 출고를 비교해서 이상이 있는 상품을 찾아서 보여준다.  
        -- 전일재고수량 + 입구수량 - 출고수량  == 당일재고수량 
        -- 날짜의 범위만 입력을 받아서 처리한다. 
        SELECT
         A.STOCD
        ,A.DEALDAY
        ,A.PRODCD
        ,B.PRODNM
        ,B.BSTOQTY
        ,(A.INQTY     + A.REGOODQTYY  + A.REGOODQTYN  + A.REPRODQTY) AS TINQTY
        ,(A.INOUTQTY  + A.OUTQTY + A.AUTHQTY     + A.ADDQTY      + A.SAMPLEQTY   + A.EATQTY     + A.ABOQTY ) AS TOUTQTY
        ,A.STOQTY
        ,DECODE ( (B.BSTOQTY + ((A.INQTY     + A.REGOODQTYY  + A.REGOODQTYN  + A.REPRODQTY) - (A.INOUTQTY  + A.OUTQTY + A.AUTHQTY     + A.ADDQTY      + A.SAMPLEQTY   + A.EATQTY    + A.ABOQTY ))- A.STOQTY ) , 0 ,'정상','비정상') AS CHECKGB   
        FROM 
        STOCK_BP A ,
             (SELECT TO_CHAR(TO_DATE(A.DEALDAY,'YYYYMMDD')+1,'YYYYMMDD') AS DEALDAY 
                     ,A.STOCD  AS STOCD 
                     ,A.PRODCD AS PRODCD
                     ,B.PRODNM AS PRODNM
                     ,A.STOQTY AS BSTOQTY  
                FROM STOCK_BP A, PRODCD_BP B
               WHERE A.BONCD='B001' 
                 AND A.BONCD=B.BONCD
                 AND A.PRODCD=B.PRODCD
                 AND A.DEALDAY >= TO_CHAR(TO_DATE('$key_date','YYYYMMDD')-1,'YYYYMMDD')
                 AND A.DEALDAY <= TO_CHAR(TO_DATE('$key_date1','YYYYMMDD')-1,'YYYYMMDD')                             
             ) B
        WHERE A.DEALDAY = B.DEALDAY
        AND A.PRODCD = B.PRODCD
        AND A.STOCD  = B.STOCD
        $c_chkSql
        --AND (B.BSTOQTY + (A.INQTY + A.REGOODQTYY + A.REGOODQTYN + A.REPRODQTY ) - ( A.OUTQTY + A.AUTHQTY + A.ADDQTY + A.SAMPLEQTY + A.EATQTY + A.ABOQTY  + A.INOUTQTY ) ) <>  A.STOQTY 
        AND A.DEALDAY >='$key_date' 
        AND A.DEALDAY <='$key_date1'                    
        ORDER BY A.STOCD , A.DEALDAY " ;
          
//echo"
$query
";