Closed

Market share input form

Hi

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:

- Country

- Account type (distributor, retail, etail...)

- Company name

- Contact person

- Contact phone

- Contact email

- Username and login password

INHOUSE SHARES table with:

- Year

- Month

- 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.

Skills: MySQL, PHP

See more: want to market my business, tablet ibm, lenovo, i want to market a product, i need a brand name for my business, ibm user, ibm tablet, ibm email, ibm at, php mysql market share, market prices, i want distributor, i want to market my company, hp server, data transfer from email to excel, mysql excel export, sell shares, average php mysql, export excel data mysql, product shares, email data access 2013, business form filling, distributor email, mysql export excel, market data mysql

About the Employer:
( 2 reviews ) Ljubljana, Slovenia

Project ID: #4321721

9 freelancers are bidding on average $145 for this job

hits

We are a team of developers with immense expertise and experience in PHP and MySql. We have developed several custom applications. I have read your requirement - it is very simple and I ensure a very thorough and q More

$150 USD in 3 days
(795 Reviews)
8.7
linuxfreak1985

Hi there, We are experts in PHP Open Source (any kind of PHP/MySQL work),wordpress and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below [url removed, login to view] More

$250 USD in 10 days
(63 Reviews)
5.7
webangel1

ready to start please check previous work thank you....

$250 USD in 10 days
(18 Reviews)
4.4
thinhnp

Hi. I'll make this really fast, by PHP+MySQL. All forms, web pages & excel reports will be exactly like what you want. I'm ready to start immediately

$125 USD in 1 day
(7 Reviews)
3.8
mascot123

I am ready to start your project. Please check your personal messages for details. Thanks!

$180 USD in 5 days
(7 Reviews)
3.1
sourishdutta

me and my team will put 200% effort to make you 101% satisfied

$125 USD in 10 days
(1 Review)
1.4
lightweightcoder

Hi, I am having 7 years of experience in web development and design in PHP,Java,MySQL. I can complete this task for you. Thanks

$80 USD in 5 days
(0 Reviews)
0.0
Davidincsoft

Hello, 4+ years exp full time freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.

$200 USD in 5 days
(0 Reviews)
0.0
getkarthik

We have experience in PHP, HTML5, CSS3, Java, Smarty template engine, PAT, Yii framework, Mysql, Javascript, Google Map API, AJAX, Drupal & Joomla. Also we will deliver a project ontime.

$100 USD in 10 days
(0 Reviews)
1.0
octsol

I am ready to start right away

$45 USD in 1 day
(0 Reviews)
0.0