/**
* 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']);
}
