123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160 |
- package com.kingdee.shr.ats.web.handler;
- import java.sql.SQLException;
- import java.util.HashMap;
- import java.util.Map;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import org.slf4j.Logger;
- import org.slf4j.LoggerFactory;
- import org.springframework.ui.ModelMap;
- import com.kingdee.bos.BOSException;
- import com.kingdee.bos.Context;
- import com.kingdee.bos.dao.IObjectPK;
- import com.kingdee.bos.dao.ormapping.ObjectUuidPK;
- import com.kingdee.eas.common.EASBizException;
- import com.kingdee.eas.custom.ats.AtsLeaveBillDetailSameFactory;
- import com.kingdee.eas.custom.ats.AtsLeaveBillDetailSameInfo;
- import com.kingdee.eas.framework.CoreBaseInfo;
- import com.kingdee.eas.hr.ats.AtsLeaveBillCollection;
- import com.kingdee.eas.hr.ats.AtsLeaveBillFactory;
- import com.kingdee.eas.hr.ats.AtsLeaveBillInfo;
- import com.kingdee.eas.hr.ats.HolidayPolicyFactory;
- import com.kingdee.eas.hr.ats.HolidayPolicyInfo;
- import com.kingdee.eas.hr.ats.HolidayTypeFactory;
- import com.kingdee.eas.hr.ats.HolidayTypeInfo;
- import com.kingdee.eas.hr.ats.HolidayTypeUnitEnum;
- import com.kingdee.eas.util.app.DbUtil;
- import com.kingdee.jdbc.rowset.IRowSet;
- import com.kingdee.shr.ats.web.handler.util.AtsLeaveBillOperationUtil;
- import com.kingdee.shr.base.syssetting.context.SHRContext;
- import com.kingdee.shr.base.syssetting.exception.SHRWebException;
- import com.kingdee.shr.base.syssetting.web.json.JSONUtils;
- public class AtsLeaveBillEditHandlerEx extends AtsLeaveBillEditHandler {
-
- private static final Logger logger = LoggerFactory.getLogger(AtsLeaveBillEditHandlerEx.class);
- /**
- * 获取假期信息(根据假期制度)
- * @param request
- * @param response
- * @param modelMap
- * @throws EASBizException
- * @throws BOSException
- * @throws SHRWebException
- */
- public void getLeaveDataAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap) throws EASBizException, BOSException, SHRWebException {
- Context ctx = SHRContext.getInstance().getContext();
- String policyId = request.getParameter("policyId");
- HolidayPolicyInfo policyInfo = HolidayPolicyFactory.getLocalInstance(ctx).getHolidayPolicyInfo(new ObjectUuidPK(policyId));
- HolidayTypeInfo holidayInfo = null;
- if(policyInfo != null && policyInfo.getHolidayType() != null) {
- String holidayTypeId = policyInfo.getHolidayType().getId().toString();
- holidayInfo = HolidayTypeFactory.getLocalInstance(ctx).getHolidayTypeInfo(new ObjectUuidPK(holidayTypeId));
- }
- JSONUtils.writeJson(response, holidayInfo);
- }
-
- /**
- * 根据假期制度获取假期类型单位
- * @param request
- * @param response
- * @param modelMap
- * @throws EASBizException
- * @throws BOSException
- * @throws SHRWebException
- */
- public void getLeaveUnitAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap) throws EASBizException, BOSException, SHRWebException {
- Context ctx = SHRContext.getInstance().getContext();
- String policyId = request.getParameter("policyId");
- HolidayPolicyInfo policyInfo = HolidayPolicyFactory.getLocalInstance(ctx).getHolidayPolicyInfo(new ObjectUuidPK(policyId));
- HolidayTypeUnitEnum unit = policyInfo.getUnit();
- modelMap.put("leaveUnit", unit.getValue());
- JSONUtils.writeJson(response, modelMap);
- }
-
-
- /**
- * 获取假期信息(根据假期类型)
- * @param request
- * @param response
- * @param modelMap
- * @throws EASBizException
- * @throws BOSException
- * @throws SHRWebException
- */
- public void getLeaveDataByTypeAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap) throws EASBizException, BOSException, SHRWebException {
- Context ctx = SHRContext.getInstance().getContext();
- String policyId = request.getParameter("policyId");
- System.out.print("获取假期信息(根据假期类型):" + policyId);
- HolidayTypeInfo holidayInfo = HolidayTypeFactory.getLocalInstance(ctx).getHolidayTypeInfo(new ObjectUuidPK(policyId));
- JSONUtils.writeJson(response, holidayInfo);
-
- }
-
- /**
- * 校验参数查询
- * @param request
- * @param response
- * @param modelMap
- * @throws EASBizException
- * @throws BOSException
- * @throws SQLException
- * @throws SHRWebException
- */
- public void customerCheckParamAction(HttpServletRequest request, HttpServletResponse response, ModelMap modelMap) throws BOSException, SQLException, SHRWebException, EASBizException {
- Context ctx = SHRContext.getInstance().getContext();
- String personId = request.getParameter("personId");
- Map<String,String> returnMap = new HashMap<String,String>();
- // String personSql = "SELECT b.fnumber FROM t_bd_person a " +
- // " left join CT_MP_WorkerCategory b on a.CFWorkercategoryID = b.fid " +
- // " where a.fid = '" + personId + "'";
- String personSql = "SELECT e.fnumber FROM T_BD_Person a "
- + "left join (select b.fpersonid,c.CFWorkercategoryID from (SELECT FPERSONID,max(FEFFDT) as maxDate FROM T_HR_EmpOrgRelation where fassignType = '1' group by FPERSONID) b "
- + "left join T_HR_EmpOrgRelation c on b.fpersonid = c.fpersonid and b.maxdate=c.FEFFDT and c.fassignType = '1') d on a.fid=d.fpersonid "
- + "left join CT_MP_WorkerCategory e on e.fid=d.CFWorkercategoryID "
- + "where a.fid='"+personId+"'";
-
- System.out.print("员工类别查询:" + personSql);
- IRowSet rs = DbUtil.executeQuery(ctx, personSql);
- if(rs.next()) {
- returnMap.put("personType", rs.getString("fnumber"));
- }
- JSONUtils.writeJson(response, returnMap);
- }
-
- /**
- * 请假单提交工作流保存数据至新建的拆分表
- */
- @Override
- protected void afterSubmit(HttpServletRequest request, HttpServletResponse response, CoreBaseInfo model)
- throws SHRWebException {
- logger.info("AtsLeaveBillEditHandlerEx.....afterSubmit...start");
- // TODO 自动生成的方法存根
- super.afterSubmit(request, response, model);
- try {
- Context ctx = SHRContext.getInstance().getContext();
- AtsLeaveBillInfo info=(AtsLeaveBillInfo)model;
- logger.info("AtsLeaveBillEditHandlerEx.....number...",info.getNumber());
-
- logger.info("AtsLeaveBillEditHandlerEx.....BillID...",info.getId().toString());
- //先删除拆分数据
- if(info.getId()!=null ) {
- String billFormatter = "('" + info.getId().toString() + "')";
- AtsLeaveBillOperationUtil.deleteInfo(ctx, billFormatter);
- }
- //审批中的数据存入拆分表
- AtsLeaveBillOperationUtil.saveInfo(ctx, info);
- logger.info("AtsLeaveBillEditHandlerEx.....afterSubmit...end");
- }catch(Exception e) {
-
- }
-
- }
-
-
- }
|