@extends('layouts.internal')

@section('content')
@section('breadcrumb')
<div class="c-subheader justify-content-between px-3">
<ol class="breadcrumb border-0 m-0 px-0 px-md-3">
<li class="breadcrumb-item"><a href="/"><i class="fa fa-home"></i></a></li>
@if(url()->previous() != url()->current())
<li class="breadcrumb-item"><a href="{{url()->previous()}}">&leftarrow; Previous Page</a></li>
@endif						
<li class="breadcrumb-item"><a href="{{route('email_templates')}}">Email Queries</a></li>

</ol> 
</div>
@endsection

    <!-- bread -->
    <div class="card ">
          <div class="card-body">
        
          <div class="table-responsive">
          
            @if(session()->has('success'))
        <div class="alert alert-success">
            {{ session()->get('success') }}
        </div>
        @endif
            <table id="tbl-list" class="table table-bordered datatable">
            <a class="btn btn-success" href="{{ route('create_email_queries')  }}">Create New</a>

                <thead>
                    <tr>
                        <th>Type</th>
                        <th>Source</th>
                        <th>Name</th>
                        <th>SQL Query</th>
                        <th>Created at</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                
                </tbody>
            </table>
            </div>
        </div>
<script>
$(document).ready(function () {
    var table = $('#tbl-list').DataTable({
        processing: true,
        serverSide: true,
        ajax: "{{ route('email_queries') }}",
        columns: [
          
            {data: 'type', name: 'type'},
            {data: 'source', name: 'source'},
            {data: 'name', name: 'name'},
            {data: 'sql_query', name: 'sql_query'},
            {data: 'created_at', name: 'created_at',orderable: false, searchable: false},
            {data: 'action', name: 'action'},
         ],
         "bLengthChange": false
    });
    $('#tbl-list').attr('style', 'border-collapse: collapse !important');

} );


</script>
@endsection