@extends('admin.layout')
@section('title','SQL LOG')
@section('content')
<h3 align="center"> SQL LOG</h3>
<div class="text-center">
    <a href="{{asset('error-logs')}}" class="btn btn-danger text-white">Gestionnaire des erreurs <i class="fas fa-exclamation-circle"></i></a>
</div>
<section class="content">
    <div class="container-fluid">
      <div class="row">
        <div class="col-12">
          <div class="card">
            <div class="card-header">
              <h3 class="card-title">Pistes audits SQL LOG</h3>
            </div>
            <div class="card-body">
                <table id="example1" class="table table-bordered table-striped">
                    <thead>
                    <tr>
                      <th>#</th>
                      <th>ID</th>
                      <th>IP</th>
                      <th>USER ID</th>
                      <th>UTILISATEUR</th>
                      <th>SQL</th>
                      <th>Donnée</th>
                      <th>Temps</th>
                      <th>DATE</th>
                    </tr>
                    </thead>
                    <tbody>

                      @forelse ($traces as $u)
                      <tr>
                        <td><input type="checkbox"></td>
                        <td>{{$u->id}}</td>
                        <td>{{$u->ip}}</td>
                        <td>{{$u->user_id}}</td>
                        <td>{{$u->name}}</td>
                        <td>{{$u->req_sql}}</td>
                        <td>{{$u->data}}</td>
                        <td>{{$u->time}}</td>
                        <td>{{$u->created_at}}</td>
                      </tr>
                      @empty

                      @endforelse


                    </tbody>
                    <tfoot>
                    <tr>
                        <th>#</th>
                      <th>ID</th>
                      <th>IP</th>
                      <th>USER ID</th>
                      <th>UTILISATEUR</th>
                      <th>SQL</th>
                      <th>Donnée</th>
                      <th>Temps</th>
                      <th>DATE</th>
                    </tr>
                    </tfoot>
                  </table>
    </div>
</div>
        </div>
      </div>
    </div>
</section>

@stop