Update PHP Pages that contain amCharts

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Web Development Posted 2 years ago

Fixed Price

Delivery by December 22, 2013




I have a number of graphs using amcharts that need improvements.  

You can view the pages at

To see a chart, select "Denver County Court", then "DRIVING WHILE ABILITY IMPAIRED M (42-4-1301(1)(B))", then "Most Likely Conditions".

I am hoping to make the following additions to the charts, via javascript, to dig further into the data with the following additions:

1) I am hoping to add some filters to the left side of the page for the charts.  I am hoping to have the following options that are based on fields in the database:
a) having checkboxes for
i) race (strDefendant_race) using checkboxes so that the person can select the races that he would like to consider in the results, so that the charts only show results for the race that has been selected.  
ii) gender (strDefendant_gender) using checkboxes so that the person can select the genders that he would like to consider,
iii) age (strDefendant_DOB) using sliders so that th eperson can set a minimum and a maximum for the age that he would like to consider.
iv) a textbox where the user can search for a substring within the results and only show the results that contain the substring.
v) a checkbox to determine whether to overlay the filtered graph next to the old graph (using a clustered bar chart like http://www.amcharts.com/javascript-charts/clustered-bar/) or to only show the filtered graph (using the chart that we currently use).
b) once the user selects the filters that he would like to use, the chart should update showing either the clustered chart or only the filtered chart (depending on his selection in step v).

2) I am hoping that you can make the bars in the chart clickable so that a use can see the portion of the data that contains that bar.  For example, if the user selects Denver County Court then Careless Driving, then clicks on "Comm Serv Ordered", I would like to show all of the records in a table (like the one below) that include "Comm Serv Ordered" as a condition in a lightbox.

<th>Case Number</th>
<th>Custody Information</th>

<table><tr><td>strHearing_court   Date: dtHearing_dateofhearing   Status:

strHearing_status</td></tr></table>  //with a new row for each hearing
<table><tr><td>strCrime_name   Statute: strCrime_statuteno   Class: strCrime_class</td></tr></table>  

//with a new row for each hearing
<table><tr><td>strCondition_name</td></tr></table>  //with a new row for each condition
<td>dtBooking_datebooked, dtBooking_releasedate, difference between dtBooking_releasedate and dtbooking_datebooked</td>

</tr>  //with a new row for each case

3)  I am hoping to show all of the graphs on a single page instead of having the user select the chart that he wants to view.

4) I am hoping to include the data table below the charts (in the same format as the table above).

About the Client

(4.86) 109 reviews

United States
Broomfield 01:42 PM

250 Jobs Posted
66% Hire Rate, 4 Open Jobs

Over $10,000 Total Spent
178 Hires, 2 Active

$6.60/hr Avg Hourly Rate Paid
1,442 Hours

Member Since May 19, 2005