| | |
|---|
| | | package cc.mrbird.febs.server.hr.mapper; |
|---|
| | | |
|---|
| | | import cc.mrbird.febs.common.core.entity.system.DicItem; |
|---|
| | | import cc.mrbird.febs.server.hr.entity.EmpAccessory; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.Wrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
|---|
| | |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | | /** |
|---|
| | |
|---|
| | | public interface EmpAccessoryMapper extends BaseMapper<EmpAccessory> { |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("select * from (select a.empName,a.empId,a.empNumb,a.age,a.archivesStatus,a.sex,a.insuranceType,a.politics,a.education,a.entryDate,a.certificateNumb,(select dept_Name from t_dept as dept where dept.dept_Id= a.deptId) as deptName,a.jobName,b.jljt,b.zp,b.ldht,b.sfz,b.rzb,b.tjb,b.hz,b.yhk,b.xgzj,b.xght,b.qj,b.cf,b.czsq,b.lzsx,b.zl,b.sb,b.syj,b.ywx,b.gs,b.lz from t_emp_baseinfo a left join t_emp_accessory b on a.empId = b.empId where a.delFlag = 0) a ${ew.customSqlSegment}") |
|---|
| | | |
|---|
| | | IPage<Map<String,Object>> selectPageVo(Page<?> page, @Param(Constants.WRAPPER) Wrapper wrapper); |
|---|
| | | |
|---|
| | | String getQuerySql(); |
|---|
| | | |
|---|
| | | List<DicItem> getDictType(@Param("type") String physicalexamtype); |
|---|
| | | |
|---|
| | | List<Map<String,Object>> getEmpAccessoryNumber(@Param("empId") Long empId); |
|---|
| | | |
|---|
| | | } |
|---|
