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

Maintenance

Security

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

Records:10 Pages:1

SchNum  

Maint

Num

User

Date
Beg

Time
Beg

Date
End

Time
End

Schd
Time

Asset

Event

Name

Descr

ChgDelView

1

1 Admin Data

2009-10-01 Sun

01:00

2009-10-01 Sun

02:00

1:00

0 vac Vacation Vacation

ChgDelView

2

1 Admin Data

2009-10-01 Sun

04:00

2009-10-01 Sun

05:00

1:00

6 met Auditor Meeting

View

3

2 Bobby BackBone

2009-04-01 Sun

08:30

2009-04-01 Sun

09:30

1:00

1 met Sch Financial Meeting

ChgDelView

4

1 Admin Data

2009-10-01 Sun

10:30

2009-10-01 Sun

10:45

0:15

0 sic sick Sick

ChgDelView

5

1 Admin Data

2009-10-01 Sun

06:00

2009-10-01 Sun

07:00

1:00

0 vac Mexico Vacation

ChgDelView

6

1 Admin Data

2009-09-29 Sun

08:00

2009-09-29 Sun

09:15

1:15

1 met Production Meeting

ChgDelView

7

1 Admin Data

2009-12-26 Sun

20:25

2009-12-31 Sun

20:16

119:51

0 oth Moving Other

View

8

2 Bobby BackBone

2009-04-01 Sun

05:44

2009-04-01 Sun

06:44

1:00

0 met my meeting Meeting

View

9

2 Bobby BackBone

2009-04-05 Sun

07:46:40

2009-04-05 Sun

08:46:40

1:00

0      

View

10

3 Demo System

2009-04-05 Sun

08:01:53

2009-04-05 Sun

08:01:53

0:00

0      


Menu : Calendar - Selection : Schedule Time

This is a condensed version of the calendar.


Graphic 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 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

SchBeg

 

SchEnd

 

AssetNum

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.