| | |
| | | e.printStackTrace(); |
| | | }*/ |
| | | } |
| | | |
| | | /** |
| | | * 查询所有的工单,所有人可见 |
| | | * @param param |
| | | * @return |
| | | */ |
| | | public Response getAllPage(WorksheetMain param) { |
| | | Integer pageNum = param.getPageNum(); |
| | | Integer pageSize = param.getPageSize(); |
| | | PageHelper.startPage(pageNum,pageSize); |
| | | |
| | | int createUserId = param.getCreateUserId().intValue(); |
| | | Date beginTime = param.getBeginTime(); |
| | | Date endTime = param.getEndTime(); |
| | | Integer type = param.getType(); |
| | | QueryWrapper<WorksheetMain> query = Wrappers.query(); |
| | | if(createUserId>0){ |
| | | query.eq("create_user_id",createUserId); |
| | | } |
| | | query.ge("begin_time",beginTime); |
| | | query.le("begin_time",endTime); |
| | | if(type!=null && type>=0){ |
| | | query.eq("type",type); |
| | | } |
| | | List<WorksheetMain> worksheetMains = mainMapper.selectList(query); |
| | | PageInfo pageInfo = new PageInfo(worksheetMains); |
| | | return new Response().set(1,pageInfo); |
| | | } |
| | | } |