253 lines
20 KiB
PHP
253 lines
20 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="26" style="background-color: #daeef3;border-right: 1px solid black;border-left: 1px solid black;;"></th>
|
||
</tr>
|
||
<tr>
|
||
<th colspan="26" 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="26" 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="24" 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>
|
||
<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>
|
||
<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
|
||
$ImensaziSarguardCount = 0;
|
||
$ImensaziSarguardSum = 0;
|
||
$TamiratCheraqCount = 0;
|
||
$TamiratCheraqSum = 0;
|
||
$IjadShiarCount = 0;
|
||
$IjadShiarSum = 0;
|
||
$IjadLarzanandeCount = 0;
|
||
$IjadLarzanandeSum = 0;
|
||
$ZarbegirCount = 0;
|
||
$ZarbegirSum = 0;
|
||
$OstevaneImeniCount = 0;
|
||
$OstevaneImeniSum = 0;
|
||
$NasbSoratgirCount = 0;
|
||
$NasbSoratgirSum = 0;
|
||
$EhdasSoratgirCount = 0;
|
||
$EhdasSoratgirSum = 0;
|
||
$EjrayeNoghteyiCount = 0;
|
||
$EjrayeNoghteyiSum = 0;
|
||
$EjrayeTooliCount = 0;
|
||
$EjrayeTooliSum = 0;
|
||
$TarizMaghtaeiCount = 0;
|
||
$TarizMaghtaeiSum = 0;
|
||
$HazfMavaneCount = 0;
|
||
$HazfMavaneSum = 0;
|
||
@endphp
|
||
@foreach ($data as $key => $item)
|
||
@php
|
||
$ImensaziSarguardCount += $item->ImensaziSarguardCount;
|
||
$ImensaziSarguardSum += $item->ImensaziSarguardSum;
|
||
$TamiratCheraqCount += $item->TamiratCheraqCount;
|
||
$TamiratCheraqSum += $item->TamiratCheraqSum;
|
||
$IjadShiarCount += $item->IjadShiarCount;
|
||
$IjadShiarSum += $item->IjadShiarSum;
|
||
$IjadLarzanandeCount += $item->IjadLarzanandeCount;
|
||
$IjadLarzanandeSum += $item->IjadLarzanandeSum;
|
||
$ZarbegirCount += $item->ZarbegirCount;
|
||
$ZarbegirSum += $item->ZarbegirSum;
|
||
$OstevaneImeniCount += $item->OstevaneImeniCount;
|
||
$OstevaneImeniSum += $item->OstevaneImeniSum;
|
||
$NasbSoratgirCount += $item->NasbSoratgirCount;
|
||
$NasbSoratgirSum += $item->NasbSoratgirSum;
|
||
$EhdasSoratgirCount += $item->EhdasSoratgirCount;
|
||
$EhdasSoratgirSum += $item->EhdasSoratgirSum;
|
||
$EjrayeNoghteyiCount += $item->EjrayeNoghteyiCount;
|
||
$EjrayeNoghteyiSum += $item->EjrayeNoghteyiSum;
|
||
$EjrayeTooliCount += $item->EjrayeTooliCount;
|
||
$EjrayeTooliSum += $item->EjrayeTooliSum;
|
||
$TarizMaghtaeiCount += $item->TarizMaghtaeiCount;
|
||
$TarizMaghtaeiSum += $item->TarizMaghtaeiSum;
|
||
$HazfMavaneCount += $item->HazfMavaneCount;
|
||
$HazfMavaneSum += $item->HazfMavaneSum;
|
||
@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->ImensaziSarguardCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->ImensaziSarguardSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->TamiratCheraqCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->TamiratCheraqSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->IjadShiarCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->IjadShiarSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->IjadLarzanandeCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->IjadLarzanandeSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->ZarbegirCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->ZarbegirSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->OstevaneImeniCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->OstevaneImeniSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->NasbSoratgirCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->NasbSoratgirSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->EhdasSoratgirCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->EhdasSoratgirSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->EjrayeNoghteyiCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->EjrayeNoghteyiSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->EjrayeTooliCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->EjrayeTooliSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->TarizMaghtaeiCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->TarizMaghtaeiSum}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->HazfMavaneCount}}</td>
|
||
<td style="border: 1px solid black;text-align: center;">{{$item->HazfMavaneSum}}</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">{{$ImensaziSarguardCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ImensaziSarguardSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TamiratCheraqCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TamiratCheraqSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$IjadShiarCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$IjadShiarSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$IjadLarzanandeCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$IjadLarzanandeSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ZarbegirCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ZarbegirSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$OstevaneImeniCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$OstevaneImeniSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NasbSoratgirCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NasbSoratgirSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EhdasSoratgirCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EhdasSoratgirSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeNoghteyiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeNoghteyiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeTooliCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeTooliSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TarizMaghtaeiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TarizMaghtaeiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$HazfMavaneCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$HazfMavaneSum ?? '-'}}</td>
|
||
</tr>
|
||
@php
|
||
$ImensaziSarguardCount = 0;
|
||
$ImensaziSarguardSum = 0;
|
||
$TamiratCheraqCount = 0;
|
||
$TamiratCheraqSum = 0;
|
||
$IjadShiarCount = 0;
|
||
$IjadShiarSum = 0;
|
||
$IjadLarzanandeCount = 0;
|
||
$IjadLarzanandeSum = 0;
|
||
$ZarbegirCount = 0;
|
||
$ZarbegirSum = 0;
|
||
$OstevaneImeniCount = 0;
|
||
$OstevaneImeniSum = 0;
|
||
$NasbSoratgirCount = 0;
|
||
$NasbSoratgirSum = 0;
|
||
$EhdasSoratgirCount = 0;
|
||
$EhdasSoratgirSum = 0;
|
||
$EjrayeNoghteyiCount = 0;
|
||
$EjrayeNoghteyiSum = 0;
|
||
$EjrayeTooliCount = 0;
|
||
$EjrayeTooliSum = 0;
|
||
$TarizMaghtaeiCount = 0;
|
||
$TarizMaghtaeiSum = 0;
|
||
$HazfMavaneCount = 0;
|
||
$HazfMavaneSum = 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">{{$ImensaziSarguardCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ImensaziSarguardSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TamiratCheraqCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TamiratCheraqSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$IjadShiarCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$IjadShiarSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$IjadLarzanandeCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$IjadLarzanandeSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ZarbegirCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ZarbegirSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$OstevaneImeniCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$OstevaneImeniSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NasbSoratgirCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NasbSoratgirSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EhdasSoratgirCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EhdasSoratgirSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeNoghteyiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeNoghteyiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeTooliCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeTooliSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TarizMaghtaeiCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TarizMaghtaeiSum ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$HazfMavaneCount ?? '-'}}</td>
|
||
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$HazfMavaneSum ?? '-'}}</td>
|
||
</tr>
|
||
@endif
|
||
@endforeach
|
||
</tbody>
|
||
</table>
|
||
</body>
|
||
</html> |