public function actionNew($eid) { $eid = (int) $eid; $id = EnrolledForm::findOne($eid); if ($id !== null) { $model = new AssessmentForm(); $student_id = (int) $id->student_id; $grade_level_id = (int) $id->grade_level_id; $student = StudentForm::findOne($id->student_id); $tuition = Tuition::find()->where(['grade_level_id' => $grade_level_id])->orderBy(['id' => SORT_DESC])->all(); $model->enrolled_id = $eid; $tid = (int) $tuition[0]['id']; $model->tuition_id = $tid; $model->has_sibling_discount = (int) $model->has_sibling_discount; $model->has_book_discount = (int) $model->has_book_discount; $model->has_honor_discount = (int) $model->has_honor_discount; if (!empty($tuition)) { $array = $tuition; } else { throw new NotFoundHttpException('Oops, Something went wrong.'); } //$tuition_detail = Tuition::find()->where(['grade_level_id' => $grade_level_id])->orderBy(['id' => SORT_DESC])->all(); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('new', ['model' => $model, 'student' => $student, 'tid' => $tid, 'array' => $array]); } } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function searchStudent($params) { $query = StudentForm::find(); $pageSize = Yii::$app->params['pageSize']; $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['created_at' => SORT_DESC]], 'pagination' => ['pageSize' => $pageSize]]); $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->andFilterWhere(['zip_code' => $this->zip_code, 'mobile' => $this->mobile, 'phone' => $this->phone, 'fathers_mobile' => $this->fathers_mobile, 'fathers_phone' => $this->fathers_phone, 'father_is' => $this->father_is, 'mothers_mobile' => $this->mothers_mobile, 'mothers_phone' => $this->mothers_phone, 'mother_is' => $this->mother_is, 'parents_are' => $this->parents_are, 'guardians_phone' => $this->guardians_phone, 'guardians_mobile' => $this->guardians_mobile, 'student_is_living_with' => $this->student_is_living_with, 'previous_school_phone' => $this->previous_school_phone, 'previous_school_mobile' => $this->previous_school_mobile, 'previous_school_grade_level' => $this->previous_school_grade_level, 'previous_school_average_grade' => $this->previous_school_average_grade, 'previous_school_from_school_year' => $this->previous_school_from_school_year, 'previous_school_to_school_year' => $this->previous_school_to_school_year, 'student_has_sibling_enrolled' => $this->student_has_sibling_enrolled, 'student_photo' => $this->student_photo, 'guardians_photo' => $this->guardians_photo, 'report_card' => $this->report_card, 'good_moral' => $this->good_moral, 'birth_certificate' => $this->birth_certificate, 'sped' => $this->sped, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]); $query->andFilterWhere(['like', 'id', $this->id])->andFilterWhere(['!=', 'status', 2])->andFilterWhere(['=', 'gender', $this->gender])->andFilterWhere(['=', 'grade_level_id', $this->grade_level_id])->andFilterWhere(['like', 'first_name', $this->first_name])->andFilterWhere(['like', 'middle_name', $this->middle_name])->andFilterWhere(['like', 'last_name', $this->last_name])->andFilterWhere(['like', 'nickname', $this->nickname])->andFilterWhere(['like', 'status', $this->status])->andFilterWhere(['like', 'religion', $this->religion])->andFilterWhere(['like', 'citizenship', $this->citizenship])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'fathers_name', $this->fathers_name])->andFilterWhere(['like', 'fathers_occupation', $this->fathers_occupation])->andFilterWhere(['like', 'fathers_employer', $this->fathers_employer])->andFilterWhere(['like', 'fathers_citizenship', $this->fathers_citizenship])->andFilterWhere(['like', 'fathers_religion', $this->fathers_religion])->andFilterWhere(['like', 'fathers_email', $this->fathers_email])->andFilterWhere(['like', 'mothers_name', $this->mothers_name])->andFilterWhere(['like', 'mothers_occupation', $this->mothers_occupation])->andFilterWhere(['like', 'mothers_employer', $this->mothers_employer])->andFilterWhere(['like', 'mothers_citizenship', $this->mothers_citizenship])->andFilterWhere(['like', 'mothers_religion', $this->mothers_religion])->andFilterWhere(['like', 'mothers_email', $this->mothers_email])->andFilterWhere(['like', 'guardians_name', $this->guardians_name])->andFilterWhere(['like', 'guardians_profile_image', $this->guardians_profile_image])->andFilterWhere(['like', 'guardians_address', $this->guardians_address])->andFilterWhere(['like', 'guardians_relation_to_student', $this->guardians_relation_to_student])->andFilterWhere(['like', 'guardians_occupation', $this->guardians_occupation])->andFilterWhere(['like', 'guardians_employer', $this->guardians_employer])->andFilterWhere(['like', 'previous_school_name', $this->previous_school_name])->andFilterWhere(['like', 'previous_school_description', $this->previous_school_description])->andFilterWhere(['like', 'previous_school_address', $this->previous_school_address])->andFilterWhere(['like', 'previous_school_teacher_in_charge', $this->previous_school_teacher_in_charge])->andFilterWhere(['like', 'previous_school_principal', $this->previous_school_principal]); //$query->andFilterWhere(['not'],['status' => 2]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getStudent() { return $this->hasOne(StudentForm::className(), ['id' => 'student_id']); }
/** * Finds the StudentForm model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return StudentForm the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = StudentForm::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
</div> </div> <?php } ?> <div class="row"> <div class="col-lg-4 col-md-4 col-sm-12"> <?php echo $form->field($model, 'sy_id', ['inputTemplate' => '<label style="padding: 0; color: #555; font-weight: 600;">School Year</label>{input}', 'inputOptions' => ['class' => 'form-control pva-form-control']])->dropDownList($listData2, ['id', 'sy'])->label(false); ?> </div> </div> <div class="row"> <div class="col-lg-6 col-md-6 col-sm-12"> <?php echo $model->isNewRecord ? $form->field($model, 'student_id', ['inputTemplate' => '<label style="padding: 0; color: #555; font-weight: 600;">Student</label>{input}', 'inputOptions' => ['class' => 'form-control pva-form-control']])->widget(Select2::classname(), ['data' => ArrayHelper::map(StudentForm::find()->orderBy(['first_name' => SORT_ASC])->where(['!=', 'status', 2])->all(), 'id', function ($model) { return implode(' ', [$model->first_name, $model->middle_name, $model->last_name]); }), 'language' => 'en', 'options' => ['id' => 'auto-suggest', 'placeholder' => 'Select Student', 'class' => 'form-control pva-form-control'], 'size' => 'md', 'pluginOptions' => ['allowClear' => true], 'pluginEvents' => ['change' => "\n function(){\n if(\$('#auto-suggest').val() === ''){\n console.log('empty');\n \$('.tiny.image').attr('src', '/proverbs/uploads/ui/user-blue.svg');\n \$('#header-label').html(' ');\n \$('#header-content').html(' ');\n \$('#meta-content').html(' ');\n \$('#left-content').html(' ');\n \$('#right-content').addClass('hidden');\n }else {\n \$.ajax({\n type: 'POST',\n url: {$card_url} + JSON.stringify({sid:\$('#auto-suggest').val(),}),\n contentType: 'application/json; charset=utf-8',\n dataType: 'json',\n success: function(data){\n\n \$('#header-label').html('ID# ' + '<strong>' + data.sid + '</strong>');\n \$('#header-content').html(data.name);\n \$('#meta-content').html(data.nick);\n \$('#left-content').html(data.level);\n\n if(data.spd === 0){\n \$('#right-content').removeClass('hidden');\n }\n\n if(data.img !== 'empty'){\n \$('.tiny.image').attr('src', data.img);\n }else {\n \$('.tiny.image').attr('src', '/proverbs/uploads/ui/user-blue.svg');\n }\n\n \$.post('" . Yii::$app->urlManager->createUrl('enroll/grade-level?id=') . "'+parseInt(\$('#auto-suggest').val()), function(data){\n \$('select#enrolledform-grade_level_id').val(data);\n \$.post('" . Yii::$app->urlManager->createUrl('enroll/section?id=') . "'+parseInt(\$('#enrolledform-grade_level_id').val()), function(data){\n \$('#enrolledform-section_id').find('option').remove();\n \$('#enrolledform-section_id').each(function(){\n \$(this).append(data);\n });\n });\n });\n }\n });\n }\n }\n "]])->label(false) : ''; ?> </div> </div> <div class="row"> <div class="col-lg-4 col-md-4 col-sm-12"> <?php echo $form->field($model, 'grade_level_id', ['inputTemplate' => '<label style="padding: 0; color: #555; font-weight: 600;">Grade Level</label>{input}', 'inputOptions' => ['class' => 'form-control pva-form-control']])->dropDownList($listData, ['onchange' => "\n level = function(){\n \$('#left-content').html(\$('#enrolledform-grade_level_id').find('option:selected').text());\n },\n \$.post('" . Yii::$app->urlManager->createUrl('enroll/section?id=') . "'+parseInt(\$('#enrolledform-grade_level_id').val()), function(data){\n level();\n \$('#enrolledform-section_id').find('option').remove();\n \$('#enrolledform-section_id').each(function(){\n \$(this).append(data);\n });\n });\n "])->label(false); ?> </div> </div> <div class="row"> <div class="col-lg-4 col-md-4 col-sm-12"> <?php
public function countStudents() { $count = count(StudentForm::find()->where(['status' => 1])->all()); return $count; }
public function getApplicantLastName($id) { $student = $this->hasOne(StudentForm::className(), ['id' => 'applicant_id']); return $student['last_name']; }