| | |
| | | "<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>") |
| | |
| | | " 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 " + |