Subversion Repositories SmartDukaan

Rev

Rev 30539 | Rev 32275 | 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.*;
7
import com.spice.profitmandi.common.model.*;
8
import org.apache.logging.log4j.LogManager;
9
import org.apache.logging.log4j.Logger;
10
import org.springframework.util.StringUtils;
11
 
24506 amit.gupta 12
import java.io.ByteArrayInputStream;
13
import java.io.ByteArrayOutputStream;
14
import java.io.IOException;
21686 ashik.ali 15
import java.io.OutputStream;
24506 amit.gupta 16
import java.net.URL;
24854 amit.gupta 17
import java.util.ArrayList;
23001 amit.gupta 18
import java.util.List;
21915 ashik.ali 19
import java.util.Locale;
21686 ashik.ali 20
import java.util.Set;
21
 
22
public class PdfUtils {
23509 amit.gupta 23
 
24
	private static final Font FONT_TITLE = new Font(Font.FontFamily.HELVETICA, 18, Font.BOLD);
21965 ashik.ali 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);
23509 amit.gupta 27
	// private static Font fontTableHeader = new
28
	// Font(Font.FontFamily.TIMES_ROMAN, 14, Font.BOLD);
24215 amit.gupta 29
	public static final String INVOICE_TITLE = "TAX INVOICE";
30
	public static final String DEBIT_NOTE_TITLE = "DEBIT NOTE";
31
	public static final String SECURITY_DEPOSIT = "SECURITY DEPOSIT RECEIPT";
23509 amit.gupta 32
 
30400 amit.gupta 33
	private static float[] igstWidthsWithDiscount = new float[]{.2f, 2.6f, 0.7f, .4f, 0.7f, 0.6f, .7f, .6f,
34
			0.7f};
35
	private static float[] stateWidthsWithDiscount = new float[]{.2f, 2.1f, 0.7f, .3f, 0.6f, 0.5f, .7f, .6f,
36
			.6f, .7f};
23509 amit.gupta 37
 
30400 amit.gupta 38
	private static float[] igstWidths = new float[]{.6f, 2.6f, 0.7f, .4f, 0.7f, .7f, .6f, 0.6f, 0.9f};
39
	private static float[] stateWidths = new float[]{.6f, 2.1f, 0.7f, .3f, 0.6f, .7f, .5f, .6f, .5f, .6f, .8f};
23533 amit.gupta 40
 
30400 amit.gupta 41
	private static float[] igstWidthsCrNote = new float[]{2.6f, 0.7f, .4f, 0.7f, .7f, .6f, 0.6f, 0.9f};
42
	private static float[] stateWidthsCrNote = new float[]{2.1f, 0.7f, .3f, 0.6f, .7f, .5f, .6f, .5f, .6f, .8f};
23654 amit.gupta 43
 
21915 ashik.ali 44
	private static final Locale indianLocale = Locale.getDefault();
23509 amit.gupta 45
 
23568 govind 46
	private static final Logger LOGGER = LogManager.getLogger(PdfUtils.class);
23509 amit.gupta 47
 
27247 amit.gupta 48
	private static final URL iconUrl = PdfUtils.class.getClassLoader().getResource("sdlogo.png");
25463 amit.gupta 49
	private static Image iconImg = null;
30400 amit.gupta 50
 
25463 amit.gupta 51
	static {
52
		try {
53
			iconImg = Image.getInstance(iconUrl);
54
		} catch (Exception e) {
55
			e.printStackTrace();
56
		}
57
	}
30400 amit.gupta 58
 
25840 amit.gupta 59
	//Debit Note generation logic has been changed
60
	//Debit Note considers price drops so amount in debit note is current price of item.
61
	//From 16Nov 2019 onwards all debit notes will be as per actuall billing value, all pricedrops
62
	//shall be rolledback or cancelled once the debit note is generated.
25463 amit.gupta 63
 
30400 amit.gupta 64
 
30321 amit.gupta 65
	public static void generateAndWrite(List<InvoicePdfModel> pdfModels, ByteArrayOutputStream outputStream) {
23509 amit.gupta 66
		try {
24854 amit.gupta 67
			List<Integer> caneclledPageList = new ArrayList<>();
24845 amit.gupta 68
			Document document = new Document();
69
			document.setMargins(0, 0, 25, 0);
24854 amit.gupta 70
			PdfWriter.getInstance(document, outputStream);
71
			document.open();
30321 amit.gupta 72
			for (InvoicePdfModel pdfModel : pdfModels) {
24845 amit.gupta 73
				CustomCustomer customer = pdfModel.getCustomer();
74
				CustomRetailer retailer = pdfModel.getRetailer();
75
				boolean stateGst = false;
76
				if (customer.getAddress().getState().equals(retailer.getAddress().getState())) {
77
					stateGst = true;
78
				}
79
				Set<CustomOrderItem> orderItems = pdfModel.getOrderItems();
80
				if (pdfModel.isCancelled()) {
24854 amit.gupta 81
					caneclledPageList.add(1);
24845 amit.gupta 82
				} else {
24854 amit.gupta 83
					caneclledPageList.add(0);
24845 amit.gupta 84
				}
85
				document.addTitle(pdfModel.getTitle());
86
				document.addAuthor(pdfModel.getAuther());
22889 amit.gupta 87
 
24845 amit.gupta 88
				Paragraph paragraphTitle = new Paragraph(INVOICE_TITLE, FONT_TITLE);
89
				paragraphTitle.setAlignment(Element.ALIGN_CENTER);
21686 ashik.ali 90
 
24845 amit.gupta 91
				PdfPCell blankCell = new PdfPCell();
92
				blankCell.setBorder(Rectangle.NO_BORDER);
93
				PdfPTable tableCustomerRetailer = new PdfPTable(3);
94
				tableCustomerRetailer.setWidthPercentage(90);
95
				tableCustomerRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);
96
				PdfPCell columnCustomerInfo = new PdfPCell();
97
				columnCustomerInfo.addElement(new Paragraph("Customer Details", FONT_BOLD));
98
				columnCustomerInfo.addElement(new Paragraph(
30400 amit.gupta 99
						StringUtils.capitalize(customer.getAddress().getName() +
100
								(customer.getAddress().getLastName() == null ? "" : " " + customer.getAddress().getLastName())),
26821 amit.gupta 101
						FONT_NORMAL));
24845 amit.gupta 102
				columnCustomerInfo.addElement(new Paragraph(StringUtils.capitalize(customer.getAddress().getLine1())
103
						+ ", " + StringUtils.capitalize(customer.getAddress().getLine2()), FONT_NORMAL));
25463 amit.gupta 104
				columnCustomerInfo.addElement(new Paragraph(StringUtils.capitalize(customer.getAddress().getCity())
105
						+ ", " + StringUtils.capitalize(customer.getAddress().getState()) + "("
106
						+ pdfModel.getCustomerAddressStateCode() + ")" + "\n" + customer.getAddress().getPinCode(),
24845 amit.gupta 107
						FONT_NORMAL));
26442 amit.gupta 108
				columnCustomerInfo.addElement(new Paragraph("Mobile - " + customer.getAddress().getPhoneNumber(), FONT_NORMAL));
24845 amit.gupta 109
				if (customer.getGstNumber() != null && !customer.getGstNumber().isEmpty()) {
110
					columnCustomerInfo
111
							.addElement(new Paragraph("GST Number - " + customer.getGstNumber(), FONT_NORMAL));
112
				}
113
				columnCustomerInfo.setBorder(Rectangle.NO_BORDER);
114
				PdfPCell columnRetailerInfo = new PdfPCell();
115
				columnRetailerInfo
116
						.addElement(new Paragraph(StringUtils.capitalize(retailer.getAddress().getName()), FONT_BOLD));
117
				columnRetailerInfo.addElement(new Paragraph(StringUtils.capitalize(retailer.getAddress().getLine1())
118
						+ ", " + StringUtils.capitalize(retailer.getAddress().getLine2()) + ", "
119
						+ StringUtils.capitalize(retailer.getAddress().getCity()) + "-"
120
						+ retailer.getAddress().getPinCode() + ", " + retailer.getAddress().getState() + "("
25463 amit.gupta 121
						+ (stateGst ? pdfModel.getCustomerAddressStateCode() : pdfModel.getPartnerAddressStateCode())
122
						+ ")", FONT_BOLD));
24845 amit.gupta 123
				columnRetailerInfo
124
						.addElement(new Paragraph("Contact No.- " + retailer.getAddress().getPhoneNumber(), FONT_BOLD));
125
				columnRetailerInfo.addElement(new Paragraph("GST NO. " + retailer.getGstNumber(), FONT_BOLD));
126
				columnRetailerInfo.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 127
 
24845 amit.gupta 128
				PdfPTable tableInvoiceDateRetailer = new PdfPTable(1);
129
				tableInvoiceDateRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 130
 
24845 amit.gupta 131
				PdfPTable tableInvoiceDate = new PdfPTable(2);
132
				tableInvoiceDate.getDefaultCell().setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 133
 
24845 amit.gupta 134
				PdfPCell invoiceNumberKey = new PdfPCell(new Paragraph("Invoice No:", FONT_NORMAL));
135
				invoiceNumberKey.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 136
 
24845 amit.gupta 137
				PdfPCell invoiceNumberValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceNumber(), FONT_NORMAL));
138
				invoiceNumberValue.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 139
 
24845 amit.gupta 140
				PdfPCell dateKey = new PdfPCell(new Paragraph("Date:", FONT_NORMAL));
141
				dateKey.setBorder(Rectangle.NO_BORDER);
23509 amit.gupta 142
 
24845 amit.gupta 143
				PdfPCell dateValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceDate(), FONT_NORMAL));
144
				dateValue.setBorder(Rectangle.NO_BORDER);
145
				tableInvoiceDate.addCell(invoiceNumberKey);
146
				// tableInvoiceDate.addCell(blankCell);
147
				tableInvoiceDate.addCell(invoiceNumberValue);
148
				tableInvoiceDate.addCell(dateKey);
149
				// tableInvoiceDate.addCell(blankCell);
150
				tableInvoiceDate.addCell(dateValue);
151
				tableInvoiceDateRetailer.addCell(tableInvoiceDate);
152
				tableInvoiceDateRetailer.addCell(columnRetailerInfo);
23509 amit.gupta 153
 
24845 amit.gupta 154
				tableCustomerRetailer.addCell(columnCustomerInfo);
155
				tableCustomerRetailer.addCell(blankCell);
156
				tableCustomerRetailer.addCell(tableInvoiceDateRetailer);
23509 amit.gupta 157
 
24845 amit.gupta 158
				PdfPTable orders = null;
159
				if (stateGst) {
160
					orders = new PdfPTable(stateWidthsWithDiscount.length);
161
					orders.setWidths(stateWidthsWithDiscount);
23509 amit.gupta 162
				} else {
24845 amit.gupta 163
					orders = new PdfPTable(igstWidthsWithDiscount.length);
164
					orders.setWidths(igstWidthsWithDiscount);
23509 amit.gupta 165
				}
24845 amit.gupta 166
				orders.setWidthPercentage(90);
167
				orders.addCell(new Paragraph("Sl", FONT_BOLD));
168
				orders.addCell(new Paragraph("Description", FONT_BOLD));
169
				orders.addCell(new Paragraph("HSN", FONT_BOLD));
170
				orders.addCell(new Paragraph("Qty", FONT_BOLD));
171
				orders.addCell(new Paragraph("Rate\n(Per pc)", FONT_BOLD));
28395 amit.gupta 172
				orders.addCell(new Paragraph("Discount", FONT_BOLD));
24845 amit.gupta 173
				orders.addCell(new Paragraph("Total\nTaxable", FONT_BOLD));
23509 amit.gupta 174
				if (!stateGst) {
24845 amit.gupta 175
					orders.addCell(new Paragraph("IGST", FONT_BOLD));
176
					// orders.setWidths(new float[]{1, 3, 1, 1, 1, 1, 1, 1});
177
					// total 8f
23509 amit.gupta 178
				} else {
24845 amit.gupta 179
					orders.addCell(new Paragraph("CGST", FONT_BOLD));
180
					orders.addCell(new Paragraph("SGST", FONT_BOLD));
181
					// orders.setWidths(new float[]{1, 3, 1, 1, 1, 1, 1, 1, 1, 1});
182
					// total 8f
23509 amit.gupta 183
				}
24845 amit.gupta 184
				orders.addCell(new Paragraph("Total", FONT_BOLD));
23509 amit.gupta 185
 
24845 amit.gupta 186
				// orders.addCell(new Paragraph("Item Total (Rs)", FONT_BOLD));
23509 amit.gupta 187
 
24845 amit.gupta 188
				orders.setHeaderRows(1);
189
				// orders.setSkipFirstHeader(true);
23509 amit.gupta 190
 
24845 amit.gupta 191
				float igstTotalAmount = 0, cgstTotalAmount = 0, sgstTotalAmount = 0;
192
				int index = 1;
193
				for (CustomOrderItem orderItem : orderItems) {
194
					orders.addCell(new Paragraph(String.valueOf(index++), FONT_NORMAL));
195
					orders.addCell(new Paragraph(orderItem.getDescription(), FONT_NORMAL));
196
					orders.addCell(new Paragraph(orderItem.getHsnCode(), FONT_NORMAL));
197
					orders.addCell(new Paragraph(String.valueOf(orderItem.getQuantity()), FONT_NORMAL));
198
					orders.addCell(new Paragraph(String.format("%.2f", orderItem.getRate()), FONT_NORMAL));
27250 amit.gupta 199
					orders.addCell(new Paragraph(String.format("%.2f", orderItem.getDiscount()), FONT_NORMAL));
24845 amit.gupta 200
					orders.addCell(new Paragraph(String.format("%.2f", orderItem.getAmount()), FONT_NORMAL));
201
					if (!stateGst) {
28395 amit.gupta 202
						orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", orderItem.getIgstAmount(), orderItem.getIgstRate()), FONT_NORMAL));
24845 amit.gupta 203
						igstTotalAmount = igstTotalAmount + orderItem.getIgstAmount();
204
					} else {
28395 amit.gupta 205
						orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", orderItem.getCgstAmount(), orderItem.getCgstRate()), FONT_NORMAL));
206
						orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", orderItem.getSgstAmount(), orderItem.getSgstRate()), FONT_NORMAL));
24845 amit.gupta 207
						cgstTotalAmount = cgstTotalAmount + orderItem.getCgstAmount();
208
						sgstTotalAmount = sgstTotalAmount + orderItem.getSgstAmount();
209
					}
210
					orders.addCell(new Paragraph(String.format("%.0f", orderItem.getNetAmount()), FONT_NORMAL));
211
					// orders.addCell(new Paragraph(String.format("%.2f",
212
					// orderItem.getItemTotal()), FONT_NORMAL));
213
				}
30400 amit.gupta 214
				if (pdfModel.getInsurancePolicies() != null) {
215
					for (CustomInsurancePolicy insurancePolicy : pdfModel.getInsurancePolicies()) {
216
						orders.addCell(new Paragraph(String.valueOf(index++), FONT_NORMAL));
217
						orders.addCell(new Paragraph(insurancePolicy.getDescription(), FONT_NORMAL));
218
						orders.addCell(new Paragraph(insurancePolicy.getHsnCode(), FONT_NORMAL));
219
						orders.addCell(new Paragraph("1", FONT_NORMAL));
220
						orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getRate()), FONT_NORMAL));
221
						orders.addCell(new Paragraph("-", FONT_NORMAL));
222
						orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getRate()), FONT_NORMAL));
223
						if (!stateGst) {
224
							orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", insurancePolicy.getIgstAmount(), insurancePolicy.getIgstRate()), FONT_NORMAL));
225
							igstTotalAmount = igstTotalAmount + insurancePolicy.getIgstAmount();
226
						} else {
227
							orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", insurancePolicy.getCgstAmount(), insurancePolicy.getCgstRate()), FONT_NORMAL));
228
							orders.addCell(new Paragraph(String.format("%.2f%n(@%.0f%%)", insurancePolicy.getSgstAmount(), insurancePolicy.getSgstRate()), FONT_NORMAL));
229
							cgstTotalAmount = cgstTotalAmount + insurancePolicy.getCgstAmount();
230
							sgstTotalAmount = sgstTotalAmount + insurancePolicy.getSgstAmount();
231
						}
232
						orders.addCell(new Paragraph(String.format("%.0f", insurancePolicy.getNetAmount()), FONT_NORMAL));
24845 amit.gupta 233
					}
234
				}
25467 amit.gupta 235
				Rectangle rectangle = document.getPageSize();
25477 amit.gupta 236
				iconImg.setAbsolutePosition(25, rectangle.getHeight() - 100);
25476 amit.gupta 237
				iconImg.scalePercent(30);
30400 amit.gupta 238
 
239
				if (pdfModel.getQrCode() != null) {
240
					Image img = Image.getInstance(pdfModel.getQrCode().toURI().toURL());
241
					img.setAbsolutePosition(450f, rectangle.getHeight() - 140);
242
					document.add(img);
243
				}
25463 amit.gupta 244
				document.add(iconImg);
24845 amit.gupta 245
				document.add(paragraphTitle);
246
				document.add(Chunk.NEWLINE);
247
				document.add(Chunk.NEWLINE);
248
				document.add(tableCustomerRetailer);
23509 amit.gupta 249
 
24845 amit.gupta 250
				document.add(Chunk.NEWLINE);
251
				document.add(orders);
23509 amit.gupta 252
 
24845 amit.gupta 253
				PdfPTable grandTotalTable = new PdfPTable(3);
254
				PdfPTable paymentsTable = new PdfPTable(2);
255
				paymentsTable.setWidthPercentage(95);
30400 amit.gupta 256
				paymentsTable.setWidths(new float[]{8f, 2f});
23509 amit.gupta 257
 
24845 amit.gupta 258
				if (stateGst) {
30400 amit.gupta 259
					grandTotalTable.setWidths(new float[]{6.6f, .6f, .8f});
24845 amit.gupta 260
				} else {
30400 amit.gupta 261
					grandTotalTable.setWidths(new float[]{6.5f, .6f, .9f});
24845 amit.gupta 262
				}
263
				grandTotalTable.setWidthPercentage(90);
23654 amit.gupta 264
 
24845 amit.gupta 265
				Paragraph grandTotalParagraph = new Paragraph("Grand total", FONT_BOLD);
266
				grandTotalParagraph.setIndentationRight(20);
267
				grandTotalTable.addCell(grandTotalParagraph);
268
				Paragraph rsParagraph = new Paragraph("Rs.", FONT_BOLD);
269
				grandTotalTable.addCell(rsParagraph);
270
				Paragraph amountParagraph = new Paragraph(String.format("%.2f", pdfModel.getTotalAmount()), FONT_BOLD);
271
				grandTotalTable.addCell(amountParagraph);
272
 
273
				document.add(grandTotalTable);
274
 
275
				PdfPTable amountInWordsTable = new PdfPTable(3);
276
				amountInWordsTable.setWidthPercentage(90);
277
				amountInWordsTable.addCell(new Paragraph("Amount in Words:", FONT_BOLD));
23558 amit.gupta 278
				if (!stateGst) {
30400 amit.gupta 279
					amountInWordsTable.setWidths(new float[]{2, 5.1f, 0.9f});
23558 amit.gupta 280
				} else {
30400 amit.gupta 281
					amountInWordsTable.setWidths(new float[]{2, 5.2f, 0.8f});
23558 amit.gupta 282
				}
23509 amit.gupta 283
 
24845 amit.gupta 284
				String amountInWords = toAmountInWords(pdfModel.getTotalAmount());
285
				amountInWordsTable.addCell(new Paragraph(amountInWords.toString(), FONT_BOLD));
286
				amountInWordsTable.addCell(new Paragraph("E & O.E", FONT_NORMAL));
287
				document.add(amountInWordsTable);
23654 amit.gupta 288
 
24845 amit.gupta 289
				if (pdfModel.getPaymentOptions() != null) {
290
					PdfPTable paidAmountTable = new PdfPTable(2);
291
					paidAmountTable.setWidthPercentage(90);
292
					if (!stateGst) {
30400 amit.gupta 293
						paidAmountTable.setWidths(new float[]{7.1f, 0.9f});
24845 amit.gupta 294
					} else {
30400 amit.gupta 295
						paidAmountTable.setWidths(new float[]{7.2f, 0.8f});
24845 amit.gupta 296
					}
297
					float totalPaidValue = 0;
298
					for (CustomPaymentOption paymentOption : pdfModel.getPaymentOptions()) {
299
						PdfPCell cell = new PdfPCell(
300
								new Paragraph(10, "Paid Through " + paymentOption.getPaymentOption(), FONT_BOLD));
301
						cell.setHorizontalAlignment(Element.ALIGN_RIGHT);
302
						cell.setPadding(5);
303
						paidAmountTable.addCell(cell);
23654 amit.gupta 304
 
24845 amit.gupta 305
						PdfPCell cell1 = new PdfPCell(new Paragraph(10,
29930 amit.gupta 306
								FormattingUtils.formatDecimal(paymentOption.getAmount()), FONT_BOLD));
24845 amit.gupta 307
						cell1.setPadding(5);
308
						paidAmountTable.addCell(cell1);
309
						totalPaidValue += paymentOption.getAmount();
23654 amit.gupta 310
 
24845 amit.gupta 311
					}
312
					PdfPCell totalPaidCell = new PdfPCell(new Paragraph(10, "Total Paid", FONT_BOLD));
313
					totalPaidCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
314
					totalPaidCell.setPadding(5);
315
					paidAmountTable.addCell(totalPaidCell);
23558 amit.gupta 316
 
24845 amit.gupta 317
					PdfPCell totalPaidValueCell = new PdfPCell(
29930 amit.gupta 318
							new Paragraph(10, FormattingUtils.formatDecimal(totalPaidValue), FONT_BOLD));
24845 amit.gupta 319
					totalPaidValueCell.setPadding(5);
320
					paidAmountTable.addCell(totalPaidValueCell);
23509 amit.gupta 321
 
24845 amit.gupta 322
					document.add(paidAmountTable);
323
				}
324
 
30400 amit.gupta 325
				if (pdfModel.getTncs() != null) {
326
					StringBuffer sb = new StringBuffer();
327
					for (String tnc : pdfModel.getTncs()) {
328
						sb.append(tnc).append("\n");
329
					}
330
					Paragraph warningParagraph = new Paragraph(sb.toString(), FONT_NORMAL);
331
					warningParagraph.setIndentationLeft(40);
332
					document.add(Chunk.NEWLINE);
333
					document.add(warningParagraph);
24845 amit.gupta 334
				}
335
 
336
				document.newPage();
24506 amit.gupta 337
			}
24854 amit.gupta 338
			document.close(); // no need to close PDFwriter?
339
			stampCancelled(outputStream, caneclledPageList);
23509 amit.gupta 340
 
341
		} catch (DocumentException e) {
342
			LOGGER.error("Unable to write data to pdf file : ", e);
343
		} catch (Exception e) {
21901 ashik.ali 344
			// TODO Auto-generated catch block
345
			e.printStackTrace();
346
		}
24506 amit.gupta 347
 
21686 ashik.ali 348
	}
23509 amit.gupta 349
 
25463 amit.gupta 350
	private static void stampCancelled(ByteArrayOutputStream byteStream, List<Integer> cancelledPage)
351
			throws IOException, DocumentException {
24506 amit.gupta 352
		ByteArrayInputStream bais = new ByteArrayInputStream(byteStream.toByteArray());
24845 amit.gupta 353
		PdfReader pdfReader = new PdfReader(bais);
354
		int n = pdfReader.getNumberOfPages();
24854 amit.gupta 355
		ByteArrayOutputStream baos = new ByteArrayOutputStream();
356
		PdfStamper pdfStamper = new PdfStamper(pdfReader, baos);
24845 amit.gupta 357
		pdfStamper.setRotateContents(false);
358
		// text watermark
359
		Font f = new Font(FontFamily.HELVETICA, 30);
360
		Phrase p = new Phrase("My watermark (text)", f);
361
		URL cancelledImgUrl = PdfUtils.class.getClassLoader().getResource("cancelled.png");
25460 amit.gupta 362
		URL waterMarkImgUrl = PdfUtils.class.getClassLoader().getResource("sd1.jpg");
363
		Image imgCancelled = Image.getInstance(cancelledImgUrl);
364
		Image imgWatermark = Image.getInstance(waterMarkImgUrl);
25471 amit.gupta 365
		imgWatermark.scaleAbsolute(imgWatermark.getScaledWidth() * 2.5f, imgWatermark.getScaledHeight() * 2.5f);
25460 amit.gupta 366
		float w = imgCancelled.getScaledWidth() / 2;
367
		float h = imgCancelled.getScaledHeight() / 2;
368
		float wWaterMark = imgWatermark.getScaledWidth() / 2;
369
		float hWatermark = imgWatermark.getScaledHeight() / 2;
24845 amit.gupta 370
		// transparency
371
		PdfGState gs1 = new PdfGState();
372
		gs1.setFillOpacity(0.5f);
25463 amit.gupta 373
		PdfGState gs2 = new PdfGState();
25478 amit.gupta 374
		gs2.setFillOpacity(0.1f);
24845 amit.gupta 375
		// properties
376
		PdfContentByte over;
377
		Rectangle pagesize;
378
		float x, y;
24506 amit.gupta 379
 
24845 amit.gupta 380
		// loop over every page
381
		for (int i = 1; i <= n; i++) {
25467 amit.gupta 382
			pagesize = pdfReader.getPageSize(i);
383
			x = (pagesize.getLeft() + pagesize.getRight()) / 2;
384
			y = (pagesize.getTop() + pagesize.getBottom()) / 2;
385
			over = pdfStamper.getOverContent(i);
386
			over.saveState();
24854 amit.gupta 387
			if (cancelledPage.get(i - 1) == 1) {
388
				over.setGState(gs1);
25460 amit.gupta 389
				over.addImage(imgCancelled, w, 0, 0, h, x - (w / 2), y - (h / 2));
24854 amit.gupta 390
				over.restoreState();
25460 amit.gupta 391
			} else {
25463 amit.gupta 392
				over.setGState(gs2);
25462 amit.gupta 393
				over.addImage(imgWatermark, wWaterMark, 0, 0, hWatermark, x - (wWaterMark / 2), y - (hWatermark / 2));
25460 amit.gupta 394
				over.restoreState();
24854 amit.gupta 395
			}
24845 amit.gupta 396
		}
397
		pdfStamper.close();
398
		pdfReader.close();
24854 amit.gupta 399
		baos.writeTo(byteStream);
24845 amit.gupta 400
 
24506 amit.gupta 401
	}
402
 
23509 amit.gupta 403
	public static void generateAndWriteDebitNote(List<DebitNotePdfModel> debitNotePdfModels,
30400 amit.gupta 404
												 OutputStream outputStream) {
23509 amit.gupta 405
		Document document = new Document();
406
		document.setMargins(0, 0, 25, 0);
407
		try {
408
			for (DebitNotePdfModel debitNotePdfModel : debitNotePdfModels) {
409
 
30321 amit.gupta 410
				InvoicePdfModel pdfModel = debitNotePdfModel.getPdfModel();
23509 amit.gupta 411
				CustomCustomer customer = pdfModel.getCustomer();
412
				CustomRetailer retailer = pdfModel.getRetailer();
413
				boolean stateGst = false;
414
				Set<CustomOrderItem> orderItems = pdfModel.getOrderItems();
415
 
416
				PdfWriter.getInstance(document, outputStream);
417
 
418
				document.open();
419
				document.addTitle(pdfModel.getTitle());
420
				document.addAuthor(pdfModel.getAuther());
421
 
23654 amit.gupta 422
				Paragraph paragraphTitle = new Paragraph(pdfModel.getTitle(), FONT_TITLE);
23509 amit.gupta 423
				paragraphTitle.setAlignment(Element.ALIGN_CENTER);
424
 
425
				PdfPCell blankCell = new PdfPCell();
426
				blankCell.setBorder(Rectangle.NO_BORDER);
427
				PdfPTable tableCustomerRetailer = new PdfPTable(3);
23533 amit.gupta 428
				tableCustomerRetailer.setWidthPercentage(95);
23532 amit.gupta 429
				PdfPCell partnerInfo = new PdfPCell();
23549 amit.gupta 430
				partnerInfo.addElement(new Paragraph("From Party:", FONT_BOLD));
23654 amit.gupta 431
				partnerInfo.addElement(
432
						new Paragraph(StringUtils.capitalize(customer.getAddress().getName()), FONT_NORMAL));
433
				partnerInfo.addElement(new Paragraph(
434
						StringUtils.capitalize(customer.getAddress().getLine1()) + ", "
435
								+ (customer.getAddress().getLine2() == null ? ""
30400 amit.gupta 436
								: StringUtils.capitalize(customer.getAddress().getLine2()))
23654 amit.gupta 437
								+ ", " + customer.getAddress().getCity() + " - " + customer.getAddress().getPinCode(),
438
						FONT_NORMAL));
439
 
440
				partnerInfo.addElement(new Paragraph(
30539 amit.gupta 441
						StringUtils.capitalize(customer.getAddress().getState()) + "(" + pdfModel.getCustomerAddressStateCode() + ")",
23654 amit.gupta 442
						FONT_NORMAL));
23532 amit.gupta 443
				partnerInfo.addElement(new Paragraph("Mobile - " + customer.getMobileNumber(), FONT_NORMAL));
23509 amit.gupta 444
				if (customer.getGstNumber() != null && !customer.getGstNumber().isEmpty()) {
23549 amit.gupta 445
					partnerInfo.addElement(new Paragraph("GST No - " + customer.getGstNumber(), FONT_BOLD));
23509 amit.gupta 446
				}
23533 amit.gupta 447
 
23532 amit.gupta 448
				PdfPCell sellerParty = new PdfPCell();
23549 amit.gupta 449
				sellerParty.addElement(new Paragraph("To Party:", FONT_BOLD));
23654 amit.gupta 450
				sellerParty.addElement(
451
						new Paragraph(StringUtils.capitalize(retailer.getAddress().getName()), FONT_NORMAL));
452
				sellerParty.addElement(new Paragraph((retailer.getAddress().getLine1() == null ? ""
453
						: StringUtils.capitalize(retailer.getAddress().getLine1()) + ", ")
454
						+ (retailer.getAddress().getLine2() == null ? ""
30400 amit.gupta 455
						: StringUtils.capitalize(retailer.getAddress().getLine2()) + ", ")
23654 amit.gupta 456
						+ StringUtils.capitalize(retailer.getAddress().getCity()) + "-"
457
						+ retailer.getAddress().getPinCode() + ", ", FONT_NORMAL));
23532 amit.gupta 458
				sellerParty.addElement(new Paragraph(
30539 amit.gupta 459
						retailer.getAddress().getState() + "(" + pdfModel.getPartnerAddressStateCode() + ")", FONT_NORMAL));
23654 amit.gupta 460
				sellerParty
461
						.addElement(new Paragraph("Mobile - " + retailer.getAddress().getPhoneNumber(), FONT_NORMAL));
23549 amit.gupta 462
				sellerParty.addElement(new Paragraph("GST No - " + retailer.getGstNumber(), FONT_BOLD));
23509 amit.gupta 463
 
464
				PdfPTable tableInvoiceDateRetailer = new PdfPTable(1);
465
				tableInvoiceDateRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);
466
 
467
				PdfPTable tableInvoiceDate = new PdfPTable(2);
468
				tableInvoiceDate.getDefaultCell().setBorder(Rectangle.NO_BORDER);
23533 amit.gupta 469
				tableInvoiceDate.setWidthPercentage(90);
23509 amit.gupta 470
 
23533 amit.gupta 471
				PdfPCell debitNoteDetails = new PdfPCell(new Paragraph("Debit Note Details", FONT_BOLD));
472
				debitNoteDetails.setColspan(2);
473
				debitNoteDetails.setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 474
 
23532 amit.gupta 475
				PdfPCell debitNoteNumberKey = new PdfPCell(new Paragraph("Debit Note No:", FONT_NORMAL));
476
				debitNoteNumberKey.setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 477
				PdfPCell debitNoteNumberValue = new PdfPCell(
478
						new Paragraph(debitNotePdfModel.getDebitNoteNumber(), FONT_NORMAL));
23532 amit.gupta 479
				debitNoteNumberValue.setBorder(Rectangle.NO_BORDER);
480
 
481
				PdfPCell debitNoteDateKey = new PdfPCell(new Paragraph("Debit Note Dt:", FONT_NORMAL));
482
				debitNoteDateKey.setBorder(Rectangle.NO_BORDER);
23533 amit.gupta 483
 
484
				PdfPCell debitNoteDateValue = new PdfPCell(
485
						new Paragraph(debitNotePdfModel.getDebitNoteDate(), FONT_NORMAL));
23532 amit.gupta 486
				debitNoteDateValue.setBorder(Rectangle.NO_BORDER);
487
 
23539 amit.gupta 488
				PdfPCell invoiceNumberKey = new PdfPCell(new Paragraph("Invoice Ref No:", FONT_NORMAL));
23509 amit.gupta 489
				invoiceNumberKey.setBorder(Rectangle.NO_BORDER);
490
				PdfPCell invoiceNumberValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceNumber(), FONT_NORMAL));
491
				invoiceNumberValue.setBorder(Rectangle.NO_BORDER);
492
 
23532 amit.gupta 493
				PdfPCell dateKey = new PdfPCell(new Paragraph("Invoice Dt:", FONT_NORMAL));
23509 amit.gupta 494
				dateKey.setBorder(Rectangle.NO_BORDER);
23549 amit.gupta 495
				PdfPCell dateValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceDate(), FONT_NORMAL));
23509 amit.gupta 496
				dateValue.setBorder(Rectangle.NO_BORDER);
23533 amit.gupta 497
 
498
				tableInvoiceDate.addCell(debitNoteDetails);
23532 amit.gupta 499
				tableInvoiceDate.addCell(debitNoteNumberKey);
500
				tableInvoiceDate.addCell(debitNoteNumberValue);
501
				tableInvoiceDate.addCell(debitNoteDateKey);
502
				tableInvoiceDate.addCell(debitNoteDateValue);
23509 amit.gupta 503
				tableInvoiceDate.addCell(invoiceNumberKey);
504
				tableInvoiceDate.addCell(invoiceNumberValue);
505
				tableInvoiceDate.addCell(dateKey);
506
				tableInvoiceDate.addCell(dateValue);
507
 
23532 amit.gupta 508
				tableCustomerRetailer.addCell(partnerInfo);
23533 amit.gupta 509
				tableCustomerRetailer.addCell(tableInvoiceDate);
510
				tableCustomerRetailer.addCell(sellerParty);
23509 amit.gupta 511
 
512
				PdfPTable orders = null;
513
				if (stateGst) {
23532 amit.gupta 514
					orders = new PdfPTable(stateWidths.length);
515
					orders.setWidths(stateWidths);
23509 amit.gupta 516
				} else {
23532 amit.gupta 517
					orders = new PdfPTable(igstWidths.length);
518
					orders.setWidths(igstWidths);
23509 amit.gupta 519
				}
23549 amit.gupta 520
				orders.setWidthPercentage(95);
23542 amit.gupta 521
				orders.addCell(new Paragraph("Order Id", FONT_BOLD));
23509 amit.gupta 522
				orders.addCell(new Paragraph("Description", FONT_BOLD));
523
				orders.addCell(new Paragraph("HSN", FONT_BOLD));
524
				orders.addCell(new Paragraph("Qty", FONT_BOLD));
525
				orders.addCell(new Paragraph("Rate\n(Per pc)", FONT_BOLD));
526
				orders.addCell(new Paragraph("Total\nTaxable", FONT_BOLD));
527
				if (!stateGst) {
528
					orders.addCell(new Paragraph("IGST\n%", FONT_BOLD));
529
					orders.addCell(new Paragraph("IGST", FONT_BOLD));
530
					// orders.setWidths(new float[]{1, 3, 1, 1, 1, 1, 1, 1});
531
					// total 8f
532
				} else {
533
					orders.addCell(new Paragraph("CGST %", FONT_BOLD));
534
					orders.addCell(new Paragraph("CGST", FONT_BOLD));
535
					orders.addCell(new Paragraph("SGST %", FONT_BOLD));
536
					orders.addCell(new Paragraph("SGST", FONT_BOLD));
537
					// orders.setWidths(new float[]{1, 3, 1, 1, 1, 1, 1, 1, 1,
538
					// 1});
539
					// total 8f
540
				}
541
				orders.addCell(new Paragraph("Total", FONT_BOLD));
542
 
543
				orders.setHeaderRows(1);
544
 
545
				float igstTotalAmount = 0, cgstTotalAmount = 0, sgstTotalAmount = 0;
546
				for (CustomOrderItem orderItem : orderItems) {
23542 amit.gupta 547
					orders.addCell(new Paragraph(String.valueOf(orderItem.getOrderId()), FONT_NORMAL));
23509 amit.gupta 548
					orders.addCell(new Paragraph(orderItem.getDescription(), FONT_NORMAL));
549
					orders.addCell(new Paragraph(orderItem.getHsnCode(), FONT_NORMAL));
550
					orders.addCell(new Paragraph(String.valueOf(orderItem.getQuantity()), FONT_NORMAL));
551
					orders.addCell(new Paragraph(String.format("%.2f", orderItem.getRate()), FONT_NORMAL));
552
					orders.addCell(new Paragraph(String.format("%.2f", orderItem.getAmount()), FONT_NORMAL));
553
					if (!stateGst) {
554
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstRate()), FONT_NORMAL));
555
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstAmount()), FONT_NORMAL));
556
						igstTotalAmount = igstTotalAmount + orderItem.getIgstAmount();
557
					} else {
558
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstRate()), FONT_NORMAL));
559
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstAmount()), FONT_NORMAL));
560
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstRate()), FONT_NORMAL));
561
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstAmount()), FONT_NORMAL));
562
						cgstTotalAmount = cgstTotalAmount + orderItem.getCgstAmount();
563
						sgstTotalAmount = sgstTotalAmount + orderItem.getSgstAmount();
564
					}
565
					orders.addCell(new Paragraph(String.format("%.0f", orderItem.getNetAmount()), FONT_NORMAL));
23533 amit.gupta 566
					LOGGER.info("IN FOR LOOP");
23509 amit.gupta 567
				}
568
 
569
				document.add(paragraphTitle);
23533 amit.gupta 570
 
23509 amit.gupta 571
				document.add(Chunk.NEWLINE);
572
				document.add(tableCustomerRetailer);
573
 
574
				document.add(Chunk.NEWLINE);
575
				document.add(orders);
576
 
577
				PdfPTable grandTotalTable = new PdfPTable(3);
578
				if (stateGst) {
30400 amit.gupta 579
					grandTotalTable.setWidths(new float[]{6.6f, .6f, .8f});
23509 amit.gupta 580
				} else {
30400 amit.gupta 581
					grandTotalTable.setWidths(new float[]{6.5f, .6f, .9f});
23509 amit.gupta 582
				}
23549 amit.gupta 583
				grandTotalTable.setWidthPercentage(95);
23509 amit.gupta 584
 
585
				Paragraph grandTotalParagraph = new Paragraph("Grand total", FONT_BOLD);
586
				grandTotalParagraph.setIndentationRight(20);
587
				grandTotalTable.addCell(grandTotalParagraph);
588
				Paragraph rsParagraph = new Paragraph("Rs.", FONT_BOLD);
589
				grandTotalTable.addCell(rsParagraph);
590
				Paragraph amountParagraph = new Paragraph(String.format("%.2f", pdfModel.getTotalAmount()), FONT_BOLD);
591
				grandTotalTable.addCell(amountParagraph);
592
 
593
				document.add(grandTotalTable);
594
 
595
				PdfPTable amountInWordsTable = new PdfPTable(3);
596
				if (!stateGst) {
30400 amit.gupta 597
					amountInWordsTable.setWidths(new float[]{2, 5.1f, 0.9f});
23509 amit.gupta 598
				} else {
30400 amit.gupta 599
					amountInWordsTable.setWidths(new float[]{2, 5.2f, 0.8f});
23509 amit.gupta 600
				}
23549 amit.gupta 601
				amountInWordsTable.setWidthPercentage(95);
23509 amit.gupta 602
				amountInWordsTable.addCell(new Paragraph("Amount in Words:", FONT_BOLD));
603
 
604
				String amountInWords = toAmountInWords(pdfModel.getTotalAmount());
605
				amountInWordsTable.addCell(new Paragraph(amountInWords.toString(), FONT_BOLD));
606
				amountInWordsTable.addCell(new Paragraph("E & O.E", FONT_NORMAL));
607
				document.add(amountInWordsTable);
608
 
609
				document.newPage();
610
			}
611
			document.close(); // no need to close PDFwriter?
30539 amit.gupta 612
 
23509 amit.gupta 613
		} catch (DocumentException e) {
614
			LOGGER.error("Unable to write data to pdf file : ", e);
615
		} catch (Exception e) {
616
			// TODO Auto-generated catch block
617
			e.printStackTrace();
618
		}
21915 ashik.ali 619
	}
23509 amit.gupta 620
 
621
	private static String toAmountInWords(float amount) {
622
		RuleBasedNumberFormat amountInWordsFormat = new RuleBasedNumberFormat(indianLocale,
623
				RuleBasedNumberFormat.SPELLOUT);
624
		StringBuilder amountInWords = new StringBuilder("Rs. ");
625
		amountInWords.append(StringUtils.capitalize(amountInWordsFormat.format((int) amount)));
626
		amountInWords.append(" and ");
627
		amountInWords.append(StringUtils.capitalize(amountInWordsFormat.format((int) (amount * 100) % 100)));
628
		amountInWords.append(" paise");
629
		return amountInWords.toString();
630
	}
23654 amit.gupta 631
 
24506 amit.gupta 632
	public static void generateAndWriteCustomerCreditNotes(List<CreditNotePdfModel> creditNotes,
30400 amit.gupta 633
														   OutputStream outputStream) {
23654 amit.gupta 634
		Document document = new Document();
635
		document.setMargins(0, 0, 25, 0);
636
		try {
637
			PdfWriter.getInstance(document, outputStream);
24506 amit.gupta 638
 
23654 amit.gupta 639
			document.open();
640
			document.addTitle(creditNotes.get(0).getPdfModel().getTitle());
641
			document.addAuthor(creditNotes.get(0).getPdfModel().getAuther());
642
			for (CreditNotePdfModel creditNotePdfModel : creditNotes) {
30321 amit.gupta 643
				InvoicePdfModel pdfModel = creditNotePdfModel.getPdfModel();
23654 amit.gupta 644
				CustomCustomer customer = pdfModel.getCustomer();
645
				CustomRetailer retailer = pdfModel.getRetailer();
646
				boolean stateGst = false;
31008 amit.gupta 647
				if (customer.getAddress().getState().equals(retailer.getAddress().getState())) {
648
					stateGst = true;
649
				}
23654 amit.gupta 650
				Set<CustomOrderItem> orderItems = pdfModel.getOrderItems();
651
 
652
				Paragraph paragraphTitle = new Paragraph(pdfModel.getTitle(), FONT_TITLE);
653
				paragraphTitle.setAlignment(Element.ALIGN_CENTER);
654
 
655
				PdfPCell blankCell = new PdfPCell();
656
				blankCell.setBorder(Rectangle.NO_BORDER);
657
				PdfPTable tableCustomerRetailer = new PdfPTable(3);
658
				tableCustomerRetailer.setWidthPercentage(95);
659
				PdfPCell partnerInfo = new PdfPCell();
660
				partnerInfo.addElement(new Paragraph("To Party:", FONT_BOLD));
661
				partnerInfo.addElement(
662
						new Paragraph(StringUtils.capitalize(customer.getAddress().getName()), FONT_NORMAL));
663
				partnerInfo.addElement(new Paragraph(
664
						StringUtils.capitalize(customer.getAddress().getLine1()) + ", "
665
								+ (customer.getAddress().getLine2() == null ? ""
30400 amit.gupta 666
								: StringUtils.capitalize(customer.getAddress().getLine2()))
23654 amit.gupta 667
								+ ", " + customer.getAddress().getCity() + " - " + customer.getAddress().getPinCode(),
668
						FONT_NORMAL));
669
 
670
				partnerInfo.addElement(new Paragraph(
30539 amit.gupta 671
						StringUtils.capitalize(customer.getAddress().getState()) + "(" + pdfModel.getCustomerAddressStateCode() + ")",
23654 amit.gupta 672
						FONT_NORMAL));
673
				partnerInfo.addElement(new Paragraph("Mobile - " + customer.getMobileNumber(), FONT_NORMAL));
674
				if (customer.getGstNumber() != null && !customer.getGstNumber().isEmpty()) {
675
					partnerInfo.addElement(new Paragraph("GST No - " + customer.getGstNumber(), FONT_BOLD));
676
				}
677
 
678
				PdfPCell sellerParty = new PdfPCell();
679
				sellerParty.addElement(new Paragraph("From Party:", FONT_BOLD));
680
				sellerParty.addElement(
681
						new Paragraph(StringUtils.capitalize(retailer.getAddress().getName()), FONT_NORMAL));
682
				sellerParty.addElement(new Paragraph((retailer.getAddress().getLine1() == null ? ""
683
						: StringUtils.capitalize(retailer.getAddress().getLine1()) + ", ")
684
						+ (retailer.getAddress().getLine2() == null ? ""
30400 amit.gupta 685
						: StringUtils.capitalize(retailer.getAddress().getLine2()) + ", ")
23654 amit.gupta 686
						+ StringUtils.capitalize(retailer.getAddress().getCity()) + "-"
687
						+ retailer.getAddress().getPinCode() + ", ", FONT_NORMAL));
688
				sellerParty.addElement(new Paragraph(
30539 amit.gupta 689
						retailer.getAddress().getState() + "(" + pdfModel.getPartnerAddressStateCode() + ")", FONT_NORMAL));
23654 amit.gupta 690
				sellerParty
691
						.addElement(new Paragraph("Mobile - " + retailer.getAddress().getPhoneNumber(), FONT_NORMAL));
692
				sellerParty.addElement(new Paragraph("GST No - " + retailer.getGstNumber(), FONT_BOLD));
693
 
694
				PdfPTable tableInvoiceDateRetailer = new PdfPTable(1);
695
				tableInvoiceDateRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);
696
 
697
				PdfPTable tableInvoiceDate = new PdfPTable(2);
698
				tableInvoiceDate.getDefaultCell().setBorder(Rectangle.NO_BORDER);
699
				tableInvoiceDate.setWidthPercentage(90);
700
 
701
				PdfPCell debitNoteDetails = new PdfPCell(new Paragraph("Credit Note Details", FONT_BOLD));
702
				debitNoteDetails.setColspan(2);
703
				debitNoteDetails.setBorder(Rectangle.NO_BORDER);
704
 
705
				PdfPCell debitNoteNumberKey = new PdfPCell(new Paragraph("Credit Note No:", FONT_NORMAL));
706
				debitNoteNumberKey.setBorder(Rectangle.NO_BORDER);
707
				PdfPCell debitNoteNumberValue = new PdfPCell(
708
						new Paragraph(creditNotePdfModel.getCreditNoteNumber(), FONT_NORMAL));
709
				debitNoteNumberValue.setBorder(Rectangle.NO_BORDER);
710
 
711
				PdfPCell debitNoteDateKey = new PdfPCell(new Paragraph("Credit Note Dt:", FONT_NORMAL));
712
				debitNoteDateKey.setBorder(Rectangle.NO_BORDER);
713
 
714
				PdfPCell debitNoteDateValue = new PdfPCell(
715
						new Paragraph(creditNotePdfModel.getCreditNoteDate(), FONT_NORMAL));
716
				debitNoteDateValue.setBorder(Rectangle.NO_BORDER);
717
				tableInvoiceDate.addCell(debitNoteDetails);
718
				tableInvoiceDate.addCell(debitNoteNumberKey);
719
				tableInvoiceDate.addCell(debitNoteNumberValue);
720
				tableInvoiceDate.addCell(debitNoteDateKey);
721
				tableInvoiceDate.addCell(debitNoteDateValue);
31008 amit.gupta 722
				if (pdfModel.getIrnNumber() != null) {
723
					PdfPCell dateKey = new PdfPCell(new Paragraph("Invoice Dt:", FONT_NORMAL));
724
					dateKey.setBorder(Rectangle.NO_BORDER);
725
					PdfPCell dateValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceDate(), FONT_NORMAL));
726
					dateValue.setBorder(Rectangle.NO_BORDER);
23654 amit.gupta 727
 
31008 amit.gupta 728
					PdfPCell invoiceNumberKey = new PdfPCell(new Paragraph("Invoice Ref No:", FONT_NORMAL));
729
					invoiceNumberKey.setBorder(Rectangle.NO_BORDER);
730
					PdfPCell invoiceNumberValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceNumber(), FONT_NORMAL));
731
					invoiceNumberValue.setBorder(Rectangle.NO_BORDER);
732
					tableInvoiceDate.addCell(invoiceNumberKey);
733
					tableInvoiceDate.addCell(invoiceNumberValue);
734
					tableInvoiceDate.addCell(dateKey);
735
					tableInvoiceDate.addCell(dateValue);
736
				}
737
 
23654 amit.gupta 738
				tableCustomerRetailer.addCell(partnerInfo);
739
				tableCustomerRetailer.addCell(tableInvoiceDate);
740
				tableCustomerRetailer.addCell(sellerParty);
741
 
742
				PdfPTable orders = null;
743
				if (stateGst) {
744
					orders = new PdfPTable(stateWidthsCrNote.length);
745
					orders.setWidths(stateWidthsCrNote);
746
				} else {
747
					orders = new PdfPTable(igstWidthsCrNote.length);
748
					orders.setWidths(igstWidthsCrNote);
749
				}
750
				orders.setWidthPercentage(95);
751
				orders.addCell(new Paragraph("Description", FONT_BOLD));
752
				orders.addCell(new Paragraph("HSN", FONT_BOLD));
753
				orders.addCell(new Paragraph("Qty", FONT_BOLD));
754
				orders.addCell(new Paragraph("Rate\n(Per pc)", FONT_BOLD));
755
				orders.addCell(new Paragraph("Total\nTaxable", FONT_BOLD));
756
				if (!stateGst) {
757
					orders.addCell(new Paragraph("IGST%", FONT_BOLD));
758
					orders.addCell(new Paragraph("IGST", FONT_BOLD));
759
					// orders.setWidths(new float[]{1, 3, 1, 1, 1, 1, 1, 1});
760
					// total 8f
761
				} else {
762
					orders.addCell(new Paragraph("CGST %", FONT_BOLD));
763
					orders.addCell(new Paragraph("CGST", FONT_BOLD));
764
					orders.addCell(new Paragraph("SGST %", FONT_BOLD));
765
					orders.addCell(new Paragraph("SGST", FONT_BOLD));
766
					// orders.setWidths(new float[]{1, 3, 1, 1, 1, 1, 1, 1, 1,
767
					// 1});
768
					// total 8f
769
				}
770
				orders.addCell(new Paragraph("Total", FONT_BOLD));
771
 
772
				orders.setHeaderRows(1);
773
 
774
				float igstTotalAmount = 0, cgstTotalAmount = 0, sgstTotalAmount = 0;
775
				for (CustomOrderItem orderItem : orderItems) {
776
					LOGGER.info("Custom Order Item - {}", orderItem);
777
					orders.addCell(new Paragraph(orderItem.getDescription(), FONT_NORMAL));
778
					orders.addCell(new Paragraph(orderItem.getHsnCode(), FONT_NORMAL));
779
					orders.addCell(new Paragraph(String.valueOf(orderItem.getQuantity()), FONT_NORMAL));
780
					orders.addCell(new Paragraph(String.format("%.2f", orderItem.getRate()), FONT_NORMAL));
781
					orders.addCell(new Paragraph(String.format("%.2f", orderItem.getAmount()), FONT_NORMAL));
782
					if (!stateGst) {
783
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstRate()), FONT_NORMAL));
784
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstAmount()), FONT_NORMAL));
785
						igstTotalAmount = igstTotalAmount + orderItem.getIgstAmount();
786
					} else {
787
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstRate()), FONT_NORMAL));
788
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstAmount()), FONT_NORMAL));
789
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstRate()), FONT_NORMAL));
790
						orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstAmount()), FONT_NORMAL));
791
						cgstTotalAmount = cgstTotalAmount + orderItem.getCgstAmount();
792
						sgstTotalAmount = sgstTotalAmount + orderItem.getSgstAmount();
793
					}
794
					orders.addCell(new Paragraph(String.format("%.0f", orderItem.getNetAmount()), FONT_NORMAL));
795
					LOGGER.info("IN FOR LOOP");
796
				}
797
 
798
				document.add(paragraphTitle);
799
 
800
				document.add(Chunk.NEWLINE);
801
				document.add(tableCustomerRetailer);
802
 
803
				document.add(Chunk.NEWLINE);
804
				document.add(orders);
805
 
806
				PdfPTable grandTotalTable = new PdfPTable(3);
807
				if (stateGst) {
30400 amit.gupta 808
					grandTotalTable.setWidths(new float[]{6.6f, .6f, .8f});
23654 amit.gupta 809
				} else {
30400 amit.gupta 810
					grandTotalTable.setWidths(new float[]{6.5f, .6f, .9f});
23654 amit.gupta 811
				}
812
				grandTotalTable.setWidthPercentage(95);
813
 
814
				Paragraph grandTotalParagraph = new Paragraph("Grand total", FONT_BOLD);
815
				grandTotalParagraph.setIndentationRight(20);
816
				grandTotalTable.addCell(grandTotalParagraph);
817
				Paragraph rsParagraph = new Paragraph("Rs.", FONT_BOLD);
818
				grandTotalTable.addCell(rsParagraph);
819
				Paragraph amountParagraph = new Paragraph(String.format("%.2f", pdfModel.getTotalAmount()), FONT_BOLD);
820
				grandTotalTable.addCell(amountParagraph);
821
 
822
				document.add(grandTotalTable);
823
 
824
				PdfPTable amountInWordsTable = new PdfPTable(3);
825
				if (!stateGst) {
30400 amit.gupta 826
					amountInWordsTable.setWidths(new float[]{2, 5.1f, 0.9f});
23654 amit.gupta 827
				} else {
30400 amit.gupta 828
					amountInWordsTable.setWidths(new float[]{2, 5.2f, 0.8f});
23654 amit.gupta 829
				}
830
				amountInWordsTable.setWidthPercentage(95);
831
				amountInWordsTable.addCell(new Paragraph("Amount in Words:", FONT_BOLD));
832
 
833
				String amountInWords = toAmountInWords(pdfModel.getTotalAmount());
834
				amountInWordsTable.addCell(new Paragraph(amountInWords.toString(), FONT_BOLD));
835
				amountInWordsTable.addCell(new Paragraph("E & O.E", FONT_NORMAL));
836
				document.add(amountInWordsTable);
837
 
838
				document.newPage();
839
			}
840
			document.close(); // no need to close PDFwriter?
841
		} catch (DocumentException e) {
842
			LOGGER.error("Unable to write data to pdf file : ", e);
843
		} catch (Exception e) {
844
			// TODO Auto-generated catch block
845
			e.printStackTrace();
846
		}
847
 
848
	}
21686 ashik.ali 849
}