The client approached us with a requirement to develop an inventory management application and wanted us to develop a form automation application as well.
We have created two applications for this project. First application for an Inventory Management Application and the other one for a Form Automation Application. The inventory management application is meant to handle the product information part. The client deals with medicines, so the inventory deals in various information like the expiry date, manufacturer details, quantity, order date, received date etc. of the medicines he offers.
There are four AWBs (Swiss, Lufthansa, Iceland, Asaman ) supported on this Logistics Application. User can generate the PDF of all AWB bill. Each AWB is having a separate formula to calculate the price like shipping charge. All the AWB prices have been stored in a database of the application. This application will run on LAN.
The admin of the site can add as many products as required as per the demands of customers into the application. All the added products have their log and help admin to generate a report. The reports carry all the information of products; and will also display details like the shipping date, customer name, manufacturer details, license number, etc.
The Form Automation Application deals with the Swiss Air Way bills. This application is meant for the users who are registered with the site as agents. They can login into the application and fill up the form to generate a PDF file which will carry all the information. Every form has it’s own formula to calculate the bill. The admin of the site can manage the users and can provide the role access. We have used the YII framework to develop these applications. MySQL database and jQuery, JSON are the technologies used in the project.
Created an automated form to manage the inventory system. Forms are serialized and now store for easy search & retrieval. All forms are stored in a repository – Easy to access ( in thumbnail format). Forms are now assigned a number, searchable by date, client name, date range, form ID, number. Saved forms can be printed, emailed or faxed.