Completed

House construction database

We need a PHP/MySQL application to help us manage home building. We are currently using spreadsheets like the ones attached to manage this process, but want to move to a web-based database solution. We want to use a db schema like the one attached (see [url removed, login to view]). Small or critical changes to that schema are acceptable, but we have to approve those changes. The code should allow the user to add items to any of the databases (customers, houses, lots, etc.), as well as editing and updating existing information. Users should also be able to delete records while maintaining the db integrity (i.e., make sure links to the deleted record don't screw up the code). Users should be able to generate reports for viewing on the web that replace the attached spreadsheets. The concept is to have the database center around a house and have all the info associated with it -- customer, subdivision, scanned documents, schedule, permits, change orders, etc. -- accessible via the web browser, so that we can: a) quickly check to see if something has been done, b) quickly locate a (usually scanned) document that we might need (such as a change order), c) generate a variety of reports telling us where things stand (obviously this particular bid will not include "all" possible reports :) ). d) Add a file name (with or without path) and have it added to that house's information. This does NOT mean to upload the file; the files we want to "attach" or associate with a house are already on the file server, and already available to the user on the local network. e) Click on the name of the scanned files and have the proper viewer launch to attempt to view the file name given on the local network (Open Office, xpdf, planner, etc.) This db will be the central point around which we manage the field work of the company. We want this designed carefully so that it is flexible enough for us to add more stuff to it (that we want to track).

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Target platform is Linux, running MySQL, Apache, and PHP. All development should be done in PHP (no Java, etc.), though shell scripts are OK for the installation process only. NO GUI is involved here, and we are ONLY willing to look at web-based, MySQL+PHP+Apache solution, running on Linux. NOTHING else.

Skills: Engineering, Linux, MySQL, PHP, Software Architecture, Software Testing

See more: work at home database, web development home office, variety of houses, track deliverables, small office solution, process orders at home, per house, need a house planner, i want to hire a party planner, in house legal, i need a party planner, hire a party planner, document viewer application, customer database php mysql, construction work, be construction, seller central us, linux shell scripts, i hire construction, central seller

About the Employer:
( 2 reviews ) United States

Project ID: #3127635

Awarded to:

florentin

See private message.

$1020 USD in 14 days
(105 Reviews)
7.7

21 freelancers are bidding on average $827 for this job

vastalitech

See private message.

$850 USD in 14 days
(34 Reviews)
5.9
artemkhojoyan

See private message.

$425 USD in 14 days
(15 Reviews)
5.1
harune

See private message.

$510 USD in 14 days
(13 Reviews)
5.0
biny83

See private message.

$1020 USD in 14 days
(16 Reviews)
4.9
veravw

See private message.

$739.5 USD in 14 days
(27 Reviews)
4.9
letregrandecoder

See private message.

$637.5 USD in 14 days
(38 Reviews)
4.7
thecodebusters

See private message.

$552.5 USD in 14 days
(9 Reviews)
4.0
itmasksystemsvw

See private message.

$1275 USD in 14 days
(2 Reviews)
3.4
sergoovw

See private message.

$467.5 USD in 14 days
(17 Reviews)
3.2
holmdel

See private message.

$807.5 USD in 14 days
(1 Review)
0.0
umerash

See private message.

$637.5 USD in 14 days
(0 Reviews)
0.0
zeljkotomicvw

See private message.

$935 USD in 14 days
(0 Reviews)
0.0
tokoloshe

See private message.

$2125 USD in 14 days
(0 Reviews)
0.0
amitpadhyevw

See private message.

$637.5 USD in 14 days
(0 Reviews)
0.0
axerasoftware

See private message.

$1275 USD in 14 days
(0 Reviews)
0.0
splashwr

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
nablavw

See private message.

$510 USD in 14 days
(0 Reviews)
0.0
tintin21vw

See private message.

$850 USD in 14 days
(0 Reviews)
0.0
rtuttle

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
vadimpvw

See private message.

$1232.5 USD in 14 days
(0 Reviews)
0.0