Revision 5962d153
Von Werner Hahn vor etwa 2 Jahren hinzugefügt
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
Dispositionsmanager List umgeschrieben wg Performance