&1'; exec($cmd, $output, $exitCode); @unlink($tmpHtml); if ($exitCode !== 0 || !file_exists($tmpPdf)) { error_log('[EWG PDF] wkhtmltopdf failed (exit ' . $exitCode . '): ' . implode(' | ', $output)); @unlink($tmpPdf); return null; } return $tmpPdf; } // ── Find wkhtmltopdf binary ─────────────────────────────── function _findWkhtmltopdf(): ?string { $candidates = [ '/usr/bin/wkhtmltopdf', '/usr/local/bin/wkhtmltopdf', '/opt/bin/wkhtmltopdf', ]; foreach ($candidates as $c) { if (is_executable($c)) return $c; } // Try PATH $which = shell_exec('which wkhtmltopdf 2>/dev/null'); return ($which !== null && trim($which) !== '') ? trim($which) : null; } // ── Build the full HTML string for a job card ───────────── function _buildJobCardHtml(PDO $db, int $jobId, string $type): ?string { $isClient = $type === 'client'; // Fetch job card $stmt = $db->prepare(" SELECT jc.*, c.company_name AS client_name, c.vat_no AS client_vat, u.full_name AS assigned_name, v.registration AS vehicle_reg, v.make AS vehicle_make, v.model AS vehicle_model, v.cost_per_km, v.quote_rate_per_km FROM job_cards jc LEFT JOIN clients c ON c.id = jc.client_id LEFT JOIN users u ON u.id = jc.assigned_to LEFT JOIN fleet_vehicles v ON v.id = jc.vehicle_id WHERE jc.id = ? "); $stmt->execute([$jobId]); $jc = $stmt->fetch(); if (!$jc) return null; // Report $rStmt = $db->prepare("SELECT r.*, u.full_name AS submitted_by FROM job_card_reports r LEFT JOIN users u ON u.id = r.submitted_by WHERE r.job_card_id = ?"); $rStmt->execute([$jobId]); $report = $rStmt->fetch(); // Team $tStmt = $db->prepare(" SELECT u.id AS user_id, u.full_name, 'Lead Technician' AS role FROM users u WHERE u.id = (SELECT assigned_to FROM job_cards WHERE id = ?) AND u.id IS NOT NULL UNION SELECT u2.id, u2.full_name, COALESCE(NULLIF(jct.role,''), 'Technician') AS role FROM job_card_technicians jct JOIN users u2 ON u2.id = jct.user_id WHERE jct.job_card_id = ? AND jct.user_id != (SELECT assigned_to FROM job_cards WHERE id = ?) "); $tStmt->execute([$jobId, $jobId, $jobId]); $techs = $tStmt->fetchAll(); // Time logs $tlStmt = $db->prepare("SELECT tl.*, u.full_name AS user_name FROM job_card_time_logs tl JOIN users u ON u.id = tl.user_id WHERE tl.job_card_id = ? ORDER BY tl.event_time ASC"); $tlStmt->execute([$jobId]); $timeLogs = $tlStmt->fetchAll(); // Notes $nStmt = $db->prepare("SELECT jcn.*, u.full_name AS user_name FROM job_card_notes jcn JOIN users u ON u.id = jcn.user_id WHERE jcn.job_card_id = ? AND jcn.is_private = 0 ORDER BY jcn.created_at ASC"); $nStmt->execute([$jobId]); $notes = $nStmt->fetchAll(); // Slips $slStmt = $db->prepare("SELECT s.*, u.full_name AS captured_by FROM slips s LEFT JOIN users u ON u.id = s.user_id WHERE s.job_card_id = ? ORDER BY s.slip_date"); $slStmt->execute([$jobId]); $slips = $slStmt->fetchAll(); // Stock $stStmt = $db->prepare("SELECT st.*, si.name AS item_name, si.unit, si.sku FROM stock_transactions st JOIN stock_items si ON si.id = st.stock_item_id WHERE st.job_card_id = ? AND st.transaction_type IN ('issue_jobcard','return') ORDER BY st.transaction_date"); $stStmt->execute([$jobId]); $stockItems = $stStmt->fetchAll(); // Net stock $stockNetMap = []; foreach ($stockItems as $si) { $key = $si['stock_item_id'] . '_' . $si['unit_cost']; $mult = $si['transaction_type'] === 'return' ? -1 : 1; if (!isset($stockNetMap[$key])) { $stockNetMap[$key] = ['item_name' => $si['item_name'], 'sku' => $si['sku'] ?? '', 'unit' => $si['unit'] ?? '', 'unit_cost' => (float)$si['unit_cost'], 'net_qty' => 0, 'net_total' => 0]; } $stockNetMap[$key]['net_qty'] += $mult * (float)$si['quantity']; $stockNetMap[$key]['net_total'] += $mult * (float)$si['unit_cost'] * (float)$si['quantity']; } $stockNetItems = array_values(array_filter($stockNetMap, fn($r) => $r['net_qty'] != 0)); // Images — embedded as base64 $imgStmt = $db->prepare("SELECT * FROM job_card_images WHERE job_card_id = ? ORDER BY created_at ASC"); $imgStmt->execute([$jobId]); $images = $imgStmt->fetchAll(); // Labour $defaultDays = 21.67; $defaultHours = 8.0; try { foreach ($db->query("SELECT setting_key, setting_value FROM settings WHERE setting_group IN ('hr','finance')")->fetchAll() as $s) { if ($s['setting_key'] === 'working_days_per_month') $defaultDays = (float)$s['setting_value']; if ($s['setting_key'] === 'working_hours_per_day') $defaultHours = (float)$s['setting_value']; } } catch (Exception $ignored) {} // Calc segments (simple version) $drivingMin = 0; $workingMin = 0; $prevLog = null; $state = null; foreach ($timeLogs as $log) { if ($prevLog) { $mins = round((strtotime($log['event_time']) - strtotime($prevLog['event_time'])) / 60); if ($state === 'driving') $drivingMin += $mins; elseif ($state === 'working') $workingMin += $mins; } $et = $log['event_type']; if (in_array($et, ['depart','resume_travel'])) $state = 'driving'; elseif (in_array($et, ['start_work','resume_work'])) $state = 'working'; elseif (in_array($et, ['pause_work','pause_travel','arrive_base','depart_site','completed','internal_complete','invoiced'])) $state = null; $prevLog = $log; } $totalBillableMin = $drivingMin + $workingMin; $labourRows = []; $totalLabourCost = 0; $teamForLabour = !empty($techs) ? $techs : []; foreach ($teamForLabour as $tm) { $tid = (int)$tm['user_id']; $r2 = $db->prepare("SELECT es.basic_salary, es.salary_type, COALESCE(e.days_per_month,?) AS days_pm, COALESCE(e.hours_per_day,?) AS hours_pd FROM users u LEFT JOIN employees e ON e.user_id=u.id LEFT JOIN employee_salaries es ON es.employee_id=e.id WHERE u.id=? ORDER BY es.effective_date DESC LIMIT 1"); $r2->execute([$defaultDays, $defaultHours, $tid]); $r2 = $r2->fetch(); $hourlyRate = 0; if ($r2) { $dpm = (float)($r2['days_pm'] ?: $defaultDays); $hpd = (float)($r2['hours_pd'] ?: $defaultHours); if ($r2['salary_type'] === 'hourly') $hourlyRate = (float)$r2['basic_salary']; elseif ($r2['salary_type'] === 'monthly') { $mh = $dpm * $hpd; $hourlyRate = $mh > 0 ? round((float)$r2['basic_salary'] / $mh, 4) : 0; } elseif ($r2['salary_type'] === 'daily') $hourlyRate = $hpd > 0 ? round((float)$r2['basic_salary'] / $hpd, 4) : 0; } $techLabour = round(($totalBillableMin / 60) * $hourlyRate, 2); $totalLabourCost += $techLabour; $labourRows[] = ['name' => $tm['full_name'], 'role' => $tm['role'] ?? 'Technician', 'hourly_rate' => round($hourlyRate,2), 'driving_hrs' => round($drivingMin/60,2), 'working_hrs' => round($workingMin/60,2), 'total_hrs' => round($totalBillableMin/60,2), 'labour_cost' => $techLabour]; } $totalLabourCost = round($totalLabourCost, 2); $odoStart = (int)$jc['odo_start']; $odoEnd = (int)$jc['odo_end']; $kmTravelled = ($odoStart && $odoEnd) ? max(0, $odoEnd - $odoStart) : 0; $travelCost = $kmTravelled * (float)($jc['cost_per_km'] ?? 0); $slipsTotal = array_sum(array_column($slips, 'amount')); $consumablesCost = 0; foreach ($stockNetItems as $si) $consumablesCost += $si['net_total']; // Company settings $sets = []; try { foreach ($db->query("SELECT setting_key, setting_value FROM settings WHERE setting_group='general'")->fetchAll() as $s) { $sets[$s['setting_key']] = $s['setting_value']; } } catch (Exception $ignored) {} $company = $sets['company_name'] ?? 'Elegant Work'; $logoPath = $sets['company_logo'] ?? null; $logoBase64 = null; if ($logoPath) { // Resolve from document root $base = rtrim($_SERVER['DOCUMENT_ROOT'] ?? dirname(__DIR__, 2), '/'); $logoAbsPath = $base . '/' . ltrim($logoPath, '/'); if (file_exists($logoAbsPath)) { $ext = strtolower(pathinfo($logoAbsPath, PATHINFO_EXTENSION)); $mime = ['jpg'=>'image/jpeg','jpeg'=>'image/jpeg','png'=>'image/png','webp'=>'image/webp','svg'=>'image/svg+xml'][$ext] ?? 'image/png'; $logoBase64 = 'data:' . $mime . ';base64,' . base64_encode(file_get_contents($logoAbsPath)); } } $statusLabels = ['draft'=>'Draft','assigned'=>'Assigned','travelling'=>'Travelling','on_site'=>'On Site','working'=>'Working','completed'=>'Completed','internal_complete'=>'Complete','invoiced'=>'Invoiced','no_charge'=>'No Charge','cancelled'=>'Cancelled']; $statusLabel = $statusLabels[$jc['status']] ?? ucfirst($jc['status']); $pageTitle = $isClient ? 'Job Completion Certificate' : 'Internal Job Card Report'; // Inline helpers (can't use global functions — might conflict with pdf.php) $fmtDate = fn($d) => $d ? date('d M Y', strtotime($d)) : '—'; $fmtDt = fn($d) => $d ? date('d M Y H:i', strtotime($d)) : '—'; $fmtR = fn($n) => 'R ' . number_format((float)$n, 2); $esc = fn($s) => htmlspecialchars($s ?? '', ENT_QUOTES); ob_start(); ?> <?= $esc($pageTitle) ?> — <?= $esc($jc['job_number']) ?>
<?= $esc($company) ?>
Generated:
Job Details
Job Title
Client
Job Type
Priority
Site
Address
Scheduled
Completed
Invoice No.
Invoice Amount
Work Performed
Parts & Materials Used
ItemSKUQtyUnit
Client Sign-Off
Signed By
Satisfied
Signature
0 || $kmTravelled > 0): ?>
Cost Summary
0): ?> 0): ?> 0): ?> 0): ?> 0): ?>
CategoryAmount
Labour ( hrs)
Travel ( km)
Consumables / Stock
Expense Slips
Total Cost
Invoice Amount
Notes
DateByNote
· ·