springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/ShopFlowerApi.java
@@ -130,7 +130,7 @@ } @ApiOperation(value = "删除用户收货地址列表") @PostMapping("shopDelUserAddress") @DeleteMapping("shopDelUserAddress") @ApiImplicitParam(name = "addressId", value = "收货地址id", required = true) public R shopDelUserAddress(@RequestParam("addressId") Long addressId) { return communityService.shopFlowerDelUserAddress(addressId); @@ -452,6 +452,7 @@ * @return */ @GetMapping("incrGoodsView") @ApiOperation(value = "新增商品浏览量") public R incrGoodsView(@RequestParam("goodsId") Long goodsId) { return communityService.incrGoodsView(goodsId); } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/LoginUserInfoVO.java
@@ -14,6 +14,7 @@ import com.panzhihua.common.model.vos.community.ComActVO; import com.panzhihua.common.model.vos.community.ComMngStructAreaVO; import com.panzhihua.common.model.vos.community.ComMngStructHouseVO; import com.panzhihua.common.model.vos.shop.ComShopUserAddressVO; import com.panzhihua.common.model.vos.user.ComMngFamilyInfoVO; import com.panzhihua.common.model.vos.user.RoleVO; import com.panzhihua.common.validated.AddGroup; @@ -263,4 +264,7 @@ @ApiModelProperty("是否为自提点") private Boolean isPoint; @ApiModelProperty("默认地址") private ComShopUserAddressVO comShopUserAddressVO; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/shop/ComShopFlowerGoodsVO.java
@@ -70,10 +70,15 @@ private BigDecimal originalPrice; /** * 商品现价 * 包邮价 */ @ApiModelProperty("商品现价") private BigDecimal price; @ApiModelProperty("包邮价") private BigDecimal freeShippingPrice; /** * 拼单价 */ @ApiModelProperty("拼单价") private BigDecimal collatePrice; /** * 商品单位 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/shop/ComShopOrderStoreIdCountVO.java
@@ -19,7 +19,7 @@ * 订 */ @ApiModelProperty("订单数量") private Integer count; private Integer countNum; /** * 统计名称 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/shop/ComShopOrderStoreIdNumVO.java
New file @@ -0,0 +1,31 @@ package com.panzhihua.common.model.vos.shop; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.math.BigDecimal; /** * @auther yh * @create 2022-11-08 17:25:45 * @describe 商家后台经营数据统计 */ @Data @ApiModel("商家后台经营数据统计") public class ComShopOrderStoreIdNumVO { /** * 订 */ @ApiModelProperty("订单数量") private BigDecimal countNum; /** * 统计名称 */ @ApiModelProperty("统计名称") private String countName; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
@@ -10758,7 +10758,7 @@ * 收货地址id * @return 删除结果 */ @PostMapping("/shopFlower/shopDelUserAddress") @DeleteMapping("/shopFlower/shopDelUserAddress") R shopFlowerDelUserAddress(@RequestParam("addressId") Long addressId); /** @@ -10881,7 +10881,7 @@ * @param pageComShopFlowerEvaluateDTO * @return */ @PostMapping("/pageEvaluate") @PostMapping("/shopFlower/pageEvaluate") R pageEvaluate(@RequestBody PageComShopFlowerEvaluateDTO pageComShopFlowerEvaluateDTO); /** springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/utlis/DateUtils.java
@@ -926,11 +926,9 @@ } public static void main(String[] args) throws Exception { Date date= getLastMonthFirst(); Date after = getLastMonthEnd(); System.out.println(date); System.out.println(after); System.out.println(getMonthTwentyDay()); List<String> beforeDays = getBeforeDays(15); System.out.println(beforeDays); } /** @@ -1174,4 +1172,13 @@ } } public static List<String> getBeforeDays(int before) { List<String> dates = new ArrayList<>(); for (int i = before; i >= 0; i--) { dates.add(getBeforeDay(i)); } return dates; } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/ShopFlowerApi.java
@@ -153,7 +153,7 @@ * @param addressId 收货地址id * @return 删除结果 */ @PostMapping("shopDelUserAddress") @DeleteMapping("shopDelUserAddress") public R shopFlowerDelUserAddress(@RequestParam("addressId") Long addressId) { return comShopUserAddressService.shopDelUserAddress(addressId); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComShopFlowerOrderDAO.java
@@ -85,4 +85,20 @@ * @return */ BigDecimal selectSettlement(@Param("storeId") Long storeId); List<ComShopOrderStoreIdNumVO> selectSumOrderAndAmountByStoreId(@Param("storeId") Long storeId); /** * 查询近15天的订单量 * @param storeId * @return */ List<ComShopOrderStoreIdCountVO> selectCountOrderDayByStoreId(@Param("storeId") Long storeId, @Param("days") Integer days); /** * 查询当年月份的订单量 * @param storeId * @return */ List<ComShopOrderStoreIdCountVO> selectCountOrderMonthByStoreId(@Param("storeId") Long storeId); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/ComShopFlowerOrderService.java
@@ -212,4 +212,11 @@ * @return */ R getQuota(Long storeId); /** * 商家后台经营数据统计-上 * @param storeId * @return */ R selectSumOrderAndAmountByStoreId(Long storeId); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComShopFlowerGoodsServiceImpl.java
@@ -168,7 +168,8 @@ goodsVo.setGoodsAttrList(goodsAttrList); goodsVo.setGoodsPic(comShopFlowerGoodsAttrVO.getAttrPic()); goodsVo.setOriginalPrice(comShopFlowerGoodsAttrVO.getPrice()); goodsVo.setPrice(comShopFlowerGoodsAttrVO.getCollatePrice()); goodsVo.setCollatePrice(comShopFlowerGoodsAttrVO.getCollatePrice()); goodsVo.setFreeShippingPrice(comShopFlowerGoodsAttrVO.getFreeShippingPrice()); } //设置商品总浏览量 goodsVo.setViewNum(comShopFlowerGoodsViewStatisticsDAO.selectTotalViewNum(goodsId)); @@ -193,15 +194,15 @@ List<ComShopFlowerGoodsAttrDO> goodsAttrDOS = shopFlowerGoodsAttrDAO.selectList(new QueryWrapper<ComShopFlowerGoodsAttrDO>().eq("goods_id", goodsId)); List<String> images = new ArrayList<>(); goodsAttrDOS.forEach(attrDO -> { int stock = 0; for (ComShopFlowerGoodsAttrDO attrDO : goodsAttrDOS) { ComShopFlowerGoodsAttrVO goodsAttrVO = new ComShopFlowerGoodsAttrVO(); BeanUtils.copyProperties(attrDO, goodsAttrVO); String attrPic = attrDO.getAttrPic(); images.add(attrPic); goodsAttrList.add(goodsAttrVO); }); stock = stock +attrDO.getStock(); } // 查询商品店铺信息 ConvenientMerchantDO convenientMerchantDO = convenientMerchantDAO.selectById(goodsDO.getStoreId()); ConvenientMerchantVO convenientMerchantVO = new ConvenientMerchantVO(); @@ -220,6 +221,13 @@ List<Long> categoryIds = convenientGoodsCategoryDAO.selectCategoryIdsForGoods(goodsId); shopGoods.setCategoryIds(categoryIds); ComShopFlowerGoodsAttrVO comShopFlowerGoodsAttrVO = goodsAttrList.get(0); shopGoods.setOriginalPrice(comShopFlowerGoodsAttrVO.getPrice()); shopGoods.setCollatePrice(comShopFlowerGoodsAttrVO.getCollatePrice()); shopGoods.setFreeShippingPrice(comShopFlowerGoodsAttrVO.getFreeShippingPrice()); shopGoods.setStock(stock); return R.ok(shopGoods); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComShopFlowerOrderServiceImpl.java
@@ -1017,15 +1017,15 @@ Map<String,Object> retMap = new HashMap<>(); //查询我的店铺订单量 List<ComShopOrderStoreIdCountVO> comShopOrderStoreIdCountVOS = this.baseMapper.selectCountByStoreId(storeId, null); Map<String, Integer> zddlMap = comShopOrderStoreIdCountVOS.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCount)); Map<String, Integer> zddlMap = comShopOrderStoreIdCountVOS.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCountNum)); retMap.put("zddl",zddlMap); //查询我的店铺拼单订单 List<ComShopOrderStoreIdCountVO> comShopOrderStoreIdCountVOS1 = this.baseMapper.selectCountByStoreId(storeId, ComShopFlowerOrderDO.deliveryType.store); Map<String, Integer> pdddMap = comShopOrderStoreIdCountVOS1.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCount)); Map<String, Integer> pdddMap = comShopOrderStoreIdCountVOS1.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCountNum)); retMap.put("pddd",pdddMap); //查询我的店铺快递订单 List<ComShopOrderStoreIdCountVO> comShopOrderStoreIdCountVOS2 = this.baseMapper.selectCountByStoreId(storeId, ComShopFlowerOrderDO.deliveryType.express); Map<String, Integer> kdddMap = comShopOrderStoreIdCountVOS2.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCount)); Map<String, Integer> kdddMap = comShopOrderStoreIdCountVOS2.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCountNum)); retMap.put("kddd",kdddMap); //拼单订单各状态 @@ -1037,7 +1037,7 @@ retMap.put("kdddStatus",r1.getData()); //营业额 List<ComShopOrderStoreIdCountVO> comShopOrderStoreIdCountVOS3 = this.baseMapper.selectSumAmountByStoreId(storeId); Map<String, Integer> yyeMap = comShopOrderStoreIdCountVOS3.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCount)); Map<String, Integer> yyeMap = comShopOrderStoreIdCountVOS3.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCountNum)); retMap.put("yye",yyeMap); //在售商品 Integer countSale = comShopFlowerGoodsDAO.selectCountSaleByStoreId(storeId); @@ -1055,6 +1055,7 @@ * @param storeId * @return */ @Override public R getQuota(Long storeId){ //营业额 BigDecimal turnover = this.baseMapper.selectTurnover(storeId); @@ -1069,4 +1070,44 @@ } @Override public R selectSumOrderAndAmountByStoreId(Long storeId){ List<ComShopOrderStoreIdNumVO> comShopOrderStoreIdCountVOS = this.baseMapper.selectSumOrderAndAmountByStoreId(storeId); Map<String, Object> retMap = comShopOrderStoreIdCountVOS.stream().collect(Collectors.toMap(ComShopOrderStoreIdNumVO::getCountName, ComShopOrderStoreIdNumVO::getCountNum)); return R.ok(retMap); } public R selectOrderLineChart(Long storeId,Integer type){ if (1==type){ //近15天的订单量 int days = 15; return getCountByStoreIdAndDays(storeId, days); }else if (2 ==type){ //近30天的订单量 int days = 30; return getCountByStoreIdAndDays(storeId, days); }else { //今年所有月份订单量 List<ComShopOrderStoreIdCountVO> comShopOrderStoreIdCountVOS = this.baseMapper.selectCountOrderMonthByStoreId(storeId); Map<String, Integer> retMap = comShopOrderStoreIdCountVOS.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCountNum)); } return R.ok(); } private R getCountByStoreIdAndDays(Long storeId, int days) { List<ComShopOrderStoreIdCountVO> comShopOrderStoreIdCountVOS = this.baseMapper.selectCountOrderDayByStoreId(storeId, days); Map<String, Integer> retMap = comShopOrderStoreIdCountVOS.stream().collect(Collectors.toMap(ComShopOrderStoreIdCountVO::getCountName, ComShopOrderStoreIdCountVO::getCountNum)); List<String> beforeDays = DateUtils.getBeforeDays(days); for (String beforeDay : beforeDays) { if (!retMap.containsKey(beforeDay)) { retMap.put(beforeDay, 0); } } return R.ok(retMap); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ConvenientElevatingPointServiceImpl.java
@@ -146,7 +146,7 @@ convenientElevatingPointDOS.forEach(f -> { ConvenientElevatingPointVO convenientElevatingPointVO = new ConvenientElevatingPointVO(); BeanUtils.copyProperties(f, convenientElevatingPointVO); Double distance = MapDistance.distanceOfTwoPoints(lng, lat, f.getLon(), f.getLat()); Double distance = MapDistance.distanceOfTwoPoints(lat, lng, f.getLon(), f.getLat()); convenientElevatingPointVO.setDistance(distance); convenientElevatingPointVOS.add(convenientElevatingPointVO); }); springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComShopFlowerOrderDAO.xml
@@ -167,7 +167,7 @@ <select id="selectCountByStoreId" resultType="com.panzhihua.common.model.vos.shop.ComShopOrderStoreIdCountVO"> SELECT count(1) as count,'dayCount' as count_name FROM com_shop_flower_order WHERE TO_DAYS(create_at)=TO_DAYS(NOW()) SELECT count(1) as count_num,'dayCount' as count_name FROM com_shop_flower_order WHERE TO_DAYS(create_at)=TO_DAYS(NOW()) <if test="storeId != null"> and store_id = #{storeId} </if> @@ -175,7 +175,7 @@ and delivery_type = #{deliveryType} </if> union all SELECT count(1) as count,'monthCount' as count_name FROM com_shop_flower_order WHERE DATE_FORMAT(create_at,'%Y%m')=DATE_FORMAT(CURDATE(),'%Y%m') SELECT count(1) as count_num,'monthCount' as count_name FROM com_shop_flower_order WHERE DATE_FORMAT(create_at,'%Y%m')=DATE_FORMAT(CURDATE(),'%Y%m') <if test="storeId != null"> and store_id = #{storeId} </if> @@ -183,7 +183,7 @@ and delivery_type = #{deliveryType} </if> union all SELECT count(1) as count,'yearCount' as count_name FROM com_shop_flower_order where YEAR(create_at) =YEAR(NOW()) SELECT count(1) as count_num,'yearCount' as count_name FROM com_shop_flower_order where YEAR(create_at) =YEAR(NOW()) <if test="storeId != null"> and store_id = #{storeId} </if> @@ -191,7 +191,7 @@ and delivery_type = #{deliveryType} </if> union all SELECT count(1) as count,'allCount' as count_name FROM com_shop_flower_order WHERE 1=1 SELECT count(1) as count_num,'allCount' as count_name FROM com_shop_flower_order WHERE 1=1 <if test="storeId != null"> and store_id = #{storeId} </if> @@ -201,31 +201,55 @@ </select> <select id="selectSumAmountByStoreId" resultType="com.panzhihua.common.model.vos.shop.ComShopOrderStoreIdCountVO"> SELECT IFNULL(sum(pay_amount),0) as count,'dayAmount' as count_name FROM com_shop_flower_order WHERE TO_DAYS(create_at)=TO_DAYS(NOW()) and `status` not in (6,7) SELECT IFNULL(sum(pay_amount),0) as count_num,'dayAmount' as count_name FROM com_shop_flower_order WHERE TO_DAYS(create_at)=TO_DAYS(NOW()) and `status` not in (6,7) <if test="storeId != null"> and store_id = #{storeId} </if> union all SELECT IFNULL(sum(pay_amount),0) as count,'monthAmount' as count_name FROM com_shop_flower_order WHERE DATE_FORMAT(create_at,'%Y%m')=DATE_FORMAT(CURDATE(),'%Y%m') and `status` not in (6,7) SELECT IFNULL(sum(pay_amount),0) as count_num,'monthAmount' as count_name FROM com_shop_flower_order WHERE DATE_FORMAT(create_at,'%Y%m')=DATE_FORMAT(CURDATE(),'%Y%m') and `status` not in (6,7) <if test="storeId != null"> and store_id = #{storeId} </if> union all SELECT IFNULL(sum(pay_amount),0) as count,'yearAmount' as count_name FROM com_shop_flower_order where YEAR(create_at) =YEAR(NOW()) and `status` not in (6,7) SELECT IFNULL(sum(pay_amount),0) as count_num,'yearAmount' as count_name FROM com_shop_flower_order where YEAR(create_at) =YEAR(NOW()) and `status` not in (6,7) <if test="storeId != null"> and store_id = #{storeId} </if> union all SELECT IFNULL(sum(pay_amount),0) as count,'allAmount' as count_name FROM com_shop_flower_order WHERE `status` not in (6,7) SELECT IFNULL(sum(pay_amount),0) as count_num,'allAmount' as count_name FROM com_shop_flower_order WHERE `status` not in (6,7) <if test="storeId != null"> and store_id = #{storeId} </if> </select> <select id="selectTurnover" resultType="java.math.BigDecimal"> SELECT IFNULL(sum(pay_amount),0) as count FROM com_shop_flower_order WHERE `status` not in (6,7) and store_id = #{storeId} SELECT IFNULL(sum(pay_amount),0) as count_num FROM com_shop_flower_order WHERE `status` not in (6,7) and store_id = #{storeId} </select> <select id="selectSettlement" resultType="java.math.BigDecimal"> SELECT IFNULL(sum(pay_amount),0) as count FROM com_shop_flower_order WHERE `status` in (4,5) and create_at <= date_sub(now(), INTERVAL 15 DAY) SELECT IFNULL(sum(pay_amount),0) as count_num FROM com_shop_flower_order WHERE `status` in (4,5) and create_at <= date_sub(now(), INTERVAL 15 DAY) </select> <select id="selectSumOrderAndAmountByStoreId" resultType="com.panzhihua.common.model.vos.shop.ComShopOrderStoreIdNumVO"> SELECT count(1) count_num ,'pddd' as count_name FROM `com_shop_flower_order` WHERE delivery_type =1 and delete_status = 1 and pay_status = 2 and store_id = #{storeId} union all SELECT count(1) count_num ,'kddd' as count_name FROM `com_shop_flower_order` WHERE delivery_type =2 and delete_status = 1 and pay_status = 2 and store_id = #{storeId} union all SELECT IFNULL(sum(pay_amount),0) count_num ,'yysr' as count_name FROM `com_shop_flower_order` WHERE `status` not in (6,7) and store_id = #{storeId} union all SELECT IFNULL(sum(pay_amount),0) count_num ,'tkje' as count_name FROM `com_shop_flower_order` WHERE `status` in (6,7) and store_id = #{storeId} union all SELECT IFNULL(sum(pay_amount),0) count_num ,'ktxje' as count_name FROM `com_shop_flower_order` WHERE `status` in (4,5) and create_at <= date_sub(now(), INTERVAL 15 DAY) and store_id = #{storeId} </select> <select id="selectCountOrderDayByStoreId" resultType="com.panzhihua.common.model.vos.shop.ComShopOrderStoreIdCountVO"> SELECT count(1) count_num, date_format(create_at,'%Y-%m-%d') as count_name FROM com_shop_flower_order WHERE date_format(create_at,'%Y-%m-%d') >= date_format(date_sub(now(), INTERVAL #{days} DAY),'%Y-%m-%d') and store_id = #{storeId} GROUP BY count_name </select> <select id="selectCountOrderMonthByStoreId" resultType="com.panzhihua.common.model.vos.shop.ComShopOrderStoreIdCountVO"> SELECT count(1) count_num, date_format(create_at,'%Y-%m') as count_name FROM com_shop_flower_order WHERE date_format(create_at,'%Y-%m') >= date_format(now(),'%Y-01') and store_id = #{storeId} GROUP BY count_name </select> </mapper> springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java
@@ -9,6 +9,7 @@ import com.panzhihua.common.model.vos.community.acid.ComActAcidMemberVO; import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO; import com.panzhihua.common.model.vos.sanshuo.ComSanshuoExpertVO; import com.panzhihua.common.model.vos.shop.ComShopUserAddressVO; import com.panzhihua.common.model.vos.user.*; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -89,7 +90,7 @@ DataKanbanDTO selectCommunityAddUserOrder(@Param("areaCode") String areaCode, @Param("date1") Date date1); List<UsersStatisticsDTO> selectDailyAdd(@Param("createAt") String createAt, @Param("appId") String appId); List<UsersStatisticsDTO> selectDailyAdd(@Param("createAt") String createAt, @Param("appId") String appId); List<UsersStatisticsDTO> selectActive(@Param("lastLoginTime") String lastLoginTime, @Param("appId") String appId); @@ -426,6 +427,7 @@ /** * 查询两个appid的用户做更新 * * @param userId * @return */ @@ -433,18 +435,21 @@ /** * 是否为党员 * */ int isDpcMember(@Param("phone") String phone,@Param("name")String name); */ int isDpcMember(@Param("phone") String phone, @Param("name") String name); /** * 是否为物业公司后台账号 * */ */ Long isPropertyAccount(String phone); /** * 判读是否为自提点账号 * * @param phone * @return */ int checkPoint(String phone); ComShopUserAddressVO selectDefaultAddressVO(@Param("userId") String userId); } springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java
@@ -31,6 +31,7 @@ import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO; import com.panzhihua.common.model.vos.community.microCommercialStreet.McsLoginUserInfoVO; import com.panzhihua.common.model.vos.sanshuo.ComSanshuoExpertVO; import com.panzhihua.common.model.vos.shop.ComShopUserAddressVO; import com.panzhihua.common.model.vos.user.*; import com.panzhihua.common.service.community.CommunityService; import com.panzhihua.common.utlis.*; @@ -549,7 +550,11 @@ loginUserInfoVO.setIsPoint(false); } } //默认地址 ComShopUserAddressVO comShopUserAddressVO = userDao.selectDefaultAddressVO(userId); if (nonNull(comShopUserAddressVO)){ loginUserInfoVO.setComShopUserAddressVO(comShopUserAddressVO); } return R.ok(loginUserInfoVO); } springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/resources/mapper/SysUserDOMapper.xml
@@ -111,5 +111,8 @@ <select id="checkPoint" resultType="int"> select count(1) from com_convenient_elevating_point where wechat_account = #{phone} and business_status = 1 and is_del = 0 </select> <select id="selectDefaultAddressVO" resultType="com.panzhihua.common.model.vos.shop.ComShopUserAddressVO"> select * from com_shop_flower_user_address where user_id = #{userId} and is_default = 1 and delete_status = 2 </select> </mapper>