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

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: branch-transfer.php

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

// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

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

// Function to check if column exists
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);
}

// Get all branches for dropdown
$branches = [];
$branch_sql = "SELECT * FROM branches WHERE status = 'active' ORDER BY branch_name";
$branch_result = $conn->query($branch_sql);
while($branch = $branch_result->fetch_assoc()) {
    $branches[] = $branch;
}

// Handle form submission
$success_msg = '';
$error_msg = '';

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    if (isset($_POST['transfer_type']) && $_POST['transfer_type'] == 'product_transfer') {
        // PRODUCT TRANSFER LOGIC
        $from_branch_id = intval($_POST['from_branch_id']);
        $to_branch_id = intval($_POST['to_branch_id']);
        $transfer_date = $_POST['transfer_date'];
        $notes = trim($_POST['notes'] ?? '');
        $product_ids = $_POST['product_ids'] ?? [];
        $quantities = $_POST['quantities'] ?? [];
        
        // Validate
        $errors = [];
        if ($from_branch_id == $to_branch_id) {
            $errors[] = "Source and destination branches cannot be the same.";
        }
        if (empty($product_ids)) {
            $errors[] = "No products selected for transfer.";
        }
        if (count($product_ids) != count($quantities)) {
            $errors[] = "Product and quantity mismatch.";
        }
        
        if (empty($errors)) {
            // Begin transaction
            $conn->begin_transaction();
            try {
                // Generate unique transfer number
                $transfer_number = 'TRF-' . date('YmdHis') . '-' . rand(100, 999);
                $total_value = 0;
                $transfer_items = [];
                
                // Prepare product data and calculate total
                foreach ($product_ids as $index => $product_id) {
                    $product_id = intval($product_id);
                    $quantity = intval($quantities[$index]);
                    if ($quantity <= 0) continue;
                    
                    // Fetch product details from source branch
                    $prod_query = "SELECT p.*, b.brand_name, m.model_name 
                                  FROM products p
                                  LEFT JOIN brands b ON p.brand_id = b.id
                                  LEFT JOIN models m ON p.model_id = m.id
                                  WHERE p.id = $product_id AND p.branch_id = $from_branch_id AND p.status = 'active'";
                    $prod_res = $conn->query($prod_query);
                    if ($prod_res && $prod_res->num_rows > 0) {
                        $product = $prod_res->fetch_assoc();
                        // Check stock
                        if ($product['stock_quantity'] < $quantity) {
                            throw new Exception("Insufficient stock for product: " . $product['product_name'] . " (Available: " . $product['stock_quantity'] . ")");
                        }
                        $unit_value = $product['purchase_price'];
                        $item_total = $unit_value * $quantity;
                        $total_value += $item_total;
                        $transfer_items[] = [
                            'product' => $product,
                            'quantity' => $quantity,
                            'unit_value' => $unit_value,
                            'total_value' => $item_total
                        ];
                    } else {
                        throw new Exception("Product ID $product_id not found in source branch.");
                    }
                }
                
                if (empty($transfer_items)) {
                    throw new Exception("No valid products to transfer.");
                }
                
                // Insert into branch_transfers - FIXED bind_param
                $insert_transfer = "INSERT INTO branch_transfers 
                                    (transfer_number, from_branch_id, to_branch_id, transfer_date, total_value, notes, status, created_at) 
                                    VALUES (?, ?, ?, ?, ?, ?, 'pending', NOW())";
                $stmt = $conn->prepare($insert_transfer);
                // 6 parameters: string, int, int, string, double, string
                $stmt->bind_param("siisds", $transfer_number, $from_branch_id, $to_branch_id, $transfer_date, $total_value, $notes);
                $stmt->execute();
                $transfer_id = $conn->insert_id;
                
                // Insert transfer items and update product branch_id
                foreach ($transfer_items as $item) {
                    $product = $item['product'];
                    $quantity = $item['quantity'];
                    $unit_value = $item['unit_value'];
                    $item_total = $item['total_value'];
                    
                    // Create product name for transfer item
                    $product_display_name = $product['product_name'] . ' - ' . ($product['model_name'] ?? $product['model']);
                    
                    // Insert into branch_transfer_items
                    $insert_item = "INSERT INTO branch_transfer_items 
                                    (transfer_id, product_name, quantity, unit_value, total_value, created_at) 
                                    VALUES (?, ?, ?, ?, ?, NOW())";
                    $stmt_item = $conn->prepare($insert_item);
                    $stmt_item->bind_param("isidd", $transfer_id, $product_display_name, $quantity, $unit_value, $item_total);
                    $stmt_item->execute();
                    
                    // Update product branch_id (move product to destination branch)
                    $update_product = "UPDATE products SET branch_id = ?, updated_at = NOW() WHERE id = ? AND branch_id = ?";
                    $stmt_upd = $conn->prepare($update_product);
                    $stmt_upd->bind_param("iii", $to_branch_id, $product['id'], $from_branch_id);
                    $stmt_upd->execute();
                    
                    // Log activity
                    $activity_desc = "Product transferred: {$product_display_name} (Qty: $quantity) from branch ID $from_branch_id to $to_branch_id";
                    $log_sql = "INSERT INTO activity_logs (branch_id, activity_type, description, related_id, related_table, created_at) 
                                VALUES (?, 'stock_update', ?, ?, 'products', NOW())";
                    $stmt_log = $conn->prepare($log_sql);
                    $stmt_log->bind_param("isi", $from_branch_id, $activity_desc, $product['id']);
                    $stmt_log->execute();
                }
                
                $conn->commit();
                $success_msg = "Transfer initiated successfully! Transfer Number: $transfer_number";
                
            } catch (Exception $e) {
                $conn->rollback();
                $error_msg = "Transfer failed: " . $e->getMessage();
            }
        } else {
            $error_msg = implode(" ", $errors);
        }
    } 
    elseif (isset($_POST['transfer_type']) && $_POST['transfer_type'] == 'credit_payment') {
        // CREDIT PAYMENT LOGIC
        $branch_id = intval($_POST['branch_id']);
        $amount = floatval($_POST['payment_amount']);
        $payment_date = $_POST['payment_date'];
        $method = $_POST['payment_method'];
        $reference = trim($_POST['reference_number']);
        $notes = trim($_POST['payment_notes']);
        
        if ($branch_id <= 0 || $amount <= 0) {
            $error_msg = "Invalid branch or payment amount.";
        } else {
            $conn->begin_transaction();
            try {
                // Check if branch_credits exists
                $check_credit = "SELECT id, current_credit FROM branch_credits WHERE branch_id = ?";
                $stmt_check = $conn->prepare($check_credit);
                $stmt_check->bind_param("i", $branch_id);
                $stmt_check->execute();
                $result = $stmt_check->get_result();
                
                if ($result->num_rows > 0) {
                    // Update existing credit
                    $update_credit = "UPDATE branch_credits SET current_credit = current_credit - ?, last_updated = NOW() WHERE branch_id = ?";
                    $stmt = $conn->prepare($update_credit);
                    $stmt->bind_param("di", $amount, $branch_id);
                    $stmt->execute();
                } else {
                    // Insert new credit record with negative amount (credit due)
                    $insert_credit = "INSERT INTO branch_credits (branch_id, current_credit, credit_limit, last_updated) VALUES (?, ?, 1000000, NOW())";
                    $neg_amount = -$amount;
                    $stmt = $conn->prepare($insert_credit);
                    $stmt->bind_param("id", $branch_id, $neg_amount);
                    $stmt->execute();
                }
                
                // Insert transaction record - FIXED bind_param
                $trans_sql = "INSERT INTO branch_credit_transactions 
                              (branch_id, transaction_type, amount, payment_method, reference_number, description, notes, created_at) 
                              VALUES (?, 'payment_received', ?, ?, ?, 'Credit payment received', ?, NOW())";
                $stmt_trans = $conn->prepare($trans_sql);
                // 5 parameters: int, double, string, string, string
                $stmt_trans->bind_param("idsss", $branch_id, $amount, $method, $reference, $notes);
                $stmt_trans->execute();
                
                $conn->commit();
                $success_msg = "Credit payment of ₹" . number_format($amount, 2) . " recorded for branch.";
                
            } catch (Exception $e) {
                $conn->rollback();
                $error_msg = "Payment failed: " . $e->getMessage();
            }
        }
    }
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8" />
    <title>Branch Transfer Management</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta content="Branch Transfer Management System" name="description" />
    <meta content="VK Mobiles" name="author" />
    <?php include('includes/head.php'); ?>
    <style>
        /* Products Container - Scrollable */
        #productsContainer {
            max-height: 500px;
            overflow-y: auto;
            border: 1px solid #dee2e6;
            border-radius: 8px;
            background: #fff;
        }
        
        #productsContainer::-webkit-scrollbar {
            width: 8px;
            height: 8px;
        }
        
        #productsContainer::-webkit-scrollbar-track {
            background: #f1f1f1;
            border-radius: 4px;
        }
        
        #productsContainer::-webkit-scrollbar-thumb {
            background: #c1c1c1;
            border-radius: 4px;
        }
        
        #productsContainer::-webkit-scrollbar-thumb:hover {
            background: #a8a8a8;
        }
        
        .product-row {
            transition: all 0.3s ease;
            border-left: 3px solid transparent;
            border-bottom: 1px solid #f0f0f0;
        }
        
        .product-row:last-child {
            border-bottom: none;
        }
        
        .product-row:hover {
            background-color: #f8f9fa;
        }
        
        .product-row.selected {
            border-left-color: #0d6efd;
            background-color: #f0f7ff;
        }
        
        .imei-serial-info {
            font-size: 0.75rem;
            background-color: #f8f9fa;
            padding: 8px;
            border-radius: 4px;
            margin-top: 5px;
        }
        
        .imei-serial-info .badge {
            font-size: 0.7rem;
        }
        
        .imei-value, .serial-value {
            font-family: monospace;
            font-size: 0.7rem;
            word-break: break-all;
        }
        
        .product-stock-badge {
            font-size: 0.7rem;
            padding: 3px 8px;
        }
        
        .product-detail-card {
            border-left: 3px solid #0d6efd;
        }
        
        .transfer-summary-card {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            color: white;
        }
        
        .credit-card-header {
            background: linear-gradient(135deg, #11998e 0%, #38ef7d 100%);
        }
        
        .product-name-highlight {
            font-weight: 600;
            color: #0d6efd;
        }
        
        .product-meta-info {
            font-size: 0.7rem;
            color: #6c757d;
        }
        
        .imei-badge {
            background-color: #0d6efd;
            color: white;
            font-size: 0.65rem;
            padding: 2px 6px;
        }
        
        .serial-badge {
            background-color: #198754;
            color: white;
            font-size: 0.65rem;
            padding: 2px 6px;
        }
        
        .both-badge {
            background-color: #ffc107;
            color: #212529;
            font-size: 0.65rem;
            padding: 2px 6px;
        }
        
        .product-type-indicator {
            margin-left: 5px;
        }
        
        .transfer-loading {
            position: fixed;
            top: 0;
            left: 0;
            width: 100%;
            height: 100%;
            background: rgba(0,0,0,0.5);
            z-index: 9999;
            display: none;
            justify-content: center;
            align-items: center;
        }
        
        .transfer-loading.show {
            display: flex;
        }
        
        .transfer-loading .spinner-border {
            width: 3rem;
            height: 3rem;
        }
        
        /* Search Styles */
        .search-container {
            position: relative;
        }
        
        .search-results-dropdown {
            position: absolute;
            top: 100%;
            left: 0;
            right: 0;
            background: white;
            border: 1px solid #dee2e6;
            border-radius: 8px;
            max-height: 400px;
            overflow-y: auto;
            z-index: 1000;
            box-shadow: 0 4px 12px rgba(0,0,0,0.15);
            display: none;
        }
        
        .search-results-dropdown.show {
            display: block;
        }
        
        .search-result-item {
            padding: 12px 15px;
            border-bottom: 1px solid #f0f0f0;
            cursor: pointer;
            transition: all 0.2s;
        }
        
        .search-result-item:hover {
            background-color: #f8f9fa;
        }
        
        .search-result-item:last-child {
            border-bottom: none;
        }
        
        .search-highlight {
            background-color: #ffeaa7;
            padding: 0 2px;
            border-radius: 3px;
            font-weight: bold;
        }
        
        .search-match-type {
            font-size: 0.7rem;
            padding: 2px 6px;
            border-radius: 12px;
            display: inline-block;
        }
        
        .match-imei { background-color: #0d6efd; color: white; }
        .match-serial { background-color: #198754; color: white; }
        .match-product { background-color: #6f42c1; color: white; }
        .match-model { background-color: #fd7e14; color: white; }
        .match-brand { background-color: #20c997; color: white; }
        
        .search-tabs {
            display: flex;
            gap: 10px;
            margin-bottom: 15px;
            border-bottom: 1px solid #dee2e6;
            padding-bottom: 10px;
        }
        
        .search-tab {
            cursor: pointer;
            padding: 5px 15px;
            border-radius: 20px;
            background-color: #f8f9fa;
            transition: all 0.2s;
        }
        
        .search-tab.active {
            background-color: #0d6efd;
            color: white;
        }
        
        .search-tab:hover:not(.active) {
            background-color: #e9ecef;
        }
        
        .quick-add-btn {
            transition: all 0.2s;
        }
        
        .quick-add-btn:hover {
            transform: scale(1.05);
        }
        
        .no-results {
            padding: 20px;
            text-align: center;
            color: #6c757d;
        }
        
        .search-stats {
            font-size: 0.75rem;
            padding: 5px 10px;
            background-color: #f8f9fa;
            border-radius: 4px;
            margin-top: 5px;
        }
        
        .product-sticky-header {
            position: sticky;
            top: 0;
            background: white;
            z-index: 10;
            padding: 10px;
            border-bottom: 2px solid #dee2e6;
            font-weight: bold;
        }
        
        .branch-info-card {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            color: white;
            padding: 15px;
            border-radius: 10px;
            margin-bottom: 20px;
        }
        
        .loading-spinner-small {
            display: inline-block;
            width: 1rem;
            height: 1rem;
            border: 2px solid #f3f3f3;
            border-top: 2px solid #3498db;
            border-radius: 50%;
            animation: spin 1s linear infinite;
        }
        
        @keyframes spin {
            0% { transform: rotate(0deg); }
            100% { transform: rotate(360deg); }
        }
        
        .alert-fixed {
            position: fixed;
            top: 20px;
            right: 20px;
            z-index: 9999;
            min-width: 300px;
            animation: slideIn 0.3s ease-out;
        }
        
        @keyframes slideIn {
            from {
                transform: translateX(100%);
                opacity: 0;
            }
            to {
                transform: translateX(0);
                opacity: 1;
            }
        }
    </style>
</head>

<div id="transferLoading" class="transfer-loading">
    <div class="text-center bg-white p-4 rounded">
        <div class="spinner-border text-primary" role="status">
            <span class="visually-hidden">Loading...</span>
        </div>
        <p class="mt-2 mb-0">Processing transfer...</p>
    </div>
</div>

<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="main-content">
        <div class="page-content">
            <div class="container-fluid">

<?php if ($success_msg): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="fas fa-check-circle me-2"></i>
                        <?php echo htmlspecialchars($success_msg); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                
                <?php if ($error_msg): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <?php echo htmlspecialchars($error_msg); ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0">Branch Transfer Management</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                                    <li class="breadcrumb-item active">Branch Transfer</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-8">
                        
                        <div class="card">
                            <div class="card-header">
                                <h5 class="card-title mb-0">
                                    <i class="fas fa-truck-moving me-2"></i>Product Transfer
                                </h5>
                            </div>
                            <div class="card-body">
                                <form method="POST" action="" id="transferForm" onsubmit="showLoading()">
                                    <input type="hidden" name="transfer_type" value="product_transfer">
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="from_branch_id" class="form-label">From Branch <span class="text-danger">*</span></label>
                                                <select class="form-select" id="from_branch_id" name="from_branch_id" required onchange="loadProducts()">
                                                    <option value="">Select Source Branch</option>
                                                    <?php foreach($branches as $branch): ?>
                                                        <option value="<?php echo $branch['id']; ?>" <?php echo (isset($_SESSION['branch_id']) && $_SESSION['branch_id'] == $branch['id']) ? 'selected' : ''; ?>>
                                                            <?php echo htmlspecialchars($branch['branch_name']); ?> (<?php echo htmlspecialchars($branch['branch_code']); ?>)
                                                        </option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                        </div>
                                        
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="to_branch_id" class="form-label">To Branch <span class="text-danger">*</span></label>
                                                <select class="form-select" id="to_branch_id" name="to_branch_id" required>
                                                    <option value="">Select Destination Branch</option>
                                                    <?php foreach($branches as $branch): ?>
                                                        <option value="<?php echo $branch['id']; ?>">
                                                            <?php echo htmlspecialchars($branch['branch_name']); ?> (<?php echo htmlspecialchars($branch['branch_code']); ?>)
                                                        </option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="transfer_date" class="form-label">Transfer Date <span class="text-danger">*</span></label>
                                                <input type="date" class="form-control" id="transfer_date" name="transfer_date" 
                                                       value="<?php echo date('Y-m-d'); ?>" required>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label class="form-label">Quick Search</label>
                                                <div class="search-container">
                                                    <input type="text" class="form-control" id="globalSearch" 
                                                           placeholder="🔍 Search by IMEI, Serial, Product Name, Model, or Brand..." 
                                                           autocomplete="off">
                                                    <div id="searchResultsDropdown" class="search-results-dropdown"></div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="mb-3">
                                        <div class="d-flex justify-content-between align-items-center mb-3">
                                            <label class="form-label mb-0">Select Products to Transfer <span class="text-danger">*</span></label>
                                            <div class="form-check">
                                                <input class="form-check-input" type="checkbox" id="selectAll" onclick="selectAllProducts(this)">
                                                <label class="form-check-label" for="selectAll">Select All</label>
                                            </div>
                                        </div>
                                        <div id="productsContainer">
                                            <div class="text-center py-4">
                                                <i class="fas fa-box-open fa-2x text-muted mb-3"></i>
                                                <p class="text-muted">Select a source branch to view products</p>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="card transfer-summary-card mb-3">
                                        <div class="card-body">
                                            <div class="row align-items-center">
                                                <div class="col-md-6">
                                                    <h6 class="mb-0 text-white">Transfer Summary</h6>
                                                    <small class="text-white-50">Based on selected products</small>
                                                </div>
                                                <div class="col-md-6 text-end">
                                                    <h5 class="mb-0 text-white">Total: <span id="totalValue" class="text-warning">₹0.00</span></h5>
                                                    <small class="text-white-50">Items: <span id="totalItems">0</span></small>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="notes" class="form-label">Transfer Notes</label>
                                        <textarea class="form-control" id="notes" name="notes" rows="2" placeholder="Add any notes about this transfer..."></textarea>
                                    </div>
                                    
                                    <div class="d-grid gap-2 d-md-flex justify-content-md-end">
                                        <button type="reset" class="btn btn-light me-md-2" onclick="resetForm()">
                                            <i class="fas fa-redo me-2"></i>Reset
                                        </button>
                                        <button type="submit" class="btn btn-primary">
                                            <i class="fas fa-paper-plane me-2"></i>Initiate Transfer
                                        </button>
                                    </div>
                                </form>
                            </div>
                        </div>
                        
                        
                        <div class="card mt-4">
                            <div class="card-header">
                                <h5 class="card-title mb-0">
                                    <i class="fas fa-history me-2"></i>Recent Transfers
                                </h5>
                            </div>
                            <div class="card-body">
                                <?php
                                $recent_sql = "SELECT bt.*, fb.branch_name as from_branch, tb.branch_name as to_branch 
                                              FROM branch_transfers bt
                                              LEFT JOIN branches fb ON bt.from_branch_id = fb.id
                                              LEFT JOIN branches tb ON bt.to_branch_id = tb.id
                                              ORDER BY bt.created_at DESC LIMIT 5";
                                $recent_result = $conn->query($recent_sql);
                                
                                if ($recent_result && $recent_result->num_rows > 0) {
                                    echo '<div class="table-responsive">';
                                    echo '<table class="table table-sm table-hover">';
                                    echo '<thead><tr><th>Date</th><th>Transfer #</th><th>From → To</th><th>Value</th><th>Status</th></tr></thead>';
                                    echo '<tbody>';
                                    
                                    while($transfer = $recent_result->fetch_assoc()) {
                                        $status_class = $transfer['status'] == 'completed' ? 'success' : ($transfer['status'] == 'pending' ? 'warning' : 'secondary');
                                        echo '<tr>';
                                        echo '<td>' . date('d M Y', strtotime($transfer['transfer_date'])) . '</td>';
                                        echo '<td><a href="branch-transfer-history.php?id=' . $transfer['id'] . '" class="text-decoration-none">' . htmlspecialchars($transfer['transfer_number']) . '</a></td>';
                                        echo '<td>' . htmlspecialchars($transfer['from_branch'] ?? 'N/A') . ' → ' . htmlspecialchars($transfer['to_branch'] ?? 'N/A') . '</td>';
                                        echo '<td>₹' . number_format($transfer['total_value'], 2) . '</td>';
                                        echo '<td><span class="badge bg-' . $status_class . '">' . ucfirst($transfer['status']) . '</span></td>';
                                        echo '</tr>';
                                    }
                                    
                                    echo '</tbody></table></div>';
                                    echo '<div class="text-center mt-2">';
                                    echo '<a href="branch-transfer-history.php" class="btn btn-sm btn-outline-primary">View All Transfers</a>';
                                    echo '</div>';
                                } else {
                                    echo '<div class="text-center py-4">';
                                    echo '<i class="fas fa-exchange-alt fa-2x text-muted mb-3"></i>';
                                    echo '<p class="text-muted">No transfers recorded yet</p>';
                                    echo '</div>';
                                }
                                ?>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-lg-4">
                        
                        <div class="card">
                            <div class="card-header credit-card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0 text-white">
                                        <i class="fas fa-credit-card me-2"></i>Branch Credits
                                    </h5>
                                    <a href="branch-credits.php" class="btn btn-sm btn-light">View All</a>
                                </div>
                            </div>
                            <div class="card-body">
                                <?php
                                $credits_sql = "SELECT b.id, b.branch_name, b.branch_code, 
                                               COALESCE(bc.current_credit, 0) as current_credit,
                                               COALESCE(bc.credit_limit, 1000000) as credit_limit
                                               FROM branches b
                                               LEFT JOIN branch_credits bc ON b.id = bc.branch_id
                                               WHERE b.status = 'active'
                                               ORDER BY b.branch_name";
                                $credits_result = $conn->query($credits_sql);
                                
                                if ($credits_result && $credits_result->num_rows > 0) {
                                    while($branch = $credits_result->fetch_assoc()) {
                                        $credit_ratio = $branch['credit_limit'] > 0 ? ($branch['current_credit'] / $branch['credit_limit']) * 100 : 0;
                                        $progress_class = $credit_ratio > 80 ? 'bg-danger' : ($credit_ratio > 50 ? 'bg-warning' : 'bg-success');
                                        $credit_status = $branch['current_credit'] == 0 ? 'No Credit' : ($branch['current_credit'] > 0 ? 'Credit Due' : 'Credit Available');
                                        
                                        echo '<div class="mb-4">';
                                        echo '<div class="d-flex justify-content-between mb-1">';
                                        echo '<span class="fw-medium">' . htmlspecialchars($branch['branch_name']) . '</span>';
                                        echo '<span class="badge ' . ($credit_status == 'No Credit' ? 'bg-success' : 'bg-warning') . '">' . $credit_status . '</span>';
                                        echo '</div>';
                                        echo '<div class="d-flex justify-content-between mb-1">';
                                        echo '<small class="text-muted">Balance:</small>';
                                        echo '<span class="fw-bold ' . ($branch['current_credit'] > 0 ? 'text-danger' : 'text-success') . '">₹' . number_format(abs($branch['current_credit']), 2) . '</span>';
                                        echo '</div>';
                                        echo '<div class="progress mb-1" style="height: 6px;">';
                                        echo '<div class="progress-bar ' . $progress_class . '" role="progressbar" style="width: ' . min($credit_ratio, 100) . '%"></div>';
                                        echo '</div>';
                                        echo '<div class="d-flex justify-content-between">';
                                        echo '<small class="text-muted">Credit Limit:</small>';
                                        echo '<small class="text-muted">₹' . number_format($branch['credit_limit'], 2) . '</small>';
                                        echo '</div>';
                                        echo '</div>';
                                    }
                                } else {
                                    echo '<div class="text-center py-3">';
                                    echo '<i class="fas fa-credit-card fa-2x text-muted mb-2"></i>';
                                    echo '<p class="text-muted">No branch credits found</p>';
                                    echo '</div>';
                                }
                                ?>
                                
                                <hr>
                                
                                
                                <h6 class="mb-3"><i class="fas fa-money-bill-wave me-2"></i>Record Credit Payment</h6>
                                <form method="POST" action="" id="creditPaymentForm">
                                    <input type="hidden" name="transfer_type" value="credit_payment">
                                    
                                    <div class="mb-3">
                                        <label for="branch_id" class="form-label">Branch <span class="text-danger">*</span></label>
                                        <select class="form-select" id="branch_id" name="branch_id" required onchange="updateMaxPayment()">
                                            <option value="">Select Branch</option>
                                            <?php
                                            $credits_result->data_seek(0);
                                            while($branch = $credits_result->fetch_assoc()) {
                                                $credit_display = $branch['current_credit'] > 0 ? ' (Due: ₹' . number_format($branch['current_credit'], 2) . ')' : ' (No Credit Due)';
                                                echo '<option value="' . $branch['id'] . '" data-credit="' . $branch['current_credit'] . '">' . 
                                                     htmlspecialchars($branch['branch_name']) . $credit_display . '</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="payment_amount" class="form-label">Payment Amount (₹) <span class="text-danger">*</span></label>
                                        <input type="number" step="0.01" min="0" class="form-control" id="payment_amount" name="payment_amount" required>
                                        <div class="form-text">Max: ₹<span id="maxPayment">0.00</span></div>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="payment_date" class="form-label">Payment Date</label>
                                                <input type="date" class="form-control" id="payment_date" name="payment_date" 
                                                       value="<?php echo date('Y-m-d'); ?>">
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="payment_method" class="form-label">Method</label>
                                                <select class="form-select" id="payment_method" name="payment_method">
                                                    <option value="cash">Cash</option>
                                                    <option value="bank_transfer">Bank Transfer</option>
                                                    <option value="cheque">Cheque</option>
                                                    <option value="upi">UPI</option>
                                                    <option value="card">Card</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="reference_number" class="form-label">Reference Number</label>
                                        <input type="text" class="form-control" id="reference_number" name="reference_number" 
                                               placeholder="Transaction ID, Cheque No., etc.">
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="payment_notes" class="form-label">Notes</label>
                                        <textarea class="form-control" id="payment_notes" name="payment_notes" rows="2" placeholder="Payment details..."></textarea>
                                    </div>
                                    
                                    <div class="d-grid">
                                        <button type="submit" class="btn btn-success">
                                            <i class="fas fa-money-bill-wave me-2"></i>Record Payment
                                        </button>
                                    </div>
                                </form>
                            </div>
                        </div>
                        
                        
                        <div class="card mt-4">
                            <div class="card-header">
                                <h5 class="card-title mb-0">
                                    <i class="fas fa-exchange-alt me-2"></i>Recent Credit Transactions
                                </h5>
                            </div>
                            <div class="card-body">
                                <?php
                                $transactions_sql = "SELECT bct.*, b.branch_name 
                                                   FROM branch_credit_transactions bct
                                                   JOIN branches b ON bct.branch_id = b.id
                                                   ORDER BY bct.created_at DESC LIMIT 5";
                                $transactions_result = $conn->query($transactions_sql);
                                
                                if ($transactions_result && $transactions_result->num_rows > 0) {
                                    echo '<div class="table-responsive">';
                                    echo '<table class="table table-sm">';
                                    echo '<tbody>';
                                    
                                    while($transaction = $transactions_result->fetch_assoc()) {
                                        $badge_class = $transaction['transaction_type'] == 'payment_received' ? 'bg-success' : 'bg-primary';
                                        $icon = $transaction['transaction_type'] == 'payment_received' ? 'fa-arrow-down' : 'fa-arrow-up';
                                        $sign = $transaction['transaction_type'] == 'payment_received' ? '-' : '+';
                                        
                                        echo '<tr>';
                                        echo '<td>';
                                        echo '<div class="d-flex align-items-center">';
                                        echo '<div class="flex-shrink-0 me-2">';
                                        echo '<span class="badge ' . $badge_class . ' p-2"><i class="fas ' . $icon . '"></i></span>';
                                        echo '</div>';
                                        echo '<div class="flex-grow-1">';
                                        echo '<small class="d-block">' . htmlspecialchars($transaction['branch_name']) . '</small>';
                                        echo '<small class="text-muted">' . date('d M, H:i', strtotime($transaction['created_at'])) . '</small>';
                                        echo '</div>';
                                        echo '</div>';
                                        echo '</td>';
                                        echo '<td class="text-end">';
                                        echo '<strong class="' . ($transaction['transaction_type'] == 'payment_received' ? 'text-success' : 'text-primary') . '">';
                                        echo $sign . ' ₹' . number_format($transaction['amount'], 2) . '</strong><br>';
                                        echo '<small class="text-muted">' . ucfirst(str_replace('_', ' ', $transaction['transaction_type'])) . '</small>';
                                        echo '</td>';
                                        echo '</tr>';
                                    }
                                    
                                    echo '</tbody></table></div>';
                                } else {
                                    echo '<div class="text-center py-3">';
                                    echo '<i class="fas fa-exchange-alt fa-2x text-muted mb-2"></i>';
                                    echo '<p class="text-muted">No credit transactions yet</p>';
                                    echo '</div>';
                                }
                                ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

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

// Show loading overlay
function showLoading() {
    document.getElementById('transferLoading').classList.add('show');
}

// Hide loading overlay
function hideLoading() {
    document.getElementById('transferLoading').classList.remove('show');
}

// Reset form
function resetForm() {
    // Clear all checkboxes
    document.querySelectorAll('.product-checkbox').forEach(checkbox => {
        checkbox.checked = false;
        const productId = checkbox.value;
        const quantityInput = document.getElementById(`quantity_${productId}`);
        if (quantityInput) {
            quantityInput.disabled = true;
            quantityInput.value = '';
        }
        const productRow = checkbox.closest('.product-row');
        if (productRow) productRow.classList.remove('selected');
    });
    calculateTotal();
    document.getElementById('notes').value = '';
    showToast('Form reset successfully', 'info');
}

// Escape HTML to prevent XSS
function escapeHtml(text) {
    if (!text) return '';
    const div = document.createElement('div');
    div.textContent = text;
    return div.innerHTML;
}

// Highlight search term in text
function highlightText(text, searchTerm) {
    if (!searchTerm || !text) return escapeHtml(text);
    const regex = new RegExp(`(${escapeRegex(searchTerm)})`, 'gi');
    return escapeHtml(text).replace(regex, '<span class="search-highlight">$1</span>');
}

// Escape regex special characters
function escapeRegex(string) {
    return string.replace(/[.*+?^${}()|[\]\\]/g, '\\$&');
}

// Load products for selected branch
function loadProducts() {
    const branchId = document.getElementById('from_branch_id').value;
    const productsContainer = document.getElementById('productsContainer');
    
    if (!branchId) {
        productsContainer.innerHTML = `
            <div class="text-center py-4">
                <i class="fas fa-box-open fa-2x text-muted mb-3"></i>
                <p class="text-muted">Select a source branch to view products</p>
            </div>
        `;
        allProductsData = [];
        return;
    }
    
    currentBranchId = branchId;
    
    // Show loading
    productsContainer.innerHTML = `
        <div class="text-center py-4">
            <div class="spinner-border text-primary" role="status">
                <span class="visually-hidden">Loading...</span>
            </div>
            <p class="text-muted mt-2">Loading products from branch...</p>
        </div>
    `;
    
    // Fetch products via AJAX
    fetch(`ajax/get-branch-products.php?branch_id=${branchId}&t=${Date.now()}`)
        .then(response => {
            if (!response.ok) {
                throw new Error('Network response was not ok: ' + response.status);
            }
            return response.json();
        })
        .then(data => {
            if (data.error) {
                productsContainer.innerHTML = `
                    <div class="alert alert-danger m-3">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        ${data.error}
                    </div>
                `;
                allProductsData = [];
            } else if (data.products && data.products.length > 0) {
                allProductsData = data.products;
                renderProductsList(allProductsData);
            } else {
                productsContainer.innerHTML = `
                    <div class="text-center py-4">
                        <i class="fas fa-box-open fa-2x text-muted mb-3"></i>
                        <p class="text-muted">No products found in this branch</p>
                    </div>
                `;
                allProductsData = [];
            }
        })
        .catch(error => {
            console.error('Error loading products:', error);
            productsContainer.innerHTML = `
                <div class="alert alert-danger m-3">
                    <i class="fas fa-exclamation-triangle me-2"></i>
                    Error loading products: ${error.message}
                </div>
            `;
            allProductsData = [];
        });
}

// Render products list
function renderProductsList(products) {
    const productsContainer = document.getElementById('productsContainer');
    
    if (!products || products.length === 0) {
        productsContainer.innerHTML = `
            <div class="text-center py-4">
                <i class="fas fa-box-open fa-2x text-muted mb-3"></i>
                <p class="text-muted">No products found in this branch</p>
            </div>
        `;
        return;
    }
    
    let html = '<div class="list-group">';
    
    products.forEach((product) => {
        // Determine product type based on IMEI/Serial
        let productType = 'none';
        let imeiDisplay = '';
        let serialDisplay = '';
        let typeBadge = '';
        
        if (product.imei_number_1 || product.imei_number_2) {
            if (product.serial_number) {
                productType = 'both';
                typeBadge = '<span class="badge both-badge ms-2">IMEI + Serial</span>';
            } else {
                productType = 'imei';
                typeBadge = '<span class="badge imei-badge ms-2">IMEI</span>';
            }
        } else if (product.serial_number) {
            productType = 'serial';
            typeBadge = '<span class="badge serial-badge ms-2">Serial</span>';
        }
        
        // Build IMEI display
        if (productType === 'imei' || productType === 'both') {
            if (product.imei_number_1) {
                imeiDisplay += `
                    <div class="imei-display mt-1">
                        <i class="fas fa-microchip me-1"></i>
                        <span class="text-muted">IMEI 1:</span> 
                        <span class="imei-value">${escapeHtml(product.imei_number_1)}</span>
                    </div>
                `;
            }
            if (product.imei_number_2) {
                imeiDisplay += `
                    <div class="imei-display mt-1">
                        <i class="fas fa-microchip me-1"></i>
                        <span class="text-muted">IMEI 2:</span> 
                        <span class="imei-value">${escapeHtml(product.imei_number_2)}</span>
                    </div>
                `;
            }
        }
        
        // Build Serial display
        if (productType === 'serial' || productType === 'both') {
            if (product.serial_number) {
                serialDisplay = `
                    <div class="serial-display mt-1">
                        <i class="fas fa-barcode me-1"></i>
                        <span class="text-muted">Serial:</span> 
                        <span class="serial-value">${escapeHtml(product.serial_number)}</span>
                    </div>
                `;
            }
        }
        
        html += `
            <div class="list-group-item product-row" data-product-id="${product.id}" data-stock="${product.stock_quantity}">
                <div class="d-flex justify-content-between align-items-start">
                    <div class="flex-grow-1">
                        <div class="d-flex align-items-center">
                            <input type="checkbox" class="form-check-input product-checkbox me-3" 
                                   value="${product.id}" id="product_${product.id}" 
                                   onchange="toggleProductSelection(this)">
                            <div>
                                <div class="d-flex align-items-center flex-wrap">
                                    <strong class="product-name">${escapeHtml(product.product_name)}</strong>
                                    ${typeBadge}
                                    <small class="product-meta-info ms-2">
                                        ${product.brand_name ? escapeHtml(product.brand_name) + ' - ' : ''}${escapeHtml(product.model)}
                                    </small>
                                </div>
                                <div class="product-detail-info mt-2">
                                    ${imeiDisplay}
                                    ${serialDisplay}
                                </div>
                                <div class="product-meta-info mt-2">
                                    <span class="badge bg-secondary me-2">Purchase: ₹${parseFloat(product.purchase_price).toFixed(2)}</span>
                                    <span class="badge bg-info me-2">Selling: ₹${parseFloat(product.selling_price).toFixed(2)}</span>
                                    <span class="badge bg-warning">Stock: ${product.stock_quantity}</span>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="quantity-section ms-3" style="min-width: 150px;">
                        <label class="form-label small mb-1">Transfer Quantity</label>
                        <div class="input-group input-group-sm">
                            <button class="btn btn-outline-secondary" type="button" onclick="updateQuantity('${product.id}', -1)">-</button>
                            <input type="number" class="form-control text-center quantity-input" 
                                   id="quantity_${product.id}" 
                                   value="" min="1" max="${product.stock_quantity}" 
                                   step="1" disabled onchange="updateProductQuantity(this, ${product.stock_quantity}, ${parseFloat(product.purchase_price)})">
                            <button class="btn btn-outline-secondary" type="button" onclick="updateQuantity('${product.id}', 1)">+</button>
                        </div>
                        <input type="hidden" id="unit_price_${product.id}" value="${product.purchase_price}">
                        <input type="hidden" id="stock_${product.id}" value="${product.stock_quantity}">
                        <small class="text-muted" id="stock_info_${product.id}">Available: ${product.stock_quantity}</small>
                    </div>
                </div>
            </div>
        `;
    });
    
    html += '</div>';
    productsContainer.innerHTML = html;
    initializeProductListeners();
    calculateTotal();
}

// Update quantity with buttons
function updateQuantity(productId, change) {
    const quantityInput = document.getElementById(`quantity_${productId}`);
    if (!quantityInput || quantityInput.disabled) return;
    
    let currentValue = parseInt(quantityInput.value) || 0;
    const maxValue = parseInt(quantityInput.max) || 0;
    let newValue = currentValue + change;
    
    if (newValue < 1) newValue = 1;
    if (newValue > maxValue) newValue = maxValue;
    
    quantityInput.value = newValue;
    updateProductQuantity(quantityInput, maxValue, parseFloat(document.getElementById(`unit_price_${productId}`).value));
}

// Update product quantity and recalculate
function updateProductQuantity(input, maxStock, unitPrice) {
    let quantity = parseInt(input.value) || 0;
    
    if (quantity > maxStock) {
        quantity = maxStock;
        input.value = maxStock;
        showToast(`Maximum available stock is ${maxStock}`, 'warning');
    } else if (quantity < 1 && quantity !== '') {
        quantity = 1;
        input.value = 1;
    }
    
    calculateTotal();
}

// Toggle product selection
function toggleProductSelection(checkbox) {
    const productId = checkbox.value;
    const quantityInput = document.getElementById(`quantity_${productId}`);
    const productRow = checkbox.closest('.product-row');
    
    if (checkbox.checked) {
        quantityInput.disabled = false;
        quantityInput.value = 1;
        productRow.classList.add('selected');
    } else {
        quantityInput.disabled = true;
        quantityInput.value = '';
        productRow.classList.remove('selected');
    }
    
    calculateTotal();
}

// Initialize product event listeners
function initializeProductListeners() {
    const checkboxes = document.querySelectorAll('.product-checkbox');
    checkboxes.forEach(checkbox => {
        checkbox.removeEventListener('change', toggleProductSelection);
        checkbox.addEventListener('change', function() {
            toggleProductSelection(this);
        });
    });
    
    const quantityInputs = document.querySelectorAll('.quantity-input');
    quantityInputs.forEach(input => {
        input.removeEventListener('input', handleQuantityInput);
        input.addEventListener('input', handleQuantityInput);
    });
}

// Calculate total transfer value
function calculateTotal() {
    const checkboxes = document.querySelectorAll('.product-checkbox:checked');
    let totalValue = 0;
    let totalItems = 0;
    
    checkboxes.forEach(checkbox => {
        const productId = checkbox.value;
        const quantityInput = document.getElementById(`quantity_${productId}`);
        if (quantityInput && !quantityInput.disabled) {
            const unitPrice = parseFloat(document.getElementById(`unit_price_${productId}`).value);
            const quantity = parseInt(quantityInput.value) || 0;
            
            if (quantity > 0) {
                totalValue += unitPrice * quantity;
                totalItems += quantity;
            }
        }
    });
    
    document.getElementById('totalValue').textContent = '₹' + totalValue.toFixed(2);
    document.getElementById('totalItems').textContent = totalItems;
}

// Global search function
function performGlobalSearch() {
    const searchTerm = document.getElementById('globalSearch').value.trim();
    const searchResultsDropdown = document.getElementById('searchResultsDropdown');
    
    if (!searchTerm || searchTerm.length < 2) {
        searchResultsDropdown.classList.remove('show');
        return;
    }
    
    if (!allProductsData.length) {
        searchResultsDropdown.innerHTML = '<div class="no-results">No products loaded. Please select a branch first.</div>';
        searchResultsDropdown.classList.add('show');
        return;
    }
    
    const searchLower = searchTerm.toLowerCase();
    const results = [];
    
    allProductsData.forEach(product => {
        let matchType = null;
        
        if (product.imei_number_1 && product.imei_number_1.toLowerCase().includes(searchLower)) {
            matchType = 'imei';
        } else if (product.imei_number_2 && product.imei_number_2.toLowerCase().includes(searchLower)) {
            matchType = 'imei';
        } else if (product.serial_number && product.serial_number.toLowerCase().includes(searchLower)) {
            matchType = 'serial';
        } else if (product.product_name && product.product_name.toLowerCase().includes(searchLower)) {
            matchType = 'product';
        } else if (product.model && product.model.toLowerCase().includes(searchLower)) {
            matchType = 'model';
        } else if (product.brand_name && product.brand_name.toLowerCase().includes(searchLower)) {
            matchType = 'brand';
        }
        
        if (matchType) {
            results.push({ ...product, matchType: matchType });
        }
    });
    
    if (results.length === 0) {
        searchResultsDropdown.innerHTML = `
            <div class="no-results">
                <i class="fas fa-search me-2"></i>
                No products found matching "${escapeHtml(searchTerm)}"
            </div>
        `;
    } else {
        let resultsHtml = '';
        results.forEach(product => {
            const matchClass = `match-${product.matchType}`;
            let matchTypeLabel = '';
            switch(product.matchType) {
                case 'imei': matchTypeLabel = 'IMEI'; break;
                case 'serial': matchTypeLabel = 'Serial'; break;
                case 'product': matchTypeLabel = 'Product'; break;
                case 'model': matchTypeLabel = 'Model'; break;
                case 'brand': matchTypeLabel = 'Brand'; break;
            }
            
            let highlightedName = highlightText(product.product_name, searchTerm);
            let highlightedModel = highlightText(product.model, searchTerm);
            let highlightedBrand = highlightText(product.brand_name, searchTerm);
            
            const stockBadge = product.stock_quantity > 0 ? 
                `<span class="badge bg-success">Stock: ${product.stock_quantity}</span>` : 
                `<span class="badge bg-danger">Out of Stock</span>`;
            
            resultsHtml += `
                <div class="search-result-item" onclick="quickAddProductToTransfer(${product.id})">
                    <div class="d-flex justify-content-between align-items-start">
                        <div class="flex-grow-1">
                            <div class="d-flex align-items-center flex-wrap gap-2 mb-1">
                                <strong>${highlightedName}</strong>
                                <span class="search-match-type ${matchClass}">${matchTypeLabel} Match</span>
                            </div>
                            <div class="small text-muted mb-1">
                                ${highlightedBrand ? highlightedBrand + ' - ' : ''}${highlightedModel}
                            </div>
                        </div>
                        <div class="text-end ms-3">
                            <div class="fw-bold">₹${parseFloat(product.purchase_price).toFixed(2)}</div>
                            ${stockBadge}
                            <button class="btn btn-sm btn-primary mt-2 quick-add-btn" onclick="event.stopPropagation(); quickAddProductToTransfer(${product.id})">
                                <i class="fas fa-arrow-right me-1"></i>Add
                            </button>
                        </div>
                    </div>
                </div>
            `;
        });
        
        searchResultsDropdown.innerHTML = resultsHtml;
    }
    
    searchResultsDropdown.classList.add('show');
}

// Quick add product to transfer list
function quickAddProductToTransfer(productId) {
    const product = allProductsData.find(p => p.id == productId);
    if (!product) return;
    
    const existingCheckbox = document.getElementById(`product_${productId}`);
    if (existingCheckbox && existingCheckbox.checked) {
        showToast('Product is already selected for transfer', 'info');
        const productRow = existingCheckbox.closest('.product-row');
        if (productRow) {
            productRow.scrollIntoView({ behavior: 'smooth', block: 'center' });
        }
        return;
    }
    
    if (existingCheckbox) {
        existingCheckbox.checked = true;
        const quantityInput = document.getElementById(`quantity_${productId}`);
        if (quantityInput) {
            quantityInput.disabled = false;
            quantityInput.value = 1;
        }
        const productRow = existingCheckbox.closest('.product-row');
        if (productRow) productRow.classList.add('selected');
        calculateTotal();
        showToast(`Added ${product.product_name} to transfer list`, 'success');
        productRow.scrollIntoView({ behavior: 'smooth', block: 'center' });
    }
    
    document.getElementById('globalSearch').value = '';
    document.getElementById('searchResultsDropdown').classList.remove('show');
}

// Update max payment
function updateMaxPayment() {
    const branchSelect = document.getElementById('branch_id');
    const selectedOption = branchSelect.options[branchSelect.selectedIndex];
    const maxPayment = selectedOption.getAttribute('data-credit') || 0;
    
    document.getElementById('maxPayment').textContent = parseFloat(maxPayment).toFixed(2);
    document.getElementById('payment_amount').max = maxPayment;
    if (maxPayment > 0) {
        document.getElementById('payment_amount').value = maxPayment;
    }
}

// Select all products
function selectAllProducts(selectAll) {
    const checkboxes = document.querySelectorAll('.product-checkbox');
    checkboxes.forEach(checkbox => {
        checkbox.checked = selectAll.checked;
        toggleProductSelection(checkbox);
    });
    calculateTotal();
}

// Show toast notification
function showToast(message, type = 'info') {
    const toast = document.createElement('div');
    toast.className = `alert alert-${type} alert-dismissible fade show position-fixed bottom-0 end-0 m-3`;
    toast.style.zIndex = '9999';
    toast.style.minWidth = '300px';
    toast.innerHTML = `
        <i class="fas fa-${type === 'success' ? 'check-circle' : type === 'warning' ? 'exclamation-triangle' : 'info-circle'} me-2"></i>
        ${message}
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
    `;
    document.body.appendChild(toast);
    
    setTimeout(() => {
        toast.remove();
    }, 3000);
}

// Form validation and submission
const transferForm = document.getElementById('transferForm');
if (transferForm) {
    transferForm.addEventListener('submit', function(e) {
        const fromBranch = document.getElementById('from_branch_id').value;
        const toBranch = document.getElementById('to_branch_id').value;
        const checkboxes = document.querySelectorAll('.product-checkbox:checked');
        
        if (!fromBranch || !toBranch) {
            e.preventDefault();
            showToast('Please select both source and destination branches', 'warning');
            return false;
        }
        
        if (fromBranch === toBranch) {
            e.preventDefault();
            showToast('Source and destination branches cannot be the same', 'warning');
            return false;
        }
        
        if (checkboxes.length === 0) {
            e.preventDefault();
            showToast('Please select at least one product to transfer', 'warning');
            return false;
        }
        
        let hasValidQuantity = false;
        let productIds = [];
        let quantities = [];
        
        checkboxes.forEach(checkbox => {
            const productId = checkbox.value;
            const quantityInput = document.getElementById(`quantity_${productId}`);
            if (quantityInput && !quantityInput.disabled) {
                const quantity = parseInt(quantityInput.value) || 0;
                if (quantity > 0) {
                    hasValidQuantity = true;
                    productIds.push(productId);
                    quantities.push(quantity);
                }
            }
        });
        
        if (!hasValidQuantity) {
            e.preventDefault();
            showToast('Please enter quantity for selected products', 'warning');
            return false;
        }
        
        // Remove any existing hidden inputs
        const existingProductIds = document.querySelectorAll('input[name="product_ids[]"]');
        existingProductIds.forEach(input => input.remove());
        
        const existingQuantities = document.querySelectorAll('input[name="quantities[]"]');
        existingQuantities.forEach(input => input.remove());
        
        // Add new hidden inputs
        productIds.forEach(productId => {
            const input = document.createElement('input');
            input.type = 'hidden';
            input.name = 'product_ids[]';
            input.value = productId;
            transferForm.appendChild(input);
        });
        
        quantities.forEach(quantity => {
            const input = document.createElement('input');
            input.type = 'hidden';
            input.name = 'quantities[]';
            input.value = quantity;
            transferForm.appendChild(input);
        });
        
        showLoading();
        return true;
    });
}

// Credit payment validation
const creditPaymentForm = document.getElementById('creditPaymentForm');
if (creditPaymentForm) {
    creditPaymentForm.addEventListener('submit', function(e) {
        const branchId = document.getElementById('branch_id').value;
        const paymentAmount = parseFloat(document.getElementById('payment_amount').value) || 0;
        const maxPayment = parseFloat(document.getElementById('maxPayment').textContent) || 0;
        
        if (!branchId) {
            e.preventDefault();
            showToast('Please select a branch', 'warning');
            return false;
        }
        
        if (paymentAmount <= 0) {
            e.preventDefault();
            showToast('Payment amount must be greater than zero', 'warning');
            return false;
        }
        
        if (paymentAmount > maxPayment) {
            e.preventDefault();
            showToast(`Payment amount cannot exceed due amount (₹${maxPayment.toFixed(2)})`, 'warning');
            return false;
        }
        
        showLoading();
        return true;
    });
}

// Hide loading when page loads (after form submission)
window.addEventListener('load', function() {
    hideLoading();
});

// Search input event
const globalSearch = document.getElementById('globalSearch');
if (globalSearch) {
    let searchTimeout;
    globalSearch.addEventListener('input', function() {
        if (searchTimeout) clearTimeout(searchTimeout);
        searchTimeout = setTimeout(() => {
            performGlobalSearch();
        }, 300);
    });
    
    document.addEventListener('click', function(e) {
        const searchContainer = document.querySelector('.search-container');
        if (searchContainer && !searchContainer.contains(e.target)) {
            document.getElementById('searchResultsDropdown').classList.remove('show');
        }
    });
}

// Initialize on page load
document.addEventListener('DOMContentLoaded', function() {
    const today = new Date().toISOString().split('T')[0];
    const transferDate = document.getElementById('transfer_date');
    const paymentDate = document.getElementById('payment_date');
    
    if (transferDate) transferDate.max = today;
    if (paymentDate) paymentDate.max = today;
    
    // Load products for default selected branch
    const fromBranchSelect = document.getElementById('from_branch_id');
    if (fromBranchSelect && fromBranchSelect.value) {
        loadProducts();
    }
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: branch-transfer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation