Subversion Repositories SmartDukaan

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

import java.io.ByteArrayOutputStream;

import java.io.IOException;

import java.text.DateFormat;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.HashMap;

import javax.servlet.ServletOutputStream;

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

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;

			}else if(action.equals("markrejected")){

				long orderId = Long.parseLong(orderIdString);

				Order order = client.getOrder(orderId);

				DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

				String returnReason = formatter.format(Calendar.getInstance().getTime()) + "|Returned from store.";

				HashMap<String, String> orderMap = new HashMap<String, String>();

				orderMap.put(order.getAirwaybill_no(), returnReason);

				client.markAsRTOrders(order.getLogistics_provider_id(), orderMap);	

				List<String> awbs = new ArrayList<String>();

				for(String awb: request.getParameter("awbs").split(":")){

					awbs.add(awb);

				}

			}else if(action.equals("getreport")){

		        String startDateStr = request.getParameter("startDate");

		        String endDateStr = request.getParameter("endDate");

		        DateFormat df = new SimpleDateFormat("dd/MM/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) {

		            error = "Please enter start and end dates in format MM/dd/yyyy";

		        } 

		        if(!error.equalsIgnoreCase("")){

					setId("report");

					return show();

		        }

		        ByteArrayOutputStream baos = generateCollectionReport(startDate, endDate, storeId);

		        if (baos == null) {

		            error = "No output for given date range";

		        } else {

		            error = "Generating report...";

		        }

		        response.setContentType("application/vnd.ms-excel");

		        response.setHeader("Content-disposition", "inline; filename=collection-report.xls");

		        ServletOutputStream sos;

		        try {

		            sos = response.getOutputStream();

		            baos.writeTo(sos);

		            sos.flush();

		            error = "Report generated";

		        } catch (IOException e) {

		            error = "Failed to write to response.";

		            logger.error("Unable to stream the colection report", e);

		        }

		        if(!error.equalsIgnoreCase("")){

					setId("report");

					return show();

		        }

    private ByteArrayOutputStream generateCollectionReport(Date startDate,	Date endDate, long storeId) throws TException {

    	List<Order> orders = client.getOrdersCollectionAtStore(storeId, startDate.getTime(), endDate.getTime(), false);

        ByteArrayOutputStream baosXLS = new ByteArrayOutputStream();

        Workbook wb = new HSSFWorkbook();

        DateFormat formatter = new SimpleDateFormat("dd-MMM-yyyy");

        Font font = wb.createFont();

        font.setBoldweight(Font.BOLDWEIGHT_BOLD);

        CellStyle style = wb.createCellStyle();

        style.setFont(font);

        DataFormat format = wb.createDataFormat();

        CellStyle styleAmount = wb.createCellStyle();

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

        Sheet collectionSheet = wb.createSheet("Collection");

        short collectionSerialNo = 0;

        Row headerRow = collectionSheet.createRow(collectionSerialNo++);

        headerRow.createCell(0).setCellValue("S.No");

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

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

        headerRow.createCell(3).setCellValue("Order Type");

        headerRow.createCell(4).setCellValue("Collection Date");

        headerRow.createCell(5).setCellValue("Order Amount");

        headerRow.createCell(6).setCellValue("Collected Amount");

        headerRow.createCell(7).setCellValue("Store Margin");

        for(Order order: orders){

        	Row contentRow = collectionSheet.createRow(collectionSerialNo++);

        	LineItem line = order.getLineitems().get(0);

        	String productName = line.getBrand() + " " + line.getModel_name() + " " + line.getModel_number() + " " + line.getColor();

        	productName = productName.replaceAll("null", "").replaceAll("  ", " ");

        	contentRow.createCell(0).setCellValue(collectionSerialNo-1);

        	contentRow.createCell(1).setCellValue(order.getId());

        	contentRow.createCell(2).setCellValue(productName);

        	contentRow.createCell(3).setCellValue(order.isCod() ? "COD" : "Prepaid");

        	contentRow.createCell(4).setCellValue(formatter.format(order.getDelivery_timestamp()));

        	contentRow.createCell(5).setCellValue(order.getTotal_amount());

        	contentRow.createCell(6).setCellValue(order.isCod() ? order.getTotal_amount() : 0.0);

        	contentRow.createCell(7).setCellValue(order.isCod() ? .01 * order.getTotal_amount() : .005 * order.getTotal_amount());

        }

        try {

            wb.write(baosXLS);

            baosXLS.close();

        } catch (IOException e) {

            logger.error("Error while streaming payment details report", e);

        }

		return baosXLS;

	}

    	String secretCode = "";