@section('title', __('site.menu_item_5_sub_6')) @section('head') @endsection @include('includes/header') @include('includes/topSite')

{{ __('site.menu_item_5_sub_6') }}

@if (\Session::has('success')) @php Session::forget('success'); @endphp @endif
@if($s)
{{ __('site.search_results') }} {{ $s }}
@endif @if($allPolls->count() == 0)
{{ __('site.page_polls_search_norec') }}
@else @php foreach($allPolls as $poll){ $totalVotes = DB::connection('mysql_site_' . session('serverID'))->table('poll_options')->where('poll_id','=',$poll->id)->selectRaw('sum(total) as qtd')->get(); $avalSite = DB::connection('mysql_site_' . session('serverID'))->table('modules')->where('site_id','=',session('siteID'))->where('type','=','12') ->where('data','like','%entityId='.$poll->id.'%')->get()->count(); @endphp @php } @endphp
{{ __('site.page_polls_table_1') }} {{ __('site.page_polls_table_2') }} {{ __('site.page_polls_table_3') }}  
{{ $poll->name }} @if($avalSite) {{ __('site.page_polls_badge_onsite') }} @endif
@if(!$poll->date_end) {{ __('site.page_slider_table_no_link') }} @else {{ date('d/m/Y',strtotime($poll->date_end)) }} @endif {{ $totalVotes[0]->qtd }} @if($avalSite) @else
@endif
{{ $allPolls->links('vendor.pagination.default') }} @endif
@include('includes/footer')