View Code - 20260723

« Back to History

beam_load_report_live_ajax.php | 20260723_000646.php Initial Domain Snapshot

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

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

$last_id = (int)($_GET['last_id'] ?? 0);
$today = date('Y-m-d');

$from_date = trim((string)($_GET['from_date'] ?? $today));
$to_date   = trim((string)($_GET['to_date'] ?? $today));

if (!preg_match('/^\d{4}-\d{2}-\d{2}$/', $from_date)) {
    $from_date = $today;
}

if (!preg_match('/^\d{4}-\d{2}-\d{2}$/', $to_date)) {
    $to_date = $today;
}

if ($from_date > $to_date) {
    [$from_date, $to_date] = [$to_date, $from_date];
}

$sql = "
    SELECT
        b.id,
        b.event_date,
        b.machine_no,
        b.beam_no,
        b.beam_slot,
        b.quality_id,
        b.load_type,
        b.employee_id,
        b.created_at,
        COALESCE(q.name, CONCAT('#', b.quality_id)) AS beam_quality_name,
        CASE
            WHEN b.load_type = 'pissing' THEN COALESCE(q.name, CONCAT('#', b.quality_id))
            ELSE ''
        END AS pissing_quality_name,
        COALESCE(e.name, CONCAT('#', b.employee_id)) AS employee_name
    FROM beam_load_data b
    LEFT JOIN beam_qualities q
        ON q.id = b.quality_id
       AND q.company_id = b.company_id
    LEFT JOIN company_employee_master e
        ON e.id = b.employee_id
       AND e.company_id = b.company_id
    WHERE b.company_id = :cid
      AND b.event_date BETWEEN :from_date AND :to_date
";

$params = [
    ':cid' => $company_id,
    ':from_date' => $from_date,
    ':to_date' => $to_date,
];

if ($last_id > 0) {
    $sql .= " AND b.id > :last_id ORDER BY b.id ASC";
    $params[':last_id'] = $last_id;
} else {
    $sql .= " ORDER BY b.event_date DESC, b.id DESC";
}

$stmt = $pdo->prepare($sql);
$stmt->execute($params);

$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

header('Content-Type: application/json; charset=UTF-8');
echo json_encode([
    'rows' => $rows
]);