Ejemplo n.º 1
0
 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");
 }
Ejemplo n.º 2
0
 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");
 }
Ejemplo n.º 3
0
 public function __construct(\DibiConnection $connection)
 {
     parent::__construct($connection, "membership");
     $this->selection->leftJoin("user")->on("membership.user_id = user.id");
 }