projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Warnung unterdrücken die den Test fehlschlagen lässt.
[kivitendo-erp.git]
/
SL
/
PE.pm
diff --git
a/SL/PE.pm
b/SL/PE.pm
index
31a8bd5
..
28f3ba5
100644
(file)
--- a/
SL/PE.pm
+++ b/
SL/PE.pm
@@
-96,7
+96,7
@@
sub save_partsgroup {
if ($form->{id}) {
$query = qq|UPDATE partsgroup SET partsgroup = ? WHERE id = ?|;
if ($form->{id}) {
$query = qq|UPDATE partsgroup SET partsgroup = ? WHERE id = ?|;
-
push(@values, $form->{id});
+ push(@values, $form->{id});
} else {
$query = qq|INSERT INTO partsgroup (partsgroup) VALUES (?)|;
}
} else {
$query = qq|INSERT INTO partsgroup (partsgroup) VALUES (?)|;
}
@@
-172,7
+172,7
@@
sub pricegroups {
my $first = 1;
$where .= qq| AND id NOT IN (|;
my $first = 1;
$where .= qq| AND id NOT IN (|;
- foreach my $table (qw(invoice orderitems prices
rmaitems
)) {
+ foreach my $table (qw(invoice orderitems prices)) {
$where .= "UNION " unless ($first);
$first = 0;
$where .=
$where .= "UNION " unless ($first);
$first = 0;
$where .=
@@
-219,7
+219,7
@@
sub save_pricegroup {
if ($form->{id}) {
$query = qq|UPDATE pricegroup SET pricegroup = ? WHERE id = ? |;
if ($form->{id}) {
$query = qq|UPDATE pricegroup SET pricegroup = ? WHERE id = ? |;
-
push(@values, $form->{id});
+ push(@values, $form->{id});
} else {
$query = qq|INSERT INTO pricegroup (pricegroup) VALUES (?)|;
}
} else {
$query = qq|INSERT INTO pricegroup (pricegroup) VALUES (?)|;
}
@@
-253,7
+253,7
@@
sub get_pricegroup {
my @values = ();
$query = qq|SELECT |;
my @values = ();
$query = qq|SELECT |;
- foreach my $table (qw(invoice orderitems prices
rmaitems
)) {
+ foreach my $table (qw(invoice orderitems prices)) {
$query .= " + " unless ($first);
$first = 0;
$query .= qq|(SELECT COUNT(*) FROM $table WHERE pricegroup_id = ?) |;
$query .= " + " unless ($first);
$first = 0;
$query .= qq|(SELECT COUNT(*) FROM $table WHERE pricegroup_id = ?) |;