public function lists($map = array(), $order = '', $page = 1, $page_size = 10) { $field = 'id,class_id,title,authorize_code,thumb,ctime'; $list = $this->_list($map, $field, $order); if (empty($list)) { return array(); } //查询知识分类 $class_id = array_column($list, 'class_id'); $class_map['id'] = array('in', $class_id); $class_field = 'id,name,thumb'; $class_list = D('KnowClass')->_list($class_map, $class_field); if (empty($class_list)) { return array(); } ArrayHelper::ArrayKeyReplace($class_list, 'id', 'class_id'); ArrayHelper::ArrayKeyReplace($class_list, 'name', 'class_name'); ArrayHelper::ArrayKeyReplace($class_list, 'thumb', 'class_thumb'); $class_list = array_column($class_list, null, 'class_id'); //合并数据 foreach ($list as $_k => $_v) { $list[$_k] = array_merge($_v, $class_list[$_v['class_id']]); } return $list; }
public function lists($map = array(), $order = '', $page = 0, $page_size = 10) { $field = 'id,pid,name,type,url,key,level'; $list = $this->_list($map, $field, $order, $page, $page_size); if (empty($list)) { return array(); } //查询父栏目 $pid = array_column($list, 'pid'); $pid = array_filter($pid); if (empty($pid)) { return $list; } $parent_map['id'] = array('in', $pid); $parent_field = 'id,name'; $parent_list = $this->_list($parent_map, $parent_field); ArrayHelper::ArrayKeyReplace($parent_list, 'id', 'pid'); ArrayHelper::ArrayKeyReplace($parent_list, 'name', 'parent_name'); $parent_list = array_column($parent_list, null, 'pid'); //合并数据 foreach ($list as $_k => $_v) { if ($_v['pid'] != 0) { $list[$_k] = array_merge($_v, $parent_list[$_v['pid']]); } } return $list; }
public function lists($map = array(), $order = '', $page = 1, $page_size = 10) { $field = 'id,class_id,name,mobile,wechat_number,recommend,work_date,month_sale,brand,reason,province,city,source,is_approve'; $list = $this->_list($map, $field, $order, $page, $page_size); if (empty($list)) { return array(); } //查询代理分类 $class_id = array_column($list, 'class_id'); $class_map['id'] = array('in', $class_id); $class_field = 'id,name,price'; $class_list = D('AgentClass')->_list($class_map, $class_field); ArrayHelper::ArrayKeyReplace($class_list, 'id', 'class_id'); ArrayHelper::ArrayKeyReplace($class_list, 'name', 'class_name'); $class_list = array_column($class_list, null, 'class_id'); foreach ($list as $_k => $_v) { $list[$_k] = array_merge($_v, $class_list[$_v['class_id']]); } return $list; }
/** * 获取管理员列表 * @param array $map 查询条件 * @param string $order 排序规则 * @param integer $page 页数 * @param integer $page_size 每页条数 * @return array 查询出的数据 */ public function lists($map = array(), $order = '', $page = 1, $page_size = 10) { //获取管理员列表 $field = 'id,group_id,username,password,nickname,ctime'; $list = $this->_list($map, $field, $order, $page, $page_size); if (empty($list)) { return array(); } //获取组列表 $group_id = array_column($list, 'group_id'); $group_map['id'] = array('in', $group_id); $group_list = D('Group')->lists($group_map); ArrayHelper::ArrayKeyReplace($group_list, 'id', 'group_id'); ArrayHelper::ArrayKeyReplace($group_list, 'name', 'group_name'); $group_list = array_column($group_list, null, 'group_id'); //合并数据 foreach ($list as $_k => $_v) { $list[$_k] = array_merge($_v, $group_list[$_v['group_id']]); } return $list; }
public function lists($map = array(), $order = '', $page = 1, $page_size = 10) { $field = 'id,key_id,title,desc,pic,url,ctime'; $list = $this->_list($map, $field, $order, $page, $page_size); if (empty($list)) { return array(); } //查询关键词 $key_id = array_column($list, 'key_id'); $key_map['id'] = array('in', $key_id); $key_field = 'id,name'; $key_list = D('Keywords')->_list($key_map, $key_field); ArrayHelper::ArrayKeyReplace($key_list, 'id', 'key_id'); ArrayHelper::ArrayKeyReplace($key_list, 'name', 'key_name'); $key_list = array_column($key_list, null, 'key_id'); //合并数据 foreach ($list as $_k => $_v) { $list[$_k] = array_merge($_v, $key_list[$_v['key_id']]); } return $list; }