<?php 

session_start();

 include("includes/database.php");

  

   $select_query = "select * from member WHERE member_category='2' AND rank >= '2'";

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

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

        $member_no = $row['member_no'];

        $user_id = $row['user_id'];

        $rank = $row['rank'];

        $fb = $row['fb'];

        $cp = $row['cp'];

        $hp = $row['hp'];

        $lp = $row['lp'];

        $gp = $row['gp'];

        $up = $row['up']; 

        $booster = $row['booster']; 



         



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











        //get last month sales



        $last_month_from = date("Y-m-d", strtotime("first day of previous month"));

        $last_month_end = date("Y-m-d", strtotime("last day of previous month"));





         $select_query_total_x1 = "select SUM(product_amount) from product_tree where date >= '$last_month_from' AND date <= '$last_month_end'";

          $run_total_x1 = mysqli_query($con,$select_query_total_x1);

          while($row_total_x1 = mysqli_fetch_array($run_total_x1)){

                $total_x1 = $row_total_x1['SUM(product_amount)'];

                

          }



          $select_query_total_x1a = "select SUM(roi_amount) from roi_tree where date >= '$last_month_from' AND date <= '$last_month_end'";

          $run_total_x1a = mysqli_query($con,$select_query_total_x1a);

          while($row_total_x1a = mysqli_fetch_array($run_total_x1a)){

                $total_x1a_1 = $row_total_x1a['SUM(roi_amount)'];

                

          }



          $total_last_month_sales_1 = $total_x1+$total_x1a_1;



          $total_last_month_sales = $total_last_month_sales_1*36;



          // get last month sales



          if ($rank >= 2) {



                        $select_query_total_point_1 = "select SUM(lp) from member where lp > '0'";

                        $run_total_point_1 = mysqli_query($con,$select_query_total_point_1);

                        while($row_total_point_1 = mysqli_fetch_array($run_total_point_1)){

                              $total_point_1 = $row_total_point_1['SUM(lp)'];

                              

                        } 



                        $processing_amount_leader=12;

                        $percentin_tds_leader = $processing_amount_leader / 100;       

                       //Get the result.

                        $final_processing_amount_leader = $percentin_tds_leader * $total_last_month_sales;





                        $leader_bonus_1a =$final_processing_amount_leader/$total_point_1;





                        $leader_bonus =$leader_bonus_1a/7;





                   

                        }

                        else {

                          $leader_bonus =0;

                        }



                                



                  //leader bonus





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

                            $run_main_network = mysqli_query($con,$select_query_main_network);

                             

                             while ($row_main_network = mysqli_fetch_array($run_main_network)) {

                              $tree_id_main_network = $row_main_network['tree_id'];                                    

                              $group_number_main_network = $row_main_network['group_number'];

                              $member_no_main_network = $row_main_network['member_no'];

                              $user_id_main_network = $row_main_network['user_id'];

                              $sponsor_no_main_network = $row_main_network['sponsor_no'];

                              $relation_ship_no_main_network = $row_main_network['relation_ship_no'];

                              $level_no_main_network = $row_main_network['level_no'];

                              $x_position_main_network = $row_main_network['x_position'];

                              $y_position_main_network = $row_main_network['y_position'];

                              $roi_amount_main_network = $row_main_network['roi_amount'];

                              $roi_status_main_network = $row_main_network['roi_status'];

                              $status_main_network = $row_main_network['status'];

                              $product_amount_main_network = $row_main_network['product_amount'];

                              $total_bv_main_network = $row_main_network['total_bv'];

                              }









                          $current_xposition_1 = $x_position_main_network+1;

                          $current_xposition_2 = $x_position_main_network+3;

                            

                              $select_query_main_1 = "select * from roi_tree where relation_ship_no LIKE '%{$relation_ship_no_main_network}%' AND tree_id > '$tree_id_main_network' AND x_position >= '$current_xposition_1' AND x_position <= '$current_xposition_2' AND rank > '0'";

                              $run_main_1 = mysqli_query($con,$select_query_main_1);

                              $check_level_1 = mysqli_num_rows($run_main_1); 





                               









                             $total_network_bonus =$check_level_1*$leader_bonus;







                             mysqli_query($con,"insert into wallet_payout(date, leader_bonus, member_no, total_amount) values('$today_date', '$total_network_bonus', '$member_no', '$total_network_bonus')");



                             





                         

           

       

     }



     exit();

   

    

  ?>