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 actionStudentProfilePdf($sid) { $nationality = $stuAdd = []; $stuMaster = StuMaster::findOne($sid); $stuDocs = StuDocs::find()->where(['stu_docs_stu_master_id' => $sid])->join('join', 'document_category dc', 'dc.doc_category_id = stu_docs_category_id AND dc.is_status <> 2')->all(); $stuInfo = StuInfo::find()->where(['stu_info_stu_master_id' => $sid])->one(); $stuCourse = Courses::findOne($stuMaster->stu_master_course_id); $stuBatch = Batches::findOne($stuMaster->stu_master_batch_id); $stuSection = Section::findOne($stuMaster->stu_master_section_id); $stuGuard = StuGuardians::findAll(['guardia_stu_master_id' => $sid]); $sDocs = new StuDocs(); if ($stuMaster->stu_master_nationality_id !== null) { $nationality = Nationality::findOne($stuMaster->stu_master_nationality_id)->nationality_name; } if ($stuMaster->stu_master_stu_address_id !== null) { $stuAdd = StuAddress::findOne($stuMaster->stu_master_stu_address_id); } $html = $this->renderPartial('/stu-master/stuprofilepdf', ['stuDocs' => $stuDocs, 'stuMaster' => $stuMaster, 'stuInfo' => $stuInfo, 'nationality' => $nationality, 'stuBatch' => $stuBatch, 'stuCourse' => $stuCourse, 'stuSection' => $stuSection, 'stuAdd' => $stuAdd, 'stuGuard' => $stuGuard, 'sDocs' => $sDocs]); $fName = $stuInfo->stu_first_name . "_" . $stuInfo->stu_last_name . "_" . date('Ymd-His'); return Yii::$app->pdf->exportData(Yii::t('report', 'Student Report'), $fName, $html); }
/** * Finds the StuGuardians model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return StuGuardians the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = StuGuardians::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
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]); }
/** * @return \yii\db\ActiveQuery */ public function getStuGuardians() { return $this->hasMany(StuGuardians::className(), ['guardia_stu_master_id' => 'stu_master_id']); }
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]); }