<?php include "../../root.class.php";
$html = new html();
$html->add_styles_page();

$db = new db_safeguard();
$service_ticket_res = $db->select_query('service_tickets', '*', "record_id = {$_GET['record_id']}");
$service_ticket = $service_ticket_res->fetch_assoc();

$client_res = $db->select_query('clients', '*', "record_id = {$service_ticket['client_id']}");
$client = $client_res->fetch_assoc();

function get_username($id)
{
    $db = new db_safeguard();
    $user_res = $db->select_query('users', '*', "record_id = {$id}");
    $user = $user_res->fetch_assoc();
    return $user['username'];
}

?>

<div class="form">
    <h1><?php echo $client['name']; ?></h1>
    <?php
    echo $html->input_html_from_db('service_tickets', 'date_time_created', "record_id = {$_GET['record_id']}");
    echo $html->select_html_from_db('users', 'record_id', 'username', '', 'user_id_created', 'user_id_created');
    echo $html->select_from_db_add_current_selected_column('service_tickets', 'user_id_created', "record_id = {$_GET['record_id']}", 'user_id_created');
    echo $html->select_html_from_db('users', 'record_id', 'username', '', 'user_id_assigned', 'user_id_assigned');
    echo $html->select_from_db_add_current_selected_column('service_tickets', 'user_id_assigned', "record_id = {$_GET['record_id']}", 'user_id_assigned');
    echo "<h1>Descripiton</h1>";
    echo $service_ticket['description'];
    echo "<h1>Service Rendered</h1>";

    echo $service_ticket['service_rendered'];
    ?>
</div>

<div class="form_down">
    <h1>ADMIN DATA</h1>
    <table>
        <tr>
            <th>date_time</th>
            <th>status</th>
            <th>user</th>
        </tr>

        <?php
        echo "<style>
                table {
                    width: 100%;
                    font-size:1vw;
                }
                th {
                    background-color: #4CAF50;
                    color: white;
                }
                tr:nth-child(even) {
                    background-color: #f2f2f2;
                }
            </style>";
        $timeline_res = $db->select_query('service_ticket_timeline', '*', "service_ticket_id = {$_GET['record_id']} ORDER BY record_id ASC");
        while ($timeline = $timeline_res->fetch_assoc()) {
            echo "<tr><td>{$timeline['date_time']}</td><td>{$timeline['status']}</td><td>" . get_username($timeline['user_id']) . "</td></tr>";
            if ($timeline['status'] == 'start') {
                $start_date_time = $timeline['date_time'];
            }
            if ($timeline['status'] == 'stop') {
                $stop_date_time = $timeline['date_time'];
                $start = new DateTime($start_date_time);
                $stop = new DateTime($stop_date_time);
                $interval = $start->diff($stop);
                $hours_difference = $interval->format('%h') + ($interval->format('%i') / 60);
                $total_hours = isset($total_hours) ? $total_hours + $hours_difference : $hours_difference;
                echo "<tr><td style='text-align:center' >Hours Difference</td><td style='text-align:center' colspan='2'>{$interval->format('%h:%i')}</td></tr>";
            }

            if ($timeline['status'] == 'completed') {
                echo "<tr><td style='text-align:center' >Total Hours</td><td colspan='2' style='text-align:center'>Hours: " . round($total_hours, 2) . "</td></tr>";
            }


        }
        ?>
    </table>
    <?php echo $html->input_html('invoice_number', 0, 'invoice_number', 'invoice_number');
    echo $html->input_html('', 1, 'singed_off', 'singed_off', '', '', '', 'text', 'hidden');
    echo $html->input_html('', $_GET['record_id'], 'record_id', 'record_id', '', '', '', 'text', 'hidden');
    echo $html->submit_btn('submit', 'SIGN OFF', 'signoff()');
    ?>
</div>

<?php
echo $html->submit_btn('submit', 'OPEN PDF', 'PDF()');
?>
<?php
echo $html->html_form_ajax("signoff", "UPDATE", "service_tickets", '', false);
?>

<script>



    function PDF() {
        window.open('service_ticket_html.php?record_id=<?php echo $_GET['record_id']; ?>', '_blank');
    }



</script>