think-orm icon indicating copy to clipboard operation
think-orm copied to clipboard

远程一对多根据关联条件查询问题

Open Chance-fyi opened this issue 3 years ago • 0 comments

这个地方驼峰为什么转下划线 生成的SQL有问题 一对一关联 一对多关联hasWhere()方法都没有转下划线 image

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`

Chance-fyi avatar May 21 '21 09:05 Chance-fyi