View Code - 20260721

jobwork_ajax.php | 20260721_154032.php Initial Bulk Import

<?php
// ... Auth & PDO Connection ...

$ajax = $_GET['ajax'] ?? '';
$material = $_GET['material'] ?? ''; // Yarn, TFO, etc.
$level = $_GET['level'] ?? '';

if ($ajax === 'get_options') {
    try {
        if ($level === 'yarn_type') {
            $sql = "SELECT DISTINCT TRIM(yarn_types) as v FROM yarn_company_data WHERE company_id = ? AND stock_type = ? ORDER BY v";
            $params = [$company_id, $material];
        } 
        elseif ($level === 'company_name') {
            $sql = "SELECT DISTINCT TRIM(company_name) as v FROM yarn_company_data WHERE company_id = ? AND stock_type = ? AND yarn_types = ? ORDER BY v";
            $params = [$company_id, $material, $_GET['yarn_type']];
        }
        elseif ($level === 'denier') {
            $sql = "SELECT DISTINCT TRIM(denier) as v FROM yarn_company_data WHERE company_id = ? AND stock_type = ? AND yarn_types = ? AND company_name = ? ORDER BY v";
            $params = [$company_id, $material, $_GET['yarn_type'], $_GET['company_name']];
        }
        elseif ($level === 'color') {
            $sql = "SELECT DISTINCT TRIM(color) as v FROM yarn_company_data WHERE company_id = ? AND stock_type = ? AND yarn_types = ? AND company_name = ? AND denier = ? ORDER BY v";
            $params = [$company_id, $material, $_GET['yarn_type'], $_GET['company_name'], $_GET['denier']];
        }

$st = $pdo->prepare($sql);
        $st->execute($params);
        echo json_encode(['ok' => true, 'data' => ['options' => $st->fetchAll(PDO::FETCH_COLUMN)]]);
    } catch (Exception $e) { echo json_encode(['ok' => false, 'msg' => $e->getMessage()]); }
    exit;
}