View Code - 20260722

kasab_entry_insert.php | 20260722_120325.php Initial Domain Snapshot

<?php
require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('kasab_entry_add');

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

if (($_GET['action'] ?? '') === 'list') {
  $q = $pdo->prepare("
    SELECT
      k.id,
      k.entry_date,
      k.roll_type,
      k.color,
      JSON_EXTRACT(k.rolls_json,'$.rolls') AS rolls,
      JSON_EXTRACT(k.weight_json,'$.total_weight') AS weight,
      e.name AS contractor
    FROM kasab_entry k
    JOIN company_employee_master e ON e.id = k.employee_id
    WHERE k.company_id = :cid
    ORDER BY k.id DESC
  ");
  $q->execute([':cid' => $company_id]);
  echo json_encode($q->fetchAll(PDO::FETCH_ASSOC));
  exit;
}

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

$stmt = $pdo->prepare("
  INSERT INTO kasab_entry
  (company_id, roll_type, color, rolls_json, weight_json, entry_date, employee_id)
  VALUES
  (:cid, :rt, :clr, :rj, :wj, :dt, :eid)
");

$stmt->execute([
  ':cid' => $company_id,
  ':rt'  => $data['roll_type'],
  ':clr' => $data['color'],
  ':rj'  => json_encode(['rolls' => (int)$data['rolls']]),
  ':wj'  => json_encode(['total_weight' => (float)$data['weight']]),
  ':dt'  => $data['entry_date'],
  ':eid' => (int)$data['contractor']
]);

echo json_encode(['success' => true]);