<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.new
code_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
="location
CodeList !
= null and location
CodeList.size > 0">
and b.location_
code in
<foreach collection
="location
CodeList" 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
="item
Code !
= null and item
Code !
= ''">
and b.item_
code like upper(#{item
Code})||'%'
</if>
<if test
="prodModel
CodeList !
= null and prodModel
CodeList.size > 0">
and b.prod_model_
code in
<foreach collection
="prodModel
CodeList" 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
="prodLine
CodeList !
= null and prodLine
CodeList.size > 0">
and tbpc.prod_line_
code in
<foreach collection
="prodLine
CodeList" item
="item" separator
="," index
="index" open
="(" close
=")">
#{item}
</foreach>
</if>
<if test
="location
CodeList !
= null and location
CodeList.size > 0">
and twwi.location_
code in
<foreach collection
="location
CodeList" 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
="item
Code !
= null and item
Code !
= ''">
and twwi.item_
code like upper(#{item
Code})||'%'
</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
="prodSeries
CodeList !
= null and prodSeries
CodeList.size > 0">
and tbpc.prod_series_
code in
<foreach collection
="prodSeries
CodeList" open
="(" close
=")" separator
="," item
="item">
#{item}
</foreach>
</if>
<if test
="prodModel
CodeList !
= null and prodModel
CodeList.size > 0">
and twwi.prod_model_
code in
<foreach collection
="prodModel
CodeList" 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
="new
CodeList !
= null and new
CodeList.size > 0">
and item.new
code_flag in
<foreach collection
="new
CodeList" 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
="orderTypeList !
= null and orderTypeList.size > 0">
and twwi.order_type in
<foreach collection
="orderTypeList" item
="item" separator
="," open
="(" close
=")">
#{item}
</foreach>
</if>
<if test
="entitySubtypeNameList !
= null and entitySubtypeNameList.size > 0">
and twwi.entity_subtype_name in
<foreach collection
="entitySubtypeNameList" item
="item" separator
="," open
="(" close
=")">
#{item}
</foreach>
</if>
order by twf.fullset_status desc,
t.plan_start_time,
twwi.plan_online_time,
twf.workorder_name
</select>中order_type不展示
解决证书冲突问题
本文介绍了解决因Xcode5自动创建开发证书导致与原有手动创建的推送证书冲突的问题。通过重新下载并安装原有的推送证书来解决该问题。
扫一扫
4124
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
