projekt kivitendo

    qq|  o.transaction_description, | .

    qq|  o.marge_total, o.marge_percent, | .

    qq|  o.itime::DATE AS insertdate, | .

    qq|  ex.$rate AS exchangerate, | .

    qq|  pt.description AS payment_terms, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|LEFT JOIN project pr ON (o.globalproject_id = pr.id) | .

    qq|LEFT JOIN payment_terms pt ON (pt.id = o.payment_id)| .

    qq|LEFT JOIN tax_zones tz ON (o.taxzone_id = tz.id) | .

    qq|$periodic_invoices_joins | .

    qq|WHERE (o.quotation = ?) |;

  push(@values, $quotation);

    "insertdate"              => "o.itime",

    "taxzone"                 => "tz.description",

    "payment_terms"           => "pt.description",

  );

  if ($form->{sort} && grep($form->{sort}, keys(%allowed_sort_columns))) {

    $sortorder = $allowed_sort_columns{$form->{sort}} . " ${sortdir}"  . ", o.itime ${sortdir}";