function buildTree($treeData, $parentId = null, $collapseAll = false) {
    $html = "
<ul id='tree_" . $parentId . "' class='tree-list " . ($collapseAll ? 'collapsed' : '') . "'>";
    
    foreach ($treeData as $node) {
        if ($node['parent_id'] == $parentId) {
            $html .= "<li data-node-id='" . $node['id'] . "' data-collapsed='false'>";
            $html .= "<a href='" . $node['link'] . "'>" . $node['text'] . "</a>";

            // Check if the node has children
            $hasChildren = in_array($node['id'], array_column($treeData, 'parent_id'));

            // Add a toggle button if there are children
            if ($hasChildren) {
                $html .= "<span class='toggle-btn' onclick='toggleChildren(\"" . $node['id'] . "\", this)'></span>";
            }

            // Recursively build child nodes
            $html .= buildTree($treeData, $node['id'], $collapseAll);
            $html .= "</li>";
        }
    }

    $html .= "</ul>";
    return $html;
}


$sql="";
if($_SESSION["language"]=="English")
{
$sql = "SELECT code as id, en_account_name label, en_account_name text, 
        concat('AccountsChart_list.php?q=(code~equal~',code,')&c=',code) link, 
        parent_code as parent_id 
        FROM acc_accounts_chart 
        ORDER BY code";
echo "<style>
             ul.tree-list { list-style-type: none; }
        ul.tree-list.collapsed { display: none; }
        .toggle-btn {
            display: inline-block;
            width: 16px;
            height: 16px;
            background-image: url('images/toggle-small.png');
            cursor: pointer;
            float:left;
            margin-left:2px;
        }
        .toggle-btn.collapsed {
            background-image: url('images/toggle-small-expand.png');
        }
     </style>";
echo ' <input type="text" id="searchBox" placeholder="Search" onkeyup="filterTree()" style="width:100%" class="form-control">';
echo "<a href='AccountsChart_list.php' class='glyphicon glyphicon-remove'></a>";
}
else if($_SESSION["language"]=="Arabic")
{
$sql ="SELECT code as id, ar_account_name label, ar_account_name text, 
        concat('AccountsChart_list.php?q=(code~equal~',code,')&c=',code) link, 
        parent_code as parent_id 
        FROM acc_accounts_chart 
        ORDER BY code";
echo "<style>
             ul.tree-list { list-style-type: none; }
        ul.tree-list.collapsed { display: none; }
        .toggle-btn {
            display: inline-block;
            width: 16px;
            height: 16px;
            background-image: url('images/toggle-small.png');
            cursor: pointer;
            float:right;
            margin-right:2px;
        }
        .toggle-btn.collapsed {
            background-image: url('images/toggle-small-expand.png');
        }
     </style>";
echo ' <input type="text" id="searchBox" placeholder="ابحث" onkeyup="filterTree()" style="width:100%" class="form-control">';
echo "<a href='AccountsChart_list.php' class='glyphicon glyphicon-remove'></a>";

}

echo "
<script>
function toggleChildren(parentId, element) {
            var ul = $('#tree_' + parentId);
            ul.toggleClass('collapsed');
            $(element).toggleClass('collapsed');
            
            var collapsed = ul.hasClass('collapsed');
            ul.data('collapsed', collapsed);
            
            // Update child nodes
            $('[data-node-id=\"' + parentId + '\"]').each(function() {
                $(this).data('hidden', collapsed);
            });
        }

        function filterTree() {
            var searchTerm = $('#searchBox').val().toLowerCase();
            $('.tree-list li').each(function() {
                var treeText = $(this).text().toLowerCase();
                var nodeId = $(this).data('node-id');
                
                if (treeText.indexOf(searchTerm) > -1) {
                 $(this).removeAttr('hidden');
    } else {
     $(this).attr('hidden', 'hidden');             
   }
            });
        }
</script>";
$rs = CustomQuery($sql);
$treeData = array();
while ($row = db_fetch_array($rs)) {
    $treeData[] = $row;
}
echo buildTree($treeData);