/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Tuitionfees::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('tuitionfeeScholar'); $query->andFilterWhere([ 'tuitionfee_id' => $this->tuitionfee_id, 'tuitionfee_scholar_id' => $this->tuitionfee_scholar_id, 'tuitionfee_amount' => $this->tuitionfee_amount, 'tuitionfee_dateOfEnrollment' => $this->tuitionfee_dateOfEnrollment, 'tuitionfee_dateOfPayment' => $this->tuitionfee_dateOfPayment, ]); $query->andFilterWhere(['like', 'scholars.scholar_lastName', $this->tuitionfee_scholar_lastName]) ->andFilterWhere(['like', 'scholars.scholar_firstName', $this->tuitionfee_scholar_firstName]) ->andFilterWhere(['like', 'scholars.scholar_middleName', $this->tuitionfee_scholar_middleName]) ->andFilterWhere(['like', 'tuitionfee_paidStatus', $this->tuitionfee_paidStatus]); return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getTuitionfees() { return $this->hasMany(Tuitionfees::className(), ['tuitionfee_scholar_id' => 'scholar_id']); }
/** * Finds the Tuitionfees model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Tuitionfees the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Tuitionfees::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
/* @var $this yii\web\View */ /* @var $searchModel frontend\models\GradeSearch */ /* @var $dataProvider yii\data\ActiveDataProvider */ $this->params['breadcrumbs'][] = $this->title; ?> <div class="grades-index"> <?php // echo $this->render('_search', ['model' => $searchModel]); ?> <?php echo'<table width=100% border=2><tr><td><h3><center>Tuition Fee Amount</center></h3></td><td><h3><center>Term No.</center></h3></td><td><h3><center>Date of Enrollment</center></h3></td><td><h3><center>Date of Payment</center></h3></td><td><h3><center>Status</center></h3></td></tr>'; $users = User::find()->all(); $scholars = Scholars::find()->all(); $tuitions = Tuitionfees::find()->all(); $username=Yii::$app->user->identity->username; foreach($users as $ctr){ if($ctr->username==$username){ foreach($scholars as $scholarctr){ foreach($tuitions as $tuition){ if($scholarctr->scholar_user_id==$ctr->id && $tuition->tuitionfee_scholar_id==$scholarctr->scholar_user_id){ echo'<tr><td><h4><center>'.$tuition->tuitionfee_amount.'<br></center></h4></td><td><h4><center>'.$tuition->tuitionfees_term.'<br></center></h4></td><td><h4><center>'.$tuition->tuitionfee_dateOfEnrollment.'</center></h4></td><td><h4><center>'.$tuition->tuitionfee_dateOfPayment.'</center></h4></td><td><h4><center>'.$tuition->tuitionfee_paidStatus.'</center></h4></td></tr>'; }
/** * @return \yii\db\ActiveQuery */ public function getBenefitTuitionfee() { return $this->hasOne(Tuitionfees::className(), ['tuitionfee_id' => 'benefit_tuitionfee_id']); }
/** * @return \yii\db\ActiveQuery */ public function getCompileTuitionfee() { return $this->hasOne(Tuitionfees::className(), ['tuitionfee_id' => 'compile_tuitionfee_id']); }