123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055 |
- var us = {};
- us.cheerio = require("cheerio");
- us.qs = require("querystring");
- us.http = require("http");
- us.mysql = require("./mysql.js");
- us.connect = {
-
- }
- us.user = {
-
- }
- us.offLineMessage = {
-
- }
- us.mindNetwork = {
-
-
- }
- us.word = {
-
-
-
-
-
-
-
- }
- us.excel = {
-
-
- }
- us.nav = {
-
-
-
-
-
-
-
-
-
- }
- us.userConnect = function (pageId, response) {
- return {
- "pageId": pageId,
- "response": response,
- "loginTime": new Date(),
- "offLineTime": null
- }
- }
- us.userInfo = function (userid, username) {
- return {
- "userId": userid,
- "userName": username
- }
- }
- us.userOffLineMessage = function (type) {
- return {
- "message": [],
- "type": type,
- "word": [],
- "excel": [],
- "mindNetwork": [],
- "nav": []
- }
- }
- us.message = function (sendid, type, messageinfo) {
- return {
- id: us.createGuid(),
- sendId: sendid,
- time: new Date(),
- type: type,
- messageInfo: messageinfo
- }
- }
- us.server = us.http.createServer(function (requset, response) {
-
- response.writeHead(200, {
- "Content-Type": "text/html;application/json;charset=utf-8",
- 'Access-Control-Allow-Origin': '*',
- 'Access-Control-Allow-Headers': 'Origin, No-Cache, X-Requested-With, If-Modified-Since, Pragma, Last-Modified, Cache-Control, Expires, Content-Type, X-E4M-With'
- });
-
- us.unifyDispose(requset, response, function (param) {
- console.log(param)
- if (param && param[0]) {
-
- var _userinfo,
- _funname = param[0],
-
- _param = param.splice(1);
-
- switch (_funname) {
-
- case 'login':
- _userinfo = JSON.parse(_param[0]);
- us.login(response, _userinfo.userId, _userinfo.pageId, _userinfo.userName, _userinfo.type);
- break;
- case 'logout':
- us.logout(response, _param[0], _param[1]);
- break;
-
- case 'polling':
- us.polling(response, _param[0], _param[1], _param[2], _param[3]);
- break;
-
- case 'getWord':
- us.getWord(response, _param[0], _param[1], _param[2]);
- break;
-
- case 'getExcel':
- us.getExcel(response, _param[0], _param[1], _param[2]);
- break;
-
- case 'getNav':
- us.getNav(response, _param[0], _param[1], _param[2]);
- break;
-
- case 'getMindNetwork':
- us.getMindNetwork(response, _param[0], _param[1], _param[2]);
- break;
- case 'getNavPageContent':
- us.getNavPageContent(response, _param[0], _param[1]);
- break;
-
- case 'send':
- us.send(response, _param[0]);
- break;
- case 'quitOffice':
- us.quitOffice(response, _param[0]);
- break;
- case 'newWordSave':
- us.newWordSave(response, _param[0], _param[1], _param[2], _param[3], _param[4]);
- break;
- case 'newExcelSave':
- us.newExcelSave(response, _param[0], _param[1], _param[2], _param[3], _param[4]);
- break;
-
- case 'newNavSave':
-
- us.newNavSave(response, _param[0], _param[1], _param[2], _param[3], _param[4], _param[5], _param[6]);
- break;
-
- case 'addWord':
-
- break;
-
- case 'addExcel':
- us.addExcel(response, _param[0]);
- break;
-
- case 'addNav':
- break;
- case 'copyPageContent':
- us.copyPageContent(response, _param[0], _param[1], _param[2], _param[3]);
- break;
- case 'updateName':
- us.updateName(response, _param[0], _param[1], _param[2], _param[3], _param[4]);
- break;
- case 'insertModifyRecord':
- us.insertModifyRecord(response, _param[0], _param[1], _param[2], _param[3], _param[4], _param[4]);
- break;
- case 'addUser':
- us.addUser(response, _param[0], _param[1], _param[2], _param[3], _param[4]);
- break;
-
- default:
- response.end(0);
- }
- }
- else {
- response.end("");
- }
- });
- });
- us.insertModifyRecord = function (response, type, fileid, filename, html, userid, pageid) {
- var _html;
- if (us[type][fileid] && us[type][fileid].content) {
- _html = us[type][fileid].content('body').html().replace(/'/ig, "''").replace(/"/ig, "\\\"");
- } else {
- _html = html;
- }
-
- us.mysql.usselect([
- '127.0.0.1',
- 'UseStudio_Office',
- 'InsertDocumentModifyRecord',
- userid,
- fileid,
- _html,
- filename
- ], function (ret) {
- if (ret) {
- var _historyid = JSON.parse(ret)[0][0].historyid;
- var _message = {};
- var _messageinfo = us.message(userid, 'us.' + type, {
- id: us.createGuid(),
- type: "insertModifyRecord",
- historyid: _historyid,
- docId: fileid
- });
- _message[fileid] = [_messageinfo];
- us.broadcast(_message, pageid, type);
- response.end(_historyid);
- } else {
- response.end(ret);
- }
- });
- }
- us.updateName = function (response, type, fileid, filename, userid, pageid) {
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Disk',
- 'UpdateFileInfo',
- fileid,
- filename
- ], function (ret) {
- if (ret) {
- var _message = {};
- var _messageinfo = us.message(userid, 'us.' + type, {
- id: us.createGuid(),
- type: "updateName",
- name: filename,
- docId: fileid
- });
- _message[fileid] = [_messageinfo];
- us.broadcast(_message, pageid, type);
- response.end('updateNameSuccess');
- } else {
- response.end('updateNameFail');
- }
- });
- }
- us.addUser = function (response, type, fileid, userids, userid, pageid) {
- var _message = {};
- var _messageinfo = us.message(userid, 'us.' + type, {
- id: us.createGuid(),
- type: "addUser",
- userIds: userids,
- docId: fileid
- });
- _message[fileid] = [_messageinfo];
- us.broadcast(_message, pageid, type);
- response.end('addUserSuccess');
- }
- us.unifyDispose = function (req, res, cb) {
- var i, _param = "";
-
- req.on("data", function (chunk) {
- _param += chunk;
- });
-
- req.on("end", function () {
- console.log(_param)
-
- if (_param) {
- _param = us.qs.parse(_param);
- }
- console.log(_param)
-
- try {
- _param = _param.mode.split(",")
- } catch (e) {
- _param = req.query;
- }
- if (_param) {
-
- for (i = 0; i < _param.length; i++) {
- _param[i] = decodeURIComponent(_param[i]);
- }
- } else {
- _param = [];
- }
-
- cb(_param);
- });
-
- res.on('timeout', function (e) {
- console.log('请求超时');
- if (req.res) {
- req.res("abort");
- }
- res.end("false");
- });
-
- res.setTimeout(30000, function () {
- console.log("响应超时.");
- res.end("false");
- });
-
- req.on("error", function (e) {
- console.log('程序报错');
- res.end("false");
- });
- }
- us.login = function (response, userid, pageid, username, type) {
- console.log(userid);
-
-
- if (!us.user[userid]) {
- var _userinfo = us.userInfo(userid, username);
- us.user[userid] = _userinfo;
- }
- console.log(us.user);
-
- us.polling(response, userid, pageid, type);
- }
- us.offLine = function (response, userid, pageid) {
-
- us.user[userid].offineTime = new Date();
-
- var _joinword = us.offLineMessage[pageid].word;
- var _joinexcel = us.offLineMessage[pageid].excel;
- var _docuser, _now;
- var i, j, o;
-
- for (i = 0; i < _joinword.length; i++) {
- _docuser = us.word[_joinword[i]].user[userid];
- _now = _docuser.indexOf(pageid);
- _now != -1 && us.word[_joinword[i]].user.splice(_now, 1);
- }
-
- for (j = 0; j < _joinexcel.length; j++) {
- _docuser = us.excel[_joinexcel[j]].user[userid];
- _now = _docuser.indexOf(pageid);
- _now != -1 && us.excel[_joinexcel[j]].user.splice(_now, 1);
- }
-
- delete us.connect[userid][pageid];
-
- delete us.offLineMessage[pageid];
-
- response.end('offLine');
- }
- us.polling = function (response, userid, pageid, type) {
-
- if (us.connect[userid]) {
- var _userarray = us.connect[userid],
- _messagearray = us.offLineMessage[pageid]
- ;
-
- if (_userarray[pageid]) {
- _userarray[pageid].response = response;
- console.log(pageid);
- if (_messagearray && _messagearray.message.length > 0) {
- response.end(JSON.stringify(_messagearray.message));
- _messagearray.message = [];
- } else {
- us.offLineMessage[pageid] = us.userOffLineMessage(type);
- }
- return;
- }
-
- _userarray[pageid] = us.userConnect(pageid, response);
- us.offLineMessage[pageid] = us.userOffLineMessage(type);
- } else {
- var _userconect = us.userConnect(pageid, response);
- us.connect[userid] = {};
- us.connect[userid][pageid] = _userconect;
- us.offLineMessage[pageid] = us.userOffLineMessage(type);
- }
- console.log(us.connect);
- }
- us.send = function (response, messageinfo) {
- console.log(messageinfo);
- var i, j,
- _message,
- _messagelist = {},
- _messageobj = JSON.parse(messageinfo)
- ;
-
- for (i in _messageobj) {
- switch (i) {
-
- case "us.mindNetwork":
- _messagearr = _messageobj[i];
-
- for (j = 0; j < _messagearr.length; j++) {
-
- _message = us.message(_messagearr[j].sendId, "us.mindNetwork", _messagearr[j].messageInfo);
-
- if (_messagelist[_messagearr[j].receiveId]) {
- _messagelist[_messagearr[j].receiveId].push(_message);
- } else {
- _messagelist[_messagearr[j].receiveId] = [_message];
- }
- us.mindNetwork[_message.messageInfo.docId] && us.mindNetwork[_message.messageInfo.docId].history.push(_message);
- us.updatemindNetwork(_message.messageInfo);
- }
-
- _messagearr[0] && us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'mindNetwork');
- break;
-
- case "us.word":
- try {
- _messagearr = _messageobj[i];
-
- for (j = 0; j < _messagearr.length; j++) {
-
- _message = us.message(_messagearr[j].sendId, "us.word", _messagearr[j].messageInfo);
-
- if (_messagelist[_messagearr[j].receiveId]) {
- _messagelist[_messagearr[j].receiveId].push(_message);
- } else {
- _messagelist[_messagearr[j].receiveId] = [_message];
- }
- us.word[_message.messageInfo.docId] && us.word[_message.messageInfo.docId].history.push(_message);
- us.updateWord(_message.messageInfo);
- }
-
-
-
- _messagearr[0] && us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'word');
- }
- catch (e) {
- console.log(e)
- }
- break;
-
- case "us.excel":
- _messagearr = _messageobj[i];
-
- for (j = 0; j < _messagearr.length; j++) {
-
- _message = us.message(_messagearr[j].sendId, _messagearr[j].type, _messagearr[j].messageInfo);
-
- if (_messagelist[_messagearr[j].receiveId]) {
- _messagelist[_messagearr[j].receiveId].push(_message);
- } else {
- _messagelist[_messagearr[j].receiveId] = [_message];
- }
- us.excel[_message.messageInfo.docId] && us.excel[_message.messageInfo.docId].history.push(_message);
- us.updateExcel(_message.messageInfo);
- }
-
-
-
- us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'excel');
- break;
- case "us.nav":
- _messagearr = _messageobj[i];
-
- for (j = 0; j < _messagearr.length; j++) {
-
- _message = us.message(_messagearr[j].sendId, "us.nav", _messagearr[j].messageInfo);
-
- if (_messagelist[_messagearr[j].receiveId]) {
- _messagelist[_messagearr[j].receiveId].push(_message);
- } else {
- _messagelist[_messagearr[j].receiveId] = [_message];
- }
- us.nav[_message.messageInfo.docId] && us.nav[_message.messageInfo.docId].history.push(_message);
- us.updateNav(_message.messageInfo);
- }
-
- us.broadcast(_messagelist, _messagearr[0].messageInfo.pageId, 'nav');
- break;
- }
- }
- response.end('send');
- }
- us.updatemindNetwork = function (messageInfo) {
- if (us.mindNetwork[messageInfo.docId]) {
- var $ = us.mindNetwork[messageInfo.docId].content;
- console.log("---------------------------------------start")
- console.log($);
- console.log("---------------------------------------end")
- console.log("---------------------------------------infostart")
- console.log(messageInfo);
- console.log("---------------------------------------infoend")
- if ($) {
- us.mindNetwork[messageInfo.docId].content[messageInfo.id] = messageInfo.content;
- }
- }
- }
- us.updateWord = function (messageInfo) {
- if (us.word[messageInfo.docId]) {
- var $ = us.word[messageInfo.docId].content;
- if ($) {
- switch (messageInfo.type) {
- case 'update':
- us.updateEditorLine(messageInfo, $);
- break;
- case 'add':
- us.addEditorLine(messageInfo, $);
- break;
- case 'delete':
- us.deleteEditorLine(messageInfo, $);
- break;
- }
- }
- }
- }
- us.updateNav = function (messageInfo) {
- var _fileinfo = us.nav[messageInfo.docId];
- if (_fileinfo) {
- switch (messageInfo.type) {
- case 'update':
- us.updateEditorLine(messageInfo, _fileinfo.page[messageInfo.navId]);
- break;
- case 'add':
- us.addEditorLine(messageInfo, _fileinfo.page[messageInfo.navId]);
- break;
- case 'delete':
- us.deleteEditorLine(messageInfo, _fileinfo.page[messageInfo.navId]);
- break;
- case 'addNav':
- us.updateNav.addNav(_fileinfo, messageInfo.parentId, messageInfo.index, messageInfo.addNav, messageInfo.content);
- break;
- case 'updateNav':
- us.updateNav.updateNav(_fileinfo.navInfo.nav, messageInfo.navId, messageInfo.name);
- break;
- case 'deleteNav':
- us.updateNav.deleteNav(_fileinfo, messageInfo.navId, messageInfo.parentId);
- break;
- case 'updateLogo':
- _navinfo.logo = messageInfo.logo;
- break;
- }
- }
- }
- us.selectByNavId = function (nowinfo, navid) {
- var i = 0;
- for (i = 0; i < nowinfo.length; i++) {
- object = nowinfo[i];
- if (object.pageId == navid) {
- return object;
- } else if (object.child) {
- return us.selectNav(object.child, navid);
- }
- }
- }
- us.updateNav.addNav = function (fileinfo, parentid, index, addnav, content) {
- var _nav = fileinfo.navInfo.nav;
- var _parent;
- if (parentid) {
-
- _parent = us.selectByNavId(_nav, parentid);
-
- if (_parent.child) {
-
- _parent.child.splice(index, 0, addnav);
- } else {
-
- _parent.child = [addnav];
- }
- } else {
- _parent = _nav;
- _parent.splice(index, 0, addnav);
- }
-
- fileinfo.page[addnav.pageId] = us.cheerio.load(content.replace(/\\'/ig, '\'').replace(/\\"/ig, "\""));
- }
- us.updateNav.updateNav = function (nav, navid, name) {
-
- var _nav = us.selectByNavId(nav, navid);
- if (_nav) {
- _nav.name = name;
- }
- }
- us.updateNav.deleteNav = function (fielinfo, deletenavid, parentid) {
- var _nav = fielinfo.navInfo.nav;
- var _parent;
- if (parentid) {
-
- _parent = us.selectByNavId(_nav, parentid);
- } else {
- _parent = _nav;
- }
- if (_parent) {
- var _child = parentid ? _parent.child : _parent;
- _child.find(function (object, index) {
- if (object.pageId == deletenavid) {
- if (!object.child) {
- _child.splice(index, 1);
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Office',
- 'DeletePage',
- deletenavid
- ], function (ret) {
- if (ret) {
- delete fielinfo.page[deletenavid];
- }
- });
- }
- return true;
- }
- });
- }
- }
- us.updateEditorLine = function (opera, $) {
-
- $('#' + opera.id).replaceWith(opera.content);
- }
- us.deleteEditorLine = function (opera, $) {
- $('#' + opera.id).remove();
- }
- us.addEditorLine = function (opera, $) {
- var _next;
- if (opera.nextId && (_next = $('#' + opera.nextId))[0]) {
-
- _next.before(opera.content);
- } else {
- $('body').append(opera.content);
- }
- }
- us.updateExcel = function (messageInfo) {
- var $ = us.excel[messageInfo.docId].content;
- if ($) {
- switch (messageInfo.type) {
- case 'blur':
- us.updateExcel.Blur(messageInfo, $);
- break;
- case "addLine":
- us.updateExcel.addLine(messageInfo, $);
- break;
- case "delLine":
- us.updateExcel.delLine(messageInfo, $);
- break;
- case "addCol":
- us.updateExcel.addCol(messageInfo, $);
- break;
- case "delCol":
- us.updateExcel.delCol(messageInfo, $);
- break;
- case "merge":
- us.updateExcel.merge(messageInfo, $);
- break;
- case "splitCells":
- us.updateExcel.splitCells(messageInfo, $);
- break;
- case "rowExpanding":
- us.updateExcel.rowExpanding(messageInfo, $);
- break;
- case "colExpanding":
- us.updateExcel.colExpanding(messageInfo, $);
- break;
- case "addTask":
- us.updateExcel.addTask(messageInfo, $);
- break;
- case "deleteTask":
- us.updateExcel.deleteTask(messageInfo, $);
- break;
- case "reNameTask":
- us.updateExcel.reNameTask(messageInfo, $);
- break;
- case "img":
- us.updateExcel.img(messageInfo, $);
- break;
- }
- }
-
- }
- us.updateExcel.Blur = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _cellData = _excelData.cell,
- _content = messageInfo.content;
- _content.forEach(function (data) {
- var _text = data.innerText.replace(/\s+/g, ""),
- _cellColList = _cellData[data.col],
- _cell = null;
- if (!_cellColList) {
- _cellColList = _cellData[data.col] = {};
- }
- if (!_cellColList[data.row]) {
- _cellColList[data.row] = {};
- _cellColList[data.row].cssStyle = {};
- }
- _cell = _cellColList[data.row];
- data.content ? _cell.innerHTML = data.content : "";
- if (data.attr) {
- _cell.cssStyle[data.attr] = data.value;
- if (!data.value) {
- delete _cell.cssStyle[data.attr]
- }
- }
- if (data.clearStyle) {
- data.cssStyle = {}
- }
- if (((!(_text) || _text === ("\u200D")) && !(_cell.endRow)) && !(us.jsonLen(_cell.cssStyle))) {
- delete (_cellColList[data.row]);
- }
- });
- }
- us.jsonLen = function (json) {
- var _json = json,
- _len = 0;
- for (var i in json) {
- _len++;
- }
- return _len;
- }
- us.updateExcel.addLine = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _content = messageInfo.content,
- _excelData = $[_taskId],
- _rowData = _excelData.row,
- _cellData = _excelData.cell,
- _start = _content.start,
- _lineNum = _content.lineNum,
- _sizeChange = _content.sizeChange,
- _mergeArr = _content.mergeArr,
- _cellCol = null;
- if (_mergeArr.length) {
- _mergeArr.forEach(function (info) {
- _cellData[info.col][info.row].endRow = _cellData[info.col][info.row].endRow + _lineNum;
- });
- }
- for (var k in _cellData) {
- _cellCol = _cellData[k];
- var temp = {};
- for (var row in _cellCol) {
- if (row > _start) {
- temp[(+row) + _lineNum] = _cellCol[row];
- temp[(+row) + _lineNum].endRow ? temp[(+row) + _lineNum].endRow = temp[(+row) + _lineNum].endRow + _lineNum : "";
- } else {
- temp[row] = _cellCol[row];
- }
- }
- _cellData[k] = temp;
- }
- var _rowDataChange = _rowData.change,
- _temp = {},
- _rowChange = null;
- for (var k in _rowDataChange) {
- _rowChange = _rowDataChange[k];
- if (k > _start) {
- _temp[(+k) + _lineNum] = _rowChange;
- } else {
- _temp[k] = _rowChange;
- }
- }
- _rowData.change = _temp;
- if (_sizeChange) {
- for (var i = 1; i <= _lineNum; i++) {
- _rowData.change[_start + i] = _sizeChange;
- }
- }
- _rowData.num = _rowData.num + _lineNum;
- };
- us.updateExcel.delLine = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _content = messageInfo.content,
- _rowData = _excelData.row,
- _cellData = _excelData.cell,
- _start = _content.start,
- _end = _content.end,
- _lineNum = _content.lineNum,
- _mergeArr = _content.mergeArr,
- _cellCol = null;
- for (var k in _cellData) {
- _cellCol = _cellData[k];
- var temp = {};
- for (var row in _cellCol) {
- if (row > _end) {
- temp[(+row) - _lineNum] = _cellCol[row];
- temp[(+row) - _lineNum].endRow ? temp[(+row) - _lineNum].endRow = temp[(+row) - _lineNum].endRow - _lineNum : "";
- } else if (row < _start) {
- temp[row] = _cellCol[row];
- }
- }
- _cellData[k] = temp;
- }
- if (_mergeArr.length) {
- var _cloneMessage = null;
- _mergeArr.forEach(function (info) {
- _cloneMessage = JSON.parse(JSON.stringify(messageInfo));
- _cloneMessage.content = info;
- us.updateExcel.merge(_cloneMessage, $);
- });
- }
- var _rowDataChange = _rowData.change,
- _temp = {},
- _rowChange = null;
- for (var k in _rowDataChange) {
- _rowChange = _rowDataChange[k];
- if (k < _start) {
- _temp[k] = _rowChange;
- } else if (k > _end) {
- _temp[(+k) - _lineNum] = _rowChange;
- }
- }
- _rowData.change = _temp;
- _rowData.num = _rowData.num - _lineNum;
- };
- us.updateExcel.addCol = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _content = messageInfo.content,
- _colData = _excelData.column,
- _cellData = _excelData.cell,
- _start = _content.start,
- _sizeChange = _content.sizeChange,
- _colNums = _content.colNums,
- _mergeArr = _content.mergeArr,
- _cellCol = null,
- _temp = {};
- if (_mergeArr.length) {
- _mergeArr.forEach(function (info) {
- _cellData[info.col][info.row].endCol = _cellData[info.col][info.row].endCol + _colNums;
- });
- }
- for (var k in _cellData) {
- _cellCol = _cellData[k];
- if (k > _start) {
- _temp[+(k) + _colNums] = _cellCol;
- var _temp2 = _temp[(+k) + _colNums];
- for (var i in _temp2) {
- _temp2[i].endCol ? _temp2[i].endCol = _temp2[i].endCol + _colNums : "";
- }
- } else {
- _temp[k] = _cellCol;
- }
- }
- _excelData.cell = _temp;
- var _colDataChange = _colData.change,
- _temp = {},
- _colChange = null;
- for (var k in _colDataChange) {
- _colChange = _colDataChange[k];
- if (k > _start) {
- _temp[(+k) + _colNums] = _colChange;
- } else {
- _temp[k] = _colChange;
- }
- }
- _colData.change = _temp;
- if (_sizeChange) {
- for (var i = 1; i <= _colNums; i++) {
- _colData.change[_start + i] = _sizeChange;
- }
- }
- _colData.num = _colData.num + _colNums;
- };
- us.updateExcel.delCol = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _content = messageInfo.content,
- _colData = _excelData.column,
- _cellData = _excelData.cell,
- _start = _content.start,
- _end = _content.end,
- _colNums = _content.colNums,
- _mergeArr = _content.mergeArr,
- _cellCol = null,
- _temp = {};
- for (var k in _cellData) {
- _cellCol = _cellData[k];
- if (k > _end) {
- _temp[+(k) - _colNums] = _cellCol;
- var _temp2 = _temp[(+k) - _colNums];
- for (var i in _temp2) {
- _temp2[i].endCol ? _temp2[i].endCol = _temp2[i].endCol - _colNums : "";
- }
- } else if (k < _start) {
- _temp[k] = _cellCol;
- }
- }
- _excelData.cell = _temp;
- if (_mergeArr.length) {
- var _cloneMessage = null;
- _mergeArr.forEach(function (info) {
- _cloneMessage = JSON.parse(JSON.stringify(messageInfo));
- _cloneMessage.content = info;
- us.updateExcel.merge(_cloneMessage, $);
- });
- }
- var _colDataChange = _colData.change,
- _temp = {},
- _colChange;
- for (var k in _colDataChange) {
- _colChange = _colDataChange[k];
- if (k < _start) {
- _temp[k] = _colChange;
- } else if (k > _end) {
- _temp[(+k) - _colNums] = _colChange;
- }
- }
- _colData.change = _temp;
- _colData.num = _colData.num - _colNums;
- };
- us.updateExcel.merge = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _content = messageInfo.content,
- _cellData = _excelData.cell,
- _cellColList = _cellData[_content.col];
- if (_content.row === _content.endRow && _content.col === _content.endCol) {
- _cellData[_content.col][_content.row].endRow = "";
- _cellData[_content.col][_content.row].endCol = ""
- return;
- }
- if (!_cellColList) {
- _cellColList = _cellData[_content.col] = {};
- }
- if (!_cellColList[_content.row]) {
- _cellColList[_content.row] = {};
- }
- _cellColList[_content.row].innerHTML = _content.content;
- _cellColList[_content.row].endRow = _content.endRow;
- _cellColList[_content.row].endCol = _content.endCol;
- };
- us.updateExcel.splitCells = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _content = messageInfo.content,
- _cellData = _excelData.cell,
- _cell = _cellData[_content.col][_content.row];
- _cell.endRow = "";
- _cell.endCol = "";
- };
- us.updateExcel.rowExpanding = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _content = messageInfo.content,
- _rowData = _excelData.row;
- _content.forEach(function (data) {
- var _rowNum = data.rowName,
- _rowHeight = data.height;
- _rowData.change[_rowNum] = _rowHeight;
- });
- };
- us.updateExcel.colExpanding = function (messageInfo, $) {
- var _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _content = messageInfo.content,
- _colData = _excelData.column;
- _content.forEach(function (data) {
- var _colNum = data.colName,
- _colWidth = data.width;
- _colData.change[_colNum] = _colWidth;
- });
- };
- us.updateExcel.addTask = function (messageInfo, $) {
- var _content = messageInfo.content,
- _taskId = _content.id;
- $[_taskId] = _content.data;
- };
- us.updateExcel.deleteTask = function (messageInfo, $) {
- var _content = messageInfo.content,
- _taskId = _content.id;
- delete ($[_taskId]);
- };
- us.updateExcel.reNameTask = function (messageInfo, $) {
- var _content = messageInfo.content,
- _taskId = _content.id;
- $[_taskId].taskName = _content.name;
- };
- us.updateExcel.img = function (messageInfo, $) {
- var _content = messageInfo.content,
- _taskId = messageInfo.worksheetId,
- _excelData = $[_taskId],
- _imgData = _excelData.img;
- _imgData.push(_content);
- };
- us.setword = function (messageinfo) {
-
- }
- us.senduser = function (userid, messageinfo) {
- us.userConnect[userid].response.end(messageinfo);
- }
- us.broadcast = function (messageinfo, pageid, type) {
- var i, j, o,
- _messageinfo,
- _users,
- _pageids,
- _recievedpageid,
- _issend,
- _userconnect = us.connect;
- console.log("1")
- console.log(messageinfo)
- for (i in messageinfo) {
- _messageinfo = messageinfo[i];
- _users = us[type][i] ? us[type][i].user : {};
- console.log(_users)
- for (j in _users) {
- _pageids = _users[j];
- for (o = 0; o < _pageids.length; o++) {
- _recievedpageid = _pageids[o];
- if (_recievedpageid != pageid) {
- console.log("2")
- console.log(_users[j])
-
- _issend = _userconnect[j][_recievedpageid].response.end(JSON.stringify(_messageinfo));
- if (!_issend) {
- console.log("3")
- us.offLineMessage[_recievedpageid].message.push(_messageinfo);
- }
- }
- }
- }
- }
- }
- us.addWord = function (response, wordinfo) {
-
- wordinfo = JSON.parse(wordinfo);
- var _docidarray = wordinfo.docId.split(','),
- _userid = wordinfo.userId,
- _pageid = wordinfo.pageId,
- i,
- _docid,
- _docinfo;
- for (i = 0; i < _docidarray.length; i++) {
- _docid = _docidarray[i];
- _docinfo = us.word[_docid];
- if (!_docinfo) {
- us.word[_docid] = {
- user: {},
- history: []
- };
- us.word[_docid].user[_userid] = [_pageid];
- } else if (!_docinfo.user[_userid]) {
- _docinfo.user[_userid] = [_pageid];
- } else if (_docinfo.user[_userid].indexOf(_pageid) == -1) {
- _docinfo.user[_userid].push(_pageid);
- }
- us.offLineMessage[_pageid].word.push(_docid);
- }
- response.end('addword');
- }
- us.quitOffice = function (response, wordinfo) {
-
- wordinfo = JSON.parse(wordinfo);
- var _docid = wordinfo.docId,
- _userid = wordinfo.userId,
- _pageid = wordinfo.pageId,
- _type = wordinfo.type,
- _messagetype = 'us.' + _type;
- var _docinfo = us[_type][_docid];
-
- if (_docinfo) {
- us.quitUserList(_docinfo, _userid, _pageid);
- var _j,
- _message = us.offLineMessage[_pageid] ? us.offLineMessage[_pageid].message : [];
- for (_j = _message.length - 1; _j > -1; _j--) {
- if (_message[_j].type == _messagetype && _message[_j].messageInfo.docId == _docid) {
- _message.splice(_j, 1);
- }
- }
- us.insertHistory(_docinfo, _docid, _type);
- }
- response.end('quitOffice');
- }
- us.quitUserList = function (docinfo, userid, pageid) {
- var _users = docinfo.user[userid];
-
- if (_users) {
- var _index = _users.indexOf(pageid);
-
- if (_index != -1) {
- _users.splice(_index, 1);
-
- if (_users.length == 0) {
- delete docinfo.user[userid];
- }
- }
- }
- }
- us.insertHistory = function (docinfo, docid, type) {
- var i,
- _info,
- _isuser = false;
- for (i in docinfo.user) {
- _isuser = true;
- break;
- }
-
- if (!_isuser) {
- switch (type) {
- case 'word':
- var _content = docinfo.content ? docinfo.content('body').html().replace(/'/ig, '\\\'').replace(/"/ig, "\\\"") : "";
- us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'SaveFileContent', docid, _content, ''],
- function (ret) { });
- break;
- case 'nav':
- us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Disk', 'SaveFileContent', docid, JSON.stringify(docinfo.navInfo), ''],
- function (ret) {
- var _key;
- for (_key in docinfo.page) {
-
- var _content = docinfo.page[_key] ? docinfo.page[_key]('body').html().replace(/'/ig, '\\\'').replace(/"/ig, "\\\"") : "";
- us.mysql.usselect(['sqlserver.1473.cn', 'UseStudio_Office', 'SaveNavPageContent', _key, _content], function (ret) { });
- }
- });
- break;
- }
- }
- }
- us.logout = function (response, userid, pageid) {
- var i, j, _docinfo,
- _wordids = us.offLineMessage[pageid].word,
- _excelids = us.offLineMessage[pageid].excel;
- us.connect[userid][pageid].offLineTime = new Date();
- for (i = 0; i < _wordids.length; i++) {
- _docinfo = us.word[_wordids[i]];
- if (_docinfo) {
- us.quitUserList(_docinfo, userid, pageid);
- delete us.offLineMessage[pageid];
- us.insertHistory(_docinfo, 'word');
- }
- }
- for (j = 0; i < _excelids.length; j++) {
- _docinfo = us.excel[_excelids[j]];
- if (_docinfo) {
- us.quitUserList(_docinfo, userid, pageid);
- delete us.offLineMessage[pageid];
- us.insertHistory(_docinfo, 'excel');
- }
- }
- response.end('logout');
- }
- us.getExcel = function (response, docid, pageid, userid) {
-
- if (us.excel[docid]) {
-
- if (!us.excel[docid].user[userid]) {
- us.excel[docid].user[userid] = [pageid];
- } else {
- us.excel[docid].user[userid].push(pageid);
- }
- us.offLineMessage[pageid].excel.indexOf(docid) == -1 && us.offLineMessage[pageid].excel.push(docid);
- var _office = us.excel[docid].content;
- response.end(JSON.stringify(_office));
- } else {
- us.excel[docid] = {
- user: {},
- history: []
- };
- us.excel[docid].user[userid] = [pageid];
- us.offLineMessage[pageid].excel.indexOf(docid) == -1 && us.offLineMessage[pageid].excel.push(docid);
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Disk',
- 'GetFileContent',
- docid
- ], function (ret) {
- if (ret) {
- var _office = JSON.parse(ret)[0][0].UsOffice;
- us.excel[docid].content = JSON.parse(_office);
- response.end(_office);
- } else {
- us.excel[docid].content = '';
- response.end('');
- }
- });
- }
- }
- us.getNav = function (response, fileid, pageid, userid) {
-
- if (us.nav[fileid]) {
-
- if (!us.nav[fileid].user[userid]) {
- us.nav[fileid].user[userid] = [pageid];
- } else {
- us.nav[fileid].user[userid].push(pageid);
- }
- us.offLineMessage[pageid].nav.indexOf(fileid) == -1 && us.offLineMessage[pageid].nav.push(fileid);
- response.end(JSON.stringify(us.nav[fileid].navInfo));
- } else {
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Disk',
- 'GetFileContent',
- fileid
- ], function (ret) {
- if (ret) {
- var _navinfo = JSON.parse(ret)[0][0].UsOffice;
- if (_navinfo) {
- var _navdata = us.nav[fileid] = {
- user: {},
- navInfo: JSON.parse(_navinfo),
- page: {},
- history: []
- };
- _navdata.user[userid] = [pageid];
- us.offLineMessage[pageid].nav.indexOf(fileid) == -1 && us.offLineMessage[pageid].nav.push(fileid);
- response.end(JSON.stringify(_navinfo));
- } else {
- response.end('');
- }
- } else {
- response.end('');
- }
- });
- }
- }
- us.getNavPageContent = function (response, fileid, navid) {
- if (us.nav[fileid] && us.nav[fileid].page[navid]) {
- response.end(us.nav[fileid].page[navid]('body').html());
- } else {
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Office',
- 'GetNavPageContent',
- navid
- ], function (ret) {
- if (ret && JSON.parse(ret)[0][0]) {
- var _content = JSON.parse(ret)[0][0].content.replace(/\\'/ig, '\'').replace(/\\"/ig, "\"");
- us.nav[fileid] && (us.nav[fileid].page[navid] = us.cheerio.load(_content));
- response.end(_content);
- } else {
- response.end('');
- }
- });
- }
- }
- us.newWordSave = function (response, docid, content, name, userid, pageid) {
- us.word[docid] = {
- user: {},
- history: []
- };
- us.word[docid].user[userid] = [pageid];
- us.offLineMessage[pageid].word.indexOf(docid) == -1 && us.offLineMessage[pageid].word.push(docid);
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Disk',
- 'SaveFileContent',
- docid,
- content,
- name
- ], function (ret) {
- if (ret) {
-
- us.word[docid].content = us.cheerio.load(content.replace(/\\'/ig, '\'').replace(/\\"/ig, "\""));
- response.end('save');
- } else {
- response.end('fail');
- }
- });
- }
- us.newExcelSave = function (response, docid, content, name, userid, pageid) {
- us.excel[docid] = {
- user: {},
- history: []
- };
- us.excel[docid].user[userid] = [pageid];
- us.offLineMessage[pageid].excel.indexOf(docid) == -1 && us.offLineMessage[pageid].word.push(docid);
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Disk',
- 'SaveFileContent',
- docid,
- content,
- name
- ], function (ret) {
- if (ret) {
-
- us.excel[docid].content = JSON.parse(content);
- response.end('saveOk');
- } else {
- response.end('fail');
- }
- });
- }
- us.newNavSave = function (response, fileid, navinfo, name, nowpageid, nowpagecontent, userid, pageid) {
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Disk',
- 'SaveFileContent',
- fileid,
- navinfo,
- name
- ], function (ret) {
- if (ret) {
- var _navinfo = JSON.parse(navinfo);
- if (!us.nav[fileid]) {
- us.nav[fileid] = {
- user: {},
- navInfo: _navinfo,
- page: {},
- history: []
- };
- } else {
- us.nav[fileid].navInfo = _navinfo;
- }
- var _navdata = us.nav[fileid];
- _navdata.user[userid] = [pageid];
- us.offLineMessage[pageid].nav.indexOf(fileid) == -1 && us.offLineMessage[pageid].nav.push(fileid);
- if (nowpageid) {
- us.SaveNavPageContent(response, fileid, nowpageid, nowpagecontent);
- } else {
- response.end('saveContentSuccess');
- }
- } else {
- response.end('saveNavFail');
- }
- });
- }
- us.SaveNavPageContent = function (response, fileid, nowpageid, nowpagecontent) {
- var _navdata = us.nav[fileid];
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Office',
- 'SaveNavPageContent',
- nowpageid,
- nowpagecontent
- ], function (ret) {
- if (ret) {
- _navdata.page[nowpageid] = us.cheerio.load(nowpagecontent.replace(/\\'/ig, '\'').replace(/\\"/ig, "\""));
- response.end('saveContentSuccess');
- } else {
- response.end('saveContentFail');
- }
- });
- }
- us.copyPageContent = function (response, fileid, nowpageid, nowpagecontent, copypageid) {
- if (!us.nav[fileid]) {
- us.nav[fileid] = {
- user: {},
- navInfo: "",
- page: {},
- history: []
- };
- }
- var _navdata = us.nav[fileid];
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Office',
- 'CopyPageContent',
- nowpageid,
- nowpagecontent,
- copypageid
- ], function (ret) {
- if (ret) {
- nowpagecontent == "" && (nowpagecontent = JSON.parse(ret)[0][0].content);
- _navdata.page[nowpageid] = us.cheerio.load(nowpagecontent.replace(/\\'/ig, '\'').replace(/\\"/ig, "\""));
- response.end('saveContentSuccess');
- } else {
- response.end('saveContentFail');
- }
- });
- }
- us.addWord = function (response, wordinfo) {
-
- wordinfo = JSON.parse(wordinfo);
- var _docidarray = wordinfo.docId.split(','),
- _userid = wordinfo.userId,
- _pageid = wordinfo.pageId,
- i,
- _docid,
- _docinfo;
- for (i = 0; i < _docidarray.length; i++) {
- _docid = _docidarray[i];
- _docinfo = us.word[_docid];
- if (!_docinfo) {
- us.word[_docid] = {
- user: {},
- history: []
- };
- us.word[_docid].user[_userid] = [_pageid];
- } else if (!_docinfo.user[_userid]) {
- _docinfo.user[_userid] = [_pageid];
- } else if (_docinfo.user[_userid].indexOf(_pageid) == -1) {
- _docinfo.user[_userid].push(_pageid);
- }
- us.offLineMessage[_pageid].word.push(_docid);
- }
- response.end('addword');
- }
- us.addExcel = function (response, excelinfo) {
-
-
- excelinfo = JSON.parse(excelinfo);
- var _excelinfo = us.excel[excelinfo.docId],
- _userid = excelinfo.userId,
- _pageid = excelinfo.pageId,
- _docid = excelinfo.docId;
- if (!_excelinfo) {
- us.excel[_docid] = {
- user: {},
- history: []
- };
- us.excel[_docid].user[_userid] = [_pageid];
- } else if (!_excelinfo.user[_userid]) {
- _excelinfo.user[_userid] = [_pageid];
- } else if (_excelinfo.user[_userid].indexOf(_pageid) == -1) {
- _excelinfo.user[_userid].push(_pageid);
- }
- us.offLineMessage[_pageid].excel.push(_docid);
- response.end('OK');
- }
- us.getMindNetwork = function (response, docid, pageid, userid) {
-
- if (us.mindNetwork[docid]) {
-
- if (!us.mindNetwork[docid].user[userid]) {
- us.mindNetwork[docid].user[userid] = [pageid];
- } else {
- us.mindNetwork[docid].user[userid].push(pageid);
- }
- try {
- us.offLineMessage[pageid].mindNetwork.indexOf(docid) == -1 && us.offLineMessage[pageid].mindNetwork.push(docid);
- }
- catch (e) {
- }
- console.log(us.mindNetwork[docid]);
-
- us.mysql.usselect(['172.16.12.5', 'pbl', 'select_room', docid],
- function (ret) {
- if (ret) {
- ret[0][0].data = us.mindNetwork[docid].content;
- response.end(JSON.stringify(ret));
- }
- else {
- response.end('');
- }
- });
- }
- else {
- us.mindNetwork[docid] = {
- user: {},
- history: []
- };
- us.mindNetwork[docid].user[userid] = [pageid];
- if (us.offLineMessage[pageid]) {
- us.offLineMessage[pageid].mindNetwork.indexOf(docid) == -1 && us.offLineMessage[pageid].mindNetwork.push(docid);
- }
-
- us.mysql.usselect(['172.16.12.5', 'pbl', 'select_room', docid],
- function (ret) {
- if (ret) {
- us.mindNetwork[docid].content = JSON.parse(ret[0][0].data);
- response.end(JSON.stringify(ret));
- }
- else {
- us.mindNetwork[docid].content = [];
- response.end('');
- }
- });
- }
- }
- us.getWord = function (response, docid, pageid, userid) {
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- if (us.word[docid]) {
-
- if (!us.word[docid].user[userid]) {
- us.word[docid].user[userid] = [pageid];
- } else {
- us.word[docid].user[userid].push(pageid);
- }
- console.log(us.offLineMessage[pageid]);
- console.log(pageid);
- try {
- us.offLineMessage[pageid].word.indexOf(docid) == -1 && us.offLineMessage[pageid].word.push(docid);
- }
- catch (e) {
- }
-
- us.mysql.usselect(['172.16.12.5', 'pbl', 'select_file', docid],
- function (ret) {
- if (ret) {
- ret[0][0].data = us.word[docid].content('body').html();
- response.end(JSON.stringify(ret));
- } else {
- us.word[docid].content = us.cheerio.load('');
- response.end('');
- }
- });
- }
- else {
- us.word[docid] = {
- user: {},
- history: []
- };
- us.word[docid].user[userid] = [pageid];
- if (us.offLineMessage[pageid]) {
- us.offLineMessage[pageid].word.indexOf(docid) == -1 && us.offLineMessage[pageid].word.push(docid);
- }
-
- us.mysql.usselect(['172.16.12.5', 'pbl', 'select_file', docid],
- function (ret) {
- if (ret) {
- var _office = ret[0][0].data ? ret[0][0].data.replace(/\\'/ig, '\'').replace(/\\"/ig, "\"") : "";
- us.word[docid].content = us.cheerio.load(_office);
- response.end(_office);
- } else {
- us.word[docid].content = us.cheerio.load('');
- response.end('');
- }
- });
- }
- }
- us.getExcel = function (response, docid, pageid, userid) {
-
- if (us.excel[docid]) {
-
- if (!us.excel[docid].user[userid]) {
- us.excel[docid].user[userid] = [pageid];
- } else {
- us.excel[docid].user[userid].push(pageid);
- }
- us.offLineMessage[pageid].excel.indexOf(docid) == -1 && us.offLineMessage[pageid].excel.push(docid);
- var _office = us.excel[docid].content;
- response.end(JSON.stringify(_office));
- } else {
- us.excel[docid] = {
- user: {},
- history: []
- };
- us.excel[docid].user[userid] = [pageid];
- us.offLineMessage[pageid].excel.indexOf(docid) == -1 && us.offLineMessage[pageid].excel.push(docid);
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Disk',
- 'GetFileContent',
- docid
- ], function (ret) {
- if (ret) {
- var _office = JSON.parse(ret)[0][0].UsOffice;
- us.excel[docid].content = JSON.parse(_office);
- response.end(_office);
- } else {
- us.excel[docid].content = '';
- response.end('');
- }
- });
- }
- }
- us.newExcelSave = function (response, docid, content, name, userid, pageid) {
- us.excel[docid] = {
- user: {},
- history: []
- };
- us.excel[docid].user[userid] = [pageid];
- us.offLineMessage[pageid].excel.indexOf(docid) == -1 && us.offLineMessage[pageid].word.push(docid);
-
- us.mysql.usselect([
- 'sqlserver.1473.cn',
- 'UseStudio_Disk',
- 'SaveFileContent',
- docid,
- content,
- name
- ], function (ret) {
- if (ret) {
-
- us.excel[docid].content = JSON.parse(content);
- response.end('saveOk');
- } else {
- response.end('fail');
- }
- });
- }
- us.createGuid = function () {
-
- return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) {
- var r = Math.random() * 16 | 0,
- v = c == 'x' ? r : (r & 0x3 | 0x8);
- return v.toString(16);
- });
- };
- us.server.listen('1473', '', function () {
-
- console.log("开始监听" + us.server.address().port + "......");
- });
|