public function __construct(\DibiConnection $connection, \Nette\Security\User $user) { parent::__construct($connection, "group"); $this->getSelection()->removeClause("SELECT"); $this->getSelection()->leftJoin("user")->on("group.user_id = user.id")->leftJoin("membership")->on("group.id = membership.group_id")->groupBy("group.id")->select("`group`.*, count(*) AS members, user.firstname, user.lastname, COALESCE(SUM(membership.user_id={$user->id}),0) AS member"); $this->setPrimaryKey("group.id"); }
public function __construct(\DibiConnection $connection) { parent::__construct($connection, "user"); $this->getSelection()->removeClause("SELECT"); $this->getSelection()->select("user.*, login_local.registered AS local_registered, login_imap.username AS imap_username, login_facebook.facebook_id AS facebook_id")->leftJoin("login_local")->on("user.id = login_local.user_id")->leftJoin("login_imap")->on("user.id = login_imap.user_id")->leftJoin("login_facebook")->on("user.id = login_facebook.user_id"); }
public function __construct(\DibiConnection $connection) { parent::__construct($connection, "membership"); $this->selection->leftJoin("user")->on("membership.user_id = user.id"); }