/**
* @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;
}
