From cdb90e3df62d60914bbbba4599e24495c3751883 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Fri, 12 Sep 2014 09:04:53 -0400
Subject: [PATCH] Update the report builder to have new options

Bring in options from their old site that they had in their older
contact database.
---
 Toolkit/Contacts/Admin/EditContact.php |  2 +-
 admin/Contact/contact_setup.inc        | 40 +++++++++++++++++++-------
 2 files changed, 30 insertions(+), 12 deletions(-)

diff --git a/Toolkit/Contacts/Admin/EditContact.php b/Toolkit/Contacts/Admin/EditContact.php
index b535447..b50e0e6 100644
--- a/Toolkit/Contacts/Admin/EditContact.php
+++ b/Toolkit/Contacts/Admin/EditContact.php
@@ -603,7 +603,7 @@ class Toolkit_Contacts_Admin_EditContact
         $e[] = array(
             'type'    => 'advcheckbox',
             'req'     => false,
-            'name'    => 'twinsok',
+            'name'    => 'twinok',
             'display' => 'Twin Ok',
             'opts'    => 'Yes',
             'val'     => array(0, 1)
diff --git a/admin/Contact/contact_setup.inc b/admin/Contact/contact_setup.inc
index b3b704b..5abba8d 100755
--- a/admin/Contact/contact_setup.inc
+++ b/admin/Contact/contact_setup.inc
@@ -479,16 +479,35 @@ $lodging     = array(
     'Trout Creek Condominiums'    => 'Trout Creek Condominiums',
     'Hamlet Village Condominiums' => 'Hamlet Village Condominiums'
 );
-$DB_fields[] = array("name" => "city", "title" => "City", "type" => "text");
-$DB_fields[] = array("name" => "state", "title" => "State", "type" => "state");
-$DB_fields[] = array("name" => "zip", "title" => "Zip", "type" => "text");
-$DB_fields[] = array("name" => "phone", "title" => "Phone", "type" => "text");
-$DB_fields[] = array('name' => "alt_phone", 'title' => "Alternate Phone", 'type' => "text");
-$DB_fields[] = array("name" => "fax", "title" => "Fax", "type" => "text");
-$DB_fields[] = array("name" => "email", "title" => "Email", "type" => "text");
-$DB_fields[] = array("name" => "mail_ok", "title" => "Mail Ok?", "type" => "radio");
-$DB_fields[] = array('name' => "comments", 'title' => "Comments", 'type' => "textarea");
-$DB_fields[] = array('name' => "discover", 'title' => "Discover Big Fore", 'type' => "drop", 'drop' => $discover);
+$DB_fields[] = array( 'name' => "create_date",		'title' => "Create Date",		'type' => "static");
+$DB_fields[] = array( 'name' => "fname",			'title' => "First Name",		'type' => "text");
+$DB_fields[] = array( 'name' => "lname", 			'title' => "Last Name", 		'type' => "text");
+$DB_fields[] = array( 'name' => "company", 		'title' => "Company Name",		'type' => "text");
+$DB_fields[] = array( 'name' => "address", 		'title' => "Address",			'type' => "text");
+$DB_fields[] = array( 'name' => "address2", 		'title' => "Address 2", 		'type' => "text");
+$DB_fields[] = array( 'name' => "city", 			'title' => "City",				'type' => "text");
+$DB_fields[] = array( 'name' => "state", 			'title' => "State", 			'type' => "state");
+$DB_fields[] = array( 'name' => "zip", 			'title' => "Zip",				'type' => "text");
+$DB_fields[] = array( 'name' => "phone", 			'title' => "Phone", 			'type' => "text");
+$DB_fields[] = array( 'name' => "alt_phone",		'title' => "Alternate Phone",	'type' => "text");
+$DB_fields[] = array( 'name' => "fax", 			'title' => "Fax",				'type' => "text");
+$DB_fields[] = array( 'name' => "email",			'title' => "Email", 			'type' => "text");
+$DB_fields[] = array( 'name' => "mail_ok",			'title' => "Mail Ok?",			'type' => "radio");
+$DB_fields[] = array( 'name' => "arrival", 		'title' => "Arrival",			'type' => "text");
+$DB_fields[] = array( 'name' => "departure", 		'title' => "Departure", 		'type' => "text");
+$DB_fields[] = array( 'name' => "golfers",			'title' => "Golfers",			'type' => "text");
+$DB_fields[] = array( 'name' => "nongolfers",		'title' => "Non Golfers",		'type' => "text");
+$DB_fields[] = array( 'name' => "pquote",			'title' => "From Price Quote",	'type' => "radio");
+$DB_fields[] = array( 'name' => "lodging",			'title' => "Lodging",			'type' => "drop",	'drop' => $lodging);
+$DB_fields[] = array( 'name' => "couples",			'title' => "Couples",			'type' => "text");
+$DB_fields[] = array( 'name' => "singles",			'title' => "Singles",			'type' => "text");
+$DB_fields[] = array( 'name' => "bathrooms",		'title' => "Bathrooms",			'type' => "text");
+$DB_fields[] = array( 'name' => "rooms",			'title' => "Rooms",				'type' => "text");
+$DB_fields[] = array( 'name' => "beds",			'title' => "Beds",				'type' => "text");
+$DB_fields[] = array( 'name' => "twinok",			'title' => "Twin Ok",			'type' => "radio");
+$DB_fields[] = array( 'name' => "sleepersofaok",	'title' => "Sleeper Sofa Ok",	'type' => "radio");
+$DB_fields[] = array( 'name' => "comments",		'title' => "Comments",			'type' => "textarea");
+$DB_fields[] = array( 'name' => "discover",		'title' => "Discover Big Fore",	'type' => "drop",	'drop' => $discover);
 $DB_fields[] = array("name" => "contact_type", "title" => "Contact Type", "type" => "drop2", "drop" => $cType);
 // $fields are used for building the query page
 foreach ($DB_fields as $key => $value) {
@@ -509,4 +528,3 @@ $data['bailout'] .= "wish to receive future items of this nature, please reply t
 $data['bailout'] .= "with the word \"CANCEL\" on the subject line. You will then be removed ";
 $data['bailout'] .= "from future mailings.<br>";
 $data['bailout'] .= "<a href=\"mailto:" . OWNER_EMAIL . "?subject=CANCEL\">" . OWNER_EMAIL . "</a><br>";
-?>
-- 
2.17.1