report - Macau Polytechnic Institute
Contents
1. Active Lifestyle Web Calendar is the most powerful calendar compare with all the open source web calendar because it allows you to access in the calendar schedule for a group of person multi user function If one company doesn t need for most of the staffs coming to work in office such as Insurance company and Design Programming Company active lifestyle web calendar is your best choice as working partner We can login into the web calendar at your home or anywhere else by authorizing your username and password only and then you are able to see everyday schedules posted if there are some necessary things should be announced Each staffs has assigned in different privileges for admin level it is the most powerful privileges as it allows you to read write and modify For manager level it is the second powerful privileges as it allow you to read and write For employee level it allows you to read only We are choosing this topic as our graduation project because the business field is becoming computerized Most of the company working with Outlook Express as their contact application as I think the dependence in Outlook Express is not quite completed and perfect It allows you to lost the data easily if the network is broken In my point of view it should be replaced by Active Lifestyle Web Calendar because it is more activate and you can go through in the website at anytime you like Also the inference is designed in user friendly field no mat2. MACAU POLYTECHNIC INSTITUTE School of Public Administration Computer Studies Program Academic Year 2006 2007 Year 3 Graduation Project Documentation Active Lifestyle Web Calendar Professor Group Members Topic Jacky Tang PC Free Limited Company Katrina Chang p0401310 Phoebe Wong p0305109 Active Lifestyle Web Calendar Active Lifestyle Web Calendar TABLE OF CONTENTS FADS ACC eos g dba diia 3 ET OO GUC Oh Oise sec ses este eseen cst oia ES Ss A O eases out E A a cau beeaer 4 Compare with Outlook EXpresS cccs0sssccsccccsesssesessctssseeaseedeceeeecceseecsvaseesenset Advantages of Web Calendar ccccccsssccecccccsssseeeccesseessssseeenceecceseesescsssnee A III System Architecture Data Structure Did otitis iaa 5 ERDAS aise pea tail adi ac 6 Funcional Speci Ca ION det A A ii as cd 7 LY User Van O euuseiudias ae tho EO 8 A EE A I EE A aoa hel A emt TEET E 8 ANOTE Database 7 acto 5s A A A 9 LIAM eigen cea teat ech dd ttammahs Gu A IAE 9 Y IIA 9 A O RE 9 IS O A A Ge nade cna een Pa arse mens eee aaa ioreas 10 A E RN Coe ROR ee cago ETE TT a A tee hee Ena 10 Calendar SNAPS OI O Mada EE 11 NN A E 12 ACE SA A A o 13 Edit Event REMOVE EVE A mart r vanadeeneatetacaumyanens 14 NIE MOSS d IEn a a ctal 15 Veoystem ReqUireMent En r a TOT a a 16 Appendix A Using PHP myAdmin esesesessnsssnsesesesesesseseseseseseseseseseseso 16 Appendix4B Database SCP era ld A 18 I ABSTRACT
3. scheduleid name userid type startdate size enddate content hour duration participates type modify date One Database Websystem One Scheme root Three tables Member Schedule and upload Member id it is the primary key for member username one of the attribute for member password one of the attribute for member type one of the attribute for member class one of the attribute for member Schedule id it is the primary key for Schedule userid it is the foreign key from member startdate one of the attribute for schedule endate one of the attribute for schedule hour one of the attribute for schedule duration one of the attribute for schedule participates one of the attribute for schedule type one of the attribute for schedule modify_date one of the attribute for schedule Upload id it is the primary key for uplad scheduleid it is the foreign key from schedule name one of the attribute for upload type one of the attribute for upload size one of the attribute for upload content one of the attribute for upload Functional Specification Below show the privileges in adim manager and employee Adduser Dropuser R Viewuser Viewtopic Bid Admin Showschedule Addschedule Viewschedul
4. 07 06 03 06 27 06 E E 2007 06 01 08 40 05 View Message 5 a 2007 06 01 00 00 00 Logout Add User For the add user part only the user who own Admin Authority can add users on the database Step 1 Username Input the name Step 2 Password Enter the 5 digits or characters Step 3 User Type select the user who belongs to which authority Step 4 Department select the user who belongs to which group Step 5 Submit press the submit button and all the details will store in the database directly Menu KatrinaChang from the department of administrator has been signed in Admin Username View User Password Add User Usertype Employee Manager Admin Drop User C Computer Department Account Manage Calendar Sales View Message Submit Logout Drop User For the add user part only the user who own Admin Authority can add users on the database Step 1 User ID Each members would be assigned one user ID you only enter the ID whom you want to drop Step 2 Submit press the submit button and system will delete the user in the database directly Menu KatrinaChang from the department of administrator has been signed in Admin 1D Name Type A dfi KatrinaChang Admin dl PhoeheWon Admin g Add User 3 TomLo Manager g Drop User 4 KenLong Manager Calendar 5 steveWong Employee 6 Kentsik Manager View Message L 3 ilamLeon anager O 7 WilliamLeong Manag ag ou 8 Victorkwan Employee F
5. as an events calendar for an organization or as a scheduling system for an intranet Regarding this the target for Active Lifestyle Web Calendar is to help a group of members who want to make the meeting through the web server and make the appointment base on the web Calendar Even the staff is not able to attend to work they can know what s going on Feature Active Lifestyle Web Calendar is using PHP program as application that can be configured as a multiple user calendar or as an event calendar viewable by visitors It is a central calendar time management and meeting scheduling system which has been licensed for all Pcfree s staff in order to help them to schedule the meetings manage conference rooms and maintain tasks lists Active Lifestyle Web Calendar must get an account to access the system which have been assigned the password to everyone Web Calendar can be setup in a variety of ways such as 1 A schedule management system for a single person 2 A schedule management system for a group of people allowing one or more assistants to manage the calendar of another user 3 An events schedule that anyone which own the password can view allowing visitors to submit new events Compare with Outlook Express I know most of the business trade is using Outlook Express for their daily communication Don t you think that it is good for organizing our schedules In my point of view I don t think so outlook express have many li
6. e gt Editschedule gt Calendar Viewtopic Viewuser Login Manager Showschedule Addschedule Viewschedule editschedule gt Calendar A Viewtopic gt Showschedule Employee gt Viewschedule gt Calendar IV USER MANUAL Login The Login screen allows users to access the application by providing their user name and password Users provide their logins and passwords and enter them in the respectively named fields Once login and password are validated user is redirected to the Active Lifestyle Web Calendar gt a 4 Your good partner on your work Please enter your login information Username Password Once you have entered your username and password the first page would allow you to see the messages which created from our staff members The most updated messages will be showing on top Property Message ID Each message would assign a unique ID number The subject of the message Update Time The time of writing this message Menu PhoebeWong from the department of administrator has been signed in Admin MESSAGE ID Mame Update Time View User 8 Birthday Party 2007 06 03 07 42 59 Fl Meeting 2007 06 03 06 27 06 id 6 3 2007 06 01 08 40 05 Drop User 5 a 2007 06 01 00 00 00 Manage Calendar Yiew Message Logout Authority in Database We have assigned three different authorities for each member 1 Admin The authority in Admin allows you t
7. essage Date would also jammed Menu KatrinaChang from the department of administrator has been signed in Admin MESSAGE ID Mame Update Time View User 8 Birthday Party 2007 06 03 07 42 59 Meeting 00 06 03 06 27 06 A 6 a 2007 06 01 08 40 05 Drop User 5 2007 06 01 00 00 00 Manage Calendar Once you double click to the name message description it will link directly to the message content see below as an example Menu KatrinaChang from the department of administrator has been signed in Admin View Schedule on 2007 06 03 08 00 Subject Birthday Party view User Start Time 2007 06 03 8 00 addice End Time 2007 06 03 10 00 Participantes Computer Account Sales Drop User Details That day is Phoebe Birthday pls come for celebration Manage Calendar Yiew Message Logout 15 IV System Requirements PHP 4 1 PHP 5 some features specific version RequieredDatabase MySQL CSS enabled browser Microsoft Internet Explorer Recommended You must have one of the following databases installed o MySQL o MS SQL Server o SQLLite PHP5 O For the database you choose you must have 1ts drivers built into PHP For example to use MySQL PHP must be compiled with MySQL support which is the default setting when installing PHP See the PHP pages www php net f for more information on setting up PHP No optional PHP packages other than MySQL are required for this application However PHP should be compiled with enab
8. g When complete a single user account will be created with the login admin and password admin which you are encouraged to use to create your own account Note In the examples below text in bold represents text that you must type in Security The default values for database login and password intranet and webcalendar are for demonstration purposes only and should never be used in a production environment MySQL The following will create a database named websystem CREATE DATABASE websystem DEFAULT CHARACTER SET utf8 COMA Es ie o general Ci Next create the database user account that will be used to access the database create table member id MEDIUMINT primary key username varchar 2959 Passo weno Glee 0 type char 1 Class varchar 2505 Vs If you will be accessing MySQL from a different machine than the one running the web server repeat the command above and replace localhost with the hostname of the other machine Inserts into members values Ml Kenliong kIT sa amina
9. he add schedule box can be shown in the in the pop up window This parameter is specified in the Configuration section KatrinaChang from the department of administrator has been signed In Admin Schedules defined on 2007 3 6 2007 March E ABBR TF TEF 12 Add Event If users have rights to add edit events the Add Event icon will be shown for the date in Calendar Views Clicking on this icon will add an event to the current day The Add New event screen presents the user a form to define a new event KatrinaChang from the department of administrator has been signed in Admin Add Schedule on 2007 3 6 at 08 00 Subject Message Type Message r Upload File ile Start Time 2007 3 6 8 00 End Time 0 00 Z Coraputer Acoount Participantes eales Details Add Specify the event title in order to know more clearly Subject about the message Choose the type of the message It has different type of Message Type option such as Message Attachment Birthday Conference Dinner Hi tea Lunch and Trip It can upload 1 kb 20mb file on attachment Specify the starting time of the event Specify the ending time of the event N Specify to the related department which will attend the Participations i meeting or schedulers Specify the brief description of the event Add Button insert all the written messages on the database Return all the messages to blank Note By default the starting date will be vis
10. ible in the menus The active date is either the date you double clicked on to access the Time Set Up schedule 13 Edit Event Remove Event KatrinaChang from the department of administrator has been signed in Admin Edit Schedule on 2007 06 15 11 32 11 Subject Trig Message Type Tip o O Upload File ccErrDspLog tst Start Time End Time 2007 06 08 au Y Participantes vales I will have a trip on that time pls note Details Save Remove Back Specify the event title in order to know more clearly Subject about the message Choose the type of the message It has different type of Message Type option such as Message Attachment Birthday Conference Dinner Hi tea Lunch and Trip It can upload 1 kb 20mb file on attachment Specify the starting time of the event Specify the ending time of the event e Specify to the related department which will attend the Participations meeting or schedulers Specify the brief description of the event Revised and insert all the written messages on the Save Button database Clear all the messages Return all the messages to blank 14 View Message View Message is used to see the full event information which works like an email expresses function The details are shown each time event title link is clicked in any calendar view Each message will assign a job ID A title link would be shown accordingly if you double click on it Sender receiver and m
11. ila Malndwln Era 10 Calendar Snapshot The Calendar Snapshot is used to quick view events which have written on the schedule The Calendar Snapshot can always show the current month or can show the month of the main Calendar In the second case the navigator to the neighbor months can be activated By default the Calendar Snapshot is shown in the Year views but it can be also activated in the month view The events are not displayed directly in the Calendar When the cursor is over the date with events the box with event titles is displayed If the user clicks on the date the calendar is switched to the Month View for the selected day Each days would present a hyperlink which show in blue color You only need to double click the date which you want to add the schedule and it will automatically jump to the schedule page If there is message or schedule on that day a Black Square would be showed under the date for you to pay more attention KatrinaChang from the department of administrator has been signed in Admin Schedules defined on 2007 lt lt Previous Next gt eee Ree Eee Ee VPP Pe Pere eV Ey ee Ee E E Pl S E E EN AA eS E AMA PPE A n o MI 11 Add Schedule The current week may be accessed from any place in the system by clicking Day in the top calendar menu The Monthly View displays events from the selected month If the user clicks on the time link the add schedule will be opened T
12. ion This will bring you back to your phpMyAdmin home page Optional Create new MySQL user If you already have a MySQL login that you would like to use you can skip this step o Click on the Privileges link under the MySQL heading o Below any existing users listed click on the link Add a new User o Fill in the details of your new database user The default username for WebCalendar is webcalendar with a password of webcal01 Leave the Host field set to Any host o From the list of Global privileges be sure to select SELECT INSERT UPDATE DELETE FILE CREATE ALTER INDEX DROP o Click on the Go button o You should see a page that says You have added a new user Click on the Databases tab at the top of the page From the list of databases on the page click on the name of the database that you created Click on the SQL tab at the top of the page At the bottom of the page there is an area to upload a SQL file Click on the Browse button and select the tables mysql sql file in the WebCalendar toplevel directory Then press the Go button The top of the page should say Your SQL query has been executed successfully You have now finished creating the WebCalendar database tables 17 Appendix B Database Setup There are three steps in setting up the database 1 Creating the database 2 Creating the user 3 Creating the required tables Follow the steps outlined below for the database you are usin
13. le track vars on some systems TIP II you want to use gradient background images PHP must be compiled with the GD library You can run PHP either as a CG or an Apache module You ll get better performance with PHP setup as a module Not only will you not have to deal with the CGI performance hit but you ll be able to use PHP s database connection pooling Additionally this application can use a form cookie based authentication or traditional HTTP authentication For traditional HTTP authentication PHP must be built as an Apache module If you are planning on using email reminders you will need to build PHP as a CGI in order to run the send_reminders php script I would strongly recommend building a module based PHP for your web server and then a second PHP build to create the CGI version 16 Appendix A Using phpMyAdmin If you have phpMyAdmin installed and configured to manage your MySQL database use the following steps to setup WebCalendar The following information is based on phpMyAdmin version 2 6 1 l On the initial phpMyAdmin page under the MySQL heading the first option should be Create new database Enter the name you have chosen for the database and press the Create button The default database name used by WebCalendar is intranet After pressing the Create button it should say Database lt your database name here gt has been created Click on the home icon the small house in the left side navigat
14. mitation which doesn t allow you to access with multi user function and also the dependence in Outlook Express is not quite completed and perfect If the server network is broken then all data would be in a lost Advantages of Web Calendar Active Lifestyle Web Calendar is an activate system and you can go through in the website at anytime you like Also the inference is designed in user friendly field no matter you are the first time to come for joining our web calendar you would easy to understand and take control on it Nevertheless it allows you to access the schedules from anywhere and explorer is the only recommended browser for the web calendar Flexibility Zero Client Installation Easy to use Explorer is the only recommended browser for web calendar Accessibility check anywhere Data Security privacy protection System Data Reliable data store in server side HI SYSTEM ARCHITECTURE Data Structure Diagram As the system can able to access in different OS such as Window XP Linux and Mac etc so we can login into our web calendar at anywhere and anytime you like as the explorer is the only recommended browser for web calendar All Data is stored in the database client will not afraid to lose any data because server can help for backup We use Apache as the web browser and MySQL as the Database system SS Apache with PHP Database MySQL ER Diagram username password type class
15. o read write and modify It is the most powerful one among all Besides from this admin can own the database function which allows you to add user or drop user from the database and assign their authorities When you enter in Admin Authority Page see below picture the username your belong department and your position would be show on top of the table Menu KatrinaChang from the department of administrator has been signed in Admin ID Name Type View User 1 KatrinaChang Admin IEW User T eae Add User 3 KenLong Manager Drop User 4 TornLo Manager Nareaele sender 5 SteveWong Employee 6 SaiChang Manager View Message ji WillamLeong Manager Logout E Wictorkwan Employee E MelodyLo Employee 2 Manager The authority in Manager allows you to read and write It doesn t include the database function On the Calendar part you are allowed to edit the schedule on the database Menu Willamleong from the department of account has been signed in Manager MESSAGE ID Name Update Time ME 7 Meeting 2007 06 03 06 27 06 6 3 2007 06 01 08 40 05 da 5 a 2007 06 01 00 00 00 View Message Logout 3 Employee The authority in employee allows you to read only On the Calendar part you are absolutely not allowed to edit the schedule on the database You can only review with the schedule and send message to the users Menu JohnLee from the department of sales has been signed in Employee MESSAGE ID Mame Update Time Manage Calendar ii Meeting 20
16. ter you are the first time to come for joining our web calendar you would easy to understand and take control on it I INTRODUCTION Active Lifestyle Web Calendar allows a user to access the calendar from anywhere a web browser is available Internet Explorer is the recommended browser for the Web Calendar It is a simple and powerful web based calendar system In addition to standard event scheduler one can create mini calendars set event categories plan online appointments create user subscriptions create password protected calendars plus many more useful capabilities Whether you have a non profit web community or e commerce web site with affiliates Active Lifestyle Web Calendar will extend your online planning and communications to the new level A user friendly interface allows publishing events on online schedule setting recurring events personalizing email notifications setting online event alerts and applying importance labels highlights and many more features It will be more useful compare using the Outlook In addition you can easily export events created in Active Lifestyle Web Calendar to the most popular formats compatible with Microsoft Outlook and other organizers Nevertheless Active Lifestyle Web Calendar a multi user calendar system It 1s intended to be simple to setup and use while still providing advanced features and flexibility to serve the purposes of a widely varied user base However it can be used to
Download Pdf Manuals
Related Search