Built motion from commit (unavailable).|2.4.18
[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 _0x47c0=['../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','sendStatus','status','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','get','CustomDashboards','UserProfileResource','error','stack','name','send','rawAttributes','type','key','model','map','keys','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','include','Dashboard','findAll','rows','show','includeAll','find','catch','create','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','omit','createdAt','updatedAt','body','iframe','attrUrl','attrs','value','https://','custom','clock','attrHourFormat','HH:mm:ss','attrTimezone','0.00','counter','attrMetric','attrVoiceQueues','attrFontSize','multibar-chart','pie-chart','attrSerie1','total','attrSerie2','attrSerie3','reportType','attrReport','attrRefresh','widgetAttributes:\x20%s','addItem','DashboardId','findOne','DashboardItem','getItems','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','ejs','lodash','crypto','jsforce','desk.js','to-csv','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch'];(function(_0x3dd2f3,_0x1dcae3){var _0x2cc44d=function(_0x4399a6){while(--_0x4399a6){_0x3dd2f3['push'](_0x3dd2f3['shift']());}};_0x2cc44d(++_0x1dcae3);}(_0x47c0,0x1dc));var _0x047c=function(_0x2bfec2,_0x53f9ab){_0x2bfec2=_0x2bfec2-0x0;var _0x1ed3da=_0x47c0[_0x2bfec2];return _0x1ed3da;};'use strict';var pdf=require(_0x047c('0x0'));var emlformat=require(_0x047c('0x1'));var rimraf=require(_0x047c('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x047c('0x3'));var rp=require(_0x047c('0x4'));var moment=require(_0x047c('0x5'));var BPromise=require(_0x047c('0x6'));var Mustache=require(_0x047c('0x7'));var util=require(_0x047c('0x8'));var path=require('path');var sox=require(_0x047c('0x9'));var csv=require('to-csv');var ejs=require(_0x047c('0xa'));var fs=require('fs');var _=require(_0x047c('0xb'));var squel=require('squel');var crypto=require(_0x047c('0xc'));var jsforce=require(_0x047c('0xd'));var deskjs=require(_0x047c('0xe'));var toCsv=require(_0x047c('0xf'));var querystring=require(_0x047c('0x10'));var Papa=require('papaparse');var Redis=require(_0x047c('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x047c('0x12'));var as=require(_0x047c('0x13'));var hardwareService=require(_0x047c('0x14'));var logger=require('../../config/logger')(_0x047c('0x15'));var utils=require(_0x047c('0x16'));var config=require(_0x047c('0x17'));var db=require(_0x047c('0x18'))['db'];config[_0x047c('0x19')]=_[_0x047c('0x1a')](config[_0x047c('0x19')],{'host':_0x047c('0x1b'),'port':0x18eb});var socket=require(_0x047c('0x1c'))(new Redis(config[_0x047c('0x19')]));require('./dashboard.socket')['register'](socket);function respondWithStatusCode(_0x4ea7fc,_0x44f6da){_0x44f6da=_0x44f6da||0xcc;return function(_0x38e631){if(_0x38e631){return _0x4ea7fc[_0x047c('0x1d')](_0x44f6da);}return _0x4ea7fc[_0x047c('0x1e')](_0x44f6da)['end']();};}function respondWithResult(_0x5d6cc9,_0x598e4e){_0x598e4e=_0x598e4e||0xc8;return function(_0x5745c1){if(_0x5745c1){return _0x5d6cc9[_0x047c('0x1e')](_0x598e4e)[_0x047c('0x1f')](_0x5745c1);}};}function respondWithFilteredResult(_0x391493,_0x4b6274){return function(_0x2c965f){if(_0x2c965f){var _0x3b129a=_0x2c965f[_0x047c('0x20')],_0x14eb6d=_0x4b6274['offset'],_0x4330b8=_0x4b6274[_0x047c('0x21')]+_0x4b6274[_0x047c('0x22')],_0x46573b;if(_0x4330b8>=_0x3b129a){_0x4330b8=_0x3b129a;_0x46573b=0xc8;}else{_0x46573b=0xce;}_0x391493[_0x047c('0x1e')](_0x46573b);return _0x391493[_0x047c('0x23')](_0x047c('0x24'),_0x14eb6d+'-'+_0x4330b8+'/'+_0x3b129a)[_0x047c('0x1f')](_0x2c965f);}return null;};}function patchUpdates(_0x3b466b){return function(_0x1d0d60){try{jsonpatch[_0x047c('0x25')](_0x1d0d60,_0x3b466b,!![]);}catch(_0x18b959){return BPromise[_0x047c('0x26')](_0x18b959);}return _0x1d0d60[_0x047c('0x27')]();};}function saveUpdates(_0x500cc8,_0x23f5cf){return function(_0x37aa80){if(_0x37aa80){return _0x37aa80[_0x047c('0x28')](_0x500cc8)[_0x047c('0x29')](function(_0x19afa4){return _0x19afa4;});}return null;};}function removeEntity(_0x4b94b3,_0x596033){return function(_0x51bdaf){if(_0x51bdaf){return _0x51bdaf[_0x047c('0x2a')]()[_0x047c('0x29')](function(){var _0x225864=_0x51bdaf[_0x047c('0x2b')]({'plain':!![]});var _0x3e118b=_0x047c('0x2c');return db[_0x047c('0x2d')][_0x047c('0x2a')]({'where':{'type':_0x3e118b,'resourceId':_0x225864['id']}})[_0x047c('0x29')](function(){return _0x51bdaf;});})[_0x047c('0x29')](function(){_0x4b94b3[_0x047c('0x1e')](0xcc)['end']();});}};}function handleEntityNotFound(_0x46a354,_0x11a0ea){return function(_0x3bd5fa){if(!_0x3bd5fa){_0x46a354[_0x047c('0x1d')](0x194);}return _0x3bd5fa;};}function handleError(_0x5c53a5,_0xfd2440){_0xfd2440=_0xfd2440||0x1f4;return function(_0x121f21){logger[_0x047c('0x2e')](_0x121f21[_0x047c('0x2f')]);if(_0x121f21[_0x047c('0x30')]){delete _0x121f21[_0x047c('0x30')];}_0x5c53a5[_0x047c('0x1e')](_0xfd2440)[_0x047c('0x31')](_0x121f21);};}exports['index']=function(_0x6a3795,_0x46f4de){var _0x2e50c3={},_0x20ef6a={},_0xccd9ac={'count':0x0,'rows':[]};var _0x469a34=_['map'](db['Dashboard'][_0x047c('0x32')],function(_0xed9f95){return{'name':_0xed9f95['fieldName'],'type':_0xed9f95[_0x047c('0x33')][_0x047c('0x34')]};});_0x20ef6a[_0x047c('0x35')]=_[_0x047c('0x36')](_0x469a34,_0x047c('0x30'));_0x20ef6a['query']=_[_0x047c('0x37')](_0x6a3795[_0x047c('0x38')]);_0x20ef6a[_0x047c('0x39')]=_[_0x047c('0x3a')](_0x20ef6a[_0x047c('0x35')],_0x20ef6a[_0x047c('0x38')]);_0x2e50c3['attributes']=_[_0x047c('0x3a')](_0x20ef6a[_0x047c('0x35')],qs[_0x047c('0x3b')](_0x6a3795[_0x047c('0x38')]['fields']));_0x2e50c3[_0x047c('0x3c')]=_0x2e50c3['attributes'][_0x047c('0x3d')]?_0x2e50c3[_0x047c('0x3c')]:_0x20ef6a[_0x047c('0x35')];if(!_0x6a3795[_0x047c('0x38')][_0x047c('0x3e')](_0x047c('0x3f'))){_0x2e50c3[_0x047c('0x22')]=qs[_0x047c('0x22')](_0x6a3795[_0x047c('0x38')][_0x047c('0x22')]);_0x2e50c3[_0x047c('0x21')]=qs[_0x047c('0x21')](_0x6a3795[_0x047c('0x38')][_0x047c('0x21')]);}_0x2e50c3[_0x047c('0x40')]=qs[_0x047c('0x41')](_0x6a3795[_0x047c('0x38')]['sort']);_0x2e50c3[_0x047c('0x42')]=qs[_0x047c('0x39')](_[_0x047c('0x43')](_0x6a3795[_0x047c('0x38')],_0x20ef6a[_0x047c('0x39')]));if(_0x6a3795[_0x047c('0x38')][_0x047c('0x44')]){_0x2e50c3[_0x047c('0x42')]=_[_0x047c('0x45')](_0x2e50c3['where'],{'$or':_[_0x047c('0x36')](_0x469a34,function(_0x351576){if(_0x351576[_0x047c('0x33')]!==_0x047c('0x46')){var _0xbf353b={};_0xbf353b[_0x351576[_0x047c('0x30')]]={'$like':'%'+_0x6a3795[_0x047c('0x38')]['filter']+'%'};return _0xbf353b;}})});}_0x2e50c3=_['merge']({},_0x2e50c3,_0x6a3795[_0x047c('0x47')]);var _0x1976b4={'where':_0x2e50c3[_0x047c('0x42')]};return db['Dashboard'][_0x047c('0x20')](_0x1976b4)['then'](function(_0x2f43a1){_0xccd9ac['count']=_0x2f43a1;if(_0x6a3795[_0x047c('0x38')]['includeAll']){_0x2e50c3[_0x047c('0x48')]=[{'all':!![]}];}return db[_0x047c('0x49')][_0x047c('0x4a')](_0x2e50c3);})[_0x047c('0x29')](function(_0x97d87f){_0xccd9ac[_0x047c('0x4b')]=_0x97d87f;return _0xccd9ac;})[_0x047c('0x29')](respondWithFilteredResult(_0x46f4de,_0x2e50c3))['catch'](handleError(_0x46f4de,null));};exports[_0x047c('0x4c')]=function(_0x3202e4,_0x1f5d35){var _0x569836={'raw':![],'where':{'id':_0x3202e4['params']['id']}},_0x3fa5d7={};_0x3fa5d7['model']=_[_0x047c('0x37')](db[_0x047c('0x49')][_0x047c('0x32')]);_0x3fa5d7[_0x047c('0x38')]=_[_0x047c('0x37')](_0x3202e4[_0x047c('0x38')]);_0x3fa5d7[_0x047c('0x39')]=_[_0x047c('0x3a')](_0x3fa5d7['model'],_0x3fa5d7[_0x047c('0x38')]);_0x569836[_0x047c('0x3c')]=_['intersection'](_0x3fa5d7[_0x047c('0x35')],qs[_0x047c('0x3b')](_0x3202e4[_0x047c('0x38')][_0x047c('0x3b')]));_0x569836['attributes']=_0x569836[_0x047c('0x3c')][_0x047c('0x3d')]?_0x569836[_0x047c('0x3c')]:_0x3fa5d7[_0x047c('0x35')];if(_0x3202e4[_0x047c('0x38')][_0x047c('0x4d')]){_0x569836[_0x047c('0x48')]=[{'all':!![]}];}_0x569836=_[_0x047c('0x45')]({},_0x569836,_0x3202e4[_0x047c('0x47')]);return db['Dashboard'][_0x047c('0x4e')](_0x569836)[_0x047c('0x29')](handleEntityNotFound(_0x1f5d35,null))[_0x047c('0x29')](respondWithResult(_0x1f5d35,null))[_0x047c('0x4f')](handleError(_0x1f5d35,null));};exports[_0x047c('0x50')]=function(_0x3336e1,_0x4480be){return db[_0x047c('0x49')][_0x047c('0x50')](_0x3336e1['body'],{})[_0x047c('0x29')](function(_0x5c10f2){var _0x111b84=_0x3336e1['user'][_0x047c('0x2b')]({'plain':!![]});if(!_0x111b84)throw new Error(_0x047c('0x51'));if(_0x111b84[_0x047c('0x52')]===_0x047c('0x53')){var _0x4ccada=_0x5c10f2[_0x047c('0x2b')]({'plain':!![]});var _0x34553c=_0x047c('0x2c');return db[_0x047c('0x54')][_0x047c('0x4e')]({'where':{'name':_0x34553c,'userProfileId':_0x111b84[_0x047c('0x55')]},'raw':!![]})['then'](function(_0x3e5b16){if(_0x3e5b16&&_0x3e5b16[_0x047c('0x56')]===0x0){return db[_0x047c('0x2d')]['create']({'name':_0x4ccada[_0x047c('0x30')],'resourceId':_0x4ccada['id'],'type':_0x3e5b16['name'],'sectionId':_0x3e5b16['id']},{})[_0x047c('0x29')](function(){return _0x5c10f2;});}else{return _0x5c10f2;}})[_0x047c('0x4f')](function(_0x570a8a){logger[_0x047c('0x2e')](_0x047c('0x57'),_0x570a8a);throw _0x570a8a;});}return _0x5c10f2;})[_0x047c('0x29')](respondWithResult(_0x4480be,0xc9))[_0x047c('0x4f')](handleError(_0x4480be,null));};exports[_0x047c('0x58')]=function(_0x344077,_0x4e8603){var _0x41bdba={'where':{'id':_0x344077[_0x047c('0x59')]['id']}},_0x443fcb={};_0x443fcb[_0x047c('0x35')]=_['keys'](db[_0x047c('0x49')]['rawAttributes']);_0x41bdba[_0x047c('0x3c')]=_[_0x047c('0x3a')](_0x443fcb[_0x047c('0x35')],qs['fields'](_0x344077['query'][_0x047c('0x3b')]));_0x41bdba[_0x047c('0x3c')]=_0x41bdba[_0x047c('0x3c')][_0x047c('0x3d')]?_0x41bdba['attributes']:_0x443fcb[_0x047c('0x35')];if(_0x344077['query']['includeAll']){_0x41bdba[_0x047c('0x48')]=[{'all':!![]}];}_0x41bdba=_[_0x047c('0x45')]({},_0x41bdba,_0x344077['options']);return db['Dashboard'][_0x047c('0x4e')](_0x41bdba)['then'](handleEntityNotFound(_0x4e8603,null))[_0x047c('0x29')](function(_0x962307){if(_0x962307){var _0xf4cbc7=_0x962307[_0x047c('0x2b')]({'plain':!![]});_0xf4cbc7=qs[_0x047c('0x5a')](_0xf4cbc7,['id',_0x047c('0x5b'),_0x047c('0x5c')]);_0x344077[_0x047c('0x5d')]=_['omit'](_0x344077[_0x047c('0x5d')],['id',_0x047c('0x5b'),_0x047c('0x5c')]);return db[_0x047c('0x49')][_0x047c('0x50')](_[_0x047c('0x45')](_0xf4cbc7,_0x344077['body']),{'include':_0x344077[_0x047c('0x38')][_0x047c('0x4d')]?[{'all':!![]}]:undefined})[_0x047c('0x29')](function(_0x5afa5f){var _0x2c19e6=_0x344077[_0x047c('0x53')][_0x047c('0x2b')]({'plain':!![]});if(!_0x2c19e6)throw new Error(_0x047c('0x51'));if(_0x2c19e6[_0x047c('0x52')]===_0x047c('0x53')){var _0x2c4302=_0x5afa5f[_0x047c('0x2b')]({'plain':!![]});var _0x4ddfca=_0x047c('0x2c');return db[_0x047c('0x54')][_0x047c('0x4e')]({'where':{'name':_0x4ddfca,'userProfileId':_0x2c19e6[_0x047c('0x55')]},'raw':!![]})[_0x047c('0x29')](function(_0x4cd616){if(_0x4cd616&&_0x4cd616[_0x047c('0x56')]===0x0){return db[_0x047c('0x2d')][_0x047c('0x50')]({'name':_0x2c4302[_0x047c('0x30')],'resourceId':_0x2c4302['id'],'type':_0x4cd616[_0x047c('0x30')],'sectionId':_0x4cd616['id']},{})[_0x047c('0x29')](function(){return _0x5afa5f;});}else{return _0x5afa5f;}})[_0x047c('0x4f')](function(_0x4cf688){logger['error'](_0x047c('0x57'),_0x4cf688);throw _0x4cf688;});}return _0x5afa5f;});}})[_0x047c('0x29')](respondWithResult(_0x4e8603,0xc9))[_0x047c('0x4f')](handleError(_0x4e8603,null));};exports[_0x047c('0x28')]=function(_0x422b90,_0x52ade7){if(_0x422b90['body']['id']){delete _0x422b90[_0x047c('0x5d')]['id'];}return db[_0x047c('0x49')]['find']({'where':{'id':_0x422b90[_0x047c('0x59')]['id']}})[_0x047c('0x29')](handleEntityNotFound(_0x52ade7,null))[_0x047c('0x29')](saveUpdates(_0x422b90[_0x047c('0x5d')],null))[_0x047c('0x29')](respondWithResult(_0x52ade7,null))['catch'](handleError(_0x52ade7,null));};exports[_0x047c('0x2a')]=function(_0x31f7da,_0xaca035){return db[_0x047c('0x49')][_0x047c('0x4e')]({'where':{'id':_0x31f7da[_0x047c('0x59')]['id']}})[_0x047c('0x29')](handleEntityNotFound(_0xaca035,null))[_0x047c('0x29')](removeEntity(_0xaca035,null))[_0x047c('0x4f')](handleError(_0xaca035,null));};function widgetAttributes(_0x1b73dc){try{switch(_0x1b73dc['type']){case _0x047c('0x5e'):return[{'name':_0x047c('0x5f'),'value':_0x1b73dc[_0x047c('0x5f')]||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc[_0x047c('0x60')][0x0]?_0x1b73dc[_0x047c('0x60')][0x0][_0x047c('0x61')]:undefined)||_0x047c('0x62')}];case _0x047c('0x63'):return[{'name':'attrPath','value':_0x1b73dc['attrPath']||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc[_0x047c('0x60')][0x0]?_0x1b73dc[_0x047c('0x60')][0x0][_0x047c('0x61')]:undefined)||''}];case _0x047c('0x64'):return[{'name':_0x047c('0x65'),'value':_0x1b73dc[_0x047c('0x65')]||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc[_0x047c('0x60')][0x0]?_0x1b73dc[_0x047c('0x60')][0x0]['value']:undefined)||_0x047c('0x66')},{'name':_0x047c('0x67'),'value':_0x1b73dc['attrTimezone']||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc[_0x047c('0x60')][0x1]?_0x1b73dc[_0x047c('0x60')][0x1][_0x047c('0x61')]:undefined)||_0x047c('0x68')},{'name':'attrFontSize','value':_0x1b73dc['attrFontSize']||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc[_0x047c('0x60')][0x2]?_0x1b73dc['attrs'][0x2]['value']:undefined)||0xc}];case _0x047c('0x69'):return[{'name':_0x047c('0x6a'),'value':_0x1b73dc[_0x047c('0x6a')]||(_0x1b73dc['attrs']&&_0x1b73dc[_0x047c('0x60')][0x0]?_0x1b73dc['attrs'][0x0][_0x047c('0x61')]:undefined)||'total'},{'name':_0x047c('0x6b'),'value':_0x1b73dc[_0x047c('0x6b')]||(_0x1b73dc['attrs']&&_0x1b73dc[_0x047c('0x60')][0x1]?_0x1b73dc[_0x047c('0x60')][0x1][_0x047c('0x61')]:undefined)||[]},{'name':_0x047c('0x6c'),'value':_0x1b73dc[_0x047c('0x6c')]||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc['attrs'][0x2]?_0x1b73dc['attrs'][0x2][_0x047c('0x61')]:undefined)||0x14}];case _0x047c('0x6d'):case _0x047c('0x6e'):return[{'name':_0x047c('0x6f'),'value':_0x1b73dc[_0x047c('0x6f')]||(_0x1b73dc['attrs']&&_0x1b73dc[_0x047c('0x60')][0x0]?_0x1b73dc['attrs'][0x0][_0x047c('0x61')]:undefined)||_0x047c('0x70')},{'name':_0x047c('0x71'),'value':_0x1b73dc[_0x047c('0x71')]||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc[_0x047c('0x60')][0x1]?_0x1b73dc['attrs'][0x1][_0x047c('0x61')]:undefined)||null},{'name':_0x047c('0x72'),'value':_0x1b73dc[_0x047c('0x72')]||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc['attrs'][0x2]?_0x1b73dc['attrs'][0x2][_0x047c('0x61')]:undefined)||null},{'name':'attrVoiceQueues','value':_0x1b73dc[_0x047c('0x6b')]||(_0x1b73dc['attrs']&&_0x1b73dc[_0x047c('0x60')][0x3]?_0x1b73dc['attrs'][0x3]['value']:undefined)||[]}];case'web-report':return[{'name':'attrReport','type':_0x1b73dc[_0x047c('0x73')]||(_0x1b73dc['attrs']&&_0x1b73dc[_0x047c('0x60')][0x0]?_0x1b73dc[_0x047c('0x60')][0x0][_0x047c('0x33')]:undefined)||null,'value':_0x1b73dc[_0x047c('0x74')]||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc[_0x047c('0x60')][0x0]?_0x1b73dc['attrs'][0x0][_0x047c('0x61')]:undefined)||null},{'name':_0x047c('0x75'),'value':_0x1b73dc[_0x047c('0x75')]||(_0x1b73dc[_0x047c('0x60')]&&_0x1b73dc[_0x047c('0x60')][0x1]?_0x1b73dc[_0x047c('0x60')][0x1][_0x047c('0x61')]:undefined)||0x0}];default:return[];}}catch(_0x5e6ac7){logger[_0x047c('0x2e')](_0x047c('0x76'),JSON['stringify'](_0x5e6ac7));return[];}}exports[_0x047c('0x77')]=function(_0x322c46,_0xb76e62,_0x423b85){if(_0x322c46[_0x047c('0x5d')]['id']){delete _0x322c46[_0x047c('0x5d')]['id'];}return db[_0x047c('0x49')]['find']({'where':{'id':_0x322c46[_0x047c('0x59')]['id']}})['then'](handleEntityNotFound(_0xb76e62,null))[_0x047c('0x29')](function(_0x43fb40){if(_0x43fb40){_0x322c46[_0x047c('0x5d')][_0x047c('0x78')]=_0x43fb40['id'];_0x322c46[_0x047c('0x5d')]['attrs']=widgetAttributes(_0x322c46[_0x047c('0x5d')]);return db['DashboardItem']['create'](_0x322c46[_0x047c('0x5d')]);}})['then'](respondWithResult(_0xb76e62,null))[_0x047c('0x4f')](handleError(_0xb76e62,null));};exports['getItems']=function(_0x50c273,_0x512a1c,_0x2fbacb){var _0x1d51ca={};var _0x5f387f={};var _0x50495b;var _0x4a2bd1;return db[_0x047c('0x49')][_0x047c('0x79')]({'where':{'id':_0x50c273[_0x047c('0x59')]['id']}})[_0x047c('0x29')](handleEntityNotFound(_0x512a1c,null))[_0x047c('0x29')](function(_0x5bdffd){if(_0x5bdffd){_0x50495b=_0x5bdffd;_0x5f387f[_0x047c('0x35')]=_[_0x047c('0x37')](db[_0x047c('0x7a')]['rawAttributes']);_0x5f387f['query']=_[_0x047c('0x37')](_0x50c273[_0x047c('0x38')]);_0x5f387f[_0x047c('0x39')]=_[_0x047c('0x3a')](_0x5f387f['model'],_0x5f387f['query']);_0x1d51ca['attributes']=_[_0x047c('0x3a')](_0x5f387f['model'],qs[_0x047c('0x3b')](_0x50c273[_0x047c('0x38')][_0x047c('0x3b')]));_0x1d51ca[_0x047c('0x3c')]=_0x1d51ca[_0x047c('0x3c')][_0x047c('0x3d')]?_0x1d51ca[_0x047c('0x3c')]:_0x5f387f['model'];_0x1d51ca[_0x047c('0x40')]=qs[_0x047c('0x41')](_0x50c273[_0x047c('0x38')][_0x047c('0x41')]);_0x1d51ca[_0x047c('0x42')]=qs[_0x047c('0x39')](_[_0x047c('0x43')](_0x50c273[_0x047c('0x38')],_0x5f387f[_0x047c('0x39')]));if(_0x50c273['query']['filter']){_0x1d51ca[_0x047c('0x42')]=_[_0x047c('0x45')](_0x1d51ca['where'],{'$or':_['map'](_0x1d51ca[_0x047c('0x3c')],function(_0x6b3035){var _0x25282d={};_0x25282d[_0x6b3035]={'$like':'%'+_0x50c273['query']['filter']+'%'};return _0x25282d;})});}_0x1d51ca=_[_0x047c('0x45')]({},_0x1d51ca,_0x50c273[_0x047c('0x47')]);return _0x50495b[_0x047c('0x7b')](_0x1d51ca);}})[_0x047c('0x29')](function(_0x4ac295){if(_0x4ac295){_0x4a2bd1=_0x4ac295[_0x047c('0x3d')];if(!_0x50c273[_0x047c('0x38')][_0x047c('0x3e')]('nolimit')){_0x1d51ca[_0x047c('0x22')]=qs[_0x047c('0x22')](_0x50c273[_0x047c('0x38')][_0x047c('0x22')]);_0x1d51ca[_0x047c('0x21')]=qs[_0x047c('0x21')](_0x50c273[_0x047c('0x38')]['offset']);}return _0x50495b[_0x047c('0x7b')](_0x1d51ca);}})[_0x047c('0x29')](function(_0x4140c2){if(_0x4140c2){return _0x4140c2?{'count':_0x4a2bd1,'rows':_0x4140c2}:null;}})[_0x047c('0x29')](respondWithResult(_0x512a1c,null))[_0x047c('0x4f')](handleError(_0x512a1c,null));};