Revision 253a9323
Von Bernd Bleßmann vor fast 12 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
|
my $vc = $form->{vc} eq "customer" ? "customer" : "vendor";
|
||
|
|
||
|
my $query =
|
||
|
qq|SELECT dord.id, dord.donumber, dord.ordnumber, dord.transdate,
|
||
|
qq|SELECT dord.id, dord.donumber, dord.ordnumber,
|
||
|
dord.transdate, dord.reqdate,
|
||
|
ct.${vc}number, ct.name, dord.${vc}_id, dord.globalproject_id,
|
||
|
dord.closed, dord.delivered, dord.shippingpoint, dord.shipvia,
|
||
|
dord.transaction_description,
|
||
| ... | ... | |
|
|
||
|
my %allowed_sort_columns = (
|
||
|
"transdate" => "dord.transdate",
|
||
|
"reqdate" => "dord.reqdate",
|
||
|
"id" => "dord.id",
|
||
|
"donumber" => "dord.donumber",
|
||
|
"ordnumber" => "dord.ordnumber",
|
||
| bin/mozilla/do.pl | ||
|---|---|---|
|
$form->{rowcount} = scalar @{ $form->{DO} };
|
||
|
|
||
|
my @columns = qw(
|
||
|
ids transdate
|
||
|
ids transdate reqdate
|
||
|
id donumber
|
||
|
ordnumber customernumber
|
||
|
name employee salesman
|
||
| ... | ... | |
|
my %column_defs = (
|
||
|
'ids' => { 'text' => '', },
|
||
|
'transdate' => { 'text' => $locale->text('Date'), },
|
||
|
'reqdate' => { 'text' => $locale->text('Reqdate'), },
|
||
|
'id' => { 'text' => $locale->text('ID'), },
|
||
|
'donumber' => { 'text' => $locale->text('Delivery Order'), },
|
||
|
'ordnumber' => { 'text' => $locale->text('Order'), },
|
||
| ... | ... | |
|
'department' => { 'text' => $locale->text('Department'), },
|
||
|
);
|
||
|
|
||
|
foreach my $name (qw(id transdate donumber ordnumber name employee salesman shipvia transaction_description department)) {
|
||
|
foreach my $name (qw(id transdate reqdate donumber ordnumber name employee salesman shipvia transaction_description department)) {
|
||
|
my $sortdir = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};
|
||
|
$column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";
|
||
|
}
|
||
| templates/webpages/do/search.html | ||
|---|---|---|
|
<input name="l_transdate" id="l_transdate" class="checkbox" type="checkbox" value="Y" checked>
|
||
|
<label for="l_transdate">[% 'Date' | $T8 %]</label>
|
||
|
</td>
|
||
|
<td>
|
||
|
<input name="l_reqdate" id="l_reqdate" class="checkbox" type="checkbox" value="Y" checked>
|
||
|
<label for="l_reqdate">[% 'Reqdate' | $T8 %]</label>
|
||
|
</td>
|
||
|
</tr>
|
||
|
|
||
|
<tr>
|
||
|
<td>
|
||
|
<input name="l_name" id="l_name" class="checkbox" type="checkbox" value="Y" checked>
|
||
|
<label for="l_name">[% IF is_customer %][% 'Customer' | $T8 %][% ELSE %][% 'Vendor' | $T8 %][% END %]</label>
|
||
Auch abrufbar als: Unified diff
Verkauf->Berichte->Lieferscheine: Lieferdatum mit anzeigen lassen.