1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / manager /
Filename : bulk-transfer.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');

$title = "Pending Services";
$currentTime = date('d-m-Y h:i:s A', time());

// Define the SQL query
$sql = "SELECT users.bank_name, users.account_number, transactions.amount
        FROM `transactions` 
        LEFT JOIN users ON users.id = transactions.user_id
        WHERE transactions.status = 'Pending' 
        AND transactions.type = 'Withdrawal' 
        AND transactions.account_type = 'Referral' ";

// Execute the query
$result = mysqli_query($con, $sql);

// Check if query executed successfully
if ($result) {
    // Generate a unique filename with the current date
    $filename = 'transactions_' . date('YmdHis') . '.csv';

    // Create a new CSV file
    $file = fopen($filename, 'w');

    // Write the header row
    fputcsv($file, array('Account Number', 'Bank', 'Amount', 'Narration'));

    // Fetch the data and write to CSV
    while ($row = mysqli_fetch_assoc($result)) {
        // Write row to CSV
        fputcsv($file, array(
            $row['account_number'],
            strtolower($row['bank_name']),
            $row['amount'],
            'Zeepay Affiliate' // or whatever narration you want
        ));
    }

    // Close the file
    fclose($file);
    ?>

    <div class="container-fluid py-4">
        <div class="card" style="padding:30px;">
            <h5 class="card-header">Bulk Transfers for Affiliate</h5>
            <div class="display:flex;flex-direction:column;align-items:center;justify-content:center">
                <a href='<?php echo $filename; ?>' download class='btn btn-primary mb-5'>Download CSV</a>
            </div>
            <div class="table-responsive table-wrapper-top text-nowrap">
                <table class="table table-bordered" id="dataTables-example">
                    <tr>
                        <th>Account Number</th>
                        <th>Bank</th>
                        <th>Amount</th>
                        <th>Narration</th>
                    </tr>
                    <?php
                    // Reset result pointer to start of result set
                    mysqli_data_seek($result, 0);
                    
                    // Display the data in a table
                    while ($row = mysqli_fetch_assoc($result)) {
                        echo "<tr>";
                        echo "<td>" . $row['account_number'] . "</td>";
                        echo "<td>" . strtolower($row['bank_name']) . "</td>";
                        echo "<td>" . $row['amount'] . "</td>";
                        echo "<td>Zeepay Affiliate</td>"; // or whatever narration you want
                        echo "</tr>";
                    }
                    ?>
                </table>
            </div>
        </div>
    </div>
<?php
} else {
    // Handle the case when query fails
    echo "<div class='alert alert-danger'>Error fetching data: " . mysqli_error($con) . "</div>";
}

include('include/footer.php');
?>