FM / api

/home/techb158/workloadmatch.com/api

Name	Size	Mode	Actions
chat/	-	0755	rm
notifications/	-	0755	rm
reports/	-	0755	rm
routes/	-	0700	rm
teacher/	-	0755	rm
.htaccess	762	0644	edit dl rm
admin.php	33110	0644	edit dl rm
api_functions.php	21474	0644	edit dl rm
Auth.php	4504	0644	edit dl rm
change_status.php	1332	0644	edit dl rm
cors_test.php	184	0644	edit dl rm
Database.php	974	0644	edit dl rm
db_connect.php	623	0644	edit dl rm
forgetpassword.php	7415	0644	edit dl rm
index.php	23932	0644	edit dl rm
logout.php	1167	0644	edit dl rm
psl-config.php	350	0644	edit dl rm
reports_schedule_by_course.php	1287	0644	edit dl rm
reports_schedule_by_group.php	1352	0644	edit dl rm
Response.php	1938	0644	edit dl rm
tasks.php	2993	0644	edit dl rm
teacher_profile.php	1177	0644	edit dl rm
test.php	1113	0644	edit dl rm

Edit: /home/techb158/workloadmatch.com/api/tasks.php (2993B)

<?php
include_once '../includes/db_connect.php';
include_once '../includes/functions.php';
sec_session_start();
header('Content-Type: application/json');

$userId = isset($_SESSION['user_id']) ? (int)$_SESSION['user_id'] : 0;
if (!$userId) {
    echo json_encode(['count' => 0, 'items' => [], 'debug' => 'no user']);
    exit;
}

$user_type = $_GET['user_type'] ?? 'manager';
$items = [];
$totalCount = 0;
$errors = [];

if ($user_type === 'manager') {
    // Unassigned course sessions
    $stmt = $mysqli->prepare("
        SELECT COUNT(DISTINCT CONCAT(scg.Course_ID, '-', scg.Group_ID)) AS task_count
        FROM schedule_course_for_group scg
        JOIN manager_group_name mgn ON mgn.Group_ID = scg.Group_ID
        WHERE scg.Assigned = 0 AND mgn.Manager_ID = ?
    ");
    if ($stmt) {
        $stmt->bind_param("i", $userId);
        if ($stmt->execute()) {
            $r = $stmt->get_result()->fetch_assoc();
            if ($r && (int)$r['task_count'] > 0) {
                $c = (int)$r['task_count'];
                $totalCount += $c;
                $items[] = [
                    'icon' => 'fa fa-user-plus text-yellow',
                    'text' => $c . ' unassigned course' . ($c > 1 ? 's' : ''),
                    'preview' => 'Assign teachers',
                    'link' => 'assign_teacher_manual.php'
                ];
            }
        } else {
            $errors[] = 'tasks1 execute: ' . $stmt->error;
        }
        $stmt->close();
    } else {
        $errors[] = 'tasks1 prepare: ' . $mysqli->error;
    }
} else {
    // Teacher: today's courses
    $today = date('Y-m-d');
    $stmt = $mysqli->prepare("
        SELECT COUNT(*) AS cnt
        FROM schedule_course_for_group scg
        JOIN teacher_course_assignments tca ON tca.Schedule_ID = scg.Schedule_ID
        WHERE tca.Teacher_ID = ? AND scg.Start_Date = ?
    ");
    if ($stmt) {
        $stmt->bind_param("is", $userId, $today);
        if ($stmt->execute()) {
            $r = $stmt->get_result()->fetch_assoc();
            if ($r && (int)$r['cnt'] > 0) {
                $c = (int)$r['cnt'];
                $totalCount += 1;
                $items[] = [
                    'icon' => 'fa fa-calendar-check-o text-green',
                    'text' => $c . ' course' . ($c > 1 ? 's' : '') . ' today',
                    'preview' => 'View schedule',
                    'link' => 'dashboard.php'
                ];
            }
        } else {
            $errors[] = 'tasks2 execute: ' . $stmt->error;
        }
        $stmt->close();
    } else {
        $errors[] = 'tasks2 prepare: ' . $mysqli->error;
    }
}

if (empty($items)) {
    $items[] = [
        'icon' => 'fa fa-check-circle text-green',
        'text' => 'All clear',
        'preview' => '',
        'link' => '#'
    ];
}

echo json_encode(['count' => $totalCount, 'items' => $items, 'debug' => $errors]);
$mysqli->close();

0, 'items' => [], 'debug' => 'no user']); exit; } $user_type = $_GET['user_type'] ?? 'manager'; $items = []; $totalCount = 0; $errors = []; if ($user_type === 'manager') { // Unassigned course sessions $stmt = $mysqli->prepare(" SELECT COUNT(DISTINCT CONCAT(scg.Course_ID, '-', scg.Group_ID)) AS task_count FROM schedule_course_for_group scg JOIN manager_group_name mgn ON mgn.Group_ID = scg.Group_ID WHERE scg.Assigned = 0 AND mgn.Manager_ID = ? "); if ($stmt) { $stmt->bind_param("i", $userId); if ($stmt->execute()) { $r = $stmt->get_result()->fetch_assoc(); if ($r && (int)$r['task_count'] > 0) { $c = (int)$r['task_count']; $totalCount += $c; $items[] = [ 'icon' => 'fa fa-user-plus text-yellow', 'text' => $c . ' unassigned course' . ($c > 1 ? 's' : ''), 'preview' => 'Assign teachers', 'link' => 'assign_teacher_manual.php' ]; } } else { $errors[] = 'tasks1 execute: ' . $stmt->error; } $stmt->close(); } else { $errors[] = 'tasks1 prepare: ' . $mysqli->error; } } else { // Teacher: today's courses $today = date('Y-m-d'); $stmt = $mysqli->prepare(" SELECT COUNT(*) AS cnt FROM schedule_course_for_group scg JOIN teacher_course_assignments tca ON tca.Schedule_ID = scg.Schedule_ID WHERE tca.Teacher_ID = ? AND scg.Start_Date = ? "); if ($stmt) { $stmt->bind_param("is", $userId, $today); if ($stmt->execute()) { $r = $stmt->get_result()->fetch_assoc(); if ($r && (int)$r['cnt'] > 0) { $c = (int)$r['cnt']; $totalCount += 1; $items[] = [ 'icon' => 'fa fa-calendar-check-o text-green', 'text' => $c . ' course' . ($c > 1 ? 's' : '') . ' today', 'preview' => 'View schedule', 'link' => 'dashboard.php' ]; } } else { $errors[] = 'tasks2 execute: ' . $stmt->error; } $stmt->close(); } else { $errors[] = 'tasks2 prepare: ' . $mysqli->error; } } if (empty($items)) { $items[] = [ 'icon' => 'fa fa-check-circle text-green', 'text' => 'All clear', 'preview' => '', 'link' => '#' ]; } echo json_encode(['count' => $totalCount, 'items' => $items, 'debug' => $errors]); $mysqli->close();