Notes

public function search($params)
{
$query = MasterLender::find();

// add conditions that should always apply here

$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;
}

// grid filtering conditions
$query->andFilterWhere([
'purchase_lenderid' => $this->purchase_lenderid,
'purchase_lenderstate' => $this->purchase_lenderstate,
'purchase_lenderzip' => $this->purchase_lenderzip,
'created_by' => $this->created_by,
'created_on' => $this->created_on,
'modified_by' => $this->modified_by,
'modified_on' => $this->modified_on,
'status' => $this->status,
]);

$query->andFilterWhere(['like', 'purchase_lendername', $this->purchase_lendername])
->andFilterWhere(['like', 'purchase_lendernumber', $this->purchase_lendernumber])
->andFilterWhere(['like', 'purchase_lenderaddress', $this->purchase_lenderaddress])
->andFilterWhere(['like', 'purchase_lendercity', $this->purchase_lendercity])
->andFilterWhere(['like', 'purchase_lenderphone', $this->purchase_lenderphone])
->andFilterWhere(['like', 'book_forusedcarvalue', $this->book_forusedcarvalue]);

return $dataProvider;
}
above function work properly but below are not working we need to add perform join in below function
public function search($params)
{
$query = LenderMapping::find();
/* Get Below selected location id form session */
$selectedCurrentlocationData = TblLocation::locationNameId(Yii::$app->session->get('location_id'));

/* Get all lender mapped with selected location id */
$query ->select([
'master_lender.purchase_lenderid as purchase_lenderid',
'master_lender.purchase_lendername as purchase_lendername',
'master_lender.purchase_lendernumber as purchase_lendernumber',
'master_lender.purchase_lenderaddress as purchase_lenderaddress',
'master_lender.book_forusedcarvalue as book_forusedcarvalue',
'master_lender.status as status',
'lender_mapping.id as id',
'lender_mapping.location_id as location_id',
'lender_mapping.lenders_id as lenders_id'
])
->join('LEFT JOIN', 'master_lender',
'master_lender.purchase_lenderid = lender_mapping.lenders_id')
->where(['lender_mapping.location_id' => $selectedCurrentlocationData['location_Id']]);


// add conditions that should always apply here

$dataProvider = new ActiveDataProvider([
'query' => $query,
]);

$this->load($params);

if (!$this->validate()) {
return $dataProvider;
}

// grid filtering conditions
$query->andFilterWhere([
'master_lender.purchase_lenderid' => $this->purchase_lenderid,
'master_lender.purchase_lenderstate' => $this->purchase_lenderstate,
'master_lender.purchase_lenderzip' => $this->purchase_lenderzip,
'status' => $this->status,
]);

$query->andFilterWhere(['like', 'master_lender.purchase_lendername', $this->purchase_lendername])
->andFilterWhere(['like', 'master_lender.purchase_lendernumber', $this->purchase_lendernumber])
->andFilterWhere(['like', 'master_lender.purchase_lenderaddress', $this->purchase_lenderaddress])
->andFilterWhere(['like', 'master_lender.book_forusedcarvalue', $this->book_forusedcarvalue]);

return $dataProvider;
}