vTiger simple customized reports and graphs - SQL and PHP needed

CLOSED
Bids
10
Avg Bid (USD)
$193
Project Budget (USD)
$30 - $250

Project Description:
Reporting needs:

- A report that adds up the value of a custom field in accounts for 7 vtiger users to whom the accounts are assigned to, and makes a graph. The accounts have a field named "yearly sales potential", so I want a graph that on one axis shows the names of the users and on the other axis shows the sum of that field for all his assigned accounts.
- Same as before, but instead of doing it for accounts, it does it for opportunities and the field "Amount", so, I want a graph that on one axis has the list of these 7 vTiger users, and on the other, it has the value of the sum of all the "amount" field for all the opportunities assigned to him on the *current* year.
- Exact same as before, but only adding the closed-won oportunities of each user.
- For each product and service, search for all the "approved" *quotes* that contain them, and get the list price and do an average price for each of them. Then make 2 graphs, one for services and one for products, that does on one axis, product or service name, and on the other, its average unit price.
- Same as above, but instead of having the average list price on the second axis, we need the amount of times the product or service was used in all "approved" quotes of the current year.

Notes:
- All graphs will be simple columns, maybe with different colours per items.
- This will probably need an new html produced with php placed somewhere in the vTiger structure with a link in an existing vTiger page, that is fine, nothing fancy is needed design wise, just maybe a title and logo on top.
- This is a system mainly used in spanish, so I'll tell you exactly what the axis names, etc. need to be.
- I'll give you access to the system, but I need all the code separately afterwards.

Regards,
Akma

Additional Project Description:
12/16/2013 at 9:29 IST
This is basically 5 relatively simple SQL queries to make a table for each report, and then graph the table in an HTML. Queries should be simple if you know your way around vTiger's DB.

Skills required:
PHP, SQL, vTiger
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 154
in 4 days
$ 249
in 25 days
$ 210
in 3 days
$ 193
in 7 days
$ 200
in 7 days
$ 210
in 5 days
Hire fixfin
$ 150
in 7 days
$ 185
in 15 days
Hire tackymindz
$ 242
in 12 days
Hire emMnkilDQLWd
$ 155
in 3 days