X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/9e7d8938efd1fbbe7a4f217ef1cb35cf21430087..69bfa40a001bfd0ca75d60babdb63f9199d4e45c:/SL/Controller/DeliveryPlan.pm diff --git a/SL/Controller/DeliveryPlan.pm b/SL/Controller/DeliveryPlan.pm index 332b1a04a..16991cf3c 100644 --- a/SL/Controller/DeliveryPlan.pm +++ b/SL/Controller/DeliveryPlan.pm @@ -41,6 +41,7 @@ sub action_list { my $orderitems = $self->models->get; $self->calc_qtys($orderitems); + $self->setup_list_action_bar; $self->report_generator_list_objects(report => $self->{report}, objects => $orderitems); } @@ -208,9 +209,7 @@ sub delivery_plan_query { my $vc = $self->vc; my $employee_id = SL::DB::Manager::Employee->current->id; my $oe_owner = $_[0]->all_edit_right ? '' : " oe.employee_id = $employee_id AND"; - # check delivered state for delivery_orders (transferred out) if enabled - my $filter_delivered = ($::instance_conf->get_delivery_plan_calculate_transferred_do) ? - "AND (SELECT delivered from delivery_orders where id = doi.delivery_order_id)" : ''; + [ "order.${vc}_id" => { gt => 0 }, 'order.closed' => 0, @@ -239,7 +238,6 @@ sub delivery_plan_query { rl.to_table = 'delivery_orders' AND rl.to_id = doi.delivery_order_id AND oi.parts_id = doi.parts_id - $filter_delivered ) tuples GROUP BY parts_id, trans_id, qty ) partials LEFT JOIN orderitems oi ON partials.parts_id = oi.parts_id AND partials.trans_id = oi.trans_id @@ -292,8 +290,6 @@ sub delivery_plan_query { (oe.quotation = 'f' OR oe.quotation IS NULL) AND NOT oe.closed ) rl LEFT JOIN delivery_order_items doi ON (rl.to_id = doi.delivery_order_id) - WHERE 1 = 1 - $filter_delivered GROUP BY rl.from_id, doi.parts_id ) agg ON (agg.oid = oi.trans_id AND agg.parts_id = oi.parts_id) LEFT JOIN oe ON oe.id = oi.trans_id @@ -316,9 +312,6 @@ sub delivery_plan_query_linked_items { my $vc = $self->vc; my $employee_id = SL::DB::Manager::Employee->current->id; my $oe_owner = $_[0]->all_edit_right ? '' : " oe.employee_id = $employee_id AND"; - # check delivered state for delivery_orders (transferred out) if enabled - my $filter_delivered = ($::instance_conf->get_delivery_plan_calculate_transferred_do) ? - "AND (SELECT delivered from delivery_orders where id = doi.delivery_order_id)" : ''; [ "order.${vc}_id" => { gt => 0 }, @@ -340,7 +333,6 @@ sub delivery_plan_query_linked_items { rl.from_table = 'orderitems'AND rl.to_table = 'delivery_order_items' AND rl.from_id = oi.id - $filter_delivered GROUP BY oi.id ) linked WHERE qty > doi_qty @@ -423,7 +415,7 @@ sub link_to { } if ($object->isa('SL::DB::Part')) { my $id = $object->id; - return "ic.pl?action=$action&id=$id"; + return "controller.pl?action=Part/$action&part.id=$id"; } if ($object->isa('SL::DB::Customer')) { my $id = $object->id; @@ -431,4 +423,18 @@ sub link_to { } } +sub setup_list_action_bar { + my ($self, %params) = @_; + + for my $bar ($::request->layout->get('actionbar')) { + $bar->add( + action => [ + t8('Update'), + submit => [ '#filter_form', { action => 'DeliveryPlan/list' } ], + accesskey => 'enter', + ], + ); + } +} + 1;