/** * Выводим подробную информацию об устройстве вместе с данными из таблицы parameters * @param integer $id * @return mixed */ public function actionView($id, $id_wp = 0) { $param_model = Parameters::findOne(['id_device' => $id]); $netSearch = new NetintsSearch(); $netProvider = $netSearch->search(Yii::$app->request->queryParams, $id); $voipSearch = new VoipnumbersSearch(); $voipProvider = $voipSearch->search(Yii::$app->request->queryParams, $id); $compSearch = new DevicesSearch(); $compProvider = $compSearch->search(Yii::$app->request->queryParams, 0, $id); Yii::$app->session->set('id_wp', $id_wp); return $this->render('view', ['model' => $this->findModel($id), 'param_model' => $param_model, 'voipSearch' => $voipSearch, 'voipProvider' => $voipProvider, 'netSearch' => $netSearch, 'netProvider' => $netProvider, 'compSearch' => $compSearch, 'compProvider' => $compProvider]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Parameters::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'nport' => $this->nport, 'id_device' => $this->id_device]); $query->andFilterWhere(['like', 'brend', $this->brend])->andFilterWhere(['like', 'model', $this->model])->andFilterWhere(['like', 'sn', $this->sn])->andFilterWhere(['like', 'mac', $this->mac])->andFilterWhere(['like', 'ip', $this->ip])->andFilterWhere(['like', 'login', $this->login])->andFilterWhere(['like', 'password', $this->password])->andFilterWhere(['like', 'biospass', $this->biospass])->andFilterWhere(['like', 'radmin', $this->radmin])->andFilterWhere(['like', 'dns', $this->dns])->andFilterWhere(['like', 'voip', $this->voip])->andFilterWhere(['like', 'aster_pwd', $this->aster_pwd])->andFilterWhere(['like', 'aster_cont', $this->aster_cont])->andFilterWhere(['like', 'imei', $this->imei]); return $dataProvider; }
/** * Finds the Parameters model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Parameters the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Parameters::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('Указанный набор параметров не найден'); } }