<?php include "../../root.class.php";
$html = new html();
$html->add_styles_page();
// $html->check_user_type("ADMIN");
$db = new db_safeguard();

$leads_res = $db->query("leads", "SELECT * FROM leads WHERE status != 'ASSIGN TEAM' AND status != 'CLIENT CANCELED' ORDER BY jc_no DESC");

if ($leads_res->num_rows > 0) {

    while ($leads = $leads_res->fetch_assoc()) {
        $user_res = $db->query("users", "SELECT * FROM users WHERE record_id = {$leads['user_created_id']}");
        $user = $user_res->fetch_assoc();

        $table_data = $table_data . "
        <tr>
            <td>{$leads['jc_no']}</td>
            <td>{$leads['contact_number']}</td>
            <td>{$leads['area']}</td>
            <td>{$leads['type']}</td>
            <td>{$user['username']}</td>
            <td>{$leads['status']}</td>
            <td><input type='input' class='submit_btn' style='margin: 0.5vw auto;' value='ASSIGN' onclick='window.location.href = `assign_jobcard.php?jc_no={$leads['jc_no']}`' readonly></td>
        </tr>
    ";
    }

} else {

    $table_data = $table_data . "
        <tr>
            <td></td>
            <td></td>
            <td>NO LEADS FOUND</td>
            <td></td>
            <td></td>
            <td></td>
        </tr>
    ";

}

?>
<style>
    table {
        border-collapse: collapse;
        width: 90%;
        background-color: whitesmoke;
    }

    table,
    th,
    td {
        border: 2px solid black;
        padding: 1vw;
    }

    th {
        padding: 0.5vw;
    }

    /* table {
        width: 80%;
        border: 2px solid black;
    }

    th {
        text-align: left;
        font-size: 2vw;
        border: 2px solid black;
    }

    td {
        text-align: left;
        font-size: 1.5vw;
        border: 2px solid black;

    } */

    tr:nth-child(even) {
        background-color: #ffa50063;
    }

    tr:hover {
        background-color: #ddd;
    }
</style>

<div class="form_down">
    <h1>UNASSIGNED LEADS</h1>
    <table>
        <tr>
            <th>JOBCARD NO</th>
            <th>CONTACT NUMBER</th>
            <th>AREA</th>
            <th>TYPE</th>
            <th>CREATED BY</th>
            <th>STATUS</th>
            <th></th>
        </tr>
        <?php
        echo $table_data;
        ?>
    </table>
    <br><br>
</div>