@extends('layouts.app')

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

        .bb {
            border-left: 1px solid lightgray !important;
        }
        thead th{
    background:#243A84;
    color:#fff;
    border:1px solid #4458a8;
    text-align:center;
    vertical-align:middle;
    white-space:nowrap;
    padding:8px 6px;
    font-size:12px;
    font-weight:600;
}

thead tr:first-child th{
    font-size:13px;
    font-weight:700;
}

thead tr:nth-child(2) th{
    padding-bottom:2px;
}

thead tr:nth-child(3) th{
    padding-top:0;
    padding-bottom:6px;
    font-size:11px;
    font-weight:700;
}

.red{
    color:#ff5252;
}

.yellow{
    color:#ffd633;
}

.blue{
    color:#33a8ff;
}
    </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('rawpanel')}}">
                <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 DeviceId " name="DeviceId" required>
                                <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="datetime-local" class="form-control" required 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="datetime-local" class="form-control" required 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>
                    <!-- ✅ Download Button (RIGHT SIDE) -->
                    <div class="form-group mb-0 ml-auto">
                        <label class="label d-block">&nbsp;</label>
                        <a href="{{ route('rawpanel.export', request()->query()) }}" class="btn btn-success">
                            <i class="fas fa-file-excel"></i> Download Excel
                        </a>
                    </div>
                </div>
            </form>
        </div>


        <div class="col-xl-12 col-lg-12 col-md-12 col-sm-2 col-12">
            <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;">
               <thead style="position:sticky; top:0; z-index:10;">

    <!-- Row 1 -->
    <tr>
        <th rowspan="3">Time</th>
        <th rowspan="3">GlobalID</th>
        <th rowspan="3">Timing</th>
        <th rowspan="3">isRv</th>

        <th colspan="3">Voltages</th>
        <th colspan="3">Currents</th>
        <th colspan="3">Power Factors</th>
        <th colspan="3">Total Power</th>

        <th colspan="6">Energy (kWh)</th>
        <th colspan="6">Energy (rkWh)</th>

        <th colspan="3">Active Power/Phase</th>
        <th colspan="3">Apparent Power/Phase</th>
        <th colspan="3">Reactive Power/Phase</th>
        <th rowspan="3">NC</th>
        <th rowspan="3">NCloss</th>
        <th colspan="3">THD (Voltage)</th>
    </tr>

    <!-- Row 2 -->
    <tr>
        <!-- Voltages -->
        <th>v1</th>
        <th>v2</th>
        <th>v3</th>

        <!-- Currents -->
        <th>i1</th>
        <th>i2</th>
        <th>i3</th>

        <!-- Power Factors -->
        <th>pf1</th>
        <th>pf2</th>
        <th>pf3</th>

        <!-- Total Power -->
        <th>kW</th>
        <th>kVA</th>
        <th>kVAR</th>

        <!-- Energy -->
        <th>kwho1</th>
        <th>kwho2</th>
        <th>kwho3</th>
        <th>kwhp1</th>
        <th>kwhp2</th>
        <th>kwhp3</th>

        <!-- Reactive Energy -->
        <th>rkwho1</th>
        <th>rkwho2</th>
        <th>rkwho3</th>
        <th>rkwhp1</th>
        <th>rkwhp2</th>
        <th>rkwhp3</th>

        <!-- Active Power/Phase -->
        <th>kw1</th>
        <th>kw2</th>
        <th>kw3</th>

        <!-- Apparent Power/Phase -->
        <th>kva1</th>
        <th>kva2</th>
        <th>kva3</th>

        <!-- Reactive Power/Phase -->
        <th>kvar1</th>
        <th>kvar2</th>
        <th>kvar3</th>

        <!-- THD -->
        <th>thdva</th>
        <th>thdvb</th>
        <th>thdvc</th>
    </tr>

    <!-- Row 3 -->
    <tr>
        <!-- Voltages -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <!-- Currents -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <!-- PF -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <!-- Total Power -->
        <th></th>
        <th></th>
        <th></th>

        <!-- kWh -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <!-- rkWh -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <!-- Active Power/Phase -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <!-- Apparent Power/Phase -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <!-- Reactive Power/Phase -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>

        <!-- THD -->
        <th><span class="red">Red</span></th>
        <th><span class="yellow">Yellow</span></th>
        <th><span class="blue">Blue</span></th>
    </tr>

</thead>
                        <tbody class="recent-record-row">
                        @if($data && (!$data->isEmpty()))
                            @foreach($data as $row)
                                @php
                                    $v1 = floatval($row->v1 ?? 0);
                                    $v2 = floatval($row->v2 ?? 0);
                                    $v3 = floatval($row->v3 ?? 0);

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

                                    $pf1 = floatval($row->pf1 ?? 0);
                                    $pf2 = floatval($row->pf2 ?? 0);
                                    $pf3 = floatval($row->pf3 ?? 0);

                                    // Apparent power per phase (kVA): S = V x I / 1000
                                    $s1 = ($v1 * $i1) / 1000;
                                    $s2 = ($v2 * $i2) / 1000;
                                    $s3 = ($v3 * $i3) / 1000;
                                    $rowApparentPower = $s1 + $s2 + $s3;

                                    // Active power per phase (kW): P = V x I x PF / 1000
                                    $p1 = ($v1 * $i1 * $pf1) / 1000;
                                    $p2 = ($v2 * $i2 * $pf2) / 1000;
                                    $p3 = ($v3 * $i3 * $pf3) / 1000;
                                    $rowActivePower = $p1 + $p2 + $p3;

                                    // Reactive power (kVAR): Q = sqrt(S^2 - P^2)
                                    $rowReactivePower = sqrt(max(pow($rowApparentPower, 2) - pow($rowActivePower, 2), 0));

                                    // Neutral current: approximated for a balanced 120° 3-phase system
                                    // I_N = sqrt(I1² + I2² + I3² - I1*I2 - I2*I3 - I3*I1)
                                    $ncValue = sqrt(max(
                                        pow($i1, 2) + pow($i2, 2) + pow($i3, 2)
                                        - ($i1 * $i2) - ($i2 * $i3) - ($i3 * $i1),
                                        0
                                    ));

                                    // Neutral loss (kW): P = I² * R / 1000, R = 0.81285 (same constant used in dashboard)
                                    $ncLoss = (pow($ncValue, 2) * 0.81285) / 1000;
                                @endphp
                                <tr>
                                    <td>{{ \Carbon\Carbon::parse($row->stime)->format('Y-m-d h:i:s') }}</td>
                                    <td @if($row->dmdt_phase==1)
                                        {{'class="bg-success"'}}
                                        @endif> {{$row->global_device_id}}</td>
                                    <td>@if($row->isPk==1)
                                            Peak
                                        @else
                                            Offpeak
                                        @endif</td>
                                    <td>{{$row->isRv}}</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>
                                    <!-- Power Factors -->
                                    <td class="bb">{{$row->pf1}}</td>
                                    <td>{{$row->pf2}}</td>
                                    <td>{{$row->pf3}}</td>
                                    {{-- Power Summary --}}
                                    <td class="bb">{{ number_format($rowActivePower, 2) }}</td>
                                    <td>{{ number_format($rowApparentPower, 2) }}</td>
                                    <td>{{ number_format($rowReactivePower, 2) }}</td>
                                    <!-- Energy (kWh) -->
                                    <td class="bb">{{$row->kwho1}}</td>
                                    <td>{{$row->kwho2}}</td>
                                    <td>{{$row->kwho3}}</td>
                                    <td>{{$row->kwhp1}}</td>
                                    <td>{{$row->kwhp2}}</td>
                                    <td>{{$row->kwhp3}}</td>
                                    <!-- Reactive Energy (rkWh) -->
                                    <td class="bb">{{$row->rkwho1}}</td>
                                    <td>{{$row->rkwho2}}</td>
                                    <td>{{$row->rkwho3}}</td>
                                    <td>{{$row->rkwhp1}}</td>
                                    <td>{{$row->rkwhp2}}</td>
                                    <td>{{$row->rkwhp3}}</td>

                                    <!-- Per-phase Active Power -->
                                    <td class="bb">{{$row->kw1}}</td>
                                    <td>{{$row->kw2}}</td>
                                    <td>{{$row->kw3}}</td>

                                    <!-- Per-phase Apparent Power -->
                                    <td class="bb">{{$row->kva1}}</td>
                                    <td>{{$row->kva2}}</td>
                                    <td>{{$row->kva3}}</td>

                                    <!-- Per-phase Reactive Power -->
                                    <td class="bb">{{$row->kvar1}}</td>
                                    <td>{{$row->kvar2}}</td>
                                    <td>{{$row->kvar3}}</td>

                                    <!-- Neutral -->
                                    <td class="bb">{{ number_format($ncValue, 2) }}</td>
                                    <td>{{ number_format($ncLoss, 4) }}</td>

                                    <!-- THD Voltage -->
                                    <td class="bb">{{$row->thdva}}</td>
                                    <td>{{$row->thdvb}}</td>
                                    <td>{{$row->thdvc}}</td>
                                </tr>
                            @endforeach
                        @else
                            <tr>
                                <td colspan="42" class="text-danger">Record Not Found</td>
                            </tr>
                        @endif
                        </tbody>
                    </table>


                </div>
                <div class="d-flex  mt-3">
                    {{ $data->appends(request()->query())->links('pagination::bootstrap-4') }}
                </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>
        <script>

        </script>
    @endpush

@endsection