public function actionIndex() { $session = new Session(); $session->open(); $countApprove = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 1])->count(); $countProblem = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 200])->count(); $countFinished = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 300])->count(); $totalCount = Homeuser::find()->where(['requestby' => $session['userid']])->count(); $pages = new Pagination(['totalCount' => $totalCount, 'pageSize' => 5]); $model = Homeuser::find()->where(['requestby' => $session['userid']])->offset($pages->offset)->limit($pages->limit)->all(); return $this->render('index', ['model' => $model, 'approve' => $countApprove, 'problem' => $countProblem, 'finished' => $countFinished, 'pages' => $pages]); }
/** * Lists all Udashboard models. * @return mixed */ public function actionIndex() { // $searchModel = new UdashboardSearch(); // $dataProvider = $searchModel->search(Yii::$app->request->queryParams); // // return $this->render('index', [ // 'searchModel' => $searchModel, // 'dataProvider' => $dataProvider, // ]); $session = new Session(); $session->open(); $countApprove = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 1])->count(); $countProblem = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 200])->count(); $countFinished = Homeuser::find()->where(['requestby' => $session['userid'], 'jobstatus' => 300])->count(); $totalCount = Homeuser::find()->where(['requestby' => $session['userid']])->count(); $pages = new Pagination(['totalCount' => $totalCount, 'pageSize' => 5]); $model = Homeuser::find()->where(['requestby' => $session['userid']])->orderBy(['recid' => SORT_DESC])->offset($pages->offset)->limit($pages->limit)->all(); return $this->render('index', ['model' => $model, 'approve' => $countApprove, 'problem' => $countProblem, 'finished' => $countFinished, 'pages' => $pages]); }