projekt kivitendo

    qq|  v.vendornumber, v.country, v.ustid, | .

    qq|  tz.description AS taxzone, | .

    qq|  pt.description AS payment_terms, | .

    qq{  ( SELECT ch.accno || ' -- ' || ch.description

           FROM acc_trans at

           LEFT JOIN chart ch ON ch.id = at.chart_id

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

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

    qq|LEFT JOIN tax_zones tz ON (tz.id = a.taxzone_id)| .

  my $where = '';

  my $sortdir   = !defined $form->{sortdir} ? 'ASC' : $form->{sortdir} ? 'ASC' : 'DESC';

  my $sortorder = join(', ', map { "$_ $sortdir" } @a);

    $sortorder = $form->{sort} . " $sortdir";

  }

  my @columns =

    qw(transdate id type invnumber ordnumber name netamount tax amount paid datepaid

       vendornumber country ustid taxzone payment_terms charts direct_debit);

  my @hidden_variables = map { "l_${_}" } @columns;

    'notes'                   => { 'text' => $locale->text('Notes'), },

    'employee'                => { 'text' => $locale->text('Employee'), },

    'globalprojectnumber'     => { 'text' => $locale->text('Document Project Number'), },

    'vendornumber'            => { 'text' => $locale->text('Vendor Number'), },

    'country'                 => { 'text' => $locale->text('Country'), },

    'ustid'                   => { 'text' => $locale->text('USt-IdNr.'), },

    'direct_debit'            => { 'text' => $locale->text('direct debit'), },

  );

    my $sortdir                 = $form->{sort} eq $name ? 1 - $form->{sortdir} : $form->{sortdir};

    $column_defs{$name}->{link} = $href . "&sort=$name&sortdir=$sortdir";

  }

           <td nowrap>[% 'Notes' | $T8 %]</td>

           <td align=right><input name="l_employee" class=checkbox type=checkbox value=Y></td>

           <td nowrap>[% 'Employee' | $T8 %]</td>

          </tr>

          <tr>

           <td align=right><input name="l_subtotal" class=checkbox type=checkbox value=Y></td>