1#@!#!123s

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

// Check if student_session_id is received via POST
if (isset($_POST['student_session_id'])) {
    $studentSessionId = $_POST['student_session_id'];

    $query = "SELECT student_session.id, student_session.student_id, students.miscellaneous_id_1, students.miscellaneous_id_2, students.miscellaneous_id_3, students.miscellaneous_id_4, students.miscellaneous_fees, students.route_id, students.route_fees, students.hostel_fees, students.vehroute_id, students.hostel_room_id, students.hostel_id, SUM(CASE WHEN students.miscellaneous_id_1 = 0 AND students.miscellaneous_id_2 = 0 AND students.miscellaneous_id_3 = 0 AND students.miscellaneous_id_4 = 0 AND students.miscellaneous_fees = 0 THEN NULL ELSE fee_miscellaneous.fare END) AS MFfare, GROUP_CONCAT( CONCAT( CASE WHEN students.miscellaneous_id_1 = 0 AND students.miscellaneous_id_2 = 0 AND students.miscellaneous_id_3 = 0 AND students.miscellaneous_id_4 = 0 AND students.miscellaneous_fees = 0 THEN NULL ELSE fee_miscellaneous.fare END ) SEPARATOR '= ' ) AS concatenated_miscellaneous_fees, GROUP_CONCAT( CONCAT( CASE WHEN students.miscellaneous_id_1 = 0 AND students.miscellaneous_id_2 = 0 AND students.miscellaneous_id_3 = 0 AND students.miscellaneous_id_4 = 0 AND students.miscellaneous_fees = 0 THEN NULL ELSE fee_miscellaneous.miscellaneous_months END ) SEPARATOR '= ' ) AS concatenated_miscellaneous_months FROM student_session JOIN students ON students.id = student_session.student_id LEFT JOIN fee_miscellaneous ON ( fee_miscellaneous.id IN ( students.miscellaneous_id_1, students.miscellaneous_id_2, students.miscellaneous_id_3, students.miscellaneous_id_4 ) AND NOT ( students.miscellaneous_id_1 = 0 AND students.miscellaneous_id_2 = 0 AND students.miscellaneous_id_3 = 0 AND students.miscellaneous_id_4 = 0 ) ) WHERE student_session.id = '$studentSessionId' ";
    $result = $con->query($query);
    $row = $result->fetch_all(MYSQLI_ASSOC);

    if (empty($row)) {
        $response = array("status" => "0", "message" => "No records found for the student_session_id", "miscellaneous" => $row);
    } else {
        $response = array("status" => "1", "message" => "Data retrieved successfully", "miscellaneous" => $row);
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request. Please provide a student_session_id via POST.");
}

echo json_encode($response);

?>