/** * js(on)entity returns an json object for the select2 widget * @param string $search Text for the lookup * @param integer of the set value * @return json [description] */ public function actionJsentity($search = NULL, $id = NULL) { header('Content-type: application/json'); $clean['more'] = false; $query = new Query(); if (!is_Null($search)) { $mainQuery = $query->select('id, name AS text')->from('{{%entity}}')->where('UPPER(name) LIKE "%' . strtoupper($search) . '%"'); $command = $mainQuery->createCommand(); $rows = $command->queryAll(); $clean['results'] = array_values($rows); } else { if (!is_null($id)) { $clean['results'] = ['id' => $id, 'text' => Entity::findOne($id)->name]; } else { $clean['results'] = ['id' => 0, 'text' => 'None found']; } } echo Json::encode($clean); exit; }
/** * Finds the Entity model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Entity the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Entity::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }