|
Lines 2276-2281
params:
Link Here
|
| 2276 |
budget |
2276 |
budget |
| 2277 |
orderstatus (note that orderstatus '' will retrieve orders |
2277 |
orderstatus (note that orderstatus '' will retrieve orders |
| 2278 |
of any status except cancelled) |
2278 |
of any status except cancelled) |
|
|
2279 |
managing_library |
| 2279 |
biblionumber |
2280 |
biblionumber |
| 2280 |
get_canceled_order (if set to a true value, cancelled orders will |
2281 |
get_canceled_order (if set to a true value, cancelled orders will |
| 2281 |
be included) |
2282 |
be included) |
|
Lines 2296-2302
returns:
Link Here
|
| 2296 |
'ordernumber' => '1', |
2297 |
'ordernumber' => '1', |
| 2297 |
'quantity' => 1, |
2298 |
'quantity' => 1, |
| 2298 |
'quantityreceived' => undef, |
2299 |
'quantityreceived' => undef, |
| 2299 |
'title' => 'The Adventures of Huckleberry Finn' |
2300 |
'title' => 'The Adventures of Huckleberry Finn', |
|
|
2301 |
'managing_library' => 'CPL' |
| 2300 |
} |
2302 |
} |
| 2301 |
|
2303 |
|
| 2302 |
=cut |
2304 |
=cut |
|
Lines 2322-2327
sub GetHistory {
Link Here
|
| 2322 |
my $ordernumber = $params{ordernumber}; |
2324 |
my $ordernumber = $params{ordernumber}; |
| 2323 |
my $search_children_too = $params{search_children_too} || 0; |
2325 |
my $search_children_too = $params{search_children_too} || 0; |
| 2324 |
my $created_by = $params{created_by} || []; |
2326 |
my $created_by = $params{created_by} || []; |
|
|
2327 |
my $managing_library = $params{managing_library}; |
| 2325 |
my $ordernumbers = $params{ordernumbers} || []; |
2328 |
my $ordernumbers = $params{ordernumbers} || []; |
| 2326 |
my $additional_fields = $params{additional_fields} // []; |
2329 |
my $additional_fields = $params{additional_fields} // []; |
| 2327 |
|
2330 |
|
|
Lines 2358-2363
sub GetHistory {
Link Here
|
| 2358 |
aqbasket.basketgroupid, |
2361 |
aqbasket.basketgroupid, |
| 2359 |
aqbasket.authorisedby, |
2362 |
aqbasket.authorisedby, |
| 2360 |
concat( borrowers.firstname,' ',borrowers.surname) AS authorisedbyname, |
2363 |
concat( borrowers.firstname,' ',borrowers.surname) AS authorisedbyname, |
|
|
2364 |
branch as managing_library, |
| 2361 |
aqbasketgroups.name as groupname, |
2365 |
aqbasketgroups.name as groupname, |
| 2362 |
aqbooksellers.name, |
2366 |
aqbooksellers.name, |
| 2363 |
aqbasket.creationdate, |
2367 |
aqbasket.creationdate, |
|
Lines 2484-2489
sub GetHistory {
Link Here
|
| 2484 |
push @query_params, @$created_by; |
2488 |
push @query_params, @$created_by; |
| 2485 |
} |
2489 |
} |
| 2486 |
|
2490 |
|
|
|
2491 |
if ( $managing_library ) { |
| 2492 |
$query .= " AND aqbasket.branch = ? "; |
| 2493 |
push @query_params, $managing_library; |
| 2494 |
} |
| 2495 |
|
| 2487 |
if ( @$ordernumbers ) { |
2496 |
if ( @$ordernumbers ) { |
| 2488 |
$query .= ' AND (aqorders.ordernumber IN ( ' . join (',', ('?') x @$ordernumbers ) . '))'; |
2497 |
$query .= ' AND (aqorders.ordernumber IN ( ' . join (',', ('?') x @$ordernumbers ) . '))'; |
| 2489 |
push @query_params, @$ordernumbers; |
2498 |
push @query_params, @$ordernumbers; |