From 433ba5ddafd57d6ce6173a6ba7d2d97851c5a4c6 Mon Sep 17 00:00:00 2001
From: wang-hao-jie <1550036656@qq.com>
Date: 星期一, 08 十一月 2021 15:24:36 +0800
Subject: [PATCH] 订单

---
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/DrivingRecordController.java    |   24 +
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/UserStatistic.java                  |   75 +++++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IOrderTaskServiceImpl.java     |   41 ++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/OrderTaskMapper.java                |   30 ++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/UserStatisticMapper.java            |   14 +
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IUserStatisticService.java         |   14 +
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderTask.java                      |  108 +++++++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderDetail.java                    |   40 ++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/OrderDetailMapper.java              |   14 +
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/UserStatisticController.java    |   89 ++++++
 xboot-modules/xboot-your/src/main/resources/mapper/OrderDetailMapper.xml                               |    5 
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IOrderTaskService.java             |   18 +
 xboot-modules/xboot-your/src/main/resources/mapper/UserStatisticMapper.xml                             |    5 
 xboot-modules/xboot-your/src/main/resources/mapper/OrderTaskMapper.xml                                 |    5 
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/OrderTaskController.java        |  173 ++++++++++++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IOrderDetailService.java           |   14 +
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IUserStatisticServiceImpl.java |   26 +
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/DrivingRecord.java                  |    5 
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IOrderDetailServiceImpl.java   |   26 +
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/OrderDetailController.java      |   77 +++++
 20 files changed, 803 insertions(+), 0 deletions(-)

diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/DrivingRecordController.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/DrivingRecordController.java
index d58b1e4..a25007c 100644
--- a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/DrivingRecordController.java
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/DrivingRecordController.java
@@ -5,7 +5,9 @@
 import cn.exrick.xboot.core.common.vo.PageVo;
 import cn.exrick.xboot.core.common.vo.Result;
 import cn.exrick.xboot.your.entity.DrivingRecord;
+import cn.exrick.xboot.your.entity.OrderTask;
 import cn.exrick.xboot.your.service.IDrivingRecordService;
+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;
@@ -16,6 +18,7 @@
 import org.springframework.web.bind.annotation.*;
 import org.springframework.transaction.annotation.Transactional;
 
+import java.util.Date;
 import java.util.List;
 
 /**
@@ -31,6 +34,27 @@
     @Autowired
     private IDrivingRecordService iDrivingRecordService;
 
+    @RequestMapping(value = "/orderConfirm", method = RequestMethod.POST)
+    @ApiOperation(value = "璁㈠崟纭")
+    public Result<DrivingRecord> orderConfirm(DrivingRecord record) {
+        if(StrUtil.isEmpty(record.getCarId())){
+            return ResultUtil.error("杞﹁締id涓嶈兘涓虹┖");
+        }
+
+        String format = DateUtil.format(new Date(), "yyyy-MM-dd");
+        QueryWrapper<DrivingRecord> wrapper = new QueryWrapper<>();
+        wrapper.eq("driving_date",format);
+        wrapper.eq("car_id",record.getCarId());
+        int count = iDrivingRecordService.count(wrapper);
+        if(count>0){
+            return ResultUtil.error("浠婃棩宸叉牳瀵癸紝璇峰嬁閲嶅鎻愪氦");
+        }
+
+        record.setDrivingDate(DateUtil.parse(format));
+        iDrivingRecordService.saveOrUpdate(record);
+        return ResultUtil.success("鎿嶄綔鎴愬姛");
+    }
+
     @RequestMapping(value = "/get/{id}", method = RequestMethod.GET)
     @ApiOperation(value = "閫氳繃id鑾峰彇")
     public Result<DrivingRecord> get(@PathVariable String id) {
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/OrderDetailController.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/OrderDetailController.java
new file mode 100644
index 0000000..a2ac584
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/OrderDetailController.java
@@ -0,0 +1,77 @@
+package cn.exrick.xboot.your.controller;
+
+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.OrderDetail;
+import cn.exrick.xboot.your.service.IOrderDetailService;
+import cn.hutool.core.util.StrUtil;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+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.web.bind.annotation.*;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.List;
+
+/**
+ * @author whj
+ */
+@Slf4j
+@RestController
+@Api(tags = "璁㈠崟璇︽儏琛ㄧ鐞嗘帴鍙�")
+@RequestMapping("/xboot/orderDetail")
+@Transactional
+public class OrderDetailController {
+
+    @Autowired
+    private IOrderDetailService iOrderDetailService;
+
+    @RequestMapping(value = "/get/{id}", method = RequestMethod.GET)
+    @ApiOperation(value = "閫氳繃id鑾峰彇")
+    public Result<OrderDetail> get(@PathVariable String id) {
+
+        OrderDetail orderDetail = iOrderDetailService.getById(id);
+        return new ResultUtil<OrderDetail>().setData(orderDetail);
+    }
+
+    @RequestMapping(value = "/getAll", method = RequestMethod.GET)
+    @ApiOperation(value = "鑾峰彇鍏ㄩ儴鏁版嵁")
+    public Result<List<OrderDetail>> getAll() {
+
+        List<OrderDetail> list = iOrderDetailService.list();
+        return new ResultUtil<List<OrderDetail>>().setData(list);
+    }
+
+    @RequestMapping(value = "/getByPage", method = RequestMethod.GET)
+    @ApiOperation(value = "鍒嗛〉鑾峰彇")
+    public Result<IPage<OrderDetail>> getByPage(PageVo page) {
+
+        IPage<OrderDetail> data = iOrderDetailService.page(PageUtil.initMpPage(page));
+        return new ResultUtil<IPage<OrderDetail>>().setData(data);
+    }
+
+    @RequestMapping(value = "/insertOrUpdate", method = RequestMethod.POST)
+    @ApiOperation(value = "缂栬緫鎴栨洿鏂版暟鎹�")
+    public Result<OrderDetail> saveOrUpdate(OrderDetail orderDetail) {
+
+        if (iOrderDetailService.saveOrUpdate(orderDetail)) {
+            return new ResultUtil<OrderDetail>().setData(orderDetail);
+        }
+        return new ResultUtil<OrderDetail>().setErrorMsg("鎿嶄綔澶辫触");
+    }
+
+    @RequestMapping(value = "/delByIds", method = RequestMethod.POST)
+    @ApiOperation(value = "鎵归噺閫氳繃id鍒犻櫎")
+    public Result<Object> delAllByIds(@RequestParam String[] ids) {
+
+        for (String id : ids) {
+            iOrderDetailService.removeById(id);
+        }
+        return ResultUtil.success("鎵归噺閫氳繃id鍒犻櫎鏁版嵁鎴愬姛");
+    }
+}
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/OrderTaskController.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/OrderTaskController.java
new file mode 100644
index 0000000..b2e05eb
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/OrderTaskController.java
@@ -0,0 +1,173 @@
+package cn.exrick.xboot.your.controller;
+
+import cn.exrick.xboot.core.common.utils.PageUtil;
+import cn.exrick.xboot.core.common.utils.ResultUtil;
+import cn.exrick.xboot.core.common.utils.SecurityUtil;
+import cn.exrick.xboot.core.common.vo.PageVo;
+import cn.exrick.xboot.core.common.vo.Result;
+import cn.exrick.xboot.your.entity.Area;
+import cn.exrick.xboot.your.entity.OrderDetail;
+import cn.exrick.xboot.your.entity.OrderTask;
+import cn.exrick.xboot.your.service.IAreaService;
+import cn.exrick.xboot.your.service.ICustomerService;
+import cn.exrick.xboot.your.service.IOrderDetailService;
+import cn.exrick.xboot.your.service.IOrderTaskService;
+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 io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.Date;
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * @author whj
+ */
+@Slf4j
+@RestController
+@Api(tags = "璁㈠崟鎺ュ彛")
+@RequestMapping("/xboot/orderTask")
+@Transactional
+public class OrderTaskController {
+
+    @Autowired
+    private IOrderTaskService iOrderTaskService;
+
+    @Autowired
+    private IAreaService iAreaService;
+
+    @Autowired
+    private ICustomerService iCustomerService;
+
+    @Autowired
+    private IOrderDetailService iOrderDetailService;
+
+    @Autowired
+    private SecurityUtil securityUtil;
+
+    @RequestMapping(value = "/get/{id}", method = RequestMethod.GET)
+    @ApiOperation(value = "閫氳繃id鑾峰彇")
+    public Result<OrderTask> get(@PathVariable String id) {
+
+        OrderTask orderTask = iOrderTaskService.getById(id);
+        return new ResultUtil<OrderTask>().setData(orderTask);
+    }
+
+    @RequestMapping(value = "/getByUserId", method = RequestMethod.GET)
+    @ApiOperation(value = "鑾峰彇浠婃棩浠诲姟缁熻淇℃伅")
+    public Result<Object> getAll() {
+        QueryWrapper<Area> wrapper = new QueryWrapper<Area>();
+        wrapper.eq("user_id",securityUtil.getCurrUser().getId());
+        Area area = iAreaService.getOne(wrapper);
+        if(area==null){
+            return ResultUtil.error("璇疯仈绯荤鐞嗗憳缁戝畾鐗囧尯閰嶉�佸憳");
+        }
+
+        QueryWrapper<OrderTask> wrapper2 = new QueryWrapper<OrderTask>();
+        String format = DateUtil.format(new Date(), "yyyy-MM-dd");
+        wrapper2.eq("area_id",area.getId());
+        wrapper2.eq("send_date",format);
+        int count = iOrderTaskService.count(wrapper2);
+
+        int sum = iOrderTaskService.sum(area.getId(),format);
+
+        Map<String,Object> map = new HashMap<String,Object>();
+        map.put("count",count);
+        map.put("sum",sum);
+        return new ResultUtil<Object>().setData(map);
+    }
+
+    @RequestMapping(value = "/getTodayOrder", method = RequestMethod.GET)
+    @ApiOperation(value = "鑾峰彇浠婃棩浠诲姟璇︽儏")
+    public Result<List<OrderTask>> getTodayOrder() {
+        QueryWrapper<Area> wrapper = new QueryWrapper<Area>();
+        wrapper.eq("user_id",securityUtil.getCurrUser().getId());
+        Area area = iAreaService.getOne(wrapper);
+        if(area==null){
+            return ResultUtil.error("璇疯仈绯荤鐞嗗憳缁戝畾鐗囧尯閰嶉�佸憳");
+        }
+
+        QueryWrapper<OrderTask> wrapper2 = new QueryWrapper<OrderTask>();
+        String format = DateUtil.format(new Date(), "yyyy-MM-dd");
+        wrapper2.eq("a.area_id",area.getId());
+        wrapper2.eq("a.send_date",format);
+        wrapper2.orderByAsc("a.seq");
+        List<OrderTask> list = iOrderTaskService.list2(wrapper2);
+        return new ResultUtil<List<OrderTask>>().setData(list);
+    }
+
+    @RequestMapping(value = "/getTodayOrderDetail", method = RequestMethod.GET)
+    @ApiOperation(value = "鑾峰彇褰撳墠閰嶉�佸晢鎴疯鎯�")
+    public Result<OrderTask> getTodayOrderDetail(String orderId) {
+        OrderTask orderTask = new OrderTask();
+        if(!StrUtil.isEmpty(orderId)){
+            orderTask = iOrderTaskService.getById(orderId);
+            if(orderTask.getStatus()!=0){
+                return ResultUtil.error("姝ゅ晢鎴峰凡閰嶉��");
+            }
+        }else{
+            QueryWrapper<Area> wrapper = new QueryWrapper<Area>();
+            wrapper.eq("user_id",securityUtil.getCurrUser().getId());
+            Area area = iAreaService.getOne(wrapper);
+            if(area==null){
+                return ResultUtil.error("璇疯仈绯荤鐞嗗憳缁戝畾鐗囧尯閰嶉�佸憳");
+            }
+
+            QueryWrapper<OrderTask> wrapper2 = new QueryWrapper<OrderTask>();
+            String format = DateUtil.format(new Date(), "yyyy-MM-dd");
+            wrapper2.eq("area_id",area.getId());
+            wrapper2.eq("send_date",format);
+            wrapper2.ne("status",0);
+            wrapper2.orderByAsc("seq");
+            List<OrderTask> list = iOrderTaskService.list(wrapper2);
+            if(list.size()>0){
+                orderTask = list.get(0);
+            }else{
+                return new ResultUtil<OrderTask>().setData(null);
+            }
+        }
+
+        orderTask.setCustomer(iCustomerService.getById(orderTask.getCustomerId()));
+        QueryWrapper<OrderDetail> wrapper3 = new QueryWrapper<OrderDetail>();
+        wrapper3.eq("order_id",orderTask.getId());
+        orderTask.setOrderDetails(iOrderDetailService.list(wrapper3));
+
+        return new ResultUtil<OrderTask>().setData(orderTask);
+    }
+
+    @RequestMapping(value = "/getByPage", method = RequestMethod.GET)
+    @ApiOperation(value = "鍒嗛〉鑾峰彇")
+    public Result<IPage<OrderTask>> getByPage(PageVo page) {
+
+        IPage<OrderTask> data = iOrderTaskService.page(PageUtil.initMpPage(page));
+        return new ResultUtil<IPage<OrderTask>>().setData(data);
+    }
+
+    @RequestMapping(value = "/insertOrUpdate", method = RequestMethod.POST)
+    @ApiOperation(value = "缂栬緫鎴栨洿鏂版暟鎹�")
+    public Result<OrderTask> saveOrUpdate(OrderTask orderTask) {
+
+        if (iOrderTaskService.saveOrUpdate(orderTask)) {
+            return new ResultUtil<OrderTask>().setData(orderTask);
+        }
+        return new ResultUtil<OrderTask>().setErrorMsg("鎿嶄綔澶辫触");
+    }
+
+    @RequestMapping(value = "/delByIds", method = RequestMethod.POST)
+    @ApiOperation(value = "鎵归噺閫氳繃id鍒犻櫎")
+    public Result<Object> delAllByIds(@RequestParam String[] ids) {
+
+        for (String id : ids) {
+            iOrderTaskService.removeById(id);
+        }
+        return ResultUtil.success("鎵归噺閫氳繃id鍒犻櫎鏁版嵁鎴愬姛");
+    }
+}
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/UserStatisticController.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/UserStatisticController.java
new file mode 100644
index 0000000..c5a00b1
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/UserStatisticController.java
@@ -0,0 +1,89 @@
+package cn.exrick.xboot.your.controller;
+
+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.UserStatistic;
+import cn.exrick.xboot.your.service.IUserStatisticService;
+import cn.hutool.core.util.StrUtil;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+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.web.bind.annotation.*;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.List;
+
+/**
+ * @author whj
+ */
+@Slf4j
+@RestController
+@Api(tags = "鐢ㄦ埛缁熻琛ㄧ鐞嗘帴鍙�")
+@RequestMapping("/xboot/userStatistic")
+@Transactional
+public class UserStatisticController {
+
+    @Autowired
+    private IUserStatisticService iUserStatisticService;
+
+    @RequestMapping(value = "/get/{id}", method = RequestMethod.GET)
+    @ApiOperation(value = "閫氳繃id鑾峰彇")
+    public Result<UserStatistic> get(@PathVariable String id) {
+
+        UserStatistic userStatistic = iUserStatisticService.getById(id);
+        return new ResultUtil<UserStatistic>().setData(userStatistic);
+    }
+
+    @RequestMapping(value = "/getByUserId", method = RequestMethod.GET)
+    @ApiOperation(value = "閫氳繃鐢ㄦ埛id鑾峰彇缁熻淇℃伅")
+    public Result<UserStatistic> getByUserId(String userId) {
+        QueryWrapper<UserStatistic> wrapper = new QueryWrapper<>();
+        wrapper.eq("user_id",userId);
+        UserStatistic userStatistic = iUserStatisticService.getOne(wrapper);
+        if(userStatistic==null){
+            return new ResultUtil<UserStatistic>().setData(new UserStatistic());
+        }
+        return new ResultUtil<UserStatistic>().setData(userStatistic);
+    }
+
+    @RequestMapping(value = "/getAll", method = RequestMethod.GET)
+    @ApiOperation(value = "鑾峰彇鍏ㄩ儴鏁版嵁")
+    public Result<List<UserStatistic>> getAll() {
+
+        List<UserStatistic> list = iUserStatisticService.list();
+        return new ResultUtil<List<UserStatistic>>().setData(list);
+    }
+
+    @RequestMapping(value = "/getByPage", method = RequestMethod.GET)
+    @ApiOperation(value = "鍒嗛〉鑾峰彇")
+    public Result<IPage<UserStatistic>> getByPage(PageVo page) {
+
+        IPage<UserStatistic> data = iUserStatisticService.page(PageUtil.initMpPage(page));
+        return new ResultUtil<IPage<UserStatistic>>().setData(data);
+    }
+
+    @RequestMapping(value = "/insertOrUpdate", method = RequestMethod.POST)
+    @ApiOperation(value = "缂栬緫鎴栨洿鏂版暟鎹�")
+    public Result<UserStatistic> saveOrUpdate(UserStatistic userStatistic) {
+
+        if (iUserStatisticService.saveOrUpdate(userStatistic)) {
+            return new ResultUtil<UserStatistic>().setData(userStatistic);
+        }
+        return new ResultUtil<UserStatistic>().setErrorMsg("鎿嶄綔澶辫触");
+    }
+
+    @RequestMapping(value = "/delByIds", method = RequestMethod.POST)
+    @ApiOperation(value = "鎵归噺閫氳繃id鍒犻櫎")
+    public Result<Object> delAllByIds(@RequestParam String[] ids) {
+
+        for (String id : ids) {
+            iUserStatisticService.removeById(id);
+        }
+        return ResultUtil.success("鎵归噺閫氳繃id鍒犻櫎鏁版嵁鎴愬姛");
+    }
+}
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/DrivingRecord.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/DrivingRecord.java
index 430fd7a..047051b 100644
--- a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/DrivingRecord.java
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/DrivingRecord.java
@@ -31,6 +31,11 @@
     @ApiModelProperty(value = "杞﹁締id")
     private String carId;
 
+    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    @ApiModelProperty(value = "琛岃溅鏃ユ湡")
+    private Date drivingDate;
+
     @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
     @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     @ApiModelProperty(value = "鍑鸿溅鏃堕棿")
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderDetail.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderDetail.java
new file mode 100644
index 0000000..f3fd58f
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderDetail.java
@@ -0,0 +1,40 @@
+package cn.exrick.xboot.your.entity;
+
+import cn.exrick.xboot.core.base.XbootBaseEntity;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.hibernate.annotations.DynamicInsert;
+import org.hibernate.annotations.DynamicUpdate;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import javax.persistence.Entity;
+import javax.persistence.Table;
+import java.util.Date;
+
+/**
+ * @author Exrick
+ */
+@Data
+@Entity
+@DynamicInsert
+@DynamicUpdate
+@Table(name = "t_order_detail")
+@TableName("t_order_detail")
+@ApiModel(value = "璁㈠崟璇︽儏琛�")
+public class OrderDetail extends XbootBaseEntity {
+
+    private static final long serialVersionUID = 1L;
+
+    @ApiModelProperty(value = "璁㈠崟id")
+    private String orderId;
+
+    @ApiModelProperty(value = "浜у搧鍚嶇О")
+    private String product;
+
+    @ApiModelProperty(value = "鏁伴噺")
+    private String num;
+
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderTask.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderTask.java
new file mode 100644
index 0000000..f7c91c6
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/OrderTask.java
@@ -0,0 +1,108 @@
+package cn.exrick.xboot.your.entity;
+
+import cn.exrick.xboot.core.base.XbootBaseEntity;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.hibernate.annotations.DynamicInsert;
+import org.hibernate.annotations.DynamicUpdate;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import javax.persistence.Entity;
+import javax.persistence.Table;
+import javax.persistence.Transient;
+import java.util.Date;
+import java.util.List;
+
+/**
+ * @author Exrick
+ */
+@Data
+@Entity
+@DynamicInsert
+@DynamicUpdate
+@Table(name = "t_order_task")
+@TableName("t_order_task")
+@ApiModel(value = "璁㈠崟浠诲姟琛�")
+public class OrderTask extends XbootBaseEntity {
+
+    private static final long serialVersionUID = 1L;
+
+    @ApiModelProperty(value = "璁㈠崟鍙�")
+    private String code;
+
+    @ApiModelProperty(value = "瀹㈡埛id")
+    private String customerId;
+
+    @ApiModelProperty(value = "杞﹁締id")
+    private String carId;
+
+    @ApiModelProperty(value = "鐗囧尯id")
+    private String areaId;
+
+    @ApiModelProperty(value = "鍒嗘id")
+    private String areaSectionId;
+
+    @ApiModelProperty(value = "閰嶉�佷汉id")
+    private String userId;
+
+    @ApiModelProperty(value = "璁㈠崟椤哄簭")
+    private int seq;
+
+    @ApiModelProperty(value = "鍖呮暟")
+    private int num;
+
+    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    @ApiModelProperty(value = "璁㈠崟鏃�")
+    private Date orderDate;
+
+    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    @ApiModelProperty(value = "灏佸寘鏃�")
+    private Date endDate;
+
+    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
+    @DateTimeFormat(pattern = "yyyy-MM-dd")
+    @ApiModelProperty(value = "閰嶉�佹棩")
+    private Date sendDate;
+
+    @ApiModelProperty(value = "閫佽揪鐓х墖")
+    private String img;
+
+    @ApiModelProperty(value = "鏄惁杩涜瑁呰溅锛�0锛氬惁  1:鏄級")
+    private int isPut;
+
+    @ApiModelProperty(value = "鏄惁椹跺嚭鏈堝彴锛�0锛氬惁  1:鏄級")
+    private int isOut;
+
+    @ApiModelProperty(value = "0閰嶉�佷腑锛�1宸查�佽揪锛�2鏃犳硶閫佽揪锛�3寮傚父绛炬敹")
+    private int status;
+
+    @ApiModelProperty(value = "鏃犳硶閫佽揪鐨勫師鍥�")
+    private String remarks;
+
+    @ApiModelProperty(value = "鍟嗘埛璇勪环 1鏄� 2鏄� 3鏄� 4鏄� 5鏄�")
+    private int level;
+
+    @ApiModelProperty(value = "绛炬敹璇勪环")
+    private String evaluate;
+
+    @Transient
+    @TableField(exist = false)
+    @ApiModelProperty(value = "鍟嗘埛鍚嶇О")
+    private String customerName;
+
+    @Transient
+    @TableField(exist = false)
+    @ApiModelProperty(value = "鍟嗘埛")
+    private Customer customer;
+
+    @Transient
+    @TableField(exist = false)
+    @ApiModelProperty(value = "璁㈠崟璇︽儏")
+    private List<OrderDetail> orderDetails;
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/UserStatistic.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/UserStatistic.java
new file mode 100644
index 0000000..f908b27
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/UserStatistic.java
@@ -0,0 +1,75 @@
+package cn.exrick.xboot.your.entity;
+
+import cn.exrick.xboot.core.base.XbootBaseEntity;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.hibernate.annotations.DynamicInsert;
+import org.hibernate.annotations.DynamicUpdate;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import javax.persistence.Entity;
+import javax.persistence.Table;
+import java.util.Date;
+
+/**
+ * @author Exrick
+ */
+@Data
+@Entity
+@DynamicInsert
+@DynamicUpdate
+@Table(name = "t_user_statistic")
+@TableName("t_user_statistic")
+@ApiModel(value = "鐢ㄦ埛缁熻琛�")
+public class UserStatistic extends XbootBaseEntity {
+
+    private static final long serialVersionUID = 1L;
+
+    @ApiModelProperty(value = "鐢ㄦ埛id")
+    private String userId;
+
+    @ApiModelProperty(value = "骞冲畨椹鹃┒")
+    private int safeDriving;
+
+    @ApiModelProperty(value = "鍑鸿溅娆℃暟")
+    private int outCar;
+
+    @ApiModelProperty(value = "椹鹃┒閲岀▼")
+    private int driving;
+
+    @ApiModelProperty(value = "鐤插姵椹鹃┒")
+    private int fatigueDriving;
+
+    @ApiModelProperty(value = "涓嶇郴瀹夊叏甯�")
+    private int noBelt;
+
+    @ApiModelProperty(value = "鎶界儫")
+    private int smoking;
+
+    @ApiModelProperty(value = "鎵撶數璇�")
+    private int phone;
+
+    @ApiModelProperty(value = "琚偣璧炴暟")
+    private int likes;
+
+    @ApiModelProperty(value = "閰嶉�佹鏁�")
+    private int sends;
+
+    @ApiModelProperty(value = "閫佽揪娆℃暟")
+    private int sends2;
+
+    @ApiModelProperty(value = "鏈嶅姟鍟嗘埛")
+    private int service;
+
+    @ApiModelProperty(value = "寮傚父寮�闂�")
+    private int abnormalOpen;
+
+    @ApiModelProperty(value = "鐐硅禐鐜�")
+    private int likesRate;
+
+
+
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/OrderDetailMapper.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/OrderDetailMapper.java
new file mode 100644
index 0000000..6666f99
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/OrderDetailMapper.java
@@ -0,0 +1,14 @@
+package cn.exrick.xboot.your.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import cn.exrick.xboot.your.entity.OrderDetail;
+
+import java.util.List;
+
+/**
+ * 璁㈠崟璇︽儏琛ㄦ暟鎹鐞嗗眰
+ * @author whj
+ */
+public interface OrderDetailMapper extends BaseMapper<OrderDetail> {
+
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/OrderTaskMapper.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/OrderTaskMapper.java
new file mode 100644
index 0000000..e8906e3
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/OrderTaskMapper.java
@@ -0,0 +1,30 @@
+package cn.exrick.xboot.your.mapper;
+
+import cn.exrick.xboot.your.entity.AddOil;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import cn.exrick.xboot.your.entity.OrderTask;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Constants;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Result;
+import org.apache.ibatis.annotations.Results;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.type.JdbcType;
+
+import java.util.List;
+
+/**
+ * 璁㈠崟琛ㄦ暟鎹鐞嗗眰
+ * @author whj
+ */
+public interface OrderTaskMapper extends BaseMapper<OrderTask> {
+
+    @Select("SELECT sum(num) FROM t_order_task where area_id=#{arg0} and DATE_FORMAT(send_date,'%Y-%m-%d')=#{arg1}")
+    Integer sum(String areaId, String format);
+
+    @Select("SELECT a.*,b.name as temp FROM t_order_task a LEFT JOIN t_customer b ON a.customer_id=b.id ${ew.customSqlSegment} ")
+    @Results({@Result(column="temp", property="customerName", jdbcType = JdbcType.VARCHAR)})
+    List<OrderTask> list2(@Param(Constants.WRAPPER) QueryWrapper<OrderTask> wrapper2);
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/UserStatisticMapper.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/UserStatisticMapper.java
new file mode 100644
index 0000000..fff9587
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/UserStatisticMapper.java
@@ -0,0 +1,14 @@
+package cn.exrick.xboot.your.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import cn.exrick.xboot.your.entity.UserStatistic;
+
+import java.util.List;
+
+/**
+ * 鐢ㄦ埛缁熻琛ㄦ暟鎹鐞嗗眰
+ * @author whj
+ */
+public interface UserStatisticMapper extends BaseMapper<UserStatistic> {
+
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IOrderDetailService.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IOrderDetailService.java
new file mode 100644
index 0000000..8a1863d
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IOrderDetailService.java
@@ -0,0 +1,14 @@
+package cn.exrick.xboot.your.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import cn.exrick.xboot.your.entity.OrderDetail;
+
+import java.util.List;
+
+/**
+ * 璁㈠崟璇︽儏琛ㄦ帴鍙�
+ * @author whj
+ */
+public interface IOrderDetailService extends IService<OrderDetail> {
+
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IOrderTaskService.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IOrderTaskService.java
new file mode 100644
index 0000000..c13fea2
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IOrderTaskService.java
@@ -0,0 +1,18 @@
+package cn.exrick.xboot.your.service;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.extension.service.IService;
+import cn.exrick.xboot.your.entity.OrderTask;
+
+import java.util.List;
+
+/**
+ * 璁㈠崟琛ㄦ帴鍙�
+ * @author whj
+ */
+public interface IOrderTaskService extends IService<OrderTask> {
+
+    int sum(String id, String format);
+
+    List<OrderTask> list2(QueryWrapper<OrderTask> wrapper2);
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IUserStatisticService.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IUserStatisticService.java
new file mode 100644
index 0000000..952a961
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/IUserStatisticService.java
@@ -0,0 +1,14 @@
+package cn.exrick.xboot.your.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import cn.exrick.xboot.your.entity.UserStatistic;
+
+import java.util.List;
+
+/**
+ * 鐢ㄦ埛缁熻琛ㄦ帴鍙�
+ * @author whj
+ */
+public interface IUserStatisticService extends IService<UserStatistic> {
+
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IOrderDetailServiceImpl.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IOrderDetailServiceImpl.java
new file mode 100644
index 0000000..78baed0
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IOrderDetailServiceImpl.java
@@ -0,0 +1,26 @@
+package cn.exrick.xboot.your.serviceimpl;
+
+import cn.exrick.xboot.your.mapper.OrderDetailMapper;
+import cn.exrick.xboot.your.entity.OrderDetail;
+import cn.exrick.xboot.your.service.IOrderDetailService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.ArrayList;
+import java.util.List;
+
+/**
+ * 璁㈠崟璇︽儏琛ㄦ帴鍙e疄鐜�
+ * @author whj
+ */
+@Slf4j
+@Service
+@Transactional
+public class IOrderDetailServiceImpl extends ServiceImpl<OrderDetailMapper, OrderDetail> implements IOrderDetailService {
+
+    @Autowired
+    private OrderDetailMapper orderDetailMapper;
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IOrderTaskServiceImpl.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IOrderTaskServiceImpl.java
new file mode 100644
index 0000000..3276289
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IOrderTaskServiceImpl.java
@@ -0,0 +1,41 @@
+package cn.exrick.xboot.your.serviceimpl;
+
+import cn.exrick.xboot.your.mapper.OrderTaskMapper;
+import cn.exrick.xboot.your.entity.OrderTask;
+import cn.exrick.xboot.your.service.IOrderTaskService;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.ArrayList;
+import java.util.List;
+
+/**
+ * 璁㈠崟琛ㄦ帴鍙e疄鐜�
+ * @author whj
+ */
+@Slf4j
+@Service
+@Transactional
+public class IOrderTaskServiceImpl extends ServiceImpl<OrderTaskMapper, OrderTask> implements IOrderTaskService {
+
+    @Autowired
+    private OrderTaskMapper orderTaskMapper;
+
+    @Override
+    public int sum(String areaId, String format) {
+         Integer sum = orderTaskMapper.sum(areaId,format);
+         if(sum==null){
+             return 0;
+         }
+         return sum;
+    }
+
+    @Override
+    public List<OrderTask> list2(QueryWrapper<OrderTask> wrapper2) {
+        return orderTaskMapper.list2(wrapper2);
+    }
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IUserStatisticServiceImpl.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IUserStatisticServiceImpl.java
new file mode 100644
index 0000000..6e6090f
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/IUserStatisticServiceImpl.java
@@ -0,0 +1,26 @@
+package cn.exrick.xboot.your.serviceimpl;
+
+import cn.exrick.xboot.your.mapper.UserStatisticMapper;
+import cn.exrick.xboot.your.entity.UserStatistic;
+import cn.exrick.xboot.your.service.IUserStatisticService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.ArrayList;
+import java.util.List;
+
+/**
+ * 鐢ㄦ埛缁熻琛ㄦ帴鍙e疄鐜�
+ * @author whj
+ */
+@Slf4j
+@Service
+@Transactional
+public class IUserStatisticServiceImpl extends ServiceImpl<UserStatisticMapper, UserStatistic> implements IUserStatisticService {
+
+    @Autowired
+    private UserStatisticMapper userStatisticMapper;
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/resources/mapper/OrderDetailMapper.xml b/xboot-modules/xboot-your/src/main/resources/mapper/OrderDetailMapper.xml
new file mode 100644
index 0000000..f786e54
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/resources/mapper/OrderDetailMapper.xml
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="cn.exrick.xboot.your.mapper.OrderDetailMapper">
+
+</mapper>
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/resources/mapper/OrderTaskMapper.xml b/xboot-modules/xboot-your/src/main/resources/mapper/OrderTaskMapper.xml
new file mode 100644
index 0000000..4f01f66
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/resources/mapper/OrderTaskMapper.xml
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="cn.exrick.xboot.your.mapper.OrderTaskMapper">
+
+</mapper>
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/resources/mapper/UserStatisticMapper.xml b/xboot-modules/xboot-your/src/main/resources/mapper/UserStatisticMapper.xml
new file mode 100644
index 0000000..1b04829
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/resources/mapper/UserStatisticMapper.xml
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="cn.exrick.xboot.your.mapper.UserStatisticMapper">
+
+</mapper>
\ No newline at end of file

--
Gitblit v1.9.1