[motion2.git] / server / api / dashboard / dashboard.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x044e=['../../mysqldb','redis','defaults','localhost','socket.io-emitter','./dashboard.socket','register','sendStatus','end','status','json','offset','limit','undefined','count','set','Content-Range','apply','save','update','then','destroy','UserProfileResource','error','name','index','Dashboard','rawAttributes','fieldName','type','model','map','filters','intersection','query','attributes','fields','hasOwnProperty','order','where','pick','filter','VIRTUAL','merge','includeAll','include','findAll','rows','catch','show','keys','length','options','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','CustomDashboards','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','createdAt','updatedAt','params','iframe','attrUrl','attrs','value','https://','custom','attrPath','clock','attrHourFormat','HH:mm:ss','attrTimezone','0.00','attrFontSize','attrMetric','attrChannel','attrEmailAccounts','attrFaxAccounts','attrSmsAccounts','attrOpenchannelAccounts','attrWhatsappAccounts','attrChatWebsites','multibar-chart','pie-chart','attrSerie1','total','attrSerie2','attrSerie3','attrVoiceQueues','voice','web-report','attrReport','attrRefresh','widgetAttributes:\x20%s','stringify','addItem','DashboardId','DashboardItem','getItems','findOne','sort','nolimit','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api'];(function(_0x3f8647,_0x39c233){var _0x39d095=function(_0x367490){while(--_0x367490){_0x3f8647['push'](_0x3f8647['shift']());}};_0x39d095(++_0x39c233);}(_0x044e,0x6d));var _0xe044=function(_0x3f6d56,_0x5ef822){_0x3f6d56=_0x3f6d56-0x0;var _0x219dcd=_0x044e[_0x3f6d56];return _0x219dcd;};'use strict';var emlformat=require(_0xe044('0x0'));var rimraf=require(_0xe044('0x1'));var zipdir=require(_0xe044('0x2'));var jsonpatch=require(_0xe044('0x3'));var rp=require(_0xe044('0x4'));var moment=require(_0xe044('0x5'));var BPromise=require(_0xe044('0x6'));var Mustache=require(_0xe044('0x7'));var util=require('util');var path=require(_0xe044('0x8'));var sox=require(_0xe044('0x9'));var csv=require(_0xe044('0xa'));var ejs=require(_0xe044('0xb'));var fs=require('fs');var fs_extra=require(_0xe044('0xc'));var _=require(_0xe044('0xd'));var squel=require(_0xe044('0xe'));var crypto=require(_0xe044('0xf'));var jsforce=require(_0xe044('0x10'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xe044('0x11'));var Papa=require(_0xe044('0x12'));var Redis=require(_0xe044('0x13'));var authService=require(_0xe044('0x14'));var qs=require(_0xe044('0x15'));var as=require(_0xe044('0x16'));var hardwareService=require(_0xe044('0x17'));var logger=require(_0xe044('0x18'))(_0xe044('0x19'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xe044('0x1a'))['db'];config[_0xe044('0x1b')]=_[_0xe044('0x1c')](config[_0xe044('0x1b')],{'host':_0xe044('0x1d'),'port':0x18eb});var socket=require(_0xe044('0x1e'))(new Redis(config['redis']));require(_0xe044('0x1f'))[_0xe044('0x20')](socket);function respondWithStatusCode(_0x434315,_0x4bd690){_0x4bd690=_0x4bd690||0xcc;return function(_0x1d824a){if(_0x1d824a){return _0x434315[_0xe044('0x21')](_0x4bd690);}return _0x434315['status'](_0x4bd690)[_0xe044('0x22')]();};}function respondWithResult(_0x498f5b,_0x52cf8b){_0x52cf8b=_0x52cf8b||0xc8;return function(_0x25cd47){if(_0x25cd47){return _0x498f5b[_0xe044('0x23')](_0x52cf8b)[_0xe044('0x24')](_0x25cd47);}};}function respondWithFilteredResult(_0x928694,_0x547989){return function(_0x4b28ab){if(_0x4b28ab){var _0x4dc7f6=typeof _0x547989[_0xe044('0x25')]==='undefined'&&typeof _0x547989[_0xe044('0x26')]===_0xe044('0x27');var _0x47845d=_0x4b28ab[_0xe044('0x28')];var _0x560cdc=_0x4dc7f6?0x0:_0x547989[_0xe044('0x25')];var _0x259853=_0x4dc7f6?_0x4b28ab[_0xe044('0x28')]:_0x547989[_0xe044('0x25')]+_0x547989[_0xe044('0x26')];var _0x306377;if(_0x259853>=_0x47845d){_0x259853=_0x47845d;_0x306377=0xc8;}else{_0x306377=0xce;}_0x928694[_0xe044('0x23')](_0x306377);return _0x928694[_0xe044('0x29')](_0xe044('0x2a'),_0x560cdc+'-'+_0x259853+'/'+_0x47845d)[_0xe044('0x24')](_0x4b28ab);}return null;};}function patchUpdates(_0xa5210f){return function(_0x5c57f6){try{jsonpatch[_0xe044('0x2b')](_0x5c57f6,_0xa5210f,!![]);}catch(_0x41e08a){return BPromise['reject'](_0x41e08a);}return _0x5c57f6[_0xe044('0x2c')]();};}function saveUpdates(_0xb10450,_0x11bf41){return function(_0x20aaf4){if(_0x20aaf4){return _0x20aaf4[_0xe044('0x2d')](_0xb10450)[_0xe044('0x2e')](function(_0x18e6da){return _0x18e6da;});}return null;};}function removeEntity(_0x315749,_0x1ff097){return function(_0x24758b){if(_0x24758b){return _0x24758b[_0xe044('0x2f')]()['then'](function(){var _0x3e6271=_0x24758b['get']({'plain':!![]});var _0x1afbf6='CustomDashboards';return db[_0xe044('0x30')]['destroy']({'where':{'type':_0x1afbf6,'resourceId':_0x3e6271['id']}})[_0xe044('0x2e')](function(){return _0x24758b;});})['then'](function(){_0x315749[_0xe044('0x23')](0xcc)[_0xe044('0x22')]();});}};}function handleEntityNotFound(_0x469599,_0x250ae6){return function(_0x12d822){if(!_0x12d822){_0x469599[_0xe044('0x21')](0x194);}return _0x12d822;};}function handleError(_0x4e18fb,_0x16c789){_0x16c789=_0x16c789||0x1f4;return function(_0x105665){logger[_0xe044('0x31')](_0x105665['stack']);if(_0x105665['name']){delete _0x105665[_0xe044('0x32')];}_0x4e18fb[_0xe044('0x23')](_0x16c789)['send'](_0x105665);};}exports[_0xe044('0x33')]=function(_0x559752,_0x5eba71){var _0x270a08={},_0x3870da={},_0x21cd4f={'count':0x0,'rows':[]};var _0x5f499f=_['map'](db[_0xe044('0x34')][_0xe044('0x35')],function(_0x4dcfcf){return{'name':_0x4dcfcf[_0xe044('0x36')],'type':_0x4dcfcf[_0xe044('0x37')]['key']};});_0x3870da[_0xe044('0x38')]=_[_0xe044('0x39')](_0x5f499f,_0xe044('0x32'));_0x3870da['query']=_['keys'](_0x559752['query']);_0x3870da[_0xe044('0x3a')]=_[_0xe044('0x3b')](_0x3870da[_0xe044('0x38')],_0x3870da[_0xe044('0x3c')]);_0x270a08[_0xe044('0x3d')]=_[_0xe044('0x3b')](_0x3870da['model'],qs[_0xe044('0x3e')](_0x559752[_0xe044('0x3c')][_0xe044('0x3e')]));_0x270a08['attributes']=_0x270a08[_0xe044('0x3d')]['length']?_0x270a08['attributes']:_0x3870da[_0xe044('0x38')];if(!_0x559752[_0xe044('0x3c')][_0xe044('0x3f')]('nolimit')){_0x270a08[_0xe044('0x26')]=qs[_0xe044('0x26')](_0x559752['query'][_0xe044('0x26')]);_0x270a08[_0xe044('0x25')]=qs[_0xe044('0x25')](_0x559752[_0xe044('0x3c')]['offset']);}_0x270a08[_0xe044('0x40')]=qs['sort'](_0x559752[_0xe044('0x3c')]['sort']);_0x270a08[_0xe044('0x41')]=qs[_0xe044('0x3a')](_[_0xe044('0x42')](_0x559752[_0xe044('0x3c')],_0x3870da[_0xe044('0x3a')]),_0x5f499f);if(_0x559752['query'][_0xe044('0x43')]){_0x270a08[_0xe044('0x41')]=_['merge'](_0x270a08[_0xe044('0x41')],{'$or':_[_0xe044('0x39')](_0x5f499f,function(_0x5f02a5){if(_0x5f02a5['type']!==_0xe044('0x44')){var _0x182656={};_0x182656[_0x5f02a5[_0xe044('0x32')]]={'$like':'%'+_0x559752[_0xe044('0x3c')]['filter']+'%'};return _0x182656;}})});}_0x270a08=_[_0xe044('0x45')]({},_0x270a08,_0x559752['options']);var _0x4c1df1={'where':_0x270a08[_0xe044('0x41')]};return db[_0xe044('0x34')][_0xe044('0x28')](_0x4c1df1)[_0xe044('0x2e')](function(_0x4a0d76){_0x21cd4f[_0xe044('0x28')]=_0x4a0d76;if(_0x559752[_0xe044('0x3c')][_0xe044('0x46')]){_0x270a08[_0xe044('0x47')]=[{'all':!![]}];}return db[_0xe044('0x34')][_0xe044('0x48')](_0x270a08);})[_0xe044('0x2e')](function(_0x470e81){_0x21cd4f[_0xe044('0x49')]=_0x470e81;return _0x21cd4f;})[_0xe044('0x2e')](respondWithFilteredResult(_0x5eba71,_0x270a08))[_0xe044('0x4a')](handleError(_0x5eba71,null));};exports[_0xe044('0x4b')]=function(_0x33d3e7,_0xaa7263){var _0x418de9={'raw':![],'where':{'id':_0x33d3e7['params']['id']}},_0x4d6b20={};_0x4d6b20['model']=_[_0xe044('0x4c')](db['Dashboard'][_0xe044('0x35')]);_0x4d6b20['query']=_[_0xe044('0x4c')](_0x33d3e7[_0xe044('0x3c')]);_0x4d6b20[_0xe044('0x3a')]=_[_0xe044('0x3b')](_0x4d6b20[_0xe044('0x38')],_0x4d6b20[_0xe044('0x3c')]);_0x418de9[_0xe044('0x3d')]=_[_0xe044('0x3b')](_0x4d6b20[_0xe044('0x38')],qs[_0xe044('0x3e')](_0x33d3e7[_0xe044('0x3c')][_0xe044('0x3e')]));_0x418de9[_0xe044('0x3d')]=_0x418de9[_0xe044('0x3d')][_0xe044('0x4d')]?_0x418de9[_0xe044('0x3d')]:_0x4d6b20['model'];if(_0x33d3e7[_0xe044('0x3c')][_0xe044('0x46')]){_0x418de9[_0xe044('0x47')]=[{'all':!![]}];}_0x418de9=_['merge']({},_0x418de9,_0x33d3e7[_0xe044('0x4e')]);return db['Dashboard'][_0xe044('0x4f')](_0x418de9)[_0xe044('0x2e')](handleEntityNotFound(_0xaa7263,null))[_0xe044('0x2e')](respondWithResult(_0xaa7263,null))['catch'](handleError(_0xaa7263,null));};exports[_0xe044('0x50')]=function(_0x2dfad7,_0x2b4d95){return db[_0xe044('0x34')][_0xe044('0x50')](_0x2dfad7[_0xe044('0x51')],{})[_0xe044('0x2e')](function(_0x242f09){var _0x3e9eee=_0x2dfad7[_0xe044('0x52')][_0xe044('0x53')]({'plain':!![]});if(!_0x3e9eee)throw new Error(_0xe044('0x54'));if(_0x3e9eee[_0xe044('0x55')]===_0xe044('0x52')){var _0x5ad228=_0x242f09[_0xe044('0x53')]({'plain':!![]});var _0x5b4eb6=_0xe044('0x56');return db[_0xe044('0x57')][_0xe044('0x4f')]({'where':{'name':_0x5b4eb6,'userProfileId':_0x3e9eee['userProfileId']},'raw':!![]})[_0xe044('0x2e')](function(_0x4f8917){if(_0x4f8917&&_0x4f8917[_0xe044('0x58')]===0x0){return db[_0xe044('0x30')]['create']({'name':_0x5ad228['name'],'resourceId':_0x5ad228['id'],'type':_0x4f8917['name'],'sectionId':_0x4f8917['id']},{})[_0xe044('0x2e')](function(){return _0x242f09;});}else{return _0x242f09;}})['catch'](function(_0x4f1bdc){logger['error'](_0xe044('0x59'),_0x4f1bdc);throw _0x4f1bdc;});}return _0x242f09;})['then'](respondWithResult(_0x2b4d95,0xc9))[_0xe044('0x4a')](handleError(_0x2b4d95,null));};exports[_0xe044('0x5a')]=function(_0x1c8429,_0x6a31f7){var _0x5d1bc6={'where':{'id':_0x1c8429['params']['id']}},_0x2751da={};_0x2751da[_0xe044('0x38')]=_[_0xe044('0x4c')](db[_0xe044('0x34')][_0xe044('0x35')]);_0x5d1bc6[_0xe044('0x3d')]=_[_0xe044('0x3b')](_0x2751da[_0xe044('0x38')],qs[_0xe044('0x3e')](_0x1c8429[_0xe044('0x3c')][_0xe044('0x3e')]));_0x5d1bc6[_0xe044('0x3d')]=_0x5d1bc6[_0xe044('0x3d')][_0xe044('0x4d')]?_0x5d1bc6[_0xe044('0x3d')]:_0x2751da[_0xe044('0x38')];if(_0x1c8429[_0xe044('0x3c')][_0xe044('0x46')]){_0x5d1bc6['include']=[{'all':!![]}];}_0x5d1bc6=_[_0xe044('0x45')]({},_0x5d1bc6,_0x1c8429['options']);return db[_0xe044('0x34')][_0xe044('0x4f')](_0x5d1bc6)[_0xe044('0x2e')](handleEntityNotFound(_0x6a31f7,null))[_0xe044('0x2e')](function(_0x3edb07){if(_0x3edb07){var _0x53d671=_0x3edb07['get']({'plain':!![]});_0x53d671=qs['omit'](_0x53d671,['id',_0xe044('0x5b'),'updatedAt']);_0x1c8429['body']=_['omit'](_0x1c8429[_0xe044('0x51')],['id',_0xe044('0x5b'),_0xe044('0x5c')]);return db['Dashboard'][_0xe044('0x50')](_[_0xe044('0x45')](_0x53d671,_0x1c8429[_0xe044('0x51')]),{'include':_0x1c8429[_0xe044('0x3c')][_0xe044('0x46')]?[{'all':!![]}]:undefined})[_0xe044('0x2e')](function(_0x551f96){var _0x3d8917=_0x1c8429[_0xe044('0x52')][_0xe044('0x53')]({'plain':!![]});if(!_0x3d8917)throw new Error(_0xe044('0x54'));if(_0x3d8917[_0xe044('0x55')]===_0xe044('0x52')){var _0x11b21e=_0x551f96[_0xe044('0x53')]({'plain':!![]});var _0x1521a1=_0xe044('0x56');return db['UserProfileSection'][_0xe044('0x4f')]({'where':{'name':_0x1521a1,'userProfileId':_0x3d8917['userProfileId']},'raw':!![]})[_0xe044('0x2e')](function(_0x354cb4){if(_0x354cb4&&_0x354cb4[_0xe044('0x58')]===0x0){return db['UserProfileResource'][_0xe044('0x50')]({'name':_0x11b21e[_0xe044('0x32')],'resourceId':_0x11b21e['id'],'type':_0x354cb4[_0xe044('0x32')],'sectionId':_0x354cb4['id']},{})['then'](function(){return _0x551f96;});}else{return _0x551f96;}})[_0xe044('0x4a')](function(_0x3fc47c){logger[_0xe044('0x31')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x3fc47c);throw _0x3fc47c;});}return _0x551f96;});}})['then'](respondWithResult(_0x6a31f7,0xc9))[_0xe044('0x4a')](handleError(_0x6a31f7,null));};exports[_0xe044('0x2d')]=function(_0x115efe,_0x47e77e){if(_0x115efe['body']['id']){delete _0x115efe['body']['id'];}return db['Dashboard'][_0xe044('0x4f')]({'where':{'id':_0x115efe[_0xe044('0x5d')]['id']}})[_0xe044('0x2e')](handleEntityNotFound(_0x47e77e,null))[_0xe044('0x2e')](saveUpdates(_0x115efe[_0xe044('0x51')],null))[_0xe044('0x2e')](respondWithResult(_0x47e77e,null))[_0xe044('0x4a')](handleError(_0x47e77e,null));};exports[_0xe044('0x2f')]=function(_0x33e876,_0x204bfa){return db[_0xe044('0x34')][_0xe044('0x4f')]({'where':{'id':_0x33e876['params']['id']}})[_0xe044('0x2e')](handleEntityNotFound(_0x204bfa,null))[_0xe044('0x2e')](removeEntity(_0x204bfa,null))['catch'](handleError(_0x204bfa,null));};function widgetAttributes(_0x92cd17){try{switch(_0x92cd17[_0xe044('0x37')]){case _0xe044('0x5e'):return[{'name':_0xe044('0x5f'),'value':_0x92cd17[_0xe044('0x5f')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17['attrs'][0x0]?_0x92cd17[_0xe044('0x60')][0x0][_0xe044('0x61')]:undefined)||_0xe044('0x62')}];case _0xe044('0x63'):return[{'name':_0xe044('0x64'),'value':_0x92cd17[_0xe044('0x64')]||(_0x92cd17['attrs']&&_0x92cd17['attrs'][0x0]?_0x92cd17[_0xe044('0x60')][0x0][_0xe044('0x61')]:undefined)||''}];case _0xe044('0x65'):return[{'name':_0xe044('0x66'),'value':_0x92cd17[_0xe044('0x66')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x0]?_0x92cd17[_0xe044('0x60')][0x0][_0xe044('0x61')]:undefined)||_0xe044('0x67')},{'name':_0xe044('0x68'),'value':_0x92cd17[_0xe044('0x68')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17['attrs'][0x1]?_0x92cd17['attrs'][0x1][_0xe044('0x61')]:undefined)||_0xe044('0x69')},{'name':_0xe044('0x6a'),'value':_0x92cd17[_0xe044('0x6a')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17['attrs'][0x2]?_0x92cd17[_0xe044('0x60')][0x2][_0xe044('0x61')]:undefined)||0xc}];case'counter':return[{'name':_0xe044('0x6b'),'value':_0x92cd17[_0xe044('0x6b')]||(_0x92cd17['attrs']&&_0x92cd17[_0xe044('0x60')][0x0]?_0x92cd17[_0xe044('0x60')][0x0][_0xe044('0x61')]:undefined)||'total'},{'name':'attrVoiceQueues','value':_0x92cd17['attrVoiceQueues']||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x1]?_0x92cd17[_0xe044('0x60')][0x1][_0xe044('0x61')]:undefined)||[]},{'name':_0xe044('0x6a'),'value':_0x92cd17[_0xe044('0x6a')]||(_0x92cd17['attrs']&&_0x92cd17['attrs'][0x2]?_0x92cd17[_0xe044('0x60')][0x2][_0xe044('0x61')]:undefined)||0x14},{'name':'attrChannel','value':_0x92cd17[_0xe044('0x6c')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17['attrs'][0x3]?_0x92cd17['attrs'][0x3]['value']:undefined)||'voice'},{'name':_0xe044('0x6d'),'value':_0x92cd17[_0xe044('0x6d')]||(_0x92cd17['attrs']&&_0x92cd17[_0xe044('0x60')][0x4]?_0x92cd17[_0xe044('0x60')][0x4][_0xe044('0x61')]:undefined)||''},{'name':_0xe044('0x6e'),'value':_0x92cd17[_0xe044('0x6e')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x5]?_0x92cd17[_0xe044('0x60')][0x5][_0xe044('0x61')]:undefined)||''},{'name':_0xe044('0x6f'),'value':_0x92cd17[_0xe044('0x6f')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x6]?_0x92cd17[_0xe044('0x60')][0x6][_0xe044('0x61')]:undefined)||''},{'name':'attrOpenchannelAccounts','value':_0x92cd17[_0xe044('0x70')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17['attrs'][0x7]?_0x92cd17[_0xe044('0x60')][0x7][_0xe044('0x61')]:undefined)||''},{'name':_0xe044('0x71'),'value':_0x92cd17[_0xe044('0x71')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x8]?_0x92cd17[_0xe044('0x60')][0x8][_0xe044('0x61')]:undefined)||''},{'name':'attrChatWebsites','value':_0x92cd17[_0xe044('0x72')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x9]?_0x92cd17[_0xe044('0x60')][0x9][_0xe044('0x61')]:undefined)||''}];case _0xe044('0x73'):case _0xe044('0x74'):return[{'name':_0xe044('0x75'),'value':_0x92cd17[_0xe044('0x75')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17['attrs'][0x0]?_0x92cd17[_0xe044('0x60')][0x0][_0xe044('0x61')]:undefined)||_0xe044('0x76')},{'name':_0xe044('0x77'),'value':_0x92cd17[_0xe044('0x77')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17['attrs'][0x1]?_0x92cd17[_0xe044('0x60')][0x1][_0xe044('0x61')]:undefined)||null},{'name':_0xe044('0x78'),'value':_0x92cd17[_0xe044('0x78')]||(_0x92cd17['attrs']&&_0x92cd17[_0xe044('0x60')][0x2]?_0x92cd17['attrs'][0x2]['value']:undefined)||null},{'name':_0xe044('0x79'),'value':_0x92cd17[_0xe044('0x79')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x3]?_0x92cd17[_0xe044('0x60')][0x3]['value']:undefined)||[]},{'name':_0xe044('0x6c'),'value':_0x92cd17[_0xe044('0x6c')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x4]?_0x92cd17[_0xe044('0x60')][0x4]['value']:undefined)||_0xe044('0x7a')},{'name':'attrEmailAccounts','value':_0x92cd17[_0xe044('0x6d')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x5]?_0x92cd17[_0xe044('0x60')][0x5][_0xe044('0x61')]:undefined)||''},{'name':_0xe044('0x6e'),'value':_0x92cd17[_0xe044('0x6e')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17['attrs'][0x6]?_0x92cd17[_0xe044('0x60')][0x6]['value']:undefined)||''},{'name':_0xe044('0x6f'),'value':_0x92cd17['attrSmsAccounts']||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x7]?_0x92cd17[_0xe044('0x60')][0x7][_0xe044('0x61')]:undefined)||''},{'name':_0xe044('0x70'),'value':_0x92cd17[_0xe044('0x70')]||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x8]?_0x92cd17[_0xe044('0x60')][0x8][_0xe044('0x61')]:undefined)||''},{'name':_0xe044('0x71'),'value':_0x92cd17['attrWhatsappAccounts']||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x9]?_0x92cd17[_0xe044('0x60')][0x9][_0xe044('0x61')]:undefined)||''},{'name':_0xe044('0x72'),'value':_0x92cd17[_0xe044('0x72')]||(_0x92cd17['attrs']&&_0x92cd17[_0xe044('0x60')][0xa]?_0x92cd17[_0xe044('0x60')][0xa]['value']:undefined)||''}];case _0xe044('0x7b'):return[{'name':_0xe044('0x7c'),'type':_0x92cd17['reportType']||(_0x92cd17[_0xe044('0x60')]&&_0x92cd17[_0xe044('0x60')][0x0]?_0x92cd17[_0xe044('0x60')][0x0]['type']:undefined)||null,'value':_0x92cd17[_0xe044('0x7c')]||(_0x92cd17['attrs']&&_0x92cd17[_0xe044('0x60')][0x0]?_0x92cd17[_0xe044('0x60')][0x0][_0xe044('0x61')]:undefined)||null},{'name':_0xe044('0x7d'),'value':_0x92cd17[_0xe044('0x7d')]||(_0x92cd17['attrs']&&_0x92cd17[_0xe044('0x60')][0x1]?_0x92cd17[_0xe044('0x60')][0x1][_0xe044('0x61')]:undefined)||0x0}];default:return[];}}catch(_0x4df6bb){logger[_0xe044('0x31')](_0xe044('0x7e'),JSON[_0xe044('0x7f')](_0x4df6bb));return[];}}exports[_0xe044('0x80')]=function(_0x24c55d,_0x4a582d,_0x42a44f){if(_0x24c55d[_0xe044('0x51')]['id']){delete _0x24c55d[_0xe044('0x51')]['id'];}return db['Dashboard'][_0xe044('0x4f')]({'where':{'id':_0x24c55d[_0xe044('0x5d')]['id']}})[_0xe044('0x2e')](handleEntityNotFound(_0x4a582d,null))[_0xe044('0x2e')](function(_0x806421){if(_0x806421){_0x24c55d[_0xe044('0x51')][_0xe044('0x81')]=_0x806421['id'];_0x24c55d['body'][_0xe044('0x60')]=widgetAttributes(_0x24c55d[_0xe044('0x51')]);return db[_0xe044('0x82')][_0xe044('0x50')](_0x24c55d[_0xe044('0x51')]);}})['then'](respondWithResult(_0x4a582d,null))[_0xe044('0x4a')](handleError(_0x4a582d,null));};exports[_0xe044('0x83')]=function(_0x59b349,_0x359b26,_0x5f5c8c){var _0x33dc04={};var _0x1e665e={};var _0x1cd0af;var _0xac7e2a;return db[_0xe044('0x34')][_0xe044('0x84')]({'where':{'id':_0x59b349[_0xe044('0x5d')]['id']}})[_0xe044('0x2e')](handleEntityNotFound(_0x359b26,null))[_0xe044('0x2e')](function(_0x3a96f6){if(_0x3a96f6){_0x1cd0af=_0x3a96f6;_0x1e665e[_0xe044('0x38')]=_[_0xe044('0x4c')](db[_0xe044('0x82')]['rawAttributes']);_0x1e665e[_0xe044('0x3c')]=_[_0xe044('0x4c')](_0x59b349[_0xe044('0x3c')]);_0x1e665e[_0xe044('0x3a')]=_['intersection'](_0x1e665e[_0xe044('0x38')],_0x1e665e[_0xe044('0x3c')]);_0x33dc04[_0xe044('0x3d')]=_['intersection'](_0x1e665e['model'],qs['fields'](_0x59b349[_0xe044('0x3c')]['fields']));_0x33dc04[_0xe044('0x3d')]=_0x33dc04[_0xe044('0x3d')][_0xe044('0x4d')]?_0x33dc04[_0xe044('0x3d')]:_0x1e665e[_0xe044('0x38')];_0x33dc04[_0xe044('0x40')]=qs[_0xe044('0x85')](_0x59b349[_0xe044('0x3c')][_0xe044('0x85')]);_0x33dc04[_0xe044('0x41')]=qs[_0xe044('0x3a')](_[_0xe044('0x42')](_0x59b349[_0xe044('0x3c')],_0x1e665e[_0xe044('0x3a')]));if(_0x59b349[_0xe044('0x3c')][_0xe044('0x43')]){_0x33dc04[_0xe044('0x41')]=_[_0xe044('0x45')](_0x33dc04[_0xe044('0x41')],{'$or':_[_0xe044('0x39')](_0x33dc04['attributes'],function(_0x59f7c1){var _0x4665f6={};_0x4665f6[_0x59f7c1]={'$like':'%'+_0x59b349['query'][_0xe044('0x43')]+'%'};return _0x4665f6;})});}_0x33dc04=_[_0xe044('0x45')]({},_0x33dc04,_0x59b349[_0xe044('0x4e')]);return _0x1cd0af['getItems'](_0x33dc04);}})[_0xe044('0x2e')](function(_0x126223){if(_0x126223){_0xac7e2a=_0x126223[_0xe044('0x4d')];if(!_0x59b349['query']['hasOwnProperty'](_0xe044('0x86'))){_0x33dc04['limit']=qs['limit'](_0x59b349[_0xe044('0x3c')]['limit']);_0x33dc04[_0xe044('0x25')]=qs[_0xe044('0x25')](_0x59b349['query']['offset']);}return _0x1cd0af[_0xe044('0x83')](_0x33dc04);}})[_0xe044('0x2e')](function(_0x5c1782){if(_0x5c1782){return _0x5c1782?{'count':_0xac7e2a,'rows':_0x5c1782}:null;}})[_0xe044('0x2e')](respondWithResult(_0x359b26,null))[_0xe044('0x4a')](handleError(_0x359b26,null));};