团队遗忘客户
__K9C0HmAjnqJZgTI2sjd
__K9C0HmAjnqJZgTI2sjd
iscript
: " + DsName2);
var userId = getWebUser().getId();
var passday7 ="&day=7";
var passday15 ="&day=15";
var passday30 ="&day=30";
var sql_plan7 = "SELECT a.* , a.LASTMODIFIED AS item_LASTMODIFIED, ( to_days( now()) - to_days( a.LASTMODIFIED )) AS item_timedif, u.NAME AS ITEM_NAME FROM tlk_customerfollow a LEFT JOIN tlk_plan c ON a.ITEM_CUSTOMERID = c.ITEM_CUSTOMERID LEFT JOIN " + DsName2 + ".t_user u ON a.ITEM_BELONGERID LIKE u.ID WHERE ( to_days( now()) - to_days( a.LASTMODIFIED )) >7 AND c.ITEM_CUSTOMERID IS NULL AND a.ITEM_BELONGERID not like '%" + userId + "%' AND u.ID IS NOT NULL GROUP BY a.ITEM_BELONGERID,a.ID ";
var sum_plan7 = countBySQL(sql_plan7);
println("sql_plan7----->: " + sql_plan7 + "sum_plan7----->: " + sum_plan7 );
var sql_plan15 = "SELECT a.* , a.LASTMODIFIED AS item_LASTMODIFIED, ( to_days( now()) - to_days( a.LASTMODIFIED )) AS item_timedif, u.NAME AS ITEM_NAME FROM tlk_customerfollow a LEFT JOIN tlk_plan c ON a.ITEM_CUSTOMERID = c.ITEM_CUSTOMERID LEFT JOIN " + DsName2 + ".t_user u ON a.ITEM_BELONGERID LIKE u.ID WHERE ( to_days( now()) - to_days( a.LASTMODIFIED )) >15 AND c.ITEM_CUSTOMERID IS NULL AND a.ITEM_BELONGERID not like '%" + userId + "%' AND u.ID IS NOT NULL GROUP BY a.ITEM_BELONGERID,a.ID ";
var sum_plan15 = countBySQL(sql_plan15);
println("sql_plan15----->: " + sql_plan15 + "sum_plan15----->: " + sum_plan15 );
var sql_plan30 = "SELECT a.* , a.LASTMODIFIED AS item_LASTMODIFIED, ( to_days( now()) - to_days( a.LASTMODIFIED )) AS item_timedif, u.NAME AS ITEM_NAME FROM tlk_customerfollow a LEFT JOIN tlk_plan c ON a.ITEM_CUSTOMERID = c.ITEM_CUSTOMERID LEFT JOIN " + DsName2 + ".t_user u ON a.ITEM_BELONGERID LIKE u.ID WHERE ( to_days( now()) - to_days( a.LASTMODIFIED )) >30 AND c.ITEM_CUSTOMERID IS NULL AND a.ITEM_BELONGERID not like '%" + userId + "%' AND u.ID IS NOT NULL GROUP BY a.ITEM_BELONGERID,a.ID ";
var sum_plan30 = countBySQL(sql_plan30);
println("sql_plan30----->: " + sql_plan30 + "sum_plan30----->: " + sum_plan30 );
var appId=getApplication();
println("appId----->: " + appId);
var viewid='__KSBPP47aiquc8bsACW2';
var html = ""
+ "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