Built motion from commit (unavailable).|2.5.10
[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 _0xb746=['VIRTUAL','filter','options','Dashboard','count','includeAll','include','rows','params','rawAttributes','find','catch','body','role','user','UserProfileSection','autoAssociation','create','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','userProfileId','iframe','attrUrl','attrs','value','custom','attrPath','clock','attrHourFormat','HH:mm:ss','attrTimezone','attrFontSize','counter','attrMetric','total','attrVoiceQueues','multibar-chart','pie-chart','attrSerie1','attrSerie2','attrSerie3','web-report','attrReport','reportType','widgetAttributes:\x20%s','stringify','addItem','DashboardId','DashboardItem','getItems','order','html-pdf','eml-format','rimraf','moment','bluebird','mustache','util','path','sox','to-csv','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/license/util','../../mysqldb','redis','defaults','socket.io-emitter','./dashboard.socket','sendStatus','status','end','offset','limit','Content-Range','json','apply','reject','save','update','then','get','CustomDashboards','UserProfileResource','destroy','error','stack','name','send','index','map','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','pick','where','merge'];(function(_0x4ea44b,_0x546b89){var _0x418cc9=function(_0x1eb1e5){while(--_0x1eb1e5){_0x4ea44b['push'](_0x4ea44b['shift']());}};_0x418cc9(++_0x546b89);}(_0xb746,0x1a2));var _0x6b74=function(_0x4de8af,_0x25f8f6){_0x4de8af=_0x4de8af-0x0;var _0xadb8ca=_0xb746[_0x4de8af];return _0xadb8ca;};'use strict';var pdf=require(_0x6b74('0x0'));var emlformat=require(_0x6b74('0x1'));var rimraf=require(_0x6b74('0x2'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x6b74('0x3'));var BPromise=require(_0x6b74('0x4'));var Mustache=require(_0x6b74('0x5'));var util=require(_0x6b74('0x6'));var path=require(_0x6b74('0x7'));var sox=require(_0x6b74('0x8'));var csv=require(_0x6b74('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x6b74('0xa'));var squel=require('squel');var crypto=require(_0x6b74('0xb'));var jsforce=require(_0x6b74('0xc'));var deskjs=require(_0x6b74('0xd'));var toCsv=require(_0x6b74('0x9'));var querystring=require(_0x6b74('0xe'));var Papa=require(_0x6b74('0xf'));var Redis=require(_0x6b74('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x6b74('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x6b74('0x12'));var logger=require(_0x6b74('0x13'))('api');var utils=require(_0x6b74('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x6b74('0x15'));var db=require(_0x6b74('0x16'))['db'];config[_0x6b74('0x17')]=_[_0x6b74('0x18')](config[_0x6b74('0x17')],{'host':'localhost','port':0x18eb});var socket=require(_0x6b74('0x19'))(new Redis(config[_0x6b74('0x17')]));require(_0x6b74('0x1a'))['register'](socket);function respondWithStatusCode(_0x123763,_0x3c45e4){_0x3c45e4=_0x3c45e4||0xcc;return function(_0x94a842){if(_0x94a842){return _0x123763[_0x6b74('0x1b')](_0x3c45e4);}return _0x123763[_0x6b74('0x1c')](_0x3c45e4)[_0x6b74('0x1d')]();};}function respondWithResult(_0x36bc69,_0x59bfd7){_0x59bfd7=_0x59bfd7||0xc8;return function(_0x3d539f){if(_0x3d539f){return _0x36bc69[_0x6b74('0x1c')](_0x59bfd7)['json'](_0x3d539f);}};}function respondWithFilteredResult(_0x29278e,_0x5c2c30){return function(_0x3ac41f){if(_0x3ac41f){var _0x39c16a=_0x3ac41f['count'],_0xf0ce97=_0x5c2c30[_0x6b74('0x1e')],_0xac25a=_0x5c2c30[_0x6b74('0x1e')]+_0x5c2c30[_0x6b74('0x1f')],_0x5c88c1;if(_0xac25a>=_0x39c16a){_0xac25a=_0x39c16a;_0x5c88c1=0xc8;}else{_0x5c88c1=0xce;}_0x29278e[_0x6b74('0x1c')](_0x5c88c1);return _0x29278e['set'](_0x6b74('0x20'),_0xf0ce97+'-'+_0xac25a+'/'+_0x39c16a)[_0x6b74('0x21')](_0x3ac41f);}return null;};}function patchUpdates(_0x10adf2){return function(_0x222a7d){try{jsonpatch[_0x6b74('0x22')](_0x222a7d,_0x10adf2,!![]);}catch(_0x239135){return BPromise[_0x6b74('0x23')](_0x239135);}return _0x222a7d[_0x6b74('0x24')]();};}function saveUpdates(_0x10c3a0,_0x35cecd){return function(_0x34d8bb){if(_0x34d8bb){return _0x34d8bb[_0x6b74('0x25')](_0x10c3a0)[_0x6b74('0x26')](function(_0x45efa9){return _0x45efa9;});}return null;};}function removeEntity(_0x256589,_0x316b1d){return function(_0x202e2e){if(_0x202e2e){return _0x202e2e['destroy']()[_0x6b74('0x26')](function(){var _0x4409ac=_0x202e2e[_0x6b74('0x27')]({'plain':!![]});var _0x1f0bc2=_0x6b74('0x28');return db[_0x6b74('0x29')][_0x6b74('0x2a')]({'where':{'type':_0x1f0bc2,'resourceId':_0x4409ac['id']}})[_0x6b74('0x26')](function(){return _0x202e2e;});})['then'](function(){_0x256589[_0x6b74('0x1c')](0xcc)[_0x6b74('0x1d')]();});}};}function handleEntityNotFound(_0x188195,_0x50aaa9){return function(_0x8e707b){if(!_0x8e707b){_0x188195['sendStatus'](0x194);}return _0x8e707b;};}function handleError(_0x5e2e6a,_0x1ad52e){_0x1ad52e=_0x1ad52e||0x1f4;return function(_0x110b6f){logger[_0x6b74('0x2b')](_0x110b6f[_0x6b74('0x2c')]);if(_0x110b6f[_0x6b74('0x2d')]){delete _0x110b6f[_0x6b74('0x2d')];}_0x5e2e6a[_0x6b74('0x1c')](_0x1ad52e)[_0x6b74('0x2e')](_0x110b6f);};}exports[_0x6b74('0x2f')]=function(_0x381d72,_0x2d3abb){var _0x5e0a2d={},_0x529fff={},_0x36f500={'count':0x0,'rows':[]};var _0x1461aa=_[_0x6b74('0x30')](db['Dashboard']['rawAttributes'],function(_0x414102){return{'name':_0x414102[_0x6b74('0x31')],'type':_0x414102[_0x6b74('0x32')][_0x6b74('0x33')]};});_0x529fff[_0x6b74('0x34')]=_[_0x6b74('0x30')](_0x1461aa,_0x6b74('0x2d'));_0x529fff[_0x6b74('0x35')]=_[_0x6b74('0x36')](_0x381d72[_0x6b74('0x35')]);_0x529fff[_0x6b74('0x37')]=_[_0x6b74('0x38')](_0x529fff['model'],_0x529fff[_0x6b74('0x35')]);_0x5e0a2d[_0x6b74('0x39')]=_[_0x6b74('0x38')](_0x529fff[_0x6b74('0x34')],qs[_0x6b74('0x3a')](_0x381d72[_0x6b74('0x35')]['fields']));_0x5e0a2d[_0x6b74('0x39')]=_0x5e0a2d[_0x6b74('0x39')][_0x6b74('0x3b')]?_0x5e0a2d[_0x6b74('0x39')]:_0x529fff['model'];if(!_0x381d72[_0x6b74('0x35')][_0x6b74('0x3c')](_0x6b74('0x3d'))){_0x5e0a2d['limit']=qs[_0x6b74('0x1f')](_0x381d72[_0x6b74('0x35')][_0x6b74('0x1f')]);_0x5e0a2d['offset']=qs[_0x6b74('0x1e')](_0x381d72['query']['offset']);}_0x5e0a2d['order']=qs[_0x6b74('0x3e')](_0x381d72[_0x6b74('0x35')][_0x6b74('0x3e')]);_0x5e0a2d['where']=qs[_0x6b74('0x37')](_[_0x6b74('0x3f')](_0x381d72[_0x6b74('0x35')],_0x529fff[_0x6b74('0x37')]),_0x1461aa);if(_0x381d72['query']['filter']){_0x5e0a2d[_0x6b74('0x40')]=_[_0x6b74('0x41')](_0x5e0a2d[_0x6b74('0x40')],{'$or':_['map'](_0x1461aa,function(_0xc0d167){if(_0xc0d167[_0x6b74('0x32')]!==_0x6b74('0x42')){var _0x5aa195={};_0x5aa195[_0xc0d167[_0x6b74('0x2d')]]={'$like':'%'+_0x381d72[_0x6b74('0x35')][_0x6b74('0x43')]+'%'};return _0x5aa195;}})});}_0x5e0a2d=_['merge']({},_0x5e0a2d,_0x381d72[_0x6b74('0x44')]);var _0x43d237={'where':_0x5e0a2d[_0x6b74('0x40')]};return db[_0x6b74('0x45')][_0x6b74('0x46')](_0x43d237)[_0x6b74('0x26')](function(_0xa8b696){_0x36f500[_0x6b74('0x46')]=_0xa8b696;if(_0x381d72[_0x6b74('0x35')][_0x6b74('0x47')]){_0x5e0a2d[_0x6b74('0x48')]=[{'all':!![]}];}return db[_0x6b74('0x45')]['findAll'](_0x5e0a2d);})[_0x6b74('0x26')](function(_0x92403a){_0x36f500[_0x6b74('0x49')]=_0x92403a;return _0x36f500;})['then'](respondWithFilteredResult(_0x2d3abb,_0x5e0a2d))['catch'](handleError(_0x2d3abb,null));};exports['show']=function(_0xd3f552,_0x236bc4){var _0x4b4e6a={'raw':![],'where':{'id':_0xd3f552[_0x6b74('0x4a')]['id']}},_0x5281f7={};_0x5281f7[_0x6b74('0x34')]=_[_0x6b74('0x36')](db[_0x6b74('0x45')][_0x6b74('0x4b')]);_0x5281f7[_0x6b74('0x35')]=_[_0x6b74('0x36')](_0xd3f552['query']);_0x5281f7[_0x6b74('0x37')]=_[_0x6b74('0x38')](_0x5281f7[_0x6b74('0x34')],_0x5281f7[_0x6b74('0x35')]);_0x4b4e6a[_0x6b74('0x39')]=_[_0x6b74('0x38')](_0x5281f7[_0x6b74('0x34')],qs[_0x6b74('0x3a')](_0xd3f552[_0x6b74('0x35')]['fields']));_0x4b4e6a[_0x6b74('0x39')]=_0x4b4e6a[_0x6b74('0x39')]['length']?_0x4b4e6a[_0x6b74('0x39')]:_0x5281f7['model'];if(_0xd3f552[_0x6b74('0x35')][_0x6b74('0x47')]){_0x4b4e6a[_0x6b74('0x48')]=[{'all':!![]}];}_0x4b4e6a=_[_0x6b74('0x41')]({},_0x4b4e6a,_0xd3f552[_0x6b74('0x44')]);return db[_0x6b74('0x45')][_0x6b74('0x4c')](_0x4b4e6a)['then'](handleEntityNotFound(_0x236bc4,null))['then'](respondWithResult(_0x236bc4,null))[_0x6b74('0x4d')](handleError(_0x236bc4,null));};exports['create']=function(_0x179192,_0xf4d36a){return db['Dashboard']['create'](_0x179192[_0x6b74('0x4e')],{})[_0x6b74('0x26')](function(_0x403946){var _0x2f111c=_0x179192['user'][_0x6b74('0x27')]({'plain':!![]});if(!_0x2f111c)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x2f111c[_0x6b74('0x4f')]===_0x6b74('0x50')){var _0xfc2478=_0x403946[_0x6b74('0x27')]({'plain':!![]});var _0x50fc23='CustomDashboards';return db[_0x6b74('0x51')][_0x6b74('0x4c')]({'where':{'name':_0x50fc23,'userProfileId':_0x2f111c['userProfileId']},'raw':!![]})['then'](function(_0x4c9146){if(_0x4c9146&&_0x4c9146[_0x6b74('0x52')]===0x0){return db[_0x6b74('0x29')][_0x6b74('0x53')]({'name':_0xfc2478[_0x6b74('0x2d')],'resourceId':_0xfc2478['id'],'type':_0x4c9146[_0x6b74('0x2d')],'sectionId':_0x4c9146['id']},{})[_0x6b74('0x26')](function(){return _0x403946;});}else{return _0x403946;}})[_0x6b74('0x4d')](function(_0x479cdd){logger[_0x6b74('0x2b')](_0x6b74('0x54'),_0x479cdd);throw _0x479cdd;});}return _0x403946;})[_0x6b74('0x26')](respondWithResult(_0xf4d36a,0xc9))[_0x6b74('0x4d')](handleError(_0xf4d36a,null));};exports[_0x6b74('0x55')]=function(_0x17a09e,_0x1b6e8f){var _0x325727={'where':{'id':_0x17a09e[_0x6b74('0x4a')]['id']}},_0x9c78b9={};_0x9c78b9[_0x6b74('0x34')]=_[_0x6b74('0x36')](db[_0x6b74('0x45')][_0x6b74('0x4b')]);_0x325727[_0x6b74('0x39')]=_['intersection'](_0x9c78b9['model'],qs['fields'](_0x17a09e[_0x6b74('0x35')][_0x6b74('0x3a')]));_0x325727['attributes']=_0x325727[_0x6b74('0x39')][_0x6b74('0x3b')]?_0x325727[_0x6b74('0x39')]:_0x9c78b9['model'];if(_0x17a09e[_0x6b74('0x35')]['includeAll']){_0x325727[_0x6b74('0x48')]=[{'all':!![]}];}_0x325727=_['merge']({},_0x325727,_0x17a09e['options']);return db[_0x6b74('0x45')][_0x6b74('0x4c')](_0x325727)['then'](handleEntityNotFound(_0x1b6e8f,null))['then'](function(_0x3e942e){if(_0x3e942e){var _0x4ca946=_0x3e942e[_0x6b74('0x27')]({'plain':!![]});_0x4ca946=qs[_0x6b74('0x56')](_0x4ca946,['id',_0x6b74('0x57'),_0x6b74('0x58')]);_0x17a09e['body']=_[_0x6b74('0x56')](_0x17a09e[_0x6b74('0x4e')],['id',_0x6b74('0x57'),'updatedAt']);return db['Dashboard'][_0x6b74('0x53')](_['merge'](_0x4ca946,_0x17a09e[_0x6b74('0x4e')]),{'include':_0x17a09e[_0x6b74('0x35')][_0x6b74('0x47')]?[{'all':!![]}]:undefined})[_0x6b74('0x26')](function(_0xa1d90f){var _0x3a0292=_0x17a09e['user'][_0x6b74('0x27')]({'plain':!![]});if(!_0x3a0292)throw new Error(_0x6b74('0x59'));if(_0x3a0292[_0x6b74('0x4f')]===_0x6b74('0x50')){var _0x170b40=_0xa1d90f[_0x6b74('0x27')]({'plain':!![]});var _0x4d6eb7=_0x6b74('0x28');return db[_0x6b74('0x51')][_0x6b74('0x4c')]({'where':{'name':_0x4d6eb7,'userProfileId':_0x3a0292[_0x6b74('0x5a')]},'raw':!![]})[_0x6b74('0x26')](function(_0x2d8258){if(_0x2d8258&&_0x2d8258[_0x6b74('0x52')]===0x0){return db[_0x6b74('0x29')][_0x6b74('0x53')]({'name':_0x170b40[_0x6b74('0x2d')],'resourceId':_0x170b40['id'],'type':_0x2d8258['name'],'sectionId':_0x2d8258['id']},{})['then'](function(){return _0xa1d90f;});}else{return _0xa1d90f;}})[_0x6b74('0x4d')](function(_0x3a2fd1){logger['error'](_0x6b74('0x54'),_0x3a2fd1);throw _0x3a2fd1;});}return _0xa1d90f;});}})[_0x6b74('0x26')](respondWithResult(_0x1b6e8f,0xc9))[_0x6b74('0x4d')](handleError(_0x1b6e8f,null));};exports[_0x6b74('0x25')]=function(_0x17ed3c,_0x10465d){if(_0x17ed3c[_0x6b74('0x4e')]['id']){delete _0x17ed3c['body']['id'];}return db['Dashboard'][_0x6b74('0x4c')]({'where':{'id':_0x17ed3c['params']['id']}})[_0x6b74('0x26')](handleEntityNotFound(_0x10465d,null))['then'](saveUpdates(_0x17ed3c[_0x6b74('0x4e')],null))['then'](respondWithResult(_0x10465d,null))[_0x6b74('0x4d')](handleError(_0x10465d,null));};exports[_0x6b74('0x2a')]=function(_0x1dd29b,_0xee1a38){return db[_0x6b74('0x45')]['find']({'where':{'id':_0x1dd29b[_0x6b74('0x4a')]['id']}})[_0x6b74('0x26')](handleEntityNotFound(_0xee1a38,null))[_0x6b74('0x26')](removeEntity(_0xee1a38,null))['catch'](handleError(_0xee1a38,null));};function widgetAttributes(_0x2110e2){try{switch(_0x2110e2['type']){case _0x6b74('0x5b'):return[{'name':'attrUrl','value':_0x2110e2[_0x6b74('0x5c')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x0]?_0x2110e2[_0x6b74('0x5d')][0x0][_0x6b74('0x5e')]:undefined)||'https://'}];case _0x6b74('0x5f'):return[{'name':'attrPath','value':_0x2110e2[_0x6b74('0x60')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2['attrs'][0x0]?_0x2110e2[_0x6b74('0x5d')][0x0][_0x6b74('0x5e')]:undefined)||''}];case _0x6b74('0x61'):return[{'name':_0x6b74('0x62'),'value':_0x2110e2[_0x6b74('0x62')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x0]?_0x2110e2[_0x6b74('0x5d')][0x0][_0x6b74('0x5e')]:undefined)||_0x6b74('0x63')},{'name':_0x6b74('0x64'),'value':_0x2110e2[_0x6b74('0x64')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x1]?_0x2110e2[_0x6b74('0x5d')][0x1][_0x6b74('0x5e')]:undefined)||'0.00'},{'name':_0x6b74('0x65'),'value':_0x2110e2['attrFontSize']||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x2]?_0x2110e2[_0x6b74('0x5d')][0x2][_0x6b74('0x5e')]:undefined)||0xc}];case _0x6b74('0x66'):return[{'name':_0x6b74('0x67'),'value':_0x2110e2[_0x6b74('0x67')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x0]?_0x2110e2[_0x6b74('0x5d')][0x0][_0x6b74('0x5e')]:undefined)||_0x6b74('0x68')},{'name':'attrVoiceQueues','value':_0x2110e2[_0x6b74('0x69')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x1]?_0x2110e2[_0x6b74('0x5d')][0x1]['value']:undefined)||[]},{'name':_0x6b74('0x65'),'value':_0x2110e2['attrFontSize']||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x2]?_0x2110e2[_0x6b74('0x5d')][0x2][_0x6b74('0x5e')]:undefined)||0x14}];case _0x6b74('0x6a'):case _0x6b74('0x6b'):return[{'name':_0x6b74('0x6c'),'value':_0x2110e2[_0x6b74('0x6c')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x0]?_0x2110e2[_0x6b74('0x5d')][0x0]['value']:undefined)||_0x6b74('0x68')},{'name':_0x6b74('0x6d'),'value':_0x2110e2[_0x6b74('0x6d')]||(_0x2110e2['attrs']&&_0x2110e2[_0x6b74('0x5d')][0x1]?_0x2110e2[_0x6b74('0x5d')][0x1]['value']:undefined)||null},{'name':_0x6b74('0x6e'),'value':_0x2110e2[_0x6b74('0x6e')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x2]?_0x2110e2[_0x6b74('0x5d')][0x2][_0x6b74('0x5e')]:undefined)||null},{'name':_0x6b74('0x69'),'value':_0x2110e2[_0x6b74('0x69')]||(_0x2110e2['attrs']&&_0x2110e2[_0x6b74('0x5d')][0x3]?_0x2110e2[_0x6b74('0x5d')][0x3][_0x6b74('0x5e')]:undefined)||[]}];case _0x6b74('0x6f'):return[{'name':_0x6b74('0x70'),'type':_0x2110e2[_0x6b74('0x71')]||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x0]?_0x2110e2[_0x6b74('0x5d')][0x0][_0x6b74('0x32')]:undefined)||null,'value':_0x2110e2[_0x6b74('0x70')]||(_0x2110e2['attrs']&&_0x2110e2[_0x6b74('0x5d')][0x0]?_0x2110e2[_0x6b74('0x5d')][0x0][_0x6b74('0x5e')]:undefined)||null},{'name':'attrRefresh','value':_0x2110e2['attrRefresh']||(_0x2110e2[_0x6b74('0x5d')]&&_0x2110e2[_0x6b74('0x5d')][0x1]?_0x2110e2['attrs'][0x1][_0x6b74('0x5e')]:undefined)||0x0}];default:return[];}}catch(_0x487bdb){logger['error'](_0x6b74('0x72'),JSON[_0x6b74('0x73')](_0x487bdb));return[];}}exports[_0x6b74('0x74')]=function(_0x1590e0,_0x10db92,_0x188f64){if(_0x1590e0[_0x6b74('0x4e')]['id']){delete _0x1590e0[_0x6b74('0x4e')]['id'];}return db[_0x6b74('0x45')][_0x6b74('0x4c')]({'where':{'id':_0x1590e0[_0x6b74('0x4a')]['id']}})[_0x6b74('0x26')](handleEntityNotFound(_0x10db92,null))['then'](function(_0xbc9b0a){if(_0xbc9b0a){_0x1590e0[_0x6b74('0x4e')][_0x6b74('0x75')]=_0xbc9b0a['id'];_0x1590e0[_0x6b74('0x4e')][_0x6b74('0x5d')]=widgetAttributes(_0x1590e0[_0x6b74('0x4e')]);return db[_0x6b74('0x76')][_0x6b74('0x53')](_0x1590e0[_0x6b74('0x4e')]);}})[_0x6b74('0x26')](respondWithResult(_0x10db92,null))[_0x6b74('0x4d')](handleError(_0x10db92,null));};exports[_0x6b74('0x77')]=function(_0x33b399,_0x154277,_0xfa961){var _0x3364af={};var _0x480da4={};var _0x1be497;var _0x5829de;return db[_0x6b74('0x45')]['findOne']({'where':{'id':_0x33b399[_0x6b74('0x4a')]['id']}})['then'](handleEntityNotFound(_0x154277,null))[_0x6b74('0x26')](function(_0x1a700c){if(_0x1a700c){_0x1be497=_0x1a700c;_0x480da4[_0x6b74('0x34')]=_[_0x6b74('0x36')](db[_0x6b74('0x76')][_0x6b74('0x4b')]);_0x480da4[_0x6b74('0x35')]=_[_0x6b74('0x36')](_0x33b399[_0x6b74('0x35')]);_0x480da4[_0x6b74('0x37')]=_['intersection'](_0x480da4[_0x6b74('0x34')],_0x480da4[_0x6b74('0x35')]);_0x3364af[_0x6b74('0x39')]=_[_0x6b74('0x38')](_0x480da4[_0x6b74('0x34')],qs[_0x6b74('0x3a')](_0x33b399[_0x6b74('0x35')]['fields']));_0x3364af[_0x6b74('0x39')]=_0x3364af[_0x6b74('0x39')][_0x6b74('0x3b')]?_0x3364af['attributes']:_0x480da4[_0x6b74('0x34')];_0x3364af[_0x6b74('0x78')]=qs[_0x6b74('0x3e')](_0x33b399[_0x6b74('0x35')][_0x6b74('0x3e')]);_0x3364af['where']=qs['filters'](_['pick'](_0x33b399['query'],_0x480da4[_0x6b74('0x37')]));if(_0x33b399[_0x6b74('0x35')][_0x6b74('0x43')]){_0x3364af[_0x6b74('0x40')]=_[_0x6b74('0x41')](_0x3364af[_0x6b74('0x40')],{'$or':_[_0x6b74('0x30')](_0x3364af[_0x6b74('0x39')],function(_0x59b39f){var _0xb0344c={};_0xb0344c[_0x59b39f]={'$like':'%'+_0x33b399['query'][_0x6b74('0x43')]+'%'};return _0xb0344c;})});}_0x3364af=_[_0x6b74('0x41')]({},_0x3364af,_0x33b399[_0x6b74('0x44')]);return _0x1be497[_0x6b74('0x77')](_0x3364af);}})[_0x6b74('0x26')](function(_0x7f7d5e){if(_0x7f7d5e){_0x5829de=_0x7f7d5e[_0x6b74('0x3b')];if(!_0x33b399[_0x6b74('0x35')][_0x6b74('0x3c')](_0x6b74('0x3d'))){_0x3364af[_0x6b74('0x1f')]=qs[_0x6b74('0x1f')](_0x33b399[_0x6b74('0x35')][_0x6b74('0x1f')]);_0x3364af[_0x6b74('0x1e')]=qs[_0x6b74('0x1e')](_0x33b399['query']['offset']);}return _0x1be497[_0x6b74('0x77')](_0x3364af);}})[_0x6b74('0x26')](function(_0x3578fc){if(_0x3578fc){return _0x3578fc?{'count':_0x5829de,'rows':_0x3578fc}:null;}})[_0x6b74('0x26')](respondWithResult(_0x154277,null))[_0x6b74('0x4d')](handleError(_0x154277,null));};