php - 使用 all() 的 Yii2 查询返回的数据少于预期

Question

我想用这个查询从数据库中查找所有数据：

 $dataSearch = House::find()
   ->select(["number","DATE(reg_date) AS date","((value) > 100) AS result","info"])
   ->join("INNER JOIN", Owner::tableName(), Owner::tableName().'.number_ow= '.House::tableName().'.number_ow')
   ->andWhere([House::tableName().'.number_ow'=>$house->number_ow])
   ->andFilterWhere([House::tableName().'.space'=>$space])
   ->orderBy([House::tableName().'.reg_date'=>SORT_DESC,'info'=>SORT_ASC]);


    $data = $dataSearch->asArray()->all();

如果我执行查询时all()只返回部分结果，但如果我对数据库执行原始 SQL 查询，我会得到所有结果。我不明白问题出在哪里。

这是原始 SQL：

SELECT `number`, DATE(reg_date) AS date, ((value) > 100) AS result, `info` 
FROM `ho_house` INNER JOIN `ho_owner` ON ho_owner.number_ow = oh_ho_house.number_ow 
WHERE (`ho_house`.`number_ow`=2100174106) AND (`ho_house`.`space`='m')
ORDER BY `ho_house`.`reg_date` DESC, `info`

标签： phpyii2

Answer 1

将 andWhere 替换为 Where 检查此代码

 $dataSearch = House::find()
   ->select(["number","DATE(reg_date) AS date","((value) > 100) AS result","info"])
   ->join("INNER JOIN", Owner::tableName(), Owner::tableName().'.number_ow= '.House::tableName().'.number_ow')
   ->where([House::tableName().'.number_ow'=>$house->number_ow])
   ->andFilterWhere([House::tableName().'.space'=>$space])
   ->orderBy([ClosedOperation::tableName().'.reg_date'=>SORT_DESC,'info'=>SORT_ASC]);


    $data = $dataSearch->asArray()->all();