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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: add-supplier.php

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

// Database connection
include('includes/db_connection.php');

// Check if suppliers table exists
$table_check = $conn->query("SHOW TABLES LIKE 'suppliers'");
$suppliers_table_exists = $table_check->num_rows > 0;

// Initialize variables
$supplier_name = $contact_person = $email = $address = $gst_number = '';
$phone = array('', '', '', ''); // Array for 4 phone numbers
$errors = [];
$success_message = '';

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Get form data
    $supplier_name = isset($_POST['supplier_name']) ? trim($_POST['supplier_name']) : '';
    $contact_person = isset($_POST['contact_person']) ? trim($_POST['contact_person']) : '';
    $email = isset($_POST['email']) ? trim($_POST['email']) : '';
    
    // Get phone numbers from array
    for ($i = 0; $i < 4; $i++) {
        $phone[$i] = isset($_POST['phone' . $i]) ? trim($_POST['phone' . $i]) : '';
    }
    
    $address = isset($_POST['address']) ? trim($_POST['address']) : '';
    $gst_number = isset($_POST['gst_number']) ? trim($_POST['gst_number']) : '';

// Validate required fields
    if (empty($supplier_name)) {
        $errors[] = "Supplier name is required!";
    }

if (empty($contact_person)) {
        $errors[] = "Contact person name is required!";
    }

// Check if at least one phone number is provided
    $hasPhone = false;
    $phoneNumbers = array();
    for ($i = 0; $i < 4; $i++) {
        if (!empty($phone[$i])) {
            $hasPhone = true;
            if (!preg_match('/^[0-9]{10}$/', $phone[$i])) {
                $errors[] = "Phone number $i must be exactly 10 digits!";
            } else {
                $phoneNumbers[] = $phone[$i];
            }
        }
    }
    
    // Optional: If you want to require at least one phone number, uncomment below
    // if (!$hasPhone) {
    //     $errors[] = "At least one phone number is required!";
    // }

if (!empty($email) && !filter_var($email, FILTER_VALIDATE_EMAIL)) {
        $errors[] = "Invalid email format!";
    }

if (empty($address)) {
        $errors[] = "Address is required!";
    }

if (!empty($gst_number) && !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)) {
        $errors[] = "Invalid GST number format! Format: 22ABCDE1234F1Z5";
    }

// Check for duplicate phone numbers among the provided ones
    $uniquePhones = array_unique(array_filter($phone));
    if (count($uniquePhones) < count(array_filter($phone))) {
        $errors[] = "Duplicate phone numbers are not allowed!";
    }

// If no validation errors, proceed
    if (empty($errors)) {
        // Check if suppliers table exists
        if (!$suppliers_table_exists) {
            // Create suppliers table if it doesn't exist
            $create_table_sql = "
            CREATE TABLE IF NOT EXISTS suppliers (
                id INT PRIMARY KEY AUTO_INCREMENT,
                supplier_name VARCHAR(255) NOT NULL,
                contact_person VARCHAR(255),
                phone VARCHAR(20),
                phone2 VARCHAR(20),
                phone3 VARCHAR(20),
                phone4 VARCHAR(20),
                email VARCHAR(255),
                address TEXT,
                gst_number VARCHAR(50),
                status ENUM('active', 'inactive') DEFAULT 'active',
                created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
            )";
            
            if ($conn->query($create_table_sql)) {
                $suppliers_table_exists = true;
                $success_message = "Suppliers table created successfully!";
            } else {
                $errors[] = "Error creating suppliers table: " . $conn->error;
            }
        }

if ($suppliers_table_exists) {
            // Check if supplier with any of the phone numbers already exists
            $checkPhones = array_filter($phone); // Remove empty values
            if (!empty($checkPhones)) {
                $placeholders = implode(',', array_fill(0, count($checkPhones), '?'));
                $types = str_repeat('s', count($checkPhones));
                
                $check_stmt = $conn->prepare("SELECT id FROM suppliers WHERE phone IN ($placeholders) OR phone2 IN ($placeholders) OR phone3 IN ($placeholders) OR phone4 IN ($placeholders)");
                $check_stmt->bind_param($types, ...array_merge($checkPhones, $checkPhones, $checkPhones, $checkPhones));
                $check_stmt->execute();
                $check_result = $check_stmt->get_result();
                
                if ($check_result->num_rows > 0) {
                    $errors[] = "Supplier with one of these phone numbers already exists!";
                }
            }
            
            // Check if GST number already exists (if provided)
            if (!empty($gst_number)) {
                $check_gst_stmt = $conn->prepare("SELECT id FROM suppliers WHERE gst_number = ?");
                $check_gst_stmt->bind_param("s", $gst_number);
                $check_gst_stmt->execute();
                $check_gst_result = $check_gst_stmt->get_result();
                
                if ($check_gst_result->num_rows > 0) {
                    $errors[] = "Supplier with this GST number already exists!";
                }
            }

if (empty($errors)) {
                // Insert new supplier with multiple phone numbers
                $stmt = $conn->prepare("INSERT INTO suppliers (
                    supplier_name, contact_person, phone, phone2, phone3, phone4, email, address, gst_number
                ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
                
                $stmt->bind_param(
                    "sssssssss", 
                    $supplier_name, 
                    $contact_person, 
                    $phone[0], 
                    $phone[1], 
                    $phone[2], 
                    $phone[3], 
                    $email, 
                    $address, 
                    $gst_number
                );
                
                if ($stmt->execute()) {
                    $success_message = "Supplier added successfully!";
                    // Clear form
                    $supplier_name = $contact_person = $email = $address = $gst_number = '';
                    $phone = array('', '', '', '');
                } else {
                    $errors[] = "Error adding supplier: " . $conn->error;
                }
            }
        }
    }
}
?>

<!doctype html>
<html lang="en">
<body data-sidebar="dark">

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

<?php include('includes/sidebar.php')?>
            
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
           
            <div class="container-fluid">

<?php if (!empty($errors)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-block-helper me-2"></i>
                        <strong>Please fix the following errors:</strong>
                        <ul class="mb-0 mt-1">
                            <?php foreach ($errors as $error): ?>
                                <li><?php echo $error; ?></li>
                            <?php endforeach; ?>
                        </ul>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                
                <?php if (!empty($success_message)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-check-all me-2"></i>
                        <?php echo $success_message; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<?php if (!$suppliers_table_exists): ?>
                    <div class="alert alert-info alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-information me-2"></i>
                        <strong>Note:</strong> The suppliers table will be created automatically when you add your first supplier.
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title">Supplier Information</h4>
                                    <div>
                                        <a href="suppliers.php" class="btn btn-outline-primary">
                                            <i class="mdi mdi-arrow-left me-1"></i> Back to Suppliers
                                        </a>
                                    </div>
                                </div>

<form method="POST" action="" id="supplierForm">
                                    <div class="row">
                                        
                                        <div class="col-lg-6">
                                            <div class="mb-3">
                                                <label for="supplier_name" class="form-label">Supplier Name <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="supplier_name" name="supplier_name" 
                                                       value="<?php echo htmlspecialchars($supplier_name); ?>" 
                                                       placeholder="Enter supplier company name" required>
                                                <div class="invalid-feedback">Please enter supplier name</div>
                                            </div>

<div class="mb-3">
                                                <label for="contact_person" class="form-label">Contact Person <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="contact_person" name="contact_person" 
                                                       value="<?php echo htmlspecialchars($contact_person); ?>" 
                                                       placeholder="Enter contact person name" required>
                                                <div class="invalid-feedback">Please enter contact person name</div>
                                            </div>

<div class="mb-3">
                                                <label class="form-label">Phone Numbers (Optional)</label>
                                                <?php for ($i = 0; $i < 4; $i++): ?>
                                                    <div class="input-group mb-2">
                                                        <span class="input-group-text">
                                                            <i class="mdi mdi-phone"></i>
                                                        </span>
                                                        <input type="tel" class="form-control phone-input" 
                                                               id="phone<?php echo $i; ?>" 
                                                               name="phone<?php echo $i; ?>" 
                                                               value="<?php echo htmlspecialchars($phone[$i]); ?>" 
                                                               placeholder="Enter phone number <?php echo $i + 1; ?>" 
                                                               maxlength="10">
                                                        <div class="invalid-feedback">Please enter a valid 10-digit phone number</div>
                                                    </div>
                                                <?php endfor; ?>
                                                <small class="form-text text-muted">You can add up to 4 phone numbers. All are optional.</small>
                                            </div>

<div class="mb-3">
                                                <label for="email" class="form-label">Email Address (Optional)</label>
                                                <input type="email" class="form-control" id="email" name="email" 
                                                       value="<?php echo htmlspecialchars($email); ?>" 
                                                       placeholder="Enter email address">
                                                <div class="invalid-feedback">Please enter a valid email address</div>
                                            </div>
                                        </div>

<div class="col-lg-6">
                                            <div class="mb-3">
                                                <label for="gst_number" class="form-label">GST Number (Optional)</label>
                                                <input type="text" class="form-control" id="gst_number" name="gst_number" 
                                                       value="<?php echo htmlspecialchars($gst_number); ?>" 
                                                       placeholder="Enter GST number (22ABCDE1234F1Z5)">
                                                <div class="invalid-feedback">Please enter a valid GST number</div>
                                                <small class="form-text text-muted">Format: 22ABCDE1234F1Z5</small>
                                            </div>

<div class="mb-3">
                                                <label for="address" class="form-label">Address <span class="text-danger">*</span></label>
                                                <textarea class="form-control" id="address" name="address" 
                                                          rows="4" placeholder="Enter complete address" required><?php echo htmlspecialchars($address); ?></textarea>
                                                <div class="invalid-feedback">Please enter supplier address</div>
                                            </div>
                                        </div>
                                    </div>

<div class="row mt-4">
                                        <div class="col-12">
                                            <div class="d-flex gap-2 justify-content-end">
                                                <button type="reset" class="btn btn-light">
                                                    <i class="mdi mdi-refresh me-1"></i> Reset
                                                </button>
                                                <button type="submit" class="btn btn-success">
                                                    <i class="mdi mdi-content-save me-1"></i> Save Supplier
                                                </button>
                                            </div>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Quick Guide</h5>
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="d-flex align-items-center mb-3">
                                            <div class="flex-shrink-0">
                                                <i class="mdi mdi-information text-primary fs-4"></i>
                                            </div>
                                            <div class="flex-grow-1 ms-3">
                                                <h6 class="mb-1">Required Fields</h6>
                                                <p class="text-muted mb-0">Fields marked with <span class="text-danger">*</span> are mandatory</p>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="d-flex align-items-center mb-3">
                                            <div class="flex-shrink-0">
                                                <i class="mdi mdi-phone-multiple text-success fs-4"></i>
                                            </div>
                                            <div class="flex-grow-1 ms-3">
                                                <h6 class="mb-1">Multiple Contacts</h6>
                                                <p class="text-muted mb-0">You can add up to 4 phone numbers, all optional</p>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="d-flex align-items-center mb-3">
                                            <div class="flex-shrink-0">
                                                <i class="mdi mdi-gavel text-warning fs-4"></i>
                                            </div>
                                            <div class="flex-grow-1 ms-3">
                                                <h6 class="mb-1">GST Compliance</h6>
                                                <p class="text-muted mb-0">GST number follows standard Indian format</p>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

<?php include('includes/footer.php')?>
    </div>

</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

// Phone number validation - restrict to numbers only
        phoneInputs.forEach(function(input) {
            input.addEventListener('input', function() {
                this.value = this.value.replace(/[^0-9]/g, '');
                if (this.value.length > 10) {
                    this.value = this.value.slice(0, 10);
                }
                
                // Clear validation when empty
                if (this.value === '') {
                    this.classList.remove('is-invalid', 'is-valid');
                }
            });
            
            // Phone validation on blur
            input.addEventListener('blur', function() {
                if (this.value.trim() !== '') {
                    if (this.value.length !== 10) {
                        this.classList.add('is-invalid');
                        this.classList.remove('is-valid');
                    } else {
                        this.classList.remove('is-invalid');
                        this.classList.add('is-valid');
                    }
                } else {
                    this.classList.remove('is-invalid', 'is-valid');
                }
            });
        });

// GST number validation (auto-uppercase)
        gstInput.addEventListener('input', function() {
            this.value = this.value.toUpperCase();
        });

// Validate GST format on blur
        gstInput.addEventListener('blur', function() {
            if (this.value.trim() !== '') {
                const gstPattern = /^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}$/;
                if (!gstPattern.test(this.value)) {
                    this.classList.add('is-invalid');
                    this.classList.remove('is-valid');
                } else {
                    this.classList.remove('is-invalid');
                    this.classList.add('is-valid');
                }
            } else {
                this.classList.remove('is-invalid', 'is-valid');
            }
        });

// Email validation on blur
        emailInput.addEventListener('blur', function() {
            if (this.value.trim() !== '') {
                const emailPattern = /^[^\s@]+@[^\s@]+\.[^\s@]+$/;
                if (!emailPattern.test(this.value)) {
                    this.classList.add('is-invalid');
                    this.classList.remove('is-valid');
                } else {
                    this.classList.remove('is-invalid');
                    this.classList.add('is-valid');
                }
            } else {
                this.classList.remove('is-invalid', 'is-valid');
            }
        });

// Required field validation on blur
        const requiredFields = form.querySelectorAll('[required]');
        requiredFields.forEach(field => {
            field.addEventListener('blur', function() {
                if (this.value.trim() === '') {
                    this.classList.add('is-invalid');
                    this.classList.remove('is-valid');
                } else {
                    this.classList.remove('is-invalid');
                    this.classList.add('is-valid');
                }
            });
            
            // Clear validation on input
            field.addEventListener('input', function() {
                if (this.value.trim() !== '') {
                    this.classList.remove('is-invalid');
                    this.classList.add('is-valid');
                }
            });
        });

// Check for duplicate phone numbers
        function checkDuplicatePhones() {
            const filledPhones = [];
            let hasDuplicates = false;
            
            phoneInputs.forEach(function(input) {
                if (input.value.trim() !== '') {
                    if (filledPhones.includes(input.value)) {
                        input.classList.add('is-invalid');
                        hasDuplicates = true;
                    } else {
                        filledPhones.push(input.value);
                    }
                }
            });
            
            return hasDuplicates;
        }

// Form submission validation
        form.addEventListener('submit', function(e) {
            let isValid = true;
            
            // Clear all validation states
            const allInputs = form.querySelectorAll('.form-control');
            allInputs.forEach(input => {
                input.classList.remove('is-invalid', 'is-valid');
            });

// Check required fields
            requiredFields.forEach(field => {
                if (!field.value.trim()) {
                    field.classList.add('is-invalid');
                    isValid = false;
                } else {
                    field.classList.add('is-valid');
                }
            });

// Validate phone numbers if provided
            phoneInputs.forEach(input => {
                if (input.value.trim() !== '') {
                    const phonePattern = /^[0-9]{10}$/;
                    if (!phonePattern.test(input.value)) {
                        input.classList.add('is-invalid');
                        isValid = false;
                    } else {
                        input.classList.add('is-valid');
                    }
                }
            });

// Check for duplicate phone numbers
            if (checkDuplicatePhones()) {
                isValid = false;
                alert('Duplicate phone numbers are not allowed!');
            }

// Validate GST if provided
            if (gstInput.value.trim() !== '') {
                const gstPattern = /^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}$/;
                if (!gstPattern.test(gstInput.value)) {
                    gstInput.classList.add('is-invalid');
                    isValid = false;
                } else {
                    gstInput.classList.add('is-valid');
                }
            }

// Validate email if provided
            if (emailInput.value.trim() !== '') {
                const emailPattern = /^[^\s@]+@[^\s@]+\.[^\s@]+$/;
                if (!emailPattern.test(emailInput.value)) {
                    emailInput.classList.add('is-invalid');
                    isValid = false;
                } else {
                    emailInput.classList.add('is-valid');
                }
            }

if (!isValid) {
                e.preventDefault();
                e.stopPropagation();
                
                // Scroll to first error
                const firstError = form.querySelector('.is-invalid');
                if (firstError) {
                    firstError.scrollIntoView({ 
                        behavior: 'smooth', 
                        block: 'center' 
                    });
                    firstError.focus();
                }
            }
        });

// Auto-suggest GST number based on phone area code
        phoneInputs[0].addEventListener('blur', function() {
            if (this.value.length === 10 && !gstInput.value) {
                const areaCode = this.value.substring(0, 2);
                // Generate a sample GST number (in real app, this would be entered by user)
                const randomChars = Math.random().toString(36).substring(2, 7).toUpperCase();
                const randomNums = Math.floor(Math.random() * 10000).toString().padStart(4, '0');
                const sampleGST = `${areaCode}${randomChars}${randomNums}${areaCode}Z5`;
                gstInput.placeholder = `e.g., ${sampleGST}`;
            }
        });

// Auto-fill address based on supplier name (dummy example)
        const supplierNameInput = document.getElementById('supplier_name');
        const addressInput = document.getElementById('address');
        
        supplierNameInput.addEventListener('blur', function() {
            if (this.value && !addressInput.value) {
                addressInput.placeholder = "Please enter complete address for " + this.value;
            }
        });

// Clear form button
        form.addEventListener('reset', function() {
            // Clear all validation states
            const allInputs = form.querySelectorAll('.form-control');
            allInputs.forEach(input => {
                input.classList.remove('is-invalid', 'is-valid');
            });
        });

// Add/Remove phone input button functionality
        document.addEventListener('click', function(e) {
            if (e.target.classList.contains('add-phone-btn')) {
                // Find next empty phone input and focus it
                const emptyPhone = Array.from(phoneInputs).find(input => input.value === '');
                if (emptyPhone) {
                    emptyPhone.focus();
                }
            }
        });

// Keyboard shortcuts
        document.addEventListener('keydown', function(e) {
            // Ctrl + S to save
            if (e.ctrlKey && e.key === 's') {
                e.preventDefault();
                form.dispatchEvent(new Event('submit'));
            }
            
            // Escape to go back
            if (e.key === 'Escape') {
                window.location.href = 'suppliers.php';
            }
            
            // Tab to jump between phone inputs
            if (e.key === 'Tab') {
                const activeElement = document.activeElement;
                if (activeElement.classList.contains('phone-input')) {
                    e.preventDefault();
                    const currentIndex = Array.from(phoneInputs).indexOf(activeElement);
                    if (currentIndex < phoneInputs.length - 1) {
                        phoneInputs[currentIndex + 1].focus();
                    }
                }
            }
        });

// Format GST number with proper spacing
        function formatGSTNumber(input) {
            let value = input.value.replace(/[^0-9A-Z]/gi, '').toUpperCase();
            
            if (value.length >= 2) {
                value = value.substring(0, 2) + value.substring(2);
            }
            if (value.length >= 7) {
                value = value.substring(0, 7) + value.substring(7);
            }
            if (value.length >= 11) {
                value = value.substring(0, 11) + value.substring(11);
            }
            if (value.length >= 13) {
                value = value.substring(0, 13) + value.substring(13);
            }
            if (value.length >= 14) {
                value = value.substring(0, 14) + value.substring(14);
            }
            if (value.length >= 15) {
                value = value.substring(0, 15);
            }
            
            input.value = value;
        }
    });
</script>

</body>

</html>

<?php
// Close database connection
if (isset($conn)) {
    $conn->close();
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-supplier.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation