java/zhihuishenqu.git

			@@ -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;

			/**
			@@ -44,6 +45,9 @@
			" LEFT JOIN com_shop_user_address uad ON sr.receiver_id = uad.id \n" +
			" LEFT JOIN com_shop_store ss ON sr.store_id = ss.id \n" +
			" WHERE sr.delete_status = 1" +
			"<if test='pageComShopOrderSearchDTO.userId != null'>" +
			" AND sr.user_id = #{pageComShopOrderSearchDTO.userId} " +
			" </if> " +
			"<if test='pageComShopOrderSearchDTO.createAtStart != null'>" +
			" AND #{pageComShopOrderSearchDTO.createAtStart} <![CDATA[<=]]> sr.create_at " +
			" </if> " +
			@@ -67,6 +71,9 @@
			" </if> " +
			"<if test='pageComShopOrderSearchDTO.status != null '>" +
			" AND sr.status = #{pageComShopOrderSearchDTO.status} " +
			" </if> " +
			"<if test='pageComShopOrderSearchDTO.storeName != null '>" +
			" AND ss.name like concat('%', #{pageComShopOrderSearchDTO.storeName}, '%') " +
			" </if> " +
			" ORDER BY sr.create_at "+
			"</script>")
			@@ -94,7 +101,7 @@
			" LEFT JOIN com_shop_store ss ON sr.store_id = ss.id \n" +
			" WHERE sr.delete_status = 1" +
			"<if test='comShopOrderExportDTO.userId != null'>" +
			" AND com_shop_store.user_id = #{comShopOrderExportDTO.userId} " +
			" AND ss.user_id = #{comShopOrderExportDTO.userId} " +
			" </if> " +
			"<if test='comShopOrderExportDTO.orderIds != null and comShopOrderExportDTO.orderIds.length>0 '>" +
			" AND sr.id in " +
			@@ -165,28 +172,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 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 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 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" +
			@@ -209,4 +225,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);
			}