prepare("SELECT u.* FROM user_tokens ut JOIN users u ON u.id = ut.user_id WHERE ut.token = ? AND ut.expires_at > NOW() AND u.is_active = 1"); $ts->execute([$token]); $user = $ts->fetch(); if (!$user) { http_response_code(401); die('Unauthorised'); } } else { $user = requireAuth(); $db = getDB(); } $instanceId = (int)($_GET['instance_id'] ?? 0); $pdfType = $_GET['type'] ?? 'submission'; // submission | blank if (!$instanceId && $pdfType === 'submission') die('Instance ID required'); $templateId = (int)($_GET['template_id'] ?? 0); // ── Fetch data ──────────────────────────────────────────────── if ($pdfType === 'submission' && $instanceId) { $iStmt = $db->prepare(" SELECT ci.*, t.name AS template_name, t.description AS template_description, t.linked_type, u.full_name AS assigned_to_name, cb.full_name AS completed_by_name, v.registration AS vehicle_reg, CONCAT(v.make, ' ', v.model) AS vehicle_name FROM checklist_instances ci LEFT JOIN checklist_templates t ON t.id = ci.template_id LEFT JOIN users u ON u.id = ci.user_id LEFT JOIN users cb ON cb.id = ci.completed_by LEFT JOIN fleet_vehicles v ON v.id = ci.vehicle_id WHERE ci.id = ? "); $iStmt->execute([$instanceId]); $instance = $iStmt->fetch(); if (!$instance) die('Instance not found'); $templateId = $instance['template_id']; } $tStmt = $db->prepare("SELECT * FROM checklist_templates WHERE id = ?"); $tStmt->execute([$templateId]); $template = $tStmt->fetch(); if (!$template) die('Template not found'); $items = $db->prepare(" SELECT ti.*, cii.answer_bool, cii.answer_text, cii.note, cii.image_filename, cii.photo_filename, cii.completed_at FROM checklist_template_items ti LEFT JOIN checklist_instance_items cii ON cii.instance_id = ? AND cii.template_item_id = ti.id WHERE ti.template_id = ? ORDER BY ti.sort_order ASC, ti.id ASC "); $items->execute([$instanceId ?? 0, $templateId]); $allItems = $items->fetchAll(); // Fetch all images for this instance from multi-image table $imagesByItem = []; if ($instanceId) { $imgStmt = $db->prepare(" SELECT template_item_id, filename FROM checklist_item_images WHERE instance_id = ? ORDER BY uploaded_at ASC "); $imgStmt->execute([$instanceId]); foreach ($imgStmt->fetchAll() as $img) { $imagesByItem[$img['template_item_id']][] = $img['filename']; } // Fallback: if no multi-image rows, pull legacy single image_filename foreach ($allItems as $it) { if (empty($imagesByItem[$it['id']]) && !empty($it['image_filename'])) { $imagesByItem[$it['id']][] = $it['image_filename']; } } } // Company logo — build absolute URL from the stored relative path $logoStmt = $db->prepare("SELECT setting_value FROM settings WHERE setting_key = 'company_logo' LIMIT 1"); $logoStmt->execute(); $logoRaw = $logoStmt->fetchColumn() ?: null; // Convert relative path (e.g. "uploads/settings/logo.png") to an absolute URL // so the browser can load it regardless of where this PHP file sits. $logoUrl = null; if ($logoRaw) { $scheme = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? 'https' : 'http'; $host = $_SERVER['HTTP_HOST'] ?? ''; // App root = two directories up from api/checklists/ $appRoot = rtrim(dirname(dirname(dirname($_SERVER['SCRIPT_NAME']))), '/'); $logoUrl = $scheme . '://' . $host . $appRoot . '/' . ltrim($logoRaw, '/'); } // Company name $nameStmt = $db->prepare("SELECT setting_value FROM settings WHERE setting_key = 'company_name' LIMIT 1"); $nameStmt->execute(); $companyName = $nameStmt->fetchColumn() ?: 'Elegant Work'; function h($s) { return htmlspecialchars($s ?? '', ENT_QUOTES); } $isBlank = ($pdfType === 'blank'); $statusColor = '#16a34a'; $statusLabel = 'Completed'; if (!$isBlank && isset($instance)) { $statusMap = ['pending' => ['#d97706','Pending'], 'in_progress' => ['#0284c7','In Progress'], 'completed' => ['#16a34a','Completed'], 'missed' => ['#dc2626','Missed']]; [$statusColor, $statusLabel] = $statusMap[$instance['status'] ?? ''] ?? ['#6b7280','Unknown']; } header('Content-Type: text/html; charset=utf-8'); ?> <?= h($template['name']) ?> — Checklist <?= $isBlank ? 'Form' : 'Report' ?>
Logo
Instance #
—
Total Questions
Answered
Yes
No
0): ?>
Photos
Notes
Checklist Questions ()
$item): ?>
*
✓ Yes ✗ No
✓ Yes ✗ No
📝 Note:
$imgFile): ?>
Photo <?= $idx + 1 ?> 1): ?>
Photo
📷 Image: — attach photo here
Completed By
Full Name & Signature
Date & Time
DD/MM/YYYY · HH:MM
· Checklist System Generated: