jeecg查询指定时间

jeecg查询指定时间

@ApiOperation(value="请假表-分页列表查询", notes="请假表-分页列表查询")
	@GetMapping(value = "/list")
	public Result<IPage<MlLeaveRequest>> queryPageList(MlLeaveRequest mlLeaveRequest,
								   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
								   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
								   HttpServletRequest req) {
		String today = "";
		if (mlLeaveRequest.getStartDate() != null) {
			//截取年月日
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			today = sdf.format(mlLeaveRequest.getStartDate());
			mlLeaveRequest.setStartDate(null);
		}
		QueryWrapper<MlLeaveRequest> queryWrapper = QueryGenerator.initQueryWrapper(mlLeaveRequest, req.getParameterMap());
		Page<MlLeaveRequest> page = new Page<MlLeaveRequest>(pageNo, pageSize);
	    if(today != null&& today != ""){
			queryWrapper.apply("DATE(start_date) = DATE({0})", today);
		}
		//}
		IPage<MlLeaveRequest> pageList = mlLeaveRequestService.page(page, queryWrapper);
		return Result.OK(pageList);
	}