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

 package in.shop2020.support.services;
 import in.shop2020.logistics.DeliveryType;
 import in.shop2020.logistics.LogisticsServiceException;
+import in.shop2020.logistics.PickupStore;
 import in.shop2020.logistics.Provider;
 import in.shop2020.logistics.ProviderDetails;
 import in.shop2020.model.v1.inventory.InventoryServiceException;
 import in.shop2020.model.v1.inventory.Warehouse;
 import in.shop2020.model.v1.order.LineItem;
 import java.io.FileNotFoundException;
 import java.io.FileOutputStream;
 import java.io.IOException;
 import java.util.ArrayList;
 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.CreationHelper;
 	    // Create the header row and put all the titles in it. Rows are 0 based.
 	    Row headerRow = sheet.createRow((short)0);
 	    headerRow.createCell(0).setCellValue("Sl No");
 	    headerRow.createCell(1).setCellValue("AWB No");
 	    headerRow.createCell(2).setCellValue("AWB Date");
-	    headerRow.createCell(3).setCellValue("Order No");
+	    headerRow.createCell(3).setCellValue("Saholic Order Id");
 	    headerRow.createCell(4).setCellValue("Name");
 	    headerRow.createCell(5).setCellValue("Address 1");
 	    headerRow.createCell(6).setCellValue("Address 2");
 	    headerRow.createCell(7).setCellValue("City");
 	    headerRow.createCell(8).setCellValue("State");
 	    headerRow.createCell(10).setCellValue("Telephone No 1");
 	    headerRow.createCell(11).setCellValue("Telephone No 2");
 	    headerRow.createCell(12).setCellValue("Paymode");
 	    headerRow.createCell(13).setCellValue("Amount to be Collected");
 	    headerRow.createCell(14).setCellValue("Shipment Value");
-	    headerRow.createCell(15).setCellValue("Item ID");
-	    headerRow.createCell(16).setCellValue("Packet Weight(in Kg)");
+	    headerRow.createCell(15).setCellValue("Packet Weight(in Kg)");
-	    headerRow.createCell(17).setCellValue("Product Name");
+	    headerRow.createCell(16).setCellValue("Product Name");
-	    headerRow.createCell(18).setCellValue("Pickup Location");
+	    headerRow.createCell(17).setCellValue("Pickup Location");
-	    headerRow.createCell(19).setCellValue("Customer A/C Code");
+	    headerRow.createCell(18).setCellValue("Customer A/C Code");
 	    String accountNo = "";
 	    DeliveryType dt =  DeliveryType.PREPAID;
         if (isCod) {
             dt = DeliveryType.COD;
+            }
+        }
 	    Date awbDate = new Date();
 	    String location = removeNewLines(warehouse.getLocation());
+	    Map<String, List<Order>> logisticsTxnIdOrdersMap = new HashMap<String, List<Order>>();
+	    Map<Long, String> itemNamesMap = new HashMap<Long, String>();
+	    Map<String, Map<Long, Double>> logisticsTxnIdOrderQuantityMap = new HashMap<String, Map<Long, Double>>();
+	    for(Order order:orders){
+			if(order.getLogistics_provider_id()!=providerId)
+				continue;
+			if(order.isLogisticsCod() != isCod)
+			    continue;
+			LineItem lineItem = order.getLineitems().get(0);
+			if(order.isSetLogisticsTransactionId()){
+				if(logisticsTxnIdOrdersMap.containsKey(order.getLogisticsTransactionId())){
+					List<Order> orderList = logisticsTxnIdOrdersMap.get(order.getLogisticsTransactionId());
+					orderList.add(order);
+					logisticsTxnIdOrdersMap.put(order.getLogisticsTransactionId(), orderList);
+				} else{
+					List<Order> orderList = new ArrayList<Order>();
+					orderList.add(order);
+					logisticsTxnIdOrdersMap.put(order.getLogisticsTransactionId(), orderList);
+				}
+				if(logisticsTxnIdOrderQuantityMap.containsKey(order.getLogisticsTransactionId())){
+					Map<Long, Double> orderItemQuantityMap = logisticsTxnIdOrderQuantityMap.get(order.getLogisticsTransactionId());
+					double orderQuantity = orderItemQuantityMap.get(lineItem.getItem_id())+ lineItem.getQuantity();
+					orderItemQuantityMap.put(lineItem.getItem_id(),orderQuantity);
+					logisticsTxnIdOrderQuantityMap.put(order.getLogisticsTransactionId(), orderItemQuantityMap);
+				}else{
+					Map<Long, Double> orderItemQuantityMap = new HashMap<Long, Double>();
+					orderItemQuantityMap.put(lineItem.getItem_id(), lineItem.getQuantity());
+					logisticsTxnIdOrderQuantityMap.put(order.getLogisticsTransactionId(), orderItemQuantityMap);
+				}
+			}else{
+				List<Order> orderList = new ArrayList<Order>();
+				orderList.add(order);
+				logisticsTxnIdOrdersMap.put(order.getId()+"", orderList);
+				Map<Long, Double> orderItemQuantityMap = new HashMap<Long, Double>();
+				orderItemQuantityMap.put(lineItem.getItem_id(), lineItem.getQuantity());
+				logisticsTxnIdOrderQuantityMap.put(order.getId()+"", orderItemQuantityMap);
+			}
+			if(!itemNamesMap.containsKey(lineItem.getItem_id())){
+				itemNamesMap.put(lineItem.getItem_id(), getItemDisplayName(lineItem, false));
+			}
+	    }
 	    int serialNo = 0;
+	    for(String logisticsTxnId : logisticsTxnIdOrdersMap.keySet()){
+	    	serialNo++;
+	    	Row contentRow = sheet.createRow((short)serialNo);
+	    	contentRow.createCell(0).setCellValue(serialNo);
+	    	List<Order> ordersList = logisticsTxnIdOrdersMap.get(logisticsTxnId);
+	    	double totalAmount = 0.0;
+	    	double totalWeight = 0.0;
+	    	for(Order o:ordersList){
+	    		totalAmount = totalAmount + (o.getTotal_amount()-o.getGvAmount());
+	    		totalWeight = totalWeight + o.getTotal_weight();
+	    	}
+	    	Order order = logisticsTxnIdOrdersMap.get(logisticsTxnId).get(0);
+	    	contentRow.createCell(1).setCellValue(order.getAirwaybill_no());
+	    	Cell awbDateCell = contentRow.createCell(2);
+		    awbDateCell.setCellValue(awbDate);
+		    awbDateCell.setCellStyle(dateCellStyle);
+		    contentRow.createCell(3).setCellValue(logisticsTxnId);
+		    if(order.getPickupStoreId() != 0){
+		    	PickupStore store = null;
+				try {
+					store = logisticsClient.getPickupStore(order.getPickupStoreId());
+				} catch (TException e) {
+					// TODO Auto-generated catch block
+					e.printStackTrace();
+				}
+		    	contentRow.createCell(4).setCellValue(getValueForEmptyString(store.getName()));
+			    contentRow.createCell(5).setCellValue(getValueForEmptyString(store.getLine1()));
+			    contentRow.createCell(6).setCellValue(getValueForEmptyString(store.getLine2()));
+			    contentRow.createCell(7).setCellValue(getValueForEmptyString(store.getCity()));
+			    contentRow.createCell(8).setCellValue(getValueForEmptyString(store.getState()));
+			    contentRow.createCell(9).setCellValue(getValueForEmptyString(store.getPin()));
+			    contentRow.createCell(10).setCellValue(getValueForEmptyString(store.getPhone()));
+		    }else{
+		    	contentRow.createCell(4).setCellValue(getValueForEmptyString(order.getCustomer_name()));
+			    contentRow.createCell(5).setCellValue(getValueForEmptyString(order.getCustomer_address1()));
+			    contentRow.createCell(6).setCellValue(getValueForEmptyString(order.getCustomer_address2()));
+			    contentRow.createCell(7).setCellValue(getValueForEmptyString(order.getCustomer_city()));
+			    contentRow.createCell(8).setCellValue(getValueForEmptyString(order.getCustomer_state()));
+			    contentRow.createCell(9).setCellValue(getValueForEmptyString(order.getCustomer_pincode()));
+			    contentRow.createCell(10).setCellValue(getValueForEmptyString(order.getCustomer_mobilenumber()));
+		    }
+		    contentRow.createCell(11).setCellValue("-");
+		    if(isCod){
+		        contentRow.createCell(12).setCellValue("COD");
+                contentRow.createCell(13).setCellValue(totalAmount);
+		    } else {
+		        contentRow.createCell(12).setCellValue("Prepaid");
+                contentRow.createCell(13).setCellValue(0);
+		    }
+		    contentRow.createCell(14).setCellValue(totalAmount);
+		    Cell weightCell = contentRow.createCell(15);
+		    weightCell.setCellValue(totalWeight);
+		    weightCell.setCellStyle(weightStyle);
+		    StringBuffer productNameBuffer = new StringBuffer();
+		    int skuSizeTxn = logisticsTxnIdOrderQuantityMap.get(logisticsTxnId).keySet().size();
+		    int count = 1;
+		    for(Long itemId : logisticsTxnIdOrderQuantityMap.get(logisticsTxnId).keySet()){
+		    	Map<Long, Double> quantityMap = logisticsTxnIdOrderQuantityMap.get(logisticsTxnId);
+		    	double quantity = quantityMap.get(itemId);
+		    	productNameBuffer.append(itemNamesMap.get(itemId)+"("+quantity+")");
+		    	if(count<skuSizeTxn){
+		    		productNameBuffer.append(",");
+		    	}
+		    	count++;
+		    }
+		    contentRow.createCell(16).setCellValue(productNameBuffer.toString());
+		    contentRow.createCell(17).setCellValue(location);
+		    contentRow.createCell(18).setCellValue(accountNo);
+	    }
-	    for(int i = 0; i<orders.size(); i++){
+	    /*for(int i = 0; i<orders.size(); i++){
 	    	Order order = orders.get(i);
 			if(order.getLogistics_provider_id()!=providerId)
 				continue;
 			if(order.isLogisticsCod() != isCod)
 			    continue;
 		    weightCell.setCellValue(lineItem.getTotal_weight());
 		    weightCell.setCellStyle(weightStyle);
 		    contentRow.createCell(17).setCellValue(lineItem.getBrand() + " " + lineItem.getModel_number() + " " + lineItem.getModel_name() + " " + lineItem.getColor());
 		    contentRow.createCell(18).setCellValue(location);
 		    contentRow.createCell(19).setCellValue(accountNo);
-	    }
+	    }*/
 		// Write the workbook to the output stream
 		try {
 			wb.write(baosXLS);
 			baosXLS.close();
 	private String removeNewLines(String str){
 	    return str.replace('\n', ' ');
+	}
+	private String getItemDisplayName(LineItem lineitem, boolean appendIMEI){
+		StringBuffer itemName = new StringBuffer();
+		if(lineitem.getBrand()!= null)
+			itemName.append(lineitem.getBrand() + " ");
+		if(lineitem.getModel_name() != null)
+			itemName.append(lineitem.getModel_name() + " ");
+		if(lineitem.getModel_number() != null )
+			itemName.append(lineitem.getModel_number() + " ");
+		if(lineitem.getColor() != null && !lineitem.getColor().trim().equals("NA"))
+			itemName.append("("+lineitem.getColor()+")");
+		if(appendIMEI && lineitem.isSetSerial_number()){
+			itemName.append("\nIMEI No. " + lineitem.getSerial_number());
+		}
+		return itemName.toString();
+	}
 	/**
 	 * @param args
 	 */
 	public static void main(String[] args) {
 		System.out.println("Hey There");

Subversion Repositories SmartDukaan

(root)/trunk/Support/src/main/java/in/shop2020/support/services/CourierDetailsGenerator.java – Rev 7792 → 13276