projekt kivitendo

#

# column flags:

#   l_partnumber l_description l_listprice l_sellprice l_lastcost l_priceupdate l_weight l_unit l_rop l_image l_drawing l_microfiche l_partsgroup

#

# exclusives:

#   itemstatus  = active | onhand | short | obsolete | orphaned

# joining filters:

#   make model                               - makemodel

#   serialnumber transdatefrom transdateto   - invoice/orderitems

#

# binary flags:

#   bought sold onorder ordered rfq quoted   - aggreg joins with invoices/orders

#   onhand                                   - as above, but masking the simple itemstatus results (doh!)

#   warehouse onhand

#   search by overrides of description

#

# disabled sanity checks and changes:

#  - searchitems = assembly will no longer disable bought

  my ($self, $myconfig, $form) = @_;

  my $dbh = $form->get_standard_dbh($myconfig);

  $form->{parts}     = +{ };

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

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

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

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

  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);

         ) 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',

    project    => 'LEFT JOIN project AS pj ON pj.id = COALESCE(ioi.project_id, apoe.globalproject_id)',

  );

  my %table_prefix = (

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

  $joins_needed{cv}          = 1 if $bsooqr;

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

  $joins_needed{invoice_oi}  = 1 if $joins_needed{project} || $joins_needed{apoe} || grep { $form->{$_} || $form->{"l_$_"} } @invoice_oi_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}%'

  my $where_clause  = join ' AND ', map { "($_)" } @where_tokens;

  my $group_clause  = @group_tokens ? ' GROUP BY ' . join ', ',    map { $token_builder->($_) } @group_tokens : '';

  my %oe_flag_to_cvar = (

    bought   => 'invoice',

    sold     => 'invoice',

  $form->{title} = $locale->text('Articles');

  my %column_defs = (

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

    'description'        => { 'text' => $locale->text('Part Description'), },

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

    'type_and_classific' => { 'text' => $locale->text('Type'), },

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

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

  );

  $revers     = $form->{revers};

  if ($form->{l_service} && !$form->{l_assembly} && !$form->{l_part}) {

    $form->{l_onhand} = "";

    flash('warning', $::locale->text('Soldtotal does not make sense without any bsooqr options'));

  }

  if ($form->{l_name} && !$bsooqr_mode) {

    delete $form->{l_name};

  IC->all_parts(\%myconfig, \%$form);

  my @columns = qw(

    linetotallistprice sellprice linetotalsellprice lastcost linetotallastcost

    priceupdate weight image drawing microfiche invnumber ordnumber quonumber

    transdate name serialnumber deliverydate ean projectnumber projectdescription

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

  my @sort_full        = qw(partnumber description onhand soldtotal deliverydate insertdate shop);

  foreach my $col (@sort_full) {

    $column_defs{$col}->{link} = join '&', $callback, "sort=$col", map { "$_=" . E($form->{$_}) } qw(revers lastsort);

  - SEPA-XML: alle Sonderzeichen filtern

  - SEPA-Export: Export wieder rückgängig machen, falls noch Status offen

2017-07-17 - Release 3.5.0

  'Sold order items'            => 'Verkaufte Auftragsartikel',

  'Soldtotal does not make sense without any bsooqr options' => 'Option "Menge in gewählten Belegen" ohne gewählte Belege wird ignoriert.',

  'Solution'                    => 'Lösung',

  'Sort By'                     => 'Sortiert nach',

  'Source'                      => 'Beleg',

  'Source BIC'                  => 'Quell-BIC',