PHP 处理数据为树状结构

游离于山间之上的Java爱好者

发布于 2022-12-19 08:58:39

8330

发布于 2022-12-19 08:58:39

文章被收录于专栏：你我杂志刊

本文已同步发布于个人站点 https://qiucode.cn/article/105 文末点击阅读原文也可到达

1、从数据库获取的数据

2、对查询出来的数据按键值归类

<?php

namespace app\index\controller;
use think\Controller;
use think\Db;

use think\Log;


class Data extends Controller {

    public function getTreeData(){
        $res =  Db::table('table_name')
               ->select();

        $erArr = self::getRepeatValGroup($res,'platform');
        Log::info($erArr);

        $newArr = [];
        foreach($erArr as $erK => $erV){

            $arr1 = [];
            foreach ($erV as $k => $v) {
                $arr1[$v['area']][] = $v;
            }
            $newArr[$erK][]=$arr1;
        }
        return json($newArr);
    }


    //$arr= 一个数组。$keys 是该数组里面的某一个值   该自定义函数主要是对二维数组里面的某一个值进行分组
    public function getRepeatValGroup($arr,$keys)
{
        if(!is_array($arr) || !$keys) {
            return false;
        }
        $temp = array();
        foreach($arr as $key=>$val) {
            $temp[$val[$keys]][] = $val;
        }
        return $temp;
    }

}

3、页面通过ajax请求接口，使用第三方书组件


  $.ajax({
                                type:"get",
                                url:"/index/channels/getPlatform",
                                success:function(data){

                                    let platformArr = []
                                    Object.keys(data).map(platform => {
                                        let areaArr = []

                                        data[platform].forEach(areaKey =>{

                                            //console.log('.........................')
                                            //console.log(areaKey)

                                            Object.keys(areaKey).map(area => {

                                                //console.log('<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<')
                                                ///console.log(area)
                                                //console.log('-------------区域-----------------------')
                                                //console.log(areaKey[area])
                                                let countryArr = []

                                                areaKey[area].forEach(country =>{
                                                    countryArr.push({
                                                        id:country.channel_no,
                                                        active: country.active,
                                                        //parentId:data2[0].area,
                                                        label:country.country
                                                    })
                                                })


                                                areaArr.push({
                                                    label:area,
                                                    children:countryArr
                                                })



                                            })

                                        })

                                        if(platform == 'Amazon'){
                                            platformArr.unshift({
                                                label: 'Amazon',
                                                children:areaArr 
                                            })
                                        }else{
                                            platformArr.push({
                                                label: platform,
                                                children:areaArr
                                            }) 
                                        }

                                    })



                                }
                            })