« Back to History
rapier_machine_status.php
|
20260921_175631.php
Initial Domain Snapshot
Copy Code
<?php /* ========================================================================= File: /erp/rapier_machine_status.php Purpose: Rapier Machine Status Management (Insert/Update) Pattern: Delete-then-Insert (Transactions) + Company-wise segregation ========================================================================= */ error_reporting(E_ALL); ini_set('display_errors', 1); /* --- DB + Auth --- */ if (!isset($pdo) || !($pdo instanceof PDO)) { require __DIR__ . '/core/db.php'; } require __DIR__ . '/modules/auth/auth.php'; require_once __DIR__ . '/modules/activity/activity_logger.php'; require_login(); $u = auth_user(); $company_id = (int)($u['company_id'] ?? 0); $user_id = (int)($u['id'] ?? 0); /* --- Helpers --- */ function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } function postv(string $k, $def=''){ return array_key_exists($k, $_POST) ? $_POST[$k] : $def; } function normalize_status_date(string $value): string { $dt = DateTime::createFromFormat('Y-m-d', $value); return ($dt && $dt->format('Y-m-d') === $value) ? $value : date('Y-m-d'); } function normalize_shift(string $value): string { $value = strtolower(trim($value)); return $value === 'night' ? 'Night' : 'Day'; } function normalize_shift_filter(string $value): string { $value = strtolower(trim($value)); if ($value === 'day') { return 'day'; } if ($value === 'night') { return 'night'; } return 'both'; } function machine_display_label(string $value): string { $value = trim($value); if ($value !== '' && preg_match('/(\d+)\s*$/', $value, $matches)) { return $matches[1]; } return $value; } $msg = ''; $err = ''; $selected_date = normalize_status_date((string)($_GET['date'] ?? postv('status_date', date('Y-m-d')))); $shift_labels = ['Day', 'Night']; $selected_shift_filter = normalize_shift_filter((string)($_GET['shift_filter'] ?? 'both')); $visible_shift_labels = $selected_shift_filter === 'both' ? $shift_labels : [ucfirst($selected_shift_filter)]; $today_date = date('Y-m-d'); $can_toggle_status = ($selected_date === $today_date); /* --- Toggle Logic --- */ if ($_SERVER['REQUEST_METHOD'] === 'POST' && postv('_action') === 'toggle') { $machine_no = trim((string)postv('machine_no', '')); $status_date = normalize_status_date(trim((string)postv('status_date', date('Y-m-d')))); $shift = normalize_shift((string)postv('shift', 'Day')); if ($status_date !== $today_date) { $err = 'Status change is allowed only for today.'; } elseif ($machine_no === '') { $err = 'Machine number is required.'; } else { try { $pdo->beginTransaction(); $cur = $pdo->prepare("SELECT status FROM rapier_machine_status WHERE company_id = ? AND machine_no = ? AND shift = ? AND status_date = ? ORDER BY id DESC LIMIT 1"); $cur->execute([$company_id, $machine_no, $shift, $status_date]); $current_status = (string)($cur->fetchColumn() ?: 'Stopped'); $new_status = strcasecmp($current_status, 'Running') === 0 ? 'Stopped' : 'Running'; $del = $pdo->prepare("DELETE FROM rapier_machine_status WHERE company_id = ? AND machine_no = ? AND shift = ? AND status_date = ?"); $del->execute([$company_id, $machine_no, $shift, $status_date]); $ins = $pdo->prepare("INSERT INTO rapier_machine_status (company_id, machine_no, shift, status, status_date, remarks, created_at, updated_at) VALUES (?, ?, ?, ?, ?, '', NOW(), NOW())"); $ins->execute([$company_id, $machine_no, $shift, $new_status, $status_date]); $insert_id = (int)$pdo->lastInsertId(); $pdo->commit(); activity_log([ 'company_id' => $company_id ?? 0, 'user_id' => $u['id'] ?? ($_SESSION['user_id'] ?? 0), 'module' => 'rapier', 'action_name' => 'edit', 'entity_type' => 'rapier_machine_status', 'entity_id' => $insert_id ?? 0, 'remarks' => 'Rapier machine status updated' ]); $msg = $machine_no . ' ' . $shift . ' marked as ' . ($new_status === 'Running' ? 'Active' : 'Deactive') . '.'; } catch (Exception $e) { if ($pdo->inTransaction()) { $pdo->rollBack(); } $err = 'Database Error: ' . $e->getMessage(); } } if ($err === '') { $redirect = 'rapier_machine_status.php?date=' . urlencode($status_date) . '&shift_filter=' . urlencode($selected_shift_filter) . '&msg=' . urlencode($msg); header('Location: ' . $redirect); exit; } } if (isset($_GET['msg']) && $_GET['msg'] !== '') { $msg = trim((string)$_GET['msg']); } /* --- Fetch Rapier Machines --- */ $machines = []; try { $st = $pdo->prepare("SELECT id, code FROM machines WHERE company_id = ? AND machine_type = 'Rapier' AND COALESCE(is_active, 1) = 1 ORDER BY code ASC"); $st->execute([$company_id]); $machines = $st->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { if ($err === '') { $err = $e->getMessage(); } } /* --- Fetch Selected Date Statuses --- */ $status_rows = []; try { $st = $pdo->prepare("SELECT machine_no, shift, status, remarks FROM rapier_machine_status WHERE company_id = ? AND status_date = ? ORDER BY id DESC"); $st->execute([$company_id, $selected_date]); foreach ($st->fetchAll(PDO::FETCH_ASSOC) as $row) { $machine_no = trim((string)($row['machine_no'] ?? '')); $shift = normalize_shift((string)($row['shift'] ?? 'Day')); if ($machine_no !== '' && !isset($status_rows[$machine_no][$shift])) { $status_rows[$machine_no][$shift] = $row; } } } catch (Exception $e) { if ($err === '') { $err = $e->getMessage(); } } $date_obj = new DateTime($selected_date); $prev_date = (clone $date_obj)->modify('-1 day')->format('Y-m-d'); $next_date = (clone $date_obj)->modify('+1 day')->format('Y-m-d'); $active_count = 0; $deactive_count = 0; foreach ($machines as $machine) { $machine_code = (string)$machine['code']; foreach ($visible_shift_labels as $shift_label) { $machine_status = (string)($status_rows[$machine_code][$shift_label]['status'] ?? 'Stopped'); if (strcasecmp($machine_status, 'Running') === 0) { $active_count++; } else { $deactive_count++; } } } $summary_total = $active_count + $deactive_count; $summary_filter_label = $selected_shift_filter === 'both' ? 'Day + Night' : ucfirst($selected_shift_filter); $filter_query = '&shift_filter=' . urlencode($selected_shift_filter); $summary_machine_rows = []; foreach ($machines as $machine) { $machine_code = (string)$machine['code']; $machine_shift_statuses = []; foreach ($visible_shift_labels as $shift_label) { $machine_status = (string)($status_rows[$machine_code][$shift_label]['status'] ?? 'Stopped'); $machine_shift_statuses[] = [ 'shift' => $shift_label, 'label' => strcasecmp($machine_status, 'Running') === 0 ? 'Active' : 'Deactive', 'class' => strcasecmp($machine_status, 'Running') === 0 ? 'active' : 'deactive', ]; } $summary_machine_rows[] = [ 'machine_no' => $machine_code, 'machine_label' => machine_display_label($machine_code), 'statuses' => $machine_shift_statuses, ]; } /* --- Header Include --- */ $page_title = 'Rapier Machine Status'; $__header = __DIR__ . '/partials/header.php'; if (is_file($__header)) { include_once $__header; } ?> <div class="container-fluid mt-3"> <style> .status-date-nav { display: flex; align-items: center; justify-content: space-between; gap: 1rem; } .status-date-title { min-width: 0; text-align: center; flex: 1; } .status-date-title h2 { margin: 0; font-size: 1.75rem; letter-spacing: 0.04em; } .toolbar-row { display: flex; justify-content: space-between; align-items: flex-start; gap: 1rem; flex-wrap: wrap; } .shift-filter-group { display: inline-flex; flex-wrap: wrap; gap: 0.5rem; } .shift-filter-btn { min-width: 88px; } .summary-actions { display: flex; align-items: center; gap: 0.75rem; flex-wrap: wrap; } .status-grid { display: grid; grid-template-columns: repeat(4, minmax(0, 1fr)); gap: 1rem; } .machine-card { border-radius: 1rem; padding: 0.85rem; background: #ffffff; box-shadow: 0 10px 24px rgba(15, 23, 42, 0.08); border: 1px solid rgba(148, 163, 184, 0.18); } .machine-card h3 { margin: 0 0 0.75rem; font-size: 1rem; color: #0f172a; } .shift-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 0.75rem; } .shift-grid.single-shift { grid-template-columns: 1fr; } .status-tile-form { margin: 0; } .status-tile { width: 100%; border: 0; border-radius: 0.9rem; padding: 0.9rem; color: #fff; text-align: left; box-shadow: 0 10px 24px rgba(15, 23, 42, 0.12); transition: transform 0.15s ease, box-shadow 0.15s ease, opacity 0.15s ease; } .status-tile:hover { transform: translateY(-2px); box-shadow: 0 14px 30px rgba(15, 23, 42, 0.18); } .status-tile.active-tile { background: linear-gradient(135deg, #157347, #20c997); } .status-tile.deactive-tile { background: linear-gradient(135deg, #b02a37, #fd7e14); } .status-tile small { display: block; opacity: 0.85; letter-spacing: 0.08em; text-transform: uppercase; font-size: 0.72rem; } .status-tile strong { display: block; font-size: 1.05rem; margin: 0.25rem 0 0.55rem; } .status-tile span { display: inline-block; padding: 0.3rem 0.65rem; border-radius: 999px; background: rgba(255, 255, 255, 0.18); font-weight: 700; font-size: 0.82rem; } .summary-card { width: 100%; max-width: 330px; margin: 0 auto 1.25rem; padding: 0.85rem; border-radius: 1.25rem; background: linear-gradient(180deg, #ffffff 0%, #eef6ff 100%); border: 1px solid rgba(59, 130, 246, 0.18); box-shadow: 0 12px 32px rgba(15, 23, 42, 0.12); } .summary-card-header { display: flex; justify-content: space-between; align-items: flex-start; gap: 0.75rem; margin-bottom: 1rem; } .summary-card-header h4 { margin: 0; font-size: 1.1rem; color: #0f172a; } .summary-card-header p { margin: 0.35rem 0 0; color: #475569; font-size: 0.88rem; } .summary-badge { padding: 0.35rem 0.75rem; border-radius: 999px; background: #0f172a; color: #fff; font-size: 0.75rem; font-weight: 700; letter-spacing: 0.04em; text-transform: uppercase; } .summary-stats { display: grid; grid-template-columns: repeat(3, 1fr); gap: 0.75rem; } .summary-stat { border-radius: 1rem; padding: 0.85rem 0.75rem; background: #fff; text-align: center; border: 1px solid rgba(148, 163, 184, 0.18); } .summary-stat strong { display: block; font-size: 1.2rem; color: #0f172a; } .summary-stat span { display: block; margin-top: 0.3rem; color: #64748b; font-size: 0.78rem; text-transform: uppercase; letter-spacing: 0.04em; } .summary-stat.active strong { color: #157347; } .summary-stat.deactive strong { color: #b02a37; } .summary-footer { margin-top: 0.9rem; padding-top: 0.8rem; grid-template-columns: repeat(4, minmax(0, 1fr)); border-top: 1px dashed rgba(148, 163, 184, 0.5); color: #475569; font-size: 0.82rem; display: flex; flex-direction: column; align-items: center; justify-content: flex-start; gap: 0.45rem; padding: 0.55rem 0.45rem; gap: 0.6rem; } .summary-machine-row { display: flex; align-items: center; justify-content: space-between; gap: 0.75rem; font-size: 0.85rem; min-width: 0; background: rgba(255, 255, 255, 0.92); border: 1px solid rgba(148, 163, 184, 0.18); } justify-content: center; gap: 0.3rem; color: #0f172a; font-size: 0.92rem; min-width: 64px; } .summary-machine-statuses { justify-content: center; gap: 0.2rem; padding: 0.22rem 0.42rem; gap: 0.45rem; font-size: 0.62rem; } .summary-machine-pill { display: inline-flex; align-items: center; gap: 0.35rem; @media (max-width: 991.98px) { .status-grid { grid-template-columns: repeat(2, minmax(0, 1fr)); } .summary-machine-list { grid-template-columns: repeat(3, minmax(0, 1fr)); } } padding: 0.35rem 0.55rem; border-radius: 999px; font-size: 0.72rem; font-weight: 700; letter-spacing: 0.02em; background: #e2e8f0; color: #0f172a; } .summary-machine-pill.active { background: rgba(21, 115, 71, 0.14); color: #157347; } .summary-machine-pill.deactive { background: rgba(176, 42, 55, 0.12); color: #b02a37; } @media (max-width: 576px) { .status-date-title h2 { font-size: 1.2rem; } .status-grid { grid-template-columns: 1fr; } .toolbar-row { flex-direction: column; align-items: stretch; } .summary-actions { width: 100%; justify-content: space-between; } .summary-card { max-width: 100%; } .summary-machine-list { grid-template-columns: repeat(2, minmax(0, 1fr)); } .summary-machine-row { align-items: center; flex-direction: column; } .summary-machine-statuses { justify-content: center; } } </style> <?php if($msg): ?> <div class="alert alert-success"><?= h($msg) ?></div> <?php endif; ?> <?php if($err): ?> <div class="alert alert-danger"><?= h($err) ?></div> <?php endif; ?> <div class="card shadow-sm border-0 mb-4"> <div class="card-body bg-light"> <div class="status-date-nav mb-3"> <a href="?date=<?= h($prev_date) ?><?= h($filter_query) ?>" class="btn btn-outline-dark btn-lg px-3" aria-label="Previous Date">←</a> <div class="status-date-title"> <h2><?= h(date('d F Y', strtotime($selected_date))) ?></h2> <div class="text-muted small mt-1"> Active: <strong><?= (int)$active_count ?></strong> | Deactive: <strong><?= (int)$deactive_count ?></strong> | Filter: <strong><?= h($summary_filter_label) ?></strong> <?php if ($selected_date === $today_date): ?> | Today <?php endif; ?> </div> </div> <a href="?date=<?= h($next_date) ?><?= h($filter_query) ?>" class="btn btn-outline-dark btn-lg px-3" aria-label="Next Date">→</a> </div> <div class="toolbar-row mb-4"> <div> <div class="small text-muted mb-2">Shift Filter</div> <div class="shift-filter-group"> <a href="?date=<?= h($selected_date) ?>&shift_filter=day" class="btn <?= $selected_shift_filter === 'day' ? 'btn-dark' : 'btn-outline-dark' ?> shift-filter-btn">Day</a> <a href="?date=<?= h($selected_date) ?>&shift_filter=night" class="btn <?= $selected_shift_filter === 'night' ? 'btn-dark' : 'btn-outline-dark' ?> shift-filter-btn">Night</a> <a href="?date=<?= h($selected_date) ?>&shift_filter=both" class="btn <?= $selected_shift_filter === 'both' ? 'btn-dark' : 'btn-outline-dark' ?> shift-filter-btn">Both</a> </div> </div> <div class="summary-actions"> <button type="button" class="btn btn-primary" id="downloadSummaryBtn">Summary</button> </div> </div> <div class="summary-card" id="statusSummaryCard"> <div class="summary-card-header"> <div> <h4>Rapier Status Summary</h4> <p><?= h(date('d F Y', strtotime($selected_date))) ?></p> </div> <div class="summary-badge"><?= h($summary_filter_label) ?></div> </div> <div class="summary-stats"> <div class="summary-stat active"> <strong><?= (int)$active_count ?></strong> <span>Active</span> </div> <div class="summary-stat deactive"> <strong><?= (int)$deactive_count ?></strong> <span>Deactive</span> </div> <div class="summary-stat"> <strong><?= (int)$summary_total ?></strong> <span>Total Slots</span> </div> </div> <div class="summary-machine-list"> <?php foreach ($summary_machine_rows as $summary_machine_row): ?> <div class="summary-machine-row"> <div class="summary-machine-name"><?= h($summary_machine_row['machine_label']) ?></div> <div class="summary-machine-statuses"> <?php foreach ($summary_machine_row['statuses'] as $machine_status): ?> <span class="summary-machine-pill <?= h($machine_status['class']) ?>"> <?= h(substr($machine_status['shift'], 0, 1)) ?>: <?= h(substr($machine_status['label'], 0, 1)) ?> </span> <?php endforeach; ?> </div> </div> <?php endforeach; ?> </div> <div class="summary-footer"> Machines: <?= (int)count($machines) ?> | View: <?= h($summary_filter_label) ?> </div> </div> <div class="status-grid"> <?php if (!$machines): ?> <div class="text-muted">No active rapier machines found.</div> <?php else: ?> <?php if (!$can_toggle_status): ?> <div class="alert alert-warning mb-0">Status can only be changed for today's date.</div> <?php endif; ?> <?php foreach ($machines as $machine): ?> <?php $machine_code = (string)$machine['code']; $machine_label = machine_display_label($machine_code); ?> <div class="machine-card"> <h3><?= h($machine_label) ?></h3> <div class="shift-grid <?= count($visible_shift_labels) === 1 ? 'single-shift' : '' ?>"> <?php foreach ($visible_shift_labels as $shift_label): ?> <?php $current_status = (string)($status_rows[$machine_code][$shift_label]['status'] ?? 'Stopped'); $is_active = strcasecmp($current_status, 'Running') === 0; ?> <form method="POST" class="status-tile-form"> <input type="hidden" name="_action" value="toggle"> <input type="hidden" name="machine_no" value="<?= h($machine_code) ?>"> <input type="hidden" name="shift" value="<?= h($shift_label) ?>"> <input type="hidden" name="status_date" value="<?= h($selected_date) ?>"> <button type="submit" class="status-tile <?= $is_active ? 'active-tile' : 'deactive-tile' ?>" <?= $can_toggle_status ? '' : 'disabled' ?>> <small>Shift</small> <strong><?= h($shift_label) ?></strong> <span><?= $is_active ? 'Active' : 'Deactive' ?></span> <div class="mt-3 small">Click to make <?= $is_active ? 'Deactive' : 'Active' ?></div> </button> </form> <?php endforeach; ?> </div> </div> <?php endforeach; ?> <?php endif; ?> </div> </div> </div> </div> <script src="https://cdnjs.cloudflare.com/ajax/libs/html2canvas/1.4.1/html2canvas.min.js"></script> <script> document.addEventListener('DOMContentLoaded', function () { var summaryButton = document.getElementById('downloadSummaryBtn'); var summaryCard = document.getElementById('statusSummaryCard'); if (!summaryButton || !summaryCard || typeof html2canvas === 'undefined') { return; } summaryButton.addEventListener('click', function () { var originalWidth = summaryCard.style.width; summaryCard.style.width = '330px'; html2canvas(summaryCard, { scale: 2, backgroundColor: '#ffffff', useCORS: true }).then(function (canvas) { summaryCard.style.width = originalWidth; var link = document.createElement('a'); link.download = 'rapier-status-summary-<?= h($selected_date) ?>-<?= h($selected_shift_filter) ?>.png'; link.href = canvas.toDataURL('image/png'); link.click(); }).catch(function () { summaryCard.style.width = originalWidth; alert('Summary image download failed.'); }); }); }); </script> <?php /* --- Footer Include --- */ $__footer = __DIR__ . '/partials/footer.php'; if (is_file($__footer)) { include_once $__footer; } ?>