Subversion Repositories SmartDukaan

Rev

Rev 10422 | Rev 10498 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 10422 Rev 10450
Line 763... Line 763...
763
						+ defaultinventory + "\theldorders " + heldorders);
763
						+ defaultinventory + "\theldorders " + heldorders);
764
				if(!PANEL){
764
				if(!PANEL){
765
					row =   sheet.getRow((short) iterator);
765
					row =   sheet.getRow((short) iterator);
766
				}
766
				}
767
				if(!inventoryItem.getStatus().equals(status.PAUSED)){
767
				if(!inventoryItem.getStatus().equals(status.PAUSED)){
-
 
768
					System.out.println("Not Paused");
768
					if(inventoryItem.getRisky()){
769
					if(inventoryItem.getRisky()){
769
						if((available - reserve) < totalheld && totalheld!=0){
770
						if((available - reserve) < totalheld && totalheld!=0){
770
							sent_inventory = (long) Math.floor(((available - reserve)*heldforsource/totalheld)) - heldorders;
771
							sent_inventory = (long) Math.floor(((available - reserve)*heldforsource/totalheld)) - heldorders;
771
							heldMoreThanAvailable.append("<tr>" 
772
							heldMoreThanAvailable.append("<tr>" 
772
									+ "<td>" + inventory.getProductName() +"</td>"
773
									+ "<td>" + inventory.getProductName() +"</td>"
Line 810... Line 811...
810
				}
811
				}
811
				else{
812
				else{
812
					sent_inventory = 0;
813
					sent_inventory = 0;
813
				}
814
				}
814
				SnapdealInventoryItem snapdealInventoryItem;
815
				SnapdealInventoryItem snapdealInventoryItem;
-
 
816
				System.out.println("Before incremental check");
-
 
817
				System.out.println("Before incremental available "+inventory.getAvailableInventory());
-
 
818
				System.out.println("To send "+sent_inventory);
815
				if(inventory.getAvailableInventory()!= sent_inventory){
819
				if(inventory.getAvailableInventory()!= sent_inventory){
-
 
820
					System.out.println("Incremental check success");
816
					if(!PANEL){
821
					if(!PANEL){
817
						row.getCell((short) 0).setCellValue(inventory.getSupc());
822
						row.getCell((short) 0).setCellValue(inventory.getSupc());
818
						row.getCell((short) 1).setCellValue(inventory.getSellerSku());
823
						row.getCell((short) 1).setCellValue(inventory.getSellerSku());
819
						row.getCell((short) 2).setCellValue(inventory.getProductName());
824
						row.getCell((short) 2).setCellValue(inventory.getProductName());
820
						row.getCell((short) 3).setCellValue(inventory.getAvailableInventory());
825
						row.getCell((short) 3).setCellValue(inventory.getAvailableInventory());
Line 825... Line 830...
825
						else{
830
						else{
826
							row.getCell((short) 5).setCellValue("No");
831
							row.getCell((short) 5).setCellValue("No");
827
						}
832
						}
828
					}
833
					}
829
					else{
834
					else{
-
 
835
						System.out.println("Incremental check success");
830
						snapdealInventoryItem = new SnapdealInventoryItem();
836
						snapdealInventoryItem = new SnapdealInventoryItem();
831
						PendingOrderInventoryHistory pendingOrderInventoryHistory = PendingOrdersInventoryHistoryMap.get(inventory.getSellerSku());
837
						PendingOrderInventoryHistory pendingOrderInventoryHistory = PendingOrdersInventoryHistoryMap.get(inventory.getSellerSku());
832
						if(snapdealItemMap.containsKey(inventory.getSellerSku())){
838
						if(snapdealItemMap.containsKey(inventory.getSellerSku())){
-
 
839
							System.out.println("Found in snapdeal items map)");
833
							System.out.println("++++++++++++++++++++++++++++++++++++++++");
840
							System.out.println("++++++++++++++++++++++++++++++++++++++++");
834
							System.out.println("Updating snapdeal inventory snapshot");
841
							System.out.println("Updating snapdeal inventory snapshot Item ID :"+snapdealItemMap.get(inventory.getSellerSku()).getItem_id());
835
							System.out.println("++++++++++++++++++++++++++++++++++++++++");
842
							System.out.println("++++++++++++++++++++++++++++++++++++++++");
836
							snapdealInventoryItem.setItem_id(snapdealItemMap.get(inventory.getSellerSku()).getItem_id());
843
							snapdealInventoryItem.setItem_id(snapdealItemMap.get(inventory.getSellerSku()).getItem_id());
837
							snapdealInventoryItem.setPendingOrders(pendingOrderInventoryHistory.getPendingOrders());
844
							snapdealInventoryItem.setPendingOrders(pendingOrderInventoryHistory.getPendingOrders());
838
							snapdealInventoryItem.setAvailability(sent_inventory);
845
							snapdealInventoryItem.setAvailability(sent_inventory);
839
							snapdealInventoryItem.setLastUpdatedOnSnapdeal(lastSentInventoryTime);
846
							snapdealInventoryItem.setLastUpdatedOnSnapdeal(lastSentInventoryTime);
-
 
847
							if(sent_inventory > 0){
-
 
848
								snapdealInventoryItem.setIs_oos(false);
-
 
849
							}
-
 
850
							else{
-
 
851
								snapdealInventoryItem.setIs_oos(true);
-
 
852
							}
840
							snapdealInventoryItemList.add(snapdealInventoryItem);
853
							snapdealInventoryItemList.add(snapdealInventoryItem);
841
						}
854
						}
842
						UpdateSDIUsingPanel UDSI = new UpdateSDIUsingPanel();
855
						UpdateSDIUsingPanel UDSI = new UpdateSDIUsingPanel();
843
						try {
856
						try {
844
							UDSI.handleLogin();
857
							UDSI.handleLogin();
Line 988... Line 1001...
988
						transactionClient.updateSourceDetailTimestamp(7, lastSentInventoryTime);
1001
						transactionClient.updateSourceDetailTimestamp(7, lastSentInventoryTime);
989
					} catch (Exception ex) {
1002
					} catch (Exception ex) {
990
						ex.printStackTrace();
1003
						ex.printStackTrace();
991
					}
1004
					}
992
				}
1005
				}
993
				InventoryClient inventoryServiceClient = null;
-
 
994
				try {
-
 
995
					inventoryServiceClient = new InventoryClient();
-
 
996
				} catch (TTransportException e1) {
-
 
997
					e1.printStackTrace();
-
 
998
				}
-
 
999
				if(snapdealInventoryItemList.size() > 0){
1006
				if(snapdealInventoryItemList.size() > 0){
1000
					in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = inventoryServiceClient.getClient();
1007
					in.shop2020.model.v1.inventory.InventoryService.Client inventoryClient = null;
1001
					try {
1008
					try {
1002
						System.out.println("Before updating to database");
1009
						System.out.println("Before updating to database");
1003
						for(SnapdealInventoryItem item:snapdealInventoryItemList){
1010
						for(SnapdealInventoryItem item:snapdealInventoryItemList){
1004
							System.out.println("Item ID " + item.getItem_id()); 
1011
							System.out.println("Item ID " + item.getItem_id()); 
1005
							System.out.println("Availability " + item.getAvailability());
1012
							System.out.println("Availability " + item.getAvailability());
1006
							System.out.println("Updated time " + sdf.format(item.getLastUpdatedOnSnapdeal()));
1013
							System.out.println("Updated time " + sdf.format(item.getLastUpdatedOnSnapdeal()));
1007
							System.out.println("Pending Orders " + item.getPendingOrders());
1014
							System.out.println("Pending Orders " + item.getPendingOrders());
1008
						}
1015
						}
1009
						System.out.println("Snapdeal inventory list size" + snapdealInventoryItemList.size());
1016
						System.out.println("Snapdeal inventory list size" + snapdealInventoryItemList.size());
-
 
1017
						inventoryClient = new InventoryClient().getClient();
1010
						inventoryClient.addOrUpdateAllSnapdealInventory(snapdealInventoryItemList);
1018
						inventoryClient.addOrUpdateAllSnapdealInventory(snapdealInventoryItemList);
1011
					} catch (TException e) {
1019
					} catch (TException e) {
1012
						e.printStackTrace();
1020
						e.printStackTrace();
-
 
1021
						try {
1013
						inventoryClient = inventoryServiceClient.getClient();
1022
							inventoryClient = new InventoryClient().getClient();
-
 
1023
						} catch (TTransportException e2) {
-
 
1024
							e2.printStackTrace();
-
 
1025
						}
1014
						try {
1026
						try {
1015
							inventoryClient.addOrUpdateAllSnapdealInventory(snapdealInventoryItemList);
1027
							inventoryClient.addOrUpdateAllSnapdealInventory(snapdealInventoryItemList);
1016
						} catch (TException e1) {
1028
						} catch (TException e1) {
1017
							e1.printStackTrace();
1029
							e1.printStackTrace();
1018
						}
1030
						}