Subversion Repositories SmartDukaan

    com.spice.profitmandi.dao.repository.transaction.EInvoiceDetailsRepository eInvoiceDetailsRepository;

    @Autowired

    com.spice.profitmandi.dao.repository.transaction.CreditNoteLineRepository creditNoteLineRepository;

    @Autowired

    @RequestMapping(value = "/credit-note/download-all", method = RequestMethod.GET)

    public ResponseEntity<?> downloadAllCreditNotes(HttpServletRequest request,

            @RequestParam("yearMonth") YearMonth yearMonth) throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        if (!roleManager.isAdmin(loginDetails.getRoleIds())) {

            return ResponseEntity.status(HttpStatus.FORBIDDEN).body("Admin access required");

        }

        List<CreditNote> creditNotes = creditNoteRepository.selectAllMarginsTypeByMonth(yearMonth);

        if (creditNotes.isEmpty()) {

            return ResponseEntity.noContent().build();

        }

        // Bulk-fetch IRN and line items

        List<String> cnNumbers = creditNotes.stream().map(CreditNote::getCreditNoteNumber).collect(Collectors.toList());

        Map<String, com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails> eiMap =

                eInvoiceDetailsRepository.selectByInvoiceNumbers(cnNumbers).stream()

                        .collect(Collectors.toMap(com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails::getInvoiceNumber, e -> e, (a, b) -> a));

        List<Integer> cnIds = creditNotes.stream().map(CreditNote::getId).collect(Collectors.toList());

        Map<Integer, List<com.spice.profitmandi.dao.entity.transaction.CreditNoteLine>> linesMap =

                creditNoteLineRepository.selectAllByCreditNoteIds(cnIds).stream()

                        .collect(Collectors.groupingBy(com.spice.profitmandi.dao.entity.transaction.CreditNoteLine::getCreditNoteId));

        // Build partner lookup

        Map<Integer, com.spice.profitmandi.common.model.CustomRetailer> retailers = retailerService.getAllFofoRetailers();

        List<List<?>> rows = new ArrayList<>();

        for (CreditNote cn : creditNotes) {

            com.spice.profitmandi.dao.entity.transaction.EInvoiceDetails ei = eiMap.get(cn.getCreditNoteNumber());

            List<com.spice.profitmandi.dao.entity.transaction.CreditNoteLine> lines =

                    linesMap.getOrDefault(cn.getId(), java.util.Collections.emptyList());

            float total = (float) lines.stream().mapToDouble(l -> l.getAmount()).sum();

            com.spice.profitmandi.common.model.CustomRetailer retailer = retailers.get(cn.getFofoId());

            String partnerName = retailer != null ? retailer.getBusinessName() : "";

            String partnerCode = retailer != null ? retailer.getCode() : "";

            rows.add(Arrays.asList(

                    cn.getCreditNoteNumber(),

                    cn.getFofoId(),

                    partnerCode,

                    partnerName,

                    com.spice.profitmandi.common.util.FormattingUtils.formatDDMMMyyyyFormatter(cn.getCnDate().toLocalDate()),

                    cn.getType(),

                    Math.round(total),

                    ei != null ? ei.getIrn() : "",

                    ei != null ? ei.getAcknowledgeNumber() : "",

                    ei != null && ei.getAcknowledgeDate() != null

                            ? com.spice.profitmandi.common.util.FormattingUtils.formatDDMMMyyyyFormatter(ei.getAcknowledgeDate().toLocalDate())

                            : ""

            ));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(

                Arrays.asList("CN Number", "FofoId", "Partner Code", "Partner Name", "CN Date", "CN Type",

                        "Total Amount", "IRN", "Ack Number", "IRN Ack Date"),

                rows);

        return orderService.downloadReportInCsv(baos, rows,

                "CN Summary Report - " + yearMonth.toString());

    }