projekt kivitendo

  $form->{soldtotal} = undef if $form->{l_soldtotal}; # security fix. top100 insists on putting strings in there...

  my @simple_filters       = qw(partnumber ean description partsgroup microfiche drawing onhand);

  my @makemodel_filters    = qw(make model);

  my @invoice_oi_filters   = qw(serialnumber soldtotal);

  my @apoe_filters         = qw(transdate);

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

  my @simple_l_switches    = (@all_columns, qw(listprice sellprice lastcost priceupdate weight unit bin rop image));

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

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

    pfac       => 'LEFT JOIN price_factors pfac ON (pfac.id     = p.price_factor_id)',

    invoice_oi =>

      q|LEFT JOIN (

       ) AS ioi ON ioi.parts_id = p.id|,

    apoe       =>

      q|LEFT JOIN (

       ) AS apoe ON ((ioi.trans_id = apoe.id) AND (ioi.ioi = apoe.ioi))|,

    cv         =>

      q|LEFT JOIN (

           SELECT id, name, 'vendor'   AS cv FROM vendor

         ) AS cv ON cv.id = apoe.customer_id OR cv.id = apoe.vendor_id|,

    mv         => 'LEFT JOIN vendor AS mv ON mv.id = mm.make',

  );

  my %table_prefix = (

     deliverydate => 'apoe.', serialnumber => 'ioi.',

     quonumber    => 'apoe.', model        => 'mm.',

     invnumber    => 'apoe.', partsgroup   => 'pg.',

     lastcost     => 'p.',  , soldtotal    => ' ',

     description  => 'p.',

     qty          => 'ioi.',

     serialnumber => 'ioi.',

  # of the scecified table will gently override (coalesce actually) the original value

  # use it to conditionally coalesce values from subtables

  my @column_override = (

    [ 'description',  'ioi.',  'invoice_oi'  ],

    [ 'deliverydate', 'ioi.',  'invoice_oi'  ],

    [ 'transdate',    'apoe.', 'apoe'        ],

    'SUM(ioi.qty)' => 'soldtotal',

    'ioi.id'       => 'ioi_id',

    'ioi.ioi'      => 'ioi',

  );

  if (($form->{searchitems} eq 'assembly') && $form->{l_lastcost}) {

  my $make_token_builder = sub {

    my $joins_needed = shift;

    sub {

      my @coalesce_tokens =

        map  { ($_->[1] || 'p.') . $_->[0] }

        grep { !$_->[2] || $joins_needed->{$_->[2]} }

      my $coalesce = scalar @coalesce_tokens > 1;

      return ($coalesce

        ? sprintf 'COALESCE(%s)', join ', ', @coalesce_tokens

        : shift                              @coalesce_tokens)

        : '');

    }

  };

  $joins_needed{partsgroup}  = 1;

  $joins_needed{pfac}        = 1;

  $joins_needed{makemodel}   = 1 if grep { $form->{$_} || $form->{"l_$_"} } @makemodel_filters;

  $joins_needed{mv}          = 1 if $joins_needed{makemodel};

  $joins_needed{cv}          = 1 if $bsooqr;

  $joins_needed{apoe}        = 1 if $joins_needed{cv}   || grep { $form->{$_} || $form->{"l_$_"} } @apoe_filters;

  # special case for description search.

  # up in the simple filter section the description filter got interpreted as something like: WHERE description ILIKE '%$form->{description}%'

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

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

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

  );

  $revers     = $form->{revers};

    partnumber description partsgroup bin onhand rop soldtotal unit listprice

    linetotallistprice sellprice linetotalsellprice lastcost linetotallastcost

    priceupdate weight image drawing microfiche invnumber ordnumber quonumber

  );

  my @includeable_custom_variables = grep { $_->{includeable} } @{ $cvar_configs };

  'Proforma Invoice'            => 'Proformarechnung',

  'Program'                     => 'Programm',

  'Project'                     => 'Projekt',

  'Project Number'              => 'Projektnummer',

  'Project Number missing!'     => 'Projektnummer fehlt!',

  'Project Numbers'             => 'Projektnummern',

           <input name="l_onhand" id="l_onhand" class="checkbox" type="checkbox" value="Y">

           <label for="l_onhand">[% 'Stocked Qty' | $T8 %]</label>

          </td>

         </tr>

         [% CUSTOM_VARIABLES_INCLUSION_CODE %]