public function lists($map = array(), $field = '', $order = '', $page = 0, $page_size = 0) { $pk = $this->pk; //主键 $field = empty($field) ? $this->selectFields : $fields; $order = empty($order) ? $pk . ' desc' : $order; if ($page === 0) { $list = $this->where($map)->field($field)->order($order)->select(); } else { $page_index = ($page - 1) * $page_size; $list = $this->where($map)->field($field)->order($order)->limit($page_index . ',' . $page_size)->select(); } if (empty($list)) { return $list; } //查询会员表 $member_id = array_column($list, 'member_id'); $member_id = array_unique($member_id); $member_map['id'] = array('in', $member_id); $member_list = D('Member')->_list($member_map, 'id,username'); $member_list = ArrayHelper::array_key_replace($member_list, 'id', 'member_id'); $member_list = array_column($member_list, null, 'member_id'); foreach ($list as $_k => $_v) { $list[$_k] = array_merge($_v, $member_list[$_v['member_id']]); } return $list; }
/** * 站内信记录 * @param array $map 查询条件 * @param string $field 查询字段 * @param string $order 排序规则 * @param integer $page 页数 * @param integer $page_size 每页条数 * @return array 记录数据 */ public function lists($map = array(), $field = '', $order = '', $page = 0, $page_size = 10) { $list = $this->_list($map, $field, $order, $page, $page_size); if (empty($list)) { return array(); } //查询会员列表数据 $user_id = array_column($list, 'user_id'); $user_id = array_merge($user_id, array_column($list, 'to_user_id')); $user_map['id'] = array('in', $user_id); $user_list = D('User')->_list($user_map, 'id, username, name'); $user_list = ArrayHelper::array_key_replace($user_list, 'id', 'user_id'); $user_list = array_column($user_list, null, 'user_id'); $to_user_list = ArrayHelper::array_key_replace($user_list, array('user_id', 'username', 'name'), array('to_user_id', 'to_username', 'to_name')); //合并数据 foreach ($list as $_k => $_v) { if ($_v['user_id'] == 0) { $_v['username'] = '******'; $list[$_k] = array_merge($_v, $to_user_list[$_v['to_user_id']]); } else { if ($_v['to_user_id'] == 0) { $_v['to_username'] = '******'; $list[$_k] = array_merge($_v, $user_list[$_v['user_id']]); } else { $list[$_k] = array_merge($_v, $user_list[$_v['user_id']], $to_user_list[$_v['to_user_id']]); } } } return $list; }
/** * 获取单个管理员信息 * @method get * @param array $map [description] * @return [type] [description] */ public function get($map = array()) { $info = $this->_get($map); if (empty($info)) { return false; } $group_map['group_id'] = $info['group_id']; $group_info = D('Group')->_get($group_map); $group_info = ArrayHelper::array_key_replace($group_info, array('id', 'name'), array('group_id', 'group_name')); $info = array_merge($info, $group_info); return $info; }
public function lists() { $list = $this->_list($map, $field, $order, $page, $page_size); if (empty($list)) { return array(); } //查询会员列表数据 $user_id = array_column($list, 'user_id'); $user_map['id'] = array('in', $user_id); $user_list = D('User')->_list($user_map, 'id, username, name'); $user_list = ArrayHelper::array_key_replace($user_list, 'id', 'user_id'); $user_list = array_column($user_list, null, 'user_id'); //合并数据 foreach ($list as $_k => $_v) { $list[$_k] = array_merge($_v, $user_list[$_v['user_id']]); } return $list; }
public function lists($map = array(), $field = '', $order = '', $page = 1, $page_size = 10) { $list = $this->_list($map, $field, $order, $page, $page_size); if (empty($list)) { return array(); } //查询会员表 $member_id = array_column($list, 'member_id'); $member_id = array_unique($member_id); $member_map['id'] = array('in', $member_id); $member_list = D('Member')->_list($member_map, 'id,username'); $member_list = ArrayHelper::array_key_replace($member_list, 'id', 'member_id'); $member_list = array_column($member_list, null, 'member_id'); foreach ($list as $_k => $_v) { $list[$_k] = array_merge($_v, $member_list[$_v['member_id']]); } return $list; }
public function get($map = array(), $fields = '', $order = '') { $info = $this->_get($map); if (empty($info)) { return false; } $level_map['id'] = $info['level_id']; $level_info = D('UserLevel')->_get($level_map); $level_info = ArrayHelper::array_key_replace($level_info, array('id', 'name'), array('level_id', 'level_name')); $info = array_merge($info, $level_info); return $info; }