/** * @see Page::readData() */ public function readData() { parent::readData(); // get smileys $this->invitationList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage; $this->invitationList->sqlLimit = $this->itemsPerPage; $this->invitationList->sqlOrderBy = $this->sortField . " " . $this->sortOrder; $this->invitationList->readObjects(); }
/** * @see Page::readData() */ public function readData() { parent::readData(); $this->unansweredInvitationList = new InvitationList(); $this->unansweredInvitationList->sqlLimit = 0; $this->unansweredInvitationList->sqlConditions .= 'sender.userID = ' . WCF::getUser()->userID . ' AND invitation.isSealed = 0'; $this->unansweredInvitationList->sqlOrderBy .= 'invitation.email ASC'; $this->unansweredInvitationList->readObjects(); $acceptedInvitationList = new InvitationList(); $acceptedInvitationList->sqlLimit = 0; $acceptedInvitationList->sqlConditions .= 'sender.userID = ' . WCF::getUser()->userID . ' AND invitation.isSealed = 1'; $acceptedInvitationList->sqlOrderBy .= 'recipient.username ASC'; $acceptedInvitationList->readObjects(); foreach ($acceptedInvitationList->getObjects() as $acceptedInvitation) { $this->invitedMembers[] = new UserProfile($acceptedInvitation->recipientUserID); } }