.-.-.-.-.-

<?php
include "../connection.php";
include "../function_lib.php";
$commit_id = $_GET['q'];
$result = mysqli_query($connection,"SELECT commit_id, uid, amount, datetime FROM commit WHERE commit_id='$commit_id' AND confirm_status=0 AND lock_status=0 AND assign_complite=0 AND amount_2>0");
?>
<option value="" selected="selected" disabled="disabled">-- Select Receiver --</option>
<?php
if(mysqli_num_rows($result)>0){
    $row = mysqli_fetch_object($result);
    $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'"));
    
    $request_rs = mysqli_query($connection,"SELECT * FROM request_amount WHERE balance>0 AND uid!='".$row->uid."' AND lock_status=0 AND type=0 ORDER BY type DESC, datetime ASC");
    if(mysqli_num_rows($request_rs)){
        $request_id_array = array();
        while($request_row = mysqli_fetch_object($request_rs)){
            $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'"));
            $request_id_array[] = $request_row->recid;
            /*
            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);

$receiver_result = mysqli_query($connection,"SELECT recid, balance, uid FROM request_amount WHERE recid IN ($request_id) ORDER BY type DESC, datetime ASC");
        while ($receiver_row = mysqli_fetch_object($receiver_result)){
            $user = get_user_detail($receiver_row->uid);
        ?>
            <option value="<?php echo $receiver_row->recid?>"><?php echo "Request Id: ".$receiver_row->recid.", ".$user->name." (".$user->login_id."), Balance-$receiver_row->balance"?></option>
        <?php 
        }
    }
        
}
else{?>
    <option value="">-- Receiver not available --</option>
<?php 
}
?>

/home2/wtmwscom/public_html/./admin/get_receiver.php