Bei Aufträgen, Angeboten, Preisanfragen das Lieferdatum mit dem nächsten Werktag...

[kivitendo-erp.git] / SL / OE.pm

diff --git a/SL/OE.pm b/SL/OE.pm
index 72c11ed3249d38f7e14d9490d98c4d81889337d2..e279e4a65f95cbc26fdbe54588a6dabd3b776afb 100644 (file)
--- a/SL/OE.pm
+++ b/SL/OE.pm
@@ -606,7 +606,12 @@ sub retrieve {
     undef @ids;
   }
 
     undef @ids;
   }
 

-  $query_add = qq|, current_date AS transdate, current_date AS reqdate| if (!$form->{id});
+  my $query_add = '';
+  if (!$form->{id}) {
+    my $wday         = (localtime(time))[6];
+    my $next_workday = $wday == 5 ? 3 : $wday == 6 ? 2 : 1;
+    $query_add       = qq|, current_date AS transdate, date(current_date + interval '${next_workday} days') AS reqdate|;
+  }

 
   # get default accounts
   $query = qq|SELECT (SELECT c.accno FROM chart c WHERE d.inventory_accno_id = c.id) AS inventory_accno,
 
   # get default accounts
   $query = qq|SELECT (SELECT c.accno FROM chart c WHERE d.inventory_accno_id = c.id) AS inventory_accno,