editor PHP MJOIN bug
editor PHP MJOIN bug
Lets say we have the following PHP code
Mjoin::inst( 'user_acl' )
->link( 'users.id', 'user_acl.user_id')
->fields(
Field::inst('user_acl.access'),
Field::inst('secties.naam')
)
->leftJoin('secties', 'secties.id', '=', 'user_acl.sectie_id')
->where('user_acl.project_id', PRJinfo['id'])
this results in the following query:
SELECT DISTINCT `users`.`id` as 'dteditor_pkey', `user_acl`.`access` as 'user_acl.access', `secties`.`naam` as 'secties.naam' FROM `users` users LEFT JOIN `secties` ON `secties`.`id` = `user_acl`.`sectie_id` JOIN `user_acl` ON `user_acl`.`user_id` = `users`.`id` WHERE `user_acl`.`project_id` = :where_0 AND `users`.`id` IN (:wherein1, :wherein2)
But this should be different, the join should come before the leftjoin
SELECT DISTINCT `users`.`id` as 'dteditor_pkey', `user_acl`.`access` as 'user_acl.access', `secties`.`naam` as 'secties.naam' FROM `users` users
JOIN `user_acl` ON `user_acl`.`user_id` = `users`.`id`
LEFT JOIN `secties` ON `secties`.`id` = `user_acl`.`sectie_id`
version:
datatables.net/editor-php 2.4.0 PHP server-side libraries for Editor