editor PHP MJOIN bug

editor PHP MJOIN bug

MaikelMaikel Posts: 80Questions: 20Answers: 1
edited February 3 in Editor

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

Sign In or Register to comment.