WebSVN – SmartDukaan – Diff – //trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm-drr-dashboard.vm

         Loading&hellip;
       </div>
     </div>
   </div>
-  <!-- Partner Billing Count -->
+  <!-- Partner Billing Count — unchanged, always current month MTD -->
   <div class="sectionlabel">Partner Billing Count <span
           style="color:var(--soft);font-weight:600;text-transform:none;letter-spacing:0;margin-left:6px">(Targeted partners only &middot; bucketed by MTD ₹)</span>
   </div>
   <div class="card">
     <div class="card-hd">
         Loading&hellip;
       </div>
     </div>
   </div>
-  <!-- RBM Performance Dashboard (MTD) — extracted from /indent/today_po_rbm without any backend change -->
+  <!-- RBM Performance Dashboard — JSON-driven, supports historical months via /rbm-drr/performance?month=YYYY-MM -->
-  <div class="sectionlabel">RBM Performance Dashboard (MTD)</div>
+  <div class="sectionlabel">RBM Performance Dashboard</div>
   <div class="card">
     <div class="card-hd">
       <div>
         <h2>Composite MTD Ranking</h2>
         <p class="desc">Rank of RBMs by weighted score across Talk Time (10%) + MTD Achievement (55%) + Aging (2%) +
-          &gt;1L Partners (29%) + Rating (2%) + Partners Rated (2%).</p>
+          &gt;1L Partners (29%) + Rating (2%) + Partners Rated (2%).
+          <span style="color:var(--soft)"
+                title="Aging denominator uses today's warehouse aging snapshot — for past months aging% is approximate.">Aging denominator is a live snapshot.</span>
+        </p>
+      </div>
+      <div style="display:flex;align-items:center;gap:10px">
+        <select id="rdrrMonthPicker" class="ctl" style="min-width:170px;height:30px;padding:4px 10px"
+                title="Pick a month to view that month's ranking"></select>
+        <span class="badge-period" id="rdrrPerfMonth">MTD</span>
       </div>
-      <span class="badge-period" id="rdrrPerfMonth">MTD</span>
     </div>
     <div id="rdrrPerfWrap">
       <div class="loading">
         <div class="spinner"></div>
         Loading&hellip;
               .replace(/"/g, "&quot;").replace(/'/g, "&#39;");
+    }
     $("#rdrrPmCategory").on("change", loadPurchaseMilestones);
-    // ------------------------- RBM Performance Dashboard (MTD) -------------------------
+    // ------------------------- Month picker + RBM Performance Dashboard -------------------------
-    // No dedicated backend endpoint exists — the perf-dashboard table is only rendered
+    // The Composite MTD Ranking card now reads /rbm-drr/performance?month=YYYY-MM so historical
+    // months can be viewed. Partner Billing Count re-fetches /rbm-drr/extras?month=YYYY-MM.
-    // inline in /indent/today_po_rbm. We fetch that page and extract just the table.
+    // Aging/Billing extras aging bits are unaffected by the month picker — they stay driven by
+    // the top-of-page date range.
+    function fmtSeconds(sec) {
+      sec = Math.max(0, Math.round(Number(sec) || 0));
+      var h = Math.floor(sec / 3600);
+      var m = Math.floor((sec % 3600) / 60);
+      if (h > 0) return h + "h " + m + "m";
+      return m + "m";
+    }
+    function pctCell(pct) {
+      var p = Number(pct) || 0;
+      return p.toFixed(1) + "%";
+    }
+    function renderPerformance(data) {
+      var rows = data.rows || [];
+      $("#rdrrPerfMonth").text(data.monthLabel || 'MTD');
+      if (rows.length === 0) {
+        $("#rdrrPerfWrap").html('<div class="empty"><div class="ei">📊</div>No performance dashboard data for this month.</div>');
+        return;
+      }
+      var html = ['<div style="overflow-x:auto"><table class="xtable" id="rdrrPerfTable"><thead><tr>',
+        '<th style="width:48px">Rank</th>',
+        '<th>RBM</th>',
+        '<th class="num">Partners</th>',
+        '<th class="num" title="Talk time / expected (10%)">Talk Time<br><small>(10%)</small></th>',
+        '<th class="num" title="MTD achieved / monthly target (55%)">MTD Achievement<br><small>(55%)</small></th>',
+        '<th class="num" title="Aging sold / warehouse aging stock. Denominator is a live snapshot (2%).">15-Day Aging<br><small>(2%)</small></th>',
+        '<th class="num" title="Partners who crossed ₹1L this month (29%)">&gt;1L Partners<br><small>(29%)</small></th>',
+        '<th class="num" title="Average partner rating (2%)">Avg Rating<br><small>(2%)</small></th>',
+        '<th class="num" title="Partners who rated / total partners (2%)">Partners Rated<br><small>(2%)</small></th>',
+        '<th class="num g-total">Score</th>',
+        '</tr></thead><tbody>'];
+      rows.forEach(function (r) {
+        var rankCell;
+        if (r.rank === 1) rankCell = '<img src="/resources/images/king.png" style="width:28px" title="Rank 1">';
+        else if (r.rank === 2) rankCell = '<img src="/resources/images/trophy-cup.png" style="width:24px" title="Rank 2">';
+        else if (r.rank === 3) rankCell = '<img src="/resources/images/bronze-medal.png" style="width:24px" title="Rank 3">';
+        else rankCell = String(r.rank);
+        html.push('<tr>' +
+                '<td class="num">' + rankCell + '</td>' +
+                '<td class="rbm-nm">' + escapeHtml(r.rbmName || '-') + '</td>' +
+                '<td class="num">' + (Number(r.partnerCount) || 0) + '</td>' +
+                '<td class="num">' + fmtSeconds(r.talkSeconds) + '<br><small style="color:var(--soft)">' + pctCell(r.talkPct) + '</small></td>' +
+                '<td class="num">' + pctCell(r.drrAchvPct) + '</td>' +
+                '<td class="num">' + formatIndian(r.agingUnitsSold) + '<br><small style="color:var(--soft)">' + pctCell(r.agingPct) + '</small></td>' +
+                '<td class="num">' + (Number(r.above1LPartnerCount) || 0) + '<br><small style="color:var(--soft)">' + pctCell(r.above1LPct) + '</small></td>' +
-    // Trade-off: heavier request (server re-runs full page prep). Consider adding a
+                '<td class="num">' + (Number(r.partnerRating) || 0).toFixed(2) + '</td>' +
-    // /rbm-drr/performance fragment endpoint later if this becomes a hot path.
+                '<td class="num">' + (Number(r.ratingPartnerCount) || 0) + '</td>' +
+                '<td class="num g-total">' + (Number(r.compositeScore) || 0).toFixed(1) + '</td>' +
+                '</tr>');
+      });
+      html.push('</tbody></table></div>');
+      $("#rdrrPerfWrap").html(html.join(""));
+    }
-    function loadPerformanceDashboard() {
+    function loadPerformance(monthKey) {
       $("#rdrrPerfWrap").html('<div class="loading"><div class="spinner"></div>Loading&hellip;</div>');
+      var qs = monthKey ? ("?month=" + encodeURIComponent(monthKey)) : "";
+      fetch("/rbm-drr/performance" + qs, {credentials: "same-origin"})
-      $.ajax({
+              .then(function (r) {
+                return r.json().then(function (b) {
-        url: "/indent/today_po_rbm",
+                  return {ok: r.ok, body: b};
-        type: "GET",
+                });
-        dataType: "html",
+              })
-        success: function (fullHtml) {
+              .then(function (res) {
-          var doc = new DOMParser().parseFromString(fullHtml, "text/html");
+                if (!res.ok) {
+                  $("#rdrrPerfWrap").html('<div class="empty">' + escapeHtml(res.body && res.body.error ? res.body.error : "Failed to load.") + '</div>');
+                  return;
+                }
-          var tbl = doc.querySelector("#performance-dashboard-table");
+                renderPerformance(res.body);
-          if (!tbl) {
+              })
+              .catch(function (e) {
-            $("#rdrrPerfWrap").html('<div class="empty"><div class="ei">📊</div>No performance dashboard data available yet.</div>');
+                $("#rdrrPerfWrap").html('<div class="empty">Failed to load: ' + (e && e.message ? e.message : "network error") + '</div>');
-            return;
+              });
-          }
+    }
-          // Fix any relative image paths (e.g. king.png / trophy-cup.png) to be root-relative.
+    // Note: variable is named `sel` without the leading dollar on purpose.
-          tbl.querySelectorAll("img").forEach(function (im) {
+    // Velocity would parse a leading-dollar name as a template reference and
-            var src = im.getAttribute("src") || "";
+    // choke on the embedded strings in the body.
+    function populateMonthPicker() {
-            if (src.indexOf("resources/") !== -1 && src.charAt(0) !== "/") {
+      var sel = $("#rdrrMonthPicker");
-              im.setAttribute("src", "/" + src.replace(/^\.\.\/+/, ""));
+      if (sel.length === 0 || sel.data("populated")) return;
-            }
+      var now = new Date();
-          });
+      var opts = [];
+      for (var i = 0; i < 6; i++) {
-          $("#rdrrPerfWrap").empty().append(tbl);
+        var d = new Date(now.getFullYear(), now.getMonth() - i, 1);
-        },
+        var y = d.getFullYear();
+        var m = String(d.getMonth() + 1).padStart(2, "0");
-        error: function () {
+        var key = y + "-" + m;
+        var label = d.toLocaleString("en-US", {month: "long", year: "numeric"}) + (i === 0 ? " (current)" : "");
-          $("#rdrrPerfWrap").html('<div class="empty">Failed to load performance dashboard.</div>');
+        opts.push('<option value="' + key + '">' + label + '</option>');
-        }
+      }
+      sel.html(opts.join(""));
+      sel.data("populated", true);
+      sel.on("change", function () {
+        loadPerformance($(this).val());
       });
+    }
     // ------------------------- RBM Call Target iframe -------------------------
     // The /indent/rbm_call_target endpoint returns a Velocity FRAGMENT (no <html>,
+      }
     });
     // initial load
     loadFilterOptions();
+    populateMonthPicker();
     load();
     loadPurchaseMilestones();
-    loadPerformanceDashboard();
+    loadPerformance($("#rdrrMonthPicker").val() || null);
     loadCallTargetIframe();
   })();
 </script>
 </body>
 </html>

Subversion Repositories SmartDukaan

(root)//trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm-drr-dashboard.vm – Rev 37775 → 37864