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

    $first_level =$row['first_level'];

    $second_level =$row['second_level'];

    $third_level =$row['third_level'];

    $fourth_level =$row['fourth_level'];



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

          $date_main = $row_main['date'];

          }



         

          $date1 = str_replace('-', '/', $date_main);

          $tomorrow = date('Y-m-d',strtotime($date1 . "+30 days"));

         









          //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' AND date <= '$tomorrow'";

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

                    

              }



              $current_position_2 = $x_position_main+3;

          $select_query_fourth_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_fourth_level_team = mysqli_query($con,$select_query_fourth_level_team);

              while($row_fourth_level_team = mysqli_fetch_array($run_fourth_level_team)){

                    $fourth_level_team = $row_fourth_level_team['SUM(roi_amount)'];

                    

              }

          //second level direct





              if ($first_level_sponsor >= 500000 && $first_level == 0) {



                mysqli_query($con,"update member set first_level='1' where member_no = '$member_no'");

                 

              }

              if ($second_level_team >= 2000000 && $second_level == 0) {

                 mysqli_query($con,"update member set second_level='1' where member_no = '$member_no'");

              }

              if ($third_level_team >= 4000000 && $third_level == 0) {



                mysqli_query($con,"update member set third_level='1' where member_no = '$member_no'");

                 

              }

              if ($fourth_level_team >= 10000000 && $fourth_level == 0) {

                 mysqli_query($con,"update member set fourth_level='1' where member_no = '$member_no'");

              }



              



         

       

   

   } 

  ?>