Revision 7349649b
Von Kivitendo Admin vor mehr als 8 Jahren hinzugefügt
| SL/CT.pm | ||
|---|---|---|
| 251 | 251 |
} |
| 252 | 252 |
|
| 253 | 253 |
my $pg_select = $form->{l_pricegroup} ? qq|, pg.pricegroup as pricegroup | : '';
|
| 254 |
my $pg_join = $form->{l_pricegroup} ? qq|LEFT JOIN pricegroup pg ON (ct.klass = pg.id) | : '';
|
|
| 254 |
my $pg_join = $form->{l_pricegroup} ? qq|LEFT JOIN pricegroup pg ON (ct.pricegroup_id = pg.id) | : '';
|
|
| 255 | 255 |
my $query = |
| 256 | 256 |
qq|SELECT ct.*, ct.itime::DATE AS insertdate, b.description AS business, e.name as salesman, | . |
| 257 | 257 |
qq| pt.description as payment | . |
Auch abrufbar als: Unified diff
Kunde: Datenbanktabelle "klass" nach "pricegroup_id" migriert
und einen Fremdschlüssel gesetzt.