| Line 741... |
Line 741... |
| 741 |
if((available - reserve) < totalheld){
|
741 |
if((available - reserve) < totalheld){
|
| 742 |
sent_inventory = (long) Math.floor(((available - reserve)*heldforsource/totalheld));
|
742 |
sent_inventory = (long) Math.floor(((available - reserve)*heldforsource/totalheld));
|
| 743 |
heldMoreThanAvailable.append("<tr>"
|
743 |
heldMoreThanAvailable.append("<tr>"
|
| 744 |
+ "<td>" + inventory.getProductName() +"</td>"
|
744 |
+ "<td>" + inventory.getProductName() +"</td>"
|
| 745 |
+"<td>" + sku + "</td>"
|
745 |
+"<td>" + sku + "</td>"
|
| 746 |
+"<td>" + inventory.getAvailableInventory() + "</td>"
|
746 |
+"<td>" + (available - reserve) + "</td>"
|
| 747 |
+"<td>" + sent_inventory + "</td>"
|
747 |
+"<td>" + totalheld + "</td>"
|
| 748 |
+"</tr>");
|
748 |
+"</tr>");
|
| 749 |
}
|
749 |
}
|
| 750 |
else{
|
750 |
else{
|
| 751 |
allocable = available - reserve - totalheld - holdinventory;
|
751 |
allocable = available - reserve - totalheld - holdinventory;
|
| 752 |
if(allocable < 0){
|
752 |
if(allocable < 0){
|
| Line 951... |
Line 951... |
| 951 |
mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
|
951 |
mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
|
| 952 |
} catch (MessagingException e) {
|
952 |
} catch (MessagingException e) {
|
| 953 |
e.printStackTrace();
|
953 |
e.printStackTrace();
|
| 954 |
}
|
954 |
}
|
| 955 |
}
|
955 |
}
|
| - |
|
956 |
|
| - |
|
957 |
tableHeader = "<tr>"
|
| - |
|
958 |
+ "<td>" + "Product Name" +"</td>"
|
| - |
|
959 |
+"<td>" + "Item ID" + "</td>"
|
| - |
|
960 |
+"<td>" + "Available - Reserve" + "</td>"
|
| - |
|
961 |
+"<td>" + "Total Held" + "</td>"
|
| - |
|
962 |
+"</tr>";
|
| - |
|
963 |
|
| 956 |
emailSubjectTxt = "Held Inventory is more than available "+ sdf.format(System.currentTimeMillis());
|
964 |
emailSubjectTxt = "Held Inventory is more than available "+ sdf.format(System.currentTimeMillis());
|
| 957 |
if(heldMoreThanAvailable.length() > 0){
|
965 |
if(heldMoreThanAvailable.length() > 0){
|
| 958 |
text = "<html><table border=\"1\" align=\"center\">"+tableHeader+heldMoreThanAvailable.toString()+"</table></html>";
|
966 |
text = "<html><table border=\"1\" align=\"center\">"+tableHeader+heldMoreThanAvailable.toString()+"</table></html>";
|
| 959 |
try {
|
967 |
try {
|
| 960 |
mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
|
968 |
mailer.sendSSLMessage(sendTo,emailSubjectTxt, emailFromAddress, password, text);
|