/**
* 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);
}
/**
* Joins a ProjectActivity 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}." : "";
ProjectActivity::setupRelated();
$q->leftJoin("{$a}Organization WITH {$a}pa_ref_type = ?", self::$REF_TYPE_ORG);
$q->leftJoin("{$a}Inquiry WITH {$a}pa_ref_type = ?", self::$REF_TYPE_INQ);
}
/**
* 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");
}
