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

🔧 Quick Actions

✏️ Editing: add-template.php

<?php
require_once('includes/db.php');

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

$success = '';
$error = '';
$template_data = [];

// Handle edit mode
$edit_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
$is_edit = $edit_id > 0;

if ($is_edit) {
    $edit_sql = "SELECT * FROM quotation_templates WHERE id = $edit_id";
    $edit_result = mysqli_query($conn, $edit_sql);
    
    if ($edit_result && mysqli_num_rows($edit_result) > 0) {
        $template_data = mysqli_fetch_assoc($edit_result);
    } else {
        $error = 'Template not found!';
        header("Location: quotation-templates.php");
        exit();
    }
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $template_name = mysqli_real_escape_string($conn, trim($_POST['template_name'] ?? ''));
    $template_code = mysqli_real_escape_string($conn, trim($_POST['template_code'] ?? ''));
    $description = mysqli_real_escape_string($conn, trim($_POST['description'] ?? ''));
    $html_content = $_POST['html_content'] ?? '';
    $paper_size = mysqli_real_escape_string($conn, $_POST['paper_size'] ?? 'A4');
    $orientation = mysqli_real_escape_string($conn, $_POST['orientation'] ?? 'portrait');
    $is_active = isset($_POST['is_active']) ? 1 : 0;
    $is_default = isset($_POST['is_default']) ? 1 : 0;
    
    // Validate
    $errors = [];
    
    if (empty($template_name)) {
        $errors[] = 'Template name is required';
    }
    
    if (empty($template_code)) {
        $errors[] = 'Template code is required';
    } elseif (!preg_match('/^[A-Z0-9_]{3,20}$/', $template_code)) {
        $errors[] = 'Template code must be 3-20 characters, uppercase letters, numbers, or underscores only';
    }
    
    if (empty($html_content)) {
        $errors[] = 'HTML content is required';
    }
    
    if (empty($errors)) {
        // Check if template code already exists (excluding current in edit mode)
        $check_sql = "SELECT id FROM quotation_templates WHERE template_code = '$template_code'";
        if ($is_edit) {
            $check_sql .= " AND id != $edit_id";
        }
        
        $check_result = mysqli_query($conn, $check_sql);
        
        if (mysqli_num_rows($check_result) > 0) {
            $error = 'Template code already exists. Please choose a different code.';
        } else {
            if ($is_default) {
                // Unset all defaults first
                $reset_sql = "UPDATE quotation_templates SET is_default = FALSE";
                mysqli_query($conn, $reset_sql);
            }
            
            if ($is_edit) {
                // Update template
                $update_sql = "UPDATE quotation_templates SET 
                              template_name = '$template_name',
                              template_code = '$template_code',
                              description = '$description',
                              html_content = '" . mysqli_real_escape_string($conn, $html_content) . "',
                              paper_size = '$paper_size',
                              orientation = '$orientation',
                              is_active = $is_active,
                              is_default = $is_default,
                              updated_at = NOW()
                              WHERE id = $edit_id";
                
                if (mysqli_query($conn, $update_sql)) {
                    $success = 'Template updated successfully!';
                } else {
                    $error = 'Error updating template: ' . mysqli_error($conn);
                }
            } else {
                // Insert new template
                $insert_sql = "INSERT INTO quotation_templates 
                              (template_name, template_code, description, html_content, paper_size, orientation, is_active, is_default, created_by) 
                              VALUES 
                              ('$template_name', '$template_code', '$description', 
                               '" . mysqli_real_escape_string($conn, $html_content) . "', 
                               '$paper_size', '$orientation', $is_active, $is_default, 
                               '" . ($_SESSION['user_id'] ?? 1) . "')";
                
                if (mysqli_query($conn, $insert_sql)) {
                    $success = 'Template created successfully!';
                    // Clear form
                    $_POST = array();
                    header("Location: quotation-templates.php");
                    exit();
                } else {
                    $error = 'Error creating template: ' . mysqli_error($conn);
                }
            }
        }
    } else {
        $error = implode('<br>', $errors);
    }
}

// Set form values
$form_values = $is_edit ? $template_data : $_POST;
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    <link href="https://cdn.jsdelivr.net/npm/codemirror@5.62.3/lib/codemirror.min.css" rel="stylesheet">
    <link href="https://cdn.jsdelivr.net/npm/codemirror@5.62.3/theme/dracula.css" rel="stylesheet">
    <style>
        .template-preview {
            border: 1px solid #dee2e6;
            border-radius: 5px;
            height: 400px;
            overflow: auto;
        }
        .CodeMirror {
            height: 400px;
            border: 1px solid #dee2e6;
            border-radius: 5px;
        }
        .var-badge {
            cursor: pointer;
            margin: 2px;
        }
        .var-badge:hover {
            opacity: 0.8;
        }
    </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="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"><?php echo $is_edit ? 'Edit Template' : 'Add New Template'; ?></h4>
                                <div class="page-title-right">
                                    <a href="quotation-templates.php" class="btn btn-secondary">
                                        <i class="fas fa-arrow-left me-1"></i> Back to Templates
                                    </a>
                                </div>
                            </div>
                        </div>
                    </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; ?>

<form method="POST" id="templateForm">
                        <div class="row">
                            <div class="col-md-8">
                                
                                <div class="card">
                                    <div class="card-body">
                                        <h5 class="card-title mb-4">Template Details</h5>
                                        
                                        <div class="row mb-3">
                                            <div class="col-md-6">
                                                <label class="form-label">Template Name *</label>
                                                <input type="text" name="template_name" class="form-control" 
                                                       value="<?php echo htmlspecialchars($form_values['template_name'] ?? ''); ?>"
                                                       required placeholder="e.g., Classic Invoice">
                                            </div>
                                            <div class="col-md-6">
                                                <label class="form-label">Template Code *</label>
                                                <input type="text" name="template_code" class="form-control" 
                                                       value="<?php echo htmlspecialchars($form_values['template_code'] ?? ''); ?>"
                                                       required placeholder="e.g., CLASSIC_INVOICE" 
                                                       pattern="[A-Z0-9_]{3,20}">
                                                <small class="text-muted">3-20 characters, uppercase, numbers, or underscores only</small>
                                            </div>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <label class="form-label">Description</label>
                                            <textarea name="description" class="form-control" rows="3"
                                                      placeholder="Describe this template..."><?php echo htmlspecialchars($form_values['description'] ?? ''); ?></textarea>
                                        </div>
                                        
                                        <div class="row mb-3">
                                            <div class="col-md-4">
                                                <label class="form-label">Paper Size</label>
                                                <select name="paper_size" class="form-select">
                                                    <option value="A4" <?php echo ($form_values['paper_size'] ?? 'A4') === 'A4' ? 'selected' : ''; ?>>A4</option>
                                                    <option value="A5" <?php echo ($form_values['paper_size'] ?? '') === 'A5' ? 'selected' : ''; ?>>A5</option>
                                                    <option value="Letter" <?php echo ($form_values['paper_size'] ?? '') === 'Letter' ? 'selected' : ''; ?>>Letter</option>
                                                    <option value="Legal" <?php echo ($form_values['paper_size'] ?? '') === 'Legal' ? 'selected' : ''; ?>>Legal</option>
                                                </select>
                                            </div>
                                            <div class="col-md-4">
                                                <label class="form-label">Orientation</label>
                                                <select name="orientation" class="form-select">
                                                    <option value="portrait" <?php echo ($form_values['orientation'] ?? 'portrait') === 'portrait' ? 'selected' : ''; ?>>Portrait</option>
                                                    <option value="landscape" <?php echo ($form_values['orientation'] ?? '') === 'landscape' ? 'selected' : ''; ?>>Landscape</option>
                                                </select>
                                            </div>
                                            <div class="col-md-4">
                                                <label class="form-label">Status</label>
                                                <div class="mt-2">
                                                    <div class="form-check form-check-inline">
                                                        <input class="form-check-input" type="checkbox" name="is_active" value="1" 
                                                               id="isActive" <?php echo ($form_values['is_active'] ?? 1) ? 'checked' : ''; ?>>
                                                        <label class="form-check-label" for="isActive">Active</label>
                                                    </div>
                                                    <div class="form-check form-check-inline">
                                                        <input class="form-check-input" type="checkbox" name="is_default" value="1" 
                                                               id="isDefault" <?php echo ($form_values['is_default'] ?? 0) ? 'checked' : ''; ?>>
                                                        <label class="form-check-label" for="isDefault">Set as Default</label>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                
                                
                                <div class="card mt-4">
                                    <div class="card-body">
                                        <h5 class="card-title mb-4">
                                            HTML Template
                                            <button type="button" class="btn btn-sm btn-outline-primary float-end" 
                                                    onclick="showTemplateVariables()">
                                                <i class="fas fa-code me-1"></i> Available Variables
                                            </button>
                                        </h5>
                                        
                                        <label class="form-label">HTML Content *</label>
                                        <textarea name="html_content" id="htmlContent" class="form-control" 
                                                  rows="15" required><?php echo htmlspecialchars($form_values['html_content'] ?? ''); ?></textarea>
                                    </div>
                                </div>
                            </div>
                            
                            <div class="col-md-4">
                                
                                <div class="card">
                                    <div class="card-body">
                                        <h5 class="card-title mb-4">Template Variables</h5>
                                        <p class="text-muted">Click on any variable to insert it into the HTML editor.</p>
                                        
                                        <div class="mb-3">
                                            <h6>Company Variables:</h6>
                                            <?php 
                                            $company_vars = [
                                                'company_name', 'company_address', 'company_phone', 
                                                'company_email', 'gst_number', 'company_tagline'
                                            ];
                                            foreach ($company_vars as $var): ?>
                                                <span class="badge bg-primary var-badge" onclick="insertVariable('{{<?php echo $var; ?>}}')">
                                                    {{<?php echo $var; ?>}}
                                                </span>
                                            <?php endforeach; ?>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <h6>Quotation Variables:</h6>
                                            <?php 
                                            $quote_vars = [
                                                'quotation_no', 'quotation_date', 'customer_name',
                                                'customer_address', 'customer_phone', 'items_table',
                                                'tax_rows', 'subtotal', 'total_amount'
                                            ];
                                            foreach ($quote_vars as $var): ?>
                                                <span class="badge bg-success var-badge" onclick="insertVariable('{{<?php echo $var; ?>}}')">
                                                    {{<?php echo $var; ?>}}
                                                </span>
                                            <?php endforeach; ?>
                                        </div>
                                        
                                        <div class="mb-3">
                                            <h6>Special Variables:</h6>
                                            <span class="badge bg-info var-badge" onclick="insertVariable('{{items_table}}')">
                                                {{items_table}} (Items HTML table)
                                            </span>
                                            <span class="badge bg-info var-badge" onclick="insertVariable('{{tax_rows}}')">
                                                {{tax_rows}} (Tax rows HTML)
                                            </span>
                                        </div>
                                        
                                        <div class="alert alert-warning mt-3">
                                            <i class="fas fa-lightbulb me-2"></i>
                                            <small>Use <code>{% for item in items %}</code> loops for dynamic content if needed.</small>
                                        </div>
                                    </div>
                                </div>
                                
                                
                                <div class="card mt-4">
                                    <div class="card-body">
                                        <h5 class="card-title mb-4">Quick Actions</h5>
                                        
                                        <div class="d-grid gap-2">
                                            <button type="submit" class="btn btn-primary">
                                                <i class="fas fa-save me-1"></i>
                                                <?php echo $is_edit ? 'Update Template' : 'Save Template'; ?>
                                            </button>
                                            
                                            <?php if ($is_edit): ?>
                                                <a href="preview-template.php?id=<?php echo $edit_id; ?>" 
                                                   target="_blank" class="btn btn-outline-info">
                                                    <i class="fas fa-eye me-1"></i> Preview Template
                                                </a>
                                            <?php endif; ?>
                                            
                                            <button type="button" class="btn btn-outline-secondary" onclick="resetForm()">
                                                <i class="fas fa-redo me-1"></i> Reset Form
                                            </button>
                                            
                                            <a href="quotation-templates.php" class="btn btn-outline-danger">
                                                <i class="fas fa-times me-1"></i> Cancel
                                            </a>
                                        </div>
                                    </div>
                                </div>
                                
                                
                                <div class="card mt-4">
                                    <div class="card-body">
                                        <h5 class="card-title mb-4">Live Preview</h5>
                                        <div id="livePreview" class="template-preview p-3">
                                            <p class="text-muted">Preview will appear here...</p>
                                        </div>
                                        <button type="button" class="btn btn-sm btn-outline-primary mt-3 w-100" 
                                                onclick="updatePreview()">
                                            <i class="fas fa-sync me-1"></i> Update Preview
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <?php include('includes/footer.php'); ?>
        </div>
    </div>

<?php include('includes/rightbar.php'); ?>
    <?php include('includes/scripts.php'); ?>
    
    <script src="https://cdn.jsdelivr.net/npm/codemirror@5.62.3/lib/codemirror.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/codemirror@5.62.3/mode/xml/xml.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/codemirror@5.62.3/mode/htmlmixed/htmlmixed.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/codemirror@5.62.3/mode/css/css.js"></script>
    
    <script>
    // Initialize CodeMirror
    const editor = CodeMirror.fromTextArea(document.getElementById('htmlContent'), {
        mode: "htmlmixed",
        theme: "dracula",
        lineNumbers: true,
        autoCloseTags: true,
        matchBrackets: true,
        lineWrapping: true
    });
    
    // Insert variable into editor
    function insertVariable(variable) {
        const doc = editor.getDoc();
        const cursor = doc.getCursor();
        doc.replaceRange(variable, cursor);
        editor.focus();
    }
    
    // Update live preview
    function updatePreview() {
        const htmlContent = editor.getValue();
        const previewDiv = document.getElementById('livePreview');
        
        // Replace variables with sample data
        let previewHtml = htmlContent
            .replace(/{{company_name}}/g, 'Sample Business')
            .replace(/{{company_address}}/g, '123 Business Street, City, State 12345')
            .replace(/{{company_phone}}/g, '(123) 456-7890')
            .replace(/{{company_email}}/g, 'info@samplebusiness.com')
            .replace(/{{gst_number}}/g, '22AAAAA0000A1Z5')
            .replace(/{{company_tagline}}/g, 'Quality Products & Services')
            .replace(/{{quotation_no}}/g, 'QTN-2024-001')
            .replace(/{{quotation_date}}/g, '<?php echo date('d M, Y'); ?>')
            .replace(/{{customer_name}}/g, 'John Doe')
            .replace(/{{customer_address}}/g, '456 Customer Ave, City, State 67890')
            .replace(/{{customer_phone}}/g, '(987) 654-3210')
            .replace(/{{items_table}}/g, `
                <tr>
                    <td>1</td>
                    <td>Sample Product 1</td>
                    <td>2</td>
                    <td>₹500.00</td>
                    <td>₹1,000.00</td>
                </tr>
                <tr>
                    <td>2</td>
                    <td>Sample Product 2</td>
                    <td>1</td>
                    <td>₹1,500.00</td>
                    <td>₹1,500.00</td>
                </tr>
            `)
            .replace(/{{tax_rows}}/g, `
                <div class="total-row">
                    <div class="total-label">GST (18%):</div>
                    <div class="total-value">₹450.00</div>
                </div>
            `)
            .replace(/{{subtotal}}/g, '₹2,500.00')
            .replace(/{{total_amount}}/g, '₹2,950.00');
        
        previewDiv.innerHTML = previewHtml;
    }
    
    // Show template variables modal
    function showTemplateVariables() {
        alert('Available Variables:\n\n' +
              'Company Variables:\n' +
              '{{company_name}} - Business name\n' +
              '{{company_address}} - Business address\n' +
              '{{company_phone}} - Business phone\n' +
              '{{company_email}} - Business email\n' +
              '{{gst_number}} - GST number\n' +
              '{{company_tagline}} - Business tagline\n\n' +
              'Quotation Variables:\n' +
              '{{quotation_no}} - Quotation number\n' +
              '{{quotation_date}} - Quotation date\n' +
              '{{customer_name}} - Customer name\n' +
              '{{customer_address}} - Customer address\n' +
              '{{customer_phone}} - Customer phone\n' +
              '{{items_table}} - Items HTML table\n' +
              '{{tax_rows}} - Tax rows HTML\n' +
              '{{subtotal}} - Subtotal amount\n' +
              '{{total_amount}} - Total amount');
    }
    
    // Reset form
    function resetForm() {
        if (confirm('Are you sure you want to reset the form? All changes will be lost.')) {
            document.getElementById('templateForm').reset();
            editor.setValue('');
            document.getElementById('livePreview').innerHTML = '<p class="text-muted">Preview will appear here...</p>';
        }
    }
    
    // Auto-update preview when editor changes (debounced)
    let updateTimeout;
    editor.on('change', () => {
        clearTimeout(updateTimeout);
        updateTimeout = setTimeout(updatePreview, 1000);
    });
    
    // Initial preview
    setTimeout(updatePreview, 500);
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-template.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation