Archive for the 'Websites' Category
Developed the UCR Libraries Content Management System. Written in-house using PHP, mySQL, Javascript, and DHTML. It features a custom search engine, automated hours interface, news management (press releases), job posting, detailed statistics generation, file management, user management, and a customized WYSIWYG editor. The site has been running under this system since 2002 with millions of page views.
Library Website:
File Management:
News Article Manager:
Centaur Editor: WYSIWYG interface to easily update webpages
File Rollback System:
News Generator:
I developed a parser that converts existing HTML links on the Library website into clickthrough links for statistical tracking. If a user is off campus, they are forwarded to our campus WebVPN server. If a user is on campus, the user is sent directly to the URL of the resource. Before a user is sent to the campus WebVPN login page, they are prompted with a intermediate page that displays instructions on using WebVPN. This intermediate page only is shown to the user once per session. This is controlled via a cookie that stores the timestamp information.
Intermediate WebVPN page
Intergration of WebVPN statistics module in our content management system
The system also exports the statistical data in Microsoft Excel (XLS) format
This system handles all of the Library Reserve requests from the faculty and lecturers on campus. It has streamlined the process of putting materials on reserve. This system eliminated the hardcopy version of the form, saving money and significant time. It handles the tracking of the items and statistical analysis of the requests. Electronic reserve material such as a class syllabus can be uploaded to the server via the submission form.
Reserve Request Form
Reserve Request Form: Upload a file
Admin Interface: Edit a item record
Admin Interface: Listing
Admin screen: Update quarter information for the system
Project: UC Riverside Libraries Study Room Reservation System
This system allows students to check out study rooms online with real-time availability. It interfaces with the existing hours system to generate the schedule for the study rooms and students have the ability to cancel reservations via e-mail. The database structure was developed to easily add new rooms and other resources in the future. Library staff have the ability cancel reservations and update the schedule if it is independent of the Library schedule.
Main Page:
Availability of the study room
Contact information with form validation
Administrator screen
Developed an online financial system that keeps track of the student workers in the UCR Libraries. Completely written from the ground up using PHP and relational MySQL databases, this application: keeps track of the students’ personal information; calculates unit/department/division student expenditures; generates reports; has multiple front-ends for the administrator, department heads, and supervisors. This program benefits the library staff by reducing paper traffic across the multiple libraries and providing expenditure reports at the convenience of the user.
Main Menu
Easy to manage student information
Reports
Sample Report (new version generates Adobe Acrobat PDFs)
Student Timeclock: Login Screen
Student Timeclock: Easy to use Time-in/Time-out mechanism
I have developed search engines for the UCR Libraries websites. The one found on the main Library website gets both the webpages and news articles from the in-house content management system. Library staff can add meta-data to pull in better search engine results and external page content is cached via the crawler every evening. The Library website search engine also suggests resources tailored to the search queries at the top of the screen.
Optimized database for improved search performance
I took existing code and made significant improvements in search performance and
user interface. The database now imports Excel documents (XLS) which is easier for staff.
Search Results
Developed the UCR Library Systems FAQ System. This FAQ system runs in a layout similar to online forums with categories, questions, users, and a moderator interface. The system is very easy to use and adaptable onto any page layout. It should cut down on answering e-mails or phone calls for commonly asked questions.
Main Listing of FAQs:
Category Thread:
Sample FAQ:
Admin Interface: