0){
$str_rest_refs=implode(",",$arr);
if($Submit=='Delete')
{
$sql="delete from $tbl_buygiftcard where id in ($str_rest_refs)";
$obj->query($sql);
$sess_msg='Selected record(s) deleted successfully';
$_SESSION['sess_msg']=$sess_msg;
}
elseif($Submit=='Approve')
{
$recArr=$obj->query("select * from $tbl_buygiftcard where id in ($str_rest_refs) and status!=1 ",$debug=-1);
while($rsRec=$obj->fetchNextObject($recArr)){
$uArr=$obj->query("select id from $tbl_user where email='".$rsRec->receiver_email."' and user_type=0 ");
if($obj->numRows($uArr)>0){
$rsUser=$obj->fetchNextObject($uArr);
$setting_reward=getField('rewardamount',$tbl_setting,1);
$reward_point=floor($rsRec->gift_amount/$setting_reward);
$my_reward_point = $reward_point+$rsRec->gift_amount;
$obj->query("insert into $tbl_reward_history set user_id='".$rsUser->id."',reward_point='".$my_reward_point."',type='Cr',added_date=now(),status=1 ");
$sql="update $tbl_buygiftcard set alloted=1,status=1 where id ='".$rsRec->id."'";
$obj->query($sql);
}
$FromTo=getAdminEmail();
$subject="Gift Cart Approval ".($rsUser->fname." ".$rsUser->lname)."";
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
// More headers
$headers .= "From: <".$FromTo.">\r\n";
$message="
Dear User,
Your Gift Card has been successfully activated from ".SITE_TITLE."
Please find the details below:
Gift Amount
:
Rs. ".$rsRec->gift_amount."
Thanks
".SITE_TITLE."
";
@mail($rsRec->receiver_email,$subject,$message,$headers);
}
$sql="update $tbl_buygiftcard set status=1,payment_status=1 where id in ($str_rest_refs)";
$obj->query($sql);
$sess_msg='Selected record(s) activated successfully';
$_SESSION['sess_msg']=$sess_msg;
}
elseif($Submit=='Disapprove')
{
$recArr=$obj->query("select * from $tbl_buygiftcard where id in ($str_rest_refs) and status!=0 ");
while($rsRec=$obj->fetchNextObject($recArr)){
$uArr=$obj->query("select id from $tbl_user where email='".$rsRec->receiver_email."' and user_type=0 ");
if($obj->numRows($uArr)>0){
$rsUser=$obj->fetchNextObject($uArr);
if($rsRec->alloted==1){
$setting_reward=getField('rewardamount',$tbl_setting,1);
$reward_point=floor($rsRec->gift_amount/$setting_reward);
$my_reward_point = $reward_point+$rsRec->gift_amount;
$obj->query("insert into $tbl_reward_history set user_id='".$rsUser->id."',reward_point='$my_reward_point',type='Dr',added_date=now(),status=1 ");
$sql="update $tbl_buygiftcard set alloted=0,status=0 where id ='".$rsRec->id."'";
$obj->query($sql);
}
}
}
$sql="update $tbl_buygiftcard set status=0 where id in ($str_rest_refs)";
$obj->query($sql);
$sess_msg='Selected record(s) deactivated successfully';
$_SESSION['sess_msg']=$sess_msg;
}
}
else{
$sess_msg="Please select check box";
$_SESSION['sess_msg']=$sess_msg;
header("location: ".$_SERVER['HTTP_REFERER']);
exit();
}
header("location: buygiftcard-list.php");
exit();
?>