View | Details | Raw Unified | Return to bug 15219
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js (-4 / +1 lines)
Lines 730-739 $(document).ready(function() { Link Here
730
                "bServerSide": ServerSideCheckoutsTables,
730
                "bServerSide": ServerSideCheckoutsTables,
731
                "sAjaxSource": "/cgi-bin/koha/svc/checkouts",
731
                "sAjaxSource": "/cgi-bin/koha/svc/checkouts",
732
                "fnServerParams": function (aoData) {
732
                "fnServerParams": function (aoData) {
733
                    for (i in relatives_borrowernumbers) {
733
                    aoData.push({ "name": "borrowernumber", "value": relatives_borrowernumbers });
734
                        var borrowernumber = relatives_borrowernumbers[i];
735
                        aoData.push({ "name": "borrowernumber", "value": borrowernumber });
736
                    }
737
                },
734
                },
738
                "bPaginate": true,
735
                "bPaginate": true,
739
                "sPaginationType": "full",
736
                "sPaginationType": "full",
(-)a/svc/checkouts (-6 / +11 lines)
Lines 45-51 unless (haspermission($userid, { circulate => 'circulate_remaining_permissions' Link Here
45
    exit 0;
45
    exit 0;
46
}
46
}
47
47
48
my @borrowernumber   = $input->multi_param('borrowernumber');
48
my @borrowernumbers;
49
my $borrowernumber = $input->param('borrowernumber');
50
if ($borrowernumber) {
51
    push @borrowernumbers, $borrowernumber;
52
} else {
53
    @borrowernumbers = $input->multi_param('borrowernumber[]');
54
}
49
my $offset = $input->param('iDisplayStart');
55
my $offset = $input->param('iDisplayStart');
50
my $count = $input->param('iDisplayLength');
56
my $count = $input->param('iDisplayLength');
51
57
Lines 125-137 my $sql = ' Link Here
125
';
131
';
126
132
127
my $borrowernumber_sql = 'borrowernumber';
133
my $borrowernumber_sql = 'borrowernumber';
128
if ( @borrowernumber == 1 ) {
134
if ( @borrowernumbers == 1 ) {
129
    $borrowernumber_sql .= ' = ?';
135
    $borrowernumber_sql .= ' = ?';
130
} else {
136
} else {
131
    $borrowernumber_sql .= ' IN (' . join( ',', ('?') x @borrowernumber ) . ') ';
137
    $borrowernumber_sql .= ' IN (' . join( ',', ('?') x @borrowernumbers ) . ') ';
132
}
138
}
133
$sql .= $borrowernumber_sql;
139
$sql .= $borrowernumber_sql;
134
push( @parameters, @borrowernumber );
140
push( @parameters, @borrowernumbers );
135
141
136
$sql .= " $orderby";
142
$sql .= " $orderby";
137
143
Lines 257-263 print $input->header( -type => 'application/json', -charset => 'UTF-8' ); Link Here
257
my $sEcho = $input->param('sEcho');
263
my $sEcho = $input->param('sEcho');
258
my ($iTotalRecords) = $dbh->selectrow_array(
264
my ($iTotalRecords) = $dbh->selectrow_array(
259
    "SELECT COUNT(*) FROM issues WHERE $borrowernumber_sql", undef,
265
    "SELECT COUNT(*) FROM issues WHERE $borrowernumber_sql", undef,
260
    @borrowernumber);
266
    @borrowernumbers);
261
267
262
my $response = {
268
my $response = {
263
    iTotalRecords => $iTotalRecords,
269
    iTotalRecords => $iTotalRecords,
264
- 

Return to bug 15219