projekt kivitendo

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

    qq|FROM oe o | .

    qq|JOIN $vc ct ON (o.${vc}_id = ct.id) | .

    qq|LEFT JOIN employee e ON (o.employee_id = e.id) | .

    qq|LEFT JOIN employee s ON (o.salesman_id = s.id) | .

    qq|LEFT JOIN exchangerate ex ON (ex.currency_id = o.currency_id | .

    push(@values, '%' . $form->{$vc} . '%');

  }

  if (!$main::auth->assert('sales_all_edit', 1)) {

    $query .= " AND o.employee_id = (select id from employee where login= ?)";

    push @values, $form->{login};