Technology Solutions

Expertise in Creating Solutions with Open Source Software

1. Website Content Management System (CMS) – Before the growth of open source CMS’s which are now available on the Internet, we developed our own framework built on PHP and MySQL. We wanted to create a CMS for building websites quickly that was easy to use, as well as easy to customize. Our firm web site (http://www.onesourcepsg.com/) as well as multiple client websites currently run on this framework. Many of the libraries created for this custom PHP framework are reused in other projects that follow.
2. Intranet Application for Tracking Boat Loans – We developed a custom application for a client that brokers boat loans. This application is used to enter and track leads, prepare and create loan settlements, and present performance reports. The application is web-based, and all user interfaces were built with HTML, JavaScript, and Cascading Style Sheets (CSS) which are interacted with a back-end LAMP system running custom software built on our PHP framework.
3. Intranet Application for Managing Off-Site Hardcopy File Storage – We built a simple system that tracks hardcopy files for office personnel. This system manages all the  physical boxes and inserted indexes held in the office, plus those sent to the warehouse for storage, and files that have been destroyed. The system tracks the history of each box and index logged, from creation to destruction.
4. Internet Application for Construction Project Bidding – This custom bidding system was built on our PHP framework and is hosted on one of our LAMP servers. It manages  construction projects and all associated documents. The system permits contractors to connect to and view architectural plans, as well as other supplemental documents and construction “take-offs” for bidding on projects. Security features include limited access to contractors based on the geographic areas of the project and their area of expertise (plumbing, electrical, etc.). Contractors have access to only the number of geographic and expert areas they buy. Additionally, the system automatically alerts the contractors to changes in current projects as well as when new projects become available.
5. Intranet Application for Managing and Alerting Employees Regarding Current Work-In-Progress (WIP) – We developed this application for a large law firm for use by their attorneys to complete weekly status reports based on their WIP, which are then automatically submitted to the partners. However, there is a penalty for not submitting data on time. The system was designed to send multiple e-mail alerts to remind the attorneys, and if they fail to enter their report data by the deadline, the system automatically signs the user out of the entire network. The project was built on our PHP framework and also uses Python programs to pull data from other third-party databases. Python programs were created to integrate with an existing Windows Active Directory, and regardless of whether the user is signed in on a Windows workstation at the office or on a terminal server, if the deadline comes and they have not submitted their report, they will be signed out. Signing back in to the network then forces the attorney to complete the report, and they are unable to perform any other action until the report is completed. Once the report is submitted, the attorney is allowed full access to the network again, and the infringement is logged.
6. CD for Indexing and Searching PDF Journals – A completely self-contained web-based application was created to run from a CD. Once the CD is inserted into a Windows PC CD-ROM drive, the program on the CD launches the Apache web server and serves HTML files designed to categorize PDF archives. The application is fully indexed and searchable by running cgi-bin scripts that execute from the CD to display the most relevant search results, based on the search criteria entered.
7. Delivery of E-Mail Alerts and Newsletters – A system was developed that enables the user to create fully customizable e-mail templates that allow multi-part e-mail messages to be delivered with both HTML and text parts, in accordance with RFC 5322. Python programs were written to deliver the e-mails either directly to the Internet or across a desired mail relay. E-mail lists are pulled from MySQL databases. The system delivers thousands of e-mails in an efficient and short time period.