Revision e8966d20
Von Bernd Bleßmann vor mehr als 9 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 69 | 69 |
dord.transdate, dord.reqdate, |
| 70 | 70 |
ct.${vc}number, ct.name, dord.${vc}_id, dord.globalproject_id,
|
| 71 | 71 |
dord.closed, dord.delivered, dord.shippingpoint, dord.shipvia, |
| 72 |
dord.transaction_description, |
|
| 72 |
dord.transaction_description, dord.itime::DATE AS insertdate,
|
|
| 73 | 73 |
pr.projectnumber AS globalprojectnumber, |
| 74 | 74 |
dep.description AS department, |
| 75 | 75 |
e.name AS employee, |
| ... | ... | |
| 163 | 163 |
push @values, conv_date($form->{reqdateto});
|
| 164 | 164 |
} |
| 165 | 165 |
|
| 166 |
if($form->{insertdatefrom}) {
|
|
| 167 |
push @where, qq|dord.itime::DATE >= ?|; |
|
| 168 |
push@values, conv_date($form->{insertdatefrom});
|
|
| 169 |
} |
|
| 170 |
|
|
| 171 |
if($form->{insertdateto}) {
|
|
| 172 |
push @where, qq|dord.itime::DATE <= ?|; |
|
| 173 |
push @values, conv_date($form->{insertdateto});
|
|
| 174 |
} |
|
| 175 |
|
|
| 166 | 176 |
if (@where) {
|
| 167 | 177 |
$query .= " WHERE " . join(" AND ", map { "($_)" } @where);
|
| 168 | 178 |
} |
| ... | ... | |
| 179 | 189 |
"shipvia" => "dord.shipvia", |
| 180 | 190 |
"transaction_description" => "dord.transaction_description", |
| 181 | 191 |
"department" => "lower(dep.description)", |
| 192 |
"insertdate" => "dord.itime", |
|
| 182 | 193 |
); |
| 183 | 194 |
|
| 184 | 195 |
my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
|
| ... | ... | |
| 673 | 684 |
dord.shipto_id, |
| 674 | 685 |
dord.globalproject_id, dord.delivered, dord.transaction_description, |
| 675 | 686 |
dord.taxzone_id, dord.taxincluded, dord.terms, (SELECT cu.name FROM currencies cu WHERE cu.id=dord.currency_id) AS currency, |
| 676 |
dord.delivery_term_id |
|
| 687 |
dord.delivery_term_id, dord.itime::DATE AS insertdate
|
|
| 677 | 688 |
FROM delivery_orders dord |
| 678 | 689 |
JOIN ${vc} cv ON (dord.${vc}_id = cv.id)
|
| 679 | 690 |
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.