Esempi in PHP per EID\Models\Location Region::rightjoin

Esempio n. 1

File: Region.php Progetto: CHAIUganda/vl_dashboard

 public static function regionsFacilitiesInit()
 {
     $arr = array();
     $res = Region::rightjoin('districts AS d', 'd.id', '=', 'f.districtID')->rightjoin('regions AS r', 'r.id', '=', 'd.regionID')->select('regionID', 'region', 'f.id AS facility_id')->from('facilities AS f')->get();
     foreach ($res as $row) {
         $arr[$row->regionID][$row->facility_id] = 0;
     }
     return $arr;
 }