| 12345678910111213141516171819202122232425262728293031323334 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="工时统计">
- <query id="UIB100206_01.SELECT" desc="工时统计">
- <![CDATA[
- SELECT DISTINCT XX.* FROM (
- SELECT DECODE(T3.SMP_NO_TYPE , '00' , '初样' , '复样') SMP_TYPE
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'PC' AND TO_NUMBER(DECODE(SUBSTR(T1.QLTY_TEM ,1,2) , '00' , '-' , '+')||SUBSTR(T1.QLTY_TEM ,3)) <= 10 THEN 3 ELSE 0 END ) PU_XIAO
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'PC' AND TO_NUMBER(DECODE(SUBSTR(T1.QLTY_TEM ,1,2) , '00' , '-' , '+')||SUBSTR(T1.QLTY_TEM ,3)) > 10 THEN 3 ELSE 0 END ) PU_DA
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'SC' AND TO_NUMBER(DECODE(SUBSTR(T1.QLTY_TEM ,1,2) , '00' , '-' , '+')||SUBSTR(T1.QLTY_TEM ,3)) <= 10 THEN 3 ELSE 0 END ) SHI_XIAO
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'SC' AND TO_NUMBER(DECODE(SUBSTR(T1.QLTY_TEM ,1,2) , '00' , '-' , '+')||SUBSTR(T1.QLTY_TEM ,3)) > 10 THEN 3 ELSE 0 END ) SHI_DA
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'CB' THEN 1 ELSE 0 END ) LEN_GWAN
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'LL' AND T1.QLTY_CD = 'ARER' THEN 1 ELSE 0 END ) LA_LI
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'DW' THEN 2 ELSE 0 END ) LUO_CHUI --落锤
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'XC' THEN 3 ELSE 0 END ) JIAN_QIE --剪切面积
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'BH' THEN 1 ELSE 0 END ) HONG_KAO --烘烤硬化
- ,SUM(CASE WHEN T1.QLTY_CD_2 = 'SR' THEN 1 ELSE 0 END ) SUO_XIN --塑性硬变比
- FROM TBB10_QLTY_CD T1, TBB10_QLTY_OPE T2, TBB10_QLTY_COIL T3
- WHERE T1.QLTY_CD = T2.QLTY_CD
- AND T2.SMP_NO = T3.SMP_NO
- AND T2.SMP_CUT_LOC = T3.SMP_CUT_LOC
- AND T2.SMP_NO_TYPE = T3.SMP_NO_TYPE
- --AND T1.QLTY_CD != 'ARER'
- AND T3.PROD_LINE = ?
- AND T3.WEITO_DTIME BETWEEN ? AND ?
- GROUP BY T3.SMP_NO_TYPE
- ) XX
- ]]>
- </query>
-
- </queryMap>
|
