教育训练处考试制证系统后端
“djh”
2025-02-20 ca90224ae08ff40b78daad37175639cae71c0855
exam-system/src/main/java/com/gkhy/exam/pay/service/impl/CoalPayStudentServiceImpl.java
@@ -10,10 +10,8 @@
import com.ruoyi.common.core.domain.model.LoginUser;
import com.ruoyi.common.exception.BusinessException;
import com.ruoyi.common.utils.SecurityUtils;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import com.ruoyi.common.utils.StringUtils;
import org.apache.poi.ss.usermodel.*;
import org.aspectj.weaver.loadtime.Aj;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
@@ -94,13 +92,26 @@
                coalPayStudent.setCoalPayId(coalPayId);
                if (row!=null){
                    coalPayStudent.setName(row.getCell(0).getStringCellValue());
                    coalPayStudent.setIdCard(row.getCell(1).getStringCellValue());
                    String idCard = row.getCell(1).getStringCellValue();
                    coalPayStudent.setIdCard(idCard);
                    coalPayStudent.setPhone(row.getCell(2).getStringCellValue());
                    String stringCellValue = row.getCell(3).getStringCellValue();
                    if (stringCellValue.equals("男")){
                        coalPayStudent.setSex(0L);
                    }else if (stringCellValue.equals("女")){
                        coalPayStudent.setSex(1L);
                    Cell cell = row.getCell(3);
                    if (cell!=null){
                        if (StringUtils.isEmpty(cell.getStringCellValue())){
                            coalPayStudent.setTrain("-");
                        }else{
                            coalPayStudent.setTrain(cell.getStringCellValue());
                        }
                    }
                    char c = idCard.charAt(idCard.length() - 1);
                    if (Character.isDigit(c)){
                        int genderDigit = Character.getNumericValue(c);
                        if (genderDigit % 2 == 1) {
                            coalPayStudent.setSex(0L);
                        } else {
                            coalPayStudent.setSex(1L);
                        }
                    }
                    coalPayStudent.setPayStatus(0L);
                    coalPayStudent.setCreateBy(loginUser.getUsername());
@@ -141,4 +152,26 @@
    public List<CoalPayStudent> selectbyIdcard(CoalPayStudentReq coalPayStudent) {
        return coalPayStudentMapper.selectByIdcard(coalPayStudent);
    }
    @Override
    public List<CoalPayStudent> selectbyId(Long studentId) {
        List<Long> longs = new ArrayList<>();
        longs.add(studentId);
        return coalPayStudentMapper.selectBatchIds(longs);
    }
    @Override
    public void updateByCoalPayId(CoalPayStudent coalPayStudent) {
        coalPayStudentMapper.updateByCoalPayId(coalPayStudent);
    }
    @Override
    public void updateByCoalPayIdAndStatus(CoalPayStudent payStudent) {
        coalPayStudentMapper.updateByCoalPayIdAndStatus(payStudent);
    }
    @Override
    public void updateByIdAndPayType(CoalPayStudent payStudent) {
        coalPayStudentMapper.updateByIdAndPayType(payStudent);
    }
}