@php
  $right_top_position = 'global_top_right'; $right_bottom_position = 'global_bottom_right';

  if(Request::segment(3) === '1') {
      $right_top_position = 'celebrities_top_right'; $right_bottom_position = 'celebrities_bottom_right';
  }

  if(Request::segment(3) === '2') { 
      $right_top_position = 'movies_top_right'; $right_bottom_position = 'movies_bottom_right';
  }

  if(Request::segment(3) === '3') {
      $right_top_position = 'series_top_right'; $right_bottom_position = 'series_bottom_right';
  }

  if(Request::segment(3) === '4') {
      $right_top_position = 'sports_top_right'; $right_bottom_position = 'sports_bottom_right';
  }

  if(Request::segment(1) === 'leaderboard') {
      $right_top_position = 'leaderboard_top_right'; $right_bottom_position = 'leaderboard_bottom_right';
  }

  if(Request::segment(1) === 'quizlist') {
      $right_top_position = 'quiz_top_right'; $right_bottom_position = 'quiz_bottom_right';
  }

  if(Request::segment(1) === 'post_wishes') {
      $right_top_position = 'postwish_top_right'; $right_bottom_position = 'postwish_bottom_right';
  }

  if(Request::segment(2) === 'blog' && Request::segment(3) === 'details') {
      $right_top_position = 'blog_top_right'; $right_bottom_position = 'blog_bottom_right';
  }
@endphp

<div class="col-lg-3 sidebar mb-20">
  <div class="widget sidebar-ad text-center"> 
    
    @php
      $ad_global_top_right = DB::table('advertisement')->where('status', '1')->where('position', $right_top_position)->first();
    @endphp

    @if($ad_global_top_right)
      <a href="javascript:void(0);" title="{{$ad_global_top_right->ad_name}}" onclick="clickAd('{{$ad_global_top_right->id}}')"><img style="box-shadow: 0 4px 24px -5px rgba(0, 0, 0, 0.4);" class="img-responsive" src="{{url('/')}}/uploads/ad_image/{{$ad_global_top_right->ad_image}}" alt=""> </a>
    @else
      <img style="box-shadow: 0 4px 24px -5px rgba(0, 0, 0, 0.4);" class="img-responsive" src="https://via.placeholder.com/336x280" alt=""> 
    @endif

  </div>
  <div class="match-results-table">
     <div class="heading">
        <div class="row">
           <div class="col-2 p-0">
              <img src="{{url('/')}}/assets/frontend/images/cake.gif" alt="" width="30px" height="30px">
           </div>
           <div class="col-8">
              <h4 style="margin-top: 12px;">Happy Birthday</h4>
           </div>
           <div class="col-2 p-0">
              <img src="{{url('/')}}/assets/frontend/images/cake.gif" alt="" width="30px" height="30px">
           </div>
        </div>
     </div>
       <div class="body">
	                        @php
						        $bdaylist = DB::table('users')->where('status','Active')->whereNotNull('dob')->where('is_member','1')->whereMonth('dob',date('m'))->whereDay('dob',date('d'))->orderBy('dob','ASC')->limit('3')->get()->toArray();

						        $settings_data = DB::table('settings')->where('user_id', '1')->first();
						        $days = isset($settings_data->noofdays)?$settings_data->noofdays:'';
						        $toDate = date('d', strtotime(date('Y-m-d'). ' + '.$days.' days')); 

						        $right_celebrities_birthday = DB::table('users')->where('status','Active')->whereNotNull('dob')->where('is_member','2')->whereMonth('dob',date('m'))->whereRaw("Day(dob)>='".date('d')."'")->whereRaw("Day(dob)<='".$toDate."'")->orderBy('dob','ASC')->limit('3')->get()->toArray();
						     @endphp

						       <div class="row justify-content-center">
						          @if(count($right_celebrities_birthday)==0)
						            @foreach($bdaylist as $bday_key => $bday_item) 
						               <div class="col-4 text-center">
						                  @if($bday_item->profile_picture)
						                    @php 
						                        $profileimg = url('/')."/uploads/members/".$bday_item->profile_picture;
						                        
						                        if($bday_item->sm!='') {
						                            $profileimg = $bday_item->profile_picture;
						                        } 
						                    @endphp
						                    <img src="{{$profileimg}}" width="50" height="50" title="{{$bday_item->name}}" style="border-radius: 50%;">
						                  @else 
						                    <img src="{{ url('/') }}/assets/images/usrbig.jpg" title="{{$bday_item->name}}" width="50" height="50" style="border-radius: 50%;">
						                  @endif
						                  <span class="badge badge-danger">{{ date("M d",strtotime($bday_item->dob))}}</span>
						               </div>
						            @endforeach
						          @endif

						          @if(count($right_celebrities_birthday)>0)
						            @foreach($right_celebrities_birthday as $bday_key => $bday_item) 
						               <div class="col-4 text-center">
						                  @if($bday_item->profile_picture)
						                    @php 
						                        $profileimg = url('/')."/uploads/members/".$bday_item->profile_picture;
						                        if($bday_item->sm!='') {
						                            $profileimg = $bday_item->profile_picture;
						                        } 
						                    @endphp
						                    <img src="{{$profileimg}}" width="50" height="50" title="{{$bday_item->name}}" style="border-radius: 50%;">
						                  @else 
						                    <img src="{{ url('/') }}/assets/images/usrbig.jpg" title="{{$bday_item->name}}" height="50" width="50" style="border-radius: 50%;">
						                  @endif
						                  <span class="badge badge-danger">{{ date("M d",strtotime($bday_item->dob))}}</span>
						               </div>
						            @endforeach
						          @endif

						          @if(count($right_celebrities_birthday)==0 && count($bdaylist)==0) 
						            <p>No one has birthday on this week!</p>
						          @else 
						           <div class="col-12 text-center pt-2">
						              <a href="{{url('/')}}/post_wishes"><button type="button" class="btn btn-danger btn-block">Post your Wishes</button></a>
						           </div>
						          @endif

						        </div>
						    </div>
  </div>
  <div class="match-results-table widget">
     <div class="heading">
        <div class="row">
           <div class="col-2">
              <i class="fas fa-newspaper" style="color: #fff;font-size: 22px;"></i>
           </div>
           <div class="col-8">
              <h4 style="margin-top: 12px;">Fan Post</h4>
           </div>
           <div class="col-2">
              <i class="fas fa-newspaper" style="color: #fff;font-size: 22px;"></i>
           </div>
        </div>
     </div>
     <div class="body">
      @php
        $fanpost_right = DB::table('fan_post')->where('status','1')->where('is_delete','0')->where('post_type','image')->orderBy('id','DESC')->get();
      @endphp
        <div class="top-stories-widget">
           <div id="top-stories" class="owl-carousel owl-theme owl-loaded owl-drag">
           <div class="owl-stage-outer"><div class="owl-stage" style="transform: translate3d(0px, 0px, 0px); transition: all 0.25s ease 0s; width: 900px;">

             @if(count($fanpost_right)>0)
                @php $loopcount = 1; @endphp
                @foreach($fanpost_right as $right_tag_key => $right_tag_item) 
                    @php 
                      $righttag_postimages = DB::table('post_images')->where('post_id',$right_tag_item->id)->first(); 
                      $right_userdata = DB::table('users')->where('id',$right_tag_item->created_by)->first();  
                    @endphp
                    
                      @if($righttag_postimages)
                        @php $loopcount++; @endphp
                       <div class="owl-item" style="width: 300px;"><div class="item">
                         <ul class="top-stories">
                           <!--Story Start-->
                           <li class="story-row" style="min-height: 65px;">
                             <div class="ts-thumb"><img style="border-radius: 50%; height: 65px;" src="{{url('/')}}/uploads/fanpost_images/{{ $righttag_postimages->image_name }}" alt=""> </div>
                             <div class="ts-txt">
                               <h5> <a href="{{url('/')}}/postview/{{$right_tag_item->id}}">{{$right_tag_item->post_name}}</a> 
                               </h5>
                               <ul class="tsw-meta">
                                 <li>By {{isset($right_userdata->name)?$right_userdata->name:''}}</li>
                               </ul>
                             </div>
                           </li>
                           <!--Story End--> 
                         </ul>
                       </div></div>
                    @endif
                  
                  @php if($loopcount>3) { break; } @endphp
              @endforeach
            @else 
              <p>No posts to diplay!</p>
            @endif

           </div></div><div class="owl-nav"><button type="button" role="presentation" class="owl-prev disabled"><span aria-label="Previous">‹</span></button><button type="button" role="presentation" class="owl-next"><span aria-label="Next">›</span></button></div><div class="owl-dots"><button role="button" class="owl-dot active"><span></span></button><button role="button" class="owl-dot"><span></span></button><button role="button" class="owl-dot"><span></span></button></div></div>
         </div>
        <div class="row justify-content-center">
           <div class="col-12 text-center pt-2">
              <a href="{{url('/')}}/fanzpost"><button type="button" class="btn btn-danger btn-block">Create Post</button></a>
           </div>
        </div>
     </div>
  </div>
  <div class="widget sidebar-ad" id="sidebar1"> 

    @php
      $ad_global_bottom_right = DB::table('advertisement')->where('status', '1')->where('position',$right_bottom_position)->first();
    @endphp

    @if($ad_global_bottom_right)
      <a href="javascript:void(0);" title="{{$ad_global_bottom_right->ad_name}}" onclick="clickAd('{{$ad_global_bottom_right->id}}')"><img style="box-shadow: 0 4px 24px -5px rgba(0, 0, 0, 0.4);" class="img-responsive" src="{{url('/')}}/uploads/ad_image/{{$ad_global_bottom_right->ad_image}}" alt=""></a>
    @else
      <img style="box-shadow: 0 4px 24px -5px rgba(0, 0, 0, 0.4);" class="img-responsive" src="https://via.placeholder.com/300x600" alt=""> 
    @endif

</div>