package com.ruoyi.system.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.common.basic.PageInfo;
|
import com.ruoyi.common.core.domain.R;
|
import com.ruoyi.common.core.domain.entity.SysUser;
|
import com.ruoyi.common.utils.SecurityUtils;
|
import com.ruoyi.common.utils.StringUtils;
|
import com.ruoyi.system.dto.TCrmClinicDTO;
|
import com.ruoyi.system.export.TCrmClinicAuditExport;
|
import com.ruoyi.system.export.TCrmClinicListExport;
|
import com.ruoyi.system.mapper.TCrmClinicMapper;
|
import com.ruoyi.system.mapper.TCrmClinicPointsMapper;
|
import com.ruoyi.system.model.TCrmClinic;
|
import com.ruoyi.system.model.TCrmClinicPoints;
|
import com.ruoyi.system.model.TErpProcurement;
|
import com.ruoyi.system.query.TCrmClinicQuery;
|
import com.ruoyi.system.service.ISysUserService;
|
import com.ruoyi.system.service.TCrmClinicService;
|
import com.ruoyi.system.service.TErpProcurementService;
|
import com.ruoyi.system.vo.TCrmClinicVO;
|
import com.ruoyi.system.vo.TCrmSupplierVO;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.CollectionUtils;
|
|
import java.math.BigDecimal;
|
import java.text.SimpleDateFormat;
|
import java.time.LocalDate;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Objects;
|
import java.util.stream.Collectors;
|
|
/**
|
* <p>
|
* crm诊所管理 服务实现类
|
* </p>
|
*
|
* @author xiaochen
|
* @since 2025-08-20
|
*/
|
@Service
|
public class TCrmClinicServiceImpl extends ServiceImpl<TCrmClinicMapper, TCrmClinic> implements TCrmClinicService {
|
|
@Autowired
|
private ISysUserService sysUserService;
|
@Autowired
|
private TErpProcurementService erpProcurementService;
|
@Autowired
|
private TCrmClinicPointsMapper crmClinicPointsMapper;
|
|
@Override
|
public PageInfo<TCrmClinicVO> pageList(TCrmClinicQuery query) {
|
String monthDate = new SimpleDateFormat("yyyy-MM").format(new Date());
|
query.setCreateTime(monthDate);
|
PageInfo<TCrmClinicVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
|
List<TCrmClinicVO> list = this.baseMapper.pageList(query,pageInfo);
|
if(CollectionUtils.isEmpty(list)){
|
return pageInfo;
|
}
|
|
List<String> clinicIds = list.stream().map(TCrmClinicVO::getId).collect(Collectors.toList());
|
List<TErpProcurement> procurements = erpProcurementService.list(Wrappers.lambdaQuery(TErpProcurement.class)
|
.in(TErpProcurement::getClinicId, clinicIds)
|
.in(TErpProcurement::getStatus, Arrays.asList(3,4,5))
|
.likeRight(TErpProcurement::getCreateTime, monthDate));
|
|
List<TCrmClinicPoints> points = crmClinicPointsMapper.selectList(new LambdaQueryWrapper<TCrmClinicPoints>().in(TCrmClinicPoints::getClinicId, clinicIds).ge(TCrmClinicPoints::getExpireTime, new Date()).last(" and points > use_points ORDER BY create_time ASC"));
|
|
for (TCrmClinicVO tCrmClinicVO : list) {
|
List<TErpProcurement> procurementList = procurements.stream().filter(procurement -> procurement.getClinicId().equals(tCrmClinicVO.getId())).collect(Collectors.toList());
|
if(!CollectionUtils.isEmpty(procurementList)){
|
tCrmClinicVO.setMonthPurchaseAmount(procurementList.stream().map(TErpProcurement::getPayMoney).reduce(BigDecimal.ZERO, BigDecimal::add));
|
}
|
|
if(Objects.nonNull(tCrmClinicVO.getMonthPurchaseAmount()) && tCrmClinicVO.getMonthPurchaseAmount().compareTo(tCrmClinicVO.getLowProcurementMoney())>-1){
|
tCrmClinicVO.setPerformanceStatus(2);
|
}
|
// 计算可用积分
|
List<TCrmClinicPoints> pointsList = points.stream().filter(item -> item.getClinicId().equals(tCrmClinicVO.getId())).collect(Collectors.toList());
|
// 可用积分
|
int userPoints = pointsList.stream().mapToInt(item -> item.getPoints() - item.getUsePoints()).sum();
|
tCrmClinicVO.setUserPoints(userPoints);
|
|
}
|
pageInfo.setRecords(list);
|
return pageInfo;
|
}
|
|
@Override
|
public PageInfo<TCrmClinicVO> pageAuditList(TCrmClinicQuery query) {
|
PageInfo<TCrmClinicVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize());
|
List<TCrmClinicVO> list = this.baseMapper.pageAuditList(query,pageInfo);
|
pageInfo.setRecords(list);
|
return pageInfo;
|
}
|
|
@Override
|
public R<Boolean> addClinic(TCrmClinicDTO dto) {
|
// 判断账号是否已存在
|
SysUser sysUser = sysUserService.selectUserByUserName(dto.getPhone());
|
if(Objects.nonNull(sysUser)){
|
return R.fail(dto.getPhone()+"-账号已存在");
|
}
|
this.save(dto);
|
// 添加账号
|
SysUser user = new SysUser();
|
user.setUserName(dto.getPhone());
|
user.setPhonenumber(dto.getPhone());
|
user.setNickName(dto.getClinicName());
|
user.setPassword(SecurityUtils.encryptPassword(dto.getPassword()));
|
user.setStatus("0");
|
user.setDelFlag("2");
|
user.setRoleType(5);
|
user.setRoleId(5L);
|
user.setObjectId(dto.getId());
|
sysUserService.insertUser(user);
|
dto.setUserId(user.getUserId());
|
this.updateById(dto);
|
return R.ok();
|
}
|
|
@Override
|
public R<Boolean> updateClinic(TCrmClinicDTO dto) {
|
// 判断账号是否已存在
|
SysUser sysUser1 = sysUserService.selectUserByUserName(dto.getPhone());
|
if(Objects.nonNull(sysUser1) && !sysUser1.getUserId().equals(dto.getUserId())){
|
return R.fail(dto.getPhone()+"-账号已存在");
|
}
|
this.updateById(dto);
|
SysUser user = sysUserService.selectUserById(dto.getUserId());
|
if(Objects.nonNull(user)){
|
// 修改账号
|
user.setPhonenumber(dto.getPhone());
|
user.setUserName(dto.getPhone());
|
user.setNickName(dto.getClinicName());
|
if(StringUtils.isNotEmpty(dto.getPassword())){
|
user.setPassword(SecurityUtils.encryptPassword(dto.getPassword()));
|
}
|
sysUserService.updateUser(user);
|
}
|
return R.ok();
|
}
|
|
@Override
|
public List<TCrmClinicAuditExport> exportAudit(TCrmClinicQuery query) {
|
List<TCrmClinicAuditExport> list = this.baseMapper.exportAudit(query);
|
return list;
|
}
|
|
@Override
|
public List<TCrmClinicListExport> exportList(TCrmClinicQuery query) {
|
String monthDate = new SimpleDateFormat("yyyy-MM").format(new Date());
|
query.setCreateTime(monthDate);
|
List<TCrmClinicListExport> list = this.baseMapper.exportList(query);
|
if(CollectionUtils.isEmpty(list)){
|
return list;
|
}
|
|
List<String> clinicIds = list.stream().map(TCrmClinicListExport::getId).collect(Collectors.toList());
|
List<TErpProcurement> procurements = erpProcurementService.list(Wrappers.lambdaQuery(TErpProcurement.class)
|
.in(TErpProcurement::getClinicId, clinicIds)
|
.in(TErpProcurement::getStatus, Arrays.asList(3,4,5))
|
.likeRight(TErpProcurement::getCreateTime, monthDate));
|
|
List<TCrmClinicPoints> points = crmClinicPointsMapper.selectList(new LambdaQueryWrapper<TCrmClinicPoints>().in(TCrmClinicPoints::getClinicId, clinicIds).ge(TCrmClinicPoints::getExpireTime, new Date()).last(" and points > use_points ORDER BY create_time ASC"));
|
|
for (TCrmClinicListExport crmClinicListExport : list) {
|
List<TErpProcurement> procurementList = procurements.stream().filter(procurement -> procurement.getClinicId().equals(crmClinicListExport.getId())).collect(Collectors.toList());
|
if(!CollectionUtils.isEmpty(procurementList)){
|
crmClinicListExport.setMonthPurchaseAmount(procurementList.stream().map(TErpProcurement::getPayMoney).reduce(BigDecimal.ZERO, BigDecimal::add));
|
}
|
|
if(Objects.nonNull(crmClinicListExport.getMonthPurchaseAmount()) && crmClinicListExport.getMonthPurchaseAmount().compareTo(crmClinicListExport.getLowProcurementMoney())>0){
|
crmClinicListExport.setPerformanceStatus(2);
|
}
|
|
// 计算可用积分
|
List<TCrmClinicPoints> pointsList = points.stream().filter(item -> item.getClinicId().equals(crmClinicListExport.getId())).collect(Collectors.toList());
|
// 可用积分
|
int userPoints = pointsList.stream().mapToInt(item -> item.getPoints() - item.getUsePoints()).sum();
|
crmClinicListExport.setUserPoints(userPoints);
|
|
}
|
return list;
|
}
|
}
|
