<?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_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');



          $select_query_main_payment_date = "select * from week_payout where member_no='$member_no' AND date='$today_date'";

          $run_main_payment_date = mysqli_query($con,$select_query_main_payment_date);

          $sponser_count_payment_date = mysqli_num_rows($run_main_payment_date);



          if ($sponser_count_payment_date == 0) {



            













        //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 ($booster > 0) {





                      switch ($booster) {

                        case '1':

                           //booster bonus



                            $select_query_growth_1 = "select * from member where booster = '1'";

                            $run_growth_1 = mysqli_query($con,$select_query_growth_1);

                            $check_level_growth_1 = mysqli_num_rows($run_growth_1);



                            $processing_amount_manager=2;

                            $percentin_tds_manager = $processing_amount_manager / 100;       

                           //Get the result.

                            $final_processing_amount_manager = $percentin_tds_manager * $total_last_month_sales;





                            $manager_bonus =$final_processing_amount_manager/$check_level_growth_1;



                           //booster bonus

                          break;



                          case '2':

                           //booster bonus



                            $select_query_growth_1 = "select * from member where booster = '2'";

                            $run_growth_1 = mysqli_query($con,$select_query_growth_1);

                            $check_level_growth_1 = mysqli_num_rows($run_growth_1);



                            $processing_amount_manager=2;

                            $percentin_tds_manager = $processing_amount_manager / 100;       

                           //Get the result.

                            $final_processing_amount_manager = $percentin_tds_manager * $total_last_month_sales;





                            $manager_bonus =$final_processing_amount_manager/$check_level_growth_1;



                           //booster bonus

                          break;



                          case '3':

                           //booster bonus



                            $select_query_growth_1 = "select * from member where booster = '3'";

                            $run_growth_1 = mysqli_query($con,$select_query_growth_1);

                            $check_level_growth_1 = mysqli_num_rows($run_growth_1);



                            $processing_amount_manager=3;

                            $percentin_tds_manager = $processing_amount_manager / 100;       

                           //Get the result.

                            $final_processing_amount_manager = $percentin_tds_manager * $total_last_month_sales;





                            $manager_bonus =$final_processing_amount_manager/$check_level_growth_1;



                           //booster bonus

                          break;



                          case '4':

                           //booster bonus



                            $select_query_growth_1 = "select * from member where booster = '4'";

                            $run_growth_1 = mysqli_query($con,$select_query_growth_1);

                            $check_level_growth_1 = mysqli_num_rows($run_growth_1);



                            $processing_amount_manager=5;

                            $percentin_tds_manager = $processing_amount_manager / 100;       

                           //Get the result.

                            $final_processing_amount_manager = $percentin_tds_manager * $total_last_month_sales;





                            $manager_bonus =$final_processing_amount_manager/$check_level_growth_1;



                           //booster bonus

                          break;

                        

                        default:

                          # code...

                          break;

                      }



                    }

                  else {

                    $manager_bonus =0;

                    

                  }





                  if ($rank >= 1) {



                      $select_query_total_car_bonus = "select SUM(cp) from member where cp > '0' AND rank >= '1'";

                      $run_total_car_bonus = mysqli_query($con,$select_query_total_car_bonus);

                      while($row_total_car_bonus = mysqli_fetch_array($run_total_car_bonus)){

                            $total_car_bonus = $row_total_car_bonus['SUM(cp)'];

                            

                      }





                      $processing_amount_car_bonus=4;

                      $percentin_tds_car_bonus = $processing_amount_car_bonus / 100;       

                     //Get the result.

                      $final_processing_amount_car_bonus = $percentin_tds_car_bonus * $total_last_month_sales;





                      $car_bonus_1 =$final_processing_amount_car_bonus/$total_car_bonus;



                      $car_bonus =$car_bonus_1*$cp;







                      $select_query_total_house_bonus = "select SUM(hp) from member where hp > '0' AND rank >= '1'";

                      $run_total_house_bonus = mysqli_query($con,$select_query_total_house_bonus);

                      while($row_total_house_bonus = mysqli_fetch_array($run_total_house_bonus)){

                            $total_house_bonus = $row_total_house_bonus['SUM(hp)'];

                            

                      }





                      $processing_amount_house_bonus=4;

                      $percentin_tds_house_bonus = $processing_amount_house_bonus / 100;       

                     //Get the result.

                      $final_processing_amount_house_bonus = $percentin_tds_house_bonus * $total_last_month_sales;





                      $house_bonus_1 =$final_processing_amount_house_bonus/$total_house_bonus;



                      $house_bonus =$house_bonus_1*$hp;

                    

                  }

                  else {

                    $car_bonus =0;

                    $house_bonus =0;



                  }







          // get manager amount



                  // trib bonus



                           if ($rank >= 1) {



                          $select_query_growth_2 = "select * from member where rank >= '1'";

                          $run_growth_2 = mysqli_query($con,$select_query_growth_2);

                          $check_level_growth_2 = mysqli_num_rows($run_growth_2);



                                $processing_amount_tour=3;

                                $percentin_tds_tour = $processing_amount_tour / 100;       

                               //Get the result.

                                $final_processing_amount_tour = $percentin_tds_tour * $total_last_month_sales;





                                $tour_bonus =$final_processing_amount_tour/$check_level_growth_2;





                                





                           

                                }

                        else {

                          $tour_bonus =0;

                          

                        }



                        // growth bonus



                           if ($gp > 0) {



                                $select_query_total_point_grouth_1 = "select SUM(gp) from member where gp > '0'";

                                $run_total_point_grouth_1 = mysqli_query($con,$select_query_total_point_grouth_1);

                                while($row_total_point_grouth_1 = mysqli_fetch_array($run_total_point_grouth_1)){

                                      $total_point_grouth_1 = $row_total_point_grouth_1['SUM(gp)'];

                                      

                                } 



                                $processing_amount_growth=5;

                                $percentin_tds_growth = $processing_amount_growth / 100;       

                               //Get the result.

                                $final_processing_amount_growth = $percentin_tds_growth * $total_last_month_sales;





                                $growth_bonus_1a =$final_processing_amount_growth/$total_point_grouth_1;





                                $growth_bonus =$growth_bonus_1a*$gp;





                           

                                }

                                else {

                                  $growth_bonus =0;

                                }



                          //growth bonus



                         



                  //trib bonus





                        // leader bonus



                   // if ($rank >= 2) {



                   //      $select_query_total_point_1 = "select SUM(lp) from member where rank >= '2'";

                   //      $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*$lp;





                   

                   //      }

                   //      else {

                   //        $leader_bonus =0;

                   //      }



                                $leader_bonus =0;



                  //leader bonus





                        //ups



                          $select_query_direct_user_get_id = "select * from commitee where member_no = '$member_no' AND status='1'";

                           $run_direct_user_get_id = mysqli_query($con,$select_query_direct_user_get_id);



                           $user_direct_level_user_spons = mysqli_num_rows($run_direct_user_get_id);



                             if ($user_direct_level_user_spons > 0) {



                                  while ($row_direct_user_get_id = mysqli_fetch_array($run_direct_user_get_id)) {

                            

                                    $point_commitee = $row_direct_user_get_id['point'];

                                    }



                                    $select_query_total_comitee_1 = "select SUM(point) from commitee where status='1'";

                                    $run_total_comitee_1 = mysqli_query($con,$select_query_total_comitee_1);

                                    while($row_total_comitee_1 = mysqli_fetch_array($run_total_comitee_1)){

                                          $total_comitee_1 = $row_total_comitee_1['SUM(point)'];

                                          

                                    }





                                    $processing_amount_commitee=9;

                                    $percentin_tds_commitee = $processing_amount_commitee / 100;       

                                   //Get the result.

                                    $final_processing_amount_commitee = $percentin_tds_commitee * $total_last_month_sales;





                                    $ups_bonus_1a =$final_processing_amount_commitee/$total_comitee_1;





                                    $ups_bonus =$ups_bonus_1a*$point_commitee; 





                                   

                              }

                              else {

                                $ups_bonus =0; 



                              }



                             



                          //ups



                        //perfomance_bonus



                         $select_query_total_team_pv_pro = "select SUM(binary_income), SUM(roi_income), SUM(manager_bonus), SUM(ups_bonus), SUM(leader_bonus), SUM(growth_bonus), SUM(car_bonus), SUM(house_bonus) from wallet_payout where member_no = '$member_no' AND status='0'";

                          $run_total_team_pv_pro = mysqli_query($con,$select_query_total_team_pv_pro);

                          while($row_total_team_pv_pro = mysqli_fetch_array($run_total_team_pv_pro)){ 



                                $total_performance_bonus = $row_total_team_pv_pro['SUM(binary_income)']; 

                                

                                $total_personal_bv = $row_total_team_pv_pro['SUM(roi_income)'];

                                $total_personal_manager_bonus = $row_total_team_pv_pro['SUM(manager_bonus)'];

                                $total_personal_ups_bonus = $row_total_team_pv_pro['SUM(ups_bonus)'];

                                $total_personal_leader_bonus = $row_total_team_pv_pro['SUM(leader_bonus)'];



                                $total_personal_growth_bonus = $row_total_team_pv_pro['SUM(growth_bonus)'];

                                $total_personal_car_bonus = $row_total_team_pv_pro['SUM(car_bonus)'];

                                $total_personal_house_bonus = $row_total_team_pv_pro['SUM(house_bonus)'];

                                

                          }



                          $select_query_total_current_month = "select SUM(roi_income) from wallet_payout where member_no = '$member_no' AND date='$today_date'";

                          $run_total_current_month = mysqli_query($con,$select_query_total_current_month);

                          while($row_total_current_month = mysqli_fetch_array($run_total_current_month)){

                                

                                $total_personal_bv_this = $row_total_current_month['SUM(roi_income)']; 

                                

                          }



                          $select_query_voucher_balance = "select SUM(amount) from cart_balance where member_no = '$member_no'";

                          $run_voucher_balance = mysqli_query($con,$select_query_voucher_balance);

                          while($row_voucher_balance = mysqli_fetch_array($run_voucher_balance)){ 



                                $total_voucher_balance = $row_voucher_balance['SUM(amount)']+0; 

                                

                          }



                        //performance_bonus



                          $total_final_amount = $total_performance_bonus+$leader_bonus+$growth_bonus+$ups_bonus+$manager_bonus+$total_personal_manager_bonus+$total_personal_ups_bonus+$total_personal_leader_bonus+$total_personal_growth_bonus+$total_personal_car_bonus+$total_personal_house_bonus+$car_bonus+$house_bonus+$total_voucher_balance;



                           $total_bonus_amount = $leader_bonus+$growth_bonus+$ups_bonus+$manager_bonus+$car_bonus+$house_bonus;





                           $manager_bonus_1 = $manager_bonus+$total_personal_manager_bonus;

                           $ups_bonus_1 = $ups_bonus+$total_personal_ups_bonus;

                           $growth_bonus_1 = $growth_bonus+$total_personal_growth_bonus;

                           $leader_bonus_1 = $leader_bonus+$total_personal_leader_bonus;

                           $car_bonus_1 = $car_bonus+$total_personal_car_bonus;

                           $house_bonus_1 = $house_bonus+$total_personal_house_bonus;



                          //get_total_previous



                          $select_query_total_total_old = "select SUM(total_amount) from week_payout where member_no = '$member_no'";

                          $run_total_total_old = mysqli_query($con,$select_query_total_total_old);

                          while($row_total_total_old = mysqli_fetch_array($run_total_total_old)){

                                $total_total_old = $row_total_total_old['SUM(total_amount)'];

                                 

                                

                          }



                          $total_old_payout = $total_total_old+$total_final_amount;



                          //get_total_previous





                          if ($total_personal_bv_this >= 20 && $total_final_amount >= 500) {



                                if ($total_old_payout >= 5000) {

                                   $processing_amount_old = 0;

                                }

                                else {

                                  $processing_amount_old = 0;

                                } 



                                $percentin_tds_final = $processing_amount_old / 100;       

                               //Get the result.

                                $final_processing_amount_final = $percentin_tds_final * $total_final_amount;





                                $net_payment = $total_final_amount-$final_processing_amount_final;





                                  mysqli_query($con,"insert into week_payout(date, binary_income, roi_income, manager_bonus, ups_bonus, leader_bonus, growth_bonus, total_amount, processing_amount, net_payment, member_no, car_bonus, house_bonus, voucher) values('$today_date', '$total_performance_bonus', '$total_personal_bv_this', '$manager_bonus_1', '$ups_bonus_1', '$leader_bonus_1', '$growth_bonus_1', '$total_final_amount', '$final_processing_amount_final', '$net_payment', '$member_no', '$car_bonus_1', '$house_bonus_1', '$total_voucher_balance')");





                                   if ($tour_bonus > 0) {





                                      $processing_amount_old_t = 5;



                                      $percentin_tds_final_t = $processing_amount_old_t / 100;       

                                     //Get the result.

                                      $final_processi_tour = $percentin_tds_final_t * $tour_bonus;





                                      $net_payment_tour = $tour_bonus-$final_processi_tour;



                                       mysqli_query($con,"insert into tour_bonus(member_no, date, amount, rank, tds, netpay) values('$member_no', '$today_date', '$tour_bonus', '$rank', '$final_processi_tour', '$net_payment_tour')");

                                     }



                                     if ($total_voucher_balance > 0) {

                                       mysqli_query($con,"delete from cart_balance where member_no = '$member_no'");

                                     }



                                     





                                  mysqli_query($con,"update wallet_payout set status='1' where member_no = '$member_no' AND status='0'");



                          }

                          else {





                              if ($total_bonus_amount > 0) {

                                  

                                  $total_final_amountss = $total_final_amount-$total_performance_bonus;



                                 mysqli_query($con,"insert into wallet_payout(date, manager_bonus, ups_bonus, leader_bonus, growth_bonus, member_no, car_bonus, house_bonus, total_amount) values('$today_date', '$manager_bonus', '$ups_bonus', '$leader_bonus', '$growth_bonus', '$member_no', '$car_bonus', '$house_bonus', '$total_final_amountss')");





                                 if ($tour_bonus > 0) {

                                   mysqli_query($con,"insert into tour_bonus(member_no, date, amount, rank) values('$member_no', '$today_date', '$tour_bonus', '$rank')");

                                 }



                                 

                                 

                              }







                          }

        

         

         



           

       }

     }

   

    

  ?>