我的項目中有一個 yii2 查詢，例如$query=Car::find() ->andFilterWhere(['in','make_id',array_filter(explode(',', $this->makes))]) ->andFilterWhere(['in','model_id',array_filter(explode(',', $this->models))]) ->andFilterWhere(['>=', 'price', $this->price_start]) ->andFilterWhere(['<=', 'price', $this->price_end]) ->andFilterWhere(['>=', ModelYear::tableName().'.year', $this->year_start]) ->andFilterWhere(['<=', ModelYear::tableName().'.year', $this->year_end]) ->andFilterWhere(['>=', 'kilometer', $this->km_start]) ->andFilterWhere(['<=', 'kilometer', $this->km_end]) ->andFilterWhere(['like', 'title', $this->title])而且我還有另一個查詢$command = $connection->createCommand("select A.id,A.make_eng,Count(B.make_id) from tbl_car_makes A,(**Can i use the first $query here**) as B where A.id=B.make_id group by A.id,A.make_eng");$data = $command->queryAll();我如何在指定位置的第二個查詢中使用第一個查詢
1 回答
繁花如伊
TA貢獻2012條經驗 獲得超12個贊
你有兩個選擇如何做到這一點。
1）可能更好的選擇是對第二個查詢也使用查詢構建器。
$query2 = (new \yii\db\Query())
->select(['A.id', 'A.make_eng', 'COUNT(B.make_id)')
->from(['A' => 'tbl_car_makes', 'B' => $query])
->where('A.id = B.make_id')
->groupBy(['A.id', 'A.make_eng']);
$data = $query2->all();
2) 另一種選擇是將第一個查詢轉換為 SQL 字符串。這種方法的問題是您將不得不處理參數。
$queryCommand = $query->createCommand();
$querySql = $queryCommand->getSql();
$command = $connection->createCommand(
"select A.id,A.make_eng,Count(B.make_id) from tbl_car_makes A,($querySql) as B where A.id=B.make_id group by A.id,A.make_eng",
$queryCommand->params
);
$data = $command->queryAll();
- 1 回答
- 0 關注
- 96 瀏覽
添加回答
舉報
0/150
提交
取消