package com.qxueyou.scc.courseware.action;
|
|
import java.math.BigDecimal;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.beans.factory.annotation.Qualifier;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.web.bind.annotation.PathVariable;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestMethod;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
|
import com.qxueyou.scc.admin.classes.model.ClsClass;
|
import com.qxueyou.scc.admin.classes.service.IClassService;
|
import com.qxueyou.scc.base.dao.CommonDAO;
|
import com.qxueyou.scc.base.model.Constants;
|
import com.qxueyou.scc.base.model.Pager;
|
import com.qxueyou.scc.base.model.Result;
|
import com.qxueyou.scc.base.service.ICommonService;
|
import com.qxueyou.scc.base.util.ClientUtils;
|
import com.qxueyou.scc.base.util.CollectionUtils;
|
import com.qxueyou.scc.base.util.TraceUtils;
|
import com.qxueyou.scc.base.util.WordProcessUtils;
|
import com.qxueyou.scc.courseware.service.ICourceCategoryService;
|
import com.qxueyou.scc.exercise.model.ExerciseReCourse;
|
import com.qxueyou.scc.media.model.MediaVideoReCourse;
|
import com.qxueyou.scc.org.model.OrgCategoryLevel;
|
import com.qxueyou.scc.org.model.OrgCollegeCourse;
|
import com.qxueyou.scc.org.model.OrgCourse;
|
import com.qxueyou.scc.org.model.OrgCourseCategory;
|
import com.qxueyou.scc.org.model.Organization;
|
import com.qxueyou.scc.school.model.SchHandoutReCourse;
|
|
/**
|
* 科目类别管理controller
|
*
|
* @author 德虎
|
* @history 2014-11-25 新建 夏德虎
|
*
|
*/
|
@Controller
|
@RequestMapping(value = "/org/courcecategory")
|
public class CourceCategoryController {
|
|
@Autowired
|
private CommonDAO commonDAO;
|
|
@Autowired
|
@Qualifier("commonAppService")
|
ICommonService commonService;
|
|
@Autowired
|
private ICourceCategoryService categoryService;
|
|
@SuppressWarnings("unused")
|
@Autowired
|
private IClassService orgClassService;
|
|
/*@Autowired
|
ISysBusinessCacheService sysBusinessCacheService ;*/
|
|
/**
|
* APP2.0: 课程超市 选课 获取所有分类 <br>
|
* URL /org/courcecategory/courseCatNew<br>
|
*
|
* @method GET
|
* @return 返回值JSON串:<br>
|
*
|
* <pre>
|
* [{"index":1,"code":"1CKJR","categoryName":"财会金融","categoryId":"18","imgPath":"/web/res/img/app/coursemarket_ico_accounting.png"},
|
* ......
|
* {"index":8,"code":"9QB","categoryName":"全部","categoryId":"26","imgPath":"/web/res/img/app/coursemarket_ico_classify.png"}]
|
* </pre>
|
*
|
* 字段值说明:
|
*
|
* <pre>
|
* index:索引
|
* code:编码
|
* categoryName:名字
|
* categoryId:id
|
* imgPath:logo URL
|
* </pre>
|
*/
|
@RequestMapping(value = "courseCatNew", method = RequestMethod.GET)
|
public @ResponseBody List<Map<String, Object>> getCourseCatData() {
|
|
Pager page = new Pager();
|
page.setPageNum(1);
|
page.setPageSize(Integer.MAX_VALUE);
|
|
// 1. 查询该机构下所有的科目
|
String hql = "select c from OrgCourseCategory c where c.deleteFlag is false and c.categoryLevel = ? order by c.code asc ";
|
|
List<OrgCourseCategory> lstLastCategory = commonDAO.findList(hql, page, CollectionUtils.newList(OrgCourseCategory.CATEGORY_LEVEL_FIRST), OrgCourseCategory.class);
|
|
if (lstLastCategory.isEmpty()) {
|
return new ArrayList<Map<String, Object>>();
|
}
|
|
List<Map<String, Object>> lstMap = new ArrayList<Map<String, Object>>(lstLastCategory.size());
|
Map<String, Object> map;
|
Map<String, Object> QBMap = new HashMap<String, Object>(5);
|
|
int index = 0;
|
for (OrgCourseCategory courseCat : lstLastCategory) {
|
|
if ("0QB".equals(courseCat.getCode())) {
|
QBMap.put("index", 8);
|
QBMap.put("categoryId", courseCat.getCategoryId());
|
QBMap.put("categoryName", courseCat.getCategoryName());
|
QBMap.put("code", courseCat.getCode());
|
QBMap.put("imgPath", courseCat.getImgPath());
|
if (StringUtils.isNotBlank(courseCat.getImgPath()) && !"null".equals(courseCat.getImgPath())) {
|
QBMap.put("imgPathShade", courseCat.getImgPath().split("\\.")[0].concat("-shade.png"));
|
} else {
|
QBMap.put("imgPathShade", courseCat.getImgPath());
|
}
|
} else if (!"8QT".equals(courseCat.getCode())) {
|
index = index + 1;
|
map = new HashMap<String, Object>(5);
|
map.put("index", index);
|
map.put("categoryId", courseCat.getCategoryId());
|
map.put("categoryName", courseCat.getCategoryName());
|
map.put("code", courseCat.getCode());
|
map.put("imgPath", courseCat.getImgPath());
|
if (StringUtils.isNotBlank(courseCat.getImgPath()) && !"null".equals(courseCat.getImgPath())) {
|
map.put("imgPathShade", courseCat.getImgPath().split("\\.")[0].concat("-shade.png"));
|
} else {
|
map.put("imgPathShade", courseCat.getImgPath());
|
}
|
lstMap.add(map);
|
}
|
|
}
|
lstMap.add(QBMap);
|
|
return lstMap;
|
}
|
|
/**
|
* APP2.0: 课程超市 所有查询条件 <br>
|
* URL /org/courcecategory/courseCatContitionNew<br>
|
*
|
* 返回值JSON串:<br>
|
*
|
* <pre>
|
* {
|
* "course":[
|
* {"code":"0QB","children":[],"index":1,"categoryName":"全部","categoryId":"26","parentId":null},
|
* {"code":"1CKJR","children":[],"index":2,"categoryName":"财会金融","categoryId":"18","parentId":null},
|
* {"code":"2YYKS","children":[],"index":3,"categoryName":"语言考试","categoryId":"19","parentId":null},
|
* {"code":"3YYL","children":[],"index":4,"categoryName":"医药类","categoryId":"20","parentId":null},
|
* {"code":"4JGL","children":[],"index":5,"categoryName":"建工类","categoryId":"21","parentId":null},
|
* {"code":"5ZYKZ","children":null,"index":6,"categoryName":"职业考证","categoryId":"22","parentId":null},
|
* {"code":"6XLJY","children":[
|
* {"code":null,"index":1,"categoryName":"经济学","categoryId":"5","parentId":"23"},
|
* {"code":null,"index":2,"categoryName":"法学","categoryId":"6","parentId":"23"}
|
* ],"index":7,"categoryName":"学历教育","categoryId":"23","parentId":null},
|
* {"code":"7ITJN","children":[],"index":8,"categoryName":"IT技能","categoryId":"24","parentId":null},
|
* {"code":"8QT","children":[],"index":9,"categoryName":"其他","categoryId":"25","parentId":null}
|
* ],
|
* "city":[{"name":"深圳","index":1,"code":"sz"},{"name":"广州","index":2,"code":"gz"}],
|
* "sort":[{"name":"价格由低到高","index":1,"code":"PRICE_ASC"},{"name":"价格由高到低","index":2,"code":"PRICE_DESC"}]
|
* }
|
*
|
* <pre>
|
*
|
* @return
|
*/
|
@RequestMapping(value = "courseCatContitionNew", method = RequestMethod.GET)
|
public @ResponseBody Map<String, Object> getCourseCatContitionData() {
|
return categoryService.generateAllCourseCondition();
|
}
|
|
/**
|
* APP2.0: 该机构下所有课程的分类和科目 URL: /org/courcecategory/courseCategoryNew
|
*
|
* @return
|
*/
|
@Deprecated
|
@RequestMapping(value = "courseCategoryNew", method = RequestMethod.GET)
|
public @ResponseBody List<OrgCourseCategory> getCourseCategoryData() {
|
|
// 1. 查询该机构下所有的科目
|
String hql = "select courseId,name,price,imgPath,courseCategoryId " + " from OrgCourse c where c.deleteFlag is false";
|
|
// 2. 查询该机构下所有的科目对应的类别
|
String hql_type = "select distinct c.category.categoryId,c.category.categoryName from OrgCourse c where " + " c.deleteFlag is false order by c.createTime ";
|
|
List<Object> args = new ArrayList<Object>(1);
|
// 如果是游客班 查所有机构 1:表示游客班
|
// if (!orgClassService.isCurrentVistorClass()) {
|
// hql = hql.concat(" and c.org.organizationId=?");
|
// hql_type = "select distinct c.category.categoryId,c.category.categoryName from OrgCourse c where " + " c.org.organizationId=? and c.deleteFlag is false order by c.createTime ";
|
// args = CollectionUtils.newList(ClientUtils.getOrgId());
|
// }
|
|
// 1. 查询该机构下所有的科目
|
List<OrgCollegeCourse> lstCourse = categoryService.queryOrgCourseListNew(hql, args);
|
|
// 2. 查询该机构下所有的科目对应的类别
|
List<OrgCourseCategory> lstCategory = categoryService.queryOrgCourseCategoryList(hql_type, args);
|
|
// 组装结构
|
List<OrgCollegeCourse> newLstCourse = null;
|
for (OrgCourseCategory category : lstCategory) {
|
newLstCourse = new ArrayList<OrgCollegeCourse>();
|
for (OrgCollegeCourse course : lstCourse) {
|
if (category.getCategoryId().equals(course.getCourseCategoryId())) {
|
newLstCourse.add(course);
|
}
|
}
|
category.setCourseList(newLstCourse);
|
}
|
// 不限制值
|
String not_limit = Constants.NOT_LIMIT_VALUE;
|
// 重新组装类型 添加不限
|
List<OrgCourseCategory> lstLastCategory = new ArrayList<OrgCourseCategory>();
|
// 添加第一个不限
|
OrgCourseCategory category = new OrgCourseCategory();
|
category.setCategoryId(not_limit);
|
category.setCategoryName("不限");
|
|
List<OrgCollegeCourse> lstLastCourse = new ArrayList<OrgCollegeCourse>();
|
OrgCollegeCourse course = new OrgCollegeCourse();
|
course.setCourseId(not_limit);
|
course.setName("不限");
|
|
lstLastCategory.add(category);
|
lstLastCategory.addAll(lstCategory);
|
|
for (OrgCourseCategory cate : lstLastCategory) {
|
lstLastCourse = new ArrayList<OrgCollegeCourse>();
|
lstLastCourse.add(course);
|
if (not_limit.equals(cate.getCategoryId())) {// 不限
|
lstLastCourse.addAll(lstCourse);
|
} else {
|
lstLastCourse.addAll(cate.getCourseList());
|
}
|
|
cate.setCourseList(lstLastCourse);
|
}
|
|
return lstLastCategory;
|
}
|
|
/******************************************************************* 上面为App接口，下面为后台接口 **************************/
|
|
/**
|
* 科目类别列表
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/list", method = RequestMethod.GET)
|
public @ResponseBody List<OrgCourseCategory> list() {
|
Organization org = commonDAO.read(Organization.class, ClientUtils.getOrgId());
|
|
return commonDAO.find("from OrgCourseCategory where deleteFlag is false and categoryLevel = ? and type = ?", CollectionUtils.newList(OrgCourseCategory.CATEGORY_LEVEL_SECOND, org.getType()), OrgCourseCategory.class);
|
}
|
|
/**
|
* 根据科目ID查询科目
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/{courceTypeId}", method = RequestMethod.GET)
|
public String get(@PathVariable String courceTypeId) {
|
// TODO
|
return null;
|
}
|
|
/**
|
* 新增
|
*
|
* @return
|
*/
|
@RequestMapping(method = RequestMethod.POST)
|
public String add() {
|
// TODO
|
return null;
|
}
|
|
/**
|
* 删除
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/{courceTypeId}", method = RequestMethod.DELETE)
|
public String delete(@PathVariable String courceTypeId) {
|
// TODO
|
return null;
|
}
|
|
/**
|
* 更新
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/{courceTypeId}", method = RequestMethod.POST)
|
public String update(@PathVariable String courceTypeId) {
|
// TODO
|
return null;
|
}
|
|
/**
|
* 新增类别层级
|
*
|
* @return
|
*/
|
|
|
|
@RequestMapping(value = "/addCategory", method = RequestMethod.POST)
|
public @ResponseBody Result addCategory(String id, String name, String code, String type) {
|
|
Result result = categoryService.addCategory(null, id, name, code, type);
|
|
if(result.isSuccess()){
|
return result;
|
}
|
|
return new Result(false,"参数错误");
|
|
}
|
|
/**
|
* 类别层级数据
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/allData", method = RequestMethod.POST)
|
public @ResponseBody List<OrgCategoryLevel> allData() {
|
String hql = " from OrgCategoryLevel where deleteFlag is false and topOrgId = ? order by orderNum desc, createTime asc";
|
Organization org = commonDAO.read(Organization.class, ClientUtils.getOrgId());
|
List<OrgCategoryLevel> lstCate = commonDAO.find(hql, CollectionUtils.newList(org.getTopOrganizationId()), OrgCategoryLevel.class);
|
List<String> levelIds = new ArrayList<String>();
|
for (OrgCategoryLevel orgCategoryLevel : lstCate) {
|
levelIds.add(orgCategoryLevel.getCategoryLevelId());
|
}
|
if(levelIds.isEmpty()){
|
return lstCate;
|
}
|
Map<String,Object> args = new HashMap<String, Object>();
|
args.put("levelIds", levelIds.toArray());
|
hql = "from OrgCollegeCourse where deleteFlag is false and courseCategoryId in (:levelIds) order by code asc";
|
List<OrgCollegeCourse> courses = commonDAO.findByComplexHql(hql, args, OrgCollegeCourse.class);
|
Map<String,List<OrgCollegeCourse>> map = new HashMap<String, List<OrgCollegeCourse>>();
|
for (OrgCollegeCourse orgCollegeCourse : courses) {
|
if(null == orgCollegeCourse){
|
continue;
|
}
|
//去除掉不content内容
|
orgCollegeCourse.setContent("");
|
|
if(null == map.get(orgCollegeCourse.getCourseCategoryId())){
|
List<OrgCollegeCourse> lstCourse = new ArrayList<OrgCollegeCourse>();
|
lstCourse.add(orgCollegeCourse);
|
map.put(orgCollegeCourse.getCourseCategoryId(), lstCourse);
|
}else{
|
map.get(orgCollegeCourse.getCourseCategoryId()).add(orgCollegeCourse);
|
}
|
}
|
for (OrgCategoryLevel orgCategoryLevel : lstCate) {
|
|
orgCategoryLevel.setCourses(map.get(orgCategoryLevel.getCategoryLevelId()));
|
}
|
return lstCate;
|
}
|
|
/**
|
* 视频类别层级数据
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/allCountData", method = RequestMethod.POST)
|
public @ResponseBody List<OrgCategoryLevel> allCountData() {
|
return setCount(1);
|
}
|
|
/**
|
* 讲义类别层级数据
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/allHandoutCountData", method = RequestMethod.POST)
|
public @ResponseBody List<OrgCategoryLevel> allHandoutCountData() {
|
return setCount(2);
|
}
|
|
/**
|
* 练习类别层级数据
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/allExerciseCountData", method = RequestMethod.POST)
|
public @ResponseBody List<OrgCategoryLevel> allExersiseCountData() {
|
return setCount(3);
|
}
|
|
/**
|
* 讲义类别层级数据
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/allArticleCountData", method = RequestMethod.POST)
|
public @ResponseBody List<OrgCategoryLevel> allArticleCountData() {
|
return setCount(4);
|
}
|
|
/**
|
* 查询视频讲义练习在各个科目下的数量
|
* @param type 1:视频 2：讲义 3：练习
|
* @return
|
*/
|
@SuppressWarnings("unchecked")
|
private List<OrgCategoryLevel> setCount(int type){
|
String hql = " from OrgCategoryLevel where deleteFlag is false and topOrgId = ? order by level asc, code asc";
|
Organization org = commonDAO.read(Organization.class, ClientUtils.getOrgId());
|
List<OrgCategoryLevel> lstCate = commonDAO.find(hql, CollectionUtils.newList(org.getTopOrganizationId()), OrgCategoryLevel.class);
|
String sql = "";
|
switch (type) {
|
case 1:
|
sql = "select r.college_course_id,count(1) from media_video_re_course r, media_video v where r.delete_flag is false and r.org_id = ? and v.video_id = r.video_id and v.delete_flag is false group by college_course_id " ;
|
break;
|
case 2:
|
sql = "select r.college_course_id,count(1) from sch_handout_re_course r, sch_handout v where r.delete_flag is false and r.org_id = ? and v.handout_id = r.handout_id and v.delete_flag is false group by college_course_id" ;
|
break;
|
case 3:
|
sql = "select r.college_course_id,count(1) from exercise_re_course r where r.delete_flag is false and r.org_id = ? group by college_course_id" ;
|
break;
|
case 4:
|
sql = "select r.college_course_id,count(1) from sch_article_re_course r, sch_article v where r.delete_flag is false and r.org_id = ? and v.ARTICLE_ID = r.ARTICLE_ID and v.delete_flag is false group by college_course_id" ;
|
break;
|
default:
|
break;
|
}
|
List<Object[]> lst = this.commonDAO.findBySql(sql, CollectionUtils.newList(ClientUtils.getOrgId()));
|
|
Map<String,Integer> map = new HashMap<String,Integer>(5);
|
for (Object[] obj : lst) {
|
map.put(String.valueOf(obj[0]), Integer.parseInt(String.valueOf(obj[1])));
|
}
|
|
for (OrgCategoryLevel orgCategoryLevel : lstCate) {
|
hql = "from OrgCollegeCourse where deleteFlag is false and courseCategoryId = ? order by code asc";
|
List<OrgCollegeCourse> courses = commonDAO.find(hql, CollectionUtils.newList(orgCategoryLevel.getCategoryLevelId()), OrgCollegeCourse.class);
|
|
for(OrgCollegeCourse course : courses){
|
if(type==1){
|
course.setVideoCount(null != map.get(course.getCollegeCourseId()) ? map.get(course.getCollegeCourseId()) : 0);
|
}else if(type==2){
|
course.setHandoutCount(null != map.get(course.getCollegeCourseId()) ? map.get(course.getCollegeCourseId()) : 0);
|
}else if(type==3){
|
course.setGroupCount(null != map.get(course.getCollegeCourseId()) ? map.get(course.getCollegeCourseId()) : 0);
|
}else if(type==4){
|
course.setArticleCount(null != map.get(course.getCollegeCourseId()) ? map.get(course.getCollegeCourseId()) : 0);
|
}
|
course.setContent(null);
|
}
|
orgCategoryLevel.setCourses(courses);
|
}
|
|
return lstCate;
|
}
|
|
/**
|
* ztree层级数据
|
*
|
* @return
|
*//*
|
@RequestMapping(value = "/allHierarchyData", method = RequestMethod.POST)
|
public @ResponseBody List<OrgCourseCategory> allHierarchyData() {
|
|
return sysBusinessCacheService.getOrgCourseCategory();
|
|
}
|
|
*//**
|
* ztree层级数据
|
*
|
* @return
|
*//*
|
@RequestMapping(value = "live/allHierarchyData", method = RequestMethod.POST)
|
public @ResponseBody ResultJson allLiveHierarchyData() {
|
|
return sysBusinessCacheService.getLiveOrgCourseCategory();
|
|
}*/
|
|
/**
|
* 查询
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/oneMsg", method = RequestMethod.POST)
|
public @ResponseBody OrgCategoryLevel oneMsg(String id) {
|
String hql = "from OrgCategoryLevel where deleteFlag is false and categoryLevelId = ?";
|
|
return commonDAO.findUnique(hql, CollectionUtils.newList(id), OrgCategoryLevel.class);
|
}
|
|
/**
|
* 查询专业信息
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/oneCourse", method = RequestMethod.POST)
|
public @ResponseBody Result oneCourse(String id) {
|
String hql = "from OrgCollegeCourse where deleteFlag is false and collegeCourseId = ?";
|
OrgCollegeCourse occ = commonDAO.findUnique(hql, CollectionUtils.newList(id), OrgCollegeCourse.class);
|
|
Map<String,Object> data = new HashMap<String,Object>();
|
data.put("name", occ.getName());
|
data.put("content", occ.getContent());
|
data.put("price", occ.getPrice());
|
data.put("courseId", occ.getCourseId());
|
data.put("collegeCourseId", occ.getCollegeCourseId());
|
data.put("relation","");
|
Result result = new Result(true,null,data);
|
|
hql = " from OrgCourse where deleteFlag is false and courseId = ?";
|
OrgCourse course = commonDAO.findUnique(hql, CollectionUtils.newList(occ.getCourseId()), OrgCourse.class);
|
if(null == course){
|
return result;
|
}
|
|
hql = " from OrgCourseCategory where deleteFlag is false and categoryId = ?";
|
OrgCourseCategory cates = commonDAO.findUnique(hql, CollectionUtils.newList(course.getCourseCategoryId()), OrgCourseCategory.class);
|
|
StringBuffer sb = new StringBuffer(course.getName()).append('/');
|
sb.insert(0, cates.getCategoryName()+"/");
|
int i = 0;
|
while(cates.getCategoryLevel()==OrgCourseCategory.CATEGORY_LEVEL_FIRST){
|
i++;
|
hql = " from OrgCourseCategory where deleteFlag is false and categoryId = ?";
|
cates = commonDAO.findUnique(hql, CollectionUtils.newList(cates.getParentCategoryId()),OrgCourseCategory.class);
|
if(cates==null){
|
break;
|
}
|
sb.insert(0,cates.getCategoryName()+"/");
|
if(i==10){
|
break;
|
}
|
}
|
if(sb.length()!=0){
|
data.put("relation",sb.deleteCharAt(sb.length()-1).toString() );
|
}
|
|
return result;
|
}
|
|
/**
|
* 获取机构名字
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/getOrgName", method = RequestMethod.POST)
|
public @ResponseBody Result getOrgName() {
|
Organization org = commonDAO.read(Organization.class, ClientUtils.getOrgId());
|
|
return new Result(true, org.getName());
|
}
|
|
/**
|
* 删除科目
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/deleteCate", method = RequestMethod.POST)
|
public @ResponseBody Result deleteCate(String id) {
|
|
return categoryService.doDeleteCate(id);
|
}
|
|
/**
|
* 删除专业
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/deleteCourse", method = RequestMethod.POST)
|
public @ResponseBody Result deleteCourse(String id) {
|
|
return categoryService.doDeleteCourse(id);
|
}
|
|
/**
|
* 3初始化科目
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/initCourse", method = RequestMethod.POST)
|
public @ResponseBody Result initCourse() {
|
String hql = " from OrgCollegeCourse where deleteFlag is false ";
|
List<OrgCollegeCourse> lstCourse = commonDAO.find(hql, OrgCollegeCourse.class);
|
int i = 0;
|
|
/*for (OrgCollegeCourse orgCollegeCourse : lstCourse) {
|
Organization org = commonDAO.read(Organization.class, orgCollegeCourse.getOrganizationId());
|
hql = " from OrgCourseCategory where deleteFlag is false and categoryLevel !=? and type = ? and categoryType = ?";
|
OrgCourseCategory c = commonDAO.findUnique(hql, CollectionUtils.newList(OrgCourseCategory.CATEGORY_LEVEL_FIRST,org.getType(),orgCollegeCourse.getType()), OrgCourseCategory.class);
|
if(c!=null){
|
orgCollegeCourse.setCourseCategoryId(c.getCategoryId());
|
orgCollegeCourse.setCourseCategoryName(c.getCategoryName());
|
}
|
|
}*/
|
Map<String,Object> map = new HashMap<String, Object>();
|
Map<String,Object> courseMap = new HashMap<String, Object>();
|
for (OrgCollegeCourse orgCollegeCourse : lstCourse) {
|
Organization org = commonDAO.read(Organization.class, orgCollegeCourse.getOrganizationId());
|
hql = " from OrgCourseCategory where categoryId = ? and deleteFlag is false";
|
OrgCourseCategory cate = commonDAO.findUnique(hql, CollectionUtils.newList(orgCollegeCourse.getCourseCategoryId()), OrgCourseCategory.class);
|
if(cate==null){
|
continue;
|
}
|
//hql = " from OrgCategoryLevel where topOrgId = ? and categoryName = ? and deleteFlag is false";
|
//OrgCategoryLevel level = commonDAO.findUnique(hql,CollectionUtils.newList(orgCollegeCourse.getTopOrgId(),cate.getCategoryName()),OrgCategoryLevel.class);
|
OrgCategoryLevel level = (OrgCategoryLevel) map.get(org.getTopOrganizationId()+"-"+cate.getCategoryName());
|
if(level==null){
|
level = new OrgCategoryLevel();
|
level.setCategoryName(cate.getCategoryName());
|
level.setCode(cate.getCode());
|
level.setDeleteFlag(false);
|
level.setFullName(cate.getFullName());
|
level.setImgPath(cate.getImgPath());
|
level.setLevel(BigDecimal.ONE.shortValue());
|
level.setParentId(null);
|
level.setOrgId(orgCollegeCourse.getOrganizationId());
|
level.setTopOrgId(org.getTopOrganizationId());
|
TraceUtils.setCreateTrace(level);
|
commonService.save(level);
|
map.put(org.getTopOrganizationId()+"-"+cate.getCategoryName(), level);
|
}
|
|
//hql = " from OrgCollegeCourse where deleteFlag is false and topOrgId = ? and courseId = ?";
|
//OrgCollegeCourse oc = commonDAO.findUnique(hql, CollectionUtils.newList(org.getTopOrganizationId(),orgCollegeCourse.getCourseId()), OrgCollegeCourse.class);
|
OrgCollegeCourse oc = (OrgCollegeCourse) courseMap.get(org.getTopOrganizationId()+"-"+orgCollegeCourse.getCourseId());
|
if(oc==null){
|
orgCollegeCourse.setTopOrgId(org.getTopOrganizationId());
|
orgCollegeCourse.setCourseCategoryId(level.getCategoryLevelId());
|
orgCollegeCourse.setCourseCategoryName(level.getCategoryName());
|
commonService.save(orgCollegeCourse);
|
courseMap.put(org.getTopOrganizationId()+"-"+orgCollegeCourse.getCourseId(), orgCollegeCourse);
|
}
|
|
i++;
|
}
|
return new Result(true,"总共有"+lstCourse.size()+",初始化了"+i+"条");
|
}
|
|
/**
|
* 2先初始化课件数据，再初始化上面的科目
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/initCourseWare", method = RequestMethod.POST)
|
public @ResponseBody Result initCourseWare() {
|
|
//视频
|
int i = 0;
|
String hql = " from MediaVideoReCourse where deleteFlag is false";
|
List<MediaVideoReCourse> videos = commonDAO.find(hql, MediaVideoReCourse.class);
|
for (MediaVideoReCourse course : videos) {
|
hql = " from OrgCollegeCourse where collegeCourseId = ? and deleteFlag is false";
|
OrgCollegeCourse oc = commonDAO.findUnique(hql, CollectionUtils.newList(course.getCollegeCourseId()), OrgCollegeCourse.class);
|
if(oc==null){
|
continue;
|
}
|
course.setOrgId(oc.getOrganizationId());
|
TraceUtils.setUpdateTrace(course);
|
commonService.save(course);
|
i++;
|
}
|
//讲义
|
int y = 0;
|
hql = " from SchHandoutReCourse where deleteFlag is false";
|
List<SchHandoutReCourse> handouts = commonDAO.find(hql, SchHandoutReCourse.class);
|
for (SchHandoutReCourse course : handouts) {
|
hql = " from OrgCollegeCourse where collegeCourseId = ? and deleteFlag is false";
|
OrgCollegeCourse oc = commonDAO.findUnique(hql, CollectionUtils.newList(course.getCollegeCourseId()), OrgCollegeCourse.class);
|
if(oc==null){
|
continue;
|
}
|
course.setOrgId(oc.getOrganizationId());
|
TraceUtils.setUpdateTrace(course);
|
commonService.save(course);
|
y++;
|
}
|
//练习
|
int z = 0;
|
hql = " from ExerciseReCourse where deleteFlag is false";
|
List<ExerciseReCourse> exers = commonDAO.find(hql, ExerciseReCourse.class);
|
for (ExerciseReCourse course : exers) {
|
hql = " from OrgCollegeCourse where collegeCourseId = ? and deleteFlag is false";
|
OrgCollegeCourse oc = commonDAO.findUnique(hql, CollectionUtils.newList(course.getCollegeCourseId()), OrgCollegeCourse.class);
|
if(oc==null){
|
continue;
|
}
|
course.setOrgId(oc.getOrganizationId());
|
TraceUtils.setUpdateTrace(course);
|
commonService.save(course);
|
z++;
|
}
|
return new Result(true,"视频总共"+videos.size()+"个,成功了"+i+"个"+"讲义总共"+handouts.size()+"个,成功了"+y+"个"+"练习总共"+exers.size()+"个,成功了"+z+"个");
|
}
|
|
/**
|
* 1初始化班级 机构ID
|
*
|
* @return
|
*/
|
@RequestMapping(value = "/initClass", method = RequestMethod.POST)
|
public @ResponseBody Result initClass() {
|
String hql = " from ClsClass where deleteFlag is false ";
|
List<ClsClass> ocs = commonDAO.find(hql, ClsClass.class);
|
int i = 0;
|
for (ClsClass orgClass : ocs) {
|
hql = " from OrgCollegeCourse where collegeCourseId = ? and deleteFlag is false";
|
OrgCollegeCourse course = commonDAO.findUnique(hql,CollectionUtils.newList(orgClass.getCollegeCourseId()), OrgCollegeCourse.class);
|
if(course==null){
|
continue;
|
}
|
hql = " from Organization where organizationId = ? and deleteFlag is false";
|
Organization org = commonDAO.findUnique(hql, CollectionUtils.newList(course.getOrganizationId()), Organization.class);
|
if(org==null){
|
continue;
|
}
|
orgClass.setOrgId(org.getOrganizationId());
|
TraceUtils.setUpdateTrace(orgClass);
|
commonService.save(orgClass);
|
i++;
|
}
|
return new Result(true,"班级总共"+ocs.size()+",成功了"+i+"个");
|
}
|
|
/**
|
* 初始化levelCode
|
*
|
* @return
|
*/
|
@SuppressWarnings("unused")
|
@RequestMapping(value = "/initLevel", method = RequestMethod.GET)
|
public @ResponseBody Result initLevel() {
|
String hql = " from OrgCategoryLevel where deleteFlag is false and level = ?";
|
// List<OrgCategoryLevel> parentsFirst = commonDAO.find(hql, CollectionUtils.newList(OrgCategoryLevel.CATEGORY_LEVEL_FIRST), OrgCategoryLevel.class);
|
// for (OrgCategoryLevel orgCategoryLevel : parentsFirst) {
|
// if(StringUtils.isBlank(orgCategoryLevel.getCategoryName())||StringUtils.isNotBlank(orgCategoryLevel.getLevelCode())){
|
// continue;
|
// }
|
// String levelCode = generateLevelCode(orgCategoryLevel.getCategoryName());
|
// String code = cacheService.get("course1_"+levelCode, String.class);
|
// if(code==null){
|
// orgCategoryLevel.setLevelCode(levelCode+"_00");
|
// commonService.save(orgCategoryLevel);
|
// cacheService.set("course1_"+levelCode, 24*60*60, orgCategoryLevel.getCategoryLevelId());
|
// continue;
|
// }else{
|
// int i = 0;
|
// String lc = "";
|
// do{
|
// i++;
|
// lc = levelCode+i;
|
// }while(null!=cacheService.get("course1_"+levelCode+i, String.class));
|
// orgCategoryLevel.setLevelCode(lc+"_00");
|
// commonService.save(orgCategoryLevel);
|
// cacheService.set("course1_"+lc, 24*60*60, orgCategoryLevel.getCategoryLevelId());
|
// continue;
|
// }
|
//
|
// }
|
//
|
initNextLevel(Short.parseShort("2"));
|
initNextLevel(Short.parseShort("3"));
|
initNextLevel(Short.parseShort("4"));
|
initNextLevel(Short.parseShort("5"));
|
initNextLevel(Short.parseShort("6"));
|
initNextLevel(Short.parseShort("7"));
|
initNextLevel(Short.parseShort("8"));
|
initNextLevel(Short.parseShort("9"));
|
initNextLevel(Short.parseShort("10"));
|
|
return new Result(true);
|
}
|
|
@SuppressWarnings("unused")
|
private void initNextLevel(short level){
|
String hql = " from OrgCategoryLevel where deleteFlag is false and level = ?";
|
List<OrgCategoryLevel> parentsSecond = commonDAO.find(hql, CollectionUtils.newList(level), OrgCategoryLevel.class);
|
for (OrgCategoryLevel orgCategoryLevel : parentsSecond) {
|
if(StringUtils.isNotBlank(orgCategoryLevel.getLevelCode())){
|
continue;
|
}
|
|
OrgCategoryLevel parent = commonDAO.read(OrgCategoryLevel.class, orgCategoryLevel.getParentId());
|
if(null==parent||StringUtils.isBlank(parent.getLevelCode())){
|
continue;
|
}
|
String levelCode = parent.getLevelCode()+"00";
|
// String code = cacheService.get("course1_"+levelCode, String.class);
|
String code = null;
|
if(code==null){
|
orgCategoryLevel.setLevelCode(levelCode);
|
commonService.save(orgCategoryLevel);
|
// cacheService.set("course1_"+levelCode, 24*60*60, orgCategoryLevel.getCategoryLevelId());
|
continue;
|
}else{
|
int i = 0;
|
String lc = "";
|
do{
|
i++;
|
String h = String.valueOf(i);
|
if(i<10){
|
h = "0"+i;
|
}
|
lc = parent.getLevelCode()+h;
|
// }while(null!=cacheService.get("course1_"+lc, String.class));
|
}while(true);
|
// orgCategoryLevel.setLevelCode(lc);
|
// commonService.save(orgCategoryLevel);
|
// cacheService.set("course1_"+lc, 24*60*60, orgCategoryLevel.getCategoryLevelId());
|
// continue;
|
}
|
|
}
|
}
|
|
|
@SuppressWarnings("unused")
|
private String generateLevelCode(String name) {
|
|
// 转拼音
|
//使用微软自带中文输入法用鼠标翻页，选择第一页之后的数据时，会生成(li'zhi.dr)这种账号
|
String[] arrUnidecode = WordProcessUtils.toPinyin(name.replace(" ",""), " ").replaceAll("'", "").split(" ");
|
|
String orgCode = "";
|
if(null != arrUnidecode){
|
for(String str : arrUnidecode){
|
orgCode = orgCode.concat(str.substring(0,1));
|
}
|
}
|
|
|
return orgCode;
|
}
|
|
public static void main(String[] args) {
|
String[] arrUnidecode = WordProcessUtils.toPinyin("22".replace(" ","")).replaceAll("'", "").split(" ");
|
String orgCode = "";
|
if(null != arrUnidecode){
|
for(String str : arrUnidecode){
|
orgCode = orgCode.concat(str.substring(0,1));
|
}
|
}
|
System.out.println(orgCode);
|
}
|
|
}
|
