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

 import javax.servlet.http.HttpSession;
 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 UserOrdersController implements ServletResponseAware, ServletRequestAware{
-	private static final DateFormat DATE_TIME_FORMAT = new SimpleDateFormat("dd/MM/yyyy HH:mm");
+	//private static final DateFormat DATE_TIME_FORMAT = new SimpleDateFormat("yyyy/MM/dd HH:mm");
 	private HttpServletRequest request;
 	private HttpServletResponse response;
 	private String errorMsg = "";
-	public UserOrdersController(){
-	}
 	@Override
 	public void setServletRequest(HttpServletRequest req) {
 		this.request = req;
+	}
 				return "report";
+			}
 			//Retrieving all user communications
 			List<UserCommunication> userCommunications = userClient.getUserCommunicationByUser(user.getUserId());
-			List<UserCommunication> allCommunications = userClient.getAllUserCommunications();
 			//Retrieving all the transactions
 			List <Transaction> transactions = transactionClient.getTransactionsForCustomer(user.getUserId(), 0, (new Date()).getTime(), null);
 			Collections.reverse(transactions);
-			System.out.println("Total number of Transaction: " + transactions.size());
 			//Retrieving all the payments
 			List <Payment> payments = paymentClient.getPaymentsForUser(user.getUserId(), 0,
 					(new Date()).getTime(), null, 0);
 			Map<Long, Payment> txnIdToPaymentMap = new HashMap<Long, Payment>();
 			response.setHeader("Content-disposition", "inline; filename=user-orders" + ".xls");
 			ServletOutputStream sos;
 			try {
 				ByteArrayOutputStream baos = getSpreadSheetData(user,
-						transactions, txnIdToPaymentMap, userCommunications,
+						transactions, txnIdToPaymentMap, userCommunications, userClient);
-						allCommunications, userClient);
 				sos = response.getOutputStream();
 				baos.writeTo(sos);
 				sos.flush();
 			} catch (IOException e) {
 				errorMsg = "Failed to write to response.";
 	// Prepares the XLS worksheet object and fills in the data with proper formatting
 	private ByteArrayOutputStream getSpreadSheetData(User user,
 			List<Transaction> transactions,
 			Map<Long, Payment> txnIdToPaymentMap,
 			List<UserCommunication> userCommunications,
-			List<UserCommunication> allCommunications, Client userClient)
+			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);
-	    createUserSheet(user, userCommunications, wb, style);
+	    CreationHelper createHelper = wb.getCreationHelper();
+	    CellStyle dateCellStyle = wb.createCellStyle();
+	    dateCellStyle.setDataFormat(createHelper.createDataFormat().getFormat("DD/MM/YYYY HH:MM"));
-	    createTransactionSheet(transactions, txnIdToPaymentMap, wb, style);
+	    createUserSheet(user, userCommunications, wb, style, dateCellStyle);
-	    createAllUserCommunicationSheet(allCommunications, userClient, wb, style);
+	    createTransactionSheet(transactions, txnIdToPaymentMap, 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)
-	{
-		// 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( 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(DATE_TIME_FORMAT.format(userComm.getCommunication_timestamp()));
-			commContentRow.createCell(11).setCellValue(userComm.getProductName());
-			commContentRow.createCell(12).setCellValue(userComm.getReplyTo());
-			commContentRow.createCell(13).setCellValue(userComm.getSubject());
-			commContentRow.createCell(14).setCellValue(userComm.getMessage());
-		}
-	}
-	private void createTransactionSheet(List<Transaction> transactions, Map<Long, Payment> txnIdToPaymentMap, Workbook wb, CellStyle style) {
+	private void createTransactionSheet(List<Transaction> transactions, Map<Long, Payment> txnIdToPaymentMap, Workbook wb, CellStyle style, CellStyle dateCellStyle) {
 		// TRANSACTION SHEET
 	    Sheet transactionSheet = wb.createSheet("Transactions and Payments");
 	    short transactionSerialNo = 0;
 	    Row orderTitleRow = transactionSheet.createRow(transactionSerialNo ++);
 	    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(18).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(38).setCellValue("Amount");
 	    orderHeaderRow.createCell(39).setCellValue("Description");
 	    orderHeaderRow.createCell(40).setCellValue("Auth Code");
 	    orderHeaderRow.createCell(41).setCellValue("Error Code");
+	    for (int i=0; i<42 ;i++) {
+            orderHeaderRow.getCell(i).setCellStyle(style);
+        }
 	    for(Transaction transaction : transactions)	{
 	    	List<Order> orders = transaction.getOrders();
 	    	Date transactionDate = new Date(transaction.getCreatedOn());
 	    	long transactionId = transaction.getId();
 	    	String transactionStatus = transaction.getStatusDescription();
 		    	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(DATE_TIME_FORMAT.format(transactionDate));
+			    contentRow.createCell(1).setCellValue(transactionDate);
+			    contentRow.getCell(1).setCellStyle(dateCellStyle);
 			    contentRow.createCell(2).setCellValue(transactionStatus);
 			    contentRow.createCell(3).setCellValue(order.getId());
 			    contentRow.createCell(4).setCellValue(order.getInvoice_number());
-			    contentRow.createCell(5).setCellValue(DATE_TIME_FORMAT.format(new Date(order.getBilling_timestamp())));
+			    contentRow.createCell(5).setCellValue(order.getBilling_timestamp());
+			    contentRow.getCell(5).setCellStyle(dateCellStyle);
 			    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(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(DATE_TIME_FORMAT.format(new Date(order.getAccepted_timestamp())));
+			    contentRow.createCell(27).setCellValue(order.getAccepted_timestamp());
+			    contentRow.getCell(27).setCellStyle(dateCellStyle);
-			    contentRow.createCell(28).setCellValue(DATE_TIME_FORMAT.format(new Date(order.getDelivery_timestamp())));
+			    contentRow.createCell(28).setCellValue(order.getDelivery_timestamp());
+			    contentRow.getCell(28).setCellStyle(dateCellStyle);
-			    contentRow.createCell(29).setCellValue(DATE_TIME_FORMAT.format(new Date(order.getExpected_delivery_time())));
+			    contentRow.createCell(29).setCellValue(order.getExpected_delivery_time());
+			    contentRow.getCell(29).setCellStyle(dateCellStyle);
 				if (payment != null) {
 					contentRow.createCell(30).setCellValue(payment.getPaymentId());
 					contentRow.createCell(31).setCellValue(payment.getStatus().name());
 					contentRow.createCell(32).setCellValue(payment.getGatewayPaymentId());
 			return "-";
 		else
 			return s;
+	}
-	private void createUserSheet(User user, List<UserCommunication> userCommunications, Workbook wb, CellStyle style) {
+	private void createUserSheet(User user, List<UserCommunication> userCommunications, Workbook wb, CellStyle style, CellStyle dateCellStyle) {
 	    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++);
 	    userHeaderRow.createCell(2).setCellValue("Communication Email");
 	    userHeaderRow.createCell(3).setCellValue("Date Of Birth");
 	    userHeaderRow.createCell(4).setCellValue("Mobile Number");
 	    userHeaderRow.createCell(5).setCellValue("Sex");
 	    userHeaderRow.createCell(6).setCellValue("User Id");
+	    for (int i=0; i<7 ;i++) {
+            userHeaderRow.getCell(i).setCellStyle(style);
+        }
 	    Row userContentRow = userSheet.createRow(userSerialNo++);
     	userContentRow.createCell(0).setCellValue(user.getName());
     	userContentRow.createCell(1).setCellValue(user.getEmail());
 	    addressHeaderRow.createCell(2).setCellValue("Line2");
 	    addressHeaderRow.createCell(3).setCellValue("City");
 	    addressHeaderRow.createCell(4).setCellValue("State");
 	    addressHeaderRow.createCell(5).setCellValue("Pincode");
 	    addressHeaderRow.createCell(6).setCellValue("Phone");
+	    for (int i=0; i<7 ;i++) {
+            addressHeaderRow.getCell(i).setCellStyle(style);
+        }
 		List<Address> user_addresses = user.getAddresses();
 		if (user_addresses != null && !user_addresses.isEmpty()) {
 			for (Address address : user.getAddresses()) {
 				if (user.getDefaultAddressId() == address.getId()) {
 					userContentRow = userSheet.createRow(userSerialNo);
 					userSheet.addMergedRegion(new CellRangeAddress(
 							userSerialNo, userSerialNo, 0, 6));
 					userContentRow.createCell(0)
 							.setCellValue("Primary Address");
+					userContentRow.getCell(0).setCellStyle(style);
 					userSerialNo++;
 					userContentRow = userSheet.createRow(userSerialNo);
 					userContentRow.createCell(0)
 							.setCellValue(address.getName());
 			userContentRow = userSheet.createRow(userSerialNo);
 			userSheet.addMergedRegion(new CellRangeAddress(userSerialNo,
 					userSerialNo, 0, 6));
 			userContentRow.createCell(0).setCellValue("Other Addresses");
+			userContentRow.getCell(0).setCellStyle(style);
 			for (Address address : user.getAddresses()) {
 				if (user.getDefaultAddressId() != address.getId()) {
 					userSerialNo++;
 					userContentRow = userSheet.createRow(userSerialNo);
 			userSerialNo+=2;
 			userContentRow = userSheet.createRow(userSerialNo);
 			userSheet.addMergedRegion(new CellRangeAddress(userSerialNo,
 					userSerialNo, 0, 6));
 			userContentRow.createCell(0).setCellValue("User Communication");
+			userContentRow.getCell(0).setCellStyle(style);
 			userSerialNo++;
 			Row commHeaderRow = userSheet.createRow(userSerialNo);
 		    commHeaderRow.createCell(0).setCellValue("Order Id");
 		    commHeaderRow.createCell(1).setCellValue("Communication Type");
 		    commHeaderRow.createCell(2).setCellValue("AirwayBill No");
 		    commHeaderRow.createCell(3).setCellValue("TimeStamp");
 		    commHeaderRow.createCell(4).setCellValue("Product Name");
 		    commHeaderRow.createCell(5).setCellValue("Reply To");
 		    commHeaderRow.createCell(6).setCellValue("Subject");
 		    commHeaderRow.createCell(7).setCellValue("Message");
+		    for (int i=0; i<8 ;i++) {
+	            commHeaderRow.getCell(i).setCellStyle(style);
+	        }
 			for( UserCommunication userComm : userCommunications) {
 				userSerialNo++;
 				userContentRow = userSheet.createRow(userSerialNo);
 				userContentRow.createCell(0).setCellValue(userComm.getOrderId());
 				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()));
+				userContentRow.createCell(3).setCellValue(userComm.getCommunication_timestamp());
+				userContentRow.createCell(3).setCellStyle(dateCellStyle);
 				userContentRow.createCell(4).setCellValue(userComm.getProductName());
 				userContentRow.createCell(5).setCellValue(userComm.getReplyTo());
 				userContentRow.createCell(6).setCellValue(userComm.getSubject());
 				userContentRow.createCell(7).setCellValue(userComm.getMessage());
+			}

Subversion Repositories SmartDukaan

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