query("select id,user_id from tbl_order where id='$refund_order_id'");
$num=$obj->numRows($result);
if($num>0){ }else{ $_SESSION['sess_msg']="Order Id : $refund_order_id not found.!"; }
}else{ $_SESSION['sess_msg']="Order Id : $refund_order_id is from a guest user. It can be refund by Payment Gateway Panel.!"; }
}
if($_REQUEST['refundtouser']=='Refund'){
$orderid=mysqli_real_escape_string($GLOBALS['conn'],$_REQUEST['orderid']);
$storeamount=$_REQUEST['storeamount'];
$storeamountid=$obj->query("select distinct storeid from tbl_order_itmes where order_id='$orderid' order by storeid asc");
$storeidarr=array();
while($resstoreamount=$obj->fetchNextObject($storeamountid)){
$storeidarr[]=$resstoreamount->storeid;
}
for($x=0; $x < count($storeamount); $x++){
if($storeamount[$x]!='0' && $storeamount[$x]!=''){
$userid=getFieldwhere('user_id','tbl_order','id',$orderid);
$obj->query("insert into tbl_wallet set user_id='$userid', order_id='$orderid', storeid='".$storeidarr[$x]."',wallet_balance='$storeamount[$x]',type='Cr',added_date=now(),status='1'");
$_SESSION['sess_msg']="Amount refunded for order id $orderid ";
}
}
//$sum=$obj->query("select sum((price+tax_value)*qty) as total from tbl_order_itmes where order_id='$refund_order_id' and storeid='$resstoreamount->storeid' order by storeid asc");
// $rs=$obj->fetchNextObject($sum);
// $total=number_format($rs->total,2);
}
?>
<?php echo SITE_TITLE; ?>
Admin: Add Refund
query("select distinct storeid from tbl_order_itmes where order_id='$refund_order_id' order by storeid asc");
if($obj->numRows($storeArrid)>0){?>
Admin: Add Refund