1#@!#!123s

: / home5 / rakcha / www / user /
Filename : get_percent.php
back
<?php 



  include("includes/database.php");



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

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

          $network_amount_main = $row_main['network_amount'];                                    

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

          $y_position_main = $row_main['y_position'];

          $roi_amount_main = $row_main['roi_amount'];

          $product_amount_main = $row_main['product_amount'];

          $x_position_main_my = $row_main['x_position']+1;

          $percent_main = $row_main['percent'];

        }





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

                

          }



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

          }







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



             if ($total_team_pv < 750) {

               $percent_amount = 0; 

             }

             elseif ($total_team_pv < 1500) {

               $percent_amount = 2; 

             }



             elseif ($total_team_pv < 3000) {

               $percent_amount = 4; 

             }



             elseif ($total_team_pv < 6000) {

               $percent_amount = 6; 

             }



             

             else {

               $percent_amount = 9;

             }





             mysqli_query($con,"update roi_tree set percent='$percent_amount' where member_no='$member_no'");

             mysqli_query($con,"update member set percent='$percent_amount' where member_no='$member_no'");



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



          

 } ?>