projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
contacts can be shared among customers / "duplicate contact emails", RT#27943
[freeside.git]
/
FS
/
FS
/
part_event
/
Condition
/
cust_bill_has_service.pm
diff --git
a/FS/FS/part_event/Condition/cust_bill_has_service.pm
b/FS/FS/part_event/Condition/cust_bill_has_service.pm
index
61e32ce
..
898b08d
100644
(file)
--- a/
FS/FS/part_event/Condition/cust_bill_has_service.pm
+++ b/
FS/FS/part_event/Condition/cust_bill_has_service.pm
@@
-16,9
+16,6
@@
sub eventtable_hashref {
};
}
};
}
-# could not find component for path '/elements/tr-select-part_svc.html'
-# sub disabled { 1; }
-
sub option_fields {
(
'has_service' => { 'label' => 'Has service',
sub option_fields {
(
'has_service' => { 'label' => 'Has service',
@@
-44,16
+41,16
@@
sub condition {
sub condition_sql {
my( $class, $table, %opt ) = @_;
sub condition_sql {
my( $class, $table, %opt ) = @_;
- my $servicenum =
- $class->condition_sql_option_option('has_service');
+ my $servicenum
s
=
+ $class->condition_sql_option_option
_integer
('has_service');
- my $sql =
qq|
0 < ( SELECT COUNT(cs.svcpart)
+ my $sql =
"
0 < ( SELECT COUNT(cs.svcpart)
FROM cust_bill_pkg cbp, cust_svc cs
WHERE cbp.invnum = cust_bill.invnum
AND cs.pkgnum = cbp.pkgnum
FROM cust_bill_pkg cbp, cust_svc cs
WHERE cbp.invnum = cust_bill.invnum
AND cs.pkgnum = cbp.pkgnum
- AND cs.svcpart IN $servicenum
+ AND cs.svcpart IN $servicenum
s
)
)
-
|
;
+
"
;
return $sql;
}
return $sql;
}