Subversion Repositories SmartDukaan

Rev

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