Revision d05e1443
Von Moritz Bunkus vor mehr als 8 Jahren hinzugefügt
| SL/AR.pm | ||
|---|---|---|
| 584 | 584 |
} |
| 585 | 585 |
}; |
| 586 | 586 |
|
| 587 |
if ($form->{parts_partnumber}) {
|
|
| 588 |
$where .= <<SQL; |
|
| 589 |
AND EXISTS ( |
|
| 590 |
SELECT invoice.trans_id |
|
| 591 |
FROM invoice |
|
| 592 |
LEFT JOIN parts ON (invoice.parts_id = parts.id) |
|
| 593 |
WHERE (invoice.trans_id = a.id) |
|
| 594 |
AND (parts.partnumber ILIKE ?) |
|
| 595 |
LIMIT 1 |
|
| 596 |
) |
|
| 597 |
SQL |
|
| 598 |
push @values, like($form->{parts_partnumber});
|
|
| 599 |
} |
|
| 600 |
|
|
| 601 |
if ($form->{parts_description}) {
|
|
| 602 |
$where .= <<SQL; |
|
| 603 |
AND EXISTS ( |
|
| 604 |
SELECT invoice.trans_id |
|
| 605 |
FROM invoice |
|
| 606 |
WHERE (invoice.trans_id = a.id) |
|
| 607 |
AND (invoice.description ILIKE ?) |
|
| 608 |
LIMIT 1 |
|
| 609 |
) |
|
| 610 |
SQL |
|
| 611 |
push @values, like($form->{parts_description});
|
|
| 612 |
} |
|
| 613 |
|
|
| 587 | 614 |
my ($cvar_where, @cvar_values) = CVar->build_filter_query('module' => 'CT',
|
| 588 | 615 |
'trans_id_field' => 'c.id', |
| 589 | 616 |
'filter' => $form, |
| bin/mozilla/ar.pl | ||
|---|---|---|
| 943 | 943 |
push @columns, map { "cvar_$_->{name}" } @ct_includeable_custom_variables;
|
| 944 | 944 |
|
| 945 | 945 |
my @hidden_variables = map { "l_${_}" } @columns;
|
| 946 |
push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber cusordnumber transaction_description notes project_id transdatefrom transdateto duedatefrom duedateto employee_id salesman_id business_id); |
|
| 946 |
push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber cusordnumber transaction_description notes project_id transdatefrom transdateto duedatefrom duedateto |
|
| 947 |
employee_id salesman_id business_id parts_partnumber parts_description); |
|
| 947 | 948 |
push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables;
|
| 948 | 949 |
|
| 949 | 950 |
$href = build_std_url('action=ar_transactions', grep { $form->{$_} } @hidden_variables);
|
| ... | ... | |
| 1039 | 1040 |
if ($form->{transaction_description}) {
|
| 1040 | 1041 |
push @options, $locale->text('Transaction description') . " : $form->{transaction_description}";
|
| 1041 | 1042 |
} |
| 1043 |
if ($form->{parts_partnumber}) {
|
|
| 1044 |
push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}";
|
|
| 1045 |
} |
|
| 1046 |
if ($form->{parts_description}) {
|
|
| 1047 |
push @options, $locale->text('Part Description') . " : $form->{parts_description}";
|
|
| 1048 |
} |
|
| 1042 | 1049 |
if ($form->{transdatefrom}) {
|
| 1043 | 1050 |
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1);
|
| 1044 | 1051 |
} |
| templates/webpages/ar/search.html | ||
|---|---|---|
| 67 | 67 |
</tr> |
| 68 | 68 |
<tr> |
| 69 | 69 |
<th align=right nowrap>[% 'Transaction description' | $T8 %]</th> |
| 70 |
<td colspan=3><input name=transaction_description id=transaction_description size=40></td> |
|
| 70 |
<td><input name=transaction_description id=transaction_description size=20></td> |
|
| 71 |
<th align="right">[% 'Part Description' | $T8 %]</th> |
|
| 72 |
<td><input name="parts_description" size="20"></td> |
|
| 71 | 73 |
</tr> |
| 72 | 74 |
<tr> |
| 73 | 75 |
<th align=right nowrap>[% 'Notes' | $T8 %]</th> |
| 74 |
<td colspan=3><input name=notes id=notes size=40></td> |
|
| 76 |
<td><input name=notes id=notes size=20></td> |
|
| 77 |
<th align="right">[% 'Part Number' | $T8 %]</th> |
|
| 78 |
<td><input name="parts_partnumber" size="20"></td> |
|
| 75 | 79 |
</tr> |
| 76 | 80 |
<tr> |
| 77 | 81 |
<th align="right">[% 'Project Number' | $T8 %]</th> |
Auch abrufbar als: Unified diff
Verkaufsrechnungen: Suche nach Artikelnummer/-beschreibung in Positionen