Files
backend/resources/views/excel/DailyAccident/Province.blade.php

95 lines
7.4 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>
<table>
<thead>
<tr>
<th colspan="22" style="background-color: #DAEEF3;text-align: center;border-right: 1px solid black;font-weight:bolder;text-align:center;">
تاریخ دریافت گزارش: {{verta()->now()->format('Y/m/d H:i')}}
</th>
</tr>
<tr>
<th colspan="22" style="background-color: #DAEEF3;text-align: center;border-right:1px solid black;font-weight:bolder;"></th>
</tr>
<tr>
<th colspan="22" style="background-color: #DAEEF3;text-align: center;border-right:1px solid black;font-weight:bolder;font-size: 13;">
@if ($fromDate == null)
گزارش تصادفات روزانه
@else
گزارش تصادفات روزانه از تاریخ
{{verta($fromDate)->format('Y/n/j')}}
تا
تاریخ
{{verta($toDate)->format('Y/n/j')}}
@endif
</th>
</tr>
<tr>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">اداره کل</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">نام محور</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">نوع راه</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">جهت حرکت</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">ابتدای محور</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">انتهای محور</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">فاصله از ابتدای محور (کیلومتر)</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">نام محلی نقطه</th>
<th colspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">مختصات جغرافیایی</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">شماره سریال کروکی</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">نوع برخورد</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">توصیف هندسی نقطه</th>
<th colspan="3" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">تعداد عوامل درگیر تصادف</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">تعداد جرحی</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">تعداد فوتی</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">تاریخ تصادف</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">ساعت تصادف</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">تاریخ ثبت در سامانه</th>
<th rowspan="2" style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">شرایط جوی راه و رویه راه</th>
</tr>
<tr>
<th style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">عرض جغرافیایی</th>
<th style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">طول جغرافیایی</th>
<th style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">دوچرخه و موتورسیکلت</th>
<th style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">وسیله نقلیه سبک</th>
<th style="border: 1px solid black;text-align: center;background-color: #EBF1DE;">وسیله نقلیه سنگین</th>
</tr>
</thead>
<tbody>
@foreach ($data as $item)
<tr>
<td style="border: 1px solid black;text-align: center;">{{$item->province_fa}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->axis_name}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->axis_type_fa ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->direction_fa ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->axis_start ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->axis_end ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->distance_axis_start ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->local_name ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->lat ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->lng ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->police_serial ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->collision_type_fa ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->way_geometri_fa ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->participants_bicycle ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->participants_light_vehicle ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->participants_heavy_vehicle ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->number_of_injured ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->number_of_died ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{verta($item->accident_date)->format('Y/n/j')}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->accident_time ?? 0}}</td>
<td style="border: 1px solid black;text-align: center;">{{verta($item->created_at)->format('Y/n/j')}}</td>
<td style="border: 1px solid black;text-align: center;">{{$item->weather_condition_fa ?? 0}}</td>
</tr>
@endforeach
</tbody>
</table>
</body>
</html>