Subversion Repositories SmartDukaan

Rev

Rev 36116 | Rev 36120 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
21686 ashik.ali 1
package com.spice.profitmandi.common.util;
2
 
29930 amit.gupta 3
import com.ibm.icu.text.RuleBasedNumberFormat;
4
import com.itextpdf.text.*;
5
import com.itextpdf.text.Font.FontFamily;
6
import com.itextpdf.text.pdf.*;
35024 amit 7
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
29930 amit.gupta 8
import com.spice.profitmandi.common.model.*;
9
import org.apache.logging.log4j.LogManager;
10
import org.apache.logging.log4j.Logger;
11
import org.springframework.util.StringUtils;
12
 
24506 amit.gupta 13
import java.io.ByteArrayInputStream;
14
import java.io.ByteArrayOutputStream;
15
import java.io.IOException;
21686 ashik.ali 16
import java.io.OutputStream;
24506 amit.gupta 17
import java.net.URL;
24854 amit.gupta 18
import java.util.ArrayList;
23001 amit.gupta 19
import java.util.List;
21915 ashik.ali 20
import java.util.Locale;
21686 ashik.ali 21
 
22
public class PdfUtils {
23509 amit.gupta 23
 
32275 tejbeer 24
    private static final Font FONT_TITLE = new Font(Font.FontFamily.HELVETICA, 18, Font.BOLD);
25
    private static Font FONT_NORMAL = new Font(Font.FontFamily.TIMES_ROMAN, 10, Font.NORMAL);
26
    private static Font FONT_BOLD = new Font(Font.FontFamily.TIMES_ROMAN, 10, Font.BOLD);
35799 amit 27
    private static Font FONT_MARGIN_HEADER = new Font(Font.FontFamily.HELVETICA, 9, Font.BOLDITALIC);
32275 tejbeer 28
    public static final String INVOICE_TITLE = "TAX INVOICE";
29
    public static final String DEBIT_NOTE_TITLE = "DEBIT NOTE";
30
    public static final String SECURITY_DEPOSIT = "SECURITY DEPOSIT RECEIPT";
23509 amit.gupta 31
 
32275 tejbeer 32
    private static float[] igstWidthsWithDiscount = new float[]{.2f, 2.6f, 0.7f, .4f, 0.7f, 0.6f, .7f, .6f, 0.7f};
33
    private static float[] stateWidthsWithDiscount = new float[]{.2f, 2.1f, 0.7f, .3f, 0.6f, 0.5f, .7f, .6f, .6f, .7f};
23509 amit.gupta 34
 
35799 amit 35
    // Column widths without discount column (for Transaction.Order invoices)
36
    private static float[] igstWidthsNoDiscount = new float[]{.2f, 2.8f, 0.7f, .4f, 0.8f, .7f, .6f, 0.8f};
37
    private static float[] stateWidthsNoDiscount = new float[]{.2f, 2.3f, 0.7f, .4f, 0.7f, .7f, .6f, .6f, .8f};
38
 
32275 tejbeer 39
    private static float[] igstWidths = new float[]{.6f, 2.6f, 0.7f, .4f, 0.7f, .7f, .6f, 0.6f, 0.9f};
40
    private static float[] stateWidths = new float[]{.6f, 2.1f, 0.7f, .3f, 0.6f, .7f, .5f, .6f, .5f, .6f, .8f};
23533 amit.gupta 41
 
32275 tejbeer 42
    private static float[] igstWidthsCrNote = new float[]{2.6f, 0.7f, .4f, 0.7f, .7f, .6f, 0.6f, 0.9f};
43
    private static float[] stateWidthsCrNote = new float[]{2.1f, 0.7f, .3f, 0.6f, .7f, .5f, .6f, .5f, .6f, .8f};
23654 amit.gupta 44
 
32275 tejbeer 45
    private static final Locale indianLocale = Locale.getDefault();
23509 amit.gupta 46
 
32275 tejbeer 47
    private static final Logger LOGGER = LogManager.getLogger(PdfUtils.class);
23509 amit.gupta 48
 
32275 tejbeer 49
    private static final URL iconUrl = PdfUtils.class.getClassLoader().getResource("sdlogo.png");
50
    private static Image iconImg = null;
30400 amit.gupta 51
 
32275 tejbeer 52
    static {
53
        try {
54
            iconImg = Image.getInstance(iconUrl);
55
        } catch (Exception e) {
56
            e.printStackTrace();
57
        }
58
    }
30400 amit.gupta 59
 
32275 tejbeer 60
    //Debit Note generation logic has been changed
61
    //Debit Note considers price drops so amount in debit note is current price of item.
62
    //From 16Nov 2019 onwards all debit notes will be as per actuall billing value, all pricedrops
63
    //shall be rolledback or cancelled once the debit note is generated.
25463 amit.gupta 64
 
35035 amit 65
    public static void generateAndWrite(List<InvoicePdfModel> pdfModels, PrinterType printerType, ByteArrayOutputStream outputStream) throws ProfitMandiBusinessException {
35024 amit 66
        if (PrinterType.A4.equals(printerType)) {
67
            generateAndWrite(pdfModels, outputStream);
68
        } else {
69
            if (pdfModels.size() > 1) {
70
            }
71
            if (PrinterType.W80.equals(printerType)) {
72
                InvoiceFormatter.getInvoice(pdfModels.get(0), outputStream, InvoiceFormatter.WIDTH_80MM);
73
            } else if (PrinterType.W58.equals(printerType)) {
74
                InvoiceFormatter.getInvoice(pdfModels.get(0), outputStream, InvoiceFormatter.WIDTH_58MM);
30400 amit.gupta 75
 
35024 amit 76
            }
77
        }
35035 amit 78
    }
35024 amit 79
 
80
 
81
    //Standard
32275 tejbeer 82
    public static void generateAndWrite(List<InvoicePdfModel> pdfModels, ByteArrayOutputStream outputStream) {
83
        try {
32991 amit.gupta 84
            boolean cancelledPages = false;
32275 tejbeer 85
            List<Integer> caneclledPageList = new ArrayList<>();
86
            Document document = new Document();
87
            document.setMargins(0, 0, 25, 0);
33741 amit.gupta 88
            PdfWriter pdfWriter = PdfWriter.getInstance(document, outputStream);
32275 tejbeer 89
            document.open();
90
            for (InvoicePdfModel pdfModel : pdfModels) {
91
                CustomCustomer customer = pdfModel.getCustomer();
92
                CustomRetailer retailer = pdfModel.getRetailer();
93
                boolean stateGst = false;
94
                if (customer.getAddress().getState().equals(retailer.getAddress().getState())) {
95
                    stateGst = true;
96
                }
33298 amit.gupta 97
                List<CustomOrderItem> orderItems = pdfModel.getOrderItems();
32275 tejbeer 98
                if (pdfModel.isCancelled()) {
99
                    caneclledPageList.add(1);
32991 amit.gupta 100
                    cancelledPages = true;
32275 tejbeer 101
                } else {
102
                    caneclledPageList.add(0);
103
                }
104
                document.addTitle(pdfModel.getTitle());
105
                document.addAuthor(pdfModel.getAuther());
22889 amit.gupta 106
 
36044 amit 107
                String titleText = pdfModel.getTitle() != null ? pdfModel.getTitle().toUpperCase() : INVOICE_TITLE;
108
                Paragraph paragraphTitle = new Paragraph(titleText, FONT_TITLE);
32275 tejbeer 109
                paragraphTitle.setAlignment(Element.ALIGN_CENTER);
21686 ashik.ali 110
 
32980 amit.gupta 111
                document.add(paragraphTitle);
112
 
113
                Rectangle rectangle = document.getPageSize();
114
 
115
                if (pdfModel.getIrnModel() != null) {
116
                    addIrnDetails(pdfModel.getIrnModel(), rectangle, document);
117
                }
118
 
119
 
120
                PdfPTable tableCustomerRetailer = new PdfPTable(2);
32275 tejbeer 121
                tableCustomerRetailer.setWidthPercentage(90);
122
                tableCustomerRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);
123
                PdfPCell columnCustomerInfo = new PdfPCell();
124
                columnCustomerInfo.addElement(new Paragraph("Customer Details", FONT_BOLD));
125
                columnCustomerInfo.addElement(new Paragraph(
126
                        StringUtils.capitalize(customer.getAddress().getName() + (customer.getAddress().getLastName() == null ? "" : " " + customer.getAddress().getLastName())), FONT_NORMAL));
32627 ranu 127
                if (customer.getAddress() != null) {
128
                    if ((customer.getAddress().getLine1() != null && !customer.getAddress().getLine1().trim().isEmpty()) || (customer.getAddress().getLine2() != null && !customer.getAddress().getLine2().trim().isEmpty())) {
129
                        columnCustomerInfo.addElement(new Paragraph(StringUtils.capitalize(customer.getAddress().getLine1()) + ", " + StringUtils.capitalize(customer.getAddress().getLine2()), FONT_NORMAL));
130
                    }
131
                    if ((customer.getAddress().getCity() != null && !customer.getAddress().getCity().trim().isEmpty()) || (customer.getAddress().getState() != null && !customer.getAddress().getState().trim().isEmpty())) {
132
                        columnCustomerInfo.addElement(new Paragraph(StringUtils.capitalize(customer.getAddress().getCity()) + ", " + StringUtils.capitalize(customer.getAddress().getState()) + "(" + pdfModel.getCustomerAddressStateCode() + ")" + "\n" + customer.getAddress().getPinCode(), FONT_NORMAL));
133
                    }
134
                }
135
 
32275 tejbeer 136
                columnCustomerInfo.addElement(new Paragraph("Mobile - " + customer.getAddress().getPhoneNumber(), FONT_NORMAL));
137
                if (customer.getGstNumber() != null && !customer.getGstNumber().isEmpty()) {
138
                    columnCustomerInfo.addElement(new Paragraph("GST Number - " + customer.getGstNumber(), FONT_NORMAL));
139
                }
140
                columnCustomerInfo.setBorder(Rectangle.NO_BORDER);
141
                PdfPCell columnRetailerInfo = new PdfPCell();
142
                columnRetailerInfo.addElement(new Paragraph(StringUtils.capitalize(retailer.getAddress().getName()), FONT_BOLD));
143
                columnRetailerInfo.addElement(new Paragraph(StringUtils.capitalize(retailer.getAddress().getLine1()) + ", " + StringUtils.capitalize(retailer.getAddress().getLine2()) + ", " + StringUtils.capitalize(retailer.getAddress().getCity()) + "-" + retailer.getAddress().getPinCode() + ", " + retailer.getAddress().getState() + "(" + (stateGst ? pdfModel.getCustomerAddressStateCode() : pdfModel.getPartnerAddressStateCode()) + ")", FONT_BOLD));
144
                columnRetailerInfo.addElement(new Paragraph("Contact No.- " + retailer.getAddress().getPhoneNumber(), FONT_BOLD));
145
                columnRetailerInfo.addElement(new Paragraph("GST NO. " + retailer.getGstNumber(), FONT_BOLD));
146
                columnRetailerInfo.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 147
 
32275 tejbeer 148
                PdfPTable tableInvoiceDateRetailer = new PdfPTable(1);
149
                tableInvoiceDateRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 150
 
32275 tejbeer 151
                PdfPTable tableInvoiceDate = new PdfPTable(2);
152
                tableInvoiceDate.getDefaultCell().setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 153
 
36037 amit 154
                String invoiceLabel = pdfModel.getTitle() != null && pdfModel.getTitle().toLowerCase().contains("challan") ? "DC No:" : "Invoice No:";
155
                PdfPCell invoiceNumberKey = new PdfPCell(new Paragraph(invoiceLabel, FONT_NORMAL));
32275 tejbeer 156
                invoiceNumberKey.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 157
 
32275 tejbeer 158
                PdfPCell invoiceNumberValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceNumber(), FONT_NORMAL));
159
                invoiceNumberValue.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 160
 
32275 tejbeer 161
                PdfPCell dateKey = new PdfPCell(new Paragraph("Date:", FONT_NORMAL));
162
                dateKey.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 163
 
32275 tejbeer 164
                PdfPCell dateValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceDate(), FONT_NORMAL));
165
                dateValue.setBorder(Rectangle.NO_BORDER);
166
                tableInvoiceDate.addCell(invoiceNumberKey);
167
                tableInvoiceDate.addCell(invoiceNumberValue);
168
                tableInvoiceDate.addCell(dateKey);
169
                tableInvoiceDate.addCell(dateValue);
170
                tableInvoiceDateRetailer.addCell(tableInvoiceDate);
171
                tableInvoiceDateRetailer.addCell(columnRetailerInfo);
23509 amit.gupta 172
 
32275 tejbeer 173
                tableCustomerRetailer.addCell(columnCustomerInfo);
174
                tableCustomerRetailer.addCell(tableInvoiceDateRetailer);
23509 amit.gupta 175
 
35799 amit 176
                boolean showDiscount = pdfModel.isShowDiscountColumn();
32275 tejbeer 177
                PdfPTable orders = null;
178
                if (stateGst) {
35799 amit 179
                    if (showDiscount) {
180
                        orders = new PdfPTable(stateWidthsWithDiscount.length);
181
                        orders.setWidths(stateWidthsWithDiscount);
182
                    } else {
183
                        orders = new PdfPTable(stateWidthsNoDiscount.length);
184
                        orders.setWidths(stateWidthsNoDiscount);
185
                    }
32275 tejbeer 186
                } else {
35799 amit 187
                    if (showDiscount) {
188
                        orders = new PdfPTable(igstWidthsWithDiscount.length);
189
                        orders.setWidths(igstWidthsWithDiscount);
190
                    } else {
191
                        orders = new PdfPTable(igstWidthsNoDiscount.length);
192
                        orders.setWidths(igstWidthsNoDiscount);
193
                    }
32275 tejbeer 194
                }
195
                orders.setWidthPercentage(90);
196
                orders.addCell(new Paragraph("Sl", FONT_BOLD));
197
                orders.addCell(new Paragraph("Description", FONT_BOLD));
198
                orders.addCell(new Paragraph("HSN", FONT_BOLD));
199
                orders.addCell(new Paragraph("Qty", FONT_BOLD));
200
                orders.addCell(new Paragraph("Rate\n(Per pc)", FONT_BOLD));
35799 amit 201
                if (showDiscount) {
202
                    orders.addCell(new Paragraph("Discount", FONT_BOLD));
203
                }
32275 tejbeer 204
                orders.addCell(new Paragraph("Total\nTaxable", FONT_BOLD));
205
                if (!stateGst) {
206
                    orders.addCell(new Paragraph("IGST", FONT_BOLD));
207
                } else {
208
                    orders.addCell(new Paragraph("CGST", FONT_BOLD));
209
                    orders.addCell(new Paragraph("SGST", FONT_BOLD));
210
                }
211
                orders.addCell(new Paragraph("Total", FONT_BOLD));
23509 amit.gupta 212
 
32275 tejbeer 213
                orders.setHeaderRows(1);
23509 amit.gupta 214
 
32275 tejbeer 215
                float igstTotalAmount = 0, cgstTotalAmount = 0, sgstTotalAmount = 0;
216
                int index = 1;
217
                for (CustomOrderItem orderItem : orderItems) {
218
                    orders.addCell(new Paragraph(String.valueOf(index++), FONT_NORMAL));
219
                    orders.addCell(new Paragraph(orderItem.getDescription(), FONT_NORMAL));
220
                    orders.addCell(new Paragraph(orderItem.getHsnCode(), FONT_NORMAL));
221
                    orders.addCell(new Paragraph(String.valueOf(orderItem.getQuantity()), FONT_NORMAL));
35799 amit 222
 
36109 amit 223
                    orders.addCell(new Paragraph(String.format("%.2f", orderItem.getRate()), FONT_NORMAL));
224
                    if (showDiscount) {
225
                        String discountText = orderItem.getDiscount() == 0 ? "-" : String.format("%.2f", orderItem.getDiscount());
226
                        orders.addCell(new Paragraph(discountText, FONT_NORMAL));
35799 amit 227
                    }
32275 tejbeer 228
                    orders.addCell(new Paragraph(String.format("%.2f", orderItem.getAmount()), FONT_NORMAL));
229
                    if (!stateGst) {
230
                        orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", orderItem.getIgstAmount(), orderItem.getIgstRate()), FONT_NORMAL));
231
                        igstTotalAmount = igstTotalAmount + orderItem.getIgstAmount();
232
                    } else {
233
                        orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", orderItem.getCgstAmount(), orderItem.getCgstRate()), FONT_NORMAL));
234
                        orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", orderItem.getSgstAmount(), orderItem.getSgstRate()), FONT_NORMAL));
235
                        cgstTotalAmount = cgstTotalAmount + orderItem.getCgstAmount();
236
                        sgstTotalAmount = sgstTotalAmount + orderItem.getSgstAmount();
237
                    }
238
                    orders.addCell(new Paragraph(String.format("%.0f", orderItem.getNetAmount()), FONT_NORMAL));
239
                }
240
                if (pdfModel.getInsurancePolicies() != null) {
241
                    for (CustomInsurancePolicy insurancePolicy : pdfModel.getInsurancePolicies()) {
242
                        orders.addCell(new Paragraph(String.valueOf(index++), FONT_NORMAL));
243
                        orders.addCell(new Paragraph(insurancePolicy.getDescription(), FONT_NORMAL));
244
                        orders.addCell(new Paragraph(insurancePolicy.getHsnCode(), FONT_NORMAL));
245
                        orders.addCell(new Paragraph("1", FONT_NORMAL));
246
                        orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getRate()), FONT_NORMAL));
35799 amit 247
                        if (showDiscount) {
248
                            orders.addCell(new Paragraph("-", FONT_NORMAL));
249
                        }
32275 tejbeer 250
                        orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getRate()), FONT_NORMAL));
251
                        if (!stateGst) {
252
                            orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", insurancePolicy.getIgstAmount(), insurancePolicy.getIgstRate()), FONT_NORMAL));
253
                            igstTotalAmount = igstTotalAmount + insurancePolicy.getIgstAmount();
254
                        } else {
255
                            orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", insurancePolicy.getCgstAmount(), insurancePolicy.getCgstRate()), FONT_NORMAL));
256
                            orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", insurancePolicy.getSgstAmount(), insurancePolicy.getSgstRate()), FONT_NORMAL));
257
                            cgstTotalAmount = cgstTotalAmount + insurancePolicy.getCgstAmount();
258
                            sgstTotalAmount = sgstTotalAmount + insurancePolicy.getSgstAmount();
259
                        }
260
                        orders.addCell(new Paragraph(String.format("%.0f", insurancePolicy.getNetAmount()), FONT_NORMAL));
261
                    }
262
                }
32980 amit.gupta 263
 
32275 tejbeer 264
                iconImg.setAbsolutePosition(25, rectangle.getHeight() - 100);
265
                iconImg.scalePercent(30);
30400 amit.gupta 266
 
32275 tejbeer 267
                document.add(iconImg);
268
                document.add(Chunk.NEWLINE);
269
                document.add(Chunk.NEWLINE);
270
                document.add(tableCustomerRetailer);
23509 amit.gupta 271
 
32275 tejbeer 272
                document.add(Chunk.NEWLINE);
273
                document.add(orders);
23509 amit.gupta 274
 
32275 tejbeer 275
                PdfPTable grandTotalTable = new PdfPTable(3);
276
                PdfPTable paymentsTable = new PdfPTable(2);
277
                paymentsTable.setWidthPercentage(95);
278
                paymentsTable.setWidths(new float[]{8f, 2f});
23509 amit.gupta 279
 
32275 tejbeer 280
                if (stateGst) {
281
                    grandTotalTable.setWidths(new float[]{6.6f, .6f, .8f});
282
                } else {
283
                    grandTotalTable.setWidths(new float[]{6.5f, .6f, .9f});
284
                }
285
                grandTotalTable.setWidthPercentage(90);
23654 amit.gupta 286
 
32275 tejbeer 287
                Paragraph grandTotalParagraph = new Paragraph("Grand total", FONT_BOLD);
288
                grandTotalParagraph.setIndentationRight(20);
289
                grandTotalTable.addCell(grandTotalParagraph);
290
                Paragraph rsParagraph = new Paragraph("Rs.", FONT_BOLD);
291
                grandTotalTable.addCell(rsParagraph);
292
                Paragraph amountParagraph = new Paragraph(String.format("%.2f", pdfModel.getTotalAmount()), FONT_BOLD);
293
                grandTotalTable.addCell(amountParagraph);
24845 amit.gupta 294
 
32275 tejbeer 295
                document.add(grandTotalTable);
24845 amit.gupta 296
 
32275 tejbeer 297
                PdfPTable amountInWordsTable = new PdfPTable(3);
298
                amountInWordsTable.setWidthPercentage(90);
299
                amountInWordsTable.addCell(new Paragraph("Amount in Words:", FONT_BOLD));
300
                if (!stateGst) {
301
                    amountInWordsTable.setWidths(new float[]{2, 5.1f, 0.9f});
302
                } else {
303
                    amountInWordsTable.setWidths(new float[]{2, 5.2f, 0.8f});
304
                }
23509 amit.gupta 305
 
32275 tejbeer 306
                String amountInWords = toAmountInWords(pdfModel.getTotalAmount());
307
                amountInWordsTable.addCell(new Paragraph(amountInWords.toString(), FONT_BOLD));
308
                amountInWordsTable.addCell(new Paragraph("E & O.E", FONT_NORMAL));
309
                document.add(amountInWordsTable);
23654 amit.gupta 310
 
32275 tejbeer 311
                if (pdfModel.getPaymentOptions() != null) {
312
                    PdfPTable paidAmountTable = new PdfPTable(2);
313
                    paidAmountTable.setWidthPercentage(90);
314
                    if (!stateGst) {
315
                        paidAmountTable.setWidths(new float[]{7.1f, 0.9f});
316
                    } else {
317
                        paidAmountTable.setWidths(new float[]{7.2f, 0.8f});
318
                    }
319
                    float totalPaidValue = 0;
320
                    for (CustomPaymentOption paymentOption : pdfModel.getPaymentOptions()) {
33795 ranu 321
                        LOGGER.info("paymentOption - {}", paymentOption);
322
                        if (!"CASH DISCOUNT".equals(paymentOption.getPaymentOption())) {
323
                            PdfPCell cell = new PdfPCell(
324
                                    new Paragraph(10, "Paid Through " + paymentOption.getPaymentOption(), FONT_BOLD));
325
                            cell.setHorizontalAlignment(Element.ALIGN_RIGHT);
326
                            cell.setPadding(5);
327
                            paidAmountTable.addCell(cell);
23654 amit.gupta 328
 
33795 ranu 329
                            PdfPCell cell1 = new PdfPCell(new Paragraph(10, FormattingUtils.formatDecimal(paymentOption.getAmount()), FONT_BOLD));
330
                            cell1.setPadding(5);
331
                            paidAmountTable.addCell(cell1);
332
                            totalPaidValue += paymentOption.getAmount();
333
                        }
32275 tejbeer 334
                    }
335
                    PdfPCell totalPaidCell = new PdfPCell(new Paragraph(10, "Total Paid", FONT_BOLD));
336
                    totalPaidCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
337
                    totalPaidCell.setPadding(5);
338
                    paidAmountTable.addCell(totalPaidCell);
23558 amit.gupta 339
 
32275 tejbeer 340
                    PdfPCell totalPaidValueCell = new PdfPCell(
341
                            new Paragraph(10, FormattingUtils.formatDecimal(totalPaidValue), FONT_BOLD));
342
                    totalPaidValueCell.setPadding(5);
343
                    paidAmountTable.addCell(totalPaidValueCell);
23509 amit.gupta 344
 
32275 tejbeer 345
                    document.add(paidAmountTable);
346
                }
36045 amit 347
                String docType = pdfModel.getTitle() != null && pdfModel.getTitle().toLowerCase().contains("challan") ? "Delivery Challan" : "Invoice";
348
                Paragraph autoGenerateParagraph = new Paragraph("Note - This is computer generated " + docType + ", no signature is required", FONT_NORMAL);
32980 amit.gupta 349
                autoGenerateParagraph.setAlignment(Element.ALIGN_CENTER);
350
                document.add(autoGenerateParagraph);
24845 amit.gupta 351
 
35024 amit 352
                if(pdfModel.getCreditTerms()!=null) {
35025 amit 353
                    Paragraph title = new Paragraph("Credit terms :-\n", FONT_BOLD);
35024 amit 354
                    title.setIndentationLeft(25);
355
                    title.setIndentationRight(25);
356
                    document.add(title);
357
 
358
                    StringBuffer termsBuffer = new StringBuffer();
359
                    int count = 0;
360
                    for (String creditTerm : pdfModel.getCreditTerms()) {
361
                        count++;
362
                        termsBuffer.append(count).append(". ").append(creditTerm).append(".\n");
363
                    }
364
 
35025 amit 365
                    Paragraph body = new Paragraph(termsBuffer.toString(), FONT_NORMAL);
35024 amit 366
                    body.setIndentationLeft(25);
367
                    body.setIndentationRight(25);
368
                    document.add(body);
369
 
370
                }
35799 amit 371
 
32275 tejbeer 372
                if (pdfModel.getTncs() != null) {
373
                    StringBuffer sb = new StringBuffer();
374
                    for (String tnc : pdfModel.getTncs()) {
375
                        sb.append(tnc).append("\n");
376
                    }
377
                    Paragraph warningParagraph = new Paragraph(sb.toString(), FONT_NORMAL);
378
                    warningParagraph.setIndentationLeft(40);
379
                    document.add(Chunk.NEWLINE);
380
                    document.add(warningParagraph);
381
                }
24845 amit.gupta 382
 
32275 tejbeer 383
                document.newPage();
35024 amit 384
                if (pdfModel.geteWayBillPdfModel() != null) {
33741 amit.gupta 385
 
386
                    EWayBillPDF.generateDocument(document, pdfWriter, pdfModel.geteWayBillPdfModel());
387
                }
32275 tejbeer 388
            }
389
            document.close(); // no need to close PDFwriter?
35024 amit 390
            if (cancelledPages) {
32991 amit.gupta 391
                stampCancelled(outputStream, caneclledPageList);
392
            }
23509 amit.gupta 393
 
32275 tejbeer 394
        } catch (DocumentException e) {
395
            LOGGER.error("Unable to write data to pdf file : ", e);
396
        } catch (Exception e) {
397
            // TODO Auto-generated catch block
398
            e.printStackTrace();
399
        }
24506 amit.gupta 400
 
32275 tejbeer 401
    }
23509 amit.gupta 402
 
32980 amit.gupta 403
    private static void addIrnDetails(IrnModel irnModel, Rectangle rectangle, Document document) throws IOException, DocumentException {
404
        PdfPTable taxTable = new PdfPTable(1);
405
        taxTable.setWidthPercentage(45);
406
        PdfPCell pdfCell = new PdfPCell();
407
        pdfCell.setBorder(Rectangle.NO_BORDER);
408
        Image img = Image.getInstance(irnModel.getQrCode().toURI().toURL());
409
        img.setAbsolutePosition(450f, rectangle.getHeight() - 140);
410
        document.add(img);
411
        Paragraph irnParagraph = new Paragraph("IRN No - " + irnModel.getIrnNumber(), FONT_NORMAL);
412
        irnParagraph.setAlignment(Element.ALIGN_LEFT);
413
        pdfCell.addElement(irnParagraph);
414
 
35024 amit 415
        Paragraph ackParagraph = new Paragraph("Ack No - " + irnModel.getAcknowledgeNumber(), FONT_NORMAL);
32980 amit.gupta 416
        ackParagraph.setAlignment(Element.ALIGN_LEFT);
417
        pdfCell.addElement(ackParagraph);
418
 
419
        Paragraph ackDateParagraph = new Paragraph("Ack Date - " + FormattingUtils.format(irnModel.getAcknowledgeDate()), FONT_NORMAL);
420
        ackDateParagraph.setAlignment(Element.ALIGN_LEFT);
421
        pdfCell.addElement(ackDateParagraph);
422
        taxTable.addCell(pdfCell);
423
        document.add(taxTable);
424
    }
425
 
35799 amit 426
    private static void addMarginSchemeSeparator(PdfPTable table, int numColumns) {
427
        PdfPCell separatorCell = new PdfPCell(new Paragraph("Items under Margin Scheme \u2013 Rule 32(5) of CGST Rules, 2017", FONT_MARGIN_HEADER));
428
        separatorCell.setColspan(numColumns);
429
        separatorCell.setBackgroundColor(new BaseColor(240, 240, 240));
430
        separatorCell.setPadding(5);
431
        separatorCell.setHorizontalAlignment(Element.ALIGN_CENTER);
432
        table.addCell(separatorCell);
433
    }
434
 
435
    private static void addMarginSchemeDeclaration(Document document, InvoicePdfModel pdfModel) throws DocumentException {
436
        if (pdfModel.getMarginSchemeDeclarations() != null && !pdfModel.getMarginSchemeDeclarations().isEmpty()) {
437
            document.add(Chunk.NEWLINE);
438
            Paragraph declarationTitle = new Paragraph("Margin Scheme Declaration:", FONT_BOLD);
439
            declarationTitle.setIndentationLeft(25);
440
            document.add(declarationTitle);
441
            for (String declaration : pdfModel.getMarginSchemeDeclarations()) {
442
                Paragraph declarationParagraph = new Paragraph("- " + declaration, FONT_NORMAL);
443
                declarationParagraph.setIndentationLeft(30);
444
                document.add(declarationParagraph);
445
            }
446
        }
447
    }
448
 
36116 amit 449
    // ── Margin Scheme Invoice Helpers ──────────────────────────────────────
450
    private static final BaseColor MS_BORDER   = new BaseColor(204, 204, 204);
451
    private static final BaseColor MS_HEADER_BG = new BaseColor(242, 242, 242);
452
    private static final BaseColor MS_TOTAL_BG  = new BaseColor(249, 249, 249);
453
    private static final BaseColor MS_SUMM_BG   = new BaseColor(242, 242, 242);
454
 
455
    private static final Font MS_TITLE      = new Font(Font.FontFamily.HELVETICA, 13, Font.BOLD);
456
    private static final Font MS_SUBTITLE   = new Font(Font.FontFamily.HELVETICA, 7.5f, Font.ITALIC, new BaseColor(51, 51, 51));
457
    private static final Font MS_SECTION    = new Font(Font.FontFamily.HELVETICA, 6.5f, Font.BOLD, new BaseColor(85, 85, 85));
458
    private static final Font MS_NORMAL     = new Font(Font.FontFamily.HELVETICA, 8, Font.NORMAL);
459
    private static final Font MS_BOLD       = new Font(Font.FontFamily.HELVETICA, 8, Font.BOLD);
460
    private static final Font MS_SMALL      = new Font(Font.FontFamily.HELVETICA, 7, Font.NORMAL, new BaseColor(68, 68, 68));
461
    private static final Font MS_SMALL_BOLD = new Font(Font.FontFamily.HELVETICA, 7, Font.BOLD);
462
    private static final Font MS_ITALIC     = new Font(Font.FontFamily.HELVETICA, 7.5f, Font.ITALIC);
463
    private static final Font MS_TBL_HDR    = new Font(Font.FontFamily.HELVETICA, 7, Font.BOLD);
464
 
465
    private static Paragraph msSpacer(float spacing) {
466
        Paragraph p = new Paragraph(" ");
467
        p.setSpacingAfter(spacing);
468
        p.setLeading(0f);
469
        return p;
470
    }
471
 
472
    private static Paragraph msRightPara(String text, Font font) {
473
        Paragraph p = new Paragraph(text, font);
474
        p.setAlignment(Element.ALIGN_RIGHT);
475
        return p;
476
    }
477
 
478
    private static void msAddHeader(PdfPTable table, String text, int align) {
479
        PdfPCell cell = new PdfPCell(new Phrase(text, MS_TBL_HDR));
480
        cell.setHorizontalAlignment(align);
481
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
482
        cell.setBackgroundColor(MS_HEADER_BG);
483
        cell.setBorderColor(MS_BORDER);
484
        cell.setPadding(4f);
485
        table.addCell(cell);
486
    }
487
 
488
    private static void msAddDataCell(PdfPTable table, String text, int align, boolean bold, boolean totalRow) {
489
        Font font = bold ? MS_BOLD : MS_NORMAL;
490
        PdfPCell cell = new PdfPCell();
491
        cell.setHorizontalAlignment(align);
492
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
493
        cell.setBorderColor(MS_BORDER);
494
        if (totalRow) cell.setBackgroundColor(MS_TOTAL_BG);
495
        cell.setPadding(4f);
496
        String[] lines = text.split("\n");
497
        for (String line : lines) {
498
            Paragraph p = new Paragraph(line, font);
499
            p.setAlignment(align);
500
            p.setLeading(11f);
501
            cell.addElement(p);
502
        }
503
        table.addCell(cell);
504
    }
505
 
506
    private static void msAddSummaryRow(PdfPTable table, String label, String value, boolean highlight) {
507
        Font lf = highlight ? MS_BOLD : MS_NORMAL;
508
        Font vf = highlight ? MS_BOLD : MS_NORMAL;
509
        BaseColor bg = highlight ? MS_SUMM_BG : BaseColor.WHITE;
510
        PdfPCell lc = new PdfPCell(new Phrase(label, lf));
511
        lc.setBorderColor(MS_BORDER);
512
        lc.setPadding(5f);
513
        lc.setBackgroundColor(bg);
514
        table.addCell(lc);
515
        PdfPCell vc = new PdfPCell(new Phrase(value, vf));
516
        vc.setHorizontalAlignment(Element.ALIGN_RIGHT);
517
        vc.setBorderColor(MS_BORDER);
518
        vc.setPadding(5f);
519
        vc.setBackgroundColor(bg);
520
        table.addCell(vc);
521
    }
522
 
36109 amit 523
    public static void generateMarginSchemeInvoice(List<InvoicePdfModel> pdfModels, ByteArrayOutputStream outputStream) {
36116 amit 524
        generateInvoiceV2(pdfModels, outputStream);
525
    }
526
 
527
    public static void generateInvoiceV2(List<InvoicePdfModel> pdfModels, ByteArrayOutputStream outputStream) {
36109 amit 528
        try {
529
            boolean cancelledPages = false;
530
            List<Integer> cancelledPageList = new ArrayList<>();
36116 amit 531
            Document document = new Document(PageSize.A4, 28, 28, 34, 34);
36109 amit 532
            PdfWriter pdfWriter = PdfWriter.getInstance(document, outputStream);
533
            document.open();
534
 
535
            for (InvoicePdfModel pdfModel : pdfModels) {
536
                CustomCustomer customer = pdfModel.getCustomer();
537
                CustomRetailer retailer = pdfModel.getRetailer();
538
                boolean stateGst = customer.getAddress().getState().equals(retailer.getAddress().getState());
36116 amit 539
                String stateCode = stateGst ? pdfModel.getCustomerAddressStateCode() : pdfModel.getPartnerAddressStateCode();
540
                List<CustomOrderItem> orderItems = pdfModel.getOrderItems();
541
                boolean isMargin = pdfModel.isHasMarginSchemeItems();
36109 amit 542
 
543
                if (pdfModel.isCancelled()) {
544
                    cancelledPageList.add(1);
545
                    cancelledPages = true;
546
                } else {
547
                    cancelledPageList.add(0);
548
                }
549
 
36116 amit 550
                // ── Header: Logo (left) + Title (center) + QR (right) ─────
551
                Rectangle rectangle = document.getPageSize();
552
                String titleText = pdfModel.getTitle() != null ? pdfModel.getTitle().toUpperCase() : "TAX INVOICE";
36109 amit 553
 
36116 amit 554
                PdfPTable headerBanner = new PdfPTable(3);
555
                headerBanner.setWidthPercentage(100);
556
                headerBanner.setWidths(new float[]{1.2f, 4f, 1.2f});
557
                headerBanner.setSpacingAfter(4f);
36109 amit 558
 
36116 amit 559
                // Left: Logo
560
                PdfPCell logoCell = new PdfPCell();
561
                logoCell.setBorder(Rectangle.NO_BORDER);
562
                logoCell.setPadding(4f);
563
                logoCell.setVerticalAlignment(Element.ALIGN_MIDDLE);
564
                Image logoImg = Image.getInstance(iconImg);
565
                logoImg.scalePercent(25);
566
                logoCell.addElement(logoImg);
567
                headerBanner.addCell(logoCell);
36111 amit 568
 
36116 amit 569
                // Center: Title + subtitle
570
                PdfPCell titleCell = new PdfPCell();
571
                titleCell.setBorder(Rectangle.NO_BORDER);
572
                titleCell.setVerticalAlignment(Element.ALIGN_MIDDLE);
573
                titleCell.setHorizontalAlignment(Element.ALIGN_CENTER);
574
                Paragraph title = new Paragraph(titleText, MS_TITLE);
575
                title.setAlignment(Element.ALIGN_CENTER);
576
                titleCell.addElement(title);
577
                if (isMargin) {
578
                    Paragraph subtitle = new Paragraph(
579
                            "(GST Payable on Margin Scheme Basis \u2014 ITC not admissible to buyer)", MS_SUBTITLE);
580
                    subtitle.setAlignment(Element.ALIGN_CENTER);
581
                    titleCell.addElement(subtitle);
582
                }
583
                headerBanner.addCell(titleCell);
36109 amit 584
 
36116 amit 585
                // Right: QR code (or empty)
586
                PdfPCell qrCell = new PdfPCell();
587
                qrCell.setBorder(Rectangle.NO_BORDER);
588
                qrCell.setVerticalAlignment(Element.ALIGN_MIDDLE);
589
                qrCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
590
                if (pdfModel.getIrnModel() != null && pdfModel.getIrnModel().getQrCode() != null) {
591
                    Image qrImg = Image.getInstance(pdfModel.getIrnModel().getQrCode().toURI().toURL());
592
                    qrImg.scaleAbsolute(80, 80);
593
                    qrCell.addElement(qrImg);
36109 amit 594
                }
36116 amit 595
                headerBanner.addCell(qrCell);
36109 amit 596
 
36116 amit 597
                document.add(headerBanner);
36109 amit 598
 
36116 amit 599
                // ── IRN Details (full width below header) ──────────────────
600
                if (pdfModel.getIrnModel() != null) {
601
                    PdfPTable irnTable = new PdfPTable(1);
602
                    irnTable.setWidthPercentage(100);
603
                    irnTable.setSpacingAfter(8f);
604
 
605
                    PdfPCell irnCell = new PdfPCell();
606
                    irnCell.setBorder(Rectangle.BOTTOM);
607
                    irnCell.setBorderColor(MS_BORDER);
608
                    irnCell.setPadding(3f);
609
                    irnCell.addElement(new Paragraph("IRN: " + pdfModel.getIrnModel().getIrnNumber(), MS_SMALL));
610
                    irnCell.addElement(new Paragraph("Ack No: " + pdfModel.getIrnModel().getAcknowledgeNumber(), MS_SMALL));
611
                    irnCell.addElement(new Paragraph("Ack Date: " + FormattingUtils.format(pdfModel.getIrnModel().getAcknowledgeDate()), MS_SMALL));
612
                    irnTable.addCell(irnCell);
613
 
614
                    document.add(irnTable);
36109 amit 615
                }
616
 
36116 amit 617
                // ── Supplier (left) + Invoice Details (right) ──────────────
618
                PdfPTable headerTable = new PdfPTable(2);
619
                headerTable.setWidthPercentage(100);
620
                headerTable.setWidths(new float[]{1f, 1f});
621
                headerTable.setSpacingAfter(8f);
36109 amit 622
 
36116 amit 623
                PdfPCell supplierCell = new PdfPCell();
624
                supplierCell.setBorder(Rectangle.NO_BORDER);
625
                supplierCell.setPadding(4f);
626
                supplierCell.setPaddingLeft(0f);
627
                supplierCell.addElement(new Paragraph("SUPPLIER DETAILS", MS_SECTION));
628
                supplierCell.addElement(msSpacer(2f));
629
                supplierCell.addElement(new Paragraph(StringUtils.capitalize(retailer.getAddress().getName()), MS_BOLD));
630
                supplierCell.addElement(new Paragraph(
631
                        StringUtils.capitalize(retailer.getAddress().getLine1()) + ", "
632
                        + StringUtils.capitalize(retailer.getAddress().getLine2()) + ", "
633
                        + StringUtils.capitalize(retailer.getAddress().getCity()) + " - "
634
                        + retailer.getAddress().getPinCode(), MS_NORMAL));
635
                supplierCell.addElement(new Paragraph("GSTIN: " + retailer.getGstNumber(), MS_NORMAL));
636
                supplierCell.addElement(new Paragraph("State: " + retailer.getAddress().getState()
637
                        + "  |  Code: " + stateCode, MS_NORMAL));
638
                headerTable.addCell(supplierCell);
36109 amit 639
 
36116 amit 640
                String invoiceLabel = (titleText.contains("CHALLAN")) ? "DC No:" : "Invoice No:";
641
                PdfPCell invoiceCell = new PdfPCell();
642
                invoiceCell.setBorder(Rectangle.NO_BORDER);
643
                invoiceCell.setPadding(4f);
644
                invoiceCell.setPaddingRight(0f);
645
                invoiceCell.addElement(msRightPara("INVOICE DETAILS", MS_SECTION));
646
                invoiceCell.addElement(msSpacer(2f));
647
                invoiceCell.addElement(msRightPara(invoiceLabel + " " + pdfModel.getInvoiceNumber(), MS_BOLD));
648
                invoiceCell.addElement(msRightPara("Date: " + pdfModel.getInvoiceDate(), MS_NORMAL));
649
                String supplyType = stateGst ? "Intra-state" : "Inter-state";
650
                invoiceCell.addElement(msRightPara("Place of supply: " + customer.getAddress().getState()
651
                        + " (" + pdfModel.getCustomerAddressStateCode() + ")", MS_NORMAL));
652
                invoiceCell.addElement(msRightPara("Supply type: " + supplyType, MS_NORMAL));
653
                headerTable.addCell(invoiceCell);
36109 amit 654
 
36116 amit 655
                document.add(headerTable);
36109 amit 656
 
36116 amit 657
                // ── Buyer Details ──────────────────────────────────────────
658
                PdfPTable buyerTable = new PdfPTable(1);
659
                buyerTable.setWidthPercentage(100);
660
                buyerTable.setSpacingAfter(8f);
36109 amit 661
 
36116 amit 662
                PdfPCell buyerCell = new PdfPCell();
663
                buyerCell.setBorder(Rectangle.BOX);
664
                buyerCell.setBorderColor(MS_BORDER);
665
                buyerCell.setPadding(5f);
666
                buyerCell.addElement(new Paragraph("BUYER DETAILS", MS_SECTION));
667
                buyerCell.addElement(msSpacer(2f));
668
                String buyerName = StringUtils.capitalize(customer.getAddress().getName()
669
                        + (customer.getAddress().getLastName() == null ? "" : " " + customer.getAddress().getLastName()));
670
                buyerCell.addElement(new Paragraph(buyerName, MS_BOLD));
671
                if (customer.getAddress().getLine1() != null || customer.getAddress().getLine2() != null) {
672
                    String addr = "";
673
                    if (customer.getAddress().getLine1() != null) addr += StringUtils.capitalize(customer.getAddress().getLine1());
674
                    if (customer.getAddress().getLine2() != null) addr += ", " + StringUtils.capitalize(customer.getAddress().getLine2());
675
                    buyerCell.addElement(new Paragraph(addr, MS_NORMAL));
676
                }
677
                String buyerLocation = StringUtils.capitalize(customer.getAddress().getCity()) + ", "
678
                        + customer.getAddress().getState() + " - " + customer.getAddress().getPinCode();
679
                buyerCell.addElement(new Paragraph(buyerLocation, MS_NORMAL));
680
                String buyerGstLine = "";
681
                if (customer.getGstNumber() != null && !customer.getGstNumber().isEmpty()) {
682
                    buyerGstLine += "GSTIN: " + customer.getGstNumber() + "  |  ";
683
                }
684
                buyerGstLine += "State: " + customer.getAddress().getState()
685
                        + " (Code: " + pdfModel.getCustomerAddressStateCode() + ")";
686
                buyerCell.addElement(new Paragraph(buyerGstLine, MS_NORMAL));
687
                if (customer.getAddress().getPhoneNumber() != null) {
688
                    buyerCell.addElement(new Paragraph("Mobile: " + customer.getAddress().getPhoneNumber(), MS_NORMAL));
689
                }
690
                buyerTable.addCell(buyerCell);
691
                document.add(buyerTable);
36109 amit 692
 
36116 amit 693
                // ── Item Table ─────────────────────────────────────────────
694
                PdfPTable itemTable;
695
                // 10 columns for both margin and regular
696
                itemTable = new PdfPTable(10);
697
                itemTable.setWidths(new float[]{0.8f, 1.0f, 3.8f, 1.2f, 0.7f, 2.0f, 2.0f, 2.4f, 1.6f, 1.6f});
698
                itemTable.setWidthPercentage(100);
699
                itemTable.setSpacingAfter(0f);
700
                itemTable.setHeaderRows(1);
36109 amit 701
 
36116 amit 702
                msAddHeader(itemTable, "S.No.",      Element.ALIGN_CENTER);
703
                msAddHeader(itemTable, "Order Id",   Element.ALIGN_CENTER);
704
                msAddHeader(itemTable, "Description of Goods", Element.ALIGN_LEFT);
705
                msAddHeader(itemTable, "HSN\nCode",  Element.ALIGN_CENTER);
706
                msAddHeader(itemTable, "Qty",        Element.ALIGN_CENTER);
36109 amit 707
 
36116 amit 708
                msAddHeader(itemTable, "Rate\n(Rs.)", Element.ALIGN_RIGHT);
709
                msAddHeader(itemTable, isMargin ? "Taxable Value\n- Margin (Rs.)" : "Taxable\nValue (Rs.)", Element.ALIGN_RIGHT);
710
                msAddHeader(itemTable, "Tax\nRate",             Element.ALIGN_CENTER);
711
                msAddHeader(itemTable, "Tax\n(Rs.)",         Element.ALIGN_RIGHT);
712
                msAddHeader(itemTable, "Total\n(Rs.)",       Element.ALIGN_RIGHT);
713
 
714
                float totalGrossSale = 0, totalTaxable = 0, totalTaxAmount = 0, totalNetAmount = 0;
715
                float totalCgst = 0, totalSgst = 0, totalIgst = 0;
36109 amit 716
                int index = 1;
717
                for (CustomOrderItem orderItem : orderItems) {
36111 amit 718
                    float taxAmount = orderItem.getCgstAmount() + orderItem.getSgstAmount() + orderItem.getIgstAmount();
36109 amit 719
 
36116 amit 720
                    msAddDataCell(itemTable, String.valueOf(index++),                    Element.ALIGN_CENTER, false, false);
721
                    msAddDataCell(itemTable, String.valueOf(orderItem.getOrderId()),     Element.ALIGN_CENTER, false, false);
722
                    msAddDataCell(itemTable, orderItem.getDescription(),                 Element.ALIGN_LEFT,   false, false);
723
                    msAddDataCell(itemTable, orderItem.getHsnCode(),                     Element.ALIGN_CENTER, false, false);
724
                    msAddDataCell(itemTable, String.valueOf(orderItem.getQuantity()),     Element.ALIGN_CENTER, false, false);
36109 amit 725
 
36116 amit 726
                    if (isMargin) {
36119 amit 727
                        float grossSaleTotal = orderItem.getNetAmount() - taxAmount;
728
                        float grossSalePerUnit = grossSaleTotal / orderItem.getQuantity();
729
                        msAddDataCell(itemTable, String.format("%.2f", grossSalePerUnit),        Element.ALIGN_RIGHT, false, false);
730
                        totalGrossSale += grossSaleTotal;
36116 amit 731
                    } else {
732
                        msAddDataCell(itemTable, String.format("%.2f", orderItem.getRate()),      Element.ALIGN_RIGHT, false, false);
733
                    }
734
                    totalNetAmount += orderItem.getNetAmount();
735
                    msAddDataCell(itemTable, String.format("%.2f", orderItem.getAmount()),        Element.ALIGN_RIGHT, false, false);
736
                    String rateText;
36111 amit 737
                    if (stateGst) {
36116 amit 738
                        rateText = String.format("CGST %.1f%%\n+ SGST %.1f%%", orderItem.getCgstRate(), orderItem.getSgstRate());
36111 amit 739
                    } else {
36116 amit 740
                        rateText = String.format("IGST %.1f%%", orderItem.getIgstRate());
36111 amit 741
                    }
36116 amit 742
                    msAddDataCell(itemTable, rateText,                                            Element.ALIGN_CENTER, false, false);
743
                    msAddDataCell(itemTable, String.format("%.2f", taxAmount), Element.ALIGN_RIGHT, false, false);
744
                    msAddDataCell(itemTable, String.format("%.0f", orderItem.getNetAmount()), Element.ALIGN_RIGHT, false, false);
36111 amit 745
 
36116 amit 746
                    totalTaxable += orderItem.getAmount();
36111 amit 747
                    totalTaxAmount += taxAmount;
36116 amit 748
                    totalCgst += orderItem.getCgstAmount();
749
                    totalSgst += orderItem.getSgstAmount();
750
                    totalIgst += orderItem.getIgstAmount();
36109 amit 751
                }
752
 
753
                // Total row
36116 amit 754
                int totalPcs = 0;
755
                for (CustomOrderItem oi : orderItems) totalPcs += oi.getQuantity();
756
                int totalColSpan = 5;
757
                PdfPCell totalSpan = new PdfPCell(new Phrase("Total " + totalPcs + " pc(s)", MS_BOLD));
758
                totalSpan.setColspan(totalColSpan);
759
                totalSpan.setHorizontalAlignment(Element.ALIGN_RIGHT);
760
                totalSpan.setBorderColor(MS_BORDER);
761
                totalSpan.setBackgroundColor(MS_TOTAL_BG);
762
                totalSpan.setPadding(4f);
763
                itemTable.addCell(totalSpan);
36109 amit 764
 
36116 amit 765
                msAddDataCell(itemTable, isMargin ? String.format("%.2f", totalGrossSale) : "", Element.ALIGN_RIGHT, true, true);
766
                msAddDataCell(itemTable, String.format("%.2f", totalTaxable),     Element.ALIGN_RIGHT, true, true);
767
                msAddDataCell(itemTable, "\u2014",                                Element.ALIGN_CENTER, false, true);
768
                msAddDataCell(itemTable, String.format("%.2f", totalTaxAmount), Element.ALIGN_RIGHT, true, true);
769
                msAddDataCell(itemTable, String.format("%.0f", totalNetAmount), Element.ALIGN_RIGHT, true, true);
36109 amit 770
 
36116 amit 771
                document.add(itemTable);
36109 amit 772
 
36116 amit 773
                // ── Bottom: Info (left) + Summary (right) + Amount in words ──
774
                float totalInvoiceValue = isMargin ? (totalGrossSale + totalTaxAmount) : totalNetAmount;
36109 amit 775
 
36116 amit 776
                PdfPTable bottomTable = new PdfPTable(2);
777
                bottomTable.setWidthPercentage(100);
778
                bottomTable.setWidths(new float[]{1.15f, 1f});
779
                bottomTable.setSpacingBefore(0f);
780
                bottomTable.setSpacingAfter(0f);
36111 amit 781
 
36116 amit 782
                // Left: Declaration (margin) or Tax Summary (regular)
783
                PdfPCell leftCell = new PdfPCell();
784
                leftCell.setBorder(Rectangle.BOX);
785
                leftCell.setBorderColor(MS_BORDER);
786
                leftCell.setPadding(6f);
787
                leftCell.setPaddingRight(8f);
36111 amit 788
 
36116 amit 789
                if (isMargin) {
790
                    leftCell.addElement(new Paragraph("Declaration", MS_SMALL_BOLD));
791
                    leftCell.addElement(msSpacer(3f));
792
                    leftCell.addElement(new Paragraph(
793
                            "GST is payable on margin scheme basis under Section 2(27) read with "
794
                            + "Rule 32(5) of CGST Rules, 2017.", MS_SMALL));
795
                    leftCell.addElement(msSpacer(4f));
796
                    leftCell.addElement(new Paragraph(
797
                            "The buyer is NOT eligible to claim Input Tax Credit on this invoice.", MS_SMALL_BOLD));
798
                }
799
                bottomTable.addCell(leftCell);
36111 amit 800
 
36116 amit 801
                // Right: Summary totals
802
                PdfPCell summaryCell = new PdfPCell();
803
                summaryCell.setBorder(Rectangle.BOX);
804
                summaryCell.setBorderColor(MS_BORDER);
805
                summaryCell.setPadding(0f);
806
                PdfPTable sumTable = new PdfPTable(2);
807
                sumTable.setWidthPercentage(100);
808
                sumTable.setWidths(new float[]{1.4f, 1f});
36111 amit 809
 
36116 amit 810
                if (isMargin) {
811
                    msAddSummaryRow(sumTable, "Total Selling Price", String.format("Rs. %.2f", totalGrossSale), false);
812
                    msAddSummaryRow(sumTable, "GST on Margin", String.format("Rs. %.2f", totalTaxAmount), false);
813
                } else {
814
                    msAddSummaryRow(sumTable, "Total Taxable Value", String.format("Rs. %.2f", totalTaxable), false);
815
                    msAddSummaryRow(sumTable, "Total GST", String.format("Rs. %.2f", totalTaxAmount), false);
816
                }
817
                msAddSummaryRow(sumTable, "Total Invoice Value", String.format("Rs. %.2f", totalInvoiceValue), true);
818
                summaryCell.addElement(sumTable);
819
                bottomTable.addCell(summaryCell);
36109 amit 820
 
36119 amit 821
                // Row 2: empty (left) + Amount in words (right) — no gap
36116 amit 822
                PdfPCell emptyLeft = new PdfPCell(new Phrase("", MS_NORMAL));
823
                emptyLeft.setBorder(Rectangle.NO_BORDER);
36119 amit 824
                emptyLeft.setPadding(0f);
825
                emptyLeft.setFixedHeight(0.1f);
36116 amit 826
                bottomTable.addCell(emptyLeft);
827
                PdfPCell wordsCell = new PdfPCell(new Phrase(toAmountInWords(totalInvoiceValue), MS_ITALIC));
828
                wordsCell.setBorder(Rectangle.BOX);
829
                wordsCell.setBorderColor(MS_BORDER);
36119 amit 830
                wordsCell.setPadding(4f);
36116 amit 831
                wordsCell.setBackgroundColor(MS_TOTAL_BG);
832
                bottomTable.addCell(wordsCell);
833
 
834
                document.add(bottomTable);
835
 
836
                // ── Payment Options ────────────────────────────────────────
36109 amit 837
                if (pdfModel.getPaymentOptions() != null) {
36116 amit 838
                    PdfPTable paidTable = new PdfPTable(2);
839
                    paidTable.setWidthPercentage(100);
840
                    paidTable.setWidths(new float[]{7f, 1f});
36109 amit 841
                    float totalPaidValue = 0;
36116 amit 842
                    for (CustomPaymentOption po : pdfModel.getPaymentOptions()) {
843
                        if (!"CASH DISCOUNT".equals(po.getPaymentOption())) {
844
                            PdfPCell lbl = new PdfPCell(new Phrase("Paid Through " + po.getPaymentOption(), MS_BOLD));
845
                            lbl.setHorizontalAlignment(Element.ALIGN_RIGHT);
846
                            lbl.setBorderColor(MS_BORDER);
847
                            lbl.setPadding(4f);
848
                            paidTable.addCell(lbl);
849
                            PdfPCell val = new PdfPCell(new Phrase(FormattingUtils.formatDecimal(po.getAmount()), MS_BOLD));
850
                            val.setHorizontalAlignment(Element.ALIGN_RIGHT);
851
                            val.setBorderColor(MS_BORDER);
852
                            val.setPadding(4f);
853
                            paidTable.addCell(val);
854
                            totalPaidValue += po.getAmount();
36109 amit 855
                        }
856
                    }
36116 amit 857
                    PdfPCell tpLbl = new PdfPCell(new Phrase("Total Paid", MS_BOLD));
858
                    tpLbl.setHorizontalAlignment(Element.ALIGN_RIGHT);
859
                    tpLbl.setBorderColor(MS_BORDER);
860
                    tpLbl.setPadding(4f);
861
                    paidTable.addCell(tpLbl);
862
                    PdfPCell tpVal = new PdfPCell(new Phrase(FormattingUtils.formatDecimal(totalPaidValue), MS_BOLD));
863
                    tpVal.setHorizontalAlignment(Element.ALIGN_RIGHT);
864
                    tpVal.setBorderColor(MS_BORDER);
865
                    tpVal.setPadding(4f);
866
                    paidTable.addCell(tpVal);
867
                    document.add(paidTable);
36109 amit 868
                }
869
 
36116 amit 870
                // ── Note + Credit Terms ────────────────────────────────────
871
                Paragraph note = new Paragraph("This is a computer-generated invoice and does not require a physical signature.", MS_SMALL);
872
                note.setAlignment(Element.ALIGN_CENTER);
873
                note.setSpacingBefore(8f);
874
                note.setSpacingAfter(4f);
875
                document.add(note);
36109 amit 876
 
877
                if (pdfModel.getCreditTerms() != null) {
36116 amit 878
                    Paragraph ctTitle = new Paragraph("Credit terms:", MS_SMALL_BOLD);
879
                    ctTitle.setIndentationLeft(25);
880
                    document.add(ctTitle);
36109 amit 881
                    int count = 0;
36116 amit 882
                    for (String ct : pdfModel.getCreditTerms()) {
36109 amit 883
                        count++;
36116 amit 884
                        Paragraph line = new Paragraph(count + ". " + ct + ".", MS_SMALL);
885
                        line.setIndentationLeft(25);
886
                        line.setIndentationRight(25);
887
                        document.add(line);
36109 amit 888
                    }
889
                }
890
 
891
                document.newPage();
892
 
36116 amit 893
                // ── E-Way Bill ─────────────────────────────────────────────
36109 amit 894
                if (pdfModel.geteWayBillPdfModel() != null) {
895
                    EWayBillPDF.generateDocument(document, pdfWriter, pdfModel.geteWayBillPdfModel());
896
                }
897
            }
898
 
899
            document.close();
900
            if (cancelledPages) {
901
                stampCancelled(outputStream, cancelledPageList);
902
            }
903
        } catch (DocumentException e) {
36116 amit 904
            LOGGER.error("Unable to write data to pdf file : ", e);
36109 amit 905
        } catch (Exception e) {
906
            e.printStackTrace();
907
        }
908
    }
909
 
32275 tejbeer 910
    private static void stampCancelled(ByteArrayOutputStream byteStream, List<Integer> cancelledPage) throws IOException, DocumentException {
911
        ByteArrayInputStream bais = new ByteArrayInputStream(byteStream.toByteArray());
912
        PdfReader pdfReader = new PdfReader(bais);
913
        int n = pdfReader.getNumberOfPages();
914
        ByteArrayOutputStream baos = new ByteArrayOutputStream();
915
        PdfStamper pdfStamper = new PdfStamper(pdfReader, baos);
916
        pdfStamper.setRotateContents(false);
917
        // text watermark
918
        Font f = new Font(FontFamily.HELVETICA, 30);
919
        Phrase p = new Phrase("My watermark (text)", f);
920
        URL cancelledImgUrl = PdfUtils.class.getClassLoader().getResource("cancelled.png");
921
        URL waterMarkImgUrl = PdfUtils.class.getClassLoader().getResource("sd1.jpg");
922
        Image imgCancelled = Image.getInstance(cancelledImgUrl);
923
        Image imgWatermark = Image.getInstance(waterMarkImgUrl);
924
        imgWatermark.scaleAbsolute(imgWatermark.getScaledWidth() * 2.5f, imgWatermark.getScaledHeight() * 2.5f);
925
        float w = imgCancelled.getScaledWidth() / 2;
926
        float h = imgCancelled.getScaledHeight() / 2;
927
        float wWaterMark = imgWatermark.getScaledWidth() / 2;
928
        float hWatermark = imgWatermark.getScaledHeight() / 2;
929
        // transparency
930
        PdfGState gs1 = new PdfGState();
32980 amit.gupta 931
        gs1.setFillOpacity(0.4f);
32275 tejbeer 932
        PdfGState gs2 = new PdfGState();
32980 amit.gupta 933
        gs2.setFillOpacity(0.05f);
32275 tejbeer 934
        // properties
935
        PdfContentByte over;
936
        Rectangle pagesize;
937
        float x, y;
24506 amit.gupta 938
 
32275 tejbeer 939
        // loop over every page
940
        for (int i = 1; i <= n; i++) {
941
            pagesize = pdfReader.getPageSize(i);
942
            x = (pagesize.getLeft() + pagesize.getRight()) / 2;
943
            y = (pagesize.getTop() + pagesize.getBottom()) / 2;
944
            over = pdfStamper.getOverContent(i);
945
            over.saveState();
946
            if (cancelledPage.get(i - 1) == 1) {
947
                over.setGState(gs1);
948
                over.addImage(imgCancelled, w, 0, 0, h, x - (w / 2), y - (h / 2));
949
                over.restoreState();
950
            } else {
951
                over.setGState(gs2);
952
                over.addImage(imgWatermark, wWaterMark, 0, 0, hWatermark, x - (wWaterMark / 2), y - (hWatermark / 2));
953
                over.restoreState();
954
            }
955
        }
956
        pdfStamper.close();
957
        pdfReader.close();
958
        baos.writeTo(byteStream);
24845 amit.gupta 959
 
32275 tejbeer 960
    }
24506 amit.gupta 961
 
32275 tejbeer 962
    public static void generateAndWriteDebitNote(List<DebitNotePdfModel> debitNotePdfModels, OutputStream outputStream) {
963
        Document document = new Document();
964
        document.setMargins(0, 0, 25, 0);
965
        try {
966
            for (DebitNotePdfModel debitNotePdfModel : debitNotePdfModels) {
23509 amit.gupta 967
 
32275 tejbeer 968
                InvoicePdfModel pdfModel = debitNotePdfModel.getPdfModel();
969
                CustomCustomer customer = pdfModel.getCustomer();
970
                CustomRetailer retailer = pdfModel.getRetailer();
971
                boolean stateGst = false;
32290 tejbeer 972
 
973
                LOGGER.info("Customer - {}", customer.getAddress().getState());
974
                LOGGER.info("retailer - {}", retailer.getAddress().getState());
975
 
976
 
32292 tejbeer 977
                if (customer.getAddress().getState().equals(retailer.getAddress().getState())) {
978
                    stateGst = true;
979
                }
33298 amit.gupta 980
                List<CustomOrderItem> orderItems = pdfModel.getOrderItems();
23509 amit.gupta 981
 
32275 tejbeer 982
                PdfWriter.getInstance(document, outputStream);
23509 amit.gupta 983
 
32275 tejbeer 984
                document.open();
985
                document.addTitle(pdfModel.getTitle());
986
                document.addAuthor(pdfModel.getAuther());
23509 amit.gupta 987
 
32275 tejbeer 988
                Paragraph paragraphTitle = new Paragraph(pdfModel.getTitle(), FONT_TITLE);
989
                paragraphTitle.setAlignment(Element.ALIGN_CENTER);
23509 amit.gupta 990
 
32275 tejbeer 991
                PdfPCell blankCell = new PdfPCell();
992
                blankCell.setBorder(Rectangle.NO_BORDER);
993
                PdfPTable tableCustomerRetailer = new PdfPTable(3);
994
                tableCustomerRetailer.setWidthPercentage(95);
995
                PdfPCell partnerInfo = new PdfPCell();
996
                partnerInfo.addElement(new Paragraph("From Party:", FONT_BOLD));
997
                partnerInfo.addElement(
998
                        new Paragraph(StringUtils.capitalize(customer.getAddress().getName()), FONT_NORMAL));
999
                partnerInfo.addElement(new Paragraph(
32289 tejbeer 1000
                        (customer.getAddress().getLine1() == null ? "" : StringUtils.capitalize(customer.getAddress().getLine1()) + ", ") + (customer.getAddress().getLine2() == null ? "" : StringUtils.capitalize(customer.getAddress().getLine2()) + ", ") + (customer.getAddress().getCity() == null ? "" : StringUtils.capitalize(customer.getAddress().getCity()) + " - ") + (customer.getAddress().getPinCode() == null ? "" : StringUtils.capitalize(customer.getAddress().getPinCode())), FONT_NORMAL));
23654 amit.gupta 1001
 
32275 tejbeer 1002
                partnerInfo.addElement(new Paragraph(
1003
                        StringUtils.capitalize(customer.getAddress().getState()) + "(" + pdfModel.getCustomerAddressStateCode() + ")", FONT_NORMAL));
1004
                partnerInfo.addElement(new Paragraph("Mobile - " + customer.getMobileNumber(), FONT_NORMAL));
1005
                if (customer.getGstNumber() != null && !customer.getGstNumber().isEmpty()) {
1006
                    partnerInfo.addElement(new Paragraph("GST No - " + customer.getGstNumber(), FONT_BOLD));
1007
                }
23533 amit.gupta 1008
 
32275 tejbeer 1009
                PdfPCell sellerParty = new PdfPCell();
1010
                sellerParty.addElement(new Paragraph("To Party:", FONT_BOLD));
1011
                sellerParty.addElement(
1012
                        new Paragraph(StringUtils.capitalize(retailer.getAddress().getName()), FONT_NORMAL));
32289 tejbeer 1013
                sellerParty.addElement(new Paragraph((retailer.getAddress().getLine1() == null ? "" : StringUtils.capitalize(retailer.getAddress().getLine1()) + ", ") + (retailer.getAddress().getLine2() == null ? "" : StringUtils.capitalize(retailer.getAddress().getLine2()) + ", ") + (retailer.getAddress().getCity() == null ? "" : StringUtils.capitalize(retailer.getAddress().getCity()) + "-") + (retailer.getAddress().getPinCode() == null ? "" : StringUtils.capitalize(retailer.getAddress().getPinCode())), FONT_NORMAL));
32275 tejbeer 1014
                sellerParty.addElement(new Paragraph(
1015
                        retailer.getAddress().getState() + "(" + pdfModel.getPartnerAddressStateCode() + ")", FONT_NORMAL));
1016
                sellerParty.addElement(new Paragraph("Mobile - " + retailer.getAddress().getPhoneNumber(), FONT_NORMAL));
1017
                sellerParty.addElement(new Paragraph("GST No - " + retailer.getGstNumber(), FONT_BOLD));
23509 amit.gupta 1018
 
32275 tejbeer 1019
                PdfPTable tableInvoiceDateRetailer = new PdfPTable(1);
1020
                tableInvoiceDateRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 1021
 
32275 tejbeer 1022
                PdfPTable tableInvoiceDate = new PdfPTable(2);
1023
                tableInvoiceDate.getDefaultCell().setBorder(Rectangle.NO_BORDER);
1024
                tableInvoiceDate.setWidthPercentage(90);
23509 amit.gupta 1025
 
32275 tejbeer 1026
                PdfPCell debitNoteDetails = new PdfPCell(new Paragraph("Debit Note Details", FONT_BOLD));
1027
                debitNoteDetails.setColspan(2);
1028
                debitNoteDetails.setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 1029
 
32275 tejbeer 1030
                PdfPCell debitNoteNumberKey = new PdfPCell(new Paragraph("Debit Note No:", FONT_NORMAL));
1031
                debitNoteNumberKey.setBorder(Rectangle.NO_BORDER);
1032
                PdfPCell debitNoteNumberValue = new PdfPCell(
1033
                        new Paragraph(debitNotePdfModel.getDebitNoteNumber(), FONT_NORMAL));
1034
                debitNoteNumberValue.setBorder(Rectangle.NO_BORDER);
23532 amit.gupta 1035
 
32275 tejbeer 1036
                PdfPCell debitNoteDateKey = new PdfPCell(new Paragraph("Debit Note Dt:", FONT_NORMAL));
1037
                debitNoteDateKey.setBorder(Rectangle.NO_BORDER);
23533 amit.gupta 1038
 
32275 tejbeer 1039
                PdfPCell debitNoteDateValue = new PdfPCell(
1040
                        new Paragraph(debitNotePdfModel.getDebitNoteDate(), FONT_NORMAL));
1041
                debitNoteDateValue.setBorder(Rectangle.NO_BORDER);
23532 amit.gupta 1042
 
32275 tejbeer 1043
                PdfPCell invoiceNumberKey = new PdfPCell(new Paragraph("Invoice Ref No:", FONT_NORMAL));
1044
                invoiceNumberKey.setBorder(Rectangle.NO_BORDER);
1045
                PdfPCell invoiceNumberValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceNumber(), FONT_NORMAL));
1046
                invoiceNumberValue.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 1047
 
32275 tejbeer 1048
                PdfPCell dateKey = new PdfPCell(new Paragraph("Invoice Dt:", FONT_NORMAL));
1049
                dateKey.setBorder(Rectangle.NO_BORDER);
1050
                PdfPCell dateValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceDate(), FONT_NORMAL));
1051
                dateValue.setBorder(Rectangle.NO_BORDER);
23533 amit.gupta 1052
 
32275 tejbeer 1053
                tableInvoiceDate.addCell(debitNoteDetails);
1054
                tableInvoiceDate.addCell(debitNoteNumberKey);
1055
                tableInvoiceDate.addCell(debitNoteNumberValue);
1056
                tableInvoiceDate.addCell(debitNoteDateKey);
1057
                tableInvoiceDate.addCell(debitNoteDateValue);
1058
                tableInvoiceDate.addCell(invoiceNumberKey);
1059
                tableInvoiceDate.addCell(invoiceNumberValue);
1060
                tableInvoiceDate.addCell(dateKey);
1061
                tableInvoiceDate.addCell(dateValue);
23509 amit.gupta 1062
 
32275 tejbeer 1063
                tableCustomerRetailer.addCell(partnerInfo);
1064
                tableCustomerRetailer.addCell(tableInvoiceDate);
1065
                tableCustomerRetailer.addCell(sellerParty);
23509 amit.gupta 1066
 
32275 tejbeer 1067
                PdfPTable orders = null;
1068
                if (stateGst) {
1069
                    orders = new PdfPTable(stateWidths.length);
1070
                    orders.setWidths(stateWidths);
1071
                } else {
1072
                    orders = new PdfPTable(igstWidths.length);
1073
                    orders.setWidths(igstWidths);
1074
                }
1075
                orders.setWidthPercentage(95);
1076
                orders.addCell(new Paragraph("Order Id", FONT_BOLD));
1077
                orders.addCell(new Paragraph("Description", FONT_BOLD));
1078
                orders.addCell(new Paragraph("HSN", FONT_BOLD));
1079
                orders.addCell(new Paragraph("Qty", FONT_BOLD));
1080
                orders.addCell(new Paragraph("Rate\n(Per pc)", FONT_BOLD));
1081
                orders.addCell(new Paragraph("Total\nTaxable", FONT_BOLD));
1082
                if (!stateGst) {
1083
                    orders.addCell(new Paragraph("IGST\n%", FONT_BOLD));
1084
                    orders.addCell(new Paragraph("IGST", FONT_BOLD));
1085
                } else {
1086
                    orders.addCell(new Paragraph("CGST %", FONT_BOLD));
1087
                    orders.addCell(new Paragraph("CGST", FONT_BOLD));
1088
                    orders.addCell(new Paragraph("SGST %", FONT_BOLD));
1089
                    orders.addCell(new Paragraph("SGST", FONT_BOLD));
1090
                }
1091
                orders.addCell(new Paragraph("Total", FONT_BOLD));
23509 amit.gupta 1092
 
32275 tejbeer 1093
                orders.setHeaderRows(1);
23509 amit.gupta 1094
 
32275 tejbeer 1095
                float igstTotalAmount = 0, cgstTotalAmount = 0, sgstTotalAmount = 0;
35799 amit 1096
                boolean marginSeparatorAdded = false;
32275 tejbeer 1097
                for (CustomOrderItem orderItem : orderItems) {
35799 amit 1098
                    if (orderItem.isMarginScheme() && !marginSeparatorAdded) {
1099
                        addMarginSchemeSeparator(orders, stateGst ? stateWidths.length : igstWidths.length);
1100
                        marginSeparatorAdded = true;
1101
                    }
1102
 
32275 tejbeer 1103
                    orders.addCell(new Paragraph(String.valueOf(orderItem.getOrderId()), FONT_NORMAL));
1104
                    orders.addCell(new Paragraph(orderItem.getDescription(), FONT_NORMAL));
1105
                    orders.addCell(new Paragraph(orderItem.getHsnCode(), FONT_NORMAL));
1106
                    orders.addCell(new Paragraph(String.valueOf(orderItem.getQuantity()), FONT_NORMAL));
1107
                    orders.addCell(new Paragraph(String.format("%.2f", orderItem.getRate()), FONT_NORMAL));
1108
                    orders.addCell(new Paragraph(String.format("%.2f", orderItem.getAmount()), FONT_NORMAL));
1109
                    if (!stateGst) {
1110
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstRate()), FONT_NORMAL));
1111
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstAmount()), FONT_NORMAL));
1112
                        igstTotalAmount = igstTotalAmount + orderItem.getIgstAmount();
1113
                    } else {
1114
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstRate()), FONT_NORMAL));
1115
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstAmount()), FONT_NORMAL));
1116
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstRate()), FONT_NORMAL));
1117
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstAmount()), FONT_NORMAL));
1118
                        cgstTotalAmount = cgstTotalAmount + orderItem.getCgstAmount();
1119
                        sgstTotalAmount = sgstTotalAmount + orderItem.getSgstAmount();
1120
                    }
1121
                    orders.addCell(new Paragraph(String.format("%.0f", orderItem.getNetAmount()), FONT_NORMAL));
1122
                    LOGGER.info("IN FOR LOOP");
1123
                }
23509 amit.gupta 1124
 
32275 tejbeer 1125
                document.add(paragraphTitle);
23533 amit.gupta 1126
 
32275 tejbeer 1127
                document.add(Chunk.NEWLINE);
1128
                document.add(tableCustomerRetailer);
23509 amit.gupta 1129
 
32275 tejbeer 1130
                document.add(Chunk.NEWLINE);
1131
                document.add(orders);
23509 amit.gupta 1132
 
32275 tejbeer 1133
                PdfPTable grandTotalTable = new PdfPTable(3);
1134
                if (stateGst) {
1135
                    grandTotalTable.setWidths(new float[]{6.6f, .6f, .8f});
1136
                } else {
1137
                    grandTotalTable.setWidths(new float[]{6.5f, .6f, .9f});
1138
                }
1139
                grandTotalTable.setWidthPercentage(95);
23509 amit.gupta 1140
 
32275 tejbeer 1141
                Paragraph grandTotalParagraph = new Paragraph("Grand total", FONT_BOLD);
1142
                grandTotalParagraph.setIndentationRight(20);
1143
                grandTotalTable.addCell(grandTotalParagraph);
1144
                Paragraph rsParagraph = new Paragraph("Rs.", FONT_BOLD);
1145
                grandTotalTable.addCell(rsParagraph);
1146
                Paragraph amountParagraph = new Paragraph(String.format("%.2f", pdfModel.getTotalAmount()), FONT_BOLD);
1147
                grandTotalTable.addCell(amountParagraph);
23509 amit.gupta 1148
 
32275 tejbeer 1149
                document.add(grandTotalTable);
23509 amit.gupta 1150
 
32275 tejbeer 1151
                PdfPTable amountInWordsTable = new PdfPTable(3);
1152
                if (!stateGst) {
1153
                    amountInWordsTable.setWidths(new float[]{2, 5.1f, 0.9f});
1154
                } else {
1155
                    amountInWordsTable.setWidths(new float[]{2, 5.2f, 0.8f});
1156
                }
1157
                amountInWordsTable.setWidthPercentage(95);
1158
                amountInWordsTable.addCell(new Paragraph("Amount in Words:", FONT_BOLD));
23509 amit.gupta 1159
 
32275 tejbeer 1160
                String amountInWords = toAmountInWords(pdfModel.getTotalAmount());
1161
                amountInWordsTable.addCell(new Paragraph(amountInWords.toString(), FONT_BOLD));
1162
                amountInWordsTable.addCell(new Paragraph("E & O.E", FONT_NORMAL));
1163
                document.add(amountInWordsTable);
23509 amit.gupta 1164
 
35799 amit 1165
                // Margin scheme declaration for debit notes
1166
                addMarginSchemeDeclaration(document, pdfModel);
1167
 
32275 tejbeer 1168
                document.newPage();
1169
            }
1170
            document.close(); // no need to close PDFwriter?
30539 amit.gupta 1171
 
32275 tejbeer 1172
        } catch (DocumentException e) {
1173
            LOGGER.error("Unable to write data to pdf file : ", e);
1174
        } catch (Exception e) {
1175
            // TODO Auto-generated catch block
1176
            e.printStackTrace();
1177
        }
1178
    }
23509 amit.gupta 1179
 
32275 tejbeer 1180
    private static String toAmountInWords(float amount) {
1181
        RuleBasedNumberFormat amountInWordsFormat = new RuleBasedNumberFormat(indianLocale, RuleBasedNumberFormat.SPELLOUT);
1182
        StringBuilder amountInWords = new StringBuilder("Rs. ");
1183
        amountInWords.append(StringUtils.capitalize(amountInWordsFormat.format((int) amount)));
1184
        amountInWords.append(" and ");
1185
        amountInWords.append(StringUtils.capitalize(amountInWordsFormat.format((int) (amount * 100) % 100)));
1186
        amountInWords.append(" paise");
1187
        return amountInWords.toString();
1188
    }
23654 amit.gupta 1189
 
32275 tejbeer 1190
    public static void generateAndWriteCustomerCreditNotes(List<CreditNotePdfModel> creditNotes, OutputStream outputStream) {
1191
        Document document = new Document();
1192
        document.setMargins(0, 0, 25, 0);
1193
        try {
1194
            PdfWriter.getInstance(document, outputStream);
24506 amit.gupta 1195
 
32275 tejbeer 1196
            document.open();
1197
            document.addTitle(creditNotes.get(0).getPdfModel().getTitle());
1198
            document.addAuthor(creditNotes.get(0).getPdfModel().getAuther());
1199
            for (CreditNotePdfModel creditNotePdfModel : creditNotes) {
1200
                InvoicePdfModel pdfModel = creditNotePdfModel.getPdfModel();
1201
                CustomCustomer customer = pdfModel.getCustomer();
1202
                CustomRetailer retailer = pdfModel.getRetailer();
1203
                boolean stateGst = false;
32290 tejbeer 1204
 
32275 tejbeer 1205
                if (customer.getAddress().getState().equals(retailer.getAddress().getState())) {
1206
                    stateGst = true;
1207
                }
33298 amit.gupta 1208
                List<CustomOrderItem> orderItems = pdfModel.getOrderItems();
23654 amit.gupta 1209
 
32275 tejbeer 1210
                Paragraph paragraphTitle = new Paragraph(pdfModel.getTitle(), FONT_TITLE);
1211
                paragraphTitle.setAlignment(Element.ALIGN_CENTER);
23654 amit.gupta 1212
 
32275 tejbeer 1213
                PdfPCell blankCell = new PdfPCell();
1214
                blankCell.setBorder(Rectangle.NO_BORDER);
1215
                PdfPTable tableCustomerRetailer = new PdfPTable(3);
1216
                tableCustomerRetailer.setWidthPercentage(95);
1217
                PdfPCell partnerInfo = new PdfPCell();
1218
                partnerInfo.addElement(new Paragraph("To Party:", FONT_BOLD));
1219
                partnerInfo.addElement(
1220
                        new Paragraph(StringUtils.capitalize(customer.getAddress().getName()), FONT_NORMAL));
1221
                partnerInfo.addElement(new Paragraph(
1222
                        StringUtils.capitalize(customer.getAddress().getLine1()) + ", " + (customer.getAddress().getLine2() == null ? "" : StringUtils.capitalize(customer.getAddress().getLine2())) + ", " + customer.getAddress().getCity() + " - " + customer.getAddress().getPinCode(), FONT_NORMAL));
23654 amit.gupta 1223
 
32275 tejbeer 1224
                partnerInfo.addElement(new Paragraph(
1225
                        StringUtils.capitalize(customer.getAddress().getState()) + "(" + pdfModel.getCustomerAddressStateCode() + ")", FONT_NORMAL));
1226
                partnerInfo.addElement(new Paragraph("Mobile - " + customer.getMobileNumber(), FONT_NORMAL));
1227
                if (customer.getGstNumber() != null && !customer.getGstNumber().isEmpty()) {
1228
                    partnerInfo.addElement(new Paragraph("GST No - " + customer.getGstNumber(), FONT_BOLD));
1229
                }
23654 amit.gupta 1230
 
32275 tejbeer 1231
                PdfPCell sellerParty = new PdfPCell();
1232
                sellerParty.addElement(new Paragraph("From Party:", FONT_BOLD));
1233
                sellerParty.addElement(
1234
                        new Paragraph(StringUtils.capitalize(retailer.getAddress().getName()), FONT_NORMAL));
1235
                sellerParty.addElement(new Paragraph((retailer.getAddress().getLine1() == null ? "" : StringUtils.capitalize(retailer.getAddress().getLine1()) + ", ") + (retailer.getAddress().getLine2() == null ? "" : StringUtils.capitalize(retailer.getAddress().getLine2()) + ", ") + StringUtils.capitalize(retailer.getAddress().getCity()) + "-" + retailer.getAddress().getPinCode() + ", ", FONT_NORMAL));
1236
                sellerParty.addElement(new Paragraph(
1237
                        retailer.getAddress().getState() + "(" + pdfModel.getPartnerAddressStateCode() + ")", FONT_NORMAL));
1238
                sellerParty.addElement(new Paragraph("Mobile - " + retailer.getAddress().getPhoneNumber(), FONT_NORMAL));
1239
                sellerParty.addElement(new Paragraph("GST No - " + retailer.getGstNumber(), FONT_BOLD));
23654 amit.gupta 1240
 
32275 tejbeer 1241
                PdfPTable tableInvoiceDateRetailer = new PdfPTable(1);
1242
                tableInvoiceDateRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 1243
 
32275 tejbeer 1244
                PdfPTable tableInvoiceDate = new PdfPTable(2);
1245
                tableInvoiceDate.getDefaultCell().setBorder(Rectangle.NO_BORDER);
1246
                tableInvoiceDate.setWidthPercentage(90);
23654 amit.gupta 1247
 
32275 tejbeer 1248
                PdfPCell debitNoteDetails = new PdfPCell(new Paragraph("Credit Note Details", FONT_BOLD));
1249
                debitNoteDetails.setColspan(2);
1250
                debitNoteDetails.setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 1251
 
32275 tejbeer 1252
                PdfPCell debitNoteNumberKey = new PdfPCell(new Paragraph("Credit Note No:", FONT_NORMAL));
1253
                debitNoteNumberKey.setBorder(Rectangle.NO_BORDER);
1254
                PdfPCell debitNoteNumberValue = new PdfPCell(
1255
                        new Paragraph(creditNotePdfModel.getCreditNoteNumber(), FONT_NORMAL));
1256
                debitNoteNumberValue.setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 1257
 
32275 tejbeer 1258
                PdfPCell debitNoteDateKey = new PdfPCell(new Paragraph("Credit Note Dt:", FONT_NORMAL));
1259
                debitNoteDateKey.setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 1260
 
32275 tejbeer 1261
                PdfPCell debitNoteDateValue = new PdfPCell(
1262
                        new Paragraph(creditNotePdfModel.getCreditNoteDate(), FONT_NORMAL));
1263
                debitNoteDateValue.setBorder(Rectangle.NO_BORDER);
1264
                tableInvoiceDate.addCell(debitNoteDetails);
1265
                tableInvoiceDate.addCell(debitNoteNumberKey);
1266
                tableInvoiceDate.addCell(debitNoteNumberValue);
1267
                tableInvoiceDate.addCell(debitNoteDateKey);
1268
                tableInvoiceDate.addCell(debitNoteDateValue);
32980 amit.gupta 1269
                if (pdfModel.getInvoiceNumber() != null) {
32275 tejbeer 1270
                    PdfPCell dateKey = new PdfPCell(new Paragraph("Invoice Dt:", FONT_NORMAL));
1271
                    dateKey.setBorder(Rectangle.NO_BORDER);
1272
                    PdfPCell dateValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceDate(), FONT_NORMAL));
1273
                    dateValue.setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 1274
 
32275 tejbeer 1275
                    PdfPCell invoiceNumberKey = new PdfPCell(new Paragraph("Invoice Ref No:", FONT_NORMAL));
1276
                    invoiceNumberKey.setBorder(Rectangle.NO_BORDER);
1277
                    PdfPCell invoiceNumberValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceNumber(), FONT_NORMAL));
1278
                    invoiceNumberValue.setBorder(Rectangle.NO_BORDER);
1279
                    tableInvoiceDate.addCell(invoiceNumberKey);
1280
                    tableInvoiceDate.addCell(invoiceNumberValue);
1281
                    tableInvoiceDate.addCell(dateKey);
1282
                    tableInvoiceDate.addCell(dateValue);
1283
                }
31008 amit.gupta 1284
 
32275 tejbeer 1285
                tableCustomerRetailer.addCell(partnerInfo);
1286
                tableCustomerRetailer.addCell(tableInvoiceDate);
1287
                tableCustomerRetailer.addCell(sellerParty);
23654 amit.gupta 1288
 
32275 tejbeer 1289
                PdfPTable orders = null;
1290
                if (stateGst) {
1291
                    orders = new PdfPTable(stateWidthsCrNote.length);
1292
                    orders.setWidths(stateWidthsCrNote);
1293
                } else {
1294
                    orders = new PdfPTable(igstWidthsCrNote.length);
1295
                    orders.setWidths(igstWidthsCrNote);
1296
                }
1297
                orders.setWidthPercentage(95);
1298
                orders.addCell(new Paragraph("Description", FONT_BOLD));
1299
                orders.addCell(new Paragraph("HSN", FONT_BOLD));
1300
                orders.addCell(new Paragraph("Qty", FONT_BOLD));
1301
                orders.addCell(new Paragraph("Rate\n(Per pc)", FONT_BOLD));
1302
                orders.addCell(new Paragraph("Total\nTaxable", FONT_BOLD));
1303
                if (!stateGst) {
1304
                    orders.addCell(new Paragraph("IGST%", FONT_BOLD));
1305
                    orders.addCell(new Paragraph("IGST", FONT_BOLD));
1306
                } else {
1307
                    orders.addCell(new Paragraph("CGST %", FONT_BOLD));
1308
                    orders.addCell(new Paragraph("CGST", FONT_BOLD));
1309
                    orders.addCell(new Paragraph("SGST %", FONT_BOLD));
1310
                    orders.addCell(new Paragraph("SGST", FONT_BOLD));
1311
                }
1312
                orders.addCell(new Paragraph("Total", FONT_BOLD));
23654 amit.gupta 1313
 
32275 tejbeer 1314
                orders.setHeaderRows(1);
23654 amit.gupta 1315
 
32275 tejbeer 1316
                float igstTotalAmount = 0, cgstTotalAmount = 0, sgstTotalAmount = 0;
35799 amit 1317
                boolean marginSeparatorAdded = false;
32275 tejbeer 1318
                for (CustomOrderItem orderItem : orderItems) {
35799 amit 1319
                    if (orderItem.isMarginScheme() && !marginSeparatorAdded) {
1320
                        addMarginSchemeSeparator(orders, stateGst ? stateWidthsCrNote.length : igstWidthsCrNote.length);
1321
                        marginSeparatorAdded = true;
1322
                    }
1323
 
32275 tejbeer 1324
                    LOGGER.info("Custom Order Item - {}", orderItem);
1325
                    orders.addCell(new Paragraph(orderItem.getDescription(), FONT_NORMAL));
1326
                    orders.addCell(new Paragraph(orderItem.getHsnCode(), FONT_NORMAL));
1327
                    orders.addCell(new Paragraph(String.valueOf(orderItem.getQuantity()), FONT_NORMAL));
1328
                    orders.addCell(new Paragraph(String.format("%.2f", orderItem.getRate()), FONT_NORMAL));
1329
                    orders.addCell(new Paragraph(String.format("%.2f", orderItem.getAmount()), FONT_NORMAL));
1330
                    if (!stateGst) {
1331
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstRate()), FONT_NORMAL));
1332
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstAmount()), FONT_NORMAL));
1333
                        igstTotalAmount = igstTotalAmount + orderItem.getIgstAmount();
1334
                    } else {
1335
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstRate()), FONT_NORMAL));
1336
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstAmount()), FONT_NORMAL));
1337
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstRate()), FONT_NORMAL));
1338
                        orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstAmount()), FONT_NORMAL));
1339
                        cgstTotalAmount = cgstTotalAmount + orderItem.getCgstAmount();
1340
                        sgstTotalAmount = sgstTotalAmount + orderItem.getSgstAmount();
1341
                    }
1342
                    orders.addCell(new Paragraph(String.format("%.0f", orderItem.getNetAmount()), FONT_NORMAL));
1343
                    LOGGER.info("IN FOR LOOP");
1344
                }
23654 amit.gupta 1345
 
32275 tejbeer 1346
                document.add(paragraphTitle);
23654 amit.gupta 1347
 
32275 tejbeer 1348
                document.add(Chunk.NEWLINE);
1349
                document.add(tableCustomerRetailer);
23654 amit.gupta 1350
 
32275 tejbeer 1351
                document.add(Chunk.NEWLINE);
1352
                document.add(orders);
23654 amit.gupta 1353
 
32275 tejbeer 1354
                PdfPTable grandTotalTable = new PdfPTable(3);
1355
                if (stateGst) {
1356
                    grandTotalTable.setWidths(new float[]{6.6f, .6f, .8f});
1357
                } else {
1358
                    grandTotalTable.setWidths(new float[]{6.5f, .6f, .9f});
1359
                }
1360
                grandTotalTable.setWidthPercentage(95);
23654 amit.gupta 1361
 
32275 tejbeer 1362
                Paragraph grandTotalParagraph = new Paragraph("Grand total", FONT_BOLD);
1363
                grandTotalParagraph.setIndentationRight(20);
1364
                grandTotalTable.addCell(grandTotalParagraph);
1365
                Paragraph rsParagraph = new Paragraph("Rs.", FONT_BOLD);
1366
                grandTotalTable.addCell(rsParagraph);
1367
                Paragraph amountParagraph = new Paragraph(String.format("%.2f", pdfModel.getTotalAmount()), FONT_BOLD);
1368
                grandTotalTable.addCell(amountParagraph);
23654 amit.gupta 1369
 
32275 tejbeer 1370
                document.add(grandTotalTable);
23654 amit.gupta 1371
 
32275 tejbeer 1372
                PdfPTable amountInWordsTable = new PdfPTable(3);
1373
                if (!stateGst) {
1374
                    amountInWordsTable.setWidths(new float[]{2, 5.1f, 0.9f});
1375
                } else {
1376
                    amountInWordsTable.setWidths(new float[]{2, 5.2f, 0.8f});
1377
                }
1378
                amountInWordsTable.setWidthPercentage(95);
1379
                amountInWordsTable.addCell(new Paragraph("Amount in Words:", FONT_BOLD));
23654 amit.gupta 1380
 
32275 tejbeer 1381
                String amountInWords = toAmountInWords(pdfModel.getTotalAmount());
1382
                amountInWordsTable.addCell(new Paragraph(amountInWords.toString(), FONT_BOLD));
1383
                amountInWordsTable.addCell(new Paragraph("E & O.E", FONT_NORMAL));
1384
                document.add(amountInWordsTable);
23654 amit.gupta 1385
 
35799 amit 1386
                // Margin scheme declaration for credit notes
1387
                addMarginSchemeDeclaration(document, pdfModel);
1388
 
32275 tejbeer 1389
                document.newPage();
1390
            }
1391
            document.close(); // no need to close PDFwriter?
1392
        } catch (DocumentException e) {
1393
            LOGGER.error("Unable to write data to pdf file : ", e);
1394
        } catch (Exception e) {
1395
            // TODO Auto-generated catch block
1396
            e.printStackTrace();
1397
        }
23654 amit.gupta 1398
 
32275 tejbeer 1399
    }
34805 ranu 1400
 
1401
    public static byte[] mergePdfFiles(List<byte[]> pdfFiles) throws IOException, DocumentException {
1402
        ByteArrayOutputStream mergedOutputStream = new ByteArrayOutputStream();
1403
        Document document = new Document();
1404
        PdfCopy copy = new PdfCopy(document, mergedOutputStream);
1405
        document.open();
1406
 
1407
        for (byte[] pdf : pdfFiles) {
1408
            PdfReader reader = new PdfReader(new ByteArrayInputStream(pdf));
1409
            int n = reader.getNumberOfPages();
1410
            for (int i = 1; i <= n; i++) {
1411
                copy.addPage(copy.getImportedPage(reader, i));
1412
            }
1413
            copy.freeReader(reader);
1414
            reader.close();
1415
        }
1416
 
1417
        document.close();
1418
        return mergedOutputStream.toByteArray();
1419
    }
1420
 
21686 ashik.ali 1421
}