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/rutzotech.com/public_html/bill

Free Space:

10.25 TB

🔧 Quick Actions

✏️ Editing: saveshop.php

<?php
// saveshop.php
require_once 'db_connection.php';

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

// Debug logging
error_log("saveshop.php called with method: " . $_SERVER['REQUEST_METHOD']);
error_log("POST data: " . print_r($_POST, true));

// Check if request is POST
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    echo json_encode(['success' => false, 'message' => 'Invalid request method. Use POST.']);
    exit;
}

// Check database connection
if (!$conn) {
    echo json_encode(['success' => false, 'message' => 'Database connection failed']);
    exit;
}

try {
    $conn->begin_transaction();
    
    $response = ['success' => false, 'message' => 'Operation failed'];
    
    // Get data from POST
    $shop_id = isset($_POST['shop_id']) ? intval($_POST['shop_id']) : 0;
    $shop_name = isset($_POST['shop_name']) ? trim($_POST['shop_name']) : '';
    $phone = isset($_POST['phone']) ? trim($_POST['phone']) : '';
    $email = isset($_POST['email']) ? trim($_POST['email']) : '';
    $address = isset($_POST['address']) ? trim($_POST['address']) : '';
    $gst_number = isset($_POST['gst_number']) ? trim($_POST['gst_number']) : '';
    $cgst_percent = isset($_POST['cgst_percent']) ? floatval($_POST['cgst_percent']) : 0;
    $sgst_percent = isset($_POST['sgst_percent']) ? floatval($_POST['sgst_percent']) : 0;
    
    error_log("Processing shop: Name=$shop_name, ShopID=$shop_id");
    
    // Validate required fields
    if (empty($shop_name)) {
        throw new Exception('Shop name is required');
    }
    
    if (empty($address)) {
        throw new Exception('Address is required');
    }
    
    if ($cgst_percent <= 0 || $sgst_percent <= 0) {
        throw new Exception('CGST and SGST percentages must be greater than 0');
    }
    
    // Validate GST number format if provided
    if (!empty($gst_number)) {
        // Basic GST validation - can be adjusted based on requirements
        $gst_number = strtoupper($gst_number);
        if (!preg_match('/^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}$/', $gst_number)) {
            // For demo, just log but don't block
            error_log("GST number format warning: $gst_number");
        }
    }
    
    if ($shop_id == 0) {
        // INSERT new shop
        $stmt = $conn->prepare("INSERT INTO shops (shop_name, phone, email, address, gst_number, cgst_percent, sgst_percent, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, NOW())");
        if (!$stmt) {
            throw new Exception('Prepare failed: ' . $conn->error);
        }
        
        $stmt->bind_param("sssssdd", $shop_name, $phone, $email, $address, $gst_number, $cgst_percent, $sgst_percent);
        
        if ($stmt->execute()) {
            $new_shop_id = $conn->insert_id;
            $response = ['success' => true, 'message' => 'Shop added successfully', 'shop_id' => $new_shop_id];
            error_log("Shop added successfully with ID: $new_shop_id");
        } else {
            throw new Exception('Failed to add shop: ' . $stmt->error);
        }
        $stmt->close();
    } else {
        // UPDATE existing shop
        $stmt = $conn->prepare("UPDATE shops SET shop_name = ?, phone = ?, email = ?, address = ?, gst_number = ?, cgst_percent = ?, sgst_percent = ?, updated_at = NOW() WHERE id = ?");
        if (!$stmt) {
            throw new Exception('Prepare failed: ' . $conn->error);
        }
        
        $stmt->bind_param("sssssddi", $shop_name, $phone, $email, $address, $gst_number, $cgst_percent, $sgst_percent, $shop_id);
        
        if ($stmt->execute()) {
            $response = ['success' => true, 'message' => 'Shop updated successfully'];
            error_log("Shop updated successfully: ID=$shop_id");
        } else {
            throw new Exception('Failed to update shop: ' . $stmt->error);
        }
        $stmt->close();
    }
    
    $conn->commit();
    
} catch (Exception $e) {
    if (isset($conn) && $conn) {
        $conn->rollback();
    }
    $response = ['success' => false, 'message' => $e->getMessage()];
    error_log("Error in saveshop.php: " . $e->getMessage());
}

echo json_encode($response);

if (isset($conn) && $conn) {
    $conn->close();
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: saveshop.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation