package com.panzhihua.service_community.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Collectors;
|
|
import javax.annotation.Resource;
|
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.ObjectUtils;
|
|
import com.alibaba.fastjson.JSON;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.panzhihua.common.model.dtos.community.ComCvtServeDTO;
|
import com.panzhihua.common.model.dtos.community.PageComCvtServeDTO;
|
import com.panzhihua.common.model.vos.R;
|
import com.panzhihua.common.model.vos.community.ComCvtBusinessCategoryServeVO;
|
import com.panzhihua.common.model.vos.community.ComCvtServeExcelVO;
|
import com.panzhihua.common.model.vos.community.ComCvtServeVO;
|
import com.panzhihua.common.model.vos.community.ComMngPopulationImportErrorVO;
|
import com.panzhihua.service_community.dao.ComCvtBusinessDAO;
|
import com.panzhihua.service_community.dao.ComCvtCategoryDAO;
|
import com.panzhihua.service_community.dao.ComCvtServeDAO;
|
import com.panzhihua.service_community.model.dos.ComCvtBusinessDO;
|
import com.panzhihua.service_community.model.dos.ComCvtCategoryDO;
|
import com.panzhihua.service_community.model.dos.ComCvtServeDO;
|
import com.panzhihua.service_community.service.ComCvtServeService;
|
|
/**
|
* @description: 社区 便民服务接口实现类
|
* @author: Null
|
* @date: 2021/3/12 8:58
|
*/
|
@Service
|
public class ComCvtServeServiceImpl extends ServiceImpl<ComCvtServeDAO, ComCvtServeDO> implements ComCvtServeService {
|
|
@Resource
|
private ComCvtServeDAO comCvtServeDAO;
|
|
@Resource
|
private ComCvtBusinessDAO comCvtBusinessDAO;
|
|
@Resource
|
private ComCvtCategoryDAO comCvtCategoryDAO;
|
|
@Override
|
public R pageComCvtServe(PageComCvtServeDTO pageComCvtServeDTO) {
|
Page page = new Page<>();
|
Long pageNum = pageComCvtServeDTO.getPageNum();
|
Long pageSize = pageComCvtServeDTO.getPageSize();
|
if (null == pageNum || 0 == pageNum) {
|
pageNum = 1l;
|
}
|
if (null == pageSize || 0 == pageSize) {
|
pageSize = 10l;
|
}
|
page.setSize(pageSize);
|
page.setCurrent(pageNum);
|
IPage<ComCvtServeVO> iPage = comCvtServeDAO.pageComCvtServe(page, pageComCvtServeDTO);
|
return R.ok(iPage);
|
|
}
|
|
@Override
|
public R addComCvtServe(ComCvtServeDTO comCvtServeDTO) {
|
ComCvtServeDO comCvtServeDO = new ComCvtServeDO();
|
BeanUtils.copyProperties(comCvtServeDTO, comCvtServeDO);
|
if (checkRepeat(comCvtServeDO)) {
|
return R.fail("服务已存在");
|
}
|
int insert = comCvtServeDAO.insert(comCvtServeDO);
|
if (insert > 0) {
|
return R.ok();
|
}
|
return R.fail();
|
}
|
|
@Override
|
public R putComCvtServe(ComCvtServeDTO comCvtServeDTO) {
|
ComCvtServeDO comCvtServeDO = comCvtServeDAO.selectById(comCvtServeDTO.getId());
|
if (null == comCvtServeDO) {
|
return R.fail("该服务不存在");
|
}
|
ComCvtServeDO comCvtServeDO2 = new ComCvtServeDO();
|
BeanUtils.copyProperties(comCvtServeDTO, comCvtServeDO2);
|
if (!comCvtServeDO.equals(comCvtServeDO2) && checkRepeat(comCvtServeDO2)) {
|
return R.fail("该服务与其他服务重复");
|
}
|
int update = comCvtServeDAO.updateById(comCvtServeDO2);
|
if (update > 0) {
|
return R.ok();
|
}
|
return R.fail();
|
}
|
|
@Override
|
public R getComCvtServe(Long id) {
|
ComCvtServeDO comCvtServeDO = comCvtServeDAO.selectById(id);
|
if (null == comCvtServeDO) {
|
return R.fail("该服务不存在");
|
}
|
ComCvtServeVO comCvtServeVO = new ComCvtServeVO();
|
BeanUtils.copyProperties(comCvtServeDO, comCvtServeVO);
|
ComCvtBusinessDO comCvtBusinessDO = comCvtBusinessDAO.selectById(comCvtServeDO.getBusinessId());
|
if (null != comCvtBusinessDO) {
|
comCvtServeVO.setBusinessName(comCvtBusinessDO.getName());
|
}
|
ComCvtCategoryDO comCvtCategoryDO = comCvtCategoryDAO.selectById(comCvtServeDO.getCategoryId());
|
if (null != comCvtCategoryDO) {
|
comCvtServeVO.setCategoryName(comCvtCategoryDO.getName());
|
}
|
return R.ok(comCvtServeDO);
|
}
|
|
@Override
|
public R deleteComCvtServe(Long id) {
|
ComCvtServeDO comCvtServeDO = comCvtServeDAO.selectById(id);
|
if (null == comCvtServeDO) {
|
return R.fail("该服务不存在");
|
}
|
int count = comCvtServeDAO.deleteById(id);
|
if (count < 1) {
|
return R.fail("删除失败");
|
}
|
return R.ok();
|
}
|
|
@Override
|
public List<ComCvtBusinessCategoryServeVO> getBusinessCategoryServeVOS(Long businessId) {
|
List<ComCvtBusinessCategoryServeVO> comCvtBusinessCategoryServeVOS = new ArrayList<>();
|
List<ComCvtServeDO> comCvtServeDOS = comCvtServeDAO
|
.selectList(new QueryWrapper<ComCvtServeDO>().lambda().eq(ComCvtServeDO::getBusinessId, businessId));
|
List<ComCvtCategoryDO> categoryDOS = comCvtCategoryDAO
|
.selectList(new QueryWrapper<ComCvtCategoryDO>().lambda().orderByDesc(ComCvtCategoryDO::getWeight));
|
categoryDOS.stream().forEach(categoryDO -> {
|
List<ComCvtServeVO> serveVOS = getComCvtServeDOSByCategory(comCvtServeDOS, categoryDO.getId());
|
if (!ObjectUtils.isEmpty(serveVOS)) {
|
ComCvtBusinessCategoryServeVO comCvtServeVo = new ComCvtBusinessCategoryServeVO();
|
comCvtServeVo.setCategoryName(categoryDO.getName());
|
comCvtServeVo.setComCvtServeVOS(serveVOS);
|
comCvtBusinessCategoryServeVOS.add(comCvtServeVo);
|
}
|
});
|
return comCvtBusinessCategoryServeVOS;
|
}
|
|
/**
|
* 按分类筛选
|
*
|
* @param comCvtServeDOS
|
* @param categoryId
|
* @return
|
*/
|
private List<ComCvtServeVO> getComCvtServeDOSByCategory(List<ComCvtServeDO> comCvtServeDOS, Long categoryId) {
|
List<ComCvtServeVO> comCvtServeVOS = new ArrayList<>();
|
comCvtServeDOS =
|
comCvtServeDOS.stream().filter(dos -> dos.getCategoryId() == categoryId).collect(Collectors.toList());
|
comCvtServeDOS.forEach(comCvtServeDO -> {
|
ComCvtServeVO vo = new ComCvtServeVO();
|
BeanUtils.copyProperties(comCvtServeDO, vo);
|
comCvtServeVOS.add(vo);
|
});
|
return comCvtServeVOS;
|
}
|
|
@Override
|
public R listSaveConvenientServeExcelVO(List<ComCvtServeExcelVO> list, Long communityId) {
|
List<ComCvtServeDO> comCvtServeDOS = new ArrayList<>();
|
List<ComMngPopulationImportErrorVO> populationImportErrorVOList = new ArrayList<>();
|
List<ComCvtCategoryDO> categoryDOS = comCvtCategoryDAO
|
.selectList(new QueryWrapper<ComCvtCategoryDO>().lambda().orderByDesc(ComCvtCategoryDO::getWeight));
|
Map<String, Long> categoryMap = getCategoryMap(categoryDOS);
|
List<ComCvtBusinessDO> comCvtBusinessDOS;
|
if (null != communityId && communityId != 0) {
|
comCvtBusinessDOS = comCvtBusinessDAO.selectList(
|
new QueryWrapper<ComCvtBusinessDO>().lambda().eq(ComCvtBusinessDO::getCommunityId, communityId));
|
} else {
|
comCvtBusinessDOS = comCvtBusinessDAO.selectList(new LambdaQueryWrapper<>());
|
}
|
Map<String, Long> businessMap = getBusinessMap(comCvtBusinessDOS);
|
int index = 2;
|
for (ComCvtServeExcelVO comCvtServeExcelVO : list) {
|
|
/**
|
* 便民服务分类存在 并且 便民服务商家 匹配上
|
*/
|
if (categoryMap.containsKey(comCvtServeExcelVO.getCategoryName())
|
&& businessMap.containsKey(comCvtServeExcelVO.getBusinessName())) {
|
ComCvtServeDO comCvtServeDO = new ComCvtServeDO();
|
BeanUtils.copyProperties(comCvtServeExcelVO, comCvtServeDO);
|
comCvtServeDO.setCategoryId(categoryMap.get(comCvtServeExcelVO.getCategoryName()));
|
comCvtServeDO.setBusinessId(businessMap.get(comCvtServeExcelVO.getBusinessName()));
|
// 检查商家是否已有某服务
|
if (!checkRepeat(comCvtServeDO)) {
|
comCvtServeDOS.add(comCvtServeDO);
|
} else {
|
ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
|
importErrorVO.setErrorMsg(String.format("导入失败：商家【%s】下已有服务【%s】",
|
comCvtServeExcelVO.getBusinessName(), comCvtServeExcelVO.getServiceName()));
|
// importErrorVO.setErrorPosition("第" + index + "行");
|
populationImportErrorVOList.add(importErrorVO);
|
log.error(String.format("导入失败：商家【%s】下已有服务【%s】", comCvtServeExcelVO.getBusinessName(),
|
comCvtServeExcelVO.getServiceName()));
|
}
|
} else {
|
if (!categoryMap.containsKey(comCvtServeExcelVO.getCategoryName())) {
|
ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
|
importErrorVO.setErrorMsg("导入失败: 服务分类" + comCvtServeExcelVO.getCategoryName() + "不存在");
|
// importErrorVO.setErrorPosition("第" + index + "行，第1列");
|
populationImportErrorVOList.add(importErrorVO);
|
// errorInfo.add(comCvtServeExcelVO.getCategoryName() +"导入失败: 服务分类不存在");
|
}
|
if (!businessMap.containsKey(comCvtServeExcelVO.getBusinessName())) {
|
ComMngPopulationImportErrorVO importErrorVO = new ComMngPopulationImportErrorVO();
|
importErrorVO.setErrorMsg("导入失败: 便民服务商家" + comCvtServeExcelVO.getBusinessName() + "不存在");
|
// importErrorVO.setErrorPosition("第" + index + "行，第5列");
|
populationImportErrorVOList.add(importErrorVO);
|
}
|
}
|
index++;
|
}
|
boolean saveBatched = this.saveBatch(comCvtServeDOS);
|
if (saveBatched) {
|
if (comCvtServeDOS.size() > 0 && populationImportErrorVOList.size() > 0) {
|
return R.fail(JSON.toJSONString(populationImportErrorVOList));
|
}
|
if (comCvtServeDOS.size() == 0 && populationImportErrorVOList.size() > 0) {
|
return R.fail(JSON.toJSONString(populationImportErrorVOList));
|
}
|
} else {
|
return R.fail(JSON.toJSONString(populationImportErrorVOList));
|
}
|
return R.ok("共计导入服务数量：" + comCvtServeDOS.size());
|
}
|
|
// 获取分类集合
|
private Map<String, Long> getCategoryMap(List<ComCvtCategoryDO> categoryDOS) {
|
Map<String, Long> categoryMap = new HashMap<>();
|
if (!ObjectUtils.isEmpty(categoryDOS)) {
|
categoryDOS.forEach(categoryDO -> {
|
categoryMap.put(categoryDO.getName(), categoryDO.getId());
|
});
|
}
|
return categoryMap;
|
}
|
|
// 获取商家集合
|
private Map<String, Long> getBusinessMap(List<ComCvtBusinessDO> comCvtBusinessDOS) {
|
Map<String, Long> businessMap = new HashMap<>();
|
if (!ObjectUtils.isEmpty(comCvtBusinessDOS)) {
|
comCvtBusinessDOS.forEach(businessDO -> {
|
businessMap.put(businessDO.getName(), businessDO.getId());
|
});
|
}
|
return businessMap;
|
}
|
|
/**
|
* 检查服务是否重复 商家名称、分类名称，服务名称、服务价格、服务描述不能同时重复
|
*
|
* @param comCvtServeDO
|
* @return
|
*/
|
private boolean checkRepeat(ComCvtServeDO comCvtServeDO) {
|
Integer count = comCvtServeDAO.selectCount(
|
new QueryWrapper<ComCvtServeDO>().lambda().eq(ComCvtServeDO::getBusinessId, comCvtServeDO.getBusinessId())
|
.and(wrapper -> wrapper.eq(ComCvtServeDO::getCategoryId, comCvtServeDO.getCategoryId()))
|
.and(wrapper -> wrapper.eq(ComCvtServeDO::getServiceName, comCvtServeDO.getServiceName()))
|
.and(wrapper -> wrapper.eq(ComCvtServeDO::getServicePrice, comCvtServeDO.getServicePrice()))
|
.and(wrapper -> wrapper.eq(ComCvtServeDO::getServiceDesc, comCvtServeDO.getServiceDesc())));
|
return count > 0;
|
}
|
}
|
