根据课程类型id获取课程
__i6zl8msHNqj50bc1SwY
__i6zl8msHNqj50bc1SwY
published
UTF-8
post
/bkt/getCourseByClassifyId
json
=now() and a.item_check_state='1' and ITEM_AUTH_TYPE=0 or ITEM_PERSON like '%"+userid+"%' ";
var sql=" select t.id,t.item_course_photo,t.item_course_name,t.ITEM_INTRODUCTION,t.ITEM_IS_TIME_LIMIT, "+
" t.item_begin_time,t.ITEM_END_TIME,t.item_classify_name "+
" from ( ("+sql1+") union all ("+sql2+") ) t ";
var datas = queryByDSName("tms",sql);
result.put("msg","success!");
result.put("code","200");
result.put("data",datas);
return result;
}else{
result.put("msg","课程类型id为空!");
result.put("code","200");
return result;
}
}
catch(e){
result.put("msg","error:"+e);
result.put("code","500");
return result;
}
})()]]>