public function actionIndex($id) { $connection = \Yii::$app->db; $servername = $this->getServername($id); $cmd = $connection->createCommand('SELECT MAX([CaptureDate]) FROM ConfigData WHERE [Server]=:srv'); $cmd->bindValue(':srv', $servername); $datum = $cmd->queryScalar(); // $searchModel = new ConfigDataSearch(); // $dataProvider = $searchModel->search(['ConfigDataSearch'=>['server'=>$servername]]); $dataProvider = new ActiveDataProvider(['query' => ConfigData::find()->where(['Server' => $servername])->andWhere(['CaptureDate' => $datum]), 'pagination' => ['pageSize' => 15]]); // get the posts in the current page //// $posts = $dataProvider->getModels(); // \yii\helpers\VarDumper::dump($dataProvider, 10, true); // -- ServerConfig $cmd = $connection->createCommand('SELECT MAX([CaptureDate]) FROM ServerConfig WHERE [server]=:srv'); $cmd->bindValue(':srv', $servername); $datum = $cmd->queryScalar(); $dataProvider_sc = new ActiveDataProvider(['query' => ServerConfig::find()->where(['Server' => $servername])->andWhere(['CaptureDate' => $datum]), 'pagination' => ['pageSize' => 15]]); //// $posts_sc = $dataProvider_sc->getModels(); // -- Datenbank-Daten $datum = DbData::find()->select(['CaptureDate'])->where(['Server' => $servername])->orderBy(['CaptureDate' => SORT_DESC])->scalar(); $dataProvider_db = new ActiveDataProvider(['query' => DbData::find()->where(['Server' => $servername, 'physicalFileName' => "_Total"])->andWhere(['CaptureDate' => $datum]), 'pagination' => ['pageSize' => 15]]); // -- Datasets date_default_timezone_set('Europe/Berlin'); $dt = date('Y-m-d H:i:s', time() - 60 * 60); // $dt->modify('-1 hour'); // \yii\helpers\VarDumper::dump($datasets, 10, true); return $this->render('index', ['id' => $id, 'servername' => $servername, 'dataProvider' => $dataProvider, 'dataProvider_sc' => $dataProvider_sc, 'dataProvider_db' => $dataProvider_db, 'datasets' => $this->getPerfmonDataset($servername, ['SQLServer:Buffer Manager:Page Life Expectancy:', ''], $dt), 'dataset_cpu' => $this->getPerfmonDataset($servername, 'Instance: Cpu Utilization %', $dt), 'dataset_pps' => $this->getPerfmonDataset($servername, 'OS:Pages/Sec:_Total', $dt), 'dataset_dql' => $this->getPerfmonDataset($servername, 'OS:Disk Queue Length:_Total', $dt), 'dataset_net' => $this->getNetPerfDataset($servername, 'BytesTotalPersec', $dt)]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = ConfigData::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, 'ConfigurationID' => $this->ConfigurationID, 'CaptureDate' => $this->CaptureDate]); $query->andFilterWhere(['like', 'Server', $this->Server])->andFilterWhere(['like', 'Name', $this->Name])->andFilterWhere(['like', 'Value', $this->Value])->andFilterWhere(['like', 'ValueInUse', $this->ValueInUse]); return $dataProvider; }
/** * Finds the ConfigData model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return ConfigData the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = ConfigData::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }