Accepting Bids on Web application programming Development contract
fbsd_user
fbsd_user at a1poweruser.com
Tue Jan 31 11:25:57 PST 2006
To all interested parities;
I am accepting bids on a Web application programming Development
project.
Bids are open to any developer any where in the world.
Bid closing date is February 8 2006.
Work is to be done at your location and using your equipment.
Please provide your quote in USA dollars and include elapse
time table targets in weeks.
In case your email reader has made the following hard to read
because of line wrap around, Email me direct and I will send the
specs as attached text file.
Real Estate Multipliable Listing Service Web application.
General Specs.
Run using FreeBSD 6.0 / apache 1.3.33_2 / php 5.1.2 / mysql 5.0.18
The membership info and the real estate info will be separate
databases in MySql.
Estimated the sizes at 5000 members and 25000 real estate
properties.
All web pages will use same template so user sees same page header
and trailer
and background color.
Header contains name of Business with line of clickable menu
options.
Footer will contain copyright statement & icons for powered by
FreeBSD, apache, php.
All php code will be commented in English. There can never be to
many comments,
the more the better.
All php code will be written in a expanded manner for easy of
reading.
Each php function and (if statement will have comments describing
what it does)
All php variables will be descriptive words of content or use in
English
All html post forms data fields will use English words.
Source code will be reviewed by customer for compliance to above
general standards.
Project will be divided in to phases by application functions and
customer acceptance
testing before payment. Completed source code will be sent to
customer as pkzip or tar
file attached to email. Yahoo chat will be used for live
project meeting to discuss
problems or changes to project specs.
Directory path location to mysql databases will be global variable
which is part of
include.
Directory path to .php files is php global variable (DOCUMENT_ROOT)
which is part of
include.
Get the user ip address from the php global variable
(REMOTE_ADDR) which is part of
include.
Access to real estate record in mysql database must be set up is
such a way that a URL
can be created to display the info. Customer needs URL for
inclusion in newspaper media
advertising so interest persons can enter that URL in their
browser and retrieve the
information.
Home page named index.php
Have visitor counter which shows count just about footer.
Content will be provided later.
Will have links to these functions
Register customer function. (seller, or agent, or broker)
Register buyer for online auction bidding
Register email notify robot agent. (user enters city or zip code
and when any
real estate gets lists in their interest area a html
email with pictures
Register for opt/in emailing for sales info from advertisers
offering mortgages,
pre-quailing buyers, real estate
lawyers/brokers/agents/appraisers Ect.
Registered user login to edit their content (called maintenance
function).
Search function (City name search, price range search, zip code
search)
Display real estate on auction block.
Contact function- email website sales dept with general questions
FAQ function- simple html page containing all the questions as
links to jump
deeper into page where answer details are. Content
provided later.
Product detail page. simple html page containing all the products
as links to
jump deeper into page where details are. Content
provided later.
Register function common specs
All register sign up functions will use the same basic form and the
data will
be saved in mysql database.
A hidden flag field will be used to distinguish between what type
of register it is.
Customer (Seller or agent or broker)
Opt/in to receive advertisings
Notifications robot
Online auction bidder
Privacy statement about use of data entered.
Common Info to capture = first name, last name, address line1 &
line2, city,
state/province, zip code.
Valid email address which will trigger a standard email to person
which he
has to reply to confirm email is valid. When conformation is
received, the
registered persons database record gets auto updated to
authorize user access.
As security measure a little box with generated password in it has
to be
entered into empty box as tool to stop script kiddies
automatically creating
registered users in effort to dos (deny of service) by
filling up all the disk space.
The Register's IP address will be saved with the data base record.
The date in yyyymmdd will be saved with the data base record.
Register Customer (Seller or agent or broker) function.
[[background info] This group will be allowed to create a real
estate record
describing the property in detail after email conformation
is successful.
They will have to login using maintenance function to load
the data or to
edit the data. This real estate record will be in separate
database.]
Additional data to collect = home phone number, work phone number,
cell
phone number, agent/broker license number, Login user ID
alphanumeric 8
positions & password, size minimum 6 positions, maximum 10
positions.
Have to inquire membership database to verify entered ID is
not used already.
Password will be written in encrypted form.
Display scroll box containing usage Agreement/contract with radio
button for
agree or decline. If no agree then do not register. Content
provided later.
Make this content as included php function so the contents
can be easily
changed at any time.
Register Opt/in to receive advertisings
Display scroll box containing Opt/in Agreement/contract with radio
button
for agree or decline. If no agree then do not register.
Content provided later.
Make this content as included php function so the contents
can be easily
changed at any time.
Set flag to identify this user as opt/in advertising user.
Append record to flat text file containing email address and first
& last
name to feed opt/in software.
Register Notifications robot
Capture notification values (City name, price range, zip
code)
Set flag to identify this user as Notifications robot user.
Register Online auction bidder
Display scroll box containing Online auction bidder
Agreement/contract with
radio button for agree or decline. If no agree then do not
register.
Content provided later. Make this content as included php
function so the
contents can be easily changed at any time.
Set flag to identify this user as Online auction bidder user.
Registered user login
Maintenance function to delete or change the content of there
membership
database record and or their real estate database record.
User entered login ID & password has to match what is on file.
Login screen must have same security measure as register screen
If user is Opt/in or Notification can only delete or edit contents
of
their membership record.
If user is auction bidder. This is handled pretty much the same way
as the
search by city function, but this time you search the real
estate record
database for the auction field = yes.
Results is an list array. Each line containing thumbnail picture
if there
is picture with that real estate record and street address
and starting bid
price and current bid price with date /time it was make.
Clicking on any
line will launch screen showing full real estate data
record. The user can
enter his bid price which is saved in the real estate record
along with
his user id. After the bid price is updated in the database
a email is sent
to the registered owner of that property telling them a bid
has been offered
and the bid price.
If user is Seller or agent or broker they get 2 options.
Every time user login, update the last logged in date and time
fields
in their membership record.
Option 1 = delete or edit contents of their membership record.
Deleting membership record forces the delete of all
associated real estate database records.
When user selects delete, reply with message are you
sure you want to do this, then delete.
Option 2 = delete or edit contents of their real estate database
records.
Seller is allowed only 1 real estate record.
Agent/broker
have no limit on number of real estate
records. Each real
estate record will be issued a unique
record number starting at
3525000. Member id + record number is
key to fetch record.
If no record then show empty form for user to fill in.
Data to capture = property address, county/province
title/parcel number,
date added in yyyy/mm/dd, total sq ft, lot
dimension, year built in
yyyy/mm/dd, about another 30 data fields to
be provided later. Option to
include max of 5 jpg pictures which is
stored as part of the real estate
record. Provide function to browse user pc
for jpg file location and
download jpg file for addition to real
estate record . One picture must
be identified as primary display picture to
be displayed with real estate
record data. Other pictures can be seen by
user clicking of picture
icon which is part of the displayed real
estate screen.
Option 3. display activity counter for each read real
estate record.
Results is an list array. Each line
containing thumbnail picture
if there is picture with that real estate
record and street
address and price and count of how many
times this was viewed.
There is an special unrestricted Admin user named "Boss" with
password of "robert7734".
There is no membership record for this user. This is hard
coded into php included
variables. Only the owner/webmaster will have access to the
servers raw .php data
file to manually edit these values. Some admin function will
be added later in the
development.
Admin Option 1. enter user id to select membership record display
all
membership record fields including user
type flags, creation
date, last logged on date and time,
include ability to display
real estate records. Delete or change
content of displayed real
estate records or Delete or change
content of displayed
membership record.
Admin Option 2. See what is needed during development.
Search function (City name search, price range search, zip code
search).
Any visitor to web site can search database for properties.
Results is an list array. Each line containing thumbnail picture if
there is
picture with that real estate record and street address and
price. Clicking on
any line will launch screen showing full real estate data
record. From detail screen
clicking on browser back button will return to search results
screen.
Search options = show all records matching city, or show all
records matching zip
code, or show all records matching city and
price range, or show all
records matching zip code and price range.
Any time the detail real estate record is shown
add one to the viewed
counter in the record. See www.realtor.com
for example of what I am
talking about.
Display real estate on auction block.
This is handled pretty much the same way as the above search by
city function, but this
time you search the real estate record database for the
auction field = yes.
Results is an list array. Each line containing thumbnail picture if
there is picture
with that real estate record and street address and starting
bid price. Clicking on any
line will launch screen showing full real estate data record.
>From detail screen
clicking on back record will return to search results screen.
Offline functions.
1. Provide file containing mysql definition statements.
2. Provide command line php script to do mysql backup of each
database used in application.
3. Provide command line php script to do mysql restore of each
database used in application.
4. Provide command line sh shell script to do an tar dump with
compression of each database.
5. Provide command line sh shell script to do an tar restore with
uncompress of each database.
6. Provide command line php script to roll through the membership
database selection all the
opt/in members and sent them a email with message built from
text content contained in flat
file.
7. Provide command line php script to roll through the membership
database selecting all the
seller/agent/brokers members who have not logged in, in the
past 90 days and sent them a
email with message built from text content contained in flat
file. Set the valid email flag
so they have to reply to the email to confirm their email is
active and working.
8. Provide command line php script to roll through the membership
database selecting all the
seller/agent/brokers members. For each one access their real
estate records to get number
times viewed and sent them a email with message built from text
content contained in flat
file showing how many times each property was viewed since
added.
General design thoughts.
The use of 2 mysql databases is not cast in concrete. Willing to
listen to your recommendations.
Open to your recommendations on how best to configure environment to
result in simple URL to point to individual real estate property web
page. www.nnnnnnnnnn.sitedomainname.com where nnnnnnnnnn is the
real estate record number without using dns, or
www.sitedomainname.com/aliasname/nnnnnnnn.
If after reading my specifications you have any recommendations or
coding standards or ideas to make things easier or processing
faster, I am willing to discuss them.
Phase one includes index.php and Register Customer (Seller or agent
or broker) function, and Registered user login for
seller,agent/broker maintenance function. 1/4 of project cost
payable on customer testing and approval.
Phase two all other registration functions and their maintenance
function. 1/8 of project cost payable on customer testing and
approval.
Phase three all the search functions and auction function. 1/8 of
project cost payable on customer testing and approval.
Phase four all remaining functions and offline functions delivered
by target deliver date. 1/8 of project cost payable on customer
testing and approval.
1/8 of project cost payable on customer testing and approval after
60 days of application stress testing and the fixing of any bugs
that come to light.
Final 1/4 of project cost payable on customer accepting complete
system as bug free.
All payment will be in USA dollars by check mailed to your post
office mailing address.
More information about the freebsd-questions
mailing list