XinYu_RZMES/.svn/pristine/fa/fa74cf84ed78f208b6ca1e6e61f5e79471436539.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
    <query id="UIH090060_01.select" desc="获取原料、产量、合格品、次品、待判定、中板、轧回、废品" fetchSize="10">
        <![CDATA[
/***********************************************************************
	黄提供，废弃
	( 
   -- scrap weight 
    
   SELECT  DAY_SCRAP_CNT,MON_SCRAP_CNT,DAY_SCRAP_WGT,MON_SCRAP_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SCRAP_CNT, SUM(SCRAP_WGT) DAY_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM    
    WHERE   SCRAP_WGT is not null     
     AND SUBSTR(MILL_DTIME,9,4) > ? AND SUBSTR(MILL_DTIME,9,4) < ? 
     AND  SUBSTR(MILL_DTIME,1,8) = ?
     AND  MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SCRAP_CNT, SUM(ACT_WGT) MON_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM    
    WHERE  SCRAP_WGT is not null  
     AND SUBSTR(MILL_DTIME,9,4) > ? AND SUBSTR(MILL_DTIME,9,4) < ? 
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(?,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   ? 
     AND  MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) G 
	
待判定
( 
   -- waiting  total  decision   
   SELECT  DAY_DEC_WAIT_CNT,MON_DEC_WAIT_CNT,DAY_DEC_WAIT_WGT,MON_DEC_WAIT_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_DEC_WAIT_CNT, SUM(ACT_WGT) DAY_DEC_WAIT_WGT  
     
     FROM TBH02_COIL_COMM    
    WHERE  CUR_PROG_CD = 'SED' 
     AND  CUR_PROG_CD  IS NOT NULL   
     AND SUBSTR(MILL_DTIME,9,4) > :29 AND SUBSTR(MILL_DTIME,9,4) < :30 
     AND  SUBSTR(MILL_DTIME,1,8) = :31
     AND  MILL_DTIME IS NOT NULL 
  ) a,   -- daily 
  (
    SELECT     COUNT(*) MON_DEC_WAIT_CNT, SUM(ACT_WGT) MON_DEC_WAIT_WGT  
     
     FROM TBH02_COIL_COMM    
    WHERE  CUR_PROG_CD = 'SED' 
     AND  CUR_PROG_CD  IS NOT NULL   
     AND SUBSTR(MILL_DTIME,9,4) > :32 AND SUBSTR(MILL_DTIME,9,4) < :33 
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:34,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :35 
     AND  MILL_DTIME IS NOT NULL 
  ) b   -- monthly
    
 ) E,
************************************************************************/
			
SELECT  TO_CHAR(DAY_SLAB_CNT)     DAY_SLAB_CNT    ,TO_CHAR(MON_SLAB_CNT)      MON_SLAB_CNT    ,nvl((DAY_SLAB_WGT/1000),0)            DAY_SLAB_WGT    ,nvl((MON_SLAB_WGT/1000),0)            MON_SLAB_WGT    ,   
        TO_CHAR(DAY_COIL_CNT)     DAY_COIL_CNT    ,TO_CHAR(MON_COIL_CNT)      MON_COIL_CNT    ,nvl((DAY_COIL_WGT/1000),0)            DAY_COIL_WGT    ,nvl((MON_COIL_WGT/1000),0)            MON_COIL_WGT    ,   
        TO_CHAR(DAY_GRD_1_CNT)    DAY_GRD_1_CNT   ,TO_CHAR(MON_GRD_1_CNT)     MON_GRD_1_CNT   ,nvl((DAY_GRD_1_WGT/1000),0)           DAY_GRD_1_WGT   ,nvl((MON_GRD_1_WGT/1000),0)           MON_GRD_1_WGT   ,   
        TO_CHAR(DAY_GRD_2_CNT)    DAY_GRD_2_CNT   ,TO_CHAR(MON_GRD_2_CNT)     MON_GRD_2_CNT   ,nvl((DAY_GRD_2_WGT/1000),0)           DAY_GRD_2_WGT   ,nvl((MON_GRD_2_WGT/1000),0)           MON_GRD_2_WGT   ,   
        TO_CHAR(DAY_REJ_CNT)      DAY_REJ_CNT     ,TO_CHAR(MON_REJ_CNT)       MON_REJ_CNT     ,nvl(TO_CHAR(DAY_REJ_WGT/1000),0)      DAY_REJ_WGT     ,nvl(TO_CHAR(MON_REJ_WGT/1000),0)      MON_REJ_WGT     ,   
        TO_CHAR(DAY_SCRAP_CNT)    DAY_SCRAP_CNT   ,TO_CHAR(MON_SCRAP_CNT)     MON_SCRAP_CNT   ,nvl(TO_CHAR(DAY_SCRAP_WGT/1000),0)    DAY_SCRAP_WGT   ,nvl(TO_CHAR(MON_SCRAP_WGT/1000),0)    MON_SCRAP_WGT   ,
	    TO_CHAR(DAY_MISSNO_CNT)   DAY_MISSNO_CNT  ,TO_CHAR(MON_MISSNO_CNT)    MON_MISSNO_CNT  ,nvl(TO_CHAR(DAY_MISSNO_WGT/1000),0)   DAY_MISSNO_WGT  ,nvl(TO_CHAR(MON_MISSNO_WGT/1000),0)   MON_MISSNO_WGT  ,
		TO_CHAR(DAY_SIZE_CNT)     DAY_SIZE_CNT    ,TO_CHAR(MON_SIZE_CNT)      MON_SIZE_CNT    ,nvl((DAY_SIZE_WGT/1000),0)            DAY_SIZE_WGT    ,nvl((MON_SIZE_WGT/1000),0)            MON_SIZE_WGT  	,
		TO_CHAR(DAY_EXTSHAPE_CNT) DAY_EXTSHAPE_CNT,TO_CHAR(MON_EXTSHAPE_CNT)  MON_EXTSHAPE_CNT,nvl((DAY_EXTSHAPE_WGT/1000),0)        DAY_EXTSHAPE_WGT,nvl((MON_EXTSHAPE_WGT/1000),0)        MON_EXTSHAPE_WGT,
		TO_CHAR(DAY_MATLQLTY_CNT) DAY_MATLQLTY_CNT,TO_CHAR(MON_MATLQLTY_CNT)  MON_MATLQLTY_CNT,nvl((DAY_MATLQLTY_WGT/1000),0)        DAY_MATLQLTY_WGT,nvl((MON_MATLQLTY_WGT/1000),0)        MON_MATLQLTY_WGT,
		TO_CHAR(DAY_STL_CNT)      DAY_STL_CNT     ,TO_CHAR(MON_STL_CNT)       MON_STL_CNT     ,nvl((DAY_STL_WGT/1000),0)             DAY_STL_WGT     ,nvl((MON_STL_WGT/1000),0)             MON_STL_WGT
 FROM 
(
   ---  Slab weight,这里统一使用轧制时间即卷取时间来进行统计
  SELECT   DAY_SLAB_CNT,MON_SLAB_CNT,DAY_SLAB_WGT ,MON_SLAB_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_SLAB_CNT, SUM(SLAB_WGT) DAY_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b  
   WHERE  a.SLAB_NO = b.SLAB_NO 
     AND SUBSTR(A.MILL_DTIME,9,4) > :1 AND SUBSTR(A.MILL_DTIME,9,4) < :2
     AND  SUBSTR(A.MILL_DTIME,1,8) = :3
    
  ) a, -- daily 
  (
    SELECT   COUNT(*) MON_SLAB_CNT, SUM(SLAB_WGT) MON_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b  
   WHERE  a.SLAB_NO = b.SLAB_NO 
     AND SUBSTR(A.MILL_DTIME,9,4) > :4  AND SUBSTR(A.MILL_DTIME,9,4) < :5
     AND  SUBSTR(A.MILL_DTIME,1,8) >= SUBSTR(:6,1,6)||'01' 
     AND  SUBSTR(A.MILL_DTIME,1,8) <=   :7
  ) b -- monthly 
 ) A,
 (
   -- coil weight 
  SELECT   DAY_COIL_CNT,MON_COIL_CNT,DAY_COIL_WGT ,MON_COIL_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_COIL_CNT,SUM(ACT_WGT) DAY_COIL_WGT  
     
    FROM TBH02_COIL_COMM   
   WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND SUBSTR(MILL_DTIME,9,4) > :8 AND SUBSTR(MILL_DTIME,9,4) < :9
     AND  SUBSTR(MILL_DTIME,1,8) = :10 
     AND  MILL_DTIME IS NOT NULL 
    
  ) a,   -- daily 
  (
    SELECT   COUNT(*) MON_COIL_CNT,SUM(ACT_WGT) MON_COIL_WGT  
     
    FROM TBH02_COIL_COMM   
     WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND SUBSTR(MILL_DTIME,9,4) > :11 AND SUBSTR(MILL_DTIME,9,4) < :12 
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:13,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :14 
     AND  MILL_DTIME IS NOT NULL 
   
  ) b   -- monthly
 )  B,
  
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 1
  SELECT   DAY_GRD_1_CNT,MON_GRD_1_CNT,DAY_GRD_1_WGT,MON_GRD_1_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_1_CNT, SUM(ACT_WGT) DAY_GRD_1_WGT 
    FROM TBH02_COIL_COMM    
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND SUBSTR(MILL_DTIME,9,4) > :15 AND SUBSTR(MILL_DTIME,9,4) < :16 
     AND  SUBSTR(MILL_DTIME,1,8) = :17
     AND  MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_1_CNT, SUM(ACT_WGT) MON_GRD_1_WGT 
    FROM TBH02_COIL_COMM    
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND SUBSTR(MILL_DTIME,9,4) > :18 AND SUBSTR(MILL_DTIME,9,4) < :19 
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:20,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :21
     AND  MILL_DTIME IS NOT NULL 
   )  b    -- monthly
   
 ) C,
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 2
  SELECT   DAY_GRD_2_CNT,MON_GRD_2_CNT,DAY_GRD_2_WGT,MON_GRD_2_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_2_CNT, SUM(ACT_WGT) DAY_GRD_2_WGT 
    FROM TBH02_COIL_COMM    
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND SUBSTR(MILL_DTIME,9,4) > :22 AND SUBSTR(MILL_DTIME,9,4) < :23 
     AND  SUBSTR(MILL_DTIME,1,8) = :24 
     AND  MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_2_CNT, SUM(ACT_WGT) MON_GRD_2_WGT 
    FROM TBH02_COIL_COMM    
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND SUBSTR(MILL_DTIME,9,4) > :25 AND SUBSTR(MILL_DTIME,9,4) < :26 
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:27,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :28  
     AND  MILL_DTIME IS NOT NULL 
   )  b
   
 ) D,
 ( 
   -- reject coil and slab 轧回
   SELECT   DAY_REJ_CNT,MON_REJ_CNT,DAY_REJ_WGT,MON_REJ_WGT
   FROM
  (
    SELECT  COUNT(*) DAY_REJ_CNT, SUM(SLAB_WGT) DAY_REJ_WGT   
     
   FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c 
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
     AND  b.missno_clf = '3'
     AND SUBSTR(MILL_DTIME,9,4) > :29 AND SUBSTR(MILL_DTIME,9,4) < :30 
     AND  SUBSTR(MILL_DTIME,1,8) = :31
     AND  MILL_DTIME IS NOT NULL 
  )  a,  -- daily 
  (
    SELECT COUNT(*) MON_REJ_CNT, SUM(SLAB_WGT) MON_REJ_WGT   
     
    FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c 
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
     AND  b.missno_clf = '3'
     AND SUBSTR(MILL_DTIME,9,4) > :32 AND SUBSTR(MILL_DTIME,9,4) < :33 
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:34,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :35 
     AND  MILL_DTIME IS NOT NULL 
  )b   -- monthly
 ) E ,

 ( 
  -- scrap weight 废钢
    
   SELECT  DAY_SCRAP_CNT,MON_SCRAP_CNT,DAY_SCRAP_WGT,MON_SCRAP_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SCRAP_CNT, SUM(b.missno_bar_wgt) DAY_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null       
          AND SUBSTR(a.MILL_DTIME,9,4) > :36  AND SUBSTR(a.MILL_DTIME,9,4) < :37
          AND  SUBSTR(a.MILL_DTIME,1,8) = :38
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SCRAP_CNT, SUM(b.missno_bar_wgt) MON_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null  
          AND SUBSTR(a.MILL_DTIME,9,4) > :39 AND SUBSTR(a.MILL_DTIME,9,4) < :40 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:41,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :42 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) F, 
( 
  -- missno_bar weight  中板
   SELECT  DAY_MISSNO_CNT,MON_MISSNO_CNT,DAY_MISSNO_WGT,MON_MISSNO_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MISSNO_CNT, SUM(b.missno_bar_wgt) DAY_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null       
          AND SUBSTR(a.MILL_DTIME,9,4) > :43  AND SUBSTR(a.MILL_DTIME,9,4) < :44
          AND  SUBSTR(a.MILL_DTIME,1,8) = :45
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MISSNO_CNT, SUM(b.missno_bar_wgt) MON_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null  
          AND SUBSTR(a.MILL_DTIME,9,4) > :46 AND SUBSTR(a.MILL_DTIME,9,4) < :47 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:48,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :49 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) G, 
( 
  -- SIZE_DEC_RST != '1' 
   SELECT  DAY_SIZE_CNT,MON_SIZE_CNT,DAY_SIZE_WGT,MON_SIZE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SIZE_CNT, SUM(a.act_wgt) DAY_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.Size_Dec_Rst != '1'
          AND  SUBSTR(a.MILL_DTIME,9,4) > :50  AND SUBSTR(a.MILL_DTIME,9,4) < :51
          AND  SUBSTR(a.MILL_DTIME,1,8) = :52
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SIZE_CNT, SUM(a.act_wgt) MON_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.Size_Dec_Rst != '1' 
          AND  SUBSTR(a.MILL_DTIME,9,4) > :53 AND SUBSTR(a.MILL_DTIME,9,4) < :54 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:55,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :56
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) H,
( 
  -- EXTSHAPE_DEC_GRD != '1' 
   SELECT  DAY_EXTSHAPE_CNT,MON_EXTSHAPE_CNT,DAY_EXTSHAPE_WGT,MON_EXTSHAPE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_EXTSHAPE_CNT, SUM(a.act_wgt) DAY_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.EXTSHAPE_DEC_GRD != '1'
          AND  SUBSTR(a.MILL_DTIME,9,4) > :57  AND SUBSTR(a.MILL_DTIME,9,4) < :58
          AND  SUBSTR(a.MILL_DTIME,1,8) = :59
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_EXTSHAPE_CNT, SUM(a.act_wgt) MON_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.EXTSHAPE_DEC_GRD != '1' 
          AND  SUBSTR(a.MILL_DTIME,9,4) > :60 AND SUBSTR(a.MILL_DTIME,9,4) < :61 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:62,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :63
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) I,
( 
  -- MATLQLTY_DEC_GRD != '1' 
   SELECT  DAY_MATLQLTY_CNT,MON_MATLQLTY_CNT,DAY_MATLQLTY_WGT,MON_MATLQLTY_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MATLQLTY_CNT, SUM(a.act_wgt) DAY_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.MATLQLTY_DEC_GRD != '1'
          AND  SUBSTR(a.MILL_DTIME,9,4) > :64  AND SUBSTR(a.MILL_DTIME,9,4) < :65
          AND  SUBSTR(a.MILL_DTIME,1,8) = :66
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MATLQLTY_CNT, SUM(a.act_wgt) MON_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.MATLQLTY_DEC_GRD != '1' 
          AND  SUBSTR(a.MILL_DTIME,9,4) > :67 AND SUBSTR(a.MILL_DTIME,9,4) < :68 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:69,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :70
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly	
 ) J,
 ( 
  --  钢制
   SELECT  DAY_STL_CNT,MON_STL_CNT,DAY_STL_WGT,MON_STL_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_STL_CNT, SUM(a.act_wgt) DAY_STL_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
          AND  SUBSTR(a.MILL_DTIME,9,4) > :71  AND SUBSTR(a.MILL_DTIME,9,4) < :72
          AND  SUBSTR(a.MILL_DTIME,1,8) = :73
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_STL_CNT, SUM(a.act_wgt) MON_STL_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59') 
          AND  SUBSTR(a.MILL_DTIME,9,4) > :74 AND SUBSTR(a.MILL_DTIME,9,4) < :75 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:76,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :77 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b 
 ) K
        ]]>
    </query>
    <query id="UIH090060_02.select" desc="获取当天的班组信息，并且根据班次情况把早、中、晚的信息对应到班组上去" fetchSize="10">
        <![CDATA[
			SELECT  T.GR_GROUP_CD  
     			 FROM    TBG02_SHIFT_GROUP T
				  WHERE   GR_YYYYMM = ?
				   AND    GR_DD     = ?
				   AND    GR_SHIFT  = ?  
				   AND    T.PROC_CD = 'H'
        ]]>
    </query>
<query id="UIH090060_03.select" desc="获取原料、产量、合格品、次品、待判定、中板、轧回、废品。 这里考虑到中班可能存在跨天的情况，所以需要分开统计。并且跨天的情况还需要对时间进行特殊处理" fetchSize="10">
        <![CDATA[		
SELECT  TO_CHAR(DAY_SLAB_CNT)     DAY_SLAB_CNT    ,TO_CHAR(MON_SLAB_CNT)      MON_SLAB_CNT    ,nvl((DAY_SLAB_WGT/1000),0)            DAY_SLAB_WGT    ,nvl((MON_SLAB_WGT/1000),0)            MON_SLAB_WGT    ,   
        TO_CHAR(DAY_COIL_CNT)     DAY_COIL_CNT    ,TO_CHAR(MON_COIL_CNT)      MON_COIL_CNT    ,nvl((DAY_COIL_WGT/1000),0)            DAY_COIL_WGT    ,nvl((MON_COIL_WGT/1000),0)            MON_COIL_WGT    ,   
        TO_CHAR(DAY_GRD_1_CNT)    DAY_GRD_1_CNT   ,TO_CHAR(MON_GRD_1_CNT)     MON_GRD_1_CNT   ,nvl((DAY_GRD_1_WGT/1000),0)           DAY_GRD_1_WGT   ,nvl((MON_GRD_1_WGT/1000),0)           MON_GRD_1_WGT   ,   
        TO_CHAR(DAY_GRD_2_CNT)    DAY_GRD_2_CNT   ,TO_CHAR(MON_GRD_2_CNT)     MON_GRD_2_CNT   ,nvl((DAY_GRD_2_WGT/1000),0)           DAY_GRD_2_WGT   ,nvl((MON_GRD_2_WGT/1000),0)           MON_GRD_2_WGT   ,   
        TO_CHAR(DAY_REJ_CNT)      DAY_REJ_CNT     ,TO_CHAR(MON_REJ_CNT)       MON_REJ_CNT     ,nvl(TO_CHAR(DAY_REJ_WGT/1000),0)      DAY_REJ_WGT     ,nvl(TO_CHAR(MON_REJ_WGT/1000),0)      MON_REJ_WGT     ,   
        TO_CHAR(DAY_SCRAP_CNT)    DAY_SCRAP_CNT   ,TO_CHAR(MON_SCRAP_CNT)     MON_SCRAP_CNT   ,nvl(TO_CHAR(DAY_SCRAP_WGT/1000),0)    DAY_SCRAP_WGT   ,nvl(TO_CHAR(MON_SCRAP_WGT/1000),0)    MON_SCRAP_WGT   ,
        TO_CHAR(DAY_MISSNO_CNT)   DAY_MISSNO_CNT  ,TO_CHAR(MON_MISSNO_CNT)    MON_MISSNO_CNT  ,nvl(TO_CHAR(DAY_MISSNO_WGT/1000),0)   DAY_MISSNO_WGT  ,nvl(TO_CHAR(MON_MISSNO_WGT/1000),0)   MON_MISSNO_WGT  ,
        TO_CHAR(DAY_SIZE_CNT)     DAY_SIZE_CNT    ,TO_CHAR(MON_SIZE_CNT)      MON_SIZE_CNT    ,nvl((DAY_SIZE_WGT/1000),0)            DAY_SIZE_WGT    ,nvl((MON_SIZE_WGT/1000),0)            MON_SIZE_WGT    ,
        TO_CHAR(DAY_EXTSHAPE_CNT) DAY_EXTSHAPE_CNT,TO_CHAR(MON_EXTSHAPE_CNT)  MON_EXTSHAPE_CNT,nvl((DAY_EXTSHAPE_WGT/1000),0)        DAY_EXTSHAPE_WGT,nvl((MON_EXTSHAPE_WGT/1000),0)        MON_EXTSHAPE_WGT,
        TO_CHAR(DAY_MATLQLTY_CNT) DAY_MATLQLTY_CNT,TO_CHAR(MON_MATLQLTY_CNT)  MON_MATLQLTY_CNT,nvl((DAY_MATLQLTY_WGT/1000),0)        DAY_MATLQLTY_WGT,nvl((MON_MATLQLTY_WGT/1000),0)        MON_MATLQLTY_WGT,
        TO_CHAR(DAY_STL_CNT)      DAY_STL_CNT     ,TO_CHAR(MON_STL_CNT)       MON_STL_CNT     ,nvl((DAY_STL_WGT/1000),0)             DAY_STL_WGT     ,nvl((MON_STL_WGT/1000),0)             MON_STL_WGT
 FROM 
(
   ---  Slab weight,这里统一使用轧制时间，即卷取时间。 
  SELECT   DAY_SLAB_CNT,MON_SLAB_CNT,DAY_SLAB_WGT ,MON_SLAB_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_SLAB_CNT, SUM(SLAB_WGT) DAY_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b  
   WHERE  a.SLAB_NO = b.SLAB_NO 
     AND  ((SUBSTR(A.MILL_DTIME,9,4) > :1 AND SUBSTR(A.MILL_DTIME,9,4) < '2400') OR (SUBSTR(A.MILL_DTIME,9,4) > '0000' AND SUBSTR(A.MILL_DTIME,9,4) < :2))
     AND  SUBSTR(A.MILL_DTIME,1,8) = :3
    
  ) a, -- daily 
  (
    SELECT   COUNT(*) MON_SLAB_CNT, SUM(SLAB_WGT) MON_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b  
   WHERE  a.SLAB_NO = b.SLAB_NO 
     AND  ((SUBSTR(A.MILL_DTIME,9,4) > :4  AND SUBSTR(A.MILL_DTIME,9,4) < '2400') OR (SUBSTR(A.MILL_DTIME,9,4) > '0000'  AND SUBSTR(A.MILL_DTIME,9,4) < :5))
     AND  SUBSTR(A.MILL_DTIME,1,8) >= SUBSTR(:6,1,6)||'01' 
     AND  SUBSTR(A.MILL_DTIME,1,8) <=   :7
  ) b -- monthly 
 ) A,
 (
   -- coil weight 
  SELECT   DAY_COIL_CNT,MON_COIL_CNT,DAY_COIL_WGT ,MON_COIL_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_COIL_CNT,SUM(ACT_WGT) DAY_COIL_WGT  
     
    FROM TBH02_COIL_COMM   
   WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  ((SUBSTR(MILL_DTIME,9,4) > :8 AND SUBSTR(MILL_DTIME,9,4) < '2400') OR (SUBSTR(MILL_DTIME,9,4) > '0000' AND SUBSTR(MILL_DTIME,9,4) < :9))
     AND  SUBSTR(MILL_DTIME,1,8) = :10 
     AND  MILL_DTIME IS NOT NULL 
    
  ) a,   -- daily 
  (
    SELECT   COUNT(*) MON_COIL_CNT,SUM(ACT_WGT) MON_COIL_WGT  
     
    FROM TBH02_COIL_COMM   
     WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  ((SUBSTR(MILL_DTIME,9,4) > :11 AND SUBSTR(MILL_DTIME,9,4) < '2400') OR (SUBSTR(MILL_DTIME,9,4) > '0000' AND SUBSTR(MILL_DTIME,9,4) < :12)) 
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:13,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :14 
     AND  MILL_DTIME IS NOT NULL 
   
  ) b   -- monthly
 )  B,
  
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 1
  SELECT   DAY_GRD_1_CNT,MON_GRD_1_CNT,DAY_GRD_1_WGT,MON_GRD_1_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_1_CNT, SUM(ACT_WGT) DAY_GRD_1_WGT 
    FROM TBH02_COIL_COMM    
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  ((SUBSTR(MILL_DTIME,9,4) > :15 AND SUBSTR(MILL_DTIME,9,4) < '2400') OR (SUBSTR(MILL_DTIME,9,4) > '0000' AND SUBSTR(MILL_DTIME,9,4) < :16)) 
     AND  SUBSTR(MILL_DTIME,1,8) = :17
     AND  MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_1_CNT, SUM(ACT_WGT) MON_GRD_1_WGT 
    FROM TBH02_COIL_COMM    
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  ((SUBSTR(MILL_DTIME,9,4) > :18 AND SUBSTR(MILL_DTIME,9,4) < '2400') OR (SUBSTR(MILL_DTIME,9,4) > '0000' AND SUBSTR(MILL_DTIME,9,4) < :19))
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:20,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :21
     AND  MILL_DTIME IS NOT NULL 
   )  b    -- monthly
   
 ) C,
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 2
  SELECT   DAY_GRD_2_CNT,MON_GRD_2_CNT,DAY_GRD_2_WGT,MON_GRD_2_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_2_CNT, SUM(ACT_WGT) DAY_GRD_2_WGT 
    FROM TBH02_COIL_COMM    
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  ((SUBSTR(MILL_DTIME,9,4) > :22 AND SUBSTR(MILL_DTIME,9,4) < '2400') OR  (SUBSTR(MILL_DTIME,9,4) > '0000' AND SUBSTR(MILL_DTIME,9,4) < :23))
     AND  SUBSTR(MILL_DTIME,1,8) = :24 
     AND  MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_2_CNT, SUM(ACT_WGT) MON_GRD_2_WGT 
    FROM TBH02_COIL_COMM    
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  ((SUBSTR(MILL_DTIME,9,4) > :25 AND SUBSTR(MILL_DTIME,9,4) < '2400') OR (SUBSTR(MILL_DTIME,9,4) > '0000' AND SUBSTR(MILL_DTIME,9,4) < :26))
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:27,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :28  
     AND  MILL_DTIME IS NOT NULL 
   )  b
   
 ) D,
 ( 
   -- reject coil and slab 轧回
   SELECT   DAY_REJ_CNT,MON_REJ_CNT,DAY_REJ_WGT,MON_REJ_WGT
   FROM
  (
    SELECT  COUNT(*) DAY_REJ_CNT, SUM(SLAB_WGT) DAY_REJ_WGT   
     
   FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c 
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
     AND  b.missno_clf = '3'
     AND  ((SUBSTR(MILL_DTIME,9,4) > :29 AND SUBSTR(MILL_DTIME,9,4) < '2400') OR (SUBSTR(MILL_DTIME,9,4) > '0000' AND SUBSTR(MILL_DTIME,9,4) < :30)) 
     AND  SUBSTR(MILL_DTIME,1,8) = :31
     AND  MILL_DTIME IS NOT NULL 
  )  a,  -- daily 
  (
    SELECT COUNT(*) MON_REJ_CNT, SUM(SLAB_WGT) MON_REJ_WGT   
     
    FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c 
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
     AND  b.missno_clf = '3'
     AND  ((SUBSTR(MILL_DTIME,9,4) > :32 AND SUBSTR(MILL_DTIME,9,4) < '2400') OR  (SUBSTR(MILL_DTIME,9,4) > '0000' AND SUBSTR(MILL_DTIME,9,4) < :33))
     AND  SUBSTR(MILL_DTIME,1,8) >= SUBSTR(:34,1,6)||'01' 
     AND  SUBSTR(MILL_DTIME,1,8) <=   :35 
     AND  MILL_DTIME IS NOT NULL 
  )b   -- monthly
 ) E ,

 ( 
  -- scrap weight 废钢
    
   SELECT  DAY_SCRAP_CNT,MON_SCRAP_CNT,DAY_SCRAP_WGT,MON_SCRAP_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SCRAP_CNT, SUM(b.missno_bar_wgt) DAY_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null       
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :36  AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000'  AND SUBSTR(a.MILL_DTIME,9,4) < :37))
          AND  SUBSTR(a.MILL_DTIME,1,8) = :38
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SCRAP_CNT, SUM(b.missno_bar_wgt) MON_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null  
          AND ((SUBSTR(a.MILL_DTIME,9,4) > :39 AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000' AND SUBSTR(a.MILL_DTIME,9,4) < :40)) 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:41,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :42 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) F, 
( 
  -- missno_bar weight  中板
   SELECT  DAY_MISSNO_CNT,MON_MISSNO_CNT,DAY_MISSNO_WGT,MON_MISSNO_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MISSNO_CNT, SUM(b.missno_bar_wgt) DAY_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null       
          AND ((SUBSTR(a.MILL_DTIME,9,4) > :43  AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000'  AND SUBSTR(a.MILL_DTIME,9,4) < :44))
          AND  SUBSTR(a.MILL_DTIME,1,8) = :45
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MISSNO_CNT, SUM(b.missno_bar_wgt) MON_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null  
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :46 AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000' AND SUBSTR(a.MILL_DTIME,9,4) < :47))
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:48,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :49 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) G, 
( 
  -- SIZE_DEC_RST != '1' 
   SELECT  DAY_SIZE_CNT,MON_SIZE_CNT,DAY_SIZE_WGT,MON_SIZE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SIZE_CNT, SUM(a.act_wgt) DAY_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.Size_Dec_Rst != '1'
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :50  AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000'  AND SUBSTR(a.MILL_DTIME,9,4) < :51))
          AND  SUBSTR(a.MILL_DTIME,1,8) = :52
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SIZE_CNT, SUM(a.act_wgt) MON_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.Size_Dec_Rst != '1' 
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :53 AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000' AND SUBSTR(a.MILL_DTIME,9,4) < :54)) 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:55,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :56
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) H,
( 
  -- EXTSHAPE_DEC_GRD != '1' 
   SELECT  DAY_EXTSHAPE_CNT,MON_EXTSHAPE_CNT,DAY_EXTSHAPE_WGT,MON_EXTSHAPE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_EXTSHAPE_CNT, SUM(a.act_wgt) DAY_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.EXTSHAPE_DEC_GRD != '1'
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :57  AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000'  AND SUBSTR(a.MILL_DTIME,9,4) < :58)) 
          AND  SUBSTR(a.MILL_DTIME,1,8) = :59
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_EXTSHAPE_CNT, SUM(a.act_wgt) MON_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.EXTSHAPE_DEC_GRD != '1' 
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :60 AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000' AND SUBSTR(a.MILL_DTIME,9,4) < :61)) 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:62,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :63
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) I,
( 
  -- MATLQLTY_DEC_GRD != '1' 
   SELECT  DAY_MATLQLTY_CNT,MON_MATLQLTY_CNT,DAY_MATLQLTY_WGT,MON_MATLQLTY_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MATLQLTY_CNT, SUM(a.act_wgt) DAY_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.MATLQLTY_DEC_GRD != '1'
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :64  AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000'  AND SUBSTR(a.MILL_DTIME,9,4) < :65))
          AND  SUBSTR(a.MILL_DTIME,1,8) = :66
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MATLQLTY_CNT, SUM(a.act_wgt) MON_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.MATLQLTY_DEC_GRD != '1' 
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :67 AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR  (SUBSTR(a.MILL_DTIME,9,4) > '0000' AND SUBSTR(a.MILL_DTIME,9,4) < :68))
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:69,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :70
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly  
 ) J,
 ( 
  --  钢制
   SELECT  DAY_STL_CNT,MON_STL_CNT,DAY_STL_WGT,MON_STL_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_STL_CNT, SUM(a.act_wgt) DAY_STL_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :71  AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000'  AND SUBSTR(a.MILL_DTIME,9,4) < :72)) 
          AND  SUBSTR(a.MILL_DTIME,1,8) = :73
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_STL_CNT, SUM(a.act_wgt) MON_STL_WGT  
     
     FROM TBH02_COIL_COMM a 
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59') 
          AND  ((SUBSTR(a.MILL_DTIME,9,4) > :74 AND SUBSTR(a.MILL_DTIME,9,4) < '2400') OR (SUBSTR(a.MILL_DTIME,9,4) > '0000' AND SUBSTR(a.MILL_DTIME,9,4) < :75)) 
          AND  SUBSTR(a.MILL_DTIME,1,8) >= SUBSTR(:76,1,6)||'01' 
          AND  SUBSTR(a.MILL_DTIME,1,8) <=   :77 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b 
 ) K
        ]]>
    </query>
	<query id="UIH090060_04.select" desc=" 这里替换原有的统计方式，给出具体的时间段。 " fetchSize="10">
        <![CDATA[		
			SELECT  TO_CHAR(DAY_SLAB_CNT)     DAY_SLAB_CNT    ,TO_CHAR(MON_SLAB_CNT)      MON_SLAB_CNT    ,nvl((DAY_SLAB_WGT/1000),0)            DAY_SLAB_WGT    ,nvl((MON_SLAB_WGT/1000),0)            MON_SLAB_WGT    ,   
        TO_CHAR(DAY_COIL_CNT)     DAY_COIL_CNT    ,TO_CHAR(MON_COIL_CNT)      MON_COIL_CNT    ,nvl((DAY_COIL_WGT/1000),0)            DAY_COIL_WGT    ,nvl((MON_COIL_WGT/1000),0)            MON_COIL_WGT    ,   
        TO_CHAR(DAY_GRD_1_CNT)    DAY_GRD_1_CNT   ,TO_CHAR(MON_GRD_1_CNT)     MON_GRD_1_CNT   ,nvl((DAY_GRD_1_WGT/1000),0)           DAY_GRD_1_WGT   ,nvl((MON_GRD_1_WGT/1000),0)           MON_GRD_1_WGT   ,   
        TO_CHAR(DAY_GRD_2_CNT)    DAY_GRD_2_CNT   ,TO_CHAR(MON_GRD_2_CNT)     MON_GRD_2_CNT   ,nvl((DAY_GRD_2_WGT/1000),0)           DAY_GRD_2_WGT   ,nvl((MON_GRD_2_WGT/1000),0)           MON_GRD_2_WGT   ,   
        TO_CHAR(DAY_REJ_CNT)      DAY_REJ_CNT     ,TO_CHAR(MON_REJ_CNT)       MON_REJ_CNT     ,nvl(TO_CHAR(DAY_REJ_WGT/1000),0)      DAY_REJ_WGT     ,nvl(TO_CHAR(MON_REJ_WGT/1000),0)      MON_REJ_WGT     ,   
        TO_CHAR(DAY_SCRAP_CNT)    DAY_SCRAP_CNT   ,TO_CHAR(MON_SCRAP_CNT)     MON_SCRAP_CNT   ,nvl(TO_CHAR(DAY_SCRAP_WGT/1000),0)    DAY_SCRAP_WGT   ,nvl(TO_CHAR(MON_SCRAP_WGT/1000),0)    MON_SCRAP_WGT   ,
        TO_CHAR(DAY_MISSNO_CNT)   DAY_MISSNO_CNT  ,TO_CHAR(MON_MISSNO_CNT)    MON_MISSNO_CNT  ,nvl(TO_CHAR(DAY_MISSNO_WGT/1000),0)   DAY_MISSNO_WGT  ,nvl(TO_CHAR(MON_MISSNO_WGT/1000),0)   MON_MISSNO_WGT  ,
        TO_CHAR(DAY_SIZE_CNT)     DAY_SIZE_CNT    ,TO_CHAR(MON_SIZE_CNT)      MON_SIZE_CNT    ,nvl((DAY_SIZE_WGT/1000),0)            DAY_SIZE_WGT    ,nvl((MON_SIZE_WGT/1000),0)            MON_SIZE_WGT    ,
        TO_CHAR(DAY_EXTSHAPE_CNT) DAY_EXTSHAPE_CNT,TO_CHAR(MON_EXTSHAPE_CNT)  MON_EXTSHAPE_CNT,nvl((DAY_EXTSHAPE_WGT/1000),0)        DAY_EXTSHAPE_WGT,nvl((MON_EXTSHAPE_WGT/1000),0)        MON_EXTSHAPE_WGT,
        TO_CHAR(DAY_MATLQLTY_CNT) DAY_MATLQLTY_CNT,TO_CHAR(MON_MATLQLTY_CNT)  MON_MATLQLTY_CNT,nvl((DAY_MATLQLTY_WGT/1000),0)        DAY_MATLQLTY_WGT,nvl((MON_MATLQLTY_WGT/1000),0)        MON_MATLQLTY_WGT,
        TO_CHAR(DAY_STL_CNT)      DAY_STL_CNT     ,TO_CHAR(MON_STL_CNT)       MON_STL_CNT     ,nvl((DAY_STL_WGT/1000),0)             DAY_STL_WGT     ,nvl((MON_STL_WGT/1000),0)             MON_STL_WGT
 FROM 
(
   ---  Slab weight,这里统一使用轧制时间即卷取时间来进行统计
  SELECT   DAY_SLAB_CNT,MON_SLAB_CNT,DAY_SLAB_WGT ,MON_SLAB_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_SLAB_CNT, SUM(SLAB_WGT) DAY_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b,
         TBH02_MILL_RESULT C  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  A.SLAB_NO = c.SLAB_NO 
     AND   A.MILL_DTIME >= :1 AND A.MILL_DTIME <= :2
    
  ) a, -- daily 
  (
    SELECT   COUNT(*) MON_SLAB_CNT, SUM(SLAB_WGT) MON_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b,
         TBH02_MILL_RESULT C  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  A.SLAB_NO = C.SLAB_NO
     AND  C.WKGROUP = :3 
     AND  A.MILL_DTIME >= :4
     AND  A.MILL_DTIME <= :5
  ) b -- monthly 
 ) A,
 (
   -- coil weight 
  SELECT   DAY_COIL_CNT,MON_COIL_CNT,DAY_COIL_WGT ,MON_COIL_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_COIL_CNT,SUM(ACT_WGT) DAY_COIL_WGT  
     
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B   
   WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  A.MILL_DTIME >= :6 AND A.MILL_DTIME <= :7
     AND  A.MILL_DTIME IS NOT NULL 
    
  ) a,   -- daily 
  (
    SELECT   COUNT(*) MON_COIL_CNT,SUM(ACT_WGT) MON_COIL_WGT  
     
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B   
     WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  B.WKGROUP = :8
     AND  A.MILL_DTIME >= :9
     AND  A.MILL_DTIME <= :10 
     AND  A.MILL_DTIME IS NOT NULL 
   
  ) b   -- monthly
 )  B,
  
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 1
  SELECT   DAY_GRD_1_CNT,MON_GRD_1_CNT,DAY_GRD_1_WGT,MON_GRD_1_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_1_CNT, SUM(ACT_WGT) DAY_GRD_1_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B    
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  A.MILL_DTIME >= :11 AND A.MILL_DTIME <= :12 
     AND  A.MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_1_CNT, SUM(ACT_WGT) MON_GRD_1_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B      
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO  
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  B.WKGROUP = :13
     AND  A.MILL_DTIME >= :14
     AND  A.MILL_DTIME <= :15
     AND  A.MILL_DTIME IS NOT NULL 
   )  b    -- monthly
   
 ) C,
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 2
  SELECT   DAY_GRD_2_CNT,MON_GRD_2_CNT,DAY_GRD_2_WGT,MON_GRD_2_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_2_CNT, SUM(ACT_WGT) DAY_GRD_2_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B     
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  A.MILL_DTIME >= :16 AND A.MILL_DTIME <= :17 
     AND  A.MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_2_CNT, SUM(ACT_WGT) MON_GRD_2_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B     
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  B.WKGROUP = :18   
     AND  A.MILL_DTIME >= :19
     AND  A.MILL_DTIME <= :20 
     AND  A.MILL_DTIME IS NOT NULL 
   )  b
   
 ) D,
 ( 
   -- reject coil and slab 轧回
   SELECT   DAY_REJ_CNT,MON_REJ_CNT,DAY_REJ_WGT,MON_REJ_WGT
   FROM
  (
    SELECT  COUNT(*) DAY_REJ_CNT, SUM(SLAB_WGT) DAY_REJ_WGT   
     
   FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
	 and  a.coil_no = b.coil_no
     AND  b.missno_clf = '3'
     AND  A.MILL_DTIME >= :21 AND A.MILL_DTIME <= :22
     AND  A.MILL_DTIME IS NOT NULL 
  )  a,  -- daily 
  (
    SELECT COUNT(*) MON_REJ_CNT, SUM(SLAB_WGT) MON_REJ_WGT   
     
    FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c,
	     tbh02_mill_result d
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
	 and  a.slab_no = d.slab_no
     AND  b.missno_clf = '3'
     AND  D.WKGROUP = :23
     AND  A.MILL_DTIME >= :24
     AND  A.MILL_DTIME <= :25 
     AND  A.MILL_DTIME IS NOT NULL 
  )b   -- monthly
 ) E ,

 ( 
  -- scrap weight 废钢
    
   SELECT  DAY_SCRAP_CNT,MON_SCRAP_CNT,DAY_SCRAP_WGT,MON_SCRAP_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SCRAP_CNT, SUM(b.missno_bar_wgt) DAY_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null       
          AND A.MILL_DTIME >= :26  AND A.MILL_DTIME <= :27
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SCRAP_CNT, SUM(b.missno_bar_wgt) MON_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null
          AND  B.WKGROUP = :28  
          AND  A.MILL_DTIME >= :29
          AND  A.MILL_DTIME <= :30 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) F, 
( 
  -- missno_bar weight  中板
   SELECT  DAY_MISSNO_CNT,MON_MISSNO_CNT,DAY_MISSNO_WGT,MON_MISSNO_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MISSNO_CNT, SUM(b.missno_bar_wgt) DAY_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null       
          AND A.MILL_DTIME >= :31  AND A.MILL_DTIME <= :32
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MISSNO_CNT, SUM(b.missno_bar_wgt) MON_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null 
          AND  B.WKGROUP = :33 
          AND  A.MILL_DTIME >= :34 
          AND  A.MILL_DTIME <= :35
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) G, 
( 
  -- SIZE_DEC_RST != '1' 
   SELECT  DAY_SIZE_CNT,MON_SIZE_CNT,DAY_SIZE_WGT,MON_SIZE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SIZE_CNT, SUM(a.act_wgt) DAY_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B 
    WHERE a.Size_Dec_Rst != '1'
	 AND  A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :36  AND A.MILL_DTIME <= :37
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SIZE_CNT, SUM(a.act_wgt) MON_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B  
    WHERE a.Size_Dec_Rst != '1' 
    AND  A.SLAB_NO = B.SLAB_NO
    AND  B.WKGROUP = :38
    AND  A.MILL_DTIME >= :39
     AND  A.MILL_DTIME <= :40
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) H,
( 
  -- EXTSHAPE_DEC_GRD != '1' 
   SELECT  DAY_EXTSHAPE_CNT,MON_EXTSHAPE_CNT,DAY_EXTSHAPE_WGT,MON_EXTSHAPE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_EXTSHAPE_CNT, SUM(a.act_wgt) DAY_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B   
    WHERE a.EXTSHAPE_DEC_GRD != '1'
     AND A.SLAB_NO = B.SLAB_NO  
     AND  A.MILL_DTIME >= :41  AND A.MILL_DTIME <= :42
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_EXTSHAPE_CNT, SUM(a.act_wgt) MON_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a , TBH02_MILL_RESULT B  
    WHERE a.EXTSHAPE_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO 
     AND  B.WKGROUP = :43
     AND  A.MILL_DTIME >= :44
     AND  A.MILL_DTIME <= :45
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) I,
( 
  -- MATLQLTY_DEC_GRD != '1' 
   SELECT  DAY_MATLQLTY_CNT,MON_MATLQLTY_CNT,DAY_MATLQLTY_WGT,MON_MATLQLTY_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MATLQLTY_CNT, SUM(a.act_wgt) DAY_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B 
    WHERE a.MATLQLTY_DEC_GRD != '1'
     AND  A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :46  AND A.MILL_DTIME <= :47
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MATLQLTY_CNT, SUM(a.act_wgt) MON_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B 
    WHERE a.MATLQLTY_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO
     AND  B.WKGROUP = :48
     AND  A.MILL_DTIME >= :49 
     AND  A.MILL_DTIME <= :50
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly  
 ) J,
 ( 
  --  钢制
   SELECT  DAY_STL_CNT,MON_STL_CNT,DAY_STL_WGT,MON_STL_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_STL_CNT, SUM(a.act_wgt) DAY_STL_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B 
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
     AND A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :51 AND A.MILL_DTIME <= :52
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_STL_CNT, SUM(a.act_wgt) MON_STL_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B  
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  B.WKGROUP = :53  
     AND  A.MILL_DTIME >= :54
     AND  A.MILL_DTIME <= :55 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b 
 ) K
        ]]>
    </query>
	<query id="UIH090060_05.select" desc=" 这里替换原有的统计方式，给出具体的时间段。这里计算全天的产量 " fetchSize="10">
        <![CDATA[		
      SELECT  TO_CHAR(DAY_SLAB_CNT)     DAY_SLAB_CNT    ,TO_CHAR(MON_SLAB_CNT)      MON_SLAB_CNT    ,nvl((DAY_SLAB_WGT/1000),0)            DAY_SLAB_WGT    ,nvl((MON_SLAB_WGT/1000),0)            MON_SLAB_WGT    ,   
        TO_CHAR(DAY_COIL_CNT)     DAY_COIL_CNT    ,TO_CHAR(MON_COIL_CNT)      MON_COIL_CNT    ,nvl((DAY_COIL_WGT/1000),0)            DAY_COIL_WGT    ,nvl((MON_COIL_WGT/1000),0)            MON_COIL_WGT    ,   
        TO_CHAR(DAY_GRD_1_CNT)    DAY_GRD_1_CNT   ,TO_CHAR(MON_GRD_1_CNT)     MON_GRD_1_CNT   ,nvl((DAY_GRD_1_WGT/1000),0)           DAY_GRD_1_WGT   ,nvl((MON_GRD_1_WGT/1000),0)           MON_GRD_1_WGT   ,   
        TO_CHAR(DAY_GRD_2_CNT)    DAY_GRD_2_CNT   ,TO_CHAR(MON_GRD_2_CNT)     MON_GRD_2_CNT   ,nvl((DAY_GRD_2_WGT/1000),0)           DAY_GRD_2_WGT   ,nvl((MON_GRD_2_WGT/1000),0)           MON_GRD_2_WGT   ,   
        TO_CHAR(DAY_REJ_CNT)      DAY_REJ_CNT     ,TO_CHAR(MON_REJ_CNT)       MON_REJ_CNT     ,nvl(TO_CHAR(DAY_REJ_WGT/1000),0)      DAY_REJ_WGT     ,nvl(TO_CHAR(MON_REJ_WGT/1000),0)      MON_REJ_WGT     ,   
        TO_CHAR(DAY_SCRAP_CNT)    DAY_SCRAP_CNT   ,TO_CHAR(MON_SCRAP_CNT)     MON_SCRAP_CNT   ,nvl(TO_CHAR(DAY_SCRAP_WGT/1000),0)    DAY_SCRAP_WGT   ,nvl(TO_CHAR(MON_SCRAP_WGT/1000),0)    MON_SCRAP_WGT   ,
        TO_CHAR(DAY_MISSNO_CNT)   DAY_MISSNO_CNT  ,TO_CHAR(MON_MISSNO_CNT)    MON_MISSNO_CNT  ,nvl(TO_CHAR(DAY_MISSNO_WGT/1000),0)   DAY_MISSNO_WGT  ,nvl(TO_CHAR(MON_MISSNO_WGT/1000),0)   MON_MISSNO_WGT  ,
        TO_CHAR(DAY_SIZE_CNT)     DAY_SIZE_CNT    ,TO_CHAR(MON_SIZE_CNT)      MON_SIZE_CNT    ,nvl((DAY_SIZE_WGT/1000),0)            DAY_SIZE_WGT    ,nvl((MON_SIZE_WGT/1000),0)            MON_SIZE_WGT    ,
        TO_CHAR(DAY_EXTSHAPE_CNT) DAY_EXTSHAPE_CNT,TO_CHAR(MON_EXTSHAPE_CNT)  MON_EXTSHAPE_CNT,nvl((DAY_EXTSHAPE_WGT/1000),0)        DAY_EXTSHAPE_WGT,nvl((MON_EXTSHAPE_WGT/1000),0)        MON_EXTSHAPE_WGT,
        TO_CHAR(DAY_MATLQLTY_CNT) DAY_MATLQLTY_CNT,TO_CHAR(MON_MATLQLTY_CNT)  MON_MATLQLTY_CNT,nvl((DAY_MATLQLTY_WGT/1000),0)        DAY_MATLQLTY_WGT,nvl((MON_MATLQLTY_WGT/1000),0)        MON_MATLQLTY_WGT,
        TO_CHAR(DAY_STL_CNT)      DAY_STL_CNT     ,TO_CHAR(MON_STL_CNT)       MON_STL_CNT     ,nvl((DAY_STL_WGT/1000),0)             DAY_STL_WGT     ,nvl((MON_STL_WGT/1000),0)             MON_STL_WGT
 FROM 
(
   ---  Slab weight,这里统一使用轧制时间即卷取时间来进行统计
  SELECT   DAY_SLAB_CNT,MON_SLAB_CNT,DAY_SLAB_WGT ,MON_SLAB_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_SLAB_CNT, SUM(SLAB_WGT) DAY_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b,
         TBH02_MILL_RESULT C  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  A.SLAB_NO = c.SLAB_NO 
     AND   A.MILL_DTIME >= :1 AND A.MILL_DTIME <= :2
    
  ) a, -- daily 
  (
    SELECT   COUNT(*) MON_SLAB_CNT, SUM(SLAB_WGT) MON_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b,
         TBH02_MILL_RESULT C  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  A.SLAB_NO = C.SLAB_NO
     AND  A.MILL_DTIME >= :3
     AND  A.MILL_DTIME <= :4
  ) b -- monthly 
 ) A,
 (
   -- coil weight 
  SELECT   DAY_COIL_CNT,MON_COIL_CNT,DAY_COIL_WGT ,MON_COIL_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_COIL_CNT,SUM(ACT_WGT) DAY_COIL_WGT  
     
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B   
   WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  A.MILL_DTIME >= :5 AND A.MILL_DTIME <= :6
     AND  A.MILL_DTIME IS NOT NULL 
    
  ) a,   -- daily 
  (
    SELECT   COUNT(*) MON_COIL_CNT,SUM(ACT_WGT) MON_COIL_WGT  
     
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B   
     WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  A.MILL_DTIME >= :7
     AND  A.MILL_DTIME <= :8 
     AND  A.MILL_DTIME IS NOT NULL 
   
  ) b   -- monthly
 )  B,
  
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 1
  SELECT   DAY_GRD_1_CNT,MON_GRD_1_CNT,DAY_GRD_1_WGT,MON_GRD_1_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_1_CNT, SUM(ACT_WGT) DAY_GRD_1_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B    
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  A.MILL_DTIME >= :9 AND A.MILL_DTIME <= :10 
     AND  A.MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_1_CNT, SUM(ACT_WGT) MON_GRD_1_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B      
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO  
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  A.MILL_DTIME >= :11
     AND  A.MILL_DTIME <= :12
     AND  A.MILL_DTIME IS NOT NULL 
   )  b    -- monthly
   
 ) C,
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 2
  SELECT   DAY_GRD_2_CNT,MON_GRD_2_CNT,DAY_GRD_2_WGT,MON_GRD_2_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_2_CNT, SUM(ACT_WGT) DAY_GRD_2_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B     
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  A.MILL_DTIME >= :13 AND A.MILL_DTIME <= :14
     AND  A.MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_2_CNT, SUM(ACT_WGT) MON_GRD_2_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B     
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL 
     AND  A.MILL_DTIME >= :15
     AND  A.MILL_DTIME <= :16
     AND  A.MILL_DTIME IS NOT NULL 
   )  b
   
 ) D,
 ( 
   -- reject coil and slab 轧回
   SELECT   DAY_REJ_CNT,MON_REJ_CNT,DAY_REJ_WGT,MON_REJ_WGT
   FROM
  (
    SELECT  COUNT(*) DAY_REJ_CNT, SUM(SLAB_WGT) DAY_REJ_WGT   
     
   FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
	 and  a.coil_no = b.coil_no
     AND  b.missno_clf = '3'
     AND  A.MILL_DTIME >= :17 AND A.MILL_DTIME <= :18
     AND  A.MILL_DTIME IS NOT NULL 
  )  a,  -- daily 
  (
    SELECT COUNT(*) MON_REJ_CNT, SUM(SLAB_WGT) MON_REJ_WGT   
     
    FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c,
         TBH02_MILL_RESULT D  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
     AND  A.SLAB_NO = D.SLAB_NO 
     AND  b.missno_clf = '3'
     AND  A.MILL_DTIME >= :19
     AND  A.MILL_DTIME <= :20 
     AND  A.MILL_DTIME IS NOT NULL 
  )b   -- monthly
 ) E ,

 ( 
  -- scrap weight 废钢
    
   SELECT  DAY_SCRAP_CNT,MON_SCRAP_CNT,DAY_SCRAP_WGT,MON_SCRAP_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SCRAP_CNT, SUM(b.missno_bar_wgt) DAY_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null       
          AND A.MILL_DTIME >= :21  AND A.MILL_DTIME <= :22
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SCRAP_CNT, SUM(b.missno_bar_wgt) MON_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null
          AND  A.MILL_DTIME >= :23
          AND  A.MILL_DTIME <= :24 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) F, 
( 
  -- missno_bar weight  中板
   SELECT  DAY_MISSNO_CNT,MON_MISSNO_CNT,DAY_MISSNO_WGT,MON_MISSNO_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MISSNO_CNT, SUM(b.missno_bar_wgt) DAY_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null       
          AND A.MILL_DTIME >= :25  AND A.MILL_DTIME <= :26
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MISSNO_CNT, SUM(b.missno_bar_wgt) MON_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null 
          AND  A.MILL_DTIME >= :27 
          AND  A.MILL_DTIME <= :28
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) G, 
( 
  -- SIZE_DEC_RST != '1' 
   SELECT  DAY_SIZE_CNT,MON_SIZE_CNT,DAY_SIZE_WGT,MON_SIZE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SIZE_CNT, SUM(a.act_wgt) DAY_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B 
    WHERE a.Size_Dec_Rst != '1'
	 AND a.slab_no = b.slab_no
     AND  A.MILL_DTIME >= :29  AND A.MILL_DTIME <= :30
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SIZE_CNT, SUM(a.act_wgt) MON_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B  
    WHERE a.Size_Dec_Rst != '1' 
    AND  A.SLAB_NO = B.SLAB_NO
    AND  A.MILL_DTIME >= :31
     AND  A.MILL_DTIME <= :32
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) H,
( 
  -- EXTSHAPE_DEC_GRD != '1' 
   SELECT  DAY_EXTSHAPE_CNT,MON_EXTSHAPE_CNT,DAY_EXTSHAPE_WGT,MON_EXTSHAPE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_EXTSHAPE_CNT, SUM(a.act_wgt) DAY_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B   
    WHERE a.EXTSHAPE_DEC_GRD != '1'
     AND A.SLAB_NO = B.SLAB_NO  
     AND  A.MILL_DTIME >= :33  AND A.MILL_DTIME <= :34
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_EXTSHAPE_CNT, SUM(a.act_wgt) MON_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a , TBH02_MILL_RESULT B  
    WHERE a.EXTSHAPE_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO 
     AND  A.MILL_DTIME >= :35
     AND  A.MILL_DTIME <= :36
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) I,
( 
  -- MATLQLTY_DEC_GRD != '1' 
   SELECT  DAY_MATLQLTY_CNT,MON_MATLQLTY_CNT,DAY_MATLQLTY_WGT,MON_MATLQLTY_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MATLQLTY_CNT, SUM(a.act_wgt) DAY_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B 
    WHERE a.MATLQLTY_DEC_GRD != '1'
     AND  A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :37  AND A.MILL_DTIME <= :38
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MATLQLTY_CNT, SUM(a.act_wgt) MON_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B 
    WHERE a.MATLQLTY_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :39 
     AND  A.MILL_DTIME <= :40
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly  
 ) J,
 ( 
  --  钢制
   SELECT  DAY_STL_CNT,MON_STL_CNT,DAY_STL_WGT,MON_STL_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_STL_CNT, SUM(a.act_wgt) DAY_STL_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B 
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
     AND A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :41 AND A.MILL_DTIME <= :42
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_STL_CNT, SUM(a.act_wgt) MON_STL_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B  
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  A.MILL_DTIME >= :43
     AND  A.MILL_DTIME <= :44
     AND  a.MILL_DTIME IS NOT NULL 
  ) b 
 ) K
        ]]>
    </query>
	<query id="UIH090060_06.select" desc=" 这里给出周的统计方式，取时间段计算 " fetchSize="10">
        <![CDATA[		
SELECT  TO_CHAR(DAY_SLAB_CNT)     DAY_SLAB_CNT    ,TO_CHAR(MON_SLAB_CNT)      MON_SLAB_CNT    ,nvl((DAY_SLAB_WGT/1000),0)            DAY_SLAB_WGT    ,nvl((MON_SLAB_WGT/1000),0)            MON_SLAB_WGT    ,   
        TO_CHAR(DAY_COIL_CNT)     DAY_COIL_CNT    ,TO_CHAR(MON_COIL_CNT)      MON_COIL_CNT    ,nvl((DAY_COIL_WGT/1000),0)            DAY_COIL_WGT    ,nvl((MON_COIL_WGT/1000),0)            MON_COIL_WGT    ,   
        TO_CHAR(DAY_GRD_1_CNT)    DAY_GRD_1_CNT   ,TO_CHAR(MON_GRD_1_CNT)     MON_GRD_1_CNT   ,nvl((DAY_GRD_1_WGT/1000),0)           DAY_GRD_1_WGT   ,nvl((MON_GRD_1_WGT/1000),0)           MON_GRD_1_WGT   ,   
        TO_CHAR(DAY_GRD_2_CNT)    DAY_GRD_2_CNT   ,TO_CHAR(MON_GRD_2_CNT)     MON_GRD_2_CNT   ,nvl((DAY_GRD_2_WGT/1000),0)           DAY_GRD_2_WGT   ,nvl((MON_GRD_2_WGT/1000),0)           MON_GRD_2_WGT   ,   
        TO_CHAR(DAY_REJ_CNT)      DAY_REJ_CNT     ,TO_CHAR(MON_REJ_CNT)       MON_REJ_CNT     ,nvl(TO_CHAR(DAY_REJ_WGT/1000),0)      DAY_REJ_WGT     ,nvl(TO_CHAR(MON_REJ_WGT/1000),0)      MON_REJ_WGT     ,   
        TO_CHAR(DAY_SCRAP_CNT)    DAY_SCRAP_CNT   ,TO_CHAR(MON_SCRAP_CNT)     MON_SCRAP_CNT   ,nvl(TO_CHAR(DAY_SCRAP_WGT/1000),0)    DAY_SCRAP_WGT   ,nvl(TO_CHAR(MON_SCRAP_WGT/1000),0)    MON_SCRAP_WGT   ,
        TO_CHAR(DAY_MISSNO_CNT)   DAY_MISSNO_CNT  ,TO_CHAR(MON_MISSNO_CNT)    MON_MISSNO_CNT  ,nvl(TO_CHAR(DAY_MISSNO_WGT/1000),0)   DAY_MISSNO_WGT  ,nvl(TO_CHAR(MON_MISSNO_WGT/1000),0)   MON_MISSNO_WGT  ,
        TO_CHAR(DAY_SIZE_CNT)     DAY_SIZE_CNT    ,TO_CHAR(MON_SIZE_CNT)      MON_SIZE_CNT    ,nvl((DAY_SIZE_WGT/1000),0)            DAY_SIZE_WGT    ,nvl((MON_SIZE_WGT/1000),0)            MON_SIZE_WGT    ,
        TO_CHAR(DAY_EXTSHAPE_CNT) DAY_EXTSHAPE_CNT,TO_CHAR(MON_EXTSHAPE_CNT)  MON_EXTSHAPE_CNT,nvl((DAY_EXTSHAPE_WGT/1000),0)        DAY_EXTSHAPE_WGT,nvl((MON_EXTSHAPE_WGT/1000),0)        MON_EXTSHAPE_WGT,
        TO_CHAR(DAY_MATLQLTY_CNT) DAY_MATLQLTY_CNT,TO_CHAR(MON_MATLQLTY_CNT)  MON_MATLQLTY_CNT,nvl((DAY_MATLQLTY_WGT/1000),0)        DAY_MATLQLTY_WGT,nvl((MON_MATLQLTY_WGT/1000),0)        MON_MATLQLTY_WGT,
        TO_CHAR(DAY_STL_CNT)      DAY_STL_CNT     ,TO_CHAR(MON_STL_CNT)       MON_STL_CNT     ,nvl((DAY_STL_WGT/1000),0)             DAY_STL_WGT     ,nvl((MON_STL_WGT/1000),0)             MON_STL_WGT
 FROM 
(
   ---  Slab weight,这里统一使用轧制时间即卷取时间来进行统计
  SELECT   DAY_SLAB_CNT,MON_SLAB_CNT,DAY_SLAB_WGT ,MON_SLAB_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_SLAB_CNT, SUM(SLAB_WGT) DAY_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b,
         TBH02_MILL_RESULT C  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  A.SLAB_NO = c.SLAB_NO 
     AND  C.WKGROUP = :1 
     AND  A.MILL_DTIME >= :2 AND A.MILL_DTIME <= :3
      
    
  ) a, -- daily 
  (
    SELECT   COUNT(*) MON_SLAB_CNT, SUM(SLAB_WGT) MON_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b,
         TBH02_MILL_RESULT C  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  A.SLAB_NO = C.SLAB_NO
     AND  C.WKGROUP = :4 
     AND  A.MILL_DTIME >= :5
     AND  A.MILL_DTIME <= :6
  ) b -- monthly 
 ) A,
 (
   -- coil weight 
  SELECT   DAY_COIL_CNT,MON_COIL_CNT,DAY_COIL_WGT ,MON_COIL_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_COIL_CNT,SUM(ACT_WGT) DAY_COIL_WGT  
     
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B   
   WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  B.WKGROUP = :7 
     AND  A.MILL_DTIME >= :8 AND A.MILL_DTIME <= :9
     AND  A.MILL_DTIME IS NOT NULL 
    
  ) a,   -- daily 
  (
    SELECT   COUNT(*) MON_COIL_CNT,SUM(ACT_WGT) MON_COIL_WGT  
     
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B   
     WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  B.WKGROUP = :10
     AND  A.MILL_DTIME >= :11
     AND  A.MILL_DTIME <= :12 
     AND  A.MILL_DTIME IS NOT NULL 
   
  ) b   -- monthly
 )  B,
  
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 1
  SELECT   DAY_GRD_1_CNT,MON_GRD_1_CNT,DAY_GRD_1_WGT,MON_GRD_1_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_1_CNT, SUM(ACT_WGT) DAY_GRD_1_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B    
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  B.WKGROUP = :13   
     AND  A.MILL_DTIME >= :14 AND A.MILL_DTIME <= :15 
     AND  A.MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_1_CNT, SUM(ACT_WGT) MON_GRD_1_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B      
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO  
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  B.WKGROUP = :16
     AND  A.MILL_DTIME >= :17
     AND  A.MILL_DTIME <= :18
     AND  A.MILL_DTIME IS NOT NULL 
   )  b    -- monthly
   
 ) C,
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 2
  SELECT   DAY_GRD_2_CNT,MON_GRD_2_CNT,DAY_GRD_2_WGT,MON_GRD_2_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_2_CNT, SUM(ACT_WGT) DAY_GRD_2_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B     
    WHERE EXTSHAPE_DEC_GRD != '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL 
     AND  B.WKGROUP = :19  
     AND  A.MILL_DTIME >= :20 AND A.MILL_DTIME <= :21 
     AND  A.MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_2_CNT, SUM(ACT_WGT) MON_GRD_2_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B     
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  B.WKGROUP = :22   
     AND  A.MILL_DTIME >= :23
     AND  A.MILL_DTIME <= :24 
     AND  A.MILL_DTIME IS NOT NULL 
   )  b
   
 ) D,
 ( 
   -- reject coil and slab 轧回
   SELECT   DAY_REJ_CNT,MON_REJ_CNT,DAY_REJ_WGT,MON_REJ_WGT
   FROM
  (
    SELECT  COUNT(*) DAY_REJ_CNT, SUM(SLAB_WGT) DAY_REJ_WGT   
     
   FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
   and  a.coil_no = b.coil_no
     AND  b.missno_clf = '3'
     AND  B.MISSNO_WKGROUP = :25
     AND  A.MILL_DTIME >= :26 AND A.MILL_DTIME <= :27
     AND  A.MILL_DTIME IS NOT NULL 
  )  a,  -- daily 
  (
    SELECT COUNT(*) MON_REJ_CNT, SUM(SLAB_WGT) MON_REJ_WGT   
     
    FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
     AND  b.missno_clf = '3'
     AND  B.MISSNO_WKGROUP = :28
     AND  A.MILL_DTIME >= :29
     AND  A.MILL_DTIME <= :30 
     AND  A.MILL_DTIME IS NOT NULL 
  )b   -- monthly
 ) E ,

 ( 
  -- scrap weight 废钢
    
   SELECT  DAY_SCRAP_CNT,MON_SCRAP_CNT,DAY_SCRAP_WGT,MON_SCRAP_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SCRAP_CNT, SUM(b.missno_bar_wgt) DAY_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null 
          AND B.WKGROUP = :31      
          AND A.MILL_DTIME >= :32  AND A.MILL_DTIME <= :33
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SCRAP_CNT, SUM(b.missno_bar_wgt) MON_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null
          AND  B.WKGROUP = :34  
          AND  A.MILL_DTIME >= :35
          AND  A.MILL_DTIME <= :36 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) F, 
( 
  -- missno_bar weight  中板
   SELECT  DAY_MISSNO_CNT,MON_MISSNO_CNT,DAY_MISSNO_WGT,MON_MISSNO_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MISSNO_CNT, SUM(b.missno_bar_wgt) DAY_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null    
          AND B.WKGROUP = :37   
          AND A.MILL_DTIME >= :38  AND A.MILL_DTIME <= :39
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MISSNO_CNT, SUM(b.missno_bar_wgt) MON_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null 
          AND  B.WKGROUP = :40 
          AND  A.MILL_DTIME >= :41 
          AND  A.MILL_DTIME <= :42
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) G, 
( 
  -- SIZE_DEC_RST != '1' 
   SELECT  DAY_SIZE_CNT,MON_SIZE_CNT,DAY_SIZE_WGT,MON_SIZE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SIZE_CNT, SUM(a.act_wgt) DAY_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B 
    WHERE a.Size_Dec_Rst != '1'
     AND  A.SLAB_NO = B.SLAB_NO
     AND  B.WKGROUP = :43
     AND  A.MILL_DTIME >= :44  AND A.MILL_DTIME <= :45
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SIZE_CNT, SUM(a.act_wgt) MON_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B  
    WHERE a.Size_Dec_Rst != '1' 
    AND  A.SLAB_NO = B.SLAB_NO
    AND  B.WKGROUP = :46
    AND  A.MILL_DTIME >= :47
     AND  A.MILL_DTIME <= :48
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) H,
( 
  -- EXTSHAPE_DEC_GRD != '1' 
   SELECT  DAY_EXTSHAPE_CNT,MON_EXTSHAPE_CNT,DAY_EXTSHAPE_WGT,MON_EXTSHAPE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_EXTSHAPE_CNT, SUM(a.act_wgt) DAY_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B   
    WHERE a.EXTSHAPE_DEC_GRD != '1'
     AND  A.SLAB_NO = B.SLAB_NO  
     AND  B.WKGROUP = :49
     AND  A.MILL_DTIME >= :50  AND A.MILL_DTIME <= :51
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_EXTSHAPE_CNT, SUM(a.act_wgt) MON_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a , TBH02_MILL_RESULT B  
    WHERE a.EXTSHAPE_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO 
     AND  B.WKGROUP = :52
     AND  A.MILL_DTIME >= :53
     AND  A.MILL_DTIME <= :54
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) I,
( 
  -- MATLQLTY_DEC_GRD != '1' 
   SELECT  DAY_MATLQLTY_CNT,MON_MATLQLTY_CNT,DAY_MATLQLTY_WGT,MON_MATLQLTY_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MATLQLTY_CNT, SUM(a.act_wgt) DAY_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B 
    WHERE a.MATLQLTY_DEC_GRD != '1'
     AND  A.SLAB_NO = B.SLAB_NO
     AND  B.WKGROUP = :55
     AND  A.MILL_DTIME >= :56  AND A.MILL_DTIME <= :57
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MATLQLTY_CNT, SUM(a.act_wgt) MON_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B 
    WHERE a.MATLQLTY_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO
     AND  B.WKGROUP = :58
     AND  A.MILL_DTIME >= :59 
     AND  A.MILL_DTIME <= :60
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly  
 ) J,
 ( 
  --  钢制
   SELECT  DAY_STL_CNT,MON_STL_CNT,DAY_STL_WGT,MON_STL_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_STL_CNT, SUM(a.act_wgt) DAY_STL_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B 
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
     AND A.SLAB_NO = B.SLAB_NO
     AND  B.WKGROUP = :61
     AND  A.MILL_DTIME >= :62 AND A.MILL_DTIME <= :63
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_STL_CNT, SUM(a.act_wgt) MON_STL_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B  
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  B.WKGROUP = :64  
     AND  A.MILL_DTIME >= :65
     AND  A.MILL_DTIME <= :66 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b 
 ) K
        ]]>
    </query>
	<query id="UIH090060_07.select" desc=" 这里替换原有的统计方式，给出具体的时间段。并且加入能耗和停轧时间的查询  废弃 " fetchSize="10">
        <![CDATA[		
      SELECT  TO_CHAR(DAY_SLAB_CNT)     DAY_SLAB_CNT    ,TO_CHAR(MON_SLAB_CNT)      MON_SLAB_CNT    ,nvl((DAY_SLAB_WGT/1000),0)            DAY_SLAB_WGT    ,nvl((MON_SLAB_WGT/1000),0)            MON_SLAB_WGT    ,   
        TO_CHAR(DAY_COIL_CNT)     DAY_COIL_CNT    ,TO_CHAR(MON_COIL_CNT)      MON_COIL_CNT    ,nvl((DAY_COIL_WGT/1000),0)            DAY_COIL_WGT    ,nvl((MON_COIL_WGT/1000),0)            MON_COIL_WGT    ,   
        TO_CHAR(DAY_GRD_1_CNT)    DAY_GRD_1_CNT   ,TO_CHAR(MON_GRD_1_CNT)     MON_GRD_1_CNT   ,nvl((DAY_GRD_1_WGT/1000),0)           DAY_GRD_1_WGT   ,nvl((MON_GRD_1_WGT/1000),0)           MON_GRD_1_WGT   ,   
        TO_CHAR(DAY_GRD_2_CNT)    DAY_GRD_2_CNT   ,TO_CHAR(MON_GRD_2_CNT)     MON_GRD_2_CNT   ,nvl((DAY_GRD_2_WGT/1000),0)           DAY_GRD_2_WGT   ,nvl((MON_GRD_2_WGT/1000),0)           MON_GRD_2_WGT   ,   
        TO_CHAR(DAY_REJ_CNT)      DAY_REJ_CNT     ,TO_CHAR(MON_REJ_CNT)       MON_REJ_CNT     ,nvl(TO_CHAR(DAY_REJ_WGT/1000),0)      DAY_REJ_WGT     ,nvl(TO_CHAR(MON_REJ_WGT/1000),0)      MON_REJ_WGT     ,   
        TO_CHAR(DAY_SCRAP_CNT)    DAY_SCRAP_CNT   ,TO_CHAR(MON_SCRAP_CNT)     MON_SCRAP_CNT   ,nvl(TO_CHAR(DAY_SCRAP_WGT/1000),0)    DAY_SCRAP_WGT   ,nvl(TO_CHAR(MON_SCRAP_WGT/1000),0)    MON_SCRAP_WGT   ,
        TO_CHAR(DAY_MISSNO_CNT)   DAY_MISSNO_CNT  ,TO_CHAR(MON_MISSNO_CNT)    MON_MISSNO_CNT  ,nvl(TO_CHAR(DAY_MISSNO_WGT/1000),0)   DAY_MISSNO_WGT  ,nvl(TO_CHAR(MON_MISSNO_WGT/1000),0)   MON_MISSNO_WGT  ,
        TO_CHAR(DAY_SIZE_CNT)     DAY_SIZE_CNT    ,TO_CHAR(MON_SIZE_CNT)      MON_SIZE_CNT    ,nvl((DAY_SIZE_WGT/1000),0)            DAY_SIZE_WGT    ,nvl((MON_SIZE_WGT/1000),0)            MON_SIZE_WGT    ,
        TO_CHAR(DAY_EXTSHAPE_CNT) DAY_EXTSHAPE_CNT,TO_CHAR(MON_EXTSHAPE_CNT)  MON_EXTSHAPE_CNT,nvl((DAY_EXTSHAPE_WGT/1000),0)        DAY_EXTSHAPE_WGT,nvl((MON_EXTSHAPE_WGT/1000),0)        MON_EXTSHAPE_WGT,
        TO_CHAR(DAY_MATLQLTY_CNT) DAY_MATLQLTY_CNT,TO_CHAR(MON_MATLQLTY_CNT)  MON_MATLQLTY_CNT,nvl((DAY_MATLQLTY_WGT/1000),0)        DAY_MATLQLTY_WGT,nvl((MON_MATLQLTY_WGT/1000),0)        MON_MATLQLTY_WGT,
        TO_CHAR(DAY_STL_CNT)      DAY_STL_CNT     ,TO_CHAR(MON_STL_CNT)       MON_STL_CNT     ,nvl((DAY_STL_WGT/1000),0)             DAY_STL_WGT     ,nvl((MON_STL_WGT/1000),0)             MON_STL_WGT,
        TO_CHAR(MQ) MQ,TO_CHAR(MON_MQ) MON_MQ,
        TO_CHAR(DIAN) DIAN,TO_CHAR(MON_DIAN) MON_DIAN,
        TO_CHAR(SHUI) SHUI,TO_CHAR(MON_SHUI) MON_SHUI,
        TO_CHAR(KQ) KQ,TO_CHAR(MON_KQ) MON_KQ,
        TO_CHAR(GH) GH,TO_CHAR(MON_GH) MON_GH,
        TO_CHAR(JIXIE) JIXIE,TO_CHAR(MON_JIXIE) MON_JIXIE,
        TO_CHAR(DQ) DQ,TO_CHAR(MON_DQ) MON_DQ,
        TO_CHAR(ZG) ZG,TO_CHAR(MON_ZG) MON_ZG,
        TO_CHAR(HG) HG,TO_CHAR(MON_HG) MON_HG,
        TO_CHAR(JIANXIU) JIANXIU,TO_CHAR(MON_JIANXIU) MON_JIANXIU,
        TO_CHAR(WB) WB,TO_CHAR(MON_WB) MON_WB,
        TO_CHAR(YC) YC,TO_CHAR(MON_YC) MON_YC,
        
 FROM 
(
   ---  Slab weight,这里统一使用轧制时间即卷取时间来进行统计
  SELECT   DAY_SLAB_CNT,MON_SLAB_CNT,DAY_SLAB_WGT ,MON_SLAB_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_SLAB_CNT, SUM(SLAB_WGT) DAY_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b,
         TBH02_MILL_RESULT C  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  A.SLAB_NO = c.SLAB_NO 
     AND   A.MILL_DTIME >= :1 AND A.MILL_DTIME <= :2
    
  ) a, -- daily 
  (
    SELECT   COUNT(*) MON_SLAB_CNT, SUM(SLAB_WGT) MON_SLAB_WGT   
     
    FROM TBH02_COIL_COMM a,
         TBG02_SLAB_COMM b,
         TBH02_MILL_RESULT C  
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  A.SLAB_NO = C.SLAB_NO
     AND  C.WKGROUP = :3 
     AND  A.MILL_DTIME >= :4
     AND  A.MILL_DTIME <= :5
  ) b -- monthly 
 ) A,
 (
   -- coil weight 
  SELECT   DAY_COIL_CNT,MON_COIL_CNT,DAY_COIL_WGT ,MON_COIL_WGT
   FROM
  (
    SELECT   COUNT(*) DAY_COIL_CNT,SUM(ACT_WGT) DAY_COIL_WGT  
     
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B   
   WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  A.MILL_DTIME >= :6 AND A.MILL_DTIME <= :7
     AND  A.MILL_DTIME IS NOT NULL 
    
  ) a,   -- daily 
  (
    SELECT   COUNT(*) MON_COIL_CNT,SUM(ACT_WGT) MON_COIL_WGT  
     
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B   
     WHERE   EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  B.WKGROUP = :8
     AND  A.MILL_DTIME >= :9
     AND  A.MILL_DTIME <= :10 
     AND  A.MILL_DTIME IS NOT NULL 
   
  ) b   -- monthly
 )  B,
  
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 1
  SELECT   DAY_GRD_1_CNT,MON_GRD_1_CNT,DAY_GRD_1_WGT,MON_GRD_1_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_1_CNT, SUM(ACT_WGT) DAY_GRD_1_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B    
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  A.MILL_DTIME >= :11 AND A.MILL_DTIME <= :12 
     AND  A.MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_1_CNT, SUM(ACT_WGT) MON_GRD_1_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B      
    WHERE  EXTSHAPE_DEC_GRD = '1' 
     AND  A.SLAB_NO = B.SLAB_NO  
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  B.WKGROUP = :13
     AND  A.MILL_DTIME >= :14
     AND  A.MILL_DTIME <= :15
     AND  A.MILL_DTIME IS NOT NULL 
   )  b    -- monthly
   
 ) C,
 ( 
  -- EXTSHAPE_DEC_GRD decision  grade 2
  SELECT   DAY_GRD_2_CNT,MON_GRD_2_CNT,DAY_GRD_2_WGT,MON_GRD_2_WGT
   FROM
   (
    SELECT   COUNT(*) DAY_GRD_2_CNT, SUM(ACT_WGT) DAY_GRD_2_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B     
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL   
     AND  A.MILL_DTIME >= :16 AND A.MILL_DTIME <= :17 
     AND  A.MILL_DTIME IS NOT NULL 
   )  a,  -- daily 
   (
    SELECT   COUNT(*) MON_GRD_2_CNT, SUM(ACT_WGT) MON_GRD_2_WGT 
    FROM TBH02_COIL_COMM A,TBH02_MILL_RESULT B     
    WHERE  EXTSHAPE_DEC_GRD != '1' 
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  EXTSHAPE_DEC_GRD  IS NOT NULL
     AND  B.WKGROUP = :18   
     AND  A.MILL_DTIME >= :19
     AND  A.MILL_DTIME <= :20 
     AND  A.MILL_DTIME IS NOT NULL 
   )  b
   
 ) D,
 ( 
   -- reject coil and slab 轧回
   SELECT   DAY_REJ_CNT,MON_REJ_CNT,DAY_REJ_WGT,MON_REJ_WGT
   FROM
  (
    SELECT  COUNT(*) DAY_REJ_CNT, SUM(SLAB_WGT) DAY_REJ_WGT   
     
   FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
   and  a.coil_no = b.coil_no
     AND  b.missno_clf = '3'
     AND  A.MILL_DTIME >= :21 AND A.MILL_DTIME <= :22
     AND  A.MILL_DTIME IS NOT NULL 
  )  a,  -- daily 
  (
    SELECT COUNT(*) MON_REJ_CNT, SUM(SLAB_WGT) MON_REJ_WGT   
     
    FROM TBH02_COIL_COMM a,
         tbh02_rhf_missno b,
         tbg02_slab_comm c,
       tbh02_mill_result d
   WHERE  a.SLAB_NO = b.SLAB_NO
     AND  a.slab_no = c.slab_no
   and  a.slab_no = d.slab_no
     AND  b.missno_clf = '3'
     AND  D.WKGROUP = :23
     AND  A.MILL_DTIME >= :24
     AND  A.MILL_DTIME <= :25 
     AND  A.MILL_DTIME IS NOT NULL 
  )b   -- monthly
 ) E ,

 ( 
  -- scrap weight 废钢
    
   SELECT  DAY_SCRAP_CNT,MON_SCRAP_CNT,DAY_SCRAP_WGT,MON_SCRAP_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SCRAP_CNT, SUM(b.missno_bar_wgt) DAY_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null       
          AND A.MILL_DTIME >= :26  AND A.MILL_DTIME <= :27
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SCRAP_CNT, SUM(b.missno_bar_wgt) MON_SCRAP_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is null
          and b.missno_bar_wth is null
          AND  B.WKGROUP = :28  
          AND  A.MILL_DTIME >= :29
          AND  A.MILL_DTIME <= :30 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) F, 
( 
  -- missno_bar weight  中板
   SELECT  DAY_MISSNO_CNT,MON_MISSNO_CNT,DAY_MISSNO_WGT,MON_MISSNO_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MISSNO_CNT, SUM(b.missno_bar_wgt) DAY_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null       
          AND A.MILL_DTIME >= :31  AND A.MILL_DTIME <= :32
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MISSNO_CNT, SUM(b.missno_bar_wgt) MON_MISSNO_WGT  
     
     FROM TBH02_COIL_COMM a,
          TBH02_MILL_RESULT b   
    WHERE  a.slab_no = b.slab_no
          and b.missno_bar_wgt is not null
          and b.missno_bar_thk is not null
          and b.missno_bar_wth is not null 
          AND  B.WKGROUP = :33 
          AND  A.MILL_DTIME >= :34 
          AND  A.MILL_DTIME <= :35
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) G, 
( 
  -- SIZE_DEC_RST != '1' 
   SELECT  DAY_SIZE_CNT,MON_SIZE_CNT,DAY_SIZE_WGT,MON_SIZE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_SIZE_CNT, SUM(a.act_wgt) DAY_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B 
    WHERE a.Size_Dec_Rst != '1'
   AND  A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :36  AND A.MILL_DTIME <= :37
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_SIZE_CNT, SUM(a.act_wgt) MON_SIZE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B  
    WHERE a.Size_Dec_Rst != '1' 
    AND  A.SLAB_NO = B.SLAB_NO
    AND  B.WKGROUP = :38
    AND  A.MILL_DTIME >= :39
     AND  A.MILL_DTIME <= :40
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) H,
( 
  -- EXTSHAPE_DEC_GRD != '1' 
   SELECT  DAY_EXTSHAPE_CNT,MON_EXTSHAPE_CNT,DAY_EXTSHAPE_WGT,MON_EXTSHAPE_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_EXTSHAPE_CNT, SUM(a.act_wgt) DAY_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B   
    WHERE a.EXTSHAPE_DEC_GRD != '1'
     AND A.SLAB_NO = B.SLAB_NO  
     AND  A.MILL_DTIME >= :41  AND A.MILL_DTIME <= :42
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_EXTSHAPE_CNT, SUM(a.act_wgt) MON_EXTSHAPE_WGT  
     
     FROM TBH02_COIL_COMM a , TBH02_MILL_RESULT B  
    WHERE a.EXTSHAPE_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO 
     AND  B.WKGROUP = :43
     AND  A.MILL_DTIME >= :44
     AND  A.MILL_DTIME <= :45
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly
 ) I,
( 
  -- MATLQLTY_DEC_GRD != '1' 
   SELECT  DAY_MATLQLTY_CNT,MON_MATLQLTY_CNT,DAY_MATLQLTY_WGT,MON_MATLQLTY_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_MATLQLTY_CNT, SUM(a.act_wgt) DAY_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B 
    WHERE a.MATLQLTY_DEC_GRD != '1'
     AND  A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :46  AND A.MILL_DTIME <= :47
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_MATLQLTY_CNT, SUM(a.act_wgt) MON_MATLQLTY_WGT  
     
     FROM TBH02_COIL_COMM a,TBH02_MILL_RESULT B 
    WHERE a.MATLQLTY_DEC_GRD != '1' 
     AND A.SLAB_NO = B.SLAB_NO
     AND  B.WKGROUP = :48
     AND  A.MILL_DTIME >= :49 
     AND  A.MILL_DTIME <= :50
     AND  a.MILL_DTIME IS NOT NULL 
  ) b   -- monthly  
 ) J,
 ( 
  --  钢制
   SELECT  DAY_STL_CNT,MON_STL_CNT,DAY_STL_WGT,MON_STL_WGT
   FROM
  (
    SELECT     COUNT(*) DAY_STL_CNT, SUM(a.act_wgt) DAY_STL_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B 
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
     AND A.SLAB_NO = B.SLAB_NO
     AND  A.MILL_DTIME >= :51 AND A.MILL_DTIME <= :52
     AND  a.MILL_DTIME IS NOT NULL 
  ) a,  -- daily 
  (
    SELECT    COUNT(*) MON_STL_CNT, SUM(a.act_wgt) MON_STL_WGT  
     
     FROM TBH02_COIL_COMM a ,TBH02_MILL_RESULT B  
    WHERE a.CRK_CD1 in ('37','38','42','11','06','57','59')
     AND  A.SLAB_NO = B.SLAB_NO 
     AND  B.WKGROUP = :53  
     AND  A.MILL_DTIME >= :54
     AND  A.MILL_DTIME <= :55 
     AND  a.MILL_DTIME IS NOT NULL 
  ) b 
 ) K,
 --煤气能耗量
    SELECT  MQ,MON_MQ
   FROM
  (
    SELECT LOG_VALUE MQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '1' 
           AND T.LOG_GROUP = :56
           AND T.DTIME     = :57
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_MQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '1' 
     AND  T.LOG_GROUP = :58  
     AND  T.DTIME >= :59
     AND  T.DTIME <= :60 
  ) b 
 ) L,
  --电能耗量
    SELECT  DIAN,MON_DIAN
   FROM
  (
    SELECT LOG_VALUE DIAN
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '2' 
           AND T.LOG_GROUP = :61
           AND T.DTIME     = :62
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_DIAN  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '2' 
     AND  T.LOG_GROUP = :63 
     AND  DTIME >= :64
     AND  DTIME <= :65 
  ) b 
 ) M,
   --水能耗量
    SELECT  SHUI,MON_SHUI
   FROM
  (
    SELECT LOG_VALUE SHUI
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '3' 
           AND T.LOG_GROUP = :66
           AND T.DTIME     = :67
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_SHUI  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '3' 
     AND  T.LOG_GROUP = :68 
     AND  DTIME >= :69
     AND  DTIME <= :70 
  ) b 
 ) N,
    --压缩空气耗量
    SELECT  KQ,MON_KQ
   FROM
  (
    SELECT LOG_VALUE KQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '4' 
           AND T.LOG_GROUP = :71
           AND T.DTIME     = :72
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_KQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '4' 
     AND  T.LOG_GROUP = :73 
     AND  DTIME >= :74 
     AND  DTIME <= :75
  ) b 
 ) O,
     --辊耗耗量
    SELECT  GH,MON_GH
   FROM
  (
    SELECT LOG_VALUE GH
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '5' 
           AND T.LOG_GROUP = :76
           AND T.DTIME     = :77
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_GH  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '5' 
     AND  T.LOG_GROUP = :78 
     AND  DTIME >= :79 
     AND  DTIME <= :80 
  ) b 
 ) P,
      --停轧时间 机械
    SELECT  JIXIE,MON_JIXIE
   FROM
  (
    SELECT LOG_VALUE JIXIE
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '6' 
           AND T.LOG_GROUP = :81
           AND T.DTIME     = :82
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_JIXIE  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '6' 
     AND  T.LOG_GROUP = :83 
     AND  DTIME >= :84 
     AND  DTIME <= :85 
  ) b 
 ) R,
       --停轧时间 电器
    SELECT  DQ,MON_DQ
   FROM
  (
    SELECT LOG_VALUE DQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '7' 
           AND T.LOG_GROUP = :86
           AND T.DTIME     = :87
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_DQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '7' 
     AND  T.LOG_GROUP = :88 
     AND  DTIME >= :89 
     AND  DTIME <= :90 
  ) b 
 ) S,
       --停轧时间 轧钢
    SELECT  ZG,MON_ZG
   FROM
  (
    SELECT LOG_VALUE ZG
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '8' 
           AND T.LOG_GROUP = :91
           AND T.DTIME     = :92
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_ZG  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '8' 
     AND  T.LOG_GROUP = :93 
     AND  DTIME >= :94 
     AND  DTIME <= :95 
  ) b 
 ) T,
        --停轧时间 换辊
    SELECT  HG,MON_HG
   FROM
  (
    SELECT LOG_VALUE HG
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '9' 
           AND T.LOG_GROUP = :96
           AND T.DTIME     = :97
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_HG  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '9' 
     AND  T.LOG_GROUP = :98 
     AND  DTIME >= :99 
     AND  DTIME <= :100 
  ) b 
 ) U,
         --停轧时间 检修
    SELECT  JIANXIU,MON_JIANXIU
   FROM
  (
    SELECT LOG_VALUE JIANXIU
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '10' 
           AND T.LOG_GROUP = :101
           AND T.DTIME     = :102
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_HG  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '10' 
     AND  T.LOG_GROUP = :103 
     AND  DTIME >= :104
     AND  DTIME <= :105 
  ) b 
 ) V,
          --停轧时间 外部
    SELECT  WB,MON_WB
   FROM
  (
    SELECT LOG_VALUE WB
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '11' 
           AND T.LOG_GROUP = :106
           AND T.DTIME     = :107
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_WB  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '11' 
     AND  T.LOG_GROUP = :108 
     AND  DTIME >= :109
     AND  DTIME <= :110 
  ) b 
 ) W,
    --停轧时间 原成
    SELECT  YC,MON_YC
   FROM
  (
    SELECT LOG_VALUE YC
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '12' 
           AND T.LOG_GROUP = :111
           AND T.DTIME     = :112
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_YC  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '12' 
     AND  T.LOG_GROUP = :113
     AND  DTIME >= :114
     AND  DTIME <= :115
  ) b 
 ) X 
        ]]>
    </query>
	<query id="UIH090060_08.select" desc=" 这里统计能耗和停轧时间的查询" fetchSize="10">
        <![CDATA[		
SELECT  MQ,MON_MQ,
        DIAN,MON_DIAN,
        SHUI,MON_SHUI,
        KQ,MON_KQ,
        GH,MON_GH,
        JIXIE,MON_JIXIE,
        DQ,MON_DQ,
        ZG,MON_ZG,
        HG,MON_HG,
        JIANXIU,MON_JIANXIU,
        WB,MON_WB,
        YC,MON_YC,
        RL,MON_RL,
        TZ,MON_TZ
        
 FROM   
    (SELECT  MQ,MON_MQ
   FROM
  (
    SELECT LOG_VALUE MQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '1' 
           AND T.LOG_GROUP = :1
           AND T.DTIME     = :2
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_MQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '1' 
     AND  T.LOG_GROUP = :3  
     AND  T.DTIME >= :4
     AND  T.DTIME <= :5 
  ) b 
 ) A,
  --电能耗量
   ( SELECT  DIAN,MON_DIAN
   FROM
  (
    SELECT LOG_VALUE DIAN
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '2' 
           AND T.LOG_GROUP = :6
           AND T.DTIME     = :7
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_DIAN  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '2' 
     AND  T.LOG_GROUP = :8 
     AND  DTIME >= :9
     AND  DTIME <= :10 
  ) b 
 ) B,
   --水能耗量
  (  SELECT  SHUI,MON_SHUI
   FROM
  (
    SELECT LOG_VALUE SHUI
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '3' 
           AND T.LOG_GROUP = :11
           AND T.DTIME     = :12
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_SHUI  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '3' 
     AND  T.LOG_GROUP = :13
     AND  DTIME >= :14
     AND  DTIME <= :15 
  ) b 
 ) C,
    --压缩空气耗量
  (  SELECT  KQ,MON_KQ
   FROM
  (
    SELECT LOG_VALUE KQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '4' 
           AND T.LOG_GROUP = :16
           AND T.DTIME     = :17
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_KQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '4' 
     AND  T.LOG_GROUP = :18 
     AND  DTIME >= :19 
     AND  DTIME <= :20
  ) b 
 ) D,
     --辊耗耗量
 (   SELECT  GH,MON_GH
   FROM
  (
    SELECT LOG_VALUE GH
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '5' 
           AND T.LOG_GROUP = :21
           AND T.DTIME     = :22
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_GH  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '5' 
     AND  T.LOG_GROUP = :23 
     AND  DTIME >= :24 
     AND  DTIME <= :25 
  ) b 
 ) E,
      --停轧时间 机械
 (   SELECT  JIXIE,MON_JIXIE
   FROM
  (
    SELECT LOG_VALUE JIXIE
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '6' 
           AND T.LOG_GROUP = :26
           AND T.DTIME     = :27
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_JIXIE  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '6' 
     AND  T.LOG_GROUP = :28 
     AND  DTIME >= :29 
     AND  DTIME <= :30 
  ) b 
 ) F,
       --停轧时间 电器
  (  SELECT  DQ,MON_DQ
   FROM
  (
    SELECT LOG_VALUE DQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '7' 
           AND T.LOG_GROUP = :31
           AND T.DTIME     = :32
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_DQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '7' 
     AND  T.LOG_GROUP = :33 
     AND  DTIME >= :34 
     AND  DTIME <= :35 
  ) b 
 ) G,
       --停轧时间 轧钢
  (  SELECT  ZG,MON_ZG
   FROM
  (
    SELECT LOG_VALUE ZG
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '8' 
           AND T.LOG_GROUP = :36
           AND T.DTIME     = :37
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_ZG  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '8' 
     AND  T.LOG_GROUP = :38 
     AND  DTIME >= :39
     AND  DTIME <= :40 
  ) b 
 ) H,
        --停轧时间 换辊
  (  SELECT  HG,MON_HG
   FROM
  (
    SELECT LOG_VALUE HG
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '9' 
           AND T.LOG_GROUP = :41
           AND T.DTIME     = :42
  ) a,  -- daily 
  (
   SELECT    SUM(LOG_VALUE) MON_HG  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '9' 
     AND  T.LOG_GROUP = :43 
     AND  DTIME >= :44 
     AND  DTIME <= :45 
  ) b 
 ) I,
         --停轧时间 检修
  (  SELECT  JIANXIU,MON_JIANXIU
   FROM
  (
    SELECT LOG_VALUE JIANXIU
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '10' 
           AND T.LOG_GROUP = :46
           AND T.DTIME     = :47
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_JIANXIU  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '10' 
     AND  T.LOG_GROUP = :48
     AND  DTIME >= :49
     AND  DTIME <= :50 
  ) b 
 ) J,
          --停轧时间 外部
   ( SELECT  WB,MON_WB
   FROM
  (
    SELECT LOG_VALUE WB
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '11' 
           AND T.LOG_GROUP = :51
           AND T.DTIME     = :52
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_WB  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '11' 
     AND  T.LOG_GROUP = :53 
     AND  DTIME >= :54
     AND  DTIME <= :55 
  ) b 
 ) K,
    --停轧时间 原成
  (  SELECT  YC,MON_YC
   FROM
  (
    SELECT LOG_VALUE YC
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '12' 
           AND T.LOG_GROUP = :56
           AND T.DTIME     = :57
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_YC  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '12' 
     AND  T.LOG_GROUP = :58
     AND  DTIME >= :59
     AND  DTIME <= :60
  ) b 
 ) H ,
     --日历时间
  (  SELECT  RL,MON_RL
   FROM
  (
    SELECT LOG_VALUE RL
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '13' 
           AND T.LOG_GROUP = :61
           AND T.DTIME     = :62
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_RL  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '13' 
     AND  T.LOG_GROUP = :63
     AND  DTIME >= :64
     AND  DTIME <= :65
  ) b 
 ) M ,
      --轧钢时间
  (  SELECT  TZ,MON_TZ
   FROM
  (
    SELECT LOG_VALUE TZ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '14' 
           AND T.LOG_GROUP = :66
           AND T.DTIME     = :67
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_TZ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '14' 
     AND  T.LOG_GROUP = :68
     AND  DTIME >= :69
     AND  DTIME <= :70
  ) b 
 ) N
        ]]>
    </query>
	<query id="UIH090060_09.select" desc=" 这里统计能耗和停轧时间的查询  这里是周统计分析使用" fetchSize="10">
        <![CDATA[		
SELECT  MQ,MON_MQ,
        DIAN,MON_DIAN,
        SHUI,MON_SHUI,
        KQ,MON_KQ,
        GH,MON_GH,
        JIXIE,MON_JIXIE,
        DQ,MON_DQ,
        ZG,MON_ZG,
        HG,MON_HG,
        JIANXIU,MON_JIANXIU,
        WB,MON_WB,
        YC,MON_YC,
        RL,MON_RL,
        TZ,MON_TZ 
        
 FROM   
    (SELECT  MQ,MON_MQ
   FROM
  (
    SELECT SUM(LOG_VALUE) MQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '1' 
           AND T.LOG_GROUP = :1
           AND T.DTIME    >= :2
           AND T.DTIME    <= :3
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_MQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '1' 
     AND  T.LOG_GROUP = :4  
     AND  T.DTIME >= :5
     AND  T.DTIME <= :6 
  ) b 
 ) A,
  --电能耗量
   ( SELECT  DIAN,MON_DIAN
   FROM
  (
    SELECT SUM(LOG_VALUE) DIAN
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '2' 
           AND T.LOG_GROUP = :7
           AND T.DTIME    >= :8
           AND T.DTIME    <= :9
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_DIAN  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '2' 
     AND  T.LOG_GROUP = :10 
     AND  DTIME >= :11
     AND  DTIME <= :12 
  ) b 
 ) B,
   --水能耗量
  (  SELECT  SHUI,MON_SHUI
   FROM
  (
    SELECT SUM(LOG_VALUE) SHUI
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '3' 
           AND T.LOG_GROUP = :13
           AND T.DTIME    >= :14
           AND T.DTIME    <= :15
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_SHUI  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '3' 
     AND  T.LOG_GROUP = :16
     AND  DTIME >= :17
     AND  DTIME <= :18 
  ) b 
 ) C,
    --压缩空气耗量
  (  SELECT  KQ,MON_KQ
   FROM
  (
    SELECT SUM(LOG_VALUE) KQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '4' 
           AND T.LOG_GROUP = :19
           AND T.DTIME    >= :20
           AND T.DTIME    <= :21
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_KQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '4' 
     AND  T.LOG_GROUP = :22 
     AND  DTIME >= :23 
     AND  DTIME <= :24
  ) b 
 ) D,
     --辊耗耗量
 (   SELECT  GH,MON_GH
   FROM
  (
    SELECT SUM(LOG_VALUE) GH
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '5' 
           AND T.LOG_GROUP = :25
           AND T.DTIME    >= :26
           AND T.DTIME    <= :27
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_GH  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '5' 
     AND  T.LOG_GROUP = :28 
     AND  DTIME >= :29 
     AND  DTIME <= :30 
  ) b 
 ) E,
      --停轧时间 机械
 (   SELECT  JIXIE,MON_JIXIE
   FROM
  (
    SELECT SUM(LOG_VALUE) JIXIE
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '6' 
           AND T.LOG_GROUP = :31
           AND T.DTIME    >= :32
           AND T.DTIME    <= :33
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_JIXIE  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '6' 
     AND  T.LOG_GROUP = :34 
     AND  DTIME >= :35 
     AND  DTIME <= :36 
  ) b 
 ) F,
       --停轧时间 电器
  (  SELECT  DQ,MON_DQ
   FROM
  (
    SELECT SUM(LOG_VALUE) DQ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '7' 
           AND T.LOG_GROUP = :37
           AND T.DTIME    >= :38
           AND T.DTIME    <= :39
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_DQ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '7' 
     AND  T.LOG_GROUP = :40 
     AND  DTIME >= :41
     AND  DTIME <= :42 
  ) b 
 ) G,
       --停轧时间 轧钢
  (  SELECT  ZG,MON_ZG
   FROM
  (
    SELECT SUM(LOG_VALUE) ZG
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '8' 
           AND T.LOG_GROUP = :43
           AND T.DTIME    >= :44
           AND T.DTIME    <= :45
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_ZG  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '8' 
     AND  T.LOG_GROUP = :46 
     AND  DTIME >= :47
     AND  DTIME <= :48 
  ) b 
 ) H,
        --停轧时间 换辊
  (  SELECT  HG,MON_HG
   FROM
  (
    SELECT SUM(LOG_VALUE) HG
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '9' 
           AND T.LOG_GROUP = :49
           AND T.DTIME    >= :50
           AND T.DTIME    <= :51
  ) a,  -- daily 
  (
   SELECT    SUM(LOG_VALUE) MON_HG  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '9' 
     AND  T.LOG_GROUP = :52 
     AND  DTIME >= :53
     AND  DTIME <= :54 
  ) b 
 ) I,
         --停轧时间 检修
  (  SELECT  JIANXIU,MON_JIANXIU
   FROM
  (
    SELECT SUM(LOG_VALUE) JIANXIU
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '10' 
           AND T.LOG_GROUP = :55
           AND T.DTIME    >= :56
           AND T.DTIME    <= :57
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_JIANXIU  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '10' 
     AND  T.LOG_GROUP = :58
     AND  DTIME >= :59
     AND  DTIME <= :60 
  ) b 
 ) J,
          --停轧时间 外部
   ( SELECT  WB,MON_WB
   FROM
  (
    SELECT SUM(LOG_VALUE) WB
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '11' 
           AND T.LOG_GROUP = :61
           AND T.DTIME    >= :62
           AND T.DTIME    <= :63
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_WB  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '11' 
     AND  T.LOG_GROUP = :64 
     AND  DTIME >= :65
     AND  DTIME <= :66 
  ) b 
 ) K,
    --停轧时间 原成
  (  SELECT  YC,MON_YC
   FROM
  (
    SELECT SUM(LOG_VALUE) YC
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '12' 
           AND T.LOG_GROUP = :67
           AND T.DTIME    >= :68
           AND T.DTIME    <= :69
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_YC  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '12' 
     AND  T.LOG_GROUP = :70
     AND  DTIME >= :71
     AND  DTIME <= :72
  ) b 
 ) H ,
     --日历时间
  (  SELECT  RL,MON_RL
   FROM
  (
    SELECT SUM(LOG_VALUE) RL
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '13' 
           AND T.LOG_GROUP = :73
           AND T.DTIME    >= :74
           AND T.DTIME    <= :75
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_RL  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '13' 
     AND  T.LOG_GROUP = :76
     AND  DTIME >= :77
     AND  DTIME <= :78
  ) b 
 ) M,
      --轧钢时间
  (  SELECT  TZ,MON_TZ
   FROM
  (
    SELECT SUM(LOG_VALUE) TZ
           FROM TBH01_COIL_OUT T
           WHERE LOG_SORT = '14' 
           AND T.LOG_GROUP = :79
           AND T.DTIME    >= :80
           AND T.DTIME    <= :81
  ) a,  -- daily 
  (
    SELECT    SUM(LOG_VALUE) MON_TZ  
     
     FROM TBH01_COIL_OUT T  
    WHERE LOG_SORT = '14' 
     AND  T.LOG_GROUP = :82
     AND  DTIME >= :83
     AND  DTIME <= :84
  ) b 
 ) N
        ]]>
    </query>
</queryMap>