Built motion from commit (unavailable).|2.5.30
[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 _0x6b19=['DashboardId','getItems','findOne','DashboardItem','eml-format','rimraf','fast-json-patch','bluebird','mustache','util','path','sox','ejs','lodash','jsforce','to-csv','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','redis','defaults','socket.io-emitter','./dashboard.socket','register','sendStatus','status','end','json','offset','undefined','count','limit','set','Content-Range','apply','save','then','destroy','CustomDashboards','UserProfileResource','error','name','send','index','map','Dashboard','rawAttributes','fieldName','key','model','query','keys','attributes','intersection','fields','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','type','VIRTUAL','options','findAll','rows','catch','show','length','includeAll','include','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','find','userProfileId','autoAssociation','params','createdAt','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','iframe','attrUrl','attrs','value','https://','attrPath','clock','attrHourFormat','0.00','attrFontSize','attrMetric','total','pie-chart','attrSerie1','attrSerie2','attrSerie3','attrVoiceQueues','web-report','attrReport','attrRefresh','stringify'];(function(_0x4f7b90,_0x54efa9){var _0x5d4aa6=function(_0x532193){while(--_0x532193){_0x4f7b90['push'](_0x4f7b90['shift']());}};_0x5d4aa6(++_0x54efa9);}(_0x6b19,0xe8));var _0x96b1=function(_0x1b44f3,_0x42bb0d){_0x1b44f3=_0x1b44f3-0x0;var _0x443d9a=_0x6b19[_0x1b44f3];return _0x443d9a;};'use strict';var emlformat=require(_0x96b1('0x0'));var rimraf=require(_0x96b1('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x96b1('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x96b1('0x3'));var Mustache=require(_0x96b1('0x4'));var util=require(_0x96b1('0x5'));var path=require(_0x96b1('0x6'));var sox=require(_0x96b1('0x7'));var csv=require('to-csv');var ejs=require(_0x96b1('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x96b1('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x96b1('0xa'));var deskjs=require('desk.js');var toCsv=require(_0x96b1('0xb'));var querystring=require('querystring');var Papa=require(_0x96b1('0xc'));var Redis=require(_0x96b1('0xd'));var authService=require(_0x96b1('0xe'));var qs=require(_0x96b1('0xf'));var as=require(_0x96b1('0x10'));var hardwareService=require(_0x96b1('0x11'));var logger=require(_0x96b1('0x12'))('api');var utils=require('../../config/utils');var config=require(_0x96b1('0x13'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];config[_0x96b1('0x14')]=_[_0x96b1('0x15')](config[_0x96b1('0x14')],{'host':'localhost','port':0x18eb});var socket=require(_0x96b1('0x16'))(new Redis(config[_0x96b1('0x14')]));require(_0x96b1('0x17'))[_0x96b1('0x18')](socket);function respondWithStatusCode(_0x46b2bb,_0x4f4150){_0x4f4150=_0x4f4150||0xcc;return function(_0x27254a){if(_0x27254a){return _0x46b2bb[_0x96b1('0x19')](_0x4f4150);}return _0x46b2bb[_0x96b1('0x1a')](_0x4f4150)[_0x96b1('0x1b')]();};}function respondWithResult(_0x2cd1f5,_0x43b7f5){_0x43b7f5=_0x43b7f5||0xc8;return function(_0x24fa0f){if(_0x24fa0f){return _0x2cd1f5[_0x96b1('0x1a')](_0x43b7f5)[_0x96b1('0x1c')](_0x24fa0f);}};}function respondWithFilteredResult(_0x1b1f8e,_0x450099){return function(_0x38478c){if(_0x38478c){var _0x2b192a=typeof _0x450099[_0x96b1('0x1d')]===_0x96b1('0x1e')&&typeof _0x450099['limit']===_0x96b1('0x1e');var _0x5dab57=_0x38478c[_0x96b1('0x1f')];var _0x2f98a2=_0x2b192a?0x0:_0x450099[_0x96b1('0x1d')];var _0x5dd21e=_0x2b192a?_0x38478c[_0x96b1('0x1f')]:_0x450099[_0x96b1('0x1d')]+_0x450099[_0x96b1('0x20')];var _0x4b3894;if(_0x5dd21e>=_0x5dab57){_0x5dd21e=_0x5dab57;_0x4b3894=0xc8;}else{_0x4b3894=0xce;}_0x1b1f8e[_0x96b1('0x1a')](_0x4b3894);return _0x1b1f8e[_0x96b1('0x21')](_0x96b1('0x22'),_0x2f98a2+'-'+_0x5dd21e+'/'+_0x5dab57)[_0x96b1('0x1c')](_0x38478c);}return null;};}function patchUpdates(_0x555185){return function(_0x301ba2){try{jsonpatch[_0x96b1('0x23')](_0x301ba2,_0x555185,!![]);}catch(_0xde249b){return BPromise['reject'](_0xde249b);}return _0x301ba2[_0x96b1('0x24')]();};}function saveUpdates(_0x370f15,_0x28b42b){return function(_0x20a85f){if(_0x20a85f){return _0x20a85f['update'](_0x370f15)[_0x96b1('0x25')](function(_0x548bae){return _0x548bae;});}return null;};}function removeEntity(_0x21ac25,_0x4ad19f){return function(_0x6509d2){if(_0x6509d2){return _0x6509d2[_0x96b1('0x26')]()['then'](function(){var _0x50dcbc=_0x6509d2['get']({'plain':!![]});var _0x3f24bc=_0x96b1('0x27');return db[_0x96b1('0x28')][_0x96b1('0x26')]({'where':{'type':_0x3f24bc,'resourceId':_0x50dcbc['id']}})[_0x96b1('0x25')](function(){return _0x6509d2;});})['then'](function(){_0x21ac25[_0x96b1('0x1a')](0xcc)[_0x96b1('0x1b')]();});}};}function handleEntityNotFound(_0x3cadbb,_0x209ce8){return function(_0x51e2c1){if(!_0x51e2c1){_0x3cadbb[_0x96b1('0x19')](0x194);}return _0x51e2c1;};}function handleError(_0x33f96b,_0x52f988){_0x52f988=_0x52f988||0x1f4;return function(_0x59cf9b){logger[_0x96b1('0x29')](_0x59cf9b['stack']);if(_0x59cf9b[_0x96b1('0x2a')]){delete _0x59cf9b[_0x96b1('0x2a')];}_0x33f96b['status'](_0x52f988)[_0x96b1('0x2b')](_0x59cf9b);};}exports[_0x96b1('0x2c')]=function(_0x5cb283,_0x36e049){var _0x444401={},_0x11cdf5={},_0x50d470={'count':0x0,'rows':[]};var _0x2ac0bf=_[_0x96b1('0x2d')](db[_0x96b1('0x2e')][_0x96b1('0x2f')],function(_0x2e232f){return{'name':_0x2e232f[_0x96b1('0x30')],'type':_0x2e232f['type'][_0x96b1('0x31')]};});_0x11cdf5[_0x96b1('0x32')]=_['map'](_0x2ac0bf,'name');_0x11cdf5[_0x96b1('0x33')]=_[_0x96b1('0x34')](_0x5cb283[_0x96b1('0x33')]);_0x11cdf5['filters']=_['intersection'](_0x11cdf5[_0x96b1('0x32')],_0x11cdf5[_0x96b1('0x33')]);_0x444401[_0x96b1('0x35')]=_[_0x96b1('0x36')](_0x11cdf5['model'],qs[_0x96b1('0x37')](_0x5cb283['query'][_0x96b1('0x37')]));_0x444401[_0x96b1('0x35')]=_0x444401[_0x96b1('0x35')]['length']?_0x444401[_0x96b1('0x35')]:_0x11cdf5[_0x96b1('0x32')];if(!_0x5cb283[_0x96b1('0x33')][_0x96b1('0x38')](_0x96b1('0x39'))){_0x444401[_0x96b1('0x20')]=qs['limit'](_0x5cb283[_0x96b1('0x33')][_0x96b1('0x20')]);_0x444401['offset']=qs[_0x96b1('0x1d')](_0x5cb283['query'][_0x96b1('0x1d')]);}_0x444401[_0x96b1('0x3a')]=qs[_0x96b1('0x3b')](_0x5cb283[_0x96b1('0x33')][_0x96b1('0x3b')]);_0x444401[_0x96b1('0x3c')]=qs[_0x96b1('0x3d')](_[_0x96b1('0x3e')](_0x5cb283[_0x96b1('0x33')],_0x11cdf5['filters']),_0x2ac0bf);if(_0x5cb283[_0x96b1('0x33')][_0x96b1('0x3f')]){_0x444401[_0x96b1('0x3c')]=_[_0x96b1('0x40')](_0x444401[_0x96b1('0x3c')],{'$or':_[_0x96b1('0x2d')](_0x2ac0bf,function(_0x3304d6){if(_0x3304d6[_0x96b1('0x41')]!==_0x96b1('0x42')){var _0x37a2ed={};_0x37a2ed[_0x3304d6[_0x96b1('0x2a')]]={'$like':'%'+_0x5cb283[_0x96b1('0x33')][_0x96b1('0x3f')]+'%'};return _0x37a2ed;}})});}_0x444401=_[_0x96b1('0x40')]({},_0x444401,_0x5cb283[_0x96b1('0x43')]);var _0x49a73e={'where':_0x444401['where']};return db[_0x96b1('0x2e')][_0x96b1('0x1f')](_0x49a73e)['then'](function(_0x2d0e9b){_0x50d470[_0x96b1('0x1f')]=_0x2d0e9b;if(_0x5cb283['query']['includeAll']){_0x444401['include']=[{'all':!![]}];}return db[_0x96b1('0x2e')][_0x96b1('0x44')](_0x444401);})[_0x96b1('0x25')](function(_0x458fd9){_0x50d470[_0x96b1('0x45')]=_0x458fd9;return _0x50d470;})[_0x96b1('0x25')](respondWithFilteredResult(_0x36e049,_0x444401))[_0x96b1('0x46')](handleError(_0x36e049,null));};exports[_0x96b1('0x47')]=function(_0x2610ee,_0x28f820){var _0x47d7d5={'raw':![],'where':{'id':_0x2610ee['params']['id']}},_0x25bfa9={};_0x25bfa9[_0x96b1('0x32')]=_['keys'](db[_0x96b1('0x2e')]['rawAttributes']);_0x25bfa9[_0x96b1('0x33')]=_[_0x96b1('0x34')](_0x2610ee[_0x96b1('0x33')]);_0x25bfa9[_0x96b1('0x3d')]=_[_0x96b1('0x36')](_0x25bfa9['model'],_0x25bfa9[_0x96b1('0x33')]);_0x47d7d5[_0x96b1('0x35')]=_[_0x96b1('0x36')](_0x25bfa9['model'],qs[_0x96b1('0x37')](_0x2610ee[_0x96b1('0x33')][_0x96b1('0x37')]));_0x47d7d5[_0x96b1('0x35')]=_0x47d7d5['attributes'][_0x96b1('0x48')]?_0x47d7d5[_0x96b1('0x35')]:_0x25bfa9['model'];if(_0x2610ee[_0x96b1('0x33')][_0x96b1('0x49')]){_0x47d7d5[_0x96b1('0x4a')]=[{'all':!![]}];}_0x47d7d5=_[_0x96b1('0x40')]({},_0x47d7d5,_0x2610ee[_0x96b1('0x43')]);return db[_0x96b1('0x2e')]['find'](_0x47d7d5)[_0x96b1('0x25')](handleEntityNotFound(_0x28f820,null))['then'](respondWithResult(_0x28f820,null))[_0x96b1('0x46')](handleError(_0x28f820,null));};exports[_0x96b1('0x4b')]=function(_0x5c0463,_0x23ad53){return db[_0x96b1('0x2e')]['create'](_0x5c0463[_0x96b1('0x4c')],{})[_0x96b1('0x25')](function(_0x2087ba){var _0x3a7301=_0x5c0463[_0x96b1('0x4d')][_0x96b1('0x4e')]({'plain':!![]});if(!_0x3a7301)throw new Error(_0x96b1('0x4f'));if(_0x3a7301[_0x96b1('0x50')]===_0x96b1('0x4d')){var _0xfeeadf=_0x2087ba['get']({'plain':!![]});var _0x296960=_0x96b1('0x27');return db[_0x96b1('0x51')][_0x96b1('0x52')]({'where':{'name':_0x296960,'userProfileId':_0x3a7301[_0x96b1('0x53')]},'raw':!![]})[_0x96b1('0x25')](function(_0x420d36){if(_0x420d36&&_0x420d36[_0x96b1('0x54')]===0x0){return db['UserProfileResource']['create']({'name':_0xfeeadf[_0x96b1('0x2a')],'resourceId':_0xfeeadf['id'],'type':_0x420d36[_0x96b1('0x2a')],'sectionId':_0x420d36['id']},{})['then'](function(){return _0x2087ba;});}else{return _0x2087ba;}})[_0x96b1('0x46')](function(_0x2863b2){logger[_0x96b1('0x29')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x2863b2);throw _0x2863b2;});}return _0x2087ba;})[_0x96b1('0x25')](respondWithResult(_0x23ad53,0xc9))[_0x96b1('0x46')](handleError(_0x23ad53,null));};exports['clone']=function(_0x5f5b83,_0x31c32d){var _0x19cc23={'where':{'id':_0x5f5b83[_0x96b1('0x55')]['id']}},_0x3b0fe6={};_0x3b0fe6[_0x96b1('0x32')]=_[_0x96b1('0x34')](db[_0x96b1('0x2e')][_0x96b1('0x2f')]);_0x19cc23[_0x96b1('0x35')]=_[_0x96b1('0x36')](_0x3b0fe6[_0x96b1('0x32')],qs[_0x96b1('0x37')](_0x5f5b83['query'][_0x96b1('0x37')]));_0x19cc23[_0x96b1('0x35')]=_0x19cc23[_0x96b1('0x35')][_0x96b1('0x48')]?_0x19cc23[_0x96b1('0x35')]:_0x3b0fe6[_0x96b1('0x32')];if(_0x5f5b83[_0x96b1('0x33')]['includeAll']){_0x19cc23[_0x96b1('0x4a')]=[{'all':!![]}];}_0x19cc23=_['merge']({},_0x19cc23,_0x5f5b83['options']);return db[_0x96b1('0x2e')][_0x96b1('0x52')](_0x19cc23)[_0x96b1('0x25')](handleEntityNotFound(_0x31c32d,null))[_0x96b1('0x25')](function(_0x41cca1){if(_0x41cca1){var _0x192744=_0x41cca1[_0x96b1('0x4e')]({'plain':!![]});_0x192744=qs['omit'](_0x192744,['id',_0x96b1('0x56'),'updatedAt']);_0x5f5b83[_0x96b1('0x4c')]=_['omit'](_0x5f5b83[_0x96b1('0x4c')],['id',_0x96b1('0x56'),'updatedAt']);return db[_0x96b1('0x2e')][_0x96b1('0x4b')](_[_0x96b1('0x40')](_0x192744,_0x5f5b83[_0x96b1('0x4c')]),{'include':_0x5f5b83['query']['includeAll']?[{'all':!![]}]:undefined})[_0x96b1('0x25')](function(_0x33b5a3){var _0x474bad=_0x5f5b83[_0x96b1('0x4d')]['get']({'plain':!![]});if(!_0x474bad)throw new Error(_0x96b1('0x4f'));if(_0x474bad[_0x96b1('0x50')]===_0x96b1('0x4d')){var _0x2048d6=_0x33b5a3[_0x96b1('0x4e')]({'plain':!![]});var _0x134e1b=_0x96b1('0x27');return db[_0x96b1('0x51')][_0x96b1('0x52')]({'where':{'name':_0x134e1b,'userProfileId':_0x474bad['userProfileId']},'raw':!![]})['then'](function(_0x15f591){if(_0x15f591&&_0x15f591[_0x96b1('0x54')]===0x0){return db['UserProfileResource']['create']({'name':_0x2048d6[_0x96b1('0x2a')],'resourceId':_0x2048d6['id'],'type':_0x15f591[_0x96b1('0x2a')],'sectionId':_0x15f591['id']},{})[_0x96b1('0x25')](function(){return _0x33b5a3;});}else{return _0x33b5a3;}})[_0x96b1('0x46')](function(_0x24ea99){logger[_0x96b1('0x29')](_0x96b1('0x57'),_0x24ea99);throw _0x24ea99;});}return _0x33b5a3;});}})['then'](respondWithResult(_0x31c32d,0xc9))['catch'](handleError(_0x31c32d,null));};exports[_0x96b1('0x58')]=function(_0x1efa0e,_0x4cbc78){if(_0x1efa0e['body']['id']){delete _0x1efa0e[_0x96b1('0x4c')]['id'];}return db[_0x96b1('0x2e')]['find']({'where':{'id':_0x1efa0e[_0x96b1('0x55')]['id']}})[_0x96b1('0x25')](handleEntityNotFound(_0x4cbc78,null))[_0x96b1('0x25')](saveUpdates(_0x1efa0e[_0x96b1('0x4c')],null))[_0x96b1('0x25')](respondWithResult(_0x4cbc78,null))[_0x96b1('0x46')](handleError(_0x4cbc78,null));};exports['destroy']=function(_0xa0877f,_0x1db88a){return db[_0x96b1('0x2e')][_0x96b1('0x52')]({'where':{'id':_0xa0877f['params']['id']}})[_0x96b1('0x25')](handleEntityNotFound(_0x1db88a,null))['then'](removeEntity(_0x1db88a,null))[_0x96b1('0x46')](handleError(_0x1db88a,null));};function widgetAttributes(_0x30547f){try{switch(_0x30547f[_0x96b1('0x41')]){case _0x96b1('0x59'):return[{'name':_0x96b1('0x5a'),'value':_0x30547f[_0x96b1('0x5a')]||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f[_0x96b1('0x5b')][0x0]?_0x30547f[_0x96b1('0x5b')][0x0][_0x96b1('0x5c')]:undefined)||_0x96b1('0x5d')}];case'custom':return[{'name':_0x96b1('0x5e'),'value':_0x30547f[_0x96b1('0x5e')]||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f[_0x96b1('0x5b')][0x0]?_0x30547f[_0x96b1('0x5b')][0x0]['value']:undefined)||''}];case _0x96b1('0x5f'):return[{'name':_0x96b1('0x60'),'value':_0x30547f['attrHourFormat']||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f[_0x96b1('0x5b')][0x0]?_0x30547f[_0x96b1('0x5b')][0x0][_0x96b1('0x5c')]:undefined)||'HH:mm:ss'},{'name':'attrTimezone','value':_0x30547f['attrTimezone']||(_0x30547f['attrs']&&_0x30547f[_0x96b1('0x5b')][0x1]?_0x30547f[_0x96b1('0x5b')][0x1]['value']:undefined)||_0x96b1('0x61')},{'name':_0x96b1('0x62'),'value':_0x30547f[_0x96b1('0x62')]||(_0x30547f['attrs']&&_0x30547f[_0x96b1('0x5b')][0x2]?_0x30547f[_0x96b1('0x5b')][0x2][_0x96b1('0x5c')]:undefined)||0xc}];case'counter':return[{'name':_0x96b1('0x63'),'value':_0x30547f[_0x96b1('0x63')]||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f[_0x96b1('0x5b')][0x0]?_0x30547f[_0x96b1('0x5b')][0x0]['value']:undefined)||_0x96b1('0x64')},{'name':'attrVoiceQueues','value':_0x30547f['attrVoiceQueues']||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f[_0x96b1('0x5b')][0x1]?_0x30547f[_0x96b1('0x5b')][0x1][_0x96b1('0x5c')]:undefined)||[]},{'name':'attrFontSize','value':_0x30547f['attrFontSize']||(_0x30547f['attrs']&&_0x30547f['attrs'][0x2]?_0x30547f['attrs'][0x2][_0x96b1('0x5c')]:undefined)||0x14}];case'multibar-chart':case _0x96b1('0x65'):return[{'name':_0x96b1('0x66'),'value':_0x30547f[_0x96b1('0x66')]||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f['attrs'][0x0]?_0x30547f[_0x96b1('0x5b')][0x0][_0x96b1('0x5c')]:undefined)||'total'},{'name':_0x96b1('0x67'),'value':_0x30547f['attrSerie2']||(_0x30547f['attrs']&&_0x30547f[_0x96b1('0x5b')][0x1]?_0x30547f['attrs'][0x1][_0x96b1('0x5c')]:undefined)||null},{'name':'attrSerie3','value':_0x30547f[_0x96b1('0x68')]||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f[_0x96b1('0x5b')][0x2]?_0x30547f['attrs'][0x2][_0x96b1('0x5c')]:undefined)||null},{'name':_0x96b1('0x69'),'value':_0x30547f[_0x96b1('0x69')]||(_0x30547f['attrs']&&_0x30547f[_0x96b1('0x5b')][0x3]?_0x30547f[_0x96b1('0x5b')][0x3]['value']:undefined)||[]}];case _0x96b1('0x6a'):return[{'name':_0x96b1('0x6b'),'type':_0x30547f['reportType']||(_0x30547f['attrs']&&_0x30547f[_0x96b1('0x5b')][0x0]?_0x30547f['attrs'][0x0][_0x96b1('0x41')]:undefined)||null,'value':_0x30547f['attrReport']||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f[_0x96b1('0x5b')][0x0]?_0x30547f[_0x96b1('0x5b')][0x0][_0x96b1('0x5c')]:undefined)||null},{'name':_0x96b1('0x6c'),'value':_0x30547f['attrRefresh']||(_0x30547f[_0x96b1('0x5b')]&&_0x30547f[_0x96b1('0x5b')][0x1]?_0x30547f[_0x96b1('0x5b')][0x1]['value']:undefined)||0x0}];default:return[];}}catch(_0x3b939a){logger['error']('widgetAttributes:\x20%s',JSON[_0x96b1('0x6d')](_0x3b939a));return[];}}exports['addItem']=function(_0x1b1d65,_0x55feaa,_0x4a31ce){if(_0x1b1d65[_0x96b1('0x4c')]['id']){delete _0x1b1d65['body']['id'];}return db[_0x96b1('0x2e')][_0x96b1('0x52')]({'where':{'id':_0x1b1d65[_0x96b1('0x55')]['id']}})[_0x96b1('0x25')](handleEntityNotFound(_0x55feaa,null))[_0x96b1('0x25')](function(_0x68af5b){if(_0x68af5b){_0x1b1d65['body'][_0x96b1('0x6e')]=_0x68af5b['id'];_0x1b1d65['body'][_0x96b1('0x5b')]=widgetAttributes(_0x1b1d65[_0x96b1('0x4c')]);return db['DashboardItem'][_0x96b1('0x4b')](_0x1b1d65[_0x96b1('0x4c')]);}})['then'](respondWithResult(_0x55feaa,null))[_0x96b1('0x46')](handleError(_0x55feaa,null));};exports[_0x96b1('0x6f')]=function(_0x5846ef,_0x2f6929,_0x566e6b){var _0x3d68d6={};var _0x50ec93={};var _0x4c61b4;var _0x42615d;return db[_0x96b1('0x2e')][_0x96b1('0x70')]({'where':{'id':_0x5846ef[_0x96b1('0x55')]['id']}})['then'](handleEntityNotFound(_0x2f6929,null))[_0x96b1('0x25')](function(_0x311f04){if(_0x311f04){_0x4c61b4=_0x311f04;_0x50ec93[_0x96b1('0x32')]=_[_0x96b1('0x34')](db[_0x96b1('0x71')][_0x96b1('0x2f')]);_0x50ec93[_0x96b1('0x33')]=_['keys'](_0x5846ef[_0x96b1('0x33')]);_0x50ec93[_0x96b1('0x3d')]=_[_0x96b1('0x36')](_0x50ec93[_0x96b1('0x32')],_0x50ec93['query']);_0x3d68d6['attributes']=_[_0x96b1('0x36')](_0x50ec93[_0x96b1('0x32')],qs[_0x96b1('0x37')](_0x5846ef[_0x96b1('0x33')][_0x96b1('0x37')]));_0x3d68d6[_0x96b1('0x35')]=_0x3d68d6[_0x96b1('0x35')][_0x96b1('0x48')]?_0x3d68d6[_0x96b1('0x35')]:_0x50ec93[_0x96b1('0x32')];_0x3d68d6['order']=qs['sort'](_0x5846ef[_0x96b1('0x33')][_0x96b1('0x3b')]);_0x3d68d6[_0x96b1('0x3c')]=qs[_0x96b1('0x3d')](_[_0x96b1('0x3e')](_0x5846ef[_0x96b1('0x33')],_0x50ec93['filters']));if(_0x5846ef[_0x96b1('0x33')]['filter']){_0x3d68d6[_0x96b1('0x3c')]=_[_0x96b1('0x40')](_0x3d68d6[_0x96b1('0x3c')],{'$or':_[_0x96b1('0x2d')](_0x3d68d6[_0x96b1('0x35')],function(_0xe0035a){var _0x4c0929={};_0x4c0929[_0xe0035a]={'$like':'%'+_0x5846ef[_0x96b1('0x33')][_0x96b1('0x3f')]+'%'};return _0x4c0929;})});}_0x3d68d6=_[_0x96b1('0x40')]({},_0x3d68d6,_0x5846ef[_0x96b1('0x43')]);return _0x4c61b4['getItems'](_0x3d68d6);}})[_0x96b1('0x25')](function(_0x2681b7){if(_0x2681b7){_0x42615d=_0x2681b7['length'];if(!_0x5846ef['query'][_0x96b1('0x38')](_0x96b1('0x39'))){_0x3d68d6[_0x96b1('0x20')]=qs[_0x96b1('0x20')](_0x5846ef['query'][_0x96b1('0x20')]);_0x3d68d6['offset']=qs[_0x96b1('0x1d')](_0x5846ef[_0x96b1('0x33')][_0x96b1('0x1d')]);}return _0x4c61b4[_0x96b1('0x6f')](_0x3d68d6);}})[_0x96b1('0x25')](function(_0x459563){if(_0x459563){return _0x459563?{'count':_0x42615d,'rows':_0x459563}:null;}})[_0x96b1('0x25')](respondWithResult(_0x2f6929,null))['catch'](handleError(_0x2f6929,null));};