projekt kivitendo

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

    qq|  o.exchangerate, | .

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

    qq|  department.description as department, | .

    qq|  ex.$rate AS daily_exchangerate, | .

    qq|  pt.description AS payment_terms, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|  e.name AS employee, s.name AS salesman, | .

    qq|  ct.${vc}number AS vcnumber, ct.country, ct.ustid, ct.business_id,  | .

    $periodic_invoices_columns .

    $phone_notes_columns .

    qq|  , o.order_probability, o.expected_billing_date, (o.netamount * o.order_probability / 100) AS expected_netamount | .

    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|LEFT JOIN department   ON (o.department_id = department.id) | .

    qq|$periodic_invoices_joins | .

    $phone_notes_join .

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

    push(@values, like($form->{intnotes}));

  }

  if ($form->{phone_notes}) {

    $query .= qq| AND (phone_notes.subject ILIKE ? OR regexp_replace(phone_notes.body, '<[^>]*>', '', 'g') ILIKE ?)|;

    push(@values, like($form->{phone_notes}), like($form->{phone_notes}));

    "payment_terms"           => "pt.description",

    "department"              => "department.description",

    "intnotes"                => "o.intnotes",

  );

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

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