projekt kivitendo

    $query .= " AND o.employee_id = ?";

    push @values, conv_i($form->{employee_id});

  }

  if ($form->{salesman_id}) {

    $query .= " AND o.salesman_id = ?";

    push @values, conv_i($form->{salesman_id});

         JOIN ${vc} cv ON (o.${vc}_id = cv.id)

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

         LEFT JOIN department d ON (o.department_id = d.id) | .

         : "WHERE o.id IN (" . join(', ', map("? ", @ids)) . ")"

        );

    @values = $form->{id} ? ($form->{id}) : @ids;

    # stuff different from the whole will not be overwritten, but saved with a suffix.

    $query =

      qq|SELECT o.id AS orderitems_id,

           c2.accno AS income_accno,    c2.new_chart_id AS income_new_chart,    date($transdate) - c2.valid_from as income_valid,

           c3.accno AS expense_accno,   c3.new_chart_id AS expense_new_chart,   date($transdate) - c3.valid_from as expense_valid,

           oe.ordnumber AS ordnumber_oe, oe.transdate AS transdate_oe, oe.cusordnumber AS cusordnumber_oe,

            push(@{ $form->{description} }, $sameitem);

          }

          map({ push(@{ $form->{$_} }, "") } grep({ $_ ne "description" } @arrays));

        }

        $sth->finish;