Make Chart: MySQL to Array
$30-250 USD
Bezahlt bei Lieferung
Hello,
1. Two MySQL tables: Income & Expenses.
2. Convert and Combine entries by months (Jan, Feb - Dec).
LIKE THIS:
"categories": [
{
"category": [
{
"label": "Jan"
},
{
"label": "Feb"
}
],
"dataset": [
{
"seriesName": "Income",
"showValues": "1",
"renderAs": "bar",
"data": [
{
"value": "10000"
},
{
"value": "15000"
}
]
},
{
"seriesName": "Projected Revenue",
"renderAs": "line",
"data": [
{
"value": "7000"
},
{
"value": "11000"
}
]
},
{
"seriesName": "Expenses",
"renderAs": "bar",
"data": [
{
"value": "7000"
},
{
"value": "13000"
}
]
},
{
"seriesName": "Net Profit",
"renderAs": "area",
"data": [
{
"value": "3000"
},
{
"value": "2000"
}
]
}
]
}
////////
JUST TO OUTPUT THE DATA IN ARRAY.
- Expenses Categories: collect the filter expenses into categories and totals.
- Cash flow chart: Monthly Income, Expenses & Projected Revenue (Future Dated income) totals and Net Income (Income - Expenses).
when i click on the chart area [day or month] go to details page.
There is also Recurring Items should appear in reports,
Example table entry: Rent | 300 | Monthly | 12 (Time)
so we want to repeat this amount 12 time monthly.
Another Example:
Phone | 10 | Daily | Forever
here you need to add 10 for every day in the report for any report range.
The Last thing:
Ajax Checkup: I want to chose a date and return a table with income & expenses.
Chart Used is: FusionCharts v3.8.0
check this useful documents:
[login to view URL]
[login to view URL]
[login to view URL]
Projekt-ID: #8239812
Über das Projekt
26 Freelancer bieten im Durchschnitt $161 für diesen Job
Hello! With 98% to 99% completion rate, 800+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page [login to view URL] Mehr
Hello, sir. I am a expert Web developer. if you give me a chance, I will do best for you. Thank you!
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
We are very interested in this project. I have read your above description and i think its well within our range to execute this is in a good time frame so would you be kind enough to message me so we can have a fast a Mehr
I am an expert in delivering custom scripts and software willing to discuss further about the project needs.
Hello, We are experts in js charting and done many charting using high charts, amcharts, google charts etc.. We can work on fusion chart too. Ready to start now. Thanks.
let expert do this...............................................................................................................
Hi I have gone through the details of your project and we find it well within our capabilities. I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excite Mehr
Hello sir/madam, we have read and understand your requirement and very much confident that we can complete this project within low budget and less time . Give us chance to serve you better Looking forward to be Mehr
Need to discuss this in detail,please tell me how we can start the discussion on this requirement. We have a team of 34 professionals,they have more than 11 year of experience, expertise in php/mysql and their MVC f Mehr
I have this type of graph work using php & jquery. let me know if you really want to finish it asap. im here to looking such kind of work.
Hello, I have read the job description and i am 100% confident to complete this task. I am an expert with wide range of skills including, PHP, MySQL, Ajax, Jquery, Css, Bootstrap and CRM development. I am ready to sta Mehr