Exemple #1
0
 public function searchInfo()
 {
     $record_count = new Expression('count(id)');
     $start = new Expression("left(column_get(blob_data,'load_date' as datetime),16)");
     //        $end = new Expression("column_get(blob_data,'load_date' as datetime)");
     $query = parent::find()->addSelect(['record_count' => $record_count, 'start' => $start])->groupBy('start');
     $ret = $query->all();
     //        var_dump($ret);die;
     //        $dataProvider = new ActiveDataProvider([
     //            'query' => $query,
     //            'pagination'=>false,
     //        ]);
     $return['labels'] = ArrayHelper::getColumn($ret, 'start');
     $return['data'] = ArrayHelper::getColumn($ret, 'record_count');
     //        $return['cpu']=shell_exec('rrdtool fetch /var/lib/munin/localhost/localhost-mysql_bytes-recv-d.rrd AVERAGE -r 1m -s -1h');
     //        var_dump($return['cpu']);die;
     return $return;
 }
Exemple #2
0
 /**
  * Finds the Loader model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $id
  * @return Loader the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Loader::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }