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;
 }
Example #2
0
 /**
  * 站内信记录
  * @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;
 }
Example #3
0
 /**
  * 获取单个管理员信息
  * @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;
 }
Example #5
0
 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;
 }
Example #6
0
 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;
 }