| | |
| | | @Mapper |
| | | public interface WorkOrderMapper extends BaseMapper<WorkOrder> { |
| | | |
| | | void page(IPage page, @Param("query") WorkOrderQuery query); |
| | | IPage page(IPage page, @Param("query") WorkOrderQuery query); |
| | | |
| | | List<WorkOrderVO> distributePage(@Param("query") DistributeWorkOrderQuery query); |
| | | |
| | |
| | | |
| | | <select id="page" resultType="com.ycl.platform.domain.vo.WorkOrderVO"> |
| | | SELECT |
| | | wo.*, |
| | | u.unit_name, |
| | | p.yw_person_name |
| | | wo.*, |
| | | u.unit_name, |
| | | p.yw_person_name |
| | | FROM |
| | | t_work_order wo |
| | | t_work_order wo |
| | | LEFT JOIN t_yw_unit u ON wo.unit_id = u.id and u.deleted = '0' |
| | | LEFT JOIN t_yw_people p ON wo.yw_people_id = p.id and p.deleted = '0' |
| | | where |