<?php
include('php-includes/connect.php');
include('php-includes/check-login.php');
$userid = $_SESSION['userid'];
$search = $userid;
?>
<?php
function tree_data($userid){
global $con;
$data = array();
$query = mysqli_query($con,"select * from tree where userid='$userid'");
$result = mysqli_fetch_array($query);
$data['left'] = $result['left'];
$data['right'] = $result['right'];
$data['middle'] = $result['middle'];
$data['leftcount'] = $result['leftcount'];
$data['rightcount'] = $result['rightcount'];
return $data;
}
?>
<?php 
if(isset($_GET['search-id'])){
$search_id = mysqli_real_escape_string($con,$_GET['search-id']);
if($search_id!=""){
$query_check = mysqli_query($con,"select * from user where email='$search_id'");
if(mysqli_num_rows($query_check)>0){
$search = $search_id;
}
else{
echo '<script>alert("Access Denied");window.location.assign("tree.php");</script>';
}
}
else{
echo '<script>alert("Access Denied");window.location.assign("tree.php");</script>';
} 
}
?>
<?PHP include("link/header.php")?>

<?php	$sel="select * from tree where userid='$userid' ";
		
			
			
?>
<link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="jq/jquery.dataTables.min.css" type="text/css" rel="stylesheet"/>
<link href="jq/buttons.dataTables.min.css" type="text/css" rel="stylesheet"/>
  <link href="/your-path-to-fontawesome/css/fontawesome.css" rel="stylesheet">
<script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-3.4.1.min.js"></script>
<script src="jq/jquery.dataTables.min.js"></script>
<script src="jq/dataTables.buttons.min.js"></script>
<script src="jq/buttons.flash.min.js"></script>
<script src="jq/jszip.min.js"></script>
<script src="jq/pdfmake.min.js"></script>
<script src="jq/vfs_fonts.js"></script>
<script src="jq/buttons.html5.min.js"></script>
<script src="jq/buttons.print.min.js"></script>
<section id="main-content">
	<section class="wrapper">
	<div id="page-wrapper" style="background-color: white;background-repeat: no-repeat;background-position: center;background-size:580px">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-lg-12">
                        <h1 class="page-header">TREE</h1>
											<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
       buttons: ['copy', 'csv', 'excel', 'pdf', 'print']
    });
	
});
</script>


<div class="table-responsive">
<table class="table" align="center" border="0" style="text-align:center">
<tr height="150">
<?php
$data = tree_data($search);
?>
<td></td>
<?php 
$sel3="select * from user where email='$search'";
$res3=mysqli_query($con,$sel3);
$row3=mysqli_fetch_array($res3,MYSQLI_BOTH);
$show=$row3['name'];
$amount3=$row3['amount'];
//echo $show

?>
<td colspan="2"><span style="color:red"><?php echo 'Joining'.' = '. $amount3;?></span><i class="fa fa-user fa-4x" style="color:#1430B1"></i><span><?php if($amount3!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $search.'('.$show.')'; ?></p></td>
<td></td>
</tr>
<tr height="150">
<?php
$first_left_user = $data['left'];
$first_middle_user = $data['middle'];
$first_right_user = $data['right'];
?>
<?php 
if($first_left_user!=""){
?>
<?php 
$sel31="select * from user where email='$first_left_user'";
$res31=mysqli_query($con,$sel31);
$row31=mysqli_fetch_array($res31,MYSQLI_BOTH);
$show1=$row31['name'];
$amount31=$row31['amount'];
//echo $show1

?>
<td colspan="2"><span style="color:red"><?php echo 'Joining'.' = '. $amount31;?></span><a href="tree.php?search-id=<?php echo $first_left_user ?>"><i class="fa fa-user fa-4x" style="color:#D520BE"></i><span><?php if($amount31!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $first_left_user.'('.$show1.')'; ?></p></a></td>
<?php 
}
else{
?>
<td colspan="2"><i class="fa fa-user fa-4x" style="color:#D520BE"></i><p style="color:black"><?php echo $first_left_user; ?></p></td>
<?php
}
?>

<?php 
if($first_middle_user!=""){
?>
<?php 
$sel314="select * from user where email='$first_middle_user'";
$res314=mysqli_query($con,$sel314);
$row314=mysqli_fetch_array($res314,MYSQLI_BOTH);
$show14=$row31['name'];
$amount314=$row314['amount'];
//echo $show1

?>
<td colspan="2"><span style="color:red"><?php echo 'Joining'.' = '. $amount314;?></span><a href="tree.php?search-id=<?php echo $first_middle_user ?>"><i class="fa fa-user fa-4x" style="color:#D520BE"></i><span><?php if($amount314!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $first_middle_user.'('.$show14.')'; ?></p></a></td>
<?php 
}
else{
?>
<td colspan="2"><i class="fa fa-user fa-4x" style="color:#D520BE"></i><p style="color:black"><?php echo $first_middle_user; ?></p></td>
<?php
}
?>


<?php 
if($first_right_user!=""){
?>
<?php 
$sel311="select * from user where email='$first_right_user'";
$res311=mysqli_query($con,$sel311);
$row311=mysqli_fetch_array($res311,MYSQLI_BOTH);
$show11=$row311['name'];
$amount311=$row311['amount'];
//echo $show1

?>
<td colspan="2"><span style="color:red"><?php echo 'Joining'.' = '. $amount311;?></span><a href="tree.php?search-id=<?php echo $first_right_user ?>"><i class="fa fa-user fa-4x" style="color:#D520BE"></i><span><?php if($amount311!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p><?php echo $first_right_user.'('.$show11.')'; ?></p></a></td>
<?php 
}
else{
?>
<td colspan="2"><i class="fa fa-user fa-4x" style="color:#D520BE"></i><p style="color:black"><?php echo $first_right_user ; ?></p></td>
<?php
}
?>
</tr>
<tr height="150">
<?php 
$data_first_left_user = tree_data($first_left_user);
$second_left_user = $data_first_left_user['left'];
$second_middle_user = $data_first_left_user['middle'];
$second_right_user = $data_first_left_user['right'];

$data_first_right_user = tree_data($first_right_user);
$third_left_user = $data_first_right_user['left'];
$third_middle_user = $data_first_right_user['middle'];
$thidr_right_user = $data_first_right_user['right'];

$data_first_middle_user = tree_data($first_middle_user);
$fourth_left_user = $data_first_middle_user['left'];
$fourth_midle_user = $data_first_middle_user['middle'];
$fourth_right_user = $data_first_middle_user['right'];
?>
<?php 
if($second_left_user!=""){
?>
<?php 
$sel41="select * from user where email='$second_left_user'";
$res41=mysqli_query($con,$sel41);
$row41=mysqli_fetch_array($res41,MYSQLI_BOTH);
$show41=$row41['name'];
$amount41=$row41['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount41;?></span><a href="tree.php?search-id=<?php echo $second_left_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"></i><span><?php if($amount41!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $second_left_user .'('.$show41.')';?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>
<?php 
if($second_middle_user!=""){
?>
<?php 
$sel414="select * from user where email='$second_middle_user'";
$res414=mysqli_query($con,$sel414);
$row414=mysqli_fetch_array($res414,MYSQLI_BOTH);
$show414=$row414['name'];
$amount414=$row414['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount414;?></span><a href="tree.php?search-id=<?php echo $second_middle_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"></i><span><?php if($amount414!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $second_middle_user .'('.$show414.')';?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>

<?php 
if($second_right_user!=""){
?>
<?php 
$sel411="select * from user where email='$second_right_user'";
$res411=mysqli_query($con,$sel411);
$row411=mysqli_fetch_array($res411,MYSQLI_BOTH);
$show411=$row411['name'];
$amount411=$row411['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount411;?></span><a href="tree.php?search-id=<?php echo $second_right_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"><span><?php if($amount411!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span></i><p style="color:black"><?php echo $second_right_user.'('.$show411.')'; ?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>
<?php 
if($third_left_user!=""){
?>
<?php 
$sel51="select * from user where email='$third_left_user'";
$res51=mysqli_query($con,$sel51);
$row51=mysqli_fetch_array($res51,MYSQLI_BOTH);
$show51=$row51['name'];
$amount51=$row51['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount51;?></span><a href="tree.php?search-id=<?php echo $third_left_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"></i><span><?php if($amount51!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $third_left_user.'('.$show51.')'; ?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>
<?php 
if($third_middle_user!=""){
?>
<?php 
$sel515="select * from user where email='$third_middle_user'";
$res515=mysqli_query($con,$sel515);
$row515=mysqli_fetch_array($res515,MYSQLI_BOTH);
$show515=$row515['name'];
$amount515=$row515['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount515;?></span><a href="tree.php?search-id=<?php echo $third_middle_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"></i><span><?php if($amount515!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $third_middle_user.'('.$show515.')'; ?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>
<?php 
if($thidr_right_user!=""){
?>

<?php 
$sel511="select * from user where email='$thidr_right_user'";
$res511=mysqli_query($con,$sel511);
$row511=mysqli_fetch_array($res511,MYSQLI_BOTH);
$show511=$row511['name'];
$amount511=$row511['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount511;?></span><a href="tree.php?search-id=<?php echo $thidr_right_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"></i><span><?php if($amount511!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $thidr_right_user .'('.$show511.')';?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>
<?php 
if($fourth_left_user!=""){
?>
<?php 
$sel516="select * from user where email='$fourth_left_user'";
$res516=mysqli_query($con,$sel516);
$row516=mysqli_fetch_array($res516,MYSQLI_BOTH);
$show516=$row516['name'];
$amount516=$row516['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount516;?></span><a href="tree.php?search-id=<?php echo $fourth_left_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"></i><span><?php if($amount516!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $fourth_left_user.'('.$show516.')'; ?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>
<?php 
if($fourth_middle_user!=""){
?>
<?php 
$sel5161="select * from user where email='$fourth_middle_user'";
$res5161=mysqli_query($con,$sel5161);
$row5161=mysqli_fetch_array($res5161,MYSQLI_BOTH);
$show5161=$row5161['name'];
$amount516=$row5161['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount5161;?></span><a href="tree.php?search-id=<?php echo $fourth_middle_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"></i><span><?php if($amount5161!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $fourth_middle_user.'('.$show5161.')'; ?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>
<?php 
if($fourth_right_user!=""){
?>
<?php 
$sel51612="select * from user where email='$fourth_right_user'";
$res51612=mysqli_query($con,$sel51612);
$row51612=mysqli_fetch_array($res51612,MYSQLI_BOTH);
$show51612=$row51612['name'];
$amount5162=$row51612['amount'];
//echo $show1

?>
<td><span style="color:red"><?php echo 'Joining'.' = '. $amount51612;?></span><a href="tree.php?search-id=<?php echo $fourth_right_user ?>"><i class="fa fa-user fa-4x" style="color:#361515"></i><span><?php if($amount51612!='0'){echo '<i class="fa fa-check-square-o" style="color:green;font-size:30px;font-weight:bold"></i>';} else {echo '<i class="fa fa-close" style="color:red;font-size:30px;font-weight:bold"></i>';}?></span><p style="color:black"><?php echo $fourth_right_user.'('.$show51612.')'; ?></p></a></td>
<?php 
}
else{
?>
<td><i class="fa fa-user fa-4x" style="color:#361515"></i></td>
<?php
}
?>
</tr>
</table>
</div>
	
                    </div>
                    <!-- /.col-lg-12 -->

                </div>
                <!-- /.row -->
                <div class="row">
                
                </div><!--/.row-->
            </div>
            <!-- /.container-fluid -->
        </div>
        <!-- /#page-wrapper -->

    </div>

	
</section>

<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-form-validator/2.3.26/jquery.form-validator.min.js"></script>
<script>
  $.validate({
    modules : 'html5',
	modules : 'file'
  });
</script>
 <!-- footer -->
		 <?php include('link/footer.php')?>
  <!-- / footer -->
</section>
<!--main content end-->
</section>
<script src="js/bootstrap.js"></script>
<script src="js/jquery.dcjqaccordion.2.7.js"></script>
<script src="js/scripts.js"></script>
<script src="js/jquery.slimscroll.js"></script>
<script src="js/jquery.nicescroll.js"></script>
<!--[if lte IE 8]><script language="javascript" type="text/javascript" src="js/flot-chart/excanvas.min.js"></script><![endif]-->
<script src="js/jquery.scrollTo.js"></script>
<!-- morris JavaScript -->	
<script>
	$(document).ready(function() {
		//BOX BUTTON SHOW AND CLOSE
	   jQuery('.small-graph-box').hover(function() {
		  jQuery(this).find('.box-button').fadeIn('fast');
	   }, function() {
		  jQuery(this).find('.box-button').fadeOut('fast');
	   });
	   jQuery('.small-graph-box .box-close').click(function() {
		  jQuery(this).closest('.small-graph-box').fadeOut(200);
		  return false;
	   });
	   
	    //CHARTS
	    function gd(year, day, month) {
			return new Date(year, month - 1, day).getTime();
		}
		
		graphArea2 = Morris.Area({
			element: 'hero-area',
			padding: 10,
        behaveLikeLine: true,
        gridEnabled: false,
        gridLineColor: '#dddddd',
        axes: true,
        resize: true,
        smooth:true,
        pointSize: 0,
        lineWidth: 0,
        fillOpacity:0.85,
			data: [
				{period: '2015 Q1', iphone: 2668, ipad: null, itouch: 2649},
				{period: '2015 Q2', iphone: 15780, ipad: 13799, itouch: 12051},
				{period: '2015 Q3', iphone: 12920, ipad: 10975, itouch: 9910},
				{period: '2015 Q4', iphone: 8770, ipad: 6600, itouch: 6695},
				{period: '2016 Q1', iphone: 10820, ipad: 10924, itouch: 12300},
				{period: '2016 Q2', iphone: 9680, ipad: 9010, itouch: 7891},
				{period: '2016 Q3', iphone: 4830, ipad: 3805, itouch: 1598},
				{period: '2016 Q4', iphone: 15083, ipad: 8977, itouch: 5185},
				{period: '2017 Q1', iphone: 10697, ipad: 4470, itouch: 2038},
			
			],
			lineColors:['#eb6f6f','#926383','#eb6f6f'],
			xkey: 'period',
            redraw: true,
            ykeys: ['iphone', 'ipad', 'itouch'],
            labels: ['All Visitors', 'Returning Visitors', 'Unique Visitors'],
			pointSize: 2,
			hideHover: 'auto',
			resize: true
		});
		
	   
	});
	</script>
<!-- calendar -->
	<script type="text/javascript" src="js/monthly.js"></script>
	<script type="text/javascript">
		$(window).load( function() {

			$('#mycalendar').monthly({
				mode: 'event',
				
			});

			$('#mycalendar2').monthly({
				mode: 'picker',
				target: '#mytarget',
				setWidth: '250px',
				startHidden: true,
				showTrigger: '#mytarget',
				stylePast: true,
				disablePast: true
			});

		switch(window.location.protocol) {
		case 'http:':
		case 'https:':
		// running on a server, should be good.
		break;
		case 'file:':
		alert('Just a heads-up, events will not work when run locally.');
		}

		});
	</script>
	<!-- //calendar -->
</body>
</html>