<?php
declare(strict_types=1);
session_start();
date_default_timezone_set('Asia/Kolkata');

@ini_set('display_errors', '0');
error_reporting(E_ALL);

/*
 * Pending Commission Admin
 * Install: public_html/developer-maruf/pending_commission.php
 * Uses existing admin session key: unohs
 * Uses existing database connection: developer-maruf/conn.php
 */

if (empty($_SESSION['unohs'])) {
    http_response_code(403);
    exit('Admin login required. Please login to the admin panel first.');
}

require_once __DIR__ . '/conn.php';

if (!isset($conn) || !($conn instanceof mysqli)) {
    http_response_code(500);
    exit('Database connection $conn was not found in conn.php.');
}

$conn->set_charset('utf8mb4');

function h($value): string {
    return htmlspecialchars((string)$value, ENT_QUOTES, 'UTF-8');
}
function money($value): string {
    return number_format((float)$value, 2, '.', ',');
}
function tableExists(mysqli $db, string $table): bool {
    $safe = $db->real_escape_string($table);
    $res = $db->query("SHOW TABLES LIKE '{$safe}'");
    return $res && $res->num_rows > 0;
}

if (!tableExists($conn, 'saas_pending_commissions')) {
    http_response_code(500);
    exit('Table saas_pending_commissions does not exist. Run the updated bootstrap/schema first.');
}

$status = isset($_GET['status']) ? strtolower(trim((string)$_GET['status'])) : 'pending';
if (!in_array($status, ['pending', 'credited', 'all'], true)) $status = 'pending';
$agentId = isset($_GET['agent_id']) ? (int)$_GET['agent_id'] : 0;
$from = isset($_GET['from']) ? trim((string)$_GET['from']) : '';
$to = isset($_GET['to']) ? trim((string)$_GET['to']) : '';

$where = [];
$params = [];
$types = '';
if ($status !== 'all') {
    $where[] = 'p.status = ?';
    $params[] = $status;
    $types .= 's';
}
if ($agentId > 0) {
    $where[] = 'p.sponsor_id = ?';
    $params[] = $agentId;
    $types .= 'i';
}
if ($from !== '' && preg_match('/^\d{4}-\d{2}-\d{2}$/', $from)) {
    $where[] = 'DATE(p.created_at) >= ?';
    $params[] = $from;
    $types .= 's';
}
if ($to !== '' && preg_match('/^\d{4}-\d{2}-\d{2}$/', $to)) {
    $where[] = 'DATE(p.created_at) <= ?';
    $params[] = $to;
    $types .= 's';
}
$whereSql = $where ? ('WHERE ' . implode(' AND ', $where)) : '';

function fetchRows(mysqli $db, string $sql, string $types, array $params): array {
    $stmt = $db->prepare($sql);
    if (!$stmt) throw new RuntimeException('SQL prepare failed: ' . $db->error);
    if ($types !== '') $stmt->bind_param($types, ...$params);
    if (!$stmt->execute()) throw new RuntimeException('SQL execute failed: ' . $stmt->error);
    $result = $stmt->get_result();
    $rows = $result ? $result->fetch_all(MYSQLI_ASSOC) : [];
    $stmt->close();
    return $rows;
}

$error = '';
$rows = [];
$summary = ['amount' => 0, 'entries' => 0, 'agents' => 0];
try {
    $rows = fetchRows(
        $conn,
        "SELECT p.id, p.sponsor_id, p.bettor_id, p.level_no,
                p.commission_amount, p.turnover, p.due_at, p.status,
                p.created_at, p.credited_at
         FROM saas_pending_commissions p
         {$whereSql}
         ORDER BY CASE WHEN p.status='pending' THEN 0 ELSE 1 END,
                  p.due_at ASC, p.id DESC
         LIMIT 2000",
        $types,
        $params
    );

    $agentSet = [];
    foreach ($rows as $r) {
        $summary['amount'] += (float)$r['commission_amount'];
        $summary['entries']++;
        $agentSet[(string)$r['sponsor_id']] = true;
    }
    $summary['agents'] = count($agentSet);
} catch (Throwable $e) {
    $error = $e->getMessage();
}

$pendingTotals = ['amount' => 0.0, 'entries' => 0, 'agents' => 0];
try {
    $totals = fetchRows(
        $conn,
        "SELECT COUNT(*) AS entries, COALESCE(SUM(commission_amount),0) AS amount,
                COUNT(DISTINCT sponsor_id) AS agents
         FROM saas_pending_commissions WHERE status='pending'",
        '', []
    );
    if ($totals) {
        $pendingTotals['amount'] = (float)$totals[0]['amount'];
        $pendingTotals['entries'] = (int)$totals[0]['entries'];
        $pendingTotals['agents'] = (int)$totals[0]['agents'];
    }
} catch (Throwable $e) {
    if ($error === '') $error = $e->getMessage();
}

$now = time();
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Pending Commission Admin</title>
<style>
*{box-sizing:border-box}body{margin:0;background:#f3f5f9;color:#172033;font:14px Arial,sans-serif}
.wrap{max-width:1400px;margin:24px auto;padding:0 16px}.top{display:flex;justify-content:space-between;align-items:center;gap:12px;flex-wrap:wrap;margin-bottom:18px}
h1{font-size:24px;margin:0}.sub{color:#697386;margin-top:6px}.cards{display:grid;grid-template-columns:repeat(4,minmax(0,1fr));gap:12px;margin:18px 0}
.card{background:#fff;border:1px solid #e5e9f0;border-radius:12px;padding:17px;box-shadow:0 2px 8px #17203308}
.label{color:#687386;font-size:12px}.value{font-size:25px;font-weight:700;margin-top:8px}
.filters{display:flex;gap:9px;flex-wrap:wrap;align-items:end;background:#fff;padding:14px;border:1px solid #e5e9f0;border-radius:12px;margin-bottom:14px}
label{display:block;font-size:12px;color:#687386;margin-bottom:5px}input,select{padding:10px;border:1px solid #d8deea;border-radius:8px;background:#fff;min-height:38px}
button,.btn{padding:10px 15px;border:0;border-radius:8px;background:#2459d3;color:#fff;cursor:pointer;text-decoration:none;display:inline-block}
.tablebox{overflow:auto;background:#fff;border:1px solid #e5e9f0;border-radius:12px}
table{border-collapse:collapse;width:100%;min-width:1050px}th,td{padding:12px 11px;text-align:left;border-bottom:1px solid #edf0f5;white-space:nowrap}
th{background:#f8f9fc;color:#566176;font-size:12px;position:sticky;top:0}tr:last-child td{border-bottom:0}
.pending{color:#a45a00;background:#fff3d9;padding:5px 8px;border-radius:20px;font-weight:700}
.credited{color:#087443;background:#e3f8ed;padding:5px 8px;border-radius:20px;font-weight:700}
.timer{font-weight:700;color:#b45309}.done{color:#087443}.muted{color:#7b8495}
.alert{background:#fff0f0;color:#a32121;padding:12px;border-radius:9px;margin:12px 0}
.empty{padding:30px;text-align:center;color:#778195}
@media(max-width:800px){.cards{grid-template-columns:repeat(2,minmax(0,1fr))}.value{font-size:21px}.wrap{margin:14px auto}}
</style>
</head>
<body>
<div class="wrap">
  <div class="top">
    <div><h1>Pending Commission Dashboard</h1><div class="sub">Agent-wise commission settlement monitor · India time (IST)</div></div>
    <a class="btn" href="pending_commission.php">Refresh</a>
  </div>

  <div class="cards">
    <div class="card"><div class="label">Total Pending Commission</div><div class="value">₹<?= money($pendingTotals['amount']) ?></div></div>
    <div class="card"><div class="label">Pending Entries</div><div class="value"><?= number_format($pendingTotals['entries']) ?></div></div>
    <div class="card"><div class="label">Agents With Pending</div><div class="value"><?= number_format($pendingTotals['agents']) ?></div></div>
    <div class="card"><div class="label">Current IST Time</div><div class="value" id="clock">--:--:--</div></div>
  </div>

  <?php if ($error !== ''): ?><div class="alert">Database error: <?= h($error) ?></div><?php endif; ?>

  <form class="filters" method="get">
    <div><label>Status</label><select name="status">
      <option value="pending" <?= $status==='pending'?'selected':'' ?>>Pending</option>
      <option value="credited" <?= $status==='credited'?'selected':'' ?>>Credited</option>
      <option value="all" <?= $status==='all'?'selected':'' ?>>All</option>
    </select></div>
    <div><label>Agent ID</label><input type="number" name="agent_id" min="1" value="<?= $agentId ?: '' ?>" placeholder="All agents"></div>
    <div><label>Created from</label><input type="date" name="from" value="<?= h($from) ?>"></div>
    <div><label>Created to</label><input type="date" name="to" value="<?= h($to) ?>"></div>
    <button type="submit">Apply Filter</button>
    <a class="btn" href="pending_commission.php" style="background:#657187">Reset</a>
  </form>

  <div class="tablebox">
    <table>
      <thead><tr>
        <th>Agent ID</th><th>Bettor ID</th><th>Level</th><th>Bet Turnover</th>
        <th>Commission</th><th>Created At</th><th>Credit Due (IST)</th>
        <th>Time Left</th><th>Status</th><th>Credited At</th>
      </tr></thead>
      <tbody>
      <?php if (!$rows): ?>
        <tr><td colspan="10" class="empty">No commission records found for this filter.</td></tr>
      <?php else: foreach ($rows as $r):
          $dueTs = strtotime((string)$r['due_at']);
          $left = $dueTs !== false ? $dueTs - $now : 0;
      ?>
        <tr>
          <td><strong><?= h($r['sponsor_id']) ?></strong></td>
          <td><?= h($r['bettor_id']) ?></td>
          <td>L<?= h($r['level_no']) ?></td>
          <td>₹<?= money($r['turnover']) ?></td>
          <td><strong>₹<?= money($r['commission_amount']) ?></strong></td>
          <td><?= h($r['created_at']) ?></td>
          <td><?= h($r['due_at']) ?></td>
          <td><?php if ($r['status'] === 'pending' && $dueTs !== false): ?>
            <span class="timer countdown" data-due="<?= (int)$dueTs ?>">Calculating…</span>
          <?php elseif ($r['status'] === 'credited'): ?><span class="done">Credited</span>
          <?php else: ?><span class="muted">Due time unavailable</span><?php endif; ?></td>
          <td><span class="<?= $r['status']==='credited'?'credited':'pending' ?>"><?= h(ucfirst((string)$r['status'])) ?></span></td>
          <td><?= $r['credited_at'] ? h($r['credited_at']) : '—' ?></td>
        </tr>
      <?php endforeach; endif; ?>
      </tbody>
    </table>
  </div>
  <p class="muted">Showing up to 2,000 records. Countdown updates every second; data refreshes when you reload the page. Wallet credit is handled only by the settlement cron, not from this dashboard.</p>
</div>
<script>
function updateTimers(){
  const now=Math.floor(Date.now()/1000);
  document.querySelectorAll('.countdown').forEach(el=>{
    let sec=parseInt(el.dataset.due,10)-now;
    if(!Number.isFinite(sec)){el.textContent='Time unavailable';return;}
    if(sec<=0){el.textContent='Due — waiting for cron';return;}
    const d=Math.floor(sec/86400);sec%=86400;
    const h=Math.floor(sec/3600);sec%=3600;
    const m=Math.floor(sec/60);const s=sec%60;
    el.textContent=(d?d+'d ':'')+String(h).padStart(2,'0')+':'+String(m).padStart(2,'0')+':'+String(s).padStart(2,'0');
  });
  document.getElementById('clock').textContent=new Date().toLocaleTimeString('en-IN',{timeZone:'Asia/Kolkata',hour12:false});
}
updateTimers();setInterval(updateTimers,1000);
</script>
</body>
</html>