Files

208 lines
16 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="20" style="background-color: #daeef3;border-right: 1px solid black;border-left: 1px solid black;;"></th>
</tr>
<tr>
<th colspan="20" 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="20" 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="18" 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>
<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>
<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
$lenghOfData = count($data);
$PaksaziCount = 0;
$PaksaziSum = 0;
$TaradodCount = 0;
$TaradodSum = 0;
$BargharariErtebatCount = 0;
$BargharariErtebatSum = 0;
$AbBordegiCount = 0;
$AbBordegiSum = 0;
$ShekastegiPolCount = 0;
$ShekastegiPolSum = 0;
$HedayatTrafficiCount = 0;
$HedayatTrafficiSum = 0;
$BozgoshaeiCount = 0;
$BozgoshaeiSum = 0;
$JabejayiCount = 0;
$JabejayiSum = 0;
$LaghgiriCount = 0;
$LaghgiriSum = 0;
@endphp
@foreach ($data as $key => $item)
@php
$PaksaziCount += $item->PaksaziCount;
$PaksaziSum += $item->PaksaziSum;
$TaradodCount += $item->TaradodCount;
$TaradodSum += $item->TaradodSum;
$BargharariErtebatCount += $item->BargharariErtebatCount;
$BargharariErtebatSum += $item->BargharariErtebatSum;
$AbBordegiCount += $item->AbBordegiCount;
$AbBordegiSum += $item->AbBordegiSum;
$ShekastegiPolCount += $item->ShekastegiPolCount;
$ShekastegiPolSum += $item->ShekastegiPolSum;
$HedayatTrafficiCount += $item->HedayatTrafficiCount;
$HedayatTrafficiSum += $item->HedayatTrafficiSum;
$BozgoshaeiCount += $item->BozgoshaeiCount;
$BozgoshaeiSum += $item->BozgoshaeiSum;
$JabejayiCount += $item->JabejayiCount;
$JabejayiSum += $item->JabejayiSum;
$LaghgiriCount += $item->LaghgiriCount;
$LaghgiriSum += $item->LaghgiriSum;
@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->PaksaziCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->PaksaziSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->TaradodCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->TaradodSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->BargharariErtebatCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->BargharariErtebatSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->AbBordegiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->AbBordegiSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->ShekastegiPolCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->ShekastegiPolSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->HedayatTrafficiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->HedayatTrafficiSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->BozgoshaeiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->BozgoshaeiSum ?? '-'}}</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>
<td style="border:1px solid black;text-align: center;">{{$item->LaghgiriCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;">{{$item->LaghgiriSum ?? '-'}}</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">{{$PaksaziCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$PaksaziSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$TaradodCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$TaradodSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$BargharariErtebatCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$BargharariErtebatSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$AbBordegiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$AbBordegiSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$ShekastegiPolCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$ShekastegiPolSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$HedayatTrafficiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$HedayatTrafficiSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$BozgoshaeiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$BozgoshaeiSum ?? '-'}}</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>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$LaghgiriCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$LaghgiriSum ?? '-'}}</td>
</tr>
@php
$PaksaziCount = 0;
$PaksaziSum = 0;
$TaradodCount = 0;
$TaradodSum = 0;
$BargharariErtebatCount = 0;
$BargharariErtebatSum = 0;
$AbBordegiCount = 0;
$AbBordegiSum = 0;
$ShekastegiPolCount = 0;
$ShekastegiPolSum = 0;
$HedayatTrafficiCount = 0;
$HedayatTrafficiSum = 0;
$BozgoshaeiCount = 0;
$BozgoshaeiSum = 0;
$JabejayiCount = 0;
$JabejayiSum = 0;
$LaghgiriCount = 0;
$LaghgiriSum = 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">{{$PaksaziCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$PaksaziSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$TaradodCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$TaradodSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$BargharariErtebatCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$BargharariErtebatSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$AbBordegiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$AbBordegiSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$ShekastegiPolCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$ShekastegiPolSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$HedayatTrafficiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$HedayatTrafficiSum ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$BozgoshaeiCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$BozgoshaeiSum ?? '-'}}</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>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$LaghgiriCount ?? '-'}}</td>
<td style="border:1px solid black;text-align: center;background-color:#DAEEF3">{{$LaghgiriSum ?? '-'}}</td>
</tr>
@endif
@endforeach
</tbody>
</table>
</body>
</html>