<?
require_once "application_top.php"; 
$orderid = isset($_REQUEST['id'])? decode($_REQUEST['id']) : "";
$error = "";

//update orders_detail
$dbArr = array('isCancelled'=>1,'cancelledOn'=>date('Y-m-d H:i:s'));
$db->where('orderid',$orderid);
$db->update('orders_detail',$dbArr);

//get order_detail
$db->where('orderid',$orderid);
$rowod = $db->getOne('orders_detail');

//make product re available
$dbArr = array('qty'=>1,'isSold'=> 0);
$db->where('pid',$rowod['pid']);
$db->update('products',$dbArr);

//notify customer that order has been canceled
$db->where('userid',$rowod['userid']);
$rowcust = $db->getOne('register');

$db->where('userid',$rowod['sellerid']);
$rowseller = $db->getOne('register');

//send email to cust
$emailid = ($rowcust['emailid'])? $rowcust['emailid'] : "";
if($emailid){
$messagetosent ="Dear ".$rowcust['fullname']." <br/><br/>
Your Order No. ".$orderid." has been cancelled by seller.<br/>
Total ".$rowod['customercost']." gold coins paid by you for this order has been credited back to your account.<br/>
	<br/>
	<br/>
	Team<br/>
	".HTTP_SERVER."
<br/><br/>
";
$subjecttosend = "Order No. ".$orderid." has been cancelled by seller";
$sendtoname = $rowcust['fullname'];
$successmesage = "";
sendemail($emailid,$subjecttosend,$messagetosent,$sendtoname,$successmesage);
}
header("location:".$_SERVER['HTTP_REFERER']);exit;
?>