« Back to History
jobwork_item_options.php
|
20260721_154032.php
Initial Bulk Import
Copy Code
<?php require_once __DIR__ . '/../modules/auth/page_acl.php'; $ctx = page_require_access('jobwork_send'); $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; header('Content-Type: application/json'); $stockType = $_GET['type'] ?? ''; if ($stockType === '') { echo json_encode([]); exit; } $sql = " SELECT yarn_types AS yarn_type, company_name AS company, denier, color FROM yarn_company_data WHERE company_id = :cid AND stock_type = :st ORDER BY yarn_types, company_name, denier, color "; $st = $pdo->prepare($sql); $st->execute([ ':cid' => $company_id, ':st' => $stockType ]); echo json_encode($st->fetchAll(PDO::FETCH_ASSOC)); exit;