From ff13e2921011bbaa241412f45f8c465fdf6aab62 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Mon, 14 Mar 2022 11:12:28 +0100 Subject: [PATCH] =?utf8?q?Kundenbericht:=20Suche=20nach=20Hauptansprechper?= =?utf8?q?son=20repariert,=20=E2=80=A6?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit … wenn auch Belege angezeigt werden sollen. Dazu muss das "SELECT" dafür in alle "UNIONS". --- SL/CT.pm | 3 +++ 1 file changed, 3 insertions(+) diff --git a/SL/CT.pm b/SL/CT.pm index 031ef112d..092da528f 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -289,6 +289,7 @@ sub search { qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | . qq| pt.description as payment | . $pg_select . + $main_cp_select . qq|, a.invnumber, a.ordnumber, a.quonumber, a.id AS invid, | . qq| '$module' AS module, 'invoice' AS formtype, | . qq| (a.amount = a.paid) AS closed | . @@ -308,6 +309,7 @@ sub search { qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | . qq| pt.description as payment | . $pg_select . + $main_cp_select . qq|, ' ' AS invnumber, o.ordnumber, o.quonumber, o.id AS invid, | . qq| 'oe' AS module, 'order' AS formtype, o.closed | . qq|FROM $cv ct | . @@ -326,6 +328,7 @@ sub search { qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | . qq| pt.description as payment | . $pg_select . + $main_cp_select . qq|, ' ' AS invnumber, o.ordnumber, o.quonumber, o.id AS invid, | . qq| 'oe' AS module, 'quotation' AS formtype, o.closed | . qq|FROM $cv ct | . -- 2.20.1