search

e107inc / e107

e107 Bootstrap CMS (Content Management System) v2 with PHP, MySQL, HTML5, jQuery and Twitter Bootstrap. Issue Discussion Room: https://gitter.im/e107inc/e107
https://e107.org
GNU General Public License v3.0
318 stars 213 forks source link

admin-ui - Left JOIN should occur automatically when type='user' is found. #47

Open CaMer0n opened 11 years ago

CaMer0n commented 11 years ago

The author_id -> user_id connection will be a common occurrence in plugin development. The admin-ui should calculate a LEFT JOIN automatically with the e107_user table when type='user' is found in the $fields array and a custom $listQry is not found.

See: admin/upload.php and e107_plugins/faqs/admin_config.php

myovchev commented 11 years ago

As per a discussion, a roadmap for this:

  1. Fix listQry and editQry parsing to old format JOINS (array data).
  2. Fix filter query builder, add back Ajax filtering (jQuery)
  3. Clear all Prototype JS inline references, disable Prototype for backend, disable e_meta.php output for backend
  4. Add auto check on controller init - look for type=>user, use it as external user ID, check if user join is already used and if not auto-create LEFT JOIN to the user table
Moc commented 4 years ago

@CaMer0n Is this still relevant?