可参考以下代码,以会员到期为例:
//通过·数据库语句查询出快过期的数据
var sql = "SELECT a.domainid,c.ITEM_PHONE, DATEDIFF(a.ITEM_DUEDATE,current_timestamp()) as item_dueday FROM tlk_associationmanagement a LEFT"
sql += " JOIN tlk_contactman c ON a.ITEM_DOMAIN_ID = c.ITEM_DOMAIN_ID where DATEDIFF(a.ITEM_DUEDATE,current_timestamp()) between 0 and 10";
var data = queryBySQL(sql);
if(data !=null && data.size()>0){
for(var it = data.iterator();it.hasNext();){
var da = it.next();
//println("usersid--------->"+da+"---------------");
var days = da.getItemValueAsDouble("dueday");
var docid = getCurrentDocument().getId();
var subject = "会员到期提醒";
var content = "你好:你的会员只剩下"+days+"天。请及时续费!!!!";
var phone = da.getItemValueAsString("Phone");
println("usersid--------->"+subject+"---------------");
println("usersid--------->"+content+"---------------");
println("usersid--------->"+phone+"---------------");
//发送信息函数
sendSMS(docid,subject,content, telephone,rtn2);
}
}
})() |