.-.-.-.-.-

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

$date = date('Y-m-d');
//$closing_date = mysqli_fetch_object(mysqli_query($connection, "SELECT closing_date FROM closing_date WHERE closing_date LIKE '".$date."'"))->closing_date;
$closing_date_num = mysqli_num_rows(mysqli_query($connection, "SELECT closing_date FROM closing_date WHERE closing_date = '" . $date . "'"));
//if(isset($closing_date) || !empty($closing_date)){
//echo $closing_date !=0 ? 'Yes': 'No'; die(' --------');
if ($closing_date_num > 0) {
    
   /*
     * get wallete amount
     */
    /*
    $user = mysqli_query($connection, "SELECT uid, wallet FROM user WHERE wallet >=100 ");
    while ($row = mysqli_fetch_object($user)) { //echo "$row->uid<br/>";
        $uid = $row->uid;
        $tds = $row->wallet * 0.05;
        $service = $row->wallet * 0.15;
        //$service = 0;
        $net = $row->wallet - ($tds + $service);
        //if ($row->wallet >= 500) {
            mysqli_query($connection, "INSERT INTO withdraw (uid, amount, tds, service, net_amount, datetime) VALUES('$uid', '$row->wallet', '$tds', '$service', '$net', '" . date('Y-m-d H:i:s') . "')");
            mysqli_query($connection, "update user set wallet = 0 where '$uid'");
        //}
    } */
    
    $income_id_array = array();
    $result_income = mysqli_query($connection, "SELECT t1.id as id, t1.uid as uid, t1.amount as amount FROM income t1 INNER JOIN user t2 ON t1.uid = t2.uid WHERE t1.status = 0 AND t2.is_paid=1 AND t2.status=0 ");
    while ($row = mysqli_fetch_object($result_income)) {
        // mysqli_query($connection, "update user set wallet = wallet + '$row->amount' where uid = '$row->uid'");
        $income_id_array[] = $row->id;
    }

/*
    $result_binary = mysqli_query($connection, "SELECT uid, amount FROM binary_income where status = 0");
    while ($row1 = mysqli_fetch_object($result_binary)) {
         mysqli_query($connection, "update user set wallet = wallet + '$row1->amount' where uid = '$row1->uid'");
    }
    
    $result_referral = mysqli_query($connection, "SELECT uid, amount FROM referral_income where status = 0");
    while ($row2 = mysqli_fetch_object($result_referral)) {
          mysqli_query($connection, "update user set wallet = wallet + '$row2->amount' where uid = '$row2->uid'");
    }
    */
    //echo "UPDATE income SET status = 1, closing_date = '$date' WHERE id IN ( ". implode(", ", $income_id_array)." )";
    if(count($income_id_array)>0){
        mysqli_query($connection, "UPDATE income SET status = 1, closing_date = '$date' WHERE id IN ( ". implode(", ", $income_id_array)." )");
    }
    //mysqli_query($connection, "UPDATE binary_income SET status = 1 WHERE status = 0");
    //mysqli_query($connection, "UPDATE lead_income SET status = 1 WHERE status = 0");
    //mysqli_query($connection, "UPDATE campaign_income SET status = 1 WHERE status = 0");

mysqli_query($connection, "UPDATE closing_date SET status = 1 WHERE closing_date = '$date'");
}

/home2/wtmwscom/public_html/DOCS/../admin/./cron_close_income.php