sub get_openbalance_date {
my ($closedto, $target) = map { $::locale->parse_date_to_object(\%::myconfig, $_) } @_;
+ return unless $closedto;
+
$closedto->subtract(years => 1) while ($target - $closedto)->is_negative;
$closedto->add(days => 1);
return $::locale->format_date(\%::myconfig, $closedto);
}
} else { # if ($form->{method} eq 'cash')
- # ich sehe keinen sinn das nochmal explizit ohne conv_i aufzurufen
- # bitte prüfen und löschen jan 15.11.2009
- # if ($department_id) {
- # $dpt_join = qq| JOIN dpt_trans t ON (t.trans_id = ac.trans_id) |;
- # $dpt_where = qq| AND t.department_id = $department_id |;
- # }
+ if ($department_id) {
+ $dpt_join = qq| JOIN dpt_trans t ON (t.trans_id = ac.trans_id) |;
+ $dpt_where = qq| AND t.department_id = | . conv_i($department_id);
+ }
$query = qq|
SELECT c.accno, sum(ac.amount) AS amount, c.description, c.category
}
} else { # if ($form->{method} eq 'cash')
- # s.o. jan 15.11.2009
-# if ($department_id) {
-# ($dpt_join, $dpt_where) = sql_department($department_id);
-# }
+ if ($department_id) {
+ $dpt_join = qq| JOIN dpt_trans t ON (t.trans_id = ac.trans_id) |;
+ $dpt_where = qq| AND (t.department_id = | . conv_i($department_id, 'NULL') . qq|) |;
+ }
$query = qq|
SELECT sum(ac.amount * chart_category_to_sgn(c.category)) AS amount, c.$category