Try making a google chart API helper which will make js code for chart
on-fly using js helper of cake PHP. I have a one written by me but works
only for pie charts with some restrictions . If you want e-mail me for it.
Will be happy to help you.
On Mar 30, 2012 8:28 PM, "phpMagpie" <p...@webbedit.co.uk> wrote:
> I've outputted some charts (combocharts - near identical to column chart)
> using the visualization api and got the model to output an array like:
>
> Array
> (
> [labels] => Array
> (
> [0] => Age
> [1] => Clients
> [2] => Not Offered
> [3] => Accepted Offer
> [4] => Declined Offer
> )
>
> [16] => Array
> (
> [0] => 16
> [1] => 10
> [2] => 7
> [3] => 5
> [4] => 0
> )
>
> [17] => Array
> (
> [0] => 17
> [1] => 27
> [2] => 22
> [3] => 13
> [4] => 4
> )
>
> [18] => Array
> (
> [0] => 18
> [1] => 13
> [2] => 8
> [3] => 7
> [4] => 2
> )
>
> [19] => Array
> (
> [0] => 19
> [1] => 12
> [2] => 6
> [3] => 6
> [4] => 1
> )
>
> [20] => Array
> (
> [0] => 20
> [1] => 8
> [2] => 2
> [3] => 6
> [4] => 0
> )
>
> [21] => Array
> (
> [0] => 21
> [1] => 7
> [2] => 4
> [3] => 3
> [4] => 0
> )
>
> )
>
> I then ran this through the following
> foreach($arrayFromModel AS $row) {
> $chartData[] = json_encode($row);
> }
>
> and ended up with:
> Array
> (
> [0] => ["Age","Clients","Not Offered","Accepted Offer","Declined
> Offer"]
> [1] => ["16",10,7,5,0]
> [2] => ["17",27,22,13,4]
> [3] => ["18",13,8,7,2]
> [4] => ["19",12,6,6,1]
> [5] => ["20",8,2,6,0]
> [6] => ["21",7,4,3,0]
> )
>
> With an array of this type you use the following google function to get
> your data table:
> var data = google.visualization.arrayToDataTable([".join(',',
> $chartData)."]);
>
> Hope this is of some help, phpMagpie
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com For more options, visit this group
> at http://groups.google.com/group/cake-php
>
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
