Revision 88e16972
Von Sven Schöling vor mehr als 15 Jahren hinzugefügt
| SL/CT.pm | ||
|---|---|---|
| 923 | 923 |
} |
| 924 | 924 |
my $query = |
| 925 | 925 |
qq|SELECT s.shiptoname, i.qty, | . |
| 926 |
qq| ${arap}.transdate, ${arap}.invnumber, ${arap}.ordnumber, | .
|
|
| 927 |
qq| i.description, i.unit, i.sellprice | . |
|
| 926 |
qq| ${arap}.id, ${arap}.transdate, ${arap}.invnumber, ${arap}.ordnumber, | .
|
|
| 927 |
qq| i.description, i.unit, i.sellprice, | . |
|
| 928 |
qq| oe.id AS oe_id | . |
|
| 928 | 929 |
qq|FROM $arap | . |
| 929 | 930 |
qq|LEFT JOIN shipto s ON | . |
| 930 | 931 |
($arap eq "ar" |
| ... | ... | |
| 932 | 933 |
: qq|(ap.id = s.trans_id) |) . |
| 933 | 934 |
qq|LEFT JOIN invoice i ON (${arap}.id = i.trans_id) | .
|
| 934 | 935 |
qq|LEFT join parts p ON (p.id = i.parts_id) | . |
| 936 |
qq|LEFT JOIN oe ON (oe.ordnumber = ${arap}.ordnumber AND NOT ${arap}.ordnumber = '') | .
|
|
| 935 | 937 |
$where . |
| 936 | 938 |
qq|ORDER BY ${arap}.transdate DESC LIMIT 15|;
|
| 937 | 939 |
|
| templates/webpages/ct/get_delivery_de.html | ||
|---|---|---|
| 16 | 16 |
[%- FOREACH row = DELIVERY %] |
| 17 | 17 |
<tr class="listrow[% loop.count % 2 %]"> |
| 18 | 18 |
<td>[% HTML.escape(row.shiptoname) UNLESS loop.prev.shiptoname == row.shiptoname %] </td> |
| 19 |
<td>[% HTML.escape(row.invnumber) %] </td>
|
|
| 20 |
<td>[% HTML.escape(row.ordnumber) %] </td>
|
|
| 21 |
<td>[% HTML.escape(row.transdate) %] </td>
|
|
| 22 |
<td>[% HTML.escape(row.description) %] </td>
|
|
| 23 |
<td>[% HTML.escape(row.qty) %] </td>
|
|
| 24 |
<td>[% HTML.escape(row.unit) %] </td>
|
|
| 25 |
<td>[% LxERP.format_amount(row.sellprice, 2) %] </td>
|
|
| 19 |
<td>[% IF row.id %]<a href='is.pl?action=edit&id=[% HTML.escape(row.id) %]'>[% END %][% HTML.escape(row.invnumber) || ' ' %][% IF row.id %]</a>[% END %]</td>
|
|
| 20 |
<td>[% IF row.oe_id %]<a href='oe.pl?action=edit&type=sales_order&vc=customer&id=[% HTML.escape(row.oe_id) %]'>[% END %][% HTML.escape(row.ordnumber) || ' ' %][% IF row.oe_id %]</a>[% END %]</td>
|
|
| 21 |
<td>[% HTML.escape(row.transdate) || ' ' %]</td>
|
|
| 22 |
<td>[% HTML.escape(row.description) || ' ' %]</td>
|
|
| 23 |
<td>[% HTML.escape(row.qty) || ' ' %]</td>
|
|
| 24 |
<td>[% HTML.escape(row.unit) || ' ' %]</td>
|
|
| 25 |
<td>[% LxERP.format_amount(row.sellprice, 2) || ' ' %]</td>
|
|
| 26 | 26 |
</tr> |
| 27 | 27 |
[%- END %] |
| 28 | 28 |
|
| templates/webpages/ct/get_delivery_master.html | ||
|---|---|---|
| 16 | 16 |
[%- FOREACH row = DELIVERY %] |
| 17 | 17 |
<tr class="listrow[% loop.count % 2 %]"> |
| 18 | 18 |
<td>[% HTML.escape(row.shiptoname) UNLESS loop.prev.shiptoname == row.shiptoname %] </td> |
| 19 |
<td>[% HTML.escape(row.invnumber) %] </td>
|
|
| 20 |
<td>[% HTML.escape(row.ordnumber) %] </td>
|
|
| 21 |
<td>[% HTML.escape(row.transdate) %] </td>
|
|
| 22 |
<td>[% HTML.escape(row.description) %] </td>
|
|
| 23 |
<td>[% HTML.escape(row.qty) %] </td>
|
|
| 24 |
<td>[% HTML.escape(row.unit) %] </td>
|
|
| 25 |
<td>[% LxERP.format_amount(row.sellprice, 2) %] </td>
|
|
| 19 |
<td>[% IF row.id %]<a href='is.pl?action=edit&id=[% HTML.escape(row.id) %]'>[% END %][% HTML.escape(row.invnumber) || ' ' %][% IF row.id %]</a>[% END %]</td>
|
|
| 20 |
<td>[% IF row.oe_id %]<a href='oe.pl?action=edit&type=sales_order&vc=customer&id=[% HTML.escape(row.oe_id) %]'>[% END %][% HTML.escape(row.ordnumber) || ' ' %][% IF row.oe_id %]</a>[% END %]</td>
|
|
| 21 |
<td>[% HTML.escape(row.transdate) || ' ' %]</td>
|
|
| 22 |
<td>[% HTML.escape(row.description) || ' ' %]</td>
|
|
| 23 |
<td>[% HTML.escape(row.qty) || ' ' %]</td>
|
|
| 24 |
<td>[% HTML.escape(row.unit) || ' ' %]</td>
|
|
| 25 |
<td>[% LxERP.format_amount(row.sellprice, 2) || ' ' %]</td>
|
|
| 26 | 26 |
</tr> |
| 27 | 27 |
[%- END %] |
| 28 | 28 |
|
Auch abrufbar als: Unified diff
Kunden->Lieferanten Dialog mit Links versehen.