Revision e8966d20
Von Bernd Bleßmann vor etwa 10 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
|
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,
|
||
|
dord.transaction_description, dord.itime::DATE AS insertdate,
|
||
|
pr.projectnumber AS globalprojectnumber,
|
||
|
dep.description AS department,
|
||
|
e.name AS employee,
|
||
| ... | ... | |
|
push @values, conv_date($form->{reqdateto});
|
||
|
}
|
||
|
|
||
|
if($form->{insertdatefrom}) {
|
||
|
push @where, qq|dord.itime::DATE >= ?|;
|
||
|
push@values, conv_date($form->{insertdatefrom});
|
||
|
}
|
||
|
|
||
|
if($form->{insertdateto}) {
|
||
|
push @where, qq|dord.itime::DATE <= ?|;
|
||
|
push @values, conv_date($form->{insertdateto});
|
||
|
}
|
||
|
|
||
|
if (@where) {
|
||
|
$query .= " WHERE " . join(" AND ", map { "($_)" } @where);
|
||
|
}
|
||
| ... | ... | |
|
"shipvia" => "dord.shipvia",
|
||
|
"transaction_description" => "dord.transaction_description",
|
||
|
"department" => "lower(dep.description)",
|
||
|
"insertdate" => "dord.itime",
|
||
|
);
|
||
|
|
||
|
my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
|
||
| ... | ... | |
|
dord.shipto_id,
|
||
|
dord.globalproject_id, dord.delivered, dord.transaction_description,
|
||
|
dord.taxzone_id, dord.taxincluded, dord.terms, (SELECT cu.name FROM currencies cu WHERE cu.id=dord.currency_id) AS currency,
|
||
|
dord.delivery_term_id
|
||
|
dord.delivery_term_id, dord.itime::DATE AS insertdate
|
||
|
FROM delivery_orders dord
|
||
|
JOIN ${vc} cv ON (dord.${vc}_id = cv.id)
|
||
|
LEFT JOIN employee e ON (dord.employee_id = e.id)
|
||
Auch abrufbar als: Unified diff
Erfassungsdatum bei Verkaufs-Lieferscheinen.
In der Maske anzeigen; im Bericht anzeigen und danach filtern.
Übernahme aus Kundenprojekt.