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-credits.php

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

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

<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">Branch Credit 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"><a href="branch-transfer.php">Branch Transfer</a></li>
                                <li class="breadcrumb-item active">Branch Credits</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>

<div class="row">
                <div class="col-12">
                    <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>All Branch Credits
                                </h5>
                                <a href="branch-transfer.php" class="btn btn-sm btn-primary">
                                    <i class="fas fa-arrow-left me-2"></i>Back to Transfer
                                </a>
                            </div>
                        </div>
                        <div class="card-body">
                            <?php
                            // Get all branch credits with details
                            $credits_sql = "SELECT b.*, 
                                           COALESCE(bc.current_credit, 0) as current_credit,
                                           COALESCE(bc.credit_limit, 1000000) as credit_limit,
                                           bc.last_updated,
                                           (SELECT SUM(amount) FROM branch_credit_transactions 
                                            WHERE branch_id = b.id AND transaction_type = 'product_transfer') as total_transfers,
                                           (SELECT SUM(amount) FROM branch_credit_transactions 
                                            WHERE branch_id = b.id AND transaction_type = 'payment_received') as total_payments
                                           FROM branches b
                                           LEFT JOIN branch_credits bc ON b.id = bc.branch_id
                                           WHERE b.status = 'active'
                                           ORDER BY bc.current_credit DESC";
                            $credits_result = $conn->query($credits_sql);
                            
                            if ($credits_result->num_rows > 0) {
                                echo '<div class="table-responsive">';
                                echo '<table class="table table-hover">';
                                echo '<thead class="table-light">';
                                echo '<tr>';
                                echo '<th>Branch</th>';
                                echo '<th>Credit Due</th>';
                                echo '<th>Credit Limit</th>';
                                echo '<th>Utilization</th>';
                                echo '<th>Total Transfers</th>';
                                echo '<th>Total Payments</th>';
                                echo '<th>Last Updated</th>';
                                echo '<th>Actions</th>';
                                echo '</tr>';
                                echo '</thead>';
                                echo '<tbody>';
                                
                                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');
                                    
                                    echo '<tr>';
                                    echo '<td>';
                                    echo '<strong>' . htmlspecialchars($branch['branch_name']) . '</strong><br>';
                                    echo '<small class="text-muted">' . $branch['branch_code'] . '</small>';
                                    echo '</td>';
                                    echo '<td>';
                                    echo '<span class="fw-bold ' . ($branch['current_credit'] > 0 ? 'text-danger' : 'text-success') . '">';
                                    echo '₹' . number_format($branch['current_credit'], 2);
                                    echo '</span>';
                                    echo '</td>';
                                    echo '<td>₹' . number_format($branch['credit_limit'], 2) . '</td>';
                                    echo '<td>';
                                    echo '<div class="d-flex align-items-center">';
                                    echo '<div class="flex-grow-1 me-2">';
                                    echo '<div class="progress" style="height: 6px;">';
                                    echo '<div class="progress-bar ' . $progress_class . '" style="width: ' . min($credit_ratio, 100) . '%"></div>';
                                    echo '</div>';
                                    echo '</div>';
                                    echo '<div class="flex-shrink-0">';
                                    echo '<small>' . number_format($credit_ratio, 1) . '%</small>';
                                    echo '</div>';
                                    echo '</div>';
                                    echo '</td>';
                                    echo '<td>₹' . number_format($branch['total_transfers'] ?? 0, 2) . '</td>';
                                    echo '<td>₹' . number_format($branch['total_payments'] ?? 0, 2) . '</td>';
                                    echo '<td>' . ($branch['last_updated'] ? date('d M Y, h:i A', strtotime($branch['last_updated'])) : 'Never') . '</td>';
                                    echo '<td>';
                                    echo '<a href="view-branch-credit.php?branch_id=' . $branch['id'] . '" class="btn btn-sm btn-outline-primary me-1">View</a>';
                                    if ($branch['current_credit'] > 0) {
                                        echo '<a href="branch-transfer.php" class="btn btn-sm btn-success">Pay</a>';
                                    }
                                    echo '</td>';
                                    echo '</tr>';
                                }
                                
                                echo '</tbody>';
                                echo '</table>';
                                echo '</div>';
                            } else {
                                echo '<div class="text-center py-5">';
                                echo '<i class="fas fa-credit-card fa-3x text-muted mb-3"></i>';
                                echo '<h5 class="text-muted">No branch credits found</h5>';
                                echo '<p class="text-muted">Start transferring products to create credit records</p>';
                                echo '</div>';
                            }
                            ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <?php include('includes/footer.php')?>
</div>

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

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: branch-credits.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation