Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
7283 kshitij.so 1
package in.shop2020.support.controllers;
2
 
7524 kshitij.so 3
import java.io.File;
7741 kshitij.so 4
import java.io.FileInputStream;
7524 kshitij.so 5
import java.io.IOException;
7365 kshitij.so 6
import java.util.HashMap;
7283 kshitij.so 7
import java.util.List;
8
import java.util.Map;
9
 
7591 kshitij.so 10
import javax.servlet.ServletContext;
7283 kshitij.so 11
import javax.servlet.ServletRequest;
12
import javax.servlet.http.HttpServletRequest;
7591 kshitij.so 13
import javax.servlet.http.HttpSession;
7283 kshitij.so 14
 
15
import in.shop2020.model.v1.catalog.Amazonlisted;
16
import in.shop2020.model.v1.catalog.CatalogServiceException;
17
import in.shop2020.model.v1.catalog.Item;
18
import in.shop2020.model.v1.inventory.AmazonInventorySnapshot;
19
import in.shop2020.model.v1.catalog.CatalogService.Client;
20
import in.shop2020.model.v1.inventory.InventoryServiceException;
7741 kshitij.so 21
import in.shop2020.model.v1.order.AmazonOrder;
7591 kshitij.so 22
import in.shop2020.support.utils.ReportsUtils;
7283 kshitij.so 23
import in.shop2020.thrift.clients.CatalogClient;
24
import in.shop2020.thrift.clients.InventoryClient;
7365 kshitij.so 25
import in.shop2020.thrift.clients.LogisticsClient;
7741 kshitij.so 26
import in.shop2020.thrift.clients.TransactionClient;
7365 kshitij.so 27
import in.shop2020.logistics.DeliveryType;
28
import in.shop2020.logistics.LogisticsInfo;
29
import in.shop2020.logistics.LogisticsServiceException;
30
import in.shop2020.logistics.PickUpType;
7283 kshitij.so 31
 
7524 kshitij.so 32
import org.apache.commons.io.FileUtils;
7365 kshitij.so 33
import org.apache.commons.lang.xwork.StringUtils;
7741 kshitij.so 34
import org.apache.poi.hssf.usermodel.HSSFSheet;
35
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
7591 kshitij.so 36
import org.apache.struts2.convention.annotation.InterceptorRef;
37
import org.apache.struts2.convention.annotation.InterceptorRefs;
7283 kshitij.so 38
import org.apache.struts2.convention.annotation.Result;
39
import org.apache.struts2.convention.annotation.Results;
40
import org.apache.struts2.interceptor.ServletRequestAware;
41
import org.apache.thrift.TException;
7741 kshitij.so 42
import org.apache.thrift.transport.TTransportException;
7283 kshitij.so 43
import org.slf4j.Logger;
44
import org.slf4j.LoggerFactory;
45
 
46
import com.opensymphony.xwork2.ValidationAwareSupport;
47
 
48
@SuppressWarnings("serial")
7591 kshitij.so 49
@InterceptorRefs({
50
	@InterceptorRef("defaultStack"),
51
	@InterceptorRef("login")
52
})
7283 kshitij.so 53
@Results({
7524 kshitij.so 54
	@Result(name = "redirect", location = "${url}", type = "redirect"),
55
	@Result(name="authsuccess", type="redirectAction", params = {"actionName" , "reports"})
56
})
57
public class AmazonListController extends ValidationAwareSupport implements ServletRequestAware {
7283 kshitij.so 58
 
59
	private static Logger logger = LoggerFactory.getLogger(AmazonListController.class);
60
 
7591 kshitij.so 61
	private HttpServletRequest request;
62
	private HttpSession session;
63
	private ServletContext context;
7283 kshitij.so 64
	private String url;
65
	private String id;
66
	private String itemId;
67
	private String isFba;
68
	private String isNonFba;
69
	private String isInventoryOverride;
70
	private String fbaPrice;
71
	private String sellingPrice;
72
	private String saholicPrice;
7365 kshitij.so 73
	private String isTime;
74
	private String handlingTime;
75
	private String customHandlingTime;
7461 kshitij.so 76
	private String holdInventory;
77
	private String defaultInventory;
7524 kshitij.so 78
	private String fileUploadFileName;
79
	private String fileUploadContentType;
80
	private File file;
7283 kshitij.so 81
 
82
	public String index() {
7591 kshitij.so 83
		if(!ReportsUtils.canAccessReport((Long)session.getAttribute(ReportsUtils.ROLE), request.getServletPath())) {
84
			return "authfail";
85
		}
7283 kshitij.so 86
		return "index";
87
	}
88
 
89
	public List<Amazonlisted> fetchItems() throws TException {
7408 kshitij.so 90
		Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
7283 kshitij.so 91
		return CatalogClient.getAllAmazonListedItems();
92
	}
93
 
7408 kshitij.so 94
	public Amazonlisted fetchItemDetail() throws NumberFormatException, TException {
95
		Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
7283 kshitij.so 96
		return CatalogClient.getAmazonItemDetails(Long.valueOf(id));
97
	}
98
 
7408 kshitij.so 99
	public Item getSaholicItem(String id) throws NumberFormatException, CatalogServiceException, TException {
100
		Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
7283 kshitij.so 101
		return CatalogClient.getItem(Long.valueOf(id));
102
	}
7365 kshitij.so 103
 
104
 
105
 
7283 kshitij.so 106
	public String update() throws NumberFormatException, TException{
7408 kshitij.so 107
		Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
7283 kshitij.so 108
		if ( Double.valueOf(fbaPrice) > Double.valueOf(saholicPrice) || Double.valueOf(sellingPrice) > Double.valueOf(saholicPrice) ) {
7365 kshitij.so 109
			addActionError("Failed To Do Changes");
7283 kshitij.so 110
		}
111
		else {
7365 kshitij.so 112
			boolean flag=false;
7591 kshitij.so 113
			long delay = Long.valueOf(customHandlingTime);
7365 kshitij.so 114
			if ( Boolean.valueOf(isTime)) {
115
				flag = true;
116
			}
7461 kshitij.so 117
			changeItemInventory();
7365 kshitij.so 118
			CatalogClient.updateAmazonItemDetails(Long.valueOf(itemId),Double.valueOf(fbaPrice),Double.valueOf(sellingPrice),Boolean.valueOf(isFba),Boolean.valueOf(isNonFba),Boolean.valueOf(isInventoryOverride),delay,flag);
7283 kshitij.so 119
		}
7591 kshitij.so 120
		//setUrl("/amazon-list/");
121
		return "index";
7283 kshitij.so 122
 
123
	}
124
 
7741 kshitij.so 125
	public String upload() throws IOException, TException {
7524 kshitij.so 126
		File fileToCreate = new File("/tmp/", "Amazon-shipping.xls");
127
		FileUtils.copyFile(this.file, fileToCreate);
7741 kshitij.so 128
		FileInputStream iFile = new FileInputStream(new File(file.getAbsolutePath()));
129
		HSSFWorkbook workbook = new HSSFWorkbook(iFile);
130
		HSSFSheet sheet = workbook.getSheetAt(0);
131
		Map<Long,String> amazonOrderMap = new HashMap<Long,String>();
132
		for (int iterator=sheet.getFirstRowNum();iterator<=sheet.getLastRowNum();iterator++){
133
			TransactionClient tcl = new TransactionClient();
134
			List<AmazonOrder> orders = tcl.getClient().getAmazonOrderByAmazonOrderId(sheet.getRow(iterator).getCell(0).getStringCellValue());
135
			for (AmazonOrder order : orders){
136
				if (StringUtils.equals(order.getStatus(), "Acknowledgement-Sent")){
137
					amazonOrderMap.put(order.getOrderId(), sheet.getRow(iterator).getCell(1).getStringCellValue());
138
				}
139
			}
140
		}
141
		TransactionClient tcl = new TransactionClient();
142
		tcl.getClient().updateTimestampForAmazonOrder(amazonOrderMap);
7524 kshitij.so 143
		return "authsuccess";
144
	}
145
 
7461 kshitij.so 146
	private void changeItemInventory() throws NumberFormatException, TException {
147
		Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
7524 kshitij.so 148
 
7461 kshitij.so 149
		if (StringUtils.isEmpty(holdInventory)) {
150
			holdInventory = "0";
151
		}
152
		if (StringUtils.isEmpty(defaultInventory)) {
153
			defaultInventory = "0";
154
		}
7524 kshitij.so 155
 
7461 kshitij.so 156
		CatalogClient.updateItemInventory(Long.valueOf(itemId),Long.valueOf(holdInventory),Long.valueOf(defaultInventory));
157
	}
158
 
159
 
7283 kshitij.so 160
	public Map<Long, Long> getAvailableItemInventory(String itemId) throws NumberFormatException, InventoryServiceException, TException{
161
		InventoryClient inventoryServiceClient = new InventoryClient();
162
		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
163
		in.shop2020.model.v1.inventory.ItemInventory thriftItemInventory = inventoryClient.getItemInventoryByItemId(Long.valueOf(itemId));
164
		return thriftItemInventory.getAvailability();
165
 
166
	}
167
 
168
	public Map<Long, Long> getReservedItemInventory(String itemId) throws NumberFormatException, InventoryServiceException, TException{
169
		InventoryClient inventoryServiceClient = new InventoryClient();
170
		in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
171
		in.shop2020.model.v1.inventory.ItemInventory thriftItemInventory = inventoryClient.getItemInventoryByItemId(Long.valueOf(itemId));
172
		return thriftItemInventory.getReserved();
173
 
174
	}
175
 
176
	public String getWarehouseName(String warehouseId) throws NumberFormatException, TException { 
177
		InventoryClient inventoryServiceClient = new InventoryClient();
178
		return inventoryServiceClient.getClient().getWarehouseName(Long.valueOf(warehouseId));
179
	}
180
 
181
	public AmazonInventorySnapshot getInventoryForAmazonItem(String itemId) throws NumberFormatException, TException {
182
		InventoryClient inventoryServiceClient = new InventoryClient();
7365 kshitij.so 183
		try { 
184
			return inventoryServiceClient.getClient().getAmazonInventoryForItem(Long.valueOf(itemId));
185
		}
186
		catch (Exception e){
187
			return null;
188
		}
7283 kshitij.so 189
	}
190
 
7365 kshitij.so 191
	public Long getTimetoShip(String itemId) throws LogisticsServiceException, TException{
192
		LogisticsClient logisticsClient = new LogisticsClient();
193
		return logisticsClient.getClient().getLogisticsInfo("110001", Long.valueOf(itemId), DeliveryType.COD, PickUpType.COURIER).getShippingTime();
194
 
195
	}
196
 
7603 kshitij.so 197
	public  Map<Long, Item> getAliveItemMap() throws TException{
7408 kshitij.so 198
		Client CatalogClient = new CatalogClient("catalog_service_server_host_amazon","catalog_service_server_port").getClient();
7365 kshitij.so 199
		List<Item> itemList = CatalogClient.getAllAliveItems();
7603 kshitij.so 200
		Map<Long, Item> itemMap = new HashMap<Long, Item>();
7365 kshitij.so 201
		for (Item o : itemList) {
7603 kshitij.so 202
			itemMap.put((Long) o.getId(), o);
7365 kshitij.so 203
		}
204
		return itemMap;
205
	}
206
 
7283 kshitij.so 207
	public String edit() {
7591 kshitij.so 208
		if(!ReportsUtils.canAccessReport((Long)session.getAttribute(ReportsUtils.ROLE), request.getRequestURI().substring(request.getContextPath().length()).split("/")[1])) {
209
			return "authfail";
210
		}
7283 kshitij.so 211
		return "edit";
212
	}
213
 
214
	public String show() {
215
		return "show";
216
	}
217
 
218
	public String editNew() {
219
		return "editNew";
220
	}
221
 
222
	public void setId(String id) {
223
		this.id = id;
224
	}
225
 
226
	public void setUrl(String url) {
227
		this.url = url;
228
	}
229
 
230
	public String getUrl() {
231
		return url;
232
	}
233
 
234
	public String getId() {
235
		return id;
236
	}
237
 
238
	public void setItemId(String itemId) {
239
		this.itemId = itemId;
240
	}
241
 
242
	public String getItemId() {
243
		return itemId;
244
	}
245
 
246
	public void setIsFba(String isFba) {
247
		this.isFba = isFba;
248
	}
249
 
250
	public String getIsFba() {
251
		return isFba;
252
	}
253
 
254
	public void setIsNonFba(String isNonFba) {
255
		this.isNonFba = isNonFba;
256
	}
257
 
258
	public String getIsNonFba() {
259
		return isNonFba;
260
	}
261
 
262
	public void setIsInventoryOverride(String isInventoryOverride) {
263
		this.isInventoryOverride = isInventoryOverride;
264
	}
265
 
266
	public String getIsInventoryOverride() {
267
		return isInventoryOverride;
268
	}
269
 
270
	public void setSellingPrice(String sellingPrice) {
271
		this.sellingPrice = sellingPrice;
272
	}
273
 
274
	public String getSellingPrice() {
275
		return sellingPrice;
276
	}
277
 
278
	public void setFbaPrice(String fbaPrice) {
279
		this.fbaPrice = fbaPrice;
280
	}
281
 
282
	public String getFbaPrice() {
283
		return fbaPrice;
284
	}
7365 kshitij.so 285
 
7283 kshitij.so 286
	public void setSaholicPrice(String saholicPrice) {
287
		this.saholicPrice = saholicPrice;
288
	}
289
 
290
	public String getSaholicPrice() {
291
		return saholicPrice;
292
	}
293
 
7365 kshitij.so 294
	public void setIsTime(String isTime){
295
		this.isTime = isTime;
296
	}
297
 
7461 kshitij.so 298
	public String getIsTime(){
7365 kshitij.so 299
		return isTime;
300
	}
301
 
302
	public void setHandlingTime(String handlingTime){
303
		this.handlingTime = handlingTime;
304
	}
305
 
7461 kshitij.so 306
	public String getHandlingTime(){
7365 kshitij.so 307
		return handlingTime;
308
	}
309
 
310
	public void setCustomHandlingTime(String customHandlingTime){
311
		this.customHandlingTime = customHandlingTime;
312
	}
313
 
7461 kshitij.so 314
	public String getCustomHandlingTime(){
7365 kshitij.so 315
		return customHandlingTime;
316
	}
7524 kshitij.so 317
 
7461 kshitij.so 318
	public void setHoldInventory(String holdInventory){
319
		this.holdInventory = holdInventory;
320
	}
7365 kshitij.so 321
 
7461 kshitij.so 322
	public String getHoldInventory(){
323
		return holdInventory;
324
	}
7524 kshitij.so 325
 
7461 kshitij.so 326
	public void setDefaultInventory(String defaultInventory){
327
		this.defaultInventory = defaultInventory;
328
	}
329
 
330
	public String getDefaultInventory(){
331
		return defaultInventory;
332
	}
333
 
7524 kshitij.so 334
	public File getFile() {
335
		return file;
336
	}
337
 
338
	public void setFile(File file) {
339
		this.file = file;
340
	}
341
 
342
	public String getFileUploadContentType() {
343
		return fileUploadContentType;
344
	}
345
 
346
	public void setFileUploadContentType(String fileUploadContentType) {
347
		this.fileUploadContentType = fileUploadContentType;
348
	}
349
 
350
	public String getFileUploadFileName() {
351
		return fileUploadFileName;
352
	}
353
 
354
	public void setFileUploadFileName(String fileUploadFileName) {
355
		this.fileUploadFileName = fileUploadFileName;
356
	}
357
 
7591 kshitij.so 358
	public void setServletRequest(HttpServletRequest req) {
359
		this.request = req;
360
		this.session = req.getSession();        
7283 kshitij.so 361
	}
362
 
363
	public static void main(String[] args) throws NumberFormatException, InventoryServiceException, TException {
364
		AmazonListController call = new AmazonListController();
7365 kshitij.so 365
		System.out.println(call.getInventoryForAmazonItem("5"));
7283 kshitij.so 366
	}
367
}