function list_users(&$msg, &$data) { get_user_data_modal($user_modal); $user_id = P('id'); $options = array('data modal' => $user_modal, 'left join' => array(array('qwp_role', 'r', 'r.id=u.role')), 'where' => 'u.id<>1 and role<>1'); if ($user_id) { $data = array(); if ($user_id != '1' && is_digits($user_id)) { $options['where'] .= ' and u.id=' . $user_id; qwp_db_get_data(array('qwp_user', 'u'), $data, null, $options); } } else { $options['default order'] = array('role', array('id', 'desc')); $options['search condition'] = array('condition' => array('fields' => array('u.name' => 'like', 'avatar' => 'set_avatar_condition', 'gender' => array('s' => array('<>', 'x'))), 'condition' => array('op' => 'or', 'fields' => array('phone' => 'like', 'account' => 'like', 'email' => 'like', 'name' => 'like')))); $options['search converter'] = 'convert_search_data'; qwp_db_retrieve_data(array('qwp_user', 'u'), $data, $options); } }
<?php if (!defined('QWP_ROOT')) { exit('Invalid Request'); } get_user_data_modal($user_modal); qwp_db_get_table_header_from_modal($user_modal, $users_header); ?> <script> var needReset = false, tableName = 'users', loadingNotes = {success: $L('Users data is loading...'), failed: $L('Failed to load user data')}; function fetchUsersData(page, psize, sortf, sort) { qwp.table.load(tableName, loadingNotes, page, psize, sortf, sort, false, $('#search_form').serialize()); return false; } function userOpsCallback(res, data, params) { if (params.ops == 'add') { if (res.ret) { needReset = true; fetchUsersData(); } else { needReset = false; } } } function addNewUser() { qwp.form.action('#user_info', 'add', { reset: needReset, dialog: ['dialog_user', $L('Add a new user')], msgBox: { title : $L('Add new user confirmation'), message : $L('Are you sure to create this user?')