Jobcard #<?= h($jc['jc_no']) ?>

row( "SELECT j.*, t.name AS team_name, u.username AS created_by FROM jobcards j LEFT JOIN teams t ON t.record_id = j.team_assigned_id LEFT JOIN users u ON u.record_id = j.user_id WHERE j.record_id = ?", [$id] ); if (!$jc) { http_response_code(404); echo 'Not found'; exit; } $timeline = $db->rows( "SELECT jt.*, u.username FROM jobcard_timeline jt LEFT JOIN users u ON u.record_id = jt.user_id WHERE jt.jobcard_id = ? ORDER BY jt.record_id ASC", [$id] ); $notes = $db->rows( "SELECT * FROM notes WHERE jobcard_id = ? ORDER BY record_id ASC", [$id] ); $payments = $db->rows( "SELECT jp.*, u.username FROM jobcard_payments jp LEFT JOIN users u ON u.record_id = jp.user_id WHERE jp.jobcard_id = ? ORDER BY jp.date_time ASC", [$id] ); // ── Compute totals ──────────────────────────────────────────────────────── $totals = ['drilling' => 0, 'rieming' => 0, 'casing' => 0, 'blasting' => 0]; foreach ($timeline as $e) { $t = strtoupper($e['type'] ?? ''); $m = (float)($e['meters'] ?? 0); if (in_array($t, ['DRILLING_STOP','DRILLING_PAUSE'])) $totals['drilling'] += $m; if (in_array($t, ['RIEMING_STOP','RIEM_STOP','RIEMING_PAUSED','REIMING_STOP'])) $totals['rieming'] += $m; if (in_array($t, ['CASING_STOP','CASING_PAUSE'])) $totals['casing'] += $m; if (in_array($t, ['BLASTING_STOP','BLASTING_PAUSE'])) $totals['blasting'] += $m; } $totalMeters = array_sum($totals); $totalPaid = array_sum(array_column($payments, 'amount')); // ── Helpers ─────────────────────────────────────────────────────────────── function h($v) { return htmlspecialchars((string)($v ?? ''), ENT_QUOTES, 'UTF-8'); } function row($label, $value) { if ((string)($value ?? '') === '') return ''; return '' . h($label) . '' . h($value) . ''; } function fmtMoney($v) { return 'R ' . number_format((float)$v, 2, '.', ','); } function fmtDate($v) { return $v ? substr($v, 0, 10) : '—'; } $statusColor = [ 'COMPLETE' => '#16a34a', 'DRILLING' => '#1d4ed8', 'PENDING' => '#ea580c', 'ACTIVE' => '#0891b2', 'FINALISING'=> '#7c3aed', ][$jc['jc_current_status'] ?? ''] ?? '#374151'; ?> Jobcard #<?= h($jc['jc_no']) ?> — Savuki Drilling

📄 Jobcard # Report

0 ? number_format($totals['drilling'], 1) : '—' ?>m

Drilling

0 ? number_format($totals['rieming'], 1) : '—' ?>m

Rieming

0 ? number_format($totals['casing'], 1) : '—' ?>m

Casing

0 ? number_format($totals['blasting'], 1) : '—' ?>m

Blasting

0 ? number_format($totalMeters, 1) : '—' ?>m

Total

Client Details

Jobcard Info

Drilling Results

0 && $de > 0) echo row('Diesel Used', number_format($ds - $de, 0) . 'L'); ?>

Payments

Method	Amount	Date	By

Total Paid

Timeline ( entries)

Date / Time	Type	Meters	Serial / Bit	By
		0 ? h(number_format((float)$e['meters'], 1)) . 'm' : '—' ?>

Notes ()