?php
declare(strict_types=1);
require_once __DIR__ . '/app/bootstrap.php';
$pdo = db();
$route = $_GET['route'] ?? 'dashboard';
if ($route === 'logout') {
session_destroy();
header('Location: ?route=login');
exit;
}
if ($route === 'login') {
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
verify_csrf();
$stmt = $pdo->prepare('SELECT users.*, roles.name AS role FROM users JOIN roles ON roles.id=users.role_id WHERE email=? AND active=1');
$stmt->execute([post('email')]);
$user = $stmt->fetch();
if ($user && password_verify(post('password'), $user['password_hash'])) {
$_SESSION['user_id'] = (int)$user['id'];
$pdo->prepare('UPDATE users SET last_login_at=CURRENT_TIMESTAMP WHERE id=?')->execute([(int)$user['id']]);
redirect($user['role'] === 'Technician' ? 'tech' : 'dashboard');
}
$error = 'Invalid email or password.';
}
echo 'Login - V.I.T.A.L. ' . head_branding_tags() . 'Shop Command Center Action queues for today, review, proof gaps, and blocked work.
Needs Action Now ';
$jobs = query("SELECT j.*, c.first_name, c.last_name, v.year, v.make, v.model, u.name AS tech_name, t.name AS team_name FROM jobs j JOIN customers c ON c.id=j.customer_id JOIN vehicles v ON v.id=j.vehicle_id LEFT JOIN users u ON u.id=j.assigned_technician_id LEFT JOIN teams t ON t.id=j.assigned_team_id WHERE j.status IN ('Ready For Review','Paused','Assigned','Available') ORDER BY j.scheduled_date, j.scheduled_start_time LIMIT 12");
if ($jobs) dashboard_job_cards($jobs); else empty_state('No jobs need action.', 'Create a job or assign work from the schedule.', '?route=job_form', 'Create Job');
echo 'Today / Upcoming ';
$upcoming = query("SELECT j.*, c.first_name, c.last_name, v.year, v.make, v.model, u.name AS tech_name, t.name AS team_name FROM jobs j JOIN customers c ON c.id=j.customer_id JOIN vehicles v ON v.id=j.vehicle_id LEFT JOIN users u ON u.id=j.assigned_technician_id LEFT JOIN teams t ON t.id=j.assigned_team_id WHERE date(j.scheduled_date) >= date('now') ORDER BY j.scheduled_date, j.scheduled_start_time LIMIT 8");
if ($upcoming) dashboard_job_cards($upcoming); else empty_state('No upcoming jobs.', 'Schedule work to see the shop load here.', '?route=job_form', 'Schedule Job');
echo 'Proof Gaps ';
$miss = grouped_proof_gaps(array_slice(jobs_with_missing_requirements(), 0, 16));
if (!$miss) echo 'No proof gaps right now. Required photos and checklist records are complete.
';
foreach ($miss as $jobId => $gap) {
echo '' . e($gap['title']) . ' Missing: ' . e(implode(', ', $gap['gaps'])) . '
Open Job Open Issues ';
$issues = query("SELECT i.*, j.job_title, v.year, v.make, v.model FROM job_issues i JOIN jobs j ON j.id=i.job_id JOIN vehicles v ON v.id=j.vehicle_id WHERE i.resolved=0 ORDER BY i.created_at DESC LIMIT 12");
if (!$issues) echo 'No open issues right now. Damage, exceptions, and approval flags will show here.
';
foreach ($issues as $issue) echo '' . e($issue['issue_type']) . ' ' . e($issue['year'].' '.$issue['make'].' '.$issue['model'].' - '.$issue['job_title']) . ' ' . e($issue['note']) . '
';
echo 'Role guide Admins manage everything. Managers schedule and review work. Technicians only see bay workflow screens.
Manage Teams ' . ($edit ? 'Edit User' : 'Create User') . ' All Users ';
$users = query('SELECT users.*, roles.name AS role FROM users JOIN roles ON roles.id=users.role_id ORDER BY users.name');
echo 'Name Email Role Status Last Login ' . e($u['name']) . ' ' . e($u['email']) . ' ' . e($u['role']) . ' ' . ((int)$u['active'] ? 'Active' : 'Inactive') . ' ' . e($u['last_login_at'] ?: 'Never') . ' Edit / Reset
' . ($edit ? 'Edit Team' : 'Create Team') . ' Teams ';
$teams = query('SELECT t.*, u.name AS manager FROM teams t LEFT JOIN users u ON u.id=t.manager_id ORDER BY archived, name');
echo 'Name Manager Status ' . e($team['name']) . ' ' . e($team['manager']) . ' ' . ((int)$team['archived'] ? 'Archived' : 'Active') . ' Edit
Customer Database Find customers, vehicles, and job history fast.
Add New Customer ' . ($edit ? 'Edit Customer' : 'Add New Customer') . ' ';
echo '';
echo '' . e(trim($view['first_name'].' '.$view['last_name'])) . ' ';
if ($view['company_name']) echo '
' . e($view['company_name']) . ' ';
echo '
' . e($view['phone']) . ($view['email'] ? ' | ' . e($view['email']) : '') . ' ';
if ($view['notes']) echo '
' . e($view['notes']) . '
';
echo '
Vehicles ';
}
// Job history
if ($custJobs) {
echo 'Job History ';
} else {
echo 'No job history yet.
';
}
echo ' ';
}
$where = ['1=1']; $params = [];
if (!empty($_GET['q'])) {
$q = '%' . $_GET['q'] . '%';
$where[] = "(c.first_name LIKE ? OR c.last_name LIKE ? OR c.company_name LIKE ? OR c.phone LIKE ? OR c.email LIKE ? OR v.make LIKE ? OR v.model LIKE ? OR v.vin LIKE ?)";
$params = [$q,$q,$q,$q,$q,$q,$q,$q];
}
$customers = query("SELECT c.*, COUNT(DISTINCT v.id) AS vehicles, COUNT(DISTINCT CASE WHEN j.status NOT IN ('Completed','Cancelled') THEN j.id END) AS open_jobs, MAX(COALESCE(j.updated_at, v.updated_at, c.updated_at)) AS last_activity FROM customers c LEFT JOIN vehicles v ON v.customer_id=c.id LEFT JOIN jobs j ON j.customer_id=c.id WHERE " . implode(' AND ', $where) . " GROUP BY c.id ORDER BY last_activity DESC, c.last_name", $params);
echo 'Customer Database ';
if (!$customers) {
empty_state('No customers found.', 'Add a new customer to get started.', '?route=customers&new=1', 'Add New Customer');
} else {
echo 'Customer Contact Vehicles Open Jobs Last Activity Actions ' . e(trim($c['first_name'].' '.$c['last_name'])) . ' ' . e($c['company_name']) . ' ' . e($c['phone']) . '' . e($c['email']) . ' ' . (int)$c['vehicles'] . ' ' . (int)$c['open_jobs'] . ' ' . e($c['last_activity'] ? date('M j, Y', strtotime($c['last_activity'])) : 'None') . ' View Add Vehicle Edit
Vehicle Database Find vehicles by customer, VIN, plate, or model.
Add New Vehicle ' . ($edit ? 'Edit Vehicle' : 'Add New Vehicle') . ' Vehicle Detail ' . e(vehicle_label($view)) . ' ' . e($view['first_name'].' '.$view['last_name']) . ' VIN: ' . e($view['vin']) . ' | Plate: ' . e($view['license_plate']) . ' Mileage: ' . e((string)$view['mileage']) . ' | Color: ' . e($view['color']) . ' ' . e($view['notes']) . '
Job History ';
}
echo 'Vehicle Database ';
if (!$vehicles) {
empty_state('No vehicles found.', 'Add a vehicle before creating shop work.', '?route=vehicles&new=1', 'Add New Vehicle');
} else {
echo 'Vehicle Customer VIN / Plate Mileage Open Jobs Last Activity Actions ' . e(vehicle_label($v)) . ' ' . e($v['first_name'].' '.$v['last_name']) . ' ' . e($v['vin']) . '' . e($v['license_plate']) . ' ' . e((string)$v['mileage']) . ' ' . (int)$v['open_jobs'] . ' ' . e($v['last_activity'] ? date('M j, Y', strtotime($v['last_activity'])) : 'None') . ' View Create Job Edit
Job Command Center Search, filter, assign, and review shop work.
Create Job Similar Template Found ';
foreach ($matches as $m) echo '';
echo '' . fmt_minutes($active) . ' Actual Active Time
' . (int)$job['estimated_duration_minutes'] . 'm Estimated
' . ($variance >= 0 ? '+' : '') . $variance . 'm Variance
' . fmt_minutes(elapsed_time_seconds((int)$job['id'])) . ' Total Elapsed
Before / After Photos ';
$reqs = requirements_for_job((int)$job['id'], 'intake');
foreach ($reqs as $req) {
$before = last_photo((int)$job['id'], 'intake', $req['requirement_key']);
$after = last_photo((int)$job['id'], 'outtake', $req['requirement_key']);
echo '
' . e($req['name']) . ' Before ' . thumb($before) . '
After ' . thumb($after) . '
';
}
echo '
Checklist Completion ';
checklist_review((int)$job['id'], 'intake');
checklist_review((int)$job['id'], 'outtake');
echo 'Issues & History ';
foreach (query('SELECT * FROM job_issues WHERE job_id=? ORDER BY created_at DESC', [$job['id']]) as $issue) echo '' . e($issue['issue_type']) . ' ' . e($issue['note']) . ' ' . e($issue['created_at']) . '
';
echo 'Status History ';
foreach (query('SELECT h.*, u.name FROM job_status_history h LEFT JOIN users u ON u.id=h.changed_by WHERE job_id=? ORDER BY h.created_at DESC', [$job['id']]) as $h) echo '' . e(($h['old_status'] ?: 'New') . ' -> ' . $h['new_status']) . ' ' . e($h['reason']) . ' ' . e($h['created_at'] . ' by ' . ($h['name'] ?: 'system')) . '
';
echo 'Proof Packet - V.I.T.A.L. ' . head_branding_tags() . '';
echo '';
job_summary($job);
echo 'Proof Summary Customer ' . e($job['first_name'].' '.$job['last_name']) . '
Vehicle ' . e(vehicle_label($job)) . '
VIN ' . e($job['vin']) . '
Plate ' . e($job['license_plate']) . '
Estimate ' . (int)$job['estimated_duration_minutes'] . 'm
Actual Active ' . e(fmt_minutes(active_time_seconds((int)$job['id']))) . '
Before / After Photo Proof ';
foreach (requirements_for_job((int)$job['id'], 'intake') as $req) {
echo '
' . e($req['name']) . ' Before ' . thumb(last_photo((int)$job['id'], 'intake', $req['requirement_key'])) . '
After ' . thumb(last_photo((int)$job['id'], 'outtake', $req['requirement_key'])) . '
';
}
echo '
Checklist Record ';
checklist_review((int)$job['id'], 'intake');
checklist_review((int)$job['id'], 'outtake');
echo 'Status / Audit Trail ';
foreach (query('SELECT h.*, u.name FROM job_status_history h LEFT JOIN users u ON u.id=h.changed_by WHERE job_id=? ORDER BY h.created_at', [$job['id']]) as $h) {
echo '' . e(($h['old_status'] ?: 'New') . ' -> ' . $h['new_status']) . ' ' . e($h['reason']) . ' ' . e($h['created_at'] . ' by ' . ($h['name'] ?: 'system')) . '
';
}
echo ' ';
}
function page_schedule(array $user): void
{
require_role(['Admin', 'Manager']);
layout_header('Schedule', $user);
$date = $_GET['date'] ?? date('Y-m-d');
$prev = date('Y-m-d', strtotime($date . ' -7 days'));
$next = date('Y-m-d', strtotime($date . ' +7 days'));
echo 'Dispatch Board Week view for scheduled work and open pool jobs.
Quick Create Job ';
for ($i = 0; $i < 7; $i++) {
$d = date('Y-m-d', strtotime($date . " +{$i} day"));
$where = ['j.scheduled_date=?']; $params = [$d];
if (!empty($_GET['team'])) { $where[] = 'j.assigned_team_id=?'; $params[] = (int)$_GET['team']; }
if (!empty($_GET['status'])) { $where[] = 'j.status=?'; $params[] = $_GET['status']; }
$jobs = query("SELECT j.*, c.first_name, c.last_name, v.year, v.make, v.model, u.name AS tech_name, t.name AS team_name FROM jobs j JOIN customers c ON c.id=j.customer_id JOIN vehicles v ON v.id=j.vehicle_id LEFT JOIN users u ON u.id=j.assigned_technician_id LEFT JOIN teams t ON t.id=j.assigned_team_id WHERE " . implode(' AND ', $where) . " ORDER BY j.scheduled_start_time", $params);
$totalEstimate = array_sum(array_map(fn($job) => (int)$job['estimated_duration_minutes'], $jobs));
echo '
' . e(date('D M j', strtotime($d))) . ' ' . count($jobs) . ' jobs' . ($totalEstimate ? ' | ' . $totalEstimate . 'm est' : '') . ' ';
if (!$jobs) echo 'No jobs scheduled. Quick create or assign from open pool.
';
foreach ($jobs as $job) echo schedule_job_card($job);
echo '';
}
echo '
Unscheduled / Open Pool ';
$open = query("SELECT j.*, c.first_name, c.last_name, v.year, v.make, v.model, u.name AS tech_name, t.name AS team_name FROM jobs j JOIN customers c ON c.id=j.customer_id JOIN vehicles v ON v.id=j.vehicle_id LEFT JOIN users u ON u.id=j.assigned_technician_id LEFT JOIN teams t ON t.id=j.assigned_team_id WHERE j.assignment_mode='pool' OR j.scheduled_date IS NULL ORDER BY j.created_at DESC LIMIT 12");
if ($open) job_table($open, true); else empty_state('No unscheduled work.', 'Open pool jobs and unscheduled work will show here.', '?route=job_form', 'Create Job');
echo 'Viewing As Technician - V.I.T.A.L. ' . head_branding_tags() . '';
foreach (flashes() as $flash) {
echo '' . e($flash['message']) . '
';
}
$step = $_GET['step'] ?? next_tech_step($job, $user);
job_summary($job);
tech_step_banner($job, $step);
echo '';
switch ($step) {
case 'dash-lights':
dash_lights_panel($job);
break;
case 'intake-checklist':
tech_checklist_panel($job, 'intake', $user);
break;
case 'intake-photos':
tech_photos_panel($job, 'intake', $user);
issue_panel($job, $user);
break;
case 'timer':
timer_panel($job, $user);
break;
case 'outtake-checklist':
tech_checklist_panel($job, 'outtake', $user);
break;
case 'outtake-photos':
tech_photos_panel($job, 'outtake', $user);
break;
case 'submit':
submit_panel($job);
break;
case 'confirm':
default:
vehicle_info_panel($job);
break;
}
echo ' ';
echo ' ';
}
function page_tech_job(array $user): void
{
require_role(['Technician']);
$job = full_job((int)($_GET['id'] ?? 0));
if (!$job || !tech_can_view($user, $job)) redirect('tech');
layout_header('Job Detail', $user);
job_summary($job);
$step = $_GET['step'] ?? next_tech_step($job, $user);
if (!$job['claimed_by'] && in_array($job['assignment_mode'], ['team','pool'], true)) {
echo '';
layout_footer();
return;
} elseif ((int)$job['assigned_technician_id'] === (int)$user['id'] && $job['status'] === 'Assigned') {
echo '';
layout_footer();
return;
}
tech_step_banner($job, $step);
echo '';
switch ($step) {
case 'dash-lights':
dash_lights_panel($job);
break;
case 'intake-checklist':
tech_checklist_panel($job, 'intake', $user);
break;
case 'intake-photos':
tech_photos_panel($job, 'intake', $user);
issue_panel($job, $user);
break;
case 'timer':
timer_panel($job, $user);
break;
case 'outtake-checklist':
tech_checklist_panel($job, 'outtake', $user);
break;
case 'outtake-photos':
tech_photos_panel($job, 'outtake', $user);
break;
case 'marketing':
tech_photos_panel($job, 'marketing', $user);
issue_panel($job, $user);
break;
case 'submit':
submit_panel($job);
break;
case 'confirm':
default:
vehicle_info_panel($job);
break;
}
echo ' ';
layout_footer();
}
function page_checklists(array $user): void
{
require_role(['Admin', 'Manager']);
layout_header('Checklists', $user);
echo 'Create Checklist Template Build reusable required steps for intake or outtake. Prefix optional items with ? and issue-note items with !.
Checklist Templates ';
foreach (query('SELECT * FROM checklist_templates ORDER BY stage, name') as $tpl) {
$items = query('SELECT * FROM checklist_items WHERE template_id=? ORDER BY sort_order', [$tpl['id']]);
echo '' . e($tpl['name']) . ' ' . e(ucfirst($tpl['stage'])) . ' ' . count($items) . ' items
';
foreach ($items as $item) echo '
' . e(((int)$item['is_required'] ? 'Required' : 'Optional') . ': ' . $item['label']) . ' ';
echo '
Create Photo Requirement Set These labels become technician photo cards with TAKE PHOTO and RETAKE PHOTO actions.
Photo Sets ';
foreach (query('SELECT * FROM photo_requirement_templates ORDER BY name') as $tpl) {
$items = query('SELECT * FROM photo_requirement_items WHERE template_id=? ORDER BY stage, sort_order', [$tpl['id']]);
echo '' . e($tpl['name']) . ' ' . count($items) . ' prompts
';
foreach ($items as $item) echo '' . e(ucfirst($item['stage'])) . ' ' . e($item['name']) . '
';
echo '
' . ($edit ? 'Edit Template' : 'Create Template') . ' Template Library ';
echo 'Template Vehicle Type Estimate ' . e($tpl['template_name']) . ' ' . e($tpl['year_start'].'-'.$tpl['year_end'].' '.$tpl['make'].' '.$tpl['model']) . ' ' . e($tpl['job_type']) . ' ' . (int)$tpl['estimated_duration_minutes'] . 'm Edit
' . (int)$completed . ' Jobs Completed Closed proof records
' . (int)$overEstimate . ' Jobs Over Estimate Labor variance
' . (int)$missingPhotos . ' Missing Required Photos Proof gaps
' . e(fmt_minutes($activeSeconds)) . ' Active Labor Total tracked time
Technician Performance Technician Jobs Completed Total Active Avg Active Pauses ' . e($tech['name']) . ' ' . (int)$tech['jobs'] . ' ' . fmt_minutes($total) . ' ' . fmt_minutes((int)$tech['jobs'] ? (int)($total / (int)$tech['jobs']) : 0) . ' ' . (int)$tech['pauses'] . '
Job Type Timing Job Type Jobs Avg Estimate Avg Actual ' . e($r['job_type']) . ' ' . (int)$r['jobs'] . ' ' . (int)$r['est'] . 'm ' . fmt_minutes((int)$r['jobs'] ? (int)($total / (int)$r['jobs']) : 0) . '
Vehicle Timing Vehicle Jobs Avg Active ' . e($r['year'].' '.$r['make'].' '.$r['model']) . ' ' . (int)$r['jobs'] . ' ' . fmt_minutes((int)($total / max(1, (int)$r['jobs']))) . '
Template Accuracy Template Estimate Avg Actual Jobs Recommendation ' . e($t['template_name']) . ' ' . (int)$t['estimated_duration_minutes'] . 'm ' . $avg . 'm ' . (int)$t['jobs'] . ' ' . e($rec) . '
Checklist & Photo Gaps ';
$miss = jobs_with_missing_requirements();
if (!$miss) echo 'No missing required checklist items or photos found.
';
foreach ($miss as $m) echo '';
echo 'Marketing Photo Library ';
foreach (query("SELECT p.*, j.job_title FROM job_photos p JOIN jobs j ON j.id=p.job_id WHERE p.stage='marketing' ORDER BY p.created_at DESC LIMIT 60") as $p) echo '
' . thumb($p) . '' . e($p['job_title']) . ' ';
echo '
View As Technician Open a live technician workflow for testing. Actions here can update the selected job.
' . e($label) . ' ';
}
function save_table(string $table, array $fields, string $redirect): void
{
$id = (int)post('id');
$values = array_map(fn($f) => post($f) === '' ? null : post($f), $fields);
if ($id) {
db()->prepare("UPDATE {$table} SET " . implode('=?, ', $fields) . '=?, updated_at=CURRENT_TIMESTAMP WHERE id=?')->execute([...$values, $id]);
} else {
db()->prepare("INSERT INTO {$table}(" . implode(',', $fields) . ') VALUES(' . implode(',', array_fill(0, count($fields), '?')) . ')')->execute($values);
}
flash(ucfirst(rtrim($table, 's')) . ' saved.');
redirect($redirect);
}
function vehicle_label(array $v): string
{
return trim((string)$v['year'] . ' ' . $v['make'] . ' ' . $v['model'] . ' ' . ($v['trim'] ?? ''));
}
function job_statuses(): array
{
return ['Scheduled','Available','Assigned','Accepted','Intake Started','Intake Complete','Work Started','Paused','Work Complete','Outtake Started','Outtake Complete','Ready For Review','Ready For Pickup','Completed','Cancelled'];
}
function full_job(int $id): ?array
{
return row("SELECT j.*, c.first_name, c.last_name, c.company_name, c.phone, c.email, v.year, v.make, v.model, v.trim, v.vin, v.license_plate, v.color, v.mileage, v.drivetrain FROM jobs j JOIN customers c ON c.id=j.customer_id JOIN vehicles v ON v.id=j.vehicle_id WHERE j.id=?", [$id]);
}
function job_table(array $jobs, bool $actions = false): void
{
if (!$jobs) { echo 'No jobs found.
'; return; }
echo '';
foreach ($jobs as $j) {
mobile_job_card($j, $actions);
}
echo '
';
echo 'Job Vehicle Scheduled Status Estimate / Actual ' . ($actions ? 'Actions ' : '') . '' . e($j['job_title']) . ' ' . e($j['first_name'].' '.$j['last_name']) . ' | ' . e($assigned) . ' ' . e(short_vehicle_label($j)) . ' ' . e(compact_datetime($j['scheduled_date'] ?? '', $j['scheduled_start_time'] ?? '')) . ' ' . status_badge($j['status'], true) . ' ' . (int)$j['estimated_duration_minutes'] . 'm / ' . fmt_minutes(active_time_seconds((int)$j['id'])) . ' ';
if ($actions) echo '' . primary_job_action($j) . 'Edit ';
echo '
';
echo '' . e($job['job_title']) . ' ' . e($job['first_name'] . ' ' . $job['last_name']) . '
' . status_badge($job['status'], true) . '
Vehicle ' . e(short_vehicle_label($job)) . '
';
echo 'Scheduled ' . e(compact_datetime($job['scheduled_date'] ?? '', $job['scheduled_start_time'] ?? '')) . '
';
echo 'Assigned ' . e($assigned) . '
';
echo 'Time ' . (int)$job['estimated_duration_minutes'] . 'm est / ' . e($actual) . ' actual
';
if ($actions) {
echo '' . primary_job_action($job) . '
Edit ';
}
function primary_job_action(array $job): string
{
$label = in_array($job['status'], ['Ready For Review','Ready For Pickup'], true) ? 'Review' : ($job['status'] === 'Available' ? 'Assign' : 'Open');
return '' . e($label) . ' ';
}
function dashboard_job_cards(array $jobs): void
{
echo '';
foreach ($jobs as $job) {
$actual = fmt_minutes(active_time_seconds((int)$job['id']));
$assigned = $job['tech_name'] ?: ($job['team_name'] ?: 'Unassigned');
echo '
';
echo '#' . (int)$job['id'] . ' ' . e(short_job_title($job['job_title'])) . ' ' . e(short_vehicle_label($job)) . ' | ' . e($job['first_name'] . ' ' . $job['last_name']) . '
' . status_badge($job['status'], true) . '
' . e(compact_datetime($job['scheduled_date'] ?? '', $job['scheduled_start_time'] ?? '')) . ' Tech: ' . e($assigned) . ' Time: ' . (int)$job['estimated_duration_minutes'] . 'm / ' . e($actual) . '
';
echo workflow_mini((int)$job['id'], $job['status']);
echo '';
echo ' ';
}
echo '
' . e(date('g:i A', strtotime($job['scheduled_start_time'] ?: '00:00')) . ' ' . short_job_title($job['job_title'])) . ' ' . status_badge($job['status'], true) . '
' . e(short_vehicle_label($job)) . ' ' . e($assigned) . ' | ' . (int)$job['estimated_duration_minutes'] . 'm / ' . e($actual) . ' ';
foreach ($steps as $label => $done) {
$html .= '' . e($label) . ' ';
}
return $html . '
';
}
function grouped_proof_gaps(array $gaps): array
{
$out = [];
foreach ($gaps as $gap) {
$id = (int)$gap['id'];
if (!isset($out[$id])) {
$out[$id] = ['title' => $gap['job_title'], 'gaps' => []];
}
$out[$id]['gaps'][] = str_replace([' missing required items', ' required photos missing'], ['', ' photos'], $gap['gap']);
}
return $out;
}
function status_badge(string $status, bool $short = false): string
{
return '' . e($short ? short_status($status) : $status) . ' ';
}
function short_status(string $status): string
{
$map = ['Ready For Review' => 'Review', 'Ready For Pickup' => 'Pickup', 'Work Started' => 'Work', 'Intake Started' => 'Intake', 'Outtake Started' => 'Outtake'];
return $map[$status] ?? $status;
}
function status_class(string $status): string
{
$map = [
'Scheduled' => 'badge-scheduled',
'Assigned' => 'badge-assigned',
'Available' => 'badge-assigned',
'Accepted' => 'badge-active',
'Intake Started' => 'badge-alert',
'Intake Complete' => 'badge-active',
'Work Started' => 'badge-red',
'Paused' => 'badge-warn',
'Work Complete' => 'badge-active',
'Outtake Started' => 'badge-alert',
'Outtake Complete' => 'badge-active',
'Ready For Review' => 'badge-review',
'Ready For Pickup' => 'badge-review',
'Completed' => 'badge-complete',
'Cancelled' => 'badge-cancelled',
];
return $map[$status] ?? 'badge-scheduled';
}
function tech_jobs(array $user, string $type): array
{
if ($type === 'my') {
return query("SELECT j.*, c.first_name, c.last_name, v.year, v.make, v.model FROM jobs j JOIN customers c ON c.id=j.customer_id JOIN vehicles v ON v.id=j.vehicle_id WHERE j.assigned_technician_id=? AND j.status NOT IN ('Completed','Cancelled') ORDER BY j.scheduled_date, j.scheduled_start_time", [(int)$user['id']]);
}
if ($type === 'team') {
return query("SELECT DISTINCT j.*, c.first_name, c.last_name, v.year, v.make, v.model FROM jobs j JOIN customers c ON c.id=j.customer_id JOIN vehicles v ON v.id=j.vehicle_id JOIN team_members tm ON tm.team_id=j.assigned_team_id WHERE tm.user_id=? AND j.assignment_mode='team' AND j.status NOT IN ('Completed','Cancelled','Ready For Review') ORDER BY j.scheduled_date, j.scheduled_start_time", [(int)$user['id']]);
}
return query("SELECT j.*, c.first_name, c.last_name, v.year, v.make, v.model FROM jobs j JOIN customers c ON c.id=j.customer_id JOIN vehicles v ON v.id=j.vehicle_id WHERE j.assignment_mode='pool' AND j.status IN ('Available','Scheduled') ORDER BY j.scheduled_date, j.scheduled_start_time");
}
function tech_can_view(array $user, array $job): bool
{
if (has_role($user, ['Admin', 'Manager'])) return true;
if ((int)$job['assigned_technician_id'] === (int)$user['id'] || (int)$job['claimed_by'] === (int)$user['id']) return true;
if ($job['assignment_mode'] === 'pool' && in_array($job['status'], ['Available','Scheduled'], true)) return true;
if ($job['assignment_mode'] === 'team') return scalar('SELECT COUNT(*) FROM team_members WHERE team_id=? AND user_id=?', [(int)$job['assigned_team_id'], (int)$user['id']]) > 0;
return false;
}
function tech_job_cta_label(string $status): string
{
$map = [
'Available' => 'ACCEPT JOB',
'Accepted' => 'START INTAKE',
'Intake Started' => 'CONTINUE INTAKE',
'Intake Complete' => 'START WORK',
'Work Started' => 'CONTINUE WORK',
'Work Complete' => 'START OUTTAKE',
'Outtake Started' => 'CONTINUE OUTTAKE',
'Outtake Complete' => 'SUBMIT JOB',
'Ready For Review' => 'SUBMIT JOB',
];
return $map[$status] ?? 'VIEW JOB';
}
function tech_section(string $id, string $title, array $jobs, array $user): void
{
echo '';
}
function job_summary(array $job): void
{
echo '#' . (int)$job['id'] . ' ' . e($job['job_title']) . ' ' . e($job['first_name'].' '.$job['last_name']) . ' - ' . e(vehicle_label($job)) . '
VIN: ' . e($job['vin']) . ' | Plate: ' . e($job['license_plate']) . ' | Color: ' . e($job['color']) . '
' . dash_light_summary($job) . '
' . status_badge($job['status']) . '
' . e($job['job_type']) . '
Scheduled: ' . e($job['scheduled_date'].' '.$job['scheduled_start_time']) . '
Dash lights not checked
';
}
if (!dash_lights_present($job)) {
return 'No dash lights on at intake
';
}
$labels = dash_light_labels([
'dash_airbag' => (int)($job['dash_airbag'] ?? 0),
'dash_abs' => (int)($job['dash_abs'] ?? 0),
'dash_check_engine' => (int)($job['dash_check_engine'] ?? 0),
'dash_tpms' => (int)($job['dash_tpms'] ?? 0),
'dash_other' => (int)($job['dash_other'] ?? 0),
'dash_other_note' => (string)($job['dash_other_note'] ?? ''),
]);
return 'Dash lights on: ' . e(implode(', ', $labels)) . ((int)($job['dash_customer_notified'] ?? 0) ? ' | Customer notified' : ' | Customer not notified') . '
';
}
function tech_progress(array $job): void
{
$steps = [
'Vehicle' => vehicle_confirmed($job),
'Intake Tasks' => checklist_complete((int)$job['id'], 'intake'),
'Intake Photos' => photos_complete((int)$job['id'], 'intake'),
'Work' => scalar('SELECT COUNT(*) FROM job_time_logs WHERE job_id=? AND event_type="complete"', [(int)$job['id']]) > 0,
'Outtake Tasks' => checklist_complete((int)$job['id'], 'outtake'),
'Final Photos' => photos_complete((int)$job['id'], 'outtake'),
'Submit' => $job['status'] === 'Ready For Review',
];
echo '';
foreach ($steps as $label => $done) echo '' . e($label) . ' ';
echo '
';
}
function lifecycle_bar(string $currentStatus): void
{
$statuses = ['Scheduled','Assigned','Accepted','Intake Started','Intake Complete','Work Started','Paused','Work Complete','Outtake Complete','Ready For Review','Completed'];
$currentIndex = array_search($currentStatus, $statuses, true);
if ($currentIndex === false && $currentStatus === 'Available') $currentIndex = 0;
echo '';
foreach ($statuses as $i => $status) {
$class = $currentStatus === 'Cancelled' ? 'cancelled' : ($i < (int)$currentIndex ? 'done' : ($i === (int)$currentIndex ? 'active' : ''));
echo '' . e($status) . ' ';
}
echo '
';
}
function compact_status_progress(string $currentStatus): void
{
$statuses = ['Scheduled','Assigned','Accepted','Intake Started','Intake Complete','Work Started','Paused','Work Complete','Outtake Complete','Ready For Review','Completed'];
$currentIndex = array_search($currentStatus, $statuses, true);
if ($currentIndex === false && $currentStatus === 'Available') $currentIndex = 0;
$currentIndex = $currentIndex === false ? 0 : (int)$currentIndex;
$next = $statuses[$currentIndex + 1] ?? null;
echo '' . status_badge($currentStatus) . '' . ($next ? 'Next: ' . e($next) : 'No next step') . '
';
foreach ($statuses as $i => $status) {
$class = $i < $currentIndex ? 'done' : ($i === $currentIndex ? 'active' : '');
echo '
Step ' . ($index + 1) . ' of ' . count($steps) . ' ' . e($steps[$active] ?? 'Vehicle Info') . '
';
}
function tech_step_nav(array $job, string $active): void
{
$steps = [
'confirm' => ['Vehicle Info', vehicle_confirmed($job)],
'intake-checklist' => ['Intake Tasks', checklist_complete((int)$job['id'], 'intake')],
'intake-photos' => ['Intake Photos', photos_complete((int)$job['id'], 'intake')],
'timer' => ['Track Time', scalar('SELECT COUNT(*) FROM job_time_logs WHERE job_id=? AND event_type="complete"', [(int)$job['id']]) > 0],
'outtake-checklist' => ['Outtake Tasks', checklist_complete((int)$job['id'], 'outtake')],
'outtake-photos' => ['Final Photos', photos_complete((int)$job['id'], 'outtake')],
'marketing' => ['Marketing / Issues', true],
'submit' => ['Submit', $job['status'] === 'Ready For Review'],
];
echo '';
foreach ($steps as $key => $step) {
$class = trim(($key === $active ? 'active ' : '') . ($step[1] ? 'done' : ''));
echo '' . e($step[0]) . ' ';
}
echo ' ';
}
function vehicle_info_panel(array $job): void
{
echo 'Vehicle Info Confirm the vehicle and enter mileage. VIN is optional.
Dash Lights Select the dash condition. If warning lights are on, V.I.T.A.L. will ask whether the customer was alerted before moving on.
';
if (isset($_GET['notify']) && !empty($_SESSION['pending_dash_lights'][(int)$job['id']])) {
$labels = dash_light_labels($_SESSION['pending_dash_lights'][(int)$job['id']]);
echo '';
}
echo 'Submit Job Submit sends the proof record, photos, checklist, and labor time to manager review.
';
if (!$ready) {
echo 'Required outtake checklist items or photos are still missing.
';
}
echo '' . e($title) . ' Complete only the hands-on tasks for this step. Photos and vehicle info complete themselves when those steps are done.
' . e(ucfirst($stage)) . ' Photos One photo at a time. Take the photo shown, submit it, then the next required photo opens.
';
if ($next) {
echo '' . ($completeCount + 1) . ' of ' . count($required) . '
';
photo_prompt_form($job, $stage, $next, 'Take Photo');
} else {
$nextStep = photo_redirect_step((int)$job['id'], $stage);
echo 'Required photos complete. All required ' . e($stage) . ' proof photos are saved. Continue ';
foreach ($requirements as $req) {
$photo = last_photo((int)$job['id'], $stage, $req['requirement_key']);
$isRequired = (int)$req['is_required'] === 1;
echo '
' . e($req['name']) . ' ' . ($photo ? 'Done' : ($isRequired ? 'Next Up' : 'Optional')) . ' ';
if ($photo) {
echo 'Retake ';
photo_prompt_form($job, $stage, $req, 'Retake Photo');
echo '
';
}
echo '
Work Timer ' . fmt_minutes(active_time_seconds((int)$job['id'], (int)$user['id'])) . '
';
echo 'No photo
';
return '' . e(ucfirst($stage)) . ' ';
foreach (checklist_for_job($jobId, $stage) as $item) {
$resp = row('SELECT * FROM job_checklist_responses WHERE job_id=? AND checklist_item_id=?', [$jobId, $item['id']]);
echo '' . (((int)($resp['checked'] ?? 0) === 1) ? 'Done' : 'Missing') . ': ' . e($item['label']) . ' ' . e($resp['exception_note'] ?? '') . '
';
}
}
function template_selects(?array $edit): string
{
ob_start();
echo 'Intake Checklist';
foreach (query("SELECT * FROM checklist_templates WHERE stage='intake' AND active=1") as $tpl) echo '' . e($tpl['name']) . ' ';
echo ' Outtake Checklist';
foreach (query("SELECT * FROM checklist_templates WHERE stage='outtake' AND active=1") as $tpl) echo '' . e($tpl['name']) . ' ';
echo ' Photo Set';
foreach (query('SELECT * FROM photo_requirement_templates WHERE active=1') as $tpl) echo '' . e($tpl['name']) . ' ';
echo '
';
return ob_get_clean();
}
function jobs_with_missing_requirements(): array
{
$out = [];
foreach (query("SELECT * FROM jobs WHERE status NOT IN ('Scheduled','Available','Assigned','Accepted','Cancelled') ORDER BY updated_at DESC LIMIT 100") as $job) {
foreach (['intake','outtake'] as $stage) {
if (!checklist_complete((int)$job['id'], $stage)) $out[] = ['id' => $job['id'], 'job_title' => $job['job_title'], 'gap' => ucfirst($stage) . ' checklist missing required items'];
if (!photos_complete((int)$job['id'], $stage)) $out[] = ['id' => $job['id'], 'job_title' => $job['job_title'], 'gap' => ucfirst($stage) . ' required photos missing'];
}
}
return $out;
}
) . '){kind=logo}