Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.37.1.lve.el8.x86_64

PHP Version:

8.0.30

User:

u885320773

Directory:

/home/u885320773/domains/sugatu.in/public_html/process

Free Space:

2.65 TB

🔧 Quick Actions

✏️ Editing: submit_custom_enquiry.php

<?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' => false, 'message' => 'Empty request body']);
    exit;
}

$data = json_decode($raw, true);
if (!$data) {
    http_response_code(400);
    echo json_encode(['success' => false, 'message' => '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' => false, 'message' => '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' => false, 'message' => '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->autocommit(false);

try {
    // Insert master enquiry
    $stmt = $conn->prepare(
        "INSERT INTO custom_enquiries (combokitid, combokittitle, customer_name, customer_email, customer_phone, customer_pincode, subtotal, discount_percent, total, created_at)
         VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    );
    if (!$stmt) throw new Exception('DB prepare failed (enquiry): ' . $conn->error);

$combokitid_param = intval($combokitid);
    $stmt->bind_param('issssdddss', $combokitid_param, $combokittitle, $name, $email, $phone, $pincode, $subtotal, $discountPercent, $total, $created_at);
    if (!$stmt->execute()) throw new Exception('DB execute failed (enquiry): ' . $stmt->error);

$enquiry_id = $stmt->insert_id;
    $stmt->close();

// Prepare insert for items
    $stmt2 = $conn->prepare(
        "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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    );
    if (!$stmt2) throw new Exception('DB prepare failed (items): ' . $conn->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']) && $it['removed'] ? 1 : 0;
        $replacement_id = isset($it['replacement_id']) && $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->bind_param(
            'iiisdiisss',
            $enquiry_id,
            $cp_id,
            $product_id,
            $product_title,
            $unit_price_used,
            $quantity,
            $removed,
            $replacement_id,
            $replacement_title,
            $alternates_json
        );

if (!$stmt2->execute()) {
            throw new Exception('DB execute failed (item insert): ' . $stmt2->error);
        }
    }
    $stmt2->close();

// Build HTML email body (replacement_title displayed if present)
    $body = "<h3>New Customized Enquiry</h3>";
    $body .= "<p><strong>Name:</strong> ".htmlspecialchars($name)."<br>";
    $body .= "<strong>Email:</strong> ".htmlspecialchars($email)."<br>";
    $body .= "<strong>Phone:</strong> ".htmlspecialchars($phone)."<br>";
    $body .= "<strong>Pincode:</strong> ".htmlspecialchars($pincode)."</p>";
    $body .= "<h4>Kit: ".htmlspecialchars($combokittitle)." (ID: ".intval($combokitid).")</h4>";

$body .= "<table border='1' cellpadding='6' cellspacing='0' style='border-collapse:collapse; width:100%;'><thead><tr style='background:#f2f2f2;'>
                <th align='left'>Product</th><th align='right'>Price</th><th align='center'>Qty</th><th align='center'>Removed</th></tr></thead><tbody>";

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 .= "<tr>";
        $body .= "<td>".htmlspecialchars($product_display)."</td>";
        $body .= "<td align='right'>₹".htmlspecialchars($price_display)."</td>";
        $body .= "<td align='center'>".htmlspecialchars($qty_display)."</td>";
        $body .= "<td align='center'>".htmlspecialchars($removed_display)."</td>";
        $body .= "</tr>";
    }
    $body .= "</tbody></table>";
    $body .= "<p><strong>Subtotal:</strong> ₹".number_format($subtotal, 2)."<br>";
    $body .= "<strong>Discount:</strong> ".number_format($discountPercent, 2)."%<br>";
    $body .= "<strong>Total:</strong> ₹".number_format($total, 2)."</p>";

// Prepare PHPMailer and send
    $mail = new \PHPMailer\PHPMailer\PHPMailer(true);
    try {
        // SMTP config
        $mail->isSMTP();
        $mail->Host = $smtpHost;
        $mail->Port = $smtpPort;
        $mail->SMTPAuth = true;
        $mail->Username = $smtpUser;
        $mail->Password = $smtpPass;
        // SMTPSecure may be 'ssl' or 'tls'
        $mail->SMTPSecure = $smtpSecure;
        $mail->CharSet = 'UTF-8';

// In some environments you may need to allow self-signed certs:
        $mail->SMTPOptions = [
            'ssl' => [
                'verify_peer' => true,
                'verify_peer_name' => true,
                'allow_self_signed' => false
            ]
        ];

$mail->setFrom($fromEmail, $fromName);
        $mail->addAddress($adminEmail);
        $mail->addReplyTo($email, $name);

$mail->isHTML(true);
        $mail->Subject = "New Customized Enquiry #{$enquiry_id} - " . htmlspecialchars($combokittitle);
        $mail->Body = $body;
        $mail->AltBody = strip_tags(str_replace(['<br>','<br/>','</p>','</tr>','</td>'],' ',$body));

// Send email
        if (!$mail->send()) {
            // throw to catch block
            throw new Exception('Mail send failed: ' . $mail->ErrorInfo);
        }
    } catch (Exception $mailEx) {
        // If you prefer to still commit DB even when mail fails, change below to comment rollback.
        $conn->rollback();
        error_log('submit_custom_enquiry mail error: ' . $mailEx->getMessage());
        http_response_code(500);
        echo json_encode(['success' => false, 'message' => 'Mail error: ' . $mailEx->getMessage()]);
        exit;
    }

// If we reach here, everything succeeded: commit DB
    $conn->commit();

echo json_encode(['success' => true, 'message' => 'Enquiry submitted successfully']);
    exit;

} catch (Exception $ex) {
    if ($conn) $conn->rollback();
    error_log('submit_custom_enquiry error: ' . $ex->getMessage());
    http_response_code(500);
    echo json_encode(['success' => false, 'message' => 'Server error: ' . $ex->getMessage()]);
    exit;
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: submit_custom_enquiry.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation