pbl.js 158 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246424742484249425042514252425342544255425642574258425942604261426242634264426542664267426842694270427142724273427442754276427742784279428042814282428342844285428642874288428942904291429242934294429542964297429842994300430143024303430443054306430743084309431043114312431343144315431643174318431943204321432243234324432543264327432843294330433143324333433443354336433743384339434043414342434343444345434643474348434943504351435243534354435543564357435843594360436143624363436443654366436743684369437043714372437343744375437643774378437943804381438243834384438543864387438843894390439143924393439443954396439743984399440044014402440344044405440644074408440944104411441244134414441544164417441844194420442144224423442444254426442744284429443044314432443344344435443644374438443944404441444244434444444544464447444844494450445144524453445444554456445744584459446044614462446344644465446644674468446944704471447244734474447544764477447844794480448144824483448444854486448744884489449044914492449344944495449644974498449945004501450245034504450545064507450845094510451145124513451445154516451745184519452045214522452345244525452645274528452945304531453245334534453545364537453845394540454145424543454445454546454745484549455045514552455345544555455645574558455945604561456245634564456545664567456845694570457145724573457445754576457745784579458045814582458345844585458645874588458945904591459245934594459545964597459845994600460146024603460446054606460746084609461046114612461346144615461646174618461946204621462246234624462546264627462846294630463146324633463446354636463746384639464046414642464346444645464646474648464946504651465246534654465546564657465846594660466146624663466446654666466746684669467046714672467346744675467646774678467946804681468246834684468546864687468846894690469146924693469446954696469746984699470047014702470347044705470647074708470947104711471247134714471547164717471847194720472147224723472447254726472747284729473047314732473347344735473647374738473947404741474247434744474547464747474847494750475147524753475447554756475747584759476047614762476347644765476647674768476947704771477247734774477547764777477847794780478147824783478447854786478747884789479047914792479347944795479647974798479948004801480248034804480548064807480848094810481148124813481448154816481748184819482048214822482348244825482648274828482948304831483248334834483548364837483848394840484148424843484448454846484748484849485048514852485348544855485648574858485948604861486248634864486548664867486848694870487148724873487448754876487748784879488048814882488348844885488648874888488948904891489248934894489548964897489848994900490149024903490449054906490749084909491049114912491349144915491649174918491949204921492249234924492549264927492849294930493149324933493449354936493749384939494049414942494349444945494649474948494949504951495249534954495549564957495849594960496149624963496449654966496749684969497049714972497349744975497649774978497949804981498249834984498549864987498849894990499149924993499449954996499749984999500050015002500350045005500650075008500950105011501250135014501550165017501850195020502150225023502450255026502750285029503050315032503350345035503650375038503950405041504250435044504550465047504850495050505150525053505450555056505750585059506050615062506350645065506650675068506950705071507250735074507550765077507850795080508150825083508450855086508750885089509050915092509350945095509650975098509951005101510251035104510551065107510851095110511151125113511451155116511751185119512051215122512351245125512651275128512951305131513251335134513551365137513851395140514151425143514451455146514751485149515051515152515351545155515651575158515951605161516251635164516551665167516851695170517151725173517451755176517751785179518051815182518351845185518651875188518951905191519251935194519551965197519851995200520152025203520452055206520752085209521052115212521352145215521652175218521952205221522252235224522552265227522852295230
  1. // ROUTES FOR OUR API
  2. // =============================================================================
  3. var express = require("express");
  4. var request = require("request");
  5. var bcrypt = require("bcryptjs");
  6. var router = express.Router(); // get an instance of the express Router
  7. const querystring = require("querystring");
  8. var mysql = require("./mysql");
  9. // const _mysqlLabor = ["123.58.32.151", "pbl"]; //edu數據庫信息
  10. // const _mysqluser = ["123.58.32.151", "cocorobouser"]; //用户数据库信息
  11. const _mysqlLabor = ["172.16.12.5", "pbl"]; //edu數據庫信息
  12. const _mysqluser = ["172.16.12.5", "cocorobouser"]; //edu數據庫信息
  13. var crypto = require("crypto");
  14. var https = require("https");
  15. //統壹處理區域
  16. router.use(async function(req, res, next) {
  17. await asynnext(req, res, next);
  18. //// make sure we go to the next routes and don't stop here
  19. //res.end("");
  20. });
  21. /**
  22. * @des 參數解釋同上
  23. */
  24. function asynnext(req, res, next) {
  25. //異步處理
  26. return new Promise(async(resolve, reject) => {
  27. next();
  28. //resolve(true);aa
  29. });
  30. }
  31. /*測試*/
  32. router.route("/a").all((req, res, next) => {
  33. var json = queryString(req.url);
  34. getmysql(req, res, "a", json["ph"], json["pa"]);
  35. });
  36. router.route("/b").all((req, res, next) => {
  37. var json = queryString(req.url);
  38. getmysql(req, res, "b", json["ph"], json["pa"]);
  39. });
  40. /* 注册接口 */
  41. router.route("/register").post(function(req, res, next) {
  42. //mode的处理
  43. if (req.body[0]) {
  44. // 0 用户名 1 用户密码 2用户身份 3 第三方id(可有可无)
  45. p = Object.values(req.body[0]); //获取用户密码
  46. //没有第三方id的处理
  47. // if (p.length < 4) {
  48. // p.push("")
  49. // }
  50. p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  51. //密码加密
  52. // bcrypt.hash(p[1], 10, function (err, hash) {
  53. // if (err) {
  54. // return next(err);
  55. // }
  56. // p[1] = hash;
  57. // });
  58. //参数拼接,注册
  59. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "register");
  60. //返回注册用户数据
  61. // mysql.usselect(p, function (ret) {
  62. // res.end(ret);
  63. // });
  64. mysql.usselect(p, function(ret) {
  65. res.end(JSON.stringify(ret));
  66. });
  67. }
  68. });
  69. /*登录接口*/
  70. router.route("/login").all((req, res, next) => {
  71. //mode的处理
  72. if (req.body[0]) {
  73. // 0 用户名 1 用户密码
  74. c = Object.values(req.body[0]); //获取用户密码
  75. p = [c[0]];
  76. // p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  77. var _password = [c[0]];
  78. _password.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectPassword");
  79. mysql.usselect(_password, function(ret) {
  80. var _ret = ret;
  81. var paJ = _ret[0][0].userpassword;
  82. bcrypt.compare(c[1], paJ, function(err, result) {
  83. // console.log(result)
  84. if (result) {
  85. //参数拼接,登录
  86. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectLogin");
  87. //执行存储过程
  88. mysql.usselect(p, function(ret) {
  89. res.end(JSON.stringify({ status: "1", ...ret }));
  90. });
  91. } else {
  92. res.end(JSON.stringify([{ status: "0" }]));
  93. }
  94. });
  95. });
  96. // console.log(isEqual)
  97. }
  98. });
  99. /*手机登录接口*/
  100. router.route("/phoneLogin").all((req, res, next) => {
  101. //mode的处理
  102. if (req.body[0]) {
  103. // 0 用户名 1 用户密码
  104. c = Object.values(req.body[0]); //获取用户密码
  105. p = [c[0]];
  106. // p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  107. var _password = [c[0]];
  108. _password.unshift(_mysqluser[0], _mysqluser[1], "selectPassword");
  109. mysql.usselect(_password, function(ret) {
  110. if (ret[0].length) {
  111. var _ret = ret;
  112. var paJ = _ret[0][0].password;
  113. let uid = _ret[0][0].userid;
  114. let duid = [uid];
  115. bcrypt.compare(c[1], paJ, function(err, result) {
  116. // console.log(result)
  117. if (result) {
  118. //参数拼接,登录
  119. duid.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectUser");
  120. //执行存储过程
  121. mysql.usselect(duid, function(ret) {
  122. res.end(JSON.stringify({ status: "1", ...ret }));
  123. });
  124. } else {
  125. res.end(JSON.stringify([{ status: "0" }]));
  126. }
  127. });
  128. } else {
  129. res.end(JSON.stringify([{ status: "0" }]));
  130. }
  131. });
  132. // console.log(isEqual)
  133. }
  134. });
  135. // 图片转base64
  136. router.route("/imgToBase64").all((req, res, next) => {
  137. var json = queryString(req.url);
  138. //mode的处理
  139. https.get(json["img"], function(res2) {
  140. var chunks = [];
  141. var size = 0;
  142. res2.on("data", function(chunk) {
  143. chunks.push(chunk);
  144. size += chunk.length; //累加缓冲数据的长度
  145. });
  146. res2.on("end", function(err) {
  147. var data = Buffer.concat(chunks, size);
  148. var base64Img = data.toString("base64");
  149. res.end(JSON.stringify([{ img: `data:image/png;base64,${base64Img}` }]));
  150. });
  151. });
  152. });
  153. router.route("/download").all(async(req, res, next) => {
  154. var json = queryString(req.url);
  155. // 查询文件名和下载链接
  156. const fileName = json["name"];
  157. const link = json["url"];
  158. // 发送下载请求
  159. request.get(link, (err, response) => {
  160. if (err) {
  161. res.status(500).end("Internal Server Error");
  162. return;
  163. }
  164. https.get(link, function(res2) {
  165. var chunks = [];
  166. var size = 0;
  167. res2.on("data", function(chunk) {
  168. chunks.push(chunk);
  169. size += chunk.length; //累加缓冲数据的长度
  170. });
  171. res2.on("end", function(err) {
  172. var data = Buffer.concat(chunks, size);
  173. var base64Img = data.toString("base64");
  174. res.end(JSON.stringify({ response, data }));
  175. });
  176. });
  177. });
  178. });
  179. /*登录接口*/
  180. router.route("/loginRace").all((req, res, next) => {
  181. //mode的处理
  182. if (req.body[0]) {
  183. // 0 用户名 1 用户密码
  184. c = Object.values(req.body[0]); //获取用户密码
  185. p = [c[0]];
  186. // p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  187. var _password = [c[0]];
  188. _password.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectPasswordRace");
  189. mysql.usselect(_password, function(ret) {
  190. var _ret = ret;
  191. var paJ = _ret[0][0].password;
  192. bcrypt.compare(c[1], paJ, function(err, result) {
  193. // console.log(result)
  194. if (result) {
  195. //参数拼接,登录
  196. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectLoginRace");
  197. //执行存储过程
  198. mysql.usselect(p, function(ret) {
  199. res.end(JSON.stringify({ status: "1", ...ret }));
  200. });
  201. } else {
  202. res.end(JSON.stringify([{ status: "0" }]));
  203. }
  204. });
  205. });
  206. // console.log(isEqual)
  207. }
  208. });
  209. /* 修改密码接口 */
  210. router.route("/updatePassword").post(function(req, res, next) {
  211. //mode的处理
  212. if (req.body[0]) {
  213. let p = [req.body[0].userid];
  214. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "getPassword"); //執行存儲過程
  215. mysql.usselect(p, function(ret) {
  216. var paJ = ret[0][0].password;
  217. var op = bcrypt.hashSync(req.body[0].opassword, bcrypt.genSaltSync(10));
  218. bcrypt.compare(req.body[0].opassword, paJ, function(err, result) {
  219. // console.log(result)
  220. if (result) {
  221. let p2 = [
  222. req.body[0].userid,
  223. bcrypt.hashSync(req.body[0].password, bcrypt.genSaltSync(10)),
  224. ];
  225. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updatePassword"); //執行存儲過程
  226. mysql.usselect(p2, function(ret) {
  227. res.end(JSON.stringify([{ success: 1 }]));
  228. });
  229. } else {
  230. res.end(JSON.stringify([{ success: 0 }]));
  231. }
  232. });
  233. });
  234. }
  235. });
  236. /* 赛事修改密码 */
  237. router.route("/updatePassword1").post(function(req, res, next) {
  238. //mode的处理
  239. if (req.body[0]) {
  240. let p = [req.body[0].userid];
  241. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "getPassword1"); //執行存儲過程
  242. mysql.usselect(p, function(ret) {
  243. var paJ = ret[0][0].password;
  244. var op = bcrypt.hashSync(req.body[0].opassword, bcrypt.genSaltSync(10));
  245. bcrypt.compare(req.body[0].opassword, paJ, function(err, result) {
  246. // console.log(result)
  247. if (result) {
  248. let p2 = [
  249. req.body[0].userid,
  250. bcrypt.hashSync(req.body[0].password, bcrypt.genSaltSync(10)),
  251. ];
  252. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updatePassword1"); //執行存儲過程
  253. mysql.usselect(p2, function(ret) {
  254. res.end(JSON.stringify([{ success: 1 }]));
  255. });
  256. } else {
  257. res.end(JSON.stringify([{ success: 0 }]));
  258. }
  259. });
  260. });
  261. }
  262. });
  263. /* 找寻重复手机号 */
  264. router.route("/findPhone").all((req, res, next) => {
  265. var json = queryString(req.url);
  266. getmysql(req, res, "findPhone", json["un"]);
  267. });
  268. /* 找寻是否有此账号 */
  269. router.route("/findUsername").all((req, res, next) => {
  270. var json = queryString(req.url);
  271. getmysql(req, res, "findUsername", json["un"]);
  272. });
  273. /* 找寻重复邮箱 */
  274. router.route("/findMail").all((req, res, next) => {
  275. var json = queryString(req.url);
  276. usergetmysql(req, res, "findMail", json["un"]);
  277. });
  278. /* 找寻重复学号 */
  279. router.route("/findSid").all((req, res, next) => {
  280. var json = queryString(req.url);
  281. getmysql(req, res, "findSid", json["un"]);
  282. });
  283. /* 新增班级 */
  284. router.route("/insertClass").all((req, res, next) => {
  285. var json = queryString(req.url);
  286. getmysql(req, res, "insertClass", json["name"], json["oid"], json["uid"]);
  287. });
  288. /* 新增教研室 */
  289. router.route("/insertTeacherOffice").all((req, res, next) => {
  290. var json = queryString(req.url);
  291. getmysql(req, res, "insertTeacherOffice", json["name"], json["oid"], json["uid"]);
  292. });
  293. /* 新增年级 */
  294. router.route("/insertGrade").all((req, res, next) => {
  295. var json = queryString(req.url);
  296. getmysql(req, res, "insertGrade", json["name"], json["oid"], json["uid"]);
  297. });
  298. /* 修改班级 */
  299. router.route("/updateClass").all((req, res, next) => {
  300. var json = queryString(req.url);
  301. getmysql(req, res, "updateClass", json["id"], json["n"], json["oid"]);
  302. });
  303. // 修改教研室
  304. router.route("/updateTeacherOffice").all((req, res, next) => {
  305. var json = queryString(req.url);
  306. getmysql(req, res, "updateTeacherOffice", json["id"], json["n"], json["oid"]);
  307. });
  308. /* 修改年级 */
  309. router.route("/updateGrade").all((req, res, next) => {
  310. var json = queryString(req.url);
  311. getmysql(req, res, "updateGrade", json["id"], json["n"], json["oid"]);
  312. });
  313. /* 查询班级 */
  314. router.route("/selectClass").all((req, res, next) => {
  315. var json = queryString(req.url);
  316. getmysql(req, res, "selectClass", json["cu"], json["oid"], json["cn"], json["page"], 10);
  317. });
  318. // 教研室查询
  319. router.route("/selectTeacherOffice").all((req, res, next) => {
  320. var json = queryString(req.url);
  321. getmysql(req, res, "selectTeacherOffice", json["cu"], json["oid"], json["cn"], json["page"], 10);
  322. });
  323. /* 查询班级 */
  324. router.route("/selectClass2").all((req, res, next) => {
  325. var json = queryString(req.url);
  326. getmysql(req, res, "selectClass2", json["cid"], json["oid"], json["cn"], json["page"], 10);
  327. });
  328. /* 查询年级 */
  329. router.route("/selectGrade").all((req, res, next) => {
  330. var json = queryString(req.url);
  331. getmysql(req, res, "selectGrade", json["cu"], json["oid"], json["cn"], json["page"], 10);
  332. });
  333. /* 删除班级 */
  334. router.route("/deleteClass").all((req, res, next) => {
  335. var json = queryString(req.url);
  336. getmysql(req, res, "deleteClass", json["id"]);
  337. });
  338. /* 删除年级 */
  339. router.route("/deleteGrade").all((req, res, next) => {
  340. var json = queryString(req.url);
  341. getmysql(req, res, "deleteGrade", json["id"]);
  342. });
  343. /* 查询学校 */
  344. router.route("/selectOrg").all((req, res, next) => {
  345. var json = queryString(req.url);
  346. getmysql(req, res, "selectOrg");
  347. });
  348. /* 查询组织 */
  349. router.route("/selectorg2").all((req, res, next) => {
  350. var json = queryString(req.url);
  351. getmysql(req, res, "selectorg2");
  352. });
  353. /* 修改学校名称 */
  354. router.route("/updateSN").all((req, res, next) => {
  355. var json = queryString(req.url);
  356. getmysql(req, res, "updateSchoolName", json["oid"], json["n"]);
  357. });
  358. /* 教师端修改学校名称 */
  359. router.route("/updateSchoolByOrg").all((req, res, next) => {
  360. var json = queryString(req.url);
  361. getmysql(req, res, "updateSchoolByOrg", json["n"], json["d"], json["id"]);
  362. });
  363. /* 教师端查询未联结学校 */
  364. router.route("/selectNoCSchool").all((req, res, next) => {
  365. var json = queryString(req.url);
  366. getmysql(req, res, "selectNoCSchool");
  367. });
  368. /* 教师端新增或修改联结学校 */
  369. router.route("/addNoSchool").all((req, res, next) => {
  370. var json = queryString(req.url);
  371. getmysql(req, res, "addNoSchool", json["id"], json["coid"]);
  372. });
  373. /* 新增学生 */
  374. router.route("/insertStudent").all((req, res, next) => {
  375. var json = queryString(req.url);
  376. json["userpassword"] = bcrypt.hashSync(
  377. json["userpassword"],
  378. bcrypt.genSaltSync(10)
  379. );
  380. getmysql(
  381. req,
  382. res,
  383. "insertStudent",
  384. json["ph"],
  385. json["username"],
  386. json["userpassword"],
  387. json["type"],
  388. json["oid"],
  389. json["tid"],
  390. json["cid"]
  391. );
  392. });
  393. // /* 新增学生 */
  394. // router.route('/iStudent').all((req, res, next) => {
  395. // var json = queryString(req.url);
  396. // json['userpassword'] = bcrypt.hashSync(json['userpassword'], bcrypt.genSaltSync(10))
  397. // getmysql(req, res, "insertStudent", json['ph'], json['username'], json['userpassword'], json['type'], json['oid'], json['tid'], json['cid']);
  398. // });
  399. /* 查询学生 */
  400. router.route("/selectStudent").all((req, res, next) => {
  401. var json = queryString(req.url);
  402. getmysql(
  403. req,
  404. res,
  405. "selectStudent",
  406. json["oid"],
  407. json["cu"],
  408. json["cn"],
  409. json["page"],
  410. 10
  411. );
  412. });
  413. /* ppt根据学校查询学生 */
  414. router.route("/selectStudentByScoolPPt").all((req, res, next) => {
  415. var json = queryString(req.url);
  416. getmysql(req, res, "selectStudentByScoolPPt", json["oid"], json["cid"]);
  417. });
  418. /* 查询学校底下的所有学生 */
  419. router.route("/selectOrgStu").all((req, res, next) => {
  420. var json = queryString(req.url);
  421. getmysql(req, res, "selectOrgStu", json["oid"]);
  422. });
  423. /* 查询学生 */
  424. router.route("/selectStudentAdd").all((req, res, next) => {
  425. var json = queryString(req.url);
  426. getmysql(req, res, "selectStudentAdd", json["oid"], json["cu"], json["cn"]);
  427. });
  428. /* 查询老师 */
  429. router.route("/selectTeacherAdd").all((req, res, next) => {
  430. var json = queryString(req.url);
  431. getmysql(req, res, "selectTeacherAdd", json["oid"], json["cu"], json["cn"]);
  432. });
  433. /* 查询老师 */
  434. router.route("/selectTeacherAddOrg").all((req, res, next) => {
  435. var json = queryString(req.url);
  436. getmysql(
  437. req,
  438. res,
  439. "selectTeacherAddOrg",
  440. json["oid"],
  441. json["cu"],
  442. json["cn"]
  443. );
  444. });
  445. /* 查询学生 */
  446. router.route("/selectStudentAddOrg").all((req, res, next) => {
  447. var json = queryString(req.url);
  448. getmysql(
  449. req,
  450. res,
  451. "selectStudentAddOrg",
  452. json["oid"],
  453. json["cu"],
  454. json["cn"]
  455. );
  456. });
  457. /* 查询全部用户 */
  458. router.route("/selectUserAddOrg").all((req, res, next) => {
  459. var json = queryString(req.url);
  460. getmysql(req, res, "selectUserAddOrg", json["oid"], json["cu"], json["cn"]);
  461. });
  462. /* 查询全部用户 */
  463. router.route("/selectUserAdd").all((req, res, next) => {
  464. var json = queryString(req.url);
  465. getmysql(req, res, "selectUserAdd", json["oid"], json["cu"], json["cn"]);
  466. });
  467. /* 查询全部用户 */
  468. router.route("/selectUserByOidS").all((req, res, next) => {
  469. var json = queryString(req.url);
  470. getmysql(
  471. req,
  472. res,
  473. "selectUserByOidS",
  474. json["oid"],
  475. json["org"],
  476. json["cu"],
  477. json["cn"]
  478. );
  479. });
  480. /* 查询全部用户 */
  481. router.route("/selectUserByOidS2").all((req, res, next) => {
  482. var json = queryString(req.url);
  483. getmysql(
  484. req,
  485. res,
  486. "selectUserByOidS2",
  487. json["oid"],
  488. json["org"],
  489. json["cu"],
  490. json["cn"],
  491. json["page"],
  492. json["pageSize"]
  493. );
  494. });
  495. /* 查询全部用户 */
  496. router.route("/selectUserByOidS2Studio").all((req, res, next) => {
  497. var json = queryString(req.url);
  498. getmysql(
  499. req,
  500. res,
  501. "selectUserByOidS2Studio",
  502. json["oid"],
  503. json["org"],
  504. json["cu"],
  505. json["cn"],
  506. json["page"],
  507. json["pageSize"]
  508. );
  509. });
  510. /* 查询班级是否有重复 */
  511. router.route("/selectC").all((req, res, next) => {
  512. var json = queryString(req.url);
  513. getmysql(req, res, "selectC", json["className"]);
  514. });
  515. /* 查询学校是否有重复 */
  516. router.route("/selectS").all((req, res, next) => {
  517. var json = queryString(req.url);
  518. getmysql(req, res, "selectS", json["schoolName"]);
  519. });
  520. /* 修改个人信息 */
  521. router.route("/updateUser").all((req, res, next) => {
  522. postmysql(req, res, "updateUser");
  523. });
  524. //查询老师的信息
  525. router.route("/getUser").all((req, res, next) => {
  526. var json = queryString(req.url);
  527. getmysql(req, res, "selectUserDeail", json["uid"]);
  528. });
  529. //查询老师的信息
  530. router.route("/getRaceUser").all((req, res, next) => {
  531. var json = queryString(req.url);
  532. getmysql(req, res, "getRaceUser", json["uid"]);
  533. });
  534. router.route("/selectUser").all((req, res, next) => {
  535. var json = queryString(req.url);
  536. getmysql(req, res, "selectUser", json["userid"]);
  537. });
  538. //查询教师端消息
  539. router.route("/getNewsTeacher").all((req, res, next) => {
  540. var json = queryString(req.url);
  541. getmysql(req, res, "selectNew", json["uid"], json["page"], 10);
  542. });
  543. //查询教师端消息
  544. router.route("/selectNotice").all((req, res, next) => {
  545. var json = queryString(req.url);
  546. getmysql(
  547. req,
  548. res,
  549. "selectNotice",
  550. json["uid"],
  551. json["oid"],
  552. json["org"],
  553. json["page"],
  554. 10
  555. );
  556. });
  557. //查询教师端消息
  558. router.route("/selectNotice2").all((req, res, next) => {
  559. var json = queryString(req.url);
  560. getmysql(req, res, "selectNotice2", json["uid"], json["oid"], json["org"]);
  561. });
  562. //查询教师端消息
  563. router.route("/addNotice").all((req, res, next) => {
  564. postmysql(req, res, "addNotice");
  565. });
  566. //查询教师端消息
  567. router.route("/deleteNotice").all((req, res, next) => {
  568. postmysql(req, res, "deleteNotice");
  569. });
  570. //查询通知详情
  571. router.route("/selectNewDetail").all((req, res, next) => {
  572. var json = queryString(req.url);
  573. getmysql(req, res, "selectNewDetail", json["nid"]);
  574. });
  575. //查出分组分类
  576. router.route("/getGroup").all((req, res, next) => {
  577. getmysql(req, res, "selectGroupTeacher");
  578. });
  579. //查询这个老师底下的学生提交的作业
  580. router.route("/getWorks").all((req, res, next) => {
  581. //已经不用
  582. var json = queryString(req.url);
  583. getmysql(req, res, "selectWorks", json["cn"], json["cid"], json["page"], 10);
  584. });
  585. //查询项目
  586. router.route("/getProject").all((req, res, next) => {
  587. var json = queryString(req.url);
  588. getmysql(
  589. req,
  590. res,
  591. "selectProject",
  592. json["type"],
  593. json["uid"],
  594. json["oid"],
  595. json["cn"],
  596. json["page"],
  597. 10
  598. );
  599. });
  600. //新评价查询项目
  601. router.route("/getProject1").all((req, res, next) => {
  602. //已经不用
  603. var json = queryString(req.url);
  604. getmysql(
  605. req,
  606. res,
  607. "selectProject1",
  608. json["uid"],
  609. json["cid"],
  610. json["eid"],
  611. json["cn"],
  612. json["page"],
  613. 10
  614. );
  615. });
  616. //查询项目
  617. router.route("/getMyProject").all((req, res, next) => {
  618. var json = queryString(req.url);
  619. getmysql(req, res, "selectMyProject", json["uid"], json["page"], 10);
  620. });
  621. //查询项目成员
  622. router.route("/selectProjectStudent").all((req, res, next) => {
  623. var json = queryString(req.url);
  624. getmysql(req, res, "select_student", json["cn"], json["oid"], json["uid"]);
  625. });
  626. //查询Banner列表
  627. router.route("/selectBannerList").all((req, res, next) => {
  628. var json = queryString(req.url);
  629. getmysql(req, res, "selectBannerList", json["page"], 10);
  630. });
  631. //查询Banner列表
  632. router.route("/selectAllBanner").all((req, res, next) => {
  633. var json = queryString(req.url);
  634. getmysql(req, res, "selectAllBanner", json["t"]);
  635. });
  636. //新增Banner
  637. router.route("/insertBannerList").all((req, res, next) => {
  638. postmysql(req, res, "insertBannerList");
  639. });
  640. //删除提交的作业
  641. router.route("/deleteCourseWork").all((req, res, next) => {
  642. postmysql(req, res, "deleteCourseWork");
  643. });
  644. //删除提交的作业
  645. router.route("/deleteCourseWorkS").all((req, res, next) => {
  646. postmysql(req, res, "deleteCourseWorkS");
  647. });
  648. //删除Banner
  649. router.route("/deleteBannerList").all((req, res, next) => {
  650. var json = queryString(req.url);
  651. getmysql(req, res, "deleteBannerList", json["id"]);
  652. });
  653. //新增课程
  654. router.route("/addWork").all((req, res, next) => {
  655. postmysql(req, res, "insert_teacher_work");
  656. });
  657. //点赞评论
  658. router.route("/insertComment").all((req, res, next) => {
  659. postmysql(req, res, "insertComment");
  660. });
  661. //点赞评论
  662. router.route("/getComment").all((req, res, next) => {
  663. postmysql(req, res, "getComment");
  664. });
  665. //取消点赞
  666. router.route("/deleteComment").all((req, res, next) => {
  667. var json = queryString(req.url);
  668. getmysql(req, res, "deleteComment", json["wid"], json["lid"]);
  669. });
  670. //删除评论
  671. router.route("/deleteComment2").all((req, res, next) => {
  672. var json = queryString(req.url);
  673. getmysql(req, res, "deleteComment2", json["id"]);
  674. });
  675. //上传批注图片
  676. router.route("/updateCourseWorks").all((req, res, next) => {
  677. postmysql(req, res, "updateCourseWorks");
  678. });
  679. //上传文件
  680. router.route("/addCourseWorks").all((req, res, next) => {
  681. postmysql(req, res, "addCourseWorks");
  682. });
  683. //上传文件
  684. router.route("/addCourseWorksS").all((req, res, next) => {
  685. postmysql(req, res, "addCourseWorksS");
  686. });
  687. //上传文件
  688. router.route("/addCourseWorksS2").all((req, res, next) => {
  689. postmysql(req, res, "addCourseWorksS2");
  690. });
  691. //修改作业名字
  692. router.route("/updateSCourseName").all((req, res, next) => {
  693. postmysql(req, res, "updateSCourseName");
  694. });
  695. //可上传多个文件
  696. router.route("/addCourseWorksR").all((req, res, next) => {
  697. postmysql(req, res, "addCourseWorksR");
  698. });
  699. //上传文件
  700. router.route("/addCourseWorksTeacher").all((req, res, next) => {
  701. postmysql(req, res, "addCourseWorksTeacher");
  702. });
  703. //上传文件
  704. router.route("/addCourseWorks2").all((req, res, next) => {
  705. var json = queryString(req.url);
  706. postmysql(
  707. req,
  708. res,
  709. "addCourseWorks",
  710. json["uid"],
  711. json["cid"],
  712. json["stage"],
  713. json["task"],
  714. json["tool"],
  715. json["content"],
  716. json["type"]
  717. );
  718. });
  719. //上传文件
  720. router.route("/addCourseWorks3").all((req, res, next) => {
  721. var json = queryString(req.url);
  722. getmysql(
  723. req,
  724. res,
  725. "addCourseWorks2",
  726. json["uid"],
  727. json["cid"],
  728. json["stage"],
  729. json["task"],
  730. json["tool"],
  731. json["content"],
  732. json["type"],
  733. json["atool"]
  734. );
  735. });
  736. //上传文件
  737. router.route("/addCourseWorks3-2").all((req, res, next) => {
  738. var json = queryString(req.url);
  739. postmysql(req, res, "addCourseWorks2");
  740. });
  741. //上传文件
  742. router.route("/addCourseWorks2Inter").all((req, res, next) => {
  743. var json = queryString(req.url);
  744. postmysql(req, res, "addCourseWorks2Inter");
  745. });
  746. //上传文件
  747. router.route("/addCourseWorks4").all((req, res, next) => {
  748. postmysql3(req, res, "addCourseWorks3");
  749. });
  750. //上传文件
  751. router.route("/addCourseWorks4-u").all((req, res, next) => {
  752. postmysql2(req, res, "addCourseWorks3");
  753. });
  754. //上传文件
  755. router.route("/addCourseWorks4E").all((req, res, next) => {
  756. postmysql3(req, res, "addCourseWorks3E");
  757. });
  758. //上传文件
  759. router.route("/addCourseWorks4s").all((req, res, next) => {
  760. postmysql3(req, res, "addCourseWorks4s");
  761. });
  762. //上传文件
  763. router.route("/addCourseWorks4s2").all((req, res, next) => {
  764. postmysql3(req, res, "addCourseWorks4s2");
  765. });
  766. //上传文件
  767. router.route("/addCourseWorks5").all((req, res, next) => {
  768. postmysql(req, res, "addCourseWorks3");
  769. });
  770. //上传批量文件
  771. router.route("/addCourseWorksPl").all((req, res, next) => {
  772. if (req.body[0]) {
  773. var p = Object.values(req.body[0]);
  774. let ateacher = p[0];
  775. let cid = p[1];
  776. let stage = p[2];
  777. let task = p[3];
  778. let tool = p[4];
  779. let files = JSON.parse(p[5]);
  780. for (let i = 0; i < files.length; i++) {
  781. var k = [
  782. files[i].username,
  783. cid,
  784. stage,
  785. task,
  786. tool,
  787. files[i].url,
  788. files[i].fileType,
  789. ateacher,
  790. "50",
  791. ];
  792. k.unshift(_mysqlLabor[0], _mysqlLabor[1], "addCourseWorksPl");
  793. //執行存儲過程
  794. mysql.usselect(k, function(ret) {
  795. if (i == files.length - 1) {
  796. res.end(JSON.stringify(ret));
  797. }
  798. });
  799. }
  800. }
  801. });
  802. //修改课程权限(学生是否能查看所有作业)
  803. router.route("/updateCourseSLook").all((req, res, next) => {
  804. var json = queryString(req.url);
  805. getmysql(req, res, "updateCourseSLook", json["sopen"], json["cid"]);
  806. });
  807. //修改跟随模式阶段-任务
  808. router.route("/updateCourseFollowC").all((req, res, next) => {
  809. postmysql(req, res, "updateCourseFollowC");
  810. });
  811. //修改跟随模式
  812. router.route("/updateCourseFollow").all((req, res, next) => {
  813. postmysql(req, res, "updateCourseFollow");
  814. });
  815. //选人回答
  816. router.route("/updateCoursePick").all((req, res, next) => {
  817. postmysql(req, res, "updateCoursePick");
  818. });
  819. //删除
  820. router.route("/deletePick").all((req, res, next) => {
  821. postmysql(req, res, "deletePick");
  822. });
  823. //修改阶段锁定状态
  824. router.route("/updateCourseLookOpen").all((req, res, next) => {
  825. postmysql(req, res, "updateCourseLookOpen");
  826. });
  827. //查看阶段锁定的状态
  828. router.route("/getCourseState").all((req, res, next) => {
  829. var json = queryString(req.url);
  830. getmysql(req, res, "getCourseState", json["cid"]);
  831. });
  832. //添加锁定状态
  833. router.route("/addCourseState").all((req, res, next) => {
  834. postmysql(req, res, "addCourseState");
  835. });
  836. //修改锁定状态
  837. router.route("/updateCourseSate").all((req, res, next) => {
  838. postmysql(req, res, "updateCourseSate");
  839. });
  840. //查询课程权限(学生是否能查看所有作业)
  841. router.route("/selectCourseSLook").all((req, res, next) => {
  842. var json = queryString(req.url);
  843. getmysql(req, res, "selectCourseSLook", json["cid"]);
  844. });
  845. //查询被挑的人
  846. router.route("/getPick").all((req, res, next) => {
  847. var json = queryString(req.url);
  848. getmysql(req, res, "getPick", json["cid"]);
  849. });
  850. //查询作业详情
  851. router.route("/selectWorksDetail2").all((req, res, next) => {
  852. var json = queryString(req.url);
  853. getmysql(
  854. req,
  855. res,
  856. "selectWorksDetail2",
  857. json["uid"],
  858. json["cid"],
  859. json["stage"],
  860. json["task"]
  861. );
  862. });
  863. //查询作业详情
  864. router.route("/selectWorksDetail2u").all((req, res, next) => {
  865. //var json = queryString(req.url);//, json['uid'], json['cid'], json['stage'], json['task'], json['tool'], json['type'], json['atool']
  866. postmysql2(req, res, "selectWorksDetail2u");
  867. });
  868. //查询课程全部作业详情
  869. router.route("/selectWorksDetail3").all((req, res, next) => {
  870. var json = queryString(req.url);
  871. getmysql(req, res, "selectWorksDetail3", json["uid"], json["cid"]);
  872. });
  873. //查询课程所有作业详情
  874. router.route("/selectAllWorksDetail").all((req, res, next) => {
  875. var json = queryString(req.url);
  876. getmysql(req, res, "selectAllWorksDetail", json["uid"], json["cid"]);
  877. });
  878. //查询多个课程全部作业详情
  879. router.route("/selectWorksDetailMore").all((req, res, next) => {
  880. var json = queryString(req.url);
  881. getmysql(req, res, "selectWorksDetailMore", json["uid"], json["cid"]);
  882. });
  883. //查询课程某个阶段某个任务下的评价
  884. router.route("/updateWorksEva").all((req, res, next) => {
  885. var json = queryString(req.url);
  886. getmysql(
  887. req,
  888. res,
  889. "updateWorksEva",
  890. json["cid"],
  891. json["s"],
  892. json["t"],
  893. json["uid"],
  894. json["rate"]
  895. );
  896. });
  897. //学习中心教师查询作业
  898. router.route("/selectSWorks").all((req, res, next) => {
  899. var json = queryString(req.url);
  900. getmysql(req, res, "selectSWorks", json["cid"], json["s"], json["t"]);
  901. });
  902. //学习中心教师查询作业全部展示
  903. router.route("/selectSWorks2").all((req, res, next) => {
  904. var json = queryString(req.url);
  905. getmysql(req, res, "selectSWorks2", json["cid"]);
  906. });
  907. //学习中心学生查询作业
  908. router.route("/selectStudentWorks").all((req, res, next) => {
  909. var json = queryString(req.url);
  910. getmysql(
  911. req,
  912. res,
  913. "selectStudentWorks",
  914. json["uid"],
  915. json["cid"],
  916. json["s"],
  917. json["t"]
  918. );
  919. });
  920. //实时课堂作业评价
  921. router.route("/updateStudentWork").all((req, res, next) => {
  922. postmysql(req, res, "updateStudentWork");
  923. });
  924. //学习中心查询学生
  925. router.route("/selectWorksStudent").all((req, res, next) => {
  926. var json = queryString(req.url);
  927. getmysql(req, res, "selectWorksStudent", json["oid"], json["cid"]);
  928. });
  929. //批量上传查询学生
  930. router.route("/selectSnameByCid").all((req, res, next) => {
  931. var json = queryString(req.url);
  932. getmysql(req, res, "selectSnameByCid", json["cid"]);
  933. });
  934. //批量上传查询学生分页
  935. router.route("/selectSnameByCidPage").all((req, res, next) => {
  936. var json = queryString(req.url);
  937. getmysql(
  938. req,
  939. res,
  940. "selectSnameByCidPage",
  941. json["cid"],
  942. json["cn"],
  943. json["page"],
  944. json["num"]
  945. );
  946. });
  947. //分组查询学生
  948. router.route("/selectSnameByCidGroup").all((req, res, next) => {
  949. var json = queryString(req.url);
  950. getmysql(
  951. req,
  952. res,
  953. "selectSnameByCidGroup",
  954. json["cid"],
  955. json["oid"],
  956. json["cn"]
  957. );
  958. });
  959. /* 查询学生 */
  960. router.route("/selectStudent2").all((req, res, next) => {
  961. var json = queryString(req.url);
  962. getmysql(
  963. req,
  964. res,
  965. "selectStudent2",
  966. json["oid"],
  967. json["cu"],
  968. json["cn"],
  969. json["cid"],
  970. json["page"],
  971. 10
  972. );
  973. });
  974. /* 查询教师 */
  975. router.route("/selectTeacher2").all((req, res, next) => {
  976. var json = queryString(req.url);
  977. getmysql(
  978. req,
  979. res,
  980. "selectTeacher2",
  981. json["oid"],
  982. json["cu"],
  983. json["cn"],
  984. json["cid"],
  985. json["page"],
  986. 10
  987. );
  988. });
  989. /* 查询教师 */
  990. router.route("/selectTeacher").all((req, res, next) => {
  991. var json = queryString(req.url);
  992. getmysql(
  993. req,
  994. res,
  995. "selectTeacher",
  996. json["org"],
  997. json["cu"],
  998. json["cn"],
  999. json["page"],
  1000. 10
  1001. );
  1002. });
  1003. /* 添加教师页面查询教师 */
  1004. router.route("/selectTcTeacher").all((req, res, next) => {
  1005. var json = queryString(req.url);
  1006. getmysql(
  1007. req,
  1008. res,
  1009. "selectTcTeacher",
  1010. json["org"],
  1011. json["oid"],
  1012. json["cu"],
  1013. json["cn"],
  1014. json["page"],
  1015. 10
  1016. );
  1017. });
  1018. /* 查询所有评价体系 */
  1019. router.route("/selectAllEvaluation").all((req, res, next) => {
  1020. var json = queryString(req.url);
  1021. getmysql(req, res, "selectAllEvaluation", json["oid"]);
  1022. });
  1023. /* 根据市级用户查询评审员 */
  1024. router.route("/selectReviewer").all((req, res, next) => {
  1025. var json = queryString(req.url);
  1026. getmysql(
  1027. req,
  1028. res,
  1029. "selectReviewer",
  1030. json["uid"],
  1031. json["cn"],
  1032. json["page"],
  1033. 10
  1034. );
  1035. });
  1036. /* 市级区县管理接口 */
  1037. router.route("/selectCReviewer").all((req, res, next) => {
  1038. var json = queryString(req.url);
  1039. getmysql(
  1040. req,
  1041. res,
  1042. "selectCReviewer",
  1043. json["uid"],
  1044. json["cn"],
  1045. json["page"],
  1046. 10
  1047. );
  1048. });
  1049. /* 修改评审员 */
  1050. router.route("/updateReviewer").all((req, res, next) => {
  1051. var json = queryString(req.url);
  1052. getmysql(
  1053. req,
  1054. res,
  1055. "updateReviewer",
  1056. json["n"],
  1057. json["p"],
  1058. json["t"],
  1059. json["s"],
  1060. json["uid"]
  1061. );
  1062. });
  1063. /* 删除评审员 */
  1064. router.route("/deleteReviewer").all((req, res, next) => {
  1065. var json = queryString(req.url);
  1066. getmysql(req, res, "deleteReviewer", json["uid"]);
  1067. });
  1068. /* 查询区县案例 */
  1069. router.route("/selecAnliBox").all((req, res, next) => {
  1070. var json = queryString(req.url);
  1071. getmysql(req, res, "selecAnliBox", json["title"]);
  1072. });
  1073. /* 查询市级案例 */
  1074. router.route("/selecAnliBox1").all((req, res, next) => {
  1075. var json = queryString(req.url);
  1076. getmysql(req, res, "selecAnliBox1", json["title"]);
  1077. });
  1078. /* 查询省级案例 */
  1079. router.route("/selecAnliBox2").all((req, res, next) => {
  1080. var json = queryString(req.url);
  1081. getmysql(req, res, "selecAnliBox2");
  1082. });
  1083. /* 案例征集查询通知公告 */
  1084. router.route("/selectRaceNotice").all((req, res, next) => {
  1085. var json = queryString(req.url);
  1086. getmysql(req, res, "selectRaceNotice", json["page"], 10);
  1087. });
  1088. /* 案例征集查询通知公告详情 */
  1089. router.route("/getRaceNoticeDetail").all((req, res, next) => {
  1090. var json = queryString(req.url);
  1091. getmysql(req, res, "getRaceNoticeDetail", json["nid"]);
  1092. });
  1093. /* 案例征集发送通知 */
  1094. router.route("/insertRaceNote").all((req, res, next) => {
  1095. var json = queryString(req.url);
  1096. getmysql(req, res, "insertRaceNote", json["t"], json["c"], json["uid"]);
  1097. });
  1098. /* 查看随机码是否重复 */
  1099. router.route("/selectInviteCode").all((req, res, next) => {
  1100. var json = queryString(req.url);
  1101. getmysql(req, res, "selectInviteCode", json["code"], json["oid"]);
  1102. });
  1103. /* 查看随机码是否重复 */
  1104. router.route("/selectInviteCode2").all((req, res, next) => {
  1105. var json = queryString(req.url);
  1106. getmysql(req, res, "selectInviteCode2", json["code"], json["oid"]);
  1107. });
  1108. /* 根据随机码获取学校 */
  1109. router.route("/selectCourseByIc").all((req, res, next) => {
  1110. var json = queryString(req.url);
  1111. getmysql(req, res, "selectCourseByIc", json["code"], json["oid"]);
  1112. });
  1113. /* 根据随机码获取学校 */
  1114. router.route("/selectCourseByIc2").all((req, res, next) => {
  1115. var json = queryString(req.url);
  1116. getmysql(req, res, "selectCourseByIc2", json["code"], json["oid"]);
  1117. });
  1118. router.route("/addWorkNew").all((req, res, next) => {
  1119. // postmysql(req, res, "insert_teacher_work_new");
  1120. if (req.body[0]) {
  1121. // p = Object.values(req.body[0]);
  1122. p = [
  1123. req.body[0].uid,
  1124. req.body[0].title,
  1125. req.body[0].brief,
  1126. req.body[0].cover,
  1127. req.body[0].astudent,
  1128. req.body[0].see,
  1129. req.body[0].chapters,
  1130. req.body[0].template,
  1131. ];
  1132. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new");
  1133. //執行存儲過程
  1134. mysql.usselect(p, function(ret) {
  1135. let course = req.body[0].courseType;
  1136. let courseId = ret[0][0].courseId;
  1137. let userid = req.body[0].uid;
  1138. delCourseType(course, courseId, userid);
  1139. res.end(
  1140. JSON.stringify({
  1141. ordernumber: ret[0][0].ordernumber,
  1142. courseId: ret[0][0].courseId,
  1143. success: 1,
  1144. })
  1145. );
  1146. // res.end(JSON.stringify(ret));
  1147. });
  1148. }
  1149. });
  1150. router.route("/addWorkNew2").all((req, res, next) => {
  1151. if (req.body[0]) {
  1152. p = [
  1153. req.body[0].uid,
  1154. req.body[0].title,
  1155. req.body[0].brief,
  1156. req.body[0].cover,
  1157. req.body[0].evaId,
  1158. req.body[0].astudent,
  1159. req.body[0].see,
  1160. req.body[0].chapters,
  1161. req.body[0].template,
  1162. req.body[0].ateacher,
  1163. ];
  1164. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new2"); //執行存儲過程
  1165. mysql.usselect(p, function(ret) {
  1166. let course = req.body[0].courseType;
  1167. let courseId = ret[0][0].courseId;
  1168. let userid = req.body[0].uid;
  1169. delCourseType(course, courseId, userid);
  1170. // delCourseInviteCode(courseId, JSON.parse(req.body[0].inviteCode));
  1171. res.end(
  1172. JSON.stringify({
  1173. ordernumber: ret[0][0].ordernumber,
  1174. courseId: ret[0][0].courseId,
  1175. success: 1,
  1176. })
  1177. );
  1178. });
  1179. }
  1180. });
  1181. router.route("/addWorkNew2E").all((req, res, next) => {
  1182. if (req.body[0]) {
  1183. p = [
  1184. req.body[0].uid,
  1185. req.body[0].title,
  1186. req.body[0].brief,
  1187. req.body[0].cover,
  1188. req.body[0].evaId,
  1189. req.body[0].astudent,
  1190. req.body[0].see,
  1191. req.body[0].chapters,
  1192. req.body[0].template,
  1193. req.body[0].ateacher,
  1194. ];
  1195. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new2E"); //執行存儲過程
  1196. mysql.usselect(p, function(ret) {
  1197. let course = req.body[0].courseType;
  1198. let courseId = ret[0][0].courseId;
  1199. let userid = req.body[0].uid;
  1200. delCourseType(course, courseId, userid);
  1201. // delCourseInviteCode(courseId, JSON.parse(req.body[0].inviteCode));
  1202. res.end(
  1203. JSON.stringify({
  1204. ordernumber: ret[0][0].ordernumber,
  1205. courseId: ret[0][0].courseId,
  1206. success: 1,
  1207. })
  1208. );
  1209. });
  1210. }
  1211. });
  1212. router.route("/addWorkNew2T").all((req, res, next) => {
  1213. if (req.body[0]) {
  1214. p = [
  1215. req.body[0].uid,
  1216. req.body[0].title,
  1217. req.body[0].brief,
  1218. req.body[0].cover,
  1219. req.body[0].evaId,
  1220. req.body[0].astudent,
  1221. req.body[0].see,
  1222. req.body[0].chapters,
  1223. req.body[0].template,
  1224. req.body[0].ateacher,
  1225. ];
  1226. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new2T"); //執行存儲過程
  1227. mysql.usselect(p, function(ret) {
  1228. let course = req.body[0].courseType;
  1229. let courseId = ret[0][0].courseId;
  1230. let userid = req.body[0].uid;
  1231. delCourseType(course, courseId, userid);
  1232. // delCourseInviteCode(courseId, JSON.parse(req.body[0].inviteCode));
  1233. res.end(
  1234. JSON.stringify({
  1235. ordernumber: ret[0][0].ordernumber,
  1236. courseId: ret[0][0].courseId,
  1237. success: 1,
  1238. })
  1239. );
  1240. });
  1241. }
  1242. });
  1243. router.route("/addSynergyCourse").all((req, res, next) => {
  1244. if (req.body[0]) {
  1245. p = [
  1246. req.body[0].uid,
  1247. req.body[0].title,
  1248. req.body[0].brief,
  1249. req.body[0].cover,
  1250. req.body[0].evaId,
  1251. req.body[0].astudent,
  1252. req.body[0].see,
  1253. req.body[0].chapters,
  1254. req.body[0].template,
  1255. req.body[0].ateacher,
  1256. ];
  1257. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_synergy"); //執行存儲過程
  1258. mysql.usselect(p, function(ret) {
  1259. let course = req.body[0].courseType;
  1260. let courseId = ret[0][0].courseId;
  1261. let userid = req.body[0].uid;
  1262. delCourseType(course, courseId, userid);
  1263. // delCourseInviteCode(courseId, JSON.parse(req.body[0].inviteCode));
  1264. res.end(
  1265. JSON.stringify({
  1266. ordernumber: ret[0][0].ordernumber,
  1267. courseId: ret[0][0].courseId,
  1268. success: 1,
  1269. })
  1270. );
  1271. });
  1272. }
  1273. });
  1274. router.route("/addWorkNew4").all((req, res, next) => {
  1275. if (req.body[0]) {
  1276. p = [
  1277. req.body[0].uid,
  1278. req.body[0].title,
  1279. req.body[0].brief,
  1280. req.body[0].cover,
  1281. req.body[0].evaId,
  1282. req.body[0].astudent,
  1283. req.body[0].see,
  1284. req.body[0].chapters,
  1285. req.body[0].template,
  1286. req.body[0].ateacher,
  1287. req.body[0].inviteCode,
  1288. ];
  1289. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new4"); //執行存儲過程
  1290. mysql.usselect(p, function(ret) {
  1291. let course = req.body[0].courseType;
  1292. let courseId = ret[0][0].courseId;
  1293. let userid = req.body[0].uid;
  1294. delCourseType(course, courseId, userid);
  1295. res.end(
  1296. JSON.stringify({
  1297. ordernumber: ret[0][0].ordernumber,
  1298. courseId: ret[0][0].courseId,
  1299. success: 1,
  1300. })
  1301. );
  1302. });
  1303. }
  1304. });
  1305. router.route("/addCourseWorkNew2").all((req, res, next) => {
  1306. //学生
  1307. if (req.body[0]) {
  1308. p = [
  1309. req.body[0].uid,
  1310. req.body[0].title,
  1311. req.body[0].brief,
  1312. req.body[0].cover,
  1313. req.body[0].evaId,
  1314. req.body[0].astudent,
  1315. req.body[0].see,
  1316. req.body[0].chapters,
  1317. req.body[0].template,
  1318. req.body[0].ateacher,
  1319. ];
  1320. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addCourseWorkNew2"); //執行存儲過程
  1321. mysql.usselect(p, function(ret) {
  1322. let course = req.body[0].courseType;
  1323. let courseId = ret[0][0].courseId;
  1324. let userid = req.body[0].uid;
  1325. delCourseType(course, courseId, userid);
  1326. res.end(
  1327. JSON.stringify({
  1328. ordernumber: ret[0][0].ordernumber,
  1329. courseId: ret[0][0].courseId,
  1330. success: 1,
  1331. })
  1332. );
  1333. });
  1334. }
  1335. });
  1336. router.route("/addCourseWorkNew22").all((req, res, next) => {
  1337. //学生
  1338. if (req.body[0]) {
  1339. p = [
  1340. req.body[0].uid,
  1341. req.body[0].title,
  1342. req.body[0].brief,
  1343. req.body[0].cover,
  1344. req.body[0].evaId,
  1345. req.body[0].astudent,
  1346. req.body[0].see,
  1347. req.body[0].chapters,
  1348. req.body[0].template,
  1349. req.body[0].ateacher,
  1350. ];
  1351. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addCourseWorkNew2"); //執行存儲過程
  1352. mysql.usselect(p, function(ret) {
  1353. let course = req.body[0].courseType;
  1354. let courseId = ret[0][0].courseId;
  1355. let userid = req.body[0].uid;
  1356. delCourseTypeS(course, courseId, userid);
  1357. res.end(
  1358. JSON.stringify({
  1359. ordernumber: ret[0][0].ordernumber,
  1360. courseId: ret[0][0].courseId,
  1361. success: 1,
  1362. })
  1363. );
  1364. });
  1365. }
  1366. });
  1367. //新增赛事项目
  1368. router.route("/addRace").all((req, res, next) => {
  1369. if (req.body[0]) {
  1370. p = [
  1371. req.body[0].uid,
  1372. req.body[0].info,
  1373. req.body[0].over,
  1374. req.body[0].pro,
  1375. req.body[0].act,
  1376. req.body[0].exc,
  1377. req.body[0].res,
  1378. ];
  1379. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addRace"); //執行存儲過程
  1380. mysql.usselect(p, function(ret) {
  1381. let course = req.body[0].courseType;
  1382. let courseId = ret[0][0].id;
  1383. let userid = req.body[0].uid;
  1384. delCourseType1(course, courseId, userid);
  1385. res.end(JSON.stringify({ courseId: courseId, success: 1 }));
  1386. });
  1387. }
  1388. });
  1389. //新增赛事账号信息
  1390. router.route("/addRaceUser").all((req, res, next) => {
  1391. if (req.body[0]) {
  1392. p = [
  1393. req.body[0].reg,
  1394. req.body[0].res,
  1395. req.body[0].sch,
  1396. req.body[0].n,
  1397. req.body[0].p,
  1398. req.body[0].t,
  1399. req.body[0].parent,
  1400. ];
  1401. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addRaceUser"); //執行存儲過程
  1402. mysql.usselect(p, function(ret) {
  1403. let num = ret[0][0].num;
  1404. let userid = ret[0][0].userid;
  1405. if (num < 10) {
  1406. num = "SZ" + "00" + num + "@gdae.com";
  1407. } else if (num < 100) {
  1408. num = "SZ" + "0" + num + "@gdae.com";
  1409. } else if (num > 100) {
  1410. num = "SZ" + num + "@gdae.com";
  1411. }
  1412. y = [userid, num, bcrypt.hashSync("123456", bcrypt.genSaltSync(10))];
  1413. //参数拼接,注册
  1414. y.unshift(_mysqlLabor[0], _mysqlLabor[1], "upRaceUserNamePassword");
  1415. mysql.usselect(y, function(ret) {
  1416. res.end(JSON.stringify(ret));
  1417. });
  1418. res.end(JSON.stringify({ num: num, success: 1 }));
  1419. });
  1420. }
  1421. });
  1422. //修改赛事项目
  1423. router.route("/updateRace").all((req, res, next) => {
  1424. if (req.body[0]) {
  1425. p = [
  1426. req.body[0].id,
  1427. req.body[0].info,
  1428. req.body[0].over,
  1429. req.body[0].pro,
  1430. req.body[0].act,
  1431. req.body[0].exc,
  1432. req.body[0].res,
  1433. ];
  1434. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateRace"); //執行存儲過程
  1435. mysql.usselect(p, function(ret) {
  1436. let course = req.body[0].courseType;
  1437. let courseId = req.body[0].id;
  1438. let userid = req.body[0].uid;
  1439. delCourseType1(course, courseId, userid);
  1440. res.end(JSON.stringify({ success: 1 }));
  1441. });
  1442. }
  1443. });
  1444. router.route("/addWorkNew3").all((req, res, next) => {
  1445. if (req.body[0]) {
  1446. p = [
  1447. req.body[0].uid,
  1448. req.body[0].title,
  1449. req.body[0].brief,
  1450. req.body[0].cover,
  1451. req.body[0].astudent,
  1452. req.body[0].see,
  1453. req.body[0].chapters,
  1454. req.body[0].template,
  1455. req.body[0].ateacher,
  1456. ];
  1457. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insert_teacher_work_new3"); //執行存儲過程
  1458. mysql.usselect(p, function(ret) {
  1459. let course = req.body[0].courseType;
  1460. let courseId = ret[0][0].courseId;
  1461. let userid = req.body[0].uid;
  1462. delCourseType(course, courseId, userid);
  1463. res.end(
  1464. JSON.stringify({
  1465. ordernumber: ret[0][0].ordernumber,
  1466. courseId: ret[0][0].courseId,
  1467. success: 1,
  1468. })
  1469. );
  1470. });
  1471. }
  1472. });
  1473. router.route("/addInviteCode").all((req, res, next) => {
  1474. if (req.body[0]) {
  1475. // delCourseInviteCode(req.body[0].courseId,JSON.parse(req.body[0].inviteCode))
  1476. addCourseInviteCode(
  1477. req.body[0].courseId,
  1478. JSON.parse(req.body[0].inviteCode)
  1479. );
  1480. }
  1481. });
  1482. function delCourseInviteCode(courseId, inviteCode) {
  1483. let _courseId = courseId;
  1484. var _userdata = [_courseId];
  1485. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_courseInviteCode");
  1486. mysql.usselect(_userdata, function(ret) {
  1487. // console.log(ret);
  1488. addCourseInviteCode(_courseId, inviteCode);
  1489. });
  1490. }
  1491. function delCourseType(course, courseId, userid) {
  1492. let _courseId = courseId;
  1493. var _userdata = [_courseId];
  1494. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_courseType");
  1495. mysql.usselect(_userdata, function(ret) {
  1496. // console.log(ret);
  1497. addCourseType(userid, course, _courseId);
  1498. });
  1499. // setTimeout(() => {
  1500. // }, 1000);
  1501. }
  1502. function delCourseType1(course, courseId, userid) {
  1503. let _courseId = courseId;
  1504. var _userdata = [_courseId];
  1505. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_courseType1");
  1506. mysql.usselect(_userdata, function(ret) {
  1507. // console.log(ret);
  1508. });
  1509. setTimeout(() => {
  1510. addCourseType1(userid, course, _courseId);
  1511. }, 1000);
  1512. }
  1513. function delCourseTypeS(course, courseId, userid) {
  1514. let _courseId = courseId;
  1515. var _userdata = [_courseId];
  1516. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_courseTypeS");
  1517. mysql.usselect(_userdata, function(ret) {
  1518. // console.log(ret);
  1519. addCourseTypeS(userid, course, _courseId);
  1520. });
  1521. // setTimeout(() => {
  1522. // }, 1000);
  1523. }
  1524. function addCourseInviteCode(courseId, inviteCode) {
  1525. var _courses = courseId;
  1526. var _tid = inviteCode;
  1527. for (let i = 0; i < _tid.length; i++) {
  1528. let _userdata = [_courses, _tid[i].cid, _tid[i].ic];
  1529. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_courseInviteCode");
  1530. setTimeout(() => {
  1531. mysql.usselect(_userdata, function(ret) {
  1532. // console.log(ret);
  1533. });
  1534. }, i * 100);
  1535. }
  1536. }
  1537. function addCourseType(userid, course, _courseId) {
  1538. var _uid = userid;
  1539. var _courses = _courseId;
  1540. var _tid = JSON.parse(course);
  1541. for (let i = 0; i < _tid.length; i++) {
  1542. if (_tid[i] == "") {
  1543. continue;
  1544. }
  1545. var _userdata = [_courses, _tid[i], _uid];
  1546. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_courseType");
  1547. mysql.usselect(_userdata, function(ret) {
  1548. // console.log(ret);
  1549. });
  1550. }
  1551. }
  1552. function addCourseType1(userid, course, _courseId) {
  1553. var _uid = userid;
  1554. var _courses = _courseId;
  1555. var _tid = JSON.parse(course);
  1556. for (let i = 0; i < _tid.length; i++) {
  1557. if (_tid[i] == "") {
  1558. continue;
  1559. }
  1560. var _userdata = [_courses, _tid[i], _uid];
  1561. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_courseType1");
  1562. mysql.usselect(_userdata, function(ret) {
  1563. // console.log(ret);
  1564. });
  1565. }
  1566. }
  1567. function addCourseTypeS(userid, course, _courseId) {
  1568. var _uid = userid;
  1569. var _courses = _courseId;
  1570. var _tid = JSON.parse(course);
  1571. for (let i = 0; i < _tid.length; i++) {
  1572. if (_tid[i] == "") {
  1573. continue;
  1574. }
  1575. var _userdata = [_courses, _tid[i], _uid];
  1576. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_courseTypeS");
  1577. mysql.usselect(_userdata, function(ret) {
  1578. // console.log(ret);
  1579. });
  1580. }
  1581. }
  1582. //修改课程
  1583. // router.route('/updateWork').all((req, res, next) => {
  1584. // postmysql(req, res, "update_teacher_work");
  1585. // });
  1586. router.route("/updateWorkNew").all((req, res, next) => {
  1587. if (req.body[0]) {
  1588. // p = Object.values(req.body[0]);
  1589. p = [
  1590. req.body[0].cid,
  1591. req.body[0].title,
  1592. req.body[0].brief,
  1593. req.body[0].cover,
  1594. req.body[0].astudent,
  1595. req.body[0].see,
  1596. req.body[0].chapters,
  1597. req.body[0].template,
  1598. ];
  1599. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new");
  1600. //執行存儲過程
  1601. mysql.usselect(p, function(ret) {
  1602. let course = req.body[0].courseType;
  1603. let courseId = req.body[0].cid;
  1604. let userid = req.body[0].uid;
  1605. delCourseType(course, courseId, userid);
  1606. res.end(JSON.stringify({ success: 1 }));
  1607. // res.end(JSON.stringify(ret));
  1608. });
  1609. }
  1610. });
  1611. //查询课程
  1612. // router.route('/selectCourse').all((req, res, next) => {
  1613. // var json = queryString(req.url);
  1614. // getmysql(req, res, "select_course", json['type'], json['uid'], json['oid'], json['page'], 10);
  1615. // });
  1616. router.route("/updateWorkNew2").all((req, res, next) => {
  1617. if (req.body[0]) {
  1618. p = [
  1619. req.body[0].cid,
  1620. req.body[0].title,
  1621. req.body[0].brief,
  1622. req.body[0].cover,
  1623. req.body[0].evaId,
  1624. req.body[0].astudent,
  1625. req.body[0].see,
  1626. req.body[0].chapters,
  1627. req.body[0].template,
  1628. req.body[0].ateacher,
  1629. ];
  1630. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new2"); //執行存儲過程
  1631. mysql.usselect(p, function(ret) {
  1632. let course = req.body[0].courseType;
  1633. let courseId = req.body[0].cid;
  1634. let userid = req.body[0].uid;
  1635. delCourseType(course, courseId, userid);
  1636. // delCourseInviteCode(courseId, JSON.parse(req.body[0].inviteCode));
  1637. res.end(JSON.stringify({ success: 1 }));
  1638. });
  1639. }
  1640. });
  1641. router.route("/updateSynergy").all((req, res, next) => {
  1642. if (req.body[0]) {
  1643. p = [
  1644. req.body[0].cid,
  1645. req.body[0].title,
  1646. req.body[0].brief,
  1647. req.body[0].cover,
  1648. req.body[0].evaId,
  1649. req.body[0].astudent,
  1650. req.body[0].see,
  1651. req.body[0].chapters,
  1652. req.body[0].template,
  1653. req.body[0].ateacher,
  1654. ];
  1655. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_synergy"); //執行存儲過程
  1656. mysql.usselect(p, function(ret) {
  1657. let course = req.body[0].courseType;
  1658. let courseId = req.body[0].cid;
  1659. let userid = req.body[0].uid;
  1660. delCourseType(course, courseId, userid);
  1661. // delCourseInviteCode(courseId, JSON.parse(req.body[0].inviteCode));
  1662. res.end(JSON.stringify({ success: 1 }));
  1663. });
  1664. }
  1665. });
  1666. router.route("/updateWorkNew5").all((req, res, next) => {
  1667. if (req.body[0]) {
  1668. p = [
  1669. req.body[0].cid,
  1670. req.body[0].title,
  1671. req.body[0].brief,
  1672. req.body[0].cover,
  1673. req.body[0].evaId,
  1674. req.body[0].astudent,
  1675. req.body[0].see,
  1676. req.body[0].chapters,
  1677. req.body[0].template,
  1678. req.body[0].ateacher,
  1679. req.body[0].inviteCode,
  1680. ];
  1681. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new5"); //執行存儲過程
  1682. mysql.usselect(p, function(ret) {
  1683. let course = req.body[0].courseType;
  1684. let courseId = req.body[0].cid;
  1685. let userid = req.body[0].uid;
  1686. delCourseType(course, courseId, userid);
  1687. res.end(JSON.stringify({ success: 1 }));
  1688. });
  1689. }
  1690. });
  1691. router.route("/updateStudentWorkNew2").all((req, res, next) => {
  1692. //学生
  1693. if (req.body[0]) {
  1694. p = [
  1695. req.body[0].cid,
  1696. req.body[0].title,
  1697. req.body[0].brief,
  1698. req.body[0].cover,
  1699. req.body[0].evaId,
  1700. req.body[0].astudent,
  1701. req.body[0].see,
  1702. req.body[0].chapters,
  1703. req.body[0].template,
  1704. req.body[0].ateacher,
  1705. ];
  1706. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudentWorkNew2"); //執行存儲過程
  1707. mysql.usselect(p, function(ret) {
  1708. let course = req.body[0].courseType;
  1709. let courseId = req.body[0].cid;
  1710. let userid = req.body[0].uid;
  1711. delCourseType(course, courseId, userid);
  1712. res.end(JSON.stringify({ success: 1 }));
  1713. });
  1714. }
  1715. });
  1716. router.route("/updateStudentWorkNew22").all((req, res, next) => {
  1717. //学生
  1718. if (req.body[0]) {
  1719. p = [
  1720. req.body[0].cid,
  1721. req.body[0].title,
  1722. req.body[0].brief,
  1723. req.body[0].cover,
  1724. req.body[0].evaId,
  1725. req.body[0].astudent,
  1726. req.body[0].see,
  1727. req.body[0].chapters,
  1728. req.body[0].template,
  1729. req.body[0].ateacher,
  1730. ];
  1731. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudentWorkNew2"); //執行存儲過程
  1732. mysql.usselect(p, function(ret) {
  1733. let course = req.body[0].courseType;
  1734. let courseId = req.body[0].cid;
  1735. let userid = req.body[0].uid;
  1736. delCourseTypeS(course, courseId, userid);
  1737. res.end(JSON.stringify({ success: 1 }));
  1738. });
  1739. }
  1740. });
  1741. router.route("/updateWorkNew3").all((req, res, next) => {
  1742. if (req.body[0]) {
  1743. p = [
  1744. req.body[0].cid,
  1745. req.body[0].title,
  1746. req.body[0].brief,
  1747. req.body[0].cover,
  1748. req.body[0].astudent,
  1749. req.body[0].see,
  1750. req.body[0].chapters,
  1751. req.body[0].template,
  1752. req.body[0].ateacher,
  1753. ];
  1754. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new3"); //執行存儲過程
  1755. mysql.usselect(p, function(ret) {
  1756. let course = req.body[0].courseType;
  1757. let courseId = req.body[0].cid;
  1758. let userid = req.body[0].uid;
  1759. delCourseType(course, courseId, userid);
  1760. res.end(JSON.stringify({ success: 1 }));
  1761. });
  1762. }
  1763. });
  1764. function guid() {
  1765. var _num,
  1766. i,
  1767. _guid = "";
  1768. for (i = 0; i < 32; i++) {
  1769. _guid += Math.floor(Math.random() * 16).toString(16); //随机0 - 16 的数字 转变为16进制的字符串
  1770. _num = Math.floor((i - 7) / 4); //计算 (i-7)除4
  1771. if (_num > -1 && _num < 4 && i == 7 + 4 * _num) {
  1772. //会使guid中间加 "-" 形式为xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
  1773. _guid += "-";
  1774. }
  1775. }
  1776. return _guid;
  1777. }
  1778. router.route("/updateWorkNew4").all((req, res, next) => {
  1779. if (req.body[0]) {
  1780. let p = [req.body[0].cid];
  1781. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
  1782. mysql.usselect(p, function(ret) {
  1783. let _unitIndex = parseInt(req.body[0].unitIndex);
  1784. let _chapters = JSON.parse(req.body[0].chapters);
  1785. let _unitJson = JSON.parse(ret[0][0].chapters);
  1786. if (_unitJson.length - 1 < _unitIndex) {
  1787. let _i = _unitIndex - (_unitJson.length - 1);
  1788. for (let i = 0; i < _i; i++) {
  1789. _unitJson.push({
  1790. dyName: "", //单元标题
  1791. chapterInfo: [{
  1792. isread: false,
  1793. chapterid: guid(),
  1794. title: "",
  1795. courseName: "",
  1796. taskJson: [{
  1797. task: "",
  1798. taskDetail: "",
  1799. chapterData: [],
  1800. toolText: "",
  1801. toolChoose: [{
  1802. tool: [],
  1803. toolDetail: "",
  1804. toolType: 0,
  1805. askCount: 1,
  1806. askTitle: "",
  1807. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  1808. }, ],
  1809. isShowTools: false,
  1810. askCount: 1,
  1811. isFold: 0,
  1812. askTitle: "",
  1813. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  1814. checkJson: [{ checkCount: [], checkPerent: [] }],
  1815. homeworkList: [],
  1816. }, ],
  1817. itemCount: 1,
  1818. fileList1: [],
  1819. video: [],
  1820. testData: [],
  1821. pData: [],
  1822. templateArray: [],
  1823. }, ],
  1824. });
  1825. }
  1826. _unitJson[_unitIndex] = _chapters[_unitIndex];
  1827. } else {
  1828. _unitJson[_unitIndex] = _chapters[_unitIndex];
  1829. }
  1830. // console.log(_unitJson);
  1831. let p2 = [
  1832. req.body[0].cid,
  1833. JSON.stringify(_unitJson).replaceAll(/%/g, "%25"),
  1834. ];
  1835. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new4"); //執行存儲過程
  1836. mysql.usselect(p2, function(ret) {
  1837. res.end(JSON.stringify({ success: 1 }));
  1838. });
  1839. // res.end(JSON.stringify({ success: 1 }));
  1840. });
  1841. }
  1842. });
  1843. router.route("/updateStudentWorkNew4").all((req, res, next) => {
  1844. //学生
  1845. if (req.body[0]) {
  1846. let p = [req.body[0].cid];
  1847. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_student_course_detail2"); //執行存儲過程
  1848. mysql.usselect(p, function(ret) {
  1849. let _unitIndex = parseInt(req.body[0].unitIndex);
  1850. let _chapters = JSON.parse(req.body[0].chapters);
  1851. let _unitJson = JSON.parse(ret[0][0].chapters);
  1852. if (_unitJson.length - 1 < _unitIndex) {
  1853. let _i = _unitIndex - (_unitJson.length - 1);
  1854. for (let i = 0; i < _i; i++) {
  1855. _unitJson.push({
  1856. dyName: "", //单元标题
  1857. chapterInfo: [{
  1858. isread: false,
  1859. chapterid: guid(),
  1860. title: "",
  1861. courseName: "",
  1862. taskJson: [{
  1863. task: "",
  1864. taskDetail: "",
  1865. chapterData: [],
  1866. toolText: "",
  1867. toolChoose: [{
  1868. tool: [],
  1869. toolDetail: "",
  1870. toolType: 0,
  1871. askCount: 1,
  1872. askTitle: "",
  1873. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  1874. }, ],
  1875. isShowTools: false,
  1876. askCount: 1,
  1877. isFold: 0,
  1878. askTitle: "",
  1879. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  1880. checkJson: [{ checkCount: [], checkPerent: [] }],
  1881. homeworkList: [],
  1882. }, ],
  1883. itemCount: 1,
  1884. fileList1: [],
  1885. video: [],
  1886. testData: [],
  1887. pData: [],
  1888. templateArray: [],
  1889. }, ],
  1890. });
  1891. }
  1892. _unitJson[_unitIndex] = _chapters[_unitIndex];
  1893. } else {
  1894. _unitJson[_unitIndex] = _chapters[_unitIndex];
  1895. }
  1896. // console.log(_unitJson);
  1897. let p2 = [
  1898. req.body[0].cid,
  1899. JSON.stringify(_unitJson).replaceAll(/%/g, "%25"),
  1900. ];
  1901. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudentWorkNew4"); //執行存儲過程
  1902. mysql.usselect(p2, function(ret) {
  1903. res.end(JSON.stringify({ success: 1 }));
  1904. });
  1905. // res.end(JSON.stringify({ success: 1 }));
  1906. });
  1907. }
  1908. });
  1909. //协同删除阶段
  1910. router.route("/deleteWork").all((req, res, next) => {
  1911. if (req.body[0]) {
  1912. let p = [req.body[0].cid];
  1913. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
  1914. mysql.usselect(p, function(ret) {
  1915. let _chapid = req.body[0].chapid;
  1916. // console.log(_chapid);
  1917. let _chapters = JSON.parse(req.body[0].chapters);
  1918. let _unitJson = JSON.parse(ret[0][0].chapters);
  1919. let _unitJson2 = [];
  1920. for (var i = 0; i < _unitJson.length; i++) {
  1921. if (_unitJson[i].chapterInfo[0].chapterid != _chapid) {
  1922. // console.log(1);
  1923. // _unitJson.splice(i, -1)
  1924. _unitJson2.push(_unitJson[i]);
  1925. // break;
  1926. }
  1927. }
  1928. // console.log(_unitJson2);
  1929. let p2 = [
  1930. req.body[0].cid,
  1931. JSON.stringify(_unitJson2).replaceAll(/%/g, "%25"),
  1932. ];
  1933. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new4"); //執行存儲過程
  1934. mysql.usselect(p2, function(ret) {
  1935. res.end(JSON.stringify({ success: 1 }));
  1936. });
  1937. // res.end(JSON.stringify({ success: 1 }));
  1938. });
  1939. }
  1940. });
  1941. //协同删除阶段
  1942. router.route("/deleteStudentWork").all((req, res, next) => {
  1943. //学生
  1944. if (req.body[0]) {
  1945. let p = [req.body[0].cid];
  1946. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_student_course_detail2"); //執行存儲過程
  1947. mysql.usselect(p, function(ret) {
  1948. let _chapid = req.body[0].chapid;
  1949. // console.log(_chapid);
  1950. let _chapters = JSON.parse(req.body[0].chapters);
  1951. let _unitJson = JSON.parse(ret[0][0].chapters);
  1952. let _unitJson2 = [];
  1953. for (var i = 0; i < _unitJson.length; i++) {
  1954. if (_unitJson[i].chapterInfo[0].chapterid != _chapid) {
  1955. // console.log(1);
  1956. // _unitJson.splice(i, -1)
  1957. _unitJson2.push(_unitJson[i]);
  1958. // break;
  1959. }
  1960. }
  1961. // console.log(_unitJson2);
  1962. let p2 = [
  1963. req.body[0].cid,
  1964. JSON.stringify(_unitJson2).replaceAll(/%/g, "%25"),
  1965. ];
  1966. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudentWorkNew4"); //執行存儲過程
  1967. mysql.usselect(p2, function(ret) {
  1968. res.end(JSON.stringify({ success: 1 }));
  1969. });
  1970. // res.end(JSON.stringify({ success: 1 }));
  1971. });
  1972. }
  1973. });
  1974. //协同恢复删除的阶段
  1975. router.route("/restoreWork").all((req, res, next) => {
  1976. if (req.body[0]) {
  1977. let p = [req.body[0].cid];
  1978. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_course_detail"); //執行存儲過程
  1979. mysql.usselect(p, function(ret) {
  1980. let _chapid = req.body[0].chapid;
  1981. // console.log(_chapid);
  1982. let _chapters = JSON.parse(req.body[0].chapters);
  1983. let _unitJson = JSON.parse(ret[0][0].chapters);
  1984. let _unitJson2 = [];
  1985. let chpaindex;
  1986. for (var i = 0; i < _chapters.length; i++) {
  1987. if (_chapters[i].chapterInfo[0].chapterid == _chapid) {
  1988. chpaindex = i;
  1989. }
  1990. }
  1991. for (var i = 0; i < _unitJson.length; i++) {
  1992. if (_unitJson[i].chapterInfo[0].chapterid != _chapid) {
  1993. // console.log(1);
  1994. // _unitJson.splice(i, -1)
  1995. _unitJson2.push(_unitJson[i]);
  1996. // break;
  1997. }
  1998. }
  1999. _unitJson2.splice(chpaindex, 0, _chapters[chpaindex]);
  2000. // console.log(_unitJson2);
  2001. let p2 = [
  2002. req.body[0].cid,
  2003. JSON.stringify(_unitJson2).replaceAll(/%/g, "%25"),
  2004. ];
  2005. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "update_teacher_work_new4"); //執行存儲過程
  2006. mysql.usselect(p2, function(ret) {
  2007. res.end(JSON.stringify({ success: 1 }));
  2008. });
  2009. // res.end(JSON.stringify({ success: 1 }));
  2010. });
  2011. }
  2012. });
  2013. //协同恢复删除的阶段
  2014. router.route("/restoreStudentWork").all((req, res, next) => {
  2015. //学生
  2016. if (req.body[0]) {
  2017. let p = [req.body[0].cid];
  2018. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_student_course_detail2"); //執行存儲過程
  2019. mysql.usselect(p, function(ret) {
  2020. let _chapid = req.body[0].chapid;
  2021. // console.log(_chapid);
  2022. let _chapters = JSON.parse(req.body[0].chapters);
  2023. let _unitJson = JSON.parse(ret[0][0].chapters);
  2024. let _unitJson2 = [];
  2025. let chpaindex;
  2026. for (var i = 0; i < _chapters.length; i++) {
  2027. if (_chapters[i].chapterInfo[0].chapterid == _chapid) {
  2028. chpaindex = i;
  2029. }
  2030. }
  2031. for (var i = 0; i < _unitJson.length; i++) {
  2032. if (_unitJson[i].chapterInfo[0].chapterid != _chapid) {
  2033. // console.log(1);
  2034. // _unitJson.splice(i, -1)
  2035. _unitJson2.push(_unitJson[i]);
  2036. // break;
  2037. }
  2038. }
  2039. _unitJson2.splice(chpaindex, 0, _chapters[chpaindex]);
  2040. // console.log(_unitJson2);
  2041. let p2 = [
  2042. req.body[0].cid,
  2043. JSON.stringify(_unitJson2).replaceAll(/%/g, "%25"),
  2044. ];
  2045. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudentWorkNew4"); //執行存儲過程
  2046. mysql.usselect(p2, function(ret) {
  2047. res.end(JSON.stringify({ success: 1 }));
  2048. });
  2049. // res.end(JSON.stringify({ success: 1 }));
  2050. });
  2051. }
  2052. });
  2053. router.route("/selectCourseNew").all((req, res, next) => {
  2054. var json = queryString(req.url);
  2055. getmysql(
  2056. req,
  2057. res,
  2058. "select_course_new",
  2059. json["type"],
  2060. json["uid"],
  2061. json["oid"],
  2062. json["typea"],
  2063. json["typeb"],
  2064. json["typec"],
  2065. json["typed"],
  2066. json["typeE"],
  2067. json["cu"],
  2068. json["cn"],
  2069. json["page"],
  2070. 10
  2071. );
  2072. });
  2073. router.route("/selectCourseNew2").all((req, res, next) => {
  2074. var json = queryString(req.url);
  2075. getmysql(
  2076. req,
  2077. res,
  2078. "select_course_new2",
  2079. json["type"],
  2080. json["uid"],
  2081. json["oid"],
  2082. json["org"],
  2083. json["typea"],
  2084. json["typeb"],
  2085. json["typec"],
  2086. json["typed"],
  2087. json["typeE"],
  2088. json["cu"],
  2089. json["cn"],
  2090. json["page"],
  2091. json["pageSize"]
  2092. );
  2093. });
  2094. router.route("/selectStudentCourseNew2").all((req, res, next) => {
  2095. var json = queryString(req.url);
  2096. getmysql(
  2097. req,
  2098. res,
  2099. "selectStudentCourseNew2",
  2100. json["type"],
  2101. json["uid"],
  2102. json["oid"],
  2103. json["org"],
  2104. json["typea"],
  2105. json["typeb"],
  2106. json["typec"],
  2107. json["typed"],
  2108. json["typeE"],
  2109. json["cu"],
  2110. json["cn"],
  2111. json["page"],
  2112. 10
  2113. );
  2114. });
  2115. router.route("/selectStudentCourseNew22").all((req, res, next) => {
  2116. var json = queryString(req.url);
  2117. getmysql(
  2118. req,
  2119. res,
  2120. "selectStudentCourseNew22",
  2121. json["type"],
  2122. json["uid"],
  2123. json["oid"],
  2124. json["org"],
  2125. json["typea"],
  2126. json["typeb"],
  2127. json["typec"],
  2128. json["typed"],
  2129. json["typef"],
  2130. json["typeE"],
  2131. json["cu"],
  2132. json["cn"],
  2133. json["page"],
  2134. json["pageSize"]
  2135. );
  2136. });
  2137. router.route("/selectStudentCourseNew222").all((req, res, next) => {
  2138. var json = queryString(req.url);
  2139. getmysql(
  2140. req,
  2141. res,
  2142. "selectStudentCourseNew222",
  2143. json["type"],
  2144. json["uid"],
  2145. json["oid"],
  2146. json["org"],
  2147. json["typea"],
  2148. json["typeb"],
  2149. json["typec"],
  2150. json["typed"],
  2151. json["typef"],
  2152. json["typeE"],
  2153. json["cu"],
  2154. json["cn"],
  2155. json["page"],
  2156. json["pageSize"]
  2157. );
  2158. });
  2159. router.route("/selectStudentCourseNew22Mode").all((req, res, next) => {
  2160. var json = queryString(req.url);
  2161. getmysql(
  2162. req,
  2163. res,
  2164. "selectStudentCourseNew22Mode",
  2165. json["type"],
  2166. json["uid"],
  2167. json["oid"],
  2168. json["org"],
  2169. json["typea"],
  2170. json["typeb"],
  2171. json["typec"],
  2172. json["typed"],
  2173. json["typef"],
  2174. json["typeE"],
  2175. json["cu"],
  2176. json["cn"]
  2177. );
  2178. });
  2179. //查询协同编辑课程
  2180. router.route("/selectCourseTeam").all((req, res, next) => {
  2181. var json = queryString(req.url);
  2182. getmysql(req, res, "selectCourseTeam", json["uid"], json["oid"]);
  2183. });
  2184. //查询学校
  2185. router.route("/selectSchoolName").all((req, res, next) => {
  2186. var json = queryString(req.url);
  2187. getmysql(req, res, "selectOidName", json["cu"], json["cn"], json["page"], 10);
  2188. });
  2189. //查询组织
  2190. router.route("/selectOrgName").all((req, res, next) => {
  2191. var json = queryString(req.url);
  2192. getmysql(req, res, "selectOrgName", json["page"], 10);
  2193. });
  2194. //查询学校
  2195. router.route("/selectSchoolName2").all((req, res, next) => {
  2196. var json = queryString(req.url);
  2197. getmysql(req, res, "selectOidName2", json["oid"]);
  2198. });
  2199. //查询学校
  2200. router.route("/selectSchoolNameOrg").all((req, res, next) => {
  2201. var json = queryString(req.url);
  2202. getmysql(req, res, "selectSchoolNameOrg", json["org"], json["page"], 10);
  2203. });
  2204. //查询协同学校和被协同学校
  2205. router.route("/selectOrgType").all((req, res, next) => {
  2206. var json = queryString(req.url);
  2207. getmysql(req, res, "selectOrgType", json["t"], json["org"], json["page"], 10);
  2208. });
  2209. //新增批注
  2210. router.route("/addPz").all((req, res, next) => {
  2211. postmysql(req, res, "addPz");
  2212. });
  2213. //新增批注
  2214. router.route("/addPz2").all((req, res, next) => {
  2215. postmysql(req, res, "addPz2");
  2216. });
  2217. //删除批注
  2218. router.route("/deletePz").all((req, res, next) => {
  2219. postmysql(req, res, "deletePz");
  2220. });
  2221. //查询批注列表
  2222. router.route("/selectPzList").all((req, res, next) => {
  2223. var json = queryString(req.url);
  2224. getmysql(req, res, "selectPzList", json["cid"], json["s"], json["t"]);
  2225. });
  2226. //查询批注列表
  2227. router.route("/selectPzListType").all((req, res, next) => {
  2228. var json = queryString(req.url);
  2229. getmysql(req, res, "selectPzListType", json["cid"], json["s"], json["t"], json["type"], json["uid"]);
  2230. });
  2231. //评分
  2232. router.route("/scoreWork").all((req, res, next) => {
  2233. postmysql(req, res, "scoreWork");
  2234. });
  2235. //删除学生
  2236. router.route("/deleteStudent").all((req, res, next) => {
  2237. postmysql(req, res, "delete_student");
  2238. });
  2239. //查询学校底下的班级
  2240. router.route("/selectClassBySchool").all((req, res, next) => {
  2241. var json = queryString(req.url);
  2242. getmysql(req, res, "selectClassBySchool", json["oid"]);
  2243. });
  2244. //查询学校底下的教研室
  2245. router.route("/selectTeacherOfficeBySchool").all((req, res, next) => {
  2246. var json = queryString(req.url);
  2247. getmysql(req, res, "selectTeacherOfficeBySchool", json["oid"]);
  2248. });
  2249. //查询学校底下的年级
  2250. router.route("/selectGrageBySchool").all((req, res, next) => {
  2251. var json = queryString(req.url);
  2252. getmysql(req, res, "selectGrageBySchool", json["oid"]);
  2253. });
  2254. //查询学校底下的班级
  2255. router.route("/selectClassBySchoolSearch").all((req, res, next) => {
  2256. var json = queryString(req.url);
  2257. getmysql(req, res, "selectClassBySchoolSearch", json["oid"], json["cn"]);
  2258. });
  2259. //查询学校底下的班级
  2260. router.route("/selectClassBySchoolSearch2").all((req, res, next) => {
  2261. var json = queryString(req.url);
  2262. getmysql(req, res, "selectClassBySchoolSearch2", json["oid"], json["gid"], json["cn"]);
  2263. });
  2264. //查询组织底下的学校
  2265. router.route("/selectSchoolByOrg").all((req, res, next) => {
  2266. var json = queryString(req.url);
  2267. getmysql(req, res, "selectSchoolByOrg", json["org"]);
  2268. });
  2269. //学生注册接口
  2270. router.route("/register_student").post(function(req, res, next) {
  2271. //mode的处理
  2272. if (req.body[0]) {
  2273. // 0 用户名 1 用户密码 2用户身份 3 第三方id(可有可无)
  2274. p = Object.values(req.body[0]); //获取用户密码
  2275. //没有第三方id的处理
  2276. // if (p.length < 4) {
  2277. // p.push("")
  2278. // }
  2279. p[1] = bcrypt.hashSync(p[1], bcrypt.genSaltSync(10));
  2280. //密码加密
  2281. // bcrypt.hash(p[1], 10, function (err, hash) {
  2282. // if (err) {
  2283. // return next(err);
  2284. // }
  2285. // p[1] = hash;
  2286. // });
  2287. //参数拼接,注册
  2288. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "register_student");
  2289. //返回注册用户数据
  2290. // mysql.usselect(p, function (ret) {
  2291. // res.end(ret);
  2292. // });
  2293. mysql.usselect(p, function(ret) {
  2294. res.end(JSON.stringify(ret));
  2295. });
  2296. }
  2297. });
  2298. //查询课程详情
  2299. router.route("/selectCourseDetail").all((req, res, next) => {
  2300. var json = queryString(req.url);
  2301. getmysql(req, res, "selectCourseDetail", json["courseId"]);
  2302. });
  2303. //查询课程详情
  2304. router.route("/selectCourseDetail2").all((req, res, next) => {
  2305. var json = queryString(req.url);
  2306. getmysql(req, res, "selectCourseDetail2", json["courseId"]);
  2307. });
  2308. //查询课程详情
  2309. router.route("/selectCourseDetail3").all((req, res, next) => {
  2310. var json = queryString(req.url);
  2311. getmysql(req, res, "selectCourseDetail3", json["courseId"]);
  2312. });
  2313. //查询学校底下的所有赛事
  2314. router.route("/selectRaceByOid").all((req, res, next) => {
  2315. var json = queryString(req.url);
  2316. getmysql(req, res, "selectRaceByOid", json["sid"]);
  2317. });
  2318. //修改作业学生名称
  2319. router.route("/updateCourseWorksName").all((req, res, next) => {
  2320. var json = queryString(req.url);
  2321. getmysql(req, res, "updateCourseWorksName", json["n"], json["cid"]);
  2322. });
  2323. //查询课程详情
  2324. router.route("/selectStudentCourseDetail").all((req, res, next) => {
  2325. //学生
  2326. var json = queryString(req.url);
  2327. getmysql(req, res, "selectStudentCourseDetail", json["courseId"]);
  2328. });
  2329. //查询课程详情
  2330. router.route("/selectStudentCourseDetail3").all((req, res, next) => {
  2331. //学生
  2332. var json = queryString(req.url);
  2333. getmysql(req, res, "selectStudentCourseDetail3", json["courseId"]);
  2334. });
  2335. //查询课程详情
  2336. router.route("/selectStudentCourseDetail2").all((req, res, next) => {
  2337. //学生
  2338. var json = queryString(req.url);
  2339. getmysql(req, res, "selectStudentCourseDetail2", json["courseId"]);
  2340. });
  2341. //跳转阶段时,如果有课程就查询1返回,如果没有就插入
  2342. router.route("/addUserR").all((req, res, next) => {
  2343. var json = queryString(req.url);
  2344. getmysql(req, res, "insertUserR", json["uid"], json["cid"]);
  2345. });
  2346. //新增学生端作业
  2347. router.route("/addWorks").all((req, res, next) => {
  2348. postmysql(req, res, "add_works");
  2349. });
  2350. //查询已提交作业
  2351. router.route("/selectWork").all((req, res, next) => {
  2352. var json = queryString(req.url);
  2353. getmysql(
  2354. req,
  2355. res,
  2356. "selectWork",
  2357. json["cid"],
  2358. json["stage"],
  2359. json["task"],
  2360. json["uid"]
  2361. );
  2362. });
  2363. //查询作业详情
  2364. router.route("/selectWorksDetail").all((req, res, next) => {
  2365. var json = queryString(req.url);
  2366. getmysql(req, res, "selectWorksDetail", json["uid"], json["cid"]);
  2367. });
  2368. //新增作业评分
  2369. router.route("/updateWorks").all((req, res, next) => {
  2370. var json = queryString(req.url);
  2371. getmysql(req, res, "updateWorks", json["rate"], json["tuid"], json["id"]);
  2372. });
  2373. //新增素材信息
  2374. router.route("/addMtl").all((req, res, next) => {
  2375. var json = queryString(req.url);
  2376. getmysql(req, res, "add_mtl", json["cInfo"], json["t"], json["cBy"]);
  2377. });
  2378. //根据类型查询素材信息
  2379. router.route("/selectMtl").all((req, res, next) => {
  2380. var json = queryString(req.url);
  2381. getmysql(req, res, "selectMtl", json["t"], json["page"], 10);
  2382. });
  2383. //根据类型查询素材信息
  2384. router.route("/selectMtl2").all((req, res, next) => {
  2385. var json = queryString(req.url);
  2386. getmysql(req, res, "selectMtl2", json["t"], json["uid"], json["page"], 10);
  2387. });
  2388. //学习中心
  2389. //新增学习资源信息
  2390. router.route("/addStuMtl").all((req, res, next) => {
  2391. var json = queryString(req.url);
  2392. getmysql(req, res, "addStuMtl", json["cInfo"], json["t"], json["cBy"]);
  2393. });
  2394. //根据类型查询学习资料信息
  2395. router.route("/selectStuMtl").all((req, res, next) => {
  2396. var json = queryString(req.url);
  2397. getmysql(req, res, "selectStuMtl", json["t"], json["page"], 10);
  2398. });
  2399. //删除素材
  2400. router.route("/deleteStuM").all((req, res, next) => {
  2401. var json = queryString(req.url);
  2402. getmysql(req, res, "deleteStuM", json["id"]);
  2403. });
  2404. //查询学生信息
  2405. router.route("/selectSDetail").all((req, res, next) => {
  2406. var json = queryString(req.url);
  2407. getmysql(req, res, "selectStudentDetail", json["uid"]);
  2408. });
  2409. //查询个人课程
  2410. router.route("/selectMyCourse").all((req, res, next) => {
  2411. var json = queryString(req.url);
  2412. getmysql(req, res, "selectMyCourse", json["uid"]);
  2413. });
  2414. //查询个人课程groupby课程id
  2415. router.route("/selectMyCourseBycid").all((req, res, next) => {
  2416. var json = queryString(req.url);
  2417. getmysql(req, res, "selectMyCourseBycid", json["uid"]);
  2418. });
  2419. //查询所有课程
  2420. router.route("/selectAllCourse").all((req, res, next) => {
  2421. var json = queryString(req.url);
  2422. getmysql(req, res, "selectAllCourse", json["oid"], json["page"], 10);
  2423. });
  2424. //根据班级查询所有课程
  2425. router.route("/selectAllCourseByCid").all((req, res, next) => {
  2426. var json = queryString(req.url);
  2427. getmysql(
  2428. req,
  2429. res,
  2430. "selectAllCourseByCid",
  2431. json["oid"],
  2432. json["cid"],
  2433. json["page"],
  2434. 10
  2435. );
  2436. });
  2437. //根据分类查询所有课程
  2438. router.route("/selectTypeCourse").all((req, res, next) => {
  2439. var json = queryString(req.url);
  2440. getmysql(
  2441. req,
  2442. res,
  2443. "selectTypeCourse",
  2444. json["uid"],
  2445. json["oid"],
  2446. json["typea"],
  2447. json["typeb"],
  2448. json["typec"],
  2449. json["typed"],
  2450. json["typeE"],
  2451. json["cu"],
  2452. json["cn"],
  2453. json["classid"],
  2454. json["page"],
  2455. 10
  2456. );
  2457. });
  2458. //根据分类查询所有课程
  2459. router.route("/selectTypeCourse2").all((req, res, next) => {
  2460. var json = queryString(req.url);
  2461. getmysql(
  2462. req,
  2463. res,
  2464. "selectTypeCourse2",
  2465. json["uid"],
  2466. json["oid"],
  2467. json["typea"],
  2468. json["typeb"],
  2469. json["typec"],
  2470. json["typed"],
  2471. json["typeE"],
  2472. json["cu"],
  2473. json["cn"],
  2474. json["classid"],
  2475. json["org"],
  2476. json["page"],
  2477. json["pageSize"]
  2478. );
  2479. });
  2480. //根据分类查询所有课程
  2481. router.route("/selectTypeCourse2Mode").all((req, res, next) => {
  2482. var json = queryString(req.url);
  2483. getmysql(
  2484. req,
  2485. res,
  2486. "selectTypeCourse2Mode",
  2487. json["uid"],
  2488. json["oid"],
  2489. json["typea"],
  2490. json["typeb"],
  2491. json["typec"],
  2492. json["typed"],
  2493. json["typeE"],
  2494. json["cu"],
  2495. json["cn"],
  2496. json["classid"],
  2497. json["org"]
  2498. );
  2499. });
  2500. //根据分类查询所有课程
  2501. router.route("/selectTypeCourse2GM").all((req, res, next) => {
  2502. var json = queryString(req.url);
  2503. getmysql(
  2504. req,
  2505. res,
  2506. "selectTypeCourse2GM",
  2507. json["uid"],
  2508. json["oid"],
  2509. json["typea"],
  2510. json["typeb"],
  2511. json["typec"],
  2512. json["typed"],
  2513. json["typeE"],
  2514. json["cu"],
  2515. json["cn"],
  2516. json["classid"],
  2517. json["org"],
  2518. json["page"],
  2519. 10
  2520. );
  2521. });
  2522. //根据分类查询所有课程
  2523. router.route("/selectCourseExamine").all((req, res, next) => {
  2524. var json = queryString(req.url);
  2525. getmysql(
  2526. req,
  2527. res,
  2528. "selectCourseExamine",
  2529. json["oid"],
  2530. json["org"],
  2531. json["cn"],
  2532. json["page"],
  2533. 10
  2534. );
  2535. });
  2536. //根据分类查询所有课程
  2537. router.route("/selectTypeCourse3").all((req, res, next) => {
  2538. var json = queryString(req.url);
  2539. getmysql(
  2540. req,
  2541. res,
  2542. "selectTypeCourse3",
  2543. json["uid"],
  2544. json["oid"],
  2545. json["typea"],
  2546. json["typeb"],
  2547. json["typec"],
  2548. json["typed"],
  2549. json["typeE"],
  2550. json["cu"],
  2551. json["cn"],
  2552. json["classid"],
  2553. json["org"],
  2554. json["page"],
  2555. 10
  2556. );
  2557. });
  2558. //审核课程
  2559. router.route("/examineCourse").all((req, res, next) => {
  2560. postmysql(req, res, "examineCourse");
  2561. });
  2562. //删除素材
  2563. router.route("/deleteM").all((req, res, next) => {
  2564. var json = queryString(req.url);
  2565. getmysql(req, res, "deleteM", json["id"]);
  2566. });
  2567. //点击阶段时添加观看人数
  2568. router.route("/updateVc").all((req, res, next) => {
  2569. var json = queryString(req.url);
  2570. getmysql(req, res, "updateVc", json["cid"]);
  2571. });
  2572. //删除课程
  2573. router.route("/deleteCourse").all((req, res, next) => {
  2574. var json = queryString(req.url);
  2575. getmysql(req, res, "deleteCourse", json["cid"]);
  2576. });
  2577. //删除课程
  2578. router.route("/deleteStudentCourse").all((req, res, next) => {
  2579. var json = queryString(req.url);
  2580. getmysql(req, res, "deleteStudentCourse", json["cid"]);
  2581. });
  2582. //复制课程
  2583. router.route("/copyCourse").all((req, res, next) => {
  2584. postmysql(req, res, "copyCourse");
  2585. });
  2586. //复制评价体系
  2587. router.route("/copyEva").all((req, res, next) => {
  2588. postmysql(req, res, "copyEva");
  2589. });
  2590. //复制课程
  2591. router.route("/copySCourse").all((req, res, next) => {
  2592. postmysql(req, res, "copySCourse");
  2593. });
  2594. //查看课程
  2595. router.route("/select_course_detail").all((req, res, next) => {
  2596. var json = queryString(req.url);
  2597. getmysql(req, res, "select_course_detail", json["cid"]);
  2598. });
  2599. //查看课程
  2600. router.route("/select_synergy").all((req, res, next) => {
  2601. var json = queryString(req.url);
  2602. getmysql(req, res, "select_synergy", json["cid"]);
  2603. });
  2604. //查看课程
  2605. router.route("/select_student_course_detail").all((req, res, next) => {
  2606. //学生
  2607. var json = queryString(req.url);
  2608. getmysql(req, res, "select_student_course_detail", json["cid"]);
  2609. });
  2610. //查看课程
  2611. router.route("/select_student_course_detail2").all((req, res, next) => {
  2612. //学生
  2613. var json = queryString(req.url);
  2614. getmysql(req, res, "select_student_course_detail2", json["cid"]);
  2615. });
  2616. //查看课程
  2617. router.route("/getExportScourse").all((req, res, next) => {
  2618. //学生
  2619. var json = queryString(req.url);
  2620. getmysql(req, res, "getExportScourse", json["cid"]);
  2621. });
  2622. //模糊查找课程
  2623. // router.route('/searchCourse').all((req, res, next) => {
  2624. // var json = queryString(req.url);
  2625. // getmysql(req, res, "searchCourse", json['cu'], json['cn'], json['page'], 10);
  2626. // });
  2627. //创建调查问卷
  2628. router.route("/addAsk").all((req, res, next) => {
  2629. postmysql(req, res, "insert_ask");
  2630. });
  2631. //学生提交问卷
  2632. router.route("/addAskList").all((req, res, next) => {
  2633. postmysql(req, res, "insert_askList");
  2634. });
  2635. //根据课程id阶段id获取已提交的问卷
  2636. router.route("/getAskListByCidStage").all((req, res, next) => {
  2637. var json = queryString(req.url);
  2638. getmysql(
  2639. req,
  2640. res,
  2641. "getAskListByCidStage",
  2642. json["cid"],
  2643. json["stage"],
  2644. json["task"]
  2645. );
  2646. });
  2647. //获取调查问卷
  2648. router.route("/getAsk").all((req, res, next) => {
  2649. var json = queryString(req.url);
  2650. getmysql(req, res, "select_ask", json["uid"], json["page"], 10);
  2651. });
  2652. //删除问卷
  2653. router.route("/deleteAsk").all((req, res, next) => {
  2654. postmysql(req, res, "deleteAsk");
  2655. });
  2656. //问卷调查数据统计
  2657. router.route("/getAskListByAskid").all((req, res, next) => {
  2658. var json = queryString(req.url);
  2659. getmysql(req, res, "select_askListByAskid", json["aid"]);
  2660. });
  2661. //删除学生提交问卷
  2662. router.route("/deleteAskList").all((req, res, next) => {
  2663. postmysql(req, res, "update_askList_delete");
  2664. });
  2665. //根据id获取调查问卷
  2666. router.route("/getAskList").all((req, res, next) => {
  2667. var json = queryString(req.url);
  2668. getmysql(req, res, "select_askList", json["uid"], json["page"], 10);
  2669. });
  2670. //查看便签列表
  2671. router.route("/selectNote").all((req, res, next) => {
  2672. var json = queryString(req.url);
  2673. getmysql(req, res, "selectNote", json["uid"]);
  2674. });
  2675. //新增便签列表
  2676. router.route("/insertNote").all((req, res, next) => {
  2677. var json = queryString(req.url);
  2678. getmysql(req, res, "insertNote", json["uid"], json["c"]);
  2679. });
  2680. //根据便签id修改便签内容
  2681. router.route("/updateNote").all((req, res, next) => {
  2682. var json = queryString(req.url);
  2683. getmysql(req, res, "updateNote", json["nid"], json["c"]);
  2684. });
  2685. //删除便签
  2686. router.route("/deleteNote").all((req, res, next) => {
  2687. var json = queryString(req.url);
  2688. getmysql(req, res, "deleteNote", json["nid"]);
  2689. });
  2690. //查询便签
  2691. router.route("/selectNoteContent").all((req, res, next) => {
  2692. var json = queryString(req.url);
  2693. getmysql(req, res, "selectNoteContent", json["cn"]);
  2694. });
  2695. //修改用户信息
  2696. router.route("/updateUserByEdu").all((req, res, next) => {
  2697. postmysql(req, res, "updateUserByEdu");
  2698. });
  2699. //修改用户信息
  2700. router.route("/updateUserByEdu1").all((req, res, next) => {
  2701. postmysql(req, res, "updateUserByEdu1");
  2702. });
  2703. //修改用户信息
  2704. router.route("/updateUserByEduOid").all((req, res, next) => {
  2705. postmysql(req, res, "updateUserByEduOid");
  2706. });
  2707. //修改学生信息
  2708. router.route("/updateStudentInfo").all((req, res, next) => {
  2709. postmysql(req, res, "updateStudentInfo");
  2710. });
  2711. //教师端data修改pbl用户信息
  2712. router.route("/updatePblMessage").all((req, res, next) => {
  2713. postmysql2(req, res, "updatePblMessage");
  2714. });
  2715. //登录次数
  2716. router.route("/addLoginOperation").all((req, res, next) => {
  2717. postmysql2(req, res, "addLoginOperation");
  2718. });
  2719. //当日登录时间
  2720. router.route("/addOperationTime").all((req, res, next) => {
  2721. postmysql2(req, res, "addOperationTime");
  2722. });
  2723. //课程学习时间
  2724. router.route("/addOperationTime2").all((req, res, next) => {
  2725. postmysql(req, res, "addOperationTime");
  2726. });
  2727. //当日登录时间
  2728. router.route("/addOperationTimeT").all((req, res, next) => {
  2729. postmysql2(req, res, "addOperationTime2");
  2730. });
  2731. //课程学习时间
  2732. router.route("/addOperationTimeT2").all((req, res, next) => {
  2733. postmysql(req, res, "addOperationTime2");
  2734. });
  2735. router.route("/updatePblMessage2").all((req, res, next) => {
  2736. postmysql(req, res, "updatePblMessage");
  2737. });
  2738. router.route("/updateRaceUser").all((req, res, next) => {
  2739. postmysql(req, res, "updateRaceUser");
  2740. });
  2741. //查询用户信息
  2742. router.route("/selectUser").all((req, res, next) => {
  2743. var json = queryString(req.url);
  2744. getmysql(req, res, "selectUser", json["userid"]);
  2745. });
  2746. //查询分类及所有子分类
  2747. router.route("/selectAllType").all((req, res, next) => {
  2748. var json = queryString(req.url);
  2749. getmysql(req, res, "selectAllType", json["org"], json["oid"]);
  2750. });
  2751. //查询分类及所有子分类
  2752. router.route("/selectAllTypeS").all((req, res, next) => {
  2753. var json = queryString(req.url);
  2754. getmysql(req, res, "selectAllTypeS", json["org"], json["oid"]);
  2755. });
  2756. //查询分类及子分类
  2757. router.route("/selectType").all((req, res, next) => {
  2758. var json = queryString(req.url);
  2759. getmysql(req, res, "selectType");
  2760. });
  2761. //查询分类及子分类
  2762. router.route("/selectStudentType").all((req, res, next) => {
  2763. var json = queryString(req.url);
  2764. getmysql(req, res, "selectStudentType");
  2765. });
  2766. //查询赛事分类及子分类
  2767. router.route("/selectMatType").all((req, res, next) => {
  2768. var json = queryString(req.url);
  2769. getmysql(req, res, "selectMatType");
  2770. });
  2771. //根据学校查询分类
  2772. router.route("/selectPtype").all((req, res, next) => {
  2773. var json = queryString(req.url);
  2774. getmysql(req, res, "selectPtype", json["page"], 10);
  2775. });
  2776. //根据学校查询学生项目分类
  2777. router.route("/selectSPtype").all((req, res, next) => {
  2778. var json = queryString(req.url);
  2779. getmysql(req, res, "selectSPtype", json["page"], 10);
  2780. });
  2781. //根据学校查询分类1
  2782. router.route("/selectPtype1").all((req, res, next) => {
  2783. var json = queryString(req.url);
  2784. getmysql(req, res, "selectPtype1", json["oid"], json["page"], 10);
  2785. });
  2786. //添加分类
  2787. router.route("/addPtype").all((req, res, next) => {
  2788. var json = queryString(req.url);
  2789. getmysql(req, res, "addPtype", json["n"], json["uid"], json["oid"]);
  2790. });
  2791. //修改分类
  2792. router.route("/updatePtype").all((req, res, next) => {
  2793. var json = queryString(req.url);
  2794. getmysql(req, res, "updatePtype", json["n"], json["tid"]);
  2795. });
  2796. //修改学生项目分类
  2797. router.route("/updateSPtype").all((req, res, next) => {
  2798. var json = queryString(req.url);
  2799. getmysql(req, res, "updateSPtype", json["n"], json["tid"]);
  2800. });
  2801. //删除分类
  2802. router.route("/deletePtype").all((req, res, next) => {
  2803. var json = queryString(req.url);
  2804. getmysql(req, res, "deletePtype", json["tid"]);
  2805. });
  2806. //删除学生项目分类
  2807. router.route("/deleteSPtype").all((req, res, next) => {
  2808. var json = queryString(req.url);
  2809. getmysql(req, res, "deleteSPtype", json["tid"]);
  2810. });
  2811. //查询子分类列表
  2812. router.route("/selectStype").all((req, res, next) => {
  2813. var json = queryString(req.url);
  2814. getmysql(req, res, "selectStype", json["pid"], json["oid"], json["page"], 10);
  2815. });
  2816. //查询学生项目子分类列表
  2817. router.route("/selectSStype").all((req, res, next) => {
  2818. var json = queryString(req.url);
  2819. getmysql(
  2820. req,
  2821. res,
  2822. "selectSStype",
  2823. json["pid"],
  2824. json["oid"],
  2825. json["page"],
  2826. 10
  2827. );
  2828. });
  2829. //添加子分类
  2830. router.route("/addStype").all((req, res, next) => {
  2831. var json = queryString(req.url);
  2832. getmysql(
  2833. req,
  2834. res,
  2835. "addStype",
  2836. json["pid"],
  2837. json["n"],
  2838. json["uid"],
  2839. json["oid"]
  2840. );
  2841. });
  2842. //添加学生项目子分类
  2843. router.route("/addSStype").all((req, res, next) => {
  2844. var json = queryString(req.url);
  2845. getmysql(
  2846. req,
  2847. res,
  2848. "addSStype",
  2849. json["pid"],
  2850. json["n"],
  2851. json["uid"],
  2852. json["oid"]
  2853. );
  2854. });
  2855. //根据学校查询工作分类
  2856. router.route("/selectStudioPtype").all((req, res, next) => {
  2857. var json = queryString(req.url);
  2858. getmysql(req, res, "selectStudioPtype", json["page"], 10);
  2859. });
  2860. //查询工作室项目子分类列表
  2861. router.route("/selectStudioStype").all((req, res, next) => {
  2862. var json = queryString(req.url);
  2863. getmysql(
  2864. req,
  2865. res,
  2866. "selectStudioStype",
  2867. json["pid"],
  2868. json["oid"],
  2869. json["page"],
  2870. 10
  2871. );
  2872. });
  2873. //添加工作室项目子分类
  2874. router.route("/addStudioStype").all((req, res, next) => {
  2875. var json = queryString(req.url);
  2876. getmysql(
  2877. req,
  2878. res,
  2879. "addStudioStype",
  2880. json["pid"],
  2881. json["n"],
  2882. json["uid"],
  2883. json["oid"]
  2884. );
  2885. });
  2886. //修改工作项目分类
  2887. router.route("/updateStudioPtype").all((req, res, next) => {
  2888. var json = queryString(req.url);
  2889. getmysql(req, res, "updateStudioPtype", json["n"], json["tid"]);
  2890. });
  2891. //删除工作项目分类
  2892. router.route("/deleteStudioPtype").all((req, res, next) => {
  2893. var json = queryString(req.url);
  2894. getmysql(req, res, "deleteStudioPtype", json["tid"]);
  2895. });
  2896. //查看本校所有学生(分页)
  2897. router.route("/selectAllStudent").all((req, res, next) => {
  2898. var json = queryString(req.url);
  2899. getmysql(
  2900. req,
  2901. res,
  2902. "selectAllStudent",
  2903. json["oid"],
  2904. json["cn"],
  2905. json["cid"],
  2906. json["page"],
  2907. 10
  2908. );
  2909. });
  2910. //根据学校id查询子分类
  2911. router.route("/selectTypeByOid").all((req, res, next) => {
  2912. var json = queryString(req.url);
  2913. getmysql(req, res, "selectTypeByOid", json["oid"]);
  2914. });
  2915. //根据学校id查询子分类
  2916. router.route("/selectTypeByOrg").all((req, res, next) => {
  2917. var json = queryString(req.url);
  2918. getmysql(req, res, "selectTypeByOid", json["oid"]);
  2919. });
  2920. //根据组织id查询子分类
  2921. router.route("/selectStudentTypeByOid").all((req, res, next) => {
  2922. var json = queryString(req.url);
  2923. getmysql(req, res, "selectStudentTypeByOid", json["oid"]);
  2924. });
  2925. //更加父id查询分类
  2926. router.route("/selectTypeByPid").all((req, res, next) => {
  2927. var json = queryString(req.url);
  2928. getmysql(req, res, "selectTypeByPid", json["pid"]);
  2929. });
  2930. //点击工具计数
  2931. router.route("/insertToolsCount").all((req, res, next) => {
  2932. var json = queryString(req.url);
  2933. getmysql(
  2934. req,
  2935. res,
  2936. "insertToolsCount",
  2937. json["cid"],
  2938. json["chid"],
  2939. json["uid"],
  2940. json["tid"],
  2941. json["count"]
  2942. );
  2943. });
  2944. //修改工具次数
  2945. router.route("/updateToolsCount").all((req, res, next) => {
  2946. var json = queryString(req.url);
  2947. getmysql(
  2948. req,
  2949. res,
  2950. "updateToolsCount",
  2951. json["cid"],
  2952. json["chid"],
  2953. json["uid"],
  2954. json["tid"],
  2955. json["count"]
  2956. );
  2957. });
  2958. //查询工具次数
  2959. router.route("/selectToolsCount").all((req, res, next) => {
  2960. var json = queryString(req.url);
  2961. getmysql(
  2962. req,
  2963. res,
  2964. "selectToolsCount",
  2965. json["cid"],
  2966. json["chid"],
  2967. json["uid"]
  2968. );
  2969. });
  2970. //导出学生
  2971. router.route("/selectUserBySchool").all((req, res, next) => {
  2972. var json = queryString(req.url);
  2973. getmysql(req, res, "selectUserBySchool", json["oid"]);
  2974. });
  2975. //上传学生作业
  2976. router.route("/insertSWork").all((req, res, next) => {
  2977. var json = queryString(req.url);
  2978. getmysql(
  2979. req,
  2980. res,
  2981. "insertSWork",
  2982. json["uid"],
  2983. json["cid"],
  2984. json["p"],
  2985. json["t"],
  2986. json["upload"]
  2987. );
  2988. });
  2989. //查询学生作业
  2990. router.route("/selectSWork").all((req, res, next) => {
  2991. var json = queryString(req.url);
  2992. getmysql(
  2993. req,
  2994. res,
  2995. "selectSWork",
  2996. json["uid"],
  2997. json["cid"],
  2998. json["p"],
  2999. json["type"]
  3000. );
  3001. });
  3002. //课程进展数据
  3003. router.route("/selectCase").all((req, res, next) => {
  3004. var json = queryString(req.url);
  3005. getmysql(req, res, "selectCase", json["org"]);
  3006. });
  3007. //课程进展数据
  3008. router.route("/selectCase2").all((req, res, next) => {
  3009. var json = queryString(req.url);
  3010. getmysql(req, res, "selectCase2", json["org"]);
  3011. });
  3012. //课程进展数据
  3013. router.route("/selectCase3").all((req, res, next) => {
  3014. var json = queryString(req.url);
  3015. getmysql(
  3016. req,
  3017. res,
  3018. "selectCase3",
  3019. json["org"],
  3020. json["oid"],
  3021. json["page"],
  3022. json["pageSize"]
  3023. );
  3024. });
  3025. //项目进展数据
  3026. router.route("/selectCaseS").all((req, res, next) => {
  3027. var json = queryString(req.url);
  3028. getmysql(req, res, "selectCaseS", json["org"], json["oid"]);
  3029. });
  3030. //项目进展数据
  3031. router.route("/selectCaseS2").all((req, res, next) => {
  3032. var json = queryString(req.url);
  3033. getmysql(
  3034. req,
  3035. res,
  3036. "selectCaseS2",
  3037. json["org"],
  3038. json["oid"],
  3039. json["type"],
  3040. json["page"],
  3041. json["pageSize"]
  3042. );
  3043. });
  3044. //查询赛事项目列表
  3045. router.route("/selectRaceList").all((req, res, next) => {
  3046. var json = queryString(req.url);
  3047. getmysql(req, res, "selectRaceList", json["uid"], json["t"]);
  3048. });
  3049. //修改赛事状态
  3050. router.route("/updateRaceState").all((req, res, next) => {
  3051. var json = queryString(req.url);
  3052. getmysql(req, res, "updateRaceState", json["id"], json["s"]);
  3053. });
  3054. //查询赛事项目详情
  3055. router.route("/selectRaceDetail").all((req, res, next) => {
  3056. var json = queryString(req.url);
  3057. getmysql(req, res, "selectRaceDetail", json["id"]);
  3058. });
  3059. //race 查询学校
  3060. router.route("/getSchool").all((req, res, next) => {
  3061. var json = queryString(req.url);
  3062. getmysql(req, res, "getSchool", json["n"]);
  3063. });
  3064. //查询我的学习报告
  3065. router.route("/selectMrEva").all((req, res, next) => {
  3066. var json = queryString(req.url);
  3067. getmysql(req, res, "selectMrEva", json["uid"], json["oid"], json["cid"]);
  3068. });
  3069. //查询行为数据库
  3070. router.route("/selectModelList").all((req, res, next) => {
  3071. var json = queryString(req.url);
  3072. getmysql(req, res, "selectModelList", json["cn"], json["oid"]);
  3073. });
  3074. //lsc
  3075. //admin 查询学校
  3076. router.route("/getSchoolAdmin").all((req, res, next) => {
  3077. var json = queryString(req.url);
  3078. getmysql(req, res, "select_school", json["page"], 10);
  3079. });
  3080. //admin 添加学校
  3081. router.route("/addSchoolAdmin").all((req, res, next) => {
  3082. postmysql(req, res, "add_school");
  3083. });
  3084. //组织添加学校
  3085. router.route("/addSchoolOrg").all((req, res, next) => {
  3086. postmysql(req, res, "addSchoolOrg");
  3087. });
  3088. //教师端组织添加学校
  3089. router.route("/insertSchoolByOrg").all((req, res, next) => {
  3090. postmysql(req, res, "insertSchoolByOrg");
  3091. });
  3092. //admin 删除学校
  3093. router.route("/deleteSchoolAdmin").all((req, res, next) => {
  3094. postmysql(req, res, "delete_school");
  3095. });
  3096. //admin 查询班级
  3097. router.route("/getClassAdmin").all((req, res, next) => {
  3098. var json = queryString(req.url);
  3099. getmysql(req, res, "select_classAdmin", json["cn"], json["page"], 10);
  3100. });
  3101. //admin 添加班级
  3102. router.route("/addClassAdmin").all((req, res, next) => {
  3103. postmysql(req, res, "add_classAdmin");
  3104. });
  3105. //admin 查询班级是否重复
  3106. router.route("/getClassRepeat").all((req, res, next) => {
  3107. var json = queryString(req.url);
  3108. getmysql(req, res, "select_classRepeatAdmin", json["n"], json["oid"]);
  3109. });
  3110. //查询未在此班级的学生
  3111. router.route("/getClassStudent").all((req, res, next) => {
  3112. var json = queryString(req.url);
  3113. getmysql(
  3114. req,
  3115. res,
  3116. "getClassStudent",
  3117. json["cid"],
  3118. json["oid"],
  3119. json["cn"],
  3120. json["page"],
  3121. json["num"]
  3122. );
  3123. });
  3124. //查询未在此教研室的老师
  3125. router.route("/getClassTeacher").all((req, res, next) => {
  3126. var json = queryString(req.url);
  3127. getmysql(
  3128. req,
  3129. res,
  3130. "getClassTeacher",
  3131. json["cid"],
  3132. json["oid"],
  3133. json["cn"],
  3134. json["page"],
  3135. json["num"]
  3136. );
  3137. });
  3138. //查询未在此年级的班级
  3139. router.route("/getGradeClass").all((req, res, next) => {
  3140. var json = queryString(req.url);
  3141. getmysql(
  3142. req,
  3143. res,
  3144. "getGradeClass",
  3145. json["cid"],
  3146. json["oid"],
  3147. json["cn"],
  3148. json["page"],
  3149. json["num"]
  3150. );
  3151. });
  3152. //添加学生到班级
  3153. router.route("/addClassStudent").all((req, res, next) => {
  3154. let cid = req.body[0].cid;
  3155. let student = JSON.parse(req.body[0].student);
  3156. for (let i = 0; i < student.length; i++) {
  3157. let _userdata = [student[i]];
  3158. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectUser");
  3159. mysql.usselect(_userdata, function(ret) {
  3160. let classid = ret[0][0].classid;
  3161. if (!classid || classid.indexOf(cid) == -1) {
  3162. classid = classid ? classid.split(",") : [];
  3163. classid.push(cid);
  3164. let _userdata2 = [student[i], classid.join(",")];
  3165. _userdata2.unshift(
  3166. _mysqlLabor[0],
  3167. _mysqlLabor[1],
  3168. "updateStudentClass"
  3169. );
  3170. mysql.usselect(_userdata2, function(ret) {
  3171. if (i == student.length - 1) {
  3172. res.end(JSON.stringify({ success: 1 }));
  3173. }
  3174. });
  3175. }
  3176. });
  3177. }
  3178. });
  3179. //添加老师到教研室
  3180. router.route("/addClassTeacher").all((req, res, next) => {
  3181. let cid = req.body[0].cid;
  3182. let student = JSON.parse(req.body[0].student);
  3183. for (let i = 0; i < student.length; i++) {
  3184. let _userdata = [student[i]];
  3185. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectUser");
  3186. mysql.usselect(_userdata, function(ret) {
  3187. let classid = ret[0][0].cclassid;
  3188. if (!classid || classid.indexOf(cid) == -1) {
  3189. classid = classid ? classid.split(",") : [];
  3190. classid.push(cid);
  3191. let _userdata2 = [student[i], classid.join(",")];
  3192. _userdata2.unshift(
  3193. _mysqlLabor[0],
  3194. _mysqlLabor[1],
  3195. "updateTeacherClass"
  3196. );
  3197. mysql.usselect(_userdata2, function(ret) {
  3198. if (i == student.length - 1) {
  3199. res.end(JSON.stringify({ success: 1 }));
  3200. }
  3201. });
  3202. }
  3203. });
  3204. }
  3205. });
  3206. //添加班级到年级
  3207. router.route("/addGradeClass").all((req, res, next) => {
  3208. let cid = req.body[0].cid;
  3209. let student = JSON.parse(req.body[0].student);
  3210. for (let i = 0; i < student.length; i++) {
  3211. let _userdata = [cid, student[i]];
  3212. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "addGradeClass");
  3213. mysql.usselect(_userdata, function(ret) {
  3214. if (i == student.length - 1) {
  3215. res.end(JSON.stringify({ success: 1 }));
  3216. }
  3217. });
  3218. }
  3219. });
  3220. //移除学生此班级
  3221. router.route("/deleteClassStudent").all((req, res, next) => {
  3222. let cid = req.body[0].cid;
  3223. let student = req.body[0].uid;
  3224. let _userdata = [student];
  3225. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectUser");
  3226. mysql.usselect(_userdata, function(ret) {
  3227. let classid = ret[0][0].classid;
  3228. if (classid.indexOf(cid) != -1) {
  3229. classid = classid.split(",");
  3230. classid.splice(classid.indexOf(cid), 1);
  3231. let _userdata2 = [student, classid.join(",")];
  3232. _userdata2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudentClass");
  3233. mysql.usselect(_userdata2, function(ret) {
  3234. res.end(JSON.stringify({ success: 1 }));
  3235. });
  3236. }
  3237. });
  3238. });
  3239. //移除学生此班级
  3240. router.route("/deleteClassTeacher").all((req, res, next) => {
  3241. let cid = req.body[0].cid;
  3242. let student = req.body[0].uid;
  3243. let _userdata = [student];
  3244. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "selectUser");
  3245. mysql.usselect(_userdata, function(ret) {
  3246. let classid = ret[0][0].cclassid;
  3247. if (classid.indexOf(cid) != -1) {
  3248. classid = classid.split(",");
  3249. classid.splice(classid.indexOf(cid), 1);
  3250. let _userdata2 = [student, classid.join(",")];
  3251. _userdata2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateTeacherClass");
  3252. mysql.usselect(_userdata2, function(ret) {
  3253. res.end(JSON.stringify({ success: 1 }));
  3254. });
  3255. }
  3256. });
  3257. });
  3258. //移除班级
  3259. router.route("/deleteGradeClass").all((req, res, next) => {
  3260. let cid = req.body[0].cid;
  3261. let student = req.body[0].uid;
  3262. let _userdata = ['', student];
  3263. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "addGradeClass");
  3264. mysql.usselect(_userdata, function(ret) {
  3265. res.end(JSON.stringify({ success: 1 }));
  3266. });
  3267. });
  3268. //admin 发布通知
  3269. router.route("/addNews").all((req, res, next) => {
  3270. postmysql(req, res, "add_news");
  3271. });
  3272. //admin 删除通知
  3273. router.route("/deleteNews").all((req, res, next) => {
  3274. postmysql(req, res, "delete_news");
  3275. });
  3276. //admin 添加banner
  3277. router.route("/addBanner").all((req, res, next) => {
  3278. postmysql(req, res, "add_banner");
  3279. });
  3280. //admin 添加banner
  3281. router.route("/deleteBanner").all((req, res, next) => {
  3282. postmysql(req, res, "delete_banner");
  3283. });
  3284. //admin 查询banner
  3285. router.route("/getBanner").all((req, res, next) => {
  3286. var json = queryString(req.url);
  3287. getmysql(req, res, "select_banner");
  3288. });
  3289. //根据学校查询banner
  3290. router.route("/selectBannerByOid").all((req, res, next) => {
  3291. var json = queryString(req.url);
  3292. getmysql(req, res, "selectBannerByOid", json["oid"]);
  3293. });
  3294. //admin 查询banner
  3295. router.route("/getBannerS").all((req, res, next) => {
  3296. var json = queryString(req.url);
  3297. getmysql(req, res, "getBannerS");
  3298. });
  3299. //根据学校查询banner
  3300. router.route("/selectBannerByOidS").all((req, res, next) => {
  3301. var json = queryString(req.url);
  3302. getmysql(req, res, "selectBannerByOidS", json["oid"]);
  3303. });
  3304. //admin 查询课程getSearchCourse
  3305. router.route("/getSearchCourse").all((req, res, next) => {
  3306. var json = queryString(req.url);
  3307. getmysql(req, res, "selectAll_courseSearch", json["t"]);
  3308. });
  3309. //根据学校查询课程
  3310. router.route("/getSearchCourseByoid").all((req, res, next) => {
  3311. var json = queryString(req.url);
  3312. getmysql(req, res, "selectAll_courseByOid", json["t"], json["oid"]);
  3313. });
  3314. //admin 查询所有课程专区
  3315. router.route("/getZone").all((req, res, next) => {
  3316. getmysql(req, res, "select_zone");
  3317. });
  3318. //admin 添加课程专区
  3319. router.route("/addZone").all((req, res, next) => {
  3320. postmysql(req, res, "insert_classZone");
  3321. });
  3322. //评审
  3323. router.route("/reviewCourse").all((req, res, next) => {
  3324. postmysql(req, res, "reviewCourse");
  3325. });
  3326. //查询评审
  3327. router.route("/getReview").all((req, res, next) => {
  3328. var json = queryString(req.url);
  3329. getmysql(req, res, "getReview", json["cid"]);
  3330. });
  3331. //查询所有课程专区下的课程
  3332. router.route("/getZoneClass").all((req, res, next) => {
  3333. var json = queryString(req.url);
  3334. getmysql(
  3335. req,
  3336. res,
  3337. "select_zoneClass",
  3338. json["bid"],
  3339. json["oid"],
  3340. json["page"],
  3341. 10
  3342. );
  3343. });
  3344. //查询所有课程专区下的课程
  3345. router.route("/getZoneClass").all((req, res, next) => {
  3346. var json = queryString(req.url);
  3347. getmysql(
  3348. req,
  3349. res,
  3350. "select_zoneClass",
  3351. json["bid"],
  3352. json["oid"],
  3353. json["page"],
  3354. 10
  3355. );
  3356. });
  3357. //查询所有课程专区下的课程
  3358. router.route("/getZoneClassStudent").all((req, res, next) => {
  3359. var json = queryString(req.url);
  3360. getmysql(
  3361. req,
  3362. res,
  3363. "select_zoneClass",
  3364. json["bid"],
  3365. json["oid"],
  3366. json["page"],
  3367. 20
  3368. );
  3369. });
  3370. //admin 后台查看专区下课程的数量
  3371. router.route("/getZoneClassNum").all((req, res, next) => {
  3372. var json = queryString(req.url);
  3373. getmysql(req, res, "select_zoneClassNum", json["bid"]);
  3374. });
  3375. //admin 后台添加课程专区时查看课程是否在此专区重复
  3376. router.route("/getZoneClassRepeat").all((req, res, next) => {
  3377. var json = queryString(req.url);
  3378. getmysql(req, res, "select_zoneClassRepeat", json["pid"], json["cid"]);
  3379. });
  3380. //把课程添加进专区
  3381. router.route("/addZoneCourse").all((req, res, next) => {
  3382. postmysql(req, res, "insert_app");
  3383. });
  3384. //admin 删除课程专区底下的课程
  3385. router.route("/deleteZoneCourse").all((req, res, next) => {
  3386. postmysql(req, res, "delete_app");
  3387. });
  3388. //admin 删除班级
  3389. router.route("/deleteZone").all((req, res, next) => {
  3390. postmysql(req, res, "delete_zone");
  3391. });
  3392. //admin 后台专区上移下移
  3393. router.route("/zoneRank").all((req, res, next) => {
  3394. postmysql(req, res, "update_classRank");
  3395. });
  3396. //admin 添加模板文档
  3397. router.route("/addTemplateAdmin").all((req, res, next) => {
  3398. postmysql(req, res, "add_template");
  3399. });
  3400. //admin 添加模板文档
  3401. router.route("/deleteTemplateAdmin").all((req, res, next) => {
  3402. postmysql(req, res, "delete_template");
  3403. });
  3404. //admin 查询模板文档
  3405. router.route("/getTemplateAdmin").all((req, res, next) => {
  3406. var json = queryString(req.url);
  3407. getmysql(req, res, "select_template", json["page"], 10);
  3408. });
  3409. //查询上传作业
  3410. router.route("/getCourseWorks").all((req, res, next) => {
  3411. var json = queryString(req.url); //cid 课程id,page 页数
  3412. getmysql(
  3413. req,
  3414. res,
  3415. "select_courseWorks",
  3416. json["cid"],
  3417. json["stage"],
  3418. json["task"],
  3419. json["page"],
  3420. 10
  3421. );
  3422. });
  3423. //查询上传作业
  3424. router.route("/getCourseWorks2").all((req, res, next) => {
  3425. var json = queryString(req.url); //cid 课程id,page 页数
  3426. getmysql(
  3427. req,
  3428. res,
  3429. "select_courseWorks2",
  3430. json["cid"],
  3431. json["uname"],
  3432. json["stage"],
  3433. json["task"],
  3434. json["page"],
  3435. 10
  3436. );
  3437. });
  3438. //查询上传作业
  3439. router.route("/getCourseWorks3").all((req, res, next) => {
  3440. var json = queryString(req.url); //cid 课程id,page 页数
  3441. getmysql(
  3442. req,
  3443. res,
  3444. "select_courseWorks3",
  3445. json["cid"],
  3446. json["uname"],
  3447. json["stage"],
  3448. json["task"],
  3449. json["page"],
  3450. 10
  3451. );
  3452. });
  3453. //查询所有学生上传作业
  3454. router.route("/getCourseWorks4").all((req, res, next) => {
  3455. var json = queryString(req.url); //cid 课程id,page 页数
  3456. getmysql(
  3457. req,
  3458. res,
  3459. "select_courseWorks4",
  3460. json["cid"],
  3461. json["uname"],
  3462. json["stage"],
  3463. json["task"]
  3464. );
  3465. });
  3466. //查询学生课程作业
  3467. router.route("/selectStudentCourseWorks").all((req, res, next) => {
  3468. var json = queryString(req.url); //cid 课程id,page 页数
  3469. getmysql(
  3470. req,
  3471. res,
  3472. "selectStudentCourseWorks",
  3473. json["uid"],
  3474. json["cid"],
  3475. json["stage"],
  3476. json["task"],
  3477. json["page"],
  3478. 10
  3479. );
  3480. });
  3481. //查询报告数据
  3482. router.route("/getCourseWorksReport").all((req, res, next) => {
  3483. var json = queryString(req.url); //cid 课程id,page 页数
  3484. getmysql(req, res, "getCourseWorksReport", json["cid"]);
  3485. });
  3486. //查询多个课程报告数据
  3487. router.route("/getCourseWorksReportMore").all((req, res, next) => {
  3488. var json = queryString(req.url); //cid 课程id,page 页数
  3489. getmysql(req, res, "getCourseWorksReportMore", json["cid"]);
  3490. });
  3491. //查询学生课程报告数据
  3492. router.route("/getStudentCourseWorksReport").all((req, res, next) => {
  3493. var json = queryString(req.url); //cid 课程id,page 页数
  3494. getmysql(req, res, "getStudentCourseWorksReport", json["uid"]);
  3495. });
  3496. //admin 添加项目模板文档
  3497. router.route("/addCourseTemplateAdmin").all((req, res, next) => {
  3498. postmysql(req, res, "add_courseTemplate");
  3499. });
  3500. //admin 添加项目模板文档
  3501. router.route("/deleteCourseTemplateAdmin").all((req, res, next) => {
  3502. postmysql(req, res, "delete_courseTemplate");
  3503. });
  3504. //admin 查询项目模板文档
  3505. router.route("/getCourseTemplateAdmin").all((req, res, next) => {
  3506. var json = queryString(req.url);
  3507. getmysql(req, res, "select_courseTemplate", json["page"], 10);
  3508. });
  3509. //teacher 查询项目模板
  3510. router.route("/getCourseTemplateT").all((req, res, next) => {
  3511. var json = queryString(req.url);
  3512. getmysql(req, res, "select_courseTemplateT");
  3513. });
  3514. //teacher 查询项目模板
  3515. router.route("/getCourseTemplateTByOid").all((req, res, next) => {
  3516. var json = queryString(req.url);
  3517. getmysql(req, res, "getCourseTemplateTByOid", json["oid"]);
  3518. });
  3519. //teacher 查询项目模板
  3520. router.route("/getCourseTemplateTs").all((req, res, next) => {
  3521. var json = queryString(req.url);
  3522. getmysql(req, res, "getCourseTemplateTs", json["oid"]);
  3523. });
  3524. //teacher 查询项目模板
  3525. router.route("/getCourseTemplateTStudio").all((req, res, next) => {
  3526. var json = queryString(req.url);
  3527. getmysql(req, res, "getCourseTemplateTStudio", json["oid"]);
  3528. });
  3529. //admin 查询课程
  3530. router.route("/getCourseAdmin").all((req, res, next) => {
  3531. var json = queryString(req.url);
  3532. getmysql(req, res, "select_courseAdmin", json["cn"], json["page"], 10);
  3533. });
  3534. //admin 查询模板文档
  3535. router.route("/deleteCourseAdmin").all((req, res, next) => {
  3536. postmysql(req, res, "delete_courseAdmin");
  3537. });
  3538. //设置分组
  3539. router.route("/setCourseGroup").all((req, res, next) => {
  3540. postmysql(req, res, "setCourseGroup");
  3541. });
  3542. //删除分组
  3543. router.route("/deleteCourseGroup").all((req, res, next) => {
  3544. postmysql(req, res, "deleteCourseGroup");
  3545. });
  3546. //获取分组
  3547. router.route("/getCourseGroup").all((req, res, next) => {
  3548. var json = queryString(req.url);
  3549. getmysql(req, res, "getCourseGroup", json["cid"], json["classid"]);
  3550. });
  3551. //加入分组
  3552. router.route("/joinCourseGroup").all((req, res, next) => {
  3553. postmysql(req, res, "joinCourseGroup");
  3554. });
  3555. //退出分组
  3556. router.route("/exitCourseGroup").all((req, res, next) => {
  3557. postmysql(req, res, "exitCourseGroup");
  3558. });
  3559. //加入分组
  3560. router.route("/joinGroup").all((req, res, next) => {
  3561. postmysql(req, res, "joinGroup");
  3562. });
  3563. //退出分组
  3564. router.route("/exitGroup").all((req, res, next) => {
  3565. postmysql(req, res, "exitGroup");
  3566. });
  3567. //查看分组
  3568. router.route("/selectGroup").all((req, res, next) => {
  3569. postmysql(req, res, "selectGroup");
  3570. });
  3571. //查询ppt在哪页
  3572. router.route("/selectPptPage").all((req, res, next) => {
  3573. var json = queryString(req.url);
  3574. getmysql(req, res, "selectPptPage", json["id"]);
  3575. });
  3576. //修改ppt页码
  3577. router.route("/updatePptPage").all((req, res, next) => {
  3578. postmysql(req, res, "updatePptPage");
  3579. });
  3580. //修改ppt操作
  3581. router.route("/updatePPTHandle").all((req, res, next) => {
  3582. postmysql(req, res, "updatePPTHandle");
  3583. });
  3584. //查询实时课堂
  3585. router.route("/getRealTimeClass").all((req, res, next) => {
  3586. var json = queryString(req.url);
  3587. getmysql(
  3588. req,
  3589. res,
  3590. "getRealTimeClass",
  3591. json["cn"],
  3592. json["uid"],
  3593. json["page"],
  3594. 10
  3595. );
  3596. });
  3597. //查询实时课堂学生
  3598. router.route("/getRealTimeClassStu").all((req, res, next) => {
  3599. var json = queryString(req.url);
  3600. getmysql(
  3601. req,
  3602. res,
  3603. "getRealTimeClassStu",
  3604. json["oid"],
  3605. json["cid"],
  3606. json["page"],
  3607. 10
  3608. );
  3609. });
  3610. //查询实时课堂学生
  3611. router.route("/getRealTimeClassById").all((req, res, next) => {
  3612. var json = queryString(req.url);
  3613. getmysql(req, res, "getRealTimeClassById", json["id"]);
  3614. });
  3615. //根据区级管理者查询案例
  3616. router.route("/selectAnliList").all((req, res, next) => {
  3617. var json = queryString(req.url);
  3618. getmysql(
  3619. req,
  3620. res,
  3621. "selectAnliList",
  3622. json["typea"],
  3623. json["typeb"],
  3624. json["typec"],
  3625. json["typed"],
  3626. json["typeE"],
  3627. json["cn"],
  3628. json["cid"],
  3629. json["title"],
  3630. json["page"],
  3631. 10
  3632. );
  3633. });
  3634. //根据市级管理者查询案例
  3635. router.route("/selectAnliList1").all((req, res, next) => {
  3636. var json = queryString(req.url);
  3637. getmysql(
  3638. req,
  3639. res,
  3640. "selectAnliList1",
  3641. json["typea"],
  3642. json["typeb"],
  3643. json["typec"],
  3644. json["typed"],
  3645. json["typeE"],
  3646. json["cn"],
  3647. json["cid"],
  3648. json["title"],
  3649. json["page"],
  3650. 10
  3651. );
  3652. });
  3653. //根据省级级管理者查询案例
  3654. router.route("/selectAnliList2").all((req, res, next) => {
  3655. var json = queryString(req.url);
  3656. getmysql(
  3657. req,
  3658. res,
  3659. "selectAnliList2",
  3660. json["typea"],
  3661. json["typeb"],
  3662. json["typec"],
  3663. json["typed"],
  3664. json["typeE"],
  3665. json["cn"],
  3666. json["cid"],
  3667. json["title"],
  3668. json["page"],
  3669. 10
  3670. );
  3671. });
  3672. //删除案例
  3673. router.route("/deleteAnli").all((req, res, next) => {
  3674. var json = queryString(req.url);
  3675. getmysql(req, res, "deleteAnli", json["id"]);
  3676. });
  3677. //根据区县管理者查询评分
  3678. router.route("/selectPoint").all((req, res, next) => {
  3679. var json = queryString(req.url);
  3680. getmysql(
  3681. req,
  3682. res,
  3683. "selectPoint",
  3684. json["typea"],
  3685. json["typeb"],
  3686. json["typec"],
  3687. json["typed"],
  3688. json["typeE"],
  3689. json["cn"],
  3690. json["cid"],
  3691. json["title"],
  3692. json["page"],
  3693. 10
  3694. );
  3695. });
  3696. //根据市级管理者查询评分
  3697. router.route("/selectPoint1").all((req, res, next) => {
  3698. var json = queryString(req.url);
  3699. getmysql(
  3700. req,
  3701. res,
  3702. "selectPoint1",
  3703. json["typea"],
  3704. json["typeb"],
  3705. json["typec"],
  3706. json["typed"],
  3707. json["typeE"],
  3708. json["cn"],
  3709. json["cid"],
  3710. json["title"],
  3711. json["page"],
  3712. 10
  3713. );
  3714. });
  3715. //根据市级管理者查询全部评分
  3716. router.route("/selectPointAll").all((req, res, next) => {
  3717. var json = queryString(req.url);
  3718. getmysql(
  3719. req,
  3720. res,
  3721. "selectPointAll",
  3722. json["typea"],
  3723. json["typeb"],
  3724. json["typec"],
  3725. json["typed"],
  3726. json["typeE"],
  3727. json["cn"],
  3728. json["cid"],
  3729. json["title"]
  3730. );
  3731. });
  3732. //查询分配案例
  3733. router.route("/selectCaseUser").all((req, res, next) => {
  3734. var json = queryString(req.url);
  3735. getmysql(req, res, "select_case", json["uid"]);
  3736. });
  3737. //根据用户id,课程id,阶段,任务,工具去查询协同
  3738. router.route("/selectWord").all((req, res, next) => {
  3739. var json = queryString(req.url);
  3740. getmysql(
  3741. req,
  3742. res,
  3743. "selectWord",
  3744. json["uid"],
  3745. json["cid"],
  3746. json["s"],
  3747. json["task"],
  3748. json["t"]
  3749. );
  3750. });
  3751. //根据用户id,课程id,阶段,任务,工具去查询协同
  3752. router.route("/selectWord2").all((req, res, next) => {
  3753. var json = queryString(req.url);
  3754. getmysql(
  3755. req,
  3756. res,
  3757. "selectWord2",
  3758. json["uid"],
  3759. json["cid"],
  3760. json["s"],
  3761. json["task"],
  3762. json["t"],
  3763. json["type"]
  3764. );
  3765. });
  3766. //根据用户id,课程id,阶段,任务,工具去查询协同
  3767. router.route("/selectWords").all((req, res, next) => {
  3768. var json = queryString(req.url);
  3769. getmysql(
  3770. req,
  3771. res,
  3772. "selectWords",
  3773. json["uid"],
  3774. json["cid"],
  3775. json["s"],
  3776. json["task"],
  3777. json["t"],
  3778. json["type"]
  3779. );
  3780. });
  3781. //根据用户id,课程id,阶段,任务,工具去查询协同
  3782. router.route("/selectWordsY").all((req, res, next) => {
  3783. var json = queryString(req.url);
  3784. getmysql(
  3785. req,
  3786. res,
  3787. "selectWordsY",
  3788. json["uid"],
  3789. json["cid"],
  3790. json["s"],
  3791. json["task"],
  3792. json["t"],
  3793. json["type"]
  3794. );
  3795. });
  3796. //新增协同内容
  3797. router.route("/insertWord2y").all((req, res, next) => {
  3798. var json = queryString(req.url);
  3799. // getmysql(req, res, "insertWord2y", json["uid"], json["cid"], json["s"], json["task"], json["t"], json["text"], json["type"]);
  3800. postmysql3(req, res, "insertWord2y");
  3801. });
  3802. //新增协同内容
  3803. router.route("/insertWord").all((req, res, next) => {
  3804. var json = queryString(req.url);
  3805. getmysql(
  3806. req,
  3807. res,
  3808. "insertWord",
  3809. json["uid"],
  3810. json["cid"],
  3811. json["s"],
  3812. json["task"],
  3813. json["t"],
  3814. json["text"]
  3815. );
  3816. });
  3817. //分配案例
  3818. router.route("/insertCase").all((req, res, next) => {
  3819. if (req.body[0]) {
  3820. p = [req.body[0].uid, req.body[0].box];
  3821. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "insertCase"); //執行存儲過程
  3822. mysql.usselect(p, function(ret) {
  3823. res.end(JSON.stringify({ success: 1 }));
  3824. });
  3825. }
  3826. });
  3827. //新增评分
  3828. router.route("/addScore").all((req, res, next) => {
  3829. var json = queryString(req.url);
  3830. getmysql(req, res, "addScore", json["rid"], json["suser"], json["s"]);
  3831. });
  3832. //查询评分
  3833. router.route("/selectScore").all((req, res, next) => {
  3834. var json = queryString(req.url);
  3835. getmysql(req, res, "selectScore", json["rid"], json["suser"]);
  3836. });
  3837. //查询所有评分
  3838. router.route("/selectAllScore").all((req, res, next) => {
  3839. var json = queryString(req.url);
  3840. getmysql(req, res, "selectAllScore");
  3841. });
  3842. //查询单个案例所有评分
  3843. router.route("/selectAnliScore").all((req, res, next) => {
  3844. var json = queryString(req.url);
  3845. getmysql(req, res, "selectAnliScore", json["rid"]);
  3846. });
  3847. //赛事推荐
  3848. router.route("/updateRaceRec").all((req, res, next) => {
  3849. var json = queryString(req.url);
  3850. getmysql(req, res, "updateRaceRec", json["id"], json["rec"]);
  3851. });
  3852. //查询数据报告学生报告列表
  3853. router.route("/selectSr").all((req, res, next) => {
  3854. var json = queryString(req.url);
  3855. getmysql(
  3856. req,
  3857. res,
  3858. "selectSr",
  3859. json["cu"],
  3860. json["cn"],
  3861. json["oid"],
  3862. json["page"],
  3863. 10
  3864. );
  3865. });
  3866. //查询数据报告班级报告列表
  3867. router.route("/selectCr").all((req, res, next) => {
  3868. var json = queryString(req.url);
  3869. getmysql(
  3870. req,
  3871. res,
  3872. "selectCr",
  3873. json["cu"],
  3874. json["cn"],
  3875. json["oid"],
  3876. json["page"],
  3877. 10
  3878. );
  3879. });
  3880. //查询数据报告查看班级报告底下学生列表
  3881. router.route("/selectCStudent").all((req, res, next) => {
  3882. var json = queryString(req.url);
  3883. getmysql(req, res, "selectCStudent", json["cid"], json["courseid"]);
  3884. });
  3885. //查询数据报告课程报告列表
  3886. router.route("/selectCourseR").all((req, res, next) => {
  3887. var json = queryString(req.url);
  3888. getmysql(
  3889. req,
  3890. res,
  3891. "selectCourseR",
  3892. json["cu"],
  3893. json["cn"],
  3894. json["cl"],
  3895. json["oid"],
  3896. json["page"],
  3897. 10
  3898. );
  3899. });
  3900. //根据学校id查询学校底下有评价的课程
  3901. router.route("/selectCourseByOid").all((req, res, next) => {
  3902. var json = queryString(req.url);
  3903. getmysql(req, res, "selectCourseByOid", json["oid"]);
  3904. });
  3905. //根据目标id和班级id查询底下有作业的课程
  3906. router.route("/selectEvaCourse").all((req, res, next) => {
  3907. var json = queryString(req.url);
  3908. getmysql(req, res, "selectEvaCourse", json["eid"], json["cid"]);
  3909. });
  3910. //teacher 查询模板
  3911. router.route("/getTemplateT").all((req, res, next) => {
  3912. var json = queryString(req.url);
  3913. getmysql(req, res, "select_templateT");
  3914. });
  3915. //思维网格 创建房间
  3916. router.route("/insertRoom").all((req, res, next) => {
  3917. postmysql(req, res, "insertRoom");
  3918. });
  3919. //删除作业阶段任务工具
  3920. router.route("/deleteStudentToolSTT").all((req, res, next) => {
  3921. postmysql(req, res, "deleteStudentToolSTT");
  3922. });
  3923. //删除作业阶段任务
  3924. router.route("/deleteStudentToolST").all((req, res, next) => {
  3925. postmysql(req, res, "deleteStudentToolST");
  3926. });
  3927. //删除作业阶段
  3928. router.route("/deleteStudentToolS").all((req, res, next) => {
  3929. postmysql(req, res, "deleteStudentToolST");
  3930. });
  3931. //协同编辑 创建房间
  3932. router.route("/insertRoomByFile").all((req, res, next) => {
  3933. //var json = queryString(req.url);
  3934. postmysql2(req, res, "insertRoomByFile");
  3935. //getmysql(req, res, "insertRoomByFile", json["uid"], json["n"], json["d"]);
  3936. });
  3937. //思维网格 查询是否是重复房间号
  3938. router.route("/checkRoomNum").all((req, res, next) => {
  3939. var json = queryString(req.url);
  3940. getmysql(req, res, "checkRoomNum", json["num"]);
  3941. });
  3942. //思维网格 查询房间列表
  3943. router.route("/selectRoomList").all((req, res, next) => {
  3944. var json = queryString(req.url);
  3945. getmysql(
  3946. req,
  3947. res,
  3948. "selectRoomList",
  3949. json["uid"],
  3950. json["oid"],
  3951. json["cid"],
  3952. json["cu"],
  3953. json["cn"]
  3954. );
  3955. });
  3956. //查询pdf列表
  3957. router.route("/selectRTC").all((req, res, next) => {
  3958. var json = queryString(req.url);
  3959. getmysql(req, res, "selectRTC", json["uid"], json["cu"], json["cn"]);
  3960. });
  3961. //协同文档 查询房间列表
  3962. router.route("/selectFileList").all((req, res, next) => {
  3963. var json = queryString(req.url);
  3964. getmysql(
  3965. req,
  3966. res,
  3967. "selectFileList",
  3968. json["uid"],
  3969. json["oid"],
  3970. json["cid"],
  3971. json["cu"],
  3972. json["cn"]
  3973. );
  3974. });
  3975. //协同编辑 查询是否是重复房间号
  3976. router.route("/checkRoomNumByFile").all((req, res, next) => {
  3977. var json = queryString(req.url);
  3978. getmysql(req, res, "checkRoomNumByFile", json["num"]);
  3979. });
  3980. //思维网格 根据房间号或者用户id查询房间信息
  3981. router.route("/selectRoom").all((req, res, next) => {
  3982. var json = queryString(req.url);
  3983. getmysql(req, res, "selectRoom", json["uid"]);
  3984. });
  3985. //思维网格 根据房间号或者用户id查询房间信息
  3986. router.route("/getRoom").all((req, res, next) => {
  3987. var json = queryString(req.url);
  3988. getmysql(req, res, "select_room", json["fid"]);
  3989. });
  3990. //协同编辑 根据房间号或者用户id查询房间信息
  3991. router.route("/selectRoomByFile").all((req, res, next) => {
  3992. var json = queryString(req.url);
  3993. getmysql(req, res, "selectRoomByFile", json["uid"]);
  3994. });
  3995. //思维网格 修改房间数据
  3996. router.route("/updateRoomData").all((req, res, next) => {
  3997. postmysql(req, res, "updateRoomData");
  3998. });
  3999. router.route("/updateFileData").all((req, res, next) => {
  4000. var json = queryString(req.url);
  4001. var json2 = json["mode"].split(",");
  4002. getmysql(req, res, "updateFileData", json2[0], json2[1]);
  4003. });
  4004. router.route("/select_file").all((req, res, next) => {
  4005. var json = queryString(req.url);
  4006. getmysql(req, res, "select_file", json["fid"]);
  4007. });
  4008. //思维网格 解散房间
  4009. router.route("/dismiss").all((req, res, next) => {
  4010. postmysql(req, res, "update_room");
  4011. });
  4012. //提交提问
  4013. router.route("/addProblem").all((req, res, next) => {
  4014. postmysql(req, res, "add_problem");
  4015. //cid 课程id,chid 章节id,t 提问内容,uid 用户id
  4016. });
  4017. //查询提交的提问
  4018. router.route("/getProblem").all((req, res, next) => {
  4019. var json = queryString(req.url); //cid 课程id,page 页数
  4020. getmysql(req, res, "select_problem", json["cid"], json["page"], 10);
  4021. });
  4022. //获取用户基本信息
  4023. router.route("/getUserInfo").all((req, res, next) => {
  4024. var json = queryString(req.url);
  4025. getmysql(req, res, "getUserInfo", json["uid"], json["cid"]);
  4026. });
  4027. //获取用户多个课程基本信息
  4028. router.route("/getUserInfoMore").all((req, res, next) => {
  4029. var json = queryString(req.url);
  4030. getmysql(req, res, "getUserInfoMore", json["uid"], json["cid"]);
  4031. });
  4032. //获取多个用户单个课程基本信息
  4033. router.route("/getClassUserInfoMore").all((req, res, next) => {
  4034. var json = queryString(req.url);
  4035. getmysql(req, res, "getClassUserInfoMore", json["uid"], json["cid"]);
  4036. });
  4037. //获取课程下所有有作业的学生id
  4038. router.route("/selectCourseSuid").all((req, res, next) => {
  4039. var json = queryString(req.url);
  4040. getmysql(req, res, "selectCourseSuid", json["cid"], json["courseid"]);
  4041. });
  4042. //获取项目基本信息
  4043. router.route("/getCourseInfo").all((req, res, next) => {
  4044. var json = queryString(req.url);
  4045. getmysql(req, res, "getCourseInfo", json["cid"]);
  4046. });
  4047. //获取多个项目基本信息
  4048. router.route("/getCourseInfoMore").all((req, res, next) => {
  4049. var json = queryString(req.url);
  4050. getmysql(req, res, "getCourseInfoMore", json["cid"]);
  4051. });
  4052. //获取用户基本信息
  4053. router.route("/getAllUserById").all((req, res, next) => {
  4054. var json = queryString(req.url);
  4055. getmysql(req, res, "getAllUserById", json["uid"]);
  4056. });
  4057. //作业生成报告
  4058. router.route("/getWorkData").all((req, res, next) => {
  4059. var json = queryString(req.url); //cid 课程id,page 页数
  4060. getmysql(req, res, "select_work_data", json["cid"]);
  4061. });
  4062. //查询评价体系
  4063. router.route("/getEvaluation").all((req, res, next) => {
  4064. var json = queryString(req.url); //cid 课程id,page 页数
  4065. getmysql(
  4066. req,
  4067. res,
  4068. "select_evaluation",
  4069. json["oid"],
  4070. json["n"],
  4071. json["page"],
  4072. 10
  4073. );
  4074. });
  4075. //添加评价体系
  4076. router.route("/addEvaluation").all((req, res, next) => {
  4077. postmysql(req, res, "add_evaluation");
  4078. //uid 用户id t标题 c内容
  4079. });
  4080. //修改评价体系
  4081. router.route("/updateEvaluation").all((req, res, next) => {
  4082. postmysql(req, res, "update_evaluation");
  4083. //c内容 t标题 id评价id
  4084. });
  4085. //删除评价体系
  4086. router.route("/deleteEvaluation").all((req, res, next) => {
  4087. postmysql(req, res, "delete_evaluation");
  4088. // id评价id
  4089. });
  4090. //删除评价体系前查询课程是否有该评价
  4091. router.route("/selectCourseEva").all((req, res, next) => {
  4092. var json = queryString(req.url); //cid 课程id,page 页数
  4093. getmysql(
  4094. req,
  4095. res,
  4096. "select_course_eva",
  4097. json["eid"],
  4098. );
  4099. });
  4100. //批量添加学校
  4101. router.route("/batchRegistrationSchool").post(function(req, res, next) {
  4102. let users = req.body[0];
  4103. let arr = JSON.parse(req.body[0].arr);
  4104. for (let i = 0; i < arr.length; i++) {
  4105. let _school = arr[i].school;
  4106. let _org = users.org;
  4107. //用戶數據
  4108. let _data = [_school, _org, "", "1", ""];
  4109. //參數拼接,註冊
  4110. _data.unshift(_mysqlLabor[0], _mysqlLabor[1], "insertSchoolByOrg");
  4111. //用戶註冊處理
  4112. mysql.usselect(_data, function(ret) {
  4113. res.end(JSON.stringify({ success: 1 }));
  4114. });
  4115. }
  4116. });
  4117. //批量添加学生
  4118. router.route("/batchRegistrationMore").post(function(req, res, next) {
  4119. let users = req.body[0];
  4120. let arr = JSON.parse(req.body[0].arr);
  4121. for (let i = 0; i < arr.length; i++) {
  4122. let _username = arr[i].name;
  4123. let _mail = arr[i].mail;
  4124. let _password = users.password || "123456";
  4125. let _alias = arr[i].name;
  4126. let _oid = users.oid;
  4127. let _ph = arr[i].phone ? arr[i].phone : "";
  4128. let _class = arr[i].class;
  4129. let _sId = arr[i].sId;
  4130. //加密密碼
  4131. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  4132. //生成激活碼
  4133. let _hashstr = new Date().getTime() + "";
  4134. let _digest = crypto
  4135. .createHash("sha256")
  4136. .update(_hashstr, "utf8")
  4137. .digest("hex");
  4138. //用戶數據
  4139. let _userdata = [
  4140. _mail,
  4141. _password,
  4142. _alias,
  4143. "",
  4144. 1, //0老师 1学生
  4145. _username,
  4146. "",
  4147. generateAPIKey(_username),
  4148. _digest,
  4149. "",
  4150. _username,
  4151. _sId,
  4152. 2, //1老师 2学生
  4153. _oid,
  4154. _ph,
  4155. _class,
  4156. "",
  4157. "0",
  4158. ];
  4159. //參數拼接,註冊
  4160. _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister");
  4161. //用戶註冊處理
  4162. mysql.usselect(_userdata, function(ret) {
  4163. // let _pbluserdata = [
  4164. // ret[1][0].uid,
  4165. // _username,
  4166. // _sId,
  4167. // 2,
  4168. // _oid,
  4169. // _ph,
  4170. // _class,
  4171. // '',
  4172. // "0",
  4173. // ];
  4174. // _pbluserdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateUserByEdu");
  4175. // mysql.usselect(_pbluserdata, function(ret) {
  4176. res.end(JSON.stringify({ success: 1 }));
  4177. // });
  4178. });
  4179. }
  4180. });
  4181. //初始化密码
  4182. router.route("/iniPassword").post(function(req, res, next) {
  4183. let users = req.body[0];
  4184. _password = users.pa;
  4185. //加密密碼
  4186. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  4187. //用戶數據
  4188. let _userList = [users.uid, _password];
  4189. _userList.unshift(_mysqlLabor[0], _mysqlLabor[1], "iniPassword");
  4190. mysql.usselect(_userList, function(ret) {
  4191. res.end(JSON.stringify({ success: 1 }));
  4192. });
  4193. });
  4194. //批量添加教师
  4195. router.route("/batchRegistrationMore1").post(function(req, res, next) {
  4196. let users = req.body[0];
  4197. let arr = JSON.parse(req.body[0].arr);
  4198. for (let i = 0; i < arr.length; i++) {
  4199. let _username = arr[i].name;
  4200. let _mail = arr[i].mail;
  4201. let _password = users.password || "123456";
  4202. let _alias = arr[i].name;
  4203. let _org = users.org;
  4204. let _oid = arr[i].school;
  4205. let _ph = arr[i].phone ? arr[i].phone : "";
  4206. let _class = arr[i].class;
  4207. let _sId = arr[i].sId;
  4208. //加密密碼
  4209. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  4210. //生成激活碼
  4211. let _hashstr = new Date().getTime() + "";
  4212. let _digest = crypto
  4213. .createHash("sha256")
  4214. .update(_hashstr, "utf8")
  4215. .digest("hex");
  4216. //用戶數據
  4217. let _userdata = [
  4218. _mail,
  4219. _password,
  4220. _alias,
  4221. "",
  4222. 0, //0老师 1学生
  4223. _username,
  4224. "",
  4225. generateAPIKey(_username),
  4226. _digest,
  4227. "",
  4228. _username,
  4229. _sId,
  4230. 1, //1老师 2学生
  4231. _org,
  4232. _oid,
  4233. "",
  4234. "",
  4235. "",
  4236. "0",
  4237. ];
  4238. //參數拼接,註冊
  4239. _userdata.unshift(
  4240. _mysqluser[0],
  4241. _mysqluser[1],
  4242. "pbl_add_batchregister_oid"
  4243. );
  4244. //用戶註冊處理
  4245. mysql.usselect(_userdata, function(ret) {
  4246. res.end(JSON.stringify({ success: 1 }));
  4247. });
  4248. }
  4249. });
  4250. //赛事批量注册老师
  4251. router.route("/pbl_add_raceuser_oid").post(function(req, res, next) {
  4252. let users = req.body[0];
  4253. let arr = JSON.parse(req.body[0].arr);
  4254. for (let i = 0; i < arr.length; i++) {
  4255. let _username = arr[i].name;
  4256. let _mail = arr[i].mail;
  4257. let _password = users.password || "123456";
  4258. let _oid = arr[i].school;
  4259. //加密密碼
  4260. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  4261. //生成激活碼
  4262. let _hashstr = new Date().getTime() + "";
  4263. let _digest = crypto
  4264. .createHash("sha256")
  4265. .update(_hashstr, "utf8")
  4266. .digest("hex");
  4267. //用戶數據
  4268. let _userdata = [
  4269. _mail,
  4270. _oid,
  4271. _password,
  4272. _username,
  4273. 1, //1普通教师 2市级 3省级 4市级子级评委 5县区评委 6县区子级
  4274. ];
  4275. //參數拼接,註冊
  4276. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "pbl_add_raceuser_oid");
  4277. //用戶註冊處理
  4278. mysql.usselect(_userdata, function(ret) {
  4279. res.end(JSON.stringify({ success: 1 }));
  4280. });
  4281. }
  4282. });
  4283. //新增学生
  4284. router.route("/batchRegistration").post(function(req, res, next) {
  4285. var users = req.body[0];
  4286. //循环注册
  4287. var _username = users.alias;
  4288. var _mail = users.username;
  4289. var _password = users.password || "123456";
  4290. var _alias = users.alias;
  4291. var _oid = users.oid;
  4292. var _ph = users.ph;
  4293. var _class = users.cid;
  4294. var _sId = users.sid;
  4295. //加密密碼
  4296. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  4297. //生成激活碼
  4298. let _hashstr = new Date().getTime() + "";
  4299. let _digest = crypto
  4300. .createHash("sha256")
  4301. .update(_hashstr, "utf8")
  4302. .digest("hex");
  4303. //用戶數據
  4304. var _userdata = [
  4305. _mail,
  4306. _password,
  4307. _alias,
  4308. "",
  4309. 1,
  4310. _username,
  4311. "",
  4312. generateAPIKey(_username),
  4313. _digest,
  4314. "",
  4315. _username,
  4316. _sId,
  4317. 2,
  4318. _oid,
  4319. _ph,
  4320. _class,
  4321. "",
  4322. "0",
  4323. ];
  4324. //參數拼接,註冊
  4325. _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister");
  4326. //用戶註冊處理
  4327. mysql.usselect(_userdata, function(ret) {
  4328. res.end(
  4329. JSON.stringify({
  4330. uid: ret[1][0].uid,
  4331. ph: _ph,
  4332. oid: _oid,
  4333. cid: _class,
  4334. success: 1,
  4335. })
  4336. );
  4337. });
  4338. });
  4339. //新增教师
  4340. router.route("/batchRegistration1").post(function(req, res, next) {
  4341. var users = req.body[0];
  4342. //循环注册
  4343. var _username = users.alias;
  4344. var _mail = users.username;
  4345. var _password = users.password || "123456";
  4346. var _alias = users.alias;
  4347. var _org = users.org;
  4348. var _oid = users.oid;
  4349. var _ph = users.ph;
  4350. var _class = users.cid;
  4351. var _sId = users.sid;
  4352. //加密密碼
  4353. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  4354. //生成激活碼
  4355. let _hashstr = new Date().getTime() + "";
  4356. let _digest = crypto
  4357. .createHash("sha256")
  4358. .update(_hashstr, "utf8")
  4359. .digest("hex");
  4360. //用戶數據
  4361. var _userdata = [
  4362. _mail,
  4363. _password,
  4364. _alias,
  4365. "",
  4366. 0,
  4367. _username,
  4368. "",
  4369. generateAPIKey(_username),
  4370. _digest,
  4371. "",
  4372. _username,
  4373. _sId,
  4374. 1,
  4375. _org,
  4376. _oid,
  4377. _ph,
  4378. _class,
  4379. "",
  4380. "0",
  4381. ];
  4382. //參數拼接,註冊
  4383. _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister1");
  4384. //用戶註冊處理
  4385. mysql.usselect(_userdata, function(ret) {
  4386. res.end(
  4387. JSON.stringify({
  4388. uid: ret[1][0].uid,
  4389. ph: _ph,
  4390. oid: _oid,
  4391. cid: _class,
  4392. success: 1,
  4393. })
  4394. );
  4395. });
  4396. });
  4397. router.route("/batchRegistrationOrg").post(function(req, res, next) {
  4398. var users = req.body[0];
  4399. //循环注册
  4400. var _username = users.alias;
  4401. var _mail = users.username;
  4402. var _password = users.password || "123456";
  4403. var _alias = users.alias;
  4404. var _oid = users.oid;
  4405. var _ph = users.ph;
  4406. var _class = users.cid;
  4407. var _sId = users.sid;
  4408. var _org = users.org;
  4409. //加密密碼
  4410. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  4411. //生成激活碼
  4412. let _hashstr = new Date().getTime() + "";
  4413. let _digest = crypto
  4414. .createHash("sha256")
  4415. .update(_hashstr, "utf8")
  4416. .digest("hex");
  4417. //用戶數據
  4418. var _userdata = [
  4419. _mail,
  4420. _password,
  4421. _alias,
  4422. "",
  4423. 1,
  4424. _username,
  4425. "",
  4426. generateAPIKey(_username),
  4427. _digest,
  4428. "",
  4429. _username,
  4430. _sId,
  4431. 2,
  4432. _oid,
  4433. _ph,
  4434. _class,
  4435. "",
  4436. "0",
  4437. _org,
  4438. ];
  4439. //參數拼接,註冊
  4440. _userdata.unshift(_mysqluser[0], _mysqluser[1], "pbl_add_batchregister_org");
  4441. //用戶註冊處理
  4442. mysql.usselect(_userdata, function(ret) {
  4443. res.end(
  4444. JSON.stringify({
  4445. uid: ret[1][0].uid,
  4446. ph: _ph,
  4447. oid: _oid,
  4448. cid: _class,
  4449. success: 1,
  4450. })
  4451. );
  4452. });
  4453. });
  4454. router.route("/batchRegistrationMoreOrg").post(function(req, res, next) {
  4455. let users = req.body[0];
  4456. let arr = JSON.parse(req.body[0].arr);
  4457. for (let i = 0; i < arr.length; i++) {
  4458. let _username = arr[i].name;
  4459. let _mail = arr[i].mail;
  4460. let _password = users.password || "123456";
  4461. let _alias = arr[i].name;
  4462. let _oid = users.oid;
  4463. let _ph = arr[i].phone ? arr[i].phone : "";
  4464. let _class = arr[i].class;
  4465. let _sId = arr[i].sId;
  4466. let _org = users.org;
  4467. //加密密碼
  4468. _password = bcrypt.hashSync(_password, bcrypt.genSaltSync(10));
  4469. //生成激活碼
  4470. let _hashstr = new Date().getTime() + "";
  4471. let _digest = crypto
  4472. .createHash("sha256")
  4473. .update(_hashstr, "utf8")
  4474. .digest("hex");
  4475. //用戶數據
  4476. let _userdata = [
  4477. _mail,
  4478. _password,
  4479. _alias,
  4480. "",
  4481. 1, //0老师 1学生
  4482. _username,
  4483. "",
  4484. generateAPIKey(_username),
  4485. _digest,
  4486. "",
  4487. _username,
  4488. _sId,
  4489. 2, //1老师 2学生
  4490. _oid,
  4491. _ph,
  4492. _class,
  4493. "",
  4494. "0",
  4495. _org,
  4496. ];
  4497. //參數拼接,註冊
  4498. _userdata.unshift(
  4499. _mysqluser[0],
  4500. _mysqluser[1],
  4501. "pbl_add_batchregister_org2"
  4502. );
  4503. //用戶註冊處理
  4504. mysql.usselect(_userdata, function(ret) {
  4505. res.end(JSON.stringify({ success: 1 }));
  4506. });
  4507. }
  4508. });
  4509. //工作室管理
  4510. router.route("/updateStudioWorkNew4").all((req, res, next) => {
  4511. //学生
  4512. if (req.body[0]) {
  4513. let p = [req.body[0].cid];
  4514. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_studio_course_detail2"); //執行存儲過程
  4515. mysql.usselect(p, function(ret) {
  4516. let _unitIndex = parseInt(req.body[0].unitIndex);
  4517. let _chapters = JSON.parse(req.body[0].chapters);
  4518. let _unitJson = JSON.parse(ret[0][0].chapters);
  4519. if (_unitJson.length - 1 < _unitIndex) {
  4520. let _i = _unitIndex - (_unitJson.length - 1);
  4521. for (let i = 0; i < _i; i++) {
  4522. _unitJson.push({
  4523. dyName: "", //单元标题
  4524. chapterInfo: [{
  4525. isread: false,
  4526. chapterid: guid(),
  4527. title: "",
  4528. courseName: "",
  4529. taskJson: [{
  4530. task: "",
  4531. taskDetail: "",
  4532. chapterData: [],
  4533. toolText: "",
  4534. toolChoose: [{
  4535. tool: [],
  4536. toolDetail: "",
  4537. toolType: 0,
  4538. askCount: 1,
  4539. askTitle: "",
  4540. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  4541. }, ],
  4542. isShowTools: false,
  4543. askCount: 1,
  4544. isFold: 0,
  4545. askTitle: "",
  4546. askJson: [{ askstitle: "", askItem: 1, checkList: [] }],
  4547. checkJson: [{ checkCount: [], checkPerent: [] }],
  4548. homeworkList: [],
  4549. }, ],
  4550. itemCount: 1,
  4551. fileList1: [],
  4552. video: [],
  4553. testData: [],
  4554. pData: [],
  4555. templateArray: [],
  4556. }, ],
  4557. });
  4558. }
  4559. _unitJson[_unitIndex] = _chapters[_unitIndex];
  4560. } else {
  4561. _unitJson[_unitIndex] = _chapters[_unitIndex];
  4562. }
  4563. // console.log(_unitJson);
  4564. let p2 = [
  4565. req.body[0].cid,
  4566. JSON.stringify(_unitJson).replaceAll(/%/g, "%25"),
  4567. ];
  4568. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudioWorkNew4"); //執行存儲過程
  4569. mysql.usselect(p2, function(ret) {
  4570. res.end(JSON.stringify({ success: 1 }));
  4571. });
  4572. // res.end(JSON.stringify({ success: 1 }));
  4573. });
  4574. }
  4575. });
  4576. router.route("/updateStudioWorkNew2").all((req, res, next) => {
  4577. //学生
  4578. if (req.body[0]) {
  4579. p = [
  4580. req.body[0].cid,
  4581. req.body[0].title,
  4582. req.body[0].brief,
  4583. req.body[0].cover,
  4584. req.body[0].evaId,
  4585. req.body[0].astudent,
  4586. req.body[0].see,
  4587. req.body[0].chapters,
  4588. req.body[0].template,
  4589. req.body[0].ateacher,
  4590. ];
  4591. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudioWorkNew2"); //執行存儲過程
  4592. mysql.usselect(p, function(ret) {
  4593. let course = req.body[0].courseType;
  4594. let courseId = req.body[0].cid;
  4595. let userid = req.body[0].uid;
  4596. delStudioCourseTypeS(course, courseId, userid);
  4597. res.end(JSON.stringify({ success: 1 }));
  4598. });
  4599. }
  4600. });
  4601. router.route("/addStudioCourseWorkNew2").all((req, res, next) => {
  4602. //学生
  4603. if (req.body[0]) {
  4604. p = [
  4605. req.body[0].uid,
  4606. req.body[0].title,
  4607. req.body[0].brief,
  4608. req.body[0].cover,
  4609. req.body[0].evaId,
  4610. req.body[0].astudent,
  4611. req.body[0].see,
  4612. req.body[0].chapters,
  4613. req.body[0].template,
  4614. req.body[0].ateacher,
  4615. ];
  4616. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addStudioCourseWorkNew2"); //執行存儲過程
  4617. mysql.usselect(p, function(ret) {
  4618. let course = req.body[0].courseType;
  4619. let courseId = ret[0][0].courseId;
  4620. let userid = req.body[0].uid;
  4621. delStudioCourseTypeS(course, courseId, userid);
  4622. res.end(
  4623. JSON.stringify({
  4624. ordernumber: ret[0][0].ordernumber,
  4625. courseId: ret[0][0].courseId,
  4626. success: 1,
  4627. })
  4628. );
  4629. });
  4630. }
  4631. });
  4632. //teacher 查询项目模板
  4633. router.route("/getStudioTemplateTs").all((req, res, next) => {
  4634. var json = queryString(req.url);
  4635. getmysql(req, res, "getStudioTemplateTs", json["oid"]);
  4636. });
  4637. //查看课程
  4638. router.route("/select_studio_course_detail").all((req, res, next) => {
  4639. //学生
  4640. var json = queryString(req.url);
  4641. getmysql(req, res, "select_studio_course_detail", json["cid"]);
  4642. });
  4643. //查看课程
  4644. router.route("/select_studio_course_detail2").all((req, res, next) => {
  4645. //学生
  4646. var json = queryString(req.url);
  4647. getmysql(req, res, "select_studio_course_detail2", json["cid"]);
  4648. });
  4649. //协同恢复删除的阶段
  4650. router.route("/restoreStudioWork").all((req, res, next) => {
  4651. //学生
  4652. if (req.body[0]) {
  4653. let p = [req.body[0].cid];
  4654. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "select_studio_course_detail2"); //執行存儲過程
  4655. mysql.usselect(p, function(ret) {
  4656. let _chapid = req.body[0].chapid;
  4657. // console.log(_chapid);
  4658. let _chapters = JSON.parse(req.body[0].chapters);
  4659. let _unitJson = JSON.parse(ret[0][0].chapters);
  4660. let _unitJson2 = [];
  4661. let chpaindex;
  4662. for (var i = 0; i < _chapters.length; i++) {
  4663. if (_chapters[i].chapterInfo[0].chapterid == _chapid) {
  4664. chpaindex = i;
  4665. }
  4666. }
  4667. for (var i = 0; i < _unitJson.length; i++) {
  4668. if (_unitJson[i].chapterInfo[0].chapterid != _chapid) {
  4669. // console.log(1);
  4670. // _unitJson.splice(i, -1)
  4671. _unitJson2.push(_unitJson[i]);
  4672. // break;
  4673. }
  4674. }
  4675. _unitJson2.splice(chpaindex, 0, _chapters[chpaindex]);
  4676. // console.log(_unitJson2);
  4677. let p2 = [
  4678. req.body[0].cid,
  4679. JSON.stringify(_unitJson2).replaceAll(/%/g, "%25"),
  4680. ];
  4681. p2.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateStudioWorkNew4"); //執行存儲過程
  4682. mysql.usselect(p2, function(ret) {
  4683. res.end(JSON.stringify({ success: 1 }));
  4684. });
  4685. // res.end(JSON.stringify({ success: 1 }));
  4686. });
  4687. }
  4688. });
  4689. //查询分类及所有子分类
  4690. router.route("/selectAllTypeStudio").all((req, res, next) => {
  4691. var json = queryString(req.url);
  4692. getmysql(req, res, "selectAllTypeStudio", json["org"], json["oid"]);
  4693. });
  4694. //上传文件
  4695. router.route("/addStudioCourseWorksS").all((req, res, next) => {
  4696. postmysql(req, res, "addStudioCourseWorksS");
  4697. });
  4698. //删除提交的作业
  4699. router.route("/deleteStudioCourseWorkS").all((req, res, next) => {
  4700. postmysql(req, res, "deleteStudioCourseWorkS");
  4701. });
  4702. router.route("/selectStudioCourseNew222").all((req, res, next) => {
  4703. var json = queryString(req.url);
  4704. getmysql(
  4705. req,
  4706. res,
  4707. "selectStudioCourseNew222",
  4708. json["type"],
  4709. json["uid"],
  4710. json["oid"],
  4711. json["org"],
  4712. json["typea"],
  4713. json["typeb"],
  4714. json["typec"],
  4715. json["typed"],
  4716. json["typef"],
  4717. json["typeE"],
  4718. json["cu"],
  4719. json["cn"],
  4720. json["page"],
  4721. json["pageSize"]
  4722. );
  4723. });
  4724. //删除课程
  4725. router.route("/deleteStudioCourse").all((req, res, next) => {
  4726. var json = queryString(req.url);
  4727. getmysql(req, res, "deleteStudioCourse", json["cid"]);
  4728. });
  4729. function delStudioCourseTypeS(course, courseId, userid) {
  4730. let _courseId = courseId;
  4731. var _userdata = [_courseId];
  4732. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_studioCourseTypeS");
  4733. mysql.usselect(_userdata, function(ret) {
  4734. // console.log(ret);
  4735. addStudioCourseTypeS(userid, course, _courseId);
  4736. });
  4737. // setTimeout(() => {
  4738. // }, 1000);
  4739. }
  4740. function addStudioCourseTypeS(userid, course, _courseId) {
  4741. var _uid = userid;
  4742. var _courses = _courseId;
  4743. var _tid = JSON.parse(course);
  4744. for (let i = 0; i < _tid.length; i++) {
  4745. if (_tid[i] == "") {
  4746. continue;
  4747. }
  4748. var _userdata = [_courses, _tid[i], _uid];
  4749. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_studioCourseTypeS");
  4750. mysql.usselect(_userdata, function(ret) {
  4751. // console.log(ret);
  4752. });
  4753. }
  4754. }
  4755. //删除作业阶段任务工具
  4756. router.route("/deleteStudioToolSTT").all((req, res, next) => {
  4757. postmysql(req, res, "deleteStudioToolSTT");
  4758. });
  4759. //删除作业阶段任务
  4760. router.route("/deleteStudioToolST").all((req, res, next) => {
  4761. postmysql(req, res, "deleteStudioToolST");
  4762. });
  4763. //删除作业阶段
  4764. router.route("/deleteStudioToolS").all((req, res, next) => {
  4765. postmysql(req, res, "deleteStudioToolST");
  4766. });
  4767. //工作管理首页查询分类
  4768. router.route("/selectStudioCourseNew22Mode").all((req, res, next) => {
  4769. var json = queryString(req.url);
  4770. getmysql(
  4771. req,
  4772. res,
  4773. "selectStudioCourseNew22Mode",
  4774. json["type"],
  4775. json["uid"],
  4776. json["oid"],
  4777. json["org"],
  4778. json["typea"],
  4779. json["typeb"],
  4780. json["typec"],
  4781. json["typed"],
  4782. json["typef"],
  4783. json["typeE"],
  4784. json["cu"],
  4785. json["cn"]
  4786. );
  4787. });
  4788. //工作管理首页查询
  4789. router.route("/selectStudioCourseNew22").all((req, res, next) => {
  4790. var json = queryString(req.url);
  4791. getmysql(
  4792. req,
  4793. res,
  4794. "selectStudioCourseNew22",
  4795. json["type"],
  4796. json["uid"],
  4797. json["oid"],
  4798. json["org"],
  4799. json["typea"],
  4800. json["typeb"],
  4801. json["typec"],
  4802. json["typed"],
  4803. json["typef"],
  4804. json["typeE"],
  4805. json["cu"],
  4806. json["cn"],
  4807. json["page"],
  4808. json["pageSize"]
  4809. );
  4810. });
  4811. //根据学校查询banner
  4812. router.route("/selectBannerByOidStudio").all((req, res, next) => {
  4813. var json = queryString(req.url);
  4814. getmysql(req, res, "selectBannerByOidStudio", json["oid"]);
  4815. });
  4816. //admin 查询banner
  4817. router.route("/getBannerStudio").all((req, res, next) => {
  4818. var json = queryString(req.url);
  4819. getmysql(req, res, "getBannerStudio");
  4820. });
  4821. //查询工作课程详情
  4822. router.route("/selectStudioCourseDetail2").all((req, res, next) => {
  4823. //学生
  4824. var json = queryString(req.url);
  4825. getmysql(req, res, "selectStudioCourseDetail2", json["courseId"]);
  4826. });
  4827. //查询工作课程详情
  4828. router.route("/selectStudioCourseDetail3").all((req, res, next) => {
  4829. //学生
  4830. var json = queryString(req.url);
  4831. getmysql(req, res, "selectStudioCourseDetail3", json["courseId"]);
  4832. });
  4833. //上传文件
  4834. router.route("/addCourseWorks4studio").all((req, res, next) => {
  4835. postmysql3(req, res, "addCourseWorks4studio");
  4836. });
  4837. //查询教师资源分类
  4838. router.route("/selectAllSourceType").all((req, res, next) => {
  4839. //学生
  4840. var json = queryString(req.url);
  4841. getmysql(req, res, "selectAllSourceType", json["oid"], json["org"]);
  4842. });
  4843. router.route("/addSource").all((req, res, next) => {
  4844. //添加资源
  4845. if (req.body[0]) {
  4846. p = [
  4847. req.body[0].name,
  4848. req.body[0].url,
  4849. req.body[0].detail,
  4850. req.body[0].label,
  4851. req.body[0].userid,
  4852. ];
  4853. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "addSource");
  4854. //執行存儲過程
  4855. mysql.usselect(p, function(ret) {
  4856. let course = req.body[0].courseType;
  4857. let courseId = ret[0][0].id;
  4858. let userid = req.body[0].userid;
  4859. delSourceType(course, courseId, userid);
  4860. res.end(JSON.stringify({ id: ret[0][0].id, success: 1 }));
  4861. // res.end(JSON.stringify(ret));
  4862. });
  4863. }
  4864. });
  4865. router.route("/updateSource").all((req, res, next) => {
  4866. //修改资源
  4867. if (req.body[0]) {
  4868. p = [
  4869. req.body[0].id,
  4870. req.body[0].name,
  4871. req.body[0].url,
  4872. req.body[0].detail,
  4873. req.body[0].label,
  4874. req.body[0].userid,
  4875. ];
  4876. p.unshift(_mysqlLabor[0], _mysqlLabor[1], "updateSource");
  4877. //執行存儲過程
  4878. mysql.usselect(p, function(ret) {
  4879. let course = req.body[0].courseType;
  4880. let courseId = req.body[0].id;
  4881. let userid = req.body[0].userid;
  4882. delSourceType(course, courseId, userid);
  4883. res.end(JSON.stringify({ id: req.body[0].id, success: 1 }));
  4884. // res.end(JSON.stringify(ret));
  4885. });
  4886. }
  4887. });
  4888. function delSourceType(course, courseId, userid) {
  4889. let _courseId = courseId;
  4890. var _userdata = [_courseId];
  4891. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "delete_sourceType");
  4892. mysql.usselect(_userdata, function(ret) {
  4893. addSourceType(userid, course, _courseId);
  4894. });
  4895. }
  4896. function addSourceType(userid, course, _courseId) {
  4897. var _uid = userid;
  4898. var _courses = _courseId;
  4899. var _tid = JSON.parse(course);
  4900. for (let i = 0; i < _tid.length; i++) {
  4901. if (_tid[i] == "") {
  4902. continue;
  4903. }
  4904. var _userdata = [_courses, _tid[i], _uid];
  4905. _userdata.unshift(_mysqlLabor[0], _mysqlLabor[1], "add_sourceType");
  4906. mysql.usselect(_userdata, function(ret) {
  4907. // console.log(ret);
  4908. });
  4909. }
  4910. }
  4911. //资源查询
  4912. router.route("/selectSource").all((req, res, next) => {
  4913. var json = queryString(req.url);
  4914. getmysql(
  4915. req,
  4916. res,
  4917. "selectSource",
  4918. json["uid"],
  4919. json["oid"],
  4920. json["org"],
  4921. json["typea"],
  4922. json["typeb"],
  4923. json["typeE"],
  4924. json["cn"],
  4925. json["page"],
  4926. json["pageSize"]
  4927. );
  4928. });
  4929. //数据看板-综合数据
  4930. router.route("/selectDataBoardSchool").all((req, res, next) => {
  4931. postmysql(req, res, "selectDataBoardSchool");
  4932. });
  4933. //数据看板-教师数据
  4934. router.route("/selectDataBoardTeacher").all((req, res, next) => {
  4935. postmysql(req, res, "selectDataBoardTeacher");
  4936. });
  4937. //数据看板-学生数据
  4938. router.route("/selectDataBoardStudent").all((req, res, next) => {
  4939. postmysql(req, res, "selectDataBoardStudent");
  4940. });
  4941. //数据看板-课程数据
  4942. router.route("/selectDataBoardCourse").all((req, res, next) => {
  4943. postmysql(req, res, "selectDataBoardCourse");
  4944. });
  4945. function generateAPIKey(username) {
  4946. let timeStamp = new Date().getTime();
  4947. let hashStr = timeStamp + username;
  4948. let digest = crypto
  4949. .createHash("sha256")
  4950. .update(hashStr, "utf8")
  4951. .digest("hex");
  4952. return digest;
  4953. }
  4954. queryString = function(url) {
  4955. var a = url.split("?");
  4956. var json = querystring.parse(a[1]);
  4957. return json;
  4958. };
  4959. //post存儲過程處理
  4960. postmysql = function(req, res, functionname) {
  4961. //mode的處理
  4962. if (req.body[0]) {
  4963. p = Object.values(req.body[0]);
  4964. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  4965. //執行存儲過程
  4966. mysql.usselect(p, function(ret) {
  4967. res.end(JSON.stringify(ret));
  4968. });
  4969. }
  4970. };
  4971. //post存儲過程處理
  4972. postmysql2 = function(req, res, functionname) {
  4973. //mode的處理
  4974. if (req.body) {
  4975. p = Object.values(req.body)[0].split(",");
  4976. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  4977. //執行存儲過程
  4978. mysql.usselect(p, function(ret) {
  4979. res.end(JSON.stringify(ret));
  4980. });
  4981. }
  4982. };
  4983. //post存儲過程處理
  4984. postmysql3 = function(req, res, functionname) {
  4985. //mode的處理
  4986. if (req.body) {
  4987. p = Object.values(req.body);
  4988. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  4989. //執行存儲過程
  4990. mysql.usselect(p, function(ret) {
  4991. res.end(JSON.stringify(ret));
  4992. });
  4993. }
  4994. };
  4995. //get獲取數據庫信息
  4996. getmysql = function(req, res, functionname, ...p) {
  4997. p = p || [];
  4998. p.unshift(_mysqlLabor[0], _mysqlLabor[1], functionname);
  4999. //執行存儲過程
  5000. mysql.usselect(p, function(ret) {
  5001. res.end(JSON.stringify(ret));
  5002. }); //
  5003. };
  5004. //post存储过程处理
  5005. userpostmysql = function(req, res, functionname) {
  5006. //mode的处理
  5007. if (req.body.mode) {
  5008. p = req.body.mode.split(",");
  5009. p.unshift(_mysqluser[0], _mysqluser[1], functionname);
  5010. //执行存储过程
  5011. mysql.usselect(p, function(ret) {
  5012. res.end(JSON.stringify(ret));
  5013. });
  5014. }
  5015. };
  5016. //get获取数据库信息
  5017. usergetmysql = function(req, res, functionname, ...p) {
  5018. p = p || [];
  5019. p.unshift(_mysqluser[0], _mysqluser[1], functionname);
  5020. //执行存储过程
  5021. mysql.usselect(p, function(ret) {
  5022. res.end(JSON.stringify(ret));
  5023. }); //
  5024. };
  5025. module.exports = router;