projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Vars in is::invoice_links besser sichern.
[kivitendo-erp.git]
/
SL
/
RC.pm
diff --git
a/SL/RC.pm
b/SL/RC.pm
index
3c91195
..
9493f0f
100644
(file)
--- a/
SL/RC.pm
+++ b/
SL/RC.pm
@@
-36,6
+36,8
@@
package RC;
use SL::DBUtils;
use SL::DBUtils;
+use strict;
+
sub paymentaccounts {
$main::lxdebug->enter_sub();
sub paymentaccounts {
$main::lxdebug->enter_sub();
@@
-74,7
+76,7
@@
sub payment_transactions {
qq| WHERE c2.accno = ?) AS category | .
qq|FROM acc_trans a | .
qq|JOIN chart c ON (c.id = a.chart_id) | .
qq| WHERE c2.accno = ?) AS category | .
qq|FROM acc_trans a | .
qq|JOIN chart c ON (c.id = a.chart_id) | .
- qq|WHERE a.transdate <
date
? AND a.cleared = '1' AND c.accno = ?|;
+ qq|WHERE a.transdate < ? AND a.cleared = '1' AND c.accno = ?|;
@values = ($form->{accno}, conv_date($form->{fromdate}), $form->{accno});
} else {
@values = ($form->{accno}, conv_date($form->{fromdate}), $form->{accno});
} else {
@@
-91,7
+93,7
@@
sub payment_transactions {
($form->{beginningbalance}, $form->{category}) =
selectrow_query($form, $dbh, $query, @values);
($form->{beginningbalance}, $form->{category}) =
selectrow_query($form, $dbh, $query, @values);
- my %oid = ('Pg' => 'ac.
o
id',
+ my %oid = ('Pg' => 'ac.
acc_trans_
id',
'Oracle' => 'ac.rowid');
@values = ();
$query =
'Oracle' => 'ac.rowid');
@values = ();
$query =
@@
-184,7
+186,7
@@
sub reconcile {
my $dbh = $form->dbconnect($myconfig);
my ($query, $i);
my $dbh = $form->dbconnect($myconfig);
my ($query, $i);
- my %oid = ('Pg' => '
o
id',
+ my %oid = ('Pg' => '
acc_trans_
id',
'Oracle' => 'rowid');
# clear flags
'Oracle' => 'rowid');
# clear flags