.-.-.-.-.-

<?php
session_start();
include '../connection.php';
include '../function_lib.php';
require "../lib/PHPMailer-master/PHPMailerAutoload.php";

if(!isset($_SESSION['adminid']) && empty($_SESSION['adminid'])) { redirect('../admin/login.php');};

//echo "admin id ".$_SESSION['adminid']; die;
//$r_date = mysqli_fetch_object(mysqli_query($connection,"select date from request_date"))->date;
$c_date = date("Y-m-d");

//if($r_date <= $c_date){

//get donor list
    $result = mysqli_query($connection,"SELECT commit_id, uid, amount, amount_2, package, datetime FROM commit WHERE confirm_status=0 AND lock_status=0 AND assign_complite=0 AND amount_2 > 0 AND is_cancel='0'");
    if(mysqli_num_rows($result)>0){
        
        // loop donor or giver list
        while($row = mysqli_fetch_object($result)){
            $commit_id = $row->commit_id;
            $amount = $row->amount_2; //donation amount
           $donor_refer_id = mysqli_fetch_object(mysqli_query($connection,"SELECT refer_id FROM user WHERE uid='".$row->uid."'"))->refer_id;

//$donor = mysqli_fetch_object(mysqli_query($connection,"SELECT country, solid_trust_pay, paypal, perfect_money, payza, ego_pay, ok_pay FROM user WHERE uid='$row->uid'"));
            
            // get receiver list
           $request_amount_sql = "SELECT * FROM request_amount WHERE balance>0 AND uid!='".$row->uid."' AND lock_status=0 AND type=0 AND is_cancel='0' AND uid NOT IN (100, 101, 102, 103, 104, 105) ORDER BY type DESC, datetime ASC";
           //echo $request_amount_sql;
           $request_rs = mysqli_query($connection,$request_amount_sql);
            
            if(mysqli_num_rows($request_rs)){
                $request_id_array = array();
                
                // loop receiver list and add receiver to array
                while($request_row = mysqli_fetch_object($request_rs)){
                    $request_id_array[] = $request_row->recid;
                    /*$receiver = mysqli_fetch_object(mysqli_query($connection,"SELECT country, solid_trust_pay, paypal, perfect_money, payza, ego_pay, ok_pay FROM user WHERE uid='$request_row->uid'"));
                    
                    if($donor->country==$receiver->country){
                        $request_id_array[] = $request_row->recid;
                    }
                    elseif($donor->solid_trust_pay!='' && $receiver->solid_trust_pay!=''){
                        $request_id_array[] = $request_row->recid;
                    }
                    elseif($donor->paypal!='' && $receiver->paypal!=''){
                        $request_id_array[] = $request_row->recid;
                    }
                    elseif($donor->perfect_money!='' && $receiver->perfect_money!=''){
                        $request_id_array[] = $request_row->recid;
                    }
                    elseif($donor->payza!='' && $receiver->payza!=''){
                        $request_id_array[] = $request_row->recid;
                    }
                    elseif($donor->ego_pay!='' && $receiver->ego_pay!=''){
                        $request_id_array[] = $request_row->recid;
                    }
                    elseif($donor->ok_pay!='' && $receiver->ok_pay!=''){
                        $request_id_array[] = $request_row->recid;
                    }
                    */
                }
                
                $request_id = implode(", ", $request_id_array);
                if(!$request_id){
                    $request_id = 0;
                }
                
                // sum all receiver list request amount
                $resultSum = mysqli_query($connection,"SELECT SUM(balance) as request_amount FROM request_amount WHERE recid IN ($request_id)");

if(mysqli_num_rows($resultSum)>0){
                    $rowSum = mysqli_fetch_object($resultSum);
                    $bank_result = mysqli_query($connection,"SELECT recid FROM `bank_details` WHERE uid='$row->uid' ORDER BY recid ASC LIMIT 1");
                    $give_bank_id = mysqli_num_rows($bank_result)==1?mysqli_fetch_object($bank_result)->recid:0; 
        
                    
                    // if sum of request amount is greater than commit amount
                    if($rowSum->request_amount>$amount){
                        $receiver_ids = get_receiver_ids_new($amount,$request_id, $donor_refer_id);
                        $amount2 = $amount;

mysqli_query($connection,"UPDATE commit SET amount_2=amount_2-$amount2 WHERE commit_id='".$commit_id."'");

foreach ($receiver_ids as $key => $value) {
                            $row2 = mysqli_fetch_object(mysqli_query($connection,"SELECT uid, balance, bank_id FROM request_amount WHERE recid='".$value."'"));
                            if($row2->balance<=$amount2){$amount3 = $row2->balance;}else{$amount3 = $amount2;}
                            $amount2 = $amount2 - $row2->balance;

mysqli_query($connection,"INSERT INTO `help` (`commit_id`, `give_uid`, `r_request_id`, `receive_uid`, `amount`, `datetime`, `give_bank_id`, `receive_bank_id`) VALUES"
                                    . " ('" .$commit_id ."','".$row->uid."','".$value."','".$row2->uid."','".$amount3."','".date('Y-m-d H:i:s')."','".$give_bank_id."','".$row2->bank_id."')");

mysqli_query($connection,"UPDATE request_amount SET balance=balance-$amount3 WHERE recid='".$value."'");
                            send_sms_email_link($row->uid, $row2->uid, $amount3);
                        }
                    }
                    elseif($rowSum->request_amount>=0){
                        $amount = $rowSum->request_amount;
                        $receiver_ids = get_receiver_ids_new($amount,$request_id, $donor_refer_id);
                        $amount2 = $amount;

mysqli_query($connection,"UPDATE commit SET amount_2=amount_2-$amount2 WHERE commit_id='".$commit_id."'");

foreach ($receiver_ids as $key => $value) {

$row2 = mysqli_fetch_object(mysqli_query($connection,"SELECT uid, balance, bank_id FROM request_amount WHERE recid='".$value."'"));
                            if($row2->balance<=$amount2){$amount3 = $row2->balance;}else{$amount3 = $amount2;}
                            $amount2 = $amount2-$row2->balance;

mysqli_query($connection,"UPDATE request_amount SET balance=balance-$amount3 WHERE recid='".$value."'");
                            send_sms_email_link($row->uid, $row2->uid, $amount3);
                        }
                    }
                }
                
            }
        }
    }
//}
//echo 'success';
setMessage('Submitted successfully.', 'alert-success');
//        redirect('../admin/cron_request_view.php');
?>

/home2/wtmwscom/public_html/css/../member/cron_request.php