<?
	include("/home/cbhprope/_inc/dbconnect.inc");

	$q = "SELECT * FROM ConciergeServices ORDER BY ServiceCode";

	$result = mysql_query($q);
	 
	$num_results = mysql_num_rows($result);
	
	if ($num_results != 0)
	{
		for ($i = 0; $i < $num_results; $i++)
		{
			$row = mysql_fetch_array($result);
			$code = stripslashes($row["Id"]);
			$name = stripslashes($row["ServiceName"]);
			$services[$i] = $name;
		}
	}

	if ($_SERVER['REQUEST_METHOD'] == "POST")
	{
		include("/home/cbhprope/_inc/mail/Mail.php");
		include("/home/cbhprope/_inc/securimage/securimage.php");

		$bizname = isset($_POST['bizname']) && strlen($_POST['bizname']) > 0 ? $_POST['bizname'] : NULL;
		$bizstreet1 = $_POST['bizstreet1'];
		$bizstreet2 = $_POST['bizstreet2'];
		$bizcity = isset($_POST['bizcity']) && strlen($_POST['bizcity']) > 0 ? $_POST['bizcity'] : NULL;
		$bizstate = isset($_POST['bizstate']) && strlen($_POST['bizstate']) > 0 ? $_POST['bizstate'] : NULL;
		$bizzip = isset($_POST['bizzip']) && strlen($_POST['bizzip']) > 0 ? $_POST['bizzip'] : NULL;
		$bizphone = isset($_POST['bizphone']) && strlen($_POST['bizphone']) > 0 ? $_POST['bizphone'] : NULL;
		$bizemail = isset($_POST['bizemail']) && strlen($_POST['bizemail']) > 0 ? $_POST['bizemail'] : NULL;
		$bizwebsite = isset($_POST['bizwebsite']) && strlen($_POST['bizwebsite']) > 0 ? $_POST['bizwebsite'] : NULL;
		$contact = isset($_POST['contact']) && strlen($_POST['contact']) > 0 ? $_POST['contact'] : NULL;
		$contactphone = $_POST['contactphone'];
		$contactemail = $_POST['contactemail'];
		$bizservices = $_POST['bizservice'];
		$bizserviceother = $_POST['bizserviceother'];
		$comments = $_POST['comments'];
		$code = $_POST['code'];
		if (isset($code) == false)
		{
			$errormsg = "Please validate the security code";
		}
		else
		{
			$img = new Securimage();
			$valid = $img->check($code);

			if($valid == false)
			{
				$errormsg = "Sorry, the Security Code you entered was invalid, please try again.";
			}
		}

		if (isset($errormsg) == false)
		{
			if (isset($bizname) == false || isset($bizcity) == false ||
				isset($bizstate) == false || isset($bizzip) == false || 
				isset($bizphone) == false || isset($bizemail) == false || 
				isset($contact) == false || 
				(isset($bizservices) == false || count($bizservices) == 0))
			{
				$errormsg = "Please fill in all required fields";
			}
			else
			{

				$q = "INSERT INTO ConciergeBusiness (BusinessName, BusinessStreet1, BusinessStreet2, " .
					"BusinessCity, BusinessState, BusinessZip, BusinessPhone, BusinessEmail, BusinessWebsite, ".
					"PrimaryContact, ContactPhone, ContactEmail, Comments) VALUES (" .
					"'".mysql_real_escape_string($bizname)."', ".
					"'".mysql_real_escape_string($bizstreet1)."', ".
					"'".mysql_real_escape_string($bizstreet2)."', ".
					"'".mysql_real_escape_string($bizcity)."', ".
					"'".mysql_real_escape_string($bizstate)."', ".
					"'".mysql_real_escape_string($bizzip)."', ".
					"'".mysql_real_escape_string($bizphone)."', ".
					"'".mysql_real_escape_string($bizemail)."', ".
					"'".mysql_real_escape_string($bizwebsite)."', ".
					"'".mysql_real_escape_string($contact)."', ".
					"'".mysql_real_escape_string($contactphone)."', ".
					"'".mysql_real_escape_string($contactemail)."', ".
					"'".mysql_real_escape_string($comments)."')";

				$result = mysql_query($q);

				if ($result)
				{
					$bizId = mysql_insert_id();

					$to = "beadling@cbhearthside.com";
					//$to = "statephan@yahoo.com";
					$cc = "statephan@yahoo.com";

					$recipients = $to.",".$cc;
					$headers['From'] = 'website@cbhearthside.com';
					//$headers['From'] = 'beadling@cbhearthside.com';
					$headers['To'] = $to;
					$headers['Cc'] = $cc;
					$headers['Subject'] = "Concierge Request";

					$msg = "Concierge form submission date - ".date("m-d-Y H:i:s")."\n" .
						"Business Name: $bizname\n" .
						"Business Street 1: $bizstreet1\n" .
						"Business Street 2: $bizstreet2\n" .
						"Business City: $bizcity\n" .
						"Business State: $bizstate\n" .
						"Business Zip: $bizzip\n" .
						"Business Phone: $bizphone\n" .
						"Business Email: $bizemail\n" .
						"Business Website: $bizwebsite\n" .
						"Primary Contact: $contact\n" .
						"Contact Phone: $contactphone\n" .
						"Contact Email: $contactemail\n\n" .
						"Services:\n==================\n";

					foreach($bizservices as $key => $value)
					{
						$q = "INSERT INTO ConciergeBusinessService (BusinessId, ServiceId, ServiceName) VALUES (" .
							"$bizId, $value, ";
						
						if ($value == "-1")
						{
							$msg .= "Other: $bizserviceother";
							$q .= "'".mysql_real_escape_string($bizserviceother)."'";
						}
						else
						{
							$msg .= $services[$value];
							$q .= "'".mysql_real_escape_string($services[$value])."'";
						}

						$q .= ")";
						$result = mysql_query($q);
						if ($result)
						{
						}
						else
						{
							echo $q;
							exit;
						}
						$msg .= "\n";
					}

					$msg .= "\nComments:\n==================\n$comments";

				
					// Create the mail object using the Mail::factory method
					$mail_object =& Mail::factory('smtp', $params);

					$send = $mail_object->send($recipients, $headers, $msg);
					if (PEAR::isError($send))
					{
						$errormsg = "There was a problem";
					}
					else
					{
						$emailsent = "Y";
					}
				}
			}
		}
	}

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Coldwell Banker Hearthside Concierge Signup Formt</title>
<link rel="stylesheet" type="text/css" href="cbh.css"/>
</head>
<body>
<div id="container">
	<div id="headercon">
		<div id="header">
			<div id="logo"><img id="logoImage" alt="Coldwell Banker - Home" src="http://www.cbhearthside.net/images/cbhlogo.gif" border="0" height="76" width="150"/></div>
			<h1>Coldwell Banker Hearthside Concierge Sign Up<br/><span style="font-size:.5em">Please fill out the form below to add a company to our list of Concierge providers</span></h1>

		</div><!-- end header -->
		<div class="clear"></div>
	</div>
	<div id="content">
		<div id="main">
<?
	if (isset($emailsent))
	{
		echo "<p>Thank you.</p>";
	}
	else
	{
		if (isset($errormsg))
		{
			echo "<div class=\"error\">".$errormsg."</div><br/>";
		}
?>
			<form action="index.html" id="frm" method="post">
			<table class="form">
			<tr>
				<td class="required">Business Name:</td>
				<td><input type="text" name="bizname" size="30" maxlength="100" value="<?= htmlspecialchars($bizname) ?>"/></td>
			</tr>
			<tr>
				<td>Business Street 1:</td>
				<td><input type="text" size="30" name="bizstreet1" value="<?= htmlspecialchars($bizstreet1) ?>"/></td>
			</tr>
			<tr>
				<td>Business Street 2:</td>
				<td><input type="text" size="30" name="bizstreet2" value="<?= htmlspecialchars($bizstreet2) ?>"/></td>
			</tr>
			<tr>
				<td class="required">Business City:</td>
				<td><input type="text" size="30" name="bizcity" value="<?= htmlspecialchars($bizcity) ?>"/></td>
			</tr>
			<tr>
				<td class="required">Business State:</td>
				<td><select name="bizstate">
					<option value=""></option>
					<option value="PA" <? if (isset($bizstate) && $bizstate == "PA") echo "selected=\"selected\""; ?>>Pennsylvania</option>
					<option value="NJ" <? if (isset($bizstate) && $bizstate == "NJ") echo "selected=\"selected\""; ?>>New Jersey</option>
					<option value="DE" <? if (isset($bizstate) && $bizstate == "DE") echo "selected=\"selected\""; ?>>Delaware</option>
					</select></td>
			</tr>
			<tr>
				<td class="required">Business Zip Code:</td>
				<td><input type="text" size="10" name="bizzip" value="<?= htmlspecialchars($bizzip) ?>"/></td>
			</tr>
			<tr>
				<td class="required">Business Phone:</td>
				<td><input type="text" name="bizphone" size="15" maxlength="20" value="<?= htmlspecialchars($bizphone) ?>"/></td>
			</tr>
			<tr>
				<td class="required">Business Email:</td>
				<td><input type="text" name="bizemail" size="30" maxlength="100" value="<?= htmlspecialchars($bizemail) ?>"/></td>
			</tr>
			<tr>
				<td>Business Website:</td>
				<td><input type="text" name="bizwebsite" size="30" maxlength="100" value="<?= htmlspecialchars($bizwebsite) ?>"/></td>
			</tr>
			<tr>
				<td class="required">Primary Contact:</td>
				<td><input type="text" name="contact" size="30" maxlength="100" value="<?= htmlspecialchars($contact) ?>"/></td>
			</tr>
			<tr>
				<td>Contact Phone:<br/>(if different)</td>
				<td valign="top"><input type="text" name="contactphone" size="15" maxlength="20" value="<?= htmlspecialchars($contactphone) ?>"/></td>
			</tr>
			<tr>
				<td>Contact Email:<br/>(if different)</td>
				<td valign="top"><input type="text" name="contactemail" size="30" maxlength="100" value="<?= htmlspecialchars($contactemail) ?>"/></td>
			</tr>
			<tr>
				<td valign="top">Business Category:</td>
				<td><table class="form" style="margin-top:0px;">
					<tr>
					<td valign="top"><?
		$mid = count($services) / 2;
		$i = 0;
		foreach($services as $key => $value)
		{
			if ($i > $mid)
			{
				echo "</td>\n<td>";
				$i = 0;
			}
			echo "<input type=\"checkbox\" ";
			echo isset($bizservices) && in_array($key, $bizservices) ? "checked=\"checked\" " : "";
			echo "name=\"bizservice[]\" value=\"".htmlspecialchars($key)."\" id=\"".$key."\"/>";
			echo "<label for=\"".$key."\">".htmlspecialchars($value)."</label><br/>\n";
			$i++;
		}
?><input type="checkbox" name="bizservice[]" <?

		echo isset($bizservices) && in_array("-1", $bizservices) ? "checked=\"checked\" " : "";

					?>value="-1" id="other"/><label for="other">Other</label> <input type="text" name="bizserviceother" value="<?

		if (isset($bizservices) && in_array("-1", $bizservices))
		{
			echo htmlspecialchars($bizserviceother);
		}
			?>"/>
					</td></tr>
					</table>
				</td>
			</tr>
			<tr>
				<td valign="top">Other Comments:</td>
				<td><textarea name="comments" cols="70" rows="4"><?= htmlspecialchars($comments) ?></textarea></td>
			</tr>
			<tr>
				<td class="formTabLabel">Security Code:</td>
				<td colspan="3"><img id="scode" src="/securimage_show.php?sid=<?php echo md5(uniqid(time())); ?>" alt="Security Code" align="absmiddle"/>
					<a href="#" onclick="document.getElementById('scode').src = '/securimage_show.php?sid=' + Math.random(); return false"><img src="/art/refresh.gif" width="22" height="20" alt="Refresh Security Code"/></a>
				</td>
			</tr>
			<tr>
				<td class="formTabLabel">Verify Code:</td>
				<td colspan="3"><input type="text" id="verifycode" name="code" /></td>
			</tr>
			<tr>
				<td>&nbsp;</td>
				<td><input type="button" id="btnsave" onclick="submitForm()" name="btnSave" value="Save"/>
			</tr>
			</table>
			</form>
<?
	}
?>
		<div style="clear:both;"></div>
		</div><!-- end main -->
	</div><!-- end content -->
	<div id="footer">
		<div id="footerContent">
		  	<div class="footerCopyArea">&copy 2011 Coldwell Banker Hearthside Realtors</div>
		  	<div class="footerBottomNav"><!--<a href="about.html">About Coldwell Banker Hearthside</a> &nbsp;
			  | &nbsp; <a href="http://66.187.133.250/CBHearthSide/home/sitemap.aspx">Site Map</a> &nbsp;
			  | &nbsp; <a href="http://66.187.133.250/CBHearthSide/home/privacy.aspx">Privacy Policy</a>-->
			</div>

		</div>
	</div><!-- end footer --></div><!-- end container -->
<script type="text/javascript">
<!--
function submitForm()
{
	var btn = document.getElementById('btnsave');
	btn.disabled = true;
	//document.getElementById('btncancel').disabled = true;
	btn.form.submit();
	return true;
}
-->
</script>
</body>
</html>