bhitch
/
PDQ


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236
							<?php
require_once __DIR__ . '/lib/identity.php';
require_once __DIR__ . '/lib/render.php';

$actor = current_actor('ICG');

$job_filter = isset($_GET['job']) ? (int) $_GET['job'] : 0;
$q          = trim((string) ($_GET['q'] ?? ''));
$limit      = isset($_GET['limit']) ? max(50, min(1000, (int) $_GET['limit'])) : 200;

$clauses = [];
$params  = [];

if ($job_filter > 0) {
    $clauses[] = 'h.job_id = ?';
    $params[]  = $job_filter;
}

if ($q !== '') {
    // SQLite LIKE is case-insensitive for ASCII. Escape user wildcards so a
    // literal "%" or "_" doesn't blow the search open.
    $needle = '%' . strtr($q, ['\\' => '\\\\', '%' => '\\%', '_' => '\\_']) . '%';
    $clauses[] =
        "(j.job         LIKE ? ESCAPE '\\'
       OR j.material    LIKE ? ESCAPE '\\'
       OR j.description LIKE ? ESCAPE '\\'
       OR v.name        LIKE ? ESCAPE '\\'
       OR h.actor       LIKE ? ESCAPE '\\'
       OR h.field       LIKE ? ESCAPE '\\'
       OR h.old_value   LIKE ? ESCAPE '\\'
       OR h.new_value   LIKE ? ESCAPE '\\')";
    array_push($params, $needle, $needle, $needle, $needle, $needle, $needle, $needle, $needle);
}

$where = $clauses ? implode(' AND ', $clauses) : '1=1';

$sql = "
    SELECT h.*, j.job AS job_label, j.description AS job_description,
           v.slug AS vendor_slug, v.name AS vendor_name
    FROM job_history h
    LEFT JOIN jobs    j ON j.id = h.job_id
    LEFT JOIN vendors v ON v.id = j.vendor_id
    WHERE $where
    ORDER BY h.id DESC
    LIMIT $limit
";
$stmt = db()->prepare($sql);
$stmt->execute($params);
$rows = $stmt->fetchAll();

function preserve_qs(array $keep): string {
    if (!$keep) return '';
    return '?' . http_build_query($keep);
}

function fmt_long_date(?string $ts): string {
    if (!$ts) return '';
    try {
        $dt = new DateTimeImmutable($ts . ' UTC');
        return $dt->setTimezone(new DateTimeZone(date_default_timezone_get()))
                  ->format('Y-m-d g:i a');
    } catch (Exception $e) {
        return h($ts);
    }
}

function fmt_event(array $h): string {
    $f   = $h['field'];
    $old = $h['old_value'];
    $new = $h['new_value'];

    if ($f === 'created') {
        return 'Created (vendor: ' . h((string) $new) . ')';
    }
    if ($f === 'deleted') {
        return 'Deleted';
    }
    if ($f === 'partial_ship') {
        return 'Partial ship: split off ' . h((string) $new) . ' (was qty ' . h((string) $old) . ')';
    }
    $labels = [
        'ack'         => 'Acknowledgement',
        'status'      => 'Status',
        'job'         => 'Job #',
        'material'    => 'Material',
        'description' => 'Description',
        'qty'         => 'Qty',
        'due_date'    => 'Due date',
    ];
    $label = $labels[$f] ?? $f;
    $oldDisp = ($old === null || $old === '') ? '∅' : h((string) $old);
    $newDisp = ($new === null || $new === '') ? '∅' : h((string) $new);
    return $label . ': ' . $oldDisp . ' &rarr; ' . $newDisp;
}
?><!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Activity Log</title>
<link rel="stylesheet" href="assets/app.css">
<style>
table.log {
    border-collapse: collapse;
    width: 100%;
    max-width: 1100px;
    font-size: 0.95rem;
}
table.log th, table.log td {
    padding: 0.4rem 0.7rem;
    border-bottom: 1px solid #eee;
    text-align: left;
    vertical-align: top;
}
table.log th {
    background: var(--c-accent-strong);
    color: #fff;
    font-weight: 600;
    font-size: 0.85rem;
    text-transform: uppercase;
    letter-spacing: 0.05em;
}
.log-ts     { white-space: nowrap; color: var(--c-muted); font-variant-numeric: tabular-nums; }
.log-actor  { font-weight: 600; }
.log-actor-icg  { color: var(--c-accent-strong); }
.log-actor-vend { color: var(--c-info); }
.log-job   { font-weight: 600; }
.log-job a { color: inherit; text-decoration: none; }
.log-job a:hover { text-decoration: underline; }
.log-filter {
    margin: 0.5rem 0 1rem;
    color: var(--c-muted);
}
.log-filter a { color: var(--c-accent-strong); }
.log-desc  { max-width: 24em; }
.log-muted { color: var(--c-muted); }

.log-search {
    display: flex;
    gap: 0.5rem;
    align-items: center;
    margin: 0.75rem 0 0.5rem;
}
.log-search input[type="text"] {
    flex: 0 1 28rem;
    font-size: 1rem;
    padding: 0.4rem 0.6rem;
    border: 1px solid #ccc;
    border-radius: 4px;
}
.log-search input[type="text"]:focus { outline: 2px solid var(--c-info); }
.log-search button {
    font-size: 0.95rem;
    padding: 0.45rem 1rem;
    border: 0;
    border-radius: 4px;
    background: var(--c-accent-strong);
    color: #fff;
    font-weight: 600;
    cursor: pointer;
}
.log-clear { color: var(--c-muted); font-size: 0.9rem; }
</style>
</head>
<body>

<div class="topbar">
    <h1>Activity Log</h1>
    <span class="who"><a href="PDQ.php">&larr; Back to schedule</a></span>
</div>

<form class="log-search" method="get" action="log.php">
    <input type="text" name="q" value="<?= h($q) ?>" placeholder="Search job, material, description, actor, status…" autofocus>
    <?php if ($job_filter > 0): ?>
        <input type="hidden" name="job" value="<?= (int) $job_filter ?>">
    <?php endif; ?>
    <button type="submit">Search</button>
    <?php if ($q !== '' || $job_filter > 0): ?>
        <a class="log-clear" href="log.php">Clear</a>
    <?php endif; ?>
</form>

<p class="log-filter">
    <?php
    $bits = [];
    if ($job_filter > 0) {
        $bits[] = 'job <strong>#' . (int) $job_filter . '</strong>';
    }
    if ($q !== '') {
        $bits[] = 'matching <strong>&ldquo;' . h($q) . '&rdquo;</strong>';
    }
    if ($bits) {
        echo count($rows) . ' event' . (count($rows) === 1 ? '' : 's') . ' ' . implode(' &middot; ', $bits) . '.';
        if ($job_filter > 0) {
            echo ' <a href="' . h(preserve_qs($q !== '' ? ['q' => $q] : [])) . '">drop job filter</a>';
        }
        if ($q !== '') {
            echo ' <a href="' . h(preserve_qs($job_filter > 0 ? ['job' => $job_filter] : [])) . '">drop search</a>';
        }
    } else {
        echo 'Latest ' . count($rows) . ' events. Click a job number to filter, or search above.';
    }
    ?>
</p>

<table class="log">
    <thead>
    <tr>
        <th>When</th>
        <th>Who</th>
        <th>Job</th>
        <th>Description</th>
        <th>Event</th>
    </tr>
    </thead>
    <tbody>
    <?php if (!$rows): ?>
        <tr><td colspan="5" class="empty">No events recorded.</td></tr>
    <?php endif; ?>
    <?php foreach ($rows as $h):
        $actorKlass = $h['actor'] === 'ICG' ? 'log-actor-icg' : 'log-actor-vend';
        $jobLabel = $h['job_label'] !== null ? '#' . (int) $h['job_id'] . ' ' . h($h['job_label']) : '#' . (int) $h['job_id'] . ' (deleted)';
        $desc = (string) ($h['job_description'] ?? '');
    ?>
        <tr>
            <td class="log-ts"><?= fmt_long_date($h['changed_at']) ?></td>
            <td class="log-actor <?= $actorKlass ?>"><?= h($h['actor']) ?></td>
            <td class="log-job"><a href="<?= h(preserve_qs(['job' => (int) $h['job_id']] + ($q !== '' ? ['q' => $q] : []))) ?>"><?= $jobLabel ?></a></td>
            <td class="log-desc"><?= $desc === '' ? '<span class="log-muted">&mdash;</span>' : h($desc) ?></td>
            <td><?= fmt_event($h) ?></td>
        </tr>
    <?php endforeach; ?>
    </tbody>
</table>

</body>
</html>