| | |
| | | <where> |
| | | date(r.create_time)>=#{startDate} and date(r.create_time) <= #{endDate} |
| | | </where> |
| | | order by r.review_status,r.id desc |
| | | limit #{offset},#{pageSize}; |
| | | order by r.review_status,r.id desc limit #{offset},#{pageSize}; |
| | | </select> |
| | | |
| | | <select id="SelectReworkPageTotal" > |
| | |
| | | values ( |
| | | #{oddNumber}, #{rework.reportingWorkId},#{rework.processId},#{rework.orderId},#{rework.orderSort},#{rework.technologyNumber},#{rework.responsibleTeam}, |
| | | #{rework.responsiblePersonnel},#{rework.reworkType},#{rework.reworkReason},#{rework.reworkProcesses},#{rework.reworkNum}, |
| | | #{rework.reworkArea},#{rework.reworkTeam},#{rework.responsibleEquipment},#{rework.qualityInspector},"",0,now() |
| | | #{rework.reworkArea},#{rework.reworkTeam},#{rework.responsibleEquipment},#{rework.qualityInspector},'',0,now() |
| | | ) |
| | | </insert> |
| | | |