コード例 #1
0
 /**
  * Joins a SrcActivity to it's external reference in a Doctrine Query.
  *
  * @param AIR2_Query $q
  * @param string  $alias
  */
 public static function joinRelated($q, $alias)
 {
     $a = $alias ? "{$alias}." : "";
     SrcActivity::setupRelated();
     $q->leftJoin("{$a}SrcResponseSet WITH {$a}sact_ref_type = ?", self::$REF_TYPE_RESPONSE);
     $q->leftJoin("{$a}Tank WITH {$a}sact_ref_type = ?", self::$REF_TYPE_TANK);
     $q->leftJoin("{$a}Organization WITH {$a}sact_ref_type = ?", self::$REF_TYPE_ORG);
     $q->leftJoin("{$a}Inquiry WITH {$a}sact_ref_type = ?", self::$REF_TYPE_INQUIRY);
     $q->leftJoin("{$a}Email WITH {$a}sact_ref_type = ?", self::$REF_TYPE_EMAIL);
 }