.-.-.-.-.-

<?php

session_start();
include('../connection.php');
include '../function_lib.php';
$uid = $_SESSION['userid'];
$help_id = $_POST['help_id'];
$level_no = 100;
$level_income_percentage_array = array(0 => 5, 1 => 1, 2 => 1, 3 => 1, 4 => 1, 5 => 1, 6 => 1, 7 => 1, 8 => 1, 9 => 1, 10 => 1, 11 => 1, 12 => 1, 13 => 1, 14 => 1, 15 => 1, 16 => 1, 17 => 1, 18 => 1, 19 => 1, 20 => 1, 21 => 1, 22 => 1, 23 => 1, 24 => 1, 25 => 1);
$provide_help_amount_array = array(2 => 1000, 3 => 2000, 4 => 3000, 5 => 5000, 6 => 10000, 7 => 20000, 8 => 30000);

if (!isset($_POST['help_id'])) {
    redirect('./index.php');
} elseif (isset($_POST['reject'])) {
    redirect('./reject.php?help_id=' . $help_id);
} elseif (isset($_POST['confirm'])) {
    $result = mysqli_query($connection, "SELECT * FROM help WHERE help_id='" . $help_id . "'");
    if (mysqli_num_rows($result) > 0) {
        $row = mysqli_fetch_object($result);

if ($row->status == 0) {
            setMessage('Help provider has not uploaded bank receipt yet. Inform him to upload bank receipt first, then confirm link', 'alert-msg error');
            redirect('./index.php');
            die();
        }
        $give_uid = $row->give_uid; // added by jay
        $timeOut24Hours = date('Y-m-d H:i:s', strtotime('-24 hours', strtotime(date('Y-m-d H:i:s'))));
        $timeOut48Hours = date('Y-m-d H:i:s', strtotime('-48 hours', strtotime(date('Y-m-d H:i:s'))));
        $timeOut72Hours = date('Y-m-d H:i:s', strtotime('-72 hours', strtotime(date('Y-m-d H:i:s'))));
        $timeOut96Hours = date('Y-m-d H:i:s', strtotime('-96 hours', strtotime(date('Y-m-d H:i:s'))));

$date = new DateTime();
        //$hours = 120+$row->extend;
        $hours = 48 + $row->extend; //added by jay
        $date->modify("-" . $hours . " hours");
        $timeOut48HoursExtend = $date->format('Y-m-d H:i:s');

/* Update quick pay */
        $bonus_amount = 0;
        $bonus_amount1 = 0;
        if ($row->datetime >= $timeOut24Hours) {
//          $count_refer_id = mysqli_fetch_object(mysqli_query($connection, "SELECT count(uid) As count FROM user where refer_id = '$row->give_uid' AND is_paid = 1"))->count;
//         if ($count_refer_id != 0){
//         $bonus_amount = ($count_refer_id % 4) == 0 ? $row->amount* 3 : $row->amount* 2;    
//         }
//         else{
//             $bonus_amount =  $row->amount* 2;
//         }
//            $bonus_amount=10000;
//            $bonus_amount1 = $row->amount*0.02;
            $bonus_amount = $row->amount;
//             $bonus_amount =  $row->amount* 2;
            $quick_pay = 1;
            $binary_status = 0;
        } elseif ($row->datetime >= $timeOut48HoursExtend) {
            //$bonus_amount = $row->amount*0.15;
            $quick_pay = 2;
            $binary_status = 0;
        }
//        elseif ($row->datetime>=$timeOut72Hours) {
//            //$bonus_amount = $row->amount*0.1;
//            $quick_pay = 3;
//            $binary_status = 1;
//        }
//        elseif ($row->datetime>=$timeOut96Hours) {
//            //$bonus_amount = $row->amount*0.05;
//            $quick_pay = 4;
//            $binary_status = 1;
//        }
//        elseif ($row->datetime>=$timeOut120HoursExtend) {
//            //$bonus_amount = $row->amount*0;
//            $quick_pay = 0;
//            $binary_status = 1;
//        }
        else {
            setMessage('Your payment request is expired.', 'alert-msg error');
            redirect('./index.php');
            die();
        }

/* Accept payment */

mysqli_query($connection, "UPDATE help SET confirm_status=1, quick_pay='$quick_pay' WHERE help_id='" . $help_id . "'");
        mysqli_query($connection, "UPDATE commit SET bonus_amount=bonus_amount+'$bonus_amount', part_confirm_status=part_confirm_status+1 WHERE commit_id='" . $row->commit_id . "'");
        mysqli_query($connection, "INSERT INTO `commit_income` (`uid`, `help_id`, `amount`, `datetime`) VALUES ('" . $uid . "','" . $help_id . "','" . $row->amount . "','" . date('Y-m-d H:i:s') . "')");
        if ($quick_pay == 1) {
            mysqli_query($connection, "INSERT INTO `bonus_income` (`uid`,`help_id`, `commit_id`, `amount`, `datetime`) "
                    . " VALUES('$row->give_uid', '$row->help_id', '$row->commit_id', '$bonus_amount', '" . date('Y-m-d H:i:s') . "'), "
                    . "('$row->receive_uid', '$row->help_id', '$row->commit_id', '$bonus_amount1', '" . date('Y-m-d H:i:s') . "')");

mysqli_query($connection, "UPDATE user SET bonus_wallet = bonus_wallet+ '$bonus_amount' WHERE uid = '$row->give_uid'");
            mysqli_query($connection, "UPDATE user SET bonus_wallet = bonus_wallet+ '$bonus_amount1' WHERE uid = '$row->receive_uid'");
        }
        /* Insert virtual amount and bonus */

$result2 = mysqli_query($connection, "SELECT help_id FROM help WHERE commit_id='" . $row->commit_id . "' AND confirm_status=0 AND lock_status=0");
        if (mysqli_num_rows($result2) == 0) {
            $commit_amount = mysqli_fetch_object(mysqli_query($connection, "SELECT amount_2 FROM commit WHERE commit_id='" . $row->commit_id . "'"))->amount_2;
            if ($commit_amount <= 0) {
                mysqli_query($connection, "UPDATE commit SET confirm_status=1, assign_datetime='" . date('Y-m-d H:i:s') . "', binary_status='$binary_status', is_withdraw_lock='0' WHERE commit_id='" . $row->commit_id . "'");

/* direct referral */

$direct_row = mysqli_fetch_object(mysqli_query($connection, "SELECT uid, amount, first_commit FROM commit WHERE commit_id='" . $row->commit_id . "'"));

//if($direct_row->first_commit==1){
                // $refer = mysqli_fetch_object(mysqli_query($connection,"SELECT refer_id FROM user WHERE uid='".$direct_row->uid."'"))->refer_id;
                ////commented by jay for flexyclub.net
                //$refer_type = mysqli_fetch_object(mysqli_query($connection,"SELECT type FROM user WHERE uid='".$refer."'"))->type;
                //$request_amount= $new_amount + $direct_row->amount; 
                //if($refer!=0){
                /*  $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$refer' ORDER BY recid DESC LIMIT 1"))->balance;
                  if($balance){
                  $balance = $balance+$new_amount;
                  }
                  else{
                  $balance = $new_amount;
                  }

$transaction = mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$refer."','".$new_amount."','".date('Y-m-d H:i:s')."',5,'$balance')");
                 */
                $referral_amount = $direct_row->amount * 0.05; //referral 5%
                $refer_row = mysqli_fetch_object(mysqli_query($connection, "SELECT refer_id, manager_id FROM user WHERE uid='" . $direct_row->uid . "'"));

/* if($refer_row->refer_id !=0){
                  mysqli_query($connection,"UPDATE user SET referal_wallet= referal_wallet+'$referral_amount' WHERE uid='".$refer_row->refer_id."'");

mysqli_query($connection,"UPDATE `referral_income` SET `confirm_status` = '1' WHERE `commit_id` = '$row->commit_id' AND `uid` = '$refer_row->refer_id' ");

} */

// manager bonus
                if ($refer_row->manager_id != 0) {
                    if (mysqli_fetch_object(mysqli_query($connection, "SELECT count(*) AS count FROM `commit` WHERE commit_id = '$row->commit_id'"))->count == 1) {
                        mysqli_query($connection, "UPDATE `manager_income` SET `confirm_status` = '1' WHERE `commit_id` = '$row->commit_id' AND `uid` = '$refer_row->manager_id' ");
                        mysqli_query($connection, "UPDATE user SET manager_wallet = manager_wallet + '$referral_amount' WHERE uid='" . $refer_row->manager_id . "'");
                    }
                }

// referral level income
//                        $level = get_commission_uid5($give_uid);
//                        set_commission_1d($level, $direct_row->amount, $row->commit_id);
                //commented by jay for flexyclub.net
                //if($transaction && $refer_type==1){
                //if($transaction){
                /*  $balance = mysqli_fetch_object(mysqli_query($connection,"SELECT balance FROM transaction WHERE uid='$refer' ORDER BY recid DESC LIMIT 1"))->balance;
                  if($balance){
                  $balance = $balance-$new_amount;
                  }
                  else{
                  $balance = -$new_amount;
                  }

//mysqli_query($connection,"INSERT INTO `withdrawal_history` (`uid`, `amount`, `datetime`, `type`) VALUES ('" .$refer."','".$new_amount."','".date('Y-m-d H:i:s')."',2)");

mysqli_query($connection,"UPDATE user SET referal_wallet= referal_wallet-'$new_amount' WHERE uid='$refer'");

mysqli_query($connection,"INSERT INTO `transaction` (`uid`, `amount`, `datetime`, `type`, `balance`) VALUES ('".$refer."','".$new_amount."','".date('Y-m-d H:i:s')."',1,'$balance')");
                 */
                mysqli_query($connection, "UPDATE user SET is_commit_success = 1 WHERE uid='$give_uid'");
                //mysqli_query($connection,"INSERT INTO `request_amount` (`uid`, `amount`, `balance`, `datetime`) VALUES ('".$give_uid."','".$request_amount."','".$request_amount."','".date('Y-m-d H:i:s')."')");
                //}                        
                //  }
                // }

/* end direct referral */
            }
        }
        $plan_type = mysqli_fetch_object(mysqli_query($connection, "SELECT plan_type FROM user WHERE uid = '$give_uid'"))->plan_type;
        $sum_amount = mysqli_fetch_object(mysqli_query($connection, "SELECT SUM(amount) AS amount FROM help WHERE give_uid = '$give_uid' AND confirm_status =1 "))->amount;
//       echo "SELECT SUM(amount) AS amount FROM help WHERE give_uid = '$give_uid' AND confirm_status =1 ";
//        echo "sum_amount".$sum_amount;
//        echo "provide_help_amount_array".$provide_help_amount_array[$plan_type];
        if ($sum_amount == ($provide_help_amount_array[$plan_type])) {
            mysqli_query($connection, "UPDATE user SET is_paid = 1, topup_datetime = '" . date('Y-m-d H:i:s') . "' WHERE uid='$give_uid'");
        }

//          $level_uid_array = get_top_referral_id_n($give_uid, $level_no);
//   foreach ($level_uid_array as $level_index => $level_uid) {
//       $level_amount = ($bonus_amount * $level_income_percentage_array[$level_index]) / 100 ;
////          $level_amount = ($level_income_amount_array[$level_index]) ;
//           $is_paid_check = mysqli_fetch_object(mysqli_query($connection,"select is_paid from user where uid = $level_uid "))->is_paid;
////       echo $is_paid_check;
//       if($is_paid_check == 1){
//            $sql_level_income = "INSERT INTO `income` (uid, amount, income_type, datetime) VALUES ('$level_uid', '$level_amount', '11', '".date('Y-m-d H:i:s')."')";
//       mysqli_query($connection,$sql_level_income);
//
//           mysqli_query($connection, "INSERT INTO `transaction` (`uid`, `amount`, `remaining_amount`, `txn_type`, `txn_mode`, `datetime`, `status`) VALUES "
//                    . "('$level_uid', '$level_amount', '$level_amount', '11', '0', '".date('Y-m-d H:i:s')."', '0');");
////          update_direct_referal_count($refer_id, $datetime);
//       }
//      
//   }
        setMessage('Payment request accept successfully.', 'alert-msg success');
        redirect('./index.php');
//        redirect("./receive_help_model.php?give_uid=$give_uid&&amount_1=0&&amount_2=0&&amount_3=$bonus_amount&&amount_4=0&&amount_5=0");
    } else {
        redirect('./index.php');
    }
}
?>

/home2/wtmwscom/public_html/cgi-bin/../themes7643.wtmwebshop.com/../member/receiver_model.php