api/_enquiry_email.php

2026-11-02 07:18:02 · 13,836 bytes · 230 lines
Where the things you mentioned are

currency	line 54
reply	line 117, 127, 192
call	line 129, 213
view	line 216
price	line 84, 104, 160, 162
The file

Press COPY and paste it in chat. I need it whole — the buttons and the price are built across several places.
<?php
/**
 * =============================================================================
 *  EMAIL ENQUIRY  --  subiect + continut (HTML si text) pentru contact_submit.php
 *  Se urca pe ADMIN, in:  public_html/api/_enquiry_email.php
 * =============================================================================
 *  Subiect:  Enquiry #48213 - 2019 BMW 3 Series 320d M Sport - Company Name
 *            Enquiry #48213 - Contact form - Company Name   (fara masina)
 * =============================================================================
 */

function ee_h($s) {
    return htmlspecialchars((string)($s ?? ''), ENT_QUOTES, 'UTF-8');
}

/** Un singur rand, fara CR/LF (nu se pot injecta headere prin subiect). */
function ee_line($s) {
    return trim(preg_replace('/[\r\n\t]+/', ' ', (string)($s ?? '')));
}

/** Culoarea temei, validata; text alb sau negru pe ea, dupa luminozitate. */
function ee_colors($theme) {
    $c = trim((string)$theme);
    if (!preg_match('/^#([0-9a-f]{3}|[0-9a-f]{6})$/i', $c)) $c = '#0d6efd';
    if (strlen($c) === 4) $c = '#' . $c[1] . $c[1] . $c[2] . $c[2] . $c[3] . $c[3];
    [$r, $g, $b] = [hexdec(substr($c, 1, 2)), hexdec(substr($c, 3, 2)), hexdec(substr($c, 5, 2))];
    $lum = (0.299 * $r + 0.587 * $g + 0.114 * $b) / 255;
    return [$c, $lum > 0.62 ? '#111827' : '#ffffff'];
}

/**
 * Poza principala a masinii, ca URL absolut. Returneaza null pana confirmam
 * unde e salvata poza (coloana / tabela) -- vezi api/vehicle.php.
 */
function ee_vehicle_cover(array $vehicle) {
    return null;
}

/**
 * @param array      $site    randul din tabela sites
 * @param array|null $vehicle randul din tabela vehicles (sau null la formularul de contact)
 * @param array      $d       ref, name, email, phone, message
 * @return array ['subject' => ..., 'text' => ..., 'html' => ...]
 */
function enquiry_email_build(array $site, $vehicle, array $d) {
    $company = ee_line($site['company_name'] ?: $site['domain']);
    $domain  = ee_line($site['domain']);
    [$accent, $onAccent] = ee_colors($site['theme_color'] ?? '');
    $logo    = upload_url($site['logo_path'] ?? '', 'logos');

    // The satellite's jurisdiction decides the currency and which clock the
    // dealer is reading. A US dealer should not be told a UK time.
    $isUs     = ((string)($site['jurisdiction'] ?? 'uk') === 'us');
    $currency = $isUs ? '$' : '£';
    $tzName   = $isUs ? 'America/New_York' : 'Europe/London';
    $tzLabel  = $isUs ? 'ET' : 'UK time';

    $now = new DateTime('now', new DateTimeZone($tzName));
    $received = $now->format('d M Y, H:i');

    $ref   = $d['ref'];
    $name  = ee_line($d['name']);
    $email = ee_line($d['email']);
    $phone = ee_line($d['phone']);
    $msg   = (string)$d['message'];
    $first = strtok($name, ' ') ?: $name;

    /* ----------------------------- masina ----------------------------- */
    $car = null;
    if ($vehicle) {
        $title = ee_line($vehicle['title'] ?? '');
        if ($title === '') $title = ee_line(trim(($vehicle['make'] ?? '') . ' ' . ($vehicle['model'] ?? '') . ' ' . ($vehicle['variant'] ?? '')));
        $specs = [];
        if (!empty($vehicle['year']))         $specs['Year']    = $vehicle['year'];
        if (isset($vehicle['mileage']) && $vehicle['mileage'] !== '' && $vehicle['mileage'] !== null)
                                              $specs['Mileage'] = number_format((int)$vehicle['mileage']) . ' mi';
        if (!empty($vehicle['fuel']))         $specs['Fuel']    = $vehicle['fuel'];
        if (!empty($vehicle['transmission'])) $specs['Gearbox'] = $vehicle['transmission'];
        if (!empty($vehicle['body_type']))    $specs['Body']    = $vehicle['body_type'];
        if (!empty($vehicle['color']))        $specs[$isUs ? 'Color' : 'Colour'] = $vehicle['color'];

        $car = [
            'title' => $title !== '' ? $title : 'Vehicle #' . (int)$vehicle['id'],
            'price' => (isset($vehicle['price']) && (float)$vehicle['price'] > 0) ? $currency . number_format((float)$vehicle['price'], 2) : '',
            'reg'   => strtoupper(ee_line($vehicle['registration_number'] ?? '')),
            'specs' => $specs,
            'url'   => !empty($vehicle['slug'])
                       ? 'https://' . $domain . '/index.php?' . http_build_query(['page' => 'vehicle', 'slug' => $vehicle['slug']])
                       : '',
            'image' => ee_vehicle_cover($vehicle),
            'id'    => (int)$vehicle['id'],
        ];
    }

    /* ----------------------------- subiect ----------------------------- */
    $subject = 'Enquiry #' . $ref . ' - ' . ($car ? $car['title'] : 'Contact form') . ' - ' . $company;

    /* ----------------------------- text simplu ----------------------------- */
    $t  = "NEW ENQUIRY #$ref\n";
    $t .= str_repeat('=', 44) . "\n\n";
    if ($car) {
        $t .= "VEHICLE\n";
        $t .= $car['title'] . "\n";
        $line = array_filter([$car['price'], $car['reg'] ? 'Reg ' . $car['reg'] : '']);
        if ($line) $t .= implode('  |  ', $line) . "\n";
        if ($car['specs']) $t .= implode(' · ', $car['specs']) . "\n";
        if ($car['url'])   $t .= $car['url'] . "\n";
        $t .= "\n";
    }
    $t .= "CUSTOMER\n";
    $t .= "Name:   $name\n";
    $t .= "Email:  $email\n";
    $t .= "Phone:  " . ($phone !== '' ? $phone : 'not provided') . "\n\n";
    $t .= "MESSAGE\n" . $msg . "\n\n";
    $t .= str_repeat('-', 44) . "\n";
    $t .= "Received $received ($tzLabel) via $domain\n";
    $t .= "Reply to this email to answer $first directly.\n";

    /* ----------------------------- HTML ----------------------------- */
    $label = function ($txt) {
        return '<div style="font-size:11px;line-height:1;color:#6b7280;text-transform:uppercase;letter-spacing:1px;font-weight:700;margin:0 0 10px">' . $txt . '</div>';
    };
    // pe o culoare de tema deschisa (ex. galben) textul colorat nu se citeste pe alb
    $ink  = $onAccent === '#ffffff' ? $accent : '#111827';
    $link = 'color:' . $ink . ';text-decoration:none;font-weight:600';

    $replyHref = 'mailto:' . rawurlencode($email) . '?subject='
               . rawurlencode('Re: ' . ($car ? $car['title'] : $company) . ' (Enquiry #' . $ref . ')');
    $telHref   = 'tel:' . preg_replace('/[^0-9+]/', '', $phone);

    // antet: logo sau numele firmei
    $brand = $logo
        ? '<img src="' . ee_h($logo) . '" alt="' . ee_h($company) . '" height="40" style="display:block;height:40px;width:auto;max-width:220px;border:0">'
        : '<span style="font-size:18px;font-weight:800;color:#111827">' . ee_h($company) . '</span>';

    $html  = '<!doctype html><html><head><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1">';
    $html .= '<title>' . ee_h($subject) . '</title></head>';
    $html .= '<body style="margin:0;padding:0;background:#eef1f5;font-family:-apple-system,BlinkMacSystemFont,\'Segoe UI\',Roboto,Helvetica,Arial,sans-serif;color:#111827">';
    // previzualizarea din inbox (textul gri de langa subiect)
    $html .= '<div style="display:none;max-height:0;overflow:hidden;opacity:0">' . ee_h($name . ($car ? ' is interested in ' . $car['title'] : ' sent a message')) . '</div>';

    $html .= '<table role="presentation" width="100%" cellpadding="0" cellspacing="0" style="background:#eef1f5"><tr><td align="center" style="padding:28px 12px">';
    $html .= '<table role="presentation" width="600" cellpadding="0" cellspacing="0" style="width:100%;max-width:600px;background:#ffffff;border-radius:14px;overflow:hidden;border-top:5px solid ' . $accent . '">';

    // antet
    $html .= '<tr><td style="padding:20px 28px;border-bottom:1px solid #eef0f3">'
           . '<table role="presentation" width="100%" cellpadding="0" cellspacing="0"><tr>'
           . '<td style="vertical-align:middle">' . $brand . '</td>'
           . '<td align="right" style="vertical-align:middle"><span style="display:inline-block;background:' . $accent . ';color:' . $onAccent . ';font-size:11px;font-weight:800;letter-spacing:.8px;text-transform:uppercase;padding:6px 11px;border-radius:999px;white-space:nowrap">'
           . ($car ? 'Vehicle enquiry' : 'New message') . '</span></td>'
           . '</tr></table></td></tr>';

    // masina
    if ($car) {
        if ($car['image']) {
            $html .= '<tr><td style="padding:0"><img src="' . ee_h($car['image']) . '" width="600" alt="' . ee_h($car['title']) . '" style="display:block;width:100%;max-width:600px;height:auto;border:0"></td></tr>';
        }
        $html .= '<tr><td style="padding:24px 28px 6px">' . $label('Vehicle');
        $html .= '<div style="font-size:23px;line-height:1.25;font-weight:800;color:#111827">' . ee_h($car['title']) . '</div>';
        if ($car['price'] || $car['reg']) {
            $html .= '<table role="presentation" cellpadding="0" cellspacing="0" style="margin-top:10px"><tr>';
            if ($car['price']) $html .= '<td style="padding-right:14px;font-size:21px;font-weight:800;color:' . $ink . ';vertical-align:middle">' . ee_h($car['price']) . '</td>';
            if ($car['reg'])   $html .= '<td style="vertical-align:middle"><span style="display:inline-block;background:#f7d33b;color:#111;border:1px solid #d8b21d;border-radius:5px;padding:4px 10px;font-size:15px;font-weight:800;letter-spacing:1.5px;font-family:\'Arial Black\',Arial,sans-serif;white-space:nowrap">' . ee_h($car['reg']) . '</span></td>';
            $html .= '</tr></table>';
        }
        if ($car['specs']) {
            $html .= '<div style="margin-top:14px;line-height:1">';
            foreach ($car['specs'] as $k => $val) {
                $html .= '<span style="display:inline-block;margin:0 6px 7px 0;background:#f2f4f7;border-radius:999px;padding:6px 12px;font-size:12.5px;line-height:1.2;color:#374151;white-space:nowrap">'
                       . '<span style="color:#6b7280">' . ee_h($k) . '</span>&nbsp; <strong>' . ee_h($val) . '</strong></span>';
            }
            $html .= '</div>';
        }
        $html .= '</td></tr>';
    }

    // referinta + data
    $html .= '<tr><td style="padding:' . ($car ? '12px' : '24px') . ' 28px 4px">'
           . '<table role="presentation" width="100%" cellpadding="0" cellspacing="0" style="background:#f8fafc;border:1px solid #e9edf2;border-radius:10px"><tr>'
           . '<td style="padding:13px 16px;font-size:12px;color:#6b7280">Reference<br><strong style="display:inline-block;margin-top:3px;font-size:17px;color:#111827;letter-spacing:.5px">#' . ee_h($ref) . '</strong></td>'
           . '<td align="right" style="padding:13px 16px;font-size:12px;color:#6b7280">Received (' . ee_h($tzLabel) . ')<br><strong style="display:inline-block;margin-top:3px;font-size:15px;color:#111827">' . ee_h($received) . '</strong></td>'
           . '</tr></table></td></tr>';

    // client
    $row = function ($k, $v) {
        return '<tr><td style="padding:12px 0;border-bottom:1px solid #eef0f3;width:90px;font-size:13px;color:#6b7280;vertical-align:top">' . $k . '</td>'
             . '<td style="padding:12px 0;border-bottom:1px solid #eef0f3;font-size:15px;color:#111827;font-weight:600;word-break:break-word">' . $v . '</td></tr>';
    };
    $html .= '<tr><td style="padding:22px 28px 0">' . $label('Customer')
           . '<table role="presentation" width="100%" cellpadding="0" cellspacing="0">'
           . $row('Name', ee_h($name))
           . $row('Email', '<a href="mailto:' . ee_h($email) . '" style="' . $link . '">' . ee_h($email) . '</a>')
           . $row('Phone', $phone !== ''
                ? '<a href="' . ee_h($telHref) . '" style="' . $link . '">' . ee_h($phone) . '</a>'
                : '<span style="color:#9ca3af;font-weight:400">Not provided</span>')
           . '</table></td></tr>';

    // mesaj
    $html .= '<tr><td style="padding:22px 28px 0">' . $label('Message')
           . '<div style="background:#f8fafc;border-left:4px solid ' . $accent . ';border-radius:0 10px 10px 0;padding:15px 18px;font-size:15px;line-height:1.65;color:#1f2937;word-break:break-word">'
           . nl2br(ee_h($msg)) . '</div></td></tr>';

    // butoane
    $btn = function ($href, $txt, $primary) use ($accent, $onAccent) {
        $style = $primary
            ? 'background:' . $accent . ';color:' . $onAccent . ';border:1px solid ' . $accent
            : 'background:#ffffff;color:#111827;border:1px solid #d1d5db';
        return '<td style="padding:0 8px 8px 0"><a href="' . ee_h($href) . '" style="display:inline-block;' . $style . ';border-radius:9px;padding:12px 20px;font-size:14px;font-weight:700;text-decoration:none;white-space:nowrap">' . $txt . '</a></td>';
    };
    // One button only. The message already carries Reply-To with the customer's
    // address, so the mail client's own Reply answers them directly - a second
    // button doing the same thing, less reliably, only caused confusion. The
    // phone number is still a tel: link in the Customer table above.
    if ($car && !empty($car['url'])) {
        $html .= '<tr><td style="padding:24px 28px 26px"><table role="presentation" cellpadding="0" cellspacing="0"><tr>'
               . $btn($car['url'], 'View vehicle &rarr;', true)
               . '</tr></table></td></tr>';
    }

    // subsol
    $html .= '<tr><td style="background:#f8fafc;border-top:1px solid #eef0f3;padding:15px 28px;font-size:12px;line-height:1.6;color:#8a93a0">'
           . 'Sent from the ' . ($car ? 'vehicle enquiry' : 'contact') . ' form on <a href="https://' . ee_h($domain) . '" style="color:#6b7280">' . ee_h($domain) . '</a> &middot; ' . ee_h($company)
           . '<br>Just hit <strong>Reply</strong> to answer ' . ee_h($first) . ' directly.'
           . '</td></tr>';

    $html .= '</table></td></tr></table></body></html>';

    return ['subject' => $subject, 'text' => $t, 'html' => $html];
}
Delete this file once you have copied it.