WebSVN – SmartDukaan – Diff – /trunk/Support/src/main/java/in/shop2020/support/services/PaymentDetailsGenerator.java

 package in.shop2020.support.services;
 import in.shop2020.model.v1.order.LineItem;
 import in.shop2020.model.v1.order.Order;
 import in.shop2020.model.v1.order.TransactionServiceException;
+import in.shop2020.payments.Attribute;
+import in.shop2020.payments.Constants;
 import in.shop2020.payments.Payment;
 import in.shop2020.payments.PaymentException;
 import in.shop2020.payments.PaymentGateway;
 import in.shop2020.payments.PaymentStatus;
 import in.shop2020.thrift.clients.PaymentServiceClient;
         paymentSheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 6));
         paymentSheet.createRow(paymentSerialNo++);
+        final int S_NO = 0, PAYMENT_ID = 1, GATEWAY = 2, PAYMENT_METHOD = 3, TXN_ID = 4, AMOUNT = 5, PAY_STATUS = 6,
+                  PAY_STATUS_DESC = 7, TXN_STATUS = 8, REF_CODE = 9, TXN_TIME = 10, CUST_ID = 11, NAME = 12,
+                  MOB_NO = 13, ADDR = 14, PINCODE = 15, CITY = 16, STATE = 17, EMAIL = 18, ORDER_ID = 19, ORDER_STATUS = 20,
+                  ORDER_STATUS_DESC = 21, ITEM_ID = 22, PROD_GRP = 23, BRAND = 24, MOD_NAME = 25, MOD_NUM = 26, QTY = 27;
         Row headerRow = paymentSheet.createRow(paymentSerialNo++);
+        headerRow.createCell(S_NO).setCellValue("S.No");
-        headerRow.createCell(0).setCellValue("Payment Id");
+        headerRow.createCell(PAYMENT_ID).setCellValue("Payment Id");
-        headerRow.createCell(1).setCellValue("Gateway");
+        headerRow.createCell(GATEWAY).setCellValue("Gateway");
+        headerRow.createCell(PAYMENT_METHOD).setCellValue("Payment Method");
+        headerRow.getCell(PAYMENT_METHOD).setCellStyle(styleWT);
-        headerRow.createCell(2).setCellValue("Txn Id");
+        headerRow.createCell(TXN_ID).setCellValue("Txn Id");
-        headerRow.createCell(3).setCellValue("Amount");
+        headerRow.createCell(AMOUNT).setCellValue("Amount");
-        headerRow.createCell(4).setCellValue("Payment Status");
+        headerRow.createCell(PAY_STATUS).setCellValue("Payment Status");
-        headerRow.createCell(5).setCellValue("Payment Status Description");
+        headerRow.createCell(PAY_STATUS_DESC).setCellValue("Payment Status Description");
+        headerRow.getCell(PAY_STATUS_DESC).setCellStyle(styleWT);
-        headerRow.createCell(6).setCellValue("Gateway Txn Status");
+        headerRow.createCell(TXN_STATUS).setCellValue("Gateway Txn Status");
-        headerRow.createCell(7).setCellValue("Reference Code");
+        headerRow.createCell(REF_CODE).setCellValue("Reference Code");
-        headerRow.createCell(8).setCellValue("Transaction Time");
+        headerRow.createCell(TXN_TIME).setCellValue("Transaction Time");
-        headerRow.createCell(9).setCellValue("Customer Id");
+        headerRow.createCell(CUST_ID).setCellValue("Customer Id");
-        headerRow.createCell(10).setCellValue("Name");
+        headerRow.createCell(NAME).setCellValue("Name");
-        headerRow.createCell(11).setCellValue("MobileNo");
+        headerRow.createCell(MOB_NO).setCellValue("MobileNo");
-        headerRow.createCell(12).setCellValue("Address");
+        headerRow.createCell(ADDR).setCellValue("Address");
-        headerRow.getCell(12).setCellStyle(styleWT);
+        headerRow.getCell(ADDR).setCellStyle(styleWT);
-        headerRow.createCell(13).setCellValue("Pincode");
+        headerRow.createCell(PINCODE).setCellValue("Pincode");
-        headerRow.createCell(14).setCellValue("City");
+        headerRow.createCell(CITY).setCellValue("City");
-        headerRow.createCell(15).setCellValue("State");
+        headerRow.createCell(STATE).setCellValue("State");
-        headerRow.createCell(16).setCellValue("Email");
+        headerRow.createCell(EMAIL).setCellValue("Login Email");
-        headerRow.createCell(17).setCellValue("Order Id");
+        headerRow.createCell(ORDER_ID).setCellValue("Order Id");
-        headerRow.createCell(18).setCellValue("Order Status");
+        headerRow.createCell(ORDER_STATUS).setCellValue("Order Status");
-        headerRow.createCell(19).setCellValue("Order Status Description");
+        headerRow.createCell(ORDER_STATUS_DESC).setCellValue("Order Status Description");
-        headerRow.createCell(20).setCellValue("Item Id");
+        headerRow.createCell(ITEM_ID).setCellValue("Item Id");
-        headerRow.createCell(21).setCellValue("Product Group");
+        headerRow.createCell(PROD_GRP).setCellValue("Product Group");
-        headerRow.createCell(22).setCellValue("Brand");
+        headerRow.createCell(BRAND).setCellValue("Brand");
-        headerRow.createCell(23).setCellValue("Model Name");
+        headerRow.createCell(MOD_NAME).setCellValue("Model Name");
-        headerRow.createCell(24).setCellValue("Model Number");
+        headerRow.createCell(MOD_NUM).setCellValue("Model Number");
-        headerRow.createCell(25).setCellValue("Qty");
+        headerRow.createCell(QTY).setCellValue("Qty");
-        int addrColWidth = 35;
+        int paymethodColWidth = 25, statusDescWidth = 25, addrColWidth = 35;
+        paymentSheet.setColumnWidth(PAYMENT_METHOD, 256 * paymethodColWidth); // set width of payment method column
+        paymentSheet.setColumnWidth(PAY_STATUS_DESC, 256 * statusDescWidth); // set width of payment status description column
-        paymentSheet.setColumnWidth(12, 256 * addrColWidth); // set width of address column to 35 characters
+        paymentSheet.setColumnWidth(ADDR, 256 * addrColWidth); // set width of address column
         List<Order> orders;
         long txnId;
         Row contentRow;
         Calendar calendar = Calendar.getInstance();
         DateFormat formatter = new SimpleDateFormat("EEE, dd-MMM-yyyy hh:mm a");
+        float rowHeight = paymentSheet.getDefaultRowHeightInPoints();
+        int sNo = 0;
         for (Payment payment : payments) {
+            float newRowHeight = paymentSheet.getDefaultRowHeightInPoints();;
             try {
                 paymentSerialNo++;
                 contentRow = paymentSheet.createRow(paymentSerialNo);
+                sNo++;
+                contentRow.createCell(S_NO).setCellValue(sNo);
-                contentRow.createCell(0).setCellValue(payment.getPaymentId());
+                contentRow.createCell(PAYMENT_ID).setCellValue(payment.getPaymentId());
-                /*PaymentGateway gateway = gateWays.get(payment.getGatewayId());
+                PaymentGateway gateway = gateWays.get(payment.getGatewayId());
                 if(gateway == null) {
                     try {
                         gateway = pClient.getPaymentGateway(payment.getGatewayId());
                         gateWays.put(payment.getGatewayId(), gateway);
                     } catch (PaymentException e) {
                         e.printStackTrace();
                     }
+                }
-                contentRow.createCell(1).setCellValue(gateway != null ? gateway.getName() : payment.getGatewayId()+"");*/
+                contentRow.createCell(GATEWAY).setCellValue(gateway != null ? gateway.getName() : payment.getGatewayId()+"");
-                contentRow.createCell(1).setCellValue(payment.getGatewayId());
+                //contentRow.createCell(GATEWAY).setCellValue(payment.getGatewayId());
+                String paymentMethod = getPaymentMethod(payment.getAttributes());
+                contentRow.createCell(PAYMENT_METHOD).setCellValue(paymentMethod);
+                contentRow.getCell(PAYMENT_METHOD).setCellStyle(styleWT);
+                if(paymentMethod.length() > paymethodColWidth) {
+                    newRowHeight = Math.max(newRowHeight, (paymentMethod.length() / paymethodColWidth + 1) * rowHeight);
+                }
-                contentRow.createCell(2).setCellValue(payment.getMerchantTxnId());
+                contentRow.createCell(TXN_ID).setCellValue(payment.getMerchantTxnId());
-                contentRow.createCell(3).setCellValue(payment.getAmount());
+                contentRow.createCell(AMOUNT).setCellValue(payment.getAmount());
-                contentRow.getCell(3).setCellStyle(styleAmount);
+                contentRow.getCell(AMOUNT).setCellStyle(styleAmount);
-                contentRow.createCell(4).setCellValue(payment.getStatus().name());
+                contentRow.createCell(PAY_STATUS).setCellValue(payment.getStatus().name());
+                String desc = payment.getDescription();
-                contentRow.createCell(5).setCellValue(payment.getDescription());
+                contentRow.createCell(PAY_STATUS_DESC).setCellValue(desc);
+                contentRow.getCell(PAY_STATUS_DESC).setCellStyle(styleWT);
+                if(desc != null && desc.length() > statusDescWidth) {
+                    newRowHeight = Math.max(newRowHeight, (desc.length() / statusDescWidth + 1) * rowHeight);
+                }
-                contentRow.createCell(6).setCellValue(payment.getGatewayTxnStatus());
+                contentRow.createCell(TXN_STATUS).setCellValue(payment.getGatewayTxnStatus());
-                contentRow.createCell(7).setCellValue(payment.getReferenceCode());
+                contentRow.createCell(REF_CODE).setCellValue(payment.getReferenceCode());
                 calendar.setTimeInMillis(payment.getInitTimestamp());
-                contentRow.createCell(8).setCellValue(formatter.format(calendar.getTime()));
+                contentRow.createCell(TXN_TIME).setCellValue(formatter.format(calendar.getTime()));
                 txnId = tClient.getTransaction(payment.getMerchantTxnId()).getId();
                 orders = tClient.getOrdersForTransaction(txnId, payment.getUserId());
                 List<LineItem> lineItems;
                 String address = "";
-                float rowHeight = paymentSheet.getDefaultRowHeightInPoints();
                 if (orders == null || orders.isEmpty()) {
                     continue;
+                }
-                contentRow.createCell(9).setCellValue(orders.get(0).getCustomer_id());
+                contentRow.createCell(CUST_ID).setCellValue(orders.get(0).getCustomer_id());
-                contentRow.createCell(10).setCellValue(orders.get(0).getCustomer_name());
+                contentRow.createCell(NAME).setCellValue(orders.get(0).getCustomer_name());
-                contentRow.createCell(11).setCellValue(orders.get(0).getCustomer_mobilenumber());
+                contentRow.createCell(MOB_NO).setCellValue(orders.get(0).getCustomer_mobilenumber());
                 address = orders.get(0).getCustomer_address1() + ", " + orders.get(0).getCustomer_address2();
-                contentRow.createCell(12).setCellValue(address);
+                contentRow.createCell(ADDR).setCellValue(address);
-                contentRow.getCell(12).setCellStyle(styleWT);
+                contentRow.getCell(ADDR).setCellStyle(styleWT);
+                if(address.length() > addrColWidth) {
-                int maxLength = Math.max(address.length(), paymentSheet.getDefaultColumnWidth());
+                    newRowHeight = Math.max(newRowHeight, (address.length() / addrColWidth + 1) * rowHeight);
+                }
-                contentRow.setHeightInPoints((maxLength / addrColWidth + 1) * rowHeight); // Setting Row Height
+                contentRow.setHeightInPoints(newRowHeight);
-                contentRow.createCell(13).setCellValue(orders.get(0).getCustomer_pincode());
+                contentRow.createCell(PINCODE).setCellValue(orders.get(0).getCustomer_pincode());
-                contentRow.createCell(14).setCellValue(orders.get(0).getCustomer_city());
+                contentRow.createCell(CITY).setCellValue(orders.get(0).getCustomer_city());
-                contentRow.createCell(15).setCellValue(orders.get(0).getCustomer_state());
+                contentRow.createCell(STATE).setCellValue(orders.get(0).getCustomer_state());
-                contentRow.createCell(16).setCellValue(orders.get(0).getCustomer_email());
+                contentRow.createCell(EMAIL).setCellValue(orders.get(0).getCustomer_email());
+                boolean firstOrder = true;
                 for (Order o : orders) {
+                    if(firstOrder) {
+                        firstOrder = false;
+                    } else {
-                    paymentSerialNo++;
+                        paymentSerialNo++;
-                    contentRow = paymentSheet.createRow(paymentSerialNo);
+                        contentRow = paymentSheet.createRow(paymentSerialNo);
+                    }
-                    contentRow.createCell(17).setCellValue(o.getId());
+                    contentRow.createCell(ORDER_ID).setCellValue(o.getId());
-                    contentRow.createCell(18).setCellValue(o.getStatus().name());
+                    contentRow.createCell(ORDER_STATUS).setCellValue(o.getStatus().name());
-                    contentRow.createCell(19).setCellValue(o.getStatusDescription());
+                    contentRow.createCell(ORDER_STATUS_DESC).setCellValue(o.getStatusDescription());
                     lineItems = tClient.getLineItemsForOrder(o.getId());
                     for (LineItem i : lineItems) {
                         /*
                          * Right now there can be only one line item in an
                          */
                         // paymentSerialNo++;
                         // contentRow =
                         // paymentSheet.createRow(paymentSerialNo);
-                        contentRow.createCell(20).setCellValue(i.getId());
+                        contentRow.createCell(ITEM_ID).setCellValue(i.getId());
-                        contentRow.createCell(21).setCellValue(i.getProductGroup());
+                        contentRow.createCell(PROD_GRP).setCellValue(i.getProductGroup());
-                        contentRow.createCell(22).setCellValue(i.getBrand());
+                        contentRow.createCell(BRAND).setCellValue(i.getBrand());
-                        contentRow.createCell(23).setCellValue(i.getModel_name());
+                        contentRow.createCell(MOD_NAME).setCellValue(i.getModel_name());
-                        contentRow.createCell(24).setCellValue(i.getModel_number());
+                        contentRow.createCell(MOD_NUM).setCellValue(i.getModel_number());
-                        contentRow.createCell(25).setCellValue(i.getQuantity());
+                        contentRow.createCell(QTY).setCellValue(i.getQuantity());
+                    }
+                }
             } catch (TransactionServiceException e) {
                 e.printStackTrace();
             } catch (TException e) {
                 e.printStackTrace();
+            }
+        }
-        for (int i = 0; i <= 25; i++) {
+        for (int i = 0; i <= QTY; i++) {
-            if (i == 12) // Address Column is of fixed size with wrap text style
+            if (i == PAYMENT_METHOD || i == PAY_STATUS_DESC || i == ADDR) // Address Column is of fixed size with wrap text style
                 continue;
             paymentSheet.autoSizeColumn(i);
+        }
         // Write the workbook to the output stream
         } catch (IOException e) {
             e.printStackTrace();
+        }
         return baosXLS;
+    }
+    public String getPaymentMethod(List<Attribute> paymentAttributes) {
+        String paymentMethod = null;
+        if(paymentAttributes == null || paymentAttributes.isEmpty()) {
+            return "N/A";
+        }
+        for(Attribute a : paymentAttributes) {
+            if("payMethod".equals(a.getName())) {
+                paymentMethod = Constants.PAYMENT_METHOD.get(a.getValue());
+                break;
+            }
+        }
+        return paymentMethod != null ? paymentMethod : "N/A";
+    }
     public static void main(String[] args) {
         DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
         Date startDate = null, endDate = null;
         try {
             startDate = df.parse("01/01/2011");

Subversion Repositories SmartDukaan

(root)/trunk/Support/src/main/java/in/shop2020/support/services/PaymentDetailsGenerator.java – Rev 2090 → 2310