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

🔧 Quick Actions

✏️ Editing: ajax-customers.php

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

if (!isset($_POST['action']) || $_POST['action'] !== 'fetch') {
    echo json_encode(['error' => 'Invalid action']);
    exit;
}

$draw   = (int)($_POST['draw'] ?? 1);
$start  = (int)($_POST['start'] ?? 0);
$length = (int)($_POST['length'] ?? 10);
$search = $_POST['search']['value'] ?? '';
$category = $_POST['category'] ?? '';
$status   = $_POST['status'] ?? '';

$sql = "SELECT id, customer_name, mobile_number, email, customer_location, 
               business_name, business_category, status, created_at as created_on, 
               updated_at as last_activity, gstin, notes 
        FROM customers";

$countSql = "SELECT COUNT(*) FROM customers";

$params = [];
$types  = '';

if ($search !== '') {
    $like = "%$search%";
    $sql      .= " AND (customer_name LIKE ? OR mobile_number LIKE ? OR business_name LIKE ? OR email LIKE ? OR notes LIKE ?)";
    $countSql .= " AND (customer_name LIKE ? OR mobile_number LIKE ? OR business_name LIKE ? OR email LIKE ? OR notes LIKE ?)";
    $params = array_merge($params, [$like, $like, $like, $like, $like]);
    $types .= 'sssss';
}

if ($category !== '') {
    $sql      .= " AND business_category = ?";
    $countSql .= " AND business_category = ?";
    $params[] = $category;
    $types   .= 's';
}

if ($status !== '') {
    $sql      .= " AND status = ?";
    $countSql .= " AND status = ?";
    $params[] = $status;
    $types   .= 's';
}

// Total filtered
$stmt = $conn->prepare($countSql);
if ($params) $stmt->bind_param($types, ...$params);
$stmt->execute();
$totalFiltered = $stmt->get_result()->fetch_array()[0] ?? 0;

// Data + pagination
$sql .= " ORDER BY id DESC LIMIT ?, ?";
$params[] = $start;
$params[] = $length;
$types   .= 'ii';

$stmt = $conn->prepare($sql);
$stmt->bind_param($types, ...$params);
$stmt->execute();
$res = $stmt->get_result();

$data = [];
while ($row = $res->fetch_assoc()) {
    $row['created_on'] = $row['created_on'] ? date('M j, Y g:i A', strtotime($row['created_on'])) : '-';
    $row['last_activity'] = $row['last_activity'] ? date('M j, Y g:i A', strtotime($row['last_activity'])) : '-';
    $data[] = $row;
}

$totalAll = $conn->query("SELECT COUNT(*) FROM customers")->fetch_array()[0];

ob_end_clean();
echo json_encode([
    "draw"            => $draw,
    "recordsTotal"    => (int)$totalAll,
    "recordsFiltered" => (int)$totalFiltered,
    "data"            => $data
]);
exit;

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ajax-customers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation