server/api/dashboardItem/dashboardItem.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0x10dc=['api','../../config/environment','../../mysqldb','defaults','redis','localhost','socket.io-emitter','register','sendStatus','status','end','offset','undefined','limit','count','set','json','apply','save','update','destroy','error','name','show','params','model','keys','DashboardItem','rawAttributes','query','filters','intersection','attributes','fields','length','includeAll','include','merge','options','find','then','catch','type','iframe','attrUrl','attrs','value','https://','custom','attrPath','attrHourFormat','attrTimezone','0.00','attrFontSize','counter','attrMetric','attrVoiceQueues','attrChannel','attrEmailAccounts','attrFaxAccounts','attrSmsAccounts','attrOpenchannelAccounts','attrWhatsappAccounts','attrChatWebsites','pie-chart','attrSerie1','attrSerie2','attrSerie3','web-report','attrReport','attrRefresh','widgetAttributes:\x20%s','stringify','body','create','eml-format','rimraf','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch'];(function(_0x517c2d,_0x4cfb4e){var _0x5ae192=function(_0x3ab341){while(--_0x3ab341){_0x517c2d['push'](_0x517c2d['shift']());}};_0x5ae192(++_0x4cfb4e);}(_0x10dc,0x107));var _0xc10d=function(_0x52e77f,_0x368694){_0x52e77f=_0x52e77f-0x0;var _0x3aad87=_0x10dc[_0x52e77f];return _0x3aad87;};'use strict';var emlformat=require(_0xc10d('0x0'));var rimraf=require(_0xc10d('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xc10d('0x2'));var rp=require('request-promise');var moment=require(_0xc10d('0x3'));var BPromise=require(_0xc10d('0x4'));var Mustache=require(_0xc10d('0x5'));var util=require(_0xc10d('0x6'));var path=require(_0xc10d('0x7'));var sox=require(_0xc10d('0x8'));var csv=require(_0xc10d('0x9'));var ejs=require(_0xc10d('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xc10d('0xb'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xc10d('0xc'));var deskjs=require(_0xc10d('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xc10d('0xe'));var Redis=require(_0xc10d('0xf'));var authService=require(_0xc10d('0x10'));var qs=require(_0xc10d('0x11'));var as=require(_0xc10d('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xc10d('0x13'));var utils=require('../../config/utils');var config=require(_0xc10d('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0xc10d('0x15'))['db'];config['redis']=_[_0xc10d('0x16')](config[_0xc10d('0x17')],{'host':_0xc10d('0x18'),'port':0x18eb});var socket=require(_0xc10d('0x19'))(new Redis(config[_0xc10d('0x17')]));require('./dashboardItem.socket')[_0xc10d('0x1a')](socket);function respondWithStatusCode(_0x517c43,_0x234152){_0x234152=_0x234152||0xcc;return function(_0x2f1bd0){if(_0x2f1bd0){return _0x517c43[_0xc10d('0x1b')](_0x234152);}return _0x517c43[_0xc10d('0x1c')](_0x234152)[_0xc10d('0x1d')]();};}function respondWithResult(_0x163e1c,_0x45de57){_0x45de57=_0x45de57||0xc8;return function(_0x3210a8){if(_0x3210a8){return _0x163e1c['status'](_0x45de57)['json'](_0x3210a8);}};}function respondWithFilteredResult(_0x37dd26,_0x2f1553){return function(_0x3fc6fd){if(_0x3fc6fd){var _0x64bc14=typeof _0x2f1553[_0xc10d('0x1e')]===_0xc10d('0x1f')&&typeof _0x2f1553[_0xc10d('0x20')]===_0xc10d('0x1f');var _0x2688d2=_0x3fc6fd[_0xc10d('0x21')];var _0x28f7b5=_0x64bc14?0x0:_0x2f1553[_0xc10d('0x1e')];var _0x2dccea=_0x64bc14?_0x3fc6fd['count']:_0x2f1553[_0xc10d('0x1e')]+_0x2f1553[_0xc10d('0x20')];var _0x4b70c1;if(_0x2dccea>=_0x2688d2){_0x2dccea=_0x2688d2;_0x4b70c1=0xc8;}else{_0x4b70c1=0xce;}_0x37dd26[_0xc10d('0x1c')](_0x4b70c1);return _0x37dd26[_0xc10d('0x22')]('Content-Range',_0x28f7b5+'-'+_0x2dccea+'/'+_0x2688d2)[_0xc10d('0x23')](_0x3fc6fd);}return null;};}function patchUpdates(_0x4f8b05){return function(_0x4d4ebf){try{jsonpatch[_0xc10d('0x24')](_0x4d4ebf,_0x4f8b05,!![]);}catch(_0x4a7813){return BPromise['reject'](_0x4a7813);}return _0x4d4ebf[_0xc10d('0x25')]();};}function saveUpdates(_0x3c206c,_0x2ded8c){return function(_0x15a518){if(_0x15a518){return _0x15a518[_0xc10d('0x26')](_0x3c206c)['then'](function(_0x572959){return _0x572959;});}return null;};}function removeEntity(_0x3afed7,_0x22b732){return function(_0x21efbb){if(_0x21efbb){return _0x21efbb[_0xc10d('0x27')]()['then'](function(){_0x3afed7[_0xc10d('0x1c')](0xcc)[_0xc10d('0x1d')]();});}};}function handleEntityNotFound(_0x298de1,_0x4fc35d){return function(_0x54e830){if(!_0x54e830){_0x298de1[_0xc10d('0x1b')](0x194);}return _0x54e830;};}function handleError(_0x21ccbb,_0x3e6ecb){_0x3e6ecb=_0x3e6ecb||0x1f4;return function(_0x497b8a){logger[_0xc10d('0x28')](_0x497b8a['stack']);if(_0x497b8a[_0xc10d('0x29')]){delete _0x497b8a['name'];}_0x21ccbb['status'](_0x3e6ecb)['send'](_0x497b8a);};}exports[_0xc10d('0x2a')]=function(_0x3c033f,_0x2af30d){var _0x11db2b={'raw':![],'where':{'id':_0x3c033f[_0xc10d('0x2b')]['id']}},_0x487f08={};_0x487f08[_0xc10d('0x2c')]=_[_0xc10d('0x2d')](db[_0xc10d('0x2e')][_0xc10d('0x2f')]);_0x487f08[_0xc10d('0x30')]=_[_0xc10d('0x2d')](_0x3c033f[_0xc10d('0x30')]);_0x487f08[_0xc10d('0x31')]=_[_0xc10d('0x32')](_0x487f08[_0xc10d('0x2c')],_0x487f08['query']);_0x11db2b[_0xc10d('0x33')]=_[_0xc10d('0x32')](_0x487f08[_0xc10d('0x2c')],qs[_0xc10d('0x34')](_0x3c033f[_0xc10d('0x30')][_0xc10d('0x34')]));_0x11db2b['attributes']=_0x11db2b['attributes'][_0xc10d('0x35')]?_0x11db2b[_0xc10d('0x33')]:_0x487f08[_0xc10d('0x2c')];if(_0x3c033f[_0xc10d('0x30')][_0xc10d('0x36')]){_0x11db2b[_0xc10d('0x37')]=[{'all':!![]}];}_0x11db2b=_[_0xc10d('0x38')]({},_0x11db2b,_0x3c033f[_0xc10d('0x39')]);return db[_0xc10d('0x2e')][_0xc10d('0x3a')](_0x11db2b)[_0xc10d('0x3b')](handleEntityNotFound(_0x2af30d,null))[_0xc10d('0x3b')](respondWithResult(_0x2af30d,null))[_0xc10d('0x3c')](handleError(_0x2af30d,null));};exports[_0xc10d('0x27')]=function(_0x4a6ce5,_0x1f30f7){return db[_0xc10d('0x2e')][_0xc10d('0x3a')]({'where':{'id':_0x4a6ce5['params']['id']}})[_0xc10d('0x3b')](handleEntityNotFound(_0x1f30f7,null))['then'](removeEntity(_0x1f30f7,null))[_0xc10d('0x3c')](handleError(_0x1f30f7,null));};function widgetAttributes(_0x4eec6c){try{switch(_0x4eec6c[_0xc10d('0x3d')]){case _0xc10d('0x3e'):return[{'name':_0xc10d('0x3f'),'value':_0x4eec6c[_0xc10d('0x3f')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x0]?_0x4eec6c[_0xc10d('0x40')][0x0][_0xc10d('0x41')]:undefined)||_0xc10d('0x42')}];case _0xc10d('0x43'):return[{'name':_0xc10d('0x44'),'value':_0x4eec6c[_0xc10d('0x44')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x0]?_0x4eec6c[_0xc10d('0x40')][0x0][_0xc10d('0x41')]:undefined)||''}];case'clock':return[{'name':_0xc10d('0x45'),'value':_0x4eec6c[_0xc10d('0x45')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x0]?_0x4eec6c[_0xc10d('0x40')][0x0][_0xc10d('0x41')]:undefined)||'HH:mm:ss'},{'name':_0xc10d('0x46'),'value':_0x4eec6c['attrTimezone']||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c['attrs'][0x1]?_0x4eec6c[_0xc10d('0x40')][0x1]['value']:undefined)||_0xc10d('0x47')},{'name':_0xc10d('0x48'),'value':_0x4eec6c['attrFontSize']||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c['attrs'][0x2]?_0x4eec6c[_0xc10d('0x40')][0x2]['value']:undefined)||0xc}];case _0xc10d('0x49'):return[{'name':_0xc10d('0x4a'),'value':_0x4eec6c[_0xc10d('0x4a')]||(_0x4eec6c['attrs']&&_0x4eec6c[_0xc10d('0x40')][0x0]?_0x4eec6c[_0xc10d('0x40')][0x0][_0xc10d('0x41')]:undefined)||'total'},{'name':_0xc10d('0x4b'),'value':_0x4eec6c[_0xc10d('0x4b')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x1]?_0x4eec6c['attrs'][0x1][_0xc10d('0x41')]:undefined)||[]},{'name':_0xc10d('0x48'),'value':_0x4eec6c[_0xc10d('0x48')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x2]?_0x4eec6c[_0xc10d('0x40')][0x2]['value']:undefined)||0x14},{'name':_0xc10d('0x4c'),'value':_0x4eec6c['attrChannel']||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x3]?_0x4eec6c[_0xc10d('0x40')][0x3][_0xc10d('0x41')]:undefined)||'voice'},{'name':_0xc10d('0x4d'),'value':_0x4eec6c[_0xc10d('0x4d')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x4]?_0x4eec6c[_0xc10d('0x40')][0x4][_0xc10d('0x41')]:undefined)||''},{'name':'attrFaxAccounts','value':_0x4eec6c[_0xc10d('0x4e')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c['attrs'][0x5]?_0x4eec6c[_0xc10d('0x40')][0x5][_0xc10d('0x41')]:undefined)||''},{'name':_0xc10d('0x4f'),'value':_0x4eec6c[_0xc10d('0x4f')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c['attrs'][0x6]?_0x4eec6c[_0xc10d('0x40')][0x6][_0xc10d('0x41')]:undefined)||''},{'name':_0xc10d('0x50'),'value':_0x4eec6c[_0xc10d('0x50')]||(_0x4eec6c['attrs']&&_0x4eec6c[_0xc10d('0x40')][0x7]?_0x4eec6c['attrs'][0x7][_0xc10d('0x41')]:undefined)||''},{'name':_0xc10d('0x51'),'value':_0x4eec6c[_0xc10d('0x51')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x8]?_0x4eec6c[_0xc10d('0x40')][0x8][_0xc10d('0x41')]:undefined)||''},{'name':_0xc10d('0x52'),'value':_0x4eec6c['attrChatWebsites']||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x9]?_0x4eec6c[_0xc10d('0x40')][0x9][_0xc10d('0x41')]:undefined)||''}];case'multibar-chart':case _0xc10d('0x53'):return[{'name':'attrSerie1','value':_0x4eec6c[_0xc10d('0x54')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c['attrs'][0x0]?_0x4eec6c[_0xc10d('0x40')][0x0][_0xc10d('0x41')]:undefined)||'total'},{'name':'attrSerie2','value':_0x4eec6c[_0xc10d('0x55')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x1]?_0x4eec6c[_0xc10d('0x40')][0x1][_0xc10d('0x41')]:undefined)||null},{'name':_0xc10d('0x56'),'value':_0x4eec6c['attrSerie3']||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x2]?_0x4eec6c[_0xc10d('0x40')][0x2][_0xc10d('0x41')]:undefined)||null},{'name':'attrVoiceQueues','value':_0x4eec6c[_0xc10d('0x4b')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x3]?_0x4eec6c[_0xc10d('0x40')][0x3][_0xc10d('0x41')]:undefined)||[]},{'name':_0xc10d('0x4c'),'value':_0x4eec6c[_0xc10d('0x4c')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x4]?_0x4eec6c[_0xc10d('0x40')][0x4][_0xc10d('0x41')]:undefined)||'voice'},{'name':_0xc10d('0x4d'),'value':_0x4eec6c[_0xc10d('0x4d')]||(_0x4eec6c['attrs']&&_0x4eec6c[_0xc10d('0x40')][0x5]?_0x4eec6c['attrs'][0x5][_0xc10d('0x41')]:undefined)||''},{'name':'attrFaxAccounts','value':_0x4eec6c[_0xc10d('0x4e')]||(_0x4eec6c['attrs']&&_0x4eec6c[_0xc10d('0x40')][0x6]?_0x4eec6c['attrs'][0x6][_0xc10d('0x41')]:undefined)||''},{'name':_0xc10d('0x4f'),'value':_0x4eec6c[_0xc10d('0x4f')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x7]?_0x4eec6c[_0xc10d('0x40')][0x7]['value']:undefined)||''},{'name':_0xc10d('0x50'),'value':_0x4eec6c[_0xc10d('0x50')]||(_0x4eec6c['attrs']&&_0x4eec6c[_0xc10d('0x40')][0x8]?_0x4eec6c[_0xc10d('0x40')][0x8][_0xc10d('0x41')]:undefined)||''},{'name':_0xc10d('0x51'),'value':_0x4eec6c[_0xc10d('0x51')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x9]?_0x4eec6c[_0xc10d('0x40')][0x9][_0xc10d('0x41')]:undefined)||''},{'name':_0xc10d('0x52'),'value':_0x4eec6c[_0xc10d('0x52')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0xa]?_0x4eec6c['attrs'][0xa][_0xc10d('0x41')]:undefined)||''}];case _0xc10d('0x57'):return[{'name':_0xc10d('0x58'),'type':_0x4eec6c['reportType']||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x0]?_0x4eec6c[_0xc10d('0x40')][0x0][_0xc10d('0x3d')]:undefined)||null,'value':_0x4eec6c[_0xc10d('0x58')]||(_0x4eec6c['attrs']&&_0x4eec6c[_0xc10d('0x40')][0x0]?_0x4eec6c['attrs'][0x0]['value']:undefined)||null},{'name':_0xc10d('0x59'),'value':_0x4eec6c[_0xc10d('0x59')]||(_0x4eec6c[_0xc10d('0x40')]&&_0x4eec6c[_0xc10d('0x40')][0x1]?_0x4eec6c['attrs'][0x1][_0xc10d('0x41')]:undefined)||0x0}];default:return[];}}catch(_0x5f4ee2){logger[_0xc10d('0x28')](_0xc10d('0x5a'),JSON[_0xc10d('0x5b')](_0x5f4ee2));return[];}}exports['create']=function(_0xc205e3,_0x24bd3a){if(_0xc205e3[_0xc10d('0x5c')]){_0xc205e3[_0xc10d('0x5c')][_0xc10d('0x40')]=widgetAttributes(_0xc205e3[_0xc10d('0x5c')]);}return db['DashboardItem'][_0xc10d('0x5d')](_0xc205e3[_0xc10d('0x5c')],{})[_0xc10d('0x3b')](respondWithResult(_0x24bd3a,0xc9))[_0xc10d('0x3c')](handleError(_0x24bd3a,null));};exports['update']=function(_0x18d262,_0x7dfffe){if(_0x18d262[_0xc10d('0x5c')]['id']){delete _0x18d262[_0xc10d('0x5c')]['id'];}_0x18d262['body'][_0xc10d('0x40')]=widgetAttributes(_0x18d262['body']);return db[_0xc10d('0x2e')][_0xc10d('0x3a')]({'where':{'id':_0x18d262[_0xc10d('0x2b')]['id']}})['then'](handleEntityNotFound(_0x7dfffe,null))[_0xc10d('0x3b')](saveUpdates(_0x18d262[_0xc10d('0x5c')],null))[_0xc10d('0x3b')](respondWithResult(_0x7dfffe,null))[_0xc10d('0x3c')](handleError(_0x7dfffe,null));};