<?php 



  include("includes/database.php");



       $select_query = "select * from member where member_category='2' AND member_id <= '1500'";

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

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



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

        $run_main = mysqli_query($con,$select_query_main);

         

         while ($row_main = mysqli_fetch_array($run_main)) {

          $tree_id_main = $row_main['tree_id'];                                    

          $group_number_main = $row_main['group_number'];

          $member_no_main = $row_main['member_no'];

          $user_id_main = $row_main['user_id'];

          $sponsor_no_main = $row_main['sponsor_no'];

          $relation_ship_no_main = $row_main['relation_ship_no'];

          $level_no_main = $row_main['level_no'];

          $x_position_main = $row_main['x_position']+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;



            $extra_kit = 81;

          }

          else {

            $extra_amount_bv = 0;

            $extra_kit = 81;

          }







          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;



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

          }







       $total_single_leg = $personal_pv_join+$p_per_product_x1_10a;



       

 mysqli_query($con,"update roi_tree set network_amount='$total_single_leg' where member_no='$member_no'");

 mysqli_query($con,"update net_tree set network_amount='$total_single_leg' where member_no='$member_no'");



          

 } ?>