How do you cross join for an active data provider?

Yii 2.0 General Discussions
1

How do you do cross join?

I tried using joinWith on product, but I get an error saying Warehouse model has no relation with Product

Also, I’d like to add that warehouse has no relation with product. I just need them to cross join, is there a proper way to do this?




public function search($params)

    {				

        $query = Warehouse::find()->joinWith('product')

                ->select(['product_id' => 'product.id','warehouse.warehouse', 'product.category', 'product.product', 'min_stock' => 'coalesce(critical.min_stock, -1)'])

                ->leftJoin('critical', 'critical.product_id = product.id AND critical.warehouse_id = warehouse.id')

				->where(['warehouse.id' => $this->_id]);


		$this->load($params);

				

        $dataProvider = new ActiveDataProvider([

            'query' => $query,

        ]);        


        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(['category' => $this->category]);

        $query->andFilterWhere(['like', 'product', $this->product]);        


        return $dataProvider;

    }
2

I think the warehouse model needs to have a getProduct() method in order for the joinWith() to work.