/* * 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.shareholder.service.impl; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.springblade.common.utils.DesensitizedUtil; import org.springblade.core.log.exception.ServiceException; import org.springblade.core.tool.utils.BeanUtil; import org.springblade.modules.information.entity.Information; import org.springblade.modules.shareholder.entity.Shareholder; import org.springblade.modules.shareholder.excel.shareExcel; import org.springblade.modules.shareholder.mapper.ShareholderMapper; import org.springblade.modules.shareholder.service.IShareholderService; import org.springblade.modules.shareholder.vo.ShareholderVO; import org.springblade.modules.system.service.IUserDeptService; import org.springblade.modules.system.service.MyAsyncService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.List; import java.util.Objects; /** * 服务实现类 * * @author BladeX * @since 2021-07-06 */ @Service public class ShareholderServiceImpl extends ServiceImpl implements IShareholderService { @Autowired private IUserDeptService userDeptService; @Autowired private MyAsyncService myAsyncService; @Override public IPage selectShareholderPage(IPage page, ShareholderVO shareholder) { return page.setRecords(baseMapper.selectShareholderPage(page, shareholder)); } @Override public IPage selectShareholderInfo(IPage page, ShareholderVO shareholderVO) { return page.setRecords(baseMapper.selectShareholderInfo(page,shareholderVO)); } @Override public void importshare(List data, Boolean isCovered) { data.forEach(shareExcel -> { Shareholder shareholder = Objects.requireNonNull(BeanUtil.copy(shareExcel, Shareholder.class)); String deptId = userDeptService.selectIn(shareExcel.getDeptId()); if (null==deptId || deptId==""){ throw new ServiceException("公司名:["+shareExcel.getDeptId()+"]不存在!"); } shareholder.setDeptId(deptId); try { shareholder.setCapitaltime(new SimpleDateFormat("yyyy/MM/dd").parse(shareExcel.getCapitaltime())); } catch (ParseException e) { e.printStackTrace(); } if (null!=shareExcel.getCapital() && shareExcel.getCapital()!=""){ shareholder.setCapital(shareExcel.getCapital()); } if (null!=shareExcel.getShareholdingratio() && shareExcel.getShareholdingratio()!=""){ shareholder.setShareholdingratio(shareExcel.getShareholdingratio()); } Shareholder shareholder1 = Objects.requireNonNull(BeanUtil.copy(shareholder, Shareholder.class)); //脱敏处理 if (null!=shareholder1.getCardid() && !shareholder1.getCardid().equals("")){ shareholder1.setCardid(DesensitizedUtil.desensitizedIdNumberBy4(shareholder1.getCardid())); } if (null!=shareholder1.getCell() && !shareholder1.getCell().equals("")){ shareholder1.setCell(DesensitizedUtil.desensitizedPhoneNumber(shareholder1.getCell())); } //新增 this.save(shareholder1); if (shareholder.getCapitaltime() == null) { String s1 = "insert into sys_shareholder(id,shareholder,shareholdingratio,capital,cardid,cell,creditCode,dept_id) " + "values(" + "'" + shareholder1.getId() + "'" + "," + "'" + shareholder.getShareholder() + "'" + "," + "'" + shareholder.getShareholdingratio() + "'" + "," + "'" + shareholder.getCapital() + "'" + "," + "'" + shareholder.getCardid() + "'" + "," + "'" + shareholder.getCell() + "'" + "," + "'" + shareholder.getCreditcode() + "'" + "," + "'" + shareholder.getDeptId() + "'" + ")"; myAsyncService.FTP(s1); } else { String s1 = "insert into sys_shareholder(id,shareholder,shareholdingratio,capital,capitalTime,cardid,cell,creditCode,dept_id) " + "values(" + "'" + shareholder1.getId() + "'" + "," + "'" + shareholder.getShareholder() + "'" + "," + "'" + shareholder.getShareholdingratio() + "'" + "," + "'" + shareholder.getCapital() + "'" + "," + "'" + new SimpleDateFormat("yyyy-MM-dd").format(shareholder.getCapitaltime()) + "'" + "," + "'" + shareholder.getCardid() + "'" + "," + "'" + shareholder.getCell() + "'" + "," + "'" + shareholder.getCreditcode() + "'" + "," + "'" + shareholder.getDeptId() + "'" + ")"; myAsyncService.FTP(s1); } }); } }