pbl.js 45 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308
  1. // ROUTES FOR OUR API
  2. // =============================================================================
  3. var express = require('express');
  4. var bcrypt = require('bcryptjs');
  5. var router = express.Router(); // get an instance of the express Router
  6. const querystring = require('querystring');
  7. var mysql = require('./mysql');
  8. // const _mysqlLabor = ["123.58.32.151", "pbl"]; //edu數據庫信息
  9. // const _mysqluser = ["123.58.32.151", "cocorobouser"]; //用户数据库信息
  10. const _mysqlLabor = ["172.16.12.5", "pbl"]; //edu數據庫信息
  11. const _mysqluser = ["172.16.12.5", "cocorobouser"]; //edu數據庫信息
  12. var crypto = require('crypto');
  13. //統壹處理區域
  14. router.use(async function(req, res, next) {
  15. await asynnext(req, res, next);
  16. //// make sure we go to the next routes and don't stop here
  17. //res.end("");
  18. });
  19. /**
  20. * @des 參數解釋同上
  21. */
  22. function asynnext(req, res, next) {
  23. //異步處理
  24. return new Promise(async(resolve, reject) => {
  25. next();
  26. //resolve(true);aa
  27. });
  28. }
  29. /*測試*/
  30. router.route('/a').all((req, res, next) => {
  31. var json = queryString(req.url);
  32. getmysql(req, res, "a", json['ph'], json['pa']);
  33. });
  34. router.route('/b').all((req, res, next) => {
  35. var json = queryString(req.url);
  36. getmysql(req, res, "b", json['ph'], json['pa']);
  37. });
  38. /* 注册接口 */
  39. router.route('/register').post(function(req, res, next) {
  40. //mode的处理
  41. if (req.body[0]) {
  42. // 0 用户名 1 用户密码 2用户身份 3 第三方id(可有可无)
  43. p = Object.values(req.body[0]); //获取用户密码
  44. //没有第三方id的处理
  45. // if (p.length < 4) {
  46. // p.push("")
  47. // }
  48. p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  49. //密码加密
  50. // bcrypt.hash(p[1], 10, function (err, hash) {
  51. // if (err) {
  52. // return next(err);
  53. // }
  54. // p[1] = hash;
  55. // });
  56. //参数拼接,注册
  57. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "register");
  58. //返回注册用户数据
  59. // mysql.usselect(p, function (ret) {
  60. // res.end(ret);
  61. // });
  62. mysql.usselect(p, function(ret) {
  63. res.end(JSON.stringify(ret));
  64. });
  65. }
  66. });
  67. /*登录接口*/
  68. router.route('/login').all((req, res, next) => {
  69. //mode的处理
  70. if (req.body[0]) {
  71. // 0 用户名 1 用户密码
  72. c = Object.values(req.body[0]); //获取用户密码
  73. p = [c[0]]
  74. // p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  75. var _password = [c[0]];
  76. _password.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectPassword");
  77. mysql.usselect(_password, function(ret) {
  78. var _ret = ret
  79. var paJ = _ret[0][0].userpassword
  80. bcrypt.compare(c[1], paJ, function(err, result) {
  81. // console.log(result)
  82. if (result) {
  83. //参数拼接,登录
  84. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectLogin");
  85. //执行存储过程
  86. mysql.usselect(p, function(ret) {
  87. res.end(JSON.stringify({ status: "1", ...ret }));
  88. });
  89. } else {
  90. res.end(JSON.stringify([{ status: "0" }]));
  91. }
  92. })
  93. });
  94. // console.log(isEqual)
  95. }
  96. });
  97. /* 找寻重复手机号 */
  98. router.route('/findPhone').all((req, res, next) => {
  99. var json = queryString(req.url);
  100. getmysql(req, res, "findPhone", json['un']);
  101. });
  102. /* 找寻重复邮箱 */
  103. router.route('/findMail').all((req, res, next) => {
  104. var json = queryString(req.url);
  105. usergetmysql(req, res, "findMail", json['un']);
  106. });
  107. /* 找寻重复学号 */
  108. router.route('/findSid').all((req, res, next) => {
  109. var json = queryString(req.url);
  110. getmysql(req, res, "findSid", json['un']);
  111. });
  112. /* 新增班级 */
  113. router.route('/insertClass').all((req, res, next) => {
  114. var json = queryString(req.url);
  115. getmysql(req, res, "insertClass", json['name'], json['oid'], json['uid']);
  116. });
  117. /* 查询班级 */
  118. router.route('/selectClass').all((req, res, next) => {
  119. var json = queryString(req.url);
  120. getmysql(req, res, "selectClass", json['cu'], json['oid'], json['cn'], json['page'], 10);
  121. });
  122. /* 删除班级 */
  123. router.route('/deleteClass').all((req, res, next) => {
  124. var json = queryString(req.url);
  125. getmysql(req, res, "deleteClass", json['id']);
  126. });
  127. /* 查询学校 */
  128. router.route('/selectOrg').all((req, res, next) => {
  129. var json = queryString(req.url);
  130. getmysql(req, res, "selectOrg");
  131. });
  132. /* 新增学生 */
  133. router.route('/insertStudent').all((req, res, next) => {
  134. var json = queryString(req.url);
  135. json['userpassword'] = bcrypt.hashSync(json['userpassword'], bcrypt.genSaltSync(10))
  136. getmysql(req, res, "insertStudent", json['ph'], json['username'], json['userpassword'], json['type'], json['oid'], json['tid'], json['cid']);
  137. });
  138. // /* 新增学生 */
  139. // router.route('/iStudent').all((req, res, next) => {
  140. // var json = queryString(req.url);
  141. // json['userpassword'] = bcrypt.hashSync(json['userpassword'], bcrypt.genSaltSync(10))
  142. // getmysql(req, res, "insertStudent", json['ph'], json['username'], json['userpassword'], json['type'], json['oid'], json['tid'], json['cid']);
  143. // });
  144. /* 查询学生 */
  145. router.route('/selectStudent').all((req, res, next) => {
  146. var json = queryString(req.url);
  147. getmysql(req, res, "selectStudent", json['oid'], json['cu'], json['cn'], json['page'], 8);
  148. });
  149. /* 查询项目 */
  150. router.route('/selectStudentAdd').all((req, res, next) => {
  151. var json = queryString(req.url);
  152. getmysql(req, res, "selectStudentAdd", json['oid'], json['cu'], json['cn']);
  153. });
  154. /* 查询老师 */
  155. router.route('/selectTeacherAdd').all((req, res, next) => {
  156. var json = queryString(req.url);
  157. getmysql(req, res, "selectTeacherAdd", json['oid'], json['cu'], json['cn']);
  158. });
  159. /* 查询班级是否有重复 */
  160. router.route('/selectC').all((req, res, next) => {
  161. var json = queryString(req.url);
  162. getmysql(req, res, "selectC", json['className']);
  163. });
  164. /* 查询学校是否有重复 */
  165. router.route('/selectS').all((req, res, next) => {
  166. var json = queryString(req.url);
  167. getmysql(req, res, "selectS", json['schoolName']);
  168. });
  169. /* 修改个人信息 */
  170. router.route('/updateUser').all((req, res, next) => {
  171. postmysql(req, res, "updateUser");
  172. });
  173. //查询老师的信息
  174. router.route('/getUser').all((req, res, next) => {
  175. var json = queryString(req.url);
  176. getmysql(req, res, "selectUserDeail", json['uid']);
  177. });
  178. router.route('/selectUser').all((req, res, next) => {
  179. var json = queryString(req.url);
  180. getmysql(req, res, "selectUser", json['userid']);
  181. });
  182. //查询教师端消息
  183. router.route('/getNewsTeacher').all((req, res, next) => {
  184. var json = queryString(req.url);
  185. getmysql(req, res, "selectNew", json['uid'], json['page'], 10);
  186. });
  187. //查询通知详情
  188. router.route('/selectNewDetail').all((req, res, next) => {
  189. var json = queryString(req.url);
  190. getmysql(req, res, "selectNewDetail", json['nid']);
  191. });
  192. //查出分组分类
  193. router.route('/getGroup').all((req, res, next) => {
  194. getmysql(req, res, "selectGroupTeacher");
  195. });
  196. //查询这个老师底下的学生提交的作业
  197. router.route('/getWorks').all((req, res, next) => {
  198. var json = queryString(req.url);
  199. getmysql(req, res, "selectWorks", json['cn'], json['cid'], json['page'], 10);
  200. });
  201. //查询项目
  202. router.route('/getProject').all((req, res, next) => {
  203. var json = queryString(req.url);
  204. getmysql(req, res, "selectProject", json['type'], json['uid'], json['oid'], json['cn'], json['page'], 10);
  205. });
  206. //查询项目成员
  207. router.route('/selectProjectStudent').all((req, res, next) => {
  208. var json = queryString(req.url);
  209. getmysql(req, res, "select_student", json['cn'], json['oid'], json['uid']);
  210. });
  211. //新增课程
  212. router.route('/addWork').all((req, res, next) => {
  213. postmysql(req, res, "insert_teacher_work");
  214. });
  215. //上传文件
  216. router.route('/addCourseWorks').all((req, res, next) => {
  217. postmysql(req, res, "addCourseWorks");
  218. });
  219. //上传文件
  220. router.route('/addCourseWorks2').all((req, res, next) => {
  221. var json = queryString(req.url);
  222. getmysql(req, res, "addCourseWorks", json['uid'], json['cid'], json['stage'], json['task'], json['tool'], json['content'], json['type']);
  223. });
  224. //查询作业详情
  225. router.route('/selectWorksDetail2').all((req, res, next) => {
  226. var json = queryString(req.url);
  227. getmysql(req, res, "selectWorksDetail2", json['uid'], json['cid'], json['stage'], json['task']);
  228. });
  229. //学习中心教师查询作业
  230. router.route('/selectSWorks').all((req, res, next) => {
  231. var json = queryString(req.url);
  232. getmysql(req, res, "selectSWorks", json['cid'], json['s'], json['t']);
  233. });
  234. //学习中心学生查询作业
  235. router.route('/selectStudentWorks').all((req, res, next) => {
  236. var json = queryString(req.url);
  237. getmysql(req, res, "selectStudentWorks", json['uid'], json['cid'], json['s'], json['t']);
  238. });
  239. //学习中心查询学生
  240. router.route('/selectWorksStudent').all((req, res, next) => {
  241. var json = queryString(req.url);
  242. getmysql(req, res, "selectWorksStudent", json['oid'], json['cid']);
  243. });
  244. /* 查询学生 */
  245. router.route('/selectStudent2').all((req, res, next) => {
  246. var json = queryString(req.url);
  247. getmysql(req, res, "selectStudent2", json['oid'], json['cu'], json['cn'], json['cid'], json['page'], 8);
  248. });
  249. /* 查询所有评价体系 */
  250. router.route('/selectAllEvaluation').all((req, res, next) => {
  251. var json = queryString(req.url);
  252. getmysql(req, res, "selectAllEvaluation", json['oid']);
  253. });
  254. router.route('/addWorkNew').all((req, res, next) => {
  255. // postmysql(req, res, "insert_teacher_work_new");
  256. if (req.body[0]) {
  257. // p = Object.values(req.body[0]);
  258. 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];
  259. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new");
  260. //執行存儲過程
  261. mysql.usselect(p, function(ret) {
  262. let course = req.body[0].courseType;
  263. let courseId = ret[0][0].courseId;
  264. let userid = req.body[0].uid;
  265. delCourseType(course, courseId, userid);
  266. res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
  267. // res.end(JSON.stringify(ret));
  268. });
  269. }
  270. });
  271. router.route('/addWorkNew2').all((req, res, next) => {
  272. if (req.body[0]) {
  273. 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];
  274. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new2"); //執行存儲過程
  275. mysql.usselect(p, function(ret) {
  276. let course = req.body[0].courseType;
  277. let courseId = ret[0][0].courseId;
  278. let userid = req.body[0].uid;
  279. delCourseType(course, courseId, userid);
  280. res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
  281. });
  282. }
  283. });
  284. router.route('/addWorkNew3').all((req, res, next) => {
  285. if (req.body[0]) {
  286. 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];
  287. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new3"); //執行存儲過程
  288. mysql.usselect(p, function(ret) {
  289. let course = req.body[0].courseType;
  290. let courseId = ret[0][0].courseId;
  291. let userid = req.body[0].uid;
  292. delCourseType(course, courseId, userid);
  293. res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
  294. });
  295. }
  296. });
  297. function delCourseType(course, courseId, userid) {
  298. let _courseId = courseId;
  299. var _userdata = [
  300. _courseId
  301. ];
  302. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_courseType");
  303. mysql.usselect(_userdata, function(ret) {
  304. console.log(ret);
  305. });
  306. setTimeout(() => {
  307. addCourseType(userid, course, _courseId)
  308. }, 1000);
  309. }
  310. function addCourseType(userid, course, _courseId) {
  311. var _uid = userid;
  312. var _courses = _courseId
  313. var _tid = JSON.parse(course)
  314. for (let i = 0; i < _tid.length; i++) {
  315. if (_tid[i] == '') {
  316. continue;
  317. }
  318. var _userdata = [
  319. _courses,
  320. _tid[i],
  321. _uid,
  322. ];
  323. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_courseType");
  324. mysql.usselect(_userdata, function(ret) {
  325. console.log(ret);
  326. });
  327. }
  328. }
  329. //修改课程
  330. // router.route('/updateWork').all((req, res, next) => {
  331. // postmysql(req, res, "update_teacher_work");
  332. // });
  333. router.route('/updateWorkNew').all((req, res, next) => {
  334. if (req.body[0]) {
  335. // p = Object.values(req.body[0]);
  336. 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];
  337. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new");
  338. //執行存儲過程
  339. mysql.usselect(p, function(ret) {
  340. let course = req.body[0].courseType;
  341. let courseId = req.body[0].cid;
  342. let userid = req.body[0].uid;
  343. delCourseType(course, courseId, userid);
  344. res.end(JSON.stringify({ success: 1 }));
  345. // res.end(JSON.stringify(ret));
  346. });
  347. }
  348. });
  349. //查询课程
  350. // router.route('/selectCourse').all((req, res, next) => {
  351. // var json = queryString(req.url);
  352. // getmysql(req, res, "select_course", json['type'], json['uid'], json['oid'], json['page'], 10);
  353. // });
  354. router.route('/updateWorkNew2').all((req, res, next) => {
  355. // if (req.body[0]) {
  356. // 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];
  357. // p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new2"); //執行存儲過程
  358. // mysql.usselect(p, function(ret) {
  359. // let course = req.body[0].courseType;
  360. // let courseId = req.body[0].cid;
  361. // let userid = req.body[0].uid;
  362. // delCourseType(course, courseId, userid);
  363. // res.end(JSON.stringify({ success: 1 }));
  364. // });
  365. // }
  366. if (req.body[0]) {
  367. 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];
  368. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new2"); //執行存儲過程
  369. mysql.usselect(p, function(ret) {
  370. let course = req.body[0].courseType;
  371. let courseId = req.body[0].cid;
  372. let userid = req.body[0].uid;
  373. delCourseType(course, courseId, userid);
  374. res.end(JSON.stringify({ success: 1 }));
  375. });
  376. }
  377. });
  378. router.route('/updateWorkNew3').all((req, res, next) => {
  379. if (req.body[0]) {
  380. 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];
  381. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new3"); //執行存儲過程
  382. mysql.usselect(p, function(ret) {
  383. let course = req.body[0].courseType;
  384. let courseId = req.body[0].cid;
  385. let userid = req.body[0].uid;
  386. delCourseType(course, courseId, userid);
  387. res.end(JSON.stringify({ success: 1 }));
  388. });
  389. }
  390. });
  391. function guid() {
  392. var _num,
  393. i,
  394. _guid = "";
  395. for (i = 0; i < 32; i++) {
  396. _guid += Math.floor(Math.random() * 16).toString(16); //随机0 - 16 的数字 转变为16进制的字符串
  397. _num = Math.floor((i - 7) / 4); //计算 (i-7)除4
  398. if (_num > -1 && _num < 4 && i == 7 + 4 * _num) {
  399. //会使guid中间加 "-" 形式为xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
  400. _guid += "-";
  401. }
  402. }
  403. return _guid;
  404. }
  405. router.route('/updateWorkNew4').all((req, res, next) => {
  406. if (req.body[0]) {
  407. let p = [req.body[0].cid];
  408. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
  409. mysql.usselect(p, function(ret) {
  410. let _unitIndex = parseInt(req.body[0].unitIndex);
  411. let _chapters = JSON.parse(req.body[0].chapters);
  412. let _unitJson = JSON.parse(ret[0][0].chapters)
  413. if ((_unitJson.length - 1) < _unitIndex) {
  414. let _i = _unitIndex - (_unitJson.length - 1)
  415. for (let i = 0; i < _i; i++) {
  416. _unitJson.push({
  417. dyName: "", //单元标题
  418. chapterInfo: [{
  419. isread: false,
  420. chapterid: guid(),
  421. title: "",
  422. courseName: "",
  423. taskJson: [{
  424. task: "",
  425. taskDetail: "",
  426. chapterData: [],
  427. toolText: "",
  428. toolChoose: [{
  429. tool: [],
  430. toolDetail: "",
  431. toolType: 0,
  432. askCount: 1,
  433. askTitle: "",
  434. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  435. }, ],
  436. isShowTools: false,
  437. askCount: 1,
  438. isFold: 0,
  439. askTitle: "",
  440. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  441. checkJson: [{ checkCount: [], checkPerent: [] }],
  442. homeworkList: [],
  443. }, ],
  444. itemCount: 1,
  445. fileList1: [],
  446. video: [],
  447. testData: [],
  448. pData: [],
  449. templateArray: [],
  450. }, ],
  451. })
  452. }
  453. _unitJson[_unitIndex] = _chapters[_unitIndex]
  454. } else {
  455. _unitJson[_unitIndex] = _chapters[_unitIndex]
  456. }
  457. console.log(_unitJson);
  458. let p2 = [req.body[0].cid, JSON.stringify(_unitJson).replaceAll(/%/g, "%25")];
  459. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new4"); //執行存儲過程
  460. mysql.usselect(p2, function(ret) {
  461. res.end(JSON.stringify({ success: 1 }));
  462. });
  463. // res.end(JSON.stringify({ success: 1 }));
  464. });
  465. }
  466. });
  467. router.route('/selectCourseNew').all((req, res, next) => {
  468. var json = queryString(req.url);
  469. 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'], 12);
  470. });
  471. //查询协同编辑课程
  472. router.route('/selectCourseTeam').all((req, res, next) => {
  473. var json = queryString(req.url);
  474. getmysql(req, res, "selectCourseTeam", json['uid'], json['oid']);
  475. });
  476. //查询学校
  477. router.route('/selectSchoolName').all((req, res, next) => {
  478. var json = queryString(req.url);
  479. getmysql(req, res, "selectOidName", json['oid']);
  480. });
  481. //删除学生
  482. router.route('/deleteStudent').all((req, res, next) => {
  483. postmysql(req, res, "delete_student");
  484. });
  485. //查询学校底下的班级
  486. router.route('/selectClassBySchool').all((req, res, next) => {
  487. var json = queryString(req.url);
  488. getmysql(req, res, "selectClassBySchool", json['oid']);
  489. });
  490. //学生注册接口
  491. router.route('/register_student').post(function(req, res, next) {
  492. //mode的处理
  493. if (req.body[0]) {
  494. // 0 用户名 1 用户密码 2用户身份 3 第三方id(可有可无)
  495. p = Object.values(req.body[0]); //获取用户密码
  496. //没有第三方id的处理
  497. // if (p.length < 4) {
  498. // p.push("")
  499. // }
  500. p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  501. //密码加密
  502. // bcrypt.hash(p[1], 10, function (err, hash) {
  503. // if (err) {
  504. // return next(err);
  505. // }
  506. // p[1] = hash;
  507. // });
  508. //参数拼接,注册
  509. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "register_student");
  510. //返回注册用户数据
  511. // mysql.usselect(p, function (ret) {
  512. // res.end(ret);
  513. // });
  514. mysql.usselect(p, function(ret) {
  515. res.end(JSON.stringify(ret));
  516. });
  517. }
  518. });
  519. //查询课程详情
  520. router.route('/selectCourseDetail').all((req, res, next) => {
  521. var json = queryString(req.url);
  522. getmysql(req, res, "selectCourseDetail", json['courseId']);
  523. });
  524. //跳转阶段时,如果有课程就查询1返回,如果没有就插入
  525. router.route('/addUserR').all((req, res, next) => {
  526. var json = queryString(req.url);
  527. getmysql(req, res, "insertUserR", json['uid'], json['cid']);
  528. });
  529. //新增学生端作业
  530. router.route('/addWorks').all((req, res, next) => {
  531. postmysql(req, res, "add_works");
  532. });
  533. //查询已提交作业
  534. router.route('/selectWork').all((req, res, next) => {
  535. var json = queryString(req.url);
  536. getmysql(req, res, "selectWork", json['cid'], json['stage'], json['task'], json['uid']);
  537. });
  538. //查询作业详情
  539. router.route('/selectWorksDetail').all((req, res, next) => {
  540. var json = queryString(req.url);
  541. getmysql(req, res, "selectWorksDetail", json['uid'], json['cid']);
  542. });
  543. //新增作业评分
  544. router.route('/updateWorks').all((req, res, next) => {
  545. var json = queryString(req.url);
  546. getmysql(req, res, "updateWorks", json['rate'], json['tuid'], json['id']);
  547. });
  548. //新增素材信息
  549. router.route('/addMtl').all((req, res, next) => {
  550. var json = queryString(req.url);
  551. getmysql(req, res, "add_mtl", json['cInfo'], json['t'], json['cBy']);
  552. });
  553. //根据类型查询素材信息
  554. router.route('/selectMtl').all((req, res, next) => {
  555. var json = queryString(req.url);
  556. getmysql(req, res, "selectMtl", json['t'], json['page'], 10);
  557. });
  558. //学习中心
  559. //新增学习资源信息
  560. router.route('/addStuMtl').all((req, res, next) => {
  561. var json = queryString(req.url);
  562. getmysql(req, res, "addStuMtl", json['cInfo'], json['t'], json['cBy']);
  563. });
  564. //根据类型查询学习资料信息
  565. router.route('/selectStuMtl').all((req, res, next) => {
  566. var json = queryString(req.url);
  567. getmysql(req, res, "selectStuMtl", json['t'], json['page'], 10);
  568. });
  569. //删除素材
  570. router.route('/deleteStuM').all((req, res, next) => {
  571. var json = queryString(req.url);
  572. getmysql(req, res, "deleteStuM", json['id']);
  573. });
  574. //查询学生信息
  575. router.route('/selectSDetail').all((req, res, next) => {
  576. var json = queryString(req.url);
  577. getmysql(req, res, "selectStudentDetail", json['uid']);
  578. });
  579. //查询个人课程
  580. router.route('/selectMyCourse').all((req, res, next) => {
  581. var json = queryString(req.url);
  582. getmysql(req, res, "selectMyCourse", json['uid']);
  583. });
  584. //查询个人课程groupby课程id
  585. router.route('/selectMyCourseBycid').all((req, res, next) => {
  586. var json = queryString(req.url);
  587. getmysql(req, res, "selectMyCourseBycid", json['uid']);
  588. });
  589. //查询所有课程
  590. router.route('/selectAllCourse').all((req, res, next) => {
  591. var json = queryString(req.url);
  592. getmysql(req, res, "selectAllCourse", json['oid'], json['page'], 10);
  593. });
  594. //根据班级查询所有课程
  595. router.route('/selectAllCourseByCid').all((req, res, next) => {
  596. var json = queryString(req.url);
  597. getmysql(req, res, "selectAllCourseByCid", json['oid'], json['cid'], json['page'], 10);
  598. });
  599. //根据分类查询所有课程
  600. router.route('/selectTypeCourse').all((req, res, next) => {
  601. var json = queryString(req.url);
  602. 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);
  603. });
  604. //删除素材
  605. router.route('/deleteM').all((req, res, next) => {
  606. var json = queryString(req.url);
  607. getmysql(req, res, "deleteM", json['id']);
  608. });
  609. //点击阶段时添加观看人数
  610. router.route('/updateVc').all((req, res, next) => {
  611. var json = queryString(req.url);
  612. getmysql(req, res, "updateVc", json['cid']);
  613. });
  614. //删除课程
  615. router.route('/deleteCourse').all((req, res, next) => {
  616. var json = queryString(req.url);
  617. getmysql(req, res, "deleteCourse", json['cid']);
  618. });
  619. //查看课程
  620. router.route('/select_course_detail').all((req, res, next) => {
  621. var json = queryString(req.url);
  622. getmysql(req, res, "select_course_detail", json['cid']);
  623. });
  624. //模糊查找课程
  625. // router.route('/searchCourse').all((req, res, next) => {
  626. // var json = queryString(req.url);
  627. // getmysql(req, res, "searchCourse", json['cu'], json['cn'], json['page'], 10);
  628. // });
  629. //创建调查问卷
  630. router.route('/addAsk').all((req, res, next) => {
  631. postmysql(req, res, "insert_ask");
  632. });
  633. //学生提交问卷
  634. router.route('/addAskList').all((req, res, next) => {
  635. postmysql(req, res, "insert_askList");
  636. });
  637. //根据课程id阶段id获取已提交的问卷
  638. router.route('/getAskListByCidStage').all((req, res, next) => {
  639. var json = queryString(req.url);
  640. getmysql(req, res, "getAskListByCidStage", json['cid'], json['stage'], json['task']);
  641. });
  642. //获取调查问卷
  643. router.route('/getAsk').all((req, res, next) => {
  644. var json = queryString(req.url);
  645. getmysql(req, res, "select_ask", json['uid'], json['page'], 10);
  646. });
  647. //问卷调查数据统计
  648. router.route('/getAskListByAskid').all((req, res, next) => {
  649. var json = queryString(req.url);
  650. getmysql(req, res, "select_askListByAskid", json['aid']);
  651. });
  652. //删除学生提交问卷
  653. router.route('/deleteAskList').all((req, res, next) => {
  654. postmysql(req, res, "update_askList_delete");
  655. });
  656. //根据id获取调查问卷
  657. router.route('/getAskList').all((req, res, next) => {
  658. var json = queryString(req.url);
  659. getmysql(req, res, "select_askList", json['uid'], json['page'], 10);
  660. });
  661. //查看便签列表
  662. router.route('/selectNote').all((req, res, next) => {
  663. var json = queryString(req.url);
  664. getmysql(req, res, "selectNote", json['uid']);
  665. });
  666. //新增便签列表
  667. router.route('/insertNote').all((req, res, next) => {
  668. var json = queryString(req.url);
  669. getmysql(req, res, "insertNote", json['uid'], json['c']);
  670. });
  671. //根据便签id修改便签内容
  672. router.route('/updateNote').all((req, res, next) => {
  673. var json = queryString(req.url);
  674. getmysql(req, res, "updateNote", json['nid'], json['c']);
  675. });
  676. //删除便签
  677. router.route('/deleteNote').all((req, res, next) => {
  678. var json = queryString(req.url);
  679. getmysql(req, res, "deleteNote", json['nid']);
  680. });
  681. //查询便签
  682. router.route('/selectNoteContent').all((req, res, next) => {
  683. var json = queryString(req.url);
  684. getmysql(req, res, "selectNoteContent", json['cn']);
  685. });
  686. //修改用户信息
  687. router.route('/updateUserByEdu').all((req, res, next) => {
  688. postmysql(req, res, "updateUserByEdu");
  689. });
  690. //教师端data修改pbl用户信息
  691. router.route('/updatePblMessage').all((req, res, next) => {
  692. postmysql(req, res, "updatePblMessage");
  693. });
  694. //查询用户信息
  695. router.route('/selectUser').all((req, res, next) => {
  696. var json = queryString(req.url);
  697. getmysql(req, res, "selectUser", json['userid']);
  698. });
  699. //查询分类及子分类
  700. router.route('/selectType').all((req, res, next) => {
  701. var json = queryString(req.url);
  702. getmysql(req, res, "selectType", );
  703. });
  704. //更加父id查询分类
  705. router.route('/selectTypeByPid').all((req, res, next) => {
  706. var json = queryString(req.url);
  707. getmysql(req, res, "selectTypeByPid", json['pid']);
  708. });
  709. //点击工具计数
  710. router.route('/insertToolsCount').all((req, res, next) => {
  711. var json = queryString(req.url);
  712. getmysql(req, res, "insertToolsCount", json['cid'], json['chid'], json['uid'], json['tid'], json['count']);
  713. });
  714. //修改工具次数
  715. router.route('/updateToolsCount').all((req, res, next) => {
  716. var json = queryString(req.url);
  717. getmysql(req, res, "updateToolsCount", json['cid'], json['chid'], json['uid'], json['tid'], json['count']);
  718. });
  719. //查询工具次数
  720. router.route('/selectToolsCount').all((req, res, next) => {
  721. var json = queryString(req.url);
  722. getmysql(req, res, "selectToolsCount", json['cid'], json['chid'], json['uid']);
  723. });
  724. //导出学生
  725. router.route('/selectUserBySchool').all((req, res, next) => {
  726. var json = queryString(req.url);
  727. getmysql(req, res, "selectUserBySchool", json['oid']);
  728. });
  729. //上传学生作业
  730. router.route('/insertSWork').all((req, res, next) => {
  731. var json = queryString(req.url);
  732. getmysql(req, res, "insertSWork", json['uid'], json['cid'], json['upload']);
  733. });
  734. //查询学生作业
  735. router.route('/selectSWork').all((req, res, next) => {
  736. var json = queryString(req.url);
  737. getmysql(req, res, "selectSWork", json['uid'], json['cid']);
  738. });
  739. //lsc
  740. //admin 查询学校
  741. router.route('/getSchoolAdmin').all((req, res, next) => {
  742. var json = queryString(req.url);
  743. getmysql(req, res, "select_school", json['page'], 10);
  744. });
  745. //admin 添加学校
  746. router.route('/addSchoolAdmin').all((req, res, next) => {
  747. postmysql(req, res, "add_school");
  748. });
  749. //admin 删除学校
  750. router.route('/deleteSchoolAdmin').all((req, res, next) => {
  751. postmysql(req, res, "delete_school");
  752. });
  753. //admin 查询班级
  754. router.route('/getClassAdmin').all((req, res, next) => {
  755. var json = queryString(req.url);
  756. getmysql(req, res, "select_classAdmin", json['cn'], json['page'], 10);
  757. });
  758. //admin 添加班级
  759. router.route('/addClassAdmin').all((req, res, next) => {
  760. postmysql(req, res, "add_classAdmin");
  761. });
  762. //admin 查询班级是否重复
  763. router.route('/getClassRepeat').all((req, res, next) => {
  764. var json = queryString(req.url);
  765. getmysql(req, res, "select_classRepeatAdmin", json['n'], json['oid']);
  766. });
  767. //admin 发布通知
  768. router.route('/addNews').all((req, res, next) => {
  769. postmysql(req, res, "add_news");
  770. });
  771. //admin 删除通知
  772. router.route('/deleteNews').all((req, res, next) => {
  773. postmysql(req, res, "delete_news");
  774. });
  775. //admin 添加banner
  776. router.route('/addBanner').all((req, res, next) => {
  777. postmysql(req, res, "add_banner");
  778. });
  779. //admin 添加banner
  780. router.route('/deleteBanner').all((req, res, next) => {
  781. postmysql(req, res, "delete_banner");
  782. });
  783. //admin 查询banner
  784. router.route('/getBanner').all((req, res, next) => {
  785. var json = queryString(req.url);
  786. getmysql(req, res, "select_banner");
  787. });
  788. //admin 查询课程getSearchCourse
  789. router.route('/getSearchCourse').all((req, res, next) => {
  790. var json = queryString(req.url);
  791. getmysql(req, res, "selectAll_courseSearch", json['t']);
  792. });
  793. //admin 查询所有课程专区
  794. router.route('/getZone').all((req, res, next) => {
  795. getmysql(req, res, "select_zone");
  796. });
  797. //admin 添加课程专区
  798. router.route('/addZone').all((req, res, next) => {
  799. postmysql(req, res, "insert_classZone");
  800. });
  801. //查询所有课程专区下的课程
  802. router.route('/getZoneClass').all((req, res, next) => {
  803. var json = queryString(req.url);
  804. getmysql(req, res, "select_zoneClass", json['bid'], json['oid'], json['page'], 10);
  805. });
  806. //查询所有课程专区下的课程
  807. router.route('/getZoneClassStudent').all((req, res, next) => {
  808. var json = queryString(req.url);
  809. getmysql(req, res, "select_zoneClass", json['bid'], json['oid'], json['page'], 20);
  810. });
  811. //admin 后台查看专区下课程的数量
  812. router.route('/getZoneClassNum').all((req, res, next) => {
  813. var json = queryString(req.url);
  814. getmysql(req, res, "select_zoneClassNum", json['bid']);
  815. });
  816. //admin 后台添加课程专区时查看课程是否在此专区重复
  817. router.route('/getZoneClassRepeat').all((req, res, next) => {
  818. var json = queryString(req.url);
  819. getmysql(req, res, "select_zoneClassRepeat", json['pid'], json['cid']);
  820. });
  821. //把课程添加进专区
  822. router.route('/addZoneCourse').all((req, res, next) => {
  823. postmysql(req, res, "insert_app");
  824. });
  825. //admin 删除课程专区底下的课程
  826. router.route('/deleteZoneCourse').all((req, res, next) => {
  827. postmysql(req, res, "delete_app");
  828. });
  829. //admin 删除班级
  830. router.route('/deleteZone').all((req, res, next) => {
  831. postmysql(req, res, "delete_zone");
  832. });
  833. //admin 后台专区上移下移
  834. router.route('/zoneRank').all((req, res, next) => {
  835. postmysql(req, res, "update_classRank");
  836. });
  837. //admin 添加模板文档
  838. router.route('/addTemplateAdmin').all((req, res, next) => {
  839. postmysql(req, res, "add_template");
  840. });
  841. //admin 添加模板文档
  842. router.route('/deleteTemplateAdmin').all((req, res, next) => {
  843. postmysql(req, res, "delete_template");
  844. });
  845. //admin 查询模板文档
  846. router.route('/getTemplateAdmin').all((req, res, next) => {
  847. var json = queryString(req.url);
  848. getmysql(req, res, "select_template", json['page'], 10);
  849. });
  850. //查询上传作业
  851. router.route('/getCourseWorks').all((req, res, next) => {
  852. var json = queryString(req.url); //cid 课程id,page 页数
  853. getmysql(req, res, "select_courseWorks", json['cid'], json['stage'], json['task'], json['page'], 10);
  854. });
  855. //查询报告数据
  856. router.route('/getCourseWorksReport').all((req, res, next) => {
  857. var json = queryString(req.url); //cid 课程id,page 页数
  858. getmysql(req, res, "getCourseWorksReport", json['cid']);
  859. });
  860. //admin 添加项目模板文档
  861. router.route('/addCourseTemplateAdmin').all((req, res, next) => {
  862. postmysql(req, res, "add_courseTemplate");
  863. });
  864. //admin 添加项目模板文档
  865. router.route('/deleteCourseTemplateAdmin').all((req, res, next) => {
  866. postmysql(req, res, "delete_courseTemplate");
  867. });
  868. //admin 查询项目模板文档
  869. router.route('/getCourseTemplateAdmin').all((req, res, next) => {
  870. var json = queryString(req.url);
  871. getmysql(req, res, "select_courseTemplate", json['page'], 10);
  872. });
  873. //teacher 查询项目模板
  874. router.route('/getCourseTemplateT').all((req, res, next) => {
  875. var json = queryString(req.url);
  876. getmysql(req, res, "select_courseTemplateT");
  877. });
  878. //admin 查询课程
  879. router.route('/getCourseAdmin').all((req, res, next) => {
  880. var json = queryString(req.url);
  881. getmysql(req, res, "select_courseAdmin", json['cn'], json['page'], 10);
  882. });
  883. //admin 查询模板文档
  884. router.route('/deleteCourseAdmin').all((req, res, next) => {
  885. postmysql(req, res, "delete_courseAdmin", );
  886. });
  887. //查询ppt在哪页
  888. router.route('/selectPptPage').all((req, res, next) => {
  889. var json = queryString(req.url);
  890. getmysql(req, res, "selectPptPage");
  891. });
  892. //修改ppt页码
  893. router.route('/updatePptPage').all((req, res, next) => {
  894. postmysql(req, res, "updatePptPage");
  895. });
  896. //teacher 查询模板
  897. router.route('/getTemplateT').all((req, res, next) => {
  898. var json = queryString(req.url);
  899. getmysql(req, res, "select_templateT");
  900. });
  901. //思维网格 创建房间
  902. router.route('/insertRoom').all((req, res, next) => {
  903. postmysql(req, res, "insertRoom");
  904. });
  905. //协同编辑 创建房间
  906. router.route('/insertRoomByFile').all((req, res, next) => {
  907. var json = queryString(req.url);
  908. getmysql(req, res, "insertRoomByFile", json["uid"], json["n"], json["d"]);
  909. });
  910. //思维网格 查询是否是重复房间号
  911. router.route('/checkRoomNum').all((req, res, next) => {
  912. var json = queryString(req.url);
  913. getmysql(req, res, "checkRoomNum", json['num']);
  914. });
  915. //思维网格 查询房间列表
  916. router.route('/selectRoomList').all((req, res, next) => {
  917. var json = queryString(req.url);
  918. getmysql(req, res, "selectRoomList", json['uid'], json['oid'], json['cid'], json['cu'], json['cn']);
  919. });
  920. //协同文档 查询房间列表
  921. router.route('/selectFileList').all((req, res, next) => {
  922. var json = queryString(req.url);
  923. getmysql(req, res, "selectFileList", json['uid'], json['oid'], json['cid'], json['cu'], json['cn']);
  924. });
  925. //协同编辑 查询是否是重复房间号
  926. router.route('/checkRoomNumByFile').all((req, res, next) => {
  927. var json = queryString(req.url);
  928. getmysql(req, res, "checkRoomNumByFile", json['num']);
  929. });
  930. //思维网格 根据房间号或者用户id查询房间信息
  931. router.route('/selectRoom').all((req, res, next) => {
  932. var json = queryString(req.url);
  933. getmysql(req, res, "selectRoom", json['uid']);
  934. });
  935. //思维网格 根据房间号或者用户id查询房间信息
  936. router.route('/getRoom').all((req, res, next) => {
  937. var json = queryString(req.url);
  938. getmysql(req, res, "select_room", json['fid']);
  939. });
  940. //协同编辑 根据房间号或者用户id查询房间信息
  941. router.route('/selectRoomByFile').all((req, res, next) => {
  942. var json = queryString(req.url);
  943. getmysql(req, res, "selectRoomByFile", json['uid']);
  944. });
  945. //思维网格 修改房间数据
  946. router.route('/updateRoomData').all((req, res, next) => {
  947. postmysql(req, res, "updateRoomData");
  948. });
  949. router.route('/updateFileData').all((req, res, next) => {
  950. var json = queryString(req.url);
  951. var json2 = json['mode'].split(',');
  952. getmysql(req, res, "updateFileData", json2[0], json2[1]);
  953. });
  954. router.route('/select_file').all((req, res, next) => {
  955. var json = queryString(req.url);
  956. getmysql(req, res, "select_file", json['fid']);
  957. });
  958. //思维网格 解散房间
  959. router.route('/dismiss').all((req, res, next) => {
  960. postmysql(req, res, "update_room");
  961. });
  962. //提交提问
  963. router.route('/addProblem').all((req, res, next) => {
  964. postmysql(req, res, "add_problem");
  965. //cid 课程id,chid 章节id,t 提问内容,uid 用户id
  966. });
  967. //查询提交的提问
  968. router.route('/getProblem').all((req, res, next) => {
  969. var json = queryString(req.url); //cid 课程id,page 页数
  970. getmysql(req, res, "select_problem", json['cid'], json['page'], 10);
  971. });
  972. //作业生成报告
  973. router.route('/getWorkData').all((req, res, next) => {
  974. var json = queryString(req.url); //cid 课程id,page 页数
  975. getmysql(req, res, "select_work_data", json['cid']);
  976. });
  977. //查询评价体系
  978. router.route('/getEvaluation').all((req, res, next) => {
  979. var json = queryString(req.url); //cid 课程id,page 页数
  980. getmysql(req, res, "select_evaluation", json['n'], json['page'], 10);
  981. });
  982. //添加评价体系
  983. router.route('/addEvaluation').all((req, res, next) => {
  984. postmysql(req, res, "add_evaluation");
  985. //uid 用户id t标题 c内容
  986. });
  987. //修改评价体系
  988. router.route('/updateEvaluation').all((req, res, next) => {
  989. postmysql(req, res, "update_evaluation");
  990. //c内容 t标题 id评价id
  991. });
  992. //删除评价体系
  993. router.route('/deleteEvaluation').all((req, res, next) => {
  994. postmysql(req, res, "delete_evaluation");
  995. // id评价id
  996. });
  997. router.route('/batchRegistrationMore').post(function(req, res, next) {
  998. let users = req.body[0];
  999. let arr = JSON.parse(req.body[0].arr);
  1000. //循环注册
  1001. // for (let j = 0; j < arr.length; j++) {
  1002. // if (arr[j].phone && arr[j].phone != "") {
  1003. // let _phonedata = [arr[j].phone];
  1004. // _phonedata.unshift(_mysqlLabor[0], _mysqlLabor[1], "findPhone");
  1005. // mysql.usselect(_phonedata, function(ret) {
  1006. // if (ret[0].length > 0) {
  1007. // res.end(JSON.stringify({ type: 1 }));
  1008. // return;
  1009. // }
  1010. // });
  1011. // }
  1012. // if (arr[j].mail && arr[j].mail != "") {
  1013. // let _maildata = [arr[j].mail];
  1014. // _maildata.unshift(_mysqluser[0], _mysqluser[1], "findMail");
  1015. // mysql.usselect(_maildata, function(ret) {
  1016. // if (ret[0].length > 0) {
  1017. // res.end(JSON.stringify({ type: 2 }));
  1018. // return;
  1019. // }
  1020. // });
  1021. // }
  1022. // if (arr[j].sId && arr[j].sId != "") {
  1023. // let _siddata = [arr[j].sId];
  1024. // _siddata.unshift(_mysqlLabor[0], _mysqlLabor[1], "findSid");
  1025. // mysql.usselect(_siddata, function(ret) {
  1026. // if (ret[0].length > 0) {
  1027. // res.end(JSON.stringify({ type: 3 }));
  1028. // return;
  1029. // }
  1030. // });
  1031. // }
  1032. // }
  1033. for (let i = 0; i < arr.length; i++) {
  1034. let _username = arr[i].name;
  1035. let _mail = arr[i].mail;
  1036. let _password = users.password || "123456";
  1037. let _alias = arr[i].name;
  1038. let _oid = users.oid;
  1039. let _ph = arr[i].phone ? arr[i].phone : '';
  1040. let _class = arr[i].class;
  1041. let _sId = arr[i].sId;
  1042. //加密密碼
  1043. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  1044. //生成激活碼
  1045. let _hashstr = new Date().getTime() + "";
  1046. let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
  1047. //用戶數據
  1048. let _userdata = [
  1049. _mail,
  1050. _password,
  1051. _alias,
  1052. "",
  1053. 1, //0老师 1学生
  1054. _username,
  1055. "",
  1056. generateAPIKey(_username),
  1057. _digest,
  1058. "",
  1059. _username,
  1060. _sId,
  1061. 2, //1老师 2学生
  1062. _oid,
  1063. _ph,
  1064. _class,
  1065. '',
  1066. "0",
  1067. ];
  1068. //參數拼接,註冊
  1069. _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister");
  1070. //用戶註冊處理
  1071. mysql.usselect(_userdata, function(ret) {
  1072. // let _pbluserdata = [
  1073. // ret[1][0].uid,
  1074. // _username,
  1075. // _sId,
  1076. // 2,
  1077. // _oid,
  1078. // _ph,
  1079. // _class,
  1080. // '',
  1081. // "0",
  1082. // ];
  1083. // _pbluserdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateUserByEdu");
  1084. // mysql.usselect(_pbluserdata, function(ret) {
  1085. res.end(JSON.stringify({ success: 1 }));
  1086. // });
  1087. });
  1088. }
  1089. });
  1090. router.route('/batchRegistration').post(function(req, res, next) {
  1091. var users = req.body[0];
  1092. //循环注册
  1093. var _username = users.alias;
  1094. var _mail = users.username;
  1095. var _password = users.password || "123456";
  1096. var _alias = users.alias;
  1097. var _oid = users.oid;
  1098. var _ph = users.ph;
  1099. var _class = users.cid;
  1100. var _sId = users.sid;
  1101. //加密密碼
  1102. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  1103. //生成激活碼
  1104. let _hashstr = new Date().getTime() + "";
  1105. let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
  1106. //用戶數據
  1107. var _userdata = [
  1108. _mail,
  1109. _password,
  1110. _alias,
  1111. "",
  1112. 1,
  1113. _username,
  1114. "",
  1115. generateAPIKey(_username),
  1116. _digest,
  1117. "",
  1118. _username,
  1119. _sId,
  1120. 2,
  1121. _oid,
  1122. _ph,
  1123. _class,
  1124. '',
  1125. "0",
  1126. ];
  1127. //參數拼接,註冊
  1128. _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister");
  1129. //用戶註冊處理
  1130. mysql.usselect(_userdata, function(ret) {
  1131. res.end(JSON.stringify({ uid: ret[1][0].uid, ph: _ph, oid: _oid, cid: _class, success: 1 }));
  1132. });
  1133. });
  1134. function generateAPIKey(username) {
  1135. let timeStamp = new Date().getTime();
  1136. let hashStr = timeStamp + username;
  1137. let digest = crypto.createHash('sha256').update(hashStr, 'utf8').digest('hex');
  1138. return digest;
  1139. }
  1140. queryString = function(url) {
  1141. var a = url.split("?");
  1142. var json = querystring.parse(a[1])
  1143. return json;
  1144. }
  1145. //post存儲過程處理
  1146. postmysql = function(req, res, functionname) {
  1147. //mode的處理
  1148. if (req.body[0]) {
  1149. p = Object.values(req.body[0]);
  1150. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  1151. //執行存儲過程
  1152. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); });
  1153. }
  1154. }
  1155. //get獲取數據庫信息
  1156. getmysql = function(req, res, functionname, ...p) {
  1157. p = p || [];
  1158. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  1159. //執行存儲過程
  1160. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); }); //
  1161. }
  1162. //post存储过程处理
  1163. userpostmysql = function(req, res, functionname) {
  1164. //mode的处理
  1165. if (req.body.mode) {
  1166. p = req.body.mode.split(",");
  1167. p.unshift(_mysqluser[0], _mysqluser[1], functionname);
  1168. //执行存储过程
  1169. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); });
  1170. }
  1171. }
  1172. //get获取数据库信息
  1173. usergetmysql = function(req, res, functionname, ...p) {
  1174. p = p || [];
  1175. p.unshift(_mysqluser[0], _mysqluser[1], functionname);
  1176. //执行存储过程
  1177. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); }); //
  1178. }
  1179. module.exports = router;