Revision 25bc91e2
Von Werner Hahn vor 6 Monaten hinzugefügt
| SL/AP.pm | ||
|---|---|---|
|
push @values, like($form->{parts_description});
|
||
|
}
|
||
|
|
||
|
if ($form->{parts_serialnumber}) {
|
||
|
$where .= <<SQL;
|
||
|
AND EXISTS (
|
||
|
SELECT invoice.trans_id
|
||
|
FROM invoice
|
||
|
WHERE (invoice.trans_id = a.id)
|
||
|
AND (invoice.serialnumber ILIKE ?)
|
||
|
LIMIT 1
|
||
|
)
|
||
|
SQL
|
||
|
push @values, like($form->{parts_serialnumber});
|
||
|
}
|
||
|
|
||
|
if ($where) {
|
||
|
$where =~ s{\s*AND\s*}{ WHERE };
|
||
|
$query .= $where;
|
||
| SL/AR.pm | ||
|---|---|---|
|
push @values, like($form->{parts_description});
|
||
|
}
|
||
|
|
||
|
if ($form->{parts_serialnumber}) {
|
||
|
$where .= <<SQL;
|
||
|
AND EXISTS (
|
||
|
SELECT invoice.trans_id
|
||
|
FROM invoice
|
||
|
WHERE (invoice.trans_id = a.id)
|
||
|
AND (invoice.serialnumber ILIKE ?)
|
||
|
LIMIT 1
|
||
|
)
|
||
|
SQL
|
||
|
push @values, like($form->{parts_serialnumber});
|
||
|
}
|
||
|
|
||
|
if ($form->{show_not_mailed}) {
|
||
|
$where .= <<SQL;
|
||
|
AND NOT EXISTS (
|
||
| bin/mozilla/ap.pl | ||
|---|---|---|
|
push @hidden_variables, "l_subtotal", qw(open closed vendor invnumber ordnumber transaction_description notes intnotes project_id
|
||
|
transdatefrom transdateto duedatefrom duedateto datepaidfrom datepaidto
|
||
|
parts_partnumber parts_description department_id taxzone_id payment_id
|
||
|
fulltext insertdatefrom insertdateto);
|
||
|
fulltext insertdatefrom insertdateto
|
||
|
parts_serialnumber);
|
||
|
|
||
|
my $href = build_std_url('action=ap_transactions', grep { $form->{$_} } @hidden_variables);
|
||
|
|
||
| ... | ... | |
|
push @options, $locale->text('Part Description') . " : $form->{parts_description}" if $form->{parts_description};
|
||
|
push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}" if $form->{parts_partnumber};
|
||
|
push @options, $locale->text('Full Text') . " : $form->{fulltext}" if ($form->{fulltext});
|
||
|
push @options, $locale->text('Serial Number') . " : $form->{parts_serialnumber}" if ($form->{parts_serialnumber});
|
||
|
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1) if ($form->{transdatefrom});
|
||
|
push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{transdateto}, 1) if ($form->{transdateto});
|
||
|
push @options, $locale->text('Due Date') . " " . $locale->text('from') . " " . $locale->date(\%myconfig, $form->{duedatefrom}, 1) if ($form->{duedatefrom});
|
||
| bin/mozilla/ar.pl | ||
|---|---|---|
|
business_id parts_partnumber parts_description department_id
|
||
|
show_marked_as_closed show_not_mailed shippingpoint shipvia taxzone_id
|
||
|
payment_id shiptoname shiptodepartment_1 shiptodepartment_2 shiptostreet
|
||
|
shiptozipcode shiptocity shiptocountry fulltext
|
||
|
shiptozipcode shiptocity shiptocountry fulltext parts_serialnumber
|
||
|
);
|
||
|
push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables;
|
||
|
|
||
| ... | ... | |
|
if ($form->{fulltext}) {
|
||
|
push @options, $locale->text('Full Text') . " : $form->{fulltext}";
|
||
|
}
|
||
|
if ($form->{parts_serialnumber}) {
|
||
|
push @options, $locale->text('Serial Number') . " : $form->{parts_serialnumber}";
|
||
|
}
|
||
|
|
||
|
$form->{ALL_PRINTERS} = SL::DB::Manager::Printer->get_all_sorted;
|
||
|
|
||
| templates/design40_webpages/ap/search.html | ||
|---|---|---|
|
<th>[% 'Part Number' | $T8 %]</th>
|
||
|
<td>[% L.input_tag("parts_partnumber", "", class="wi-normal") %]</td>
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<th>[% 'Serial Number' | $T8 %]</th>
|
||
|
<td>[% L.input_tag("parts_serialnumber", "") %]</td>
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<th>[% 'Project Number' | $T8 %]</th>
|
||
|
<td>[% P.project.picker("project_id", project_id, active="both", valid="both", class="wi-normal") %]</td>
|
||
| templates/design40_webpages/ar/search.html | ||
|---|---|---|
|
<th>[% 'Part Number' | $T8 %]</th>
|
||
|
<td>[% L.input_tag("parts_partnumber", "") %]</td>
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<th>[% 'Serial Number' | $T8 %]</th>
|
||
|
<td>[% L.input_tag("parts_serialnumber", "") %]</td>
|
||
|
</tr>
|
||
|
</tbody>
|
||
|
</table>
|
||
|
|
||
| templates/webpages/ap/search.html | ||
|---|---|---|
|
<tr>
|
||
|
<th align="right">[% 'Full Text' | $T8 %]</th>
|
||
|
<td>[% L.input_tag('fulltext', '', style=style) %]</td>
|
||
|
<th align="right">[% 'Serial Number' | $T8 %]</th>
|
||
|
<td>[% L.input_tag("parts_serialnumber", "", style=style) %]</td>
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<th align="right">[% 'Project Number' | $T8 %]</th>
|
||
| templates/webpages/ar/search.html | ||
|---|---|---|
|
<tr>
|
||
|
<th align="right">[% 'Full Text' | $T8 %]</th>
|
||
|
<td>[% L.input_tag('fulltext', '', style=style) %]</td>
|
||
|
<th align="right">[% 'Serial Number' | $T8 %]</th>
|
||
|
<td>[% L.input_tag("parts_serialnumber", "", style=style) %]</td>
|
||
|
</tr>
|
||
|
<tr>
|
||
|
<th align=right nowrap>[% 'Shipping Point' | $T8 %]</th>
|
||
Auch abrufbar als: Unified diff
EK/VK Rechnungen Kred. Deb. Suche Seriannummer aus Position als Kriterium