/home/techb158/workloadmatch.com/Master
| Name | Size | Mode | Actions |
|---|---|---|---|
| addgroup.php | 6908 | 0644 | editdlrm |
| addmanager.php | 14495 | 0644 | editdlrm |
| adduser.php | 11148 | 0644 | editdlrm |
| assign_teacher_manual.php | 3879 | 0644 | editdlrm |
| chat.php | 16850 | 0644 | editdlrm |
| dashboard.php | 13677 | 0644 | editdlrm |
| fetch_teacher_prefrence_courses.php | 1887 | 0644 | editdlrm |
| inc.php | 551 | 0644 | editdlrm |
| Lockup_to_Assign.php | 3662 | 0644 | editdlrm |
| main-header-inc.php | 1276 | 0644 | editdlrm |
| main-header.php | 15374 | 0644 | editdlrm |
| preference_accounting.php | 9416 | 0644 | editdlrm |
| preference_secretarial.php | 9416 | 0644 | editdlrm |
| profile.php | 17094 | 0644 | editdlrm |
| profile_bak.php.disabled | 3195 | 0644 | editdlrm |
| save_teacher_preference.php | 2107 | 0644 | editdlrm |
| set_manager.php | 1305 | 0644 | editdlrm |
| teacher_absence.php | 305 | 0644 | editdlrm |
| teacher_preference.php | 3798 | 0644 | editdlrm |
| teacher_preference_by_course.php | 3833 | 0644 | editdlrm |
Edit:
prepare("SELECT Admin_ID FROM master_profile WHERE Master_ID = ?");
$q->bind_param("s", $master_id);
$q->execute();
$q->bind_result($Admin_ID);
$q->fetch();
$q->close();
// Ensure manager_profile has last_activity column
$chk = $mysqli->query("SELECT COUNT(*) AS cnt FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '" . DATABASE . "' AND TABLE_NAME = 'manager_profile' AND COLUMN_NAME = 'last_activity'");
if ($chk) { $r = $chk->fetch_assoc(); if ((int)$r['cnt'] === 0) $mysqli->query("ALTER TABLE manager_profile ADD COLUMN last_activity DATETIME DEFAULT NULL"); }
$managers = [];
$stmt = $mysqli->prepare("
SELECT mp.Manager_ID, CONCAT(mp.First_Name, ' ', mp.Last_Name) AS name, COALESCE(mp.User_Img, 'avatar.png') AS User_Img,
CASE WHEN mp.last_activity IS NOT NULL AND mp.last_activity >= NOW() - INTERVAL 5 MINUTE THEN 'Online' ELSE 'Offline' END AS status_txt,
(SELECT COUNT(*) FROM chat_messages WHERE receiver_id = ? AND receiver_type = 'master' AND sender_id = mp.Manager_ID AND is_read = 0) AS unread,
(SELECT message FROM chat_messages WHERE (sender_id = ? AND sender_type = 'master' AND receiver_id = mp.Manager_ID) OR (sender_id = mp.Manager_ID AND sender_type = 'manager' AND receiver_id = ?) ORDER BY created_at DESC LIMIT 1) AS last_msg,
(SELECT created_at FROM chat_messages WHERE (sender_id = ? AND sender_type = 'master' AND receiver_id = mp.Manager_ID) OR (sender_id = mp.Manager_ID AND sender_type = 'manager' AND receiver_id = ?) ORDER BY created_at DESC LIMIT 1) AS last_msg_time
FROM manager_profile mp
WHERE mp.Admin_ID = ?
ORDER BY last_msg_time DESC
");
$stmt->bind_param("iiiiis", $master_id, $master_id, $master_id, $master_id, $master_id, $Admin_ID);
$stmt->execute();
$res = $stmt->get_result();
while ($row = $res->fetch_assoc()) {
$row['unread'] = (int)$row['unread'];
$managers[] = $row;
}
$stmt->close();
$totalUnread = 0;
foreach ($managers as $m) { $totalUnread += $m['unread']; }
function timeAgo($dt) {
if (!$dt) return '';
$ts = strtotime($dt);
$diff = time() - $ts;
if ($diff < 60) return 'now';
if ($diff < 3600) return floor($diff / 60) . 'm';
if ($diff < 86400) return floor($diff / 3600) . 'h';
if ($diff < 172800) return 'yesterday';
return date('M d', $ts);
}
?>
/home/techb158/workloadmatch.com/Master/chat.php (16850B)
Managers 0): ?>
40 ? mb_substr($m['last_msg'], 0, 40) . '...' : $m['last_msg']) : 'No messages yet';
$previewTime = timeAgo($m['last_msg_time']);
?>
; ?>)
0): ?>
Select a manager to start chatting
Select a manager to view messages