<?php
	
	require_once('../../phpapps/cms-template-loader/cms-template-loader.class.php');
	require_once('../../phpapps/form-builder/Form_Builder.php');
	
	$form = new Form_Builder();

	$form->setSubmitButton('Send');
	
	$form->setupDatabase('localhost','carolinabeachdata','capefearforms','!cape!fear!','plannersguide');
	$form->setupEmail('mwall@capefearcoast.com','mwall@capefearcoast.com','Carolina Beach Getaway Meeting Planner\'s Guide Request',true);
	
	// When completed, redirect the user or say a message?
	$form->setRedirect('/secondary/thankyou.html');
	//$form->setThankYouText('Thank you!');
	
	// Optional - add the current date/time to the database row
	$form->addDateColumn('Date');
	
	
	$form->addField(array(
		'name' => 'subject',
		'type' => 'hidden',
		'defaultValue' => 'Carolina Beach Getaway - Meeting Planner\'s Guide Request'
	));
	
	$form->addField(array(
		'name' => 'picvb',
		'type' => 'hidden',
		'defaultValue' => 'T',
		'columnName' => 'PICVB'
	));
	
	$form->addField(array(
		'name' => 'first_name',
		'label' => '*First Name:',
		'type' => 'text',
		'errorMessage' => 'Please enter your first name.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'FirstName'
	));
	
	$form->addField(array(
		'name' => 'last_name',
		'label' => '*Last Name:',
		'type' => 'text',
		'errorMessage' => 'Please enter your last name.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'LastName'
	));
	
	$form->addField(array(
		'name' => 'title',
		'label' => 'Title:',
		'type' => 'text',
		'errorMessage' => 'Please enter your title.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'Title'
	));
	
	$form->addField(array(
		'name' => 'organization',
		'label' => '*Organization:',
		'type' => 'text',
		'errorMessage' => 'Please enter your organization name.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'Organization'
	));
	
	$form->addField(array(
		'name' => 'meeting_name',
		'label' => '*Meeting Name:',
		'type' => 'text',
		'errorMessage' => 'Please enter your meeting name.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'MeetingName'
	));
	
	$form->addField(array(
		'name' => 'address',
		'label' => '*Address:',
		'type' => 'text',
		'errorMessage' => 'Please enter your mailing address.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'Address'
	));
	
	$form->addField(array(
		'name' => 'city',
		'label' => '*City:',
		'type' => 'text',
		'errorMessage' => 'Please enter your city.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'City'
	));
	
	$form->addField(array(
		'name' => 'state',
		'label' => '*State or Province:',
		'type' => 'text',
		'errorMessage' => 'Please enter your state or province.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'State'
	));
	
	$form->addField(array(
		'name' => 'country',
		'label' => 'Country:',
		'type' => 'text',
		'errorMessage' => 'Please enter your country.',
		'required' => true,
		'defaultValue' => '',
		'columnName' => 'Country'
	));
	
	$form->addField(array(
		'name' => 'zip',
		'label' => '*Zip:',
		'type' => 'text',
		'errorMessage' => 'Please enter your zip code.',
		'required' => true,
		'defaultValue' => '',
		'size' => '8',
		'columnName' => 'Zip'
	));
	
	$form->addField(array(
		'name' => 'phone',
		'label' => '*Phone:',
		'type' => 'text',
		'errorMessage' => 'Please enter your phone number.',
		'required' => true,
		'defaultValue' => '',
		'size' => '10',
		'columnName' => 'Phone'
	));
	
	$form->addField(array(
		'name' => 'fax',
		'label' => 'Fax:',
		'type' => 'text',
		'errorMessage' => 'Please enter your fax number.',
		'defaultValue' => '',
		'size' => '10',
		'columnName' => 'Fax'
	));

	$form->addField(array(
		'name' => 'email',
		'type' => 'text',
		'label' => '*Email:',
		'errorMessage' => 'Please enter a valid email address.',
		'required' => true,
		'validate' => 'Email'
	));

	$form->addField(array(
		'name' => 'hear_about_us',
		'type' => 'textarea',
		'label' => 'How did you hear about us?',
		'defaultValue' => '',
		'cols' => '30',
		'rows' => '5',
		'columnName' => 'ReferredBy',
		'validate' => 'spam',
		'errorMessage' => 'Please don\'t type any of the following text in the "How did you hear about us?" box: "cc:", "multipart", "[url", "Content-Type:", or "href".'
	));

	$form->addField(array(
		'name' => 'preferred_dates_html',
		'type' => 'html',
		'defaultValue' => '<h2>Preferred Dates</h2>'
	));
	
	$form->addField(array(
		'name' => 'arrival_date',
		'label' => 'Arrival Date:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'ArrivalDate'
	));
	
	$form->addField(array(
		'name' => 'departure_date',
		'label' => 'Departure Date:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'DepartureDate'
	));

	$form->addField(array(
		'name' => 'dates_flexible',
		'type' => 'radio',
		'label' => 'Are these dates flexible?',
		'options' => array('y' => 'Yes', 'n' => 'No'),
		'columnName' => 'DatesFlexible'
	));

	$form->addField(array(
		'name' => 'pattern_flexible',
		'type' => 'radio',
		'label' => 'If yes, is arrival/departure pattern flexible?',
		'options' => array('y' => 'Yes', 'n' => 'No'),
		'columnName' => 'PatternFlexible'
	));
	
	$form->addField(array(
		'name' => 'preferred_location',
		'label' => 'Preferred Location:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'PreferredLocation'
	));
	
	$form->addField(array(
		'name' => 'attendance',
		'label' => '*Attendance:',
		'type' => 'text',
		'defaultValue' => '',
		'required' => true,
		'columnName' => 'Attendance'
	));
	
	$form->addField(array(
		'name' => 'guest_rooms',
		'label' => '*No. of Guest Rooms Required:',
		'type' => 'text',
		'defaultValue' => '',
		'required' => true,
		'columnName' => 'RoomsRequired'
	));
	
	$form->addField(array(
		'name' => 'day',
		'label' => 'Day:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'Day'
	));
	
	$form->addField(array(
		'name' => 'dates',
		'label' => 'Dates:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'Dates'
	));
	
	$form->addField(array(
		'name' => 'no_of_rooms',
		'label' => 'No. of Rooms:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'NumRooms'
	));
	
	$form->addField(array(
		'name' => 'meeting_space',
		'label' => 'Meeting Space:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'MeetingSpace'
	));

	$form->addField(array(
		'name' => 'requirements',
		'type' => 'textarea',
		'label' => 'Requirements',
		'defaultValue' => '',
		'cols' => '30',
		'rows' => '5',
		'columnName' => 'Requirements',
		'validate' => 'spam',
		'errorMessage' => 'Please don\'t type any of the following text in the Requirements box: "cc:", "multipart", "[url", "Content-Type:", or "href".'
	));

	$form->addField(array(
		'name' => 'spec_sheet_html',
		'type' => 'html',
		'defaultValue' => '<p><i>(Forward mtg. Spec sheet if more convenient)</i></p>'
	));

	$form->addField(array(
		'name' => 'exhibit_space_html',
		'type' => 'html',
		'defaultValue' => '<h2>Exhibit Space Requirements</h2>'
	));
	
	$form->addField(array(
		'name' => 'gsf',
		'label' => 'GSF:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'GSF'
	));
	
	$form->addField(array(
		'name' => 'nsf',
		'label' => 'NSF:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'NSF'
	));
	
	$form->addField(array(
		'name' => 'exhibit_move_in',
		'label' => 'Move In Days:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'MoveInDays'
	));
	
	$form->addField(array(
		'name' => 'exhibit_show_days',
		'label' => 'Show Days:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'ShowDays'
	));
	
	$form->addField(array(
		'name' => 'exhibit_move_out',
		'label' => 'Move Out Days:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'MoveOutDays'
	));
	
	$form->addField(array(
		'name' => 'food_beverage',
		'label' => 'Food and Beverage Requirements:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'FoodAndBeverage'
	));
	
	$form->addField(array(
		'name' => 'other_requirements',
		'label' => 'Other Key Space or Guest Room Requirements:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'KeySpace'
	));
	
	$form->addField(array(
		'name' => 'other_cities',
		'label' => 'Other cities you are considering for this meeting:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'OtherCities'
	));

	$form->addField(array(
		'name' => 'history_html',
		'type' => 'html',
		'defaultValue' => '<h2>Meeting History</h2>'
	));
	
	$form->addField(array(
		'name' => 'history_year',
		'label' => 'Year:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'Year'
	));
	
	$form->addField(array(
		'name' => 'headquarters_hotel',
		'label' => 'Headquarters Hotel:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'HQHotel'
	));
	
	$form->addField(array(
		'name' => 'room_pick_up',
		'label' => 'Room Pick Up:',
		'type' => 'text',
		'defaultValue' => '',
		'columnName' => 'RoomPickup'
	));
	
	$form->addField(array(
		'name' => 'decision_date',
		'label' => '*Decision Date:',
		'type' => 'text',
		'defaultValue' => '',
		'required' => true,
		'columnName' => 'DecisionDate'
	));
	
	$form->addField(array(
		'name' => 'criteria',
		'type' => 'textarea',
		'label' => 'Criteria for choosing a location for this meeting:',
		'defaultValue' => '',
		'cols' => '30',
		'rows' => '5',
		'columnName' => 'Criteria',
		'validate' => 'spam',
		'errorMessage' => 'Please don\'t type any of the following text in the "Criteria for choosing a location for this meeting" box: "cc:", "multipart", "[url", "Content-Type:", or "href".'
	));

	$form->addField(array(
		'name' => 'lead_request_html',
		'type' => 'html',
		'defaultValue' => '<p>The Wilmington/Cape Fear Coast CVB will send your request only to those properties and facilities that meet the criteria listed. If you prefer to only have a meeting planner\'s guide sent, please indicate by checking the box below.</p>'
	));
	
	$form->addField(array(
		'name' => 'comments',
		'type' => 'textarea',
		'label' => 'Comments:',
		'defaultValue' => '',
		'cols' => '30',
		'rows' => '5',
		'columnName' => 'Comments',
		'validate' => 'spam',
		'errorMessage' => 'Please don\'t type any of the following text in the Comments box: "cc:", "multipart", "[url", "Content-Type:", or "href".'
	));
	
	$form->addField(array(
		'name' => 'only_guide',
		'type' => 'checkbox',
		'label' => 'Only send me a meeting planner\'s guide.',
		'columnName' => 'GuideOnly',
		'defaultValue' => 'F',
		'checkboxValues' => 'T:F'
	));

	$form->addField(array(
		'name' => 'second',
		'type' => 'text',
		'label' => 'Leave this box blank!',
		'validate' => 'blank',
		'defaultValue' => '',
		'errorMessage' => 'Please do not enter anything where the form says, "Leave this box blank!"'
	));
	
	$form->init();
	
	// Load the CMS Template
	define('TEMP_DIR', realpath('../../phpapps/tmp/') . '/');
	$loader = new CMS_Template_Loader('meeting_planners_guide', 'http://' . $_SERVER['HTTP_HOST'] . '/groups/_request-meeting-planners-guide', 1800);
	$loader->set('<!--{MAIN_CONTENT}-->', '<?=$content ?>');
	$loader->load();
	
	$tpl =& new Template(TEMP_DIR);
	$tpl->set('content', $form->getDisplayString());
	echo $tpl->display('_cms_template_meeting_planners_guide.tpl.php');

?>