WebSVN – SmartDukaan – Diff – /trunk/Support/src/main/java/in/shop2020/support/controllers/UserOrdersController.java

 import in.shop2020.model.v1.order.Order;
 import in.shop2020.model.v1.order.Transaction;
 import in.shop2020.model.v1.order.TransactionServiceException;
 import in.shop2020.model.v1.user.Address;
 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.payments.Payment;
 import in.shop2020.thrift.clients.PaymentServiceClient;
 import in.shop2020.thrift.clients.TransactionServiceClient;
 import in.shop2020.thrift.clients.UserContextServiceClient;
 import java.io.UnsupportedEncodingException;
 import java.security.Principal;
 import java.text.DateFormat;
 import java.text.ParseException;
 import java.text.SimpleDateFormat;
-import java.util.ArrayList;
+import java.util.Collections;
 import java.util.Date;
 import java.util.Enumeration;
+import java.util.HashMap;
 import java.util.List;
 import java.util.Locale;
 import java.util.Map;
 import javax.servlet.RequestDispatcher;
 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.ServletRequestAware;
 import org.apache.struts2.interceptor.ServletResponseAware;
+import org.apache.thrift.TException;
 public class UserOrdersController implements ServletResponseAware, ServletRequestAware{
+	private static final DateFormat DATE_TIME_FORMAT = new SimpleDateFormat("dd/MM/yyyy HH:mm");
 	private HttpServletRequest request;
 	private HttpServletResponse response;
 	private String errorMsg = "";
 			UserContextServiceClient userContextServiceClient = new UserContextServiceClient();
 			Client userClient = userContextServiceClient.getClient();
 			PaymentServiceClient paymentServiceClient = new PaymentServiceClient();
 			in.shop2020.payments.PaymentService.Client paymentClient = paymentServiceClient.getClient();
 			User user = null;
 			if (email != null && !email.isEmpty()) {
 				user = userClient.getUserByEmail(email);
 				if(user.getUserId() == -1){
 				    errorMsg = "No user for this id.";
 			if (user == null) {
 				errorMsg = "Could not find user.";
 				return "report";
+			}
+			//Retrieving all user communications
+			List<UserCommunication> userCommunications = userClient.getUserCommunicationByUser(user.getUserId());
-			List <Transaction> transactions = new ArrayList<Transaction>();
+			List<UserCommunication> allCommunications = userClient.getAllUserCommunications();
 			//Retrieving all the transactions
-			transactions.addAll(transactionClient.getTransactionsForCustomer(user.getUserId(), 0, (new Date()).getTime(), null));
+			List <Transaction> transactions = transactionClient.getTransactionsForCustomer(user.getUserId(), 0, (new Date()).getTime(), null);
+			Collections.reverse(transactions);
 			System.out.println("Total number of Transaction: " + transactions.size());
-			List <Payment> payments = new ArrayList<Payment>();
 			//Retrieving all the payments
-			payments.addAll(paymentClient.getPaymentsForUser(user.getUserId(), 0,
+			List <Payment> payments = paymentClient.getPaymentsForUser(user.getUserId(), 0,
-						(new Date()).getTime(), null, 0));
+					(new Date()).getTime(), null, 0);
+			Map<Long, Payment> txnIdToPaymentMap = new HashMap<Long, Payment>();
+			for(Payment payment : payments) {
+				txnIdToPaymentMap.put(payment.getMerchantTxnId(), payment);
+			}
 			// Preparing XLS file for output
 			response.setContentType("application/vnd.ms-excel");
 			response.setHeader("Content-disposition", "inline; filename=user-orders" + ".xls");
 			ServletOutputStream sos;
 			try {
-				ByteArrayOutputStream baos = getSpreadSheetData(user, transactions, payments);
+				ByteArrayOutputStream baos = getSpreadSheetData(user,
+						transactions, txnIdToPaymentMap, userCommunications,
+						allCommunications, userClient);
 				sos = response.getOutputStream();
 				baos.writeTo(sos);
 				sos.flush();
 			} catch (IOException e) {
 				errorMsg = "Failed to write to response.";
+		}
 		return "report";
+	}
 	// Prepares the XLS worksheet object and fills in the data with proper formatting
-	private ByteArrayOutputStream getSpreadSheetData(User user, List<Transaction> transactions, List<Payment> payments)	{
+	private ByteArrayOutputStream getSpreadSheetData(User user,
+			List<Transaction> transactions,
+			Map<Long, Payment> txnIdToPaymentMap,
+			List<UserCommunication> userCommunications,
+			List<UserCommunication> allCommunications, Client userClient)
+	{
-		ByteArrayOutputStream baosXLS = new ByteArrayOutputStream();
+	    ByteArrayOutputStream baosXLS = new ByteArrayOutputStream();
-		DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
-	    Workbook wb = new HSSFWorkbook();
+		Workbook wb = new HSSFWorkbook();
 	    Font font = wb.createFont();
 	    font.setBoldweight(Font.BOLDWEIGHT_BOLD);
 	    CellStyle style = wb.createCellStyle();
 	    style.setFont(font);
-	    createUserSheet(user, wb, style);
+	    createUserSheet(user, userCommunications, wb, style);
-	    createTransactionSheet(transactions, wb, style, dateFormat);
+	    createTransactionSheet(transactions, txnIdToPaymentMap, wb, style);
-	    createPaymentSheet(payments, wb, style, dateFormat);
+	    createAllUserCommunicationSheet(allCommunications, userClient, wb, style);
 		// Write the workbook to the output stream
 		try {
 			wb.write(baosXLS);
 			baosXLS.close();
 			e.printStackTrace();
+		}
 		return baosXLS;
+	}
-	private void createPaymentSheet(List<Payment> payments, Workbook wb,
+	private void createAllUserCommunicationSheet(
+			List<UserCommunication> allCommunications,
+			Client userClient,
+			Workbook wb,
-			CellStyle style, DateFormat dateFormat)
+			CellStyle style)
+	{
-		// PAYMENT SHEET
+		// USER COMMUNICATION SHEET
-	    Sheet paymentSheet = wb.createSheet("Payment");
+	    Sheet commSheet = wb.createSheet("All Users Communications");
-	    short paymentSerialNo = 0;
+	    short commSerialNo = 0;
-	    Row orderTitleRow = paymentSheet.createRow(paymentSerialNo ++);
+	    Row commTitleRow = commSheet.createRow(commSerialNo ++);
-	    Cell orderTitleCell = orderTitleRow.createCell(0);
+	    Cell commTitleCell = commTitleRow.createCell(0);
-	    orderTitleCell.setCellValue("User Payments");
+	    commTitleCell.setCellValue("All Users Communications");
-	    orderTitleCell.setCellStyle(style);
+	    commTitleCell.setCellStyle(style);
-	    paymentSheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 6));
-	    paymentSheet.createRow(paymentSerialNo ++);
+	    commSheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 6));
+	    commSheet.createRow(commSerialNo ++);
-	    Row orderHeaderRow = paymentSheet.createRow(paymentSerialNo ++);
+	    Row commHeaderRow = commSheet.createRow(commSerialNo++);
-	    orderHeaderRow.createCell(0).setCellValue("Transaction Id");
+	    commHeaderRow.createCell(0).setCellValue("User Email");
-	    orderHeaderRow.createCell(1).setCellValue("Payment Id");
+	    commHeaderRow.createCell(1).setCellValue("User Name");
-	    orderHeaderRow.createCell(2).setCellValue("Payment Status");
+	    commHeaderRow.createCell(2).setCellValue("Communication Email");
-	    orderHeaderRow.createCell(3).setCellValue("Gateway Payment Id");
+	    commHeaderRow.createCell(3).setCellValue("Date of Birth");
-	    orderHeaderRow.createCell(4).setCellValue("Gateway Transaction Date");
+	    commHeaderRow.createCell(4).setCellValue("Mobile Number");
-	    orderHeaderRow.createCell(5).setCellValue("Gateway Txn Id");
+	    commHeaderRow.createCell(5).setCellValue("User Id");
-	    orderHeaderRow.createCell(6).setCellValue("Gateway Txn Status");
+	    commHeaderRow.createCell(6).setCellValue("Sex");
-	    orderHeaderRow.createCell(7).setCellValue("Reference Code");
+	    commHeaderRow.createCell(7).setCellValue("Order Id");
+	    commHeaderRow.createCell(8).setCellValue("Communication Type");
-	    orderHeaderRow.createCell(8).setCellValue("Gateway Id");
+	    commHeaderRow.createCell(9).setCellValue("AirwayBill No");
-	    orderHeaderRow.createCell(9).setCellValue("Amount");
+	    commHeaderRow.createCell(10).setCellValue("TimeStamp");
+	    commHeaderRow.createCell(11).setCellValue("Product Name");
-	    orderHeaderRow.createCell(10).setCellValue("Description");
+	    commHeaderRow.createCell(12).setCellValue("Reply To");
-	    orderHeaderRow.createCell(11).setCellValue("Auth Code");
+	    commHeaderRow.createCell(13).setCellValue("Subject");
-	    orderHeaderRow.createCell(12).setCellValue("Error Code");
+	    commHeaderRow.createCell(14).setCellValue("Message");
-		for (Payment payment : payments) {
+		for( UserCommunication userComm : allCommunications) {
-			paymentSerialNo++;
+			commSerialNo++;
-			Row contentRow = paymentSheet.createRow(paymentSerialNo);
+			Row commContentRow = commSheet.createRow(commSerialNo);
+			try {
+				User user = userClient.getUserById(userComm.getUserId());
+				if (user.getUserId() == -1) {
-			contentRow.createCell(0).setCellValue(payment.getMerchantTxnId());
+					commContentRow.createCell(0).setCellValue(user.getEmail());
-			contentRow.createCell(1).setCellValue(payment.getPaymentId());
+					commContentRow.createCell(1).setCellValue(user.getName());
-			contentRow.createCell(2).setCellValue(payment.getStatus().name());
+					commContentRow.createCell(2).setCellValue(user.getCommunicationEmail());
-			contentRow.createCell(3)
+					commContentRow.createCell(3).setCellValue(user.getDateOfBirth());
+					commContentRow.createCell(4).setCellValue(user.getMobileNumber());
-					.setCellValue(payment.getGatewayPaymentId());
+					commContentRow.createCell(5).setCellValue(user.getUserId());
+					if (user.getSex() != null) {
-			contentRow.createCell(4).setCellValue(payment.getGatewayTxnDate());
+						commContentRow.createCell(6).setCellValue(user.getSex().name());
+					}
+				}
+			} catch (UserContextException e) {
+				e.printStackTrace();
+			} catch (TException e) {
+				e.printStackTrace();
+			}
-			contentRow.createCell(5).setCellValue(payment.getGatewayTxnId());
+			commContentRow.createCell(7).setCellValue(userComm.getOrderId());
+			if (userComm.getCommunicationType() != null) {
-			contentRow.createCell(6)
+				commContentRow.createCell(8).setCellValue(
-					.setCellValue(payment.getGatewayTxnStatus());
+						userComm.getCommunicationType().name());
+			}
-			contentRow.createCell(7).setCellValue(payment.getReferenceCode());
+			commContentRow.createCell(9).setCellValue(userComm.getAirwaybillNo());
-			contentRow.createCell(8).setCellValue(payment.getGatewayId());
+			commContentRow.createCell(10).setCellValue(DATE_TIME_FORMAT.format(userComm.getCommunication_timestamp()));
-			contentRow.createCell(9).setCellValue(payment.getAmount());
+			commContentRow.createCell(11).setCellValue(userComm.getProductName());
-			contentRow.createCell(10).setCellValue(payment.getDescription());
+			commContentRow.createCell(12).setCellValue(userComm.getReplyTo());
-			contentRow.createCell(11).setCellValue(payment.getAuthCode());
+			commContentRow.createCell(13).setCellValue(userComm.getSubject());
-			contentRow.createCell(12).setCellValue(payment.getErrorCode());
+			commContentRow.createCell(14).setCellValue(userComm.getMessage());
+		}
+	}
-	private void createTransactionSheet(List<Transaction> transactions, Workbook wb, CellStyle style, DateFormat dateFormat) {
+	private void createTransactionSheet(List<Transaction> transactions, Map<Long, Payment> txnIdToPaymentMap, Workbook wb, CellStyle style) {
 		// TRANSACTION SHEET
-	    Sheet transactionSheet = wb.createSheet("Transaction");
+	    Sheet transactionSheet = wb.createSheet("Transactions and Payments");
 	    short transactionSerialNo = 0;
 	    Row orderTitleRow = transactionSheet.createRow(transactionSerialNo ++);
 	    Cell orderTitleCell = orderTitleRow.createCell(0);
-	    orderTitleCell.setCellValue("User Transactions");
+	    orderTitleCell.setCellValue("User Transactions and Payments");
 	    orderTitleCell.setCellStyle(style);
 	    transactionSheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 6));
 	    transactionSheet.createRow(transactionSerialNo ++);
 	    orderHeaderRow.createCell(2).setCellValue("Transaction Status");
 	    orderHeaderRow.createCell(3).setCellValue("Order Id");
 	    orderHeaderRow.createCell(4).setCellValue("Billing Number");
 	    orderHeaderRow.createCell(5).setCellValue("Billing Date");
 	    orderHeaderRow.createCell(6).setCellValue("Order Status");
 	    orderHeaderRow.createCell(7).setCellValue("Brand");
 	    orderHeaderRow.createCell(8).setCellValue("Model Name");
 	    orderHeaderRow.createCell(9).setCellValue("Model Number");
 	    orderHeaderRow.createCell(10).setCellValue("Color");
 	    orderHeaderRow.createCell(11).setCellValue("Quantity");
 	    orderHeaderRow.createCell(12).setCellValue("Unit Price");
 	    orderHeaderRow.createCell(13).setCellValue("Total Price");
 	    orderHeaderRow.createCell(14).setCellValue("User Id");
 	    orderHeaderRow.createCell(15).setCellValue("Name");
 	    orderHeaderRow.createCell(16).setCellValue("Address1");
 	    orderHeaderRow.createCell(17).setCellValue("Address2");
 	    orderHeaderRow.createCell(17).setCellValue("City");
 	    orderHeaderRow.createCell(19).setCellValue("State");
 	    orderHeaderRow.createCell(20).setCellValue("Pin Code");
 	    orderHeaderRow.createCell(21).setCellValue("Mobile Number");
 	    orderHeaderRow.createCell(22).setCellValue("email");
 	    orderHeaderRow.createCell(23).setCellValue("Airway Bill No.");
 	    orderHeaderRow.createCell(24).setCellValue("Billed By");
 	    orderHeaderRow.createCell(25).setCellValue("Receiver");
 	    orderHeaderRow.createCell(26).setCellValue("Tracking Id");
 	    orderHeaderRow.createCell(27).setCellValue("Accepted Timestamp");
 	    orderHeaderRow.createCell(28).setCellValue("Delivery Timestamp");
 	    orderHeaderRow.createCell(29).setCellValue("Expected Delivery Time");
+	    orderHeaderRow.createCell(30).setCellValue("Payment Id");
+	    orderHeaderRow.createCell(31).setCellValue("Payment Status");
+	    orderHeaderRow.createCell(32).setCellValue("Gateway Payment Id");
+	    orderHeaderRow.createCell(33).setCellValue("Gateway Transaction Date");
+	    orderHeaderRow.createCell(34).setCellValue("Gateway Txn Id");
+	    orderHeaderRow.createCell(35).setCellValue("Gateway Txn Status");
+	    orderHeaderRow.createCell(36).setCellValue("Reference Code");
+	    orderHeaderRow.createCell(37).setCellValue("Gateway Id");
+	    orderHeaderRow.createCell(38).setCellValue("Amount");
+	    orderHeaderRow.createCell(39).setCellValue("Description");
+	    orderHeaderRow.createCell(40).setCellValue("Auth Code");
+	    orderHeaderRow.createCell(41).setCellValue("Error Code");
 	    for(Transaction transaction : transactions)	{
 	    	List<Order> orders = transaction.getOrders();
 	    	Date transactionDate = new Date(transaction.getCreatedOn());
 	    	long transactionId = transaction.getId();
 	    	String transactionStatus = transaction.getStatusDescription();
 	    	for(Order order : orders)	{
 		    	transactionSerialNo ++;
 		    	Row contentRow = transactionSheet.createRow(transactionSerialNo);
 			    LineItem lineItem = order.getLineitems().get(0);
+			    Payment payment = txnIdToPaymentMap.get(transactionId);
 			    contentRow.createCell(0).setCellValue(transactionId);
-			    contentRow.createCell(1).setCellValue(dateFormat.format(transactionDate));
+			    contentRow.createCell(1).setCellValue(DATE_TIME_FORMAT.format(transactionDate));
 			    contentRow.createCell(2).setCellValue(transactionStatus);
 			    contentRow.createCell(3).setCellValue(order.getId());
 			    contentRow.createCell(4).setCellValue(order.getInvoice_number());
-			    contentRow.createCell(5).setCellValue(dateFormat.format(new Date(order.getBilling_timestamp())));
+			    contentRow.createCell(5).setCellValue(DATE_TIME_FORMAT.format(new Date(order.getBilling_timestamp())));
 			    contentRow.createCell(6).setCellValue(order.getStatusDescription());
 			    contentRow.createCell(7).setCellValue(getValueForEmptyString(lineItem.getBrand()));
 			    contentRow.createCell(8).setCellValue(getValueForEmptyString(lineItem.getModel_name()));
 			    contentRow.createCell(9).setCellValue(getValueForEmptyString(lineItem.getModel_number()));
 			    contentRow.createCell(10).setCellValue(getValueForEmptyString(lineItem.getColor()));
 			    contentRow.createCell(11).setCellValue(lineItem.getQuantity());
 			    contentRow.createCell(12).setCellValue(lineItem.getUnit_price());
 			    contentRow.createCell(13).setCellValue(lineItem.getTotal_price());
 			    contentRow.createCell(14).setCellValue(order.getCustomer_id());
 			    contentRow.createCell(15).setCellValue(order.getCustomer_name());
 			    contentRow.createCell(16).setCellValue(order.getCustomer_address1());
 			    contentRow.createCell(17).setCellValue(order.getCustomer_address2());
 			    contentRow.createCell(18).setCellValue(order.getCustomer_city());
 			    contentRow.createCell(19).setCellValue(order.getCustomer_state());
 			    contentRow.createCell(20).setCellValue(order.getCustomer_pincode());
 			    contentRow.createCell(21).setCellValue(order.getCustomer_mobilenumber());
 			    contentRow.createCell(22).setCellValue(order.getCustomer_email());
 			    contentRow.createCell(23).setCellValue(order.getAirwaybill_no());
 			    contentRow.createCell(24).setCellValue(order.getBilled_by());
 			    contentRow.createCell(25).setCellValue(order.getReceiver());
 			    contentRow.createCell(26).setCellValue(order.getTracking_id());
-			    contentRow.createCell(27).setCellValue(dateFormat.format(new Date(order.getAccepted_timestamp())));
+			    contentRow.createCell(27).setCellValue(DATE_TIME_FORMAT.format(new Date(order.getAccepted_timestamp())));
-			    contentRow.createCell(28).setCellValue(dateFormat.format(new Date(order.getDelivery_timestamp())));
+			    contentRow.createCell(28).setCellValue(DATE_TIME_FORMAT.format(new Date(order.getDelivery_timestamp())));
-			    contentRow.createCell(29).setCellValue(dateFormat.format(new Date(order.getExpected_delivery_time())));
+			    contentRow.createCell(29).setCellValue(DATE_TIME_FORMAT.format(new Date(order.getExpected_delivery_time())));
+				if (payment != null) {
+					contentRow.createCell(30).setCellValue(payment.getPaymentId());
+					contentRow.createCell(31).setCellValue(payment.getStatus().name());
+					contentRow.createCell(32).setCellValue(payment.getGatewayPaymentId());
+					contentRow.createCell(33).setCellValue(payment.getGatewayTxnDate());
+					contentRow.createCell(34).setCellValue(payment.getGatewayTxnId());
+					contentRow.createCell(35).setCellValue(payment.getGatewayTxnStatus());
+					contentRow.createCell(36).setCellValue(payment.getReferenceCode());
+					contentRow.createCell(37).setCellValue(payment.getGatewayId());
+					contentRow.createCell(38).setCellValue(payment.getAmount());
+					contentRow.createCell(39).setCellValue(payment.getDescription());
+					contentRow.createCell(40).setCellValue(payment.getAuthCode());
+					contentRow.createCell(41).setCellValue(payment.getErrorCode());
+				}
+		    }
+	    }
+	}
 	private String getValueForEmptyString(String s){
 			return "-";
 		else
 			return s;
+	}
-	private void createUserSheet(User user, Workbook wb, CellStyle style) {
+	private void createUserSheet(User user, List<UserCommunication> userCommunications, Workbook wb, CellStyle style) {
 	    Sheet userSheet = wb.createSheet("User");
 	    short userSerialNo = 0;
     	// Create the header row and put all the titles in it. Rows are 0 based.
 	    Row titleRow = userSheet.createRow(userSerialNo++);
 					userSerialNo, 0, 6));
 			userContentRow.createCell(0).setCellValue("Other Addresses");
 			for (Address address : user.getAddresses()) {
 				if (user.getDefaultAddressId() != address.getId()) {
 					userSerialNo++;
 					userContentRow = userSheet.createRow(userSerialNo);
 					userContentRow.createCell(0)
 							.setCellValue(address.getName());
 					userContentRow.createCell(1).setCellValue(
 					userContentRow.createCell(5).setCellValue(address.getPin());
 					userContentRow.createCell(6).setCellValue(
 							address.getPhone());
+				}
+			}
-		}
-	}
-	public static void main(String[] args){
-		UserOrdersController usc = new UserOrdersController();
-		usc.request = new HttpServletRequest() {
-			@Override
-			public void setCharacterEncoding(String arg0)
-					throws UnsupportedEncodingException {
-				// TODO Auto-generated method stub
-			}
-			@Override
-			public void setAttribute(String arg0, Object arg1) {
-				// TODO Auto-generated method stub
-			}
-			@Override
-			public void removeAttribute(String arg0) {
-				// TODO Auto-generated method stub
-			}
-			@Override
-			public boolean isSecure() {
-				// TODO Auto-generated method stub
-				return false;
-			}
-			@Override
-			public int getServerPort() {
-				// TODO Auto-generated method stub
-				return 0;
-			}
-			@Override
-			public String getServerName() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getScheme() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public RequestDispatcher getRequestDispatcher(String arg0) {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public int getRemotePort() {
-				// TODO Auto-generated method stub
-				return 0;
-			}
-			@Override
-			public String getRemoteHost() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getRemoteAddr() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getRealPath(String arg0) {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public BufferedReader getReader() throws IOException {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getProtocol() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String[] getParameterValues(String arg0) {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public Enumeration getParameterNames() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public Map getParameterMap() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getParameter(String arg0) {
-				return "test@test.com";
-			}
-			@Override
-			public Enumeration getLocales() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public Locale getLocale() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public int getLocalPort() {
-				// TODO Auto-generated method stub
-				return 0;
-			}
-			@Override
-			public String getLocalName() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getLocalAddr() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public ServletInputStream getInputStream() throws IOException {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getContentType() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public int getContentLength() {
-				// TODO Auto-generated method stub
-				return 0;
-			}
-			@Override
-			public String getCharacterEncoding() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public Enumeration getAttributeNames() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public Object getAttribute(String arg0) {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public boolean isUserInRole(String arg0) {
-				// TODO Auto-generated method stub
-				return false;
-			}
-			@Override
-			public boolean isRequestedSessionIdValid() {
-				// TODO Auto-generated method stub
-				return false;
-			}
-			@Override
-			public boolean isRequestedSessionIdFromUrl() {
-				// TODO Auto-generated method stub
-				return false;
-			}
-			@Override
-			public boolean isRequestedSessionIdFromURL() {
-				// TODO Auto-generated method stub
-				return false;
-			}
-			@Override
-			public boolean isRequestedSessionIdFromCookie() {
-				// TODO Auto-generated method stub
-				return false;
-			}
-			@Override
-			public Principal getUserPrincipal() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public HttpSession getSession(boolean arg0) {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public HttpSession getSession() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getServletPath() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getRequestedSessionId() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public StringBuffer getRequestURL() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getRequestURI() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getRemoteUser() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getQueryString() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getPathTranslated() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getPathInfo() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public String getMethod() {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
-			public int getIntHeader(String arg0) {
-				// TODO Auto-generated method stub
-				return 0;
-			}
-			@Override
-			public Enumeration getHeaders(String arg0) {
-				// TODO Auto-generated method stub
-				return null;
-			}
-			@Override
+			userSerialNo+=2;
-			public Enumeration getHeaderNames() {
+			userContentRow = userSheet.createRow(userSerialNo);
-				// TODO Auto-generated method stub
+			userSheet.addMergedRegion(new CellRangeAddress(userSerialNo,
-				return null;
+					userSerialNo, 0, 6));
-			}
+			userContentRow.createCell(0).setCellValue("User Communication");
-			@Override
+			userSerialNo++;
-			public String getHeader(String arg0) {
+			Row commHeaderRow = userSheet.createRow(userSerialNo);
-				// TODO Auto-generated method stub
+		    commHeaderRow.createCell(0).setCellValue("Order Id");
-				return null;
+		    commHeaderRow.createCell(1).setCellValue("Communication Type");
-			}
-			@Override
-			public long getDateHeader(String arg0) {
+		    commHeaderRow.createCell(2).setCellValue("AirwayBill No");
-				// TODO Auto-generated method stub
+		    commHeaderRow.createCell(3).setCellValue("TimeStamp");
-				return 0;
+		    commHeaderRow.createCell(4).setCellValue("Product Name");
-			}
-			@Override
-			public Cookie[] getCookies() {
+		    commHeaderRow.createCell(5).setCellValue("Reply To");
-				// TODO Auto-generated method stub
+		    commHeaderRow.createCell(6).setCellValue("Subject");
-				return null;
+		    commHeaderRow.createCell(7).setCellValue("Message");
-			}
+			for( UserCommunication userComm : userCommunications) {
-			@Override
+				userSerialNo++;
-			public String getContextPath() {
+				userContentRow = userSheet.createRow(userSerialNo);
-				// TODO Auto-generated method stub
+				userContentRow.createCell(0).setCellValue(userComm.getOrderId());
-				return null;
+				if (userComm.getCommunicationType() != null) {
+					userContentRow.createCell(1).setCellValue(userComm.getCommunicationType().name());
-			}
+				}
+				userContentRow.createCell(2).setCellValue(userComm.getAirwaybillNo());
+				userContentRow.createCell(3).setCellValue(DATE_TIME_FORMAT.format(userComm.getCommunication_timestamp()));
-			@Override
+				userContentRow.createCell(4).setCellValue(userComm.getProductName());
-			public String getAuthType() {
+				userContentRow.createCell(5).setCellValue(userComm.getReplyTo());
-				// TODO Auto-generated method stub
+				userContentRow.createCell(6).setCellValue(userComm.getSubject());
-				return null;
+				userContentRow.createCell(7).setCellValue(userComm.getMessage());
+			}
-		};
+		}
-		usc.create();
+	}
 	public String getErrorMsg() {
 		return errorMsg;
+	}
 }

Subversion Repositories SmartDukaan

(root)/trunk/Support/src/main/java/in/shop2020/support/controllers/UserOrdersController.java – Rev 1514 → 1608