思路:
把分类列表和图片列表全部搜出来。
然后用一个方法把这两个数组整合。
/**
* 开放图库分类
*/
public function galleryOpenCategory()
{
$gallery_open_cates_info = db('gallery_open_cates')->field('id,name,parent_id')->select();
$gallery_open_cates_info = generateTree($gallery_open_cates_info,$pk = 'id', $pid = 'parent_id', $child = 'subCg' );
$gallery_open_list = db('gallery_open')->column('cate_path');
$data = $this->makeAmericaGreatAgain($gallery_open_cates_info,$gallery_open_list);
$return['data'] = $data;
$return['status'] = 1000;
$return['code'] = "success";
$return['msg'] = "成功";
echo json_encode($return);
}
/**
*Have a cigarette
* @param $gallery_open_cates_info
* @param $gallery_open_list
* @return array
*/
public function makeAmericaGreatAgain($gallery_open_cates_info,$gallery_open_list){
$listOk = [];
foreach ($gallery_open_cates_info as $info){
$haveAcigarette = [];
foreach ($gallery_open_list as $op ){
if (strpos($op, (string)$info['id']) !== false) {
$haveAcigarette[] = $op;
}
}
$info['img_count'] = count($haveAcigarette);
if (isset($info['subCg'])) {
$info['subCg'] = $this->makeAmericaGreatAgain($info['subCg'], $gallery_open_list);
}
$listOk[] = $info;
}
return $listOk;
}
/**
* 多层分类树状图
* @param $list 原始数组
* @param string $pk 当前分类id
* @param string $pid 父类id
* @param string $child 子类键名
* @param int $root 顶级分类
* @return array 多级结构数组
*/
function generateTree($list, $pk = 'id', $pid = 'parent_id', $child = 'children', $root = 0)
{
$tree = array();
$packData = array();
foreach ($list as $data) {
$packData[$data[$pk]] = $data;
}
foreach ($packData as $key => $val) {
if ($val[$pid] == $root) {
$tree[] = &$packData[$key];
} else {
$packData[$val[$pid]][$child][] = &$packData[$key];
}
}
return $tree;
}