338b4bb7a66b47265e72f7918adba2e47793ce45
[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 _0x7515=['attrVoiceQueues','attrChannel','voice','attrEmailAccounts','attrSmsAccounts','attrOpenchannelAccounts','attrWhatsappAccounts','attrChatWebsites','multibar-chart','pie-chart','attrSerie1','attrSerie2','attrSerie3','attrFaxAccounts','web-report','attrReport','attrRefresh','widgetAttributes:\x20%s','stringify','DashboardId','DashboardItem','getItems','findOne','hasOwnProperty','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','socket.io-emitter','./dashboard.socket','register','status','limit','undefined','count','offset','set','json','apply','reject','update','then','destroy','CustomDashboards','UserProfileResource','end','sendStatus','error','name','send','index','Dashboard','type','model','map','query','keys','filters','intersection','attributes','fields','nolimit','order','sort','where','pick','filter','merge','includeAll','include','show','params','length','options','find','catch','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','rawAttributes','omit','createdAt','UserProfileSection','attrs','value','https://','custom','attrPath','clock','attrHourFormat','HH:mm:ss','attrTimezone','0.00','attrFontSize','counter','attrMetric','total'];(function(_0x1526e1,_0x5ed5a5){var _0x249a1e=function(_0x4a7c12){while(--_0x4a7c12){_0x1526e1['push'](_0x1526e1['shift']());}};_0x249a1e(++_0x5ed5a5);}(_0x7515,0x19b));var _0x5751=function(_0x2f26a2,_0x3debdf){_0x2f26a2=_0x2f26a2-0x0;var _0x42e320=_0x7515[_0x2f26a2];return _0x42e320;};'use strict';var emlformat=require(_0x5751('0x0'));var rimraf=require(_0x5751('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x5751('0x2'));var rp=require(_0x5751('0x3'));var moment=require('moment');var BPromise=require(_0x5751('0x4'));var Mustache=require(_0x5751('0x5'));var util=require('util');var path=require(_0x5751('0x6'));var sox=require(_0x5751('0x7'));var csv=require(_0x5751('0x8'));var ejs=require(_0x5751('0x9'));var fs=require('fs');var fs_extra=require(_0x5751('0xa'));var _=require(_0x5751('0xb'));var squel=require(_0x5751('0xc'));var crypto=require(_0x5751('0xd'));var jsforce=require(_0x5751('0xe'));var deskjs=require(_0x5751('0xf'));var toCsv=require(_0x5751('0x8'));var querystring=require(_0x5751('0x10'));var Papa=require(_0x5751('0x11'));var Redis=require(_0x5751('0x12'));var authService=require(_0x5751('0x13'));var qs=require(_0x5751('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x5751('0x15'))(_0x5751('0x16'));var utils=require(_0x5751('0x17'));var config=require(_0x5751('0x18'));var licenseUtil=require(_0x5751('0x19'));var db=require(_0x5751('0x1a'))['db'];config[_0x5751('0x1b')]=_[_0x5751('0x1c')](config[_0x5751('0x1b')],{'host':'localhost','port':0x18eb});var socket=require(_0x5751('0x1d'))(new Redis(config[_0x5751('0x1b')]));require(_0x5751('0x1e'))[_0x5751('0x1f')](socket);function respondWithStatusCode(_0x23d3ce,_0x5b7417){_0x5b7417=_0x5b7417||0xcc;return function(_0x199594){if(_0x199594){return _0x23d3ce['sendStatus'](_0x5b7417);}return _0x23d3ce[_0x5751('0x20')](_0x5b7417)['end']();};}function respondWithResult(_0x8591d7,_0x294527){_0x294527=_0x294527||0xc8;return function(_0x1f526d){if(_0x1f526d){return _0x8591d7[_0x5751('0x20')](_0x294527)['json'](_0x1f526d);}};}function respondWithFilteredResult(_0x11451f,_0x416e5c){return function(_0x73905e){if(_0x73905e){var _0x2501ae=typeof _0x416e5c['offset']==='undefined'&&typeof _0x416e5c[_0x5751('0x21')]===_0x5751('0x22');var _0x10058d=_0x73905e[_0x5751('0x23')];var _0x3434d1=_0x2501ae?0x0:_0x416e5c[_0x5751('0x24')];var _0x2b7e67=_0x2501ae?_0x73905e['count']:_0x416e5c[_0x5751('0x24')]+_0x416e5c['limit'];var _0x355178;if(_0x2b7e67>=_0x10058d){_0x2b7e67=_0x10058d;_0x355178=0xc8;}else{_0x355178=0xce;}_0x11451f[_0x5751('0x20')](_0x355178);return _0x11451f[_0x5751('0x25')]('Content-Range',_0x3434d1+'-'+_0x2b7e67+'/'+_0x10058d)[_0x5751('0x26')](_0x73905e);}return null;};}function patchUpdates(_0x1ee31f){return function(_0x38afdd){try{jsonpatch[_0x5751('0x27')](_0x38afdd,_0x1ee31f,!![]);}catch(_0x20673f){return BPromise[_0x5751('0x28')](_0x20673f);}return _0x38afdd['save']();};}function saveUpdates(_0x5588f9,_0x3bf191){return function(_0x350b86){if(_0x350b86){return _0x350b86[_0x5751('0x29')](_0x5588f9)[_0x5751('0x2a')](function(_0x450e2c){return _0x450e2c;});}return null;};}function removeEntity(_0x492a01,_0xcb4070){return function(_0x28c9b5){if(_0x28c9b5){return _0x28c9b5[_0x5751('0x2b')]()[_0x5751('0x2a')](function(){var _0x37b1bb=_0x28c9b5['get']({'plain':!![]});var _0x4d6500=_0x5751('0x2c');return db[_0x5751('0x2d')][_0x5751('0x2b')]({'where':{'type':_0x4d6500,'resourceId':_0x37b1bb['id']}})[_0x5751('0x2a')](function(){return _0x28c9b5;});})[_0x5751('0x2a')](function(){_0x492a01[_0x5751('0x20')](0xcc)[_0x5751('0x2e')]();});}};}function handleEntityNotFound(_0x514039,_0x4ebafa){return function(_0x1f27d9){if(!_0x1f27d9){_0x514039[_0x5751('0x2f')](0x194);}return _0x1f27d9;};}function handleError(_0x2e6e97,_0x30072c){_0x30072c=_0x30072c||0x1f4;return function(_0x1d9731){logger[_0x5751('0x30')](_0x1d9731['stack']);if(_0x1d9731[_0x5751('0x31')]){delete _0x1d9731[_0x5751('0x31')];}_0x2e6e97[_0x5751('0x20')](_0x30072c)[_0x5751('0x32')](_0x1d9731);};}exports[_0x5751('0x33')]=function(_0x11727a,_0x48276c){var _0x50a2f9={},_0x9f1275={},_0x12b2a5={'count':0x0,'rows':[]};var _0x3fe483=_['map'](db[_0x5751('0x34')]['rawAttributes'],function(_0x5d1e55){return{'name':_0x5d1e55['fieldName'],'type':_0x5d1e55[_0x5751('0x35')]['key']};});_0x9f1275[_0x5751('0x36')]=_[_0x5751('0x37')](_0x3fe483,'name');_0x9f1275[_0x5751('0x38')]=_[_0x5751('0x39')](_0x11727a[_0x5751('0x38')]);_0x9f1275[_0x5751('0x3a')]=_[_0x5751('0x3b')](_0x9f1275[_0x5751('0x36')],_0x9f1275[_0x5751('0x38')]);_0x50a2f9[_0x5751('0x3c')]=_['intersection'](_0x9f1275[_0x5751('0x36')],qs[_0x5751('0x3d')](_0x11727a[_0x5751('0x38')][_0x5751('0x3d')]));_0x50a2f9['attributes']=_0x50a2f9['attributes']['length']?_0x50a2f9[_0x5751('0x3c')]:_0x9f1275['model'];if(!_0x11727a[_0x5751('0x38')]['hasOwnProperty'](_0x5751('0x3e'))){_0x50a2f9[_0x5751('0x21')]=qs[_0x5751('0x21')](_0x11727a['query']['limit']);_0x50a2f9[_0x5751('0x24')]=qs[_0x5751('0x24')](_0x11727a[_0x5751('0x38')][_0x5751('0x24')]);}_0x50a2f9[_0x5751('0x3f')]=qs[_0x5751('0x40')](_0x11727a[_0x5751('0x38')][_0x5751('0x40')]);_0x50a2f9[_0x5751('0x41')]=qs[_0x5751('0x3a')](_[_0x5751('0x42')](_0x11727a[_0x5751('0x38')],_0x9f1275['filters']),_0x3fe483);if(_0x11727a['query'][_0x5751('0x43')]){_0x50a2f9[_0x5751('0x41')]=_[_0x5751('0x44')](_0x50a2f9[_0x5751('0x41')],{'$or':_['map'](_0x3fe483,function(_0x5158fc){if(_0x5158fc[_0x5751('0x35')]!=='VIRTUAL'){var _0x193d4b={};_0x193d4b[_0x5158fc['name']]={'$like':'%'+_0x11727a[_0x5751('0x38')][_0x5751('0x43')]+'%'};return _0x193d4b;}})});}_0x50a2f9=_['merge']({},_0x50a2f9,_0x11727a['options']);var _0x47b5b2={'where':_0x50a2f9['where']};return db[_0x5751('0x34')]['count'](_0x47b5b2)[_0x5751('0x2a')](function(_0x30cb38){_0x12b2a5[_0x5751('0x23')]=_0x30cb38;if(_0x11727a[_0x5751('0x38')][_0x5751('0x45')]){_0x50a2f9[_0x5751('0x46')]=[{'all':!![]}];}return db['Dashboard']['findAll'](_0x50a2f9);})[_0x5751('0x2a')](function(_0x87aa5b){_0x12b2a5['rows']=_0x87aa5b;return _0x12b2a5;})['then'](respondWithFilteredResult(_0x48276c,_0x50a2f9))['catch'](handleError(_0x48276c,null));};exports[_0x5751('0x47')]=function(_0x37e627,_0x33f3bb){var _0x2e40ab={'raw':![],'where':{'id':_0x37e627[_0x5751('0x48')]['id']}},_0x536fda={};_0x536fda['model']=_[_0x5751('0x39')](db['Dashboard']['rawAttributes']);_0x536fda['query']=_[_0x5751('0x39')](_0x37e627['query']);_0x536fda[_0x5751('0x3a')]=_[_0x5751('0x3b')](_0x536fda[_0x5751('0x36')],_0x536fda[_0x5751('0x38')]);_0x2e40ab[_0x5751('0x3c')]=_[_0x5751('0x3b')](_0x536fda[_0x5751('0x36')],qs[_0x5751('0x3d')](_0x37e627[_0x5751('0x38')]['fields']));_0x2e40ab['attributes']=_0x2e40ab['attributes'][_0x5751('0x49')]?_0x2e40ab[_0x5751('0x3c')]:_0x536fda[_0x5751('0x36')];if(_0x37e627[_0x5751('0x38')][_0x5751('0x45')]){_0x2e40ab[_0x5751('0x46')]=[{'all':!![]}];}_0x2e40ab=_[_0x5751('0x44')]({},_0x2e40ab,_0x37e627[_0x5751('0x4a')]);return db[_0x5751('0x34')][_0x5751('0x4b')](_0x2e40ab)['then'](handleEntityNotFound(_0x33f3bb,null))[_0x5751('0x2a')](respondWithResult(_0x33f3bb,null))[_0x5751('0x4c')](handleError(_0x33f3bb,null));};exports[_0x5751('0x4d')]=function(_0x3eed64,_0x12ed1c){return db[_0x5751('0x34')]['create'](_0x3eed64[_0x5751('0x4e')],{})[_0x5751('0x2a')](function(_0x186374){var _0x5b7d89=_0x3eed64[_0x5751('0x4f')][_0x5751('0x50')]({'plain':!![]});if(!_0x5b7d89)throw new Error(_0x5751('0x51'));if(_0x5b7d89[_0x5751('0x52')]===_0x5751('0x4f')){var _0x36cf17=_0x186374[_0x5751('0x50')]({'plain':!![]});var _0x5bdcb2=_0x5751('0x2c');return db['UserProfileSection']['find']({'where':{'name':_0x5bdcb2,'userProfileId':_0x5b7d89[_0x5751('0x53')]},'raw':!![]})[_0x5751('0x2a')](function(_0x9b63c7){if(_0x9b63c7&&_0x9b63c7[_0x5751('0x54')]===0x0){return db[_0x5751('0x2d')]['create']({'name':_0x36cf17['name'],'resourceId':_0x36cf17['id'],'type':_0x9b63c7[_0x5751('0x31')],'sectionId':_0x9b63c7['id']},{})[_0x5751('0x2a')](function(){return _0x186374;});}else{return _0x186374;}})[_0x5751('0x4c')](function(_0x5ed8a6){logger['error'](_0x5751('0x55'),_0x5ed8a6);throw _0x5ed8a6;});}return _0x186374;})[_0x5751('0x2a')](respondWithResult(_0x12ed1c,0xc9))['catch'](handleError(_0x12ed1c,null));};exports[_0x5751('0x56')]=function(_0x3ff4a4,_0x2ce3a7){var _0x1607e8={'where':{'id':_0x3ff4a4[_0x5751('0x48')]['id']}},_0x26fd81={};_0x26fd81[_0x5751('0x36')]=_['keys'](db[_0x5751('0x34')][_0x5751('0x57')]);_0x1607e8[_0x5751('0x3c')]=_[_0x5751('0x3b')](_0x26fd81[_0x5751('0x36')],qs['fields'](_0x3ff4a4['query']['fields']));_0x1607e8[_0x5751('0x3c')]=_0x1607e8[_0x5751('0x3c')][_0x5751('0x49')]?_0x1607e8[_0x5751('0x3c')]:_0x26fd81[_0x5751('0x36')];if(_0x3ff4a4[_0x5751('0x38')][_0x5751('0x45')]){_0x1607e8[_0x5751('0x46')]=[{'all':!![]}];}_0x1607e8=_[_0x5751('0x44')]({},_0x1607e8,_0x3ff4a4['options']);return db[_0x5751('0x34')][_0x5751('0x4b')](_0x1607e8)[_0x5751('0x2a')](handleEntityNotFound(_0x2ce3a7,null))[_0x5751('0x2a')](function(_0x3c865b){if(_0x3c865b){var _0x2d94a3=_0x3c865b[_0x5751('0x50')]({'plain':!![]});_0x2d94a3=qs[_0x5751('0x58')](_0x2d94a3,['id',_0x5751('0x59'),'updatedAt']);_0x3ff4a4[_0x5751('0x4e')]=_[_0x5751('0x58')](_0x3ff4a4[_0x5751('0x4e')],['id',_0x5751('0x59'),'updatedAt']);return db['Dashboard'][_0x5751('0x4d')](_[_0x5751('0x44')](_0x2d94a3,_0x3ff4a4[_0x5751('0x4e')]),{'include':_0x3ff4a4[_0x5751('0x38')][_0x5751('0x45')]?[{'all':!![]}]:undefined})[_0x5751('0x2a')](function(_0x33cf90){var _0x4dddcd=_0x3ff4a4[_0x5751('0x4f')][_0x5751('0x50')]({'plain':!![]});if(!_0x4dddcd)throw new Error(_0x5751('0x51'));if(_0x4dddcd[_0x5751('0x52')]===_0x5751('0x4f')){var _0x5484cc=_0x33cf90[_0x5751('0x50')]({'plain':!![]});var _0x2132f8=_0x5751('0x2c');return db[_0x5751('0x5a')][_0x5751('0x4b')]({'where':{'name':_0x2132f8,'userProfileId':_0x4dddcd[_0x5751('0x53')]},'raw':!![]})[_0x5751('0x2a')](function(_0xb6edd8){if(_0xb6edd8&&_0xb6edd8[_0x5751('0x54')]===0x0){return db[_0x5751('0x2d')]['create']({'name':_0x5484cc[_0x5751('0x31')],'resourceId':_0x5484cc['id'],'type':_0xb6edd8['name'],'sectionId':_0xb6edd8['id']},{})[_0x5751('0x2a')](function(){return _0x33cf90;});}else{return _0x33cf90;}})[_0x5751('0x4c')](function(_0x4e754d){logger[_0x5751('0x30')](_0x5751('0x55'),_0x4e754d);throw _0x4e754d;});}return _0x33cf90;});}})[_0x5751('0x2a')](respondWithResult(_0x2ce3a7,0xc9))[_0x5751('0x4c')](handleError(_0x2ce3a7,null));};exports['update']=function(_0x439e3f,_0x5e5434){if(_0x439e3f[_0x5751('0x4e')]['id']){delete _0x439e3f[_0x5751('0x4e')]['id'];}return db['Dashboard'][_0x5751('0x4b')]({'where':{'id':_0x439e3f[_0x5751('0x48')]['id']}})['then'](handleEntityNotFound(_0x5e5434,null))[_0x5751('0x2a')](saveUpdates(_0x439e3f['body'],null))[_0x5751('0x2a')](respondWithResult(_0x5e5434,null))[_0x5751('0x4c')](handleError(_0x5e5434,null));};exports['destroy']=function(_0x372159,_0x57d9a7){return db[_0x5751('0x34')][_0x5751('0x4b')]({'where':{'id':_0x372159[_0x5751('0x48')]['id']}})[_0x5751('0x2a')](handleEntityNotFound(_0x57d9a7,null))[_0x5751('0x2a')](removeEntity(_0x57d9a7,null))['catch'](handleError(_0x57d9a7,null));};function widgetAttributes(_0x168578){try{switch(_0x168578[_0x5751('0x35')]){case'iframe':return[{'name':'attrUrl','value':_0x168578['attrUrl']||(_0x168578['attrs']&&_0x168578[_0x5751('0x5b')][0x0]?_0x168578[_0x5751('0x5b')][0x0][_0x5751('0x5c')]:undefined)||_0x5751('0x5d')}];case _0x5751('0x5e'):return[{'name':_0x5751('0x5f'),'value':_0x168578[_0x5751('0x5f')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x0]?_0x168578['attrs'][0x0][_0x5751('0x5c')]:undefined)||''}];case _0x5751('0x60'):return[{'name':_0x5751('0x61'),'value':_0x168578[_0x5751('0x61')]||(_0x168578['attrs']&&_0x168578['attrs'][0x0]?_0x168578[_0x5751('0x5b')][0x0][_0x5751('0x5c')]:undefined)||_0x5751('0x62')},{'name':'attrTimezone','value':_0x168578[_0x5751('0x63')]||(_0x168578['attrs']&&_0x168578[_0x5751('0x5b')][0x1]?_0x168578['attrs'][0x1][_0x5751('0x5c')]:undefined)||_0x5751('0x64')},{'name':_0x5751('0x65'),'value':_0x168578[_0x5751('0x65')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x2]?_0x168578[_0x5751('0x5b')][0x2][_0x5751('0x5c')]:undefined)||0xc}];case _0x5751('0x66'):return[{'name':'attrMetric','value':_0x168578[_0x5751('0x67')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x0]?_0x168578[_0x5751('0x5b')][0x0]['value']:undefined)||_0x5751('0x68')},{'name':_0x5751('0x69'),'value':_0x168578[_0x5751('0x69')]||(_0x168578[_0x5751('0x5b')]&&_0x168578['attrs'][0x1]?_0x168578[_0x5751('0x5b')][0x1][_0x5751('0x5c')]:undefined)||[]},{'name':'attrFontSize','value':_0x168578['attrFontSize']||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x2]?_0x168578['attrs'][0x2][_0x5751('0x5c')]:undefined)||0x14},{'name':_0x5751('0x6a'),'value':_0x168578['attrChannel']||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x3]?_0x168578[_0x5751('0x5b')][0x3][_0x5751('0x5c')]:undefined)||_0x5751('0x6b')},{'name':_0x5751('0x6c'),'value':_0x168578[_0x5751('0x6c')]||(_0x168578['attrs']&&_0x168578[_0x5751('0x5b')][0x4]?_0x168578[_0x5751('0x5b')][0x4]['value']:undefined)||''},{'name':'attrFaxAccounts','value':_0x168578['attrFaxAccounts']||(_0x168578[_0x5751('0x5b')]&&_0x168578['attrs'][0x5]?_0x168578['attrs'][0x5][_0x5751('0x5c')]:undefined)||''},{'name':_0x5751('0x6d'),'value':_0x168578[_0x5751('0x6d')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x6]?_0x168578[_0x5751('0x5b')][0x6][_0x5751('0x5c')]:undefined)||''},{'name':_0x5751('0x6e'),'value':_0x168578[_0x5751('0x6e')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x7]?_0x168578[_0x5751('0x5b')][0x7][_0x5751('0x5c')]:undefined)||''},{'name':_0x5751('0x6f'),'value':_0x168578['attrWhatsappAccounts']||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x8]?_0x168578[_0x5751('0x5b')][0x8][_0x5751('0x5c')]:undefined)||''},{'name':_0x5751('0x70'),'value':_0x168578[_0x5751('0x70')]||(_0x168578[_0x5751('0x5b')]&&_0x168578['attrs'][0x9]?_0x168578[_0x5751('0x5b')][0x9][_0x5751('0x5c')]:undefined)||''}];case _0x5751('0x71'):case _0x5751('0x72'):return[{'name':_0x5751('0x73'),'value':_0x168578[_0x5751('0x73')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x0]?_0x168578['attrs'][0x0]['value']:undefined)||'total'},{'name':_0x5751('0x74'),'value':_0x168578[_0x5751('0x74')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x1]?_0x168578[_0x5751('0x5b')][0x1][_0x5751('0x5c')]:undefined)||null},{'name':_0x5751('0x75'),'value':_0x168578[_0x5751('0x75')]||(_0x168578['attrs']&&_0x168578[_0x5751('0x5b')][0x2]?_0x168578[_0x5751('0x5b')][0x2][_0x5751('0x5c')]:undefined)||null},{'name':'attrVoiceQueues','value':_0x168578[_0x5751('0x69')]||(_0x168578[_0x5751('0x5b')]&&_0x168578['attrs'][0x3]?_0x168578[_0x5751('0x5b')][0x3][_0x5751('0x5c')]:undefined)||[]},{'name':'attrChannel','value':_0x168578['attrChannel']||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x4]?_0x168578[_0x5751('0x5b')][0x4]['value']:undefined)||_0x5751('0x6b')},{'name':_0x5751('0x6c'),'value':_0x168578[_0x5751('0x6c')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x5]?_0x168578[_0x5751('0x5b')][0x5][_0x5751('0x5c')]:undefined)||''},{'name':_0x5751('0x76'),'value':_0x168578[_0x5751('0x76')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x6]?_0x168578[_0x5751('0x5b')][0x6]['value']:undefined)||''},{'name':_0x5751('0x6d'),'value':_0x168578['attrSmsAccounts']||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x7]?_0x168578['attrs'][0x7][_0x5751('0x5c')]:undefined)||''},{'name':_0x5751('0x6e'),'value':_0x168578['attrOpenchannelAccounts']||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x8]?_0x168578[_0x5751('0x5b')][0x8][_0x5751('0x5c')]:undefined)||''},{'name':'attrWhatsappAccounts','value':_0x168578['attrWhatsappAccounts']||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x9]?_0x168578['attrs'][0x9][_0x5751('0x5c')]:undefined)||''},{'name':_0x5751('0x70'),'value':_0x168578[_0x5751('0x70')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0xa]?_0x168578['attrs'][0xa][_0x5751('0x5c')]:undefined)||''}];case _0x5751('0x77'):return[{'name':_0x5751('0x78'),'type':_0x168578['reportType']||(_0x168578[_0x5751('0x5b')]&&_0x168578['attrs'][0x0]?_0x168578[_0x5751('0x5b')][0x0][_0x5751('0x35')]:undefined)||null,'value':_0x168578[_0x5751('0x78')]||(_0x168578[_0x5751('0x5b')]&&_0x168578[_0x5751('0x5b')][0x0]?_0x168578['attrs'][0x0][_0x5751('0x5c')]:undefined)||null},{'name':_0x5751('0x79'),'value':_0x168578[_0x5751('0x79')]||(_0x168578[_0x5751('0x5b')]&&_0x168578['attrs'][0x1]?_0x168578[_0x5751('0x5b')][0x1]['value']:undefined)||0x0}];default:return[];}}catch(_0x4ffe4e){logger[_0x5751('0x30')](_0x5751('0x7a'),JSON[_0x5751('0x7b')](_0x4ffe4e));return[];}}exports['addItem']=function(_0x12fea7,_0x5941ce,_0x5b0ddf){if(_0x12fea7['body']['id']){delete _0x12fea7[_0x5751('0x4e')]['id'];}return db[_0x5751('0x34')][_0x5751('0x4b')]({'where':{'id':_0x12fea7[_0x5751('0x48')]['id']}})['then'](handleEntityNotFound(_0x5941ce,null))[_0x5751('0x2a')](function(_0x3a737f){if(_0x3a737f){_0x12fea7[_0x5751('0x4e')][_0x5751('0x7c')]=_0x3a737f['id'];_0x12fea7['body']['attrs']=widgetAttributes(_0x12fea7[_0x5751('0x4e')]);return db[_0x5751('0x7d')][_0x5751('0x4d')](_0x12fea7[_0x5751('0x4e')]);}})[_0x5751('0x2a')](respondWithResult(_0x5941ce,null))[_0x5751('0x4c')](handleError(_0x5941ce,null));};exports[_0x5751('0x7e')]=function(_0x3d316b,_0xc27177,_0x29bd80){var _0x4757f4={};var _0x2a9083={};var _0x10eb55;var _0x255a55;return db[_0x5751('0x34')][_0x5751('0x7f')]({'where':{'id':_0x3d316b[_0x5751('0x48')]['id']}})[_0x5751('0x2a')](handleEntityNotFound(_0xc27177,null))[_0x5751('0x2a')](function(_0x5b55ad){if(_0x5b55ad){_0x10eb55=_0x5b55ad;_0x2a9083[_0x5751('0x36')]=_[_0x5751('0x39')](db['DashboardItem'][_0x5751('0x57')]);_0x2a9083[_0x5751('0x38')]=_['keys'](_0x3d316b[_0x5751('0x38')]);_0x2a9083[_0x5751('0x3a')]=_['intersection'](_0x2a9083[_0x5751('0x36')],_0x2a9083[_0x5751('0x38')]);_0x4757f4[_0x5751('0x3c')]=_['intersection'](_0x2a9083[_0x5751('0x36')],qs[_0x5751('0x3d')](_0x3d316b['query'][_0x5751('0x3d')]));_0x4757f4['attributes']=_0x4757f4[_0x5751('0x3c')][_0x5751('0x49')]?_0x4757f4['attributes']:_0x2a9083[_0x5751('0x36')];_0x4757f4[_0x5751('0x3f')]=qs[_0x5751('0x40')](_0x3d316b[_0x5751('0x38')][_0x5751('0x40')]);_0x4757f4[_0x5751('0x41')]=qs[_0x5751('0x3a')](_['pick'](_0x3d316b[_0x5751('0x38')],_0x2a9083['filters']));if(_0x3d316b[_0x5751('0x38')][_0x5751('0x43')]){_0x4757f4['where']=_[_0x5751('0x44')](_0x4757f4[_0x5751('0x41')],{'$or':_[_0x5751('0x37')](_0x4757f4[_0x5751('0x3c')],function(_0x463c0c){var _0x5dd7b4={};_0x5dd7b4[_0x463c0c]={'$like':'%'+_0x3d316b[_0x5751('0x38')][_0x5751('0x43')]+'%'};return _0x5dd7b4;})});}_0x4757f4=_[_0x5751('0x44')]({},_0x4757f4,_0x3d316b[_0x5751('0x4a')]);return _0x10eb55[_0x5751('0x7e')](_0x4757f4);}})[_0x5751('0x2a')](function(_0x3c49b0){if(_0x3c49b0){_0x255a55=_0x3c49b0[_0x5751('0x49')];if(!_0x3d316b[_0x5751('0x38')][_0x5751('0x80')](_0x5751('0x3e'))){_0x4757f4[_0x5751('0x21')]=qs[_0x5751('0x21')](_0x3d316b[_0x5751('0x38')]['limit']);_0x4757f4[_0x5751('0x24')]=qs[_0x5751('0x24')](_0x3d316b[_0x5751('0x38')][_0x5751('0x24')]);}return _0x10eb55[_0x5751('0x7e')](_0x4757f4);}})[_0x5751('0x2a')](function(_0x3285f7){if(_0x3285f7){return _0x3285f7?{'count':_0x255a55,'rows':_0x3285f7}:null;}})[_0x5751('0x2a')](respondWithResult(_0xc27177,null))[_0x5751('0x4c')](handleError(_0xc27177,null));};