@extends('layouts.admin.app')
@section('content')
<div class="pd-30">
  <div class="col-sm-12 col-xl-12 " style="display: flex;">
    <h4 class="tx-gray-800 mg-b-5 title" style="width: 100%;">SIP </h4>
  </div>
</div><!-- d-flex -->
<div class=" br-pagebody mg-t-5 pd-x-30">
  <div class="br-section-wrapper row row-sm p-20">
    <div class="col-sm-12 col-xl-12" style="padding-bottom: 20px">
      <h6 class="filter-title">Advanced Search Filter</h6>
      <form method="post" action="/gpclrmainportal/search-sip">
        @csrf @method('post')
        <div class="row">
          <div class="col-md-2">
            <label>From Date</label>
            <input type="date" name="fromdate" class="form-control"
              value="">
          </div>
          <div class="col-md-2">
            <label>To Date</label>
            <input type="date" name="todate" class="form-control" value="">
          </div>
          <div class="col-md-4">
            <label>UUID</label>
            <select name="uuid" class="form-control m-select2 m-select2-general">
              <option value="">Select</options>
                @foreach($uuiddata as $key => $value)
              <option value="{{$value->uuid}}" >{{$value->uuid}}</options>
                @endforeach
            </select>
          </div>
          <div class="col-md-4">
            <label>Cas No</label>
            <select name="casno" class="form-control m-select2 m-select2-general">
              <option value="">Select</options>
                @foreach($casdata as $key => $value)
              <option value="{{$value->cas_no}}" >{{$value->cas_no}}</options>
                @endforeach
            </select>
          </div>

          <div class="col-md-12 text-center" style="padding-top: 16px">
            <!-- <button type="reset" class="btn btn-style2 text-white">Clear</button> -->
            <a href="/gpclrmainportal/user-sip" class="btn btn-style2 text-white" type=>Clear</a>
            <button class="btn btn-style1 text-white" type="submit">Submit</button>
          </div>
        </div>
      </form>
    </div>
    <div class="col-sm-12 col-xl-12">
      <div class="table-responsive">
        @if(count($sip) > 0)
        <table id="example" class="table display responsive nowrap dataTable no-footer dtr-inline" role="grid"
          aria-describedby="datatable1_info">
          <thead class="thead-colored">
            <tr>
              <th>Sr No</th>
              <th>Date</th>
              <th>Region</th>
              <th>CAS NO</th>
              <th>EC NO</th>
              <th>CAS Name</th>
              <th>UUID</th>
              <th>Preregistration Number</th>
              <th>Action</th>
            </tr>
          </thead>
          <tbody>
            @php $i = 1; @endphp
            @foreach($sip as $key => $n)

            <tr>
              <th scope="row">{{$i++}}</th>
              <td>@if($n->created_at != "0000-00-00" && $n->created_at != "-0001-11-30 00:00:00")
                {{ $n->created_at->format('d-m-Y')}}
                @endif
              </td>
              <td>{{$n->Region->name}}</td>
              <td>{{$n->cas_no}}</td>
              <td>{{$n->ec_no}}</td>
              <td>{{$n->cas_name}}</td>
              <td>{{$n->uuid}}</td>
              <td>{{$n->preregistration_no}}</td>
              <td style="display: flex;">
                @if($n->type == 'pdf')
                @php
                $pdfdata = DB::table('sip_pdf')->where([['status', 1], ['cas_no', $n->cas_no], ['region_id',
                $n->region_id]])->first();
                @endphp
                @if($pdfdata == NULL)
                @php
                $company = DB::table('company_uuid')->where([['cas_no', $n->cas_no], ['region_id', $n->region_id],
                ['uuid', $n->uuid]])->first();
                @endphp
                @if($company != NULL)
                <a target='_blank' href="{{asset('uploads/sip/'. $company->sip_pdf)}} " class="btn btn-primary">Pdf</a>
                @endif
                @else
                <a target='_blank' href="{{asset('/uploads/'. $pdfdata->pdf)}}" class="btn btn-primary">Pdf</a>
                @endif
                @else
                <a target='_blank' href="/gpclrmainportal/sip-view-pdf/{{base64_encode($n->id)}}"
                  class="btn btn-primary">Pdf</a>
                @endif


                <!-- <a class="btn btn-primary" target="_blank" href="sip-view-pdf/{{ base64_encode($n->id) }}" style="border-radius: 0px;color: white;border: 1px solid white;background: ">PDF</a> -->
              </td>
            </tr>
            @endforeach
          </tbody>
        </table>
        @else
        <h4 class="text-center">No SIP Found</h4>
        @endif
        <br>
      </div>
    </div>
  </div>
</div>

@endsection
@section('scripts')
<script>
  $(document).ready(function() {
        var table = $('#example').DataTable( {
            lengthChange: false,
            buttons: ['copy','excel','pdf','colvis' ]
        });
        table.buttons().container()
        .appendTo( '#example_wrapper .col-md-6:eq(0)' );
    });
</script>
@endsection