alecpl
2008-04-23 d91fedb8d45fafa2c16859771fdb958aa10ad469
program/steps/addressbook/list.inc
@@ -5,8 +5,8 @@
 | program/steps/addressbook/list.inc                                    |
 |                                                                       |
 | This file is part of the RoundCube Webmail client                     |
 | Copyright (C) 2005, RoundCube Dev. - Switzerland                      |
 | All rights reserved.                                                  |
 | Copyright (C) 2005-2007, RoundCube Dev. - Switzerland                 |
 | Licensed under the GNU GPL                                            |
 |                                                                       |
 | PURPOSE:                                                              |
 |   Send contacts list to client (as remote response)                   |
@@ -19,41 +19,17 @@
*/
$REMOTE_REQUEST = TRUE;
// count contacts for this user
$sql_result = $DB->query(sprintf("SELECT COUNT(contact_id) AS rows
                                  FROM   %s
                                  WHERE  del!='1'
                                  AND    user_id=%d",
                                 get_table_name('contacts'),
                                 $_SESSION['user_id']));
$sql_arr = $DB->fetch_assoc($sql_result);
$rowcount = $sql_arr['rows'];
// get contacts for this user
$result = $CONTACTS->list_records();
// update message count display
$pages = ceil($rowcount/$CONFIG['pagesize']);
$commands = sprintf("this.set_rowcount('%s');\n", rcmail_get_rowcount_text($rowcount));
$commands .= sprintf("this.set_env('pagecount', %d);\n", $pages);
$OUTPUT->set_env('pagecount', ceil($result->count / $CONTACTS->page_size));
$OUTPUT->command('set_rowcount', rcmail_get_rowcount_text($rowcount));
$start_row = ($CONTACTS_LIST['page']-1) * $CONFIG['pagesize'];
// get contacts from DB
$sql_result = $DB->query(sprintf("SELECT * FROM %s
                                  WHERE  del!='1'
                                  AND    user_id=%d
                                  ORDER BY name
                                  LIMIT %d, %d",
                                 get_table_name('contacts'),
                                 $_SESSION['user_id'],
                                 $start_row,
                                 $CONFIG['pagesize']));
$commands .= rcmail_js_contacts_list($sql_result);
// create javascript list
rcmail_js_contacts_list($result);
  
// send response
rcube_remote_response($commands);
$OUTPUT->send();
exit;
?>