Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 7eae8fac

Von Moritz Bunkus vor mehr als 17 Jahren hinzugefügt

  • ID 7eae8facf962ddf359ab295b0e402c142be31548
  • Vorgänger 468b6bcf
  • Nachfolger e9e216f5

Kosmetik.

Unterschiede anzeigen:

SL/IS.pm
1370 1370

  
1371 1371
  $query =
1372 1372
    qq|SELECT
1373
         (SELECT c.accno FROM chart c
1374
          WHERE d.inventory_accno_id = c.id) AS inventory_accno,
1375
         (SELECT c.accno FROM chart c
1376
          WHERE d.income_accno_id = c.id) AS income_accno,
1377
         (SELECT c.accno FROM chart c
1378
          WHERE d.expense_accno_id = c.id) AS expense_accno,
1379
         (SELECT c.accno FROM chart c
1380
          WHERE d.fxgain_accno_id = c.id) AS fxgain_accno,
1381
         (SELECT c.accno FROM chart c
1382
          WHERE d.fxloss_accno_id = c.id) AS fxloss_accno,
1373
         (SELECT c.accno FROM chart c WHERE d.inventory_accno_id = c.id) AS inventory_accno,
1374
         (SELECT c.accno FROM chart c WHERE d.income_accno_id = c.id)    AS income_accno,
1375
         (SELECT c.accno FROM chart c WHERE d.expense_accno_id = c.id)   AS expense_accno,
1376
         (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id)    AS fxgain_accno,
1377
         (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id)    AS fxloss_accno,
1383 1378
         d.curr AS currencies
1384 1379
         ${query_transdate}
1385 1380
       FROM defaults d|;

Auch abrufbar als: Unified diff