----- Original Message -----
Sent: Friday, June 04, 2004 10:30
AM
Subject: [Rodopi] No 'On Hold Late' on
weekends
Looks like
someone's not paying attention to what thread they are responding to
:) Then again, maybe it was my fault for responding to one and starting
a new thread at virtually the same time. :)
By the way, not
that we need another change of subject, but does anyone know why my messages
took so long to be distributed to the list. I sent both messages
yesterday just before 2PM local time (CDT) and they didn't arrive in my
mailbox until just before 10AM this morning (which actually was 20 minutes
AFTER Cary's reply).
Scott
Cary,
By doing it on a radius profile it
in effect removes Rodopi from the picture. What happens is that when the user
dials in during a blackout time the user will be rejected, similarly as a
simultanius login attempt (which is handled by radius not Rodopi). It doesn't
actually suspend the account and thus no accounting issues a dependency on
Rodopi to do billing correctly and on time. I haven't had a chance to actually
test it and am not sure if it is the proper syntax (but looks good to me). In
my case the user wants the account dissabled while they are at work so the
kids can't get online and do what kids do. Not sure if they want it on weekend
or not. hehe the power at my fingure tips. Guess I had better make a
call.
Paul
Cary Fitch wrote:
I don't do this type of programming. BUT,
from other experience, I assume it will block the SAT/Sun effects
but,
Will it then actually do the suspend on
Monday?
Also you may have to Block FRI/SAT not SAT/SUN
because the proceedure runs at midnight,not "in the day" and it may need to
be defeated then.
$0.02
Of course the proof of the pudding is in the
eating!
Cary Fitch
-----
Original Message -----
Sent:
Thursday, June 03, 2004 1:49 PM
Subject:
[Rodopi] No 'On Hold Late' on weekends
We use Rodopi 5.2 sp3 and I
have been passed the request to NOT put customers on hold for late
payment on the weekends when our accounting staff is not available.
I believe I have found the stored procedure that puts the accounts on hold
but I wanted to check with some of you Rodopi and SQL gurus to be
sure I'm looking in the right place, as well as make sure this should work
and not cause any additional problems. Below are the first dozen or
so lines of the SP along with my simple edit. If I am correct, this
should prevent the procedure from running on Saturday and Sunday and if I
am reading the procedure correctly, any users who would have went on hold
over the weekend will be found and put on hold when the procedure runs on
Monday. Anyone see any errors in my thinking?
CREATE Procedure
Maint_OnHoldLateSuspend
@CustomerID int = NULL,
@Proc int = 0 output
As
set nocount on
if datename(dw,
getdate()) IN ('Saturday',
'Sunday')
return
0
select @Proc= 0
declare @DateLateSuspCC
smalldatetime,
@DateLateSuspCheck
smalldatetime,
@DateLateSuspACH
smalldatetime,
@DateLateSuspCorpCheck
smalldatetime,
@BillingDate
smalldatetime
