Write commans query in yii2

Yii 2.0 General Discussions
1

Hi guys

I want to write a query in yii2

and i dont know how to write it

i tried few things from documentaion but its not working

here is my query




SELECT notification.*,event.title,user.firstname,user.lastname FROM notification 

LEFT JOIN event ON event.id = notification.source_id 

AND notification.activity_type = "checkin" 

LEFT JOIN user ON user.id = notification.source_id 

AND notification.activity_type = "friend"

and here is the query i write for now,i need to add AND function just like its in the query




 $query  ->select(['notification.*,event.title,user.firstname,user.lastname'])

                ->from('notification')

                ->leftJoin('event', 'event.id = notification.source_id')

                ->leftJoin('user', 'user.id = notification.source_id');
2

$query = new Query();

	$query->select


			   ([


					'[color=#008800][size=2]notification.* As Not,event.title As Event,user.firstname As First,user.lastname As Last[/size][/color][size=2]'[/size]


			   ]) 


			  ->from('[size=2]notification[/size][size=2]')[/size]


			  ->join('LEFT OUTER JOIN','event','[size=2]notification[/size][color=#666600][size=2].[/size][/color][size=2]source_id[/size][size=2]=[/size][color="#000088"][size=2]event[/size][/color][color=#666600][size=2].[/size][/color][size=2]id[/size][size=2]')[/size]

[size=2] [/size][size=2]->where(’[/size][size=2]notification[/size][color=#666600][size=2].[/size][/color][size=2]activity_type[/size][size=2]=:id’,[‘id’=>[/size][color=#008800][size=2]checkin[/size][/color][size=2]])[/size]

			  ->join('LEFT OUTER JOIN','[size=2]user[/size][size=2]','[/size][size=2]notification[/size][color=#666600][size=2].[/size][/color][size=2]source_id[/size][size=2]=[/size][size=2]user[/size][color=#666600][size=2].[/size][/color][size=2]id[/size][size=2]')[/size]


			  ->andWhere('[size=2]notification[/size][color=#666600][size=2].[/size][/color][size=2]activity_type[/size][size=2]>=:no',['no'=>[/size][color=#008800][size=2]friend[/size][/color][size=2]]);[/size]


              





         $command 	= $query->createCommand();


	$result 	= $command->queryAll();

u can try this.

3

did it work?