package com.product.org.admin.service;

import com.product.common.lang.StringUtils;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

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.IDimissionHandoverService;
import com.product.util.BaseUtil;

/**
 * Copyright LX-BASE
 * 
 * @Title: DimissionHandoverService
 * @Project: LX-BASE-SERVER
 * @Date: 2020年6月11日 下午5:25:34
 * @Author: 郑盟
 * @Description: 离职交接
 */
@Component
public class DimissionHandoverService extends AbstractBaseService implements IDimissionHandoverService{
	
	@Autowired
	public BaseDao baseDao;
	
	@Autowired
	PermissionService permissionService;

	@Autowired
	QueryFilterService queryFilterService;
	
	/**
	 * 离职交接详情
	 * 
	 * @param uuid
	 * @return
	 * @throws BaseException
	 */
	public FieldSetEntity findHandover(String uuid) throws BaseException {
		return baseDao.getFieldSetEntity("product_sys_staff_termination", uuid,false);
	}

	/**
	 * 离职交接列表
	 * @param fs
	 * @return
	 * @throws BaseException
	 */
	public DataTableEntity listHandover(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();

		//luoxin 添加字段  a.handover_staff_uuid,a.handover_date     交接人     交接时间
		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,a.handover_staff_uuid,a.handover_date,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("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
	 */
	public boolean addHandover(FieldSetEntity fs) throws BaseException {
		String staff_uuid = fs.getString("apply_staff_uuid");
		FieldSetEntity fss = baseDao.getFieldSetEntityByFilter(CmnConst.PRODUCT_SYS_STAFF_TERMINATION,
				"result_status=0 and apply_staff_uuid =?", new String[] {staff_uuid}, false);
		fss.setValue(CmnConst.HANDOVER_STAFF_UUID, fs.getString(CmnConst.HANDOVER_STAFF_UUID));
		fss.setValue(CmnConst.HANDOVER_DATE, fs.getString(CmnConst.HANDOVER_DATE));
		fss.setValue(CmnConst.HANDOVER_DETAIL, fs.getString(CmnConst.HANDOVER_DETAIL));
		fss.setValue(CmnConst.ATTACHMENT, fs.getString(CmnConst.ATTACHMENT));
		return baseDao.update(fss);
	}

	/**
	 * 离职交接修改
	 * @param fs
	 * @return
	 * @throws BaseException
	 */
	@Transactional
	public boolean updateHandover(FieldSetEntity fs) throws BaseException {
		String uuid = fs.getString("uuid");
		FieldSetEntity fss = baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_STAFF_TERMINATION, uuid, false);
		if (fss != null) {
			fss.setValue(CmnConst.HANDOVER_STAFF_UUID, fs.getString(CmnConst.HANDOVER_STAFF_UUID));
			fss.setValue(CmnConst.HANDOVER_DATE, fs.getString(CmnConst.HANDOVER_DATE));
			fss.setValue(CmnConst.HANDOVER_DETAIL, fs.getString(CmnConst.HANDOVER_DETAIL));
			fss.setValue(CmnConst.ATTACHMENT, fs.getString(CmnConst.ATTACHMENT));
		}
//		处理删除的文件
		String delete_attachments = fs.getString("delete_attachments");
		if (!StringUtils.isEmpty(delete_attachments)) {
			String[] split = delete_attachments.split(",");
			for (int i = 0; i < split.length; i++) {
				baseDao.delete("product_sys_attachments", new Object[] { split[i] });
			}
		}
		return baseDao.update(fss);
	}
	
	/**
	 * 员工交接删除
	 * @param fs
	 * @return
	 * @throws BaseException
	 */
	@Transactional
	public boolean delectHandover(FieldSetEntity fs) throws BaseException {

		// 删除文件
		FieldSetEntity product_sys_staff_termination = baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_STAFF_TERMINATION,fs.getUUID(), false);
		String changeUuids =product_sys_staff_termination.getString("apply_staff_uuid") + ","+product_sys_staff_termination.getString(CmnConst.HANDOVER_STAFF_UUID);
		baseDao.delete("product_sys_attachments", "staff_uuid=? and attachment_data_field='attachment' and attachment_data_table='product_sys_staff_termination'",new String[] { changeUuids });

		String uuid = fs.getString("uuid");
		if (StringUtils.isEmpty(uuid)) {	//杜洪波 updateTime 2020-12-17 09:48:00
			return false;
		}
		FieldSetEntity fss = baseDao.getFieldSetEntity(CmnConst.PRODUCT_SYS_STAFF_TERMINATION, uuid, false);
		fss.setValue(CmnConst.HANDOVER_STAFF_UUID, null);
		fss.setValue(CmnConst.HANDOVER_DATE, null);
		fss.setValue(CmnConst.HANDOVER_DETAIL, null);
		fss.setValue(CmnConst.ATTACHMENT, null);
		return baseDao.update(fss);
	}


}