WebSVN – SmartDukaan – Diff – //trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java

      *  the shipped monthly-email cron. */
     private static final String[] RBM_RANK_PROBE_RECIPIENTS = {
 //            "gaurav.mathur@smartdukaan.com",
 //            "kangan.monga@smartdukaan.com",
 //            "siddharth.chaturvedi@smartdukaan.com",
-//            "aquil.ahmad@smartdukaan.com",
+////            "aquil.ahmad@smartdukaan.com",
 //            "charu.sharma@smartdukaan.com",
             "ranu.rajput@smartdukaan.com"
     };
     /**
                     dm.getAbove1LPct(), dm.getPartnerRating(), ratedPct,
                     dm.getCompositeScore()));
+        }
         LOGGER.info("[RBM-RANK] === End ranking for {} ===", month);
-        // Email disabled while verifying data gaps — check logs only.
+        // Email the same table so the user can eyeball without tailing logs.
-        // try {
+        try {
-        //     sendRbmRankingProbeEmail(month, from, to, ranked);
+            sendRbmRankingProbeEmail(month, from, to, ranked);
-        // } catch (Exception e) {
+        } catch (Exception e) {
-        //     LOGGER.error("[RBM-RANK] Email send FAILED (log-only fallback in place): {}", e.getMessage(), e);
+            LOGGER.error("[RBM-RANK] Email send FAILED (log-only fallback in place): {}", e.getMessage(), e);
-        // }
+        }
+    }
     /** Direct HTML send via googleMailSender — bypasses mail_outbox so dev delivers. */
     private void sendRbmRankingProbeEmail(java.time.YearMonth month, LocalDate from, LocalDate to,
                                           List<RbmPerformanceDashboardModel> ranked) throws Exception {
         body.append("<p style='color:#555;font-size:12px'>Score formula: Talk(10%) + DRR(55%) + Aging(2%) + &gt;1L(29%) + Rating(2%) + Rated(2%).</p>");
         body.append("<table border='1' cellpadding='6' cellspacing='0' style='border-collapse:collapse;font-size:12px'>");
         body.append("<thead><tr style='background:#343a40;color:#fff'>")
             .append("<th>Rank</th><th style='text-align:left'>RBM</th><th>Partners</th>")
             .append("<th style='background:#28a745'>Talk%<br><small>(10%)</small></th>")
+            .append("<th style='background:#20c997'>Target<br><small>(Lakh)</small></th>")
+            .append("<th style='background:#0dcaf0;color:#000'>Secondary<br><small>(Lakh)</small></th>")
             .append("<th style='background:#17a2b8'>DRR%<br><small>(55%)</small></th>")
             .append("<th style='background:#fd7e14'>Aging%<br><small>(2%)</small></th>")
             .append("<th style='background:#6f42c1'>&gt;1L%<br><small>(29%)</small></th>")
             .append("<th style='background:#ffc107;color:#000'>Rating<br><small>(2%)</small></th>")
             .append("<th style='background:#e67e22'>Rated%<br><small>(2%)</small></th>")
             body.append("<tr style='").append(rowStyle).append("'>")
                 .append("<td style='text-align:center'>").append(dm.getRank()).append("</td>")
                 .append("<td>").append(escapeHtml(dm.getRbmName())).append("</td>")
                 .append("<td style='text-align:center'>").append(dm.getPartnerCount()).append("</td>")
                 .append("<td style='text-align:right'>").append(String.format("%.1f%%", dm.getTalkPct())).append("</td>")
+                .append("<td style='text-align:right'>").append(String.format("%.1fL", dm.getMonthlyTarget() / 100000.0)).append("</td>")
+                .append("<td style='text-align:right'>").append(String.format("%.1fL", dm.getMtdAchieved()   / 100000.0)).append("</td>")
                 .append("<td style='text-align:right'>").append(String.format("%.1f%%", dm.getDrrAchvPct())).append("</td>")
                 .append("<td style='text-align:right'>").append(String.format("%.1f%%", dm.getAgingPct())).append("</td>")
                 .append("<td style='text-align:right'>").append(String.format("%.1f%%", dm.getAbove1LPct())).append("</td>")
                 .append("<td style='text-align:center'>").append(String.format("%.2f", dm.getPartnerRating())).append(" ★</td>")
                 .append("<td style='text-align:right'>").append(String.format("%.1f%%", ratedPct)).append("</td>")

Subversion Repositories SmartDukaan

(root)//trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java – Rev 37892 → 37894