本帖最后由 shary 于 2015-9-23 16:55 编辑
需求:1、每月25号查询“用户”有没更新项目实施进度,没有则发短信提醒。
2、项目实施进度表单有两种:a:现代渔业 b:水产种苗
代码:
var user = new Packages.cn.myapps.core.user.action.WebUser(null);
user.setTelephone("13531748447");
user.setDomainid("11e4-7645-9ee890d4-ad72-ad9dc4d62436");//前台用户对应的企业域ID
user.setDefaultApplication("11e4-76c2-cfe5e3ad-a3d1-e533969f718f");//当前应用ID
var sender = $MESSAGE.getSMSManager().getSender(user);
var time = getCurDate("yyyy-MM");
var process = getDocProcess($WEB.getApplication());
//现代渔业
var sql = "select * from tlk_现代渔业示合同填报 where STATELABEL like '%结束%' and isnull(ITEM_实施进度百分比,'')!='100%' and isnull(ITEM_实施进度更新时间,'')<'"+time+"' ";
println("=="+sql);
var data = process.queryBySQL(sql, $WEB.getDomainid());
println("打印查询结果集:"+data);
if(data!=null){
for(var it=data.iterator();it.hasNext();){
println("=111=");
var doc = it.next();
var docid=doc.getId();
var title="实施进度更新提醒 ";
var content="项目名称:"+doc.getItemValueAsString("项目名称")+" 请在本月结束前提交本月的实施进度情况";
var telephone=doc.getItemValueAsString("负责人电话");
sender.send(docid, title, content, telephone, false, false);
}
}
//水产种苗
var sql1 = "select * from tlk_水产种苗合同填报 where STATELABEL like '%结束%' and isnull(ITEM_实施进度百分比,'')!='100%' and isnull(ITEM_实施进度更新时间,'')<'"+time+"' ";
var data1 = process.queryBySQL(sql1, $WEB.getDomainid());
println("=="+sql1);
if(data1!=null){
for(var it1=data1.iterator();it1.hasNext();){
println("=222=");
var doc = it1.next();
var docid=doc.getId();
var title="实施进度更新提醒 ";
var content="项目名称:"+doc.getItemValueAsString("项目名称")+" 请在本月结束前提交本月的实施进度情况";
var telephone=doc.getItemValueAsString("负责人电话");
sender.send(docid, title, content, telephone, false, false);
}
}
异常:
11:06:40,615 INFO Task:569 - ************ Execute Start *************
11:06:40,616 INFO PrintJsUtil:27 - JsUtil:==select * from tlk_现代渔业示合同填报 where STATELABEL like '%结束%' and isnull(ITEM_实施进度百分比,'')!='100%' and isnull(ITEM_实施进度更新时间,'')<'2015-03'
11:06:40,618 DEBUG AbstractDocStaticTblDAO:2132 - MS SQL Server: SELECT * FROM (SELECT * FROM TLK_现代渔业示合同填报 WHERE STATELABEL LIKE '%结束%' AND ISNULL(ITEM_实施进度百分比,'')!='100%' AND ISNULL(ITEM_实施进度更新时间,'')<'2015-03' ) table_0 WHERE table_0.DOMAINID ='null'
11:06:40,621 INFO PrintJsUtil:27 - JsUtil:打印查询结果集:cn.myapps.base.dao.DataPackage@dff9c6
11:06:40,623 WARN Task:585 - Run TaskScript Error: JavaScriptRunning:[TASK(11e4-c14c-95797ebd-be32-130af91a6f0a).实施进度提醒任务.TaskScript]: TypeError: Cannot find function iterator. (11e4-c14c-95797ebd-be32-130af91a6f0a).实施进度提醒任务.TaskScript#15) |