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/menswear/includes

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: log-helper.php

<?php
function logPurchaseOrderAction($conn, $po_id, $action_type, $description, $old_values = null, $new_values = null, $changed_fields = null) {
    // Always disable foreign key checks for safety
    $conn->query("SET FOREIGN_KEY_CHECKS=0");
    
    try {
        // Check if logs table exists
        $table_check = $conn->query("SHOW TABLES LIKE 'purchase_order_logs'");
        if ($table_check->num_rows == 0) {
            // Create the logs table without any foreign keys
            $create_table_sql = "
                CREATE TABLE purchase_order_logs (
                    log_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                    purchase_order_id INT(11) NOT NULL,
                    action_type ENUM('created','updated','status_changed','payment_updated','item_added','item_updated','item_removed','delivery_updated','cancelled','completed') NOT NULL,
                    action_description TEXT NOT NULL,
                    old_values JSON DEFAULT NULL,
                    new_values JSON DEFAULT NULL,
                    changed_fields VARCHAR(500) DEFAULT NULL,
                    performed_by VARCHAR(100) DEFAULT 'System',
                    ip_address VARCHAR(45) DEFAULT NULL,
                    user_agent VARCHAR(255) DEFAULT NULL,
                    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                    INDEX (purchase_order_id),
                    INDEX (action_type),
                    INDEX (created_at)
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
            ";
            if (!$conn->query($create_table_sql)) {
                error_log("Failed to create purchase_order_logs table: " . $conn->error);
                $conn->query("SET FOREIGN_KEY_CHECKS=1");
                return false;
            }
        }

$stmt = $conn->prepare("
            INSERT INTO purchase_order_logs 
            (purchase_order_id, action_type, action_description, old_values, new_values, changed_fields, performed_by, ip_address, user_agent)
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
        ");
        
        if (!$stmt) {
            throw new Exception("Failed to prepare statement: " . $conn->error);
        }
        
        $performed_by = 'System';
        $ip_address = $_SERVER['REMOTE_ADDR'] ?? '';
        $user_agent = substr($_SERVER['HTTP_USER_AGENT'] ?? '', 0, 255);
        
        $old_json = $old_values ? json_encode($old_values, JSON_UNESCAPED_UNICODE) : null;
        $new_json = $new_values ? json_encode($new_values, JSON_UNESCAPED_UNICODE) : null;
        
        $stmt->bind_param("issssssss", 
            $po_id, $action_type, $description, $old_json, $new_json, $changed_fields, $performed_by, $ip_address, $user_agent
        );
        
        $result = $stmt->execute();
        
        if (!$result) {
            // If there's still an error, try one more approach - insert without performed_by
            $stmt->close();
            
            $stmt = $conn->prepare("
                INSERT INTO purchase_order_logs 
                (purchase_order_id, action_type, action_description, old_values, new_values, changed_fields, ip_address, user_agent)
                VALUES (?, ?, ?, ?, ?, ?, ?, ?)
            ");
            
            if ($stmt) {
                $stmt->bind_param("isssssss", 
                    $po_id, $action_type, $description, $old_json, $new_json, $changed_fields, $ip_address, $user_agent
                );
                $result = $stmt->execute();
            }
        }
        
        if ($stmt) $stmt->close();
        
        $conn->query("SET FOREIGN_KEY_CHECKS=1");
        return $result;
        
    } catch (Exception $e) {
        $conn->query("SET FOREIGN_KEY_CHECKS=1");
        error_log("Logging error - PO: {$po_id}, Action: {$action_type}, Error: " . $e->getMessage());
        return false;
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: log-helper.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation