Dreamweaver MX 2004 Recipe: In/Out Dashboard
This chapter is from the book
This chapter is from the book
This chapter is from the book
One of the first rules of business is to keep a close eye on all your assets—and employees are among an organization's primary assets. The In/Out Dashboard application provides a visual representation of the location for all intranet employees. With the Dashboard, you can instantly tell if an employee is in the office, in a meeting, on the road, or wherever. With minor modifications, this application can also serve to keep track of virtually any asset, such as training tapes, laptop computers, or even company cars.
Because the Dashboard is a natural employee-gathering place, it's a good location to display company-wide announcements. Such announcements need to be timely and well managed; corporate messages released before their time can be damaging to business, and those left too long on display lessen the impact of the other notices.
To support the Dashboard and its announcement section, this application uses four pages in all. One page provides the main interface for the in/out board and message section; a bullet character in a particular status column designates an employee's status. A necessary function of any such application is the ability to easily alter an employee's status; in our application, each employee's name on the in/out board is linked to a detail record where the status updates can be made. Two pages are used to administer the announcement section—one to manage the announcements in general, designating which ones should be displayed and which should be deleted; and another page for adding announcements.
Ingredients
4 Application Pages:
-
2 User Pages
-
In/Out Dashboard
-
Update Status
-
2 Administration Pages
-
Manage Announcements
-
Add Announcement
1 Data Source:
-
1 Database with:
-
3 Tables
-
Dashboard—Dashboard tracks each entry in the Dashboard by employee ID, the current status, and each time the status is changed.
-
Announcements—Announcements maintains the announcement text, its active date, and whether or not it should be displayed.
-
Status—Status contains each of the available status options, by ID and name. This table is used primarily to populate list elements.
-
Employees—Reference is made to this table, so it needs to be included here for clarity.
-
1 View
-
EmployeeDashboard—This is a virtual table joining the Announcements, Dashboard, and Status tables.