projekt kivitendo

  my $query =

    qq|SELECT a.id, a.invnumber, a.transdate, a.duedate, a.amount, a.paid, | .

    qq|  a.ordnumber, v.name, a.invoice, a.netamount, a.datepaid, a.notes, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|  e.name AS employee | .

    qq|FROM ap a | .

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

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

  my @values;

  if ($form->{vendor_id}) {

  }

  if ($where) {

    $query .= $where;

  }