Files
backend/resources/views/excel/CurrentActivities/Zemestani/City.blade.php

158 lines
9.9 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="12" style="background-color: #daeef3;border-right: 1px solid black;border-left: 1px solid black;;"></th>
</tr>
<tr>
<th colspan="12" 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="12" 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="10" 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>
</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>
</tr>
</thead>
<tbody>
@php
$YakhzodaeiCount = 0;
$YakhzodaeiSum = 0;
$BarfRoobiCount = 0;
$BarfRoobiSum = 0;
$MizanNamakCount = 0;
$MizanNamakSum = 0;
$MosaferinCount = 0;
$MosaferinSum = 0;
$KomakResaniCount = 0;
$KomakResaniSum = 0;
@endphp
@foreach ($data as $key => $item)
@php
$YakhzodaeiCount += $item->YakhzodaeiCount;
$YakhzodaeiSum += $item->YakhzodaeiSum;
$BarfRoobiCount += $item->BarfRoobiCount;
$BarfRoobiSum += $item->BarfRoobiSum;
$MizanNamakCount += $item->MizanNamakCount;
$MizanNamakSum += $item->MizanNamakSum;
$MosaferinCount += $item->MosaferinCount;
$MosaferinSum += $item->MosaferinSum;
$KomakResaniCount += $item->KomakResaniCount;
$KomakResaniSum += $item->KomakResaniSum;
@endphp
<tr>
<td style="text-align: center;border:1px solid black;">{{$item->province_fa}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->city_fa}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->YakhzodaeiCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->YakhzodaeiSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->BarfRoobiCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->BarfRoobiSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->MizanNamakCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->MizanNamakSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->MosaferinCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->MosaferinSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->KomakResaniCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;">{{$item->KomakResaniSum ?? '-'}}</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="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$YakhzodaeiCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$YakhzodaeiSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$BarfRoobiCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$BarfRoobiSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$MizanNamakCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$MizanNamakSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$MosaferinCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$MosaferinSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$KomakResaniCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$KomakResaniSum ?? '-'}}</td>
</tr>
@php
$YakhzodaeiCount = 0;
$YakhzodaeiSum = 0;
$BarfRoobiCount = 0;
$BarfRoobiSum = 0;
$MizanNamakCount = 0;
$MizanNamakSum = 0;
$MosaferinCount = 0;
$MosaferinSum = 0;
$KomakResaniCount = 0;
$KomakResaniSum = 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="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$YakhzodaeiCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$YakhzodaeiSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$BarfRoobiCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$BarfRoobiSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$MizanNamakCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$MizanNamakSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$MosaferinCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$MosaferinSum ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$KomakResaniCount ?? '-'}}</td>
<td style="text-align: center;border:1px solid black;background-color:#DAEEF3">{{$KomakResaniSum ?? '-'}}</td>
</tr>
@endif
@endforeach
</tbody>
</table>
</body>
</html>