@extends('layouts.app')
@section('content')
<div class="row p-2" >
    <div class="col-sm-12 col-md-12 col-lg-12 mb-2 text-center">
        <h3>Finished Inspection Jobs</h3>
    </div>

    <div class="col-sm-12 col-md-12 col-lg-12">
        <form action="{{route('reports_insjobs.search')}}" method="GET" class="form-row" >
                {{ csrf_field() }}
                <div class="col-sm-12 col-md-12 col-lg-3">
                    <div class="form-group row">
                        <label for="start_day" class=" col-form-label pr-0 mr-1">Start Date</label>
                        <div class=" pl-0">
                            <input class="search_date" type="date" id="start_day" name="start_day"
                                value={{\Carbon\Carbon::today()->addMonths(-2)->format('Y-m-d')}} class="form-control">
                        </div>
                    </div>
                </div>
                <div class="col-sm-12 col-md-12 col-lg-3">
                    <div class="form-group row">
                        <label for="end_day" class=" col-form-label pr-0 mr-1">End Date</label>
                        <div class=" pl-0">
                            <input class="search_date" type="date" id="end_day" name="end_day"
                            value={{\Carbon\Carbon::today()->addMonths(1)->format('Y-m-d')}} class="form-control">
                        </div>
                    </div>
                </div>
            <div class="col-sm-12 col-md-12 col-lg-6">
                    <div class="input-group md-form form-sm form-1 pl-0  mb-1  float-left">
                        <div class="input-group-prepend ">
                            <span class="input-group-text purple lighten-3" id="basic-text1"><i class="fas fa-search text-white"
                                aria-hidden="true"></i></span>
                        </div>
                        <input class="form-control my-0 py-1" type="text" placeholder="Search by, Company Name, inspector, or Workorder ID" aria-label="Search" name="search_val">
                        <button type="submit" class="btn btn-sm btn-primary ml-1">Search</button>
                    </div>
            </div>


        </form>
    </div>
</div>
<hr>
<div class="row">
    <div class="col-sm-12 col-md-12 col-lg-12">
        <div class="card">
            <div class="card-header">
                Search Result
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table style="box-shadow: 0px 0px 10px lightgray; "
                        class="table table-bordered table-hover table-sm table-striped myDatatable">
                        <thead style="background-color:  rgb(80, 120, 131); color: white;font-size: 12px;text-align: center;">
                            <tr>
                                <th>Job ID</th>
                                <th>Company</th>
                                <th>Service Location</th>
                                <th>Equipment (QTY)</th>
                                <th>Engineer</th>
                                <th>Service Date</th>
                                <th>Inquiry / Proposal / Workorder</th>
                                <th>Certificates / Checklist</th>
                                <th>Result</th>
                                <th>Reinspection</th>
                            </tr>
                        </thead>
                        <tbody>

                            @foreach ($insjobs as $insjob)
                                @php
                                    $company_name =$insjob->instask->workorder->insservice->inqservice->branch->company->name;
                                    $user_id = $insjob->user->id;
                                    $report_name = '/storage/docs/companies/' . $company_name . '/inspections/' . $user_id
                                    .'/'.$insjob->id. '/docs/Report.pdf';
                                    $chklist_name = '/storage/docs/companies/' . $company_name . '/inspections/' . $user_id
                                    .'/'.$insjob->id. '/docs/chklist.pdf';
                                @endphp
                                <tr style="font-size: 10px;text-align: center;">
                                    <td>{{$insjob->id}}</td>
                                    <td>
                                        <p>
                                        Company: {{$company_name}}
                                        </p>
                                    </td>
                                    <td>
                                        <p>
                                            {{$insjob->instask->workorder->insservice->inqservice->branch->zone->emirate->name}},
                                            {{$insjob->instask->workorder->insservice->inqservice->branch->zone->name}},
                                            {{$insjob->instask->workorder->insservice->location}}
                                        </p>
                                    </td>
                                    <td>
                                        <p>{{$insjob->equipment->name}} ({{$insjob->qty}})
                                            </p>
                                    </td>
                                    <td><p>{{$insjob->user->name}}</p></td>
                                    <td><p>{{$insjob->get_chklistfield_byId(8)}}</p></td>
                                    <td>
                                        <p>
                                        Inquiry: <a class="text-primary" target="_blank"
                                                            href="/inqservices/{{$insjob->instask->workorder->insservice->inqservice->id}}">
                                                            Q:{{$insjob->instask->workorder->insservice->inqservice->id}}</a>
                                        /
                                            Proposal: <a class="text-primary" target="_blank"
                                                            href="/insproposals/{{$insjob->instask->workorder->insservice->insproposal->id}}">
                                                            P:{{$insjob->instask->workorder->insservice->insproposal->id}}</a>
                                        /
                                            Workorder: <a class="text-primary" target="_blank"
                                                            href="/workorders/{{$insjob->instask->workorder->id}}">
                                                            W:{{$insjob->instask->workorder->id}}</a>
                                        </p>
                                    </td>
                                    <td>
                                        <p><a class="text-primary" target="_blank" href="{!! $report_name !!}">
                                                BSS-{{$insjob->insdocuments->id}}</a>
                                                <br><br> 
                                        <a href="{{$chklist_name}}" target="_blank">Checklist</a></p>
                                    </td>
                                    <td>
                                        @if(strtolower(trim($insjob->get_chklistfield_byId(12))) == "safe")
                                                    <strong class="text-success">{{ $insjob->get_chklistfield_byId(12) }}</strong>
                                            @else
                                                    <strong class="text-danger">{{ $insjob->get_chklistfield_byId(12) }}</strong>   
                                            @endif
                                    </td>
                                    <td>
                                            @php
                                                    if($insjob->instask->related_job_id != 0)
                                                    {

                                                        echo (

                                                            "Related Job: <a target='_blank' href=".route('instasks.show',$insjob->instask->related_task_id)." class='links font-weight-bolder'>
                                                                ".$insjob->instask->related_job_id."
                                                            </a>");
                                                    }else{
                                                        echo "<b>Original</b>";
                                                    }
                                                @endphp
                                        </td>
                                    
                                    
                                </tr>
                            @endforeach

                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        
    </div>
</div>


@endsection