package cn.com.goldenwater.dcproj.service.impl;

import cn.com.goldenwater.core.service.AbstractCrudService;
import cn.com.goldenwater.dcproj.constValue.SplitValue;
import cn.com.goldenwater.dcproj.dao.BisInspAllWorkerPersDao;
import cn.com.goldenwater.dcproj.model.BisInspAllRlationPers;
import cn.com.goldenwater.dcproj.model.BisInspAllWorkerPers;
import cn.com.goldenwater.dcproj.param.BisInspAllRlationPersParam;
import cn.com.goldenwater.dcproj.param.BisInspAllWorkerPersParam;
import cn.com.goldenwater.dcproj.service.BisInspAllRlationPersService;
import cn.com.goldenwater.dcproj.service.BisInspAllWorkerPersService;
import cn.com.goldenwater.dcproj.util.CheckUtil;
import cn.com.goldenwater.dcproj.utils.Builder;
import cn.com.goldenwater.dcproj.utils.expExcel.ExportUtil;
import cn.com.goldenwater.id.util.UuidUtil;
import cn.com.goldenwater.util.common.IdCardUtils;
import com.alibaba.fastjson.JSON;
import org.apache.commons.lang3.StringUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * @author
 * @date 2021-11-3
 */
@Service
@Transactional
public class BisInspAllWorkerPersServiceImpl extends AbstractCrudService<BisInspAllWorkerPers, BisInspAllWorkerPersParam> implements BisInspAllWorkerPersService {

    private Logger logger = LoggerFactory.getLogger(getClass());

    @Autowired
    private BisInspAllWorkerPersDao bisInspAllWorkerPersDao;

    @Autowired
    private BisInspAllRlationPersService bisInspAllRlationPersService;

    public BisInspAllWorkerPersServiceImpl(BisInspAllWorkerPersDao bisInspAllWorkerPersDao) {
        super(bisInspAllWorkerPersDao);
        this.bisInspAllWorkerPersDao = bisInspAllWorkerPersDao;
    }

    @Override
    public int insert(BisInspAllWorkerPers bisInspAllWorkerPers) {
        CheckUtil.notEmpty(bisInspAllWorkerPers.getPersName(), "专家姓名为必填参数");
        CheckUtil.notEmpty(bisInspAllWorkerPers.getSpecialty(), "专家专业为必填参数");
        CheckUtil.notEmpty(bisInspAllWorkerPers.getDpnm(), "专家单位为必填参数");
        CheckUtil.notEmpty(bisInspAllWorkerPers.getIdNumber(), "专家身份证号为必填参数");
        bisInspAllWorkerPers.setBornDate(IdCardUtils.getBirthdayDate(bisInspAllWorkerPers.getIdNumber()));
        bisInspAllWorkerPers.setAge(Long.parseLong(String.valueOf(IdCardUtils.getAge(bisInspAllWorkerPers.getIdNumber()).intValue())));
        String uuid = UuidUtil.uuid();
        bisInspAllWorkerPers.setId(uuid);
        bisInspAllWorkerPers.setIntm(new Date());
        bisInspAllWorkerPers.setUptm(new Date());
        bisInspAllWorkerPers.setDataStat("0");

        // 关联用户表
        associatedUsers(bisInspAllWorkerPers);

        logger.info("insert 督查专家：{}", JSON.toJSONString(bisInspAllWorkerPers));
        return this.bisInspAllWorkerPersDao.insert(bisInspAllWorkerPers);
    }

    /**
     * 关联用户表： 通过手机号码查找用户表有无数据，有数据，获取GUID， 无数据创建用户表
     *
     * @param bisInspAllWorkerPers
     */
    private void associatedUsers(BisInspAllWorkerPers bisInspAllWorkerPers) {
        if (StringUtils.isNotBlank(bisInspAllWorkerPers.getGuid()) || StringUtils.isBlank(bisInspAllWorkerPers.getMobilenumb())) {
            return;
        }
        BisInspAllRlationPers pers = bisInspAllRlationPersService.getBy(Builder.of(BisInspAllRlationPersParam::new)
                .with(BisInspAllRlationPersParam::setMobilenumb, bisInspAllWorkerPers.getMobilenumb())
                .build());

        if (pers != null) {
            logger.debug(bisInspAllWorkerPers.getPersName() + ":" + bisInspAllWorkerPers.getMobilenumb() + " 已有帐号");
            bisInspAllWorkerPers.setGuid(pers.getGuid());
        } else {
            logger.debug(bisInspAllWorkerPers.getPersName() + ":" + bisInspAllWorkerPers.getMobilenumb() + " 无 帐号");
            pers = new BisInspAllRlationPers();
            BeanUtils.copyProperties(bisInspAllWorkerPers, pers);
            pers = bisInspAllRlationPersService.createUser(pers);
            bisInspAllWorkerPers.setGuid(pers.getGuid());
        }
    }

    @Override
    public int update(BisInspAllWorkerPers bisInspAllWorkerPers) {
        CheckUtil.notEmpty(bisInspAllWorkerPers.getPersName(), "专家姓名为必填参数");
        CheckUtil.notEmpty(bisInspAllWorkerPers.getSpecialty(), "专家专业为必填参数");
        CheckUtil.notEmpty(bisInspAllWorkerPers.getDpnm(), "专家单位为必填参数");
        CheckUtil.notEmpty(bisInspAllWorkerPers.getIdNumber(), "专家身份证号为必填参数");
        bisInspAllWorkerPers.setBornDate(IdCardUtils.getBirthdayDate(bisInspAllWorkerPers.getIdNumber()));
        bisInspAllWorkerPers.setAge(Long.parseLong(String.valueOf(IdCardUtils.getAge(bisInspAllWorkerPers.getIdNumber()).intValue())));
        bisInspAllWorkerPers.setUptm(new Date());
        // 关联用户表
        associatedUsers(bisInspAllWorkerPers);
        logger.info("update 督查专家：{}", JSON.toJSONString(bisInspAllWorkerPers));
        return this.bisInspAllWorkerPersDao.update(bisInspAllWorkerPers);
    }

    @Override
    public int delete(String id) {
        return this.bisInspAllWorkerPersDao.delete(id);
    }


    @Override
    public void export(BisInspAllWorkerPersParam bisInspAllWorkerPersParam, HttpServletResponse response) {
        List<BisInspAllWorkerPers> persList = findList(bisInspAllWorkerPersParam);
        persList.forEach(p -> {
            if ("1".equals(p.getSex())) {
                p.setSex("男");
            }
            if ("2".equals(p.getSex())) {
                p.setSex("女");
            }

            if ("0".equals(p.getIsWork())) {
                p.setIsWork("是");
            }
            if ("1".equals(p.getIsWork())) {
                p.setIsWork("否");
            }

            if ("1".equals(p.getIsCvlSrvnts())) {
                p.setIsCvlSrvnts("是");
            }
            if ("2".equals(p.getIsCvlSrvnts())) {
                p.setIsCvlSrvnts("否");
            }

            if (StringUtils.isNotBlank(p.getExpertPost())) {
                String[] expertPostArr = p.getExpertPost().split(SplitValue.DOUHAO_SPLIT);
                List<String> expertPostlist = new ArrayList<>(expertPostArr.length);

                for (String expertPost : expertPostArr) {
                    switch (expertPost) {
                        case "1":
                            expertPostlist.add("前期设计");
                            break;
                        case "2":
                            expertPostlist.add("建设管理");
                            break;
                        case "3":
                            expertPostlist.add("计划管理");
                            break;
                        case "4":
                            expertPostlist.add("财务管理");
                            break;
                        case "5":
                            expertPostlist.add("质量管理");
                            break;
                        case "6":
                            expertPostlist.add("运行管理");
                            break;
                        case "7":
                            expertPostlist.add("水土保持");
                            break;
                        case "8":
                            expertPostlist.add("水文水资源");
                            break;
                        case "9":
                            expertPostlist.add("安全生产");
                            break;
                        default:
                    }
                }
                p.setExpertPost(String.join("、", expertPostlist));
            }
        });

        List<String> columns = new ArrayList<String>() {{
            add("persName");
            add("sex");
            add("age");
            add("isWork");
            add("isCvlSrvnts");
            add("specialty");
            add("admDuty");
            add("dppost");
            add("dpnm");
            add("expertPost");
            add("mobilenumb");
            add("email");
            add("idNumber");
            add("remark");
        }};

        ExportUtil.exportExcel2(persList, response, "专家信息列表", columns, BisInspAllWorkerPers.class);
    }
}