删除岗点小组人员
__XLjD79Km8j8pkSHjTTv
__XLjD79Km8j8pkSHjTTv
published
UTF-8
post
/event/delete/group/person
json
您好,您已被从'+post_name+"岗点中移除。', '"+person_id+"', now(), NULL, '赛演项目', '"+domain_id+"', 11, '"+'{\"content\":\"您已被从'+post_name+'岗点中移除。\",\"post_id\":\"'+post_id+'\",\"title\":\"赛演提醒\",\"type\":11,\"typeName\":\"赛演项目\"'+"}');"
insertByDSName("baibaodunFlow",insertsql);
attinWhere+=att_person_id+"','"
loginWhere+=person_log+"','"
inWhere+=arr[i]+"','"
}
inWhere+="1')"
attinWhere+="1')"
loginWhere+="1')"
//删除驻勤岗点人员
var sql2="delete from tlk_attendance_site_person_info where id in "+attinWhere
deleteByDSName("baibaodunFlow",sql2);
//更新日志
var sql3="update tlk_event_post_person_log set item_remove_person='"+userName+"',item_remove_time=now() where id in "+loginWhere
updateByDSName("baibaodunFlow",sql3);
//删除小组人员
var sql1="delete from tlk_event_post_group_person where id in "+inWhere
deleteByDSName("baibaodunFlow",sql1);
result.put("code","200");
result.put("msg","移除成功!");
result.put("state", true);
return result;
}else{
result.put("code","500");
result.put("msg","ids不能为空!");
result.put("state", false);
return result;
}
}else{
result.put("code","500");
result.put("msg","请求体不能为空!");
result.put("state", false);
return result;
}
})()]]>