Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/crm

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: update-lead.php

<?php
// update-lead.php
ob_start(); // Capture any accidental output
session_start();
require_once 'includes/db.php';
require_once 'includes/telegram_helper.php';

header('Content-Type: application/json');

// === CONFIG ===
$BOT_TOKEN = "8566838958:AAEMQhva5iFJC2ZFAY-qsp0eVKsg9fbK9kM";
$CHAT_ID = "1203355744";
$telegram = new TelegramHelper($BOT_TOKEN, $CHAT_ID);

// === RESPONSE HELPER ===
function sendResponse($success, $message = '', $extra = []) {
    echo json_encode(array_merge(['success' => $success, 'message' => $message], $extra));
    exit;
}

try {
    if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
        sendResponse(false, 'Invalid request method');
    }

$lead_id = $_POST['lead_id'] ?? null;
    if (!$lead_id || !is_numeric($lead_id)) {
        sendResponse(false, 'Invalid Lead ID');
    }

// === COLLECT & SANITIZE FIELDS ===
    $fields = [
        'customer_name' => $_POST['customer_name'] ?? '',
        'mobile_number' => $_POST['mobile_number'] ?? '',
        'customer_location' => $_POST['customer_location'] ?? '',
        'business_name' => $_POST['business_name'] ?? '',
        'business_category' => $_POST['business_category'] ?? '',
        'lead_status' => $_POST['lead_status'] ?? '',
        'remark' => $_POST['remark'] ?? '',
        'remark_contacted' => $_POST['remark_contacted'] ?? '',
        'callback_eta' => $_POST['callback_eta'] ?? null,
        'remark_qualified' => $_POST['remark_qualified'] ?? '',
        'qualified_callback' => $_POST['qualified_callback'] ?? null,
        'advance_amount' => $_POST['advance_amount'] ?? null,
        'remark_converted' => $_POST['remark_converted'] ?? '',
        'total_amount' => $_POST['total_amount'] ?? null,
        'cloud_amount' => $_POST['cloud_amount'] ?? null,
        'cloud_renewal' => $_POST['cloud_renewal'] ?? null,
        'developers' => $_POST['developers'] ?? null,
        'expected_delivery_date' => $_POST['expected_delivery_date'] ?? null,
        'delivered_date' => $_POST['delivered_date'] ?? null,
    ];

// Required fields
    if (empty($fields['mobile_number']) || empty($fields['business_name']) || empty($fields['lead_status'])) {
        sendResponse(false, 'Required fields missing');
    }

// Format dates
    $fields['callback_eta'] = $fields['callback_eta'] ? date('Y-m-d H:i:s', strtotime($fields['callback_eta'])) : null;
    $fields['qualified_callback'] = $fields['qualified_callback'] ? date('Y-m-d H:i:s', strtotime($fields['qualified_callback'])) : null;

// Convert to float
    foreach (['advance_amount', 'total_amount', 'cloud_amount'] as $f) {
        if ($fields[$f] !== null) {
            $fields[$f] = floatval($fields[$f]);
        }
    }

// === BUILD SQL ===
    $setParts = [];
    $params = [];
    $types = '';
    foreach ($fields as $k => $v) {
        $setParts[] = "`$k` = ?";
        $params[] = $v;
        $types .= is_null($v) ? 's' : (in_array($k, ['advance_amount','total_amount','cloud_amount']) ? 'd' : 's');
    }
    $setParts[] = "`updated_at` = NOW()";
    $params[] = $lead_id;
    $types .= 'i';

$sql = "UPDATE leads SET " . implode(', ', $setParts) . " WHERE id = ?";
    $stmt = $conn->prepare($sql);
    if (!$stmt) {
        throw new Exception('Database prepare failed');
    }

$stmt->bind_param($types, ...$params);
    if (!$stmt->execute()) {
        throw new Exception('Update failed');
    }

// === LOGGING ===
    $log_fields = ['lead_status', 'advance_amount', 'total_amount', 'cloud_amount', 'delivered_date', 'expected_delivery_date'];
    $old = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM leads WHERE id = ?", [$lead_id]))[0] ?? [];
    foreach ($log_fields as $f) {
        if (isset($old[$f]) && $old[$f] != $fields[$f]) {
            $action = in_array($f, ['advance_amount','total_amount','cloud_amount']) ? 'payment_update' : 'status_change';
            $log = $conn->prepare("INSERT INTO leads_logs (lead_id, action, field_name, old_value, new_value, changed_by) VALUES (?, ?, ?, ?, ?, ?)");
            $user = $_SESSION['user'] ?? 'System';
            $log->bind_param("isssss", $lead_id, $action, $f, $old[$f], $fields[$f], $user);
            $log->execute();
        }
    }

// === TELEGRAM ===
    $msg = "Lead Updated #{$lead_id}\n\n";
    $msg .= "Customer: " . ($fields['customer_name'] ?: 'N/A') . "\n";
    $msg .= "Mobile: <code>{$fields['mobile_number']}</code>\n";
    $msg .= "Business: {$fields['business_name']}\n";
    $msg .= "Status: " . ucfirst($fields['lead_status']) . "\n";
    $clean = preg_replace('/[^0-9+]/', '', $fields['mobile_number']);
    $msg .= "\nCall: <a href=\"tel:{$clean}\">{$fields['mobile_number']}</a>";
    $telegram->sendMessage($msg);

sendResponse(true, 'Lead updated successfully!');

} catch (Exception $e) {
    error_log("Update Lead Error: " . $e->getMessage());
    $telegram->sendMessage("Update Failed #{$lead_id}\nError: " . $e->getMessage());
    sendResponse(false, 'Server error occurred');
} finally {
    ob_end_clean(); // Discard any accidental output
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update-lead.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation