Mindfire has deep experience developing PHP/MySQL and applications based on the LAMP stack. We describe some of these PHP, MySQL and LAMP experiences below, and will be glad to share our expertise in detail with you.
Accounting Module based on Quick Books
Concrete Pumping Company;
Nebraska, USA
Industry:
Construction
Technologies:
PHP, jAjax (Javascript & Ajax), MySQL
Implemented an accounting module based on Quick Books functionality. The module allows for setting up accounting details for a given subscriber. The module allows for creating of invoices, credit memos, cash receipts, computing finance charges, aging summary and generating account statements. This module heavily uses javascript to prefetch and load data to minimize data load time for an enhanced user experience.
EMR/EHR Application
Healthcare Solutions Provider;
Florida
Industry:
Healthcare
Technologies:
LAMP, Javascript, AJAX, webservices, SOAP, XML, Amazon S3, HL7, TCP/IP, Authorize.net
Designed and implemented EMR/EHR application that integrates with a third party billing/scheduling application and attempts to provide a solution for patient identification across clinics. The application provides a means for storing and retrieving patient records across clinics. The application uses advanced Javascript to provide the user with a rich UI and fully customizable interface similar to igoogle with drag&drop boxes. Key features implemented include integrating with Amazon S3 for storage and retrieval of scanned documents, integrating with Lab Corp and Quest Diagnostics for lab ordering and results, automated MS Word document parsing for transcripts. We also are the primary server support and worked on application and DB tuning and JS minification using tools like YSlow and Firebug.
Media Advertising Repository for Brand Researchers
Media Advertisement Marketer;
Media Advertisement Marketer
Industry:
Media Advertising Monitoring & Marketing
Technologies:
LAMP, AJAX, Javascript
Designed and Implemented a highly secure Media Advertising Repository for Brand Researchers that allows search, view, order and download of digitised records from over 500,000 TV, Press and News Commercials. Implemented a unique Ratecard, quota and subscription/alert system that notifies users on new ads based on their preferences. Key features include conversion of mpeg to flv using FFMPEG, LAME, FLVtool2, ImageMagick, fine tuning apache, mysql and PHP for optimal search time. We are also the server support and created the server from ground up for the client.
Incident Reporting and Management System
IT Solutions Provider;
Canada
Industry:
Petroleum Industry
Technologies:
LAMP, Javascript, HTML, CSS
Designed and Implemented an incident reporting and management system that allows for users to report incident on the job, including people involved, environment/site effected, vehicles, equipment, materials, community involved along with a notification system. Key features were to provide an easy to use interface to avoid data entry on paper forms. The challenge was to keep it light weight and customize it across Firefox, IE 6, IE 7, Opera and Safari web browsers.
Document Management System
Data Management Solutions Provider;
Chicago, IL
Industry:
Data Management Solutions
Technologies:
LAMP, Linux server apps including sendmail, proftpd, samba, system account creation via web
Maintainance/bugfixes/enhancements to a document management system. The application is a web-based content management system that keeps your critical files centralized in an easy-to-use, online environment. The application is accessible from any industry-standard Web browser, Key features include storing scanned and electronic files such as documents, graphics, audio and video clips, etc. within system user folders. The documents can then be accessed on the LAN via SAMBA shares that are user specific and use LDAP authentication. Document sharing, Management, Distribution for approvals, routing, etc. Creation of workflow for a specific document, archiving, Creating e-books, Downloading of document information directly into excel, batch print documents, and more!
User database to centralize management of user permissions for home applications
Software and consulting services for News Industry;
Missouri
Industry:
News
Technologies:
LAMP, XML, SOAP, webservices, NuSOAP
Designed and Implemented from scratch a centralized user database that allows for creation of registration forms to be used by home application - management of users and privileges can be done in the user database application. Logins and Privileges are sent from the home applications and received by the home applications by sending and receiving SOAP/XML messages from the userdb application. This allows for having a single user login across home applications. Key Features: SOAP/XML web services.
Event Tracking Application
Software and consulting services for News Industry;
Missouri, USA
Industry:
News
Technologies:
LAMP, AJAX, XML, CVS
This project required us to provide support for several versions of an existing application. We implemented version specific bug fixes and client/version specific enhancements. The application is web based and allows users to create, plan, organize and coordinate event listings for newspapers and press releases. We also implemented designing of form templates and layouts by the admin user with permission based access. The forms can be customized based on the fields the admin wants to present to the user.
Royalty Calculator for Bloggers
Software and consulting services for News Industry;
Missouri, USA
Industry:
News
Technologies:
LAMP, AJAX, XML, SOAP, webservices, NuSOAP, CVS, salesforce
Designed and implemented a royalty report generator for publishers based on set royalty percent and publication views reported by customers every month. The application implements a complex login process using NuSOAP and communicates with a centralized user database to validate login.
Implemented a complex data reporting system that allows for importing publisher and publication data from salesforce and monthly customer page view data to determine amount to be paid to publishers based on publication page views and amount paid by customers. The system allows for tracking prepayments and carryforward amounts to publishers and allows the user to export data into formatted excel reports for publishers, publications and customers.
Meta Carta Webservices Integration
Software and consulting services for News Industry;
Missouri, USA
Industry:
News
Technologies:
LAMP, process forking, metacarta web services, XML, AJAX, google maps api
Implemented a php script that spawns multiple child processes to get geo location tags based on new stories. Implemented inter-process communication. The stories table content grows rapidly and as a result we used multiple processes to hit meta carta's web service to and get the stories geo tagged.
Integrated with google maps api to display the map based on geo tagged parameters for the story that was returned from meta carta.
The challenge was implementing interprocess communication so as not to have the same story tagged and getting the php processes to use a persistent mysql connection to write the geo tags to the db.
e-ticketing system
Multimedia Presentation Software Solutions;
California, USA
Industry:
Multimedia & Graphics Software
Technologies:
Linux, Apache, MySQL, PHP, Javascript, HTML, CSS
Designed and Implemented an eTicketing system that allows for product users to submit tickets and view responses. Implemented admin section to enable staff to use predefined email templates to respond to queries on various products.
Web Document Management System
eBusiness Solution Software Company;
Antwerpen, Belgium
Industry:
eBusiness Solution
Technologies:
PHP, AJAX, JavaScript, XML, MySQL 5.0
This application basically manages the documents of the companies and different departments of one company through web.
The application is having two major section, System administrator and normal users. The Super administrator who actually manages the application and normal users can access all the documents assigned to they by the Super Administrator and depending on the various permission labels the different section of the document repository will be accessible.
Super Administrator can log into the application, can create/manage/edit/delete normal users profile and assign various permission labels through the features available. Super Admin can create/manage/edit/delete groups like, sales, marketing etc. The various groups can have different permissions to the documents directly or to the document root directory. Many normal users can be put under groups so that by assigning permission to the group only, the normal users can have the same group permissions inherited from groups.
The GUI is completely AJAX based, with tree view of folder structures with functionalities like create/manage/edit/delete folders and documents. And also the upload document is available through which Admin can upload the document for the groups and users. This is partially a database driven application where many features are managed by the data in database. The GUI and application layer interacts with each other through AJAX calls and application layer in turn calls the database layer.
Distributed Transaction Processing Application
Information Technology Services provider;
Nashville, Tennessee, USA
Industry:
Consumer Services
Technologies:
PHP, MySQL, OSCommerce, UPS
Designed and implemented a distributed transaction processing system to allow for a centralized way to create and manage shopping carts for a group of websites that provide an online marketplaces for the sale of consumer goods. Customized OSCommerce to allow the DTP admin to setup layout and preferences for each website. Integrated with UPS API to determine cost of shipping based on package specifications and generation of shipping label and tracking number for the package once the order is placed successfully.
Website for Museum
Software services;
Pasadena, CA
Industry:
Museum
Technologies:
PHP, SQL Server 2005
This website maintains collection of many paintings, sculptures, tapestry and arts from several centuries, culture, artists. It has many options to get information about a specific painting or art. By selecting a painting, a brief description of that painting can be seen with all details. Advance Search option has the abilities to search by the combination of Artist, Culture, Title, Centuries, Object Type, Accession ID and Origin. Event section maintains information about Events by Day, Week and Month wise.
The upcoming events are also maintained.
Collection Management & Reporting
Software service;
Pasadena, CA
Industry:
Finance
Technologies:
PHP and MYSQL
This website has an Admin Section and User Section. In Admin Section, there are options like, Clients, Contracts, Accounts, Reports and Preference. Admin can view clients, their Accounts and Reports. Admin can also create Clients, Contracts and Accounts. The Users can create accounts against contract. Individual clients (Users) will have their individual contracts and Accounts as well.
There are options to see the details of Clients, Contracts and Accounts. Several reports are there to for each section. There are search options to get information easily.
Sales Force Management Application
Sales and Management Company;
Chicago, USA
Industry:
Sales Management
Technologies:
PHP, Jquery, MSSQL
This application is specifically designed for B2B managers to manage their sales team. The application allows for tracking of sales force activity and performace and provides directional input to managers via complex algorithms to help them identify weaknesses and key points to enhance their sales force performance. It objectively analyzes sales activities and identifies key steps required to close individual sales opportunities. It increases market share through a more productive sales force. The application is implemented in PHP with a MS SQL database backend and uses advanced JavaScript to prefetch and load data to minimize data load time for an enhanced user experience. Implemented code optimization and js minification to improve the load time of the pages. Replicated complex logic from existing application and implemented new modules to help sales managers get required data quickly. Implemented a forecast assistant module to help the sales manager decision making process for future planning.
Video sharing community for bird and sports enthusiasts
Software Development Company;
Orem, Utah, USA
Industry:
Internet Software & Services
Technologies:
LAMP, Ajax, Javascript, Flash, HTML, CSS, PHP, MySQL, Lighttpd, Video Streaming
Designed and Implemented a highly secure web site similar to you tube where users can share videos and pictures with the world. The website allows members to view online videos, create forum discussions, blog and create groups with whom they can chat, share videos and pictures online. The sites also allow for Super Administrators to login and manage users, videos, pictures, groups and forum discussions. Super administrators can also create different user types who can administer the site with their assigned permissions. One of the key features of these sites is that it is self managed and requires minimal administration. Key features include conversion of video files uploaded by users to desired format using FFMPEG, MENCODER, LAME and FLVtool2 for video streaming. We also configured and set up lighttpd for streaming and provided the client with a flash video player that uses external interface to support JS calls and supports streaming.
POP3 mail parser to allow for submitting trouble tickets via email.
Mechanical Services Contractor;
Charlotte, NC, USA
Industry:
Consumer Services
Technologies:
PHP, MySQL, POP3
The php script is implemented as a cron that runs periodically and connects to a POP3 server account to access tickets that are submitted to a help-desk email address. The script accesses and parses the emails and stores customer number, address, problem and the rep the ticket is to be assigned to in a MySQL database. Tech support responses can also be parsed and logged against the original ticket. The cron is used to capture questions and their responses to build a knowledge base system that tech support staff can use to help solve day to day issues.
