<%@ page import="weaver.conn.RecordSet" %> <%@ page import="weaver.general.Util" %> <%@ page import="org.apache.commons.lang3.StringUtils" %> <%@ page import="com.alibaba.fastjson.JSONObject" %> <%@ page import="java.util.List" %> <%@ page import="java.util.ArrayList" %> <%@ page import="weaver.hrm.User" %> <%@ page import="weaver.hrm.HrmUserVarify" %> <%@ page import="java.util.Map" %> <%@ page import="java.util.HashMap" %> <%@ page import="weaver.general.BaseBean" %> <%@ page import="com.engine.kq.biz.KQGroupMemberComInfo" %> <%@ page import="com.engine.kq.biz.KQGroupComInfo" %> <%@ page import="com.engine.kq.biz.KQGroupBiz" %> <%@ page import="weaver.common.DateUtil" %> <%@ page language="java" contentType="text/html; charset=UTF-8" %> <% User user = HrmUserVarify.getUser(request, response); if(user==null) { response.sendRedirect("/login/Login.jsp"); return; } RecordSet rs = new RecordSet(); String ry = request.getParameter("ry"); String tbrq = request.getParameter("tbrq"); // out.print("ry:"+ry+"
"); // out.print("tbrq:"+tbrq+"
"); String activeGroupId = "" ; String wfidstatus = ""; JSONObject jsonObject = new JSONObject(); if(StringUtils.isNotBlank(ry)){ activeGroupId = getUserActiveGroupId(ry); if(StringUtils.isNotBlank(tbrq) && StringUtils.isNotBlank(activeGroupId)){ String sql =" select t.wfidstatus\n" + " from kq_flow_shiftschedule t\n" + " inner join kq_ShiftManagement k on k.id = t.serialid" + " where t.kqdate='"+tbrq+"' \n" + " and t.groupid="+activeGroupId+" and (t.isDelete is null or t.isDelete = 0)\n" + " and t.resourceid = " + ry ; rs.executeQuery(sql); if(rs.next()){ wfidstatus = Util.null2String(rs.getString("wfidstatus")); } } } // out.print("serialid:"+serialid+"
"); // out.print("serial:"+serial+"
"); jsonObject.put("wfidstatus",wfidstatus); jsonObject.put("ry",ry); jsonObject.put("tbrq",tbrq); %> <%=jsonObject.toJSONString() %> <%! public List> getDt1UserDate(List> hrmList){ List> dt1List = new ArrayList>(); for(int i=0;i hrmMap = hrmList.get(i); String userid = Util.null2String(hrmMap.get("id")); String lastname = Util.null2String(hrmMap.get("lastname")); Map dt1Map = new HashMap(); dt1Map.put("id",userid); dt1Map.put("name",lastname); List> specialobjList2 = new ArrayList>(); Map specialobjMap2 = new HashMap(); specialobjMap2.put("id",userid); specialobjMap2.put("name",lastname); specialobjList2.add(specialobjMap2); Map valueMap2 = new HashMap(); valueMap2.put("value",userid); valueMap2.put("specialobj",specialobjList2); dt1Map.put("value",valueMap2); dt1List.add(dt1Map); } return dt1List; } /*** * * @param hrmList * @return */ public Map getMainUserDate(List> hrmList){ String userids = ""; List> specialobjList = new ArrayList>(); for(int i=0;i hrmMap = hrmList.get(i); String userid = Util.null2String(hrmMap.get("id")); String lastname = Util.null2String(hrmMap.get("lastname")); userids += StringUtils.isBlank(userids) ? userid : ","+userid ; Map specialobjMap = new HashMap(); specialobjMap.put("id",userid); specialobjMap.put("name",lastname); specialobjList.add(specialobjMap); } Map valueMap = new HashMap(); valueMap.put("value",userids); valueMap.put("specialobj",specialobjList); return valueMap; } public List> queryListBySql(String sql){ RecordSet rs = new RecordSet(); BaseBean bb = new BaseBean(); List> list = new ArrayList>(); try{ if(StringUtils.isNotBlank(sql)){ Map map = new HashMap(); rs.executeQuery(sql); String[] column = rs.getColumnName(); while (rs.next()){ map = new HashMap(); for(int i=0;i0){ list.add(map); } } } }catch (Exception e){ e.printStackTrace(); bb.writeLog("queryListBySql-e:"+e); } return list; } public String getUserActiveGroupId(String userid){ BaseBean bb = new BaseBean(); KQGroupMemberComInfo kqGroupMemberComInfo = null; KQGroupComInfo kqGroupComInfo = null ; String activeGroupId = ""; try{ kqGroupMemberComInfo = new KQGroupMemberComInfo(); kqGroupComInfo = new KQGroupComInfo(); Map> groupMemberMap = getUserGroup(); String activeGroup = ""; if(groupMemberMap.containsKey(userid)){ List groupIds = groupMemberMap.get(userid); bb.writeLog("groupIds:"+groupIds.size()); for(String i : groupIds){ String isDelete = kqGroupComInfo.getIsdelete(i); if(!"1".equals(isDelete)) { String currentGroupId = Util.null2String(kqGroupMemberComInfo.getKQGroupId(userid, DateUtil.getCurrentDate())); if (i.equals(currentGroupId)) { activeGroupId = i; } } } } }catch (Exception e){ e.printStackTrace(); bb.writeLog(e); } return activeGroupId; } /*** * * @return */ public Map> getUserGroup(){ BaseBean bb = new BaseBean(); Map> groupMemberMap = new HashMap<>(); RecordSet rs = new RecordSet(); String viewScope = "3"; try { KQGroupBiz kqGroupBiz = new KQGroupBiz(); Map groupParams = new HashMap(); if("3".equals(viewScope)){ groupParams.put("isNoAccount", "1"); } rs.executeQuery(kqGroupBiz.getGroupMemberSql(groupParams)); while (rs.next()) { String id = rs.getString("resourceid"); String gid = rs.getString("groupid"); if (!groupMemberMap.containsKey(id)) groupMemberMap.put(id, new ArrayList<>()); groupMemberMap.get(id).add(gid); } } catch (Exception e) { } return groupMemberMap; } %>