[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

Code:

function get_children($node) {

        // get children by getting descendants with count and limit that to 1

        // De-reference some vars for readability

        $lcol = $this->options['left_colname'];

        $rcol = $this->options['right_colname'];



        // only add selections if not overridden

        if(empty($node->db->ar_select))

        {

            $node->select('*');

        }

        else

        {

            // ensure these are selected

            $node->select("id, $lcol, $rcol");

        }

        // DMZ won't add the table name to expressions with parentheses

        $node->select('(COUNT(parent.id)-1) as tree_depth');



        // Isolate the dependants of the parent which are 1 level away

        $node->db->from("{$node->table} as parent");

        

        // Only descendants, parent node not included

        $node->where("{$lcol} >", "parent.{$lcol}", FALSE);

        $node->where("{$lcol} <", "parent.{$rcol}", FALSE);

      

        // Only for the parents part of the tree  

        $node->where("{$lcol} >", $node->$lcol);

        $node->where("{$rcol} <", $node->$rcol);

                

        $node->group_by("id");

        $node->having("tree_depth =",1); // DMZ won't add the table name to unknown columns

        $node->order_by($lcol);

        

        // Run query

        $node->get();

   }

Code:

// filter on 'foo'

$items->like('foo', 'bar')->get_children($parent_item);

// limit column selection

$items->select('foo')->get_children($parent_item);

Code:

$node->where("{$lcol} > ", "parent.{$lcol}", FALSE);

$node->where("{$lcol} < ", "parent.{$rcol}", FALSE);

$node->where("{$lcol} >", $node->$lcol);

$node->where("{$rcol} <", $node->$rcol);

Code:

WHERE apn_pages.lft >parent.lft

AND apn_pages.lft  '9'

AND `apn_pages`.`rgt` < '12'

Code:

$node->where("{$lcol} > ", " parent.{$lcol}", FALSE);

$node->where("{$lcol} < ", " parent.{$rcol}", FALSE);

$node->where("{$lcol} >", $node->$lcol);

$node->where("{$rcol} <", $node->$rcol);

Code:

WHERE apn_pages.lft > parent.lft

AND apn_pages.lft < parent.rgt

AND `apn_pages`.`lft` > '9'

AND `apn_pages`.`rgt` < '12'

Code:

// in extension

function something_cool($object, $param) {

    // store the current time for tracking

    $object->_my_extension_start_time = time();

    ...