Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: edit-quotation.php

<?php
// edit-quotation.php - COMPLETE CORRECTED VERSION

require_once('includes/db.php');

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

// Check if quotation ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header("Location: manage-quotations.php");
    exit();
}

$quotation_id = (int)$_GET['id'];

// Handle AJAX request for template loading
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'get_template') {
    $business_id = isset($_POST['business_id']) ? (int) $_POST['business_id'] : 0;
    
    if ($business_id <= 0) {
        echo json_encode(['success' => false, 'message' => 'Invalid business id']);
        exit();
    }

// Fetch template
    $template_sql = "SELECT tm.*, g.business_name, g.gst_num 
                     FROM template_mapping tm
                     LEFT JOIN gst_details g ON tm.gst_id = g.id
                     WHERE tm.gst_id = ? AND tm.is_active = 1
                     LIMIT 1";
    
    $template_stmt = mysqli_prepare($conn, $template_sql);
    if (!$template_stmt) {
        echo json_encode(['success' => false, 'message' => 'DB prepare error']);
        exit();
    }
    
    mysqli_stmt_bind_param($template_stmt, "i", $business_id);
    mysqli_stmt_execute($template_stmt);
    $result = mysqli_stmt_get_result($template_stmt);
    $template = mysqli_fetch_assoc($result);
    mysqli_stmt_close($template_stmt);
    
    if ($template) {
        echo json_encode([
            'success' => true,
            'template_file' => $template['template_file'] ?? '',
            'template_name' => $template['template_name'] ?? '',
            'business_name' => $template['business_name'] ?? ''
        ]);
    } else {
        echo json_encode(['success' => false, 'message' => 'No template mapped to this business']);
    }
    exit();
}

// Fetch quotation details
$quotation_sql = "SELECT q.*, 
                  g.business_name, g.gst_num, g.business_address,
                  c.name as customer_name, c.phone as customer_phone
                  FROM quotations q
                  LEFT JOIN gst_details g ON q.business_id = g.id
                  LEFT JOIN customers c ON q.customer_id = c.id
                  WHERE q.id = ?";
$quotation_stmt = mysqli_prepare($conn, $quotation_sql);
mysqli_stmt_bind_param($quotation_stmt, "i", $quotation_id);
mysqli_stmt_execute($quotation_stmt);
$quotation_result = mysqli_stmt_get_result($quotation_stmt);

if (mysqli_num_rows($quotation_result) === 0) {
    header("Location: manage-quotations.php?error=Quotation not found");
    exit();
}

$quotation = mysqli_fetch_assoc($quotation_result);

// Fetch quotation items
$items_sql = "SELECT * FROM quotation_items WHERE quotation_id = ? ORDER BY id";
$items_stmt = mysqli_prepare($conn, $items_sql);
mysqli_stmt_bind_param($items_stmt, "i", $quotation_id);
mysqli_stmt_execute($items_stmt);
$items_result = mysqli_stmt_get_result($items_stmt);
$items = [];
while ($item = mysqli_fetch_assoc($items_result)) {
    $items[] = $item;
}

// Get businesses for dropdown
$businesses_query = "SELECT * FROM gst_details ORDER BY business_name";
$businesses_result = mysqli_query($conn, $businesses_query);
$businesses = [];
while ($row = mysqli_fetch_assoc($businesses_result)) {
    $businesses[] = $row;
}

// Get customers for dropdown
$customers_query = "SELECT * FROM customers ORDER BY name";
$customers_result = mysqli_query($conn, $customers_query);
$customers = [];
while ($row = mysqli_fetch_assoc($customers_result)) {
    $customers[] = $row;
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && (!isset($_POST['action']) || $_POST['action'] !== 'get_template')) {
    try {
        // Read input fields
        $customer_id = (int)($_POST['customer_id'] ?? 0);
        $customer_name = trim($_POST['customer_name'] ?? '');
        $customer_phone = trim($_POST['customer_phone'] ?? '');
        $business_id = (int)($_POST['business_id'] ?? 0);
        $include_gst = isset($_POST['include_gst']) ? (int)$_POST['include_gst'] : 1;
        $notes = trim($_POST['notes'] ?? '');
        $items_raw = $_POST['items'] ?? '[]';
        $template_file = trim($_POST['template_file'] ?? '');
        $template_name = trim($_POST['template_name'] ?? '');

$items_data = json_decode($items_raw, true);
        if (!is_array($items_data)) {
            $items_data = [];
        }

if (empty($items_data)) {
            $_SESSION['error'] = 'Please add at least one item';
            header("Location: edit-quotation.php?id=" . $quotation_id);
            exit();
        }

if ($business_id <= 0) {
            $_SESSION['error'] = 'Please select a business';
            header("Location: edit-quotation.php?id=" . $quotation_id);
            exit();
        }

// Start transaction
        mysqli_begin_transaction($conn);

// Insert new customer if needed
        if ($customer_id <= 0 && !empty($customer_name)) {
            $insert_customer_sql = "INSERT INTO customers (name, phone, created_at) VALUES (?, ?, NOW())";
            $stmt = mysqli_prepare($conn, $insert_customer_sql);
            mysqli_stmt_bind_param($stmt, "ss", $customer_name, $customer_phone);
            mysqli_stmt_execute($stmt);
            $customer_id = mysqli_insert_id($conn);
            mysqli_stmt_close($stmt);
        }

// Get business details
        $business_sql = "SELECT business_name, gst_num FROM gst_details WHERE id = ? LIMIT 1";
        $business_stmt = mysqli_prepare($conn, $business_sql);
        mysqli_stmt_bind_param($business_stmt, "i", $business_id);
        mysqli_stmt_execute($business_stmt);
        $business_res = mysqli_stmt_get_result($business_stmt);
        $business_row = mysqli_fetch_assoc($business_res);
        mysqli_stmt_close($business_stmt);
        
        $business_name_val = $business_row['business_name'] ?? '';
        $business_gst_val = $business_row['gst_num'] ?? '';

// If customer exists, fetch name and phone
        if ($customer_id > 0) {
            $cust_sql = "SELECT name, phone FROM customers WHERE id = ? LIMIT 1";
            $cust_stmt = mysqli_prepare($conn, $cust_sql);
            mysqli_stmt_bind_param($cust_stmt, "i", $customer_id);
            mysqli_stmt_execute($cust_stmt);
            $cust_res = mysqli_stmt_get_result($cust_stmt);
            $cust_row = mysqli_fetch_assoc($cust_res);
            if ($cust_row) {
                $customer_name = $cust_row['name'] ?? $customer_name;
                $customer_phone = $cust_row['phone'] ?? $customer_phone;
            }
            mysqli_stmt_close($cust_stmt);
        }

// Calculate totals
        $subtotal = 0;
        $total_gst = 0;
        $total_cgst = 0;
        $total_sgst = 0;
        $grand_total = 0;

foreach ($items_data as $item) {
            $price = (float)($item['price'] ?? 0);
            $quantity = (float)($item['quantity'] ?? 1);
            $discount = (float)($item['discount'] ?? 0);
            $discount_type = $item['discount_type'] ?? 'percent';
            $gst_percentage = (float)($item['gst_percentage'] ?? 0);
            $is_gst_applicable = (int)($item['is_gst_applicable'] ?? 0);

// Item total before discount
            $item_total = $price * $quantity;

// Apply discount
            if ($discount > 0) {
                if ($discount_type === 'percent') {
                    $discount_amount = ($item_total * $discount) / 100;
                } else {
                    $discount_amount = $discount;
                }
                $item_total -= $discount_amount;
            }

// Calculate GST if applicable
            if ($include_gst && $is_gst_applicable && $gst_percentage > 0) {
                $item_gst = ($item_total * $gst_percentage) / 100;
                $item_cgst = $item_gst / 2;
                $item_sgst = $item_gst / 2;
                
                $total_gst += $item_gst;
                $total_cgst += $item_cgst;
                $total_sgst += $item_sgst;
            }

$subtotal += $item_total;
        }

$grand_total = $include_gst ? $subtotal + $total_gst : $subtotal;

// Update quotation
        $update_sql = "UPDATE quotations SET
            customer_id = ?,
            customer_name = ?,
            customer_phone = ?,
            business_id = ?,
            business_name = ?,
            gst_number = ?,
            template_file = ?,
            template_name = ?,
            include_gst = ?,
            subtotal = ?,
            total_gst = ?,
            total_cgst = ?,
            total_sgst = ?,
            grand_total = ?,
            notes = ?,
            updated_at = NOW()
            WHERE id = ?";

$update_stmt = mysqli_prepare($conn, $update_sql);
        mysqli_stmt_bind_param(
            $update_stmt,
            "ississssidddddsi",
            $customer_id,
            $customer_name,
            $customer_phone,
            $business_id,
            $business_name_val,
            $business_gst_val,
            $template_file,
            $template_name,
            $include_gst,
            $subtotal,
            $total_gst,
            $total_cgst,
            $total_sgst,
            $grand_total,
            $notes,
            $quotation_id
        );

mysqli_stmt_execute($update_stmt);
        mysqli_stmt_close($update_stmt);

// Delete existing items
        $delete_items_sql = "DELETE FROM quotation_items WHERE quotation_id = ?";
        $delete_stmt = mysqli_prepare($conn, $delete_items_sql);
        mysqli_stmt_bind_param($delete_stmt, "i", $quotation_id);
        mysqli_stmt_execute($delete_stmt);
        mysqli_stmt_close($delete_stmt);

// Insert updated items
        $item_sql = "INSERT INTO quotation_items (
            quotation_id, item_type, item_id, item_name, quantity, unit_price,
            discount, discount_type, total_price, gst_percentage, gst_amount,
            cgst_amount, sgst_amount, grand_total, hsn_code, description
        ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

$item_stmt = mysqli_prepare($conn, $item_sql);

foreach ($items_data as $item) {
            $item_type = $item['type'] ?? 'product';
            $item_id = (int)($item['id'] ?? 0);
            $item_name = trim($item['name'] ?? '');
            $quantity = (float)($item['quantity'] ?? 1);
            $unit_price = (float)($item['price'] ?? 0);
            $discount = (float)($item['discount'] ?? 0);
            $discount_type = $item['discount_type'] ?? 'percent';
            $gst_percentage = (float)($item['gst_percentage'] ?? 0);
            $is_gst_applicable = (int)($item['is_gst_applicable'] ?? 0);
            $hsn_code = trim($item['hsn_code'] ?? '');
            $description = trim($item['description'] ?? '');

// Calculate item totals
            $total_before_discount = $unit_price * $quantity;
            $discount_amount = 0;
            
            if ($discount > 0) {
                if ($discount_type === 'percent') {
                    $discount_amount = ($total_before_discount * $discount) / 100;
                } else {
                    $discount_amount = $discount;
                }
            }
            
            $total_price = $total_before_discount - $discount_amount;
            
            // Calculate GST
            $gst_amount = 0;
            $cgst_amount = 0;
            $sgst_amount = 0;
            if ($include_gst && $is_gst_applicable && $gst_percentage > 0) {
                $gst_amount = ($total_price * $gst_percentage) / 100;
                $cgst_amount = $gst_amount / 2;
                $sgst_amount = $gst_amount / 2;
            }
            
            $item_grand_total = $total_price + $gst_amount;

mysqli_stmt_bind_param(
                $item_stmt,
                "isisdddsddddddss",
                $quotation_id,
                $item_type,
                $item_id,
                $item_name,
                $quantity,
                $unit_price,
                $discount,
                $discount_type,
                $total_price,
                $gst_percentage,
                $gst_amount,
                $cgst_amount,
                $sgst_amount,
                $item_grand_total,
                $hsn_code,
                $description
            );

mysqli_stmt_execute($item_stmt);
        }

mysqli_stmt_close($item_stmt);

// Commit transaction
        mysqli_commit($conn);

$_SESSION['success'] = 'Quotation updated successfully!';
        header("Location: view-quotation.php?id=" . $quotation_id);
        exit();
        
    } catch (Exception $e) {
        mysqli_rollback($conn);
        $_SESSION['error'] = 'Error updating quotation: ' . $e->getMessage();
        header("Location: edit-quotation.php?id=" . $quotation_id);
        exit();
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/sweetalert2@11/dist/sweetalert2.min.css">
    <style>
        .item-list { max-height:300px; overflow-y:auto; border:1px solid #dee2e6; border-radius:4px; padding:10px; }
        .selected-items { border:1px solid #dee2e6; border-radius:4px; padding:15px; min-height:200px; max-height:400px; overflow-y:auto; }
        .item-row { padding:8px 0; border-bottom:1px solid #eee; }
        .item-row:last-child { border-bottom:none; }
        .summary-box { border:1px solid #dee2e6; border-radius:4px; padding:15px; background:#f8f9fa; }
        .summary-row { display:flex; justify-content:space-between; padding:5px 0; }
        .summary-total { border-top:1px solid #dee2e6; margin-top:10px; padding-top:10px; font-weight:bold; font-size:1.1em; }
        .badge-sm { font-size:0.75em; padding:2px 6px; }
        .table-sm td, .table-sm th { padding:8px 10px; }
        .form-switch .form-check-input { width:3em; height:1.5em; }
        .customer-type-tabs .nav-link { border:1px solid #dee2e6; border-bottom:none; border-radius:4px 4px 0 0; }
        .customer-type-tabs .nav-link.active { background-color:#0d6efd; color:white; border-color:#0d6efd; }
        .customer-details-tab { border:1px solid #dee2e6; border-top:none; border-radius:0 0 4px 4px; padding:15px; }
        .template-display { background:#f8f9fa; border:1px solid #dee2e6; border-radius:4px; padding:10px 15px; min-height:50px; display:flex; align-items:center; }
        .template-name { font-weight:bold; color:#0d6efd; }
        .tab-content { margin-top:-1px; }
        .update-quotation-btn { font-size:1.1rem; padding:12px 30px; border-radius:8px; font-weight:600; }
        .floating-update-btn { position:fixed; bottom:30px; right:30px; z-index:1000; box-shadow:0 4px 15px rgba(0,0,0,0.2); }
        .items-tab-content { border:1px solid #dee2e6; border-top:none; border-radius:0 0 4px 4px; padding:15px; }
        .type-badge { font-size:0.7em; padding:2px 6px; }
        .edit-price-btn { font-size:0.8em; padding:1px 5px; }
        .toast-container { z-index: 9999; }
        .toast { max-width: 400px; }
        .error-details { 
            background: rgba(255,255,255,0.1); 
            border: 1px solid rgba(255,255,255,0.2); 
            border-radius: 4px; 
            padding: 8px; 
            margin-top: 5px; 
            font-size: 11px; 
            font-family: monospace; 
            max-height: 150px; 
            overflow-y: auto; 
            word-break: break-all;
        }
        .quotation-header {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            color: white;
            border-radius: 10px;
            padding: 20px;
            margin-bottom: 20px;
        }
        @media (max-width: 768px) {
            .item-list { max-height: 220px; }
            .floating-update-btn { bottom: 20px; right: 20px; }
        }
    </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="quotation-header">
                        <div class="row align-items-center">
                            <div class="col-md-8">
                                <h4 class="mb-1">
                                    <i class="fas fa-edit me-2"></i>Edit Quotation
                                </h4>
                                <p class="mb-0 opacity-75">
                                    Quotation #<?php echo htmlspecialchars($quotation['quotation_number']); ?> 
                                    • Created: <?php echo date('d M Y', strtotime($quotation['created_at'])); ?>
                                </p>
                            </div>
                            <div class="col-md-4 text-end">
                                <span class="badge bg-<?php echo $quotation['status'] === 'approved' ? 'success' : ($quotation['status'] === 'pending' ? 'warning' : 'secondary'); ?> fs-6">
                                    <?php echo ucfirst($quotation['status']); ?>
                                </span>
                            </div>
                        </div>
                    </div>

<?php if (isset($_SESSION['error'])): ?>
                        <div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <i class="fas fa-exclamation-triangle me-2"></i>
                            <?php echo htmlspecialchars($_SESSION['error']); ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['error']); ?>
                    <?php endif; ?>

<?php if (isset($_SESSION['success'])): ?>
                        <div class="alert alert-success alert-dismissible fade show" role="alert">
                            <i class="fas fa-check-circle me-2"></i>
                            <?php echo htmlspecialchars($_SESSION['success']); ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>
                        <?php unset($_SESSION['success']); ?>
                    <?php endif; ?>

<form id="editQuotationForm" method="POST">
                        <div class="row mt-3">
                            
                            <div class="col-lg-8">
                                
                                <div class="card mb-3">
                                    <div class="card-body">
                                        <h5 class="card-title mb-3">Customer Details</h5>
                                        <div class="row">
                                            <div class="col-md-6 mb-3">
                                                <label class="form-label">Select Customer</label>
                                                <select class="form-control" id="customer_id" name="customer_id" required>
                                                    <option value="">Select Customer...</option>
                                                    <?php foreach ($customers as $customer): ?>
                                                        <option value="<?php echo $customer['id']; ?>" 
                                                            <?php echo $customer['id'] == $quotation['customer_id'] ? 'selected' : ''; ?>
                                                            data-name="<?php echo htmlspecialchars($customer['name']); ?>"
                                                            data-phone="<?php echo htmlspecialchars($customer['phone'] ?? ''); ?>">
                                                            <?php echo htmlspecialchars($customer['name']); ?>
                                                            <?php if (!empty($customer['phone'])): ?>
                                                                (<?php echo htmlspecialchars($customer['phone']); ?>)
                                                            <?php endif; ?>
                                                        </option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                            <div class="col-md-6 mb-3">
                                                <label class="form-label">Customer Name</label>
                                                <input type="text" class="form-control" id="customer_name" name="customer_name" 
                                                    value="<?php echo htmlspecialchars($quotation['customer_name']); ?>" required>
                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="col-md-6 mb-3">
                                                <label class="form-label">Phone Number</label>
                                                <input type="text" class="form-control" id="customer_phone" name="customer_phone" 
                                                    value="<?php echo htmlspecialchars($quotation['customer_phone'] ?? ''); ?>">
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="card mb-3">
                                    <div class="card-body">
                                        <h5 class="card-title mb-3">Business & GST</h5>
                                        <div class="row">
                                            <div class="col-md-6 mb-3">
                                                <label class="form-label">Business *</label>
                                                <select class="form-control" id="business_id" name="business_id" required onchange="loadTemplate()">
                                                    <option value="">Select Business...</option>
                                                    <?php foreach ($businesses as $business): ?>
                                                        <option value="<?php echo $business['id']; ?>"
                                                            <?php echo $business['id'] == $quotation['business_id'] ? 'selected' : ''; ?>>
                                                            <?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>

<div class="col-md-6 mb-3">
                                                <label class="form-label">Template</label>
                                                <div id="templatePreview" class="template-display">
                                                    <?php 
                                                    // Get current template for display
                                                    $current_template_sql = "SELECT tm.* FROM template_mapping tm WHERE tm.gst_id = ? AND tm.is_active = 1 LIMIT 1";
                                                    $current_stmt = mysqli_prepare($conn, $current_template_sql);
                                                    mysqli_stmt_bind_param($current_stmt, "i", $quotation['business_id']);
                                                    mysqli_stmt_execute($current_stmt);
                                                    $current_result = mysqli_stmt_get_result($current_stmt);
                                                    $current_template = mysqli_fetch_assoc($current_result);
                                                    mysqli_stmt_close($current_stmt);
                                                    
                                                    if ($current_template): ?>
                                                        <span class="template-name"><?php echo htmlspecialchars($current_template['template_name'] ?? 'Not selected'); ?></span>
                                                    <?php else: ?>
                                                        <span class="text-muted">No template mapped</span>
                                                    <?php endif; ?>
                                                </div>
                                                <input type="hidden" id="template_file" name="template_file" value="<?php echo htmlspecialchars($quotation['template_file'] ?? ''); ?>">
                                                <input type="hidden" id="template_name" name="template_name" value="<?php echo htmlspecialchars($quotation['template_name'] ?? ''); ?>">
                                            </div>
                                        </div>

<div class="row mt-2">
                                            <div class="col-md-6">
                                                <div class="form-check form-switch">
                                                    <input class="form-check-input" type="checkbox" id="include_gst" name="include_gst" value="1"
                                                        <?php echo $quotation['include_gst'] ? 'checked' : ''; ?>>
                                                    <label class="form-check-label" for="include_gst">
                                                        <strong>Include GST in Quotation</strong>
                                                    </label>
                                                </div>
                                                <small class="text-muted">Enable to calculate GST</small>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="card mb-3">
                                    <div class="card-body">
                                        <h5 class="card-title mb-3">Edit Items (Products & Services)</h5>

<ul class="nav nav-tabs mb-3" id="itemTypeTab" role="tablist">
                                            <li class="nav-item" role="presentation">
                                                <button class="nav-link active" id="products-tab" data-bs-toggle="tab" data-bs-target="#products" type="button" role="tab">
                                                    <i class="fas fa-box me-1"></i> Products
                                                </button>
                                            </li>
                                            <li class="nav-item" role="presentation">
                                                <button class="nav-link" id="services-tab" data-bs-toggle="tab" data-bs-target="#services" type="button" role="tab">
                                                    <i class="fas fa-concierge-bell me-1"></i> Services
                                                </button>
                                            </li>
                                            <li class="nav-item" role="presentation">
                                                <button class="nav-link" id="new-item-tab" data-bs-toggle="tab" data-bs-target="#new-item" type="button" role="tab">
                                                    <i class="fas fa-plus-circle me-1"></i> New Item
                                                </button>
                                            </li>
                                        </ul>

<div class="tab-content items-tab-content">
                                            
                                            <div class="tab-pane fade show active" id="products" role="tabpanel">
                                                <div class="mb-3">
                                                    <label class="form-label">Select Products</label>
                                                    <div class="item-list">
                                                        <table class="table table-sm table-hover">
                                                            <thead>
                                                                <tr>
                                                                    <th>#</th>
                                                                    <th>Product Name</th>
                                                                    <th>Price</th>
                                                                    <th>Stock</th>
                                                                    <th>GST</th>
                                                                    <th>Action</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody id="productsTableBody">
                                                                <tr>
                                                                    <td colspan="6" class="text-center text-muted">
                                                                        <i class="fas fa-spinner fa-spin me-2"></i> Loading products...
                                                                    </td>
                                                                </tr>
                                                            </tbody>
                                                        </table>
                                                    </div>
                                                </div>
                                            </div>

<div class="tab-pane fade" id="services" role="tabpanel">
                                                <div class="mb-3">
                                                    <label class="form-label">Select Services</label>
                                                    <div class="item-list">
                                                        <table class="table table-sm table-hover">
                                                            <thead>
                                                                <tr>
                                                                    <th>#</th>
                                                                    <th>Service Name</th>
                                                                    <th>Price</th>
                                                                    <th>Duration</th>
                                                                    <th>GST</th>
                                                                    <th>Action</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody id="servicesTableBody">
                                                                <tr>
                                                                    <td colspan="6" class="text-center text-muted">
                                                                        <i class="fas fa-spinner fa-spin me-2"></i> Loading services...
                                                                    </td>
                                                                </tr>
                                                            </tbody>
                                                        </table>
                                                    </div>
                                                </div>
                                            </div>

<div class="tab-pane fade" id="new-item" role="tabpanel">
                                                <div class="row">
                                                    <div class="col-md-6 mb-3">
                                                        <label class="form-label">Item Type</label>
                                                        <select class="form-control" id="new_item_type">
                                                            <option value="product">Product</option>
                                                            <option value="service">Service</option>
                                                        </select>
                                                    </div>
                                                    <div class="col-md-6 mb-3">
                                                        <label class="form-label">Item Name *</label>
                                                        <input type="text" class="form-control" id="new_item_name" placeholder="Enter item name" required>
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="col-md-4 mb-3">
                                                        <label class="form-label">Price (₹) *</label>
                                                        <input type="number" class="form-control" id="new_item_price" step="0.01" min="0" placeholder="0.00" required>
                                                    </div>
                                                    <div class="col-md-4 mb-3">
                                                        <label class="form-label">Quantity *</label>
                                                        <input type="number" class="form-control" id="new_item_quantity" step="1" min="1" value="1" required>
                                                    </div>
                                                    <div class="col-md-4 mb-3">
                                                        <label class="form-label">GST Percentage</label>
                                                        <input type="number" class="form-control" id="new_item_gst" step="0.01" min="0" max="100" value="18.00">
                                                        <small class="text-muted">Set to 0 for no GST</small>
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="col-md-6 mb-3">
                                                        <label class="form-label">HSN Code (Optional)</label>
                                                        <input type="text" class="form-control" id="new_item_hsn" placeholder="Enter HSN code">
                                                    </div>
                                                    <div class="col-md-6 mb-3">
                                                        <label class="form-label">Description (Optional)</label>
                                                        <input type="text" class="form-control" id="new_item_description" placeholder="Enter description">
                                                    </div>
                                                </div>
                                                <div class="text-center">
                                                    <button type="button" class="btn btn-primary" onclick="addNewItem()">
                                                        <i class="fas fa-plus me-1"></i> Add New Item
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

<div class="col-lg-4">
                                
                                <div class="card mb-3">
                                    <div class="card-body">
                                        <h5 class="card-title mb-3">
                                            Selected Items 
                                            <span id="selectedItemsCount" class="badge bg-primary">0</span>
                                        </h5>
                                        <div id="selectedItems" class="selected-items">
                                            
                                        </div>
                                    </div>
                                </div>

<div class="card mb-3">
                                    <div class="card-body">
                                        <h5 class="card-title mb-3">Quotation Summary</h5>
                                        <div class="summary-box">
                                            <div class="summary-row">
                                                <span>Subtotal:</span>
                                                <span id="subtotal">₹0.00</span>
                                            </div>

<div id="gstSummary" style="display: none;">
                                                <div class="summary-row">
                                                    <span>Total GST:</span>
                                                    <span id="totalGst">₹0.00</span>
                                                </div>

<div class="summary-row summary-total">
                                                <span>Grand Total:</span>
                                                <span id="grandTotal">₹0.00</span>
                                            </div>
                                        </div>

<div class="mt-4">
                                            <label class="form-label">Notes</label>
                                            <textarea class="form-control" id="notes" name="notes" rows="3" 
                                                placeholder="Add any special instructions or notes..."><?php echo htmlspecialchars($quotation['notes'] ?? ''); ?></textarea>
                                        </div>
                                    </div>
                                </div>

<div class="card">
                                    <div class="card-body text-center">
                                        <h5 class="card-title mb-3">Update Quotation</h5>
                                        <div class="d-grid gap-2">
                                            <button type="button" class="btn btn-warning btn-lg update-quotation-btn" onclick="updateQuotation()">
                                                <i class="fas fa-save me-2"></i> Update Quotation
                                            </button>
                                            <a href="view-quotation.php?id=<?php echo $quotation_id; ?>" class="btn btn-outline-secondary">
                                                <i class="fas fa-times me-2"></i> Cancel
                                            </a>
                                        </div>
                                        <p class="text-muted mt-3 mb-0 small">
                                            <i class="fas fa-info-circle me-1"></i>
                                            Changes will be saved immediately
                                        </p>
                                    </div>
                                </div>
                            </div>
                        </div>
                        
                        
                        <input type="hidden" id="items" name="items" value="">
                    </form>

<div class="floating-update-btn d-lg-none">
                        <button type="button" class="btn btn-warning btn-lg rounded-pill shadow-lg" onclick="updateQuotation()">
                            <i class="fas fa-save me-2"></i> Update
                        </button>
                    </div>

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

<div id="toastContainer" class="toast-container position-fixed top-0 end-0 p-3"></div>

<div class="modal fade" id="editPriceModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Edit Item Details</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <input type="hidden" id="edit_item_index">
                    <div class="mb-3">
                        <label class="form-label">Item Name</label>
                        <input type="text" class="form-control" id="edit_item_name" readonly>
                    </div>
                    <div class="row">
                        <div class="col-md-6 mb-3">
                            <label class="form-label">Price (₹) *</label>
                            <input type="number" class="form-control" id="edit_item_price" step="0.01" min="0" required>
                        </div>
                        <div class="col-md-6 mb-3">
                            <label class="form-label">Quantity *</label>
                            <input type="number" class="form-control" id="edit_item_quantity" step="1" min="1" required>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-md-6 mb-3">
                            <label class="form-label">Discount (%)</label>
                            <input type="number" class="form-control" id="edit_item_discount" step="0.01" min="0" max="100" value="0">
                        </div>
                        <div class="col-md-6 mb-3">
                            <label class="form-label">GST (%)</label>
                            <input type="number" class="form-control" id="edit_item_gst" step="0.01" min="0" max="100">
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="button" class="btn btn-primary" onclick="saveEditedItem()">Save Changes</button>
                </div>
            </div>
        </div>
    </div>

$(document).ready(function() {
        // Handle GST toggle
        $('#include_gst').change(function() {
            includeGst = $(this).is(':checked');
            updateSummary();
        });

// Handle customer selection
        $('#customer_id').change(function() {
            const selectedOption = $(this).find(':selected');
            const customerName = selectedOption.data('name') || '';
            const customerPhone = selectedOption.data('phone') || '';
            
            $('#customer_name').val(customerName);
            $('#customer_phone').val(customerPhone);
        });

// Load initial products and services
        loadProducts();
        loadServices();
        
        // Initialize with existing items
        updateSelectedItems();
        updateSummary();
        
        // Load template for selected business
        loadTemplate();
    });

// Load products via AJAX
    function loadProducts() {
        $.ajax({
            url: 'ajax/get-products.php',
            type: 'GET',
            dataType: 'json',
            cache: false,
            timeout: 30000,
            beforeSend: function() {
                $('#productsTableBody').html('<tr><td colspan="6" class="text-center text-muted"><i class="fas fa-spinner fa-spin me-2"></i> Loading products...</td></tr>');
            },
            success: function (products) {
                let html = '';

if (!Array.isArray(products) || products.length === 0) {
                    html = '<tr><td colspan="6" class="text-center text-muted">No products available</td></tr>';
                } else {
                    products.forEach((product, index) => {
                        html += `
                        <tr data-id="${product.id}" 
                            data-type="product"
                            data-name="${String(product.product_name).replace(/"/g, '&quot;')}"
                            data-price="${product.customer_price}"
                            data-gst="${product.is_gst_applicable ? product.gst_percentage : 0}"
                            data-is-gst="${product.is_gst_applicable}"
                            data-hsn="${product.hsn_code || ''}"
                            data-description="${product.description ? String(product.description).replace(/"/g, '&quot;') : ''}">
                            <td>${index + 1}</td>
                            <td>
                                <strong>${product.product_name}</strong>
                                <br><small class="text-muted">${product.category_name || ''}</small>
                            </td>
                            <td>₹${parseFloat(product.customer_price).toFixed(2)}</td>
                            <td>${product.quantity}</td>
                            <td>
                                ${product.is_gst_applicable == 1 ? 
                                    `<span class="badge bg-primary badge-sm">${product.gst_percentage}%</span>` : 
                                    `<span class="badge bg-secondary badge-sm">No GST</span>`}
                            </td>
                            <td>
                                <button type="button" class="btn btn-sm btn-outline-primary" onclick="addExistingItem(this.closest('tr'))">
                                    <i class="fas fa-plus"></i> Add
                                </button>
                            </td>
                        </tr>`;
                    });
                }

$('#productsTableBody').html(html);
            },
            error: function(xhr, status, error) {
                console.error('Error loading products:', xhr.responseText || status || error);
                $('#productsTableBody').html('<tr><td colspan="6" class="text-center text-danger">Failed to load products</td></tr>');
            }
        });
    }

// Load services via AJAX
    function loadServices() {
        $.ajax({
            url: 'ajax/get-services.php',
            type: 'GET',
            dataType: 'json',
            cache: false,
            timeout: 30000,
            beforeSend: function() {
                $('#servicesTableBody').html('<tr><td colspan="6" class="text-center text-muted"><i class="fas fa-spinner fa-spin me-2"></i> Loading services...</td></tr>');
            },
            success: function (services) {
                let html = '';

if (!Array.isArray(services) || services.length === 0) {
                    html = '<tr><td colspan="6" class="text-center text-muted">No services available</td></tr>';
                } else {
                    services.forEach((service, index) => {
                        html += `
                        <tr data-id="${service.id}" 
                            data-type="service"
                            data-name="${String(service.service_name).replace(/"/g, '&quot;')}"
                            data-price="${service.selling_price}"
                            data-gst="${service.is_gst_applicable ? service.gst_percentage : 0}"
                            data-is-gst="${service.is_gst_applicable}"
                            data-hsn="${service.hsn_code || ''}"
                            data-description="${service.description ? String(service.description).replace(/"/g, '&quot;') : ''}">
                            <td>${index + 1}</td>
                            <td>
                                <strong>${service.service_name}</strong>
                                <br><small class="text-muted">${service.category_name || ''}</small>
                            </td>
                            <td>₹${parseFloat(service.selling_price).toFixed(2)}</td>
                            <td>${service.duration || 'N/A'}</td>
                            <td>
                                ${service.is_gst_applicable == 1 ? 
                                    `<span class="badge bg-primary badge-sm">${service.gst_percentage}%</span>` : 
                                    `<span class="badge bg-secondary badge-sm">No GST</span>`}
                            </td>
                            <td>
                                <button type="button" class="btn btn-sm btn-outline-primary" onclick="addExistingItem(this.closest('tr'))">
                                    <i class="fas fa-plus"></i> Add
                                </button>
                            </td>
                        </tr>`;
                    });
                }

$('#servicesTableBody').html(html);
            },
            error: function(xhr, status, error) {
                console.error('Error loading services:', xhr.responseText || status || error);
                $('#servicesTableBody').html('<tr><td colspan="6" class="text-center text-danger">Failed to load services</td></tr>');
            }
        });
    }

// Add existing item to quotation
    function addExistingItem(row) {
        const $row = $(row);
        const item = {
            id: parseInt($row.data('id')),
            type: $row.data('type'),
            name: $row.data('name'),
            price: parseFloat($row.data('price')),
            gst_percentage: parseFloat($row.data('gst')),
            is_gst_applicable: parseInt($row.data('is-gst')) || 0,
            hsn_code: $row.data('hsn') || '',
            description: $row.data('description') || '',
            quantity: 1,
            discount: 0,
            discount_type: 'percent',
            original_price: parseFloat($row.data('price'))
        };

// Check if item already exists (same ID and type)
        const existingIndex = selectedItems.findIndex(i => i.id === item.id && i.type === item.type);

if (existingIndex > -1) {
            // Increase quantity
            selectedItems[existingIndex].quantity += 1;
        } else {
            // Add new item
            selectedItems.push(item);
        }

updateSelectedItems();
        updateSummary();
    }

// Add new item to quotation
    function addNewItem() {
        const itemType = $('#new_item_type').val();
        const itemName = $('#new_item_name').val().trim();
        const itemPrice = parseFloat($('#new_item_price').val()) || 0;
        const itemQuantity = parseFloat($('#new_item_quantity').val()) || 1;
        const itemGst = parseFloat($('#new_item_gst').val()) || 0;
        const itemHsn = $('#new_item_hsn').val().trim();
        const itemDescription = $('#new_item_description').val().trim();

if (!itemName) {
            showToast('Please enter item name', 'error');
            return;
        }

if (itemPrice <= 0) {
            showToast('Please enter a valid price', 'error');
            return;
        }

if (itemQuantity <= 0) {
            showToast('Please enter a valid quantity', 'error');
            return;
        }

const item = {
            id: itemCounter++,
            type: itemType,
            name: itemName,
            price: itemPrice,
            gst_percentage: itemGst,
            is_gst_applicable: itemGst > 0 ? 1 : 0,
            hsn_code: itemHsn,
            description: itemDescription,
            quantity: itemQuantity,
            discount: 0,
            discount_type: 'percent',
            original_price: itemPrice
        };

// Check if similar item already exists
        const existingIndex = selectedItems.findIndex(i => 
            i.name.toLowerCase() === item.name.toLowerCase() && 
            i.type === item.type
        );

if (existingIndex > -1) {
            // Increase quantity
            selectedItems[existingIndex].quantity += itemQuantity;
        } else {
            // Add new item
            selectedItems.push(item);
        }

// Clear new item form
        $('#new_item_name').val('');
        $('#new_item_price').val('');
        $('#new_item_quantity').val(1);
        $('#new_item_hsn').val('');
        $('#new_item_description').val('');

updateSelectedItems();
        updateSummary();

// Switch back to products tab
        $('#products-tab').tab('show');

// Show success message
        showToast('Item added successfully!', 'success');
    }

// Update selected items display
    function updateSelectedItems() {
        const container = $('#selectedItems');
        const countElement = $('#selectedItemsCount');

if (selectedItems.length === 0) {
            container.html('<p class="text-muted text-center">No items selected yet.</p>');
            countElement.text('0');
            return;
        }

let html = '';
        countElement.text(selectedItems.length);

selectedItems.forEach((item, index) => {
            const totalBeforeDiscount = item.price * item.quantity;
            let discountAmount = 0;
            
            if (item.discount > 0) {
                if (item.discount_type === 'percent') {
                    discountAmount = (totalBeforeDiscount * item.discount) / 100;
                } else {
                    discountAmount = item.discount;
                }
            }
            
            const total = totalBeforeDiscount - discountAmount;
            const itemTotal = includeGst && item.is_gst_applicable ? 
                total + (total * item.gst_percentage / 100) : 
                total;

const typeBadge = item.type === 'product' ? 
                '<span class="badge bg-info type-badge">PRODUCT</span>' : 
                '<span class="badge bg-warning type-badge">SERVICE</span>';

html += `
            <div class="item-row">
                <div class="d-flex justify-content-between align-items-start">
                    <div class="me-2" style="flex: 1;">
                        <strong>${item.name}</strong>
                        <div class="text-muted small">
                            ${typeBadge}
                            <br>
                            ₹${item.price.toFixed(2)} × ${item.quantity} = ₹${totalBeforeDiscount.toFixed(2)}
                            ${item.discount > 0 ? `<br>Discount: ${item.discount}${item.discount_type === 'percent' ? '%' : '₹'}` : ''}
                            ${discountAmount > 0 ? `<br>After Discount: ₹${total.toFixed(2)}</span>` : ''}
                            ${includeGst && item.is_gst_applicable ? `<br>+ GST ${item.gst_percentage}%` : ''}
                        </div>
                    </div>
                    <div class="text-end">
                        <strong>₹${itemTotal.toFixed(2)}</strong>
                        <div class="mt-1">
                            <button type="button" class="btn btn-sm btn-outline-warning edit-price-btn" onclick="editItem(${index})" title="Edit">
                                <i class="fas fa-edit"></i>
                            </button>
                            <button type="button" class="btn btn-sm btn-outline-danger" onclick="removeItem(${index})" title="Remove">
                                <i class="fas fa-times"></i>
                            </button>
                        </div>
                    </div>
                </div>
                <div class="d-flex justify-content-between align-items-center mt-1">
                    <small>
                        <button class="btn btn-xs btn-outline-secondary p-0 px-1" onclick="updateQuantity(${index}, -1)">-</button>
                        <span class="mx-2">Qty: ${item.quantity}</span>
                        <button class="btn btn-xs btn-outline-secondary p-0 px-1" onclick="updateQuantity(${index}, 1)">+</button>
                    </small>
                    <small class="text-muted">${item.type === 'product' ? 'Product' : 'Service'}</small>
                </div>
            </div>
            `;
        });

container.html(html);
    }

// Edit item details
    function editItem(index) {
        const item = selectedItems[index];
        
        $('#edit_item_index').val(index);
        $('#edit_item_name').val(item.name);
        $('#edit_item_price').val(item.price);
        $('#edit_item_quantity').val(item.quantity);
        $('#edit_item_discount').val(item.discount);
        $('#edit_item_gst').val(item.gst_percentage);
        
        $('#editPriceModal').modal('show');
    }

// Save edited item
    function saveEditedItem() {
        const index = parseInt($('#edit_item_index').val());
        if (isNaN(index) || index < 0 || index >= selectedItems.length) return;
        
        const newPrice = parseFloat($('#edit_item_price').val()) || 0;
        const newQuantity = parseFloat($('#edit_item_quantity').val()) || 1;
        const newDiscount = parseFloat($('#edit_item_discount').val()) || 0;
        const newGst = parseFloat($('#edit_item_gst').val()) || 0;
        
        if (newPrice <= 0) {
            showToast('Please enter a valid price', 'error');
            return;
        }
        
        if (newQuantity <= 0) {
            showToast('Please enter a valid quantity', 'error');
            return;
        }
        
        selectedItems[index].price = newPrice;
        selectedItems[index].quantity = newQuantity;
        selectedItems[index].discount = newDiscount;
        selectedItems[index].gst_percentage = newGst;
        selectedItems[index].is_gst_applicable = newGst > 0 ? 1 : 0;
        
        $('#editPriceModal').modal('hide');
        updateSelectedItems();
        updateSummary();
        
        showToast('Item updated successfully!', 'success');
    }

// Remove item
    function removeItem(index) {
        if (confirm('Are you sure you want to remove this item?')) {
            selectedItems.splice(index, 1);
            updateSelectedItems();
            updateSummary();
        }
    }

// Update item quantity
    function updateQuantity(index, change) {
        const newQuantity = selectedItems[index].quantity + change;

if (newQuantity > 0) {
            selectedItems[index].quantity = newQuantity;
            updateSelectedItems();
            updateSummary();
        }
    }

// Update summary calculations
    function updateSummary() {
        let subtotal = 0;
        let totalGst = 0;
        let totalCgst = 0;
        let totalSgst = 0;
        let grandTotal = 0;

selectedItems.forEach(item => {
            const itemTotalBeforeDiscount = item.price * item.quantity;
            let discountAmount = 0;
            
            if (item.discount > 0) {
                if (item.discount_type === 'percent') {
                    discountAmount = (itemTotalBeforeDiscount * item.discount) / 100;
                } else {
                    discountAmount = item.discount;
                }
            }
            
            const itemTotal = itemTotalBeforeDiscount - discountAmount;
            subtotal += itemTotal;

if (includeGst && item.is_gst_applicable) {
                const itemGst = (itemTotal * item.gst_percentage) / 100;
                totalGst += itemGst;
                totalCgst += itemGst / 2;
                totalSgst += itemGst / 2;
            }
        });

grandTotal = includeGst ? subtotal + totalGst : subtotal;

$('#subtotal').text('₹' + subtotal.toFixed(2));
        $('#totalGst').text('₹' + totalGst.toFixed(2));
        $('#totalCgst').text('₹' + totalCgst.toFixed(2));
        $('#totalSgst').text('₹' + totalSgst.toFixed(2));
        $('#grandTotal').text('₹' + grandTotal.toFixed(2));

// Show/hide GST summary based on GST toggle
        if (includeGst) {
            $('#gstSummary').show();
        } else {
            $('#gstSummary').hide();
        }
    }

// Load template for selected business
    function loadTemplate() {
        const businessId = $('#business_id').val();

if (!businessId) {
            $('#templatePreview').html('<span class="text-muted">Select business to view template</span>');
            $('#template_file').val('');
            $('#template_name').val('');
            return;
        }

// Show loading
        $('#templatePreview').html('<span class="text-muted"><i class="fas fa-spinner fa-spin me-2"></i>Loading...</span>');

// Use current page URL for AJAX request
        $.ajax({
            url: window.location.href,
            method: 'POST',
            data: {
                action: 'get_template',
                business_id: businessId
            },
            dataType: 'json',
            success: function(response) {
                if (response && response.success) {
                    $('#templatePreview').html(`<span class="template-name">${response.template_name}</span>`);
                    $('#template_file').val(response.template_file);
                    $('#template_name').val(response.template_name);
                } else {
                    $('#templatePreview').html(`<span class="text-danger"><i class="fas fa-exclamation-triangle me-1"></i>${(response && response.message) ? response.message : 'No template found'}</span>`);
                    $('#template_file').val('');
                    $('#template_name').val('');
                }
            },
            error: function(xhr, status, err) {
                console.error('Template loading error:', xhr.responseText || status || err);
                $('#templatePreview').html('<span class="text-danger"><i class="fas fa-exclamation-circle me-1"></i>Failed to load template</span>');
                $('#template_file').val('');
                $('#template_name').val('');
            }
        });
    }

// Show toast notification
    function showToast(message, type = 'info', details = '') {
        const toastId = 'toast-' + Date.now();
        const toastHtml = `
        <div id="${toastId}" class="toast align-items-center text-white bg-${type === 'error' ? 'danger' : type === 'success' ? 'success' : 'info'} border-0" role="alert" aria-live="assertive" aria-atomic="true">
            <div class="d-flex">
                <div class="toast-body" style="flex: 1;">
                    ${message}
                    ${details ? `<div class="error-details mt-2">${details}</div>` : ''}
                </div>
                <button type="button" class="btn-close btn-close-white me-2 m-auto" data-bs-dismiss="toast" aria-label="Close"></button>
            </div>
        </div>`;
        
        $('#toastContainer').append(toastHtml);
        const bsToast = new bootstrap.Toast($(`#${toastId}`)[0]);
        bsToast.show();
        
        setTimeout(() => {
            $(`#${toastId}`).remove();
        }, type === 'error' ? 10000 : 5000);
    }

// Update quotation
    function updateQuotation() {
        // Prevent double submit
        if (isSaving) {
            showToast('Please wait, updating in progress...', 'info');
            return;
        }
        isSaving = true;

const $mainBtn = $('.update-quotation-btn');
        const $mobileBtn = $('.floating-update-btn button');

// Store original button HTML
        const mainOrigHtml = $mainBtn.html();
        const mobileOrigHtml = $mobileBtn.length ? $mobileBtn.html() : '';

// Gather customer info
        const customerId = parseInt($('#customer_id').val()) || 0;
        const customerName = $('#customer_name').val().trim();
        const customerPhone = $('#customer_phone').val().trim();
        
        if (customerId <= 0 && !customerName) {
            showToast('Please select or enter customer name', 'error');
            isSaving = false;
            return;
        }

const businessId = $('#business_id').val();
        const templateFile = $('#template_file').val();
        const templateName = $('#template_name').val();
        const includeGstVal = $('#include_gst').is(':checked') ? 1 : 0;
        const notes = $('#notes').val();

// Validation
        if (!businessId) {
            showToast('Please select a business', 'error');
            isSaving = false;
            return;
        }

if (selectedItems.length === 0) {
            showToast('Please add at least one item to the quotation', 'error');
            isSaving = false;
            return;
        }

if (!templateFile || !templateName) {
            showToast('No template mapped to this business. Please map a template first.', 'error');
            isSaving = false;
            return;
        }

// Disable both buttons and show loading text
        $mainBtn.prop('disabled', true).html('<i class="fas fa-spinner fa-spin me-1"></i> Updating...');
        if ($mobileBtn.length) {
            $mobileBtn.prop('disabled', true).html('<i class="fas fa-spinner fa-spin me-1"></i> Updating...');
        }

// Update hidden items field
        $('#items').val(JSON.stringify(selectedItems));

// Submit the form
        $('#editQuotationForm').submit();
    }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-quotation.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation