Subversion Repositories SmartDukaan

package in.shop2020.support.controllers;

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

import in.shop2020.model.v1.user.User;

import in.shop2020.model.v1.user.UserCommunication;

import in.shop2020.model.v1.user.UserContextException;

import in.shop2020.model.v1.user.UserContextService.Client;

import in.shop2020.thrift.clients.UserContextServiceClient;

import java.io.ByteArrayOutputStream;

import java.io.IOException;

import java.text.ParseException;

import java.util.Date;

import java.util.List;

import javax.servlet.ServletOutputStream;

import javax.servlet.http.HttpServletResponse;

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.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.struts2.interceptor.ServletResponseAware;

import org.apache.thrift.TException;

public class UserCommunicationsController implements ServletResponseAware{

	private HttpServletResponse response;

	private String errorMsg = "";

	@Override

	public void setServletResponse(HttpServletResponse res) {

		this.response = res;

	}

	public String index()	{

	    try   {

            UserContextServiceClient userContextServiceClient = new UserContextServiceClient();

            Client userClient = userContextServiceClient.getClient();

            //Retrieving all user communications

            List<UserCommunication> allCommunications = userClient.getAllUserCommunications();

            // Preparing XLS file for output

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

            response.setHeader("Content-disposition", "inline; filename=user-communications" + ".xls");

            ServletOutputStream sos;

            try {

                ByteArrayOutputStream baos = getSpreadSheetData(allCommunications, userClient);

                sos = response.getOutputStream();

                baos.writeTo(sos);

                sos.flush();

            } catch (IOException e) {

                errorMsg = "Failed to write to response.";

                e.printStackTrace();

            }

        } catch (ParseException e)  {

            errorMsg = e.getMessage();

            e.printStackTrace();

        } catch (TransactionServiceException e) {

            errorMsg = e.getMessage();

            e.printStackTrace();

        } catch (Exception e)   {

            errorMsg = e.getMessage();

            e.printStackTrace();

        }

        return null;

	}

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

	private ByteArrayOutputStream getSpreadSheetData(List<UserCommunication> allCommunications,

			Client userClient) 

	{

	    ByteArrayOutputStream baosXLS = new ByteArrayOutputStream();

		Workbook wb = new HSSFWorkbook();

	    Font font = wb.createFont();

	    font.setBoldweight(Font.BOLDWEIGHT_BOLD);

	    CellStyle style = wb.createCellStyle();

	    style.setFont(font);

	    CreationHelper createHelper = wb.getCreationHelper();

	    CellStyle dateCellStyle = wb.createCellStyle();

	    dateCellStyle.setDataFormat(createHelper.createDataFormat().getFormat("DD/MM/YYYY HH:MM"));

	    createAllUserCommunicationSheet(allCommunications, userClient, wb, style, dateCellStyle);

		// Write the workbook to the output stream

		try {

			wb.write(baosXLS);

			baosXLS.close();

		} catch (IOException e) {

			e.printStackTrace();

		}		

		return baosXLS;

	}

	private void createAllUserCommunicationSheet(

			List<UserCommunication> allCommunications, 

			Client userClient,

			Workbook wb, 

			CellStyle style, CellStyle dateCellStyle) 

	{

		// USER COMMUNICATION SHEET

	    Sheet commSheet = wb.createSheet("All Users Communications");

	    short commSerialNo = 0;

	    Row commTitleRow = commSheet.createRow(commSerialNo ++);

	    Cell commTitleCell = commTitleRow.createCell(0);

	    commTitleCell.setCellValue("All Users Communications");

	    commTitleCell.setCellStyle(style);

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

	    commSheet.createRow(commSerialNo ++);

	    Row commHeaderRow = commSheet.createRow(commSerialNo++);

	    commHeaderRow.createCell(0).setCellValue("User Email");

	    commHeaderRow.createCell(1).setCellValue("User Name");

	    commHeaderRow.createCell(2).setCellValue("Communication Email");

	    commHeaderRow.createCell(3).setCellValue("Date of Birth");

	    commHeaderRow.createCell(4).setCellValue("Mobile Number");

	    commHeaderRow.createCell(5).setCellValue("User Id");

	    commHeaderRow.createCell(6).setCellValue("Sex");

	    commHeaderRow.createCell(7).setCellValue("Order Id");

	    commHeaderRow.createCell(8).setCellValue("Communication Type");

	    commHeaderRow.createCell(9).setCellValue("AirwayBill No");

	    commHeaderRow.createCell(10).setCellValue("TimeStamp");

	    commHeaderRow.createCell(11).setCellValue("Product Name");

	    commHeaderRow.createCell(12).setCellValue("Reply To");

	    commHeaderRow.createCell(13).setCellValue("Subject");

	    commHeaderRow.createCell(14).setCellValue("Message");

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

	        commHeaderRow.getCell(i).setCellStyle(style);

	    }

		for( UserCommunication userComm : allCommunications) {

			commSerialNo++;

			Row commContentRow = commSheet.createRow(commSerialNo);

			try {

				User user = userClient.getUserById(userComm.getUserId());

				if (user.getUserId() != -1) {

					commContentRow.createCell(0).setCellValue(user.getEmail());

					commContentRow.createCell(1).setCellValue(user.getName());

					commContentRow.createCell(2).setCellValue(user.getCommunicationEmail());

					commContentRow.createCell(3).setCellValue(user.getDateOfBirth());

					commContentRow.createCell(4).setCellValue(user.getMobileNumber());

					commContentRow.createCell(5).setCellValue(user.getUserId());

					if (user.getSex() != null) {

						commContentRow.createCell(6).setCellValue(user.getSex().name());

					}

				}

			} catch (UserContextException e) {

				e.printStackTrace();

			} catch (TException e) {

				e.printStackTrace();

			}

			commContentRow.createCell(7).setCellValue(userComm.getOrderId());

			if (userComm.getCommunicationType() != null) {

				commContentRow.createCell(8).setCellValue(

						userComm.getCommunicationType().name());

			}

			commContentRow.createCell(9).setCellValue(userComm.getAirwaybillNo());

			commContentRow.createCell(10).setCellValue(new Date(userComm.getCommunication_timestamp()));

			commContentRow.getCell(10).setCellStyle(dateCellStyle);

			commContentRow.createCell(11).setCellValue(userComm.getProductName());

			commContentRow.createCell(12).setCellValue(userComm.getReplyTo());

			commContentRow.createCell(13).setCellValue(userComm.getSubject());

			commContentRow.createCell(14).setCellValue(userComm.getMessage());

		}

	}

	public String getErrorMsg() {

		return errorMsg;

	}

}