/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Scholars::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('scholarSchool');
$query->andFilterWhere([
'scholar_id' => $this->scholar_id,
// 'scholar_school_id' => $this->scholar_school_id,
]);
$query->andFilterWhere(['like', 'scholar_first_name', $this->scholar_first_name])
->andFilterWhere(['like', 'scholar_last_name', $this->scholar_last_name])
->andFilterWhere(['like', 'scholar_middle_initial', $this->scholar_middle_initial])
->andFilterWhere(['like', 'scholar_course', $this->scholar_course])
->andFilterWhere(['like', 'scholar_email', $this->scholar_email])
->andFilterWhere(['like', 'schools.school_name', $this->scholar_school_id]);
return $dataProvider;
}
/**
* Creates a new Uploadedforms model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$username=Yii::$app->user->identity->username;
$users = User::find()->all();
$scholars = Scholars::find()->all();
$model = new Uploadedforms();
foreach($users as $user){
foreach($scholars as $scholar){
if($user->username==$username&&$user->id==$scholar->scholar_id){
$model->uploaded_scholar_id=$scholar->scholar_id;
if ($model->load(Yii::$app->request->post())) {
$fileName = $model->fileName.$model->uploaded_scholar_id;
$model->file = UploadedFile::getInstance($model,'file');
if($model->file != null)
{
$model->file->saveAs('uploads/'.$fileName.'.'.$model->file->extension);
$model->uploadedForm = 'uploads/'.$fileName.'.'.$model->file->extension;
}
$model->save();
return $this->redirect(['index', 'id' => $model->id]);
} else {
return $this->render('create', [
'model' => $model,
]);
}
}
}
}
}
/**
* Creates a new Parttimejobs model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$username=Yii::$app->user->identity->username;
$users = User::find()->all();
$scholars = Scholars::find()->all();
$model = new Parttimejobs();
foreach($users as $user){
foreach($scholars as $scholar){
if($user->username==$username&&$user->id==$scholar->scholar_id){
$model->job_scholar_id=$scholar->scholar_id;
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect(['index', 'id' => $model->id]);
} else {
return $this->render('create', [
'model' => $model,
]);
}
}
}
}
}
/**
* Lists all Allowance models.
* @return mixed
*/
public function actionIndex()
{
$username=Yii::$app->user->identity->username;
$users = User::find()->all();
$scholars = Scholars::find()->all();
$deductions = Deductions::find()->all();
$refunds = Refunds::find()->all();
$model = new Allowance();
foreach($users as $user){
foreach($scholars as $scholar){
foreach($deductions as $deduction){
foreach($refunds as $refund){
if($user->username==$username&&$user->id==$scholar->scholar_id){
$model->allowance_scholar_id=$scholar->scholar_id;
$searchModel = new AllowanceSearch($model);
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', [
'searchModel' => $searchModel,
'dataProvider' => $dataProvider,
]);
}
}
}
}
}
}
/**
* Lists all Grades models.
* @return mixed
*/
public function actionIndex()
{
$grades = Grades::find()->all();
$schools = Schools::find()->all();
$users = User::find()->all();
$scholars = Scholars::find()->all();
return $this->render('index', array('users' => $users, 'scholars' => $scholars, 'schools' => $schools, 'grades' => $grades));
}
/**
* Lists all Allowance models.
* @return mixed
*/
public function actionIndex()
{
$schools = Schools::find()->all();
$users = User::find()->all();
$scholars = Scholars::find()->all();
$allowances = Allowance::find()->all();
$benefits = Benefit::find()->all();
return $this->render('index', array('users' => $users, 'scholars' => $scholars, 'schools' => $schools, 'allowances' => $allowances, 'benefits' => $benefits));
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Scholars::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('scholarSchool');
$query->andFilterWhere(['scholar_id' => $this->scholar_id, 'scholar_yearLevel' => $this->scholar_yearLevel, 'scholar_contactNum' => $this->scholar_contactNum, 'scholar_cashCardNum' => $this->scholar_cashCardNum]);
$query->andFilterWhere(['like', 'scholar_firstName', $this->scholar_firstName])->andFilterWhere(['like', 'scholar_lastName', $this->scholar_lastName])->andFilterWhere(['like', 'scholar_middleName', $this->scholar_middleName])->andFilterWhere(['like', 'scholar_gender', $this->scholar_gender])->andFilterWhere(['like', 'scholar_address', $this->scholar_address])->andFilterWhere(['like', 'scholar_course', $this->scholar_course])->andFilterWhere(['like', 'scholar_email', $this->scholar_email])->andFilterWhere(['like', 'scholar_school_area', $this->scholar_school_area])->andFilterWhere(['like', 'schools.school_name', $this->scholar_school_id]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getRefundScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'refund_scholar_id']);
}
use common\models\Scholars;
use common\models\Schools;
use yii\helpers\ArrayHelper;
use kartik\select2\Select2;
/* @var $this yii\web\View */
/* @var $model common\models\Allowance */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="allowance-form">
<?php $form = ActiveForm::begin(); ?>
<?= $form->field($model,'allowance_scholar_id')->widget(Select2::classname(),
[
'data'=>ArrayHelper::map(Scholars::find()->all(),'scholar_id','scholar_id','scholar_lastName'),
'language'=>'en',
'options'=>['placeholder'=>'Select Scholar ID'],
'pluginOptions'=>['allowClear'=>true],
]) ?>
<?= $form->field($model, 'allowance_amount')->textInput() ?>
<?= $form->field($model, 'allowance_remark')->textInput(['maxlength' => true]) ?>
<?= $form->field($model,'allowance_school_id')->widget(Select2::classname(),
[
'data'=>ArrayHelper::map(Schools::find()->all(), 'School_id','school_name'),
'language'=>'en',
'options'=>['placeholder'=>'Select School Name'],
'pluginOptions'=>['allowClear'=>true],
/**
* Finds the Scholars model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Scholars the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Scholars::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getGradeScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'grade_scholar_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getFailScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'fail_scholar_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getScholars()
{
return $this->hasMany(Scholars::className(), ['scholar_school_id' => 'school_id']);
}
/* @var $this yii\web\View */
/* @var $model common\models\Grades */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="grades-form">
<?php
$form = ActiveForm::begin(['options' => ['enctype' => 'multipart/form-data']]);
$test = ArrayHelper::map(Scholars::findBySql('SELECT * FROM scholars WHERE scholar_id=2')->all(), 'scholar_id', 'scholar_lastName');
$test2 = ArrayHelper::map(Scholars::findBySql('SELECT * FROM scholars WHERE scholar_id=3')->all(), 'scholar_id', 'scholar_lastName');
$test3 = array_values($test2)[0] . ' ' . array_values($test)[0];
?>
<?php
echo $form->field($model, 'grade_scholar_id')->widget(Select2::classname(), ['data' => ArrayHelper::map(Scholars::find()->all(), 'scholar_id', 'scholar_id', 'scholar_lastName'), 'language' => 'en', 'options' => ['placeholder' => 'Select Scholar ID'], 'pluginOptions' => ['allowClear' => true]]);
?>
<?php
echo $form->field($model, 'grade_schoolYear')->textInput();
?>
<?php
echo $form->field($model, 'grade_Term')->textInput();
?>
<?php
echo $form->field($model, 'grade_value')->textInput();
?>
<div class="form-group">
ArrayHelper::map(Scholars::find()->all(),'scholar_id','scholar_id'),
['prompt'=>'Select Scholar ID']
) ?>
<?= $form->field($model, 'compile_scholar_lastName')->dropDownList(
ArrayHelper::map(Scholars::find()->all(),'scholar_lastName','scholar_lastName'),
['prompt'=>'Select Scholar Last Name']
) ?>
<?= $form->field($model, 'compile_scholar_firstName')->dropDownList(
ArrayHelper::map(Scholars::find()->all(),'scholar_firstName','scholar_firstName'),
['prompt'=>'Select Scholar First Name']
) ?>
<?= $form->field($model, 'compile_scholar_middleName')->dropDownList(
ArrayHelper::map(Scholars::find()->all(),'scholar_middleName','scholar_middleName'),
['prompt'=>'Select Scholar Middle Name']
) ?>
<?= $form->field($model, 'compile_school_name')->dropDownList(
ArrayHelper::map(Schools::find()->all(),'school_name','school_name'),
['prompt'=>'Select School Name']
) ?>
<?= $form->field($model, 'compile_school_area')->dropDownList(
ArrayHelper::map(Schools::find()->all(),'school_area','school_area'),
['prompt'=>'Select School Area']
) ?>
<?= $form->field($model, 'compile_pendingPaymentToSchool')->dropDownList([ 'Yes' => 'Yes', 'No' => 'No', ], ['prompt' => '']) ?>
/**
* @return \yii\db\ActiveQuery
*/
public function getBenefitScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'benefit_scholar_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getJobScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'job_scholar_id']);
}
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
use common\models\Scholars;
/* @var $this yii\web\View */
/* @var $model common\models\Grades */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="grades-form">
<?php $form = ActiveForm::begin(); ?>
<?= $form->field($model, 'grade_scholar_id')->dropDownList(
ArrayHelper::map(Scholars::find()->all(),'scholar_id','scholar_id'),
['prompt'=>'Select Scholar']
) ?>
<?= $form->field($model, 'grade_school_year')->textInput(['maxlength' => true]) ?>
<?= $form->field($model, 'grade_school_term')->textInput(['maxlength' => true]) ?>
<?= $form->field($model, 'grade_value')->textInput(['maxlength' => true]) ?>
<div class="form-group">
<?= Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?>
</div>
<?php ActiveForm::end(); ?>
/**
* @return \yii\db\ActiveQuery
*/
public function getCompileScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'compile_scholar_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getTuitionScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'tuition_scholar_id']);
}
/* @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>';
}
?>
<?php
echo $form->field($model, 'compile_scholar_id')->dropDownList(ArrayHelper::map(Scholars::find()->all(), 'scholar_id', 'scholar_id'), ['prompt' => 'Select Scholar ID']);
?>
<?php
echo $form->field($model, 'compile_scholar_lastName')->dropDownList(ArrayHelper::map(Scholars::find()->all(), 'scholar_lastName', 'scholar_lastName'), ['prompt' => 'Select Scholar Last Name']);
?>
<?php
echo $form->field($model, 'compile_scholar_firstName')->dropDownList(ArrayHelper::map(Scholars::find()->all(), 'scholar_firstName', 'scholar_firstName'), ['prompt' => 'Select Scholar First Name']);
?>
<?php
echo $form->field($model, 'compile_scholar_middleName')->dropDownList(ArrayHelper::map(Scholars::find()->all(), 'scholar_middleName', 'scholar_middleName'), ['prompt' => 'Select Scholar Middle Name']);
?>
<?php
echo $form->field($model, 'compile_school_name')->dropDownList(ArrayHelper::map(Schools::find()->all(), 'school_name', 'school_name'), ['prompt' => 'Select School Name']);
?>
<?php
echo $form->field($model, 'compile_school_area')->dropDownList(ArrayHelper::map(Schools::find()->all(), 'school_area', 'school_area'), ['prompt' => 'Select School Area']);
?>
<?php
echo $form->field($model, 'compile_pendingPaymentToSchool')->dropDownList(['Yes' => 'Yes', 'No' => 'No'], ['prompt' => '']);
?>
<?php
/**
* @return \yii\db\ActiveQuery
*/
public function getScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'uploaded_scholar_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getAllowanceScholar()
{
return $this->hasOne(Scholars::className(), ['scholar_id' => 'allowance_scholar_id']);
}
