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

🔧 Quick Actions

✏️ Editing: new-quotation.php

<?php
// new-quotation.php (complete file)

require_once('includes/db.php'); // must define $conn (mysqli)

// Helper to always return pure JSON and exit
function send_json($arr, $http_code = 200) {
    if (!headers_sent()) {
        http_response_code($http_code);
        header('Content-Type: application/json; charset=utf-8');
    }
    while (ob_get_level() > 0) {
        ob_end_clean();
    }
    echo json_encode($arr);
    exit;
}

// Basic auth check (adjust to your auth logic)
if (!isset($_SESSION['user_id'])) {
    if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
        send_json(['success' => false, 'message' => 'Unauthorized'], 401);
    } else {
        header("Location: user-login.php");
        exit();
    }
}

// Load businesses and customers for page render
$businesses = [];
$customers = [];

$businesses_sql = "SELECT * FROM gst_details ORDER BY business_name";
$bres = mysqli_query($conn, $businesses_sql);
if ($bres) {
    while ($r = mysqli_fetch_assoc($bres)) {
        $businesses[] = $r;
    }
}

$customers_sql = "SELECT * FROM customers ORDER BY name";
$cres = mysqli_query($conn, $customers_sql);
if ($cres) {
    while ($r = mysqli_fetch_assoc($cres)) {
        $customers[] = $r;
    }
}

// Handle AJAX POST actions BEFORE any HTML output
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    ini_set('display_errors', '1');
    error_reporting(E_ALL);
    
    $action = $_POST['action'];

if ($action === 'get_template') {
        $business_id = isset($_POST['business_id']) ? (int) $_POST['business_id'] : 0;
        if ($business_id <= 0) {
            send_json(['success' => false, 'message' => 'Invalid business id']);
        }

$bid = (int)$business_id;
        $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 = {$bid} AND tm.is_active = 1
                         LIMIT 1";
        $tres = mysqli_query($conn, $template_sql);
        if (!$tres) {
            send_json(['success' => false, 'message' => 'DB error while fetching template: ' . mysqli_error($conn)]);
        }
        $mapping = mysqli_fetch_assoc($tres);
        if ($mapping) {
            send_json([
                'success' => true,
                'template_file' => $mapping['template_file'] ?? '',
                'template_name' => $mapping['template_name'] ?? '',
                'business_name' => $mapping['business_name'] ?? ''
            ]);
        } else {
            send_json(['success' => false, 'message' => 'No template mapped to this business']);
        }
    }

if ($action === 'test_connection') {
        send_json(['success' => true, 'message' => 'Connection successful']);
    }

if ($action === 'save_quotation') {
        try {
            // Read input fields
            $quotation_type = 'mixed'; // Always mixed since we allow both
            $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 = json_decode($items_raw, true);
            if (!is_array($items)) {
                $items = [];
            }

if (empty($items)) {
                send_json(['success' => false, 'message' => 'Please add at least one item']);
            }
            
            if ($business_id <= 0) {
                send_json(['success' => false, 'message' => 'Please select a business']);
            }

// Start transaction
            mysqli_begin_transaction($conn);

// Generate quotation number
            $quotation_number = 'QTN' . date('YmdHis') . rand(100, 999);

// Calculation variables
            $subtotal = 0.0;
            $total_gst = 0.0;
            $total_cgst = 0.0;
            $total_sgst = 0.0;
            $grand_total = 0.0;

$quotation_items = [];

foreach ($items as $item) {
                $item_type = $item['type'] ?? '';
                $item_id = (int)($item['id'] ?? 0);
                $quantity = (float)($item['quantity'] ?? 1);
                $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'] ?? '');
                $item_name = trim($item['name'] ?? '');
                $description = trim($item['description'] ?? '');

// item total before gst
                $item_total = $price * $quantity;

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

$item_gst = 0.0;
                $item_cgst = 0.0;
                $item_sgst = 0.0;
                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;
                }

$item_grand_total = $item_total + $item_gst;

$subtotal += $item_total;
                $total_gst += $item_gst;
                $total_cgst += $item_cgst;
                $total_sgst += $item_sgst;
                $grand_total += $item_grand_total;

$quotation_items[] = [
                    'type' => $item_type,
                    'item_id' => $item_id,
                    'item_name' => $item_name,
                    'quantity' => $quantity,
                    'unit_price' => $price,
                    'discount' => $discount,
                    'discount_type' => $discount_type,
                    'total_price' => $item_total,
                    'gst_percentage' => $gst_percentage,
                    'gst_amount' => $item_gst,
                    'cgst_amount' => $item_cgst,
                    'sgst_amount' => $item_sgst,
                    'grand_total' => $item_grand_total,
                    'hsn_code' => $hsn_code,
                    'description' => $description
                ];
            }

// 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);
                if (!$stmt) {
                    throw new Exception('DB prepare error (insert customer): ' . mysqli_error($conn));
                }
                mysqli_stmt_bind_param($stmt, "ss", $customer_name, $customer_phone);
                if (!mysqli_stmt_execute($stmt)) {
                    $err = mysqli_stmt_error($stmt);
                    mysqli_stmt_close($stmt);
                    throw new Exception('Failed to save customer: ' . $err);
                }
                $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);
            if (!$business_stmt) {
                throw new Exception('DB prepare error (business): ' . mysqli_error($conn));
            }
            mysqli_stmt_bind_param($business_stmt, "i", $business_id);
            if (!mysqli_stmt_execute($business_stmt)) {
                $err = mysqli_stmt_error($business_stmt);
                mysqli_stmt_close($business_stmt);
                throw new Exception('Failed to fetch business: ' . $err);
            }
            $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);
                if ($cust_stmt) {
                    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);
                }
            }

// Insert quotation
            $quotation_sql = "INSERT INTO quotations (
                quotation_number, quotation_type, 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,
                status, created_by, created_at
            ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'draft', ?, NOW())";

$quotation_stmt = mysqli_prepare($conn, $quotation_sql);
            if (!$quotation_stmt) {
                throw new Exception('DB prepare error (quotation): ' . mysqli_error($conn));
            }

$created_by = (int)($_SESSION['user_id'] ?? 1);
            
            mysqli_stmt_bind_param(
                $quotation_stmt,
                "ssississssidddddsi",
                $quotation_number,
                $quotation_type,
                $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,
                $created_by
            );

if (!mysqli_stmt_execute($quotation_stmt)) {
                $err = mysqli_stmt_error($quotation_stmt);
                mysqli_stmt_close($quotation_stmt);
                throw new Exception('Failed to save quotation: ' . $err);
            }

$quotation_id = mysqli_insert_id($conn);
            mysqli_stmt_close($quotation_stmt);

// Insert quotation 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);
            if (!$item_stmt) {
                throw new Exception('DB prepare error (item): ' . mysqli_error($conn));
            }

foreach ($quotation_items as $it) {
                $item_type = $it['type'] ?? '';
                $item_id = $it['item_id'] ?? 0;
                $item_name = $it['item_name'] ?? '';
                $quantity = $it['quantity'] ?? 1;
                $unit_price = $it['unit_price'] ?? 0;
                $discount = $it['discount'] ?? 0;
                $discount_type = $it['discount_type'] ?? 'percent';
                $total_price = $it['total_price'] ?? 0;
                $gst_percentage = $it['gst_percentage'] ?? 0;
                $gst_amount = $it['gst_amount'] ?? 0;
                $cgst_amount = $it['cgst_amount'] ?? 0;
                $sgst_amount = $it['sgst_amount'] ?? 0;
                $grand_total = $it['grand_total'] ?? 0;
                $hsn_code = $it['hsn_code'] ?? '';
                $description = $it['description'] ?? '';

// Bind parameters
                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,
                    $grand_total,
                    $hsn_code,
                    $description
                );

if (!mysqli_stmt_execute($item_stmt)) {
                    $err = mysqli_stmt_error($item_stmt);
                    mysqli_stmt_close($item_stmt);
                    throw new Exception('Failed to save quotation item: ' . $err);
                }
            }

mysqli_stmt_close($item_stmt);

// Commit transaction
            mysqli_commit($conn);

send_json([
                'success' => true,
                'message' => 'Quotation saved successfully!',
                'quotation_id' => $quotation_id,
                'quotation_number' => $quotation_number
            ]);
            
        } catch (Exception $e) {
            // Rollback transaction on error
            if ($conn) {
                mysqli_rollback($conn);
            }
            send_json(['success' => false, 'message' => $e->getMessage()], 500);
        }
    }

// Unknown action
    send_json(['success' => false, 'message' => 'Unknown action']);
}

// If not AJAX, render full page HTML below
?>
<!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; }
        .create-quotation-btn { font-size:1.1rem; padding:12px 30px; border-radius:8px; font-weight:600; }
        .floating-create-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;
        }
        .button-group { display:flex; flex-direction:column; gap:10px; margin-top:15px; }
        .button-group .btn { width:100%; }
        .action-buttons { display:flex; flex-wrap:wrap; gap:10px; justify-content:center; }
        @media (max-width: 768px) {
            .item-list { max-height: 220px; }
            .floating-create-btn { bottom: 20px; right: 20px; }
            .action-buttons { flex-direction:column; }
            .button-group { flex-direction:row; }
        }
        @media (min-width: 769px) {
            .button-group { flex-direction:row; }
            .button-group .btn { flex:1; }
        }
    </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="row mt-3">
                        
                        <div class="col-lg-8">
                            
                            <div class="card mb-3">
                                <div class="card-body">
                                    <h5 class="card-title mb-3">Step 1: Customer Details</h5>

<ul class="nav nav-tabs customer-type-tabs mb-3" id="customerTypeTab" role="tablist">
                                        <li class="nav-item" role="presentation">
                                            <button class="nav-link active" id="existing-customer-tab" data-bs-toggle="tab" data-bs-target="#existing-customer" type="button" role="tab">
                                                Existing Customer
                                            </button>
                                        </li>
                                        <li class="nav-item" role="presentation">
                                            <button class="nav-link" id="new-customer-tab" data-bs-toggle="tab" data-bs-target="#new-customer" type="button" role="tab">
                                                New Customer
                                            </button>
                                        </li>
                                    </ul>

<div class="tab-content">
                                        
                                        <div class="tab-pane fade show active customer-details-tab" id="existing-customer" role="tabpanel">
                                            <div class="row">
                                                <div class="col-md-12 mb-3">
                                                    <label class="form-label">Select Customer</label>
                                                    <select class="form-control" id="existing_customer_id">
                                                        <option value="">Select Customer...</option>
                                                        <?php foreach ($customers as $customer): ?>
                                                            <option value="<?php echo $customer['id']; ?>" 
                                                                    data-name="<?php echo htmlspecialchars($customer['name']); ?>"
                                                                    data-phone="<?php echo htmlspecialchars($customer['phone'] ?? ''); ?>"
                                                                    data-email="<?php echo htmlspecialchars($customer['email'] ?? ''); ?>"
                                                                    data-address="<?php echo htmlspecialchars($customer['address'] ?? ''); ?>"
                                                                    data-gst="<?php echo htmlspecialchars($customer['gst_number'] ?? ''); ?>">
                                                                <?php echo htmlspecialchars($customer['name']); ?>
                                                                <?php if (!empty($customer['phone'])): ?>
                                                                    (<?php echo htmlspecialchars($customer['phone']); ?>)
                                                                <?php endif; ?>
                                                            </option>
                                                        <?php endforeach; ?>
                                                    </select>
                                                </div>
                                            </div>
                                        </div>

<div class="tab-pane fade customer-details-tab" id="new-customer" role="tabpanel">
                                            <div class="row">
                                                <div class="col-md-6 mb-3">
                                                    <label class="form-label">Customer Name *</label>
                                                    <input type="text" class="form-control" id="new_customer_name" placeholder="Enter customer name" required>
                                                </div>
                                                <div class="col-md-6 mb-3">
                                                    <label class="form-label">Phone Number</label>
                                                    <input type="text" class="form-control" id="new_customer_phone" placeholder="Enter phone number">
                                                </div>
                                            </div>
                                            <div class="row">
                                                <div class="col-md-6 mb-3">
                                                    <label class="form-label">Email (Optional)</label>
                                                    <input type="email" class="form-control" id="new_customer_email" placeholder="Enter email">
                                                </div>
                                                <div class="col-md-6 mb-3">
                                                    <label class="form-label">GST Number (Optional)</label>
                                                    <input type="text" class="form-control" id="new_customer_gst" placeholder="Enter GST number">
                                                </div>
                                            </div>
                                            <div class="row">
                                                <div class="col-12 mb-3">
                                                    <label class="form-label">Address (Optional)</label>
                                                    <textarea class="form-control" id="new_customer_address" rows="2" placeholder="Enter address"></textarea>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

<div class="card mb-3">
                                <div class="card-body">
                                    <h5 class="card-title mb-3">Step 2: 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" required onchange="loadTemplate()">
                                                <option value="">Select Business...</option>
                                                <?php foreach ($businesses as $business): ?>
                                                    <option value="<?php echo $business['id']; ?>"
                                                            data-business-name="<?php echo htmlspecialchars($business['business_name']); ?>"
                                                            data-gst="<?php echo htmlspecialchars($business['gst_num'] ?? ''); ?>"
                                                            data-address="<?php echo htmlspecialchars($business['address'] ?? ''); ?>">
                                                        <?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">
                                                <span class="text-muted">Select business to view template</span>
                                            </div>
                                            <input type="hidden" id="template_file">
                                            <input type="hidden" id="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" 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">Step 3: Add 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">
                                        <p class="text-muted text-center">No items selected yet.</p>
                                    </div>
                                </div>
                            </div>

<div class="card">
                                <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" rows="3" placeholder="Add any special instructions or notes..."></textarea>
                                    </div>
                                </div>
                            </div>

<div class="card mt-3">
                                <div class="card-body text-center">
                                    <h5 class="card-title mb-3">Actions</h5>
                                    <div class="button-group">
                                        <button id="createQuotationBtn" type="button" class="btn btn-success btn-lg create-quotation-btn" onclick="saveQuotation()">
                                            <i class="fas fa-file-invoice-dollar me-2"></i> Create Quotation
                                        </button>
                                    </div>
                                    <div class="mt-3">
                                        <button type="button" class="btn btn-outline-secondary" onclick="previewQuotation()">
                                            <i class="fas fa-eye me-2"></i> Preview
                                        </button>
                                        <button type="button" class="btn btn-outline-danger ms-2" onclick="resetForm()">
                                            <i class="fas fa-redo me-2"></i> Reset
                                        </button>
                                    </div>
                                    <p class="text-muted mt-3 mb-0 small">
                                        <i class="fas fa-info-circle me-1"></i>
                                        Click "Create Quotation" to save as draft.
                                    </p>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="floating-create-btn d-lg-none">
                        <button id="createQuotationBtnMobile" type="button" class="btn btn-success btn-lg rounded-pill shadow-lg" onclick="saveQuotation()">
                            <i class="fas fa-plus-circle me-2"></i> Create Quotation
                        </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>

<div class="modal fade" id="previewModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">
                        <i class="fas fa-file-invoice-dollar me-2"></i>Quotation Preview
                    </h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body"></div>
            </div>
        </div>
    </div>

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

// Handle customer selection
        $('#existing_customer_id').change(function() {
            const selectedOption = $(this).find(':selected');
            const customerName = selectedOption.data('name') || '';
            const customerPhone = selectedOption.data('phone') || '';
            const customerEmail = selectedOption.data('email') || '';
            const customerAddress = selectedOption.data('address') || '';
            const customerGst = selectedOption.data('gst') || '';

// Update new customer fields
            $('#new_customer_name').val(customerName);
            $('#new_customer_phone').val(customerPhone);
            $('#new_customer_email').val(customerEmail);
            $('#new_customer_address').val(customerAddress);
            $('#new_customer_gst').val(customerGst);
        });

// Load initial products and services
        loadProducts();
        loadServices();
    });

// 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;') : ''}"
                            data-stock="${product.quantity}"
                            data-category="${product.category_name || ''}">
                            <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;') : ''}"
                            data-duration="${service.duration || ''}"
                            data-category="${service.category_name || ''}">
                            <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')),
            stock: $row.data('stock') || 0,
            category: $row.data('category') || '',
            duration: $row.data('duration') || ''
        };

// 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,
            stock: 0,
            category: 'Custom',
            duration: itemType === 'service' ? 'Custom' : ''
        };

// 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>
                        ${itemDetails}
                        <div class="text-muted small mt-1">
                            ₹${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}%</span>` : ''}
                        </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>');

$.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('');
            }
        });
    }

// Preview quotation
    function previewQuotation() {
        // Get customer details
        let customerId = 0;
        let customerName = '';
        const activeTab = $('#customerTypeTab .nav-link.active').attr('id');

if (activeTab === 'existing-customer-tab') {
            customerId = parseInt($('#existing_customer_id').val()) || 0;
            if (customerId <= 0) {
                showToast('Please select a customer', 'error');
                return;
            }
            customerName = $('#existing_customer_id option:selected').data('name') || '';
        } else {
            customerName = $('#new_customer_name').val().trim();
            if (!customerName) {
                showToast('Please enter customer name', 'error');
                return;
            }
        }

// Get other details
        const businessName = $('#business_id option:selected').text();
        const templateName = $('#template_name').val();
        const includeGstNow = $('#include_gst').is(':checked');

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

if (!templateName) {
            showToast('No template selected for this business', 'error');
            return;
        }

// Calculate totals
        let subtotal = 0;
        let totalGst = 0;
        let grandTotal = 0;

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

grandTotal = includeGstNow ? subtotal + totalGst : subtotal;

// Show preview modal
        const previewHtml = `
        <div class="preview-quotation">
            <h5 class="mb-3"><i class="fas fa-eye me-2"></i>Quotation Preview</h5>
            <div class="row">
                <div class="col-md-6">
                    <div class="mb-2">
                        <strong>Customer:</strong> ${customerName || 'Not specified'}
                    </div>
                    <div class="mb-2">
                        <strong>Business:</strong> ${businessName || 'Not selected'}
                    </div>
                    <div class="mb-2">
                        <strong>Template:</strong> ${templateName || 'Not selected'}
                    </div>
                </div>
                <div class="col-md-6">
                    <div class="mb-2">
                        <strong>Items:</strong> ${selectedItems.length}
                    </div>
                    <div class="mb-2">
                        <strong>GST:</strong> ${includeGstNow ? 'Included' : 'Excluded'}
                    </div>
                    <div class="mb-2">
                        <strong>Type:</strong> Mixed (Products & Services)
                    </div>
                </div>
            </div>
            
            <div class="mt-4">
                <h6>Selected Items:</h6>
                <div class="table-responsive">
                    <table class="table table-sm">
                        <thead>
                            <tr>
                                <th>Item</th>
                                <th>Type</th>
                                <th>Qty</th>
                                <th>Price</th>
                                <th>Total</th>
                                ${includeGstNow ? '<th>GST</th>' : ''}
                            </tr>
                        </thead>
                        <tbody>
                            ${selectedItems.map((item) => {
                                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 gst = includeGstNow && item.is_gst_applicable ? (total * item.gst_percentage / 100) : 0;
                                return `
                                <tr>
                                    <td>${item.name}</td>
                                    <td>${item.type === 'product' ? 'Product' : 'Service'}</td>
                                    <td>${item.quantity}</td>
                                    <td>₹${item.price.toFixed(2)}</td>
                                    <td>₹${total.toFixed(2)}</td>
                                    ${includeGstNow ? `<td>${item.is_gst_applicable ? item.gst_percentage + '%' : 'No GST'}</td>` : ''}
                                </tr>
                                `;
                            }).join('')}
                        </tbody>
                    </table>
                </div>
            </div>
            
            <div class="summary-box mt-4">
                <div class="summary-row">
                    <span>Subtotal:</span>
                    <span>₹${subtotal.toFixed(2)}</span>
                </div>
                ${includeGstNow ? `
                <div class="summary-row">
                    <span>Total GST:</span>
                    <span>₹${totalGst.toFixed(2)}</span>
                </div>
                ` : ''}
                <div class="summary-row summary-total">
                    <span>Grand Total:</span>
                    <span>₹${grandTotal.toFixed(2)}</span>
                </div>
            </div>
            
            <div class="mt-4 text-center">
                <button type="button" class="btn btn-primary" onclick="saveQuotation(); $('#previewModal').modal('hide');">
                    <i class="fas fa-check-circle me-2"></i> Yes, Create Quotation
                </button>
                <button type="button" class="btn btn-secondary ms-2" data-bs-dismiss="modal">
                    <i class="fas fa-times me-2"></i> Cancel
                </button>
            </div>
        </div>
        `;

$('#previewModal .modal-body').html(previewHtml);
        $('#previewModal').modal('show');
    }

// Calculate total for display
    function calculateTotal() {
        let subtotal = 0;
        let totalGst = 0;

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

return includeGst ? subtotal + totalGst : subtotal;
    }

// 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);
    }

// Save quotation - single-click friendly
    function saveQuotation() {
        // Prevent double submit
        if (isSaving) {
            showToast('Please wait, saving in progress...', 'info');
            return;
        }
        isSaving = true;

const $mainBtn = $('#createQuotationBtn');
        const $mobileBtn = $('#createQuotationBtnMobile');

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

// Gather customer info
        const activeTab = $('#customerTypeTab .nav-link.active').attr('id');
        let customerId = 0, customerName = '', customerPhone = '', customerEmail = '', customerAddress = '', customerGst = '';
        
        if (activeTab === 'existing-customer-tab') {
            customerId = parseInt($('#existing_customer_id').val()) || 0;
            if (customerId <= 0) {
                showToast('Please select a customer', 'error');
                isSaving = false;
                return;
            }
            customerName = $('#existing_customer_id option:selected').data('name') || '';
            customerPhone = $('#existing_customer_id option:selected').data('phone') || '';
            customerEmail = $('#existing_customer_id option:selected').data('email') || '';
            customerAddress = $('#existing_customer_id option:selected').data('address') || '';
            customerGst = $('#existing_customer_id option:selected').data('gst') || '';
        } else {
            customerName = $('#new_customer_name').val().trim();
            customerPhone = $('#new_customer_phone').val().trim();
            customerEmail = $('#new_customer_email').val().trim();
            customerAddress = $('#new_customer_address').val().trim();
            customerGst = $('#new_customer_gst').val().trim();
            if (!customerName) {
                showToast('Please 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> Creating...');
        if ($mobileBtn.length) {
            $mobileBtn.prop('disabled', true).html('<i class="fas fa-spinner fa-spin me-1"></i> Creating...');
        }

// Prepare form data
        const formData = {
            action: 'save_quotation',
            quotation_type: 'mixed',
            customer_id: customerId,
            customer_name: customerName,
            customer_phone: customerPhone,
            customer_email: customerEmail,
            customer_address: customerAddress,
            customer_gst: customerGst,
            business_id: businessId,
            include_gst: includeGstVal,
            template_file: templateFile,
            template_name: templateName,
            notes: notes,
            items: JSON.stringify(selectedItems)
        };

console.log('Sending quotation data:', formData);
        
        // Start timing the request
        const startTime = Date.now();

$.ajax({
            url: window.location.href,
            method: 'POST',
            data: formData,
            dataType: 'json',
            timeout: 60000,
            beforeSend: function() {
                console.log('AJAX request started...');
            },
            success: function(data, textStatus, xhr) {
                const endTime = Date.now();
                console.log('Request completed in:', (endTime - startTime) + 'ms');
                console.log('Response data:', data);
                
                // Reset buttons immediately
                $mainBtn.prop('disabled', false).html(mainOrigHtml);
                if ($mobileBtn.length) {
                    $mobileBtn.prop('disabled', false).html(mobileOrigHtml);
                }
                
                if (data && data.success) {
                    showToast(data.message, 'success');
                    
                    // Use browser confirmation instead of SweetAlert if SweetAlert is not available
                    if (typeof Swal !== 'undefined') {
                        Swal.fire({
                            icon: 'success',
                            title: 'Quotation Created!',
                            html: `Quotation <strong>${data.quotation_number}</strong> has been created successfully!`,
                            confirmButtonText: 'View Quotation',
                            showCancelButton: true,
                            cancelButtonText: 'Create Another',
                            allowOutsideClick: false
                        }).then((result) => {
                            if (result.isConfirmed) {
                                window.location.href = 'view-quotation.php?id=' + encodeURIComponent(data.quotation_id);
                            } else {
                                resetForm();
                                isSaving = false;
                            }
                        });
                    } else {
                        // Fallback to regular confirm if SweetAlert not available
                        const userChoice = confirm(`Quotation ${data.quotation_number} created successfully!\n\nClick OK to view the quotation, or Cancel to create another.`);
                        if (userChoice) {
                            window.location.href = 'view-quotation.php?id=' + encodeURIComponent(data.quotation_id);
                        } else {
                            resetForm();
                            isSaving = false;
                        }
                    }
                } else {
                    let msg = data && data.message ? data.message : 'Unknown error occurred';
                    console.error('Server error:', msg);
                    showToast('Error: ' + msg, 'error');
                    isSaving = false;
                }
            },
            error: function(xhr, status, error) {
                const endTime = Date.now();
                console.error('AJAX Error:', {
                    status: status,
                    error: error,
                    responseText: xhr.responseText,
                    statusText: xhr.statusText,
                    timeTaken: (endTime - startTime) + 'ms'
                });
                
                let errMsg = 'Request failed: ' + (error || status);
                
                // Try to parse error response
                try {
                    if (xhr.responseText) {
                        const parsed = JSON.parse(xhr.responseText);
                        if (parsed && parsed.message) {
                            errMsg = parsed.message;
                        } else {
                            errMsg = xhr.responseText.substring(0, 200);
                        }
                    }
                } catch (e) {
                    console.error('Error parsing response:', e);
                }
                
                showToast('Failed to save quotation: ' + errMsg, 'error');
                $mainBtn.prop('disabled', false).html(mainOrigHtml);
                if ($mobileBtn.length) {
                    $mobileBtn.prop('disabled', false).html(mobileOrigHtml);
                }
                isSaving = false;
            },
            complete: function() {
                console.log('AJAX request complete');
            }
        });
    }

// Reset form
    function resetForm() {
        if (!confirm('Are you sure you want to reset the form? All data will be lost.')) return;
        selectedItems = [];
        updateSelectedItems();
        updateSummary();

$('#existing_customer_id').val('');
        $('#new_customer_name').val('');
        $('#new_customer_phone').val('');
        $('#new_customer_email').val('');
        $('#new_customer_address').val('');
        $('#new_customer_gst').val('');
        $('#business_id').val('');
        $('#notes').val('');

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

$('#include_gst').prop('checked', true).trigger('change');

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

// Reset tabs
        $('#customerTypeTab .nav-link:first').tab('show');
        $('#itemTypeTab .nav-link:first').tab('show');

// Load products and services
        loadProducts();
        loadServices();
    }
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: new-quotation.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation