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/reports_schedule_by_group.php (1352B)

<?php
header('Content-Type: application/json');

include_once '../includes/db_connect.php';
include_once '../includes/functions.php';

sec_session_start();

if (!isset($_SESSION['user_id'])) {
    http_response_code(401);
    echo json_encode(["status" => "error", "message" => "Unauthorized"]);
    exit();
}

$user_id = $_SESSION['user_id'];
$UserDB = $_SESSION['UserDB'];

// Fetch schedule grouped by group for the logged-in manager
$query = "
    SELECT 
        MGN.Group_Name,
        COUNT(TCA.Teacher_Course_ID) AS AssignmentCount,
        GROUP_CONCAT(DISTINCT TP.F_Name, ' ', TP.L_Name SEPARATOR ', ') AS Teachers
    FROM teacher_course_assignments TCA
    JOIN Courses C ON TCA.Course_ID = C.Course_ID
    JOIN teacher_profile TP ON TCA.Teacher_ID = TP.Teacher_ID
    JOIN manager_group_name MGN ON TP.Group_ID = MGN.Group_ID
    WHERE TP.Manager_ID = ?
    GROUP BY MGN.Group_ID
    ORDER BY MGN.Group_Name
";

if ($stmt = $mysqli->prepare($query)) {
    $stmt->bind_param("s", $user_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $data = $result->fetch_all(MYSQLI_ASSOC);
    $stmt->close();

echo json_encode(["status" => "success", "data" => $data]);
} else {
    http_response_code(500);
    echo json_encode(["status" => "error", "message" => "Database error."]);
}

"error", "message" => "Unauthorized"]); exit(); } $user_id = $_SESSION['user_id']; $UserDB = $_SESSION['UserDB']; // Fetch schedule grouped by group for the logged-in manager $query = " SELECT MGN.Group_Name, COUNT(TCA.Teacher_Course_ID) AS AssignmentCount, GROUP_CONCAT(DISTINCT TP.F_Name, ' ', TP.L_Name SEPARATOR ', ') AS Teachers FROM teacher_course_assignments TCA JOIN Courses C ON TCA.Course_ID = C.Course_ID JOIN teacher_profile TP ON TCA.Teacher_ID = TP.Teacher_ID JOIN manager_group_name MGN ON TP.Group_ID = MGN.Group_ID WHERE TP.Manager_ID = ? GROUP BY MGN.Group_ID ORDER BY MGN.Group_Name "; if ($stmt = $mysqli->prepare($query)) { $stmt->bind_param("s", $user_id); $stmt->execute(); $result = $stmt->get_result(); $data = $result->fetch_all(MYSQLI_ASSOC); $stmt->close(); echo json_encode(["status" => "success", "data" => $data]); } else { http_response_code(500); echo json_encode(["status" => "error", "message" => "Database error."]); }