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

🔧 Quick Actions

✏️ Editing: quotation-templates.php

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

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

/**
 * STATIC FILE LISTS
 */
$quotation_templates = [
  
    'quo-daimond.php',
    'quo-pro.php',
     
    
    'quo-profestional.php',
    'quo-ribbon.php',
   
];

$invoice_templates = [
    
    'inv-daimond.php',
    
  'inv-pro.php',
    'inv-profestional.php',
    'inv-ribbon.php',
   
];

// Process template arrays for dropdowns
function process_template_files($files, $prefix = 'quo') {
    $templates = [];
    foreach ($files as $f) {
        $safe_file = basename($f);
        $friendly = friendly_name_from_file($safe_file, $prefix);
        $templates[] = [
            'file' => $safe_file,
            'name' => $friendly,
            'type' => ($prefix === 'quo') ? 'quotation' : 'invoice'
        ];
    }
    return $templates;
}

$quotation_options = process_template_files($quotation_templates, 'quo');
$invoice_options = process_template_files($invoice_templates, 'inv');

// Helper to create friendly name
function friendly_name_from_file($f, $prefix = 'quo') {
    $n = preg_replace('/\.php$/i', '', $f);
    $n = str_replace([$prefix . '-', '-'], ['', ' '], $n);
    return ucwords($n);
}

// Helper find preview URL
function find_preview_url($file) {
    if (!preg_match('/^[a-z0-9_\-]+\.php$/i', $file)) return null;

// templates/ directory first
    $t1 = __DIR__ . '/templates/' . $file;
    if (file_exists($t1)) {
        return 'templates/' . rawurlencode($file);
    }

// then current directory
    $t2 = __DIR__ . '/' . $file;
    if (file_exists($t2)) {
        return rawurlencode($file);
    }

return null;
}

// Handle template-business mapping
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action']) && $_POST['action'] === 'map_template') {
        $quotation_file = isset($_POST['quotation_file']) ? mysqli_real_escape_string($conn, $_POST['quotation_file']) : '';
        $quotation_name = isset($_POST['quotation_name']) ? mysqli_real_escape_string($conn, $_POST['quotation_name']) : '';
        $invoice_file = isset($_POST['invoice_file']) ? mysqli_real_escape_string($conn, $_POST['invoice_file']) : '';
        $invoice_name = isset($_POST['invoice_name']) ? mysqli_real_escape_string($conn, $_POST['invoice_name']) : '';
        $business_id = isset($_POST['business_id']) ? (int)$_POST['business_id'] : 0;
        
        if ($business_id > 0 && !empty($quotation_file) && !empty($invoice_file)) {
            // Check if this business already has a mapping
            $check_sql = "SELECT id, template_file, template_name, invoice_file, invoice_name 
                         FROM template_mapping WHERE gst_id = ?";
            $check_stmt = mysqli_prepare($conn, $check_sql);
            mysqli_stmt_bind_param($check_stmt, "i", $business_id);
            mysqli_stmt_execute($check_stmt);
            mysqli_stmt_store_result($check_stmt);
            
            if (mysqli_stmt_num_rows($check_stmt) > 0) {
                // Business already has a mapping - UPDATE
                mysqli_stmt_bind_result($check_stmt, $existing_id, $existing_quo_file, $existing_quo_name, $existing_inv_file, $existing_inv_name);
                mysqli_stmt_fetch($check_stmt);
                
                // Update both quotation and invoice templates
                $update_sql = "UPDATE template_mapping SET 
                              template_file = ?, template_name = ?,
                              invoice_file = ?, invoice_name = ?,
                              is_active = 1
                              WHERE gst_id = ?";
                $update_stmt = mysqli_prepare($conn, $update_sql);
                mysqli_stmt_bind_param($update_stmt, "ssssi", 
                    $quotation_file, $quotation_name,
                    $invoice_file, $invoice_name,
                    $business_id);
                
                if (mysqli_stmt_execute($update_stmt)) {
                    $changes = [];
                    if ($existing_quo_file !== $quotation_file) {
                        $changes[] = "Quotation: '{$existing_quo_name}' → '{$quotation_name}'";
                    }
                    if ($existing_inv_file !== $invoice_file) {
                        $changes[] = "Invoice: '{$existing_inv_name}' → '{$invoice_name}'";
                    }
                    
                    if (empty($changes)) {
                        $success = "Template mapping already up to date!";
                    } else {
                        $success = "Templates updated: " . implode(", ", $changes);
                    }
                } else {
                    $error = "Failed to update template mapping: " . mysqli_error($conn);
                }
                mysqli_stmt_close($update_stmt);
            } else {
                // Insert new mapping for this business
                $insert_sql = "INSERT INTO template_mapping 
                              (template_file, template_name, invoice_file, invoice_name, 
                               shop_id, gst_id, is_active, created_at) 
                              VALUES (?, ?, ?, ?, 1, ?, 1, CURRENT_TIMESTAMP)";
                $insert_stmt = mysqli_prepare($conn, $insert_sql);
                mysqli_stmt_bind_param($insert_stmt, "ssssi", 
                    $quotation_file, $quotation_name,
                    $invoice_file, $invoice_name,
                    $business_id);
                
                if (mysqli_stmt_execute($insert_stmt)) {
                    $success = "Templates mapped to business successfully!";
                } else {
                    $error = "Failed to map templates: " . mysqli_error($conn);
                }
                mysqli_stmt_close($insert_stmt);
            }
            mysqli_stmt_close($check_stmt);
        } else {
            $error = "Please select a business and both templates!";
        }
    }
    
    // Handle remove mapping
    if (isset($_POST['action']) && $_POST['action'] === 'remove_mapping') {
        $mapping_id = isset($_POST['mapping_id']) ? (int)$_POST['mapping_id'] : 0;
        
        if ($mapping_id > 0) {
            // First check how many quotations use this mapping
            $check_sql = "SELECT COUNT(*) as quote_count, g.business_name, 
                         tm.template_name, tm.invoice_name
                         FROM template_mapping tm
                         LEFT JOIN gst_details g ON tm.gst_id = g.id
                         LEFT JOIN quotations q ON q.business_id = tm.gst_id
                         WHERE tm.id = ?";
            $check_stmt = mysqli_prepare($conn, $check_sql);
            mysqli_stmt_bind_param($check_stmt, "i", $mapping_id);
            mysqli_stmt_execute($check_stmt);
            mysqli_stmt_bind_result($check_stmt, $quote_count, $business_name, $quotation_name, $invoice_name);
            mysqli_stmt_fetch($check_stmt);
            mysqli_stmt_close($check_stmt);
            
            if ($quote_count > 0) {
                $error = "Cannot delete this mapping! <strong>{$quote_count} quotation(s)</strong> are currently using template '{$quotation_name}' for business '{$business_name}'. Please reassign quotations first.";
            } else {
                // No quotations using this mapping - safe to delete
                $delete_sql = "DELETE FROM template_mapping WHERE id = ?";
                $delete_stmt = mysqli_prepare($conn, $delete_sql);
                mysqli_stmt_bind_param($delete_stmt, "i", $mapping_id);
                if (mysqli_stmt_execute($delete_stmt)) {
                    $success = "Mapping removed successfully!";
                } else {
                    $error = "Failed to remove mapping: " . mysqli_error($conn);
                }
                mysqli_stmt_close($delete_stmt);
            }
        }
    }
    
    // Handle toggle active status for specific mapping
    if (isset($_POST['action']) && $_POST['action'] === 'toggle_mapping') {
        $mapping_id = isset($_POST['mapping_id']) ? (int)$_POST['mapping_id'] : 0;
        
        if ($mapping_id > 0) {
            // Get current status
            $status_sql = "SELECT is_active FROM template_mapping WHERE id = ?";
            $status_stmt = mysqli_prepare($conn, $status_sql);
            mysqli_stmt_bind_param($status_stmt, "i", $mapping_id);
            mysqli_stmt_execute($status_stmt);
            mysqli_stmt_bind_result($status_stmt, $current_status);
            mysqli_stmt_fetch($status_stmt);
            mysqli_stmt_close($status_stmt);
            
            $new_status = $current_status ? 0 : 1;
            
            // Update only this specific mapping
            $update_sql = "UPDATE template_mapping SET is_active = ? WHERE id = ?";
            $update_stmt = mysqli_prepare($conn, $update_sql);
            mysqli_stmt_bind_param($update_stmt, "ii", $new_status, $mapping_id);
            if (mysqli_stmt_execute($update_stmt)) {
                $status_text = $new_status ? 'activated' : 'deactivated';
                $success = "Mapping {$status_text} successfully!";
            } else {
                $error = "Failed to update mapping status: " . mysqli_error($conn);
            }
            mysqli_stmt_close($update_stmt);
        }
    }
    
    // Handle auto-generate invoice template
    if (isset($_POST['action']) && $_POST['action'] === 'auto_generate_invoice') {
        $quotation_file = isset($_POST['quotation_file']) ? mysqli_real_escape_string($conn, $_POST['quotation_file']) : '';
        
        if (!empty($quotation_file)) {
            // Generate invoice filename from quotation filename
            $invoice_file = preg_replace('/^quo-/', 'inv-', $quotation_file);
            $invoice_name = friendly_name_from_file($invoice_file, 'inv');
            
            // Check if invoice template exists
            $invoice_path = __DIR__ . '/' . $invoice_file;
            $templates_path = __DIR__ . '/templates/' . $invoice_file;
            
            if (file_exists($invoice_path) || file_exists($templates_path)) {
                echo json_encode([
                    'success' => true,
                    'invoice_file' => $invoice_file,
                    'invoice_name' => $invoice_name
                ]);
                exit;
            } else {
                echo json_encode([
                    'success' => false,
                    'message' => 'Invoice template not found: ' . $invoice_file
                ]);
                exit;
            }
        }
    }
}

// Get all businesses from gst_details table
$businesses_sql = "SELECT id, business_name, gst_num, gst_status FROM gst_details ORDER BY business_name";
$businesses_result = mysqli_query($conn, $businesses_sql);
$businesses = [];
if ($businesses_result) {
    while ($business = mysqli_fetch_assoc($businesses_result)) {
        $businesses[] = $business;
    }
}

// Get existing template mappings with quotation counts
$mappings_sql = "SELECT tm.*, 
                g.business_name, g.gst_num,
                COUNT(q.id) as quotation_count
                FROM template_mapping tm
                LEFT JOIN gst_details g ON tm.gst_id = g.id
                LEFT JOIN quotations q ON q.business_id = tm.gst_id
                GROUP BY tm.id, g.business_name, g.gst_num
                ORDER BY g.business_name, tm.created_at DESC";
$mappings_result = mysqli_query($conn, $mappings_sql);
$mappings = [];
if ($mappings_result) {
    while ($mapping = mysqli_fetch_assoc($mappings_result)) {
        $mappings[] = $mapping;
    }
}

// Get template usage statistics
$template_stats_sql = "SELECT 
    tm.template_file,
    tm.template_name,
    tm.invoice_file,
    tm.invoice_name,
    COUNT(DISTINCT tm.gst_id) as business_count,
    COUNT(DISTINCT q.id) as total_quotations
    FROM template_mapping tm
    LEFT JOIN quotations q ON q.business_id = tm.gst_id
    WHERE tm.is_active = 1
    GROUP BY tm.template_file, tm.template_name, tm.invoice_file, tm.invoice_name
    ORDER BY total_quotations DESC, template_name";
$template_stats_result = mysqli_query($conn, $template_stats_sql);
$template_stats = [];
if ($template_stats_result) {
    while ($stat = mysqli_fetch_assoc($template_stats_result)) {
        $template_stats[] = $stat;
    }
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    <style>
        .file-list-card { 
            margin-bottom: 20px;
            border: none;
            box-shadow: 0 0 20px rgba(0,0,0,0.08);
        }
        
        .file-list-table {
            margin: 0;
        }
        
        .file-list-table thead {
            background: #f8f9fa;
            color: #495057;
        }
        
        .file-list-table thead th {
            font-weight: 600;
            padding: 15px;
            border-bottom: 2px solid #dee2e6;
        }
        
        .file-list-table tbody tr {
            border-bottom: 1px solid #dee2e6;
        }
        
        .file-list-table tbody tr:hover {
            background-color: #f8f9fa;
        }
        
        .file-list-table tbody td {
            padding: 15px;
            vertical-align: middle;
            border: none;
        }
        
        .preview-iframe { 
            width: 100%; 
            height: 80vh; 
            border: none; 
            border-radius: 6px; 
        }
        
        .mapping-card {
            margin-bottom: 20px;
        }
        
        .mapping-status-active {
            color: #198754;
            background-color: rgba(25, 135, 84, 0.1);
            padding: 4px 8px;
            border-radius: 4px;
            font-size: 0.85em;
        }
        
        .mapping-status-inactive {
            color: #6c757d;
            background-color: rgba(108, 117, 125, 0.1);
            padding: 4px 8px;
            border-radius: 4px;
            font-size: 0.85em;
        }
        
        .business-badge {
            background: linear-gradient(45deg, #0d6efd, #0dcaf0);
            color: white;
            padding: 4px 8px;
            border-radius: 4px;
            font-size: 0.85em;
            display: inline-block;
            margin-bottom: 2px;
        }
        
        .template-badge {
            background: linear-gradient(45deg, #6f42c1, #6610f2);
            color: white;
            padding: 4px 8px;
            border-radius: 4px;
            font-size: 0.85em;
            display: inline-block;
            margin-bottom: 2px;
        }
        
        .invoice-badge {
            background: linear-gradient(45deg, #198754, #20c997);
            color: white;
            padding: 4px 8px;
            border-radius: 4px;
            font-size: 0.85em;
            display: inline-block;
            margin-bottom: 2px;
        }
        
        .quote-count-badge {
            background: linear-gradient(45deg, #fd7e14, #ffc107);
            color: white;
            padding: 2px 6px;
            border-radius: 3px;
            font-size: 0.75em;
            margin-left: 5px;
        }
        
        .template-type-tabs {
            border-bottom: 1px solid #dee2e6;
            margin-bottom: 0;
        }
        
        .template-type-tabs .nav-link {
            border: none;
            color: #6c757d;
            font-weight: 500;
            padding: 12px 20px;
        }
        
        .template-type-tabs .nav-link.active {
            color: #0d6efd;
            border-bottom: 2px solid #0d6efd;
            background: transparent;
        }
        
        .template-pair {
            background: #f8f9fa;
            border-radius: 8px;
            padding: 12px;
            margin-bottom: 12px;
            border-left: 4px solid #0d6efd;
        }
        
        .auto-generate-btn {
            padding: 4px 8px;
            font-size: 0.8rem;
            margin-left: 5px;
        }
        
        .template-relationship {
            font-size: 0.8rem;
            color: #666;
            margin-top: 5px;
            padding: 3px 8px;
            background: #e9ecef;
            border-radius: 3px;
            display: inline-block;
        }
        
        @media (max-width: 991px) { 
            .preview-iframe { 
                height: 70vh; 
            } 
        }
    </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>

<?php if (isset($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 $success; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                        </div>
                    <?php endif; ?>
                    
                    <?php if (isset($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; ?>

<?php if (!empty($template_stats)): ?>
                    <div class="row mb-4">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h5 class="mb-0"><i class="fas fa-chart-bar me-2"></i>Template Usage Statistics</h5>
                                </div>
                                <div class="card-body">
                                    <div class="row">
                                        <?php foreach ($template_stats as $stat): ?>
                                        <div class="col-md-6 mb-3">
                                            <div class="template-pair">
                                                <div class="d-flex justify-content-between align-items-start mb-2">
                                                    <div>
                                                        <strong>Quotation:</strong>
                                                        <span class="badge bg-primary ms-2"><?php echo htmlspecialchars($stat['template_name']); ?></span>
                                                    </div>
                                                    <div class="text-end">
                                                        <span class="badge bg-info">
                                                            <?php echo $stat['business_count']; ?> business<?php echo $stat['business_count'] != 1 ? 'es' : ''; ?>
                                                        </span>
                                                    </div>
                                                </div>
                                                <div class="d-flex justify-content-between align-items-start">
                                                    <div>
                                                        <strong>Invoice:</strong>
                                                        <span class="badge bg-success ms-2"><?php echo htmlspecialchars($stat['invoice_name']); ?></span>
                                                    </div>
                                                    <div class="text-end">
                                                        <span class="badge bg-success">
                                                            <?php echo $stat['total_quotations']; ?> quotation<?php echo $stat['total_quotations'] != 1 ? 's' : ''; ?>
                                                        </span>
                                                    </div>
                                                </div>
                                                <div class="mt-2 small text-muted">
                                                    <code><?php echo htmlspecialchars($stat['template_file']); ?></code> → 
                                                    <code><?php echo htmlspecialchars($stat['invoice_file']); ?></code>
                                                </div>
                                            </div>
                                        </div>
                                        <?php endforeach; ?>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <?php endif; ?>

<div class="row">
                        <div class="col-lg-6">
                            
                            <div class="card mapping-card">
                                <div class="card-header">
                                    <h5 class="mb-0"><i class="fas fa-link me-2"></i>Map Templates to Business</h5>
                                    <small class="text-muted">Select a business and both quotation/invoice templates to map.</small>
                                </div>
                                <div class="card-body">
                                    <form method="POST" action="" id="mappingForm">
                                        <input type="hidden" name="action" value="map_template">
                                        
                                        <div class="row mb-3">
                                            <div class="col-md-12">
                                                <label class="form-label">Select Business <span class="text-danger">*</span></label>
                                                <select name="business_id" class="form-control" required id="businessSelect">
                                                    <option value="">Choose a business...</option>
                                                    <?php foreach ($businesses as $business): ?>
                                                        <option value="<?php echo $business['id']; ?>">
                                                            <?php echo htmlspecialchars($business['business_name']); ?> 
                                                            <?php if ($business['gst_num']): ?>
                                                                (GST: <?php echo htmlspecialchars($business['gst_num']); ?>)
                                                            <?php endif; ?>
                                                        </option>
                                                    <?php endforeach; ?>
                                                </select>
                                                <div id="existingMappingInfo" class="mt-2 small" style="display: none;"></div>
                                            </div>
                                        </div>
                                        
                                        <div class="row mb-3">
                                            <div class="col-md-6">
                                                <label class="form-label">Quotation Template <span class="text-danger">*</span></label>
                                                <div class="input-group">
                                                    <select name="quotation_file" class="form-control" required id="quotationFile" onchange="autoGenerateInvoiceTemplate(this.value)">
                                                        <option value="">Choose quotation template...</option>
                                                        <?php foreach ($quotation_options as $template): ?>
                                                            <option value="<?php echo htmlspecialchars($template['file']); ?>" data-name="<?php echo htmlspecialchars($template['name']); ?>">
                                                                <?php echo htmlspecialchars($template['name']); ?>
                                                            </option>
                                                        <?php endforeach; ?>
                                                    </select>
                                                    <button type="button" class="btn btn-outline-secondary" onclick="autoGenerateInvoiceTemplate(document.getElementById('quotationFile').value)">
                                                        <i class="fas fa-sync-alt"></i>
                                                    </button>
                                                </div>
                                                <input type="hidden" name="quotation_name" id="quotation_name" value="">
                                                <div class="form-text">Select quotation template (starts with quo-)</div>
                                            </div>
                                            <div class="col-md-6">
                                                <label class="form-label">Invoice Template <span class="text-danger">*</span></label>
                                                <select name="invoice_file" class="form-control" required id="invoiceFile" onchange="updateInvoiceName(this)">
                                                    <option value="">Choose invoice template...</option>
                                                    <?php foreach ($invoice_options as $template): ?>
                                                        <option value="<?php echo htmlspecialchars($template['file']); ?>" data-name="<?php echo htmlspecialchars($template['name']); ?>">
                                                            <?php echo htmlspecialchars($template['name']); ?>
                                                        </option>
                                                    <?php endforeach; ?>
                                                </select>
                                                <input type="hidden" name="invoice_name" id="invoice_name" value="">
                                                <div class="form-text">Corresponding invoice template (starts with inv-)</div>
                                            </div>
                                        </div>
                                        
                                        <div class="alert alert-info mb-3">
                                            <small>
                                                <i class="fas fa-info-circle me-1"></i>
                                                <strong>Auto-mapping:</strong> When you select a quotation template (quo-), the system will automatically suggest the corresponding invoice template (inv-). Example: quo-pro.php → inv-pro.php
                                            </small>
                                        </div>
                                        
                                        <div class="text-end">
                                            <button type="submit" class="btn btn-primary" id="submitBtn">
                                                <i class="fas fa-save me-1"></i> Save Template Mapping
                                            </button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                        
                        <div class="col-lg-6">
                            
                            <div class="card mapping-card">
                                <div class="card-header d-flex justify-content-between align-items-center">
                                    <h5 class="mb-0"><i class="fas fa-list me-2"></i>Current Business-Template Mappings</h5>
                                    <span class="badge bg-primary"><?php echo count($mappings); ?> Mapped</span>
                                </div>
                                <div class="card-body p-0">
                                    <?php if (empty($mappings)): ?>
                                        <div class="text-center py-4">
                                            <i class="fas fa-unlink fa-3x text-muted mb-3"></i>
                                            <p class="text-muted">No template-business mappings found.</p>
                                        </div>
                                    <?php else: ?>
                                        <div class="table-responsive">
                                            <table class="table table-hover mb-0">
                                                <thead>
                                                    <tr>
                                                        <th width="5%">#</th>
                                                        <th width="20%">Business</th>
                                                        <th width="25%">Quotation</th>
                                                        <th width="25%">Invoice</th>
                                                        <th width="10%">Status</th>
                                                        <th width="15%" class="text-end">Actions</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php foreach ($mappings as $index => $mapping): ?>
                                                        <tr>
                                                            <td class="text-center"><?php echo $index + 1; ?></td>
                                                            <td>
                                                                <div>
                                                                    <span class="business-badge">
                                                                        <?php echo htmlspecialchars($mapping['business_name'] ?? 'N/A'); ?>
                                                                    </span>
                                                                    <?php if ($mapping['gst_num']): ?>
                                                                        <div class="small text-muted mt-1">
                                                                            GST: <?php echo htmlspecialchars($mapping['gst_num']); ?>
                                                                        </div>
                                                                    <?php endif; ?>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div>
                                                                    <?php if ($mapping['template_name']): ?>
                                                                        <span class="template-badge">
                                                                            <?php echo htmlspecialchars($mapping['template_name']); ?>
                                                                        </span>
                                                                    <?php else: ?>
                                                                        <span class="badge bg-warning text-dark">Not Set</span>
                                                                    <?php endif; ?>
                                                                    <div class="small text-muted mt-1">
                                                                        <code><?php echo htmlspecialchars($mapping['template_file'] ?? 'No file'); ?></code>
                                                                    </div>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <div>
                                                                    <?php if ($mapping['invoice_name']): ?>
                                                                        <span class="invoice-badge">
                                                                            <?php echo htmlspecialchars($mapping['invoice_name']); ?>
                                                                        </span>
                                                                    <?php else: ?>
                                                                        <span class="badge bg-warning text-dark">Not Set</span>
                                                                    <?php endif; ?>
                                                                    <div class="small text-muted mt-1">
                                                                        <code><?php echo htmlspecialchars($mapping['invoice_file'] ?? 'No file'); ?></code>
                                                                    </div>
                                                                </div>
                                                            </td>
                                                            <td>
                                                                <span class="<?php echo $mapping['is_active'] ? 'mapping-status-active' : 'mapping-status-inactive'; ?>">
                                                                    <?php echo $mapping['is_active'] ? 'Active' : 'Inactive'; ?>
                                                                </span>
                                                                <?php if ($mapping['quotation_count'] > 0): ?>
                                                                    <span class="quote-count-badge" title="<?php echo $mapping['quotation_count']; ?> quotation(s)">
                                                                        <?php echo $mapping['quotation_count']; ?>
                                                                    </span>
                                                                <?php endif; ?>
                                                            </td>
                                                            <td class="text-end">
                                                                <div class="btn-group btn-group-sm">
                                                                    
                                                                    <form method="POST" action="" style="display: inline;">
                                                                        <input type="hidden" name="action" value="toggle_mapping">
                                                                        <input type="hidden" name="mapping_id" value="<?php echo $mapping['id']; ?>">
                                                                        <button type="submit" class="btn btn-outline-warning" title="<?php echo $mapping['is_active'] ? 'Deactivate' : 'Activate'; ?>">
                                                                            <i class="fas fa-power-off"></i>
                                                                        </button>
                                                                    </form>
                                                                    
                                                                    
                                                                    <?php if ($mapping['quotation_count'] == 0): ?>
                                                                        <form method="POST" action="" style="display: inline;" onsubmit="return confirmDeleteMapping('<?php echo htmlspecialchars($mapping['business_name']); ?>')">
                                                                            <input type="hidden" name="action" value="remove_mapping">
                                                                            <input type="hidden" name="mapping_id" value="<?php echo $mapping['id']; ?>">
                                                                            <button type="submit" class="btn btn-outline-danger" title="Remove Mapping">
                                                                                <i class="fas fa-trash"></i>
                                                                            </button>
                                                                        </form>
                                                                    <?php else: ?>
                                                                        <button class="btn btn-outline-danger" disabled title="Cannot delete - <?php echo $mapping['quotation_count']; ?> quotation(s) using this template">
                                                                            <i class="fas fa-trash"></i>
                                                                        </button>
                                                                    <?php endif; ?>
                                                                </div>
                                                            </td>
                                                        </tr>
                                                    <?php endforeach; ?>
                                                </tbody>
                                            </table>
                                        </div>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="card file-list-card">
                        <div class="card-header">
                            <ul class="nav nav-tabs template-type-tabs" id="templateTabs" role="tablist">
                                <li class="nav-item" role="presentation">
                                    <button class="nav-link active" id="quotation-tab" data-bs-toggle="tab" data-bs-target="#quotation-templates" type="button" role="tab">
                                        <i class="fas fa-file-contract me-1"></i> Quotation Templates
                                        <span class="badge bg-primary ms-1"><?php echo count($quotation_templates); ?></span>
                                    </button>
                                </li>
                                <li class="nav-item" role="presentation">
                                    <button class="nav-link" id="invoice-tab" data-bs-toggle="tab" data-bs-target="#invoice-templates" type="button" role="tab">
                                        <i class="fas fa-file-invoice me-1"></i> Invoice Templates
                                        <span class="badge bg-success ms-1"><?php echo count($invoice_templates); ?></span>
                                    </button>
                                </li>
                            </ul>
                        </div>
                        <div class="card-body p-0">
                            <div class="tab-content" id="templateTabsContent">
                                
                                <div class="tab-pane fade show active" id="quotation-templates" role="tabpanel">
                                    <div class="table-responsive">
                                        <table class="table table-hover align-middle mb-0 file-list-table">
                                            <thead>
                                                <tr>
                                                    <th style="width:5%">#</th>
                                                    <th style="width:35%">Template Name</th>
                                                    <th style="width:25%">Filename</th>
                                                    <th style="width:25%">Corresponding Invoice</th>
                                                    <th style="width:10%" class="text-end">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php 
                                                $counter = 1;
                                                foreach ($quotation_templates as $f): 
                                                    $safe_file = basename($f);
                                                    $friendly = friendly_name_from_file($safe_file, 'quo');
                                                    $preview = find_preview_url($safe_file);
                                                    $exists = $preview ? true : false;
                                                    $invoice_file = preg_replace('/^quo-/', 'inv-', $safe_file);
                                                    $invoice_friendly = friendly_name_from_file($invoice_file, 'inv');
                                                ?>
                                                <tr>
                                                    <td class="text-center"><?php echo $counter++; ?></td>
                                                    <td>
                                                        <strong><?php echo htmlspecialchars($friendly); ?></strong>
                                                    </td>
                                                    <td>
                                                        <code><?php echo htmlspecialchars($safe_file); ?></code>
                                                    </td>
                                                    <td>
                                                        <span class="template-relationship">
                                                            <i class="fas fa-arrow-right me-1"></i>
                                                            <?php echo htmlspecialchars($invoice_friendly); ?>
                                                            <code class="ms-1"><?php echo htmlspecialchars($invoice_file); ?></code>
                                                        </span>
                                                    </td>
                                                    <td class="text-end">
                                                        <?php if ($exists): ?>
                                                            <button class="btn btn-sm btn-outline-primary"
                                                                    onclick="openPreviewFile('<?php echo addslashes($preview); ?>','<?php echo addslashes($friendly); ?> (Quotation)')">
                                                                <i class="fas fa-eye me-1"></i> View
                                                            </button>
                                                        <?php else: ?>
                                                            <button class="btn btn-sm btn-outline-secondary" disabled title="File not found">
                                                                <i class="fas fa-eye-slash me-1"></i> View
                                                            </button>
                                                        <?php endif; ?>
                                                    </td>
                                                </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                                
                                
                                <div class="tab-pane fade" id="invoice-templates" role="tabpanel">
                                    <div class="table-responsive">
                                        <table class="table table-hover align-middle mb-0 file-list-table">
                                            <thead>
                                                <tr>
                                                    <th style="width:5%">#</th>
                                                    <th style="width:35%">Template Name</th>
                                                    <th style="width:25%">Filename</th>
                                                    <th style="width:25%">Corresponding Quotation</th>
                                                    <th style="width:10%" class="text-end">Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php 
                                                $counter = 1;
                                                foreach ($invoice_templates as $f): 
                                                    $safe_file = basename($f);
                                                    $friendly = friendly_name_from_file($safe_file, 'inv');
                                                    $preview = find_preview_url($safe_file);
                                                    $exists = $preview ? true : false;
                                                    $quotation_file = preg_replace('/^inv-/', 'quo-', $safe_file);
                                                    $quotation_friendly = friendly_name_from_file($quotation_file, 'quo');
                                                ?>
                                                <tr>
                                                    <td class="text-center"><?php echo $counter++; ?></td>
                                                    <td>
                                                        <strong><?php echo htmlspecialchars($friendly); ?></strong>
                                                    </td>
                                                    <td>
                                                        <code><?php echo htmlspecialchars($safe_file); ?></code>
                                                    </td>
                                                    <td>
                                                        <span class="template-relationship">
                                                            <i class="fas fa-arrow-left me-1"></i>
                                                            <?php echo htmlspecialchars($quotation_friendly); ?>
                                                            <code class="ms-1"><?php echo htmlspecialchars($quotation_file); ?></code>
                                                        </span>
                                                    </td>
                                                    <td class="text-end">
                                                        <?php if ($exists): ?>
                                                            <button class="btn btn-sm btn-outline-primary"
                                                                    onclick="openPreviewFile('<?php echo addslashes($preview); ?>','<?php echo addslashes($friendly); ?> (Invoice)')">
                                                                <i class="fas fa-eye me-1"></i> View
                                                            </button>
                                                        <?php else: ?>
                                                            <button class="btn btn-sm btn-outline-secondary" disabled title="File not found">
                                                                <i class="fas fa-eye-slash me-1"></i> View
                                                            </button>
                                                        <?php endif; ?>
                                                    </td>
                                                </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

</div> 
            </div>

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

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

<div class="modal fade" id="templatePreviewModal" tabindex="-1" aria-labelledby="templatePreviewLabel" aria-hidden="true">
      <div class="modal-dialog modal-xl modal-fullscreen-sm-down">
        <div class="modal-content">
          <div class="modal-header">
            <h5 class="modal-title" id="templatePreviewLabel">Template Preview</h5>
            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close" onclick="closePreview()"></button>
          </div>
          <div class="modal-body p-0">
            <iframe id="previewFrame" class="preview-iframe" src="" frameborder="0" sandbox="allow-same-origin allow-scripts allow-forms"></iframe>
          </div>
        </div>
      </div>
    </div>

// Check if business already has a mapping
    document.getElementById('businessSelect')?.addEventListener('change', function() {
        const businessId = this.value;
        const infoDiv = document.getElementById('existingMappingInfo');
        
        if (!businessId) {
            infoDiv.style.display = 'none';
            return;
        }
        
        // AJAX call to check existing mapping
        fetch('check-existing-mapping.php?business_id=' + businessId)
            .then(response => response.json())
            .then(data => {
                if (data.exists) {
                    infoDiv.innerHTML = '<div class="alert alert-warning p-2">' +
                        '<i class="fas fa-info-circle me-1"></i>' +
                        'This business already has: ' +
                        '<strong>' + data.template_name + '</strong> (Quotation) and ' +
                        '<strong>' + data.invoice_name + '</strong> (Invoice). ' +
                        'Saving will update both templates.' +
                        '</div>';
                    infoDiv.style.display = 'block';
                    
                    // Pre-fill the form with existing values
                    if (data.template_file) {
                        document.getElementById('quotationFile').value = data.template_file;
                        document.getElementById('quotation_name').value = data.template_name;
                    }
                    if (data.invoice_file) {
                        document.getElementById('invoiceFile').value = data.invoice_file;
                        document.getElementById('invoice_name').value = data.invoice_name;
                    }
                } else {
                    infoDiv.style.display = 'none';
                }
            })
            .catch(error => {
                console.error('Error:', error);
                infoDiv.style.display = 'none';
            });
    });

// Confirm delete mapping
    function confirmDeleteMapping(businessName) {
        return confirm('Are you sure you want to remove template mapping for "' + businessName + '"?');
    }

// Open preview for file template
    function openPreviewFile(relPath, filename) {
        if (!relPath) return alert('Preview not available for: ' + filename);
        const iframe = document.getElementById('previewFrame');
        const modalTitle = document.getElementById('templatePreviewLabel');
        modalTitle.textContent = 'Preview — ' + filename;
        iframe.src = relPath;

const modalEl = document.getElementById('templatePreviewModal');
        const modal = new bootstrap.Modal(modalEl);
        modal.show();
    }

// Close preview and clear iframe src
    function closePreview() {
        const iframe = document.getElementById('previewFrame');
        iframe.src = '';
        
        const modalEl = document.getElementById('templatePreviewModal');
        const modal = bootstrap.Modal.getInstance(modalEl);
        if (modal) modal.hide();
    }

// Ensure iframe is cleared when modal closed
    document.addEventListener('DOMContentLoaded', function(){
        const modalEl = document.getElementById('templatePreviewModal');
        if (modalEl) {
            modalEl.addEventListener('hidden.bs.modal', function () {
                const iframe = document.getElementById('previewFrame');
                iframe.src = '';
            });
        }
        
        // Initialize template names
        const quotationSelect = document.getElementById('quotationFile');
        const invoiceSelect = document.getElementById('invoiceFile');
        
        if (quotationSelect && quotationSelect.value) {
            updateTemplateName(quotationSelect, 'quotation');
        }
        if (invoiceSelect && invoiceSelect.value) {
            updateInvoiceName(invoiceSelect);
        }
    });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: quotation-templates.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation