public function actionUpdatesettings()
{
if (!isset($_POST['select_orgs']) || empty($_POST['select_orgs'])) {
return;
}
if (!isset($_POST['select_types']) || empty($_POST['select_types'])) {
return;
}
if (!isset($_POST['select_start_date']) || empty($_POST['select_start_date'])) {
return;
}
if (!isset($_POST['select_end_date']) || empty($_POST['select_end_date'])) {
return;
}
$orgs = $_POST['select_orgs'];
$types = $_POST['select_types'];
$startdate = $_POST['select_start_date'];
$enddate = $_POST['select_end_date'];
$connection = \Yii::$app->db;
// DELETE
Preferences::deleteAll('pref_name LIKE "organisationID"');
Preferences::deleteAll('pref_name LIKE "selectedTypes"');
Preferences::deleteAll('pref_name LIKE "end_date"');
Preferences::deleteAll('pref_name LIKE "start_date"');
// UPDATE
foreach ($orgs as $org) {
//echo $query. '<br>';
$connection->createCommand()->insert('preferences', ['pref_name' => 'organisationID', 'pref_value' => $org])->execute();
}
foreach ($types as $type) {
//echo $query. '<br>';
$connection->createCommand()->insert('preferences', ['pref_name' => 'selectedTypes', 'pref_value' => $type])->execute();
}
$connection->createCommand()->insert('preferences', ['pref_name' => 'start_date', 'pref_value' => $startdate])->execute();
$connection->createCommand()->insert('preferences', ['pref_name' => 'end_date', 'pref_value' => $enddate])->execute();
return 1;
}
public function actionResultsb21afmorg()
{
if (!isset($_POST['select_orgs']) || empty($_POST['select_orgs'])) {
$orgID1 = Preferences::findOne(['pref_name' => 'Resultsb21afmorgID']);
$orgID = $orgID1->pref_value;
Preferences::deleteAll(['pref_name' => 'Resultsb21afmorgID']);
} else {
$orgID = $_POST['select_orgs'];
}
if (!isset($_POST['set_afm']) || empty($_POST['set_afm'])) {
$afm1 = Preferences::findOne(['pref_name' => 'Resultsb21afmorgcpv']);
$afm = $afm1->pref_value;
Preferences::deleteAll(['pref_name' => 'Resultsb21afmorgcpv']);
} else {
$afm = $_POST['set_afm'];
}
Preferences::deleteAll(['pref_name' => 'Resultsb21afmorgID']);
Yii::$app->view->params['Resultsb21afmorgID'] = $orgID;
$pref = new Preferences();
$pref->pref_name = 'Resultsb21afmorgID';
$pref->pref_value = $orgID;
$pref->save();
Preferences::deleteAll(['pref_name' => 'Resultsb21afmorgcpv']);
Yii::$app->view->params['Resultsb21afmorgcpv'] = $afm;
$pref = new Preferences();
$pref->pref_name = 'Resultsb21afmorgcpv';
$pref->pref_value = $afm;
$pref->save();
return $this->render('resultsb21afmorg');
}
