From f1cee812a4cd17e02895a00bbabb009b1b4e67e9 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期三, 28 四月 2021 16:51:47 +0800
Subject: [PATCH] 邻里圈模块接口编写
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopOrderDAO.java | 38 ++++++++++++++++++++++++--------------
1 files changed, 24 insertions(+), 14 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 c70f545..7c38cf3 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
@@ -24,7 +24,7 @@
public interface ComShopOrderDAO extends BaseMapper<ComShopOrderDO> {
@Select("<script> " +
- "select order_no,store_id,`status`,pay_status,receiver_id,total_amount as orderTotal,pay_amount,delivery_type,remark,create_at from com_shop_order as cso" +
+ "select id as orderId,order_no,store_id,`status`,pay_status,receiver_id,total_amount as orderTotal,pay_amount,delivery_type,remark,create_at from com_shop_order as cso" +
" where 1=1 and cso.delete_status = 1 and cso.user_id = #{comOrderListDTO.userId}" +
"<if test='comOrderListDTO.status != null'>" +
" AND cso.status = #{comOrderListDTO.status} " +
@@ -34,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, ss.name as store_name \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" +
@@ -55,16 +55,16 @@
" AND sr.create_at <![CDATA[<=]]> #{pageComShopOrderSearchDTO.createAtEnd} " +
" </if> " +
"<if test='pageComShopOrderSearchDTO.orderNo != null '>" +
- " AND sr.order_no = #{pageComShopOrderSearchDTO.orderNo} " +
+ " AND sr.order_no like concat('%', #{pageComShopOrderSearchDTO.orderNo}, '%') " +
" </if> " +
"<if test='pageComShopOrderSearchDTO.userAccount != null '>" +
- " AND su.phone = #{pageComShopOrderSearchDTO.userAccount} " +
+ " AND su.phone like concat('%', #{pageComShopOrderSearchDTO.userAccount}, '%') " +
" </if> " +
"<if test='pageComShopOrderSearchDTO.receiverAccount != null '>" +
- " AND uad.name = #{pageComShopOrderSearchDTO.receiverAccount} " +
+ " AND uad.name like concat('%', #{pageComShopOrderSearchDTO.receiverAccount}, '%') " +
" </if> " +
"<if test='pageComShopOrderSearchDTO.receiverPhone != null '>" +
- " AND uad.phone = #{pageComShopOrderSearchDTO.receiverPhone} " +
+ " AND uad.phone like concat('%',#{pageComShopOrderSearchDTO.receiverPhone}, '%') " +
" </if> " +
"<if test='pageComShopOrderSearchDTO.goodsName != null'>" +
" AND og.goods_name like concat('%', #{pageComShopOrderSearchDTO.goodsName}, '%') " +
@@ -75,12 +75,19 @@
"<if test='pageComShopOrderSearchDTO.storeName != null '>" +
" AND ss.name like concat('%', #{pageComShopOrderSearchDTO.storeName}, '%') " +
" </if> " +
- " ORDER BY sr.create_at "+
+ "<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 DESC "+
"</script>")
IPage<ComShopOrderSearchVO> pageOrderBy(Page page, @Param("pageComShopOrderSearchDTO") PageComShopOrderSearchDTO pageComShopOrderSearchDTO);
@Select("<script> " +
- "SELECT sr.total_amount AS goods_total, GROUP_CONCAT(og.goods_name) AS goods_name , count(og.id) AS goods_count, " +
+ "SELECT sr.total_amount AS goods_total, GROUP_CONCAT(og.goods_name separator '\n') AS goods_name , sum(og.amount) AS goods_count, " +
" su.phone AS account, uad.name AS receiver, uad.phone AS receiverPhone, \n" +
" concat(uad.province_name, uad.city_name, uad.district_name, uad.detail_address) AS receiver_address, ss.name AS storeName, sr.remark," +
" CASE\n" +
@@ -101,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 " +
@@ -179,7 +189,7 @@
"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'>" +
+ "<if test='userId!=null and userId!=0L'>" +
" and ss.sys_user_id = #{userId}\n" +
"</if>" +
"GROUP BY days\n" +
@@ -187,7 +197,7 @@
"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'>" +
+ "<if test='userId!=null and userId!=0L'>" +
" and ss.sys_user_id = #{userId}\n" +
"</if>" +
"GROUP BY weeks\n" +
@@ -195,7 +205,7 @@
"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'>" +
+ "<if test='userId!=null and userId!=0L'>" +
" and ss.sys_user_id = #{userId}\n" +
"</if>" +
"GROUP BY months\n" +
@@ -222,7 +232,7 @@
"<if test='pageComShopFundsSearchDTO.orderNo != null '>" +
" AND sr.order_no = #{pageComShopFundsSearchDTO.orderNo} " +
" </if> " +
- " GROUP BY sr.id ORDER BY sr.create_at "+
+ " GROUP BY sr.id ORDER BY sr.create_at DESC "+
"</script>")
IPage<ComShopFundsOrderVO> pageShopFunds(Page page, @Param("pageComShopFundsSearchDTO") PageComShopFundsSearchDTO pageComShopFundsSearchDTO);
--
Gitblit v1.7.1