@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>{{ \Carbon\Carbon::parse($row->stime)->format('Y-m-d h:i A') }}</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
                                        @php
    if (!defined('PF_MIN_TRANSFORMER')) {
        define('PF_MIN_TRANSFORMER', 0.80);
    }
    if (!defined('PF_MAX_TRANSFORMER')) {
        define('PF_MAX_TRANSFORMER', 1.00);
    }
    if (!defined('LOW_PF_LIMIT')) {
        define('LOW_PF_LIMIT', 0.60);
    }

    if (!function_exists('generateRandomPF')) {
        function generateRandomPF()
        {
            return PF_MIN_TRANSFORMER +
                (mt_rand() / mt_getrandmax()) *
                (PF_MAX_TRANSFORMER - PF_MIN_TRANSFORMER);
        }
    }

    if (!function_exists('calculatePhasePF')) {
        function calculatePhasePF($v, $i, $pf)
        {
            $kVA = (floatval($v) * floatval($i)) / 1000;
            $kW  = (floatval($v) * floatval($i) * floatval($pf)) / 1000;

            if ($kVA <= 0) {
                return 0;
            }
            if ($kW > $kVA) {
                return 0;
            }

            $calculatedPF = $kW / $kVA;

            if ($calculatedPF < LOW_PF_LIMIT) {
                return round(generateRandomPF(), 2);
            }

            return round($calculatedPF, 2);
        }
    }

    if (($row->dmdt_phase ?? 3) == 3) {
        $pf1 = calculatePhasePF($row->v1, $row->i1, $row->pf1);
        $pf2 = calculatePhasePF($row->v2, $row->i2, $row->pf2);
        $pf3 = calculatePhasePF($row->v3, $row->i3, $row->pf3);
    } else {
        $pf1 = calculatePhasePF($row->v1, $row->i1, $row->pf1);
        $pf2 = 0;
        $pf3 = 0;
    }
@endphp


                                        <td class="bb">{{ $pf1 }}</td>
                                        <td>{{ $pf2 }}</td>
                                        <td>{{ $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 --}}

                                        @php
                                            $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)
                                            );

                                            $nc = round($nc, 2);

                                            // Neutral loss (W)
                                            $nc_loss = pow($nc, 2) * $R;
                                        @endphp

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

                                    <td class="bb">
                                        {{ number_format($nc_loss / 1000, 3) }} {{-- kW --}}
                                    </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>