1#@!#!123s

32767 1#@!#!123s
: / home5 / rakcha / www / app /
Filename : index1.php
back
<?php error_reporting(0); ?>

<?php session_start();?>

<?php 

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

    header("location: login.php");

  }

 else {

  include("includes/database.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'];

        $profile = $row['profile'];

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

        $date_of_join =$row['date_of_join'];

        $member_no = $row['member_no'];

        $user_id = $row['user_id'];

        $rank = $row['rank'];

        

        $password = $row['password'];

        $elite_board = $row['elite_board'];

        $onhold_payment = $row['onhold_payment'];



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

        $product_eligible = $row['product_eligible'];

        $network_bonus_data = $row['network_bonus']; 

        $current_release_data = $row['current_release'];

        $profile = $row['profile']; 

        $login_status = $row['login_status']; 

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

          $y_position_main = $row_main['y_position'];

          $roi_amount_main = $row_main['roi_amount'];

          $roi_status_main = $row_main['roi_status'];

          $product_amount_main = $row_main['product_amount'];

          $total_bv_main = $row_main['total_bv'];

          }



          if ($member_no == '024') {

            $extra_amount_bv = 0;

          }

          else {

            $extra_amount_bv = 0;

          }







          if ($roi_status_main == 0) {

             $personal_pv_join_1 = $roi_amount_main;

          }

          else {

            $personal_pv_join_1 = 0;

          }



          $personal_pv_join = $personal_pv_join_1+$extra_amount_bv;







          



        $select_query_total_team_pv = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%'";

          $run_total_team_pv = mysqli_query($con,$select_query_total_team_pv);

          while($row_total_team_pv = mysqli_fetch_array($run_total_team_pv)){

                $total_team_pv_1 = $row_total_team_pv['SUM(roi_amount)'];

                $total_percent_amount_1 = $row_total_team_pv['SUM(percent_amount)'];

                

          }



          //products



          $select_query_total_team_pv_pro = "select SUM(level_roi), SUM(binary_income), SUM(referral_income), SUM(car_bonus), SUM(total_amount), SUM(manager_bonus), SUM(tour_bonus), SUM(leader_bonus), SUM(growth_bonus), SUM(ups_bonus), SUM(house_bonus) from week_payout where member_no = '$member_no'";

          $run_total_team_pv_pro = mysqli_query($con,$select_query_total_team_pv_pro);

          while($row_total_team_pv_pro = mysqli_fetch_array($run_total_team_pv_pro)){

                $total_team_pv_pro_1 = $row_total_team_pv_pro['SUM(level_roi)'];

                $total_team_pv_old_binary = $row_total_team_pv_pro['SUM(binary_income)']; 

                $total_team_pv_car_bonus = $row_total_team_pv_pro['SUM(car_bonus)'];

                $total_team_pv_total_amount = $row_total_team_pv_pro['SUM(total_amount)'];



                $total_team_pv_manager_bonus = $row_total_team_pv_pro['SUM(manager_bonus)'];

                $total_team_pv_tour_bonus = $row_total_team_pv_pro['SUM(tour_bonus)'];

                $total_team_pv_leader_bonus = $row_total_team_pv_pro['SUM(leader_bonus)'];

                $total_team_pv_proold_ref = $row_total_team_pv_pro['SUM(growth_bonus)'];

                $total_team_pv_ups_bonus = $row_total_team_pv_pro['SUM(ups_bonus)'];

                $total_team_pv_house_bonus = $row_total_team_pv_pro['SUM(house_bonus)'];

                

          }



          $select_query_total_team_old_wallet = "select SUM(binary_income), SUM(referral_income), SUM(roi_income), SUM(total_amount), SUM(processing_amount), SUM(net_payment), SUM(ups_bonus) from wallet_payout where member_no = '$member_no' AND status='0'";

              $run_total_team_old_wallet = mysqli_query($con,$select_query_total_team_old_wallet);

              while($row_total_team_old_wallet = mysqli_fetch_array($run_total_team_old_wallet)){

                    $total_team_old_binary_income = $row_total_team_old_wallet['SUM(binary_income)'];

                    $total_team_old_referral_income = $row_total_team_old_wallet['SUM(referral_income)'];

                    $total_team_old_roi_income = $row_total_team_old_wallet['SUM(roi_income)'];

                    $total_team_old_total_amount = $row_total_team_old_wallet['SUM(total_amount)'];

                    $total_team_old_processing_amount = $row_total_team_old_wallet['SUM(processing_amount)'];

                    $total_team_old_net_payment = $row_total_team_old_wallet['SUM(net_payment)'];

                    $total_team_old_ups_bonus = $row_total_team_old_wallet['SUM(ups_bonus)'];

                    

                    

              }





               $select_query_total_tour_bonus = "select SUM(amount), SUM(tds), SUM(netpay) from tour_bonus where member_no = '$member_no'";

                $run_total_tour_bonus = mysqli_query($con,$select_query_total_tour_bonus);

                while($row_total_tour_bonus = mysqli_fetch_array($run_total_tour_bonus)){

                      $total_team_old_amount = $row_total_tour_bonus['SUM(amount)'];

                      $total_team_old_tds = $row_total_tour_bonus['SUM(tds)'];

                      $total_team_old_netpay = $row_total_tour_bonus['SUM(netpay)']; 

                      

                      

                }



          





          $arr1_10a_pro = array();

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

          $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' AND product_no not in (".implode(',', $arr1_10a_pro).")";

          $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}%' 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}%'";

          $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



          $total_team_pv = $total_team_pv_1+$p_product_x1_10a+$extra_amount_bv+$total_percent_amount_1;

          $total_team_pvs = $total_team_pv_1+$p_product_x1_10a+$extra_amount_bv;



          //products







        $arr1 = array();

        $select_query_findempty_pay = "select * from roi_member where member_no = '$member_no_main'";

        $run_findempty_pay = mysqli_query($con,$select_query_findempty_pay);

        while ($row_findempty_pay = mysqli_fetch_array($run_findempty_pay)) {

         $arr1[] = $row_findempty_pay['used_no'];

        }



        $select_query_third_level_team = "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).")";

              $run_third_level_team = mysqli_query($con,$select_query_third_level_team);

              while($row_third_level_team = mysqli_fetch_array($run_third_level_team)){

                    $total_single_leg_1 = $row_third_level_team['SUM(roi_amount)'];

                    

              }



          $total_single_leg_current_view = $total_single_leg_1+$personal_pv_join+$p_cur_product_x1_10a;

            





          $select_query_main_1 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='1' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

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

          $check_level_1 = mysqli_num_rows($run_main_1);

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

          $tree_id_main_1 = $row_main_1['tree_id'];

          $group_number_main_1 = $row_main_1['group_number'];

          $member_no_main_1 = $row_main_1['member_no'];

          $sponsor_no_main_1 = $row_main_1['sponsor_no'];

          $level_no_main_1 = $row_main_1['level_no'];

          $relation_ship_no_main_1 = $row_main_1['relation_ship_no'];

          $x_position_main_1 = $row_main_1['x_position'];

        }



        if ($check_level_1 > 0) {

          



        $select_query_total_x1 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x1 = mysqli_query($con,$select_query_total_x1);

          while($row_total_x1 = mysqli_fetch_array($run_total_x1)){

                $total_x1 = $row_total_x1['SUM(product_amount)'];

                

          }



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

          $run_total_x1a = mysqli_query($con,$select_query_total_x1a);

          while($row_total_x1a = mysqli_fetch_array($run_total_x1a)){

                $total_x1a_1 = $row_total_x1a['SUM(roi_amount)'];

                

          }



          $select_query_group_t_1 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1}%' AND member_no <> '$member_no_main'";

          $run_group_t_1 = mysqli_query($con,$select_query_group_t_1);

          while($row_group_t_1 = mysqli_fetch_array($run_group_t_1)){

                $total_group_t_1 = $row_group_t_1['SUM(product_amount)'];

                

          }



          $select_query_group_t_1a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1}%' AND tree_id > '$tree_id_main'";

          $run_group_t_1a = mysqli_query($con,$select_query_group_t_1a);

          while($row_group_t_1a = mysqli_fetch_array($run_group_t_1a)){

                $total_group_t_1a = $row_group_t_1a['SUM(roi_amount)'];

                $total_percent_amount_1a = $row_group_t_1a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_1 = $total_group_t_1+$total_group_t_1a+$total_percent_amount_1a;



          $total_x1a = $total_x1a_1+$total_x1;



          $select_query_growth_1 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_1}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_1 = mysqli_query($con,$select_query_growth_1);

          $check_level_growth_1 = mysqli_num_rows($run_growth_1);



          if ($check_level_growth_1 == 0) {

             $total_cur_1 = $total_x1a_1+$total_x1;

             $growth_leg_1=0;

          }

          else {

            $total_cur_1 = 0;

            $growth_leg_1=1;

          }



        }else {

          $total_x1 =0;

          $total_x1a=0;

          $total_oagrbv_1 = 0;

        }





          $select_query_main_2 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='2' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_2 = mysqli_query($con,$select_query_main_2);

          $check_level_2 = mysqli_num_rows($run_main_2);

          while ($row_main_2 = mysqli_fetch_array($run_main_2)) {

          $tree_id_main_2 = $row_main_2['tree_id'];

          $group_number_main_2 = $row_main_2['group_number'];

          $member_no_main_2 = $row_main_2['member_no'];

          $sponsor_no_main_2 = $row_main_2['sponsor_no'];

          $level_no_main_2 = $row_main_2['level_no'];

          $relation_ship_no_main_2 = $row_main_2['relation_ship_no'];

          $x_position_main_2 = $row_main_2['x_position'];

        }



        if ($check_level_2 > 0) {



        $select_query_total_x2 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_2}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x2 = mysqli_query($con,$select_query_total_x2);

          while($row_total_x2 = mysqli_fetch_array($run_total_x2)){

                $total_x2 = $row_total_x2['SUM(product_amount)'];

                

          }

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

          $run_total_x2a = mysqli_query($con,$select_query_total_x2a);

          while($row_total_x2a = mysqli_fetch_array($run_total_x2a)){

                $total_x2a_1 = $row_total_x2a['SUM(roi_amount)'];

                

          }



          $select_query_group_t_2 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_2}%' AND member_no <> '$member_no_main'";

          $run_group_t_2 = mysqli_query($con,$select_query_group_t_2);

          while($row_group_t_2 = mysqli_fetch_array($run_group_t_2)){

                $total_group_t_2 = $row_group_t_2['SUM(product_amount)'];

                

          }



          $select_query_group_t_2a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_2}%' AND tree_id > '$tree_id_main'";

          $run_group_t_2a = mysqli_query($con,$select_query_group_t_2a);

          while($row_group_t_2a = mysqli_fetch_array($run_group_t_2a)){

                $total_group_t_2a = $row_group_t_2a['SUM(roi_amount)'];

                $total_percent_amount_2a = $row_group_t_2a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_2 = $total_group_t_2+$total_group_t_2a+$total_percent_amount_2a;





          $total_x2a = $total_x2a_1+$total_x2;



          $select_query_growth_2 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_2}%' AND tree_id > '$tree_id_main' AND rank > '0'";

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

          $check_level_growth_2 = mysqli_num_rows($run_growth_2);



            if ($check_level_growth_2 == 0) {

               $total_cur_2 = $total_x2a_1+$total_x2;

               $growth_leg_2=0;

            }

            else {

              $total_cur_2 = 0;

              $growth_leg_2=1;

            }

        }

        else {

             $total_x2 =0;

             $total_x2a=0;

             $total_oagrbv_2 = 0;

        }



        $select_query_main_3 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='3' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_3 = mysqli_query($con,$select_query_main_3);

          $check_level_3 = mysqli_num_rows($run_main_3);

          while ($row_main_3 = mysqli_fetch_array($run_main_3)) {

          $tree_id_main_3 = $row_main_3['tree_id'];

          $group_number_main_3 = $row_main_3['group_number'];

          $member_no_main_3 = $row_main_3['member_no'];

          $sponsor_no_main_3 = $row_main_3['sponsor_no'];

          $level_no_main_3 = $row_main_3['level_no'];

          $relation_ship_no_main_3 = $row_main_3['relation_ship_no'];

          $x_position_main_3 = $row_main_3['x_position'];

        }



        if ($check_level_3 > 0) {



        $select_query_total_x3 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_3}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x3 = mysqli_query($con,$select_query_total_x3);

          while($row_total_x3 = mysqli_fetch_array($run_total_x3)){

                $total_x3 = $row_total_x3['SUM(product_amount)'];

                

          }



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

          $run_total_x3a = mysqli_query($con,$select_query_total_x3a);

          while($row_total_x3a = mysqli_fetch_array($run_total_x3a)){

                $total_x3a_1 = $row_total_x3a['SUM(roi_amount)'];

                

          }



          $select_query_group_t_3 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_3}%' AND member_no <> '$member_no_main'";

          $run_group_t_3 = mysqli_query($con,$select_query_group_t_3);

          while($row_group_t_3 = mysqli_fetch_array($run_group_t_3)){

                $total_group_t_3 = $row_group_t_3['SUM(product_amount)'];

                

          }



          $select_query_group_t_3a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_3}%' AND tree_id > '$tree_id_main'";

          $run_group_t_3a = mysqli_query($con,$select_query_group_t_3a);

          while($row_group_t_3a = mysqli_fetch_array($run_group_t_3a)){

                $total_group_t_3a = $row_group_t_3a['SUM(roi_amount)'];

                $total_percent_amount_3a = $row_group_t_3a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_3 = $total_group_t_3+$total_group_t_3a+$total_percent_amount_3a;





          $total_x3a = $total_x3a_1+$total_x3;



          $select_query_growth_3 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_3}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_3 = mysqli_query($con,$select_query_growth_3);

          $check_level_growth_3 = mysqli_num_rows($run_growth_3);



          if ($check_level_growth_3 == 0) {

             $total_cur_3 = $total_x3a_1+$total_x3;

             $growth_leg_3=0;

          }

          else {

            $total_cur_3 = 0;

            $growth_leg_3=1;

          }

        }

        else {



          $total_x3 =0;

             $total_x3a=0;

             $total_oagrbv_3 = 0;



        }





          $select_query_main_4 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='4' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_4 = mysqli_query($con,$select_query_main_4);

          $check_level_4 = mysqli_num_rows($run_main_4);

          while ($row_main_4 = mysqli_fetch_array($run_main_4)) {

          $tree_id_main_4 = $row_main_4['tree_id'];

          $group_number_main_4 = $row_main_4['group_number'];

          $member_no_main_4 = $row_main_4['member_no'];

          $sponsor_no_main_4 = $row_main_4['sponsor_no'];

          $level_no_main_4 = $row_main_4['level_no'];

          $relation_ship_no_main_4 = $row_main_4['relation_ship_no'];

          $x_position_main_4 = $row_main_4['x_position'];

        }



        if ($check_level_4 > 0) {



        $select_query_total_x4 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_4}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x4 = mysqli_query($con,$select_query_total_x4);

          while($row_total_x4 = mysqli_fetch_array($run_total_x4)){

                $total_x4 = $row_total_x4['SUM(product_amount)'];

                

          }



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

          $run_total_x4a = mysqli_query($con,$select_query_total_x4a);

          while($row_total_x4a = mysqli_fetch_array($run_total_x4a)){

                $total_x4a_1 = $row_total_x4a['SUM(roi_amount)'];

                

          }



          $select_query_group_t_4 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_4}%' AND member_no <> '$member_no_main'";

          $run_group_t_4 = mysqli_query($con,$select_query_group_t_4);

          while($row_group_t_4 = mysqli_fetch_array($run_group_t_4)){

                $total_group_t_4 = $row_group_t_4['SUM(product_amount)'];

                

          }



          $select_query_group_t_4a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_4}%' AND tree_id > '$tree_id_main'";

          $run_group_t_4a = mysqli_query($con,$select_query_group_t_4a);

          while($row_group_t_4a = mysqli_fetch_array($run_group_t_4a)){

                $total_group_t_4a = $row_group_t_4a['SUM(roi_amount)'];

                $total_percent_amount_4a = $row_group_t_4a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_4 = $total_group_t_4+$total_group_t_4a+$total_percent_amount_4a;





          $total_x4a = $total_x4a_1+$total_x4;



           $select_query_growth_4 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_4}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_4 = mysqli_query($con,$select_query_growth_4);

          $check_level_growth_4 = mysqli_num_rows($run_growth_4);



          if ($check_level_growth_4 == 0) {

             $total_cur_4 = $total_x4a_1+$total_x4;

             $growth_leg_4=0;

          }

          else {

            $total_cur_4 = 0;

            $growth_leg_4=1;

          }



        }else {



          $total_x4 =0;

             $total_x4a=0;

             $total_oagrbv_4 = 0;



        }





          $select_query_main_5 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='5' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_5 = mysqli_query($con,$select_query_main_5);

          $check_level_5 = mysqli_num_rows($run_main_5);

          while ($row_main_5 = mysqli_fetch_array($run_main_5)) {

          $tree_id_main_5 = $row_main_5['tree_id'];

          $group_number_main_5 = $row_main_5['group_number'];

          $member_no_main_5 = $row_main_5['member_no'];

          $sponsor_no_main_5 = $row_main_5['sponsor_no'];

          $level_no_main_5 = $row_main_5['level_no'];

          $relation_ship_no_main_5 = $row_main_5['relation_ship_no'];

          $x_position_main_5 = $row_main_5['x_position'];

        }



        if ($check_level_5 > 0) {



        $select_query_total_x5 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_5}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x5 = mysqli_query($con,$select_query_total_x5);

          while($row_total_x5 = mysqli_fetch_array($run_total_x5)){

                $total_x5 = $row_total_x5['SUM(product_amount)'];

          }



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

          $run_total_x5a = mysqli_query($con,$select_query_total_x5a);

          while($row_total_x5a = mysqli_fetch_array($run_total_x5a)){

                $total_x5a_1 = $row_total_x5a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_5 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_5}%' AND member_no <> '$member_no_main'";

          $run_group_t_5 = mysqli_query($con,$select_query_group_t_5);

          while($row_group_t_5 = mysqli_fetch_array($run_group_t_5)){

                $total_group_t_5 = $row_group_t_5['SUM(product_amount)'];

                

          }



          $select_query_group_t_5a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_5}%' AND tree_id > '$tree_id_main'";

          $run_group_t_5a = mysqli_query($con,$select_query_group_t_5a);

          while($row_group_t_5a = mysqli_fetch_array($run_group_t_5a)){

                $total_group_t_5a = $row_group_t_5a['SUM(roi_amount)'];

                $total_percent_amount_5a = $row_group_t_5a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_5 = $total_group_t_5+$total_group_t_5a+$total_percent_amount_5a;





          $total_x5a = $total_x5a_1+$total_x5;



          $select_query_growth_5 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_5}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_5 = mysqli_query($con,$select_query_growth_5);

          $check_level_growth_5 = mysqli_num_rows($run_growth_5);



          if ($check_level_growth_5 == 0) {

             $total_cur_5 = $total_x5a_1+$total_x5;

             $growth_leg_5=0;

          }

          else {

            $total_cur_5 = 0;

            $growth_leg_5=1;

          }



        }else {



          $total_x5 =0;

             $total_x5a=0;

             $total_oagrbv_5 = 0;



        }



        $select_query_main_6 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='6' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_6 = mysqli_query($con,$select_query_main_6);

          $check_level_6 = mysqli_num_rows($run_main_6);

          while ($row_main_6 = mysqli_fetch_array($run_main_6)) {

          $tree_id_main_6 = $row_main_6['tree_id'];

          $group_number_main_6 = $row_main_6['group_number'];

          $member_no_main_6 = $row_main_6['member_no'];

          $sponsor_no_main_6 = $row_main_6['sponsor_no'];

          $level_no_main_6 = $row_main_6['level_no'];

          $relation_ship_no_main_6 = $row_main_6['relation_ship_no'];

          $x_position_main_6 = $row_main_6['x_position'];

        }



        if ($check_level_6 > 0) {



        $select_query_total_x6 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_6}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x6 = mysqli_query($con,$select_query_total_x6);

          while($row_total_x6 = mysqli_fetch_array($run_total_x6)){

                $total_x6 = $row_total_x6['SUM(product_amount)'];

          }



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

          $run_total_x6a = mysqli_query($con,$select_query_total_x6a);

          while($row_total_x6a = mysqli_fetch_array($run_total_x6a)){

                $total_x6a_1 = $row_total_x6a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_6 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_6}%' AND member_no <> '$member_no_main'";

          $run_group_t_6 = mysqli_query($con,$select_query_group_t_6);

          while($row_group_t_6 = mysqli_fetch_array($run_group_t_6)){

                $total_group_t_6 = $row_group_t_6['SUM(product_amount)'];

                

          }



          $select_query_group_t_6a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_6}%' AND tree_id > '$tree_id_main'";

          $run_group_t_6a = mysqli_query($con,$select_query_group_t_6a);

          while($row_group_t_6a = mysqli_fetch_array($run_group_t_6a)){

                $total_group_t_6a = $row_group_t_6a['SUM(roi_amount)'];

                $total_percent_amount_6a = $row_group_t_6a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_6 = $total_group_t_6+$total_group_t_6a+$total_percent_amount_6a;





          $total_x6a = $total_x6a_1+$total_x6;



          $select_query_growth_6 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_6}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_6 = mysqli_query($con,$select_query_growth_6);

          $check_level_growth_6 = mysqli_num_rows($run_growth_6);



          if ($check_level_growth_6 == 0) {

             $total_cur_6 = $total_x6a_1+$total_x6;

             $growth_leg_6=0;

          }

          else {

            $total_cur_6 = 0;

            $growth_leg_6=1;

          }



        }else {



          $total_x6 =0;

             $total_x6a=0;

             $total_oagrbv_6 = 0;



        }



        $select_query_main_7 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='7' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_7 = mysqli_query($con,$select_query_main_7);

          $check_level_7 = mysqli_num_rows($run_main_7);

          while ($row_main_7 = mysqli_fetch_array($run_main_7)) {

          $tree_id_main_7 = $row_main_7['tree_id'];

          $group_number_main_7 = $row_main_7['group_number'];

          $member_no_main_7 = $row_main_7['member_no'];

          $sponsor_no_main_7 = $row_main_7['sponsor_no'];

          $level_no_main_7 = $row_main_7['level_no'];

          $relation_ship_no_main_7 = $row_main_7['relation_ship_no'];

          $x_position_main_7 = $row_main_7['x_position'];

        }



        if ($check_level_7 > 0) {



        $select_query_total_x7 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_7}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x7 = mysqli_query($con,$select_query_total_x7);

          while($row_total_x7 = mysqli_fetch_array($run_total_x7)){

                $total_x7 = $row_total_x7['SUM(product_amount)'];

          }



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

          $run_total_x7a = mysqli_query($con,$select_query_total_x7a);

          while($row_total_x7a = mysqli_fetch_array($run_total_x7a)){

                $total_x7a_1 = $row_total_x7a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_7 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_7}%' AND member_no <> '$member_no_main'";

          $run_group_t_7 = mysqli_query($con,$select_query_group_t_7);

          while($row_group_t_7 = mysqli_fetch_array($run_group_t_7)){

                $total_group_t_7 = $row_group_t_7['SUM(product_amount)'];

                

          }



          $select_query_group_t_7a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_7}%' AND tree_id > '$tree_id_main'";

          $run_group_t_7a = mysqli_query($con,$select_query_group_t_7a);

          while($row_group_t_7a = mysqli_fetch_array($run_group_t_7a)){

                $total_group_t_7a = $row_group_t_7a['SUM(roi_amount)'];

                $total_percent_amount_7a = $row_group_t_7a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_7 = $total_group_t_7+$total_group_t_7a+$total_percent_amount_7a;





          $total_x7a = $total_x7a_1+$total_x7;



          $select_query_growth_7 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_7}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_7 = mysqli_query($con,$select_query_growth_7);

          $check_level_growth_7 = mysqli_num_rows($run_growth_7);



          if ($check_level_growth_7 == 0) {

             $total_cur_7 = $total_x7a_1+$total_x7;

             $growth_leg_7=0;

          }

          else {

            $total_cur_7 = 0;

            $growth_leg_7=1;

          }



        }else {



          $total_x7 =0;

             $total_x7a=0;

             $total_oagrbv_7 = 0;



        }



        $select_query_main_8 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='8' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_8 = mysqli_query($con,$select_query_main_8);

          $check_level_8 = mysqli_num_rows($run_main_8);

          while ($row_main_8 = mysqli_fetch_array($run_main_8)) {

          $tree_id_main_8 = $row_main_8['tree_id'];

          $group_number_main_8 = $row_main_8['group_number'];

          $member_no_main_8 = $row_main_8['member_no'];

          $sponsor_no_main_8 = $row_main_8['sponsor_no'];

          $level_no_main_8 = $row_main_8['level_no'];

          $relation_ship_no_main_8 = $row_main_8['relation_ship_no'];

          $x_position_main_8 = $row_main_8['x_position'];

        }



        if ($check_level_8 > 0) {



        $select_query_total_x8 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_8}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x8 = mysqli_query($con,$select_query_total_x8);

          while($row_total_x8 = mysqli_fetch_array($run_total_x8)){

                $total_x8 = $row_total_x8['SUM(product_amount)'];

          }



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

          $run_total_x8a = mysqli_query($con,$select_query_total_x8a);

          while($row_total_x8a = mysqli_fetch_array($run_total_x8a)){

                $total_x8a_1 = $row_total_x8a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_8 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_8}%' AND member_no <> '$member_no_main'";

          $run_group_t_8 = mysqli_query($con,$select_query_group_t_8);

          while($row_group_t_8 = mysqli_fetch_array($run_group_t_8)){

                $total_group_t_8 = $row_group_t_8['SUM(product_amount)'];

                

          }



          $select_query_group_t_8a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_8}%' AND tree_id > '$tree_id_main'";

          $run_group_t_8a = mysqli_query($con,$select_query_group_t_8a);

          while($row_group_t_8a = mysqli_fetch_array($run_group_t_8a)){

                $total_group_t_8a = $row_group_t_8a['SUM(roi_amount)'];

                $total_percent_amount_8a = $row_group_t_8a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_8 = $total_group_t_8+$total_group_t_8a+$total_percent_amount_8a;





          $total_x8a = $total_x8a_1+$total_x8;



          $select_query_growth_8 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_8}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_8 = mysqli_query($con,$select_query_growth_8);

          $check_level_growth_8 = mysqli_num_rows($run_growth_8);



          if ($check_level_growth_8 == 0) {

             $total_cur_8 = $total_x8a_1+$total_x8;

             $growth_leg_8=0;

          }

          else {

            $total_cur_8 = 0;

            $growth_leg_8=1;

          }



        }else {



          $total_x8 =0;

             $total_x8a=0;

             $total_oagrbv_8 = 0;



        }



        $select_query_main_9 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='9' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_9 = mysqli_query($con,$select_query_main_9);

          $check_level_9 = mysqli_num_rows($run_main_9);

          while ($row_main_9 = mysqli_fetch_array($run_main_9)) {

          $tree_id_main_9 = $row_main_9['tree_id'];

          $group_number_main_9 = $row_main_9['group_number'];

          $member_no_main_9 = $row_main_9['member_no'];

          $sponsor_no_main_9 = $row_main_9['sponsor_no'];

          $level_no_main_9 = $row_main_9['level_no'];

          $relation_ship_no_main_9 = $row_main_9['relation_ship_no'];

          $x_position_main_9 = $row_main_9['x_position'];

        }



        if ($check_level_9 > 0) {



        $select_query_total_x9 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_9}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x9 = mysqli_query($con,$select_query_total_x9);

          while($row_total_x9 = mysqli_fetch_array($run_total_x9)){

                $total_x9 = $row_total_x9['SUM(product_amount)'];

          }



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

          $run_total_x9a = mysqli_query($con,$select_query_total_x9a);

          while($row_total_x9a = mysqli_fetch_array($run_total_x9a)){

                $total_x9a_1 = $row_total_x9a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_9 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_9}%' AND member_no <> '$member_no_main'";

          $run_group_t_9 = mysqli_query($con,$select_query_group_t_9);

          while($row_group_t_9 = mysqli_fetch_array($run_group_t_9)){

                $total_group_t_9 = $row_group_t_9['SUM(product_amount)'];

                

          }



          $select_query_group_t_9a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_9}%' AND tree_id > '$tree_id_main'";

          $run_group_t_9a = mysqli_query($con,$select_query_group_t_9a);

          while($row_group_t_9a = mysqli_fetch_array($run_group_t_9a)){

                $total_group_t_9a = $row_group_t_9a['SUM(roi_amount)'];

                $total_percent_amount_9a = $row_group_t_9a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_9 = $total_group_t_9+$total_group_t_9a+$total_percent_amount_9a;





          $total_x9a = $total_x9a_1+$total_x9;



           $select_query_growth_9 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_9}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_9 = mysqli_query($con,$select_query_growth_9);

          $check_level_growth_9 = mysqli_num_rows($run_growth_9);



          if ($check_level_growth_9 == 0) {

             $total_cur_9 = $total_x9a_1+$total_x9;

             $growth_leg_9=0;

          }

          else {

            $total_cur_9 = 0;

            $growth_leg_9=1;

          }

        }else {



          $total_x9 =0;

             $total_x9a=0;

             $total_oagrbv_9 = 0;



        }



        $select_query_main_10 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='10' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_10 = mysqli_query($con,$select_query_main_10);

          $check_level_10 = mysqli_num_rows($run_main_10);

          while ($row_main_10 = mysqli_fetch_array($run_main_10)) {

          $tree_id_main_10 = $row_main_10['tree_id'];

          $group_number_main_10 = $row_main_10['group_number'];

          $member_no_main_10 = $row_main_10['member_no'];

          $sponsor_no_main_10 = $row_main_10['sponsor_no'];

          $level_no_main_10 = $row_main_10['level_no'];

          $relation_ship_no_main_10 = $row_main_10['relation_ship_no'];

          $x_position_main_10 = $row_main_10['x_position'];

        }



        if ($check_level_10 > 0) {



        $select_query_total_x10 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x10 = mysqli_query($con,$select_query_total_x10);

          while($row_total_x10 = mysqli_fetch_array($run_total_x10)){

                $total_x10 = $row_total_x10['SUM(product_amount)'];

          }



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

          $run_total_x10a = mysqli_query($con,$select_query_total_x10a);

          while($row_total_x10a = mysqli_fetch_array($run_total_x10a)){

                $total_x10a_1 = $row_total_x10a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_10 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10}%' AND member_no <> '$member_no_main'";

          $run_group_t_10 = mysqli_query($con,$select_query_group_t_10);

          while($row_group_t_10 = mysqli_fetch_array($run_group_t_10)){

                $total_group_t_10 = $row_group_t_10['SUM(product_amount)'];

                

          }



          $select_query_group_t_10a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10}%' AND tree_id > '$tree_id_main'";

          $run_group_t_10a = mysqli_query($con,$select_query_group_t_10a);

          while($row_group_t_10a = mysqli_fetch_array($run_group_t_10a)){

                $total_group_t_10a = $row_group_t_10a['SUM(roi_amount)'];

                $total_percent_amount_10a = $row_group_t_10a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_10 = $total_group_t_10+$total_group_t_10a+$total_percent_amount_10a;





          $total_x10a = $total_x10a_1+$total_x10;



           $select_query_growth_10 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_10}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_10 = mysqli_query($con,$select_query_growth_10);

          $check_level_growth_10 = mysqli_num_rows($run_growth_10);



          if ($check_level_growth_10 == 0) {

             $total_cur_10 = $total_x10a_1+$total_x10;

             $growth_leg_10=0;

          }

          else {

            $total_cur_10 = 0;

            $growth_leg_10=1;

          }



        }else {



          $total_x10 =0;

             $total_x10a=0;

             $total_oagrbv_10 = 0;



        }







        $select_query_main_11 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='11' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_11 = mysqli_query($con,$select_query_main_11);

          $check_level_11 = mysqli_num_rows($run_main_11);

          while ($row_main_11 = mysqli_fetch_array($run_main_11)) {

          $tree_id_main_11 = $row_main_11['tree_id'];

          $group_number_main_11 = $row_main_11['group_number'];

          $member_no_main_11 = $row_main_11['member_no'];

          $sponsor_no_main_11 = $row_main_11['sponsor_no'];

          $level_no_main_11 = $row_main_11['level_no'];

          $relation_ship_no_main_11 = $row_main_11['relation_ship_no'];

          $x_position_main_11 = $row_main_11['x_position'];

        }



        if ($check_level_11 > 0) {

          



        $select_query_total_x11 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_11}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x11 = mysqli_query($con,$select_query_total_x11);

          while($row_total_x11 = mysqli_fetch_array($run_total_x11)){

                $total_x11 = $row_total_x11['SUM(product_amount)'];

                

          }



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

          $run_total_x11a = mysqli_query($con,$select_query_total_x11a);

          while($row_total_x11a = mysqli_fetch_array($run_total_x11a)){

                $total_x11a_11 = $row_total_x11a['SUM(roi_amount)'];

                

          }



          $select_query_group_t_11 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_11}%' AND member_no <> '$member_no_main'";

          $run_group_t_11 = mysqli_query($con,$select_query_group_t_11);

          while($row_group_t_11 = mysqli_fetch_array($run_group_t_11)){

                $total_group_t_11 = $row_group_t_11['SUM(product_amount)'];

                

          }



          $select_query_group_t_11a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_11}%' AND tree_id > '$tree_id_main'";

          $run_group_t_11a = mysqli_query($con,$select_query_group_t_11a);

          while($row_group_t_11a = mysqli_fetch_array($run_group_t_11a)){

                $total_group_t_11a = $row_group_t_11a['SUM(roi_amount)'];

                $total_percent_amount_11a = $row_group_t_11a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_11 = $total_group_t_11+$total_group_t_11a+$total_percent_amount_11a;





          $total_x11a = $total_x11a_11+$total_x11;



           $select_query_growth_11 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_11}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_11 = mysqli_query($con,$select_query_growth_11);

          $check_level_growth_11 = mysqli_num_rows($run_growth_11);



          if ($check_level_growth_11 == 0) {

             $total_cur_11 = $total_x11a_1+$total_x11;

             $growth_leg_11=0;

          }

          else {

            $total_cur_11 = 0;

            $growth_leg_11=1;

          }



        }else {

          $total_x11 =0;

          $total_x11a=0;

          $total_oagrbv_11 = 0;

        }





          $select_query_main_12 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='12' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_12 = mysqli_query($con,$select_query_main_12);

          $check_level_12 = mysqli_num_rows($run_main_12);

          while ($row_main_12 = mysqli_fetch_array($run_main_12)) {

          $tree_id_main_12 = $row_main_12['tree_id'];

          $group_number_main_12 = $row_main_12['group_number'];

          $member_no_main_12 = $row_main_12['member_no'];

          $sponsor_no_main_12 = $row_main_12['sponsor_no'];

          $level_no_main_12 = $row_main_12['level_no'];

          $relation_ship_no_main_12 = $row_main_12['relation_ship_no'];

          $x_position_main_12 = $row_main_12['x_position'];

        }



        if ($check_level_12 > 0) {



        $select_query_total_x12 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_12}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x12 = mysqli_query($con,$select_query_total_x12);

          while($row_total_x12 = mysqli_fetch_array($run_total_x12)){

                $total_x12 = $row_total_x12['SUM(product_amount)'];

                

          }

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

          $run_total_x12a = mysqli_query($con,$select_query_total_x12a);

          while($row_total_x12a = mysqli_fetch_array($run_total_x12a)){

                $total_x12a_1 = $row_total_x12a['SUM(roi_amount)'];

                

          }



          $select_query_group_t_12 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_12}%' AND member_no <> '$member_no_main'";

          $run_group_t_12 = mysqli_query($con,$select_query_group_t_12);

          while($row_group_t_12 = mysqli_fetch_array($run_group_t_12)){

                $total_group_t_12 = $row_group_t_12['SUM(product_amount)'];

                

          }



          $select_query_group_t_12a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_12}%' AND tree_id > '$tree_id_main'";

          $run_group_t_12a = mysqli_query($con,$select_query_group_t_12a);

          while($row_group_t_12a = mysqli_fetch_array($run_group_t_12a)){

                $total_group_t_12a = $row_group_t_12a['SUM(roi_amount)'];

                $total_percent_amount_12a = $row_group_t_12a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_12 = $total_group_t_12+$total_group_t_12a+$total_percent_amount_12a;



          $total_x12a = $total_x12a_1+$total_x12;



           $select_query_growth_12 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_12}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_12 = mysqli_query($con,$select_query_growth_12);

          $check_level_growth_12 = mysqli_num_rows($run_growth_12);



          if ($check_level_growth_12 == 0) {

             $total_cur_12 = $total_x12a_1+$total_x12;

             $growth_leg_12=0;

          }

          else {

            $total_cur_12 = 0;

            $growth_leg_12=1;

          }



        }

        else {

             $total_x12 =0;

             $total_x12a=0;

             $total_oagrbv_12 = 0;

        }



        $select_query_main_13 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='13' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_13 = mysqli_query($con,$select_query_main_13);

          $check_level_13 = mysqli_num_rows($run_main_13);

          while ($row_main_13 = mysqli_fetch_array($run_main_13)) {

          $tree_id_main_13 = $row_main_13['tree_id'];

          $group_number_main_13 = $row_main_13['group_number'];

          $member_no_main_13 = $row_main_13['member_no'];

          $sponsor_no_main_13 = $row_main_13['sponsor_no'];

          $level_no_main_13 = $row_main_13['level_no'];

          $relation_ship_no_main_13 = $row_main_13['relation_ship_no'];

          $x_position_main_13 = $row_main_13['x_position'];

        }



        if ($check_level_13 > 0) {



        $select_query_total_x13 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_13}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x13 = mysqli_query($con,$select_query_total_x13);

          while($row_total_x13 = mysqli_fetch_array($run_total_x13)){

                $total_x13 = $row_total_x13['SUM(product_amount)'];

                

          }



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

          $run_total_x13a = mysqli_query($con,$select_query_total_x13a);

          while($row_total_x13a = mysqli_fetch_array($run_total_x13a)){

                $total_x13a_1 = $row_total_x13a['SUM(roi_amount)'];

                

          }



          $select_query_group_t_13 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_13}%' AND member_no <> '$member_no_main'";

          $run_group_t_13 = mysqli_query($con,$select_query_group_t_13);

          while($row_group_t_13 = mysqli_fetch_array($run_group_t_13)){

                $total_group_t_13 = $row_group_t_13['SUM(product_amount)'];

                

          }



          $select_query_group_t_13a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_13}%' AND tree_id > '$tree_id_main'";

          $run_group_t_13a = mysqli_query($con,$select_query_group_t_13a);

          while($row_group_t_13a = mysqli_fetch_array($run_group_t_13a)){

                $total_group_t_13a = $row_group_t_13a['SUM(roi_amount)'];

                $total_percent_amount_13a = $row_group_t_13a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_13 = $total_group_t_13+$total_group_t_13a+$total_percent_amount_13a;





          $total_x13a = $total_x13a_1+$total_x13;



           $select_query_growth_13 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_13}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_13 = mysqli_query($con,$select_query_growth_13);

          $check_level_growth_13 = mysqli_num_rows($run_growth_13);



          if ($check_level_growth_13 == 0) {

             $total_cur_13 = $total_x13a_1+$total_x13;

             $growth_leg_13=0;

          }

          else {

            $total_cur_13 = 0;

            $growth_leg_13=1;

          }



        }

        else {



          $total_x13 =0;

             $total_x13a=0;

             $total_oagrbv_13 = 0;



        }





          $select_query_main_14 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='14' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_14 = mysqli_query($con,$select_query_main_14);

          $check_level_14 = mysqli_num_rows($run_main_14);

          while ($row_main_14 = mysqli_fetch_array($run_main_14)) {

          $tree_id_main_14 = $row_main_14['tree_id'];

          $group_number_main_14 = $row_main_14['group_number'];

          $member_no_main_14 = $row_main_14['member_no'];

          $sponsor_no_main_14 = $row_main_14['sponsor_no'];

          $level_no_main_14 = $row_main_14['level_no'];

          $relation_ship_no_main_14 = $row_main_14['relation_ship_no'];

          $x_position_main_14 = $row_main_14['x_position'];

        }



        if ($check_level_14 > 0) {



        $select_query_total_x14 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_14}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x14 = mysqli_query($con,$select_query_total_x14);

          while($row_total_x14 = mysqli_fetch_array($run_total_x14)){

                $total_x14 = $row_total_x14['SUM(product_amount)'];

                

          }



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

          $run_total_x14a = mysqli_query($con,$select_query_total_x14a);

          while($row_total_x14a = mysqli_fetch_array($run_total_x14a)){

                $total_x14a_1 = $row_total_x14a['SUM(roi_amount)'];

                

          }



          $select_query_group_t_14 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_14}%' AND member_no <> '$member_no_main'";

          $run_group_t_14 = mysqli_query($con,$select_query_group_t_14);

          while($row_group_t_14 = mysqli_fetch_array($run_group_t_14)){

                $total_group_t_14 = $row_group_t_14['SUM(product_amount)'];

                

          }



          $select_query_group_t_14a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_14}%' AND tree_id > '$tree_id_main'";

          $run_group_t_14a = mysqli_query($con,$select_query_group_t_14a);

          while($row_group_t_14a = mysqli_fetch_array($run_group_t_14a)){

                $total_group_t_14a = $row_group_t_14a['SUM(roi_amount)'];

                $total_percent_amount_14a = $row_group_t_14a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_14 = $total_group_t_14+$total_group_t_14a+$total_percent_amount_14a;





          $total_x14a = $total_x14a_1+$total_x14;



           $select_query_growth_14 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_14}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_14 = mysqli_query($con,$select_query_growth_14);

          $check_level_growth_14 = mysqli_num_rows($run_growth_14);



          if ($check_level_growth_14 == 0) {

             $total_cur_14 = $total_x14a_1+$total_x14;

             $growth_leg_14=0;

          }

          else {

            $total_cur_14 = 0;

            $growth_leg_14=1;

          }



        }else {



          $total_x14 =0;

             $total_x14a=0;

             $total_oagrbv_14 = 0;



        }





          $select_query_main_15 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='15' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_15 = mysqli_query($con,$select_query_main_15);

          $check_level_15 = mysqli_num_rows($run_main_15);

          while ($row_main_15 = mysqli_fetch_array($run_main_15)) {

          $tree_id_main_15 = $row_main_15['tree_id'];

          $group_number_main_15 = $row_main_15['group_number'];

          $member_no_main_15 = $row_main_15['member_no'];

          $sponsor_no_main_15 = $row_main_15['sponsor_no'];

          $level_no_main_15 = $row_main_15['level_no'];

          $relation_ship_no_main_15 = $row_main_15['relation_ship_no'];

          $x_position_main_15 = $row_main_15['x_position'];

        }



        if ($check_level_15 > 0) {



        $select_query_total_x15 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_15}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x15 = mysqli_query($con,$select_query_total_x15);

          while($row_total_x15 = mysqli_fetch_array($run_total_x15)){

                $total_x15 = $row_total_x15['SUM(product_amount)'];

          }



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

          $run_total_x15a = mysqli_query($con,$select_query_total_x15a);

          while($row_total_x15a = mysqli_fetch_array($run_total_x15a)){

                $total_x15a_1 = $row_total_x15a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_15 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_15}%' AND member_no <> '$member_no_main'";

          $run_group_t_15 = mysqli_query($con,$select_query_group_t_15);

          while($row_group_t_15 = mysqli_fetch_array($run_group_t_15)){

                $total_group_t_15 = $row_group_t_15['SUM(product_amount)'];

                

          }



          $select_query_group_t_15a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_15}%' AND tree_id > '$tree_id_main'";

          $run_group_t_15a = mysqli_query($con,$select_query_group_t_15a);

          while($row_group_t_15a = mysqli_fetch_array($run_group_t_15a)){

                $total_group_t_15a = $row_group_t_15a['SUM(roi_amount)'];

                $total_percent_amount_15a = $row_group_t_15a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_15 = $total_group_t_15+$total_group_t_15a+$total_percent_amount_15a;





          $total_x15a = $total_x15a_1+$total_x15;



           $select_query_growth_15 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_15}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_15 = mysqli_query($con,$select_query_growth_15);

          $check_level_growth_15 = mysqli_num_rows($run_growth_15);



          if ($check_level_growth_15 == 0) {

             $total_cur_15 = $total_x15a_1+$total_x15;

             $growth_leg_15=0;

          }

          else {

            $total_cur_15 = 0;

            $growth_leg_15=1;

          }



        }else {



          $total_x15 =0;

             $total_x15a=0;

             $total_oagrbv_15 = 0;



        }



        $select_query_main_16 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='16' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_16 = mysqli_query($con,$select_query_main_16);

          $check_level_16 = mysqli_num_rows($run_main_16);

          while ($row_main_16 = mysqli_fetch_array($run_main_16)) {

          $tree_id_main_16 = $row_main_16['tree_id'];

          $group_number_main_16 = $row_main_16['group_number'];

          $member_no_main_16 = $row_main_16['member_no'];

          $sponsor_no_main_16 = $row_main_16['sponsor_no'];

          $level_no_main_16 = $row_main_16['level_no'];

          $relation_ship_no_main_16 = $row_main_16['relation_ship_no'];

          $x_position_main_16 = $row_main_16['x_position'];

        }



        if ($check_level_16 > 0) {



        $select_query_total_x16 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_16}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x16 = mysqli_query($con,$select_query_total_x16);

          while($row_total_x16 = mysqli_fetch_array($run_total_x16)){

                $total_x16 = $row_total_x16['SUM(product_amount)'];

          }



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

          $run_total_x16a = mysqli_query($con,$select_query_total_x16a);

          while($row_total_x16a = mysqli_fetch_array($run_total_x16a)){

                $total_x16a_1 = $row_total_x16a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_16 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_16}%' AND member_no <> '$member_no_main'";

          $run_group_t_16 = mysqli_query($con,$select_query_group_t_16);

          while($row_group_t_16 = mysqli_fetch_array($run_group_t_16)){

                $total_group_t_16 = $row_group_t_16['SUM(product_amount)'];

                

          }



          $select_query_group_t_16a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_16}%' AND tree_id > '$tree_id_main'";

          $run_group_t_16a = mysqli_query($con,$select_query_group_t_16a);

          while($row_group_t_16a = mysqli_fetch_array($run_group_t_16a)){

                $total_group_t_16a = $row_group_t_16a['SUM(roi_amount)'];

                $total_percent_amount_16a = $row_group_t_16a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_16 = $total_group_t_16+$total_group_t_16a+$total_percent_amount_16a;





          $total_x16a = $total_x16a_1+$total_x16;



           $select_query_growth_16 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_16}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_16 = mysqli_query($con,$select_query_growth_16);

          $check_level_growth_16 = mysqli_num_rows($run_growth_16);



          if ($check_level_growth_16 == 0) {

             $total_cur_16 = $total_x16a_1+$total_x16;

             $growth_leg_16=0;

          }

          else {

            $total_cur_16 = 0;

            $growth_leg_16=1;

          }



        }else {



          $total_x16 =0;

             $total_x16a=0;

             $total_oagrbv_16 = 0;



        }



        $select_query_main_17 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='17' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_17 = mysqli_query($con,$select_query_main_17);

          $check_level_17 = mysqli_num_rows($run_main_17);

          while ($row_main_17 = mysqli_fetch_array($run_main_17)) {

          $tree_id_main_17 = $row_main_17['tree_id'];

          $group_number_main_17 = $row_main_17['group_number'];

          $member_no_main_17 = $row_main_17['member_no'];

          $sponsor_no_main_17 = $row_main_17['sponsor_no'];

          $level_no_main_17 = $row_main_17['level_no'];

          $relation_ship_no_main_17 = $row_main_17['relation_ship_no'];

          $x_position_main_17 = $row_main_17['x_position'];

        }



        if ($check_level_17 > 0) {



        $select_query_total_x17 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_17}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x17 = mysqli_query($con,$select_query_total_x17);

          while($row_total_x17 = mysqli_fetch_array($run_total_x17)){

                $total_x17 = $row_total_x17['SUM(product_amount)'];

          }



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

          $run_total_x17a = mysqli_query($con,$select_query_total_x17a);

          while($row_total_x17a = mysqli_fetch_array($run_total_x17a)){

                $total_x17a_1 = $row_total_x17a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_17 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_17}%' AND member_no <> '$member_no_main'";

          $run_group_t_17 = mysqli_query($con,$select_query_group_t_17);

          while($row_group_t_17 = mysqli_fetch_array($run_group_t_17)){

                $total_group_t_17 = $row_group_t_17['SUM(product_amount)'];

                

          }



          $select_query_group_t_17a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_17}%' AND tree_id > '$tree_id_main'";

          $run_group_t_17a = mysqli_query($con,$select_query_group_t_17a);

          while($row_group_t_17a = mysqli_fetch_array($run_group_t_17a)){

                $total_group_t_17a = $row_group_t_17a['SUM(roi_amount)'];

                $total_percent_amount_17a = $row_group_t_17a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_17 = $total_group_t_17+$total_group_t_17a+$total_percent_amount_17a;





          $total_x17a = $total_x17a_1+$total_x17;



           $select_query_growth_17 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_17}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_17 = mysqli_query($con,$select_query_growth_17);

          $check_level_growth_17 = mysqli_num_rows($run_growth_17);



          if ($check_level_growth_17 == 0) {

             $total_cur_17 = $total_x17a_1+$total_x17;

             $growth_leg_17=0;

          }

          else {

            $total_cur_17 = 0;

            $growth_leg_17=1;

          }





        }else {



          $total_x17 =0;

             $total_x17a=0;

             $total_oagrbv_17 = 0;



        }



        $select_query_main_18 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='18' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_18 = mysqli_query($con,$select_query_main_18);

          $check_level_18 = mysqli_num_rows($run_main_18);

          while ($row_main_18 = mysqli_fetch_array($run_main_18)) {

          $tree_id_main_18 = $row_main_18['tree_id'];

          $group_number_main_18 = $row_main_18['group_number'];

          $member_no_main_18 = $row_main_18['member_no'];

          $sponsor_no_main_18 = $row_main_18['sponsor_no'];

          $level_no_main_18 = $row_main_18['level_no'];

          $relation_ship_no_main_18 = $row_main_18['relation_ship_no'];

          $x_position_main_18 = $row_main_18['x_position'];

        }



        if ($check_level_18 > 0) {



        $select_query_total_x18 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_18}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x18 = mysqli_query($con,$select_query_total_x18);

          while($row_total_x18 = mysqli_fetch_array($run_total_x18)){

                $total_x18 = $row_total_x18['SUM(product_amount)'];

          }



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

          $run_total_x18a = mysqli_query($con,$select_query_total_x18a);

          while($row_total_x18a = mysqli_fetch_array($run_total_x18a)){

                $total_x18a_1 = $row_total_x18a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_18 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_18}%' AND member_no <> '$member_no_main'";

          $run_group_t_18 = mysqli_query($con,$select_query_group_t_18);

          while($row_group_t_18 = mysqli_fetch_array($run_group_t_18)){

                $total_group_t_18 = $row_group_t_18['SUM(product_amount)'];

                

          }



          $select_query_group_t_18a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_18}%' AND tree_id > '$tree_id_main'";

          $run_group_t_18a = mysqli_query($con,$select_query_group_t_18a);

          while($row_group_t_18a = mysqli_fetch_array($run_group_t_18a)){

                $total_group_t_18a = $row_group_t_18a['SUM(roi_amount)'];

                $total_percent_amount_18a = $row_group_t_18a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_18 = $total_group_t_18+$total_group_t_18a+$total_percent_amount_18a;





          $total_x18a = $total_x18a_1+$total_x18;





           $select_query_growth_18 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_18}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_18 = mysqli_query($con,$select_query_growth_18);

          $check_level_growth_18 = mysqli_num_rows($run_growth_18);



          if ($check_level_growth_18 == 0) {

             $total_cur_18 = $total_x18a_1+$total_x18;

             $growth_leg_18=0;

          }

          else {

            $total_cur_18 = 0;

            $growth_leg_18=1;

          }





        }else {



          $total_x18 =0;

             $total_x18a=0;

             $total_oagrbv_18 = 0;



        }



        $select_query_main_19 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='19' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_19 = mysqli_query($con,$select_query_main_19);

          $check_level_19 = mysqli_num_rows($run_main_19);

          while ($row_main_19 = mysqli_fetch_array($run_main_19)) {

          $tree_id_main_19 = $row_main_19['tree_id'];

          $group_number_main_19 = $row_main_19['group_number'];

          $member_no_main_19 = $row_main_19['member_no'];

          $sponsor_no_main_19 = $row_main_19['sponsor_no'];

          $level_no_main_19 = $row_main_19['level_no'];

          $relation_ship_no_main_19 = $row_main_19['relation_ship_no'];

          $x_position_main_19 = $row_main_19['x_position'];

        }



        if ($check_level_19 > 0) {



        $select_query_total_x19 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_19}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x19 = mysqli_query($con,$select_query_total_x19);

          while($row_total_x19 = mysqli_fetch_array($run_total_x19)){

                $total_x19 = $row_total_x19['SUM(product_amount)'];

          }



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

          $run_total_x19a = mysqli_query($con,$select_query_total_x19a);

          while($row_total_x19a = mysqli_fetch_array($run_total_x19a)){

                $total_x19a_1 = $row_total_x19a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_19 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_19}%' AND member_no <> '$member_no_main'";

          $run_group_t_19 = mysqli_query($con,$select_query_group_t_19);

          while($row_group_t_19 = mysqli_fetch_array($run_group_t_19)){

                $total_group_t_19 = $row_group_t_19['SUM(product_amount)'];

                

          }



          $select_query_group_t_19a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_19}%' AND tree_id > '$tree_id_main'";

          $run_group_t_19a = mysqli_query($con,$select_query_group_t_19a);

          while($row_group_t_19a = mysqli_fetch_array($run_group_t_19a)){

                $total_group_t_19a = $row_group_t_19a['SUM(roi_amount)'];

                $total_percent_amount_19a = $row_group_t_19a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_19 = $total_group_t_19+$total_group_t_19a+$total_percent_amount_19a;



          $total_x19a = $total_x19a_1+$total_x19;



           $select_query_growth_19 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_19}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_19 = mysqli_query($con,$select_query_growth_19);

          $check_level_growth_19 = mysqli_num_rows($run_growth_19);



          if ($check_level_growth_19 == 0) {

             $total_cur_19 = $total_x19a_1+$total_x19;

             $growth_leg_19=0;

          }

          else {

            $total_cur_19 = 0;

            $growth_leg_19=1;

          }



        }else {



          $total_x19 =0;

             $total_x19a=0;

             $total_oagrbv_19 = 0;



        }



        $select_query_main_20 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='20' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_20 = mysqli_query($con,$select_query_main_20);

          $check_level_20 = mysqli_num_rows($run_main_20);

          while ($row_main_20 = mysqli_fetch_array($run_main_20)) {

          $tree_id_main_20 = $row_main_20['tree_id'];

          $group_number_main_20 = $row_main_20['group_number'];

          $member_no_main_20 = $row_main_20['member_no'];

          $sponsor_no_main_20 = $row_main_20['sponsor_no'];

          $level_no_main_20 = $row_main_20['level_no'];

          $relation_ship_no_main_20 = $row_main_20['relation_ship_no'];

          $x_position_main_20 = $row_main_20['x_position'];

        }



        if ($check_level_20 > 0) {



        $select_query_total_x20 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_20}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x20 = mysqli_query($con,$select_query_total_x20);

          while($row_total_x20 = mysqli_fetch_array($run_total_x20)){

                $total_x20 = $row_total_x20['SUM(product_amount)'];

          }



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

          $run_total_x20a = mysqli_query($con,$select_query_total_x20a);

          while($row_total_x20a = mysqli_fetch_array($run_total_x20a)){

                $total_x20a_1 = $row_total_x20a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_20 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_20}%' AND member_no <> '$member_no_main'";

          $run_group_t_20 = mysqli_query($con,$select_query_group_t_20);

          while($row_group_t_20 = mysqli_fetch_array($run_group_t_20)){

                $total_group_t_20 = $row_group_t_20['SUM(product_amount)'];

                

          }



          $select_query_group_t_20a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_20}%' AND tree_id > '$tree_id_main'";

          $run_group_t_20a = mysqli_query($con,$select_query_group_t_20a);

          while($row_group_t_20a = mysqli_fetch_array($run_group_t_20a)){

                $total_group_t_20a = $row_group_t_20a['SUM(roi_amount)'];

                $total_percent_amount_20a = $row_group_t_20a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_20 = $total_group_t_20+$total_group_t_20a+$total_percent_amount_20a;



          $total_x20a = $total_x20a_1+$total_x20;



           $select_query_growth_20 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_20}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_20 = mysqli_query($con,$select_query_growth_20);

          $check_level_growth_20 = mysqli_num_rows($run_growth_20);



          if ($check_level_growth_20 == 0) {

             $total_cur_20 = $total_x20a_1+$total_x20;

             $growth_leg_20=0;

          }

          else {

            $total_cur_20 = 0;

            $growth_leg_20=1;

          }



        }else {



          $total_x20 =0;

             $total_x20a=0;

             $total_oagrbv_20 = 0;



        }



        $select_query_main_21 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='21' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_21 = mysqli_query($con,$select_query_main_21);

          $check_level_21 = mysqli_num_rows($run_main_21);

          while ($row_main_21 = mysqli_fetch_array($run_main_21)) {

          $tree_id_main_21 = $row_main_21['tree_id'];

          $group_number_main_21 = $row_main_21['group_number'];

          $member_no_main_21 = $row_main_21['member_no'];

          $sponsor_no_main_21 = $row_main_21['sponsor_no'];

          $level_no_main_21 = $row_main_21['level_no'];

          $relation_ship_no_main_21 = $row_main_21['relation_ship_no'];

          $x_position_main_21 = $row_main_21['x_position'];

        }



        if ($check_level_21 > 0) {



        $select_query_total_x21 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_21}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x21 = mysqli_query($con,$select_query_total_x21);

          while($row_total_x21 = mysqli_fetch_array($run_total_x21)){

                $total_x21 = $row_total_x21['SUM(product_amount)'];

          }



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

          $run_total_x21a = mysqli_query($con,$select_query_total_x21a);

          while($row_total_x21a = mysqli_fetch_array($run_total_x21a)){

                $total_x21a_1 = $row_total_x21a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_21 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_21}%' AND member_no <> '$member_no_main'";

          $run_group_t_21 = mysqli_query($con,$select_query_group_t_21);

          while($row_group_t_21 = mysqli_fetch_array($run_group_t_21)){

                $total_group_t_21 = $row_group_t_21['SUM(product_amount)'];

                

          }



          $select_query_group_t_21a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_21}%' AND tree_id > '$tree_id_main'";

          $run_group_t_21a = mysqli_query($con,$select_query_group_t_21a);

          while($row_group_t_21a = mysqli_fetch_array($run_group_t_21a)){

                $total_group_t_21a = $row_group_t_21a['SUM(roi_amount)'];

                $total_percent_amount_21a = $row_group_t_21a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_21 = $total_group_t_21+$total_group_t_21a+$total_percent_amount_21a;



          $total_x21a = $total_x21a_1+$total_x21;



           $select_query_growth_21 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_21}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_21 = mysqli_query($con,$select_query_growth_21);

          $check_level_growth_21 = mysqli_num_rows($run_growth_21);



          if ($check_level_growth_21 == 0) {

             $total_cur_21 = $total_x21a_1+$total_x21;

             $growth_leg_21=0;

          }

          else {

            $total_cur_21 = 0;

            $growth_leg_21=1;

          }



        }else {



          $total_x21 =0;

             $total_x21a=0;

             $total_oagrbv_21 = 0;



        }







        $select_query_main_22 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='22' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_22 = mysqli_query($con,$select_query_main_22);

          $check_level_22 = mysqli_num_rows($run_main_22);

          while ($row_main_22 = mysqli_fetch_array($run_main_22)) {

          $tree_id_main_22 = $row_main_22['tree_id'];

          $group_number_main_22 = $row_main_22['group_number'];

          $member_no_main_22 = $row_main_22['member_no'];

          $sponsor_no_main_22 = $row_main_22['sponsor_no'];

          $level_no_main_22 = $row_main_22['level_no'];

          $relation_ship_no_main_22 = $row_main_22['relation_ship_no'];

          $x_position_main_22 = $row_main_22['x_position'];

        }



        if ($check_level_22 > 0) {



        $select_query_total_x22 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_22}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x22 = mysqli_query($con,$select_query_total_x22);

          while($row_total_x22 = mysqli_fetch_array($run_total_x22)){

                $total_x22 = $row_total_x22['SUM(product_amount)'];

          }



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

          $run_total_x22a = mysqli_query($con,$select_query_total_x22a);

          while($row_total_x22a = mysqli_fetch_array($run_total_x22a)){

                $total_x22a_1 = $row_total_x22a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_22 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_22}%' AND member_no <> '$member_no_main'";

          $run_group_t_22 = mysqli_query($con,$select_query_group_t_22);

          while($row_group_t_22 = mysqli_fetch_array($run_group_t_22)){

                $total_group_t_22 = $row_group_t_22['SUM(product_amount)'];

                

          }



          $select_query_group_t_22a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_22}%' AND tree_id > '$tree_id_main'";

          $run_group_t_22a = mysqli_query($con,$select_query_group_t_22a);

          while($row_group_t_22a = mysqli_fetch_array($run_group_t_22a)){

                $total_group_t_22a = $row_group_t_22a['SUM(roi_amount)'];

                $total_percent_amount_22a = $row_group_t_22a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_22 = $total_group_t_22+$total_group_t_22a+$total_percent_amount_22a;



          $total_x22a = $total_x22a_1+$total_x22;



           $select_query_growth_22 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_22}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_22 = mysqli_query($con,$select_query_growth_22);

          $check_level_growth_22 = mysqli_num_rows($run_growth_22);



          if ($check_level_growth_22 == 0) {

             $total_cur_22 = $total_x22a_1+$total_x22;

             $growth_leg_22=0;

          }

          else {

            $total_cur_22 = 0;

            $growth_leg_22=1;

          }



        }else {



          $total_x22 =0;

             $total_x22a=0;

             $total_oagrbv_22 = 0;



        }







        $select_query_main_23 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='23' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_23 = mysqli_query($con,$select_query_main_23);

          $check_level_23 = mysqli_num_rows($run_main_23);

          while ($row_main_23 = mysqli_fetch_array($run_main_23)) {

          $tree_id_main_23 = $row_main_23['tree_id'];

          $group_number_main_23 = $row_main_23['group_number'];

          $member_no_main_23 = $row_main_23['member_no'];

          $sponsor_no_main_23 = $row_main_23['sponsor_no'];

          $level_no_main_23 = $row_main_23['level_no'];

          $relation_ship_no_main_23 = $row_main_23['relation_ship_no'];

          $x_position_main_23 = $row_main_23['x_position'];

        }



        if ($check_level_23 > 0) {



        $select_query_total_x23 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_23}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x23 = mysqli_query($con,$select_query_total_x23);

          while($row_total_x23 = mysqli_fetch_array($run_total_x23)){

                $total_x23 = $row_total_x23['SUM(product_amount)'];

          }



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

          $run_total_x23a = mysqli_query($con,$select_query_total_x23a);

          while($row_total_x23a = mysqli_fetch_array($run_total_x23a)){

                $total_x23a_1 = $row_total_x23a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_23 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_23}%' AND member_no <> '$member_no_main'";

          $run_group_t_23 = mysqli_query($con,$select_query_group_t_23);

          while($row_group_t_23 = mysqli_fetch_array($run_group_t_23)){

                $total_group_t_23 = $row_group_t_23['SUM(product_amount)'];

                

          }



          $select_query_group_t_23a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_23}%' AND tree_id > '$tree_id_main'";

          $run_group_t_23a = mysqli_query($con,$select_query_group_t_23a);

          while($row_group_t_23a = mysqli_fetch_array($run_group_t_23a)){

                $total_group_t_23a = $row_group_t_23a['SUM(roi_amount)'];

                $total_percent_amount_23a = $row_group_t_23a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_23 = $total_group_t_23+$total_group_t_23a+$total_percent_amount_23a;



          $total_x23a = $total_x23a_1+$total_x23;



           $select_query_growth_23 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_23}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_23 = mysqli_query($con,$select_query_growth_23);

          $check_level_growth_23 = mysqli_num_rows($run_growth_23);



          if ($check_level_growth_23 == 0) {

             $total_cur_23 = $total_x23a_1+$total_x23;

             $growth_leg_23=0;

          }

          else {

            $total_cur_23 = 0;

            $growth_leg_23=1;

          }



        }else {



          $total_x23 =0;

             $total_x23a=0;

             $total_oagrbv_23 = 0;



        }







        $select_query_main_24 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='24' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_24 = mysqli_query($con,$select_query_main_24);

          $check_level_24 = mysqli_num_rows($run_main_24);

          while ($row_main_24 = mysqli_fetch_array($run_main_24)) {

          $tree_id_main_24 = $row_main_24['tree_id'];

          $group_number_main_24 = $row_main_24['group_number'];

          $member_no_main_24 = $row_main_24['member_no'];

          $sponsor_no_main_24 = $row_main_24['sponsor_no'];

          $level_no_main_24 = $row_main_24['level_no'];

          $relation_ship_no_main_24 = $row_main_24['relation_ship_no'];

          $x_position_main_24 = $row_main_24['x_position'];

        }



        if ($check_level_24 > 0) {



        $select_query_total_x24 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_24}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x24 = mysqli_query($con,$select_query_total_x24);

          while($row_total_x24 = mysqli_fetch_array($run_total_x24)){

                $total_x24 = $row_total_x24['SUM(product_amount)'];

          }



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

          $run_total_x24a = mysqli_query($con,$select_query_total_x24a);

          while($row_total_x24a = mysqli_fetch_array($run_total_x24a)){

                $total_x24a_1 = $row_total_x24a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_24 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_24}%' AND member_no <> '$member_no_main'";

          $run_group_t_24 = mysqli_query($con,$select_query_group_t_24);

          while($row_group_t_24 = mysqli_fetch_array($run_group_t_24)){

                $total_group_t_24 = $row_group_t_24['SUM(product_amount)'];

                

          }



          $select_query_group_t_24a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_24}%' AND tree_id > '$tree_id_main'";

          $run_group_t_24a = mysqli_query($con,$select_query_group_t_24a);

          while($row_group_t_24a = mysqli_fetch_array($run_group_t_24a)){

                $total_group_t_24a = $row_group_t_24a['SUM(roi_amount)'];

                $total_percent_amount_24a = $row_group_t_24a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_24 = $total_group_t_24+$total_group_t_24a+$total_percent_amount_24a;



          $total_x24a = $total_x24a_1+$total_x24;



           $select_query_growth_24 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_24}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_24 = mysqli_query($con,$select_query_growth_24);

          $check_level_growth_24 = mysqli_num_rows($run_growth_24);



          if ($check_level_growth_24 == 0) {

             $total_cur_24 = $total_x24a_1+$total_x24;

             $growth_leg_24=0;

          }

          else {

            $total_cur_24 = 0;

            $growth_leg_24=1;

          }



        }else {



          $total_x24 =0;

             $total_x24a=0;

             $total_oagrbv_24 = 0;



        }







        $select_query_main_25 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='25' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_25 = mysqli_query($con,$select_query_main_25);

          $check_level_25 = mysqli_num_rows($run_main_25);

          while ($row_main_25 = mysqli_fetch_array($run_main_25)) {

          $tree_id_main_25 = $row_main_25['tree_id'];

          $group_number_main_25 = $row_main_25['group_number'];

          $member_no_main_25 = $row_main_25['member_no'];

          $sponsor_no_main_25 = $row_main_25['sponsor_no'];

          $level_no_main_25 = $row_main_25['level_no'];

          $relation_ship_no_main_25 = $row_main_25['relation_ship_no'];

          $x_position_main_25 = $row_main_25['x_position'];

        }



        if ($check_level_25 > 0) {



        $select_query_total_x25 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_25}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x25 = mysqli_query($con,$select_query_total_x25);

          while($row_total_x25 = mysqli_fetch_array($run_total_x25)){

                $total_x25 = $row_total_x25['SUM(product_amount)'];

          }



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

          $run_total_x25a = mysqli_query($con,$select_query_total_x25a);

          while($row_total_x25a = mysqli_fetch_array($run_total_x25a)){

                $total_x25a_1 = $row_total_x25a['SUM(roi_amount)'];





                

          }





          $select_query_group_t_25 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_25}%' AND member_no <> '$member_no_main'";

          $run_group_t_25 = mysqli_query($con,$select_query_group_t_25);

          while($row_group_t_25 = mysqli_fetch_array($run_group_t_25)){

                $total_group_t_25 = $row_group_t_25['SUM(product_amount)'];

                

          }



          $select_query_group_t_25a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_25}%' AND tree_id > '$tree_id_main'";

          $run_group_t_25a = mysqli_query($con,$select_query_group_t_25a);

          while($row_group_t_25a = mysqli_fetch_array($run_group_t_25a)){

                $total_group_t_25a = $row_group_t_25a['SUM(roi_amount)'];

                $total_percent_amount_25a = $row_group_t_25a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_25 = $total_group_t_25+$total_group_t_25a+$total_percent_amount_25a;





          $total_x25a = $total_x25a_1+$total_x25;



           $select_query_growth_25 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_25}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_25 = mysqli_query($con,$select_query_growth_25);

          $check_level_growth_25 = mysqli_num_rows($run_growth_25);



          if ($check_level_growth_25 == 0) {

             $total_cur_25 = $total_x25a_1+$total_x25;

             $growth_leg_25=0;

          }

          else {

            $total_cur_25 = 0;

            $growth_leg_25=1;

          }



        }else {



          $total_x25 =0;

             $total_x25a=0;

             $total_oagrbv_25 = 0;



        }







        $select_query_main_26 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='26' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_26 = mysqli_query($con,$select_query_main_26);

          $check_level_26 = mysqli_num_rows($run_main_26);

          while ($row_main_26 = mysqli_fetch_array($run_main_26)) {

          $tree_id_main_26 = $row_main_26['tree_id'];

          $group_number_main_26 = $row_main_26['group_number'];

          $member_no_main_26 = $row_main_26['member_no'];

          $sponsor_no_main_26 = $row_main_26['sponsor_no'];

          $level_no_main_26 = $row_main_26['level_no'];

          $relation_ship_no_main_26 = $row_main_26['relation_ship_no'];

          $x_position_main_26 = $row_main_26['x_position'];

        }



        if ($check_level_26 > 0) {



        $select_query_total_x26 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_26}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x26 = mysqli_query($con,$select_query_total_x26);

          while($row_total_x26 = mysqli_fetch_array($run_total_x26)){

                $total_x26 = $row_total_x26['SUM(product_amount)'];

          }



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

          $run_total_x26a = mysqli_query($con,$select_query_total_x26a);

          while($row_total_x26a = mysqli_fetch_array($run_total_x26a)){

                $total_x26a_1 = $row_total_x26a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_26 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_26}%' AND member_no <> '$member_no_main'";

          $run_group_t_26 = mysqli_query($con,$select_query_group_t_26);

          while($row_group_t_26 = mysqli_fetch_array($run_group_t_26)){

                $total_group_t_26 = $row_group_t_26['SUM(product_amount)'];

                

          }



          $select_query_group_t_26a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_26}%' AND tree_id > '$tree_id_main'";

          $run_group_t_26a = mysqli_query($con,$select_query_group_t_26a);

          while($row_group_t_26a = mysqli_fetch_array($run_group_t_26a)){

                $total_group_t_26a = $row_group_t_26a['SUM(roi_amount)'];

                $total_percent_amount_26a = $row_group_t_26a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_26 = $total_group_t_26+$total_group_t_26a+$total_percent_amount_26a;



          $total_x26a = $total_x26a_1+$total_x26;



           $select_query_growth_26 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_26}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_26 = mysqli_query($con,$select_query_growth_26);

          $check_level_growth_26 = mysqli_num_rows($run_growth_26);



          if ($check_level_growth_26 == 0) {

             $total_cur_26 = $total_x26a_1+$total_x26;

             $growth_leg_26=0;

          }

          else {

            $total_cur_26 = 0;

            $growth_leg_26=1;

          }





        }else {



          $total_x26 =0;

             $total_x26a=0;

             $total_oagrbv_26 = 0;



        }







        $select_query_main_27 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='27' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_27 = mysqli_query($con,$select_query_main_27);

          $check_level_27 = mysqli_num_rows($run_main_27);

          while ($row_main_27 = mysqli_fetch_array($run_main_27)) {

          $tree_id_main_27 = $row_main_27['tree_id'];

          $group_number_main_27 = $row_main_27['group_number'];

          $member_no_main_27 = $row_main_27['member_no'];

          $sponsor_no_main_27 = $row_main_27['sponsor_no'];

          $level_no_main_27 = $row_main_27['level_no'];

          $relation_ship_no_main_27 = $row_main_27['relation_ship_no'];

          $x_position_main_27 = $row_main_27['x_position'];

        }



        if ($check_level_27 > 0) {



        $select_query_total_x27 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_27}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x27 = mysqli_query($con,$select_query_total_x27);

          while($row_total_x27 = mysqli_fetch_array($run_total_x27)){

                $total_x27 = $row_total_x27['SUM(product_amount)'];

          }



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

          $run_total_x27a = mysqli_query($con,$select_query_total_x27a);

          while($row_total_x27a = mysqli_fetch_array($run_total_x27a)){

                $total_x27a_1 = $row_total_x27a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_27 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_27}%' AND member_no <> '$member_no_main'";

          $run_group_t_27 = mysqli_query($con,$select_query_group_t_27);

          while($row_group_t_27 = mysqli_fetch_array($run_group_t_27)){

                $total_group_t_27 = $row_group_t_27['SUM(product_amount)'];

                

          }



          $select_query_group_t_27a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_27}%' AND tree_id > '$tree_id_main'";

          $run_group_t_27a = mysqli_query($con,$select_query_group_t_27a);

          while($row_group_t_27a = mysqli_fetch_array($run_group_t_27a)){

                $total_group_t_27a = $row_group_t_27a['SUM(roi_amount)'];

                $total_percent_amount_27a = $row_group_t_27a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_27 = $total_group_t_27+$total_group_t_27a+$total_percent_amount_27a;

          $total_x27a = $total_x27a_1+$total_x27;



           $select_query_growth_27 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_27}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_27 = mysqli_query($con,$select_query_growth_27);

          $check_level_growth_27 = mysqli_num_rows($run_growth_27);



          if ($check_level_growth_27 == 0) {

             $total_cur_27 = $total_x27a_1+$total_x27;

             $growth_leg_27=0;

          }

          else {

            $total_cur_27 = 0;

            $growth_leg_27=1;

          }



        }else {



          $total_x27 =0;

             $total_x27a=0;

             $total_oagrbv_27 = 0;



        }







        $select_query_main_28 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='28' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_28 = mysqli_query($con,$select_query_main_28);

          $check_level_28 = mysqli_num_rows($run_main_28);

          while ($row_main_28 = mysqli_fetch_array($run_main_28)) {

          $tree_id_main_28 = $row_main_28['tree_id'];

          $group_number_main_28 = $row_main_28['group_number'];

          $member_no_main_28 = $row_main_28['member_no'];

          $sponsor_no_main_28 = $row_main_28['sponsor_no'];

          $level_no_main_28 = $row_main_28['level_no'];

          $relation_ship_no_main_28 = $row_main_28['relation_ship_no'];

          $x_position_main_28 = $row_main_28['x_position'];

        }



        if ($check_level_28 > 0) {



        $select_query_total_x28 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_28}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x28 = mysqli_query($con,$select_query_total_x28);

          while($row_total_x28 = mysqli_fetch_array($run_total_x28)){

                $total_x28 = $row_total_x28['SUM(product_amount)'];

          }



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

          $run_total_x28a = mysqli_query($con,$select_query_total_x28a);

          while($row_total_x28a = mysqli_fetch_array($run_total_x28a)){

                $total_x28a_1 = $row_total_x28a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_28 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_28}%' AND member_no <> '$member_no_main'";

          $run_group_t_28 = mysqli_query($con,$select_query_group_t_28);

          while($row_group_t_28 = mysqli_fetch_array($run_group_t_28)){

                $total_group_t_28 = $row_group_t_28['SUM(product_amount)'];

                

          }



          $select_query_group_t_28a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_28}%' AND tree_id > '$tree_id_main'";

          $run_group_t_28a = mysqli_query($con,$select_query_group_t_28a);

          while($row_group_t_28a = mysqli_fetch_array($run_group_t_28a)){

                $total_group_t_28a = $row_group_t_28a['SUM(roi_amount)'];

                $total_percent_amount_28a = $row_group_t_28a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_28 = $total_group_t_28+$total_group_t_28a+$total_percent_amount_28a;



          $total_x28a = $total_x28a_1+$total_x28;



           $select_query_growth_28 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_28}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_28 = mysqli_query($con,$select_query_growth_28);

          $check_level_growth_28 = mysqli_num_rows($run_growth_28);



          if ($check_level_growth_28 == 0) {

             $total_cur_28 = $total_x28a_1+$total_x28;

             $growth_leg_28=0;

          }

          else {

            $total_cur_28 = 0;

            $growth_leg_28=1;

          }



        }else {



          $total_x28 =0;

             $total_x28a=0;

             $total_oagrbv_28 = 0;



        }





        $select_query_main_29 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='29' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_29 = mysqli_query($con,$select_query_main_29);

          $check_level_29 = mysqli_num_rows($run_main_29);

          while ($row_main_29 = mysqli_fetch_array($run_main_29)) {

          $tree_id_main_29 = $row_main_29['tree_id'];

          $group_number_main_29 = $row_main_29['group_number'];

          $member_no_main_29 = $row_main_29['member_no'];

          $sponsor_no_main_29 = $row_main_29['sponsor_no'];

          $level_no_main_29 = $row_main_29['level_no'];

          $relation_ship_no_main_29 = $row_main_29['relation_ship_no'];

          $x_position_main_29 = $row_main_29['x_position'];

        }



        if ($check_level_29 > 0) {



        $select_query_total_x29 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_29}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x29 = mysqli_query($con,$select_query_total_x29);

          while($row_total_x29 = mysqli_fetch_array($run_total_x29)){

                $total_x29 = $row_total_x29['SUM(product_amount)'];

          }



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

          $run_total_x29a = mysqli_query($con,$select_query_total_x29a);

          while($row_total_x29a = mysqli_fetch_array($run_total_x29a)){

                $total_x29a_1 = $row_total_x29a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_29 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_29}%' AND member_no <> '$member_no_main'";

          $run_group_t_29 = mysqli_query($con,$select_query_group_t_29);

          while($row_group_t_29 = mysqli_fetch_array($run_group_t_29)){

                $total_group_t_29 = $row_group_t_29['SUM(product_amount)'];

                

          }



          $select_query_group_t_29a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_29}%' AND tree_id > '$tree_id_main'";

          $run_group_t_29a = mysqli_query($con,$select_query_group_t_29a);

          while($row_group_t_29a = mysqli_fetch_array($run_group_t_29a)){

                $total_group_t_29a = $row_group_t_29a['SUM(roi_amount)'];

                $total_percent_amount_29a = $row_group_t_29a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_29 = $total_group_t_29+$total_group_t_29a+$total_percent_amount_29a;



          $total_x29a = $total_x29a_1+$total_x29;



           $select_query_growth_29 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_29}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_29 = mysqli_query($con,$select_query_growth_29);

          $check_level_growth_29 = mysqli_num_rows($run_growth_29);



          if ($check_level_growth_29 == 0) {

             $total_cur_29 = $total_x29a_1+$total_x29;

             $growth_leg_29=0;

          }

          else {

            $total_cur_29 = 0;

            $growth_leg_29=1;

          }



        }else {



          $total_x29 =0;

             $total_x29a=0;

             $total_oagrbv_29 = 0;



        }







        $select_query_main_30 = "select * from roi_tree where group_number = '$group_number_main' AND x_position = '$x_position_main' AND y_position='30' AND relation_ship_no LIKE '%{$relation_ship_no_main}%' AND tree_id > '$tree_id_main'";

          $run_main_30 = mysqli_query($con,$select_query_main_30);

          $check_level_30 = mysqli_num_rows($run_main_30);

          while ($row_main_30 = mysqli_fetch_array($run_main_30)) {

          $tree_id_main_30 = $row_main_30['tree_id'];

          $group_number_main_30 = $row_main_30['group_number'];

          $member_no_main_30 = $row_main_30['member_no'];

          $sponsor_no_main_30 = $row_main_30['sponsor_no'];

          $level_no_main_30 = $row_main_30['level_no'];

          $relation_ship_no_main_30 = $row_main_30['relation_ship_no'];

          $x_position_main_30 = $row_main_30['x_position'];

        }



        if ($check_level_30 > 0) {



        $select_query_total_x30 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_30}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND status='0'";

          $run_total_x30 = mysqli_query($con,$select_query_total_x30);

          while($row_total_x30 = mysqli_fetch_array($run_total_x30)){

                $total_x30 = $row_total_x30['SUM(product_amount)'];

          }



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

          $run_total_x30a = mysqli_query($con,$select_query_total_x30a);

          while($row_total_x30a = mysqli_fetch_array($run_total_x30a)){

                $total_x30a_1 = $row_total_x30a['SUM(roi_amount)'];





                

          }



          $select_query_group_t_30 = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main_30}%' AND member_no <> '$member_no_main'";

          $run_group_t_30 = mysqli_query($con,$select_query_group_t_30);

          while($row_group_t_30 = mysqli_fetch_array($run_group_t_30)){

                $total_group_t_30 = $row_group_t_30['SUM(product_amount)'];

                

          }



          $select_query_group_t_30a = "select SUM(roi_amount), SUM(percent_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_30}%' AND tree_id > '$tree_id_main'";

          $run_group_t_30a = mysqli_query($con,$select_query_group_t_30a);

          while($row_group_t_30a = mysqli_fetch_array($run_group_t_30a)){

                $total_group_t_30a = $row_group_t_30a['SUM(roi_amount)'];

                $total_percent_amount_30a = $row_group_t_30a['SUM(percent_amount)'];

                

          }



          $total_oagrbv_30 = $total_group_t_30+$total_group_t_30a+$total_percent_amount_30a;



          $total_x30a = $total_x30a_1+$total_x30;



           $select_query_growth_30 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_30}%' AND tree_id > '$tree_id_main' AND rank > '0'";

          $run_growth_30 = mysqli_query($con,$select_query_growth_30);

          $check_level_growth_30 = mysqli_num_rows($run_growth_30);



          if ($check_level_growth_30 == 0) {

             $total_cur_30 = $total_x30a_1+$total_x30;

             $growth_leg_30=0;

          }

          else {

            $total_cur_30 = 0;

            $growth_leg_30=1;

          }



        }else {



          $total_x30 =0;

             $total_x30a=0;

             $total_oagrbv_30 = 0;



        }





          $bigest_value = max($total_x5a, $total_x4a, $total_x3a, $total_x2a, $total_x1a, $total_x6a, $total_x7a, $total_x8a, $total_x9a, $total_x10a, $total_x15a, $total_x14a, $total_x13a, $total_x12a, $total_x11a, $total_x16a, $total_x17a, $total_x18a, $total_x19a, $total_x20a, $total_x25a, $total_x24a, $total_x23a, $total_x22a, $total_x21a, $total_x26a, $total_x27a, $total_x28a, $total_x29a, $total_x30a);



          if ($total_team_pv < 30000) {

               $percent_amount = 6;

               $next_level_amount = 30000;

               $next_ve_per = 9; 

             }

             elseif ($total_team_pv < 75000) {

               $percent_amount = 9;

               $next_level_amount = 75000; 

               $next_ve_per = 14;

             }

             

             else {

               $percent_amount = 14;

             }





             //get level position1a amount



             if ($total_oagrbv_1 < 30000) {

               $level_1a_percent = 6; 

             }

             elseif ($total_oagrbv_1 < 75000) {

               $level_1a_percent = 9; 

             }

             else {

               $level_1a_percent = 14;

             }



             if ($percent_amount == $level_1a_percent) {



                $level_1a_release_percent = 0;

                $level_1a_amount = 0;

                $step1_amount = 0;



                

             }else {



                if ($check_level_1 == 0) {

                  $level_1a_release_percent = 0;

                  $level_1a_amount = $total_x1a;

                  $step1_amount = 0;

                }

                else {

                  $level_1a_release_percent = $percent_amount - $level_1a_percent;

                  $level_1a_amount = $total_x1a;



                  $percentin_tds_roi_process_step1 = $level_1a_release_percent / 100;       

                 //Get the result.

                  $step1_amount = $percentin_tds_roi_process_step1 * $level_1a_amount;

                }



                

             }



             //get level position1a amount



             //get level position2a amount



             if ($total_oagrbv_2 < 30000) {

               $level_2a_percent = 6; 

             }

             elseif ($total_oagrbv_2 < 75000) {

               $level_2a_percent = 9; 

             }

             else {

               $level_2a_percent = 14;

             }



             if ($percent_amount == $level_2a_percent) {



                $level_2a_release_percent = 0;

                $level_2a_amount = 0;

                $step2_amount = 0;



                

             }else {



                if ($check_level_2 == 0) {

                  $level_2a_release_percent = 0;

                  $level_2a_amount = $total_x2a;

                  $step2_amount=0;

                }

                else {

                  $level_2a_release_percent = $percent_amount - $level_2a_percent;

                  $level_2a_amount = $total_x2a;



                  $percentin_tds_roi_process_step2 = $level_2a_release_percent / 100;       

                 //Get the result.

                  $step2_amount = $percentin_tds_roi_process_step2 * $level_2a_amount;

                }

             }



             //get level position2a amount

             //get level position3a amount



             if ($total_oagrbv_3 < 30000) {

               $level_3a_percent = 6; 

             }

             elseif ($total_oagrbv_3 < 75000) {

               $level_3a_percent = 9; 

             }

             else {

               $level_3a_percent = 14;

             }



             if ($percent_amount == $level_3a_percent) {



                $level_3a_release_percent = 0;

                $level_3a_amount = 0;

                $step3_amount = 0;



                

             }else {



                if ($check_level_3 == 0) {

                  $level_3a_release_percent = 0;

                  $level_3a_amount = $total_x3a;

                  $step3_amount = 0;

                }

                else {

                  $level_3a_release_percent = $percent_amount - $level_3a_percent;

                  $level_3a_amount = $total_x3a;



                  $percentin_tds_roi_process_step3 = $level_3a_release_percent / 100;       

                 //Get the result.

                  $step3_amount = $percentin_tds_roi_process_step3 * $level_3a_amount;





                }

             }



             //get level position3a amount

             //get level position4a amount



             if ($total_oagrbv_4 < 30000) {

               $level_4a_percent = 6; 

             }

             elseif ($total_oagrbv_4 < 75000) {

               $level_4a_percent = 9; 

             }

             else {

               $level_4a_percent = 14;

             }



             if ($percent_amount == $level_4a_percent) {



                $level_4a_release_percent = 0;

                $level_4a_amount = 0;

                $step4_amount = 0;



                

             }else {



                if ($check_level_4 == 0) {

                  $level_4a_release_percent = 0;

                  $level_4a_amount = $total_x4a;

                  $step4_amount = 0;

                }

                else {

                  $level_4a_release_percent = $percent_amount - $level_4a_percent;

                  $level_4a_amount = $total_x4a;

                  $percentin_tds_roi_process_step4 = $level_4a_release_percent / 100;       

                 //Get the result.

                  $step4_amount = $percentin_tds_roi_process_step4 * $level_4a_amount;

                }

             }



             //get level position4a amount

             //get level position5a amount



             if ($total_oagrbv_5 < 30000) {

               $level_5a_percent = 6; 

             }

             elseif ($total_oagrbv_5 < 75000) {

               $level_5a_percent = 9; 

             }

             else {

               $level_5a_percent = 14;

             }



             if ($percent_amount == $level_5a_percent) {



                $level_5a_release_percent = 0;

                $level_5a_amount = 0;

                $step5_amount = 0;



                

             }else {



                if ($check_level_5 == 0) {

                  $level_5a_release_percent = 0;

                  $level_5a_amount = $total_x5a;

                  $step5_amount = 0;

                }

                else {

                  $level_5a_release_percent = $percent_amount - $level_5a_percent;

                  $level_5a_amount = $total_x5a;

                  $percentin_tds_roi_process_step5 = $level_5a_release_percent / 100;       

                 //Get the result.

                  $step5_amount = $percentin_tds_roi_process_step5 * $level_5a_amount;

                }

             }



             //get level position5a amount

             //get level position6a amount



             if ($total_oagrbv_6 < 30000) {

               $level_6a_percent = 6; 

             }

             elseif ($total_oagrbv_6 < 75000) {

               $level_6a_percent = 9; 

             }

             else {

               $level_6a_percent = 14;

             }



             if ($percent_amount == $level_6a_percent) {



                $level_6a_release_percent = 0;

                $level_6a_amount = 0;

                $step6_amount = 0;



                

             }else {



                if ($check_level_6 == 0) {

                  $level_6a_release_percent = 0;

                  $level_6a_amount = $total_x6a;

                  $step6_amount = 0;

                }

                else {

                  $level_6a_release_percent = $percent_amount - $level_6a_percent;

                  $level_6a_amount = $total_x6a;

                  $percentin_tds_roi_process_step6 = $level_6a_release_percent / 100;       

                 //Get the result.

                  $step6_amount = $percentin_tds_roi_process_step6 * $level_6a_amount;

                }

             }



             //get level position6a amount

             //get level position7a amount



             if ($total_oagrbv_7 < 30000) {

               $level_7a_percent = 6; 

             }

             elseif ($total_oagrbv_7 < 75000) {

               $level_7a_percent = 9; 

             }

             else {

               $level_7a_percent = 14;

             }



             if ($percent_amount == $level_7a_percent) {



                $level_7a_release_percent = 0;

                $level_7a_amount = 0;

                $step7_amount = 0;



                

             }else {



                if ($check_level_7 == 0) {

                  $level_7a_release_percent = 0;

                  $level_7a_amount = $total_x7a;

                  $step7_amount = 0;

                }

                else {

                  $level_7a_release_percent = $percent_amount - $level_7a_percent;

                  $level_7a_amount = $total_x7a;

                  $percentin_tds_roi_process_step7 = $level_7a_release_percent / 100;       

                 //Get the result.

                  $step7_amount = $percentin_tds_roi_process_step7 * $level_7a_amount;

                }

             }



             //get level position7a amount



             //get level position8a amount



             if ($total_oagrbv_8 < 30000) {

               $level_8a_percent = 6; 

             }

             elseif ($total_oagrbv_8 < 75000) {

               $level_8a_percent = 9; 

             }

             else {

               $level_8a_percent = 14;

             }



             if ($percent_amount == $level_8a_percent) {



                $level_8a_release_percent = 0;

                $level_8a_amount = 0;

                $step8_amount = 0;



                

             }else {



                if ($check_level_8 == 0) {

                  $level_8a_release_percent = 0;

                  $level_8a_amount = $total_x8a;

                  $step8_amount = 0;

                }

                else {

                  $level_8a_release_percent = $percent_amount - $level_8a_percent;

                  $level_8a_amount = $total_x8a;

                  $percentin_tds_roi_process_step8 = $level_8a_release_percent / 100;       

                 //Get the result.

                  $step8_amount = $percentin_tds_roi_process_step8 * $level_8a_amount;

                }

             }



             //get level position8a amount

             //get level position9a amount



             if ($total_oagrbv_9 < 30000) {

               $level_9a_percent = 6; 

             }

             elseif ($total_oagrbv_9 < 75000) {

               $level_9a_percent = 9; 

             }

             else {

               $level_9a_percent = 14;

             }



             if ($percent_amount == $level_9a_percent) {



                $level_9a_release_percent = 0;

                $level_9a_amount = 0;

                $step9_amount = 0;



                

             }else {



                if ($check_level_9 == 0) {

                  $level_9a_release_percent = 0;

                  $level_9a_amount = $total_x9a;

                  $step9_amount = 0;

                }

                else {

                  $level_9a_release_percent = $percent_amount - $level_9a_percent;

                  $level_9a_amount = $total_x9a;

                  $percentin_tds_roi_process_step9 = $level_9a_release_percent / 100;       

                 //Get the result.

                  $step9_amount = $percentin_tds_roi_process_step9 * $level_9a_amount;

                }

             }



             //get level position9a amount



             //get level position10a amount



             if ($total_oagrbv_10 < 30000) {

               $level_10a_percent = 6; 

             }

             elseif ($total_oagrbv_10 < 75000) {

               $level_10a_percent = 9; 

             }

             else {

               $level_10a_percent = 14;

             }



             if ($percent_amount == $level_10a_percent) {



                $level_10a_release_percent = 0;

                $level_10a_amount = 0;

                $step10_amount = 0;



                

             }else {



                if ($check_level_10 == 0) {

                  $level_10a_release_percent = 0;

                  $level_10a_amount = $total_x10a;

                  $step10_amount = 0;

                }

                else {

                  $level_10a_release_percent = $percent_amount - $level_10a_percent;

                  $level_10a_amount = $total_x10a;

                  $percentin_tds_roi_process_step10 = $level_10a_release_percent / 100;       

                 //Get the result.

                  $step10_amount = $percentin_tds_roi_process_step10 * $level_10a_amount;

                }

             }



             //get level position10a amount





             //get level position11a amount



             if ($total_oagrbv_11 < 30000) {

               $level_11a_percent = 6; 

             }

             elseif ($total_oagrbv_11 < 75000) {

               $level_11a_percent = 9; 

             }

             else {

               $level_11a_percent = 14;

             }



             if ($percent_amount == $level_11a_percent) {



                $level_11a_release_percent = 0;

                $level_11a_amount = 0;

                $step11_amount = 0;



                

             }else {



                if ($check_level_11 == 0) {

                  $level_11a_release_percent = 0;

                  $level_11a_amount = $total_x11a;

                  $step11_amount = 0;

                }

                else {

                  $level_11a_release_percent = $percent_amount - $level_11a_percent;

                  $level_11a_amount = $total_x11a;

                  $percentin_tds_roi_process_step11 = $level_11a_release_percent / 100;       

                 //Get the result.

                  $step11_amount = $percentin_tds_roi_process_step11 * $level_11a_amount;

                }

             }



             //get level position11a amount



             //get level position12a amount



             if ($total_oagrbv_12 < 30000) {

               $level_12a_percent = 6; 

             }

             elseif ($total_oagrbv_12 < 75000) {

               $level_12a_percent = 9; 

             }

             else {

               $level_12a_percent = 14;

             }



             if ($percent_amount == $level_12a_percent) {



                $level_12a_release_percent = 0;

                $level_12a_amount = 0;

                $step12_amount = 0;



                

             }else {



                if ($check_level_12 == 0) {

                  $level_12a_release_percent = 0;

                  $level_12a_amount = $total_x12a;

                  $step12_amount = 0;

                }

                else {

                  $level_12a_release_percent = $percent_amount - $level_12a_percent;

                  $level_12a_amount = $total_x12a;

                  $percentin_tds_roi_process_step12 = $level_12a_release_percent / 100;       

                 //Get the result.

                  $step12_amount = $percentin_tds_roi_process_step12 * $level_12a_amount;

                }

             }



             //get level position12a amount

             //get level position13a amount



             if ($total_oagrbv_13 < 30000) {

               $level_13a_percent = 6; 

             }

             elseif ($total_oagrbv_13 < 75000) {

               $level_13a_percent = 9; 

             }

             else {

               $level_13a_percent = 14;

             }



             if ($percent_amount == $level_13a_percent) {



                $level_13a_release_percent = 0;

                $level_13a_amount = 0;

                $step13_amount = 0;



                

             }else {



                if ($check_level_13 == 0) {

                  $level_13a_release_percent = 0;

                  $level_13a_amount = $total_x13a;

                  $step13_amount = 0;

                }

                else {

                  $level_13a_release_percent = $percent_amount - $level_13a_percent;

                  $level_13a_amount = $total_x13a;

                  $percentin_tds_roi_process_step13 = $level_13a_release_percent / 100;       

                 //Get the result.

                  $step13_amount = $percentin_tds_roi_process_step13 * $level_13a_amount;

                }

             }



             //get level position13a amount

             //get level position14a amount



             if ($total_oagrbv_14 < 30000) {

               $level_14a_percent = 6; 

             }

             elseif ($total_oagrbv_14 < 75000) {

               $level_14a_percent = 9; 

             }

             else {

               $level_14a_percent = 14;

             }



             if ($percent_amount == $level_14a_percent) {



                $level_14a_release_percent = 0;

                $level_14a_amount = 0;

                $step14_amount = 0;



                

             }else {



                if ($check_level_14 == 0) {

                  $level_14a_release_percent = 0;

                  $level_14a_amount = $total_x14a;

                  $step14_amount = 0;

                }

                else {

                  $level_14a_release_percent = $percent_amount - $level_14a_percent;

                  $level_14a_amount = $total_x14a;

                  $percentin_tds_roi_process_step14 = $level_14a_release_percent / 100;       

                 //Get the result.

                  $step14_amount = $percentin_tds_roi_process_step14 * $level_14a_amount;

                }

             }



             //get level position14a amount

             //get level position15a amount



             if ($total_oagrbv_15 < 30000) {

               $level_15a_percent = 6; 

             }

             elseif ($total_oagrbv_15 < 75000) {

               $level_15a_percent = 9; 

             }

             else {

               $level_15a_percent = 14;

             }



             if ($percent_amount == $level_15a_percent) {



                $level_15a_release_percent = 0;

                $level_15a_amount = 0;

                $step15_amount = 0;



                

             }else {



                if ($check_level_15 == 0) {

                  $level_15a_release_percent = 0;

                  $level_15a_amount = $total_x15a;

                  $step15_amount = 0;

                }

                else {

                  $level_15a_release_percent = $percent_amount - $level_15a_percent;

                  $level_15a_amount = $total_x15a;

                  $percentin_tds_roi_process_step15 = $level_15a_release_percent / 100;       

                 //Get the result.

                  $step15_amount = $percentin_tds_roi_process_step15 * $level_15a_amount;

                }

             }



             //get level position15a amount

             //get level position16a amount



             if ($total_oagrbv_16 < 30000) {

               $level_16a_percent = 6; 

             }

             elseif ($total_oagrbv_16 < 75000) {

               $level_16a_percent = 9; 

             }

             else {

               $level_16a_percent = 14;

             }



             if ($percent_amount == $level_16a_percent) {



                $level_16a_release_percent = 0;

                $level_16a_amount = 0;

                $step16_amount = 0;



                

             }else {



                if ($check_level_16 == 0) {

                  $level_16a_release_percent = 0;

                  $level_16a_amount = $total_x16a;

                  $step16_amount = 0;

                }

                else {

                  $level_16a_release_percent = $percent_amount - $level_16a_percent;

                  $level_16a_amount = $total_x16a;

                  $percentin_tds_roi_process_step16 = $level_16a_release_percent / 100;       

                 //Get the result.

                  $step16_amount = $percentin_tds_roi_process_step16 * $level_16a_amount;

                }

             }



             //get level position16a amount

             //get level position17a amount



             if ($total_oagrbv_17 < 30000) {

               $level_17a_percent = 6; 

             }

             elseif ($total_oagrbv_17 < 75000) {

               $level_17a_percent = 9; 

             }

             else {

               $level_17a_percent = 14;

             }



             if ($percent_amount == $level_17a_percent) {



                $level_17a_release_percent = 0;

                $level_17a_amount = 0;

                $step17_amount = 0;



                

             }else {



                if ($check_level_17 == 0) {

                  $level_17a_release_percent = 0;

                  $level_17a_amount = $total_x17a;

                  $step17_amount = 0;

                }

                else {

                  $level_17a_release_percent = $percent_amount - $level_17a_percent;

                  $level_17a_amount = $total_x17a;

                  $percentin_tds_roi_process_step17 = $level_17a_release_percent / 100;       

                 //Get the result.

                  $step17_amount = $percentin_tds_roi_process_step17 * $level_17a_amount;

                }

             }



             //get level position17a amount



             //get level position18a amount



             if ($total_oagrbv_18 < 30000) {

               $level_18a_percent = 6; 

             }

             elseif ($total_oagrbv_18 < 75000) {

               $level_18a_percent = 9; 

             }

             else {

               $level_18a_percent = 14;

             }



             if ($percent_amount == $level_18a_percent) {



                $level_18a_release_percent = 0;

                $level_18a_amount = 0;

                $step18_amount = 0;



                

             }else {



                if ($check_level_18 == 0) {

                  $level_18a_release_percent = 0;

                  $level_18a_amount = $total_x18a;

                  $step18_amount = 0;

                }

                else {

                  $level_18a_release_percent = $percent_amount - $level_18a_percent;

                  $level_18a_amount = $total_x18a;

                  $percentin_tds_roi_process_step18 = $level_18a_release_percent / 100;       

                 //Get the result.

                  $step18_amount = $percentin_tds_roi_process_step18 * $level_18a_amount;

                }

             }



             //get level position18a amount

             //get level position19a amount



             if ($total_oagrbv_19 < 30000) {

               $level_19a_percent = 6; 

             }

             elseif ($total_oagrbv_19 < 75000) {

               $level_19a_percent = 9; 

             }

             else {

               $level_19a_percent = 14;

             }



             if ($percent_amount == $level_19a_percent) {



                $level_19a_release_percent = 0;

                $level_19a_amount = 0;

                $step19_amount = 0;



                

             }else {



                if ($check_level_19 == 0) {

                  $level_19a_release_percent = 0;

                  $level_19a_amount = $total_x19a;

                  $step19_amount = 0;

                }

                else {

                  $level_19a_release_percent = $percent_amount - $level_19a_percent;

                  $level_19a_amount = $total_x19a;



                  $percentin_tds_roi_process_step19 = $level_19a_release_percent / 100;       

                 //Get the result.

                  $step19_amount = $percentin_tds_roi_process_step19 * $level_19a_amount;

                }

             }



             //get level position19a amount



             //get level position20a amount



             if ($total_oagrbv_20 < 30000) {

               $level_20a_percent = 6; 

             }

             elseif ($total_oagrbv_20 < 75000) {

               $level_20a_percent = 9; 

             }

             else {

               $level_20a_percent = 14;

             }



             if ($percent_amount == $level_20a_percent) {



                $level_20a_release_percent = 0;

                $level_20a_amount = 0;

                $step20_amount = 0;



                

             }else {



                if ($check_level_20 == 0) {

                  $level_20a_release_percent = 0;

                  $level_20a_amount = $total_x20a;

                  $step20_amount = 0;

                }

                else {

                  $level_20a_release_percent = $percent_amount - $level_20a_percent;

                  $level_20a_amount = $total_x20a;

                  $percentin_tds_roi_process_step20 = $level_20a_release_percent / 100;       

                 //Get the result.

                  $step20_amount = $percentin_tds_roi_process_step20 * $level_20a_amount;

                }

             }



             //get level position21a amount



             if ($total_oagrbv_21 < 30000) {

               $level_21a_percent = 6; 

             }

             elseif ($total_oagrbv_21 < 75000) {

               $level_21a_percent = 9; 

             }

             else {

               $level_21a_percent = 14;

             }



             if ($percent_amount == $level_21a_percent) {



                $level_21a_release_percent = 0;

                $level_21a_amount = 0;

                $step21_amount = 0;



                

             }else {



                if ($check_level_21 == 0) {

                  $level_21a_release_percent = 0;

                  $level_21a_amount = $total_x21a;

                  $step21_amount = 0;

                }

                else {

                  $level_21a_release_percent = $percent_amount - $level_21a_percent;

                  $level_21a_amount = $total_x21a;

                  $percentin_tds_roi_process_step21 = $level_21a_release_percent / 100;       

                 //Get the result.

                  $step21_amount = $percentin_tds_roi_process_step21 * $level_21a_amount;

                }

             }



             //get level position22a amount



             if ($total_oagrbv_22 < 30000) {

               $level_22a_percent = 6; 

             }

             elseif ($total_oagrbv_22 < 75000) {

               $level_22a_percent = 9; 

             }

             else {

               $level_22a_percent = 14;

             }



             if ($percent_amount == $level_22a_percent) {



                $level_22a_release_percent = 0;

                $level_22a_amount = 0;

                $step22_amount = 0;



                

             }else {



                if ($check_level_22 == 0) {

                  $level_22a_release_percent = 0;

                  $level_22a_amount = $total_x22a;

                  $step22_amount = 0;

                }

                else {

                  $level_22a_release_percent = $percent_amount - $level_22a_percent;

                  $level_22a_amount = $total_x22a;

                  $percentin_tds_roi_process_step22 = $level_22a_release_percent / 100;       

                 //Get the result.

                  $step22_amount = $percentin_tds_roi_process_step22 * $level_22a_amount;

                }

             }



             //get level position23a amount



             if ($total_oagrbv_23 < 30000) {

               $level_23a_percent = 6; 

             }

             elseif ($total_oagrbv_23 < 75000) {

               $level_23a_percent = 9; 

             }

             else {

               $level_23a_percent = 14;

             }



             if ($percent_amount == $level_23a_percent) {



                $level_23a_release_percent = 0;

                $level_23a_amount = 0;

                $step23_amount = 0;



                

             }else {



                if ($check_level_23 == 0) {

                  $level_23a_release_percent = 0;

                  $level_23a_amount = $total_x23a;

                  $step23_amount = 0;

                }

                else {

                  $level_23a_release_percent = $percent_amount - $level_23a_percent;

                  $level_23a_amount = $total_x23a;

                  $percentin_tds_roi_process_step23 = $level_23a_release_percent / 100;       

                 //Get the result.

                  $step23_amount = $percentin_tds_roi_process_step23 * $level_23a_amount;

                }

             }



             //get level position24a amount



            if ($total_oagrbv_24 < 30000) {

               $level_24a_percent = 6; 

             }

             elseif ($total_oagrbv_24 < 75000) {

               $level_24a_percent = 9; 

             }

             else {

               $level_24a_percent = 14;

             }



             if ($percent_amount == $level_24a_percent) {



                $level_24a_release_percent = 0;

                $level_24a_amount = 0;

                $step24_amount = 0;



                

             }else {



                if ($check_level_24 == 0) {

                  $level_24a_release_percent = 0;

                  $level_24a_amount = $total_x24a;

                  $step24_amount = 0;

                }

                else {

                  $level_24a_release_percent = $percent_amount - $level_24a_percent;

                  $level_24a_amount = $total_x24a;

                  $percentin_tds_roi_process_step24 = $level_24a_release_percent / 100;       

                 //Get the result.

                  $step24_amount = $percentin_tds_roi_process_step24 * $level_24a_amount;

                }

             }



             //get level position25a amount



             if ($total_oagrbv_25 < 30000) {

               $level_25a_percent = 6; 

             }

             elseif ($total_oagrbv_25 < 75000) {

               $level_25a_percent = 9; 

             }

             else {

               $level_25a_percent = 14;

             }



             if ($percent_amount == $level_25a_percent) {



                $level_25a_release_percent = 0;

                $level_25a_amount = 0;

                $step25_amount = 0;



                

             }else {



                if ($check_level_25 == 0) {

                  $level_25a_release_percent = 0;

                  $level_25a_amount = $total_x25a;

                  $step25_amount = 0;

                }

                else {

                  $level_25a_release_percent = $percent_amount - $level_25a_percent;

                  $level_25a_amount = $total_x25a;

                  $percentin_tds_roi_process_step25 = $level_25a_release_percent / 100;       

                 //Get the result.

                  $step25_amount = $percentin_tds_roi_process_step25 * $level_25a_amount;

                }

             }



             //get level position26a amount



             if ($total_oagrbv_26 < 30000) {

               $level_26a_percent = 6; 

             }

             elseif ($total_oagrbv_26 < 75000) {

               $level_26a_percent = 9; 

             }

             else {

               $level_26a_percent = 14;

             }



             if ($percent_amount == $level_26a_percent) {



                $level_26a_release_percent = 0;

                $level_26a_amount = 0;

                $step26_amount = 0;



                

             }else {



                if ($check_level_26 == 0) {

                  $level_26a_release_percent = 0;

                  $level_26a_amount = $total_x26a;

                  $step26_amount = 0;

                }

                else {

                  $level_26a_release_percent = $percent_amount - $level_26a_percent;

                  $level_26a_amount = $total_x26a;

                  $percentin_tds_roi_process_step26 = $level_26a_release_percent / 100;       

                 //Get the result.

                  $step26_amount = $percentin_tds_roi_process_step26 * $level_26a_amount;

                }

             }



             //get level position27a amount



             if ($total_oagrbv_27 < 30000) {

               $level_27a_percent = 6; 

             }

             elseif ($total_oagrbv_27 < 75000) {

               $level_27a_percent = 9; 

             }

             else {

               $level_27a_percent = 14;

             }



             if ($percent_amount == $level_27a_percent) {



                $level_27a_release_percent = 0;

                $level_27a_amount = 0;

                $step27_amount = 0;



                

             }else {



                if ($check_level_27 == 0) {

                  $level_27a_release_percent = 0;

                  $level_27a_amount = $total_x27a;

                  $step27_amount = 0;

                }

                else {

                  $level_27a_release_percent = $percent_amount - $level_27a_percent;

                  $level_27a_amount = $total_x27a;

                  $percentin_tds_roi_process_step27 = $level_27a_release_percent / 100;       

                 //Get the result.

                  $step27_amount = $percentin_tds_roi_process_step27 * $level_27a_amount;

                }

             }



             //get level position28a amount



             if ($total_oagrbv_28 < 30000) {

               $level_28a_percent = 6; 

             }

             elseif ($total_oagrbv_28 < 75000) {

               $level_28a_percent = 9; 

             }

             else {

               $level_28a_percent = 14;

             }



             if ($percent_amount == $level_28a_percent) {



                $level_28a_release_percent = 0;

                $level_28a_amount = 0;

                $step28_amount = 0;



                

             }else {



                if ($check_level_28 == 0) {

                  $level_28a_release_percent = 0;

                  $level_28a_amount = $total_x28a;

                  $step28_amount = 0;

                }

                else {

                  $level_28a_release_percent = $percent_amount - $level_28a_percent;

                  $level_28a_amount = $total_x28a;

                  $percentin_tds_roi_process_step28 = $level_28a_release_percent / 100;       

                 //Get the result.

                  $step28_amount = $percentin_tds_roi_process_step28 * $level_28a_amount;

                }

             }



             //get level position29a amount



             if ($total_oagrbv_29 < 30000) {

               $level_29a_percent = 6; 

             }

             elseif ($total_oagrbv_29 < 75000) {

               $level_29a_percent = 9; 

             }

             else {

               $level_29a_percent = 14;

             }



             if ($percent_amount == $level_29a_percent) {



                $level_29a_release_percent = 0;

                $level_29a_amount = 0;

                $step29_amount = 0;



                

             }else {



                if ($check_level_29 == 0) {

                  $level_29a_release_percent = 0;

                  $level_29a_amount = $total_x29a;

                  $step29_amount = 0;

                }

                else {

                  $level_29a_release_percent = $percent_amount - $level_29a_percent;

                  $level_29a_amount = $total_x29a;

                  $percentin_tds_roi_process_step29 = $level_29a_release_percent / 100;       

                 //Get the result.

                  $step29_amount = $percentin_tds_roi_process_step29 * $level_29a_amount;

                }

             }



             //get level position30a amount



             if ($total_oagrbv_30 < 30000) {

               $level_30a_percent = 6; 

             }

             elseif ($total_oagrbv_30 < 75000) {

               $level_30a_percent = 9; 

             }

             else {

               $level_30a_percent = 14;

             }



             if ($percent_amount == $level_30a_percent) {



                $level_30a_release_percent = 0;

                $level_30a_amount = 0;

                $step30_amount = 0;



                

             }else {



                if ($check_level_30 == 0) {

                  $level_30a_release_percent = 0;

                  $level_30a_amount = $total_x30a;

                  $step30_amount = 0;

                }

                else {

                  $level_30a_release_percent = $percent_amount - $level_30a_percent;

                  $level_30a_amount = $total_x30a;

                  $percentin_tds_roi_process_step30 = $level_30a_release_percent / 100;       

                 //Get the result.

                  $step30_amount = $percentin_tds_roi_process_step30 * $level_30a_amount;

                }

             }



             //total_percent_to_getstep1_amount



             $final_step_amount = $step1_amount+$step2_amount+$step3_amount+$step4_amount+$step5_amount+$step6_amount+$step7_amount+$step8_amount+$step9_amount+$step10_amount+$step11_amount+$step12_amount+$step13_amount+$step14_amount+$step15_amount+$step16_amount+$step17_amount+$step18_amount+$step19_amount+$step20_amount+$step21_amount+$step22_amount+$step23_amount+$step24_amount+$step25_amount+$step26_amount+$step27_amount+$step28_amount+$step29_amount+$step30_amount;



             



             



             $total_single_leg = $personal_pv_join+$p_per_product_x1_10a;



             //total_percent_to_get







             //get level position20a amount



          $current_sv = $total_cur_1+$total_cur_2+$total_cur_3+$total_cur_4+$total_cur_6+$total_cur_7+$total_cur_8+$total_cur_9+$total_cur_10+$total_cur_11+$total_cur_12+$total_cur_13+$total_cur_14+$total_cur_15+$total_cur_16+$total_cur_17+$total_cur_18+$total_cur_19+$total_cur_20+$total_cur_21+$total_cur_22+$total_cur_23+$total_cur_24+$total_cur_25+$total_cur_26+$total_cur_27+$total_cur_28+$total_cur_29+$total_cur_30;



          $current_sv_final = $current_sv+$total_single_leg;





             $percentin_tds_roi_process = $percent_amount / 100;       

             //Get the result.

             $current_release_step = $percentin_tds_roi_process * $total_single_leg;



             $current_release = $current_release_step+$final_step_amount;



            $current_xposition_1 = $x_position_main;

             $select_query_level_1 = "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 = '$current_xposition_1' AND roi_amount >= '300'";

                $run_level_1 = mysqli_query($con,$select_query_level_1);

                while($row_level_1 = mysqli_fetch_array($run_level_1)){

                      $level_1_income_1 = $row_level_1['SUM(roi_amount)'];

                      

                }

              $select_query_level_1_products = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND x_position = '$current_xposition_1' AND product_amount >= '300' AND status='0'";

                $run_level_1_products = mysqli_query($con,$select_query_level_1_products);

                while($row_level_1_products = mysqli_fetch_array($run_level_1_products)){

                      $level_1_income_products_1 = $row_level_1_products['SUM(product_amount)'];

                      

                }

                $level_1_income = $level_1_income_products_1+$level_1_income_1;



            $current_xposition_2 = $x_position_main+1;

             $select_query_level_2 = "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 = '$current_xposition_2' AND roi_amount >= '300'";

                $run_level_2 = mysqli_query($con,$select_query_level_2);

                while($row_level_2 = mysqli_fetch_array($run_level_2)){

                      $level_2_income_1 = $row_level_2['SUM(roi_amount)'];

                      

                }



                $select_query_level_2_products = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND x_position = '$current_xposition_2' AND product_amount >= '300' AND status='0'";

                $run_level_2_products = mysqli_query($con,$select_query_level_2_products);

                while($row_level_2_products = mysqli_fetch_array($run_level_2_products)){

                      $level_2_income_products_1 = $row_level_2_products['SUM(product_amount)'];

                      

                }



                $level_2_income = $level_2_income_1+$level_2_income_products_1;



           $current_xposition_3 = $x_position_main+1;



           $current_xposition_3a = $x_position_main+12;



             $select_query_level_3 = "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 > '$current_xposition_3' AND roi_amount >= '300' AND x_position < '$current_xposition_3a'";

                $run_level_3 = mysqli_query($con,$select_query_level_3);

                while($row_level_3 = mysqli_fetch_array($run_level_3)){

                      $level_3_income_1 = $row_level_3['SUM(roi_amount)'];

                      

                }

                $select_query_level_3_products = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND x_position > '$current_xposition_3' AND product_amount >= '300' AND x_position < '$current_xposition_3a' AND status='0'";

                $run_level_3_products = mysqli_query($con,$select_query_level_3_products);

                while($row_level_3_products = mysqli_fetch_array($run_level_3_products)){

                      $level_3_income_1_products = $row_level_3_products['SUM(product_amount)'];

                      

                }



                $level_3_income = $level_3_income_1+$level_3_income_1_products;



                $current_xposition_4 = $x_position_main+11;



                 $current_xposition_4a = $x_position_main+21;



                   $select_query_level_4 = "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 > '$current_xposition_4' AND roi_amount >= '300' AND x_position < '$current_xposition_4a'";

                      $run_level_4 = mysqli_query($con,$select_query_level_4);

                      while($row_level_4 = mysqli_fetch_array($run_level_4)){

                            $level_4_income_1 = $row_level_4['SUM(roi_amount)'];

                            

                      }



                      $select_query_level_4_products = "select SUM(product_amount) from product_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND member_no <> '$member_no_main' AND product_no not in (".implode(',', $arr1_10a_pro).") AND x_position > '$current_xposition_4' AND product_amount >= '300' AND x_position < '$current_xposition_4a' AND status='0'";

                      $run_level_4_products = mysqli_query($con,$select_query_level_4_products);

                      while($row_level_4_products = mysqli_fetch_array($run_level_4_products)){

                            $level_4_income_1_products = $row_level_4_products['SUM(product_amount)'];

                            

                      }



                      $level_4_income = $level_4_income_1+$level_4_income_1_products;

                        

                         $network_bonus_per_1 = 3;



                         $percentin_network_1 = $network_bonus_per_1 / 100;       

                         //Get the result.

                         $current_1_income_1 = $percentin_network_1 * $level_1_income;





                         $network_bonus_per_2 = 1.5;



                         $percentin_network_2 = $network_bonus_per_2 / 100;       

                         //Get the result.

                         $current_2_income_2 = $percentin_network_2 * $level_2_income;





                         $network_bonus_per_3 = 1;



                         $percentin_network_3 = $network_bonus_per_3 / 100;       

                         //Get the result.

                         $current_3_income_3 = $percentin_network_3 * $level_3_income;





                         $network_bonus_per_4 = 0.5;



                         $percentin_network_4 = $network_bonus_per_4 / 100;       

                         //Get the result.

                         $current_4_income_4 = $percentin_network_4 * $level_4_income;





                         if ($total_single_leg > 300) {



                          $final_hold_net = $total_single_leg-300;



                          $current_net_bo_bv = floor($final_hold_net / 300);



                          $final_percent_bv = $current_net_bo_bv*300;





                          $network_bonus_per_5 = 3;



                         $percentin_network_5 = $network_bonus_per_5 / 100;       

                         //Get the result.

                         $current_5_income_5 = $percentin_network_5 * $final_percent_bv;

                            

                         }

                         else {



                           $current_5_income_5 = 0;



                         }



                        $total_network_bonus = 0;





                        





                        switch ($rank) {

                          case '0':

                            $title_user= "CONSULTANT";

                            break;

                          case '1':

                            $title_user= "CON.MANAGER";

                            break;

                         case '2':

                            $title_user= "CON.SENIOR MANAGER";

                            break;



                          case '3':

                            $title_user= "CON.DIRECTOR";

                            break;

                        case '4':

                            $title_user= "CON.SENIOR DIRECTOR";

                            break;

                        case '5':

                            $title_user= "CON.VICE PRESIDENT";

                            break;

                        case '6':

                            $title_user= "CON.SENIOR VICE PRESIDENT";

                            break;

                        case '7':

                            $title_user= "CON.PRESIDENT";

                            break;

                          

                          default:

                            # code...

                            break;

                        }



                        $select_query_12 = "select * from admin";

                                      $run_12 = mysqli_query($con,$select_query_12);

                                       while ($row_12 = mysqli_fetch_array($run_12)) { 

                                        $network_12 = $row_12['network']; 

                                    }





                        $select_query_net_tree = "select * from net_tree where member_no = '$member_no' AND status = '$network_12'";

                        $run_net_tree = mysqli_query($con,$select_query_net_tree);

                        $check_net_tree = mysqli_num_rows($run_net_tree);







                        //voucher bonus



                        $select_query_voucher_bonus = "select SUM(total_amount) from wallet_payout where member_no = '$member_no' AND status='0'";

                          $run_voucher_bonus = mysqli_query($con,$select_query_voucher_bonus);

                          while($row_voucher_bonus = mysqli_fetch_array($run_voucher_bonus)){ 



                                $total_voucher_bonus = $row_voucher_bonus['SUM(total_amount)']; 

                                

                          }



                          $select_query_voucher_balance = "select SUM(amount) from cart_balance where member_no = '$member_no'";

                          $run_voucher_balance = mysqli_query($con,$select_query_voucher_balance);

                          while($row_voucher_balance = mysqli_fetch_array($run_voucher_balance)){ 



                                $total_voucher_balance = $row_voucher_balance['SUM(amount)']; 

                                

                          } 



                          $available_balance_amt = $total_voucher_bonus+$total_voucher_balance;



                          $select_query_paid_title = "select * from title where member_no = '$member_no'";

                          $run_paid_title = mysqli_query($con,$select_query_paid_title);

                          $check_paid_title = mysqli_num_rows($run_paid_title);





                          $total_grouwth_leg = $growth_leg_1+$growth_leg_2+$growth_leg_3+$growth_leg_4+$growth_leg_5+$growth_leg_6+$growth_leg_7+$growth_leg_8+$growth_leg_9+$growth_leg_10+$growth_leg_11+$growth_leg_12+$growth_leg_13+$growth_leg_14+$growth_leg_15+$growth_leg_16+$growth_leg_17+$growth_leg_18+$growth_leg_19+$growth_leg_20+$growth_leg_21+$growth_leg_22+$growth_leg_23+$growth_leg_24+$growth_leg_25+$growth_leg_26+$growth_leg_27+$growth_leg_28+$growth_leg_29+$growth_leg_30;



                        //voucher bonus





                      





          



        ?> 

        <!DOCTYPE html>

<html lang="en">



<head>

  <meta charset="UTF-8">

  <meta content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no" name="viewport">

  <title>RAKCHABLOOMING</title>

  <!-- General CSS Files -->

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

  <link rel="stylesheet" href="assets/bundles/jqvmap/dist/jqvmap.min.css">

  <link rel="stylesheet" href="assets/bundles/weather-icon/css/weather-icons.min.css">

  <link rel="stylesheet" href="assets/bundles/weather-icon/css/weather-icons-wind.min.css">

  <link rel="stylesheet" href="assets/bundles/summernote/summernote-bs4.css">

  <!-- Template CSS -->

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

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

  <!-- Custom style CSS -->

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

  <link rel='shortcut icon' type='image/x-icon' href='assets/img/favicon.ico' />

  <style type="text/css">

    .card {

      border-radius: 0 !important;

    }

  </style>

</head>



<body>

  <div class="loader"></div>

  <div id="app">

    <div class="main-wrapper main-wrapper-1">

      <div class="navbar-bg"></div>

      <?php include("includes/header.php"); ?>

      <!-- Main Content -->

      <div class="main-content">

        <section class="section">



          <div class="row">

              <div class="col-xl-12 col-lg-12">

                        <div class="card" style="border-top: 2px solid green;border-bottom: 2px solid green;background-color:#08a7d6;">

                          <div style="font-size: 15px;margin: 0;padding-top: 10px;padding-bottom: 6px;color:#fff;">

                            

                            <div class="card-content">

                              <marquee id="test5" behavior="scroll" direction="left" scrolldelay="200" scrollamount="6" onMouseOver="document.all.test5.stop()" onMouseOut="document.all.test5.start()">



                                  <?php  

                                    $select_query_s2 = "select * from daily";

                                    $run_s2 = mysqli_query($con,$select_query_s2);

                                    $sponser_count_spons = mysqli_num_rows($run_s2);

                                    if ($sponser_count_spons > 0) {

                                       

                                   ?>

                                  <span style="padding-right: 5px;padding-left: 5px;"> *</span>

                                  <?php                                    



                                                    $select_query_s1 = "select * from daily";

                                                    $run_s1 = mysqli_query($con,$select_query_s1);

                                                     

                                                     

                                                     while ($row_s1 = mysqli_fetch_array($run_s1)) {

                                                     

                                                      $id_s1 = $row_s1['id'];

                                                      $date_s1 = $row_s1['date'];

                                                      $category_s1 = $row_s1['category'];

                                                      $message_s1 = $row_s1['message'];



                                              ?>  



                                             <?= $message_s1; ?> 



                                              



                                              

                                              <span style="padding-right: 5px;padding-left: 5px;"> *</span>

                                              <?php } ?>

                                               

                                            <?php }else {

                                              ?>



                                              WELCOME TO RAKCHABLOOMING !!!



                                              <?php

                                            } ?>

                                    </marquee>

                                

                               

                               

                            </div>

                          </div>

                        </div>

                      </div>

          </div>



          <div class="row">

            <div class="col-md-6">



                  

                <div class="card profile-widget card-primary" style="background-color: green;">

                  <div class="profile-widget-header">



                    <?php if ($profile == '') {

                                  ?>

                            <img alt="image" src="img/profiles.png" class="rounded-circle profile-widget-picture">

                        <?php }else {

                            ?>

                            

                           <img alt="image" src="../user_profile/<?= $profile; ?>" class="rounded-circle profile-widget-picture">

                            <?php

                        } ?>





                        <div class="profile-widget-items" >

                            <div class="profile-widget-item">

                              <div class="profile-widget-item-label" style="color: #fff !important;"><?= $name; ?></div>

                              <div class="profile-widget-item-value" style="color: #ffc20f !important;"><?= $user_id; ?></div>

                            </div>

                             <div class="profile-widget-item">



                              <div class="profile-widget-item-label" style="color: #fff !important;">Percentage</div>

                         

                                <div class="profile-widget-item-value" style="color: #ffc20f !important;"><?= $percent_amount; ?>%</div>

                              </div>

                               

                          </div>



                     



                     

                  </div>

                  <div class="profile-widget-description pb-0">

                     

                    <p class="clearfix" style="color: #fff;">

                        <span class="float-left">

                          Paid Title

                        </span>

                        <span class="float-right">

                          <b> <?= $title_user; ?></b> 

                        </span>

                      </p>

                    



                      <p class="clearfix" style="color: #fff;">

                        <span class="float-left">

                          Star Title

                        </span>

                        <span class="float-right">

                           <b> -</b> 

                        </span>

                      </p>



                      <p class="clearfix" style="color: #fff;">

                        <span class="float-left">

                          Founder Title

                        </span>

                        <span class="float-right">

                          <b> -</b> 

                        </span>

                      </p>

                      

                      <p class="clearfix" style="color: #fff;">

                        <span class="float-left">

                          Rolling Title

                        </span>

                        <span class="float-right">

                          <b>



                            <?php if ($check_paid_title > 0) {



                              $select_query_main_aq = "select * from title where member_no = '$member_no'";

                              $run_main_aq = mysqli_query($con,$select_query_main_aq);

                               

                               while ($row_main_aq = mysqli_fetch_array($run_main_aq)) {

                                $title_main_aq = $row_main_aq['title'];                                    

                                 

                                }

                                echo $title_main_aq;





                             } else { ?>



                           <?= $title_user; ?>



                         <?php } ?>

                             



                           </b> 

                        </span>

                      </p>



                      <!-- <?php if ($total_team_pvs < 75000) { ?>



                      <p class="clearfix" style="color: #fff;">

                        <span class="float-left">

                          Remaining Bv For Next Level 

                        </span>

                        <span class="float-right">

                           <b> <?= $next_level_amount-$total_team_pvs; ?> -  <?= $next_ve_per; ?>% </b> 

                        </span>

                      </p>



                      <?php } ?> -->

                    

                  </div>

                  

                </div>

                 

               

            </div>

             

             

            <div class="col-md-6">

                

                <div class="row" style="margin-top: 39px;">

                        <div class="col-xl-6 col-lg-6">

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

                          <div class="card" style="background-color: red !important;">

                          <?php } else { ?>



                            <div class="card" style="background-color: #03799c !important;">



                           <?php } ?>

                            <div class="card-statistic-3">

                               

                              <div class="card-content" style="padding-bottom: 15px;">

                                

                                <span>PERSONAL BV</span>

                                                   <h4 class="card-title" style="margin-top:15px;"><?php 

                                                      echo $total_single_leg+0;

                                                   ?></h4>

                                

                              </div>

                            </div>

                          </div>

                        </div>

                        <div class="col-xl-6 col-lg-6">

                          <div class="card" style="background-color: #03799c !important;">

                            <div class="card-statistic-3">

                               

                              <div class="card-content" style="padding-bottom: 15px;">

                                

                                <span>GROUP BV</span>

                                                   <h4 class="card-title" style="margin-top:15px;"><?php 

                                                     

                                                       echo $total_single_leg_current_view+0;

                                                     

                                                      

                                                   ?></h4>

                                 

                              </div>

                            </div>

                          </div>

                        </div>



                        <?php if ($percent_amount < 14) { ?>

                       

                        <div class="col-xl-6 col-lg-6">

                          <div class="card" style="background-color: #03799c !important;">

                            <div class="card-statistic-3">

                               

                              <div class="card-content" style="padding-bottom: 15px;">

                                

                                <span>AGBV</span>

                                                   <h4 class="card-title" style="margin-top:15px;"><?php 

                                                      echo $total_team_pvs+0;

                                                   ?></h4>

                                

                              </div>

                            </div>

                          </div>

                        </div>

                      <?php } ?>

                        

                        <div class="col-xl-6 col-lg-6">

                          <div class="card" style="background-color: #03799c !important;">

                            <div class="card-statistic-3">

                               

                              <div class="card-content" style="padding-bottom: 15px;">

                                

                                <span>SIDE VOLUME</span>

                                                   <h4 class="card-title" style="margin-top:15px;"><?php



                                                    if ($total_grouwth_leg > 0) {



                                                      



                                                     

                                                      echo $current_sv+0;

                                                    

                                                  }

                                                  else {

                                                    echo "0";

                                                  }



                                                      

                                                   ?></h4>

                                 

                              </div>

                            </div>

                          </div>

                        </div>

                      </div>



                       

            </div>

          </div>



          <div class="row ">

                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      

                                      <span>TOTAL EARNINGS</span>

                                      <h4 class="card-title">Rs. <?= $current_release+$total_network_bonus+0; ?> <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-purple" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                         <span class="mr-2">Rs.                        <?= $current_release+$total_network_bonus+$total_team_pv_total_amount+$total_team_pv_car_bonus+$network_bonus_data+$current_release_data+$total_team_old_total_amount+$total_team_old_amount; ?></span>

                                        

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>

                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span>PERFORMANCE BONUS</span>

                                      <h4 class="card-title">  Rs. 0 <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-orange" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2">Rs.                        <?= $current_release+$total_team_pv_old_binary+0+$current_release_data+$total_team_old_binary_income; ?></span>

                                         

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>

                              <?php if ($check_net_tree > 0) { ?>

                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                     

                                    <div class="card-content">

                                      <span>NETWORK BONUS</span>

                                      <h4 class="card-title" style="color: #fff;font-size: 14px;"><span class="text-nowrap" >this month



                                          <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-check-circle"><path d="M22 11.08V12a10 10 0 1 1-5.93-9.14"></path><polyline points="22 4 12 14.01 9 11.01"></polyline></svg> Qualified

                                          </span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-cyan" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                         

                                        Rs.                        <?= $total_team_pv_proold_ref+0; ?>



                                         

                                          



                                         

                                           



                                         

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>

                              <?php } else {

                                ?>



                                <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                     

                                    <div class="card-content">

                                      <span>NETWORK BONUS</span>

                                      <h4 class="card-title" style="color: #fff;font-size: 14px;">  <span class="text-nowrap" >this month



                                          <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-x-circle"><circle cx="12" cy="12" r="10"></circle><line x1="15" y1="9" x2="9" y2="15"></line><line x1="9" y1="9" x2="15" y2="15"></line></svg> Pending

                                          </span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-cyan" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                         

                                        Rs.                        <?= $total_team_pv_proold_ref+0; ?>



                                         

                                        



                                         

                                           



                                         

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                                <?php

                              } ?>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span>MANAGER BONUS</span>

                                      <h4 class="card-title"> Rs. 0  <span class="text-nowrap" style="font-size: 14px;">This Month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2">Rs.                        <?= $total_team_pv_manager_bonus+0; ?></span>

                                       

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>

                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span>TOUR BONUS</span>

                                      <h4 class="card-title"> Rs.                          <?= $total_team_old_netpay+0; ?> <span class="text-nowrap" style="font-size: 14px;">Available</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2">Rs.                        <?= $total_team_old_amount+0; ?></span>

                                        

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span>CAR BONUS</span>

                                      <h4 class="card-title">Rs. 0 <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2">Rs. <?= $total_team_pv_car_bonus+0; ?> </span>

                                        

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span>LEADERSHIP BONUS</span>

                                      <h4 class="card-title"> Rs. 0 <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2">Rs. <?= $total_team_pv_leader_bonus+0; ?> </span>

                                        

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span>HOUSE BONUS</span>

                                      <h4 class="card-title"> Rs. 0 <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2">Rs. <?= $total_team_pv_house_bonus+0; ?></span>

                                        

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span>COMMITTEE BONUS</span>

                                      <h4 class="card-title"> Rs. 0 <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2">Rs. <?= $total_team_pv_ups_bonus+$total_team_old_ups_bonus+0; ?> </span>

                                        

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span>PAID AS PRESIDENT BONUS</span>

                                      <h4 class="card-title">Rs. 0 <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2"> Rs. 0 </span>

                                        

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span style="text-transform: uppercase;">Guaranteed Royalty Bonus</span>

                                      <h4 class="card-title">Rs. 0 <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2"> Rs. 0 </span>

                                        

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span style="text-transform: uppercase;">FOUNDER PRESIDENT BONUS</span>

                                      <h4 class="card-title">Rs. 0 <span class="text-nowrap" style="font-size: 14px;">this month</span></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2"> Rs. 0 </span>

                                         

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>



                              <div class="col-xl-3 col-lg-6">

                                <div class="card" style="background-color: #08a7d6;">

                                  <div class="card-statistic-3">

                                    

                                    <div class="card-content">

                                      <span style="text-transform: uppercase;">Voucher Bonus</span>

                                      <h4 class="card-title">Rs. <?= $available_balance_amt+0; ?></h4>

                                      

                                      <div class="progress mt-1 mb-1" data-height="1">

                                        <div class="progress-bar l-bg-green" role="progressbar" data-width="100%" aria-valuenow="100"

                                          aria-valuemin="0" aria-valuemax="100"></div>

                                      </div>

                                      <p class="mb-0 text-sm">

                                        <span class="mr-2"> </span>

                                        <span class="text-nowrap">available</span>

                                      </p>

                                    </div>

                                  </div>

                                </div>

                              </div>

         </div>



          



           

          

          





           

          

           

           

        </section>

        

      </div>

      <footer class="main-footer">

        <div class="footer-left">

          Copyright &copy; 2021 <div class="bullet"></div> All Rights Reserved.

        </div>

        

      </footer>

    </div>

  </div>

  <!-- General JS Scripts -->

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

  <!-- JS Libraies -->

  <script src="assets/bundles/echart/echarts.js"></script>

  <script src="assets/bundles/chartjs/chart.min.js"></script>

  <!-- Page Specific JS File -->

  <script src="assets/js/page/index.js"></script>

  <!-- Template JS File -->

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

  <!-- Custom JS File -->

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

</body>



</html>



<?php } } ?>