Skip to main content

followers with following flag

$followers=DB::table('user_followers as f')->join('users as u', 'u.id', '=', 'f.follower_id')
            ->leftJoin('user_followers AS b', function($join){
                $join->on('b.follower_id', '=', 'f.leader_id')
                     ->on('b.leader_id', '=', 'u.id');
            })
            ->selectRaw(DB::raw("u.user_id,u.full_name,u.username,u.avatar,
            case when b.follower_id is null then 0
                when b.follower_id is not null and  b.status=1 then 1
            else 2
            end as isFollowing,
            case when b.follower_id is null then 'Follow'
                when b.follower_id is not null and  b.status=1 then 'Pending'
            else 'Following'
            end as isFollowing
            "))
            ->where("f.leader_id",$authUserId)
            ->paginate(5);
            ;
-----------------------------------------
Mysql
----------------------------------

 SELECT 
    u.id,
    u.username,
    f.status,
    case when b.follower_id is null then -- No record in b if 3 didn't follow this user back.
       'User is not following back'
    else
       'User is following back'
    end as back
FROM 
    user_followers f -- IDs of followers of user 3
    INNER JOIN users u  -- User information of those followers
       ON u.id = f.follower_id
    LEFT JOIN user_followers b  -- Check if 3 follows them back.
       ON b.follower_id = f.leader_id and
          b.leader_id = u.id
WHERE
    f.leader_id = 582

Comments

Post a Comment

Popular posts from this blog

AWS EC2, LAMP, Laravel and RDS Installation / setup

This document shows you how to configure AWS environment in Amazon EC2 with RDS Instance. We need to login in to AWS to start the configuration. http://aws.amazon.com Login screen for AWS Management console: First thing we have to select is region. On which region you want to deploy your server. I am going to select Oregon region here for my setup. 1.       click on the launch instance button, 2.       It redirects to following screen. Here we have to search for required operating system or select from list,  here im selecting Ubuntu latest version 4.       After selecting operating system, choose the instance type according to our requirement. Here I need lower configuration so choosing t2.micro type instance.   5.       Click Next button, then you see the below screen. Here we to modify if any settings need to modify Like changing netwo...
1 comment
Read more

Laravel Request Validator json response example

 Step 1 :  php artisan make : request  StoreArticleRequest Step 2 : <?php namespace App\Http\Requests; use Illuminate\Foundation\Http\FormRequest; use Illuminate\Http\JsonResponse; use Illuminate\Contracts\Validation\Validator; use Illuminate\Http\Exceptions\HttpResponseException; class StoreArticleRequest extends FormRequest { /** * Determine if the user is authorized to make this request. * * @return bool */ public function authorize () { return true ; } /** * Get the validation rules that apply to the request. * * @return array */ public function rules () { return [ 'title' => 'required' ]; } protected function failedValidation (Validator $validator ) { if ($this -> wantsJson () || $this -> ajax ()) { throw new HttpResponseException( response () -> json ([ 'status' => ...
Post a Comment
Read more