如何从分层树导出产品全类别路径？

Question

我的起点是一个包含类别ID及其父ID的数组，来自Virtuemart categories表，如下所示：

Array
(
    [0] => Array
        (
            [id] => 1
            [parent_id] => 0
            [name] => Category A
        )

    [1] => Array
        (
            [id] => 2
            [parent_id] => 1
            [name] => Subcategory A1
        )

    [2] => Array
        (
            [id] => 3
            [parent_id] => 2
            [name] => Sub-Subcategory A1
        )

    [3] => Array
        (
            [id] => 4
            [parent_id] => 1
            [name] => Subcategory A2
        )

    [4] => Array
        (
            [id] => 5
            [parent_id] => 0
            [name] => Category B
        )

    [5] => Array
        (
            [id] => 6
            [parent_id] => 5
            [name] => Subcategory B
        )

)

我需要有一个字符串，每个最后类别的孩子完整的路径由/（斜杠）之间的孩子和由，（逗号）之间的第一级父母

我的输出应该是：

Category A/Subcategory A1/Sub-Subcategory A1,Category A/Subcategory A2,Category B/Subcategory B

我可以把启动数组转换成这个

Array
(
    [0] => Array
        (
            [id] => 1
            [parent_id] => 0
            [name] => Category A
            [children] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [parent_id] => 1
                            [name] => Subcategory A1
                            [children] => Array
                                (
                                    [0] => Array
                                        (
                                            [id] => 3
                                            [parent_id] => 2
                                            [name] => Sub-Subcategory A1
                                        )

                                )

                        )

                    [1] => Array
                        (
                            [id] => 4
                            [parent_id] => 1
                            [name] => Subcategory A2

                        )

                )

        )

    [1] => Array
        (
            [id] => 5
            [parent_id] => 0
            [name] => Category B
            [children] => Array
                (
                    [0] => Array
                        (
                            [id] => 6
                            [parent_id] => 5
                            [name] => Subcategory B1

                        )

                )

        )

)

Answer 1

给定下一个数组：

$array = Array(
    "0" => Array
        (
        "id" => 1,
        "parent_id" => 0,
        "name" => "Category A"
    ),
    "1" => Array
        (
        "id" => 2,
        "parent_id" => 1,
        "name" => "Subcategory A1"
    ),
    "2" => Array
        (
        "id" => 3,
        "parent_id" => 2,
        "name" => "Sub-Subcategory A1"
    ),
    "3" => Array
        (
        "id" => 4,
        "parent_id" => 1,
        "name" => "Subcategory A2"
    ),
    "4" => Array
        (
        "id" => 5,
        "parent_id" => 0,
        "name" => "Category B"
    ),
    "5" => Array
        (
        "id" => 6,
        "parent_id" => 5,
        "name" => "Subcategory B"
    )
);

诸如此类：

$tabOfElements = array();
foreach($array as $element){
    $tabOfElements[$element['id']] = (isset($tabOfElements[$element['parent_id']])?$tabOfElements[$element['parent_id']].'/':'').$element['name'];
}
$stringOfCategories = implode(',',$tabOfElements);

你应该做你需要的。注意：仅当父类别在数组中始终位于其子类别之前时，此选项才有效。

编辑：

要只获取所有最后类别子路径，可以执行以下操作：

$tabOfElements = array();
$elementsToDelete = array();
foreach($array as $element){
    $tabOfElements[$element['id']] = (isset($tabOfElements[$element['parent_id']])?$tabOfElements[$element['parent_id']].'/':'').$element['name'];       
    if(isset($tabOfElements[$element['parent_id']]) && !isset($elementsToDelete[$element['parent_id']])){
        $elementsToDelete[$element['parent_id']] = $element['parent_id'];
    }
}
$finalArray = array_diff_key($tabOfElements, $elementsToDelete);
$stringOfCategories = implode(',',$finalArray);

这将给你：

Category A/Subcategory A1/Sub-Subcategory A1,Category A/Subcategory A2,Category B/Subcategory B

编辑2：对于给定的第二个数组，可以使用如下递归函数：

function recursiveFunction($elementArray, $parentString = ''){
    if(isset($elementArray['children']) && !empty($elementArray['children'])){
        foreach($elementArray['children'] as $keyChild=>$child){
            $resultString .= recursiveFunction($child, $parentString.$elementArray['name'].'/').(($keyChild<count($elementArray['children'])-1)?',':'');
        }
        return $resultString;
    }else{
        return $parentString.$elementArray['name'];
    }
}

$tabOfPaths = array();
foreach($array as $elementArray){
    $tabOfPaths[] = recursiveFunction($elementArray);
}
$stringOfPaths = implode(',',$tabOfPaths);
echo $stringOfPaths;

希望能有帮助。