| Line 5... |
Line 5... |
| 5 |
import java.sql.Timestamp;
|
5 |
import java.sql.Timestamp;
|
| 6 |
import java.text.MessageFormat;
|
6 |
import java.text.MessageFormat;
|
| 7 |
import java.time.LocalDate;
|
7 |
import java.time.LocalDate;
|
| 8 |
import java.time.LocalDateTime;
|
8 |
import java.time.LocalDateTime;
|
| 9 |
import java.time.LocalTime;
|
9 |
import java.time.LocalTime;
|
| - |
|
10 |
import java.time.temporal.ChronoField;
|
| 10 |
import java.time.temporal.ChronoUnit;
|
11 |
import java.time.temporal.ChronoUnit;
|
| - |
|
12 |
import java.time.temporal.IsoFields;
|
| - |
|
13 |
import java.time.temporal.TemporalField;
|
| 11 |
import java.util.ArrayList;
|
14 |
import java.util.ArrayList;
|
| 12 |
import java.util.Arrays;
|
15 |
import java.util.Arrays;
|
| 13 |
import java.util.HashMap;
|
16 |
import java.util.HashMap;
|
| 14 |
import java.util.HashSet;
|
17 |
import java.util.HashSet;
|
| 15 |
import java.util.List;
|
18 |
import java.util.List;
|
| Line 18... |
Line 21... |
| 18 |
import java.util.stream.Collectors;
|
21 |
import java.util.stream.Collectors;
|
| 19 |
|
22 |
|
| 20 |
import javax.mail.MessagingException;
|
23 |
import javax.mail.MessagingException;
|
| 21 |
import javax.mail.internet.InternetAddress;
|
24 |
import javax.mail.internet.InternetAddress;
|
| 22 |
import javax.mail.internet.MimeMessage;
|
25 |
import javax.mail.internet.MimeMessage;
|
| - |
|
26 |
import javax.persistence.TemporalType;
|
| 23 |
|
27 |
|
| 24 |
import org.apache.commons.codec.CharEncoding;
|
28 |
import org.apache.commons.codec.CharEncoding;
|
| 25 |
import org.apache.commons.io.IOUtils;
|
29 |
import org.apache.commons.io.IOUtils;
|
| 26 |
import org.apache.commons.io.output.ByteArrayOutputStream;
|
30 |
import org.apache.commons.io.output.ByteArrayOutputStream;
|
| 27 |
import org.apache.logging.log4j.LogManager;
|
31 |
import org.apache.logging.log4j.LogManager;
|
| Line 483... |
Line 487... |
| 483 |
LOGGER.info("Could not find retailer with retailer Id {}", fofoStore.getId());
|
487 |
LOGGER.info("Could not find retailer with retailer Id {}", fofoStore.getId());
|
| 484 |
continue;
|
488 |
continue;
|
| 485 |
}
|
489 |
}
|
| 486 |
float walletAmount = walletService.getUserWallet(fofoStore.getId()).getAmount();
|
490 |
float walletAmount = walletService.getUserWallet(fofoStore.getId()).getAmount();
|
| 487 |
float inStockAmount = inventoryService.getTotalAmountInStock(fofoStore.getId());
|
491 |
float inStockAmount = inventoryService.getTotalAmountInStock(fofoStore.getId());
|
| 488 |
float salesAmount = orderService.getSales(fofoStore.getId(), LocalDate.now().minusDays(1));
|
492 |
float salesAmount = orderService.getSales(fofoStore.getId(), LocalDateTime.now().minusDays(1).with(LocalTime.MIDNIGHT), LocalDateTime.now());
|
| 489 |
|
493 |
|
| 490 |
float unbilledStockAmount = 0;
|
494 |
float unbilledStockAmount = 0;
|
| 491 |
List<Order> unbilledOrders = transactionService.getInTransitOrders(fofoStore.getId());
|
495 |
List<Order> unbilledOrders = transactionService.getInTransitOrders(fofoStore.getId());
|
| 492 |
for (Order unBilledOrder : unbilledOrders) {
|
496 |
for (Order unBilledOrder : unbilledOrders) {
|
| 493 |
unbilledStockAmount += unBilledOrder.getTotalAmount();
|
497 |
unbilledStockAmount += unBilledOrder.getTotalAmount();
|
| Line 498... |
Line 502... |
| 498 |
for (Order grnPendingOrder : grnPendingOrders) {
|
502 |
for (Order grnPendingOrder : grnPendingOrders) {
|
| 499 |
LOGGER.info("Grn pending for Order {} and partner {}", grnPendingOrder.getId(),
|
503 |
LOGGER.info("Grn pending for Order {} and partner {}", grnPendingOrder.getId(),
|
| 500 |
grnPendingOrder.getRetailerEmailId());
|
504 |
grnPendingOrder.getRetailerEmailId());
|
| 501 |
grnPendingStockAmount += grnPendingOrder.getTotalAmount();
|
505 |
grnPendingStockAmount += grnPendingOrder.getTotalAmount();
|
| 502 |
}
|
506 |
}
|
| 503 |
float totalInvestedAmount = walletAmount + inStockAmount + unbilledStockAmount + grnPendingStockAmount;
|
507 |
float totalInvestedAmount = walletAmount + inStockAmount + unbilledStockAmount + grnPendingStockAmount + salesAmount;
|
| 504 |
List<Object> row = Arrays.asList(fofoStore.getCode(), retailer.getBusinessName(), retailer.getEmail(),
|
508 |
List<Object> row = Arrays.asList(fofoStore.getCode(), retailer.getBusinessName(), retailer.getEmail(),
|
| 505 |
retailer.getMobileNumber(), salesAmount, walletAmount, inStockAmount, 0, unbilledStockAmount,
|
509 |
retailer.getMobileNumber(), salesAmount, walletAmount, inStockAmount, 0, unbilledStockAmount,
|
| 506 |
grnPendingStockAmount, fofoStore.getMinimumInvestment(), totalInvestedAmount,
|
510 |
grnPendingStockAmount, fofoStore.getMinimumInvestment(), totalInvestedAmount,
|
| 507 |
fofoStore.getMinimumInvestment() - totalInvestedAmount);
|
511 |
fofoStore.getMinimumInvestment() - totalInvestedAmount);
|
| 508 |
float shortValue = fofoStore.getMinimumInvestment() - totalInvestedAmount;
|
512 |
float shortValue = fofoStore.getMinimumInvestment() - totalInvestedAmount;
|