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/thirumalaistores

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: ajax_barcode.php

<?php
include('includes/db.php');

header('Content-Type: application/json; charset=utf-8');

$action = $_GET['action'] ?? $_POST['action'] ?? '';

if ($action === 'find_product') {
    $barcode = $_GET['barcode'] ?? '';
    
    if (empty($barcode)) {
        echo json_encode(['success' => false, 'message' => 'Barcode is empty']);
        exit;
    }
    
    $stmt = $conn->prepare("SELECT id, product_name, product_code as barcode, customer_price as price, quantity FROM products WHERE product_code = ? LIMIT 1");
    $stmt->bind_param('s', $barcode);
    $stmt->execute();
    $result = $stmt->get_result();
    
    if ($result->num_rows > 0) {
        $product = $result->fetch_assoc();
        echo json_encode([
            'success' => true,
            'product' => $product
        ]);
    } else {
        echo json_encode(['success' => false, 'message' => 'Product not found']);
    }
    exit;
}

if ($action === 'update_barcode') {
    $product_id = $_POST['product_id'] ?? 0;
    $new_barcode = $_POST['new_barcode'] ?? '';
    
    if ($product_id <= 0 || empty($new_barcode)) {
        echo json_encode(['success' => false, 'message' => 'Invalid product ID or barcode']);
        exit;
    }
    
    // Check if barcode already exists for another product
    $check_stmt = $conn->prepare("SELECT id, product_name FROM products WHERE product_code = ? AND id != ?");
    $check_stmt->bind_param('si', $new_barcode, $product_id);
    $check_stmt->execute();
    $check_result = $check_stmt->get_result();
    
    if ($check_result->num_rows > 0) {
        $existing = $check_result->fetch_assoc();
        echo json_encode([
            'success' => false, 
            'message' => "Barcode already assigned to: " . $existing['product_name']
        ]);
        exit;
    }
    
    // Update the barcode
    $update_stmt = $conn->prepare("UPDATE products SET product_code = ? WHERE id = ?");
    $update_stmt->bind_param('si', $new_barcode, $product_id);
    
    if ($update_stmt->execute()) {
        // Log the barcode change
        $log_details = [
            'product_id' => $product_id,
            'new_barcode' => $new_barcode,
            'action' => 'BARCODE_UPDATED'
        ];
        $log_json = json_encode($log_details, JSON_UNESCAPED_UNICODE);
        
        $log_sql = "INSERT INTO product_logs (product_id, action, details, created_at) 
                    VALUES (?, 'BARCODE_UPDATED', ?, NOW())";
        $log_stmt = $conn->prepare($log_sql);
        $log_stmt->bind_param('is', $product_id, $log_json);
        $log_stmt->execute();
        
        echo json_encode([
            'success' => true, 
            'message' => 'Barcode updated successfully'
        ]);
    } else {
        echo json_encode(['success' => false, 'message' => 'Failed to update barcode']);
    }
    exit;
}

echo json_encode(['success' => false, 'message' => 'Invalid action']);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ajax_barcode.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation