Files
backend/resources/views/excel/Maintanance/RoadMaintanance.blade.php

309 lines
19 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>
<style>
table,
th,
td {
border: 1px solid black;
}
</style>
</head>
<body dir="rtl" style="text-align: center;">
<table>
<thead>
<tr>
<th colspan="47"
style="background-color: #DAEEF3;text-align: center;border-right: 1px solid black;font-weight:bolder;">
تاریخ دریافت گزارش: {{ verta()->now()->format('Y/m/d H:i') }}
</th>
</tr>
<tr>
<th colspan="47"
style="background-color: #DAEEF3;text-align: center;border-right:1px solid black;font-weight:bolder;">
</th>
</tr>
<tr>
<th colspan="47"
style="background-color: #DAEEF3;text-align: center;border-right:1px solid black;font-weight:bolder;font-size: 13;">
گزارش پروژه های روکش آسفالت(نگهداری راه)
</th>
</tr>
<tr>
<th rowspan="3"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
اداره کل</th>
<th rowspan="3"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
شهرستان</th>
<th rowspan="3"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
نام محور</th>
<th rowspan="3"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
نوع محور</th>
<th rowspan="3"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
عنوان پروژه</th>
<th colspan="6"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
روکش تقویتی (کیلومتر) </th>
<th colspan="16"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
روکش حفاظتی (کیلومتر)</th>
<th colspan="4"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
لکه گیری و درزگیری (کیلومتر)</th>
<th rowspan="3"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
تاریخ قرارداد </th>
<th rowspan="3"
style="font-weight:bold;background-color: #E4DFEC;text-align: center;border: 1px solid black;font-weight:bold;">
آخرین وضعیت پروژه</th>
<th rowspan="3"
style="font-weight:bold;background-color: #FDE9D9;text-align: center;border: 1px solid black;font-weight:bold;">
درصد پیشرفت کل پروژه</th>
<th colspan="4"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
اطلاعات مالی پروژه (میلیون ریال)</th>
<th colspan="9"
style="font-weight:bold;background-color: #EBF1DE;text-align: center;border: 1px solid black;font-weight:bold;">
اطلاعات تکمیلی</th>
</tr>
<tr>
<th colspan="2"
style="font-weight:bold;background-color: #C4D79B;border:1px solid black;text-align:center;font-weight:bold;">
روکش آسفالت گرم</th>
<th colspan="2"
style="font-weight:bold;background-color: #C4D79B;border:1px solid black;text-align:center;font-weight:bold;">
ماسه آسفالت</th>
<th colspan="2"
style="font-weight:bold;background-color: #C4D79B;border:1px solid black;text-align:center;font-weight:bold;">
بازیافت سرد/گرم</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
میکروسرفیسینگ</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
چیپ سیل</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
اسلاری سیل</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
اسکراب سیل</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
فوگ سیل</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
سیل کت</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
کیپ سیل</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
آسفالت سرد/ردمیکس</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
لکه گیری</th>
<th colspan="2"
style="font-weight:bold;background-color: #B1A0C7;border:1px solid black;text-align:center;font-weight:bold;">
درزگیری</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
آخرین رقم ریالی</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
آخرین کارکرد پیمانکار</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
مبلغ پرداختی به پیمانکار</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
مبلغ مورد نیاز جهت تکمیل پروژه</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
پیمانکار</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
مشاور طراحی</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
مشاور نظارت</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
درجه اهمیت پروژه</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
درجه اهمیت پیگیری پروژه</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
کارشناس ناظر پروژه</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
شماره تماس ناظر</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
آخرین تاریخ بروز رسانی</th>
<th rowspan="2"
style="font-weight:bold;background-color: #FCD5B4;border:1px solid black;text-align:center;font-weight:bold;">
کد یکتا</th>
</tr>
<tr>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">تعریف شده</th>
<th style="border: 1px solid black;text-align: center;background-color: #B1A0C7">انجام شده</th>
</tr>
</thead>
<tbody>
@foreach ($roads as $road)
<tr>
<td style="border: 1px solid black;text-align: center;">{{ $road['province'] ?? '' }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['city'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['axis_name_fa'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['axis_type_fa'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['project_title'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDefined']['rokeshAsphalt'] }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['rokeshAsphalt'] }}</td>
<td style="border: 1px solid black;text-align: center;">
{{ $road['isDefined']['maseAsphalt'] ?? '' }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['maseAsphalt'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">
{{ $road['isDefined']['baziaftSard'] ?? '' }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['baziaftSard'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">
{{ $road['isDefined']['microsurfacing'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">
{{ $road['isDone']['microsurfacing'] ?? '' }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDefined']['chipSail'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['chipSail'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">
{{ $road['isDefined']['slarySail'] ?? '' }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['slarySail'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">
{{ $road['isDefined']['scrubSail'] ?? '' }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['scrubSail'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDefined']['fogSail'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['fogSail'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDefined']['sailKat'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['sailKat'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDefined']['kipSail'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['kipSail'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDefined']['redmix'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['redmix'] ?? '' }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDefined']['lakeGiri'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['lakeGiri'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDefined']['darzGiri'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['isDone']['darzGiri'] ?? '' }}
</td>
<td style="border: 1px solid black;text-align: center;">
{{ $road['contract_date_from_parent_contract'] }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['last_status_fa'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['progress_project'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['last_digit_project'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['last_function_operator'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['last_payable_operator'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['complete_payable'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['contract_peymankar'] }}
<td style="border: 1px solid black;text-align: center;">{{ $road['contract_moshaver_tarahi'] }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['contract_moshaver_nezarat'] }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['priority_project_fa'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['followup_priority_project'] }}
</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['operator_name'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['operator_phone'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['updated_at_fa'] }}</td>
<td style="border: 1px solid black;text-align: center;">{{ $road['code'] }}</td>
</tr>
@endforeach
</tbody>
</table>
</body>
</html>