You have chosen to sponsor your bid up to a maximum amount of .
My business partners sell notebooks, tablets and phones. I want to have a clear overview of what they are selling - what brands, what market shares, what average prices. I need this info each at the beggining of each month for one month and the partners are prepared to provide this data.
I need a database with few tables:
PARTNER table with following data:
- Account type (distributor, retail, etail...)
- Company name
- Contact person
- Contact phone
- Contact email
- Username and login password
INHOUSE SHARES table with:
- Product group (Notebook, Tablet, Phone...) // when filling in data the user can only pick a group previously defined by Admin
- Brand (HP, IBM, Samsung, Lenovo...) // when filling in data the user can only pick a brand previously defined by Admin
- QTY // meaning the total QTY sold in the listed month
- Revenue // total value of above QTY
- ASP // Average selling price calculated from above two data
I need each partner to be able to loggin and fill the data for their company, but cannot have access to the data from other companies.
I as the admin need to be able to view and export all data (for all companies together) into excel table.
Only admin can alter data in the PARTNER table
If possible the app should be php/mysql based and easy to transfer to my hosting server.