mysql - 将别名 Mysql 转换为 cakePHP find 语句

Question

请帮我将此查询转换为 cakePHP find 语句 --

mysql> select auctions.id, auctions.price, products.target_price, (auctions.price / products.target_price) as target_ratio FROM auctions LEFT JOIN products ON auctions.product_id = products.id ORDER BY target_ratio DESC;

特别是，我很难让这部分工作:

 (auctions.price / products.target_price) as target_ratio

谢谢!

Answer 1

对于比率部分，您应该使用 Virtual Fields .
如果您的模型具有belongsTo 或hasOne 关系，则连接应该自动完成，否则您可以 join them manually .