ComputeItemCostRepository.java 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. package com.kcim.dao.repository;
  2. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  3. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  4. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  5. import com.kcim.common.util.UserContext;
  6. import com.kcim.dao.mapper.ComputeItemCostMapper;
  7. import com.kcim.dao.model.ComputeItemCost;
  8. import com.kcim.dao.model.dto.ComputeItemCostPageDto;
  9. import com.kcim.dao.model.dto.ComputeItemGroupByOrder;
  10. import com.kcim.dao.model.dto.ComputeItemGroupByVisitNoDto;
  11. import org.springframework.stereotype.Repository;
  12. import org.springframework.util.CollectionUtils;
  13. import java.util.ArrayList;
  14. import java.util.List;
  15. import java.util.stream.Collectors;
  16. /**
  17. * @program: CostAccount
  18. * @description: 收费项目成本计算数据库交互
  19. * @author: Wang.YS
  20. * @create: 2023-10-25 14:37
  21. **/
  22. @Repository
  23. public class ComputeItemCostRepository extends ServiceImpl<ComputeItemCostMapper, ComputeItemCost> {
  24. public List<Integer> removeByComputeDate(String computeDate) {
  25. LambdaQueryWrapper<ComputeItemCost> queryWrapper = new LambdaQueryWrapper<>();
  26. queryWrapper.eq(ComputeItemCost::getHospId, UserContext.getHospId());
  27. queryWrapper.eq(ComputeItemCost::getComputeDate,computeDate);
  28. List<ComputeItemCost> list = this.list(queryWrapper);
  29. if(!CollectionUtils.isEmpty(list)){
  30. List<Integer> collect = list.stream().map(ComputeItemCost::getId).collect(Collectors.toList());
  31. this.removeBatchByIds(collect,500);
  32. return collect;
  33. }
  34. return new ArrayList<>();
  35. }
  36. public Page<ComputeItemCostPageDto> getByPage(Integer current, Integer pageSize, String computeDate, String itemType, String itemName){
  37. Page<ComputeItemCostPageDto> page = new Page<>(current,pageSize);
  38. List<ComputeItemCostPageDto> byPage = this.baseMapper.getByPage(page, computeDate, itemType, itemName, UserContext.getHospId());
  39. if(!CollectionUtils.isEmpty(byPage)){
  40. page.setRecords(byPage);
  41. }
  42. return page;
  43. }
  44. public List<ComputeItemGroupByVisitNoDto> getByComputeDateGroupByVisitNo(String computeDate){
  45. return this.baseMapper.getListGroupByVisitNo(computeDate,UserContext.getHospId());
  46. }
  47. public List<ComputeItemGroupByOrder> getByComputeDateGroupByOrder(String computeDate){
  48. return this.baseMapper.getListGroupByOrder(computeDate,UserContext.getHospId());
  49. }
  50. }