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/vkmobiles/admin

Free Space:

10.29 TB

🔧 Quick Actions

✏️ Editing: add-branch.php

<!doctype html>
<html lang="en">

<?php include('includes/head.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">

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="card-title mb-0">Add New Branch</h5>
                            </div>
                            <div class="card-body">
                                <?php
                                // Include database connection
                                include('includes/db.php');

// Handle form submission
                                if ($_SERVER["REQUEST_METHOD"] == "POST") {
                                    $branch_name    = $conn->real_escape_string($_POST['branch_name']);
                                    $branch_code    = $conn->real_escape_string($_POST['branch_code']);
                                    $address        = $conn->real_escape_string($_POST['address']);
                                    $city           = $conn->real_escape_string($_POST['city']);
                                    $state          = $conn->real_escape_string($_POST['state']);
                                    $pincode        = $conn->real_escape_string($_POST['pincode']);
                                    $country        = $conn->real_escape_string($_POST['country']);
                                    $phone          = $conn->real_escape_string($_POST['phone']);
                                    $email          = $conn->real_escape_string($_POST['email']);
                                    $manager_name   = $conn->real_escape_string($_POST['manager_name']);
                                    $manager_phone  = $conn->real_escape_string($_POST['manager_phone']);
                                    $manager_email  = $conn->real_escape_string($_POST['manager_email']);
                                    $gst_number     = $conn->real_escape_string($_POST['gst_number']);
                                    $opening_date   = $conn->real_escape_string($_POST['opening_date']);
                                    $status         = $conn->real_escape_string($_POST['status']);
                                    $notes          = $conn->real_escape_string($_POST['notes']);
                                    
                                    // New fields for login credentials
                                    $username       = $conn->real_escape_string($_POST['username']);
                                    $password       = $conn->real_escape_string($_POST['password']);
                                    $confirm_password = $conn->real_escape_string($_POST['confirm_password']);

// Validation
                                    $errors = [];

if (empty($branch_name)) $errors[] = "Branch name is required.";
                                    if (empty($branch_code)) $errors[] = "Branch code is required.";
                                    if (empty($address)) $errors[] = "Address is required.";
                                    if (empty($city)) $errors[] = "City is required.";
                                    if (empty($state)) $errors[] = "State is required.";
                                    if (empty($pincode)) $errors[] = "Pincode is required.";
                                    if (empty($country)) $errors[] = "Country is required.";
                                    if (empty($username)) $errors[] = "Username is required.";
                                    if (empty($password)) $errors[] = "Password is required.";
                                    
                                    // Password validation
                                    if ($password !== $confirm_password) {
                                        $errors[] = "Passwords do not match.";
                                    }
                                    if (strlen($password) < 6) {
                                        $errors[] = "Password must be at least 6 characters long.";
                                    }

// Validate branch code uniqueness
                                    $check_sql = "SELECT id FROM branches WHERE branch_code = '$branch_code' LIMIT 1";
                                    if ($conn->query($check_sql)->num_rows > 0) {
                                        $errors[] = "Branch code already exists. Please use a unique branch code.";
                                    }

// Validate username uniqueness
                                    $check_username_sql = "SELECT id FROM branches WHERE username = '$username' LIMIT 1";
                                    if ($conn->query($check_username_sql)->num_rows > 0) {
                                        $errors[] = "Username already exists. Please choose a different username.";
                                    }

// Validate GST number format if provided
                                    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. Example: 29ABCDE1234F1Z5";
                                    }

// Validate email format if provided
                                    if (!empty($email) && !filter_var($email, FILTER_VALIDATE_EMAIL)) {
                                        $errors[] = "Invalid email format for branch email.";
                                    }
                                    if (!empty($manager_email) && !filter_var($manager_email, FILTER_VALIDATE_EMAIL)) {
                                        $errors[] = "Invalid email format for manager email.";
                                    }

if (empty($errors)) {
                                        // Hash the password
                                        $hashed_password = password_hash($password, PASSWORD_DEFAULT);
                                        
                                        // Insert into branches table
                                        $sql = "INSERT INTO branches (
                                            branch_name, branch_code, address, city, state, pincode, country,
                                            phone, email, manager_name, manager_phone, manager_email,
                                            gst_number, opening_date, status, notes, username, password, created_at
                                        ) VALUES (
                                            '$branch_name', '$branch_code', '$address', '$city', '$state', '$pincode', '$country',
                                            '$phone', '$email', '$manager_name', '$manager_phone', '$manager_email',
                                            '$gst_number', '$opening_date', '$status', '$notes', '$username', '$hashed_password', current_timestamp()
                                        )";

if ($conn->query($sql) === TRUE) {
                                            $branch_id = $conn->insert_id;
                                            
                                            // Create initial credit record for this branch
                                            $credit_sql = "INSERT INTO branch_credits (branch_id, current_credit, credit_limit) 
                                                          VALUES ($branch_id, 0.00, 1000000.00)";
                                            $conn->query($credit_sql);
                                            
                                            echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                                    <i class="fas fa-check-circle me-2"></i>
                                                    Branch added successfully! <br>
                                                    <strong>Branch ID:</strong> ' . $branch_id . '<br>
                                                    <strong>Login Credentials:</strong><br>
                                                    <strong>Username:</strong> ' . htmlspecialchars($username) . '<br>
                                                    <strong>Password:</strong> ' . htmlspecialchars($password) . ' (Please save this password)
                                                    <div class="mt-3">
                                                        <a href="branches.php" class="btn btn-sm btn-outline-primary me-2">View All Branches</a>
                                                        <a href="add-branch.php" class="btn btn-sm btn-outline-success">Add Another Branch</a>
                                                    </div>
                                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                                  </div>';
                                            // Clear POST so form resets
                                            $_POST = array();
                                        } else {
                                            echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                                    <i class="fas fa-exclamation-triangle me-2"></i>
                                                    Error adding branch: ' . $conn->error . '
                                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                                  </div>';
                                        }
                                    } else {
                                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                                <i class="fas fa-exclamation-circle me-2"></i>
                                                <strong>Please fix the following errors:</strong><br>
                                                ' . implode('<br>', $errors) . '
                                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                              </div>';
                                    }
                                }
                                ?>

<form method="POST" action="" id="branchForm">
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="branch_name" class="form-label">Branch Name <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="branch_name" name="branch_name" 
                                                       value="<?php echo isset($_POST['branch_name']) ? htmlspecialchars($_POST['branch_name']) : ''; ?>" required>
                                            </div>
                                        </div>

<div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="branch_code" class="form-label">Branch Code <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="branch_code" name="branch_code" 
                                                       value="<?php echo isset($_POST['branch_code']) ? htmlspecialchars($_POST['branch_code']) : ''; ?>" required>
                                                <div class="form-text">Unique code for the branch (e.g., BR001)</div>
                                            </div>
                                        </div>
                                    </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="2" required><?php echo isset($_POST['address']) ? htmlspecialchars($_POST['address']) : ''; ?></textarea>
                                    </div>

<div class="row">
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="city" class="form-label">City <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="city" name="city" 
                                                       value="<?php echo isset($_POST['city']) ? htmlspecialchars($_POST['city']) : ''; ?>" required>
                                            </div>
                                        </div>

<div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="state" class="form-label">State <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="state" name="state" 
                                                       value="<?php echo isset($_POST['state']) ? htmlspecialchars($_POST['state']) : ''; ?>" required>
                                            </div>
                                        </div>

<div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="pincode" class="form-label">Pincode <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="pincode" name="pincode" 
                                                       value="<?php echo isset($_POST['pincode']) ? htmlspecialchars($_POST['pincode']) : ''; ?>" required>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="country" class="form-label">Country <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="country" name="country" 
                                                       value="<?php echo isset($_POST['country']) ? htmlspecialchars($_POST['country']) : 'India'; ?>" required>
                                            </div>
                                        </div>

<div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="phone" class="form-label">Phone Number</label>
                                                <input type="tel" class="form-control" id="phone" name="phone" 
                                                       value="<?php echo isset($_POST['phone']) ? htmlspecialchars($_POST['phone']) : ''; ?>">
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="email" class="form-label">Email Address</label>
                                                <input type="email" class="form-control" id="email" name="email" 
                                                       value="<?php echo isset($_POST['email']) ? htmlspecialchars($_POST['email']) : ''; ?>">
                                            </div>
                                        </div>

<div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="gst_number" class="form-label">GST Number</label>
                                                <input type="text" class="form-control" id="gst_number" name="gst_number" 
                                                       value="<?php echo isset($_POST['gst_number']) ? htmlspecialchars($_POST['gst_number']) : ''; ?>"
                                                       pattern="[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}" 
                                                       title="GST Format: 29ABCDE1234F1Z5">
                                                <div class="form-text">Format: 29ABCDE1234F1Z5</div>
                                            </div>
                                        </div>
                                    </div>

<hr>
                                    <h5 class="mb-3">Manager Details</h5>

<div class="row">
                                        <div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="manager_name" class="form-label">Manager Name</label>
                                                <input type="text" class="form-control" id="manager_name" name="manager_name" 
                                                       value="<?php echo isset($_POST['manager_name']) ? htmlspecialchars($_POST['manager_name']) : ''; ?>">
                                            </div>
                                        </div>

<div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="manager_phone" class="form-label">Manager Phone</label>
                                                <input type="tel" class="form-control" id="manager_phone" name="manager_phone" 
                                                       value="<?php echo isset($_POST['manager_phone']) ? htmlspecialchars($_POST['manager_phone']) : ''; ?>">
                                            </div>
                                        </div>

<div class="col-md-4">
                                            <div class="mb-3">
                                                <label for="manager_email" class="form-label">Manager Email</label>
                                                <input type="email" class="form-control" id="manager_email" name="manager_email" 
                                                       value="<?php echo isset($_POST['manager_email']) ? htmlspecialchars($_POST['manager_email']) : ''; ?>">
                                            </div>
                                        </div>
                                    </div>

<hr>
                                    <h5 class="mb-3">Login Credentials</h5>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="username" class="form-label">Username <span class="text-danger">*</span></label>
                                                <div class="input-group">
                                                    <span class="input-group-text">@</span>
                                                    <input type="text" class="form-control" id="username" name="username" 
                                                           value="<?php echo isset($_POST['username']) ? htmlspecialchars($_POST['username']) : ''; ?>" required>
                                                </div>
                                                <div class="form-text">Will be used to login to this branch</div>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="email" class="form-label">Login Email</label>
                                                <input type="email" class="form-control" id="login_email" name="login_email" 
                                                       value="<?php echo isset($_POST['login_email']) ? htmlspecialchars($_POST['login_email']) : ''; ?>">
                                                <div class="form-text">Optional: Can be used for password recovery</div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="password" class="form-label">Password <span class="text-danger">*</span></label>
                                                <div class="input-group">
                                                    <input type="password" class="form-control" id="password" name="password" 
                                                           value="<?php echo isset($_POST['password']) ? htmlspecialchars($_POST['password']) : ''; ?>" required>
                                                    <button class="btn btn-outline-secondary" type="button" id="togglePassword">
                                                        <i class="fas fa-eye"></i>
                                                    </button>
                                                </div>
                                                <div class="form-text">Minimum 6 characters</div>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="confirm_password" class="form-label">Confirm Password <span class="text-danger">*</span></label>
                                                <div class="input-group">
                                                    <input type="password" class="form-control" id="confirm_password" name="confirm_password" 
                                                           value="<?php echo isset($_POST['confirm_password']) ? htmlspecialchars($_POST['confirm_password']) : ''; ?>" required>
                                                    <button class="btn btn-outline-secondary" type="button" id="toggleConfirmPassword">
                                                        <i class="fas fa-eye"></i>
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="opening_date" class="form-label">Opening Date</label>
                                                <input type="date" class="form-control" id="opening_date" name="opening_date" 
                                                       value="<?php echo isset($_POST['opening_date']) ? htmlspecialchars($_POST['opening_date']) : date('Y-m-d'); ?>">
                                            </div>
                                        </div>

<div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="status" class="form-label">Status <span class="text-danger">*</span></label>
                                                <select class="form-select" id="status" name="status" required>
                                                    <option value="active" <?php echo (isset($_POST['status']) && $_POST['status'] == 'active') ? 'selected' : 'selected'; ?>>Active</option>
                                                    <option value="inactive" <?php echo (isset($_POST['status']) && $_POST['status'] == 'inactive') ? 'selected' : ''; ?>>Inactive</option>
                                                    <option value="pending" <?php echo (isset($_POST['status']) && $_POST['status'] == 'pending') ? 'selected' : ''; ?>>Pending</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>

<div class="mb-3">
                                        <label for="notes" class="form-label">Notes</label>
                                        <textarea class="form-control" id="notes" name="notes" rows="3"><?php echo isset($_POST['notes']) ? htmlspecialchars($_POST['notes']) : ''; ?></textarea>
                                    </div>

<div class="d-grid gap-2 d-md-flex justify-content-md-end">
                                        <button type="reset" class="btn btn-secondary me-md-2">Reset</button>
                                        <button type="submit" class="btn btn-primary">
                                            <i class="fas fa-plus-circle me-2"></i>Add Branch
                                        </button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

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

// Toggle password visibility
    const togglePassword = document.getElementById('togglePassword');
    const passwordInput = document.getElementById('password');
    const toggleConfirmPassword = document.getElementById('toggleConfirmPassword');
    const confirmPasswordInput = document.getElementById('confirm_password');
    
    togglePassword.addEventListener('click', function() {
        const type = passwordInput.getAttribute('type') === 'password' ? 'text' : 'password';
        passwordInput.setAttribute('type', type);
        this.innerHTML = type === 'password' ? '<i class="fas fa-eye"></i>' : '<i class="fas fa-eye-slash"></i>';
    });
    
    toggleConfirmPassword.addEventListener('click', function() {
        const type = confirmPasswordInput.getAttribute('type') === 'password' ? 'text' : 'password';
        confirmPasswordInput.setAttribute('type', type);
        this.innerHTML = type === 'password' ? '<i class="fas fa-eye"></i>' : '<i class="fas fa-eye-slash"></i>';
    });

// Validate phone numbers
    const phoneInputs = document.querySelectorAll('input[type="tel"]');
    phoneInputs.forEach(input => {
        input.addEventListener('input', function() {
            this.value = this.value.replace(/[^0-9+()\- ]/g, '');
        });
    });

// Validate pincode
    const pincodeInput = document.getElementById('pincode');
    pincodeInput.addEventListener('input', function() {
        this.value = this.value.replace(/[^0-9]/g, '');
        if (this.value.length > 6) {
            this.value = this.value.substring(0, 6);
        }
    });
    
    // Password strength indicator
    passwordInput.addEventListener('input', function() {
        const password = this.value;
        const strength = checkPasswordStrength(password);
        updatePasswordStrength(strength);
    });
    
    function checkPasswordStrength(password) {
        let score = 0;
        if (password.length >= 6) score++;
        if (password.length >= 8) score++;
        if (/[A-Z]/.test(password)) score++;
        if (/[0-9]/.test(password)) score++;
        if (/[^A-Za-z0-9]/.test(password)) score++;
        return score;
    }
    
    function updatePasswordStrength(score) {
        const indicator = document.getElementById('passwordStrength');
        if (!indicator) {
            const div = document.createElement('div');
            div.id = 'passwordStrength';
            div.className = 'mt-2';
            passwordInput.parentNode.appendChild(div);
        }
        
        const strengthText = ['Very Weak', 'Weak', 'Fair', 'Good', 'Strong', 'Very Strong'];
        const strengthColors = ['danger', 'danger', 'warning', 'info', 'success', 'success'];
        
        document.getElementById('passwordStrength').innerHTML = `
            <div class="progress" style="height: 5px;">
                <div class="progress-bar bg-${strengthColors[score]}" role="progressbar" 
                     style="width: ${(score / 5) * 100}%"></div>
            </div>
            <small class="text-${strengthColors[score]}">${strengthText[score]} password</small>
        `;
    }
    
    // Real-time password matching
    const passwordFields = [passwordInput, confirmPasswordInput];
    passwordFields.forEach(field => {
        field.addEventListener('input', function() {
            const password = passwordInput.value;
            const confirm = confirmPasswordInput.value;
            
            if (confirm && password !== confirm) {
                confirmPasswordInput.classList.add('is-invalid');
                confirmPasswordInput.classList.remove('is-valid');
            } else if (confirm && password === confirm) {
                confirmPasswordInput.classList.remove('is-invalid');
                confirmPasswordInput.classList.add('is-valid');
            } else {
                confirmPasswordInput.classList.remove('is-invalid', 'is-valid');
            }
        });
    });
});
</script>

/* Password visibility toggle button */
.input-group .btn-outline-secondary {
    border-color: #ced4da;
    border-left: none;
}

.input-group .btn-outline-secondary:hover {
    background-color: #e9ecef;
    border-color: #ced4da;
}

/* Form validation styles */
.is-valid {
    border-color: #198754 !important;
}

.is-invalid {
    border-color: #dc3545 !important;
}
</style>

</body>
</html>

<?php
// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-branch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation