@extends('layouts.app')

@section('content')


<div class="pagetitle">
    <h1>TESTE DE SECURITATE</h1>
    <nav>
      <ol class="breadcrumb">
        <li class="breadcrumb-item"><a href="{{route('home')}}">Acasa</a></li>
        <li class="breadcrumb-item">Teste de securitate</li>
        <li class="breadcrumb-item active"> @if(isset($_GET['branch_id'])) <a href="{{route('security-tests')}}">Reset</a> @else Management @endif </li>
      </ol>
    </nav>
  </div><!-- End Page Title -->

  <section class="section">
    <div class="row">
      <div class="col-lg-12">

        <div class="card">
          <div class="card-body">
            <h5 class="card-title">Example Card</h5>
            <form action="{{route('search-tests')}}" method="get">
            <div class="row">
                <div class="col-md-2">
                    <label for="">Agentie</label>
                    <select name="branch_id" id="" class="form-control">
                        <option value="">Alegeti Agentie</option>
                        @foreach($branches as $branch)
                        <option value="{{$branch->branch}}" @if(isset($_GET['branch_id'])) @if($_GET['branch_id']==$branch->branch) selected @endif @endif >{{$branch->name}} {{$branch->branch}}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label for="">Perioada(De la)</label>
                    <input type="date" name="control_date_from" @if(isset($_GET['control_date_from'])) value="{{$_GET['control_date_from']}}" @endif id="" class="form-control">
                </div>
                <div class="col-md-2">
                    <label for="">Perioada(Pana)</label>
                    <input type="date" name="control_date_to" @if(isset($_GET['control_date_to'])) value="{{$_GET['control_date_to']}}" @endif id="" class="form-control">
                </div>
                <div class="col-md-1">
                    <label for="">Echipa a sosit</label>
                    <select name="appearance" id="" class="form-control">
                        <option value="" selected>Alegeti Optiune</option>
                        <option value="1" @if(isset($_GET['appearance'])) @if($_GET['appearance']==1) selected @endif @endif >DA</option>
                        <option value="0" @if(isset($_GET['appearance'])) @if($_GET['appearance']==0) selected @endif @endif>NU</option>
                    </select>
                </div>
                <div class="col-md-1">
                    <label for="">Rezultat</label>
                    <select name="result" id="" class="form-control">
                        <option value="" selected>Alegeti Optiune</option>
                        <option value="1" @if(isset($_GET['result'])) @if($_GET['result']==1) selected @endif @endif >OK</option>
                        <option value="0" @if(isset($_GET['result'])) @if($_GET['result']==0) selected @endif @endif >Not ok</option>
                    </select>
                </div>
                <div class="col-md-2">
                    <label for="">Diferenta(Minute)</label>
                    <input type="text" name="response_time" @if(isset($_GET['response_time'])) value="{{$_GET['response_time']}}" @endif  class="form-control">
                </div>
                <div class="col-md-1">
                    <label for="" style="visibility:hidden;">Filter</label>
                    <button class="btn btn-info form-control"><i class="bi bi-search"></i></button>
                </div>
                <div class="col-md-1">
                    <label for="" style="visibility:hidden;">Filter</label>
                    <button type="button" id="export" class="btn btn-success form-control"><i class="bi bi-download"></i></button>
                </div>
            </div>
        </form>
            <div class="table-responsive">
            <table class="table table-bordered table-hover table-stripped datatable">
                <thead>
                        <tr>
                                <th>Agentie</th>
                                <th>Data Testare</th>
                                <th>Declansator</th>
                                <th>Ora Declansare</th>
                                <th>Ora sorire</th>
                                <th>Durata(Minute)</th>
                                <th>Rezultat</th>
                                <th>Echipa a sosit</th>
                                <th>Operator</th>
                                <th>Proces Verbal</th>
                                @if(Auth::user()->role_id==1)
                                <th>Eliminare</th>
                                @endif
                        </tr>
                </thead>
                <tbody>
                    @foreach($tests as $test)
                        <tr>
                            <td>{{$test->myBranch->branch}} {{$test->myBranch->name}}</td>
                            <td>{{Carbon\Carbon::parse($test->control_date)->format('d-m-Y')}}</td>
                            <td>{{$test->myDevice->name}}</td>
                            <td>{{$test->test_start}}</td>
                            <td>{{$test->test_response}}</td>
                            @if($test->response_time > 0)
                            <td>{{round($test->response_time/60,2)}}</td>
                            @else 
                            <td>{{$test->response_time}}</td>
                            @endif
                            <td>
                                @php $test->succeded ? $result = '<span class="text-success">Cu succes </span>' : $result='<span class="text-danger">Cu intarziere</span>'; @endphp
                                 
                            </td>
                            <td>
                                @php $test->appearance ? $appearance='<span class="text-success">DA</span>' : $appearance = '<span class="text-danger">NU</span>'; @endphp
                                                            </td>
                            <td>{{$test->myUser->username}}</td>
                            @if($test->pv_doc)
                            <td><a href="{{route('display-test-doc',$test->id)}}" target="_blank" class="btn btn-sm btn-info"><i class="bi bi-eye"></i></a></td>
                            @else 
                            <td>Fara proces Verbal</td>
                            @endif 
                            @if(Auth::user()->role_id==1)
                                <td><a href="{{route('destroy-test',$test->id)}}" class="btn btn-danger btn-sm"><i class="bi bi-trash"></i></a></td>
                            @endif
                        </tr>

                    @endforeach
                </tbody>
            </table>
        </div>
          </div>
        </div>

      </div>

     
    </div>
  </section>



@endsection

@push('js')
<script src="https://code.jquery.com/jquery-3.6.3.js" integrity="sha256-nQLuAZGRRcILA+6dMBOvcRh5Pe310sBpanc6+QBmyVM=" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/gh/linways/table-to-excel@v1.0.4/dist/tableToExcel.js"></script>
<script>
$(document).ready(function () {
    $("#export").click(function () {
        let table = document.getElementsByTagName("table");
        console.log(table);
        debugger;
        TableToExcel.convert(table[0], {
            name: `Securitytests.xlsx`,
            sheet: {
                name: 'Security Test'
            }
        });
    });
});
</script>
@endpush