From 53391a949929195b3341a683d64b82364fa8cf6e Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Thu, 22 Dec 2022 15:39:21 +0800
Subject: [PATCH] 20221221

---
 src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java               |    2 
 src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java                  |    9 ++
 src/main/java/cc/mrbird/febs/mall/controller/ApiMallOrderController.java        |   11 +++
 src/main/java/cc/mrbird/febs/mall/service/IApiMallOrderInfoService.java         |    2 
 src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallOrderInfoServiceImpl.java |   32 +++++++++-
 src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java                  |    2 
 src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java      |    2 
 src/main/java/cc/mrbird/febs/mall/vo/ApiMallSubsidyAmountInfoVo.java            |   28 +++++++++
 src/main/resources/mapper/modules/MallOrderInfoMapper.xml                       |   22 ++++++-
 src/main/resources/mapper/modules/MallMoneyFlowMapper.xml                       |    7 ++
 src/main/resources/templates/febs/views/modules/order/orderMoneyFlow.html       |   17 -----
 11 files changed, 109 insertions(+), 25 deletions(-)

diff --git a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java b/src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java
index 5cf3160..3a6f67e 100644
--- a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java
+++ b/src/main/java/cc/mrbird/febs/mall/controller/AdminMallOrderController.java
@@ -437,7 +437,7 @@
         if (parentId == null) {
             ViewMallOrderController.seeOrderFlowByOrderId = 0;
         }
-        mallOrderInfo.setId(ViewMallMemberController.idFromMoneyFlow);
+        mallOrderInfo.setId(ViewMallOrderController.seeOrderFlowByOrderId);
         Map<String, Object> dataTable = getDataTable(adminMallOrderService.moneyFlow(request, mallOrderInfo));
         return new FebsResponse().success().data(dataTable);
     }
diff --git a/src/main/java/cc/mrbird/febs/mall/controller/ApiMallOrderController.java b/src/main/java/cc/mrbird/febs/mall/controller/ApiMallOrderController.java
index 2c293f7..0a2e412 100644
--- a/src/main/java/cc/mrbird/febs/mall/controller/ApiMallOrderController.java
+++ b/src/main/java/cc/mrbird/febs/mall/controller/ApiMallOrderController.java
@@ -3,6 +3,8 @@
 import cc.mrbird.febs.common.entity.FebsResponse;
 import cc.mrbird.febs.mall.dto.*;
 import cc.mrbird.febs.mall.service.IApiMallOrderInfoService;
+import cc.mrbird.febs.mall.vo.ApiMallSubsidyAmountInfoVo;
+import cc.mrbird.febs.mall.vo.MallMemberVo;
 import cc.mrbird.febs.mall.vo.OrderDetailVo;
 import cc.mrbird.febs.mall.vo.OrderListVo;
 import io.swagger.annotations.Api;
@@ -117,4 +119,13 @@
         return mallOrderInfoService.bangCardSign(bangCardSignDto);
     }
 
+    @ApiOperation(value = "获取订单补贴信息", notes = "获取订单补贴信息")
+    @ApiResponses({
+            @ApiResponse(code = 200, message = "success", response = ApiMallSubsidyAmountInfoVo.class)
+    })
+    @GetMapping(value = "/subsidyAmountInfo")
+    public FebsResponse subsidyAmountInfo() {
+        return mallOrderInfoService.subsidyAmountInfo();
+    }
+
 }
diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java
index 2671ca1..44250e4 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallOrderInfoMapper.java
@@ -67,4 +67,6 @@
     BigDecimal selectSumAmountByPayMethodAndSomeStatue(@Param("payMethod")String name, @Param("statues") List<Long> values);
 
     Integer selectCountByCreateTimeAndMemberId(@Param("createdTime")String yyyyMMdd,@Param("memberId")Long memberId);
+
+    BigDecimal selectTodayAmountByCreateTimeAndMemberId(@Param("createdTime")String yyyyMMdd,@Param("memberId")Long memberId);
 }
diff --git a/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java b/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java
index cb00b93..5481d86 100644
--- a/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java
+++ b/src/main/java/cc/mrbird/febs/mall/quartz/OrderOvertimeJob.java
@@ -155,9 +155,16 @@
             if(BigDecimal.ZERO.compareTo(avaAmount) >= 0){
                 mallMemberStarBuyMapper.updateStatusById(2,mallMemberStarBuy.getId());
                 List<MallMemberStarBuy> mallMemberStarBuysIng = mallMemberStarBuyMapper.selectByStatusAndMemberId(1,memberId);
-                //如果没有其他生效中的记录,则更新用户的星级
+                //如果没有其他生效中的记录,则更新用户的星级为普通,更新会员代理等级为代理
                 if(CollUtil.isEmpty(mallMemberStarBuysIng)){
                     mallMemberMapper.updateAccountLevelById(MemberAccountLevelEnum.NORMAL.getName(), memberId);
+
+                    //如果代理等级为手动设置,则跳过该会员
+                    int levelStatus = ObjectUtil.isEmpty(mallMember.getLevelStatus()) ? 0 : 1;
+                    if(1 == levelStatus){
+                        continue;
+                    }
+                    mallMemberMapper.updateLevelById(MemberAgentLevelEnum.AGENT.getName(),mallMember.getId());
                 }
             }
         }
diff --git a/src/main/java/cc/mrbird/febs/mall/service/IApiMallOrderInfoService.java b/src/main/java/cc/mrbird/febs/mall/service/IApiMallOrderInfoService.java
index 91bd897..f43d1d3 100644
--- a/src/main/java/cc/mrbird/febs/mall/service/IApiMallOrderInfoService.java
+++ b/src/main/java/cc/mrbird/febs/mall/service/IApiMallOrderInfoService.java
@@ -35,4 +35,6 @@
     void goodsComment(ApiAddCommentDtos addCommentDtos);
 
     FebsResponse bangCardSign(BangCardSignDto bangCardSignDto);
+
+    FebsResponse subsidyAmountInfo();
 }
diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallOrderInfoServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallOrderInfoServiceImpl.java
index 9a2c5a5..3bc8606 100644
--- a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallOrderInfoServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallOrderInfoServiceImpl.java
@@ -14,10 +14,7 @@
 import cc.mrbird.febs.mall.entity.*;
 import cc.mrbird.febs.mall.mapper.*;
 import cc.mrbird.febs.mall.service.*;
-import cc.mrbird.febs.mall.vo.ApiShopApplyVo;
-import cc.mrbird.febs.mall.vo.OrderDetailVo;
-import cc.mrbird.febs.mall.vo.OrderListVo;
-import cc.mrbird.febs.mall.vo.OrderRefundVo;
+import cc.mrbird.febs.mall.vo.*;
 import cc.mrbird.febs.pay.model.AgreementPayDto;
 import cc.mrbird.febs.pay.model.AgreementSignDto;
 import cc.mrbird.febs.pay.model.UnipayDto;
@@ -684,4 +681,31 @@
         }
     }
 
+    @Override
+    public FebsResponse subsidyAmountInfo() {
+        MallMember member = LoginUserUtil.getLoginUser();
+        ApiMallSubsidyAmountInfoVo apiMallSubsidyAmountInfoVo = new ApiMallSubsidyAmountInfoVo();
+        DateTime today = DateUtil.date();
+        DateTime yesterday = DateUtil.yesterday();
+        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
+        String yyyyMMddToday = sdf.format(today);
+        String yyyyMMddYesterday = sdf.format(yesterday);
+        //今日补贴
+        BigDecimal todayAmount = this.baseMapper.selectTodayAmountByCreateTimeAndMemberId(yyyyMMddToday,member.getId());
+        apiMallSubsidyAmountInfoVo.setTodayAmount(todayAmount);
+        //今日累计接单
+        Integer todayTotalCnt = this.baseMapper.selectCountByCreateTimeAndMemberId(yyyyMMddToday,member.getId());
+        apiMallSubsidyAmountInfoVo.setTodayTotalCnt(todayTotalCnt);
+        //昨日补贴
+        BigDecimal yesterdayAmount = this.baseMapper.selectTodayAmountByCreateTimeAndMemberId(yyyyMMddYesterday,member.getId());
+        apiMallSubsidyAmountInfoVo.setYesterdayAmount(yesterdayAmount);
+        //昨日累计接单
+        Integer totalYesterdayCnt = this.baseMapper.selectCountByCreateTimeAndMemberId(yyyyMMddYesterday,member.getId());
+        apiMallSubsidyAmountInfoVo.setTotalYesterdayCnt(totalYesterdayCnt);
+        //获得总额
+        BigDecimal totalAmount = this.baseMapper.selectTodayAmountByCreateTimeAndMemberId(null,member.getId());
+        apiMallSubsidyAmountInfoVo.setTotalAmount(totalAmount);
+        return new FebsResponse().success().data(apiMallSubsidyAmountInfoVo);
+    }
+
 }
diff --git a/src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java b/src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java
index 6b8270b..689ad52 100644
--- a/src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java
+++ b/src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java
@@ -25,4 +25,6 @@
 
     private String remark;
 
+    private String memberName;
+
 }
diff --git a/src/main/java/cc/mrbird/febs/mall/vo/ApiMallSubsidyAmountInfoVo.java b/src/main/java/cc/mrbird/febs/mall/vo/ApiMallSubsidyAmountInfoVo.java
new file mode 100644
index 0000000..dac1ffa
--- /dev/null
+++ b/src/main/java/cc/mrbird/febs/mall/vo/ApiMallSubsidyAmountInfoVo.java
@@ -0,0 +1,28 @@
+package cc.mrbird.febs.mall.vo;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.math.BigDecimal;
+
+@Data
+@ApiModel(value = "ApiMallSubsidyAmountInfoVo", description = "返回参数类")
+public class ApiMallSubsidyAmountInfoVo {
+
+    @ApiModelProperty(value = "获得总额")
+    private BigDecimal totalAmount = BigDecimal.ZERO;
+
+    @ApiModelProperty(value = "今日补贴")
+    private BigDecimal todayAmount = BigDecimal.ZERO;
+
+    @ApiModelProperty(value = "今日累计接单")
+    private Integer todayTotalCnt = 0;
+
+    @ApiModelProperty(value = "昨日补贴")
+    private BigDecimal yesterdayAmount = BigDecimal.ZERO;
+
+    @ApiModelProperty(value = "昨日累计接单")
+    private Integer totalYesterdayCnt = 0;
+
+}
diff --git a/src/main/resources/mapper/modules/MallMoneyFlowMapper.xml b/src/main/resources/mapper/modules/MallMoneyFlowMapper.xml
index 368a4e2..c2827e7 100644
--- a/src/main/resources/mapper/modules/MallMoneyFlowMapper.xml
+++ b/src/main/resources/mapper/modules/MallMoneyFlowMapper.xml
@@ -146,7 +146,12 @@
     </select>
 
     <select id="selectOrderMoneyFlowInPage" resultType="cc.mrbird.febs.mall.vo.AdminMallMoneyFlowVo">
-        select * from mall_money_flow a where a.order_no = #{record.orderNo}
+        select
+               a.*,
+               b.name memberName
+        from mall_money_flow a
+        inner join mall_member b on b.id = a.rt_member_id
+        where a.order_no = #{record.orderNo}
         order by a.CREATED_TIME desc
     </select>
 </mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/modules/MallOrderInfoMapper.xml b/src/main/resources/mapper/modules/MallOrderInfoMapper.xml
index 38df6d1..c4419a6 100644
--- a/src/main/resources/mapper/modules/MallOrderInfoMapper.xml
+++ b/src/main/resources/mapper/modules/MallOrderInfoMapper.xml
@@ -112,6 +112,7 @@
         <result column="del_flag" property="delFlag" />
         <result column="deliver_type" property="deliverType" />
         <result column="shop_id" property="shopId" />
+        <result column="subsidy_amount" property="subsidyAmount" />
         <collection property="items" ofType="cc.mrbird.febs.mall.entity.MallOrderItem">
             <id property="id" column="item_id" />
             <result property="orderId" column="order_id" />
@@ -165,10 +166,10 @@
                 and a.order_type=#{record.orderType}
             </if>
             <if test="record.allStatus == 2">
-                and a.status <![CDATA[<= ]]> 4
+                and a.status <![CDATA[< ]]> 4
             </if>
             <if test="record.allStatus == 3">
-                and a.status <![CDATA[>= ]]> 5
+                and a.status <![CDATA[>= ]]> 4
             </if>
         </where>
         order by a.created_time desc
@@ -321,7 +322,22 @@
             count(a.id)
         from mall_order_info a
         where
-            date_format(a.CREATED_TIME, '%Y-%m-%d') = #{createdTime}
+            <if test="createdTime != null">
+                and date_format(a.CREATED_TIME, '%Y-%m-%d') = #{createdTime}
+            </if>
+            and a.status = 4
+            and a.member_id = #{memberId}
+    </select>
+
+    <select id="selectTodayAmountByCreateTimeAndMemberId" resultType="java.math.BigDecimal">
+            select
+                ifnull(sum(a.subsidy_amount),0)
+            from mall_order_info a
+            where
+            <if test="createdTime != null">
+                and date_format(a.CREATED_TIME, '%Y-%m-%d') = #{createdTime}
+            </if>
+            and a.status = 4
             and a.member_id = #{memberId}
     </select>
 </mapper>
\ No newline at end of file
diff --git a/src/main/resources/templates/febs/views/modules/order/orderMoneyFlow.html b/src/main/resources/templates/febs/views/modules/order/orderMoneyFlow.html
index 61c6c41..579c30e 100644
--- a/src/main/resources/templates/febs/views/modules/order/orderMoneyFlow.html
+++ b/src/main/resources/templates/febs/views/modules/order/orderMoneyFlow.html
@@ -16,26 +16,12 @@
             febs = layui.febs,
             form = layui.form,
             table = layui.table,
-            treeSelect = layui.treeSelect,
-            dropdown = layui.dropdown,
             $view = $('#febs-orderMoneyFlow-child'),
-            $query = $view.find('#queryChild'),
-            $searchForm = $view.find('formChild'),
-            sortObject = {field: 'createTime', type: null},
-            tableIns,
-            createTimeFrom,
-            createTimeTo;
+            tableIns;
 
         form.render();
 
         initTable();
-
-        laydate.render({
-            elem: '#user-createTime',
-            range: true,
-            trigger: 'click'
-        });
-
 
         function initTable() {
             tableIns = febs.table.init({
@@ -43,6 +29,7 @@
                 id: 'orderMoneyFlowChild',
                 url: ctx + 'admin/order/moneyFlow?parentId=1',
                 cols: [[
+                    {field: 'memberName', title: '用户名', minWidth: 80,align:'center'},
                     {field: 'amount', title: '金额', minWidth: 80,align:'center'},
                     {field: 'type', title: '流水类型',
                         templet: function (d) {

--
Gitblit v1.9.1