以下是合并后的SQL查询语句:
SELECT DISTINCT t.UNIT_NAME,
t.FINAL_CHECK_LEVEL,
t.final_check_reason,
case when t.FINAL_CHECK_POINT is null or t.FINAL_CHECK_POINT ='null' then '' else t.FINAL_CHECK_POINT end as FINAL_CHECK_POINT,
t.FINAL_CHECK_TIME,
t.FINAL_TEST_EL_LEVEL,
t.final_test_el_reason,
t.FINAL_TEST_EL_POINT,
t.final_test_el_time,
t.FRONT_LEVEL,
t.FRONT_REASON,
t.FRONT_POINT,
t.RATED_POWER,
t.PMPP,
t.umpp,
t.impp,
t.nmod,
t.ncell,
t.ff,
t.uoc,
t.isc,
t.RATED_VOLTAGE,
t.RATED_CURRENT,
p.box_name,
case when uu.original_order is not null or uu.original_order != '' then uu.original_order else u.work_order_name end as workorder,
uu.serialnumber,
t2.CUSTOMER_CODE,
d.CONVERSION_EFFICIENCY,
d.LOT_NUMBER,
d.PART_NAME,
p.DESCRIPTION as vendorname,
e.CREATE_TIME as CREATE_TIME_UNIT_PROCESS_HISTORY,
a.START_COMPRESSION1PRESSURE as START_COMPRESSION1PRESSURE_LAMINATE,
a.START_COMPRESSION2PRESSURE as START_COMPRESSION2PRESSURE_LAMINATE,
a.START_COMPRESSION3PRESSURE as START_COMPRESSION3PRESSURE_LAMINATE,
a.START_TEMP as START_TEMP_LAMINATE,
a.START_INFLATIONTIME as START_INFLATIONTIME_LAMINATE,
a.UP_VACUUM1 as UP_VACUUM1_LAMINATE ,
a.DOWN_VACUUM1 as DOWN_VACUUM1_LAMINATE ,
a.AVG_TEMP1 as AVG_TEMP1_LAMINATE,
a.PILANI1 as PILANI1_LAMINATE ,
u.WORK_ORDER_NAME ,
'http://172.25.130.51:30009/mes' || g.EL_IMAGE_PATH as imageurl,
t.CREATE_TIME
FROM UDT_FINAL_TEST_DATA t
LEFT JOIN UDT_TM_PACKING p ON t.unit_name = p.unit_name
LEFT JOIN TM_UNIT u ON t.unit_name = u.name
LEFT JOIN UDA_UNIT uu ON u.id = uu.id
LEFT JOIN TM_UNIT_PROCESS_HISTORY e ON t.unit_name = e.unit_name
LEFT JOIN TM_WORK_ORDER f ON e.work_order_name = f.name
LEFT JOIN UDA_WORK_ORDER uw ON f.id = uw.id
LEFT JOIN UDT_TM_JUNCTIONBOX h ON h.CORS_ID=e.CQRS_ID
LEFT JOIN TM_WORK_ORDER_ITEM c ON f.id = c.PARENT_WORK_ORDER_ID
LEFT JOIN UDT_TM_AI_STACK_AND_EL g ON g.NAME = e.NAME
LEFT JOIN UDA_WORK_ORDER_ITEM d ON c.id = d.id
LEFT JOIN PROD_PART p ON p.name = d.PART_NAME
JOIN (
SELECT name, CUSTOMER_CODE, MAX(create_time) AS max_time
FROM UDT_TM_FINAL_CHECK
WHERE 1=1
{ and name IN (:unit)}
{ and create_time >= TO_DATE(:begintimezj,'yyyy-mm-dd hh24:mi:ss')}
{ and create_time < TO_DATE(:endtimezj, 'yyyy-mm-dd hh24:mi:ss')}
GROUP BY name, CUSTOMER_CODE
) t2 ON t.unit_name = t2.name AND t2.max_time = t.FINAL_CHECK_TIME
LEFT JOIN UDT_TM_LAMINATE a on a.unit_name=t.unit_name
WHERE 1=1
AND d.sap_part_group = '电池片'
AND d.LOT_NUMBER IS NOT NULL
AND e.ROUTE_STEP_NAME = '终测'
AND (a.OUT_TYPE IS NULL OR a.OUT_TYPE ='一腔体')
{ and t.unit_name IN (:unit)}
{ and p.box_name IN (:boxname)}
{ and t.FINAL_CHECK_LEVEL IN (:final_level)}
{ and t.FINAL_CHECK_LINE IN (:check_line)}
{ and t.FINAL_TEST_LINE IN (:test_line)}
{ and t2.CUSTOMER_CODE IN (:custcode)}
{ and workorder in(:workorder)}
{ and uw.serialnumber in(:partgroupname)}
{ and t.create_time >= TO_DATE(:begintimezj,'yyyy-mm-dd hh24:mi:ss')}
{ and t.create_time < TO_DATE(:endtimezj, 'yyyy-mm-dd hh24:mi:ss')}
ORDER BY t.unit_name
请注意,我将原始SQL语句中的一些列名和表名进行了适当的调整,以确保查询语句的完整性。请根据你的实际数据结构和需要进行相应的修改。
内容由零声教学AI助手提供,问题来源于学员提问