MAINHACK

Viewing / Editing File: api_printable_timetable.php

<?php
header("Content-Type: application/json");
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: GET");

include("../functions.php");

// 1. GET PARAMETERS
$school_code = $_GET['s_code'] 
    ?? $_GET['school_code'] 
    ?? $_SESSION['myschoolcode'] 
    ?? '';

$semester = $_GET['semester'] ?? '';

if (!$school_code || !$semester) {
    echo json_encode([
        "status" => "error",
        "message" => "Missing required parameters: s_code, semester"
    ]);
    exit();
}

/*
|--------------------------------------------------------------------------
| TIME SLOTS (10AM - 5PM)
|--------------------------------------------------------------------------
*/
$start = new DateTime('10:00 AM');
$end   = new DateTime('05:00 PM');
$timeSlots = [];

while ($start < $end) {
    $current = $start->format('h:i A');
    $start->modify('+60 minutes');
    $next = $start->format('h:i A');
    $timeSlots[] = "$current - $next";
}

/*
|--------------------------------------------------------------------------
| SCHOOL INFO
|--------------------------------------------------------------------------
*/
$stmt = $con->prepare("SELECT school_name FROM schools WHERE school_code = ? LIMIT 1");
$stmt->execute([$school_code]);
$row = $stmt->fetch();
$school_name = $row['school_name'] ?? "";

/*
|--------------------------------------------------------------------------
| ACADEMIC YEAR
|--------------------------------------------------------------------------
*/
$stmt2 = $con->prepare("SELECT academic_year FROM admission_info WHERE s_code = ? LIMIT 1");
$stmt2->execute([$school_code]);
$year = $stmt2->fetch();
$academic_year = $year['academic_year'] ?? "";

/*
|--------------------------------------------------------------------------
| FETCH TIMETABLE FILTERED BY SEMESTER
|--------------------------------------------------------------------------
*/
$q = $new->prepare("
    SELECT * FROM timetable1
    WHERE s_code = ? 
      AND semester = ?
");
$q->bind_param("ss", $school_code, $semester);
$q->execute();
$result = $q->get_result();

$timetable = [];
while ($r = $result->fetch_assoc()) {
    $timetable[$r['day']][$r['time_slot']] = [
        "course_id" => $r['course'],
        "room_id" => $r['room'],
        "teacher_id" => $r['teacher'],
        "is_break_time" => (int)$r['is_break_time']
    ];
}

/*
|--------------------------------------------------------------------------
| COURSE, ROOM, TEACHER NAMES
|--------------------------------------------------------------------------
*/
$courses = $new->query("SELECT cid, class_name FROM class WHERE s_code='$school_code'")
               ->fetch_all(MYSQLI_ASSOC);

$rooms = $new->query("SELECT id, name FROM room WHERE s_code='$school_code'")
             ->fetch_all(MYSQLI_ASSOC);

$teachers = $new->query("SELECT id, user_name FROM schools WHERE school_code='$school_code' AND user_name!='Admin'")
                ->fetch_all(MYSQLI_ASSOC);

function getName($id, $array, $idField, $nameField) {
    foreach ($array as $a) {
        if ($a[$idField] == $id) return $a[$nameField];
    }
    return null;
}

/*
|--------------------------------------------------------------------------
| FINAL DATA BUILD
|--------------------------------------------------------------------------
*/
$days = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday"];
$final = [];

foreach ($days as $day) {
    $slots = [];

foreach ($timeSlots as $slot) {
        $cell = $timetable[$day][$slot] ?? null;

if ($cell && $cell['is_break_time'] == 1) {
            $slots[] = [
                "time_slot" => $slot,
                "type" => "break",
                "label" => "Break Time"
            ];
        } else {
            $slots[] = [
                "time_slot" => $slot,
                "type" => "class",
                "course" => getName($cell['course_id'] ?? null, $courses, "cid", "class_name") ?? "Free Period",
                "room" => getName($cell['room_id'] ?? null, $rooms, "id", "name") ?? "",
                "teacher" => getName($cell['teacher_id'] ?? null, $teachers, "id", "user_name") ?? ""
            ];
        }
    }

$final[] = [
        "day" => $day,
        "slots" => $slots
    ];
}

/*
|--------------------------------------------------------------------------
| RESPONSE
|--------------------------------------------------------------------------
*/
echo json_encode([
    "status" => "success",
    "school_code" => $school_code,
    "school_name" => $school_name,
    "semester" => $semester,
    "academic_year" => $academic_year,
    "time_slots" => $timeSlots,
    "timetable" => $final
], JSON_PRETTY_PRINT);
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: api_printable_timetable.php

Server Info

System Features

User Info