<?php 

session_start();

 include("includes/database.php");

  

   $select_query = "select * from member where member_category='2' AND payment_member <> '2'";

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

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

    $member_id = $row['member_id'];

    $title = $row['title'];

    $dob = $row['dob'];

    $name = $row['name'];

    $gender = $row['gender'];

    $address_1 = $row['address_1'];

    $address_2 = $row['address_2'];

    $town_area = $row['town_area'];

    $city_district = $row['city_district'];

    $state = $row['state'];

    $country = $row['country'];

    $pincode = $row['pincode'];

    $mobile_number = $row['mobile_number'];

    $email = $row['email'];

    $aadhaar_card = $row['aadhaar_card'];

    $pan_card = $row['pan_card'];

    $nominee_name = $row['nominee_name'];

    $nominee_relationship = $row['nominee_relationship'];

    $account_name = $row['account_name'];

    $account_number = $row['account_number'];

    $ifsc_code = $row['ifsc_code'];

    $bank_name = $row['bank_name'];

    $branch_name = $row['branch_name'];

    $member_no = $row['member_no'];

    $user_id = $row['user_id'];

    $password = $row['password'];

    $aadhaar_card_image = $row['aadhaar_card_image'];

    $pan_card_image = $row['pan_card_image'];

    $bank_proof_image = $row['bank_proof_image'];

    $document_status = $row['document_status'];

    $activity_level = $row['activity_level'];

    $activity_referral = $row['activity_referral'];

    $activity_date = $row['activity_date'];

    $activity_month = $row['activity_month'];

    $member_fess = $row['member_fess'];

    $elite_board = $row['elite_board'];

    $aadhaar_card_image = $row['aadhaar_card_image'];

    $pan_card_image = $row['pan_card_image'];

    $bank_proof_image = $row['bank_proof_image'];

    $document_status = $row['document_status'];

    $date_of_join_1 =$row['date_of_join'];

    $member_category =$row['member_category'];

    $roi_status =$row['roi_status'];

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

    $today_date = date('Y-m-d');

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

          }



          //first level direct

          $select_query_firstlevel_spons = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position = '$x_position_main' AND sponsor_no='$member_no_main'";

              $run_firstlevel_spons = mysqli_query($con,$select_query_firstlevel_spons);

              while($row_firstlevel_spons = mysqli_fetch_array($run_firstlevel_spons)){

                    $first_level_sponsor = $row_firstlevel_spons['SUM(roi_amount)'];

                    

              }

          //first level direct



          //second level direct

              $current_position = $x_position_main+1;

          $select_query_second_level_team = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position = '$current_position'";

              $run_second_level_team = mysqli_query($con,$select_query_second_level_team);

              while($row_second_level_team = mysqli_fetch_array($run_second_level_team)){

                    $second_level_team = $row_second_level_team['SUM(roi_amount)'];

                    

              }

          //second level direct



          //second level direct

              $current_position_2 = $x_position_main+2;

          $select_query_third_level_team = "select SUM(roi_amount) from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position = '$current_position_2'";

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

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

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

                    

              }

          //second level direct



              $total_check_team_member = $first_level_sponsor+$second_level_team+$third_level_team;



              if ($total_check_team_member > 0) {

                //first level



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

                }

                $final_position_1 = $x_position_main;               



                $select_query_get_fresh_member1 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position = '$final_position_1' AND member_no not in (".implode(',', $arr1).") AND sponsor_no='$member_no_main'";

                $run_get_fresh_member1 = mysqli_query($con,$select_query_get_fresh_member1);

                $count_get_fresh_member1 = mysqli_num_rows($run_get_fresh_member1);

                if ($count_get_fresh_member1 > 0) {

                

                while($row_get_fresh_member1 = mysqli_fetch_array($run_get_fresh_member1)){

                      $first_level_roi_amount = $row_get_fresh_member1['roi_amount'];

                      $first_level_roi_member_no = $row_get_fresh_member1['member_no'];



                     $commission=2;

                     $commission_percent = $commission / 100;       

                     //Get the result.

                     $final_member_amount_give = $commission_percent * $first_level_roi_amount;



                     $select_query_count_1 = "select * from binary_roi";

                      $run_count_1 = mysqli_query($con,$select_query_count_1);

                      $user_count_1 = mysqli_num_rows($run_count_1);



                      $nominee_name_id1_1 = $user_count_1 + 1;



                      $insert_payment = "insert into binary_roi(member_no, user_id, date, amount, roi_category, roi_no, member_category) values('$member_no', '$user_id_main', '$today_date', '$final_member_amount_give', '2', '$nominee_name_id1_1', '2')";

                      if (mysqli_query($con,$insert_payment)) {

                          mysqli_query($con,"insert into roi_member(member_no, used_no) values('$member_no', '$first_level_roi_member_no')");

                      }

                      

                   } 

                 }



               

               //first level 





                 //get second level amount



                 if ($first_level_sponsor > 500000) {

                  

                    $arr2 = 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)) {

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

                    }

                    $final_position_2 = $x_position_main+1;               



                    $select_query_get_fresh_member2 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position = '$final_position_2' AND member_no not in (".implode(',', $arr2).")";

                    $run_get_fresh_member2 = mysqli_query($con,$select_query_get_fresh_member2);

                    $count_get_fresh_member2 = mysqli_num_rows($run_get_fresh_member2);

                    if ($count_get_fresh_member2 > 0) {

                    

                    while($row_get_fresh_member2 = mysqli_fetch_array($run_get_fresh_member2)){

                          $first_level_roi_amount = $row_get_fresh_member2['roi_amount'];

                          $first_level_roi_member_no = $row_get_fresh_member2['member_no'];



                         $commission=1;

                         $commission_percent = $commission / 100;       

                         //Get the result.

                         $final_member_amount_give = $commission_percent * $first_level_roi_amount;



                         $select_query_count_1 = "select * from binary_roi";

                          $run_count_1 = mysqli_query($con,$select_query_count_1);

                          $user_count_1 = mysqli_num_rows($run_count_1);



                          $nominee_name_id1_1 = $user_count_1 + 1;



                          $insert_payment = "insert into binary_roi(member_no, user_id, date, amount, roi_category, roi_no, member_category) values('$member_no', '$user_id_main', '$today_date', '$final_member_amount_give', '2', '$nominee_name_id1_1', '2')";

                          if (mysqli_query($con,$insert_payment)) {

                              mysqli_query($con,"insert into roi_member(member_no, used_no) values('$member_no', '$first_level_roi_member_no')");

                          }

                          

                       } 

                     }



                                



                 }



                 //get second level amount



                 //get third level amount



                 if ($second_level_team > 2000000) {

                  

                    $arr3 = 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)) {

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

                    }

                    $final_position_3 = $x_position_main+2;               



                    $select_query_get_fresh_member3 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position = '$final_position_3' AND member_no not in (".implode(',', $arr3).")";

                    $run_get_fresh_member3 = mysqli_query($con,$select_query_get_fresh_member3);

                    $count_get_fresh_member3 = mysqli_num_rows($run_get_fresh_member3);

                    if ($count_get_fresh_member3 > 0) {

                    

                    while($row_get_fresh_member3 = mysqli_fetch_array($run_get_fresh_member3)){

                          $first_level_roi_amount = $row_get_fresh_member3['roi_amount'];

                          $first_level_roi_member_no = $row_get_fresh_member3['member_no'];



                         $commission=1;

                         $commission_percent = $commission / 100;       

                         //Get the result.

                         $final_member_amount_give = $commission_percent * $first_level_roi_amount;



                         $select_query_count_1 = "select * from binary_roi";

                          $run_count_1 = mysqli_query($con,$select_query_count_1);

                          $user_count_1 = mysqli_num_rows($run_count_1);



                          $nominee_name_id1_1 = $user_count_1 + 1;



                          $insert_payment = "insert into binary_roi(member_no, user_id, date, amount, roi_category, roi_no, member_category) values('$member_no', '$user_id_main', '$today_date', '$final_member_amount_give', '2', '$nominee_name_id1_1', '2')";

                          if (mysqli_query($con,$insert_payment)) {

                              mysqli_query($con,"insert into roi_member(member_no, used_no) values('$member_no', '$first_level_roi_member_no')");

                          }

                          

                       } 

                     }



                                



                 }



                 //get third level amount



                 //get fourth level amount



                 if ($third_level_team > 4000000) {

                  

                    $arr4 = 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)) {

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

                    }

                    $final_position_4 = $x_position_main+3;               



                    $select_query_get_fresh_member4 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main}%' AND x_position = '$final_position_4' AND member_no not in (".implode(',', $arr4).")";

                    $run_get_fresh_member4 = mysqli_query($con,$select_query_get_fresh_member4);

                    $count_get_fresh_member4 = mysqli_num_rows($run_get_fresh_member4);

                    if ($count_get_fresh_member4 > 0) {

                    

                    while($row_get_fresh_member4 = mysqli_fetch_array($run_get_fresh_member4)){

                          $first_level_roi_amount = $row_get_fresh_member4['roi_amount'];

                          $first_level_roi_member_no = $row_get_fresh_member4['member_no'];



                         $commission=1;

                         $commission_percent = $commission / 100;       

                         //Get the result.

                         $final_member_amount_give = $commission_percent * $first_level_roi_amount;



                         $select_query_count_1 = "select * from binary_roi";

                          $run_count_1 = mysqli_query($con,$select_query_count_1);

                          $user_count_1 = mysqli_num_rows($run_count_1);



                          $nominee_name_id1_1 = $user_count_1 + 1;



                          $insert_payment = "insert into binary_roi(member_no, user_id, date, amount, roi_category, roi_no, member_category) values('$member_no', '$user_id_main', '$today_date', '$final_member_amount_give', '2', '$nominee_name_id1_1', '2')";

                          if (mysqli_query($con,$insert_payment)) {

                              mysqli_query($con,"insert into roi_member(member_no, used_no) values('$member_no', '$first_level_roi_member_no')");

                          }

                          

                       } 

                     }



                                



                 }



                 //get fourth level amount

              }



         

       

   

   } 

  ?>