Who will do this for less than $100?
I have a database with a project tracking table and a contact table that I need
to output to two seperate formatted pages with "sort", "search", with a login
and a welcome page to select contacts or projects pages from.
"edit", and "add" functions. All users may view "all" or "user1" "user2" etc..
Users may add anyting but only edit entries they created.
"Contacts" should not be user editable period. updates will be
performed using a db manager or on
the cli.
PHP/MySQL scheme preffered, although any programming type is acceptable.
Concise simple code only, no fluff or complex operations please.
Project Tracking should use css and tables, no graphics neccesary,
only color coding of rows (which should be setup in css but left blank
for my customization)
It should be arranged as follows with the status field being a
different color for different status levels (there being 4 total).
"sort" by status +/- user +/- either date field.
------------------------------------------------------------------------------
User Jeff
Status Post-Bid
Name Classroom Addition Westside High School
Date Bid 8/3/2005
Contacted 8/17/2005
Bidders [co. name and ph1 and fax1] from contact table
[co. name and ph1 and fax1] from contact table
[co. name and ph1 and fax1] from contact table
[co. name and ph1 and fax1] from contact table
[co. name and ph1 and fax1] from contact table
[co. name and ph1 and fax1] from contact table
etc, as many as neccessary
Contractor [Co. Name, selectable by a drop down box related to the contact table]
Items H20=9.6k, Ampco=4.8k, HT=2k, NEBB=9k Starters=5k
Notes Rock said the low H20 was $3,900, Dennis TAB was $5700, high on stack,
low on starters and VFDs.
Try Calling Lowery in one week to follow-up
Blah Blah Blah
Files: upload button to add files to be related to this project
------------------------------------------------------------------------------
Contact Databse should use css and tables as well, no graphics
neccesary, only color coding of rows.
I would like the Colors of each entry to alternate, set this up in
CSS, but leave it blank and I will fill in as needed later.
I would also like <br><hr><br> betwen each entry as well.
A "show only" option which shows specific state name and associated
region (selectable from a drop down box or hyperlink) is required.
Entry on drop down box or hyperlink would be State"-"Region
------------------------------------------------------------------------------
Region
Name area-code+phone1 area-code+Fax1 contactname1 c1notes
Streetaddr. area-codephone2 area-code+Fax2 contactname2 c1notes
city, State zip area-codephone3 area-code+Fax3 contactname3 c1notes
area-codephone4 area-code+Fax4 contactname4 c1notes
POaddress area-codephone5 area-code+Fax5 contactname5 c1notes
city, state zip area-codephone6 area-code+Fax6 contactname6 c1notes
area-codephone7 area-code+Fax7 contactname7 c1notes
notes: varchar 255
project: [insert "user" "status" and "name"] from project table if this contractor
is listed as THE contractor in the project table
-------------------------------------------------------------------------------- |