1#@!#!123s

: / home / schoolcampuserp / erp.bnninternationalschool.com / api / app_api /
Filename : send_fees.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    if(isset($_POST["id"])) {
        $id = $_POST["id"];
        $studentFeesMasterId = $_POST["student_fees_master_id"];
        $feeGroupsFeeTypeId = $_POST["fee_groups_feetype_id"];
        $newAmountDetails = $_POST["amount_details"];

        // Fetch existing amount_details
        $selectQuery = "SELECT `amount_detail` FROM `student_fees_deposite` WHERE `id` = $id AND `student_fees_master_id` = '$studentFeesMasterId' AND `fee_groups_feetype_id` = '$feeGroupsFeeTypeId'";
        $result = $con->query($selectQuery);
        
        if ($result && $row = $result->fetch_assoc()) {
            // Get existing amount_details
            $existingAmountDetails = json_decode($row['amount_detail'], true);

            // Append new amount_details
            $existingAmountDetails[] = json_decode($newAmountDetails, true);

            // Update the row with the updated amount_details
            $updateQuery = "UPDATE `student_fees_deposite` SET 
                            `amount_detail` = '" . json_encode($existingAmountDetails) . "',
                            `created_at` = CURRENT_TIMESTAMP
                            WHERE `id` = $id AND `student_fees_master_id` = '$studentFeesMasterId' AND
                            `fee_groups_feetype_id` = '$feeGroupsFeeTypeId'";
            $updateResult = $con->query($updateQuery);

            if ($updateResult === true) {
                $response = array("status" => "1", "message" => "New amount details added successfully");
            } else {
                $response = array("status" => "0", "message" => "Failed to add new amount details: " . $con->error);
            }
        } else {
            // Insert new data when no record is found with the provided ID
            $insertQuery ="INSERT INTO `student_fees_deposite` 
                    (`id`, `student_fees_master_id`, `fee_groups_feetype_id`, `amount_detail`, `is_active`, `created_at`) 
                    VALUES 
                    (NULL, $studentFeesMasterId, $feeGroupsFeeTypeId,'$newAmountDetails' , 'no', CURRENT_TIMESTAMP)";
            $insertResult = $con->query($insertQuery);

            if ($insertResult === true) {
                $response = array("status" => "1", "message" => "New record inserted successfully");
            } else {
                $response = array("status" => "0", "message" => "Failed to insert new record: " . $con->error);
            }
        }
    } else {
        $response = array("status" => "0", "message" => "ID not provided in the request.");
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request method. Please use POST.");
}

echo json_encode($response);
?>