<?php
session_start();

include "classes/html.class.php";

$html = new html("open jobcards");
$db = new db();
echo $_SESSION['farm_id'];
if ($_SESSION['farm_id'] != '0') {
    $where_data = " AND farm_id = {$_SESSION['farm_id']}";
} else {
    $where_data = "AND 1";
}


$table_data = '<br><br><tr></tr>';
$jobcards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', "job_card_status = 'OPEN' OR job_card_status = 'AWAITING PARTS' $where_data", 'ORDER BY record_id DESC');
$index = 0;
while ($jobcard_info = $jobcards_res->fetch_assoc()) {

    $asset_info_res = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = {$jobcard_info['asset_id']}");
    $asset_info = $asset_info_res->fetch_assoc();

    $table_data = $table_data . "<tr><td>
    <input type='text' class='table_input' id='opened_date_$index' readonly value='".substr($jobcard_info['date_time_opened'],2,8)."'</td>
    <td><input type='text' class='table_input' value='{$asset_info['description']}' readonly /></td>
    <td><input type='text' class='table_input' id='status_$index' value='{$jobcard_info['job_card_status']}' readonly /></td>
    <script> if(document.getElementById('status_$index').value == 'AWAITING PARTS'){
        document.getElementById('status_$index').style.backgroundColor = 'orange';} </script>
    <td><input type='text' class='table_input' value='{$jobcard_info['job_card_type']}' readonly /></td>
    <td><a href='jobcard.php?jobcard_num={$jobcard_info['record_id']}'><input type='submit' id='btn_$index' value='SELECT' class='form_btn' readonly /></a></td></tr>
     " . $html->loading('btn', "$index") . "


    <script> if(document.getElementById('opened_date_$index').value == ''){
        document.getElementById('btn_$index').value = 'OPEN';
    }else{
            document.getElementById('btn_$index').value = 'CONTINUE';
        }</script>";
    $index++;
}

?>


<table style='width:100%; text-align:center;'>
    <tr>
        <td style='font-size:1.5vw;'>
            DATE OPENED
        </td>
        <td style='font-size:1.5vw;'>
            ASSET ID
        </td>
        <td style='font-size:1.5vw;'>
            STATUS
        </td>
        <td style='font-size:1.5vw;'>
            TYPE
        </td>
        <td>

        </td>
    </tr>
    <?php echo $table_data; ?>
</table>


</body>

</html>