projekt kivitendo

  my @apoe_filters         = qw(transdate);

  my @like_filters         = (@simple_filters, @invoice_oi_filters);

  my @all_columns          = (@simple_filters, @makemodel_filters, @apoe_filters, @project_filters, qw(serialnumber));

  my @oe_flags             = qw(bought sold onorder ordered rfq quoted);

  my @qsooqr_flags         = qw(invnumber ordnumber quonumber trans_id name module qty);

  my @deliverydate_flags   = qw(deliverydate);

    push @bind_vars, $form->{"partsgroup_id"};

  }

  foreach (@like_filters) {

    next unless $form->{$_};

    $form->{"l_$_"} = '1'; # show the column

  my $token_builder = $make_token_builder->(\%joins_needed);

     $form->{sort} = 'id' unless grep { $form->{"l_$_"} } grep { $form->{sort} eq $_ } @sort_cols; # sort by id if unknown or invisible column

  my $sort_order   = ($form->{revers} ? ' DESC' : ' ASC');

  my $order_clause = " ORDER BY " . $token_builder->($form->{sort}) . ($form->{revers} ? ' DESC' : ' ASC');

    'transdate'          => { 'text' => $locale->text('Transdate'), },

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

    'weight'             => { 'text' => $locale->text('Weight'), },

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

    'projectdescription' => { 'text' => $locale->text('Project Description'), },

  );

  my @itemstatus_keys = qw(active obsolete orphaned onhand short);

  my @callback_keys   = qw(onorder ordered rfq quoted bought sold partnumber partsgroup partsgroup_id serialnumber description make model

  # calculate dependencies

  for (@itemstatus_keys, @callback_keys) {

    linetotallistprice sellprice linetotalsellprice lastcost linetotallastcost

    priceupdate weight image drawing microfiche invnumber ordnumber quonumber

    transdate name serialnumber deliverydate ean projectnumber projectdescription

  );

  my $pricegroups = SL::DB::Manager::Pricegroup->get_all(sort => 'id');

  %column_defs = (%column_defs, %column_defs_cvars, %column_defs_pricegroups);

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

  my @hidden_variables = (

    qw(l_subtotal l_linetotal searchitems itemstatus bom l_pricegroups),

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

  my @sort_no_revers   = qw(partsgroup bin priceupdate invnumber ordnumber quonumber name image drawing serialnumber);

  foreach my $col (@sort_full) {

    $row->{weight}->{data} .= ' ' . $defaults->{weightunit};

    if (!$ref->{assemblyitem}) {

      foreach my $col (@subtotal_columns) {

        $totals{$col}    += $soldtotal * $ref->{$col};

       <td><input name="microfiche" size="20"></td>

      </tr>

      [% CUSTOM_VARIABLES_FILTER_CODE %]

      [%- IF is_assembly %]

         <tr>

          <td>[%- L.checkbox_tag('l_notes', label=LxERP.t8('Notes'), value='Y') %]</td>

          <td>[%- L.checkbox_tag('l_name', label=LxERP.t8('Name in Selected Records'), value='Y') %]</td>

         </tr>

         [% CUSTOM_VARIABLES_INCLUSION_CODE %]