Subversion Repositories SmartDukaan

Rev

Rev 10895 | Rev 10897 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
8616 vikram.rag 1 
package in.shop2020;
2 
 
3 
import in.shop2020.model.v1.catalog.CatalogService;
8739 vikram.rag 4 
import in.shop2020.model.v1.catalog.SnapdealItem;
8616 vikram.rag 5 
import in.shop2020.model.v1.catalog.CatalogServiceException;
6 
import in.shop2020.model.v1.catalog.Item;
7 
import in.shop2020.model.v1.inventory.InventoryService;
8 
import in.shop2020.model.v1.inventory.InventoryServiceException;
8890 amar.kumar 9 
import in.shop2020.model.v1.inventory.InventoryType;
10 
import in.shop2020.model.v1.inventory.WarehouseType;
8759 vikram.rag 11 
 
8616 vikram.rag 12 
import in.shop2020.model.v1.inventory.VendorItemPricing;
13 
import in.shop2020.model.v1.inventory.Warehouse;
14 
import in.shop2020.model.v1.order.LineItem;
15 
import in.shop2020.model.v1.order.OrderStatus;
16 
import in.shop2020.model.v1.order.OrderType;
17 
import in.shop2020.model.v1.order.SnapdealOrder;
18 
import in.shop2020.model.v1.order.SourceDetail;
19 
import in.shop2020.model.v1.order.Transaction;
8651 vikram.rag 20 
import in.shop2020.model.v1.order.TransactionServiceException;
8616 vikram.rag 21 
import in.shop2020.model.v1.order.TransactionStatus;
22 
import in.shop2020.model.v1.order.TransactionService.Client;
23 
import in.shop2020.model.v1.user.User;
24 
import in.shop2020.payments.PaymentException;
25 
import in.shop2020.payments.PaymentStatus;
26 
import in.shop2020.thrift.clients.CatalogClient;
27 
import in.shop2020.thrift.clients.InventoryClient;
28 
import in.shop2020.thrift.clients.PaymentClient;
29 
import in.shop2020.thrift.clients.TransactionClient;
30 
import in.shop2020.thrift.clients.UserClient;
31 
 
32 
import java.io.File;
8651 vikram.rag 33 
import java.text.ParseException;
8616 vikram.rag 34 
import java.text.SimpleDateFormat;
35 
import java.util.ArrayList;
36 
import java.util.Calendar;
37 
import java.util.Collections;
38 
import java.util.Date;
8773 vikram.rag 39 
import java.util.GregorianCalendar;
8616 vikram.rag 40 
import java.util.List;
41 
import javax.xml.bind.JAXBContext;
42 
import javax.xml.bind.JAXBException;
43 
import javax.xml.bind.Marshaller;
44 
import javax.xml.bind.Unmarshaller;
8739 vikram.rag 45 
 
8616 vikram.rag 46 
import org.apache.thrift.TException;
47 
import org.apache.thrift.transport.TTransportException;
8645 vikram.rag 48 
import org.slf4j.Logger;
49 
import org.slf4j.LoggerFactory;
8773 vikram.rag 50 
import in.shop2020.utils.GmailUtils;
8616 vikram.rag 51 
 
52 
import order.SaholicAPI;
53 
import order.SaholicAPI.Order;
54 
 
55 
public class ProcessSnapdealOrder {
56 
	private static final int SNAPDEAL_SOURCE_ID = 7;
57 
	private static final String FIRSTFLIGHT = "First Flight";
8627 vikram.rag 58 
	private static final String DELHIVERY = "DELHIVERY";
59 
	private static final String BLUEDART = "Bluedart";
8715 vikram.rag 60 
	private static final String CHHOTU = "CHHOTU";
61 
	private static final String LAST_MILE = "LAST_MILE";
8844 amar.kumar 62 
	private static final String  ECOMM_EXP = "Ecom Express";
8715 vikram.rag 63 
	private static final String  EWINGS = "EWINGS";
64 
	private static final String DTDC = "DTDC";
9187 vikram.rag 65 
	private static final String WAREOLOG = "Wareolog";
8715 vikram.rag 66 
	private static final String  MIRAKLE = "MIRAKLE";
67 
	private static final String RAJIV_TRANSPORT = "RAJIV_TRANSPORT";
68 
	private static final String BLUEDART_HIGH_VALUE = "BLUEDART_HIGH_VALUE";
69 
	private static final String BLUEDART_SURFACE = "BLUEDART_SURFACE";
9187 vikram.rag 70 
	private static final String BLUEDART_APEX = "BLUEDART APEX";
8715 vikram.rag 71 
	private static final String ARAMEX = "ARAMEX";
9120 vikram.rag 72 
	private static final String GATI = "GATI";
9879 rajveer 73 
	private static final String INDIA_POST = "INDIA POST";
8715 vikram.rag 74 
	private static final String FEDEX = "FEDEX";
75 
	private static final String IOT = "IOT";
9148 vikram.rag 76 
	private static final String RED_EXP = "Red Express";
8715 vikram.rag 77 
	private static final String GHARPAY = "GHARPAY";
9128 vikram.rag 78 
	private static final String QUANTIUM = "Quantium Solutions";
9120 vikram.rag 79 
	private static final String GATI_AIR = "GATI AIR";
8715 vikram.rag 80 
	private static final String VDELIVER = "VDELIVER";
9137 vikram.rag 81 
	private static final String OVERNITE_EXP = "Overnite Express";
10235 vikram.rag 82 
	private static final String BIBHA_CARGO =  "BIBHA CARGO AND COURIER PVT LTD";
10570 manish.sha 83 
	private static final String FF_DELHI = "FF-Delhi";
10574 vikram.rag 84 
	private static final String FF_GURGAON = "FF-GURGAON";
10761 kshitij.so 85 
	private static final String TANVI_EXPRESS = "Tanvi Express";
86 
	private static final String VELIX = "Velex Logistics Pvt. Ltd";
10768 manish.sha 87 
	private static final String XPRESSBEES = "XPRESSBEES";
8627 vikram.rag 88 
	private static String transactionId;
9151 vikram.rag 89 
	private static long paymentId;
8627 vikram.rag 90 
	private static final int SNAPDEAL_GATEWAY_ID = 18;
8646 vikram.rag 91 
	private static Logger logger;
8627 vikram.rag 92 
 
8616 vikram.rag 93 
	public static void processSnapdealOrders(File file) throws JAXBException{
8646 vikram.rag 94 
		logger = LoggerFactory.getLogger(ProcessSnapdealOrder.class);
8616 vikram.rag 95 
		JAXBContext jc = JAXBContext.newInstance(SaholicAPI.class);
96 
		Unmarshaller unmarshaller = jc.createUnmarshaller();
97 
		SaholicAPI orders = (SaholicAPI) unmarshaller.unmarshal(file);
98 
		Marshaller marshaller = jc.createMarshaller();
99 
		marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
100 
		marshaller.marshal(orders, System.out);
101 
		SourceDetail sourceDetail = null;
102 
		User user = null;
103 
		TransactionClient tsc = null;
104 
		try {
105 
			tsc = new TransactionClient();
106 
			sourceDetail = tsc.getClient().getSourceDetail(SNAPDEAL_SOURCE_ID);
107 
		} catch (Exception e) {
8773 vikram.rag 108 
			logger.error("Unable to establish connection to the transaction service while getting Snapdeal Source Detail ", e);
8616 vikram.rag 109 
		}
110 
		try {
111 
			in.shop2020.model.v1.user.UserContextService.Client userClient = new UserClient().getClient();
112 
			user = userClient.getUserByEmail(sourceDetail.getEmail());
113 
		} catch (Exception e) {
8773 vikram.rag 114 
			logger.error("Unable to establish connection to the User service ", e);
8616 vikram.rag 115 
		}
8800 vikram.rag 116 
		int duplicate_orders = 0;
117 
		int new_orders = 0;
8773 vikram.rag 118 
		int processed_orders = 0;
119 
		StringBuffer sb = new StringBuffer();
9456 vikram.rag 120 
		LineItem lineItem = null;
121 
		CatalogService.Client catalogClient = null;
122 
		SnapdealItem snapdealItem = null;
123 
		double SellingPrice = 0;
124 
		long sku;
9630 vikram.rag 125 
		String subOrderId;
8616 vikram.rag 126 
		for(Order order:orders.getOrder()){
9629 vikram.rag 127 
			subOrderId = order.getSuborderId();
8627 vikram.rag 128 
			Client transaction_client = null;
10895 vikram.rag 129 
			new_orders++;
10896 vikram.rag 130 
			boolean flag = false;
8627 vikram.rag 131 
			try {
132 
				transaction_client = new TransactionClient().getClient();
10896 vikram.rag 133 
			} catch (TTransportException e2) {
134 
				try {
135 
					transaction_client = new TransactionClient().getClient();
136 
				} catch (TTransportException e) {
137 
					logger.error("Problem with Transaction service " + subOrderId);
138 
					e.printStackTrace();
8627 vikram.rag 139 
					continue;
140 
				}
10896 vikram.rag 141 
				e2.printStackTrace();
142 
			}
143 
			try {
144 
				flag = transaction_client.snapdealOrderExists(subOrderId, order.getReferenceCode());
145 
			} catch (TException e2) {
146 
				try {
147 
					flag = new TransactionClient().getClient().snapdealOrderExists(subOrderId, order.getReferenceCode());
148 
				} catch (TTransportException e) {
149 
					logger.error("Problem with Transaction service " + subOrderId);
150 
					e.printStackTrace();
151 
					continue;
152 
				} catch (TException e) {
153 
					logger.error("Problem with Transaction service " + subOrderId);
154 
					e.printStackTrace();
155 
					continue;
8627 vikram.rag 156 
 
10896 vikram.rag 157 
				}
158 
			}
159 
			if(flag) {
160 
				logger.error("Snapdeal suborder id exists " + subOrderId);
161 
				duplicate_orders++;
10895 vikram.rag 162 
				continue;
8627 vikram.rag 163 
			}
10896 vikram.rag 164 
 
8616 vikram.rag 165 
			Transaction txn = new Transaction();
166 
			txn.setShoppingCartid(user.getActiveCartId());
167 
			txn.setCustomer_id(user.getUserId());
8627 vikram.rag 168 
			System.out.println("User Id is " + user.getUserId());
8616 vikram.rag 169 
			txn.setCreatedOn(new Date().getTime());
170 
			txn.setTransactionStatus(TransactionStatus.INIT);
171 
			txn.setStatusDescription("Order for Snapdeal ");
172 
			List<in.shop2020.model.v1.order.Order> orderlist = new ArrayList<in.shop2020.model.v1.order.Order>();
173 
			try {
9240 vikram.rag 174 
				catalogClient =  new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
9573 vikram.rag 175 
				snapdealItem = catalogClient.getSnapdealItembySkuAtSnapdeal(order.getSKUCode());
176 
				if(snapdealItem.getItem_id()!=0){
177 
					sku = snapdealItem.getItem_id();
9456 vikram.rag 178 
				}
9573 vikram.rag 179 
				else{
180 
					sb.append(order.getSuborderId() +" "+"SKU not found "+"\n");
181 
					continue;
9456 vikram.rag 182 
				}
8886 vikram.rag 183 
				if(snapdealItem.getExceptionPrice()!=0 && snapdealItem.getItem_id()!=0 && (order.getSellingPricePerItem() <  snapdealItem.getExceptionPrice())){
8739 vikram.rag 184 
					SellingPrice = snapdealItem.getExceptionPrice();
185 
				}
186 
				else{
187 
					SellingPrice = order.getSellingPricePerItem();
188 
				}
9456 vikram.rag 189 
				lineItem = createLineItem(sku,SellingPrice);
8773 vikram.rag 190 
				if(lineItem == null){
8854 vikram.rag 191 
					sb.append(order.getSuborderId() +" "+"SKU not found "+"\n");
8773 vikram.rag 192 
					continue;
193 
				}
8846 vikram.rag 194 
				lineItem.setExtra_info("SubOrderId = " + order.getSuborderId() + " ReferenceCode = " + order.getReferenceCode());
8616 vikram.rag 195 
			} catch (CatalogServiceException e) {
8773 vikram.rag 196 
				logger.error("Unable to create order for suborderid  " + order.getSuborderId() , e);
8616 vikram.rag 197 
				e.printStackTrace();
8773 vikram.rag 198 
				sb.append(order.getSuborderId() + " " + "Problem with catalog service" + "\n");
8744 vikram.rag 199 
				continue;
8616 vikram.rag 200 
			} catch (TException e) {
8773 vikram.rag 201 
				logger.error("Unable to create order for suborderid  " + order.getSuborderId() , e);
8616 vikram.rag 202 
				e.printStackTrace();
8773 vikram.rag 203 
				sb.append(order.getSuborderId() + " " + "Thrift Exception in Catalog Service" + "\n");
8744 vikram.rag 204 
				continue;
8616 vikram.rag 205 
			}
206 
			in.shop2020.model.v1.order.Order t_order = new in.shop2020.model.v1.order.Order();
8627 vikram.rag 207 
			t_order.setCustomer_id(user.getUserId());
208 
			t_order.setCustomer_email(sourceDetail.getEmail());
209 
			t_order.setCustomer_name(order.getCustomerName());
210 
			t_order.setCustomer_address1("");
211 
			t_order.setCustomer_address2("");
212 
			t_order.setCustomer_city(order.getCity());
9214 vikram.rag 213 
			t_order.setCustomer_mobilenumber("+91-9999999999");
8627 vikram.rag 214 
			t_order.setCustomer_state(order.getState());
215 
			t_order.setCustomer_pincode(String.valueOf(order.getPINCode()));
8742 vikram.rag 216 
			t_order.setTotal_amount(SellingPrice);
8627 vikram.rag 217 
			t_order.setTotal_weight(lineItem.getTotal_weight());
218 
			t_order.setLineitems(Collections.singletonList(lineItem));
8759 vikram.rag 219 
			t_order.setStatus(OrderStatus.PAYMENT_PENDING);
8890 amar.kumar 220 
			t_order.setStatusDescription("Payment Pending");
8627 vikram.rag 221 
			t_order.setCreated_timestamp(new Date().getTime());
222 
			t_order.setOrderType(OrderType.B2C);
223 
			t_order.setCod(false);
224 
			System.out.println("t order created");
225 
			try {
8804 vikram.rag 226 
				SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
8661 vikram.rag 227 
				Date shipDate = null;
228 
				try {
229 
					shipDate= istFormatter.parse(order.getShipByDate());
230 
				} catch (ParseException e) {
8773 vikram.rag 231 
					logger.error("Could not parse order ship date from file " , e);
8661 vikram.rag 232 
					e.printStackTrace();
8775 vikram.rag 233 
					sb.append(order.getSuborderId() + " Could not parse ship date" + " " + "\n");
8744 vikram.rag 234 
					continue;
8661 vikram.rag 235 
				}
8627 vikram.rag 236 
				Calendar time = Calendar.getInstance();
8661 vikram.rag 237 
				t_order.setPromised_shipping_time(shipDate.getTime());
238 
				t_order.setExpected_shipping_time(shipDate.getTime());
8744 vikram.rag 239 
				time.add(Calendar.DAY_OF_MONTH, 4);
8627 vikram.rag 240 
				t_order.setPromised_delivery_time(time.getTimeInMillis());
241 
				t_order.setExpected_delivery_time(time.getTimeInMillis());
242 
				System.out.println("Dates set in transaction");
8697 vikram.rag 243 
			} catch(Exception e) {
8645 vikram.rag 244 
				logger.error("Error in updating Shipping or Delivery Time for suborderid  " + order.getSuborderId());
8775 vikram.rag 245 
				sb.append(order.getSuborderId() + " Could not update delivery time" + " " + "\n");
8627 vikram.rag 246 
				continue;
247 
			}
8657 vikram.rag 248 
			InventoryService.Client inventoryClient = null;
8739 vikram.rag 249 
			Warehouse fulfillmentWarehouse= null;
250 
			try {
251 
				inventoryClient = new InventoryClient().getClient();
252 
				if(snapdealItem.getItem_id()!=0 && snapdealItem.getWarehouseId()!=0) {
253 
					fulfillmentWarehouse = inventoryClient.getWarehouse(snapdealItem.getWarehouseId());
254 
				} else {
9456 vikram.rag 255 
					List<Long> itemAvailability = inventoryClient.getItemAvailabilityAtLocation(sku, 1);
8739 vikram.rag 256 
					fulfillmentWarehouse = inventoryClient.getWarehouse(itemAvailability.get(0));
8789 vikram.rag 257 
					if(fulfillmentWarehouse.getStateId()!=0){
258 
						fulfillmentWarehouse = inventoryClient.getWarehouse(7);
259 
					}
8739 vikram.rag 260 
				}
261 
				t_order.setFulfilmentWarehouseId(fulfillmentWarehouse.getId());
8890 amar.kumar 262 
				long billingWarehouseId = 0;
263 
				if(fulfillmentWarehouse.getBillingWarehouseId()== 0) {
264 
					inventoryClient = new InventoryClient().getClient();
265 
					List<Warehouse> warehouses = inventoryClient.getWarehouses(WarehouseType.OURS, InventoryType.GOOD, fulfillmentWarehouse.getVendor().getId(), 0, 0);
266 
					for(Warehouse warehouse : warehouses) {
267 
						if(warehouse.getBillingWarehouseId()!=0) {
268 
							billingWarehouseId = warehouse.getBillingWarehouseId();
9573 vikram.rag 269 
							break;
8890 amar.kumar 270 
						}
271 
					}
8891 amar.kumar 272 
				}else {
273 
					billingWarehouseId = fulfillmentWarehouse.getBillingWarehouseId();
8890 amar.kumar 274 
				}
9573 vikram.rag 275 
 
8890 amar.kumar 276 
				//logger.info("Billing warehouse id for suborderid  " + order.getSuborderId() + " is " + fulfillmentWarehouse.getBillingWarehouseId());
277 
				t_order.setWarehouse_id(billingWarehouseId);
8845 amar.kumar 278 
				VendorItemPricing vendorItemPricing = new VendorItemPricing();
279 
				if(fulfillmentWarehouse.getId()==7) {
280 
					Item item = new CatalogClient().getClient().getItem(lineItem.getItem_id());
281 
					vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), item.getPreferredVendor());
282 
				} else {
283 
					vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), fulfillmentWarehouse.getVendor().getId());
284 
				}
9573 vikram.rag 285 
 
8739 vikram.rag 286 
				t_order.getLineitems().get(0).setTransfer_price(vendorItemPricing.getTransferPrice());
287 
				t_order.getLineitems().get(0).setNlc(vendorItemPricing.getNlc());
8616 vikram.rag 288 
			} catch (InventoryServiceException e) {
8846 vikram.rag 289 
				logger.error("Error connecting inventory service for suborderid  " + order.getSuborderId() , e);
8775 vikram.rag 290 
				sb.append(order.getSuborderId() + " Inventory Service Exception" + " " + "\n");
8739 vikram.rag 291 
				continue;
8616 vikram.rag 292 
			} catch (TTransportException e) {
8773 vikram.rag 293 
				logger.error("Transport Exception with Inventory Service for suborderid  " + order.getSuborderId() , e);
8775 vikram.rag 294 
				sb.append(order.getSuborderId() + " Transport Exception with Inventory Service" + " " + "\n");
8744 vikram.rag 295 
				continue;
8616 vikram.rag 296 
			} catch (TException e) {
8773 vikram.rag 297 
				logger.error("Exception with Inventory Service for suborderid  " + order.getSuborderId() , e);
8775 vikram.rag 298 
				sb.append(order.getSuborderId() + " Exception in Inventory Service" + " " + "\n");
8744 vikram.rag 299 
				continue;
8845 amar.kumar 300 
			} catch (CatalogServiceException e) {
301 
				logger.error("Exception with Catalog Service for suborderid  " + order.getSuborderId() + " while getting item " + lineItem.getItem_id(), e);
302 
				sb.append(order.getSuborderId() + " Exception in Catalog Service" + " " + "\n");
303 
				continue;
8657 vikram.rag 304 
			}
8616 vikram.rag 305 
			if(order.getCourier().equalsIgnoreCase(FIRSTFLIGHT)) {
306 
				t_order.setLogistics_provider_id(12);
307 
			} else if(order.getCourier().equalsIgnoreCase(DELHIVERY)) {
308 
				t_order.setLogistics_provider_id(13);
309 
			} else if(order.getCourier().equalsIgnoreCase(BLUEDART)) {
310 
				t_order.setLogistics_provider_id(14);
8642 vikram.rag 311 
			}else if(order.getCourier().equalsIgnoreCase(CHHOTU)) {
312 
				t_order.setLogistics_provider_id(16);
8715 vikram.rag 313 
			}
314 
			else if(order.getCourier().equalsIgnoreCase(LAST_MILE)){
315 
				t_order.setLogistics_provider_id(17);
316 
			}
317 
			else if(order.getCourier().equalsIgnoreCase(ECOMM_EXP)){
318 
				t_order.setLogistics_provider_id(18);
319 
			}
320 
			else if(order.getCourier().equalsIgnoreCase(EWINGS)){
321 
				t_order.setLogistics_provider_id(19);
322 
			}
323 
			else if(order.getCourier().equalsIgnoreCase(DTDC)){
324 
				t_order.setLogistics_provider_id(20);
325 
			}
326 
			else if(order.getCourier().equalsIgnoreCase(WAREOLOG)){
327 
				t_order.setLogistics_provider_id(21);
328 
			}
329 
			else if(order.getCourier().equalsIgnoreCase(MIRAKLE)){
330 
				t_order.setLogistics_provider_id(22);
331 
			}
332 
			else if(order.getCourier().equalsIgnoreCase(RAJIV_TRANSPORT)){
333 
				t_order.setLogistics_provider_id(23);
334 
			}
335 
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_HIGH_VALUE)){
336 
				t_order.setLogistics_provider_id(24);
337 
			}
338 
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_SURFACE)){
339 
				t_order.setLogistics_provider_id(25);
340 
			}
341 
			else if(order.getCourier().equalsIgnoreCase(BLUEDART_APEX)){
342 
				t_order.setLogistics_provider_id(26);
343 
			}
344 
			else if(order.getCourier().equalsIgnoreCase(ARAMEX)){
345 
				t_order.setLogistics_provider_id(27);
346 
			}
347 
			else if(order.getCourier().equalsIgnoreCase(GATI)){
348 
				t_order.setLogistics_provider_id(28);
349 
			}
350 
			else if(order.getCourier().equalsIgnoreCase(INDIA_POST)){
351 
				t_order.setLogistics_provider_id(29);
352 
			}
353 
			else if(order.getCourier().equalsIgnoreCase(FEDEX)){
354 
				t_order.setLogistics_provider_id(30);
355 
			}
356 
			else if(order.getCourier().equalsIgnoreCase(IOT)){
357 
				t_order.setLogistics_provider_id(31);
358 
			}
359 
			else if(order.getCourier().equalsIgnoreCase(RED_EXP)){
360 
				t_order.setLogistics_provider_id(32);
361 
			}
362 
			else if(order.getCourier().equalsIgnoreCase(VDELIVER)){
363 
				t_order.setLogistics_provider_id(33);
364 
			}
365 
			else if(order.getCourier().equalsIgnoreCase(GHARPAY)){
366 
				t_order.setLogistics_provider_id(34);
367 
			}
368 
			else if(order.getCourier().equalsIgnoreCase(QUANTIUM)){
369 
				t_order.setLogistics_provider_id(35);
370 
			}
371 
			else if(order.getCourier().equalsIgnoreCase(GATI_AIR)){
372 
				t_order.setLogistics_provider_id(36);
373 
			}
9137 vikram.rag 374 
			else if(order.getCourier().equalsIgnoreCase(OVERNITE_EXP)){
375 
				t_order.setLogistics_provider_id(37);
376 
			}
10235 vikram.rag 377 
			else if(order.getCourier().equalsIgnoreCase(BIBHA_CARGO)){
378 
				t_order.setLogistics_provider_id(38);
379 
			}
10570 manish.sha 380 
			else if(order.getCourier().equalsIgnoreCase(FF_DELHI)){
381 
				t_order.setLogistics_provider_id(39);
382 
			}
10574 vikram.rag 383 
			else if(order.getCourier().equalsIgnoreCase(FF_GURGAON)){
384 
				t_order.setLogistics_provider_id(40);
385 
			}
10761 kshitij.so 386 
			else if(order.getCourier().trim().equalsIgnoreCase(TANVI_EXPRESS)){
10705 manish.sha 387 
				t_order.setLogistics_provider_id(41);
388 
			}
10761 kshitij.so 389 
			else if(order.getCourier().trim().equalsIgnoreCase(VELIX)){
10896 vikram.rag 390 
				t_order.setLogistics_provider_id(42);
391 
			}
10768 manish.sha 392 
			else if(order.getCourier().trim().equalsIgnoreCase(XPRESSBEES)){
10896 vikram.rag 393 
				t_order.setLogistics_provider_id(43);
394 
			}
395 
 
8715 vikram.rag 396 
			else {
10869 vikram.rag 397 
				t_order.setLogistics_provider_id(44);
398 
				/*logger.error("Error No Courier Match please add courier to our system for suborderid  " + order.getSuborderId() + "Courier Name " + order.getCourier());
8773 vikram.rag 399 
				sb.append(order.getSuborderId() + " Error No Courier Match " + order.getCourier() +"\n");
8627 vikram.rag 400 
				continue;
10869 vikram.rag 401 
				 */
8616 vikram.rag 402 
			}
8627 vikram.rag 403 
 
8616 vikram.rag 404 
			t_order.setAirwaybill_no(String.valueOf(order.getAWBNumber()));
405 
			t_order.setTracking_id(String.valueOf(order.getAWBNumber()));
8739 vikram.rag 406 
			t_order.setTotal_amount(SellingPrice);
8627 vikram.rag 407 
			t_order.setOrderType(OrderType.B2C);
408 
			t_order.setSource(SNAPDEAL_SOURCE_ID);
409 
			t_order.setOrderType(OrderType.B2C);
410 
			orderlist.add(t_order);
411 
			txn.setOrders(orderlist);
8739 vikram.rag 412 
			String referenceCode = order.getReferenceCode();
413 
			String productName = order.getProduct();
414 
			SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
415 
			Date snapdealTxnDate = null;
416 
			try {
417 
				snapdealTxnDate = istFormatter.parse(order.getOrderPlacedDate());
418 
			} catch (ParseException e) {
8773 vikram.rag 419 
				logger.error(order.getSuborderId() + " Could not parse snapdeal order date from file " , e);
420 
				sb.append(order.getSuborderId() + " Could not parse order date" +"\n");
8744 vikram.rag 421 
				continue;
8739 vikram.rag 422 
			}
423 
			try {
424 
				transactionId =  String.valueOf(transaction_client.createTransaction(txn));
425 
			} catch (TransactionServiceException e) {
8773 vikram.rag 426 
				logger.error(order.getSuborderId() + " Could not create transaction " , e);
427 
				sb.append(order.getSuborderId() + " Could not create transaction" +"\n");
8744 vikram.rag 428 
				continue;
8739 vikram.rag 429 
			} catch (TException e) {
8773 vikram.rag 430 
				logger.error("Problem with transaction service while creating transaction", e);
8775 vikram.rag 431 
				sb.append(order.getSuborderId() + " Transaction Service Exception could not create transaction" +"\n");
8744 vikram.rag 432 
				continue;
8739 vikram.rag 433 
			}
8806 vikram.rag 434 
			try{
9151 vikram.rag 435 
				paymentId = createPayment(user, (new Long(subOrderId)).toString(),lineItem.getTotal_price());
8806 vikram.rag 436 
			}
437 
			catch (NumberFormatException e) {
438 
				logger.error("Could not create payment",e);
439 
				sb.append(order.getSuborderId() + " Could not create payment");
440 
				e.printStackTrace();
441 
				continue;
442 
			} catch (PaymentException e) {
443 
				logger.error("Could not create payment payment exception",e);
444 
				sb.append(order.getSuborderId() + " Could not create payment Payment exception");
445 
				e.printStackTrace();
446 
				continue;
447 
			} catch (TException e) {
448 
				logger.error("Could not create payment thrift exception",e);
449 
				sb.append(order.getSuborderId() + " Could not create payment Thrift exception");
450 
				e.printStackTrace();
451 
				continue;
452 
			}
8739 vikram.rag 453 
			Transaction transaction = null;
454 
			try {
455 
				transaction = transaction_client.getTransaction(Long.parseLong(transactionId));
456 
			} catch (NumberFormatException e) {
457 
				logger.error("Problem parsing transaction id " + transactionId);
8773 vikram.rag 458 
				sb.append(order.getSuborderId() + " Problem parsing transaction id "+ transactionId +"\n");
8739 vikram.rag 459 
				e.printStackTrace();
8744 vikram.rag 460 
				continue;
8739 vikram.rag 461 
			} catch (TransactionServiceException e) {
462 
				logger.error("Problem getting transaction from service transaction id " + transactionId);
8773 vikram.rag 463 
				sb.append(order.getSuborderId() + " Problem getting transaction id "+ transactionId +"\n");
8739 vikram.rag 464 
				e.printStackTrace();
8744 vikram.rag 465 
				continue;
8739 vikram.rag 466 
			} catch (TException e) {
467 
				logger.error("Problem with transaction service while getting transaction id " + transactionId);
8773 vikram.rag 468 
				sb.append(order.getSuborderId() + " Problem with transaction service while getting transaction id "+ transactionId +"\n");
8739 vikram.rag 469 
				e.printStackTrace();
8744 vikram.rag 470 
				continue;
8739 vikram.rag 471 
			}
472 
			in.shop2020.model.v1.order.Order snapdealorder = transaction.getOrders().get(0);
8744 vikram.rag 473 
			try {
474 
				inventoryClient.reserveItemInWarehouse(lineItem.getItem_id(), fulfillmentWarehouse.getId(), 1,
8773 vikram.rag 475 
						snapdealorder.getId(), snapdealorder.getCreated_timestamp(), snapdealorder.getPromised_shipping_time(), snapdealorder.getLineitems().get(0).getQuantity());
8744 vikram.rag 476 
			} catch (InventoryServiceException e1) {
477 
				logger.error("Problem while reserving item in inventory service" + snapdealorder.getId());
9456 vikram.rag 478 
				sb.append(order.getSuborderId() + " Could not reserve inventory for sku "+ sku +"\n");
8744 vikram.rag 479 
				continue;
480 
			} catch (TException e1) {
481 
				logger.error("Problem with inventory service" + snapdealorder.getId());
9456 vikram.rag 482 
				sb.append(order.getSuborderId() + " Problem with inventory service while reserving inventory for sku "+ sku +"\n");
8744 vikram.rag 483 
				continue;
484 
			}
8739 vikram.rag 485 
			SnapdealOrder snapdealOrder = new SnapdealOrder();
486 
			snapdealOrder.setOrderId(snapdealorder.getId());
487 
			snapdealOrder.setSubOrderId(subOrderId);
488 
			snapdealOrder.setReferenceCode(referenceCode);
489 
			snapdealOrder.setProductName(productName);
490 
			snapdealOrder.setSnapdealTxnDate(snapdealTxnDate.getTime());
491 
			snapdealOrder.setListingPrice(order.getSellingPricePerItem());
9456 vikram.rag 492 
			snapdealOrder.setMaxNlc(snapdealItem.getMaxNlc());
8739 vikram.rag 493 
			try {
494 
				transaction_client.createSnapdealOrder(snapdealOrder);
9631 vikram.rag 495 
				new PaymentClient().getClient().updatePaymentDetails(paymentId, null, null, null, null, null, null, subOrderId, null, PaymentStatus.SUCCESS, null, null);
9573 vikram.rag 496 
 
8739 vikram.rag 497 
			} catch (TException e) {
498 
				logger.error("Could not create Snapdeal Order");
8773 vikram.rag 499 
				sb.append(order.getSuborderId() + " Could not create snapdeal order"+"\n");
9151 vikram.rag 500 
			} catch (PaymentException e) {
501 
				logger.error("Could not update payment for Snapdeal Order");
502 
				sb.append(order.getSuborderId() + " Could not update payment for snapdeal order"+"\n");
8739 vikram.rag 503 
			}
8773 vikram.rag 504 
			processed_orders++;
8789 vikram.rag 505 
 
8773 vikram.rag 506 
		}
507 
		java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
508 
		Calendar cal=GregorianCalendar.getInstance();
509 
		String emailFromAddress = "build@shop2020.in";
510 
		String password = "cafe@nes";
511 
		GmailUtils mailer = new GmailUtils();
8808 vikram.rag 512 
		//String sendTo[] = new String[]{"vikram.raghav@shop2020.in"};
513 
		String sendTo[] = new String[]{ "sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
514 
				"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
10253 manish.sha 515 
				"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in"};
8806 vikram.rag 516 
 
8773 vikram.rag 517 
		try {
8800 vikram.rag 518 
			if(new_orders==processed_orders && new_orders > 0){
519 
				String emailSubjectTxt = "Snapdeal Orders Created Successfully "+sdf.format(cal.getTime());
520 
				String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" +
8801 vikram.rag 521 
				"Orders Already Existing : " + duplicate_orders + "\n" +
8800 vikram.rag 522 
				"Processed Orders : " + processed_orders + "\n" +
523 
				"Failed Orders : " + (new_orders - processed_orders);
8773 vikram.rag 524 
				mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
525 
			}
8800 vikram.rag 526 
			else if(new_orders > 0){
527 
				String emailSubjectTxt = "Snapdeal Orders Failed while creation "+sdf.format(cal.getTime());
528 
				String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" +
8801 vikram.rag 529 
				"Orders Already Existing : " + duplicate_orders + "\n" +
8800 vikram.rag 530 
				"Processed Orders : " + processed_orders + "\n" +
531 
				"Failed Orders : " + (new_orders - processed_orders) + "\n"+ "\n" +
532 
				sb.toString();
8773 vikram.rag 533 
				mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
534 
			}
8800 vikram.rag 535 
			else{
8808 vikram.rag 536 
				//sendTo[] = new String[]{"vikram.raghav@shop2020.in"};
537 
				sendTo = new String[]{"engg@shop2020.in","sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
538 
						"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
539 
						"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in"};
540 
 
8800 vikram.rag 541 
				String emailSubjectTxt = "No new Snapdeal Orders " + sdf.format(cal.getTime());
542 
				String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" +
8801 vikram.rag 543 
				"Orders Already Existing : " + duplicate_orders + "\n" +
8800 vikram.rag 544 
				"Processed Orders : " + processed_orders + "\n" +
545 
				"Failed Orders : " + (new_orders - processed_orders) + "\n"+ "\n" +
546 
				sb.toString();
547 
				mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
548 
			}
8773 vikram.rag 549 
		}
550 
		catch (Exception e) {
551 
			e.printStackTrace();
552 
		}
8627 vikram.rag 553 
 
8616 vikram.rag 554 
 
8773 vikram.rag 555 
 
8616 vikram.rag 556 
	}
557 
 
9151 vikram.rag 558 
	public static long createPayment(User user, String subOrderId, double amount) throws NumberFormatException, PaymentException, TException {
9573 vikram.rag 559 
		in.shop2020.payments.PaymentService.Client client = new PaymentClient().getClient();
560 
		return client.createPayment(user.getUserId(), amount, SNAPDEAL_GATEWAY_ID, Long.valueOf(transactionId), false);
561 
 
8627 vikram.rag 562 
	}
563 
 
8616 vikram.rag 564 
	public static LineItem createLineItem(long itemId, double amount) throws CatalogServiceException, TException {
8627 vikram.rag 565 
		LineItem lineItem = new LineItem();
566 
		CatalogService.Client catalogClient = new CatalogClient().getClient();
567 
		Item item = catalogClient.getItem(itemId);
8773 vikram.rag 568 
		if(item.getId()==0){
569 
			//in case item id is incorrect..
570 
			return null;
571 
		}
8616 vikram.rag 572 
 
8627 vikram.rag 573 
		lineItem.setProductGroup(item.getProductGroup());
574 
		lineItem.setBrand(item.getBrand());
575 
		lineItem.setModel_number(item.getModelNumber());
576 
		lineItem.setModel_name(item.getModelName());
577 
		lineItem.setExtra_info(item.getFeatureDescription());
578 
		lineItem.setQuantity(1);
579 
		lineItem.setItem_id(item.getId());
580 
		lineItem.setUnit_weight(item.getWeight());
581 
		lineItem.setTotal_weight(item.getWeight());
582 
		lineItem.setUnit_price(amount);
583 
		lineItem.setTotal_price(amount);
584 
 
8739 vikram.rag 585 
		if (item.getColor() == null || "NA".equals(item.getColor())) {
8627 vikram.rag 586 
			lineItem.setColor("");
587 
		} else {
588 
			lineItem.setColor(item.getColor());
589 
		}
590 
		return lineItem;
8616 vikram.rag 591 
	}
592 
 
593 
}