« Back to History
jobwork_api.php
|
20260723_000646.php
Initial Domain Snapshot
Copy Code
<?php // Note: $ctx and $pdo are provided by the including file or via separate auth check function getJobworkOptions($pdo, $company_id, $type, $params) { if ($type === 'material_data') { $m = $params['material'] ?? 'yarn'; // Yarn Entry logic for dropdowns $stmt = $pdo->prepare("SELECT DISTINCT company_name FROM yarn_company_data WHERE company_id = ? AND type = ? ORDER BY company_name"); $stmt->execute([$company_id, $m]); return $stmt->fetchAll(PDO::FETCH_COLUMN); } if ($type === 'stock_check') { // Logic for checking existing stock before send $stmt = $pdo->prepare("SELECT SUM(in_qty - out_qty) as balance FROM yarn_stock_table WHERE company_id = ? AND item_id = ?"); $stmt->execute([$company_id, $params['item_id']]); return $stmt->fetch(PDO::FETCH_ASSOC); } } ?>