package cn.com.lzt.userwagestrategy.service.impl; import java.io.Serializable; import java.math.BigDecimal; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.UUID; import org.apache.commons.collections.CollectionUtils; import org.apache.commons.lang3.StringUtils; import org.jeecgframework.core.common.hibernate.qbc.CriteriaQuery; import org.jeecgframework.core.common.model.json.AjaxJson; import org.jeecgframework.core.common.service.impl.CommonServiceImpl; import org.jeecgframework.core.constant.Globals; import org.jeecgframework.core.util.ApplicationContextUtil; import org.jeecgframework.core.util.ListUtils; import org.jeecgframework.core.util.MyBeanUtils; import org.jeecgframework.core.util.MyClassLoader; import org.jeecgframework.core.util.ResourceUtil; import org.jeecgframework.core.util.StringUtil; import org.jeecgframework.core.util.oConvertUtils; import org.jeecgframework.minidao.pojo.MiniDaoPage; import org.jeecgframework.web.cgform.enhance.CgformEnhanceJavaInter; import org.jeecgframework.web.system.pojo.base.TSBaseUser; import org.jeecgframework.web.system.pojo.base.TSDepart; import org.jeecgframework.web.system.pojo.base.TSUser; import org.jeecgframework.web.system.pojo.base.TSUserOrg; import org.jeecgframework.web.system.service.SystemService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import cn.com.lzt.dutyfeestrategy.entity.DutyfeeStrategyEntity; import cn.com.lzt.mealssubsidy.entity.MealsSubsidyEntity; import cn.com.lzt.megathermalsubsidy.entity.MegathermalSubsidyEntity; import cn.com.lzt.othersubsidy.entity.OtherSubsidyEntity; import cn.com.lzt.overtimepaystrategy.entity.OvertimepayStrategyEntity; import cn.com.lzt.personnelbasearchivesmanage.entity.PersonnelBaseArchivesManageEntity; import cn.com.lzt.providentfundstrategy.entity.ProvidentFundStrategyEntity; import cn.com.lzt.socialsecuritystrategy.entity.SocialSecurityStrategyEntity; import cn.com.lzt.trafficsubsidy.entity.TrafficSubsidyEntity; import cn.com.lzt.userchangeslog.entity.UserChangesLogEntity; import cn.com.lzt.userwagestrategy.dao.UserwagestrategyMinidaoDao; import cn.com.lzt.userwagestrategy.dto.UserWagestrategyDto; import cn.com.lzt.userwagestrategy.entity.UserWagestrategyEntity; import cn.com.lzt.userwagestrategy.service.UserWagestrategyServiceI; import cn.com.lzt.wagestrategy.entity.WagestrategyEntity; @Service("userWagestrategyService") @Transactional public class UserWagestrategyServiceImpl extends CommonServiceImpl implements UserWagestrategyServiceI { @Autowired private UserwagestrategyMinidaoDao minidao; @Autowired private SystemService systemService; @Override public BigDecimal getBaseHourWage(String userid) throws Exception{ PersonnelBaseArchivesManageEntity per = null; per = findUniqueByProperty(PersonnelBaseArchivesManageEntity.class,"userid",userid); StringBuffer str = new StringBuffer(); str.append("select * from t_bus_wagestrategy where dutiesid = '"+per.getBelongDutiesid()+"'"); List perobident = null; perobident = this.getSession().createSQLQuery(str.toString()).addEntity(WagestrategyEntity.class).list(); if(perobident != null && !perobident.isEmpty()){ //需要区分是管理层还是一线员工 WagestrategyEntity wa = perobident.get(0); //uw.setDutiesid(wa.getId()); if(wa != null){ //管理层和一线员工统一 //基本工时费 = 基本工资/(21.75*8) BigDecimal bwage = wa.getBasicWage().divide(new BigDecimal(21.75),3,BigDecimal.ROUND_HALF_UP) .divide(new BigDecimal(8),3,BigDecimal.ROUND_HALF_UP); return bwage; } } return BigDecimal.ZERO; } public void delete(UserWagestrategyEntity entity) throws Exception{ super.delete(entity); //执行删除操作增强业务 this.doDelBus(entity); } public Serializable save(UserWagestrategyEntity entity) throws Exception{ Serializable t = super.save(entity); //执行新增操作增强业务 this.doAddBus(entity); return t; } public void saveOrUpdate(UserWagestrategyEntity entity) throws Exception{ super.saveOrUpdate(entity); //执行更新操作增强业务 this.doUpdateBus(entity); } /** * 新增操作增强业务 * @param t * @return */ private void doAddBus(UserWagestrategyEntity t) throws Exception{ //-----------------sql增强 start---------------------------- //-----------------sql增强 end------------------------------ //-----------------java增强 start--------------------------- //-----------------java增强 end----------------------------- } /** * 更新操作增强业务 * @param t * @return */ private void doUpdateBus(UserWagestrategyEntity t) throws Exception{ //-----------------sql增强 start---------------------------- //-----------------sql增强 end------------------------------ //-----------------java增强 start--------------------------- //-----------------java增强 end----------------------------- } /** * 删除操作增强业务 * @param id * @return */ private void doDelBus(UserWagestrategyEntity t) throws Exception{ //-----------------sql增强 start---------------------------- //-----------------sql增强 end------------------------------ //-----------------java增强 start--------------------------- //-----------------java增强 end----------------------------- } // private Map populationMap(UserWagestrategyEntity t){ // Map map = new HashMap(); // map.put("id", t.getId()); // map.put("create_name", t.getCreateName()); // map.put("create_by", t.getCreateBy()); // map.put("create_date", t.getCreateDate()); // map.put("update_name", t.getUpdateName()); // map.put("update_by", t.getUpdateBy()); // map.put("update_date", t.getUpdateDate()); // map.put("sys_org_code", t.getSysOrgCode()); // map.put("sys_company_code", t.getSysCompanyCode()); // map.put("bpm_status", t.getBpmStatus()); // map.put("userid", t.getUserid()); // map.put("belong_unitid", t.getBelongUnitid()); // map.put("dutiesid", t.getDutiesid()); // map.put("overtimepay_strategyid", t.getOvertimepayStrategyid()); // map.put("duty_strategyid", t.getDutyStrategyid()); // map.put("certificate_subsidyid", t.getCertificateSubsidyid()); // map.put("traffic_subsidyid", t.getTrafficSubsidyid()); // map.put("megathermal_subsidyid", t.getMegathermalSubsidyid()); // map.put("nofixedmeals_subsidyid", t.getNofixedmealsSubsidyid()); // map.put("fixedmeals_subsidyid", t.getFixedmealsSubsidyid()); // map.put("other_subsidyid", t.getOtherSubsidyid()); // map.put("social_security_strategyid", t.getSocialSecurityStrategyid()); // map.put("provident_fund_strategyid", t.getProvidentFundStrategyid()); // map.put("append_pay", t.getAppendPay()); // map.put("deduct_pay", t.getDeductPay()); // map.put("onlychild_pay", t.getOnlychildPay()); // map.put("status", t.getStatus()); // map.put("delete_flag", t.getDeleteFlag()); // map.put("strategy_type", t.getStrategyType()); // return map; // } /** * 替换sql中的变量 * @param sql * @param t * @return */ public String replaceVal(String sql,UserWagestrategyEntity t){ sql = sql.replace("#{id}",String.valueOf(t.getId())); sql = sql.replace("#{create_name}",String.valueOf(t.getCreateName())); sql = sql.replace("#{create_by}",String.valueOf(t.getCreateBy())); sql = sql.replace("#{create_date}",String.valueOf(t.getCreateDate())); sql = sql.replace("#{update_name}",String.valueOf(t.getUpdateName())); sql = sql.replace("#{update_by}",String.valueOf(t.getUpdateBy())); sql = sql.replace("#{update_date}",String.valueOf(t.getUpdateDate())); sql = sql.replace("#{sys_org_code}",String.valueOf(t.getSysOrgCode())); sql = sql.replace("#{sys_company_code}",String.valueOf(t.getSysCompanyCode())); sql = sql.replace("#{bpm_status}",String.valueOf(t.getBpmStatus())); sql = sql.replace("#{userid}",String.valueOf(t.getUserid())); sql = sql.replace("#{belong_unitid}",String.valueOf(t.getBelongUnitid())); sql = sql.replace("#{dutiesid}",String.valueOf(t.getDutiesid())); sql = sql.replace("#{overtimepay_strategyid}",String.valueOf(t.getOvertimepayStrategyid())); sql = sql.replace("#{duty_strategyid}",String.valueOf(t.getDutyStrategyid())); sql = sql.replace("#{certificate_subsidyid}",String.valueOf(t.getCertificateSubsidyid())); sql = sql.replace("#{traffic_subsidyid}",String.valueOf(t.getTrafficSubsidyid())); sql = sql.replace("#{megathermal_subsidyid}",String.valueOf(t.getMegathermalSubsidyid())); //sql = sql.replace("#{meals_subsidyid}",String.valueOf(t.getMealsSubsidyid())); sql = sql.replace("#{nofixedmeals_subsidyid}", String.valueOf(t.getNofixedmealsSubsidyid())); sql = sql.replace("#{fixedmeals_subsidyid}", String.valueOf(t.getFixedmealsSubsidyid())); sql = sql.replace("#{other_subsidyid}",String.valueOf(t.getOtherSubsidyid())); sql = sql.replace("#{social_security_strategyid}",String.valueOf(t.getSocialSecurityStrategyid())); sql = sql.replace("#{provident_fund_strategyid}",String.valueOf(t.getProvidentFundStrategyid())); sql = sql.replace("#{append_pay}",String.valueOf(t.getAppendPay())); sql = sql.replace("#{deduct_pay}",String.valueOf(t.getDeductPay())); sql = sql.replace("#{daikou_fee}",String.valueOf(t.getDaikouFee())); sql = sql.replace("#{onlychild_pay}",String.valueOf(t.getOnlychildPay())); sql = sql.replace("#{jiaojin_subsidyid}",String.valueOf(t.getJiaojinSubsidyid())); sql = sql.replace("#{project_performance}",String.valueOf(t.getProjectPerformance())); sql = sql.replace("#{status}",String.valueOf(t.getStatus())); sql = sql.replace("#{delete_flag}",String.valueOf(t.getDeleteFlag())); sql = sql.replace("#{strategy_type}",String.valueOf(t.getStrategyType())); sql = sql.replace("#{UUID}",UUID.randomUUID().toString()); return sql; } /** * 执行JAVA增强 */ private void executeJavaExtend(String cgJavaType,String cgJavaValue,Map data) throws Exception { if(StringUtil.isNotEmpty(cgJavaValue)){ Object obj = null; try { if("class".equals(cgJavaType)){ //因新增时已经校验了实例化是否可以成功,所以这块就不需要再做一次判断 obj = MyClassLoader.getClassByScn(cgJavaValue).newInstance(); }else if("spring".equals(cgJavaType)){ obj = ApplicationContextUtil.getContext().getBean(cgJavaValue); } if(obj instanceof CgformEnhanceJavaInter){ CgformEnhanceJavaInter javaInter = (CgformEnhanceJavaInter) obj; javaInter.execute("t_bus_user_wagestrategy",data); } } catch (Exception e) { e.printStackTrace(); throw new Exception("执行JAVA增强出现异常!"); } } } @Override public AjaxJson addOrEdit(List demos) throws Exception { String message = "操作成功!"; AjaxJson j = new AjaxJson(); if(CollectionUtils.isNotEmpty(demos)){ for(UserWagestrategyEntity jeecgDemo:demos){ jeecgDemo.setDutiesid(jeecgDemo.getDutid()); jeecgDemo.setUserid(jeecgDemo.getUserids()); jeecgDemo.setBelongUnitid(jeecgDemo.getDepartid()); jeecgDemo.setDepartid(jeecgDemo.getDutid()); jeecgDemo.setDeleteFlag(Globals.Delete_Normal.toString()); jeecgDemo.setPjtId(getBybelongId(jeecgDemo.getUserids())); TSBaseUser user = systemService.getEntity(TSBaseUser.class, jeecgDemo.getUserids()); if(StringUtil.isEmpty(jeecgDemo.getDutiesid())) { j.setSuccess(false); j.setMsg("请完善人事信息后再设置工资策略:" +user.getRealName()); return j; } // check用户id的数据是否已经在员工工资策略表中存在 String userWagestrategyByUserIdHql = "from UserWagestrategyEntity where userid = ?"; List userWagestrategyEntityList = findHql(userWagestrategyByUserIdHql, jeecgDemo.getUserid()); if(userWagestrategyEntityList.size() > 0) { jeecgDemo.setId(userWagestrategyEntityList.get(0).getId()); } if (StringUtil.isNotEmpty(jeecgDemo.getId())) { UserWagestrategyEntity t =this.get(UserWagestrategyEntity.class, jeecgDemo.getId()); try { j = this.isParmateNull(jeecgDemo,user); if(j.isSuccess()){ boolean temp = false; if(oConvertUtils.isNotEmpty(jeecgDemo.getSocialSecurityStrategyid()) && oConvertUtils.isNotEmpty(t.getSocialSecurityStrategyid())){ if(!jeecgDemo.getSocialSecurityStrategyid().equals(t.getSocialSecurityStrategyid())){ temp = true; } } message = "员工工资基本策略: " + jeecgDemo.getBelongUnitid() + "被更新成功"; MyBeanUtils.copyBeanNotNull2Bean(jeecgDemo, t); //缴金补贴为空时有特殊业务含义,所以允许空值修改 if(jeecgDemo.getJiaojinSubsidyid() == null) { t.setJiaojinSubsidyid(null); } this.saveOrUpdate(t); if(temp){ changUserChangesLogEntity(t); } systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO); }else{ return j; } } catch (Exception e) { e.printStackTrace(); } } else { try { j = this.isParmateNull(jeecgDemo,user); if(j.isSuccess()){ message = "员工工资基本策略: " + jeecgDemo.getBelongUnitid() + "被添加成功"; this.save(jeecgDemo); systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO); }else{ return j; } } catch (Exception e) { e.printStackTrace(); } } } } return j; } /** * 插入缴金记录 * @param t */ private void changUserChangesLogEntity(UserWagestrategyEntity t){ UserChangesLogEntity ucle = new UserChangesLogEntity(); ucle.setChangeTime(new Date()); TSDepart ts = systemService.get(TSDepart.class, t.getBelongUnitid()); if(ts != null){ ucle.setBelongUnitid(ts.getId()); } TSBaseUser tsBaseUser = systemService.get(TSBaseUser.class,t.getUserid()); if(tsBaseUser != null){ ucle.setUserCode(tsBaseUser.getUserName()); ucle.setUserName(tsBaseUser.getRealName()); } TSUser tSUser=ResourceUtil.getSessionUser(); if(tSUser != null){ ucle.setApplicant(tSUser.getRealName()); } ucle.setChangeType(Globals.CHANGE_TYPE_JIAOJINBIANDONG); SocialSecurityStrategyEntity soc = get(SocialSecurityStrategyEntity.class,t.getSocialSecurityStrategyid()); if(soc != null){ ucle.setPayUnit(soc.getSocialSecurityUnit()); ucle.setPayRemindStatus(Globals.PAY_REMIND_STATUS_0); } String message = "员工【"+tsBaseUser.getRealName()+"】的缴金方式发生了改变!"; this.save(ucle); systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO); } /** * 通过人查询所属项目 * @param userid * @return */ private String getBybelongId(String userid){ String temp = ""; StringBuffer hql = new StringBuffer("from TSUserOrg where tsUser.id = :userid and ifpluralism = 0 and status=0"); List tsList = this.getSession().createQuery(hql.toString()).setParameter("userid", userid).list(); if(!tsList.isEmpty()){ TSUserOrg uo = tsList.get(0); TSDepart tsDepart = uo.getTsDepart(); if("1".equals(tsDepart.getOrgType()) || "3".equals(tsDepart.getOrgType()) || "4".equals(tsDepart.getOrgType()) || "5".equals(tsDepart.getOrgType())){ temp = tsDepart.getId(); }else if("2".equals(tsDepart.getOrgType()) && "1".equals(tsDepart.getTSPDepart().getOrgType())){ temp = tsDepart.getId(); }else{ temp = selectById(tsDepart.getId()); } } return temp; } private String selectById(String id){ String temp = ""; TSDepart tsDepart = getEntity(TSDepart.class,id); if("3".equals(tsDepart.getOrgType()) || "5".equals(tsDepart.getOrgType())){ temp = tsDepart.getId(); }else{ if(tsDepart.getTSPDepart() != null){ selectById(tsDepart.getTSPDepart().getId()); temp = tsDepart.getTSPDepart().getId(); } } return temp; } /** * 判断员工工资策略设定添加选择 * @param jeecgDemo * @param user * @return */ private AjaxJson isParmateNull(UserWagestrategyEntity jeecgDemo,TSBaseUser user){ AjaxJson j = new AjaxJson(); String message = "操作成功!"; j.setSuccess(true); j.setMsg(message); if(StringUtils.isNotEmpty(jeecgDemo.getOvertimepayStrategyid())){ OvertimepayStrategyEntity overtime = systemService.getEntity(OvertimepayStrategyEntity.class,jeecgDemo.getOvertimepayStrategyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于 用户姓名【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】加班费策略选项有误,请重新选择!"; j.setMsg(message); return j; } } if(StringUtils.isNotEmpty(jeecgDemo.getDutyStrategyid())){ DutyfeeStrategyEntity overtime = systemService.getEntity(DutyfeeStrategyEntity.class,jeecgDemo.getDutyStrategyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于用户【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】值班费策略选项有误,请重新选择!"; j.setMsg(message); return j; } } if(StringUtils.isNotEmpty(jeecgDemo.getTrafficSubsidyid())){ TrafficSubsidyEntity overtime = systemService.getEntity(TrafficSubsidyEntity.class,jeecgDemo.getTrafficSubsidyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于用户【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】交通费补贴选项有误,请重新选择!"; j.setMsg(message); return j; } } if(StringUtils.isNotEmpty(jeecgDemo.getMegathermalSubsidyid())){ MegathermalSubsidyEntity overtime = systemService.getEntity(MegathermalSubsidyEntity.class,jeecgDemo.getMegathermalSubsidyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于用户【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】高温补贴选项有误,请重新选择!"; j.setMsg(message); return j; } } if(StringUtils.isNotEmpty(jeecgDemo.getNofixedmealsSubsidyid())){ MealsSubsidyEntity overtime = systemService.getEntity(MealsSubsidyEntity.class,jeecgDemo.getNofixedmealsSubsidyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于用户【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】不固定餐费补贴选项有误,请重新选择!"; j.setMsg(message); return j; } } if(StringUtils.isNotEmpty(jeecgDemo.getFixedmealsSubsidyid())){ MealsSubsidyEntity overtime = systemService.getEntity(MealsSubsidyEntity.class,jeecgDemo.getFixedmealsSubsidyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于用户【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】固定餐费补贴选项有误,请重新选择!"; j.setMsg(message); return j; } } if(StringUtils.isNotEmpty(jeecgDemo.getOtherSubsidyid())){ OtherSubsidyEntity overtime = systemService.getEntity(OtherSubsidyEntity.class,jeecgDemo.getOtherSubsidyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于用户【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】其他补贴选项有误,请重新选择!"; j.setMsg(message); return j; } } if(StringUtils.isNotEmpty(jeecgDemo.getSocialSecurityStrategyid())){ SocialSecurityStrategyEntity overtime = systemService.getEntity(SocialSecurityStrategyEntity.class,jeecgDemo.getSocialSecurityStrategyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于用户【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】社保策略选项有误,请重新选择!"; j.setMsg(message); return j; } } if(StringUtils.isNotEmpty(jeecgDemo.getProvidentFundStrategyid())){ ProvidentFundStrategyEntity overtime = systemService.getEntity(ProvidentFundStrategyEntity.class,jeecgDemo.getProvidentFundStrategyid()); if(overtime == null || !Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) || !Globals.Enabled_Status.toString().equals(overtime.getStatus())){ j.setSuccess(false); message = "操作失败,原因:由于用户【"+user.getRealName()+"】,用户编号【"+user.getUserName()+"】公积金策略选项有误,请重新选择!"; j.setMsg(message); return j; } } return j; } /** * 查询员工工资策略(Minidao方式) */ @Override public MiniDaoPage getAllEntities(UserWagestrategyDto dto, List useridList, int page, int rows, String sql) { return minidao.getAllEntities(dto, useridList, page, rows, sql); } public void businessAccounting(){ /*List list = null; List entityList = systemService.findListbySql("select * from t_bus_user_wagestrategy w " + "where w.status = '0' and delete_flag = '0'"); if(!entityList.isEmpty()){ list = new ArrayList(); UserWageEntity uw = null; for (UserWagestrategyEntity uwe : entityList) { uw = new UserWageEntity(); uw.setUserid(uwe.getId()); uw.setBelongUnitid(uwe.getBelongUnitid()); uw.setDutiesid(uwe.getDutid()); } }*/ } private BigDecimal isOvertimepayStrategy(String id){ BigDecimal big = null; OvertimepayStrategyEntity overtime = systemService.getEntity(OvertimepayStrategyEntity.class,id); if(overtime != null && Globals.Delete_Normal.toString().equals(overtime.getDeleteFlag()) && Globals.Enabled_Status.toString().equals(overtime.getStatus())){ } return big; } @Override public UserWagestrategyEntity getUserWagestrategyEntityByUserId(String userid) throws Exception { UserWagestrategyEntity userWagestrategyEntity = null; if (oConvertUtils.isEmpty(userid)) { return userWagestrategyEntity; } CriteriaQuery cq = new CriteriaQuery(UserWagestrategyEntity.class); cq.eq("userid", userid); cq.add(); cq.eq("deleteFlag", "0"); cq.add(); List resulEntities = getListByCriteriaQuery(cq, false); if (!ListUtils.isNullOrEmpty(resulEntities)) { userWagestrategyEntity = resulEntities.get(0); } return userWagestrategyEntity; } @Override public List getByuserid(String userid) { return minidao.getByuserid(userid); } @Override public MiniDaoPage getExcelPutOut(UserWagestrategyDto dto, List useridList, int page, int rows, String sql) { return minidao.getExcelPutOut(dto, useridList, page, rows, sql); } }