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