byp4a55 professor6T9

Linux premium133.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
LiteSpeed
162.0.232.69

File Name : fetch_queue_sms.php

<?php
session_start();
header('Content-Type: application/json');
header("Access-Control-Allow-Origin: * ");

require_once '../pdo_config.php';

if (!isset($_SESSION['username'])) {
    http_response_code(401);
    echo json_encode(["error" => "Unauthorized."]);
    exit;
}

try {
    // Get user
    $stmt = $conn->prepare("SELECT * FROM api_users WHERE user_name = :username");
    $stmt->execute(['username' => $_SESSION['username']]);
    $user = $stmt->fetch(PDO::FETCH_ASSOC);

if (!$user) {
        echo json_encode(["error" => "User not found."]);
        exit;
    }

// Prepare query with optional date filters
    $sql = "SELECT * FROM sms_queue WHERE user_id = :user_id AND status = :status";
    $params = ['user_id' => $user['user_name'], 'status' => 'pending'];

if (!empty($_GET['startDate'])) {
        $sql .= " AND DATE(created_at) >= :startDate";
        $params['startDate'] = $_GET['startDate'];
    }
    if (!empty($_GET['endDate'])) {
        $sql .= " AND DATE(created_at) <= :endDate";
        $params['endDate'] = $_GET['endDate'];
    }

$sql .= " ORDER BY created_at DESC";
    $smsLogs = $conn->prepare($sql);
    $smsLogs->execute($params);
    $logs = $smsLogs->fetchAll(PDO::FETCH_ASSOC);

echo json_encode([
        "success" => true,
        "queues" => $logs
    ]);

} catch (PDOException $e) {
    http_response_code(500);
    echo json_encode(["error" => "Server error: " . $e->getMessage()]);
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	mboniqkj/mboniqkj	0755	2025-11-20 08:50:52
..	dir	-	mboniqkj/mboniqkj	0755	2025-11-20 09:01:08
logs	dir	-	mboniqkj/mboniqkj	0777	2025-07-07 08:11:18
delete_queue_sms.php	text/x-php	1.42 KB	mboniqkj/mboniqkj	0644	2025-07-05 08:48:34
fetch_queue_sms.php	text/x-php	1.42 KB	mboniqkj/mboniqkj	0644	2025-11-20 08:49:10
get_sender_ids.php	text/x-php	1.07 KB	mboniqkj/mboniqkj	0644	2025-11-20 08:49:29
get_single_sms.php	text/x-php	538 B	mboniqkj/mboniqkj	0644	2025-07-07 08:43:02
index.php	application/x-empty	0 B	mboniqkj/mboniqkj	0644	2025-11-20 08:50:52
send_scheduled_sms.php	text/x-php	5.71 KB	mboniqkj/mboniqkj	0644	2025-07-07 08:22:54
send_single_sms.php	text/x-php	1007 B	mboniqkj/mboniqkj	0644	2025-07-03 07:25:06
send_sms.php	text/x-php	6.28 KB	mboniqkj/mboniqkj	0644	2025-07-01 11:36:22
sms_logs.php	text/x-php	1.33 KB	mboniqkj/mboniqkj	0644	2025-07-02 05:37:47
update_sms.php	text/x-php	898 B	mboniqkj/mboniqkj	0644	2025-07-14 09:14:43

Team Anon Force

https://t.me/Professor6T9x