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
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.
You can search using wild cards on any scheduling parameter.
Running the system..
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.
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
8 Scheduled Time
6 Translate Tables (xlate)
2 User System xref
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
Go back to main menu
Add a schedule
Show graphic calendar
Help messages (up to you to change this to your needs)
Displays the total number of schedules
Displays the total number of pages. This depends on the number of records devided
by the [Lpp] Lines per page
Go to the previous page
You can change this and go directly to that page by clicking [Next]
Go to the next page
Change the number of lines per page.. The default is 25
Sort Drop down
Select the sort sequence from the drop down list
Sort schedules according to the selected drop down
Shows the current sort sequence - in this case SchNum sequence
Go to the Drill down search screen
Menu : Calendar - Selection : Schedule Time
This is a condensed version of the calendar.
This schows one month at a time. Using the various buttons you can move to other months and years.
Detail schedules are shown for each day.
By clickiing on the day number, it will show the detail schedules begining with
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
1 Admin Data
2 Bobby BackBone
1 Admin Data
3 Demo System
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
For begin and end dates above,
show the next available times slots for hour(s)
Show slots by:
Show slots by:
There are two tables you can maintain.
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.
The Asset table describes your assets. Each asset
is assigned a number and a name. You can have as many assets as you wish.
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.
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.