IncomeCollectionMapper.java 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. package com.imed.costaccount.mapper;
  2. import com.imed.costaccount.model.IncomeCollection;
  3. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  4. import com.imed.costaccount.model.dto.CollectDTO;
  5. import com.imed.costaccount.model.vo.CodeAndNameVO;
  6. import com.imed.costaccount.model.vo.CollectedVO;
  7. import org.apache.ibatis.annotations.Mapper;
  8. import org.apache.ibatis.annotations.Param;
  9. import java.math.BigDecimal;
  10. import java.util.List;
  11. /**
  12. * 归集后列表
  13. *
  14. * @author huangrui
  15. * @date 2021-08-09 15:26:28
  16. */
  17. @Mapper
  18. public interface IncomeCollectionMapper extends BaseMapper<IncomeCollection> {
  19. /**
  20. * 分页List
  21. *
  22. * @param collectDTO {@link CollectDTO}
  23. * @return {@link CollectedVO}
  24. */
  25. List<CollectedVO> getCollectList(@Param("collectDTO") CollectDTO collectDTO);
  26. /**
  27. * 总数
  28. * @param collectDTO {@link CollectDTO}
  29. * @return
  30. */
  31. int getCollectListCount(@Param("collectDTO") CollectDTO collectDTO);
  32. /**
  33. * 计算总金额
  34. * @param collectDTO {@link CollectDTO}
  35. * @return
  36. */
  37. BigDecimal getTotalAmount(@Param("collectDTO") CollectDTO collectDTO);
  38. /**
  39. * 纵向计算所有的amount
  40. * @param responsibilityCode
  41. * @param accountingCodes
  42. * @param hospId
  43. * @param date
  44. * @return
  45. */
  46. BigDecimal getCountByResponseAndAccounts(@Param("responsibilityCode") String responsibilityCode, @Param("accountingCodes") List<String> accountingCodes, @Param("hospId") Long hospId, @Param("date") String date);
  47. List<CodeAndNameVO> getResponsibility(@Param("hospId") Long hospId, @Param("responsibilityCode") String responsibilityCode, @Param("date") String date);
  48. List<CodeAndNameVO> getAccount(@Param("hospId") Long hospId, @Param("accountingCode") String accountingCode, @Param("date") String date);
  49. BigDecimal getCountAccountAndResponsibilities(@Param("hospId") Long hospId, @Param("date") String date, @Param("code") String code, @Param("responsibilityCodes") List<String> responsibilityCodes);
  50. BigDecimal getCountByResponsibilitiesAndAccounts(@Param("responsibilityCodes") List<String> responsibilityCodes, @Param("accountingCodes") List<String> accountingCodes, @Param("hospId") Long hospId, @Param("date") String date);
  51. }