1#@!#!123s

: / home / schoolcampuserp / srinfinityschool.in / api / app_api /
Filename : get_receipt_no.php
back
<?php
include 'connection.php';

header('Content-Type: application/json');

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    echo json_encode(["status" => "0", "message" => "Invalid request method"]);
    exit;
}

if (!isset($_POST['student_fees_deposite_id'])) {
    echo json_encode(["status" => "0", "message" => "Missing student_fees_deposite_id"]);
    exit;
}

$depositId = trim($_POST['student_fees_deposite_id']);

if (!ctype_digit($depositId)) {
    echo json_encode(["status" => "0", "message" => "Invalid deposit id"]);
    exit;
}

/*
 MATCH RULES (STRICT):
 1. Exact start
 2. Exact middle
 3. Exact end
 4. Single month (/1)
*/

$sql = "
SELECT id
FROM fee_receipt_no
WHERE
    payment_id = CONCAT(?, '/1')
    OR payment_id LIKE CONCAT(?, '/1-%')
    OR payment_id LIKE CONCAT('%-', ?, '/1-%')
    OR payment_id LIKE CONCAT('%-', ?, '/1')
LIMIT 1
";

$stmt = $con->prepare($sql);

if (!$stmt) {
    echo json_encode(["status" => "0", "message" => "Prepare failed"]);
    exit;
}

$stmt->bind_param(
    "ssss",
    $depositId,
    $depositId,
    $depositId,
    $depositId
);

$stmt->execute();
$result = $stmt->get_result();

if ($row = $result->fetch_assoc()) {
    echo json_encode([
        "status" => "1",
        "message" => "Receipt found",
        "receipt_id" => $row['id']
    ]);
} else {
    echo json_encode([
        "status" => "0",
        "message" => "Receipt not found"
    ]);
}

$stmt->close();
$con->close();