/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
package org.springblade.modules.social.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import lombok.AllArgsConstructor;
import org.apache.commons.lang3.StringUtils;
import org.springblade.core.log.exception.ServiceException;
import org.springblade.core.tool.utils.BeanUtil;
import org.springblade.modules.social.entity.Social;
import org.springblade.modules.social.excel.SocialExcel;
import org.springblade.modules.social.mapper.SocialMapper;
import org.springblade.modules.social.service.ISocialService;
import org.springblade.modules.social.vo.SocialVO;
import org.springblade.modules.system.entity.User;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Objects;

/**
 *  服务实现类
 *
 * @author BladeX
 * @since 2021-07-16
 */
@Service
public class SocialServiceImpl extends ServiceImpl<SocialMapper, Social> implements ISocialService {

	@Autowired
	private MyAsyncService myAsyncService;

	@Autowired
	private IUserService userService;


	@Override
	public IPage<SocialVO> selectSocialPage(IPage<SocialVO> page, SocialVO social) {
		return page.setRecords(baseMapper.selectSocialPage(page, social));
	}

	@Override
//	@Transactional(rollbackFor = Exception.class)
	public void importUser(List<SocialExcel> data, Boolean isCovered,String deptid) {
		//没有录入的人员
		List<String> notFoundList = new ArrayList<>();
		int num = 0;
		//遍历
		for (SocialExcel socialExcel : data) {
			Social social = Objects.requireNonNull(BeanUtil.copy(socialExcel, Social.class));
			if (StringUtils.isBlank(social.getCardid())){
				throw new ServiceException("身份证号不能为空!");
			}
			//判断人员是否已录入
			User user = userService.getUserInfoByIdCardNo(social.getCardid());
			if (null == user){
				notFoundList.add(social.getCardid());
				num ++;
				//终止本个循环，继续下一个循环
				continue;
			}

			//设置用户id
			social.setNamb(user.getId().toString());

//			if (null!=social.getSex() && !"".equals(social.getSex())) {
//				if (social.getSex().contains("男")){
//					social.setSex("1");
//				}
//				if (social.getSex().contains("女")){
//					social.setSex("2");
//				}
//			}
			if (null!=social.getBirthday()) {
				social.setBirthday(social.getBirthday());
			}
			if (null!=social.getTelephone() && !"".equals(social.getTelephone())) {
				social.setTelephone(social.getTelephone());
			}
			if (null!=social.getResidence() && !"".equals(social.getResidence())) {
				social.setResidence(social.getResidence());
			}
			if (null!=social.getAddress() && !"".equals(social.getAddress())) {
				social.setAddress(social.getAddress());
			}
			if (null!=social.getNature() && !"".equals(social.getNature())) {
				social.setNature(social.getNature());
			}
			if (null!=social.getNation() && !"".equals(social.getNation())) {
				social.setNation(social.getNation());
			}
			social.setDeptid(deptid);
			//设置状态
			this.upSoil(social.getCardid());
			//新增
			boolean save = this.save(social);

			if (save) {
				//内网同步
				String sql =
					"insert into sys_socil(id,namb,sex,nation,telephone,cardid,residence,amount,insuredtime,deptid) " +
						"values(" + "'" + social.getId() + "'"
						+ "," + "'" + social.getNamb() + "'"
						+ "," + "'" + social.getSex() + "'" +
						"," + "'" + social.getNation() + "'" +
						"," + "'" + social.getTelephone() + "'" +
						"," + "'" + social.getCardid() + "'" +
						"," + "'" + social.getResidence() + "'" +
						"," + "'" + social.getAmount() + "'" +
						"," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(social.getInsuredtime()) + "'" +
						"," + "'" + social.getDeptid() + "'" + ")";
				myAsyncService.dataSync(sql);
			}
		}

		//如果所有数据导入有一个异常
		StringBuilder errorBuilder = new StringBuilder();
		if (num>0){
			String errorAccount = StringUtils.join(notFoundList, "\\\n");
			errorBuilder.append("用户:[" + errorAccount + "]社保记录导入失败!该人员尚未录入!");
		}
		//抛出异常
		if (errorBuilder.length()>0){
			throw new ServiceException(errorBuilder.toString());
		}

	}

	@Override
	public void upSoil(String cardid) {
		baseMapper.upSoil(cardid);
	}

}