package com.kingdee.shr.batchAffair.web.handler;

import com.kingdee.bos.BOSException;
import com.kingdee.bos.Context;
import com.kingdee.bos.dao.ormapping.ObjectUuidPK;
import com.kingdee.bos.metadata.entity.SelectorItemCollection;
import com.kingdee.bos.metadata.entity.SelectorItemInfo;
import com.kingdee.eas.basedata.org.AdminOrgUnitInfo;
import com.kingdee.eas.basedata.org.PositionInfo;
import com.kingdee.eas.common.EASBizException;
import com.kingdee.eas.framework.CoreBaseInfo;
import com.kingdee.eas.hr.base.EmpPosOrgRelationFactory;
import com.kingdee.eas.hr.base.EmpPosOrgRelationInfo;
import com.kingdee.eas.hr.base.IEmpPosOrgRelation;
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 com.kingdee.shr.base.syssetting.web.handler.EditHandler;
import com.kingdee.shr.base.syssetting.web.json.JSONUtils;
import com.kingdee.util.StringUtils;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.ui.ModelMap;

public class PlatformPreResignEditHandler  extends EditHandler {
	
	protected void afterCreateNewModel(HttpServletRequest request,
			HttpServletResponse response, CoreBaseInfo coreBaseInfo)
			throws SHRWebException {
		String empPosOrgRelaID = request.getParameter("empPosOrgRelaID");
		if (StringUtils.isEmpty(empPosOrgRelaID)) {
			return;
		}
		Context ctx = SHRContext.getInstance().getContext();
		SelectorItemCollection selectors = new SelectorItemCollection();
		selectors.add(new SelectorItemInfo("person.id"));
		selectors.add(new SelectorItemInfo("person.name"));
		selectors.add(new SelectorItemInfo("person.number"));
		selectors.add(new SelectorItemInfo("adminOrg.displayName"));
		selectors.add(new SelectorItemInfo("position.name"));
		EmpPosOrgRelationInfo empPosOrgRelaInfo = null;
		try {
			empPosOrgRelaInfo = EmpPosOrgRelationFactory.getLocalInstance(ctx)
					.getEmpPosOrgRelationInfo(
							new ObjectUuidPK(empPosOrgRelaID), selectors);
		} catch (EASBizException e) {
			e.printStackTrace();
		} catch (BOSException e) {
			e.printStackTrace();
		}
		coreBaseInfo.put("person", empPosOrgRelaInfo.getPerson());
		coreBaseInfo.put("adminOrgName", empPosOrgRelaInfo.getAdminOrg()
				.getDisplayName());
		coreBaseInfo.put("positionName", empPosOrgRelaInfo.getPosition()
				.getName());
	}

	public String getVariationReasonFilterAction(HttpServletRequest request,
			HttpServletResponse response, ModelMap modelMap)
			throws SHRWebException, BOSException, SQLException {
		Context ctx = SHRContext.getInstance().getContext();
		int bizDefineType = Integer.valueOf(
				request.getParameter("bizDefineType")).intValue();

		StringBuffer buffer = new StringBuffer(
				" select v.fid as id, v.fnumber as number");
		buffer.append(" from T_HR_VariationReason v");
		buffer
				.append(" inner join T_HR_HRBizDefVarReason h on v.fid = h.FVariationReasonID");
		buffer
				.append(" inner join T_HR_HRBizDefine b on b.fid = h.FbizDefineID");
		buffer.append(" where b.FBizDefineType = ");
		buffer.append(bizDefineType);
		IRowSet result = DbUtil.executeQuery(ctx, buffer.toString());
		StringBuffer numbers = new StringBuffer("number in (");
		String numberStr = null;
		while (result.next()) {
			numbers.append("'").append(result.getString("number")).append("',");
		}
		numberStr = numbers.substring(0, numbers.length() - 1) + ")";
		Map data = new HashMap();
		data.put("filter", numberStr);
		JSONUtils.SUCCESS(data);

		return null;
	}

}