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

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: sales-new.php

<?php
session_start();
include('includes/db.php');

// Ensure branch login
if (!isset($_SESSION['branch_id'])) {
    header("Location: login.php");
    exit();
}

// Ensure branch_id is integer
$branch_id = intval($_SESSION['branch_id']);

// Get branch info for display
$branch_sql = "SELECT branch_name, branch_code FROM branches WHERE id = $branch_id LIMIT 1";
$branch_result = $conn->query($branch_sql);
$branch_info = $branch_result && $branch_result->num_rows > 0 ? $branch_result->fetch_assoc() : ['branch_name' => 'Unknown', 'branch_code' => 'N/A'];

// Get active finance names from finance_master table
$finance_sql = "SELECT finance_name FROM finance_master WHERE branch_id = $branch_id AND status = 'active' ORDER BY finance_name ASC";
$finance_result = $conn->query($finance_sql);
$finance_options = [];
while($finance = $finance_result->fetch_assoc()) {
    $finance_options[] = $finance['finance_name'];
}

/**
 * Helper: check if a table has a column
 */
function columnExists($conn, $table, $column) {
    $table_safe = $conn->real_escape_string($table);
    $column_safe = $conn->real_escape_string($column);
    $res = $conn->query("SHOW COLUMNS FROM `{$table_safe}` LIKE '{$column_safe}'");
    return ($res && $res->num_rows > 0);
}

// Check if columns exist in sale_items table
$base_price_exists = columnExists($conn, 'sale_items', 'base_price');
$imei_1_exists = columnExists($conn, 'sale_items', 'imei_number_1');
$imei_2_exists = columnExists($conn, 'sale_items', 'imei_number_2');
$serial_exists = columnExists($conn, 'sale_items', 'serial_number');

// Check if alternate phone column exists in customers table
$alternate_phone_exists = columnExists($conn, 'customers', 'customer_phone_alternate');

// Check if photo column exists in customers table
$photo_column_exists = columnExists($conn, 'customers', 'photo');
$customer_photo_column_exists = columnExists($conn, 'customers', 'customer_photo');

/**
 * Log activity
 */
function logActivity($conn, $activity_type, $description, $related_id = null, $related_table = null) {
    $user_id = isset($_SESSION['staff_id']) ? $_SESSION['staff_id'] : null;
    $ip_address = isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : null;
    $user_agent = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : null;

$stmt = $conn->prepare("INSERT INTO activity_logs (user_id, activity_type, description, related_id, related_table, ip_address, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?)");
    if ($stmt === false) {
        error_log("logActivity prepare failed: " . $conn->error);
        return;
    }
    $stmt->bind_param("ississs", $user_id, $activity_type, $description, $related_id, $related_table, $ip_address, $user_agent);
    $stmt->execute();
    $stmt->close();
}

/**
 * Find or create customer tied to branch with photo upload
 */
function findOrCreateCustomer($conn, $customer_data, $branch_id) {
    global $alternate_phone_exists, $photo_column_exists, $customer_photo_column_exists;
    
    $phone = $customer_data['phone'] ?? '';
    $alternate_phone = $customer_data['alternate_phone'] ?? '';
    $name = $customer_data['name'] ?? '';
    $email = $customer_data['email'] ?? '';
    $address = $customer_data['address'] ?? '';
    $photo_path = $customer_data['photo_path'] ?? null;

$hasBranchColumn = columnExists($conn, 'customers', 'branch_id');

if ($hasBranchColumn) {
        // Check if customer exists with this phone number in the same branch
        $stmt = $conn->prepare("SELECT id FROM customers WHERE customer_phone = ? AND branch_id = ? LIMIT 1");
        $stmt->bind_param("si", $phone, $branch_id);
        $stmt->execute();
        $res = $stmt->get_result();
        
        if ($res && $res->num_rows > 0) {
            // Customer exists, update information
            $row = $res->fetch_assoc();
            $customer_id = intval($row['id']);
            $stmt->close();

// Build update query dynamically based on available columns
            $update_fields = ["customer_name = ?", "customer_email = ?", "customer_address = ?", "updated_at = NOW()"];
            $update_types = "sss";
            $update_values = [$name, $email, $address];
            
            if ($alternate_phone_exists) {
                $update_fields[] = "customer_phone_alternate = ?";
                $update_types .= "s";
                $update_values[] = $alternate_phone;
            }
            
            if ($photo_column_exists && $photo_path) {
                $update_fields[] = "photo = ?";
                $update_types .= "s";
                $update_values[] = $photo_path;
            }
            
            if ($customer_photo_column_exists && $photo_path) {
                $update_fields[] = "customer_photo = ?";
                $update_types .= "s";
                $update_values[] = $photo_path;
            }
            
            $update_values[] = $customer_id;
            $update_types .= "i";
            
            $update_query = "UPDATE customers SET " . implode(", ", $update_fields) . " WHERE id = ?";
            $update_stmt = $conn->prepare($update_query);
            $update_stmt->bind_param($update_types, ...$update_values);
            $update_stmt->execute();
            $update_stmt->close();

logActivity($conn, 'customer_update', "Customer updated for branch {$branch_id}: {$name} (Phone: {$phone}, Alt: {$alternate_phone})", $customer_id, 'customers');
            return $customer_id;
        }
        $stmt->close();

// Create new customer
        $insert_fields = ["customer_name", "customer_phone", "customer_email", "customer_address", "branch_id", "created_at"];
        $insert_placeholders = ["?", "?", "?", "?", "?", "NOW()"];
        $insert_types = "ssssi";
        $insert_values = [$name, $phone, $email, $address, $branch_id];
        
        if ($alternate_phone_exists) {
            $insert_fields[] = "customer_phone_alternate";
            $insert_placeholders[] = "?";
            $insert_types .= "s";
            $insert_values[] = $alternate_phone;
        }
        
        if ($photo_column_exists && $photo_path) {
            $insert_fields[] = "photo";
            $insert_placeholders[] = "?";
            $insert_types .= "s";
            $insert_values[] = $photo_path;
        }
        
        if ($customer_photo_column_exists && $photo_path) {
            $insert_fields[] = "customer_photo";
            $insert_placeholders[] = "?";
            $insert_types .= "s";
            $insert_values[] = $photo_path;
        }
        
        $insert_query = "INSERT INTO customers (" . implode(", ", $insert_fields) . ") VALUES (" . implode(", ", $insert_placeholders) . ")";
        $insert_stmt = $conn->prepare($insert_query);
        $insert_stmt->bind_param($insert_types, ...$insert_values);
        $insert_stmt->execute();
        $customer_id = $conn->insert_id;
        $insert_stmt->close();

logActivity($conn, 'customer_create', "New customer created for branch {$branch_id}: {$name} (Phone: {$phone}, Alt: {$alternate_phone})", $customer_id, 'customers');
        return $customer_id;
    } else {
        // Old logic without branch_id column
        $stmt = $conn->prepare("SELECT id FROM customers WHERE customer_phone = ? LIMIT 1");
        $stmt->bind_param("s", $phone);
        $stmt->execute();
        $res = $stmt->get_result();
        
        if ($res && $res->num_rows > 0) {
            $row = $res->fetch_assoc();
            $customer_id = intval($row['id']);
            $stmt->close();

// Update customer with photo if available
            $update_fields = ["customer_name = ?", "customer_email = ?", "customer_address = ?", "updated_at = NOW()"];
            $update_types = "sss";
            $update_values = [$name, $email, $address];
            
            if ($alternate_phone_exists) {
                $update_fields[] = "customer_phone_alternate = ?";
                $update_types .= "s";
                $update_values[] = $alternate_phone;
            }
            
            if ($photo_column_exists && $photo_path) {
                $update_fields[] = "photo = ?";
                $update_types .= "s";
                $update_values[] = $photo_path;
            }
            
            if ($customer_photo_column_exists && $photo_path) {
                $update_fields[] = "customer_photo = ?";
                $update_types .= "s";
                $update_values[] = $photo_path;
            }
            
            $update_values[] = $customer_id;
            $update_types .= "i";
            
            $update_query = "UPDATE customers SET " . implode(", ", $update_fields) . " WHERE id = ?";
            $update_stmt = $conn->prepare($update_query);
            $update_stmt->bind_param($update_types, ...$update_values);
            $update_stmt->execute();
            $update_stmt->close();

logActivity($conn, 'customer_update', "Customer information updated: {$name} (Phone: {$phone}, Alt: {$alternate_phone})", $customer_id, 'customers');
            return $customer_id;
        }
        $stmt->close();

// Create new customer without branch_id
        $insert_fields = ["customer_name", "customer_phone", "customer_email", "customer_address", "created_at"];
        $insert_placeholders = ["?", "?", "?", "?", "NOW()"];
        $insert_types = "ssss";
        $insert_values = [$name, $phone, $email, $address];
        
        if ($alternate_phone_exists) {
            $insert_fields[] = "customer_phone_alternate";
            $insert_placeholders[] = "?";
            $insert_types .= "s";
            $insert_values[] = $alternate_phone;
        }
        
        if ($photo_column_exists && $photo_path) {
            $insert_fields[] = "photo";
            $insert_placeholders[] = "?";
            $insert_types .= "s";
            $insert_values[] = $photo_path;
        }
        
        if ($customer_photo_column_exists && $photo_path) {
            $insert_fields[] = "customer_photo";
            $insert_placeholders[] = "?";
            $insert_types .= "s";
            $insert_values[] = $photo_path;
        }
        
        $insert_query = "INSERT INTO customers (" . implode(", ", $insert_fields) . ") VALUES (" . implode(", ", $insert_placeholders) . ")";
        $insert_stmt = $conn->prepare($insert_query);
        $insert_stmt->bind_param($insert_types, ...$insert_values);
        $insert_stmt->execute();
        $customer_id = $conn->insert_id;
        $insert_stmt->close();

logActivity($conn, 'customer_create', "New customer created: {$name} (Phone: {$phone}, Alt: {$alternate_phone})", $customer_id, 'customers');
        return $customer_id;
    }
}

/**
 * Handle photo upload
 */
function handlePhotoUpload($file_field_name) {
    if (!isset($_FILES[$file_field_name]) || $_FILES[$file_field_name]['error'] !== UPLOAD_ERR_OK) {
        return null;
    }
    
    $file = $_FILES[$file_field_name];
    
    // Check file size (max 5MB)
    if ($file['size'] > 5 * 1024 * 1024) {
        return null;
    }
    
    // Check file type
    $allowed_types = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
    $file_type = mime_content_type($file['tmp_name']);
    
    if (!in_array($file_type, $allowed_types)) {
        return null;
    }
    
    // Create upload directory if it doesn't exist
    $upload_dir = 'uploads/customer_photos/';
    if (!file_exists($upload_dir)) {
        mkdir($upload_dir, 0777, true);
    }
    
    // Generate unique filename
    $file_extension = pathinfo($file['name'], PATHINFO_EXTENSION);
    $unique_filename = 'customer_' . uniqid() . '_' . time() . '.' . $file_extension;
    $destination = $upload_dir . $unique_filename;
    
    // Move uploaded file
    if (move_uploaded_file($file['tmp_name'], $destination)) {
        return $destination;
    }
    
    return null;
}

/**
 * Product GST helper functions
 */
function getProductGstSettings($conn, $product_id) {
    $sql = "SELECT gst_applicable, gst_percentage FROM product_gst_settings WHERE product_id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $product_id);
    $stmt->execute();
    $res = $stmt->get_result();
    if ($res && $res->num_rows > 0) {
        return $res->fetch_assoc();
    }
    return ['gst_applicable' => 0, 'gst_percentage' => 18.00];
}

function calculateGstFromInclusive($inclusive_price, $gst_percentage, $gst_applicable) {
    if (!$gst_applicable || $gst_percentage <= 0) {
        return [
            'base_price' => $inclusive_price,
            'gst_amount' => 0,
            'total_price' => $inclusive_price
        ];
    }
    
    $base_price = $inclusive_price / (1 + ($gst_percentage / 100));
    $gst_amount = $inclusive_price - $base_price;
    
    return [
        'base_price' => round($base_price, 2),
        'gst_amount' => round($gst_amount, 2),
        'total_price' => $inclusive_price
    ];
}

/* ------------------------------
   Handle new sale submission
   ------------------------------ */
$alert_message = '';

if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['create_sale'])) {
    // Handle photo upload first
    $photo_path = handlePhotoUpload('customer_photo');
    
    // sanitize inputs
    $customer_name = isset($_POST['customer_name']) ? $conn->real_escape_string($_POST['customer_name']) : '';
    $customer_phone = isset($_POST['customer_phone']) ? $conn->real_escape_string($_POST['customer_phone']) : '';
    $customer_phone_alternate = isset($_POST['customer_phone_alternate']) ? $conn->real_escape_string($_POST['customer_phone_alternate']) : '';
    $customer_email = isset($_POST['customer_email']) ? $conn->real_escape_string($_POST['customer_email']) : '';
    $customer_address = isset($_POST['customer_address']) ? $conn->real_escape_string($_POST['customer_address']) : '';

$sale_date = isset($_POST['sale_date']) ? $conn->real_escape_string($_POST['sale_date']) : date('Y-m-d H:i:s');
    $payment_type = isset($_POST['payment_type']) ? $conn->real_escape_string($_POST['payment_type']) : 'cash';
    $payment_status = isset($_POST['payment_status']) ? $conn->real_escape_string($_POST['payment_status']) : 'pending';
    $total_amount = isset($_POST['total_amount']) ? floatval($_POST['total_amount']) : 0;
    $paid_amount = isset($_POST['paid_amount']) ? floatval($_POST['paid_amount']) : 0;
    $due_amount = isset($_POST['due_amount']) ? floatval($_POST['due_amount']) : 0;
    $notes = isset($_POST['notes']) ? $conn->real_escape_string($_POST['notes']) : '';

$finance_partner = isset($_POST['finance_partner']) ? $conn->real_escape_string($_POST['finance_partner']) : '';
    $credit_due_date = isset($_POST['credit_due_date']) ? $conn->real_escape_string($_POST['credit_due_date']) : '';
    $credit_terms = isset($_POST['credit_terms']) ? $conn->real_escape_string($_POST['credit_terms']) : '';
    
    // EMI details (simplified)
    $emi_due_date = isset($_POST['emi_due_date']) ? $conn->real_escape_string($_POST['emi_due_date']) : '';

// GST fields
    $subtotal_amount = isset($_POST['subtotal_amount']) ? floatval($_POST['subtotal_amount']) : 0;
    $total_gst_amount = isset($_POST['total_gst_amount']) ? floatval($_POST['total_gst_amount']) : 0;
    $gst_breakdown = isset($_POST['gst_breakdown']) ? $conn->real_escape_string($_POST['gst_breakdown']) : '';

// Begin transaction
    $conn->begin_transaction();

try {
        // Find or create customer for this branch
        $customer_data = [
            'name' => $customer_name,
            'phone' => $customer_phone,
            'alternate_phone' => $customer_phone_alternate,
            'email' => $customer_email,
            'address' => $customer_address,
            'photo_path' => $photo_path
        ];
        $customer_id = findOrCreateCustomer($conn, $customer_data, $branch_id);

// Generate 7-digit sequential invoice number for this branch
        $invoice_query = "SELECT COUNT(*) as sale_count FROM sales WHERE branch_id = $branch_id";
        $invoice_result = $conn->query($invoice_query);
        $invoice_row = $invoice_result->fetch_assoc();
        $next_invoice_number = $invoice_row['sale_count'] + 1;
        
        // Format as 7-digit number (e.g., 0000123)
        $formatted_invoice_number = str_pad($next_invoice_number, 7, '0', STR_PAD_LEFT);
        
        // Get branch code
        $branch_code = !empty($branch_info['branch_code']) ? $branch_info['branch_code'] : str_pad($branch_id, 3, '0', STR_PAD_LEFT);
        
        // Create TWO identifiers:
        // 1. sale_number - keeps existing format for backward compatibility
        $sale_number = 'SALE-' . date('Ymd-His') . '-' . $branch_id;
        // 2. invoice_number - 7-digit format for display
        $invoice_number = $branch_code . '-' . $formatted_invoice_number;

// Handle finance partner correctly
        $finance_partner_value = '';
        $payment_type_value = $payment_type; // Keep original payment type

if ($payment_type == 'emi' && !empty($finance_partner)) {
            // For EMI, store the finance partner name directly
            $finance_partner_value = $finance_partner;
        } elseif ($payment_type == 'TVS' || $payment_type == 'Bajaj') {
            // For TVS/Bajaj, we still store the payment_type as TVS/Bajaj
            // But also store finance partner info in notes and finance_partner field
            if (!empty($notes)) {
                $notes .= "\nFinance Partner: " . strtoupper($payment_type);
            } else {
                $notes = "Finance Partner: " . strtoupper($payment_type);
            }
            $finance_partner_value = strtoupper($payment_type);
        }

// Insert sale (branch_id included) - Simplified EMI columns
        $sale_sql = "INSERT INTO sales (
            sale_number, invoice_number, customer_id, customer_name, customer_phone, customer_email, customer_address,
            sale_date, payment_type, payment_status, total_amount, paid_amount, due_amount,
            finance_partner, credit_due_date, credit_terms, notes, status,
            subtotal_amount, total_gst_amount, gst_breakdown, branch_id, created_at,
            emi_due_date
        ) VALUES (
            '{$conn->real_escape_string($sale_number)}', 
            '{$conn->real_escape_string($invoice_number)}', 
            {$customer_id}, 
            '{$conn->real_escape_string($customer_name)}', 
            '{$conn->real_escape_string($customer_phone)}', 
            '{$conn->real_escape_string($customer_email)}', 
            '{$conn->real_escape_string($customer_address)}',
            '{$conn->real_escape_string($sale_date)}', 
            '{$conn->real_escape_string($payment_type)}', 
            '{$conn->real_escape_string($payment_status)}', 
            {$total_amount}, 
            {$paid_amount}, 
            {$due_amount},
            '{$conn->real_escape_string($finance_partner_value)}', 
            '{$conn->real_escape_string($credit_due_date)}', 
            '{$conn->real_escape_string($credit_terms)}', 
            '{$conn->real_escape_string($notes)}', 
            'completed',
            {$subtotal_amount}, 
            {$total_gst_amount}, 
            '{$conn->real_escape_string($gst_breakdown)}', 
            {$branch_id}, 
            NOW(),
            '{$conn->real_escape_string($emi_due_date)}'
        )";

if ($conn->query($sale_sql) === FALSE) {
            throw new Exception("Insert sale failed: " . $conn->error);
        }
        $sale_id = $conn->insert_id;

// Insert sale items & update product stock
        $sale_items_has_branch = columnExists($conn, 'sale_items', 'branch_id');

if (isset($_POST['product_id']) && is_array($_POST['product_id'])) {
            foreach ($_POST['product_id'] as $index => $product_id_raw) {
                $product_id = intval($product_id_raw);
                $quantity = isset($_POST['quantity'][$index]) ? intval($_POST['quantity'][$index]) : 1;
                
                // Get IMEI/serial numbers from product data
                $imei_numbers_1 = isset($_POST['imei_number_1'][$index]) && is_array($_POST['imei_number_1'][$index]) ? 
                                $_POST['imei_number_1'][$index] : [];
                $imei_numbers_2 = isset($_POST['imei_number_2'][$index]) && is_array($_POST['imei_number_2'][$index]) ? 
                                $_POST['imei_number_2'][$index] : [];
                $serial_numbers = isset($_POST['serial_number'][$index]) && is_array($_POST['serial_number'][$index]) ? 
                                $_POST['serial_number'][$index] : [];

// Verify product belongs to this branch
                $verify_sql = "SELECT p.* FROM products p WHERE p.id = {$product_id} AND p.branch_id = {$branch_id} LIMIT 1";
                $verify_result = $conn->query($verify_sql);
                if (!$verify_result || $verify_result->num_rows == 0) {
                    throw new Exception("Product ID {$product_id} does not belong to your branch or does not exist.");
                }
                $product = $verify_result->fetch_assoc();

// Stock check
                $stock_quantity = isset($product['stock_quantity']) ? intval($product['stock_quantity']) : 0;
                if ($stock_quantity < $quantity) {
                    $product_name = isset($product['product_name']) ? $product['product_name'] : 'Unknown';
                    throw new Exception("Insufficient stock for {$product_name}. Available: {$stock_quantity}, Requested: {$quantity}");
                }

// GST calculation from inclusive price
                $gst_settings = getProductGstSettings($conn, $product_id);
                $gst_applicable = isset($gst_settings['gst_applicable']) ? intval($gst_settings['gst_applicable']) : 0;
                $gst_percentage = isset($gst_settings['gst_percentage']) ? floatval($gst_settings['gst_percentage']) : 18.00;
                
                $selling_price = isset($product['selling_price']) ? floatval($product['selling_price']) : 0;
                $item_total = $quantity * $selling_price;
                $price_calc = calculateGstFromInclusive($item_total, $gst_percentage, $gst_applicable);
                
                $base_price = $price_calc['base_price'];
                $gst_amount = $price_calc['gst_amount'];
                $item_total_with_gst = $price_calc['total_price'];

// For each unit, create separate sale item with IMEI/serial
                for ($i = 0; $i < $quantity; $i++) {
                    // Calculate price per unit
                    $unit_base_price = $base_price / $quantity;
                    $unit_gst_amount = $gst_amount / $quantity;
                    $unit_total_with_gst = $selling_price;

// Get IMEI/serial data if available
                    $imei1 = isset($imei_numbers_1[$i]) && !empty($imei_numbers_1[$i]) ? 
                            "'" . $conn->real_escape_string($imei_numbers_1[$i]) . "'" : "NULL";
                    $imei2 = isset($imei_numbers_2[$i]) && !empty($imei_numbers_2[$i]) ? 
                            "'" . $conn->real_escape_string($imei_numbers_2[$i]) . "'" : "NULL";
                    $serial = isset($serial_numbers[$i]) && !empty($serial_numbers[$i]) ? 
                            "'" . $conn->real_escape_string($serial_numbers[$i]) . "'" : "NULL";
                    
                    // Build dynamic INSERT query
                    $columns = ['sale_id', 'product_id', 'quantity', 'unit_price', 'total_price', 
                               'gst_applicable', 'gst_percentage', 'gst_amount', 'total_price_with_gst'];
                    $values = [$sale_id, $product_id, 1, $selling_price, $unit_total_with_gst,
                              $gst_applicable, $gst_percentage, $unit_gst_amount, $unit_total_with_gst];

// Add base_price if column exists
                    if ($base_price_exists) {
                        $columns[] = 'base_price';
                        $values[] = $unit_base_price;
                    }

// Add IMEI/serial columns if they exist
                    if ($imei_1_exists) {
                        $columns[] = 'imei_number_1';
                        $values[] = $imei1;
                    }
                    
                    if ($imei_2_exists) {
                        $columns[] = 'imei_number_2';
                        $values[] = $imei2;
                    }
                    
                    if ($serial_exists) {
                        $columns[] = 'serial_number';
                        $values[] = $serial;
                    }

// Add branch_id if column exists
                    if ($sale_items_has_branch) {
                        $columns[] = 'branch_id';
                        $values[] = $branch_id;
                    }

// Add created_at
                    $columns[] = 'created_at';
                    $values[] = 'NOW()';

// Build and execute insert query
                    $columns_str = implode(', ', $columns);
                    $values_str = implode(', ', $values);
                    
                    $item_sql = "INSERT INTO sale_items ({$columns_str}) VALUES ({$values_str})";
                    
                    if ($conn->query($item_sql) === FALSE) {
                        throw new Exception("Insert sale item failed: " . $conn->error . " SQL: " . $item_sql);
                    }
                }

// Update product stock for this branch
                $update_stock_sql = "UPDATE products SET stock_quantity = stock_quantity - {$quantity} WHERE id = {$product_id} AND branch_id = {$branch_id}";
                if ($conn->query($update_stock_sql) === FALSE) {
                    throw new Exception("Update product stock failed: " . $conn->error);
                }

$product_name = isset($product['product_name']) ? $product['product_name'] : 'Unknown';
                logActivity($conn, 'stock_update', "Stock reduced for {$product_name} (Quantity: {$quantity}, Sale: {$sale_number})", $product_id, 'products');
            }
        }

// Update customer purchase statistics
        if (columnExists($conn, 'customers', 'branch_id')) {
            $update_customer_sql = "UPDATE customers SET 
                total_purchases = COALESCE(total_purchases,0) + {$total_amount},
                total_paid = COALESCE(total_paid,0) + {$paid_amount},
                outstanding_balance = COALESCE(outstanding_balance,0) + {$due_amount},
                updated_at = NOW()
                WHERE id = {$customer_id} AND branch_id = {$branch_id}";
        } else {
            $update_customer_sql = "UPDATE customers SET 
                total_purchases = COALESCE(total_purchases,0) + {$total_amount},
                total_paid = COALESCE(total_paid,0) + {$paid_amount},
                outstanding_balance = COALESCE(outstanding_balance,0) + {$due_amount},
                updated_at = NOW()
                WHERE id = {$customer_id}";
        }
        if ($conn->query($update_customer_sql) === FALSE) {
            throw new Exception("Update customer stats failed: " . $conn->error);
        }

// Create credit payment record if needed
        if (($payment_status == 'partial' || $payment_type == 'credit' || $payment_type == 'emi' || $payment_type == 'TVS' || $payment_type == 'Bajaj') && $due_amount > 0) {
            // Use EMI due date if payment type is EMI, otherwise use credit due date
            $due_date_for_record = ($payment_type == 'emi' && !empty($emi_due_date)) ? $emi_due_date : $credit_due_date;
            
            // Add finance partner info to credit terms if EMI or TVS/Bajaj
            $terms_for_record = $credit_terms;
            if ($payment_type == 'emi' && !empty($finance_partner)) {
                $emi_terms = "Finance Partner: {$finance_partner}";
                $terms_for_record = !empty($credit_terms) ? $credit_terms . "\n\n" . $emi_terms : $emi_terms;
            } elseif ($payment_type == 'TVS' || $payment_type == 'Bajaj') {
                $finance_terms = "Finance Partner: " . strtoupper($payment_type);
                $terms_for_record = !empty($credit_terms) ? $credit_terms . "\n\n" . $finance_terms : $finance_terms;
            }
            
            if (columnExists($conn, 'credit_payments', 'branch_id')) {
                $credit_sql = "INSERT INTO credit_payments (
                    sale_id, customer_id, due_amount, paid_amount, remaining_amount, due_date, status, terms, branch_id, created_at
                ) VALUES (
                    {$sale_id}, {$customer_id}, {$due_amount}, {$paid_amount}, {$due_amount}, '{$conn->real_escape_string($due_date_for_record)}', 'pending', '{$conn->real_escape_string($terms_for_record)}', {$branch_id}, NOW()
                )";
            } else {
                $credit_sql = "INSERT INTO credit_payments (
                    sale_id, customer_id, due_amount, paid_amount, remaining_amount, due_date, status, terms, created_at
                ) VALUES (
                    {$sale_id}, {$customer_id}, {$due_amount}, {$paid_amount}, {$due_amount}, '{$conn->real_escape_string($due_date_for_record)}', 'pending', '{$conn->real_escape_string($terms_for_record)}', NOW()
                )";
            }
            if ($conn->query($credit_sql) === FALSE) {
                throw new Exception("Insert credit payment failed: " . $conn->error);
            }
            $credit_payment_id = $conn->insert_id;

// If initial payment present, add transaction record
            if ($paid_amount > 0) {
                if (columnExists($conn, 'credit_payment_transactions', 'branch_id')) {
                    $transaction_sql = "INSERT INTO credit_payment_transactions (
                        credit_payment_id, customer_id, amount_paid, payment_method, payment_date, reference_number, notes, branch_id, created_at
                    ) VALUES (
                        {$credit_payment_id}, {$customer_id}, {$paid_amount}, '{$conn->real_escape_string($payment_type)}', '{$conn->real_escape_string($sale_date)}', 'INITIAL', 'Initial payment for sale {$sale_number}', {$branch_id}, NOW()
                    )";
                } else {
                    $transaction_sql = "INSERT INTO credit_payment_transactions (
                        credit_payment_id, customer_id, amount_paid, payment_method, payment_date, reference_number, notes, created_at
                    ) VALUES (
                        {$credit_payment_id}, {$customer_id}, {$paid_amount}, '{$conn->real_escape_string($payment_type)}', '{$conn->real_escape_string($sale_date)}', 'INITIAL', 'Initial payment for sale {$sale_number}', NOW()
                    )";
                }
                if ($conn->query($transaction_sql) === FALSE) {
                    throw new Exception("Insert credit transaction failed: " . $conn->error);
                }
            }
        }

// Log sale
        $finance_info = "";
        if ($payment_type == 'emi' && $finance_partner) {
            $finance_info = " (Finance: {$finance_partner})";
        } elseif ($payment_type == 'TVS' || $payment_type == 'Bajaj') {
            $finance_info = " (Finance: " . strtoupper($payment_type) . ")";
        }
        
        logActivity($conn, 'sale', "New sale created: {$sale_number} (Invoice: {$invoice_number}) for {$customer_name} (Amount: ₹{$total_amount}, Paid: ₹{$paid_amount}, GST: ₹{$total_gst_amount}) by branch {$branch_id}{$finance_info}", $sale_id, 'sales');

// Commit
        $conn->commit();

// Success message with receipt link - SHOW 7-DIGIT INVOICE NUMBER
        $alert_message = '<div class="alert alert-success alert-dismissible fade show" role="alert">
                <i class="fas fa-check-circle me-2"></i>
                <strong>Sale Completed Successfully!</strong><br>
                Invoice Number: <strong>' . htmlspecialchars($invoice_number) . '</strong><br>
                Sale Reference: <small>' . htmlspecialchars($sale_number) . '</small><br>
                Branch: <strong>' . htmlspecialchars($branch_info['branch_name']) . '</strong><br>
                Total Amount: <strong>₹' . number_format($total_amount, 2) . '</strong>';

if ($total_gst_amount > 0) {
            $alert_message .= '<br>GST Amount: <strong>₹' . number_format($total_gst_amount, 2) . '</strong>';
        }
        if ($due_amount > 0) {
            $alert_message .= '<br>Due Amount: <strong>₹' . number_format($due_amount, 2) . '</strong>';
        }
        if ($payment_type == 'emi' && $finance_partner) {
            $alert_message .= '<br>Finance Partner: <strong>' . htmlspecialchars($finance_partner) . '</strong>';
        } elseif ($payment_type == 'TVS' || $payment_type == 'Bajaj') {
            $alert_message .= '<br>Finance Partner: <strong>' . strtoupper($payment_type) . '</strong>';
        }

$alert_message .= '<div class="mt-2">';
        if ($due_amount > 0) {
            $alert_message .= '<a href="credit-payments.php?customer_id=' . $customer_id . '" class="btn btn-sm btn-outline-warning me-2">Manage Credit</a>';
        }
        $alert_message .= '<a href="sales-receipt.php?id=' . $sale_id . '" class="btn btn-sm btn-outline-primary me-2" target="_blank"><i class="fas fa-receipt me-1"></i>View Receipt</a>
                          <a href="sales-new.php" class="btn btn-sm btn-outline-info">New Sale</a>
                          </div>
                          <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                        </div>';

} catch (Exception $e) {
        $conn->rollback();
        $alert_message = '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                <i class="fas fa-exclamation-triangle me-2"></i>
                Error creating sale: ' . htmlspecialchars($e->getMessage()) . '
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
              </div>';
    }
}

/* ------------------------------
   Build product catalog (current branch only)
   ------------------------------ */
$products_array = [];
$products_sql = "SELECT p.*, b.brand_name,
                        COALESCE(g.gst_applicable, 0) as gst_applicable,
                        COALESCE(g.gst_percentage, 18) as gst_percentage
                FROM products p 
                LEFT JOIN brands b ON p.brand_id = b.id 
                LEFT JOIN product_gst_settings g ON p.id = g.product_id
                WHERE p.status = 'active' AND p.branch_id = $branch_id
                ORDER BY p.product_name, p.id";
$products_result = $conn->query($products_sql);

if ($products_result) {
    while ($product = $products_result->fetch_assoc()) {
        $selling_price = isset($product['selling_price']) ? floatval($product['selling_price']) : 0;
        $gst_applicable = isset($product['gst_applicable']) ? intval($product['gst_applicable']) : 0;
        $gst_percentage = isset($product['gst_percentage']) ? floatval($product['gst_percentage']) : 0;
        
        // Automatically calculate base price and GST amount
        $price_calc = calculateGstFromInclusive($selling_price, $gst_percentage, $gst_applicable);
        $base_price = $price_calc['base_price'];
        $gst_amount = $price_calc['gst_amount'];
        
        // Determine product type based on what's stored
        $product_type = 'none';
        $imei_number_1 = isset($product['imei_number_1']) ? $product['imei_number_1'] : '';
        $imei_number_2 = isset($product['imei_number_2']) ? $product['imei_number_2'] : '';
        $serial_number = isset($product['serial_number']) ? $product['serial_number'] : '';
        
        if (!empty($imei_number_1) || !empty($imei_number_2)) {
            if (!empty($serial_number)) {
                $product_type = 'both';
            } else {
                $product_type = 'imei';
            }
        } elseif (!empty($serial_number)) {
            $product_type = 'serial';
        }
        
        // Build IMEI/serial display text
        $imei_display = '';
        if ($product_type === 'imei') {
            $imei1 = !empty($imei_number_1) ? $imei_number_1 : '';
            $imei2 = !empty($imei_number_2) ? $imei_number_2 : '';
            $imei_display = '<div class="imei-display"><small class="imei-display-label">IMEI 1:</small> <span class="imei-value">' . htmlspecialchars($imei1) . '</span></div>';
            if ($imei2) {
                $imei_display .= '<div class="imei-display"><small class="imei-display-label">IMEI 2:</small> <span class="imei-value">' . htmlspecialchars($imei2) . '</span></div>';
            }
        } elseif ($product_type === 'serial') {
            $serial = !empty($serial_number) ? $serial_number : '';
            $imei_display = '<div class="imei-display"><small class="imei-display-label">Serial:</small> <span class="imei-value">' . htmlspecialchars($serial) . '</span></div>';
        } elseif ($product_type === 'both') {
            $imei1 = !empty($imei_number_1) ? $imei_number_1 : '';
            $imei2 = !empty($imei_number_2) ? $imei_number_2 : '';
            $serial = !empty($serial_number) ? $serial_number : '';
            $imei_display = '<div class="imei-display"><small class="imei-display-label">IMEI 1:</small> <span class="imei-value">' . htmlspecialchars($imei1) . '</span></div>';
            if ($imei2) {
                $imei_display .= '<div class="imei-display"><small class="imei-display-label">IMEI 2:</small> <span class="imei-value">' . htmlspecialchars($imei2) . '</span></div>';
            }
            $imei_display .= '<div class="imei-display"><small class="imei-display-label">Serial:</small> <span class="imei-value">' . htmlspecialchars($serial) . '</span></div>';
        }
        
        // Get the actual barcode from products table
        $actual_barcode = isset($product['barcode']) ? $product['barcode'] : '';
        // Generate barcode number if not exists
        $barcode_number = $actual_barcode ? $actual_barcode : "PID" . str_pad($product['id'], 6, '0', STR_PAD_LEFT);
        
        // For display text
        $brand_name = isset($product['brand_name']) ? $product['brand_name'] : '';
        $model = isset($product['model']) ? $product['model'] : '';
        $product_name = isset($product['product_name']) ? $product['product_name'] : '';
        
        $display_text = $product_name . ' - ' . $brand_name . ' ' . $model . ' (₹' . number_format($selling_price, 2) . ')';
        if ($gst_applicable) {
            $display_text .= ' [Incl. ' . $gst_percentage . '% GST: ₹' . number_format($gst_amount, 2) . ']';
        }
        
        $products_array[] = [
            'id' => isset($product['id']) ? intval($product['id']) : 0,
            'name' => $product_name,
            'brand' => $brand_name,
            'model' => $model,
            'price' => floatval($selling_price),
            'base_price' => floatval($base_price),
            'gst_amount_per_unit' => floatval($gst_amount),
            'stock' => isset($product['stock_quantity']) ? intval($product['stock_quantity']) : 0,
            'gst_applicable' => $gst_applicable,
            'gst_percentage' => $gst_percentage,
            'product_type' => $product_type,
            'imei_number_1' => $imei_number_1,
            'imei_number_2' => $imei_number_2,
            'serial_number' => $serial_number,
            'barcode' => $actual_barcode,
            'generated_barcode' => $barcode_number,
            'imei_display' => $imei_display,
            'text' => $display_text,
            'price_breakdown' => [
                'base' => $base_price,
                'gst' => $gst_amount,
                'total' => $selling_price
            ]
        ];
    }
}
?>
<!doctype html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    <title>Create Sale | <?php echo htmlspecialchars($branch_info['branch_name']); ?></title>
    
    <script src="https://unpkg.com/html5-qrcode@2.3.8/html5-qrcode.min.js" type="text/javascript"></script>
    <style>
        /* ... (keep all existing styles but remove EMI-specific styles) ... */
        .emi-date-picker { position: relative; }
        .emi-date-picker input { padding-right: 40px; }
        .emi-date-picker .calendar-icon { position: absolute; right: 10px; top: 50%; transform: translateY(-50%); color: #6c757d; pointer-events: none; }
        .emi-warning { background-color: #fff3cd; border: 1px solid #ffc107; border-radius: 5px; padding: 10px; margin-top: 10px; }
        .emi-warning i { color: #ffc107; }
        .finance-select { background-color: #fff; border: 1px solid #ced4da; border-radius: 4px; padding: 8px; }
        .invoice-preview { font-size: 12px; padding: 5px 10px; background: #e8f5e9; border-left: 4px solid #4caf50; }
    </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="branch-info">
                    <div class="row align-items-center">
                        <div class="col-md-8">
                            <h4 class="mb-1">
                                <i class="fas fa-store-alt me-2"></i>
                                <?php echo htmlspecialchars($branch_info['branch_name']); ?>
                                <span class="badge bg-light text-dark"><?php echo htmlspecialchars($branch_info['branch_code']); ?></span>
                            </h4>
                            <p class="mb-0">
                                <i class="fas fa-cash-register me-1"></i>Creating sale for your branch only
                                <span class="badge bg-info inclusive-badge">Prices are inclusive of GST</span>
                                <span class="badge bg-success inclusive-badge">Auto-Calculated GST</span>
                                <span class="badge bg-warning inclusive-badge">Smart Product Search</span>
                                <span class="badge bg-primary inclusive-badge">Barcode Scanner Ready</span>
                                <span class="badge bg-danger inclusive-badge">7-Digit Invoice</span>
                            </p>
                        </div>
                        <div class="col-md-4 text-end">
                            <span class="badge bg-white text-primary px-3 py-2"><i class="fas fa-search me-1"></i>Universal Search</span>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <h5 class="card-title mb-0"><i class="fas fa-cash-register me-2"></i>Create New Sale - <?php echo htmlspecialchars($branch_info['branch_name']); ?></h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <a href="sales-new.php" class="btn btn-outline-secondary btn-smaller"><i class="fas fa-arrow-left me-1"></i>Back to Sales</a>
                                        <a href="customers-manage.php" class="btn btn-outline-primary btn-smaller"><i class="fas fa-users me-1"></i>My Customers</a>
                                        <a href="products-manage.php" class="btn btn-outline-info btn-smaller"><i class="fas fa-box me-1"></i>My Products</a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">
                                <?php if (!empty($alert_message)): ?>
                                    <div class="mb-4"><?php echo $alert_message; ?></div>
                                <?php endif; ?>

<form method="POST" action="" id="saleForm" enctype="multipart/form-data">
                                    <input type="hidden" id="subtotal_amount" name="subtotal_amount" value="0">
                                    <input type="hidden" id="total_gst_amount" name="total_gst_amount" value="0">
                                    <input type="hidden" id="gst_breakdown" name="gst_breakdown" value="">
                                    
                                    <div class="row">
                                        
                                        <div class="col-md-6">
                                            <div class="card mb-4">
                                                <div class="card-header">
                                                    <h6 class="card-title mb-0">
                                                        <i class="fas fa-user me-2"></i>Customer Information
                                                    </h6>
                                                </div>
                                                <div class="card-body">
                                                    <div class="row">
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="customer_name" class="form-label">Customer Name <span class="text-danger">*</span></label>
                                                                <input type="text" class="form-control" id="customer_name" name="customer_name" required>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="customer_phone" class="form-label">Mobile Number <span class="text-danger">*</span></label>
                                                                <input type="text" class="form-control" id="customer_phone" name="customer_phone" required maxlength="10" pattern="[0-9]{10}" title="Enter 10-digit mobile number">
                                                                <div class="form-text" id="customerInfo"></div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="row">
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="customer_phone_alternate" class="form-label">Alternate Mobile Number</label>
                                                                <input type="text" class="form-control" id="customer_phone_alternate" name="customer_phone_alternate" maxlength="10" pattern="[0-9]{10}" title="Enter 10-digit mobile number">
                                                                <div class="form-text">Optional second contact number</div>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="customer_email" class="form-label">Email Address</label>
                                                                <input type="email" class="form-control" id="customer_email" name="customer_email">
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="mb-3">
                                                        <label for="customer_address" class="form-label">Address</label>
                                                        <textarea class="form-control" id="customer_address" name="customer_address" rows="3"></textarea>
                                                    </div>
                                                    
                                                    
                                                    <div class="customer-photo-section">
                                                        <div class="mb-3">
                                                            <label for="customer_photo" class="form-label">Customer Photo</label>
                                                            <input type="file" class="form-control" id="customer_photo" name="customer_photo" accept="image/*">
                                                            <div class="form-text">Optional: Upload customer photo (Max 5MB, JPG/PNG/GIF)</div>
                                                        </div>
                                                        <div class="photo-preview-container" id="photoPreviewContainer" style="display: none;">
                                                            <img id="photoPreview" class="customer-photo-preview" src="" alt="Photo Preview">
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>

<div class="col-md-6">
                                            <div class="card mb-4">
                                                <div class="card-header">
                                                    <h6 class="card-title mb-0">
                                                        <i class="fas fa-info-circle me-2"></i>Sale Information
                                                    </h6>
                                                </div>
                                                <div class="card-body">
                                                    <div class="row">
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="sale_date" class="form-label">Sale Date <span class="text-danger">*</span></label>
                                                                <input type="datetime-local" class="form-control" id="sale_date" name="sale_date" value="<?php echo date('Y-m-d\TH:i'); ?>" required>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="payment_type" class="form-label">Payment Type <span class="text-danger">*</span></label>
                                                                <select class="form-select" id="payment_type" name="payment_type" required>
                                                                    <option value="upi">UPI</option>
                                                                    <option value="cash">Cash</option>
                                                                    <option value="card">Card</option>
                                                                    <option value="TVS">TVS Finance</option>
                                                                    <option value="Bajaj">Bajaj Finance</option>
                                                                    <option value="emi">EMI</option>
                                                                    <option value="credit">Credit</option>
                                                                    <option value="bank_transfer">Bank Transfer</option>
                                                                </select>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    
                                                    
                                                    <div class="row" id="financePartnerSection" style="display: none;">
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="finance_partner" class="form-label">Finance Partner <span class="text-danger">*</span></label>
                                                                <select class="form-select finance-select" id="finance_partner" name="finance_partner">
                                                                    <option value="">Select Finance Partner</option>
                                                                    <?php if (count($finance_options) > 0): ?>
                                                                        <?php foreach ($finance_options as $finance_name): ?>
                                                                            <option value="<?php echo htmlspecialchars($finance_name); ?>">
                                                                                <?php echo htmlspecialchars($finance_name); ?>
                                                                            </option>
                                                                        <?php endforeach; ?>
                                                                    <?php else: ?>
                                                                        <option value="">No finance partners available</option>
                                                                    <?php endif; ?>
                                                                    <option value="other">Other (Specify in notes)</option>
                                                                </select>
                                                                <div class="form-text">Select from active finance partners</div>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-6">
                                                            <div class="mb-3 emi-date-picker">
                                                                <label for="emi_due_date" class="form-label">EMI Due Date <span class="text-danger">*</span></label>
                                                                <input type="date" class="form-control" id="emi_due_date" name="emi_due_date" value="<?php echo date('Y-m-d', strtotime('+1 month')); ?>">
                                                                <i class="fas fa-calendar-alt calendar-icon"></i>
                                                                <div class="form-text">Date when first EMI is due</div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    
                                                    
                                                    <div class="emi-warning" id="emiWarningSection" style="display: none;">
                                                        <i class="fas fa-exclamation-triangle me-2"></i>
                                                        <strong>EMI Sale:</strong> Ensure all EMI documents are properly filled and signed by customer.
                                                    </div>
                                                    
                                                    
                                                    <div class="alert alert-info" id="tvsBajajInfoSection" style="display: none;">
                                                        <i class="fas fa-building me-2"></i>
                                                        <strong>Finance Sale:</strong> This transaction will be recorded as finance sale with the partner.
                                                    </div>
                                                    
                                                    <div class="row">
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="payment_status" class="form-label">Payment Status <span class="text-danger">*</span></label>
                                                                <select class="form-select" id="payment_status" name="payment_status" required>
                                                                    <option value="pending">Pending Payment</option>
                                                                    <option value="paid">Full Payment</option>
                                                                    <option value="partial">Partial Payment</option>
                                                                </select>
                                                            </div>
                                                        </div>
                                                        <div class="col-md-6">
                                                            <div class="mb-3">
                                                                <label for="total_amount" class="form-label">Grand Total (Incl. GST) (₹)</label>
                                                                <input type="text" class="form-control" id="total_amount" name="total_amount" readonly value="0">
                                                                <div class="form-text">Automatically calculated from products</div>
                                                            </div>
                                                        </div>
                                                    </div>

<div class="calculation-summary">
                                                        <h6><i class="fas fa-calculator me-2"></i>Automatic Calculation Summary</h6>
                                                        <div class="calc-item">
                                                            <span class="calc-label">Subtotal (Base Amount):</span>
                                                            <span class="calc-value" id="display_subtotal">₹0.00</span>
                                                        </div>
                                                        <div class="calc-item">
                                                            <span class="calc-label">Total GST:</span>
                                                            <span class="calc-value gst-value" id="display_total_gst">₹0.00</span>
                                                        </div>
                                                        <div class="calc-item">
                                                            <span class="calc-label">Grand Total (Incl. GST):</span>
                                                            <span class="calc-value total-value" id="display_grand_total">₹0.00</span>
                                                        </div>
                                                    </div>

<div id="paymentAmountSection">
                                                        <div class="row">
                                                            <div class="col-md-6">
                                                                <div class="mb-3">
                                                                    <label for="paid_amount" class="form-label">Paid Amount (₹) <span class="text-danger">*</span></label>
                                                                    <input type="number" class="form-control" id="paid_amount" name="paid_amount" step="0.01" min="0" value="0" required>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-6">
                                                                <div class="mb-3">
                                                                    <label for="due_amount" class="form-label">Due Amount (₹)</label>
                                                                    <input type="text" class="form-control" id="due_amount" name="due_amount" readonly value="0">
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row" id="creditSection" style="display: none;">
                                        <div class="col-12">
                                            <div class="card mb-4">
                                                <div class="card-header">
                                                    <h6 class="card-title mb-0">
                                                        <i class="fas fa-clock me-2"></i>Credit Payment Details
                                                    </h6>
                                                </div>
                                                <div class="card-body">
                                                    <div class="row">
                                                        <div class="col-md-4">
                                                            <div class="mb-3">
                                                                <label for="credit_due_date" class="form-label">Due Date</label>
                                                                <input type="date" class="form-control" id="credit_due_date" name="credit_due_date" value="<?php echo date('Y-m-d', strtotime('+15 days')); ?>">
                                                            </div>
                                                        </div>
                                                        <div class="col-md-8">
                                                            <div class="mb-3">
                                                                <label for="credit_terms" class="form-label">Credit Terms & Conditions</label>
                                                                <textarea class="form-control" id="credit_terms" name="credit_terms" rows="2" placeholder="Any specific terms for credit payment..."></textarea>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="alert alert-warning">
                                                        <i class="fas fa-exclamation-triangle me-2"></i>
                                                        Ensure to collect the pending amount before the due date. This will be tracked in credit management.
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-12">
                                            <div class="card mb-4">
                                                <div class="card-header">
                                                    <div class="d-flex justify-content-between align-items-center flex-wrap">
                                                        <h6 class="card-title mb-0">
                                                            <i class="fas fa-shopping-cart me-2"></i>
                                                            Products from <?php echo htmlspecialchars($branch_info['branch_name']); ?>
                                                        </h6>
                                                        <div class="d-flex gap-2 flex-wrap">
                                                            <button type="button" class="btn btn-sm btn-outline-primary btn-smaller" id="showBarcodeScanner">
                                                                <i class="fas fa-camera me-1"></i>Scan Barcode
                                                            </button>
                                                            <button type="button" class="btn btn-sm btn-outline-info btn-smaller" id="showBarcodeList">
                                                                <i class="fas fa-list me-1"></i>View Barcodes
                                                            </button>
                                                            <button type="button" class="btn btn-sm btn-outline-success btn-smaller" id="showGstSettings">
                                                                <i class="fas fa-percentage me-1"></i>GST Settings
                                                            </button>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="card-body">
                                                    
                                                    <div id="searchSection" class="mb-4">
                                                        <div class="input-group search-input-group">
                                                            <input type="text" class="form-control smart-search-input" id="universalSearchInput" placeholder="Enter barcode, IMEI, Serial, product name, or scan..." autocomplete="off">
                                                            <button class="btn btn-success search-btn" type="button" id="addByUniversalSearch">
                                                                <i class="fas fa-plus me-1"></i>Add Product
                                                            </button>
                                                        </div>
                                                        <div class="search-help">
                                                            <strong>Smart Search:</strong> This single input accepts:
                                                            <div class="search-examples">
                                                                <span class="search-example"><i class="fas fa-barcode me-1"></i>Barcode</span>
                                                                <span class="search-example"><i class="fas fa-mobile-alt me-1"></i>IMEI</span>
                                                                <span class="search-example"><i class="fas fa-hashtag me-1"></i>Serial</span>
                                                                <span class="search-example"><i class="fas fa-search me-1"></i>Product Name</span>
                                                                <span class="search-example"><i class="fas fa-hashtag me-1"></i>Product ID</span>
                                                            </div>
                                                            <div class="barcode-search-type" id="barcodeTypeInfo"></div>
                                                        </div>
                                                        
                                                        
                                                        <div id="searchAutocomplete" class="barcode-autocomplete" style="display: none;"></div>
                                                        
                                                        
                                                        <div class="quick-add-btns">
                                                            <strong>Quick Add (Top Products):</strong>
                                                            <?php
                                                            // Show top 5 products by stock (or price) as quick buttons
                                                            $top_products = array_slice($products_array, 0, 5);
                                                            if (count($top_products) > 0) {
                                                                foreach ($top_products as $product):
                                                                    if (isset($product['barcode'])) {
                                                                        $display_barcode = !empty($product['barcode']) ? $product['barcode'] : (isset($product['generated_barcode']) ? $product['generated_barcode'] : '');
                                                                    ?>
                                                                        <button type="button" class="btn btn-sm btn-outline-secondary quick-add-btn" 
                                                                                data-product-id="<?php echo $product['id']; ?>"
                                                                                onclick="quickAddProduct(<?php echo $product['id']; ?>)">
                                                                            <?php echo htmlspecialchars($product['name']); ?>
                                                                        </button>
                                                                    <?php
                                                                    }
                                                                endforeach;
                                                            }
                                                            ?>
                                                        </div>
                                                        
                                                        <div id="searchResult" class="mt-2"></div>
                                                        
                                                        
                                                        <div id="barcodeScannerSection" class="barcode-scanner-section" style="display: none;">
                                                            <h6><i class="fas fa-camera me-2"></i>Barcode Scanner</h6>
                                                            <div class="barcode-camera-container">
                                                                <div id="barcodeScanner"></div>
                                                            </div>
                                                            <div class="barcode-scanner-controls">
                                                                <button type="button" class="btn btn-success" id="startScanner">
                                                                    <i class="fas fa-play me-1"></i>Start Scanner
                                                                </button>
                                                                <button type="button" class="btn btn-danger" id="stopScanner">
                                                                    <i class="fas fa-stop me-1"></i>Stop Scanner
                                                                </button>
                                                                <button type="button" class="btn btn-secondary" id="hideScanner">
                                                                    <i class="fas fa-times me-1"></i>Hide Scanner
                                                                </button>
                                                            </div>
                                                            <div class="mt-2">
                                                                <small class="text-muted">Point your camera at a barcode. Auto-detects any barcode format.</small>
                                                            </div>
                                                        </div>
                                                    </div>

<div class="table-responsive">
                                                        <table class="table table-bordered table-smaller" id="productsTable">
                                                            <thead class="table-light">
                                                                <tr>
                                                                    <th width="40%">Product Details</th>
                                                                    <th width="70">Stock</th>
                                                                    <th width="80">Qty</th>
                                                                    <th width="150">Price (Incl. GST)</th>
                                                                    <th width="60">GST</th>
                                                                    <th width="150">Total (₹)</th>
                                                                    <th width="40">Action</th>
                                                                </tr>
                                                            </thead>
                                                            <tbody id="productsTableBody">
                                                                
                                                            </tbody>
                                                            <tfoot>
                                                                <tr class="table-secondary">
                                                                    <td colspan="3" class="text-end"><strong>Base Amount:</strong></td>
                                                                    <td colspan="2"></td>
                                                                    <td><strong id="displaySubtotal">₹0.00</strong></td>
                                                                    <td></td>
                                                                </tr>
                                                                <tr class="table-info">
                                                                    <td colspan="3" class="text-end"><strong>Total GST:</strong></td>
                                                                    <td colspan="2"></td>
                                                                    <td><strong id="displayTotalGst">₹0.00</strong></td>
                                                                    <td></td>
                                                                </tr>
                                                                <tr class="table-success">
                                                                    <td colspan="3" class="text-end"><strong>Grand Total (Incl. GST):</strong></td>
                                                                    <td colspan="2"></td>
                                                                    <td><strong id="grandTotal">₹0.00</strong></td>
                                                                    <td></td>
                                                                </tr>
                                                            </tfoot>
                                                        </table>
                                                    </div>
                                                    <div class="d-flex justify-content-between align-items-center mt-2">
                                                        <div>
                                                            <button type="button" class="btn btn-sm btn-outline-primary btn-smaller-add" id="addProductRow">
                                                                <i class="fas fa-plus me-1"></i>Add Product
                                                            </button>
                                                            <button type="button" class="btn btn-sm btn-outline-info btn-smaller-add" id="addFromRecent">
                                                                <i class="fas fa-history me-1"></i>Add from Recent
                                                            </button>
                                                        </div>
                                                        <small class="text-muted" id="productsCount">No products added</small>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-12">
                                            <div class="card mb-4">
                                                <div class="card-header">
                                                    <h6 class="card-title mb-0">
                                                        <i class="fas fa-sticky-note me-2"></i>Additional Information
                                                    </h6>
                                                </div>
                                                <div class="card-body">
                                                    <div class="mb-3">
                                                        <label for="notes" class="form-label">Sale Notes</label>
                                                        <textarea class="form-control" id="notes" name="notes" rows="3" placeholder="Any additional notes about this sale..."></textarea>
                                                        <div class="form-text">For EMI/TVS/Bajaj sales, mention EMI tenure, interest rate, and other details here.</div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-12">
                                            <div class="d-flex justify-content-between">
                                                <button type="reset" class="btn btn-secondary btn-smaller">
                                                    <i class="fas fa-redo me-2"></i>Reset Form
                                                </button>
                                                <div class="d-flex gap-2">
                                                    <button type="button" class="btn btn-outline-primary btn-smaller" id="saveDraft">
                                                        <i class="fas fa-save me-2"></i>Save as Draft
                                                    </button>
                                                    <button type="submit" name="create_sale" class="btn btn-success">
                                                        <i class="fas fa-check-circle me-2"></i>Complete Sale
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </form>

</div>
                        </div>
                    </div>
                </div>

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

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

// Create multiple search maps
const barcodeMap = {};
const generatedBarcodeMap = {};
const productIdMap = {};
const imei1Map = {};
const imei2Map = {};
const serialMap = {};
const searchIndex = [];

// Build search indices
productsData.forEach(product => {
    // Barcode map (actual barcode from database)
    if (product.barcode && product.barcode.trim() !== '') {
        barcodeMap[product.barcode.trim()] = product;
    }
    
    // Generated barcode map (fallback)
    if (product.generated_barcode && product.generated_barcode.trim() !== '') {
        generatedBarcodeMap[product.generated_barcode.trim()] = product;
    }
    
    productIdMap[product.id] = product;
    
    // IMEI maps
    if (product.imei_number_1 && product.imei_number_1.trim() !== '') {
        imei1Map[product.imei_number_1.trim()] = product;
    }
    if (product.imei_number_2 && product.imei_number_2.trim() !== '') {
        imei2Map[product.imei_number_2.trim()] = product;
    }
    
    // Serial map
    if (product.serial_number && product.serial_number.trim() !== '') {
        serialMap[product.serial_number.trim()] = product;
    }
    
    // Search index for text search
    const searchableText = (
        product.name + ' ' + 
        product.brand + ' ' + 
        product.model
    ).toLowerCase();
    
    searchIndex.push({
        product: product,
        searchText: searchableText,
        displayText: `${product.name} - ${product.brand} ${product.model}`
    });
});

// Search function
function searchProduct(searchValue) {
    let product = null;
    let matchingProducts = [];
    let searchType = 'unknown';
    const cleanValue = searchValue.trim();

// 1. Check for exact barcode match
    if (cleanValue) {
        product = barcodeMap[cleanValue];
        if (product) searchType = 'barcode_exact';
    }
    
    // 2. Check for generated barcode match
    if (!product) {
        product = generatedBarcodeMap[cleanValue];
        if (product) searchType = 'barcode_generated';
    }
    
    // 3. Check for product ID
    if (!product) {
        const productId = parseInt(cleanValue);
        if (!isNaN(productId) && productId > 0) {
            product = productIdMap[productId];
            if (product) searchType = 'product_id';
        }
    }
    
    // 4. Check for IMEI
    if (!product) {
        product = imei1Map[cleanValue] || imei2Map[cleanValue];
        if (product) searchType = 'imei';
    }
    
    // 5. Check for serial number
    if (!product) {
        product = serialMap[cleanValue];
        if (product) searchType = 'serial';
    }
    
    // 6. Text search
    if (!product) {
        const searchLower = cleanValue.toLowerCase();
        matchingProducts = searchIndex.filter(item => 
            item.searchText.includes(searchLower)
        ).map(item => item.product);
        
        if (matchingProducts.length === 1) {
            product = matchingProducts[0];
            searchType = 'text';
        } else if (matchingProducts.length > 1) {
            searchType = 'text_multiple';
        }
    }

return { product, matchingProducts, searchType };
}

// Show autocomplete suggestions
function showAutocompleteSuggestions(searchValue) {
    const autocomplete = document.getElementById('searchAutocomplete');
    const barcodeTypeInfo = document.getElementById('barcodeTypeInfo');
    
    if (!searchValue || searchValue.length < 1) {
        autocomplete.style.display = 'none';
        barcodeTypeInfo.innerHTML = '';
        return;
    }

if (results.length === 0) {
        autocomplete.style.display = 'none';
        barcodeTypeInfo.innerHTML = '<span class="text-danger">No matches found</span>';
        return;
    }

autocomplete.innerHTML = html;
    autocomplete.style.display = 'block';
    
    // Add click handlers
    document.querySelectorAll('.barcode-autocomplete-item').forEach(item => {
        item.addEventListener('click', function() {
            const productId = this.getAttribute('data-product-id');
            const product = productIdMap[productId];
            if (product) {
                addProductToTable(product);
                autocomplete.style.display = 'none';
                document.getElementById('universalSearchInput').value = '';
                document.getElementById('barcodeTypeInfo').innerHTML = '';
                showSuccessMessage(`Product added: ${product.name}`);
            }
        });
    });

// Update info text
    const searchResult = searchProduct(searchValue);
    let infoText = '';
    if (searchResult.searchType !== 'unknown') {
        infoText = `<span class="text-success">Search type: ${searchResult.searchType.replace('_', ' ')}</span>`;
        if (searchResult.product) {
            infoText += ` | Found: ${searchResult.product.name}`;
        } else if (searchResult.matchingProducts.length > 0) {
            infoText += ` | Multiple matches (${searchResult.matchingProducts.length})`;
        }
    }
    barcodeTypeInfo.innerHTML = infoText;
}

// Show success message
function showSuccessMessage(message) {
    const searchResult = document.getElementById('searchResult');
    searchResult.innerHTML = `<div class="alert alert-success">
        <i class="fas fa-check-circle me-1"></i> ${message}
    </div>`;
    setTimeout(() => {
        if (document.getElementById('universalSearchInput')) {
            document.getElementById('universalSearchInput').focus();
        }
    }, 100);
}

// Add product to table
function addProductToTable(product, quantity = 1) {
    const tableBody = document.getElementById('productsTableBody');
    const rowIndex = productRowCount++;
    
    // Calculate item total
    const itemTotal = product.price * quantity;
    const itemGst = product.gst_amount_per_unit * quantity;
    const itemBase = product.base_price * quantity;
    
    // Create row HTML
    const rowHtml = `
        <tr id="productRow_${rowIndex}" data-product-id="${product.id}">
            <td class="product-details-cell">
                <div><strong>${product.name}</strong></div>
                <div class="text-muted">${product.brand} ${product.model}</div>
                <div class="product-id-info">ID: ${product.id}</div>
                <div class="price-breakdown">
                    <span class="price-base">Base: ₹${product.base_price.toFixed(2)}</span> | 
                    <span class="price-gst">GST: ₹${product.gst_amount_per_unit.toFixed(2)}</span> | 
                    <span class="price-total">Total: ₹${product.price.toFixed(2)}</span>
                </div>
                <div class="imei-section-container" id="imeiSection_${rowIndex}">
                    ${product.imei_display || '<div class="no-imei-message">No IMEI/Serial recorded</div>'}
                </div>
                <input type="hidden" name="product_id[]" value="${product.id}">
                <input type="hidden" name="imei_number_1[${rowIndex}][]" value="${product.imei_number_1 || ''}">
                <input type="hidden" name="imei_number_2[${rowIndex}][]" value="${product.imei_number_2 || ''}">
                <input type="hidden" name="serial_number[${rowIndex}][]" value="${product.serial_number || ''}">
            </td>
            <td>
                <span class="stock-info ${product.stock > 0 ? 'text-success' : 'text-danger'}">
                    ${product.stock}
                </span>
            </td>
            <td>
                <input type="number" class="form-control quantity-input" name="quantity[]" value="${quantity}" min="1" max="${product.stock}" data-row="${rowIndex}" data-price="${product.price}" data-base-price="${product.base_price}" data-gst-amount="${product.gst_amount_per_unit}" onchange="updateRowTotal(${rowIndex})">
            </td>
            <td>
                <input type="text" class="form-control price-input" value="₹${product.price.toFixed(2)}" readonly>
                <div class="gst-breakdown">
                    <small>Base: ₹${product.base_price.toFixed(2)} + GST: ₹${product.gst_amount_per_unit.toFixed(2)}</small>
                </div>
            </td>
            <td>
                <span class="badge ${product.gst_applicable ? 'bg-success' : 'bg-secondary'}">
                    ${product.gst_applicable ? product.gst_percentage + '%' : 'No GST'}
                </span>
            </td>
            <td class="item-total" id="itemTotal_${rowIndex}">₹${itemTotal.toFixed(2)}</td>
            <td>
                <button type="button" class="btn btn-sm btn-danger remove-row" onclick="removeProductRow(${rowIndex})">
                    <i class="fas fa-times"></i>
                </button>
            </td>
        </tr>
    `;
    
    tableBody.insertAdjacentHTML('beforeend', rowHtml);
    
    // Update totals
    updateGrandTotal();
    updateProductsCount();
    
    // Add to recent products
    addToRecentProducts(product);
}

// Update row total
function updateRowTotal(rowIndex) {
    const quantityInput = document.querySelector(`input[name="quantity[]"][data-row="${rowIndex}"]`);
    const itemTotalCell = document.getElementById(`itemTotal_${rowIndex}`);
    
    if (quantityInput && itemTotalCell) {
        const quantity = parseInt(quantityInput.value) || 1;
        const price = parseFloat(quantityInput.getAttribute('data-price')) || 0;
        const total = price * quantity;
        
        itemTotalCell.textContent = `₹${total.toFixed(2)}`;
        updateGrandTotal();
    }
}

// Remove product row
function removeProductRow(rowIndex) {
    const row = document.getElementById(`productRow_${rowIndex}`);
    if (row) {
        row.remove();
        updateGrandTotal();
        updateProductsCount();
    }
}

// Update grand total
function updateGrandTotal() {
    let subtotal = 0;
    let totalGst = 0;
    let grandTotal = 0;
    
    // Get all quantity inputs
    const quantityInputs = document.querySelectorAll('input[name="quantity[]"]');
    
    quantityInputs.forEach(input => {
        const quantity = parseInt(input.value) || 1;
        const basePrice = parseFloat(input.getAttribute('data-base-price')) || 0;
        const gstAmount = parseFloat(input.getAttribute('data-gst-amount')) || 0;
        
        subtotal += basePrice * quantity;
        totalGst += gstAmount * quantity;
        grandTotal += (basePrice + gstAmount) * quantity;
    });
    
    // Update display
    document.getElementById('displaySubtotal').textContent = `₹${subtotal.toFixed(2)}`;
    document.getElementById('displayTotalGst').textContent = `₹${totalGst.toFixed(2)}`;
    document.getElementById('grandTotal').textContent = `₹${grandTotal.toFixed(2)}`;
    
    // Update summary
    document.getElementById('display_subtotal').textContent = `₹${subtotal.toFixed(2)}`;
    document.getElementById('display_total_gst').textContent = `₹${totalGst.toFixed(2)}`;
    document.getElementById('display_grand_total').textContent = `₹${grandTotal.toFixed(2)}`;
    
    // Update form fields
    document.getElementById('total_amount').value = grandTotal.toFixed(2);
    document.getElementById('subtotal_amount').value = subtotal.toFixed(2);
    document.getElementById('total_gst_amount').value = totalGst.toFixed(2);
    
    // Update GST breakdown
    const gstBreakdown = {};
    if (totalGst > 0) {
        gstBreakdown['18'] = totalGst; // Assuming 18% GST
    }
    document.getElementById('gst_breakdown').value = JSON.stringify(gstBreakdown);
    
    // Update due amount
    updateDueAmount();
}

// Update due amount
function updateDueAmount() {
    const totalAmount = parseFloat(document.getElementById('total_amount').value) || 0;
    const paidAmount = parseFloat(document.getElementById('paid_amount').value) || 0;
    const dueAmount = Math.max(0, totalAmount - paidAmount);
    
    document.getElementById('due_amount').value = dueAmount.toFixed(2);
}

// Update products count
function updateProductsCount() {
    const productCount = document.querySelectorAll('input[name="product_id[]"]').length;
    const countElement = document.getElementById('productsCount');
    
    if (productCount === 0) {
        countElement.textContent = 'No products added';
        countElement.className = 'text-muted';
    } else {
        countElement.textContent = `${productCount} product(s) added`;
        countElement.className = 'text-success fw-bold';
    }
}

// Add to recent products
function addToRecentProducts(product) {
    // Remove if already exists
    recentProducts = recentProducts.filter(p => p.id !== product.id);
    
    // Add to beginning
    recentProducts.unshift(product);
    
    // Keep only last 10
    if (recentProducts.length > 10) {
        recentProducts = recentProducts.slice(0, 10);
    }
    
    // Save to localStorage
    localStorage.setItem('recentProducts', JSON.stringify(recentProducts));
}

// Quick add product
function quickAddProduct(productId) {
    const product = productIdMap[productId];
    if (product) {
        addProductToTable(product, 1);
        showSuccessMessage(`Product added: ${product.name}`);
    }
}

// Photo preview functionality
function setupPhotoPreview() {
    const photoInput = document.getElementById('customer_photo');
    const photoPreview = document.getElementById('photoPreview');
    const photoPreviewContainer = document.getElementById('photoPreviewContainer');
    
    if (photoInput && photoPreview && photoPreviewContainer) {
        photoInput.addEventListener('change', function(e) {
            const file = e.target.files[0];
            if (file) {
                const reader = new FileReader();
                reader.onload = function(e) {
                    photoPreview.src = e.target.result;
                    photoPreviewContainer.style.display = 'block';
                }
                reader.readAsDataURL(file);
            } else {
                photoPreview.src = '';
                photoPreviewContainer.style.display = 'none';
            }
        });
    }
}

// Initialize barcode scanner
function initBarcodeScanner() {
    if (!html5QrCode) {
        html5QrCode = new Html5Qrcode("barcodeScanner");
    }
}

// Start barcode scanner
function startBarcodeScanner() {
    if (!html5QrCode) {
        initBarcodeScanner();
    }
    
    html5QrCode.start(
        { facingMode: "environment" },
        {
            fps: 10,
            qrbox: { width: 250, height: 250 }
        },
        (decodedText, decodedResult) => {
            // Stop scanning after successful scan
            stopBarcodeScanner();
            
            // Process the scanned barcode
            const searchResult = searchProduct(decodedText);
            if (searchResult.product) {
                addProductToTable(searchResult.product, 1);
                showSuccessMessage(`Product added via barcode: ${searchResult.product.name}`);
            } else {
                document.getElementById('universalSearchInput').value = decodedText;
                document.getElementById('searchResult').innerHTML = `
                    <div class="alert alert-warning">
                        <i class="fas fa-exclamation-triangle me-1"></i> 
                        Scanned barcode not found: ${decodedText}
                    </div>
                `;
            }
        },
        (errorMessage) => {
            // Ignore scanning errors
        }
    ).catch(err => {
        console.error("Scanner start error:", err);
        document.getElementById('searchResult').innerHTML = `
            <div class="alert alert-danger">
                <i class="fas fa-exclamation-circle me-1"></i> 
                Scanner error: ${err}
            </div>
        `;
    });
}

// Stop barcode scanner
function stopBarcodeScanner() {
    if (html5QrCode && html5QrCode.isScanning) {
        html5QrCode.stop().then(() => {
            console.log("Scanner stopped");
        }).catch(err => {
            console.error("Scanner stop error:", err);
        });
    }
}

// Show barcode list modal
function showBarcodeList() {
    let modalHtml = `
        <div class="modal fade" id="barcodeListModal" tabindex="-1">
            <div class="modal-dialog modal-lg">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title">Product Barcodes</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body barcode-list-modal">
                        <div class="row">
    `;
    
    productsData.forEach((product, index) => {
        const barcode = product.barcode || product.generated_barcode;
        modalHtml += `
            <div class="col-md-6">
                <div class="product-item" onclick="quickAddProduct(${product.id})" style="cursor: pointer;">
                    <div><strong>${product.name}</strong></div>
                    <div class="text-muted">${product.brand} ${product.model}</div>
                    <div class="barcode-display mt-2">${barcode}</div>
                    <div class="mt-1">
                        <small>Price: ₹${product.price.toFixed(2)} | Stock: ${product.stock}</small>
                    </div>
                </div>
            </div>
        `;
        
        if ((index + 1) % 2 === 0) {
            modalHtml += '</div><div class="row">';
        }
    });
    
    modalHtml += `
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                    </div>
                </div>
            </div>
        </div>
    `;
    
    // Remove existing modal if any
    const existingModal = document.getElementById('barcodeListModal');
    if (existingModal) {
        existingModal.remove();
    }
    
    // Add modal to body
    document.body.insertAdjacentHTML('beforeend', modalHtml);
    
    // Show modal
    const modal = new bootstrap.Modal(document.getElementById('barcodeListModal'));
    modal.show();
}

// Show recent products
function showRecentProducts() {
    const recentContainer = document.createElement('div');
    recentContainer.className = 'recent-products';
    recentContainer.innerHTML = '<h6>Recently Added Products</h6>';
    
    if (recentProducts.length === 0) {
        recentContainer.innerHTML += '<p class="text-muted">No recent products</p>';
    } else {
        recentProducts.forEach(product => {
            const barcode = product.barcode || product.generated_barcode;
            recentContainer.innerHTML += `
                <div class="recent-product-item" onclick="quickAddProduct(${product.id})">
                    <div><strong>${product.name}</strong></div>
                    <div class="text-muted">${product.brand} ${product.model}</div>
                    <div class="recent-product-barcode">${barcode}</div>
                </div>
            `;
        });
    }
    
    // Show in modal
    let modalHtml = `
        <div class="modal fade" id="recentProductsModal" tabindex="-1">
            <div class="modal-dialog">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title">Recent Products</h5>
                        <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                    </div>
                    <div class="modal-body">
                        ${recentContainer.innerHTML}
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                    </div>
                </div>
            </div>
        </div>
    `;
    
    // Remove existing modal if any
    const existingModal = document.getElementById('recentProductsModal');
    if (existingModal) {
        existingModal.remove();
    }
    
    // Add modal to body
    document.body.insertAdjacentHTML('beforeend', modalHtml);
    
    // Show modal
    const modal = new bootstrap.Modal(document.getElementById('recentProductsModal'));
    modal.show();
}

// Initialize when DOM is loaded
document.addEventListener('DOMContentLoaded', function() {
    // Setup photo preview
    setupPhotoPreview();
    
    // Get DOM elements
    const universalSearchInput = document.getElementById('universalSearchInput');
    const addByUniversalSearch = document.getElementById('addByUniversalSearch');
    const searchAutocomplete = document.getElementById('searchAutocomplete');
    const showBarcodeScanner = document.getElementById('showBarcodeScanner');
    const barcodeScannerSection = document.getElementById('barcodeScannerSection');
    const startScanner = document.getElementById('startScanner');
    const stopScanner = document.getElementById('stopScanner');
    const hideScanner = document.getElementById('hideScanner');
    const showBarcodeList = document.getElementById('showBarcodeList');
    const addProductRow = document.getElementById('addProductRow');
    const addFromRecent = document.getElementById('addFromRecent');
    const saveDraft = document.getElementById('saveDraft');
    const paymentType = document.getElementById('payment_type');
    const paymentStatus = document.getElementById('payment_status');
    const paidAmount = document.getElementById('paid_amount');
    const financePartnerSection = document.getElementById('financePartnerSection');
    const emiWarningSection = document.getElementById('emiWarningSection');
    const tvsBajajInfoSection = document.getElementById('tvsBajajInfoSection');
    const creditSection = document.getElementById('creditSection');
    const saleForm = document.getElementById('saleForm');
    const emiDueDate = document.getElementById('emi_due_date');
    
    // Auto-focus search input
    setTimeout(() => {
        if (universalSearchInput) universalSearchInput.focus();
    }, 500);
    
    // Universal search input event
    if (universalSearchInput) {
        universalSearchInput.addEventListener('input', function() {
            const searchValue = this.value;
            
            // Clear previous timeout
            if (autocompleteTimeout) {
                clearTimeout(autocompleteTimeout);
            }
            
            // Set new timeout for autocomplete
            autocompleteTimeout = setTimeout(() => {
                showAutocompleteSuggestions(searchValue);
            }, 300);
        });
        
        // Handle Enter key
        universalSearchInput.addEventListener('keypress', function(e) {
            if (e.key === 'Enter') {
                e.preventDefault();
                handleUniversalSearch();
            }
        });
    }
    
    // Add by universal search button
    if (addByUniversalSearch) {
        addByUniversalSearch.addEventListener('click', handleUniversalSearch);
    }
    
    // Handle universal search
    function handleUniversalSearch() {
        const searchValue = universalSearchInput.value.trim();
        if (!searchValue) {
            showError('Please enter a search term');
            return;
        }
        
        const searchResult = searchProduct(searchValue);
        
        if (searchResult.product) {
            addProductToTable(searchResult.product, 1);
            universalSearchInput.value = '';
            searchAutocomplete.style.display = 'none';
            showSuccessMessage(`Product added: ${searchResult.product.name}`);
        } else if (searchResult.matchingProducts.length > 1) {
            // Show multiple matches
            let html = '<div class="alert alert-info"><strong>Multiple matches found:</strong><ul class="mb-0 mt-2">';
            searchResult.matchingProducts.forEach(product => {
                html += `<li style="cursor: pointer;" onclick="quickAddProduct(${product.id})">
                    ${product.name} - ${product.brand} ${product.model} (₹${product.price.toFixed(2)})
                </li>`;
            });
            html += '</ul></div>';
            document.getElementById('searchResult').innerHTML = html;
        } else {
            showError(`No product found for: "${searchValue}"`);
        }
    }
    
    // Show error message
    function showError(message) {
        const searchResult = document.getElementById('searchResult');
        searchResult.innerHTML = `<div class="alert alert-danger">
            <i class="fas fa-exclamation-triangle me-1"></i> ${message}
        </div>`;
    }
    
    // Show barcode scanner section
    if (showBarcodeScanner) {
        showBarcodeScanner.addEventListener('click', function() {
            barcodeScannerSection.style.display = 'block';
            initBarcodeScanner();
        });
    }
    
    // Hide barcode scanner section
    if (hideScanner) {
        hideScanner.addEventListener('click', function() {
            barcodeScannerSection.style.display = 'none';
            stopBarcodeScanner();
        });
    }
    
    // Start scanner
    if (startScanner) {
        startScanner.addEventListener('click', startBarcodeScanner);
    }
    
    // Stop scanner
    if (stopScanner) {
        stopScanner.addEventListener('click', stopBarcodeScanner);
    }
    
    // Show barcode list
    if (showBarcodeList) {
        showBarcodeList.addEventListener('click', showBarcodeList);
    }
    
    // Add product row (manual selection)
    if (addProductRow) {
        addProductRow.addEventListener('click', function() {
            // Create a product selection modal
            let modalHtml = `
                <div class="modal fade" id="productSelectionModal" tabindex="-1">
                    <div class="modal-dialog modal-lg">
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title">Select Product</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                            </div>
                            <div class="modal-body">
                                <div class="row">
            `;
            
            // Group products by availability
            const inStockProducts = productsData.filter(p => p.stock > 0);
            const outOfStockProducts = productsData.filter(p => p.stock <= 0);
            
            // Show in-stock products first
            inStockProducts.forEach(product => {
                const barcode = product.barcode || product.generated_barcode;
                modalHtml += `
                    <div class="col-md-6 mb-3">
                        <div class="card h-100" onclick="quickAddProduct(${product.id})" style="cursor: pointer;">
                            <div class="card-body">
                                <h6 class="card-title">${product.name}</h6>
                                <p class="card-text text-muted">${product.brand} ${product.model}</p>
                                <div class="d-flex justify-content-between align-items-center">
                                    <div>
                                        <span class="badge bg-success">In Stock: ${product.stock}</span>
                                        <div class="mt-1"><small>Barcode: ${barcode}</small></div>
                                    </div>
                                    <div class="text-end">
                                        <div class="fw-bold">₹${product.price.toFixed(2)}</div>
                                        <small class="text-muted">incl. GST</small>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                `;
            });
            
            // Show out of stock products
            if (outOfStockProducts.length > 0) {
                modalHtml += `
                    <div class="col-12 mt-3">
                        <h6>Out of Stock</h6>
                        <div class="row">
                `;
                
                outOfStockProducts.forEach(product => {
                    const barcode = product.barcode || product.generated_barcode;
                    modalHtml += `
                        <div class="col-md-6 mb-3">
                            <div class="card h-100 bg-light" style="cursor: not-allowed; opacity: 0.7;">
                                <div class="card-body">
                                    <h6 class="card-title">${product.name}</h6>
                                    <p class="card-text text-muted">${product.brand} ${product.model}</p>
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <span class="badge bg-danger">Out of Stock</span>
                                            <div class="mt-1"><small>Barcode: ${barcode}</small></div>
                                        </div>
                                        <div class="text-end">
                                            <div class="fw-bold">₹${product.price.toFixed(2)}</div>
                                            <small class="text-muted">incl. GST</small>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    `;
                });
                
                modalHtml += '</div></div>';
            }
            
            modalHtml += `
                                </div>
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                            </div>
                        </div>
                    </div>
                </div>
            `;
            
            // Remove existing modal if any
            const existingModal = document.getElementById('productSelectionModal');
            if (existingModal) {
                existingModal.remove();
            }
            
            // Add modal to body
            document.body.insertAdjacentHTML('beforeend', modalHtml);
            
            // Show modal
            const modal = new bootstrap.Modal(document.getElementById('productSelectionModal'));
            modal.show();
        });
    }
    
    // Add from recent
    if (addFromRecent) {
        addFromRecent.addEventListener('click', showRecentProducts);
    }
    
    // Payment type change handler
    if (paymentType) {
        paymentType.addEventListener('change', function() {
            const value = this.value;
            
            // Hide all conditional sections first
            financePartnerSection.style.display = 'none';
            emiWarningSection.style.display = 'none';
            creditSection.style.display = 'none';
            if (tvsBajajInfoSection) tvsBajajInfoSection.style.display = 'none';
            
            // Show/hide finance partner ONLY for EMI
            if (value === 'emi') {
                financePartnerSection.style.display = 'block';
                emiWarningSection.style.display = 'block';
                creditSection.style.display = 'block';
                // For EMI, always set payment status to partial
                if (paymentStatus) {
                    paymentStatus.value = 'partial';
                }
            }
            
            // Show/hide credit section for credit
            if (value === 'credit') {
                creditSection.style.display = 'block';
            }
            
            // For TVS/Bajaj - show info section
            if (value === 'TVS' || value === 'Bajaj') {
                if (tvsBajajInfoSection) tvsBajajInfoSection.style.display = 'block';
                creditSection.style.display = 'block';
            }
        });
    }
    
    // Payment status change handler
    if (paymentStatus) {
        paymentStatus.addEventListener('change', function() {
            updateDueAmount();
        });
    }
    
    // Paid amount change handler
    if (paidAmount) {
        paidAmount.addEventListener('input', function() {
            updateDueAmount();
        });
    }
    
    // EMI due date validation
    if (emiDueDate) {
        emiDueDate.addEventListener('change', function() {
            const selectedDate = new Date(this.value);
            const today = new Date();
            today.setHours(0, 0, 0, 0);
            
            if (selectedDate < today) {
                alert('EMI due date cannot be in the past!');
                this.value = getNextMonthDate();
            }
        });
    }
    
    // Helper function to get next month date
    function getNextMonthDate() {
        const today = new Date();
        const nextMonth = new Date(today.getFullYear(), today.getMonth() + 1, today.getDate());
        return nextMonth.toISOString().split('T')[0];
    }
    
    // Save draft
    if (saveDraft) {
        saveDraft.addEventListener('click', function() {
            // For now, just submit the form
            saleForm.submit();
        });
    }
    
    // Initialize UI values
    updateGrandTotal();
    updateDueAmount();
    updateProductsCount();
    
    // Set minimum date for EMI due date
    if (emiDueDate) {
        const today = new Date().toISOString().split('T')[0];
        emiDueDate.min = today;
    }
    
    // Hide autocomplete when clicking outside
    document.addEventListener('click', function(e) {
        if (searchAutocomplete && !searchAutocomplete.contains(e.target) && 
            universalSearchInput && !universalSearchInput.contains(e.target)) {
            searchAutocomplete.style.display = 'none';
        }
    });
});

// Cleanup when leaving page
window.addEventListener('beforeunload', function() {
    if (html5QrCode && html5QrCode.isScanning) {
        html5QrCode.stop();
    }
});
</script>

</body>
</html>

<?php
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sales-new.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation