/** * Get the assigned vle for the specified card with sector and district * params @int $id * * return array */ public static function get_partners($id, $sid) { $partners = Card::select('users.*'); $partners->leftjoin('partner_district_sector', function ($join) use($sid) { $join->on('partner_district_sector.district_id', '=', static::$c_district_id); $join->where('partner_district_sector.sector_id', '=', $sid); }); $partners->join('users', 'users.id', '=', 'partner_district_sector.partner_id', 'left'); $partners->where(static::$c_id, $id); $partners->where('group_id', 3); $partners->orderby(static::$u_name, 'asc'); return $partners->get(); }