WebSVN – SmartDukaan – Diff – /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

 import com.spice.profitmandi.dao.entity.cs.Ticket;
 import com.spice.profitmandi.dao.entity.dtr.User;
 import com.spice.profitmandi.dao.entity.dtr.*;
 import com.spice.profitmandi.dao.entity.fofo.*;
 import com.spice.profitmandi.dao.entity.inventory.*;
+import com.spice.profitmandi.dao.entity.logistics.AST;
+import com.spice.profitmandi.dao.entity.logistics.ASTRepository;
 import com.spice.profitmandi.dao.entity.transaction.*;
 import com.spice.profitmandi.dao.entity.user.*;
 import com.spice.profitmandi.dao.entity.warehouse.WarehouseInventoryItem;
 import com.spice.profitmandi.dao.entity.warehouse.WarehouseScan;
 import com.spice.profitmandi.dao.enumuration.auth.CollectionRemark;
     PurchaseMigration purchaseMigration;
     @Autowired
     SmartPingService smartPingService;
+    @Autowired
+    private ASTRepository astRepository;
     @Autowired
     private ServiceConfigService serviceConfigService;
     @Autowired
     @Autowired
     PriceCircularService priceCircularService;
     public void test() throws Exception {
-        this.findTodayPocoBillingItems();
 //        LocalDate startDate = LocalDate.of(2024, Month.MAY, 1);
 //        List<PriceDropIMEI> priceDropIMEIList = priceDropIMEIRepository.selectAllByCreditedBetween(startDate.atStartOfDay(), startDate.plusMonths(1).atTime(Utils.MAX_TIME));
 //        Set<Integer> inventoryItemIds = priceDropIMEIList.stream().map(x -> x.getInventoryItemId()).collect(Collectors.toSet());
 //        List<InventoryItem> inventoryItems = inventoryItemRepository.selectByIds(inventoryItemIds);
 //        List<String> headers = Arrays.asList("FofoId", "Serial Number", "Original DP", "DP(Inc PDs)", "PDs credited", "Fixed amount", "Discount", "Percentage Amount", "Margins Calc.", "Margins credited", "SoldOut");
+        }
+    }
     private String getMessageForDueDateExtend(List<Loan> loans) throws ProfitMandiBusinessException {
+        Map<Integer, com.spice.profitmandi.dao.model.FofoReportingModel> fofoReportingModelMap = csService.getPartnerIdSalesHeaders();
+        Map<Integer, FofoRBMReportingModel> fofoRbmReportingModelMap = csService.getPartnerIdRBMHeaders();
+        List<AST> asts = astRepository.selectAll();
+        Map<Integer, AST> astMap = asts.stream()
+                .collect(Collectors.toMap(AST::getId, ast -> ast));
         StringBuilder sb = new StringBuilder();
         sb.append(
-                "<html><body><p>Alert</p><p>Default Partners :-</p>" + "<br/><p>EveryDay Rs.100 charged as Penalty</p>" + "<br/><table style='border:1px solid black ;padding: 5px';>");
+                "<html><body><p>Alert</p><p>Default Partners :-</p>" + "<br/><p>EveryDay Rs.100 charged as Penalty</p>" + "<br/>" +
+                        "<table style='border:1px solid black ;padding: 5px';>");
+        sb.append("<tbody>\n" +
+                "<tr>\n" +
+                "<th style='border:1px solid black;padding: 5px'>PartnerName</th>\n" +
-        sb.append("<tbody>\n" + "	    				<tr>\n" + "	    					<th style='border:1px solid black;padding: 5px'>PartnerName</th>\n" + "	    					<th style='border:1px solid black;padding: 5px'>due date</th>\n" + "	    					<th style='border:1px solid black;padding: 5px'>Days</th>\n" + "	    					<th style='border:1px solid black;padding: 5px'>Pending Amount</th>\n"
+                "<th style='border:1px solid black;padding: 5px'>due date</th>\n" +
+                "<th style='border:1px solid black;padding: 5px'>Days</th>\n" +
+                "<th style='border:1px solid black;padding: 5px'>Pending Amount</th>\n"+
+                "<th style='border:1px solid black;padding: 5px'>RBM L1</th>\n" +
+                "<th style='border:1px solid black;padding: 5px'>RBM L2</th>\n" +
+                "<th style='border:1px solid black;padding: 5px'>Sales L1</th>\n" +
+                "<th style='border:1px solid black;padding: 5px'>Sales L2</th>\n" +
-                + "	    				</tr>");
+                "</tr>");
         for (Loan entry : loans) {
             List<LoanStatement> loanStatements = loanStatementRepository.selectByLoanId(entry.getId());
             double amount = loanStatements.stream().map(x -> x.getAmount()).collect(Collectors.summingDouble(x -> x.doubleValue()));
             sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getBusinessName() + "(" + customRetailer.getCode() + ")" + "</td>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + entry.getDueDate().format(DateTimeFormatter.ofPattern("dd/MM/yyyy")) + "</td>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + noOfdaysBetween + "</td>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + new DecimalFormat("#.##").format(Math.abs(amount)) + "</td>");
+            sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoRbmReportingModelMap.get(entry.getFofoId()).getL1Manager() + "</td>");
+            sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoRbmReportingModelMap.get(entry.getFofoId()).getL2Manager() + "</td>");
+            sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoReportingModelMap.get(entry.getFofoId()).getTerritoryManager() + "</td>");
+            sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoReportingModelMap.get(entry.getFofoId()).getRegionalManager() + "</td>");
+            sb.append("<td style='border:1px solid black;padding: 5px'>" + astMap.get(customRetailer.getAstId()).getArea() + "</td>");
+            sb.append("<td style='border:1px solid black;padding: 5px'>" + astMap.get(customRetailer.getAstId()).getTerritory() + "</td>");
             sb.append("</tr>");
+        }
+    }
     private String getMessageForDueDateCross(List<Loan> loans) throws ProfitMandiBusinessException {
         Map<Integer, com.spice.profitmandi.dao.model.FofoReportingModel> fofoReportingModelMap = csService.getPartnerIdSalesHeaders();
         Map<Integer, FofoRBMReportingModel> fofoRbmReportingModelMap = csService.getPartnerIdRBMHeaders();
+        List<AST> asts = astRepository.selectAll();
+        Map<Integer, AST> astMap = asts.stream()
+                .collect(Collectors.toMap(AST::getId, ast -> ast));
         StringBuilder sb = new StringBuilder();
         sb.append("<html><body><p>Alert</p><p>Due Date Cross Partners :-</p>" + "<br/><p>Additional penal interest of  shall be levied on daily basis.</p>" + "<br/>" +
                 "<table style='border:1px solid black ;padding: 5px';>");
         sb.append("<tbody>\n" + "<tr>\n" +
                 "<th style='border:1px solid black;padding: 5px'>PartnerName</th>\n" +
                 "<th style='border:1px solid black;padding: 5px'>State Name</th>\n" +
+                "<th style='border:1px solid black;padding: 5px'>Aria</th>\n" +
+                "<th style='border:1px solid black;padding: 5px'>Territory</th>\n" +
                 "<th style='border:1px solid black;padding: 5px'>due date</th>\n" +
                 "<th style='border:1px solid black;padding: 5px'>Days</th>\n" +
                 "<th style='border:1px solid black;padding: 5px'>Pending Amount</th>\n" +
                 "<th style='border:1px solid black;padding: 5px'>RBM L1</th>\n" +
                 "<th style='border:1px solid black;padding: 5px'>RBM L2</th>\n" +
             CustomRetailer customRetailer = retailerService.getFofoRetailer(entry.getFofoId());
             sb.append("<tr>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getBusinessName() + "(" + customRetailer.getCode() + ")" + "</td>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + customRetailer.getAddress().getState() + "</td>");
+            sb.append("<td style='border:1px solid black;padding: 5px'>" + astMap.get(customRetailer.getAstId()).getArea() + "</td>");
+            sb.append("<td style='border:1px solid black;padding: 5px'>" + astMap.get(customRetailer.getAstId()).getTerritory() + "</td>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + entry.getDueDate().format(DateTimeFormatter.ofPattern("dd/MM/yyyy")) + "</td>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + noOfdaysBetween + "</td>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + new DecimalFormat("#.##").format(Math.abs(amount)) + "</td>");
             sb.append("<td style='border:1px solid black;padding: 5px'>" + fofoRbmReportingModelMap.get(entry.getFofoId()).getL1Manager() + "</td>");

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java – Rev 33524 → 33553