View Code - 20260721

ajax_yarn.php | 20260721_154032.php Initial Bulk Import

<?php
require_once __DIR__ . '/../modules/auth/page_acl.php';
$ctx = page_require_access(null, ['json'=>true]);

$pdo = $ctx['pdo'];
$cid = (int)$ctx['company_id'];

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

$act = $_GET['act'] ?? '';

if($act==='stock'){
  $q=$pdo->prepare("SELECT DISTINCT stock_type FROM yarn_company_data WHERE company_id=? ORDER BY stock_type");
  $q->execute([$cid]);
  echo json_encode($q->fetchAll(PDO::FETCH_COLUMN));
  exit;
}

if($act==='yarn'){
  $q=$pdo->prepare("SELECT DISTINCT yarn_types FROM yarn_company_data WHERE company_id=? AND stock_type=? ORDER BY yarn_types");
  $q->execute([$cid,$_GET['stock']??'']);
  echo json_encode($q->fetchAll(PDO::FETCH_COLUMN));
  exit;
}

if($act==='denier'){
  $q=$pdo->prepare("SELECT DISTINCT denier FROM yarn_company_data WHERE company_id=? AND stock_type=? AND yarn_types=? ORDER BY denier");
  $q->execute([$cid,$_GET['stock']??'',$_GET['yarn']??'']);
  echo json_encode($q->fetchAll(PDO::FETCH_COLUMN));
  exit;
}

if($act==='color'){
  $q=$pdo->prepare("SELECT DISTINCT color FROM yarn_company_data WHERE company_id=? AND stock_type=? AND yarn_types=? AND denier=? ORDER BY color");
  $q->execute([$cid,$_GET['stock']??'',$_GET['yarn']??'',$_GET['denier']??'']);
  echo json_encode($q->fetchAll(PDO::FETCH_COLUMN));
  exit;
}

echo json_encode([]);