<select id="getWorkorderFullsetList" resultType="com.huawei.it.tgmes.tmas.wavejuxin.entity.bo.WorkorderFullsetInfo">
select twf.id,
twwi.location_code,
twwi.factory_code,
t.dept_name,
twf.workorder_name,
twwi.item_code,
twf.fullset_status,
twf.material_fullset,
twf.guide_fullset,
twf.tooling_fullset,
twf.copper_mesh_fullset,
twf.program_fullset,
twf.workorder_configuration_fullset,
twf.delivery_object_fullset,
item.newcode_flag new_code,
tbpc.prod_series_cn_name,
twwi.prod_model_code,
twwi.workorder_qty,
t.plan_start_time,
t.plan_end_time,
twwi.plan_online_time,
twwi.release_time,
twwi.workorder_type,
twwi.order_type,
twwi.entity_subtype_name,
twwi.work_serction_juxin
from t_workorder_fullset twf
left join t_wave_workorder_info twwi
on twf.workorder_name = twwi.workorder_name
left join t_base_prod_catalog tbpc
on twwi.prod_model_code = tbpc.prod_model_code
left join (select b.workorder_name,
max(b.dept_name) dept_name,
min(b.plan_start_time) plan_start_time,
max(b.plan_end_time) plan_end_time
from t_wave_taskorder_juxin b
where b.is_delete = 0
<if test="locationCodeList
!= null and locationCodeList.size > 0">
and b.location_code in
<foreach collection="locationCodeList" item="item" separator="," index="index" open="(" close=")">
#{item}
</foreach>
</if>
<if test="deptNameList
!= null and deptNameList.size > 0">
and b.dept_name in
<foreach collection="deptNameList" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
<if test="workorderName
!= null and workorderName
!= ''">
and b.workorder_name like upper(#{workorderName})||'%'
</if>
<if test="itemCode
!= null and itemCode
!= ''">
and b.item_code like upper(#{itemCode})||'%'
</if>
<if test="prodModelCodeList
!= null and prodModelCodeList.size > 0">
and b.prod_model_code in
<foreach collection="prodModelCodeList" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
<if test="planStartTime1
!= null">
and b.plan_start_time >= #{planStartTime1}
</if>
<if test="planStartTime2
!= null">
<
![
CDATA[ and b.plan_start_time < #{planStartTime2} ]]>
</if>
group by b.workorder_name
) t
on twf.workorder_name = t.workorder_name
left join t_base_prod_item_info item
on item.prod_item_code = twwi.item_code
and item.part_template = 'AI'
and item.aps_flag is null
where 1=1
<
![
CDATA[
<addProgram prepend ="and" dimensions2Fields="FactoryInfo:TWWI.FACTORY_CODE"></addProgram>
]]>
<if test="prodLineCodeList
!= null and prodLineCodeList.size > 0">
and tbpc.prod_line_code in
<foreach collection="prodLineCodeList" item="item" separator="," index="index" open="(" close=")">
#{item}
</foreach>
</if>
<if test="locationCodeList
!= null and locationCodeList.size > 0">
and twwi.location_code in
<foreach collection="locationCodeList" item="item" separator="," index="index" open="(" close=")">
#{item}
</foreach>
</if>
<if test="deptNameList
!= null and deptNameList.size > 0">
and t.dept_name in
<foreach collection="deptNameList" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
<if test="workorderName
!= null and workorderName
!= ''">
and twf.workorder_name like upper(#{workorderName})||'%'
</if>
<if test="itemCode
!= null and itemCode
!= ''">
and twwi.item_code like upper(#{itemCode})||'%'
</if>
<if test="fullsetStatusList
!= null and fullsetStatusList.size > 0">
and twf.fullset_status in
<foreach collection="fullsetStatusList" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
<if test="prodSeriesCodeList
!= null and prodSeriesCodeList.size > 0">
and tbpc.prod_series_code in
<foreach collection="prodSeriesCodeList" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
<if test="prodModelCodeList
!= null and prodModelCodeList.size > 0">
and twwi.prod_model_code in
<foreach collection="prodModelCodeList" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
<if test="workSerctionJuxinList
!= null and workSerctionJuxinList.size > 0">
and twwi.work_serction_juxin in
<foreach collection="workSerctionJuxinList" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
<if test="newCodeList
!= null and newCodeList.size > 0">
and item.newcode_flag in
<foreach collection="newCodeList" open="(" close=")" separator="," item="item">
#{item}
</foreach>
</if>
<if test="planStartTime1
!= null">
and t.plan_start_time >= #{planStartTime1}
</if>
<if test="planStartTime2
!= null">
<
![
CDATA[ and t.plan_start_time < #{planStartTime2} ]]>
</if>
<if test="planOnlineTime1
!= null">
and twwi.plan_online_time >= #{planOnlineTime1}
</if>
<if test="planOnlineTime2
!= null">
<
![
CDATA[ and twwi.plan_online_time <= #{planOnlineTime2} ]]>
</if>
<if test="releaseTime1
!= null">
and twwi.release_time >= #{releaseTime1}
</if>
<if test="releaseTime2
!= null">
<
![
CDATA[ and twwi.release_time <= #{releaseTime2} ]]>
</if>
<if test="lockRowStatusList
!= null and lockRowStatusList.size > 0">
and twwi.lock_row_status in
<foreach collection="lockRowStatusList" item="item" separator="," index="index" open="(" close=")">
#{item}
</foreach>
</if>
<if test="orderTypeArray
!= null and orderTypeArray.length > 0">
and twwi.order_type = any(#{orderTypeArray})
</if>
<if test="entitySubtypeNameArray
!= null and entitySubtypeNameArray.length > 0">
and twwi.entity_subtype_name = any(#{entitySubtypeNameArray})
</if>
order by twf.fullset_status desc,
t.plan_start_time,
twwi.plan_online_time,
twf.workorder_name
</select>
和 List<WorkorderFullsetInfo> getWorkorderFullsetList(QueryWorkorderFullsetCondition condition);报错
扫一扫
5752
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
