projekt kivitendo

    my $basket_part = SL::DB::PurchaseBasketItem->new(

      parts_id    => $part->id,

      qty         => $part->ordersize, # was ist wenn order_size < (rop-onhand) ist? sollte dann nicht (rop-onhand) genommen werden?

    )->save;

 }

 $self->action_show_basket;

    my $basket_part = SL::DB::PurchaseBasketItem->new(

      parts_id    => $self->part->id,

      qty         => $self->part->ordersize || 1, # was ist wenn order_size < (rop-onhand) ist? sollte dann nicht (rop-onhand) genommen werden?

    )->save;

    $self->js->flash('info', t8('Part added to purchasebasket'))->render;

      paginated    => { per_page => 2 },

      with_objects => [ qw(unit_obj classification) ],

    );

    my $exact_matches;

    if (1 == scalar @{ $exact_matches = $exact_models->get }) {

      $self->parts($exact_matches);

  return SL::DB::Manager::PurchaseBasketItem->get_all_count( query => [ parts_id => $self->part->id ] );

}

sub _setup_form_action_bar {

  my ($self) = @_;

        call     => [ 'kivi.Part.add_to_basket' ],

        disabled => !$self->part->id       ? t8('This object has not been saved yet.')

                  : $self->_is_in_purchase_basket ? t8('Part already in purchasebasket')

                  : !scalar @{$self->part->makemodels} ? t8('No vendors to add to purchasebasket')

                  : undef,

      ],

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

  marge_price_factor     => { type => 'numeric', default => 1, precision => 15, scale => 5 },

  mtime                  => { type => 'timestamp' },

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

  parts_id               => { type => 'integer', not_null => 1 },

  position               => { type => 'integer', not_null => 1 },

    key_columns => { delivery_order_id => 'id' },

  },

  part => {

    class       => 'SL::DB::Part',

    key_columns => { parts_id => 'id' },

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

  mtime                        => { type => 'timestamp' },

  optional                     => { type => 'boolean', default => 'false' },

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

  parts_id                     => { type => 'integer' },

  position                     => { type => 'integer', not_null => 1 },

    key_columns => { trans_id => 'id' },

  },

  part => {

    class       => 'SL::DB::Part',

    key_columns => { parts_id => 'id' },

__PACKAGE__->meta->table('purchase_basket_items');

__PACKAGE__->meta->columns(

);

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

__PACKAGE__->meta->foreign_keys(

  part => {

    class       => 'SL::DB::Part',

    key_columns => { parts_id => 'id' },

           o.ordnumber, o.transdate, o.cusordnumber, o.subtotal, o.recurring_billing_mode, o.longdescription,

           o.price_factor_id, o.price_factor, o.marge_price_factor, o.active_price_source, o.active_discount_source,

           pr.projectnumber, p.formel,

         FROM orderitems o

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

         JOIN oe ON (o.trans_id = oe.id)

         LEFT JOIN chart c2 ON ((SELECT tc.income_accno_id  FROM taxzone_charts tc WHERE tc.taxzone_id = ? and tc.buchungsgruppen_id = p.buchungsgruppen_id) = c2.id)

         LEFT JOIN chart c3 ON ((SELECT tc.expense_accno_id FROM taxzone_charts tc WHERE tc.taxzone_id = ? and tc.buchungsgruppen_id = p.buchungsgruppen_id) = c3.id)

         LEFT JOIN project pr ON (o.project_id = pr.id)

      ($form->{id}

       ? qq|WHERE o.trans_id = ?|

       : qq|WHERE o.trans_id IN (| . join(", ", map("?", @ids)) . qq|)|) .

  my @arrays =

    qw(runningnumber number description longdescription qty qty_nofmt ship ship_nofmt unit bin

       partnotes serialnumber reqdate sellprice sellprice_nofmt listprice listprice_nofmt netprice netprice_nofmt

       discount discount_nofmt p_discount discount_sub discount_sub_nofmt nodiscount_sub nodiscount_sub_nofmt

       linetotal linetotal_nofmt nodiscount_linetotal nodiscount_linetotal_nofmt tax_rate projectnumber projectdescription

       price_factor price_factor_name partsgroup weight weight_nofmt lineweight lineweight_nofmt optional);

  # position of serialnr is used below!

  my @row2_sort   = qw(

    tax_chart tax serialnr projectnr reqdate subtotal recurring_billing_mode marge listprice lastcost onhand

  );

  # serialnr is important for delivery_orders

  if ($form->{type} eq 'sales_delivery_order') {

    vendor_partnumber => { width => 8, value => $locale->text('Vendor Part Number'),   display => $is_delivery_order && $is_purchase, },

    tax_chart     => {                 value => "",                                    display => $is_purchase && $is_invoice },

    tax           => {                 value => $locale->text('Tax'),                  display => $is_purchase && $is_invoice },

  );

  my @HEADER = map { $column_def{$_} } @header_sort;

      default => $::form->{"recurring_billing_mode_$i"} || 'always',

    );

    # begin marge calculations

    $form->{"lastcost_$i"}     *= 1;

    $form->{"marge_percent_$i"} = 0;

  'Already counted'             => 'Bereits erfasst',

  'Already imported entries (duplicates)' => 'Bereits importierte Einträge (Duplikate)',

  'Already imported: '          => 'Bereits importiert:',

  'Always edit assembly items (user can change/delete items even if assemblies are already produced)' => 'Erzeugnisbestandteile verändern (Löschen/Umsortieren) auch nachdem dieses Erzeugnis schon produziert wurde.',

  'Always edit assortment items (user can change/delete items even if assortments are already used)' => 'Sortimentsbestandteile verändern (Löschen/Umsortieren), auch nachdem dieses Sortiment schon verwendet wurde.',

  'Always save orders with a projectnumber (create new projects)' => 'Aufträge immer mit Projektnummer speichern (neue Projekte erstellen)',

  'Order/Item row name'         => 'Name der Auftrag-/Positions-Zeilen',

  'Order/Item/Stock row name'   => 'Name der Auftrag-/Positions-/Lager-Zeilen',

  'Order/RFQ Number'            => 'Belegnummer',

  'OrderItem'                   => 'Position',

  'Ordered'                     => 'Von Kunden bestellt',

  'Ordered qty'                 => 'bestellt',

  'Ordered purchase'            => 'Bestellte Menge',

  'Orders'                      => 'Aufträge',

  'Orders / Delivery Orders deleteable' => 'Aufträge / Lieferscheine löschbar',

  'Orders in Webshop'           => 'Bestellungen in Webshop',

  'Part Type'                   => 'Artikel-Typ',

  'Part Unit'                   => 'Einheit',

  'Part added to purchasebasket' => 'Zu Einkaufkorb hinzugefügt',

  'Part already in purchasebasket or has no vendor' => 'Artikel ist schon im Bestellwarenkorb oder hat keinen Lieferanten',

  'Part classifications'        => 'Artikel-Klassifizierungen',

  'Part marked as "Shop part"'  => 'Markiert als Shopartikel',

  'Part picker'                 => 'Artikelauswahl',

  'VAT ID'                      => 'USt-IdNr.',

  'VAT ID and/or taxnumber must be given.' => 'UStId und/oder Steuernummer muss angegeben werden.',

  'VN'                          => 'Kred.-Nr.',

  'Valid'                       => 'Gültig',

  'Valid are integer values and floating point numbers, e.g. 4.75h = 4 hours and 45 minutes.' => 'Erlaubt sind ganzzahlige Werte und Kommawerte: Beispiel: 4,75h = 4 Stunden und 45 Minuten.',

  'Valid for Purchase'          => 'Gültig für Einkauf',

    </thead>

    <tbody>

    [% FOREACH basket_item = BASKET_ITEMS %]

    [% SET select_size = basket_item.part.vendor_dropdown.size %]

      <tr class="listrow">

        <td>[% L.checkbox_tag('ids[+]', checked = '1',  value=basket_item.id) %]</td>

        <td>[% HTML.escape(basket_item.part.partnumber) %] </td>

        <td class="numeric">[% basket_item.qty_as_number %] </td>

        <td>[% L.select_tag('vendor_ids[]', basket_item.part.vendor_dropdown, value_key = 'value', title_key = 'title', default = basket_item.part.makemodels.item(0).make, size = select_size, style='width: 350px;' ) %]</td>

      </tr>

    [% END %]

    </tbody>

  </table>