Subversion Repositories SmartDukaan

Rev

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