use of com.bc.pmpheep.back.po.DecClinicalReward in project pmph by BCSquad.
the class WordHelper method fillDecClinicalRewardData.
private XWPFTable fillDecClinicalRewardData(XWPFTable table, List<DecClinicalReward> decClinicalRewards) {
if (CollectionUtil.isEmpty(decClinicalRewards)) {
return table;
}
if (decClinicalRewards.size() > 1) {
int height = table.getRow(1).getHeight();
for (int i = 1; i < decClinicalRewards.size(); i++) {
table.createRow().setHeight(height);
}
}
List<XWPFTableRow> rows = table.getRows();
List<XWPFTableCell> cells;
int rowCount = 1;
for (DecClinicalReward decClinicalReward : decClinicalRewards) {
cells = rows.get(rowCount).getTableCells();
String value = decClinicalReward.getRewardName();
if (StringUtil.notEmpty(value)) {
cells.get(0).setText(value);
}
Date rewardDate = decClinicalReward.getRewardDate();
if (null != rewardDate) {
value = sdf.format(rewardDate);
cells.get(1).setText(value);
}
Integer type = decClinicalReward.getAwardUnit();
if (null != type) {
switch(type) {
case 0:
value = "无";
break;
case 1:
value = "国际";
break;
case 2:
value = "国家";
break;
case 3:
value = "省部";
break;
case 4:
value = "市";
break;
default:
value = "其他";
break;
}
cells.get(2).setText(value);
}
value = decClinicalReward.getNote();
if (StringUtil.notEmpty(value)) {
cells.get(3).setText(value);
}
for (XWPFTableCell cell : cells) {
cell.setVerticalAlignment(XWPFVertAlign.CENTER);
}
rowCount++;
}
return table;
}
use of com.bc.pmpheep.back.po.DecClinicalReward 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;
}
use of com.bc.pmpheep.back.po.DecClinicalReward 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;
}
use of com.bc.pmpheep.back.po.DecClinicalReward 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;
}
use of com.bc.pmpheep.back.po.DecClinicalReward in project pmph by BCSquad.
the class ExcelHelper method fillDecClinicalRewardData.
private ColumnProperties fillDecClinicalRewardData(List<DecClinicalReward> decClinicalRewards, Row row, ColumnProperties properties) {
int colCount = properties.getColCount();
int[] maxLength = properties.getMaxLength();
if (CollectionUtil.isEmpty(decClinicalRewards)) {
for (int i = 0; i < 3; i++) {
row.createCell(colCount++);
}
} else {
String value;
List<StringBuilder> builders = new ArrayList<>(3);
for (int i = 0; i < 3; i++) {
builders.add(new StringBuilder());
}
boolean isFirst = true;
for (DecClinicalReward decClinicalReward : decClinicalRewards) {
if (isFirst == false) {
for (StringBuilder builder : builders) {
builder.append("\r\n");
}
} else {
isFirst = false;
}
int index = 0;
value = decClinicalReward.getRewardName();
if (StringUtil.isEmpty(value)) {
value = "";
}
builders.get(index++).append(value);
if (value.length() > maxLength[colCount]) {
maxLength[colCount] = value.length();
}
colCount++;
switch(decClinicalReward.getAwardUnit()) {
case 0:
value = "无";
break;
case 1:
value = "国际";
break;
case 2:
value = "国家";
break;
default:
value = "";
break;
}
builders.get(index++).append(value);
if (value.length() > maxLength[colCount]) {
maxLength[colCount] = value.length();
}
colCount++;
Date reward = decClinicalReward.getRewardDate();
value = "";
if (!ObjectUtil.isNull(reward)) {
value = sdf.format(reward);
}
builders.get(index++).append(value);
if (value.length() > maxLength[colCount]) {
maxLength[colCount] = value.length();
}
// 列数复位
colCount = properties.getColCount();
}
for (int i = 0; i < 3; i++) {
Cell cell = row.createCell(colCount++);
value = builders.get(i).toString();
cell.setCellValue(value);
}
}
properties.setColCount(colCount);
properties.setMaxLength(maxLength);
return properties;
}
Aggregations