Fusioncharts / php / mysql
I have a table called “tickets” in a database called “jazzfunk_cmms”
I need two fusioncharts generated from this table
1:-A field called “status“ contains an integer of values 0, 1 or 2. I require a 3D Pie chart of the amount of times each occurs in the table. The meaning of this field is as follows
0 = Open, 1 = In Progress, and 2 = Closed
That’s the easy bit!
Now the tricky part
2:- This table also contains a field called “assigned” This field contains an array in the as follows.
***U1U***U3U which means User 1 and User 3 are included the record
These need to be exploded, cleaned (so we just get 1 or 2 or 3 etc.), and joined to a table called “users” by [login to view URL] where I need to display “[login to view URL]” on the JOIN and finally in the Fusion chart.
Finally I require this to be put in a 3D stacked chart with reference to the “status” field as follows
How many times does the “assigned” user appear WHERE “status” = 1
How many times does the “assigned” user appear WHERE “status” = 2
X axis displays [login to view URL]
Y axis displays number of jobs (i.e. 1 = in progress and 2 = closed).
[login to view URL]
Tools(Yii framework).
[login to view URL]
Tools( Codeigniter framework)
Over the last 4 years, I have developed a wide range of websites for startup companies, small businesses and product base projects.
My core competency lies in complete end-end management of a new website development project, and I am seeking opportunities to build websites from the ground up for you or your business.
I have some experience in the following areas: .
Yii Framework,
CODEIGNITOR Framework
Doctrine ORM
Drupal
Smarty
Javascript
AJAX
Json
JQUERY
$77 USD em 7 dias
0,0 (0 avaliações)
0,0
0,0
5 freelancers estão ofertando em média $139 USD for esse trabalho
Dear sir. I'm a php and mysql expert and have rich experience. Especially I’m very good at wordpress. I can work fulltime and I'm ready for your requirement. My skill is build website neat and tidy.I hope you choose me and we work together.
Thanks.