Closed

Product Specification Management Portal redesign

Looking for PHP and mysql expert to redesign our specification management portal to database and the web pages to meat the following requirements

This Portal requires 2 areas:

1. Admin

2. Client

Admin Portal Functionalities:

1. Admin should be able to mange client accounts.

2. Able to create a portal backup and restore from backup.

3. Able to upload client official LOGO individual clients

Client Portal Functionalities:

Ability to Manage Suppliers:

1. Able to create and change Testing characteristic

2. Able to Create a material specification

3. Able to generate a sample for material/lot by copying the existing material specification

4. Ability record/enter results for the material/lot within generated sample

5. Ability to approve or reject a material/lot for a individual sample and overall material/lot

6. Ability to mass upload the database from Excel format to the Portal.

Ability to run following Reports:

1. List of Material, Lot and Test Results

2. List of Material and lot with approval or rejections

Following are the details of the each Form and how it should be developed:

1. Product specification:

List of Fields: Material Specification ID, Material No, Material Description, Plant, Operation No, Operation Description, Characteristics ID, Characteristics Description, Unit Of Measurement, Decimal Place, Lower Limit, Upper Limit, Target Value, Catalog, Test Method ID, and Test Comment

Many of these fields values to be copied for another table for example, we are maintaining in another table with fields: Characteristics ID, Characteristics Description, Unit Of Measurement, Decimal Place, Lower Limit, Upper Limit, Target Value, Catalog, Test Method ID and Characteristics ID is the key for them, so, when creating the Product specification and add a specific Characteristics ID then Form program should automatically copy the data related to the Characteristics ID.

Product specification Form will have three levels as follows:

1. Specification Header
Associated fields for this level are: Specification ID, Material No, Material Description, and Plant.

2. Specification Operation Lines
Associated fields for this level are: Operation No, and Operation Description

3. Specification Characteristics
Associated fields for this level are: Characteristics ID, Characteristics Description, Unit Of Measurement, Decimal Place, Lower Limit, Upper Limit, Target Value, Catalog, Test Method ID, and Test Comment

The Product Specification the field structure has to be in vertical. Because, for each product specification header may have many specification operations and each specification operations may have many Specification Characteristics.

Refers to following:
Product specification Form will have three levels as follows:

4. Specification Header
Associated fields for this level are: Specification ID, Material No, Material Description, and Plant.

5. Specification Operation Lines
Associated fields for this level are: Operation No, and Operation Description

6. Specification Characteristics
Associated fields for this level are: Characteristics ID, Characteristics Description, Unit Of Measurement, Decimal Place, Lower Limit, Upper Limit, Target Value, Catalog, Test Method ID, and Test Comment


2. Sample loading by copying the Product Specification:
List of Fields: Material No, Lot No, Plant, Number of Samples

On this Form with above fields Material and Plant reference Product Specification should be copied with all the fields and an incremental sample number (Filed name: Sample ID) should be generated in a same table.


3. Result Recording for the Samples:
List of Fields: Sample ID, Material No, Material Description, Plant, Operation No, Operation Description, Characteristics ID, Characteristics Description, Unit Of Measurement, Decimal Place, Lower Limit, Upper Limit, Target Value, Catalog, Test Method ID, Test Comment and additional fields: Actual Result, Result Valuation, Test Comments

On the Result Recording for Sample Form should copy all the field values/data during Sample Loading (on the process of #2 Form) addition to that three additional field should be added to each sample to input data/value for Actual Result, Result Valuation, and Test Comments.


4. Make Approve or Reject the Item:
List of Fields: Material No, Lot No, Plant, Status
Once the Form#2 processed then it should also populate a status table with above fields and an additional field: Status should be able to take accept or reject value and save to product status table.

Skills: Graphic Design, HTML, MySQL, PHP, Website Design

See more: client portal specification, product specification portal, web portal requirements, test excel expert, requirements and specification, product list design, product design specification, product database design, portal specification, logo official, excel test expert, excel specification, create official website, create a management logo, Specification, product testing, product test, Product Management, product manage, official logo, meat, logo portal, client management, generate reports excel, website design client portal

About the Employer:
( 0 reviews ) United States

Project ID: #1133269

7 freelancers are bidding on average $578 for this job

DevWorkshop

Please see [url removed, login to view] you

$250 USD in 7 days
(882 Reviews)
8.3
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$1000 USD in 30 days
(56 Reviews)
7.0
webspidy

Sir, We at the WebSpidy, Kolkata have gone through your requirements, and with our extensive knowledge in web technology, we can deliver the designs you asked for. Please Revert back, if you are interested in our wor More

$1200 USD in 20 days
(15 Reviews)
6.9
mindblowcreative

Please see PMB, thanks!

$1300 USD in 16 days
(19 Reviews)
6.8
trustus

Please check PM for details. . .. ..

$500 USD in 25 days
(51 Reviews)
6.3
arsprojects

hello sir please check the pm for more detail

$600 USD in 30 days
(1 Review)
1.2
ahsan077

Im ready to do this project...

$500 USD in 6 days
(0 Reviews)
0.0
Jadav84

hi, please have a look on my pm.. thanks

$1000 USD in 30 days
(0 Reviews)
0.0
devloperweb

Sounds good, thats very much easy. ready to work, have 8 years of experienced. I will give you the best quality of work & stisfie you & completed this job within given timeframe. I design & developed the whole package More

$199 USD in 10 days
(0 Reviews)
0.0