@php $i = 1; $totalSeconds = 0; $count = 0; $totoal_totalDuration = 0; $total_voltageL_1_N_Parameter = 0; $total_voltageL_2_N_Parameter = 0; $total_voltageL_3_N_Parameter = 0; $total_voltageL_1_L_2_Parameter = 0; $total_voltageL_2_L_3_Parameter = 0; $total_voltageL_3_L_1_Parameter = 0; $total_currentL_1_Parameter = 0; $total_currentL_2_Parameter = 0; $total_currentL_3_Parameter = 0; $total_loadKwL_1_Parameter = 0; $total_loadKwL_2_Parameter = 0; $total_loadKwL_3_Parameter = 0; $total_totalKwParameter = 0; $total_totalLoadKwParameter = 0; $total_totalApPowerParameter = 0; $total_totalLoadKvaParameter = 0; @endphp @foreach ($data as $key => $value) @php $duration = explode(':', $value['duration']); $totalSeconds += $duration[0] * 3600 + $duration[1] * 60 + $duration[2]; $total_voltageL_1_N_Parameter += $value['voltageL_1_N_Parameter']; $total_voltageL_2_N_Parameter += $value['voltageL_2_N_Parameter']; $total_voltageL_3_N_Parameter += $value['voltageL_3_N_Parameter']; $total_voltageL_1_L_2_Parameter += $value['voltageL_1_L_2_Parameter']; $total_voltageL_2_L_3_Parameter += $value['voltageL_2_L_3_Parameter']; $total_voltageL_3_L_1_Parameter += $value['voltageL_3_L_1_Parameter']; $total_currentL_1_Parameter += $value['currentL_1_Parameter']; $total_currentL_2_Parameter += $value['currentL_2_Parameter']; $total_currentL_3_Parameter += $value['currentL_3_Parameter']; $total_loadKwL_1_Parameter += $value['loadKwL_1_Parameter']; $total_loadKwL_2_Parameter += $value['loadKwL_2_Parameter']; $total_loadKwL_3_Parameter += $value['loadKwL_3_Parameter']; $total_totalKwParameter += $value['totalKwParameter']; $total_totalLoadKwParameter += $value['totalLoadKwParameter']; $total_totalApPowerParameter += $value['totalApPowerParameter']; $total_totalLoadKvaParameter += $value['totalLoadKvaParameter']; $count++; @endphp @php $i++; @endphp @endforeach @php $hours = floor($totalSeconds / 3600); $minutes = floor(($totalSeconds / 60) % 60); $seconds = $totalSeconds % 60; $totalDuration = sprintf('%02d:%02d:%02d', $hours, $minutes, $seconds); @endphp

Start Time	End Time	Duration	Voltage L1-N	Voltage L2-N	Voltage L3-N	Voltage L1-L2	Voltage L2-L3	Voltage L3-L1	Current L1	Current L2	Current L3	Load KW L1	Load KW L2	Load KW L3	Total KW	Total Load KW	Total Apparent Power	Total Load KVA
{{ $value['startTime'] }}	{{ $value['endTime'] }}	{{ $value['duration'] }}	{{ round($value['voltageL_1_N_Parameter'], 2) }}	{{ round($value['voltageL_2_N_Parameter'], 2) }}	{{ round($value['voltageL_3_N_Parameter'], 2) }}	{{ round($value['voltageL_1_L_2_Parameter'], 2) }}	{{ round($value['voltageL_2_L_3_Parameter'], 2) }}	{{ round($value['voltageL_3_L_1_Parameter'], 2) }}	{{ round($value['currentL_1_Parameter'], 2) }}	{{ round($value['currentL_2_Parameter'], 2) }}	{{ round($value['currentL_3_Parameter'], 2) }}	{{ round($value['loadKwL_1_Parameter'], 2) }}	{{ round($value['loadKwL_2_Parameter'], 2) }}	{{ round($value['loadKwL_3_Parameter'], 2) }}	{{ round($value['totalKwParameter'], 2) }}	{{ round($value['totalLoadKwParameter'], 2) }}	{{ round($value['totalApPowerParameter'], 2) }}	{{ round($value['totalLoadKvaParameter'], 2) }}
Total:		{{ $totalDuration }}	{{ $count > 0 ? round($total_voltageL_1_N_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_voltageL_2_N_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_voltageL_3_N_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_voltageL_1_L_2_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_voltageL_2_L_3_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_voltageL_3_L_1_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_currentL_1_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_currentL_2_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_currentL_3_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_loadKwL_1_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_loadKwL_2_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_loadKwL_3_Parameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_totalKwParameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_totalLoadKwParameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_totalApPowerParameter / $count, 2) : 0 }}	{{ $count > 0 ? round($total_totalLoadKvaParameter / $count, 2) : 0 }}