projekt kivitendo

          ) AS charts } .

    qq|FROM ar a | .

    qq|JOIN customer c ON (a.customer_id = c.id) | .

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

    qq|LEFT JOIN employee e2 ON (a.salesman_id = e2.id) | .

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

    $where .= " AND c.name ILIKE ?";

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

  }

  if ($form->{business_id}) {

    my $business_id = $form->{business_id};

    $where .= " AND c.business_id = ?";