Subversion Repositories SmartDukaan

    public void postCreditNoteForDuplicateInvoice(String duplicateInvoice, String activeInvoice) throws Exception {

        List<Order> orders = orderRepository.selectByInvoiceNumber(activeInvoice);

        if (orders.isEmpty()) throw new RuntimeException("No orders found for " + activeInvoice);

        Order firstOrder = orders.get(0);

        SellerWarehouse sellerWarehouse = sellerWarehouseRepository.selectByWarehouseIdAndSellerId(

                firstOrder.getWarehouseId(), firstOrder.getSellerId());

        sellerWarehouse.setCreditNoteSequence(sellerWarehouse.getCreditNoteSequence() + 1);

        String cnNumber = "CN-" + sellerWarehouse.getPrefix() + sellerWarehouse.getCreditNoteSequence();

        InvoicePdfModel invoicePdfModel = invoiceService.getInvoicePdfModelForIrn(orders);

        String billingDateStr = com.spice.profitmandi.common.util.StringUtils.toString(firstOrder.getBillingTimestamp().toLocalDate());

        List<String[]> invoiceRefs = java.util.Collections.singletonList(

                new String[]{duplicateInvoice, billingDateStr});

        String sellerGstin = "09AACCN9802G2ZC";

        String reason = "Credit Note against duplicate invoice " + duplicateInvoice;

        com.spice.profitmandi.dao.entity.transaction.CreditNote creditNote = new com.spice.profitmandi.dao.entity.transaction.CreditNote();

        creditNote.setCreditNoteNumber(cnNumber);

        creditNote.setFofoId(firstOrder.getRetailerId());

        creditNote.setCnDate(java.time.LocalDate.now().atTime(com.spice.profitmandi.common.util.Utils.MAX_TIME));

        creditNote.setType(com.spice.profitmandi.dao.entity.transaction.CreditNoteType.RETURNS);

        creditNote.setOriginalInvoiceNumber(duplicateInvoice);

        creditNote.setCreateTimestamp(java.time.LocalDateTime.now());

        creditNoteRepository.persist(creditNote);

        for (Order order : orders) {

            com.spice.profitmandi.dao.entity.transaction.CreditNoteLine cnLine = new com.spice.profitmandi.dao.entity.transaction.CreditNoteLine();

            cnLine.setCreditNoteId(creditNote.getId());

            cnLine.setDescription(order.getLineItem().getItem().getItemDescription());

            cnLine.setQuantity(order.getLineItem().getQuantity());

            cnLine.setUnitPrice(order.getLineItem().getUnitPrice());

            cnLine.setAmount(order.getLineItem().getUnitPrice() * order.getLineItem().getQuantity());

            cnLine.setCgst(order.getLineItem().getCgstRate());

            cnLine.setSgst(order.getLineItem().getSgstRate());

            cnLine.setIgst(order.getLineItem().getIgstRate());

            cnLine.setHsnCode(order.getLineItem().getHsnCode());

            creditNoteLineRepository.persist(cnLine);

        }

        LOGGER.info("Credit Note {} created against duplicate invoice {}", cnNumber, duplicateInvoice);

        gstProService.generateCreditNoteIrn(cnNumber, java.time.LocalDate.now(), invoicePdfModel, invoiceRefs, sellerGstin, reason);

        LOGGER.info("Credit Note IRN posted to NIC: CN={} against {}", cnNumber, duplicateInvoice);

    }