projekt kivitendo

     "partunit"             => "p.unit",

     "stock_value"          => "p.lastcost / COALESCE(pfac.factor, 1)",

     "purchase_price"       => "p.lastcost",

  );

  $form->{l_classification_id}  = 'Y';

  $form->{l_part_type}          = 'Y';

  my $sort_col     = $form->{sort};

  my %filter;

  # filter stuff

  map { $filter{$_} = $form->{$_} if ($form->{$_}) } qw(warehouse_id bin_id classification_id partnumber description chargenumber bestbefore date include_invalid_warehouses);

    'partunit'             => { 'text' => $locale->text('Unit'), },

    'stock_value'          => { 'text' => $locale->text('Stock value'), },

    'purchase_price'       => { 'text' => $locale->text('Purchase price'), },

  );

  my $href = build_std_url('action=generate_report', grep { $form->{$_} } @hidden_variables);

  map { $column_defs{$_}->{link} = $href . "&page=".$page."&sort=${_}&order=" . Q($_ eq $sort_col ? 1 - $form->{order} : $form->{order}) } @columns;

  map { $column_defs{$_}->{visible} = $form->{"l_${_}"} ? 1 : 0 } @columns;

#                                                       'conv_units' => 'convertible');

    $entry->{stock_value} = $form->format_amount(\%myconfig, $entry->{stock_value} * 1, 2);

    $entry->{purchase_price} = $form->format_amount(\%myconfig, $entry->{purchase_price} * 1, 2);

    my $row_set = [ { map { $_ => { 'data' => $entry->{$_}, 'align' => $column_alignment{$_} } } @columns } ];

#                                                               'conv_units' => 'convertible');

      $row->{stock_value}->{data} = $form->format_amount(\%myconfig, $subtotals{stock_value} * 1, 2);

      $row->{purchase_price}->{data} = $form->format_amount(\%myconfig, $subtotals{purchase_price} * 1, 2);

      %subtotals                  = map { $_ => 0 } @subtotals_columns;

        <td nowrap><label for="l_stock_value">[% 'Stock value' | $T8 %]</label></td>

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

        <td nowrap><label for="l_purchase_price">[% 'Purchase price' | $T8 %]</label></td>

       </tr>

      </table>