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

164 lines
12 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="14" style="background-color: #daeef3;border-right: 1px solid black;border-left: 1px solid black;;"></th>
</tr>
<tr>
<th colspan="14" 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="14" 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="12" 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>
</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>
</tr>
</thead>
<tbody>
@php
$KhatkeshiRangGarmCount = 0;
$KhatkeshiRangGarmSum = 0;
$KhatkeshiRangSardCount = 0;
$KhatkeshiRangSardSum = 0;
$TarsimKhatCount = 0;
$TarsimKhatSum = 0;
$EjrayeTooliCount = 0;
$EjrayeTooliSum = 0;
$EjrayeArziCount = 0;
$EjrayeArziSum = 0;
$PakKardanKhotootCount = 0;
$PakKardanKhotootSum = 0;
@endphp
@foreach ($data as $key => $item)
@php
$KhatkeshiRangGarmCount += $item->KhatkeshiRangGarmCount;
$KhatkeshiRangGarmSum += $item->KhatkeshiRangGarmSum;
$KhatkeshiRangSardCount += $item->KhatkeshiRangSardCount;
$KhatkeshiRangSardSum += $item->KhatkeshiRangSardSum;
$TarsimKhatCount += $item->TarsimKhatCount;
$TarsimKhatSum += $item->TarsimKhatSum;
$EjrayeTooliCount += $item->EjrayeTooliCount;
$EjrayeTooliSum += $item->EjrayeTooliSum;
$EjrayeArziCount += $item->EjrayeArziCount;
$EjrayeArziSum += $item->EjrayeArziSum;
$PakKardanKhotootCount += $item->PakKardanKhotootCount;
$PakKardanKhotootSum += $item->PakKardanKhotootSum;
@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->KhatkeshiRangGarmCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->KhatkeshiRangGarmSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->KhatkeshiRangSardCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->KhatkeshiRangSardSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->TarsimKhatCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->TarsimKhatSum ?? '-'}}</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->EjrayeArziCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->EjrayeArziSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->PakKardanKhotootCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->PakKardanKhotootSum ?? '-'}}</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">{{$KhatkeshiRangGarmCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$KhatkeshiRangGarmSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$KhatkeshiRangSardCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$KhatkeshiRangSardSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TarsimKhatCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TarsimKhatSum ?? '-'}}</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">{{$EjrayeArziCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeArziSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$PakKardanKhotootCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$PakKardanKhotootSum ?? '-'}}</td>
</tr>
@php
$KhatkeshiRangGarmCount = 0;
$KhatkeshiRangGarmSum = 0;
$KhatkeshiRangSardCount = 0;
$KhatkeshiRangSardSum = 0;
$TarsimKhatCount = 0;
$TarsimKhatSum = 0;
$EjrayeTooliCount = 0;
$EjrayeTooliSum = 0;
$EjrayeArziCount = 0;
$EjrayeArziSum = 0;
$PakKardanKhotootCount = 0;
$PakKardanKhotootSum = 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">{{$KhatkeshiRangGarmCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$KhatkeshiRangGarmSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$KhatkeshiRangSardCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$KhatkeshiRangSardSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TarsimKhatCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$TarsimKhatSum ?? '-'}}</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">{{$EjrayeArziCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$EjrayeArziSum ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$PakKardanKhotootCount ?? '-'}}</td>
<td style="border: 1px solid black;text-align: center;background-color:#DAEEF3">{{$PakKardanKhotootSum ?? '-'}}</td>
</tr>
@endif
@endforeach
</tbody>
</table>
</body>
</html>