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%"; |