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

🔧 Quick Actions

✏️ Editing: edit-supplier.php

<?php
// edit-supplier.php
// Edit supplier page with support for multiple phone numbers

include('includes/head.php');
include('includes/db_connection.php');

// Initialize
$errors = [];
$success_message = '';
$supplier = [
    'id' => '',
    'supplier_name' => '',
    'contact_person' => '',
    'phone' => '',
    'phone2' => '',
    'phone3' => '',
    'phone4' => '',
    'email' => '',
    'address' => '',
    'gst_number' => '',
    'status' => 'active'
];

// Ensure we have an ID
if (!isset($_GET['id']) && $_SERVER['REQUEST_METHOD'] !== 'POST') {
    header('Location: suppliers.php');
    exit;
}

// If coming from POST (update or delete) we expect id as hidden field
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $id = isset($_POST['id']) ? (int) $_POST['id'] : 0;

// Delete action
    if (isset($_POST['action']) && $_POST['action'] === 'delete') {
        if ($id > 0) {
            $del_stmt = $conn->prepare("DELETE FROM suppliers WHERE id = ?");
            $del_stmt->bind_param("i", $id);
            if ($del_stmt->execute()) {
                $del_stmt->close();
                $success_message = "Supplier deleted successfully.";
                // Redirect after successful deletion
                echo "<script>setTimeout(function() { window.location.href = 'suppliers.php'; }, 1500);</script>";
            } else {
                $errors[] = "Error deleting supplier: " . $conn->error;
            }
        } else {
            $errors[] = "Invalid supplier ID for deletion.";
        }
    } else {
        // Update action
        $supplier_name = isset($_POST['supplier_name']) ? trim($_POST['supplier_name']) : '';
        $contact_person = isset($_POST['contact_person']) ? trim($_POST['contact_person']) : '';
        
        // Get all phone numbers
        $phones = [];
        for ($i = 0; $i < 4; $i++) {
            $phones[$i] = isset($_POST['phone' . $i]) ? trim($_POST['phone' . $i]) : '';
        }
        
        $email = isset($_POST['email']) ? trim($_POST['email']) : '';
        $address = isset($_POST['address']) ? trim($_POST['address']) : '';
        $gst_number = isset($_POST['gst_number']) ? trim(strtoupper($_POST['gst_number'])) : '';
        $status = isset($_POST['status']) && in_array($_POST['status'], ['active', 'inactive']) ? $_POST['status'] : 'active';

// Basic validation
        if (empty($supplier_name)) $errors[] = "Supplier name is required!";
        if (empty($contact_person)) $errors[] = "Contact person name is required!";
        
        // Phone validation - at least one phone is optional but if provided must be valid
        $hasPhone = false;
        foreach ($phones as $index => $phone) {
            if (!empty($phone)) {
                $hasPhone = true;
                if (!preg_match('/^[0-9]{10}$/', $phone)) {
                    $errors[] = "Phone number " . ($index + 1) . " must be exactly 10 digits!";
                }
            }
        }
        
        // Optional: If you want to require at least one phone number, uncomment below
        // if (!$hasPhone) {
        //     $errors[] = "At least one phone number is required!";
        // }
        
        // Check for duplicate phone numbers among the provided ones
        $uniquePhones = array_unique(array_filter($phones));
        if (count($uniquePhones) < count(array_filter($phones))) {
            $errors[] = "Duplicate phone numbers are not allowed!";
        }

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";
        }

// If no validation errors, check uniqueness and update
        if (empty($errors)) {
            // Check phone uniqueness excluding current supplier
            $checkPhones = array_filter($phones); // Remove empty values
            if (!empty($checkPhones)) {
                $placeholders = implode(',', array_fill(0, count($checkPhones), '?'));
                $types = str_repeat('s', count($checkPhones));
                
                $check_sql = "SELECT id FROM suppliers WHERE id <> ? AND (phone IN ($placeholders) OR phone2 IN ($placeholders) OR phone3 IN ($placeholders) OR phone4 IN ($placeholders))";
                $check_stmt = $conn->prepare($check_sql);
                $check_stmt->bind_param('i' . $types . $types . $types . $types, 
                    $id, 
                    ...array_merge($checkPhones, $checkPhones, $checkPhones, $checkPhones)
                );
                $check_stmt->execute();
                $check_result = $check_stmt->get_result();
                if ($check_result->num_rows > 0) {
                    $errors[] = "One of these phone numbers already exists for another supplier!";
                }
                $check_stmt->close();
            }
            
            // Check GST uniqueness if provided
            if (empty($errors) && !empty($gst_number)) {
                $check_gst_stmt = $conn->prepare("SELECT id FROM suppliers WHERE gst_number = ? AND id <> ?");
                $check_gst_stmt->bind_param("si", $gst_number, $id);
                $check_gst_stmt->execute();
                $check_gst_result = $check_gst_stmt->get_result();
                if ($check_gst_result->num_rows > 0) {
                    $errors[] = "Another supplier with this GST number already exists!";
                }
                $check_gst_stmt->close();
            }

// Do the update
            if (empty($errors)) {
                $update_stmt = $conn->prepare("UPDATE suppliers SET 
                    supplier_name = ?, 
                    contact_person = ?, 
                    phone = ?, 
                    phone2 = ?, 
                    phone3 = ?, 
                    phone4 = ?, 
                    email = ?, 
                    address = ?, 
                    gst_number = ?, 
                    status = ?, 
                    updated_at = CURRENT_TIMESTAMP 
                    WHERE id = ?");
                
                $update_stmt->bind_param(
                    "ssssssssssi", 
                    $supplier_name, 
                    $contact_person, 
                    $phones[0], 
                    $phones[1], 
                    $phones[2], 
                    $phones[3], 
                    $email, 
                    $address, 
                    $gst_number, 
                    $status, 
                    $id
                );
                
                if ($update_stmt->execute()) {
                    $success_message = "Supplier updated successfully!";
                } else {
                    $errors[] = "Error updating supplier: " . $conn->error;
                }
                $update_stmt->close();
            }
        }

// Refill $supplier array for display (to reflect posted data even on errors)
        $supplier = [
            'id' => $id,
            'supplier_name' => htmlspecialchars($supplier_name),
            'contact_person' => htmlspecialchars($contact_person),
            'phone' => htmlspecialchars($phones[0] ?? ''),
            'phone2' => htmlspecialchars($phones[1] ?? ''),
            'phone3' => htmlspecialchars($phones[2] ?? ''),
            'phone4' => htmlspecialchars($phones[3] ?? ''),
            'email' => htmlspecialchars($email),
            'address' => htmlspecialchars($address),
            'gst_number' => htmlspecialchars($gst_number),
            'status' => $status
        ];
    }
} else {
    // GET - fetch supplier details
    $id = (int) $_GET['id'];
    if ($id <= 0) {
        header('Location: suppliers.php');
        exit;
    }

$stmt = $conn->prepare("SELECT id, supplier_name, contact_person, phone, phone2, phone3, phone4, email, address, gst_number, status FROM suppliers WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $res = $stmt->get_result();
    if ($res->num_rows === 0) {
        $stmt->close();
        // Not found
        header('Location: suppliers.php?msg=notfound');
        exit;
    } else {
        $row = $res->fetch_assoc();
        $supplier = [
            'id' => $row['id'],
            'supplier_name' => htmlspecialchars($row['supplier_name']),
            'contact_person' => htmlspecialchars($row['contact_person']),
            'phone' => htmlspecialchars($row['phone'] ?? ''),
            'phone2' => htmlspecialchars($row['phone2'] ?? ''),
            'phone3' => htmlspecialchars($row['phone3'] ?? ''),
            'phone4' => htmlspecialchars($row['phone4'] ?? ''),
            'email' => htmlspecialchars($row['email'] ?? ''),
            'address' => htmlspecialchars($row['address']),
            'gst_number' => htmlspecialchars($row['gst_number'] ?? ''),
            'status' => $row['status'] ?? 'active'
        ];
    }
    $stmt->close();
}
?>

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

<div id="layout-wrapper">

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

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?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; ?>

<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">
                                        Edit Supplier
                                        <?php if ($supplier['id']): ?>
                                            <span class="text-muted fs-6">#<?php echo $supplier['id']; ?></span>
                                        <?php endif; ?>
                                    </h4>
                                    <div>
                                        <a href="suppliers-list.php" class="btn btn-outline-primary">
                                            <i class="mdi mdi-arrow-left me-1"></i> Back to Suppliers
                                        </a>
                                    </div>
                                </div>

<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 $supplier['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 $supplier['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++): 
                                                    $phone_field = $i === 0 ? 'phone' : 'phone' . ($i + 1);
                                                    $phone_value = $supplier[$phone_field] ?? '';
                                                ?>
                                                    <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 $phone_value; ?>" 
                                                               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 $supplier['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 $supplier['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 $supplier['address']; ?></textarea>
                                                <div class="invalid-feedback">Please enter supplier address</div>
                                            </div>

<div class="mb-3">
                                                <label for="status" class="form-label">Status</label>
                                                <select class="form-select" id="status1" name="status">
                                                    <option value="active" <?php echo ($supplier['status'] === 'active') ? 'selected' : ''; ?>>Active</option>
                                                    <option value="inactive" <?php echo ($supplier['status'] === 'inactive') ? 'selected' : ''; ?>>Inactive</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>

<div class="row mt-4">
                                        <div class="col-12 d-flex justify-content-between">
                                            <div>
                                                <button type="button" id="deleteBtn" class="btn btn-danger" <?php echo !$supplier['id'] ? 'disabled' : ''; ?>>
                                                    <i class="mdi mdi-delete me-1"></i> Delete Supplier
                                                </button>
                                            </div>

<div class="d-flex gap-2">
                                                <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> Update Supplier
                                                </button>
                                            </div>
                                        </div>
                                    </div>
                                </form>

<form method="POST" id="deleteForm" style="display:none;">
                                    <input type="hidden" name="id" value="<?php echo $supplier['id']; ?>">
                                    <input type="hidden" name="action" value="delete">
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

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

// Restrict phone to digits only
    phoneInputs.forEach(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);
        });
    });

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

// Validation 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');
        }
    });

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');
        }
    });

// Phone validation on blur
    phoneInputs.forEach(input => {
        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');
            }
        });
    });

// 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.addEventListener('submit', function(e) {
        let isValid = true;
        const allInputs = form.querySelectorAll('.form-control');
        allInputs.forEach(input => input.classList.remove('is-invalid', 'is-valid'));

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!');
        }

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');
        }

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();
            const firstError = form.querySelector('.is-invalid');
            if (firstError) {
                firstError.scrollIntoView({ behavior: 'smooth', block: 'center' });
                firstError.focus();
            }
        }
    });

// Delete flow
    const deleteBtn = document.getElementById('deleteBtn');
    const deleteForm = document.getElementById('deleteForm');
    deleteBtn.addEventListener('click', function() {
        if (confirm('Are you sure you want to delete this supplier? This action cannot be undone.')) {
            deleteForm.submit();
        }
    });

// Clear all phone inputs button functionality
    const clearPhonesBtn = document.createElement('button');
    clearPhonesBtn.type = 'button';
    clearPhonesBtn.className = 'btn btn-sm btn-outline-secondary mt-2';
    clearPhonesBtn.innerHTML = '<i class="mdi mdi-close-circle me-1"></i> Clear All Phone Numbers';
    clearPhonesBtn.addEventListener('click', function() {
        if (confirm('Clear all phone numbers?')) {
            phoneInputs.forEach(input => {
                input.value = '';
                input.classList.remove('is-valid', 'is-invalid');
            });
        }
    });
    
    // Add clear button after phone inputs
    const phoneSection = document.querySelector('.phone-input').closest('.mb-3');
    if (phoneSection) {
        phoneSection.appendChild(clearPhonesBtn);
    }

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

</body>
</html>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-supplier.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation