pbl-api/pbl.js

// ROUTES FOR OUR API
// =============================================================================
var express = require('express');
var bcrypt = require('bcryptjs');
var router = express.Router(); // get an instance of the express Router
const querystring = require('querystring');
var mysql = require('./mysql');
// const _mysqlLabor = ["123.58.32.151", "pbl"]; //edu數據庫信息
// const _mysqluser = ["123.58.32.151", "cocorobouser"]; //用户数据库信息
const _mysqlLabor = ["172.16.12.5", "pbl"]; //edu數據庫信息
const _mysqluser = ["172.16.12.5", "cocorobouser"]; //edu數據庫信息
var crypto = require('crypto');
var https = require('https');

//統壹處理區域
router.use(async function(req, res, next) {
    await asynnext(req, res, next);
    //// make sure we go to the next routes and don't stop here
    //res.end("");
});

/**
 * @des 參數解釋同上
 */
function asynnext(req, res, next) {
    //異步處理
    return new Promise(async(resolve, reject) => {
        next();
        //resolve(true);aa
    });
}
/*測試*/
router.route('/a').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "a", json['ph'], json['pa']);
});
router.route('/b').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "b", json['ph'], json['pa']);
});
/* 注册接口 */
router.route('/register').post(function(req, res, next) {
    //mode的处理
    if (req.body[0]) {
        // 0 用户名 1 用户密码 2用户身份 3 第三方id（可有可无）
        p = Object.values(req.body[0]); //获取用户密码
        //没有第三方id的处理
        // if (p.length < 4) {
        //     p.push("")
        // }
        p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
        //密码加密
        // bcrypt.hash(p[1], 10, function (err, hash) {
        //     if (err) {
        //         return next(err);
        //     }
        //     p[1] = hash;
        // });
        //参数拼接，注册
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "register");
        //返回注册用户数据
        // mysql.usselect(p, function (ret) {
        //     res.end(ret);
        // });
        mysql.usselect(p, function(ret) {
            res.end(JSON.stringify(ret));
        });
    }
});
/*登录接口*/
router.route('/login').all((req, res, next) => {
    //mode的处理
    if (req.body[0]) {
        // 0 用户名 1 用户密码
        c = Object.values(req.body[0]); //获取用户密码
        p = [c[0]]
            // p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
        var _password = [c[0]];
        _password.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectPassword");

        mysql.usselect(_password, function(ret) {
            var _ret = ret
            var paJ = _ret[0][0].userpassword
            bcrypt.compare(c[1], paJ, function(err, result) {
                // console.log(result)
                if (result) {
                    //参数拼接，登录
                    p.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectLogin");
                    //执行存储过程
                    mysql.usselect(p, function(ret) {
                        res.end(JSON.stringify({ status: "1", ...ret }));
                    });
                } else {
                    res.end(JSON.stringify([{ status: "0" }]));
                }
            })
        });

        // console.log(isEqual)
    }

});

/*手机登录接口*/
router.route('/phoneLogin').all((req, res, next) => {
    //mode的处理
    if (req.body[0]) {
        // 0 用户名 1 用户密码
        c = Object.values(req.body[0]); //获取用户密码
        p = [c[0]]
            // p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
        var _password = [c[0]];
        _password.unshift(_mysqluser[0], _mysqluser[1], "selectPassword");

        mysql.usselect(_password, function(ret) {
            if (ret[0].length) {
                var _ret = ret
                var paJ = _ret[0][0].password
                let uid = _ret[0][0].userid
                let duid = [uid]
                bcrypt.compare(c[1], paJ, function(err, result) {
                    // console.log(result)
                    if (result) {
                        //参数拼接，登录
                        duid.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectUser");
                        //执行存储过程
                        mysql.usselect(duid, function(ret) {
                            res.end(JSON.stringify({ status: "1", ...ret }));
                        });
                    } else {
                        res.end(JSON.stringify([{ status: "0" }]));
                    }
                })
            } else {
                res.end(JSON.stringify([{ status: "0" }]));
            }
        });

        // console.log(isEqual)
    }

});

// 图片转base64
router.route('/imgToBase64').all((req, res, next) => {
    var json = queryString(req.url);
    //mode的处理
    https.get(json['img'], function(res2) {
        var chunks = [];
        var size = 0;
        res2.on('data', function(chunk) {
            chunks.push(chunk);
            size += chunk.length;　　 //累加缓冲数据的长度
        });
        res2.on('end', function(err) {
            var data = Buffer.concat(chunks, size);
            var base64Img = data.toString('base64');
            res.end(JSON.stringify([{ img: `data:image/png;base64,${base64Img}` }]));
        });
    });



});

/*登录接口*/
router.route('/loginRace').all((req, res, next) => {
    //mode的处理
    if (req.body[0]) {
        // 0 用户名 1 用户密码
        c = Object.values(req.body[0]); //获取用户密码
        p = [c[0]]
            // p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
        var _password = [c[0]];
        _password.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectPasswordRace");

        mysql.usselect(_password, function(ret) {
            var _ret = ret
            var paJ = _ret[0][0].password
            bcrypt.compare(c[1], paJ, function(err, result) {
                // console.log(result)
                if (result) {
                    //参数拼接，登录
                    p.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectLoginRace");
                    //执行存储过程
                    mysql.usselect(p, function(ret) {
                        res.end(JSON.stringify({ status: "1", ...ret }));
                    });
                } else {
                    res.end(JSON.stringify([{ status: "0" }]));
                }
            })
        });

        // console.log(isEqual)
    }

});

/* 修改密码接口 */
router.route('/updatePassword').post(function(req, res, next) {
    //mode的处理
    if (req.body[0]) {
        let p = [req.body[0].userid];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "getPassword"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            var paJ = ret[0][0].password
            var op = bcrypt.hashSync(req.body[0].opassword, bcrypt.genSaltSync(10));
            bcrypt.compare(req.body[0].opassword, paJ, function(err, result) {
                // console.log(result)
                if (result) {
                    let p2 = [req.body[0].userid, bcrypt.hashSync(req.body[0].password, bcrypt.genSaltSync(10))];
                    p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updatePassword"); //執行存儲過程
                    mysql.usselect(p2, function(ret) {
                        res.end(JSON.stringify([{ success: 1 }]));
                    });
                } else {
                    res.end(JSON.stringify([{ success: 0 }]));
                }
            })

        });
    }
});
/* 找寻重复手机号 */
router.route('/findPhone').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "findPhone", json['un']);
});
/* 找寻是否有此账号 */
router.route('/findUsername').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "findUsername", json['un']);
});
/* 找寻重复邮箱 */
router.route('/findMail').all((req, res, next) => {
    var json = queryString(req.url);
    usergetmysql(req, res, "findMail", json['un']);
});
/* 找寻重复学号 */
router.route('/findSid').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "findSid", json['un']);
});
/* 新增班级 */
router.route('/insertClass').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "insertClass", json['name'], json['oid'], json['uid']);
});
/* 查询班级 */
router.route('/selectClass').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectClass", json['cu'], json['oid'], json['cn'], json['page'], 10);
});
/* 删除班级 */
router.route('/deleteClass').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deleteClass", json['id']);
});
/* 查询学校 */
router.route('/selectOrg').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectOrg");
});
/* 查询组织 */
router.route('/selectorg2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectorg2");
});

/* 修改学校名称 */
router.route('/updateSN').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updateSchoolName", json["oid"], json["n"]);
});

/* 新增学生 */
router.route('/insertStudent').all((req, res, next) => {
    var json = queryString(req.url);
    json['userpassword'] = bcrypt.hashSync(json['userpassword'], bcrypt.genSaltSync(10))
    getmysql(req, res, "insertStudent", json['ph'], json['username'], json['userpassword'], json['type'], json['oid'], json['tid'], json['cid']);
});

// /* 新增学生 */
// router.route('/iStudent').all((req, res, next) => {
//     var json = queryString(req.url);
//     json['userpassword'] = bcrypt.hashSync(json['userpassword'], bcrypt.genSaltSync(10))
//     getmysql(req, res, "insertStudent", json['ph'], json['username'], json['userpassword'], json['type'], json['oid'], json['tid'], json['cid']);
// });

/* 查询学生 */
router.route('/selectStudent').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectStudent", json['oid'], json['cu'], json['cn'], json['page'], 8);
});

/* ppt根据学校查询学生 */
router.route('/selectStudentByScoolPPt').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectStudentByScoolPPt", json['oid'], json['cid']);
});

/* 查询项目 */
router.route('/selectStudentAdd').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectStudentAdd", json['oid'], json['cu'], json['cn']);
});
/* 查询老师 */
router.route('/selectTeacherAdd').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectTeacherAdd", json['oid'], json['cu'], json['cn']);
});
/* 查询老师 */
router.route('/selectTeacherAddOrg').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectTeacherAddOrg", json['oid'], json['cu'], json['cn']);
});

/* 查询班级是否有重复 */
router.route('/selectC').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectC", json['className']);
});

/* 查询学校是否有重复 */
router.route('/selectS').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectS", json['schoolName']);
});

/* 修改个人信息 */
router.route('/updateUser').all((req, res, next) => {
    postmysql(req, res, "updateUser");
});

//查询老师的信息
router.route('/getUser').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectUserDeail", json['uid']);
});
//查询老师的信息
router.route('/getRaceUser').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getRaceUser", json['uid']);
});
router.route('/selectUser').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectUser", json['userid']);
});
//查询教师端消息
router.route('/getNewsTeacher').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectNew", json['uid'], json['page'], 10);
});

//查询通知详情
router.route('/selectNewDetail').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectNewDetail", json['nid']);
});

//查出分组分类
router.route('/getGroup').all((req, res, next) => {
    getmysql(req, res, "selectGroupTeacher");
});

//查询这个老师底下的学生提交的作业
router.route('/getWorks').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectWorks", json['cn'], json['cid'], json['page'], 10);
});

//查询项目
router.route('/getProject').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectProject", json['type'], json['uid'], json['oid'], json['cn'], json['page'], 10);
});

//查询项目
router.route('/getMyProject').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectMyProject", json['uid'], json['page'], 10);
});

//查询项目成员
router.route('/selectProjectStudent').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_student", json['cn'], json['oid'], json['uid']);
});

//查询Banner列表
router.route('/selectBannerList').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectBannerList", json['page'], 10);
});
//查询Banner列表
router.route('/selectAllBanner').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectAllBanner", json["t"]);
});

//新增Banner
router.route('/insertBannerList').all((req, res, next) => {
    postmysql(req, res, "insertBannerList");
});
//删除提交的作业
router.route('/deleteCourseWork').all((req, res, next) => {
    postmysql(req, res, "deleteCourseWork");
});

//删除Banner
router.route('/deleteBannerList').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deleteBannerList", json['id']);
});


//新增课程
router.route('/addWork').all((req, res, next) => {
    postmysql(req, res, "insert_teacher_work");
});

//点赞评论
router.route('/insertComment').all((req, res, next) => {
    postmysql(req, res, "insertComment");
});

//取消点赞
router.route('/deleteComment').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deleteComment", json['wid'], json['lid']);
});

//上传批注图片
router.route('/updateCourseWorks').all((req, res, next) => {
    postmysql(req, res, "updateCourseWorks");
});
//上传文件
router.route('/addCourseWorks').all((req, res, next) => {
    postmysql(req, res, "addCourseWorks");
});
//上传文件
router.route('/addCourseWorksTeacher').all((req, res, next) => {
    postmysql(req, res, "addCourseWorksTeacher");
});

//上传文件
router.route('/addCourseWorks2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "addCourseWorks", json['uid'], json['cid'], json['stage'], json['task'], json['tool'], json['content'], json['type']);
});
//上传文件
router.route('/addCourseWorks3').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "addCourseWorks2", json['uid'], json['cid'], json['stage'], json['task'], json['tool'], json['content'], json['type'], json['atool']);
});
//修改课程权限（学生是否能查看所有作业）
router.route('/updateCourseSLook').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updateCourseSLook", json['sopen'], json['cid']);
});
//修改阶段锁定状态
router.route('/updateCourseLookOpen').all((req, res, next) => {
    postmysql(req, res, "updateCourseLookOpen");
});
//查看阶段锁定的状态
router.route('/getCourseState').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getCourseState", json['cid']);
});
//添加锁定状态
router.route('/addCourseState').all((req, res, next) => {
    postmysql(req, res, "addCourseState");
});
//修改锁定状态
router.route('/updateCourseSate').all((req, res, next) => {
    postmysql(req, res, "updateCourseSate");
});

//查询课程权限（学生是否能查看所有作业）
router.route('/selectCourseSLook').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectCourseSLook", json['cid']);
});

//查询作业详情
router.route('/selectWorksDetail2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectWorksDetail2", json['uid'], json['cid'], json['stage'], json['task']);
});

//查询课程全部作业详情
router.route('/selectWorksDetail3').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectWorksDetail3", json['uid'], json['cid']);
});

//学习中心教师查询作业
router.route('/selectSWorks').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectSWorks", json['cid'], json['s'], json['t']);
});

//学习中心教师查询作业全部展示
router.route('/selectSWorks2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectSWorks2", json['cid']);
});

//学习中心学生查询作业
router.route('/selectStudentWorks').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectStudentWorks", json['uid'], json['cid'], json['s'], json['t']);
});

//实时课堂作业评价
router.route('/updateStudentWork').all((req, res, next) => {
    postmysql(req, res, "updateStudentWork");
});

//学习中心查询学生
router.route('/selectWorksStudent').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectWorksStudent", json['oid'], json['cid']);
});

/* 查询学生 */
router.route('/selectStudent2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectStudent2", json['oid'], json['cu'], json['cn'], json['cid'], json['page'], 8);
});
/* 查询教师 */
router.route('/selectTeacher').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectTeacher", json['org'], json['cu'], json['cn'], json['page'], 8);
});
/* 查询所有评价体系 */
router.route('/selectAllEvaluation').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectAllEvaluation", json['oid']);
});
/* 根据市级用户查询评审员 */
router.route('/selectReviewer').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectReviewer", json['uid'], json['cn'], json['page'], 10);
});
/* 修改评审员 */
router.route('/updateReviewer').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updateReviewer", json['n'], json['p'], json['t'], json['uid']);
});
/* 删除评审员 */
router.route('/deleteReviewer').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deleteReviewer", json['uid']);
});
/* 查询案例 */
router.route('/selecAnliBox').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selecAnliBox");
});

router.route('/addWorkNew').all((req, res, next) => {
    // postmysql(req, res, "insert_teacher_work_new");
    if (req.body[0]) {
        // p = Object.values(req.body[0]);
        p = [req.body[0].uid, req.body[0].title, req.body[0].brief, req.body[0].cover, req.body[0].astudent, req.body[0].see, req.body[0].chapters, req.body[0].template];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new");
        //執行存儲過程
        mysql.usselect(p, function(ret) {
            let course = req.body[0].courseType;
            let courseId = ret[0][0].courseId;
            let userid = req.body[0].uid;
            delCourseType(course, courseId, userid);
            res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
            // res.end(JSON.stringify(ret)); 
        });
    }

});

router.route('/addWorkNew2').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], "insert_teacher_work_new2"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            let course = req.body[0].courseType;
            let courseId = ret[0][0].courseId;
            let userid = req.body[0].uid;
            delCourseType(course, courseId, userid);
            res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
        });
    }

});

//新增赛事项目
router.route('/addRace').all((req, res, next) => {
    if (req.body[0]) {
        p = [req.body[0].uid, req.body[0].info, req.body[0].over, req.body[0].pro, req.body[0].act, req.body[0].exc, req.body[0].res];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addRace"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            let course = req.body[0].courseType;
            let courseId = ret[0][0].id;
            let userid = req.body[0].uid;
            delCourseType1(course, courseId, userid);
            res.end(JSON.stringify({ courseId: courseId, success: 1 }));
        });
    }
});
//新增赛事账号信息
router.route('/addRaceUser').all((req, res, next) => {
    if (req.body[0]) {
        p = [req.body[0].reg, req.body[0].res, req.body[0].sch, req.body[0].n, req.body[0].p, req.body[0].t, req.body[0].parent];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addRaceUser"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            let num = ret[0][0].num;
            let userid = ret[0][0].userid;
            if (num < 10) {
                num = "SZ" + "00" + num + "@gdae.com";
            } else if (num < 100) {
                num = "SZ" + "0" + num + "@gdae.com";
            } else if (num > 100) {
                num = "SZ" + num + "@gdae.com";
            }
            y = [userid, num, bcrypt.hashSync("123456", bcrypt.genSaltSync(10))];
            //参数拼接，注册
            y.unshift(_mysqlLabor[0], _mysqlLabor[1], "upRaceUserNamePassword");
            mysql.usselect(y, function(ret) {
                res.end(JSON.stringify(ret));
            });
            res.end(JSON.stringify({ num: num, success: 1 }));
        });
    }
});

//修改赛事项目
router.route('/updateRace').all((req, res, next) => {
    if (req.body[0]) {
        p = [req.body[0].id, req.body[0].info, req.body[0].over, req.body[0].pro, req.body[0].act, req.body[0].exc, req.body[0].res];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateRace"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            let course = req.body[0].courseType;
            let courseId = req.body[0].id;
            let userid = req.body[0].uid;
            delCourseType1(course, courseId, userid);
            res.end(JSON.stringify({ success: 1 }));
        });
    }
});

router.route('/addWorkNew3').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].astudent, req.body[0].see, req.body[0].chapters, req.body[0].template, req.body[0].ateacher];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new3"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            let course = req.body[0].courseType;
            let courseId = ret[0][0].courseId;
            let userid = req.body[0].uid;
            delCourseType(course, courseId, userid);
            res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
        });
    }

});


function delCourseType(course, courseId, userid) {
    let _courseId = courseId;
    var _userdata = [
        _courseId
    ];
    _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_courseType");
    mysql.usselect(_userdata, function(ret) {
        // console.log(ret);
    });

    setTimeout(() => {
        addCourseType(userid, course, _courseId)
    }, 1000);
}

function delCourseType1(course, courseId, userid) {
    let _courseId = courseId;
    var _userdata = [
        _courseId
    ];
    _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_courseType1");
    mysql.usselect(_userdata, function(ret) {
        // console.log(ret);
    });

    setTimeout(() => {
        addCourseType1(userid, course, _courseId)
    }, 1000);
}

function addCourseType(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_courseType");
        mysql.usselect(_userdata, function(ret) {
            // console.log(ret);
        });
    }
}

function addCourseType1(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_courseType1");
        mysql.usselect(_userdata, function(ret) {
            // console.log(ret);
        });
    }
}

//修改课程
// router.route('/updateWork').all((req, res, next) => {
//     postmysql(req, res, "update_teacher_work");
// });

router.route('/updateWorkNew').all((req, res, next) => {
    if (req.body[0]) {
        // p = Object.values(req.body[0]);
        p = [req.body[0].cid, req.body[0].title, req.body[0].brief, req.body[0].cover, req.body[0].astudent, req.body[0].see, req.body[0].chapters, req.body[0].template];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new");
        //執行存儲過程
        mysql.usselect(p, function(ret) {
            let course = req.body[0].courseType;
            let courseId = req.body[0].cid;
            let userid = req.body[0].uid;
            delCourseType(course, courseId, userid);
            res.end(JSON.stringify({ success: 1 }));
            // res.end(JSON.stringify(ret)); 
        });
    }
});

//查询课程
// router.route('/selectCourse').all((req, res, next) => {
//     var json = queryString(req.url);
//     getmysql(req, res, "select_course", json['type'], json['uid'], json['oid'], json['page'], 10);
// });

router.route('/updateWorkNew2').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];
    //     p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new2"); //執行存儲過程
    //     mysql.usselect(p, function(ret) {
    //         let course = req.body[0].courseType;
    //         let courseId = req.body[0].cid;
    //         let userid = req.body[0].uid;
    //         delCourseType(course, courseId, userid);
    //         res.end(JSON.stringify({ success: 1 }));
    //     });
    // }
    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], "update_teacher_work_new2"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            let course = req.body[0].courseType;
            let courseId = req.body[0].cid;
            let userid = req.body[0].uid;
            delCourseType(course, courseId, userid);
            res.end(JSON.stringify({ success: 1 }));
        });
    }
});

router.route('/updateWorkNew3').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].astudent, req.body[0].see, req.body[0].chapters, req.body[0].template, req.body[0].ateacher];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new3"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            let course = req.body[0].courseType;
            let courseId = req.body[0].cid;
            let userid = req.body[0].uid;
            delCourseType(course, courseId, userid);
            res.end(JSON.stringify({ success: 1 }));
        });
    }
});

function guid() {
    var _num,
        i,
        _guid = "";
    for (i = 0; i < 32; i++) {
        _guid += Math.floor(Math.random() * 16).toString(16); //随机0  - 16 的数字 转变为16进制的字符串
        _num = Math.floor((i - 7) / 4); //计算 (i-7)除4
        if (_num > -1 && _num < 4 && i == 7 + 4 * _num) {
            //会使guid中间加 "-"   形式为xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
            _guid += "-";
        }
    }
    return _guid;
}

router.route('/updateWorkNew4').all((req, res, next) => {
    if (req.body[0]) {
        let p = [req.body[0].cid];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
        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], "update_teacher_work_new4"); //執行存儲過程
            mysql.usselect(p2, function(ret) {
                res.end(JSON.stringify({ success: 1 }));
            });
            // res.end(JSON.stringify({ success: 1 }));
        });
    }
});

//协同删除阶段
router.route('/deleteWork').all((req, res, next) => {
    if (req.body[0]) {
        let p = [req.body[0].cid];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
        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 = []
            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;
                }
            }
            // console.log(_unitJson2);
            let p2 = [req.body[0].cid, JSON.stringify(_unitJson2).replaceAll(/%/g, "%25")];
            p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new4"); //執行存儲過程
            mysql.usselect(p2, function(ret) {
                res.end(JSON.stringify({ success: 1 }));
            });
            // res.end(JSON.stringify({ success: 1 }));
        });
    }
});
//协同恢复删除的阶段
router.route('/restoreWork').all((req, res, next) => {
    if (req.body[0]) {
        let p = [req.body[0].cid];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
        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], "update_teacher_work_new4"); //執行存儲過程
            mysql.usselect(p2, function(ret) {
                res.end(JSON.stringify({ success: 1 }));
            });
            // res.end(JSON.stringify({ success: 1 }));
        });
    }
});

router.route('/selectCourseNew').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_course_new", json['type'], json['uid'], json['oid'], json['typea'], json['typeb'], json['typec'], json['typed'], json['typeE'], json['cu'], json['cn'], json['page'], 10);
});
router.route('/selectCourseNew2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_course_new2", json['type'], json['uid'], json['oid'], json['typea'], json['typeb'], json['typec'], json['typed'], json['typeE'], json['cu'], json['cn'], json['page'], 10);
});
//查询协同编辑课程
router.route('/selectCourseTeam').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectCourseTeam", json['uid'], json['oid']);
});


//查询学校
router.route('/selectSchoolName').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectOidName", json['page'], 10);
});

//查询学校
router.route('/selectSchoolName2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectOidName2", json['oid']);
});

//查询学校
router.route('/selectSchoolNameOrg').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectSchoolNameOrg", json['org'], json['page'], 10);
});

//新增批注
router.route('/addPz').all((req, res, next) => {
    postmysql(req, res, "addPz");
});
//新增批注
router.route('/addPz2').all((req, res, next) => {
    postmysql(req, res, "addPz2");
});
//删除批注
router.route('/deletePz').all((req, res, next) => {
    postmysql(req, res, "deletePz");
});
//查询批注列表
router.route('/selectPzList').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectPzList", json['cid'], json['s'], json['t']);
});
//评分
router.route('/scoreWork').all((req, res, next) => {
    postmysql(req, res, "scoreWork");
});
//删除学生
router.route('/deleteStudent').all((req, res, next) => {
    postmysql(req, res, "delete_student");
});
//查询学校底下的班级
router.route('/selectClassBySchool').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectClassBySchool", json['oid']);
});
//查询组织底下的学校
router.route('/selectSchoolByOrg').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectSchoolByOrg", json['org']);
});
//学生注册接口
router.route('/register_student').post(function(req, res, next) {
    //mode的处理
    if (req.body[0]) {
        // 0 用户名 1 用户密码 2用户身份 3 第三方id（可有可无）
        p = Object.values(req.body[0]); //获取用户密码
        //没有第三方id的处理
        // if (p.length < 4) {
        //     p.push("")
        // }
        p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
        //密码加密
        // bcrypt.hash(p[1], 10, function (err, hash) {
        //     if (err) {
        //         return next(err);
        //     }
        //     p[1] = hash;
        // });
        //参数拼接，注册
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "register_student");
        //返回注册用户数据
        // mysql.usselect(p, function (ret) {
        //     res.end(ret);
        // });
        mysql.usselect(p, function(ret) {
            res.end(JSON.stringify(ret));
        });
    }
});
//查询课程详情
router.route('/selectCourseDetail').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectCourseDetail", json['courseId']);
});
//跳转阶段时，如果有课程就查询1返回，如果没有就插入
router.route('/addUserR').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "insertUserR", json['uid'], json['cid']);
});
//新增学生端作业
router.route('/addWorks').all((req, res, next) => {
    postmysql(req, res, "add_works");
});
//查询已提交作业
router.route('/selectWork').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectWork", json['cid'], json['stage'], json['task'], json['uid']);
});
//查询作业详情
router.route('/selectWorksDetail').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectWorksDetail", json['uid'], json['cid']);
});
//新增作业评分
router.route('/updateWorks').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updateWorks", json['rate'], json['tuid'], json['id']);
});
//新增素材信息
router.route('/addMtl').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "add_mtl", json['cInfo'], json['t'], json['cBy']);
});

//根据类型查询素材信息
router.route('/selectMtl').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectMtl", json['t'], json['page'], 10);
});
//根据类型查询素材信息
router.route('/selectMtl2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectMtl2", json['t'], json['uid'], json['page'], 10);
});
//学习中心
//新增学习资源信息
router.route('/addStuMtl').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "addStuMtl", json['cInfo'], json['t'], json['cBy']);
});
//根据类型查询学习资料信息
router.route('/selectStuMtl').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectStuMtl", json['t'], json['page'], 10);
});
//删除素材
router.route('/deleteStuM').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deleteStuM", json['id']);
});


//查询学生信息
router.route('/selectSDetail').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectStudentDetail", json['uid']);
});
//查询个人课程
router.route('/selectMyCourse').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectMyCourse", json['uid']);
});
//查询个人课程groupby课程id
router.route('/selectMyCourseBycid').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectMyCourseBycid", json['uid']);
});
//查询所有课程
router.route('/selectAllCourse').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectAllCourse", json['oid'], json['page'], 10);
});
//根据班级查询所有课程
router.route('/selectAllCourseByCid').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectAllCourseByCid", json['oid'], json['cid'], json['page'], 10);
});
//根据分类查询所有课程
router.route('/selectTypeCourse').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectTypeCourse", json['uid'], json['oid'], json['typea'], json['typeb'], json['typec'], json['typed'], json['typeE'], json['cu'], json['cn'], json['classid'], json['page'], 10);
});
//根据分类查询所有课程
router.route('/selectTypeCourse2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectTypeCourse2", json['uid'], json['oid'], json['typea'], json['typeb'], json['typec'], json['typed'], json['typeE'], json['cu'], json['cn'], json['classid'], json['org'], json['page'], 10);
});
//删除素材
router.route('/deleteM').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deleteM", json['id']);
});
//点击阶段时添加观看人数
router.route('/updateVc').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updateVc", json['cid']);
});
//删除课程
router.route('/deleteCourse').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deleteCourse", json['cid']);
});
//查看课程
router.route('/select_course_detail').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_course_detail", json['cid']);
});
//模糊查找课程
// router.route('/searchCourse').all((req, res, next) => {
//     var json = queryString(req.url);
//     getmysql(req, res, "searchCourse", json['cu'], json['cn'], json['page'], 10);
// });
//创建调查问卷
router.route('/addAsk').all((req, res, next) => {
    postmysql(req, res, "insert_ask");
});
//学生提交问卷
router.route('/addAskList').all((req, res, next) => {
    postmysql(req, res, "insert_askList");
});
//根据课程id阶段id获取已提交的问卷
router.route('/getAskListByCidStage').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getAskListByCidStage", json['cid'], json['stage'], json['task']);
});
//获取调查问卷
router.route('/getAsk').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_ask", json['uid'], json['page'], 10);
});
//删除问卷
router.route('/deleteAsk').all((req, res, next) => {
    postmysql(req, res, "deleteAsk");
});
//问卷调查数据统计
router.route('/getAskListByAskid').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_askListByAskid", json['aid']);
});
//删除学生提交问卷
router.route('/deleteAskList').all((req, res, next) => {
    postmysql(req, res, "update_askList_delete");
});
//根据id获取调查问卷
router.route('/getAskList').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_askList", json['uid'], json['page'], 10);
});
//查看便签列表
router.route('/selectNote').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectNote", json['uid']);
});
//新增便签列表
router.route('/insertNote').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "insertNote", json['uid'], json['c']);
});
//根据便签id修改便签内容
router.route('/updateNote').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updateNote", json['nid'], json['c']);
});
//删除便签
router.route('/deleteNote').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deleteNote", json['nid']);
});
//查询便签
router.route('/selectNoteContent').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectNoteContent", json['cn']);
});
//修改用户信息
router.route('/updateUserByEdu').all((req, res, next) => {
    postmysql(req, res, "updateUserByEdu");
});
//修改用户信息
router.route('/updateUserByEdu1').all((req, res, next) => {
    postmysql(req, res, "updateUserByEdu1");
});
//修改用户信息
router.route('/updateUserByEduOid').all((req, res, next) => {
    postmysql(req, res, "updateUserByEduOid");
});

//教师端data修改pbl用户信息
router.route('/updatePblMessage').all((req, res, next) => {
    postmysql2(req, res, "updatePblMessage");
});
router.route('/updatePblMessage2').all((req, res, next) => {
    postmysql(req, res, "updatePblMessage");
});
router.route('/updateRaceUser').all((req, res, next) => {
    postmysql(req, res, "updateRaceUser");
});
//查询用户信息
router.route('/selectUser').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectUser", json['userid']);
});
//查询分类及子分类
router.route('/selectType').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectType", );
});
//查询赛事分类及子分类
router.route('/selectMatType').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectMatType", );
});

//根据学校查询分类
router.route('/selectPtype').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectPtype", json["page"], 10);
});
//添加分类
router.route('/addPtype').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "addPtype", json["n"], json["uid"], json["oid"]);
});
//修改分类
router.route('/updatePtype').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updatePtype", json["n"], json["tid"]);
});
//删除分类
router.route('/deletePtype').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "deletePtype", json["tid"]);
});
//查询子分类列表
router.route('/selectStype').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectStype", json["pid"], json["oid"], json["page"], 10);
});
//添加子分类
router.route('/addStype').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "addStype", json["pid"], json["n"], json["uid"], json["oid"]);
});
//根据学校id查询子分类
router.route('/selectTypeByOid').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectTypeByOid", json["oid"]);
});

//根据组织id查询子分类
router.route('/selectTypeByOrg').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectTypeByOrg", json["oid"]);
});

//更加父id查询分类
router.route('/selectTypeByPid').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectTypeByPid", json['pid']);
});
//点击工具计数
router.route('/insertToolsCount').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "insertToolsCount", json['cid'], json['chid'], json['uid'], json['tid'], json['count']);
});
//修改工具次数
router.route('/updateToolsCount').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updateToolsCount", json['cid'], json['chid'], json['uid'], json['tid'], json['count']);
});
//查询工具次数
router.route('/selectToolsCount').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectToolsCount", json['cid'], json['chid'], json['uid']);
});
//导出学生
router.route('/selectUserBySchool').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectUserBySchool", json['oid']);
});
//上传学生作业
router.route('/insertSWork').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "insertSWork", json['uid'], json['cid'], json['p'], json['t'], json['upload']);
});
//查询学生作业
router.route('/selectSWork').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectSWork", json['uid'], json['cid'], json['p'], json['type']);
});
//查询赛事案例设计
router.route('/selectCase').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectCase", json['org']);
});
//查询赛事案例设计
router.route('/selectCase2').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectCase2", json['org']);
});

//查询赛事项目列表
router.route('/selectRaceList').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectRaceList", json['uid']);
});
//修改赛事状态
router.route('/updateRaceState').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "updateRaceState", json['id']);
});
//查询赛事项目详情
router.route('/selectRaceDetail').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectRaceDetail", json['id']);
});
//race 查询学校
router.route('/getSchool').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getSchool", json['n']);
});

//lsc
//admin 查询学校
router.route('/getSchoolAdmin').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_school", json['page'], 10);
});
//admin 添加学校
router.route('/addSchoolAdmin').all((req, res, next) => {
    postmysql(req, res, "add_school");
});
//组织添加学校
router.route('/addSchoolOrg').all((req, res, next) => {
    postmysql(req, res, "addSchoolOrg");
});
//admin 删除学校
router.route('/deleteSchoolAdmin').all((req, res, next) => {
    postmysql(req, res, "delete_school");
});
//admin 查询班级
router.route('/getClassAdmin').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_classAdmin", json['cn'], json['page'], 10);
});
//admin 添加班级
router.route('/addClassAdmin').all((req, res, next) => {
    postmysql(req, res, "add_classAdmin");
});
//admin 查询班级是否重复
router.route('/getClassRepeat').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_classRepeatAdmin", json['n'], json['oid']);
});
//admin 发布通知
router.route('/addNews').all((req, res, next) => {
    postmysql(req, res, "add_news");
});
//admin 删除通知
router.route('/deleteNews').all((req, res, next) => {
    postmysql(req, res, "delete_news");
});
//admin 添加banner
router.route('/addBanner').all((req, res, next) => {
    postmysql(req, res, "add_banner");
});
//admin 添加banner
router.route('/deleteBanner').all((req, res, next) => {
    postmysql(req, res, "delete_banner");
});
//admin 查询banner
router.route('/getBanner').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_banner");
});
//根据学校查询banner
router.route('/selectBannerByOid').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectBannerByOid", json["oid"]);
});
//admin 查询课程getSearchCourse
router.route('/getSearchCourse').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectAll_courseSearch", json['t']);
});
//根据学校查询课程
router.route('/getSearchCourseByoid').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectAll_courseByOid", json['t'], json['oid']);
});

//admin 查询所有课程专区
router.route('/getZone').all((req, res, next) => {
    getmysql(req, res, "select_zone");
});
//admin 添加课程专区
router.route('/addZone').all((req, res, next) => {
    postmysql(req, res, "insert_classZone");
});
//查询所有课程专区下的课程
router.route('/getZoneClass').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_zoneClass", json['bid'], json['oid'], json['page'], 10);
});
//查询所有课程专区下的课程
router.route('/getZoneClassStudent').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_zoneClass", json['bid'], json['oid'], json['page'], 20);
});
//admin 后台查看专区下课程的数量
router.route('/getZoneClassNum').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_zoneClassNum", json['bid']);
});
//admin 后台添加课程专区时查看课程是否在此专区重复
router.route('/getZoneClassRepeat').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_zoneClassRepeat", json['pid'], json['cid']);
});
//把课程添加进专区
router.route('/addZoneCourse').all((req, res, next) => {
    postmysql(req, res, "insert_app");
});
//admin 删除课程专区底下的课程
router.route('/deleteZoneCourse').all((req, res, next) => {
    postmysql(req, res, "delete_app");
});
//admin 删除班级
router.route('/deleteZone').all((req, res, next) => {
    postmysql(req, res, "delete_zone");
});

//admin 后台专区上移下移
router.route('/zoneRank').all((req, res, next) => {
    postmysql(req, res, "update_classRank");
});

//admin 添加模板文档
router.route('/addTemplateAdmin').all((req, res, next) => {
    postmysql(req, res, "add_template");
});

//admin 添加模板文档
router.route('/deleteTemplateAdmin').all((req, res, next) => {
    postmysql(req, res, "delete_template");
});

//admin 查询模板文档
router.route('/getTemplateAdmin').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_template", json['page'], 10);
});

//查询上传作业
router.route('/getCourseWorks').all((req, res, next) => {
    var json = queryString(req.url); //cid 课程id,page 页数
    getmysql(req, res, "select_courseWorks", json['cid'], json['stage'], json['task'], json['page'], 10);
});
//查询上传作业
router.route('/getCourseWorks2').all((req, res, next) => {
    var json = queryString(req.url); //cid 课程id,page 页数
    getmysql(req, res, "select_courseWorks2", json['cid'], json['uname'], json['stage'], json['task'], json['page'], 10);
});

//查询上传作业
router.route('/getCourseWorks3').all((req, res, next) => {
    var json = queryString(req.url); //cid 课程id,page 页数
    getmysql(req, res, "select_courseWorks3", json['cid'], json['uname'], json['stage'], json['task'], json['page'], 10);
});


//查询报告数据
router.route('/getCourseWorksReport').all((req, res, next) => {
    var json = queryString(req.url); //cid 课程id,page 页数
    getmysql(req, res, "getCourseWorksReport", json['cid']);
});


//admin 添加项目模板文档
router.route('/addCourseTemplateAdmin').all((req, res, next) => {
    postmysql(req, res, "add_courseTemplate");
});

//admin 添加项目模板文档
router.route('/deleteCourseTemplateAdmin').all((req, res, next) => {
    postmysql(req, res, "delete_courseTemplate");
});

//admin 查询项目模板文档
router.route('/getCourseTemplateAdmin').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_courseTemplate", json['page'], 10);
});

//teacher 查询项目模板
router.route('/getCourseTemplateT').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_courseTemplateT");
});

//admin 查询课程
router.route('/getCourseAdmin').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_courseAdmin", json['cn'], json['page'], 10);
});

//admin 查询模板文档
router.route('/deleteCourseAdmin').all((req, res, next) => {
    postmysql(req, res, "delete_courseAdmin");
});

//查询ppt在哪页
router.route('/selectPptPage').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectPptPage", json['id']);
});
//修改ppt页码
router.route('/updatePptPage').all((req, res, next) => {
    postmysql(req, res, "updatePptPage");
});
//修改ppt操作
router.route('/updatePPTHandle').all((req, res, next) => {
    postmysql(req, res, "updatePPTHandle");
});
//查询实时课堂
router.route('/getRealTimeClass').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getRealTimeClass", json["cn"], json["uid"], json["page"], 10);
});
//查询实时课堂学生
router.route('/getRealTimeClassStu').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getRealTimeClassStu", json["oid"], json["cid"], json["page"], 10);
});
//查询实时课堂学生
router.route('/getRealTimeClassById').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getRealTimeClassById", json["id"]);
});

//根据市级管理者查询案例
router.route('/selectAnliList').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectAnliList", json["typea"], json["typeb"], json["typec"], json["typed"], json["typeE"], json["cn"], json["page"], 10);
});

//分配案例
router.route('/insertCase').all((req, res, next) => {
    if (req.body[0]) {
        p = [req.body[0].uid, req.body[0].box];
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insertCase"); //執行存儲過程
        mysql.usselect(p, function(ret) {
            res.end(JSON.stringify({ success: 1 }));
        });
    }
});






//teacher 查询模板
router.route('/getTemplateT').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_templateT");
});

//思维网格 创建房间
router.route('/insertRoom').all((req, res, next) => {
    postmysql(req, res, "insertRoom");
});

//协同编辑 创建房间
router.route('/insertRoomByFile').all((req, res, next) => {
    //var json = queryString(req.url);
    postmysql2(req, res, "insertRoomByFile");
    //getmysql(req, res, "insertRoomByFile", json["uid"], json["n"], json["d"]);
});

//思维网格 查询是否是重复房间号
router.route('/checkRoomNum').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "checkRoomNum", json['num']);
});

//思维网格 查询房间列表
router.route('/selectRoomList').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectRoomList", json['uid'], json['oid'], json['cid'], json['cu'], json['cn']);
});

//查询pdf列表
router.route('/selectRTC').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectRTC", json['uid'], json['cu'], json['cn']);
});


//协同文档 查询房间列表
router.route('/selectFileList').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectFileList", json['uid'], json['oid'], json['cid'], json['cu'], json['cn']);
});

//协同编辑 查询是否是重复房间号
router.route('/checkRoomNumByFile').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "checkRoomNumByFile", json['num']);
});

//思维网格 根据房间号或者用户id查询房间信息
router.route('/selectRoom').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectRoom", json['uid']);
});
//思维网格 根据房间号或者用户id查询房间信息
router.route('/getRoom').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_room", json['fid']);
});

//协同编辑 根据房间号或者用户id查询房间信息
router.route('/selectRoomByFile').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "selectRoomByFile", json['uid']);
});

//思维网格 修改房间数据
router.route('/updateRoomData').all((req, res, next) => {
    postmysql(req, res, "updateRoomData");
});

router.route('/updateFileData').all((req, res, next) => {
    var json = queryString(req.url);
    var json2 = json['mode'].split(',');
    getmysql(req, res, "updateFileData", json2[0], json2[1]);
});

router.route('/select_file').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "select_file", json['fid']);
});

//思维网格 解散房间
router.route('/dismiss').all((req, res, next) => {
    postmysql(req, res, "update_room");
});

//提交提问
router.route('/addProblem').all((req, res, next) => {
    postmysql(req, res, "add_problem");
    //cid 课程id,chid 章节id,t 提问内容,uid 用户id 
});


//查询提交的提问
router.route('/getProblem').all((req, res, next) => {
    var json = queryString(req.url); //cid 课程id,page 页数
    getmysql(req, res, "select_problem", json['cid'], json['page'], 10);
});

//获取用户基本信息
router.route('/getUserInfo').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getUserInfo", json['uid'], json['cid']);
});
//获取项目基本信息
router.route('/getCourseInfo').all((req, res, next) => {
    var json = queryString(req.url);
    getmysql(req, res, "getCourseInfo", json['cid']);
});



//作业生成报告
router.route('/getWorkData').all((req, res, next) => {
    var json = queryString(req.url); //cid 课程id,page 页数
    getmysql(req, res, "select_work_data", json['cid']);
});

//查询评价体系
router.route('/getEvaluation').all((req, res, next) => {
    var json = queryString(req.url); //cid 课程id,page 页数
    getmysql(req, res, "select_evaluation", json['oid'], json['n'], json['page'], 10);
});

//添加评价体系
router.route('/addEvaluation').all((req, res, next) => {
    postmysql(req, res, "add_evaluation");
    //uid 用户id t标题 c内容
});

//修改评价体系
router.route('/updateEvaluation').all((req, res, next) => {
    postmysql(req, res, "update_evaluation");
    //c内容 t标题 id评价id
});

//删除评价体系
router.route('/deleteEvaluation').all((req, res, next) => {
    postmysql(req, res, "delete_evaluation");
    // id评价id
});

//批量添加学生
router.route('/batchRegistrationMore').post(function(req, res, next) {
    let users = req.body[0];
    let arr = JSON.parse(req.body[0].arr);
    for (let i = 0; i < arr.length; i++) {
        let _username = arr[i].name;
        let _mail = arr[i].mail;
        let _password = users.password || "123456";
        let _alias = arr[i].name;
        let _oid = users.oid;
        let _ph = arr[i].phone ? arr[i].phone : '';
        let _class = arr[i].class;
        let _sId = arr[i].sId;
        //加密密碼
        _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
        //生成激活碼
        let _hashstr = new Date().getTime() + "";
        let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
        //用戶數據
        let _userdata = [
            _mail,
            _password,
            _alias,
            "",
            1, //0老师 1学生
            _username,
            "",
            generateAPIKey(_username),
            _digest,
            "",
            _username,
            _sId,
            2, //1老师 2学生
            _oid,
            _ph,
            _class,
            '',
            "0",
        ];
        //參數拼接，註冊
        _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister");
        //用戶註冊處理
        mysql.usselect(_userdata, function(ret) {
            // let _pbluserdata = [
            //     ret[1][0].uid,
            //     _username,
            //     _sId,
            //     2,
            //     _oid,
            //     _ph,
            //     _class,
            //     '',
            //     "0",
            // ];
            // _pbluserdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateUserByEdu");
            // mysql.usselect(_pbluserdata, function(ret) {
            res.end(JSON.stringify({ success: 1 }));
            // });
        });
    }
});
//批量添加教师
router.route('/batchRegistrationMore1').post(function(req, res, next) {
    let users = req.body[0];
    let arr = JSON.parse(req.body[0].arr);
    for (let i = 0; i < arr.length; i++) {
        let _username = arr[i].name;
        let _mail = arr[i].mail;
        let _password = users.password || "123456";
        let _alias = arr[i].name;
        let _org = users.org;
        let _oid = arr[i].school;
        let _ph = arr[i].phone ? arr[i].phone : '';
        let _class = arr[i].class;
        let _sId = arr[i].sId;
        //加密密碼
        _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
        //生成激活碼
        let _hashstr = new Date().getTime() + "";
        let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
        //用戶數據
        let _userdata = [
            _mail,
            _password,
            _alias,
            "",
            0, //0老师 1学生
            _username,
            "",
            generateAPIKey(_username),
            _digest,
            "",
            _username,
            _sId,
            1, //1老师 2学生
            _org,
            _oid,
            '',
            '',
            '',
            "0",
        ];
        //參數拼接，註冊
        _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister_oid");
        //用戶註冊處理
        mysql.usselect(_userdata, function(ret) {
            res.end(JSON.stringify({ success: 1 }));
        });
    }
});
//新增学生
router.route('/batchRegistration').post(function(req, res, next) {
    var users = req.body[0];
    //循环注册
    var _username = users.alias;
    var _mail = users.username;
    var _password = users.password || "123456";
    var _alias = users.alias;
    var _oid = users.oid;
    var _ph = users.ph;
    var _class = users.cid;
    var _sId = users.sid;
    //加密密碼
    _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
    //生成激活碼
    let _hashstr = new Date().getTime() + "";
    let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
    //用戶數據
    var _userdata = [
        _mail,
        _password,
        _alias,
        "",
        1,
        _username,
        "",
        generateAPIKey(_username),
        _digest,
        "",
        _username,
        _sId,
        2,
        _oid,
        _ph,
        _class,
        '',
        "0",
    ];
    //參數拼接，註冊
    _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister");
    //用戶註冊處理
    mysql.usselect(_userdata, function(ret) {
        res.end(JSON.stringify({ uid: ret[1][0].uid, ph: _ph, oid: _oid, cid: _class, success: 1 }));
    });
});

//新增教师
router.route('/batchRegistration1').post(function(req, res, next) {
    var users = req.body[0];
    //循环注册
    var _username = users.alias;
    var _mail = users.username;
    var _password = users.password || "123456";
    var _alias = users.alias;
    var _org = users.org;
    var _oid = users.oid;
    var _ph = users.ph;
    var _class = users.cid;
    var _sId = users.sid;
    //加密密碼
    _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
    //生成激活碼
    let _hashstr = new Date().getTime() + "";
    let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
    //用戶數據
    var _userdata = [
        _mail,
        _password,
        _alias,
        "",
        0,
        _username,
        "",
        generateAPIKey(_username),
        _digest,
        "",
        _username,
        _sId,
        1,
        _org,
        _oid,
        _ph,
        _class,
        '',
        "0",
    ];
    //參數拼接，註冊
    _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister1");
    //用戶註冊處理
    mysql.usselect(_userdata, function(ret) {
        res.end(JSON.stringify({ uid: ret[1][0].uid, ph: _ph, oid: _oid, cid: _class, success: 1 }));
    });
});

router.route('/batchRegistrationOrg').post(function(req, res, next) {
    var users = req.body[0];
    //循环注册
    var _username = users.alias;
    var _mail = users.username;
    var _password = users.password || "123456";
    var _alias = users.alias;
    var _oid = users.oid;
    var _ph = users.ph;
    var _class = users.cid;
    var _sId = users.sid;
    var _org = users.org;
    //加密密碼
    _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
    //生成激活碼
    let _hashstr = new Date().getTime() + "";
    let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
    //用戶數據
    var _userdata = [
        _mail,
        _password,
        _alias,
        "",
        1,
        _username,
        "",
        generateAPIKey(_username),
        _digest,
        "",
        _username,
        _sId,
        2,
        _oid,
        _ph,
        _class,
        '',
        "0",
        _org
    ];
    //參數拼接，註冊
    _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister_org");
    //用戶註冊處理
    mysql.usselect(_userdata, function(ret) {
        res.end(JSON.stringify({ uid: ret[1][0].uid, ph: _ph, oid: _oid, cid: _class, success: 1 }));
    });
});

router.route('/batchRegistrationMoreOrg').post(function(req, res, next) {
    let users = req.body[0];
    let arr = JSON.parse(req.body[0].arr);
    for (let i = 0; i < arr.length; i++) {
        let _username = arr[i].name;
        let _mail = arr[i].mail;
        let _password = users.password || "123456";
        let _alias = arr[i].name;
        let _oid = users.oid;
        let _ph = arr[i].phone ? arr[i].phone : '';
        let _class = arr[i].class;
        let _sId = arr[i].sId;
        let _org = users.org;
        //加密密碼
        _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
        //生成激活碼
        let _hashstr = new Date().getTime() + "";
        let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
        //用戶數據
        let _userdata = [
            _mail,
            _password,
            _alias,
            "",
            1, //0老师 1学生
            _username,
            "",
            generateAPIKey(_username),
            _digest,
            "",
            _username,
            _sId,
            2, //1老师 2学生
            _oid,
            _ph,
            _class,
            '',
            "0",
            _org
        ];
        //參數拼接，註冊
        _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregisterp_org2");
        //用戶註冊處理
        mysql.usselect(_userdata, function(ret) {
            res.end(JSON.stringify({ success: 1 }));
        });
    }
});

function generateAPIKey(username) {

    let timeStamp = new Date().getTime();

    let hashStr = timeStamp + username;

    let digest = crypto.createHash('sha256').update(hashStr, 'utf8').digest('hex');

    return digest;

}



queryString = function(url) {
    var a = url.split("?");
    var json = querystring.parse(a[1])
    return json;
}

//post存儲過程處理
postmysql = function(req, res, functionname) {
    //mode的處理
    if (req.body[0]) {
        p = Object.values(req.body[0]);
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
        //執行存儲過程
        mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); });
    }
}

//post存儲過程處理
postmysql2 = function(req, res, functionname) {
    //mode的處理
    if (req.body) {
        p = Object.values(req.body)[0].split(",");
        p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
        //執行存儲過程
        mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); });
    }
}

//get獲取數據庫信息
getmysql = function(req, res, functionname, ...p) {
    p = p || [];
    p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
    //執行存儲過程
    mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); }); //
}


//post存储过程处理

userpostmysql = function(req, res, functionname) {

    //mode的处理

    if (req.body.mode) {

        p = req.body.mode.split(",");

        p.unshift(_mysqluser[0], _mysqluser[1], functionname);

        //执行存储过程

        mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); });

    }

}



//get获取数据库信息

usergetmysql = function(req, res, functionname, ...p) {

    p = p || [];

    p.unshift(_mysqluser[0], _mysqluser[1], functionname);

    //执行存储过程

    mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); }); //

}

module.exports = router;