Пример #1
0
 protected static function personPrepare()
 {
     return PersonModel::join(PersonLangModel::getTableName(), PersonLangModel::getField("person_id"), '=', PersonModel::getField("id"))->join(PersonRelModel::getTableName(), PersonRelModel::getField("person_id"), '=', PersonModel::getField("id"))->leftJoin(Files::getTableName(), function ($join) {
         $join->on(Files::getField("module_id"), '=', PersonModel::getField("id"));
         $join->on(Files::getField("module_name"), '=', DB::raw("'person'"));
     })->where(PersonLangModel::getField("lang_id"), \WebAPL\Language::getId())->orderBy('first_name', 'asc')->orderBy('last_name', 'asc');
 }