|
做调度任务测试时一直报错是哪里的问题,sql脚本写的没问题啊
- let AbstractTrigger = require('AbstractTrigger');
- class MyTrigger extends AbstractTrigger {
- execute(context,param){
- //获取巡检计划明细信息
-
- var sql="select t.id,t.plan_name,t.device_name,t1.inspect_date,t1.inspect_person"+
- " from AT1A74E9283F600005.AT1A74E9283F600005.plan_detail t1"+
- " left join AT1A74E9283F600005.AT1A74E9283F600005.inspect_plan t on t.id=t1.inspect_plan_id";
- var res = ObjectStore.queryByYonQL(sql);
- throw new Error(JSON.stringify(res));
- // //查询出距离巡检日期还有3天的巡检计划
- // var arr=[];
- // for (var i=0;i<res.length;i++){
- // //获取巡检日期
- // var inspectDate=res[i].inspect_date;
- // var inspectTime=Date.parse(new Date(inspectDate));
- // //获取当前系统日期
- // var nowtime=Date.parse(new Date());
- // //获取日期差小于等于3天的数据
- // if(inspectTime-nowtime>0){
- // const days=parseInt((inspectTime-nowtime)/(1000*3600*24));
- // if(15>=days){
- // res[i].days=days;
- // arr.push(res[i]);
- // }
- // }
- // }
-
- // throw new Error(JSON.stringify(arr));
- // //发送代办消息
- // for(var i=0;i<arr.length;i++){
- // var planName=arr[i].plan_name;
- // var planId=arr[i].id;
- // var inspectPerson=arr[i].inspect_person;
- // //获取域名
- // var envUrl = ObjectStore.env().url;
- // var tenantId = ObjectStore.user().tenantId;
- // //获取userId
- // let body = {id:inspectPerson};
- // let url = envUrl+"/iuap-api-gateway/yonbip/hrcloud/HRCloud/getStaffDetail"
- // let apiResponse = openLinker("POST", url, "AT1A74E9283F600005", JSON.stringify(body));
-
- // var userId=JSON.parse(apiResponse).data.userId;
-
- // var receiver =[];
- // receiver.push(userId);
- // var channels = ["uspace"];
- // var title = "巡检计划提醒";
- // var content = planName+"距离巡检日期只有3天了,请做好准备!";
- // var createToDoExt = {
- // "webUrl":envUrl+"/mdf-node/meta/Voucher/inspect_plan/"+planId+"?domainKey=developplatform";
- // }
- // var messageInfo = {
- // 'sysId':'diwork',
- // 'tenantId':tenantId,
- // 'receiver':receiver,
- // 'channels':channels,
- // 'subject':title,
- // 'content':content,
- // 'messageType':'createToDo',
- // 'createToDoExt':createToDoExt
- // };
- // var result = sendMessage(messageInfo);
-
- // }
-
- return {};
- }
- }
- exports({"entryPoint":MyTrigger});
复制代码
|
本帖子中包含更多资源,您需要 登录 才可以下载或查看,没有帐号?立即注册
X
|