Dialogbuchen - Abteilung nutzt immer L.select_tag als Dropdown

diff --git a/SL/GL.pm b/SL/GL.pm
index 20d469a63eb6c423b55e14ab122c2a80adb82c0c..09fc2f03bf382ac21c01fe7f65f7253c1b44ee0e 100644 (file)
--- a/SL/GL.pm
+++ b/SL/GL.pm
@@ -113,8 +113,6 @@ sub _post_transaction {
     do_query($form, $dbh, $query, @values);
   }
 
     do_query($form, $dbh, $query, @values);
   }
 

-  my ($null, $department_id) = split(/--/, $form->{department});
-

   $form->{ob_transaction} *= 1;
   $form->{cb_transaction} *= 1;
 
   $form->{ob_transaction} *= 1;
   $form->{cb_transaction} *= 1;
 


@@ -126,7 +124,7 @@ sub _post_transaction {
        WHERE id = ?|;
 
   @values = ($form->{reference}, $form->{description}, $form->{notes},
        WHERE id = ?|;
 
   @values = ($form->{reference}, $form->{description}, $form->{notes},

-             conv_date($form->{transdate}), conv_i($department_id), $form->{taxincluded} ? 't' : 'f',
+             conv_date($form->{transdate}), conv_i($form->{department_id}), $form->{taxincluded} ? 't' : 'f',

              $form->{storno} ? 't' : 'f', conv_i($form->{storno_id}), $form->{ob_transaction} ? 't' : 'f', $form->{cb_transaction} ? 't' : 'f',
              conv_i($form->{id}));
   do_query($form, $dbh, $query, @values);
              $form->{storno} ? 't' : 'f', conv_i($form->{storno_id}), $form->{ob_transaction} ? 't' : 'f', $form->{cb_transaction} ? 't' : 'f',
              conv_i($form->{id}));
   do_query($form, $dbh, $query, @values);


@@ -233,14 +231,13 @@ sub all_transactions {
     push(@apvalues, like($form->{reference}));
   }
 
     push(@apvalues, like($form->{reference}));
   }
 

-  if ($form->{department}) {
-    my ($null, $department) = split /--/, $form->{department};
+  if ($form->{department_id}) {

     $glwhere .= qq| AND g.department_id = ?|;
     $arwhere .= qq| AND a.department_id = ?|;
     $apwhere .= qq| AND a.department_id = ?|;
     $glwhere .= qq| AND g.department_id = ?|;
     $arwhere .= qq| AND a.department_id = ?|;
     $apwhere .= qq| AND a.department_id = ?|;

-    push(@glvalues, $department);
-    push(@arvalues, $department);
-    push(@apvalues, $department);
+    push(@glvalues, $form->{department_id});
+    push(@arvalues, $form->{department_id});
+    push(@apvalues, $form->{department_id});

   }
 
   if ($form->{source}) {
   }
 
   if ($form->{source}) {


@@ -639,7 +636,8 @@ sub transaction {
   if ($form->{id}) {
     $query =
       qq|SELECT g.reference, g.description, g.notes, g.transdate, g.storno, g.storno_id,
   if ($form->{id}) {
     $query =
       qq|SELECT g.reference, g.description, g.notes, g.transdate, g.storno, g.storno_id,

-           d.description AS department, e.name AS employee, g.taxincluded, g.gldate,
+           g.department_id, d.description AS department,
+           e.name AS employee, g.taxincluded, g.gldate,

          g.ob_transaction, g.cb_transaction
          FROM gl g
          LEFT JOIN department d ON (d.id = g.department_id)
          g.ob_transaction, g.cb_transaction
          FROM gl g
          LEFT JOIN department d ON (d.id = g.department_id)

diff --git a/bin/mozilla/gl.pl b/bin/mozilla/gl.pl
index 7237a593c86a939f7f8e58c659b4ee5457e35900..2c203d33e9cf227b80cbc9aeb7e4bdc5ea3fc485 100644 (file)
--- a/bin/mozilla/gl.pl
+++ b/bin/mozilla/gl.pl
@@ -99,16 +99,7 @@ sub add {
   $form->{credit} = 0;
   $form->{tax}    = 0;
 
   $form->{credit} = 0;
   $form->{tax}    = 0;
 

-  # departments
-  $form->all_departments(\%myconfig);
-  if (@{ $form->{all_departments} || [] }) {
-    $form->{selectdepartment} = "<option>\n";
-
-    map {
-      $form->{selectdepartment} .=
-        "<option>$_->{description}--$_->{id}\n"
-    } (@{ $form->{all_departments} || [] });
-  }
+  $::form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all;

 
   $form->{show_details} = $myconfig{show_form_details} unless defined $form->{show_details};
 
 
   $form->{show_details} = $myconfig{show_form_details} unless defined $form->{show_details};
 


@@ -129,16 +120,7 @@ sub prepare_transaction {
 
   $form->{amount} = $form->format_amount(\%myconfig, $form->{amount}, 2);
 
 
   $form->{amount} = $form->format_amount(\%myconfig, $form->{amount}, 2);
 

-  # departments
-  $form->all_departments(\%myconfig);
-  if (@{ $form->{all_departments} || [] }) {
-    $form->{selectdepartment} = "<option>\n";
-
-    map {
-      $form->{selectdepartment} .=
-        "<option>$_->{description}--$_->{id}\n"
-    } (@{ $form->{all_departments} || [] });
-  }
+  $::form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all;

 
   my $i        = 1;
   my $tax      = 0;
 
   my $i        = 1;
   my $tax      = 0;


@@ -226,15 +208,14 @@ sub search {
   $::lxdebug->enter_sub;
   $::auth->assert('general_ledger | gl_transactions');
 
   $::lxdebug->enter_sub;
   $::auth->assert('general_ledger | gl_transactions');
 

-  $::form->all_departments(\%::myconfig);

   $::form->get_lists(
     projects  => { key => "ALL_PROJECTS", all => 1 },
   );
   $::form->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ deleted => 0 ]);
   $::form->get_lists(
     projects  => { key => "ALL_PROJECTS", all => 1 },
   );
   $::form->{ALL_EMPLOYEES} = SL::DB::Manager::Employee->get_all_sorted(query => [ deleted => 0 ]);

+  $::form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all;

 
   $::form->header;
   print $::form->parse_html_template('gl/search', {
 
   $::form->header;
   print $::form->parse_html_template('gl/search', {

-    department_label => sub { ("$_[0]{description}--$_[0]{id}")x2 },

     employee_label => sub { "$_[0]{id}--$_[0]{name}" },
   });
 
     employee_label => sub { "$_[0]{id}--$_[0]{name}" },
   });
 


@@ -316,7 +297,7 @@ sub generate_report {
   );
 
   # add employee here, so that variable is still known and passed in url when choosing a different sort order in resulting table
   );
 
   # add employee here, so that variable is still known and passed in url when choosing a different sort order in resulting table

-  my @hidden_variables = qw(accno source reference department description notes project_id datefrom dateto employee_id datesort category l_subtotal);
+  my @hidden_variables = qw(accno source reference description notes project_id datefrom dateto employee_id datesort category l_subtotal);

   push @hidden_variables, map { "l_${_}" } @columns;
 
   my $employee = $form->{employee_id} ? SL::DB::Employee->new(id => $form->{employee_id})->load->name : '';
   push @hidden_variables, map { "l_${_}" } @columns;
 
   my $employee = $form->{employee_id} ? SL::DB::Employee->new(id => $form->{employee_id})->load->name : '';


@@ -334,12 +315,11 @@ sub generate_report {
   push @date_options, $locale->text('Bis'),  $locale->date(\%myconfig, $form->{dateto},   1)          if ($form->{dateto});
   push @options,      join(' ', @date_options)                                                        if (scalar @date_options);
 
   push @date_options, $locale->text('Bis'),  $locale->date(\%myconfig, $form->{dateto},   1)          if ($form->{dateto});
   push @options,      join(' ', @date_options)                                                        if (scalar @date_options);
 

-  if ($form->{department}) {
-    my ($department) = split /--/, $form->{department};
-    push @options, $locale->text('Department') . " : $department";
+  if ($form->{department_id}) {
+    my $department = SL::DB::Manager::Department->find_by( id => $form->{department_id} );
+    push @options, $locale->text('Department') . " : " . $department->description;

   }
 
   }
 

-

   my $callback = build_std_url('action=generate_report', grep { $form->{$_} } @hidden_variables);
 
   $form->{l_credit_accno}     = 'Y';
   my $callback = build_std_url('action=generate_report', grep { $form->{$_} } @hidden_variables);
 
   $form->{l_credit_accno}     = 'Y';


@@ -877,9 +857,12 @@ sub form_header {
   $::form->get_lists("projects"  => { "key"       => "ALL_PROJECTS",
                                     "all"       => 0,
                                     "old_id"    => \@old_project_ids },
   $::form->get_lists("projects"  => { "key"       => "ALL_PROJECTS",
                                     "all"       => 0,
                                     "old_id"    => \@old_project_ids },

+

                    "charts"    => { "key"       => "ALL_CHARTS",
                                     "transdate" => $::form->{transdate} });
 
                    "charts"    => { "key"       => "ALL_CHARTS",
                                     "transdate" => $::form->{transdate} });
 

+  $::form->{ALL_DEPARTMENTS} = SL::DB::Manager::Department->get_all;
+

   GL->get_chart_balances('charts' => $::form->{ALL_CHARTS});
 
   my $title      = $::form->{title};
   GL->get_chart_balances('charts' => $::form->{ALL_CHARTS});
 
   my $title      = $::form->{title};


@@ -890,10 +873,6 @@ sub form_header {
   map { $::form->{$_} =~ s/\"/&quot;/g }
     qw(chart taxchart);
 
   map { $::form->{$_} =~ s/\"/&quot;/g }
     qw(chart taxchart);
 

-  $::form->{selectdepartment} =~ s/ selected//;
-  $::form->{selectdepartment} =~
-    s/option>\Q$::form->{department}\E/option selected>$::form->{department}/;
-

   if ($init) {
     $::request->{layout}->focus("#reference");
     $::form->{taxincluded} = "1";
   if ($init) {
     $::request->{layout}->focus("#reference");
     $::form->{taxincluded} = "1";


@@ -1172,7 +1151,7 @@ sub post {
   my $form     = $main::form;
   my $locale   = $main::locale;
 
   my $form     = $main::form;
   my $locale   = $main::locale;
 

-  if ($::myconfig{mandatory_departments} && !$form->{department}) {
+  if ($::myconfig{mandatory_departments} && !$form->{department_id}) {

     $form->{saved_message} = $::locale->text('You have to specify a department.');
     update();
     exit;
     $form->{saved_message} = $::locale->text('You have to specify a department.');
     update();
     exit;

diff --git a/templates/webpages/gl/form_header.html b/templates/webpages/gl/form_header.html
index ec74206fdd7f825be93e36f265c9bbc7137d04d5..748ff1b324ac8d98c010a0e9a6398b52795b82b9 100644 (file)
--- a/templates/webpages/gl/form_header.html
+++ b/templates/webpages/gl/form_header.html
@@ -99,11 +99,10 @@ function updateTaxes(row)
         </tr>
 [%- END %]
 
         </tr>
 [%- END %]
 

-[%- IF selectdepartment %]
+[%- IF ALL_DEPARTMENTS %]

         <tr>
           <th align=right nowrap>[% 'Department' | $T8 %]</th>
         <tr>
           <th align=right nowrap>[% 'Department' | $T8 %]</th>

-          <td colspan=3><select name=department>[% selectdepartment %]</select></td>
-          <input type=hidden name=selectdepartment value="[% selectdepartment | html %]">
+          <td>[% L.select_tag('department_id', ALL_DEPARTMENTS, default = department_id, title_key = 'description', with_empty = 1) %]</td>

         </tr>
 [%- END %]
 
         </tr>
 [%- END %]
 

diff --git a/templates/webpages/gl/search.html b/templates/webpages/gl/search.html
index e9ec7970ceb88cf17e06ad81a42680390f6b4ad4..80a4aca431a973b44cb9e2f98d937ebf0449c9ea 100644 (file)
--- a/templates/webpages/gl/search.html
+++ b/templates/webpages/gl/search.html
@@ -18,10 +18,10 @@
           <th align=right>[% 'Source' | $T8 %]</th>
           <td><input name=source size=20></td>
         </tr>
           <th align=right>[% 'Source' | $T8 %]</th>
           <td><input name=source size=20></td>
         </tr>

-        [%- IF all_departments %]
+        [%- IF ALL_DEPARTMENTS %]

         <tr>
           <th align=right nowrap>[% 'Department' | $T8 %]</th>
         <tr>
           <th align=right nowrap>[% 'Department' | $T8 %]</th>

-          <td colspan=3>[% L.select_tag('department', all_departments, value_title_sub = \department_label, with_empty = 1) %]</td>
+          <td colspan=3>[% L.select_tag('department_id', ALL_DEPARTMENTS, title_key = 'description', with_empty = 1) %]</td>

         </tr>
         [%- END %]
         <tr>
         </tr>
         [%- END %]
         <tr>