团队遗忘计划
__K9C0HmAjnqJZgTI2sjd
__K9C0HmAjnqJZgTI2sjd
iscript
: " + DsName2);
var userId = getWebUser().getId();
var passday0 ="&day=0";
var passday7 ="&day=7";
var passday15 ="&day=15";
var passday30 ="&day=30";
var sql_plan0 = " SELECT c.*, c.AUTHOR AS item_author, ( to_days(now()) - to_days( c.ITEM_PLANEDTIME )) AS item_timedif, u.NAME AS item_authorname FROM tlk_plan c left join tlk_planitem d on c.id = d.PARENT LEFT JOIN " + DsName2 + ".t_user u ON c.AUTHOR LIKE u.ID WHERE ( to_days( now()) - to_days( c.ITEM_PLANEDTIME )) > 0 and d.PARENT is null AND c.AUTHOR NOT LIKE '%" + userId + "%' AND u.ID IS NOT NULL GROUP BY c.AUTHOR,c.ID ";
var sum_plan0 = countBySQL(sql_plan0);
println("sql_plan0----->: " + sql_plan0 + "sum_plan0----->: " + sum_plan0 );
var sql_plan7 = " SELECT c.*, c.AUTHOR AS item_author, ( to_days(now()) - to_days( c.ITEM_PLANEDTIME )) AS item_timedif, u.NAME AS item_authorname FROM tlk_plan c left join tlk_planitem d on c.id = d.PARENT LEFT JOIN " + DsName2 + ".t_user u ON c.AUTHOR LIKE u.ID WHERE ( to_days( now()) - to_days( c.ITEM_PLANEDTIME )) > 7 and d.PARENT is null AND c.AUTHOR NOT LIKE '%" + userId + "%' AND u.ID IS NOT NULL GROUP BY c.AUTHOR,c.ID ";
var sum_plan7 = countBySQL(sql_plan7);
println("sql_plan7----->: " + sql_plan7 + "sum_plan7----->: " + sum_plan7 );
var sql_plan15 = " SELECT c.*, c.AUTHOR AS item_author, ( to_days(now()) - to_days( c.ITEM_PLANEDTIME )) AS item_timedif, u.NAME AS item_authorname FROM tlk_plan c left join tlk_planitem d on c.id = d.PARENT LEFT JOIN " + DsName2 + ".t_user u ON c.AUTHOR LIKE u.ID WHERE ( to_days( now()) - to_days( c.ITEM_PLANEDTIME )) > 15 and d.PARENT is null AND c.AUTHOR NOT LIKE '%" + userId + "%' AND u.ID IS NOT NULL GROUP BY c.AUTHOR,c.ID ";
var sum_plan15 = countBySQL(sql_plan15);
println("sql_plan15----->: " + sql_plan15 + "sum_plan15----->: " + sum_plan15 );
var sql_plan30 = " SELECT c.*, c.AUTHOR AS item_author, ( to_days(now()) - to_days( c.ITEM_PLANEDTIME )) AS item_timedif, u.NAME AS item_authorname FROM tlk_plan c left join tlk_planitem d on c.id = d.PARENT LEFT JOIN " + DsName2 + ".t_user u ON c.AUTHOR LIKE u.ID WHERE ( to_days( now()) - to_days( c.ITEM_PLANEDTIME )) > 30 and d.PARENT is null AND c.AUTHOR NOT LIKE '%" + userId + "%' AND u.ID IS NOT NULL GROUP BY c.AUTHOR,c.ID ";
var sum_plan30 = countBySQL(sql_plan30);
println("sql_plan30----->: " + sql_plan30 + "sum_plan30----->: " + sum_plan30 );
//var html = "遗忘计划数： "+sum_plan+" 条";
//println("html----->: " + html);
var appId=getApplication();
println("appId----->: " + appId);
var viewid='__FJNdSaVzoNLwn6reVQT';
var html = ""
+ "遗忘计划总数： " +sum_plan0+ " "
+""
+ "7天计未跟进划数： " +sum_plan7+ " "
+""
+ "15天未跟进计划数： " +sum_plan15+ " "
+""
+ "30天未跟进计划数： " +sum_plan30+ " "
+"";
html;]]>
1
__anmsjU6BWYJG5TroOwc
管理员;
false
{"icon":"if-lib icon-xinwenxinxi","icontype":"font","iconFontColor":"#000"}
#000
false
0
true
0