+1 (646) 584-0210

 

48
PREVIEWS
Integration system and Lowes
  • ActiveRecord DB library
  • CSS
  • ExtJS
  • HTML
  • JavaScript
  • jQuery
  • MySQL
  • PHP
  • PHP­framework Codeigniter
  • SOAP
  • SVN
  • XLS
  • XML
  • XML parser
  • XSLT
Goal:
Customer has signed an agreement with a large network of building supermarkets Lowes (http://www.lowes.com/), and set us a task to develop a system to integrate with Lowes SOAP services.
 
According to the specifications received from Lowes technicians, we had to develop a SOAP server to receive and process requests (order, credit, reject). It was also necessary to develop a client service for sending requests to Lowes SOAP server: order confirmation, shipping confirmation and invoice.
 
To monitor and process orders received from Lowes we had to develop a separate control panel with user-friendly interface. Control panel had to have the following functions: search, data filtering, send all kinds of requests to the Lowes server and csv export. The system also had to have a built-in module of automatic synchronization of orders received from Lowes with a workflow system Lotus Notes.
 
Solution:
Analyzing customer requirements we decided to develop a SOAP server using PHP, control panel using PHP based framework. For quick and easy development we have chosen CodeIgniter PHP framework. To implement the user interface control panel we used JavaScript library component ExtJS, because it contains all the necessary interface components. As a data warehouse we have chosen DBMS MySQL, which was later replaced with a more powerful Percona Server database. For system integration with Lotus Notes we used SOAP data exchange protocol.
 
Soon, the whole integration system with Lowes store was fully automated, as we made tighter integration with the Lotus Notes system. Since Lotus Notes produces all the manual order processing, we have implemented a software mechanism using LotusScript, which at certain stages of order processing automatically calls the appropriate SOAP service methods.
 
Team:
  • PHP programmer - SOAP services and control panel server-side development;
  • JavaScript programmer - frontend development;
  • Tester - system functionality testing.
 
Duration:
1 month
 
We have evaluated all work on the project in two months. This estimation included: studying data exchange protocol, SOAP services development, control panel development, integration with Lotus Notes, system debugging and commissioning. The project was completed in time and works successfully