/** * Query * * @param array $args * @return Doctrine_Query $q */ protected function air_query($args = array()) { $prj_id = $this->parent_rec->prj_id; $q = Doctrine_Query::create()->from('ProjectActivity pa'); $q->where('pa.pa_prj_id = ?', $prj_id); $q->leftJoin('pa.ActivityMaster a'); $q->leftJoin('pa.CreUser'); ProjectActivity::joinRelated($q, 'pa'); return $q; }