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

         headerRow.createCell(1).setCellValue("Gateway");
         headerRow.createCell(2).setCellValue("Txn Id");
         headerRow.createCell(3).setCellValue("Amount");
         headerRow.createCell(4).setCellValue("Payment Status");
         headerRow.createCell(5).setCellValue("Payment Status Description");
+        headerRow.createCell(6).setCellValue("Gateway Txn Status");
-        headerRow.createCell(6).setCellValue("Reference Code");
+        headerRow.createCell(7).setCellValue("Reference Code");
-        headerRow.createCell(7).setCellValue("Transaction Time");
+        headerRow.createCell(8).setCellValue("Transaction Time");
-        headerRow.createCell(8).setCellValue("Customer Id");
+        headerRow.createCell(9).setCellValue("Customer Id");
-        headerRow.createCell(9).setCellValue("Name");
+        headerRow.createCell(10).setCellValue("Name");
-        headerRow.createCell(10).setCellValue("MobileNo");
+        headerRow.createCell(11).setCellValue("MobileNo");
-        headerRow.createCell(11).setCellValue("Address");
+        headerRow.createCell(12).setCellValue("Address");
-        headerRow.getCell(11).setCellStyle(styleWT);
+        headerRow.getCell(12).setCellStyle(styleWT);
-        headerRow.createCell(12).setCellValue("Pincode");
+        headerRow.createCell(13).setCellValue("Pincode");
-        headerRow.createCell(13).setCellValue("City");
+        headerRow.createCell(14).setCellValue("City");
-        headerRow.createCell(14).setCellValue("State");
+        headerRow.createCell(15).setCellValue("State");
-        headerRow.createCell(15).setCellValue("Email");
+        headerRow.createCell(16).setCellValue("Email");
-        headerRow.createCell(16).setCellValue("Order Id");
+        headerRow.createCell(17).setCellValue("Order Id");
-        headerRow.createCell(17).setCellValue("Order Status");
+        headerRow.createCell(18).setCellValue("Order Status");
-        headerRow.createCell(18).setCellValue("Order Status Description");
+        headerRow.createCell(19).setCellValue("Order Status Description");
-        headerRow.createCell(19).setCellValue("Item Id");
+        headerRow.createCell(20).setCellValue("Item Id");
-        headerRow.createCell(20).setCellValue("Product Group");
+        headerRow.createCell(21).setCellValue("Product Group");
-        headerRow.createCell(21).setCellValue("Brand");
+        headerRow.createCell(22).setCellValue("Brand");
-        headerRow.createCell(22).setCellValue("Model Name");
+        headerRow.createCell(23).setCellValue("Model Name");
-        headerRow.createCell(23).setCellValue("Model Number");
+        headerRow.createCell(24).setCellValue("Model Number");
-        headerRow.createCell(24).setCellValue("Qty");
+        headerRow.createCell(25).setCellValue("Qty");
         int addrColWidth = 35;
-        paymentSheet.setColumnWidth(10, 256 * addrColWidth); // set width of address column to 35 characters
+        paymentSheet.setColumnWidth(12, 256 * addrColWidth); // set width of address column to 35 characters
         List<Order> orders;
         long txnId;
         Row contentRow;
         Calendar calendar = Calendar.getInstance();
         DateFormat formatter = new SimpleDateFormat("EEE, dd-MMM-yyyy hh:mm a");
                         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(1).setCellValue(payment.getGatewayId());
                 contentRow.createCell(2).setCellValue(payment.getMerchantTxnId());
                 contentRow.createCell(3).setCellValue(payment.getAmount());
                 contentRow.getCell(3).setCellStyle(styleAmount);
                 contentRow.createCell(4).setCellValue(payment.getStatus().name());
                 contentRow.createCell(5).setCellValue(payment.getDescription());
+                contentRow.createCell(6).setCellValue(payment.getGatewayTxnStatus());
-                contentRow.createCell(6).setCellValue(payment.getReferenceCode());
+                contentRow.createCell(7).setCellValue(payment.getReferenceCode());
                 calendar.setTimeInMillis(payment.getInitTimestamp());
-                contentRow.createCell(7).setCellValue(formatter.format(calendar.getTime()));
+                contentRow.createCell(8).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(8).setCellValue(orders.get(0).getCustomer_id());
+                contentRow.createCell(9).setCellValue(orders.get(0).getCustomer_id());
-                contentRow.createCell(9).setCellValue(orders.get(0).getCustomer_name());
+                contentRow.createCell(10).setCellValue(orders.get(0).getCustomer_name());
-                contentRow.createCell(10).setCellValue(orders.get(0).getCustomer_mobilenumber());
+                contentRow.createCell(11).setCellValue(orders.get(0).getCustomer_mobilenumber());
                 address = orders.get(0).getCustomer_address1() + ", " + orders.get(0).getCustomer_address2();
-                contentRow.createCell(11).setCellValue(address);
+                contentRow.createCell(12).setCellValue(address);
-                contentRow.getCell(11).setCellStyle(styleWT);
+                contentRow.getCell(12).setCellStyle(styleWT);
                 int maxLength = Math.max(address.length(), paymentSheet.getDefaultColumnWidth());
                 contentRow.setHeightInPoints((maxLength / addrColWidth + 1) * rowHeight); // Setting Row Height
-                contentRow.createCell(12).setCellValue(orders.get(0).getCustomer_pincode());
+                contentRow.createCell(13).setCellValue(orders.get(0).getCustomer_pincode());
-                contentRow.createCell(13).setCellValue(orders.get(0).getCustomer_city());
+                contentRow.createCell(14).setCellValue(orders.get(0).getCustomer_city());
-                contentRow.createCell(14).setCellValue(orders.get(0).getCustomer_state());
+                contentRow.createCell(15).setCellValue(orders.get(0).getCustomer_state());
-                contentRow.createCell(15).setCellValue(orders.get(0).getCustomer_email());
+                contentRow.createCell(16).setCellValue(orders.get(0).getCustomer_email());
                 for (Order o : orders) {
                     paymentSerialNo++;
                     contentRow = paymentSheet.createRow(paymentSerialNo);
-                    contentRow.createCell(16).setCellValue(o.getId());
+                    contentRow.createCell(17).setCellValue(o.getId());
-                    contentRow.createCell(17).setCellValue(o.getStatus().name());
+                    contentRow.createCell(18).setCellValue(o.getStatus().name());
-                    contentRow.createCell(18).setCellValue(o.getStatusDescription());
+                    contentRow.createCell(19).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(19).setCellValue(i.getId());
+                        contentRow.createCell(20).setCellValue(i.getId());
-                        contentRow.createCell(20).setCellValue(i.getProductGroup());
+                        contentRow.createCell(21).setCellValue(i.getProductGroup());
-                        contentRow.createCell(21).setCellValue(i.getBrand());
+                        contentRow.createCell(22).setCellValue(i.getBrand());
-                        contentRow.createCell(22).setCellValue(i.getModel_name());
+                        contentRow.createCell(23).setCellValue(i.getModel_name());
-                        contentRow.createCell(23).setCellValue(i.getModel_number());
+                        contentRow.createCell(24).setCellValue(i.getModel_number());
-                        contentRow.createCell(24).setCellValue(i.getQuantity());
+                        contentRow.createCell(25).setCellValue(i.getQuantity());
+                    }
+                }
             } catch (TransactionServiceException e) {
                 e.printStackTrace();
             } catch (TException e) {
                 e.printStackTrace();
+            }
+        }
-        for (int i = 0; i <= 24; i++) {
+        for (int i = 0; i <= 25; i++) {
-            if (i == 11) // Address Column is of fixed size with wrap text style
+            if (i == 12) // Address Column is of fixed size with wrap text style
                 continue;
             paymentSheet.autoSizeColumn(i);
+        }
         // Write the workbook to the output stream
     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");
-            endDate = df.parse("04/30/2011");
+            endDate = df.parse("06/30/2011");
             Calendar cal = Calendar.getInstance();
             cal.setTime(endDate);
             cal.add(Calendar.DATE, 1);
             endDate.setTime(cal.getTimeInMillis());
         } catch (ParseException pe) {

Subversion Repositories SmartDukaan

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