adding a method to the nested set - doctrine-user

Message from discussion adding a method to the nested set
Received-SPF: neutral (google.com: 64.98.42.197 is neither permitted nor denied by best guess record for domain of jphi...@noatak.com) client-ip=64.98.42.197;
From: "J. Philip" <jphi...@noatak.com>
To: <doctrine-user@googlegroups.com>
Subject: RE: [doctrine-user] adding a method to the nested set
Date: Fri, 3 Jul 2009 15:27:19 -0800
Message-ID: <41ECD43C4A0D409F9E789FDF9C0A0597@dogtecass>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
In-Reply-To: <3ce1e09f-1823-4d64-9743-847729039...@x3g2000yqa.googlegroups.com>
Importance: Normal

You can derive a class MyNestedSet from nested set and add your own
methods in it.

Add a behavior MyNestedSetBehavior derived from
Doctrine_Template_NestedSet and override the setup method and relpace 
$this->_table->setOption('treeImpl', 'NestedSet'); with
$this->_table->setOption('treeImpl', 'MyNestedSet');

After, you replace actAs : [NestedSet] with actAs :
[MyNestedSetBehavior]

I have not tried it but it should work.

Note that if you just want to add an orderBy clause, you should be able
to do it by calling the setBaseQuery($q) method of the Tree just before
you call the getDescendants methos. (Where $q contains the orderBy
clause)


-----Original Message-----
From: doctrine-user@googlegroups.com
[mailto:doctrine-user@googlegroups.com] On Behalf Of crash3k
Sent: Friday, July 03, 2009 10:57 AM
To: doctrine-user
Subject: [doctrine-user] adding a method to the nested set



Hi,

I've just started lerning Doctrine and Symfony
and now I want to add a method to the nested
set-class of Doctrine but I really don't know
how to implement it.

So... here's the method a want to add:
(As you can see it's just the "getDescendants"-method
with an option to sort the result by a specified column)


public function getDescendantsSorted($depth = null, $includeNode =
false, $orderBy = '', $orderType = 'ASC') {
  $baseAlias = $this->_tree->getBaseAlias();
  $q = $this->_tree->getBaseQuery();
  $params = array($this->record->get('lft'), $this->record->get
('rgt'));

  if ($includeNode) {
    $q->addWhere("$baseAlias.lft >= ? AND $baseAlias.rgt <= ?",
$params)->addOrderBy("$baseAlias.lft asc");
  } else {
    $q->addWhere("$baseAlias.lft > ? AND $baseAlias.rgt < ?", $params)-
>addOrderBy("$baseAlias.lft asc");
  }

  if ($depth !== null) {
    $q->addWhere("$baseAlias.level <= ?", $this->record['level'] +
$depth);
  }

  if ($orderBy != "")
    $q->orderBy("$baseAlias.$orderBy $orderType");

  $q = $this->_tree->returnQueryWithRootId($q, $this->getRootValue());

  $result = $q->execute();

  if (count($result) <= 0) {
    return false;
  }

  return $result;
}


So is there a way of loading this method into the
given nested set class?


Thanks in advance!


Greetings,
CRaSH3k