projekt kivitendo

  my $query =

    qq|SELECT DISTINCT a.id, a.invnumber, a.ordnumber, a.cusordnumber, a.transdate, | .

    qq|  a.duedate, a.netamount, a.amount, a.paid, | .

    qq|  a.invoice, a.datepaid, a.notes, a.shipvia, | .

    qq|  a.shippingpoint, a.storno, a.storno_id, a.globalproject_id, | .

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

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

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

  }

  my $report = SL::ReportGenerator->new(\%myconfig, $form);

  @columns =

       datepaid due duedate transaction_description notes salesman employee shippingpoint shipvia

       marge_total marge_percent globalprojectnumber customernumber country ustid taxzone

       payment_terms charts customertype direct_debit dunning_description department);

    'invnumber'               => { 'text' => $locale->text('Invoice'), },

    'ordnumber'               => { 'text' => $locale->text('Order'), },

    'cusordnumber'            => { 'text' => $locale->text('Customer Order Number'), },

    'name'                    => { 'text' => $locale->text('Customer'), },

    'netamount'               => { 'text' => $locale->text('Amount'), },

    'tax'                     => { 'text' => $locale->text('Tax'), },

    %column_defs_cvars,

  );

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

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

  }

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

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

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

          </tr>

          <tr>

           <td align=right><input name="l_netamount" id="l_netamount" class=checkbox type=checkbox value="Y" checked></td>

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