407 lines
14 KiB
Plaintext
407 lines
14 KiB
Plaintext
<%@ page contentType="text/html; charset=UTF-8" %>
|
|
<%@ page import="weaver.conn.RecordSet" %>
|
|
<%@ page import="weaver.general.Util" %>
|
|
<%@ page import="com.alibaba.fastjson.JSONObject" %>
|
|
<%@ page import="weaver.soa.workflow.request.RequestInfo" %>
|
|
<%@ page import="weaver.soa.workflow.request.MainTableInfo" %>
|
|
<%@ page import="java.util.*" %>
|
|
<%@ page import="weaver.hrm.*" %>
|
|
|
|
<!-- 招聘人才登记表审批 -->
|
|
|
|
<%@ page import="weaver.soa.workflow.request.Property" %>
|
|
<%@ page import="weaver.soa.workflow.request.RequestService" %>
|
|
<%@ page import="weaver.general.TimeUtil" %>
|
|
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
|
|
<jsp:useBean id="rs1" class="weaver.conn.RecordSet" scope="page" />
|
|
<%
|
|
JSONObject jsonObject = new JSONObject();
|
|
String bool = "0";
|
|
String flag = "0";
|
|
String errorinfo = "";
|
|
User user = HrmUserVarify.getUser(request, response);
|
|
int userid = user.getUID();
|
|
String username = user.getUsername();
|
|
String currentDate = TimeUtil.getCurrentDateString();
|
|
String title = "招聘人才登记表审批-"+username+"-"+currentDate;
|
|
String mainid = Util.null2String(request.getParameter("mainid"));
|
|
String workflowid = rs.getPropValue("hrm_shhq","zprcdjlc_workflowid");
|
|
rs.executeQuery("select * from uf_xygrztz where id=?",mainid);
|
|
while(rs.next()) {
|
|
Map<String, Object> map = new HashMap();
|
|
//身份证号码
|
|
String sfzhm = Util.null2String(rs.getString("sfzhm"));
|
|
if(sfzhm != null && !"".equals(sfzhm)) {
|
|
map.put("sfzhm", sfzhm);
|
|
}else{
|
|
errorinfo += "身份证号码值为空,";
|
|
}
|
|
|
|
//姓名
|
|
String xm = Util.null2String(rs.getString("xm"));
|
|
if(xm != null && !"".equals(xm)) {
|
|
map.put("xm", xm);
|
|
}else{
|
|
errorinfo += "姓名值为空,";
|
|
}
|
|
|
|
//性别
|
|
String xb = Util.null2String(rs.getString("xb"));
|
|
if(xb != null && !"".equals(xb)) {
|
|
map.put("xb", xb);
|
|
}else{
|
|
errorinfo += "性别值为空,";
|
|
}
|
|
|
|
//民族
|
|
String mz = Util.null2String(rs.getString("mz"));
|
|
if(mz != null && !"".equals(mz)) {
|
|
map.put("mz", mz);
|
|
}else{
|
|
errorinfo += "民族值为空,";
|
|
}
|
|
|
|
//籍贯
|
|
String jg = Util.null2String(rs.getString("jg"));
|
|
if(jg != null && !"".equals(jg)) {
|
|
map.put("jg", jg);
|
|
}else{
|
|
errorinfo += "籍贯值为空,";
|
|
}
|
|
|
|
//出生日期
|
|
String csrq = Util.null2String(rs.getString("csrq"));
|
|
if(csrq != null && !"".equals(csrq)) {
|
|
map.put("csrq", csrq);
|
|
}else{
|
|
errorinfo += "出生日期值为空,";
|
|
}
|
|
|
|
//政治面貌
|
|
String zzmm = Util.null2String(rs.getString("zzmm"));
|
|
if(zzmm != null && !"".equals(zzmm)) {
|
|
map.put("zzmm", zzmm);
|
|
}else{
|
|
errorinfo += "政治面貌值为空,";
|
|
}
|
|
|
|
//手机号码
|
|
String yddh = Util.null2String(rs.getString("yddh"));
|
|
if(yddh != null && !"".equals(yddh)) {
|
|
map.put("yddh", yddh);
|
|
}else{
|
|
errorinfo += "移动电话值为空,";
|
|
}
|
|
|
|
//身高
|
|
String sg = Util.null2String(rs.getString("sg"));
|
|
if(sg != null && !"".equals(sg)) {
|
|
map.put("sg", sg);
|
|
}else{
|
|
errorinfo += "身高值为空,";
|
|
}
|
|
|
|
//体重
|
|
String tz = Util.null2String(rs.getString("tz"));
|
|
if(tz != null && !"".equals(tz)) {
|
|
map.put("tz", tz);
|
|
}else{
|
|
errorinfo += "体重值为空,";
|
|
}
|
|
|
|
//应聘公司
|
|
String ypgs = Util.null2String(rs.getString("ypgs1"));
|
|
if(ypgs != null && !"".equals(ypgs)) {
|
|
map.put("ypgs", ypgs);
|
|
}else{
|
|
errorinfo += "应聘公司值为空,";
|
|
}
|
|
|
|
//公司
|
|
String gs = Util.null2String(rs.getString("gsmc"));
|
|
if(ypgs != null && !"".equals(ypgs)) {
|
|
map.put("gs", ypgs);
|
|
}else{
|
|
errorinfo += "公司值为空,";
|
|
}
|
|
|
|
//学历
|
|
String xl = Util.null2String(rs.getString("xl"));
|
|
if(xl != null && !"".equals(xl)) {
|
|
map.put("xl", xl);
|
|
}else{
|
|
errorinfo += "学历值为空,";
|
|
}
|
|
|
|
//毕业院校
|
|
String byyx = Util.null2String(rs.getString("byyx"));
|
|
if(byyx != null && !"".equals(byyx)) {
|
|
map.put("byyx", byyx);
|
|
}else{
|
|
errorinfo += "毕业院校值为空,";
|
|
}
|
|
|
|
//家庭住址
|
|
String jtzz = Util.null2String(rs.getString("jtzz"));
|
|
if(jtzz != null && !"".equals(jtzz)) {
|
|
map.put("jtzz", jtzz);
|
|
}else{
|
|
errorinfo += "家庭住址值为空,";
|
|
}
|
|
|
|
//应聘岗位
|
|
String ypgw = Util.null2String(rs.getString("ypgw"));
|
|
if(ypgw != null && !"".equals(ypgw)) {
|
|
map.put("ypgw", ypgw);
|
|
}else{
|
|
errorinfo += "应聘岗位值为空,";
|
|
}
|
|
|
|
//招聘专员
|
|
String zpzyxm = Util.null2String(rs.getString("zpzyxm"));
|
|
if(zpzyxm != null && !"".equals(zpzyxm)) {
|
|
map.put("zpzyxm", zpzyxm);
|
|
}else{
|
|
errorinfo += "招聘专员姓名值为空,";
|
|
}
|
|
|
|
//招聘专员工号
|
|
String zpzygh = Util.null2String(rs.getString("zpzygh"));
|
|
if(zpzygh != null && !"".equals(zpzygh)) {
|
|
map.put("zpzygh", zpzygh);
|
|
}else{
|
|
errorinfo += "招聘专员工号值为空,";
|
|
}
|
|
|
|
String xxjl = "";
|
|
rs1.executeQuery("select * from uf_xygrztz_dt1 where mainid=?",mainid);
|
|
while(rs1.next()){
|
|
String kssj = Util.null2String(rs1.getString("kssj"));
|
|
if(kssj!=null && !"".equals(kssj)) {
|
|
xxjl += kssj + ",";
|
|
}
|
|
String jssj = Util.null2String(rs1.getString("jssj"));
|
|
if(jssj!=null && !"".equals(jssj)) {
|
|
xxjl += jssj + ",";
|
|
}
|
|
String byyx1 = Util.null2String(rs1.getString("byyx"));
|
|
if(byyx1!=null && !"".equals(byyx1)) {
|
|
xxjl += byyx1 + ",";
|
|
}
|
|
String xlid = Util.null2String(rs1.getString("xl"));
|
|
String xlname = getXlname(xlid);
|
|
if(xlname!=null && !"".equals(xlname)) {
|
|
xxjl += xlname + ",";
|
|
}
|
|
String xwid = Util.null2String(rs1.getString("xw"));
|
|
String xw1_fieldid = rs.getPropValue("hrm_shhq","xw1_fieldid");
|
|
String xwname = getSelectName(xw1_fieldid,xwid);
|
|
if(xwname!=null && !"".equals(xwname)) {
|
|
xxjl += xwname + ",";
|
|
}
|
|
String zy1 = Util.null2String(rs1.getString("zy"));
|
|
if(zy1!=null && !"".equals(zy1)) {
|
|
xxjl += zy1;
|
|
}
|
|
|
|
if(xxjl.endsWith(",")){
|
|
xxjl = xxjl.substring(0,xxjl.length()-1);
|
|
}
|
|
xxjl += ";";
|
|
}
|
|
if(xxjl.endsWith(";")){
|
|
xxjl = xxjl.substring(0,xxjl.length()-1);
|
|
}
|
|
map.put("xxjl", xxjl);
|
|
|
|
String gzjl = "";
|
|
rs1.executeQuery("select * from uf_xygrztz_dt2 where mainid=?",mainid);
|
|
while(rs1.next()){
|
|
String ksrq = Util.null2String(rs1.getString("ksrq"));
|
|
if(ksrq!=null && !"".equals(ksrq)) {
|
|
gzjl += ksrq + ",";
|
|
}
|
|
String jsrq = Util.null2String(rs1.getString("jsrq"));
|
|
if(jsrq!=null && !"".equals(jsrq)) {
|
|
gzjl += jsrq + ",";
|
|
}
|
|
String gzdw = Util.null2String(rs1.getString("gzdw"));
|
|
if(gzdw!=null && !"".equals(gzdw)) {
|
|
gzjl += gzdw + ",";
|
|
}
|
|
String drzw = Util.null2String(rs1.getString("drzw"));
|
|
if(drzw!=null && !"".equals(drzw)){
|
|
gzjl += drzw + ",";
|
|
}
|
|
String lxdh = Util.null2String(rs1.getString("lxdh"));
|
|
if(lxdh!=null && !"".equals(lxdh)){
|
|
gzjl += lxdh ;
|
|
}
|
|
if(gzjl.endsWith(",")){
|
|
gzjl = gzjl.substring(0,gzjl.length()-1);
|
|
}
|
|
gzjl += ";";
|
|
}
|
|
if(gzjl.endsWith(";")){
|
|
gzjl = gzjl.substring(0,gzjl.length()-1);
|
|
}
|
|
map.put("gzjl", gzjl);
|
|
|
|
//学习经历 field6765
|
|
//工作经历 field6766
|
|
|
|
boolean boole = checkHasWorkflow(sfzhm);
|
|
rs.writeLog("============ bool ================ " + bool);
|
|
rs.writeLog("============ map ================ " + map);
|
|
if (!boole) {
|
|
if(errorinfo.length() < 5){
|
|
String requestid = Createrequest(Integer.parseInt(workflowid), userid, title, "1", map);
|
|
rs.writeLog("============ requestid ================ " + requestid);
|
|
if (Integer.parseInt(requestid) > 0) {
|
|
flag = "1";
|
|
} else {
|
|
flag = "0";
|
|
break;
|
|
}
|
|
}else{
|
|
flag = "0";
|
|
}
|
|
}else{
|
|
bool = "1";
|
|
}
|
|
if(errorinfo.endsWith(",")){
|
|
errorinfo = errorinfo.substring(0,errorinfo.length()-1);
|
|
}
|
|
}
|
|
|
|
jsonObject.put("booll",bool);
|
|
jsonObject.put("flag",flag);
|
|
jsonObject.put("errorinfo",errorinfo);
|
|
|
|
out.print(JSONObject.toJSONString(jsonObject));
|
|
|
|
%>
|
|
|
|
<%!
|
|
|
|
/**
|
|
* 方法描述 : 创建流程方法
|
|
* @param workflowid
|
|
* @param userid 创建人id
|
|
* @param title 流程标题
|
|
* @param IsNextFlow 是否默认流转到下一节点 传 1 或 空 默认提交到下一节点
|
|
* @param map 数据map
|
|
* @return
|
|
* String
|
|
*/
|
|
public static String Createrequest(int workflowid, int userid, String title, String IsNextFlow, Map map){
|
|
String newrequestid="";
|
|
RequestInfo req=new RequestInfo();
|
|
req.setCreatorid(userid+""); //创建人
|
|
req.setWorkflowid(workflowid+"");//流程id
|
|
req.setDescription(title); //流程标题
|
|
req.setIsNextFlow(IsNextFlow); //是否默认流转到下一节点
|
|
MainTableInfo maintable=new MainTableInfo();
|
|
Set<String> keySet = map.keySet();
|
|
Property[] property = new Property[keySet.size()];
|
|
int i= 0;
|
|
Property p = null;
|
|
for(String key : keySet){
|
|
p = new Property();
|
|
p.setName(key);
|
|
p.setValue(map.get(key).toString());
|
|
property[i] = p;
|
|
i++;
|
|
}
|
|
maintable.setProperty(property);
|
|
req.setMainTableInfo(maintable);
|
|
req.setRequestlevel("0");
|
|
RequestService service=new RequestService();
|
|
try {
|
|
newrequestid=service.createRequest(req);
|
|
} catch (Exception e) {
|
|
e.printStackTrace();
|
|
}
|
|
return newrequestid;
|
|
}
|
|
|
|
/**
|
|
* 获取 下拉框 的名称
|
|
* @param fieldid
|
|
* @param value
|
|
* @return
|
|
*/
|
|
public static String getSelectName(String fieldid,String value) {
|
|
String result = "";
|
|
RecordSet rs = new RecordSet();
|
|
rs.executeQuery("select selectname from workflow_selectitem where cancel=0 and fieldid = ? and selectvalue = ?", fieldid, value);
|
|
if (rs.next()) {
|
|
result = Util.null2String(rs.getString("selectname"));
|
|
}
|
|
return result;
|
|
}
|
|
|
|
public static String getFieldId(String fieldname){
|
|
RecordSet rs = new RecordSet();
|
|
String fieldid = "field";
|
|
String billid = rs.getPropValue("hrm_shhq","zprcdjlc_billid");
|
|
rs.executeQuery("select * from workflow_billfield where billid=? and viewtype=0 and fieldname=?",billid,fieldname);
|
|
if(rs.next()){
|
|
String id = Util.null2String(rs.getString("id"));
|
|
fieldid += id;
|
|
}
|
|
return fieldid;
|
|
}
|
|
|
|
public static boolean checkHasWorkflow(String sfzhm){
|
|
boolean flag = false;
|
|
RecordSet rs = new RecordSet();
|
|
RecordSet rst = new RecordSet();
|
|
String billid = rs.getPropValue("hrm_shhq","zprcdjlc_billid");
|
|
rs.executeQuery("select * from workflow_bill where id=?",billid);
|
|
rs.next();
|
|
String tablename = Util.null2String(rs.getString("tablename"));
|
|
rs.executeQuery("select * from "+ tablename +" where sfzhm=?",sfzhm);
|
|
while(rs.next()){
|
|
String requestid = Util.null2String(rs.getString("requestid"));
|
|
rst.executeQuery("select currentnodetype from workflow_requestbase where requestid=?",requestid);
|
|
rst.next();
|
|
String currentnodetype = Util.null2String(rst.getString("currentnodetype"));
|
|
//非创建节点
|
|
if(!"0".equals(currentnodetype)){
|
|
flag = true;
|
|
break;
|
|
}else{
|
|
boolean bool = checkHasWorkflowLog(requestid);
|
|
if(bool){
|
|
flag = true;
|
|
break;
|
|
}
|
|
}
|
|
|
|
}
|
|
return flag;
|
|
}
|
|
|
|
public static boolean checkHasWorkflowLog(String requestid){
|
|
boolean flag = false;
|
|
RecordSet rs = new RecordSet();
|
|
rs.executeQuery("select * from workflow_requestlog where logtype='3' and requestid=?",requestid);
|
|
if(rs.next()){
|
|
flag = true;
|
|
}
|
|
return flag;
|
|
}
|
|
|
|
public static String getXlname(String xlid){
|
|
String result = "";
|
|
RecordSet rs = new RecordSet();
|
|
rs.executeQuery("select * from hrmeducationlevel where id=?",xlid);
|
|
if(rs.next()){
|
|
result = Util.null2String(rs.getString("name"));
|
|
}
|
|
return result;
|
|
}
|
|
%>
|
|
|