router.route('/updateStudioWorkNew4').all((req, res, next) => { //学生
if (req.body[0]) {
let p = [req.body[0].cid];
p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_studio_course_detail2"); //執行存儲過程
mysql.usselect(p, function(ret) {
let _unitIndex = parseInt(req.body[0].unitIndex);
let _chapters = JSON.parse(req.body[0].chapters);
let _unitJson = JSON.parse(ret[0][0].chapters)
if ((_unitJson.length - 1) < _unitIndex) {
let _i = _unitIndex - (_unitJson.length - 1)
for (let i = 0; i < _i; i++) {
_unitJson.push({
dyName: "", //单元标题
chapterInfo: [{
isread: false,
chapterid: guid(),
title: "",
courseName: "",
taskJson: [{
task: "",
taskDetail: "",
chapterData: [],
toolText: "",
toolChoose: [{
tool: [],
toolDetail: "",
toolType: 0,
askCount: 1,
askTitle: "",
askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
}, ],
isShowTools: false,
askCount: 1,
isFold: 0,
askTitle: "",
askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
checkJson: [{ checkCount: [], checkPerent: [] }],
homeworkList: [],
}, ],
itemCount: 1,
fileList1: [],
video: [],
testData: [],
pData: [],
templateArray: [],
}, ],
})
}
_unitJson[_unitIndex] = _chapters[_unitIndex]
} else {
_unitJson[_unitIndex] = _chapters[_unitIndex]
}
// console.log(_unitJson);
let p2 = [req.body[0].cid, JSON.stringify(_unitJson).replaceAll(/%/g, "%25")];
p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudioWorkNew4"); //執行存儲過程
mysql.usselect(p2, function(ret) {
res.end(JSON.stringify({ success: 1 }));
});
// res.end(JSON.stringify({ success: 1 }));
});
}
});
router.route('/updateStudioWorkNew2').all((req, res, next) => { //学生
if (req.body[0]) {
p = [req.body[0].cid, req.body[0].title, req.body[0].brief, req.body[0].cover, req.body[0].evaId, req.body[0].astudent, req.body[0].see, req.body[0].chapters, req.body[0].template, req.body[0].ateacher];
p.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudioWorkNew2"); //執行存儲過程
mysql.usselect(p, function(ret) {
let course = req.body[0].courseType;
let courseId = req.body[0].cid;
let userid = req.body[0].uid;
delStudioCourseTypeS(course, courseId, userid);
res.end(JSON.stringify({ success: 1 }));
});
}
});
router.route('/addStudioCourseWorkNew2').all((req, res, next) => { //学生
if (req.body[0]) {
p = [req.body[0].uid, req.body[0].title, req.body[0].brief, req.body[0].cover, req.body[0].evaId, req.body[0].astudent, req.body[0].see, req.body[0].chapters, req.body[0].template, req.body[0].ateacher];
p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addStudioCourseWorkNew2"); //執行存儲過程
mysql.usselect(p, function(ret) {
let course = req.body[0].courseType;
let courseId = ret[0][0].courseId;
let userid = req.body[0].uid;
delStudioCourseTypeS(course, courseId, userid);
res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
});
}
});
//teacher 查询项目模板
router.route('/getStudioTemplateTs').all((req, res, next) => {
var json = queryString(req.url);
getmysql(req, res, "getStudioTemplateTs", json['oid']);
});
//查看课程
router.route('/select_studio_course_detail').all((req, res, next) => { //学生
var json = queryString(req.url);
getmysql(req, res, "select_studio_course_detail", json['cid']);
});
//查看课程
router.route('/select_studio_course_detail2').all((req, res, next) => { //学生
var json = queryString(req.url);
getmysql(req, res, "select_studio_course_detail2", json['cid']);
});
//协同恢复删除的阶段
router.route('/restoreStudioWork').all((req, res, next) => { //学生
if (req.body[0]) {
let p = [req.body[0].cid];
p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_studio_course_detail2"); //執行存儲過程
mysql.usselect(p, function(ret) {
let _chapid = req.body[0].chapid;
// console.log(_chapid);
let _chapters = JSON.parse(req.body[0].chapters);
let _unitJson = JSON.parse(ret[0][0].chapters)
let _unitJson2 = []
let chpaindex;
for (var i = 0; i < _chapters.length; i++) {
if (_chapters[i].chapterInfo[0].chapterid == _chapid) {
chpaindex = i
}
}
for (var i = 0; i < _unitJson.length; i++) {
if (_unitJson[i].chapterInfo[0].chapterid != _chapid) {
// console.log(1);
// _unitJson.splice(i, -1)
_unitJson2.push(_unitJson[i])
// break;
}
}
_unitJson2.splice(chpaindex, 0, _chapters[chpaindex])
// console.log(_unitJson2);
let p2 = [req.body[0].cid, JSON.stringify(_unitJson2).replaceAll(/%/g, "%25")];
p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudioWorkNew4"); //執行存儲過程
mysql.usselect(p2, function(ret) {
res.end(JSON.stringify({ success: 1 }));
});
// res.end(JSON.stringify({ success: 1 }));
});
}
});
//查询分类及所有子分类
router.route('/selectAllTypeStudio').all((req, res, next) => {
var json = queryString(req.url);
getmysql(req, res, "selectAllTypeStudio", json['org'], json['oid']);
});
//上传文件
router.route('/addStudioCourseWorksS').all((req, res, next) => {
postmysql(req, res, "addStudioCourseWorksS");
});
//删除提交的作业
router.route('/deleteStudioCourseWorkS').all((req, res, next) => {
postmysql(req, res, "deleteStudioCourseWorkS");
});
router.route('/selectStudioCourseNew222').all((req, res, next) => {
var json = queryString(req.url);
getmysql(req, res, "selectStudioCourseNew222", json['type'], json['uid'], json['oid'], json['org'], json['typea'], json['typeb'], json['typec'], json['typed'], json['typef'], json['typeE'], json['cu'], json['cn'], json['page'], json['pageSize']);
});
//删除课程
router.route('/deleteStudioCourse').all((req, res, next) => {
var json = queryString(req.url);
getmysql(req, res, "deleteStudioCourse", json['cid']);
});
function delStudioCourseTypeS(course, courseId, userid) {
let _courseId = courseId;
var _userdata = [
_courseId
];
_userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_studioCourseTypeS");
mysql.usselect(_userdata, function(ret) {
// console.log(ret);
addStudioCourseTypeS(userid, course, _courseId)
});
// setTimeout(() => {
// }, 1000);
}
function addStudioCourseTypeS(userid, course, _courseId) {
var _uid = userid;
var _courses = _courseId
var _tid = JSON.parse(course)
for (let i = 0; i < _tid.length; i++) {
if (_tid[i] == '') {
continue;
}
var _userdata = [
_courses,
_tid[i],
_uid,
];
_userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_studioCourseTypeS");
mysql.usselect(_userdata, function(ret) {
// console.log(ret);
});
}
}