22

✏️ Editing: sales_mgr.php

<?php $view='dashboard/sales_mgr.php'; ?>
<?php require __DIR__ . '/_shared.php'; ?>
<?php $k = $data['kpis'] ?? []; ?>

<div class="d-flex justify-content-between align-items-center mb-3 flex-wrap gap-2">
  <h4 class="mb-0">Sales Manager Dashboard</h4>
  <?php dash_range_select($config, $range); ?>
</div>

<div class="row g-2">
  <div class="col-6 col-lg-3"><div class="p-3 bg-light rounded">Leads<br><strong><?= (int)($k['leads_total'] ?? 0) ?></strong></div></div>
  <div class="col-6 col-lg-3"><div class="p-3 bg-light rounded">Qualified<br><strong><?= (int)($k['leads_qualified'] ?? 0) ?></strong></div></div>
  <div class="col-6 col-lg-3"><div class="p-3 bg-light rounded">Q%<br><strong><?= e($k['qualification_rate'] ?? 0) ?>%</strong></div></div>
  <div class="col-6 col-lg-3"><div class="p-3 bg-light rounded">Opps<br><strong><?= (int)($k['opp_total'] ?? 0) ?></strong></div></div>
  <div class="col-6 col-lg-3"><div class="p-3 bg-light rounded">Won<br><strong><?= (int)($k['opp_won'] ?? 0) ?></strong></div></div>
  <div class="col-6 col-lg-3"><div class="p-3 bg-light rounded">Lost<br><strong><?= (int)($k['opp_lost'] ?? 0) ?></strong></div></div>
  <div class="col-6 col-lg-3"><div class="p-3 bg-light rounded">Win%<br><strong><?= e($k['win_rate'] ?? 0) ?>%</strong></div></div>
  <div class="col-6 col-lg-3"><div class="p-3 bg-light rounded">Disqualified<br><strong><?= (int)($k['leads_disqualified'] ?? 0) ?></strong></div></div>
</div>

<div class="row g-3 mt-1">
  <div class="col-12 col-lg-6"><div class="card shadow-sm"><div class="card-body">
    <h6>Funnel</h6><div style="height:260px;"><canvas id="c1"></canvas></div>
  </div></div></div>
  <div class="col-12 col-lg-6"><div class="card shadow-sm"><div class="card-body">
    <h6>Opportunity Status</h6><div style="height:260px;"><canvas id="c2"></canvas></div>
  </div></div></div>

<div class="col-12 col-lg-6"><div class="card shadow-sm"><div class="card-body">
    <h6>Opportunity Stage</h6><div style="height:260px;"><canvas id="c3"></canvas></div>
  </div></div></div>
  <div class="col-12 col-lg-6"><div class="card shadow-sm"><div class="card-body">
    <h6>Won by Branch</h6><div style="height:260px;"><canvas id="c4"></canvas></div>
  </div></div></div>

<div class="col-12 col-lg-6"><div class="card shadow-sm"><div class="card-body">
    <h6>Vehicle of Interest</h6><div style="height:260px;"><canvas id="c5"></canvas></div>
  </div></div></div>
  <div class="col-12 col-lg-6"><div class="card shadow-sm"><div class="card-body">
    <h6>Leads by Source</h6><div style="height:260px;"><canvas id="c6"></canvas></div>
  </div></div></div>
</div>

<div class="row g-3 mt-1">
  <div class="col-12 col-lg-6">
    <div class="card shadow-sm"><div class="card-body">
      <h6 class="mb-2">Branch Leaderboard</h6>
      <div class="table-responsive">
        <table class="table table-sm align-middle">
          <thead><tr><th>Branch</th><th class="text-end">Opps</th><th class="text-end">Won</th><th class="text-end">Lost</th></tr></thead>
          <tbody>
          <?php foreach (($data['table_branch_leaderboard'] ?? []) as $r): ?>
            <tr>
              <td><?= e($r['branch']) ?></td>
              <td class="text-end"><?= (int)$r['opps'] ?></td>
              <td class="text-end"><?= (int)$r['won'] ?></td>
              <td class="text-end"><?= (int)$r['lost'] ?></td>
            </tr>
          <?php endforeach; ?>
          </tbody>
        </table>
      </div>
    </div></div>
  </div>

<div class="col-12 col-lg-6">
    <div class="card shadow-sm"><div class="card-body">
      <h6 class="mb-2">Sales Agent Leaderboard</h6>
      <div class="table-responsive">
        <table class="table table-sm align-middle">
          <thead><tr><th>Agent</th><th class="text-end">Opps</th><th class="text-end">Won</th><th class="text-end">Lost</th></tr></thead>
          <tbody>
          <?php foreach (($data['table_agent_leaderboard'] ?? []) as $r): ?>
            <tr>
              <td><?= e($r['agent']) ?></td>
              <td class="text-end"><?= (int)$r['opps'] ?></td>
              <td class="text-end"><?= (int)$r['won'] ?></td>
              <td class="text-end"><?= (int)$r['lost'] ?></td>
            </tr>
          <?php endforeach; ?>
          </tbody>
        </table>
      </div>
    </div></div>
  </div>
</div>

<?php chart_js('c1','bar', $data['chart_funnel'] ?? [], 'Count'); ?>
<?php chart_js('c2','pie', $data['chart_opp_status'] ?? [], 'Count'); ?>
<?php chart_js('c3','bar', $data['chart_opp_stage'] ?? [], 'Count'); ?>
<?php chart_js('c4','bar', $data['chart_branch_won'] ?? [], 'Won'); ?>
<?php chart_js('c5','bar', $data['chart_vehicle'] ?? [], 'Leads'); ?>
<?php chart_js('c6','bar', $data['chart_source'] ?? [], 'Leads'); ?>

MR SKB