projekt kivitendo

  description        => { type => 'text' },

  discount           => { type => 'float', precision => 4 },

  fxsellprice        => { type => 'numeric', precision => 5, scale => 15 },

  id                 => { type => 'integer', not_null => 1, sequence => 'invoiceid' },

  itime              => { type => 'timestamp', default => 'now()' },

  lastcost           => { type => 'numeric', precision => 5, scale => 15 },

         doi.reqdate, doi.project_id, doi.serialnumber, doi.lastcost,

         doi.ordnumber, doi.transdate, doi.cusordnumber, doi.longdescription,

         doi.price_factor_id, doi.price_factor, doi.marge_price_factor, doi.pricegroup_id,

         pg.partsgroup

       FROM delivery_order_items doi

       JOIN parts p ON (doi.parts_id = p.id)

  my @arrays =

    qw(runningnumber number description longdescription qty ship unit bin

       partnotes serialnumber reqdate sellprice listprice netprice

       discount p_discount discount_sub nodiscount_sub

       linetotal  nodiscount_linetotal tax_rate projectnumber projectdescription

      push @{ $form->{TEMPLATE_ARRAYS}->{sellprice} },         $form->{"sellprice_$i"};

      push @{ $form->{TEMPLATE_ARRAYS}->{sellprice_nofmt} },   $form->parse_amount($myconfig, $form->{"sellprice_$i"});

      push @{ $form->{TEMPLATE_ARRAYS}->{ordnumber_oe} },      $form->{"ordnumber_$i"};

      push @{ $form->{TEMPLATE_ARRAYS}->{transdate_oe} },      $form->{"transdate_$i"};

      push @{ $form->{TEMPLATE_ARRAYS}->{invnumber} },         $form->{"invnumber"};

      push @{ $form->{TEMPLATE_ARRAYS}->{invdate} },           $form->{"invdate"};

        qq|INSERT INTO invoice (id, trans_id, parts_id, description, longdescription, qty,

                                sellprice, fxsellprice, discount, allocated, assemblyitem,

                                unit, deliverydate, project_id, serialnumber, pricegroup_id,

                                marge_percent, marge_total, lastcost,

                                price_factor_id, price_factor, marge_price_factor)

                   (SELECT factor FROM price_factors WHERE id = ?), ?)|;

      @values = ($invoice_id, conv_i($form->{id}), conv_i($form->{"id_$i"}),

                 $form->{"discount_$i"}, $allocated, 'f',

                 $form->{"unit_$i"}, conv_date($form->{"reqdate_$i"}), conv_i($form->{"project_id_$i"}),

                 $form->{"serialnumber_$i"}, $pricegroup_id,

                 $form->{"cusordnumber_$i"}, $baseqty, $form->{"subtotal_$i"} ? 't' : 'f',

                 $form->{"marge_percent_$i"}, $form->{"marge_absolut_$i"},

                 $form->{"lastcost_$i"},

           i.id AS invoice_id,

           i.description, i.longdescription, i.qty, i.fxsellprice AS sellprice, i.discount, i.parts_id AS id, i.unit, i.deliverydate AS reqdate,

           i.price_factor_id, i.price_factor, i.marge_price_factor,

           p.partnumber, p.assembly, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, p.formel, p.listprice,

           pr.projectnumber, pg.partsgroup, prg.pricegroup

      }

    }

    map { $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, $form->{"${_}_${i}"}) if $form->{"${_}_${i}"} } qw(ship qty sellprice listprice lastcost basefactor);

  }

  $form->{type} = "invoice";

          $cgi->hidden("-name" => "price_new_$i", "-value" => $form->format_amount(\%myconfig, $form->{"price_new_$i"})),

          map { ($cgi->hidden("-name" => $_, "-id" => $_, "-value" => $form->{$_})); } map { $_."_$i" }

            (qw(orderitems_id bo pricegroup_old price_old id inventory_accno bin partsgroup partnotes

                longdescription basefactor marge_absolut marge_percent marge_price_factor weight), @hidden_vars)

    );

                taxaccounts bin assembly weight projectnumber project_id

                oldprojectnumber runningnumber serialnumber partsgroup payment_id

                not_discountable shop ve gv buchungsgruppen_id language_values

                transdate longdescription basefactor marge_total marge_percent

                marge_price_factor lastcost price_factor_id partnotes

                stock_out stock_in has_sernumber reqdate);

              </listitem>

            </varlistentry>

            <varlistentry>

              <term><varname>p_discount</varname></term>