From 88e16972a3c5a76af719c3eff31b6d8163e2e8b3 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Mon, 30 Mar 2009 15:53:52 +0000 Subject: [PATCH] Kunden->Lieferanten Dialog mit Links versehen. --- SL/CT.pm | 6 ++++-- templates/webpages/ct/get_delivery_de.html | 14 +++++++------- templates/webpages/ct/get_delivery_master.html | 14 +++++++------- 3 files changed, 18 insertions(+), 16 deletions(-) diff --git a/SL/CT.pm b/SL/CT.pm index 7e81d66c4..3df827a6d 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -923,8 +923,9 @@ sub get_delivery { } my $query = qq|SELECT s.shiptoname, i.qty, | . - qq| ${arap}.transdate, ${arap}.invnumber, ${arap}.ordnumber, | . - qq| i.description, i.unit, i.sellprice | . + qq| ${arap}.id, ${arap}.transdate, ${arap}.invnumber, ${arap}.ordnumber, | . + qq| i.description, i.unit, i.sellprice, | . + qq| oe.id AS oe_id | . qq|FROM $arap | . qq|LEFT JOIN shipto s ON | . ($arap eq "ar" @@ -932,6 +933,7 @@ sub get_delivery { : qq|(ap.id = s.trans_id) |) . qq|LEFT JOIN invoice i ON (${arap}.id = i.trans_id) | . qq|LEFT join parts p ON (p.id = i.parts_id) | . + qq|LEFT JOIN oe ON (oe.ordnumber = ${arap}.ordnumber AND NOT ${arap}.ordnumber = '') | . $where . qq|ORDER BY ${arap}.transdate DESC LIMIT 15|; diff --git a/templates/webpages/ct/get_delivery_de.html b/templates/webpages/ct/get_delivery_de.html index 17a75880a..b6daa6717 100644 --- a/templates/webpages/ct/get_delivery_de.html +++ b/templates/webpages/ct/get_delivery_de.html @@ -16,13 +16,13 @@ [%- FOREACH row = DELIVERY %] [% HTML.escape(row.shiptoname) UNLESS loop.prev.shiptoname == row.shiptoname %]  - [% HTML.escape(row.invnumber) %]  - [% HTML.escape(row.ordnumber) %]  - [% HTML.escape(row.transdate) %]  - [% HTML.escape(row.description) %]  - [% HTML.escape(row.qty) %]  - [% HTML.escape(row.unit) %]  - [% LxERP.format_amount(row.sellprice, 2) %]  + [% IF row.id %][% END %][% HTML.escape(row.invnumber) || ' ' %][% IF row.id %][% END %] + [% IF row.oe_id %][% END %][% HTML.escape(row.ordnumber) || ' ' %][% IF row.oe_id %][% END %] + [% HTML.escape(row.transdate) || ' ' %] + [% HTML.escape(row.description) || ' ' %] + [% HTML.escape(row.qty) || ' ' %] + [% HTML.escape(row.unit) || ' ' %] + [% LxERP.format_amount(row.sellprice, 2) || ' ' %] [%- END %] diff --git a/templates/webpages/ct/get_delivery_master.html b/templates/webpages/ct/get_delivery_master.html index eac63cb76..a8d53a780 100644 --- a/templates/webpages/ct/get_delivery_master.html +++ b/templates/webpages/ct/get_delivery_master.html @@ -16,13 +16,13 @@ [%- FOREACH row = DELIVERY %] [% HTML.escape(row.shiptoname) UNLESS loop.prev.shiptoname == row.shiptoname %]  - [% HTML.escape(row.invnumber) %]  - [% HTML.escape(row.ordnumber) %]  - [% HTML.escape(row.transdate) %]  - [% HTML.escape(row.description) %]  - [% HTML.escape(row.qty) %]  - [% HTML.escape(row.unit) %]  - [% LxERP.format_amount(row.sellprice, 2) %]  + [% IF row.id %][% END %][% HTML.escape(row.invnumber) || ' ' %][% IF row.id %][% END %] + [% IF row.oe_id %][% END %][% HTML.escape(row.ordnumber) || ' ' %][% IF row.oe_id %][% END %] + [% HTML.escape(row.transdate) || ' ' %] + [% HTML.escape(row.description) || ' ' %] + [% HTML.escape(row.qty) || ' ' %] + [% HTML.escape(row.unit) || ' ' %] + [% LxERP.format_amount(row.sellprice, 2) || ' ' %] [%- END %] -- 2.20.1