prepare(" SELECT d.*, c.firstname as cf, c.lastname as cl, c.email as ce, c.phone as cp, c.address as ca FROM devis d LEFT JOIN clients c ON c.id = d.client_id WHERE d.id = ? AND d.user_id = ? "); $stmt->execute([$devis_id, $me['id']]); $devis = $stmt->fetch(); if (!$devis) { header('Location: index.php'); exit; } $lignes_stmt = $db->prepare("SELECT * FROM devis_lignes WHERE devis_id=? ORDER BY id ASC"); $lignes_stmt->execute([$devis_id]); $lignes = $lignes_stmt->fetchAll(); $html = '
' . htmlspecialchars($me['company_name'] ?? 'Mon Entreprise') . '
' . htmlspecialchars($me['firstname'] ?? '') . '
' . htmlspecialchars($me['phone'] ?? '') . '
' . htmlspecialchars($me['address'] ?? '') . '
' . ($me['siret'] ? '
SIRET : ' . htmlspecialchars($me['siret']) . '
' : '') . '
DEVIS N° ' . htmlspecialchars($devis['numero']) . '
Date : ' . date('d/m/Y', strtotime($devis['created_at'])) . '
Client
' . htmlspecialchars(($devis['cf'] ?? '') . ' ' . ($devis['cl'] ?? '')) . '
' . ($devis['ce'] ? htmlspecialchars($devis['ce']) . '
' : '') . ' ' . ($devis['cp'] ? htmlspecialchars($devis['cp']) : '') . '
' . ($devis['description'] ? '
Description

' . nl2br(htmlspecialchars($devis['description'])) . '

' : '') . '
Détail des travaux
'; foreach ($lignes as $l) { $html .= ''; } $html .= '
Désignation Quantité Prix unitaire HT Total HT
' . htmlspecialchars($l['description']) . ' ' . number_format($l['quantite'], 2, ',', ' ') . ' ' . number_format($l['prix_unitaire'], 2, ',', ' ') . ' € ' . number_format($l['total'], 2, ',', ' ') . ' €
Total HT' . number_format($devis['montant_ht'], 2, ',', ' ') . ' €
TVA (20%)' . number_format($devis['montant_ht'] * 0.2, 2, ',', ' ') . ' €
TOTAL TTC' . number_format($devis['montant_ttc'], 2, ',', ' ') . ' €
' . htmlspecialchars($me['company_name'] ?? '') . ' — ' . htmlspecialchars($me['address'] ?? '') . ' ' . ($me['siret'] ? '— SIRET : ' . htmlspecialchars($me['siret']) : '') . '
'; $mpdf = new \Mpdf\Mpdf(['margin_top'=>15,'margin_bottom'=>15,'margin_left'=>15,'margin_right'=>15]); $mpdf->SetTitle('Devis ' . $devis['numero']); $mpdf->WriteHTML($html); $mpdf->Output('Devis_' . $devis['numero'] . '.pdf', 'D');