@extends('layouts.layout')

@section('title', 'Advertisement')

@section('content')

@php
    function created_by_name($id){
        $result=DB::table('users')->where('id',$id)->first();
        return isset($result->name)?$result->name:'';
    }
@endphp

<section class="content">
        <div class="container-fluid">
            <div class="block-header">
                <div class="row">
                    <div class="col-xs-10 col-sm-10 col-md-10 col-lg-10">
                        <ul class="breadcrumb breadcrumb-style ">
                            <li class="breadcrumb-item bcrumb-1">
                                <a href="{{url('/')}}/home"><i class="fas fa-home"></i> Home</a>
                            </li>
                            <li class="breadcrumb-item active">Advertisement</li>                            
                            <li class="breadcrumb-item active">View Details</li>                            
                        </ul>
                    </div>
                    
                </div>
            </div>
            <!-- Basic Examples -->
            <div class="row clearfix">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="card">
                        <div class="header">
                            <h2>
                                <strong>View </strong> Details</h2>
                        </div>
                        <div class="body">
                            <div class="table-responsive">
                                @if(Session::has('message'))
                                    <div class="alert bg-{{Session::get('status')}} alert-dismissible" role="alert">
                                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                            <span aria-hidden="true">×</span>
                                        </button>
                                        {{ Session::get('message') }}
                                    </div>
                                 @endif
                                <table id="adminTable" class="display table table-checkable order-column m-t-20 width-per-100">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Ad Details</th>
                                            <th>User</th>
                                            <th>IP</th>
                                            <th>Date</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(count($ad)>0) 
                                        @foreach($ad as $key=>$item)
                                        <tr>
                                            <td>{{ $key+1 }}</td>
                                            <td>
                                                @php 
                                                    $addata = DB::table('advertisement')->where('id',$item->ad_id)->first();
                                                @endphp

                                                @if($addata)
                                                    <span class="col-blue">Ad Name :</span> {{ $addata->ad_name }}
                                                    @if($addata->position) <br> <span class="col-blue">Position : </span>{{ ucwords(str_replace('_',' ',$addata->position)) }} @endif
                                                @endif
                                            </td>
                                            <td>{{ isset($item->user_id)?created_by_name($item->user_id):'' }}</td>
                                            <td>{{ $item->ip_address }}</td>
                                            <td>{{ date("d/m/Y h:i A",strtotime($item->created_at))}}</td>
                                        </tr>
                                        @endforeach
                                        @else 
                                            <tr>
                                                <td class="text-center" colspan="7">
                                                    <img src="{{url('/')}}/assets/images/nodata.png"> 
                                                    <br><h3>No records found!</h3> 
                                                </td>
                                            </tr>
                                        @endif
                                    </tbody>
                                </table>
                            </div>

                            <div class="col-xs-12 col-sm-12 col-md-12 col-lg-12 text-center">
                                <a href="{{ url()->previous() }}"><button type="button" id="event_add" class="btn btn-danger waves-effect m-t-15">Go Back
                                </button></a>
                            </div>

                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
   
   <script src="{{url('/')}}/assets/js/pages/tables/jquery-datatable.js"></script>
@endsection