百课堂学习节完成时记录进度 __SOQfkhSTeVBQs57oLFw __SOQfkhSTeVBQs57oLFw published UTF-8 post /bkt/lesson/progress json =100){ progress = 100; isend = "1"; var sqls = "select id from tlk_creditMemberDetails where item_score_source_id = '"+lessonid+"'"; var datass = queryByDSName("tms",sqls); if(datass=="[]"){ var process = getDocumentProcess(); var formProcess = getFormProcess(); var subform = formProcess.doView("__84a1z2MaoRytX5nWz86"); var doc2 = process.doNew(subform, getWebUser(), createParamsTable()); var subform = formProcess.doView("__6HDqpRKrC0KPrhy2Rgo"); var doc3 = process.doNew(subform, getWebUser(), createParamsTable()); var id4= ""; var sql4 = "select id from tlk_creditRules where item_rule_name = '企业课程' order by created desc limit 1" var datas4 = queryByDSName("tms",sql4); if(datas4!="[]"){ for(var iterator = datas4.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 id4 = map1.get("id"); } } doc2.addStringItem("CREDIT_RULE_ID",id4); doc2.addStringItem("student",empid); doc2.addStringItem("CREDIT_SCORE",xf); doc2.addStringItem("notes",name); doc2.setDomainid(getDomainid()); process.doCreate(doc2); var doc2id = doc2.getId(); doc3.addStringItem("credit_detail_id",doc2id); doc3.addStringItem("student_id",empid); doc3.addStringItem("student_name",username); doc3.addStringItem("STUDENT_DEPARTMENT",departmentname); doc3.addStringItem("isdelete","0"); doc3.addStringItem("SCORE_SOURCE_ID",lessonid); process.doCreate(doc3); } } } } } doc.addStringItem("name", username); doc.addStringItem("employee_id", empid); doc.addStringItem("phone", phone); doc.addStringItem("idcardno", idcardno); doc.addStringItem("lessonid", lessonid); doc.addStringItem("progress", progress); doc.addStringItem("is_end", isend); doc.setDomainid(getDomainid()); process.doCreate(doc); pid = doc.getId(); progress = progress/100; var upsql2 = "UPDATE tlk_learnPlan_mission_process a JOIN tlk_learnPlanMission b ON a.item_mission_id = b.id AND a.item_isdelete = '0' JOIN tlk_company_course c ON c.id = b.ITEM_MISSION_ID and b.item_isdelete = '0' join tlk_chapter d on c.id = d.item_company_course_id join tlk_courseware_resource e on e.item_chapter_id = d.id set a.item_process = '"+progress+"' where a.ITEM_examinee_id = '"+empid+"' and e.id = '"+sectionid+"'" updateByDSName("tms",upsql2); }else{ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 pid = map1.get("id"); } var progress = "0"; var isend = "0"; var sql2 = "SELECT a.id,count(c.id) as count FROM tlk_company_course a JOIN tlk_chapter b ON a.id = b.ITEM_COMPANY_COURSE_ID JOIN tlk_courseware_resource c ON c.ITEM_CHAPTER_ID = b.id WHERE c.id = '"+sectionid+"'" var datas2 = queryByDSName("tms",sql2); if(datas2!="[]"){ for(var iterator = datas2.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 lessonid = map1.get("id"); } } if(isNotNull(empid) && isNotNull(lessonid)){ var sql3 = "SELECT count(z.id)+1 as counta,count(c.id) as countb,a.item_name,sum(c.item_study_score) as xf FROM tlk_company_course a JOIN tlk_chapter b ON a.id = b.ITEM_COMPANY_COURSE_ID JOIN tlk_courseware_resource c ON c.ITEM_CHAPTER_ID = b.id left join tlk_section_person z on z.item_sectionid = c.id and z.item_employee_id = '"+empid+"' WHERE a.id = '"+lessonid+"' " var datas3 = queryByDSName("tms",sql3); if(datas3!="[]"){ for(var iterator = datas3.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 counta = map1.get("counta"); countb = map1.get("countb"); name = map1.get("item_name"); xf = map1.get("xf"); counta = parseInt(counta); countb = parseInt(countb); if(!"0".equals(counta) && !"0".equals(countb)) progress = (counta/countb)*100; if(progress>=100){ progress = 100; isend = "1"; var sqls = "select id from tlk_creditMemberDetails where item_score_source_id = '"+lessonid+"'"; var datass = queryByDSName("tms",sqls); if(datass=="[]"){ var process = getDocumentProcess(); var formProcess = getFormProcess(); var subform = formProcess.doView("__84a1z2MaoRytX5nWz86"); var doc2 = process.doNew(subform, getWebUser(), createParamsTable()); var subform = formProcess.doView("__6HDqpRKrC0KPrhy2Rgo"); var doc3 = process.doNew(subform, getWebUser(), createParamsTable()); var id4= ""; var sql4 = "select id from tlk_creditRules where item_rule_name = '企业课程' order by created desc limit 1" var datas4 = queryByDSName("tms",sql4); if(datas4!="[]"){ for(var iterator = datas4.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 id4 = map1.get("id"); } } doc2.addStringItem("CREDIT_RULE_ID",id4); doc2.addStringItem("student",empid); doc2.addStringItem("CREDIT_SCORE",xf); doc2.addStringItem("notes",name); doc2.setDomainid(getDomainid()); process.doCreate(doc2); var doc2id = doc2.getId(); doc3.addStringItem("credit_detail_id",doc2id); doc3.addStringItem("student_id",empid); doc3.addStringItem("student_name",username); doc3.addStringItem("STUDENT_DEPARTMENT",departmentname); doc3.addStringItem("isdelete","0"); doc3.addStringItem("SCORE_SOURCE_ID",lessonid); process.doCreate(doc3); } } } } } progress = progress/100; var upsql = "update tlk_lesson_person set item_progress = '"+progress+"',item_is_end = '"+isend+"',lastmodified = now() where id = '"+pid+"'"; updateByDSName("tms",upsql); var upsql2 = "UPDATE tlk_learnPlan_mission_process a JOIN tlk_learnPlanMission b ON a.item_mission_id = b.id AND a.item_isdelete = '0' JOIN tlk_company_course c ON c.id = b.ITEM_MISSION_ID and b.item_isdelete = '0' join tlk_chapter d on c.id = d.item_company_course_id join tlk_courseware_resource e on e.item_chapter_id = d.id set a.item_process = '"+progress+"' where a.ITEM_examinee_id = '"+empid+"' and e.id = '"+sectionid+"'" updateByDSName("tms",upsql2); } var process = getDocumentProcess(); var formProcess = getFormProcess(); var subform = formProcess.doView("__NX4oMgim4JLxwf90smx"); var doc = process.doNew(subform, getWebUser(), createParamsTable()); doc.addStringItem("name", username); doc.addStringItem("idcardno", idcardno); doc.addStringItem("phone", phone); doc.addStringItem("sectionid", sectionid); doc.addStringItem("progress", '100'); doc.addStringItem("employee_id",empid); doc.addStringItem("is_end",'1'); var time ="0"; var studyscore = "0"; var ssql = "select item_time,item_study_score from tlk_courseware_resource where id = '"+sectionid+"'" var datass = queryByDSName("tms",ssql); if(datass!="[]"){ for(var iterator = datass.iterator();iterator.hasNext();){ var map1 = iterator.next(); time = map1.get("item_time"); studyscore = map1.get("item_study_score"); } } doc.addStringItem("studytime",time); doc.addStringItem("studyscore",studyscore); doc.addStringItem("lessonid",pid); process.doCreate(doc); result.put("code","1"); result.put("msg","success"); }else{ result.put("code","1"); result.put("msg","success"); } }else{ result.put("code","0"); result.put("msg","节id不得为空！"); } return result; })()]]>