| Line 700... |
Line 700... |
| 700 |
long available,reserve,defaultinventory,holdinventory,heldorders=0,sent_inventory = 0,totalheld,heldforsource,allocable;
|
700 |
long available,reserve,defaultinventory,holdinventory,heldorders=0,sent_inventory = 0,totalheld,heldforsource,allocable;
|
| 701 |
SnapdealItemForInventory inventoryItem;
|
701 |
SnapdealItemForInventory inventoryItem;
|
| 702 |
StringBuffer outOfStockItems =new StringBuffer();
|
702 |
StringBuffer outOfStockItems =new StringBuffer();
|
| 703 |
StringBuffer backInStockItems =new StringBuffer();
|
703 |
StringBuffer backInStockItems =new StringBuffer();
|
| 704 |
StringBuffer inventoryChangeItems =new StringBuffer();
|
704 |
StringBuffer inventoryChangeItems =new StringBuffer();
|
| - |
|
705 |
StringBuffer heldMoreThanAvailable =new StringBuffer();
|
| 705 |
long sku = 0;
|
706 |
long sku = 0;
|
| 706 |
SnapdealItemDetails snapdealitem;
|
707 |
SnapdealItemDetails snapdealitem;
|
| 707 |
for(Inventory inventory:currentInventoryItemList){
|
708 |
for(Inventory inventory:currentInventoryItemList){
|
| 708 |
//System.out.println(inventory.getSupc()+" "+inventory.getSellerSku()+ " " +inventory.getProductName()+" "+inventory.getAvailableInventory()+" "+inventory.isLive()+" "+itemIdpendingOrdersMap.get(Long.parseLong(inventory.getSellerSku())));
|
709 |
//System.out.println(inventory.getSupc()+" "+inventory.getSellerSku()+ " " +inventory.getProductName()+" "+inventory.getAvailableInventory()+" "+inventory.isLive()+" "+itemIdpendingOrdersMap.get(Long.parseLong(inventory.getSellerSku())));
|
| 709 |
if(snapdealItemMap.containsKey(inventory.getSellerSku())){
|
710 |
if(snapdealItemMap.containsKey(inventory.getSellerSku())){
|
| Line 737... |
Line 738... |
| 737 |
row = sheet.getRow((short) iterator);
|
738 |
row = sheet.getRow((short) iterator);
|
| 738 |
if(!inventoryItem.getStatus().equals(status.PAUSED)){
|
739 |
if(!inventoryItem.getStatus().equals(status.PAUSED)){
|
| 739 |
if(inventoryItem.getRisky()){
|
740 |
if(inventoryItem.getRisky()){
|
| 740 |
if((available - reserve) < totalheld){
|
741 |
if((available - reserve) < totalheld){
|
| 741 |
sent_inventory = (long) Math.floor(((available - reserve)*heldforsource/totalheld));
|
742 |
sent_inventory = (long) Math.floor(((available - reserve)*heldforsource/totalheld));
|
| - |
|
743 |
heldMoreThanAvailable.append("<tr>"
|
| - |
|
744 |
+ "<td>" + inventory.getProductName() +"</td>"
|
| - |
|
745 |
+"<td>" + sku + "</td>"
|
| - |
|
746 |
+"<td>" + inventory.getAvailableInventory() + "</td>"
|
| - |
|
747 |
+"<td>" + sent_inventory + "</td>"
|
| - |
|
748 |
+"</tr>");
|
| 742 |
}
|
749 |
}
|
| 743 |
else{
|
750 |
else{
|
| 744 |
allocable = available - reserve - totalheld - holdinventory;
|
751 |
allocable = available - reserve - totalheld - holdinventory;
|
| 745 |
if(allocable < 0){
|
752 |
if(allocable < 0){
|
| 746 |
allocable = 0;
|
753 |
allocable = 0;
|
| Line 935... |
Line 942... |
| 935 |
mailer.sendSSLMessage(sendTo,"Inventory File",feedresponse, emailFromAddress, password, files);
|
942 |
mailer.sendSSLMessage(sendTo,"Inventory File",feedresponse, emailFromAddress, password, files);
|
| 936 |
} catch (MessagingException e) {
|
943 |
} catch (MessagingException e) {
|
| 937 |
e.printStackTrace();
|
944 |
e.printStackTrace();
|
| 938 |
}
|
945 |
}
|
| 939 |
*/
|
946 |
*/
|
| - |
|
947 |
emailSubjectTxt = "Snapdeal Inventory Updates sent for " +(iterator-1)+" items "+ sdf.format(System.currentTimeMillis());
|
| 940 |
if(inventoryChangeItems.length() > 0){
|
948 |
if(inventoryChangeItems.length() > 0){
|
| 941 |
text = "<html><table border=\"1\" align=\"center\">"+tableHeader+inventoryChangeItems.toString()+"</table></html>";
|
949 |
text = "<html><table border=\"1\" align=\"center\">"+tableHeader+inventoryChangeItems.toString()+"</table></html>";
|
| 942 |
try {
|
950 |
try {
|
| 943 |
mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
|
951 |
mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
|
| - |
|
952 |
} catch (MessagingException e) {
|
| - |
|
953 |
e.printStackTrace();
|
| - |
|
954 |
}
|
| - |
|
955 |
}
|
| - |
|
956 |
emailSubjectTxt = "Held Inventory is more than available "+ sdf.format(System.currentTimeMillis());
|
| - |
|
957 |
if(heldMoreThanAvailable.length() > 0){
|
| - |
|
958 |
text = "<html><table border=\"1\" align=\"center\">"+tableHeader+heldMoreThanAvailable.toString()+"</table></html>";
|
| - |
|
959 |
try {
|
| - |
|
960 |
mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
|
| 944 |
//mailer.sendSSLMessage(sendTo,"Snapdeal Inventory Updates sent for " +(iterator-1)+" items "+ sdf.format(System.currentTimeMillis()),inventoryChangeItems.toString(), emailFromAddress, password, new ArrayList<File>());
|
961 |
//mailer.sendSSLMessage(sendTo,"Snapdeal Inventory Updates sent for " +(iterator-1)+" items "+ sdf.format(System.currentTimeMillis()),inventoryChangeItems.toString(), emailFromAddress, password, new ArrayList<File>());
|
| 945 |
} catch (MessagingException e) {
|
962 |
} catch (MessagingException e) {
|
| 946 |
e.printStackTrace();
|
963 |
e.printStackTrace();
|
| 947 |
}
|
964 |
}
|
| 948 |
}
|
965 |
}
|