新增批量缴费，未考试，已报名的

Administrator

2022-03-04 1ad510e0e7b57a533e70875d95b1da4f392d1b1e

新增批量缴费，未考试，已报名的

 src/main/java/org/springblade/modules/training/controller/TrainingRegistrationController.java

@@ -754,4 +754,37 @@
        //更新并返回数据
        return R.data(trainingRegistrationService.updateById(trainingRegistration));
    }

    /**
     * 批量将已报名人员标记为已缴费
     * @param trainingRegistration
     * @return
     */
    @PostMapping("/vipSignBatch")
    @Transactional(rollbackFor = Exception.class)
    public R vipSignBatch(@RequestBody TrainingRegistrationVo trainingRegistration){
        //查询已报名，未考试的报名信息
        List<TrainingRegistration> trainingRegistrationList = trainingRegistrationService.getList(trainingRegistration);
        if (trainingRegistrationList.size()>0){
            for (TrainingRegistration registration : trainingRegistrationList) {
                if (registration.getVipStatus().equals(2)) {
                    registration.setVipStatus(1);
                    //新增会员记录
                    userVipService.insertUserVipInfo(registration);
                    //新增会员题库记录
                    vipTopicService.insertVipTopicInfo(registration);
                    //内网报名信息同步
                    String s1 =
                        "update sys_training_registration set vip_status = " + "'" + registration.getVipStatus() + "'"
                            + " " + "where id = " + "'" + registration.getId() + "'";
                    //FtpUtil.sqlFileUpload(s1);
                    myAsyncService.FTP(s1);
                    //更新
                    trainingRegistrationService.updateById(registration);
                }
            }
        }
        //返回数据
        return R.data(true);
    }
}

 src/main/java/org/springblade/modules/training/mapper/TrainingRegistrationMapper.java

@@ -68,4 +68,10 @@
     */
    List<TrainingRegistration> selectTrainingRegistrationList(@Param("trainingRegistration") TrainingRegistration trainingRegistration);

    /**
     * 查看报名集合信息
     * @param trainingRegistration
     * @return
     */
    List<TrainingRegistration> getList(@Param("trainingRegistration") TrainingRegistrationVo trainingRegistration);
}

 src/main/java/org/springblade/modules/training/mapper/TrainingRegistrationMapper.xml

@@ -287,4 +287,73 @@
            and sr.cancel = #{trainingRegistration.cancel}
        </if>
    </select>


    <!--查询报名集合信息-->
    <select id="getList" resultType="org.springblade.modules.training.vo.TrainingRegistrationVo">
        SELECT
        sr.*
        FROM
        sys_training_registration sr
        LEFT JOIN
        blade_dept bt0
        ON
        sr.training_unit_id = bt0.id
        left join
        blade_user bu
        on
        sr.user_id = bu.id
        LEFT JOIN
        blade_dept bt
        ON
        bu.dept_id = bt.id
        left join
        ksxt_exam ke
        on
        ke.id = sr.train_exam_id
        left join sys_information si on si.departmentid = bt.id
        left join sys_jurisdiction sj on si.jurisdiction = sj.id
        WHERE
        1=1
        <if test="trainingRegistration.isExam!=null and trainingRegistration.isExam!=0">
            and is_exam = #{trainingRegistration.isExam}
        </if>
        <if test="trainingRegistration.trainingUnitId!=null and  trainingRegistration.trainingUnitId!=''">
            and sr.training_unit_id = #{trainingRegistration.trainingUnitId}
        </if>
        <if test="trainingRegistration.examId!=null and  trainingRegistration.examId!=''">
            and ke.id = #{trainingRegistration.examId}
        </if>
        <if test="trainingRegistration.userId!=null and  trainingRegistration.userId!=''">
            and sr.user_id = #{trainingRegistration.userId}
        </if>
        <if test="trainingRegistration.deptId!=null and  trainingRegistration.deptId!=''">
            and bu.dept_id = #{trainingRegistration.deptId}
        </if>
        <if test="trainingRegistration.auditStatus!=null and trainingRegistration.auditStatus!=0">
            and sr.audit_status = #{trainingRegistration.auditStatus}
        </if>
        <if test="trainingRegistration.vipStatus!=null and trainingRegistration.vipStatus!=0">
            and sr.vip_status = #{trainingRegistration.vipStatus}
        </if>
        <if test="trainingRegistration.deptName!=null and  trainingRegistration.deptName!=''">
            and bt.dept_name like concat('%', #{trainingRegistration.deptName},'%')
        </if>
        <if test="trainingRegistration.realName!=null and  trainingRegistration.realName!=''">
            and bu.real_name like concat('%', #{trainingRegistration.realName},'%')
        </if>
        <if test="trainingRegistration.idCardNo!=null and  trainingRegistration.idCardNo!=''">
            and bu.cardid like concat('%', #{trainingRegistration.idCardNo},'%')
        </if>
        <if test="trainingRegistration.cancel!=null and trainingRegistration.cancel!=0">
            and sr.cancel = #{trainingRegistration.cancel}
        </if>
        <if test="trainingRegistration.isTrain!=null">
            and bu.is_train = #{trainingRegistration.isTrain}
        </if>
        <if test="trainingRegistration.jurisdiction!=null and trainingRegistration.jurisdiction!='' and trainingRegistration.jurisdiction!='1372091709474910209'">
            and (sj.id=#{trainingRegistration.jurisdiction} or sj.parent_id = #{trainingRegistration.jurisdiction})
        </if>
        order by sr.id desc
    </select>
</mapper>

 src/main/java/org/springblade/modules/training/service/TrainingRegistrationService.java

@@ -72,4 +72,10 @@
     * 考试中的
     */
    void examLoading();

    /**
     * 查看报名集合信息
     * @return
     */
    List<TrainingRegistration> getList(TrainingRegistrationVo trainingRegistration);
}

 src/main/java/org/springblade/modules/training/service/impl/TrainingRegistrationServiceImpl.java

@@ -487,4 +487,13 @@
            });
        }
    }

    /**
     * 查看报名集合信息
     * @return
     */
    @Override
    public List<TrainingRegistration> getList(TrainingRegistrationVo trainingRegistration) {
        return baseMapper.getList(trainingRegistration);
    }
}