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