/** * Query * * @param array $args * @return Doctrine_Query $q */ protected function air_query($args = array()) { $q = parent::air_query($args); $src_id = $this->parent_rec->src_id; $outs = "select sout_out_id from src_outcome where sout_src_id={$src_id}"; $q->addWhere("o.out_id in ({$outs})"); return $q; }
/** * Restrict to org-projects * * @param array $args * @return Doctrine_Query $q */ protected function air_query($args = array()) { $q = parent::air_query($args); $oid = $this->parent_rec->org_id; $prjs = "select porg_prj_id from project_org where porg_org_id={$oid}"; $outs = "select pout_out_id from prj_outcome where pout_prj_id in ({$prjs})"; $q->addWhere("o.out_id in ({$outs})"); return $q; }