【5.0】将未处理的任务通过邮件提醒用户-爱游戏

chain · 发表于 2021-12-28 14:28:41

/*检查质量签发中'待签发'数据通过邮件提醒工程师*/
(function(){
var domainid = "pfqrtkz2khbjbu9w0xc";
var applicationid = "__dpdtviiboq60pcmb7ky";
var process = getdocprocess(applicationid);
var sql = "select * from tlk_engineer_issued_form where item_issuingstatus = '01'";
var query = process.querybysql(sql,domainid).datas;
var userprocess = createprocess("cn.myapps.authtime.user.service.userprocess"); //获取用户业务处理类
var uservo = userprocess.getuserbyloginno("chain", domainid);
var webuser = new packages.cn.myapps.base.web.webuser(uservo);
var eutil = new packages.cn.myapps.util.mail.emailutil(applicationid,webuser);
if(query!=null && query.size()>0){
for(var iter = query.iterator();iter.hasnext();){
var doc = iter.next();
var qftasknumber = doc.getitemvalueasstring("qftasknumber"); //任务编号
var material_name = doc.getitemvalueasstring("material_name"); //物料名称
var arrivaldate = doc.getitemvalueasdate("arrivaldate"); //到货日期
var today = gettoday();
if(arrivaldate!=null&&today!=null){
arrivaldate = format(arrivaldate,"yyyy-mm-dd hh:mm:ss");
today = format(today,"yyyy-mm-dd hh:mm:ss");
diff = diffdays(arrivaldate,today);
}
var pmtengineer = doc.getitemvalueasstring("pmtengineer"); //pmt工程师
var waybillno = doc.getitemvalueasstring("waybillno"); //货运单号
var touser = userprocess.doview(pmtengineer).getemail();
println("touser===========================================================>" touser);
// var touser = "chain@weioa365.com";
var subject = "工程师物料签发提醒";
var content = "货运单号：" waybillno "，物料" material_name "已到库，滞留天数为：" diff "天，请尽快签收！";
eutil.sendemailbysystemuser(touser,subject,content);
}
}
})();

复制代码

		自动登录
密码			注册成为天翎用户