Here is my scenario. I work for a fire department. While this project is not in dire need of being done immediately we would like it done soon. I posted project over a month ago and winning provider promised in 4 days. After 1 month of emails he never replied again after promising and promising it to be done.
We have a total of 8 stations in our township. I want to try and keep a communication line open between all of the stations with a "Status Web Page". I already have the domain purchased and what I am looking for is a simple index page with 8 boxes (1 per station) to show any needed news and important information for each station - much like in the file located at [url removed, login to view] Except all headings should be District instead of Station (District 2, District 3, etc)
I plan on having each station keep their browser window open at that page and I would set it up with an auto refresh (every 10 - 15 minutes or so)
Now the real work... getting the data in
I figured it would require the use of a database and thought it might be able to utilize a PHP Include to pull the data from the database into the page.
First and foremost I am database illiterate so I would not be able to assist at all with that. We would need a form page so that each station could input the relevant data to be included onto the main page. My thought is to have users assigned with special permissions to a add info for their respective stations. I would also like to have an admin user (ME) to have the ability to edit all sections like I have here [url removed, login to view]
In addition to having the ability to place info into their respective station boxes I also want the users to have the ability to delete a note they place on the site (So when a street is closed, they can log in to delete the note)
Some other notes I would like to bring to your attention....
-If at all possible I would like to make the main screen be so that a person does not have to scroll in order to view all of the information. I understand this may be hard to do because a lot will depend on how much info each person places in their station's section. The reason I say this is because...some stations plan on using a spare computer and mounting a monitor on the wall in their station to display info so a lot of stations will not have the ability to use a mouse to scroll and look through information on the page.
-I am open to suggestions as to how the best way for people to log in. I would assume that me as the admin I would be able to assign usernames and passwords via the admin page but I would also like to be able to assign specific permissions for each username. My plan is to have only one username per station giving them permission to only edit their own station info but I would also like to have the ability to create an additional admin account (or username that could edit multiple station areas) in the event i would like to provide access to our dispatching center.
- It would also be nice if each entry can have a small time/date stamp after it (maybe in a smaller font and red in color) so we know when the info was added.
I am open to any suggestions and although I understand this may be a big job I have to ask to be kind with bids as my fire department has no budget for this project (I am taking it on myself and will be paying any fees out of my own pocket like domain name and web hosting and such) I just want to do this as a safety feature for all firefighters in my town.