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]);
}
