Subversion Repositories SmartDukaan

package in.shop2020.support.services;

import in.shop2020.logistics.DeliveryType;
import in.shop2020.logistics.LogisticsServiceException;
import in.shop2020.logistics.Provider;
import in.shop2020.logistics.ProviderDetails;
import in.shop2020.model.v1.inventory.InventoryServiceException;
import in.shop2020.model.v1.inventory.Warehouse;
import in.shop2020.model.v1.order.LineItem;
import in.shop2020.model.v1.order.Order;
import in.shop2020.model.v1.order.OrderStatus;
import in.shop2020.model.v1.order.TransactionServiceException;
import in.shop2020.thrift.clients.InventoryClient;
import in.shop2020.thrift.clients.LogisticsClient;
import in.shop2020.thrift.clients.TransactionClient;

import java.io.ByteArrayOutputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
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.CreationHelper;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.thrift.TException;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class CourierDetailsGenerator {
    private static Logger logger = LoggerFactory.getLogger(CourierDetailsGenerator.class);
    
        private TransactionClient tsc = null;
        private InventoryClient isc = null;
        private LogisticsClient lsc = null;
        
        public CourierDetailsGenerator(){
                try {
                        tsc = new TransactionClient();
                        isc = new InventoryClient();
                        lsc = new LogisticsClient();
                } catch (Exception e) {
                        logger.error("Error while initializing one of the thrift clients", e);
                }
        }
        
        public ByteArrayOutputStream generateCourierDetails(long warehouseId, long providerId, boolean isCod){
                ByteArrayOutputStream baosXLS = new ByteArrayOutputStream();
                in.shop2020.model.v1.order.TransactionService.Client txnClient = tsc.getClient();
                in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = isc.getClient();
                in.shop2020.logistics.LogisticsService.Client logisticsClient = lsc.getClient();
                
                List<Order> orders = null;
                Warehouse warehouse = null;
                Provider provider = null;

                try {
                    List<OrderStatus> statuses = new ArrayList<OrderStatus>();
            statuses.add(OrderStatus.BILLED);
                        orders = txnClient.getAllOrders(statuses, 0L, new Date().getTime(), warehouseId);
                        warehouse = inventoryClient.getWarehouse(warehouseId);
                        provider = logisticsClient.getProvider(providerId);
                } catch (TException e) {
                    logger.error("Error getting information from one of the Thrift Services: ", e);
                        return baosXLS;
                } catch (InventoryServiceException e) {
                    logger.error("Error getting warehouse info from the catalog service: ", e);
                        return baosXLS;
                } catch (LogisticsServiceException e) {
                    logger.error("Error getting provider info from the logistics service: ", e);
                        return baosXLS;
                } catch (TransactionServiceException e) {
                    logger.error("Error getting orders from the transaction service: ", e);
                        return baosXLS;
                }
                
            Workbook wb = new HSSFWorkbook();
            CreationHelper createHelper = wb.getCreationHelper();
            Sheet sheet = wb.createSheet("new sheet");
            
            CellStyle dateCellStyle = wb.createCellStyle();
            dateCellStyle.setDataFormat(createHelper.createDataFormat().getFormat("d/m/yyyy"));
            
            CellStyle weightStyle = wb.createCellStyle();
            weightStyle.setDataFormat(createHelper.createDataFormat().getFormat("0.000"));

            // Create the header row and put all the titles in it. Rows are 0 based.
            Row headerRow = sheet.createRow((short)0);
            headerRow.createCell(0).setCellValue("Sl No");
            headerRow.createCell(1).setCellValue("AWB No");
            headerRow.createCell(2).setCellValue("AWB Date");
            headerRow.createCell(3).setCellValue("Order No");
            headerRow.createCell(4).setCellValue("Name");
            headerRow.createCell(5).setCellValue("Address 1");
            headerRow.createCell(6).setCellValue("Address 2");
            headerRow.createCell(7).setCellValue("City");
            headerRow.createCell(8).setCellValue("State");
            headerRow.createCell(9).setCellValue("Pin Code");
            headerRow.createCell(10).setCellValue("Telephone No 1");
            headerRow.createCell(11).setCellValue("Telephone No 2");
            headerRow.createCell(12).setCellValue("Paymode");
            headerRow.createCell(13).setCellValue("Amount to be Collected");
            headerRow.createCell(14).setCellValue("Shipment Value");
            headerRow.createCell(15).setCellValue("Item ID");
            headerRow.createCell(16).setCellValue("Packet Weight(in Kg)");
            headerRow.createCell(17).setCellValue("Product Name");
            headerRow.createCell(18).setCellValue("Pickup Location");
            headerRow.createCell(19).setCellValue("Customer A/C Code");

            String accountNo = "";
            DeliveryType dt =  DeliveryType.PREPAID;
        if (isCod) {
            dt = DeliveryType.COD;
        }
        
        for (ProviderDetails detail : provider.getDetails()) {
            if(in.shop2020.model.v1.inventory.WarehouseLocation.findByValue((int) detail.getLogisticLocation()) == warehouse.getLogisticsLocation() && detail.getDeliveryType() == dt) {
                accountNo = detail.getAccountNo();
            }
        }
            Date awbDate = new Date();
            String location = removeNewLines(warehouse.getLocation());
            
            int serialNo = 0;
            for(int i = 0; i<orders.size(); i++){
                Order order = orders.get(i);
                        if(order.getLogistics_provider_id()!=providerId)
                                continue;
                        if(order.isLogisticsCod() != isCod)
                            continue;
                        serialNo++;
                Row contentRow = sheet.createRow((short)serialNo);
                    contentRow.createCell(0).setCellValue(serialNo);
                    contentRow.createCell(1).setCellValue(order.getAirwaybill_no());
                    Cell awbDateCell = contentRow.createCell(2);
                    awbDateCell.setCellValue(awbDate);
                    awbDateCell.setCellStyle(dateCellStyle);                
                    contentRow.createCell(3).setCellValue(order.getId());
                    contentRow.createCell(4).setCellValue(getValueForEmptyString(order.getCustomer_name()));
                    contentRow.createCell(5).setCellValue(getValueForEmptyString(order.getCustomer_address1()));
                    contentRow.createCell(6).setCellValue(getValueForEmptyString(order.getCustomer_address2()));
                    contentRow.createCell(7).setCellValue(getValueForEmptyString(order.getCustomer_city()));
                    contentRow.createCell(8).setCellValue(getValueForEmptyString(order.getCustomer_state()));
                    contentRow.createCell(9).setCellValue(getValueForEmptyString(order.getCustomer_pincode()));
                    contentRow.createCell(10).setCellValue(getValueForEmptyString(order.getCustomer_mobilenumber()));
                    contentRow.createCell(11).setCellValue("-");
                    if(isCod){
                        contentRow.createCell(12).setCellValue("COD");
                contentRow.createCell(13).setCellValue(order.getTotal_amount()-order.getGvAmount());
                    } else {
                        contentRow.createCell(12).setCellValue("Prepaid");
                contentRow.createCell(13).setCellValue(0);
                    }
                    
                    List<LineItem> lineItems = order.getLineitems();
                    LineItem lineItem = lineItems.get(0);
                    contentRow.createCell(14).setCellValue(order.getTotal_amount()-order.getGvAmount());
                    contentRow.createCell(15).setCellValue(lineItem.getId());
                    Cell weightCell = contentRow.createCell(16);
                    weightCell.setCellValue(lineItem.getTotal_weight());
                    weightCell.setCellStyle(weightStyle);
                    contentRow.createCell(17).setCellValue(lineItem.getBrand() + " " + lineItem.getModel_number() + " " + lineItem.getModel_name() + " " + lineItem.getColor());
                    contentRow.createCell(18).setCellValue(location);
                    contentRow.createCell(19).setCellValue(accountNo);
            }

                // Write the workbook to the output stream
                try {
                        wb.write(baosXLS);
                        baosXLS.close();
                } catch (IOException e) {
                        logger.error("Exception while creating the Courier Details report", e);
                }
                
                return baosXLS;
        }
        
        private String getValueForEmptyString(String s){
                if(s==null || s.equals(""))
                        return "-";
                else
                        return s; 
        }
        
        private String removeNewLines(String str){
            return str.replace('\n', ' ');
        }
        
        /**
         * @param args
         */
        public static void main(String[] args) {
                System.out.println("Hey There");
                CourierDetailsGenerator g = new CourierDetailsGenerator();
                try {
                        FileOutputStream f = new FileOutputStream("/home/ashish/Downloads/courier-details.xls");
                        ByteArrayOutputStream baosXLS = g.generateCourierDetails(1, 1, true);
                        baosXLS.writeTo(f);
                        f.close();
                } catch (FileNotFoundException e) {
                        logger.error("Error while creating the Courier Details report", e);
                } catch (IOException e) {
                        logger.error("IO error while writing the Courier Details report", e);
                }
                System.out.println("Successfully generated the detailed courier report");
        }

}