projekt kivitendo

  my $query;

  my $ordnumber = 'ordnumber';

  my $quotation = '0';

  my @values;

  my $where;

    $quotation = '1';

    $ordnumber = 'quonumber';

  } elsif ($form->{type} eq 'sales_order') {

    $periodic_invoices_columns = qq| , COALESCE(pcfg.active, 'f') AS periodic_invoices |;

    $periodic_invoices_joins   = qq| LEFT JOIN periodic_invoices_configs pcfg ON (o.id = pcfg.oe_id) |;

    qq|LEFT JOIN order_statuses ON (o.order_status_id = order_statuses.id) | .

    qq|$periodic_invoices_joins | .

    $phone_notes_join .

  push(@values, $quotation);

  if ($form->{department_id}) {

    $query .= qq| AND o.department_id = ?|;