//
// Source code recreated from a .class file by IntelliJ IDEA
// (powered by FernFlower decompiler)
//

package com.kingdee.shr.affair.web.handler.hrman;

import com.kingdee.bos.BOSException;
import com.kingdee.bos.Context;
import com.kingdee.eas.base.core.hr.util.CnToSpell;
import com.kingdee.eas.util.app.DbUtil;
import com.kingdee.jdbc.rowset.IRowSet;
import com.kingdee.shr.base.syssetting.context.SHRContext;
import com.kingdee.shr.base.syssetting.exception.SHRWebException;
import java.sql.SQLException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.ui.ModelMap;

public class EmpEnrollBizBillHrManEditHandlerEx extends EmpEnrollBizBillHrManEditHandler {
    public EmpEnrollBizBillHrManEditHandlerEx() {
    }

    public void getNamePinYinAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap) throws SHRWebException {
        String personName = this.getIdCordsfilter(request.getParameter("personName"));
        String cnSpell = CnToSpell.getSpell(personName, false);
        StringBuffer namePinYin = new StringBuffer();
        if (this.getPersonNamePinYin(cnSpell) > 0) {
            namePinYin.append(cnSpell).append("0").append(this.getPersonNamePinYin(cnSpell) + 1);
        } else {
            namePinYin.append(cnSpell);
        }

        this.writeSuccessData(namePinYin.toString());
    }

    public void getLaborRelationAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap) throws SHRWebException {
        Context ctx = SHRContext.getInstance().getContext();
        String personName = this.getIdCordsfilter(request.getParameter("personName"));
        String cnSpell = CnToSpell.getSpell(personName, false);
        StringBuffer namePinYin = new StringBuffer();
        StringBuffer namePinYinSX = new StringBuffer();
        if (this.getPersonNamePinYin(cnSpell) > 0) {
            namePinYin.append(cnSpell).append("0").append(this.getPersonNamePinYin(cnSpell) + 1);
        } else {
            namePinYin.append(cnSpell);
        }

        namePinYinSX.append(namePinYin);
        StringBuffer nameBufSql = new StringBuffer();
        nameBufSql.append("select * from T_HR_BDEmployeeType b ").append("inner join T_HR_EmpLaborRelation e on b.FID = e.FLaborRelationStateID ").append("inner join T_BD_Person p on p.FID = e.FPersonID ").append("where b.FID = '").append("2JNc5qoSR7mPF3oNZeqB/qKehbM=").append("'");

        try {
            IRowSet rs = DbUtil.executeQuery(ctx, nameBufSql.toString());
            String size = String.valueOf(rs.size());
            if (size.length() == 1) {
                namePinYinSX.append("00").append(size);
            } else if (size.length() == 2) {
                namePinYinSX.append("0").append(size);
            } else {
                namePinYinSX.append(size);
            }

            namePinYinSX.append("_sx");
        } catch (BOSException var12) {
            var12.printStackTrace();
        }

        this.writeSuccessData(namePinYinSX.toString());
    }

    public void getPositionBolAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap) throws SHRWebException {
        Context ctx = SHRContext.getInstance().getContext();
        String personName = this.getIdCordsfilter(request.getParameter("personName"));

        String personNumber = request.getParameter("personNumber");
        String cn =personName+"_"+personNumber;
        String positionId = request.getParameter("positions");
        StringBuffer sql = new StringBuffer();
        String state = "false";
        sql.append("select * from T_ORG_Admin a inner join T_HR_PersonPosition p on a.FID = p.FPersonDep ").append("inner join T_BD_Person b on b.FID = p.FPersonID ").append("inner join T_ORG_Position s on s.FAdminOrgUnitID = a.FID ").append("inner join T_HR_BDEmployeeType t on b.FEMPLOYEETYPEID = t.FID ").append("where s.FID = '").append(positionId).append("' and b.FZDY2 = '").append(cn).append("' and t.FinService = 1");

        try {
            IRowSet rs = DbUtil.executeQuery(ctx, sql.toString());
            if (!rs.next()) {
                state = "true";
            }
        } catch (BOSException var10) {
            var10.printStackTrace();
        } catch (SQLException var11) {
            var11.printStackTrace();
        }

        this.writeSuccessData(state);
    }

    private String getIdCordsfilter(String str) {
        String[] SqlStr2 = new String[]{"*", "'", ";", "-", "--", "+", "//", "/", "%", "#"};

        for(int i = 0; i < SqlStr2.length; ++i) {
            if (str.indexOf(SqlStr2[i]) >= 0) {
                str = str.replaceAll(SqlStr2[i], "");
            }
        }

        return str;
    }

    private int getPersonNamePinYin(String pinyin) {
        Context ctx = SHRContext.getInstance().getContext();
        StringBuffer sql = new StringBuffer();
        int numbers = 0;
        sql.append("select COUNT").append("(").append("*").append(")").append(" as numbers from T_BD_Person where FFullNamePingYin = '").append(pinyin).append("'");

        try {
            for(IRowSet rs = DbUtil.executeQuery(ctx, sql.toString()); rs.next(); numbers = rs.getInt("numbers")) {
            }
        } catch (BOSException var6) {
            var6.printStackTrace();
        } catch (SQLException var7) {
            var7.printStackTrace();
        }

        return numbers;
    }
}