.-.-.-.-.-

<?php
include '../../connection.php';
include '../../function_lib.php';

$date =     "2018-11-15";
 $datetime = $date." 23:59:59";

//$datetime = date('Y-m-d H:i:s');

//$datetime = "2016-01-07 23:00:00";

$hour_now = date("H", strtotime($datetime));
//if($hour_now == 6 || $hour_now == 14 || $hour_now == 22){}
    if($hour_now >= 00 && $hour_now <= 06){
        $closing_type = 1 ;
    }
    elseif($hour_now > 06 && $hour_now <= 12){
        $closing_type = 2;
    }
    elseif($hour_now > 12 && $hour_now <= 18){
        $closing_type = 3;
    }
    elseif($hour_now > 18 && $hour_now <= 23){
        $closing_type = 4;
    }
    else{
        $closing_type = 0;
    }
    //$closing_type = 0;
$result = mysqli_query($connection, "SELECT uid, refer_id, type, is_paid FROM user WHERE reg_date <= '$datetime' ORDER BY recid ASC ");    
while($row = mysqli_fetch_object($result)) {
    $uid = $row->uid;
    $type = $row->type;
    $refer_id = $row->refer_id;
    $is_paid = $row->is_paid;
    calculation($uid, $type, $closing_type, $datetime, $refer_id, $is_paid);
}

/* For 1:1 pair this function is used */
function calculate_binary_2($commission_ids_left, $commission_ids_right, $uid, $closing_type, $datetime, $refer_id, $is_paid) {
    
    /* for applying capping at daily, weekly and monthly basis */
    $date = date("Y-m-d", strtotime($datetime));
    $daily_pair = mysqli_num_rows(mysqli_query($connection, "SELECT uid FROM binary_income WHERE uid = '$uid' AND date(datetime) = '".$date."' AND closing_type = '$closing_type' ")); // daily pair
    $total_binary_pair = mysqli_num_rows(mysqli_query($connection, "SELECT uid FROM binary_income WHERE uid = '$uid' "));
    //$week_date = date("Y-m-d", strtotime('-1 week', strtotime(date('Y-m-d H:i:s'))));
    //$weekly_pair = mysqli_num_rows(mysqli_query($connection, "SELECT uid FROM binary_income WHERE uid = '$uid' AND datetime BETWEEN '$week_date' AND '$date'")); // weekly pair

//$month_date = date("Y-m-d", strtotime('-1 month', strtotime(date('Y-m-d H:i:s'))));
    //$monthly_pair = mysqli_num_rows(mysqli_query($connection, "SELECT uid FROM binary_income WHERE uid = '$uid' AND datetime BETWEEN '$month_date' AND '$date'")); // monthly pair

$n_of_i_left = count($commission_ids_left);
    $n_of_i_right = count($commission_ids_right);
    
    if ($n_of_i_left <= $n_of_i_right) {
        $j = $n_of_i_left;
    } elseif ($n_of_i_left > $n_of_i_right) {
        $j = $n_of_i_right;
    }

$i = 0;
    $current_pair_counter = 0;
    while ($i <= $j) {
        
        if (isset($commission_ids_left[$i])) {
            $uid1 = $commission_ids_left[$i];

if (isset($commission_ids_right[$i])) {
                $uid2 = $commission_ids_right[$i];
                
                if($daily_pair < 4 ){
                    $current_pair_counter++;
                     if( ($total_binary_pair + $current_pair_counter) % 3 == 0){
                        $amount = 0;
                    } else {
                        $amount = 500;
                        //$income_on_income_amount = $amount * 0.10;
                        if($is_paid == 1){
                           mysqli_query($connection, "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$uid', '$amount', '2', '" . $datetime . "')");
                           // income on income to sponser
                           //mysqli_query($connection, "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$refer_id', '$amount', '5', '" . $datetime . "')"); 
                        }
                    }
                    mysqli_query($connection, "INSERT INTO binary_income (uid, amount, datetime, closing_type) VALUES ('$uid', $amount, '".$datetime."', '$closing_type' )");
                    mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid1."', '".$datetime."')");
                    mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid2."', '".$datetime."')");
                    //mysqli_query($connection, "UPDATE user SET wallet = wallet + 250 WHERE uid = '$uid' ");
                    $daily_pair++;
                } else {
                    mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '" . $uid1 . "', '" . $datetime . "')");
                    mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '" . $uid2 . "', '" . $datetime . "')");
                   // break;
                }
                
            }
        }
        $i++;
    }
     $daily_pair = 0;
}

/* For 2:1 or 1:2 pair this function is used, means first time calculation */
function calculate_binary($commission_ids_left, $commission_ids_right, $uid, $closing_type, $datetime, $refer_id, $is_paid) {
    $n_of_i_left = count($commission_ids_left);
    $n_of_i_right = count($commission_ids_right);
    
    //if($n_of_i_left>1 || $n_of_i_right>1){
    if($n_of_i_left != 0 && $n_of_i_right != 0){
        $uid1 = $commission_ids_left[0];
        $uid2 = $commission_ids_right[0];
        /*if($n_of_i_left>1){
            $uid3 = $commission_ids_left[1];
        }
        else{
            $uid3 = $commission_ids_right[1];
        } */
        $amount = 500;
        //$income_on_income_amount = $amount * 0.10;
        mysqli_query($connection, "INSERT INTO binary_income (uid, amount, datetime, closing_type) VALUES ('$uid', '$amount', '".$datetime."', '$closing_type' )");
        mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid1."', '".$datetime."')");
        mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid2."', '".$datetime."')");
        //mysqli_query($connection, "INSERT INTO binary_done (uid, from_uid, datetime) VALUES ('$uid', '".$uid3."', '".$datetime."')");
        mysqli_query($connection, "UPDATE user SET type = '1', type_update_datetime='" . $datetime . "', board_type = '1' WHERE uid = '$uid' ");
      //  add_user_to_board($uid, 1, $datetime);
        if($is_paid==1){
            mysqli_query($connection, "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$uid', '$amount', '2', '" . $datetime . "')");
            // income on income
            //mysqli_query($connection, "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$refer_id', '$amount', '5', '" . $datetime . "')");
        }
    }
}
echo "<br/> Closing complete. Please close this browser.";
?>

/home2/wtmwscom/public_html/admin/images/../cronjob/cron_pair_income.php