Built motion from commit (unavailable).|2.6.0
[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 _0x5ae6=['attrReport','reportType','attrRefresh','widgetAttributes:\x20%s','stringify','addItem','DashboardId','DashboardItem','getItems','findOne','eml-format','rimraf','zip-dir','fast-json-patch','bluebird','mustache','util','path','sox','to-csv','fs-extra','crypto','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','redis','socket.io-emitter','./dashboard.socket','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','save','update','then','destroy','get','CustomDashboards','UserProfileResource','error','stack','name','send','index','map','Dashboard','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','options','includeAll','rows','catch','show','params','include','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','createdAt','updatedAt','body','iframe','attrUrl','attrs','value','https://','attrPath','attrHourFormat','attrTimezone','0.00','attrFontSize','counter','attrMetric','total','attrVoiceQueues','multibar-chart','pie-chart','attrSerie1','attrSerie2','attrSerie3','web-report'];(function(_0x56482c,_0x16118d){var _0x5aae7a=function(_0x52512f){while(--_0x52512f){_0x56482c['push'](_0x56482c['shift']());}};_0x5aae7a(++_0x16118d);}(_0x5ae6,0x16f));var _0x65ae=function(_0x32d414,_0x4d23da){_0x32d414=_0x32d414-0x0;var _0x4e0bca=_0x5ae6[_0x32d414];return _0x4e0bca;};'use strict';var emlformat=require(_0x65ae('0x0'));var rimraf=require(_0x65ae('0x1'));var zipdir=require(_0x65ae('0x2'));var jsonpatch=require(_0x65ae('0x3'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x65ae('0x4'));var Mustache=require(_0x65ae('0x5'));var util=require(_0x65ae('0x6'));var path=require(_0x65ae('0x7'));var sox=require(_0x65ae('0x8'));var csv=require(_0x65ae('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x65ae('0xa'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x65ae('0xb'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x65ae('0x9'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x65ae('0xc'));var authService=require(_0x65ae('0xd'));var qs=require(_0x65ae('0xe'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x65ae('0xf'));var logger=require('../../config/logger')(_0x65ae('0x10'));var utils=require(_0x65ae('0x11'));var config=require(_0x65ae('0x12'));var licenseUtil=require(_0x65ae('0x13'));var db=require(_0x65ae('0x14'))['db'];config['redis']=_[_0x65ae('0x15')](config[_0x65ae('0x16')],{'host':'localhost','port':0x18eb});var socket=require(_0x65ae('0x17'))(new Redis(config[_0x65ae('0x16')]));require(_0x65ae('0x18'))['register'](socket);function respondWithStatusCode(_0x80b79,_0x2eb107){_0x2eb107=_0x2eb107||0xcc;return function(_0x54a280){if(_0x54a280){return _0x80b79[_0x65ae('0x19')](_0x2eb107);}return _0x80b79[_0x65ae('0x1a')](_0x2eb107)[_0x65ae('0x1b')]();};}function respondWithResult(_0x2f7b90,_0x333e10){_0x333e10=_0x333e10||0xc8;return function(_0x1f96c5){if(_0x1f96c5){return _0x2f7b90['status'](_0x333e10)[_0x65ae('0x1c')](_0x1f96c5);}};}function respondWithFilteredResult(_0x27b9b6,_0x23e7cc){return function(_0x423a02){if(_0x423a02){var _0xfb17b0=typeof _0x23e7cc[_0x65ae('0x1d')]===_0x65ae('0x1e')&&typeof _0x23e7cc[_0x65ae('0x1f')]===_0x65ae('0x1e');var _0x3293a5=_0x423a02['count'];var _0x3f2e26=_0xfb17b0?0x0:_0x23e7cc[_0x65ae('0x1d')];var _0x5ce75c=_0xfb17b0?_0x423a02[_0x65ae('0x20')]:_0x23e7cc['offset']+_0x23e7cc[_0x65ae('0x1f')];var _0x506496;if(_0x5ce75c>=_0x3293a5){_0x5ce75c=_0x3293a5;_0x506496=0xc8;}else{_0x506496=0xce;}_0x27b9b6[_0x65ae('0x1a')](_0x506496);return _0x27b9b6[_0x65ae('0x21')](_0x65ae('0x22'),_0x3f2e26+'-'+_0x5ce75c+'/'+_0x3293a5)[_0x65ae('0x1c')](_0x423a02);}return null;};}function patchUpdates(_0x454cc8){return function(_0x170265){try{jsonpatch[_0x65ae('0x23')](_0x170265,_0x454cc8,!![]);}catch(_0x5d2392){return BPromise['reject'](_0x5d2392);}return _0x170265[_0x65ae('0x24')]();};}function saveUpdates(_0x51ac13,_0x30eb03){return function(_0x56286a){if(_0x56286a){return _0x56286a[_0x65ae('0x25')](_0x51ac13)[_0x65ae('0x26')](function(_0x4dab7a){return _0x4dab7a;});}return null;};}function removeEntity(_0x516ee4,_0x4e311d){return function(_0x29079c){if(_0x29079c){return _0x29079c[_0x65ae('0x27')]()[_0x65ae('0x26')](function(){var _0x26dcd0=_0x29079c[_0x65ae('0x28')]({'plain':!![]});var _0xd20bf9=_0x65ae('0x29');return db[_0x65ae('0x2a')][_0x65ae('0x27')]({'where':{'type':_0xd20bf9,'resourceId':_0x26dcd0['id']}})[_0x65ae('0x26')](function(){return _0x29079c;});})[_0x65ae('0x26')](function(){_0x516ee4[_0x65ae('0x1a')](0xcc)[_0x65ae('0x1b')]();});}};}function handleEntityNotFound(_0x330dd9,_0x505d9f){return function(_0x5d87ce){if(!_0x5d87ce){_0x330dd9[_0x65ae('0x19')](0x194);}return _0x5d87ce;};}function handleError(_0x2afc3f,_0x1ea2a3){_0x1ea2a3=_0x1ea2a3||0x1f4;return function(_0x515850){logger[_0x65ae('0x2b')](_0x515850[_0x65ae('0x2c')]);if(_0x515850[_0x65ae('0x2d')]){delete _0x515850[_0x65ae('0x2d')];}_0x2afc3f[_0x65ae('0x1a')](_0x1ea2a3)[_0x65ae('0x2e')](_0x515850);};}exports[_0x65ae('0x2f')]=function(_0x315e5e,_0x2f734e){var _0xfa3708={},_0x5bd416={},_0x3ba04e={'count':0x0,'rows':[]};var _0x35439e=_[_0x65ae('0x30')](db[_0x65ae('0x31')][_0x65ae('0x32')],function(_0x40f4f1){return{'name':_0x40f4f1[_0x65ae('0x33')],'type':_0x40f4f1[_0x65ae('0x34')][_0x65ae('0x35')]};});_0x5bd416[_0x65ae('0x36')]=_[_0x65ae('0x30')](_0x35439e,_0x65ae('0x2d'));_0x5bd416['query']=_[_0x65ae('0x37')](_0x315e5e[_0x65ae('0x38')]);_0x5bd416[_0x65ae('0x39')]=_[_0x65ae('0x3a')](_0x5bd416[_0x65ae('0x36')],_0x5bd416[_0x65ae('0x38')]);_0xfa3708['attributes']=_[_0x65ae('0x3a')](_0x5bd416[_0x65ae('0x36')],qs[_0x65ae('0x3b')](_0x315e5e['query'][_0x65ae('0x3b')]));_0xfa3708[_0x65ae('0x3c')]=_0xfa3708['attributes'][_0x65ae('0x3d')]?_0xfa3708['attributes']:_0x5bd416['model'];if(!_0x315e5e[_0x65ae('0x38')][_0x65ae('0x3e')](_0x65ae('0x3f'))){_0xfa3708[_0x65ae('0x1f')]=qs[_0x65ae('0x1f')](_0x315e5e[_0x65ae('0x38')][_0x65ae('0x1f')]);_0xfa3708['offset']=qs[_0x65ae('0x1d')](_0x315e5e[_0x65ae('0x38')][_0x65ae('0x1d')]);}_0xfa3708[_0x65ae('0x40')]=qs['sort'](_0x315e5e['query'][_0x65ae('0x41')]);_0xfa3708[_0x65ae('0x42')]=qs[_0x65ae('0x39')](_['pick'](_0x315e5e[_0x65ae('0x38')],_0x5bd416[_0x65ae('0x39')]),_0x35439e);if(_0x315e5e['query'][_0x65ae('0x43')]){_0xfa3708[_0x65ae('0x42')]=_[_0x65ae('0x44')](_0xfa3708[_0x65ae('0x42')],{'$or':_['map'](_0x35439e,function(_0x56a33f){if(_0x56a33f[_0x65ae('0x34')]!=='VIRTUAL'){var _0x1b9d5c={};_0x1b9d5c[_0x56a33f[_0x65ae('0x2d')]]={'$like':'%'+_0x315e5e['query'][_0x65ae('0x43')]+'%'};return _0x1b9d5c;}})});}_0xfa3708=_[_0x65ae('0x44')]({},_0xfa3708,_0x315e5e[_0x65ae('0x45')]);var _0x4316ab={'where':_0xfa3708[_0x65ae('0x42')]};return db[_0x65ae('0x31')][_0x65ae('0x20')](_0x4316ab)[_0x65ae('0x26')](function(_0x420ae6){_0x3ba04e[_0x65ae('0x20')]=_0x420ae6;if(_0x315e5e[_0x65ae('0x38')][_0x65ae('0x46')]){_0xfa3708['include']=[{'all':!![]}];}return db[_0x65ae('0x31')]['findAll'](_0xfa3708);})[_0x65ae('0x26')](function(_0x2edaf2){_0x3ba04e[_0x65ae('0x47')]=_0x2edaf2;return _0x3ba04e;})[_0x65ae('0x26')](respondWithFilteredResult(_0x2f734e,_0xfa3708))[_0x65ae('0x48')](handleError(_0x2f734e,null));};exports[_0x65ae('0x49')]=function(_0x13fea9,_0xfbb3e9){var _0x487fe7={'raw':![],'where':{'id':_0x13fea9[_0x65ae('0x4a')]['id']}},_0x4defed={};_0x4defed['model']=_[_0x65ae('0x37')](db[_0x65ae('0x31')][_0x65ae('0x32')]);_0x4defed[_0x65ae('0x38')]=_[_0x65ae('0x37')](_0x13fea9[_0x65ae('0x38')]);_0x4defed['filters']=_[_0x65ae('0x3a')](_0x4defed[_0x65ae('0x36')],_0x4defed[_0x65ae('0x38')]);_0x487fe7['attributes']=_[_0x65ae('0x3a')](_0x4defed[_0x65ae('0x36')],qs[_0x65ae('0x3b')](_0x13fea9['query'][_0x65ae('0x3b')]));_0x487fe7['attributes']=_0x487fe7[_0x65ae('0x3c')][_0x65ae('0x3d')]?_0x487fe7['attributes']:_0x4defed[_0x65ae('0x36')];if(_0x13fea9[_0x65ae('0x38')][_0x65ae('0x46')]){_0x487fe7[_0x65ae('0x4b')]=[{'all':!![]}];}_0x487fe7=_[_0x65ae('0x44')]({},_0x487fe7,_0x13fea9['options']);return db[_0x65ae('0x31')]['find'](_0x487fe7)[_0x65ae('0x26')](handleEntityNotFound(_0xfbb3e9,null))['then'](respondWithResult(_0xfbb3e9,null))[_0x65ae('0x48')](handleError(_0xfbb3e9,null));};exports[_0x65ae('0x4c')]=function(_0x43af34,_0x46c257){return db['Dashboard']['create'](_0x43af34['body'],{})[_0x65ae('0x26')](function(_0x1ed064){var _0x4760e1=_0x43af34['user'][_0x65ae('0x28')]({'plain':!![]});if(!_0x4760e1)throw new Error(_0x65ae('0x4d'));if(_0x4760e1[_0x65ae('0x4e')]===_0x65ae('0x4f')){var _0xbfc2e0=_0x1ed064[_0x65ae('0x28')]({'plain':!![]});var _0x1b3bd8=_0x65ae('0x29');return db[_0x65ae('0x50')][_0x65ae('0x51')]({'where':{'name':_0x1b3bd8,'userProfileId':_0x4760e1[_0x65ae('0x52')]},'raw':!![]})[_0x65ae('0x26')](function(_0x14c8cb){if(_0x14c8cb&&_0x14c8cb[_0x65ae('0x53')]===0x0){return db[_0x65ae('0x2a')][_0x65ae('0x4c')]({'name':_0xbfc2e0[_0x65ae('0x2d')],'resourceId':_0xbfc2e0['id'],'type':_0x14c8cb[_0x65ae('0x2d')],'sectionId':_0x14c8cb['id']},{})['then'](function(){return _0x1ed064;});}else{return _0x1ed064;}})[_0x65ae('0x48')](function(_0x410d21){logger[_0x65ae('0x2b')](_0x65ae('0x54'),_0x410d21);throw _0x410d21;});}return _0x1ed064;})[_0x65ae('0x26')](respondWithResult(_0x46c257,0xc9))[_0x65ae('0x48')](handleError(_0x46c257,null));};exports['clone']=function(_0x614d00,_0x4d0b10){var _0x423ce8={'where':{'id':_0x614d00[_0x65ae('0x4a')]['id']}},_0x689f53={};_0x689f53[_0x65ae('0x36')]=_[_0x65ae('0x37')](db[_0x65ae('0x31')]['rawAttributes']);_0x423ce8[_0x65ae('0x3c')]=_[_0x65ae('0x3a')](_0x689f53['model'],qs[_0x65ae('0x3b')](_0x614d00[_0x65ae('0x38')][_0x65ae('0x3b')]));_0x423ce8[_0x65ae('0x3c')]=_0x423ce8[_0x65ae('0x3c')][_0x65ae('0x3d')]?_0x423ce8[_0x65ae('0x3c')]:_0x689f53[_0x65ae('0x36')];if(_0x614d00[_0x65ae('0x38')]['includeAll']){_0x423ce8[_0x65ae('0x4b')]=[{'all':!![]}];}_0x423ce8=_[_0x65ae('0x44')]({},_0x423ce8,_0x614d00[_0x65ae('0x45')]);return db['Dashboard'][_0x65ae('0x51')](_0x423ce8)[_0x65ae('0x26')](handleEntityNotFound(_0x4d0b10,null))[_0x65ae('0x26')](function(_0x21d546){if(_0x21d546){var _0x5298e3=_0x21d546[_0x65ae('0x28')]({'plain':!![]});_0x5298e3=qs[_0x65ae('0x55')](_0x5298e3,['id',_0x65ae('0x56'),_0x65ae('0x57')]);_0x614d00[_0x65ae('0x58')]=_[_0x65ae('0x55')](_0x614d00['body'],['id',_0x65ae('0x56'),'updatedAt']);return db[_0x65ae('0x31')][_0x65ae('0x4c')](_[_0x65ae('0x44')](_0x5298e3,_0x614d00[_0x65ae('0x58')]),{'include':_0x614d00[_0x65ae('0x38')][_0x65ae('0x46')]?[{'all':!![]}]:undefined})[_0x65ae('0x26')](function(_0x392d07){var _0x217ae8=_0x614d00['user'][_0x65ae('0x28')]({'plain':!![]});if(!_0x217ae8)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x217ae8['role']===_0x65ae('0x4f')){var _0x4e3e29=_0x392d07[_0x65ae('0x28')]({'plain':!![]});var _0x50f3a1=_0x65ae('0x29');return db[_0x65ae('0x50')][_0x65ae('0x51')]({'where':{'name':_0x50f3a1,'userProfileId':_0x217ae8[_0x65ae('0x52')]},'raw':!![]})[_0x65ae('0x26')](function(_0x5d20da){if(_0x5d20da&&_0x5d20da[_0x65ae('0x53')]===0x0){return db[_0x65ae('0x2a')][_0x65ae('0x4c')]({'name':_0x4e3e29[_0x65ae('0x2d')],'resourceId':_0x4e3e29['id'],'type':_0x5d20da['name'],'sectionId':_0x5d20da['id']},{})[_0x65ae('0x26')](function(){return _0x392d07;});}else{return _0x392d07;}})[_0x65ae('0x48')](function(_0x518b79){logger[_0x65ae('0x2b')](_0x65ae('0x54'),_0x518b79);throw _0x518b79;});}return _0x392d07;});}})['then'](respondWithResult(_0x4d0b10,0xc9))[_0x65ae('0x48')](handleError(_0x4d0b10,null));};exports['update']=function(_0x1b0831,_0x53e923){if(_0x1b0831[_0x65ae('0x58')]['id']){delete _0x1b0831[_0x65ae('0x58')]['id'];}return db[_0x65ae('0x31')]['find']({'where':{'id':_0x1b0831[_0x65ae('0x4a')]['id']}})[_0x65ae('0x26')](handleEntityNotFound(_0x53e923,null))[_0x65ae('0x26')](saveUpdates(_0x1b0831[_0x65ae('0x58')],null))['then'](respondWithResult(_0x53e923,null))[_0x65ae('0x48')](handleError(_0x53e923,null));};exports[_0x65ae('0x27')]=function(_0x3fbb31,_0x46c0ec){return db[_0x65ae('0x31')]['find']({'where':{'id':_0x3fbb31[_0x65ae('0x4a')]['id']}})[_0x65ae('0x26')](handleEntityNotFound(_0x46c0ec,null))[_0x65ae('0x26')](removeEntity(_0x46c0ec,null))[_0x65ae('0x48')](handleError(_0x46c0ec,null));};function widgetAttributes(_0x4144a1){try{switch(_0x4144a1[_0x65ae('0x34')]){case _0x65ae('0x59'):return[{'name':_0x65ae('0x5a'),'value':_0x4144a1[_0x65ae('0x5a')]||(_0x4144a1['attrs']&&_0x4144a1[_0x65ae('0x5b')][0x0]?_0x4144a1[_0x65ae('0x5b')][0x0][_0x65ae('0x5c')]:undefined)||_0x65ae('0x5d')}];case'custom':return[{'name':'attrPath','value':_0x4144a1[_0x65ae('0x5e')]||(_0x4144a1['attrs']&&_0x4144a1[_0x65ae('0x5b')][0x0]?_0x4144a1[_0x65ae('0x5b')][0x0][_0x65ae('0x5c')]:undefined)||''}];case'clock':return[{'name':_0x65ae('0x5f'),'value':_0x4144a1[_0x65ae('0x5f')]||(_0x4144a1[_0x65ae('0x5b')]&&_0x4144a1[_0x65ae('0x5b')][0x0]?_0x4144a1[_0x65ae('0x5b')][0x0][_0x65ae('0x5c')]:undefined)||'HH:mm:ss'},{'name':_0x65ae('0x60'),'value':_0x4144a1[_0x65ae('0x60')]||(_0x4144a1[_0x65ae('0x5b')]&&_0x4144a1[_0x65ae('0x5b')][0x1]?_0x4144a1[_0x65ae('0x5b')][0x1][_0x65ae('0x5c')]:undefined)||_0x65ae('0x61')},{'name':_0x65ae('0x62'),'value':_0x4144a1['attrFontSize']||(_0x4144a1['attrs']&&_0x4144a1[_0x65ae('0x5b')][0x2]?_0x4144a1[_0x65ae('0x5b')][0x2][_0x65ae('0x5c')]:undefined)||0xc}];case _0x65ae('0x63'):return[{'name':_0x65ae('0x64'),'value':_0x4144a1[_0x65ae('0x64')]||(_0x4144a1[_0x65ae('0x5b')]&&_0x4144a1[_0x65ae('0x5b')][0x0]?_0x4144a1[_0x65ae('0x5b')][0x0]['value']:undefined)||_0x65ae('0x65')},{'name':'attrVoiceQueues','value':_0x4144a1[_0x65ae('0x66')]||(_0x4144a1[_0x65ae('0x5b')]&&_0x4144a1[_0x65ae('0x5b')][0x1]?_0x4144a1[_0x65ae('0x5b')][0x1][_0x65ae('0x5c')]:undefined)||[]},{'name':_0x65ae('0x62'),'value':_0x4144a1[_0x65ae('0x62')]||(_0x4144a1[_0x65ae('0x5b')]&&_0x4144a1[_0x65ae('0x5b')][0x2]?_0x4144a1[_0x65ae('0x5b')][0x2][_0x65ae('0x5c')]:undefined)||0x14}];case _0x65ae('0x67'):case _0x65ae('0x68'):return[{'name':_0x65ae('0x69'),'value':_0x4144a1[_0x65ae('0x69')]||(_0x4144a1[_0x65ae('0x5b')]&&_0x4144a1['attrs'][0x0]?_0x4144a1['attrs'][0x0]['value']:undefined)||_0x65ae('0x65')},{'name':_0x65ae('0x6a'),'value':_0x4144a1['attrSerie2']||(_0x4144a1[_0x65ae('0x5b')]&&_0x4144a1['attrs'][0x1]?_0x4144a1[_0x65ae('0x5b')][0x1][_0x65ae('0x5c')]:undefined)||null},{'name':'attrSerie3','value':_0x4144a1[_0x65ae('0x6b')]||(_0x4144a1['attrs']&&_0x4144a1['attrs'][0x2]?_0x4144a1[_0x65ae('0x5b')][0x2][_0x65ae('0x5c')]:undefined)||null},{'name':_0x65ae('0x66'),'value':_0x4144a1[_0x65ae('0x66')]||(_0x4144a1['attrs']&&_0x4144a1[_0x65ae('0x5b')][0x3]?_0x4144a1[_0x65ae('0x5b')][0x3]['value']:undefined)||[]}];case _0x65ae('0x6c'):return[{'name':_0x65ae('0x6d'),'type':_0x4144a1[_0x65ae('0x6e')]||(_0x4144a1['attrs']&&_0x4144a1[_0x65ae('0x5b')][0x0]?_0x4144a1['attrs'][0x0]['type']:undefined)||null,'value':_0x4144a1[_0x65ae('0x6d')]||(_0x4144a1['attrs']&&_0x4144a1[_0x65ae('0x5b')][0x0]?_0x4144a1[_0x65ae('0x5b')][0x0]['value']:undefined)||null},{'name':_0x65ae('0x6f'),'value':_0x4144a1[_0x65ae('0x6f')]||(_0x4144a1['attrs']&&_0x4144a1[_0x65ae('0x5b')][0x1]?_0x4144a1[_0x65ae('0x5b')][0x1]['value']:undefined)||0x0}];default:return[];}}catch(_0x18c5b2){logger['error'](_0x65ae('0x70'),JSON[_0x65ae('0x71')](_0x18c5b2));return[];}}exports[_0x65ae('0x72')]=function(_0x3bf30e,_0x45c9de,_0x17aaff){if(_0x3bf30e[_0x65ae('0x58')]['id']){delete _0x3bf30e[_0x65ae('0x58')]['id'];}return db['Dashboard'][_0x65ae('0x51')]({'where':{'id':_0x3bf30e[_0x65ae('0x4a')]['id']}})[_0x65ae('0x26')](handleEntityNotFound(_0x45c9de,null))[_0x65ae('0x26')](function(_0x261c3c){if(_0x261c3c){_0x3bf30e[_0x65ae('0x58')][_0x65ae('0x73')]=_0x261c3c['id'];_0x3bf30e['body']['attrs']=widgetAttributes(_0x3bf30e[_0x65ae('0x58')]);return db[_0x65ae('0x74')][_0x65ae('0x4c')](_0x3bf30e[_0x65ae('0x58')]);}})[_0x65ae('0x26')](respondWithResult(_0x45c9de,null))[_0x65ae('0x48')](handleError(_0x45c9de,null));};exports[_0x65ae('0x75')]=function(_0x9fac13,_0x48f4e2,_0x9e5d4b){var _0x368922={};var _0x2c4b18={};var _0x265269;var _0x31fede;return db[_0x65ae('0x31')][_0x65ae('0x76')]({'where':{'id':_0x9fac13[_0x65ae('0x4a')]['id']}})[_0x65ae('0x26')](handleEntityNotFound(_0x48f4e2,null))[_0x65ae('0x26')](function(_0x1ecc90){if(_0x1ecc90){_0x265269=_0x1ecc90;_0x2c4b18['model']=_[_0x65ae('0x37')](db[_0x65ae('0x74')][_0x65ae('0x32')]);_0x2c4b18[_0x65ae('0x38')]=_[_0x65ae('0x37')](_0x9fac13[_0x65ae('0x38')]);_0x2c4b18[_0x65ae('0x39')]=_[_0x65ae('0x3a')](_0x2c4b18[_0x65ae('0x36')],_0x2c4b18[_0x65ae('0x38')]);_0x368922[_0x65ae('0x3c')]=_[_0x65ae('0x3a')](_0x2c4b18[_0x65ae('0x36')],qs['fields'](_0x9fac13[_0x65ae('0x38')]['fields']));_0x368922[_0x65ae('0x3c')]=_0x368922['attributes'][_0x65ae('0x3d')]?_0x368922[_0x65ae('0x3c')]:_0x2c4b18[_0x65ae('0x36')];_0x368922[_0x65ae('0x40')]=qs[_0x65ae('0x41')](_0x9fac13[_0x65ae('0x38')][_0x65ae('0x41')]);_0x368922[_0x65ae('0x42')]=qs['filters'](_['pick'](_0x9fac13[_0x65ae('0x38')],_0x2c4b18[_0x65ae('0x39')]));if(_0x9fac13[_0x65ae('0x38')][_0x65ae('0x43')]){_0x368922['where']=_['merge'](_0x368922[_0x65ae('0x42')],{'$or':_[_0x65ae('0x30')](_0x368922[_0x65ae('0x3c')],function(_0x3a12ca){var _0x52cb85={};_0x52cb85[_0x3a12ca]={'$like':'%'+_0x9fac13[_0x65ae('0x38')][_0x65ae('0x43')]+'%'};return _0x52cb85;})});}_0x368922=_[_0x65ae('0x44')]({},_0x368922,_0x9fac13[_0x65ae('0x45')]);return _0x265269[_0x65ae('0x75')](_0x368922);}})[_0x65ae('0x26')](function(_0x5ece65){if(_0x5ece65){_0x31fede=_0x5ece65[_0x65ae('0x3d')];if(!_0x9fac13[_0x65ae('0x38')][_0x65ae('0x3e')](_0x65ae('0x3f'))){_0x368922[_0x65ae('0x1f')]=qs[_0x65ae('0x1f')](_0x9fac13[_0x65ae('0x38')][_0x65ae('0x1f')]);_0x368922[_0x65ae('0x1d')]=qs[_0x65ae('0x1d')](_0x9fac13[_0x65ae('0x38')]['offset']);}return _0x265269[_0x65ae('0x75')](_0x368922);}})['then'](function(_0x849cb5){if(_0x849cb5){return _0x849cb5?{'count':_0x31fede,'rows':_0x849cb5}:null;}})['then'](respondWithResult(_0x48f4e2,null))['catch'](handleError(_0x48f4e2,null));};