You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
51 lines
2.0 KiB
Plaintext
51 lines
2.0 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
|
|
<%@ page import="weaver.general.*" %>
|
|
<%@ page import="com.alibaba.fastjson.JSONObject" %>
|
|
<%@ page import="weaver.hrm.*" %>
|
|
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
|
|
<jsp:useBean id="bb" class="weaver.general.BaseBean" />
|
|
<%
|
|
JSONObject result = new JSONObject();
|
|
User user = HrmUserVarify.getUser(request, response);
|
|
int useridd = user.getUID();
|
|
if(useridd == 1) { //系统管理员
|
|
useridd = 383; // 刘善玉
|
|
}
|
|
|
|
String sql =" select e.id,e.lastname,e.sex,d.departmentname,j.jobtitlename,h.zjf,h.dhjf,h.syjfs from uf_jftz h " +
|
|
" inner join HrmDepartment d on d.id = h.jfhdrbm " +
|
|
" inner join hrmjobtitles j on j.id = h.jfhdrgw " +
|
|
" inner join hrmresource e on e.id = h.jfhdr " +
|
|
" where e.status in(1,2,3,4) and h.jfhdr = ? " ;
|
|
bb.writeLog("sql:"+sql);
|
|
rs.executeQuery(sql,useridd);
|
|
while (rs.next()){
|
|
|
|
String userid = Util.null2String(rs.getString("id"));
|
|
String lastname = Util.null2String(rs.getString("lastname"));
|
|
String sex = Util.null2String(rs.getString("sex"));
|
|
String departmentname = Util.null2o(rs.getString("departmentname"));
|
|
String jobtitlename = Util.null2o(rs.getString("jobtitlename"));
|
|
String zjf = Util.null2o(rs.getString("zjf"));
|
|
String dhjf = Util.null2o(rs.getString("dhjf"));
|
|
String syjfs = Util.null2o(rs.getString("syjfs"));
|
|
String imgurl = "/messager/images/icon_m_wev9.png";
|
|
if("1".equals(sex)){
|
|
imgurl = "/messager/images/icon_w_wev9.png";
|
|
}
|
|
|
|
result.put("userid",userid);
|
|
result.put("lastname",lastname);
|
|
result.put("sex",sex);
|
|
result.put("imgurl",imgurl);
|
|
result.put("departmentname",departmentname);
|
|
result.put("jobtitlename",jobtitlename);
|
|
result.put("zjf",zjf);
|
|
result.put("dhjf",dhjf);
|
|
result.put("syjfs",syjfs);
|
|
}
|
|
|
|
out.print(result.toJSONString());
|
|
%>
|
|
|