1#@!#!123s

: / home5 / rakcha / www / admin /
Filename : member_tree.php
back
<?php error_reporting(0); ?>

<?php 

session_start();

 if (!isset($_SESSION['admin_name'])) {

    header("location: index.php");

 }

 else {

  include("includes/database.php");

  if (isset($_GET['member_id'])) {

    $page_user = $_SESSION['admin_name'];



    $page_id = $_GET['member_id'];



    $select_query = "select * from member where member_id='$page_id'";

      $run = mysqli_query($con,$select_query);

       $serial = 1;

       while ($row = mysqli_fetch_array($run)) {

        $s_num = $serial++;

        $member_id = $row['member_id'];

        $title = $row['title'];

        $dob = $row['dob'];

        $name = $row['name'];

        $gender = $row['gender'];

        $address_1 = $row['address_1'];

        $address_2 = $row['address_2'];

        $town_area = $row['town_area'];

        $city_district = $row['city_district'];

        $state = $row['state'];

        $country = $row['country'];

        $pincode = $row['pincode'];

        $mobile_number = $row['mobile_number'];

        $email = $row['email'];

        $aadhaar_card = $row['aadhaar_card'];

        $pan_card = $row['pan_card'];

        $nominee_name = $row['nominee_name'];

        $nominee_relationship = $row['nominee_relationship'];

        $account_name = $row['account_name'];

        $account_number = $row['account_number'];

        $ifsc_code = $row['ifsc_code'];

        $bank_name = $row['bank_name'];

        $branch_name = $row['branch_name'];

        $member_no = $row['member_no'];

        $password = $row['password'];

        $elite_board = $row['elite_board'];

        $deb_member = $row['deb_member'];

        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];

        $member_fess = $row['member_fess'];

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];

        $aadhaar_card_image = $row['aadhaar_card_image'];

        $pan_card_image = $row['pan_card_image'];

        $bank_proof_image = $row['bank_proof_image'];

        $document_status = $row['document_status'];

        $date_of_join =$row['date_of_join'];

        $select_query_main_1 = "select * from member_tree where member_no='$member_no' ORDER BY tree_id ASC limit 1";

        $run_main_1 = mysqli_query($con,$select_query_main_1);

         

         while ($row_main_1 = mysqli_fetch_array($run_main_1)) {

          $tree_id_main_1 = $row_main_1['tree_id'];                                    

          $group_number_main_1 = $row_main_1['group_number'];

          $member_no_main_1 = $row_main_1['member_no'];

          $sponsor_no_main_1 = $row_main_1['sponsor_no'];

          $relation_ship_no_main_1 = $row_main_1['relation_ship_no'];

          $level_no_main_1 = $row_main_1['level_no'];

          $x_position_main_1 = $row_main_1['x_position']+1;

          $y_position_main_1 = $row_main_1['y_position'];

    

  ?>

  <!DOCTYPE html>

<html lang="en">



<head>

    <meta charset="utf-8" />

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta content="width=device-width, initial-scale=1" name="viewport" />

    <meta name="description" content="RAKCHA | Dashboard" />

    <meta name="author" content="RAKCHA | Dashboard" />

    <title>RAKCHA | Dashboard</title>

    <!-- google font -->

    <link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet" type="text/css" />

	<!-- icons -->

    <link href="assets/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" />

    <link href="assets/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>

	<link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">

	<!--bootstrap -->

	<link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />

	<!-- Material Design Lite CSS -->

	<link rel="stylesheet" href="assets/plugins/material/material.min.css">

	<link rel="stylesheet" href="assets/css/material_style.css">

	<!-- animation -->

	<link href="assets/css/pages/animate_page.css" rel="stylesheet">

	<!-- Theme Styles -->

    

    <link href="assets/css/style.css" rel="stylesheet" type="text/css" />

    <link href="assets/css/plugins.min.css" rel="stylesheet" type="text/css" />

    <link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />

	<link href="assets/css/theme-color.css" rel="stylesheet" type="text/css" />

	<!-- favicon -->

    <link rel="shortcut icon" href="assets/img/favicon.ico" /> 

    <style type="text/css">

   ul {margin: 0;}

    .tree_1

    {

      width: 900px;

      margin: 0 auto;



    }

    .tree_1 ul {

      padding-top: 20px; position: relative;

      

      transition: all 0.5s;

      -webkit-transition: all 0.5s;

      -moz-transition: all 0.5s;

    }

    .tree_1 li {

      float: left; text-align: center;

      list-style-type: none;

      position: relative;

      padding: 20px 5px 0 5px;

      

      transition: all 0.5s;

      -webkit-transition: all 0.5s;

      -moz-transition: all 0.5s;

    }

    .tree_1 li::before, .tree_1 li::after{

      content: '';

      position: absolute; top: 0; right: 50%;

      border-top: 1px solid #ccc;

      width: 50%; height: 20px;

    }

    .tree_1 li::after{

      right: auto; left: 50%;

      border-left: 1px solid #ccc;

    }

    .tree_1 li:only-child::after, .tree_1 li:only-child::before {

      display: none;

    }

    .tree_1 li:only-child{ padding-top: 0;}

    .tree_1 li:first-child::before, .tree_1 li:last-child::after{

      border: 0 none;

    }

    .tree_1 li:last-child::before{

      border-right: 1px solid #ccc;

      border-radius: 0 5px 0 0;

      -webkit-border-radius: 0 5px 0 0;

      -moz-border-radius: 0 5px 0 0;

    }

    .tree_1 li:first-child::after{

      border-radius: 5px 0 0 0;

      -webkit-border-radius: 5px 0 0 0;

      -moz-border-radius: 5px 0 0 0;

    }

    .tree_1 ul ul::before{

      content: '';

      position: absolute; top: 0; left: 50%;

      border-left: 1px solid #ccc;

      width: 0; height: 20px;

    }

    .tree_1 li a{

          

        

        text-decoration: none;

        color: #666;

        font-family: arial, verdana, tahoma;

        font-size: 11px;

        display: inline-block;

        background: url('img/people.png');

        -webkit-border-radius: 50%;

        -moz-border-radius: 5px;

        transition: all 0.5s;

        -webkit-transition: all 0.5s;

        -moz-transition: all 0.5s;

        width: 50px;

        height: 50px;

    }

    .tree_1 li a:hover, .tree_1 li a:hover+ul li a {

      background: url('img/hover.png'); color: #000; 

    }

    .tree_1 li a:hover+ul li::after, 

    .tree_1 li a:hover+ul li::before, 

    .tree_1 li a:hover+ul::before, 

    .tree_1 li a:hover+ul ul::before{

      border-color:  #94a0b4;

    }

    

    </style>

</head>

<!-- END HEAD -->

<body class="page-header-fixed sidemenu-closed-hidelogo page-content-white page-md header-white dark-sidebar-color logo-dark">

    <div class="page-wrapper">

        <!-- start header -->

        <div class="page-header navbar navbar-fixed-top">

            <div class="page-header-inner ">

                <!-- logo start -->

                <div class="page-logo">

                    <a href="main_home.php">

                        <img src="../images/resources/logo.png">

                    </a>

                </div>

                <!-- logo end -->

                <ul class="nav navbar-nav navbar-left in">

                    <li><a href="#" class="menu-toggler sidebar-toggler"><i class="icon-menu"></i></a></li>

                </ul>

                

                <!-- start mobile menu -->

                <a href="javascript:;" class="menu-toggler responsive-toggler" data-toggle="collapse" data-target=".navbar-collapse">

                    <span></span>

                </a>

               <!-- end mobile menu -->

                <!-- start header menu -->

                <div class="top-menu">

                    <ul class="nav navbar-nav pull-right">

                        

                        <!-- start manage user dropdown -->

                        <li class="dropdown dropdown-user">

                            <a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-close-others="true">

                                <i class="fa fa-user-o"></i>

                                <span class="username username-hide-on-mobile"> Admin </span>

                                <i class="fa fa-angle-down"></i>

                            </a>

                            <ul class="dropdown-menu dropdown-menu-default animated jello">

                                

                                <li>

                                    <a href="logout.php">

                                        <i class="icon-logout"></i> Log Out </a>

                                </li>

                            </ul>

                        </li>

                       

                    </ul>

                </div>

            </div>

        </div>

        <!-- end header -->

        

        <!-- start page container -->

        <div class="page-container">

 			<div class="sidebar-container">

                <div class="sidemenu-container navbar-collapse collapse fixed-menu">

                    <div id="remove-scroll">

                       <ul class="sidemenu  page-header-fixed" data-keep-expanded="false" data-auto-scroll="true" data-slide-speed="200" style="padding-top: 20px">

                            <li class="sidebar-toggler-wrapper hide">

                                <div class="sidebar-toggler">

                                    <span></span>

                                </div>

                            </li>

                            

                            <li class="nav-item start active">

                                <a href="main_home.php" class="nav-link nav-toggle">

                                    <i class="material-icons">dashboard</i>

                                    <span class="title">Dashboard</span>

                                    

                                </a>

                                

                            </li>

                            



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Members</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                     

                                    <li class="nav-item">

                                        <a href="member_roi.php" class="nav-link "> <span class="title">Member List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="member_company.php" class="nav-link "> <span class="title">Company Member List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="member_adv.php" class="nav-link "> <span class="title">Advance Registeration</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                             

                           

                             

                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Payout</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                    <li class="nav-item">

                                        <a href="weekly_roi.php" class="nav-link "> <span class="title">Payout</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="weekly_roi_history.php" class="nav-link "> <span class="title">Payout History</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="weekly_roi_search.php" class="nav-link "> <span class="title">Report</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Kit Bank</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                     

                                    <li class="nav-item">

                                        <a href="eproduct_request_roi.php" class="nav-link "> <span class="title">KIT Request</span>

                                        </a>

                                    </li>



                                    

                                </ul>

                            </li>



                             



                            

                            



                            



                             

                            



                            



                             

                            



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Product Management</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                    

                                    <li class="nav-item">

                                        <a href="new_kit.php" class="nav-link "> <span class="title">New Kit I</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_kit_1.php" class="nav-link "> <span class="title">New Kit II</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_address.php" class="nav-link "> <span class="title">Get Address</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_address_1.php" class="nav-link "> <span class="title">Get Address I</span>

                                        </a>

                                    </li>

                                    

                                    <li class="nav-item">

                                        <a href="billing.php" class="nav-link "> <span class="title">New Billing</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_binary.php" class="nav-link "> <span class="title">Product Details</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi.php" class="nav-link "> <span class="title">New Orders</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi_approve.php" class="nav-link "> <span class="title">Approved Orders</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi_order.php" class="nav-link "> <span class="title">Orders History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_1_history.php" class="nav-link "> <span class="title">New Kit I History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_2_history.php" class="nav-link "> <span class="title">New Kit II History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_pay.php" class="nav-link "> <span class="title">Download Invoice</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                            <li class="nav-item">

                                <a href="daily.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Daily Updates</span> 

                                </a>

                            </li>

                            <li class="nav-item">

                                <a href="gallery.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Gallery</span> 

                                </a>

                            </li>



                             

                            <li class="nav-item">

                                <a href="reward_list.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Reward Eligible list</span> 

                                </a>

                            </li>

                            



                            

                             

                             

                             

                            <li class="nav-item">

                                <a href="kyc_documents.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">KYC Documents</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="../control/" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">OLD DATA</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">NETWORK TREE</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">



                                    

                                    

                                    <li class="nav-item">

                                        <a href="network.php" class="nav-link "> <span class="title">Seniority List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="network_search.php" class="nav-link "> <span class="title">Level List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="../user/network_report.php" class="nav-link "> <span class="title">Get Report</span>

                                        </a>

                                    </li>



                                    

                                    

                                    

                                    

                                </ul>

                            </li>

                             

                            

                            <li class="nav-item">

                                <a href="coupon_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Coupon Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="personal_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Personal Pv Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="special_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Special Pv Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="sms_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">SMS DETAILS</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="comitee_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">COMMITTEE DETAILS</span> 

                                </a>

                            </li>

                             

                            

                            <li class="nav-item">

                                <a href="nottice_letter.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Notice Letter</span> 

                                </a>

                            </li>

                            

                            <li class="nav-item">

                                <a href="change_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Change Password</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="change_trans_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Change Trans Password</span> 

                                </a>

                            </li>

                           

                        </ul>

                    </div>

                </div>

            </div>

			<!-- start page content -->

            <div class="page-content-wrapper">

                <div class="page-content">

                    <div class="page-bar">

                        <div class="page-title-breadcrumb">

                           

                            <ol class="breadcrumb page-breadcrumb pull-right">

                                <li><i class="fa fa-home"></i>&nbsp;<a class="parent-item" href="main_home.php">Home</a>&nbsp;<i class="fa fa-angle-right"></i>

                                </li>

                                

                                </li>

                                <li class="active">Genealogy View</li>

                            </ol>

                        </div>

                    </div>

                    <div class="row">

                                <div class="col-sm-12">

                                    <div class="card card-topline-green">

                                        

                                        <div class="card-body ">

                                            <div class="table-scrollable">

                                                <table class="table">

                                                    

                                                    <tbody>

                                                        <tr>

                                                            <td>

                                                                

                                                                <div class="tree_1">  

                                                                      <ul>

                                                                        <li>

                                                                          <a href="javascript:;" class="link tooltips" data-placement="top" data-original-title="<?= $member_no; ?> - <?= $name; ?>"></a>



                                                                          

                                                                          <ul>

                                                                            <?php 

                                                                                 

                                                                                 $select_query_main = "select * from member_tree where group_number = '$group_number_main_1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1}%' AND x_position='$x_position_main_1' ORDER BY x_position ASC, tree_id ASC limit 3";

                                                                                  $run_main = mysqli_query($con,$select_query_main);

                                                                                   

                                                                                   while ($row_main = mysqli_fetch_array($run_main)) {

                                                                                    $tree_id_main = $row_main['tree_id'];                                    

                                                                                    $group_number_main = $row_main['group_number'];

                                                                                    $member_no_main = $row_main['member_no'];

                                                                                    $sponsor_no_main = $row_main['sponsor_no'];

                                                                                    $level_no_main = $row_main['level_no'];

                                                                                    $relation_ship_no_main = $row_main['relation_ship_no'];

                                                                                    $x_position_main = $row_main['x_position']+1;



                                                                                    $select_query_get_name = "select * from member where member_no='$member_no_main'";

                                                                                     $run_get_name = mysqli_query($con,$select_query_get_name);

                                                                                     

                                                                                     while ($row_get_name = mysqli_fetch_array($run_get_name)) {

                                                                                      $name_get_name = $row_get_name['name'];

                                                                                    }

                                                                             ?>

                                                                            <li><a href="member_tree_sub.php?member_no=<?= $member_no_main; ?>" class="link tooltips" data-placement="top" data-original-title="<?= $member_no_main; ?> - <?= $name_get_name; ?>"></a>

                                                                              

                                                                                <ul>

                                                                                  <?php 

                                                                                 

                                                                                     $select_query_child = "select * from member_tree where group_number = '$group_number_main' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position='$x_position_main' ORDER BY x_position ASC, tree_id ASC limit 3";

                                                                                      $run_child = mysqli_query($con,$select_query_child);

                                                                                       

                                                                                       while ($row_child = mysqli_fetch_array($run_child)) {

                                                                                        $tree_id_child = $row_child['tree_id'];                                    

                                                                                        $group_number_child = $row_child['group_number'];

                                                                                        $member_no_child = $row_child['member_no'];

                                                                                        $sponsor_no_child = $row_child['sponsor_no'];

                                                                                        $level_no_child = $row_child['level_no'];

                                                                                        $relation_ship_no_main = $row_main['relation_ship_no'];

                                                                                        $select_query_get_name_1 = "select * from member where member_no='$member_no_child'";

                                                                                           $run_get_name_1 = mysqli_query($con,$select_query_get_name_1);

                                                                                           

                                                                                           while ($row_get_name_1 = mysqli_fetch_array($run_get_name_1)) {

                                                                                            $name_get_name_1 = $row_get_name_1['name'];

                                                                                          }

                                                                                 ?>

                                                                                  <li><a href="member_tree_sub.php?member_no=<?= $member_no_child; ?>"  class="link tooltips" data-placement="top" data-original-title="<?= $member_no_child; ?> - <?= $name_get_name_1; ?>"></a>

                                                                                    

                                                                                   



                                                                                  </li>



                                                                                <?php } ?>

                                                                                  

                                                                                </ul>

                                                                            </li>

                                                                            <?php } ?>

                                                                          </ul>

                                                                        </li>       



                                                                      </ul>

                                                              </div>



                                                            </td>

                                                            

                                                        </tr>

                                                        

                                                    </tbody>

                                                </table>

                                            </div>

                                        </div>

                                    </div>

                                </div>

                                

                            </div>

                    

                <!-- end page content -->

                

            </div>

            <!-- end page container -->

            <!-- start footer -->

            <div class="page-footer">

               <div class="page-footer-inner"> 2018 &copy; All Rights Reserved.

                    

                </div>

                <div class="scroll-to-top">

                    <i class="icon-arrow-up"></i>

                </div>

            </div>

            <!-- end footer -->

        </div></div>

        <!-- start js include path -->

        <script src="assets/plugins/jquery/jquery.min.js" ></script>

        <script src="assets/plugins/popper/popper.min.js" ></script>

        <script src="assets/plugins/jquery-blockui/jquery.blockui.min.js" ></script>

		<script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.min.js"></script>

        <!-- bootstrap -->

        <script src="assets/plugins/bootstrap/js/bootstrap.min.js" ></script>

        <!-- Common js-->

		<script src="assets/js/app.js" ></script>

        <script src="assets/js/layout.js" ></script>

		<script src="assets/js/theme-color.js" ></script>

		<!-- Material -->

		<script src="assets/plugins/material/material.min.js"></script>

	<!-- animation -->

	<script src="assets/js/pages/ui/animations.js" ></script>

        <!-- end js include path -->

</body>



</html>

<?php } } } } ?>