think-orm
think-orm copied to clipboard
远程一对多根据关联条件查询问题
这个地方驼峰为什么转下划线 生成的SQL有问题
一对一关联 一对多关联hasWhere()
方法都没有转下划线
SELECT
`UserOrder`.*,
`user_order`.*
FROM
`tb_user_order` `UserOrder`
INNER JOIN `tb_order_status` `OrderStatus` ON `UserOrder`.`ID` = `OrderStatus`.`ID`
INNER JOIN `tb_place_order_assign_manager` ON `tb_place_order_assign_manager`.`ORDER_ID` = `user_order`.`ID`
JOIN `tb_manager_user` ON `tb_manager_user`.`ID` = `tb_place_order_assign_manager`.`MANAGER_ID`
WHERE
`tb_manager_user`.`username` LIKE '%测试%'
GROUP BY
`tb_manager_user`.`ID`