.-.-.-.-.-

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

$start_date = date('2018-09-18');
$no_of_days=1;
$start_date_obj = new DateTime($start_date);
 $end_date = '2018-11-15'; 
while(true){
 $start_date_obj->modify("+ 1 day");
 
 $date = $start_date_obj->format('Y-m-d');
 $datetime = $date." 23:59:59";
 
 //code goes here begin
$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);
}
 
 
 
 //code ends here

$no_of_days++;
if($date == $end_date){
    break;
}
}
echo "no of days =====================".$no_of_days;

/* 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 < 30 ){
 
 //$current_pair_counter++;
 //if( (($total_binary_pair + $current_pair_counter) == 3) && (($total_binary_pair + $current_pair_counter) == 5) && (($total_binary_pair + $current_pair_counter) == 8) && (($total_binary_pair + $current_pair_counter) == 10) && (($total_binary_pair + $current_pair_counter) == 12) ){
 //$amount = 0;
 //} else { 
 $amount = 100;
 //$income_on_income_amount = $amount * 0.10;
 if($is_paid == 1){
 $sql_income = "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$uid', '$amount', '2', '" . $datetime . "')";
 echo "type 1 $sql_income ";
 mysqli_query($connection, $sql_income);
 // 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;
 }
 
 }
 }
 echo "while counter = $i ";
 $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){
 $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 = 100;
 //$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){
 $sql_income = "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$uid', '$amount', '2', '" . $datetime . "')";
 echo "type 0 $sql_income ";
 
 mysqli_query($connection, $sql_income);
 // income on income
 //mysqli_query($connection, "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$refer_id', '$amount', '5', '" . $datetime . "')");
 }
 }
}
echo " Closing complete. Please close this browser.";

/home2/wtmwscom/public_html/cgi-bin/../admin/cronjob/demo.php