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.');
}
}
