|
Lines 2085-2090
sub GetHistory {
Link Here
|
| 2085 |
my $isbn = $params{isbn}; |
2085 |
my $isbn = $params{isbn}; |
| 2086 |
my $ean = $params{ean}; |
2086 |
my $ean = $params{ean}; |
| 2087 |
my $name = $params{name}; |
2087 |
my $name = $params{name}; |
|
|
2088 |
my $internalnote = $params{internalnote}; |
| 2089 |
my $vendornote = $params{vendornote}; |
| 2088 |
my $from_placed_on = $params{from_placed_on}; |
2090 |
my $from_placed_on = $params{from_placed_on}; |
| 2089 |
my $to_placed_on = $params{to_placed_on}; |
2091 |
my $to_placed_on = $params{to_placed_on}; |
| 2090 |
my $basket = $params{basket}; |
2092 |
my $basket = $params{basket}; |
|
Lines 2150-2155
sub GetHistory {
Link Here
|
| 2150 |
aqorders.biblionumber, |
2152 |
aqorders.biblionumber, |
| 2151 |
aqorders.orderstatus, |
2153 |
aqorders.orderstatus, |
| 2152 |
aqorders.parent_ordernumber, |
2154 |
aqorders.parent_ordernumber, |
|
|
2155 |
aqorders.order_internalnote, |
| 2156 |
aqorders.order_vendornote, |
| 2153 |
aqbudgets.budget_name |
2157 |
aqbudgets.budget_name |
| 2154 |
"; |
2158 |
"; |
| 2155 |
$query .= ", aqbudgets.budget_id AS budget" if defined $budget; |
2159 |
$query .= ", aqbudgets.budget_id AS budget" if defined $budget; |
|
Lines 2242-2247
sub GetHistory {
Link Here
|
| 2242 |
} |
2246 |
} |
| 2243 |
} |
2247 |
} |
| 2244 |
|
2248 |
|
|
|
2249 |
if ( $internalnote ) { |
| 2250 |
$query .= " AND aqorders.order_internalnote LIKE ? "; |
| 2251 |
push @query_params, "%$internalnote%"; |
| 2252 |
} |
| 2253 |
|
| 2254 |
if ( $vendornote ) { |
| 2255 |
$query .= " AND aqorders.order_vendornote LIKE ?"; |
| 2256 |
push @query_params, "%$vendornote%"; |
| 2257 |
} |
| 2258 |
|
| 2245 |
if ($booksellerinvoicenumber) { |
2259 |
if ($booksellerinvoicenumber) { |
| 2246 |
$query .= " AND aqinvoices.invoicenumber LIKE ? "; |
2260 |
$query .= " AND aqinvoices.invoicenumber LIKE ? "; |
| 2247 |
push @query_params, "%$booksellerinvoicenumber%"; |
2261 |
push @query_params, "%$booksellerinvoicenumber%"; |