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

 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.Payment;
 import in.shop2020.payments.PaymentException;
+import in.shop2020.payments.PaymentGateway;
 import in.shop2020.payments.PaymentStatus;
 import in.shop2020.thrift.clients.PaymentServiceClient;
 import in.shop2020.thrift.clients.TransactionServiceClient;
+import in.shop2020.thrift.clients.UserContextServiceClient;
 import java.io.ByteArrayOutputStream;
 import java.io.FileNotFoundException;
 import java.io.FileOutputStream;
 import java.io.IOException;
 import java.text.DateFormat;
 import java.text.ParseException;
 import java.text.SimpleDateFormat;
 import java.util.Calendar;
 import java.util.Date;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
 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.DataFormat;
     in.shop2020.model.v1.order.TransactionService.Client tClient;
     PaymentServiceClient psc;
     in.shop2020.payments.PaymentService.Client pClient;
+    UserContextServiceClient usc;
+    in.shop2020.model.v1.user.UserContextService.Client uClient;
+    Map<Long, PaymentGateway> gateWays = new HashMap<Long, PaymentGateway>(3);
     public PaymentDetailsGenerator() {
         try {
             tsc = new TransactionServiceClient();
             tClient = tsc.getClient();
             psc = new PaymentServiceClient();
             pClient = psc.getClient();
+            usc = new UserContextServiceClient();
+            uClient = usc.getClient();
         } catch (Exception e) {
             e.printStackTrace();
+        }
+    }
         // as FAILED or INIT and for gateway Id = 1 (HDFC)
         List<Payment> payments = null;
         List<Payment> pendingPayments = null;
         try {
             if(status == 0) {
-                payments = pClient.getPayments(startDate.getTime(), endDate.getTime(), PaymentStatus.SUCCESS, 1);
+                payments = pClient.getPayments(startDate.getTime(), endDate.getTime(), PaymentStatus.SUCCESS, 0);
             } else {
-                payments = pClient.getPayments(startDate.getTime(), endDate.getTime(), PaymentStatus.FAILED, 1);
+                payments = pClient.getPayments(startDate.getTime(), endDate.getTime(), PaymentStatus.FAILED, 0);
-                pendingPayments = pClient.getPayments(startDate.getTime(), endDate.getTime(), PaymentStatus.INIT, 1);
+                pendingPayments = pClient.getPayments(startDate.getTime(), endDate.getTime(), PaymentStatus.INIT, 0);
                 if (payments != null && pendingPayments != null) {
                     payments.addAll(pendingPayments);
                 } else if (pendingPayments != null){
                     payments = pendingPayments;
+                }
         paymentSheet.createRow(paymentSerialNo++);
         Row headerRow = paymentSheet.createRow(paymentSerialNo++);
         headerRow.createCell(0).setCellValue("Payment Id");
+        headerRow.createCell(1).setCellValue("Gateway");
-        headerRow.createCell(1).setCellValue("Txn Id");
+        headerRow.createCell(2).setCellValue("Txn Id");
-        headerRow.createCell(2).setCellValue("Amount");
+        headerRow.createCell(3).setCellValue("Amount");
-        headerRow.createCell(3).setCellValue("Payment Status");
+        headerRow.createCell(4).setCellValue("Payment Status");
-        headerRow.createCell(4).setCellValue("Payment Status Description");
+        headerRow.createCell(5).setCellValue("Payment Status Description");
-        headerRow.createCell(5).setCellValue("Reference Code");
+        headerRow.createCell(6).setCellValue("Reference Code");
-        headerRow.createCell(6).setCellValue("Transaction Time");
+        headerRow.createCell(7).setCellValue("Transaction Time");
-        headerRow.createCell(7).setCellValue("Customer Id");
+        headerRow.createCell(8).setCellValue("Customer Id");
-        headerRow.createCell(8).setCellValue("Name");
+        headerRow.createCell(9).setCellValue("Name");
-        headerRow.createCell(9).setCellValue("MobileNo");
+        headerRow.createCell(10).setCellValue("MobileNo");
-        headerRow.createCell(10).setCellValue("Address");
+        headerRow.createCell(11).setCellValue("Address");
-        headerRow.getCell(10).setCellStyle(styleWT);
+        headerRow.getCell(11).setCellStyle(styleWT);
-        headerRow.createCell(11).setCellValue("Pincode");
+        headerRow.createCell(12).setCellValue("Pincode");
-        headerRow.createCell(12).setCellValue("City");
+        headerRow.createCell(13).setCellValue("City");
-        headerRow.createCell(13).setCellValue("State");
+        headerRow.createCell(14).setCellValue("State");
-        headerRow.createCell(14).setCellValue("Email");
+        headerRow.createCell(15).setCellValue("Email");
-        headerRow.createCell(15).setCellValue("Order Id");
+        headerRow.createCell(16).setCellValue("Order Id");
-        headerRow.createCell(16).setCellValue("Order Status");
+        headerRow.createCell(17).setCellValue("Order Status");
-        headerRow.createCell(17).setCellValue("Order Status Description");
+        headerRow.createCell(18).setCellValue("Order Status Description");
-        headerRow.createCell(18).setCellValue("Item Id");
+        headerRow.createCell(19).setCellValue("Item Id");
-        headerRow.createCell(19).setCellValue("Product Group");
+        headerRow.createCell(20).setCellValue("Product Group");
-        headerRow.createCell(20).setCellValue("Brand");
+        headerRow.createCell(21).setCellValue("Brand");
-        headerRow.createCell(21).setCellValue("Model Name");
+        headerRow.createCell(22).setCellValue("Model Name");
-        headerRow.createCell(22).setCellValue("Model Number");
+        headerRow.createCell(23).setCellValue("Model Number");
-        headerRow.createCell(23).setCellValue("Qty");
+        headerRow.createCell(24).setCellValue("Qty");
         int addrColWidth = 35;
         paymentSheet.setColumnWidth(10, 256 * addrColWidth); // set width of address column to 35 characters
         List<Order> orders;
         long txnId;
         for (Payment payment : payments) {
             try {
                 paymentSerialNo++;
                 contentRow = paymentSheet.createRow(paymentSerialNo);
                 contentRow.createCell(0).setCellValue(payment.getPaymentId());
+                /*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(payment.getGatewayId());
-                contentRow.createCell(1).setCellValue(payment.getMerchantTxnId());
+                contentRow.createCell(2).setCellValue(payment.getMerchantTxnId());
-                contentRow.createCell(2).setCellValue(payment.getAmount());
+                contentRow.createCell(3).setCellValue(payment.getAmount());
-                contentRow.getCell(2).setCellStyle(styleAmount);
+                contentRow.getCell(3).setCellStyle(styleAmount);
-                contentRow.createCell(3).setCellValue(payment.getStatus().name());
+                contentRow.createCell(4).setCellValue(payment.getStatus().name());
-                contentRow.createCell(4).setCellValue(payment.getDescription());
+                contentRow.createCell(5).setCellValue(payment.getDescription());
-                contentRow.createCell(5).setCellValue(payment.getReferenceCode());
+                contentRow.createCell(6).setCellValue(payment.getReferenceCode());
                 calendar.setTimeInMillis(payment.getInitTimestamp());
-                contentRow.createCell(6).setCellValue(formatter.format(calendar.getTime()));
+                contentRow.createCell(7).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(7).setCellValue(orders.get(0).getCustomer_id());
+                contentRow.createCell(8).setCellValue(orders.get(0).getCustomer_id());
-                contentRow.createCell(8).setCellValue(orders.get(0).getCustomer_name());
+                contentRow.createCell(9).setCellValue(orders.get(0).getCustomer_name());
-                contentRow.createCell(9).setCellValue(orders.get(0).getCustomer_mobilenumber());
+                contentRow.createCell(10).setCellValue(orders.get(0).getCustomer_mobilenumber());
                 address = orders.get(0).getCustomer_address1() + ", " + orders.get(0).getCustomer_address2();
-                contentRow.createCell(10).setCellValue(address);
+                contentRow.createCell(11).setCellValue(address);
-                contentRow.getCell(10).setCellStyle(styleWT);
+                contentRow.getCell(11).setCellStyle(styleWT);
                 int maxLength = Math.max(address.length(), paymentSheet.getDefaultColumnWidth());
                 contentRow.setHeightInPoints((maxLength / addrColWidth + 1) * rowHeight); // Setting Row Height
-                contentRow.createCell(11).setCellValue(orders.get(0).getCustomer_pincode());
+                contentRow.createCell(12).setCellValue(orders.get(0).getCustomer_pincode());
-                contentRow.createCell(12).setCellValue(orders.get(0).getCustomer_city());
+                contentRow.createCell(13).setCellValue(orders.get(0).getCustomer_city());
-                contentRow.createCell(13).setCellValue(orders.get(0).getCustomer_state());
+                contentRow.createCell(14).setCellValue(orders.get(0).getCustomer_state());
-                contentRow.createCell(14).setCellValue(orders.get(0).getCustomer_email());
+                contentRow.createCell(15).setCellValue(orders.get(0).getCustomer_email());
                 for (Order o : orders) {
                     paymentSerialNo++;
                     contentRow = paymentSheet.createRow(paymentSerialNo);
-                    contentRow.createCell(15).setCellValue(o.getId());
+                    contentRow.createCell(16).setCellValue(o.getId());
-                    contentRow.createCell(16).setCellValue(o.getStatus().name());
+                    contentRow.createCell(17).setCellValue(o.getStatus().name());
-                    contentRow.createCell(17).setCellValue(o.getStatusDescription());
+                    contentRow.createCell(18).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(18).setCellValue(i.getId());
+                        contentRow.createCell(19).setCellValue(i.getId());
-                        contentRow.createCell(19).setCellValue(i.getProductGroup());
+                        contentRow.createCell(20).setCellValue(i.getProductGroup());
-                        contentRow.createCell(20).setCellValue(i.getBrand());
+                        contentRow.createCell(21).setCellValue(i.getBrand());
-                        contentRow.createCell(21).setCellValue(i.getModel_name());
+                        contentRow.createCell(22).setCellValue(i.getModel_name());
-                        contentRow.createCell(22).setCellValue(i.getModel_number());
+                        contentRow.createCell(23).setCellValue(i.getModel_number());
-                        contentRow.createCell(23).setCellValue(i.getQuantity());
+                        contentRow.createCell(24).setCellValue(i.getQuantity());
+                    }
+                }
             } catch (TransactionServiceException e) {
                 e.printStackTrace();
             } catch (TException e) {
                 e.printStackTrace();
+            }
+        }
-        for (int i = 0; i <= 23; i++) {
+        for (int i = 0; i <= 24; i++) {
-            if (i == 10) // Address Column is of fixed size with wrap text style
+            if (i == 11) // Address Column is of fixed size with wrap text style
                 continue;
             paymentSheet.autoSizeColumn(i);
+        }
         // Write the workbook to the output stream

Subversion Repositories SmartDukaan

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