跟进记录
__1ztzuCfbFMrk1J3JfFq
__1ztzuCfbFMrk1J3JfFq
published
__MliHwi6VUyUe2sHYkR5
UTF-8
get
/dailylog/view/followlog
json
: " + sql );
//var datas = queryByDSName("mcs",sql);
//return datas;
/*
var sql = "";
var usql = " SELECT a.*, b.ITEM_NAME AS ITEM_CATEGORYNAME, c.ITEM_NAME AS ITEM_PRODUCTNAME, d.ITEM_NAME AS ITEM_CONTACTNAME, GROUP_CONCAT(e.ITEM_NAME SEPARATOR ', ') AS ITEM_PHASE FROM mcs.tlk_planitem a JOIN mcs.tlk_productcategory b ON a.ITEM_CATEGORYID = b.ID JOIN mcs.tlk_product c ON a.ITEM_PRODUCTID = c.ID JOIN mcs.tlk_customer_contact d ON a.ITEM_CUSTOMERCONTACTID = d.ID JOIN mcs.tlk_plantemplatestatus e ON FIND_IN_SET( e.ID, REPLACE ( a.ITEM_STATUSLIST, ';', ',' )) WHERE a.AUTHOR = '" + sendID + "' AND a.DOMAINID = '" + domainid +"' AND a.ITEM_REALPLANEDTIME LIKE '%" + choosetime + "%' GROUP BY a.ID ";
var roles = getWebUser().getRoles();
var idIndex = "";
for(var it = roles.iterator(); roles != null && it.hasNext();){
var role = it.next();
idIndex += role.getId();
}
if( idIndex.indexOf("__EfOuD0AlJKPzhcdzjcI") >= 0){ //是管理员id
sql = usql;
}
else if( idIndex.indexOf("__hxME2qTKkSacBzgbr4O") >= 0){ //是部门经理id
sql = usql;
}
else{
sql = " "+
" SELECT "+
" p.* "+
" FROM "+
" ( "+
" SELECT "+
" cf.ITEM_BELONGERID, "+
" u.* "+
" FROM "+
" ( " + usql + ") u "+
" LEFT JOIN mcs.tlk_customerfollow cf ON u.ITEM_CUSTOMERID = cf.ITEM_CUSTOMERID "+
" ) p WHERE p.ITEM_BELONGERID = '"+userId+"' ";
}
*/
var rtn = '[';
var query = queryBySQL(sql);
var CUSTOMERID = "";
var CUSTOMERID_OLD = "";
var PLANID = "";
var PLANID_OLD = "";
if( query != null ){
for(var iterator = query.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
var CATEGORYNAME = map1.getItemValueAsString("CATEGORYNAME"); //业务名
var PRODUCTNAME = map1.getItemValueAsString("PRODUCTNAME"); //产品名
var CONTACTNAME = map1.getItemValueAsString("CONTACTNAME"); //联系人名
var PHASE = map1.getItemValueAsString("PHASE"); //跟进阶段
var ACTUALCONTENT = map1.getItemValueAsString("ACTUALCONTENT"); //跟进说明
ACTUALCONTENT = ACTUALCONTENT.replace("\n",""); //去除跟进记录中的换行符
PLANID = map1.getItemValueAsString("PLANID"); //计划ID
if( !PLANID_OLD.equals(PLANID) )
{
if( rtn == "["){
rtn += "{";
}
else rtn += "]},{";
var PLANNAME = map1.getItemValueAsString("PLANNAME"); //计划名
rtn += "'item_planname': '" + PLANNAME + "',";
rtn += "'item_planid': '" + PLANID + "',";
var BELONGSCUSTOMER = map1.getItemValueAsString("CUSTOMERNAME"); //客户名
var CUSTOMERID = map1.getItemValueAsString("CUSTOMERID"); //客户id
rtn += "'item_customerid': '" + CUSTOMERID + "',";
rtn += "'item_customername': '" + BELONGSCUSTOMER + "',";
rtn += "'item_planitem': [";
rtn += "{";
rtn += "'item_categoryname': '" + CATEGORYNAME + "',";
rtn += "'item_productname': '" + PRODUCTNAME + "',";
rtn += "'item_contactname': '" + CONTACTNAME + "',";
rtn += "'item_phase': '" + PHASE + "',";
rtn += "'item_actualcontent': '" + ACTUALCONTENT + "'";
rtn += "}";
}
else{
rtn += ",{";
rtn += "'item_categoryname': '" + CATEGORYNAME + "',";
rtn += "'item_productname': '" + PRODUCTNAME + "',";
rtn += "'item_contactname': '" + CONTACTNAME + "',";
rtn += "'item_phase': '" + PHASE + "',";
rtn += "'item_actualcontent': '" + ACTUALCONTENT + "'";
rtn += "}";
}
CUSTOMERID_OLD = CUSTOMERID; //上一条数据的客户ID
PLANID_OLD = PLANID; //上一条数据的计划ID
if ( !iterator.hasNext() ){
//rtn += "]}]";
}
}
}
rtn += "]}]";
var result = "";
result += "{'msg': 'success','code': '0','data': "+rtn+" }"
return result;
})()]]>