Home

Calendar

Download

Design

Calendar is a Web-based calendar application
It schedules multiple users, events, and assets
It uses the SQLite Database to keep track of information and file maintenance

Maintenance:
You can set up the calendar to meet your particular needs.
-- Users. You can assign users with privleges. They can be restricted to look at the calendar, or add schedules.
-- Assets. You can maintain assets. For an office environment, you may have conference rooms or coppy rooms etc.
For a manufactuning facility you may want to maintain work centers, equipment, work crews, or operatons.
Medical facilities may want to maintain schedules on x-ray rooms, MRI, equipment schedules, and work groups.
-- Events. Schedule events like holidays and vacations.

Drill Doqn.
You can search using wild cards on any scheduling parameter.

Running the system..

Login

The first thing you need to do is log in. The system comes with a admin user. The user/pass is admin/admin. Once you are setup you may want to delete this user or at least change the user/pass for better security.

LOGIN
UserName
Password:

Menu

Once logged in, the menu appears.
Depending on your privleges some menu's may not appear or within a menu some drop down items may not appear.

1 Admin Data

Calendar Schedule

2009-04-18

Calendar 5 Calendar 8 Scheduled Time

Maintenance 6 Translate Tables (xlate) 7 Asset

Security 1 Users 2 User System xref 3 Systems

Heading..
You can [Login] again.
Shows the current logged in user
Shows the current date
You can [Exit] to the previous web page. I

Menu : Calendar Selection : Calendar

This is a detail list of schedules.
[Exit Calendar] - Go back to the menu
[Add] Add a

Option	Action
[Exit Calendar]	Go back to main menu
[Add]	Add a schedule
[Calendar]	Show graphic calendar
[Help]	Help messages (up to you to change this to your needs)
Records	Displays the total number of schedules
Pages	Displays the total number of pages. This depends on the number of records devided by the [Lpp] Lines per page
[Prev]	Go to the previous page
Page number	You can change this and go directly to that page by clicking [Next]
[Next]	Go to the next page
[Lpp]	Change the number of lines per page.. The default is 25
Sort Drop down	Select the sort sequence from the drop down list
[Sort]	Sort schedules according to the selected drop down
Sort seq	Shows the current sort sequence - in this case SchNum sequence
[Search]	Go to the Drill down search screen

Menu : Calendar - Selection : Schedule Time

This is a condensed version of the calendar.

By clickiing on the day number, it will show the detail schedules begining with that date.

Apr 2009
Sun	Mon	Tue	Wed	Thr	Fri	Sat
			No Asset Event User From To 3 Com A met 2 08:30 09:30 8   met 2 05:44 06:44
No Asset Event User From To 9     2 07:46:40 08:46:40 10     3 08:01:53 08:01:53

Adding a Schedule.

You can add schedules for any asset, event, or user.
You enter the begin and end date and time.
[D] A date popup to help select dates.
[T] A time popup to help select time.

Knowing how much time you need, you can find all available open times slots that allow your schedule

Calendar Maintenance
SchNum	Auto Assigned
UserNum	1 Admin Data 2 Bobby BackBone 1 Admin Data 3 Demo System *None*
SchBeg
SchEnd
AssetNum	*None* 1 Conference Room A 2 Conference Room B 6 Meeting Room 1 5 Meeting Room 2 7 Movie Room 3 Recreation Room 1 4 Recreation Room 2 *None*
Event
Name
Descr

For begin and end dates above, show the next available times slots for hour(s) and minutes

Show slots by:

Maintenance..

There are two tables you can maintain.
Translate tables
Assets

The translate table is a table that allows maintenance of various parameters.
The fieldName tells the system what the translate information is for.
The value is the value, and the description and short give the translated value.

Field Name	Usage
assetType	Describes the types of assets you wish to use.
event	Your events
menuId	The names of your menus
siteHdr	Used to give a name to your calendar
state	Translate state codes to names
yesNo	Describes names you want to assign to Yes / No drop down selections

The Asset table describes your assets. Each asset is assigned a number and a name. You can have as many assets as you wish.

Security
Users.. You can add as many users as you wish. Each user is assigned a username and password. You also tell what systems they can look at and what systems they can maintain.
The Key Keeper field gives the user total access to the system. It tells the system who has access to the keeper of the keys. Currently the Admin user has Key Keeper privleges.

User System xref. This is a list of all users and what system they can look at and maintain.

Systems.. This is a list of the systems in this application. You can use this to change what manu you want them in, and what name appears in the manu. If you add other systems to this, you need to tell about it here.

Note..
The database was developed using the SQLite database management system.
The programs were developed using the RBgen system.
Over 90% of the system was done this way.