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: view-transfer.php

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

// Check if transfer ID is provided
$transfer_id = isset($_GET['id']) ? intval($_GET['id']) : 0;

if (!$transfer_id) {
    // If no ID provided, check if we're viewing all transfers
    if (isset($_GET['view']) && $_GET['view'] == 'all') {
        // Show all transfers
        showAllTransfers($conn);
        exit();
    } else {
        header('Location: branch-transfer.php');
        exit();
    }
}

// Get transfer details
$transfer_sql = "SELECT bt.*, 
                 fb.branch_name as from_branch, fb.branch_code as from_code,
                 tb.branch_name as to_branch, tb.branch_code as to_code
                 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
                 WHERE bt.id = $transfer_id";
$transfer_result = $conn->query($transfer_sql);

if ($transfer_result->num_rows == 0) {
    // Transfer not found
    $_SESSION['error'] = 'Transfer not found';
    header('Location: branch-transfer.php');
    exit();
}

$transfer = $transfer_result->fetch_assoc();

// Get transfer items
$items_sql = "SELECT * FROM branch_transfer_items WHERE transfer_id = $transfer_id ORDER BY id";
$items_result = $conn->query($items_sql);
$total_items = $items_result->num_rows;

// Get branch credit information for source branch
$credit_sql = "SELECT * FROM branch_credits WHERE branch_id = " . $transfer['from_branch_id'];
$credit_result = $conn->query($credit_sql);
$credit = $credit_result->num_rows > 0 ? $credit_result->fetch_assoc() : null;

// Get all credit transactions for this branch (for payment history)
$all_trans_sql = "SELECT * FROM branch_credit_transactions 
                  WHERE branch_id = " . $transfer['from_branch_id'] . "
                  ORDER BY created_at DESC";
$all_trans_result = $conn->query($all_trans_sql);

// Get payments specifically for this transfer
$transfer_payments_sql = "SELECT * FROM branch_credit_transactions 
                          WHERE branch_id = " . $transfer['from_branch_id'] . "
                          AND transaction_type = 'payment_received'
                          AND (reference_id = $transfer_id OR description LIKE '%transfer%')
                          ORDER BY created_at DESC";
$transfer_payments_result = $conn->query($transfer_payments_sql);

// Calculate payment statistics
$total_paid = 0;
$total_transfers = 0;
$outstanding_balance = 0;

if ($credit) {
    $outstanding_balance = $credit['current_credit'];
    
    // Calculate total payments made
    $payment_stats_sql = "SELECT 
                         SUM(CASE WHEN transaction_type = 'payment_received' THEN amount ELSE 0 END) as total_paid,
                         SUM(CASE WHEN transaction_type = 'product_transfer' THEN amount ELSE 0 END) as total_transfers
                         FROM branch_credit_transactions 
                         WHERE branch_id = " . $transfer['from_branch_id'];
    $stats_result = $conn->query($payment_stats_sql);
    if ($stats_result && $stats_row = $stats_result->fetch_assoc()) {
        $total_paid = $stats_row['total_paid'] ?: 0;
        $total_transfers = $stats_row['total_transfers'] ?: 0;
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8" />
    <title><?php echo $transfer_id ? 'Transfer Details' : 'All Transfers'; ?> - VK Mobiles</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" />
</head>

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

<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">
                                <?php if ($transfer_id): ?>
                                <i class="fas fa-exchange-alt me-2"></i>Transfer Details
                                <?php else: ?>
                                <i class="fas fa-list me-2"></i>All Transfers
                                <?php endif; ?>
                            </h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="branch-transfer.php">Transfer</a></li>
                                    <li class="breadcrumb-item active">
                                        <?php if ($transfer_id): ?>
                                        Details
                                        <?php else: ?>
                                        All Transfers
                                        <?php endif; ?>
                                    </li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php
                // Display any session messages
                if (isset($_SESSION['success'])) {
                    echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                            <i class="fas fa-check-circle me-2"></i>' . htmlspecialchars($_SESSION['success']) . '
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                          </div>';
                    unset($_SESSION['success']);
                }
                
                if (isset($_SESSION['error'])) {
                    echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                            <i class="fas fa-exclamation-triangle me-2"></i>' . htmlspecialchars($_SESSION['error']) . '
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                          </div>';
                    unset($_SESSION['error']);
                }
                
                // If we're viewing all transfers, show the table and exit
                if (!$transfer_id && isset($_GET['view']) && $_GET['view'] == 'all') {
                    showAllTransfers($conn);
                    exit();
                }
                ?>

<div class="row">
                    
                    <div class="col-lg-8">
                        
                        <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-info-circle me-2"></i>Transfer Information
                                    </h5>
                                    <div class="d-flex gap-2">
                                        <span class="badge bg-<?php 
                                            echo $transfer['status'] == 'completed' ? 'success' : 
                                                 ($transfer['status'] == 'pending' ? 'warning' : 
                                                 ($transfer['status'] == 'in_transit' ? 'info' : 'danger')); 
                                        ?> fs-6">
                                            <?php echo ucfirst($transfer['status']); ?>
                                        </span>
                                        <?php if ($transfer['status'] != 'cancelled'): ?>
                                        <a href="update-transfer-status.php?id=<?php echo $transfer_id; ?>&status=cancelled" 
                                           class="btn btn-danger btn-sm" 
                                           onclick="return confirm('Are you sure you want to cancel this transfer?')">
                                            <i class="fas fa-times me-1"></i>Cancel
                                        </a>
                                        <?php endif; ?>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-6">
                                        <table class="table table-sm table-borderless">
                                            <tr>
                                                <th width="40%" class="text-muted">Transfer Number:</th>
                                                <td>
                                                    <strong class="text-primary"><?php echo $transfer['transfer_number']; ?></strong>
                                                    <?php if ($transfer['status'] == 'completed'): ?>
                                                        <span class="badge bg-success ms-2"><i class="fas fa-check"></i></span>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th class="text-muted">From Branch:</th>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($transfer['from_branch']); ?></strong>
                                                    <small class="text-muted">(<?php echo $transfer['from_code']; ?>)</small>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th class="text-muted">To Branch:</th>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($transfer['to_branch']); ?></strong>
                                                    <small class="text-muted">(<?php echo $transfer['to_code']; ?>)</small>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th class="text-muted">Transfer Date:</th>
                                                <td>
                                                    <i class="fas fa-calendar me-1 text-muted"></i>
                                                    <?php echo date('d M Y', strtotime($transfer['transfer_date'])); ?>
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                    <div class="col-md-6">
                                        <table class="table table-sm table-borderless">
                                            <tr>
                                                <th width="40%" class="text-muted">Total Value:</th>
                                                <td class="fw-bold fs-5 text-primary">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($transfer['total_value'], 2); ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th class="text-muted">Credit Generated:</th>
                                                <td class="fw-bold text-danger">
                                                    <i class="fas fa-credit-card me-1"></i>
                                                    <?php echo number_format($transfer['total_value'], 2); ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th class="text-muted">Created By:</th>
                                                <td>Admin</td>
                                            </tr>
                                            <tr>
                                                <th class="text-muted">Created At:</th>
                                                <td>
                                                    <i class="fas fa-clock me-1 text-muted"></i>
                                                    <?php echo date('d M Y H:i:s', strtotime($transfer['created_at'])); ?>
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>
                                
                                <?php if (!empty($transfer['notes'])): ?>
                                <div class="alert alert-info mt-3">
                                    <div class="d-flex">
                                        <div class="flex-shrink-0 me-3">
                                            <i class="fas fa-sticky-note fa-lg"></i>
                                        </div>
                                        <div class="flex-grow-1">
                                            <h6 class="alert-heading mb-2">Transfer Notes</h6>
                                            <p class="mb-0"><?php echo nl2br(htmlspecialchars($transfer['notes'])); ?></p>
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                        
                        
                        <div class="card mt-4">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-boxes me-2"></i>Transferred Products
                                        <span class="badge bg-primary ms-2"><?php echo $total_items; ?> Items</span>
                                    </h5>
                                    <button type="button" onclick="printTransfer()" class="btn btn-outline-primary btn-sm">
                                        <i class="fas fa-print me-1"></i>Print
                                    </button>
                                </div>
                            </div>
                            <div class="card-body">
                                <?php if ($total_items > 0): ?>
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th width="50">#</th>
                                                <th>Product Name</th>
                                                <th class="text-center">Quantity</th>
                                                <th class="text-end">Unit Price</th>
                                                <th class="text-end">Total Value</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php 
                                            $counter = 1;
                                            $total_quantity = 0;
                                            $items_result->data_seek(0);
                                            while($item = $items_result->fetch_assoc()): 
                                                $total_quantity += $item['quantity'];
                                            ?>
                                            <tr>
                                                <td class="text-muted"><?php echo $counter++; ?></td>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($item['product_name']); ?></strong>
                                                </td>
                                                <td class="text-center">
                                                    <span class="badge bg-info rounded-pill px-3 py-1">
                                                        <?php echo $item['quantity']; ?>
                                                    </span>
                                                </td>
                                                <td class="text-end">
                                                    <small class="text-muted">₹</small>
                                                    <?php echo number_format($item['unit_value'], 2); ?>
                                                </td>
                                                <td class="text-end fw-bold">
                                                    <small class="text-muted">₹</small>
                                                    <?php echo number_format($item['total_value'], 2); ?>
                                                </td>
                                            </tr>
                                            <?php endwhile; ?>
                                            <tr class="table-active">
                                                <td colspan="2" class="fw-bold">Total</td>
                                                <td class="text-center fw-bold">
                                                    <span class="badge bg-primary rounded-pill px-3 py-1">
                                                        <?php echo $total_quantity; ?>
                                                    </span>
                                                </td>
                                                <td class="text-end fw-bold text-muted">-</td>
                                                <td class="text-end fw-bold fs-5 text-primary">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($transfer['total_value'], 2); ?>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                                <?php else: ?>
                                <div class="text-center py-5">
                                    <i class="fas fa-box-open fa-3x text-muted mb-3"></i>
                                    <h5 class="text-muted">No products found for this transfer</h5>
                                    <p class="text-muted">This transfer doesn't contain any products.</p>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                        
                        
                        <div class="card mt-4">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-history me-2"></i>Payment History
                                        <span class="badge bg-info ms-2"><?php echo $transfer_payments_result->num_rows; ?> Payments</span>
                                    </h5>
                                    <a href="add-payment.php?branch_id=<?php echo $transfer['from_branch_id']; ?>&transfer_id=<?php echo $transfer_id; ?>" 
                                       class="btn btn-success btn-sm">
                                        <i class="fas fa-plus me-1"></i>Add Payment
                                    </a>
                                </div>
                            </div>
                            <div class="card-body">
                                <?php if ($transfer_payments_result->num_rows > 0): ?>
                                <div class="table-responsive">
                                    <table class="table table-hover mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th width="80">Date</th>
                                                <th>Payment Details</th>
                                                <th class="text-center">Method</th>
                                                <th class="text-end">Amount</th>
                                                <th class="text-center">Reference</th>
                                                <th width="100">Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php 
                                            $total_payments = 0;
                                            $transfer_payments_result->data_seek(0);
                                            while($payment = $transfer_payments_result->fetch_assoc()): 
                                                $total_payments += $payment['amount'];
                                            ?>
                                            <tr>
                                                <td>
                                                    <small class="d-block"><?php echo date('d M Y', strtotime($payment['created_at'])); ?></small>
                                                    <small class="text-muted"><?php echo date('h:i A', strtotime($payment['created_at'])); ?></small>
                                                </td>
                                                <td>
                                                    <div class="d-flex align-items-start">
                                                        <div class="flex-shrink-0 me-3">
                                                            <span class="badge bg-success p-2 rounded-circle">
                                                                <i class="fas fa-arrow-down"></i>
                                                            </span>
                                                        </div>
                                                        <div class="flex-grow-1">
                                                            <small class="d-block fw-medium">Payment Received</small>
                                                            <?php if (!empty($payment['description'])): ?>
                                                            <small class="text-muted"><?php echo htmlspecialchars($payment['description']); ?></small>
                                                            <?php endif; ?>
                                                            <?php if (!empty($payment['notes'])): ?>
                                                            <br><small class="text-muted"><i><?php echo htmlspecialchars($payment['notes']); ?></i></small>
                                                            <?php endif; ?>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td class="text-center">
                                                    <span class="badge bg-primary">
                                                        <?php echo !empty($payment['payment_method']) ? ucfirst($payment['payment_method']) : 'N/A'; ?>
                                                    </span>
                                                </td>
                                                <td class="text-end fw-bold text-success">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($payment['amount'], 2); ?>
                                                </td>
                                                <td class="text-center">
                                                    <?php if (!empty($payment['reference_number'])): ?>
                                                    <code><?php echo $payment['reference_number']; ?></code>
                                                    <?php else: ?>
                                                    <span class="text-muted">-</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td class="text-center">
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-outline-primary" 
                                                                onclick="viewPaymentDetails(<?php echo $payment['id']; ?>)"
                                                                title="View Details">
                                                            <i class="fas fa-eye"></i>
                                                        </button>
                                                        <button type="button" class="btn btn-outline-danger"
                                                                onclick="deletePayment(<?php echo $payment['id']; ?>)"
                                                                title="Delete Payment">
                                                            <i class="fas fa-trash"></i>
                                                        </button>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php endwhile; ?>
                                            <tr class="table-active">
                                                <td colspan="3" class="fw-bold">Total Payments for this Transfer</td>
                                                <td class="text-end fw-bold fs-5 text-success">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($total_payments, 2); ?>
                                                </td>
                                                <td colspan="2" class="text-center">
                                                    <?php if ($total_payments >= $transfer['total_value']): ?>
                                                    <span class="badge bg-success">Fully Paid</span>
                                                    <?php else: ?>
                                                    <span class="badge bg-warning">Partially Paid</span>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                                
                                
                                <div class="row mt-4">
                                    <div class="col-md-3 mb-2">
                                        <div class="card bg-primary text-white">
                                            <div class="card-body text-center py-3">
                                                <h5 class="mb-1">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($transfer['total_value'], 2); ?>
                                                </h5>
                                                <small>Transfer Value</small>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 mb-2">
                                        <div class="card bg-success text-white">
                                            <div class="card-body text-center py-3">
                                                <h5 class="mb-1">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($total_payments, 2); ?>
                                                </h5>
                                                <small>Total Paid</small>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 mb-2">
                                        <div class="card bg-<?php echo ($transfer['total_value'] - $total_payments) > 0 ? 'danger' : 'success'; ?> text-white">
                                            <div class="card-body text-center py-3">
                                                <h5 class="mb-1">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($transfer['total_value'] - $total_payments, 2); ?>
                                                </h5>
                                                <small>Balance Due</small>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-3 mb-2">
                                        <div class="card bg-info text-white">
                                            <div class="card-body text-center py-3">
                                                <h5 class="mb-1">
                                                    <?php echo $transfer_payments_result->num_rows; ?>
                                                </h5>
                                                <small>Payments</small>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                
                                <?php else: ?>
                                <div class="text-center py-5">
                                    <i class="fas fa-money-bill-wave fa-3x text-muted mb-3"></i>
                                    <h5 class="text-muted">No Payments Recorded</h5>
                                    <p class="text-muted mb-4">No payments have been made for this transfer yet.</p>
                                    <a href="add-payment.php?branch_id=<?php echo $transfer['from_branch_id']; ?>&transfer_id=<?php echo $transfer_id; ?>" 
                                       class="btn btn-success">
                                        <i class="fas fa-plus-circle me-2"></i>Record First Payment
                                    </a>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                    
                    
                    <div class="col-lg-4">
                        
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-credit-card me-2"></i>Credit Information
                                    </h5>
                                    <?php if ($credit && $credit['current_credit'] > 0): ?>
                                    <a href="add-payment.php?branch_id=<?php echo $transfer['from_branch_id']; ?>&transfer_id=<?php echo $transfer_id; ?>" 
                                       class="btn btn-success btn-sm">
                                        <i class="fas fa-money-bill-wave me-1"></i>Make Payment
                                    </a>
                                    <?php endif; ?>
                                </div>
                            </div>
                            <div class="card-body">
                                <?php if ($credit): ?>
                                <div class="mb-4">
                                    <h6 class="border-bottom pb-2 mb-3">Current Credit Status</h6>
                                    
                                    <div class="mb-3">
                                        <div class="d-flex justify-content-between align-items-center mb-2">
                                            <span class="text-muted">Branch:</span>
                                            <span class="fw-medium"><?php echo htmlspecialchars($transfer['from_branch']); ?></span>
                                        </div>
                                        
                                        <div class="d-flex justify-content-between align-items-center mb-3">
                                            <span class="text-muted">Credit Due:</span>
                                            <span class="fw-bold fs-5 <?php echo $credit['current_credit'] > 0 ? 'text-danger' : 'text-success'; ?>">
                                                <i class="fas fa-rupee-sign me-1"></i>
                                                <?php echo number_format($credit['current_credit'], 2); ?>
                                            </span>
                                        </div>
                                        
                                        <?php 
                                        $credit_percentage = $credit['credit_limit'] > 0 ? ($credit['current_credit'] / $credit['credit_limit']) * 100 : 0;
                                        $progress_class = $credit_percentage > 80 ? 'bg-danger' : ($credit_percentage > 50 ? 'bg-warning' : 'bg-success');
                                        ?>
                                        <div class="progress mb-2" style="height: 8px;">
                                            <div class="progress-bar <?php echo $progress_class; ?>" 
                                                 role="progressbar" 
                                                 style="width: <?php echo min($credit_percentage, 100); ?>%">
                                            </div>
                                        </div>
                                        
                                        <div class="d-flex justify-content-between">
                                            <small class="text-muted">Credit Limit:</small>
                                            <small class="text-muted">
                                                <i class="fas fa-rupee-sign me-1"></i>
                                                <?php echo number_format($credit['credit_limit'], 2); ?>
                                            </small>
                                        </div>
                                    </div>
                                    
                                    
                                    <div class="alert alert-light border">
                                        <h6 class="mb-2">Payment Statistics</h6>
                                        <div class="row text-center">
                                            <div class="col-6 mb-2">
                                                <small class="text-muted d-block">Total Transfers</small>
                                                <strong class="text-primary">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($total_transfers, 2); ?>
                                                </strong>
                                            </div>
                                            <div class="col-6 mb-2">
                                                <small class="text-muted d-block">Total Payments</small>
                                                <strong class="text-success">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($total_paid, 2); ?>
                                                </strong>
                                            </div>
                                            <div class="col-6">
                                                <small class="text-muted d-block">Outstanding</small>
                                                <strong class="text-danger">
                                                    <i class="fas fa-rupee-sign me-1"></i>
                                                    <?php echo number_format($outstanding_balance, 2); ?>
                                                </strong>
                                            </div>
                                            <div class="col-6">
                                                <small class="text-muted d-block">Paid %</small>
                                                <strong class="<?php echo ($total_paid / $total_transfers * 100) >= 100 ? 'text-success' : 'text-warning'; ?>">
                                                    <?php echo $total_transfers > 0 ? number_format(($total_paid / $total_transfers * 100), 1) : 0; ?>%
                                                </strong>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <?php if ($credit['current_credit'] > 0): ?>
                                    <div class="alert alert-warning">
                                        <div class="d-flex">
                                            <div class="flex-shrink-0 me-3">
                                                <i class="fas fa-exclamation-triangle"></i>
                                            </div>
                                            <div class="flex-grow-1">
                                                <small>This branch has pending credit. Make a payment to clear it.</small>
                                            </div>
                                        </div>
                                    </div>
                                    <?php endif; ?>
                                </div>
                                
                                <hr>
                                
                                <h6 class="border-bottom pb-2 mb-3">Recent Transactions</h6>
                                
                                <?php if ($all_trans_result->num_rows > 0): ?>
                                <div class="list-group list-group-flush" style="max-height: 300px; overflow-y: auto;">
                                    <?php 
                                    $all_trans_result->data_seek(0);
                                    $counter = 0;
                                    while($trans = $all_trans_result->fetch_assoc()): 
                                        if ($counter >= 10) break;
                                        $counter++;
                                        $is_payment = $trans['transaction_type'] == 'payment_received';
                                        $icon_class = $is_payment ? 'text-success' : 'text-primary';
                                        $icon = $is_payment ? 'fa-arrow-down' : 'fa-arrow-up';
                                    ?>
                                    <div class="list-group-item px-0 py-2 border-0">
                                        <div class="d-flex justify-content-between align-items-start">
                                            <div class="d-flex align-items-start">
                                                <div class="flex-shrink-0 me-3">
                                                    <span class="badge <?php echo $is_payment ? 'bg-success' : 'bg-primary'; ?> p-2 rounded-circle">
                                                        <i class="fas <?php echo $icon; ?>"></i>
                                                    </span>
                                                </div>
                                                <div class="flex-grow-1">
                                                    <small class="d-block fw-medium">
                                                        <?php echo ucfirst(str_replace('_', ' ', $trans['transaction_type'])); ?>
                                                    </small>
                                                    <small class="text-muted">
                                                        <?php echo date('d M Y', strtotime($trans['created_at'])); ?>
                                                        <span class="mx-1">•</span>
                                                        <?php echo date('h:i A', strtotime($trans['created_at'])); ?>
                                                    </small>
                                                    <?php if (!empty($trans['description'])): ?>
                                                    <br>
                                                    <small class="text-muted">
                                                        <?php echo htmlspecialchars($trans['description']); ?>
                                                    </small>
                                                    <?php endif; ?>
                                                </div>
                                            </div>
                                            <div class="text-end">
                                                <strong class="<?php echo $icon_class; ?> d-block">
                                                    <?php echo $is_payment ? '-' : '+'; ?><i class="fas fa-rupee-sign me-1"></i><?php echo number_format($trans['amount'], 2); ?>
                                                </strong>
                                            </div>
                                        </div>
                                    </div>
                                    <?php endwhile; ?>
                                </div>
                                <div class="text-center mt-2">
                                    <a href="branch-transactions.php?branch_id=<?php echo $transfer['from_branch_id']; ?>" 
                                       class="btn btn-sm btn-outline-primary">
                                        View All Transactions
                                    </a>
                                </div>
                                <?php else: ?>
                                <div class="text-center py-3">
                                    <i class="fas fa-exchange-alt fa-2x text-muted mb-2"></i>
                                    <p class="text-muted mb-0">No credit transactions found</p>
                                </div>
                                <?php endif; ?>
                                
                                <?php else: ?>
                                <div class="text-center py-4">
                                    <i class="fas fa-credit-card fa-2x text-muted mb-3"></i>
                                    <h6 class="text-muted">No Credit Record Found</h6>
                                    <p class="text-muted small">This branch doesn't have a credit record yet.</p>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                        
                        
                        <div class="card mt-4">
                            <div class="card-header">
                                <h5 class="card-title mb-0">
                                    <i class="fas fa-cog me-2"></i>Quick Actions
                                </h5>
                            </div>
                            <div class="card-body">
                                <div class="d-grid gap-2">
                                    <a href="branch-transfer.php" class="btn btn-outline-success">
                                        <i class="fas fa-plus me-2"></i>New Transfer
                                    </a>
                                    
                                    <a href="view-transfer.php?view=all" class="btn btn-outline-primary">
                                        <i class="fas fa-list me-2"></i>View All Transfers
                                    </a>
                                    
                                    <button type="button" onclick="printTransfer()" class="btn btn-outline-info">
                                        <i class="fas fa-print me-2"></i>Print Transfer
                                    </button>
                                    
                                    <button type="button" class="btn btn-outline-secondary" onclick="shareTransfer()">
                                        <i class="fas fa-share-alt me-2"></i>Share Details
                                    </button>
                                </div>
                            </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>Status Timeline
                                </h5>
                            </div>
                            <div class="card-body">
                                <div class="timeline">
                                    <div class="timeline-item">
                                        <div class="timeline-icon bg-primary">
                                            <i class="fas fa-plus text-white"></i>
                                        </div>
                                        <div class="timeline-content">
                                            <small class="d-block fw-medium">Transfer Created</small>
                                            <small class="text-muted"><?php echo date('d M Y, h:i A', strtotime($transfer['created_at'])); ?></small>
                                        </div>
                                    </div>
                                    
                                    <?php if ($transfer['status'] == 'completed'): ?>
                                    <div class="timeline-item">
                                        <div class="timeline-icon bg-success">
                                            <i class="fas fa-check text-white"></i>
                                        </div>
                                        <div class="timeline-content">
                                            <small class="d-block fw-medium">Transfer Completed</small>
                                            <small class="text-muted"><?php echo date('d M Y, h:i A', strtotime($transfer['updated_at'])); ?></small>
                                        </div>
                                    </div>
                                    <?php elseif ($transfer['status'] == 'in_transit'): ?>
                                    <div class="timeline-item">
                                        <div class="timeline-icon bg-info">
                                            <i class="fas fa-truck text-white"></i>
                                        </div>
                                        <div class="timeline-content">
                                            <small class="d-block fw-medium">In Transit</small>
                                            <small class="text-muted">Currently being transferred</small>
                                        </div>
                                    </div>
                                    <?php elseif ($transfer['status'] == 'cancelled'): ?>
                                    <div class="timeline-item">
                                        <div class="timeline-icon bg-danger">
                                            <i class="fas fa-times text-white"></i>
                                        </div>
                                        <div class="timeline-content">
                                            <small class="d-block fw-medium">Transfer Cancelled</small>
                                            <small class="text-muted"><?php echo date('d M Y, h:i A', strtotime($transfer['updated_at'])); ?></small>
                                        </div>
                                    </div>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div> 
        </div>

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

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

<div class="modal fade" id="paymentDetailsModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Payment Details</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="paymentDetailsContent">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

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

.timeline:before {
    content: '';
    position: absolute;
    left: 15px;
    top: 0;
    bottom: 0;
    width: 2px;
    background-color: #dee2e6;
}

.timeline-item {
    position: relative;
    margin-bottom: 20px;
}

.timeline-icon {
    position: absolute;
    left: -30px;
    top: 0;
    width: 30px;
    height: 30px;
    border-radius: 50%;
    display: flex;
    align-items: center;
    justify-content: center;
    z-index: 1;
}

.timeline-content {
    margin-left: 10px;
}

/* Scrollbar for transactions list */
.list-group-flush::-webkit-scrollbar {
    width: 6px;
}

.list-group-flush::-webkit-scrollbar-track {
    background: #f1f1f1;
    border-radius: 10px;
}

.list-group-flush::-webkit-scrollbar-thumb {
    background: #888;
    border-radius: 10px;
}

.list-group-flush::-webkit-scrollbar-thumb:hover {
    background: #555;
}

/* Print styles */
@media print {
    .card-header, .card-footer, .btn, .vertical-menu, .topbar, .right-bar, 
    .page-title-box, .timeline:before, .timeline-icon, .status-timeline,
    .modal {
        display: none !important;
    }
    
    .card {
        border: 1px solid #ddd !important;
        box-shadow: none !important;
        margin-bottom: 15px !important;
    }
    
    .main-content {
        margin-left: 0 !important;
        padding: 0 !important;
    }
    
    .container-fluid {
        padding: 15px !important;
    }
    
    .table {
        border-collapse: collapse !important;
        width: 100% !important;
    }
    
    .table th,
    .table td {
        border: 1px solid #ddd !important;
        padding: 8px !important;
    }
    
    .table-active {
        background-color: #f8f9fa !important;
    }
    
    .badge {
        border: 1px solid #ddd !important;
        background-color: transparent !important;
        color: #000 !important;
    }
}
</style>

// Delete payment
function deletePayment(paymentId) {
    if (!confirm('Are you sure you want to delete this payment? This action cannot be undone.')) {
        return;
    }
    
    fetch(`ajax/delete-payment.php?id=${paymentId}`)
        .then(response => response.json())
        .then(data => {
            if (data.success) {
                showToast(data.message, 'success');
                // Reload the page after 2 seconds
                setTimeout(() => {
                    window.location.reload();
                }, 2000);
            } else {
                showToast(data.message, 'danger');
            }
        })
        .catch(error => {
            showToast('Error deleting payment', 'danger');
            console.error('Error:', error);
        });
}

// Share functionality
function shareTransfer() {
    const transferDetails = {
        number: "<?php echo $transfer['transfer_number']; ?>",
        from: "<?php echo $transfer['from_branch']; ?>",
        to: "<?php echo $transfer['to_branch']; ?>",
        amount: "<?php echo number_format($transfer['total_value'], 2); ?>",
        date: "<?php echo date('d M Y', strtotime($transfer['transfer_date'])); ?>",
        status: "<?php echo ucfirst($transfer['status']); ?>"
    };
    
    const text = `Transfer Details\n\n` +
                 `Transfer Number: ${transferDetails.number}\n` +
                 `From: ${transferDetails.from}\n` +
                 `To: ${transferDetails.to}\n` +
                 `Amount: ₹${transferDetails.amount}\n` +
                 `Date: ${transferDetails.date}\n` +
                 `Status: ${transferDetails.status}\n` +
                 `\nView details: ${window.location.href}`;
    
    if (navigator.share) {
        navigator.share({
            title: `Transfer ${transferDetails.number}`,
            text: text,
            url: window.location.href
        })
        .then(() => showToast('Shared successfully!', 'success'))
        .catch(error => console.log('Sharing cancelled:', error));
    } else {
        // Fallback: Copy to clipboard
        navigator.clipboard.writeText(text)
            .then(() => showToast('Transfer details copied to clipboard!', 'success'))
            .catch(err => showToast('Failed to copy: ' + err, 'danger'));
    }
}

// Print functionality
function printTransfer() {
    const printWindow = window.open('', '_blank', 'width=800,height=600');
    
    const printContent = `
        <!DOCTYPE html>
        <html>
        <head>
            <title>Transfer <?php echo $transfer['transfer_number']; ?></title>
            <style>
                body { margin: 20px; font-family: Arial, sans-serif; }
                .header { text-align: center; margin-bottom: 30px; }
                .header h1 { margin: 0 0 5px 0; color: #2c3e50; }
                .header .subtitle { color: #7f8c8d; margin-bottom: 20px; }
                .info-table { width: 100%; border-collapse: collapse; margin-bottom: 30px; }
                .info-table td { padding: 8px; border-bottom: 1px solid #ddd; }
                .info-table .label { font-weight: bold; width: 30%; color: #34495e; }
                .items-table { width: 100%; border-collapse: collapse; margin-bottom: 30px; }
                .items-table th, .items-table td { padding: 10px; border: 1px solid #ddd; text-align: left; }
                .items-table th { background-color: #f8f9fa; font-weight: bold; }
                .total-row { font-weight: bold; background-color: #f8f9fa; }
                .payment-table { width: 100%; border-collapse: collapse; margin-bottom: 30px; }
                .payment-table th, .payment-table td { padding: 8px; border: 1px solid #ddd; }
                .footer { margin-top: 40px; padding-top: 20px; border-top: 2px solid #ddd; text-align: center; color: #7f8c8d; }
                @media print {
                    .no-print { display: none; }
                    body { margin: 0; padding: 20px; }
                }
            </style>
        </head>
        <body>
            <div class="header">
                <h1>BRANCH TRANSFER RECEIPT</h1>
                <div class="subtitle">Transfer Number: <?php echo $transfer['transfer_number']; ?></div>
                <div class="subtitle">Generated on: <?php echo date('d M Y, h:i A'); ?></div>
            </div>
            
            <table class="info-table">
                <tr>
                    <td class="label">From Branch:</td>
                    <td><?php echo htmlspecialchars($transfer['from_branch']); ?> (<?php echo $transfer['from_code']; ?>)</td>
                </tr>
                <tr>
                    <td class="label">To Branch:</td>
                    <td><?php echo htmlspecialchars($transfer['to_branch']); ?> (<?php echo $transfer['to_code']; ?>)</td>
                </tr>
                <tr>
                    <td class="label">Transfer Date:</td>
                    <td><?php echo date('d M Y', strtotime($transfer['transfer_date'])); ?></td>
                </tr>
                <tr>
                    <td class="label">Status:</td>
                    <td><?php echo ucfirst($transfer['status']); ?></td>
                </tr>
                <tr>
                    <td class="label">Total Value:</td>
                    <td><strong>₹<?php echo number_format($transfer['total_value'], 2); ?></strong></td>
                </tr>
                <?php if (!empty($transfer['notes'])): ?>
                <tr>
                    <td class="label">Notes:</td>
                    <td><?php echo nl2br(htmlspecialchars($transfer['notes'])); ?></td>
                </tr>
                <?php endif; ?>
            </table>
            
            <h3>Transferred Products</h3>
            <table class="items-table">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>Product Name</th>
                        <th>Quantity</th>
                        <th>Unit Price</th>
                        <th>Total</th>
                    </tr>
                </thead>
                <tbody>
                    <?php 
                    $counter = 1;
                    $total_quantity = 0;
                    $items_result->data_seek(0);
                    while($item = $items_result->fetch_assoc()): 
                        $total_quantity += $item['quantity'];
                    ?>
                    <tr>
                        <td><?php echo $counter++; ?></td>
                        <td><?php echo htmlspecialchars($item['product_name']); ?></td>
                        <td><?php echo $item['quantity']; ?></td>
                        <td>₹<?php echo number_format($item['unit_value'], 2); ?></td>
                        <td>₹<?php echo number_format($item['total_value'], 2); ?></td>
                    </tr>
                    <?php endwhile; ?>
                    <tr class="total-row">
                        <td colspan="2"><strong>Total</strong></td>
                        <td><strong><?php echo $total_quantity; ?></strong></td>
                        <td>-</td>
                        <td><strong>₹<?php echo number_format($transfer['total_value'], 2); ?></strong></td>
                    </tr>
                </tbody>
            </table>
            
            <?php if ($transfer_payments_result->num_rows > 0): ?>
            <h3>Payment History</h3>
            <table class="payment-table">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Method</th>
                        <th>Reference</th>
                        <th>Amount</th>
                    </tr>
                </thead>
                <tbody>
                    <?php 
                    $total_payments = 0;
                    $transfer_payments_result->data_seek(0);
                    while($payment = $transfer_payments_result->fetch_assoc()): 
                        $total_payments += $payment['amount'];
                    ?>
                    <tr>
                        <td><?php echo date('d M Y', strtotime($payment['created_at'])); ?></td>
                        <td><?php echo !empty($payment['payment_method']) ? ucfirst($payment['payment_method']) : 'N/A'; ?></td>
                        <td><?php echo !empty($payment['reference_number']) ? $payment['reference_number'] : '-'; ?></td>
                        <td>₹<?php echo number_format($payment['amount'], 2); ?></td>
                    </tr>
                    <?php endwhile; ?>
                    <tr class="total-row">
                        <td colspan="3"><strong>Total Payments</strong></td>
                        <td><strong>₹<?php echo number_format($total_payments, 2); ?></strong></td>
                    </tr>
                    <tr class="total-row">
                        <td colspan="3"><strong>Balance Due</strong></td>
                        <td><strong>₹<?php echo number_format($transfer['total_value'] - $total_payments, 2); ?></strong></td>
                    </tr>
                </tbody>
            </table>
            <?php endif; ?>
            
            <div class="footer">
                <p>Generated by VK Mobiles Inventory System</p>
                <p>For any queries, please contact support</p>
                <p>Page 1 of 1</p>
            </div>
            
            <div class="no-print" style="margin-top: 20px; text-align: center;">
                <button onclick="window.print()" style="padding: 10px 20px; background: #007bff; color: white; border: none; border-radius: 4px; cursor: pointer;">
                    Print This Receipt
                </button>
            </div>
        </body>
        </html>
    `;
    
    printWindow.document.write(printContent);
    printWindow.document.close();
    printWindow.focus();
}

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

// Initialize tooltips
document.addEventListener('DOMContentLoaded', function() {
    var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'));
    var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) {
        return new bootstrap.Tooltip(tooltipTriggerEl);
    });
});
</script>

</body>
</html>

<?php
// Function to show all transfers
function showAllTransfers($conn) {
    ?>
    <div class="row">
        <div class="col-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-list me-2"></i>All Transfers
                        </h5>
                        <div class="d-flex gap-2">
                            <a href="branch-transfer.php" class="btn btn-success">
                                <i class="fas fa-plus-circle me-2"></i>New Transfer
                            </a>
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <?php
                    // Get filter parameters
                    $branch_id = isset($_GET['branch_id']) ? intval($_GET['branch_id']) : 0;
                    $status = isset($_GET['status']) ? $conn->real_escape_string($_GET['status']) : '';
                    $date_from = isset($_GET['date_from']) ? $conn->real_escape_string($_GET['date_from']) : '';
                    $date_to = isset($_GET['date_to']) ? $conn->real_escape_string($_GET['date_to']) : '';
                    $search = isset($_GET['search']) ? $conn->real_escape_string($_GET['search']) : '';
                    
                    // Build query with filters
                    $where_conditions = ["1=1"];
                    
                    if ($branch_id > 0) {
                        $where_conditions[] = "(bt.from_branch_id = $branch_id OR bt.to_branch_id = $branch_id)";
                    }
                    
                    if (!empty($status)) {
                        $where_conditions[] = "bt.status = '$status'";
                    }
                    
                    if (!empty($date_from)) {
                        $where_conditions[] = "DATE(bt.transfer_date) >= '$date_from'";
                    }
                    
                    if (!empty($date_to)) {
                        $where_conditions[] = "DATE(bt.transfer_date) <= '$date_to'";
                    }
                    
                    if (!empty($search)) {
                        $where_conditions[] = "(bt.transfer_number LIKE '%$search%' OR 
                                               fb.branch_name LIKE '%$search%' OR 
                                               tb.branch_name LIKE '%$search%')";
                    }
                    
                    $where_sql = implode(" AND ", $where_conditions);
                    
                    // Get total count for pagination
                    $count_sql = "SELECT COUNT(*) as total 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
                                 WHERE $where_sql";
                    $count_result = $conn->query($count_sql);
                    $total_rows = $count_result->fetch_assoc()['total'];
                    
                    // Pagination
                    $per_page = 20;
                    $page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
                    $offset = ($page - 1) * $per_page;
                    $total_pages = ceil($total_rows / $per_page);
                    
                    // Get transfers
                    $transfers_sql = "SELECT bt.*, 
                                     fb.branch_name as from_branch, fb.branch_code as from_code,
                                     tb.branch_name as to_branch, tb.branch_code as to_code
                                     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
                                     WHERE $where_sql
                                     ORDER BY bt.transfer_date DESC, bt.created_at DESC
                                     LIMIT $offset, $per_page";
                    $transfers_result = $conn->query($transfers_sql);
                    ?>
                    
                    
                    <div class="card bg-light mb-4">
                        <div class="card-body">
                            <form method="GET" action="" class="row g-3">
                                <input type="hidden" name="view" value="all">
                                
                                <div class="col-md-3">
                                    <label class="form-label">Branch</label>
                                    <select class="form-select" name="branch_id">
                                        <option value="">All Branches</option>
                                        <?php
                                        $branches_sql = "SELECT * FROM branches WHERE status = 'active' ORDER BY branch_name";
                                        $branches_result = $conn->query($branches_sql);
                                        while($branch = $branches_result->fetch_assoc()) {
                                            $selected = $branch_id == $branch['id'] ? 'selected' : '';
                                            echo '<option value="' . $branch['id'] . '" ' . $selected . '>' . 
                                                 htmlspecialchars($branch['branch_name']) . ' (' . $branch['branch_code'] . ')' . '</option>';
                                        }
                                        ?>
                                    </select>
                                </div>
                                
                                <div class="col-md-2">
                                    <label class="form-label">Status</label>
                                    <select class="form-select" name="status">
                                        <option value="">All Status</option>
                                        <option value="pending" <?php echo $status == 'pending' ? 'selected' : ''; ?>>Pending</option>
                                        <option value="in_transit" <?php echo $status == 'in_transit' ? 'selected' : ''; ?>>In Transit</option>
                                        <option value="completed" <?php echo $status == 'completed' ? 'selected' : ''; ?>>Completed</option>
                                        <option value="cancelled" <?php echo $status == 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                                    </select>
                                </div>
                                
                                <div class="col-md-2">
                                    <label class="form-label">From Date</label>
                                    <input type="date" class="form-control" name="date_from" value="<?php echo $date_from; ?>">
                                </div>
                                
                                <div class="col-md-2">
                                    <label class="form-label">To Date</label>
                                    <input type="date" class="form-control" name="date_to" value="<?php echo $date_to; ?>">
                                </div>
                                
                                <div class="col-md-3">
                                    <label class="form-label">Search</label>
                                    <div class="input-group">
                                        <input type="text" class="form-control" name="search" placeholder="Transfer # or branch..." value="<?php echo htmlspecialchars($search); ?>">
                                        <button class="btn btn-primary" type="submit">
                                            <i class="fas fa-search"></i>
                                        </button>
                                    </div>
                                </div>
                                
                                <div class="col-12">
                                    <div class="d-flex justify-content-between">
                                        <button type="submit" class="btn btn-primary">
                                            <i class="fas fa-filter me-2"></i>Apply Filters
                                        </button>
                                        <a href="view-transfer.php?view=all" class="btn btn-outline-secondary">
                                            <i class="fas fa-redo me-2"></i>Reset
                                        </a>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                    
                    
                    <div class="d-flex justify-content-between align-items-center mb-3">
                        <div>
                            <h6 class="mb-0">Showing <?php echo min($offset + 1, $total_rows); ?> - <?php echo min($offset + $per_page, $total_rows); ?> of <?php echo $total_rows; ?> transfers</h6>
                        </div>
                        <div>
                            <?php if ($total_rows > 0): ?>
                            <a href="export-transfers.php?<?php echo http_build_query($_GET); ?>" class="btn btn-sm btn-outline-success">
                                <i class="fas fa-file-excel me-2"></i>Export to Excel
                            </a>
                            <?php endif; ?>
                        </div>
                    </div>
                    
                    <?php if ($transfers_result->num_rows > 0): ?>
                    <div class="table-responsive">
                        <table class="table table-bordered table-hover mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th width="100">Date</th>
                                    <th>Transfer #</th>
                                    <th>From Branch</th>
                                    <th>To Branch</th>
                                    <th class="text-center">Items</th>
                                    <th class="text-end">Value</th>
                                    <th>Status</th>
                                    <th class="text-center">Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php 
                                while($transfer = $transfers_result->fetch_assoc()):
                                    // Get item count
                                    $items_sql = "SELECT COUNT(*) as item_count FROM branch_transfer_items WHERE transfer_id = " . $transfer['id'];
                                    $items_result = $conn->query($items_sql);
                                    $item_count = $items_result->fetch_assoc()['item_count'];
                                    
                                    // Status badge color
                                    $status_color = $transfer['status'] == 'completed' ? 'success' : 
                                                   ($transfer['status'] == 'pending' ? 'warning' : 
                                                   ($transfer['status'] == 'in_transit' ? 'info' : 'danger'));
                                ?>
                                <tr>
                                    <td>
                                        <small class="d-block"><?php echo date('d M Y', strtotime($transfer['transfer_date'])); ?></small>
                                        <small class="text-muted"><?php echo date('h:i A', strtotime($transfer['created_at'])); ?></small>
                                    </td>
                                    <td>
                                        <strong class="text-primary"><?php echo $transfer['transfer_number']; ?></strong>
                                    </td>
                                    <td>
                                        <div class="d-flex align-items-center">
                                            <div class="flex-shrink-0 me-2">
                                                <span class="badge bg-light text-dark border"><?php echo $transfer['from_code']; ?></span>
                                            </div>
                                            <div class="flex-grow-1">
                                                <small class="d-block"><?php echo htmlspecialchars($transfer['from_branch']); ?></small>
                                            </div>
                                        </div>
                                    </td>
                                    <td>
                                        <div class="d-flex align-items-center">
                                            <div class="flex-shrink-0 me-2">
                                                <span class="badge bg-light text-dark border"><?php echo $transfer['to_code']; ?></span>
                                            </div>
                                            <div class="flex-grow-1">
                                                <small class="d-block"><?php echo htmlspecialchars($transfer['to_branch']); ?></small>
                                            </div>
                                        </div>
                                    </td>
                                    <td class="text-center">
                                        <span class="badge bg-secondary"><?php echo $item_count; ?> items</span>
                                    </td>
                                    <td class="text-end">
                                        <strong class="text-primary">₹<?php echo number_format($transfer['total_value'], 2); ?></strong>
                                    </td>
                                    <td>
                                        <span class="badge bg-<?php echo $status_color; ?>">
                                            <?php echo ucfirst($transfer['status']); ?>
                                        </span>
                                    </td>
                                    <td class="text-center">
                                        <div class="btn-group btn-group-sm">
                                            <a href="view-transfer.php?id=<?php echo $transfer['id']; ?>" class="btn btn-outline-primary" title="View Details">
                                                <i class="fas fa-eye"></i>
                                            </a>
                                            <button type="button" onclick="printSingleTransfer(<?php echo $transfer['id']; ?>)" class="btn btn-outline-info" title="Print">
                                                <i class="fas fa-print"></i>
                                            </button>
                                        </div>
                                    </td>
                                </tr>
                                <?php endwhile; ?>
                            </tbody>
                        </table>
                    </div>
                    
                    
                    <?php if ($total_pages > 1): ?>
                    <nav aria-label="Page navigation" class="mt-4">
                        <ul class="pagination justify-content-center">
                            <li class="page-item <?php echo $page <= 1 ? 'disabled' : ''; ?>">
                                <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page - 1])); ?>">
                                    <i class="fas fa-chevron-left"></i>
                                </a>
                            </li>
                            
                            <?php
                            $start_page = max(1, $page - 2);
                            $end_page = min($total_pages, $page + 2);
                            
                            for ($i = $start_page; $i <= $end_page; $i++):
                            ?>
                            <li class="page-item <?php echo $i == $page ? 'active' : ''; ?>">
                                <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $i])); ?>">
                                    <?php echo $i; ?>
                                </a>
                            </li>
                            <?php endfor; ?>
                            
                            <li class="page-item <?php echo $page >= $total_pages ? 'disabled' : ''; ?>">
                                <a class="page-link" href="?<?php echo http_build_query(array_merge($_GET, ['page' => $page + 1])); ?>">
                                    <i class="fas fa-chevron-right"></i>
                                </a>
                            </li>
                        </ul>
                    </nav>
                    <?php endif; ?>
                    
                    <?php else: ?>
                    <div class="text-center py-5">
                        <i class="fas fa-exchange-alt fa-3x text-muted mb-3"></i>
                        <h5 class="text-muted">No Transfers Found</h5>
                        <p class="text-muted">No transfers match your search criteria.</p>
                        <a href="view-transfer.php?view=all" class="btn btn-outline-primary me-2">Clear Filters</a>
                        <a href="branch-transfer.php" class="btn btn-success">
                            <i class="fas fa-plus-circle me-2"></i>Create New Transfer
                        </a>
                    </div>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </div>
    <?php
    
    // Close DB connection at the end of the function
    $conn->close();
}

// Close DB connection if not already closed
if (isset($conn) && $conn) {
    $conn->close();
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-transfer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation