From 30db4510c06202b3ad0ad4920e561f5f5541d69f Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期二, 20 四月 2021 19:56:51 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java | 55 ++++++++++++++++++++++++++++++++++++++++++++++---------
1 files changed, 46 insertions(+), 9 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java
index f51d358..cf35981 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java
@@ -3,6 +3,8 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.common.model.dtos.shop.PageComOrderListDTO;
+import com.panzhihua.common.model.vos.shop.*;
import com.panzhihua.common.model.dtos.shop.*;
import com.panzhihua.common.model.vos.shop.*;
import com.baomidou.mybatisplus.core.metadata.IPage;
@@ -11,7 +13,6 @@
import com.panzhihua.service_community.model.dos.ComShopOrderDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
-import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Select;
/**
@@ -33,11 +34,11 @@
IPage<ComShopOrderPageVO> pageOrderList(Page page,@Param("comOrderListDTO") PageComOrderListDTO comOrderListDTO);
@Select("<script> " +
- "SELECT sr.id, sr.store_id, sr.user_id, sr.order_no, sr.pay_no, \n" +
+ "SELECT distinct sr.id, sr.store_id, sr.user_id, su.phone AS userName , sr.order_no, sr.pay_no, \n" +
" sr.wx_tarde_no, sr.status, sr.pay_status, sr.receiver_id, \n" +
" sr.total_amount, sr.discount_amount, sr.pay_amount, sr.pay_type, \n" +
" sr.pay_time, sr.delivery_type, sr.delivery_status, sr.logistics_company, \n" +
- " sr.logistics_no, sr.create_at \n" +
+ " sr.logistics_no, sr.create_at, uad.name as receiver_name, uad.phone as receiver_phone, group_concat(og.goods_name) as goodsName \n" +
" FROM com_shop_order sr LEFT JOIN com_shop_order_goods og ON sr.id = og.order_id \n" +
" LEFT JOIN com_shop_goods_attr ga ON og.goods_attr_id = ga.id \n" +
" LEFT JOIN sys_user su ON sr.user_id = su.user_id \n" +
@@ -74,6 +75,13 @@
"<if test='pageComShopOrderSearchDTO.storeName != null '>" +
" AND ss.name like concat('%', #{pageComShopOrderSearchDTO.storeName}, '%') " +
" </if> " +
+ "<if test='pageComShopOrderSearchDTO.storeId != null '>" +
+ " AND ss.id = #{pageComShopOrderSearchDTO.storeId} " +
+ " </if> " +
+ "<if test='pageComShopOrderSearchDTO.storeUserId != null '>" +
+ " AND ss.sys_user_id = #{pageComShopOrderSearchDTO.storeUserId} " +
+ " </if> " +
+ " GROUP BY sr.id " +
" ORDER BY sr.create_at "+
"</script>")
IPage<ComShopOrderSearchVO> pageOrderBy(Page page, @Param("pageComShopOrderSearchDTO") PageComShopOrderSearchDTO pageComShopOrderSearchDTO);
@@ -100,7 +108,10 @@
" LEFT JOIN com_shop_store ss ON sr.store_id = ss.id \n" +
" WHERE sr.delete_status = 1" +
"<if test='comShopOrderExportDTO.userId != null'>" +
- " AND ss.user_id = #{comShopOrderExportDTO.userId} " +
+ " AND sr.user_id = #{comShopOrderExportDTO.userId} " +
+ " </if> " +
+ "<if test='comShopOrderExportDTO.storeUserId != null '>" +
+ " AND ss.sys_user_id = #{comShopOrderExportDTO.storeUserId} " +
" </if> " +
"<if test='comShopOrderExportDTO.orderIds != null and comShopOrderExportDTO.orderIds.length>0 '>" +
" AND sr.id in " +
@@ -171,28 +182,37 @@
@Select("<script> " +
" SELECT sys_user_id,\n" +
- " sum(case when abt.days = DATE_FORMAT(NOW(),'%Y%m%d') then abt.t END) AS todayTotal,\n" +
- " sum(case when abt.days = DATE_FORMAT(NOW(),'%Y%u') then abt.t END) AS weekTotal,\n" +
- " sum(case when abt.days = DATE_FORMAT(NOW(),'%Y%m') then abt.t END) AS monthTotal\n" +
+ " COALESCE(SUM(CASE WHEN abt.days = DATE_FORMAT(NOW(),'%Y%m%d') THEN abt.t END), 0) AS todayTotal,\n" +
+ " COALESCE(SUM(CASE WHEN abt.days = DATE_FORMAT(NOW(),'%Y%u') THEN abt.t END), 0) AS weekTotal,\n" +
+ " COALESCE(SUM(CASE WHEN abt.days = DATE_FORMAT(NOW(),'%Y%m') THEN abt.t END), 0) AS monthTotal\n" +
"FROM (\n" +
- "SELECT ss.sys_user_id, (sr.pay_amount) AS t , DATE_FORMAT(sr.pay_time,'%Y%m%d') days\n" +
+ "SELECT ss.sys_user_id, sum(sr.pay_amount) AS t , DATE_FORMAT(sr.pay_time,'%Y%m%d') days\n" +
"FROM com_shop_order sr LEFT JOIN com_shop_store ss ON sr.store_id = ss.id\n" +
"WHERE sr.pay_status = 2 AND DATE_FORMAT(sr.pay_time,'%Y%m%d') = DATE_FORMAT(NOW(),'%Y%m%d')\n" +
+ "<if test='userId!=null and userId!=0L'>" +
+ " and ss.sys_user_id = #{userId}\n" +
+ "</if>" +
"GROUP BY days\n" +
"UNION \n" +
"SELECT ss.sys_user_id, sum(sr.pay_amount) AS t, DATE_FORMAT(sr.pay_time,'%Y%u') weeks\n" +
"FROM com_shop_order sr LEFT JOIN com_shop_store ss ON sr.store_id = ss.id\n" +
"WHERE sr.pay_status = 2 AND DATE_FORMAT(sr.pay_time,'%Y%u') = DATE_FORMAT(NOW(),'%Y%u')\n" +
+ "<if test='userId!=null and userId!=0L'>" +
+ " and ss.sys_user_id = #{userId}\n" +
+ "</if>" +
"GROUP BY weeks\n" +
"UNION \n" +
"SELECT ss.sys_user_id, sum(sr.pay_amount) AS t, DATE_FORMAT(sr.pay_time,'%Y%m') months\n" +
"FROM com_shop_order sr LEFT JOIN com_shop_store ss ON sr.store_id = ss.id\n" +
"WHERE sr.pay_status = 2 AND DATE_FORMAT(sr.pay_time,'%Y%m') = DATE_FORMAT(NOW(),'%Y%m')\n" +
+ "<if test='userId!=null and userId!=0L'>" +
+ " and ss.sys_user_id = #{userId}\n" +
+ "</if>" +
"GROUP BY months\n" +
") abt\n" +
"GROUP BY abt.sys_user_id "+
"</script>")
- ComShopFundsVO queryStatis(Long userId);
+ ComShopFundsVO queryStatis(@Param("userId") Long userId);
@Select("<script> " +
"SELECT sr.id, sr.total_amount, sr.pay_time, sr.order_no, \n" +
@@ -215,4 +235,21 @@
" GROUP BY sr.id ORDER BY sr.create_at "+
"</script>")
IPage<ComShopFundsOrderVO> pageShopFunds(Page page, @Param("pageComShopFundsSearchDTO") PageComShopFundsSearchDTO pageComShopFundsSearchDTO);
+
+ @Select("<script> " +
+ "SELECT\n" +
+ "css.store_account,\n" +
+ "css.`contacts`,\n" +
+ "css.`name` as storeName,\n" +
+ "cso.total_amount,\n" +
+ "cso.pay_type,\n" +
+ "cso.pay_time, \n" +
+ "cso.create_at, \n" +
+ "cso.order_no\n" +
+ "FROM\n" +
+ "com_shop_order cso\n" +
+ "left JOIN com_shop_store css on cso.store_id=css.id \n" +
+ "where cso.id =#{id} "+
+ "</script>")
+ CapitalDetailVO capitalDetailByStore(@Param("id")Long id);
}
--
Gitblit v1.7.1