Closed

vTiger simple customized reports and graphs - SQL and PHP needed

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

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: PHP, SQL, vTiger

See more: vtiger sql report, graphs sql php, what is graphs, what does product and services design do, what are graphs used for, what are graphs for, what are graphs, top graph, structure graph, sql price, simple reporting, search graphs, reporting services sql, product and service, logo design graph, logo design for reports, link graphs, graph top, graph structure, graphs in c, graphs c, graph graphs, get quotes for logo design, custom logo names, c graphs

About the Employer:
( 29 reviews ) Montevideo, Uruguay

Project ID: #5232019

8 freelancers are bidding on average $195 for this job

hunterboss

A proposal has not yet been provided

$154 USD in 4 days
(117 Reviews)
6.9
OutsourceMan

We will help you with: vTiger simple customized reports and graphs - SQL and PHP needed Hello, Greetings from "Hire WordPress and Design Experts". We would like to assure you that we have best of WordPress programme More

$249 USD in 25 days
(67 Reviews)
6.8
otssols

Hello Akma Thanks for your post. I am Rishi , a business consultant with OTS Solutions. We are a CMMI Level 3, ISO 9001, 2008 and Microsoft certified outsourced software Development Company. We carry a strong p More

$210 USD in 3 days
(7 Reviews)
6.3
auriclesoft09

Hi there! We are a Software Company with a team of 55 in-house developers in a hierarchy of Seniors and Juniors. Expertise in Open Source/CRM/ERP/POS/Custom Solutions/Web designing/Ecommerce. We do customization a More

$193 USD in 7 days
(29 Reviews)
6.1
Codomotive

Hi, You basically need a CRM management report generation in graphical view, we are working in the PHP for last 7 years, we can create all the necessary things as you required. I am sending all the recent works deta More

$200 USD in 7 days
(12 Reviews)
4.8
otssolutions01

Hello Akma Thanks for your post. I am Rishi , a business consultant with OTS Solutions. We are a CMMI Level 3, ISO 9001, 2008 and Microsoft certified outsourced software Development Company. We carry a strong p More

$210 USD in 5 days
(1 Review)
4.7
fixfin

Hi We are confident that we can accomplish the project as per your requirement. You are requested to go through our Profile to know our domain knowledge and our Services. We have done lots of customization on Sug More

$150 USD in 7 days
(5 Reviews)
3.0
gkws

Hello Sir/ Mam, Thanks for posting the project on Freelancer, this project exactly matches with our technical strengths. We have more than 30 plus retail and agency clients and have successfully completed over 100 More

$185 USD in 15 days
(2 Reviews)
2.3
tackymindz

Dear Sir Hi, Greetings of the day and thanks for sharing these details and allowing me to bid on this assignment. yes we have similar experience and can deliver u as u have mentioned in your requirements. we More

$242 USD in 12 days
(0 Reviews)
0.0
emMnkilDQLWd

Hi we are a team of freelance software developers, if you contact me at our website we can discuss the details of the project. w w w . s o l ve r . i o

$155 USD in 3 days
(0 Reviews)
0.0
ajaysfreelancer

Hello, We have more than 5 year experience in CRM development and customization , till now we have done more than 35 project so we can easily work on any version of vtiger crm. Also we have ability More

$222 USD in 3 days
(0 Reviews)
0.0