<?php
include "classes/class.loader.php";
$html = new html();
$html->bacground_emoji();
$DashboardWidget = new DashboardWidget();
$calls = new functions();
$db = new db();
$html->header();

?>
<style>
    body {
        background-color: #bebebee7;
        color: white;
    }
</style>

<div class="home_container">

    <div class="container_square">
        <h2>TOTAL PAYMENTS THIS MONTH</h2>
        <div class="line"></div>
        <h1><?php echo "R " . $calls->get_total_value_from_payments_this_month(); ?>
        </h1>
        <br>
    </div>

    <div class="container_square">
        <h2>LAST MONTH PAYMENTS</h2>
        <div class="line"></div>
        <h1><?php echo "R " . $calls->get_total_value_from_payments_last_month(); ?></h1>
    </div>

    <div class="container_square">
        <h2>TOTAL PAYMENTS</h2>
        <div class="line"></div>
        <h1><?php echo "R " . $calls->get_total_value_from_payments(); ?>
        </h1>
        <br>
    </div>

    <div class="container_square">
        <br>
        <input type="text" id="search" placeholder="Search">
        <br>
        <button onclick="search()">SEARCH</button>
        <script>
            function search() {
                var search = document.getElementById("search").value;
                var search_str = new RegExp(search, 'i');
                var rows = document.querySelectorAll("tr");
                rows.forEach(function (row) {
                    var match = false;
                    row.querySelectorAll("td").forEach(function (cell) {
                        if (cell.innerHTML.match(search_str)) {
                            match = true;
                        }
                    });
                    if (match) {
                        row.style.backgroundColor = "#46878bff";
                        row.scrollIntoView();
                        row.focus();
                    } else {
                        row.style.backgroundColor = "";
                    }
                });
            }
        </script>
    </div>
    <?php
    echo DashboardWidget::includeAssets();


    $table_data = [];

    $bookings_res = $db->query("SELECT * FROM `payments` WHERE booking_id = 0 ORDER BY record_id DESC");
    while ($booking = $bookings_res->fetch_assoc()) {

        $table_data[] = [
            $booking['record_id'],
            $calls->get_username($booking['user_id']),
            $booking['date_time'],
            "R " . $booking['zar'],
            ''
        ];

    }


    echo DashboardWidget::tableBlock(
        'Latest Payments',
        ['No', 'User', 'Date', 'Zar'],
        $table_data,
        '90vw'
    );
    ?>
</div>