<?php 

session_start();

 include("includes/database.php");

  

   $select_query = "select * from member where member_category='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



          



              if ($first_level_sponsor > 0) {

                //first level



                $arr1 = array();

                $select_query_findempty_pay = "select * from direct_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'];

                      $first_level_roi_date = $row_get_fresh_member1['date'];





                      $date1=date($first_level_roi_date);

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

                      $date_diff=strtotime($date2)-strtotime($date1);

                      $current_month = floor(($date_diff)/2628000);



                      if ($current_month > 0) {

                        



                     $commission=5;

                     $commission_percent = $commission / 100;       

                     //Get the result.

                     $final_member_amount_give = $commission_percent * $first_level_roi_amount;



                     



                      $insert_payment = "insert into direct_refferral(member_no, user_id, amount, giver, date) values('$member_no', '$user_id_main', '$final_member_amount_give', '$first_level_roi_member_no', '$today_date')";

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

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

                      }

                    }

                      

                   } 

                 }



               

               //first level 





                

              }



         

       

   

   } 

  ?>