projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
SQL-Upgrade korrekter Name und kivi-version
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
erzeugnisnummern.pl
diff --git
a/sql/Pg-upgrade2/erzeugnisnummern.pl
b/sql/Pg-upgrade2/erzeugnisnummern.pl
index
bd8eb1c
..
8468e69
100644
(file)
--- a/
sql/Pg-upgrade2/erzeugnisnummern.pl
+++ b/
sql/Pg-upgrade2/erzeugnisnummern.pl
@@
-79,16
+79,15
@@
sub filter_parts {
}
if ($::form->{filter_type} eq 'assembly') {
}
if ($::form->{filter_type} eq 'assembly') {
- $where .=
' AND assembly'
;
+ $where .=
" AND part_type = 'assembly'"
;
}
if ($::form->{filter_type} eq 'service') {
}
if ($::form->{filter_type} eq 'service') {
- $where .=
' AND inventory_accno_id IS NULL AND NOT assembly'
;
+ $where .=
" AND part_type = 'service'"
;
}
if ($::form->{filter_type} eq 'part') {
}
if ($::form->{filter_type} eq 'part') {
- $where .= ' AND inventory_accno_id IS NOT NULL';
- $where .= ' AND NOT assembly';
+ $where .= " AND part_type = 'part'";
}
if ($::form->{filter_obsolete} eq 'obsolete') {
}
if ($::form->{filter_obsolete} eq 'obsolete') {