#I LOVE YOU EVERDAY#

<?php
session_start();
include 'db_connection.php';

// Hakikisha admin ame-login
if (!isset($_SESSION['admin_logged_in']) || $_SESSION['admin_logged_in'] !== true) {
    header("Location: admin_login.php");
    exit;
}

// Basic stats
$agents = $conn->query("SELECT COUNT(*) AS total FROM agents")->fetch_assoc()['total'];
$houses_sale = $conn->query("SELECT COUNT(*) AS total FROM houses_for_sale")->fetch_assoc()['total'];
$houses_rent = $conn->query("SELECT COUNT(*) AS total FROM houses_for_rent")->fetch_assoc()['total'];
$rooms_rent = $conn->query("SELECT COUNT(*) AS total FROM rooms_for_rent")->fetch_assoc()['total'];
$plots_sale = $conn->query("SELECT COUNT(*) AS total FROM plots_for_sale")->fetch_assoc()['total'];

// Total listings
$total_listings = $houses_sale + $houses_rent + $rooms_rent + $plots_sale;

// Visitors – placeholder (later you’ll track using a visitors table)
// Visitors
$visitors_today = $conn->query("SELECT COUNT(*) AS total FROM visitors WHERE DATE(visit_date) = CURDATE()")->fetch_assoc()['total'];
$visitors_month = $conn->query("SELECT COUNT(*) AS total FROM visitors WHERE MONTH(visit_date) = MONTH(CURDATE()) AND YEAR(visit_date) = YEAR(CURDATE())")->fetch_assoc()['total'];
$visitors_year  = $conn->query("SELECT COUNT(*) AS total FROM visitors WHERE YEAR(visit_date) = YEAR(CURDATE())")->fetch_assoc()['total'];
?>

<?php
// Total messages
$total_messages = $conn->query("SELECT COUNT(*) as total FROM messages")->fetch_assoc()['total'];

// Messages today
$today_messages = $conn->query("SELECT COUNT(*) as total FROM messages WHERE DATE(created_at) = CURDATE()")->fetch_assoc()['total'];

// Messages this month
$month_messages = $conn->query("SELECT COUNT(*) as total FROM messages WHERE MONTH(created_at) = MONTH(CURDATE()) AND YEAR(created_at) = YEAR(CURDATE())")->fetch_assoc()['total'];

// Messages this year
$year_messages = $conn->query("SELECT COUNT(*) as total FROM messages WHERE YEAR(created_at) = YEAR(CURDATE())")->fetch_assoc()['total'];
?>

<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>Staff Dashboard | FRAJUU CONNECT</title>
  <meta name="viewport" content="width=device-width, initial-scale=1">
  
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body class="bg-light">

<nav class="navbar navbar-expand-lg navbar-dark bg-primary">
  <div class="container-fluid">
    <a class="navbar-brand fw-bold" href="index.php">FRAJUU CONNECT - Staff</a>
    <div class="d-flex">
      <span class="text-white me-3">Welcome, <?php echo $_SESSION['admin_full_name']; ?></span>
      <a href="logout.php" class="btn btn-danger btn-sm">Logout</a>
    </div>
  </div>
</nav>

<div class="container py-4">
  <h2 class="fw-bold mb-4">Dashboard Overview</h2>
  
  <div class="row g-4">
    <div class="col-md-3">
      <div class="card text-center shadow-sm border-primary">
        <div class="card-body">
          <h5 class="card-title">Agents</h5>
          <p class="display-6 fw-bold text-primary"><?php echo $agents; ?></p>
          <a href="manage_agents.php" class="btn btn-outline-primary btn-sm">Manage Agents</a>
        </div>
      </div>
    </div>
    
    <div class="col-md-3">
      <div class="card text-center shadow-sm border-success">
        <div class="card-body">
          <h5 class="card-title">Total Listings</h5>
          <p class="display-6 fw-bold text-success"><?php echo $total_listings; ?></p>
          <a href="manage_listings.php" class="btn btn-outline-success btn-sm">Manage Listings</a>
        </div>
      </div>
    </div>
    
    <div class="col-md-3">
      <div class="card text-center shadow-sm border-info">
        <div class="card-body">
          <h5 class="card-title">Visitors Today</h5>
          <p class="display-6 fw-bold text-info"><?php echo $visitors_today; ?></p>
          <a href="visitors_report.php" class="btn btn-outline-info btn-sm">View Report</a>
        </div>
      </div>
    </div>
    
    <div class="col-md-3">
      <div class="card text-center shadow-sm border-warning">
        <div class="card-body">
          <h5 class="card-title">Visitors This Month</h5>
          <p class="display-6 fw-bold text-warning"><?php echo $visitors_month; ?></p>
          <a href="visitors_report.php" class="btn btn-outline-warning btn-sm">View Report</a>
        </div>
      </div>
    </div>

<div class="col-md-3">
  <div class="card text-center shadow-sm border-dark">
    <div class="card-body">
      <h5 class="card-title">Visitors This Year</h5>
      <p class="display-6 fw-bold text-dark"><?php echo $visitors_year; ?></p>
      <a href="visitors_report.php" class="btn btn-outline-dark btn-sm">View Report</a>
    </div>
  </div>
</div>
</div>
  
  <h3 class="mt-5">Detailed Breakdown</h3>
  <div class="row g-4 mt-2">
    <div class="col-md-3">
      <div class="card shadow-sm">
        <div class="card-body">
          <h6 class="card-title">Houses for Sale</h6>
          <p class="fw-bold text-dark"><?php echo $houses_sale; ?></p>
        </div>
      </div>
    </div>
    
    <div class="col-md-3">
      <div class="card shadow-sm">
        <div class="card-body">
          <h6 class="card-title">Houses for Rent</h6>
          <p class="fw-bold text-dark"><?php echo $houses_rent; ?></p>
        </div>
      </div>
    </div>
    
    <div class="col-md-3">
      <div class="card shadow-sm">
        <div class="card-body">
          <h6 class="card-title">Rooms for Rent</h6>
          <p class="fw-bold text-dark"><?php echo $rooms_rent; ?></p>
        </div>
      </div>
    </div>
    
    <div class="col-md-3">
      <div class="card shadow-sm">
        <div class="card-body">
          <h6 class="card-title">Plots for Sale</h6>
          <p class="fw-bold text-dark"><?php echo $plots_sale; ?></p>
        </div>
      </div>
    </div>
  </div>

<div class="row g-4 my-4">
    <div class="col-md-3">
        <div class="card text-center shadow-sm">
            <div class="card-body">
                <h5 class="card-title">Total Messages</h5>
                <p class="card-text fs-4 fw-bold"><?php echo $total_messages; ?></p>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card text-center shadow-sm">
            <div class="card-body">
                <h5 class="card-title">Today</h5>
                <p class="card-text fs-4 fw-bold"><?php echo $today_messages; ?></p>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card text-center shadow-sm">
            <div class="card-body">
                <h5 class="card-title">This Month</h5>
                <p class="card-text fs-4 fw-bold"><?php echo $month_messages; ?></p>
            </div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="card text-center shadow-sm">
            <div class="card-body">
                <h5 class="card-title">This Year</h5>
                <p class="card-text fs-4 fw-bold"><?php echo $year_messages; ?></p>
            </div>
        </div>
    </div>
</div>

<?php
$days = 30; // active in the last 30 days

// Active agents
$active_agents = $conn->query("SELECT full_name, email, phone, last_login FROM agents WHERE last_login >= NOW() - INTERVAL $days DAY");

// Inactive agents
$inactive_agents = $conn->query("SELECT full_name, email, phone, last_login FROM agents WHERE last_login < NOW() - INTERVAL $days DAY OR last_login IS NULL");
?>
<div class="row g-4">
  
  <div class="col-md-6">
    <div class="card shadow-sm p-3">
      <h5>Active Agents (last <?php echo $days; ?> days)</h5>
      <h2><?php echo $active_agents->num_rows; ?></h2>
      <?php if($active_agents->num_rows > 0): ?>
        <ul class="list-group list-group-flush mt-3">
          <?php while($agent = $active_agents->fetch_assoc()): ?>
            <li class="list-group-item">
              <strong><?php echo htmlspecialchars($agent['full_name']); ?></strong><br>
              Email: <?php echo htmlspecialchars($agent['email']); ?><br>
              Phone: <?php echo htmlspecialchars($agent['phone']); ?><br>
              Last Login: <?php echo $agent['last_login']; ?>
            </li>
          <?php endwhile; ?>
        </ul>
      <?php else: ?>
        <p class="mt-2">No active agents.</p>
      <?php endif; ?>
    </div>
  </div>

<div class="col-md-6">
    <div class="card shadow-sm p-3">
      <h5>Inactive Agents</h5>
      <h2><?php echo $inactive_agents->num_rows; ?></h2>
      <?php if($inactive_agents->num_rows > 0): ?>
        <ul class="list-group list-group-flush mt-3">
          <?php while($agent = $inactive_agents->fetch_assoc()): ?>
            <li class="list-group-item">
              <strong><?php echo htmlspecialchars($agent['full_name']); ?></strong><br>
              Email: <?php echo htmlspecialchars($agent['email']); ?><br>
              Phone: <?php echo htmlspecialchars($agent['phone']); ?><br>
              Last Login: <?php echo $agent['last_login'] ?? 'Never'; ?>
            </li>
          <?php endwhile; ?>
        </ul>
      <?php else: ?>
        <p class="mt-2">No inactive agents.</p>
      <?php endif; ?>
    </div>
  </div>
</div>

</div>

</body>
</html>