message.js 59 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576
  1. var us = {}; //全局的命名空间
  2. us.cheerio = require("cheerio"); //dom处理类
  3. us.qs = require("querystring"); //引用文件解析包
  4. us.http = require("http"); //引用http server服务
  5. us.mysql = require("./mysql.js"); //引用执行存储过程包
  6. /**
  7. * 保持知识建构的时间变量
  8. **/
  9. us.savecscltime = null;
  10. /**
  11. * 用户的链接池集合,以用户id作为搜索键
  12. **/
  13. us.connect = {};
  14. /**
  15. * 用户的数据集合集合,以用户id作为搜索键
  16. **/
  17. us.user = {};
  18. /**
  19. * 未来课堂数据结构
  20. **/
  21. us.cscl = {};
  22. /**
  23. * 离线数据
  24. **/
  25. us.offLineMessage = {};
  26. /**
  27. * 思维网格
  28. **/
  29. us.mindNetwork = {};
  30. /**
  31. * 同步课堂
  32. **/
  33. us.realTimeClass = {};
  34. //文档列表
  35. us.word = {};
  36. //excel列表
  37. us.excel = {};
  38. //导航文件列表
  39. us.nav = {};
  40. //知识建构的数据结构
  41. us.cscldata = function () {
  42. return {
  43. id: "", userid: "", name: "", num: "", data: "",
  44. isClose: "", create_at: "", createuser: "", smailheadportrait: ""
  45. };
  46. };
  47. /**
  48. * 用户链接类
  49. **/
  50. us.userConnect = function (pageId, response) {
  51. return {
  52. "pageId": pageId,
  53. "response": response,
  54. "loginTime": new Date(),
  55. "offLineTime": null
  56. };
  57. };
  58. /**
  59. * 用户数据类
  60. **/
  61. us.userInfo = function (userid, username) {
  62. return { "userId": userid, "userName": username };
  63. };
  64. /**
  65. * 用户离线数据
  66. **/
  67. us.userOffLineMessage = function (type) {
  68. return {
  69. "message": [], "type": type || "pc",
  70. "word": [], "excel": [], "mindNetwork": [], "realTimeClass": [],
  71. "cscl": [], "nav": []
  72. };
  73. };
  74. /**
  75. * 用户的离线消息结构
  76. **/
  77. us.message = function (sendid, type, messageinfo) {
  78. return {
  79. "id": us.createGuid(),
  80. "sendId": sendid,
  81. "time": new Date(),
  82. "type": type,
  83. "messageInfo": messageinfo
  84. };
  85. };
  86. process.on('uncaughtException', (e) => {
  87. console.error('process error is:', e.message);
  88. });
  89. /**
  90. * 创建服务
  91. **/
  92. us.server = us.http.createServer(function (requset, response) {
  93. response.writeHead(200, {
  94. "Content-Type": "text/html;application/json;charset=utf-8",
  95. 'Access-Control-Allow-Origin': '*',
  96. 'Access-Control-Allow-Headers': 'Origin, No-Cache, X-Requested-With, If-Modified-Since, Pragma, Last-Modified, Cache-Control, Expires, Content-Type, X-E4M-With'
  97. });
  98. us.unifyDispose(requset, response, function (param) {
  99. if (param && param[0]) {
  100. var _userinfo, _funname = param[0], _param = param.splice(1);
  101. switch (_funname) {
  102. case 'login':
  103. _userinfo = JSON.parse(_param[0]);
  104. us.login(requset, response, _userinfo.userId, _userinfo.pageId, _userinfo.userName, _userinfo.type);
  105. break;
  106. case 'logout':
  107. us.logout(response, _param[0], _param[1]);
  108. break;
  109. case 'polling':
  110. us.polling(requset, response, _param[0], _param[1], _param[2], _param[3]);
  111. break;
  112. case 'getWord':
  113. us.getWord(response, _param[0], _param[1], _param[2]);
  114. break;
  115. case 'getExcel':
  116. us.getExcel(response, _param[0], _param[1], _param[2]);
  117. break;
  118. case 'getNav':
  119. us.getNav(response, _param[0], _param[1], _param[2]);
  120. break;
  121. case 'getMindNetwork':
  122. us.getMindNetwork(response, _param[0], _param[1], _param[2]);
  123. break;
  124. case 'getcscl':
  125. us.getcscl(response, _param[0], _param[1], _param[2]);
  126. break;
  127. case 'getcscldata':
  128. us.getcscldata(response, _param[0], _param[1], _param[2]);
  129. break;
  130. case 'getRealTimeClass':
  131. us.getRealTimeClass(response, _param[0], _param[1], _param[2]);
  132. break;
  133. case 'getNavPageContent':
  134. us.getNavPageContent(response, _param[0], _param[1]);
  135. break;
  136. case 'send':
  137. us.send(response, _param[0]);
  138. break;
  139. case 'quitOffice':
  140. us.quitOffice(response, _param[0]);
  141. break;
  142. case 'quitcscl':
  143. us.quitcscl(response, _param[0]);
  144. break;
  145. case 'newWordSave':
  146. us.newWordSave(response, _param[0], _param[1], _param[2], _param[3], _param[4]);
  147. break;
  148. case 'newExcelSave':
  149. us.newExcelSave(response, _param[0], _param[1], _param[2], _param[3], _param[4]);
  150. break;
  151. case 'newNavSave':
  152. us.newNavSave(response, _param[0], _param[1], _param[2], _param[3], _param[4], _param[5], _param[6]);
  153. break;
  154. case 'addWord':
  155. us.addWord(response, _param[0]);
  156. break;
  157. case 'addExcel':
  158. us.addExcel(response, _param[0]);
  159. break;
  160. case 'copyPageContent':
  161. us.copyPageContent(response, _param[0], _param[1], _param[2], _param[3]);
  162. break;
  163. case 'updateName':
  164. us.updateName(response, _param[0], _param[1], _param[2], _param[3], _param[4]);
  165. break;
  166. case 'insertModifyRecord':
  167. us.insertModifyRecord(response, _param[0], _param[1], _param[2], _param[3], _param[4], _param[5]);
  168. break;
  169. case 'addUser':
  170. us.addUser(response, _param[0], _param[1], _param[2], _param[3], _param[4]);
  171. break;
  172. default:
  173. response.end(0);
  174. }
  175. } else {
  176. response.end("");
  177. }
  178. });
  179. });
  180. /**
  181. * 协同历史(保存类操作:必须等数据库返回 historyid 才能广播)
  182. **/
  183. us.insertModifyRecord = function (response, type, fileid, filename, html, userid, pageid) {
  184. var _html;
  185. if (us[type][fileid] && us[type][fileid].content) {
  186. _html = us[type][fileid].content('body').html().replace(/'/ig, "''").replace(/"/ig, "\\\"");
  187. } else {
  188. _html = html;
  189. }
  190. us.mysql.usselect([
  191. '127.0.0.1', 'UseStudio_Office', 'InsertDocumentModifyRecord',
  192. userid, fileid, _html, filename
  193. ], function (ret) {
  194. if (ret) {
  195. var _historyid = JSON.parse(ret)[0][0].historyid;
  196. var _message = {};
  197. var _messageinfo = us.message(userid, 'us.' + type, {
  198. id: us.createGuid(), type: "insertModifyRecord",
  199. historyid: _historyid, docId: fileid
  200. });
  201. _message[fileid] = [_messageinfo];
  202. us.broadcast(_message, pageid, type);
  203. response.end(_historyid);
  204. } else {
  205. response.end(ret);
  206. }
  207. });
  208. };
  209. /**
  210. * 更新文件名(保存类操作:等数据库确认后广播)
  211. **/
  212. us.updateName = function (response, type, fileid, filename, userid, pageid) {
  213. us.mysql.usselect([
  214. 'sqlserver.1473.cn', 'UseStudio_Disk', 'UpdateFileInfo', fileid, filename
  215. ], function (ret) {
  216. if (ret) {
  217. var _message = {};
  218. var _messageinfo = us.message(userid, 'us.' + type, {
  219. id: us.createGuid(), type: "updateName",
  220. name: filename, docId: fileid
  221. });
  222. _message[fileid] = [_messageinfo];
  223. us.broadcast(_message, pageid, type);
  224. response.end('updateNameSuccess');
  225. } else {
  226. response.end('updateNameFail');
  227. }
  228. });
  229. };
  230. /**
  231. * 添加用户(不需要等数据库,直接广播)
  232. **/
  233. us.addUser = function (response, type, fileid, userids, userid, pageid) {
  234. var _message = {};
  235. var _messageinfo = us.message(userid, 'us.' + type, {
  236. id: us.createGuid(), type: "addUser",
  237. userIds: userids, docId: fileid
  238. });
  239. _message[fileid] = [_messageinfo];
  240. us.broadcast(_message, pageid, type);
  241. response.end('addUserSuccess');
  242. };
  243. us.getuserbytype = function (userids) {
  244. var _userinfo = [];
  245. for (var i in userids) {
  246. if (us.user[i]) _userinfo.push(us.user[i]);
  247. }
  248. return _userinfo;
  249. };
  250. us.sendUser = function (userinfo, type, pageid, fileid) {
  251. var _message = {};
  252. var _messageinfo = us.message(userinfo.userid, 'us.' + type, {
  253. id: us.createGuid(), type: "addUser",
  254. userinfo: userinfo, docId: fileid
  255. });
  256. _message[fileid] = [_messageinfo];
  257. us.broadcast(_message, pageid, type);
  258. };
  259. /**
  260. * 获取用户传参异步
  261. **/
  262. us.unifyDispose = function (req, res, cb) {
  263. var i, _param = "";
  264. req.on("data", function (chunk) { _param += chunk; });
  265. req.on("end", function () {
  266. if (_param) _param = us.qs.parse(_param);
  267. try {
  268. _param = _param.mode.split(",");
  269. } catch (e) {
  270. _param = req.query;
  271. }
  272. if (_param) {
  273. for (i = 0; i < _param.length; i++) {
  274. _param[i] = decodeURIComponent(_param[i]);
  275. }
  276. } else {
  277. _param = [];
  278. }
  279. cb(_param);
  280. });
  281. res.on('timeout', function () {
  282. try { /* 超时由 setTimeout 统一处理 */ } catch (e) { }
  283. });
  284. /* === 修改:超时前先判断是否已结束,避免 ERR_STREAM_WRITE_AFTER_END === */
  285. res.setTimeout(60000, function () {
  286. try {
  287. if (!res.writableEnded && !res.finished) {
  288. res.end("");
  289. }
  290. } catch (e) {
  291. console.error('process error is:', e.message);
  292. }
  293. });
  294. req.on("error", function (e) {
  295. try { console.log(e); } catch (e) { }
  296. });
  297. };
  298. /**
  299. * 登录
  300. **/
  301. us.login = function (requset, response, userid, pageid, username, type) {
  302. if (userid && pageid) {
  303. if (!us.user[userid]) {
  304. username = username || "";
  305. us.user[userid] = us.userInfo(userid, username);
  306. }
  307. us.polling(requset, response, userid, pageid, type);
  308. }
  309. };
  310. /* ============================================================
  311. * === 修改:deluser / offLine / offLineByUser / polling / broadcast ===
  312. * ============================================================ */
  313. /**
  314. * 用户下线,清理用户的数据
  315. **/
  316. us.deluser = function (userid, pageid) {
  317. if (!pageid || !us.offLineMessage[pageid]) return;
  318. var _offline = us.offLineMessage[pageid];
  319. var _csclids = _offline.cscl || [];
  320. delete us.offLineMessage[pageid];
  321. for (var i = 0; i < _csclids.length; i++) {
  322. var _docinfo = us.cscl[_csclids[i]];
  323. if (!_docinfo) continue;
  324. var _fileid = _csclids[i];
  325. var _userid = us.quitUserList(_docinfo, userid, pageid);
  326. if (_userid) {
  327. var _message = {};
  328. var _messageinfo = us.message(userid, 'us.cscl', {
  329. id: us.createGuid(), type: "delUser",
  330. userinfo: us.user[_userid], docId: _fileid
  331. });
  332. _message[_fileid] = [_messageinfo];
  333. us.broadcast(_message, pageid, "cscl");
  334. }
  335. }
  336. };
  337. /**
  338. * 定时检测离线(60秒一次)
  339. **/
  340. us.offLine = function () {
  341. var now = Date.now();
  342. var _connect = us.connect;
  343. for (var i in _connect) {
  344. var _user = _connect[i];
  345. for (var j in _user) {
  346. var conn = _user[j];
  347. if (!conn) continue;
  348. var resp = conn.response;
  349. var invalid = !resp
  350. || resp.writableEnded
  351. || resp.finished
  352. || resp.destroyed
  353. || (resp.socket && resp.socket.destroyed);
  354. if (invalid) {
  355. var last = conn.loginTime
  356. ? (conn.loginTime instanceof Date ? conn.loginTime.getTime() : new Date(conn.loginTime).getTime())
  357. : 0;
  358. // 服务端主动 end 后 response 置 null,用户会很快发下一次轮询;
  359. // 只有超过 90 秒没有任何新请求才判定真正下线
  360. if (now - last > 90000) {
  361. us.offLineByUser(i, j, _user);
  362. }
  363. }
  364. }
  365. }
  366. };
  367. /**
  368. * 用户下线
  369. **/
  370. us.offLineByUser = function (i, j, _user) {
  371. setTimeout(function () {
  372. var conn = _user[j];
  373. if (!conn) return;
  374. var resp = conn.response;
  375. var invalid = !resp
  376. || resp.writableEnded
  377. || resp.finished
  378. || resp.destroyed
  379. || (resp.socket && resp.socket.destroyed);
  380. var last = conn.loginTime
  381. ? (conn.loginTime instanceof Date ? conn.loginTime.getTime() : new Date(conn.loginTime).getTime())
  382. : 0;
  383. if (invalid && Date.now() - last > 90000) {
  384. var k, istrue = true;
  385. us.deluser(i, j);
  386. delete _user[j];
  387. for (k in _user) { istrue = false; break; }
  388. if (istrue) {
  389. delete us.user[i];
  390. delete us.connect[i];
  391. }
  392. }
  393. }, 5000);
  394. };
  395. /**
  396. * 长轮询:有离线消息立即推送并 end;无消息则挂起等待 broadcast 或 60 秒超时
  397. **/
  398. us.polling = function (requset, response, userid, pageid, type) {
  399. if (!us.connect[userid]) us.connect[userid] = {};
  400. if (!us.offLineMessage[pageid]) us.offLineMessage[pageid] = us.userOffLineMessage(type);
  401. var _userarray = us.connect[userid];
  402. var _messagearray = us.offLineMessage[pageid];
  403. if (_userarray[pageid]) {
  404. var _oldResp = _userarray[pageid].response;
  405. if (_oldResp && !_oldResp.writableEnded && !_oldResp.finished && !_oldResp.destroyed) {
  406. try { _oldResp.end(""); } catch (e) { }
  407. }
  408. _userarray[pageid].response = response;
  409. _userarray[pageid].loginTime = new Date();
  410. } else {
  411. _userarray[pageid] = us.userConnect(pageid, response);
  412. _userarray[pageid].loginTime = new Date();
  413. }
  414. // 有离线消息:立即推送并结束本次轮询
  415. if (_messagearray.message.length > 0) {
  416. var _data = JSON.stringify(_messagearray.message);
  417. _messagearray.message = [];
  418. // 先置空,防止 broadcast 同时往已结束的 response 写
  419. _userarray[pageid].response = null;
  420. response.end(_data + "\r\n");
  421. }
  422. // 无消息:保持挂起,等待 broadcast 推送或 60 秒超时
  423. };
  424. /**
  425. * 群发:写入并立即 end,让前端毫秒级收到
  426. **/
  427. us.broadcast = function (messageinfo, pageid, type) {
  428. var i, j, o, _messageinfo, _doc, _users, _pageids, _recievedpageid, _data;
  429. var _userconnect = us.connect;
  430. for (i in messageinfo) {
  431. _messageinfo = messageinfo[i]; // 该接收者的一批消息(数组)
  432. if (!_messageinfo || !_messageinfo.length) continue;
  433. // 优先用 key 查文档(兼容前端把 docId 当 receiveId 传);否则用消息里的 docId
  434. _doc = us[type][i]
  435. || (_messageinfo[0].messageInfo && us[type][_messageinfo[0].messageInfo.docId]);
  436. if (!_doc) continue;
  437. _users = _doc.user || {};
  438. _data = JSON.stringify(_messageinfo);
  439. for (j in _users) {
  440. _pageids = _users[j];
  441. for (o = 0; o < _pageids.length; o++) {
  442. _recievedpageid = _pageids[o];
  443. if (_recievedpageid == pageid) continue; // 跳过发送者自己
  444. if (!us.offLineMessage[_recievedpageid]) {
  445. us.offLineMessage[_recievedpageid] = us.userOffLineMessage();
  446. }
  447. var conn = _userconnect[j] && _userconnect[j][_recievedpageid];
  448. var resp = conn && conn.response;
  449. if (resp && !resp.writableEnded && !resp.finished && !resp.destroyed) {
  450. try {
  451. resp.end(_data + "\r\n");
  452. conn.response = null; // 已结束,后续消息进入离线队列
  453. conn.offLineTime = new Date();
  454. continue;
  455. } catch (e) {
  456. conn.response = null;
  457. }
  458. } else if (conn) {
  459. conn.response = null;
  460. }
  461. // 在线连接不可用:写入离线消息(展开数组,元素为单条消息)
  462. Array.prototype.push.apply(
  463. us.offLineMessage[_recievedpageid].message,
  464. _messageinfo
  465. );
  466. }
  467. }
  468. }
  469. };
  470. /**
  471. * 发送消息(实时编辑:不等数据库)
  472. **/
  473. us.send = function (response, messageinfo) {
  474. var i, j, _message, _messagelist = {}, _messagearr;
  475. var _messageobj = JSON.parse(messageinfo);
  476. for (i in _messageobj) {
  477. switch (i) {
  478. case "us.mindNetwork":
  479. _messagearr = _messageobj[i];
  480. for (j = 0; j < _messagearr.length; j++) {
  481. _message = us.message(_messagearr[j].sendId, "us.mindNetwork", _messagearr[j].messageInfo);
  482. if (_messagelist[_messagearr[j].receiveId]) {
  483. _messagelist[_messagearr[j].receiveId].push(_message);
  484. } else {
  485. _messagelist[_messagearr[j].receiveId] = [_message];
  486. }
  487. us.mindNetwork[_message.messageInfo.docId]
  488. && us.mindNetwork[_message.messageInfo.docId].history.push(_message);
  489. us.updatemindNetwork(_message.messageInfo);
  490. }
  491. _messagearr[0] && us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'mindNetwork');
  492. break;
  493. case "us.cscl":
  494. _messagearr = _messageobj[i];
  495. for (j = 0; j < _messagearr.length; j++) {
  496. _messagearr[j].messageInfo.type = _messagearr[j].type;
  497. _message = us.message(_messagearr[j].sendId, "us.cscl", _messagearr[j].messageInfo);
  498. _message.ttype = _messagearr[j].type;
  499. if (_messagelist[_messagearr[j].receiveId]) {
  500. _messagelist[_messagearr[j].receiveId].push(_message);
  501. } else {
  502. _messagelist[_messagearr[j].receiveId] = [_message];
  503. }
  504. us.cscl[_messagearr[j].receiveId]
  505. && us.cscl[_messagearr[j].receiveId].history.push(_message);
  506. us.updatecscl(_message.messageInfo, _messagearr[j].receiveId, _messagearr[j].type);
  507. }
  508. _messagearr[0] && us.broadcast(_messagelist, _messagearr[0].pageId, 'cscl');
  509. break;
  510. case "us.realTimeClass":
  511. _messagearr = _messageobj[i];
  512. for (j = 0; j < _messagearr.length; j++) {
  513. _message = us.message(_messagearr[j].sendId, "us.realTimeClass", _messagearr[j].messageInfo);
  514. if (_messagelist[_messagearr[j].receiveId]) {
  515. _messagelist[_messagearr[j].receiveId].push(_message);
  516. } else {
  517. _messagelist[_messagearr[j].receiveId] = [_message];
  518. }
  519. us.realTimeClass[_message.messageInfo.docId]
  520. && us.realTimeClass[_message.messageInfo.docId].history.push(_message);
  521. us.updaterealTimeClass(_message.messageInfo);
  522. }
  523. _messagearr[0] && us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'realTimeClass');
  524. break;
  525. case "us.word":
  526. try {
  527. _messagearr = _messageobj[i];
  528. for (j = 0; j < _messagearr.length; j++) {
  529. _message = us.message(_messagearr[j].sendId, "us.word", _messagearr[j].messageInfo);
  530. if (_messagelist[_messagearr[j].receiveId]) {
  531. _messagelist[_messagearr[j].receiveId].push(_message);
  532. } else {
  533. _messagelist[_messagearr[j].receiveId] = [_message];
  534. }
  535. us.word[_message.messageInfo.docId]
  536. && us.word[_message.messageInfo.docId].history.push(_message);
  537. us.updateWord(_message.messageInfo);
  538. }
  539. _messagearr[0] && us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'word');
  540. } catch (e) { console.log(e); }
  541. break;
  542. case "us.excel":
  543. _messagearr = _messageobj[i];
  544. for (j = 0; j < _messagearr.length; j++) {
  545. _message = us.message(_messagearr[j].sendId, _messagearr[j].type, _messagearr[j].messageInfo);
  546. if (_messagelist[_messagearr[j].receiveId]) {
  547. _messagelist[_messagearr[j].receiveId].push(_message);
  548. } else {
  549. _messagelist[_messagearr[j].receiveId] = [_message];
  550. }
  551. us.excel[_message.messageInfo.docId]
  552. && us.excel[_message.messageInfo.docId].history.push(_message);
  553. us.updateExcel(_message.messageInfo);
  554. }
  555. _messagearr[0] && us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'excel');
  556. break;
  557. case "us.nav":
  558. _messagearr = _messageobj[i];
  559. for (j = 0; j < _messagearr.length; j++) {
  560. _message = us.message(_messagearr[j].sendId, "us.nav", _messagearr[j].messageInfo);
  561. if (_messagelist[_messagearr[j].receiveId]) {
  562. _messagelist[_messagearr[j].receiveId].push(_message);
  563. } else {
  564. _messagelist[_messagearr[j].receiveId] = [_message];
  565. }
  566. us.nav[_message.messageInfo.docId]
  567. && us.nav[_message.messageInfo.docId].history.push(_message);
  568. us.updateNav(_message.messageInfo);
  569. }
  570. _messagearr[0] && us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'nav');
  571. break;
  572. }
  573. }
  574. response.end('send');
  575. };
  576. /* ============================================================
  577. * 以下为业务更新函数(与原文件基本一致,个别加了空保护)
  578. * ============================================================ */
  579. us.updatemindNetwork = function (messageInfo) {
  580. if (us.mindNetwork[messageInfo.docId]) {
  581. var $ = us.mindNetwork[messageInfo.docId].content;
  582. if ($) us.mindNetwork[messageInfo.docId].content[messageInfo.id] = messageInfo.content;
  583. }
  584. };
  585. us.updatecscl = function (messageInfo, classId, ty) {
  586. var _obj;
  587. if (us.cscl[classId]) {
  588. var i, j, _is;
  589. _obj = us.cscl[classId].content;
  590. if (ty == "clean") {
  591. _obj = us.cscl[classId].content = {};
  592. } else {
  593. _obj.backgroundUrl = messageInfo.backgroundUrl;
  594. _obj.edges = _obj.edges || [];
  595. _obj.nodes = _obj.nodes || [];
  596. for (j = 0; j < messageInfo.edges.length; j++) {
  597. _is = true;
  598. for (i = 0; i < _obj.edges.length; i++) {
  599. if (_obj.edges[i].id == messageInfo.edges[j].id) {
  600. if (ty == "update") _obj.edges[i] = messageInfo.edges[j];
  601. else _obj.edges.splice(i, 1);
  602. _is = false;
  603. break;
  604. }
  605. }
  606. if (_is && ty == "update") _obj.edges.push(messageInfo.edges[j]);
  607. }
  608. for (j = 0; j < messageInfo.nodes.length; j++) {
  609. _is = true;
  610. for (i = 0; i < _obj.nodes.length; i++) {
  611. if (_obj.nodes[i].id == messageInfo.nodes[j].id) {
  612. if (ty == "update") _obj.nodes[i] = messageInfo.nodes[j];
  613. else _obj.nodes.splice(i, 1);
  614. _is = false;
  615. break;
  616. }
  617. }
  618. if (_is && ty == "update") _obj.nodes.push(messageInfo.nodes[j]);
  619. }
  620. }
  621. try { clearTimeout(us.savecscltime); } catch (e) { }
  622. }
  623. us.savecscltime = setTimeout(function () {
  624. us.mysql.usselect(['172.16.12.5', 'pbl', 'updateRoomData', JSON.stringify(_obj), classId], function () { });
  625. }, 5000);
  626. };
  627. us.updaterealTimeClass = function (messageInfo) {
  628. if (us.realTimeClass[messageInfo.docId]) {
  629. var $ = us.realTimeClass[messageInfo.docId].content;
  630. if ($) us.realTimeClass[messageInfo.docId].content[messageInfo.id] = messageInfo.content;
  631. }
  632. };
  633. us.updateWord = function (messageInfo) {
  634. if (us.word[messageInfo.docId]) {
  635. var $ = us.word[messageInfo.docId].content;
  636. if ($) {
  637. switch (messageInfo.type) {
  638. case 'update': us.updateEditorLine(messageInfo, $); break;
  639. case 'add': us.addEditorLine(messageInfo, $); break;
  640. case 'delete': us.deleteEditorLine(messageInfo, $); break;
  641. }
  642. }
  643. }
  644. };
  645. us.updateNav = function (messageInfo) {
  646. var _fileinfo = us.nav[messageInfo.docId];
  647. if (_fileinfo) {
  648. switch (messageInfo.type) {
  649. case 'update': us.updateEditorLine(messageInfo, _fileinfo.page[messageInfo.navId]); break;
  650. case 'add': us.addEditorLine(messageInfo, _fileinfo.page[messageInfo.navId]); break;
  651. case 'delete': us.deleteEditorLine(messageInfo, _fileinfo.page[messageInfo.navId]); break;
  652. case 'addNav': us.updateNav.addNav(_fileinfo, messageInfo.parentId, messageInfo.index, messageInfo.addNav, messageInfo.content); break;
  653. case 'updateNav': us.updateNav.updateNav(_fileinfo.navInfo.nav, messageInfo.navId, messageInfo.name); break;
  654. case 'deleteNav': us.updateNav.deleteNav(_fileinfo, messageInfo.navId, messageInfo.parentId); break;
  655. case 'updateLogo': _fileinfo.navInfo.logo = messageInfo.logo; break;
  656. }
  657. }
  658. };
  659. us.selectByNavId = function (nowinfo, navid) {
  660. for (var i = 0; i < nowinfo.length; i++) {
  661. var object = nowinfo[i];
  662. if (object.pageId == navid) return object;
  663. else if (object.child) {
  664. var r = us.selectByNavId(object.child, navid);
  665. if (r) return r;
  666. }
  667. }
  668. };
  669. us.updateNav.addNav = function (fileinfo, parentid, index, addnav, content) {
  670. var _nav = fileinfo.navInfo.nav, _parent;
  671. if (parentid) {
  672. _parent = us.selectByNavId(_nav, parentid);
  673. if (!_parent) return;
  674. if (_parent.child) _parent.child.splice(index, 0, addnav);
  675. else _parent.child = [addnav];
  676. } else {
  677. _parent = _nav;
  678. _parent.splice(index, 0, addnav);
  679. }
  680. fileinfo.page[addnav.pageId] = us.cheerio.load(content.replace(/\\'/ig, '\'').replace(/\\"/ig, "\""));
  681. };
  682. us.updateNav.updateNav = function (nav, navid, name) {
  683. var _nav = us.selectByNavId(nav, navid);
  684. if (_nav) _nav.name = name;
  685. };
  686. us.updateNav.deleteNav = function (fielinfo, deletenavid, parentid) {
  687. var _nav = fielinfo.navInfo.nav, _parent;
  688. if (parentid) _parent = us.selectByNavId(_nav, parentid);
  689. else _parent = _nav;
  690. if (_parent) {
  691. var _child = parentid ? _parent.child : _parent;
  692. _child.find(function (object, index) {
  693. if (object.pageId == deletenavid) {
  694. if (!object.child) {
  695. _child.splice(index, 1);
  696. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Office', 'DeletePage', deletenavid], function (ret) {
  697. if (ret) delete fielinfo.page[deletenavid];
  698. });
  699. }
  700. return true;
  701. }
  702. });
  703. }
  704. };
  705. us.updateEditorLine = function (opera, $) { $('#' + opera.id).replaceWith(opera.content); };
  706. us.deleteEditorLine = function (opera, $) { $('#' + opera.id).remove(); };
  707. us.addEditorLine = function (opera, $) {
  708. var _next;
  709. if (opera.nextId && (_next = $('#' + opera.nextId))[0]) {
  710. _next.before(opera.content);
  711. } else {
  712. $('body').append(opera.content);
  713. }
  714. };
  715. us.updateExcel = function (messageInfo) {
  716. var _doc = us.excel[messageInfo.docId];
  717. if (!_doc || !_doc.content) return;
  718. var $ = _doc.content;
  719. switch (messageInfo.type) {
  720. case 'blur': us.updateExcel.Blur(messageInfo, $); break;
  721. case "addLine": us.updateExcel.addLine(messageInfo, $); break;
  722. case "delLine": us.updateExcel.delLine(messageInfo, $); break;
  723. case "addCol": us.updateExcel.addCol(messageInfo, $); break;
  724. case "delCol": us.updateExcel.delCol(messageInfo, $); break;
  725. case "merge": us.updateExcel.merge(messageInfo, $); break;
  726. case "splitCells": us.updateExcel.splitCells(messageInfo, $); break;
  727. case "rowExpanding": us.updateExcel.rowExpanding(messageInfo, $); break;
  728. case "colExpanding": us.updateExcel.colExpanding(messageInfo, $); break;
  729. case "addTask": us.updateExcel.addTask(messageInfo, $); break;
  730. case "deleteTask": us.updateExcel.deleteTask(messageInfo, $); break;
  731. case "reNameTask": us.updateExcel.reNameTask(messageInfo, $); break;
  732. case "img": us.updateExcel.img(messageInfo, $); break;
  733. }
  734. };
  735. us.updateExcel.Blur = function (messageInfo, $) {
  736. var _taskId = messageInfo.worksheetId,
  737. _excelData = $[_taskId],
  738. _cellData = _excelData.cell,
  739. _content = messageInfo.content;
  740. _content.forEach(function (data) {
  741. var _text = data.innerText.replace(/\s+/g, ""),
  742. _cellColList = _cellData[data.col],
  743. _cell = null;
  744. if (!_cellColList) _cellColList = _cellData[data.col] = {};
  745. if (!_cellColList[data.row]) {
  746. _cellColList[data.row] = {};
  747. _cellColList[data.row].cssStyle = {};
  748. }
  749. _cell = _cellColList[data.row];
  750. data.content ? _cell.innerHTML = data.content : "";
  751. if (data.attr) {
  752. _cell.cssStyle[data.attr] = data.value;
  753. if (!data.value) delete _cell.cssStyle[data.attr];
  754. }
  755. if (data.clearStyle) data.cssStyle = {};
  756. if (((!(_text) || _text === ("\u200D")) && !(_cell.endRow)) && !(us.jsonLen(_cell.cssStyle))) {
  757. delete (_cellColList[data.row]);
  758. }
  759. });
  760. };
  761. us.jsonLen = function (json) {
  762. var _len = 0;
  763. for (var i in json) _len++;
  764. return _len;
  765. };
  766. us.updateExcel.addLine = function (messageInfo, $) {
  767. var _taskId = messageInfo.worksheetId,
  768. _content = messageInfo.content,
  769. _excelData = $[_taskId],
  770. _rowData = _excelData.row,
  771. _cellData = _excelData.cell,
  772. _start = _content.start,
  773. _lineNum = _content.lineNum,
  774. _sizeChange = _content.sizeChange,
  775. _mergeArr = _content.mergeArr,
  776. _cellCol = null;
  777. if (_mergeArr.length) {
  778. _mergeArr.forEach(function (info) {
  779. _cellData[info.col][info.row].endRow = _cellData[info.col][info.row].endRow + _lineNum;
  780. });
  781. }
  782. for (var k in _cellData) {
  783. _cellCol = _cellData[k];
  784. var temp = {};
  785. for (var row in _cellCol) {
  786. if (row > _start) {
  787. temp[(+row) + _lineNum] = _cellCol[row];
  788. temp[(+row) + _lineNum].endRow ? temp[(+row) + _lineNum].endRow = temp[(+row) + _lineNum].endRow + _lineNum : "";
  789. } else {
  790. temp[row] = _cellCol[row];
  791. }
  792. }
  793. _cellData[k] = temp;
  794. }
  795. var _rowDataChange = _rowData.change, _temp = {}, _rowChange = null;
  796. for (var k in _rowDataChange) {
  797. _rowChange = _rowDataChange[k];
  798. if (k > _start) _temp[(+k) + _lineNum] = _rowChange;
  799. else _temp[k] = _rowChange;
  800. }
  801. _rowData.change = _temp;
  802. if (_sizeChange) {
  803. for (var i = 1; i <= _lineNum; i++) _rowData.change[_start + i] = _sizeChange;
  804. }
  805. _rowData.num = _rowData.num + _lineNum;
  806. };
  807. us.updateExcel.delLine = function (messageInfo, $) {
  808. var _taskId = messageInfo.worksheetId,
  809. _excelData = $[_taskId],
  810. _content = messageInfo.content,
  811. _rowData = _excelData.row,
  812. _cellData = _excelData.cell,
  813. _start = _content.start,
  814. _end = _content.end,
  815. _lineNum = _content.lineNum,
  816. _mergeArr = _content.mergeArr,
  817. _cellCol = null;
  818. for (var k in _cellData) {
  819. _cellCol = _cellData[k];
  820. var temp = {};
  821. for (var row in _cellCol) {
  822. if (row > _end) {
  823. temp[(+row) - _lineNum] = _cellCol[row];
  824. temp[(+row) - _lineNum].endRow ? temp[(+row) - _lineNum].endRow = temp[(+row) - _lineNum].endRow - _lineNum : "";
  825. } else if (row < _start) {
  826. temp[row] = _cellCol[row];
  827. }
  828. }
  829. _cellData[k] = temp;
  830. }
  831. if (_mergeArr.length) {
  832. var _cloneMessage = null;
  833. _mergeArr.forEach(function (info) {
  834. _cloneMessage = JSON.parse(JSON.stringify(messageInfo));
  835. _cloneMessage.content = info;
  836. us.updateExcel.merge(_cloneMessage, $);
  837. });
  838. }
  839. var _rowDataChange = _rowData.change, _temp = {}, _rowChange = null;
  840. for (var k in _rowDataChange) {
  841. _rowChange = _rowDataChange[k];
  842. if (k < _start) _temp[k] = _rowChange;
  843. else if (k > _end) _temp[(+k) - _lineNum] = _rowChange;
  844. }
  845. _rowData.change = _temp;
  846. _rowData.num = _rowData.num - _lineNum;
  847. };
  848. us.updateExcel.addCol = function (messageInfo, $) {
  849. var _taskId = messageInfo.worksheetId,
  850. _excelData = $[_taskId],
  851. _content = messageInfo.content,
  852. _colData = _excelData.column,
  853. _cellData = _excelData.cell,
  854. _start = _content.start,
  855. _sizeChange = _content.sizeChange,
  856. _colNums = _content.colNums,
  857. _mergeArr = _content.mergeArr,
  858. _cellCol = null, _temp = {};
  859. if (_mergeArr.length) {
  860. _mergeArr.forEach(function (info) {
  861. _cellData[info.col][info.row].endCol = _cellData[info.col][info.row].endCol + _colNums;
  862. });
  863. }
  864. for (var k in _cellData) {
  865. _cellCol = _cellData[k];
  866. if (k > _start) {
  867. _temp[+(k) + _colNums] = _cellCol;
  868. var _temp2 = _temp[(+k) + _colNums];
  869. for (var i in _temp2) {
  870. _temp2[i].endCol ? _temp2[i].endCol = _temp2[i].endCol + _colNums : "";
  871. }
  872. } else {
  873. _temp[k] = _cellCol;
  874. }
  875. }
  876. _excelData.cell = _temp;
  877. var _colDataChange = _colData.change, _temp = {}, _colChange = null;
  878. for (var k in _colDataChange) {
  879. _colChange = _colDataChange[k];
  880. if (k > _start) _temp[(+k) + _colNums] = _colChange;
  881. else _temp[k] = _colChange;
  882. }
  883. _colData.change = _temp;
  884. if (_sizeChange) {
  885. for (var i = 1; i <= _colNums; i++) _colData.change[_start + i] = _sizeChange;
  886. }
  887. _colData.num = _colData.num + _colNums;
  888. };
  889. us.updateExcel.delCol = function (messageInfo, $) {
  890. var _taskId = messageInfo.worksheetId,
  891. _excelData = $[_taskId],
  892. _content = messageInfo.content,
  893. _colData = _excelData.column,
  894. _cellData = _excelData.cell,
  895. _start = _content.start,
  896. _end = _content.end,
  897. _colNums = _content.colNums,
  898. _mergeArr = _content.mergeArr,
  899. _cellCol = null, _temp = {};
  900. for (var k in _cellData) {
  901. _cellCol = _cellData[k];
  902. if (k > _end) {
  903. _temp[+(k) - _colNums] = _cellCol;
  904. var _temp2 = _temp[(+k) - _colNums];
  905. for (var i in _temp2) {
  906. _temp2[i].endCol ? _temp2[i].endCol = _temp2[i].endCol - _colNums : "";
  907. }
  908. } else if (k < _start) {
  909. _temp[k] = _cellCol;
  910. }
  911. }
  912. _excelData.cell = _temp;
  913. if (_mergeArr.length) {
  914. var _cloneMessage = null;
  915. _mergeArr.forEach(function (info) {
  916. _cloneMessage = JSON.parse(JSON.stringify(messageInfo));
  917. _cloneMessage.content = info;
  918. us.updateExcel.merge(_cloneMessage, $);
  919. });
  920. }
  921. var _colDataChange = _colData.change, _temp = {}, _colChange;
  922. for (var k in _colDataChange) {
  923. _colChange = _colDataChange[k];
  924. if (k < _start) _temp[k] = _colChange;
  925. else if (k > _end) _temp[(+k) - _colNums] = _colChange;
  926. }
  927. _colData.change = _temp;
  928. _colData.num = _colData.num - _colNums;
  929. };
  930. us.updateExcel.merge = function (messageInfo, $) {
  931. var _taskId = messageInfo.worksheetId,
  932. _excelData = $[_taskId],
  933. _content = messageInfo.content,
  934. _cellData = _excelData.cell,
  935. _cellColList = _cellData[_content.col];
  936. if (_content.row === _content.endRow && _content.col === _content.endCol) {
  937. _cellData[_content.col][_content.row].endRow = "";
  938. _cellData[_content.col][_content.row].endCol = "";
  939. return;
  940. }
  941. if (!_cellColList) _cellColList = _cellData[_content.col] = {};
  942. if (!_cellColList[_content.row]) _cellColList[_content.row] = {};
  943. _cellColList[_content.row].innerHTML = _content.content;
  944. _cellColList[_content.row].endRow = _content.endRow;
  945. _cellColList[_content.row].endCol = _content.endCol;
  946. };
  947. us.updateExcel.splitCells = function (messageInfo, $) {
  948. var _taskId = messageInfo.worksheetId,
  949. _excelData = $[_taskId],
  950. _content = messageInfo.content,
  951. _cellData = _excelData.cell,
  952. _cell = _cellData[_content.col][_content.row];
  953. _cell.endRow = "";
  954. _cell.endCol = "";
  955. };
  956. us.updateExcel.rowExpanding = function (messageInfo, $) {
  957. var _taskId = messageInfo.worksheetId,
  958. _excelData = $[_taskId],
  959. _content = messageInfo.content,
  960. _rowData = _excelData.row;
  961. _content.forEach(function (data) {
  962. _rowData.change[data.rowName] = data.height;
  963. });
  964. };
  965. us.updateExcel.colExpanding = function (messageInfo, $) {
  966. var _taskId = messageInfo.worksheetId,
  967. _excelData = $[_taskId],
  968. _content = messageInfo.content,
  969. _colData = _excelData.column;
  970. _content.forEach(function (data) {
  971. _colData.change[data.colName] = data.width;
  972. });
  973. };
  974. us.updateExcel.addTask = function (messageInfo, $) {
  975. var _content = messageInfo.content, _taskId = _content.id;
  976. $[_taskId] = _content.data;
  977. };
  978. us.updateExcel.deleteTask = function (messageInfo, $) {
  979. var _content = messageInfo.content, _taskId = _content.id;
  980. delete ($[_taskId]);
  981. };
  982. us.updateExcel.reNameTask = function (messageInfo, $) {
  983. var _content = messageInfo.content, _taskId = _content.id;
  984. $[_taskId].taskName = _content.name;
  985. };
  986. us.updateExcel.img = function (messageInfo, $) {
  987. var _content = messageInfo.content,
  988. _taskId = messageInfo.worksheetId,
  989. _excelData = $[_taskId],
  990. _imgData = _excelData.img;
  991. _imgData.push(_content);
  992. };
  993. us.setword = function (messageinfo) { };
  994. us.senduser = function (userid, messageinfo) { us.userConnect[userid].response.end(messageinfo); };
  995. /* ============================================================
  996. * 以下是业务读写函数(与原文件一致)
  997. * ============================================================ */
  998. us.addWord = function (response, wordinfo) {
  999. wordinfo = JSON.parse(wordinfo);
  1000. var _docidarray = wordinfo.docId.split(','),
  1001. _userid = wordinfo.userId,
  1002. _pageid = wordinfo.pageId,
  1003. i, _docid, _docinfo;
  1004. for (i = 0; i < _docidarray.length; i++) {
  1005. _docid = _docidarray[i];
  1006. _docinfo = us.word[_docid];
  1007. if (!_docinfo) {
  1008. us.word[_docid] = { user: {}, history: [] };
  1009. us.word[_docid].user[_userid] = [_pageid];
  1010. } else if (!_docinfo.user[_userid]) {
  1011. _docinfo.user[_userid] = [_pageid];
  1012. } else if (_docinfo.user[_userid].indexOf(_pageid) == -1) {
  1013. _docinfo.user[_userid].push(_pageid);
  1014. }
  1015. if (us.offLineMessage[_pageid]) {
  1016. us.offLineMessage[_pageid].word.indexOf(_docid) == -1 && us.offLineMessage[_pageid].word.push(_docid);
  1017. }
  1018. }
  1019. response.end('addword');
  1020. };
  1021. us.quitOffice = function (response, wordinfo) {
  1022. wordinfo = JSON.parse(wordinfo);
  1023. var _docid = wordinfo.docId,
  1024. _userid = wordinfo.userId,
  1025. _pageid = wordinfo.pageId,
  1026. _type = wordinfo.type,
  1027. _messagetype = 'us.' + _type;
  1028. var _docinfo = us[_type][_docid];
  1029. if (_docinfo) {
  1030. us.quitUserList(_docinfo, _userid, _pageid);
  1031. var _j,
  1032. _message = us.offLineMessage[_pageid] ? us.offLineMessage[_pageid].message : [];
  1033. for (_j = _message.length - 1; _j > -1; _j--) {
  1034. if (_message[_j].type == _messagetype && _message[_j].messageInfo.docId == _docid) {
  1035. _message.splice(_j, 1);
  1036. }
  1037. }
  1038. us.insertHistory(_docinfo, _docid, _type);
  1039. }
  1040. response.end('quitOffice');
  1041. };
  1042. us.quitcscl = function (response, info) {
  1043. info = JSON.parse(info);
  1044. var _docid = info.docId,
  1045. _userid = info.userId,
  1046. _pageid = info.pageId,
  1047. _type = info.type;
  1048. var _docinfo = us[_type][_docid];
  1049. if (_docinfo) {
  1050. _userid = us.quitUserList(_docinfo, _userid, _pageid);
  1051. if (_userid) {
  1052. var _message = {};
  1053. var _messageinfo = us.message(_userid, 'us.cscl', {
  1054. id: us.createGuid(), type: "delUser",
  1055. userinfo: us.user[_userid], docId: _docid
  1056. });
  1057. _message[_docid] = [_messageinfo];
  1058. us.broadcast(_message, _pageid, "cscl");
  1059. }
  1060. }
  1061. response.end('quitcscl');
  1062. };
  1063. us.quitUserList = function (docinfo, userid, pageid) {
  1064. var _users = docinfo.user[userid];
  1065. if (_users) {
  1066. var _index = _users.indexOf(pageid);
  1067. if (_index != -1) {
  1068. _users.splice(_index, 1);
  1069. if (_users.length == 0) {
  1070. delete docinfo.user[userid];
  1071. return userid;
  1072. }
  1073. }
  1074. }
  1075. };
  1076. us.insertHistory = function (docinfo, docid, type) {
  1077. var i, _isuser = false;
  1078. for (i in docinfo.user) { _isuser = true; break; }
  1079. if (!_isuser) {
  1080. switch (type) {
  1081. case 'word':
  1082. var _content = docinfo.content ? docinfo.content('body').html().replace(/'/ig, '\\\'').replace(/"/ig, "\\\"") : "";
  1083. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'SaveFileContent', docid, _content, ''], function () { });
  1084. break;
  1085. case 'nav':
  1086. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'SaveFileContent', docid, JSON.stringify(docinfo.navInfo), ''], function () {
  1087. var _key;
  1088. for (_key in docinfo.page) {
  1089. var _content = docinfo.page[_key] ? docinfo.page[_key]('body').html().replace(/'/ig, '\\\'').replace(/"/ig, "\\\"") : "";
  1090. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Office', 'SaveNavPageContent', _key, _content], function () { });
  1091. }
  1092. });
  1093. break;
  1094. }
  1095. }
  1096. };
  1097. us.logout = function (response, userid, pageid) {
  1098. var j, istrue = true;
  1099. var _user = us.connect[userid];
  1100. us.deluser(userid, pageid);
  1101. if (_user) {
  1102. delete _user[pageid];
  1103. for (j in _user) { istrue = false; break; }
  1104. if (istrue) {
  1105. delete us.user[userid];
  1106. delete us.connect[userid];
  1107. }
  1108. }
  1109. response.end('logout');
  1110. };
  1111. us.getExcel = function (response, docid, pageid, userid) {
  1112. if (us.excel[docid]) {
  1113. if (!us.excel[docid].user[userid]) us.excel[docid].user[userid] = [pageid];
  1114. else us.excel[docid].user[userid].push(pageid);
  1115. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].excel.indexOf(docid) == -1) {
  1116. us.offLineMessage[pageid].excel.push(docid);
  1117. }
  1118. response.end(JSON.stringify(us.excel[docid].content));
  1119. } else {
  1120. us.excel[docid] = { user: {}, history: [] };
  1121. us.excel[docid].user[userid] = [pageid];
  1122. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].excel.indexOf(docid) == -1) {
  1123. us.offLineMessage[pageid].excel.push(docid);
  1124. }
  1125. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'GetFileContent', docid], function (ret) {
  1126. if (ret) {
  1127. var _office = JSON.parse(ret)[0][0].UsOffice;
  1128. us.excel[docid].content = JSON.parse(_office);
  1129. response.end(_office);
  1130. } else {
  1131. us.excel[docid].content = '';
  1132. response.end('');
  1133. }
  1134. });
  1135. }
  1136. };
  1137. us.getNav = function (response, fileid, pageid, userid) {
  1138. if (us.nav[fileid]) {
  1139. if (!us.nav[fileid].user[userid]) us.nav[fileid].user[userid] = [pageid];
  1140. else us.nav[fileid].user[userid].push(pageid);
  1141. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].nav.indexOf(fileid) == -1) {
  1142. us.offLineMessage[pageid].nav.push(fileid);
  1143. }
  1144. response.end(JSON.stringify(us.nav[fileid].navInfo));
  1145. } else {
  1146. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'GetFileContent', fileid], function (ret) {
  1147. if (ret) {
  1148. var _navinfo = JSON.parse(ret)[0][0].UsOffice;
  1149. if (_navinfo) {
  1150. var _navdata = us.nav[fileid] = {
  1151. user: {}, navInfo: JSON.parse(_navinfo), page: {}, history: []
  1152. };
  1153. _navdata.user[userid] = [pageid];
  1154. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].nav.indexOf(fileid) == -1) {
  1155. us.offLineMessage[pageid].nav.push(fileid);
  1156. }
  1157. response.end(JSON.stringify(_navinfo));
  1158. } else {
  1159. response.end('');
  1160. }
  1161. } else {
  1162. response.end('');
  1163. }
  1164. });
  1165. }
  1166. };
  1167. us.getNavPageContent = function (response, fileid, navid) {
  1168. if (us.nav[fileid] && us.nav[fileid].page[navid]) {
  1169. response.end(us.nav[fileid].page[navid]('body').html());
  1170. } else {
  1171. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Office', 'GetNavPageContent', navid], function (ret) {
  1172. if (ret && JSON.parse(ret)[0][0]) {
  1173. var _content = JSON.parse(ret)[0][0].content.replace(/\\'/ig, '\'').replace(/\\"/ig, "\"");
  1174. us.nav[fileid] && (us.nav[fileid].page[navid] = us.cheerio.load(_content));
  1175. response.end(_content);
  1176. } else {
  1177. response.end('');
  1178. }
  1179. });
  1180. }
  1181. };
  1182. us.newWordSave = function (response, docid, content, name, userid, pageid) {
  1183. us.word[docid] = { user: {}, history: [] };
  1184. us.word[docid].user[userid] = [pageid];
  1185. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].word.indexOf(docid) == -1) {
  1186. us.offLineMessage[pageid].word.push(docid);
  1187. }
  1188. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'SaveFileContent', docid, content, name], function (ret) {
  1189. if (ret) {
  1190. us.word[docid].content = us.cheerio.load(content.replace(/\\'/ig, '\'').replace(/\\"/ig, "\""));
  1191. response.end('save');
  1192. } else {
  1193. response.end('fail');
  1194. }
  1195. });
  1196. };
  1197. us.newExcelSave = function (response, docid, content, name, userid, pageid) {
  1198. us.excel[docid] = { user: {}, history: [] };
  1199. us.excel[docid].user[userid] = [pageid];
  1200. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].excel.indexOf(docid) == -1) {
  1201. us.offLineMessage[pageid].excel.push(docid);
  1202. }
  1203. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'SaveFileContent', docid, content, name], function (ret) {
  1204. if (ret) {
  1205. us.excel[docid].content = JSON.parse(content);
  1206. response.end('saveOk');
  1207. } else {
  1208. response.end('fail');
  1209. }
  1210. });
  1211. };
  1212. us.newNavSave = function (response, fileid, navinfo, name, nowpageid, nowpagecontent, userid, pageid) {
  1213. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'SaveFileContent', fileid, navinfo, name], function (ret) {
  1214. if (ret) {
  1215. var _navinfo = JSON.parse(navinfo);
  1216. if (!us.nav[fileid]) {
  1217. us.nav[fileid] = { user: {}, navInfo: _navinfo, page: {}, history: [] };
  1218. } else {
  1219. us.nav[fileid].navInfo = _navinfo;
  1220. }
  1221. var _navdata = us.nav[fileid];
  1222. _navdata.user[userid] = [pageid];
  1223. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].nav.indexOf(fileid) == -1) {
  1224. us.offLineMessage[pageid].nav.push(fileid);
  1225. }
  1226. if (nowpageid) us.SaveNavPageContent(response, fileid, nowpageid, nowpagecontent);
  1227. else response.end('saveContentSuccess');
  1228. } else {
  1229. response.end('saveNavFail');
  1230. }
  1231. });
  1232. };
  1233. us.SaveNavPageContent = function (response, fileid, nowpageid, nowpagecontent) {
  1234. var _navdata = us.nav[fileid];
  1235. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Office', 'SaveNavPageContent', nowpageid, nowpagecontent], function (ret) {
  1236. if (ret) {
  1237. _navdata.page[nowpageid] = us.cheerio.load(nowpagecontent.replace(/\\'/ig, '\'').replace(/\\"/ig, "\""));
  1238. response.end('saveContentSuccess');
  1239. } else {
  1240. response.end('saveContentFail');
  1241. }
  1242. });
  1243. };
  1244. us.copyPageContent = function (response, fileid, nowpageid, nowpagecontent, copypageid) {
  1245. if (!us.nav[fileid]) {
  1246. us.nav[fileid] = { user: {}, navInfo: "", page: {}, history: [] };
  1247. }
  1248. var _navdata = us.nav[fileid];
  1249. us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Office', 'CopyPageContent', nowpageid, nowpagecontent, copypageid], function (ret) {
  1250. if (ret) {
  1251. nowpagecontent == "" && (nowpagecontent = JSON.parse(ret)[0][0].content);
  1252. _navdata.page[nowpageid] = us.cheerio.load(nowpagecontent.replace(/\\'/ig, '\'').replace(/\\"/ig, "\""));
  1253. response.end('saveContentSuccess');
  1254. } else {
  1255. response.end('saveContentFail');
  1256. }
  1257. });
  1258. };
  1259. us.addExcel = function (response, excelinfo) {
  1260. excelinfo = JSON.parse(excelinfo);
  1261. var _excelinfo = us.excel[excelinfo.docId],
  1262. _userid = excelinfo.userId,
  1263. _pageid = excelinfo.pageId,
  1264. _docid = excelinfo.docId;
  1265. if (!_excelinfo) {
  1266. us.excel[_docid] = { user: {}, history: [] };
  1267. us.excel[_docid].user[_userid] = [_pageid];
  1268. } else if (!_excelinfo.user[_userid]) {
  1269. _excelinfo.user[_userid] = [_pageid];
  1270. } else if (_excelinfo.user[_userid].indexOf(_pageid) == -1) {
  1271. _excelinfo.user[_userid].push(_pageid);
  1272. }
  1273. if (us.offLineMessage[_pageid]) us.offLineMessage[_pageid].excel.push(_docid);
  1274. response.end('OK');
  1275. };
  1276. us.getcscl = function (response, calssid, pageid, userid) {
  1277. if (us.cscl[calssid]) {
  1278. if (!us.cscl[calssid].user[userid]) us.cscl[calssid].user[userid] = [pageid];
  1279. else if (us.cscl[calssid].user[userid].indexOf(pageid) == -1) us.cscl[calssid].user[userid].push(pageid);
  1280. try {
  1281. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].cscl.indexOf(calssid) == -1) {
  1282. us.offLineMessage[pageid].cscl.push(calssid);
  1283. }
  1284. } catch (e) { }
  1285. us.mysql.usselect(['172.16.12.5', 'pbl', 'select_room', calssid], function (ret) {
  1286. var _user = us.getuserbytype(us.cscl[calssid].user);
  1287. var _data = us.cscl[calssid].content;
  1288. if (ret) {
  1289. ret[0][0].user = _user;
  1290. ret[0][0].data = _data;
  1291. if (userid && us.user[userid]) us.sendUser(us.user[userid], "cscl", pageid, calssid);
  1292. response.end(JSON.stringify(ret));
  1293. } else {
  1294. response.end('');
  1295. }
  1296. });
  1297. } else {
  1298. us.cscl[calssid] = { user: {}, history: [] };
  1299. us.cscl[calssid].user[userid] = [pageid];
  1300. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].cscl.indexOf(calssid) == -1) {
  1301. us.offLineMessage[pageid].cscl.push(calssid);
  1302. }
  1303. us.mysql.usselect(['172.16.12.5', 'pbl', 'select_room', calssid], function (ret) {
  1304. var _user = us.getuserbytype(us.cscl[calssid].user);
  1305. if (ret) {
  1306. ret[0][0].user = _user;
  1307. try { us.cscl[calssid].content = JSON.parse(ret[0][0].data) || {}; }
  1308. catch (e) { us.cscl[calssid].content = ret[0][0].data || {}; }
  1309. response.end(JSON.stringify(ret));
  1310. } else {
  1311. us.cscl[calssid].content = {};
  1312. response.end('');
  1313. }
  1314. });
  1315. }
  1316. };
  1317. us.getcscldata = function (response, calssid, pageid, userid) {
  1318. if (us.cscl[calssid]) {
  1319. us.mysql.usselect(['172.16.12.5', 'pbl', 'select_room', calssid], function (ret) {
  1320. var _user = us.getuserbytype(us.cscl[calssid].user);
  1321. var _data = us.cscl[calssid].content;
  1322. if (ret) {
  1323. ret[0][0].user = _user;
  1324. ret[0][0].data = _data;
  1325. response.end(JSON.stringify(ret));
  1326. } else {
  1327. response.end('');
  1328. }
  1329. });
  1330. } else {
  1331. us.mysql.usselect(['172.16.12.5', 'pbl', 'select_room', calssid], function (ret) {
  1332. if (ret) {
  1333. ret[0][0].user = [];
  1334. response.end(JSON.stringify(ret));
  1335. } else {
  1336. response.end('');
  1337. }
  1338. });
  1339. }
  1340. };
  1341. us.getMindNetwork = function (response, docid, pageid, userid) {
  1342. if (us.mindNetwork[docid]) {
  1343. if (!us.mindNetwork[docid].user[userid]) us.mindNetwork[docid].user[userid] = [pageid];
  1344. else us.mindNetwork[docid].user[userid].push(pageid);
  1345. try {
  1346. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].mindNetwork.indexOf(docid) == -1) {
  1347. us.offLineMessage[pageid].mindNetwork.push(docid);
  1348. }
  1349. } catch (e) { }
  1350. us.mysql.usselect(['172.16.12.5', 'pbl', 'select_room', docid], function (ret) {
  1351. if (ret) {
  1352. ret[0][0].data = us.mindNetwork[docid].content;
  1353. response.end(JSON.stringify(ret));
  1354. } else {
  1355. response.end('');
  1356. }
  1357. });
  1358. } else {
  1359. us.mindNetwork[docid] = { user: {}, history: [] };
  1360. us.mindNetwork[docid].user[userid] = [pageid];
  1361. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].mindNetwork.indexOf(docid) == -1) {
  1362. us.offLineMessage[pageid].mindNetwork.push(docid);
  1363. }
  1364. us.mysql.usselect(['172.16.12.5', 'pbl', 'select_room', docid], function (ret) {
  1365. if (ret) {
  1366. us.mindNetwork[docid].content = JSON.parse(ret[0][0].data);
  1367. response.end(JSON.stringify(ret));
  1368. } else {
  1369. us.mindNetwork[docid].content = [];
  1370. response.end('');
  1371. }
  1372. });
  1373. }
  1374. };
  1375. us.getRealTimeClass = function (response, docid, pageid, userid) {
  1376. if (us.realTimeClass[docid]) {
  1377. if (!us.realTimeClass[docid].user[userid]) us.realTimeClass[docid].user[userid] = [pageid];
  1378. else us.realTimeClass[docid].user[userid].push(pageid);
  1379. try {
  1380. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].realTimeClass.indexOf(docid) == -1) {
  1381. us.offLineMessage[pageid].realTimeClass.push(docid);
  1382. }
  1383. } catch (e) { }
  1384. us.mysql.usselect(['172.16.12.5', 'pbl', 'selectPptPage', docid], function (ret) {
  1385. if (ret) {
  1386. ret[0][0].page = us.realTimeClass[docid].content;
  1387. response.end(JSON.stringify(ret));
  1388. } else {
  1389. response.end('');
  1390. }
  1391. });
  1392. } else {
  1393. us.realTimeClass[docid] = { user: {}, history: [] };
  1394. us.realTimeClass[docid].user[userid] = [pageid];
  1395. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].realTimeClass.indexOf(docid) == -1) {
  1396. us.offLineMessage[pageid].realTimeClass.push(docid);
  1397. }
  1398. us.mysql.usselect(['172.16.12.5', 'pbl', 'selectPptPage', docid], function (ret) {
  1399. if (ret) {
  1400. us.realTimeClass[docid].content = JSON.parse(ret[0][0].page);
  1401. response.end(JSON.stringify(ret));
  1402. } else {
  1403. us.realTimeClass[docid].content = [];
  1404. response.end('');
  1405. }
  1406. });
  1407. }
  1408. };
  1409. us.getWord = function (response, docid, pageid, userid) {
  1410. if (us.word[docid]) {
  1411. if (!us.word[docid].user[userid]) us.word[docid].user[userid] = [pageid];
  1412. else us.word[docid].user[userid].push(pageid);
  1413. try {
  1414. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].word.indexOf(docid) == -1) {
  1415. us.offLineMessage[pageid].word.push(docid);
  1416. }
  1417. } catch (e) { }
  1418. us.mysql.usselect(['172.16.12.5', 'pbl', 'select_file', docid], function (ret) {
  1419. if (ret) {
  1420. ret[0][0].data = us.word[docid].content('body').html();
  1421. response.end(JSON.stringify(ret));
  1422. } else {
  1423. us.word[docid].content = us.cheerio.load('');
  1424. response.end('');
  1425. }
  1426. });
  1427. } else {
  1428. us.word[docid] = { user: {}, history: [] };
  1429. us.word[docid].user[userid] = [pageid];
  1430. if (us.offLineMessage[pageid] && us.offLineMessage[pageid].word.indexOf(docid) == -1) {
  1431. us.offLineMessage[pageid].word.push(docid);
  1432. }
  1433. us.mysql.usselect(['172.16.12.5', 'pbl', 'select_file', docid], function (ret) {
  1434. if (ret) {
  1435. var _office = ret[0][0].data ? ret[0][0].data.replace(/\\'/ig, '\'').replace(/\\"/ig, "\"") : "";
  1436. us.word[docid].content = us.cheerio.load(_office);
  1437. response.end(_office);
  1438. } else {
  1439. us.word[docid].content = us.cheerio.load('');
  1440. response.end('');
  1441. }
  1442. });
  1443. }
  1444. };
  1445. /**
  1446. * 生成Guid
  1447. **/
  1448. us.createGuid = function () {
  1449. return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) {
  1450. var r = Math.random() * 16 | 0,
  1451. v = c == 'x' ? r : (r & 0x3 | 0x8);
  1452. return v.toString(16);
  1453. });
  1454. };
  1455. /**
  1456. * 监听1473端口
  1457. **/
  1458. us.server.listen('1473', '', function () {
  1459. setInterval(function () { us.offLine(); }, 60000);
  1460. console.log("开始监听" + us.server.address().port + "......");
  1461. });