Examples with DecWorkExp com.bc.pmpheep.back.po.DecWorkExp used on opensource projects

Example 6 with DecWorkExp

use of com.bc.pmpheep.back.po.DecWorkExp in project pmph by BCSquad.

the class DeclarationServiceImpl method exportExcel.

@Override
public ApplicationVO exportExcel(Long declarationId) {
    // 专家信息显示实体
    ApplicationVO applicationVO = new ApplicationVO();
    // 作家申报
    List<DecPositionDisplayVO> decPositionList = decPositionDao.listDecPositionsOrBook(declarationId);
    for (DecPositionDisplayVO decPositions : decPositionList) {
        String syllabusId = decPositions.getSyllabusId();
        if (StringUtil.notEmpty(syllabusId)) {
            // 下载路径
            String syllabusIds = RouteUtil.MONGODB_FILE + syllabusId;
            decPositions.setSyllabusId(syllabusIds);
        }
        switch(decPositions.getPresetPosition()) {
            case 1:
                decPositions.setShowPosition("编委");
                break;
            case 2:
                decPositions.setShowPosition("副主编");
                break;
            case 3:
                decPositions.setShowPosition("副主编,编委");
                break;
            case 4:
                decPositions.setShowPosition("主编");
                break;
            case 5:
                decPositions.setShowPosition("主编,编委");
                break;
            case 6:
                decPositions.setShowPosition("主编,副主编");
                break;
            case 7:
                decPositions.setShowPosition("主编,副主编,编委");
                break;
            case 8:
                decPositions.setShowPosition("数字编委");
                break;
            case 9:
                decPositions.setShowPosition("编委,数字编委");
                break;
            case 10:
                decPositions.setShowPosition("副主编,数字编委");
                break;
            case 11:
                decPositions.setShowPosition("副主编,编委,数字编委");
                break;
            case 12:
                decPositions.setShowPosition("主编,数字编委");
                break;
            case 13:
                decPositions.setShowPosition("主编,编委,数字编委");
                break;
            case 14:
                decPositions.setShowPosition("主编,副主编,数字编委");
                break;
            case 15:
                decPositions.setShowPosition("主编,副主编,编委,数字编委");
                break;
            default:
                break;
        }
        if (decPositions.getChosenPosition() != 0) {
            switch(decPositions.getChosenPosition()) {
                case 1:
                    decPositions.setShowChosenPosition("编委");
                    break;
                case 2:
                    decPositions.setShowChosenPosition("副主编");
                    break;
                case 3:
                    decPositions.setShowChosenPosition("副主编,编委");
                    break;
                case 4:
                    decPositions.setShowChosenPosition("主编");
                    break;
                case 5:
                    decPositions.setShowChosenPosition("主编,编委");
                    break;
                case 6:
                    decPositions.setShowChosenPosition("主编,副主编");
                    break;
                case 7:
                    decPositions.setShowChosenPosition("主编,副主编,编委");
                    break;
                case 8:
                    decPositions.setShowChosenPosition("数字编委");
                    break;
                case 9:
                    decPositions.setShowChosenPosition("编委,数字编委");
                    break;
                case 10:
                    decPositions.setShowChosenPosition("副主编,数字编委");
                    break;
                case 11:
                    decPositions.setShowChosenPosition("副主编,编委,数字编委");
                    break;
                case 12:
                    decPositions.setShowChosenPosition("主编,数字编委");
                    break;
                case 13:
                    decPositions.setShowChosenPosition("主编,编委,数字编委");
                    break;
                case 14:
                    decPositions.setShowChosenPosition("主编,副主编,数字编委");
                    break;
                case 15:
                    decPositions.setShowChosenPosition("主编,副主编,编委,数字编委");
                    break;
                default:
                    break;
            }
        }
    }
    // 作家遴选
    List<DecPositionPublishedVO> decPositionPublishedVOs = decPositionPublishedDao.listDecPositionDisplayOrPosition(declarationId);
    for (DecPositionPublishedVO decPositionPublished : decPositionPublishedVOs) {
        if (decPositionPublished.getChosenPosition() != 0) {
            switch(decPositionPublished.getChosenPosition()) {
                case 1:
                    decPositionPublished.setShowChosenPosition("编委");
                    break;
                case 2:
                    decPositionPublished.setShowChosenPosition("副主编");
                    break;
                case 3:
                    decPositionPublished.setShowChosenPosition("副主编,编委");
                    break;
                case 4:
                    decPositionPublished.setShowChosenPosition("主编");
                    break;
                case 5:
                    decPositionPublished.setShowChosenPosition("主编,编委");
                    break;
                case 6:
                    decPositionPublished.setShowChosenPosition("主编,副主编");
                    break;
                case 7:
                    decPositionPublished.setShowChosenPosition("主编,副主编,编委");
                    break;
                case 8:
                    decPositionPublished.setShowChosenPosition("数字编委");
                    break;
                case 9:
                    decPositionPublished.setShowChosenPosition("编委,数字编委");
                    break;
                case 10:
                    decPositionPublished.setShowChosenPosition("副主编,数字编委");
                    break;
                case 11:
                    decPositionPublished.setShowChosenPosition("副主编,编委,数字编委");
                    break;
                case 12:
                    decPositionPublished.setShowChosenPosition("主编,数字编委");
                    break;
                case 13:
                    decPositionPublished.setShowChosenPosition("主编,编委,数字编委");
                    break;
                case 14:
                    decPositionPublished.setShowChosenPosition("主编,副主编,数字编委");
                    break;
                case 15:
                    decPositionPublished.setShowChosenPosition("主编,副主编,编委,数字编委");
                    break;
                default:
                    break;
            }
        }
    }
    // 作家申报表
    DeclarationOrDisplayVO declaration = declarationDao.getDeclarationByIdOrOrgName(declarationId);
    WriterUser user = writerUserService.get(declaration.getUserId());
    if (user != null) {
        declaration.setUsername(user.getUsername());
    }
    // 作家学习经历
    List<DecEduExp> decEduExpList = decEduExpDao.getListDecEduExpByDeclarationId(declarationId);
    // 作家工作经历
    List<DecWorkExp> decWorkExpList = decWorkExpDao.getListDecWorkExpByDeclarationId(declarationId);
    // 作家教学经历
    List<DecTeachExp> decTeachExpList = decTeachExpDao.getListDecTeachExpByDeclarationId(declarationId);
    // 作家个人成就
    DecAchievement decAchievement = decAchievementDao.getDecAchievementByDeclarationId(declarationId);
    // 作家兼职学术
    List<DecAcade> decAcadeList = decAcadeDao.getListDecAcadeByDeclarationId(declarationId);
    // 作家本套上版教材参编情况
    List<DecLastPosition> decLastPositionList = decLastPositionDao.getListDecLastPositionByDeclarationId(declarationId);
    // 作家主编国家级规划教材情况
    List<DecNationalPlan> decNationalPlanList = decNationalPlanDao.getListDecNationalPlanByDeclarationId(declarationId);
    // 人卫社教材编写情况表
    List<DecTextbookPmph> decTextbookPmphList = decTextbookPmphDao.getListDecTextbookPmphByDeclarationId(declarationId);
    // 其他社教材编写情况
    List<DecTextbook> decTextbookList = decTextbookDao.getListDecTextbookByDeclarationId(declarationId);
    // 参加人卫慕课、数字教材编写情况表
    DecMoocDigital decMoocDigital = decMoocDigitalDao.getDecMoocDigitalByDeclarationId(declarationId);
    // 作家精品课程建设情况
    List<DecCourseConstruction> decCourseConstruction = decCourseConstructionDao.getDecCourseConstructionByDeclarationId(declarationId);
    // 作家科研情况
    List<DecResearch> decResearchList = decResearchDao.getListDecResearchByDeclarationId(declarationId);
    // 主编学术专著情况
    List<DecMonograph> decMonographList = decMonographDao.getListDecMonographByDeclarationId(declarationId);
    // 出版行业获奖情况
    List<DecPublishReward> decPublishRewardList = decPublishRewardDao.getListDecPublishRewardByDeclarationId(declarationId);
    // SCI论文投稿及影响因子情况
    List<DecSci> decSciList = decSciDao.getListDecSciByDeclarationId(declarationId);
    // 临床医学获奖情况
    List<DecClinicalReward> decClinicalRewardList = decClinicalRewardDao.getListDecClinicalRewardByDeclarationId(declarationId);
    // 学术荣誉授予情况
    List<DecAcadeReward> decAcadeRewardList = decAcadeRewardDao.getListDecAcadeRewardByDeclarationId(declarationId);
    // 作家扩展项
    List<DecExtensionVO> decExtensionList = decExtensionDao.getListDecExtensionByDeclarationId(declarationId);
    // 编写内容意向表
    DecIntention decIntention = decIntentionDao.getDecIntentionByDeclarationId(declarationId);
    // 是否选择必填
    Material material = materialService.getMaterialById(declaration.getMaterialId());
    // 把查询出来的信息添加进applicationVO
    applicationVO.setDecPositionList(decPositionList);
    applicationVO.setDecPositionPublishedVOs(decPositionPublishedVOs);
    applicationVO.setDeclaration(declaration);
    applicationVO.setDecEduExpList(decEduExpList);
    applicationVO.setDecWorkExpList(decWorkExpList);
    applicationVO.setDecTeachExpList(decTeachExpList);
    applicationVO.setDecAchievement(decAchievement);
    applicationVO.setDecAcadeList(decAcadeList);
    applicationVO.setDecLastPositionList(decLastPositionList);
    applicationVO.setDecNationalPlanList(decNationalPlanList);
    applicationVO.setDecTextbookPmphList(decTextbookPmphList);
    applicationVO.setDecTextbookList(decTextbookList);
    applicationVO.setDecMoocDigital(decMoocDigital);
    applicationVO.setDecCourseConstruction(decCourseConstruction);
    applicationVO.setDecResearchList(decResearchList);
    applicationVO.setDecMonographList(decMonographList);
    applicationVO.setDecPublishRewardList(decPublishRewardList);
    applicationVO.setDecSciList(decSciList);
    applicationVO.setDecClinicalRewardList(decClinicalRewardList);
    applicationVO.setDecAcadeRewardList(decAcadeRewardList);
    applicationVO.setDecExtensionList(decExtensionList);
    applicationVO.setDecIntention(decIntention);
    applicationVO.setMaterial(material);
    return applicationVO;
}

Example 7 with DecWorkExp

use of com.bc.pmpheep.back.po.DecWorkExp in project pmph by BCSquad.

the class DeclarationServiceImpl method declarationEtcBO.

@Override
public List<DeclarationEtcBO> declarationEtcBO(Long materialId, String textBookids, String realname, String position, String title, String orgName, String unitName, Integer positionType, Integer onlineProgress, Integer offlineProgress) throws CheckedServiceException, IllegalArgumentException, IllegalAccessException {
    List<DeclarationEtcBO> declarationEtcBOs = new ArrayList<>();
    Gson gson = new Gson();
    List<Long> bookIds = gson.fromJson(textBookids, new TypeToken<ArrayList<Long>>() {
    }.getType());
    List<DeclarationOrDisplayVO> declarationOrDisplayVOs = declarationDao.getDeclarationOrDisplayVOByMaterialId(materialId, bookIds, realname, position, title, orgName, unitName, positionType, onlineProgress, offlineProgress);
    List<Long> decIds = new ArrayList<>();
    for (DeclarationOrDisplayVO declarationOrDisplayVO : declarationOrDisplayVOs) {
        decIds.add(declarationOrDisplayVO.getId());
    }
    // 学习经历
    ArrayList<DecEduExp> decEduExps = (ArrayList<DecEduExp>) decEduExpDao.getListDecEduExpByDeclarationIds(decIds);
    // 工作经历
    ArrayList<DecWorkExp> decWorkExps = (ArrayList<DecWorkExp>) decWorkExpDao.getListDecWorkExpByDeclarationIds(decIds);
    // 教学经历
    ArrayList<DecTeachExp> decTeachExps = (ArrayList<DecTeachExp>) decTeachExpDao.getListDecTeachExpByDeclarationIds(decIds);
    // 兼职学术
    ArrayList<DecAcade> decAcades = (ArrayList<DecAcade>) decAcadeDao.getListDecAcadeByDeclarationIds(decIds);
    // 个人成就
    ArrayList<DecAchievement> decAchievements = (ArrayList<DecAchievement>) decAchievementDao.getDecAchievementByDeclarationIds(decIds);
    // 本套上版教材参编情况
    ArrayList<DecLastPosition> decLastPositions = (ArrayList<DecLastPosition>) decLastPositionDao.getListDecLastPositionByDeclarationIds(decIds);
    // 精品课程建设情况
    ArrayList<DecCourseConstruction> decCourseConstructions = (ArrayList<DecCourseConstruction>) decCourseConstructionDao.getDecCourseConstructionByDeclarationIds(decIds);
    // 主编国家级规划
    ArrayList<DecNationalPlan> decNationalPlans = (ArrayList<DecNationalPlan>) decNationalPlanDao.getListDecNationalPlanByDeclarationIds(decIds);
    // 人卫社教材编写情况表
    ArrayList<DecTextbookPmph> decTextbookPmphs = (ArrayList<DecTextbookPmph>) decTextbookPmphDao.getListDecTextbookPmphByDeclarationIds(decIds);
    // 其他社教材编写情况
    ArrayList<DecTextbook> decTextbooks = (ArrayList<DecTextbook>) decTextbookDao.getListDecTextbookByDeclarationIds(decIds);
    // 参加人卫慕课、数字教材编写情况表
    ArrayList<DecMoocDigital> decMoocDigitals = (ArrayList<DecMoocDigital>) decMoocDigitalDao.getDecMoocDigitalByDeclarationIds(decIds);
    // 作家科研
    ArrayList<DecResearch> decResearchs = (ArrayList<DecResearch>) decResearchDao.getListDecResearchByDeclarationIds(decIds);
    // 主编学术专著情况
    ArrayList<DecMonograph> decMonographList = (ArrayList<DecMonograph>) decMonographDao.getListDecMonographByDeclarationIds(decIds);
    // 出版行业获奖情况
    ArrayList<DecPublishReward> decPublishRewardList = (ArrayList<DecPublishReward>) decPublishRewardDao.getListDecPublishRewardByDeclarationIds(decIds);
    // SCI论文投稿及影响因子情况
    ArrayList<DecSci> decSciList = (ArrayList<DecSci>) decSciDao.getListDecSciByDeclarationIds(decIds);
    // 临床医学获奖情况
    ArrayList<DecClinicalReward> decClinicalRewardList = (ArrayList<DecClinicalReward>) decClinicalRewardDao.getListDecClinicalRewardByDeclarationIds(decIds);
    // 学术荣誉授予情况
    ArrayList<DecAcadeReward> decAcadeRewardList = (ArrayList<DecAcadeReward>) decAcadeRewardDao.getListDecAcadeRewardByDeclarationIds(decIds);
    // 作家扩展项
    ArrayList<DecExtensionVO> decExtensionVOs = (ArrayList<DecExtensionVO>) decExtensionDao.getListDecExtensionVOByDeclarationIds(decIds);
    // 编写内容意向表
    ArrayList<DecIntention> decIntentions = (ArrayList<DecIntention>) decIntentionDao.getDecIntentionByDeclarationIds(decIds);
    for (DeclarationOrDisplayVO declarationOrDisplayVO : declarationOrDisplayVOs) {
        // 审核进度
        String strOnlineProgress = "";
        // 纸质表进度
        String strOfflineProgress = "";
        // 性别
        String sex = "";
        // 证件类别
        String idtype = "";
        // 学历
        String degree = "";
        switch(declarationOrDisplayVO.getIdtype()) {
            case 0:
                idtype = "身份证";
                break;
            case 1:
                idtype = "护照";
                break;
            case 2:
                idtype = "军官证";
                break;
            default:
                idtype = "出现错误";
                break;
        }
        switch(declarationOrDisplayVO.getDegree()) {
            case 0:
                degree = "无";
                break;
            case 1:
                degree = "专科";
                break;
            case 2:
                degree = "本科";
                break;
            case 3:
                degree = "硕士";
                break;
            case 4:
                degree = "博士";
                break;
            default:
                degree = "出现错误";
                break;
        }
        switch(declarationOrDisplayVO.getOnlineProgress()) {
            case 0:
                strOnlineProgress = "未提交";
                break;
            case 1:
                strOnlineProgress = "已提交";
                break;
            case 2:
                strOnlineProgress = "被退回";
                break;
            case 3:
                strOnlineProgress = "已通过";
                break;
            default:
                strOnlineProgress = "出现错误";
                break;
        }
        switch(declarationOrDisplayVO.getSex()) {
            case 0:
                sex = "保密";
                break;
            case 1:
                sex = "男";
                break;
            case 2:
                sex = "女";
                break;
            default:
                sex = "出现错误";
                break;
        }
        switch(declarationOrDisplayVO.getOfflineProgress()) {
            case 0:
                strOfflineProgress = "未收到";
                break;
            case 1:
                strOfflineProgress = "被退回";
                break;
            case 2:
                strOfflineProgress = "已收到";
                break;
            default:
                strOfflineProgress = "出现错误";
                break;
        }
        String birthday = "";
        if (null != declarationOrDisplayVO.getBirthday()) {
            birthday = DateUtil.date2Str(declarationOrDisplayVO.getBirthday(), "yyyy-MM-dd");
        }
        if (null == declarationOrDisplayVO.getPosition() || "".equals(declarationOrDisplayVO.getPosition())) {
            declarationOrDisplayVO.setPosition("无");
        }
        if (StringUtil.isEmpty(declarationOrDisplayVO.getTextbookName())) {
            declarationOrDisplayVO.setTextbookName("");
        }
        if (StringUtil.isEmpty(declarationOrDisplayVO.getPresetPosition())) {
            declarationOrDisplayVO.setPresetPosition("");
        }
        // 学习经历
        List<DecEduExp> decEduExp = new ArrayList<>();
        for (DecEduExp exp : decEduExps) {
            if (exp.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decEduExp.add(exp);
            }
        }
        // 工作经历
        List<DecWorkExp> decWorkExp = new ArrayList<>();
        for (DecWorkExp workExp : decWorkExps) {
            if (workExp.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decWorkExp.add(workExp);
            }
        }
        // 教学经历
        List<DecTeachExp> decTeachExp = new ArrayList<>();
        for (DecTeachExp teachExp : decTeachExps) {
            if (teachExp.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decTeachExp.add(teachExp);
            }
        }
        // 兼职学术
        List<DecAcade> decAcade = new ArrayList<>();
        for (DecAcade acade : decAcades) {
            if (acade.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decAcade.add(acade);
            }
        }
        // 个人成就
        DecAchievement decAchievement = new DecAchievement();
        for (DecAchievement achievement : decAchievements) {
            if (achievement.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decAchievement = achievement;
                break;
            }
        }
        // 上套教材
        List<DecLastPosition> decLastPosition = new ArrayList<>();
        for (DecLastPosition lastPosition : decLastPositions) {
            if (lastPosition.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decLastPosition.add(lastPosition);
            }
        }
        // 精品课程建设情况
        List<DecCourseConstruction> decCourseConstruction = new ArrayList<>();
        for (DecCourseConstruction construction : decCourseConstructions) {
            if (construction.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decCourseConstruction.add(construction);
            }
        }
        // 主编国家级规划
        List<DecNationalPlan> decNationalPlan = new ArrayList<>();
        for (DecNationalPlan plan : decNationalPlans) {
            if (plan.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decNationalPlan.add(plan);
            }
        }
        // 人卫社教材编写
        List<DecTextbookPmph> decTextbookPmph = new ArrayList<>();
        for (DecTextbookPmph textbookPmph : decTextbookPmphs) {
            if (textbookPmph.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decTextbookPmph.add(textbookPmph);
            }
        }
        // 其他社教材编写
        List<DecTextbook> decTextbook = new ArrayList<>();
        for (DecTextbook textbook : decTextbooks) {
            if (textbook.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decTextbook.add(textbook);
            }
        }
        // 参加人卫慕课、数字教材编写情况表
        DecMoocDigital decMoocDigital = new DecMoocDigital();
        for (DecMoocDigital moocDigital : decMoocDigitals) {
            if (moocDigital.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decMoocDigital = moocDigital;
                break;
            }
        }
        // 作家科研
        List<DecResearch> decResearch = new ArrayList<>();
        for (DecResearch research : decResearchs) {
            if (research.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decResearch.add(research);
            }
        }
        // 主编学术专著情况
        List<DecMonograph> monographs = new ArrayList<>();
        for (DecMonograph monograph : decMonographList) {
            if (monograph.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                monographs.add(monograph);
            }
        }
        // 出版行业获奖情况
        List<DecPublishReward> publishRewards = new ArrayList<>();
        for (DecPublishReward publishReward : decPublishRewardList) {
            if (publishReward.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                publishRewards.add(publishReward);
            }
        }
        // SCI论文投稿及影响因子情况
        List<DecSci> scis = new ArrayList<>();
        for (DecSci sci : decSciList) {
            if (sci.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                scis.add(sci);
            }
        }
        // 临床医学获奖情况
        List<DecClinicalReward> clinicalRewards = new ArrayList<>();
        for (DecClinicalReward clinicalReward : decClinicalRewardList) {
            if (clinicalReward.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                clinicalRewards.add(clinicalReward);
            }
        }
        // 学术荣誉授予情况
        List<DecAcadeReward> acadeRewards = new ArrayList<>();
        for (DecAcadeReward acadeReward : decAcadeRewardList) {
            if (acadeReward.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                acadeRewards.add(acadeReward);
            }
        }
        // 编写内容意向表
        DecIntention decIntention = new DecIntention();
        for (DecIntention intention : decIntentions) {
            if (intention.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decIntention = intention;
                break;
            }
        }
        // 作家扩展项
        List<DecExtensionVO> extensionVOs = new ArrayList<>();
        for (DecExtensionVO extensionVO : decExtensionVOs) {
            if (extensionVO.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                extensionVOs.add(extensionVO);
            }
        }
        String isDispensed = declarationOrDisplayVO.getIsDispensed() ? "是" : "否";
        String isUtec = declarationOrDisplayVO.getIsUtec() ? "是" : "否";
        String textbookName = declarationOrDisplayVO.getTextbookName() + "第" + declarationOrDisplayVO.getTextbookRound() + "版";
        DeclarationEtcBO declarationEtcBO = new DeclarationEtcBO(declarationOrDisplayVO.getRealname(), declarationOrDisplayVO.getUsername(), sex, birthday, declarationOrDisplayVO.getExperience(), declarationOrDisplayVO.getOrgName(), declarationOrDisplayVO.getPosition(), declarationOrDisplayVO.getTitle(), declarationOrDisplayVO.getAddress(), declarationOrDisplayVO.getPostcode(), declarationOrDisplayVO.getTelephone(), declarationOrDisplayVO.getFax(), declarationOrDisplayVO.getHandphone(), degree, declarationOrDisplayVO.getEmail(), idtype, declarationOrDisplayVO.getIdcard(), declarationOrDisplayVO.getExpertise(), isDispensed, isUtec, strOnlineProgress, strOfflineProgress, declarationOrDisplayVO.getOrgNameOne(), (ArrayList<DecEduExp>) decEduExp, (ArrayList<DecWorkExp>) decWorkExp, (ArrayList<DecTeachExp>) decTeachExp, decAchievement, (ArrayList<DecAcade>) decAcade, (ArrayList<DecLastPosition>) decLastPosition, (ArrayList<DecCourseConstruction>) decCourseConstruction, (ArrayList<DecNationalPlan>) decNationalPlan, (ArrayList<DecTextbookPmph>) decTextbookPmph, decMoocDigital, (ArrayList<DecTextbook>) decTextbook, (ArrayList<DecResearch>) decResearch, (ArrayList<DecMonograph>) monographs, (ArrayList<DecPublishReward>) publishRewards, (ArrayList<DecSci>) scis, (ArrayList<DecClinicalReward>) clinicalRewards, (ArrayList<DecAcadeReward>) acadeRewards, (ArrayList<DecExtensionVO>) extensionVOs, decIntention);
        List<String> list = new ArrayList<>();
        list.add(textbookName);
        declarationEtcBO.setTextbookName(list);
        List<String> presetPosition = new ArrayList<>();
        presetPosition.add(declarationOrDisplayVO.getPresetPosition());
        declarationEtcBO.setPresetPosition(presetPosition);
        declarationEtcBOs.add(declarationEtcBO);
    }
    return declarationEtcBOs;
}

Example 8 with DecWorkExp

use of com.bc.pmpheep.back.po.DecWorkExp in project pmph by BCSquad.

the class DeclarationServiceImpl method getDeclarationOrDisplayVOByIdOrRealname.

@Override
public List<DeclarationEtcBO> getDeclarationOrDisplayVOByIdOrRealname(List<Long> decIds) throws CheckedServiceException, IllegalArgumentException, IllegalAccessException {
    List<DeclarationEtcBO> declarationEtcBOs = new ArrayList<>();
    List<DeclarationOrDisplayVO> declarationOrDisplayVOs = declarationDao.getDeclarationOrDisplayVOByIdOrRealname(decIds);
    // 学习经历
    ArrayList<DecEduExp> decEduExps = (ArrayList<DecEduExp>) decEduExpDao.getListDecEduExpByDeclarationIds(decIds);
    // 工作经历
    ArrayList<DecWorkExp> decWorkExps = (ArrayList<DecWorkExp>) decWorkExpDao.getListDecWorkExpByDeclarationIds(decIds);
    // 教学经历
    ArrayList<DecTeachExp> decTeachExps = (ArrayList<DecTeachExp>) decTeachExpDao.getListDecTeachExpByDeclarationIds(decIds);
    // 兼职学术
    ArrayList<DecAcade> decAcades = (ArrayList<DecAcade>) decAcadeDao.getListDecAcadeByDeclarationIds(decIds);
    // 个人成就
    ArrayList<DecAchievement> decAchievements = (ArrayList<DecAchievement>) decAchievementDao.getDecAchievementByDeclarationIds(decIds);
    // 本套上版教材参编情况
    ArrayList<DecLastPosition> decLastPositions = (ArrayList<DecLastPosition>) decLastPositionDao.getListDecLastPositionByDeclarationIds(decIds);
    // 精品课程建设情况
    ArrayList<DecCourseConstruction> decCourseConstructions = (ArrayList<DecCourseConstruction>) decCourseConstructionDao.getDecCourseConstructionByDeclarationIds(decIds);
    // 主编国家级规划
    ArrayList<DecNationalPlan> decNationalPlans = (ArrayList<DecNationalPlan>) decNationalPlanDao.getListDecNationalPlanByDeclarationIds(decIds);
    // 人卫社教材编写情况表
    ArrayList<DecTextbookPmph> decTextbookPmphs = (ArrayList<DecTextbookPmph>) decTextbookPmphDao.getListDecTextbookPmphByDeclarationIds(decIds);
    // 其他社教材编写情况
    ArrayList<DecTextbook> decTextbooks = (ArrayList<DecTextbook>) decTextbookDao.getListDecTextbookByDeclarationIds(decIds);
    // 参加人卫慕课、数字教材编写情况表
    ArrayList<DecMoocDigital> decMoocDigitals = (ArrayList<DecMoocDigital>) decMoocDigitalDao.getDecMoocDigitalByDeclarationIds(decIds);
    // 作家科研
    ArrayList<DecResearch> decResearchs = (ArrayList<DecResearch>) decResearchDao.getListDecResearchByDeclarationIds(decIds);
    // 主编学术专著情况
    ArrayList<DecMonograph> decMonographList = (ArrayList<DecMonograph>) decMonographDao.getListDecMonographByDeclarationIds(decIds);
    // 出版行业获奖情况
    ArrayList<DecPublishReward> decPublishRewardList = (ArrayList<DecPublishReward>) decPublishRewardDao.getListDecPublishRewardByDeclarationIds(decIds);
    // SCI论文投稿及影响因子情况
    ArrayList<DecSci> decSciList = (ArrayList<DecSci>) decSciDao.getListDecSciByDeclarationIds(decIds);
    // 临床医学获奖情况
    ArrayList<DecClinicalReward> decClinicalRewardList = (ArrayList<DecClinicalReward>) decClinicalRewardDao.getListDecClinicalRewardByDeclarationIds(decIds);
    // 学术荣誉授予情况
    ArrayList<DecAcadeReward> decAcadeRewardList = (ArrayList<DecAcadeReward>) decAcadeRewardDao.getListDecAcadeRewardByDeclarationIds(decIds);
    // 作家扩展项
    ArrayList<DecExtensionVO> decExtensionVOs = (ArrayList<DecExtensionVO>) decExtensionDao.getListDecExtensionVOByDeclarationIds(decIds);
    // 编写内容意向表
    ArrayList<DecIntention> decIntentions = (ArrayList<DecIntention>) decIntentionDao.getDecIntentionByDeclarationIds(decIds);
    // materialExtensionService.getMaterialExtensionByMaterialId(materialId);
    for (DeclarationOrDisplayVO declarationOrDisplayVO : declarationOrDisplayVOs) {
        // 审核进度
        String strOnlineProgress = "";
        // 纸质表进度
        String strOfflineProgress = "";
        // 性别
        String sex = "";
        // 证件类别
        String idtype = "";
        // 学历
        String degree = "";
        switch(declarationOrDisplayVO.getIdtype()) {
            case 0:
                idtype = "身份证";
                break;
            case 1:
                idtype = "护照";
                break;
            case 2:
                idtype = "军官证";
                break;
            default:
                idtype = "出现错误";
                break;
        }
        switch(declarationOrDisplayVO.getDegree()) {
            case 0:
                degree = "无";
                break;
            case 1:
                degree = "专科";
                break;
            case 2:
                degree = "本科";
                break;
            case 3:
                degree = "硕士";
                break;
            case 4:
                degree = "博士";
                break;
            default:
                degree = "出现错误";
                break;
        }
        switch(declarationOrDisplayVO.getOnlineProgress()) {
            case 0:
                strOnlineProgress = "未提交";
                break;
            case 1:
                strOnlineProgress = "已提交";
                break;
            case 2:
                strOnlineProgress = "被退回";
                break;
            case 3:
                strOnlineProgress = "已通过";
                break;
            default:
                strOnlineProgress = "出现错误";
                break;
        }
        switch(declarationOrDisplayVO.getSex()) {
            case 0:
                sex = "保密";
                break;
            case 1:
                sex = "男";
                break;
            case 2:
                sex = "女";
                break;
            default:
                sex = "出现错误";
                break;
        }
        switch(declarationOrDisplayVO.getOfflineProgress()) {
            case 0:
                strOfflineProgress = "未收到";
                break;
            case 1:
                strOfflineProgress = "被退回";
                break;
            case 2:
                strOfflineProgress = "已收到";
                break;
            default:
                strOfflineProgress = "出现错误";
                break;
        }
        String birthday = "";
        if (null != declarationOrDisplayVO.getBirthday()) {
            birthday = DateUtil.date2Str(declarationOrDisplayVO.getBirthday(), "yyyy-MM-dd");
        }
        if (null == declarationOrDisplayVO.getPosition() || "".equals(declarationOrDisplayVO.getPosition())) {
            declarationOrDisplayVO.setPosition("无");
        }
        if (StringUtil.isEmpty(declarationOrDisplayVO.getTextbookName())) {
            declarationOrDisplayVO.setTextbookName("");
        }
        if (StringUtil.isEmpty(declarationOrDisplayVO.getPresetPosition())) {
            declarationOrDisplayVO.setPresetPosition("");
        }
        // 学习经历
        List<DecEduExp> decEduExp = new ArrayList<>();
        for (DecEduExp exp : decEduExps) {
            if (exp.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decEduExp.add(exp);
            }
        }
        // 工作经历
        List<DecWorkExp> decWorkExp = new ArrayList<>();
        for (DecWorkExp workExp : decWorkExps) {
            if (workExp.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decWorkExp.add(workExp);
            }
        }
        // 教学经历
        List<DecTeachExp> decTeachExp = new ArrayList<>();
        for (DecTeachExp teachExp : decTeachExps) {
            if (teachExp.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decTeachExp.add(teachExp);
            }
        }
        // 兼职学术
        List<DecAcade> decAcade = new ArrayList<>();
        for (DecAcade acade : decAcades) {
            if (acade.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decAcade.add(acade);
            }
        }
        // 个人成就
        DecAchievement decAchievement = new DecAchievement();
        for (DecAchievement achievement : decAchievements) {
            if (achievement.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decAchievement = achievement;
                break;
            }
        }
        // 上套教材
        List<DecLastPosition> decLastPosition = new ArrayList<>();
        for (DecLastPosition lastPosition : decLastPositions) {
            if (lastPosition.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decLastPosition.add(lastPosition);
            }
        }
        // 精品课程建设情况
        List<DecCourseConstruction> decCourseConstruction = new ArrayList<>();
        for (DecCourseConstruction construction : decCourseConstructions) {
            if (construction.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decCourseConstruction.add(construction);
            }
        }
        // 主编国家级规划
        List<DecNationalPlan> decNationalPlan = new ArrayList<>();
        for (DecNationalPlan plan : decNationalPlans) {
            if (plan.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decNationalPlan.add(plan);
            }
        }
        // 人卫社教材编写
        List<DecTextbookPmph> decTextbookPmph = new ArrayList<>();
        for (DecTextbookPmph textbookPmph : decTextbookPmphs) {
            if (textbookPmph.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decTextbookPmph.add(textbookPmph);
            }
        }
        // 其他社教材编写
        List<DecTextbook> decTextbook = new ArrayList<>();
        for (DecTextbook textbook : decTextbooks) {
            if (textbook.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decTextbook.add(textbook);
            }
        }
        // 参加人卫慕课、数字教材编写情况表
        DecMoocDigital decMoocDigital = new DecMoocDigital();
        for (DecMoocDigital moocDigital : decMoocDigitals) {
            if (moocDigital.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decMoocDigital = moocDigital;
                break;
            }
        }
        // 作家科研
        List<DecResearch> decResearch = new ArrayList<>();
        for (DecResearch research : decResearchs) {
            if (research.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decResearch.add(research);
            }
        }
        // 主编学术专著情况
        List<DecMonograph> monographs = new ArrayList<>();
        for (DecMonograph monograph : decMonographList) {
            if (monograph.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                monographs.add(monograph);
            }
        }
        // 出版行业获奖情况
        List<DecPublishReward> publishRewards = new ArrayList<>();
        for (DecPublishReward publishReward : decPublishRewardList) {
            if (publishReward.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                publishRewards.add(publishReward);
            }
        }
        // SCI论文投稿及影响因子情况
        List<DecSci> scis = new ArrayList<>();
        for (DecSci sci : decSciList) {
            if (sci.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                scis.add(sci);
            }
        }
        // 临床医学获奖情况
        List<DecClinicalReward> clinicalRewards = new ArrayList<>();
        for (DecClinicalReward clinicalReward : decClinicalRewardList) {
            if (clinicalReward.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                clinicalRewards.add(clinicalReward);
            }
        }
        // 学术荣誉授予情况
        List<DecAcadeReward> acadeRewards = new ArrayList<>();
        for (DecAcadeReward acadeReward : decAcadeRewardList) {
            if (acadeReward.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                acadeRewards.add(acadeReward);
            }
        }
        // 编写内容意向表
        DecIntention decIntention = new DecIntention();
        for (DecIntention intention : decIntentions) {
            if (intention.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                decIntention = intention;
                break;
            }
        }
        // 作家扩展项
        List<DecExtensionVO> extensionVOs = new ArrayList<>();
        for (DecExtensionVO extensionVO : decExtensionVOs) {
            if (extensionVO.getDeclarationId().equals(declarationOrDisplayVO.getId())) {
                extensionVOs.add(extensionVO);
            }
        }
        String isDispensed = declarationOrDisplayVO.getIsDispensed() ? "是" : "否";
        String isUtec = declarationOrDisplayVO.getIsUtec() ? "是" : "否";
        String textbookName = declarationOrDisplayVO.getTextbookName() + "第" + declarationOrDisplayVO.getTextbookRound() + "版";
        DeclarationEtcBO declarationEtcBO = new DeclarationEtcBO(declarationOrDisplayVO.getRealname(), declarationOrDisplayVO.getUsername(), sex, birthday, declarationOrDisplayVO.getExperience(), declarationOrDisplayVO.getOrgName(), declarationOrDisplayVO.getPosition(), declarationOrDisplayVO.getTitle(), declarationOrDisplayVO.getAddress(), declarationOrDisplayVO.getPostcode(), declarationOrDisplayVO.getTelephone(), declarationOrDisplayVO.getFax(), declarationOrDisplayVO.getHandphone(), degree, declarationOrDisplayVO.getEmail(), idtype, declarationOrDisplayVO.getIdcard(), declarationOrDisplayVO.getExpertise(), isDispensed, isUtec, strOnlineProgress, strOfflineProgress, declarationOrDisplayVO.getOrgNameOne(), (ArrayList<DecEduExp>) decEduExp, (ArrayList<DecWorkExp>) decWorkExp, (ArrayList<DecTeachExp>) decTeachExp, decAchievement, (ArrayList<DecAcade>) decAcade, (ArrayList<DecLastPosition>) decLastPosition, (ArrayList<DecCourseConstruction>) decCourseConstruction, (ArrayList<DecNationalPlan>) decNationalPlan, (ArrayList<DecTextbookPmph>) decTextbookPmph, decMoocDigital, (ArrayList<DecTextbook>) decTextbook, (ArrayList<DecResearch>) decResearch, (ArrayList<DecMonograph>) monographs, (ArrayList<DecPublishReward>) publishRewards, (ArrayList<DecSci>) scis, (ArrayList<DecClinicalReward>) clinicalRewards, (ArrayList<DecAcadeReward>) acadeRewards, (ArrayList<DecExtensionVO>) extensionVOs, decIntention);
        List<String> list = new ArrayList<>();
        list.add(textbookName);
        declarationEtcBO.setTextbookName(list);
        List<String> presetPosition = new ArrayList<>();
        presetPosition.add(declarationOrDisplayVO.getPresetPosition());
        declarationEtcBO.setPresetPosition(presetPosition);
        declarationEtcBO.setMaterialId(declarationOrDisplayVO.getMaterialId());
        declarationEtcBOs.add(declarationEtcBO);
    }
    return declarationEtcBOs;
}

Example 9 with DecWorkExp

use of com.bc.pmpheep.back.po.DecWorkExp in project pmph by BCSquad.

the class ExcelHelper method fromDeclarationEtcBOList.

/**
 * 根据业务对象（包含子集合的BO）集合创建工作簿
 *
 * @param material
 *            申报表所属教材对象
 * @param extensions
 *            教材扩展项集合
 * @param dataSource
 *            业务对象（BO）集合
 * @param sheetName
 *            要生成的Excel表名（非文件名）
 * @return Excel工作簿
 */
public Workbook fromDeclarationEtcBOList(Material material, List<MaterialExtension> extensions, List<DeclarationEtcBO> dataSource, String sheetName) throws CheckedServiceException, IllegalArgumentException, IllegalAccessException {
    if (null == dataSource || dataSource.isEmpty()) {
        throw new CheckedServiceException(CheckedExceptionBusiness.MATERIAL, CheckedExceptionResult.NULL_PARAM, "用于导出Excel的数据源为空");
    }
    Workbook workbook = new HSSFWorkbook();
    Sheet sheet = workbook.createSheet(sheetName);
    // 生成表头
    sheet = generateDeclarationEtcBOHeader(extensions, sheet);
    // 设置表头样式
    headerStyleSetup(workbook, 2);
    Field[] fields = dataSource.get(0).getClass().getDeclaredFields();
    /* 设置行计数器 */
    int rowCount = 2;
    /* 记录列数和最大列宽 */
    ColumnProperties columnProperties = new ColumnProperties(1, new int[sheet.getRow(1).getLastCellNum()]);
    /* 遍历list中的对象 */
    Iterator iterator = dataSource.iterator();
    while (iterator.hasNext()) {
        Object object = iterator.next();
        Row row = sheet.createRow(rowCount);
        /* 设置序号及宽度 */
        row.createCell(0).setCellValue(String.valueOf(rowCount - 1));
        columnProperties.setMaxElement(0, 2);
        /* 设置列计数器 */
        columnProperties.setColCount(1);
        for (Field field : fields) {
            // 可访问性设置
            field.setAccessible(true);
            if (field.isAnnotationPresent(ExcelHeader.class)) {
                ExcelHeader excelHeader = (ExcelHeader) field.getAnnotation(ExcelHeader.class);
                String headerName = excelHeader.header();
                if (StringUtil.notEmpty(headerName)) {
                    switch(headerName) {
                        case "学习经历":
                            {
                                List<DecEduExp> list = (List<DecEduExp>) field.get(object);
                                columnProperties = fillDecEduExpData(list, row, columnProperties);
                                break;
                            }
                        case "工作经历":
                            {
                                List<DecWorkExp> list = (List<DecWorkExp>) field.get(object);
                                columnProperties = fillDecWorkExpData(list, row, columnProperties);
                                break;
                            }
                        case "教学经历":
                            {
                                List<DecTeachExp> list = (List<DecTeachExp>) field.get(object);
                                columnProperties = fillDecTeachExpData(list, row, columnProperties);
                                break;
                            }
                        case "个人成就":
                            {
                                DecAchievement decAchievement = (DecAchievement) field.get(object);
                                columnProperties = fillDecAchievementData(decAchievement, row, columnProperties);
                                break;
                            }
                        case "学术兼职":
                            {
                                List<DecAcade> list = (List<DecAcade>) field.get(object);
                                columnProperties = fillDecAcadeData(list, row, columnProperties);
                                break;
                            }
                        case "本套上版教材参编情况":
                            {
                                List<DecLastPosition> list = (List<DecLastPosition>) field.get(object);
                                columnProperties = fillDecLastPositionData(list, row, columnProperties);
                                break;
                            }
                        case "精品课程建设情况":
                            {
                                List<DecCourseConstruction> list = (List<DecCourseConstruction>) field.get(object);
                                columnProperties = fillDecCourseConstructionData(list, row, columnProperties);
                                break;
                            }
                        case "主编国家级规划教材情况":
                            {
                                List<DecNationalPlan> list = (List<DecNationalPlan>) field.get(object);
                                columnProperties = fillDecNationalPlanData(list, row, columnProperties);
                                break;
                            }
                        case "人卫社教材编写情况":
                            {
                                List<DecTextbookPmph> list = (List<DecTextbookPmph>) field.get(object);
                                columnProperties = fillDecTextbookPmphData(list, row, columnProperties);
                                break;
                            }
                        case "其他社教材编写情况":
                            {
                                List<DecTextbook> list = (List<DecTextbook>) field.get(object);
                                columnProperties = fillDecTextbookData(list, row, columnProperties);
                                break;
                            }
                        case "参加人卫慕课、数字教材编写情况":
                            {
                                DecMoocDigital decMoocDigital = (DecMoocDigital) field.get(object);
                                columnProperties = fillDecMoocDigitalData(decMoocDigital, row, columnProperties);
                                break;
                            }
                        case "科研情况":
                            {
                                List<DecResearch> list = (List<DecResearch>) field.get(object);
                                columnProperties = fillDecResearchData(list, row, columnProperties);
                                break;
                            }
                        case "学术专著":
                            {
                                List<DecMonograph> list = (List<DecMonograph>) field.get(object);
                                columnProperties = fillDecMonographData(list, row, columnProperties);
                                break;
                            }
                        case "出版行业获奖情况":
                            {
                                List<DecPublishReward> list = (List<DecPublishReward>) field.get(object);
                                columnProperties = fillDecPublishRewardData(list, row, columnProperties);
                                break;
                            }
                        case "SCI论文投稿及影响因子情况":
                            {
                                List<DecSci> list = (List<DecSci>) field.get(object);
                                columnProperties = fillDecSciData(list, row, columnProperties);
                                break;
                            }
                        case "临床医学获奖情况":
                            {
                                List<DecClinicalReward> list = (List<DecClinicalReward>) field.get(object);
                                columnProperties = fillDecClinicalRewardData(list, row, columnProperties);
                                break;
                            }
                        case "学术荣誉授予情况":
                            {
                                List<DecAcadeReward> list = (List<DecAcadeReward>) field.get(object);
                                columnProperties = fillDecAcadeRewardData(list, row, columnProperties);
                                break;
                            }
                        case "编写内容意向":
                            {
                                DecIntention decIntention = (DecIntention) field.get(object);
                                columnProperties = fillDecIntentionData(decIntention, row, columnProperties);
                                break;
                            }
                        case "作家扩展项":
                            {
                                if (extensions == null || extensions.isEmpty()) {
                                    break;
                                }
                                List<DecExtensionVO> list = (List<DecExtensionVO>) field.get(object);
                                columnProperties = fillDecExtensionVODataPlus(extensions, list, row, columnProperties);
                                break;
                            }
                        default:
                            Object o = field.get(object);
                            Cell cell = row.createCell(columnProperties.getColCount());
                            if (null != o) {
                                String value = o.toString();
                                cell.setCellValue(value);
                                if (value.length() > columnProperties.getCurrentMaxElement()) {
                                    columnProperties.setCurrentMaxElement(value.length());
                                }
                            }
                            columnProperties.setColCount(columnProperties.getColCount() + 1);
                            break;
                    }
                }
            }
        }
        rowCount++;
    }
    /* 样式调整 */
    workbook = dataStyleSetup(workbook, 2, rowCount, columnProperties);
    /* 以下隐藏多余的列 */
    return clearColumns(workbook, material);
}

Example 10 with DecWorkExp

use of com.bc.pmpheep.back.po.DecWorkExp in project pmph by BCSquad.

the class DecWorkExpServiceTest method testUpdateDecWorkExp.

@Test
@Rollback(Const.ISROLLBACK)
public void testUpdateDecWorkExp() {
    DecWorkExp decWorkExp = add();
    decWorkExp.setNote("考职称");
    decWorkExp.setDateEnd("至今");
    decWorkExp.setSort(9);
    Integer count = decWorkExpService.updateDecWorkExp(decWorkExp);
    Assert.assertTrue("数据更新失败", count > 0);
}