/** * Lists all Products models. * @return mixed */ public function actionUser() { $transactions = []; $user_account = null; $pagination = null; $date_posted = ''; $g_total_quantity = $g_total_amount = $g_total_amount_paid = 0; $user_id = Yii::$app->request->post('player_select'); if (Yii::$app->request->post('date_range')) { $date_posted = Yii::$app->request->post('date_range'); } elseif (Yii::$app->request->getQueryParam('page')) { $date_posted = Yii::$app->session['date_posted']; $user_id = Yii::$app->session['user_id']; } if ($date_posted != '') { Yii::$app->session['date_posted'] = $date_posted; Yii::$app->session['user_id'] = $user_id; $date_range = explode(' to ', $date_posted); $start_date = $date_range[0]; $end_date = $date_range[1]; $query = Transactions::find()->where(['BETWEEN', 'transaction_date', Yii::$app->formatter->asDate($start_date, 'php:Y-m-d') . ' 00:00:00', Yii::$app->formatter->asDate($end_date, 'php:Y-m-d') . ' 23:59:59'])->orderBy(['transaction_date' => SORT_DESC]); if ($user_id > 0) { $query->andWhere(['user_id' => $user_id]); } $pagination = new Pagination(['totalCount' => $query->count(), 'pageSize' => 10]); $g_total_quantity = $query->sum('total_quantity'); $g_total_amount = $query->sum('total_amount'); $g_total_amount_paid = $query->sum('amount_paid'); $transactions = $query->offset($pagination->offset)->limit($pagination->limit)->all(); $user_account = UserAccounts::findOne($user_id); } return $this->render('users', ['transactions' => $transactions, 'user_account' => $user_account, 'g_total_quantity' => $g_total_quantity, 'g_total_amount' => $g_total_amount, 'g_total_amount_paid' => $g_total_amount_paid, 'pagination' => $pagination]); }
/** * Finds the UserAccounts model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return UserAccounts the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = UserAccounts::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }