public function getClients($id) { $vendedor = Vendedor::find($id); $client = Client::select('name', 'telephone')->with('vendedor')->where('vendedor_id', '=', $id)->get(); //dd($clients->toArray()); return view("vendedores.clients")->with(array('vendedor' => $vendedor, 'client' => $client)); return redirect()->back(); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Vendedor::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(['telefonoVendedor' => $this->telefonoVendedor]); $query->andFilterWhere(['like', 'rutVendedor', $this->rutVendedor])->andFilterWhere(['like', 'nombreVendedor', $this->nombreVendedor]); return $dataProvider; }