topic Re: How can I get next billing date in ARB subscription? in Integration and Testing

How can I get next billing date in ARB subscription?

subhash — Fri, 14 May 2010 06:21:48 GMT

Hi,

I am using ARB Authorized.net subscription. my subscription start_date is 01 Jan,2010. I know that ARB will automatically bill my amount on date 01 of every month. But for some reason i need to get my next billing date. For example : I have to update my subscription today (14 May,2010) and I want to get my next billing date (which is 01 June,2010) from authorized.net. Can I get it from authorized.net or I have to get it manually from my site ?

Thanx

Subhash.

Re: How can I get next billing date in ARB subscription?

stymiee — Fri, 14 May 2010 12:17:25 GMT

You can't get it from Authnet but you don't need to. If you know the next billing date is the first of every month you can easily figure it out programmatically.

Re: How can I get next billing date in ARB subscription?

syoung68 — Thu, 11 Aug 2011 16:12:55 GMT

what happens if you bill date is late in the month e.g July 31? WHat happens in Sept (only goes to 30)

Re: How can I get next billing date in ARB subscription?

TJPride — Thu, 11 Aug 2011 21:30:32 GMT

Have your database store the next billing date and then increment it by one month when the callback says a payment came in.

Re: How can I get next billing date in ARB subscription?

syoung68 — Fri, 12 Aug 2011 02:55:42 GMT

I understand that, but does anyone know what the policy is from Authorize.net. If the subscription starts on Jan. 30 what happens in Feb? Does it get charged on March 2?

Re: How can I get next billing date in ARB subscription?

TJPride — Fri, 12 Aug 2011 11:44:14 GMT

I'd be interested in finding that out as well. My client just has all subscriptions start on the first of the next month, that way there's no confusion.

Re: How can I get next billing date in ARB subscription?

abernh — Fri, 12 Aug 2011 12:35:57 GMT

If I understand correctly the "next billing date" for a "monthly" period is always calculated by adding the days of the current month to the latest billing date.

e.g.

1. 15.Jan

2. +31days = 15.Feb

3. +28/29days = 15.Mar

...

So a monthly billing happens always on the "X.th" of a month.

for February there will always be a little hickup

e.g.

1. 31.Jan (last of month)

2. +31days = 2./3.Mar (the hickup)

3. +28 days = 31.Mar (last of month)

...

Re: How can I get next billing date in ARB subscription?

TJPride — Fri, 12 Aug 2011 13:55:53 GMT

You could always use CIM and just program the billing yourself - that way you have more control over when the billing happens and can set it up any way you prefer.

Re: How can I get next billing date in ARB subscription?

Michelle — Mon, 15 Aug 2011 19:33:35 GMT

Hey guys,

If you set up a subscription to bill on daysthat don't exist in other months, like the 31st, then in those months without 31 days, the payment will run on the last day of the month, whatever that may be. So for instance, if you regularly bill on the 30th, then in February, the bill would run on the 28th.

Thanks,

Michelle
Developer Community Manager

Re: How can I get next billing date in ARB subscription?

TJPride — Fri, 12 Aug 2011 21:10:41 GMT

That makes good logical sense, thanks.

Re: How can I get next billing date in ARB subscription?

syoung68 — Mon, 15 Aug 2011 16:06:51 GMT

Thank you so much. That make sense.

Re: How can I get next billing date in ARB subscription?

syoung68 — Mon, 15 Aug 2011 21:40:34 GMT

I realize that this is not a PHP forum, but I am looking for suggestions. I can calculate the last day of next month based on the current date so if today is 01/31 I can get 02/28, but I am not sure how to approach this if I am only storing the ARB start date. e.g. Start date = 01/31 and now it is 04/02 and I want to display the next bill date.

Any thoughts?

Re: How can I get next billing date in ARB subscription?

TJPride — Tue, 16 Aug 2011 00:05:17 GMT

Depends. If you know it's 2011-04-02, then all you have to do is calculate how many days there are in the current month and then put that number in place of the 2, and to do that just requires knowing how many days each month has and how to calculate whether February has 28 or 29 days. Fairly simple. If you don't know it's 2011-04-02, you can use the date function to give you that information.

If your subscription started on the 27th, of course, you don't need to even bother with all of that - it's always going to be the 27th.

Re: How can I get next billing date in ARB subscription?

syoung68 — Tue, 16 Aug 2011 14:18:43 GMT

I think I have it for anyone else who is interested. Any thoughts and/or improvements are appreciated.

/**
 * Function to calculate the same day one month in the future.
 *
 * This is necessary because some months don't have 29, 30, or 31 days.
 * If thenext month doesn't have as many days as this month, the 
 * anniversary will be moved up to the last day of the next month.
 *
 * @param $start_date
 *    Function assumes that date is pulled from MySql YYYY-MM-DD
 *
 * @return $nextBillDate
 *    Formmated in common US date format MM/DD/YYYY
 */

function getNextBillDate($start_date) {

   $date_array = explode("-",$start_date); // split the array

   $year = $date_array[0];
   $month = $date_array[1];
   $day = $date_array[2];

   if (date("d")  $day) {
      $billDay = $day;
   }else{
      $billDay = $billMonthDays;
   }

   $nextBillDate = $billMonth . "/" . $billDay . "/" . date("Y");

   return $nextBillDate;
}

Re: How can I get next billing date in ARB subscription?

TJPride — Tue, 16 Aug 2011 14:55:07 GMT

Well, you're getting a bit closer, but there seem to be some errors and no explanation of where $billMonthDays is coming from.

Re: How can I get next billing date in ARB subscription?

syoung68 — Tue, 16 Aug 2011 15:05:43 GMT

Sorry about that, several lines keeping getting removed when I paste and I did not notice it before...

function getNextBillDate($start_date) {

   $date_array = explode("-",$start_date); // split the array

   $year = $date_array[0];
   $month = $date_array[1];
   $day = $date_array[2];

   if (date("d") <= $day) {
      $billMonth = (int)date("m");
   }else{
      $billMonth = date("m")+1;
   }
   $billMonthDays = cal_days_in_month(CAL_GREGORIAN, ($billMonth), date("Y"));

   if ($billMonthDays > $day) {
      $billDay = $day;
   }else{
      $billDay = $billMonthDays;
   }

   $nextBillDate = $billMonth . "/" . $billDay . "/" . date("Y");

    return $nextBillDate;
}

Re: How can I get next billing date in ARB subscription?

syoung68 — Wed, 21 Sep 2011 16:08:05 GMT

Someone brought an error to my attention. The following returns an error if we are in the month of December...

$billMonth = date("m")+1;

If you are using PHP 5.3+, you can use the following...

$billMonth = date_format(date_modify(date_create(), 'first day of next month'), 'm');