/** * Fetch * * @param string $uuid * @param bool $minimal * @return Doctrine_Record $rec */ protected function air_fetch($uuid, $minimal = false) { $q = Doctrine_Query::create()->from('SrcExport se'); $q->where('se.se_email_id = ?', $this->parent_rec->email_id); $q->leftJoin('se.CreUser cu'); $q->leftJoin('se.UpdUser uu'); SrcExport::joinRelated($q, 'se'); return $q->fetchOne(); }
/** * Joins to xid relations * * @param AIR2_Query $q * @param string $alias */ public static function joinRelated($q, $alias) { $a = $alias ? "{$alias}." : ""; SrcExport::setupRelated(); $q->leftJoin("{$a}Bin WITH {$a}se_ref_type = ?", self::$REF_TYPE_BIN); $q->leftJoin("{$a}Source WITH {$a}se_ref_type = ?", self::$REF_TYPE_SOURCE); $q->leftJoin("{$a}SrcResponseSet xidsrs WITH {$a}se_ref_type = ?", self::$REF_TYPE_RESPONSE); $q->leftJoin("xidsrs.Source xidsrssrc"); }