@include('dashboards.header')

<style>
    /* Borders */
    .wb { border-left: 1px solid #fff !important; }
    .bb { border-left: 1px solid #dcdcdc !important; }
    .rbg { border-right: 1px solid #dcdcdc !important; }

    /* Table enhancements */
    .table-container {
        background: #fff;
        border-radius: 10px;
        padding: 10px;
        box-shadow: 0 2px 6px rgba(0,0,0,0.08);
    }

    thead th {
        background: #f5f6fa !important;
        font-weight: 700;
        font-size: 11px;
        text-transform: uppercase;
        border-bottom: 2px solid #ccc !important;
    }

    tbody tr:hover {
        background: #f7f9fc !important;
    }

    .table-responsive {
        max-height: 780px;
        overflow-y: auto;
        border-radius: 8px;
    }

    .page-container {
        max-width: 98%;
        margin: auto;
    }
</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')}}"/>

@php
    $R = 0.81285; // AAC 50mm², 1.5 km
@endphp
<div class="page-container mt-3">
        <h3>
                Current Logs
</h3>
    <div class="row gutters">
        <div class="col-12">

            <div class="table-container">

                <div class="table-responsive">
                    <table class="table table-hover m-0" style="font-size: 11px !important;">
                        <thead style="position: sticky; top: 0; z-index: 10;">
                        <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 class="wb text-center">NC</th>
                            <th class="wb text-center">Neutral Loss</th>
                            <th colspan="3" class="wb text-center">Load Direction</th>
                        </tr>

                        <tr>
                            <th class="wb">v1</th><th>v2</th><th>v3</th>
                            <th class="wb">i1</th><th>i2</th><th>i3</th>
                            <th class="wb">pf1</th><th>pf2</th><th>pf3</th>
                            <th class="wb"></th>
                            <th class="wb"></th>
                            <th class="wb">d1</th><th>d2</th><th>d3</th>
                        </tr>
                        </thead>

                        <tbody>
                        @if($logsdata && !$logsdata->isEmpty())
                            @foreach($logsdata as $row)
                                <tr>
                                    <td>{{ appDate($row->dtime) }}</td>

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

                                    <td class="bb">
                                        {{ $row->isPk ? 'Peak' : 'Offpeak' }}
                                    </td>

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

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

                                    <!-- PF -->
                                    @if($row->category=='SDBB')
                                        <td class="bb">-</td><td>-</td><td>-</td>
                                    @else
                                        <td class="bb">{{ $row->pf1 }}</td>
                                        <td>{{ $row->pf2 }}</td>
                                        <td>{{ $row->pf3 }}</td>
                                    @endif

{{--                                    <td class="bb">{{ $row->nc }}</td>--}}

{{--                                    NC Lass area--}}
                                    @php
                                        if ($row->is_warterScade_device == 1) {

                                            $nc = sqrt(
                                                pow($row->i1, 2)
                                              + pow($row->i2, 2)
                                              + pow($row->i3, 2)
                                              - ($row->i1 * $row->i2)
                                              - ($row->i2 * $row->i3)
                                              - ($row->i3 * $row->i1)
                                            );

                                        } else {
                                            $nc = $row->nc ?? 0;
                                        }

                                        $nc = round($nc, 2);

                                        // Neutral Loss (I²R)
                                        $nc_loss = pow($nc, 2) * $R; // Watts

                                        @endphp

                                    <td class="bb">
                                        {{ number_format($nc, 2) }}
                                    </td>

                                    <td class="bb">
                                        {{ number_format($nc_loss / 1000, 3) }} {{-- kW --}}
                                    </td>
                                    <td class="bb">{{ $row->d1 == 1 ? 'F' : 'R' }}</td>
                                    <td>{{ $row->d2 == 1 ? 'F' : 'R' }}</td>
                                    <td class="rbg">{{ $row->d3 == 1 ? 'F' : 'R' }}</td>
                                </tr>
                            @endforeach
                        @else
                            <tr>
                                <td colspan="25" class="text-danger text-center py-3">No Records Found</td>
                            </tr>
                        @endif
                        </tbody>
                    </table>
                </div>

                <!-- pagination -->
                <div class="d-flex justify-content-center mt-3">
                    {{ $logsdata->appends(request()->query())->links('pagination::bootstrap-4') }}
                </div>

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

<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>