全部日报 __1ztzuCfbFMrk1J3JfFq __1ztzuCfbFMrk1J3JfFq published __epSEONPqumqyqXNO4zO UTF-8 get /dailylog/view/allDaily json ='"+startTime+"'"; } if(isNotNull(endTime)){ whereStr+="and subdate(a.item_sendTime,1) <'"+endTime+"'"; } if(isNotNull(logtype)){ whereStr+=" and a.item_logtype = '"+logtype+"'"; } /* var rtn = ""; for(var it = roles.iterator(); roles != null && it.hasNext();){ var role = it.next(); rtn += role.getId(); } */ //if( rtn.indexOf("__EfOuD0AlJKPzhcdzjcI") >= 0){ //是管理员id var sql = " SELECT "+ "a.PARENT," + // "a.LASTMODIFIED," + // "a.FORMNAME," + // "a.STATE," + // "a.AUDITUSER," + // "a.AUDITDATE," + // "a.AUTHOR," + // "a.AUTHORDEPTID," + // "a.AUTHOR_DEPT_INDEX," + // "a.AUTHOR_USER_INDEX," + // "a.CREATED," + // "a.FORMID," + // "a.SUBFORMIDS," + // "a.INITIATOR," + // "a.ISTMP," + // "a.VERSIONS," + // "a.APPLICATIONID," + // "a.STATEINT," + // "a.STATELABEL," + // "a.AUDITORNAMES," + // "a.LASTFLOWOPERATION," + // "a.LASTMODIFIER," + // "a.DOMAINID," + // "a.AUDITORLIST," + // "a.COAUDITORLIST," + // "a.STATELABELINFO," + // "a.PREVAUDITNODE," + // "a.PREVAUDITUSER," + // "a.OPTIONITEM," + // "a.SIGN," + // "a.KINGGRIDSIGNATURE," + // "a.ID," + // "a.ITEM_NOTE," + // "a.ITEM_PICTURE," + // "a.ITEM_ATTACHMENT," + // "a.ITEM_READ," + // "a.ITEM_UNREAD," + // "a.ITEM_LOGTYPE," + // "a.ITEM_FIELD1," + // "a.ITEM_FIELD2," + // "a.ITEM_FIELD3," + // "a.ITEM_FIELD4," + // "a.ITEM_FIELD5,"+ "a.ITEM_COPYTOPERSON," + // "a.ITEM_SEND," + // "a.ITEM_USERNAME," + // "a.ITEM_planitem," + // "a.ITEM_USERID," + // "a.ITEM_SIGN," + // "a.ITEM_COMMENTSSECTION," + // "a.ITEM_COMMENT," + // "a.ITEM_SENDTIME," + // "a.ITEM_choosetime," + // "a.ITEM_finishWork," + // "a.ITEM_unfinish," + // "a.ITEM_projectProgress," + // "a.ITEM_coordinateWork," + // "count(b.id) as item_commentNumber,"+ "case when a.ITEM_READ like('%"+userId+"%') then '已读' else '未读' end as ITEM_state"+// " FROM tlk_baselog a "+ " LEFT JOIN tlk_comment b ON a.id = b.item_dailyID" ; if( rtn.indexOf(role1) >= 0){ //是管理员id sql += " WHERE a.item_userid !='"+userId+"' and a.DOMAINID = '" + domainid + "' and a.item_send='已发送' "; result.put("role", "1"); } else if( rtn.indexOf(role2) >= 0){ //是部门经理id var applicant_dept=getWebUser().getDefaultDepartment(); var deptUnderUserList=getUsersByDptId(applicant_dept); var uids=""; for(var iter= deptUnderUserList.iterator();iter.hasNext();){ var UserInfo=iter.next(); var name= UserInfo.getName(); var uid= UserInfo.getId(); var uid="'"+uid+"'"; uids=uids+","+uid; } uids=uids.substr(1); sql +=" where a.item_userid !='"+userId+"' and (a.item_userId in(" + uids + ") or a.item_copytoperson like '%"+userId+"%') and a.DOMAINID = '" + domainid + "' and a.item_send='已发送' "+whereStr; result.put("role", "2"); }else{//抄送给我的 sql +=" where a.item_userid !='"+userId+"' and a.item_copytoperson like '%"+userId+"%' and a.DOMAINID = '" + domainid + "' and a.item_send='已发送' "+whereStr; result.put("role", "3"); } var ptroleid=getRoleIdByName("普通员工"); sql += whereStr; sql += " GROUP BY a.id ORDER BY a.ITEM_SENDTIME DESC "; sql += limitSql; var datas = queryByDSName("dailylog",sql); //if(rtn.equals(ptroleid)){//权限处理 datas = permission.setPermission( datas ); //} result.put("msg", "success"); result.put("code", "0"); result.put("datas", datas); return result; })() ]]>