PHP App\Data\Entities City::leftJoin Examples

Programming Language: PHP

Namespace/Package Name: App\Data\Entities

Class/Type: City

Method/Function: leftJoin

Examples at hotexamples.com: 1

PHP App\Data\Entities City::leftJoin - 1 examples found. These are the top rated real world PHP examples of App\Data\Entities\City::leftJoin extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

create(1)

leftJoin(1)

where(1)

Frequently Used Methods

create (1)

leftJoin (1)

where (1)

Example #1

Show file

File: Subscriptions.php Project: alerj/parlamentojuvenil

 public function byState()
 {
     return City::leftJoin('subscriptions', 'cities.name', '=', 'subscriptions.city')->join('states', 'states.id', '=', 'cities.state_id')->where('states.code', 'RJ')->distinct()->select('cities.name as city', DB::raw('(select count(*) from subscriptions where subscriptions.ignored = false and subscriptions.city = cities.name) as subscriptionCount'), DB::raw('(select max(created_at) from subscriptions where subscriptions.ignored = false and subscriptions.city = cities.name) as lastSubscription'), DB::raw('(select count(distinct school) from subscriptions where subscriptions.ignored = false and subscriptions.city = cities.name) as schoolCount'), DB::raw('(select count(*) from subscriptions where subscriptions.ignored != false and subscriptions.city = cities.name) as cancelledCount'), DB::raw('(select count(*) from cities where cities.state_id = 19 and cities.name in (select city from subscriptions where subscriptions.ignored = false)) as citiesIn'), DB::raw('(select count(*) from cities where cities.state_id = 19 and cities.name not in (select city from subscriptions where subscriptions.ignored = false)) as citiesOut'))->orderBy('cities.name')->get();
 }