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