/** * @param $param * @return array */ public static function ownerList($param) { $list['results'] = (new Query())->select(['e.id', 'concat_ws(" ", e.last_name, e.first_name, e.middle_name) as name', 'e.post', 'b.branch_name as division'])->from(['e' => Employee::tableName()])->leftJoin('branches b', 'e.branch = b.id')->where(['like', 'last_name', $param])->all(); return $list; }
/** * @param $queryParam * @return array */ public static function itemsList($queryParam) { if (is_numeric($queryParam)) { $query = new Query(); $query->select(['_id' => false, 'number' => 'text'])->from(Number::collectionName())->where(['like', 'number', $queryParam]); } else { $query = new \yii\db\Query(); $query->select(["CONCAT_WS(' ',last_name, first_name, middle_name) AS number"])->from(Employee::tableName())->where(['like', 'last_name', $queryParam]); } $items['results'] = array_map(function ($item) { $item['id'] = $item['number']; return $item; }, $query->limit(10)->all()); return $items; }