X-Git-Url: http://wagnertech.de/git?p=kivitendo-erp.git;a=blobdiff_plain;f=SL%2FController%2FMebil.pm;fp=SL%2FController%2FMebil.pm;h=dbb8c2dea49a8a4f69e7752914f29cd2c95a6021;hp=570e07011884ecfd7ab063d9031b5d647f9a5699;hb=5349a1ed016ae603b39d73747eccc6792707db1c;hpb=2a0cbd885790174fa0f212e6661b30362650a42c

diff --git a/SL/Controller/Mebil.pm b/SL/Controller/Mebil.pm
index 570e07011..dbb8c2dea 100644
--- a/SL/Controller/Mebil.pm
+++ b/SL/Controller/Mebil.pm
@@ -13,6 +13,8 @@ use SL::Locale::String;  # t8
 #use Data::Dumper;
 #use SL::ClientJS;
 
+use SL::mebil::Mapping;
+
 use Rose::Object::MakeMethods::Generic (
   scalar                  => [ qw(report number_columns year current_year objects subtotals_per_quarter salesman_id) ],
   'scalar --get_set_init' => [ qw(employees types data) ],
@@ -56,8 +58,8 @@ sub action_showmap {
 	
 	$::form->{title} = $::locale->text('Mebil Map');
 
-	my $sql = "SELECT fromacc,typ,toacc from mebil_mapping order by ordering";
-	$self->{data} = SL::DBUtils::selectall_hashref_query($::form, $::form->get_standard_dbh, $sql);
+	my $mapping = new SL::mebil::Mapping($::form, $::form->get_standard_dbh);
+	$self->{data} = $mapping->get_mapping();
 
 	$self->prepare_report;
 	$self->list_data;