@extends('layouts.admin_new')
@section('content')
<div>
    @can('request_database_create')
        <div style="margin-bottom: 10px;" class="row">
            <div class="col-lg-12">
                <a class="btn btn-sm btn-light-primary" href="{{ route('admin.request-databases.create') }}">
                    {{ trans('global.add') }} {{ trans('cruds.requestDatabase.title_singular') }}
                </a>
            </div>
        </div>
    @endcan
    <div class="row">
        <div class="col-lg-12">
            <div class="panel panel-default">
                <div class="h5 panel-heading">
                    {{ trans('cruds.requestDatabase.title_singular') }} {{ trans('global.list') }}
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
                        <table class=" table table-bordered table-striped table-hover datatable datatable-RequestDatabase">
                            <thead>
                                <tr>
                                    <th width="10">

                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.id') }}
                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.requester') }}
                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.request_date') }}
                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.request_approval') }}
                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.date_of_request_approval_denial') }}
                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.request') }}
                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.technical_request') }}
                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.request_location') }}
                                    </th>
                                    <th>
                                        {{ trans('cruds.requestDatabase.fields.request_duration') }}
                                    </th>
                                    <th>
                                        &nbsp;
                                    </th>
                                </tr>
                                <tr>
                                    <td>
                                    </td>
                                    <td>
                                        <input class="search" type="text" placeholder="{{ trans('global.search') }}">
                                    </td>
                                    <td>
                                        <select class="search">
                                            <option value>{{ trans('global.all') }}</option>
                                            @foreach($requesters as $key => $item)
                                                <option value="{{ $item->name }}">{{ $item->name }}</option>
                                            @endforeach
                                        </select>
                                    </td>
                                    <td>
                                    </td>
                                    <td>
                                        <select class="search" strict="true">
                                            <option value>{{ trans('global.all') }}</option>
                                            @foreach(App\Models\RequestDatabase::REQUEST_APPROVAL_RADIO as $key => $item)
                                                <option value="{{ $item }}">{{ $item }}</option>
                                            @endforeach
                                        </select>
                                    </td>
                                    <td>
                                    </td>
                                    <td>
                                        <select class="search">
                                            <option value>{{ trans('global.all') }}</option>
                                            @foreach($request_types as $key => $item)
                                                <option value="{{ $item->request_type }}">{{ $item->request_type }}</option>
                                            @endforeach
                                        </select>
                                    </td>
                                    <td>
                                        <select class="search">
                                            <option value>{{ trans('global.all') }}</option>
                                            @foreach($rrt_roles as $key => $item)
                                                <option value="{{ $item->name }}">{{ $item->name }}</option>
                                            @endforeach
                                        </select>
                                    </td>
                                    <td>
                                        <select class="search">
                                            <option value>{{ trans('global.all') }}</option>
                                            @foreach($regions as $key => $item)
                                                <option value="{{ $item->name }}">{{ $item->name }}</option>
                                            @endforeach
                                        </select>
                                    </td>
                                    <td>
                                        <input class="search" type="text" placeholder="{{ trans('global.search') }}">
                                    </td>
                                    <td>
                                    </td>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($requestDatabases as $key => $requestDatabase)
                                    <tr data-entry-id="{{ $requestDatabase->id }}">
                                        <td>

                                        </td>
                                        <td>
                                            {{ $requestDatabase->id ?? '' }}
                                        </td>
                                        <td>
                                            {{ $requestDatabase->requester->name ?? '' }}
                                        </td>
                                        <td>
                                            {{ $requestDatabase->request_date ?? '' }}
                                        </td>
                                        <td>
                                            {{ App\Models\RequestDatabase::REQUEST_APPROVAL_RADIO[$requestDatabase->request_approval] ?? '' }}
                                        </td>
                                        <td>
                                            {{ $requestDatabase->date_of_request_approval_denial ?? '' }}
                                        </td>
                                        <td>
                                            {{ $requestDatabase->request->request_type ?? '' }}
                                        </td>
                                        <td>
                                            @foreach($requestDatabase->technical_requests as $key => $item)
                                                <span class="label label-info label-many">{{ $item->name }}</span>
                                            @endforeach
                                        </td>
                                        <td>
                                            {{ $requestDatabase->request_location->name ?? '' }}
                                        </td>
                                        <td>
                                            {{ $requestDatabase->request_duration ?? '' }}
                                        </td>
                                        <td>
                                            @can('request_database_show')
                                                <a class="btn btn-xs btn-primary" href="{{ route('admin.request-databases.show', $requestDatabase->id) }}">
                                                    {{ trans('global.view') }}
                                                </a>
                                            @endcan

                                            @can('request_database_edit')
                                                <a class="btn btn-xs btn-info" href="{{ route('admin.request-databases.edit', $requestDatabase->id) }}">
                                                    {{ trans('global.edit') }}
                                                </a>
                                            @endcan

                                            @can('request_database_delete')
                                                <form action="{{ route('admin.request-databases.destroy', $requestDatabase->id) }}" method="POST" onsubmit="return confirm('{{ trans('global.areYouSure') }}');" style="display: inline-block;">
                                                    <input type="hidden" name="_method" value="DELETE">
                                                    <input type="hidden" name="_token" value="{{ csrf_token() }}">
                                                    <input type="submit" class="btn btn-xs btn-danger" value="{{ trans('global.delete') }}">
                                                </form>
                                            @endcan

                                        </td>

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



        </div>
    </div>
</div>
@endsection
@section('scripts')
@parent
<script>
    $(function () {
  let dtButtons = $.extend(true, [], $.fn.dataTable.defaults.buttons)
@can('request_database_delete')
  let deleteButtonTrans = '{{ trans('global.datatables.delete') }}'
  let deleteButton = {
    text: deleteButtonTrans,
    url: "{{ route('admin.request-databases.massDestroy') }}",
    className: 'btn-danger',
    action: function (e, dt, node, config) {
      var ids = $.map(dt.rows({ selected: true }).nodes(), function (entry) {
          return $(entry).data('entry-id')
      });

      if (ids.length === 0) {
        alert('{{ trans('global.datatables.zero_selected') }}')

        return
      }

      if (confirm('{{ trans('global.areYouSure') }}')) {
        $.ajax({
          headers: {'x-csrf-token': _token},
          method: 'POST',
          url: config.url,
          data: { ids: ids, _method: 'DELETE' }})
          .done(function () { location.reload() })
      }
    }
  }
  dtButtons.push(deleteButton)
@endcan

  $.extend(true, $.fn.dataTable.defaults, {
    orderCellsTop: true,
    order: [[ 1, 'desc' ]],
    pageLength: 100,
  });
  let table = $('.datatable-RequestDatabase:not(.ajaxTable)').DataTable({ buttons: dtButtons })
  $('a[data-toggle="tab"]').on('shown.bs.tab click', function(e){
      $($.fn.dataTable.tables(true)).DataTable()
          .columns.adjust();
  });
  
let visibleColumnsIndexes = null;
$('.datatable thead').on('input', '.search', function () {
      let strict = $(this).attr('strict') || false
      let value = strict && this.value ? "^" + this.value + "$" : this.value

      let index = $(this).parent().index()
      if (visibleColumnsIndexes !== null) {
        index = visibleColumnsIndexes[index]
      }

      table
        .column(index)
        .search(value, strict)
        .draw()
  });
table.on('column-visibility.dt', function(e, settings, column, state) {
      visibleColumnsIndexes = []
      table.columns(":visible").every(function(colIdx) {
          visibleColumnsIndexes.push(colIdx);
      });
  })
})

</script>
@endsection