Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 5962d153

Von Werner Hahn vor etwa 2 Jahren hinzugefügt

  • ID 5962d153f8b3dfbbeb0ad6cadf23b0234aa5a76f
  • Vorgänger d9152018
  • Nachfolger 53a02517

Dispositionsmanager List umgeschrieben wg Performance

Unterschiede anzeigen:

SL/Controller/DispositionManager.pm
my ( $self ) = @_;
my $parts = $self->_get_parts;
my $parts_tmp;
for my $part(@{ $parts }) {
my $openitems = SL::DB::Manager::OrderItem->get_all(where => [ parts_id => $part->id, 'order.closed' => 0 ],
with_objects => ['order'],);
my ($not_delivered, $ordered) = 0;
for my $openitem (@{ $openitems }) {
if($openitem -> order -> type eq 'sales_order') {
$not_delivered += $openitem->qty - $openitem->shipped_qty;
} elsif ( $openitem->order->type eq 'purchase_order' ) {
$ordered += $openitem->qty - $openitem->delivered_qty;
}
}
$part->assign_attributes( gv => $ordered );
push @{ $parts_tmp }, $part;
}
$self->_setup_list_action_bar;
$self->render('disposition_manager/list_parts', title => t8('Parts short onhand'), PARTS => $parts);
$self->render('disposition_manager/list_parts', title => t8('Parts short onhand'), PARTS => $parts_tmp);
}
sub action_add_to_purchase_basket{
templates/webpages/disposition_manager/list_parts.html
</tr>
</thead>
[% FOREACH part = PARTS %]
[% IF !part.get_open_ordered_qty(part.id) %]
[% IF !part.gv %]
<tr class="listrow">
<td>[% IF part.makemodels.size %][% L.checkbox_tag('ids[+]', "data-checkall"=1, checked = '1', value=part.id) %][% ELSE %][% 'No Vendor' | $T8 %][% END %]</td>
<td>[% HTML.escape(part.partnumber) %]</td>
......
</tr>
</thead>
[% FOREACH part = PARTS %]
[% IF part.get_open_ordered_qty(part.id) %]
[% IF part.gv %]
<tr class="listrow">
<td>[% HTML.escape(part.partnumber) %]</td>
<td>[% HTML.escape(part.description) %] </td>
<td class="numeric">[% part.onhand_as_number %] </td>
<td class="numeric">[% part.rop_as_number %] </td>
<td class="numeric">[% part.get_open_ordered_qty(part.id) %] </td>
<td class="numeric">[% part.gv %] </td>
</tr>
[% END %]
[% END %]

Auch abrufbar als: Unified diff