Built motion from commit (unavailable).|2.5.4
[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 _0x4e5e=['attrSerie3','web-report','attrReport','reportType','attrRefresh','widgetAttributes:\x20%s','stringify','addItem','DashboardId','DashboardItem','getItems','findOne','hasOwnProperty','nolimit','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','socket.io-emitter','register','sendStatus','status','end','count','offset','limit','set','reject','update','then','get','CustomDashboards','destroy','error','name','send','index','Dashboard','rawAttributes','fieldName','type','key','model','query','filters','attributes','intersection','fields','length','order','sort','pick','where','merge','map','VIRTUAL','filter','options','includeAll','include','findAll','rows','catch','params','keys','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','body','updatedAt','role','iframe','attrUrl','attrs','value','clock','attrHourFormat','HH:mm:ss','attrTimezone','attrFontSize','counter','attrMetric','attrVoiceQueues','multibar-chart','pie-chart','attrSerie1','total','attrSerie2'];(function(_0x4cce65,_0x40021e){var _0x4d1b45=function(_0x54d290){while(--_0x54d290){_0x4cce65['push'](_0x4cce65['shift']());}};_0x4d1b45(++_0x40021e);}(_0x4e5e,0x179));var _0xe4e5=function(_0x4f8fc4,_0x483e4d){_0x4f8fc4=_0x4f8fc4-0x0;var _0x106eaa=_0x4e5e[_0x4f8fc4];return _0x106eaa;};'use strict';var pdf=require(_0xe4e5('0x0'));var emlformat=require(_0xe4e5('0x1'));var rimraf=require(_0xe4e5('0x2'));var zipdir=require(_0xe4e5('0x3'));var jsonpatch=require(_0xe4e5('0x4'));var rp=require(_0xe4e5('0x5'));var moment=require(_0xe4e5('0x6'));var BPromise=require(_0xe4e5('0x7'));var Mustache=require(_0xe4e5('0x8'));var util=require(_0xe4e5('0x9'));var path=require(_0xe4e5('0xa'));var sox=require(_0xe4e5('0xb'));var csv=require(_0xe4e5('0xc'));var ejs=require(_0xe4e5('0xd'));var fs=require('fs');var _=require('lodash');var squel=require(_0xe4e5('0xe'));var crypto=require(_0xe4e5('0xf'));var jsforce=require(_0xe4e5('0x10'));var deskjs=require(_0xe4e5('0x11'));var toCsv=require(_0xe4e5('0xc'));var querystring=require(_0xe4e5('0x12'));var Papa=require('papaparse');var Redis=require(_0xe4e5('0x13'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0xe4e5('0x14'));var hardwareService=require(_0xe4e5('0x15'));var logger=require(_0xe4e5('0x16'))(_0xe4e5('0x17'));var utils=require(_0xe4e5('0x18'));var config=require(_0xe4e5('0x19'));var db=require(_0xe4e5('0x1a'))['db'];config[_0xe4e5('0x1b')]=_[_0xe4e5('0x1c')](config['redis'],{'host':'localhost','port':0x18eb});var socket=require(_0xe4e5('0x1d'))(new Redis(config[_0xe4e5('0x1b')]));require('./dashboard.socket')[_0xe4e5('0x1e')](socket);function respondWithStatusCode(_0x33a1f3,_0x2fe9f0){_0x2fe9f0=_0x2fe9f0||0xcc;return function(_0x1b1b64){if(_0x1b1b64){return _0x33a1f3[_0xe4e5('0x1f')](_0x2fe9f0);}return _0x33a1f3[_0xe4e5('0x20')](_0x2fe9f0)[_0xe4e5('0x21')]();};}function respondWithResult(_0x4ae919,_0x439220){_0x439220=_0x439220||0xc8;return function(_0x9f9695){if(_0x9f9695){return _0x4ae919[_0xe4e5('0x20')](_0x439220)['json'](_0x9f9695);}};}function respondWithFilteredResult(_0x168496,_0x108376){return function(_0x355b3d){if(_0x355b3d){var _0x3e8918=_0x355b3d[_0xe4e5('0x22')],_0x34d102=_0x108376[_0xe4e5('0x23')],_0x1166fb=_0x108376[_0xe4e5('0x23')]+_0x108376[_0xe4e5('0x24')],_0x146fa2;if(_0x1166fb>=_0x3e8918){_0x1166fb=_0x3e8918;_0x146fa2=0xc8;}else{_0x146fa2=0xce;}_0x168496[_0xe4e5('0x20')](_0x146fa2);return _0x168496[_0xe4e5('0x25')]('Content-Range',_0x34d102+'-'+_0x1166fb+'/'+_0x3e8918)['json'](_0x355b3d);}return null;};}function patchUpdates(_0x3c0367){return function(_0x371491){try{jsonpatch['apply'](_0x371491,_0x3c0367,!![]);}catch(_0xfa04f7){return BPromise[_0xe4e5('0x26')](_0xfa04f7);}return _0x371491['save']();};}function saveUpdates(_0x3c5876,_0x1dd7c4){return function(_0x4111af){if(_0x4111af){return _0x4111af[_0xe4e5('0x27')](_0x3c5876)[_0xe4e5('0x28')](function(_0x1b2f2b){return _0x1b2f2b;});}return null;};}function removeEntity(_0x219a27,_0x1f1582){return function(_0x1674f3){if(_0x1674f3){return _0x1674f3['destroy']()['then'](function(){var _0x46b202=_0x1674f3[_0xe4e5('0x29')]({'plain':!![]});var _0x4e8e79=_0xe4e5('0x2a');return db['UserProfileResource'][_0xe4e5('0x2b')]({'where':{'type':_0x4e8e79,'resourceId':_0x46b202['id']}})[_0xe4e5('0x28')](function(){return _0x1674f3;});})[_0xe4e5('0x28')](function(){_0x219a27[_0xe4e5('0x20')](0xcc)['end']();});}};}function handleEntityNotFound(_0x47b250,_0x11a240){return function(_0x36b2f6){if(!_0x36b2f6){_0x47b250[_0xe4e5('0x1f')](0x194);}return _0x36b2f6;};}function handleError(_0x1de203,_0x3ed6f0){_0x3ed6f0=_0x3ed6f0||0x1f4;return function(_0x437bc1){logger[_0xe4e5('0x2c')](_0x437bc1['stack']);if(_0x437bc1[_0xe4e5('0x2d')]){delete _0x437bc1[_0xe4e5('0x2d')];}_0x1de203[_0xe4e5('0x20')](_0x3ed6f0)[_0xe4e5('0x2e')](_0x437bc1);};}exports[_0xe4e5('0x2f')]=function(_0x3f2455,_0x56df2f){var _0x12b8c3={},_0x13c174={},_0x41be2b={'count':0x0,'rows':[]};var _0x5c1e85=_['map'](db[_0xe4e5('0x30')][_0xe4e5('0x31')],function(_0x10b5c6){return{'name':_0x10b5c6[_0xe4e5('0x32')],'type':_0x10b5c6[_0xe4e5('0x33')][_0xe4e5('0x34')]};});_0x13c174[_0xe4e5('0x35')]=_['map'](_0x5c1e85,'name');_0x13c174[_0xe4e5('0x36')]=_['keys'](_0x3f2455[_0xe4e5('0x36')]);_0x13c174[_0xe4e5('0x37')]=_['intersection'](_0x13c174['model'],_0x13c174['query']);_0x12b8c3[_0xe4e5('0x38')]=_[_0xe4e5('0x39')](_0x13c174[_0xe4e5('0x35')],qs['fields'](_0x3f2455[_0xe4e5('0x36')][_0xe4e5('0x3a')]));_0x12b8c3[_0xe4e5('0x38')]=_0x12b8c3[_0xe4e5('0x38')][_0xe4e5('0x3b')]?_0x12b8c3[_0xe4e5('0x38')]:_0x13c174[_0xe4e5('0x35')];if(!_0x3f2455[_0xe4e5('0x36')]['hasOwnProperty']('nolimit')){_0x12b8c3[_0xe4e5('0x24')]=qs['limit'](_0x3f2455[_0xe4e5('0x36')]['limit']);_0x12b8c3[_0xe4e5('0x23')]=qs['offset'](_0x3f2455['query'][_0xe4e5('0x23')]);}_0x12b8c3[_0xe4e5('0x3c')]=qs[_0xe4e5('0x3d')](_0x3f2455[_0xe4e5('0x36')]['sort']);_0x12b8c3['where']=qs[_0xe4e5('0x37')](_[_0xe4e5('0x3e')](_0x3f2455[_0xe4e5('0x36')],_0x13c174[_0xe4e5('0x37')]),_0x5c1e85);if(_0x3f2455['query']['filter']){_0x12b8c3[_0xe4e5('0x3f')]=_[_0xe4e5('0x40')](_0x12b8c3[_0xe4e5('0x3f')],{'$or':_[_0xe4e5('0x41')](_0x5c1e85,function(_0x2e03cf){if(_0x2e03cf[_0xe4e5('0x33')]!==_0xe4e5('0x42')){var _0x3b3c53={};_0x3b3c53[_0x2e03cf[_0xe4e5('0x2d')]]={'$like':'%'+_0x3f2455['query'][_0xe4e5('0x43')]+'%'};return _0x3b3c53;}})});}_0x12b8c3=_[_0xe4e5('0x40')]({},_0x12b8c3,_0x3f2455[_0xe4e5('0x44')]);var _0xe17725={'where':_0x12b8c3[_0xe4e5('0x3f')]};return db[_0xe4e5('0x30')][_0xe4e5('0x22')](_0xe17725)[_0xe4e5('0x28')](function(_0x112380){_0x41be2b['count']=_0x112380;if(_0x3f2455[_0xe4e5('0x36')][_0xe4e5('0x45')]){_0x12b8c3[_0xe4e5('0x46')]=[{'all':!![]}];}return db[_0xe4e5('0x30')][_0xe4e5('0x47')](_0x12b8c3);})[_0xe4e5('0x28')](function(_0x771894){_0x41be2b[_0xe4e5('0x48')]=_0x771894;return _0x41be2b;})[_0xe4e5('0x28')](respondWithFilteredResult(_0x56df2f,_0x12b8c3))[_0xe4e5('0x49')](handleError(_0x56df2f,null));};exports['show']=function(_0x31fa26,_0x57dafc){var _0x502956={'raw':![],'where':{'id':_0x31fa26[_0xe4e5('0x4a')]['id']}},_0x54bdc7={};_0x54bdc7[_0xe4e5('0x35')]=_[_0xe4e5('0x4b')](db[_0xe4e5('0x30')][_0xe4e5('0x31')]);_0x54bdc7[_0xe4e5('0x36')]=_[_0xe4e5('0x4b')](_0x31fa26[_0xe4e5('0x36')]);_0x54bdc7[_0xe4e5('0x37')]=_[_0xe4e5('0x39')](_0x54bdc7[_0xe4e5('0x35')],_0x54bdc7[_0xe4e5('0x36')]);_0x502956[_0xe4e5('0x38')]=_['intersection'](_0x54bdc7[_0xe4e5('0x35')],qs[_0xe4e5('0x3a')](_0x31fa26[_0xe4e5('0x36')][_0xe4e5('0x3a')]));_0x502956[_0xe4e5('0x38')]=_0x502956['attributes'][_0xe4e5('0x3b')]?_0x502956[_0xe4e5('0x38')]:_0x54bdc7['model'];if(_0x31fa26[_0xe4e5('0x36')][_0xe4e5('0x45')]){_0x502956[_0xe4e5('0x46')]=[{'all':!![]}];}_0x502956=_[_0xe4e5('0x40')]({},_0x502956,_0x31fa26[_0xe4e5('0x44')]);return db[_0xe4e5('0x30')][_0xe4e5('0x4c')](_0x502956)[_0xe4e5('0x28')](handleEntityNotFound(_0x57dafc,null))[_0xe4e5('0x28')](respondWithResult(_0x57dafc,null))[_0xe4e5('0x49')](handleError(_0x57dafc,null));};exports[_0xe4e5('0x4d')]=function(_0x21a13a,_0x257640){return db[_0xe4e5('0x30')][_0xe4e5('0x4d')](_0x21a13a['body'],{})['then'](function(_0x478956){var _0x55cc0e=_0x21a13a[_0xe4e5('0x4e')]['get']({'plain':!![]});if(!_0x55cc0e)throw new Error(_0xe4e5('0x4f'));if(_0x55cc0e['role']===_0xe4e5('0x4e')){var _0x4e594c=_0x478956[_0xe4e5('0x29')]({'plain':!![]});var _0x51a1fc=_0xe4e5('0x2a');return db[_0xe4e5('0x50')][_0xe4e5('0x4c')]({'where':{'name':_0x51a1fc,'userProfileId':_0x55cc0e[_0xe4e5('0x51')]},'raw':!![]})['then'](function(_0x529194){if(_0x529194&&_0x529194[_0xe4e5('0x52')]===0x0){return db[_0xe4e5('0x53')][_0xe4e5('0x4d')]({'name':_0x4e594c[_0xe4e5('0x2d')],'resourceId':_0x4e594c['id'],'type':_0x529194[_0xe4e5('0x2d')],'sectionId':_0x529194['id']},{})[_0xe4e5('0x28')](function(){return _0x478956;});}else{return _0x478956;}})[_0xe4e5('0x49')](function(_0x65fbf4){logger['error'](_0xe4e5('0x54'),_0x65fbf4);throw _0x65fbf4;});}return _0x478956;})[_0xe4e5('0x28')](respondWithResult(_0x257640,0xc9))[_0xe4e5('0x49')](handleError(_0x257640,null));};exports[_0xe4e5('0x55')]=function(_0x11ada0,_0x4ed318){var _0x52a7a3={'where':{'id':_0x11ada0[_0xe4e5('0x4a')]['id']}},_0x566a5e={};_0x566a5e[_0xe4e5('0x35')]=_[_0xe4e5('0x4b')](db[_0xe4e5('0x30')][_0xe4e5('0x31')]);_0x52a7a3[_0xe4e5('0x38')]=_[_0xe4e5('0x39')](_0x566a5e[_0xe4e5('0x35')],qs[_0xe4e5('0x3a')](_0x11ada0['query']['fields']));_0x52a7a3['attributes']=_0x52a7a3[_0xe4e5('0x38')][_0xe4e5('0x3b')]?_0x52a7a3['attributes']:_0x566a5e[_0xe4e5('0x35')];if(_0x11ada0[_0xe4e5('0x36')][_0xe4e5('0x45')]){_0x52a7a3[_0xe4e5('0x46')]=[{'all':!![]}];}_0x52a7a3=_['merge']({},_0x52a7a3,_0x11ada0[_0xe4e5('0x44')]);return db[_0xe4e5('0x30')]['find'](_0x52a7a3)['then'](handleEntityNotFound(_0x4ed318,null))['then'](function(_0x583b0e){if(_0x583b0e){var _0x23ca50=_0x583b0e[_0xe4e5('0x29')]({'plain':!![]});_0x23ca50=qs[_0xe4e5('0x56')](_0x23ca50,['id','createdAt','updatedAt']);_0x11ada0['body']=_[_0xe4e5('0x56')](_0x11ada0[_0xe4e5('0x57')],['id','createdAt',_0xe4e5('0x58')]);return db['Dashboard'][_0xe4e5('0x4d')](_[_0xe4e5('0x40')](_0x23ca50,_0x11ada0[_0xe4e5('0x57')]),{'include':_0x11ada0[_0xe4e5('0x36')][_0xe4e5('0x45')]?[{'all':!![]}]:undefined})['then'](function(_0x268b29){var _0x4dcb8f=_0x11ada0[_0xe4e5('0x4e')]['get']({'plain':!![]});if(!_0x4dcb8f)throw new Error(_0xe4e5('0x4f'));if(_0x4dcb8f[_0xe4e5('0x59')]===_0xe4e5('0x4e')){var _0x3e25e4=_0x268b29[_0xe4e5('0x29')]({'plain':!![]});var _0x476982=_0xe4e5('0x2a');return db[_0xe4e5('0x50')][_0xe4e5('0x4c')]({'where':{'name':_0x476982,'userProfileId':_0x4dcb8f[_0xe4e5('0x51')]},'raw':!![]})[_0xe4e5('0x28')](function(_0x4dd586){if(_0x4dd586&&_0x4dd586[_0xe4e5('0x52')]===0x0){return db['UserProfileResource']['create']({'name':_0x3e25e4[_0xe4e5('0x2d')],'resourceId':_0x3e25e4['id'],'type':_0x4dd586['name'],'sectionId':_0x4dd586['id']},{})[_0xe4e5('0x28')](function(){return _0x268b29;});}else{return _0x268b29;}})[_0xe4e5('0x49')](function(_0x3a1ad5){logger[_0xe4e5('0x2c')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x3a1ad5);throw _0x3a1ad5;});}return _0x268b29;});}})['then'](respondWithResult(_0x4ed318,0xc9))[_0xe4e5('0x49')](handleError(_0x4ed318,null));};exports[_0xe4e5('0x27')]=function(_0x66c9c0,_0x30f5d1){if(_0x66c9c0[_0xe4e5('0x57')]['id']){delete _0x66c9c0[_0xe4e5('0x57')]['id'];}return db[_0xe4e5('0x30')][_0xe4e5('0x4c')]({'where':{'id':_0x66c9c0[_0xe4e5('0x4a')]['id']}})[_0xe4e5('0x28')](handleEntityNotFound(_0x30f5d1,null))['then'](saveUpdates(_0x66c9c0[_0xe4e5('0x57')],null))[_0xe4e5('0x28')](respondWithResult(_0x30f5d1,null))[_0xe4e5('0x49')](handleError(_0x30f5d1,null));};exports[_0xe4e5('0x2b')]=function(_0x3fd219,_0x5af729){return db[_0xe4e5('0x30')][_0xe4e5('0x4c')]({'where':{'id':_0x3fd219[_0xe4e5('0x4a')]['id']}})[_0xe4e5('0x28')](handleEntityNotFound(_0x5af729,null))['then'](removeEntity(_0x5af729,null))['catch'](handleError(_0x5af729,null));};function widgetAttributes(_0x5ec823){try{switch(_0x5ec823[_0xe4e5('0x33')]){case _0xe4e5('0x5a'):return[{'name':_0xe4e5('0x5b'),'value':_0x5ec823[_0xe4e5('0x5b')]||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823[_0xe4e5('0x5c')][0x0]?_0x5ec823[_0xe4e5('0x5c')][0x0][_0xe4e5('0x5d')]:undefined)||'https://'}];case'custom':return[{'name':'attrPath','value':_0x5ec823['attrPath']||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823[_0xe4e5('0x5c')][0x0]?_0x5ec823[_0xe4e5('0x5c')][0x0]['value']:undefined)||''}];case _0xe4e5('0x5e'):return[{'name':_0xe4e5('0x5f'),'value':_0x5ec823[_0xe4e5('0x5f')]||(_0x5ec823['attrs']&&_0x5ec823[_0xe4e5('0x5c')][0x0]?_0x5ec823[_0xe4e5('0x5c')][0x0][_0xe4e5('0x5d')]:undefined)||_0xe4e5('0x60')},{'name':_0xe4e5('0x61'),'value':_0x5ec823['attrTimezone']||(_0x5ec823['attrs']&&_0x5ec823['attrs'][0x1]?_0x5ec823[_0xe4e5('0x5c')][0x1]['value']:undefined)||'0.00'},{'name':_0xe4e5('0x62'),'value':_0x5ec823[_0xe4e5('0x62')]||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823['attrs'][0x2]?_0x5ec823[_0xe4e5('0x5c')][0x2][_0xe4e5('0x5d')]:undefined)||0xc}];case _0xe4e5('0x63'):return[{'name':_0xe4e5('0x64'),'value':_0x5ec823[_0xe4e5('0x64')]||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823[_0xe4e5('0x5c')][0x0]?_0x5ec823[_0xe4e5('0x5c')][0x0]['value']:undefined)||'total'},{'name':_0xe4e5('0x65'),'value':_0x5ec823[_0xe4e5('0x65')]||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823['attrs'][0x1]?_0x5ec823[_0xe4e5('0x5c')][0x1][_0xe4e5('0x5d')]:undefined)||[]},{'name':_0xe4e5('0x62'),'value':_0x5ec823[_0xe4e5('0x62')]||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823[_0xe4e5('0x5c')][0x2]?_0x5ec823[_0xe4e5('0x5c')][0x2]['value']:undefined)||0x14}];case _0xe4e5('0x66'):case _0xe4e5('0x67'):return[{'name':_0xe4e5('0x68'),'value':_0x5ec823[_0xe4e5('0x68')]||(_0x5ec823['attrs']&&_0x5ec823[_0xe4e5('0x5c')][0x0]?_0x5ec823[_0xe4e5('0x5c')][0x0]['value']:undefined)||_0xe4e5('0x69')},{'name':_0xe4e5('0x6a'),'value':_0x5ec823[_0xe4e5('0x6a')]||(_0x5ec823['attrs']&&_0x5ec823['attrs'][0x1]?_0x5ec823[_0xe4e5('0x5c')][0x1]['value']:undefined)||null},{'name':_0xe4e5('0x6b'),'value':_0x5ec823[_0xe4e5('0x6b')]||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823[_0xe4e5('0x5c')][0x2]?_0x5ec823[_0xe4e5('0x5c')][0x2][_0xe4e5('0x5d')]:undefined)||null},{'name':_0xe4e5('0x65'),'value':_0x5ec823[_0xe4e5('0x65')]||(_0x5ec823['attrs']&&_0x5ec823['attrs'][0x3]?_0x5ec823[_0xe4e5('0x5c')][0x3][_0xe4e5('0x5d')]:undefined)||[]}];case _0xe4e5('0x6c'):return[{'name':_0xe4e5('0x6d'),'type':_0x5ec823[_0xe4e5('0x6e')]||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823[_0xe4e5('0x5c')][0x0]?_0x5ec823['attrs'][0x0][_0xe4e5('0x33')]:undefined)||null,'value':_0x5ec823[_0xe4e5('0x6d')]||(_0x5ec823[_0xe4e5('0x5c')]&&_0x5ec823['attrs'][0x0]?_0x5ec823[_0xe4e5('0x5c')][0x0]['value']:undefined)||null},{'name':_0xe4e5('0x6f'),'value':_0x5ec823[_0xe4e5('0x6f')]||(_0x5ec823['attrs']&&_0x5ec823['attrs'][0x1]?_0x5ec823[_0xe4e5('0x5c')][0x1][_0xe4e5('0x5d')]:undefined)||0x0}];default:return[];}}catch(_0x47a500){logger[_0xe4e5('0x2c')](_0xe4e5('0x70'),JSON[_0xe4e5('0x71')](_0x47a500));return[];}}exports[_0xe4e5('0x72')]=function(_0x5bc166,_0xa32631,_0x2e9bc4){if(_0x5bc166[_0xe4e5('0x57')]['id']){delete _0x5bc166[_0xe4e5('0x57')]['id'];}return db[_0xe4e5('0x30')][_0xe4e5('0x4c')]({'where':{'id':_0x5bc166[_0xe4e5('0x4a')]['id']}})[_0xe4e5('0x28')](handleEntityNotFound(_0xa32631,null))[_0xe4e5('0x28')](function(_0x4da111){if(_0x4da111){_0x5bc166[_0xe4e5('0x57')][_0xe4e5('0x73')]=_0x4da111['id'];_0x5bc166[_0xe4e5('0x57')]['attrs']=widgetAttributes(_0x5bc166[_0xe4e5('0x57')]);return db[_0xe4e5('0x74')][_0xe4e5('0x4d')](_0x5bc166['body']);}})[_0xe4e5('0x28')](respondWithResult(_0xa32631,null))[_0xe4e5('0x49')](handleError(_0xa32631,null));};exports[_0xe4e5('0x75')]=function(_0x12f4b4,_0x525083,_0x2b0fb2){var _0x278475={};var _0x21a438={};var _0x2920c1;var _0x473eed;return db[_0xe4e5('0x30')][_0xe4e5('0x76')]({'where':{'id':_0x12f4b4[_0xe4e5('0x4a')]['id']}})[_0xe4e5('0x28')](handleEntityNotFound(_0x525083,null))['then'](function(_0x5291fa){if(_0x5291fa){_0x2920c1=_0x5291fa;_0x21a438[_0xe4e5('0x35')]=_[_0xe4e5('0x4b')](db[_0xe4e5('0x74')][_0xe4e5('0x31')]);_0x21a438['query']=_[_0xe4e5('0x4b')](_0x12f4b4['query']);_0x21a438['filters']=_[_0xe4e5('0x39')](_0x21a438[_0xe4e5('0x35')],_0x21a438[_0xe4e5('0x36')]);_0x278475['attributes']=_['intersection'](_0x21a438[_0xe4e5('0x35')],qs['fields'](_0x12f4b4[_0xe4e5('0x36')][_0xe4e5('0x3a')]));_0x278475['attributes']=_0x278475[_0xe4e5('0x38')][_0xe4e5('0x3b')]?_0x278475[_0xe4e5('0x38')]:_0x21a438[_0xe4e5('0x35')];_0x278475['order']=qs['sort'](_0x12f4b4['query'][_0xe4e5('0x3d')]);_0x278475[_0xe4e5('0x3f')]=qs[_0xe4e5('0x37')](_[_0xe4e5('0x3e')](_0x12f4b4[_0xe4e5('0x36')],_0x21a438[_0xe4e5('0x37')]));if(_0x12f4b4[_0xe4e5('0x36')]['filter']){_0x278475['where']=_[_0xe4e5('0x40')](_0x278475[_0xe4e5('0x3f')],{'$or':_[_0xe4e5('0x41')](_0x278475[_0xe4e5('0x38')],function(_0x24d3ee){var _0x2f4d0f={};_0x2f4d0f[_0x24d3ee]={'$like':'%'+_0x12f4b4['query'][_0xe4e5('0x43')]+'%'};return _0x2f4d0f;})});}_0x278475=_[_0xe4e5('0x40')]({},_0x278475,_0x12f4b4[_0xe4e5('0x44')]);return _0x2920c1['getItems'](_0x278475);}})[_0xe4e5('0x28')](function(_0x84d4e4){if(_0x84d4e4){_0x473eed=_0x84d4e4[_0xe4e5('0x3b')];if(!_0x12f4b4[_0xe4e5('0x36')][_0xe4e5('0x77')](_0xe4e5('0x78'))){_0x278475[_0xe4e5('0x24')]=qs[_0xe4e5('0x24')](_0x12f4b4[_0xe4e5('0x36')]['limit']);_0x278475[_0xe4e5('0x23')]=qs[_0xe4e5('0x23')](_0x12f4b4[_0xe4e5('0x36')][_0xe4e5('0x23')]);}return _0x2920c1['getItems'](_0x278475);}})[_0xe4e5('0x28')](function(_0x1a28ab){if(_0x1a28ab){return _0x1a28ab?{'count':_0x473eed,'rows':_0x1a28ab}:null;}})[_0xe4e5('0x28')](respondWithResult(_0x525083,null))['catch'](handleError(_0x525083,null));};