定时任务中的代码:
(function () {
var formid = "__ZmpryCN7rm8hFAppSDg";
var appid = "__rz4dovPGJTyLIVFpRWv";
var dsdtsi = new Packages.cn.myapps.designtime.datasource.service.DataSourceDesignTimeServiceImpl();
var sql_del = "DELETE FROM oa.tlk_西安维修件库存信息表 where 1=1 ";
//deleteByDSName("new_oa", sql_del);
dsdtsi.remove("new_oa", sql_del,appid);
var sql_insert = "INSERT INTO oa.tlk_西安维修件库存信息表 (" +
"domainid,formid,applicationid,formname,id,item_实物存储状态," +
"item_整机料号,item_产品名称,item_产品系列,item_批号,item_库存数量,LASTMODIFIED,AUTHOR) " +
"SELECT domainid,'" + formid + "' AS formid,APPLICATIONID," +
"'市场售后管理/故障件管理/西安维修件库存信息/西安维修件库存信息表' AS formname," +
"CONCAT(SUBSTRING(MD5(RAND()), 1, 19),'--','__ZmpryCN7rm8hFAppSDg') AS ID," +
"ITEM_实物存储状态,ITEM_整机料号,ITEM_产品名称,ITEM_产品系列," +
"ITEM_批号,COUNT(*) AS item_库存数量,NOW() AS LASTMODIFIED," +
"'a76f01c7-f78d-464b-bb54-7aaaacec2298' AS AUTHOR " +
" FROM oa.tlk_西安故障件全周期信息库 WHERE ITEM_实物存储状态='维修良品在库' GROUP BY " +
" domainid,ITEM_实物存储状态,ITEM_整机料号,ITEM_产品名称,ITEM_批号,ITEM_产品系列";
//insertByDSName("new_oa", sql_insert);
dsdtsi.queryInsert("new_oa", sql_insert,appid);
var sql = "SELECT * FROM OA.tlk_西安维修件库存信息表 where ITEM_实物存储状态='维修良品在库'";
//var query = queryBySQL(sql);
var process = getDocumentProcess();
process.queryBySQL(sql, "new_oa");
var html = "<table style='width:80%;border-collapse:collapse;'>";
html += "<thead><tr style='background-color:#f0f0f0;'>";
html += "<th style='border:1px solid #ccc;padding:8px;'>库存状态</th>";
html += "<th style='border:1px solid #ccc;padding:8px;'>整机料号</th>";
html += "<th style='border:1px solid #ccc;padding:8px;'>产品名称</th>";
html += "<th style='border:1px solid #ccc;padding:8px;'>产品系列</th>";
html += "<th style='border:1px solid #ccc;padding:8px;'>批号</th>";
html += "<th style='border:1px solid #ccc;padding:8px;'>库存数量</th>";
html += "</tr></thead><tbody>";
if (query != null) {
for (var it = query.iterator(); it.hasNext();) {
var data = it.next();
html += "<tr>";
html += "<td style='border:1px solid #ccc;padding:10px;'>" + data.getItemValueAsString("实物存储状态") + "</td>";
html += "<td style='border:1px solid #ccc;padding:8px;'>" + data.getItemValueAsString("整机料号") + "</td>";
html += "<td style='border:1px solid #ccc;padding:8px;'>" + data.getItemValueAsString("产品名称") + "</td>";
html += "<td style='border:1px solid #ccc;padding:8px;'>" + data.getItemValueAsString("产品系列") + "</td>";
html += "<td style='border:1px solid #ccc;padding:8px;'>" + data.getItemValueAsString("批号") + "</td>";
html += "<td style='border:1px solid #ccc;padding:8px;'>" + data.getItemValueAsInt("库存数量") + "</td>";
html += "</tr>";
}
}
html += "</tbody></table>";
var body = "<p style='text-align: center;'><h2>维修良品库存信息</h2></p>";
body += html;
var subject = "维修良品库存信息!";
var from = "bpmservices@...";
var host = "smtp.qiye.aliyun.com";
var user = "bpmservices@...";
var password = "******";
var bbc = "";
var validate = true;
var sendTo = "wxlpzkts@..."
if (isNotNull(sendTo)) {
sendMail(from, sendTo, subject, body, host, user, password, bbc, validate);
println("维修良品库存信息sendMail成功");
Packages.java.lang.System.out.println("维修良品库存信息sendMail成功");
}
})(); |