Service modul

I need a service module which is connected to the costumer database, and the inventory database of products on our webpage.

I want the module to perform the following:

1.

The ability to create new costumers and to search for costumers which have already been created.

We use this to when we want to create a new order of service, whenever a costumer wants a service to be done.

2.

When a new costumer/order of service is created, the following input should be required:

First & Lastname

Social Security Number

Adress

Telephone Number

E-mail

We also want that every costumer who hands in their unit for service, receives a number for that service. That number is to be based on the last 4 digits in the social security number of that costumer.

Ex. Social Security Number 1990-09-10-1234

Which translates to the costumer being born on the 10th of September, 1990. The last 4 digits is to identify that specific person.

Next, what kind of unit does the costumer have? We are thinking of 2 dropdown lists.

Manufacturer (Apple, Samsung, HTC, etc.)

Model (If manufacturer is Apple; then iPhone 5, iPhone 5S, iPad 4, etc.)

After the kind of unit has been established, we need to know what type of service the costumer is asking for. (Example, Screen replacement, speakers, etc.)

This function needs to be connected to the inventory database, since we run the same inventory for our webpage and for the local shop. We need to keep the same amount of stock in both places, regardless of where the costumer places his/her order.

So, for summary:

First/Lastname

Social Security Number

Adress

Telephone Number & Email

Unit selection (Manufacturer & Model)

Service selection (Screen replacement, speakers, water damage etc.)

We also need an overview of our orders of service.

Handed-In Units, Ongoing, Awaiting Parts and Finished.

(These should also be searchable since we sometimes handle business with warranties and we need to look back in our history of services.)

Databasprogrammering MySQL PHP Prestashop Programvaruarkitektur

Projekt-id: #8640226

Om projektet