<?php


class subsidiaryActions extends sfActions
{
 
  
  public function executeIndex(sfWebRequest $request)
  {
          $query = Doctrine::getTable('Page')
                        ->createQuery('n')
						->innerJoin('n.Category c')
						->where('c.parent_id=?',10)
						->execute();
		$this->departments = $query;
		
     
  }
    public function executeShow(sfWebRequest $request)
  {
       $query = Doctrine::getTable('Page')
                        ->createQuery('n')
						->innerJoin('n.Category c')
						->where('c.parent_id=?',10)
						->execute();
		$this->departments = $query;

		
        $this->page = Doctrine::getTable("Page")->find($request->getParameter('id')); 		
     
  }
  
}


?>