<?php 

session_start();

 include("includes/database.php");



   $today_date = "2024-09-01";

  

    $select_query_payment = "select * from week_payout where date='$today_date' ORDER BY payout_id ASC";

                               $run_payment = mysqli_query($con,$select_query_payment); 

                               while ($row_payment = mysqli_fetch_array($run_payment)) { 

                                $payout_id = $row_payment['payout_id'];

                                $date = $row_payment['date'];

                                $binary_income = $row_payment['binary_income'];

                                $manager_bonus = $row_payment['manager_bonus'];

                                $ups_bonus = $row_payment['ups_bonus'];

                                $tds = $row_payment['tds'];





                                $total_amount = $binary_income+$manager_bonus+$ups_bonus;







                                mysqli_query($con,"update week_payout set total_amount='$total_amount', net_payment='$total_amount' where payout_id='$payout_id'");







                           

        

         

         



           

        

     }

   

    

  ?>