public function actionIndex() { $grades = Grade::find()->all(); $schools = School::find()->all(); $users = User::find()->all(); $scholars = Scholar::find()->all(); $tuitions = Tuition::find()->all(); return $this->render('index', array('users' => $users, 'scholars' => $scholars, 'schools' => $schools, 'grades' => $grades, 'tuition' => $tuitions)); }
/** * Lists all Compile models. * @return mixed */ public function actionIndex() { $schools = School::find()->all(); $users = User::find()->all(); $scholars = Scholar::find()->all(); $allowances = Allowance::find()->all(); $grades = Grade::find()->all(); return $this->render('index', array('users' => $users, 'scholars' => $scholars, 'schools' => $schools, 'allowances' => $allowances, 'grades' => $grades)); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Grade::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->joinWith('scholarScholar'); $query->joinWith('subjectSubject'); $query->joinWith('subjectSubject'); $query->andFilterWhere(['grade_id' => $this->grade_id, 'subject_subject_id' => $this->subject_subject_id, 'subject_scholar_scholar_id' => $this->subject_scholar_scholar_id, 'subject_scholar_school_school_id' => $this->subject_scholar_school_school_id, 'grade_school_year_start' => $this->grade_school_year_start, 'grade_school_year_end' => $this->grade_school_year_end]); $query->andFilterWhere(['like', 'grade_raw_grade', $this->grade_raw_grade])->andFilterWhere(['like', 'grade_approval_status', $this->grade_approval_status])->andFilterWhere(['like', 'grade_approved_by', $this->grade_approved_by])->andFilterWhere(['like', 'scholar.scholar_first_name', $this->firstName])->andFilterWhere(['like', 'scholar.scholar_middle_name', $this->middleName])->andFilterWhere(['like', 'scholar.scholar_last_name', $this->lastName])->andFilterWhere(['like', 'subject.subject_name', $this->subjectName])->andFilterWhere(['like', 'subject.subject_term', $this->subjectTerm])->andFilterWhere(['like', 'subject.subject_units', $this->subjectUnits])->andFilterWhere(['like', 'subject.subject_taken_status', $this->takenStatus]); return $dataProvider; }
use common\models\Grade; use common\models\GroupGrade; use common\models\User; ?> <div class="grade-form"> <?php $form = ActiveForm::begin(['id' => 'dynamic-form']); ?> <?php $username = Yii::$app->user->identity->username; $users = User::find()->all(); $scholars = Scholar::find()->all(); $model = new Subject(); $modelCustomer = new Grade(); $modelsAddress = [new Grade()]; foreach ($users as $user) { foreach ($scholars as $scholar) { if ($user->username == $username && $user->id == $scholar->scholar_user_id) { $modelCustomer->subject_scholar_scholar_id = $scholar->scholar_id; if ($modelCustomer->load(Yii::$app->request->post())) { $modelsAddress = GroupGrade::createMultiple(Grade::classname()); GroupGrade::loadMultiple($modelsAddress, Yii::$app->request->post()); // ajax validation if (Yii::$app->request->isAjax) { Yii::$app->response->format = Response::FORMAT_JSON; return ArrayHelper::merge(ActiveForm::validateMultiple($modelsAddress), ActiveForm::validate($modelCustomer)); } // validate all models $valid = $modelCustomer->validate();
/** * Finds the Grade model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $grade_id * @param integer $subject_subject_id * @param integer $subject_scholar_scholar_id * @param integer $subject_scholar_school_school_id * @return Grade the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Grade::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * @return \yii\db\ActiveQuery */ public function getGrades1() { return $this->hasMany(Grade::className(), ['subject_scholar_school_school_id' => 'scholar_school_school_id']); }
$form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'subject_term')->textInput(); ?> <?php echo $form->field($model, 'subject_name')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'subject_units')->textInput(['maxlength' => true]); ?> <?php $modelCustomers = Grade::find()->all(); foreach ($modelCustomers as $modelCustomer) { if ($modelCustomer->subject_subject_id == $model->subject_id) { $test = $form->field($modelCustomer, 'grade_raw_grade')->textInput(['maxlength' => true]); } } ?> <?php echo $test; ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div>
/** * Updates an existing Subject model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id * @return mixed */ public function actionUpdate($id) { $model = $this->findModel($id); $model2s = Grade::find()->all(); foreach ($model2s as $model2) { if ($model->subject_id == $model2->subject_subject_id) { if ($model2->grade_approval_status == 'Not Approved') { if ($model->load(Yii::$app->request->post()) && $model->save()) { if ($model2->load(Yii::$app->request->post()) && $model2->save()) { return $this->redirect(['index', 'id' => $model2->grade_id]); } return $this->redirect(['index', 'id' => $model->subject_id]); } else { return $this->render('update', ['model' => $model]); } } else { \Yii::$app->getSession()->setFlash('error', 'The record has already been reviewed by the SM Foundation'); return $this->redirect(['index', 'id' => $model->subject_id]); } } } }
public function actionGroupcreate() { $modelCustomer = new Grade(); $modelsAddress = [new Grade()]; if ($modelCustomer->load(Yii::$app->request->post())) { $modelsAddress = GroupGrade::createMultiple(Grade::classname()); GroupGrade::loadMultiple($modelsAddress, Yii::$app->request->post()); // ajax validation if (Yii::$app->request->isAjax) { Yii::$app->response->format = Response::FORMAT_JSON; return ArrayHelper::merge(ActiveForm::validateMultiple($modelsAddress), ActiveForm::validate($modelCustomer)); } // validate all models $valid = $modelCustomer->validate(); $valid = GroupGrade::validateMultiple($modelsAddress) && $valid; if ($valid) { $transaction = \Yii::$app->db->beginTransaction(); try { // if($flag = $modelCustomer->save(false)){ foreach ($modelsAddress as $modelAddress) { $modelAddress->subject_scholar_scholar_id = $modelCustomer->subject_scholar_scholar_id; $modelAddress->grade_school_year_start = $modelCustomer->grade_school_year_start; $modelAddress->grade_school_year_end = $modelCustomer->grade_school_year_end; $selectSchool = ArrayHelper::map(Scholar::find()->where(['scholar_id' => $modelAddress->subject_scholar_scholar_id])->all(), 'school_school_id', 'school_school_id'); $schoolID = array_values($selectSchool)[0]; $modelAddress->subject_scholar_school_school_id = $schoolID; if (!($flag = $modelAddress->save(false))) { $transaction->rollBack(); break; } } // } if ($flag) { if ($modelCustomer->subject_subject_id == null) { $sql = "DELETE FROM grade WHERE subject_subject_id is null;"; Yii::$app->db->createCommand($sql)->execute(); } $transaction->commit(); return $this->redirect(['index']); } } catch (Exception $e) { $transaction->rollBack(); } } } return $this->render('groupcreate', ['modelCustomer' => $modelCustomer, 'modelsAddress' => empty($modelsAddress) ? [new Grade()] : $modelsAddress]); }