| | |
| | | @Override |
| | | public IPage<DispatcherUnitVO> selectDispatcherUnitPage(IPage<DispatcherUnitVO> page, DispatcherUnitVO dispatcherUnitVO) { |
| | | List<DispatcherUnitVO> dispatcherUnitVOS = baseMapper.selectDispatcherUnitPage(page, dispatcherUnitVO); |
| | | dispatcherUnitVOS.forEach(dispatcherUnitVO1 -> { |
| | | //查询派遣记录条数 |
| | | dispatcherUnitVO1.setNum(dispatcherService.getDispatcherCount(dispatcherUnitVO1)); |
| | | }); |
| | | // dispatcherUnitVOS.forEach(dispatcherUnitVO1 -> { |
| | | // //查询派遣记录条数 |
| | | // dispatcherUnitVO1.setNum(dispatcherService.getDispatcherCount(dispatcherUnitVO1)); |
| | | // }); |
| | | return page.setRecords(dispatcherUnitVOS); |
| | | } |
| | | |
| | |
| | | dispatcherUnit.setPhone(dispatcherUnitExcel.getPhone()); |
| | | } |
| | | |
| | | if (dispatcherUnitExcel.getSecurityLinkman()!=null && dispatcherUnitExcel.getSecurityLinkman()!=""){ |
| | | dispatcherUnit.setSecurityLinkman(dispatcherUnitExcel.getSecurityLinkman()); |
| | | } |
| | | |
| | | if (dispatcherUnitExcel.getCell()!=null && dispatcherUnitExcel.getCell()!=""){ |
| | | dispatcherUnit.setCell(dispatcherUnitExcel.getCell()); |
| | | } |
| | | |
| | | if (dispatcherUnitExcel.getServeType()!=null && dispatcherUnitExcel.getServeType()!=""){ |
| | | dispatcherUnit.setServeType(dispatcherUnitExcel.getServeType()); |
| | | } |
| | | |
| | | if (dispatcherUnitExcel.getNum()!=null){ |
| | | dispatcherUnit.setNum(dispatcherUnitExcel.getNum()); |
| | | } |
| | | |
| | | dispatcherUnit.setStartTime(dispatcherUnitExcel.getStartTime()); |
| | | dispatcherUnit.setEndTime(dispatcherUnitExcel.getEndTime()); |
| | | |
| | |
| | | |
| | | //数据同步 |
| | | String s1 = |
| | | "insert into sys_dispatcher_unit(id,name,dept_id,linkman,phone,create_time,start_time,end_time) " + |
| | | "insert into sys_dispatcher_unit(id,name,dept_id,linkman,phone,create_time,start_time,end_time,serve_type,security_linkman,cell,num) " + |
| | | "values(" + "'" + dispatcherUnit.getId() + "'" + "," + |
| | | "'" + dispatcherUnit.getName() + "'" + "," + |
| | | "'" + dispatcherUnit.getDeptId() + "'" + "," + |
| | |
| | | "'" + dispatcherUnit.getPhone() + "'" + "," + |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(dispatcherUnit.getCreateTime()) + "'" + "," + |
| | | "'" + new SimpleDateFormat("yyyy/MM/dd").format(dispatcherUnit.getStartTime()) + "'" + "," + |
| | | "'" + new SimpleDateFormat("yyyy/MM/dd").format(dispatcherUnit.getEndTime()) + "'" + ")"; |
| | | "'" + new SimpleDateFormat("yyyy/MM/dd").format(dispatcherUnit.getEndTime()) + "'" + "," + |
| | | "'" + dispatcherUnit.getServeType() + "'" + "," + |
| | | "'" + dispatcherUnit.getSecurityLinkman() + "'" + "," + |
| | | "'" + dispatcherUnit.getCell() + "'" + "," + |
| | | "'" + dispatcherUnit.getNum() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | }); |
| | | } |