1#@!#!123s

: / home / rakcha / www / user /
Filename : downline.php
back
<?php error_reporting(0); ?>

<?php 

session_start();

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

    header("location: ../login.html");

 }

 else {

  include("includes/db.php");

       $page_user = $_SESSION['distributor_id'];

       $select_query = "select * from member where user_id='$page_user'";

       $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'];

        $user_id = $row['user_id'];

        $password = $row['password'];

        $contact_status = $row['contact_status'];



        $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'];

        $activity_level = $row['activity_level'];

        $activity_referral = $row['activity_referral'];

        $activity_date = $row['activity_date'];

        $activity_month = $row['activity_month'];



        $member_fess = $row['member_fess'];

        $elite_board = $row['elite_board'];



        $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_1 =$row['date_of_join'];

        $date_of_join = date('d-m-Y', strtotime($date_of_join_1));



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

        $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'];

          $user_id_main = $row_main['user_id'];

          $sponsor_no_main = $row_main['sponsor_no'];

          $relation_ship_no_main = $row_main['relation_ship_no'];

          $level_no_main = $row_main['level_no'];

          $x_position_main = $row_main['x_position'];

          $y_position_main = $row_main['y_position'];

          $roi_amount_main = $row_main['roi_amount'];

          $product_amount_main = $row_main['product_amount'];

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



          



  ?>



  <?php 



                                  $select_query_main_10a = "select * from roi_tree where group_number = '$group_number_main' AND member_no = '$member_no'";



                                    $run_main_10a = mysqli_query($con,$select_query_main_10a);



                                    $check_level_10a = mysqli_num_rows($run_main_10a);



                                    if ($check_level_10a > 0) {



                                    while ($row_main_10a = mysqli_fetch_array($run_main_10a)) {                                   



                                    $tree_id_main_10a = $row_main_10a['tree_id'];



                                    $group_number_main_10a = $row_main_10a['group_number'];



                                    $member_no_main_10a = $row_main_10a['member_no'];



                                    $sponsor_no_main_10a = $row_main_10a['sponsor_no'];



                                    $level_no_main_10a = $row_main_10a['level_no'];



                                    $relation_ship_no_main_10a = $row_main_10a['relation_ship_no'];



                                    $x_position_main_10a = $row_main_10a['x_position'];

                                    $roi_amount_main_10a = $row_main_10a['roi_amount'];

                                    $product_amount_main_10a = $row_main_10a['product_amount'];

                                    $x_position_main_my_10a = $row_main_10a['x_position']+1;

                                    $roi_status_main_my_10a = $row_main_10a['roi_status'];



                                    if ($roi_status_main_my_10a == 0) {

                                         $personal_pv_join = $roi_amount_main_10a;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;                                  

                                   $select_query_select_10a = "select * from member where member_no ='$member_no_main_10a'";



                                  $run_select_10a = mysqli_query($con,$select_query_select_10a);

                                    while ($row_select_10a = mysqli_fetch_array($run_select_10a)) {

                                    $name_row_select_10a = $row_select_10a['name'];

                                    $mobile_number_row_select_10a = $row_select_10a['mobile_number'];

                                    

                                    $user_id_row_select_10a = $row_select_10a['user_id'];

                                    $date_of_join_row_select_10a =$row_select_10a['date_of_join'];

                                    $city_district_row_select_10a =$row_select_10a['city_district'];                                    

                                    $state_row_select_10a =$row_select_10a['state'];

                                      }





                                 $current_xpoision_10a = $x_position_main_10a-$x_position_main;





                                 $arr1_10a = array();

                                  $select_query_findempty_pay_10a = "select * from roi_member where member_no = '$member_no_main_10a'";

                                  $run_findempty_pay_10a = mysqli_query($con,$select_query_findempty_pay_10a);

                                  while ($row_findempty_pay_10a = mysqli_fetch_array($run_findempty_pay_10a)) {

                                   $arr1_10a[] = $row_findempty_pay_10a['used_no'];

                                  }



                              $arr1_10a_pro = array();

                                  $select_query_findempty_pay_10a_pro = "select * from product_member where member_no = '$member_no_main_10a'";

                                  $run_findempty_pay_10a_pro = mysqli_query($con,$select_query_findempty_pay_10a_pro);

                                  while ($row_findempty_pay_10a_pro = mysqli_fetch_array($run_findempty_pay_10a_pro)) {

                                   $arr1_10a_pro[] = $row_findempty_pay_10a_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_10a = "select SUM(product_amount) from product_tree where member_no='$member_no_main_10a' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

                                  $run_per_product_x1_10a = mysqli_query($con,$select_query_per_product_x1_10a);

                                  while($row_per_product_x1_10a = mysqli_fetch_array($run_per_product_x1_10a)){

                                        $p_per_product_x1_10a = $row_per_product_x1_10a['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_10a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

                                  $run_cur_product_x1_10a = mysqli_query($con,$select_query_cur_product_x1_10a);

                                  while($row_cur_product_x1_10a = mysqli_fetch_array($run_cur_product_x1_10a)){

                                        $p_cur_product_x1_10a = $row_cur_product_x1_10a['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_10a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%'";

                                  $run_product_x1_10a = mysqli_query($con,$select_query_product_x1_10a);

                                  while($row_product_x1_10a = mysqli_fetch_array($run_product_x1_10a)){

                                        $p_product_x1_10a = $row_product_x1_10a['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                            

                              $select_query_total_x1_10a = "select SUM(product_amount), SUM(total_bv) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%'";

                                $run_total_x1_10a = mysqli_query($con,$select_query_total_x1_10a);

                                while($row_total_x1_10a = mysqli_fetch_array($run_total_x1_10a)){

                                      $total_x1_10a = $row_total_x1_10a['SUM(product_amount)'];

                                      $total_x1_10a_to = $row_total_x1_10a['SUM(total_bv)'];

                                      

                                }



                                $select_query_total_x1a_10a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND member_no not in (".implode(',', $arr1_10a).") AND member_no <> '$member_no_main_10a'";

                                $run_total_x1a_10a = mysqli_query($con,$select_query_total_x1a_10a);

                                while($row_total_x1a_10a = mysqli_fetch_array($run_total_x1a_10a)){

                                      $total_x1a_1_10a = $row_total_x1a_10a['SUM(roi_amount)'];

                                      

                                }

                                $total_x1a_10a = $total_x1a_1_10a+$p_cur_product_x1_10a+$total_personal_pv;





                                //group pv

                              $select_query_total_team_pv_10a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%'";

                              $run_total_team_pv_10a = mysqli_query($con,$select_query_total_team_pv_10a);

                              while($row_total_team_pv_10a = mysqli_fetch_array($run_total_team_pv_10a)){

                                    $total_team_pv_1_10a = $row_total_team_pv_10a['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_10a = $total_team_pv_1_10a+$p_product_x1_10a;

                            //group pv



                              //member details

                               $select_query_total_member_last_10a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a'";

                                $run_total_member_last_10a = mysqli_query($con,$select_query_total_member_last_10a);

                                $final_total_member_last_10a = mysqli_num_rows($run_total_member_last_10a);



                                $select_query_total_member_current_10a = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND member_no not in (".implode(',', $arr1_10a).") AND status='1'";

                                $run_total_member_current_10a = mysqli_query($con,$select_query_total_member_current_10a);

                                $final_total_member_current_10a = mysqli_num_rows($run_total_member_current_10a);



                                $previuos_add_10a = $final_total_member_last_10a-$final_total_member_current_10a;

                            //member details





                                $select_query_total_curt_10a = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main' AND x_position='$x_position_main_10a'";

                                $run_total_curt_10a = mysqli_query($con,$select_query_total_curt_10a);

                                while($row_total_curt_10a = mysqli_fetch_array($run_total_curt_10a)){

                                      $total_curt_10a = $row_total_curt_10a['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_10a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main' AND member_no not in (".implode(',', $arr1).") AND x_position='$x_position_main_10a'";

                                $run_total_curta_10a = mysqli_query($con,$select_query_total_curta_10a);

                                while($row_total_curta_10a = mysqli_fetch_array($run_total_curta_10a)){

                                      $total_curta_1_10a = $row_total_curta_10a['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_10a = $total_curta_1_10a+$total_curt_10a;





                                



                               if ($final_group_pv_10a < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_10a < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_10a < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_10a < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_10a < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per6 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='6'";

                                $run_total_member_get_per6 = mysqli_query($con,$select_query_total_member_get_per6);

                                $final_total_member_get_per6 = mysqli_num_rows($run_total_member_get_per6);



                                $select_query_total_member_get_per10 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='9'";

                                $run_total_member_get_per10 = mysqli_query($con,$select_query_total_member_get_per10);

                                $final_total_member_get_per10 = mysqli_num_rows($run_total_member_get_per10);





                                $select_query_total_member_get_per14 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='14'";

                                $run_total_member_get_per14 = mysqli_query($con,$select_query_total_member_get_per14);

                                $final_total_member_get_per14 = mysqli_num_rows($run_total_member_get_per14);





                                $select_query_total_member_get_per18 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='12'";

                                $run_total_member_get_per18 = mysqli_query($con,$select_query_total_member_get_per18);

                                $final_total_member_get_per18 = mysqli_num_rows($run_total_member_get_per18);





                                $select_query_total_member_get_per22 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='15'";

                                $run_total_member_get_per22 = mysqli_query($con,$select_query_total_member_get_per22);

                                $final_total_member_get_per22 = mysqli_num_rows($run_total_member_get_per22);



                                $select_query_total_member_get_per23 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a' AND percent='21'";

                                $run_total_member_get_per23 = mysqli_query($con,$select_query_total_member_get_per23);

                                $final_total_member_get_per23 = mysqli_num_rows($run_total_member_get_per23);



                               // get percent member



                                $select_query_growth_2 = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_10a}%' AND tree_id > '$tree_id_main_10a'";

                                $run_growth_2 = mysqli_query($con,$select_query_growth_2);

                                $check_level_growth_2 = mysqli_num_rows($run_growth_2);



                                $select_query_active_base = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main' AND x_position >= '$x_position_main_my' AND active_base='1'";

                                $run_active_base = mysqli_query($con,$select_query_active_base);

                                $check_level_active_base = mysqli_num_rows($run_active_base);

                                    

}

}

                                    



                               ?>

  <!DOCTYPE html>

<html lang="en">



<head>

  <meta charset="utf-8">

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

    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">

    <meta name="description" content="">

    <meta name="author" content="">

    <link rel="icon" href="images/fave.png">



    <title>Welcome - <?= $title; ?><?= $name; ?></title>

  

	<!-- Bootstrap v4.0.0-beta -->

	<link rel="stylesheet" href="assets/vendor_components/bootstrap/dist/css/bootstrap.min.css">



	<!-- Font Awesome -->

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



	<!-- Ionicons -->

	<link rel="stylesheet" href="assets/vendor_components/Ionicons/css/ionicons.min.css">



	<!-- Theme style -->

	<link rel="stylesheet" href="css/master_style.css">



	<!-- maximum_admin Skins. Choose a skin from the css/skins

	   folder instead of downloading all of them to reduce the load. -->

	<link rel="stylesheet" href="css/skins/_all-skins.css">	



	<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->

	<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->

	<!--[if lt IE 9]>

	<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>

	<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>

	<![endif]-->



	<!-- google font -->

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



</head>

<body class="hold-transition skin-blue sidebar-mini">

<div class="wrapper">



  <header class="main-header">

    <!-- Logo -->

    <a href="main_home.php" class="logo">

      <!-- mini logo for sidebar mini 50x50 pixels -->

      <span class="logo-mini"><img src="../images/resources/logo.png" style="max-width: 47px;padding-top: 3px;"></span>

      <!-- logo for regular state and mobile devices -->

      <span class="logo-lg"><img src="../images/resources/logo.png" style="max-width: 47px;padding-top: 3px;"></span>

    </a>

    <!-- Header Navbar: style can be found in header.less -->

    <nav class="navbar navbar-fixed-top">

      <!-- Sidebar toggle button-->

      <a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button">

        <span class="sr-only">Toggle navigation</span>

      </a>



      <div class="navbar-custom-menu">

        <ul class="nav navbar-nav">

          

          

           

          

          <!-- Notifications: style can be found in dropdown.less -->

          <li class="dropdown notifications-menu label-warning">

            <a href="#" class="dropdown-toggle" data-toggle="dropdown" style="color: #000;font-weight: 700;">

              

              <span class="d-sm-inline-block "><?= $title; ?><?= $name; ?> - <?= $user_id; ?> <i class="fa fa-angle-down pull-right" style="margin-top:8px;font-size:14px;"></i></span>

            </a>

             

          </li>

          

          <li>

            <a href="logout.php" class="link" data-toggle="tooltip" title="" data-original-title="Logout"><i class="fa fa-power-off"></i></a>

          </li>

        </ul>

      </div>

    </nav>

  </header>

  

  <!-- Left side column. contains the logo and sidebar -->

   <aside class="main-sidebar"  style="background-image: url('img/bg.jpg');background-position: left;background-attachment: fixed;">

    <!-- sidebar: style can be found in sidebar.less -->

    <section class="sidebar">

      

      

      <!-- sidebar menu: : style can be found in sidebar.less -->

      <ul class="sidebar-menu" data-widget="tree">

        

        <li><a href="main_home.php"><i class="fa fa-dashboard"></i> <span>DASHBOARD</span></a></li>

         

        

        <li class="treeview">

          <a href="#">

            <i class="fa fa-users"></i>

            <span>GENEALOGY TREE</span>

            <span class="pull-right-container">

              <i class="fa fa-angle-left pull-right"></i>

            </span>

          </a>

          <ul class="treeview-menu">

           

            <li><a href="main_home.php"><i class="fa fa-circle"></i> GENEALOGY TREE</a></li>

            <li><a href="direct_referrals.php"><i class="fa fa-circle-o"></i> DIRECT LEG</a></li>

            

          </ul>

        </li>



         

        

         

          

        <li><a href="logout.php"><i class="fa fa-sign-out"></i> <span>Logout</span></a></li>



        

        



      </ul>

    </section>

    

  </aside>



  <!-- Content Wrapper. Contains page content -->

  <div class="content-wrapper">

    <!-- Content Header (Page header) -->

    <!-- Content Header (Page header) -->

    <section class="content-header">

      <h4>

        <?= $title; ?><?= $name; ?>



           



      </h4>

      <ol class="breadcrumb">

        <li class="breadcrumb-item"><a href="main_home.php"><i class="fa fa-dashboard"></i> Home</a></li>

        <li class="breadcrumb-item active">Team List</li>

      </ol>

    </section>



   <section class="content">

    <div class="row">

        <div class="col-12">

               

               <div class="box">

                  <div class="box-header">

                    <h3 class="box-title">Team List</h3>

                    <a href="javascript:;" onclick="goBack()" style="margin: 7px;max-width: 100px;" class="btn btn-block btn-info btn-sm pull-right">Go Back</a>

                  </div>

                  <!-- /.box-header -->

                        <div class="box-body table-responsive no-padding">



                    <table id="example1" class="table table-bordered table-striped table-responsive" style="overflow: all;width: 100%;">



                      <thead>



                        <tr>

                          <th>View</th>

                          <th>Level</th>

                          <th>RC ID</th>

                          <th>Name</th>

                          

                          <th>PBV</th>

                          <th>AGBV</th>

                          <th>PV %</th>

                          <th>CMGBV</th>

                          <th>CMSV</th>

                          <th>CM Mgr&abouve</th>

                          <th>Paid as Title</th>

                          <th>Star Title</th>

                          <th>Founder Title</th>

                          <th>Rolling Title</th>

                          <th>6%</th>

                          <th>9%</th>

                          <th>14%</th> 





                           <th>New Join</th>

                           <th>Active Base</th>

                           <th>Total Consultant</th>

                          

                          

                          

                           <th>Joining Date</th>



                           <th>City</th>

                          <?php if ($contact_status == 1) { ?>

                           <th>Contact No</th>

                           <?php } ?>

                           

                            <th>State</th>

                          



                        </tr>



                      </thead>



                      



                            <tbody>



                              <tr class="gradeX">

                                <td></td>



                                <td>0</td>



                             

                                <td><?= $user_id_row_select_10a; ?></td>

                                <td><?= $name_row_select_10a; ?></td>

                                

                                

                                <td><?= $total_personal_pv+$p_per_product_x1_10a; ?></td>

                                <td><?= $final_group_pv_10a; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1a_10a; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_2; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per6; ?></td>

                                <td><?= $final_total_member_get_per10; ?></td>

                                <td><?= $final_total_member_get_per14; ?></td>





                                <td><?= $final_total_member_current_10a; ?></td>

                                <td><?= $check_level_active_base+$final_total_member_current_10a; ?></td>

                                <td><?= $final_total_member_last_10a; ?></td> 





                                

                                <td><?= $date_of_join_row_select_10a; ?></td>

                                <td><?= $city_district_row_select_10a; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_10a; ?></td>

                                <?php } ?>

                                <td><?= $state_row_select_10a; ?></td>

                                

                                

                              </tr>

                              <?php 



                                  $select_query_main_1a = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main_my' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";



                                    $run_main_1a = mysqli_query($con,$select_query_main_1a);



                                    $check_level_1a = mysqli_num_rows($run_main_1a);



                                    if ($check_level_1a > 0) {



                                    while ($row_main_1a = mysqli_fetch_array($run_main_1a)) {                                   



                                    $tree_id_main_1a = $row_main_1a['tree_id'];



                                    $group_number_main_1a = $row_main_1a['group_number'];



                                    $member_no_main_1a = $row_main_1a['member_no'];



                                    $sponsor_no_main_1a = $row_main_1a['sponsor_no'];



                                    $level_no_main_1a = $row_main_1a['level_no'];



                                    $relation_ship_no_main_1a = $row_main_1a['relation_ship_no'];



                                    $x_position_main_1a = $row_main_1a['x_position'];

                                    $roi_amount_main_1a = $row_main_1a['roi_amount'];

                                    $product_amount_main_1a = $row_main_1a['product_amount'];

                                    $x_position_main_my_1a = $row_main_1a['x_position']+1;



                                    $roi_status_main_my_1a = $row_main_1a['roi_status'];



                                    if ($roi_status_main_my_1a == 0) {

                                         $personal_pv_join = $roi_amount_main_1a;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1a = "select * from member where member_no ='$member_no_main_1a'";



                                  $run_select_1a = mysqli_query($con,$select_query_select_1a);

                                    while ($row_select_1a = mysqli_fetch_array($run_select_1a)) {

                                    $name_row_select_1a = $row_select_1a['name'];

                                    

                                    $user_id_row_select_1a = $row_select_1a['user_id'];

                                    $date_of_join_row_select_1a =$row_select_1a['date_of_join'];

                                    $city_district_row_select_1a =$row_select_1a['city_district'];

                                    $mobile_number_row_select_1a =$row_select_1a['mobile_number'];                                    

                                    $state_row_select_1a =$row_select_1a['state'];

                                      }





                                 $current_xpoision_1a = $x_position_main_1a-$x_position_main;





                                 $arr1_1a = array();

                                  $select_query_findempty_pay_1a = "select * from roi_member where member_no = '$member_no_main_1a'";

                                  $run_findempty_pay_1a = mysqli_query($con,$select_query_findempty_pay_1a);

                                  while ($row_findempty_pay_1a = mysqli_fetch_array($run_findempty_pay_1a)) {

                                   $arr1_1a[] = $row_findempty_pay_1a['used_no'];

                                  }





                              $arr1_1a_pro = array();

                                  $select_query_findempty_pay_1a_pro = "select * from product_member where member_no = '$member_no_main_1a'";

                                  $run_findempty_pay_1a_pro = mysqli_query($con,$select_query_findempty_pay_1a_pro);

                                  while ($row_findempty_pay_1a_pro = mysqli_fetch_array($run_findempty_pay_1a_pro)) {

                                   $arr1_1a_pro[] = $row_findempty_pay_1a_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1a = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1a' AND product_no not in (".implode(',', $arr1_1a_pro).") AND status='0'";

                                  $run_per_product_x1_1a = mysqli_query($con,$select_query_per_product_x1_1a);

                                  while($row_per_product_x1_1a = mysqli_fetch_array($run_per_product_x1_1a)){

                                        $p_per_product_x1_1a = $row_per_product_x1_1a['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND product_no not in (".implode(',', $arr1_1a_pro).") AND status='0'";

                                  $run_cur_product_x1_1a = mysqli_query($con,$select_query_cur_product_x1_1a);

                                  while($row_cur_product_x1_1a = mysqli_fetch_array($run_cur_product_x1_1a)){

                                        $p_cur_product_x1_1a = $row_cur_product_x1_1a['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1a = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%'";

                                  $run_product_x1_1a = mysqli_query($con,$select_query_product_x1_1a);

                                  while($row_product_x1_1a = mysqli_fetch_array($run_product_x1_1a)){

                                        $p_product_x1_1a = $row_product_x1_1a['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%'";

                              $run_total_team_pv_1a = mysqli_query($con,$select_query_total_team_pv_1a);

                              while($row_total_team_pv_1a = mysqli_fetch_array($run_total_team_pv_1a)){

                                    $total_team_pv_1_1a = $row_total_team_pv_1a['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1a = $total_team_pv_1_1a+$p_product_x1_1a;

                            //group pv

                            

                              



                                $select_query_total_x1a_1a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND member_no not in (".implode(',', $arr1_1a).")";

                                $run_total_x1a_1a = mysqli_query($con,$select_query_total_x1a_1a);

                                while($row_total_x1a_1a = mysqli_fetch_array($run_total_x1a_1a)){

                                      $total_x1a_1_1a = $row_total_x1a_1a['SUM(roi_amount)'];

                                      

                                }

                                $total_x1a_1a = $total_x1a_1_1a+$p_cur_product_x1_1a+$personal_pv_join;





                              



                              //member details

                               $select_query_total_member_last_1a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a'";

                                $run_total_member_last_1a = mysqli_query($con,$select_query_total_member_last_1a);

                                $final_total_member_last_1a = mysqli_num_rows($run_total_member_last_1a);



                                $select_query_total_member_current_1a = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND member_no not in (".implode(',', $arr1_1a).") AND status='1'";

                                $run_total_member_current_1a = mysqli_query($con,$select_query_total_member_current_1a);

                                $final_total_member_current_1a = mysqli_num_rows($run_total_member_current_1a);



                                $previuos_add_1a = $final_total_member_last_1a-$final_total_member_current_1a;

                            //member details





                                $select_query_total_curt_1a = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND x_position='$x_position_main_1a'";

                                $run_total_curt_1a = mysqli_query($con,$select_query_total_curt_1a);

                                while($row_total_curt_1a = mysqli_fetch_array($run_total_curt_1a)){

                                      $total_curt_1a = $row_total_curt_1a['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1a = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND member_no not in (".implode(',', $arr1_1a).") AND x_position='$x_position_main_1a'";

                                $run_total_curta_1a = mysqli_query($con,$select_query_total_curta_1a);

                                while($row_total_curta_1a = mysqli_fetch_array($run_total_curta_1a)){

                                      $total_curta_1_1a = $row_total_curta_1a['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1a = $total_curta_1_1a+$total_curt_1a;





                                 



                               if ($final_group_pv_1a < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1a < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1a < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1a < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1a < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND percent='3'";

                                $run_total_member_get_per61a = mysqli_query($con,$select_query_total_member_get_per61a);

                                $final_total_member_get_per61a = mysqli_num_rows($run_total_member_get_per61a);



                                $select_query_total_member_get_per101a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND percent='6'";

                                $run_total_member_get_per101a = mysqli_query($con,$select_query_total_member_get_per101a);

                                $final_total_member_get_per101a = mysqli_num_rows($run_total_member_get_per101a);





                                $select_query_total_member_get_per141a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND percent='9'";

                                $run_total_member_get_per141a = mysqli_query($con,$select_query_total_member_get_per141a);

                                $final_total_member_get_per141a = mysqli_num_rows($run_total_member_get_per141a);





                                $select_query_total_member_get_per181a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND percent='12'";

                                $run_total_member_get_per181a = mysqli_query($con,$select_query_total_member_get_per181a);

                                $final_total_member_get_per181a = mysqli_num_rows($run_total_member_get_per181a);





                                $select_query_total_member_get_per221a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND percent='15'";

                                $run_total_member_get_per221a = mysqli_query($con,$select_query_total_member_get_per221a);

                                $final_total_member_get_per221a = mysqli_num_rows($run_total_member_get_per221a);



                                $select_query_total_member_get_per231a = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND percent='21'";

                                $run_total_member_get_per231a = mysqli_query($con,$select_query_total_member_get_per231a);

                                $final_total_member_get_per231a = mysqli_num_rows($run_total_member_get_per231a);



                                $select_query_growth_1a = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a'";

                                $run_growth_1a = mysqli_query($con,$select_query_growth_1a);

                                $check_level_growth_1a = mysqli_num_rows($run_growth_1a);



                               // get percent member





                                $select_query_active_base_1a = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a' AND x_position >= '$x_position_main_my_1a' AND active_base='1'";

                                $run_active_base_1a = mysqli_query($con,$select_query_active_base_1a);

                                $check_level_active_base_1a = mysqli_num_rows($run_active_base_1a);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1a; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1a; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1a; ?></td>



                             

                                <td><?= $user_id_row_select_1a; ?></td>

                                <td><?= $name_row_select_1a; ?></td>

                                <td><?= $city_district_row_select_1a; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1a; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1a; ?></td>

                                <td><?= $final_total_member_current_1a; ?></td>

                                <td><?= $final_total_member_last_1a; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1a; ?></td>

                                <td><?= $final_group_pv_1a; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1a_1a; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1a; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61a; ?></td>

                                <td><?= $final_total_member_get_per101a; ?></td>

                                <td><?= $final_total_member_get_per141a; ?></td>

                                <td><?= $final_total_member_get_per181a; ?></td>

                                <td><?= $final_total_member_get_per221a; ?></td>

                                <td><?= $final_total_member_get_per231a; ?></td>



                                

                                <td><?= $date_of_join_row_select_1a; ?></td>

                                <td><?= $state_row_select_1a; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1b = "select * from roi_tree where group_number = '$group_number_main_1a' AND x_position = '$x_position_main_my_1a' AND relation_ship_no LIKE '%{$relation_ship_no_main_1a}%' AND tree_id > '$tree_id_main_1a'";



                                    $run_main_1b = mysqli_query($con,$select_query_main_1b);



                                    $check_level_1b = mysqli_num_rows($run_main_1b);



                                    if ($check_level_1b > 0) {



                                    while ($row_main_1b = mysqli_fetch_array($run_main_1b)) {                                   



                                    $tree_id_main_1b = $row_main_1b['tree_id'];



                                    $group_number_main_1b = $row_main_1b['group_number'];



                                    $member_no_main_1b = $row_main_1b['member_no'];



                                    $sponsor_no_main_1b = $row_main_1b['sponsor_no'];



                                    $level_no_main_1b = $row_main_1b['level_no'];



                                    $relation_ship_no_main_1b = $row_main_1b['relation_ship_no'];



                                    $x_position_main_1b = $row_main_1b['x_position'];

                                    $roi_amount_main_1b = $row_main_1b['roi_amount'];

                                    $product_amount_main_1b = $row_main_1b['product_amount'];

                                    $x_position_main_my_1b = $row_main_1b['x_position']+1;



                                    $roi_status_main_my_1b = $row_main_1b['roi_status'];



                                    if ($roi_status_main_my_1b == 0) {

                                         $personal_pv_join = $roi_amount_main_1b;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1b = "select * from member where member_no ='$member_no_main_1b'";



                                  $run_select_1b = mysqli_query($con,$select_query_select_1b);

                                    while ($row_select_1b = mysqli_fetch_array($run_select_1b)) {

                                    $name_row_select_1b = $row_select_1b['name'];

                                    

                                    $user_id_row_select_1b = $row_select_1b['user_id'];

                                    $date_of_join_row_select_1b =$row_select_1b['date_of_join'];

                                    $city_district_row_select_1b =$row_select_1b['city_district'];

                                    $mobile_number_row_select_1b =$row_select_1b['mobile_number'];                                    

                                    $state_row_select_1b =$row_select_1b['state'];

                                      }





                                 $current_xpoision_1b = $x_position_main_1b-$x_position_main;





                                 $arr1_1b = array();

                                  $select_query_findempty_pay_1b = "select * from roi_member where member_no = '$member_no_main_1b'";

                                  $run_findempty_pay_1b = mysqli_query($con,$select_query_findempty_pay_1b);

                                  while ($row_findempty_pay_1b = mysqli_fetch_array($run_findempty_pay_1b)) {

                                   $arr1_1b[] = $row_findempty_pay_1b['used_no'];

                                  }



                                  $arr1_1b_pro = array();

                                  $select_query_findempty_pay_1b_pro = "select * from product_member where member_no = '$member_no_main_1b'";

                                  $run_findempty_pay_1b_pro = mysqli_query($con,$select_query_findempty_pay_1b_pro);

                                  while ($row_findempty_pay_1b_pro = mysqli_fetch_array($run_findempty_pay_1b_pro)) {

                                   $arr1_1b_pro[] = $row_findempty_pay_1b_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1b = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1b' AND product_no not in (".implode(',', $arr1_1b_pro).") AND status='0'";

                                  $run_per_product_x1_1b = mysqli_query($con,$select_query_per_product_x1_1b);

                                  while($row_per_product_x1_1b = mysqli_fetch_array($run_per_product_x1_1b)){

                                        $p_per_product_x1_1b = $row_per_product_x1_1b['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1b = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND product_no not in (".implode(',', $arr1_1b_pro).") AND status='0'";

                                  $run_cur_product_x1_1b = mysqli_query($con,$select_query_cur_product_x1_1b);

                                  while($row_cur_product_x1_1b = mysqli_fetch_array($run_cur_product_x1_1b)){

                                        $p_cur_product_x1_1b = $row_cur_product_x1_1b['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1b = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%'";

                                  $run_product_x1_1b = mysqli_query($con,$select_query_product_x1_1b);

                                  while($row_product_x1_1b = mysqli_fetch_array($run_product_x1_1b)){

                                        $p_product_x1_1b = $row_product_x1_1b['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1b = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%'";

                              $run_total_team_pv_1b = mysqli_query($con,$select_query_total_team_pv_1b);

                              while($row_total_team_pv_1b = mysqli_fetch_array($run_total_team_pv_1b)){

                                    $total_team_pv_1_1b = $row_total_team_pv_1b['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1b = $total_team_pv_1_1b+$p_product_x1_1b;

                            //group pv

                            

                              



                                $select_query_total_x1b_1b = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND member_no not in (".implode(',', $arr1_1b).")";

                                $run_total_x1b_1b = mysqli_query($con,$select_query_total_x1b_1b);

                                while($row_total_x1b_1b = mysqli_fetch_array($run_total_x1b_1b)){

                                      $total_x1b_1_1b = $row_total_x1b_1b['SUM(roi_amount)'];

                                      

                                }

                                $total_x1b_1b = $total_x1b_1_1b+$p_cur_product_x1_1b+$personal_pv_join;





                                



                              //member details

                               $select_query_total_member_last_1b = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b'";

                                $run_total_member_last_1b = mysqli_query($con,$select_query_total_member_last_1b);

                                $final_total_member_last_1b = mysqli_num_rows($run_total_member_last_1b);



                                $select_query_total_member_current_1b = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND member_no not in (".implode(',', $arr1_1b).") AND status='1'";

                                $run_total_member_current_1b = mysqli_query($con,$select_query_total_member_current_1b);

                                $final_total_member_current_1b = mysqli_num_rows($run_total_member_current_1b);



                                $previuos_add_1b = $final_total_member_last_1b-$final_total_member_current_1b;

                            //member details





                                $select_query_total_curt_1b = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND x_position='$x_position_main_1b'";

                                $run_total_curt_1b = mysqli_query($con,$select_query_total_curt_1b);

                                while($row_total_curt_1b = mysqli_fetch_array($run_total_curt_1b)){

                                      $total_curt_1b = $row_total_curt_1b['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1b = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND member_no not in (".implode(',', $arr1_1b).") AND x_position='$x_position_main_1b'";

                                $run_total_curta_1b = mysqli_query($con,$select_query_total_curta_1b);

                                while($row_total_curta_1b = mysqli_fetch_array($run_total_curta_1b)){

                                      $total_curta_1_1b = $row_total_curta_1b['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1b = $total_curta_1_1b+$total_curt_1b;





                                 if ($final_group_pv_1b < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1b < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1b < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1b < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1b < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61b = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND percent='3'";

                                $run_total_member_get_per61b = mysqli_query($con,$select_query_total_member_get_per61b);

                                $final_total_member_get_per61b = mysqli_num_rows($run_total_member_get_per61b);



                                $select_query_total_member_get_per101b = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND percent='6'";

                                $run_total_member_get_per101b = mysqli_query($con,$select_query_total_member_get_per101b);

                                $final_total_member_get_per101b = mysqli_num_rows($run_total_member_get_per101b);





                                $select_query_total_member_get_per141b = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND percent='9'";

                                $run_total_member_get_per141b = mysqli_query($con,$select_query_total_member_get_per141b);

                                $final_total_member_get_per141b = mysqli_num_rows($run_total_member_get_per141b);





                                $select_query_total_member_get_per181b = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND percent='12'";

                                $run_total_member_get_per181b = mysqli_query($con,$select_query_total_member_get_per181b);

                                $final_total_member_get_per181b = mysqli_num_rows($run_total_member_get_per181b);





                                $select_query_total_member_get_per221b = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND percent='15'";

                                $run_total_member_get_per221b = mysqli_query($con,$select_query_total_member_get_per221b);

                                $final_total_member_get_per221b = mysqli_num_rows($run_total_member_get_per221b);



                                $select_query_total_member_get_per231b = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND percent='21'";

                                $run_total_member_get_per231b = mysqli_query($con,$select_query_total_member_get_per231b);

                                $final_total_member_get_per231b = mysqli_num_rows($run_total_member_get_per231b);





                                $select_query_growth_1b = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b'";

                                $run_growth_1b = mysqli_query($con,$select_query_growth_1b);

                                $check_level_growth_1b = mysqli_num_rows($run_growth_1b);



                               // get percent member



                                $select_query_active_base_1b = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b' AND x_position >= '$x_position_main_my_1b' AND active_base='1'";

                                $run_active_base_1b = mysqli_query($con,$select_query_active_base_1b);

                                $check_level_active_base_1b = mysqli_num_rows($run_active_base_1b);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1b; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1b; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1b; ?></td>



                             

                                <td><?= $user_id_row_select_1b; ?></td>

                                <td><?= $name_row_select_1b; ?></td>

                                <td><?= $city_district_row_select_1b; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1b; ?></td>

                                <?php } ?>



                                <td><?= $check_level_active_base_1b; ?></td>



                                <td><?= $final_total_member_current_1b; ?></td>

                                <td><?= $final_total_member_last_1b; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1b; ?></td>

                                <td><?= $final_group_pv_1b; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1b_1b; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1b; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61b; ?></td>

                                <td><?= $final_total_member_get_per101b; ?></td>

                                <td><?= $final_total_member_get_per141b; ?></td>

                                <td><?= $final_total_member_get_per181b; ?></td>

                                <td><?= $final_total_member_get_per221b; ?></td>

                                <td><?= $final_total_member_get_per231b; ?></td>



                                

                                <td><?= $date_of_join_row_select_1b; ?></td>

                                <td><?= $state_row_select_1b; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1c = "select * from roi_tree where group_number = '$group_number_main_1b' AND x_position = '$x_position_main_my_1b' AND relation_ship_no LIKE '%{$relation_ship_no_main_1b}%' AND tree_id > '$tree_id_main_1b'";



                                    $run_main_1c = mysqli_query($con,$select_query_main_1c);



                                    $check_level_1c = mysqli_num_rows($run_main_1c);



                                    if ($check_level_1c > 0) {



                                    while ($row_main_1c = mysqli_fetch_array($run_main_1c)) {                                   



                                    $tree_id_main_1c = $row_main_1c['tree_id'];



                                    $group_number_main_1c = $row_main_1c['group_number'];



                                    $member_no_main_1c = $row_main_1c['member_no'];



                                    $sponsor_no_main_1c = $row_main_1c['sponsor_no'];



                                    $level_no_main_1c = $row_main_1c['level_no'];



                                    $relation_ship_no_main_1c = $row_main_1c['relation_ship_no'];



                                    $x_position_main_1c = $row_main_1c['x_position'];

                                    $roi_amount_main_1c = $row_main_1c['roi_amount'];

                                    $product_amount_main_1c = $row_main_1c['product_amount'];

                                    $x_position_main_my_1c = $row_main_1c['x_position']+1;



                                    $roi_status_main_my_1c = $row_main_1c['roi_status'];



                                    if ($roi_status_main_my_1c == 0) {

                                         $personal_pv_join = $roi_amount_main_1c;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1c = "select * from member where member_no ='$member_no_main_1c'";



                                  $run_select_1c = mysqli_query($con,$select_query_select_1c);

                                    while ($row_select_1c = mysqli_fetch_array($run_select_1c)) {

                                    $name_row_select_1c = $row_select_1c['name'];

                                    

                                    $user_id_row_select_1c = $row_select_1c['user_id'];

                                    $date_of_join_row_select_1c =$row_select_1c['date_of_join'];

                                    $city_district_row_select_1c =$row_select_1c['city_district'];

                                    $mobile_number_row_select_1c =$row_select_1c['mobile_number'];                                    

                                    $state_row_select_1c =$row_select_1c['state'];

                                      }





                                 $current_xpoision_1c = $x_position_main_1c-$x_position_main;





                                 $arr1_1c = array();

                                  $select_query_findempty_pay_1c = "select * from roi_member where member_no = '$member_no_main_1c'";

                                  $run_findempty_pay_1c = mysqli_query($con,$select_query_findempty_pay_1c);

                                  while ($row_findempty_pay_1c = mysqli_fetch_array($run_findempty_pay_1c)) {

                                   $arr1_1c[] = $row_findempty_pay_1c['used_no'];

                                  }



                                  $arr1_1c_pro = array();

                                  $select_query_findempty_pay_1c_pro = "select * from product_member where member_no = '$member_no_main_1c'";

                                  $run_findempty_pay_1c_pro = mysqli_query($con,$select_query_findempty_pay_1c_pro);

                                  while ($row_findempty_pay_1c_pro = mysqli_fetch_array($run_findempty_pay_1c_pro)) {

                                   $arr1_1c_pro[] = $row_findempty_pay_1c_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1c = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1c' AND product_no not in (".implode(',', $arr1_1c_pro).") AND status='0'";

                                  $run_per_product_x1_1c = mysqli_query($con,$select_query_per_product_x1_1c);

                                  while($row_per_product_x1_1c = mysqli_fetch_array($run_per_product_x1_1c)){

                                        $p_per_product_x1_1c = $row_per_product_x1_1c['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1c = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND product_no not in (".implode(',', $arr1_1c_pro).") AND status='0'";

                                  $run_cur_product_x1_1c = mysqli_query($con,$select_query_cur_product_x1_1c);

                                  while($row_cur_product_x1_1c = mysqli_fetch_array($run_cur_product_x1_1c)){

                                        $p_cur_product_x1_1c = $row_cur_product_x1_1c['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1c = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%'";

                                  $run_product_x1_1c = mysqli_query($con,$select_query_product_x1_1c);

                                  while($row_product_x1_1c = mysqli_fetch_array($run_product_x1_1c)){

                                        $p_product_x1_1c = $row_product_x1_1c['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1c = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%'";

                              $run_total_team_pv_1c = mysqli_query($con,$select_query_total_team_pv_1c);

                              while($row_total_team_pv_1c = mysqli_fetch_array($run_total_team_pv_1c)){

                                    $total_team_pv_1_1c = $row_total_team_pv_1c['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1c = $total_team_pv_1_1c+$p_product_x1_1c;

                            //group pv

                            

                              



                                $select_query_total_x1c_1c = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND member_no not in (".implode(',', $arr1_1c).")";

                                $run_total_x1c_1c = mysqli_query($con,$select_query_total_x1c_1c);

                                while($row_total_x1c_1c = mysqli_fetch_array($run_total_x1c_1c)){

                                      $total_x1c_1_1c = $row_total_x1c_1c['SUM(roi_amount)'];

                                      

                                }

                                $total_x1c_1c = $total_x1c_1_1c+$p_cur_product_x1_1c+$personal_pv_join;





                                



                              //member details

                               $select_query_total_member_last_1c = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c'";

                                $run_total_member_last_1c = mysqli_query($con,$select_query_total_member_last_1c);

                                $final_total_member_last_1c = mysqli_num_rows($run_total_member_last_1c);



                                $select_query_total_member_current_1c = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND member_no not in (".implode(',', $arr1_1c).") AND status='1'";

                                $run_total_member_current_1c = mysqli_query($con,$select_query_total_member_current_1c);

                                $final_total_member_current_1c = mysqli_num_rows($run_total_member_current_1c);



                                $previuos_add_1c = $final_total_member_last_1c-$final_total_member_current_1c;

                            //member details





                                $select_query_total_curt_1c = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND x_position='$x_position_main_1c'";

                                $run_total_curt_1c = mysqli_query($con,$select_query_total_curt_1c);

                                while($row_total_curt_1c = mysqli_fetch_array($run_total_curt_1c)){

                                      $total_curt_1c = $row_total_curt_1c['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1c = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND member_no not in (".implode(',', $arr1_1c).") AND x_position='$x_position_main_1c'";

                                $run_total_curta_1c = mysqli_query($con,$select_query_total_curta_1c);

                                while($row_total_curta_1c = mysqli_fetch_array($run_total_curta_1c)){

                                      $total_curta_1_1c = $row_total_curta_1c['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1c = $total_curta_1_1c+$total_curt_1c;





                                if ($final_group_pv_1c < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1c < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1c < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1c < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1c < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61c = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND percent='3'";

                                $run_total_member_get_per61c = mysqli_query($con,$select_query_total_member_get_per61c);

                                $final_total_member_get_per61c = mysqli_num_rows($run_total_member_get_per61c);



                                $select_query_total_member_get_per101c = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND percent='6'";

                                $run_total_member_get_per101c = mysqli_query($con,$select_query_total_member_get_per101c);

                                $final_total_member_get_per101c = mysqli_num_rows($run_total_member_get_per101c);





                                $select_query_total_member_get_per141c = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND percent='9'";

                                $run_total_member_get_per141c = mysqli_query($con,$select_query_total_member_get_per141c);

                                $final_total_member_get_per141c = mysqli_num_rows($run_total_member_get_per141c);





                                $select_query_total_member_get_per181c = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND percent='12'";

                                $run_total_member_get_per181c = mysqli_query($con,$select_query_total_member_get_per181c);

                                $final_total_member_get_per181c = mysqli_num_rows($run_total_member_get_per181c);





                                $select_query_total_member_get_per221c = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND percent='15'";

                                $run_total_member_get_per221c = mysqli_query($con,$select_query_total_member_get_per221c);

                                $final_total_member_get_per221c = mysqli_num_rows($run_total_member_get_per221c);





                                $select_query_total_member_get_per231c = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND percent='21'";

                                $run_total_member_get_per231c = mysqli_query($con,$select_query_total_member_get_per231c);

                                $final_total_member_get_per231c = mysqli_num_rows($run_total_member_get_per231c);



                                $select_query_growth_1c = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c'";

                                $run_growth_1c = mysqli_query($con,$select_query_growth_1c);

                                $check_level_growth_1c = mysqli_num_rows($run_growth_1c);



                               // get percent member





                                $select_query_active_base_1c = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c' AND x_position >= '$x_position_main_my_1c' AND active_base='1'";

                                $run_active_base_1c = mysqli_query($con,$select_query_active_base_1c);

                                $check_level_active_base_1c = mysqli_num_rows($run_active_base_1c);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1c; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1c; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1c; ?></td>



                             

                                <td><?= $user_id_row_select_1c; ?></td>

                                <td><?= $name_row_select_1c; ?></td>

                                <td><?= $city_district_row_select_1c; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1c; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1c; ?></td>

                                <td><?= $final_total_member_current_1c; ?></td>

                                <td><?= $final_total_member_last_1c; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1c; ?></td>

                                <td><?= $final_group_pv_1c; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1c_1c; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1c; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61c; ?></td>

                                <td><?= $final_total_member_get_per101c; ?></td>

                                <td><?= $final_total_member_get_per141c; ?></td>

                                <td><?= $final_total_member_get_per181c; ?></td>

                                <td><?= $final_total_member_get_per221c; ?></td>

                                <td><?= $final_total_member_get_per231c; ?></td>



                                

                                <td><?= $date_of_join_row_select_1c; ?></td>

                                <td><?= $state_row_select_1c; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1d = "select * from roi_tree where group_number = '$group_number_main_1c' AND x_position = '$x_position_main_my_1c' AND relation_ship_no LIKE '%{$relation_ship_no_main_1c}%' AND tree_id > '$tree_id_main_1c'";



                                    $run_main_1d = mysqli_query($con,$select_query_main_1d);



                                    $check_level_1d = mysqli_num_rows($run_main_1d);



                                    if ($check_level_1d > 0) {



                                    while ($row_main_1d = mysqli_fetch_array($run_main_1d)) {                                   



                                    $tree_id_main_1d = $row_main_1d['tree_id'];



                                    $group_number_main_1d = $row_main_1d['group_number'];



                                    $member_no_main_1d = $row_main_1d['member_no'];



                                    $sponsor_no_main_1d = $row_main_1d['sponsor_no'];



                                    $level_no_main_1d = $row_main_1d['level_no'];



                                    $relation_ship_no_main_1d = $row_main_1d['relation_ship_no'];



                                    $x_position_main_1d = $row_main_1d['x_position'];

                                    $roi_amount_main_1d = $row_main_1d['roi_amount'];

                                    $product_amount_main_1d = $row_main_1d['product_amount'];

                                    $x_position_main_my_1d = $row_main_1d['x_position']+1;



                                    $roi_status_main_my_1d = $row_main_1d['roi_status'];



                                    if ($roi_status_main_my_1d == 0) {

                                         $personal_pv_join = $roi_amount_main_1d;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1d = "select * from member where member_no ='$member_no_main_1d'";



                                  $run_select_1d = mysqli_query($con,$select_query_select_1d);

                                    while ($row_select_1d = mysqli_fetch_array($run_select_1d)) {

                                    $name_row_select_1d = $row_select_1d['name'];

                                    

                                    $user_id_row_select_1d = $row_select_1d['user_id'];

                                    $date_of_join_row_select_1d =$row_select_1d['date_of_join'];

                                    $city_district_row_select_1d =$row_select_1d['city_district'];

                                    $mobile_number_row_select_1d =$row_select_1d['mobile_number'];                                    

                                    $state_row_select_1d =$row_select_1d['state'];

                                      }





                                 $current_xpoision_1d = $x_position_main_1d-$x_position_main;





                                 $arr1_1d = array();

                                  $select_query_findempty_pay_1d = "select * from roi_member where member_no = '$member_no_main_1d'";

                                  $run_findempty_pay_1d = mysqli_query($con,$select_query_findempty_pay_1d);

                                  while ($row_findempty_pay_1d = mysqli_fetch_array($run_findempty_pay_1d)) {

                                   $arr1_1d[] = $row_findempty_pay_1d['used_no'];

                                  }



                                  $arr1_1d_pro = array();

                                  $select_query_findempty_pay_1d_pro = "select * from product_member where member_no = '$member_no_main_1d'";

                                  $run_findempty_pay_1d_pro = mysqli_query($con,$select_query_findempty_pay_1d_pro);

                                  while ($row_findempty_pay_1d_pro = mysqli_fetch_array($run_findempty_pay_1d_pro)) {

                                   $arr1_1d_pro[] = $row_findempty_pay_1d_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1d = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1d' AND product_no not in (".implode(',', $arr1_1d_pro).") AND status='0'";

                                  $run_per_product_x1_1d = mysqli_query($con,$select_query_per_product_x1_1d);

                                  while($row_per_product_x1_1d = mysqli_fetch_array($run_per_product_x1_1d)){

                                        $p_per_product_x1_1d = $row_per_product_x1_1d['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1d = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND product_no not in (".implode(',', $arr1_1d_pro).") AND status='0'";

                                  $run_cur_product_x1_1d = mysqli_query($con,$select_query_cur_product_x1_1d);

                                  while($row_cur_product_x1_1d = mysqli_fetch_array($run_cur_product_x1_1d)){

                                        $p_cur_product_x1_1d = $row_cur_product_x1_1d['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1d = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%'";

                                  $run_product_x1_1d = mysqli_query($con,$select_query_product_x1_1d);

                                  while($row_product_x1_1d = mysqli_fetch_array($run_product_x1_1d)){

                                        $p_product_x1_1d = $row_product_x1_1d['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1d = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%'";

                              $run_total_team_pv_1d = mysqli_query($con,$select_query_total_team_pv_1d);

                              while($row_total_team_pv_1d = mysqli_fetch_array($run_total_team_pv_1d)){

                                    $total_team_pv_1_1d = $row_total_team_pv_1d['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1d = $total_team_pv_1_1d+$p_product_x1_1d;

                            //group pv

                            

                              



                                $select_query_total_x1d_1d = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND member_no not in (".implode(',', $arr1_1d).")";

                                $run_total_x1d_1d = mysqli_query($con,$select_query_total_x1d_1d);

                                while($row_total_x1d_1d = mysqli_fetch_array($run_total_x1d_1d)){

                                      $total_x1d_1_1d = $row_total_x1d_1d['SUM(roi_amount)'];

                                      

                                }

                                $total_x1d_1d = $total_x1d_1_1d+$p_cur_product_x1_1d+$personal_pv_join;





                                



                              //member details

                               $select_query_total_member_last_1d = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d'";

                                $run_total_member_last_1d = mysqli_query($con,$select_query_total_member_last_1d);

                                $final_total_member_last_1d = mysqli_num_rows($run_total_member_last_1d);



                                $select_query_total_member_current_1d = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND member_no not in (".implode(',', $arr1_1d).") AND status='1'";

                                $run_total_member_current_1d = mysqli_query($con,$select_query_total_member_current_1d);

                                $final_total_member_current_1d = mysqli_num_rows($run_total_member_current_1d);



                                $previuos_add_1d = $final_total_member_last_1d-$final_total_member_current_1d;

                            //member details





                                $select_query_total_curt_1d = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND x_position='$x_position_main_1d'";

                                $run_total_curt_1d = mysqli_query($con,$select_query_total_curt_1d);

                                while($row_total_curt_1d = mysqli_fetch_array($run_total_curt_1d)){

                                      $total_curt_1d = $row_total_curt_1d['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1d = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND member_no not in (".implode(',', $arr1_1d).") AND x_position='$x_position_main_1d'";

                                $run_total_curta_1d = mysqli_query($con,$select_query_total_curta_1d);

                                while($row_total_curta_1d = mysqli_fetch_array($run_total_curta_1d)){

                                      $total_curta_1_1d = $row_total_curta_1d['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1d = $total_curta_1_1d+$total_curt_1d;





                                if ($final_group_pv_1d < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1d < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1d < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1d < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1d < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61d = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND percent='3'";

                                $run_total_member_get_per61d = mysqli_query($con,$select_query_total_member_get_per61d);

                                $final_total_member_get_per61d = mysqli_num_rows($run_total_member_get_per61d);



                                $select_query_total_member_get_per101d = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND percent='6'";

                                $run_total_member_get_per101d = mysqli_query($con,$select_query_total_member_get_per101d);

                                $final_total_member_get_per101d = mysqli_num_rows($run_total_member_get_per101d);





                                $select_query_total_member_get_per141d = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND percent='9'";

                                $run_total_member_get_per141d = mysqli_query($con,$select_query_total_member_get_per141d);

                                $final_total_member_get_per141d = mysqli_num_rows($run_total_member_get_per141d);





                                $select_query_total_member_get_per181d = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND percent='12'";

                                $run_total_member_get_per181d = mysqli_query($con,$select_query_total_member_get_per181d);

                                $final_total_member_get_per181d = mysqli_num_rows($run_total_member_get_per181d);





                                $select_query_total_member_get_per221d = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND percent='15'";

                                $run_total_member_get_per221d = mysqli_query($con,$select_query_total_member_get_per221d);

                                $final_total_member_get_per221d = mysqli_num_rows($run_total_member_get_per221d);



                                $select_query_total_member_get_per231d = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND percent='21'";

                                $run_total_member_get_per231d = mysqli_query($con,$select_query_total_member_get_per231d);

                                $final_total_member_get_per231d = mysqli_num_rows($run_total_member_get_per231d);



                                $select_query_growth_1d = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d'";

                                $run_growth_1d = mysqli_query($con,$select_query_growth_1d);

                                $check_level_growth_1d = mysqli_num_rows($run_growth_1d);



                               // get percent member





                                $select_query_active_base_1d = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d' AND x_position >= '$x_position_main_my_1d' AND active_base='1'";

                                $run_active_base_1d = mysqli_query($con,$select_query_active_base_1d);

                                $check_level_active_base_1d = mysqli_num_rows($run_active_base_1d);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1d; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1d; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1d; ?></td>



                             

                                <td><?= $user_id_row_select_1d; ?></td>

                                <td><?= $name_row_select_1d; ?></td>

                                <td><?= $city_district_row_select_1d; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1d; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1d; ?></td>

                                <td><?= $final_total_member_current_1d; ?></td>

                                <td><?= $final_total_member_last_1d; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1d; ?></td>

                                <td><?= $final_group_pv_1d; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1d_1d; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1d; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61d; ?></td>

                                <td><?= $final_total_member_get_per101d; ?></td>

                                <td><?= $final_total_member_get_per141d; ?></td>

                                <td><?= $final_total_member_get_per181d; ?></td>

                                <td><?= $final_total_member_get_per221d; ?></td>

                                <td><?= $final_total_member_get_per231d; ?></td>



                                

                                <td><?= $date_of_join_row_select_1d; ?></td>

                                <td><?= $state_row_select_1d; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1e = "select * from roi_tree where group_number = '$group_number_main_1d' AND x_position = '$x_position_main_my_1d' AND relation_ship_no LIKE '%{$relation_ship_no_main_1d}%' AND tree_id > '$tree_id_main_1d'";



                                    $run_main_1e = mysqli_query($con,$select_query_main_1e);



                                    $check_level_1e = mysqli_num_rows($run_main_1e);



                                    if ($check_level_1e > 0) {



                                    while ($row_main_1e = mysqli_fetch_array($run_main_1e)) {                                   



                                    $tree_id_main_1e = $row_main_1e['tree_id'];



                                    $group_number_main_1e = $row_main_1e['group_number'];



                                    $member_no_main_1e = $row_main_1e['member_no'];



                                    $sponsor_no_main_1e = $row_main_1e['sponsor_no'];



                                    $level_no_main_1e = $row_main_1e['level_no'];



                                    $relation_ship_no_main_1e = $row_main_1e['relation_ship_no'];



                                    $x_position_main_1e = $row_main_1e['x_position'];

                                    $roi_amount_main_1e = $row_main_1e['roi_amount'];

                                    $product_amount_main_1e = $row_main_1e['product_amount'];

                                    $x_position_main_my_1e = $row_main_1e['x_position']+1;



                                    $roi_status_main_my_1e = $row_main_1e['roi_status'];



                                    if ($roi_status_main_my_1e == 0) {

                                         $personal_pv_join = $roi_amount_main_1e;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1e = "select * from member where member_no ='$member_no_main_1e'";



                                  $run_select_1e = mysqli_query($con,$select_query_select_1e);

                                    while ($row_select_1e = mysqli_fetch_array($run_select_1e)) {

                                    $name_row_select_1e = $row_select_1e['name'];

                                    

                                    $user_id_row_select_1e = $row_select_1e['user_id'];

                                    $date_of_join_row_select_1e =$row_select_1e['date_of_join'];

                                    $city_district_row_select_1e =$row_select_1e['city_district'];

                                    $mobile_number_row_select_1e =$row_select_1e['mobile_number'];                                    

                                    $state_row_select_1e =$row_select_1e['state'];

                                      }





                                 $current_xpoision_1e = $x_position_main_1e-$x_position_main;





                                 $arr1_1e = array();

                                  $select_query_findempty_pay_1e = "select * from roi_member where member_no = '$member_no_main_1e'";

                                  $run_findempty_pay_1e = mysqli_query($con,$select_query_findempty_pay_1e);

                                  while ($row_findempty_pay_1e = mysqli_fetch_array($run_findempty_pay_1e)) {

                                   $arr1_1e[] = $row_findempty_pay_1e['used_no'];

                                  }



                                  $arr1_1e_pro = array();

                                  $select_query_findempty_pay_1e_pro = "select * from product_member where member_no = '$member_no_main_1e'";

                                  $run_findempty_pay_1e_pro = mysqli_query($con,$select_query_findempty_pay_1e_pro);

                                  while ($row_findempty_pay_1e_pro = mysqli_fetch_array($run_findempty_pay_1e_pro)) {

                                   $arr1_1e_pro[] = $row_findempty_pay_1e_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1e = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1e' AND product_no not in (".implode(',', $arr1_1e_pro).") AND status='0'";

                                  $run_per_product_x1_1e = mysqli_query($con,$select_query_per_product_x1_1e);

                                  while($row_per_product_x1_1e = mysqli_fetch_array($run_per_product_x1_1e)){

                                        $p_per_product_x1_1e = $row_per_product_x1_1e['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1e = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND product_no not in (".implode(',', $arr1_1e_pro).") AND status='0'";

                                  $run_cur_product_x1_1e = mysqli_query($con,$select_query_cur_product_x1_1e);

                                  while($row_cur_product_x1_1e = mysqli_fetch_array($run_cur_product_x1_1e)){

                                        $p_cur_product_x1_1e = $row_cur_product_x1_1e['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1e = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%'";

                                  $run_product_x1_1e = mysqli_query($con,$select_query_product_x1_1e);

                                  while($row_product_x1_1e = mysqli_fetch_array($run_product_x1_1e)){

                                        $p_product_x1_1e = $row_product_x1_1e['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1e = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%'";

                              $run_total_team_pv_1e = mysqli_query($con,$select_query_total_team_pv_1e);

                              while($row_total_team_pv_1e = mysqli_fetch_array($run_total_team_pv_1e)){

                                    $total_team_pv_1_1e = $row_total_team_pv_1e['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1e = $total_team_pv_1_1e+$p_product_x1_1e;

                            //group pv

                            

                              



                                $select_query_total_x1e_1e = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND member_no not in (".implode(',', $arr1_1e).")";

                                $run_total_x1e_1e = mysqli_query($con,$select_query_total_x1e_1e);

                                while($row_total_x1e_1e = mysqli_fetch_array($run_total_x1e_1e)){

                                      $total_x1e_1_1e = $row_total_x1e_1e['SUM(roi_amount)'];

                                      

                                }

                                $total_x1e_1e = $total_x1e_1_1e+$p_cur_product_x1_1e+$personal_pv_join;





                                



                              //member details

                               $select_query_total_member_last_1e = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e'";

                                $run_total_member_last_1e = mysqli_query($con,$select_query_total_member_last_1e);

                                $final_total_member_last_1e = mysqli_num_rows($run_total_member_last_1e);



                                $select_query_total_member_current_1e = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND member_no not in (".implode(',', $arr1_1e).") AND status='1'";

                                $run_total_member_current_1e = mysqli_query($con,$select_query_total_member_current_1e);

                                $final_total_member_current_1e = mysqli_num_rows($run_total_member_current_1e);



                                $previuos_add_1e = $final_total_member_last_1e-$final_total_member_current_1e;

                            //member details





                                $select_query_total_curt_1e = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND x_position='$x_position_main_1e'";

                                $run_total_curt_1e = mysqli_query($con,$select_query_total_curt_1e);

                                while($row_total_curt_1e = mysqli_fetch_array($run_total_curt_1e)){

                                      $total_curt_1e = $row_total_curt_1e['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1e = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND member_no not in (".implode(',', $arr1_1e).") AND x_position='$x_position_main_1e'";

                                $run_total_curta_1e = mysqli_query($con,$select_query_total_curta_1e);

                                while($row_total_curta_1e = mysqli_fetch_array($run_total_curta_1e)){

                                      $total_curta_1_1e = $row_total_curta_1e['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1e = $total_curta_1_1e+$total_curt_1e;





                                if ($final_group_pv_1e < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1e < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1e < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1e < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1e < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61e = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND percent='3'";

                                $run_total_member_get_per61e = mysqli_query($con,$select_query_total_member_get_per61e);

                                $final_total_member_get_per61e = mysqli_num_rows($run_total_member_get_per61e);



                                $select_query_total_member_get_per101e = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND percent='6'";

                                $run_total_member_get_per101e = mysqli_query($con,$select_query_total_member_get_per101e);

                                $final_total_member_get_per101e = mysqli_num_rows($run_total_member_get_per101e);





                                $select_query_total_member_get_per141e = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND percent='9'";

                                $run_total_member_get_per141e = mysqli_query($con,$select_query_total_member_get_per141e);

                                $final_total_member_get_per141e = mysqli_num_rows($run_total_member_get_per141e);





                                $select_query_total_member_get_per181e = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND percent='12'";

                                $run_total_member_get_per181e = mysqli_query($con,$select_query_total_member_get_per181e);

                                $final_total_member_get_per181e = mysqli_num_rows($run_total_member_get_per181e);





                                $select_query_total_member_get_per221e = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND percent='15'";

                                $run_total_member_get_per221e = mysqli_query($con,$select_query_total_member_get_per221e);

                                $final_total_member_get_per221e = mysqli_num_rows($run_total_member_get_per221e);



                                $select_query_total_member_get_per231e = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND percent='21'";

                                $run_total_member_get_per231e = mysqli_query($con,$select_query_total_member_get_per231e);

                                $final_total_member_get_per231e = mysqli_num_rows($run_total_member_get_per231e);



                                $select_query_growth_1e = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e'";

                                $run_growth_1e = mysqli_query($con,$select_query_growth_1e);

                                $check_level_growth_1e = mysqli_num_rows($run_growth_1e);



                               // get percent member



                                $select_query_active_base_1e = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e' AND x_position >= '$x_position_main_my_1e' AND active_base='1'";

                                $run_active_base_1e = mysqli_query($con,$select_query_active_base_1e);

                                $check_level_active_base_1e = mysqli_num_rows($run_active_base_1e);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1e; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1e; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1e; ?></td>



                             

                                <td><?= $user_id_row_select_1e; ?></td>

                                <td><?= $name_row_select_1e; ?></td>

                                <td><?= $city_district_row_select_1e; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1e; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1e; ?></td>

                                <td><?= $final_total_member_current_1e; ?></td>

                                <td><?= $final_total_member_last_1e; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1e; ?></td>

                                <td><?= $final_group_pv_1e; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1e_1e; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1e; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61e; ?></td>

                                <td><?= $final_total_member_get_per101e; ?></td>

                                <td><?= $final_total_member_get_per141e; ?></td>

                                <td><?= $final_total_member_get_per181e; ?></td>

                                <td><?= $final_total_member_get_per221e; ?></td>

                                <td><?= $final_total_member_get_per231e; ?></td>



                                

                                <td><?= $date_of_join_row_select_1e; ?></td>

                                <td><?= $state_row_select_1e; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1f = "select * from roi_tree where group_number = '$group_number_main_1e' AND x_position = '$x_position_main_my_1e' AND relation_ship_no LIKE '%{$relation_ship_no_main_1e}%' AND tree_id > '$tree_id_main_1e'";



                                    $run_main_1f = mysqli_query($con,$select_query_main_1f);



                                    $check_level_1f = mysqli_num_rows($run_main_1f);



                                    if ($check_level_1f > 0) {



                                    while ($row_main_1f = mysqli_fetch_array($run_main_1f)) {                                   



                                    $tree_id_main_1f = $row_main_1f['tree_id'];



                                    $group_number_main_1f = $row_main_1f['group_number'];



                                    $member_no_main_1f = $row_main_1f['member_no'];



                                    $sponsor_no_main_1f = $row_main_1f['sponsor_no'];



                                    $level_no_main_1f = $row_main_1f['level_no'];



                                    $relation_ship_no_main_1f = $row_main_1f['relation_ship_no'];



                                    $x_position_main_1f = $row_main_1f['x_position'];

                                    $roi_amount_main_1f = $row_main_1f['roi_amount'];

                                    $product_amount_main_1f = $row_main_1f['product_amount'];

                                    $x_position_main_my_1f = $row_main_1f['x_position']+1;



                                    $roi_status_main_my_1f = $row_main_1f['roi_status'];



                                    if ($roi_status_main_my_1f == 0) {

                                         $personal_pv_join = $roi_amount_main_1f;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1f = "select * from member where member_no ='$member_no_main_1f'";



                                  $run_select_1f = mysqli_query($con,$select_query_select_1f);

                                    while ($row_select_1f = mysqli_fetch_array($run_select_1f)) {

                                    $name_row_select_1f = $row_select_1f['name'];

                                    

                                    $user_id_row_select_1f = $row_select_1f['user_id'];

                                    $date_of_join_row_select_1f =$row_select_1f['date_of_join'];

                                    $city_district_row_select_1f =$row_select_1f['city_district'];

                                    $mobile_number_row_select_1f =$row_select_1f['mobile_number'];                                    

                                    $state_row_select_1f =$row_select_1f['state'];

                                      }





                                 $current_xpoision_1f = $x_position_main_1f-$x_position_main;





                                 $arr1_1f = array();

                                  $select_query_findempty_pay_1f = "select * from roi_member where member_no = '$member_no_main_1f'";

                                  $run_findempty_pay_1f = mysqli_query($con,$select_query_findempty_pay_1f);

                                  while ($row_findempty_pay_1f = mysqli_fetch_array($run_findempty_pay_1f)) {

                                   $arr1_1f[] = $row_findempty_pay_1f['used_no'];

                                  }



                                  $arr1_1f_pro = array();

                                  $select_query_findempty_pay_1f_pro = "select * from product_member where member_no = '$member_no_main_1f'";

                                  $run_findempty_pay_1f_pro = mysqli_query($con,$select_query_findempty_pay_1f_pro);

                                  while ($row_findempty_pay_1f_pro = mysqli_fetch_array($run_findempty_pay_1f_pro)) {

                                   $arr1_1f_pro[] = $row_findempty_pay_1f_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1f = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1f' AND product_no not in (".implode(',', $arr1_1f_pro).") AND status='0'";

                                  $run_per_product_x1_1f = mysqli_query($con,$select_query_per_product_x1_1f);

                                  while($row_per_product_x1_1f = mysqli_fetch_array($run_per_product_x1_1f)){

                                        $p_per_product_x1_1f = $row_per_product_x1_1f['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1f = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND product_no not in (".implode(',', $arr1_1f_pro).") AND status='0'";

                                  $run_cur_product_x1_1f = mysqli_query($con,$select_query_cur_product_x1_1f);

                                  while($row_cur_product_x1_1f = mysqli_fetch_array($run_cur_product_x1_1f)){

                                        $p_cur_product_x1_1f = $row_cur_product_x1_1f['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1f = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%'";

                                  $run_product_x1_1f = mysqli_query($con,$select_query_product_x1_1f);

                                  while($row_product_x1_1f = mysqli_fetch_array($run_product_x1_1f)){

                                        $p_product_x1_1f = $row_product_x1_1f['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1f = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%'";

                              $run_total_team_pv_1f = mysqli_query($con,$select_query_total_team_pv_1f);

                              while($row_total_team_pv_1f = mysqli_fetch_array($run_total_team_pv_1f)){

                                    $total_team_pv_1_1f = $row_total_team_pv_1f['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1f = $total_team_pv_1_1f+$p_product_x1_1f;

                            //group pv

                            

                              



                                $select_query_total_x1f_1f = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND member_no not in (".implode(',', $arr1_1f).")";

                                $run_total_x1f_1f = mysqli_query($con,$select_query_total_x1f_1f);

                                while($row_total_x1f_1f = mysqli_fetch_array($run_total_x1f_1f)){

                                      $total_x1f_1_1f = $row_total_x1f_1f['SUM(roi_amount)'];

                                      

                                }

                                $total_x1f_1f = $total_x1f_1_1f+$p_cur_product_x1_1f+$personal_pv_join;





                                



                              //member details

                               $select_query_total_member_last_1f = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f'";

                                $run_total_member_last_1f = mysqli_query($con,$select_query_total_member_last_1f);

                                $final_total_member_last_1f = mysqli_num_rows($run_total_member_last_1f);



                                $select_query_total_member_current_1f = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND member_no not in (".implode(',', $arr1_1f).") AND status='1'";

                                $run_total_member_current_1f = mysqli_query($con,$select_query_total_member_current_1f);

                                $final_total_member_current_1f = mysqli_num_rows($run_total_member_current_1f);



                                $previuos_add_1f = $final_total_member_last_1f-$final_total_member_current_1f;

                            //member details





                                $select_query_total_curt_1f = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND x_position='$x_position_main_1f'";

                                $run_total_curt_1f = mysqli_query($con,$select_query_total_curt_1f);

                                while($row_total_curt_1f = mysqli_fetch_array($run_total_curt_1f)){

                                      $total_curt_1f = $row_total_curt_1f['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1f = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND member_no not in (".implode(',', $arr1_1f).") AND x_position='$x_position_main_1f'";

                                $run_total_curta_1f = mysqli_query($con,$select_query_total_curta_1f);

                                while($row_total_curta_1f = mysqli_fetch_array($run_total_curta_1f)){

                                      $total_curta_1_1f = $row_total_curta_1f['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1f = $total_curta_1_1f+$total_curt_1f;





                                if ($final_group_pv_1f < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1f < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1f < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1f < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1f < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61f = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND percent='3'";

                                $run_total_member_get_per61f = mysqli_query($con,$select_query_total_member_get_per61f);

                                $final_total_member_get_per61f = mysqli_num_rows($run_total_member_get_per61f);



                                $select_query_total_member_get_per101f = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND percent='6'";

                                $run_total_member_get_per101f = mysqli_query($con,$select_query_total_member_get_per101f);

                                $final_total_member_get_per101f = mysqli_num_rows($run_total_member_get_per101f);





                                $select_query_total_member_get_per141f = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND percent='9'";

                                $run_total_member_get_per141f = mysqli_query($con,$select_query_total_member_get_per141f);

                                $final_total_member_get_per141f = mysqli_num_rows($run_total_member_get_per141f);





                                $select_query_total_member_get_per181f = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND percent='12'";

                                $run_total_member_get_per181f = mysqli_query($con,$select_query_total_member_get_per181f);

                                $final_total_member_get_per181f = mysqli_num_rows($run_total_member_get_per181f);





                                $select_query_total_member_get_per221f = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND percent='15'";

                                $run_total_member_get_per221f = mysqli_query($con,$select_query_total_member_get_per221f);

                                $final_total_member_get_per221f = mysqli_num_rows($run_total_member_get_per221f);



                                $select_query_total_member_get_per231f = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND percent='21'";

                                $run_total_member_get_per231f = mysqli_query($con,$select_query_total_member_get_per231f);

                                $final_total_member_get_per231f = mysqli_num_rows($run_total_member_get_per231f);



                                $select_query_growth_1f = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f'";

                                $run_growth_1f = mysqli_query($con,$select_query_growth_1f);

                                $check_level_growth_1f = mysqli_num_rows($run_growth_1f);



                               // get percent member



                                $select_query_active_base_1f = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f' AND x_position >= '$x_position_main_my_1f' AND active_base='1'";

                                $run_active_base_1f = mysqli_query($con,$select_query_active_base_1f);

                                $check_level_active_base_1f = mysqli_num_rows($run_active_base_1f);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1f; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1f; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1f; ?></td>



                             

                                <td><?= $user_id_row_select_1f; ?></td>

                                <td><?= $name_row_select_1f; ?></td>

                                <td><?= $city_district_row_select_1f; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1f; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1f; ?></td>

                                <td><?= $final_total_member_current_1f; ?></td>

                                <td><?= $final_total_member_last_1f; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1f; ?></td>

                                <td><?= $final_group_pv_1f; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1f_1f; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1f; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61f; ?></td>

                                <td><?= $final_total_member_get_per101f; ?></td>

                                <td><?= $final_total_member_get_per141f; ?></td>

                                <td><?= $final_total_member_get_per181f; ?></td>

                                <td><?= $final_total_member_get_per221f; ?></td>

                                <td><?= $final_total_member_get_per231f; ?></td>



                                

                                <td><?= $date_of_join_row_select_1f; ?></td>

                                <td><?= $state_row_select_1f; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1g = "select * from roi_tree where group_number = '$group_number_main_1f' AND x_position = '$x_position_main_my_1f' AND relation_ship_no LIKE '%{$relation_ship_no_main_1f}%' AND tree_id > '$tree_id_main_1f'";



                                    $run_main_1g = mysqli_query($con,$select_query_main_1g);



                                    $check_level_1g = mysqli_num_rows($run_main_1g);



                                    if ($check_level_1g > 0) {



                                    while ($row_main_1g = mysqli_fetch_array($run_main_1g)) {                                   



                                    $tree_id_main_1g = $row_main_1g['tree_id'];



                                    $group_number_main_1g = $row_main_1g['group_number'];



                                    $member_no_main_1g = $row_main_1g['member_no'];



                                    $sponsor_no_main_1g = $row_main_1g['sponsor_no'];



                                    $level_no_main_1g = $row_main_1g['level_no'];



                                    $relation_ship_no_main_1g = $row_main_1g['relation_ship_no'];



                                    $x_position_main_1g = $row_main_1g['x_position'];

                                    $roi_amount_main_1g = $row_main_1g['roi_amount'];

                                    $product_amount_main_1g = $row_main_1g['product_amount'];

                                    $x_position_main_my_1g = $row_main_1g['x_position']+1;



                                    $roi_status_main_my_1g = $row_main_1g['roi_status'];



                                    if ($roi_status_main_my_1g == 0) {

                                         $personal_pv_join = $roi_amount_main_1g;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1g = "select * from member where member_no ='$member_no_main_1g'";



                                  $run_select_1g = mysqli_query($con,$select_query_select_1g);

                                    while ($row_select_1g = mysqli_fetch_array($run_select_1g)) {

                                    $name_row_select_1g = $row_select_1g['name'];

                                    

                                    $user_id_row_select_1g = $row_select_1g['user_id'];

                                    $date_of_join_row_select_1g =$row_select_1g['date_of_join'];

                                    $city_district_row_select_1g =$row_select_1g['city_district'];

                                    $mobile_number_row_select_1g =$row_select_1g['mobile_number'];                                    

                                    $state_row_select_1g =$row_select_1g['state'];

                                      }





                                 $current_xpoision_1g = $x_position_main_1g-$x_position_main;





                                 $arr1_1g = array();

                                  $select_query_findempty_pay_1g = "select * from roi_member where member_no = '$member_no_main_1g'";

                                  $run_findempty_pay_1g = mysqli_query($con,$select_query_findempty_pay_1g);

                                  while ($row_findempty_pay_1g = mysqli_fetch_array($run_findempty_pay_1g)) {

                                   $arr1_1g[] = $row_findempty_pay_1g['used_no'];

                                  }





                                  $arr1_1g_pro = array();

                                  $select_query_findempty_pay_1g_pro = "select * from product_member where member_no = '$member_no_main_1g'";

                                  $run_findempty_pay_1g_pro = mysqli_query($con,$select_query_findempty_pay_1g_pro);

                                  while ($row_findempty_pay_1g_pro = mysqli_fetch_array($run_findempty_pay_1g_pro)) {

                                   $arr1_1g_pro[] = $row_findempty_pay_1g_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1g = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1g' AND product_no not in (".implode(',', $arr1_1g_pro).") AND status='0'";

                                  $run_per_product_x1_1g = mysqli_query($con,$select_query_per_product_x1_1g);

                                  while($row_per_product_x1_1g = mysqli_fetch_array($run_per_product_x1_1g)){

                                        $p_per_product_x1_1g = $row_per_product_x1_1g['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1g = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND product_no not in (".implode(',', $arr1_1g_pro).") AND status='0'";

                                  $run_cur_product_x1_1g = mysqli_query($con,$select_query_cur_product_x1_1g);

                                  while($row_cur_product_x1_1g = mysqli_fetch_array($run_cur_product_x1_1g)){

                                        $p_cur_product_x1_1g = $row_cur_product_x1_1g['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1g = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%'";

                                  $run_product_x1_1g = mysqli_query($con,$select_query_product_x1_1g);

                                  while($row_product_x1_1g = mysqli_fetch_array($run_product_x1_1g)){

                                        $p_product_x1_1g = $row_product_x1_1g['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1g = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%'";

                              $run_total_team_pv_1g = mysqli_query($con,$select_query_total_team_pv_1g);

                              while($row_total_team_pv_1g = mysqli_fetch_array($run_total_team_pv_1g)){

                                    $total_team_pv_1_1g = $row_total_team_pv_1g['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1g = $total_team_pv_1_1g+$p_product_x1_1g;

                            //group pv

                            

                              



                                $select_query_total_x1g_1g = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND member_no not in (".implode(',', $arr1_1g).")";

                                $run_total_x1g_1g = mysqli_query($con,$select_query_total_x1g_1g);

                                while($row_total_x1g_1g = mysqli_fetch_array($run_total_x1g_1g)){

                                      $total_x1g_1_1g = $row_total_x1g_1g['SUM(roi_amount)'];

                                      

                                }

                                $total_x1g_1g = $total_x1g_1_1g+$p_cur_product_x1_1g+$personal_pv_join;





                                



                              //member details

                               $select_query_total_member_last_1g = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g'";

                                $run_total_member_last_1g = mysqli_query($con,$select_query_total_member_last_1g);

                                $final_total_member_last_1g = mysqli_num_rows($run_total_member_last_1g);



                                $select_query_total_member_current_1g = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND member_no not in (".implode(',', $arr1_1g).") AND status='1'";

                                $run_total_member_current_1g = mysqli_query($con,$select_query_total_member_current_1g);

                                $final_total_member_current_1g = mysqli_num_rows($run_total_member_current_1g);



                                $previuos_add_1g = $final_total_member_last_1g-$final_total_member_current_1g;

                            //member details





                                $select_query_total_curt_1g = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND x_position='$x_position_main_1g'";

                                $run_total_curt_1g = mysqli_query($con,$select_query_total_curt_1g);

                                while($row_total_curt_1g = mysqli_fetch_array($run_total_curt_1g)){

                                      $total_curt_1g = $row_total_curt_1g['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1g = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND member_no not in (".implode(',', $arr1).") AND x_position='$x_position_main_1g'";

                                $run_total_curta_1g = mysqli_query($con,$select_query_total_curta_1g);

                                while($row_total_curta_1g = mysqli_fetch_array($run_total_curta_1g)){

                                      $total_curta_1_1g = $row_total_curta_1g['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1g = $total_curta_1_1g+$total_curt_1g;





                                if ($final_group_pv_1g < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1g < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1g < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1g < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1g < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61g = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND percent='3'";

                                $run_total_member_get_per61g = mysqli_query($con,$select_query_total_member_get_per61g);

                                $final_total_member_get_per61g = mysqli_num_rows($run_total_member_get_per61g);



                                $select_query_total_member_get_per101g = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND percent='6'";

                                $run_total_member_get_per101g = mysqli_query($con,$select_query_total_member_get_per101g);

                                $final_total_member_get_per101g = mysqli_num_rows($run_total_member_get_per101g);





                                $select_query_total_member_get_per141g = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND percent='9'";

                                $run_total_member_get_per141g = mysqli_query($con,$select_query_total_member_get_per141g);

                                $final_total_member_get_per141g = mysqli_num_rows($run_total_member_get_per141g);





                                $select_query_total_member_get_per181g = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND percent='12'";

                                $run_total_member_get_per181g = mysqli_query($con,$select_query_total_member_get_per181g);

                                $final_total_member_get_per181g = mysqli_num_rows($run_total_member_get_per181g);





                                $select_query_total_member_get_per221g = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND percent='15'";

                                $run_total_member_get_per221g = mysqli_query($con,$select_query_total_member_get_per221g);

                                $final_total_member_get_per221g = mysqli_num_rows($run_total_member_get_per221g);



                                $select_query_total_member_get_per231g = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND percent='21'";

                                $run_total_member_get_per231g = mysqli_query($con,$select_query_total_member_get_per231g);

                                $final_total_member_get_per231g = mysqli_num_rows($run_total_member_get_per231g);





                                $select_query_growth_1g = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g'";

                                $run_growth_1g = mysqli_query($con,$select_query_growth_1g);

                                $check_level_growth_1g = mysqli_num_rows($run_growth_1g);



                               // get percent member



                                $select_query_active_base_1g = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g' AND x_position >= '$x_position_main_my_1g' AND active_base='1'";

                                $run_active_base_1g = mysqli_query($con,$select_query_active_base_1g);

                                $check_level_active_base_1g = mysqli_num_rows($run_active_base_1g);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1g; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1g; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1g; ?></td>



                             

                                <td><?= $user_id_row_select_1g; ?></td>

                                <td><?= $name_row_select_1g; ?></td>

                                <td><?= $city_district_row_select_1g; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1g; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1g; ?></td>

                                <td><?= $final_total_member_current_1g; ?></td>

                                <td><?= $final_total_member_last_1g; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1g; ?></td>

                                <td><?= $final_group_pv_1g; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1g_1g; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1g; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61g; ?></td>

                                <td><?= $final_total_member_get_per101g; ?></td>

                                <td><?= $final_total_member_get_per141g; ?></td>

                                <td><?= $final_total_member_get_per181g; ?></td>

                                <td><?= $final_total_member_get_per221g; ?></td>

                                <td><?= $final_total_member_get_per231g; ?></td>



                                

                                <td><?= $date_of_join_row_select_1g; ?></td>

                                <td><?= $state_row_select_1g; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1h = "select * from roi_tree where group_number = '$group_number_main_1g' AND x_position = '$x_position_main_my_1g' AND relation_ship_no LIKE '%{$relation_ship_no_main_1g}%' AND tree_id > '$tree_id_main_1g'";



                                    $run_main_1h = mysqli_query($con,$select_query_main_1h);



                                    $check_level_1h = mysqli_num_rows($run_main_1h);



                                    if ($check_level_1h > 0) {



                                    while ($row_main_1h = mysqli_fetch_array($run_main_1h)) {                                   



                                    $tree_id_main_1h = $row_main_1h['tree_id'];



                                    $group_number_main_1h = $row_main_1h['group_number'];



                                    $member_no_main_1h = $row_main_1h['member_no'];



                                    $sponsor_no_main_1h = $row_main_1h['sponsor_no'];



                                    $level_no_main_1h = $row_main_1h['level_no'];



                                    $relation_ship_no_main_1h = $row_main_1h['relation_ship_no'];



                                    $x_position_main_1h = $row_main_1h['x_position'];

                                    $roi_amount_main_1h = $row_main_1h['roi_amount'];

                                    $product_amount_main_1h = $row_main_1h['product_amount'];

                                    $x_position_main_my_1h = $row_main_1h['x_position']+1;



                                    $roi_status_main_my_1h = $row_main_1h['roi_status'];



                                    if ($roi_status_main_my_1h == 0) {

                                         $personal_pv_join = $roi_amount_main_1h;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1h = "select * from member where member_no ='$member_no_main_1h'";



                                  $run_select_1h = mysqli_query($con,$select_query_select_1h);

                                    while ($row_select_1h = mysqli_fetch_array($run_select_1h)) {

                                    $name_row_select_1h = $row_select_1h['name'];

                                    

                                    $user_id_row_select_1h = $row_select_1h['user_id'];

                                    $date_of_join_row_select_1h =$row_select_1h['date_of_join'];

                                    $city_district_row_select_1h =$row_select_1h['city_district'];

                                    $mobile_number_row_select_1h =$row_select_1h['mobile_number'];                                    

                                    $state_row_select_1h =$row_select_1h['state'];

                                      }





                                 $current_xpoision_1h = $x_position_main_1h-$x_position_main;





                                 $arr1_1h = array();

                                  $select_query_findempty_pay_1h = "select * from roi_member where member_no = '$member_no_main_1h'";

                                  $run_findempty_pay_1h = mysqli_query($con,$select_query_findempty_pay_1h);

                                  while ($row_findempty_pay_1h = mysqli_fetch_array($run_findempty_pay_1h)) {

                                   $arr1_1h[] = $row_findempty_pay_1h['used_no'];

                                  }



                                  $arr1_1h_pro = array();

                                  $select_query_findempty_pay_1h_pro = "select * from product_member where member_no = '$member_no_main_1h'";

                                  $run_findempty_pay_1h_pro = mysqli_query($con,$select_query_findempty_pay_1h_pro);

                                  while ($row_findempty_pay_1h_pro = mysqli_fetch_array($run_findempty_pay_1h_pro)) {

                                   $arr1_1h_pro[] = $row_findempty_pay_1h_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1h = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1h' AND product_no not in (".implode(',', $arr1_1h_pro).") AND status='0'";

                                  $run_per_product_x1_1h = mysqli_query($con,$select_query_per_product_x1_1h);

                                  while($row_per_product_x1_1h = mysqli_fetch_array($run_per_product_x1_1h)){

                                        $p_per_product_x1_1h = $row_per_product_x1_1h['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1h = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND product_no not in (".implode(',', $arr1_1h_pro).") AND status='0'";

                                  $run_cur_product_x1_1h = mysqli_query($con,$select_query_cur_product_x1_1h);

                                  while($row_cur_product_x1_1h = mysqli_fetch_array($run_cur_product_x1_1h)){

                                        $p_cur_product_x1_1h = $row_cur_product_x1_1h['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1h = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%'";

                                  $run_product_x1_1h = mysqli_query($con,$select_query_product_x1_1h);

                                  while($row_product_x1_1h = mysqli_fetch_array($run_product_x1_1h)){

                                        $p_product_x1_1h = $row_product_x1_1h['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1h = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%'";

                              $run_total_team_pv_1h = mysqli_query($con,$select_query_total_team_pv_1h);

                              while($row_total_team_pv_1h = mysqli_fetch_array($run_total_team_pv_1h)){

                                    $total_team_pv_1_1h = $row_total_team_pv_1h['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1h = $total_team_pv_1_1h+$p_product_x1_1h;

                            //group pv

                            

                              



                                $select_query_total_x1h_1h = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND member_no not in (".implode(',', $arr1_1h).")";

                                $run_total_x1h_1h = mysqli_query($con,$select_query_total_x1h_1h);

                                while($row_total_x1h_1h = mysqli_fetch_array($run_total_x1h_1h)){

                                      $total_x1h_1_1h = $row_total_x1h_1h['SUM(roi_amount)'];

                                      

                                }

                                $total_x1h_1h = $total_x1h_1_1h+$p_cur_product_x1_1h+$personal_pv_join;





                                



                              //member details

                               $select_query_total_member_last_1h = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h'";

                                $run_total_member_last_1h = mysqli_query($con,$select_query_total_member_last_1h);

                                $final_total_member_last_1h = mysqli_num_rows($run_total_member_last_1h);



                                $select_query_total_member_current_1h = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND member_no not in (".implode(',', $arr1_1h).") AND status='1'";

                                $run_total_member_current_1h = mysqli_query($con,$select_query_total_member_current_1h);

                                $final_total_member_current_1h = mysqli_num_rows($run_total_member_current_1h);



                                $previuos_add_1h = $final_total_member_last_1h-$final_total_member_current_1h;

                            //member details





                                $select_query_total_curt_1h = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND x_position='$x_position_main_1h'";

                                $run_total_curt_1h = mysqli_query($con,$select_query_total_curt_1h);

                                while($row_total_curt_1h = mysqli_fetch_array($run_total_curt_1h)){

                                      $total_curt_1h = $row_total_curt_1h['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1h = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND member_no not in (".implode(',', $arr1).") AND x_position='$x_position_main_1h'";

                                $run_total_curta_1h = mysqli_query($con,$select_query_total_curta_1h);

                                while($row_total_curta_1h = mysqli_fetch_array($run_total_curta_1h)){

                                      $total_curta_1_1h = $row_total_curta_1h['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1h = $total_curta_1_1h+$total_curt_1h;





                                if ($final_group_pv_1h < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1h < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1h < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1h < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1h < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61h = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND percent='3'";

                                $run_total_member_get_per61h = mysqli_query($con,$select_query_total_member_get_per61h);

                                $final_total_member_get_per61h = mysqli_num_rows($run_total_member_get_per61h);



                                $select_query_total_member_get_per101h = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND percent='6'";

                                $run_total_member_get_per101h = mysqli_query($con,$select_query_total_member_get_per101h);

                                $final_total_member_get_per101h = mysqli_num_rows($run_total_member_get_per101h);





                                $select_query_total_member_get_per141h = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND percent='9'";

                                $run_total_member_get_per141h = mysqli_query($con,$select_query_total_member_get_per141h);

                                $final_total_member_get_per141h = mysqli_num_rows($run_total_member_get_per141h);





                                $select_query_total_member_get_per181h = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND percent='12'";

                                $run_total_member_get_per181h = mysqli_query($con,$select_query_total_member_get_per181h);

                                $final_total_member_get_per181h = mysqli_num_rows($run_total_member_get_per181h);





                                $select_query_total_member_get_per221h = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND percent='15'";

                                $run_total_member_get_per221h = mysqli_query($con,$select_query_total_member_get_per221h);

                                $final_total_member_get_per221h = mysqli_num_rows($run_total_member_get_per221h);



                                $select_query_total_member_get_per231h = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND percent='21'";

                                $run_total_member_get_per231h = mysqli_query($con,$select_query_total_member_get_per231h);

                                $final_total_member_get_per231h = mysqli_num_rows($run_total_member_get_per231h);



                                $select_query_growth_1h = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h'";

                                $run_growth_1h = mysqli_query($con,$select_query_growth_1h);

                                $check_level_growth_1h = mysqli_num_rows($run_growth_1h);



                               // get percent member



                                $select_query_active_base_1h = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h' AND x_position >= '$x_position_main_my_1h' AND active_base='1'";

                                $run_active_base_1h = mysqli_query($con,$select_query_active_base_1h);

                                $check_level_active_base_1h = mysqli_num_rows($run_active_base_1h);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1h; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1h; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1h; ?></td>



                             

                                <td><?= $user_id_row_select_1h; ?></td>

                                <td><?= $name_row_select_1h; ?></td>

                                <td><?= $city_district_row_select_1h; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1h; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1h; ?></td>

                                <td><?= $final_total_member_current_1h; ?></td>

                                <td><?= $final_total_member_last_1h; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1h; ?></td>

                                <td><?= $final_group_pv_1h; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1h_1h; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1h; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61h; ?></td>

                                <td><?= $final_total_member_get_per101h; ?></td>

                                <td><?= $final_total_member_get_per141h; ?></td>

                                <td><?= $final_total_member_get_per181h; ?></td>

                                <td><?= $final_total_member_get_per221h; ?></td>

                                <td><?= $final_total_member_get_per231h; ?></td>



                                

                                <td><?= $date_of_join_row_select_1h; ?></td>

                                <td><?= $state_row_select_1h; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1i = "select * from roi_tree where group_number = '$group_number_main_1h' AND x_position = '$x_position_main_my_1h' AND relation_ship_no LIKE '%{$relation_ship_no_main_1h}%' AND tree_id > '$tree_id_main_1h'";



                                    $run_main_1i = mysqli_query($con,$select_query_main_1i);



                                    $check_level_1i = mysqli_num_rows($run_main_1i);



                                    if ($check_level_1i > 0) {



                                    while ($row_main_1i = mysqli_fetch_array($run_main_1i)) {                                   



                                    $tree_id_main_1i = $row_main_1i['tree_id'];



                                    $group_number_main_1i = $row_main_1i['group_number'];



                                    $member_no_main_1i = $row_main_1i['member_no'];



                                    $sponsor_no_main_1i = $row_main_1i['sponsor_no'];



                                    $level_no_main_1i = $row_main_1i['level_no'];



                                    $relation_ship_no_main_1i = $row_main_1i['relation_ship_no'];



                                    $x_position_main_1i = $row_main_1i['x_position'];

                                    $roi_amount_main_1i = $row_main_1i['roi_amount'];

                                    $product_amount_main_1i = $row_main_1i['product_amount'];

                                    $x_position_main_my_1i = $row_main_1i['x_position']+1;



                                    $roi_status_main_my_1i = $row_main_1i['roi_status'];



                                    if ($roi_status_main_my_1i == 0) {

                                         $personal_pv_join = $roi_amount_main_1i;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1i = "select * from member where member_no ='$member_no_main_1i'";



                                  $run_select_1i = mysqli_query($con,$select_query_select_1i);

                                    while ($row_select_1i = mysqli_fetch_array($run_select_1i)) {

                                    $name_row_select_1i = $row_select_1i['name'];

                                    

                                    $user_id_row_select_1i = $row_select_1i['user_id'];

                                    $date_of_join_row_select_1i =$row_select_1i['date_of_join'];

                                    $city_district_row_select_1i =$row_select_1i['city_district'];

                                    $mobile_number_row_select_1i =$row_select_1i['mobile_number'];                                    

                                    $state_row_select_1i =$row_select_1i['state'];

                                      }





                                 $current_xpoision_1i = $x_position_main_1i-$x_position_main;





                                 $arr1_1i = array();

                                  $select_query_findempty_pay_1i = "select * from roi_member where member_no = '$member_no_main_1i'";

                                  $run_findempty_pay_1i = mysqli_query($con,$select_query_findempty_pay_1i);

                                  while ($row_findempty_pay_1i = mysqli_fetch_array($run_findempty_pay_1i)) {

                                   $arr1_1i[] = $row_findempty_pay_1i['used_no'];

                                  }



                                  $arr1_1i_pro = array();

                                  $select_query_findempty_pay_1i_pro = "select * from product_member where member_no = '$member_no_main_1i'";

                                  $run_findempty_pay_1i_pro = mysqli_query($con,$select_query_findempty_pay_1i_pro);

                                  while ($row_findempty_pay_1i_pro = mysqli_fetch_array($run_findempty_pay_1i_pro)) {

                                   $arr1_1i_pro[] = $row_findempty_pay_1i_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1i = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1i' AND product_no not in (".implode(',', $arr1_1i_pro).") AND status='0'";

                                  $run_per_product_x1_1i = mysqli_query($con,$select_query_per_product_x1_1i);

                                  while($row_per_product_x1_1i = mysqli_fetch_array($run_per_product_x1_1i)){

                                        $p_per_product_x1_1i = $row_per_product_x1_1i['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1i = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND product_no not in (".implode(',', $arr1_1i_pro).") AND status='0'";

                                  $run_cur_product_x1_1i = mysqli_query($con,$select_query_cur_product_x1_1i);

                                  while($row_cur_product_x1_1i = mysqli_fetch_array($run_cur_product_x1_1i)){

                                        $p_cur_product_x1_1i = $row_cur_product_x1_1i['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1i = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%'";

                                  $run_product_x1_1i = mysqli_query($con,$select_query_product_x1_1i);

                                  while($row_product_x1_1i = mysqli_fetch_array($run_product_x1_1i)){

                                        $p_product_x1_1i = $row_product_x1_1i['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1i = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%'";

                              $run_total_team_pv_1i = mysqli_query($con,$select_query_total_team_pv_1i);

                              while($row_total_team_pv_1i = mysqli_fetch_array($run_total_team_pv_1i)){

                                    $total_team_pv_1_1i = $row_total_team_pv_1i['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1i = $total_team_pv_1_1i+$p_product_x1_1i;

                            //group pv

                            

                              



                                $select_query_total_x1i_1i = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND member_no not in (".implode(',', $arr1_1i).")";

                                $run_total_x1i_1i = mysqli_query($con,$select_query_total_x1i_1i);

                                while($row_total_x1i_1i = mysqli_fetch_array($run_total_x1i_1i)){

                                      $total_x1i_1_1i = $row_total_x1i_1i['SUM(roi_amount)'];

                                      

                                }

                                $total_x1i_1i = $total_x1i_1_1i+$p_cur_product_x1_1i+$personal_pv_join;





                               



                              //member details

                               $select_query_total_member_last_1i = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i'";

                                $run_total_member_last_1i = mysqli_query($con,$select_query_total_member_last_1i);

                                $final_total_member_last_1i = mysqli_num_rows($run_total_member_last_1i);



                                $select_query_total_member_current_1i = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND member_no not in (".implode(',', $arr1_1i).") AND status='1'";

                                $run_total_member_current_1i = mysqli_query($con,$select_query_total_member_current_1i);

                                $final_total_member_current_1i = mysqli_num_rows($run_total_member_current_1i);



                                $previuos_add_1i = $final_total_member_last_1i-$final_total_member_current_1i;

                            //member details





                                $select_query_total_curt_1i = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND x_position='$x_position_main_1i'";

                                $run_total_curt_1i = mysqli_query($con,$select_query_total_curt_1i);

                                while($row_total_curt_1i = mysqli_fetch_array($run_total_curt_1i)){

                                      $total_curt_1i = $row_total_curt_1i['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1i = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND member_no not in (".implode(',', $arr1_1i).") AND x_position='$x_position_main_1i'";

                                $run_total_curta_1i = mysqli_query($con,$select_query_total_curta_1i);

                                while($row_total_curta_1i = mysqli_fetch_array($run_total_curta_1i)){

                                      $total_curta_1_1i = $row_total_curta_1i['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1i = $total_curta_1_1i+$total_curt_1i;





                                if ($final_group_pv_1i < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1i < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1i < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1i < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1i < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61i = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND percent='3'";

                                $run_total_member_get_per61i = mysqli_query($con,$select_query_total_member_get_per61i);

                                $final_total_member_get_per61i = mysqli_num_rows($run_total_member_get_per61i);



                                $select_query_total_member_get_per101i = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND percent='6'";

                                $run_total_member_get_per101i = mysqli_query($con,$select_query_total_member_get_per101i);

                                $final_total_member_get_per101i = mysqli_num_rows($run_total_member_get_per101i);





                                $select_query_total_member_get_per141i = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND percent='9'";

                                $run_total_member_get_per141i = mysqli_query($con,$select_query_total_member_get_per141i);

                                $final_total_member_get_per141i = mysqli_num_rows($run_total_member_get_per141i);





                                $select_query_total_member_get_per181i = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND percent='12'";

                                $run_total_member_get_per181i = mysqli_query($con,$select_query_total_member_get_per181i);

                                $final_total_member_get_per181i = mysqli_num_rows($run_total_member_get_per181i);





                                $select_query_total_member_get_per221i = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND percent='15'";

                                $run_total_member_get_per221i = mysqli_query($con,$select_query_total_member_get_per221i);

                                $final_total_member_get_per221i = mysqli_num_rows($run_total_member_get_per221i);



                                $select_query_total_member_get_per231i = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND percent='21'";

                                $run_total_member_get_per231i = mysqli_query($con,$select_query_total_member_get_per231i);

                                $final_total_member_get_per231i = mysqli_num_rows($run_total_member_get_per231i);



                                $select_query_growth_1i = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i'";

                                $run_growth_1i = mysqli_query($con,$select_query_growth_1i);

                                $check_level_growth_1i = mysqli_num_rows($run_growth_1i);



                               // get percent member



                                $select_query_active_base_1i = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i' AND x_position >= '$x_position_main_my_1i' AND active_base='1'";

                                $run_active_base_1i = mysqli_query($con,$select_query_active_base_1i);

                                $check_level_active_base_1i = mysqli_num_rows($run_active_base_1i);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1i; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1i; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1i; ?></td>



                             

                                <td><?= $user_id_row_select_1i; ?></td>

                                <td><?= $name_row_select_1i; ?></td>

                                <td><?= $city_district_row_select_1i; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1i; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1i; ?></td>

                                <td><?= $final_total_member_current_1i; ?></td>

                                <td><?= $final_total_member_last_1i; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1i; ?></td>

                                <td><?= $final_group_pv_1i; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1i_1i; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1i; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61i; ?></td>

                                <td><?= $final_total_member_get_per101i; ?></td>

                                <td><?= $final_total_member_get_per141i; ?></td>

                                <td><?= $final_total_member_get_per181i; ?></td>

                                <td><?= $final_total_member_get_per221i; ?></td>

                                <td><?= $final_total_member_get_per231i; ?></td>



                                

                                <td><?= $date_of_join_row_select_1i; ?></td>

                                <td><?= $state_row_select_1i; ?></td>

                           </tr>



                           <?php 



                                  $select_query_main_1j = "select * from roi_tree where group_number = '$group_number_main_1i' AND x_position = '$x_position_main_my_1i' AND relation_ship_no LIKE '%{$relation_ship_no_main_1i}%' AND tree_id > '$tree_id_main_1i'";



                                    $run_main_1j = mysqli_query($con,$select_query_main_1j);



                                    $check_level_1j = mysqli_num_rows($run_main_1j);



                                    if ($check_level_1j > 0) {



                                    while ($row_main_1j = mysqli_fetch_array($run_main_1j)) {                                   



                                    $tree_id_main_1j = $row_main_1j['tree_id'];



                                    $group_number_main_1j = $row_main_1j['group_number'];



                                    $member_no_main_1j = $row_main_1j['member_no'];



                                    $sponsor_no_main_1j = $row_main_1j['sponsor_no'];



                                    $level_no_main_1j = $row_main_1j['level_no'];



                                    $relation_ship_no_main_1j = $row_main_1j['relation_ship_no'];



                                    $x_position_main_1j = $row_main_1j['x_position'];

                                    $roi_amount_main_1j = $row_main_1j['roi_amount'];

                                    $product_amount_main_1j = $row_main_1j['product_amount'];

                                    $x_position_main_my_1j = $row_main_1j['x_position']+1;



                                    $roi_status_main_my_1j = $row_main_1j['roi_status'];



                                    if ($roi_status_main_my_1j == 0) {

                                         $personal_pv_join = $roi_amount_main_1j;

                                      }

                                      else {

                                        $personal_pv_join = 0;

                                      } 

                                    $total_personal_pv = $personal_pv_join;





                                   $select_query_select_1j = "select * from member where member_no ='$member_no_main_1j'";



                                  $run_select_1j = mysqli_query($con,$select_query_select_1j);

                                    while ($row_select_1j = mysqli_fetch_array($run_select_1j)) {

                                    $name_row_select_1j = $row_select_1j['name'];

                                    

                                    $user_id_row_select_1j = $row_select_1j['user_id'];

                                    $date_of_join_row_select_1j =$row_select_1j['date_of_join'];

                                    $city_district_row_select_1j =$row_select_1j['city_district'];

                                    $mobile_number_row_select_1j =$row_select_1j['mobile_number'];                                    

                                    $state_row_select_1j =$row_select_1j['state'];

                                      }





                                 $current_xpoision_1j = $x_position_main_1j-$x_position_main;





                                 $arr1_1j = array();

                                  $select_query_findempty_pay_1j = "select * from roi_member where member_no = '$member_no_main_1j'";

                                  $run_findempty_pay_1j = mysqli_query($con,$select_query_findempty_pay_1j);

                                  while ($row_findempty_pay_1j = mysqli_fetch_array($run_findempty_pay_1j)) {

                                   $arr1_1j[] = $row_findempty_pay_1j['used_no'];

                                  }





                                  $arr1_1j_pro = array();

                                  $select_query_findempty_pay_1j_pro = "select * from product_member where member_no = '$member_no_main_1j'";

                                  $run_findempty_pay_1j_pro = mysqli_query($con,$select_query_findempty_pay_1j_pro);

                                  while ($row_findempty_pay_1j_pro = mysqli_fetch_array($run_findempty_pay_1j_pro)) {

                                   $arr1_1j_pro[] = $row_findempty_pay_1j_pro['used_no'];

                                  }



                                  //get_product_bv



                                  $select_query_per_product_x1_1j = "select SUM(product_amount) from product_tree where member_no='$member_no_main_1j' AND product_no not in (".implode(',', $arr1_1j_pro).") AND status='0'";

                                  $run_per_product_x1_1j = mysqli_query($con,$select_query_per_product_x1_1j);

                                  while($row_per_product_x1_1j = mysqli_fetch_array($run_per_product_x1_1j)){

                                        $p_per_product_x1_1j = $row_per_product_x1_1j['SUM(product_amount)'];

                                  }



                                  $select_query_cur_product_x1_1j = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND product_no not in (".implode(',', $arr1_1j_pro).") AND status='0'";

                                  $run_cur_product_x1_1j = mysqli_query($con,$select_query_cur_product_x1_1j);

                                  while($row_cur_product_x1_1j = mysqli_fetch_array($run_cur_product_x1_1j)){

                                        $p_cur_product_x1_1j = $row_cur_product_x1_1j['SUM(product_amount)'];

                                  }

                                  



                                  $select_query_product_x1_1j = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%'";

                                  $run_product_x1_1j = mysqli_query($con,$select_query_product_x1_1j);

                                  while($row_product_x1_1j = mysqli_fetch_array($run_product_x1_1j)){

                                        $p_product_x1_1j = $row_product_x1_1j['SUM(product_amount)'];

                                  }



                                  //get_product_bv





                                   //group pv

                              $select_query_total_team_pv_1j = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%'";

                              $run_total_team_pv_1j = mysqli_query($con,$select_query_total_team_pv_1j);

                              while($row_total_team_pv_1j = mysqli_fetch_array($run_total_team_pv_1j)){

                                    $total_team_pv_1_1j = $row_total_team_pv_1j['SUM(roi_amount)'];

                                    

                                    

                              }

                              

                              $final_group_pv_1j = $total_team_pv_1_1j+$p_product_x1_1j;

                            //group pv

                            

                              



                                $select_query_total_x1j_1j = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND member_no not in (".implode(',', $arr1_1j).")";

                                $run_total_x1j_1j = mysqli_query($con,$select_query_total_x1j_1j);

                                while($row_total_x1j_1j = mysqli_fetch_array($run_total_x1j_1j)){

                                      $total_x1j_1_1j = $row_total_x1j_1j['SUM(roi_amount)'];

                                      

                                }

                                $total_x1j_1j = $total_x1j_1_1j+$p_cur_product_x1_1j+$personal_pv_join;





                               



                              //member details

                               $select_query_total_member_last_1j = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j'";

                                $run_total_member_last_1j = mysqli_query($con,$select_query_total_member_last_1j);

                                $final_total_member_last_1j = mysqli_num_rows($run_total_member_last_1j);



                                $select_query_total_member_current_1j = "select * from roi_tree where  relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND member_no not in (".implode(',', $arr1_1j).") AND status='1'";

                                $run_total_member_current_1j = mysqli_query($con,$select_query_total_member_current_1j);

                                $final_total_member_current_1j = mysqli_num_rows($run_total_member_current_1j);



                                $previuos_add_1j = $final_total_member_last_1j-$final_total_member_current_1j;

                            //member details





                                $select_query_total_curt_1j = "select SUM(product_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND x_position='$x_position_main_1j'";

                                $run_total_curt_1j = mysqli_query($con,$select_query_total_curt_1j);

                                while($row_total_curt_1j = mysqli_fetch_array($run_total_curt_1j)){

                                      $total_curt_1j = $row_total_curt_1j['SUM(product_amount)'];

                                      

                                }



                                $select_query_total_curta_1j = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND member_no not in (".implode(',', $arr1_1j).") AND x_position='$x_position_main_1j'";

                                $run_total_curta_1j = mysqli_query($con,$select_query_total_curta_1j);

                                while($row_total_curta_1j = mysqli_fetch_array($run_total_curta_1j)){

                                      $total_curta_1_1j = $row_total_curta_1j['SUM(roi_amount)'];

                                      

                                }

                                $total_curta_1j = $total_curta_1_1j+$total_curt_1j;





                                if ($final_group_pv_1j < 5000) {

                                 $percent_amount = 3; 

                               }

                               elseif ($final_group_pv_1j < 12000) {

                                 $percent_amount = 6; 

                               }



                               elseif ($final_group_pv_1j < 30000) {

                                 $percent_amount = 9; 

                               }



                               elseif ($final_group_pv_1j < 60000) {

                                 $percent_amount = 12; 

                               }



                               elseif ($final_group_pv_1j < 100000) {

                                 $percent_amount = 15;  

                               }



                               

                               else {

                                 $percent_amount = 21;

                               }





                               // get percent member



                               $select_query_total_member_get_per61j = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND percent='3'";

                                $run_total_member_get_per61j = mysqli_query($con,$select_query_total_member_get_per61j);

                                $final_total_member_get_per61j = mysqli_num_rows($run_total_member_get_per61j);



                                $select_query_total_member_get_per101j = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND percent='6'";

                                $run_total_member_get_per101j = mysqli_query($con,$select_query_total_member_get_per101j);

                                $final_total_member_get_per101j = mysqli_num_rows($run_total_member_get_per101j);





                                $select_query_total_member_get_per141j = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND percent='9'";

                                $run_total_member_get_per141j = mysqli_query($con,$select_query_total_member_get_per141j);

                                $final_total_member_get_per141j = mysqli_num_rows($run_total_member_get_per141j);





                                $select_query_total_member_get_per181j = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND percent='12'";

                                $run_total_member_get_per181j = mysqli_query($con,$select_query_total_member_get_per181j);

                                $final_total_member_get_per181j = mysqli_num_rows($run_total_member_get_per181j);





                                $select_query_total_member_get_per221j = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND percent='15'";

                                $run_total_member_get_per221j = mysqli_query($con,$select_query_total_member_get_per221j);

                                $final_total_member_get_per221j = mysqli_num_rows($run_total_member_get_per221j);



                                $select_query_total_member_get_per231j = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND percent='21'";

                                $run_total_member_get_per231j = mysqli_query($con,$select_query_total_member_get_per231j);

                                $final_total_member_get_per231j = mysqli_num_rows($run_total_member_get_per231j);



                                $select_query_growth_1j = "select * from roi_tree where rank >= '1' AND relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j'";

                                $run_growth_1j = mysqli_query($con,$select_query_growth_1j);

                                $check_level_growth_1j = mysqli_num_rows($run_growth_1j);



                               // get percent member



                                $select_query_active_base_1j = "select * from roi_tree where roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1j}%' AND tree_id > '$tree_id_main_1j' AND x_position >= '$x_position_main_my_1j' AND active_base='1'";

                                $run_active_base_1j = mysqli_query($con,$select_query_active_base_1j);

                                $check_level_active_base_1j = mysqli_num_rows($run_active_base_1j);

                                    



                                    



                               ?>







                            <tr class="gradeX">



                              <td><a href="downline_view.php?member_no=<?= $member_no_main_1j; ?>" class="badge bg-blue">Lifeline</a></td>



                              <td>

                                <?php 

                                  for ($i=1; $i <= $current_xpoision_1j; $i++) { 

                                    echo ".";

                                  }

                                ?>

                                 <?= $current_xpoision_1j; ?></td>



                             

                                <td><?= $user_id_row_select_1j; ?></td>

                                <td><?= $name_row_select_1j; ?></td>

                                <td><?= $city_district_row_select_1j; ?></td>

                                <?php if ($contact_status == 1) { ?>

                                <td><?= $mobile_number_row_select_1j; ?></td>

                                <?php } ?>

                                <td><?= $check_level_active_base_1j; ?></td>

                                <td><?= $final_total_member_current_1j; ?></td>

                                <td><?= $final_total_member_last_1j; ?></td>

                                <td><?= $total_personal_pv+$p_per_product_x1_1j; ?></td>

                                <td><?= $final_group_pv_1j; ?></td>

                                <td><?= $percent_amount; ?></td>

                                <td><?= $total_x1j_1j; ?></td>

                                <td>-</td>

                                <td><?= $check_level_growth_1j; ?></td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td>-</td>

                                <td><?= $final_total_member_get_per61j; ?></td>

                                <td><?= $final_total_member_get_per101j; ?></td>

                                <td><?= $final_total_member_get_per141j; ?></td>

                                <td><?= $final_total_member_get_per181j; ?></td>

                                <td><?= $final_total_member_get_per221j; ?></td>

                                <td><?= $final_total_member_get_per231j; ?></td>



                                

                                <td><?= $date_of_join_row_select_1j; ?></td>

                                <td><?= $state_row_select_1j; ?></td>

                           </tr>

















                             <?php } ?><!-- j -->

                             <?php  } ?><!-- j -->

                             <?php } ?><!-- i -->

                             <?php  } ?><!-- i -->

                             <?php } ?><!-- h -->

                             <?php  } ?><!-- h -->



                             <?php } ?><!-- g -->

                             <?php  } ?><!-- g -->

                             <?php } ?><!-- f -->

                             <?php  } ?><!-- f -->

                             <?php } ?><!-- e -->

                             <?php  } ?><!-- e -->

                             <?php } ?><!-- d -->

                             <?php  } ?><!-- d -->

                             <?php } ?><!-- c -->

                             <?php  } ?><!-- c -->

                             <?php } ?><!-- b -->

                             <?php  } ?><!-- b -->

                             <?php } ?><!-- a -->

                             <?php  } ?><!-- a -->



                             



                             



                             



                            </tbody>



                            </table>



                          </div>

                          <!-- /.box-body -->

                        </div>

                        <!-- /.box -->

                       

                       

                        <!-- /.box -->          

                      </div>

      </div>

  </section>

    <div class="clearfix"></div>

  </div>

  <!-- /.content-wrapper -->

 

  <footer class="main-footer">

    <div class="pull-right d-none d-sm-inline-block">      

    </div>Copyright &copy; 2018. All Rights Reserved.

  </footer>



  <!-- Control Sidebar -->

  <aside class="control-sidebar control-sidebar-dark">

    <!-- Create the tabs -->

    <ul class="nav nav-tabs nav-justified control-sidebar-tabs">

      <li class="nav-item"><a href="#control-sidebar-home-tab" data-toggle="tab"><i class="fa fa-home"></i></a></li>

      <li class="nav-item"><a href="#control-sidebar-settings-tab" data-toggle="tab"><i class="fa fa-cog fa-spin"></i></a></li>

    </ul>

    <!-- Tab panes -->

    <div class="tab-content">

      <!-- Home tab content -->

      <div class="tab-pane" id="control-sidebar-home-tab">

        <h3 class="control-sidebar-heading">Recent Activity</h3>

        <ul class="control-sidebar-menu">

          <li>

            <a href="javascript:void(0)">

              <i class="menu-icon fa fa-birthday-cake bg-red"></i>



              <div class="menu-info">

                <h4 class="control-sidebar-subheading">Admin Birthday</h4>



                <p>Will be July 24th</p>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <i class="menu-icon fa fa-user bg-yellow"></i>



              <div class="menu-info">

                <h4 class="control-sidebar-subheading">Jhone Updated His Profile</h4>



                <p>New Email : jhone_doe@demo.com</p>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <i class="menu-icon fa fa-envelope-o bg-light-blue"></i>



              <div class="menu-info">

                <h4 class="control-sidebar-subheading">Disha Joined Mailing List</h4>



                <p>disha@demo.com</p>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <i class="menu-icon fa fa-file-code-o bg-green"></i>



              <div class="menu-info">

                <h4 class="control-sidebar-subheading">Code Change</h4>



                <p>Execution time 15 Days</p>

              </div>

            </a>

          </li>

        </ul>

        <!-- /.control-sidebar-menu -->



        <h3 class="control-sidebar-heading">Tasks Progress</h3>

        <ul class="control-sidebar-menu">

          <li>

            <a href="javascript:void(0)">

              <h4 class="control-sidebar-subheading">

                Web Design

                <span class="label label-danger pull-right">40%</span>

              </h4>



              <div class="progress progress-xxs">

                <div class="progress-bar progress-bar-danger" style="width: 40%"></div>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <h4 class="control-sidebar-subheading">

                Update Data

                <span class="label label-success pull-right">75%</span>

              </h4>



              <div class="progress progress-xxs">

                <div class="progress-bar progress-bar-success" style="width: 75%"></div>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <h4 class="control-sidebar-subheading">

                Order Process

                <span class="label label-warning pull-right">89%</span>

              </h4>



              <div class="progress progress-xxs">

                <div class="progress-bar progress-bar-warning" style="width: 89%"></div>

              </div>

            </a>

          </li>

          <li>

            <a href="javascript:void(0)">

              <h4 class="control-sidebar-subheading">

                Development 

                <span class="label label-primary pull-right">72%</span>

              </h4>



              <div class="progress progress-xxs">

                <div class="progress-bar progress-bar-primary" style="width: 72%"></div>

              </div>

            </a>

          </li>

        </ul>

        <!-- /.control-sidebar-menu -->



      </div>

      <!-- /.tab-pane -->

      <!-- Stats tab content -->

      <div class="tab-pane" id="control-sidebar-stats-tab">Stats Tab Content</div>

      <!-- /.tab-pane -->

      <!-- Settings tab content -->

      <div class="tab-pane" id="control-sidebar-settings-tab">

        <form method="post">

          <h3 class="control-sidebar-heading">General Settings</h3>



          <div class="form-group">

            <input type="checkbox" id="report_panel" class="chk-col-grey" >

			<label for="report_panel" class="control-sidebar-subheading ">Report panel usage</label>



            <p>

              general settings information

            </p>

          </div>

          <!-- /.form-group -->



          <div class="form-group">

            <input type="checkbox" id="allow_mail" class="chk-col-grey" >

			<label for="allow_mail" class="control-sidebar-subheading ">Mail redirect</label>



            <p>

              Other sets of options are available

            </p>

          </div>

          <!-- /.form-group -->



          <div class="form-group">

            <input type="checkbox" id="expose_author" class="chk-col-grey" >

			<label for="expose_author" class="control-sidebar-subheading ">Expose author name</label>



            <p>

              Allow the user to show his name in blog posts

            </p>

          </div>

          <!-- /.form-group -->



          <h3 class="control-sidebar-heading">Chat Settings</h3>



          <div class="form-group">

            <input type="checkbox" id="show_me_online" class="chk-col-grey" >

			<label for="show_me_online" class="control-sidebar-subheading ">Show me as online</label>

          </div>

          <!-- /.form-group -->



          <div class="form-group">

            <input type="checkbox" id="off_notifications" class="chk-col-grey" >

			<label for="off_notifications" class="control-sidebar-subheading ">Turn off notifications</label>

          </div>

          <!-- /.form-group -->



          <div class="form-group">

            <label class="control-sidebar-subheading">              

              <a href="javascript:void(0)" class="text-red margin-r-5"><i class="fa fa-trash-o"></i></a>

              Delete chat history

            </label>

          </div>

          <!-- /.form-group -->

        </form>

      </div>

      <!-- /.tab-pane -->

    </div>

  </aside>

  <!-- /.control-sidebar -->

  

  <!-- Add the sidebar's background. This div must be placed immediately after the control sidebar -->

  <div class="control-sidebar-bg"></div>

</div>

<!-- ./wrapper -->



	<!-- jQuery 3 -->

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

	

	<!-- popper -->

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

	

	<!-- Bootstrap v4.0.0-beta -->

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

	

	<!-- SlimScroll -->

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

	

	<!-- FastClick -->

	<script src="assets/vendor_components/fastclick/lib/fastclick.js"></script>

	

	<!-- maximum_admin App -->

	<script src="js/template.js"></script>

	

	<!-- maximum_admin for demo purposes -->

	<script src="js/demo.js"></script>

	

	<!-- This is data table -->

    <script src="assets/vendor_plugins/DataTables-1.10.15/media/js/jquery.dataTables.min.js"></script>

    

    <!-- start - This is for export functionality only -->

    <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/dataTables.buttons.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.flash.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/jszip.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/pdfmake.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/vfs_fonts.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.html5.min.js"></script>

    <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.print.min.js"></script>

    <!-- end - This is for export functionality only -->

  

  <!-- maximum_admin for Data Table -->

  <script src="js/pages/data-table.js"></script>

  <script type="text/javascript">

    function goBack() {

        window.history.back();

    }

    </script>



</body>



</html>

<?php } } } ?>