public function actionSearchCurrency($search = null, $id = null)
{
$out = ['more' => false];
$q = new Query();
if (!is_null($search)) {
$q->select('cur.id, cur.name as text')->from(ResCurrency::tableName() . ' as cur')->where('LOWER(cur.name) LIKE :search')->addParams([':search' => '%' . strtolower($search) . '%']);
$users = $q->createCommand()->queryAll();
$out['results'] = array_values($users);
} elseif ($id > 0) {
$out['results'] = ['id' => $id, 'text' => ResCurrency::find()->where(['id' => $id])->with('partner')->one()->partner->name];
} else {
$out['results'] = ['id' => 0, 'text' => 'No matching records found'];
}
echo Json::encode($out);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getCurrency()
{
return $this->hasOne(ResCurrency::className(), ['id' => 'currency_id']);
}
