Re: billing system
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52801
interpreted = N
texte = I noticed this is what Rob said but i offered a little code :) ----- Original Message ----- From: "WebDna @"
To: "WebDNA Talk" Sent: Thursday, September 11, 2003 3:09 PM Subject: Re: billing system > It seems to me that all you need to do is take the number of days in the > month and compare it to the billing day of the account. > > [!]How many days are in the month -- seems to work for leap year[/!] > [math > show=f]num_of_days=({[the_month]/1/[the_year]}+{1/0/0000})-{[the_month]/1/[t > he_year]}[/math] > > Now either store the day they are billed on or strip it out some how. (for > this example we will use 31st) > > [math show=f]billday=31[/math] > > [if (([billday]>[num_of_days]) & ([num_of_days]=[date %d]))] > [then] > bill now > [/then] > [else] > normal billing cycle > [/else] > [/if] > > The above should look and see 28 days in feb (29 in those leap years) and > the 30th in those months that only have 30. > > You would need to tell the client that they are being billed once a month, > not on the same day every month. > > RonnyMc > > > > > > > ----- Original Message ----- > From: "Kalin Mintchev" > To: "WebDNA Talk" > Sent: Thursday, September 11, 2003 2:00 PM > Subject: Re: billing system > > > > > > i think we offered them a formula that whoever subscribes after 28 if any > > given month his/hers next date bill will be on the the 1st day of the > > month after the next.... > > > > for ex if i subscribe on 01.30 i get my next bill on 03.01, then 04.01 > > etc... they are considering that. > > > > of cource the issue is if i subscribe on 02.28 and i get the bill on 04.01 > > i get 03.28 - 04.01 for free but they might go for it... > > > > how's that sounding... > > > > On Thu, 11 Sep 2003, Donovan wrote: > > > > > Eh, what am I thinking... I already did this a while back > > > with leasing out Banner space. > > > > > > > > > I did this by comparing (Tom's) "Date-in-seconds-since-epoch". > > > > > > Here is the test page I did at the time: > > > > > > http://www.euca.us/admin/tests/sectodays.html > > > > > > Donovan > > > > > > > > > > > > > > > Donovan wrote: > > > > What about a simple database with the number of days in > > > > each month. You could also easily check for leap year. > > > > > > > > Donovan > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------- > > This message is sent to you because you are subscribed to > > the mailing list . > > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to > > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I noticed this is what Rob said but i offered a little code :) ----- Original Message ----- From: "WebDna @" To: "WebDNA Talk" Sent: Thursday, September 11, 2003 3:09 PM Subject: Re: billing system > It seems to me that all you need to do is take the number of days in the > month and compare it to the billing day of the account. > > [!]How many days are in the month -- seems to work for leap year[/!] > [math > show=f]num_of_days=({[the_month]/1/[the_year]}+{1/0/0000})-{[the_month]/1/[t > he_year]}[/math] > > Now either store the day they are billed on or strip it out some how. (for > this example we will use 31st) > > [math show=f]billday=31[/math] > > [if (([billday]>[num_of_days]) & ([num_of_days]=[date %d]))] > [then] > bill now > [/then] > [else] > normal billing cycle > [/else] > [/if] > > The above should look and see 28 days in feb (29 in those leap years) and > the 30th in those months that only have 30. > > You would need to tell the client that they are being billed once a month, > not on the same day every month. > > RonnyMc > > > > > > > ----- Original Message ----- > From: "Kalin Mintchev" > To: "WebDNA Talk" > Sent: Thursday, September 11, 2003 2:00 PM > Subject: Re: billing system > > > > > > i think we offered them a formula that whoever subscribes after 28 if any > > given month his/hers next date bill will be on the the 1st day of the > > month after the next.... > > > > for ex if i subscribe on 01.30 i get my next bill on 03.01, then 04.01 > > etc... they are considering that. > > > > of cource the issue is if i subscribe on 02.28 and i get the bill on 04.01 > > i get 03.28 - 04.01 for free but they might go for it... > > > > how's that sounding... > > > > On Thu, 11 Sep 2003, Donovan wrote: > > > > > Eh, what am I thinking... I already did this a while back > > > with leasing out Banner space. > > > > > > > > > I did this by comparing (Tom's) "Date-in-seconds-since-epoch". > > > > > > Here is the test page I did at the time: > > > > > > http://www.euca.us/admin/tests/sectodays.html > > > > > > Donovan > > > > > > > > > > > > > > > Donovan wrote: > > > > What about a simple database with the number of days in > > > > each month. You could also easily check for leap year. > > > > > > > > Donovan > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------- > > This message is sent to you because you are subscribed to > > the mailing list . > > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to > > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"WebDna @"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Date Time Oddness (1999)
How Many SKU's is enough? (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Variables from a long text string (2000)
Converting Esiting Html Table Forms to WebCat (1997)
Emailer errors (1997)
showcart context? (1998)
Stumpted Again (1997)
WebCat2b15MacPlugin - showing [math] (1997)
HideIf ip= OR ip= (1998)
WebCat2b12 - nesting [tags] (1997)
CAPTCHA (2006)
All choices on IE different than Netscape (1997)
Setting up shop (1997)
WebCommerce: Folder organization ? (1997)
Re[2]: Problem with new formvariables (2000)
Webcat causing crashes left and right! (1997)
[WebDNA] return missing db number (2010)
Include (1998)
Stumpted Again (1997)