Lines 1190-1196
canned reports and writing custom SQL reports.</p>
Link Here
|
1190 |
|
1190 |
|
1191 |
[% IF results && !errors %] |
1191 |
[% IF results && !errors %] |
1192 |
$('#draw-chart').click(function() { |
1192 |
$('#draw-chart').click(function() { |
|
|
1193 |
var results = []; |
1194 |
if ($('input[name="chart-include-all"]').prop('checked')) { |
1195 |
$.getJSON("/cgi-bin/koha/svc/report?id=[% id %][%- FOREACH param IN sql_params %]&sql_params=[% param | uri %][% END %][%- FOREACH param_name IN param_names %]&param_name=[% param_name | uri %][% END %]",function(data){ |
1196 |
$.each(data, function(row_index,row_value){ |
1197 |
var row = []; |
1198 |
row_value.forEach(function(cell_value,cell_index){ |
1199 |
row.push({ cell: cell_value }); |
1200 |
}); |
1201 |
|
1202 |
results.push({ cells : row }); |
1203 |
}); |
1204 |
results.cells = results; |
1205 |
drawchart(results); |
1206 |
} |
1207 |
); |
1208 |
} |
1209 |
else { |
1210 |
results = [% results.json | $raw %]; |
1211 |
drawchart(results); |
1212 |
} |
1213 |
}); |
1193 |
|
1214 |
|
|
|
1215 |
function drawchart(results){ |
1194 |
var x_elements = $('select[name="x"]').val(); |
1216 |
var x_elements = $('select[name="x"]').val(); |
1195 |
var y_elements = []; |
1217 |
var y_elements = []; |
1196 |
var groups = []; |
1218 |
var groups = []; |
Lines 1199-1212
canned reports and writing custom SQL reports.</p>
Link Here
|
1199 |
|
1221 |
|
1200 |
headers = [% header_row.json | $raw %]; |
1222 |
headers = [% header_row.json | $raw %]; |
1201 |
|
1223 |
|
1202 |
var results; |
|
|
1203 |
if ($('input[name="chart-include-all"]').prop('checked')) { |
1204 |
results = [% allresults.json | $raw %] |
1205 |
} |
1206 |
else { |
1207 |
results = [% results.json | $raw %] |
1208 |
} |
1209 |
|
1210 |
if ($('input[name="chart-exclude-last"]').prop('checked')) { |
1224 |
if ($('input[name="chart-exclude-last"]').prop('checked')) { |
1211 |
results.splice(-1, 1); |
1225 |
results.splice(-1, 1); |
1212 |
} |
1226 |
} |
Lines 1257-1263
canned reports and writing custom SQL reports.</p>
Link Here
|
1257 |
$("#download-chart,#toggle_chart_settings_hid,#chart").show(); |
1271 |
$("#download-chart,#toggle_chart_settings_hid,#chart").show(); |
1258 |
$("#toggle_chart_settings_vis").hide(); |
1272 |
$("#toggle_chart_settings_vis").hide(); |
1259 |
$("#chartModal").modal("hide"); |
1273 |
$("#chartModal").modal("hide"); |
1260 |
}); |
1274 |
}; |
1261 |
[% END %] |
1275 |
[% END %] |
1262 |
[% IF ( create ) %] |
1276 |
[% IF ( create ) %] |
1263 |
load_group_subgroups(); |
1277 |
load_group_subgroups(); |
1264 |
- |
|
|