Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision be776964

Von Niclas Zimmermann vor mehr als 11 Jahren hinzugefügt

  • ID be776964b83340e69fa2f02eae59b703c0c95b88
  • Vorgänger 6d06b178
  • Nachfolger 014161b8

Nutzung der Tabelle currencies

Dieser Commmit passt den Code an, um die Tabelle currencies zu nutzen.

Unterschiede anzeigen:

SL/DO.pm
348 348
         shippingpoint = ?, shipvia = ?, notes = ?, intnotes = ?, closed = ?,
349 349
         delivered = ?, department_id = ?, language_id = ?, shipto_id = ?,
350 350
         globalproject_id = ?, employee_id = ?, salesman_id = ?, cp_id = ?, transaction_description = ?,
351
         is_sales = ?, taxzone_id = ?, taxincluded = ?, terms = ?, curr = ?
351
         is_sales = ?, taxzone_id = ?, taxincluded = ?, terms = ?, curr = (SELECT id FROM currencies WHERE curr = ?)
352 352
       WHERE id = ?|;
353 353

  
354 354
  @values = ($form->{donumber}, $form->{ordnumber},
......
616 616
         d.description AS department, dord.language_id,
617 617
         dord.shipto_id,
618 618
         dord.globalproject_id, dord.delivered, dord.transaction_description,
619
         dord.taxzone_id, dord.taxincluded, dord.terms, dord.curr AS currency
619
         dord.taxzone_id, dord.taxincluded, dord.terms, (SELECT cu.curr FROM currencies cu WHERE cu.id=dord.curr) AS currency
620 620
       FROM delivery_orders dord
621 621
       JOIN ${vc} cv ON (dord.${vc}_id = cv.id)
622 622
       LEFT JOIN employee e ON (dord.employee_id = e.id)
......
638 638
  }
639 639
  $sth->finish();
640 640

  
641
  # remove any trailing whitespace
642
  $form->{currency} =~ s/\s*$//;
643

  
644 641
  $form->{donumber_array} =~ s/\s*$//g;
645 642

  
646 643
  $form->{saved_donumber} = $form->{donumber};

Auch abrufbar als: Unified diff