asterisk2billing.org
http://forum.asterisk2billing.org/

Expire Notify Alert mail
http://forum.asterisk2billing.org/viewtopic.php?f=18&t=11862		 Page 1 of 1
Author:  clsinc [ Thu Oct 22, 2015 12:24 pm ]
Post subject:  Expire Notify Alert mail
Hi !I am a2billing Beginner user .
I'm looking for a script that mail is sent when a customer of use has expired . :?:

It is only those that you use the mail template , please let us know something hint .
Nice to meet you.
Author:  jroper [ Fri Oct 23, 2015 8:33 am ]
Post subject:  Re: Expire Notify Alert mail
Hi

The card is only set to expired and inactive if a call is attempted, there is no cronjob to check expired cards.

To do this, you would have to write some SQL in a script to check whether a card was expired and send an email.

Joe
Author:  clsinc [ Fri Oct 23, 2015 9:57 am ]
Post subject:  Re: Expire Notify Alert mail
Joe Thank you .

If there is also something sample script An attempt was made to reference .
Please introduce If there be a simple shell script .
Author:  Rabon [ Sat Oct 24, 2015 4:11 pm ]
Post subject:  Re: Expire Notify Alert mail
hi,

you will find autorefill script under cronjobs folder in a2billing. you can EDIT that script to match with your requirements.
Author:  clsinc [ Sun Oct 25, 2015 2:37 am ]
Post subject:  Re: Expire Notify Alert mail
Hi Joe

I'm Try ! Thanks
Author:  clsinc [ Sun Oct 25, 2015 3:03 am ]
Post subject:  Re: Expire Notify Alert mail
Oh! Sorry


Jroper and Rabon Thanks!!
Author:  clsinc [ Sat Oct 31, 2015 10:40 am ]
Post subject:  Re: Expire Notify Alert mail
It is a recent result .
We were set as follows .

/var/spool/cron/root

10 * * * * php /usr/local/src/a2billing/Cronjobs/a2billing_alarm2.php > /dev/null 2>&1

a2billing_alarm2.php

****************************************************************************/
include (dirname(__FILE__) . "/lib/admin.defines.php");
include (dirname(__FILE__) . "/lib/ProcessHandler.php");


// expirationdate >= '".date('Y-m-d H:00:00',strtotime("-1 hour"))." AND expirationdate <= '".date('Y-m-d H:59:59',strtotime("-1 hour"))."
//
// db setting
------

$verbose_level=1;
$QUERY = "SELECT * FROM cc_card WHERE `status` = '5' AND enableexpire = '1' AND expirationdate >= '".date('Y-m-d H:00:00',strtotime("-1 hour"))."' AND expirationdate <= '".date('Y-m-d H:59:59',strtotime("-1 hour"))."'";
//$QUERY = "SELECT * FROM cc_card WHERE id = '2'";
$RESULT = mysql_query($QUERY,$conn) or die(mysql_error());
while($row=mysql_fetch_array($RESULT)){

// SEND REPORT
if ($row) {
$mail_subject = "A2BILLING ALARM : ACCOUNT EXPIRED";

// $mail_content = "ALARM NAME = " . $myalarm[1];
$mail_content="Dear Customer <br>You Account(".$row['username'].")expirationdate(".$row['expirationdate'].")";

try {
// Hostname <myserver-email-address>

$mail = new Mail(null, null, null, $mail_content, $mail_subject);
$mail -> send($row['email']);
// $mail -> send('emailaddress');
} catch (A2bMailException $e) {
if ($verbose_level >= 1)
echo "[Sent mail failed : $e]";
write_log(LOGFILE_CRONT_ALARM, basename(__FILE__) . ' line:' . __LINE__ . "[Sent mail failed : $e]");
}
}
}
if ($verbose_level >= 1)
echo "#### END ALARMS \n";
write_log(LOGFILE_CRONT_ALARM, basename(__FILE__) . ' line:' . __LINE__ . "[#### ALARM END ####]");
Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/