models/PedidoSearch.php
/**
     * Creates data provider instance with search query applied
     *
     * @param array $params
     *
     * @return ActiveDataProvider
     */
Creates data provider instance with search query applied
@param array $params


Creates data provider instance with search query applied @param array $params
public function search($params)
    {
        $query = Pedido::find()->join('INNER JOIN',
                                      'Producto',
                                      'Pedido.ProductoID = Producto.ProductoID');
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);
        $this->load($params);
        if (!$this->validate()) {
            return $dataProvider;
        }
        $query->andFilterWhere([
            'PedidoID' => $this->PedidoID,
            'UnidadXLote' => $this->UnidadXLote,
            'FechaInicio' => $this->FechaInicio,
            'FechaFin' => $this->FechaFin,
            'Status' => $this->Status,
            'FechaStatusFin' => $this->FechaStatusFin,
        ])->andFilterWhere(['like', 'Nombre', $this->ProductoID]);
        return $dataProvider;
    }
public function search ( $ params ) { $ query = Pedido :: find ( ) -> join ( 'INNER JOIN' , 'Producto' , 'Pedido.ProductoID = Producto.ProductoID' ) ; $ dataProvider = new ActiveDataProvider ( [ 'query' => $ query , ] ) ; $ this -> load ( $ params ) ; if ( ! $ this -> validate ( ) ) { return $ dataProvider ; } $ query -> andFilterWhere ( [ 'PedidoID' => $ this -> PedidoID , 'UnidadXLote' => $ this -> UnidadXLote , 'FechaInicio' => $ this -> FechaInicio , 'FechaFin' => $ this -> FechaFin , 'Status' => $ this -> Status , 'FechaStatusFin' => $ this -> FechaStatusFin , ] ) -> andFilterWhere ( [ 'like' , 'Nombre' , $ this -> ProductoID ] ) ; return $ dataProvider ; }
Creates data provider instance with search query applied
 @param array $params
Creates data provider instance with search query applied @param array $params
// add conditions that should always apply here // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); // grid filtering conditions