Webbased Infrastructure Documentation System WIDS

1
Web-based Infrastructure Documentation System
(WIDS)
Brian Grace, Troy Harter, and Kristen Wilson BS
Computer Science
2
Problem
Overview

• Departments on Campus have lots of information to
  track.
• How to organize it all and make it accessible?

Solution

• Create an online system that stores key
  information
• pertinent to departments on campus.
• Make it web accessible.

3
Specifications
User Interface
Full campus aerial photo with interactive campus
locations. Hover cursor over a campus location
and the specified area will popup with pertinent
information.

• Two types of Campus Locations
• Building
• Outside location

4
Campus Location Building
Specifications- User Interface

• User can view a floor plan
• Two Options
• Click an area Displays all the objects within
  that area
• Click an object Displays just that object on a
  separate web page
• Object page can contain
• Image files
• Text

Demo
5
Campus Location Outside Location
Specifications- User Interface

• An outside location may be
• Single object
• OR
• Area containing multiple objects

• An object web page contains
• Image files
• Text

6
Access to WIDS
Specifications

• Type of access
• User
• Viewing
• Administrator (includes User privileges)
• Add/Remove User and Administrator accounts
• Modify account information (i.e. name, username,
  and password)
• Add/Remove a Campus Location
• Add/Remove Floors
• Add/Remove/Modify areas and objects
• Set session timeout periods (e.g. users logged
  out after twenty minutes
• of activity)

7
Strategy
Game Plan!

• We need to create
• Image maps
• KImageMapEditor
• Database
• MySQL
• Manipulation of Database
• PHP
• User interface
• XHTML
• Cascading Style Sheets
• Authentication
• pubCookie (www.pubcookie.org)

Imagemap source
Demo Main Window
Demo Coordinates
ER Model
Demo
8
Learning Objectives
Project Objectives

• PHP
• SQL
• XHTML
• Cascading Style Sheets
• ER Modeling
• Creating image maps
• Working in a group
• CVS project management software

9
Most important goalThink Dynamic!!!

• Able to work with any infrastructure
• Easily updatable
• Easily expandable

10
Future Ideas
Navigation Aid
11
Created by Brian Grace Troy
Harter Kristen Wilson
12
KImageMapEditor- Main Window
13
KImageMapEditor - Editing a polygons
coordinates
14
Entity Relationship Model of Database
Object SQL code
15
Objects SQL Code
SQL Code   CREATE TABLE object ( objectId
BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, area_nam
e VARCHAR(255), building_id BIGINT
UNSIGNED, floor_name VARCHAR(255), outsideLocati
on_id BIGINT UNSIGNED, coordinates TEXT NOT
NULL, text TEXT, mouseOver VARCHAR(90) DEFAULT
Click here for more information about this
object, PRIMARY KEY (objectId), FOREIGN KEY
(area_name, floor_name, building_id) REFERENCES
area(areaName, floor_name, building_id), FOREI
GN KEY (outsideLocationId) REFERENCES
outsideLocation(outsideLocationId) ) ENGINE
InnoDB
16
Image Map Source code
ltimg id"Aerial_Photo" src"http//www.cs.plu.edu/
wids/Documents/Aerial_Photo.jpg"
usemap"Aerial_Photo_Map" /gt ltmap
name"Aerial_Photo_Map" id"Aerial_Photo_Map"gt
ltarea shape"poly" coords"3952,953, 3889,953,
3888,919, 3872,920, 3871,911, 3866,1013,
3964,1015, 3965,953" href"./floor.html"
title"Xavier" /gt lt/mapgt