221 lines
15 KiB
PHP
221 lines
15 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="18" style="background-color: #DAEEF3;text-align: center;border-right:1px solid black;"></th>
|
|
</tr>
|
|
<tr>
|
|
<th colspan="18" 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="18" style="background-color: #DAEEF3;text-align: center;border-right: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="16" 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;" data-id="1">نصب تابلوهای اخطاری ، انتظامی و مسیرنمای جدید </th>
|
|
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;" data-id="5">تعویض صفحه های تابلوهای اخطاری ، انتظامی فاقد بازتاب و معیوب </th>
|
|
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;" data-id="2">نصب تابلو های اطلاعاتی جدید</th>
|
|
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;" data-id="3">تعویض شبرنگ تابلوهای اطلاعاتی </th>
|
|
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;" data-id="6">مرمت شکستگی ، خم شدگی و ... تابلوهای اطلاعاتی </th>
|
|
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;" data-id="7">اصلاح کج شدگی پایه تابلوها و علائم </th>
|
|
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;" data-id="8">نصب یا برداشتن علائم موقت </th>
|
|
<th colspan="2" style="background-color: #c4d79b;border: 1px solid black; text-align:center;" data-id="4">نصب بازتاب بر روی گاردریل و حفاظ های حاشیه راه و چشم گربه ای</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>
|
|
</tr>
|
|
|
|
</thead>
|
|
|
|
<tbody>
|
|
@php
|
|
$lenghOfData = count($data);
|
|
$TabloEkhtariCount = 0;
|
|
$TabloEkhtariSum = 0;
|
|
$TavizTabloCount = 0;
|
|
$TavizTabloSum = 0;
|
|
$TabloEtelatiCount = 0;
|
|
$TabloEtelatiSum = 0;
|
|
$ShabrangCount = 0;
|
|
$ShabrangSum = 0;
|
|
$MarematCount = 0;
|
|
$MarematSum = 0;
|
|
$EslahKajShodegiCount = 0;
|
|
$EslahKajShodegiSum = 0;
|
|
$NasbAlaemMovaghatCount = 0;
|
|
$NasbAlaemMovaghatSum = 0;
|
|
$BaztabCount = 0;
|
|
$BaztabSum = 0;
|
|
// $data = json_decode($data, true);
|
|
@endphp
|
|
|
|
@foreach ($data as $key => $item)
|
|
@php
|
|
$TabloEkhtariCount += $item->TabloEkhtariCount;
|
|
$TabloEkhtariSum += $item->TabloEkhtariSum;
|
|
$TavizTabloCount += $item->TavizTabloCount;
|
|
$TavizTabloSum += $item->TavizTabloSum;
|
|
$TabloEtelatiCount += $item->TabloEtelatiCount;
|
|
$TabloEtelatiSum += $item->TabloEtelatiSum;
|
|
$ShabrangCount += $item->ShabrangCount;
|
|
$ShabrangSum += $item->ShabrangSum;
|
|
$MarematCount += $item->MarematCount;
|
|
$MarematSum += $item->MarematSum;
|
|
$EslahKajShodegiCount += $item->EslahKajShodegiCount;
|
|
$EslahKajShodegiSum += $item->EslahKajShodegiSum;
|
|
$NasbAlaemMovaghatCount += $item->NasbAlaemMovaghatCount;
|
|
$NasbAlaemMovaghatSum += $item->NasbAlaemMovaghatSum;
|
|
$BaztabCount += $item->BaztabCount;
|
|
$BaztabSum += $item->BaztabSum;
|
|
@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->TabloEkhtariCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->TabloEkhtariSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->TavizTabloCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->TavizTabloSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->TabloEtelatiCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->TabloEtelatiSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->ShabrangCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->ShabrangSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->MarematCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->MarematSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->EslahKajShodegiCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->EslahKajShodegiSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->NasbAlaemMovaghatCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->NasbAlaemMovaghatSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->BaztabCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;">{{$item->BaztabSum ?? '-'}}</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">{{$TabloEkhtariCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TabloEkhtariSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TavizTabloCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TavizTabloSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TabloEtelatiCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TabloEtelatiSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ShabrangCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ShabrangSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$MarematCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$MarematSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EslahKajShodegiCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EslahKajShodegiSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NasbAlaemMovaghatCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NasbAlaemMovaghatSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BaztabCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BaztabSum ?? '-'}}</td>
|
|
</tr>
|
|
@php
|
|
$TabloEkhtariCount = 0;
|
|
$TabloEkhtariSum = 0;
|
|
$TavizTabloCount = 0;
|
|
$TavizTabloSum = 0;
|
|
$TabloEtelatiCount = 0;
|
|
$TabloEtelatiSum = 0;
|
|
$ShabrangCount = 0;
|
|
$ShabrangSum = 0;
|
|
$MarematCount = 0;
|
|
$MarematSum = 0;
|
|
$EslahKajShodegiCount = 0;
|
|
$EslahKajShodegiSum = 0;
|
|
$NasbAlaemMovaghatCount = 0;
|
|
$NasbAlaemMovaghatSum = 0;
|
|
$BaztabCount = 0;
|
|
$BaztabSum = 0;
|
|
@endphp
|
|
@endif
|
|
@else
|
|
|
|
{{-- ///// style abi sotone akhar --}}
|
|
|
|
<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">{{$TabloEkhtariCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TabloEkhtariSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TavizTabloCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TavizTabloSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TabloEtelatiCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TabloEtelatiSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ShabrangCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$ShabrangSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$MarematCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$MarematSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EslahKajShodegiCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EslahKajShodegiSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NasbAlaemMovaghatCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$NasbAlaemMovaghatSum ?? '-'}}</td>
|
|
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BaztabCount ?? '-'}}</td>
|
|
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$BaztabSum ?? '-'}}</td>
|
|
</tr>
|
|
@endif
|
|
|
|
@endforeach
|
|
</tbody>
|
|
</table>
|
|
</body>
|
|
</html> |