| | |
| | | import com.doumee.dao.business.model.*; |
| | | import com.doumee.dao.business.vo.ShopTree; |
| | | import com.doumee.dao.business.vo.ShopTreeVo; |
| | | import com.doumee.dao.business.vo.UnitCodeVo; |
| | | import com.doumee.dao.web.reqeust.EditShopDTO; |
| | | import com.doumee.dao.web.reqeust.ShopQueryByLLDTO; |
| | | import com.doumee.service.business.ShopService; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | |
| | | import com.github.yulichang.wrapper.MPJLambdaWrapper; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.apache.shiro.SecurityUtils; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.data.redis.core.RedisTemplate; |
| | | import org.springframework.scheduling.annotation.Async; |
| | |
| | | import org.springframework.util.CollectionUtils; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.*; |
| | | import java.util.concurrent.Callable; |
| | | import java.util.concurrent.ExecutorService; |
| | | import java.util.concurrent.Executors; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * 志邦组织信息表Service实现 |
| | |
| | | @Override |
| | | public void updateById(Shop shop) { |
| | | shopMapper.updateById(shop); |
| | | usersMapper.update(new UpdateWrapper<Users>().lambda() |
| | | .set(Users::getCardImg,null) |
| | | .isNotNull(Users::getCardImg) |
| | | .eq(Users::getDepartmentId,shop.getId()) |
| | | ); |
| | | } |
| | | |
| | | @Override |
| | |
| | | queryWrapper.orderByAsc(sortData.getProperty()); |
| | | } |
| | | } |
| | | return PageData.from(shopMapper.selectPage(page, queryWrapper)); |
| | | PageData<Shop> pageData = PageData.from(shopMapper.selectPage(page, queryWrapper)); |
| | | //查询经营范围信息 |
| | | List<CategorySeg> categorySegAllList = categorySegMapper.selectList(new QueryWrapper<CategorySeg>().lambda() |
| | | .isNotNull(CategorySeg::getOrgId) |
| | | .eq(CategorySeg::getIsdeleted,Constants.ZERO)); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(categorySegAllList)){ |
| | | for (Shop shop:pageData.getRecords()) { |
| | | if(StringUtils.isBlank(shop.getOrgId())){ |
| | | continue; |
| | | } |
| | | List<CategorySeg> categorySegList = categorySegAllList.stream().filter(i->i.getOrgId().equals(shop.getOrgId())).collect(Collectors.toList()); |
| | | List<UnitCodeVo> unitCodeVoList =systemDictDataBiz.getUnitList(); |
| | | List<String> seqNameList = new ArrayList<>(); |
| | | for(CategorySeg model : categorySegList){ |
| | | String seqName = systemDictDataBiz.getUnitName(model.getUnitCode(),unitCodeVoList); |
| | | if(Objects.nonNull(seqName)){ |
| | | seqNameList.add(seqName); |
| | | } |
| | | } |
| | | shop.setSeqNameList(seqNameList); |
| | | } |
| | | } |
| | | |
| | | return pageData; |
| | | } |
| | | |
| | | @Override |
| | |
| | | shop.setLegalPhone(model.getLegalPhone()); |
| | | shop.setLegalIdcode(model.getLegalIdcode()); |
| | | shop.setLegalName(model.getLegalName()); |
| | | shop.setFcode(model.getFcode()); |
| | | shop.setScode(model.getScode()); |
| | | shop.setTaxRegCode(model.getTaxRegCode()); |
| | | shopMapper.updateById(shop); |
| | | } |
| | |
| | | } |
| | | |
| | | @Async |
| | | private void dealCategoryDataBiz(List<CategoryImport> dataList, Date date, LoginUserInfo loginUserInfo) { |
| | | public void dealCategoryDataBiz(List<CategoryImport> dataList, Date date, LoginUserInfo loginUserInfo) { |
| | | try { |
| | | List<CategorySeg> categorySegList = new ArrayList<>(); |
| | | List<Segments> segmentsList = new ArrayList<>(); |
| | |
| | | shop.setSecondType(model.getSecondType()); |
| | | shop.setAttribute(model.getAttribute()); |
| | | shop.setParentIamId(model.getParentOrgId()); |
| | | shop.setScode(model.getScode()); |
| | | newList.add(shop); |
| | | }else { |
| | | shop.setEditor(loginUserInfo.getId()); |
| | |
| | | shop.setSecondType(model.getSecondType()); |
| | | shop.setName(model.getName()); |
| | | shop.setCode(model.getCode()); |
| | | shop.setScode(model.getScode()); |
| | | shop.setUnitCode(model.getUnitCode()); |
| | | if(Constants.equalsInteger(model.getStatus(),Constants.TWO)){ |
| | | shop.setIsdeleted(Constants.ONE); |
| | |
| | | } |
| | | IPage<Shop> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<Shop> queryWrapper = new MPJLambdaWrapper<>(); |
| | | queryWrapper.select("ID,NAME,ADDRESS,PROVINCE_NAME,CITY_NAME,AREA_NAME,TOWN,AREA_NAME,LEGAL_PHONE," + |
| | | " CONVERT (ST_Distance_Sphere (point ("+pageWrap.getModel().getLongitude()+", "+pageWrap.getModel().getLatitude()+" ), point ( LONGITUDE, LATITUDE )) /1000,decimal(15,2)) as distance ") |
| | | queryWrapper.select("ID,NAME,LINK_PHONE,ADDRESS,PROVINCE_NAME,CITY_NAME,AREA_NAME,TOWN,AREA_NAME,LEGAL_PHONE " + |
| | | " , (6371 * ACOS(COS(RADIANS("+pageWrap.getModel().getLatitude()+")) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS("+pageWrap.getModel().getLongitude()+")) + SIN(RADIANS("+pageWrap.getModel().getLatitude()+")) * SIN(RADIANS(latitude)) ) ) as distance " ) |
| | | .eq("isdeleted",Constants.ZERO) |
| | | .isNotNull("LATITUDE") |
| | | .isNotNull("LONGITUDE") |
| | | .eq("ATTRIBUTE",Constants.ONE) |
| | | .eq("TYPE",Constants.TWO) |
| | | .eq("SECOND_TYPE",Constants.THREE) |
| | | .eq("STATUS",Constants.ONE) |
| | | .orderByAsc(" distance "); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | PageData<Shop> pageData = PageData.from(shopMapper.selectPage(page, queryWrapper)); |
| | | String prefix = StringUtils.trimToNull(systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.RESOURCE_PATH).getCode()) + |
| | | StringUtils.trimToNull(systemDictDataBiz.queryByCode(Constants.OBJCET_STORAGE,Constants.USERS_FILE).getCode()); |
| | | for (Shop shop:pageData.getRecords()) { |
| | | this.dealDistance(shop); |
| | | //查询门店下导购数据 |
| | | List<Users> usersList =usersMapper.selectList(new QueryWrapper<Users>().lambda().eq(Users::getDepartmentId,shop.getId()) |
| | | .eq(Users::getIsdeleted,Constants.ZERO) |
| | | .eq(Users::getStatus,Constants.ONE) |
| | | .eq(Users::getType,Constants.ZERO) |
| | | ); |
| | | for (Users users:usersList) { |
| | | if(StringUtils.isNotBlank(users.getImgurl())){ |
| | |
| | | return pageData; |
| | | } |
| | | |
| | | /** |
| | | * 处理门店距离显示 |
| | | * @param shop |
| | | */ |
| | | public void dealDistance(Shop shop){ |
| | | if(Objects.isNull(shop.getDistance())){ |
| | | shop.setDistanceStr("-"); |
| | | }else{ |
| | | //距离小于1公里 显示米 |
| | | if(shop.getDistance().compareTo(BigDecimal.ONE)<Constants.ZERO){ |
| | | BigDecimal distanceM = shop.getDistance().multiply(new BigDecimal(1000).setScale(0)); |
| | | //100米之内 |
| | | if(distanceM.compareTo(new BigDecimal(100))<0){ |
| | | shop.setDistanceStr("<100米"); |
| | | }else{ |
| | | shop.setDistanceStr(distanceM.divide(BigDecimal.valueOf(1)).setScale(0,BigDecimal.ROUND_HALF_UP) + "m"); |
| | | } |
| | | }else{ |
| | | shop.setDistanceStr(shop.getDistance().divide(BigDecimal.valueOf(1)).setScale(2,BigDecimal.ROUND_HALF_UP) + "km"); |
| | | } |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public Shop shopDetail(Long id,Long memberId) { |
| | | Member member = memberMapper.selectById(memberId); |
| | | if(Objects.isNull(member)){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"未查询到用户信息"); |
| | | } |
| | | QueryWrapper<Shop> queryWrapper = new QueryWrapper<Shop>(); |
| | | //如果人员没有经纬度信息,则不查询距离 |
| | | if(Objects.nonNull(member.getLatitude())&&Objects.nonNull(member.getLongitude())){ |
| | | queryWrapper.select("ID,NAME,ADDRESS,PROVINCE_NAME,CITY_NAME,AREA_NAME,TOWN,AREA_NAME,LEGAL_PHONE," + |
| | | " CONVERT (ST_Distance_Sphere (point ("+member.getLongitude()+", "+member.getLatitude()+" ), point ( LONGITUDE, LATITUDE )) /1000,decimal(15,2)) as distance "); |
| | | if(Objects.nonNull(memberId)){ |
| | | Member member = memberMapper.selectById(memberId); |
| | | //如果人员没有经纬度信息,则不查询距离 |
| | | if(Objects.nonNull(member)&&Objects.nonNull(member.getLatitude())&&Objects.nonNull(member.getLongitude())){ |
| | | queryWrapper.select(" * " + |
| | | " , (6371 * ACOS(COS(RADIANS("+member.getLatitude()+")) * COS(RADIANS(latitude)) * COS(RADIANS(longitude) - RADIANS("+member.getLongitude()+")) + SIN(RADIANS("+member.getLatitude()+")) * SIN(RADIANS(latitude)) ) ) as distance " ); |
| | | } |
| | | } |
| | | queryWrapper.eq("id",id); |
| | | Shop shop = shopMapper.selectOne(queryWrapper); |
| | |
| | | List<Users> usersList =usersMapper.selectList(new QueryWrapper<Users>().lambda().eq(Users::getDepartmentId,shop.getId()) |
| | | .eq(Users::getIsdeleted,Constants.ZERO) |
| | | .eq(Users::getStatus,Constants.ONE) |
| | | .eq(Users::getType,Constants.ZERO) |
| | | ); |
| | | this.dealDistance(shop); |
| | | for (Users users:usersList) { |
| | | if(StringUtils.isNotBlank(users.getImgurl())){ |
| | | users.setImgurlFull(prefix + users.getImgurl()); |
| | | } |
| | | } |
| | | shop.setUsersList(usersList); |
| | | //查询经营范围信息 |
| | | List<CategorySeg> categorySegList = categorySegMapper.selectList(new QueryWrapper<CategorySeg>().lambda().eq(CategorySeg::getScode,shop.getScode()).eq(CategorySeg::getIsdeleted,Constants.ZERO)); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(categorySegList)){ |
| | | List<UnitCodeVo> unitCodeVoList =systemDictDataBiz.getUnitList(); |
| | | List<String> seqNameList = new ArrayList<>(); |
| | | for(CategorySeg model : categorySegList){ |
| | | String seqName = systemDictDataBiz.getUnitName(model.getUnitCode(),unitCodeVoList); |
| | | if(Objects.nonNull(seqName)){ |
| | | seqNameList.add(seqName); |
| | | } |
| | | } |
| | | Set<String> hs = new HashSet<String>(seqNameList); |
| | | shop.setSeqNameList(new ArrayList<String>(hs)); |
| | | } |
| | | return shop; |
| | | } |
| | | |
| | | @Override |
| | | public void updShop(EditShopDTO editShopDTO) { |
| | | if(Objects.isNull(editShopDTO) |
| | | || Objects.isNull(editShopDTO.getId())){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | Shop shop = shopMapper.selectById(editShopDTO.getId()); |
| | | if(Objects.isNull(shop)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY); |
| | | } |
| | | Shop updShop = new Shop(); |
| | | BeanUtils.copyProperties(editShopDTO,updShop); |
| | | shopMapper.updateById(updShop); |
| | | usersMapper.update(new UpdateWrapper<Users>().lambda() |
| | | .set(Users::getCardImg,null) |
| | | .isNotNull(Users::getCardImg) |
| | | .eq(Users::getDepartmentId,shop.getId()) |
| | | ); |
| | | } |
| | | |
| | | @Override |
| | | public List<Shop> getUserShopList(Long userId) { |
| | | Users users = usersMapper.selectById(userId); |
| | | if(Objects.isNull(users)){ |
| | | return new ArrayList<>(); |
| | | } |
| | | Shop userShop = shopMapper.selectById(users.getDepartmentId()); |
| | | if(Objects.isNull(userShop)){ |
| | | return new ArrayList<>(); |
| | | } |
| | | Boolean manageShop = true; |
| | | if(users.getRoleCodes().indexOf(StringUtils.trimToNull(systemDictDataBiz.queryByCode(Constants.ZBOM_CUSTOMIZED,Constants.USERS_MANAGE_CODE).getCode()))>=0){ |
| | | manageShop = false; |
| | | } |
| | | List<Shop> shopList = shopMapper.selectList(new QueryWrapper<Shop>() |
| | | .lambda() |
| | | .eq(Shop::getScode,userShop.getScode()) |
| | | .eq(Shop::getType,Constants.TWO) |
| | | .eq(Shop::getSecondType,Constants.THREE) |
| | | .apply(manageShop,"1=2") |
| | | ); |
| | | //查询经营范围信息 |
| | | List<CategorySeg> categorySegAllList = categorySegMapper.selectList(new QueryWrapper<CategorySeg>().lambda() |
| | | .isNotNull(CategorySeg::getOrgId) |
| | | .eq(CategorySeg::getIsdeleted,Constants.ZERO)); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(categorySegAllList)){ |
| | | for (Shop shop:shopList) { |
| | | if(StringUtils.isBlank(shop.getOrgId())){ |
| | | continue; |
| | | } |
| | | List<CategorySeg> categorySegList = categorySegAllList.stream().filter(i->i.getScode().equals(shop.getScode())).collect(Collectors.toList()); |
| | | List<UnitCodeVo> unitCodeVoList =systemDictDataBiz.getUnitList(); |
| | | List<String> seqNameList = new ArrayList<>(); |
| | | for(CategorySeg model : categorySegList){ |
| | | String seqName = systemDictDataBiz.getUnitName(model.getUnitCode(),unitCodeVoList); |
| | | if(Objects.nonNull(seqName)){ |
| | | seqNameList.add(seqName); |
| | | } |
| | | } |
| | | Set<String> hs = new HashSet<String>(seqNameList); |
| | | shop.setSeqNameList(new ArrayList<String>(hs)); |
| | | } |
| | | } |
| | | return shopList; |
| | | } |
| | | |
| | | } |