projekt kivitendo

           i.project_id, i.serialnumber, i.pricegroup_id, i.ordnumber, i.donumber, i.transdate, i.cusordnumber, i.subtotal, i.lastcost,

           i.price_factor_id, i.price_factor, i.marge_price_factor, i.active_price_source, i.active_discount_source,

           p.partnumber, p.part_type, p.notes AS partnotes, p.formel, p.listprice,

           pr.projectnumber, pg.partsgroup, prg.pricegroup

         FROM invoice i

         p.id, p.partnumber, p.description, p.sellprice,

         p.listprice, p.part_type, p.lastcost,

         p.ean, p.notes,

         c1.accno AS inventory_accno,

         c1.new_chart_id AS inventory_new_chart,

         p.price_factor_id, p.weight,

         pfac.factor AS price_factor,

         pg.partsgroup

       FROM parts p

           FROM taxzone_charts tc

           WHERE tc.buchungsgruppen_id = p.buchungsgruppen_id and tc.taxzone_id = ${taxzone_id}) = c3.id)

       LEFT JOIN partsgroup pg ON (pg.id = p.partsgroup_id)

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

       WHERE $where|;

  my $sth = prepare_execute_query($form, $dbh, $query, @values);

                                   LIMIT 1| ] );

  map { push @{ $_ }, prepare_query($form, $dbh, $_->[0]) } @translation_queries;

  while (my $ref = $sth->fetchrow_hashref('NAME_lc')) {

    if ($mm_by_id{$ref->{id}}) {

      push @{ $ref->{matches} ||= [] }, $::locale->text('EAN') . ': ' . $ref->{ean};

    }

    # In der Buchungsgruppe ist immer ein Bestandskonto verknuepft, auch wenn

    # es sich um eine Dienstleistung handelt. Bei Dienstleistungen muss das

    # Buchungskonto also aus dem Ergebnis rausgenommen werden.

  $sth->finish;

  $_->[1]->finish for @translation_queries;

  foreach my $item (@{ $form->{item_list} }) {

    my $custom_variables = CVar->get_custom_variables(module   => 'IC',

                                                      trans_id => $item->{id},

                                                      dbh      => $dbh,

                                                     );

    map { $item->{"ic_cvar_" . $_->{name} } = $_->{value} } @{ $custom_variables };

  }

  $main::lxdebug->leave_sub();

}