Revision ed14204d
Von Moritz Bunkus vor etwa 12 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 66 | 66 |
dord.closed, dord.delivered, dord.shippingpoint, dord.shipvia, |
| 67 | 67 |
dord.transaction_description, |
| 68 | 68 |
pr.projectnumber AS globalprojectnumber, |
| 69 |
dep.description AS department, |
|
| 69 | 70 |
e.name AS employee, |
| 70 | 71 |
sm.name AS salesman |
| 71 | 72 |
FROM delivery_orders dord |
| 72 | 73 |
LEFT JOIN $vc ct ON (dord.${vc}_id = ct.id)
|
| 73 | 74 |
LEFT JOIN employee e ON (dord.employee_id = e.id) |
| 74 | 75 |
LEFT JOIN employee sm ON (dord.salesman_id = sm.id) |
| 75 |
LEFT JOIN project pr ON (dord.globalproject_id = pr.id)|; |
|
| 76 |
LEFT JOIN project pr ON (dord.globalproject_id = pr.id) |
|
| 77 |
LEFT JOIN department dep ON (dord.department_id = dep.id) |
|
| 78 |
|; |
|
| 76 | 79 |
|
| 77 | 80 |
push @where, ($form->{type} eq 'sales_delivery_order' ? '' : 'NOT ') . qq|COALESCE(dord.is_sales, FALSE)|;
|
| 78 | 81 |
|
| ... | ... | |
| 147 | 150 |
"employee" => "e.name", |
| 148 | 151 |
"salesman" => "sm.name", |
| 149 | 152 |
"shipvia" => "dord.shipvia", |
| 150 |
"transaction_description" => "dord.transaction_description" |
|
| 153 |
"transaction_description" => "dord.transaction_description", |
|
| 154 |
"department" => "lower(dep.description)", |
|
| 151 | 155 |
); |
| 152 | 156 |
|
| 153 | 157 |
my $sortdir = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';
|
Auch abrufbar als: Unified diff
Suche nach und Anzeige von Abteilungen bei Lieferscheinsuche
Implementiert #1952.