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