| | |
| | | String maintenanceOrderId = maintenanceThreeAcceptance.getMaintenanceOrderId(); |
| | | List<MaintenanceThreeAcceptance> maintenanceThreeAcceptances = maintenanceThreeAcceptance.getMaintenanceThreeAcceptances(); |
| | | for (MaintenanceThreeAcceptance threeAcceptance : maintenanceThreeAcceptances) { |
| | | threeAcceptance.setMaintenanceOrderId(maintenanceOrderId); |
| | | threeAcceptance.setId(""); |
| | | maintenanceThreeAcceptanceService.saveOrUpdate(threeAcceptance); |
| | | } |
| | | DailyMaintenanceOrder maintenanceOrder = dailyMaintenanceOrderService.getById(maintenanceOrderId); |
| | |
| | | /**3保工单id*/ |
| | | @Excel(name = "3保工单id", width = 15) |
| | | @ApiModelProperty(value = "3保工单id") |
| | | private java.lang.String maintenanceOrderId; |
| | | private java.lang.String maintenanceOrderDetailId; |
| | | /**保养部位*/ |
| | | @Excel(name = "保养部位", width = 15) |
| | | @ApiModelProperty(value = "保养部位") |
| | |
| | | |
| | | @TableField(exist = false) |
| | | private List<MaintenanceThreeAcceptance> maintenanceThreeAcceptances; |
| | | |
| | | @TableField(exist = false) |
| | | private String maintenanceOrderId; |
| | | } |
| | |
| | | |
| | | <select id="getMaintenanceThreeAcceptanceList" parameterType="Map" resultType="Map"> |
| | | SELECT |
| | | t1.id AS id, |
| | | t1.position, |
| | | t1.content, |
| | | t1.standard, |
| | | t1.first_inspect as firstInspect, |
| | | t1.second_inspect as secondInspect |
| | | t1.id, |
| | | t1.id as maintenanceOrderDetailId, |
| | | t1.daily_maintenance_order_id AS maintenanceOrderId, |
| | | t2.location AS position, |
| | | t3.name AS content, |
| | | t3.standard, |
| | | t4.first_inspect AS firstInspect, |
| | | t4.second_inspect AS secondInspect |
| | | FROM |
| | | mom_eam_maintenance_three_acceptance t1 |
| | | WHERE t1.del_flag = '0' AND t1.maintenance_order_id = #{maintenanceOrderId} |
| | | mom_eam_daily_maintenance_order_detail t1 |
| | | LEFT JOIN mom_eam_maintenance_standard_detail t2 ON t1.maintenance_standard_detail_id = t2.id |
| | | LEFT JOIN mom_eam_maintenance_project t3 ON t1.maintenance_project_id = t3.id |
| | | LEFT JOIN mom_eam_maintenance_three_acceptance t4 ON t1.id = t4.maintenance_order_detail_id |
| | | WHERE t1.del_flag = '0' AND t1.daily_maintenance_order_id = #{maintenanceOrderId} |
| | | </select> |
| | | </mapper> |