#!/usr/bin/perl

print "Content-type: text/html\n\n";

require "config.idx";
$long = $ENV{'QUERY_STRING'};
if ($long) {
	@pairs=split(/&/,$long);
	foreach $item(@pairs) {
		($name,$content)=split (/=/,$item,2);
		$content=~tr/+/ /;
		$content=~ s/%(..)/pack("c",hex($1))/ge;
		if ($INPUT{$name}) { $INPUT{$name} = $INPUT{$name}.",".$content; }
		else { $INPUT{$name} = $content; }
	}
}
else {
	read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'});
	@pairs = split(/&/, $buffer);
	foreach $pair (@pairs) {
		($name, $value) = split(/=/, $pair);
		$value =~ tr/+/ /;
		$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg;
		if ($INPUT{$name}) { $INPUT{$name} = $INPUT{$name}.",".$value; }
		else { $INPUT{$name} = $value; }
	}
}


#print qq~
#Please call 765-212-1111 to schedule or ask a question about this property.   The online showing module has temporarly been disabled.
#~;
#exit 0;

if ($INPUT{action} eq "send")			{ &send; }
elsif ($INPUT{action} eq "verify")		{ &verify; }
else { &main; }

sub main {


@days   = ('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday');
@months = ('January','February','March','April','May','June','July','August','September','October','November','December');
($sec,$min,$hour,$mday,$mon,$year,$wday) = (localtime(time))[0,1,2,3,4,5,6];
$time = sprintf("%02d:%02d:%02d",$hour,$min,$sec);

	if ($hour eq "13") {
	$hour = "1";
	$pm = "y";

	}if ($hour eq "14") {
	$hour = "2";
	$pm = "y";
	}if ($hour eq "15") {
	$hour = "3";
	$pm = "y";
	}if ($hour eq "16") {
	$hour = "4";
	$pm = "y";
	}if ($hour eq "17") {
	$hour = "5";
	$pm = "y";
	}if ($hour eq "18") {
	$hour = "6";
	$pm = "y";
	}if ($hour eq "19") {
	$hour = "7";
	$pm = "y";
	}if ($hour eq "20") {
	$hour = "8";
	$pm = "y";
	}if ($hour eq "21") {
	$hour = "9";
	$pm = "y";
	}if ($hour eq "22") {
	$hour = "10";
	$pm = "y";
	}if ($hour eq "23") {
	$hour = "11";
	$pm = "y";
	}if ($hour eq "24") {
	$hour = "12";
	$pm = "y";
	}
	$time = sprintf("%02d:%02d",$hour,$min);
	$tdate = "$days[$wday], $months[$mon] $mday, $year";
	$mon = $mon - 1;
	if ($pm eq "y") {
	$tm = "pm";
	}
	else {
	$tm = "am";
	}
	if ($mday < "10") {
	$mday = "0$mday";
	}
	if ($mon eq "12") {
	$mon = "1";
	}
	else {
	$mon++;
	}
	$newyear = $year+1900;
	$actdate = "$mon\/$mday\/$newyear";


my $client_info = $dbh->prepare("select userid,email,password,firstname,lastname,address,city,state,zipcode,Phone,myERAAgent from users where userid = '$Cook{userid}'");
$client_info->execute;
while (($cclient_userid,$cclient_email,$cclient_password,$cclient_firstname,$cclient_lastname,$cclient_address,$cclient_city,$cclient_state,$cclient_zip,$cclient_phone,$cclient_agentid) = $client_info->fetchrow_array()) {

$client_userid = "$cclient_userid";
$client_email = "$cclient_email";
$client_password = "$cclient_password";
$client_firstname = "$cclient_firstname";
$client_lastname = "$cclient_lastname";
$client_address = "$cclient_address";
$client_city = "$cclient_city";
$client_state = "$cclient_state";
$client_zip = "$cclient_zip";
$client_phone = "$cclient_phone";
$client_agentid = "$cclient_agentid";


}
print qq~
<html>
<head>
<title>The ORR Home Selling Team Setup A Showing Online</title>
<link rel="stylesheet" TYPE="text/css" href="includes/style.css">
</head>
<body bgcolor="#ffffff" background="images/request_showing_background.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- Main Showing Form -->
<table border="0" cellpadding="3" cellspacing="1" width="365">
<tr>
<td valign="top" width="365">
<FORM method="post" ACTION="showing_setup.idx">
<input type="hidden" name="action" value="verify">
<input type="hidden" name="mlsnumber" value="$INPUT{mlsnumber}">
<input type="hidden" name="proptype" value="$INPUT{proptype}">
<input type="hidden" name="userid" value="$Cook{userid}">
<input type="hidden" name="address" value="$INPUT{address}">
<input type="hidden" name="City" value="$INPUT{City}">

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%">
<font size="2" face="Arial"><b>Please Enter Your Contact Info, Showing Information and/or Question Below:</b></font><br>
<font size="1" face="Arial">
<u>Name</u><br>
<INPUT TYPE=TEXT SIZE=25 NAME="FirstName" value="$client_firstname $client_lastname" class="adminform"><br>
<u>Address</u><br>
<INPUT TYPE=TEXT SIZE=25 NAME="cAddress" value="$client_address" class="adminform"><br>
<INPUT TYPE=TEXT SIZE=16 NAME="cCity" value="$client_city" class="adminform">, <SELECT NAME="cState" class="adminform">
		<OPTION value="$client_state">$client_state</OPTION>
                <OPTION>Alabama</OPTION>
                <OPTION>Alaska</OPTION>
                <OPTION>Arizona</OPTION>
                <OPTION>Arkansas</OPTION>
                <OPTION>California</OPTION>
                <OPTION>Connecticut</OPTION>
                <OPTION>Colorado</OPTION>
                <OPTION>Delaware</OPTION>
                <OPTION>District of Columbia</OPTION>
                <OPTION>Florida</OPTION>
                <OPTION>Georgia</OPTION>
                <OPTION>Hawaii</OPTION>
                <OPTION>Idaho</OPTION>
                <OPTION>Illinois</OPTION>
                <OPTION selected>Indiana</OPTION>
                <OPTION>Iowa</OPTION>
                <OPTION>Kansas</OPTION>
                <OPTION>Kentucky</OPTION>
                <OPTION>Louisiana</OPTION>
                <OPTION>Maine</OPTION>
                <OPTION>Maryland</OPTION>
                <OPTION>Massachusetts</OPTION>
                <OPTION>Michigan</OPTION>
                <OPTION>Minnesota</OPTION>
                <OPTION>Mississippi</OPTION>
                <OPTION>Missouri</OPTION>
                <OPTION>Montana</OPTION>
                <OPTION>Nebraska</OPTION>
                <OPTION>New Hampshire</OPTION>
                <OPTION>New Jersey</OPTION>
                <OPTION>New Mexico</OPTION>
                <OPTION>New York</OPTION>
                <OPTION>Nevada</OPTION>
                <OPTION>North Carolina</OPTION>
                <OPTION>North Dakota</OPTION>
                <OPTION>Ohio</OPTION>
                <OPTION>Oklahoma</OPTION>
                <OPTION>Oregon</OPTION>
                <OPTION>Pennsylvania</OPTION>
                <OPTION>Rhode Island</OPTION>
                <OPTION>South Carolina</OPTION>
                <OPTION>South Dakota</OPTION>
                <OPTION>Tennessee</OPTION>
                <OPTION>Texas</OPTION>
                <OPTION>Utah</OPTION>
                <OPTION>Vermont</OPTION>
                <OPTION>Virginia</OPTION>
                <OPTION>Washington</OPTION>
                <OPTION>West Virginia</OPTION>
                <OPTION>Wisconsin</OPTION>
                <OPTION>Wyoming</OPTION>
                </SELECT> <INPUT TYPE=TEXT SIZE=5 NAME="cZipCode" value="$client_zip" class="adminform"><br>
		<u>Phone</u> Used to verify appointment<br>
		<INPUT TYPE=TEXT SIZE=25 NAME="Phone" value="$client_phone" class="adminform"><br>
		<u>E-Mail Address</u><br>
		<INPUT TYPE=TEXT SIZE=25 NAME="EmailAddress" value="$client_email" class="adminform"><br>
</td>
</tr>
<tr>
<td width="100%">
<font size="1"><b>When would you like to see this property?</b></font><br>
<SELECT NAME=TMonth SIZE=1 class="adminform">
		<OPTION value="$months[$mon]">$months[$mon]</option>
		<option value="Not Selected">----</option>
                <OPTION value="January">January</option>
                <OPTION value="February">February</option>
                <OPTION value="March">March</option>
                <OPTION value="April">April</option>
                <OPTION value="May">May</option>
                <OPTION value="June">June</option>
                <OPTION value="July">July</option>
                <OPTION value="August">August</option>
                <OPTION value="September">September</option>
                <OPTION value="October">October</option>
                <OPTION value="November">November</option>
                <OPTION value="December">December</option>
</select>
<SELECT NAME=TMonthDay SIZE=1 class="adminform">
		<OPTION value="$mday">$mday</option>
		<option value="No Selected">----</option>
                <OPTION value="01">01</option>
                <OPTION value="02">02</option>
                <OPTION value="03">03</option>
                <OPTION value="04">04</option>
                <OPTION value="05">05</option>
                <OPTION value="06">06</option>
                <OPTION value="07">07</option>
                <OPTION value="08">08</option>
                <OPTION value="09">09</option>
                <OPTION value="10">10</option>
                <OPTION value="11">11</option>
                <OPTION value="12">12</option>
                <OPTION value="13">13</option>
                <OPTION value="14">14</option>
                <OPTION value="15">15</option>
                <OPTION value="16">16</option>
                <OPTION value="17">17</option>
                <OPTION value="18">18</option>
                <OPTION value="19">19</option>
                <OPTION value="20">20</option>
                <OPTION value="21">21</option>
                <OPTION value="22">22</option>
                <OPTION value="23">23</option>
                <OPTION value="24">24</option>
                <OPTION value="25">25</option>
                <OPTION value="26">26</option>
                <OPTION value="27">27</option>
                <OPTION value="28">28</option>
                <OPTION value="29">29</option>
                <OPTION value="30">30</option>
                <OPTION value="31">31</option>
</select> at 
<select name="TTimeHour" size="1" class="adminform">
	<Option value="1">1</option>
	<Option value="2">2</option>
	<Option value="3">3</option>
	<Option value="4">4</option>
	<Option value="5">5</option>
	<Option value="6">6</option>
	<Option value="7">7</option>
	<Option value="8">8</option>
	<Option value="9">9</option>
	<Option value="10">10</option>
	<Option value="11">11</option>
	<Option value="12">12</option>
</select>:
<select name="TTimeMinute" size="1" class="adminform">
	<Option value="15">15</option>
	<Option value="30">30</option>
	<Option value="45">45</option>
	<Option value="00" selected>00</option>
</select>&nbsp;
<select name="TTimeAP" size="1" class="adminform">
	<Option value="PM" selected>PM</option>
	<Option value="AM">AM</option>
</select>
</center>
</td>
</tr>
<tr>
<td width="100%" valign="top">
<font size="1" color="black"><b>Please send us any showing information or attach your question in the box below:</b></font><br>
<TEXTAREA ROWS=4 COLS=40 NAME=EmailMessage WRAP=PHYSICAL></TEXTAREA><br><br>
<INPUT TYPE=SUBMIT VALUE=">> Continue to Next Page">
</td>
</tr>
</table>
</FORM>
</td>
</tr>
</table>
<!-- END Main Showing Form -->
</body>
</html>
~;
}

sub verify {

print qq~
<html>
<head>
<title>The ORR Home Selling Team Setup A Showing Online</title>
<link rel="stylesheet" TYPE="text/css" href="includes/style.css">
</head>
<body bgcolor="#ffffff" background="images/request_showing_background.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- Main Showing Form -->
<table border="0" cellpadding="3" cellspacing="1" width="365">
<tr>
<td valign="top" width="365">
<FORM method="post" ACTION="showing_setup.idx">
<input type="hidden" name="action" value="send">
<input type="hidden" name="mlsnumber" value="$INPUT{mlsnumber}">
<input type="hidden" name="proptype" value="$INPUT{proptype}">
<input type="hidden" name="userid" value="$Cook{userid}">
<input type="hidden" name="address" value="$INPUT{address}">
<input type="hidden" name="City" value="$INPUT{City}">
<input type="hidden" name="FirstName" value="$INPUT{FirstName}">
<input type="hidden" name="cAddress" value="$INPUT{cAddress}">
<input type="hidden" name="cCity" value="$INPUT{cCity}">
<input type="hidden" name="cState" value="$INPUT{cState}">
<input type="hidden" name="cZipCode" value="$INPUT{cZipCode}">
<input type="hidden" name="Phone" value="$INPUT{Phone}">
<input type="hidden" name="EmailAddress" value="$INPUT{EmailAddress}">
<input type="hidden" name="TMonth" value="$INPUT{TMonth}">
<input type="hidden" name="TMonthDay" value="$INPUT{TMonthDay}">
<input type="hidden" name="TTimeHour" value="$INPUT{TTimeHour}">
<input type="hidden" name="TTimeMinute" value="$INPUT{TTimeMinute}">
<input type="hidden" name="TTimeAP" value="$INPUT{TTimeAP}">
<input type="hidden" name="EmailMessage" value="$INPUT{EmailMessage}">

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" colspan="3">
<center>[ <a href="javascript:history.back()">Make Changes</a> ]  <INPUT TYPE=SUBMIT VALUE=">> Submit Showing Request"></center>
</td>
</tr>
<tr>
<td width="100%" colspan="3">
<font size="2" face="Arial"><b>Please Verify Information Below:</b></font><br>
</td>
</tr>
<tr>
<td valign="top" width="48%">
	<table border="0" cellpadding="3" cellspacing="1" bgcolor="navy" width="100%">
		<tr>
			<td valign="top" width="90%" bgcolor="#FFFF99">
				<font size="2">
				<b>Name:</b><br>
				$INPUT{FirstName}<br>
				<b>Address:</b><br>
				$INPUT{cAddress}<br>
				$INPUT{cCity}, $INPUT{cState} $INPUT{cZipCode}<br>
				<b>Phone:</b><br>
				$INPUT{Phone}<br>
				<b>E-Mail Address:</b><br>
				$INPUT{EmailAddress}<br>
				</font>
				<br><br><br><br><br>
			</td>
		</tr>
	</table>
</td>
<td valign="top" width="2%" bgcolor="navy">
	&nbsp;
</td>
<td valign="top" width="48%">
	<table border="0" cellpadding="3" cellspacing="1" bgcolor="navy" width="100%">
		<tr>
			<td valign="top" width="90%" bgcolor="navy">
				<font size="1" face="Arial" color="white">
				<b>Property:</b><br>
				$INPUT{address}<br>
				$INPUT{City}<br>
				</font>
			</td>
		</tr>
	</table>
	<table border="0" cellpadding="3" cellspacing="1" width="100%">
		<tr>
			<td valign="top" width="90%">
				<font size="1"><b>When would you like to see this property?</b><br>
				$INPUT{TMonth} $INPUT{TMonthDay} at $INPUT{TTimeHour}:$INPUT{TTimeMinute} $INPUT{TTimeAP}<br><br>
				<b>Showing Information or Question to Ask:</b><br>
				$INPUT{EmailMessage}<br><br><br>
				</font>
			</td>
		</tr>
	</table>
</td>
</tr>
<tr>
<td width="100%" colspan="3">
<center>[ <a href="javascript:history.back()">Make Changes</a> ]  <INPUT TYPE=SUBMIT VALUE=">> Submit Showing Request"></center>
</td>
</tr>
</table>
</FORM>
</td>
</tr>
</table>
<!-- END Main Showing Form -->
</body>
</html>
~;

}


sub send {

		open(MAIL,"|/usr/sbin/sendmail -t");
		print MAIL "To: messages\@ORRHomes.com\n";
		print MAIL "To: ryan\@ORRHomes.com\n";
		print MAIL "From: showings\@munciemls.com\n";
		print MAIL "Subject: \*\*Online Showing Request received from MuncieMLS.com!\*\*\n";
		print MAIL "Content-type: text/html\n\n";
		print MAIL qq~
		Below is a copy of the showing request.</b><br>
		<u><b>Property Type</b></u><br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$INPUT{proptype}<br><br>
		<u><b>Client Information</b></u><br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$INPUT{FirstName}<br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$INPUT{cAddress}<br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$INPUT{cCity}, $INPUT{cState} $INPUT{cZipCode}<br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Phone Number $INPUT{Phone}<br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;E-Mail Address $INPUT{EmailAddress}<br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ORRHomes.com UserID $INPUT{userid}<br><br>
		<u><b>Property Information</b></u><br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MLS Number $INPUT{mlsnumber}<br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$INPUT{address}<br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$INPUT{City}, Indiana<br><br>
		<u><b>Requested Time Of Showing</b></u><br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$INPUT{TMonth} $INPUT{TMonthDay} at $INPUT{TTimeHour}:$INPUT{TTimeMinute} $INPUT{TTimeAP}<br><br>
		<u><b>E-Mail Message</b></u><br>
		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$INPUT{EmailMessage}<br>
		~;
		close(MAIL); 

		print qq~
			<font size="3" face="Arial"><b>Thank you, Your request has successfully been sent The ORR Home Selling Team.   We will respond to your request as soon as possible.  Please note: Your showing request may be delayed if submited on Saturday, Sunday, or on Holidays.  Please call our office at 765-212-1111 if you have not received confirmation from an ORR Team member.  <u><font color="red">Please do not show up to the property until an ORR Team member has confirmed this showing request!</font></u></b></font><br>
		~;
}
