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.2 TB

🔧 Quick Actions

✏️ Editing: save_shop.php

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

session_start();

// Check if shop already exists
$check_stmt = $conn->query("SELECT COUNT(*) as shop_count FROM shops");
$check_data = $check_stmt->fetch_assoc();
$shop_exists = ($check_data['shop_count'] > 0);

// If shop already exists, don't allow creating new one
if ($shop_exists) {
    // Get existing shop ID to redirect to edit page
    $existing_shop = $conn->query("SELECT id FROM shops ORDER BY id LIMIT 1");
    $shop = $existing_shop->fetch_assoc();
    $existing_shop_id = $shop['id'] ?? 0;
    
    header("Location: edit_shop.php?id=$existing_shop_id&error=Only one shop is allowed. You can only edit the existing shop.");
    exit;
}

// Check if request is POST
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    header('Location: add_shop.php?error=Invalid request method');
    exit;
}

try {
    // Get data from POST
    $shop_name = trim($_POST['shop_name'] ?? '');
    $phone = trim($_POST['phone'] ?? '');
    $email = trim($_POST['email'] ?? '');
    $address = trim($_POST['address'] ?? '');
    $gst_number = trim($_POST['gst_number'] ?? '');
    $cgst_percent = floatval($_POST['cgst_percent'] ?? 0);
    $sgst_percent = floatval($_POST['sgst_percent'] ?? 0);
    
    // Validate required fields
    if (empty($shop_name)) {
        header('Location: add_shop.php?error=Shop name is required');
        exit;
    }
    
    if (empty($address)) {
        header('Location: add_shop.php?error=Address is required');
        exit;
    }
    
    if ($cgst_percent <= 0 || $sgst_percent <= 0) {
        header('Location: add_shop.php?error=CGST and SGST percentages must be greater than 0');
        exit;
    }
    
    // Validate phone (if provided)
    if (!empty($phone) && !preg_match('/^[0-9]{10}$/', $phone)) {
        header('Location: add_shop.php?error=Phone number must be 10 digits');
        exit;
    }
    
    // Validate email (if provided)
    if (!empty($email) && !filter_var($email, FILTER_VALIDATE_EMAIL)) {
        header('Location: add_shop.php?error=Invalid email address');
        exit;
    }
    
    // Insert new shop
    $stmt = $conn->prepare("INSERT INTO shops (shop_name, phone, email, address, gst_number, cgst_percent, sgst_percent, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, NOW())");
    $stmt->bind_param("sssssdd", $shop_name, $phone, $email, $address, $gst_number, $cgst_percent, $sgst_percent);
    
    if ($stmt->execute()) {
        $new_shop_id = $conn->insert_id;
        header('Location: add_shop.php?success=Shop created successfully! Only one shop is allowed per system.');
    } else {
        header('Location: add_shop.php?error=Failed to create shop: ' . $stmt->error);
    }
    $stmt->close();
    
} catch (Exception $e) {
    header('Location: add_shop.php?error=' . urlencode($e->getMessage()));
}

$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: save_shop.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation