1#@!#!123s

: / home / schoolcampuserp / bmsnrajganj.in / erp / api / app_api /
Filename : get_homework_report.php
back
<?php
include 'connection.php';

// Check if class_id, session_id, and section_id are received via POST
if (isset($_POST['session_id'])&& isset($_POST['staff_id']) && isset($_POST['role_id']) && isset($_POST['class_id']) && isset($_POST['section_id'])) {
    $sessionId = $_POST['session_id'];
    $staffId = $_POST['staff_id'];
    $roleId= $_POST['role_id'];
    $classId= $_POST['class_id'];
    $sectionId= $_POST['section_id'];
    

    // Prepare the query to fetch homework data
    if($roleId ==7  ){
        $query = "SELECT* FROM homework 
        WHERE session_id= '$sessionId' && class_id= '$classId' && section_id= '$sectionId'";
    }else{
    $query = "SELECT * FROM homework
    WHERE session_id = '$sessionId' && staff_id= '$staffId' && class_id= '$classId' && section_id= '$sectionId'";
    }
    
    $result = $con->query($query);

    if ($result) {
        if ($result->num_rows > 0) {
            $homeworkData = array();

            while ($homework = $result->fetch_assoc()) {
                $subject_group_subject_id = $homework['subject_group_subject_id'];

                // Fetch subject name from subjects table using subject_id
                $subjectQuery = "SELECT subject_group_subjects.id, subjects.name 
                FROM subject_group_subjects
                JOIN subjects ON subject_group_subjects.subject_id = subjects.id
                WHERE subject_group_subjects.id = '$subject_group_subject_id'";
                $subjectResult = $con->query($subjectQuery);

                if ($subjectResult) {
                    $subjectData = $subjectResult->fetch_assoc();

                    // Add the subject name to the homework data
                    $homework['subject_name'] = $subjectData['name'];

                    $homeworkData[] = $homework;
                } else {
                    // Handle SQL error if needed
                    $response = array("status" => "0", "message" => "Error fetching subject data: " . $con->error);
                    echo json_encode($response);
                    exit;
                }
            }

            $response = array("status" => "1", "message" => "Data retrieved successfully", "homework" => $homeworkData);
        } else {
            $response = array("status" => "0", "message" => "No records found for the provided details", "homework" => []);
        }
    } else {
        // Handle SQL error if needed
        $response = array("status" => "0", "message" => "Error executing query: " . $con->error);
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request. Please provide class_id, session_id, and section_id via POST.");
}

echo json_encode($response);
?>