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/trading/api

Free Space:

10.16 TB

🔧 Quick Actions

✏️ Editing: holds.php

<?php
require_once '../includes/auth.php';
require_once '../config/database.php';

checkAuth();
$business_id = getBusinessId();
$shop_id = getShopId();
$user_id = getUserId();

header('Content-Type: application/json');

try {
    $action = $_GET['action'] ?? '';
    
    switch ($action) {
        case 'get_next_number':
            getNextHoldNumber();
            break;
        case 'save':
            saveHold();
            break;
        case 'list':
            listHolds();
            break;
        case 'get':
            getHold();
            break;
        case 'delete':
            deleteHold();
            break;
        default:
            echo json_encode(['success' => false, 'message' => 'Invalid action: ' . $action]);
    }
} catch (Exception $e) {
    error_log("Holds API Error: " . $e->getMessage());
    echo json_encode(['success' => false, 'message' => 'Server error occurred']);
}

function getNextHoldNumber() {
    global $pdo, $business_id, $shop_id;
    
    $year_month = date('Ym');
    $prefix = 'HOLD' . $year_month . '-';
    
    $sql = "SELECT hold_number
            FROM held_invoices
            WHERE business_id = ?
              AND shop_id = ?
              AND hold_number LIKE ?
            ORDER BY CAST(SUBSTRING_INDEX(hold_number, '-', -1) AS UNSIGNED) DESC
            LIMIT 1";
    
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$business_id, $shop_id, $prefix . '%']);
    $last = $stmt->fetch();
    
    $seq = 1;
    if ($last && isset($last['hold_number'])) {
        $last_num = (int)substr($last['hold_number'], strlen($prefix));
        $seq = $last_num + 1;
    }
    
    $hold_number = $prefix . str_pad($seq, 4, '0', STR_PAD_LEFT);
    
    echo json_encode([
        'success' => true,
        'hold_number' => $hold_number
    ]);
}

function listHolds() {
    global $pdo, $business_id, $shop_id, $user_id;
    
    $sql = "SELECT 
                h.*,
                COUNT(DISTINCT hi.id) as item_count,
                (SELECT COUNT(*) FROM held_invoices WHERE shop_id = ? AND business_id = ?) as total_count
            FROM held_invoices h
            LEFT JOIN JSON_TABLE(h.cart_items, '$[*]' COLUMNS(
                id INT PATH '$.product_id'
            )) hi ON 1=1
            WHERE h.shop_id = ? AND h.business_id = ?
            GROUP BY h.id
            ORDER BY h.created_at DESC";
    
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$shop_id, $business_id, $shop_id, $business_id]);
    $holds = $stmt->fetchAll();
    
    // Clean up expired holds
    cleanupExpiredHolds();
    
    echo json_encode([
        'success' => true,
        'holds' => $holds,
        'total' => count($holds)
    ]);
}

function cleanupExpiredHolds() {
    global $pdo, $business_id, $shop_id;
    
    $sql = "DELETE FROM held_invoices 
            WHERE expiry_at < NOW() 
            AND shop_id = ? 
            AND business_id = ?";
    
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$shop_id, $business_id]);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: holds.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation