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.
The attached txt file contains the specs in case your email
reader
has made the following hard to read because of line wrap
around.
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.
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.
_______________________________________________
freebsd-questions freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-que
stions
To unsubscribe, send any mail to
"freebsd-questions-unsubscribefreebsd.org" |