Guest User

Untitled

a guest
Jun 20th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. $query = Doctrine_Query::create()
  2. ->from('Node n')
  3. ->orderBy('n.sort ASC, n.name ASC');
  4.  
  5. if(!empty($args['class'])) {
  6. $query->addWhere('n.class = ?', $class);
  7. }
  8.  
  9. if(!empty($args['id'])) {
  10. if(is_array($args['id'])) {
  11. $query->addWhereIn('n.id', $args['id']);
  12. } else {
  13. $query->addWhere('n.id = ?', $args['id']);
  14. }
  15. }
  16.  
  17. if(!empty($args['level']) || $args['level'] === 0) {
  18. $query->addWhere('n.level = ?', $args['level']);
  19. }
  20.  
  21. $nodes = $query->fetchArray();
Add Comment
Please, Sign In to add comment