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.');
}
}
public function searchEnrolled($params)
{
$pageSize = Yii::$app->params['pageSize'];
$query = EnrolledForm::find()->joinWith(['gradeLevel' => function ($query) {
$query->from(['gradeLevelName' => 'grade_level']);
}])->joinWith(['sy' => function ($query) {
$query->from(['sy' => 'school_year']);
}]);
/*->joinWith(['relation name' => function($query) {
$query->from(['alias' => 'table name']);
//$query->from(['method' => 'table name']);
}])*/
$dataProvider->sort->attributes['sy_id'] = ['asc' => ['sy_id' => SORT_ASC], 'desc' => ['sy_id' => SORT_DESC]];
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC, 'sy_id' => 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->joinWith('method');
//$query->joinWith('relation');
$query->joinWith('gradeLevelName');
//$query->joinWith('student');
$query->andFilterWhere(['id' => $this->id, 'student_id' => $this->student_id, 'grade_level_id' => $this->grade_level_id, 'section_id' => $this->section_id, 'enrollment_status' => $this->enrollment_status, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at])->andFilterWhere(['like', 'sy.sy', $this->sy_id]);
return $dataProvider;
}
protected function findModel($id)
{
if (($model = EnrolledForm::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function countCurrentEnrolled()
{
$latest = (int) SchoolYear::find()->orderBy(['id' => SORT_DESC])->all()[0]['id'];
$count = count(EnrolledForm::find()->where(['sy_id' => $latest])->where(['enrollment_status' => 0])->all());
return $count;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getEnrolled()
{
return $this->hasOne(EnrolledForm::className(), ['id' => 'enrolled_id']);
}
protected function touchEnrolleeStatus($eid)
{
if (($enrollee = EnrolledForm::findOne($eid)) !== null) {
$enrollee->enrollment_status = 0;
$enrollee->save();
Yii::$app->session->setFlash('success2', 'Assessment saved successfully');
}
}
use app\models\ActiveRecord;
use app\models\EnrolledForm;
use yii\helpers\ArrayHelper;
use yii\bootstrap\ActiveForm;
?>
<div class="nursery-form">
<?php
$form = ActiveForm::begin();
?>
<div class="row">
<div class="container form-input-wrapper">
<div class="col-lg-4 col-md-4 col-sm-12">
<?php
echo $model->isNewRecord ? $form->field($model, 'enrolled_id')->widget(Select2::classname(), ['data' => ArrayHelper::map(EnrolledForm::find()->all(), 'id', function ($model) {
return $model->id . ' ' . $model->student->id . ' ' . $model->student->last_name . ', ' . $model->student->first_name . ' ' . $model->student->middle_name;
}), 'language' => 'en', 'options' => ['id' => 'auto-suggest', 'placeholder' => 'Enter ID #'], 'pluginOptions' => ['allowClear' => true]])->label(false) : $model->enrolled->student->id . ' ' . $model->enrolled->student->last_name . ', ' . $model->enrolled->student->first_name . ' ' . $model->enrolled->student->middle_name;
?>
</div>
<div class="col-lg-3 col-md-3 col-sm-12">
<?php
echo $form->field($model, 'grade_protection', ['inputTemplate' => '<div class="input-group"><span class="input-group-addon"><span class="dropdown-list">Protection</span></span></span>{input}</div>'])->dropDownList(['0' => 'Off', '1' => 'On'], ['default' => 'Off'])->label(false);
?>
</div>
<div class="col-lg-4 col-md-4 col-sm-12">
<?php
echo $form->field($model, 'grading_period', ['inputTemplate' => '<div class="input-group"><span class="input-group-addon subject-min-width"><span class="dropdown-list">Grading Period</span></span></span>{input}</div>'])->dropDownList(['1' => '1st Grading', '2' => '2nd Grading', '3' => '3rd Grading', '4' => '4th Grading'], ['default' => '1st Grading'])->label(false);
?>
</div>
</div>
