@extends('layouts.app')

@section('center')
    <style>
        .wb {
            border-left: 1px solid white !important;
        }

        .bb {
            border-left: 1px solid lightgray !important;
        }

        .rbg {
            border-right: 1px solid lightgray !important;
        }
    </style>
    <link rel="stylesheet" href="{{asset('assets')}}/vendor/datepicker/css/classic.css"/>
    <link rel="stylesheet" href="{{asset('assets')}}/vendor/datepicker/css/classic.date.css"/>
    <link rel="stylesheet" href="{{asset('assets')}}/vendor/bs-select/bs-select.css"/>
    <div class="row gutters">
        <div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
            <form action="{{route('calculatedkwh')}}">
                <div class="row gutters">
                    <div class="col-xl-2 col-lg-2 col-md-2 col-sm-2">

                        <div class="form-group">
                            <label class="label">Device ID</label>
                            <select class="form-control selectpicker" data-live-search="true" class="form-control "
                                    name="DeviceId">
                                <option value=''>Select Device ID</option>
                                @foreach($tr_data as $k => $row)
                                    <option value="{{$row->global_device_id}}" @isset($_GET["DeviceId"])
                                        @if($_GET["DeviceId"]==$row->global_device_id)
                                            {{'selected'}}
                                            @endif
                                        @endisset>{{$row->global_device_id}}</option>
                                @endforeach

                            </select>
                        </div>


                    </div>


                    <div class="col-xl-3 col-lg-3 col-md-3 col-sm-3">

                        <div class="form-group">
                            <label class="label">From Date</label>
{{--                            <input type="text" class="form-control datepicker" name="from" placeholder="From"--}}
                            <input type="datetime-local" class="form-control" name="from" placeholder="From"
                                   @isset($_GET["from"])
                                       value="{{$_GET['from']}}"
                                @endisset >
                        </div>

                    </div>

                    <div class="col-xl-3 col-lg-3 col-md-3 col-sm-3">

                        <div class="form-group">
                            <label class="label">To Date</label>
{{--                            <input type="text" class="form-control datepicker" name="to" placeholder="To"--}}
                            <input type="datetime-local" class="form-control" name="to" placeholder="To"
                                   @isset($_GET["to"])
                                       value="{{$_GET['to']}}"
                                @endisset
                            >
                        </div>

                    </div>

                    <div class="col-xl-2 col-lg col-md-2 col-sm-2 col-12 ">
                        <div class="form-group">
                            <label class="label">&nbsp;</label>
                            <button type="submit" class="form-control btn btn-primary generate">Generate</button>
                        </div>

                    </div>
                </div>
            </form>
        </div>


    <div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
        <div class="table-responsive">
            <div class="table-container">
                <div class="table-responsive" style="max-height: 800px; overflow-y: auto;">
                    <table class="table m-0 table-hover" style="font-size: 10px !important;" id="kwh-table">
                        <thead style="position: sticky; top: 0; z-index: 1;">
                            <tr>
                                <th rowspan="2">Time</th>
                                <th rowspan="2">GlobalID</th>
                                <th rowspan="2">Timing</th>
                                <th colspan="3" class="wb text-center">Voltages</th>
                                <th colspan="3" class="wb text-center">Currents</th>
                                <th colspan="3" class="wb text-center">Power Factors</th>
                                <th colspan="4" class="wb text-center">&#9889; Calculated KWH</th>
                            </tr>
                            <tr>
                                {{-- Voltages --}}
                                <th class="wb">V1</th>
                                <th>V2</th>
                                <th>V3</th>
                                {{-- Currents --}}
                                <th class="wb">I1</th>
                                <th>I2</th>
                                <th>I3</th>
                                {{-- Power Factors --}}
                                <th class="wb">PF1</th>
                                <th>PF2</th>
                                <th>PF3</th>
                                {{-- KWH --}}
                                <th class="wb">kW Load</th>
                                <th>Int (mins)</th>
                                <th>Int (hours)</th>
                                <th>kWh (Int)</th>
                                <th>kWh (Cumul)</th>
                            </tr>
                        </thead>

                        <tbody class="recent-record-row">

                            @if($data && $data->count() > 0)

                                @php
                                    /*
                                    |------------------------------------------------------
                                    | $prev_record_time  = Unix timestamp of the last row
                                    |   on the previous page (null on page 1).
                                    | Seeded by the controller so cross-page intervals
                                    | are always correct.
                                    |------------------------------------------------------
                                    */
                                    $prev_time  = $prev_record_time ?? null;
                                    $cumulative = 0;
                                @endphp

                                @foreach($data as $row)
                                    @php
                                        /*--------------------------------------------------
                                        | 1. V / I — same fields as currentLog
                                        --------------------------------------------------*/
                                        $v1 = (float)($row->v1 ?? 0);
                                        $v2 = (float)($row->v2 ?? 0);
                                        $v3 = (float)($row->v3 ?? 0);

                                        $i1 = (float)($row->i1 ?? 0);
                                        $i2 = (float)($row->i2 ?? 0);
                                        $i3 = (float)($row->i3 ?? 0);

                                        /*--------------------------------------------------
                                        | 2. PF — mirror currentLog exactly:
                                        |    WaterScada  → getRandomPf() (display only)
                                        |                  but use REAL pf for kWh formula
                                        |    Normal      → actual pf1/pf2/pf3
                                        --------------------------------------------------*/
                                        $pf1_real = max(-1, min(1, (float)($row->pf1 ?? 0)));
                                        $pf2_real = max(-1, min(1, (float)($row->pf2 ?? 0)));
                                        $pf3_real = max(-1, min(1, (float)($row->pf3 ?? 0)));

                                        /*--------------------------------------------------
                                        | 3. Time interval = diff between last 2 entries
                                        |    Uses dtime (packet time), same as currentLog
                                        --------------------------------------------------*/
                                        $dtime        = $row->dtime ?? null;
                                        $current_time = ($dtime && $dtime !== '0000-00-00 00:00:00')
                                                            ? strtotime($dtime) : null;

                                        if ($prev_time !== null && $current_time !== null) {
                                            $diff_seconds   = abs($current_time - $prev_time);
                                            $diff_minutes   = $diff_seconds / 60;
                                            $interval_hours = $diff_minutes / 60;
                                            
                                        } else {
                                            $diff_seconds   = 0;
                                            $diff_minutes   = 0;
                                            $interval_hours = 0;
                                        }

                                        if ($current_time) $prev_time = $current_time;

                                        /*--------------------------------------------------
                                        | 4. kWh = V * I * PF * interval_hours (per phase)
                                        |    kW Load = (V1*I1*PF1 + V2*I2*PF2 + V3*I3*PF3) / 1000
                                        |    kWh_interval = kW_load * interval_hours
                                        --------------------------------------------------*/
                                        $p1      = $v1 * $i1 * $pf1_real;
                                        $p2      = $v2 * $i2 * $pf2_real;
                                        $p3      = $v3 * $i3 * $pf3_real;
                                        $kw_load = ($p1 + $p2 + $p3) / 1000;

                                        $kwh_interval = $kw_load * $interval_hours;
                                        $cumulative  += $kwh_interval;
                                    @endphp

                                    <tr>
                                        {{-- Time --}}
                                        <td>{{ appDate($row->dtime) }}</td>

                                        {{-- GlobalID — blue if dmdt_phase==1, same as currentLog --}}
                                        <td class="bb" @if($row->dmdt_phase == 1) style="color:blue;" @endif>
                                            {{ $row->global_device_id }}
                                        </td>

                                        {{-- Timing — same logic as currentLog --}}
                                        <td class="bb">
                                            @if($row->is_warterScade_device == 1)
                                                {{-- WaterScada: no peak/offpeak --}}
                                            @else
                                                @if(isset($row->isPk) && $row->isPk == 1) Peak @else Offpeak @endif
                                            @endif
                                        </td>

                                        {{-- Voltages --}}
                                        <td class="bb">{{ $v1 }}</td>
                                        <td>{{ $v2 }}</td>
                                        <td>{{ $v3 }}</td>

                                        {{-- Currents --}}
                                        <td class="bb">{{ $i1 }}</td>
                                        <td>{{ $i2 }}</td>
                                        <td>{{ $i3 }}</td>

                                        {{-- Power Factors — mirror currentLog display logic --}}
                                        @if($row->is_warterScade_device == 1)
                                            <td class="bb">{{ getRandomPf() }}</td>
                                            <td>{{ getRandomPf() }}</td>
                                            <td>{{ getRandomPf() }}</td>
                                        @else
                                            <td class="bb">{{ $row->pf1 }}</td>
                                            <td>{{ $row->pf2 }}</td>
                                            <td>{{ $row->pf3 }}</td>
                                        @endif

                                        {{-- kW Load --}}
                                        <td class="wb" style="color:#1565c0; font-weight:600;">
                                            {{ number_format($kw_load, 4) }}
                                        </td>

                                        {{-- Interval (minutes) --}}
                                        <td style="color:#555;">
                                            {{ number_format($diff_minutes, 2) }}
                                        </td>
                                        {{-- Interval (hours) --}}
                                        <td style="color:#555;">
                                            {{ number_format($interval_hours, 2) }}
                                        </td>

                                        {{-- kWh Interval --}}
                                        <td style="color:#2e7d32; font-weight:600;">
                                            {{ number_format($kwh_interval, 6) }}
                                        </td>

                                        {{-- kWh Cumulative --}}
                                        <td class="rbg" style="color:#b71c1c; font-weight:700;">
                                            {{ number_format($cumulative, 4) }}
                                        </td>
                                    </tr>

                                @endforeach

                            @else
                                <tr>
                                    <td colspan="17" class="text-danger">
                                        @if(request()->hasAny(['from','to','DeviceId']))
                                            Record Not Found
                                        @else
                                            Please select a Device and date range to load data.
                                        @endif
                                    </td>
                                </tr>
                            @endif

                        </tbody>

                        @if($data && $data->count() > 0)
                        <tfoot>
                            <tr>
                                <td colspan="13" class="text-right pr-2">Page Total:</td>
                                <td></td>
                                <td style="color:#2e7d32;">{{ number_format($cumulative, 4) }}</td>
                                <td style="color:#b71c1c;">{{ number_format($cumulative, 4) }} kWh</td>
                            </tr>
                        </tfoot>
                        @endif

                    </table>
                </div>

                <div class="d-flex mt-3">
                    @if ($data->hasPages())
                        {{ $data->appends(request()->query())->links('pagination::bootstrap-4') }}
                    @endif
                </div>

            </div>
        </div>
    </div>
</div>

@push('scripts')
<script src="{{asset('assets')}}/vendor/datepicker/js/picker.js"></script>
<script src="{{asset('assets')}}/vendor/datepicker/js/picker.date.js"></script>
<script src="{{asset('assets')}}/vendor/datepicker/js/custom-picker.js"></script>
<script src="{{asset('assets')}}/vendor/bs-select/bs-select.min.js"></script>
<script src="{{asset('assets')}}/js/main.js"></script>
@endpush

@endsection