@foreach ($ad_dtl as $advert) @php if(isset(($advert['approval_status']))){ switch ($advert) { case ($advert['approval_status'] == 'A'): $approval_status = 'Approved'; $clr = 'label-success'; break; case ($advert['approval_status'] == 'R'): $approval_status = 'Rejected'; $clr = 'label-danger'; break; case ($advert['approval_status'] == 'P'): $approval_status = 'Pending'; $clr = 'label-warning'; break; } } // if( ($advert['expires_on'] < date('Y-m-d',strtotime($advert['date_of_advert']))) && $advert['discontinued'] != '1' ){ if( ($advert['expires_on'] < now()) && $advert['discontinued'] != '1' ){ $actv_stat_clr = 'label-danger'; $actv_stat_des = 'Expired'; } // if( ($advert['expires_on'] >= date('Y-m-d',strtotime($advert['date_of_advert']))) && $advert['discontinued'] != '1' ){ if( ($advert['expires_on'] >= now()) && $advert['discontinued'] != '1' ){ $actv_stat_clr = 'label-success'; $actv_stat_des = 'Active'; } if($advert['discontinued'] == '1'){ $actv_stat_clr = 'label-warning'; $actv_stat_des = 'Discontinued'; } @endphp @endforeach {{-- --}} {{-- --}}

Advertisement Type	Product/Service	District	Owner	Title	Created Date	Approval Status	Status
{{$advert['ad_type_des_en']}}	{{$advert['product_name_en']}}	{{$advert['dist_name_en']}}	{{$advert['user_firstname'].' '.$advert['user_lastname']}}	{{$advert['title']}}	{{ Carbon\Carbon::parse($advert['date_of_advert'])->format('Y-m-d') }}	{{$approval_status}}	{{$actv_stat_des}}
Advertisement Type	Product/Service	District	Owner	Title	Created Date	Approval Status	Status