Project Specification Sheet

colonteeΛογισμικό & κατασκευή λογ/κού

4 Νοε 2013 (πριν από 3 χρόνια και 11 μήνες)

199 εμφανίσεις

Project Specification Sheet



Project Title:

Luck Truck Services, LLC


Project URL:

www.lucktruck.com


Scripting Language:

PHP


Database:

MYSQL




Project Scope




We are wanting

to develop a database of apartments that we have a preferred
relationship with.


To do this, we will need for you to build the following components:


1) Input form
-


It would essentially be a form with the various fields we would want to
capture for each

apartment complex (area of town, price range, phone numbers,
address, property description, etc).


It would also have an area where we could upload
photos to the database which would be attached to each apartment community
record.


There would be a fold
er on our website which the photos would be uploaded
to.


I have attached a very rough draft of the type of information we will collect in this
form, this is not the final document, but it should give you an idea for the estimate.


Once we have filled out
the form and submit it, the following would occur:

A) A new record for the new apartment community would be created and saved to our
database.

B) A new PHP page would be created and saved to our website which would be based
on a master template (which we w
ould provide).


Each PHP page would essentially pull
from the Master Template & the Database to create the page.


These PHP pages would
contain only a small sampling of the data collected in the Input form and would look
something like the following link:


http://www.lucktruck.com/apartments/houston/galleria/gables_6464_sanfelipe.html


If at any point in the future we wanted to change the master template, all pag
es that we
had created in the past would reflect this change.


Also, any change to the Apartment
Database would also reflect changes in the individual pages.


Page Title

Meta Description

Meta Keywords

Header Title

Property Name

Street Address

City

State

Zip

Year Built

Phone

Fax

Hours

Number of Units

Number of Floors

School District

Elementary

Middle

High

Application Fee

Area of Town (menu where you can select multiple entries


list of areas in separate
spreadsheet)


Pets

Cats


Pull Down (Yes, No)

Dogs


Pull Down (Yes, No)

Pet Weight Restriction


(Pull Down
-
None,15,20,25,30,35,40,45,50,55,60,65,70,75,80,90,95,100)


Apartment Option 1

Type


(pull down: Studio/Efficiency, 1 Bedroom, 2 Bedrooms, 3+ Bedrooms)

Beds/Baths Option 1
-

Pull Down Menus (0,1
,2,3,4 bedrooms) + (1, 1.5, 2, 2.5, 3, 3.5, 4
baths)

Square Feet Option 1


“Square Feet Minimum”


“Square Feet Maximum”

W/D Option 1


Pull Down Menu (W/D Connections, Stacked Machines Included, Full
Machines Included, On
-
Site, None)

Rent Range Option 1


“Rent Range Minimum”


“Rent Range Maximum”

Deposit Option 1

Floorplan 1 Option 1

Floorplan 2 Option 1

Floorplan 3 Option 1

Floorplan 4 Option 1

Floorplan 5 Option 1


Apartment Option 2

Type Option 2


(pull down: Studio/Efficiency, 1

Bedroom, 2 Bedrooms, 3+ Bedrooms)

Beds/Baths Option 2
-

Pull Down Menus (0,1,2,3,4 bedrooms) + (1, 1.5, 2, 2.5, 3, 3.5, 4
baths)

Square Feet Option 2


“Square Feet Minimum”


“Square Feet Maximum”

W/D Option 2


Pull Down Menu (W/D Connections, Stacked

Machines Included, Full
Machines Included, On
-
Site, None)

Rent Range Option 2


“Rent Range Minimum”


“Rent Range Maximum”

Deposit Option 2

Floorplan 1 Option 2

Floorplan 2 Option 2

Floorplan 3 Option 2

Floorplan 4 Option 2

Floorplan 5 Option 2



Apartment Option 3

Type Option 3


(pull down: Studio/Efficiency, 1 Bedroom, 2 Bedrooms, 3+ Bedrooms)

Beds/Baths Option 3
-

Pull Down Menus (0,1,2,3,4 bedrooms) + (1, 1.5, 2, 2.5, 3, 3.5, 4
baths)

Square Feet Option 3


“Square Feet Minimum”


“Square
Feet Maximum”

W/D Option 3


Pull Down Menu (W/D Connections, Stacked Machines Included, Full
Machines Included, On
-
Site, None)

Rent Range Option 3


“Rent Range Minimum”


“Rent Range Maximum”

Deposit Option 3

Floorplan 1 Option 3

Floorplan 2 Option 3

Flo
orplan 3 Option 3

Floorplan 4 Option 3

Floorplan 5 Option 3



Apartment Option 4

Type Option 4


(pull down: Studio/Efficiency, 1 Bedroom, 2 Bedrooms, 3+ Bedrooms)

Beds/Baths Option 4
-

Pull Down Menus (0,1,2,3,4 bedrooms) + (1, 1.5, 2, 2.5, 3, 3.5, 4
baths)

Square Feet Option 4


“Square Feet Minimum”


“Square Feet Maximum”

W/D Option 4


Pull Down Menu (W/D Connections, Stacked Machines Included, Full
Machines Included, On
-
Site, None
)

Rent Range Option 4


“Rent Range Minimum”


“Rent Range Maximum”

Deposit Option 4

Floorplan 1 Option 4

Floorplan 2 Option 4

Floorplan 3 Option 4

Floorplan 4 Option 4

Floorplan 5 Option 4



Apartment Option 5

Type Option 5


(pull down: Studio/Efficienc
y, 1 Bedroom, 2 Bedrooms, 3+ Bedrooms)

Beds/Baths Option 5
-

Pull Down Menus (0,1,2,3,4 bedrooms) + (1, 1.5, 2, 2.5, 3, 3.5, 4
baths)

Square Feet Option 5


“Square Feet Minimum”


“Square Feet Maximum”

W/D Option 5


Pull Down Menu (W/D Connections, St
acked Machines Included, Full
Machines Included, On
-
Site, None)

Rent Range Option 5


“Rent Range Minimum”


“Rent Range Maximum”

Deposit Option 5

Floorplan 1 Option 5

Floorplan 2 Option 5

Floorplan 3 Option 5

Floorplan 4 Option 5

Floorplan 5 Option 5



Apartment Option 6

Type Option 6


(pull down: Studio/Efficiency, 1 Bedroom, 2 Bedrooms, 3+ Bedrooms)

Beds/Baths Option 6
-

Pull Down Menus (0,1,2,3,4 bedrooms) + (1, 1.5, 2, 2.5, 3, 3.5, 4
baths)

Square Feet Option 6


“Square Feet Minimum”


“Square
Feet Maximum”

W/D Option 6


Pull Down Menu (W/D Connections, Stacked Machines Included, Full
Machines Included, On
-
Site, None)

Rent Range Option 6


“Rent Range Minimum”


“Rent Range Maximum”

Deposit Option 6

Floorplan 1 Option 6

Floorplan 2 Option 6

Flo
orplan 3 Option 6

Floorplan 4 Option 6

Floorplan 5 Option 6



Property Description


Text Box


Amenities and Features (check boxes)


Community Features

Fitness Center

Pool

Business Center

Assigned Parking

Perimeter Fence

Gated Entrance

Jacuzzi

Sauna

Tennis

Court

Racquetball

Vollyball

Play ground

Picnic Area

BBQ Grills

Club House

Game/Sport Room

Theater Room

Movie Library

Lofts

Townhomes

Dry Cleaning Service

Maid Service

Handicap Units

Elevators

Valet Service

On Site Guard


Individual Unit Features

Intrusion Alarms

High Speed Internet

Custom Kitchen Cabinets

Walk In Closets

Fireplaces

Ceiling Fans

Furnished

Cable Ready

Free Basic Cable

Free Basic Channels

Free Movie Channels

Patio/Balcony

Outside Storage

Large Tub

High Ceilings

Crown Molding

Custom
Carpet

Non Carpeted Floors

Custom Built
-
Ins

Miniblinds

Wet Bars

Microwaves

Ice Makers

Frost Free Refirgerators

Self Cleaning Ovens

Dishwashers

Disposals

Stainless Steel Appliances

Granite Countertops


Policies

Senior Living

Co
-
Signers

1
st

Time Renters

Broken Leases

Misdemeanors

Felons


Photo 1

Photo 2

Photo 3

Photo 4

Photo 5

Photo 6

Photo 7

Photo 8

Photo 9

Photo 10



Management Info


Management Company

Manager

Street Address

City

State

Zip

Phone

Fax

Email

Website


For the "Input Form"

--

We don't want
anyone having access to this form who might mess up our database,
etc.


So we would want to make a sign
-
in function so that this page can only be accessed
by authorized users.

--

We also would like to have the ability to allow the individual Apartment Comm
unity
Managers to edit their own pages, while only having access to their specific community
page.


So we would send them link to a Sign
-
In page and a Username an Password that
they could log in and view the details of ONLY their specific apartment communi
ty and
make changes and edits to the data in the database.

--

We would like the ability to edit and modify the information in the database, so
somehow we have to be able to search or have a list of communities in our database, so
that we can find an apartm
ent community's database record and edit or make changes
to the record.


This is how I think it might work best:


Sign
-
In Page

-

this page is where the user would input their username and password.


After sign
-
in it would go to one of two places:


1) For L
uckTruck staff
-

this page is where the user can choose to "Edit an Apartment
Community", "Add an Apartment Community", "Delete an Apartment Community", or
"Add User"


A) Edit an Apartment Community
-

if this is clicked a search tool would be presented:
Se
arch by Name, Area of Town, or Zip

B) Add an Apartment Community
-

the input form would be presented

C) Delete an Apartment Community
-

again a search tool would be presented, and once
the results are displayed the option to delete by clicking on a check b
ox would be
presented, with a warning to be sure that this is what is intended

D) Add User
-

a form for user name and password creation, plus a choice to give ALL
ACCESS or LIMIT ACCESS TO A SINGLE APARTMENT COMMUNITY.


If Limit Access is
chosen a pull dow
n menu for zip code is presented and based on the choice of zip code,
a list of apartments would be presented to choose from to assign to that password.


2) For Specific Community Users
-

If the username is for a specific community, then after
sign
-
in the
"Edit an Apartment Community" page would come up and allow the user to
edit ONLY that specific apartment community record.


We would like for the input form to follow the look of our website with our “LuckTruck”
header at the top and the clover background
images. See any page on our website for a
general idea.


Property Input Form


Property Name


Street Address

City

State


defaults as TX

Zip


Phone

Fax


Number of Units

Number of Floors


Hours


Year Built

Remodel Date


Metro Area



(Houston (default), Dallas, Fort Worth, San Antonio, Austin)

Geographic Area



Pull Down (Central Houston, West Houston, Northwest Houston,
Southeast Houston, North Houston, Southwest Houston, Northeast Houston


defaults
as blank)

Neighborhood/Communit
y Area

-

(menu where you can select multiple entries


list of
areas in separate spreadsheet. This menu has differing results based on what is
selected as the Geographic Area Above. In other words, if you select “West Houston”
you would see the results
for “Westchase, Memorial, Spring Branch,… etc” Please see
separate spreadsheet for all of the Neighborhoods for each Geographic Area. Defaults
as blank)



Community Features (checkboxes)

Fitness Center

Business Center

Theater Room

Club House

Game/Sport Room

Movie Library

Pool

Jacuzzi

Sauna

Tennis Court

Racquetball

Volleyball

Play ground

Picnic Area

BBQ Grills

Lofts

Townhomes

Handicap Units

Elevators

Valet Service

Dry Cleaning Service

Maid Service

Gated Entrance

Perimeter Fence

Patrol Service


Individual Unit Features (checkboxes)

Intrusion Alarms

High Speed Internet

Walk In Closets

Fireplaces

Patio/Balcony

Wet Bars

Large Tub

Mini
-
blinds

Custom Built
-
Ins

Custom Kitchen Cabinets

Microwaves

Ice Makers

Frost Free
Refrigerators

Self Cleaning Ovens

Dishwashers

Disposals

Stainless Steel Appliances

Granite Countertops

Ceiling Fans

High Ceilings

Vaulted Ceilings

Crown Molding

Custom Carpet

Non Carpeted Floors

Cable Ready

Free Basic Cable

Free Basic Channels

Free Movie
Channels

Outside Storage

Furnished



Parking/Bus (checkboxes)
Carport

Assigned Parking

Parking Garage

Detached garage

Attached Garage

Metro Bus

School Bus


Policies (all checkboxes, except as noted)
Application Fee

Short Term Leases

Senior Living

Co
-
Signers

1
st

Time Renters

Broken Leases

Misdemeanors

Felons

Section 8

Income Guidelines


Text Box

School Information (text boxes)

School District

Elementary

Middle

High


Pets

Cats


Pull Down (Yes, No


defaults as blank)

Dogs


Pull Down (Yes, No


defaults as blank)

Pet Weight Limit


(Pull Down
-
None,15,20,25,30,35,40,45,50,55,60,65,70,75,80,90,95,100


defaults as blank)

Pet Deposit
-

text box

Pet Notes


text box


Utilities (checkboxes)

Water Paid

G
as Paid

Cable Paid

All Utilities Paid


Property Description



Text Box


Apartment Options


Option 1

Beds
-

(0,1,2,3,4


defaults as blank)

Baths
-

(1, 1.5, 2, 2.5, 3, 3.5, 4


defaults as blank)

Square Feet Minimum

Square Feet Maximum

Washer/Dryer


(W/D

Connections, Stacked Machines Included, Full Machines Included,
On
-
Site, None


defaults as blank)

Rent Range Minimum

Rent Range Maximum

Deposit

Upload Floorplan

Add Additional Floorplan


(this will add another floorplan to upload and attach to thi
s
option)



Add Additional Apartment Option


(this will add another Option (example Option 2)
with the exact fields as in Option 1)



Photos

Upload Photo 1


Add Additional




Management Info (text boxes)


Management Company

Manager

Street Address

City

State

Zip

Phone

Fax

Email

Website


Commission Rate

Commission Notes

Pre
-
Register (Yes, No


defaults as No)

Escort (Required, None, For Higher Commission


defaults as None)

LRN Required (Yes, No


Defaults as No)


PHP Page Details

To be automatically
built after Input form submission


PAGE TEMPLATE

Please develop a template (common include) which can be applied to all of these pages
based on the following page:

http://www.lucktruck.com/apartments/houston/galleria/gables_6464_sanfelipe.html


IMPORTANT: If we are to ever want to change the template, it should apply to and
change all of the pages we have already created. (Common Include)


FOLDER LOCATIONS

All p
ages to be saved to a specific folder based on the choice of “Metro Area” on the
input form. Here are where the folders are located:


http://www.lucktruck.com/apartments/houston/

http://www.lucktruck.com/apartments/san_antonio/

http://www.lucktruck.com/apartments/austin/

http://www.lucktruck.com/apartments/dallas/

http://www.lucktruck.com/apartments/fort_worth/


For example, if on the input form the choice “Houston” then the PHP page would be
saved into

the “lucktruck.com/apartments/houston/” folder.


FILENAME

The filename should be named based on the property name which is entered on the
Input Form. So for example if the property name was “Gables on Kirby” then the file
name would be “Gables_on_Kirby.p
hp”


PAGE TITLE

The page title should use the following formula:


[Property Name] | Move Here For FREE | [Metro Area] Apartments


So it would read as an example like this:

Gables on Kirby | Move Here For FREE | Houston Apartments


META DESCRIPTION

The meta

description should use the following formula:


Get a FREE MOVE to [Property Name] in [Metro Area] or other apartments on our site.
Interested in a FREE MOVE to [Property Name]? You're In Luck, with LuckTruck
Apartment Locators!




META KEYWORDS

The meta

keywords should use the following formula:


[Property Name], [Property Name] [Metro Area], free move, move for free,
[Neighborhood/Community Area] apartments, [metro area] apartments, [metro area]
apartment locators, [metro area] apartment finder, lucktru
ck, luck truck


HEADER TITLE

This is the title in blue letters at the top right of the template link I sent you. This should
reflect the [Property Name]


The following is a list of pages that will be part of the newly revised website. Please
refer to the

JPG mockups that I have sent to get a general idea of how the site will
function.


The first quote that we are requesting is assuming that we provide you the basic PHP or
HTML page code for each page mentioned below, and you will make all of the
function
ality on each page work with our database. The second quote we would like is if
you develop and build all of the pages and hook up the functionality requested based on
our spec sheets, basic Word Documents with content, and JPG mockups.



Pages (these
descriptions are assuming that we provide you with the base PHP or
HTML page language, and you hook up the code to our database):

1)

Revised Homepage



See attached JPG mockup.

For this page, I will need for you to hook up the search form, which is displaye
d
on the homepage. This will also add the user to our email database


as our
current site does.

2)

Moving Quote Page



this will be a page with a form on it, which will collect
information and email the request to us at LuckTruck. It will also send out a
c
onfirmation email to the user that their request has been sent. I will need you
to make the form’s email functionality work.

3)

Advanced Search (Search Listings) Page



this form will be a more advanced
search than the basic search which is available on the homepage. When a user
submits this form, it will function like the homepage form, where it will create a
user account, add the users email to our email database, a
nd pull up a list of
matching results from the database. I will need for you to make this form work.

4)

Sign
-
In Page



this links from the homepage and will allow the user to sign in to
their existing account. The page will also have a link if they forget t
heir password
or email/UserID. I will need for you to make this page work with the database.

5)

Search Results Page



see attached JPG mockup.

This page will be displayed once the user does a basic search from the
homepage, or clicks on the advanced searc
h link on the homepage. The results
will appear and will be pulled from the database. The results can be sorted. The
results will be counted and displayed 10 to a page. The user will be able to page
through the results. Also, there will be the ability

to refine the search through
the form on the left side of the page. Where it says “LuckTruck Special Offer”
the system will run through a formula and display “FREE MOVE!” , “75% OFF
Your Move Cost”, etc for EACH APARTMENT COMMUNITY RESULT based on
commi
ssion information which is stored in the database. I can send you the
formula once we are ready.

6)

Listing Detail Page


see attached JPG mockup.

This page will display information which is stored in our database. The user will
be able to look through mult
iple pictures, view floorplans, etc. Again, where it
says “LuckTruck Special Offer” this will display “FREE MOVE” , “75% Discount”,
“25% Discount”, etc based on a formula which will calculate the result based on
information stored in our database. There
also will be the ability to “ADD to
Favorites” which will add this particular apartment community to the users
record as a favorite. When the user clicks on the “ADD Favorite” button, the
system will also run through a formula to see if that particular ap
artment
community has a certain tag that we have in our database “Pre
-
Register” or
“LRN”. If it does it the system will send us an email indicating that this
community was added to this users favorites list and it requires pre
-
registration
or LRN. Lastly
, the page will also have a “Map & Directions” tab. When this is
clicked the page will display (in the same place as the Property Details
information) a embedded map with the ability to get directions. I am not sure if
you can recommend a Map service


M
apQuest, GoogleMaps, Yahoo Maps, etc.
It must be embedded in the page and not a link to another separate page.

7)

Advanced Search Page


this page is similar to the page described in #3 however
this page will not create a new user account, but will simply tr
y and refine a
users search results and will be available once the user is logged in to their
account.

8)

Favorites Page



this page will display a list of the users favorites that they have
chosen. It will also have the ability to select one of their favori
tes and schedule
their move.

9)

My LuckTruck.com Page
-


this page will show a short summary of the users
information. They will be able to view their favorites, view scheduled moves,
etc. Mockup for this page still in the works. Basically this page will p
ull from the
database various information which we will need for you to make work.

10)

Schedule My Move Page


this page will start off looking like the My Favorites
page, where a list of favorites will be displayed. The user will need to select one
of their
favorites to schedule their move to, and then they will be directed to a
form where they will fill in their move information. This will function similarly to
our existing website, where after submission, we will receive an email and the
user will receive
a confirmation email.

11)

Moving Rates Page


this will be a basic text page which we will provide text for.

12)

OTHER PAGES THAT ALREADY EXIST ON OUR PREVIOUS WEBSITE


these pages
already exist on our existing website and will also be part of the new website
rev
ision


we will make small edits to these pages.

a.

5 Simple Steps

b.

What we Move for Free

c.

FAQ’s

d.

Disclaimers

e.

About Us


New Front End

(all pages listed below in this front end will use HF3


see explanation at end of this
document)

(this front end will replace
all existing front end content once complete and will reside
at http://www.lucktruck.com/):



Revised Homepage



For this page, I will need for you to hook up the search form, which is displayed
on the homepage. The form will have the following behavior:

o

T
he form will collect the following information:



First Name (required)



Last Name (required)



Metro Area (required)



Neighborhood



Min Price



Max Price



Bedrooms (required)



Approximate Move Date



Email (required


validate that it is a valid format for email)



Password (required)

o

When a User submits the form, the users First Name, Last Name, Metro
Area, and Email Address will be added to our iContact Database

o

The user will be sent a welcome HTML email

o

When a User submits the form, based on the choice for “Metro
Area” the
user will be logged in and redirected to one of two possible backends:



Backend 1


this is the existing backend on our current working
site. A user who is logged into this backend will use the site as it is
currently today. There is NO developm
ent needed with this site
and it will function as today.



Backend 2


this is the new backend we are developing with you
and described in this proposal below

o

Based on the selection for metro area, the user will be redirected to the
following:



Houston


Back
end 2



Dallas


Backend 1



Ft. Worth


Backend 1



San Antonio


Backend 1



Austin


Backend 1



Moving Quote Page



this will be a page with a form on it, which will collect
information and email the request to us at LuckTruck. It will also send out a
confirmat
ion email to the user that their request has been sent. I will need you
to make the form’s email functionality work.



Advanced Search (Search Listings) Page



this form will be a more advanced
search than the basic search which is available on the homepage
. When a user
submits this form, it will function like the homepage form, where it will create a
user account, add the users email to our email database, and pull up a list of
matching results from the database. I will need for you to make this form work
.



Sign
-
In Page



this links from the homepage and will allow the user to sign in to
their existing account. The page will also have a link if they forget their password
or email/UserID. I will need for you to make this page work with the database.


Back
end 2

(All of these pages will use HF4


see explanation below)


1)

Search Results Page



This page will be displayed once the user does a basic search from the
homepage, or clicks on the advanced search link on the homepage. The
results will appear and
will be pulled from the database. The results can be
sorted. The results will be counted and displayed 10 to a page. The user will
be able to page through the results. Also, there will be the ability to refine
the search through the form on the left si
de of the page. Where it says
“LuckTruck Special Offer” the system will run through a formula and display
“FREE MOVE!” , “75% OFF Your Move Cost”, etc for EACH APARTMENT
COMMUNITY RESULT based on commission information which is stored in
the database. I

can send you the formula once we are ready.

2)

Listing Detail Page

This page will display information which is stored in our database. The user
will be able to look through multiple pictures, view floorplans, etc. Again,
where it says “LuckTruck

Special Offer” this will display “FREE MOVE” , “75%
Discount”, “25% Discount”, etc based on a formula which will calculate the
result based on information stored in our database. There also will be the
ability to “ADD to Favorites” which will add this pa
rticular apartment
community to the users record as a favorite. When the user clicks on the
“ADD Favorite” button, the system will also run through a formula to see if
that particular apartment community has a certain tag that we have in our
database “Pre
-
Register” or “LRN”. If it does it the system will send us an
email indicating that this community was added to this users favorites list
and it requires pre
-
registration or LRN. Lastly, the page will also have a “Map
& Directions” tab. When this is cli
cked the page will display (in the same
place as the Property Details information) a embedded map with the ability
to get directions. I am not sure if you can recommend a Map service


MapQuest, GoogleMaps, Yahoo Maps, etc. It must be embedded in the pag
e
and not a link to another separate page.

3)

Advanced Search Page


this page is similar to the page described in #3
however this page will not create a new user account, but will simply try and
refine a users search results and will be available once the us
er is logged in to
their account.

4)

Favorites Page



this page will display a list of the users favorites that they
have chosen. It will also have the ability to select one of their favorites and
schedule their move.

5)

My LuckTruck.com Page
-


this page will
show a short summary of the users
information. They will be able to view their favorites, view scheduled moves,
etc. Mockup for this page still in the works. Basically this page will pull from
the database various information which we will need for you
to make work.

6)

Schedule My Move Page


this page will start off looking like the My
Favorites page, where a list of favorites will be displayed. The user will need
to select one of their favorites to schedule their move to, and then they will
be directed t
o a form where they will fill in their move information. This will
function similarly to our existing website, where after submission, we will
receive an email and the user will receive a confirmation email.

7)

Moving Rates Page


this will be a basic text p
age which we will provide text
for.



Header / Footer Explanation:


These are the various header and footers for the site. These will be developed and
provided to One World, there is no work involved with these and they are for your
information only:


HF1

(Header/Footer #1)



Existing front end of our current website. This will be
replaced HF2 when we publish the new front end. This Header / Footer will no longer be
used and will be deleted.


HF2



this is the existing header footer for the existing site
backend (backend 1). This
will be used for backend 1.


HF3



this will be the new front end Header / Footer and will replace HF1.


HF4



This will be the header footer for the new backend (backend 2) and will display on
all search results and listing det
ail pages


Tabs



Search by Neighborhood



loads a metro area and neighborhood pull downs,
can select multiple neighborhoods, loads amenities and features below



Search by Zip Code



loads a zip code box, loads amenities and features below



Search by Street
Name



loads a metro area pull down & a text box to enter
street name, loads amenities and features below



Search by Property Name



prompts only for property name


(Amenities & Features)


Min Price

Max Price

Bedrooms (required)

Bathrooms

Pets
(No Pr
eference, Cats OK, Dogs OK,
Cats/Dogs OK)

W/D
(defaults as blank, W/D Hookups,
W/D Included)

Unit Features: (two columns, checkboxes)
Walk in Closets

Fireplaces

Patio/Balcony

Hardwood/Laminate Flooring

Dishwashers

Intrusion Alarms
Community Features: (two columns, checkboxes)

Fitness Center

Pool

Club House

Tennis Courts

Newer Community (less than 10 yrs old)
Handicap Units

Senior Living

Offers Short Term Leases


Will Accept: (two
columns, checkboxes)

Co
-
Signers

1
st

Time Renters

Broken Leases

Section 8
(For the Advanced Search for the Front End


the following would load before the
search button)

Create Account:

First Name

Last Name

Email Add
ress

Password

Anticipated Move Date:


SEARCH



Moving Quote Form:


Please fill out and submit the following form to obtain a quote for your moving needs.
Once submitted, a LuckTruck Movers representative will contact you within 1 business
day to discuss
your moving estimate.


Contact Information:

First name

Last name

Email Address

Phone Number

Best Time to Call (Anytime, Daytime, After 5)


Starting Address:

Street Address

City, State ZIP


Location Type: (Apartment, House , Office


radio buttons)


Number

of Bedrooms?


Job Size? (Small, Medium, Large


Radio Buttons)


Destination:

Street Address

City, State ZIP


Special Instructions:



SUBMIT



DB of Moving Companies Tab


The following tab will list moving companies that we work with. Each entry in the l
ist
will have the following:


Moving Company Name, Metro Area, Main Phone Number,
View/Edit
,
Delete


There will also be an option to Add New, at which point a form with the following info
will be brought up.


Moving Company Name

Representative


Moving
Company Mailing Address

City, State, Zip

Metro Area


Phone Number

Fax

Dispatch Number


Website

Moving Company Email


TxDot Number:


Moving Records


This document should describe the new Moving Records database (or table) I would like
to build to contain th
e “Moving Records” for the company. This does not have to be a
separate database, but the information in this needs to be separate of the information
already in the system. The reason for this is that when a customer of ours schedules a
move on the site,

I would like to create a Moving Record, with its own unique ID
number, which will record all of the details of the moving transaction. With this system,
each contact record can reference multiple Moving Record ID numbers. So if we have
customers who move

with us multiple times, then we will have multiple moving records
associated with them, and we will have their full moving history in our database.


For example, we will need to add the following field to a persons contact record,
“Moving Records”. This

field will contain the unique record number or numbers of the
persons moves with us. For example: Jane Doe, Moving Records = 11134, 11155; John
Simmons, Moving Records = 11156.


When a customer schedules a move on our website (see Schedule Move Form)
, a new
moving record will be created, and the moving record ID will be recorded into their
contact record. The following are the fields that will make up the Moving Records
Database:


Additional Pick Up Charge

Additional Pick Up Location

Additional Pick
Up Location City

Additional Pick Up Location State

Additional Pick Up Location Street Address

Additional Pick Up Location Zip

Apartment Community ID

Box Charges

Client Cell Phone

Client Day Phone

Client Email

Client First Name

Client Last Name

Commission C
ollected

Date of Request

Destination Apartment Community Name

Destination City

Destination Commission Rate

Destination Flat Rate

Destination Floor Level

Destination Number of Bedrooms

Destination Other Commission or Bonus

Destination State

Destination Stre
et Address

Destination Unit Number

Destination Zip

Estimated Moving Expense

Estimated Moving Hours

Final Collect

Final Collect Notes

Fuel Charge

Heavy Oversized Items

Heavy Oversized Items Total

High Level Dropoff Cost

High Level Pickup Cost

Invalid Notes

Invoice Amount Due

Invoice Amount Paid

Invoice City

Invoice Contact First Name

Invoice Contact Last Name

Invoice Date

Invoice Email

Invoice Fax

Invoice Number

Invoice Paid Date

Invoice Phone

Invoice State

Invoice Street Address

Invoice Zip

Lease Term

Leasi
ng Agent Name

Metro Area

Monthly Lease Amount

Move Profit

Move Rate Lock

Moving Comments

Moving Company Assigned

Moving Record ID

Notes

Origin City

Origin Floor Level

Origin Number of Bedrooms

Origin State

Origin Street Address

Origin Unit Number

Origin
Zip

Promotion

Requested Move Date

Requested Move Time

Scheduled Move Date

Scheduled Move Time

Status

Total Collect

Trip Charge Lock


Schedule Move Form


This form is to be used for the new backend only (Houston


Backend 2). This should
not be used in the

existing backend.


(page 1)


Schedule My LuckTruck™ Move

Once you have an accepted lease application, please proceed with the following to
schedule your LuckTruck Move:


Please select your chosen apartment community from your Favorites list:

(pull

down list of customers favorites list


can only choose one) (this will be the
Destination Apartment Community Name) (it will also determine the Apartment
Community ID)


Number of Bedrooms:

(pull down with Studio/Efficiency, 1 Bedroom, 2 Bedroom, 3+
Bedr
ooms, defaults with the customers bed preference) (this will be the Destination
Number of Bedrooms)


(Check box) I have listed LuckTruck on my guest card and/or lease application.

(If this is
not checked a warning message states “LuckTruck must be listed
on your Guest Card
and/or Lease Application to qualify for your Free or Discounted Move.”)


[NEXT

]
-

when this is clicked, the user is directed to Page 2, I would prefer that a
moving record not be created until finishing the form on page 3)



(page 2)


LuckTruck Special Offer:

Congratulations! Your qualify for a (Promotion)
(display is either LuckTruck Free Move,
75% Discount Off Your Move Costs, 50% Discount Off Your Move Costs, 25% Discount
Off Your Move Costs, 10% Discount Off Your Move Costs, 5% D
iscount Off Your Move
Costs) (calculated with the promotion formula based on the community name and
destination number of bedrooms stated on the previous page) (this value will also be
saved as the “Promotion” field when the moving record is created)


(if
Promotion equals free move, then display the following in smaller typeface)

*Some charges may apply, see our “What We Move for Free” page for more details.

(links to this page content in a small pop up window, no header, just text of page)


[Accept & Cont
inue

]


(if Promotion DOES NOT EQUAL free move, then display the following)

Moving Cost Estimate


Number of Bedrooms: (destination number of bedrooms)
(equals number of bedrooms
specified on previous page, display only)(saved as destination number of bedro
oms in
moving record once created)

Estimated Hours to Complete:
(See Formula B, display only, saved as Estimated Moving
Hours in moving record once created)

LuckTruck Hourly Rate:
(equals MovingRate, display only, saved as Move Rate Lock in
moving record o
nce created)

Trip Charge:
(equals TripCharge, display only, saved as trip charge lock in moving record
once created)

Estimated Total (Regular Rate):
(See Formula D, display only, not saved into database)


Your Savings:

(savings = total collect


regular
rate, display only, value not saved into
database)

Your Estimated Cost:
(See Formula C, display only, saved as Total Collect in moving
record once created)


*This figure is an estimate only. The number of hours can vary greatly depending on
weather, wait
ing time, oversized or bulky items, long drives (over 15 miles), additional
pick
-
up locations, long distances between the unit and the truck parking area, etc. This
figure should only serve as an estimate for an average in
-
town move.


[Accept & Continue

]



(page 3)


Moving Details

Please provide us with the details of your move request:


Name on Lease:
(auto populates with what is stored in our contact record for this client,
saved into moving record)

First Name: (Client First Name)

Last Name: (Client L
ast Name)



Leasing Information (for your new apartment):

Lease Term: (lease term)

Monthly Rent:


(monthly lease amount)

Leasing Agent Name (person who helped you): (leasing agent name)


Contact Information

Work (Day) Phone: (Client Day Phone)

Cell Phone:

(Client Cell Phone)

E
-
Mail: (Cleint Email)
(auto populates with email in existing client record)


Move Date

Requested Move Date: (Requested Move Date)


Preferred Moving Time: (requested move time)


Origin (current address):

Street Address (origin street
address)


Apartment/Unit # (origin unit number)


City (origin city)

State (origin state)

Zip (origin zip)

Number of Bedrooms

(origin number of bedrooms)

Floor Level (origin floor level)


Destination (new apartment)

Apartment Community Name (destination co
mmunity name)
(auto populates from
selection on page 1)


Street Address (destination street address)


Apartment/Unit # (destination unit number)

City (destination city)
(auto populates with apartment community city)

State (destination state)
(auto populate
s with apartment community state)

Zip (destination zip)
(auto populates with apartment community zip)


Floor Level (destination floor level)


(if promotion equals Free Move, display the following heavy oversized items checklist)

Heavy/Oversized Items (not
included, $15 per item):

(checkboxes)

China Cabinet

BBQ Grill

Sleeper Sofa

Grandfather Clock

Big Screen TV (Over 36 In)

Armoire/Entertainment Centers

Weight Bench w/Weights or Fitness Equipment

Washer/Dryer

Refrigerator/Freezer

Aquarium (Empty)



Do you have any additional pick up locations?
(pull down yes or no, defaults as no)(if
yes display address box below)

Additional Pick Up Location:

Street Address (additional pick up location street address)

City (additional pick up location city)

State (ad
ditional pick up location state)

Zip (additional pick up location zip)


Comments:
(moving comments)

(text box)



(Checkbox) I have read and understand the LuckTruck “Disclaimers” page
. (if promotion
equals free move display the following sentence also)

I
have also read and understand
the “What We Move for Free” page.
(links to both pages as a popup window with the
text from these pages (no header info), this must be checked, warning reads “Please
indicate that you have read and understand the LuckTruck D
isclaimers page.”)


[Submit Request

]

When the request is submitted, the following occurs:

-

A moving record is created with a unique ID number (Moving Record ID)

-

All of the data collected on Pages 1, 2 & 3 will be saved into the moving record

-

The Date of R
equest field will be auto populated with the date month date and
year that the submission occurs

-

The Status field will be marked as “Move Request Received”

-

The Apartment Community ID field will be auto populated with the apartment
community ID that is sto
red in our apartment database

-

The Metro Area field will be auto populated with the metro area for the
apartment community that was chosen (destination apartment community)

-

An email is sent to
schedule@lucktruck
.com

notifying us that a new move
request is now waiting in the LuckTruck Staff area for review.

-

The moving record ID number is recorded into the clients regular contact record
in a field Moving Records


Formula A


if

Destination Commission Amount does not equal 0

then Commission Collected = Monthly Lease Amount * Destination Commission Amount

if Destination Commission Amount equals 0 and Destination Flat Rate does not equal
zero

then Commission Colleted = Destination

Flat Rate

else print 0



Formula B


if Destination Number of Bedrooms = studio/efficiency, then Estimated Moving Hours =
StudioHours

if Destination Number of Bedrooms = 1, then Estimated Moving Hours = 1BedHours

if Destination Number of Bedrooms = 2, t
hen Estimated Moving Hours = 2BedHours

if Destination Number of Bedrooms = 3, then Estimated Moving Hours = 3BedHours



Formula C


if Promotion = 75% discount, then discount = .25

if promotion = 50% discount, then discount = .5

if promotion = 25% disco
unt, then discount = .75

if promotion = 10% discount, then discount = .90

if promotion = 5% discount, then discount = .95

if Destination Number of Bedrooms = studio/efficiency, then hours = studiohours

if Destination Number of Bedrooms = 1 bedroom, then ho
urs = 1bedhours

if Destination Number of Bedrooms = 2 bedroom, then hours = 2bedhours

if Destination Number of Bedrooms = 3 bedroom, then hours = 3bedhours

total collect = ((Move Rate Lock*hours) + Trip Charge Lock)*discount



Formula D


if

Destination Number of Bedrooms = studio/efficiency, then hours = studiohours

if Destination Number of Bedrooms = 1 bedroom, then hours = 1bedhours

if Destination Number of Bedrooms = 2 bedroom, then hours = 2bedhours

if Destination Number of Bedrooms = 3
bedroom, then hours = 3bedhours

regular rate = ((movingrate*hours) + tripcharge)



Pending Move Requests Tab


This page will have two lists. The first list will be “New Requests.” The second list will
be “Waiting for Signed Confirmation.” It will
display similar to the following:



Pending Move Requests


New Requests


-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------


Waiting for Signed Confirmation


-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------

-------



Under each heading will be different lists as described below:


New Requests

Under this header, a list is displayed of all records with the Status fie
ld marked as “Move
Request Received.” The results are displayed in list form, with the following
information: Client Name, Metro Area, Apartment Community Name, Date of Request,
Requested Move Date. There will also be an option to “View/Edit”, if you cl
ick this it
brings up the detail page for each of these requests. The detail page will have the
following information on it:


Please verify the following information with the Apartment Community before sending
the verification form. If no comm
ission is offered, proceed to schedule move.


Community Information:
(pulled from apartment database, editable, saved back to
apartment database)
Community Name

Street Address

City, State Zip

Community Email

Community Phone

Community Fax

Manag
er First Name

Manager Last Name


Lease Information:
(pulled from Moving Records Database, editable, saved back to
moving records database)
Client First Name

Client Last Name

Client Day Phone

Client Cell Phone

Client Email



Destination Street Address

City, State Zip

Destination Number of Bedrooms

Destination Floor Level

Monthly Lease Amount

Lease Term

Leasing Agent Name


Commission Information:
(pulled from Apartment Database, editable, saved back to
apartment
database)

Commission Rate

Flat Rate

Other Commission or Bonus

Commission Notes

Minimum Lease Term

Pre
-
Register

Notification Preference

Escort

LRN Required


[Save & Email Verification Form]



saves any changes to the above information into the
database, and generates an email with the Verification form (see note below & separate
word document) attached to the email. The email is sent to the Community Email
Address. The status field is also
changed to “Waiting for Signed Confirmation.” Also,
the values for the following fields area copied into the Moving Record as follows:
Commision Rate = Destination Commission Rate, Flat Rate = Destination Flat Rate, Other
Commission = Destination Other C
ommission.

[Save & Fax Verification Form]



saves any changes to the above information into the
database, and generates a fax with the verification form (see note below & separate
word document) to the fax number listed as Community Fax. The status field
is also
changes to “Waiting for Signed Confirmation.” Also, the values for the following fields
area copied into the Moving Record as follows: Commision Rate = Destination
Commission Rate, Flat Rate = Destination Flat Rate, Other Commission = Destination
Other Commission.

[Save & Schedule Move]



saves any changes and brings up the “Schedule Move” form
described below. Also, the values for the following fields area copied into the Moving
Record as follows: Commision Rate = Destination Commission Rate, Fla
t Rate =
Destination Flat Rate, Other Commission = Destination Other Commission.

[Invalid Move Request
]


saves any changes and brings up a new page where the user is
asked to enter in notes on why the request was invalic (Invalid Notes). Once the user
en
ters in some notes, they click “Save” This does the following: marks the status field
as “Invalid Move Request, Name not Properly Listed”, and also sends an HTML email to
the client email notifying them of the status. (Email template to be provided later
)

[Save Changes]


saves any changes to the above information into the database, returns
user to the Pending Move Requests tab.




Waiting for Signed Confirmation

Under this header, a list is displayed of all records with the Status field marked
as
“Waiting for Signed Confirmation.” The results are displayed in list form, with the
following information: Client Name, Metro Area, Apartment Community Name, Date of
Request, Requested Move Date. There will be an option to “View/Edit”, which will
dir
ect you to the detail page above. There will also be an option to “Schedule Move” if
you click this it brings up a schedule move form as follows:


Schedule a Move


-------------------


(if LuckTruck Promotion Offered is “Free Move”


then display the foll
owing information
on the page)

Moving Details
Customer Name
(first & last, display only)

Requested Move Date
(display only)

Requested Move Time
(display only)

Origin Address:
(editable)

Street Address

City, State Zip

Number of Bedrooms
(display only)

Origin Floor Level
(display only)

Destination Address:
(editable)

Street Address

City, State Zip

Number of Bedrooms
(display only)

Destination Floor Level
(display only)

Heavy/Oversized Items:

(list any items

checked on Move Request form, display only)


Additional Pick Up Location:

(YES or NO, display only)


Additional Pick Up Location Address:
(editable)

Street Address

City, State, Zip


Moving Comments:
(displays any comments the client submitted on the Move
Request
form, display only)


Commissions and Fees

LuckTruck Promotion Offered: (Promotion)

Commission Paid: (Commission Collected)
(see Formula A)

Other Commission or Bonus: (Destination Other Commission or Bonus)

Estimated Moving Expense for LuckTruck: (E
stimated Moving Expense)
(if
studio/efficiency is selected, then Estimated Moving Expense = MCS, if 1 bed, then
Estimated Moving Expense = MC1, 2 bed = MC2, 3 bed = MC3, editable)


Estimated Collection from Customer:


Heavy/Oversized Items:
(Heavy Items To
tal)

($15 for each check box checked on move
form, displays total here, field can also be edited)

Fuel Surcharge / Mileage Charge ($3 per mile):

(Fuel Charge)
(blank text box)

Additional Pick Up Locations & Mileage Charges ($50 + $3 per mile):

(Additional Pick
Up)
(blank text box)

Above Second Floor Pickup:

(Pickup Cost)
(if origin floor level = 3, then print “25”, if
origin floor level = 4, then print “50”, field can also be edited)

Above Second Floor Drop Off:

(Dropoff Cost)
(if destination
floor level = 3, then print
“25”, if origin floor level = 4, then print “50”, field can also be edited)


Total Estimated Collect from Customer:

(Total Collect)
(totals the above fields, saves
value as Total Collect in moving record)


Estimated Profit

Esti
mated Profit: (Move Profit)
(Move Profit = Commission Collected + Total Collect


Moving Expense)


Booking Details:


Moving Company:

(Moving Company Assigned)
(pull down, displays moving companies
stored in our system


separate module discussed later)

(th
e following fields are auto populated with values from the moving company module,
these fields are editable and any changes are saved back into the moving company
module)

Moving Company Name

Moving Company Contact

Phone

Fax

Email


Scheduled Move Date:

(scheduled move date)
(ability to fill in month, date, year)

Scheduled Move Time:

(scheduled move time)

(pull down: 7am, 8am, 9am, 10am,
11am, 12pm, 1pm, 2pm, 3pm, 4pm, 5pm, 6pm, 7pm, 8pm)


Moving Record Notes:

(notes)


-------------------------


(if Luc
kTruck Promotion Offered does NOT equal “Free Move”


then display the
following information on the page)

Moving Details
Customer Name
(first & last, display only)

Requested Move Date
(display only)

Requested Move Time
(display only)

Origin Address:
(editable)

Street Address

City, State Zip

Number of Bedrooms
(display only)

Origin Floor Level
(display only)

Destination Address:
(editable)

Street Address

City, State Zip

Number of Bedrooms
(display only)

Destination Floor Level
(display only)

Additional Pick Up Location:

(YES or NO, display only)


Additional Pick Up Location Address:
(editable)

Street Address

City, State, Zip


Moving Comments:
(displays any comments the client submitted on the Move Reques
t
form, display only)


Commissions and Fees

LuckTruck Promotion Offered: (Promotion)

Commission Paid: (Commission Collected)
(see Formula A)

Other Commission or Bonus: (Destination Other Commission or Bonus)

Estimated Moving Expense for LuckTruck: (Estimat
ed Moving Expense)
(if
studio/efficiency is selected, then Estimated Moving Expense = MCS, if 1 bed, then
Estimated Moving Expense = MC1, 2 bed = MC2, 3 bed = MC3, editable)


Estimated Collection from Customer:


Estimated Moving Hours:
(Estimated Moving Hours)
(Editable)

Total Estimated Collect from Customer:

(Total Collect)
(Editable)


Estimated Profit

Estimated Profit:

(Move Profit)
(Move Profit = Commission Collected + Total Collect


Estimated Moving Expense)


Booking Details:


Movin
g Company:

(Moving Company Assigned)
(pull down, displays moving companies
stored in our system


separate module discussed later)

(the following fields are auto populated with values from the moving company module,
these fields are editable and any change
s are saved back into the moving company
module)

Moving Company Name

Moving Company Contact

Phone

Fax

Email


Scheduled Move Date:

(scheduled move date)
(ability to fill in month, date, year)

Scheduled Move Time:

(scheduled move time)

(pull down: 7am, 8am, 9am, 10am,
11am, 12pm, 1pm, 2pm, 3pm, 4pm, 5pm, 6pm, 7pm, 8pm)


Moving Record Notes:

(notes)


------------------------------

(the following button will be at the bottom of both versions of the schedule move page)


[Save & Book Move]



when this is clicked the following occurs:

-

the status is changed to “Move Confirmed & Scheduled”

-

a unique HTML email is sent to the moving company email (template to be sent
to you)

-

a unique HTML email is sent to the client email (template to be sent to

you)



Verification Form


The verification form mockup is attached as a separate document in this proposal.


This document is either faxed or emailed. I am not sure how you can do this, but if we
can electronically fax, that would be the most preferred.

If we cannot do this then we
need to be sent the email with the subject line to Fax this document.


1) Based on fields stored in the database and a template a PDF document is generated
(in the case of the Pending Moves Tab, we are generating a Verificatio
n Form PDF)

2) The PDF that is generated is stored as part of the Moving Record. For the Pending
Moves tab, we can add a new field "Verification Form" to the Moving Record and store
this PDF there.

3) Based on the users preference, the PDF document is then

either emailed or faxed.


If
it is emailed, an email is generated (template to be provided) with the PDF as an
attachment.


If the preference is to fax, then the following occurs:



An email is generated with the PDF attached



The subject and body of the ema
il are left blank



The from email address is
faxes@lucktruck.com



The to email address is the (community fax number)@
efaxsend.com
.


The
database stores the

fax number in the following format XXX
-
XXX
-
XXXX.


The
format for the fax number in the email address is 1XXXXXXXXXX.


You will need
to develop some code to take the fax number in the database, and generate an
email address
1XXXXXXXXXX@efaxsend.com
.