public function actionIndex() { $report = new Report(); if ($report->load(Yii::$app->request->post()) && $report->validate()) { $active_from = $_POST['Report']['active_from']; $active_to = $_POST['Report']['active_to']; $query = $report->ReportSql($active_from, $active_to); //return print_r($query); return $this->render('report', ['query' => $query]); } return $this->render('index', ['report' => $report]); }
public function actionIndex() { $model = new Report(); $models = null; try { if ($model->load(Yii::$app->request->post()) && $model->validate()) { $models = $model->search(); } } catch (\Exception $e) { $msg = isset($e->errorInfo[2]) ? $e->errorInfo[2] : $e->getMessage(); $model->addError('_exception', $msg); } return $this->render('index', ['model' => $model, 'models' => $models]); }
public function actionForm() { $model = new Report(); if ($model->load(Yii::$app->request->post())) { $model->location_is_precise = true; $date = new DateTime(); $model->time_sent = $date->format('Y-m-d H:i:s'); $model->time_updated = $date->format('Y-m-d H:i:s'); if ($model->validate()) { $model->save(); \Yii::$app->session->setFlash('submittedForm'); return $this->refresh(); } } $languages = Language::find()->all(); $language_arr = []; foreach ($languages as $language) { $language_arr[$language->id_language] = $language->name . " (" . $language->dialect . ")"; } $disabilities = DisabilityCategory::find()->all(); $disability_arr = []; foreach ($disabilities as $disability) { $disability_arr[$disability->id_disability_category] = $disability->category; } $problems = ProblemCategory::find()->all(); $problem_arr = []; foreach ($problems as $problem) { $problem_arr[$problem->id_problem_category] = $problem->category; } return $this->render('form', ['model' => $model, 'languages' => $language_arr, 'disabilities' => $disability_arr, 'problems' => $problem_arr]); }