Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/pawn

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: manage-quotations.php

<?php
// manage-quotations.php

require_once('includes/db.php');

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        header('Content-Type: application/json');
        echo json_encode(['success' => false, 'message' => 'Unauthorized']);
        exit();
    } else {
        header("Location: user-login.php");
        exit();
    }
}

// Get user role
$user_role = $_SESSION['role'] ?? 'admin';

// Handle actions - MUST be at the TOP before any HTML output
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    // Set JSON header first
    header('Content-Type: application/json');
    
    try {
        $action = $_POST['action'];
        
        if ($action === 'update_status' && isset($_POST['id'], $_POST['status'])) {
            $id = (int)$_POST['id'];
            $status = mysqli_real_escape_string($conn, $_POST['status']);
            
            $sql = "UPDATE quotations SET status = ?, updated_at = NOW() WHERE id = ?";
            $stmt = mysqli_prepare($conn, $sql);
            mysqli_stmt_bind_param($stmt, "si", $status, $id);
            
            if (mysqli_stmt_execute($stmt)) {
                echo json_encode(['success' => true, 'message' => 'Status updated successfully']);
            } else {
                echo json_encode(['success' => false, 'message' => 'Failed to update status']);
            }
            mysqli_stmt_close($stmt);
            exit();
        }
        
        if ($action === 'delete_quotation' && isset($_POST['id'])) {
            $id = (int)$_POST['id'];
            
            if ($user_role !== 'admin') {
                echo json_encode(['success' => false, 'message' => 'Permission denied']);
                exit();
            }
            
            mysqli_begin_transaction($conn);
            
            try {
                $delete_items_sql = "DELETE FROM quotation_items WHERE quotation_id = ?";
                $stmt1 = mysqli_prepare($conn, $delete_items_sql);
                mysqli_stmt_bind_param($stmt1, "i", $id);
                mysqli_stmt_execute($stmt1);
                mysqli_stmt_close($stmt1);
                
                $delete_quotation_sql = "DELETE FROM quotations WHERE id = ?";
                $stmt2 = mysqli_prepare($conn, $delete_quotation_sql);
                mysqli_stmt_bind_param($stmt2, "i", $id);
                
                if (mysqli_stmt_execute($stmt2)) {
                    mysqli_commit($conn);
                    echo json_encode(['success' => true, 'message' => 'Quotation deleted successfully']);
                } else {
                    throw new Exception('Failed to delete quotation');
                }
                mysqli_stmt_close($stmt2);
            } catch (Exception $e) {
                mysqli_rollback($conn);
                echo json_encode(['success' => false, 'message' => 'Failed to delete quotation']);
            }
            exit();
        }
        
        // Convert to Sale action
        if ($action === 'convert_to_sale' && isset($_POST['id'])) {
            $id = (int)$_POST['id'];
            
            // Fetch quotation details with customer info
            $quotation_query = "SELECT q.*, 
                                       c.name as customer_full_name, 
                                       c.phone as customer_contact,
                                       tm.invoice_file, 
                                       tm.invoice_name,
                                       gd.business_name, 
                                       gd.gst_num
                                FROM quotations q
                                LEFT JOIN customers c ON q.customer_id = c.id
                                LEFT JOIN template_mapping tm ON q.business_id = tm.gst_id AND tm.is_active = 1
                                LEFT JOIN gst_details gd ON q.business_id = gd.id
                                WHERE q.id = ?";
            
            $stmt = mysqli_prepare($conn, $quotation_query);
            mysqli_stmt_bind_param($stmt, "i", $id);
            
            if (!mysqli_stmt_execute($stmt)) {
                echo json_encode(['success' => false, 'message' => 'Database error: ' . mysqli_error($conn)]);
                mysqli_stmt_close($stmt);
                exit();
            }
            
            $result = mysqli_stmt_get_result($stmt);
            
            if ($quotation = mysqli_fetch_assoc($result)) {
                // Update quotation status to "accepted" if not already
                if ($quotation['status'] !== 'accepted' && $quotation['status'] !== 'converted_to_sale') {
                    $update_sql = "UPDATE quotations SET status = 'accepted', updated_at = NOW() WHERE id = ?";
                    $update_stmt = mysqli_prepare($conn, $update_sql);
                    mysqli_stmt_bind_param($update_stmt, "i", $id);
                    mysqli_stmt_execute($update_stmt);
                    mysqli_stmt_close($update_stmt);
                }
                
                // Use customer info from customers table if available
                $customer_name = !empty($quotation['customer_full_name']) ? $quotation['customer_full_name'] : $quotation['customer_name'];
                $customer_phone = !empty($quotation['customer_contact']) ? $quotation['customer_contact'] : $quotation['customer_phone'];
                
                // Store quotation data in session for auto-filling in common_sale.php
                $_SESSION['converting_from_quotation'] = true;
                $_SESSION['quotation_data'] = [
                    'customer_id' => $quotation['customer_id'],
                    'customer_name' => $customer_name,
                    'customer_phone' => $customer_phone,
                    'business_id' => $quotation['business_id'],
                    'business_name' => $quotation['business_name'],
                    'gst_number' => $quotation['gst_number'],
                    'template_file' => $quotation['invoice_file'] ?? '',
                    'template_name' => $quotation['invoice_name'] ?? '',
                    'service_type' => $quotation['quotation_type'] === 'service' ? 'service' : 'product',
                    'grand_total' => $quotation['grand_total'],
                    'subtotal' => $quotation['subtotal'],
                    'total_gst' => $quotation['total_gst'],
                    'total_cgst' => $quotation['total_cgst'],
                    'total_sgst' => $quotation['total_sgst'],
                    'quotation_number' => $quotation['quotation_number'],
                    'quotation_id' => $quotation['id'],
                    'notes' => $quotation['notes'] ?? ''
                ];
                
                // Fetch quotation items
                $items_query = "SELECT * FROM quotation_items WHERE quotation_id = ?";
                $items_stmt = mysqli_prepare($conn, $items_query);
                mysqli_stmt_bind_param($items_stmt, "i", $id);
                mysqli_stmt_execute($items_stmt);
                $items_result = mysqli_stmt_get_result($items_stmt);
                
                // Store items in session
                $_SESSION['quotation_items'] = [];
                $_SESSION['quotation_items_json'] = [];
                while ($item = mysqli_fetch_assoc($items_result)) {
                    $item_data = [
                        'item_type' => $item['item_type'],
                        'item_id' => $item['item_id'],
                        'item_name' => $item['item_name'],
                        'quantity' => $item['quantity'],
                        'unit_price' => $item['unit_price'],
                        'discount' => $item['discount'],
                        'discount_type' => $item['discount_type'],
                        'total_price' => $item['total_price'],
                        'gst_percentage' => $item['gst_percentage'],
                        'gst_amount' => $item['gst_amount'],
                        'cgst_amount' => $item['cgst_amount'],
                        'sgst_amount' => $item['sgst_amount'],
                        'grand_total' => $item['grand_total'],
                        'hsn_code' => $item['hsn_code'],
                        'description' => $item['description']
                    ];
                    
                    $_SESSION['quotation_items'][] = $item_data;
                    $_SESSION['quotation_items_json'][] = $item_data;
                }
                
                mysqli_stmt_close($items_stmt);
                mysqli_stmt_close($stmt);
                
                echo json_encode([
                    'success' => true,
                    'message' => 'Quotation ready for conversion to sale!',
                    'redirect_url' => 'common_sale.php?quotation_id=' . $id,
                    'quotation_number' => $quotation['quotation_number']
                ]);
            } else {
                mysqli_stmt_close($stmt);
                echo json_encode(['success' => false, 'message' => 'Quotation not found']);
            }
            exit();
        }
        
        // Unknown action
        echo json_encode(['success' => false, 'message' => 'Unknown action']);
        exit();
        
    } catch (Exception $e) {
        echo json_encode(['success' => false, 'message' => 'Server error: ' . $e->getMessage()]);
        exit();
    }
}

// Rest of the HTML page continues below...
// ================================================
// ONLY REACH THIS POINT IF NOT A POST REQUEST
// ================================================

// Get filter parameters
$search = $_GET['search'] ?? '';
$status_filter = $_GET['status'] ?? '';
$date_from = $_GET['date_from'] ?? '';
$date_to = $_GET['date_to'] ?? '';
$customer_id = $_GET['customer_id'] ?? '';

// Build query with template mapping information
$query = "SELECT q.*, c.name as customer_name, c.phone as customer_phone,
          tm.template_file, tm.template_name, tm.invoice_file, tm.invoice_name,
          gd.business_name, gd.business_prefix
          FROM quotations q 
          LEFT JOIN customers c ON q.customer_id = c.id 
          LEFT JOIN template_mapping tm ON q.business_id = tm.gst_id AND tm.is_active = 1
          LEFT JOIN gst_details gd ON q.business_id = gd.id
          WHERE 1=1";

$params = [];

if (!empty($search)) {
    $query .= " AND (q.quotation_number LIKE ? OR q.customer_name LIKE ? OR c.name LIKE ? OR c.phone LIKE ?)";
    $search_param = "%$search%";
    $params = array_merge($params, [$search_param, $search_param, $search_param, $search_param]);
}

if (!empty($status_filter) && $status_filter !== 'all') {
    $query .= " AND q.status = ?";
    $params[] = $status_filter;
}

if (!empty($date_from)) {
    $query .= " AND DATE(q.created_at) >= ?";
    $params[] = $date_from;
}

if (!empty($date_to)) {
    $query .= " AND DATE(q.created_at) <= ?";
    $params[] = $date_to;
}

if (!empty($customer_id)) {
    $query .= " AND q.customer_id = ?";
    $params[] = (int)$customer_id;
}

$query .= " ORDER BY q.created_at DESC";

// Pagination
$limit = 20;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $limit;

// Get total count
$count_query = "SELECT COUNT(*) as total FROM quotations q LEFT JOIN customers c ON q.customer_id = c.id WHERE 1=1";
if (!empty($search)) {
    $count_query .= " AND (q.quotation_number LIKE ? OR q.customer_name LIKE ? OR c.name LIKE ? OR c.phone LIKE ?)";
}
if (!empty($status_filter) && $status_filter !== 'all') {
    $count_query .= " AND q.status = ?";
}
if (!empty($date_from)) {
    $count_query .= " AND DATE(q.created_at) >= ?";
}
if (!empty($date_to)) {
    $count_query .= " AND DATE(q.created_at) <= ?";
}
if (!empty($customer_id)) {
    $count_query .= " AND q.customer_id = ?";
}

$count_stmt = mysqli_prepare($conn, $count_query);
if (!empty($params)) {
    $types = '';
    foreach ($params as $param) {
        $types .= is_int($param) ? 'i' : 's';
    }
    mysqli_stmt_bind_param($count_stmt, $types, ...$params);
}
mysqli_stmt_execute($count_stmt);
$count_result = mysqli_stmt_get_result($count_stmt);
$total_row = mysqli_fetch_assoc($count_result);
$total_quotations = $total_row['total'];
$total_pages = ceil($total_quotations / $limit);
mysqli_stmt_close($count_stmt);

// Apply pagination to main query
$query .= " LIMIT ? OFFSET ?";
$params[] = $limit;
$params[] = $offset;

// Prepare and execute main query
$stmt = mysqli_prepare($conn, $query);
if (!empty($params)) {
    $types = '';
    foreach ($params as $param) {
        $types .= is_int($param) ? 'i' : 's';
    }
    mysqli_stmt_bind_param($stmt, $types, ...$params);
}
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

// Get customers for filter dropdown
$customers_query = "SELECT id, name, phone FROM customers ORDER BY name LIMIT 50";
$customers_result = mysqli_query($conn, $customers_query);
$customers = [];
while ($row = mysqli_fetch_assoc($customers_result)) {
    $customers[] = $row;
}
mysqli_free_result($customers_result);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    <style>
        .filter-card {
            background: #f8f9fa;
            border-radius: 8px;
            padding: 15px;
            margin-bottom: 20px;
        }
        .pagination-wrapper {
            display: flex;
            justify-content: center;
            margin-top: 20px;
        }
        .empty-state {
            text-align: center;
            padding: 50px 20px;
            color: #6c757d;
        }
        .empty-state i {
            font-size: 4rem;
            margin-bottom: 20px;
            opacity: 0.3;
        }
        .status-badge {
            font-size: 0.75em;
            padding: 4px 8px;
            border-radius: 20px;
        }
        .status-draft { background: #6c757d; color: white; }
        .status-sent { background: #17a2b8; color: white; }
        .status-accepted { background: #28a745; color: white; }
        .status-converted_to_sale { background: #20c997; color: white; }
        .status-rejected { background: #dc3545; color: white; }
        .status-expired { background: #ffc107; color: #212529; }
        .status-cancelled { background: #6c757d; color: white; }
        .table-actions .btn {
            padding: 3px 8px;
            font-size: 0.85rem;
        }
        .quotation-table th {
            background-color: #f8f9fa;
            font-weight: 600;
        }
        .quotation-table tbody tr:hover {
            background-color: #f8f9fa;
        }
        .action-dropdown {
            min-width: 200px;
        }
        .template-badge {
            background-color: #e7f1ff;
            color: #0d6efd;
            font-size: 0.7em;
            padding: 2px 6px;
            border-radius: 3px;
        }
        .business-prefix {
            background-color: #e3f2fd;
            color: #1565c0;
            font-size: 0.7em;
            padding: 1px 5px;
            border-radius: 3px;
            font-family: monospace;
            margin-right: 5px;
        }
        .business-name-badge {
            background-color: #e8f5e9;
            color: #2e7d32;
            font-size: 0.7em;
            padding: 2px 8px;
            border-radius: 10px;
            font-weight: 500;
            margin-top: 2px;
            display: inline-block;
        }
        .convert-sale-btn {
            background-color: #20c997;
            border-color: #20c997;
            color: white;
        }
        .convert-sale-btn:hover {
            background-color: #1ab188;
            border-color: #1ab188;
        }
        .invoice-badge {
            background-color: #fff3cd;
            color: #856404;
            font-size: 0.7em;
            padding: 2px 6px;
            border-radius: 3px;
            border: 1px solid #ffeaa7;
        }
        .info-bubble {
            display: inline-block;
            width: 18px;
            height: 18px;
            background-color: #6c757d;
            color: white;
            border-radius: 50%;
            text-align: center;
            font-size: 11px;
            line-height: 18px;
            cursor: help;
            margin-left: 3px;
        }
        .total-info {
            font-size: 0.8em;
            color: #6c757d;
            display: block;
            line-height: 1.2;
        }
        @media (max-width: 768px) {
            .table-responsive {
                font-size: 0.9rem;
            }
            .table-actions .btn {
                margin-bottom: 5px;
            }
            .action-dropdown {
                min-width: 160px;
                font-size: 0.9em;
            }
        }
    </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="card filter-card">
                        <div class="card-body">
                            <h5 class="card-title mb-3">Filter Quotations</h5>
                            <form method="GET" id="filterForm">
                                <div class="row">
                                    <div class="col-md-3 mb-3">
                                        <label class="form-label">Search</label>
                                        <input type="text" class="form-control" name="search" placeholder="Search by number, customer..." value="<?php echo htmlspecialchars($search); ?>">
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <label class="form-label">Status</label>
                                        <select class="form-control" name="status">
                                            <option value="all" <?php echo $status_filter === 'all' || empty($status_filter) ? 'selected' : ''; ?>>All Status</option>
                                            <option value="draft" <?php echo $status_filter === 'draft' ? 'selected' : ''; ?>>Draft</option>
                                            <option value="sent" <?php echo $status_filter === 'sent' ? 'selected' : ''; ?>>Sent</option>
                                            <option value="accepted" <?php echo $status_filter === 'accepted' ? 'selected' : ''; ?>>Accepted</option>
                                            <option value="converted_to_sale" <?php echo $status_filter === 'converted_to_sale' ? 'selected' : ''; ?>>Converted to Sale</option>
                                            <option value="rejected" <?php echo $status_filter === 'rejected' ? 'selected' : ''; ?>>Rejected</option>
                                            <option value="expired" <?php echo $status_filter === 'expired' ? 'selected' : ''; ?>>Expired</option>
                                            <option value="cancelled" <?php echo $status_filter === 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <label class="form-label">Customer</label>
                                        <select class="form-control" name="customer_id">
                                            <option value="">All Customers</option>
                                            <?php foreach ($customers as $customer): ?>
                                                <option value="<?php echo $customer['id']; ?>" <?php echo $customer_id == $customer['id'] ? 'selected' : ''; ?>>
                                                    <?php echo htmlspecialchars($customer['name']); ?>
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <label class="form-label">From Date</label>
                                        <input type="date" class="form-control" name="date_from" value="<?php echo htmlspecialchars($date_from); ?>">
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <label class="form-label">To Date</label>
                                        <input type="date" class="form-control" name="date_to" value="<?php echo htmlspecialchars($date_to); ?>">
                                    </div>
                                    <div class="col-md-1 mb-3 d-flex align-items-end">
                                        <button type="submit" class="btn btn-primary w-100">
                                            <i class="fas fa-filter"></i> Filter
                                        </button>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>

<div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <h5 class="card-title mb-3">Quotations List</h5>
                                    
                                    <?php if (mysqli_num_rows($result) > 0): ?>
                                        <div class="table-responsive">
                                            <table class="table table-hover quotation-table">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>Quotation Number</th>
                                                        <th>Customer</th>
                                                        <th>Business & Template</th>
                                                        <th>Date</th>
                                                        <th>Status</th>
                                                        <th>Amount</th>
                                                        <th>Actions</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php 
                                                    $counter = ($page - 1) * $limit + 1;
                                                    while ($row = mysqli_fetch_assoc($result)): 
                                                        // Get template info
                                                        $template_file = $row['template_file'] ?? '';
                                                        $template_name = $row['template_name'] ?? '';
                                                        $invoice_file = $row['invoice_file'] ?? '';
                                                        $invoice_name = $row['invoice_name'] ?? '';
                                                    ?>
                                                        <tr>
                                                            <td><?php echo $counter++; ?></td>
                                                            <td>
                                                                <?php if (!empty($row['business_prefix'])): ?>
                                                                    <span class="business-prefix" title="Business Prefix">
                                                                        <?php echo htmlspecialchars($row['business_prefix']); ?>
                                                                    </span>
                                                                <?php endif; ?>
                                                                <strong><?php echo htmlspecialchars($row['quotation_number']); ?></strong>
                                                                <?php if (!empty($row['notes'])): ?>
                                                                    <br>
                                                                    <small class="text-muted" title="<?php echo htmlspecialchars($row['notes']); ?>">
                                                                        <i class="fas fa-sticky-note me-1"></i>
                                                                        <?php echo htmlspecialchars(substr($row['notes'], 0, 30)); ?>
                                                                        <?php echo strlen($row['notes']) > 30 ? '...' : ''; ?>
                                                                    </small>
                                                                <?php endif; ?>
                                                            </td>
                                                            <td>
                                                                <?php if (!empty($row['customer_name'])): ?>
                                                                    <strong><?php echo htmlspecialchars($row['customer_name']); ?></strong>
                                                                    <?php if (!empty($row['customer_phone'])): ?>
                                                                        <br>
                                                                        <small class="text-muted"><?php echo htmlspecialchars($row['customer_phone']); ?></small>
                                                                    <?php endif; ?>
                                                                <?php else: ?>
                                                                    <span class="text-muted">No customer</span>
                                                                <?php endif; ?>
                                                            </td>
                                                            <td>
                                                                <?php if (!empty($row['business_name'])): ?>
                                                                    <div>
                                                                        <strong><?php echo htmlspecialchars($row['business_name']); ?></strong>
                                                                        <?php if (!empty($row['business_prefix'])): ?>
                                                                            <span class="business-name-badge" title="Business Prefix">
                                                                                <?php echo htmlspecialchars($row['business_prefix']); ?>
                                                                            </span>
                                                                        <?php endif; ?>
                                                                    </div>
                                                                    <?php if (!empty($template_name)): ?>
                                                                        <div>
                                                                            <span class="template-badge" title="Quotation Template: <?php echo htmlspecialchars($template_file); ?>">
                                                                                <i class="fas fa-file-contract me-1"></i>
                                                                                <?php echo htmlspecialchars($template_name); ?>
                                                                            </span>
                                                                            <?php if (!empty($invoice_name)): ?>
                                                                                <span class="invoice-badge" title="Invoice Template: <?php echo htmlspecialchars($invoice_file); ?>">
                                                                                    <i class="fas fa-file-invoice me-1"></i>
                                                                                    <?php echo htmlspecialchars($invoice_name); ?>
                                                                                </span>
                                                                            <?php endif; ?>
                                                                        </div>
                                                                    <?php else: ?>
                                                                        <div>
                                                                            <span class="badge bg-warning text-dark">
                                                                                <i class="fas fa-exclamation-triangle me-1"></i>
                                                                                No template mapped
                                                                            </span>
                                                                        </div>
                                                                    <?php endif; ?>
                                                                <?php else: ?>
                                                                    <span class="text-muted">No business</span>
                                                                <?php endif; ?>
                                                            </td>
                                                            <td>
                                                                <?php echo date('d M Y', strtotime($row['created_at'])); ?>
                                                                <br>
                                                                <small class="text-muted"><?php echo date('h:i A', strtotime($row['created_at'])); ?></small>
                                                            </td>
                                                            <td>
                                                                <span class="badge status-badge status-<?php echo $row['status']; ?>">
                                                                    <?php echo ucfirst(str_replace('_', ' ', $row['status'])); ?>
                                                                </span>
                                                            </td>
                                                            <td>
                                                                <strong class="text-success">₹<?php echo number_format($row['grand_total'] ?? 0, 2); ?></strong>
                                                                <span class="total-info">
                                                                    Sub: ₹<?php echo number_format($row['subtotal'] ?? 0, 2); ?>
                                                                    <br>
                                                                    GST: ₹<?php echo number_format($row['total_gst'] ?? 0, 2); ?>
                                                                </span>
                                                            </td>
                                                            <td>
                                                                <div class="table-actions">
                                                                    <div class="btn-group" role="group">
                                                                        <a href="view-quotation.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-outline-primary" title="View">
                                                                            <i class="fas fa-eye"></i>
                                                                        </a>
                                                                        <a href="edit-quotation.php?id=<?php echo $row['id']; ?>" class="btn btn-sm btn-outline-warning" title="Edit">
                                                                            <i class="fas fa-edit"></i>
                                                                        </a>
                                                                        <?php if (!empty($template_file)): ?>
                                                                            <button class="btn btn-sm btn-outline-info" onclick="printWithTemplate(<?php echo $row['id']; ?>, '<?php echo htmlspecialchars($template_file); ?>')" title="Print Quotation">
                                                                                <i class="fas fa-print"></i>
                                                                            </button>
                                                                        <?php else: ?>
                                                                            <button class="btn btn-sm btn-outline-info" onclick="printWithTemplate(<?php echo $row['id']; ?>, 'default')" title="Print Quotation (Default)">
                                                                                <i class="fas fa-print"></i>
                                                                            </button>
                                                                        <?php endif; ?>
                                                                        <button class="btn btn-sm btn-outline-secondary dropdown-toggle" type="button" data-bs-toggle="dropdown" aria-expanded="false" title="More Actions">
                                                                            <i class="fas fa-ellipsis-v"></i>
                                                                        </button>
                                                                        <ul class="dropdown-menu action-dropdown">
                                                                            <li><a class="dropdown-item" href="#" onclick="updateStatus(<?php echo $row['id']; ?>, 'sent')">
                                                                                <i class="fas fa-paper-plane text-primary me-2"></i> Mark as Sent
                                                                            </a></li>
                                                                            <li><a class="dropdown-item" href="#" onclick="updateStatus(<?php echo $row['id']; ?>, 'accepted')">
                                                                                <i class="fas fa-check-circle text-success me-2"></i> Mark as Accepted
                                                                            </a></li>
                                                                            <li><a class="dropdown-item convert-sale-action" href="#" onclick="convertToSale(<?php echo $row['id']; ?>, '<?php echo htmlspecialchars($row['quotation_number']); ?>')">
                                                                                <i class="fas fa-shopping-cart text-info me-2"></i> Convert to Sale
                                                                            </a></li>
                                                                            <li><hr class="dropdown-divider"></li>
                                                                            <li><a class="dropdown-item" href="#" onclick="updateStatus(<?php echo $row['id']; ?>, 'rejected')">
                                                                                <i class="fas fa-times-circle text-danger me-2"></i> Mark as Rejected
                                                                            </a></li>
                                                                            <li><a class="dropdown-item" href="#" onclick="updateStatus(<?php echo $row['id']; ?>, 'expired')">
                                                                                <i class="fas fa-clock text-warning me-2"></i> Mark as Expired
                                                                            </a></li>
                                                                            <li><a class="dropdown-item" href="#" onclick="updateStatus(<?php echo $row['id']; ?>, 'cancelled')">
                                                                                <i class="fas fa-ban text-dark me-2"></i> Mark as Cancelled
                                                                            </a></li>
                                                                            <li><hr class="dropdown-divider"></li>
                                                                            <?php if ($user_role === 'admin'): ?>
                                                                                <li><a class="dropdown-item text-danger" href="#" onclick="deleteQuotation(<?php echo $row['id']; ?>, '<?php echo htmlspecialchars($row['quotation_number']); ?>')">
                                                                                    <i class="fas fa-trash me-2"></i> Delete Quotation
                                                                                </a></li>
                                                                            <?php endif; ?>
                                                                        </ul>
                                                                    </div>
                                                                </div>
                                                            </td>
                                                        </tr>
                                                    <?php endwhile; ?>
                                                </tbody>
                                            </table>
                                        </div>
                                    <?php else: ?>
                                        <div class="empty-state">
                                            <i class="fas fa-file-invoice-dollar"></i>
                                            <h4>No Quotations Found</h4>
                                            <p class="text-muted">No quotations match your current filters.</p>
                                            <a href="manage-quotations.php" class="btn btn-primary mt-3">
                                                <i class="fas fa-sync-alt me-2"></i>Clear Filters
                                            </a>
                                        </div>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </div>
                    </div>

<?php if ($total_pages > 1): ?>
                        <div class="row">
                            <div class="col-12">
                                <div class="pagination-wrapper">
                                    <nav aria-label="Page navigation">
                                        <ul class="pagination">
                                            <?php if ($page > 1): ?>
                                                <li class="page-item">
                                                    <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page - 1])); ?>">
                                                        <i class="fas fa-chevron-left"></i>
                                                    </a>
                                                </li>
                                            <?php endif; ?>

<?php
                                            $start_page = max(1, $page - 2);
                                            $end_page = min($total_pages, $page + 2);
                                            
                                            for ($i = $start_page; $i <= $end_page; $i++):
                                            ?>
                                                <li class="page-item <?php echo $i == $page ? 'active' : ''; ?>">
                                                    <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $i])); ?>">
                                                        <?php echo $i; ?>
                                                    </a>
                                                </li>
                                            <?php endfor; ?>

<?php if ($page < $total_pages): ?>
                                                <li class="page-item">
                                                    <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page + 1])); ?>">
                                                        <i class="fas fa-chevron-right"></i>
                                                    </a>
                                                </li>
                                            <?php endif; ?>
                                        </ul>
                                    </nav>
                                </div>
                            </div>
                        </div>
                    <?php endif; ?>

</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/sweetalert2@11"></script>

// Update quotation status
    function updateStatus(quotationId, newStatus) {
        Swal.fire({
            title: 'Update Status?',
            text: 'Are you sure you want to update the quotation status?',
            icon: 'question',
            showCancelButton: true,
            confirmButtonText: 'Yes, Update',
            cancelButtonText: 'Cancel'
        }).then((result) => {
            if (result.isConfirmed) {
                $.ajax({
                    url: 'manage-quotations.php',
                    method: 'POST',
                    data: {
                        action: 'update_status',
                        id: quotationId,
                        status: newStatus
                    },
                    dataType: 'json',
                    success: function(response) {
                        if (response.success) {
                            Swal.fire({
                                icon: 'success',
                                title: 'Status Updated',
                                text: response.message,
                                timer: 1500,
                                showConfirmButton: false
                            }).then(() => {
                                location.reload();
                            });
                        } else {
                            Swal.fire({
                                icon: 'error',
                                title: 'Error',
                                text: response.message
                            });
                        }
                    },
                    error: function(xhr, status, error) {
                        console.error('Update status error:', error, xhr.responseText);
                        Swal.fire({
                            icon: 'error',
                            title: 'Error',
                            text: 'Failed to update status. Please try again.'
                        });
                    }
                });
            }
        });
    }

// Convert quotation to sale
    function convertToSale(quotationId, quotationNumber) {
        Swal.fire({
            title: 'Convert to Sale?',
            html: `Are you sure you want to convert quotation <strong>${quotationNumber}</strong> to a sale?<br><br>
                  <small class="text-info">
                    <i class="fas fa-info-circle"></i> This will:
                    <ul class="text-start mt-2" style="font-size: 0.9em;">
                        <li>Update quotation status to "accepted"</li>
                        <li>Redirect you to sales page</li>
                        <li>Auto-fill all customer and item details</li>
                        <li>Preserve all pricing and GST information</li>
                    </ul>
                  </small>`,
            icon: 'question',
            showCancelButton: true,
            confirmButtonText: 'Yes, Convert to Sale',
            cancelButtonText: 'Cancel',
            confirmButtonColor: '#20c997'
        }).then((result) => {
            if (result.isConfirmed) {
                // Show loading
                Swal.fire({
                    title: 'Processing...',
                    text: 'Preparing quotation for sale conversion',
                    allowOutsideClick: false,
                    didOpen: () => {
                        Swal.showLoading();
                    }
                });
                
                $.ajax({
                    url: 'manage-quotations.php',
                    method: 'POST',
                    data: {
                        action: 'convert_to_sale',
                        id: quotationId
                    },
                    dataType: 'json',
                    timeout: 30000,
                    beforeSend: function() {
                        console.log('Sending convert to sale request for ID:', quotationId);
                    },
                    success: function(response) {
                        console.log('Convert to sale response:', response);
                        
                        if (response && response.success && response.redirect_url) {
                            Swal.fire({
                                icon: 'success',
                                title: 'Ready for Sale!',
                                html: `Quotation <strong>${quotationNumber}</strong> has been prepared for sale conversion.<br>
                                       <small class="text-muted">Redirecting to sales page...</small>`,
                                timer: 1500,
                                showConfirmButton: false,
                                willClose: () => {
                                    window.location.href = response.redirect_url;
                                }
                            });
                        } else {
                            let errorMessage = response && response.message ? response.message : 'Failed to convert quotation to sale';
                            Swal.fire({
                                icon: 'error',
                                title: 'Error',
                                html: errorMessage
                            });
                        }
                    },
                    error: function(xhr, status, error) {
                        console.error('Convert to sale AJAX error:', {
                            status: status,
                            error: error,
                            responseText: xhr.responseText,
                            readyState: xhr.readyState
                        });
                        
                        let errorMessage = 'Failed to process request. Please try again.';
                        let debugInfo = '';
                        
                        // Check if response is HTML (starts with <)
                        if (xhr.responseText && xhr.responseText.trim().startsWith('<')) {
                            errorMessage = 'Server returned HTML instead of JSON. There might be a PHP error.';
                            debugInfo = 'Response starts with: ' + xhr.responseText.substring(0, 100) + '...';
                        }
                        
                        Swal.fire({
                            icon: 'error',
                            title: 'Request Failed',
                            html: errorMessage + '<br><small class="text-muted">' + debugInfo + '</small>',
                            footer: 'Status: ' + status + ', Error: ' + error
                        });
                    }
                });
            }
        });
    }

// Delete quotation
    function deleteQuotation(quotationId, quotationNumber) {
        Swal.fire({
            title: 'Delete Quotation?',
            html: `Are you sure you want to delete quotation <strong>${quotationNumber}</strong>?<br><small class="text-danger">This action cannot be undone.</small>`,
            icon: 'warning',
            showCancelButton: true,
            confirmButtonText: 'Yes, Delete',
            cancelButtonText: 'Cancel',
            confirmButtonColor: '#dc3545'
        }).then((result) => {
            if (result.isConfirmed) {
                $.ajax({
                    url: 'manage-quotations.php',
                    method: 'POST',
                    data: {
                        action: 'delete_quotation',
                        id: quotationId
                    },
                    dataType: 'json',
                    success: function(response) {
                        if (response.success) {
                            Swal.fire({
                                icon: 'success',
                                title: 'Deleted',
                                text: response.message,
                                timer: 1500,
                                showConfirmButton: false
                            }).then(() => {
                                location.reload();
                            });
                        } else {
                            Swal.fire({
                                icon: 'error',
                                title: 'Error',
                                text: response.message
                            });
                        }
                    },
                    error: function() {
                        Swal.fire({
                            icon: 'error',
                            title: 'Error',
                            text: 'Failed to delete quotation. Please try again.'
                        });
                    }
                });
            }
        });
    }

// Quick search
    $(document).ready(function() {
        // Auto-submit filter form on enter in search field
        $('input[name="search"]').on('keypress', function(e) {
            if (e.which === 13) {
                $('#filterForm').submit();
            }
        });

// Date validation
        $('input[name="date_from"], input[name="date_to"]').change(function() {
            const dateFrom = $('input[name="date_from"]').val();
            const dateTo = $('input[name="date_to"]').val();
            
            if (dateFrom && dateTo && dateFrom > dateTo) {
                Swal.fire({
                    icon: 'warning',
                    title: 'Invalid Date Range',
                    text: 'From date cannot be after To date'
                });
                $(this).val('');
            }
        });
    });
    </script>
</body>
</html>

<?php
// Close database connection and free result
if (isset($stmt)) {
    mysqli_stmt_close($stmt);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-quotations.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation