View Code - 20260722

save_loom_quality_yarn.php | 20260722_120325.php Initial Domain Snapshot

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

$pdo = $ctx['pdo'];
$cid = (int)$ctx['company_id'];
$user_id = (int)($ctx['user']['id'] ?? 0);

$data = json_decode(file_get_contents('php://input'), true);

$pdo->beginTransaction();

if(empty($data['quality_id']) && !empty($data['new_name'])){
  $q=$pdo->prepare("INSERT INTO loom_quality_data (cid,name,short_name) VALUES (?,?,?)");
  $q->execute([$cid,$data['new_name'],$data['short_name']]);
  $quality_id=$pdo->lastInsertId();
}else{
  $quality_id=(int)$data['quality_id'];
}

$ins=$pdo->prepare("INSERT INTO loom_quality_yarn_data (cid,loom_quality_id,yarn_name,gram_per_meter) VALUES (?,?,?,?)");

$saved_rows = 0;

foreach($data['rows'] as $r){
  if(!$r['gram']) continue;
  $name=$r['yarn'].' '.$r['denier'].' '.$r['color'];
  $ins->execute([$cid,$quality_id,$name,$r['gram']]);
  $saved_rows++;
}

$pdo->commit();

activity_log([
  'company_id'  => $cid,
  'user_id'     => $user_id,
  'module'      => 'loom',
  'action_name' => 'create',
  'entity_type' => 'loom_quality_yarn_data',
  'entity_id'   => (int)$quality_id,
  'remarks'     => 'Saved loom quality yarn rows: ' . $saved_rows
]);

echo json_encode(['ok'=>1,'msg'=>'Saved successfully']);