<?php
include 'header.php';

?>

    
    <div class="pt-28 md:pt-0 mt-0 md:mt-36 w-full md:w-4/5" id="general-content">
        <div class="w-full md:w-10/12 md:ml-64 2xl:ml-1/5" id="general-content-section">

            
            <div class="w-full py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 rounded-md bg-[#0e1726] p-2 md:p-4">
            <div class="flex justify-between items-center">
                <div>
                    
                    <h2 class="bg-transparent text-[#ebedf2] font-medium capitalize">
                        my Transfers
                    </h2>
                </div>

                <div>
                  <a href="javascript:void(0);" onclick="window.history.back();" class="flex justify-start items-center text-xs text-gray-400 hover:text-white">
    <svg xmlns="http://www.w3.org/2000/svg" class="h-5 w-5" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
        <path stroke-linecap="round" stroke-linejoin="round" d="M11 17l-5-5m0 0l5-5m-5 5h12" />
    </svg>
    <span>back</span>
</a>
                </div>
            </div>
        </div>
    </div>
</div>
            

            
            <div id="preloader" class="action-preloader">
    <div id="loading-bar-spinner" class="spinner">
        <div class="spinner-icon"></div>
    </div>
</div>

            
            
            
                        

            
            <div class="py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 rounded-sm bg-[#0e1726] p-4">
            <div class="w-full py-5">
                <div class="w-full lg:flex lg:justify-evenly lg:space-x-2 space-y-3 lg:space-y-0 text-[#bfc9d4]">
                    <div class="flex lg:block justify-between items-center bg-[#152136] px-3 lg:px-6 py-2 lg:py-3 hover:text-white cursor-pointer rounded-md">
                        <div class="hidden lg:block relative w-full">
                            <div class="absolute flex justify-center items-center -top-7 -right-7 h-9 w-9 rounded-full bg-blue-600 text-white">
                                <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                    <path stroke-linecap="round" stroke-linejoin="round" d="M12 6.253v13m0-13C10.832 5.477 9.246 5 7.5 5S4.168 5.477 3 6.253v13C4.168 18.477 5.754 18 7.5 18s3.332.477 4.5 1.253m0-13C13.168 5.477 14.754 5 16.5 5c1.747 0 3.332.477 4.5 1.253v13C19.832 18.477 18.247 18 16.5 18c-1.746 0-3.332.477-4.5 1.253" />
                                </svg>
                            </div>
                        </div>
                       <div>
    <?php
    // Calculate total transfers amount for the user
    $totalResult = mysqli_query($conn, "SELECT SUM(amount) as total_amount FROM transfers WHERE sender_id = '$user_id'");
    $totalRow = mysqli_fetch_assoc($totalResult);
    $totalTransfers = $totalRow['total_amount'] ? number_format($totalRow['total_amount'], 2) : '0.00';
    ?>
    <div>
        <h2 class="text-sm lg:text-base font-semibold">USD<?php echo $totalTransfers; ?></h2>
    </div>
    <div class="mt-2">
        <h4 class="text-xs lg:text-sm font-medium">Total transfers</h4>
    </div>
</div>
                        <div class="lg:hidden opacity-50">
                            <div class="flex justify-center items-center h-9 w-9 rounded-full bg-blue-600 text-white">
                                <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                                    <path stroke-linecap="round" stroke-linejoin="round" d="M12 6.253v13m0-13C10.832 5.477 9.246 5 7.5 5S4.168 5.477 3 6.253v13C4.168 18.477 5.754 18 7.5 18s3.332.477 4.5 1.253m0-13C13.168 5.477 14.754 5 16.5 5c1.747 0 3.332.477 4.5 1.253v13C19.832 18.477 18.247 18 16.5 18c-1.746 0-3.332.477-4.5 1.253" />
                                </svg>
                            </div>
                        </div>
                    </div>

                    <!--<div class="flex lg:block justify-between items-center bg-[#152136] px-3 lg:px-6 py-2 lg:py-3 hover:text-white cursor-pointer rounded-md">-->
                    <!--    <div class="hidden lg:block relative w-full">-->
                    <!--        <div class="absolute flex justify-center items-center -top-7 -right-7 h-9 w-9 rounded-full bg-green-600 text-white">-->
                    <!--            <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">-->
                    <!--                <path stroke-linecap="round" stroke-linejoin="round" d="M3 4h13M3 8h9m-9 4h9m5-4v12m0 0l-4-4m4 4l4-4" />-->
                    <!--            </svg>-->
                    <!--        </div>-->
                    <!--    </div>-->
                    <!--    <div>-->
                    <!--        <div>-->
                    <!--            <h2 class="text-sm lg:text-base font-semibold">USD0.00</h2>-->
                    <!--        </div>-->
                    <!--        <div class="mt-2">-->
                    <!--            <h4 class="text-xs lg:text-sm font-medium">Incoming transfers</h4>-->
                    <!--        </div>-->
                    <!--    </div>-->
                    <!--    <div class="lg:hidden opacity-50">-->
                    <!--        <div class="flex justify-center items-center h-9 w-9 rounded-full bg-green-600 text-white">-->
                    <!--            <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">-->
                    <!--                <path stroke-linecap="round" stroke-linejoin="round" d="M3 4h13M3 8h9m-9 4h9m5-4v12m0 0l-4-4m4 4l4-4" />-->
                    <!--            </svg>-->
                    <!--        </div>-->
                    <!--    </div>-->
                    <!--</div>-->

                    <!--<div class="flex lg:block justify-between items-center bg-[#152136] px-3 lg:px-6 py-2 lg:py-3 hover:text-white cursor-pointer rounded-md">-->
                    <!--    <div class="hidden lg:block relative w-full">-->
                    <!--        <div class="absolute flex justify-center items-center -top-7 -right-7 h-9 w-9 rounded-full bg-red-600 text-white">-->
                    <!--            <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">-->
                    <!--                <path stroke-linecap="round" stroke-linejoin="round" d="M3 4h13M3 8h9m-9 4h6m4 0l4-4m0 0l4 4m-4-4v12" />-->
                    <!--            </svg>-->
                    <!--        </div>-->
                    <!--    </div>-->
                    <!--    <div>-->
                    <!--        <div>-->
                    <!--            <h2 class="text-sm lg:text-base font-semibold">USD0.00</h2>-->
                    <!--        </div>-->
                    <!--        <div class="mt-2">-->
                    <!--            <h4 class="text-xs lg:text-sm font-medium">Outgoing transfers</h4>-->
                    <!--        </div>-->
                    <!--    </div>-->
                    <!--    <div class="lg:hidden opacity-50">-->
                    <!--        <div class="flex justify-center items-center h-9 w-9 rounded-full bg-red-600 text-white">-->
                    <!--            <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">-->
                    <!--                <path stroke-linecap="round" stroke-linejoin="round" d="M3 4h13M3 8h9m-9 4h6m4 0l4-4m0 0l4 4m-4-4v12" />-->
                    <!--            </svg>-->
                    <!--        </div>-->
                    <!--    </div>-->
                    <!--</div>-->
                </div>
            </div>
                    </div>
    </div>
</div>


            

            
<div class="py-5">
    <div class="w-full flex justify-center">
        <div class="w-11/12 rounded-sm bg-[#0e1726] p-1 md:p-4">
    <?php
    // Assuming $user_id is already defined
    $result = mysqli_query($conn, "SELECT * FROM `transfers` WHERE `sender_id` = '$user_id'");
    
    // Check if there are any records
    if(mysqli_num_rows($result) > 0) {
    ?>
        <div class="overflow-x-auto">
            <table class="min-w-full bg-[#131d2c] text-[#d3d6df]">
                <thead>
                    <tr class="border-b border-gray-700">
                        <th class="px-4 py-3 text-left">ID</th>
                        <!--<th class="px-4 py-3 text-left">Receiver</th>-->
                        <th class="px-4 py-3 text-left">Amount</th>
                        <th class="px-4 py-3 text-left">Fee</th>
                        <th class="px-4 py-3 text-left">Total</th>
                        <th class="px-4 py-3 text-left">Account</th>
                        <th class="px-4 py-3 text-left">Narration</th>
                        <th class="px-4 py-3 text-left">Status</th>
                        <th class="px-4 py-3 text-left">Date</th>
                    </tr>
                </thead>
                <tbody>
                    <?php 
                    // Using while loop instead of do-while for better handling
                    while($row = mysqli_fetch_assoc($result)) {
                    ?>
                        <tr class="border-b border-gray-700 hover:bg-[#0e1726]">
                            <td class="px-4 py-3"><?php echo htmlspecialchars($row['id']); ?></td>
                            <!--<td class="px-4 py-3"><?php echo htmlspecialchars($row['receiver_id']); ?></td>-->
                            <td class="px-4 py-3"><?php echo htmlspecialchars($row['amount']); ?></td>
                            <td class="px-4 py-3"><?php echo htmlspecialchars($row['fee']); ?></td>
                            <td class="px-4 py-3"><?php echo htmlspecialchars($row['total']); ?></td>
                            <td class="px-4 py-3"><?php echo htmlspecialchars($row['receiver_account_id']); ?></td>
                            <td class="px-4 py-3"><?php echo htmlspecialchars($row['narration']); ?></td>
                            <td class="px-4 py-3">
                                <span class="<?php echo $row['status'] === 'completed' ? 'text-green-500' : ($row['status'] === 'failed' ? 'text-red-500' : 'text-yellow-500'); ?>">
                                    <?php echo htmlspecialchars($row['status']); ?>
                                </span>
                            </td>
                            <td class="px-4 py-3"><?php echo date('M d, Y H:i', strtotime($row['created_at'])); ?></td>
                        </tr>
                    <?php 
                    }
                    ?>
                </tbody>
            </table>
        </div>
    <?php } else { ?>
        <div class="w-full p-6 md:p-10 flex justify-center">
            <div class="w-full flex space-x-2 rounded-lg bg-[#131d2c] text-[#d3d6df] p-2 md:p-4 text-xs md:text-sm">
                <div class="text-orange-500">
                    <svg xmlns="http://www.w3.org/2000/svg" class="h-6 w-6" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2">
                        <path stroke-linecap="round" stroke-linejoin="round" d="M20.618 5.984A11.955 11.955 0 0112 2.944a11.955 11.955 0 01-8.618 3.04A12.02 12.02 0 003 9c0 5.591 3.824 10.29 9 11.622 5.176-1.332 9-6.03 9-11.622 0-1.042-.133-2.052-.382-3.016zM12 9v2m0 4h.01" />
                    </svg>
                </div>
                <div>
                    <b class="font-medium">Empty Record! </b> You haven't made any transfers.
                </div>
            </div>
        </div>
    <?php } ?>
</div>
    </div>
</div>

            

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


<?php
    include 'footer.php';
?>
    