server/api/dashboard/dashboard.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 _0xd782=['api','../../config/environment','../../config/license/util','redis','defaults','localhost','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','destroy','get','UserProfileResource','error','stack','name','send','index','map','Dashboard','rawAttributes','fieldName','type','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','includeAll','include','findAll','rows','catch','show','params','options','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','CustomDashboards','userProfileId','autoAssociation','clone','omit','createdAt','updatedAt','UserProfileSection','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','iframe','attrs','value','custom','attrPath','attrHourFormat','HH:mm:ss','attrTimezone','0.00','attrFontSize','counter','attrMetric','total','attrVoiceQueues','attrChannel','voice','attrEmailAccounts','attrFaxAccounts','attrSmsAccounts','attrOpenchannelAccounts','attrWhatsappAccounts','attrChatWebsites','multibar-chart','pie-chart','attrSerie1','attrSerie2','attrSerie3','reportType','attrRefresh','widgetAttributes:\x20%s','stringify','addItem','DashboardId','DashboardItem','findOne','getItems','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch'];(function(_0x19e35c,_0x29cd1e){var _0x3e1fe8=function(_0x17258b){while(--_0x17258b){_0x19e35c['push'](_0x19e35c['shift']());}};_0x3e1fe8(++_0x29cd1e);}(_0xd782,0x171));var _0x2d78=function(_0x157fdf,_0xbd5ade){_0x157fdf=_0x157fdf-0x0;var _0x152177=_0xd782[_0x157fdf];return _0x152177;};'use strict';var emlformat=require(_0x2d78('0x0'));var rimraf=require(_0x2d78('0x1'));var zipdir=require(_0x2d78('0x2'));var jsonpatch=require(_0x2d78('0x3'));var rp=require(_0x2d78('0x4'));var moment=require(_0x2d78('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x2d78('0x6'));var util=require(_0x2d78('0x7'));var path=require(_0x2d78('0x8'));var sox=require(_0x2d78('0x9'));var csv=require(_0x2d78('0xa'));var ejs=require(_0x2d78('0xb'));var fs=require('fs');var fs_extra=require(_0x2d78('0xc'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x2d78('0xd'));var deskjs=require(_0x2d78('0xe'));var toCsv=require('to-csv');var querystring=require(_0x2d78('0xf'));var Papa=require(_0x2d78('0x10'));var Redis=require(_0x2d78('0x11'));var authService=require(_0x2d78('0x12'));var qs=require(_0x2d78('0x13'));var as=require(_0x2d78('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x2d78('0x15'));var utils=require('../../config/utils');var config=require(_0x2d78('0x16'));var licenseUtil=require(_0x2d78('0x17'));var db=require('../../mysqldb')['db'];config[_0x2d78('0x18')]=_[_0x2d78('0x19')](config[_0x2d78('0x18')],{'host':_0x2d78('0x1a'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require('./dashboard.socket')['register'](socket);function respondWithStatusCode(_0x1e679d,_0x36101f){_0x36101f=_0x36101f||0xcc;return function(_0x1c840a){if(_0x1c840a){return _0x1e679d[_0x2d78('0x1b')](_0x36101f);}return _0x1e679d[_0x2d78('0x1c')](_0x36101f)[_0x2d78('0x1d')]();};}function respondWithResult(_0x50d35a,_0x5bf71e){_0x5bf71e=_0x5bf71e||0xc8;return function(_0x32bc47){if(_0x32bc47){return _0x50d35a[_0x2d78('0x1c')](_0x5bf71e)[_0x2d78('0x1e')](_0x32bc47);}};}function respondWithFilteredResult(_0x589521,_0x3bccf2){return function(_0x5df979){if(_0x5df979){var _0x5cd7a3=typeof _0x3bccf2[_0x2d78('0x1f')]===_0x2d78('0x20')&&typeof _0x3bccf2[_0x2d78('0x21')]===_0x2d78('0x20');var _0x537ade=_0x5df979['count'];var _0x48b60c=_0x5cd7a3?0x0:_0x3bccf2[_0x2d78('0x1f')];var _0x27b0a2=_0x5cd7a3?_0x5df979[_0x2d78('0x22')]:_0x3bccf2['offset']+_0x3bccf2[_0x2d78('0x21')];var _0x2dbb34;if(_0x27b0a2>=_0x537ade){_0x27b0a2=_0x537ade;_0x2dbb34=0xc8;}else{_0x2dbb34=0xce;}_0x589521[_0x2d78('0x1c')](_0x2dbb34);return _0x589521[_0x2d78('0x23')](_0x2d78('0x24'),_0x48b60c+'-'+_0x27b0a2+'/'+_0x537ade)[_0x2d78('0x1e')](_0x5df979);}return null;};}function patchUpdates(_0x793f7b){return function(_0x54a66c){try{jsonpatch[_0x2d78('0x25')](_0x54a66c,_0x793f7b,!![]);}catch(_0x228840){return BPromise[_0x2d78('0x26')](_0x228840);}return _0x54a66c['save']();};}function saveUpdates(_0x5b5bda,_0x270d48){return function(_0x731157){if(_0x731157){return _0x731157[_0x2d78('0x27')](_0x5b5bda)[_0x2d78('0x28')](function(_0x350ba1){return _0x350ba1;});}return null;};}function removeEntity(_0x594a66,_0x27f9dc){return function(_0x12d50a){if(_0x12d50a){return _0x12d50a[_0x2d78('0x29')]()[_0x2d78('0x28')](function(){var _0x557864=_0x12d50a[_0x2d78('0x2a')]({'plain':!![]});var _0x2becfe='CustomDashboards';return db[_0x2d78('0x2b')][_0x2d78('0x29')]({'where':{'type':_0x2becfe,'resourceId':_0x557864['id']}})[_0x2d78('0x28')](function(){return _0x12d50a;});})[_0x2d78('0x28')](function(){_0x594a66[_0x2d78('0x1c')](0xcc)[_0x2d78('0x1d')]();});}};}function handleEntityNotFound(_0xb377a0,_0x691774){return function(_0x4ee262){if(!_0x4ee262){_0xb377a0[_0x2d78('0x1b')](0x194);}return _0x4ee262;};}function handleError(_0x110c46,_0x47cea5){_0x47cea5=_0x47cea5||0x1f4;return function(_0x29315b){logger[_0x2d78('0x2c')](_0x29315b[_0x2d78('0x2d')]);if(_0x29315b[_0x2d78('0x2e')]){delete _0x29315b[_0x2d78('0x2e')];}_0x110c46[_0x2d78('0x1c')](_0x47cea5)[_0x2d78('0x2f')](_0x29315b);};}exports[_0x2d78('0x30')]=function(_0x2b9ac4,_0x220fec){var _0x3241cd={},_0x3faf60={},_0x1696b3={'count':0x0,'rows':[]};var _0x363cef=_[_0x2d78('0x31')](db[_0x2d78('0x32')][_0x2d78('0x33')],function(_0x28cfda){return{'name':_0x28cfda[_0x2d78('0x34')],'type':_0x28cfda[_0x2d78('0x35')]['key']};});_0x3faf60[_0x2d78('0x36')]=_['map'](_0x363cef,_0x2d78('0x2e'));_0x3faf60['query']=_[_0x2d78('0x37')](_0x2b9ac4[_0x2d78('0x38')]);_0x3faf60[_0x2d78('0x39')]=_[_0x2d78('0x3a')](_0x3faf60[_0x2d78('0x36')],_0x3faf60[_0x2d78('0x38')]);_0x3241cd[_0x2d78('0x3b')]=_[_0x2d78('0x3a')](_0x3faf60['model'],qs[_0x2d78('0x3c')](_0x2b9ac4['query'][_0x2d78('0x3c')]));_0x3241cd[_0x2d78('0x3b')]=_0x3241cd[_0x2d78('0x3b')][_0x2d78('0x3d')]?_0x3241cd[_0x2d78('0x3b')]:_0x3faf60['model'];if(!_0x2b9ac4[_0x2d78('0x38')][_0x2d78('0x3e')](_0x2d78('0x3f'))){_0x3241cd[_0x2d78('0x21')]=qs[_0x2d78('0x21')](_0x2b9ac4[_0x2d78('0x38')][_0x2d78('0x21')]);_0x3241cd[_0x2d78('0x1f')]=qs[_0x2d78('0x1f')](_0x2b9ac4[_0x2d78('0x38')][_0x2d78('0x1f')]);}_0x3241cd[_0x2d78('0x40')]=qs[_0x2d78('0x41')](_0x2b9ac4[_0x2d78('0x38')]['sort']);_0x3241cd['where']=qs[_0x2d78('0x39')](_[_0x2d78('0x42')](_0x2b9ac4[_0x2d78('0x38')],_0x3faf60[_0x2d78('0x39')]),_0x363cef);if(_0x2b9ac4[_0x2d78('0x38')][_0x2d78('0x43')]){_0x3241cd[_0x2d78('0x44')]=_[_0x2d78('0x45')](_0x3241cd[_0x2d78('0x44')],{'$or':_[_0x2d78('0x31')](_0x363cef,function(_0x5d7b5c){if(_0x5d7b5c[_0x2d78('0x35')]!==_0x2d78('0x46')){var _0x3d275a={};_0x3d275a[_0x5d7b5c[_0x2d78('0x2e')]]={'$like':'%'+_0x2b9ac4[_0x2d78('0x38')][_0x2d78('0x43')]+'%'};return _0x3d275a;}})});}_0x3241cd=_['merge']({},_0x3241cd,_0x2b9ac4['options']);var _0xbb1a3c={'where':_0x3241cd[_0x2d78('0x44')]};return db[_0x2d78('0x32')]['count'](_0xbb1a3c)[_0x2d78('0x28')](function(_0x3dd8ed){_0x1696b3[_0x2d78('0x22')]=_0x3dd8ed;if(_0x2b9ac4[_0x2d78('0x38')][_0x2d78('0x47')]){_0x3241cd[_0x2d78('0x48')]=[{'all':!![]}];}return db[_0x2d78('0x32')][_0x2d78('0x49')](_0x3241cd);})[_0x2d78('0x28')](function(_0x5817e5){_0x1696b3[_0x2d78('0x4a')]=_0x5817e5;return _0x1696b3;})[_0x2d78('0x28')](respondWithFilteredResult(_0x220fec,_0x3241cd))[_0x2d78('0x4b')](handleError(_0x220fec,null));};exports[_0x2d78('0x4c')]=function(_0x9f4232,_0x9e6ea4){var _0x5c2f1d={'raw':![],'where':{'id':_0x9f4232[_0x2d78('0x4d')]['id']}},_0x3db984={};_0x3db984['model']=_['keys'](db[_0x2d78('0x32')]['rawAttributes']);_0x3db984[_0x2d78('0x38')]=_['keys'](_0x9f4232[_0x2d78('0x38')]);_0x3db984[_0x2d78('0x39')]=_[_0x2d78('0x3a')](_0x3db984[_0x2d78('0x36')],_0x3db984['query']);_0x5c2f1d[_0x2d78('0x3b')]=_[_0x2d78('0x3a')](_0x3db984[_0x2d78('0x36')],qs[_0x2d78('0x3c')](_0x9f4232[_0x2d78('0x38')][_0x2d78('0x3c')]));_0x5c2f1d[_0x2d78('0x3b')]=_0x5c2f1d['attributes'][_0x2d78('0x3d')]?_0x5c2f1d[_0x2d78('0x3b')]:_0x3db984[_0x2d78('0x36')];if(_0x9f4232['query'][_0x2d78('0x47')]){_0x5c2f1d[_0x2d78('0x48')]=[{'all':!![]}];}_0x5c2f1d=_[_0x2d78('0x45')]({},_0x5c2f1d,_0x9f4232[_0x2d78('0x4e')]);return db[_0x2d78('0x32')][_0x2d78('0x4f')](_0x5c2f1d)[_0x2d78('0x28')](handleEntityNotFound(_0x9e6ea4,null))[_0x2d78('0x28')](respondWithResult(_0x9e6ea4,null))[_0x2d78('0x4b')](handleError(_0x9e6ea4,null));};exports[_0x2d78('0x50')]=function(_0x1e9c3f,_0x2c6e81){return db['Dashboard']['create'](_0x1e9c3f[_0x2d78('0x51')],{})[_0x2d78('0x28')](function(_0x447ab8){var _0x410ff3=_0x1e9c3f[_0x2d78('0x52')][_0x2d78('0x2a')]({'plain':!![]});if(!_0x410ff3)throw new Error(_0x2d78('0x53'));if(_0x410ff3[_0x2d78('0x54')]===_0x2d78('0x52')){var _0x29f362=_0x447ab8['get']({'plain':!![]});var _0x5aa317=_0x2d78('0x55');return db['UserProfileSection']['find']({'where':{'name':_0x5aa317,'userProfileId':_0x410ff3[_0x2d78('0x56')]},'raw':!![]})['then'](function(_0x4a650e){if(_0x4a650e&&_0x4a650e[_0x2d78('0x57')]===0x0){return db[_0x2d78('0x2b')][_0x2d78('0x50')]({'name':_0x29f362['name'],'resourceId':_0x29f362['id'],'type':_0x4a650e[_0x2d78('0x2e')],'sectionId':_0x4a650e['id']},{})[_0x2d78('0x28')](function(){return _0x447ab8;});}else{return _0x447ab8;}})['catch'](function(_0x7c7fb){logger[_0x2d78('0x2c')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x7c7fb);throw _0x7c7fb;});}return _0x447ab8;})[_0x2d78('0x28')](respondWithResult(_0x2c6e81,0xc9))[_0x2d78('0x4b')](handleError(_0x2c6e81,null));};exports[_0x2d78('0x58')]=function(_0x42f937,_0x4ce0b3){var _0x40afa6={'where':{'id':_0x42f937[_0x2d78('0x4d')]['id']}},_0x453b8f={};_0x453b8f['model']=_[_0x2d78('0x37')](db[_0x2d78('0x32')][_0x2d78('0x33')]);_0x40afa6['attributes']=_[_0x2d78('0x3a')](_0x453b8f['model'],qs[_0x2d78('0x3c')](_0x42f937[_0x2d78('0x38')][_0x2d78('0x3c')]));_0x40afa6[_0x2d78('0x3b')]=_0x40afa6[_0x2d78('0x3b')][_0x2d78('0x3d')]?_0x40afa6[_0x2d78('0x3b')]:_0x453b8f['model'];if(_0x42f937[_0x2d78('0x38')]['includeAll']){_0x40afa6[_0x2d78('0x48')]=[{'all':!![]}];}_0x40afa6=_[_0x2d78('0x45')]({},_0x40afa6,_0x42f937[_0x2d78('0x4e')]);return db[_0x2d78('0x32')]['find'](_0x40afa6)[_0x2d78('0x28')](handleEntityNotFound(_0x4ce0b3,null))[_0x2d78('0x28')](function(_0x3143fc){if(_0x3143fc){var _0xc97057=_0x3143fc[_0x2d78('0x2a')]({'plain':!![]});_0xc97057=qs[_0x2d78('0x59')](_0xc97057,['id',_0x2d78('0x5a'),_0x2d78('0x5b')]);_0x42f937[_0x2d78('0x51')]=_[_0x2d78('0x59')](_0x42f937[_0x2d78('0x51')],['id',_0x2d78('0x5a'),_0x2d78('0x5b')]);return db[_0x2d78('0x32')][_0x2d78('0x50')](_['merge'](_0xc97057,_0x42f937[_0x2d78('0x51')]),{'include':_0x42f937[_0x2d78('0x38')][_0x2d78('0x47')]?[{'all':!![]}]:undefined})[_0x2d78('0x28')](function(_0x589f41){var _0x25de47=_0x42f937[_0x2d78('0x52')][_0x2d78('0x2a')]({'plain':!![]});if(!_0x25de47)throw new Error(_0x2d78('0x53'));if(_0x25de47[_0x2d78('0x54')]===_0x2d78('0x52')){var _0x3cd297=_0x589f41[_0x2d78('0x2a')]({'plain':!![]});var _0x31768f=_0x2d78('0x55');return db[_0x2d78('0x5c')][_0x2d78('0x4f')]({'where':{'name':_0x31768f,'userProfileId':_0x25de47[_0x2d78('0x56')]},'raw':!![]})[_0x2d78('0x28')](function(_0x445a95){if(_0x445a95&&_0x445a95[_0x2d78('0x57')]===0x0){return db['UserProfileResource'][_0x2d78('0x50')]({'name':_0x3cd297[_0x2d78('0x2e')],'resourceId':_0x3cd297['id'],'type':_0x445a95[_0x2d78('0x2e')],'sectionId':_0x445a95['id']},{})['then'](function(){return _0x589f41;});}else{return _0x589f41;}})[_0x2d78('0x4b')](function(_0x3c43ca){logger[_0x2d78('0x2c')](_0x2d78('0x5d'),_0x3c43ca);throw _0x3c43ca;});}return _0x589f41;});}})[_0x2d78('0x28')](respondWithResult(_0x4ce0b3,0xc9))[_0x2d78('0x4b')](handleError(_0x4ce0b3,null));};exports[_0x2d78('0x27')]=function(_0x413dda,_0x127e40){if(_0x413dda[_0x2d78('0x51')]['id']){delete _0x413dda['body']['id'];}return db[_0x2d78('0x32')][_0x2d78('0x4f')]({'where':{'id':_0x413dda[_0x2d78('0x4d')]['id']}})[_0x2d78('0x28')](handleEntityNotFound(_0x127e40,null))['then'](saveUpdates(_0x413dda[_0x2d78('0x51')],null))[_0x2d78('0x28')](respondWithResult(_0x127e40,null))[_0x2d78('0x4b')](handleError(_0x127e40,null));};exports['destroy']=function(_0x2b7d87,_0x31d4b6){return db['Dashboard'][_0x2d78('0x4f')]({'where':{'id':_0x2b7d87[_0x2d78('0x4d')]['id']}})[_0x2d78('0x28')](handleEntityNotFound(_0x31d4b6,null))[_0x2d78('0x28')](removeEntity(_0x31d4b6,null))[_0x2d78('0x4b')](handleError(_0x31d4b6,null));};function widgetAttributes(_0x2ba0d2){try{switch(_0x2ba0d2[_0x2d78('0x35')]){case _0x2d78('0x5e'):return[{'name':'attrUrl','value':_0x2ba0d2['attrUrl']||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x0]?_0x2ba0d2[_0x2d78('0x5f')][0x0][_0x2d78('0x60')]:undefined)||'https://'}];case _0x2d78('0x61'):return[{'name':_0x2d78('0x62'),'value':_0x2ba0d2[_0x2d78('0x62')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x0]?_0x2ba0d2['attrs'][0x0]['value']:undefined)||''}];case'clock':return[{'name':_0x2d78('0x63'),'value':_0x2ba0d2[_0x2d78('0x63')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2['attrs'][0x0]?_0x2ba0d2[_0x2d78('0x5f')][0x0]['value']:undefined)||_0x2d78('0x64')},{'name':_0x2d78('0x65'),'value':_0x2ba0d2[_0x2d78('0x65')]||(_0x2ba0d2['attrs']&&_0x2ba0d2[_0x2d78('0x5f')][0x1]?_0x2ba0d2[_0x2d78('0x5f')][0x1]['value']:undefined)||_0x2d78('0x66')},{'name':_0x2d78('0x67'),'value':_0x2ba0d2[_0x2d78('0x67')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x2]?_0x2ba0d2[_0x2d78('0x5f')][0x2][_0x2d78('0x60')]:undefined)||0xc}];case _0x2d78('0x68'):return[{'name':_0x2d78('0x69'),'value':_0x2ba0d2[_0x2d78('0x69')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x0]?_0x2ba0d2[_0x2d78('0x5f')][0x0][_0x2d78('0x60')]:undefined)||_0x2d78('0x6a')},{'name':_0x2d78('0x6b'),'value':_0x2ba0d2['attrVoiceQueues']||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x1]?_0x2ba0d2[_0x2d78('0x5f')][0x1][_0x2d78('0x60')]:undefined)||[]},{'name':_0x2d78('0x67'),'value':_0x2ba0d2['attrFontSize']||(_0x2ba0d2['attrs']&&_0x2ba0d2[_0x2d78('0x5f')][0x2]?_0x2ba0d2['attrs'][0x2][_0x2d78('0x60')]:undefined)||0x14},{'name':'attrChannel','value':_0x2ba0d2[_0x2d78('0x6c')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x3]?_0x2ba0d2[_0x2d78('0x5f')][0x3][_0x2d78('0x60')]:undefined)||_0x2d78('0x6d')},{'name':_0x2d78('0x6e'),'value':_0x2ba0d2['attrEmailAccounts']||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2['attrs'][0x4]?_0x2ba0d2['attrs'][0x4][_0x2d78('0x60')]:undefined)||''},{'name':_0x2d78('0x6f'),'value':_0x2ba0d2[_0x2d78('0x6f')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x5]?_0x2ba0d2[_0x2d78('0x5f')][0x5][_0x2d78('0x60')]:undefined)||''},{'name':_0x2d78('0x70'),'value':_0x2ba0d2[_0x2d78('0x70')]||(_0x2ba0d2['attrs']&&_0x2ba0d2[_0x2d78('0x5f')][0x6]?_0x2ba0d2[_0x2d78('0x5f')][0x6][_0x2d78('0x60')]:undefined)||''},{'name':'attrOpenchannelAccounts','value':_0x2ba0d2[_0x2d78('0x71')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x7]?_0x2ba0d2['attrs'][0x7][_0x2d78('0x60')]:undefined)||''},{'name':_0x2d78('0x72'),'value':_0x2ba0d2[_0x2d78('0x72')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x8]?_0x2ba0d2['attrs'][0x8][_0x2d78('0x60')]:undefined)||''},{'name':'attrChatWebsites','value':_0x2ba0d2[_0x2d78('0x73')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2['attrs'][0x9]?_0x2ba0d2[_0x2d78('0x5f')][0x9][_0x2d78('0x60')]:undefined)||''}];case _0x2d78('0x74'):case _0x2d78('0x75'):return[{'name':'attrSerie1','value':_0x2ba0d2[_0x2d78('0x76')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x0]?_0x2ba0d2[_0x2d78('0x5f')][0x0][_0x2d78('0x60')]:undefined)||_0x2d78('0x6a')},{'name':_0x2d78('0x77'),'value':_0x2ba0d2[_0x2d78('0x77')]||(_0x2ba0d2['attrs']&&_0x2ba0d2[_0x2d78('0x5f')][0x1]?_0x2ba0d2[_0x2d78('0x5f')][0x1]['value']:undefined)||null},{'name':'attrSerie3','value':_0x2ba0d2[_0x2d78('0x78')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x2]?_0x2ba0d2[_0x2d78('0x5f')][0x2][_0x2d78('0x60')]:undefined)||null},{'name':_0x2d78('0x6b'),'value':_0x2ba0d2[_0x2d78('0x6b')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x3]?_0x2ba0d2[_0x2d78('0x5f')][0x3]['value']:undefined)||[]},{'name':'attrChannel','value':_0x2ba0d2[_0x2d78('0x6c')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x4]?_0x2ba0d2['attrs'][0x4][_0x2d78('0x60')]:undefined)||'voice'},{'name':'attrEmailAccounts','value':_0x2ba0d2['attrEmailAccounts']||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2['attrs'][0x5]?_0x2ba0d2['attrs'][0x5]['value']:undefined)||''},{'name':'attrFaxAccounts','value':_0x2ba0d2[_0x2d78('0x6f')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x6]?_0x2ba0d2[_0x2d78('0x5f')][0x6][_0x2d78('0x60')]:undefined)||''},{'name':_0x2d78('0x70'),'value':_0x2ba0d2[_0x2d78('0x70')]||(_0x2ba0d2['attrs']&&_0x2ba0d2[_0x2d78('0x5f')][0x7]?_0x2ba0d2[_0x2d78('0x5f')][0x7][_0x2d78('0x60')]:undefined)||''},{'name':_0x2d78('0x71'),'value':_0x2ba0d2[_0x2d78('0x71')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x8]?_0x2ba0d2['attrs'][0x8][_0x2d78('0x60')]:undefined)||''},{'name':_0x2d78('0x72'),'value':_0x2ba0d2[_0x2d78('0x72')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2['attrs'][0x9]?_0x2ba0d2['attrs'][0x9][_0x2d78('0x60')]:undefined)||''},{'name':_0x2d78('0x73'),'value':_0x2ba0d2[_0x2d78('0x73')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2['attrs'][0xa]?_0x2ba0d2['attrs'][0xa][_0x2d78('0x60')]:undefined)||''}];case'web-report':return[{'name':'attrReport','type':_0x2ba0d2[_0x2d78('0x79')]||(_0x2ba0d2['attrs']&&_0x2ba0d2[_0x2d78('0x5f')][0x0]?_0x2ba0d2['attrs'][0x0][_0x2d78('0x35')]:undefined)||null,'value':_0x2ba0d2['attrReport']||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x0]?_0x2ba0d2[_0x2d78('0x5f')][0x0][_0x2d78('0x60')]:undefined)||null},{'name':_0x2d78('0x7a'),'value':_0x2ba0d2[_0x2d78('0x7a')]||(_0x2ba0d2[_0x2d78('0x5f')]&&_0x2ba0d2[_0x2d78('0x5f')][0x1]?_0x2ba0d2['attrs'][0x1]['value']:undefined)||0x0}];default:return[];}}catch(_0x4dde90){logger['error'](_0x2d78('0x7b'),JSON[_0x2d78('0x7c')](_0x4dde90));return[];}}exports[_0x2d78('0x7d')]=function(_0x221692,_0x2eb0ea,_0x32162a){if(_0x221692['body']['id']){delete _0x221692['body']['id'];}return db[_0x2d78('0x32')][_0x2d78('0x4f')]({'where':{'id':_0x221692[_0x2d78('0x4d')]['id']}})['then'](handleEntityNotFound(_0x2eb0ea,null))[_0x2d78('0x28')](function(_0x4b833c){if(_0x4b833c){_0x221692[_0x2d78('0x51')][_0x2d78('0x7e')]=_0x4b833c['id'];_0x221692[_0x2d78('0x51')][_0x2d78('0x5f')]=widgetAttributes(_0x221692[_0x2d78('0x51')]);return db[_0x2d78('0x7f')]['create'](_0x221692[_0x2d78('0x51')]);}})['then'](respondWithResult(_0x2eb0ea,null))[_0x2d78('0x4b')](handleError(_0x2eb0ea,null));};exports['getItems']=function(_0x109847,_0x2bca73,_0xa27f15){var _0x469335={};var _0x2c6459={};var _0x13e7cb;var _0x5bf4d2;return db[_0x2d78('0x32')][_0x2d78('0x80')]({'where':{'id':_0x109847[_0x2d78('0x4d')]['id']}})[_0x2d78('0x28')](handleEntityNotFound(_0x2bca73,null))[_0x2d78('0x28')](function(_0x386067){if(_0x386067){_0x13e7cb=_0x386067;_0x2c6459['model']=_[_0x2d78('0x37')](db[_0x2d78('0x7f')][_0x2d78('0x33')]);_0x2c6459[_0x2d78('0x38')]=_[_0x2d78('0x37')](_0x109847[_0x2d78('0x38')]);_0x2c6459[_0x2d78('0x39')]=_[_0x2d78('0x3a')](_0x2c6459[_0x2d78('0x36')],_0x2c6459['query']);_0x469335['attributes']=_[_0x2d78('0x3a')](_0x2c6459[_0x2d78('0x36')],qs['fields'](_0x109847[_0x2d78('0x38')][_0x2d78('0x3c')]));_0x469335['attributes']=_0x469335[_0x2d78('0x3b')][_0x2d78('0x3d')]?_0x469335[_0x2d78('0x3b')]:_0x2c6459[_0x2d78('0x36')];_0x469335[_0x2d78('0x40')]=qs[_0x2d78('0x41')](_0x109847[_0x2d78('0x38')][_0x2d78('0x41')]);_0x469335[_0x2d78('0x44')]=qs['filters'](_[_0x2d78('0x42')](_0x109847[_0x2d78('0x38')],_0x2c6459[_0x2d78('0x39')]));if(_0x109847[_0x2d78('0x38')][_0x2d78('0x43')]){_0x469335[_0x2d78('0x44')]=_[_0x2d78('0x45')](_0x469335['where'],{'$or':_[_0x2d78('0x31')](_0x469335['attributes'],function(_0x3c6b06){var _0x522fa2={};_0x522fa2[_0x3c6b06]={'$like':'%'+_0x109847['query'][_0x2d78('0x43')]+'%'};return _0x522fa2;})});}_0x469335=_[_0x2d78('0x45')]({},_0x469335,_0x109847['options']);return _0x13e7cb[_0x2d78('0x81')](_0x469335);}})['then'](function(_0xc6c1e2){if(_0xc6c1e2){_0x5bf4d2=_0xc6c1e2['length'];if(!_0x109847[_0x2d78('0x38')][_0x2d78('0x3e')](_0x2d78('0x3f'))){_0x469335['limit']=qs[_0x2d78('0x21')](_0x109847[_0x2d78('0x38')][_0x2d78('0x21')]);_0x469335[_0x2d78('0x1f')]=qs[_0x2d78('0x1f')](_0x109847[_0x2d78('0x38')]['offset']);}return _0x13e7cb[_0x2d78('0x81')](_0x469335);}})[_0x2d78('0x28')](function(_0x2fda23){if(_0x2fda23){return _0x2fda23?{'count':_0x5bf4d2,'rows':_0x2fda23}:null;}})[_0x2d78('0x28')](respondWithResult(_0x2bca73,null))[_0x2d78('0x4b')](handleError(_0x2bca73,null));};