/** * @return array */ function &SelectAllAccounts($pageNumber, $accountPerPage, $sortField, $sortOrder, $searchText) { $mailBoxSizes = array(); if ($this->_dbConnection->Execute($this->_commandCreator->CountAllMailboxSizes())) { while ($row = $this->_dbConnection->GetNextRecord()) { $mailBoxSizes[$row->id_user] = $row->mailboxes_size; } } $outarray = array(); if (!$this->_dbConnection->Execute($this->_commandCreator->SelectAllAccounts($pageNumber, $accountPerPage, $sortField, $sortOrder, $searchText))) { return $outarray; } while ($row = $this->_dbConnection->GetNextRecord()) { if ($row) { $temp = array(); $temp['Id'] = (int) $row->id_acct; $temp['IdUser'] = (int) $row->id_user; $temp['Deleted'] = $row->deleted; $temp['Email'] = $row->email; $temp['MailIncHost'] = $row->mail_inc_host; $temp['MailOutHost'] = $row->mail_out_host; $temp['LastLogin'] = $row->nlast_login; $temp['LoginsCount'] = (int) $row->logins_count; $temp['MailboxSize'] = $row->mailbox_size; $temp['MailboxLimit'] = $row->mailbox_limit; $temp['UserMailboxSize'] = isset($mailBoxSizes[$row->id_user]) ? $mailBoxSizes[$row->id_user] : 0; $temp['DefAcct'] = $row->def_acct; $outarray[] = $temp; } } $this->_dbConnection->FreeResult(); return $outarray; }