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<Object> table1(PageVo page) {
|
String format = DateUtil.format(new Date(), "yyyy-MM-dd");
|
QueryWrapper<DrivingRecord> wp = new QueryWrapper<>();
|
wp.between("a.create_time",format+" 00:00:00",format+" 23:59:59");
|
IPage<DrivingRecord> page1 = iDrivingRecordService.page2(PageUtil.initMpPage(page), wp);
|
return new ResultUtil<Object>().setData(page1);
|
}
|
|
//0配送中，1已送达，2异常签收
|
@RequestMapping(value = "/table2", method = RequestMethod.GET)
|
@ApiOperation(value = "订单配送")
|
public Result<Object> table2(PageVo page,String sendDate,Integer status) {
|
QueryWrapper<OrderTask> wrapper = new QueryWrapper<>();
|
if(StrUtil.isNotEmpty(sendDate)){
|
wrapper.eq("o.send_date",sendDate);
|
}
|
if(status!=null){
|
wrapper.eq("o.status",status);
|
}
|
IPage<OrderTask> data = iOrderTaskService.page3(PageUtil.initMpPage(page),wrapper);
|
return new ResultUtil<Object>().setData(data);
|
}
|
|
@RequestMapping(value = "/table3", method = RequestMethod.GET)
|
@ApiOperation(value = "异常签收")
|
public Result<Object> table3(PageVo page,Integer type,String carNo) {
|
QueryWrapper<Alarm> queryWrapper = new QueryWrapper<>();
|
if(type!=null){
|
queryWrapper.eq("type",type);
|
}
|
if(StrUtil.isNotEmpty(carNo)){
|
queryWrapper.like("car_no","%"+carNo+"%");
|
}
|
IPage<Alarm> data = iAlarmService.page(PageUtil.initMpPage(page),queryWrapper);
|
return new ResultUtil<Object>().setData(data);
|
}
|
|
@RequestMapping(value = "/table4", method = RequestMethod.GET)
|
@ApiOperation(value = "今日新增商户")
|
public Result<Object> table4(PageVo page) {
|
QueryWrapper<Customer> 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<Customer> data = iCustomerService.page(PageUtil.initMpPage(page),wrapper);
|
return new ResultUtil<Object>().setData(data);
|
}
|
}
|
