Conditional JOIN QUERY in Laravel Query Builder

Question

I have the following SQL query. I want to implement the same query in laravel query builder. But no luck. Can help me to how to build this.

SELECT DISTINCT IF(follower_id = 1, leader_id, follower_id ) as user_id,U.email,T.name FROM `followers` as F JOIN users as U ON IF(follower_id = 1, U.id = F.leader_id,U.id=F.follower_id ) JOIN timelines as T ON U.timeline_id = T.id   where F.follower_id = 1 OR F.leader_id =1

I don't how to add this condition

ON IF(follower_id = 1, U.id = F.leader_id,U.id=F.follower_id )

in Laravel query builder.

alistaircol · Accepted Answer · 2017-06-14 11:46:31Z

1

I have not tested but something like this is maybe what you are looking for:

<?php

DB::connection('my_connection')
  ->table('followers AS F')
  ->select([
    'DISTINCT IF(F.follower_id = 1, F.leader_id, F.follower_id) AS user_id',
    'U.email',
    'T.name',
  ])
  ->leftJoin(
    'users AS U', function ($join) {
      $join->on('U.id'. '=', 'F.leader_id')->where('F.follower_id', '=', 1);
      $join->on('U.id', '=', 'F.follower_id')->where('F.follower_id', '<>', 1);
    }
  )
  ->leftJoin(
    'timelines AS T', 'T.id', '=', 'U.timeline_id'
  )
  ->where([
    ['F.follower_id', '=', 1],
    ['F.leader_id', '=', 1]
  ]);

answered Jun 14, 2017 at 11:46

alistaircol

1,45312 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional JOIN QUERY in Laravel Query Builder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related