fatch_challan_no_for_kits_issue.php

<?php
include './include/check_login.php';
include './include/connection.php';
include_once 'include/admin-main.php';

// Check if the necessary parameter (stitcher) is set
if (isset($_GET['stitcher'])) {
    $selectedStitcher = mysqli_real_escape_string($con, $_GET['stitcher']);

    // Check if the date range is provided
    if (isset($_GET['from_date'], $_GET['to_date'])) {
        $fromDate = mysqli_real_escape_string($con, $_GET['from_date']);
        $toDate = mysqli_real_escape_string($con, $_GET['to_date']);
        // Fetch the distinct challan numbers based on the selected stitcher and date range
        $query = "SELECT DISTINCT challan_no FROM kits_issue WHERE stitcher_name = '$selectedStitcher' AND date_and_time BETWEEN '$fromDate' AND '$toDate'";
    } else {
        // Fetch the distinct challan numbers based on the selected stitcher without considering date range
        $query = "SELECT DISTINCT challan_no FROM kits_issue WHERE stitcher_name = '$selectedStitcher'";
    }

    $result = mysqli_query($con, $query);

    if ($result) {
        $challanNumbers = array();
        while ($row = mysqli_fetch_assoc($result)) { 
            $challanNumbers[] = $row['challan_no'];
        }
        // Output the array of challan numbers as JSON
        echo json_encode($challanNumbers);
    } else {
        // Handle database query error
        echo "Error: " . mysqli_error($con);
    }
} else {
    // Handle missing parameter
    echo "Missing parameter: stitcher";
}
?>