TreeSql.php

Go to the documentation of this file.

<?php

 
namespace Depage\XmlDb\Helpers;

class TreeSql
{
    public static function descendants(string $table, string $anchorCondition, int $pad): string
    {
        return "WITH RECURSIVE tree (root_id, id, id_parent, lvl, sortkey) AS
            (
            SELECT x.id, x.id, x.id_parent, 0, CAST('' AS CHAR(5000))
                FROM {$table} AS x
                WHERE {$anchorCondition}
            UNION ALL
            SELECT tree.root_id, x.id, x.id_parent, tree.lvl + 1, CONCAT(tree.sortkey, LPAD(IFNULL(x.pos + 1, 0), {$pad}, '0'))
                FROM {$table} AS x INNER JOIN tree
                ON x.id_parent = tree.id
            )";
    }
}
 
/* vim:set ft=php sw=4 sts=4 fdm=marker et : */