Christian Web Host, Java Programming - Cheap Web Hosting Blog

338 Part II: Developing Intranet Solutions Central Login/Logout Messages Calendar Events User Home Interface PHP Application Framework Message Object Intranet Calendar Applications Event Object class.Message.php class.Events.php Figure 10-2: Intranet calendar manager system diagram. The Event class provides the Event object. The class is used to manipulate each event. It allows an application to create and delete events. The ch10/apps/class/ class.Event.php in the CDROM is an implementation of this class. This class implements the following methods: . Event (): This is the constructor method. It performs the following functions: Sets an object variable named dbi to point to the class.DBI.phpprovided object, which is passed to the constructor by an application. dbi holds the DBI object that is used to communicate with the back- end database. Sets a member variable named event_tbl to $CALENDAR_EVENT_TBL, which is loaded from the calendar.conf file. $CALENDAR_EVENT_TBL holds the name of the calendar event table. Sets a member variable named event_view_tbl to $CALENDAR_EVENT_ VIEW_TBL, which is loaded from the calendar.conf file. $CALENDAR_ EVENT_VIEW_TBL holds the name of the event view table. Sets a member variable named event_repeat_tbl to $CALENDAR_ EVENT_REPEAT_TBL, which is loaded from the calendar.conf file. $CALENDAR_EVENT_REPEAT_TBL holds the name of the event repeat table. Sets a member variable called std_fields as an associative array to hold the attributes of the calendar event table and their data types (text/number).

Chapter 10: Intranet Calendar Manager 337 Table 10-1 provides the details of the database tables. TABLE 10-1 CALENDAR DATABASE TABLES Table Description CALENDAR_EVENT This table is the integral part of this database. It holds the event number (EVENT_ID), user ID (USER_ID), event title (EVENT_TITLE), event date (EVENT_DATE), event description (EVENT_DESC), reminder ID (REMINDER_ID), and a check flag (FLAG). The event number (EVENT_ID) is automatically generated by the database. CALENDAR_EVENT_VIEWER Holds the calendar event viewer information. The calendar event viewer consists of the EVENT_ID and VIEWER_ID. CALENDAR_REPETITIVE_EVENTS Holds the calendar repetitive event information. The calendar repetitive event consists of EVENT_ID and repeat mode (REPEAT_MODE). The ch10/sql/calendar.sql file in the CDROM contains all the table creation statements for the CALENDAR database. You can create this CALENDAR database in your MySQL server by running the following commands. mysqladmin -u root -p create CALENDAR mysql -u root -p -D CALENDAR < calendar.sql Make sure you change the user name (root) to whatever is appropriate for your system. With the intranet calendar manager database established, it s time to look at the PHP classes that are needed to implement the applications. The Intranet Calendar Application Event Class We need only one new object, the Event object, to implement the intranet calendar manager, as you can see in Figure 10-2, which shows the system diagram. The Message object was discussed in Chapter 7.

336 Part II: Developing Intranet Solutions . Sharing and assigning events among users: Users can create events for themselves or assign events to others or even share events with multiple users. . Automatic reminders: Users can choose to be reminded about an event when they log in to the intranet on the day of the event. Let s look at the prerequisites of the calendar system. Understanding Prerequisites The event calendar builds on the intranet classes discussed in the Chapters 4 through 7. For example, it uses the Message class (discussed in Chapter 7) to announce event reminders. That class enables the application to create and delete messages. The intranet calendar applications that you ll develop require the central login/logout, user management, and intranet home applications discussed in those earlier chapters. Now let s look at the database design and implementation needed for creating the intranet calendar manager. Designing the Database Figure 10-1 shows the database diagram for the intranet calendar manager. Here the CALENDAR_EVENT table holds the event data, CALENDAR_EVENT_VIEWER table holds the viewer list for an event in the CALENDAR_EVENT table. The CALENDAR_REPETITIVE_EVENTS table stores information about how an event is repeated. Figure 10-1: Intranet calendar manager database diagram.

Chapter 10 Intranet Calendar Manager IN THIS CHAPTER . Developing an intranet event calendar . Installing an intranet event calendar . Using an intranet event calendar WORK MEANS SCHEDULES, and schedules mean important dates. Everyone has important family- and work-related dates that they need to remember. Many use a calendar as a tool to remind themselves of such events. In this chapter, we look at an intranet calendar system that enables a company to publish important events via a central calendar, and enables users to keep track of their personal events and dates. Identifying Functionality Requirements The calendar system that you ll put together in this chapter will have the following functionality: . Global events: These events can be predefined in a configuration file to show up on the calendar every year. These may include annual company events. . Holiday events: These events can be predefined in a configuration file to show up on the calendar every year. These are standard holidays with fixed dates, such as Independence Day, Christmas, New Year s Day, and so forth. Holidays that are not on a fixed date such as Thanksgiving, Labor Day, etc. will have to be set up manually. . Weekends: Weekends can be configured to be any days and any number of days using a configuration file. Some parts of the world don t follow the Saturday-Sunday weekend system used in the U.S. and Europe. . Repeatable events: Users can configure events to repeat weekly, monthly, or yearly. 335

Chapter 9: Intranet Contact Manager 333 Summary In this chapter, you developed a central contact manager tool for your intranet. This tool enables your intranet users to search and manage contacts in a very efficient way compared to individual contact files. This application can be extended to include private and public contacts, or you can even consider extending it to allow groups of users to view a category (or prevent them from viewing a category).

332 Part II: Developing Intranet Solutions An abridged result of the search is shown in Figure 9-13. Clicking on a contact name brings up the details as discussed earlier. Figure 9-14 shows a detailed contact information page that includes e-mail history. Figure 9-13: Search results for a subcategory s contacts. Figure 9-14: E-mail history of a contact.

Chapter 9: Intranet Contact Manager 331 Figure 9-11: Sending e-mail to a contact. Figure 9-12: Searching for all contacts in a subcategory.

330 Part II: Developing Intranet Solutions To view a detailed version of the search results, click on the name of the contact. A detailed result screen displays, as shown in Figure 9-10. Figure 9-10: Detailed search results. Sending e-mail to a contact When you view detailed information about a contact, you can click on the Email link and send an e-mail to the contact, as shown in Figure 9-11. The e-mail will be stored in the contact database along with the contact. When you search for this contact again, the e-mail will be available for review. This is a great way to keep in touch with leads in your contact database. Searching for contacts in a subcategory You can find all the contacts in a subcategory by selecting the subcategory on the Contact Search screen. For example, Figure 9-12 shows that a user wants to find all the contacts in Communication Vendors subcategory of the Vendors parent category.

Chapter 9: Intranet Contact Manager 329 Searching for a contact To find a contact in your contact database, click on the Contact Manager link on your home page and enter the contact s first name or company name or select a category or keywords. Currently, the address fields (company/home) are not searchable but you should try to add search capability for these fields as a learning experience. To find a contact by first name, for example, enter the name in the search interface s Contact Name field and click the Find button. Figure 9-8 shows a user entering joe as the name in the search interface. The result of the search is shown in Figure 9-9. Figure 9-8: Searching for a contact. Figure 9-9: Brief search results.

328 Part II: Developing Intranet Solutions Adding a contact To add a contact in a subcategory, do the following: 1. Go to the search interface as an administrative user and click on the Contact Manager Admin link. 2. Click on the Add Contact link, which shows a Web form similar to the one shown in Figure 9-7. 3. Select the category and then select the subcategory. Do not enter any information until you ve selected the appropriate subcategory. 4. Enter all the contact information you have available in the data fields. If you want to find this contact via certain keywords, make sure you add the keywords in a comma-separated list in the appropriate keyword field in this form. 5. If you want to set reminders for yourself regarding future meetings or calls that you want to be reminded of via the intranet messaging system, add the reminders in the reminder fields with the appropriate data. 6. After you ve filled in the contact s information, submit the contact data to be added in the database. Figure 9-7: Adding a new contact.