获取用户课程 __i6zl8msHNqj50bc1SwY __i6zl8msHNqj50bc1SwY published UTF-8 post /bkt/getCourseList json =now() and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql="select t.id,t.item_course_name,t.ITEM_CLASSIFY_INDEX,t.item_classify_name,t.ITEM_COURSE_PHOTO,t.item_progress,count(y.id) as study_num,sum(z.item_time) as courseTime "+ " from (("+sql1+") union all ("+sql2+") ) t left join tlk_lesson_person y on t.id=y.ITEM_LESSONID "+ " left join tlk_chapter x on t.id = x.ITEM_COMPANY_COURSE_ID "+ " left join tlk_courseware_resource z on (t.id = z.ITEM_CHAPTER_ID or x.id = z.ITEM_CHAPTER_ID) "+ " where 1=1 "+type1Where+" group by t.id limit "+page+","+pageSize+" "; var total="select count(1) as total,"+pageIndex+" as pageIndex ,"+pageSize+" as pageSize "+ " from (("+sql1+") union all ("+sql2+") ) t where 1=1 "+type1Where+" "; }else if(type==1){//1用户所拥有的课程 var userid= getWebUser().getId(); var sql1="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_CLASSIFY_INDEX,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.item_progress "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_is_time_limit=0 and a.item_check_state='1' and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql2="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_CLASSIFY_INDEX,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.item_progress "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_check_state='1' "+ " and a.item_is_time_limit=1 and a.item_begin_time<=now() and a.item_end_time>=now() and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql="select t.id,t.item_course_name,t.ITEM_CLASSIFY_INDEX,t.item_classify_name,t.ITEM_COURSE_PHOTO,t.item_progress,count(y.id) as study_num,sum(z.item_time) as courseTime "+ " from (("+sql1+") union all ("+sql2+") ) t left join tlk_lesson_person y on t.id=y.ITEM_LESSONID "+ " left join tlk_chapter x on t.id = x.ITEM_COMPANY_COURSE_ID "+ " left join tlk_courseware_resource z on (t.id = z.ITEM_CHAPTER_ID or x.id = z.ITEM_CHAPTER_ID) "+ " where 1=1 "+whereSql+" group by t.id limit "+page+","+pageSize+" "; var total="select count(1) as total,"+pageIndex+" as pageIndex ,"+pageSize+" as pageSize "+ " from (("+sql1+") union all ("+sql2+") ) t where 1=1 "+whereSql+" "; }else if(type==2){//2完成的课程 var userid= getWebUser().getId(); var finishSql=" select DISTINCT DATE_FORMAT(LASTMODIFIED,'%Y-%m-%d') as finishTime from tlk_lesson_person where ITEM_EMPLOYEE_ID='"+userid+"' and ITEM_IS_END='1' ORDER BY LASTMODIFIED desc "; var finish = queryByDSName("tms",finishSql); var finishList = new Packages.java.util.ArrayList(); if(finish!=null){ for(var iterator = finish.iterator();iterator.hasNext();){ var finishDatas = new Packages.java.util.HashMap(); var map1 = iterator.next();//取值 var finishTime= map1.get("finishTime"); finishDatas.put("finishTime",finishTime); var sql1="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.item_progress,c.ITEM_IS_END "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_is_time_limit=0 and a.item_check_state='1' and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql2="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.item_progress,c.ITEM_IS_END "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_check_state='1' "+ " and a.item_is_time_limit=1 and a.item_begin_time<=now() and a.item_end_time>=now() and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql="select t.id,t.item_course_name,t.item_classify_name,t.ITEM_COURSE_PHOTO,t.item_progress,t.ITEM_IS_END,count(y.id) as study_num,sum(z.item_time) as courseTime "+ " from (("+sql1+") union all ("+sql2+") ) t join tlk_lesson_person y on t.id=y.ITEM_LESSONID "+ " left join tlk_chapter x on t.id = x.ITEM_COMPANY_COURSE_ID "+ " left join tlk_courseware_resource z on (t.id = z.ITEM_CHAPTER_ID or x.id = z.ITEM_CHAPTER_ID) "+ " where t.ITEM_IS_END='1' and DATE_FORMAT(y.LASTMODIFIED,'%Y-%m-%d') = '"+finishTime+"' "+whereSql+" group by t.id limit "+page+","+pageSize+" "; var datas = queryByDSName("tms",sql); finishDatas.put("courseList",datas); finishList.add(finishDatas); } } var total="select count(1) as total,"+pageIndex+" as pageIndex ,"+pageSize+" as pageSize "+ " from (("+sql1+") union all ("+sql2+") ) t where t.ITEM_IS_END='1' "+whereSql+" "; var page = queryByDSName("tms",total); result.put("msg","success!"); result.put("code","200"); result.put("datas",finishList); result.put("page",page); return result; }else if(type==3){//学习中的课程 var userid= getWebUser().getId(); var sql1="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.item_progress,c.ITEM_IS_END "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_is_time_limit=0 and a.item_check_state='1' and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql2="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.item_progress,c.ITEM_IS_END "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_check_state='1' "+ " and a.item_is_time_limit=1 and a.item_begin_time<=now() and a.item_end_time>=now() and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql="select t.id,t.item_course_name,t.item_classify_name,t.ITEM_COURSE_PHOTO,t.item_progress,t.ITEM_IS_END,count(y.id) as study_num,sum(z.item_time) as courseTime "+ " from (("+sql1+") union all ("+sql2+") ) t join tlk_lesson_person y on t.id=y.ITEM_LESSONID "+ " left join tlk_chapter x on t.id = x.ITEM_COMPANY_COURSE_ID "+ " left join tlk_courseware_resource z on (t.id = z.ITEM_CHAPTER_ID or x.id = z.ITEM_CHAPTER_ID) "+ " where t.ITEM_IS_END='0' "+whereSql+" group by t.id limit "+page+","+pageSize+" "; var total="select count(1) as total,"+pageIndex+" as pageIndex ,"+pageSize+" as pageSize "+ " from (("+sql1+") union all ("+sql2+") ) t where t.ITEM_IS_END='0' "+whereSql+" "; } if (type==4){//学过的课程 var userid= getWebUser().getId(); var sql1="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.item_progress,c.ITEM_IS_END "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_is_time_limit=0 and a.item_check_state='1' and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql2="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.item_progress,c.ITEM_IS_END "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_check_state='1' "+ " and a.item_is_time_limit=1 and a.item_begin_time<=now() and a.item_end_time>=now() and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql="select t.id,t.item_course_name,t.item_classify_name,t.ITEM_COURSE_PHOTO,t.item_progress,t.ITEM_IS_END,count(y.id) as study_num,sum(z.item_time) as courseTime "+ " from (("+sql1+") union all ("+sql2+") ) t join tlk_lesson_person y on t.id=y.ITEM_LESSONID "+ " left join tlk_chapter x on t.id = x.ITEM_COMPANY_COURSE_ID "+ " left join tlk_courseware_resource z on (t.id = z.ITEM_CHAPTER_ID or x.id = z.ITEM_CHAPTER_ID) "+ " where t.ITEM_IS_END is not null "+whereSql+" group by t.id limit "+page+","+pageSize+" "; var total="select count(1) as total,"+pageIndex+" as pageIndex ,"+pageSize+" as pageSize "+ " from (("+sql1+") union all ("+sql2+") ) t join tlk_lesson_person y on t.id=y.ITEM_LESSONID where t.ITEM_IS_END is not null "+whereSql+" "; }else if(type==5){ var userid= getWebUser().getId(); var sql1="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.ITEM_IS_COLLECT,c.item_progress "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_is_time_limit=0 and a.item_check_state='1' and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql2="select a.id,a.ITEM_NAME as item_course_name,b.ITEM_NAME as item_classify_name,a.ITEM_COURSE_PHOTO,c.ITEM_IS_COLLECT,c.item_progress "+ " from tlk_company_course a "+ " left join tlk_course_classify b on a.ITEM_CLASSIFY_ID=b.id "+ " left join tlk_lesson_person c on c.item_lessonid=a.id and c.item_employee_id='"+userid+"' "+ " where a.item_is_delete='0' and "+company+" and a.item_check_state='1' "+ " and a.item_is_time_limit=1 and a.item_begin_time<=now() and a.item_end_time>=now() and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' "; var sql="select t.id,t.item_course_name,t.item_classify_name,t.ITEM_COURSE_PHOTO,t.ITEM_IS_COLLECT,t.item_progress,count(y.id) as study_num,sum(z.item_time) as courseTime "+ " from (("+sql1+") union all ("+sql2+") ) t join tlk_lesson_person y on t.id=y.ITEM_LESSONID "+ " left join tlk_chapter x on t.id = x.ITEM_COMPANY_COURSE_ID "+ " left join tlk_courseware_resource z on (t.id = z.ITEM_CHAPTER_ID or x.id = z.ITEM_CHAPTER_ID) "+ " where t.ITEM_IS_COLLECT='1' "+whereSql+" group by t.id limit "+page+","+pageSize+" "; var total="select count(1) as total,"+pageIndex+" as pageIndex ,"+pageSize+" as pageSize "+ " from (("+sql1+") union all ("+sql2+") ) t where t.ITEM_IS_COLLECT='1' "+whereSql+" "; } var datas = queryByDSName("tms",sql); var page = queryByDSName("tms",total); result.put("msg","success!"); result.put("code","200"); result.put("datas",datas); result.put("page",page); return result; }catch(e){ result.put("msg","error"); result.put("error",e); return result; } })()]]>