Revision 612e3ebe
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 507 | 507 |
} |
| 508 | 508 |
} |
| 509 | 509 |
|
| 510 |
if ($form->{parts_partnumber}) {
|
|
| 511 |
$where .= <<SQL; |
|
| 512 |
AND EXISTS ( |
|
| 513 |
SELECT invoice.trans_id |
|
| 514 |
FROM invoice |
|
| 515 |
LEFT JOIN parts ON (invoice.parts_id = parts.id) |
|
| 516 |
WHERE (invoice.trans_id = a.id) |
|
| 517 |
AND (parts.partnumber ILIKE ?) |
|
| 518 |
LIMIT 1 |
|
| 519 |
) |
|
| 520 |
SQL |
|
| 521 |
push @values, like($form->{parts_partnumber});
|
|
| 522 |
} |
|
| 523 |
|
|
| 524 |
if ($form->{parts_description}) {
|
|
| 525 |
$where .= <<SQL; |
|
| 526 |
AND EXISTS ( |
|
| 527 |
SELECT invoice.trans_id |
|
| 528 |
FROM invoice |
|
| 529 |
WHERE (invoice.trans_id = a.id) |
|
| 530 |
AND (invoice.description ILIKE ?) |
|
| 531 |
LIMIT 1 |
|
| 532 |
) |
|
| 533 |
SQL |
|
| 534 |
push @values, like($form->{parts_description});
|
|
| 535 |
} |
|
| 536 |
|
|
| 510 | 537 |
if ($where) {
|
| 511 | 538 |
substr($where, 0, 4, " WHERE "); |
| 512 | 539 |
$query .= $where; |
| bin/mozilla/ap.pl | ||
|---|---|---|
| 903 | 903 |
vendornumber country ustid taxzone payment_terms charts direct_debit); |
| 904 | 904 |
|
| 905 | 905 |
my @hidden_variables = map { "l_${_}" } @columns;
|
| 906 |
push @hidden_variables, "l_subtotal", qw(open closed vendor invnumber ordnumber transaction_description notes project_id transdatefrom transdateto department); |
|
| 906 |
push @hidden_variables, "l_subtotal", qw(open closed vendor invnumber ordnumber transaction_description notes project_id transdatefrom transdateto department |
|
| 907 |
parts_partnumber parts_description); |
|
| 907 | 908 |
|
| 908 | 909 |
my $href = build_std_url('action=ap_transactions', grep { $form->{$_} } @hidden_variables);
|
| 909 | 910 |
|
| ... | ... | |
| 959 | 960 |
push @options, $locale->text('Order Number') . " : $form->{ordnumber}" if ($form->{ordnumber});
|
| 960 | 961 |
push @options, $locale->text('Notes') . " : $form->{notes}" if ($form->{notes});
|
| 961 | 962 |
push @options, $locale->text('Transaction description') . " : $form->{transaction_description}" if ($form->{transaction_description});
|
| 963 |
push @options, $locale->text('Part Description') . " : $form->{parts_description}" if $form->{parts_description};
|
|
| 964 |
push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}" if $form->{parts_partnumber};
|
|
| 962 | 965 |
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1) if ($form->{transdatefrom});
|
| 963 | 966 |
push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{transdateto}, 1) if ($form->{transdateto});
|
| 964 | 967 |
push @options, $locale->text('Open') if ($form->{open});
|
| templates/webpages/ap/search.html | ||
|---|---|---|
| 55 | 55 |
</tr> |
| 56 | 56 |
<tr> |
| 57 | 57 |
<th align=right nowrap>[% 'Notes' | $T8 %]</th> |
| 58 |
<td colspan=3><input name=notes size=40></td> |
|
| 58 |
<td><input name=notes size=20></td> |
|
| 59 |
<th align="right">[% 'Part Description' | $T8 %]</th> |
|
| 60 |
<td><input name="parts_description" size="20"></td> |
|
| 59 | 61 |
</tr> |
| 60 | 62 |
<tr> |
| 61 | 63 |
<th align="right">[% 'Project Number' | $T8 %]</th> |
| 62 |
<td colspan="3">
|
|
| 64 |
<td> |
|
| 63 | 65 |
[%- INCLUDE 'generic/multibox.html' |
| 64 | 66 |
name = 'project_id', |
| 65 | 67 |
style = "width: 250px", |
| ... | ... | |
| 71 | 73 |
allow_textbox = 0, |
| 72 | 74 |
-%] |
| 73 | 75 |
</td> |
| 76 |
<th align="right">[% 'Part Number' | $T8 %]</th> |
|
| 77 |
<td><input name="parts_partnumber" size="20"></td> |
|
| 74 | 78 |
</tr> |
| 75 | 79 |
<tr> |
| 76 | 80 |
<th align=right nowrap>[% 'From' | $T8 %]</th> |
Auch abrufbar als: Unified diff
Einkaufsrechnungen: Suche nach Artikelnummer/-beschreibung in Positionen