| | |
| | | import com.ruoyi.framework.web.domain.AjaxResult; |
| | | import com.ruoyi.framework.web.domain.R; |
| | | import com.ruoyi.framework.web.page.TableDataInfo; |
| | | import com.ruoyi.production.dto.ProductOrderDto; |
| | | import com.ruoyi.sales.dto.InvoiceLedgerDto; |
| | | import com.ruoyi.sales.dto.SalesLedgerDto; |
| | | import com.ruoyi.sales.mapper.InvoiceLedgerMapper; |
| | |
| | | startPage(); |
| | | List<SalesLedger> list = salesLedgerService.selectSalesLedgerList(salesLedgerDto); |
| | | // 计算已开票金额/未开票金额(已填写发票金额为准) |
| | | if(CollectionUtils.isEmpty(list)){ |
| | | if (CollectionUtils.isEmpty(list)) { |
| | | return getDataTable(list); |
| | | } |
| | | List<Long> salesLedgerIds = list.stream().map(SalesLedger::getId).collect(Collectors.toList()); |
| | | List<InvoiceLedgerDto> invoiceLedgerDtoList = invoiceLedgerMapper.invoicedTotal(salesLedgerIds); |
| | | if(CollectionUtils.isEmpty(invoiceLedgerDtoList)){ |
| | | if (CollectionUtils.isEmpty(invoiceLedgerDtoList)) { |
| | | return getDataTable(list); |
| | | } |
| | | for (SalesLedger salesLedger : list) { |
| | |
| | | @Log(title = "销售台账", businessType = BusinessType.EXPORT) |
| | | @PostMapping("/export") |
| | | public void export(HttpServletResponse response, SalesLedgerDto salesLedgerDto) { |
| | | Page page = new Page(-1,-1); |
| | | Page page = new Page(-1, -1); |
| | | IPage<SalesLedger> salesLedgerIPage = listPage(page, salesLedgerDto); |
| | | ExcelUtil<SalesLedger> util = new ExcelUtil<SalesLedger>(SalesLedger.class); |
| | | if(salesLedgerIPage == null){ |
| | | if (salesLedgerIPage == null) { |
| | | util.exportExcel(response, new ArrayList<>(), "销售台账数据"); |
| | | return; |
| | | } |
| | |
| | | * 新增修改销售台账 |
| | | */ |
| | | @Log(title = "销售台账", businessType = BusinessType.INSERT) |
| | | @ApiOperation(value = "新增修改销售台账", notes = "新增修改销售台账") |
| | | @PostMapping("/addOrUpdateSalesLedger") |
| | | public AjaxResult add(@RequestBody SalesLedgerDto salesLedgerDto) { |
| | | return toAjax(salesLedgerService.addOrUpdateSalesLedger(salesLedgerDto)); |
| | |
| | | * 近半年开票,回款金额 |
| | | */ |
| | | @GetMapping("/getAmountHalfYear") |
| | | public AjaxResult getAmountHalfYear(@RequestParam(value = "type",defaultValue = "1") Integer type) { |
| | | public AjaxResult getAmountHalfYear(@RequestParam(value = "type", defaultValue = "1") Integer type) { |
| | | return AjaxResult.success(salesLedgerService.getAmountHalfYear(type)); |
| | | } |
| | | |
| | | /** |
| | | * 查询销售台账列表 |
| | | */ |
| | | @ApiOperation(value = "查询销售台账列表", notes = "查询销售台账列表") |
| | | @GetMapping("/listPage") |
| | | public IPage<SalesLedger> listPage(Page page, SalesLedgerDto salesLedgerDto) { |
| | | IPage<SalesLedger> iPage = salesLedgerService.selectSalesLedgerListPage(page, salesLedgerDto); |
| | |
| | | return iPage; |
| | | } |
| | | |
| | | for (SalesLedger record : iPage.getRecords()) { |
| | | Long salesLedgerId = record.getId(); |
| | | List<ProductOrderDto> productionOrdersBySalesLedgerId = salesLedgerService.getProductionOrdersBySalesLedgerId(salesLedgerId); |
| | | record.setProductionOrders(productionOrdersBySalesLedgerId); |
| | | } |
| | | |
| | | // 获取当前页所有台账记录的 ID 集合 |
| | | List<Long> salesLedgerIds = iPage.getRecords().stream().map(SalesLedger::getId).collect(Collectors.toList()); |
| | | |