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();

        }

    }

    /**

     * This method is used in PaymentDetailsController.

     * If any pending or failed payment exists between given date range, it returns ByteArrayOutputStream,

     * otherwise it returns null.

     * @param startDate

     * @param endDate

     * @return

     */

    public ByteArrayOutputStream generatePaymentDetailsReport(Date startDate, Date endDate) {

        // Retrieving all the payments between start and end dates with status

        // as FAILED or INIT 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 if (pendingPayments != null){

            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");

        int addrColWidth = 35;

        paymentSheet.setColumnWidth(10, 256 * addrColWidth); // 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()) {

                    continue;

                }

                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 / addrColWidth + 1) * rowHeight); // Setting 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();

            }

        }

        for (int i = 0; i <= 23; i++) {

            if (i == 10) // Address Column is of fixed size with wrap text style

                continue;

            paymentSheet.autoSizeColumn(i);

        }

        // 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) {

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

        Date startDate = null, endDate = null;

        try {

            startDate = df.parse("01/01/2011");

            endDate = df.parse("04/30/2011");

            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");

    }

}