From: Bernd Bleßmann <bernd@kivitendo-premium.de>
Date: Mon, 14 Mar 2022 10:12:28 +0000 (+0100)
Subject: Kundenbericht: Suche nach Hauptansprechperson repariert, …
X-Git-Tag: kivitendo-mebil_0.1-0~10^2~2^2~119
X-Git-Url: http://wagnertech.de/git?p=kivitendo-erp.git;a=commitdiff_plain;h=ff13e2921011bbaa241412f45f8c465fdf6aab62

Kundenbericht: Suche nach Hauptansprechperson repariert, …

… wenn auch Belege angezeigt werden sollen.
Dazu muss das "SELECT" dafür in alle "UNIONS".
---

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 | .