1#@!#!123s

: / home / schoolcampuserp / erp.bethelschool.co.in / api / app_api /
Filename : get_teacher_timetables.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $staff_id = $_POST["staff_id"];
    
    $query = "SELECT
    st.day,
    `c`.`class`,
    `s`.`section`,
    `cs`.`id` AS `class_section_id`, 
    `sgcs`.`id` AS `subject_group_class_section_id`,
    `sub`.`name` AS `subject_name`,
    `st`.`subject_group_subject_id`,
    st.time_from, 
    st.time_to, 
    st.room_no, 
    st.staff_id
FROM 
    `subject_timetable` AS `st`
INNER JOIN 
    `classes` AS `c` ON `c`.`id` = `st`.`class_id`
INNER JOIN 
    `sections` AS `s` ON `s`.`id` = `st`.`section_id`
INNER JOIN 
    `class_sections` AS `cs` ON `cs`.`class_id` = `c`.`id` AND `cs`.`section_id` = `s`.`id` -- Joining class_sections table
INNER JOIN
    `subject_group_class_sections` AS `sgcs` ON `sgcs`.`class_section_id` = `cs`.`id` -- Joining subject_group_class_sections table
INNER JOIN 
    `subject_group_subjects` AS `sgs` ON `sgs`.`id` = `st`.`subject_group_subject_id`
INNER JOIN 
    `subjects` AS `sub` ON `sub`.`id` = `sgs`.`subject_id`
WHERE 
    `st`.`staff_id` = $staff_id
    
ORDER BY 
    `st`.`id` ASC";
    
    $result = $con->query($query);

    if ($result && $result->num_rows > 0) {
        $itemData = $result->fetch_all(MYSQLI_ASSOC);
        $response = array("status" => "1", "message" => "Matching items retrieved successfully", "data" => $itemData);
    } else {
        $response = array("status" => "0", "message" => "No matching items found");
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request method. Please use POST.");
}

echo json_encode($response);
?>