07aef4d89ba97fe95fe804e75a4cc8c1ad7fb85e
[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 _0x49eb=['attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','includeAll','include','rows','catch','show','params','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','user','destroy','iframe','attrUrl','attrs','value','https://','custom','attrPath','clock','attrHourFormat','0.00','attrFontSize','attrMetric','total','attrVoiceQueues','attrChannel','voice','attrEmailAccounts','attrSmsAccounts','attrOpenchannelAccounts','attrWhatsappAccounts','attrChatWebsites','multibar-chart','attrSerie1','attrSerie2','attrSerie3','attrFaxAccounts','web-report','attrReport','reportType','attrRefresh','widgetAttributes:\x20%s','stringify','addItem','DashboardItem','findOne','getItems','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/utils','../../config/license/util','redis','defaults','localhost','./dashboard.socket','sendStatus','end','status','offset','count','limit','set','Content-Range','json','apply','reject','save','update','then','get','CustomDashboards','UserProfileResource','error','stack','name','Dashboard','rawAttributes','fieldName','type','key','model','map','keys','query','filters','intersection','fields'];(function(_0x648163,_0x241576){var _0x199d4d=function(_0x23055d){while(--_0x23055d){_0x648163['push'](_0x648163['shift']());}};_0x199d4d(++_0x241576);}(_0x49eb,0x136));var _0xb49e=function(_0x317db3,_0xef2070){_0x317db3=_0x317db3-0x0;var _0x593f60=_0x49eb[_0x317db3];return _0x593f60;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xb49e('0x0'));var zipdir=require(_0xb49e('0x1'));var jsonpatch=require(_0xb49e('0x2'));var rp=require(_0xb49e('0x3'));var moment=require('moment');var BPromise=require(_0xb49e('0x4'));var Mustache=require(_0xb49e('0x5'));var util=require(_0xb49e('0x6'));var path=require(_0xb49e('0x7'));var sox=require(_0xb49e('0x8'));var csv=require(_0xb49e('0x9'));var ejs=require(_0xb49e('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require('squel');var crypto=require(_0xb49e('0xb'));var jsforce=require(_0xb49e('0xc'));var deskjs=require(_0xb49e('0xd'));var toCsv=require(_0xb49e('0x9'));var querystring=require(_0xb49e('0xe'));var Papa=require(_0xb49e('0xf'));var Redis=require(_0xb49e('0x10'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xb49e('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')('api');var utils=require(_0xb49e('0x12'));var config=require('../../config/environment');var licenseUtil=require(_0xb49e('0x13'));var db=require('../../mysqldb')['db'];config[_0xb49e('0x14')]=_[_0xb49e('0x15')](config['redis'],{'host':_0xb49e('0x16'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xb49e('0x14')]));require(_0xb49e('0x17'))['register'](socket);function respondWithStatusCode(_0x44b0f7,_0x2f236b){_0x2f236b=_0x2f236b||0xcc;return function(_0x408276){if(_0x408276){return _0x44b0f7[_0xb49e('0x18')](_0x2f236b);}return _0x44b0f7['status'](_0x2f236b)[_0xb49e('0x19')]();};}function respondWithResult(_0x2ce41b,_0x52b337){_0x52b337=_0x52b337||0xc8;return function(_0x2fe530){if(_0x2fe530){return _0x2ce41b[_0xb49e('0x1a')](_0x52b337)['json'](_0x2fe530);}};}function respondWithFilteredResult(_0x10ca89,_0x27e40b){return function(_0x10b860){if(_0x10b860){var _0x3224e5=typeof _0x27e40b[_0xb49e('0x1b')]==='undefined'&&typeof _0x27e40b['limit']==='undefined';var _0x5cb83c=_0x10b860['count'];var _0x363671=_0x3224e5?0x0:_0x27e40b[_0xb49e('0x1b')];var _0x51051f=_0x3224e5?_0x10b860[_0xb49e('0x1c')]:_0x27e40b[_0xb49e('0x1b')]+_0x27e40b[_0xb49e('0x1d')];var _0x3bc626;if(_0x51051f>=_0x5cb83c){_0x51051f=_0x5cb83c;_0x3bc626=0xc8;}else{_0x3bc626=0xce;}_0x10ca89[_0xb49e('0x1a')](_0x3bc626);return _0x10ca89[_0xb49e('0x1e')](_0xb49e('0x1f'),_0x363671+'-'+_0x51051f+'/'+_0x5cb83c)[_0xb49e('0x20')](_0x10b860);}return null;};}function patchUpdates(_0x31e059){return function(_0x2eb8fa){try{jsonpatch[_0xb49e('0x21')](_0x2eb8fa,_0x31e059,!![]);}catch(_0x3ed729){return BPromise[_0xb49e('0x22')](_0x3ed729);}return _0x2eb8fa[_0xb49e('0x23')]();};}function saveUpdates(_0x122347,_0x180ba6){return function(_0x3cf825){if(_0x3cf825){return _0x3cf825[_0xb49e('0x24')](_0x122347)['then'](function(_0x517da7){return _0x517da7;});}return null;};}function removeEntity(_0x50306e,_0x50c5dc){return function(_0x2ff0ac){if(_0x2ff0ac){return _0x2ff0ac['destroy']()[_0xb49e('0x25')](function(){var _0x27f8e0=_0x2ff0ac[_0xb49e('0x26')]({'plain':!![]});var _0x15027f=_0xb49e('0x27');return db[_0xb49e('0x28')]['destroy']({'where':{'type':_0x15027f,'resourceId':_0x27f8e0['id']}})[_0xb49e('0x25')](function(){return _0x2ff0ac;});})[_0xb49e('0x25')](function(){_0x50306e[_0xb49e('0x1a')](0xcc)[_0xb49e('0x19')]();});}};}function handleEntityNotFound(_0x5c2228,_0x310f9d){return function(_0x45a9f3){if(!_0x45a9f3){_0x5c2228[_0xb49e('0x18')](0x194);}return _0x45a9f3;};}function handleError(_0x13ac58,_0x582c29){_0x582c29=_0x582c29||0x1f4;return function(_0x54ef88){logger[_0xb49e('0x29')](_0x54ef88[_0xb49e('0x2a')]);if(_0x54ef88[_0xb49e('0x2b')]){delete _0x54ef88[_0xb49e('0x2b')];}_0x13ac58['status'](_0x582c29)['send'](_0x54ef88);};}exports['index']=function(_0x1d86c9,_0x22a0e1){var _0x58c71e={},_0x2591ad={},_0x7c760b={'count':0x0,'rows':[]};var _0x4202dd=_['map'](db[_0xb49e('0x2c')][_0xb49e('0x2d')],function(_0x4fd55a){return{'name':_0x4fd55a[_0xb49e('0x2e')],'type':_0x4fd55a[_0xb49e('0x2f')][_0xb49e('0x30')]};});_0x2591ad[_0xb49e('0x31')]=_[_0xb49e('0x32')](_0x4202dd,'name');_0x2591ad['query']=_[_0xb49e('0x33')](_0x1d86c9[_0xb49e('0x34')]);_0x2591ad[_0xb49e('0x35')]=_[_0xb49e('0x36')](_0x2591ad[_0xb49e('0x31')],_0x2591ad['query']);_0x58c71e['attributes']=_['intersection'](_0x2591ad[_0xb49e('0x31')],qs[_0xb49e('0x37')](_0x1d86c9[_0xb49e('0x34')][_0xb49e('0x37')]));_0x58c71e[_0xb49e('0x38')]=_0x58c71e['attributes'][_0xb49e('0x39')]?_0x58c71e[_0xb49e('0x38')]:_0x2591ad[_0xb49e('0x31')];if(!_0x1d86c9[_0xb49e('0x34')][_0xb49e('0x3a')](_0xb49e('0x3b'))){_0x58c71e[_0xb49e('0x1d')]=qs[_0xb49e('0x1d')](_0x1d86c9[_0xb49e('0x34')]['limit']);_0x58c71e[_0xb49e('0x1b')]=qs[_0xb49e('0x1b')](_0x1d86c9['query']['offset']);}_0x58c71e[_0xb49e('0x3c')]=qs[_0xb49e('0x3d')](_0x1d86c9['query'][_0xb49e('0x3d')]);_0x58c71e[_0xb49e('0x3e')]=qs['filters'](_[_0xb49e('0x3f')](_0x1d86c9[_0xb49e('0x34')],_0x2591ad[_0xb49e('0x35')]),_0x4202dd);if(_0x1d86c9['query'][_0xb49e('0x40')]){_0x58c71e[_0xb49e('0x3e')]=_[_0xb49e('0x41')](_0x58c71e[_0xb49e('0x3e')],{'$or':_['map'](_0x4202dd,function(_0x5bbc4c){if(_0x5bbc4c['type']!=='VIRTUAL'){var _0x372dc7={};_0x372dc7[_0x5bbc4c[_0xb49e('0x2b')]]={'$like':'%'+_0x1d86c9['query']['filter']+'%'};return _0x372dc7;}})});}_0x58c71e=_[_0xb49e('0x41')]({},_0x58c71e,_0x1d86c9[_0xb49e('0x42')]);var _0x58cb18={'where':_0x58c71e['where']};return db[_0xb49e('0x2c')][_0xb49e('0x1c')](_0x58cb18)[_0xb49e('0x25')](function(_0x8c9177){_0x7c760b['count']=_0x8c9177;if(_0x1d86c9['query'][_0xb49e('0x43')]){_0x58c71e[_0xb49e('0x44')]=[{'all':!![]}];}return db[_0xb49e('0x2c')]['findAll'](_0x58c71e);})[_0xb49e('0x25')](function(_0x1166e0){_0x7c760b[_0xb49e('0x45')]=_0x1166e0;return _0x7c760b;})[_0xb49e('0x25')](respondWithFilteredResult(_0x22a0e1,_0x58c71e))[_0xb49e('0x46')](handleError(_0x22a0e1,null));};exports[_0xb49e('0x47')]=function(_0x3dcf1d,_0x242529){var _0x5b5ded={'raw':![],'where':{'id':_0x3dcf1d[_0xb49e('0x48')]['id']}},_0x463a0a={};_0x463a0a[_0xb49e('0x31')]=_['keys'](db[_0xb49e('0x2c')][_0xb49e('0x2d')]);_0x463a0a[_0xb49e('0x34')]=_['keys'](_0x3dcf1d[_0xb49e('0x34')]);_0x463a0a[_0xb49e('0x35')]=_[_0xb49e('0x36')](_0x463a0a[_0xb49e('0x31')],_0x463a0a[_0xb49e('0x34')]);_0x5b5ded[_0xb49e('0x38')]=_[_0xb49e('0x36')](_0x463a0a[_0xb49e('0x31')],qs[_0xb49e('0x37')](_0x3dcf1d[_0xb49e('0x34')][_0xb49e('0x37')]));_0x5b5ded['attributes']=_0x5b5ded[_0xb49e('0x38')][_0xb49e('0x39')]?_0x5b5ded['attributes']:_0x463a0a[_0xb49e('0x31')];if(_0x3dcf1d[_0xb49e('0x34')][_0xb49e('0x43')]){_0x5b5ded[_0xb49e('0x44')]=[{'all':!![]}];}_0x5b5ded=_[_0xb49e('0x41')]({},_0x5b5ded,_0x3dcf1d[_0xb49e('0x42')]);return db[_0xb49e('0x2c')][_0xb49e('0x49')](_0x5b5ded)[_0xb49e('0x25')](handleEntityNotFound(_0x242529,null))['then'](respondWithResult(_0x242529,null))['catch'](handleError(_0x242529,null));};exports[_0xb49e('0x4a')]=function(_0x2803ad,_0x1172e2){return db[_0xb49e('0x2c')][_0xb49e('0x4a')](_0x2803ad[_0xb49e('0x4b')],{})['then'](function(_0x449f90){var _0x2f9e02=_0x2803ad['user'][_0xb49e('0x26')]({'plain':!![]});if(!_0x2f9e02)throw new Error(_0xb49e('0x4c'));if(_0x2f9e02['role']==='user'){var _0x3ee14d=_0x449f90[_0xb49e('0x26')]({'plain':!![]});var _0xf50d3d=_0xb49e('0x27');return db[_0xb49e('0x4d')][_0xb49e('0x49')]({'where':{'name':_0xf50d3d,'userProfileId':_0x2f9e02[_0xb49e('0x4e')]},'raw':!![]})[_0xb49e('0x25')](function(_0x2e4c10){if(_0x2e4c10&&_0x2e4c10[_0xb49e('0x4f')]===0x0){return db[_0xb49e('0x28')]['create']({'name':_0x3ee14d[_0xb49e('0x2b')],'resourceId':_0x3ee14d['id'],'type':_0x2e4c10[_0xb49e('0x2b')],'sectionId':_0x2e4c10['id']},{})[_0xb49e('0x25')](function(){return _0x449f90;});}else{return _0x449f90;}})['catch'](function(_0x51b1a6){logger['error'](_0xb49e('0x50'),_0x51b1a6);throw _0x51b1a6;});}return _0x449f90;})[_0xb49e('0x25')](respondWithResult(_0x1172e2,0xc9))[_0xb49e('0x46')](handleError(_0x1172e2,null));};exports[_0xb49e('0x51')]=function(_0xa4f852,_0x41f907){var _0x42d7b3={'where':{'id':_0xa4f852[_0xb49e('0x48')]['id']}},_0x5219dd={};_0x5219dd['model']=_[_0xb49e('0x33')](db[_0xb49e('0x2c')][_0xb49e('0x2d')]);_0x42d7b3[_0xb49e('0x38')]=_[_0xb49e('0x36')](_0x5219dd[_0xb49e('0x31')],qs[_0xb49e('0x37')](_0xa4f852[_0xb49e('0x34')]['fields']));_0x42d7b3[_0xb49e('0x38')]=_0x42d7b3[_0xb49e('0x38')][_0xb49e('0x39')]?_0x42d7b3['attributes']:_0x5219dd[_0xb49e('0x31')];if(_0xa4f852[_0xb49e('0x34')][_0xb49e('0x43')]){_0x42d7b3[_0xb49e('0x44')]=[{'all':!![]}];}_0x42d7b3=_[_0xb49e('0x41')]({},_0x42d7b3,_0xa4f852[_0xb49e('0x42')]);return db[_0xb49e('0x2c')][_0xb49e('0x49')](_0x42d7b3)[_0xb49e('0x25')](handleEntityNotFound(_0x41f907,null))[_0xb49e('0x25')](function(_0x514795){if(_0x514795){var _0x5d7fc1=_0x514795[_0xb49e('0x26')]({'plain':!![]});_0x5d7fc1=qs[_0xb49e('0x52')](_0x5d7fc1,['id',_0xb49e('0x53'),'updatedAt']);_0xa4f852[_0xb49e('0x4b')]=_[_0xb49e('0x52')](_0xa4f852[_0xb49e('0x4b')],['id',_0xb49e('0x53'),'updatedAt']);return db[_0xb49e('0x2c')][_0xb49e('0x4a')](_[_0xb49e('0x41')](_0x5d7fc1,_0xa4f852[_0xb49e('0x4b')]),{'include':_0xa4f852[_0xb49e('0x34')][_0xb49e('0x43')]?[{'all':!![]}]:undefined})[_0xb49e('0x25')](function(_0x3e8b1e){var _0x4ea033=_0xa4f852[_0xb49e('0x54')][_0xb49e('0x26')]({'plain':!![]});if(!_0x4ea033)throw new Error(_0xb49e('0x4c'));if(_0x4ea033['role']===_0xb49e('0x54')){var _0x47ff5c=_0x3e8b1e[_0xb49e('0x26')]({'plain':!![]});var _0x1f7363='CustomDashboards';return db['UserProfileSection'][_0xb49e('0x49')]({'where':{'name':_0x1f7363,'userProfileId':_0x4ea033[_0xb49e('0x4e')]},'raw':!![]})[_0xb49e('0x25')](function(_0x29e74a){if(_0x29e74a&&_0x29e74a[_0xb49e('0x4f')]===0x0){return db[_0xb49e('0x28')][_0xb49e('0x4a')]({'name':_0x47ff5c['name'],'resourceId':_0x47ff5c['id'],'type':_0x29e74a[_0xb49e('0x2b')],'sectionId':_0x29e74a['id']},{})[_0xb49e('0x25')](function(){return _0x3e8b1e;});}else{return _0x3e8b1e;}})['catch'](function(_0x1afecd){logger[_0xb49e('0x29')](_0xb49e('0x50'),_0x1afecd);throw _0x1afecd;});}return _0x3e8b1e;});}})['then'](respondWithResult(_0x41f907,0xc9))[_0xb49e('0x46')](handleError(_0x41f907,null));};exports[_0xb49e('0x24')]=function(_0x3b40e9,_0xf96efe){if(_0x3b40e9[_0xb49e('0x4b')]['id']){delete _0x3b40e9[_0xb49e('0x4b')]['id'];}return db['Dashboard']['find']({'where':{'id':_0x3b40e9[_0xb49e('0x48')]['id']}})[_0xb49e('0x25')](handleEntityNotFound(_0xf96efe,null))[_0xb49e('0x25')](saveUpdates(_0x3b40e9[_0xb49e('0x4b')],null))['then'](respondWithResult(_0xf96efe,null))['catch'](handleError(_0xf96efe,null));};exports[_0xb49e('0x55')]=function(_0x4fb79b,_0x178c92){return db[_0xb49e('0x2c')]['find']({'where':{'id':_0x4fb79b['params']['id']}})['then'](handleEntityNotFound(_0x178c92,null))[_0xb49e('0x25')](removeEntity(_0x178c92,null))[_0xb49e('0x46')](handleError(_0x178c92,null));};function widgetAttributes(_0x1e4774){try{switch(_0x1e4774[_0xb49e('0x2f')]){case _0xb49e('0x56'):return[{'name':_0xb49e('0x57'),'value':_0x1e4774[_0xb49e('0x57')]||(_0x1e4774['attrs']&&_0x1e4774[_0xb49e('0x58')][0x0]?_0x1e4774['attrs'][0x0][_0xb49e('0x59')]:undefined)||_0xb49e('0x5a')}];case _0xb49e('0x5b'):return[{'name':_0xb49e('0x5c'),'value':_0x1e4774[_0xb49e('0x5c')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x0]?_0x1e4774['attrs'][0x0][_0xb49e('0x59')]:undefined)||''}];case _0xb49e('0x5d'):return[{'name':_0xb49e('0x5e'),'value':_0x1e4774[_0xb49e('0x5e')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x0]?_0x1e4774[_0xb49e('0x58')][0x0][_0xb49e('0x59')]:undefined)||'HH:mm:ss'},{'name':'attrTimezone','value':_0x1e4774['attrTimezone']||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x1]?_0x1e4774['attrs'][0x1]['value']:undefined)||_0xb49e('0x5f')},{'name':_0xb49e('0x60'),'value':_0x1e4774[_0xb49e('0x60')]||(_0x1e4774['attrs']&&_0x1e4774[_0xb49e('0x58')][0x2]?_0x1e4774['attrs'][0x2]['value']:undefined)||0xc}];case'counter':return[{'name':_0xb49e('0x61'),'value':_0x1e4774[_0xb49e('0x61')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x0]?_0x1e4774[_0xb49e('0x58')][0x0][_0xb49e('0x59')]:undefined)||_0xb49e('0x62')},{'name':_0xb49e('0x63'),'value':_0x1e4774[_0xb49e('0x63')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x1]?_0x1e4774['attrs'][0x1]['value']:undefined)||[]},{'name':_0xb49e('0x60'),'value':_0x1e4774[_0xb49e('0x60')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x2]?_0x1e4774[_0xb49e('0x58')][0x2][_0xb49e('0x59')]:undefined)||0x14},{'name':'attrChannel','value':_0x1e4774[_0xb49e('0x64')]||(_0x1e4774['attrs']&&_0x1e4774[_0xb49e('0x58')][0x3]?_0x1e4774[_0xb49e('0x58')][0x3]['value']:undefined)||_0xb49e('0x65')},{'name':_0xb49e('0x66'),'value':_0x1e4774[_0xb49e('0x66')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x4]?_0x1e4774['attrs'][0x4][_0xb49e('0x59')]:undefined)||''},{'name':'attrFaxAccounts','value':_0x1e4774['attrFaxAccounts']||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x5]?_0x1e4774[_0xb49e('0x58')][0x5][_0xb49e('0x59')]:undefined)||''},{'name':'attrSmsAccounts','value':_0x1e4774[_0xb49e('0x67')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774['attrs'][0x6]?_0x1e4774[_0xb49e('0x58')][0x6][_0xb49e('0x59')]:undefined)||''},{'name':'attrOpenchannelAccounts','value':_0x1e4774[_0xb49e('0x68')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x7]?_0x1e4774['attrs'][0x7][_0xb49e('0x59')]:undefined)||''},{'name':'attrWhatsappAccounts','value':_0x1e4774[_0xb49e('0x69')]||(_0x1e4774['attrs']&&_0x1e4774['attrs'][0x8]?_0x1e4774[_0xb49e('0x58')][0x8]['value']:undefined)||''},{'name':'attrChatWebsites','value':_0x1e4774[_0xb49e('0x6a')]||(_0x1e4774['attrs']&&_0x1e4774[_0xb49e('0x58')][0x9]?_0x1e4774['attrs'][0x9][_0xb49e('0x59')]:undefined)||''}];case _0xb49e('0x6b'):case'pie-chart':return[{'name':_0xb49e('0x6c'),'value':_0x1e4774[_0xb49e('0x6c')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x0]?_0x1e4774[_0xb49e('0x58')][0x0][_0xb49e('0x59')]:undefined)||_0xb49e('0x62')},{'name':_0xb49e('0x6d'),'value':_0x1e4774[_0xb49e('0x6d')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774['attrs'][0x1]?_0x1e4774[_0xb49e('0x58')][0x1][_0xb49e('0x59')]:undefined)||null},{'name':_0xb49e('0x6e'),'value':_0x1e4774[_0xb49e('0x6e')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x2]?_0x1e4774[_0xb49e('0x58')][0x2]['value']:undefined)||null},{'name':'attrVoiceQueues','value':_0x1e4774['attrVoiceQueues']||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x3]?_0x1e4774[_0xb49e('0x58')][0x3][_0xb49e('0x59')]:undefined)||[]},{'name':_0xb49e('0x64'),'value':_0x1e4774[_0xb49e('0x64')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x4]?_0x1e4774['attrs'][0x4][_0xb49e('0x59')]:undefined)||_0xb49e('0x65')},{'name':_0xb49e('0x66'),'value':_0x1e4774['attrEmailAccounts']||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x5]?_0x1e4774[_0xb49e('0x58')][0x5][_0xb49e('0x59')]:undefined)||''},{'name':_0xb49e('0x6f'),'value':_0x1e4774[_0xb49e('0x6f')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x6]?_0x1e4774[_0xb49e('0x58')][0x6][_0xb49e('0x59')]:undefined)||''},{'name':_0xb49e('0x67'),'value':_0x1e4774['attrSmsAccounts']||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774['attrs'][0x7]?_0x1e4774[_0xb49e('0x58')][0x7][_0xb49e('0x59')]:undefined)||''},{'name':'attrOpenchannelAccounts','value':_0x1e4774[_0xb49e('0x68')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x8]?_0x1e4774[_0xb49e('0x58')][0x8][_0xb49e('0x59')]:undefined)||''},{'name':_0xb49e('0x69'),'value':_0x1e4774[_0xb49e('0x69')]||(_0x1e4774['attrs']&&_0x1e4774[_0xb49e('0x58')][0x9]?_0x1e4774[_0xb49e('0x58')][0x9]['value']:undefined)||''},{'name':_0xb49e('0x6a'),'value':_0x1e4774[_0xb49e('0x6a')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0xa]?_0x1e4774[_0xb49e('0x58')][0xa][_0xb49e('0x59')]:undefined)||''}];case _0xb49e('0x70'):return[{'name':_0xb49e('0x71'),'type':_0x1e4774[_0xb49e('0x72')]||(_0x1e4774['attrs']&&_0x1e4774['attrs'][0x0]?_0x1e4774[_0xb49e('0x58')][0x0][_0xb49e('0x2f')]:undefined)||null,'value':_0x1e4774['attrReport']||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x0]?_0x1e4774[_0xb49e('0x58')][0x0][_0xb49e('0x59')]:undefined)||null},{'name':_0xb49e('0x73'),'value':_0x1e4774[_0xb49e('0x73')]||(_0x1e4774[_0xb49e('0x58')]&&_0x1e4774[_0xb49e('0x58')][0x1]?_0x1e4774['attrs'][0x1]['value']:undefined)||0x0}];default:return[];}}catch(_0x2752d8){logger[_0xb49e('0x29')](_0xb49e('0x74'),JSON[_0xb49e('0x75')](_0x2752d8));return[];}}exports[_0xb49e('0x76')]=function(_0x3fe439,_0x24c43e,_0x55e019){if(_0x3fe439[_0xb49e('0x4b')]['id']){delete _0x3fe439[_0xb49e('0x4b')]['id'];}return db['Dashboard'][_0xb49e('0x49')]({'where':{'id':_0x3fe439['params']['id']}})[_0xb49e('0x25')](handleEntityNotFound(_0x24c43e,null))[_0xb49e('0x25')](function(_0x5dffcc){if(_0x5dffcc){_0x3fe439[_0xb49e('0x4b')]['DashboardId']=_0x5dffcc['id'];_0x3fe439[_0xb49e('0x4b')][_0xb49e('0x58')]=widgetAttributes(_0x3fe439[_0xb49e('0x4b')]);return db[_0xb49e('0x77')][_0xb49e('0x4a')](_0x3fe439[_0xb49e('0x4b')]);}})['then'](respondWithResult(_0x24c43e,null))[_0xb49e('0x46')](handleError(_0x24c43e,null));};exports['getItems']=function(_0x312f8f,_0x506eb6,_0x50a924){var _0x1f972d={};var _0x5192df={};var _0x3bd253;var _0x5df366;return db[_0xb49e('0x2c')][_0xb49e('0x78')]({'where':{'id':_0x312f8f[_0xb49e('0x48')]['id']}})[_0xb49e('0x25')](handleEntityNotFound(_0x506eb6,null))[_0xb49e('0x25')](function(_0x9c8d52){if(_0x9c8d52){_0x3bd253=_0x9c8d52;_0x5192df[_0xb49e('0x31')]=_[_0xb49e('0x33')](db[_0xb49e('0x77')]['rawAttributes']);_0x5192df['query']=_[_0xb49e('0x33')](_0x312f8f['query']);_0x5192df[_0xb49e('0x35')]=_[_0xb49e('0x36')](_0x5192df[_0xb49e('0x31')],_0x5192df[_0xb49e('0x34')]);_0x1f972d[_0xb49e('0x38')]=_[_0xb49e('0x36')](_0x5192df[_0xb49e('0x31')],qs['fields'](_0x312f8f['query'][_0xb49e('0x37')]));_0x1f972d[_0xb49e('0x38')]=_0x1f972d['attributes']['length']?_0x1f972d[_0xb49e('0x38')]:_0x5192df[_0xb49e('0x31')];_0x1f972d['order']=qs['sort'](_0x312f8f['query'][_0xb49e('0x3d')]);_0x1f972d[_0xb49e('0x3e')]=qs['filters'](_[_0xb49e('0x3f')](_0x312f8f[_0xb49e('0x34')],_0x5192df['filters']));if(_0x312f8f['query'][_0xb49e('0x40')]){_0x1f972d[_0xb49e('0x3e')]=_[_0xb49e('0x41')](_0x1f972d['where'],{'$or':_[_0xb49e('0x32')](_0x1f972d[_0xb49e('0x38')],function(_0x5ce732){var _0xffe7ba={};_0xffe7ba[_0x5ce732]={'$like':'%'+_0x312f8f[_0xb49e('0x34')][_0xb49e('0x40')]+'%'};return _0xffe7ba;})});}_0x1f972d=_[_0xb49e('0x41')]({},_0x1f972d,_0x312f8f[_0xb49e('0x42')]);return _0x3bd253[_0xb49e('0x79')](_0x1f972d);}})['then'](function(_0x3d21fd){if(_0x3d21fd){_0x5df366=_0x3d21fd[_0xb49e('0x39')];if(!_0x312f8f[_0xb49e('0x34')][_0xb49e('0x3a')](_0xb49e('0x3b'))){_0x1f972d[_0xb49e('0x1d')]=qs[_0xb49e('0x1d')](_0x312f8f['query'][_0xb49e('0x1d')]);_0x1f972d['offset']=qs[_0xb49e('0x1b')](_0x312f8f[_0xb49e('0x34')][_0xb49e('0x1b')]);}return _0x3bd253[_0xb49e('0x79')](_0x1f972d);}})['then'](function(_0x335a2a){if(_0x335a2a){return _0x335a2a?{'count':_0x5df366,'rows':_0x335a2a}:null;}})['then'](respondWithResult(_0x506eb6,null))[_0xb49e('0x46')](handleError(_0x506eb6,null));};