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

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: new-customer.php

<?php

// Include database connection
include('includes/db.php');

// Initialize variables
$name = $phone = $address = $address2 = $gst_no = $pan_no = '';
$errors = [];
$success = '';

// Start session if not already started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Validate and sanitize inputs
    $name = trim($_POST['name'] ?? '');
    $phone = trim($_POST['phone'] ?? '');
    $address = trim($_POST['address'] ?? '');
    $address2 = trim($_POST['address2'] ?? '');
    $gst_no = trim($_POST['gst_no'] ?? '');
    $pan_no = trim($_POST['pan_no'] ?? '');
    
    // Validation
    if (empty($name)) {
        $errors['name'] = 'Customer name is required';
    } elseif (strlen($name) > 255) {
        $errors['name'] = 'Name must be less than 255 characters';
    }
    
    if (!empty($phone) && !preg_match('/^[0-9]{10}$/', $phone)) {
        $errors['phone'] = 'Phone number must be 10 digits';
    }
    
    if (!empty($gst_no) && strlen($gst_no) > 20) {
        $errors['gst_no'] = 'GST number must be less than 20 characters';
    }
    
    if (!empty($pan_no) && !preg_match('/^[A-Z]{5}[0-9]{4}[A-Z]{1}$/', $pan_no)) {
        $errors['pan_no'] = 'Invalid PAN number format';
    }
    
    // Check if phone number already exists (if provided)
    if (!empty($phone)) {
        $check_sql = "SELECT id FROM customers WHERE phone = ?";
        $check_stmt = mysqli_prepare($conn, $check_sql);
        mysqli_stmt_bind_param($check_stmt, 's', $phone);
        mysqli_stmt_execute($check_stmt);
        mysqli_stmt_store_result($check_stmt);
        
        if (mysqli_stmt_num_rows($check_stmt) > 0) {
            $errors['phone'] = 'Phone number already exists in the system';
        }
        mysqli_stmt_close($check_stmt);
    }
    
    // If no errors, insert into database
    if (empty($errors)) {
        $current_time = date('Y-m-d H:i:s');
        
        // SQL query based on actual table columns
        $sql = "INSERT INTO customers (name, phone, address, address2, gst_no, pan_no, created_at) 
                VALUES (?, ?, ?, ?, ?, ?, ?)";
        
        $stmt = mysqli_prepare($conn, $sql);
        
        if ($stmt) {
            // Bind parameters with correct column names
            mysqli_stmt_bind_param($stmt, 'sssssss', 
                $name, 
                $phone, 
                $address, 
                $address2, 
                $gst_no, 
                $pan_no, 
                $current_time
            );
            
            if (mysqli_stmt_execute($stmt)) {
                $customer_id = mysqli_insert_id($conn);
                $success = 'Customer added successfully!';
                
                // Clear form fields
                $name = $phone = $address = $address2 = $gst_no = $pan_no = '';
                
                // Redirect to view customer page if needed
                // header("Location: view-customer.php?id=" . $customer_id);
                // exit();
            } else {
                $errors['database'] = 'Failed to add customer: ' . mysqli_error($conn);
            }
            
            mysqli_stmt_close($stmt);
        } else {
            $errors['database'] = 'Failed to prepare query: ' . mysqli_error($conn);
        }
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<?php include('includes/head.php'); ?>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Add New Customer</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                    <li class="breadcrumb-item"><a href="customers.php">Customers</a></li>
                                    <li class="breadcrumb-item active">New Customer</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php if ($success): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="fas fa-check-circle me-2"></i>
                        <?php echo htmlspecialchars($success); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<?php if (isset($errors['database'])): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <?php echo htmlspecialchars($errors['database']); ?>
                        <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">
                                <h5 class="card-title mb-4">Customer Information</h5>
                                
                                <form method="POST" action="" id="customerForm">
                                    <div class="row">
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="name" class="form-label">
                                                Customer Name <span class="text-danger">*</span>
                                            </label>
                                            <input type="text" 
                                                   class="form-control <?php echo isset($errors['name']) ? 'is-invalid' : ''; ?>" 
                                                   id="name" 
                                                   name="name" 
                                                   value="<?php echo htmlspecialchars($name); ?>" 
                                                   placeholder="Enter customer name" 
                                                   required>
                                            <?php if (isset($errors['name'])): ?>
                                                <div class="error"><?php echo htmlspecialchars($errors['name']); ?></div>
                                            <?php endif; ?>
                                        </div>

<div class="col-md-6 mb-3">
                                            <label for="phone" class="form-label">Phone Number</label>
                                            <input type="text" 
                                                   class="form-control <?php echo isset($errors['phone']) ? 'is-invalid' : ''; ?>" 
                                                   id="phone" 
                                                   name="phone" 
                                                   value="<?php echo htmlspecialchars($phone); ?>" 
                                                   placeholder="Enter 10-digit phone number">
                                            <?php if (isset($errors['phone'])): ?>
                                                <div class="error"><?php echo htmlspecialchars($errors['phone']); ?></div>
                                            <?php endif; ?>
                                            <small class="text-muted">Optional. Must be 10 digits if provided.</small>
                                        </div>
                                    </div>

<div class="row">
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="address" class="form-label">Address Line 1</label>
                                            <textarea class="form-control" 
                                                      id="address" 
                                                      name="address" 
                                                      rows="2" 
                                                      placeholder="Enter address line 1"><?php echo htmlspecialchars($address); ?></textarea>
                                        </div>
                                        
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="address2" class="form-label">Address Line 2</label>
                                            <textarea class="form-control" 
                                                      id="address2" 
                                                      name="address2" 
                                                      rows="2" 
                                                      placeholder="Enter address line 2"><?php echo htmlspecialchars($address2); ?></textarea>
                                        </div>
                                    </div>

<div class="row">
                                        
                                        <div class="col-md-6 mb-3">
                                            <label for="gst_no" class="form-label">GST Number</label>
                                            <input type="text" 
                                                   class="form-control <?php echo isset($errors['gst_no']) ? 'is-invalid' : ''; ?>" 
                                                   id="gst_no" 
                                                   name="gst_no" 
                                                   value="<?php echo htmlspecialchars($gst_no); ?>" 
                                                   placeholder="Enter GST number">
                                            <?php if (isset($errors['gst_no'])): ?>
                                                <div class="error"><?php echo htmlspecialchars($errors['gst_no']); ?></div>
                                            <?php endif; ?>
                                            <small class="text-muted">Optional. Max 20 characters.</small>
                                        </div>

<div class="col-md-6 mb-3">
                                            <label for="pan_no" class="form-label">PAN Number</label>
                                            <input type="text" 
                                                   class="form-control <?php echo isset($errors['pan_no']) ? 'is-invalid' : ''; ?>" 
                                                   id="pan_no" 
                                                   name="pan_no" 
                                                   value="<?php echo htmlspecialchars($pan_no); ?>" 
                                                   placeholder="Enter PAN number (e.g., ABCDE1234F)">
                                            <?php if (isset($errors['pan_no'])): ?>
                                                <div class="error"><?php echo htmlspecialchars($errors['pan_no']); ?></div>
                                            <?php endif; ?>
                                            <small class="text-muted">Optional. Format: ABCDE1234F</small>
                                        </div>
                                    </div>

<div class="mt-4">
                                        <button type="submit" class="btn btn-primary">
                                            <i class="fas fa-save me-2"></i>Save Customer
                                        </button>
                                        <button type="reset" class="btn btn-secondary">
                                            <i class="fas fa-redo me-2"></i>Reset Form
                                        </button>
                                        <a href="customers.php" class="btn btn-outline-danger">
                                            <i class="fas fa-times me-2"></i>Cancel
                                        </a>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-3">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h6 class="card-title">
                                    <i class="fas fa-info-circle text-primary me-2"></i>Quick Tips
                                </h6>
                                <ul class="mb-0">
                                    <li>Name field is required for all customers</li>
                                    <li>Phone number should be 10 digits if provided</li>
                                    <li>PAN number format: 5 letters, 4 digits, 1 letter (e.g., ABCDE1234F)</li>
                                    <li>GST number is optional and can be added later</li>
                                    <li>Walk-in customers can be created with just a name</li>
                                    <li>Customers can be edited later from the Customers page</li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>

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

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

// PAN number formatting and validation
    $('#pan_no').on('input', function() {
        var pan = $(this).val().toUpperCase().replace(/[^A-Z0-9]/g, '');
        $(this).val(pan);
    });

// GST number formatting
    $('#gst_no').on('input', function() {
        var gst = $(this).val().toUpperCase().replace(/[^A-Z0-9]/g, '');
        $(this).val(gst);
    });

// Form validation
    $('#customerForm').on('submit', function(e) {
        var name = $('#name').val().trim();
        var phone = $('#phone').val().trim();
        var pan = $('#pan_no').val().trim();
        
        // Name validation
        if (name === '') {
            alert('Please enter customer name');
            $('#name').focus();
            return false;
        }
        
        // Phone validation
        if (phone !== '' && !/^\d{10}$/.test(phone)) {
            alert('Phone number must be 10 digits');
            $('#phone').focus();
            return false;
        }
        
        // PAN validation
        if (pan !== '' && !/^[A-Z]{5}[0-9]{4}[A-Z]{1}$/.test(pan)) {
            alert('Invalid PAN number format. Format: ABCDE1234F');
            $('#pan_no').focus();
            return false;
        }
        
        return true;
    });

// Auto-focus on name field
    $('#name').focus();
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: new-customer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation