XinYu_LZMES/.svn/pristine/da/dadedac19f2895e5ac7ca1a747b9558438af5f53.svn-base

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="技术经济指标">


<query id="UIC010001_01.SELECT">
  <![CDATA[
SELECT                T.TJ_SEQ                         SEQ
                     ,T.TJ_NAME||NAME_UNIT             ZHIBIAO 
                     ,NVL(T.JIA_CURRENT   ,0)          DAY_1
                     ,NVL(T.JIA_MONTH     ,0)          MONTH_1
                     ,NVL(T.YI_CURRENT    ,0)          DAY_2
                     ,NVL(T.YI_MONTH      ,0)          MONTH_2
                     ,NVL(T.BIN_CURRENT   ,0)          DAY_3
                     ,NVL(T.BIN_MONTH     ,0)          MONTH_3
                     ,NVL(T.DING_CURRENT  ,0)          DAY_4
                     ,NVL(T.DING_MONTH    ,0)          MONTH_4
                     ,NVL(T.FAC_CURRENT   ,0)          DAY_5
                     ,NVL(T.FAC_MONTH     ,0)          MONTH_5
                     ,NVL(T.FAC_YEAR      ,0)          YEAR_5
FROM                  TBC01_JISHU_ZB            T
WHERE                 T.PROD_LINE               =                    ?
AND                   T.REG_DTIME               =              	     ?
ORDER  BY             T.TJ_SEQ 
 ]]>
</query>

<query id="UIC010001_02.SELECT" desc="酸轧非计划">
  <![CDATA[
    SELECT    T.COIL_NO             --  '钢卷号'       
           ,T.HC_COIL_NO           -- '热轧卷号'      
           ,T.ACT_WGT               --'钢卷重量'       
           ,T.SPEC_STL_GRD          --'成品牌号'    
           ,T.COIL_THK              --'厚度'                     
           ,T.COIL_WTH             -- '宽度'        
           ,T.PLANORDERFORM        -- '计划订单'    
           ,T.ALLOTORDERFORM       -- '实际订单'                       
           ,T.PRODUCETIME          -- '生产时间'                
           ,T.JHN_WEIGHT           -- '计划量'                    
           ,T.CUR_PROG_CD          -- '当期进程状态'    
           ,T.YN_FJH               -- '是否非计划'                                                                        
           ,T.FJHYY                -- '非计划原因'                                                                        
           ,T.JT_FJHYY             -- '具体非计划原因'                                                                      
           ,T.JHN_WEIGHT           -- '计划量'                                                                                                                                              
           ,T.LGYYFJH_WEIGHT       --'炼钢原因非计划'                                                                       
           ,T.RZYYFJH_WEIGHT       -- '热轧原因非计划'                                                                       
           ,T.SZYYFJH_WEIGHT       -- '酸轧原因非计划'                                                                                 
           ,T.YN_YCMZ              -- '是否一次命中原因'     
           ,T.FYCMZ_YY             -- '非一次命中原因'                                                                     
           ,T.JT_YCBMZYY           -- '具体一次不命中原因'                                                                      
           FROM TBB02_STAT_SUAN T 
           WHERE --T.MILL_GROUP IN ( '1','2','3','4') 
           --AND 
           SUBSTR(T.PRODUCETIME ,1,8) BETWEEN ? AND ? 
           AND T.YN_FJH='Y'
           AND T.YN_LT='N'
           ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
 ]]>
</query>


<query id="UIC010001_03.SELECT" desc="酸轧一次命中">
  <![CDATA[
    SELECT    T.COIL_NO             --  '钢卷号'       
           ,T.HC_COIL_NO           	-- '热轧卷号'      
           ,T.ACT_WGT               --'钢卷重量'       
           ,T.SPEC_STL_GRD          --'成品牌号'    
           ,T.COIL_THK              --'厚度'                     
           ,T.COIL_WTH             -- '宽度'        
           ,T.PLANORDERFORM        -- '计划订单'    
           ,T.ALLOTORDERFORM       -- '实际订单'                       
           ,T.PRODUCETIME          -- '生产时间'                
           ,T.JHN_WEIGHT           -- '计划量'                    
           ,T.CUR_PROG_CD          -- '当期进程状态'    
           ,T.YN_FJH               -- '是否非计划'                                                                        
           ,T.FJHYY                -- '非计划原因'                                                                        
           ,T.JT_FJHYY             -- '具体非计划原因'                                                                      
           ,T.JHN_WEIGHT           -- '计划量'                                                                                                                                      
           ,T.LGYYFJH_WEIGHT       --'炼钢原因非计划'                                                                       
           ,T.RZYYFJH_WEIGHT       -- '热轧原因非计划'                                                                       
           ,T.SZYYFJH_WEIGHT       -- '酸轧原因非计划'                                                                                 
           ,T.YN_YCMZ              -- '是否一次命中原因'     
           ,T.FYCMZ_YY             -- '非一次命中原因'                                                                     
           ,T.JT_YCBMZYY           -- '具体一次不命中原因'                                                                      
           FROM TBB02_STAT_SUAN T 
           WHERE --T.MILL_GROUP IN ( '1','2','3','4') 
           --AND 
           SUBSTR(T.PRODUCETIME ,1,8) BETWEEN ? AND ? 
           AND T.YN_YCMZ	=	'N'
           AND T.YN_LT='N'
           ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
 ]]>
</query>

<query id="UIC010001_04.SELECT" desc="酸轧待判定">
  <![CDATA[
  	SELECT  T.COIL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT ACT_WGT
       ,T.MILL_DTIME
       ,DECODE(T.INGR_DEC_GRD,0,'无性能要求',1,'合格',2,'不合格','待判') INGR_DEC_GRD
       ,DECODE(T.EXTSHAPE_DEC_GRD,0,'无性能要求',1,'合格',2,'不合格','待判') EXTSHAPE_DEC_GRD
       ,DECODE(T.MATLQLTY_DEC_GRD,0,'无性能要求',1,'合格',2,'不合格','待判') MATLQLTY_DEC_GRD
       ,DECODE(T.TOT_DEC_GRD,0,'无性能要求',1,'合格',2,'不合格','待判') TOT_DEC_GRD
       FROM C_TBL02_COIL_COMM T 
       WHERE   T.CUR_PROG_CD = 'DED' 
       AND T.TOT_DEC_GRD IS NULL 
       AND SUBSTR(T.MILL_DTIME ,1,8) BETWEEN  ? AND ? 
      -- AND T.MILL_GROUP IN     ('1','2','3','4')
       ORDER BY T.COIL_NO,T.COIL_THK,T.COIL_WTH
   ]]>
</query>

<query id="UIC010001_05.SELECT" desc="酸轧表面缺陷">
  <![CDATA[
  SELECT  T.COIL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT ACT_WGT
       ,T.MILL_DTIME 
       ,DECODE(T.MILL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.冷轧类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'D5' THEN '2.1酸轧辊印'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '2.2酸轧擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'B1' THEN '2.3酸轧振动纹'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5','E1','B1') THEN '2.4酸轧其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
       FROM        C_TBL02_COIL_COMM            T  
       WHERE       T.CRK_CD1_TYPE IS NOT NULL
       AND         SUBSTR(T.MILL_DTIME ,1,8)  BETWEEN ? AND ? 
      -- AND         T.MILL_GROUP IN ('1','2','3','4') 
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
     ]]>
</query>

<query id="UIC010001_06.SELECT" desc="1.原料类缺陷">
  <![CDATA[
 SELECT  T.COIL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT ACT_WGT
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.MILL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.冷轧类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'D5' THEN '2.1酸轧辊印'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '2.2酸轧擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'B1' THEN '2.3酸轧振动纹'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5','E1','B1') THEN '2.4酸轧其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
      FROM TBB02_STAT_SUAN T
 	WHERE 	T.YN_FJH = 'Y'
   		AND T.FJHYY = '热轧'
   		AND SUBSTR(T.PRODUCETIME, 1, 8) BETWEEN ? AND ?
   		AND T.YN_LT = 'N'
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
       ]]>
</query>

<query id="UIC010001_07.SELECT" desc="2.冷轧类缺陷">
  <![CDATA[
 SELECT  T.COIL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT ACT_WGT
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.MILL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.冷轧类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'D5' THEN '2.1酸轧辊印'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '2.2酸轧擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'B1' THEN '2.3酸轧振动纹'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5','E1','B1') THEN '2.4酸轧其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
      FROM TBB02_STAT_SUAN T
 	WHERE 	T.YN_FJH = 'Y'
   		AND T.FJHYY = '酸轧'
   		AND SUBSTR(T.PRODUCETIME, 1, 8) BETWEEN ? AND ?
   		AND T.YN_LT = 'N'
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
       ]]>
</query>

<query id="UIC010001_08.SELECT" desc="2.1酸轧缺陷类">
  <![CDATA[
 SELECT  T.COIL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT ACT_WGT
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.MILL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.冷轧类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'D5' THEN '2.1酸轧辊印'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '2.2酸轧擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'B1' THEN '2.3酸轧振动纹'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5','E1','B1') THEN '2.4酸轧其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
        FROM        TBB02_STAT_SUAN            T 
       WHERE       T.CRK_CD1_TYPE IS NOT NULL 
       AND         T.YN_FJH = 'Y'
       AND         T.YN_LT = 'N'
       AND         SUBSTR(T.PRODUCETIME ,1,8)  BETWEEN  ? and ?
       ]]>
</query>

<query id="UIC010001_09.SELECT" desc="2.2酸轧类其他">
  <![CDATA[
 SELECT  T.COIL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT ACT_WGT
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.MILL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.冷轧类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'D5' THEN '2.1酸轧辊印'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '2.2酸轧擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'B1' THEN '2.3酸轧振动纹'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5','E1','B1') THEN '2.4酸轧其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
      FROM        TBB02_STAT_SUAN            T 
       WHERE       T.CRK_CD1_TYPE IS  NULL 
       AND        T.YN_FJH = 'Y'
       AND         T.YN_LT = 'N'
       AND         T.FJHYY = '酸轧'
       AND         SUBSTR(T.PRODUCETIME ,1,8)  BETWEEN  ? and ? 
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
       ]]>
</query>


<query id="UIC010001_10.SELECT" desc="2.3酸轧振动纹">
  <![CDATA[
SELECT  T.COIL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT ACT_WGT
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.MILL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.冷轧类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'D5' THEN '2.1酸轧辊印'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '2.2酸轧擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'B1' THEN '2.3酸轧振动纹'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5','E1','B1') THEN '2.4酸轧其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
      FROM TBB02_STAT_SUAN T
 	WHERE 	T.YN_FJH = 'Y'
   		AND T.FJHYY = '钢质'
   		AND SUBSTR(T.PRODUCETIME, 1, 8) BETWEEN ? AND ?
   		AND T.YN_LT = 'N'
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
       ]]>
</query>

<query id="UIC010001_11.SELECT" desc="2.4酸轧其它">
  <![CDATA[
 SELECT  T.COIL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT ACT_WGT
       ,T.MILL_DTIME 
       ,DECODE(T.MILL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.冷轧类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'D5' THEN '2.1酸轧辊印'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '2.2酸轧擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'B1' THEN '2.3酸轧振动纹'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5','E1','B1') THEN '2.4酸轧其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
       FROM        C_TBL02_COIL_COMM            T  
       WHERE       (T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5','E1','B1'))
       AND         SUBSTR(T.MILL_DTIME ,1,8)  BETWEEN ? AND ? 
      -- AND         T.MILL_GROUP IN ('1','2','3','4') 
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
       ]]>
</query>


<query id="UIC010001_12.SELECT" desc="连退待判">
  <![CDATA[
  	 SELECT   T.OLD_SAMPL_NO
         ,T.COIL_THK
         ,T.COIL_WTH
         ,T.ACT_WGT
         ,T.MILL_DTIME
         ,DECODE(T.INGR_DEC_GRD,1,'合格',2,'不合格','待判') INGR_DEC_GRD
         ,DECODE(T.EXTSHAPE_DEC_GRD,1,'合格',2,'不合格','待判')EXTSHAPE_DEC_GRD
         ,DECODE(T.MATLQLTY_DEC_GRD,1,'合格',2,'不合格','待判')MATLQLTY_DEC_GRD
         ,DECODE(T.TOT_DEC_GRD,1,'合格',2,'不合格','待判') TOT_DEC_GRD
         FROM C_TBC02_COIL_COMM T 
         WHERE T.CUR_PROG_CD = 'DED' 
         AND T.TOT_DEC_GRD IS NULL 
         AND SUBSTR(T.MILL_DTIME ,1,8) BETWEEN  ? AND ? 
       --  AND T.CAL_GROUP IN      ('1','2','3','4')
         ORDER BY T.COIL_NO,T.COIL_THK,T.COIL_WTH
  ]]>
</query>


<query id="UIC010001_13.SELECT" desc="连退表面缺陷">
  <![CDATA[
  	 SELECT  T.OLD_SAMPL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT 
       ,T.MILL_DTIME 
       ,DECODE(T.CAL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.酸轧类'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IS NOT NULL THEN '3.连退类'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'F5' THEN '3.1连退平整花'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '3.2连退擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4') THEN '3.3连退辊印/压印(痕)'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'F5' ,'E1') THEN '3.4连退其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
       FROM        C_TBC02_COIL_COMM            T  
       WHERE       T.CRK_CD1_TYPE IS NOT NULL 
       AND         SUBSTR(T.MILL_DTIME ,1,8)  BETWEEN ? AND ? 
      -- AND         T.CAL_GROUP IN ('1','2','3','4') 
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
    ]]>
</query>

<query id="UIC010001_14.SELECT" desc="1.原料类缺陷">
  <![CDATA[
   SELECT  T.OLD_SAMPL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT 
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.CAL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.酸轧类'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IS NOT NULL THEN '3.连退类'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'F5' THEN '3.1连退平整花'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '3.2连退擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4') THEN '3.3连退辊印/压印(痕)'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'F5' ,'E1') THEN '3.4连退其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
      FROM TBB02_STAT_LIAN T
 	WHERE 	(YN_YCMZ = 'N' OR YN_FJH = 'Y')
   			AND T.FJHYY = '热轧'
   			AND SUBSTR(T.PRODUCETIME, 1, 8) BETWEEN ? and ?
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
    ]]>
</query>

<query id="UIC010001_15.SELECT" desc="2.酸轧类">
  <![CDATA[
   SELECT  T.OLD_SAMPL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT 
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.CAL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.酸轧类'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IS NOT NULL THEN '3.连退类'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'F5' THEN '3.1连退平整花'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '3.2连退擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4') THEN '3.3连退辊印/压印(痕)'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'F5' ,'E1') THEN '3.4连退其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
       FROM TBB02_STAT_LIAN T
 	WHERE 	(YN_YCMZ = 'N' OR YN_FJH = 'Y')
   			AND T.FJHYY = '酸轧'
   			AND SUBSTR(T.PRODUCETIME, 1, 8) BETWEEN ? and ?
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
	]]>
</query>

<query id="UIC010001_16.SELECT" desc="3.连退类">
  <![CDATA[
   SELECT  T.OLD_SAMPL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT 
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.CAL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE WHEN T.CRK_CD1_TYPE LIKE 'A%' OR T.CRK_CD1_TYPE LIKE 'B%' THEN '1.原料类缺陷'
             WHEN T.CRK_CD1_TYPE LIKE 'C%' THEN '2.酸轧类'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IS NOT NULL THEN '3.连退类'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'F5' THEN '3.1连退平整花'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '3.2连退擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4') THEN '3.3连退辊印/压印(痕)'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'F5' ,'E1') THEN '3.4连退其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
        FROM TBB02_STAT_LIAN T
 	WHERE 	(YN_YCMZ = 'N' OR YN_FJH = 'Y')
   			AND T.FJHYY = '连退'
   			AND SUBSTR(T.PRODUCETIME, 1, 8) BETWEEN ? and ?
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
  	]]>
</query>
  
<query id="UIC010001_17.SELECT" desc="3.1连退平整花">
 <![CDATA[
  SELECT  T.OLD_SAMPL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT 
       ,T.PRODUCETIME MILL_DTIME 
       ,DECODE(T.CAL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE 
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'F5' THEN '3.1连退平整花'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '3.2连退擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4') THEN '3.3连退辊印/压印(痕)'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'F5' ,'E1') THEN '3.4连退其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
       FROM TBB02_STAT_LIAN T
 	WHERE 	(YN_YCMZ = 'N' OR YN_FJH = 'Y')
   			AND T.FJHYY = '钢质'
   			AND SUBSTR(T.PRODUCETIME, 1, 8) BETWEEN ? and ?
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
   	]]>
</query>

<query id="UIC010001_18.SELECT" desc="3.2连退擦划伤">
 <![CDATA[
  SELECT  T.OLD_SAMPL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT 
       ,T.MILL_DTIME 
       ,DECODE(T.CAL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE 
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'F5' THEN '3.1连退平整花'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '3.2连退擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4') THEN '3.3连退辊印/压印(痕)'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'F5' ,'E1') THEN '3.4连退其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
       FROM        C_TBC02_COIL_COMM            T  
       WHERE       (T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1')
       AND         SUBSTR(T.MILL_DTIME ,1,8)  BETWEEN ? AND ? 
     --  AND         T.CAL_GROUP IN ('1','2','3','4') 
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
   ]]>
</query>

<query id="UIC010001_19.SELECT" desc="3.3连退辊印/压印(痕)">
 <![CDATA[
  SELECT  T.OLD_SAMPL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT 
       ,T.MILL_DTIME 
       ,DECODE(T.CAL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE 
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'F5' THEN '3.1连退平整花'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '3.2连退擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4') THEN '3.3连退辊印/压印(痕)'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'F5' ,'E1') THEN '3.4连退其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
       FROM        C_TBC02_COIL_COMM            T  
       WHERE       (T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4'))
       AND         SUBSTR(T.MILL_DTIME ,1,8)  BETWEEN ? AND ? 
    --   AND         T.CAL_GROUP IN ('1','2','3','4') 
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
    ]]>
</query>

<query id="UIC010001_20.SELECT" desc="3.4连退其它">
 <![CDATA[
  SELECT  T.OLD_SAMPL_NO
       ,T.COIL_THK
       ,T.COIL_WTH
       ,T.ACT_WGT 
       ,T.MILL_DTIME 
       ,DECODE(T.CAL_GROUP,1,'甲',2,'乙',3,'丙',4,'丁') MILL_GROUP
       ,(CASE             
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'F5' THEN '3.1连退平整花'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 = 'E1' THEN '3.2连退擦划伤'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 IN ('D5' ,'J5','D4') THEN '3.3连退辊印/压印(痕)'
             WHEN T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'E5' ,'E1') THEN '3.4连退其它'
             END ) CRK_CD1
       ,T.CRK_CD1_TYPE
       FROM        C_TBC02_COIL_COMM            T  
       WHERE       (T.CRK_CD1_TYPE LIKE 'D%' AND T.CRK_CD1 NOT IN ('D5' ,'J5','D4' ,'F5' ,'E1'))
       AND         SUBSTR(T.MILL_DTIME ,1,8)  BETWEEN ? AND ? 
      -- AND         T.CAL_GROUP IN ('1','2','3','4') 
       ORDER BY  T.COIL_NO,T.COIL_THK,T.COIL_WTH
     ]]>
</query>

<query id="UIC010001_21.SELECT" desc="连退非计划总量">
 <![CDATA[
 	
SELECT    T.OLD_SAMPL_NO                           --钢卷号
           ,T.HC_COIL_NO                      --热轧卷号T4.OLD_SAMPL_NO (用这个会出现一个酸轧卷对应多个热卷号)T2.COIL_NO(可能可以待定)
           ,T.ACT_WGT                         --钢卷重量
           ,T.SPEC_STL_GRD                    --成品牌号
           ,T.COIL_THK                        --厚度
           ,T.COIL_WTH                        --宽度
           ,T.PLANORDERFORM                   --计划订单
           ,T.ALLOTORDERFORM                  --实际订单
           ,T.PRODUCETIME                     --生产时间
           ,T.CUR_PROG_CD                     --当期进程状态
           ,T.YN_FJH                          --是否非计划(46,47合同，余材，没订单在库，没订单没综合判定)
           ,T.FJHYY                           --非计划原因
           ,T.JT_FJHYY                        --具体非计划原因
           ,T.JHN_WEIGHT                      --计划量                                                               
           ,T.LGYYFJH_WEIGHT                  --炼钢原因非计划
           ,T.RZYYFJH_WEIGHT                  --热轧原因非计划(非46合同中的热轧缺陷)
           ,T.SZYYFJH_WEIGHT                  --酸轧原因非计划(非46合同中的酸扎缺陷及其他缺陷)          
           ,T.YN_YCMZ          			      --是否一次命中
           ,T.FYCMZ_YY                        --非一次命中原因
           ,T.JT_YCBMZYY                      --具体一次不命中原因
           FROM TBB02_STAT_LIAN T 
           WHERE --T.CAL_GROUP IN ( '1','2','3','4') 
          -- AND 
           SUBSTR(T.PRODUCETIME ,1,8) BETWEEN ? AND ?
           AND T.YN_FJH='Y'
           ORDER BY T.COIL_NO,T.COIL_THK,T.COIL_WTH 
    ]]>
</query>

<query id="UIC010001_22.SELECT" desc="连退卷一次命中率">
 <![CDATA[
 
SELECT    T.OLD_SAMPL_NO                           --钢卷号
           ,T.HC_COIL_NO                      --热轧卷号T4.OLD_SAMPL_NO (用这个会出现一个酸轧卷对应多个热卷号)T2.COIL_NO(可能可以待定)
           ,T.ACT_WGT                         --钢卷重量
           ,T.SPEC_STL_GRD                    --成品牌号
           ,T.COIL_THK                        --厚度
           ,T.COIL_WTH                        --宽度
           ,T.PLANORDERFORM                   --计划订单
           ,T.ALLOTORDERFORM                  --实际订单
           ,T.PRODUCETIME                     --生产时间
           ,T.CUR_PROG_CD                     --当期进程状态
           ,T.YN_FJH                          --是否非计划(46,47合同，余材，没订单在库，没订单没综合判定)
           ,T.FJHYY                           --非计划原因
           ,T.JT_FJHYY                        --具体非计划原因
           ,T.JHN_WEIGHT                      --计划量                                                               
           ,T.LGYYFJH_WEIGHT                  --炼钢原因非计划
           ,T.RZYYFJH_WEIGHT                  --热轧原因非计划(非46合同中的热轧缺陷)
           ,T.SZYYFJH_WEIGHT                  --酸轧原因非计划(非46合同中的酸扎缺陷及其他缺陷)
           ,T.YN_YCMZ          			      --是否一次命中
           ,T.FYCMZ_YY                        --非一次命中原因
           ,T.JT_YCBMZYY                      --具体一次不命中原因
           FROM TBB02_STAT_LIAN T 
           WHERE-- T.CAL_GROUP IN ( '1','2','3','4') 
          -- AND 
           SUBSTR(T.PRODUCETIME ,1,8) BETWEEN ? AND ? 
           AND T.YN_YCMZ='N'
           ORDER BY T.COIL_NO,T.COIL_THK,T.COIL_WTH 
    ]]>
</query>
<query id="UIC010001_23.SELECT" desc="非计划原因明细">
 <![CDATA[
 select t.OLD_SAMPL_NO
 		,t.ORD_NO
 		,t.ord_seq
 		,t.JT_FJHYY 
 		,t.ACT_WGT
 		,t.COIL_THK ,t.COIL_WTH, t.FJHYY,
               t.MILL_DTIME, t.SPEC_STL_GRD
 		FROM (select 
 				t.OLD_SAMPL_NO
 				,t.ORD_NO
 				,t.ORD_SEQ
 				,t.JT_FJHYY 
 				,t.ACT_WGT
 				,t.COIL_THK ,t.COIL_WTH, t.FJHYY,
               t.PRODUCETIME MILL_DTIME, t.SPEC_STL_GRD
 				FROM tbb02_stat_lian t 
 				WHERE --((t.REEL_GROUP in ('1','2','3','4')) or (t.CAL_GROUP in ('1','2','3','4')))
 				--AND	 
 				t.YN_FJH ='Y' 
 				AND SUBSTR(T.PRODUCETIME ,1,8)  BETWEEN  SUBSTR(?,1,8) AND SUBSTR(?,1,8))t
 				,c_tbc02_coil_comm t1 
 		WHERE t.OLD_SAMPL_NO=t1.OLD_SAMPL_NO --and t1.PACKAGE_FL='1'
     ]]>
</query>

<query id="UIC010001_24.SELECT" desc="停机消耗查询">
 <![CDATA[
	select t.tj_dh,
       nvl(t.tj_dh, 0) * 0.63*1.6 tj_dh1,
       t.tj_szq,
       nvl(t.tj_szq, 0) * 100 tj_szq1,
       t.tj_mq,
       nvl(t.tj_mq, 0) * 0.29 tj_mq1,
       (nvl(t.tj_s, 0)+nvl(t.tj_s_zs,0)) tj_s,
       (nvl(t.tj_s, 0)+nvl(t.tj_s_zs,0)) * 0.35 tj_s1,
       t.tj_tys,
       nvl(t.tj_tys, 0) * 3.8 tj_tys1,
       nvl(t.tj_dh, 0) * 0.63*1.6+nvl(t.tj_szq, 0) * 100+nvl(t.tj_mq, 0) * 0.29+nvl(t.tj_s, 0) * 0.35+nvl(t.tj_tys, 0) * 3.8 total,
       t.tj_dtime,
       t.tj_stime,
       t.tj_etime,
       t.tj_kaohe
  		from tbc02_jishu_tj t
 	where t.tj_dtime between ? and ?
     ]]>
</query>
<query id="UIC010001_01.CALL"  desc="">
 <![CDATA[
	{call REPORT_FORM.JISHU_JINJI_ZHIBIAO(?,?,?)}
	]]>
</query>
<query id="UIC010001_02.CALL"  desc="">
 <![CDATA[
	{call REPORT_FORM.DETAIL_REPORT_TJXIAOHAO(?,?)}
	]]>
</query>
<query id="UIC010001_03.CALL"  desc="">
 <![CDATA[
	{call REPORT_FORM.ORI_COIL_WGT(?,?)}
	]]>
</query>
</queryMap>