YgglController.java 77.6 KB
Newer Older
1 2 3 4 5 6 7
/**
 * @date 2019年11月15日  
 * @author 翁东州
 * @方法中文名称:
 */
package cn.timer.api.controller.yggl;

8
import java.io.IOException;
lal committed
9
import java.text.ParseException;
yuquan.zhu committed
10
import java.text.SimpleDateFormat;
11
import java.util.ArrayList;
12
import java.util.Collections;
13 14 15 16
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
17
import java.util.Map.Entry;
18
import java.util.stream.Collectors;
19

20
import javax.annotation.Resource;
21 22
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
23 24
import javax.transaction.Transactional;

25
import cn.timer.api.utils.redis.RedisUtil;
26
import org.springframework.beans.factory.annotation.Autowired;
27
import org.springframework.beans.factory.annotation.Value;
28
import org.springframework.transaction.interceptor.TransactionAspectSupport;
29
import org.springframework.validation.annotation.Validated;
30 31 32 33 34 35 36 37
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

38
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
39 40 41
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
42
import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
43
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
东州 翁 committed
44
import com.github.pagehelper.util.StringUtil;
45
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
46

47
import cn.hutool.core.bean.BeanUtil;
48
import cn.hutool.core.collection.CollUtil;
49
import cn.hutool.core.collection.CollectionUtil;
东州 翁 committed
50 51
import cn.hutool.core.date.BetweenFormater.Level;
import cn.hutool.core.date.DateUtil;
52
import cn.hutool.core.io.IoUtil;
53 54 55
import cn.hutool.core.lang.tree.Tree;
import cn.hutool.core.lang.tree.TreeNodeConfig;
import cn.hutool.core.lang.tree.TreeUtil;
56
import cn.hutool.core.util.IdcardUtil;
57
import cn.hutool.core.util.ObjectUtil;
58
import cn.hutool.core.util.ReUtil;
59
import cn.hutool.core.util.StrUtil;
60
import cn.hutool.json.JSONObject;
tangzhaoqian committed
61
import cn.hutool.json.JSONUtil;
62 63
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
64
import cn.timer.api.bean.clazz.CommonArea;
65
import cn.timer.api.bean.clazz.SysRegion;
yuquan.zhu committed
66
import cn.timer.api.bean.kqmk.KqglAssoLeaveEmployeeBalance;
lal committed
67
import cn.timer.api.bean.kqmk.KqglAssoLeaveRules;
ilal committed
68
import cn.timer.api.bean.kqmk.KqglAssoYhkqz;
69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
import cn.timer.api.bean.qyzx.QyzxEmpEntAsso;
import cn.timer.api.bean.qyzx.QyzxEmpLogin;
import cn.timer.api.bean.yggl.YgglAttaClfjb;
import cn.timer.api.bean.yggl.YgglAttaCzjlb;
import cn.timer.api.bean.yggl.YgglAttaGzjlb;
import cn.timer.api.bean.yggl.YgglAttaGzk;
import cn.timer.api.bean.yggl.YgglAttaHtxxb;
import cn.timer.api.bean.yggl.YgglAttaJjlxr;
import cn.timer.api.bean.yggl.YgglAttaJyjlb;
import cn.timer.api.bean.yggl.YgglAttaLxxxb;
import cn.timer.api.bean.yggl.YgglAttaPxjlxxb;
import cn.timer.api.bean.yggl.YgglAttaSbgjj;
import cn.timer.api.bean.yggl.YgglAttaZcxxb;
import cn.timer.api.bean.yggl.YgglAttaZszjb;
import cn.timer.api.bean.yggl.YgglMainEmp;
import cn.timer.api.bean.yggl.YgglMainLzb;
import cn.timer.api.bean.zzgl.ZzglBmgwM;
import cn.timer.api.config.annotation.CurrentUser;
import cn.timer.api.config.annotation.UserBean;
太阳与水 committed
88
import cn.timer.api.config.enuminterface.YgEnumInterface;
89
import cn.timer.api.config.enuminterface.YgEnumInterface.jobStatus;
90
import cn.timer.api.config.enums.CommonEnum;
91
import cn.timer.api.config.enums.SysRoleType;
92
import cn.timer.api.config.exception.Regular;
93
import cn.timer.api.config.validation.ValidList;
lal committed
94
import cn.timer.api.controller.kqgl.ClockInTool;
lal committed
95
import cn.timer.api.controller.kqgl.atttimer.RealTimeUpdate;
96
import cn.timer.api.controller.zzgl.service.ZzglBmgwMService;
97
import cn.timer.api.dao.clazz.CommonAreaMapper;
lal committed
98
import cn.timer.api.dao.kqmk.KqglAssoLeaveBalanceMapper;
99
import cn.timer.api.dao.qyzx.QyzxEmpEntAssoMapper;
100
import cn.timer.api.dao.qyzx.QyzxEmpLoginMapper;
101
import cn.timer.api.dao.yggl.YgMzDtoMapper;
102 103 104
import cn.timer.api.dao.yggl.YgglMainEmpMapper;
import cn.timer.api.dao.yggl.YgglMainLzbMapper;
import cn.timer.api.dao.zzgl.ZzglBmgwMMapper;
lal committed
105
import cn.timer.api.dto.kqmk.AdditionalDto;
106
import cn.timer.api.dto.yggl.AddygdaDto;
107
import cn.timer.api.dto.yggl.EmpQuery;
108
import cn.timer.api.dto.yggl.ImportEmpDto;
109
import cn.timer.api.dto.yggl.LoginInfoDto;
110
import cn.timer.api.dto.yggl.LoginerChargeDto;
111 112
import cn.timer.api.dto.yggl.LzbQueryDto;
import cn.timer.api.dto.yggl.LzygQueryDto;
ilal committed
113
import cn.timer.api.dto.yggl.ModifyAvatarDto;
114
import cn.timer.api.dto.yggl.YgCartogramDto;
115
import cn.timer.api.dto.yggl.YgKVDto;
116
import cn.timer.api.dto.yggl.YgQueryDto;
117
import cn.timer.api.dto.yggl.YgbintuDto;
118
import cn.timer.api.dto.yggl.YgglCartogramDto;
东州 翁 committed
119
import cn.timer.api.dto.yggl.YgmzDto;
120
import cn.timer.api.dto.yggl.YgzzDto;
121
import cn.timer.api.utils.DateFormatUtils;
122 123 124 125 126 127 128 129 130 131 132 133 134
import cn.timer.api.utils.Md5;
import cn.timer.api.utils.Result;
import cn.timer.api.utils.ResultUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;

/**
 * @date 2019年11月15日
 * @author 翁东州
 * @方法中文名称:
 */
@Api(tags = "3.员工管理")
@RestController
135
@Transactional(rollbackOn = Exception.class)
136 137 138
@RequestMapping(value = "/yggl", produces = { "application/json" })
public class YgglController {

139 140
	@Value(value = "${config-8timer.init-password}")
	private String pwd;
141

142 143
	@Autowired
	private YgglMainEmpMapper ygglMainEmpMapper;
144

145 146
	@Autowired
	private QyzxEmpEntAssoMapper qyzxEmpEntAssoMapper;
147 148 149 150 151 152

	@Autowired
	private QyzxEmpLoginMapper qyzxEmpLoginMapper;

	@Autowired
	private YgglMainLzbMapper ygglMainLzbMapper;
邓实川 committed
153

154 155
	@Autowired
	private ZzglBmgwMMapper zzglBmgwMMapper;
邓实川 committed
156 157

	// weng(民族)
158 159
	@Autowired
	private YgMzDtoMapper ygMzDtoMapper;
160

161 162 163 164 165 166
	@Resource
	private RedisUtil redisUtil;

	@Value("${server.servlet.session.timeout}")
	public Integer session_timeout;

167
	/**
168
	 * 获取员工档案
邓实川 committed
169
	 * 
170 171 172 173
	 * @param
	 * @return
	 */
	@GetMapping(value = "/ygda")
174
	@ApiOperation(value = "1.获取员工档案", httpMethod = "GET", notes = "接口发布说明")
175 176 177 178
	@ApiOperationSupport(order = 1)
	public Result<YgglMainEmp> selectygda(@CurrentUser UserBean userBean) {
		Integer empNum = userBean.getEmpNum();
		Integer orgCode = userBean.getOrgCode();
179
		YgglMainEmp ygglMainEmp = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda()
180
				.eq(YgglMainEmp::getOrgCode, orgCode).eq(YgglMainEmp::getEmpNum, empNum));
邓实川 committed
181 182 183 184
		Date rz = ygglMainEmp.getRzTime();
		if (rz != null) {
			ygglMainEmp.setWorkTime(DateUtil.formatBetween(rz, new Date(), Level.DAY));
		}
185
		return ResultUtil.data(ygglMainEmp);
186
	}
邓实川 committed
187

东州 翁 committed
188 189
	// 获取员工档案
	@GetMapping(value = "/ygda/{empNum}")
190
	@ApiOperation(value = "2.获取员工档案(管)", httpMethod = "GET", notes = "接口发布说明")
东州 翁 committed
191 192 193
	@ApiOperationSupport(order = 2)
	public Result<YgglMainEmp> selectygda(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
		Integer orgCode = userBean.getOrgCode();
194
		YgglMainEmp ygglMainEmp = YgglMainEmp.builder().build().selectOne(new QueryWrapper<YgglMainEmp>().lambda()
195
				.eq(YgglMainEmp::getOrgCode, orgCode).eq(YgglMainEmp::getEmpNum, empNum));
196 197
		Date rz = ygglMainEmp.getRzTime();
		if (rz != null) {
邓实川 committed
198
			ygglMainEmp.setWorkTime(DateUtil.formatBetween(ygglMainEmp.getRzTime(), new Date(), Level.DAY));
东州 翁 committed
199
		}
200
		return ResultUtil.data(ygglMainEmp);
东州 翁 committed
201
	}
邓实川 committed
202

203 204
	/**
	 * 根据岗位id获取员工档案部门岗位名称
邓实川 committed
205
	 * 
206 207 208
	 * @param
	 * @return
	 */
东州 翁 committed
209
	@GetMapping(value = "/ygdabm/{gwid}")
210
	@ApiOperation(value = "3.获取员工档案部门岗位名称", httpMethod = "GET", notes = "接口发布说明")
东州 翁 committed
211
	@ApiOperationSupport(order = 3)
邓实川 committed
212 213
	public Result<String> selectbmgw(@CurrentUser UserBean userBean, @PathVariable Integer gwid) {
		if (gwid == null || gwid == 0) {
214
			return ResultUtil.data("岗位不存在");
215
		}
216
		Integer orgCode = userBean.getOrgCode();
217 218
		ZzglBmgwM zzglBmgwM = ZzglBmgwM.builder().build().selectOne(
				new QueryWrapper<ZzglBmgwM>().lambda().eq(ZzglBmgwM::getOrgCode, orgCode).eq(ZzglBmgwM::getId, gwid));
邓实川 committed
219 220 221 222 223 224
		String gw = null;
		Integer bmid = null;
		if (zzglBmgwM != null) {
			gw = zzglBmgwM.getName();
			bmid = zzglBmgwM.getUpId();
		}
225 226
		ZzglBmgwM z = ZzglBmgwM.builder().build().selectOne(
				new QueryWrapper<ZzglBmgwM>().lambda().eq(ZzglBmgwM::getOrgCode, orgCode).eq(ZzglBmgwM::getId, bmid));
邓实川 committed
227 228 229 230 231
		String bm = null;
		if (z != null) {
			bm = z.getName();
		}
		String bmgw = bm + "/" + gw;
232
		return ResultUtil.data(bmgw);
邓实川 committed
233 234
	}

lal committed
235 236 237
	
	@Autowired
	private RealTimeUpdate realtimeupdate;
238
	/**
239
	 * 添加员工档案
240
	 * 
241 242
	 * @param userBean
	 * @param addygdaDto
243 244
	 * @return
	 */
东州 翁 committed
245
	@PostMapping(value = "/addygda")
246
	@ApiOperation(value = "4.添加员工档案", httpMethod = "POST", notes = "接口发布说明")
247
	@ApiOperationSupport(order = 4)
248 249
	public Result<Object> addygda(@CurrentUser UserBean userBean, @Validated @RequestBody AddygdaDto addygdaDto)
			throws Exception {
东州 翁 committed
250 251 252 253 254
		Integer orgCode = userBean.getOrgCode();
		String name = addygdaDto.getName();
		String phone = addygdaDto.getPhone();
		Integer zjType = addygdaDto.getZjType();
		String zjNum = addygdaDto.getZjNum();
255 256 257
		boolean isvalid = true;
		switch (zjType) {
		case 0:
258
			isvalid = IdcardUtil.isValidCard15(zjNum) || IdcardUtil.isValidCard18(zjNum);
259 260
			break;
		case 1:
261
			String[] strs = IdcardUtil.isValidCard10(zjNum);
邓实川 committed
262 263 264 265 266 267
			if (strs == null) {
				isvalid = false;
				break;
			}
			String str2 = strs != null && strs.length > 2 ? strs[2] : "false";
			isvalid = "澳门/香港".contains(strs[0]) && "true".equals(str2);
268 269
			break;
		case 2:
270
			isvalid = IdcardUtil.isValidTWCard(zjNum);
271 272 273 274 275 276 277
			break;
		case 3:
			isvalid = ReUtil.isMatch(Regular.PASSPORT1, zjNum) || ReUtil.isMatch(Regular.PASSPORT2, zjNum);
			break;
		default:
			break;
		}
ilal committed
278 279 280
//		if (!isvalid) {
//			return ResultUtil.error("证件格式不对!");
//		}
281

东州 翁 committed
282
		Integer jobType = addygdaDto.getJobType();
283
		Date rzTime = addygdaDto.getRzTime() == null ? new Date() : addygdaDto.getRzTime();
东州 翁 committed
284 285
		Integer syq = addygdaDto.getSyq();
		Integer sex = addygdaDto.getSex();
286
		Integer bmgwId = addygdaDto.getBmgwId();
lal committed
287
		
288

东州 翁 committed
289 290 291
		QyzxEmpLogin login = new LambdaQueryChainWrapper<QyzxEmpLogin>(qyzxEmpLoginMapper)
				.eq(!StrUtil.hasBlank(phone), QyzxEmpLogin::getPhone, phone).one();
		if (login == null) {
292
			// 初始化密码 pwd
293
			login = QyzxEmpLogin.builder().phone(phone).pw(Md5.md5(pwd))
东州 翁 committed
294
					.sts(CommonEnum.U_STS_ON.getType()).orgId(userBean.getOrgCode()).username(name).build();
295
			if (!login.insert()) {
东州 翁 committed
296 297 298
				TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
				return ResultUtil.error("添加员工登录表失败,请检查输入信息");
			}
299
		}
300

301 302 303 304
		YgglMainEmp ygglMainEmp = ygglMainEmpMapper.selectOne(new QueryWrapper<YgglMainEmp>().lambda()
				.eq(YgglMainEmp::getPhone, phone).eq(YgglMainEmp::getOrgCode, orgCode));

		if (ygglMainEmp == null) {
305 306 307
			QyzxEmpEntAsso.builder().empNum(login.getId()).orgCode(orgCode).userType(SysRoleType.U_TYPE_EMP.getType())
					.status(CommonEnum.U_STS_ON.getType()).build().insert();
			ygglMainEmp = YgglMainEmp.builder().name(name).phone(phone).zjType(zjType).zjNum(zjNum).jobType(jobType)
308
					.jobStatus(jobStatus.SHIYONG.getType()).rzTime(rzTime).syq(syq).sex(sex)
309
					.empNum(login.getId()).orgCode(orgCode).bmgwId(bmgwId).build();
lal committed
310 311 312 313 314 315 316 317 318 319 320 321
			
			if(syq == 0) {
				ygglMainEmp.setZzTime(rzTime);
			}else {
				
				String sdf = new SimpleDateFormat("yyyy-MM-dd").format(rzTime);
				
				String zztime = ClockInTool.requires_extra_times(sdf, syq, 4, 1);
				
				ygglMainEmp.setZzTime(ClockInTool.strToDateLong(zztime));
			}
			
东州 翁 committed
322
			ygglMainEmp.insert();
lal committed
323 324
			
			//假期规则初始化
yuquan.zhu committed
325
			String current_time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
lal committed
326 327 328
			List<KqglAssoLeaveRules> rul = KqglAssoLeaveRules.builder().build().selectList(new QueryWrapper<KqglAssoLeaveRules>().lambda().eq(KqglAssoLeaveRules::getOrgCode, orgCode));
			for(KqglAssoLeaveRules r : rul) {
				if(r.getLeaveBalance() == 0) {
yuquan.zhu committed
329
					KqglAssoLeaveEmployeeBalance.builder().leaveRulesId(r.getId()).userid(ygglMainEmp.getEmpNum()).balanceDays(-1).modifyUserid(userBean.getEmpNum()).modifyTimer(current_time).orgCode(userBean.getOrgCode()).build().insert();
lal committed
330
				}else {
yuquan.zhu committed
331
					KqglAssoLeaveEmployeeBalance.builder().leaveRulesId(r.getId()).userid(ygglMainEmp.getEmpNum()).balanceDays(0.0).modifyUserid(userBean.getEmpNum()).modifyTimer(current_time).orgCode(userBean.getOrgCode()).build().insert();
lal committed
332 333 334 335
				}
			}
			
			
lal committed
336 337 338 339 340
			try {
				realtimeupdate.AttendanceTask(userBean.getOrgCode(), ygglMainEmp.getEmpNum(), 2,null);
			} catch (ParseException e) {
				e.printStackTrace();
			}
lal committed
341
			
342
			return ResultUtil.data(ygglMainEmp, "添加员工成功!");
东州 翁 committed
343
		} else {
344
			return ResultUtil.error("该手机号已被使用,请输入正确手机号");
东州 翁 committed
345
		}
346

东州 翁 committed
347
	}
邓实川 committed
348

349
	/**
东州 翁 committed
350
	 * 修改员工档案
邓实川 committed
351
	 * 
352 353 354
	 * @param
	 * @return
	 */
东州 翁 committed
355
	@PostMapping(value = "/updateygda")
356
	@ApiOperation(value = "5.修改员工档案", httpMethod = "POST", notes = "接口发布说明")
太阳与水 committed
357
	@ApiOperationSupport(order = 5)
358 359
	public Result<Object> updateygda(@CurrentUser UserBean userBean, @RequestBody YgglMainEmp ygglMainEmp)
			throws Exception {
360

361 362
		if (ObjectUtil.isAllNotEmpty(ygglMainEmp.getRzTime(), ygglMainEmp.getZzTime())
				&& !DateFormatUtils.getCompareDate(ygglMainEmp.getRzTime(), ygglMainEmp.getZzTime())) {
邓实川 committed
363
			return ResultUtil.error("入职日期 不可以大于 转正日期");
364
		}
365

东州 翁 committed
366
		if (ygglMainEmp.getEmpNum() != null) {
367 368 369
			ygglMainEmp.update(new UpdateWrapper<YgglMainEmp>().lambda()
					.eq(YgglMainEmp::getOrgCode, userBean.getOrgCode())
					.eq(YgglMainEmp::getEmpNum, ygglMainEmp.getEmpNum()));
370

东州 翁 committed
371 372
			return ResultUtil.data(ygglMainEmp, "修改成功");
		}
373
		return ResultUtil.data(ygglMainEmp, "修改成功");
东州 翁 committed
374
	}
邓实川 committed
375

376
	/**
东州 翁 committed
377
	 * 员工搜索
邓实川 committed
378
	 * 
379 380 381
	 * @param
	 * @return
	 */
东州 翁 committed
382
	@PostMapping(value = "/ygquery")
383
	@ApiOperation(value = "6.员工搜索/分页", httpMethod = "POST", notes = "接口发布说明")
太阳与水 committed
384
	@ApiOperationSupport(order = 6)
东州 翁 committed
385 386 387 388 389
	public Result<Object> ygquery(@CurrentUser UserBean userBean, @RequestBody YgQueryDto ygQueryDto) {
		Integer orgCode = userBean.getOrgCode();
		Integer b = ygQueryDto.getBmgwid();
		ArrayList<Integer> bList = new ArrayList<Integer>();
		List<ZzglBmgwM> zzglBmgwMs = new LambdaQueryChainWrapper<ZzglBmgwM>(zzglBmgwMMapper)
邓实川 committed
390
				.eq(ZzglBmgwM::getOrgCode, orgCode).list();
东州 翁 committed
391
		ZzglBmgwM.getDepts(bList, b, zzglBmgwMs);
392

东州 翁 committed
393 394 395
		Integer j = ygQueryDto.getJobStatus();
		Integer t = ygQueryDto.getJobType();
		String q = ygQueryDto.getQuery();
396
		Page<YgglMainEmp> page = new Page<YgglMainEmp>(ygQueryDto.getCurrentPage(), ygQueryDto.getTotalPage());
东州 翁 committed
397
		QueryWrapper<YgglMainEmp> queryWrapper = new QueryWrapper<>();
398
		queryWrapper.lambda()
399 400
				.select(YgglMainEmp::getName, YgglMainEmp::getEmpNum, YgglMainEmp::getBmgwId, YgglMainEmp::getRzTime,
						YgglMainEmp::getJobType, YgglMainEmp::getPhone, YgglMainEmp::getJobStatus)
401
				.ne(YgglMainEmp::getJobStatus, jobStatus.YILIZHI.getType())
402 403
				.eq(YgglMainEmp::getOrgCode, orgCode).eq(t != null && t > -1, YgglMainEmp::getJobType, t)
				.eq(j != null && j > -1, YgglMainEmp::getJobStatus, j)
404 405
				.in(!bList.isEmpty(), YgglMainEmp::getBmgwId, bList)
				.and(!StrUtil.hasBlank(q), wq -> wq.like(YgglMainEmp::getName, q).or().like(YgglMainEmp::getPhone, q));
406

东州 翁 committed
407
		IPage<YgglMainEmp> ygglMainEmpPage = YgglMainEmp.builder().build().selectPage(page, queryWrapper);
408

409
		return ResultUtil.data(ygglMainEmpPage);
410
	}
411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449
	
	@Autowired
	private ZzglBmgwMService zzglBmgwMService;
	
	/**
	 * 员工列表-分页
	 * 
	 * @param
	 * @return
	 */
	@PostMapping(value = "/selects_emp")
	@ApiOperation(value = "6.员工列表-分页", httpMethod = "POST", notes = "员工列表-分页")
	@ApiOperationSupport(order = 6)
	public Result<Object> selectsEmp(@CurrentUser UserBean userBean, @RequestBody EmpQuery empQuery) {
		Integer orgCode = userBean.getOrgCode();
		Integer bmgwId = empQuery.getBmgwid();
		Page<YgglMainEmp> page = new Page<YgglMainEmp>(empQuery.getCurrentPage(), empQuery.getTotalPage());
		List<Integer> empNums = CollUtil.toList();
		
		if (bmgwId != null) {
			List<YgglMainEmp> usersQuery = zzglBmgwMService.selectOtherlistent(userBean.getOrgCode(), bmgwId);
			if (CollectionUtil.isNotEmpty(usersQuery)) {
				empNums = usersQuery.stream().map(YgglMainEmp::getEmpNum).collect(Collectors.toList());
			}else {
				return ResultUtil.data(null);
			}
			
			if (CollectionUtil.isEmpty(empNums)) {
				return ResultUtil.data(null);
			}
		}
		empQuery.setOrgCode(orgCode);
		empQuery.setEmpNums(empNums);
		IPage<YgglMainEmp> ygglMainEmpPage = ygglMainEmpMapper.selectME(page, empQuery);

		List<YgglMainEmp> ygglMainEmps = ygglMainEmpPage.getRecords();
		
		return ResultUtil.data(page, ygglMainEmps);
	}
450

tangzhaoqian committed
451 452 453 454
	/**
	 * 导入员工档案
	 */
	@PostMapping(value = "/import_emp_record")
455
	@ApiOperation(value = "7.导入员工档案", httpMethod = "POST", notes = "接口发布说明")
tangzhaoqian committed
456
	@ApiOperationSupport(order = 7)
457 458
	public Result<JSONObject> importEmpRecord(@CurrentUser UserBean userBean,
			@Validated @RequestBody ValidList<AddygdaDto> listAddygdaDto) throws Exception {
459 460 461 462 463 464

		Integer orgCode = userBean.getOrgCode();
		// 查询所有员工手机号
//		List<QyzxEmpLogin> listEl = qyzxEmpLoginMapper
//				.selectList(new QueryWrapper<QyzxEmpLogin>().lambda()
//						.select(QyzxEmpLogin::getPhone));
465 466 467 468 469 470 471

		List<YgglMainEmp> listMe = ygglMainEmpMapper.selectList(new QueryWrapper<YgglMainEmp>().lambda()
				.eq(YgglMainEmp::getOrgCode, orgCode).select(YgglMainEmp::getPhone, YgglMainEmp::getZjNum));

		listMe = listMe != null
				? listMe.stream().filter(o -> o != null && o.getPhone() != null).collect(Collectors.toList())
				: null;
472 473 474 475 476

		// 抽取 登录表 的phone的集合
		List<String> listPhone = listMe.stream().map(YgglMainEmp::getPhone).collect(Collectors.toList());
		// 抽取 登录表 的zjNum的集合
		List<String> listzjNum = listMe.stream().map(YgglMainEmp::getZjNum).collect(Collectors.toList());
477

478
		List<YgglMainEmp> listYmp = new ArrayList<YgglMainEmp>();
479

480
		// 过滤掉 导入数据中, listPhone已存在 的 phone 的对象集合
481
		List<AddygdaDto> list = listAddygdaDto.stream()
482 483 484
				.filter(o -> o != null && !listPhone.contains(o.getPhone()) && !listzjNum.contains(o.getZjNum()))
				.collect(Collectors.toList());

485
		// 过滤出 导入数据中, listPhone已存在 的 phone 的对象集合
486 487
		List<AddygdaDto> phoneRepetitions = listAddygdaDto.stream()
				.filter(o -> o != null && listPhone.contains(o.getPhone())).collect(Collectors.toList());
488

489
		// 过滤出 导入数据中, listzjNum 已存在 的 ZjNum 的对象集合
490
		List<AddygdaDto> idCardRepetitions = listAddygdaDto.stream()
491
				.filter(o -> o != null && listzjNum.contains(o.getZjNum())).collect(Collectors.toList());
492

493
		List<YgglMainEmp> insertErrors = new ArrayList<YgglMainEmp>();
494

495 496
		YgglMainEmp yme;
		for (AddygdaDto ad : list) {
497

498 499 500 501 502 503 504
			String name = ad.getName();
			String phone = ad.getPhone();
			Integer zjType = ad.getZjType();
			String zjNum = ad.getZjNum();
			boolean isvalid = true;
			switch (zjType) {
			case 0:
505
				isvalid = IdcardUtil.isValidCard15(zjNum) || IdcardUtil.isValidCard18(zjNum);
506 507
				break;
			case 1:
508
				String[] strs = IdcardUtil.isValidCard10(zjNum);
tangzhaoqian committed
509 510 511 512 513 514
				if (strs == null) {
					isvalid = false;
					break;
				}
				String str2 = strs != null && strs.length > 2 ? strs[2] : "false";
				isvalid = "澳门/香港".contains(strs[0]) && "true".equals(str2);
515 516
				break;
			case 2:
517
				isvalid = IdcardUtil.isValidTWCard(zjNum);
518 519 520 521 522 523 524 525 526 527 528 529 530 531 532
				break;
			case 3:
				isvalid = ReUtil.isMatch(Regular.PASSPORT1, zjNum) || ReUtil.isMatch(Regular.PASSPORT2, zjNum);
				break;
			default:
				break;
			}
			if (!isvalid) {
				return ResultUtil.error("证件格式不对!");
			}
			Integer jobType = ad.getJobType();
			Date rzTime = ad.getRzTime() == null ? new Date() : ad.getRzTime();
			Integer syq = ad.getSyq();
			Integer sex = ad.getSex();
			Integer bmgwId = ad.getBmgwId();
533

534 535 536 537
			QyzxEmpLogin login = new LambdaQueryChainWrapper<QyzxEmpLogin>(qyzxEmpLoginMapper)
					.eq(!StrUtil.hasBlank(phone), QyzxEmpLogin::getPhone, phone).one();
			if (login == null) {
				// 初始化密码 pwd
538 539
				login = QyzxEmpLogin.builder().phone(phone).pw(Md5.md5(pwd)).sts(CommonEnum.U_STS_ON.getType())
						.orgId(userBean.getOrgCode()).username(name).build();
540 541 542 543 544 545
				if (!login.insert()) {
					TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
					return ResultUtil.error("添加员工登录表失败,请检查输入信息");
				}
			}

546 547 548 549 550
			QyzxEmpEntAsso.builder().empNum(login.getId()).orgCode(orgCode).userType(SysRoleType.U_TYPE_EMP.getType())
					.status(CommonEnum.U_STS_ON.getType()).build().insert();// usertype2普通员工 status1正常
			yme = YgglMainEmp.builder().name(name).phone(phone).zjType(zjType).zjNum(zjNum).jobType(jobType)
					.jobStatus(YgEnumInterface.jobStatus.SHIYONG.getType()).rzTime(rzTime).syq(syq).sex(sex)
					.empNum(login.getId()).orgCode(orgCode).bmgwId(bmgwId).build();
551 552
			if (yme.insert()) {
				listYmp.add(yme);
553
			} else {
554
				// 存放 插入失败的 数据
555
				insertErrors.add(yme);
556
			}
ilal committed
557 558 559 560 561 562 563 564 565 566 567 568 569 570 571
			
			
			
			//假期规则初始化
			String current_time = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
			List<KqglAssoLeaveRules> rul = KqglAssoLeaveRules.builder().build().selectList(new QueryWrapper<KqglAssoLeaveRules>().lambda().eq(KqglAssoLeaveRules::getOrgCode, orgCode));
			for(KqglAssoLeaveRules r : rul) {
				if(r.getLeaveBalance() == 0) {
					KqglAssoLeaveEmployeeBalance.builder().leaveRulesId(r.getId()).userid(login.getId()).balanceDays(-1).modifyUserid(userBean.getEmpNum()).modifyTimer(current_time).orgCode(userBean.getOrgCode()).build().insert();
				}else {
					KqglAssoLeaveEmployeeBalance.builder().leaveRulesId(r.getId()).userid(login.getId()).balanceDays(0.0).modifyUserid(userBean.getEmpNum()).modifyTimer(current_time).orgCode(userBean.getOrgCode()).build().insert();
				}
			}
			
			
572
		}
573

574 575 576
		JSONObject obj = JSONUtil.createObj();
		obj.set("empList", listYmp);
		obj.set("phoneRepetitions", phoneRepetitions);
577 578
		obj.set("idCardRepetitions", idCardRepetitions);
		obj.set("insertErrors", insertErrors);
579 580 581

		// listEl.stream().filter(i -> i !=
		// null).collect(Collectors.<QyzxEmpLogin>toList());
582
		return ResultUtil.data(obj, "导入员工档案成功!");
tangzhaoqian committed
583
	}
584

585
	/**
586
	 * 获取导入模板
邓实川 committed
587
	 * 
588 589
	 * @param
	 * @return
590
	 * @throws IOException
591
	 */
592 593 594 595
	@GetMapping(value = "/impoet_template")
	@ApiOperation(value = "8.获取导入模板", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 8)
	public Result<Object> getImpoetTemplate(HttpServletResponse response) throws IOException {
596
		ImportEmpDto ied = ImportEmpDto.builder().name("张三").phone("15219671123")
597
				// 证件类型 0:身份证;1:港澳居民来往内地通行证;2:台湾居民来往大陆通行证;3:外国护照;4:其他
598
				.zjType(0).zjNum("445381199611063586")
599
				// 工作性质 0全职、1实习生、2兼职、3劳务派遣、4劳务、5派遣、6外包、7退休返聘
600
				.jobType(0).rzTime("2010-10-10 10:10:10")
601 602 603
				// 试用期 0:无试用期;1:1个月;2:2个月;3:3个月;4:4个月;5:5个月;6:6个月(有试用期显示选项)
				.syq(1)
				// 性别 0:男;1:女
604
				.sex(0).build();
605 606 607 608
		List<ImportEmpDto> listAd = CollUtil.newArrayList(ied);
		// 通过工具类创建writer
		ExcelWriter writer = ExcelUtil.getWriter(true);

609
		// 自定义标题别名
610 611 612 613 614 615 616 617
		writer.addHeaderAlias("name", "姓名");
		writer.addHeaderAlias("phone", "手机号");
		writer.addHeaderAlias("sex", "性别");
		writer.addHeaderAlias("zjType", "证件类型 0:身份证;1:港澳居民来往内地通行证;2:台湾居民来往大陆通行证;3:外国护照;4:其他");
		writer.addHeaderAlias("zjNum", "证件号");
		writer.addHeaderAlias("jobType", "工作性质 0全职、1实习生、2兼职、3劳务派遣、4劳务、5派遣、6外包、7退休返聘");
		writer.addHeaderAlias("syq", "试用期 0:无试用期;1:1个月;2:2个月;3:3个月;4:4个月;5:5个月;6:6个月(有试用期显示选项)");
		writer.addHeaderAlias("rzTime", "入职日期");
618

619 620 621 622 623 624 625 626
		// 合并单元格后的标题行,使用默认标题样式
		writer.merge(7, "员工导入模板");
		writer.setFreezePane(2);
		writer.setColumnWidth(1, 15);
		writer.setColumnWidth(4, 22);
		writer.setColumnWidth(7, 20);
		// 一次性写出内容,使用默认样式,强制输出标题
		writer.write(listAd, true);
627 628 629

		response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
		response.setHeader("Content-Disposition", "attachment;filename=8timer_emp_import.xlsx");
630 631
		ServletOutputStream out = response.getOutputStream();
		writer.flush(out, true);
632

633 634
		// 关闭writer,释放内存
		writer.close();
635
		// 此处记得关闭输出Servlet流
636
		IoUtil.close(out);
637

638
		return ResultUtil.data(null, "获取模板成功");
邓实川 committed
639

东州 翁 committed
640
	}
邓实川 committed
641

太阳与水 committed
642
	/**
东州 翁 committed
643
	 * 导出员工
邓实川 committed
644
	 * 
太阳与水 committed
645 646 647
	 * @param
	 * @return
	 */
东州 翁 committed
648
	@GetMapping(value = "/ygdas")
649 650
	@ApiOperation(value = "9.导出员工", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 9)
东州 翁 committed
651
	public Result<List<YgglMainEmp>> selectygdas(@CurrentUser UserBean userBean) {
邓实川 committed
652
		List<YgglMainEmp> list = new LambdaQueryChainWrapper<YgglMainEmp>(ygglMainEmpMapper)
653
				.eq(YgglMainEmp::getOrgCode, userBean.getOrgCode()).in(YgglMainEmp::getJobStatus, jobStatus.SHIYONG.getType(), jobStatus.ZHENSHI.getType(), jobStatus.LIZHIZHONG.getType()).list();
东州 翁 committed
654
		return ResultUtil.data(list, "导出员工成功");
太阳与水 committed
655
	}
邓实川 committed
656

太阳与水 committed
657
	/**
东州 翁 committed
658
	 * 获取员工教育经历表
邓实川 committed
659
	 * 
太阳与水 committed
660 661 662
	 * @param
	 * @return
	 */
东州 翁 committed
663
	@GetMapping(value = "/jyjlb")
664 665
	@ApiOperation(value = "10.获取员工教育经历表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 10)
东州 翁 committed
666
	public Result<List<YgglAttaJyjlb>> selectjyjlb(@CurrentUser UserBean userBean) {
667 668 669
		List<YgglAttaJyjlb> ygglAttaJyjlbss = YgglAttaJyjlb.builder().build().selectList(
				new QueryWrapper<YgglAttaJyjlb>().lambda().eq(YgglAttaJyjlb::getOrgCode, userBean.getOrgCode())
						.eq(YgglAttaJyjlb::getEmpNum, userBean.getEmpNum()));
670
		return ResultUtil.data(ygglAttaJyjlbss);
东州 翁 committed
671
	}
邓实川 committed
672

东州 翁 committed
673 674
	// 获取员工教育经历表
	@GetMapping(value = "/jyjlb/{empNum}")
675 676
	@ApiOperation(value = "11.获取员工教育经历表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 11)
东州 翁 committed
677
	public Result<List<YgglAttaJyjlb>> selectjyjlb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
678 679 680
		List<YgglAttaJyjlb> ygglAttaJyjlbs = YgglAttaJyjlb.builder().build()
				.selectList(new QueryWrapper<YgglAttaJyjlb>().lambda()
						.eq(YgglAttaJyjlb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaJyjlb::getEmpNum, empNum));
681
		return ResultUtil.data(ygglAttaJyjlbs);
东州 翁 committed
682
	}
邓实川 committed
683

东州 翁 committed
684 685
	/**
	 * 添加/修改员工教育经历表
邓实川 committed
686
	 * 
太阳与水 committed
687 688 689
	 * @param
	 * @return
	 */
东州 翁 committed
690
	@PostMapping(value = "/jyjlb")
691 692
	@ApiOperation(value = "12.添加/修改员工教育经历表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 12)
东州 翁 committed
693 694 695 696
	public Result<YgglAttaJyjlb> addjyjlb(@CurrentUser UserBean userBean, @RequestBody YgglAttaJyjlb ygglAttaJyjlb) {
		ygglAttaJyjlb.setEmpNum(ygglAttaJyjlb.getEmpNum());
		ygglAttaJyjlb.setOrgCode(userBean.getOrgCode());
		ygglAttaJyjlb.insertOrUpdate();
697
		return ResultUtil.data(ygglAttaJyjlb, "修改员工教育经历表成功");
太阳与水 committed
698
	}
邓实川 committed
699

太阳与水 committed
700
	/**
东州 翁 committed
701
	 * 删除员工教育经历表
邓实川 committed
702
	 * 
东州 翁 committed
703 704
	 * @param
	 * @return
太阳与水 committed
705
	 */
东州 翁 committed
706
	@DeleteMapping(value = "/jyjlb/{id}")
707 708
	@ApiOperation(value = "13.删除员工教育经历表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 13)
东州 翁 committed
709
	public Result<Boolean> deljyjlb(@CurrentUser UserBean userBean, @PathVariable Integer id) {
太阳与水 committed
710
		Integer orgCode = userBean.getOrgCode();
711 712
		return ResultUtil.data(YgglAttaJyjlb.builder().build().delete(new QueryWrapper<YgglAttaJyjlb>().lambda()
				.eq(YgglAttaJyjlb::getOrgCode, orgCode).eq(YgglAttaJyjlb::getId, id)), "删除员工教育经历表成功");
太阳与水 committed
713
	}
邓实川 committed
714

东州 翁 committed
715 716
	/**
	 * 获取员工培训经历信息表
邓实川 committed
717
	 * 
东州 翁 committed
718 719 720 721
	 * @param
	 * @return
	 */
	@GetMapping(value = "/pxjlxxb")
722 723
	@ApiOperation(value = "14.获取员工培训经历信息表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 14)
东州 翁 committed
724
	public Result<List<YgglAttaPxjlxxb>> selectpxjlxxb(@CurrentUser UserBean userBean) {
邓实川 committed
725
		List<YgglAttaPxjlxxb> ygglAttaPxjlxxbs = YgglAttaPxjlxxb.builder().build()
726 727 728
				.selectList(new QueryWrapper<YgglAttaPxjlxxb>().lambda()
						.eq(YgglAttaPxjlxxb::getOrgCode, userBean.getOrgCode())
						.eq(YgglAttaPxjlxxb::getEmpNum, userBean.getEmpNum()));
729
		return ResultUtil.data(ygglAttaPxjlxxbs);
东州 翁 committed
730
	}
邓实川 committed
731

东州 翁 committed
732 733
	// 获取员工培训经历信息表
	@GetMapping(value = "/pxjlxxb/{empNum}")
734 735
	@ApiOperation(value = "15.获取员工培训经历信息表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 15)
东州 翁 committed
736
	public Result<List<YgglAttaPxjlxxb>> selectpxjlxxb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
737 738 739
		List<YgglAttaPxjlxxb> ygglAttaPxjlxxbs = YgglAttaPxjlxxb.builder().build()
				.selectList(new QueryWrapper<YgglAttaPxjlxxb>().lambda()
						.eq(YgglAttaPxjlxxb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaPxjlxxb::getEmpNum, empNum));
740
		return ResultUtil.data(ygglAttaPxjlxxbs);
东州 翁 committed
741
	}
邓实川 committed
742

东州 翁 committed
743 744
	/**
	 * 添加/修改员工培训经历信息表
邓实川 committed
745
	 * 
东州 翁 committed
746 747 748 749
	 * @param
	 * @return
	 */
	@PostMapping(value = "/pxjlxxb")
750 751
	@ApiOperation(value = "16.添加/修改员工培训经历信息表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 16)
东州 翁 committed
752 753 754 755 756
	public Result<YgglAttaPxjlxxb> addpxjlxxb(@CurrentUser UserBean userBean,
			@RequestBody YgglAttaPxjlxxb ygglAttaPxjlxxb) {
		ygglAttaPxjlxxb.setEmpNum(ygglAttaPxjlxxb.getEmpNum());
		ygglAttaPxjlxxb.setOrgCode(userBean.getOrgCode());
		ygglAttaPxjlxxb.insertOrUpdate();
757
		return ResultUtil.data(ygglAttaPxjlxxb, "修改员工培训经历信息表成功");
758
	}
邓实川 committed
759

东州 翁 committed
760 761
	/**
	 * 删除员工培训经历信息表
邓实川 committed
762
	 * 
东州 翁 committed
763 764 765 766
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/pxjlxxb/{id}")
767 768
	@ApiOperation(value = "17.删除员工培训经历信息表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 17)
东州 翁 committed
769 770
	public Result<Boolean> delpxjlxxb(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
771 772
		return ResultUtil.data(YgglAttaPxjlxxb.builder().build().delete(new QueryWrapper<YgglAttaPxjlxxb>().lambda()
				.eq(YgglAttaPxjlxxb::getOrgCode, orgCode).eq(YgglAttaPxjlxxb::getId, id)), "删除员工培训经历信息表成功");
东州 翁 committed
773
	}
邓实川 committed
774

东州 翁 committed
775 776
	/**
	 * 获取员工工作经历表
邓实川 committed
777
	 * 
东州 翁 committed
778 779 780 781
	 * @param
	 * @return
	 */
	@GetMapping(value = "/gzjlb")
782 783
	@ApiOperation(value = "18.获取员工工作经历表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 18)
东州 翁 committed
784
	public Result<List<YgglAttaGzjlb>> selectgzjlb(@CurrentUser UserBean userBean) {
785 786
		List<YgglAttaGzjlb> ygglAttaGzjlbs = YgglAttaGzjlb.builder().build().selectList(
				new QueryWrapper<YgglAttaGzjlb>().lambda().eq(YgglAttaGzjlb::getOrgCode, userBean.getOrgCode())
787
						.eq(YgglAttaGzjlb::getEmpNum, userBean.getEmpNum()));
788
		return ResultUtil.data(ygglAttaGzjlbs);
太阳与水 committed
789
	}
邓实川 committed
790

太阳与水 committed
791 792
	// 获取员工工作经历表
	@GetMapping(value = "/gzjlb/{empNum}")
793 794
	@ApiOperation(value = "19.获取员工工作经历表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 19)
太阳与水 committed
795
	public Result<List<YgglAttaGzjlb>> selectgzjlb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
796 797 798
		List<YgglAttaGzjlb> ygglAttaGzjlbs = YgglAttaGzjlb.builder().build()
				.selectList(new QueryWrapper<YgglAttaGzjlb>().lambda()
						.eq(YgglAttaGzjlb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaGzjlb::getEmpNum, empNum));
799
		return ResultUtil.data(ygglAttaGzjlbs);
太阳与水 committed
800
	}
邓实川 committed
801

东州 翁 committed
802 803
	/**
	 * 添加/修改员工工作经历表
邓实川 committed
804
	 * 
东州 翁 committed
805 806 807 808
	 * @param
	 * @return
	 */
	@PostMapping(value = "/gzjlb")
809 810
	@ApiOperation(value = "20.添加/修改员工工作经历表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 20)
东州 翁 committed
811 812 813 814
	public Result<YgglAttaGzjlb> addgzjlb(@CurrentUser UserBean userBean, @RequestBody YgglAttaGzjlb ygglAttaGzjlb) {
		ygglAttaGzjlb.setEmpNum(ygglAttaGzjlb.getEmpNum());
		ygglAttaGzjlb.setOrgCode(userBean.getOrgCode());
		ygglAttaGzjlb.insertOrUpdate();
815
		return ResultUtil.data(ygglAttaGzjlb, "修改员工工作经历表成功");
东州 翁 committed
816
	}
邓实川 committed
817

东州 翁 committed
818 819
	/**
	 * 删除员工工作经历表
邓实川 committed
820
	 * 
东州 翁 committed
821 822 823 824
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/gzjlb/{id}")
825 826
	@ApiOperation(value = "21.删除员工工作经历表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 21)
东州 翁 committed
827 828
	public Result<Boolean> delgzjlb(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
829 830
		return ResultUtil.data(YgglAttaGzjlb.builder().build().delete(new QueryWrapper<YgglAttaGzjlb>().lambda()
				.eq(YgglAttaGzjlb::getOrgCode, orgCode).eq(YgglAttaGzjlb::getId, id)), "删除员工工作经历表成功");
东州 翁 committed
831
	}
邓实川 committed
832

东州 翁 committed
833 834
	/**
	 * 获取员工职称信息表
邓实川 committed
835
	 * 
东州 翁 committed
836 837 838 839
	 * @param
	 * @return
	 */
	@GetMapping(value = "/zcxxb")
840 841
	@ApiOperation(value = "22.获取员工职称信息表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 22)
东州 翁 committed
842
	public Result<List<YgglAttaZcxxb>> selectzcxxb(@CurrentUser UserBean userBean) {
843 844
		List<YgglAttaZcxxb> ygglAttaZcxxbs = YgglAttaZcxxb.builder().build().selectList(
				new QueryWrapper<YgglAttaZcxxb>().lambda().eq(YgglAttaZcxxb::getOrgCode, userBean.getOrgCode())
845
						.eq(YgglAttaZcxxb::getEmpNum, userBean.getEmpNum()));
846
		return ResultUtil.data(ygglAttaZcxxbs);
东州 翁 committed
847
	}
邓实川 committed
848

太阳与水 committed
849 850
	// 获取员工职称信息表
	@GetMapping(value = "/zcxxb/{empNum}")
851 852
	@ApiOperation(value = "23.获取员工职称信息表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 23)
太阳与水 committed
853
	public Result<List<YgglAttaZcxxb>> selectzcxxb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
854 855 856
		List<YgglAttaZcxxb> ygglAttaZcxxbs = YgglAttaZcxxb.builder().build()
				.selectList(new QueryWrapper<YgglAttaZcxxb>().lambda()
						.eq(YgglAttaZcxxb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaZcxxb::getEmpNum, empNum));
857
		return ResultUtil.data(ygglAttaZcxxbs);
太阳与水 committed
858
	}
邓实川 committed
859

东州 翁 committed
860 861
	/**
	 * 添加/修改员工职称信息表
邓实川 committed
862
	 * 
东州 翁 committed
863 864 865 866
	 * @param
	 * @return
	 */
	@PostMapping(value = "/zcxxb")
867 868
	@ApiOperation(value = "24.添加/修改员工职称信息表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 24)
东州 翁 committed
869 870 871 872
	public Result<YgglAttaZcxxb> addzcxxb(@CurrentUser UserBean userBean, @RequestBody YgglAttaZcxxb ygglAttaZcxxb) {
		ygglAttaZcxxb.setEmpNum(ygglAttaZcxxb.getEmpNum());
		ygglAttaZcxxb.setOrgCode(userBean.getOrgCode());
		ygglAttaZcxxb.insertOrUpdate();
873
		return ResultUtil.data(ygglAttaZcxxb, "修改员工职称信息表成功");
东州 翁 committed
874
	}
邓实川 committed
875

东州 翁 committed
876 877
	/**
	 * 删除员工职称信息表
邓实川 committed
878
	 * 
东州 翁 committed
879 880 881 882
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/zcxxb/{id}")
883 884
	@ApiOperation(value = "25.删除员工职称信息表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 25)
东州 翁 committed
885 886
	public Result<Boolean> delzcxxb(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
887 888
		return ResultUtil.data(YgglAttaZcxxb.builder().build().delete(new QueryWrapper<YgglAttaZcxxb>().lambda()
				.eq(YgglAttaZcxxb::getOrgCode, orgCode).eq(YgglAttaZcxxb::getId, id)), "删除员工职称信息表成功");
东州 翁 committed
889
	}
邓实川 committed
890

东州 翁 committed
891 892
	/**
	 * 获取员工证书证件表
邓实川 committed
893
	 * 
东州 翁 committed
894 895 896 897
	 * @param
	 * @return
	 */
	@GetMapping(value = "/zszjb")
898 899
	@ApiOperation(value = "26.获取员工证书证件表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 26)
东州 翁 committed
900
	public Result<List<YgglAttaZszjb>> selectzszjb(@CurrentUser UserBean userBean) {
901 902 903
		List<YgglAttaZszjb> ygglAttaZszjbs = YgglAttaZszjb.builder().build().selectList(
				new QueryWrapper<YgglAttaZszjb>().lambda().eq(YgglAttaZszjb::getOrgCode, userBean.getOrgCode())
						.eq(YgglAttaZszjb::getEmpNum, userBean.getEmpNum()));
904
		return ResultUtil.data(ygglAttaZszjbs);
东州 翁 committed
905
	}
邓实川 committed
906

太阳与水 committed
907 908
	// 获取员工证书证件表
	@GetMapping(value = "/zszjb/{empNum}")
909 910
	@ApiOperation(value = "27.获取员工证书证件表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 27)
太阳与水 committed
911
	public Result<List<YgglAttaZszjb>> selectzszjb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
912 913 914
		List<YgglAttaZszjb> ygglAttaZszjbs = YgglAttaZszjb.builder().build()
				.selectList(new QueryWrapper<YgglAttaZszjb>().lambda()
						.eq(YgglAttaZszjb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaZszjb::getEmpNum, empNum));
915
		return ResultUtil.data(ygglAttaZszjbs);
太阳与水 committed
916
	}
邓实川 committed
917

东州 翁 committed
918 919
	/**
	 * 添加/修改员工证书证件表
邓实川 committed
920
	 * 
东州 翁 committed
921 922 923 924
	 * @param
	 * @return
	 */
	@PostMapping(value = "/zszjb")
925 926
	@ApiOperation(value = "28.添加/修改员工证书证件表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 28)
东州 翁 committed
927 928 929 930
	public Result<YgglAttaZszjb> addzszjb(@CurrentUser UserBean userBean, @RequestBody YgglAttaZszjb ygglAttaZszjb) {
		ygglAttaZszjb.setEmpNum(ygglAttaZszjb.getEmpNum());
		ygglAttaZszjb.setOrgCode(userBean.getOrgCode());
		ygglAttaZszjb.insertOrUpdate();
931
		return ResultUtil.data(ygglAttaZszjb, "修改员工证书证件表成功");
太阳与水 committed
932
	}
邓实川 committed
933

东州 翁 committed
934 935
	/**
	 * 删除员工证书证件表
邓实川 committed
936
	 * 
东州 翁 committed
937 938 939 940
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/zszjb/{id}")
941 942
	@ApiOperation(value = "29.删除员工证书证件表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 29)
东州 翁 committed
943 944
	public Result<Boolean> delzszjb(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
945 946
		return ResultUtil.data(YgglAttaZszjb.builder().build().delete(new QueryWrapper<YgglAttaZszjb>().lambda()
				.eq(YgglAttaZszjb::getOrgCode, orgCode).eq(YgglAttaZszjb::getId, id)), "删除员工证书证件表成功");
太阳与水 committed
947
	}
邓实川 committed
948

东州 翁 committed
949 950
	/**
	 * 获取员工联系信息表
邓实川 committed
951
	 * 
东州 翁 committed
952 953 954 955
	 * @param
	 * @return
	 */
	@GetMapping(value = "/lxxxb")
956 957
	@ApiOperation(value = "30.获取员工联系信息表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 30)
东州 翁 committed
958
	public Result<List<YgglAttaLxxxb>> selectlxxxb(@CurrentUser UserBean userBean) {
959 960
		List<YgglAttaLxxxb> ygglAttaLxxxbs = YgglAttaLxxxb.builder().build().selectList(
				new QueryWrapper<YgglAttaLxxxb>().lambda().eq(YgglAttaLxxxb::getOrgCode, userBean.getOrgCode())
961
						.eq(YgglAttaLxxxb::getEmpNum, userBean.getEmpNum()));
962
		return ResultUtil.data(ygglAttaLxxxbs);
东州 翁 committed
963
	}
邓实川 committed
964

东州 翁 committed
965 966
	// 获取员工联系信息表
	@GetMapping(value = "/lxxxb/{empNum}")
967 968
	@ApiOperation(value = "31.获取员工联系信息表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 31)
东州 翁 committed
969
	public Result<List<YgglAttaLxxxb>> selectlxxxb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
970 971 972
		List<YgglAttaLxxxb> ygglAttaLxxxbs = YgglAttaLxxxb.builder().build()
				.selectList(new QueryWrapper<YgglAttaLxxxb>().lambda()
						.eq(YgglAttaLxxxb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaLxxxb::getEmpNum, empNum));
973
		return ResultUtil.data(ygglAttaLxxxbs);
东州 翁 committed
974
	}
邓实川 committed
975

东州 翁 committed
976 977
	/**
	 * 添加/修改员工联系信息表
邓实川 committed
978
	 * 
东州 翁 committed
979 980 981 982
	 * @param
	 * @return
	 */
	@PostMapping(value = "/lxxxb")
983 984
	@ApiOperation(value = "32.添加/修改员工联系信息表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 32)
东州 翁 committed
985 986 987 988
	public Result<YgglAttaLxxxb> addlxxxb(@CurrentUser UserBean userBean, @RequestBody YgglAttaLxxxb ygglAttaLxxxb) {
		ygglAttaLxxxb.setEmpNum(ygglAttaLxxxb.getEmpNum());
		ygglAttaLxxxb.setOrgCode(userBean.getOrgCode());
		ygglAttaLxxxb.insertOrUpdate();
989
		return ResultUtil.data(ygglAttaLxxxb, "修改员工联系信息表成功");
东州 翁 committed
990
	}
邓实川 committed
991

东州 翁 committed
992 993
	/**
	 * 删除员工联系信息表
邓实川 committed
994
	 * 
东州 翁 committed
995 996 997 998
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/lxxxb/{id}")
999 1000
	@ApiOperation(value = "33.删除员工联系信息表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 33)
东州 翁 committed
1001 1002
	public Result<Boolean> dellxxxb(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
1003 1004
		return ResultUtil.data(YgglAttaLxxxb.builder().build().delete(new QueryWrapper<YgglAttaLxxxb>().lambda()
				.eq(YgglAttaLxxxb::getOrgCode, orgCode).eq(YgglAttaLxxxb::getId, id)), "删除员工联系信息表成功");
东州 翁 committed
1005
	}
邓实川 committed
1006

东州 翁 committed
1007 1008
	/**
	 * 获取员工紧急联系人表
邓实川 committed
1009
	 * 
东州 翁 committed
1010 1011 1012 1013
	 * @param
	 * @return
	 */
	@GetMapping(value = "/jjlxr")
1014 1015
	@ApiOperation(value = "34.获取员工紧急联系人表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 34)
东州 翁 committed
1016
	public Result<List<YgglAttaJjlxr>> selectjjlxr(@CurrentUser UserBean userBean) {
1017 1018
		List<YgglAttaJjlxr> ygglAttaJjlxrs = YgglAttaJjlxr.builder().build().selectList(
				new QueryWrapper<YgglAttaJjlxr>().lambda().eq(YgglAttaJjlxr::getOrgCode, userBean.getOrgCode())
1019
						.eq(YgglAttaJjlxr::getEmpNum, userBean.getEmpNum()));
1020
		return ResultUtil.data(ygglAttaJjlxrs);
东州 翁 committed
1021
	}
邓实川 committed
1022

东州 翁 committed
1023 1024
	// 获取员工紧急联系人表
	@GetMapping(value = "/jjlxr/{empNum}")
1025 1026
	@ApiOperation(value = "35.获取员工紧急联系人表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 35)
1027
	public Result<List<YgglAttaJjlxr>> selectjjlxr(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
1028 1029 1030
		List<YgglAttaJjlxr> ygglAttaJjlxrs = YgglAttaJjlxr.builder().build()
				.selectList(new QueryWrapper<YgglAttaJjlxr>().lambda()
						.eq(YgglAttaJjlxr::getOrgCode, userBean.getOrgCode()).eq(YgglAttaJjlxr::getEmpNum, empNum));
1031
		return ResultUtil.data(ygglAttaJjlxrs);
太阳与水 committed
1032
	}
邓实川 committed
1033

东州 翁 committed
1034 1035
	/**
	 * 添加/修改员工紧急联系人表
邓实川 committed
1036
	 * 
东州 翁 committed
1037 1038 1039 1040
	 * @param
	 * @return
	 */
	@PostMapping(value = "/jjlxr")
1041 1042
	@ApiOperation(value = "36.添加/修改员工紧急联系人表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 36)
东州 翁 committed
1043 1044 1045 1046
	public Result<YgglAttaJjlxr> addjjlxr(@CurrentUser UserBean userBean, @RequestBody YgglAttaJjlxr ygglAttaJjlxr) {
		ygglAttaJjlxr.setEmpNum(ygglAttaJjlxr.getEmpNum());
		ygglAttaJjlxr.setOrgCode(userBean.getOrgCode());
		ygglAttaJjlxr.insertOrUpdate();
1047
		return ResultUtil.data(ygglAttaJjlxr, "修改员工紧急联系人表成功");
东州 翁 committed
1048
	}
邓实川 committed
1049

东州 翁 committed
1050 1051
	/**
	 * 删除员工紧急联系人表
邓实川 committed
1052
	 * 
东州 翁 committed
1053 1054 1055 1056
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/jjlxr/{id}")
1057 1058
	@ApiOperation(value = "37.删除员工紧急联系人表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 37)
东州 翁 committed
1059 1060
	public Result<Boolean> deljjlxr(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
1061 1062
		return ResultUtil.data(YgglAttaJjlxr.builder().build().delete(new QueryWrapper<YgglAttaJjlxr>().lambda()
				.eq(YgglAttaJjlxr::getOrgCode, orgCode).eq(YgglAttaJjlxr::getId, id)), "删除员工紧急联系人表成功");
东州 翁 committed
1063
	}
邓实川 committed
1064

东州 翁 committed
1065 1066 1067
	// 获取工资卡信息
	/**
	 * 获取员工工资卡信息
邓实川 committed
1068
	 * 
东州 翁 committed
1069 1070 1071 1072
	 * @param
	 * @return
	 */
	@GetMapping(value = "/gzk")
1073 1074
	@ApiOperation(value = "38.获取员工工资卡信息", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 38)
东州 翁 committed
1075
	public Result<List<YgglAttaGzk>> selectgzk(@CurrentUser UserBean userBean) {
1076
		List<YgglAttaGzk> ygglAttaGzks = YgglAttaGzk.builder().build()
1077
				.selectList(new QueryWrapper<YgglAttaGzk>().lambda().eq(YgglAttaGzk::getOrgCode, userBean.getOrgCode())
1078
						.eq(YgglAttaGzk::getEmpNum, userBean.getEmpNum()));
1079
		return ResultUtil.data(ygglAttaGzks);
东州 翁 committed
1080
	}
邓实川 committed
1081

太阳与水 committed
1082 1083
	// 获取工资卡信息
	@GetMapping(value = "/gzk/{empNum}")
1084 1085
	@ApiOperation(value = "39.获取员工工资卡信息(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 39)
太阳与水 committed
1086
	public Result<List<YgglAttaGzk>> selectgzk(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
1087 1088
		List<YgglAttaGzk> ygglAttaGzks = YgglAttaGzk.builder().build().selectList(new QueryWrapper<YgglAttaGzk>()
				.lambda().eq(YgglAttaGzk::getOrgCode, userBean.getOrgCode()).eq(YgglAttaGzk::getEmpNum, empNum));
1089
		return ResultUtil.data(ygglAttaGzks);
太阳与水 committed
1090
	}
邓实川 committed
1091

东州 翁 committed
1092 1093
	/**
	 * 添加/修改工资卡信息
邓实川 committed
1094
	 * 
东州 翁 committed
1095 1096 1097 1098
	 * @param
	 * @return
	 */
	@PostMapping(value = "/gzk")
1099 1100
	@ApiOperation(value = "40.添加/修改工资卡信息", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 40)
东州 翁 committed
1101 1102 1103 1104
	public Result<YgglAttaGzk> addgzk(@CurrentUser UserBean userBean, @RequestBody YgglAttaGzk ygglAttaGzk) {
		ygglAttaGzk.setEmpNum(ygglAttaGzk.getEmpNum());
		ygglAttaGzk.setOrgCode(userBean.getOrgCode());
		ygglAttaGzk.insertOrUpdate();
1105
		return ResultUtil.data(ygglAttaGzk, "修改工资卡信息成功");
东州 翁 committed
1106
	}
邓实川 committed
1107

东州 翁 committed
1108 1109
	/**
	 * 删除工资卡信息
邓实川 committed
1110
	 * 
东州 翁 committed
1111 1112 1113 1114
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/gzk/{id}")
1115 1116
	@ApiOperation(value = "41.删除工资卡信息", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 41)
东州 翁 committed
1117 1118
	public Result<Boolean> delgzk(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
1119 1120
		return ResultUtil.data(YgglAttaGzk.builder().build().delete(new QueryWrapper<YgglAttaGzk>().lambda()
				.eq(YgglAttaGzk::getOrgCode, orgCode).eq(YgglAttaGzk::getId, id)), "删除工资卡信息成功");
东州 翁 committed
1121
	}
邓实川 committed
1122

东州 翁 committed
1123 1124
	/**
	 * 获取员工合同信息表
邓实川 committed
1125
	 * 
东州 翁 committed
1126 1127 1128 1129
	 * @param
	 * @return
	 */
	@GetMapping(value = "/htxxb")
1130 1131
	@ApiOperation(value = "42.获取员工合同信息表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 42)
东州 翁 committed
1132
	public Result<List<YgglAttaHtxxb>> selecthtxxb(@CurrentUser UserBean userBean) {
1133 1134
		List<YgglAttaHtxxb> ygglAttaHtxxbs = YgglAttaHtxxb.builder().build().selectList(
				new QueryWrapper<YgglAttaHtxxb>().lambda().eq(YgglAttaHtxxb::getOrgCode, userBean.getOrgCode())
1135
						.eq(YgglAttaHtxxb::getEmpNum, userBean.getEmpNum()));
1136
		return ResultUtil.data(ygglAttaHtxxbs);
东州 翁 committed
1137
	}
邓实川 committed
1138

太阳与水 committed
1139 1140
	// 获取员工合同信息表
	@GetMapping(value = "/htxxb/{empNum}")
1141 1142
	@ApiOperation(value = "43.获取员工合同信息表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 43)
太阳与水 committed
1143
	public Result<List<YgglAttaHtxxb>> selecthtxxb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
1144 1145 1146
		List<YgglAttaHtxxb> ygglAttaHtxxbs = YgglAttaHtxxb.builder().build()
				.selectList(new QueryWrapper<YgglAttaHtxxb>().lambda()
						.eq(YgglAttaHtxxb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaHtxxb::getEmpNum, empNum));
1147
		return ResultUtil.data(ygglAttaHtxxbs);
太阳与水 committed
1148
	}
邓实川 committed
1149

太阳与水 committed
1150
	/**
东州 翁 committed
1151
	 * 添加/修改员工合同信息表
邓实川 committed
1152
	 * 
太阳与水 committed
1153 1154 1155
	 * @param
	 * @return
	 */
东州 翁 committed
1156
	@PostMapping(value = "/htxxb")
1157 1158
	@ApiOperation(value = "44.添加/修改员工合同信息表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 44)
东州 翁 committed
1159 1160 1161 1162
	public Result<YgglAttaHtxxb> addhtxxb(@CurrentUser UserBean userBean, @RequestBody YgglAttaHtxxb ygglAttaHtxxb) {
		ygglAttaHtxxb.setEmpNum(ygglAttaHtxxb.getEmpNum());
		ygglAttaHtxxb.setOrgCode(userBean.getOrgCode());
		ygglAttaHtxxb.insertOrUpdate();
1163
		return ResultUtil.data(ygglAttaHtxxb, "修改员工合同信息表成功");
太阳与水 committed
1164
	}
邓实川 committed
1165

太阳与水 committed
1166
	/**
东州 翁 committed
1167
	 * 删除员工合同信息表
邓实川 committed
1168
	 * 
太阳与水 committed
1169 1170 1171
	 * @param
	 * @return
	 */
东州 翁 committed
1172
	@DeleteMapping(value = "/htxxb/{id}")
1173 1174
	@ApiOperation(value = "45.删除员工合同信息表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 45)
东州 翁 committed
1175 1176
	public Result<Boolean> delhtxxb(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
1177 1178
		return ResultUtil.data(YgglAttaHtxxb.builder().build().delete(new QueryWrapper<YgglAttaHtxxb>().lambda()
				.eq(YgglAttaHtxxb::getOrgCode, orgCode).eq(YgglAttaHtxxb::getId, id)), "删除员工合同信息表成功");
太阳与水 committed
1179
	}
邓实川 committed
1180

太阳与水 committed
1181
	/**
东州 翁 committed
1182
	 * 获取员工材料附件表
1183
	 * 
1184 1185 1186
	 * @param
	 * @return
	 */
东州 翁 committed
1187
	@GetMapping(value = "/clfjb")
1188 1189
	@ApiOperation(value = "46.获取员工材料附件表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 46)
东州 翁 committed
1190
	public Result<List<YgglAttaClfjb>> selectclfjb(@CurrentUser UserBean userBean) {
1191 1192
		List<YgglAttaClfjb> ygglAttaClfjbs = YgglAttaClfjb.builder().build().selectList(
				new QueryWrapper<YgglAttaClfjb>().lambda().eq(YgglAttaClfjb::getOrgCode, userBean.getOrgCode())
1193
						.eq(YgglAttaClfjb::getEmpNum, userBean.getEmpNum()));
1194
		return ResultUtil.data(ygglAttaClfjbs);
1195
	}
邓实川 committed
1196

东州 翁 committed
1197 1198
	// 获取员工材料附件表
	@GetMapping(value = "/clfjb/{empNum}")
1199 1200
	@ApiOperation(value = "47.获取员工材料附件表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 47)
东州 翁 committed
1201
	public Result<List<YgglAttaClfjb>> selectclfjb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
1202 1203 1204
		List<YgglAttaClfjb> ygglAttaClfjbs = YgglAttaClfjb.builder().build()
				.selectList(new QueryWrapper<YgglAttaClfjb>().lambda()
						.eq(YgglAttaClfjb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaClfjb::getEmpNum, empNum));
1205
		return ResultUtil.data(ygglAttaClfjbs);
1206
	}
邓实川 committed
1207

1208
	/**
东州 翁 committed
1209
	 * 添加/修改员工材料附件表
邓实川 committed
1210
	 * 
1211 1212 1213
	 * @param
	 * @return
	 */
东州 翁 committed
1214
	@PostMapping(value = "/clfjb")
1215 1216
	@ApiOperation(value = "48.添加/修改员工材料附件表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 48)
东州 翁 committed
1217 1218 1219 1220
	public Result<YgglAttaClfjb> addclfjb(@CurrentUser UserBean userBean, @RequestBody YgglAttaClfjb ygglAttaClfjb) {
		ygglAttaClfjb.setOrgCode(userBean.getOrgCode());
		ygglAttaClfjb.setEmpNum(ygglAttaClfjb.getEmpNum());
		ygglAttaClfjb.insertOrUpdate();
1221
		return ResultUtil.data(ygglAttaClfjb, "修改员工材料附件表成功");
1222
	}
邓实川 committed
1223

1224
	/**
东州 翁 committed
1225
	 * 删除员工材料附件表
邓实川 committed
1226
	 * 
1227 1228 1229 1230
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/clfjb/{id}")
1231 1232
	@ApiOperation(value = "49.删除员工材料附件表", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 49)
东州 翁 committed
1233 1234
	public Result<Boolean> delclfjb(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
1235 1236
		return ResultUtil.data(YgglAttaClfjb.builder().build().delete(new QueryWrapper<YgglAttaClfjb>().lambda()
				.eq(YgglAttaClfjb::getOrgCode, orgCode).eq(YgglAttaClfjb::getId, id)), "删除员工材料附件表成功");
1237
	}
邓实川 committed
1238

东州 翁 committed
1239 1240
	/**
	 * 获取成长记录表
邓实川 committed
1241
	 * 
东州 翁 committed
1242 1243 1244 1245
	 * @param
	 * @return
	 */
	@GetMapping(value = "/czjlb")
1246 1247
	@ApiOperation(value = "50.获取成长记录表", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 50)
东州 翁 committed
1248
	public Result<List<YgglAttaCzjlb>> selectczjlb(@CurrentUser UserBean userBean) {
1249 1250
		List<YgglAttaCzjlb> ygglAttaCzjlbs = YgglAttaCzjlb.builder().build().selectList(
				new QueryWrapper<YgglAttaCzjlb>().lambda().eq(YgglAttaCzjlb::getOrgCode, userBean.getOrgCode())
1251
						.eq(YgglAttaCzjlb::getEmpNum, userBean.getEmpNum()));
1252
		return ResultUtil.data(ygglAttaCzjlbs);
东州 翁 committed
1253
	}
邓实川 committed
1254

东州 翁 committed
1255 1256
	// 获取成长记录表
	@GetMapping(value = "/czjlb/{empNum}")
1257 1258
	@ApiOperation(value = "51.获取成长记录表(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 51)
东州 翁 committed
1259
	public Result<List<YgglAttaCzjlb>> selectczjlb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
1260 1261 1262
		List<YgglAttaCzjlb> ygglAttaCzjlbs = YgglAttaCzjlb.builder().build()
				.selectList(new QueryWrapper<YgglAttaCzjlb>().lambda()
						.eq(YgglAttaCzjlb::getOrgCode, userBean.getOrgCode()).eq(YgglAttaCzjlb::getEmpNum, empNum));
1263
		return ResultUtil.data(ygglAttaCzjlbs);
东州 翁 committed
1264
	}
邓实川 committed
1265

东州 翁 committed
1266 1267
	/**
	 * 添加/修改成长记录表
邓实川 committed
1268
	 * 
东州 翁 committed
1269 1270 1271 1272
	 * @param
	 * @return
	 */
	@PostMapping(value = "/czjlb")
1273 1274
	@ApiOperation(value = "52.添加/修改成长记录表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 52)
东州 翁 committed
1275 1276 1277 1278
	public Result<YgglAttaCzjlb> addczjlb(@CurrentUser UserBean userBean, @RequestBody YgglAttaCzjlb ygglAttaCzjlb) {
		ygglAttaCzjlb.setEmpNum(ygglAttaCzjlb.getEmpNum());
		ygglAttaCzjlb.setOrgCode(userBean.getOrgCode());
		ygglAttaCzjlb.insertOrUpdate();
1279
		return ResultUtil.data(ygglAttaCzjlb, "修改成长记录表成功");
东州 翁 committed
1280
	}
邓实川 committed
1281

东州 翁 committed
1282 1283
	/**
	 * 获取单个离职员工信息(管)
邓实川 committed
1284
	 * 
东州 翁 committed
1285 1286 1287 1288
	 * @param
	 * @return
	 */
	@GetMapping(value = "/lzb/{empNum}")
1289 1290
	@ApiOperation(value = "53.获取单个离职员工信息(管)", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 53)
东州 翁 committed
1291 1292 1293
	public Result<YgglMainLzb> selectlzb(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {
		YgglMainLzb lzyg = new LambdaQueryChainWrapper<YgglMainLzb>(ygglMainLzbMapper)
				.eq(YgglMainLzb::getOrgCode, userBean.getOrgCode()).eq(YgglMainLzb::getEmpNum, empNum).one();
1294
		return ResultUtil.data(lzyg);
东州 翁 committed
1295
	}
邓实川 committed
1296

东州 翁 committed
1297
	/**
邓实川 committed
1298
	 * 员工转正 0-1
邓实川 committed
1299
	 * 
东州 翁 committed
1300 1301 1302 1303
	 * @param
	 * @return
	 */
	@PostMapping(value = "/ygzz")
1304 1305
	@ApiOperation(value = "54.员工转正", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 54)
东州 翁 committed
1306
	public Result<Void> ygzz(@CurrentUser UserBean userBean, @RequestBody YgzzDto ygzzDto) {
1307

1308
		YgglMainEmp.builder().jobStatus(jobStatus.ZHENSHI.getType()).zzTime(ygzzDto.getZzTime()).sjzzTime(new Date())
1309 1310
				.zzRemark(ygzzDto.getZzRemark()).build()
				.update(new UpdateWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getEmpNum, ygzzDto.getEmpNum()));
1311
		return ResultUtil.success("转正成功!");
东州 翁 committed
1312
	}
邓实川 committed
1313

东州 翁 committed
1314
	/**
邓实川 committed
1315
	 * 计划离职 type1-2
邓实川 committed
1316
	 * 
东州 翁 committed
1317 1318 1319 1320
	 * @param
	 * @return
	 */
	@PostMapping(value = "/addlzjh")
1321 1322
	@ApiOperation(value = "55.添加离职计划", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 55)
东州 翁 committed
1323
	public Result<YgglMainLzb> addjhlz(@CurrentUser UserBean userBean, @RequestBody LzygQueryDto lzygQueryDto) {
1324

1325
		Integer empNum = lzygQueryDto.getEmpNum();
1326

1327
		YgglMainEmp ygglMainEmp = ygglMainEmpMapper.selectOne(new QueryWrapper<YgglMainEmp>().lambda()
tangzhaoqian committed
1328 1329
				.eq(YgglMainEmp::getEmpNum, empNum)
				.eq(YgglMainEmp::getOrgCode, userBean.getOrgCode()));
tangzhaoqian committed
1330 1331 1332 1333 1334
		
		if (ygglMainEmp.getJobStatus() == jobStatus.LIZHIZHONG.getType()) {
			return ResultUtil.success("你已在离职中");
		}
		
东州 翁 committed
1335 1336
		YgglMainLzb ygglMainLzb = YgglMainLzb.builder().empNum(lzygQueryDto.getEmpNum()).build();
		// 移动员工表数据到离职表
1337
		BeanUtil.copyProperties(ygglMainEmp, ygglMainLzb, "before_leaving_sts");
东州 翁 committed
1338
		ygglMainLzb.insert();
1339

1340
		YgglMainEmp.builder().empNum(lzygQueryDto.getEmpNum()).jobStatus(jobStatus.LIZHIZHONG.getType())
1341
				.beforeLeavingSts(ygglMainEmp.getJobStatus()).build()
tangzhaoqian committed
1342 1343 1344 1345
				.update(new UpdateWrapper<YgglMainEmp>().lambda()
						.eq(YgglMainEmp::getEmpNum, empNum)
						.eq(YgglMainEmp::getOrgCode, userBean.getOrgCode()));
		
1346
		YgglMainLzb.builder().jobStatus(jobStatus.LIZHIZHONG.getType()).lzTime(lzygQueryDto.getLzTime())
1347
				.lzyy(lzygQueryDto.getLzyy()).lzbz(lzygQueryDto.getLzbz()).build()
tangzhaoqian committed
1348 1349 1350
				.update(new UpdateWrapper<YgglMainLzb>().lambda()
						.eq(YgglMainLzb::getEmpNum, empNum)
						.eq(YgglMainLzb::getOrgCode, userBean.getOrgCode()));
1351

东州 翁 committed
1352 1353
		return ResultUtil.data(ygglMainLzb, "添加待离职员工成功");
	}
邓实川 committed
1354

1355
	/**
邓实川 committed
1356
	 * 确认离职 type2-3
邓实川 committed
1357
	 * 
太阳与水 committed
1358 1359
	 * @param
	 * @return
东州 翁 committed
1360 1361
	 */
	@PostMapping(value = "/qrlz")
1362 1363
	@ApiOperation(value = "56.确认离职", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 56)
东州 翁 committed
1364
	public Result<Void> addlzb(@CurrentUser UserBean userBean, @RequestBody LzygQueryDto lzygQueryDto) {
1365
		Integer empNum = lzygQueryDto.getEmpNum();
1366
		// 删除员工档案表
tangzhaoqian committed
1367 1368 1369
		ygglMainEmpMapper.delete(new QueryWrapper<YgglMainEmp>().lambda()
				.eq(YgglMainEmp::getEmpNum, empNum)
				.eq(YgglMainEmp::getOrgCode, userBean.getOrgCode()));
1370

1371
		YgglMainLzb.builder().empNum(empNum).jobStatus(YgEnumInterface.jobStatus.YILIZHI.getType()).sjlzTime(new Date())
tangzhaoqian committed
1372 1373 1374
				.build().update(new UpdateWrapper<YgglMainLzb>().lambda()
						.eq(YgglMainLzb::getEmpNum, empNum)
						.eq(YgglMainLzb::getOrgCode, userBean.getOrgCode()));
1375

1376
		LambdaQueryWrapper<QyzxEmpEntAsso> queryWrapper = new QueryWrapper<QyzxEmpEntAsso>().lambda()
tangzhaoqian committed
1377
				.eq(QyzxEmpEntAsso::getEmpNum, empNum)
1378
				.eq(QyzxEmpEntAsso::getOrgCode, userBean.getOrgCode());
1379

1380
		// 确认离职 删除员工关联表
1381
		qyzxEmpEntAssoMapper.delete(queryWrapper);
1382 1383 1384

		// 初始化 部门主管
		zzglBmgwMMapper.update(ZzglBmgwM.builder().leader(null).build(),
tangzhaoqian committed
1385 1386 1387
				new UpdateWrapper<ZzglBmgwM>().lambda()
				.eq(ZzglBmgwM::getOrgCode, userBean.getOrgCode())
				.eq(ZzglBmgwM::getLeader, empNum));
1388

1389
		// 更新当前企业
1390 1391
		List<QyzxEmpEntAsso> listEEA = qyzxEmpEntAssoMapper.selectList(new QueryWrapper<QyzxEmpEntAsso>().lambda()
				.eq(QyzxEmpEntAsso::getEmpNum, empNum));
1392 1393 1394
		if (listEEA != null && listEEA.size() > 0) {
			QyzxEmpLogin.builder().id(empNum).orgId(CollUtil.getFirst(listEEA).getOrgCode()).build().updateById();
		}
ilal committed
1395
		
ilal committed
1396
		QyzxEmpLogin.builder().build().delete(new QueryWrapper<QyzxEmpLogin>().lambda().eq(QyzxEmpLogin::getOrgId, userBean.getOrgCode()).eq(QyzxEmpLogin::getId, empNum));
ilal committed
1397 1398 1399 1400 1401
		
		KqglAssoYhkqz.builder().build().delete(new QueryWrapper<KqglAssoYhkqz>().lambda().eq(KqglAssoYhkqz::getUserid, empNum).eq(KqglAssoYhkqz::getQyid, userBean.getOrgCode()));
		
		try {
			realtimeupdate.AttendanceTask(userBean.getOrgCode(), empNum, 2,null);
1402 1403

			redisUtil.set("BlockUser"+empNum,"BlockUser",session_timeout);
ilal committed
1404 1405 1406 1407
		} catch (ParseException e) {
			e.printStackTrace();
		}
		
东州 翁 committed
1408 1409
		return ResultUtil.success("确认离职员工成功");
	}
邓实川 committed
1410

东州 翁 committed
1411
	/**
邓实川 committed
1412
	 * 放弃离职 type 2-1
邓实川 committed
1413
	 * 
东州 翁 committed
1414 1415 1416 1417
	 * @param
	 * @return
	 */
	@PostMapping(value = "/fqlz")
1418 1419
	@ApiOperation(value = "57.放弃离职", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 57)
东州 翁 committed
1420
	public Result<Void> fqlz(@CurrentUser UserBean userBean, @RequestBody LzygQueryDto lzygQueryDto) {
1421 1422 1423 1424 1425 1426 1427

		YgglMainEmp ygglMainEmp = ygglMainEmpMapper
				.selectOne(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getEmpNum, lzygQueryDto.getEmpNum())
						.eq(YgglMainEmp::getOrgCode, userBean.getOrgCode()));

		YgglMainEmp.builder().jobStatus(ygglMainEmp.getBeforeLeavingSts()).build()
				.update(new UpdateWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getEmpNum, lzygQueryDto.getEmpNum()));
东州 翁 committed
1428
		// 删除离职表
1429 1430
		YgglMainLzb.builder().id(lzygQueryDto.getEmpNum()).build()
				.delete(new QueryWrapper<YgglMainLzb>().lambda().eq(YgglMainLzb::getEmpNum, lzygQueryDto.getEmpNum()));
东州 翁 committed
1431 1432 1433

		return ResultUtil.success("放弃成功");
	}
邓实川 committed
1434

东州 翁 committed
1435
	@PostMapping(value = "/tzlzyy")
1436 1437
	@ApiOperation(value = "58.调整离职", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 58)
东州 翁 committed
1438 1439
	public Result<YgglMainLzb> tzlzyy(@CurrentUser UserBean userBean, @RequestBody YgglMainLzb ygglMainLzb) {

邓实川 committed
1440
		if (ygglMainLzb.getEmpNum() != null) {
1441 1442 1443
			ygglMainLzb
					.update(new UpdateWrapper<YgglMainLzb>().lambda().eq(YgglMainLzb::getOrgCode, userBean.getOrgCode())
							.eq(YgglMainLzb::getEmpNum, ygglMainLzb.getEmpNum()));
邓实川 committed
1444 1445
			return ResultUtil.data(ygglMainLzb, "修改成功");
		}
1446
		return ResultUtil.error("请确认该员工是否存在!");
邓实川 committed
1447

东州 翁 committed
1448
	}
邓实川 committed
1449

东州 翁 committed
1450 1451
	/**
	 * 查询离职员工列表
邓实川 committed
1452
	 * 
东州 翁 committed
1453 1454 1455 1456
	 * @param
	 * @return
	 */
	@PostMapping(value = "/querylzyg")
1457 1458
	@ApiOperation(value = "59.查询离职员工列表", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 59)
东州 翁 committed
1459 1460
	public Result<Object> querylzyg(@CurrentUser UserBean userBean, @RequestBody LzbQueryDto lzygQueryDto) {
		lzygQueryDto.setOrgCode(userBean.getOrgCode());
邓实川 committed
1461

东州 翁 committed
1462 1463 1464 1465 1466
		IPage<YgglMainLzb> page = new Page<YgglMainLzb>(
				lzygQueryDto.getCurrentPage() == null ? 1 : lzygQueryDto.getCurrentPage(),
				lzygQueryDto.getTotalPage() == null ? 10 : lzygQueryDto.getTotalPage());
		List<YgglMainLzb> lzb = ygglMainLzbMapper.queryLzb(page, lzygQueryDto);
		return ResultUtil.data(page, lzb, "离职员工搜索成功");
太阳与水 committed
1467
	}
邓实川 committed
1468

1469 1470
	/**
	 * 展示民族/展示所有民族
邓实川 committed
1471
	 * 
1472 1473
	 * @param
	 * @return
邓实川 committed
1474
	 */
1475
	@PostMapping(value = "/mz/{id}")
1476 1477
	@ApiOperation(value = "60.展示民族/展示所有民族", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 60)
1478
	public Result<List<YgmzDto>> selectmzs(@CurrentUser UserBean userBean, @PathVariable Integer id) {
邓实川 committed
1479 1480 1481
		if (id == null || id == 0) {
			List<YgmzDto> allmz = new LambdaQueryChainWrapper<YgmzDto>(ygMzDtoMapper).list();
			return ResultUtil.data(allmz, "展示所有民族");
1482
		}
邓实川 committed
1483 1484
		List<YgmzDto> mz = new LambdaQueryChainWrapper<YgmzDto>(ygMzDtoMapper).eq(YgmzDto::getNumber, id).list();
		return ResultUtil.data(mz, "展示该民族");
1485
	}
1486

1487 1488
	@Autowired
	CommonAreaMapper commonAreaMapper;
1489

1490
	/**
1491
	 * 籍贯树
1492 1493 1494 1495 1496
	 * 
	 * @param
	 * @return
	 */
	@GetMapping(value = "/native_place")
1497 1498
	@ApiOperation(value = "61.籍贯树", httpMethod = "GET", notes = "籍贯树")
	@ApiOperationSupport(order = 61)
1499
	public Result<List<CommonArea>> selectNativePlace() {
1500

1501
		List<CommonArea> listCommonArea = commonAreaMapper.AllAreaForTree();
1502
		return ResultUtil.data(listCommonArea);
1503

1504
	}
邓实川 committed
1505

1506
	/**
1507
	 * 查询员工列表
邓实川 committed
1508
	 * 
1509 1510 1511 1512
	 * @param
	 * @return
	 */
	@GetMapping(value = "/queryemp")
1513
	@ApiOperation(value = "62.查询员工列表", httpMethod = "GET", notes = "接口发布说明")
东州 翁 committed
1514
	@ApiOperationSupport(order = 62)
1515
	public Result<List<YgQueryDto>> queryEmpMessage(@CurrentUser UserBean userBean) {
1516
		List<YgQueryDto> ygQueryDto = ygglMainEmpMapper.queryEmpMessage(userBean.getOrgCode());
1517 1518 1519 1520 1521
		for (YgQueryDto yg : ygQueryDto) {
			if (StringUtil.isEmpty(yg.getHeadUrl())) {
				yg.setHeadUrl("");
			}
		}
1522
		return ResultUtil.data(ygQueryDto);
1523
	}
邓实川 committed
1524

1525 1526 1527
	/*************** 统计图 ***************/
	/**
	 * 查询统计图
邓实川 committed
1528
	 * 
1529 1530 1531
	 * @return 成功信息
	 */
	@GetMapping("/yggl")
1532
	@ApiOperation(value = "63.获取员工管理统计图信息", httpMethod = "GET", notes = "接口发布说明")
东州 翁 committed
1533
	@ApiOperationSupport(order = 63)
1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550
	public Result<Map<String, Object>> queryYgglCartogram(@CurrentUser UserBean userBean) {

		Map<String, Object> map = new HashMap<String, Object>();
		YgglCartogramDto ygglCartogramDto1 = ygglMainEmpMapper.queryPositive(userBean);
		YgglCartogramDto ygglCartogramDto2 = ygglMainEmpMapper.queryAvgAge(userBean);
		YgglCartogramDto ygglCartogramDto3 = ygglMainEmpMapper.queryInduction(userBean);
		YgglCartogramDto ygglCartogramDto4 = ygglMainEmpMapper.queryInservice(userBean);
		YgglCartogramDto ygglCartogramDto5 = ygglMainLzbMapper.queryDeparture(userBean);

		List<YgglCartogramDto> ygglCartogramDto6 = ygglMainEmpMapper.queryDepartmentNum(userBean);
		List<YgglCartogramDto> ygglCartogramDto7 = ygglMainEmpMapper.queryEducation(userBean);
		List<YgglCartogramDto> ygglCartogramDto8 = ygglMainEmpMapper.queryJobsNum(userBean);
		List<YgglCartogramDto> ygglCartogramDto9 = ygglMainEmpMapper.queryEmpAge(userBean);
		List<YgglCartogramDto> ygglCartogramDto10 = ygglMainEmpMapper.queryNativeplace(userBean);
		List<YgglCartogramDto> ygglCartogramDto11 = ygglMainEmpMapper.queryWorkingAge(userBean);

		map.put("positive", ygglCartogramDto1.getPositive());
1551 1552 1553
		if (ygglCartogramDto2 != null) {
			map.put("avgAge", ygglCartogramDto2.getAvgAge());
		}
1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565
		map.put("induction", ygglCartogramDto3.getInduction());
		map.put("probation", ygglCartogramDto4.getProbation());
		map.put("regular", ygglCartogramDto4.getRegular());
		map.put("departure", ygglCartogramDto5.getDepartureNum());

		map.put("department", ygglCartogramDto6);
		map.put("education", ygglCartogramDto7);
		map.put("jobs", ygglCartogramDto8);
		map.put("empAge", ygglCartogramDto9);
		map.put("nativeplace", ygglCartogramDto10);
		map.put("workingAge", ygglCartogramDto11);

1566
		return ResultUtil.data(map);
1567
	}
邓实川 committed
1568

东州 翁 committed
1569
	/**
1570
	 * 员工信息统计图
1571
	 * 
1572 1573 1574
	 * @return 成功信息(weng)
	 */
	@GetMapping("/Cartogram")
1575 1576
	@ApiOperation(value = "64.获取员工管理统计图信息", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 64)
1577 1578 1579
	public Result<YgCartogramDto> ygCartogram(@CurrentUser UserBean userBean) {
		Integer orgCode = userBean.getOrgCode();
		List<YgbintuDto> bintu = ygglMainEmpMapper.rsybp(orgCode);
1580

1581
		Map<String, Long> gw = bintu.stream().collect(Collectors.groupingBy(YgbintuDto::getGw, Collectors.counting()));
1582
		List<YgKVDto> gwList = new ArrayList<YgKVDto>();
1583 1584
		for (Map.Entry<String, Long> entry : gw.entrySet()) {
			gwList.add(new YgKVDto(entry.getKey(), entry.getValue().toString()));
1585
		}
1586
		Map<String, Long> bm = bintu.stream().collect(Collectors.groupingBy(YgbintuDto::getBm, Collectors.counting()));
1587
		List<YgKVDto> bmList = new ArrayList<YgKVDto>();
1588 1589
		for (Map.Entry<String, Long> entry : bm.entrySet()) {
			bmList.add(new YgKVDto(entry.getKey(), entry.getValue().toString()));
1590
		}
1591 1592
		Map<String, Long> edu = bintu.stream()
				.collect(Collectors.groupingBy(YgbintuDto::getEduname, Collectors.counting()));
1593
		List<YgKVDto> eduList = new ArrayList<YgKVDto>();
1594 1595
		for (Map.Entry<String, Long> entry : edu.entrySet()) {
			eduList.add(new YgKVDto(entry.getKey(), entry.getValue().toString()));
1596
		}
1597 1598
		Map<Integer, Long> jobStatus = bintu.stream()
				.collect(Collectors.groupingBy(YgbintuDto::getJobStatus, Collectors.counting()));
1599
		List<YgKVDto> jobStatusList = new ArrayList<YgKVDto>();
1600 1601
		for (Entry<Integer, Long> entry : jobStatus.entrySet()) {
			jobStatusList.add(new YgKVDto(entry.getKey().toString(), entry.getValue().toString()));
1602
		}
1603 1604
		Map<String, Long> proname = bintu.stream()
				.collect(Collectors.groupingBy(YgbintuDto::getProname, Collectors.counting()));
1605
		List<YgKVDto> pronameList = new ArrayList<YgKVDto>();
1606 1607
		for (Entry<String, Long> entry : proname.entrySet()) {
			pronameList.add(new YgKVDto(entry.getKey().toString(), entry.getValue().toString()));
1608
		}
1609
		Map<String, Integer> workage = YgEnumInterface.workage.choose(bintu);
1610
		List<YgKVDto> workageList = new ArrayList<YgKVDto>();
1611 1612
		for (Entry<String, Integer> entry : workage.entrySet()) {
			workageList.add(new YgKVDto(entry.getKey().toString(), entry.getValue().toString()));
1613
		}
1614
		Map<String, Integer> age = YgEnumInterface.age.choose(bintu);
1615
		List<YgKVDto> ageList = new ArrayList<YgKVDto>();
1616 1617
		for (Entry<String, Integer> entry : age.entrySet()) {
			ageList.add(new YgKVDto(entry.getKey().toString(), entry.getValue().toString()));
1618
		}
1619
		// 在职
1620 1621
		Integer zaizhi = jobStatus.get(YgEnumInterface.jobStatus.ZHENSHI.getType()).intValue()
				+ jobStatus.get(YgEnumInterface.jobStatus.SHIYONG.getType()).intValue();
1622
		// 本月新入职
1623
		Integer xinruzhi = workage.get("本月新入职").intValue();
1624
		// 本月离职
1625
		Integer lizhi = ygglMainEmpMapper.benyueLz(orgCode);
1626
		// 本月转正
1627
		Integer zhuanzhen = ygglMainEmpMapper.benyueZz(orgCode);
1628
		// 平均年龄
1629 1630
		Integer nianlin = age.get("平均年龄").intValue();
		YgCartogramDto ybp = new YgCartogramDto();
1631 1632 1633 1634 1635
		ybp.setOnTheJob(zaizhi);
		ybp.setNewRecruits(xinruzhi);
		ybp.setDimission(lizhi);
		ybp.setRegularization(zhuanzhen);
		ybp.setAverageAge(nianlin);
1636

1637 1638
		ybp.setDepartment(bmList);
		ybp.setPosition(gwList);
1639 1640 1641 1642 1643
		ybp.setEdu(eduList);
		ybp.setJobStatus(jobStatusList);
		ybp.setProname(pronameList);
		ybp.setWorkage(workageList);
		ybp.setAge(ageList);
1644
		return ResultUtil.data(ybp);
1645
	}
1646

1647 1648
	/**
	 * 获取员工社保公积金
邓实川 committed
1649
	 * 
东州 翁 committed
1650 1651 1652 1653
	 * @param
	 * @return
	 */
	@GetMapping(value = "/ygsbgjj")
1654 1655
	@ApiOperation(value = "65.获取员工社保公积金", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 65)
邓实川 committed
1656 1657
	public Result<YgglAttaSbgjj> selectygsbgjj(@CurrentUser UserBean userBean) {
		YgglAttaSbgjj ygglAttaSbgjj = YgglAttaSbgjj.builder().build().selectOne(
1658 1659
				new QueryWrapper<YgglAttaSbgjj>().lambda().eq(YgglAttaSbgjj::getOrgCode, userBean.getOrgCode())
						.eq(YgglAttaSbgjj::getEmpNum, userBean.getEmpNum()));
1660
		return ResultUtil.data(ygglAttaSbgjj);
东州 翁 committed
1661
	}
邓实川 committed
1662

1663 1664
	/**
	 * 获取员工社保公积金
邓实川 committed
1665
	 * 
1666 1667 1668 1669
	 * @param
	 * @return
	 */
	@GetMapping(value = "/ygsbgjj/{empNum}")
1670 1671
	@ApiOperation(value = "66.获取员工社保公积金", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 66)
邓实川 committed
1672 1673 1674
	public Result<YgglAttaSbgjj> selectygsbgjj(@CurrentUser UserBean userBean, @PathVariable Integer empNum) {

		YgglAttaSbgjj ygglAttaSbgjj = YgglAttaSbgjj.builder().build()
1675
				.selectOne(new QueryWrapper<YgglAttaSbgjj>().lambda().eq(YgglAttaSbgjj::getEmpNum, empNum));
1676

1677
		return ResultUtil.data(ygglAttaSbgjj);
1678
	}
邓实川 committed
1679

1680 1681
	/**
	 * 添加/修改员工社保公积金
邓实川 committed
1682
	 * 
1683 1684 1685 1686
	 * @param
	 * @return
	 */
	@PostMapping(value = "/ygsbgjj")
1687 1688
	@ApiOperation(value = "67.添加/修改员工社保公积金", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 67)
邓实川 committed
1689
	public Result<YgglAttaSbgjj> addygsbgjj(@CurrentUser UserBean userBean, @RequestBody YgglAttaSbgjj ygglAttaSbgjj) {
1690 1691 1692 1693
		Integer empNum = ygglAttaSbgjj.getEmpNum();
		if (empNum == null) {
			return ResultUtil.error();
		}
邓实川 committed
1694
		YgglAttaSbgjj AttaSbgjj = YgglAttaSbgjj.builder().build()
1695
				.selectOne(new QueryWrapper<YgglAttaSbgjj>().lambda().eq(YgglAttaSbgjj::getEmpNum, empNum));
1696
		if (AttaSbgjj != null) {
1697
			ygglAttaSbgjj.update(new UpdateWrapper<YgglAttaSbgjj>().lambda().eq(YgglAttaSbgjj::getEmpNum, empNum));
邓实川 committed
1698
		} else {
1699 1700 1701
			ygglAttaSbgjj.insert();
		}

1702
		return ResultUtil.data(ygglAttaSbgjj);
1703
	}
邓实川 committed
1704

东州 翁 committed
1705 1706
	/**
	 * 删除员工社保公积金
邓实川 committed
1707
	 * 
东州 翁 committed
1708 1709 1710 1711
	 * @param
	 * @return
	 */
	@DeleteMapping(value = "/ygsbgjj/{id}")
1712 1713
	@ApiOperation(value = "68.删除员工社保公积金", httpMethod = "DELETE", notes = "接口发布说明")
	@ApiOperationSupport(order = 68)
东州 翁 committed
1714 1715
	public Result<Boolean> delygsbgjj(@CurrentUser UserBean userBean, @PathVariable Integer id) {
		Integer orgCode = userBean.getOrgCode();
1716 1717
		return ResultUtil.data(YgglAttaSbgjj.builder().build().delete(new QueryWrapper<YgglAttaSbgjj>().lambda()
				.eq(YgglAttaSbgjj::getOrgCode, orgCode).eq(YgglAttaSbgjj::getId, id)));
东州 翁 committed
1718
	}
邓实川 committed
1719

1720 1721 1722 1723 1724
	@GetMapping(value = "/sysRegion")
	@ApiOperation(value = "省市区字典(贼全)", httpMethod = "GET", notes = "接口发布说明")
	public Result<List<Tree<String>>> sysRegion() {
		List<SysRegion> nodeList = SysRegion.builder().build()
				.selectList(new LambdaQueryWrapper<SysRegion>().select(SysRegion::getKeyId, SysRegion::getRegionCode,
1725
						SysRegion::getRegionName, SysRegion::getMerName, SysRegion::getLevel, SysRegion::getZipCode));
1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736

		// 配置
		TreeNodeConfig treeNodeConfig = new TreeNodeConfig();
		// 自定义属性名 都要默认值的
		treeNodeConfig.setIdKey("key_id");
		treeNodeConfig.setParentIdKey("region_code");
		// 最大递归深度
		treeNodeConfig.setDeep(4);

		List<Tree<String>> treeNodes = TreeUtil.build(nodeList, "0", treeNodeConfig, (treeNode, tree) -> {
			tree.setId(treeNode.getKeyId().toString());
1737
			tree.setParentId(treeNode.getRegionCode().toString());
1738 1739 1740
			tree.setName(treeNode.getRegionName());
			// 扩展属性 ...
			tree.putExtra("mer_name", treeNode.getMerName());
1741
			tree.putExtra("zip_code", treeNode.getZipCode());
1742 1743
		});

1744
		return ResultUtil.data(treeNodes);
1745
	}
1746

1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760
	/**
	 * 获取登录人的相关信息
	 * 
	 * @param
	 * @return
	 */
	@GetMapping(value = "/loginmessage")
	@ApiOperation(value = "69.获取登录人的相关信息", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 69)
	public Result<LoginInfoDto> loginmessage(@CurrentUser UserBean userBean) {
		Integer empNum = userBean.getEmpNum();
		Integer orgCode = userBean.getOrgCode();
		LoginInfoDto loginInfo = LoginInfoDto.builder().build();
		YgglMainEmp ygglMainEmp = new LambdaQueryChainWrapper<YgglMainEmp>(ygglMainEmpMapper)
1761
				.select(YgglMainEmp::getBmgwId, YgglMainEmp::getName, YgglMainEmp::getRzTime, YgglMainEmp::getZzTime,YgglMainEmp::getSyq,
1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783
						YgglMainEmp::getEmpNum)
				.eq(YgglMainEmp::getEmpNum, empNum).eq(YgglMainEmp::getOrgCode, orgCode).one();
		if (ygglMainEmp != null) {
			Integer gw = ygglMainEmp.getBmgwId();

			ZzglBmgwM gwObj = new LambdaQueryChainWrapper<ZzglBmgwM>(zzglBmgwMMapper)
					.select(ZzglBmgwM::getUpId, ZzglBmgwM::getName).eq(ZzglBmgwM::getId, gw)
					.eq(ZzglBmgwM::getOrgCode, orgCode).one();

			if (gwObj != null) {
				ZzglBmgwM bmObj = new LambdaQueryChainWrapper<ZzglBmgwM>(zzglBmgwMMapper)
						.select(ZzglBmgwM::getId, ZzglBmgwM::getName).eq(ZzglBmgwM::getId, gwObj.getUpId())
						.eq(ZzglBmgwM::getOrgCode, orgCode).one();
				loginInfo.setBmId(bmObj != null ? bmObj.getId() : null);
				loginInfo.setBmName(bmObj != null ? bmObj.getName() : null);
			}

			loginInfo.setEmpNum(ygglMainEmp.getEmpNum());
			loginInfo.setName(ygglMainEmp.getName());
			loginInfo.setGwId(gw);
			loginInfo.setGwName(gwObj != null ? gwObj.getName() : "");
			loginInfo.setEntryTime(ygglMainEmp.getRzTime());
yuquan.zhu committed
1784 1785
			
			if(ygglMainEmp.getSyq()!=null) {
1786
				System.out.println(ygglMainEmp.getSyq());
yuquan.zhu committed
1787 1788 1789 1790 1791 1792
				Date expireDate = DateUtil.offsetMonth(ygglMainEmp.getRzTime(), ygglMainEmp.getSyq()); // 时间偏移
				loginInfo.setRegularTime(expireDate);	
			}else {
				loginInfo.setRegularTime(new Date());	
			}
			
1793
		}
1794
		return ResultUtil.data(loginInfo);
1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806
	}

	/**
	 * 获取登录人和上级主管的empNum和名称
	 * 
	 * @param
	 * @return
	 */
	@GetMapping(value = "/loginerChargers")
	@ApiOperation(value = "70.获取登录人和上级主管的empNum和名称", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 70)
	public Result<List<LoginerChargeDto>> loginerChargers(@CurrentUser UserBean userBean) {
ilal committed
1807 1808 1809
		
		List<LoginerChargeDto> loginerChargeDtos = new ArrayList<LoginerChargeDto>();
		
1810 1811 1812 1813
		Integer orgCode = userBean.getOrgCode();
		ArrayList<Integer> list = new ArrayList<Integer>();
		Integer empNum = userBean.getEmpNum();
		Integer gw = empNumConfirm(orgCode, empNum).getBmgwId();
ilal committed
1814
		if(gw != null && gw > 0) {
ilal committed
1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827
			ZzglBmgwM buid = ZzglBmgwM.builder().id(gw).build().selectById();
			
			List<ZzglBmgwM> zzglBmgwMs = new LambdaQueryChainWrapper<ZzglBmgwM>(zzglBmgwMMapper)
					.eq(ZzglBmgwM::getOrgCode, orgCode).eq(ZzglBmgwM::getType, 0).list();
			// 获取该员工的上级部门id 的数组list
			ZzglBmgwM.getUpDepts(list, buid.getUpId(), zzglBmgwMs);
			List<Integer> leaderList = new ArrayList<Integer>();
			for (Integer zzglId : list) {
				for (ZzglBmgwM zzglBmgwM : zzglBmgwMs) {
					if (zzglId.equals(zzglBmgwM.getId()) && zzglBmgwM.getLeader() != null) {

						leaderList.add(zzglBmgwM.getLeader());
					}
1828 1829
				}
			}
ilal committed
1830 1831
			List<YgglMainEmp> ygglMainEmps = empNumsConfirm(orgCode, leaderList);
//			List<LoginerChargeDto> loginerChargeDtos = new ArrayList<LoginerChargeDto>();
ilal committed
1832 1833 1834
			
			for (Integer leaderId : leaderList) {
				for (YgglMainEmp m : ygglMainEmps) {
ilal committed
1835
					if(leaderId.equals(m.getEmpNum())) {
ilal committed
1836 1837 1838 1839 1840
						if (m.getHeadUrl() == null) {
							m.setHeadUrl(CommonEnum.NULL_STR.getDesc());
						}
						loginerChargeDtos.add(new LoginerChargeDto(m.getEmpNum(), m.getName(), m.getHeadUrl()));
					}
ilal committed
1841
				}
ilal committed
1842
				
1843
			}
ilal committed
1844 1845
			
			
ilal committed
1846 1847
			Collections.reverse(loginerChargeDtos);
			return ResultUtil.data(loginerChargeDtos);
1848
		}
1849
		return ResultUtil.data(loginerChargeDtos);
ilal committed
1850
		
1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887
	}

	// 根据传来的empNum获取该人员信息,没有则传全部
	public List<YgglMainEmp> empNumsConfirm(Integer orgCode, List<Integer> empNumList) {
		List<YgglMainEmp> all = new LambdaQueryChainWrapper<YgglMainEmp>(ygglMainEmpMapper)
				.eq(YgglMainEmp::getOrgCode, orgCode).list();
		List<YgglMainEmp> ygglMainEmps = new ArrayList<YgglMainEmp>();
		if (empNumList.size() != 0) {
			for (Integer empNum : empNumList) {
				all.stream().filter(item -> empNum.equals(item.getEmpNum())).forEach(action -> {
					ygglMainEmps.add(action);
				});
			}
		} else {
			ygglMainEmps.addAll(all);
		}

		return ygglMainEmps;
	}

	// 根据传来的empNum获取该人员信息
	public YgglMainEmp empNumConfirm(Integer orgCode, Integer empNum) {
		YgglMainEmp one = new LambdaQueryChainWrapper<YgglMainEmp>(ygglMainEmpMapper)
				.eq(YgglMainEmp::getOrgCode, orgCode).eq(YgglMainEmp::getEmpNum, empNum).one();
		return one;
	}

	/**
	 * 获取用户头像
	 * 
	 * @param
	 * @return
	 */
	@PostMapping(value = "/headphotos")
	@ApiOperation(value = "71.获取用户头像", httpMethod = "POST", notes = "接口发布说明")
	@ApiOperationSupport(order = 71)
	public Result<List<YgglMainEmp>> headphotos(@CurrentUser UserBean userBean, @RequestBody List<Integer> empNumList) {
tangzhaoqian committed
1888
		if (empNumList == null || empNumList.size() == 0) {
ilal committed
1889
			return ResultUtil.error("存在未设置的审批人");
1890 1891 1892 1893 1894 1895 1896
		}
		List<YgglMainEmp> yglList = YgglMainEmp.builder().build()
				.selectList(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getOrgCode, userBean.getOrgCode())
						.in(YgglMainEmp::getEmpNum, empNumList)
						.select(YgglMainEmp::getEmpNum, YgglMainEmp::getName, YgglMainEmp::getHeadUrl));
		for (YgglMainEmp yg : yglList) {
			if (StringUtil.isEmpty(yg.getHeadUrl())) {
1897
				yg.setHeadUrl(CommonEnum.NULL_STR.getDesc());
1898 1899
			}
		}
1900
		return ResultUtil.data(yglList);
1901
	}
lal committed
1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916
	
	
	@Autowired
	private KqglAssoLeaveBalanceMapper kqglassoleavebalancemapper;
	
	@GetMapping(value = "/address_book")
	@ApiOperation(value = "APP 获取通讯录", httpMethod = "GET", notes = "接口发布说明")
	@ApiOperationSupport(order = 70)
	public Result<Object> Getaddressbook(@CurrentUser UserBean userBean) {
		
		List<AdditionalDto> userlist = kqglassoleavebalancemapper.selectAdditionalList(userBean.getOrgCode());
		
		return ResultUtil.data(userlist);
	}
	
ilal committed
1917 1918 1919 1920 1921 1922 1923 1924
	
	@PostMapping(value = "/modify_avatar")
	@ApiOperation(value = "APP_修改头像", httpMethod = "POST", notes = "接口发布说明")
	public Result<YgglAttaSbgjj> Modify_Avatar(@CurrentUser UserBean userBean, @RequestBody ModifyAvatarDto modifyavatardto) {
		
		YgglMainEmp.builder().headUrl(modifyavatardto.getAvatar_path()).build().update(new QueryWrapper<YgglMainEmp>().lambda().eq(YgglMainEmp::getOrgCode, userBean.getOrgCode())
				.eq(YgglMainEmp::getEmpNum, userBean.getEmpNum()));
		
ilal committed
1925 1926 1927
		QyzxEmpLogin.builder().headUrl(modifyavatardto.getAvatar_path()).build().update(new QueryWrapper<QyzxEmpLogin>().lambda().eq(QyzxEmpLogin::getOrgId, userBean.getOrgCode())
				.eq(QyzxEmpLogin::getPhone, userBean.getQyzxEmpLogin().getPhone()));
		
ilal committed
1928 1929 1930
		return ResultUtil.success("上传成功");
	}
	
ilal committed
1931 1932 1933
	
	
	
1934
}