<?
include("config.inc");
include("filehandler.inc");
include("errorhandler.inc");
include("general.inc");

function getConfigValues()
{
    global $write_to_db;
    global $write_to_file;
    global $errlog;
    global $dsn;
    global $debug_level;
    global $log_path;
    global $switch_interval;
    global $referlog_reg;
    global $conn;
}
function validate_emailadd($em)
{
    $pattern = '^([._a-zA-Z0-9-]){2,255}@([._a-zA-Z0-9-]){2,255}\.([a-zA-Z]){2,4}$';
    if (!ereg($pattern, $em))
	{
        return false;
    }
    return true;
}

getConfigValues();
$fileHandler = new FileHandler();
$dbHandler = new DbHandler();


$fname=$_GET['fname'];
$lname=$_GET['lname'];
$company_name=$_GET['company_name'];
$emailadd=$_GET['emailadd'];
$daytime_phone=$_GET['daytime_phone'];
$opted_for=$_GET['opted_for'];
$blastid=$_GET['blastid'];
$ac_manager=$_GET['ac_manager'];
$description=$_GET['description'];


if ($write_to_db) {
    $dbHandler = new DbHandler();
    $conn = $dbHandler->getConnection($dsn); //Connect to response database.
    if (!$conn) {

		$errorvar=" 09002  :: RELEVANT NOISE DATABASE CONNECTION FAILED::" . $emailadd .  "," . $fname . "," . $lname . "," . $company_name . "," . $blastid . "," . $daytime_phone .  "," . $opted_format . "," . $ac_manager . "," . $description ."\n";
		errorlog(0, $errorvar);
        // header("Location:error.html" );
        die;
    }
}

if ($conn) {
	if(validate_emailadd($emailadd))
	{
		$insertQuery = "Insert into RELEVANT_NOISE(email,fname,lname,company_name,blastid,daytime_phone,opted_for,ac_manager,description) values('" . $emailadd . "','" . $fname . "','" . $lname . "','" . $company_name . "','" . $blastid . "','" . $daytime_phone . "','" . $opted_for . "','" . $ac_manager . "','" . $description . "')";

		$resultInsert = $dbHandler -> execute_Update($conn,$insertQuery);

		if(empty($resultInsert))
		{
			$errorvar = "DATABASE PROBLEM :INSERT QUERY FAILED ".date("F j, Y, g:i a") ." ::  " . $emailadd .  "," . $fname . "," . $lname . "," . $company_name . "," . $blastid . "," .  $daytime_phone .  "," . $opted_format . "," . $ac_manager . "," . $description . "\n";
					$fileHandler -> writeToFile($referlog_reg,$errorvar);
		}
	}
	else
	{
		$errorvar = "INVALID EMAIL ADDRESS ".date("F j, Y, g:i a") ." ::  " . $emailadd .  "," . $fname . "," . $lname . "," . $company_name . "," . $blastid . "," .  $daytime_phone .  "," . $opted_format . "," . $ac_manager . "," . $description . "\n";
					$fileHandler -> writeToFile($referlog_reg,$errorvar);
	}

}
if($conn)
{
	@mysql_close($conn);
	if($opted_for=='R')
	{
		 $thankyouurl="http://capps.zt03.net/custapps/Relevant_Noise/thankyou.php?emailadd=" . $emailadd . "&fname=" . $fname . "&lname=" . $lname . "&company_name=" . $company_name . "&blastid=" . $blastid . "&opted_for=UG" . "&ac_manager=" . $ac_manager . "&description=" . $description;

	//echo $thankyouurl;
	 	header("Location:" . $thankyouurl);

	}

	else if($opted_for=='UG')
	{
		//header('Content-type: application/pdf');
		header('Content-type: application/pdf');
		header('Content-Disposition: attachment; filename="relevantnoise.pdf"');
		readfile('relevantnoise.pdf');
		//header('Location: http://capps.zt03.net/custapps/Relevant_Noise/Updated_RelevantNoise_Quick_User_Guide_FINAL.pdf');
		//	header('Location: http://capps.zt03.net/custapps/Relevant_Noise/demo_Landingpage.htm');
		
	}
	else if($opted_for=='D')
	{
		header("Location:http://capps.zt03.net/custapps/Relevant_Noise/RN_demo_v3/index.htm");
	}
}

?>