Design a small web application with PHP to seek and calculate products prices.

The web application is called PCS (Price Consult System).

The specification is on Bitbucket. [url removed, login to view]

Our database is Firebird and is on a remote server on AWS (Amazon).

The main application's goal is to allow all the users seek for the product's price quickly and allow the administrator manage the product's price and updates with our ERP called Ilux (Firebird database) in a fast and easy way.

*** This feature is very important ***

The whole program interface will be translated into the Portuguese language and therefore the messages of the interface should be registered as constants in the code and in a single file for easy maintenance and to allow us to make the translation to Portuguese.

The application will be used for 4 types of users with different privileges. So, there are four kinds of visions or privileges that will be detailed further up.

1- Administrator

2- Manager

3- Technical

4- Sales

All the functions of the application would be


F1. Manage the user table INN_Price_Users with CRUD (Create, Read, Update, Delete).

F2. Manage the markup table INN_Price_Markup with CRUD. This table has the product's factors that when multiplied by the product cost calculate the price of a product.

F3. Import an Excel .xls file with the product list and their costs updating the table INN_Price_Products_cost.

F4. Manage the product table INN_Price_Products_cost with the products and their costs and prices.

F5. Calculate all the prices and update the product table INN_Price_Products_cost with the prices calculated.

F6. Update the prices on the system Ilux, updating the table ITABPRECOIT.

F7. List and export historical data of the products searched by users and registered in INN_Price_Searched.

F8. Seek and show the products and their prices.

F9. Seek and show the product balance in the stock.

The specification F3 is ready to develop. The project is small and we are developing the other functions very quickly and will be ready soon while the first functionality F3 is being developed.

The first budget is to develop the F3 function.

Skills: Amazon Web Services, MySQL, PHP, Software Architecture

See more: php work from home projects, online php work from home, looking for php projects, php freelance work from home, php freelance work provider, online php jobs from home, php jobs online, how to get freelance php projects, small web application php mysql, technical design document web application php, design small web php, small web application company, technical design document web application, invoice web application php, send sms web application php, sms web application php, java design pattern web application survey, rock band web application php, project management web application php ldap, updating web application php

About the Employer:
( 3 reviews ) Recife, Brazil

Project ID: #15675158

6 freelancers are bidding on average $42 for this job


A proposal has not yet been provided

$111 USD in 7 days
(26 Reviews)

i am experienced and no one can do it better than me. Relevant Skills and Experience Amazon Web Services, MySQL, PHP, Software Architecture Proposed Milestones $30 USD - def

$30 USD in 1 day
(46 Reviews)

Hello. I read your job description very carefully and found that your specifications are really match to my skills. I will deliver you perfect result Relevant Skills and Experience Skills: PHP frameworks: CodeIgniter, More

$35 USD in 1 day
(3 Reviews)
$35 USD in 1 day
(17 Reviews)

A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)

A proposal has not yet been provided

$10 USD in 1 day
(0 Reviews)