prepare($query); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); $user = $result->fetch_assoc(); $stmt->close(); // Check if user exists and has proper permissions // Uncomment and adjust based on your role requirements // if (!$user || $user['role'] !== 'manager') { // header("Location: unauthorized.php"); // exit(); // } ?> CRM | rutzo Admin Dashboard
  2. CRM
  3. CRM

Manager Dashboard

Total Employees

prepare($emp_query); $stmt->execute(); $emp_result = $stmt->get_result(); if ($emp_result) { echo htmlspecialchars($emp_result->fetch_assoc()['total']); $stmt->close(); } else { echo "Error: " . $conn->error . ""; } ?>

Active Staff

Online Now

prepare($on_query); $stmt->execute(); $on_result = $stmt->get_result(); if ($on_result) { echo htmlspecialchars($on_result->fetch_assoc()['total']); $stmt->close(); } else { echo "Error: " . $conn->error . ""; } ?>

Live Status

Pending Tasks

prepare($task_query); $stmt->execute(); $task_result = $stmt->get_result(); if ($task_result) { echo htmlspecialchars($task_result->fetch_assoc()['total']); $stmt->close(); } else { echo "Error: " . $conn->error . ""; } ?>

Task Queue

Leave Requests

prepare($leave_query); $stmt->execute(); $leave_result = $stmt->get_result(); if ($leave_result) { echo htmlspecialchars($leave_result->fetch_assoc()['total']); $stmt->close(); } else { echo "Error: " . $conn->error . ""; } ?>

Needs Approval

Employee Overview
prepare($emp_query); $stmt->execute(); $emp_result = $stmt->get_result(); if ($emp_result && $emp_result->num_rows > 0) { while ($row = $emp_result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } else { echo ""; } $stmt->close(); ?>
Name Email Role Status
" . htmlspecialchars($row['name'] ?? 'N/A') . "" . htmlspecialchars($row['email'] ?? 'N/A') . "" . htmlspecialchars($row['role'] ?? 'N/A') . "" . htmlspecialchars($row['status'] ?? 'N/A') . "
No employees found
Online Staff
prepare($on_query); $stmt->execute(); $on_result = $stmt->get_result(); if ($on_result && $on_result->num_rows > 0) { while ($row = $on_result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; } } else { echo ""; } $stmt->close(); ?>
User ID Status Last Active
" . htmlspecialchars($row['user_id'] ?? 'N/A') . "" . htmlspecialchars($row['status'] ?? 'N/A') . "" . htmlspecialchars($row['last_seen'] ?? 'N/A') . "
No online staff
Pending Tasks
prepare($task_query); $stmt->execute(); $task_result = $stmt->get_result(); if ($task_result && $task_result->num_rows > 0) { while ($row = $task_result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; } } else { echo ""; } $stmt->close(); ?>
Task Name Assigned To Due Date
" . htmlspecialchars($row['task_name'] ?? 'N/A') . "" . htmlspecialchars($row['assigned_to'] ?? 'N/A') . "" . htmlspecialchars($row['due_date'] ?? 'N/A') . "
No pending tasks
Leave Requests
prepare($leave_query); $stmt->execute(); $leave_result = $stmt->get_result(); if ($leave_result && $leave_result->num_rows > 0) { while ($row = $leave_result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } else { echo ""; } $stmt->close(); ?>
Employee Name Reason Start Date End Date Status
" . htmlspecialchars($row['name'] ?? 'N/A') . "" . htmlspecialchars($row['reason'] ?? 'N/A') . "" . htmlspecialchars($row['start_date'] ?? 'N/A') . "" . htmlspecialchars($row['end_date'] ?? 'N/A') . "" . htmlspecialchars($row['status'] ?? 'N/A') . "
No pending leave requests
// Example: