a38489a6907dd122306c9022ea443c805fb33209
[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 _0x54ef=['iframe','attrUrl','attrs','value','custom','attrPath','clock','attrHourFormat','attrTimezone','0.00','attrFontSize','counter','attrMetric','attrVoiceQueues','multibar-chart','pie-chart','attrSerie1','total','attrSerie2','attrSerie3','web-report','attrReport','reportType','attrRefresh','widgetAttributes:\x20%s','stringify','addItem','DashboardItem','getItems','findOne','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','ejs','lodash','squel','jsforce','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','redis','localhost','socket.io-emitter','./dashboard.socket','sendStatus','end','json','count','offset','set','apply','reject','save','update','destroy','then','get','CustomDashboards','UserProfileResource','status','error','stack','name','index','map','Dashboard','rawAttributes','type','key','query','keys','model','attributes','intersection','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filters','pick','filter','merge','VIRTUAL','include','findAll','rows','catch','show','params','includeAll','options','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x54ef,0x112));var _0xf54e=function(_0x1e108c,_0x57a80d){_0x1e108c=_0x1e108c-0x0;var _0x144354=_0x54ef[_0x1e108c];return _0x144354;};'use strict';var pdf=require(_0xf54e('0x0'));var emlformat=require(_0xf54e('0x1'));var rimraf=require(_0xf54e('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0xf54e('0x3'));var rp=require(_0xf54e('0x4'));var moment=require(_0xf54e('0x5'));var BPromise=require(_0xf54e('0x6'));var Mustache=require(_0xf54e('0x7'));var util=require(_0xf54e('0x8'));var path=require(_0xf54e('0x9'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xf54e('0xa'));var fs=require('fs');var _=require(_0xf54e('0xb'));var squel=require(_0xf54e('0xc'));var crypto=require('crypto');var jsforce=require(_0xf54e('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xf54e('0xe'));var querystring=require(_0xf54e('0xf'));var Papa=require('papaparse');var Redis=require(_0xf54e('0x10'));var authService=require(_0xf54e('0x11'));var qs=require(_0xf54e('0x12'));var as=require(_0xf54e('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xf54e('0x14'))(_0xf54e('0x15'));var utils=require(_0xf54e('0x16'));var config=require(_0xf54e('0x17'));var db=require('../../mysqldb')['db'];config[_0xf54e('0x18')]=_['defaults'](config['redis'],{'host':_0xf54e('0x19'),'port':0x18eb});var socket=require(_0xf54e('0x1a'))(new Redis(config[_0xf54e('0x18')]));require(_0xf54e('0x1b'))['register'](socket);function respondWithStatusCode(_0x331732,_0x1bbeaa){_0x1bbeaa=_0x1bbeaa||0xcc;return function(_0x1855fe){if(_0x1855fe){return _0x331732[_0xf54e('0x1c')](_0x1bbeaa);}return _0x331732['status'](_0x1bbeaa)[_0xf54e('0x1d')]();};}function respondWithResult(_0x389abc,_0x3eb415){_0x3eb415=_0x3eb415||0xc8;return function(_0x5c5d00){if(_0x5c5d00){return _0x389abc['status'](_0x3eb415)[_0xf54e('0x1e')](_0x5c5d00);}};}function respondWithFilteredResult(_0x41fb35,_0x1c02e7){return function(_0x9647f){if(_0x9647f){var _0x15cc48=_0x9647f[_0xf54e('0x1f')],_0x3e7d96=_0x1c02e7[_0xf54e('0x20')],_0x2e27b6=_0x1c02e7[_0xf54e('0x20')]+_0x1c02e7['limit'],_0x1ef06e;if(_0x2e27b6>=_0x15cc48){_0x2e27b6=_0x15cc48;_0x1ef06e=0xc8;}else{_0x1ef06e=0xce;}_0x41fb35['status'](_0x1ef06e);return _0x41fb35[_0xf54e('0x21')]('Content-Range',_0x3e7d96+'-'+_0x2e27b6+'/'+_0x15cc48)[_0xf54e('0x1e')](_0x9647f);}return null;};}function patchUpdates(_0x1bfe99){return function(_0x106362){try{jsonpatch[_0xf54e('0x22')](_0x106362,_0x1bfe99,!![]);}catch(_0xf64f12){return BPromise[_0xf54e('0x23')](_0xf64f12);}return _0x106362[_0xf54e('0x24')]();};}function saveUpdates(_0x11985e,_0x3c0169){return function(_0x5f9eea){if(_0x5f9eea){return _0x5f9eea[_0xf54e('0x25')](_0x11985e)['then'](function(_0x6f6d29){return _0x6f6d29;});}return null;};}function removeEntity(_0x54f914,_0x264a8f){return function(_0x272df6){if(_0x272df6){return _0x272df6[_0xf54e('0x26')]()[_0xf54e('0x27')](function(){var _0x3805a7=_0x272df6[_0xf54e('0x28')]({'plain':!![]});var _0x1e08d1=_0xf54e('0x29');return db[_0xf54e('0x2a')][_0xf54e('0x26')]({'where':{'type':_0x1e08d1,'resourceId':_0x3805a7['id']}})[_0xf54e('0x27')](function(){return _0x272df6;});})[_0xf54e('0x27')](function(){_0x54f914[_0xf54e('0x2b')](0xcc)['end']();});}};}function handleEntityNotFound(_0xb3706e,_0x4cbf7c){return function(_0x282c63){if(!_0x282c63){_0xb3706e['sendStatus'](0x194);}return _0x282c63;};}function handleError(_0x15b888,_0x269f47){_0x269f47=_0x269f47||0x1f4;return function(_0x21ba00){logger[_0xf54e('0x2c')](_0x21ba00[_0xf54e('0x2d')]);if(_0x21ba00[_0xf54e('0x2e')]){delete _0x21ba00[_0xf54e('0x2e')];}_0x15b888['status'](_0x269f47)['send'](_0x21ba00);};}exports[_0xf54e('0x2f')]=function(_0x258d29,_0x2ec92e){var _0x16d00f={},_0xb2d4c4={},_0x133cd7={'count':0x0,'rows':[]};var _0x2b5408=_[_0xf54e('0x30')](db[_0xf54e('0x31')][_0xf54e('0x32')],function(_0x5ea0cc){return{'name':_0x5ea0cc['fieldName'],'type':_0x5ea0cc[_0xf54e('0x33')][_0xf54e('0x34')]};});_0xb2d4c4['model']=_[_0xf54e('0x30')](_0x2b5408,_0xf54e('0x2e'));_0xb2d4c4[_0xf54e('0x35')]=_[_0xf54e('0x36')](_0x258d29['query']);_0xb2d4c4['filters']=_['intersection'](_0xb2d4c4[_0xf54e('0x37')],_0xb2d4c4[_0xf54e('0x35')]);_0x16d00f[_0xf54e('0x38')]=_[_0xf54e('0x39')](_0xb2d4c4[_0xf54e('0x37')],qs[_0xf54e('0x3a')](_0x258d29['query']['fields']));_0x16d00f['attributes']=_0x16d00f[_0xf54e('0x38')][_0xf54e('0x3b')]?_0x16d00f['attributes']:_0xb2d4c4['model'];if(!_0x258d29[_0xf54e('0x35')][_0xf54e('0x3c')](_0xf54e('0x3d'))){_0x16d00f['limit']=qs[_0xf54e('0x3e')](_0x258d29[_0xf54e('0x35')]['limit']);_0x16d00f[_0xf54e('0x20')]=qs[_0xf54e('0x20')](_0x258d29[_0xf54e('0x35')][_0xf54e('0x20')]);}_0x16d00f[_0xf54e('0x3f')]=qs[_0xf54e('0x40')](_0x258d29['query']['sort']);_0x16d00f[_0xf54e('0x41')]=qs[_0xf54e('0x42')](_[_0xf54e('0x43')](_0x258d29['query'],_0xb2d4c4[_0xf54e('0x42')]));if(_0x258d29[_0xf54e('0x35')][_0xf54e('0x44')]){_0x16d00f[_0xf54e('0x41')]=_[_0xf54e('0x45')](_0x16d00f[_0xf54e('0x41')],{'$or':_[_0xf54e('0x30')](_0x2b5408,function(_0x1345b0){if(_0x1345b0[_0xf54e('0x33')]!==_0xf54e('0x46')){var _0x1c1f0d={};_0x1c1f0d[_0x1345b0[_0xf54e('0x2e')]]={'$like':'%'+_0x258d29[_0xf54e('0x35')][_0xf54e('0x44')]+'%'};return _0x1c1f0d;}})});}_0x16d00f=_[_0xf54e('0x45')]({},_0x16d00f,_0x258d29['options']);var _0x4f311f={'where':_0x16d00f['where']};return db[_0xf54e('0x31')][_0xf54e('0x1f')](_0x4f311f)['then'](function(_0x3dae9b){_0x133cd7[_0xf54e('0x1f')]=_0x3dae9b;if(_0x258d29[_0xf54e('0x35')]['includeAll']){_0x16d00f[_0xf54e('0x47')]=[{'all':!![]}];}return db[_0xf54e('0x31')][_0xf54e('0x48')](_0x16d00f);})[_0xf54e('0x27')](function(_0x4b1931){_0x133cd7[_0xf54e('0x49')]=_0x4b1931;return _0x133cd7;})[_0xf54e('0x27')](respondWithFilteredResult(_0x2ec92e,_0x16d00f))[_0xf54e('0x4a')](handleError(_0x2ec92e,null));};exports[_0xf54e('0x4b')]=function(_0x47bedd,_0x11c736){var _0x3447fd={'raw':![],'where':{'id':_0x47bedd[_0xf54e('0x4c')]['id']}},_0x40df32={};_0x40df32[_0xf54e('0x37')]=_[_0xf54e('0x36')](db['Dashboard'][_0xf54e('0x32')]);_0x40df32['query']=_[_0xf54e('0x36')](_0x47bedd['query']);_0x40df32[_0xf54e('0x42')]=_[_0xf54e('0x39')](_0x40df32[_0xf54e('0x37')],_0x40df32['query']);_0x3447fd[_0xf54e('0x38')]=_[_0xf54e('0x39')](_0x40df32[_0xf54e('0x37')],qs[_0xf54e('0x3a')](_0x47bedd[_0xf54e('0x35')]['fields']));_0x3447fd[_0xf54e('0x38')]=_0x3447fd[_0xf54e('0x38')][_0xf54e('0x3b')]?_0x3447fd[_0xf54e('0x38')]:_0x40df32['model'];if(_0x47bedd[_0xf54e('0x35')][_0xf54e('0x4d')]){_0x3447fd['include']=[{'all':!![]}];}_0x3447fd=_[_0xf54e('0x45')]({},_0x3447fd,_0x47bedd[_0xf54e('0x4e')]);return db[_0xf54e('0x31')][_0xf54e('0x4f')](_0x3447fd)['then'](handleEntityNotFound(_0x11c736,null))[_0xf54e('0x27')](respondWithResult(_0x11c736,null))[_0xf54e('0x4a')](handleError(_0x11c736,null));};exports[_0xf54e('0x50')]=function(_0xb4654f,_0x346fc9){return db[_0xf54e('0x31')][_0xf54e('0x50')](_0xb4654f[_0xf54e('0x51')],{})[_0xf54e('0x27')](function(_0x21f2f8){var _0xaf9bf0=_0xb4654f[_0xf54e('0x52')][_0xf54e('0x28')]({'plain':!![]});if(!_0xaf9bf0)throw new Error(_0xf54e('0x53'));if(_0xaf9bf0[_0xf54e('0x54')]===_0xf54e('0x52')){var _0x40d8ab=_0x21f2f8[_0xf54e('0x28')]({'plain':!![]});var _0x21fd80=_0xf54e('0x29');return db['UserProfileSection']['find']({'where':{'name':_0x21fd80,'userProfileId':_0xaf9bf0[_0xf54e('0x55')]},'raw':!![]})[_0xf54e('0x27')](function(_0x45861b){if(_0x45861b&&_0x45861b[_0xf54e('0x56')]===0x0){return db[_0xf54e('0x2a')][_0xf54e('0x50')]({'name':_0x40d8ab[_0xf54e('0x2e')],'resourceId':_0x40d8ab['id'],'type':_0x45861b[_0xf54e('0x2e')],'sectionId':_0x45861b['id']},{})[_0xf54e('0x27')](function(){return _0x21f2f8;});}else{return _0x21f2f8;}})[_0xf54e('0x4a')](function(_0x1df308){logger['error'](_0xf54e('0x57'),_0x1df308);throw _0x1df308;});}return _0x21f2f8;})[_0xf54e('0x27')](respondWithResult(_0x346fc9,0xc9))[_0xf54e('0x4a')](handleError(_0x346fc9,null));};exports[_0xf54e('0x58')]=function(_0x1b8f16,_0x30f53b){var _0x18a25f={'where':{'id':_0x1b8f16[_0xf54e('0x4c')]['id']}},_0x58988a={};_0x58988a[_0xf54e('0x37')]=_[_0xf54e('0x36')](db['Dashboard'][_0xf54e('0x32')]);_0x18a25f['attributes']=_[_0xf54e('0x39')](_0x58988a[_0xf54e('0x37')],qs[_0xf54e('0x3a')](_0x1b8f16['query'][_0xf54e('0x3a')]));_0x18a25f[_0xf54e('0x38')]=_0x18a25f[_0xf54e('0x38')][_0xf54e('0x3b')]?_0x18a25f[_0xf54e('0x38')]:_0x58988a[_0xf54e('0x37')];if(_0x1b8f16[_0xf54e('0x35')]['includeAll']){_0x18a25f['include']=[{'all':!![]}];}_0x18a25f=_[_0xf54e('0x45')]({},_0x18a25f,_0x1b8f16[_0xf54e('0x4e')]);return db['Dashboard'][_0xf54e('0x4f')](_0x18a25f)['then'](handleEntityNotFound(_0x30f53b,null))[_0xf54e('0x27')](function(_0x528a64){if(_0x528a64){var _0x324167=_0x528a64[_0xf54e('0x28')]({'plain':!![]});_0x324167=qs[_0xf54e('0x59')](_0x324167,['id',_0xf54e('0x5a'),_0xf54e('0x5b')]);_0x1b8f16[_0xf54e('0x51')]=_['omit'](_0x1b8f16['body'],['id',_0xf54e('0x5a'),_0xf54e('0x5b')]);return db['Dashboard']['create'](_[_0xf54e('0x45')](_0x324167,_0x1b8f16['body']),{'include':_0x1b8f16[_0xf54e('0x35')][_0xf54e('0x4d')]?[{'all':!![]}]:undefined})[_0xf54e('0x27')](function(_0x2b11f8){var _0x1d7c52=_0x1b8f16[_0xf54e('0x52')][_0xf54e('0x28')]({'plain':!![]});if(!_0x1d7c52)throw new Error(_0xf54e('0x53'));if(_0x1d7c52[_0xf54e('0x54')]===_0xf54e('0x52')){var _0x1f9dad=_0x2b11f8[_0xf54e('0x28')]({'plain':!![]});var _0x65bdf2=_0xf54e('0x29');return db['UserProfileSection'][_0xf54e('0x4f')]({'where':{'name':_0x65bdf2,'userProfileId':_0x1d7c52[_0xf54e('0x55')]},'raw':!![]})[_0xf54e('0x27')](function(_0x11908b){if(_0x11908b&&_0x11908b[_0xf54e('0x56')]===0x0){return db['UserProfileResource'][_0xf54e('0x50')]({'name':_0x1f9dad[_0xf54e('0x2e')],'resourceId':_0x1f9dad['id'],'type':_0x11908b['name'],'sectionId':_0x11908b['id']},{})['then'](function(){return _0x2b11f8;});}else{return _0x2b11f8;}})[_0xf54e('0x4a')](function(_0x4b4a2f){logger[_0xf54e('0x2c')](_0xf54e('0x57'),_0x4b4a2f);throw _0x4b4a2f;});}return _0x2b11f8;});}})[_0xf54e('0x27')](respondWithResult(_0x30f53b,0xc9))[_0xf54e('0x4a')](handleError(_0x30f53b,null));};exports['update']=function(_0x2ecda1,_0x5cdb8c){if(_0x2ecda1[_0xf54e('0x51')]['id']){delete _0x2ecda1[_0xf54e('0x51')]['id'];}return db[_0xf54e('0x31')]['find']({'where':{'id':_0x2ecda1[_0xf54e('0x4c')]['id']}})['then'](handleEntityNotFound(_0x5cdb8c,null))[_0xf54e('0x27')](saveUpdates(_0x2ecda1[_0xf54e('0x51')],null))['then'](respondWithResult(_0x5cdb8c,null))[_0xf54e('0x4a')](handleError(_0x5cdb8c,null));};exports['destroy']=function(_0x3aa7e5,_0x2df028){return db[_0xf54e('0x31')][_0xf54e('0x4f')]({'where':{'id':_0x3aa7e5[_0xf54e('0x4c')]['id']}})['then'](handleEntityNotFound(_0x2df028,null))[_0xf54e('0x27')](removeEntity(_0x2df028,null))[_0xf54e('0x4a')](handleError(_0x2df028,null));};function widgetAttributes(_0x57db6f){try{switch(_0x57db6f[_0xf54e('0x33')]){case _0xf54e('0x5c'):return[{'name':'attrUrl','value':_0x57db6f[_0xf54e('0x5d')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x0]?_0x57db6f['attrs'][0x0][_0xf54e('0x5f')]:undefined)||'https://'}];case _0xf54e('0x60'):return[{'name':_0xf54e('0x61'),'value':_0x57db6f['attrPath']||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x0]?_0x57db6f[_0xf54e('0x5e')][0x0][_0xf54e('0x5f')]:undefined)||''}];case _0xf54e('0x62'):return[{'name':_0xf54e('0x63'),'value':_0x57db6f[_0xf54e('0x63')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x0]?_0x57db6f[_0xf54e('0x5e')][0x0][_0xf54e('0x5f')]:undefined)||'HH:mm:ss'},{'name':_0xf54e('0x64'),'value':_0x57db6f[_0xf54e('0x64')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f['attrs'][0x1]?_0x57db6f[_0xf54e('0x5e')][0x1][_0xf54e('0x5f')]:undefined)||_0xf54e('0x65')},{'name':_0xf54e('0x66'),'value':_0x57db6f[_0xf54e('0x66')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x2]?_0x57db6f['attrs'][0x2][_0xf54e('0x5f')]:undefined)||0xc}];case _0xf54e('0x67'):return[{'name':_0xf54e('0x68'),'value':_0x57db6f['attrMetric']||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x0]?_0x57db6f[_0xf54e('0x5e')][0x0][_0xf54e('0x5f')]:undefined)||'total'},{'name':'attrVoiceQueues','value':_0x57db6f[_0xf54e('0x69')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x1]?_0x57db6f[_0xf54e('0x5e')][0x1][_0xf54e('0x5f')]:undefined)||[]},{'name':_0xf54e('0x66'),'value':_0x57db6f[_0xf54e('0x66')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x2]?_0x57db6f[_0xf54e('0x5e')][0x2]['value']:undefined)||0x14}];case _0xf54e('0x6a'):case _0xf54e('0x6b'):return[{'name':_0xf54e('0x6c'),'value':_0x57db6f[_0xf54e('0x6c')]||(_0x57db6f['attrs']&&_0x57db6f[_0xf54e('0x5e')][0x0]?_0x57db6f[_0xf54e('0x5e')][0x0][_0xf54e('0x5f')]:undefined)||_0xf54e('0x6d')},{'name':'attrSerie2','value':_0x57db6f[_0xf54e('0x6e')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x1]?_0x57db6f['attrs'][0x1]['value']:undefined)||null},{'name':_0xf54e('0x6f'),'value':_0x57db6f[_0xf54e('0x6f')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x2]?_0x57db6f[_0xf54e('0x5e')][0x2][_0xf54e('0x5f')]:undefined)||null},{'name':_0xf54e('0x69'),'value':_0x57db6f[_0xf54e('0x69')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f['attrs'][0x3]?_0x57db6f[_0xf54e('0x5e')][0x3][_0xf54e('0x5f')]:undefined)||[]}];case _0xf54e('0x70'):return[{'name':_0xf54e('0x71'),'type':_0x57db6f[_0xf54e('0x72')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x0]?_0x57db6f[_0xf54e('0x5e')][0x0][_0xf54e('0x33')]:undefined)||null,'value':_0x57db6f[_0xf54e('0x71')]||(_0x57db6f[_0xf54e('0x5e')]&&_0x57db6f[_0xf54e('0x5e')][0x0]?_0x57db6f['attrs'][0x0][_0xf54e('0x5f')]:undefined)||null},{'name':_0xf54e('0x73'),'value':_0x57db6f['attrRefresh']||(_0x57db6f['attrs']&&_0x57db6f[_0xf54e('0x5e')][0x1]?_0x57db6f[_0xf54e('0x5e')][0x1][_0xf54e('0x5f')]:undefined)||0x0}];default:return[];}}catch(_0x3be745){logger[_0xf54e('0x2c')](_0xf54e('0x74'),JSON[_0xf54e('0x75')](_0x3be745));return[];}}exports[_0xf54e('0x76')]=function(_0x244451,_0x570c3a,_0x2bb31f){if(_0x244451[_0xf54e('0x51')]['id']){delete _0x244451[_0xf54e('0x51')]['id'];}return db['Dashboard'][_0xf54e('0x4f')]({'where':{'id':_0x244451['params']['id']}})[_0xf54e('0x27')](handleEntityNotFound(_0x570c3a,null))['then'](function(_0xfe35d8){if(_0xfe35d8){_0x244451[_0xf54e('0x51')]['DashboardId']=_0xfe35d8['id'];_0x244451['body'][_0xf54e('0x5e')]=widgetAttributes(_0x244451[_0xf54e('0x51')]);return db[_0xf54e('0x77')][_0xf54e('0x50')](_0x244451[_0xf54e('0x51')]);}})['then'](respondWithResult(_0x570c3a,null))['catch'](handleError(_0x570c3a,null));};exports[_0xf54e('0x78')]=function(_0x331e1f,_0x456159,_0xc31d53){var _0x9afe5={};var _0xe1205={};var _0x7568bf;var _0x138119;return db[_0xf54e('0x31')][_0xf54e('0x79')]({'where':{'id':_0x331e1f['params']['id']}})[_0xf54e('0x27')](handleEntityNotFound(_0x456159,null))[_0xf54e('0x27')](function(_0x4d4667){if(_0x4d4667){_0x7568bf=_0x4d4667;_0xe1205['model']=_[_0xf54e('0x36')](db[_0xf54e('0x77')][_0xf54e('0x32')]);_0xe1205[_0xf54e('0x35')]=_[_0xf54e('0x36')](_0x331e1f['query']);_0xe1205[_0xf54e('0x42')]=_[_0xf54e('0x39')](_0xe1205[_0xf54e('0x37')],_0xe1205[_0xf54e('0x35')]);_0x9afe5['attributes']=_[_0xf54e('0x39')](_0xe1205[_0xf54e('0x37')],qs[_0xf54e('0x3a')](_0x331e1f[_0xf54e('0x35')]['fields']));_0x9afe5[_0xf54e('0x38')]=_0x9afe5[_0xf54e('0x38')][_0xf54e('0x3b')]?_0x9afe5[_0xf54e('0x38')]:_0xe1205[_0xf54e('0x37')];_0x9afe5['order']=qs[_0xf54e('0x40')](_0x331e1f['query']['sort']);_0x9afe5[_0xf54e('0x41')]=qs[_0xf54e('0x42')](_[_0xf54e('0x43')](_0x331e1f[_0xf54e('0x35')],_0xe1205[_0xf54e('0x42')]));if(_0x331e1f[_0xf54e('0x35')][_0xf54e('0x44')]){_0x9afe5[_0xf54e('0x41')]=_[_0xf54e('0x45')](_0x9afe5['where'],{'$or':_[_0xf54e('0x30')](_0x9afe5[_0xf54e('0x38')],function(_0x259a3e){var _0x971a3e={};_0x971a3e[_0x259a3e]={'$like':'%'+_0x331e1f[_0xf54e('0x35')][_0xf54e('0x44')]+'%'};return _0x971a3e;})});}_0x9afe5=_['merge']({},_0x9afe5,_0x331e1f[_0xf54e('0x4e')]);return _0x7568bf[_0xf54e('0x78')](_0x9afe5);}})[_0xf54e('0x27')](function(_0x2b46d4){if(_0x2b46d4){_0x138119=_0x2b46d4[_0xf54e('0x3b')];if(!_0x331e1f[_0xf54e('0x35')]['hasOwnProperty'](_0xf54e('0x3d'))){_0x9afe5[_0xf54e('0x3e')]=qs[_0xf54e('0x3e')](_0x331e1f[_0xf54e('0x35')]['limit']);_0x9afe5['offset']=qs[_0xf54e('0x20')](_0x331e1f[_0xf54e('0x35')][_0xf54e('0x20')]);}return _0x7568bf[_0xf54e('0x78')](_0x9afe5);}})[_0xf54e('0x27')](function(_0x14e19e){if(_0x14e19e){return _0x14e19e?{'count':_0x138119,'rows':_0x14e19e}:null;}})['then'](respondWithResult(_0x456159,null))[_0xf54e('0x4a')](handleError(_0x456159,null));};