@extends('layouts.master')
@section('title', 'E-mail Log')
@section('style')
    <style>
        
    </style>
@endsection

@section('script')
    <script></script>
@endsection

@section('content')
    @include('layouts.header')
    <section class="wrapper image-wrapper bg-image bg-overlay text-white" data-image-src="{{ asset('/bg/bgg02.png') }}"
        style="background-image: url('{{ asset('/bg/bgg02.png') }}');">
        <div class="container pt-14 pt-md-16 pb-23 pb-md-15 text-center">
            <div class="row">
                <div class="row">
                    <div class="col-lg-8 col-xxl-7 mx-auto text-center" data-cues="slideInDown" data-group="page-title"
                        data-delay="600">
                        <h1 class="fs-58 mb-2 text-light">@yield('title')</h1>
                    </div>
                </div>
            </div>
        </div>
    </section>

    <div class="container py-10">
        <div class="d-flex justify-content-between align-items-center">
            <div>
                <span class="text-dark fs-30">@yield('title')</span>
            </div>
            
        </div>
        <div class="table-responsive">
            <table class="table datatable">
                <thead>
                    <tr>
                        <th style="width: 5%">No.</th>
                        <th style="width: 15%">User</th>
                        <th style="width: 15%">E-mail</th>
                        <th style="width: 15%">Activity</th>
                        {{-- <th style="width: 15%">Key</th> --}}
                        <th style="width: 15%">Status</th>
                        <th style="width: 15%">Datetime</th>
                        
                    </tr>
                </thead>
                <tbody>

                  

                    @foreach ($email_log as $key => $logmail)

                        @php
                            $name = '';

                            if($logmail->sendemail_type == 'forgotpassword'){

                                $user = DB::table('user_meta')
                                            ->where('user_userid', $logmail->sendemail_userid)
                                            ->get();

                                $name =  $user->pluck('user_firstname')->first().' '.$user->pluck('user_lastname')->first();

                            }elseif($logmail->sendemail_type == 'mail after payment'){

                                $user = DB::table('payment')
                                            ->LeftJoin('student_list','student_id','payment_student_id')
                                            // ->where('user_userid', $logmail->sendemail_userid)
                                            ->get();

                                $name = $user->pluck('student_name')->first();
                            
                            }elseif($logmail->sendemail_type == 'mail after officer'){

                                $user = DB::table('user_meta')
                                            ->where('user_userid', $logmail->sendemail_userid)
                                            ->get();

                                $name =  $user->pluck('user_firstname')->first().' '.$user->pluck('user_lastname')->first();
                            }      
                        @endphp


                        <tr>
                            <td class="">{{ ++$key}}</td>
                            {{-- <td class="">{{ $logmail->user_firstname }} {{ $logmail->user_lastname }}</td> --}}
                            


                            <td class="">{{ $name }}</td>
                            {{-- <td class="">{{ $logmail->sendemail_userid }}</td> --}}
                            {{-- @elseif() --}}
                            <td class="">{{ $logmail->sendemail_email }}</td>
                            <td class="">{{ $logmail->sendemail_type }}</td>
                            {{-- <td class="">{{ $logmail->sendemail_key }}</td> --}}
                            <td class="">{{ $logmail->sendemail_status }}</td>
                            <td class="">{{ $logmail->updated_at }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>

    @include('layouts.footer')
@endsection