| 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";
|
| 8844 |
amar.kumar |
60 |
private static final String ECOMM_EXP = "Ecom Express";
|
| 8715 |
vikram.rag |
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){
|
| 8854 |
vikram.rag |
152 |
sb.append(order.getSuborderId() +" "+"SKU not found "+"\n");
|
| 8773 |
vikram.rag |
153 |
continue;
|
|
|
154 |
}
|
| 8846 |
vikram.rag |
155 |
lineItem.setExtra_info("SubOrderId = " + order.getSuborderId() + " ReferenceCode = " + order.getReferenceCode());
|
| 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);
|
| 8844 |
amar.kumar |
180 |
t_order.setStatusDescription("In Process");
|
| 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());
|
| 8845 |
amar.kumar |
224 |
VendorItemPricing vendorItemPricing = new VendorItemPricing();
|
|
|
225 |
if(fulfillmentWarehouse.getId()==7) {
|
|
|
226 |
Item item = new CatalogClient().getClient().getItem(lineItem.getItem_id());
|
|
|
227 |
vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), item.getPreferredVendor());
|
|
|
228 |
} else {
|
|
|
229 |
vendorItemPricing = inventoryClient.getItemPricing(lineItem.getItem_id(), fulfillmentWarehouse.getVendor().getId());
|
|
|
230 |
}
|
|
|
231 |
|
| 8739 |
vikram.rag |
232 |
t_order.getLineitems().get(0).setTransfer_price(vendorItemPricing.getTransferPrice());
|
|
|
233 |
t_order.getLineitems().get(0).setNlc(vendorItemPricing.getNlc());
|
| 8616 |
vikram.rag |
234 |
} catch (InventoryServiceException e) {
|
| 8846 |
vikram.rag |
235 |
logger.error("Error connecting inventory service for suborderid " + order.getSuborderId() , e);
|
| 8775 |
vikram.rag |
236 |
sb.append(order.getSuborderId() + " Inventory Service Exception" + " " + "\n");
|
| 8739 |
vikram.rag |
237 |
continue;
|
| 8616 |
vikram.rag |
238 |
} catch (TTransportException e) {
|
| 8773 |
vikram.rag |
239 |
logger.error("Transport Exception with Inventory Service for suborderid " + order.getSuborderId() , e);
|
| 8775 |
vikram.rag |
240 |
sb.append(order.getSuborderId() + " Transport Exception with Inventory Service" + " " + "\n");
|
| 8744 |
vikram.rag |
241 |
continue;
|
| 8616 |
vikram.rag |
242 |
} catch (TException e) {
|
| 8773 |
vikram.rag |
243 |
logger.error("Exception with Inventory Service for suborderid " + order.getSuborderId() , e);
|
| 8775 |
vikram.rag |
244 |
sb.append(order.getSuborderId() + " Exception in Inventory Service" + " " + "\n");
|
| 8744 |
vikram.rag |
245 |
continue;
|
| 8845 |
amar.kumar |
246 |
} catch (CatalogServiceException e) {
|
|
|
247 |
logger.error("Exception with Catalog Service for suborderid " + order.getSuborderId() + " while getting item " + lineItem.getItem_id(), e);
|
|
|
248 |
sb.append(order.getSuborderId() + " Exception in Catalog Service" + " " + "\n");
|
|
|
249 |
continue;
|
| 8657 |
vikram.rag |
250 |
}
|
| 8616 |
vikram.rag |
251 |
if(order.getCourier().equalsIgnoreCase(FIRSTFLIGHT)) {
|
|
|
252 |
t_order.setLogistics_provider_id(12);
|
|
|
253 |
} else if(order.getCourier().equalsIgnoreCase(DELHIVERY)) {
|
|
|
254 |
t_order.setLogistics_provider_id(13);
|
|
|
255 |
} else if(order.getCourier().equalsIgnoreCase(BLUEDART)) {
|
|
|
256 |
t_order.setLogistics_provider_id(14);
|
| 8642 |
vikram.rag |
257 |
}else if(order.getCourier().equalsIgnoreCase(CHHOTU)) {
|
|
|
258 |
t_order.setLogistics_provider_id(16);
|
| 8715 |
vikram.rag |
259 |
}
|
|
|
260 |
else if(order.getCourier().equalsIgnoreCase(LAST_MILE)){
|
|
|
261 |
t_order.setLogistics_provider_id(17);
|
|
|
262 |
}
|
|
|
263 |
else if(order.getCourier().equalsIgnoreCase(ECOMM_EXP)){
|
|
|
264 |
t_order.setLogistics_provider_id(18);
|
|
|
265 |
}
|
|
|
266 |
else if(order.getCourier().equalsIgnoreCase(EWINGS)){
|
|
|
267 |
t_order.setLogistics_provider_id(19);
|
|
|
268 |
}
|
|
|
269 |
else if(order.getCourier().equalsIgnoreCase(DTDC)){
|
|
|
270 |
t_order.setLogistics_provider_id(20);
|
|
|
271 |
}
|
|
|
272 |
else if(order.getCourier().equalsIgnoreCase(WAREOLOG)){
|
|
|
273 |
t_order.setLogistics_provider_id(21);
|
|
|
274 |
}
|
|
|
275 |
else if(order.getCourier().equalsIgnoreCase(MIRAKLE)){
|
|
|
276 |
t_order.setLogistics_provider_id(22);
|
|
|
277 |
}
|
|
|
278 |
else if(order.getCourier().equalsIgnoreCase(RAJIV_TRANSPORT)){
|
|
|
279 |
t_order.setLogistics_provider_id(23);
|
|
|
280 |
}
|
|
|
281 |
else if(order.getCourier().equalsIgnoreCase(BLUEDART_HIGH_VALUE)){
|
|
|
282 |
t_order.setLogistics_provider_id(24);
|
|
|
283 |
}
|
|
|
284 |
else if(order.getCourier().equalsIgnoreCase(BLUEDART_SURFACE)){
|
|
|
285 |
t_order.setLogistics_provider_id(25);
|
|
|
286 |
}
|
|
|
287 |
else if(order.getCourier().equalsIgnoreCase(BLUEDART_APEX)){
|
|
|
288 |
t_order.setLogistics_provider_id(26);
|
|
|
289 |
}
|
|
|
290 |
else if(order.getCourier().equalsIgnoreCase(ARAMEX)){
|
|
|
291 |
t_order.setLogistics_provider_id(27);
|
|
|
292 |
}
|
|
|
293 |
else if(order.getCourier().equalsIgnoreCase(GATI)){
|
|
|
294 |
t_order.setLogistics_provider_id(28);
|
|
|
295 |
}
|
|
|
296 |
else if(order.getCourier().equalsIgnoreCase(INDIA_POST)){
|
|
|
297 |
t_order.setLogistics_provider_id(29);
|
|
|
298 |
}
|
|
|
299 |
else if(order.getCourier().equalsIgnoreCase(FEDEX)){
|
|
|
300 |
t_order.setLogistics_provider_id(30);
|
|
|
301 |
}
|
|
|
302 |
else if(order.getCourier().equalsIgnoreCase(IOT)){
|
|
|
303 |
t_order.setLogistics_provider_id(31);
|
|
|
304 |
}
|
|
|
305 |
else if(order.getCourier().equalsIgnoreCase(RED_EXP)){
|
|
|
306 |
t_order.setLogistics_provider_id(32);
|
|
|
307 |
}
|
|
|
308 |
else if(order.getCourier().equalsIgnoreCase(VDELIVER)){
|
|
|
309 |
t_order.setLogistics_provider_id(33);
|
|
|
310 |
}
|
|
|
311 |
else if(order.getCourier().equalsIgnoreCase(GHARPAY)){
|
|
|
312 |
t_order.setLogistics_provider_id(34);
|
|
|
313 |
}
|
|
|
314 |
else if(order.getCourier().equalsIgnoreCase(QUANTIUM)){
|
|
|
315 |
t_order.setLogistics_provider_id(35);
|
|
|
316 |
}
|
|
|
317 |
else if(order.getCourier().equalsIgnoreCase(GATI_AIR)){
|
|
|
318 |
t_order.setLogistics_provider_id(36);
|
|
|
319 |
}
|
|
|
320 |
else {
|
| 8652 |
vikram.rag |
321 |
logger.error("Error No Courier Match please add courier to our system for suborderid " + order.getSuborderId() + "Courier Name " + order.getCourier());
|
| 8773 |
vikram.rag |
322 |
sb.append(order.getSuborderId() + " Error No Courier Match " + order.getCourier() +"\n");
|
| 8627 |
vikram.rag |
323 |
continue;
|
| 8616 |
vikram.rag |
324 |
}
|
| 8627 |
vikram.rag |
325 |
|
| 8616 |
vikram.rag |
326 |
t_order.setAirwaybill_no(String.valueOf(order.getAWBNumber()));
|
|
|
327 |
t_order.setTracking_id(String.valueOf(order.getAWBNumber()));
|
| 8739 |
vikram.rag |
328 |
t_order.setTotal_amount(SellingPrice);
|
| 8627 |
vikram.rag |
329 |
t_order.setOrderType(OrderType.B2C);
|
|
|
330 |
t_order.setSource(SNAPDEAL_SOURCE_ID);
|
|
|
331 |
t_order.setOrderType(OrderType.B2C);
|
|
|
332 |
orderlist.add(t_order);
|
|
|
333 |
txn.setOrders(orderlist);
|
| 8739 |
vikram.rag |
334 |
String referenceCode = order.getReferenceCode();
|
|
|
335 |
String productName = order.getProduct();
|
|
|
336 |
SimpleDateFormat istFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
|
|
337 |
Date snapdealTxnDate = null;
|
|
|
338 |
try {
|
|
|
339 |
snapdealTxnDate = istFormatter.parse(order.getOrderPlacedDate());
|
|
|
340 |
} catch (ParseException e) {
|
| 8773 |
vikram.rag |
341 |
logger.error(order.getSuborderId() + " Could not parse snapdeal order date from file " , e);
|
|
|
342 |
sb.append(order.getSuborderId() + " Could not parse order date" +"\n");
|
| 8744 |
vikram.rag |
343 |
continue;
|
| 8739 |
vikram.rag |
344 |
}
|
|
|
345 |
try {
|
|
|
346 |
transactionId = String.valueOf(transaction_client.createTransaction(txn));
|
|
|
347 |
} catch (TransactionServiceException e) {
|
| 8773 |
vikram.rag |
348 |
logger.error(order.getSuborderId() + " Could not create transaction " , e);
|
|
|
349 |
sb.append(order.getSuborderId() + " Could not create transaction" +"\n");
|
| 8744 |
vikram.rag |
350 |
continue;
|
| 8739 |
vikram.rag |
351 |
} catch (TException e) {
|
| 8773 |
vikram.rag |
352 |
logger.error("Problem with transaction service while creating transaction", e);
|
| 8775 |
vikram.rag |
353 |
sb.append(order.getSuborderId() + " Transaction Service Exception could not create transaction" +"\n");
|
| 8744 |
vikram.rag |
354 |
continue;
|
| 8739 |
vikram.rag |
355 |
}
|
| 8806 |
vikram.rag |
356 |
try{
|
|
|
357 |
createPayment(user, (new Long(subOrderId)).toString(),lineItem.getTotal_price());
|
|
|
358 |
}
|
|
|
359 |
catch (NumberFormatException e) {
|
|
|
360 |
logger.error("Could not create payment",e);
|
|
|
361 |
sb.append(order.getSuborderId() + " Could not create payment");
|
|
|
362 |
e.printStackTrace();
|
|
|
363 |
continue;
|
|
|
364 |
} catch (PaymentException e) {
|
|
|
365 |
logger.error("Could not create payment payment exception",e);
|
|
|
366 |
sb.append(order.getSuborderId() + " Could not create payment Payment exception");
|
|
|
367 |
e.printStackTrace();
|
|
|
368 |
continue;
|
|
|
369 |
} catch (TException e) {
|
|
|
370 |
logger.error("Could not create payment thrift exception",e);
|
|
|
371 |
sb.append(order.getSuborderId() + " Could not create payment Thrift exception");
|
|
|
372 |
e.printStackTrace();
|
|
|
373 |
continue;
|
|
|
374 |
}
|
| 8739 |
vikram.rag |
375 |
Transaction transaction = null;
|
|
|
376 |
try {
|
|
|
377 |
transaction = transaction_client.getTransaction(Long.parseLong(transactionId));
|
|
|
378 |
} catch (NumberFormatException e) {
|
|
|
379 |
logger.error("Problem parsing transaction id " + transactionId);
|
| 8773 |
vikram.rag |
380 |
sb.append(order.getSuborderId() + " Problem parsing transaction id "+ transactionId +"\n");
|
| 8739 |
vikram.rag |
381 |
e.printStackTrace();
|
| 8744 |
vikram.rag |
382 |
continue;
|
| 8739 |
vikram.rag |
383 |
} catch (TransactionServiceException e) {
|
|
|
384 |
logger.error("Problem getting transaction from service transaction id " + transactionId);
|
| 8773 |
vikram.rag |
385 |
sb.append(order.getSuborderId() + " Problem getting transaction id "+ transactionId +"\n");
|
| 8739 |
vikram.rag |
386 |
e.printStackTrace();
|
| 8744 |
vikram.rag |
387 |
continue;
|
| 8739 |
vikram.rag |
388 |
} catch (TException e) {
|
|
|
389 |
logger.error("Problem with transaction service while getting transaction id " + transactionId);
|
| 8773 |
vikram.rag |
390 |
sb.append(order.getSuborderId() + " Problem with transaction service while getting transaction id "+ transactionId +"\n");
|
| 8739 |
vikram.rag |
391 |
e.printStackTrace();
|
| 8744 |
vikram.rag |
392 |
continue;
|
| 8739 |
vikram.rag |
393 |
}
|
|
|
394 |
in.shop2020.model.v1.order.Order snapdealorder = transaction.getOrders().get(0);
|
| 8744 |
vikram.rag |
395 |
try {
|
|
|
396 |
inventoryClient.reserveItemInWarehouse(lineItem.getItem_id(), fulfillmentWarehouse.getId(), 1,
|
| 8773 |
vikram.rag |
397 |
snapdealorder.getId(), snapdealorder.getCreated_timestamp(), snapdealorder.getPromised_shipping_time(), snapdealorder.getLineitems().get(0).getQuantity());
|
| 8744 |
vikram.rag |
398 |
} catch (InventoryServiceException e1) {
|
|
|
399 |
logger.error("Problem while reserving item in inventory service" + snapdealorder.getId());
|
| 8773 |
vikram.rag |
400 |
sb.append(order.getSuborderId() + " Could not reserve inventory for sku "+ order.getSKUCode() +"\n");
|
| 8744 |
vikram.rag |
401 |
continue;
|
|
|
402 |
} catch (TException e1) {
|
|
|
403 |
logger.error("Problem with inventory service" + snapdealorder.getId());
|
| 8773 |
vikram.rag |
404 |
sb.append(order.getSuborderId() + " Problem with inventory service while reserving inventory for sku "+ order.getSKUCode() +"\n");
|
| 8744 |
vikram.rag |
405 |
continue;
|
|
|
406 |
}
|
| 8739 |
vikram.rag |
407 |
SnapdealOrder snapdealOrder = new SnapdealOrder();
|
|
|
408 |
snapdealOrder.setOrderId(snapdealorder.getId());
|
|
|
409 |
snapdealOrder.setSubOrderId(subOrderId);
|
|
|
410 |
snapdealOrder.setReferenceCode(referenceCode);
|
|
|
411 |
snapdealOrder.setProductName(productName);
|
|
|
412 |
snapdealOrder.setSnapdealTxnDate(snapdealTxnDate.getTime());
|
|
|
413 |
snapdealOrder.setListingPrice(order.getSellingPricePerItem());
|
|
|
414 |
try {
|
|
|
415 |
transaction_client.createSnapdealOrder(snapdealOrder);
|
|
|
416 |
} catch (TException e) {
|
|
|
417 |
logger.error("Could not create Snapdeal Order");
|
| 8773 |
vikram.rag |
418 |
sb.append(order.getSuborderId() + " Could not create snapdeal order"+"\n");
|
| 8739 |
vikram.rag |
419 |
}
|
| 8773 |
vikram.rag |
420 |
processed_orders++;
|
| 8789 |
vikram.rag |
421 |
|
| 8773 |
vikram.rag |
422 |
}
|
|
|
423 |
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-MM-dd-HH:mm:ss");
|
|
|
424 |
Calendar cal=GregorianCalendar.getInstance();
|
|
|
425 |
String emailFromAddress = "build@shop2020.in";
|
|
|
426 |
String password = "cafe@nes";
|
|
|
427 |
GmailUtils mailer = new GmailUtils();
|
| 8808 |
vikram.rag |
428 |
//String sendTo[] = new String[]{"vikram.raghav@shop2020.in"};
|
|
|
429 |
String sendTo[] = new String[]{ "sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
|
|
|
430 |
"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
|
| 8849 |
vikram.rag |
431 |
"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in","amar.kumar@shop2020.in"};
|
| 8806 |
vikram.rag |
432 |
|
| 8773 |
vikram.rag |
433 |
try {
|
| 8800 |
vikram.rag |
434 |
if(new_orders==processed_orders && new_orders > 0){
|
|
|
435 |
String emailSubjectTxt = "Snapdeal Orders Created Successfully "+sdf.format(cal.getTime());
|
|
|
436 |
String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" +
|
| 8801 |
vikram.rag |
437 |
"Orders Already Existing : " + duplicate_orders + "\n" +
|
| 8800 |
vikram.rag |
438 |
"Processed Orders : " + processed_orders + "\n" +
|
|
|
439 |
"Failed Orders : " + (new_orders - processed_orders);
|
| 8773 |
vikram.rag |
440 |
mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
|
|
|
441 |
}
|
| 8800 |
vikram.rag |
442 |
else if(new_orders > 0){
|
|
|
443 |
String emailSubjectTxt = "Snapdeal Orders Failed while creation "+sdf.format(cal.getTime());
|
|
|
444 |
String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" +
|
| 8801 |
vikram.rag |
445 |
"Orders Already Existing : " + duplicate_orders + "\n" +
|
| 8800 |
vikram.rag |
446 |
"Processed Orders : " + processed_orders + "\n" +
|
|
|
447 |
"Failed Orders : " + (new_orders - processed_orders) + "\n"+ "\n" +
|
|
|
448 |
sb.toString();
|
| 8773 |
vikram.rag |
449 |
mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
|
|
|
450 |
}
|
| 8800 |
vikram.rag |
451 |
else{
|
| 8808 |
vikram.rag |
452 |
//sendTo[] = new String[]{"vikram.raghav@shop2020.in"};
|
|
|
453 |
sendTo = new String[]{"engg@shop2020.in","sandeep.sachdeva@shop2020.in", "vikram.raghav@shop2020.in", "rajneesh.arora@shop2020.in",
|
|
|
454 |
"khushal.bhatia@shop2020.in","manoj.kumar@saholic.com","chaitnaya.vats@saholic.com",
|
|
|
455 |
"yukti.jain@shop2020.in","manisha.sharma@shop2020.in","chandan.kumar@shop2020.in","ankush.dhingra@shop2020.in"};
|
|
|
456 |
|
| 8800 |
vikram.rag |
457 |
String emailSubjectTxt = "No new Snapdeal Orders " + sdf.format(cal.getTime());
|
|
|
458 |
String text = "Total Orders Received : " + ( new_orders + duplicate_orders ) + "\n" +
|
| 8801 |
vikram.rag |
459 |
"Orders Already Existing : " + duplicate_orders + "\n" +
|
| 8800 |
vikram.rag |
460 |
"Processed Orders : " + processed_orders + "\n" +
|
|
|
461 |
"Failed Orders : " + (new_orders - processed_orders) + "\n"+ "\n" +
|
|
|
462 |
sb.toString();
|
|
|
463 |
mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
|
|
|
464 |
}
|
| 8773 |
vikram.rag |
465 |
}
|
|
|
466 |
catch (Exception e) {
|
|
|
467 |
e.printStackTrace();
|
|
|
468 |
}
|
| 8627 |
vikram.rag |
469 |
|
| 8616 |
vikram.rag |
470 |
|
| 8773 |
vikram.rag |
471 |
|
| 8616 |
vikram.rag |
472 |
}
|
|
|
473 |
|
| 8806 |
vikram.rag |
474 |
public static void createPayment(User user, String subOrderId, double amount) throws NumberFormatException, PaymentException, TException {
|
|
|
475 |
in.shop2020.payments.PaymentService.Client client = new PaymentClient().getClient();
|
|
|
476 |
long paymentId = client.createPayment(user.getUserId(), amount, SNAPDEAL_GATEWAY_ID, Long.valueOf(transactionId), false);
|
|
|
477 |
client.updatePaymentDetails(paymentId, null, null, null, null, null, null, subOrderId, null, PaymentStatus.AUTHORIZED, null, null);
|
| 8627 |
vikram.rag |
478 |
}
|
|
|
479 |
|
| 8616 |
vikram.rag |
480 |
public static LineItem createLineItem(long itemId, double amount) throws CatalogServiceException, TException {
|
| 8627 |
vikram.rag |
481 |
LineItem lineItem = new LineItem();
|
|
|
482 |
CatalogService.Client catalogClient = new CatalogClient().getClient();
|
|
|
483 |
Item item = catalogClient.getItem(itemId);
|
| 8773 |
vikram.rag |
484 |
if(item.getId()==0){
|
|
|
485 |
//in case item id is incorrect..
|
|
|
486 |
return null;
|
|
|
487 |
}
|
| 8616 |
vikram.rag |
488 |
|
| 8627 |
vikram.rag |
489 |
lineItem.setProductGroup(item.getProductGroup());
|
|
|
490 |
lineItem.setBrand(item.getBrand());
|
|
|
491 |
lineItem.setModel_number(item.getModelNumber());
|
|
|
492 |
lineItem.setModel_name(item.getModelName());
|
|
|
493 |
lineItem.setExtra_info(item.getFeatureDescription());
|
|
|
494 |
lineItem.setQuantity(1);
|
|
|
495 |
lineItem.setItem_id(item.getId());
|
|
|
496 |
lineItem.setUnit_weight(item.getWeight());
|
|
|
497 |
lineItem.setTotal_weight(item.getWeight());
|
|
|
498 |
lineItem.setUnit_price(amount);
|
|
|
499 |
lineItem.setTotal_price(amount);
|
|
|
500 |
|
| 8739 |
vikram.rag |
501 |
if (item.getColor() == null || "NA".equals(item.getColor())) {
|
| 8627 |
vikram.rag |
502 |
lineItem.setColor("");
|
|
|
503 |
} else {
|
|
|
504 |
lineItem.setColor(item.getColor());
|
|
|
505 |
}
|
|
|
506 |
return lineItem;
|
| 8616 |
vikram.rag |
507 |
}
|
|
|
508 |
|
|
|
509 |
}
|