学习总览
__fZPXLvfVWV8SpJdpjPb
__fZPXLvfVWV8SpJdpjPb
published
UTF-8
post
/study/overview
json
= month(CURRENT_DATE) WHERE a.item_is_delete = '0' and a.item_check_state = '1' AND ((a.item_course_part = 0 AND a.item_company_id like '%aSuXCEfz%') OR a.domainId = '"+getDomainid()+"') AND (a.ITEM_IS_TIME_LIMIT = 0 OR (a.ITEM_IS_TIME_LIMIT = 1 AND a.ITEM_BEGIN_TIME <= now() AND a.item_end_time >= now()))";
var sql2 = "SELECT cast(sum(b.item_time_m) as char) as learning_time,cast(sum(d.item_time_m) as char) as learning_time_m FROM tlk_section_person a JOIN tlk_courseware_resource b ON a.item_sectionid = b.id left join tlk_section_person c on a.id = c.id and month(c.created) >= month(CURRENT_DATE) left join tlk_courseware_resource d on c.item_sectionid = d.id where a.item_is_end = 1 and a.item_progress = 100 and a.domainid = '"+getDomainid()+"'";
var sql3 = "SELECT count(a.id) as learn_project_number,count(b.id) as learn_project_number_m FROM tms.tlk_learnplan a left join tms.tlk_learnplan b on a.id = b.id and month(b.created) >= month(CURRENT_DATE) WHERE a.item_isDelete = '0' and a.ITEM_release_status = '1' and a.ITEM_EFFECT_DATE_START <= now() and a.ITEM_EFFECT_DATE_END >= now() and a.domainid = '"+getDomainid()+"'";
var sql4 = "SELECT count(a.id) as exam_number,count(b.id) as exam_number_m FROM tlk_enterprise_exam_info a left join tlk_enterprise_exam_info b on a.id = b.id and month(b.created) >= month(CURRENT_DATE) WHERE a.item_isDelete = '0' and a.domainid = '"+getDomainid()+"' and a.ITEM_EXAM_RELEASE_STATUS = '1'";
var course_number = 0;
var course_number_m = 0;
var learning_time = 0;
var learning_time_m = 0;
var learn_project_number = 0;
var learn_project_number_m = 0;
var exam_number = 0;
var exam_number_m = 0;
var datas = queryByDSName("tms",sql);
if(datas!="[]"){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
course_number = map1.get("course_number");
course_number_m = map1.get("course_number_m");
}
}
var datas2 = queryByDSName("tms",sql2);
if(datas2!="[]"){
for(var iterator = datas2.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
learning_time = map1.get("learning_time");
learning_time_m = map1.get("learning_time_m");
}
}
var datas3 = queryByDSName("tms",sql3);
if(datas3!="[]"){
for(var iterator = datas3.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
learn_project_number = map1.get("learn_project_number");
learn_project_number_m = map1.get("learn_project_number_m");
}
}
var datas4 = queryByDSName("tms",sql4);
if(datas4!="[]"){
for(var iterator = datas4.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
exam_number = map1.get("exam_number");
exam_number_m = map1.get("exam_number_m");
}
}
result.put("course_number",course_number);
result.put("course_number_m",course_number_m);
result.put("learning_time",learning_time);
result.put("learning_time_m",learning_time_m);
result.put("learn_project_number",learn_project_number);
result.put("learn_project_number_m",learn_project_number_m);
result.put("exam_number",exam_number);
result.put("exam_number_m",exam_number_m);
return result;
})()]]>