/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
//$query = REFERRALGIVEN::find();
$query = REFERRALGIVEN::find()->joinWith(['rEFERRAL']);
$dataProvider = new ActiveDataProvider(['query' => $query]);
/**
* Setup your sorting attributes
* Note: This is setup before the $this->load($params)
* statement below
*/
$dataProvider->setSort(['attributes' => ['GIVEN_ID', 'MEMBER_ID', 'referralName' => ['asc' => ['REFERRAL.REFERRAL_NAME' => SORT_ASC], 'desc' => ['REFERRAL.REFERRAL_NAME' => SORT_DESC], 'label' => 'Referral Name'], 'MEETING_ID']]);
if (!($this->load($params) && $this->validate())) {
//Brad
//$query->joinWith(['rEFERRAL']);
return $dataProvider;
}
$query->andFilterWhere(['GIVEN_ID' => $this->GIVEN_ID, 'MEMBER_ID' => $this->MEMBER_ID, 'REFERRAL_ID' => $this->REFERRAL_ID, 'MEETING_ID' => $this->MEETING_ID]);
$query->andFilterWhere(['like', 'GIVEN_YOUR_CARD', $this->GIVEN_YOUR_CARD])->andFilterWhere(['like', 'TOLD_THEM_YOU_WOULD_CALL', $this->TOLD_THEM_YOU_WOULD_CALL])->andFilterWhere(['like', 'COMMENTS', $this->COMMENTS]);
// filter by Referral name - Brad
// $query->joinWith(['rEFERRAL'=>function ($q) {
// $q->where('rEFERRAL.REFERRAL_NAME LIKE "%' .
// $this->referralName . '%"');
// }]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getREFERRALGIVENs()
{
return $this->hasMany(REFERRALGIVEN::className(), ['MEETING_ID' => 'MEETING_ID']);
}
/**
* Finds the REFERRALGIVEN model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return REFERRALGIVEN the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = REFERRALGIVEN::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
