magento - Magento 如何在集合中使用封闭的 AND & OR 条件

Question

     select * from quote where created < '2020-05-12' and (((is_offer = 0 OR (is_offer is null and is_active = 1)) and
        (cart_status is NULL)) OR cart_status = 3) and status='completed';

如何使用 magento 集合模型编写此查询。已经尝试过但不知道这个(((is_offer = 0 OR (is_offer is null and is_active = 1)) and (cart_status is NULL)) OR cart_status = 3)

提前致谢。

标签： magento