<?php
require('dbConfig.php');

$connection = dbConfig();
$result_rows=array();
$tree = array();
$tree_result = array();
$tree_count=1;
$data=array();


function getSubLevel($level,$position_no,$connection){
	$getdata=array();

   $sqlQuery = "SELECT n_level,position_no,reporting_to_position_code,position_code from chart_data WHERE reporting_to_position_no ='".$position_no."'";
	$result_data = mysqli_query($connection, $sqlQuery);
	if(mysqli_num_rows($result_data))
	{
		while ($rows = mysqli_fetch_assoc($result_data)) { 
			$level_name=$rows['n_level'].'_'.$rows['position_no'];
		    $reporting=$rows['reporting_to_position_code'];
		    $getdata[$level_name]=getSubLevel($rows['n_level'],$rows['position_no'],$connection);
		    $position_code=$rows['position_code'];
            $tree_result[$level_name]=array("trad"=>'<span class="nm">'.$position_code.'</span><span class="dgn">'.$reporting.'</span>');

		}
		return $getdata;
	}
	else
	{
		return '';
	}

}

//$tree_result["N1"]=array("trad"=>'<span class="nm">admin</span>');
$sqlQuery = "SELECT n_level,position_no,reporting_to_position_code,position_code from chart_data WHERE n_level NOT IN ('Service', 'Support') and n_level in ('N2') ";
$result_data = mysqli_query($connection, $sqlQuery);
if(mysqli_num_rows($result_data))
{
	while ($rows = mysqli_fetch_assoc($result_data)) {
		$level_name=$rows['n_level'].'_'.$rows['position_no'];
		$reporting=$rows['reporting_to_position_code'];
        $data[$level_name]=getSubLevel($rows['n_level'],$rows['position_no'],$connection);
        $position_code=$rows['position_code'];
      }
}


$sqlQuery = "SELECT n_level,position_no,reporting_to_position_code,position_code,department_n4 from chart_data ";
	$result_data = mysqli_query($connection, $sqlQuery);
	if(mysqli_num_rows($result_data))
	{
		while ($rows = mysqli_fetch_assoc($result_data)) {
		$level_name=$rows['n_level'].'_'.$rows['position_no'];
		$reporting=$rows['reporting_to_position_code'];
        $position_code=$rows['position_code'];
        $department_n4=$rows['department_n4'];
        $tree_result[$level_name]=array("trad"=>'<span class="nm">'.$position_code.'</span><span class="dgn">'.$reporting.'</span><span class="code">'.$department_n4.'</span>');
      }
	}
$tree=array("N1_FTE08302"=>$data);

echo json_encode(array('tree'=>$tree, 'tree_result'=>$tree_result));

?>