02a5719197ff669e1bfe098e11e04318e61dab90
[motion2.git] / 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 _0x3b69=['clone','omit','updatedAt','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','error','params','attrUrl','attrs','value','https://','attrPath','attrHourFormat','HH:mm:ss','attrTimezone','0.00','attrFontSize','counter','attrMetric','total','attrVoiceQueues','attrChannel','voice','attrEmailAccounts','attrFaxAccounts','attrSmsAccounts','attrOpenchannelAccounts','attrWhatsappAccounts','multibar-chart','pie-chart','attrSerie1','attrSerie2','attrSerie3','attrChatWebsites','attrReport','reportType','attrRefresh','widgetAttributes:\x20%s','stringify','addItem','DashboardItem','findOne','getItems','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','path','ejs','fs-extra','lodash','squel','jsforce','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./dashboard.socket','register','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','destroy','then','get','CustomDashboards','UserProfileResource','stack','name','map','Dashboard','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','options','includeAll','findAll','rows','catch','show','include','find','body','user','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s'];(function(_0x26a494,_0x35b08){var _0x26f2b6=function(_0x5ef100){while(--_0x5ef100){_0x26a494['push'](_0x26a494['shift']());}};_0x26f2b6(++_0x35b08);}(_0x3b69,0xaa));var _0x93b6=function(_0x43e38e,_0x563dd8){_0x43e38e=_0x43e38e-0x0;var _0x22c34e=_0x3b69[_0x43e38e];return _0x22c34e;};'use strict';var emlformat=require(_0x93b6('0x0'));var rimraf=require(_0x93b6('0x1'));var zipdir=require(_0x93b6('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x93b6('0x3'));var moment=require(_0x93b6('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x93b6('0x5'));var util=require(_0x93b6('0x6'));var path=require(_0x93b6('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x93b6('0x8'));var fs=require('fs');var fs_extra=require(_0x93b6('0x9'));var _=require(_0x93b6('0xa'));var squel=require(_0x93b6('0xb'));var crypto=require('crypto');var jsforce=require(_0x93b6('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x93b6('0xd'));var querystring=require(_0x93b6('0xe'));var Papa=require(_0x93b6('0xf'));var Redis=require(_0x93b6('0x10'));var authService=require(_0x93b6('0x11'));var qs=require(_0x93b6('0x12'));var as=require(_0x93b6('0x13'));var hardwareService=require(_0x93b6('0x14'));var logger=require('../../config/logger')(_0x93b6('0x15'));var utils=require(_0x93b6('0x16'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x93b6('0x17'))['db'];config[_0x93b6('0x18')]=_[_0x93b6('0x19')](config[_0x93b6('0x18')],{'host':_0x93b6('0x1a'),'port':0x18eb});var socket=require(_0x93b6('0x1b'))(new Redis(config[_0x93b6('0x18')]));require(_0x93b6('0x1c'))[_0x93b6('0x1d')](socket);function respondWithStatusCode(_0x305a25,_0x43545a){_0x43545a=_0x43545a||0xcc;return function(_0x5b7764){if(_0x5b7764){return _0x305a25[_0x93b6('0x1e')](_0x43545a);}return _0x305a25[_0x93b6('0x1f')](_0x43545a)[_0x93b6('0x20')]();};}function respondWithResult(_0x585b42,_0x3e9b40){_0x3e9b40=_0x3e9b40||0xc8;return function(_0xcf198b){if(_0xcf198b){return _0x585b42[_0x93b6('0x1f')](_0x3e9b40)[_0x93b6('0x21')](_0xcf198b);}};}function respondWithFilteredResult(_0x3d900d,_0x5c17a6){return function(_0x9bf628){if(_0x9bf628){var _0x58dd35=typeof _0x5c17a6[_0x93b6('0x22')]===_0x93b6('0x23')&&typeof _0x5c17a6[_0x93b6('0x24')]===_0x93b6('0x23');var _0x9ecf42=_0x9bf628[_0x93b6('0x25')];var _0x37051c=_0x58dd35?0x0:_0x5c17a6[_0x93b6('0x22')];var _0x2590f0=_0x58dd35?_0x9bf628[_0x93b6('0x25')]:_0x5c17a6[_0x93b6('0x22')]+_0x5c17a6[_0x93b6('0x24')];var _0x4dbec2;if(_0x2590f0>=_0x9ecf42){_0x2590f0=_0x9ecf42;_0x4dbec2=0xc8;}else{_0x4dbec2=0xce;}_0x3d900d['status'](_0x4dbec2);return _0x3d900d[_0x93b6('0x26')](_0x93b6('0x27'),_0x37051c+'-'+_0x2590f0+'/'+_0x9ecf42)['json'](_0x9bf628);}return null;};}function patchUpdates(_0xcc1b59){return function(_0x115951){try{jsonpatch[_0x93b6('0x28')](_0x115951,_0xcc1b59,!![]);}catch(_0x1303e0){return BPromise[_0x93b6('0x29')](_0x1303e0);}return _0x115951[_0x93b6('0x2a')]();};}function saveUpdates(_0x20a762,_0x385985){return function(_0x1f2751){if(_0x1f2751){return _0x1f2751['update'](_0x20a762)['then'](function(_0x43e1c9){return _0x43e1c9;});}return null;};}function removeEntity(_0x5e20b8,_0x45d1e0){return function(_0x500f23){if(_0x500f23){return _0x500f23[_0x93b6('0x2b')]()[_0x93b6('0x2c')](function(){var _0x1882a4=_0x500f23[_0x93b6('0x2d')]({'plain':!![]});var _0x29d657=_0x93b6('0x2e');return db[_0x93b6('0x2f')][_0x93b6('0x2b')]({'where':{'type':_0x29d657,'resourceId':_0x1882a4['id']}})[_0x93b6('0x2c')](function(){return _0x500f23;});})[_0x93b6('0x2c')](function(){_0x5e20b8[_0x93b6('0x1f')](0xcc)[_0x93b6('0x20')]();});}};}function handleEntityNotFound(_0x3ebca9,_0x4eb8df){return function(_0x2d2482){if(!_0x2d2482){_0x3ebca9[_0x93b6('0x1e')](0x194);}return _0x2d2482;};}function handleError(_0x51e944,_0x5e77b9){_0x5e77b9=_0x5e77b9||0x1f4;return function(_0x2eb1c9){logger['error'](_0x2eb1c9[_0x93b6('0x30')]);if(_0x2eb1c9[_0x93b6('0x31')]){delete _0x2eb1c9[_0x93b6('0x31')];}_0x51e944[_0x93b6('0x1f')](_0x5e77b9)['send'](_0x2eb1c9);};}exports['index']=function(_0xe1b0f0,_0x656abf){var _0x2616ff={},_0x3cea02={},_0x45ad86={'count':0x0,'rows':[]};var _0x573d4f=_[_0x93b6('0x32')](db[_0x93b6('0x33')][_0x93b6('0x34')],function(_0x5784ff){return{'name':_0x5784ff[_0x93b6('0x35')],'type':_0x5784ff[_0x93b6('0x36')][_0x93b6('0x37')]};});_0x3cea02[_0x93b6('0x38')]=_['map'](_0x573d4f,'name');_0x3cea02[_0x93b6('0x39')]=_[_0x93b6('0x3a')](_0xe1b0f0['query']);_0x3cea02[_0x93b6('0x3b')]=_[_0x93b6('0x3c')](_0x3cea02['model'],_0x3cea02['query']);_0x2616ff[_0x93b6('0x3d')]=_[_0x93b6('0x3c')](_0x3cea02[_0x93b6('0x38')],qs[_0x93b6('0x3e')](_0xe1b0f0[_0x93b6('0x39')][_0x93b6('0x3e')]));_0x2616ff['attributes']=_0x2616ff['attributes'][_0x93b6('0x3f')]?_0x2616ff[_0x93b6('0x3d')]:_0x3cea02[_0x93b6('0x38')];if(!_0xe1b0f0[_0x93b6('0x39')][_0x93b6('0x40')](_0x93b6('0x41'))){_0x2616ff[_0x93b6('0x24')]=qs[_0x93b6('0x24')](_0xe1b0f0[_0x93b6('0x39')][_0x93b6('0x24')]);_0x2616ff[_0x93b6('0x22')]=qs[_0x93b6('0x22')](_0xe1b0f0['query'][_0x93b6('0x22')]);}_0x2616ff[_0x93b6('0x42')]=qs[_0x93b6('0x43')](_0xe1b0f0[_0x93b6('0x39')]['sort']);_0x2616ff['where']=qs[_0x93b6('0x3b')](_[_0x93b6('0x44')](_0xe1b0f0[_0x93b6('0x39')],_0x3cea02[_0x93b6('0x3b')]),_0x573d4f);if(_0xe1b0f0[_0x93b6('0x39')][_0x93b6('0x45')]){_0x2616ff[_0x93b6('0x46')]=_[_0x93b6('0x47')](_0x2616ff[_0x93b6('0x46')],{'$or':_['map'](_0x573d4f,function(_0x30f8b6){if(_0x30f8b6[_0x93b6('0x36')]!=='VIRTUAL'){var _0x3b2ced={};_0x3b2ced[_0x30f8b6[_0x93b6('0x31')]]={'$like':'%'+_0xe1b0f0[_0x93b6('0x39')]['filter']+'%'};return _0x3b2ced;}})});}_0x2616ff=_['merge']({},_0x2616ff,_0xe1b0f0[_0x93b6('0x48')]);var _0x21196d={'where':_0x2616ff[_0x93b6('0x46')]};return db['Dashboard']['count'](_0x21196d)['then'](function(_0x36c14a){_0x45ad86[_0x93b6('0x25')]=_0x36c14a;if(_0xe1b0f0[_0x93b6('0x39')][_0x93b6('0x49')]){_0x2616ff['include']=[{'all':!![]}];}return db['Dashboard'][_0x93b6('0x4a')](_0x2616ff);})[_0x93b6('0x2c')](function(_0x216578){_0x45ad86[_0x93b6('0x4b')]=_0x216578;return _0x45ad86;})['then'](respondWithFilteredResult(_0x656abf,_0x2616ff))[_0x93b6('0x4c')](handleError(_0x656abf,null));};exports[_0x93b6('0x4d')]=function(_0x3fc056,_0x5a3c39){var _0x40a9a1={'raw':![],'where':{'id':_0x3fc056['params']['id']}},_0x10fb7b={};_0x10fb7b['model']=_['keys'](db[_0x93b6('0x33')][_0x93b6('0x34')]);_0x10fb7b['query']=_[_0x93b6('0x3a')](_0x3fc056[_0x93b6('0x39')]);_0x10fb7b[_0x93b6('0x3b')]=_[_0x93b6('0x3c')](_0x10fb7b[_0x93b6('0x38')],_0x10fb7b[_0x93b6('0x39')]);_0x40a9a1[_0x93b6('0x3d')]=_[_0x93b6('0x3c')](_0x10fb7b[_0x93b6('0x38')],qs['fields'](_0x3fc056[_0x93b6('0x39')][_0x93b6('0x3e')]));_0x40a9a1[_0x93b6('0x3d')]=_0x40a9a1[_0x93b6('0x3d')]['length']?_0x40a9a1[_0x93b6('0x3d')]:_0x10fb7b[_0x93b6('0x38')];if(_0x3fc056['query'][_0x93b6('0x49')]){_0x40a9a1[_0x93b6('0x4e')]=[{'all':!![]}];}_0x40a9a1=_[_0x93b6('0x47')]({},_0x40a9a1,_0x3fc056['options']);return db[_0x93b6('0x33')][_0x93b6('0x4f')](_0x40a9a1)[_0x93b6('0x2c')](handleEntityNotFound(_0x5a3c39,null))[_0x93b6('0x2c')](respondWithResult(_0x5a3c39,null))[_0x93b6('0x4c')](handleError(_0x5a3c39,null));};exports['create']=function(_0x31ca2e,_0x3368da){return db[_0x93b6('0x33')]['create'](_0x31ca2e[_0x93b6('0x50')],{})['then'](function(_0x15d994){var _0x102d8a=_0x31ca2e[_0x93b6('0x51')]['get']({'plain':!![]});if(!_0x102d8a)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x102d8a['role']===_0x93b6('0x51')){var _0x4874ad=_0x15d994['get']({'plain':!![]});var _0x5a3dec=_0x93b6('0x2e');return db['UserProfileSection'][_0x93b6('0x4f')]({'where':{'name':_0x5a3dec,'userProfileId':_0x102d8a['userProfileId']},'raw':!![]})['then'](function(_0xa03227){if(_0xa03227&&_0xa03227[_0x93b6('0x52')]===0x0){return db[_0x93b6('0x2f')]['create']({'name':_0x4874ad[_0x93b6('0x31')],'resourceId':_0x4874ad['id'],'type':_0xa03227[_0x93b6('0x31')],'sectionId':_0xa03227['id']},{})[_0x93b6('0x2c')](function(){return _0x15d994;});}else{return _0x15d994;}})[_0x93b6('0x4c')](function(_0x1d7c4d){logger['error'](_0x93b6('0x53'),_0x1d7c4d);throw _0x1d7c4d;});}return _0x15d994;})[_0x93b6('0x2c')](respondWithResult(_0x3368da,0xc9))[_0x93b6('0x4c')](handleError(_0x3368da,null));};exports[_0x93b6('0x54')]=function(_0x34509f,_0x3149f6){var _0x29d91e={'where':{'id':_0x34509f['params']['id']}},_0x5a41c3={};_0x5a41c3[_0x93b6('0x38')]=_[_0x93b6('0x3a')](db[_0x93b6('0x33')][_0x93b6('0x34')]);_0x29d91e[_0x93b6('0x3d')]=_[_0x93b6('0x3c')](_0x5a41c3[_0x93b6('0x38')],qs[_0x93b6('0x3e')](_0x34509f['query'][_0x93b6('0x3e')]));_0x29d91e[_0x93b6('0x3d')]=_0x29d91e['attributes']['length']?_0x29d91e['attributes']:_0x5a41c3[_0x93b6('0x38')];if(_0x34509f[_0x93b6('0x39')][_0x93b6('0x49')]){_0x29d91e[_0x93b6('0x4e')]=[{'all':!![]}];}_0x29d91e=_[_0x93b6('0x47')]({},_0x29d91e,_0x34509f[_0x93b6('0x48')]);return db[_0x93b6('0x33')][_0x93b6('0x4f')](_0x29d91e)[_0x93b6('0x2c')](handleEntityNotFound(_0x3149f6,null))[_0x93b6('0x2c')](function(_0x28dad8){if(_0x28dad8){var _0x1ee049=_0x28dad8['get']({'plain':!![]});_0x1ee049=qs[_0x93b6('0x55')](_0x1ee049,['id','createdAt','updatedAt']);_0x34509f[_0x93b6('0x50')]=_[_0x93b6('0x55')](_0x34509f[_0x93b6('0x50')],['id','createdAt',_0x93b6('0x56')]);return db[_0x93b6('0x33')][_0x93b6('0x57')](_[_0x93b6('0x47')](_0x1ee049,_0x34509f[_0x93b6('0x50')]),{'include':_0x34509f['query'][_0x93b6('0x49')]?[{'all':!![]}]:undefined})['then'](function(_0x2a42fd){var _0x224991=_0x34509f[_0x93b6('0x51')][_0x93b6('0x2d')]({'plain':!![]});if(!_0x224991)throw new Error(_0x93b6('0x58'));if(_0x224991['role']===_0x93b6('0x51')){var _0x17bb70=_0x2a42fd['get']({'plain':!![]});var _0x254a7b=_0x93b6('0x2e');return db['UserProfileSection'][_0x93b6('0x4f')]({'where':{'name':_0x254a7b,'userProfileId':_0x224991['userProfileId']},'raw':!![]})[_0x93b6('0x2c')](function(_0x3ca52e){if(_0x3ca52e&&_0x3ca52e[_0x93b6('0x52')]===0x0){return db[_0x93b6('0x2f')]['create']({'name':_0x17bb70[_0x93b6('0x31')],'resourceId':_0x17bb70['id'],'type':_0x3ca52e[_0x93b6('0x31')],'sectionId':_0x3ca52e['id']},{})[_0x93b6('0x2c')](function(){return _0x2a42fd;});}else{return _0x2a42fd;}})[_0x93b6('0x4c')](function(_0x5b2b2e){logger[_0x93b6('0x59')](_0x93b6('0x53'),_0x5b2b2e);throw _0x5b2b2e;});}return _0x2a42fd;});}})[_0x93b6('0x2c')](respondWithResult(_0x3149f6,0xc9))['catch'](handleError(_0x3149f6,null));};exports['update']=function(_0x2ebfa5,_0x5e34b5){if(_0x2ebfa5[_0x93b6('0x50')]['id']){delete _0x2ebfa5[_0x93b6('0x50')]['id'];}return db[_0x93b6('0x33')][_0x93b6('0x4f')]({'where':{'id':_0x2ebfa5[_0x93b6('0x5a')]['id']}})[_0x93b6('0x2c')](handleEntityNotFound(_0x5e34b5,null))[_0x93b6('0x2c')](saveUpdates(_0x2ebfa5[_0x93b6('0x50')],null))[_0x93b6('0x2c')](respondWithResult(_0x5e34b5,null))[_0x93b6('0x4c')](handleError(_0x5e34b5,null));};exports['destroy']=function(_0x501b84,_0x927cf5){return db['Dashboard'][_0x93b6('0x4f')]({'where':{'id':_0x501b84['params']['id']}})[_0x93b6('0x2c')](handleEntityNotFound(_0x927cf5,null))[_0x93b6('0x2c')](removeEntity(_0x927cf5,null))[_0x93b6('0x4c')](handleError(_0x927cf5,null));};function widgetAttributes(_0x3d9dcf){try{switch(_0x3d9dcf[_0x93b6('0x36')]){case'iframe':return[{'name':'attrUrl','value':_0x3d9dcf[_0x93b6('0x5b')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x0]?_0x3d9dcf['attrs'][0x0][_0x93b6('0x5d')]:undefined)||_0x93b6('0x5e')}];case'custom':return[{'name':'attrPath','value':_0x3d9dcf[_0x93b6('0x5f')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf['attrs'][0x0]?_0x3d9dcf['attrs'][0x0]['value']:undefined)||''}];case'clock':return[{'name':_0x93b6('0x60'),'value':_0x3d9dcf[_0x93b6('0x60')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf['attrs'][0x0]?_0x3d9dcf['attrs'][0x0][_0x93b6('0x5d')]:undefined)||_0x93b6('0x61')},{'name':_0x93b6('0x62'),'value':_0x3d9dcf['attrTimezone']||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x1]?_0x3d9dcf[_0x93b6('0x5c')][0x1]['value']:undefined)||_0x93b6('0x63')},{'name':_0x93b6('0x64'),'value':_0x3d9dcf[_0x93b6('0x64')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x2]?_0x3d9dcf[_0x93b6('0x5c')][0x2][_0x93b6('0x5d')]:undefined)||0xc}];case _0x93b6('0x65'):return[{'name':_0x93b6('0x66'),'value':_0x3d9dcf[_0x93b6('0x66')]||(_0x3d9dcf['attrs']&&_0x3d9dcf[_0x93b6('0x5c')][0x0]?_0x3d9dcf[_0x93b6('0x5c')][0x0][_0x93b6('0x5d')]:undefined)||_0x93b6('0x67')},{'name':_0x93b6('0x68'),'value':_0x3d9dcf[_0x93b6('0x68')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x1]?_0x3d9dcf[_0x93b6('0x5c')][0x1]['value']:undefined)||[]},{'name':_0x93b6('0x64'),'value':_0x3d9dcf[_0x93b6('0x64')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x2]?_0x3d9dcf[_0x93b6('0x5c')][0x2][_0x93b6('0x5d')]:undefined)||0x14},{'name':_0x93b6('0x69'),'value':_0x3d9dcf['attrChannel']||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf['attrs'][0x3]?_0x3d9dcf[_0x93b6('0x5c')][0x3]['value']:undefined)||_0x93b6('0x6a')},{'name':'attrEmailAccounts','value':_0x3d9dcf[_0x93b6('0x6b')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x4]?_0x3d9dcf[_0x93b6('0x5c')][0x4][_0x93b6('0x5d')]:undefined)||''},{'name':_0x93b6('0x6c'),'value':_0x3d9dcf['attrFaxAccounts']||(_0x3d9dcf['attrs']&&_0x3d9dcf[_0x93b6('0x5c')][0x5]?_0x3d9dcf[_0x93b6('0x5c')][0x5][_0x93b6('0x5d')]:undefined)||''},{'name':_0x93b6('0x6d'),'value':_0x3d9dcf['attrSmsAccounts']||(_0x3d9dcf['attrs']&&_0x3d9dcf[_0x93b6('0x5c')][0x6]?_0x3d9dcf[_0x93b6('0x5c')][0x6][_0x93b6('0x5d')]:undefined)||''},{'name':_0x93b6('0x6e'),'value':_0x3d9dcf['attrOpenchannelAccounts']||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf['attrs'][0x7]?_0x3d9dcf[_0x93b6('0x5c')][0x7][_0x93b6('0x5d')]:undefined)||''},{'name':_0x93b6('0x6f'),'value':_0x3d9dcf['attrWhatsappAccounts']||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x8]?_0x3d9dcf[_0x93b6('0x5c')][0x8][_0x93b6('0x5d')]:undefined)||''},{'name':'attrChatWebsites','value':_0x3d9dcf['attrChatWebsites']||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x9]?_0x3d9dcf[_0x93b6('0x5c')][0x9][_0x93b6('0x5d')]:undefined)||''}];case _0x93b6('0x70'):case _0x93b6('0x71'):return[{'name':_0x93b6('0x72'),'value':_0x3d9dcf[_0x93b6('0x72')]||(_0x3d9dcf['attrs']&&_0x3d9dcf[_0x93b6('0x5c')][0x0]?_0x3d9dcf[_0x93b6('0x5c')][0x0][_0x93b6('0x5d')]:undefined)||'total'},{'name':_0x93b6('0x73'),'value':_0x3d9dcf[_0x93b6('0x73')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x1]?_0x3d9dcf[_0x93b6('0x5c')][0x1][_0x93b6('0x5d')]:undefined)||null},{'name':_0x93b6('0x74'),'value':_0x3d9dcf['attrSerie3']||(_0x3d9dcf['attrs']&&_0x3d9dcf[_0x93b6('0x5c')][0x2]?_0x3d9dcf[_0x93b6('0x5c')][0x2][_0x93b6('0x5d')]:undefined)||null},{'name':_0x93b6('0x68'),'value':_0x3d9dcf[_0x93b6('0x68')]||(_0x3d9dcf['attrs']&&_0x3d9dcf[_0x93b6('0x5c')][0x3]?_0x3d9dcf['attrs'][0x3][_0x93b6('0x5d')]:undefined)||[]},{'name':_0x93b6('0x69'),'value':_0x3d9dcf['attrChannel']||(_0x3d9dcf['attrs']&&_0x3d9dcf['attrs'][0x4]?_0x3d9dcf[_0x93b6('0x5c')][0x4]['value']:undefined)||_0x93b6('0x6a')},{'name':'attrEmailAccounts','value':_0x3d9dcf[_0x93b6('0x6b')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf['attrs'][0x5]?_0x3d9dcf[_0x93b6('0x5c')][0x5]['value']:undefined)||''},{'name':'attrFaxAccounts','value':_0x3d9dcf[_0x93b6('0x6c')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x6]?_0x3d9dcf[_0x93b6('0x5c')][0x6][_0x93b6('0x5d')]:undefined)||''},{'name':'attrSmsAccounts','value':_0x3d9dcf[_0x93b6('0x6d')]||(_0x3d9dcf['attrs']&&_0x3d9dcf[_0x93b6('0x5c')][0x7]?_0x3d9dcf['attrs'][0x7][_0x93b6('0x5d')]:undefined)||''},{'name':_0x93b6('0x6e'),'value':_0x3d9dcf[_0x93b6('0x6e')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x8]?_0x3d9dcf[_0x93b6('0x5c')][0x8][_0x93b6('0x5d')]:undefined)||''},{'name':_0x93b6('0x6f'),'value':_0x3d9dcf[_0x93b6('0x6f')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf['attrs'][0x9]?_0x3d9dcf['attrs'][0x9][_0x93b6('0x5d')]:undefined)||''},{'name':_0x93b6('0x75'),'value':_0x3d9dcf['attrChatWebsites']||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0xa]?_0x3d9dcf[_0x93b6('0x5c')][0xa][_0x93b6('0x5d')]:undefined)||''}];case'web-report':return[{'name':_0x93b6('0x76'),'type':_0x3d9dcf[_0x93b6('0x77')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf['attrs'][0x0]?_0x3d9dcf['attrs'][0x0][_0x93b6('0x36')]:undefined)||null,'value':_0x3d9dcf[_0x93b6('0x76')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x0]?_0x3d9dcf[_0x93b6('0x5c')][0x0][_0x93b6('0x5d')]:undefined)||null},{'name':_0x93b6('0x78'),'value':_0x3d9dcf[_0x93b6('0x78')]||(_0x3d9dcf[_0x93b6('0x5c')]&&_0x3d9dcf[_0x93b6('0x5c')][0x1]?_0x3d9dcf[_0x93b6('0x5c')][0x1][_0x93b6('0x5d')]:undefined)||0x0}];default:return[];}}catch(_0x3907be){logger[_0x93b6('0x59')](_0x93b6('0x79'),JSON[_0x93b6('0x7a')](_0x3907be));return[];}}exports[_0x93b6('0x7b')]=function(_0x418355,_0x5dab44,_0x15e28d){if(_0x418355[_0x93b6('0x50')]['id']){delete _0x418355[_0x93b6('0x50')]['id'];}return db[_0x93b6('0x33')][_0x93b6('0x4f')]({'where':{'id':_0x418355[_0x93b6('0x5a')]['id']}})[_0x93b6('0x2c')](handleEntityNotFound(_0x5dab44,null))[_0x93b6('0x2c')](function(_0x459238){if(_0x459238){_0x418355[_0x93b6('0x50')]['DashboardId']=_0x459238['id'];_0x418355[_0x93b6('0x50')][_0x93b6('0x5c')]=widgetAttributes(_0x418355['body']);return db[_0x93b6('0x7c')][_0x93b6('0x57')](_0x418355['body']);}})['then'](respondWithResult(_0x5dab44,null))[_0x93b6('0x4c')](handleError(_0x5dab44,null));};exports['getItems']=function(_0x443f8e,_0x58418b,_0x1ce73f){var _0xdd76e5={};var _0x131d3a={};var _0x340520;var _0x158fec;return db['Dashboard'][_0x93b6('0x7d')]({'where':{'id':_0x443f8e[_0x93b6('0x5a')]['id']}})[_0x93b6('0x2c')](handleEntityNotFound(_0x58418b,null))[_0x93b6('0x2c')](function(_0x9db573){if(_0x9db573){_0x340520=_0x9db573;_0x131d3a[_0x93b6('0x38')]=_[_0x93b6('0x3a')](db['DashboardItem']['rawAttributes']);_0x131d3a[_0x93b6('0x39')]=_[_0x93b6('0x3a')](_0x443f8e[_0x93b6('0x39')]);_0x131d3a[_0x93b6('0x3b')]=_[_0x93b6('0x3c')](_0x131d3a[_0x93b6('0x38')],_0x131d3a[_0x93b6('0x39')]);_0xdd76e5[_0x93b6('0x3d')]=_[_0x93b6('0x3c')](_0x131d3a[_0x93b6('0x38')],qs[_0x93b6('0x3e')](_0x443f8e['query'][_0x93b6('0x3e')]));_0xdd76e5[_0x93b6('0x3d')]=_0xdd76e5['attributes'][_0x93b6('0x3f')]?_0xdd76e5[_0x93b6('0x3d')]:_0x131d3a['model'];_0xdd76e5[_0x93b6('0x42')]=qs[_0x93b6('0x43')](_0x443f8e[_0x93b6('0x39')][_0x93b6('0x43')]);_0xdd76e5[_0x93b6('0x46')]=qs[_0x93b6('0x3b')](_[_0x93b6('0x44')](_0x443f8e['query'],_0x131d3a[_0x93b6('0x3b')]));if(_0x443f8e[_0x93b6('0x39')][_0x93b6('0x45')]){_0xdd76e5['where']=_[_0x93b6('0x47')](_0xdd76e5['where'],{'$or':_[_0x93b6('0x32')](_0xdd76e5['attributes'],function(_0x2f642b){var _0x59c984={};_0x59c984[_0x2f642b]={'$like':'%'+_0x443f8e[_0x93b6('0x39')][_0x93b6('0x45')]+'%'};return _0x59c984;})});}_0xdd76e5=_['merge']({},_0xdd76e5,_0x443f8e['options']);return _0x340520[_0x93b6('0x7e')](_0xdd76e5);}})['then'](function(_0x2ab957){if(_0x2ab957){_0x158fec=_0x2ab957[_0x93b6('0x3f')];if(!_0x443f8e[_0x93b6('0x39')]['hasOwnProperty'](_0x93b6('0x41'))){_0xdd76e5[_0x93b6('0x24')]=qs[_0x93b6('0x24')](_0x443f8e['query'][_0x93b6('0x24')]);_0xdd76e5[_0x93b6('0x22')]=qs[_0x93b6('0x22')](_0x443f8e[_0x93b6('0x39')][_0x93b6('0x22')]);}return _0x340520[_0x93b6('0x7e')](_0xdd76e5);}})[_0x93b6('0x2c')](function(_0x5125a6){if(_0x5125a6){return _0x5125a6?{'count':_0x158fec,'rows':_0x5125a6}:null;}})[_0x93b6('0x2c')](respondWithResult(_0x58418b,null))[_0x93b6('0x4c')](handleError(_0x58418b,null));};