Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision ff13e292

Von Bernd Bleßmann vor fast 3 Jahren hinzugefügt

  • ID ff13e2921011bbaa241412f45f8c465fdf6aab62
  • Vorgänger 31bb90f4
  • Nachfolger 33ccfd3e

Kundenbericht: Suche nach Hauptansprechperson repariert, …

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

Unterschiede anzeigen:

SL/CT.pm
289 289
        qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | .
290 290
        qq|  pt.description as payment | .
291 291
        $pg_select .
292
        $main_cp_select .
292 293
        qq|, a.invnumber, a.ordnumber, a.quonumber, a.id AS invid, | .
293 294
        qq|  '$module' AS module, 'invoice' AS formtype, | .
294 295
        qq|  (a.amount = a.paid) AS closed | .
......
308 309
        qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | .
309 310
        qq|  pt.description as payment | .
310 311
        $pg_select .
312
        $main_cp_select .
311 313
        qq|, ' ' AS invnumber, o.ordnumber, o.quonumber, o.id AS invid, | .
312 314
        qq|  'oe' AS module, 'order' AS formtype, o.closed | .
313 315
        qq|FROM $cv ct | .
......
326 328
        qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | .
327 329
        qq|  pt.description as payment | .
328 330
        $pg_select .
331
        $main_cp_select .
329 332
        qq|, ' ' AS invnumber, o.ordnumber, o.quonumber, o.id AS invid, | .
330 333
        qq|  'oe' AS module, 'quotation' AS formtype, o.closed | .
331 334
        qq|FROM $cv ct | .

Auch abrufbar als: Unified diff