Overview
The client has a well settled business of Jewelry designing and having both retail as well as wholesale customers.
Business Requirements
The client wanted us to develop a system for a wholesaler through which he can show his jewelry designs to a wholesaler and get the orders. Initially, We had decided to develop the application using WordPress as it is a simple catalog kind of system. We submitted the wire-frames for client review based on the initial requirements stated by the client. But after few wire frame revisions our Team realized that the client wanted some specific things in the wire-frames and in the website. (A website wire-frame is a basic design draft done before any artwork and used in web design to show the structure of a website, custom user paths, most important user interface elements, their position and relationships between website pages.) So we chosen CakePHP as a development framework instead of WordPress as it is quite hard to customize a website developed using WordPress. (CakePHP is a free, open-source, rapiddevelopment framework for PHP).
The basic business process life cycle follows specific steps as mentioned below:
The Admin sends few items to the wholesaler with specific details of each item. The wholesaler will choose some items from the list send by the admin and send that list back to the admin. Admin will decide which items will go for further order processing after order confirmation. And the system decides the factory in which the order will be processed further automatically
The Challenge
We tried some order processing systems but they seem slow in working as they have uploaded heavy images. We changed the image up loader component to Ajax base Image up loader which is faster compared to the previous image up loader components. We also realized that the server response was slow; So we consulted the client and suggested him to go with a dedicated server or VPS. After moving the website to VPS the performance increased by 50%.After the completion of the first phase successfully, the client suggested us that he should be able to import orders directly through an XLS file. They have a desktop application working on the intranet and they have the facility to import item details on an XLS file. So we implemented this functionality in their website. They also wanted us to add watermark in the ornament design images for the security purpose. we added watermark in all the ornament design images provided by the client.
Our Solution
This application is developed using CakePHP and MySQL. It is a web application for managing the designs of various jewelries, as well as for communicating with the clients of the organization regarding the delivery of the jewelries. The clients can see the designs of various Jewelries sent by the admin and can order the selected designs in a specific quantity. The Admin can assign the jewelry designs to the production department for the production of jewelry.
Approach
We followed basic steps of the Project Development Life Cycle as mentioned below:
1.Requirement Gathering and Analysis
2.Systems design
3.Development
4.Integration and testing
5.Acceptance, installation, deployment
6.Maintenance
Benefit
Through this system a client can easily track his/her orders and the overseas clients are quite happy with the system as they can visualize the jewelry in the real-time and they can order the selected jewelry anytime and from anywhere with the help of just a mouse click.
Technology
Framework: CakePHP
Scripting Language: PHP
Database: MySQL
Web technology: HTML5, CSS3, JavaScript, AJAX
Server: Linux