public function getGuardians($params)
{
$query = StuGuardians::find()->where(['is_status' => 0]);
$query->join('join', 'stu_guardians as sg', 'sg.guardia_stu_master_id = stu_master.stu_master_id')->where("stu_master.stu_master_id = " . $params['id']);
$query->joinWith(['guardiaStuMaster']);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
return $dataProvider;
}
public function actionEmgChangeStatus()
{
$guard = StuGuardians::find()->where(['guardia_stu_master_id' => $_REQUEST['sid']])->asArray()->all();
foreach ($guard as $gu) {
if ($gu['is_emg_contact'] == 1) {
StuGuardians::updateAll(['is_emg_contact' => 0], 'guardia_stu_master_id=:sid AND stu_guardian_id <> :gid', [':sid' => $_REQUEST['sid'], ':gid' => $_REQUEST['guard_id']]);
} else {
StuGuardians::updateAll(['is_emg_contact' => 1], 'guardia_stu_master_id=:sid AND stu_guardian_id=:gid', [':sid' => $_REQUEST['sid'], ':gid' => $_REQUEST['guard_id']]);
}
}
//return $this->redirect(['view', 'id' => $sid]);
}
public function actionEmgChangeStatus()
{
$guard = StuGuardians::find()->where('guardia_stu_master_id = ' . $_REQUEST['sid'])->asArray()->all();
foreach ($guard as $gu) {
if ($gu['is_emg_contact'] == 1) {
\Yii::$app->db->createCommand("UPDATE stu_guardians SET is_emg_contact =0 WHERE guardia_stu_master_id =" . $_REQUEST['sid'] . " AND stu_guardian_id <> " . $_REQUEST['guard_id'])->execute();
} else {
\Yii::$app->db->createCommand("UPDATE stu_guardians SET is_emg_contact =1 WHERE guardia_stu_master_id =" . $_REQUEST['sid'] . " AND stu_guardian_id = " . $_REQUEST['guard_id'])->execute();
}
}
//return $this->redirect(['view', 'id' => $sid]);
}
