TOTAL TIME REPORT

<?php
require('../../fpdf.php');
include "../../root.class.php";
$html = new html();
$html->add_styles_page();

$db = new db_safeguard();

$teams_res = $db->query("teams", "SELECT * FROM teams ORDER BY record_id ASC");

$team_names = [];
while ($row = $teams_res->fetch_assoc()) {
    $team_names[] = $row;
}

foreach ($team_names as $team) {
    $data_1[$team['name']] = $team['record_id'];
}



$job_card_res = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline ORDER BY record_id ASC");
if ($job_card_res->num_rows == 0) {
    echo "<br><h2>NOT STARTED YET</h2>";
} else {
    $total_work_time = 0;
    while ($job_card = $job_card_res->fetch_assoc()) {
        if ($job_card['type'] == "RIEM_START") {
            $riem_start = $job_card['date_time'];
            echo $riem_start;
        }

        if ($job_card['type'] == "RIEM_STOP") {
            $riem_stop = $job_card['date_time'];
            echo $riem_stop;
            
            $riem_start_time = strtotime($riem_start);
            $riem_end_time = strtotime($riem_stop);

            $riem_start_total_time += $riem_start_time;
            $riem_end_total_time += $riem_end_time;

            $total_work_time += $total_time = $riem_end_time - $riem_start_time;

        }

        $data_1 = [
            'RIEM_START' => date('H:i', $riem_start_time),
            'RIEM_END' => date('H:i', $riem_end_time),
        ];

        if ($job_card['type'] == 'DRILLING_START') {
            $drilling_start = $job_card['date_time'];
            echo $drilling_start;

        }

        if ($job_card['type'] == 'DRILLING_STOP') {
            $drilling_stop = $job_card['date_time'];
            echo $drilling_stop;

            $drilling_start_time = strtotime($drilling_start);
            $drilling_end_time = strtotime($drilling_stop);

            $drilling_start_total_time += $drilling_start_time;
            $drilling_end_total_time += $drilling_end_time;

            $total_work_time += $total_time = $drilling_end_time - $drilling_start_time;
        }

        $data_2 = [
            'DRILL_START' => $drilling_start_time,
            'DRILL_END' => $drilling_end_time,
        ];

        if ($job_card['type'] == "CASING_START") {
            $casing_start = $job_card['date_time'];
            echo $casing_start;

        }

        if ($job_card['type'] == "CASING_STOP") {
            $casing_stop = $job_card['date_time'];
            echo $casing_stop;

            $casing_start_time = strtotime($casing_start);
            $casing_end_time = strtotime($casing_stop);

            $casing_start_total_time += $casing_start_time;
            $casing_end_total_time += $casing_end_time;

            $total_work_time += $total_time = $casing_end_time - $casing_start_time;
        }

        $data_3 = [
            'CASING_START' => $casing_start_time,
            'CASING_END' => $casing_end_time,
        ];

        // $data_4 = [
        //     'RIEM_START' => 150,
        //     'RIEM_END' => 90,
        // ];

        // $data_5 = [
        //     'RIEM_START' => 150,
        //     'RIEM_END' => 90,
        // ];

        // $data_6 = [
        //     'RIEM_START' => 150,
        //     'RIEM_END' => 90,
        // ];
    }
}

?>

<div class="form_down">
    <h1>TOTAL TIME REPORT</h1>
    <br>
    <?php
    $html->bar_graph_horizontal($data_1);
    ?>
    <br><br>
    <?php
    $html->bar_graph_horizontal($data_2);
    ?>
    <br><br>
    <?php
    $html->bar_graph_horizontal($data_3);
    ?>
    <br><br>

</div>