175 lines
13 KiB
PHP
175 lines
13 KiB
PHP
<!DOCTYPE html>
|
||
<html lang="en">
|
||
<head>
|
||
<meta charset="UTF-8">
|
||
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
||
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
||
<title>شهرستانی</title>
|
||
</head>
|
||
<body dir="rtl">
|
||
<table>
|
||
<thead>
|
||
<tr>
|
||
<th colspan="16" style="background-color: #daeef3;border-right: 1px solid black;border-left: 1px solid black;;"></th>
|
||
</tr>
|
||
<tr>
|
||
<th colspan="16" style="background-color: #DAEEF3;text-align: center;border-right:1px solid black;font-weight:bolder;font-size: 13;">
|
||
تعداد و احجام فعالیت های روزانه و جاری راهداری ثبت شده از تاریخ
|
||
{{verta($fromDate)->format('Y/n/j')}}
|
||
تا
|
||
تاریخ
|
||
{{verta($toDate)->format('Y/n/j')}}
|
||
</th>
|
||
</tr>
|
||
<tr>
|
||
<th colspan="16" style="background-color: #daeef3;border-right: 1px solid black;border-left: 1px solid black;;"></th>
|
||
</tr>
|
||
<tr>
|
||
<th rowspan="3" style="background-color: #ebf1de;border:1px solid black;text-align: center;">اداره کل</th>
|
||
<th rowspan="3" style="background-color: #ebf1de;border:1px solid black;text-align: center;">شهرستان</th>
|
||
<th colspan="14" style="background-color: #ebf1de;border:1px solid black;text-align: center;">فعالیتهای ماشین آلات</th>
|
||
</tr>
|
||
|
||
<tr>
|
||
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;">بنزین مصرفی کل ماشین آلات فعال - ماهانه</th>
|
||
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;">گازوئیل مصرفی کل ماشین آلات فعال - ماهانه</th>
|
||
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;">مواد مصرفی نفتی و انواع روغن - ماهانه</th>
|
||
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;">بازسازی و راه اندازی ماشین آلات</th>
|
||
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;">سرویس کاری و تعمیرات جزئی روزانه</th>
|
||
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;">شستشو نمک پاش ها و سایر ماشین آلات</th>
|
||
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;">جا به جایی دستگاه های سنگین راهداری</th>
|
||
</tr>
|
||
<tr>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">تعداد</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">مجموع</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">تعداد</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">مجموع</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">تعداد</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">مجموع</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">تعداد</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">مجموع</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">تعداد</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">مجموع</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">تعداد</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">مجموع</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">تعداد</th>
|
||
<th style="background-color: #fde9d9;border: 1px solid black;text-align: center;">مجموع</th>
|
||
</tr>
|
||
|
||
</thead>
|
||
|
||
<tbody>
|
||
@php
|
||
$BenzinMasrafiCount = 0;
|
||
$BenzinMasrafiSum = 0;
|
||
$GazMasrafiCount = 0;
|
||
$GazMasrafiSum = 0;
|
||
$MavadNaftiCount = 0;
|
||
$MavadNaftiSum = 0;
|
||
$BazsaziCount = 0;
|
||
$BazsaziSum = 0;
|
||
$ServiceCount = 0;
|
||
$ServiceSum = 0;
|
||
$NamakPashCount = 0;
|
||
$NamakPashSum = 0;
|
||
$JabejayiCount = 0;
|
||
$JabejayiSum = 0;
|
||
@endphp
|
||
|
||
@foreach ($data as $key => $item)
|
||
@php
|
||
$BenzinMasrafiCount += $item->BenzinMasrafiCount;
|
||
$BenzinMasrafiSum += $item->BenzinMasrafiSum;
|
||
$GazMasrafiCount += $item->GazMasrafiCount;
|
||
$GazMasrafiSum += $item->GazMasrafiSum;
|
||
$MavadNaftiCount += $item->MavadNaftiCount;
|
||
$MavadNaftiSum += $item->MavadNaftiSum;
|
||
$BazsaziCount += $item->BazsaziCount;
|
||
$BazsaziSum += $item->BazsaziSum;
|
||
$ServiceCount += $item->ServiceCount;
|
||
$ServiceSum += $item->ServiceSum;
|
||
$NamakPashCount += $item->NamakPashCount;
|
||
$NamakPashSum += $item->NamakPashSum;
|
||
$JabejayiCount += $item->JabejayiCount;
|
||
$JabejayiSum += $item->JabejayiSum;
|
||
@endphp
|
||
<tr>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->province_fa}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->city_fa}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->BenzinMasrafiCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->BenzinMasrafiSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->GazMasrafiCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->GazMasrafiSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->MavadNaftiCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->MavadNaftiSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->BazsaziCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->BazsaziSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->ServiceCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->ServiceSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->NamakPashCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->NamakPashSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->JabejayiCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->JabejayiSum}}</td>
|
||
</tr>
|
||
|
||
|
||
@if(isset($data[$key + 1]))
|
||
@if($data[$key + 1]->province_id != $data[$key]->province_id)
|
||
<tr>
|
||
<td colspan="2" style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$item->province_fa ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BenzinMasrafiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BenzinMasrafiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$GazMasrafiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$GazMasrafiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$MavadNaftiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$MavadNaftiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BazsaziCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BazsaziSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ServiceCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ServiceSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NamakPashCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NamakPashSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$JabejayiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$JabejayiSum ?? '-'}}</td>
|
||
</tr>
|
||
@php
|
||
$BenzinMasrafiCount = 0;
|
||
$BenzinMasrafiSum = 0;
|
||
$GazMasrafiCount = 0;
|
||
$GazMasrafiSum = 0;
|
||
$MavadNaftiCount = 0;
|
||
$MavadNaftiSum = 0;
|
||
$BazsaziCount = 0;
|
||
$BazsaziSum = 0;
|
||
$ServiceCount = 0;
|
||
$ServiceSum = 0;
|
||
$NamakPashCount = 0;
|
||
$NamakPashSum = 0;
|
||
$JabejayiCount = 0;
|
||
$JabejayiSum = 0;
|
||
@endphp
|
||
@endif
|
||
@else
|
||
<tr>
|
||
<td colspan="2" style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$item->province_fa ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BenzinMasrafiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BenzinMasrafiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$GazMasrafiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$GazMasrafiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$MavadNaftiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$MavadNaftiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BazsaziCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BazsaziSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ServiceCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ServiceSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NamakPashCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NamakPashSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$JabejayiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$JabejayiSum ?? '-'}}</td>
|
||
</tr>
|
||
@endif
|
||
@endforeach
|
||
</tbody>
|
||
</table>
|
||
</body>
|
||
</html> |