| | |
| | | import com.ruoyi.common.utils.DateUtils; |
| | | import javax.annotation.Resource; |
| | | |
| | | import com.ruoyi.cwgl.mapper.ReceivableFeeManagementMapper; |
| | | import com.ruoyi.cwgl.domain.*; |
| | | import com.ruoyi.cwgl.domain.vo.ReceivableBillAgingAnalysisVo; |
| | | import com.ruoyi.cwgl.mapper.*; |
| | | import com.ruoyi.cwgl.service.IAgingLogService; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.scheduling.annotation.Async; |
| | |
| | | import com.ruoyi.common.enums.DataSourceType; |
| | | import com.ruoyi.common.core.service.BaseService; |
| | | |
| | | import com.ruoyi.cwgl.mapper.ReceivableBillManagementMapper; |
| | | import com.ruoyi.cwgl.domain.ReceivableBillManagement; |
| | | import com.ruoyi.cwgl.domain.ReceivableFeeManagement; |
| | | import com.ruoyi.cwgl.service.IReceivableBillManagementService; |
| | | import com.ruoyi.cwgl.service.IReceivableFeeManagementService; |
| | | import com.ruoyi.common.core.text.Convert; |
| | | import com.ruoyi.common.exception.ServiceException; |
| | | import com.ruoyi.common.utils.SecurityUtils; |
| | | |
| | | /** |
| | | * 应收账单管理Service业务层处理 |
| | |
| | | private ReceivableBillManagementMapper receivableBillManagementMapper; |
| | | @Resource |
| | | private ReceivableFeeManagementMapper receivableFeeManagementMapper; |
| | | |
| | | @Resource |
| | | private ReceivableBillManagementLogMapper receivableBillManagementLogMapper; |
| | | @Resource |
| | | private AgingLogMapper agingLogMapper; |
| | | @Resource |
| | | private AccountLogMapper accountLogMapper; |
| | | |
| | | |
| | | /** |
| | |
| | | public int updateReceivableBillManagement(ReceivableBillManagement receivableBillManagement) |
| | | { |
| | | receivableBillManagement.setUpdateTime(DateUtils.getNowDate()); |
| | | return receivableBillManagementMapper.updateReceivableBillManagement(receivableBillManagement); |
| | | int result = receivableBillManagementMapper.updateReceivableBillManagement(receivableBillManagement); |
| | | |
| | | // 记录操作日志 |
| | | if (result > 0) { |
| | | ReceivableBillManagementLog log = new ReceivableBillManagementLog(); |
| | | log.setBillId(receivableBillManagement.getId()); |
| | | log.setCreateBy(SecurityUtils.getUsername()); |
| | | log.setCreateTime(DateUtils.getNowDate()); |
| | | log.setOperation("修改应收账单,账单编号:" + receivableBillManagement.getSystemNo()); |
| | | receivableBillManagementLogMapper.insertReceivableBillManagementLog(log); |
| | | } |
| | | |
| | | return result; |
| | | } @Override |
| | | public int aging(ReceivableBillManagement receivableBillManagement) |
| | | { |
| | | receivableBillManagement.setUpdateTime(DateUtils.getNowDate()); |
| | | int result = receivableBillManagementMapper.updateReceivableBillManagement(receivableBillManagement); |
| | | |
| | | // 记录操作日志 |
| | | if (result > 0) { |
| | | AgingLog log = new AgingLog(); |
| | | log.setHeadId(receivableBillManagement.getId()); |
| | | log.setCreateBy(SecurityUtils.getUsername()); |
| | | log.setCreateTime(DateUtils.getNowDate()); |
| | | log.setOperation("编辑账龄分析信息"); |
| | | agingLogMapper.insertAgingLog(log); |
| | | } |
| | | |
| | | return result; |
| | | } |
| | | @Override |
| | | public int account(ReceivableBillManagement receivableBillManagement) |
| | | { |
| | | receivableBillManagement.setUpdateTime(DateUtils.getNowDate()); |
| | | int result = receivableBillManagementMapper.updateReceivableBillManagement(receivableBillManagement); |
| | | |
| | | // 记录操作日志 |
| | | if (result > 0) { |
| | | AccountLog log = new AccountLog(); |
| | | log.setHeadId(receivableBillManagement.getId()); |
| | | log.setCreateBy(SecurityUtils.getUsername()); |
| | | log.setCreateTime(DateUtils.getNowDate()); |
| | | log.setOperation("编辑账款分析信息"); |
| | | accountLogMapper.insertAccountLog(log); |
| | | } |
| | | |
| | | return result; |
| | | } |
| | | |
| | | /** |
| | |
| | | // 清除关联账单编号并将状态改为0(待生成账单) |
| | | receivableFeeManagementMapper.updateReceivableFeeManagementByRelatedBillNo(billSystemNo); |
| | | } |
| | | |
| | | // 记录作废操作日志 |
| | | ReceivableBillManagementLog log = new ReceivableBillManagementLog(); |
| | | log.setBillId(id); |
| | | log.setCreateBy(SecurityUtils.getUsername()); |
| | | log.setCreateTime(DateUtils.getNowDate()); |
| | | log.setOperation("作废应收账单,账单编号:" + billManagement.getSystemNo()); |
| | | receivableBillManagementLogMapper.insertReceivableBillManagementLog(log); |
| | | } |
| | | |
| | | return result; |
| | | } |
| | | |
| | | /** |
| | | * 根据系统编号查询应收账单管理 |
| | | * |
| | | * @param systemNo 系统编号 |
| | | * @return 应收账单管理 |
| | | */ |
| | | @DataSource(DataSourceType.SLAVE) |
| | | @Override |
| | | public ReceivableBillManagement selectReceivableBillManagementBySystemNo(String systemNo) |
| | | { |
| | | return receivableBillManagementMapper.selectReceivableBillManagementBySystemNo(systemNo); |
| | | } |
| | | |
| | | /** |
| | | * 查询应收账单客户汇总列表 |
| | | * |
| | | * @param receivableBillManagement 查询条件 |
| | | * @return 应收账单客户汇总列表 |
| | | */ |
| | | @DataSource(DataSourceType.SLAVE) |
| | | @Override |
| | | public List<ReceivableBillCustomerSummary> selectReceivableBillCustomerSummaryList(ReceivableBillManagement receivableBillManagement) |
| | | { |
| | | return receivableBillManagementMapper.selectReceivableBillCustomerSummaryList(receivableBillManagement); |
| | | } |
| | | |
| | | /** |
| | | * 查询应收账单账龄分析列表 |
| | | * |
| | | * @param receivableBillManagement 查询条件 |
| | | * @return 应收账单账龄分析列表 |
| | | */ |
| | | @DataSource(DataSourceType.SLAVE) |
| | | @Override |
| | | public List<ReceivableBillAgingAnalysisVo> selectReceivableBillAgingAnalysisList(ReceivableBillManagement receivableBillManagement) |
| | | { |
| | | // 直接查询数据库中的预计算账龄数据 |
| | | List<ReceivableBillAgingAnalysisVo> result = receivableBillManagementMapper.selectReceivableBillAgingAnalysisList(receivableBillManagement); |
| | | |
| | | return result; |
| | | } |
| | | |
| | | /** |
| | | * 批量更新应收账单账龄分析数据 |
| | | * 直接在数据库层面计算账龄分段,避免查询大量数据到应用层 |
| | | * |
| | | * @return 更新的记录数 |
| | | */ |
| | | @Override |
| | | public int batchUpdateAgingAnalysisData() |
| | | { |
| | | return receivableBillManagementMapper.batchUpdateAgingAnalysisData(); |
| | | } |
| | | } |