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

🔧 Quick Actions

✏️ Editing: quotation-settings.php

<?php
// === server bootstrap & includes ===
include('includes/db.php');

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

// Check if user has admin role
$user_role = isset($_SESSION['user_role']) ? $_SESSION['user_role'] : 'sale';
if ($user_role !== 'admin') {
    header("Location: index.php");
    exit();
}

// Normalize connection charset/collation
mysqli_query($conn, "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci");
mysqli_query($conn, "SET collation_connection = 'utf8mb4_unicode_ci'");

// --- helpers ---
function h($v) { 
    return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); 
}

// Handle form submissions
$message = '';
$message_type = '';

// Add new template
if (isset($_POST['add_template'])) {
    $template_name = mysqli_real_escape_string($conn, $_POST['template_name']);
    $template_code = mysqli_real_escape_string($conn, $_POST['template_code']);
    $description = mysqli_real_escape_string($conn, $_POST['description']);
    $html_content = mysqli_real_escape_string($conn, $_POST['html_content']);
    $header_html = mysqli_real_escape_string($conn, $_POST['header_html']);
    $footer_html = mysqli_real_escape_string($conn, $_POST['footer_html']);
    $css_styles = mysqli_real_escape_string($conn, $_POST['css_styles']);
    $paper_size = mysqli_real_escape_string($conn, $_POST['paper_size']);
    $orientation = mysqli_real_escape_string($conn, $_POST['orientation']);
    $margin_top = (float)$_POST['margin_top'];
    $margin_bottom = (float)$_POST['margin_bottom'];
    $margin_left = (float)$_POST['margin_left'];
    $margin_right = (float)$_POST['margin_right'];
    
    // Check if template code already exists
    $check_sql = "SELECT id FROM quotation_templates WHERE template_code = '$template_code'";
    $check_result = mysqli_query($conn, $check_sql);
    
    if (mysqli_num_rows($check_result) > 0) {
        $message = "Template code already exists!";
        $message_type = "danger";
    } else {
        $sql = "INSERT INTO quotation_templates (template_name, template_code, description, html_content, header_html, 
                footer_html, css_styles, paper_size, orientation, margin_top, margin_bottom, margin_left, margin_right, 
                is_active, is_default, created_by) 
                VALUES ('$template_name', '$template_code', '$description', '$html_content', '$header_html', 
                '$footer_html', '$css_styles', '$paper_size', '$orientation', $margin_top, $margin_bottom, 
                $margin_left, $margin_right, 1, 0, " . $_SESSION['user_id'] . ")";
        
        if (mysqli_query($conn, $sql)) {
            $message = "Template added successfully!";
            $message_type = "success";
        } else {
            $message = "Error adding template: " . mysqli_error($conn);
            $message_type = "danger";
        }
    }
}

// Update template
if (isset($_POST['update_template'])) {
    $template_id = (int)$_POST['template_id'];
    $template_name = mysqli_real_escape_string($conn, $_POST['template_name']);
    $template_code = mysqli_real_escape_string($conn, $_POST['template_code']);
    $description = mysqli_real_escape_string($conn, $_POST['description']);
    $html_content = mysqli_real_escape_string($conn, $_POST['html_content']);
    $header_html = mysqli_real_escape_string($conn, $_POST['header_html']);
    $footer_html = mysqli_real_escape_string($conn, $_POST['footer_html']);
    $css_styles = mysqli_real_escape_string($conn, $_POST['css_styles']);
    $paper_size = mysqli_real_escape_string($conn, $_POST['paper_size']);
    $orientation = mysqli_real_escape_string($conn, $_POST['orientation']);
    $margin_top = (float)$_POST['margin_top'];
    $margin_bottom = (float)$_POST['margin_bottom'];
    $margin_left = (float)$_POST['margin_left'];
    $margin_right = (float)$_POST['margin_right'];
    $is_active = isset($_POST['is_active']) ? 1 : 0;
    $is_default = isset($_POST['is_default']) ? 1 : 0;
    
    // If setting as default, unset other defaults
    if ($is_default) {
        mysqli_query($conn, "UPDATE quotation_templates SET is_default = 0 WHERE id != $template_id");
    }
    
    $sql = "UPDATE quotation_templates SET 
            template_name = '$template_name',
            template_code = '$template_code',
            description = '$description',
            html_content = '$html_content',
            header_html = '$header_html',
            footer_html = '$footer_html',
            css_styles = '$css_styles',
            paper_size = '$paper_size',
            orientation = '$orientation',
            margin_top = $margin_top,
            margin_bottom = $margin_bottom,
            margin_left = $margin_left,
            margin_right = $margin_right,
            is_active = $is_active,
            is_default = $is_default,
            updated_at = NOW()
            WHERE id = $template_id";
    
    if (mysqli_query($conn, $sql)) {
        $message = "Template updated successfully!";
        $message_type = "success";
    } else {
        $message = "Error updating template: " . mysqli_error($conn);
        $message_type = "danger";
    }
}

// Delete template
if (isset($_GET['delete'])) {
    $template_id = (int)$_GET['delete'];
    
    // Check if template is in use
    $check_sql = "SELECT COUNT(*) as count FROM quotations WHERE template_name = (
        SELECT template_name FROM quotation_templates WHERE id = $template_id
    )";
    $check_result = mysqli_query($conn, $check_sql);
    $row = mysqli_fetch_assoc($check_result);
    
    if ($row['count'] > 0) {
        $message = "Cannot delete template as it is in use by existing quotations!";
        $message_type = "danger";
    } else {
        $sql = "DELETE FROM quotation_templates WHERE id = $template_id";
        if (mysqli_query($conn, $sql)) {
            $message = "Template deleted successfully!";
            $message_type = "success";
        } else {
            $message = "Error deleting template: " . mysqli_error($conn);
            $message_type = "danger";
        }
    }
}

// Get all templates
$templates = [];
$sql = "SELECT * FROM quotation_templates ORDER BY is_default DESC, template_name ASC";
$result = mysqli_query($conn, $sql);
if ($result) {
    while ($row = mysqli_fetch_assoc($result)) {
        $templates[] = $row;
    }
}

// Get template details for editing
$edit_template = null;
if (isset($_GET['edit'])) {
    $template_id = (int)$_GET['edit'];
    $sql = "SELECT * FROM quotation_templates WHERE id = $template_id";
    $result = mysqli_query($conn, $sql);
    if ($result && mysqli_num_rows($result) > 0) {
        $edit_template = mysqli_fetch_assoc($result);
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <?php include('includes/head.php'); ?>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        .template-card {
            transition: transform 0.2s, box-shadow 0.2s;
            height: 100%;
        }
        .template-card:hover {
            transform: translateY(-5px);
            box-shadow: 0 5px 15px rgba(0,0,0,0.1);
        }
        .template-active {
            border-left: 4px solid #28a745;
        }
        .template-inactive {
            border-left: 4px solid #dc3545;
        }
        .template-default {
            border-left: 4px solid #007bff;
        }
        .code-badge {
            font-family: 'Courier New', monospace;
            font-size: 0.85rem;
        }
        .preview-container {
            max-height: 300px;
            overflow-y: auto;
            border: 1px solid #dee2e6;
            border-radius: 5px;
            padding: 15px;
            background: #f8f9fa;
        }
        .action-buttons .btn {
            margin-right: 5px;
            margin-bottom: 5px;
        }
    </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">Quotation Templates Settings</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                    <li class="breadcrumb-item active">Quotation Templates</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php if ($message): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="alert alert-<?php echo $message_type; ?> alert-dismissible fade show" role="alert">
                            <?php echo h($message); ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">
                                    <?php echo $edit_template ? 'Edit Template' : 'Add New Template'; ?>
                                </h5>
                                
                                <form method="POST" action="">
                                    <?php if ($edit_template): ?>
                                    <input type="hidden" name="template_id" value="<?php echo h($edit_template['id']); ?>">
                                    <?php endif; ?>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="template_name" class="form-label">Template Name *</label>
                                                <input type="text" class="form-control" id="template_name" name="template_name" 
                                                       value="<?php echo $edit_template ? h($edit_template['template_name']) : ''; ?>" required>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="template_code" class="form-label">Template Code *</label>
                                                <input type="text" class="form-control" id="template_code" name="template_code" 
                                                       value="<?php echo $edit_template ? h($edit_template['template_code']) : ''; ?>" required>
                                                <small class="text-muted">Unique identifier (e.g., CLASSIC, MODERN)</small>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="description" class="form-label">Description</label>
                                        <textarea class="form-control" id="description" name="description" rows="2"><?php echo $edit_template ? h($edit_template['description']) : ''; ?></textarea>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label for="paper_size" class="form-label">Paper Size</label>
                                                <select class="form-select" id="paper_size" name="paper_size">
                                                    <option value="A4" <?php echo ($edit_template && $edit_template['paper_size'] == 'A4') ? 'selected' : ''; ?>>A4</option>
                                                    <option value="A5" <?php echo ($edit_template && $edit_template['paper_size'] == 'A5') ? 'selected' : ''; ?>>A5</option>
                                                    <option value="Letter" <?php echo ($edit_template && $edit_template['paper_size'] == 'Letter') ? 'selected' : ''; ?>>Letter</option>
                                                    <option value="Legal" <?php echo ($edit_template && $edit_template['paper_size'] == 'Legal') ? 'selected' : ''; ?>>Legal</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label for="orientation" class="form-label">Orientation</label>
                                                <select class="form-select" id="orientation" name="orientation">
                                                    <option value="portrait" <?php echo ($edit_template && $edit_template['orientation'] == 'portrait') ? 'selected' : ''; ?>>Portrait</option>
                                                    <option value="landscape" <?php echo ($edit_template && $edit_template['orientation'] == 'landscape') ? 'selected' : ''; ?>>Landscape</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="row">
                                                <div class="col-3">
                                                    <label class="form-label">Margins (mm)</label>
                                                </div>
                                                <div class="col-9">
                                                    <div class="row g-2">
                                                        <div class="col-3">
                                                            <input type="number" class="form-control" name="margin_top" 
                                                                   value="<?php echo $edit_template ? h($edit_template['margin_top']) : '10'; ?>" step="0.1" min="0" max="50">
                                                            <small class="text-muted">Top</small>
                                                        </div>
                                                        <div class="col-3">
                                                            <input type="number" class="form-control" name="margin_bottom" 
                                                                   value="<?php echo $edit_template ? h($edit_template['margin_bottom']) : '10'; ?>" step="0.1" min="0" max="50">
                                                            <small class="text-muted">Bottom</small>
                                                        </div>
                                                        <div class="col-3">
                                                            <input type="number" class="form-control" name="margin_left" 
                                                                   value="<?php echo $edit_template ? h($edit_template['margin_left']) : '10'; ?>" step="0.1" min="0" max="50">
                                                            <small class="text-muted">Left</small>
                                                        </div>
                                                        <div class="col-3">
                                                            <input type="number" class="form-control" name="margin_right" 
                                                                   value="<?php echo $edit_template ? h($edit_template['margin_right']) : '10'; ?>" step="0.1" min="0" max="50">
                                                            <small class="text-muted">Right</small>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="html_content" class="form-label">HTML Content *</label>
                                        <textarea class="form-control" id="html_content" name="html_content" rows="8" required><?php echo $edit_template ? h($edit_template['html_content']) : ''; ?></textarea>
                                        <small class="text-muted">Use placeholders like {{company_name}}, {{customer_name}}, {{items_table}}, {{subtotal}}, {{total_amount}}</small>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="header_html" class="form-label">Header HTML</label>
                                                <textarea class="form-control" id="header_html" name="header_html" rows="3"><?php echo $edit_template ? h($edit_template['header_html']) : ''; ?></textarea>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="footer_html" class="form-label">Footer HTML</label>
                                                <textarea class="form-control" id="footer_html" name="footer_html" rows="3"><?php echo $edit_template ? h($edit_template['footer_html']) : ''; ?></textarea>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="css_styles" class="form-label">CSS Styles</label>
                                        <textarea class="form-control" id="css_styles" name="css_styles" rows="4"><?php echo $edit_template ? h($edit_template['css_styles']) : ''; ?></textarea>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <div class="form-check form-check-inline">
                                            <input class="form-check-input" type="checkbox" id="is_active" name="is_active" value="1" 
                                                   <?php echo ($edit_template && $edit_template['is_active']) ? 'checked' : 'checked'; ?>>
                                            <label class="form-check-label" for="is_active">Active</label>
                                        </div>
                                        <div class="form-check form-check-inline">
                                            <input class="form-check-input" type="checkbox" id="is_default" name="is_default" value="1"
                                                   <?php echo ($edit_template && $edit_template['is_default']) ? 'checked' : ''; ?>>
                                            <label class="form-check-label" for="is_default">Set as Default Template</label>
                                        </div>
                                    </div>
                                    
                                    <div class="d-flex justify-content-end">
                                        <?php if ($edit_template): ?>
                                            <a href="quotation-settings.php" class="btn btn-secondary me-2">Cancel</a>
                                            <button type="submit" name="update_template" class="btn btn-primary">Update Template</button>
                                        <?php else: ?>
                                            <button type="submit" name="add_template" class="btn btn-success">Add Template</button>
                                        <?php endif; ?>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Available Templates</h5>
                                
                                <?php if (empty($templates)): ?>
                                    <div class="alert alert-info">
                                        No templates found. Add your first template using the form above.
                                    </div>
                                <?php else: ?>
                                    <div class="row">
                                        <?php foreach ($templates as $template): 
                                            $status_class = '';
                                            if (!$template['is_active']) {
                                                $status_class = 'template-inactive';
                                            } elseif ($template['is_default']) {
                                                $status_class = 'template-default';
                                            } else {
                                                $status_class = 'template-active';
                                            }
                                        ?>
                                        <div class="col-md-6 col-lg-4 mb-4">
                                            <div class="card template-card <?php echo $status_class; ?>">
                                                <div class="card-body">
                                                    <div class="d-flex justify-content-between align-items-start mb-2">
                                                        <h5 class="card-title mb-0"><?php echo h($template['template_name']); ?></h5>
                                                        <span class="badge bg-secondary code-badge"><?php echo h($template['template_code']); ?></span>
                                                    </div>
                                                    
                                                    <?php if ($template['description']): ?>
                                                    <p class="text-muted small"><?php echo h($template['description']); ?></p>
                                                    <?php endif; ?>
                                                    
                                                    <div class="d-flex mb-3">
                                                        <span class="badge bg-light text-dark me-2">
                                                            <i class="fas fa-file"></i> <?php echo h($template['paper_size']); ?>
                                                        </span>
                                                        <span class="badge bg-light text-dark me-2">
                                                            <i class="fas fa-expand-alt"></i> <?php echo h($template['orientation']); ?>
                                                        </span>
                                                        <?php if ($template['is_default']): ?>
                                                        <span class="badge bg-primary">
                                                            <i class="fas fa-star"></i> Default
                                                        </span>
                                                        <?php endif; ?>
                                                        <?php if (!$template['is_active']): ?>
                                                        <span class="badge bg-danger">
                                                            <i class="fas fa-ban"></i> Inactive
                                                        </span>
                                                        <?php endif; ?>
                                                    </div>
                                                    
                                                    <div class="preview-container mb-3">
                                                        <?php 
                                                        $preview = strip_tags($template['html_content']);
                                                        echo strlen($preview) > 150 ? substr($preview, 0, 150) . '...' : $preview;
                                                        ?>
                                                    </div>
                                                    
                                                    <div class="action-buttons">
                                                        <a href="quotation-settings.php?edit=<?php echo $template['id']; ?>" 
                                                           class="btn btn-sm btn-outline-primary">
                                                            <i class="fas fa-edit"></i> Edit
                                                        </a>
                                                        <a href="quotation-settings.php?delete=<?php echo $template['id']; ?>" 
                                                           class="btn btn-sm btn-outline-danger"
                                                           onclick="return confirm('Are you sure you want to delete this template?');">
                                                            <i class="fas fa-trash"></i> Delete
                                                        </a>
                                                        <?php if ($template['is_active'] && !$template['is_default']): ?>
                                                        <a href="quotation-settings.php?set_default=<?php echo $template['id']; ?>" 
                                                           class="btn btn-sm btn-outline-success"
                                                           onclick="return confirm('Set this as default template?');">
                                                            <i class="fas fa-star"></i> Set Default
                                                        </a>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <?php endforeach; ?>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>

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

</div>

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

// Scroll to form when editing
<?php if ($edit_template): ?>
document.addEventListener('DOMContentLoaded', function() {
    document.getElementById('template_name').focus();
    window.scrollTo({ top: 0, behavior: 'smooth' });
});
<?php endif; ?>
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: quotation-settings.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation