@@ -, +, @@ --- koha-tmpl/intranet-tmpl/prog/js/checkouts.js | 5 +---- svc/checkouts | 16 +++++++++++----- 2 files changed, 12 insertions(+), 9 deletions(-) --- a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js +++ a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js @@ -730,10 +730,7 @@ $(document).ready(function() { "bServerSide": ServerSideCheckoutsTables, "sAjaxSource": "/cgi-bin/koha/svc/checkouts", "fnServerParams": function (aoData) { - for (i in relatives_borrowernumbers) { - var borrowernumber = relatives_borrowernumbers[i]; - aoData.push({ "name": "borrowernumber", "value": borrowernumber }); - } + aoData.push({ "name": "borrowernumber", "value": relatives_borrowernumbers }); }, "bPaginate": true, "sPaginationType": "full", --- a/svc/checkouts +++ a/svc/checkouts @@ -45,7 +45,13 @@ unless (haspermission($userid, { circulate => 'circulate_remaining_permissions' exit 0; } -my @borrowernumber = $input->multi_param('borrowernumber'); +my @borrowernumbers; +my $borrowernumber = $input->param('borrowernumber'); +if ($borrowernumber) { + push @borrowernumbers, $borrowernumber; +} else { + @borrowernumbers = $input->multi_param('borrowernumber[]'); +} my $offset = $input->param('iDisplayStart'); my $count = $input->param('iDisplayLength'); @@ -125,13 +131,13 @@ my $sql = ' '; my $borrowernumber_sql = 'borrowernumber'; -if ( @borrowernumber == 1 ) { +if ( @borrowernumbers == 1 ) { $borrowernumber_sql .= ' = ?'; } else { - $borrowernumber_sql .= ' IN (' . join( ',', ('?') x @borrowernumber ) . ') '; + $borrowernumber_sql .= ' IN (' . join( ',', ('?') x @borrowernumbers ) . ') '; } $sql .= $borrowernumber_sql; -push( @parameters, @borrowernumber ); +push( @parameters, @borrowernumbers ); $sql .= " $orderby"; @@ -257,7 +263,7 @@ print $input->header( -type => 'application/json', -charset => 'UTF-8' ); my $sEcho = $input->param('sEcho'); my ($iTotalRecords) = $dbh->selectrow_array( "SELECT COUNT(*) FROM issues WHERE $borrowernumber_sql", undef, - @borrowernumber); + @borrowernumbers); my $response = { iTotalRecords => $iTotalRecords, --