package cn.exrick.xboot.your.controller.pc; import cn.exrick.xboot.core.common.utils.PageUtil; import cn.exrick.xboot.core.common.utils.ResultUtil; import cn.exrick.xboot.core.common.vo.PageVo; import cn.exrick.xboot.core.common.vo.Result; import cn.exrick.xboot.your.entity.*; import cn.exrick.xboot.your.service.*; import cn.hutool.core.date.DateUtil; import cn.hutool.core.util.StrUtil; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RestController; import java.util.Date; /** * @author whj */ @Slf4j @RestController @Api(tags = "大屏统计其他页面接口3") @RequestMapping("/xboot/pcStatistic3") @Transactional public class Statistic3Controller { @Autowired private ICustomerService iCustomerService; @Autowired private IAlarmService iAlarmService; @Autowired private IOrderTaskService iOrderTaskService; @Autowired private IDrivingRecordService iDrivingRecordService; @RequestMapping(value = "/table1", method = RequestMethod.GET) @ApiOperation(value = "获取出发车辆") public Result table1(PageVo page) { String format = DateUtil.format(new Date(), "yyyy-MM-dd"); QueryWrapper wp = new QueryWrapper<>(); wp.between("a.create_time",format+" 00:00:00",format+" 23:59:59"); IPage page1 = iDrivingRecordService.page2(PageUtil.initMpPage(page), wp); return new ResultUtil().setData(page1); } //0配送中,1已送达,2异常签收 @RequestMapping(value = "/table2", method = RequestMethod.GET) @ApiOperation(value = "订单配送") public Result table2(PageVo page,String sendDate,Integer status) { QueryWrapper wrapper = new QueryWrapper<>(); if(StrUtil.isNotEmpty(sendDate)){ wrapper.eq("o.send_date",sendDate); } if(status!=null){ wrapper.eq("o.status",status); } IPage data = iOrderTaskService.page3(PageUtil.initMpPage(page),wrapper); return new ResultUtil().setData(data); } @RequestMapping(value = "/table3", method = RequestMethod.GET) @ApiOperation(value = "异常签收") public Result table3(PageVo page,Integer type,String carNo) { QueryWrapper queryWrapper = new QueryWrapper<>(); if(type!=null){ queryWrapper.eq("type",type); } if(StrUtil.isNotEmpty(carNo)){ queryWrapper.like("car_no","%"+carNo+"%"); } IPage data = iAlarmService.page(PageUtil.initMpPage(page),queryWrapper); return new ResultUtil().setData(data); } @RequestMapping(value = "/table4", method = RequestMethod.GET) @ApiOperation(value = "今日新增商户") public Result table4(PageVo page) { QueryWrapper wrapper = new QueryWrapper<>(); String format = DateUtil.format(new Date(), "yyyy-MM-dd"); wrapper.between("create_time",format+" 00:00:00",format+" 23:59:59"); IPage data = iCustomerService.page(PageUtil.initMpPage(page),wrapper); return new ResultUtil().setData(data); } }