未读日报 __1ztzuCfbFMrk1J3JfFq __1ztzuCfbFMrk1J3JfFq published __epSEONPqumqyqXNO4zO UTF-8 get /dailylog/view/unreadDaily json ='"+startTime+"'"; } if(isNotNull(endTime)){ whereStr+="and subdate(a.item_sendTime,1) <'"+endTime+"'"; } if(isNotNull(logtype)){ whereStr+=" and a.item_logtype = '"+logtype+"'"; } 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"+ " where a.item_unread like('%"+userId+"%') and (a.item_read not like('%"+userId+"%') or a.item_read is null) and a.item_userID !='"+userId+"' and a.item_send='已发送' "+whereStr; if(isNotNull(Number) && !"null".equals(Number)){ sql += " GROUP BY a.id ORDER BY a.ITEM_SENDTIME DESC limit "+Number+""; }else{ sql += " GROUP BY a.id ORDER BY a.ITEM_SENDTIME DESC limit 30"; } var datas = queryByDSName("dailylog",sql); //权限设置 //var rtn = getWebUser().getRolelist(getApplication()); //var ptroleid=getRoleIdByName("普通员工"); //if(rtn.equals(ptroleid)){//权限处理 datas = permission.setPermission( datas ); //} result.put("msg", "success"); result.put("code", "0"); result.put("datas",datas); return result; })()]]>