删除岗点负责人 __XLjD79Km8j8pkSHjTTv __XLjD79Km8j8pkSHjTTv published UTF-8 post /event/delete/post/manager json 您好，您已被从'+post_name+"岗点的负责人中移除。', '"+person_id+"', now(), NULL, '赛演项目', '"+domain_id+"', 11, '"+'{\"content\":\"您好，您已被从'+post_name+'岗点的负责人中移除。\",\"post_id\":\"'+post_id+'\",\"title\":\"赛演提醒\",\"type\":11,\"typeName\":\"赛演项目\"'+"}');" insertByDSName("baibaodunFlow",insertsql); var uppersonlist="update baibaodunflow.tlk_attendance_site_base_info set item_principal= REPLACE(REPLACE(item_principal, '"+personStr+";', ''), '"+personStr+"', ''),item_principalName= REPLACE(REPLACE(item_principalName, '"+name+";', ''), '"+name+"', ''),item_principalPhoneNo= REPLACE(REPLACE(item_principalPhoneNo, '"+telephone+";', ''), '"+telephone+"', '') where id=(select item_att_id from tlk_event_post where id='"+post_id+"' )" updateByDSName('baibaodunFlow',uppersonlist) var updateDevice = "update dispatch.tlk_device set item_end_time='"+format(adjustDay (getToday(),-1),"yyyy-MM-dd")+"' where item_binded_assigner_name='赛演临时调度' and item_binded_user_id='"+person_id+"' " updateByDSName("baibaodunFlow",updateDevice); } inWhere+="1')" var sql ="delete from tlk_event_post_manager where id in "+inWhere; deleteByDSName("baibaodunFlow",sql); 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; } })()]]>