| | |
| | | | program/steps/addressbook/list.inc | |
| | | | | |
| | | | This file is part of the RoundCube Webmail client | |
| | | | Copyright (C) 2005, RoundCube Dev. - Switzerland | |
| | | | Copyright (C) 2005-2007, RoundCube Dev. - Switzerland | |
| | | | Licensed under the GNU GPL | |
| | | | | |
| | | | PURPOSE: | |
| | |
| | | |
| | | */ |
| | | |
| | | $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", |
| | | 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; |
| | | ?> |