JobDictServiceImpl.java 4.59 KB
package com.laowu.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.laowu.common.exception.HttpException;
import com.laowu.dto.job.BatchAddJobDTO;
import com.laowu.dto.job.JobDTO;
import com.laowu.dto.job.JobManagementDTO;
import com.laowu.mapper.CompanyPhotoMapper;
import com.laowu.mapper.JobDictMapper;
import com.laowu.mapper.PositionDictMapper;
import com.laowu.model.CompanyPhotoDO;
import com.laowu.model.JobDictDO;
import com.laowu.service.JobDictService;
import com.laowu.util.ConstantUtils;
import com.laowu.util.ExcelUtil;
import com.laowu.vo.job.JobManagementVO;
import com.laowu.vo.job.JobVO;
import com.laowu.vo.job.OneJobVO;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;

import java.util.List;

/**
 * <p>
 * 职位字典表 服务实现类
 * </p>
 *
 * @author Tuyp
 * @since 2023-02-15
 */
@Service
public class JobDictServiceImpl extends ServiceImpl<JobDictMapper, JobDictDO> implements JobDictService {

    @Autowired
    private CompanyPhotoMapper companyPhotoMapper;

    @Autowired
    private PositionDictMapper positionDictMapper;

    public IPage<JobVO> jobs(JobDTO jobDTO) {
        Page pager = new Page(jobDTO.getPageNum(), jobDTO.getPageSize());
        return this.baseMapper.jobs(pager, jobDTO.getRecruitId(), jobDTO.getCityId(), jobDTO.getPositions(), jobDTO.getJobType(), jobDTO.getJobName(),jobDTO.getRecruitStatus());
    }

    public OneJobVO oneJob(JobDictDO jobDictDO) {

        OneJobVO oneJob = this.baseMapper.oneJob(jobDictDO.getId());
        List<CompanyPhotoDO> companyPhotoDOS = companyPhotoMapper.selectList(new QueryWrapper<CompanyPhotoDO>()
                .lambda()
                .eq(CompanyPhotoDO::getCompanyId, oneJob.getCompanyId()));
        oneJob.setCompanyPhotoDOS(companyPhotoDOS);
        return oneJob;
    }

    public List<JobVO> relativeJobs(JobDictDO jobDictDO) {
        return this.baseMapper.relativeJobs(jobDictDO.getPositionId());
    }

    public IPage<JobManagementVO> jobManagement(JobManagementDTO jobManagementDTO) {
        Page pager = new Page(jobManagementDTO.getPageNum(), jobManagementDTO.getPageSize());
        return this.baseMapper.jobManagement(pager, jobManagementDTO.getRecruitId(), jobManagementDTO.getCityId(), jobManagementDTO.getPositions(), jobManagementDTO.getJobType(), jobManagementDTO.getRecruitStatus());
    }

    public String deleteJob(JobDictDO jobDictDO) {
        this.baseMapper.deleteById(jobDictDO.getId());
        return ConstantUtils.DELETE_SUCCESS;
    }

    public String updateJob(JobDictDO jobDictDO) {
        this.baseMapper.updateById(jobDictDO);
        return ConstantUtils.SUCCESS_UPDATE;
    }

    public String addJob(JobDictDO jobDictDO) {

        //生成职位id
        String positionCode = positionDictMapper.jobCode(jobDictDO.getPositionId());
        List<JobDictDO> jobDictDOS = this.baseMapper.selectList(new QueryWrapper<JobDictDO>()
                .lambda()
                .like(JobDictDO::getJobId, positionCode)
                .orderByDesc(JobDictDO::getCreateDate));

        if (jobDictDOS.size() > 0) {
            String substring = jobDictDOS.get(0).getJobId().substring(2);
            Integer cnt = Integer.parseInt(substring) + 1;
            jobDictDO.setJobId(positionCode + cnt);
        } else {
            jobDictDO.setJobId(positionCode + "100001");
        }
        this.baseMapper.insert(jobDictDO);
        return ConstantUtils.ADD_SUCCESS;
    }

    @Transactional(rollbackFor = Exception.class)
    public String batchAddJob(Integer jobType, MultipartFile multipartFile) {

        try {
            ExcelUtil.readExcelWithoutTitle(null, BatchAddJobDTO.class, multipartFile).forEach(s -> {
                JobDictDO jobDictDO = new JobDictDO();
                BeanUtils.copyProperties(s, jobDictDO);
                jobDictDO.setJobType(jobType);
                this.baseMapper.insert(jobDictDO);
            });
        } catch (Exception e) {
            e.printStackTrace();
            throw new HttpException(10001);
        }
        return ConstantUtils.IMPORT_SUCCESS;
    }


    public static void main(String[] args) {
        String abc = "AB100001";
        Integer a = Integer.parseInt(abc.substring(2)) + 1;
        System.out.println(a);

    }

}