332a295fd16d46270707f832efc47865046e4270
[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 _0x0fea=['attrSerie1','attrSerie2','attrSerie3','web-report','attrReport','reportType','attrRefresh','widgetAttributes:\x20%s','addItem','DashboardItem','getItems','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','ejs','lodash','squel','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','localhost','socket.io-emitter','redis','./dashboard.socket','register','sendStatus','status','end','json','offset','undefined','limit','set','Content-Range','reject','update','then','destroy','get','CustomDashboards','UserProfileResource','stack','name','send','render','merge','message','agent','index','map','Dashboard','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','options','count','includeAll','include','findAll','rows','catch','show','params','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','create','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','rawAttributes','createdAt','updatedAt','userProfileId','autoAssociation','iframe','attrUrl','attrs','value','attrPath','clock','attrHourFormat','attrTimezone','attrFontSize','counter','attrMetric','total','attrVoiceQueues','multibar-chart','pie-chart'];(function(_0x5850b3,_0x3e3edc){var _0x5a15f4=function(_0x539ab0){while(--_0x539ab0){_0x5850b3['push'](_0x5850b3['shift']());}};_0x5a15f4(++_0x3e3edc);}(_0x0fea,0x86));var _0xa0fe=function(_0x301785,_0x506056){_0x301785=_0x301785-0x0;var _0x4ea53b=_0x0fea[_0x301785];return _0x4ea53b;};'use strict';var emlformat=require(_0xa0fe('0x0'));var rimraf=require(_0xa0fe('0x1'));var zipdir=require(_0xa0fe('0x2'));var jsonpatch=require(_0xa0fe('0x3'));var rp=require(_0xa0fe('0x4'));var moment=require(_0xa0fe('0x5'));var BPromise=require(_0xa0fe('0x6'));var Mustache=require(_0xa0fe('0x7'));var util=require('util');var path=require(_0xa0fe('0x8'));var sox=require(_0xa0fe('0x9'));var csv=require('to-csv');var ejs=require(_0xa0fe('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xa0fe('0xb'));var squel=require(_0xa0fe('0xc'));var crypto=require('crypto');var jsforce=require(_0xa0fe('0xd'));var deskjs=require(_0xa0fe('0xe'));var toCsv=require(_0xa0fe('0xf'));var querystring=require('querystring');var Papa=require(_0xa0fe('0x10'));var Redis=require(_0xa0fe('0x11'));var authService=require(_0xa0fe('0x12'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xa0fe('0x13'));var logger=require('../../config/logger')(_0xa0fe('0x14'));var utils=require('../../config/utils');var config=require(_0xa0fe('0x15'));var licenseUtil=require(_0xa0fe('0x16'));var db=require(_0xa0fe('0x17'))['db'];config['redis']=_['defaults'](config['redis'],{'host':_0xa0fe('0x18'),'port':0x18eb});var socket=require(_0xa0fe('0x19'))(new Redis(config[_0xa0fe('0x1a')]));require(_0xa0fe('0x1b'))[_0xa0fe('0x1c')](socket);function respondWithStatusCode(_0x3b5d9d,_0x2ffedf){_0x2ffedf=_0x2ffedf||0xcc;return function(_0x41f3d8){if(_0x41f3d8){return _0x3b5d9d[_0xa0fe('0x1d')](_0x2ffedf);}return _0x3b5d9d[_0xa0fe('0x1e')](_0x2ffedf)[_0xa0fe('0x1f')]();};}function respondWithResult(_0x4c47f9,_0x3264d3){_0x3264d3=_0x3264d3||0xc8;return function(_0x47186f){if(_0x47186f){return _0x4c47f9['status'](_0x3264d3)[_0xa0fe('0x20')](_0x47186f);}};}function respondWithFilteredResult(_0x536a7f,_0x2b7591){return function(_0x4c0767){if(_0x4c0767){var _0xf151ce=typeof _0x2b7591[_0xa0fe('0x21')]===_0xa0fe('0x22')&&typeof _0x2b7591[_0xa0fe('0x23')]===_0xa0fe('0x22');var _0x398909=_0x4c0767['count'];var _0x2a0dd7=_0xf151ce?0x0:_0x2b7591[_0xa0fe('0x21')];var _0x5e4329=_0xf151ce?_0x4c0767['count']:_0x2b7591['offset']+_0x2b7591[_0xa0fe('0x23')];var _0x3e9ec8;if(_0x5e4329>=_0x398909){_0x5e4329=_0x398909;_0x3e9ec8=0xc8;}else{_0x3e9ec8=0xce;}_0x536a7f[_0xa0fe('0x1e')](_0x3e9ec8);return _0x536a7f[_0xa0fe('0x24')](_0xa0fe('0x25'),_0x2a0dd7+'-'+_0x5e4329+'/'+_0x398909)[_0xa0fe('0x20')](_0x4c0767);}return null;};}function patchUpdates(_0x4f9331){return function(_0x217a76){try{jsonpatch['apply'](_0x217a76,_0x4f9331,!![]);}catch(_0x560ca9){return BPromise[_0xa0fe('0x26')](_0x560ca9);}return _0x217a76['save']();};}function saveUpdates(_0x35162d,_0x4db0d9){return function(_0x3fd67f){if(_0x3fd67f){return _0x3fd67f[_0xa0fe('0x27')](_0x35162d)[_0xa0fe('0x28')](function(_0x19553c){return _0x19553c;});}return null;};}function removeEntity(_0x4ef46b,_0x156242){return function(_0xe4b064){if(_0xe4b064){return _0xe4b064[_0xa0fe('0x29')]()[_0xa0fe('0x28')](function(){var _0x2c3a96=_0xe4b064[_0xa0fe('0x2a')]({'plain':!![]});var _0x262d09=_0xa0fe('0x2b');return db[_0xa0fe('0x2c')][_0xa0fe('0x29')]({'where':{'type':_0x262d09,'resourceId':_0x2c3a96['id']}})[_0xa0fe('0x28')](function(){return _0xe4b064;});})[_0xa0fe('0x28')](function(){_0x4ef46b['status'](0xcc)[_0xa0fe('0x1f')]();});}};}function handleEntityNotFound(_0x8e5e73,_0x55b0b7){return function(_0x162015){if(!_0x162015){_0x8e5e73[_0xa0fe('0x1d')](0x194);}return _0x162015;};}function handleError(_0x5692fc,_0xd21715){_0xd21715=_0xd21715||0x1f4;return function(_0x3c65ba){logger['error'](_0x3c65ba[_0xa0fe('0x2d')]);if(_0x3c65ba[_0xa0fe('0x2e')]){delete _0x3c65ba[_0xa0fe('0x2e')];}_0x5692fc[_0xa0fe('0x1e')](_0xd21715)[_0xa0fe('0x2f')](_0x3c65ba);};}function getMustacheRender(_0x5e22bb,_0x511d55){return Mustache[_0xa0fe('0x30')](_0x5e22bb,_[_0xa0fe('0x31')](_0x511d55['body'],{'contact':_0x511d55['contact'],'message':_0x511d55[_0xa0fe('0x32')],'agent':_0x511d55[_0xa0fe('0x33')],'interaction':_0x511d55['interaction'],'account':_0x511d55['account']}))||'';}exports[_0xa0fe('0x34')]=function(_0x547f03,_0x20d1ec){var _0x25ecb5={},_0x33b216={},_0x217d4e={'count':0x0,'rows':[]};var _0x250d59=_[_0xa0fe('0x35')](db[_0xa0fe('0x36')]['rawAttributes'],function(_0xcd2661){return{'name':_0xcd2661[_0xa0fe('0x37')],'type':_0xcd2661[_0xa0fe('0x38')][_0xa0fe('0x39')]};});_0x33b216[_0xa0fe('0x3a')]=_[_0xa0fe('0x35')](_0x250d59,'name');_0x33b216[_0xa0fe('0x3b')]=_[_0xa0fe('0x3c')](_0x547f03[_0xa0fe('0x3b')]);_0x33b216[_0xa0fe('0x3d')]=_[_0xa0fe('0x3e')](_0x33b216[_0xa0fe('0x3a')],_0x33b216[_0xa0fe('0x3b')]);_0x25ecb5[_0xa0fe('0x3f')]=_[_0xa0fe('0x3e')](_0x33b216[_0xa0fe('0x3a')],qs[_0xa0fe('0x40')](_0x547f03[_0xa0fe('0x3b')][_0xa0fe('0x40')]));_0x25ecb5[_0xa0fe('0x3f')]=_0x25ecb5[_0xa0fe('0x3f')][_0xa0fe('0x41')]?_0x25ecb5['attributes']:_0x33b216[_0xa0fe('0x3a')];if(!_0x547f03[_0xa0fe('0x3b')][_0xa0fe('0x42')](_0xa0fe('0x43'))){_0x25ecb5['limit']=qs[_0xa0fe('0x23')](_0x547f03[_0xa0fe('0x3b')]['limit']);_0x25ecb5[_0xa0fe('0x21')]=qs['offset'](_0x547f03[_0xa0fe('0x3b')]['offset']);}_0x25ecb5[_0xa0fe('0x44')]=qs[_0xa0fe('0x45')](_0x547f03['query'][_0xa0fe('0x45')]);_0x25ecb5['where']=qs[_0xa0fe('0x3d')](_[_0xa0fe('0x46')](_0x547f03[_0xa0fe('0x3b')],_0x33b216[_0xa0fe('0x3d')]),_0x250d59);if(_0x547f03[_0xa0fe('0x3b')][_0xa0fe('0x47')]){_0x25ecb5[_0xa0fe('0x48')]=_[_0xa0fe('0x31')](_0x25ecb5[_0xa0fe('0x48')],{'$or':_['map'](_0x250d59,function(_0xa3f6cb){if(_0xa3f6cb[_0xa0fe('0x38')]!=='VIRTUAL'){var _0x51db3b={};_0x51db3b[_0xa3f6cb['name']]={'$like':'%'+_0x547f03[_0xa0fe('0x3b')]['filter']+'%'};return _0x51db3b;}})});}_0x25ecb5=_['merge']({},_0x25ecb5,_0x547f03[_0xa0fe('0x49')]);var _0x4cd8af={'where':_0x25ecb5[_0xa0fe('0x48')]};return db[_0xa0fe('0x36')][_0xa0fe('0x4a')](_0x4cd8af)[_0xa0fe('0x28')](function(_0xbac93c){_0x217d4e[_0xa0fe('0x4a')]=_0xbac93c;if(_0x547f03[_0xa0fe('0x3b')][_0xa0fe('0x4b')]){_0x25ecb5[_0xa0fe('0x4c')]=[{'all':!![]}];}return db[_0xa0fe('0x36')][_0xa0fe('0x4d')](_0x25ecb5);})[_0xa0fe('0x28')](function(_0x1556da){_0x217d4e[_0xa0fe('0x4e')]=_0x1556da;return _0x217d4e;})[_0xa0fe('0x28')](respondWithFilteredResult(_0x20d1ec,_0x25ecb5))[_0xa0fe('0x4f')](handleError(_0x20d1ec,null));};exports[_0xa0fe('0x50')]=function(_0x4a09b8,_0x2273a4){var _0x56e236={'raw':![],'where':{'id':_0x4a09b8[_0xa0fe('0x51')]['id']}},_0x2e7e3f={};_0x2e7e3f[_0xa0fe('0x3a')]=_['keys'](db[_0xa0fe('0x36')]['rawAttributes']);_0x2e7e3f[_0xa0fe('0x3b')]=_[_0xa0fe('0x3c')](_0x4a09b8['query']);_0x2e7e3f[_0xa0fe('0x3d')]=_[_0xa0fe('0x3e')](_0x2e7e3f[_0xa0fe('0x3a')],_0x2e7e3f[_0xa0fe('0x3b')]);_0x56e236[_0xa0fe('0x3f')]=_[_0xa0fe('0x3e')](_0x2e7e3f['model'],qs['fields'](_0x4a09b8[_0xa0fe('0x3b')]['fields']));_0x56e236[_0xa0fe('0x3f')]=_0x56e236[_0xa0fe('0x3f')]['length']?_0x56e236[_0xa0fe('0x3f')]:_0x2e7e3f['model'];if(_0x4a09b8[_0xa0fe('0x3b')]['includeAll']){_0x56e236['include']=[{'all':!![]}];}_0x56e236=_[_0xa0fe('0x31')]({},_0x56e236,_0x4a09b8[_0xa0fe('0x49')]);return db['Dashboard']['find'](_0x56e236)[_0xa0fe('0x28')](handleEntityNotFound(_0x2273a4,null))[_0xa0fe('0x28')](respondWithResult(_0x2273a4,null))['catch'](handleError(_0x2273a4,null));};exports['create']=function(_0x23c167,_0x35d237){return db['Dashboard']['create'](_0x23c167[_0xa0fe('0x52')],{})[_0xa0fe('0x28')](function(_0x31c941){var _0x393dd6=_0x23c167[_0xa0fe('0x53')][_0xa0fe('0x2a')]({'plain':!![]});if(!_0x393dd6)throw new Error(_0xa0fe('0x54'));if(_0x393dd6[_0xa0fe('0x55')]===_0xa0fe('0x53')){var _0x2527c4=_0x31c941[_0xa0fe('0x2a')]({'plain':!![]});var _0x427d0c=_0xa0fe('0x2b');return db[_0xa0fe('0x56')][_0xa0fe('0x57')]({'where':{'name':_0x427d0c,'userProfileId':_0x393dd6['userProfileId']},'raw':!![]})[_0xa0fe('0x28')](function(_0x100fba){if(_0x100fba&&_0x100fba['autoAssociation']===0x0){return db[_0xa0fe('0x2c')][_0xa0fe('0x58')]({'name':_0x2527c4['name'],'resourceId':_0x2527c4['id'],'type':_0x100fba[_0xa0fe('0x2e')],'sectionId':_0x100fba['id']},{})['then'](function(){return _0x31c941;});}else{return _0x31c941;}})[_0xa0fe('0x4f')](function(_0x5f5670){logger[_0xa0fe('0x59')](_0xa0fe('0x5a'),_0x5f5670);throw _0x5f5670;});}return _0x31c941;})[_0xa0fe('0x28')](respondWithResult(_0x35d237,0xc9))[_0xa0fe('0x4f')](handleError(_0x35d237,null));};exports[_0xa0fe('0x5b')]=function(_0x411a5b,_0x111e29){var _0x9384b3={'where':{'id':_0x411a5b[_0xa0fe('0x51')]['id']}},_0x5114c6={};_0x5114c6[_0xa0fe('0x3a')]=_[_0xa0fe('0x3c')](db[_0xa0fe('0x36')][_0xa0fe('0x5c')]);_0x9384b3['attributes']=_['intersection'](_0x5114c6[_0xa0fe('0x3a')],qs['fields'](_0x411a5b[_0xa0fe('0x3b')][_0xa0fe('0x40')]));_0x9384b3[_0xa0fe('0x3f')]=_0x9384b3[_0xa0fe('0x3f')][_0xa0fe('0x41')]?_0x9384b3[_0xa0fe('0x3f')]:_0x5114c6['model'];if(_0x411a5b['query'][_0xa0fe('0x4b')]){_0x9384b3[_0xa0fe('0x4c')]=[{'all':!![]}];}_0x9384b3=_[_0xa0fe('0x31')]({},_0x9384b3,_0x411a5b[_0xa0fe('0x49')]);return db['Dashboard'][_0xa0fe('0x57')](_0x9384b3)[_0xa0fe('0x28')](handleEntityNotFound(_0x111e29,null))['then'](function(_0x539361){if(_0x539361){var _0x4c06ef=_0x539361[_0xa0fe('0x2a')]({'plain':!![]});_0x4c06ef=qs['omit'](_0x4c06ef,['id',_0xa0fe('0x5d'),_0xa0fe('0x5e')]);_0x411a5b[_0xa0fe('0x52')]=_['omit'](_0x411a5b[_0xa0fe('0x52')],['id',_0xa0fe('0x5d'),_0xa0fe('0x5e')]);return db[_0xa0fe('0x36')]['create'](_['merge'](_0x4c06ef,_0x411a5b[_0xa0fe('0x52')]),{'include':_0x411a5b[_0xa0fe('0x3b')][_0xa0fe('0x4b')]?[{'all':!![]}]:undefined})['then'](function(_0x4e031c){var _0x4be086=_0x411a5b[_0xa0fe('0x53')]['get']({'plain':!![]});if(!_0x4be086)throw new Error(_0xa0fe('0x54'));if(_0x4be086['role']===_0xa0fe('0x53')){var _0xd2f484=_0x4e031c['get']({'plain':!![]});var _0x5b0e66=_0xa0fe('0x2b');return db[_0xa0fe('0x56')]['find']({'where':{'name':_0x5b0e66,'userProfileId':_0x4be086[_0xa0fe('0x5f')]},'raw':!![]})[_0xa0fe('0x28')](function(_0x58d970){if(_0x58d970&&_0x58d970[_0xa0fe('0x60')]===0x0){return db['UserProfileResource']['create']({'name':_0xd2f484[_0xa0fe('0x2e')],'resourceId':_0xd2f484['id'],'type':_0x58d970[_0xa0fe('0x2e')],'sectionId':_0x58d970['id']},{})[_0xa0fe('0x28')](function(){return _0x4e031c;});}else{return _0x4e031c;}})[_0xa0fe('0x4f')](function(_0x295656){logger[_0xa0fe('0x59')](_0xa0fe('0x5a'),_0x295656);throw _0x295656;});}return _0x4e031c;});}})[_0xa0fe('0x28')](respondWithResult(_0x111e29,0xc9))[_0xa0fe('0x4f')](handleError(_0x111e29,null));};exports['update']=function(_0x5c87dd,_0xd9811c){if(_0x5c87dd[_0xa0fe('0x52')]['id']){delete _0x5c87dd[_0xa0fe('0x52')]['id'];}return db[_0xa0fe('0x36')][_0xa0fe('0x57')]({'where':{'id':_0x5c87dd[_0xa0fe('0x51')]['id']}})[_0xa0fe('0x28')](handleEntityNotFound(_0xd9811c,null))[_0xa0fe('0x28')](saveUpdates(_0x5c87dd[_0xa0fe('0x52')],null))['then'](respondWithResult(_0xd9811c,null))['catch'](handleError(_0xd9811c,null));};exports[_0xa0fe('0x29')]=function(_0x9769c7,_0x5d04e8){return db['Dashboard'][_0xa0fe('0x57')]({'where':{'id':_0x9769c7['params']['id']}})[_0xa0fe('0x28')](handleEntityNotFound(_0x5d04e8,null))[_0xa0fe('0x28')](removeEntity(_0x5d04e8,null))[_0xa0fe('0x4f')](handleError(_0x5d04e8,null));};function widgetAttributes(_0x47c255){try{switch(_0x47c255[_0xa0fe('0x38')]){case _0xa0fe('0x61'):return[{'name':_0xa0fe('0x62'),'value':_0x47c255[_0xa0fe('0x62')]||(_0x47c255['attrs']&&_0x47c255['attrs'][0x0]?_0x47c255[_0xa0fe('0x63')][0x0][_0xa0fe('0x64')]:undefined)||'https://'}];case'custom':return[{'name':_0xa0fe('0x65'),'value':_0x47c255[_0xa0fe('0x65')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x0]?_0x47c255[_0xa0fe('0x63')][0x0][_0xa0fe('0x64')]:undefined)||''}];case _0xa0fe('0x66'):return[{'name':_0xa0fe('0x67'),'value':_0x47c255[_0xa0fe('0x67')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x0]?_0x47c255[_0xa0fe('0x63')][0x0][_0xa0fe('0x64')]:undefined)||'HH:mm:ss'},{'name':_0xa0fe('0x68'),'value':_0x47c255[_0xa0fe('0x68')]||(_0x47c255['attrs']&&_0x47c255[_0xa0fe('0x63')][0x1]?_0x47c255[_0xa0fe('0x63')][0x1][_0xa0fe('0x64')]:undefined)||'0.00'},{'name':_0xa0fe('0x69'),'value':_0x47c255[_0xa0fe('0x69')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x2]?_0x47c255[_0xa0fe('0x63')][0x2]['value']:undefined)||0xc}];case _0xa0fe('0x6a'):return[{'name':_0xa0fe('0x6b'),'value':_0x47c255[_0xa0fe('0x6b')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x0]?_0x47c255[_0xa0fe('0x63')][0x0][_0xa0fe('0x64')]:undefined)||_0xa0fe('0x6c')},{'name':_0xa0fe('0x6d'),'value':_0x47c255[_0xa0fe('0x6d')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x1]?_0x47c255[_0xa0fe('0x63')][0x1][_0xa0fe('0x64')]:undefined)||[]},{'name':'attrFontSize','value':_0x47c255['attrFontSize']||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255['attrs'][0x2]?_0x47c255[_0xa0fe('0x63')][0x2][_0xa0fe('0x64')]:undefined)||0x14}];case _0xa0fe('0x6e'):case _0xa0fe('0x6f'):return[{'name':_0xa0fe('0x70'),'value':_0x47c255[_0xa0fe('0x70')]||(_0x47c255['attrs']&&_0x47c255[_0xa0fe('0x63')][0x0]?_0x47c255[_0xa0fe('0x63')][0x0][_0xa0fe('0x64')]:undefined)||'total'},{'name':_0xa0fe('0x71'),'value':_0x47c255['attrSerie2']||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x1]?_0x47c255[_0xa0fe('0x63')][0x1][_0xa0fe('0x64')]:undefined)||null},{'name':'attrSerie3','value':_0x47c255[_0xa0fe('0x72')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x2]?_0x47c255[_0xa0fe('0x63')][0x2][_0xa0fe('0x64')]:undefined)||null},{'name':'attrVoiceQueues','value':_0x47c255['attrVoiceQueues']||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255['attrs'][0x3]?_0x47c255[_0xa0fe('0x63')][0x3][_0xa0fe('0x64')]:undefined)||[]}];case _0xa0fe('0x73'):return[{'name':_0xa0fe('0x74'),'type':_0x47c255[_0xa0fe('0x75')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x0]?_0x47c255[_0xa0fe('0x63')][0x0][_0xa0fe('0x38')]:undefined)||null,'value':_0x47c255[_0xa0fe('0x74')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x0]?_0x47c255[_0xa0fe('0x63')][0x0]['value']:undefined)||null},{'name':_0xa0fe('0x76'),'value':_0x47c255[_0xa0fe('0x76')]||(_0x47c255[_0xa0fe('0x63')]&&_0x47c255[_0xa0fe('0x63')][0x1]?_0x47c255[_0xa0fe('0x63')][0x1]['value']:undefined)||0x0}];default:return[];}}catch(_0x2ef46f){logger[_0xa0fe('0x59')](_0xa0fe('0x77'),JSON['stringify'](_0x2ef46f));return[];}}exports[_0xa0fe('0x78')]=function(_0x493b20,_0x5f26f4,_0x4e2834){if(_0x493b20[_0xa0fe('0x52')]['id']){delete _0x493b20[_0xa0fe('0x52')]['id'];}return db[_0xa0fe('0x36')][_0xa0fe('0x57')]({'where':{'id':_0x493b20[_0xa0fe('0x51')]['id']}})[_0xa0fe('0x28')](handleEntityNotFound(_0x5f26f4,null))[_0xa0fe('0x28')](function(_0x5b2438){if(_0x5b2438){_0x493b20[_0xa0fe('0x52')]['DashboardId']=_0x5b2438['id'];_0x493b20[_0xa0fe('0x52')][_0xa0fe('0x63')]=widgetAttributes(_0x493b20[_0xa0fe('0x52')]);return db[_0xa0fe('0x79')][_0xa0fe('0x58')](_0x493b20[_0xa0fe('0x52')]);}})[_0xa0fe('0x28')](respondWithResult(_0x5f26f4,null))[_0xa0fe('0x4f')](handleError(_0x5f26f4,null));};exports['getItems']=function(_0x13a636,_0x3d2288,_0x962879){var _0x4e7852={};var _0x1a0d4f={};var _0x4670dd;var _0x4c99be;return db[_0xa0fe('0x36')]['findOne']({'where':{'id':_0x13a636[_0xa0fe('0x51')]['id']}})[_0xa0fe('0x28')](handleEntityNotFound(_0x3d2288,null))[_0xa0fe('0x28')](function(_0x2d4676){if(_0x2d4676){_0x4670dd=_0x2d4676;_0x1a0d4f[_0xa0fe('0x3a')]=_[_0xa0fe('0x3c')](db[_0xa0fe('0x79')][_0xa0fe('0x5c')]);_0x1a0d4f[_0xa0fe('0x3b')]=_[_0xa0fe('0x3c')](_0x13a636['query']);_0x1a0d4f['filters']=_[_0xa0fe('0x3e')](_0x1a0d4f[_0xa0fe('0x3a')],_0x1a0d4f['query']);_0x4e7852[_0xa0fe('0x3f')]=_[_0xa0fe('0x3e')](_0x1a0d4f[_0xa0fe('0x3a')],qs[_0xa0fe('0x40')](_0x13a636[_0xa0fe('0x3b')][_0xa0fe('0x40')]));_0x4e7852['attributes']=_0x4e7852['attributes'][_0xa0fe('0x41')]?_0x4e7852[_0xa0fe('0x3f')]:_0x1a0d4f[_0xa0fe('0x3a')];_0x4e7852[_0xa0fe('0x44')]=qs['sort'](_0x13a636[_0xa0fe('0x3b')][_0xa0fe('0x45')]);_0x4e7852['where']=qs[_0xa0fe('0x3d')](_[_0xa0fe('0x46')](_0x13a636[_0xa0fe('0x3b')],_0x1a0d4f['filters']));if(_0x13a636[_0xa0fe('0x3b')][_0xa0fe('0x47')]){_0x4e7852['where']=_[_0xa0fe('0x31')](_0x4e7852[_0xa0fe('0x48')],{'$or':_[_0xa0fe('0x35')](_0x4e7852[_0xa0fe('0x3f')],function(_0x4e2e44){var _0x43f530={};_0x43f530[_0x4e2e44]={'$like':'%'+_0x13a636[_0xa0fe('0x3b')]['filter']+'%'};return _0x43f530;})});}_0x4e7852=_[_0xa0fe('0x31')]({},_0x4e7852,_0x13a636['options']);return _0x4670dd[_0xa0fe('0x7a')](_0x4e7852);}})['then'](function(_0x6c2367){if(_0x6c2367){_0x4c99be=_0x6c2367[_0xa0fe('0x41')];if(!_0x13a636[_0xa0fe('0x3b')][_0xa0fe('0x42')](_0xa0fe('0x43'))){_0x4e7852[_0xa0fe('0x23')]=qs[_0xa0fe('0x23')](_0x13a636[_0xa0fe('0x3b')][_0xa0fe('0x23')]);_0x4e7852[_0xa0fe('0x21')]=qs[_0xa0fe('0x21')](_0x13a636[_0xa0fe('0x3b')]['offset']);}return _0x4670dd[_0xa0fe('0x7a')](_0x4e7852);}})[_0xa0fe('0x28')](function(_0x179485){if(_0x179485){return _0x179485?{'count':_0x4c99be,'rows':_0x179485}:null;}})[_0xa0fe('0x28')](respondWithResult(_0x3d2288,null))[_0xa0fe('0x4f')](handleError(_0x3d2288,null));};