Update PHP Pages that contain amCharts

Update PHP Pages that contain amCharts

Closed - This job posting has been filled and work has been completed.

Job Description

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

You can view the pages at http://174.127.71.14/charts/Charts.php

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.

<table>
<thead>
<th>Case Number</th>
<th>Age</th>
<th>Race</th>
<th>Gender</th>
<th>Hearings</th>
<th>Charges</th>
<th>Conditions</th>
<th>Custody Information</th>
</thead>
<tbody>
<tr>
<td>strDefendant_casenumber

</td>
<td>strDefendant_age</td>
<td>strDefendant_race</td>
<td>strDefendant_gender</td>
<td>
<table><tr><td>strHearing_court Date: dtHearing_dateofhearing Status:

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

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

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



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).

Other open jobs by this client