public function mergeAdvanced(MergeableFilter $filter, $condition, $joinType = Join::LEFT_JOIN)
{
$this->mainFilter->getQb()->join($filter->getPrimaryTable(), $filter->getPrimaryTableAlias(), $joinType, $condition);
$parts = $filter->getQb()->getSQLParts();
foreach ($parts['join'] as $join) {
$this->mainFilter->getQb()->add("join", $join, true);
}
$this->mainFilter->getQb()->andWhere($parts['where']);
}
public function __construct()
{
parent::__construct(Tbl::get('TBL_CHAT_SESSIONS', 'ChatSessionManager'), "chat_sess", "id");
$this->qb->select(new Field("*", "chat_sess"))->from(Tbl::get('TBL_CHAT_SESSIONS', 'ChatSessionManager'), "chat_sess");
}
public function __construct()
{
parent::__construct(Tbl::get('TBL_PERMISSIONS', 'UserManager'), "perms", "id");
$this->qb->select(new Field("*", $this->primaryTableAlias))->from($this->primaryTable, $this->primaryTableAlias);
}
public function __construct()
{
parent::__construct(Tbl::get('TBL_CHAT_INVITATIONS', 'ChatInvitationManager'), "inv", "id");
$this->qb->select(new Field("*", "inv"))->from(Tbl::get('TBL_CHAT_INVITATIONS', 'ChatInvitationManager'), "inv");
}
public function __construct()
{
parent::__construct(Tbl::get('TBL_USERS_PHOTOS', 'UserPhotoManager'), "up", "user_id");
$this->qb->select(new Field("*", "up"))->from(Tbl::get('TBL_USERS_PHOTOS', 'UserPhotoManager'), "up");
}
public function __construct()
{
parent::__construct(Tbl::get('TBL_CONVERSATION_MESSAGES', 'ConversationManager'), "conv_msgs", "user_id");
$this->qb->select(new Field("*"))->from($this->primaryTable, $this->primaryTableAlias);
}
public function __construct()
{
parent::__construct(Tbl::get('TBL_USERS', 'UserManager'), "users", "id");
$this->qb->select(new Field("id", $this->primaryTableAlias))->from($this->primaryTable, $this->primaryTableAlias);
}
