Revision ff13e292
Von Bernd Bleßmann vor fast 3 Jahren hinzugefügt
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
Kundenbericht: Suche nach Hauptansprechperson repariert, …
… wenn auch Belege angezeigt werden sollen.
Dazu muss das "SELECT" dafür in alle "UNIONS".