package com.product.org.admin.service;
|
|
import com.product.admin.config.SystemCode;
|
import com.product.common.lang.StringUtils;
|
import com.product.core.dao.BaseDao;
|
import com.product.core.entity.DataTableEntity;
|
import com.product.core.entity.FieldSetEntity;
|
import com.product.core.exception.BaseException;
|
import com.product.core.permission.PermissionService;
|
import com.product.core.service.support.AbstractBaseService;
|
import com.product.core.service.support.QueryFilterService;
|
import com.product.core.transfer.Transactional;
|
import com.product.org.admin.config.CmnConst;
|
import com.product.org.admin.service.idel.IChangeDimissionService;
|
import com.product.util.BaseUtil;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
/**
|
* Copyright LX-BASE
|
*
|
* @Title: ChangeDimissionService
|
* @Project: LX-BASE-SERVER
|
* @Date: 2020年6月10日 下午3:49:58
|
* @Author: 郑盟
|
* @Description:
|
*/
|
@Component
|
public class ChangeDimissionService extends AbstractBaseService implements IChangeDimissionService{
|
|
@Autowired
|
public BaseDao baseDao;
|
|
@Autowired
|
PermissionService permissionService;
|
|
@Autowired
|
QueryFilterService queryFilterService;
|
|
|
/**
|
* 员工离职详情
|
* @param uuid
|
* @return
|
* @throws BaseException
|
*/
|
public FieldSetEntity findDimission(String uuid) throws BaseException {
|
return baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_STAFF_TERMINATION, uuid, false);
|
}
|
|
|
/**
|
* 员工离职列表
|
* @param fs
|
* @return
|
* @throws BaseException
|
*/
|
public DataTableEntity listDimission(FieldSetEntity fs) throws BaseException {
|
|
String dataFilter=permissionService.getDataFilter("b."+CmnConst.ORG_LEVEL_UUID) ;
|
//高级查询
|
String searchFilter=queryFilterService.getQueryFilter(fs);
|
|
if(!StringUtils.isEmpty(dataFilter)) {
|
dataFilter=" WHERE "+dataFilter;
|
if (!StringUtils.isEmpty(searchFilter)) {
|
dataFilter+=" AND "+ searchFilter;
|
}
|
}else {
|
if (!StringUtils.isEmpty(searchFilter)) {
|
dataFilter=searchFilter;
|
}
|
}
|
|
StringBuilder sql=new StringBuilder();
|
sql.append(" select * from (");
|
sql.append(" SELECT a.uuid uuid,b.uuid uuid1,c.uuid uuid2,d.uuid uuid3,e.uuid uuid4,f.uuid uuid5,a.apply_staff_uuid,a.termination_reason,a.change_effective,a.result_status,b.show_name,b.preferred_name,c.client_name,d.org_level_all,e.job_post_name,f.job_grade_name ");
|
sql.append(" FROM product_sys_staff_termination a ");
|
sql.append(" LEFT JOIN product_sys_staffs b ON a.apply_staff_uuid=b.uuid ");
|
sql.append(" LEFT JOIN product_sys_clients c ON c.uuid=b.client_uuid ");
|
sql.append(" LEFT JOIN product_sys_org_levels d ON d.uuid=b.dept_uuid ");
|
sql.append(" LEFT JOIN product_sys_job_posts e ON e.uuid=b.job_post_uuid ");
|
sql.append(" LEFT JOIN product_sys_job_post_grades f ON f.uuid=b.job_post_grade_uuid ");
|
sql.append(dataFilter);
|
sql.append(" ) b");
|
|
DataTableEntity dt=baseDao.listTable(sql.toString(), null, fs.getInteger("pagesize"), fs.getInteger("cpage"));
|
dt.getMeta().addAliasTable(CmnConst.PRODUCT_SYS_STAFF_TERMINATION,"a");
|
dt.getMeta().addAliasTable(CmnConst.PRODUCT_SYS_STAFFS,"b");
|
dt.getMeta().addAliasTable("product_sys_clients","c");
|
dt.getMeta().addAliasTable("product_sys_org_levels","d");
|
dt.getMeta().addAliasTable("product_sys_job_posts","e");
|
dt.getMeta().addAliasTable("product_sys_job_post_grades","f");
|
dt.getMeta().addAliasField("product_sys_staffs.uuid", "uuid1");
|
dt.getMeta().addAliasField("product_sys_staffs.show_name", "show_name");
|
|
if (!BaseUtil.dataTableIsEmpty(dt)) {
|
baseDao.loadPromptData(dt);
|
baseDao.listInternationDataTable(dt, null);
|
}
|
|
return dt;
|
}
|
|
/**
|
* 离职新增
|
* @param fs
|
* @return
|
* @throws BaseException
|
*/
|
@Transactional
|
public String addDimission(FieldSetEntity fs) throws BaseException {
|
String staff_uuid = fs.getString(CmnConst.APP_STAFF_UUID);
|
String sql = " SELECT uuid FROM product_sys_staffs WHERE staff_status in(1,2,3) and uuid not in (SELECT apply_staff_uuid FROM product_sys_staff_termination WHERE result_status<>2 or result_status is null or result_status='') AND uuid =? ";
|
DataTableEntity listTable = baseDao.listTable(sql, new Object[] {staff_uuid});
|
if (listTable.getRows() == 0) {
|
throw new BaseException(SystemCode.SYSTEM_STAFFS_WHERE_FAIL.getValue(),SystemCode.SYSTEM_STAFFS_WHERE_FAIL.getText(), this.getClass(), "addDimission");
|
}
|
FieldSetEntity staff_fs = baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_STAFFS, staff_uuid, false);
|
fs.setValue("org_level_uuid", staff_fs.getString("org_level_uuid"));
|
fs.setValue("apply_dept_uuid", staff_fs.getString("dept_uuid"));
|
fs.setValue("job_post_uuid", staff_fs.getString("job_post_uuid"));
|
fs.setValue("role_uuids", staff_fs.getString("role_uuids"));
|
fs.setValue("direct_leader_code", staff_fs.getString("direct_leader_code"));
|
fs.setValue(CmnConst.RESULT_STATUS, 0);
|
baseDao.executeUpdate("update product_sys_staffs set staff_status=5 where uuid=?", new String[] { staff_uuid });
|
baseDao.executeUpdate("update product_sys_staff_employment_info set termination_effective_date=? where staff_uuid=?", new Object[] {fs.getString(CmnConst.CHANGE_EFFECTIVE),staff_uuid}); //杜洪波 2020-12-30 14:58:00 就业信息显示离职日期
|
String add = baseDao.add(fs);
|
return add;
|
}
|
|
/**
|
* 根据人员id获取人员信息
|
* @param staff_uuid
|
* @return
|
* @throws BaseException
|
*/
|
public FieldSetEntity getStaff(String staff_uuid) throws BaseException {
|
FieldSetEntity staff_fs = baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_STAFFS, staff_uuid, false);
|
baseDao.loadPromptData(staff_fs);
|
return staff_fs;
|
}
|
|
/**
|
* 离职申请修改
|
* @param fs
|
* @return
|
* @throws BaseException
|
*/
|
public boolean updateDimission(FieldSetEntity fs) throws BaseException {
|
String uuid = fs.getString("uuid");
|
FieldSetEntity fss = baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_STAFF_TERMINATION, uuid, false);
|
String handover_staff_uuid = fss.getString("handover_staff_uuid");
|
fs.setValue(CmnConst.RESULT_STATUS, fss.getString(CmnConst.RESULT_STATUS));
|
fs.remove("handover_date");
|
if (!StringUtils.isEmpty(handover_staff_uuid)) {
|
fs.setValue("handover_staff_uuid", handover_staff_uuid);
|
fs.setValue("handover_detail", fss.getString("handover_detail"));
|
fs.setValue("attachment", fss.getString("attachment"));
|
fs.setValue(CmnConst.CHANGE_EFFECTIVE, fss.getString(CmnConst.CHANGE_EFFECTIVE));
|
}
|
//杜洪波 2020-12-30 14:58:00 就业信息显示离职日期
|
baseDao.executeUpdate("update product_sys_staff_employment_info set termination_effective_date=? where staff_uuid=?", new Object[] {fs.getDate(CmnConst.CHANGE_EFFECTIVE),fs.getString(CmnConst.APP_STAFF_UUID)});
|
return baseDao.update(fs);
|
}
|
|
/**
|
* 离职申请删除
|
* @param uuid
|
* @return
|
* @throws BaseException
|
*/
|
@Transactional
|
public boolean deleteDimission(String uuid)throws BaseException {
|
FieldSetEntity fseDimission=baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_STAFF_TERMINATION, uuid, false);
|
if (fseDimission!=null) {
|
baseDao.executeUpdate("update product_sys_staffs set staff_status=3 where uuid=?", new Object[]{fseDimission.getString(CmnConst.APP_STAFF_UUID)});
|
baseDao.executeUpdate("update product_sys_staff_employment_info set termination_effective_date=null where staff_uuid=?", new Object[] {fseDimission.getString(CmnConst.APP_STAFF_UUID)}); //杜洪波 2020-12-30 14:58:00 就业信息显示离职日期
|
}
|
boolean flag=baseDao.delete(CmnConst.PRODUCT_SYS_STAFF_TERMINATION, "uuid=?", new Object[] {uuid});
|
return flag;
|
}
|
|
}
|
