script for kettle send mail contect

来源：互联网发布：java实现链表结构编辑：程序博客网时间：2024/06/08 06:26

//Script here

var title = "不同步的数据";
var sender_address = "biservice@sds.com";
var user = "csdfsdf";
var server = "mail.sdfs.com";
var port = 25;
var sender_name = "System Administrator";
var password = "sdfsf";
var content = "<style type = 'text/css'> body{font_size:20px;}th,td{padding:1px;line-height:21px;border:1px #a4a7ac solid;text-align:center;}</style>";
content+="<font color='red'><b>不同步的数据</b></font>,具体详情如下：<br/>";
var dbcon = "ripdb";
content+="<br/><table style='table-layout:fixed;width:100%;border:1px #A4A7AC solid;background: white;padding:1px;line-height:21px;border-collapse: collapse;'><tr style='background: #ccc;'><th>2243号</th><th>2342号</th><th>颜色_1</th><th>颜色_2</th></tr>";
var sql = "SELECT manufacturecode ,productcode ,erpcolors ,scmcolors FROM tmp_sq_scmerp_colors";
var query_data = fireToDB(dbcon,sql);
if(query_data!=undefined)
{
for(var i=0;i < query_data.length;i++)
{
var ap = query_data[i];
content+="<tr><td>"+ap[0]+"</td><td>"+ap[1]+"</td><td>"+ap[2]+"</td><td>"+ap[3]+"</td></tr>"

}
}
content += "</table>";

0 0