pbl.js 56 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610
  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('/selectorg2').all((req, res, next) => {
  134. var json = queryString(req.url);
  135. getmysql(req, res, "selectorg2");
  136. });
  137. /* 修改学校名称 */
  138. router.route('/updateSN').all((req, res, next) => {
  139. var json = queryString(req.url);
  140. getmysql(req, res, "updateSchoolName", json["oid"], json["n"]);
  141. });
  142. /* 新增学生 */
  143. router.route('/insertStudent').all((req, res, next) => {
  144. var json = queryString(req.url);
  145. json['userpassword'] = bcrypt.hashSync(json['userpassword'], bcrypt.genSaltSync(10))
  146. getmysql(req, res, "insertStudent", json['ph'], json['username'], json['userpassword'], json['type'], json['oid'], json['tid'], json['cid']);
  147. });
  148. // /* 新增学生 */
  149. // router.route('/iStudent').all((req, res, next) => {
  150. // var json = queryString(req.url);
  151. // json['userpassword'] = bcrypt.hashSync(json['userpassword'], bcrypt.genSaltSync(10))
  152. // getmysql(req, res, "insertStudent", json['ph'], json['username'], json['userpassword'], json['type'], json['oid'], json['tid'], json['cid']);
  153. // });
  154. /* 查询学生 */
  155. router.route('/selectStudent').all((req, res, next) => {
  156. var json = queryString(req.url);
  157. getmysql(req, res, "selectStudent", json['oid'], json['cu'], json['cn'], json['page'], 8);
  158. });
  159. /* ppt根据学校查询学生 */
  160. router.route('/selectStudentByScoolPPt').all((req, res, next) => {
  161. var json = queryString(req.url);
  162. getmysql(req, res, "selectStudentByScoolPPt", json['oid'], json['cid']);
  163. });
  164. /* 查询项目 */
  165. router.route('/selectStudentAdd').all((req, res, next) => {
  166. var json = queryString(req.url);
  167. getmysql(req, res, "selectStudentAdd", json['oid'], json['cu'], json['cn']);
  168. });
  169. /* 查询老师 */
  170. router.route('/selectTeacherAdd').all((req, res, next) => {
  171. var json = queryString(req.url);
  172. getmysql(req, res, "selectTeacherAdd", json['oid'], json['cu'], json['cn']);
  173. });
  174. /* 查询班级是否有重复 */
  175. router.route('/selectC').all((req, res, next) => {
  176. var json = queryString(req.url);
  177. getmysql(req, res, "selectC", json['className']);
  178. });
  179. /* 查询学校是否有重复 */
  180. router.route('/selectS').all((req, res, next) => {
  181. var json = queryString(req.url);
  182. getmysql(req, res, "selectS", json['schoolName']);
  183. });
  184. /* 修改个人信息 */
  185. router.route('/updateUser').all((req, res, next) => {
  186. postmysql(req, res, "updateUser");
  187. });
  188. //查询老师的信息
  189. router.route('/getUser').all((req, res, next) => {
  190. var json = queryString(req.url);
  191. getmysql(req, res, "selectUserDeail", json['uid']);
  192. });
  193. router.route('/selectUser').all((req, res, next) => {
  194. var json = queryString(req.url);
  195. getmysql(req, res, "selectUser", json['userid']);
  196. });
  197. //查询教师端消息
  198. router.route('/getNewsTeacher').all((req, res, next) => {
  199. var json = queryString(req.url);
  200. getmysql(req, res, "selectNew", json['uid'], json['page'], 10);
  201. });
  202. //查询通知详情
  203. router.route('/selectNewDetail').all((req, res, next) => {
  204. var json = queryString(req.url);
  205. getmysql(req, res, "selectNewDetail", json['nid']);
  206. });
  207. //查出分组分类
  208. router.route('/getGroup').all((req, res, next) => {
  209. getmysql(req, res, "selectGroupTeacher");
  210. });
  211. //查询这个老师底下的学生提交的作业
  212. router.route('/getWorks').all((req, res, next) => {
  213. var json = queryString(req.url);
  214. getmysql(req, res, "selectWorks", json['cn'], json['cid'], json['page'], 10);
  215. });
  216. //查询项目
  217. router.route('/getProject').all((req, res, next) => {
  218. var json = queryString(req.url);
  219. getmysql(req, res, "selectProject", json['type'], json['uid'], json['oid'], json['cn'], json['page'], 10);
  220. });
  221. //查询项目
  222. router.route('/getMyProject').all((req, res, next) => {
  223. var json = queryString(req.url);
  224. getmysql(req, res, "selectMyProject", json['uid'], json['page'], 10);
  225. });
  226. //查询项目成员
  227. router.route('/selectProjectStudent').all((req, res, next) => {
  228. var json = queryString(req.url);
  229. getmysql(req, res, "select_student", json['cn'], json['oid'], json['uid']);
  230. });
  231. //查询Banner列表
  232. router.route('/selectBannerList').all((req, res, next) => {
  233. var json = queryString(req.url);
  234. getmysql(req, res, "selectBannerList", json['page'], 10);
  235. });
  236. //查询Banner列表
  237. router.route('/selectAllBanner').all((req, res, next) => {
  238. var json = queryString(req.url);
  239. getmysql(req, res, "selectAllBanner", json["t"]);
  240. });
  241. //新增Banner
  242. router.route('/insertBannerList').all((req, res, next) => {
  243. postmysql(req, res, "insertBannerList");
  244. });
  245. //删除Banner
  246. router.route('/deleteBannerList').all((req, res, next) => {
  247. var json = queryString(req.url);
  248. getmysql(req, res, "deleteBannerList", json['id']);
  249. });
  250. //新增课程
  251. router.route('/addWork').all((req, res, next) => {
  252. postmysql(req, res, "insert_teacher_work");
  253. });
  254. //点赞评论
  255. router.route('/insertComment').all((req, res, next) => {
  256. postmysql(req, res, "insertComment");
  257. });
  258. //取消点赞
  259. router.route('/deleteComment').all((req, res, next) => {
  260. var json = queryString(req.url);
  261. getmysql(req, res, "deleteComment", json['wid'], json['lid']);
  262. });
  263. //上传文件
  264. router.route('/addCourseWorks').all((req, res, next) => {
  265. postmysql(req, res, "addCourseWorks");
  266. });
  267. //上传文件
  268. router.route('/addCourseWorks2').all((req, res, next) => {
  269. var json = queryString(req.url);
  270. getmysql(req, res, "addCourseWorks", json['uid'], json['cid'], json['stage'], json['task'], json['tool'], json['content'], json['type']);
  271. });
  272. //修改课程权限(学生是否能查看所有作业)
  273. router.route('/updateCourseSLook').all((req, res, next) => {
  274. var json = queryString(req.url);
  275. getmysql(req, res, "updateCourseSLook", json['sopen'], json['cid']);
  276. });
  277. //查询课程权限(学生是否能查看所有作业)
  278. router.route('/selectCourseSLook').all((req, res, next) => {
  279. var json = queryString(req.url);
  280. getmysql(req, res, "selectCourseSLook", json['cid']);
  281. });
  282. //查询作业详情
  283. router.route('/selectWorksDetail2').all((req, res, next) => {
  284. var json = queryString(req.url);
  285. getmysql(req, res, "selectWorksDetail2", json['uid'], json['cid'], json['stage'], json['task']);
  286. });
  287. //查询课程全部作业详情
  288. router.route('/selectWorksDetail3').all((req, res, next) => {
  289. var json = queryString(req.url);
  290. getmysql(req, res, "selectWorksDetail3", json['uid'], json['cid']);
  291. });
  292. //学习中心教师查询作业
  293. router.route('/selectSWorks').all((req, res, next) => {
  294. var json = queryString(req.url);
  295. getmysql(req, res, "selectSWorks", json['cid'], json['s'], json['t']);
  296. });
  297. //学习中心教师查询作业全部展示
  298. router.route('/selectSWorks2').all((req, res, next) => {
  299. var json = queryString(req.url);
  300. getmysql(req, res, "selectSWorks2", json['cid']);
  301. });
  302. //学习中心学生查询作业
  303. router.route('/selectStudentWorks').all((req, res, next) => {
  304. var json = queryString(req.url);
  305. getmysql(req, res, "selectStudentWorks", json['uid'], json['cid'], json['s'], json['t']);
  306. });
  307. //实时课堂作业评价
  308. router.route('/updateStudentWork').all((req, res, next) => {
  309. postmysql(req, res, "updateStudentWork");
  310. });
  311. //学习中心查询学生
  312. router.route('/selectWorksStudent').all((req, res, next) => {
  313. var json = queryString(req.url);
  314. getmysql(req, res, "selectWorksStudent", json['oid'], json['cid']);
  315. });
  316. /* 查询学生 */
  317. router.route('/selectStudent2').all((req, res, next) => {
  318. var json = queryString(req.url);
  319. getmysql(req, res, "selectStudent2", json['oid'], json['cu'], json['cn'], json['cid'], json['page'], 8);
  320. });
  321. /* 查询所有评价体系 */
  322. router.route('/selectAllEvaluation').all((req, res, next) => {
  323. var json = queryString(req.url);
  324. getmysql(req, res, "selectAllEvaluation", json['oid']);
  325. });
  326. router.route('/addWorkNew').all((req, res, next) => {
  327. // postmysql(req, res, "insert_teacher_work_new");
  328. if (req.body[0]) {
  329. // p = Object.values(req.body[0]);
  330. 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];
  331. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new");
  332. //執行存儲過程
  333. mysql.usselect(p, function(ret) {
  334. let course = req.body[0].courseType;
  335. let courseId = ret[0][0].courseId;
  336. let userid = req.body[0].uid;
  337. delCourseType(course, courseId, userid);
  338. res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
  339. // res.end(JSON.stringify(ret));
  340. });
  341. }
  342. });
  343. router.route('/addWorkNew2').all((req, res, next) => {
  344. if (req.body[0]) {
  345. 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];
  346. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new2"); //執行存儲過程
  347. mysql.usselect(p, function(ret) {
  348. let course = req.body[0].courseType;
  349. let courseId = ret[0][0].courseId;
  350. let userid = req.body[0].uid;
  351. delCourseType(course, courseId, userid);
  352. res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
  353. });
  354. }
  355. });
  356. router.route('/addWorkNew3').all((req, res, next) => {
  357. if (req.body[0]) {
  358. 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];
  359. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new3"); //執行存儲過程
  360. mysql.usselect(p, function(ret) {
  361. let course = req.body[0].courseType;
  362. let courseId = ret[0][0].courseId;
  363. let userid = req.body[0].uid;
  364. delCourseType(course, courseId, userid);
  365. res.end(JSON.stringify({ ordernumber: ret[0][0].ordernumber, courseId: ret[0][0].courseId, success: 1 }));
  366. });
  367. }
  368. });
  369. function delCourseType(course, courseId, userid) {
  370. let _courseId = courseId;
  371. var _userdata = [
  372. _courseId
  373. ];
  374. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_courseType");
  375. mysql.usselect(_userdata, function(ret) {
  376. console.log(ret);
  377. });
  378. setTimeout(() => {
  379. addCourseType(userid, course, _courseId)
  380. }, 1000);
  381. }
  382. function addCourseType(userid, course, _courseId) {
  383. var _uid = userid;
  384. var _courses = _courseId
  385. var _tid = JSON.parse(course)
  386. for (let i = 0; i < _tid.length; i++) {
  387. if (_tid[i] == '') {
  388. continue;
  389. }
  390. var _userdata = [
  391. _courses,
  392. _tid[i],
  393. _uid,
  394. ];
  395. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_courseType");
  396. mysql.usselect(_userdata, function(ret) {
  397. console.log(ret);
  398. });
  399. }
  400. }
  401. //修改课程
  402. // router.route('/updateWork').all((req, res, next) => {
  403. // postmysql(req, res, "update_teacher_work");
  404. // });
  405. router.route('/updateWorkNew').all((req, res, next) => {
  406. if (req.body[0]) {
  407. // p = Object.values(req.body[0]);
  408. 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];
  409. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new");
  410. //執行存儲過程
  411. mysql.usselect(p, function(ret) {
  412. let course = req.body[0].courseType;
  413. let courseId = req.body[0].cid;
  414. let userid = req.body[0].uid;
  415. delCourseType(course, courseId, userid);
  416. res.end(JSON.stringify({ success: 1 }));
  417. // res.end(JSON.stringify(ret));
  418. });
  419. }
  420. });
  421. //查询课程
  422. // router.route('/selectCourse').all((req, res, next) => {
  423. // var json = queryString(req.url);
  424. // getmysql(req, res, "select_course", json['type'], json['uid'], json['oid'], json['page'], 10);
  425. // });
  426. router.route('/updateWorkNew2').all((req, res, next) => {
  427. // if (req.body[0]) {
  428. // 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];
  429. // p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new2"); //執行存儲過程
  430. // mysql.usselect(p, function(ret) {
  431. // let course = req.body[0].courseType;
  432. // let courseId = req.body[0].cid;
  433. // let userid = req.body[0].uid;
  434. // delCourseType(course, courseId, userid);
  435. // res.end(JSON.stringify({ success: 1 }));
  436. // });
  437. // }
  438. if (req.body[0]) {
  439. 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];
  440. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new2"); //執行存儲過程
  441. mysql.usselect(p, function(ret) {
  442. let course = req.body[0].courseType;
  443. let courseId = req.body[0].cid;
  444. let userid = req.body[0].uid;
  445. delCourseType(course, courseId, userid);
  446. res.end(JSON.stringify({ success: 1 }));
  447. });
  448. }
  449. });
  450. router.route('/updateWorkNew3').all((req, res, next) => {
  451. if (req.body[0]) {
  452. 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];
  453. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new3"); //執行存儲過程
  454. mysql.usselect(p, function(ret) {
  455. let course = req.body[0].courseType;
  456. let courseId = req.body[0].cid;
  457. let userid = req.body[0].uid;
  458. delCourseType(course, courseId, userid);
  459. res.end(JSON.stringify({ success: 1 }));
  460. });
  461. }
  462. });
  463. function guid() {
  464. var _num,
  465. i,
  466. _guid = "";
  467. for (i = 0; i < 32; i++) {
  468. _guid += Math.floor(Math.random() * 16).toString(16); //随机0 - 16 的数字 转变为16进制的字符串
  469. _num = Math.floor((i - 7) / 4); //计算 (i-7)除4
  470. if (_num > -1 && _num < 4 && i == 7 + 4 * _num) {
  471. //会使guid中间加 "-" 形式为xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
  472. _guid += "-";
  473. }
  474. }
  475. return _guid;
  476. }
  477. router.route('/updateWorkNew4').all((req, res, next) => {
  478. if (req.body[0]) {
  479. let p = [req.body[0].cid];
  480. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
  481. mysql.usselect(p, function(ret) {
  482. let _unitIndex = parseInt(req.body[0].unitIndex);
  483. let _chapters = JSON.parse(req.body[0].chapters);
  484. let _unitJson = JSON.parse(ret[0][0].chapters)
  485. if ((_unitJson.length - 1) < _unitIndex) {
  486. let _i = _unitIndex - (_unitJson.length - 1)
  487. for (let i = 0; i < _i; i++) {
  488. _unitJson.push({
  489. dyName: "", //单元标题
  490. chapterInfo: [{
  491. isread: false,
  492. chapterid: guid(),
  493. title: "",
  494. courseName: "",
  495. taskJson: [{
  496. task: "",
  497. taskDetail: "",
  498. chapterData: [],
  499. toolText: "",
  500. toolChoose: [{
  501. tool: [],
  502. toolDetail: "",
  503. toolType: 0,
  504. askCount: 1,
  505. askTitle: "",
  506. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  507. }, ],
  508. isShowTools: false,
  509. askCount: 1,
  510. isFold: 0,
  511. askTitle: "",
  512. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  513. checkJson: [{ checkCount: [], checkPerent: [] }],
  514. homeworkList: [],
  515. }, ],
  516. itemCount: 1,
  517. fileList1: [],
  518. video: [],
  519. testData: [],
  520. pData: [],
  521. templateArray: [],
  522. }, ],
  523. })
  524. }
  525. _unitJson[_unitIndex] = _chapters[_unitIndex]
  526. } else {
  527. _unitJson[_unitIndex] = _chapters[_unitIndex]
  528. }
  529. console.log(_unitJson);
  530. let p2 = [req.body[0].cid, JSON.stringify(_unitJson).replaceAll(/%/g, "%25")];
  531. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new4"); //執行存儲過程
  532. mysql.usselect(p2, function(ret) {
  533. res.end(JSON.stringify({ success: 1 }));
  534. });
  535. // res.end(JSON.stringify({ success: 1 }));
  536. });
  537. }
  538. });
  539. //协同删除阶段
  540. router.route('/deleteWork').all((req, res, next) => {
  541. if (req.body[0]) {
  542. let p = [req.body[0].cid];
  543. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
  544. mysql.usselect(p, function(ret) {
  545. let _chapid = req.body[0].chapid;
  546. console.log(_chapid);
  547. let _chapters = JSON.parse(req.body[0].chapters);
  548. let _unitJson = JSON.parse(ret[0][0].chapters)
  549. let _unitJson2 = []
  550. for (var i = 0; i < _unitJson.length; i++) {
  551. if (_unitJson[i].chapterInfo[0].chapterid != _chapid) {
  552. // console.log(1);
  553. // _unitJson.splice(i, -1)
  554. _unitJson2.push(_unitJson[i])
  555. // break;
  556. }
  557. }
  558. console.log(_unitJson2);
  559. let p2 = [req.body[0].cid, JSON.stringify(_unitJson2).replaceAll(/%/g, "%25")];
  560. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new4"); //執行存儲過程
  561. mysql.usselect(p2, function(ret) {
  562. res.end(JSON.stringify({ success: 1 }));
  563. });
  564. // res.end(JSON.stringify({ success: 1 }));
  565. });
  566. }
  567. });
  568. //协同恢复删除的阶段
  569. router.route('/restoreWork').all((req, res, next) => {
  570. if (req.body[0]) {
  571. let p = [req.body[0].cid];
  572. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
  573. mysql.usselect(p, function(ret) {
  574. let _chapid = req.body[0].chapid;
  575. console.log(_chapid);
  576. let _chapters = JSON.parse(req.body[0].chapters);
  577. let _unitJson = JSON.parse(ret[0][0].chapters)
  578. let _unitJson2 = []
  579. let chpaindex;
  580. for (var i = 0; i < _chapters.length; i++) {
  581. if (_chapters[i].chapterInfo[0].chapterid == _chapid) {
  582. chpaindex = i
  583. }
  584. }
  585. for (var i = 0; i < _unitJson.length; i++) {
  586. if (_unitJson[i].chapterInfo[0].chapterid != _chapid) {
  587. // console.log(1);
  588. // _unitJson.splice(i, -1)
  589. _unitJson2.push(_unitJson[i])
  590. // break;
  591. }
  592. }
  593. _unitJson2.splice(chpaindex, 0, _chapters[chpaindex])
  594. console.log(_unitJson2);
  595. let p2 = [req.body[0].cid, JSON.stringify(_unitJson2).replaceAll(/%/g, "%25")];
  596. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new4"); //執行存儲過程
  597. mysql.usselect(p2, function(ret) {
  598. res.end(JSON.stringify({ success: 1 }));
  599. });
  600. // res.end(JSON.stringify({ success: 1 }));
  601. });
  602. }
  603. });
  604. router.route('/selectCourseNew').all((req, res, next) => {
  605. var json = queryString(req.url);
  606. 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);
  607. });
  608. router.route('/selectCourseNew2').all((req, res, next) => {
  609. var json = queryString(req.url);
  610. 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);
  611. });
  612. //查询协同编辑课程
  613. router.route('/selectCourseTeam').all((req, res, next) => {
  614. var json = queryString(req.url);
  615. getmysql(req, res, "selectCourseTeam", json['uid'], json['oid']);
  616. });
  617. //查询学校
  618. router.route('/selectSchoolName').all((req, res, next) => {
  619. var json = queryString(req.url);
  620. getmysql(req, res, "selectOidName", json['page'], 10);
  621. });
  622. //查询学校
  623. router.route('/selectSchoolName2').all((req, res, next) => {
  624. var json = queryString(req.url);
  625. getmysql(req, res, "selectOidName2", json['oid']);
  626. });
  627. //新增批注
  628. router.route('/addPz').all((req, res, next) => {
  629. postmysql(req, res, "addPz");
  630. });
  631. //新增批注
  632. router.route('/addPz2').all((req, res, next) => {
  633. postmysql(req, res, "addPz2");
  634. });
  635. //查询批注列表
  636. router.route('/selectPzList').all((req, res, next) => {
  637. var json = queryString(req.url);
  638. getmysql(req, res, "selectPzList", json['cid'], json['s'], json['t']);
  639. });
  640. //删除学生
  641. router.route('/deleteStudent').all((req, res, next) => {
  642. postmysql(req, res, "delete_student");
  643. });
  644. //查询学校底下的班级
  645. router.route('/selectClassBySchool').all((req, res, next) => {
  646. var json = queryString(req.url);
  647. getmysql(req, res, "selectClassBySchool", json['oid']);
  648. });
  649. //学生注册接口
  650. router.route('/register_student').post(function(req, res, next) {
  651. //mode的处理
  652. if (req.body[0]) {
  653. // 0 用户名 1 用户密码 2用户身份 3 第三方id(可有可无)
  654. p = Object.values(req.body[0]); //获取用户密码
  655. //没有第三方id的处理
  656. // if (p.length < 4) {
  657. // p.push("")
  658. // }
  659. p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  660. //密码加密
  661. // bcrypt.hash(p[1], 10, function (err, hash) {
  662. // if (err) {
  663. // return next(err);
  664. // }
  665. // p[1] = hash;
  666. // });
  667. //参数拼接,注册
  668. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "register_student");
  669. //返回注册用户数据
  670. // mysql.usselect(p, function (ret) {
  671. // res.end(ret);
  672. // });
  673. mysql.usselect(p, function(ret) {
  674. res.end(JSON.stringify(ret));
  675. });
  676. }
  677. });
  678. //查询课程详情
  679. router.route('/selectCourseDetail').all((req, res, next) => {
  680. var json = queryString(req.url);
  681. getmysql(req, res, "selectCourseDetail", json['courseId']);
  682. });
  683. //跳转阶段时,如果有课程就查询1返回,如果没有就插入
  684. router.route('/addUserR').all((req, res, next) => {
  685. var json = queryString(req.url);
  686. getmysql(req, res, "insertUserR", json['uid'], json['cid']);
  687. });
  688. //新增学生端作业
  689. router.route('/addWorks').all((req, res, next) => {
  690. postmysql(req, res, "add_works");
  691. });
  692. //查询已提交作业
  693. router.route('/selectWork').all((req, res, next) => {
  694. var json = queryString(req.url);
  695. getmysql(req, res, "selectWork", json['cid'], json['stage'], json['task'], json['uid']);
  696. });
  697. //查询作业详情
  698. router.route('/selectWorksDetail').all((req, res, next) => {
  699. var json = queryString(req.url);
  700. getmysql(req, res, "selectWorksDetail", json['uid'], json['cid']);
  701. });
  702. //新增作业评分
  703. router.route('/updateWorks').all((req, res, next) => {
  704. var json = queryString(req.url);
  705. getmysql(req, res, "updateWorks", json['rate'], json['tuid'], json['id']);
  706. });
  707. //新增素材信息
  708. router.route('/addMtl').all((req, res, next) => {
  709. var json = queryString(req.url);
  710. getmysql(req, res, "add_mtl", json['cInfo'], json['t'], json['cBy']);
  711. });
  712. //根据类型查询素材信息
  713. router.route('/selectMtl').all((req, res, next) => {
  714. var json = queryString(req.url);
  715. getmysql(req, res, "selectMtl", json['t'], json['page'], 10);
  716. });
  717. //学习中心
  718. //新增学习资源信息
  719. router.route('/addStuMtl').all((req, res, next) => {
  720. var json = queryString(req.url);
  721. getmysql(req, res, "addStuMtl", json['cInfo'], json['t'], json['cBy']);
  722. });
  723. //根据类型查询学习资料信息
  724. router.route('/selectStuMtl').all((req, res, next) => {
  725. var json = queryString(req.url);
  726. getmysql(req, res, "selectStuMtl", json['t'], json['page'], 10);
  727. });
  728. //删除素材
  729. router.route('/deleteStuM').all((req, res, next) => {
  730. var json = queryString(req.url);
  731. getmysql(req, res, "deleteStuM", json['id']);
  732. });
  733. //查询学生信息
  734. router.route('/selectSDetail').all((req, res, next) => {
  735. var json = queryString(req.url);
  736. getmysql(req, res, "selectStudentDetail", json['uid']);
  737. });
  738. //查询个人课程
  739. router.route('/selectMyCourse').all((req, res, next) => {
  740. var json = queryString(req.url);
  741. getmysql(req, res, "selectMyCourse", json['uid']);
  742. });
  743. //查询个人课程groupby课程id
  744. router.route('/selectMyCourseBycid').all((req, res, next) => {
  745. var json = queryString(req.url);
  746. getmysql(req, res, "selectMyCourseBycid", json['uid']);
  747. });
  748. //查询所有课程
  749. router.route('/selectAllCourse').all((req, res, next) => {
  750. var json = queryString(req.url);
  751. getmysql(req, res, "selectAllCourse", json['oid'], json['page'], 10);
  752. });
  753. //根据班级查询所有课程
  754. router.route('/selectAllCourseByCid').all((req, res, next) => {
  755. var json = queryString(req.url);
  756. getmysql(req, res, "selectAllCourseByCid", json['oid'], json['cid'], json['page'], 10);
  757. });
  758. //根据分类查询所有课程
  759. router.route('/selectTypeCourse').all((req, res, next) => {
  760. var json = queryString(req.url);
  761. 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);
  762. });
  763. //根据分类查询所有课程
  764. router.route('/selectTypeCourse2').all((req, res, next) => {
  765. var json = queryString(req.url);
  766. 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);
  767. });
  768. //删除素材
  769. router.route('/deleteM').all((req, res, next) => {
  770. var json = queryString(req.url);
  771. getmysql(req, res, "deleteM", json['id']);
  772. });
  773. //点击阶段时添加观看人数
  774. router.route('/updateVc').all((req, res, next) => {
  775. var json = queryString(req.url);
  776. getmysql(req, res, "updateVc", json['cid']);
  777. });
  778. //删除课程
  779. router.route('/deleteCourse').all((req, res, next) => {
  780. var json = queryString(req.url);
  781. getmysql(req, res, "deleteCourse", json['cid']);
  782. });
  783. //查看课程
  784. router.route('/select_course_detail').all((req, res, next) => {
  785. var json = queryString(req.url);
  786. getmysql(req, res, "select_course_detail", json['cid']);
  787. });
  788. //模糊查找课程
  789. // router.route('/searchCourse').all((req, res, next) => {
  790. // var json = queryString(req.url);
  791. // getmysql(req, res, "searchCourse", json['cu'], json['cn'], json['page'], 10);
  792. // });
  793. //创建调查问卷
  794. router.route('/addAsk').all((req, res, next) => {
  795. postmysql(req, res, "insert_ask");
  796. });
  797. //学生提交问卷
  798. router.route('/addAskList').all((req, res, next) => {
  799. postmysql(req, res, "insert_askList");
  800. });
  801. //根据课程id阶段id获取已提交的问卷
  802. router.route('/getAskListByCidStage').all((req, res, next) => {
  803. var json = queryString(req.url);
  804. getmysql(req, res, "getAskListByCidStage", json['cid'], json['stage'], json['task']);
  805. });
  806. //获取调查问卷
  807. router.route('/getAsk').all((req, res, next) => {
  808. var json = queryString(req.url);
  809. getmysql(req, res, "select_ask", json['uid'], json['page'], 10);
  810. });
  811. //问卷调查数据统计
  812. router.route('/getAskListByAskid').all((req, res, next) => {
  813. var json = queryString(req.url);
  814. getmysql(req, res, "select_askListByAskid", json['aid']);
  815. });
  816. //删除学生提交问卷
  817. router.route('/deleteAskList').all((req, res, next) => {
  818. postmysql(req, res, "update_askList_delete");
  819. });
  820. //根据id获取调查问卷
  821. router.route('/getAskList').all((req, res, next) => {
  822. var json = queryString(req.url);
  823. getmysql(req, res, "select_askList", json['uid'], json['page'], 10);
  824. });
  825. //查看便签列表
  826. router.route('/selectNote').all((req, res, next) => {
  827. var json = queryString(req.url);
  828. getmysql(req, res, "selectNote", json['uid']);
  829. });
  830. //新增便签列表
  831. router.route('/insertNote').all((req, res, next) => {
  832. var json = queryString(req.url);
  833. getmysql(req, res, "insertNote", json['uid'], json['c']);
  834. });
  835. //根据便签id修改便签内容
  836. router.route('/updateNote').all((req, res, next) => {
  837. var json = queryString(req.url);
  838. getmysql(req, res, "updateNote", json['nid'], json['c']);
  839. });
  840. //删除便签
  841. router.route('/deleteNote').all((req, res, next) => {
  842. var json = queryString(req.url);
  843. getmysql(req, res, "deleteNote", json['nid']);
  844. });
  845. //查询便签
  846. router.route('/selectNoteContent').all((req, res, next) => {
  847. var json = queryString(req.url);
  848. getmysql(req, res, "selectNoteContent", json['cn']);
  849. });
  850. //修改用户信息
  851. router.route('/updateUserByEdu').all((req, res, next) => {
  852. postmysql(req, res, "updateUserByEdu");
  853. });
  854. //教师端data修改pbl用户信息
  855. router.route('/updatePblMessage').all((req, res, next) => {
  856. postmysql2(req, res, "updatePblMessage");
  857. });
  858. router.route('/updatePblMessage2').all((req, res, next) => {
  859. postmysql(req, res, "updatePblMessage");
  860. });
  861. //查询用户信息
  862. router.route('/selectUser').all((req, res, next) => {
  863. var json = queryString(req.url);
  864. getmysql(req, res, "selectUser", json['userid']);
  865. });
  866. //查询分类及子分类
  867. router.route('/selectType').all((req, res, next) => {
  868. var json = queryString(req.url);
  869. getmysql(req, res, "selectType", );
  870. });
  871. //根据学校查询分类
  872. router.route('/selectPtype').all((req, res, next) => {
  873. var json = queryString(req.url);
  874. getmysql(req, res, "selectPtype", json["page"], 10);
  875. });
  876. //添加分类
  877. router.route('/addPtype').all((req, res, next) => {
  878. var json = queryString(req.url);
  879. getmysql(req, res, "addPtype", json["n"], json["uid"], json["oid"]);
  880. });
  881. //修改分类
  882. router.route('/updatePtype').all((req, res, next) => {
  883. var json = queryString(req.url);
  884. getmysql(req, res, "updatePtype", json["n"], json["tid"]);
  885. });
  886. //删除分类
  887. router.route('/deletePtype').all((req, res, next) => {
  888. var json = queryString(req.url);
  889. getmysql(req, res, "deletePtype", json["tid"]);
  890. });
  891. //查询子分类列表
  892. router.route('/selectStype').all((req, res, next) => {
  893. var json = queryString(req.url);
  894. getmysql(req, res, "selectStype", json["pid"], json["oid"], json["page"], 10);
  895. });
  896. //添加子分类
  897. router.route('/addStype').all((req, res, next) => {
  898. var json = queryString(req.url);
  899. getmysql(req, res, "addStype", json["pid"], json["n"], json["uid"], json["oid"]);
  900. });
  901. //根据学校id查询子分类
  902. router.route('/selectTypeByOid').all((req, res, next) => {
  903. var json = queryString(req.url);
  904. getmysql(req, res, "selectTypeByOid", json["oid"]);
  905. });
  906. //根据组织id查询子分类
  907. router.route('/selectTypeByOrg').all((req, res, next) => {
  908. var json = queryString(req.url);
  909. getmysql(req, res, "selectTypeByOrg", json["oid"]);
  910. });
  911. //更加父id查询分类
  912. router.route('/selectTypeByPid').all((req, res, next) => {
  913. var json = queryString(req.url);
  914. getmysql(req, res, "selectTypeByPid", json['pid']);
  915. });
  916. //点击工具计数
  917. router.route('/insertToolsCount').all((req, res, next) => {
  918. var json = queryString(req.url);
  919. getmysql(req, res, "insertToolsCount", json['cid'], json['chid'], json['uid'], json['tid'], json['count']);
  920. });
  921. //修改工具次数
  922. router.route('/updateToolsCount').all((req, res, next) => {
  923. var json = queryString(req.url);
  924. getmysql(req, res, "updateToolsCount", json['cid'], json['chid'], json['uid'], json['tid'], json['count']);
  925. });
  926. //查询工具次数
  927. router.route('/selectToolsCount').all((req, res, next) => {
  928. var json = queryString(req.url);
  929. getmysql(req, res, "selectToolsCount", json['cid'], json['chid'], json['uid']);
  930. });
  931. //导出学生
  932. router.route('/selectUserBySchool').all((req, res, next) => {
  933. var json = queryString(req.url);
  934. getmysql(req, res, "selectUserBySchool", json['oid']);
  935. });
  936. //上传学生作业
  937. router.route('/insertSWork').all((req, res, next) => {
  938. var json = queryString(req.url);
  939. getmysql(req, res, "insertSWork", json['uid'], json['cid'], json['p'], json['t'], json['upload']);
  940. });
  941. //查询学生作业
  942. router.route('/selectSWork').all((req, res, next) => {
  943. var json = queryString(req.url);
  944. getmysql(req, res, "selectSWork", json['uid'], json['cid'], json['p'], json['type']);
  945. });
  946. //查询赛事案例设计
  947. router.route('/selectCase').all((req, res, next) => {
  948. var json = queryString(req.url);
  949. getmysql(req, res, "selectCase", json['org']);
  950. });
  951. //lsc
  952. //admin 查询学校
  953. router.route('/getSchoolAdmin').all((req, res, next) => {
  954. var json = queryString(req.url);
  955. getmysql(req, res, "select_school", json['page'], 10);
  956. });
  957. //admin 添加学校
  958. router.route('/addSchoolAdmin').all((req, res, next) => {
  959. postmysql(req, res, "add_school");
  960. });
  961. //admin 删除学校
  962. router.route('/deleteSchoolAdmin').all((req, res, next) => {
  963. postmysql(req, res, "delete_school");
  964. });
  965. //admin 查询班级
  966. router.route('/getClassAdmin').all((req, res, next) => {
  967. var json = queryString(req.url);
  968. getmysql(req, res, "select_classAdmin", json['cn'], json['page'], 10);
  969. });
  970. //admin 添加班级
  971. router.route('/addClassAdmin').all((req, res, next) => {
  972. postmysql(req, res, "add_classAdmin");
  973. });
  974. //admin 查询班级是否重复
  975. router.route('/getClassRepeat').all((req, res, next) => {
  976. var json = queryString(req.url);
  977. getmysql(req, res, "select_classRepeatAdmin", json['n'], json['oid']);
  978. });
  979. //admin 发布通知
  980. router.route('/addNews').all((req, res, next) => {
  981. postmysql(req, res, "add_news");
  982. });
  983. //admin 删除通知
  984. router.route('/deleteNews').all((req, res, next) => {
  985. postmysql(req, res, "delete_news");
  986. });
  987. //admin 添加banner
  988. router.route('/addBanner').all((req, res, next) => {
  989. postmysql(req, res, "add_banner");
  990. });
  991. //admin 添加banner
  992. router.route('/deleteBanner').all((req, res, next) => {
  993. postmysql(req, res, "delete_banner");
  994. });
  995. //admin 查询banner
  996. router.route('/getBanner').all((req, res, next) => {
  997. var json = queryString(req.url);
  998. getmysql(req, res, "select_banner");
  999. });
  1000. //根据学校查询banner
  1001. router.route('/selectBannerByOid').all((req, res, next) => {
  1002. var json = queryString(req.url);
  1003. getmysql(req, res, "selectBannerByOid", json["oid"]);
  1004. });
  1005. //admin 查询课程getSearchCourse
  1006. router.route('/getSearchCourse').all((req, res, next) => {
  1007. var json = queryString(req.url);
  1008. getmysql(req, res, "selectAll_courseSearch", json['t']);
  1009. });
  1010. //根据学校查询课程
  1011. router.route('/getSearchCourseByoid').all((req, res, next) => {
  1012. var json = queryString(req.url);
  1013. getmysql(req, res, "selectAll_courseByOid", json['t'], json['oid']);
  1014. });
  1015. //admin 查询所有课程专区
  1016. router.route('/getZone').all((req, res, next) => {
  1017. getmysql(req, res, "select_zone");
  1018. });
  1019. //admin 添加课程专区
  1020. router.route('/addZone').all((req, res, next) => {
  1021. postmysql(req, res, "insert_classZone");
  1022. });
  1023. //查询所有课程专区下的课程
  1024. router.route('/getZoneClass').all((req, res, next) => {
  1025. var json = queryString(req.url);
  1026. getmysql(req, res, "select_zoneClass", json['bid'], json['oid'], json['page'], 10);
  1027. });
  1028. //查询所有课程专区下的课程
  1029. router.route('/getZoneClassStudent').all((req, res, next) => {
  1030. var json = queryString(req.url);
  1031. getmysql(req, res, "select_zoneClass", json['bid'], json['oid'], json['page'], 20);
  1032. });
  1033. //admin 后台查看专区下课程的数量
  1034. router.route('/getZoneClassNum').all((req, res, next) => {
  1035. var json = queryString(req.url);
  1036. getmysql(req, res, "select_zoneClassNum", json['bid']);
  1037. });
  1038. //admin 后台添加课程专区时查看课程是否在此专区重复
  1039. router.route('/getZoneClassRepeat').all((req, res, next) => {
  1040. var json = queryString(req.url);
  1041. getmysql(req, res, "select_zoneClassRepeat", json['pid'], json['cid']);
  1042. });
  1043. //把课程添加进专区
  1044. router.route('/addZoneCourse').all((req, res, next) => {
  1045. postmysql(req, res, "insert_app");
  1046. });
  1047. //admin 删除课程专区底下的课程
  1048. router.route('/deleteZoneCourse').all((req, res, next) => {
  1049. postmysql(req, res, "delete_app");
  1050. });
  1051. //admin 删除班级
  1052. router.route('/deleteZone').all((req, res, next) => {
  1053. postmysql(req, res, "delete_zone");
  1054. });
  1055. //admin 后台专区上移下移
  1056. router.route('/zoneRank').all((req, res, next) => {
  1057. postmysql(req, res, "update_classRank");
  1058. });
  1059. //admin 添加模板文档
  1060. router.route('/addTemplateAdmin').all((req, res, next) => {
  1061. postmysql(req, res, "add_template");
  1062. });
  1063. //admin 添加模板文档
  1064. router.route('/deleteTemplateAdmin').all((req, res, next) => {
  1065. postmysql(req, res, "delete_template");
  1066. });
  1067. //admin 查询模板文档
  1068. router.route('/getTemplateAdmin').all((req, res, next) => {
  1069. var json = queryString(req.url);
  1070. getmysql(req, res, "select_template", json['page'], 10);
  1071. });
  1072. //查询上传作业
  1073. router.route('/getCourseWorks').all((req, res, next) => {
  1074. var json = queryString(req.url); //cid 课程id,page 页数
  1075. getmysql(req, res, "select_courseWorks", json['cid'], json['stage'], json['task'], json['page'], 10);
  1076. });
  1077. //查询上传作业
  1078. router.route('/getCourseWorks2').all((req, res, next) => {
  1079. var json = queryString(req.url); //cid 课程id,page 页数
  1080. getmysql(req, res, "select_courseWorks2", json['cid'], json['uname'], json['stage'], json['task'], json['page'], 10);
  1081. });
  1082. //查询上传作业
  1083. router.route('/getCourseWorks3').all((req, res, next) => {
  1084. var json = queryString(req.url); //cid 课程id,page 页数
  1085. getmysql(req, res, "select_courseWorks3", json['cid'], json['uname'], json['stage'], json['task'], json['page'], 10);
  1086. });
  1087. //查询报告数据
  1088. router.route('/getCourseWorksReport').all((req, res, next) => {
  1089. var json = queryString(req.url); //cid 课程id,page 页数
  1090. getmysql(req, res, "getCourseWorksReport", json['cid']);
  1091. });
  1092. //admin 添加项目模板文档
  1093. router.route('/addCourseTemplateAdmin').all((req, res, next) => {
  1094. postmysql(req, res, "add_courseTemplate");
  1095. });
  1096. //admin 添加项目模板文档
  1097. router.route('/deleteCourseTemplateAdmin').all((req, res, next) => {
  1098. postmysql(req, res, "delete_courseTemplate");
  1099. });
  1100. //admin 查询项目模板文档
  1101. router.route('/getCourseTemplateAdmin').all((req, res, next) => {
  1102. var json = queryString(req.url);
  1103. getmysql(req, res, "select_courseTemplate", json['page'], 10);
  1104. });
  1105. //teacher 查询项目模板
  1106. router.route('/getCourseTemplateT').all((req, res, next) => {
  1107. var json = queryString(req.url);
  1108. getmysql(req, res, "select_courseTemplateT");
  1109. });
  1110. //admin 查询课程
  1111. router.route('/getCourseAdmin').all((req, res, next) => {
  1112. var json = queryString(req.url);
  1113. getmysql(req, res, "select_courseAdmin", json['cn'], json['page'], 10);
  1114. });
  1115. //admin 查询模板文档
  1116. router.route('/deleteCourseAdmin').all((req, res, next) => {
  1117. postmysql(req, res, "delete_courseAdmin");
  1118. });
  1119. //查询ppt在哪页
  1120. router.route('/selectPptPage').all((req, res, next) => {
  1121. var json = queryString(req.url);
  1122. getmysql(req, res, "selectPptPage", json['id']);
  1123. });
  1124. //修改ppt页码
  1125. router.route('/updatePptPage').all((req, res, next) => {
  1126. postmysql(req, res, "updatePptPage");
  1127. });
  1128. //修改ppt操作
  1129. router.route('/updatePPTHandle').all((req, res, next) => {
  1130. postmysql(req, res, "updatePPTHandle");
  1131. });
  1132. //查询实时课堂
  1133. router.route('/getRealTimeClass').all((req, res, next) => {
  1134. var json = queryString(req.url);
  1135. getmysql(req, res, "getRealTimeClass", json["cn"], json["uid"], json["page"], 10);
  1136. });
  1137. //查询实时课堂学生
  1138. router.route('/getRealTimeClassStu').all((req, res, next) => {
  1139. var json = queryString(req.url);
  1140. getmysql(req, res, "getRealTimeClassStu", json["oid"], json["cid"], json["page"], 10);
  1141. });
  1142. //查询实时课堂学生
  1143. router.route('/getRealTimeClassById').all((req, res, next) => {
  1144. var json = queryString(req.url);
  1145. getmysql(req, res, "getRealTimeClassById", json["id"]);
  1146. });
  1147. //teacher 查询模板
  1148. router.route('/getTemplateT').all((req, res, next) => {
  1149. var json = queryString(req.url);
  1150. getmysql(req, res, "select_templateT");
  1151. });
  1152. //思维网格 创建房间
  1153. router.route('/insertRoom').all((req, res, next) => {
  1154. postmysql(req, res, "insertRoom");
  1155. });
  1156. //协同编辑 创建房间
  1157. router.route('/insertRoomByFile').all((req, res, next) => {
  1158. //var json = queryString(req.url);
  1159. postmysql2(req, res, "insertRoomByFile");
  1160. //getmysql(req, res, "insertRoomByFile", json["uid"], json["n"], json["d"]);
  1161. });
  1162. //思维网格 查询是否是重复房间号
  1163. router.route('/checkRoomNum').all((req, res, next) => {
  1164. var json = queryString(req.url);
  1165. getmysql(req, res, "checkRoomNum", json['num']);
  1166. });
  1167. //思维网格 查询房间列表
  1168. router.route('/selectRoomList').all((req, res, next) => {
  1169. var json = queryString(req.url);
  1170. getmysql(req, res, "selectRoomList", json['uid'], json['oid'], json['cid'], json['cu'], json['cn']);
  1171. });
  1172. //查询pdf列表
  1173. router.route('/selectRTC').all((req, res, next) => {
  1174. var json = queryString(req.url);
  1175. getmysql(req, res, "selectRTC", json['uid'], json['cu'], json['cn']);
  1176. });
  1177. //协同文档 查询房间列表
  1178. router.route('/selectFileList').all((req, res, next) => {
  1179. var json = queryString(req.url);
  1180. getmysql(req, res, "selectFileList", json['uid'], json['oid'], json['cid'], json['cu'], json['cn']);
  1181. });
  1182. //协同编辑 查询是否是重复房间号
  1183. router.route('/checkRoomNumByFile').all((req, res, next) => {
  1184. var json = queryString(req.url);
  1185. getmysql(req, res, "checkRoomNumByFile", json['num']);
  1186. });
  1187. //思维网格 根据房间号或者用户id查询房间信息
  1188. router.route('/selectRoom').all((req, res, next) => {
  1189. var json = queryString(req.url);
  1190. getmysql(req, res, "selectRoom", json['uid']);
  1191. });
  1192. //思维网格 根据房间号或者用户id查询房间信息
  1193. router.route('/getRoom').all((req, res, next) => {
  1194. var json = queryString(req.url);
  1195. getmysql(req, res, "select_room", json['fid']);
  1196. });
  1197. //协同编辑 根据房间号或者用户id查询房间信息
  1198. router.route('/selectRoomByFile').all((req, res, next) => {
  1199. var json = queryString(req.url);
  1200. getmysql(req, res, "selectRoomByFile", json['uid']);
  1201. });
  1202. //思维网格 修改房间数据
  1203. router.route('/updateRoomData').all((req, res, next) => {
  1204. postmysql(req, res, "updateRoomData");
  1205. });
  1206. router.route('/updateFileData').all((req, res, next) => {
  1207. var json = queryString(req.url);
  1208. var json2 = json['mode'].split(',');
  1209. getmysql(req, res, "updateFileData", json2[0], json2[1]);
  1210. });
  1211. router.route('/select_file').all((req, res, next) => {
  1212. var json = queryString(req.url);
  1213. getmysql(req, res, "select_file", json['fid']);
  1214. });
  1215. //思维网格 解散房间
  1216. router.route('/dismiss').all((req, res, next) => {
  1217. postmysql(req, res, "update_room");
  1218. });
  1219. //提交提问
  1220. router.route('/addProblem').all((req, res, next) => {
  1221. postmysql(req, res, "add_problem");
  1222. //cid 课程id,chid 章节id,t 提问内容,uid 用户id
  1223. });
  1224. //查询提交的提问
  1225. router.route('/getProblem').all((req, res, next) => {
  1226. var json = queryString(req.url); //cid 课程id,page 页数
  1227. getmysql(req, res, "select_problem", json['cid'], json['page'], 10);
  1228. });
  1229. //获取用户基本信息
  1230. router.route('/getUserInfo').all((req, res, next) => {
  1231. var json = queryString(req.url);
  1232. getmysql(req, res, "getUserInfo", json['uid'], json['cid']);
  1233. });
  1234. //获取项目基本信息
  1235. router.route('/getCourseInfo').all((req, res, next) => {
  1236. var json = queryString(req.url);
  1237. getmysql(req, res, "getCourseInfo", json['cid']);
  1238. });
  1239. //作业生成报告
  1240. router.route('/getWorkData').all((req, res, next) => {
  1241. var json = queryString(req.url); //cid 课程id,page 页数
  1242. getmysql(req, res, "select_work_data", json['cid']);
  1243. });
  1244. //查询评价体系
  1245. router.route('/getEvaluation').all((req, res, next) => {
  1246. var json = queryString(req.url); //cid 课程id,page 页数
  1247. getmysql(req, res, "select_evaluation", json['oid'], json['n'], json['page'], 10);
  1248. });
  1249. //添加评价体系
  1250. router.route('/addEvaluation').all((req, res, next) => {
  1251. postmysql(req, res, "add_evaluation");
  1252. //uid 用户id t标题 c内容
  1253. });
  1254. //修改评价体系
  1255. router.route('/updateEvaluation').all((req, res, next) => {
  1256. postmysql(req, res, "update_evaluation");
  1257. //c内容 t标题 id评价id
  1258. });
  1259. //删除评价体系
  1260. router.route('/deleteEvaluation').all((req, res, next) => {
  1261. postmysql(req, res, "delete_evaluation");
  1262. // id评价id
  1263. });
  1264. router.route('/batchRegistrationMore').post(function(req, res, next) {
  1265. let users = req.body[0];
  1266. let arr = JSON.parse(req.body[0].arr);
  1267. //循环注册
  1268. // for (let j = 0; j < arr.length; j++) {
  1269. // if (arr[j].phone && arr[j].phone != "") {
  1270. // let _phonedata = [arr[j].phone];
  1271. // _phonedata.unshift(_mysqlLabor[0], _mysqlLabor[1], "findPhone");
  1272. // mysql.usselect(_phonedata, function(ret) {
  1273. // if (ret[0].length > 0) {
  1274. // res.end(JSON.stringify({ type: 1 }));
  1275. // return;
  1276. // }
  1277. // });
  1278. // }
  1279. // if (arr[j].mail && arr[j].mail != "") {
  1280. // let _maildata = [arr[j].mail];
  1281. // _maildata.unshift(_mysqluser[0], _mysqluser[1], "findMail");
  1282. // mysql.usselect(_maildata, function(ret) {
  1283. // if (ret[0].length > 0) {
  1284. // res.end(JSON.stringify({ type: 2 }));
  1285. // return;
  1286. // }
  1287. // });
  1288. // }
  1289. // if (arr[j].sId && arr[j].sId != "") {
  1290. // let _siddata = [arr[j].sId];
  1291. // _siddata.unshift(_mysqlLabor[0], _mysqlLabor[1], "findSid");
  1292. // mysql.usselect(_siddata, function(ret) {
  1293. // if (ret[0].length > 0) {
  1294. // res.end(JSON.stringify({ type: 3 }));
  1295. // return;
  1296. // }
  1297. // });
  1298. // }
  1299. // }
  1300. for (let i = 0; i < arr.length; i++) {
  1301. let _username = arr[i].name;
  1302. let _mail = arr[i].mail;
  1303. let _password = users.password || "123456";
  1304. let _alias = arr[i].name;
  1305. let _oid = users.oid;
  1306. let _ph = arr[i].phone ? arr[i].phone : '';
  1307. let _class = arr[i].class;
  1308. let _sId = arr[i].sId;
  1309. //加密密碼
  1310. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  1311. //生成激活碼
  1312. let _hashstr = new Date().getTime() + "";
  1313. let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
  1314. //用戶數據
  1315. let _userdata = [
  1316. _mail,
  1317. _password,
  1318. _alias,
  1319. "",
  1320. 1, //0老师 1学生
  1321. _username,
  1322. "",
  1323. generateAPIKey(_username),
  1324. _digest,
  1325. "",
  1326. _username,
  1327. _sId,
  1328. 2, //1老师 2学生
  1329. _oid,
  1330. _ph,
  1331. _class,
  1332. '',
  1333. "0",
  1334. ];
  1335. //參數拼接,註冊
  1336. _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister");
  1337. //用戶註冊處理
  1338. mysql.usselect(_userdata, function(ret) {
  1339. // let _pbluserdata = [
  1340. // ret[1][0].uid,
  1341. // _username,
  1342. // _sId,
  1343. // 2,
  1344. // _oid,
  1345. // _ph,
  1346. // _class,
  1347. // '',
  1348. // "0",
  1349. // ];
  1350. // _pbluserdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateUserByEdu");
  1351. // mysql.usselect(_pbluserdata, function(ret) {
  1352. res.end(JSON.stringify({ success: 1 }));
  1353. // });
  1354. });
  1355. }
  1356. });
  1357. router.route('/batchRegistration').post(function(req, res, next) {
  1358. var users = req.body[0];
  1359. //循环注册
  1360. var _username = users.alias;
  1361. var _mail = users.username;
  1362. var _password = users.password || "123456";
  1363. var _alias = users.alias;
  1364. var _oid = users.oid;
  1365. var _ph = users.ph;
  1366. var _class = users.cid;
  1367. var _sId = users.sid;
  1368. //加密密碼
  1369. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  1370. //生成激活碼
  1371. let _hashstr = new Date().getTime() + "";
  1372. let _digest = crypto.createHash('sha256').update(_hashstr, 'utf8').digest('hex');
  1373. //用戶數據
  1374. var _userdata = [
  1375. _mail,
  1376. _password,
  1377. _alias,
  1378. "",
  1379. 1,
  1380. _username,
  1381. "",
  1382. generateAPIKey(_username),
  1383. _digest,
  1384. "",
  1385. _username,
  1386. _sId,
  1387. 2,
  1388. _oid,
  1389. _ph,
  1390. _class,
  1391. '',
  1392. "0",
  1393. ];
  1394. //參數拼接,註冊
  1395. _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister");
  1396. //用戶註冊處理
  1397. mysql.usselect(_userdata, function(ret) {
  1398. res.end(JSON.stringify({ uid: ret[1][0].uid, ph: _ph, oid: _oid, cid: _class, success: 1 }));
  1399. });
  1400. });
  1401. function generateAPIKey(username) {
  1402. let timeStamp = new Date().getTime();
  1403. let hashStr = timeStamp + username;
  1404. let digest = crypto.createHash('sha256').update(hashStr, 'utf8').digest('hex');
  1405. return digest;
  1406. }
  1407. queryString = function(url) {
  1408. var a = url.split("?");
  1409. var json = querystring.parse(a[1])
  1410. return json;
  1411. }
  1412. //post存儲過程處理
  1413. postmysql = function(req, res, functionname) {
  1414. //mode的處理
  1415. if (req.body[0]) {
  1416. p = Object.values(req.body[0]);
  1417. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  1418. //執行存儲過程
  1419. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); });
  1420. }
  1421. }
  1422. //post存儲過程處理
  1423. postmysql2 = function(req, res, functionname) {
  1424. //mode的處理
  1425. if (req.body) {
  1426. p = Object.values(req.body)[0].split(",");
  1427. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  1428. //執行存儲過程
  1429. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); });
  1430. }
  1431. }
  1432. //get獲取數據庫信息
  1433. getmysql = function(req, res, functionname, ...p) {
  1434. p = p || [];
  1435. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  1436. //執行存儲過程
  1437. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); }); //
  1438. }
  1439. //post存储过程处理
  1440. userpostmysql = function(req, res, functionname) {
  1441. //mode的处理
  1442. if (req.body.mode) {
  1443. p = req.body.mode.split(",");
  1444. p.unshift(_mysqluser[0], _mysqluser[1], functionname);
  1445. //执行存储过程
  1446. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); });
  1447. }
  1448. }
  1449. //get获取数据库信息
  1450. usergetmysql = function(req, res, functionname, ...p) {
  1451. p = p || [];
  1452. p.unshift(_mysqluser[0], _mysqluser[1], functionname);
  1453. //执行存储过程
  1454. mysql.usselect(p, function(ret) { res.end(JSON.stringify(ret)); }); //
  1455. }
  1456. module.exports = router;