Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/silverconchawavepoolresortandhotel.com/public_html/admin/main

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: get_sales_data.php

<?php
// get_sales_data.php

// Ensure the necessary headers for JSON response
header('Content-Type: application/json');
include('../controller/config.php');

// Get the parameters from the URL
$date = isset($_GET['date']) ? $_GET['date'] : '';
$salesType = isset($_GET['sales_type']) ? $_GET['sales_type'] : '';

// Ensure that both parameters are received
if (!$date || !$salesType) {
    echo json_encode(['error' => 'Missing required parameters']);
    exit;
}

// Initialize SQL query based on the selected sales type
if ($salesType == 'cottage_sales') {
    $sql = "SELECT * FROM cottage_sales WHERE DATE(c_sales_date) = ?";
    $salesCode = "Cottage Sales";
} else if ($salesType == 'sales') {
    $sql = "SELECT * FROM sales, room_booking WHERE sales.rb_id = room_booking.rb_id and DATE(date) = ?";
    $salesCode = "Room Sales";
} else {
    echo json_encode(['error' => 'Invalid sales type']);
    exit;
}

// Prepare the SQL statement to prevent SQL injection
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $date);

// Execute the query
$stmt->execute();
$result = $stmt->get_result();

// Check if we got any records
$salesData = [];
$totalSales = 0;

while ($row = $result->fetch_assoc()) {
    $salesData[] = [
        'id' => $row['c_sales_id'] ?? $row['sales_id'], // Use the appropriate ID
        'book_number' => $row['room_book_num'] ?? $row['reservation_number'], // Use the appropriate ID
        'date' => $row['c_sales_date'] ?? $row['date'],
        'sales_type' => $salesCode,
        'amount' => number_format($row['total'], 2)

];

$totalSales += $row['total'];
}

// Send the response
echo json_encode([
    'totalSales' => $totalSales,
    'sales' => $salesData
]);

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: get_sales_data.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation