发送通知 - 人员指派任务 __qmtw40pukMZGOuCte1x __qmtw40pukMZGOuCte1x published UTF-8 post /duty/task/notice/arrange json 0){ var idGroup = "("; for(var i = 0; i < securityIdArr.length; i++){ idGroup += "'" + securityIdArr[i] + "'"; if(i < securityIdArr.length - 1 ){ idGroup += ","; } } idGroup += ")"; var sql = "insert into obpm2.mc_notice(ID,IS_READ,SUMMARY,TO_USER_ID,CREATE_TIME,LINK_PARAMS,MODULE,DOMAIN_ID,SUBJECT_TYPE,CONTENT) " + " SELECT UUID(),0,'任务助手',r.ITEM_EMPLOYEEID,CURRENT_TIMESTAMP,JSON_OBJECT('taskId',t.id),'任务助手',e.organization_id,31, " + " JSON_OBJECT('taskName',t.ITEM_NAME,'typeName',y.ITEM_NAME,'taskDescription',t.ITEM_DESCRIPTION,'startDate',DATE_FORMAT(t.ITEM_STARTDATE,'%Y-%m-%d %H:%i'),'endDate',DATE_FORMAT(t.ITEM_STARTDATE,'%Y-%m-%d %H:%i')) " + " from duty.tlk_patrol_tasks t left join duty.tlk_task_types y on t.ITEM_TYPE = y.id " + " join duty.tlk_patrol_task_employee_relations r on t.id = r.ITEM_TASKID " + " join obpm2.tenant_employees e on r.ITEM_EMPLOYEEID = e.id " + " where t.id = '" + taskId + "' and r.ITEM_EMPLOYEEID in " + idGroup; insertByDSName("duty",sql); //var result = new Packages.java.util.HashMap(); //result.put("sql",sql); //return result; } })()]]>