diff options
| -rw-r--r-- | FS/bin/freeside-torrus-srvderive | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/FS/bin/freeside-torrus-srvderive b/FS/bin/freeside-torrus-srvderive index 895cc24b8..50dcb9238 100644 --- a/FS/bin/freeside-torrus-srvderive +++ b/FS/bin/freeside-torrus-srvderive @@ -39,11 +39,14 @@ my $other_date = concat_sql([ 'other.srv_date', "' '", 'other.srv_time' ]); $other_date = "CAST( $other_date AS TIMESTAMP )" if driver_name =~ /^Pg/i; $other_date = str2time_sql. $other_date. str2time_sql_closing; +my $in = concat_sql([ '?', "'_IN'" ) +my $out = concat_sql([ '?', "'_OUT'" ) + my $sql = " SELECT DISTINCT srv_date, srv_time FROM srvexport WHERE NOT EXISTS ( SELECT 1 FROM srvexport AS other - WHERE other.serviceid IN ( ?||'_IN', ?||'_OUT') + WHERE other.serviceid IN ( $in, $out ) AND ABS( $_date - $other_date ) <= 60 ) ORDER BY id |