function sendSms()
{
include 'save_excel_2.php';
include '../../gammu/send_sms.php';
$SendSms = new SendSms();
$dbConn = new clsDBConnSIKP();
$query = "SELECT * FROM t_sms_outbox where is_sent = 'N'";
$dbConn->query($query);
$data = array();
while ($dbConn->next_record()) {
$data[] = $item = array('t_sms_outbox_id' => $dbConn->f("t_sms_outbox_id"), 'npwpd' => $dbConn->f("npwpd"), 'mobile_no' => $dbConn->f("mobile_no"), 'message' => $dbConn->f("message"), 'is_sent' => $dbConn->f("is_sent"), 'date_sent' => $dbConn->f("date_sent"), 'date_addded' => $dbConn->f("date_addded"));
$SendSms->send($item["mobile_no"], $item["message"]);
}
for ($counter = 0; $counter < sizeof($data); $counter++) {
$query = " UPDATE t_sms_outbox\r\n\t \t\tSET is_sent='Y',date_sent=sysdate\r\n\t \t\tWHERE t_sms_outbox_id=" . $data[$counter]['t_sms_outbox_id'];
$dbConn->query($query);
}
}
/**
* Send verify code to user's cellphone.
*【注册验证】验证码.484933.，您正在注册成为探庐者用户，感谢您的支持！
* @param String/int $phone 手机号
* @param String/int $verify_code 后台生成的验证码
* @return success/fail
*/
public function sendVerifyCode($phone, $verify_code)
{
$pro = new PropertyManager();
$c = new SmsServer();
$c->appkey = $pro->getProperty('sms_key');
$c->secretKey = $pro->getProperty('sms_secret');
$req = new SendSms();
$req->setExtend("1010");
$req->setSmsType("normal");
$req->setSmsFreeSignName("注册验证");
$req->setSmsParam("{\"code\":\"{$verify_code}\",\"product\":\"探庐者\"}");
$req->setRecNum($phone);
$req->setSmsTemplateCode("SMS_5400651");
$resp = $c->execute($req);
if ($resp->result->err_code == '0') {
return true;
} else {
echo $resText;
return false;
}
}