View Code - 20260722

quality_by_machine.php | 20260722_120325.php Initial Domain Snapshot

<?php
/* ============================================================
   QUALITY AUTO-FILL FROM loom_quality_master
   ============================================================ */
header('Content-Type: application/json; charset=utf-8');
ini_set('display_errors','0'); error_reporting(EALL);

require __DIR__ . '/../modules/auth/auth.php';
require_login();
$u=auth_user(); $company_id=(int)$u['company_id'];

try{
  if(!isset($GLOBALS['pdo']) || !$GLOBALS['pdo']) require __DIR__ . '/../core/db.php';
  /** @var PDO $pdo */ $pdo=$GLOBALS['pdo']; $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

$machine_no = isset($_GET['machine_no']) ? (int)$_GET['machine_no'] : 0;
  if($machine_no<=0){ echo json_encode(['ok'=>false,'msg'=>'Missing machine_no']); exit; }

// prefer machine_code like 'loom 036', else machine_id column if available
  $code = sprintf('loom %03d',$machine_no);
  $s=$pdo->prepare("SELECT quality, quality_pasaria, pasaria_date
                      FROM loom_quality_master
                     WHERE company_id=? AND (machine_code=? OR machine_id=?)
                  ORDER BY updated_at DESC, id DESC LIMIT 1");
  $s->execute([$company_id,$code,$machine_no]);

if($row=$s->fetch(PDO::FETCH_ASSOC)){ echo json_encode(['ok'=>true]+$row); }
  else { echo json_encode(['ok'=>false,'msg'=>'Quality not found']); }

}catch(Throwable $e){
  http_response_code(500); echo json_encode(['ok'=>false,'msg'=>'Server error','detail'=>$e->getMessage()]);
}