/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Alumni::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->andFilterWhere([
'id' => $this->id,
'alumni_year_graduated' => $this->alumni_year_graduated,
'user_id' => $this->user_id,
]);
$query->andFilterWhere(['like', 'alumni_id', $this->alumni_id])
->andFilterWhere(['like', 'alumni_firstname', $this->alumni_firstname])
->andFilterWhere(['like', 'alumni_lastname', $this->alumni_lastname])
->andFilterWhere(['like', 'alumni_midinit', $this->alumni_midinit])
->andFilterWhere(['like', 'alumni_gender', $this->alumni_gender])
->andFilterWhere(['like', 'alumni_address', $this->alumni_address])
->andFilterWhere(['like', 'alumni_contactno', $this->alumni_contactno])
->andFilterWhere(['like', 'alumni_remarks', $this->alumni_remarks])
->andFilterWhere(['like', 'alumni_office_local_no', $this->alumni_office_local_no])
->andFilterWhere(['like', 'alumni_email', $this->alumni_email])
->andFilterWhere(['like', 'alumni_course', $this->alumni_course])
->andFilterWhere(['like', 'alumni_school', $this->alumni_school])
->andFilterWhere(['like', 'alumni_company', $this->alumni_company])
->andFilterWhere(['like', 'alumni_status', $this->alumni_status])
->andFilterWhere(['like', 'alumni_area', $this->alumni_area])
->andFilterWhere(['like', 'alumni_cur_work', $this->alumni_cur_work])
->andFilterWhere(['like', 'alumni_prev_work', $this->alumni_prev_work])
->andFilterWhere(['like', 'alumni_further_study', $this->alumni_further_study])
->andFilterWhere(['like', 'alumni_achievements', $this->alumni_achievements])
->andFilterWhere(['like', 'alumni_legends', $this->alumni_legends]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getAlumnis()
{
return $this->hasMany(Alumni::className(), ['user_id' => 'id']);
}
//['label' => 'Logs', 'url' => ['/logs/index']],
//['label' => 'Migration', 'url' => ['/migration/index']],
['label' => 'Testimonials', 'url' => ['/testimonials/index']],
//['label' => 'Users', 'url' => ['/user/index']],
[
'label' => 'Logout (' . Yii::$app->user->identity->username . ')',
'url' => ['/site/logout'],
'linkOptions' => ['data-method' => 'post']],
];
}else if ($roles == 'alumni'){
$userid = ArrayHelper::getValue(User::find()->where(['username' => Yii::$app->user->identity->username])->one(), 'id');
$alumniid = ArrayHelper::getValue(Alumni::find()->where(['user_id' => $userid])->one(), 'id');
$menuItems =[
['label' => 'Home', 'url' => ['/site/index']],
['label' => 'Alumni', 'url' => ['/alumni/view', 'id' => $alumniid]],
['label' => 'Event', 'url' => ['/event/index']],
['label' => 'Testimonials', 'url' => ['/testimonials/index']],
[
'label' => 'Logout (' . Yii::$app->user->identity->username . ')',
'url' => ['/site/logout'],
'linkOptions' => ['data-method' => 'post']],
/**
* Finds the Alumni model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Alumni the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Alumni::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
