| | |
| | | private Date completeDate; |
| | | |
| | | /** 自定义日期 */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "自定义日期", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date customTime; |
| | | // @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | // @Excel(name = "自定义日期", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | // private Date customTime; |
| | | } |
| | |
| | | private Date orderCreateTime; |
| | | |
| | | /** 自定义时间 */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "自定义时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date customTime; |
| | | // @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | // @Excel(name = "自定义时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | // private Date customTime; |
| | | |
| | | /** 生产基地 */ |
| | | @Excel(name = "生产基地") |
| | |
| | | <result property="hasDelayRisk" column="has_delay_risk" /> |
| | | <result property="startDate" column="start_date" /> |
| | | <result property="completeDate" column="complete_date" /> |
| | | <result property="customTime" column="custom_time" /> |
| | | <!-- <result property="customTime" column="custom_time" />--> |
| | | </resultMap> |
| | | |
| | | <select id="selectApsPlanOrderManager" parameterType="ApsPlateOrderPlanManager" resultMap="ApsPlateOrderPlanManagerResult"> |
| | |
| | | plan.plan_start_day, |
| | | plan.plan_end_day, |
| | | plan.unmatched_quantity, |
| | | plan.custom_time, |
| | | require.has_delay_risk, |
| | | plan.id, |
| | | require.start_date, |
| | |
| | | left join aps_plate_plan plan on detail.doc_no = plan.document_number |
| | | <where> |
| | | <if test="workOrderNo != null and workOrderNo != ''"> and detail.doc_no = #{workOrderNo}</if> |
| | | <if test="requireId != null and requireId != ''"> and detail.require_id = #{requireId}</if> |
| | | <if test="requireTrackId != null and requireTrackId != ''"> and detail.require_track_id = #{requireTrackId}</if> |
| | | <if test="mainPartNumber != null and mainPartNumber != ''"> and plan.main_part_number = #{mainPartNumber}</if> |
| | | <if test="hasDelayRisk != null and hasDelayRisk != ''"> and require.has_delay_risk = #{hasDelayRisk}</if> |
| | | </where> |
| | |
| | | |
| | | <update id="updatePlanDateByCustom" parameterType="ApsPlateOrderPlanDate"> |
| | | update aps_plate_plan set |
| | | custom_time = #{customDate}, |
| | | plan_end_day = #{customDate}, |
| | | update_by = #{updateBy}, |
| | | update_time = now() |
| | | where id in |