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.28 TB

🔧 Quick Actions

✏️ Editing: ajax-callbacks.php

<?php
require_once 'includes/db.php';
header('Content-Type: application/json');

$response = [
    'draw' => intval($_POST['draw'] ?? 1),
    'recordsTotal' => 0,
    'recordsFiltered' => 0,
    'data' => [],
    'stats' => ['today'=>0, 'upcoming'=>0, 'overdue'=>0, 'done_today'=>0]
];

try {
    $search = $_POST['search_value'] ?? '';
    $from   = $_POST['from'] ?? '';
    $to     = $_POST['to'] ?? '';
    $id     = $_POST['id'] ?? null;

$where = "(lead_status='contacted' AND callback_eta IS NOT NULL) OR (lead_status='qualified' AND qualified_callback IS NOT NULL)";
    $params = []; $types = '';

if ($search !== '') {
        $where .= " AND (customer_name LIKE ? OR mobile_number LIKE ? OR business_name LIKE ? OR remark LIKE ?)";
        $like = "%$search%";
        $params = array_merge($params, [$like,$like,$like,$like]);
        $types .= 'ssss';
    }
    if ($from !== '') {
        $where .= " AND (DATE(callback_eta)>=? OR DATE(qualified_callback)>=?)";
        $params[] = $from; $params[] = $from; $types .= 'ss';
    }
    if ($to !== '') {
        $where .= " AND (DATE(callback_eta)<=? OR DATE(qualified_callback)<=?)";
        $params[] = $to; $params[] = $to; $types .= 'ss';
    }
    if ($id !== null) {
        $where .= " AND id=?";
        $params[] = $id; $types .= 'i';
    }

// Count
    $c = $conn->prepare("SELECT COUNT(*) FROM leads WHERE $where");
    if ($types) $c->bind_param($types, ...$params);
    $c->execute();
    $response['recordsTotal'] = $response['recordsFiltered'] = $c->get_result()->fetch_row()[0];

// Data
    $sql = "SELECT *, 
            CASE WHEN lead_status='contacted' THEN callback_eta ELSE qualified_callback END AS callback_eta,
            CASE WHEN lead_status='contacted' THEN 'callback_eta' ELSE 'qualified_callback' END AS callback_field
            FROM leads WHERE $where
            ORDER BY callback_eta ASC";
    $stmt = $conn->prepare($sql);
    if ($types) $stmt->bind_param($types, ...$params);
    $stmt->execute();
    $res = $stmt->get_result();

$today = date('Y-m-d');
    $now   = date('Y-m-d H:i:s');
    $data  = [];

while ($r = $res->fetch_assoc()) {
        $eta = $r['callback_eta'];
        $dateOnly = substr($eta,0,10);
        $r['is_today'] = ($dateOnly === $today);
        $r['is_overdue'] = ($eta < $now && $dateOnly === $today);

if ($r['is_today']) {
            $response['stats']['today']++;
            if ($r['is_overdue']) $response['stats']['overdue']++;
        } elseif ($eta > $now) {
            $response['stats']['upcoming']++;
        }

$data[] = $r;
    }

// Done today
    $done = $conn->query("SELECT COUNT(*) FROM leads WHERE DATE(updated_at)='$today' AND lead_status IN ('qualified','converted')");
    $response['stats']['done_today'] = $done->fetch_row()[0];

$response['data'] = $data;

} catch(Exception $e) {
    $response['error'] = $e->getMessage();
}

echo json_encode($response);
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ajax-callbacks.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation