<%@ page import="com.alibaba.fastjson.JSONObject" %> <%@ page import="java.util.*" %> <%@ page import="weaver.conn.RecordSet" %> <%@ page import="weaver.general.Util" %> <%@ page import="weaver.mfbdt.util.MfUtil" %> <%@ page import="com.time.util.DateUtil" %> <%@ page import="java.text.SimpleDateFormat" %> <%@ page import="weaver.mfbdt.util.WorkflowCreateHandler" %> <%-- User: wangj Design Ideas： 铭沣-获取时间段内外勤打卡记录同步到原始外勤打卡审批表 --%> <%@ page contentType="text/html;charset=UTF-8" %> <% JSONObject data = new JSONObject(); boolean flag = false; String sdate = Util.null2String(request.getParameter("sdate")); String edate = Util.null2String(request.getParameter("edate")); String userid = Util.null2String(request.getParameter("userid")); if ("".equals(sdate) || "".equals(edate) || "".equals(userid)) { data.put("flag", flag); out.print(data.toJSONString()); }else{ List datelist = new ArrayList<>(100); datelist = dateUtil(sdate, edate); String sql = ""; for (String datestr : datelist){ sql = "select sqr from uf_wqdkysjl where dkrq = '" + datestr + "' and sqr = '"+userid+"' group by sqr"; doJob(sql,datestr); flag = true; data.put("flag", flag); } out.print(data.toJSONString()); } %> <%! public void doJob(String sql,String date){ List userList = new ArrayList<>(100); RecordSet rs = new RecordSet(); rs.execute(sql); while (rs.next()) { String sqr = com.wbi.util.Util.null2String(rs.getString("sqr")); userList.add(sqr); } sql = "select * from uf_wqdkysjl where sqr = ? and dkrq = ?"; String sqrq = DateUtil.getCurrentTime("yyyy-MM-dd"); if (userList.size() > 0) { for (String sqr : userList) { String id = ""; String gsmc = ""; String szzw = ""; String szbm = ""; String ygbh = ""; String dkrq = ""; String dksj = ""; String dkwz = ""; String gzrq = ""; String bz = ""; String wqdkysjlid = ""; String lastname = getLastname(sqr); List> detailList = new ArrayList<>(100); rs.executeQuery(sql, sqr, date); while (rs.next()) { id = com.wbi.util.Util.null2String(rs.getString("id")); gsmc = com.wbi.util.Util.null2String(rs.getString("gsmc")); szzw = com.wbi.util.Util.null2String(rs.getString("szzw")); szbm = com.wbi.util.Util.null2String(rs.getString("szbm")); ygbh = com.wbi.util.Util.null2String(rs.getString("ygbh")); wqdkysjlid = wqdkysjlid + "," + id; Map map = new HashMap<>(100); dkrq = com.wbi.util.Util.null2String(rs.getString("dkrq")); dksj = com.wbi.util.Util.null2String(rs.getString("dksj")); dkwz = com.wbi.util.Util.null2String(rs.getString("dkwz")); gzrq = com.wbi.util.Util.null2String(rs.getString("gzrq")); bz = com.wbi.util.Util.null2String(rs.getString("bz")); map.put("dkrq", dkrq); map.put("dksj", dksj); map.put("dkwz", dkwz); map.put("gzrq", gzrq); map.put("bz", bz); detailList.add(map); } wqdkysjlid = wqdkysjlid.substring(1, wqdkysjlid.length()); String createrid = sqr + ""; String workflowId = com.wbi.util.Util.null2String(rs.getPropValue("kq_config", "outSign_wfid")); String requestName = MfUtil.getWorkflowname(workflowId); requestName = requestName + "-" + lastname + "-" + sqrq; String isNextFlow = "1"; Map requestMainMap = new HashMap<>(); requestMainMap.put("sqr", createrid); requestMainMap.put("sqrq", sqrq); requestMainMap.put("gsmc", gsmc); requestMainMap.put("wqdkysjlid", wqdkysjlid); if (!"".equals(gsmc)) { requestMainMap.put("gsmc", gsmc); } if (!"".equals(szzw)) { requestMainMap.put("szzw", szzw); } if (!"".equals(szbm)) { requestMainMap.put("szbm", szbm); } if (!"".equals(ygbh)) { requestMainMap.put("ygbh", ygbh); } WorkflowCreateHandler workflowCreateHandler = new WorkflowCreateHandler(); String requestid = workflowCreateHandler.workflowCreateByRequestMap(createrid, workflowId, requestName, isNextFlow, requestMainMap); if (com.wbi.util.Util.getIntValue(requestid) > 0) { //更新明细数据 updateDetailData(detailList,requestid); } } } } %> <%! public String getLastname(String userid) { RecordSet rs = new RecordSet(); String lastname = ""; rs.execute("select lastname from hrmresource where id = '" + userid + "'"); while (rs.next()) { lastname = com.wbi.util.Util.null2String(rs.getString("lastname")); } return lastname; } %> <%! public void updateDetailData(List> datalist, String requestid) { RecordSet rs = new RecordSet(); String mainid = ""; String tableName = com.wbi.util.Util.null2String(rs.getPropValue("kq_config", "wq_wf_tablename")); rs.execute("select id from " + tableName + " where requestid = '" + requestid + "'"); while (rs.next()) { mainid = com.wbi.util.Util.null2String(rs.getString("id")); } for (Map map : datalist) { String dkrq = com.wbi.util.Util.null2String(map.get("dkrq")); String dksj = com.wbi.util.Util.null2String(map.get("dksj")); String dkwz = com.wbi.util.Util.null2String(map.get("dkwz")); String gzrq = com.wbi.util.Util.null2String(map.get("gzrq")); String bz = com.wbi.util.Util.null2String(map.get("bz")); String sql = "insert into " + tableName + "_dt1 (mainid,dkrq,dksj,dkwz,gzrq,bz) values (?,?,?,?,?,?)"; rs.executeUpdate(sql, mainid, dkrq, dksj, dkwz, gzrq, bz); } } %> <%! /** * @Description: 获取起止日期集合 * @Param: * @return: */ public static List dateUtil(String start, String end) { List list = new ArrayList(); Date sdate = DateUtil.parseDate(start, "yyyy-MM-dd"); Date edate = DateUtil.parseDate(end, "yyyy-MM-dd"); long s = sdate.getTime(); long e = edate.getTime(); Long oneDay = 1000 * 60 * 60 * 24l; while (s <= e) { sdate = new Date(s); System.out.println(new SimpleDateFormat("yyyy-MM-dd").format(sdate)); list.add(new SimpleDateFormat("yyyy-MM-dd").format(sdate)); s += oneDay; } return list; } %>