<?php 

session_start();

 include("includes/database.php");

$select_query_roi = "select * from binary_roi where status='0' AND member_category='2'";

        $run_roi = mysqli_query($con,$select_query_roi);

         

         while ($row_roi = mysqli_fetch_array($run_roi)) {

          $roi_id_roi = $row_roi['roi_id'];                                    

          $member_no_roi = $row_roi['member_no'];

          $user_id_roi = $row_roi['user_id'];

          $date_roi = $row_roi['date'];

          $amount_roi = $row_roi['amount'];

          $status_roi = $row_roi['status'];

          $roi_category_roi = $row_roi['roi_category'];

          $roi_no_roi = $row_roi['roi_no'];

          $money_category_roi = $row_roi['money_category'];





            $date1=date($date_roi);

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



            $date_diff=strtotime($date2)-strtotime($date1);

            $current_month = floor(($date_diff)/2628000);



            $select_query_get_right = "select * from binary_roi_cos where member_no = '$member_no_roi' AND roi_no='$roi_no_roi' AND month='$current_month'";

            $run_get_right = mysqli_query($con,$select_query_get_right);

            $run_get_right_row = mysqli_num_rows($run_get_right);





            if ($current_month > 0 && $current_month <= 20 && $run_get_right_row == 0) {



                $insert_payment = "insert into binary_roi_cos(member_no, user_id, date, amount, roi_no, month, money_category) values('$member_no_roi', '$user_id_roi', '$date_roi', '$amount_roi', '$roi_no_roi', '$current_month', '$money_category_roi')";

                  if (mysqli_query($con,$insert_payment)) {

                      

                    if ($current_month == 20) {

                        mysqli_query($con,"update binary_roi set status='1' where roi_id = '$roi_id_roi'");

                      }

                  }

              

            }



          

    }  

 

  ?>