function InvoicePaid($args)
{
$class = new AktuelSms();
$template = $class->getTemplateDetails(__FUNCTION__);
if ($template['active'] == 0) {
return null;
}
$settings = $class->getSettings();
if (!$settings['api'] || !$settings['apiparams'] || !$settings['gsmnumberfield'] || !$settings['wantsmsfield']) {
return null;
}
$userSql = "\n SELECT a.duedate,b.id as userid,b.firstname,b.lastname,`c`.`value` as `gsmnumber` FROM `tblinvoices` as `a`\n JOIN tblclients as b ON b.id = a.userid\n JOIN `tblcustomfieldsvalues` as `c` ON `c`.`relid` = `a`.`userid`\n JOIN `tblcustomfieldsvalues` as `d` ON `d`.`relid` = `a`.`userid`\n WHERE a.id = '" . $args['invoiceid'] . "'\n AND `c`.`fieldid` = '" . $settings['gsmnumberfield'] . "'\n AND `d`.`fieldid` = '" . $settings['wantsmsfield'] . "'\n AND `d`.`value` = 'on'\n LIMIT 1\n ";
$result = mysql_query($userSql);
$num_rows = mysql_num_rows($result);
if ($num_rows == 1) {
$UserInformation = mysql_fetch_assoc($result);
$template['variables'] = str_replace(" ", "", $template['variables']);
$replacefrom = explode(",", $template['variables']);
$replaceto = array($UserInformation['firstname'], $UserInformation['lastname'], $class->changeDateFormat($UserInformation['duedate']));
$message = str_replace($replacefrom, $replaceto, $template['template']);
$class->setGsmnumber($UserInformation['gsmnumber']);
$class->setMessage($message);
$class->setUserid($UserInformation['userid']);
$class->send();
}
}
