prepare(" SELECT i.*, p.project_name, p.eloi, p.sample_size, p.industry, p.closed_at FROM invoices i INNER JOIN projects p ON i.project_id = p.id WHERE i.id = ? AND i.client_id = ? "); $stmt->execute([$invoiceId, $_SESSION['client_id']]); $inv = $stmt->fetch(PDO::FETCH_ASSOC); if (!$inv) { header('Location: invoices.php'); exit; } // Load company settings for bank details & footer $settings = []; try { $result = $pdo->query("SELECT setting_key, setting_value FROM company_settings"); while ($row = $result->fetch()) $settings[$row['setting_key']] = $row['setting_value']; } catch (Exception $e) {} $sym = $inv['currency_symbol'] ?? '₹'; $currLabel = ['INR'=>'Indian Rupees','USD'=>'US Dollars','EUR'=>'Euros'][$inv['currency']] ?? $inv['currency']; $isINR = $inv['currency'] === 'INR'; ?>
☎
✉
🌐
| # | Description | Qty | Rate | Amount |
|---|---|---|---|---|
| 1 |
Sample Cost
Online survey fielding & data collection (Avg LOI: min)
|
completes | ||
| 2 |
Respondent Incentive
Panel member incentive payments
|
completes |