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

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: manage-gstn.php

<?php

require_once('includes/db.php');

// Check if user is logged in as admin
if (!isset($_SESSION['user_role']) || $_SESSION['user_role'] !== 'admin') {
    header("Location: user-login.php");
    exit();
}

// Initialize variables
$success = '';
$error = '';
$gst_details = [];

// Upload directories
$upload_dir = 'uploads/gst_logos/';
$signature_dir = 'uploads/signatures/';
if (!file_exists($upload_dir)) {
    mkdir($upload_dir, 0777, true);
}
if (!file_exists($signature_dir)) {
    mkdir($signature_dir, 0777, true);
}

// Check and update database table structure if needed - Check each column individually
$columns_to_add = [
    'account_name' => "ADD COLUMN `account_name` VARCHAR(255) NULL AFTER `logo_path`",
    'account_number' => "ADD COLUMN `account_number` VARCHAR(20) NULL AFTER `account_name`",
    'bank_name' => "ADD COLUMN `bank_name` VARCHAR(255) NULL AFTER `account_number`",
    'ifsc_code' => "ADD COLUMN `ifsc_code` VARCHAR(11) NULL AFTER `bank_name`",
    'branch_name' => "ADD COLUMN `branch_name` VARCHAR(255) NULL AFTER `ifsc_code`",
    'signature_path' => "ADD COLUMN `signature_path` VARCHAR(255) NULL AFTER `logo_path`"
];

foreach ($columns_to_add as $column_name => $alter_sql) {
    $check_sql = "SHOW COLUMNS FROM gst_details LIKE '$column_name'";
    $check_result = mysqli_query($conn, $check_sql);
    
    if (mysqli_num_rows($check_result) == 0) {
        // Column doesn't exist, add it
        $full_alter_sql = "ALTER TABLE `gst_details` $alter_sql";
        if (!mysqli_query($conn, $full_alter_sql)) {
            // If error occurs, store it but don't stop execution
            $db_error = mysqli_error($conn);
            error_log("Failed to add column $column_name: $db_error");
        }
    }
}

// First, check if shop_profile exists or create a default one
$check_shop_sql = "SELECT id FROM shop_profile LIMIT 1";
$check_shop_result = mysqli_query($conn, $check_shop_sql);

if (mysqli_num_rows($check_shop_result) == 0) {
    // Create a default shop profile
    $default_shop_sql = "INSERT INTO shop_profile (name, contact, email, password_hash, currency, timezone, language, is_active, created_at, updated_at) 
                         VALUES ('Main Shop', '9999999999', 'shop@example.com', 'default_hash', 'INR', 'Asia/Kolkata', 'en', 1, NOW(), NOW())";
    
    if (!mysqli_query($conn, $default_shop_sql)) {
        $error = 'Error creating default shop profile. Please contact administrator.';
    }
    
    // Get the created shop ID
    $shop_id_result = mysqli_query($conn, "SELECT id FROM shop_profile LIMIT 1");
    $shop_data = mysqli_fetch_assoc($shop_id_result);
    $default_shop_id = $shop_data['id'];
} else {
    $shop_data = mysqli_fetch_assoc($check_shop_result);
    $default_shop_id = $shop_data['id'];
}

// Handle form submission for adding/updating GSTN
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Check if it's an update or add
    $gst_id = isset($_POST['gst_id']) ? (int)$_POST['gst_id'] : 0;
    
    $business_name = mysqli_real_escape_string($conn, trim($_POST['business_name'] ?? ''));
    $business_address = mysqli_real_escape_string($conn, trim($_POST['business_address'] ?? ''));
    $gst_num = mysqli_real_escape_string($conn, trim($_POST['gst_num'] ?? ''));
    $account_name = mysqli_real_escape_string($conn, trim($_POST['account_name'] ?? ''));
    $account_number = mysqli_real_escape_string($conn, trim($_POST['account_number'] ?? ''));
    $bank_name = mysqli_real_escape_string($conn, trim($_POST['bank_name'] ?? ''));
    $ifsc_code = mysqli_real_escape_string($conn, trim($_POST['ifsc_code'] ?? ''));
    $branch_name = mysqli_real_escape_string($conn, trim($_POST['branch_name'] ?? ''));
    $gst_status = isset($_POST['gst_status']) ? 1 : 0;
    $shop_id = $default_shop_id; // Use the default shop ID
    
    // Handle logo upload
    $logo_path = '';
    if (isset($_POST['existing_logo'])) {
        $logo_path = $_POST['existing_logo'];
    }
    
    // Handle signature upload
    $signature_path = '';
    if (isset($_POST['existing_signature'])) {
        $signature_path = $_POST['existing_signature'];
    }
    
    // Process logo upload
    if (isset($_FILES['business_logo']) && $_FILES['business_logo']['error'] == 0) {
        $logo = $_FILES['business_logo'];
        $logo_path = handleFileUpload($logo, $upload_dir, 'logo', $logo_path);
        if (is_string($logo_path) && strpos($logo_path, 'Error:') === 0) {
            $error = $logo_path;
            $logo_path = isset($_POST['existing_logo']) ? $_POST['existing_logo'] : '';
        }
    }
    
    // Process signature upload
    if (isset($_FILES['signature']) && $_FILES['signature']['error'] == 0) {
        $signature = $_FILES['signature'];
        $signature_path = handleFileUpload($signature, $signature_dir, 'signature', $signature_path);
        if (is_string($signature_path) && strpos($signature_path, 'Error:') === 0) {
            $error = $signature_path;
            $signature_path = isset($_POST['existing_signature']) ? $_POST['existing_signature'] : '';
        }
    }
    
    // Validate required fields (only if no upload error)
    if (empty($error)) {
        $errors = [];
        
        if (empty($business_name)) {
            $errors[] = 'Business name is required';
        }
        
        if (empty($gst_num)) {
            $errors[] = 'GST number is required';
        } elseif (!preg_match('/^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}$/', $gst_num)) {
            $errors[] = 'Invalid GST number format. Please enter a valid 15-digit GSTIN.';
        }
        
        if (!empty($account_number) && !preg_match('/^[0-9]{9,18}$/', $account_number)) {
            $errors[] = 'Invalid account number. Should be 9-18 digits.';
        }
        
        if (!empty($ifsc_code) && !preg_match('/^[A-Z]{4}0[A-Z0-9]{6}$/', $ifsc_code)) {
            $errors[] = 'Invalid IFSC code format. Should be like ABCD0123456';
        }
        
        if (empty($errors)) {
            // Check if GST number already exists (excluding current if updating)
            $check_sql = "SELECT id FROM gst_details WHERE gst_num = '$gst_num'";
            if ($gst_id > 0) {
                $check_sql .= " AND id != $gst_id";
            }
            
            $check_result = mysqli_query($conn, $check_sql);
            
            if (mysqli_num_rows($check_result) > 0) {
                $error = 'GST number already exists in the system';
            } else {
                if ($gst_id > 0) {
                    // Update existing GSTN
                    $update_fields = [
                        "business_name = '$business_name'",
                        "business_address = '$business_address'",
                        "gst_num = '$gst_num'",
                        "account_name = '$account_name'",
                        "account_number = '$account_number'",
                        "bank_name = '$bank_name'",
                        "ifsc_code = '$ifsc_code'",
                        "branch_name = '$branch_name'",
                        "gst_status = $gst_status",
                        "last_updated = NOW()"
                    ];
                    
                    if (!empty($logo_path)) {
                        $logo_path_escaped = mysqli_real_escape_string($conn, $logo_path);
                        $update_fields[] = "logo_path = '$logo_path_escaped'";
                    }
                    
                    if (!empty($signature_path)) {
                        $signature_path_escaped = mysqli_real_escape_string($conn, $signature_path);
                        $update_fields[] = "signature_path = '$signature_path_escaped'";
                    }
                    
                    $update_sql = "UPDATE gst_details SET " . implode(', ', $update_fields) . " WHERE id = $gst_id";
                    
                    if (mysqli_query($conn, $update_sql)) {
                        $success = 'GST details updated successfully!';
                    } else {
                        $error = 'Error updating GST details: ' . mysqli_error($conn);
                    }
                } else {
                    // Insert new GSTN
                    $logo_path_escaped = !empty($logo_path) ? "'" . mysqli_real_escape_string($conn, $logo_path) . "'" : 'NULL';
                    $signature_path_escaped = !empty($signature_path) ? "'" . mysqli_real_escape_string($conn, $signature_path) . "'" : 'NULL';
                    
                    $insert_sql = "INSERT INTO gst_details (shop_id, business_name, business_address, gst_num, logo_path, signature_path, account_name, account_number, bank_name, ifsc_code, branch_name, gst_status, last_updated, created_at) 
                                  VALUES ($shop_id, '$business_name', '$business_address', '$gst_num', $logo_path_escaped, $signature_path_escaped, '$account_name', '$account_number', '$bank_name', '$ifsc_code', '$branch_name', $gst_status, NOW(), NOW())";
                    
                    if (mysqli_query($conn, $insert_sql)) {
                        $success = 'GST details added successfully!';
                        // Clear form after successful insert
                        $_POST = array();
                        $logo_path = '';
                        $signature_path = '';
                    } else {
                        $error = 'Error adding GST details: ' . mysqli_error($conn);
                    }
                }
            }
        } else {
            $error = implode('<br>', $errors);
        }
    }
}

// Handle delete action
if (isset($_GET['delete_id'])) {
    $delete_id = (int)$_GET['delete_id'];
    
    // Check if GSTN exists and get file paths
    $check_sql = "SELECT logo_path, signature_path FROM gst_details WHERE id = $delete_id";
    $check_result = mysqli_query($conn, $check_sql);
    
    if (mysqli_num_rows($check_result) > 0) {
        $gst_data = mysqli_fetch_assoc($check_result);
        
        // Delete logo file if exists
        if (!empty($gst_data['logo_path']) && file_exists($gst_data['logo_path'])) {
            @unlink($gst_data['logo_path']);
        }
        
        // Delete signature file if exists
        if (!empty($gst_data['signature_path']) && file_exists($gst_data['signature_path'])) {
            @unlink($gst_data['signature_path']);
        }
        
        $delete_sql = "DELETE FROM gst_details WHERE id = $delete_id";
        if (mysqli_query($conn, $delete_sql)) {
            $success = 'GST details deleted successfully!';
        } else {
            $error = 'Error deleting GST details: ' . mysqli_error($conn);
        }
    } else {
        $error = 'GST details not found!';
    }
}

// Handle edit action - load data for editing
$edit_data = [];
if (isset($_GET['edit_id'])) {
    $edit_id = (int)$_GET['edit_id'];
    $edit_sql = "SELECT * FROM gst_details WHERE id = $edit_id";
    $edit_result = mysqli_query($conn, $edit_sql);
    
    if ($edit_result && mysqli_num_rows($edit_result) > 0) {
        $edit_data = mysqli_fetch_assoc($edit_result);
    } else {
        $error = 'GST details not found for editing';
    }
}

// Handle toggle status
if (isset($_GET['toggle_status'])) {
    $toggle_id = (int)$_GET['toggle_status'];
    
    // Get current status
    $status_sql = "SELECT gst_status FROM gst_details WHERE id = $toggle_id";
    $status_result = mysqli_query($conn, $status_sql);
    
    if (mysqli_num_rows($status_result) > 0) {
        $current = mysqli_fetch_assoc($status_result);
        $new_status = $current['gst_status'] == 1 ? 0 : 1;
        
        $update_sql = "UPDATE gst_details SET gst_status = $new_status, last_updated = NOW() WHERE id = $toggle_id";
        if (mysqli_query($conn, $update_sql)) {
            $success = "GST status updated successfully!";
        } else {
            $error = 'Error updating GST status: ' . mysqli_error($conn);
        }
    }
}

// Fetch all GST details
$gst_sql = "SELECT gd.*, sp.name as shop_name 
            FROM gst_details gd
            LEFT JOIN shop_profile sp ON gd.shop_id = sp.id
            ORDER BY gd.created_at DESC";
$gst_result = mysqli_query($conn, $gst_sql);

$gst_details = [];
if ($gst_result && mysqli_num_rows($gst_result) > 0) {
    while ($row = mysqli_fetch_assoc($gst_result)) {
        $gst_details[] = $row;
    }
}

// File upload handler function
function handleFileUpload($file, $upload_dir, $type = 'logo', $existing_path = '') {
    $allowed_types = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif', 'image/webp'];
    $max_size = 2 * 1024 * 1024; // 2MB
    
    // Validate file type
    if (!in_array($file['type'], $allowed_types)) {
        return "Error: Invalid file type for $type. Only JPG, PNG, GIF, and WebP images are allowed.";
    }
    // Validate file size
    elseif ($file['size'] > $max_size) {
        return "Error: File size too large for $type. Maximum size is 2MB.";
    }
    // Validate image dimensions
    else {
        $image_info = getimagesize($file['tmp_name']);
        if (!$image_info) {
            return "Error: Invalid image file for $type.";
        } elseif ($image_info[0] > 2000 || $image_info[1] > 2000) {
            return "Error: Image dimensions too large for $type. Maximum is 2000x2000 pixels.";
        } else {
            // Generate unique filename
            $file_extension = pathinfo($file['name'], PATHINFO_EXTENSION);
            $unique_filename = $type . '_' . time() . '_' . uniqid() . '.' . $file_extension;
            $target_path = $upload_dir . $unique_filename;
            
            // Create upload directory if it doesn't exist
            if (!file_exists($upload_dir)) {
                mkdir($upload_dir, 0777, true);
            }
            
            // Move uploaded file
            if (move_uploaded_file($file['tmp_name'], $target_path)) {
                // Delete old file if exists
                if (!empty($existing_path) && file_exists($existing_path) && $existing_path != $target_path) {
                    @unlink($existing_path);
                }
                return $target_path;
            } else {
                return "Error: Failed to upload $type. Please try again.";
            }
        }
    }
}
?>

<!doctype html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    <style>
        .gst-card:hover {
            transform: translateY(-2px);
            box-shadow: 0 4px 15px rgba(0,0,0,0.1);
        }
        .gst-badge {
            font-size: 0.8rem;
            padding: 0.25rem 0.5rem;
        }
        .status-active {
            color: #198754;
            background-color: rgba(25, 135, 84, 0.1);
        }
        .status-inactive {
            color: #6c757d;
            background-color: rgba(108, 117, 125, 0.1);
        }
        .action-buttons .btn {
            padding: 0.25rem 0.5rem;
            font-size: 0.875rem;
        }
        .form-help-text {
            font-size: 0.875rem;
            color: #6c757d;
            margin-top: 0.25rem;
        }
        .gst-example {
            background-color: #f8f9fa;
            padding: 10px;
            border-radius: 5px;
            margin-top: 5px;
            font-family: monospace;
        }
        .table th {
            background-color: #f8f9fa;
            font-weight: 600;
        }
        .empty-state {
            padding: 3rem 1rem;
            text-align: center;
            color: #6c757d;
        }
        .empty-state i {
            font-size: 4rem;
            margin-bottom: 1rem;
            opacity: 0.3;
        }
        .business-name {
            font-weight: 600;
            color: #495057;
        }
        .business-address {
            font-size: 0.875rem;
            color: #6c757d;
            max-width: 200px;
            white-space: nowrap;
            overflow: hidden;
            text-overflow: ellipsis;
        }
        .address-cell {
            position: relative;
        }
        .address-cell:hover .business-address {
            position: absolute;
            background: white;
            padding: 10px;
            border: 1px solid #dee2e6;
            border-radius: 5px;
            box-shadow: 0 2px 5px rgba(0,0,0,0.1);
            z-index: 1000;
            max-width: 300px;
            white-space: normal;
            overflow: visible;
        }
        .form-icon {
            color: #6c757d;
        }
        .required:after {
            content: " *";
            color: #dc3545;
        }
        .alert-shop-info {
            background-color: #d1ecf1;
            border-color: #bee5eb;
            color: #0c5460;
        }
        /* Logo upload styles */
        .logo-upload-container {
            border: 2px dashed #dee2e6;
            border-radius: 8px;
            padding: 20px;
            text-align: center;
            background-color: #f8f9fa;
            transition: all 0.3s ease;
            cursor: pointer;
        }
        .logo-upload-container:hover {
            border-color: #007bff;
            background-color: #e9f7fe;
        }
        .logo-upload-container.dragover {
            border-color: #28a745;
            background-color: #e8f5e9;
        }
        .logo-preview {
            max-width: 200px;
            max-height: 100px;
            border-radius: 4px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
        }
        .logo-placeholder {
            font-size: 3rem;
            color: #6c757d;
            margin-bottom: 10px;
        }
        .logo-remove-btn {
            margin-top: 10px;
        }
        .logo-info {
            font-size: 0.8rem;
            color: #6c757d;
            margin-top: 5px;
        }
        /* Signature upload styles - smaller version */
        .signature-upload-container {
            border: 2px dashed #dee2e6;
            border-radius: 6px;
            padding: 15px;
            text-align: center;
            background-color: #f8f9fa;
            transition: all 0.3s ease;
            cursor: pointer;
            margin-top: 15px;
        }
        .signature-upload-container:hover {
            border-color: #007bff;
            background-color: #e9f7fe;
        }
        .signature-upload-container.dragover {
            border-color: #28a745;
            background-color: #e8f5e9;
        }
        .signature-preview {
            max-width: 150px;
            max-height: 60px;
            border-radius: 3px;
            box-shadow: 0 1px 3px rgba(0,0,0,0.1);
        }
        .signature-placeholder {
            font-size: 2rem;
            color: #6c757d;
            margin-bottom: 5px;
        }
        .signature-remove-btn {
            margin-top: 8px;
            padding: 2px 8px;
            font-size: 0.75rem;
        }
        .signature-info {
            font-size: 0.7rem;
            color: #6c757d;
            margin-top: 3px;
        }
        .logo-grid {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(150px, 1fr));
            gap: 15px;
            margin-top: 20px;
        }
        .logo-grid-item {
            text-align: center;
            padding: 10px;
            border: 1px solid #dee2e6;
            border-radius: 8px;
            background: white;
        }
        .logo-grid-img {
            max-width: 100%;
            max-height: 80px;
            object-fit: contain;
        }
        .logo-grid-name {
            font-size: 0.8rem;
            margin-top: 5px;
            word-break: break-all;
        }
        /* Hide empty alerts by default */
        .alert:empty {
            display: none;
        }
        .logo-cell, .signature-cell {
            text-align: center;
        }
        .logo-table-img, .signature-table-img {
            max-width: 60px;
            max-height: 40px;
            object-fit: contain;
            border-radius: 4px;
        }
        .account-info {
            background-color: #f8f9fa;
            padding: 15px;
            border-radius: 5px;
            margin-bottom: 20px;
        }
        .account-row {
            margin-bottom: 10px;
            padding-bottom: 10px;
            border-bottom: 1px solid #dee2e6;
        }
        .account-row:last-child {
            margin-bottom: 0;
            padding-bottom: 0;
            border-bottom: none;
        }
        .signature-section {
            margin-top: 20px;
            padding-top: 15px;
            border-top: 1px solid #dee2e6;
        }
    </style>
</head>
<body data-sidebar="dark">
    <?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="alert alert-shop-info alert-dismissible fade show mb-4" role="alert">
                        <i class="fas fa-store me-2"></i>
                        <strong>Shop Profile:</strong> You can add multiple GST numbers for this shop. 
                        <?php if (isset($default_shop_id)): ?>
                            Current shop ID: <strong>#<?php echo $default_shop_id; ?></strong>
                        <?php endif; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                    </div>

<?php if (!empty($success)): ?>
                        <div class="alert alert-success alert-dismissible fade show mb-4" 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"></button>
                        </div>
                    <?php endif; ?>
                    
                    <?php if (!empty($error)): ?>
                        <div class="alert alert-danger alert-dismissible fade show mb-4" role="alert">
                            <i class="fas fa-exclamation-circle me-2"></i>
                            <?php echo $error; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                        </div>
                    <?php endif; ?>

<div class="row">
                        <div class="col-xl-6">
                            
                            <div class="card gst-card">
                                <div class="card-body">
                                    <h5 class="card-title mb-4">
                                        <i class="fas <?php echo !empty($edit_data) ? 'fa-edit' : 'fa-plus-circle'; ?> me-2"></i>
                                        <?php echo !empty($edit_data) ? 'Edit GSTN Details' : 'Add New GSTN'; ?>
                                    </h5>
                                    
                                    <form method="POST" id="gstForm" enctype="multipart/form-data">
                                        <?php if (!empty($edit_data)): ?>
                                            <input type="hidden" name="gst_id" value="<?php echo $edit_data['id']; ?>">
                                            <?php if (!empty($edit_data['logo_path'])): ?>
                                                <input type="hidden" name="existing_logo" value="<?php echo htmlspecialchars($edit_data['logo_path']); ?>">
                                            <?php endif; ?>
                                            <?php if (!empty($edit_data['signature_path'])): ?>
                                                <input type="hidden" name="existing_signature" value="<?php echo htmlspecialchars($edit_data['signature_path']); ?>">
                                            <?php endif; ?>
                                        <?php endif; ?>
                                        
                                        
                                        <div class="mb-4">
                                            <label class="form-label">
                                                <i class="fas fa-image form-icon me-1"></i>Business Logo
                                            </label>
                                            <div class="logo-upload-container" id="logoUploadContainer">
                                                <div id="logoPreview">
                                                    <?php 
                                                    $current_logo = $edit_data['logo_path'] ?? '';
                                                    if (!empty($current_logo) && file_exists($current_logo)): 
                                                    ?>
                                                        <img src="<?php echo htmlspecialchars($current_logo); ?>" 
                                                             alt="Business Logo" 
                                                             class="logo-preview mb-2"
                                                             onerror="this.style.display='none'; document.getElementById('defaultLogo').style.display='block';">
                                                        <div id="defaultLogo" style="display:none;">
                                                            <div class="logo-placeholder">
                                                                <i class="fas fa-image"></i>
                                                            </div>
                                                            <small>Logo preview not available</small>
                                                        </div>
                                                    <?php else: ?>
                                                        <div id="defaultLogo">
                                                            <div class="logo-placeholder">
                                                                <i class="fas fa-image"></i>
                                                            </div>
                                                            <small>Click or drag to upload logo</small>
                                                        </div>
                                                    <?php endif; ?>
                                                </div>
                                                <input type="file" id="businessLogo" name="business_logo" 
                                                       accept=".jpg,.jpeg,.png,.gif,.webp" 
                                                       class="d-none">
                                                <div class="logo-info">
                                                    Max size: 2MB • Formats: JPG, PNG, GIF, WebP
                                                </div>
                                                <?php if (!empty($current_logo) && file_exists($current_logo)): ?>
                                                    <button type="button" class="btn btn-sm btn-outline-danger logo-remove-btn" id="removeLogo">
                                                        <i class="fas fa-trash me-1"></i>Remove Logo
                                                    </button>
                                                <?php endif; ?>
                                            </div>
                                        </div>

<div class="mb-3">
                                            <label for="businessName" class="form-label required">
                                                <i class="fas fa-building form-icon me-1"></i>Business Name
                                            </label>
                                            <input type="text" id="businessName" name="business_name" 
                                                   class="form-control" 
                                                   value="<?php echo htmlspecialchars($edit_data['business_name'] ?? ($_POST['business_name'] ?? '')); ?>"
                                                   required 
                                                   placeholder="Enter business/company name">
                                            <div class="form-help-text">
                                                Legal name of the business as registered
                                            </div>
                                        </div>

<div class="mb-3">
                                            <label for="businessAddress" class="form-label">
                                                <i class="fas fa-map-marker-alt form-icon me-1"></i>Business Address
                                            </label>
                                            <textarea id="businessAddress" name="business_address" 
                                                      class="form-control" rows="3"
                                                      placeholder="Enter complete business address"><?php echo htmlspecialchars($edit_data['business_address'] ?? ($_POST['business_address'] ?? '')); ?></textarea>
                                            <div class="form-help-text">
                                                Registered office address (optional)
                                            </div>
                                        </div>

<div class="mb-3">
                                            <label for="gstNum" class="form-label required">
                                                <i class="fas fa-id-card form-icon me-1"></i>GST Number
                                            </label>
                                            <input type="text" id="gstNum" name="gst_num" 
                                                   class="form-control" 
                                                   value="<?php echo htmlspecialchars($edit_data['gst_num'] ?? ($_POST['gst_num'] ?? '')); ?>"
                                                   required 
                                                   placeholder="Enter 15-digit GSTIN" 
                                                   pattern="^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}$"
                                                   title="Format: 22AAAAA0000A1Z5">
                                            <div class="form-help-text">
                                                Enter 15-digit GSTIN in correct format
                                            </div>
                                            <div class="gst-example">
                                                <small>Example: <strong>22AAAAA0000A1Z5</strong></small>
                                            </div>
                                        </div>

<div class="mb-4">
                                            <h6 class="mb-3">
                                                <i class="fas fa-university me-1"></i>Current Account Details (Optional)
                                            </h6>
                                            
                                            <div class="account-info">
                                                
                                                <div class="mb-3">
                                                    <label for="accountName" class="form-label">
                                                        <i class="fas fa-user form-icon me-1"></i>Account Holder Name
                                                    </label>
                                                    <input type="text" id="accountName" name="account_name" 
                                                           class="form-control" 
                                                           value="<?php echo htmlspecialchars($edit_data['account_name'] ?? ($_POST['account_name'] ?? '')); ?>"
                                                           placeholder="Account holder name">
                                                </div>

<div class="mb-3">
                                                    <label for="accountNumber" class="form-label">
                                                        <i class="fas fa-credit-card form-icon me-1"></i>Account Number
                                                    </label>
                                                    <input type="text" id="accountNumber" name="account_number" 
                                                           class="form-control" 
                                                           value="<?php echo htmlspecialchars($edit_data['account_number'] ?? ($_POST['account_number'] ?? '')); ?>"
                                                           placeholder="Bank account number"
                                                           pattern="[0-9]{9,18}"
                                                           title="Account number should be 9-18 digits">
                                                    <div class="form-help-text">
                                                        Enter 9-18 digit account number
                                                    </div>
                                                </div>

<div class="mb-3">
                                                    <label for="bankName" class="form-label">
                                                        <i class="fas fa-bank form-icon me-1"></i>Bank Name
                                                    </label>
                                                    <input type="text" id="bankName" name="bank_name" 
                                                           class="form-control" 
                                                           value="<?php echo htmlspecialchars($edit_data['bank_name'] ?? ($_POST['bank_name'] ?? '')); ?>"
                                                           placeholder="Bank name">
                                                </div>

<div class="mb-3">
                                                    <label for="ifscCode" class="form-label">
                                                        <i class="fas fa-code form-icon me-1"></i>IFSC Code
                                                    </label>
                                                    <input type="text" id="ifscCode" name="ifsc_code" 
                                                           class="form-control" 
                                                           value="<?php echo htmlspecialchars($edit_data['ifsc_code'] ?? ($_POST['ifsc_code'] ?? '')); ?>"
                                                           placeholder="IFSC code"
                                                           pattern="[A-Z]{4}0[A-Z0-9]{6}"
                                                           title="IFSC code format: ABCD0123456">
                                                    <div class="form-help-text">
                                                        Format: ABCD0123456
                                                    </div>
                                                </div>

<div class="mb-3">
                                                    <label for="branchName" class="form-label">
                                                        <i class="fas fa-map-pin form-icon me-1"></i>Branch Name
                                                    </label>
                                                    <input type="text" id="branchName" name="branch_name" 
                                                           class="form-control" 
                                                           value="<?php echo htmlspecialchars($edit_data['branch_name'] ?? ($_POST['branch_name'] ?? '')); ?>"
                                                           placeholder="Branch name">
                                                </div>

<div class="signature-section">
                                                    <label class="form-label">
                                                        <i class="fas fa-signature form-icon me-1"></i>Authorized Signature
                                                    </label>
                                                    <div class="signature-upload-container" id="signatureUploadContainer">
                                                        <div id="signaturePreview">
                                                            <?php 
                                                            $current_signature = $edit_data['signature_path'] ?? '';
                                                            if (!empty($current_signature) && file_exists($current_signature)): 
                                                            ?>
                                                                <img src="<?php echo htmlspecialchars($current_signature); ?>" 
                                                                     alt="Authorized Signature" 
                                                                     class="signature-preview mb-2"
                                                                     onerror="this.style.display='none'; document.getElementById('defaultSignature').style.display='block';">
                                                                <div id="defaultSignature" style="display:none;">
                                                                    <div class="signature-placeholder">
                                                                        <i class="fas fa-signature"></i>
                                                                    </div>
                                                                    <small>Signature preview not available</small>
                                                                </div>
                                                            <?php else: ?>
                                                                <div id="defaultSignature">
                                                                    <div class="signature-placeholder">
                                                                        <i class="fas fa-signature"></i>
                                                                    </div>
                                                                    <small>Click or drag to upload signature</small>
                                                                </div>
                                                            <?php endif; ?>
                                                        </div>
                                                        <input type="file" id="signature" name="signature" 
                                                               accept=".jpg,.jpeg,.png,.gif,.webp" 
                                                               class="d-none">
                                                        <div class="signature-info">
                                                            Max size: 2MB • Formats: JPG, PNG, GIF, WebP
                                                        </div>
                                                        <?php if (!empty($current_signature) && file_exists($current_signature)): ?>
                                                            <button type="button" class="btn btn-sm btn-outline-danger signature-remove-btn" id="removeSignature">
                                                                <i class="fas fa-trash me-1"></i>Remove
                                                            </button>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

<div class="mb-4">
                                            <div class="form-check form-switch">
                                                <input class="form-check-input" type="checkbox" id="gstStatus" 
                                                       name="gst_status" value="1"
                                                       <?php echo (!empty($edit_data) && $edit_data['gst_status'] == 1) || (isset($_POST['gst_status']) && $_POST['gst_status'] == 1) ? 'checked' : ''; ?>>
                                                <label class="form-check-label" for="gstStatus">
                                                    <i class="fas fa-toggle-on me-1"></i>Active Status
                                                </label>
                                            </div>
                                            <div class="form-help-text">
                                                Active GST numbers will be available for use in invoices
                                            </div>
                                        </div>

<div class="row mt-4">
                                            <div class="col-12">
                                                <div class="d-flex justify-content-between">
                                                    <?php if (!empty($edit_data)): ?>
                                                        <a href="manage-gstn.php" class="btn btn-secondary">
                                                            <i class="fas fa-times me-1"></i>Cancel Edit
                                                        </a>
                                                    <?php else: ?>
                                                        <button type="reset" class="btn btn-outline-secondary" id="resetForm">
                                                            <i class="fas fa-redo me-1"></i>Reset
                                                        </button>
                                                    <?php endif; ?>
                                                    <button type="submit" class="btn btn-primary px-4">
                                                        <i class="fas fa-save me-1"></i>
                                                        <?php echo !empty($edit_data) ? 'Update GSTN' : 'Add GSTN'; ?>
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </form>
                                </div>
                            </div>

<div class="card mt-4">
                                <div class="card-body">
                                    <h5 class="card-title mb-4">
                                        <i class="fas fa-info-circle me-2"></i>GST Information
                                    </h5>
                                    
                                    <div class="mb-3">
                                        <h6 class="text-muted mb-2">What is GSTIN?</h6>
                                        <p class="mb-0">GSTIN (Goods and Services Tax Identification Number) is a 15-digit unique identification number assigned to every registered business under GST.</p>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <h6 class="text-muted mb-2">Features:</h6>
                                        <ul class="mb-0">
                                            <li>Add business logo for professional invoices</li>
                                            <li>Upload authorized signature for authenticity</li>
                                            <li>Store current account details for payment information</li>
                                            <li>Multiple GST numbers for different business entities</li>
                                            <li>Only active GST numbers appear in invoice options</li>
                                            <li>All information will be printed on invoices</li>
                                        </ul>
                                    </div>
                                    
                                    <div class="alert alert-warning mt-3">
                                        <i class="fas fa-exclamation-triangle me-2"></i>
                                        <small>Ensure all information is correct before saving. This will be displayed on invoices.</small>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="col-xl-6">
                            
                            <div class="card">
                                <div class="card-body">
                                    <h5 class="card-title mb-4">
                                        <i class="fas fa-list me-2"></i>Existing GST Numbers
                                        <span class="badge bg-primary ms-2"><?php echo count($gst_details); ?></span>
                                    </h5>
                                    
                                    <?php if (empty($gst_details)): ?>
                                        
                                        <div class="empty-state">
                                            <i class="fas fa-id-card"></i>
                                            <h4>No GST Numbers Found</h4>
                                            <p class="mb-4">You haven't added any GST numbers yet. Add your first GST number using the form on the left.</p>
                                        </div>
                                    <?php else: ?>
                                        <div class="table-responsive">
                                            <table class="table table-hover">
                                                <thead>
                                                    <tr>
                                                        <th width="5%">#</th>
                                                        <th width="8%">Logo</th>
                                                        <th width="8%">Signature</th>
                                                        <th width="20%">Business Name</th>
                                                        <th width="12%">Address</th>
                                                        <th width="12%">GST Number</th>
                                                        <th width="8%">Account</th>
                                                        <th width="10%">Status</th>
                                                        <th width="12%">Last Updated</th>
                                                        <th width="10%">Actions</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php foreach ($gst_details as $index => $gst): ?>
                                                        <tr>
                                                            <td><?php echo $index + 1; ?></td>
                                                            <td class="logo-cell">
                                                                <?php if (!empty($gst['logo_path']) && file_exists($gst['logo_path'])): ?>
                                                                    <img src="<?php echo htmlspecialchars($gst['logo_path']); ?>" 
                                                                         alt="Logo" 
                                                                         class="logo-table-img"
                                                                         onerror="this.style.display='none'; this.parentNode.innerHTML='<i class=\"fas fa-image text-muted\"></i>';">
                                                                <?php else: ?>
                                                                    <i class="fas fa-image text-muted"></i>
                                                                <?php endif; ?>
                                                            </td>
                                                            <td class="signature-cell">
                                                                <?php if (!empty($gst['signature_path']) && file_exists($gst['signature_path'])): ?>
                                                                    <img src="<?php echo htmlspecialchars($gst['signature_path']); ?>" 
                                                                         alt="Signature" 
                                                                         class="signature-table-img"
                                                                         onerror="this.style.display='none'; this.parentNode.innerHTML='<i class=\"fas fa-signature text-muted\"></i>';">
                                                                <?php else: ?>
                                                                    <i class="fas fa-signature text-muted"></i>
                                                                <?php endif; ?>
                                                            </td>
                                                            <td>
                                                                <div class="business-name"><?php echo htmlspecialchars($gst['business_name'] ?? 'N/A'); ?></div>
                                                                <small class="text-muted">ID: #<?php echo $gst['id']; ?></small>
                                                            </td>
                                                            <td class="address-cell">
                                                                <div class="business-address" title="<?php echo htmlspecialchars($gst['business_address'] ?? ''); ?>">
                                                                    <?php 
                                                                    if (!empty($gst['business_address'])) {
                                                                        echo htmlspecialchars(substr($gst['business_address'], 0, 20));
                                                                        if (strlen($gst['business_address']) > 20) {
                                                                            echo '...';
                                                                        }
                                                                    } else {
                                                                        echo 'Not set';
                                                                    }
                                                                    ?>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <span class="badge bg-light text-dark">
                                                                    <?php echo htmlspecialchars($gst['gst_num'] ?? 'N/A'); ?>
                                                                </span>
                                                            </td>
                                                            <td>
                                                                <?php if (!empty($gst['account_number'])): ?>
                                                                    <span class="badge bg-info" title="<?php echo htmlspecialchars($gst['bank_name'] ?? '') . ' - ' . htmlspecialchars($gst['account_number'] ?? ''); ?>">
                                                                        <i class="fas fa-university me-1"></i>Account
                                                                    </span>
                                                                <?php else: ?>
                                                                    <span class="badge bg-secondary">No Account</span>
                                                                <?php endif; ?>
                                                            </td>
                                                            <td>
                                                                <span class="badge gst-badge <?php echo ($gst['gst_status'] ?? 0) == 1 ? 'status-active' : 'status-inactive'; ?>">
                                                                    <i class="fas fa-circle me-1" style="font-size: 0.5rem;"></i>
                                                                    <?php echo ($gst['gst_status'] ?? 0) == 1 ? 'Active' : 'Inactive'; ?>
                                                                </span>
                                                            </td>
                                                            <td>
                                                                <small class="text-muted">
                                                                    <?php 
                                                                    if (!empty($gst['last_updated'])) {
                                                                        echo date('M j, Y', strtotime($gst['last_updated']));
                                                                    } else {
                                                                        echo 'Never';
                                                                    }
                                                                    ?>
                                                                </small>
                                                            </td>
                                                            <td>
                                                                <div class="action-buttons d-flex gap-2">
                                                                    <a href="manage-gstn.php?edit_id=<?php echo $gst['id']; ?>" 
                                                                       class="btn btn-sm btn-outline-primary" 
                                                                       title="Edit GSTN">
                                                                        <i class="fas fa-edit"></i>
                                                                    </a>
                                                                    <a href="manage-gstn.php?toggle_status=<?php echo $gst['id']; ?>" 
                                                                       class="btn btn-sm btn-outline-warning" 
                                                                       title="<?php echo ($gst['gst_status'] ?? 0) == 1 ? 'Deactivate' : 'Activate'; ?>"
                                                                       onclick="return confirm('Are you sure you want to <?php echo ($gst['gst_status'] ?? 0) == 1 ? 'deactivate' : 'activate'; ?> this GST number?')">
                                                                        <i class="fas fa-power-off"></i>
                                                                    </a>
                                                                    <a href="manage-gstn.php?delete_id=<?php echo $gst['id']; ?>" 
                                                                       class="btn btn-sm btn-outline-danger" 
                                                                       title="Delete GSTN"
                                                                       onclick="return confirm('Are you sure you want to delete this GST number? This action cannot be undone.')">
                                                                        <i class="fas fa-trash"></i>
                                                                    </a>
                                                                </div>
                                                            </td>
                                                        </tr>
                                                    <?php endforeach; ?>
                                                </tbody>
                                            </table>
                                        </div>

<div class="row mt-4">
                                            <div class="col-md-12">
                                                <div class="alert alert-light">
                                                    <div class="d-flex justify-content-between align-items-center">
                                                        <div>
                                                            <strong>Summary:</strong> 
                                                            Showing <?php echo count($gst_details); ?> GST number(s)
                                                        </div>
                                                        <div class="d-flex gap-2">
                                                            <?php 
                                                            $active_count = array_filter($gst_details, function($gst) {
                                                                return ($gst['gst_status'] ?? 0) == 1;
                                                            });
                                                            $logos_count = array_filter($gst_details, function($gst) {
                                                                return !empty($gst['logo_path']) && file_exists($gst['logo_path']);
                                                            });
                                                            $signatures_count = array_filter($gst_details, function($gst) {
                                                                return !empty($gst['signature_path']) && file_exists($gst['signature_path']);
                                                            });
                                                            $accounts_count = array_filter($gst_details, function($gst) {
                                                                return !empty($gst['account_number']);
                                                            });
                                                            ?>
                                                            <span class="badge bg-success">Active: <?php echo count($active_count); ?></span>
                                                            <span class="badge bg-secondary">Inactive: <?php echo count($gst_details) - count($active_count); ?></span>
                                                            <span class="badge bg-info">Logos: <?php echo count($logos_count); ?></span>
                                                            <span class="badge bg-warning">Signatures: <?php echo count($signatures_count); ?></span>
                                                            <span class="badge bg-primary">Accounts: <?php echo count($accounts_count); ?></span>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    <?php endif; ?>
                                </div>
                            </div>

<div class="card mt-4">
                                <div class="card-body">
                                    <h5 class="card-title mb-4">
                                        <i class="fas fa-lightbulb me-2"></i>Quick Tips
                                    </h5>
                                    
                                    <ul class="mb-0">
                                        <li>Add logos for professional invoice appearance</li>
                                        <li>Upload signature for invoice authenticity (under account details)</li>
                                        <li>Add current account details for payment information</li>
                                        <li>Recommended logo size: 200x100 pixels</li>
                                        <li>Signature should be transparent PNG for best results</li>
                                        <li>Use PNG format with transparent background for logos</li>
                                        <li>Account details are optional but recommended</li>
                                        <li>IFSC code format: ABCD0123456</li>
                                        <li>Account number should be 9-18 digits</li>
                                        <li>Hover over address to see full text</li>
                                        <li>Update GST status when a number becomes invalid</li>
                                    </ul>
                                </div>
                            </div>

<?php if (!empty($logos_count) || !empty($signatures_count)): ?>
                            <div class="card mt-4">
                                <div class="card-body">
                                    <h5 class="card-title mb-4">
                                        <i class="fas fa-images me-2"></i>Uploaded Files Preview
                                    </h5>
                                    <div class="logo-grid">
                                        <?php foreach ($gst_details as $gst): 
                                            if (!empty($gst['logo_path']) && file_exists($gst['logo_path'])): 
                                        ?>
                                            <div class="logo-grid-item">
                                                <img src="<?php echo htmlspecialchars($gst['logo_path']); ?>" 
                                                     alt="<?php echo htmlspecialchars($gst['business_name']); ?>" 
                                                     class="logo-grid-img"
                                                     onerror="this.style.display='none'; this.parentNode.querySelector('.logo-grid-name').innerHTML='<i>Logo missing</i>';">
                                                <div class="logo-grid-name" title="<?php echo htmlspecialchars($gst['business_name']); ?>">
                                                    <?php 
                                                    echo htmlspecialchars(substr($gst['business_name'], 0, 15));
                                                    if (strlen($gst['business_name']) > 15) {
                                                        echo '...';
                                                    }
                                                    ?> (Logo)
                                                </div>
                                            </div>
                                        <?php endif; 
                                            if (!empty($gst['signature_path']) && file_exists($gst['signature_path'])): 
                                        ?>
                                            <div class="logo-grid-item">
                                                <img src="<?php echo htmlspecialchars($gst['signature_path']); ?>" 
                                                     alt="<?php echo htmlspecialchars($gst['business_name']); ?> Signature" 
                                                     class="logo-grid-img"
                                                     onerror="this.style.display='none'; this.parentNode.querySelector('.logo-grid-name').innerHTML='<i>Signature missing</i>';">
                                                <div class="logo-grid-name" title="<?php echo htmlspecialchars($gst['business_name']); ?>">
                                                    <?php 
                                                    echo htmlspecialchars(substr($gst['business_name'], 0, 15));
                                                    if (strlen($gst['business_name']) > 15) {
                                                        echo '...';
                                                    }
                                                    ?> (Signature)
                                                </div>
                                            </div>
                                        <?php endif; 
                                        endforeach; ?>
                                    </div>
                                </div>
                            </div>
                            <?php endif; ?>
                        </div>
                    </div>

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

<?php include('includes/rightbar.php'); ?>
    <?php include('includes/scripts.php'); ?>
    
    <script>
    $(document).ready(function() {
        // Initialize tooltips
        $('[title]').tooltip();
        
        // File upload functionality for logo
        setupFileUpload('logoUploadContainer', 'businessLogo', 'logoPreview', 'defaultLogo', 'removeLogo', 'logo');
        
        // File upload functionality for signature
        setupFileUpload('signatureUploadContainer', 'signature', 'signaturePreview', 'defaultSignature', 'removeSignature', 'signature', true);
        
        function setupFileUpload(containerId, inputId, previewId, defaultId, removeBtnId, type = 'logo', isSmall = false) {
            const uploadContainer = document.getElementById(containerId);
            const fileInput = document.getElementById(inputId);
            const previewDiv = document.getElementById(previewId);
            const defaultDiv = document.getElementById(defaultId);
            
            if (uploadContainer && fileInput) {
                // Click to upload
                uploadContainer.addEventListener('click', function() {
                    fileInput.click();
                });
                
                // File selection
                fileInput.addEventListener('change', function(e) {
                    const file = e.target.files[0];
                    if (file) {
                        previewFile(file, previewDiv, defaultDiv, type, isSmall);
                    }
                });
                
                // Drag and drop
                ['dragenter', 'dragover', 'dragleave', 'drop'].forEach(eventName => {
                    uploadContainer.addEventListener(eventName, preventDefaults, false);
                });
                
                function preventDefaults(e) {
                    e.preventDefault();
                    e.stopPropagation();
                }
                
                ['dragenter', 'dragover'].forEach(eventName => {
                    uploadContainer.addEventListener(eventName, highlight, false);
                });
                
                ['dragleave', 'drop'].forEach(eventName => {
                    uploadContainer.addEventListener(eventName, unhighlight, false);
                });
                
                function highlight() {
                    uploadContainer.classList.add('dragover');
                }
                
                function unhighlight() {
                    uploadContainer.classList.remove('dragover');
                }
                
                uploadContainer.addEventListener('drop', function(e) {
                    const dt = e.dataTransfer;
                    const file = dt.files[0];
                    if (file && file.type.startsWith('image/')) {
                        fileInput.files = dt.files;
                        previewFile(file, previewDiv, defaultDiv, type, isSmall);
                    }
                });
            }
        }
        
        function previewFile(file, previewDiv, defaultDiv, type = 'logo', isSmall = false) {
            // Validate file type
            const validTypes = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif', 'image/webp'];
            if (!validTypes.includes(file.type)) {
                alert(`Invalid file type for ${type}. Please select an image (JPG, PNG, GIF, or WebP).`);
                return;
            }
            
            // Validate file size (2MB)
            if (file.size > 2 * 1024 * 1024) {
                alert(`File size too large for ${type}. Maximum size is 2MB.`);
                return;
            }
            
            const reader = new FileReader();
            reader.onload = function(e) {
                const img = document.createElement('img');
                img.src = e.target.result;
                img.className = isSmall ? 'signature-preview mb-2' : 'logo-preview mb-2';
                img.onload = function() {
                    // Validate dimensions
                    if (this.width > 2000 || this.height > 2000) {
                        alert(`Image dimensions too large for ${type}. Maximum is 2000x2000 pixels.`);
                        return;
                    }
                    previewDiv.innerHTML = '';
                    previewDiv.appendChild(img);
                    
                    // Show remove button
                    const removeBtnId = `remove${type.charAt(0).toUpperCase() + type.slice(1)}`;
                    if (!document.getElementById(removeBtnId)) {
                        const removeBtn = document.createElement('button');
                        removeBtn.type = 'button';
                        removeBtn.className = isSmall ? 'btn btn-sm btn-outline-danger signature-remove-btn' : 'btn btn-sm btn-outline-danger logo-remove-btn';
                        removeBtn.id = removeBtnId;
                        removeBtn.innerHTML = '<i class="fas fa-trash me-1"></i>' + (isSmall ? 'Remove' : 'Remove ' + type.charAt(0).toUpperCase() + type.slice(1));
                        removeBtn.addEventListener('click', function() {
                            removeFile(type, previewDiv, defaultDiv, isSmall);
                        });
                        previewDiv.appendChild(removeBtn);
                    }
                };
            };
            reader.readAsDataURL(file);
        }
        
        function removeFile(type, previewDiv, defaultDiv, isSmall = false) {
            const fileInputId = type === 'signature' ? 'signature' : 'businessLogo';
            const fileInput = document.getElementById(fileInputId);
            fileInput.value = '';
            previewDiv.innerHTML = '';
            
            // Show default placeholder
            if (defaultDiv) {
                previewDiv.appendChild(defaultDiv);
                defaultDiv.style.display = 'block';
            } else {
                const placeholder = document.createElement('div');
                placeholder.id = 'default' + type.charAt(0).toUpperCase() + type.slice(1);
                placeholder.innerHTML = `
                    <div class="${isSmall ? 'signature-placeholder' : 'logo-placeholder'}">
                        <i class="fas fa-${type === 'signature' ? 'signature' : 'image'}"></i>
                    </div>
                    <small>Click or drag to upload ${type}</small>
                `;
                previewDiv.appendChild(placeholder);
            }
            
            // Remove existing file reference
            const existingFileInput = document.querySelector(`input[name="existing_${type}"]`);
            if (existingFileInput) {
                existingFileInput.remove();
            }
        }
        
        // Attach remove function to existing buttons
        const existingRemoveLogoBtn = document.getElementById('removeLogo');
        if (existingRemoveLogoBtn) {
            existingRemoveLogoBtn.addEventListener('click', function() {
                removeFile('logo', document.getElementById('logoPreview'), document.getElementById('defaultLogo'), false);
            });
        }
        
        const existingRemoveSignatureBtn = document.getElementById('removeSignature');
        if (existingRemoveSignatureBtn) {
            existingRemoveSignatureBtn.addEventListener('click', function() {
                removeFile('signature', document.getElementById('signaturePreview'), document.getElementById('defaultSignature'), true);
            });
        }
        
        // GST number format validation
        $('#gstNum').on('blur', function() {
            var gstNum = $(this).val().trim();
            var pattern = /^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}$/;
            
            if (gstNum !== '' && !pattern.test(gstNum)) {
                alert('Invalid GST number format. Please enter a valid 15-digit GSTIN.\n\nFormat: 22AAAAA0000A1Z5');
                $(this).focus();
                $(this).addClass('is-invalid');
            } else {
                $(this).removeClass('is-invalid');
            }
        });
        
        // Auto-format GST number (uppercase and remove spaces)
        $('#gstNum').on('input', function() {
            var value = $(this).val();
            $(this).val(value.toUpperCase().replace(/\s/g, ''));
        });
        
        // Auto-format IFSC code (uppercase)
        $('#ifscCode').on('input', function() {
            var value = $(this).val();
            $(this).val(value.toUpperCase().replace(/\s/g, ''));
        });
        
        // Validate IFSC code
        $('#ifscCode').on('blur', function() {
            var ifscCode = $(this).val().trim();
            var pattern = /^[A-Z]{4}0[A-Z0-9]{6}$/;
            
            if (ifscCode !== '' && !pattern.test(ifscCode)) {
                alert('Invalid IFSC code format. Should be like ABCD0123456');
                $(this).focus();
                $(this).addClass('is-invalid');
            } else {
                $(this).removeClass('is-invalid');
            }
        });
        
        // Validate account number
        $('#accountNumber').on('blur', function() {
            var accountNumber = $(this).val().trim();
            var pattern = /^[0-9]{9,18}$/;
            
            if (accountNumber !== '' && !pattern.test(accountNumber)) {
                alert('Invalid account number. Should be 9-18 digits.');
                $(this).focus();
                $(this).addClass('is-invalid');
            } else {
                $(this).removeClass('is-invalid');
            }
        });
        
        // Form submission validation
        $('#gstForm').submit(function(e) {
            var businessName = $('#businessName').val().trim();
            var gstNum = $('#gstNum').val().trim();
            var pattern = /^[0-9]{2}[A-Z]{5}[0-9]{4}[A-Z]{1}[1-9A-Z]{1}Z[0-9A-Z]{1}$/;
            var ifscCode = $('#ifscCode').val().trim();
            var accountNumber = $('#accountNumber').val().trim();
            
            // Reset error styles
            $('#businessName, #gstNum, #ifscCode, #accountNumber').removeClass('is-invalid');
            
            if (businessName === '') {
                e.preventDefault();
                alert('Please enter business name');
                $('#businessName').addClass('is-invalid').focus();
                return false;
            }
            
            if (gstNum === '') {
                e.preventDefault();
                alert('Please enter GST number');
                $('#gstNum').addClass('is-invalid').focus();
                return false;
            }
            if (!pattern.test(gstNum)) {
                e.preventDefault();
                alert('Invalid GST number format. Please enter a valid 15-digit GSTIN.\n\nExample: 22AAAAA0000A1Z5');
                $('#gstNum').addClass('is-invalid').focus();
                return false;
            }
            
            // Validate IFSC code if provided
            if (ifscCode !== '') {
                var ifscPattern = /^[A-Z]{4}0[A-Z0-9]{6}$/;
                if (!ifscPattern.test(ifscCode)) {
                    e.preventDefault();
                    alert('Invalid IFSC code format. Should be like ABCD0123456');
                    $('#ifscCode').addClass('is-invalid').focus();
                    return false;
                }
            }
            
            // Validate account number if provided
            if (accountNumber !== '') {
                var accountPattern = /^[0-9]{9,18}$/;
                if (!accountPattern.test(accountNumber)) {
                    e.preventDefault();
                    alert('Invalid account number. Should be 9-18 digits.');
                    $('#accountNumber').addClass('is-invalid').focus();
                    return false;
                }
            }
            return true;
        });
        
        // Reset form functionality
        $('#resetForm').click(function() {
            if (confirm('Are you sure you want to reset the form? All unsaved changes will be lost.')) {
                $('#gstForm')[0].reset();
                // Clear file inputs and previews
                removeFile('logo', document.getElementById('logoPreview'), document.getElementById('defaultLogo'), false);
                removeFile('signature', document.getElementById('signaturePreview'), document.getElementById('defaultSignature'), true);
            }
        });
        
        // Auto-focus on business name field if not editing
        <?php if (empty($edit_data)): ?>
            $('#businessName').focus();
        <?php endif; ?>
    });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-gstn.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation