define("PID", "/var/run/a2billing/a2billing_subscription_fee_pid.php");
}
// CHECK IF THE CRONT PROCESS IS ALREADY RUNNING
$pH = new ProcessHandler();
if ($pH->isActive()) {
die;
// Already running!
} else {
$pH->activate();
}
$verbose_level = 1;
$groupcard = 5000;
$A2B = new A2Billing();
$A2B->load_conf($agi, NULL, 0, $idconfig);
write_log(LOGFILE_CRONT_SUBSCRIPTIONFEE, basename(__FILE__) . ' line:' . __LINE__ . "[#### BATCH BEGIN ####]");
if (!$A2B->DbConnect()) {
echo "[Cannot connect to the database]\n";
write_log(LOGFILE_CRONT_SUBSCRIPTIONFEE, basename(__FILE__) . ' line:' . __LINE__ . "[Cannot connect to the database]");
exit;
}
$instance_table = new Table();
/*
Pay_Status :
0 : First USE
1 : Billed
2 : Paid
3 : UnPaid
*/
$QUERY = 'SELECT count(*) FROM cc_card INNER JOIN cc_card_subscription ON cc_card.id = cc_card_subscription.id_cc_card INNER JOIN cc_subscription_service ON cc_card_subscription.id_subscription_fee=cc_subscription_service.id' . ' WHERE cc_subscription_service.status=1 AND cc_card_subscription.startdate < NOW() AND (cc_card_subscription.stopdate = "0000-00-00 00:00:00" OR cc_card_subscription.stopdate > NOW())' . ' AND cc_subscription_service.startdate < NOW() AND (cc_subscription_service.stopdate = "0000-00-00 00:00:00" OR cc_subscription_service.stopdate > NOW()) AND cc_card_subscription.paid_status !=3';
$result = $instance_table->SQLExec($A2B->DBHandle, $QUERY);
$nb_card = $result[0][0];
$A2B = new A2Billing();
$A2B->load_conf($agi);
if (!defined('PID'))
define("PID", $A2B->config["daemon-info"]['pidfile']);
// CHECK IF THE DAEMON IS ALREADY RUNNING
if (ProcessHandler :: isActive())
die("Already running!");
else
ProcessHandler :: activate();
write_log(LOGFILE_API_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[#### CALLBACK BEGIN ####]");
if (!$A2B->DbConnect()) {
echo "[Cannot connect to the database]\n";
write_log(LOGFILE_API_CALLBACK, basename(__FILE__) . ' line:' . __LINE__ . "[Cannot connect to the database]");
exit;
}
if ($A2B->config["database"]['dbtype'] == "postgres")
$UNIX_TIMESTAMP = "date_part('epoch',";
else
$UNIX_TIMESTAMP = "UNIX_TIMESTAMP(";
$instance_table = new Table();
$A2B -> set_instance_table ($instance_table);
while(true)
{
