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/billing/pawn/ajax

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: get_sales.php

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

// Get filters from POST request
$dateFrom = $_POST['dateFrom'] ?? date('Y-m-d', strtotime('-7 days'));
$dateTo = $_POST['dateTo'] ?? date('Y-m-d');
$type = $_POST['type'] ?? '';
$payment = $_POST['payment'] ?? '';
$business = $_POST['business'] ?? '';
$customer = $_POST['customer'] ?? '';
$invoice = $_POST['invoice'] ?? '';
$status = $_POST['status'] ?? '';

// Get DataTables parameters
$start = $_POST['start'] ?? 0;
$length = $_POST['length'] ?? 25;
$searchValue = $_POST['search']['value'] ?? '';
$orderColumn = $_POST['order'][0]['column'] ?? 0;
$orderDir = $_POST['order'][0]['dir'] ?? 'desc';

// Column mapping for ordering
$columns = [
    0 => 'id',
    1 => 'invoice_number',
    2 => 'created_at',
    3 => 'customer_name',
    4 => 'service_type',
    5 => 'business_name',
    6 => 'items_count',
    7 => 'total',
    8 => 'payment_method',
    9 => 'status'
];

$orderBy = $columns[$orderColumn] ?? 'created_at';
$orderDir = in_array(strtolower($orderDir), ['asc', 'desc']) ? $orderDir : 'desc';

// Build WHERE clause
$whereConditions = ["DATE(i.created_at) BETWEEN '{$dateFrom}' AND '{$dateTo}'"];

if (!empty($type)) {
    $whereConditions[] = "i.service_type = '{$type}'";
}

if (!empty($payment)) {
    $whereConditions[] = "i.payment_method = '{$payment}'";
}

if (!empty($business)) {
    $whereConditions[] = "i.business_id = '{$business}'";
}

if (!empty($customer)) {
    $whereConditions[] = "i.customer_id = '{$customer}'";
}

if (!empty($invoice)) {
    $whereConditions[] = "i.invoice_number LIKE '%{$invoice}%'";
}

if (!empty($status)) {
    $whereConditions[] = "i.status = '{$status}'";
}

// Search condition
if (!empty($searchValue)) {
    $searchConditions = [
        "i.invoice_number LIKE '%{$searchValue}%'",
        "c.name LIKE '%{$searchValue}%'",
        "i.business_name LIKE '%{$searchValue}%'",
        "i.payment_method LIKE '%{$searchValue}%'",
        "i.status LIKE '%{$searchValue}%'"
    ];
    $whereConditions[] = "(" . implode(" OR ", $searchConditions) . ")";
}

$whereClause = !empty($whereConditions) ? "WHERE " . implode(" AND ", $whereConditions) : "";

// Count total records
$countSql = "SELECT COUNT(*) as total FROM invoices i LEFT JOIN customers c ON i.customer_id = c.id {$whereClause}";
$countResult = mysqli_query($conn, $countSql);
$totalRecords = mysqli_fetch_assoc($countResult)['total'];

// Count filtered records
$filteredCountSql = "SELECT COUNT(*) as filtered FROM invoices i LEFT JOIN customers c ON i.customer_id = c.id {$whereClause}";
$filteredResult = mysqli_query($conn, $filteredCountSql);
$filteredRecords = mysqli_fetch_assoc($filteredResult)['filtered'];

// Get data
$sql = "SELECT 
            i.id,
            i.invoice_number,
            DATE_FORMAT(i.created_at, '%d-%m-%Y %h:%i %p') as created_at,
            c.name as customer_name,
            i.service_type,
            i.business_name,
            (SELECT COUNT(*) FROM invoice_items ii WHERE ii.invoice_id = i.id) as items_count,
            i.total,
            i.payment_method,
            COALESCE(i.status, 'completed') as status
        FROM invoices i
        LEFT JOIN customers c ON i.customer_id = c.id
        {$whereClause}
        ORDER BY {$orderBy} {$orderDir}
        LIMIT {$start}, {$length}";

$result = mysqli_query($conn, $sql);
$data = [];

if ($result && mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        $data[] = $row;
    }
}

// Prepare response
$response = [
    'draw' => intval($_POST['draw'] ?? 1),
    'recordsTotal' => intval($totalRecords),
    'recordsFiltered' => intval($filteredRecords),
    'data' => $data
];

echo json_encode($response);

mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: get_sales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation