Subversion Repositories SmartDukaan

package in.shop2020.support.services;

import in.shop2020.model.v1.order.LineItem;

import in.shop2020.model.v1.order.Order;

import in.shop2020.model.v1.order.TransactionServiceException;

import in.shop2020.payments.Payment;

import in.shop2020.payments.PaymentException;

import in.shop2020.payments.PaymentStatus;

import in.shop2020.thrift.clients.PaymentServiceClient;

import in.shop2020.thrift.clients.TransactionServiceClient;

import java.io.ByteArrayOutputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.text.DateFormat;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.Date;

import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Cell;

import org.apache.poi.ss.usermodel.CellStyle;

import org.apache.poi.ss.usermodel.DataFormat;

import org.apache.poi.ss.usermodel.Font;

import org.apache.poi.ss.usermodel.Row;

import org.apache.poi.ss.usermodel.Sheet;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.ss.util.CellRangeAddress;

import org.apache.thrift.TException;

public class PaymentDetailsGenerator {

	TransactionServiceClient tsc;

	in.shop2020.model.v1.order.TransactionService.Client tClient;

	PaymentServiceClient psc;

	in.shop2020.payments.PaymentService.Client pClient;

	public PaymentDetailsGenerator() {

		try {

			tsc = new TransactionServiceClient();

			tClient = tsc.getClient();

			psc = new PaymentServiceClient();

			pClient = psc.getClient();

		} catch (Exception e) {

			e.printStackTrace();

		}

	}

	public ByteArrayOutputStream generatePaymentDetailsReport(Date startDate, Date endDate) {

		// Retrieving all the payments between start and end dates with status as failed and for gateway Id = 1 (HDFC)

		List<Payment> payments = null;

		List<Payment> pendingPayments = null;

		try {

			payments = pClient.getPayments(startDate.getTime(), endDate.getTime(), PaymentStatus.FAILED, 1);

			pendingPayments = pClient.getPayments(startDate.getTime(), endDate.getTime(), PaymentStatus.INIT, 1);

		} catch (PaymentException e) {

			e.printStackTrace();

		} catch (TException e) {

			e.printStackTrace();

		}

		if(payments != null && pendingPayments != null) {

			payments.addAll(pendingPayments);	

		} else {

			payments = pendingPayments;

		}

		if(payments == null || payments.isEmpty()) {

			return null;

		}

		// Preparing XLS file for output

		return getSpreadSheetData(payments);

	}

	// Prepares the XLS worksheet object and fills in the data with proper formatting

	private ByteArrayOutputStream getSpreadSheetData(List<Payment> payments)	{

		ByteArrayOutputStream baosXLS = new ByteArrayOutputStream();

		Workbook wb = new HSSFWorkbook();

		Font font = wb.createFont();

		font.setBoldweight(Font.BOLDWEIGHT_BOLD);

		CellStyle style = wb.createCellStyle();

		style.setFont(font);

		CellStyle styleWT = wb.createCellStyle();

        styleWT.setWrapText(true);

        DataFormat format = wb.createDataFormat();

        CellStyle styleAmount = wb.createCellStyle();

        styleAmount.setDataFormat(format.getFormat("#,##0.00"));

		Sheet paymentSheet = wb.createSheet("Payment");

		short paymentSerialNo = 0;

		Row titleRow = paymentSheet.createRow(paymentSerialNo ++);

		Cell titleCell = titleRow.createCell(0);

		titleCell.setCellValue("Payment Details");

		titleCell.setCellStyle(style);

		paymentSheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 6));

		paymentSheet.createRow(paymentSerialNo ++);

		Row headerRow = paymentSheet.createRow(paymentSerialNo ++);

		headerRow.createCell(0).setCellValue("Payment Id");

		headerRow.createCell(1).setCellValue("Txn Id");

		headerRow.createCell(2).setCellValue("Amount");

		headerRow.createCell(3).setCellValue("Payment Status");

		headerRow.createCell(4).setCellValue("Payment Status Description");

		headerRow.createCell(5).setCellValue("Reference Code");

		headerRow.createCell(6).setCellValue("Transaction Time");

		headerRow.createCell(7).setCellValue("Customer Id");

		headerRow.createCell(8).setCellValue("Name");

		headerRow.createCell(9).setCellValue("MobileNo");

		headerRow.createCell(10).setCellValue("Address");

		headerRow.getCell(10).setCellStyle(styleWT);

		headerRow.createCell(11).setCellValue("Pincode");

		headerRow.createCell(12).setCellValue("City");

		headerRow.createCell(13).setCellValue("State");

		headerRow.createCell(14).setCellValue("Email");

		headerRow.createCell(15).setCellValue("Order Id");

		headerRow.createCell(16).setCellValue("Order Status");

		headerRow.createCell(17).setCellValue("Order Status Description");

		headerRow.createCell(18).setCellValue("Item Id");

		headerRow.createCell(19).setCellValue("Product Group");

		headerRow.createCell(20).setCellValue("Brand");

		headerRow.createCell(21).setCellValue("Model Name");

		headerRow.createCell(22).setCellValue("Model Number");

		headerRow.createCell(23).setCellValue("Qty");

		paymentSheet.setColumnWidth(10, 256*35); // set width of address column to 35 characters

		List<Order> orders;

		long txnId;

		Row contentRow;

		Calendar calendar = Calendar.getInstance();

		DateFormat formatter = new SimpleDateFormat("EEE, dd-MMM-yyyy hh:mm a");

		for(Payment payment : payments) {

			try {

				paymentSerialNo++;

				contentRow = paymentSheet.createRow(paymentSerialNo);

				contentRow.createCell(0).setCellValue(payment.getPaymentId());

				contentRow.createCell(1).setCellValue(payment.getMerchantTxnId());

				contentRow.createCell(2).setCellValue(payment.getAmount());

				contentRow.getCell(2).setCellStyle(styleAmount);

				contentRow.createCell(3).setCellValue(payment.getStatus().name());

				contentRow.createCell(4).setCellValue(payment.getDescription());

				contentRow.createCell(5).setCellValue(payment.getReferenceCode());

				calendar.setTimeInMillis(payment.getInitTimestamp());

				contentRow.createCell(6).setCellValue(formatter.format(calendar.getTime()));

				txnId = tClient.getTransaction(payment.getMerchantTxnId()).getId();

				orders = tClient.getOrdersForTransaction(txnId, payment.getUserId());

				List<LineItem> lineItems;

				String address = "";

				float rowHeight = paymentSheet.getDefaultRowHeightInPoints();

				if(orders != null && !orders.isEmpty()) {

					contentRow.createCell(7).setCellValue(orders.get(0).getCustomer_id());

					contentRow.createCell(8).setCellValue(orders.get(0).getCustomer_name());

					contentRow.createCell(9).setCellValue(orders.get(0).getCustomer_mobilenumber());

					address = orders.get(0).getCustomer_address1() + ", " + orders.get(0).getCustomer_address2();

					contentRow.createCell(10).setCellValue(address);

					contentRow.getCell(10).setCellStyle(styleWT);

					int maxLength = Math.max(address.length(), paymentSheet.getDefaultColumnWidth());

				    contentRow.setHeightInPoints((maxLength / 35 + 1) * rowHeight);  // Set Row Height

					contentRow.createCell(11).setCellValue(orders.get(0).getCustomer_pincode());

					contentRow.createCell(12).setCellValue(orders.get(0).getCustomer_city());

					contentRow.createCell(13).setCellValue(orders.get(0).getCustomer_state());

					contentRow.createCell(14).setCellValue(orders.get(0).getCustomer_email());		

					for(Order o : orders) {

						paymentSerialNo++;

						contentRow = paymentSheet.createRow(paymentSerialNo);

						contentRow.createCell(15).setCellValue(o.getId());

						contentRow.createCell(16).setCellValue(o.getStatus().name());

						contentRow.createCell(17).setCellValue(o.getStatusDescription());

						lineItems = tClient.getLineItemsForOrder(o.getId());

						for(LineItem i : lineItems) {

							/*Right now there can be only one line item in an order.

					  So putting line item details in the same row as order details. Commenting below 2 lines for this.*/

							//paymentSerialNo++;

							//contentRow = paymentSheet.createRow(paymentSerialNo);

							contentRow.createCell(18).setCellValue(i.getId());

							contentRow.createCell(19).setCellValue(i.getProductGroup());

							contentRow.createCell(20).setCellValue(i.getBrand());

							contentRow.createCell(21).setCellValue(i.getModel_name());

							contentRow.createCell(22).setCellValue(i.getModel_number());

							contentRow.createCell(23).setCellValue(i.getQuantity());

						}

					}

				}

			} catch (TransactionServiceException e) {

				e.printStackTrace();

			} catch (TException e) {

				e.printStackTrace();

			}

		}

		paymentSheet.autoSizeColumn(0);

		paymentSheet.autoSizeColumn(1);

		paymentSheet.autoSizeColumn(2);

		paymentSheet.autoSizeColumn(3);

		paymentSheet.autoSizeColumn(4);

		paymentSheet.autoSizeColumn(5);

		paymentSheet.autoSizeColumn(6);

		paymentSheet.autoSizeColumn(7);

		paymentSheet.autoSizeColumn(8);

		paymentSheet.autoSizeColumn(9);

		paymentSheet.autoSizeColumn(11);

		paymentSheet.autoSizeColumn(12);

		paymentSheet.autoSizeColumn(13);

		paymentSheet.autoSizeColumn(14);

		paymentSheet.autoSizeColumn(15);

		paymentSheet.autoSizeColumn(16);

		paymentSheet.autoSizeColumn(17);

		paymentSheet.autoSizeColumn(18);

		paymentSheet.autoSizeColumn(19);

		paymentSheet.autoSizeColumn(20);

		paymentSheet.autoSizeColumn(21);

		paymentSheet.autoSizeColumn(22);

		paymentSheet.autoSizeColumn(23);

		// Write the workbook to the output stream

		try {

			wb.write(baosXLS);

			baosXLS.close();

		} catch (IOException e) {

			e.printStackTrace();

		}		

		return baosXLS;

	}

	public static void main(String[] args) {

		String startDateStr = "01/01/2011";

		String endDateStr = "04/30/2011";

		DateFormat df = new SimpleDateFormat("MM/dd/yyyy");

		Date startDate = null, endDate = null;

		try {

			startDate = df.parse(startDateStr);

			endDate = df.parse(endDateStr);

			Calendar cal = Calendar.getInstance();

			cal.setTime(endDate);

			cal.add(Calendar.DATE, 1);

			endDate.setTime(cal.getTimeInMillis());

		} catch(ParseException pe) {

			pe.printStackTrace();

		}

		PaymentDetailsGenerator pdg = new PaymentDetailsGenerator();

		try {

			String userHome = System.getProperty("user.home");

			FileOutputStream f = new FileOutputStream(userHome + "/payment-details-report.xls");

			ByteArrayOutputStream baosXLS = pdg.generatePaymentDetailsReport(startDate, endDate);

			baosXLS.writeTo(f);

			f.close();

		} catch (FileNotFoundException e) {

			e.printStackTrace();

		} catch (IOException e) {

			e.printStackTrace();

		}

		System.out.println("Successfully generated the payment details report");

	}

}