tree

function getAEdit($el_in, $el, $tree)
{
	global $conn;
	
	$query_c = "Select company, global_type, surname, first_name, last_name From users where del=0 and Id = " . $el_in;
	//echo $query_c;
	$res = mysql_query($query_c);
	$company_name = mysql_result($res, 0, 0);	
	$global_type = mysql_result($res, 0, 1);
	
	$surname = mysql_result($res, 0, 2);
	$first_name = mysql_result($res, 0, 3);
	$last_name = mysql_result($res, 0, 4);
	
	$name = $surname . " " . $first_name . " " . $last_name;
	
	
	$query_d = "select id from users where parent_id=" . $el_in;
	$res = mysql_query($query_d);
	while ($row = mysql_fetch_assoc($res)) {
		$arr2[] = $row;
	}
	

	$tree .= "
"  . $el_in . "
";		

		
		
	for($k = 0; $k < count($arr2); $k++)
	{		
	
		$tree = getAEdit($arr2[$k]['id'], $el, $tree);
	
	}


	
	return $tree;	

}

function getTree($el_in, $el, $tree)
{
	global $conn;
	
	$query_c = "Select company, global_type, surname, first_name, last_name From users where del=0 and Id = " . $el_in;
	//echo $query_c;
	$res = mysql_query($query_c);
	$company_name = mysql_result($res, 0, 0);	
	$global_type = mysql_result($res, 0, 1);
	
	$surname = mysql_result($res, 0, 2);
	$first_name = mysql_result($res, 0, 3);
	$last_name = mysql_result($res, 0, 4);
	
	$name = $surname . " " . $first_name . " " . $last_name;
	
	$icon = array();
	$icon[] = "/img/company_icon.png";
	$icon[] = "/img/face_icon.png";
	$icon[] = "/img/sub_icon.png";
	

	
	$query_d = "select id from users where parent_id=" . $el_in;
	$res = mysql_query($query_d);
	while ($row = mysql_fetch_assoc($res)) {
		$arr2[] = $row;
	}
	
	$tree .= "
";
	
		if($el_in == $el)
		{
			$tree .= '
' . $company_name . ' [' . $name . ']';
		
		
		}
		else	
		{
			$tree .= '
' . $company_name . ' [' . $name . ']';
		
		
		}
		
		
	for($k = 0; $k < count($arr2); $k++)
	{
		
	
		$tree = getTree($arr2[$k]['id'], $el, $tree);
	
	}

		$tree .= "
";
	$tree .= "
";
	
	return $tree;	

}

$con = "";

	$con .= '
	
	



	
	
	
	
	
	
	
	
	
		
	
	
	
	

		
	
		
	';
	
	echo $con;
	
	
	
	$tree = getTree($global_parent, $company_id, "");
	$a_edit = getAEdit($global_parent, $company_id, "");
	
	echo $tree;	
	
	
	$con ='
		
	
	
	';
	
	echo $con;
	
	echo $a_edit;
	
	$end = '	
	
	

	';

echo $end;

function getAEdit($el_in, $el, $tree)
{
    global $conn;
    
    $query_c = "Select company, global_type, surname, first_name, last_name From users where del=0 and Id = " . $el_in;
    //echo $query_c;
    $res = mysql_query($query_c);
    $company_name = mysql_result($res, 0, 0);    
    $global_type = mysql_result($res, 0, 1);
    
    $surname = mysql_result($res, 0, 2);
    $first_name = mysql_result($res, 0, 3);
    $last_name = mysql_result($res, 0, 4);
    
    $name = $surname . " " . $first_name . " " . $last_name;
    
    
    $query_d = "select id from users where parent_id=" . $el_in;
    $res = mysql_query($query_d);
    while ($row = mysql_fetch_assoc($res)) {
        $arr2[] = $row;
    }
    

    $tree .= "<div><a style='display:none' class='a_edit' node='" . $el_in . "' href='/index.php?mod=edit&id=" . $el_in . "&rs=1' target='_blank'>" . $el_in . "</a></div>";        

        
        
    for($k = 0; $k < count($arr2); $k++)
    {        
    
        $tree = getAEdit($arr2[$k]['id'], $el, $tree);
    
    }


    
    return $tree;    

}

function getTree($el_in, $el, $tree)
{
    global $conn;
    
    $query_c = "Select company, global_type, surname, first_name, last_name From users where del=0 and Id = " . $el_in;
    //echo $query_c;
    $res = mysql_query($query_c);
    $company_name = mysql_result($res, 0, 0);    
    $global_type = mysql_result($res, 0, 1);
    
    $surname = mysql_result($res, 0, 2);
    $first_name = mysql_result($res, 0, 3);
    $last_name = mysql_result($res, 0, 4);
    
    $name = $surname . " " . $first_name . " " . $last_name;
    
    $icon = array();
    $icon[] = "/img/company_icon.png";
    $icon[] = "/img/face_icon.png";
    $icon[] = "/img/sub_icon.png";
    

    
    $query_d = "select id from users where parent_id=" . $el_in;
    $res = mysql_query($query_d);
    while ($row = mysql_fetch_assoc($res)) {
        $arr2[] = $row;
    }
    
    $tree .= "<ul>";
    
        if($el_in == $el)
        {
            $tree .= '<li data-jstree=\'{"opened":true,"selected":true,"icon":"' . $icon[$global_type] . '"}\'><span style="color:#000000"><b>' . $company_name . '</b> [' . $name . ']</span>';
        
        
        }
        else    
        {
            $tree .= '<li data-jstree=\'{"opened":true,"icon":"' . $icon[$global_type] . '"}\'><img style="margin-right:5px" class="node_edit" node="' . $el_in . '" src="/b_edit.png" border="0">' . $company_name . ' [' . $name . ']';
        
        
        }
        
        
    for($k = 0; $k < count($arr2); $k++)
    {
        
    
        $tree = getTree($arr2[$k]['id'], $el, $tree);
    
    }

        $tree .= "</li>";
    $tree .= "</ul>";
    
    return $tree;    

}

$con = "";

    $con .= '
    
    
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Mobile theme visual tests</title>
    <link rel="stylesheet" href="/jsr/vakata-jstree-2f630b4/dist/themes/default/style.min.css">
    <link rel="stylesheet" href="/jsr/vakata-jstree-2f630b4/dist/themes/default-dark/style.min.css">
    <style>.tree { border:1px solid black; padding:10px; width:300px; margin:20px; float:left; min-height:200px; }</style>
    
    <script src="/jsr/vakata-jstree-2f630b4/dist/libs/jquery-1.10.2.min.js"></script>
    <script src="/jsr/vakata-jstree-2f630b4/dist/jstree.js"></script>
    
    <script type="text/javascript">
    $(function() {
        var iframe = $("#iframe_get_tree", parent.document.body);
        iframe.height($(document.body).height() + 40);
    });
    </script>    
    
    </head>
    <body >
    <div id="html1">
        
    
        
    ';
    
    echo $con;
    
    
    
    $tree = getTree($global_parent, $company_id, "");
    $a_edit = getAEdit($global_parent, $company_id, "");
    
    echo $tree;    
    
    
    $con ='
        
    </div>
    
    ';
    
    echo $con;
    
    echo $a_edit;
    
    $end = '    <script>
    
        $(document).ready(function(){
    
            $("#html1").jstree();
        
            $(".node_edit").click(function(){
            
                var node = $(this).attr("node");                
            
                $("a[node=\'" + node + "\']")[0].click();
            
            
            });    
            
        });    
    
    </script>
    
    
</body>
</html>    ';

echo $end;