WebSVN – SmartDukaan – Diff – /trunk/SnapDealFeeds/src/main/java/in/shop2020/UpdateSnapdealInventoryUsingPanel.java

 	@SuppressWarnings("deprecation")
-	public static void main(String[] args) throws NumberFormatException, TException, ClientProtocolException, IOException, MessagingException {
+	public static void main(String[] args) throws NumberFormatException, TException,MessagingException {
+		try {
-		handleLogin();
+			handleLogin();
+		} catch (ClientProtocolException e2) {
+			System.out.println("Handle login failed");
+			e2.printStackTrace();
+		} catch (IOException e2) {
+			System.out.println("Handle login failed");
+			e2.printStackTrace();
+		}
+		try {
-		fetchinventoryhistoryfromsnapdeal();
+			fetchinventoryhistoryfromsnapdeal();
+		} catch (UnsupportedEncodingException e2) {
+			System.out.println("History Inventory Fetch failed");
+			e2.printStackTrace();
+		}
+		try {
-		fetchcurrentinventoryfromsnapdeal();
+			fetchcurrentinventoryfromsnapdeal();
+		} catch (UnsupportedEncodingException e2) {
+			System.out.println("Current Inventory Fetch failed");
+			e2.printStackTrace();
+		}
 		calculateinventory();
 		in.shop2020.model.v1.catalog.CatalogService.Client catalogServiceClient = null;
 		try {
 			catalogServiceClient = new CatalogClient().getClient();
 		} catch (TTransportException e) {
+		}
 		FileInputStream fis = null;
 		Workbook hwb = null;
 		Sheet sheet = null;
 		if(!PANEL){
+			try {
-			fis = new FileInputStream("/root/code/trunk/SnapDealFeeds/SellerInventory.xls");
+				fis = new FileInputStream("/root/code/trunk/SnapDealFeeds/SellerInventory.xls");
+			} catch (FileNotFoundException e) {
+				System.out.println("Template File not found");
+				e.printStackTrace();
+			}
+			try {
-			hwb = new HSSFWorkbook(fis);
+				hwb = new HSSFWorkbook(fis);
+			} catch (IOException e) {
+				System.out.println("Could not created workbook I/O Problem");
+				e.printStackTrace();
+			}
 			sheet = hwb.getSheetAt(0);
+		}
 		Row row = null;
 		int iterator=1;
 		long available,reserve,defaultinventory,holdinventory,heldorders=0,sent_inventory = 0,totalheld,heldforsource,allocable;
 						row.getCell((short) 0).setCellValue(inventory.getSupc());
 						row.getCell((short) 1).setCellValue(inventory.getSellerSku());
 						row.getCell((short) 2).setCellValue(inventory.getProductName());
 						row.getCell((short) 3).setCellValue(inventory.getAvailableInventory());
 						row.getCell((short) 4).setCellValue(sent_inventory);
-						if(inventory.getAvailableInventory()!=0 && sent_inventory==0){
-							outOfStockItems.append("<tr>"
-									+ "<td>" + inventory.getProductName() +"</td>"
-									+"<td>" + sku + "</td>"
-									+"<td>" + inventory.getAvailableInventory() + "</td>"
-									+"<td>" + sent_inventory + "</td>"
-									+"</tr>");
-						}
-						else if(inventory.getAvailableInventory()==0 && sent_inventory!=0){
-							backInStockItems.append("<tr>"
-									+ "<td>" + inventory.getProductName() +"</td>"
-									+"<td>" + sku + "</td>"
-									+"<td>" + inventory.getAvailableInventory() + "</td>"
-									+"<td>" + sent_inventory + "</td>"
-									+"</tr>");
-						}
-						else{
-							inventoryChangeItems.append("<tr>"
-									+ "<td>" + inventory.getProductName() +"</td>"
-									+"<td>" + sku + "</td>"
-									+"<td>" + inventory.getAvailableInventory() + "</td>"
-									+"<td>" + sent_inventory + "</td>"
-									+"</tr>");
-						}
 						if(inventory.isLive()){
 							row.getCell((short) 5).setCellValue("Yes");
+						}
 						else{
 							row.getCell((short) 5).setCellValue("No");
+						}
+					}
 					else{
 						UpdateSDIUsingPanel UDSI = new UpdateSDIUsingPanel();
-						UDSI.handleLogin();
+						try {
-						UDSI.updateInventory(sent_inventory,inventory.getSupc());
+							UDSI.updateInventory(sent_inventory,inventory.getSupc());
+						} catch (ClientProtocolException e) {
+							System.out.println("Could not login and update inventory");
+							e.printStackTrace();
+						} catch (IOException e) {
+							System.out.println("Could not login and update inventory I/O");
+							e.printStackTrace();
+						}
+					}
+					if(inventory.getAvailableInventory()!=0 && sent_inventory==0){
+						outOfStockItems.append("<tr>"
+								+ "<td>" + inventory.getProductName() +"</td>"
+								+"<td>" + sku + "</td>"
+								+"<td>" + inventory.getAvailableInventory() + "</td>"
+								+"<td>" + sent_inventory + "</td>"
+								+"</tr>");
+					}
+					else if(inventory.getAvailableInventory()==0 && sent_inventory!=0){
+						backInStockItems.append("<tr>"
+								+ "<td>" + inventory.getProductName() +"</td>"
+								+"<td>" + sku + "</td>"
+								+"<td>" + inventory.getAvailableInventory() + "</td>"
+								+"<td>" + sent_inventory + "</td>"
+								+"</tr>");
+					}
+					else{
+						inventoryChangeItems.append("<tr>"
+								+ "<td>" + inventory.getProductName() +"</td>"
+								+"<td>" + sku + "</td>"
+								+"<td>" + inventory.getAvailableInventory() + "</td>"
+								+"<td>" + sent_inventory + "</td>"
+								+"</tr>");
+					}
 					iterator++;
+				}
+			}
 			else{
+			}
+		}
 		if(iterator > 1){
 			FileOutputStream fileOut = null;
 			if(!PANEL){
+				try {
-				fis.close();
+					fis.close();
+				} catch (IOException e2) {
+					e2.printStackTrace();
+				}
 				try {
 					System.out.println("Before writing file ");
 					fileOut = new FileOutputStream(SNAPDEAL_INVENTORY_SHEET);
 				} catch (FileNotFoundException e) {
 				MultipartEntity mpEntity = new MultipartEntity();
 				ContentBody cbFile = new FileBody(file,"application/vnd.ms-excel");
 				mpEntity.addPart("file", cbFile);
 				post.setEntity(mpEntity);
 				System.out.println("Before posting file");
+				HttpResponse response;
+				try {
-				HttpResponse response = client.execute(post);
+					response = client.execute(post);
+				} catch (ClientProtocolException e2) {
+					System.out.println("Error While Posting Inventory File");
+					e2.printStackTrace();
+				} catch (IOException e2) {
+					System.out.println("I/O Error While Posting Inventory File");
+					e2.printStackTrace();
+				}
 				BufferedReader rd = null;
 				try {
 					rd = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));
 				} catch (IllegalStateException e1) {
 					transactionClient.updateSourceDetailTimestamp(7, lastSentInventoryTime);
 				} catch (Exception ex) {
 					ex.printStackTrace();
+				}
+			}
+			String PANEL_TEXT_MAIL = "";
+			if(PANEL){
+				PANEL_TEXT_MAIL = " (Using Panel)";
+			}
-			String emailSubjectTxt = "Products back in stock on Snapdeal "+sdf.format(lastSentInventoryTime);
+			String emailSubjectTxt = "Products back in stock on Snapdeal "+sdf.format(lastSentInventoryTime) + PANEL_TEXT_MAIL;
 			String text;
 			String tableHeader = "<tr>"
 				+ "<td>" + "Product Name" +"</td>"
 				+"<td>" + "Item ID" + "</td>"
 				+"<td>" + "Old Inventory" + "</td>"
 					//mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
 				} catch (MessagingException e) {
 					e.printStackTrace();
+				}
+			}
-			emailSubjectTxt = "Products out of stock on Snapdeal "+sdf.format(lastSentInventoryTime);
+			emailSubjectTxt = "Products out of stock on Snapdeal "+sdf.format(lastSentInventoryTime) + PANEL_TEXT_MAIL;
 			if(outOfStockItems.length() > 0){
 				text = "<html><table border=\"1\" align=\"center\">"+tableHeader+outOfStockItems.toString()+"</table></html>";
 				try {
 					mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
 					//mailer.sendSSLMessage(sendTo, emailSubjectTxt, text, emailFromAddress, password, new ArrayList<File>());
 				} catch (MessagingException e) {
 					e.printStackTrace();
+				}
+			}
-			/*			List<File> files = new ArrayList<File>();
-			files.add(new File(SNAPDEAL_INVENTORY_SHEET));
-			try {
-				mailer.sendSSLMessage(sendTo,"Inventory File",feedresponse, emailFromAddress, password, files);
-			} catch (MessagingException e) {
-				e.printStackTrace();
-			}
-			 */
-			emailSubjectTxt = "Snapdeal Inventory Updates sent for " +(iterator-1)+" items "+ sdf.format(System.currentTimeMillis());
+			emailSubjectTxt = "Snapdeal Inventory Updates sent for " +(iterator-1)+" items "+ sdf.format(System.currentTimeMillis())+PANEL_TEXT_MAIL;
 			if(inventoryChangeItems.length() > 0){
 				text = "<html><table border=\"1\" align=\"center\">"+tableHeader+inventoryChangeItems.toString()+"</table></html>";
 				try {
 					mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
 				} catch (MessagingException e) {

Subversion Repositories SmartDukaan

(root)/trunk/SnapDealFeeds/src/main/java/in/shop2020/UpdateSnapdealInventoryUsingPanel.java – Rev 10162 → 10164