189984e2af8b5837360d9e06ddfc0ce68344b009
[motion2.git] / server / api / intDeskConfiguration / intDeskConfiguration.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 _0x10d9=['send','key','model','query','filters','intersection','fields','attributes','length','nolimit','order','sort','where','filter','merge','type','VIRTUAL','options','DeskConfiguration','count','includeAll','include','findAll','rows','catch','params','keys','create','body','find','getFields','findOne','DeskField','rawAttributes','pick','hasOwnProperty','getSubjects','getDescriptions','map','getTags','setTags','ids','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','crypto','desk.js','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','sendStatus','status','end','offset','undefined','limit','set','json','apply','save','update','then','destroy','error','name'];(function(_0x5bc8d3,_0x2fe93d){var _0x4d1662=function(_0x3546a3){while(--_0x3546a3){_0x5bc8d3['push'](_0x5bc8d3['shift']());}};_0x4d1662(++_0x2fe93d);}(_0x10d9,0x79));var _0x910d=function(_0x380e26,_0x18ef89){_0x380e26=_0x380e26-0x0;var _0x12c615=_0x10d9[_0x380e26];return _0x12c615;};'use strict';var emlformat=require(_0x910d('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x910d('0x1'));var jsonpatch=require(_0x910d('0x2'));var rp=require(_0x910d('0x3'));var moment=require(_0x910d('0x4'));var BPromise=require(_0x910d('0x5'));var Mustache=require(_0x910d('0x6'));var util=require(_0x910d('0x7'));var path=require('path');var sox=require(_0x910d('0x8'));var csv=require(_0x910d('0x9'));var ejs=require(_0x910d('0xa'));var fs=require('fs');var fs_extra=require(_0x910d('0xb'));var _=require(_0x910d('0xc'));var squel=require('squel');var crypto=require(_0x910d('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x910d('0xe'));var toCsv=require(_0x910d('0x9'));var querystring=require('querystring');var Papa=require(_0x910d('0xf'));var Redis=require(_0x910d('0x10'));var authService=require('../../components/auth/service');var qs=require(_0x910d('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x910d('0x12'));var logger=require(_0x910d('0x13'))('api');var utils=require('../../config/utils');var config=require(_0x910d('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0x910d('0x15'))['db'];function respondWithStatusCode(_0x581a6f,_0x1ad528){_0x1ad528=_0x1ad528||0xcc;return function(_0x4a4f3c){if(_0x4a4f3c){return _0x581a6f[_0x910d('0x16')](_0x1ad528);}return _0x581a6f[_0x910d('0x17')](_0x1ad528)[_0x910d('0x18')]();};}function respondWithResult(_0x2426b4,_0x42f2cc){_0x42f2cc=_0x42f2cc||0xc8;return function(_0x3de1ae){if(_0x3de1ae){return _0x2426b4['status'](_0x42f2cc)['json'](_0x3de1ae);}};}function respondWithFilteredResult(_0x1ea5ed,_0x92da49){return function(_0x3e3b91){if(_0x3e3b91){var _0x1d8338=typeof _0x92da49[_0x910d('0x19')]===_0x910d('0x1a')&&typeof _0x92da49[_0x910d('0x1b')]===_0x910d('0x1a');var _0x61c144=_0x3e3b91['count'];var _0xd29e71=_0x1d8338?0x0:_0x92da49[_0x910d('0x19')];var _0x49c42b=_0x1d8338?_0x3e3b91['count']:_0x92da49[_0x910d('0x19')]+_0x92da49[_0x910d('0x1b')];var _0x561183;if(_0x49c42b>=_0x61c144){_0x49c42b=_0x61c144;_0x561183=0xc8;}else{_0x561183=0xce;}_0x1ea5ed[_0x910d('0x17')](_0x561183);return _0x1ea5ed[_0x910d('0x1c')]('Content-Range',_0xd29e71+'-'+_0x49c42b+'/'+_0x61c144)[_0x910d('0x1d')](_0x3e3b91);}return null;};}function patchUpdates(_0x45580b){return function(_0x15400e){try{jsonpatch[_0x910d('0x1e')](_0x15400e,_0x45580b,!![]);}catch(_0x48b294){return BPromise['reject'](_0x48b294);}return _0x15400e[_0x910d('0x1f')]();};}function saveUpdates(_0x5cd8c3,_0x2e1e26){return function(_0x262f6b){if(_0x262f6b){return _0x262f6b[_0x910d('0x20')](_0x5cd8c3)[_0x910d('0x21')](function(_0x55d9ee){return _0x55d9ee;});}return null;};}function removeEntity(_0x208f40,_0x5805c5){return function(_0x363447){if(_0x363447){return _0x363447[_0x910d('0x22')]()['then'](function(){_0x208f40[_0x910d('0x17')](0xcc)[_0x910d('0x18')]();});}};}function handleEntityNotFound(_0x330f29,_0x5e6c3c){return function(_0x1daba5){if(!_0x1daba5){_0x330f29['sendStatus'](0x194);}return _0x1daba5;};}function handleError(_0x1c61b2,_0x202a4a){_0x202a4a=_0x202a4a||0x1f4;return function(_0x802832){logger[_0x910d('0x23')](_0x802832['stack']);if(_0x802832['name']){delete _0x802832[_0x910d('0x24')];}_0x1c61b2[_0x910d('0x17')](_0x202a4a)[_0x910d('0x25')](_0x802832);};}exports['index']=function(_0x21677d,_0x13ddae){var _0x5c59c4={},_0x40c741={},_0x580c3d={'count':0x0,'rows':[]};var _0x22533f=_['map'](db['DeskConfiguration']['rawAttributes'],function(_0x2123e6){return{'name':_0x2123e6['fieldName'],'type':_0x2123e6['type'][_0x910d('0x26')]};});_0x40c741[_0x910d('0x27')]=_['map'](_0x22533f,_0x910d('0x24'));_0x40c741[_0x910d('0x28')]=_['keys'](_0x21677d['query']);_0x40c741[_0x910d('0x29')]=_['intersection'](_0x40c741[_0x910d('0x27')],_0x40c741[_0x910d('0x28')]);_0x5c59c4['attributes']=_[_0x910d('0x2a')](_0x40c741[_0x910d('0x27')],qs['fields'](_0x21677d[_0x910d('0x28')][_0x910d('0x2b')]));_0x5c59c4['attributes']=_0x5c59c4[_0x910d('0x2c')][_0x910d('0x2d')]?_0x5c59c4[_0x910d('0x2c')]:_0x40c741[_0x910d('0x27')];if(!_0x21677d[_0x910d('0x28')]['hasOwnProperty'](_0x910d('0x2e'))){_0x5c59c4['limit']=qs[_0x910d('0x1b')](_0x21677d['query']['limit']);_0x5c59c4['offset']=qs[_0x910d('0x19')](_0x21677d[_0x910d('0x28')][_0x910d('0x19')]);}_0x5c59c4[_0x910d('0x2f')]=qs[_0x910d('0x30')](_0x21677d['query'][_0x910d('0x30')]);_0x5c59c4[_0x910d('0x31')]=qs[_0x910d('0x29')](_['pick'](_0x21677d[_0x910d('0x28')],_0x40c741[_0x910d('0x29')]),_0x22533f);if(_0x21677d['query'][_0x910d('0x32')]){_0x5c59c4[_0x910d('0x31')]=_[_0x910d('0x33')](_0x5c59c4[_0x910d('0x31')],{'$or':_['map'](_0x22533f,function(_0x5b3caf){if(_0x5b3caf[_0x910d('0x34')]!==_0x910d('0x35')){var _0x5c2549={};_0x5c2549[_0x5b3caf[_0x910d('0x24')]]={'$like':'%'+_0x21677d[_0x910d('0x28')][_0x910d('0x32')]+'%'};return _0x5c2549;}})});}_0x5c59c4=_['merge']({},_0x5c59c4,_0x21677d[_0x910d('0x36')]);var _0x24db3f={'where':_0x5c59c4[_0x910d('0x31')]};return db[_0x910d('0x37')][_0x910d('0x38')](_0x24db3f)[_0x910d('0x21')](function(_0xe57765){_0x580c3d[_0x910d('0x38')]=_0xe57765;if(_0x21677d[_0x910d('0x28')][_0x910d('0x39')]){_0x5c59c4[_0x910d('0x3a')]=[{'all':!![]}];}return db[_0x910d('0x37')][_0x910d('0x3b')](_0x5c59c4);})['then'](function(_0x2f4967){_0x580c3d[_0x910d('0x3c')]=_0x2f4967;return _0x580c3d;})[_0x910d('0x21')](respondWithFilteredResult(_0x13ddae,_0x5c59c4))[_0x910d('0x3d')](handleError(_0x13ddae,null));};exports['show']=function(_0x37efda,_0x29c665){var _0x37eda9={'raw':![],'where':{'id':_0x37efda[_0x910d('0x3e')]['id']}},_0x300166={};_0x300166[_0x910d('0x27')]=_[_0x910d('0x3f')](db[_0x910d('0x37')]['rawAttributes']);_0x300166[_0x910d('0x28')]=_[_0x910d('0x3f')](_0x37efda[_0x910d('0x28')]);_0x300166['filters']=_[_0x910d('0x2a')](_0x300166[_0x910d('0x27')],_0x300166[_0x910d('0x28')]);_0x37eda9['attributes']=_[_0x910d('0x2a')](_0x300166[_0x910d('0x27')],qs[_0x910d('0x2b')](_0x37efda[_0x910d('0x28')][_0x910d('0x2b')]));_0x37eda9[_0x910d('0x2c')]=_0x37eda9['attributes'][_0x910d('0x2d')]?_0x37eda9['attributes']:_0x300166[_0x910d('0x27')];if(_0x37efda[_0x910d('0x28')][_0x910d('0x39')]){_0x37eda9[_0x910d('0x3a')]=[{'all':!![]}];}_0x37eda9=_[_0x910d('0x33')]({},_0x37eda9,_0x37efda[_0x910d('0x36')]);return db[_0x910d('0x37')]['find'](_0x37eda9)[_0x910d('0x21')](handleEntityNotFound(_0x29c665,null))[_0x910d('0x21')](respondWithResult(_0x29c665,null))[_0x910d('0x3d')](handleError(_0x29c665,null));};exports['create']=function(_0x4828c9,_0x14109b){return db[_0x910d('0x37')][_0x910d('0x40')](_0x4828c9[_0x910d('0x41')],{})['then'](respondWithResult(_0x14109b,0xc9))[_0x910d('0x3d')](handleError(_0x14109b,null));};exports['update']=function(_0xb49896,_0x4b37ff){if(_0xb49896[_0x910d('0x41')]['id']){delete _0xb49896[_0x910d('0x41')]['id'];}return db[_0x910d('0x37')][_0x910d('0x42')]({'where':{'id':_0xb49896['params']['id']}})[_0x910d('0x21')](handleEntityNotFound(_0x4b37ff,null))[_0x910d('0x21')](saveUpdates(_0xb49896['body'],null))[_0x910d('0x21')](respondWithResult(_0x4b37ff,null))['catch'](handleError(_0x4b37ff,null));};exports['destroy']=function(_0x294ea1,_0x33700a){return db[_0x910d('0x37')][_0x910d('0x42')]({'where':{'id':_0x294ea1[_0x910d('0x3e')]['id']}})[_0x910d('0x21')](handleEntityNotFound(_0x33700a,null))[_0x910d('0x21')](removeEntity(_0x33700a,null))[_0x910d('0x3d')](handleError(_0x33700a,null));};exports[_0x910d('0x43')]=function(_0x5acaf7,_0x455595,_0x11200f){var _0x1e1226={};var _0x291ca5={};var _0x396d5c;var _0xeee462;return db[_0x910d('0x37')][_0x910d('0x44')]({'where':{'id':_0x5acaf7['params']['id']}})[_0x910d('0x21')](handleEntityNotFound(_0x455595,null))[_0x910d('0x21')](function(_0x32cf7a){if(_0x32cf7a){_0x396d5c=_0x32cf7a;_0x291ca5[_0x910d('0x27')]=_['keys'](db[_0x910d('0x45')][_0x910d('0x46')]);_0x291ca5[_0x910d('0x28')]=_[_0x910d('0x3f')](_0x5acaf7[_0x910d('0x28')]);_0x291ca5[_0x910d('0x29')]=_[_0x910d('0x2a')](_0x291ca5[_0x910d('0x27')],_0x291ca5[_0x910d('0x28')]);_0x1e1226[_0x910d('0x2c')]=_['intersection'](_0x291ca5[_0x910d('0x27')],qs[_0x910d('0x2b')](_0x5acaf7['query'][_0x910d('0x2b')]));_0x1e1226[_0x910d('0x2c')]=_0x1e1226[_0x910d('0x2c')][_0x910d('0x2d')]?_0x1e1226[_0x910d('0x2c')]:_0x291ca5['model'];_0x1e1226['order']=qs[_0x910d('0x30')](_0x5acaf7[_0x910d('0x28')]['sort']);_0x1e1226['where']=qs['filters'](_[_0x910d('0x47')](_0x5acaf7[_0x910d('0x28')],_0x291ca5[_0x910d('0x29')]));if(_0x5acaf7['query']['filter']){_0x1e1226[_0x910d('0x31')]=_[_0x910d('0x33')](_0x1e1226[_0x910d('0x31')],{'$or':_['map'](_0x1e1226['attributes'],function(_0x8c059a){var _0x443564={};_0x443564[_0x8c059a]={'$like':'%'+_0x5acaf7[_0x910d('0x28')][_0x910d('0x32')]+'%'};return _0x443564;})});}_0x1e1226=_['merge']({},_0x1e1226,_0x5acaf7['options']);return _0x396d5c['getFields'](_0x1e1226);}})[_0x910d('0x21')](function(_0x3696d1){if(_0x3696d1){_0xeee462=_0x3696d1[_0x910d('0x2d')];if(!_0x5acaf7[_0x910d('0x28')][_0x910d('0x48')](_0x910d('0x2e'))){_0x1e1226[_0x910d('0x1b')]=qs[_0x910d('0x1b')](_0x5acaf7['query']['limit']);_0x1e1226[_0x910d('0x19')]=qs['offset'](_0x5acaf7[_0x910d('0x28')][_0x910d('0x19')]);}return _0x396d5c[_0x910d('0x43')](_0x1e1226);}})[_0x910d('0x21')](function(_0x5c1b3d){if(_0x5c1b3d){return _0x5c1b3d?{'count':_0xeee462,'rows':_0x5c1b3d}:null;}})[_0x910d('0x21')](respondWithResult(_0x455595,null))[_0x910d('0x3d')](handleError(_0x455595,null));};exports['getSubjects']=function(_0x549f74,_0x2c0419,_0x4e82c0){var _0x5978d6={};var _0x4fa7f4={};var _0x5338ba;var _0x4b319c;return db[_0x910d('0x37')][_0x910d('0x44')]({'where':{'id':_0x549f74[_0x910d('0x3e')]['id']}})[_0x910d('0x21')](handleEntityNotFound(_0x2c0419,null))[_0x910d('0x21')](function(_0x1ee293){if(_0x1ee293){_0x5338ba=_0x1ee293;_0x4fa7f4[_0x910d('0x27')]=_[_0x910d('0x3f')](db[_0x910d('0x45')]['rawAttributes']);_0x4fa7f4['query']=_[_0x910d('0x3f')](_0x549f74[_0x910d('0x28')]);_0x4fa7f4[_0x910d('0x29')]=_['intersection'](_0x4fa7f4[_0x910d('0x27')],_0x4fa7f4[_0x910d('0x28')]);_0x5978d6[_0x910d('0x2c')]=_['intersection'](_0x4fa7f4[_0x910d('0x27')],qs[_0x910d('0x2b')](_0x549f74['query'][_0x910d('0x2b')]));_0x5978d6['attributes']=_0x5978d6[_0x910d('0x2c')][_0x910d('0x2d')]?_0x5978d6[_0x910d('0x2c')]:_0x4fa7f4[_0x910d('0x27')];_0x5978d6['order']=qs[_0x910d('0x30')](_0x549f74[_0x910d('0x28')][_0x910d('0x30')]);_0x5978d6[_0x910d('0x31')]=qs[_0x910d('0x29')](_[_0x910d('0x47')](_0x549f74['query'],_0x4fa7f4[_0x910d('0x29')]));if(_0x549f74[_0x910d('0x28')]['filter']){_0x5978d6[_0x910d('0x31')]=_[_0x910d('0x33')](_0x5978d6[_0x910d('0x31')],{'$or':_['map'](_0x5978d6[_0x910d('0x2c')],function(_0x110853){var _0x2b2c1d={};_0x2b2c1d[_0x110853]={'$like':'%'+_0x549f74[_0x910d('0x28')][_0x910d('0x32')]+'%'};return _0x2b2c1d;})});}_0x5978d6=_[_0x910d('0x33')]({},_0x5978d6,_0x549f74[_0x910d('0x36')]);return _0x5338ba['getSubjects'](_0x5978d6);}})[_0x910d('0x21')](function(_0x49cca2){if(_0x49cca2){_0x4b319c=_0x49cca2[_0x910d('0x2d')];if(!_0x549f74['query'][_0x910d('0x48')](_0x910d('0x2e'))){_0x5978d6['limit']=qs[_0x910d('0x1b')](_0x549f74['query'][_0x910d('0x1b')]);_0x5978d6['offset']=qs['offset'](_0x549f74[_0x910d('0x28')][_0x910d('0x19')]);}return _0x5338ba[_0x910d('0x49')](_0x5978d6);}})[_0x910d('0x21')](function(_0x1f98a6){if(_0x1f98a6){return _0x1f98a6?{'count':_0x4b319c,'rows':_0x1f98a6}:null;}})[_0x910d('0x21')](respondWithResult(_0x2c0419,null))[_0x910d('0x3d')](handleError(_0x2c0419,null));};exports[_0x910d('0x4a')]=function(_0x393b13,_0x1d13cc,_0xc97002){var _0x30ea6d={};var _0x2a9ace={};var _0x1bd106;var _0x152a42;return db['DeskConfiguration'][_0x910d('0x44')]({'where':{'id':_0x393b13[_0x910d('0x3e')]['id']}})[_0x910d('0x21')](handleEntityNotFound(_0x1d13cc,null))[_0x910d('0x21')](function(_0xbd1aaf){if(_0xbd1aaf){_0x1bd106=_0xbd1aaf;_0x2a9ace[_0x910d('0x27')]=_[_0x910d('0x3f')](db[_0x910d('0x45')]['rawAttributes']);_0x2a9ace[_0x910d('0x28')]=_['keys'](_0x393b13[_0x910d('0x28')]);_0x2a9ace[_0x910d('0x29')]=_['intersection'](_0x2a9ace[_0x910d('0x27')],_0x2a9ace[_0x910d('0x28')]);_0x30ea6d['attributes']=_[_0x910d('0x2a')](_0x2a9ace[_0x910d('0x27')],qs[_0x910d('0x2b')](_0x393b13[_0x910d('0x28')][_0x910d('0x2b')]));_0x30ea6d[_0x910d('0x2c')]=_0x30ea6d[_0x910d('0x2c')][_0x910d('0x2d')]?_0x30ea6d['attributes']:_0x2a9ace[_0x910d('0x27')];_0x30ea6d[_0x910d('0x2f')]=qs['sort'](_0x393b13[_0x910d('0x28')][_0x910d('0x30')]);_0x30ea6d['where']=qs[_0x910d('0x29')](_[_0x910d('0x47')](_0x393b13[_0x910d('0x28')],_0x2a9ace['filters']));if(_0x393b13[_0x910d('0x28')][_0x910d('0x32')]){_0x30ea6d['where']=_['merge'](_0x30ea6d[_0x910d('0x31')],{'$or':_[_0x910d('0x4b')](_0x30ea6d[_0x910d('0x2c')],function(_0x3b023f){var _0x5d34ab={};_0x5d34ab[_0x3b023f]={'$like':'%'+_0x393b13[_0x910d('0x28')][_0x910d('0x32')]+'%'};return _0x5d34ab;})});}_0x30ea6d=_['merge']({},_0x30ea6d,_0x393b13[_0x910d('0x36')]);return _0x1bd106['getDescriptions'](_0x30ea6d);}})['then'](function(_0x5cabbd){if(_0x5cabbd){_0x152a42=_0x5cabbd[_0x910d('0x2d')];if(!_0x393b13[_0x910d('0x28')][_0x910d('0x48')]('nolimit')){_0x30ea6d[_0x910d('0x1b')]=qs[_0x910d('0x1b')](_0x393b13[_0x910d('0x28')][_0x910d('0x1b')]);_0x30ea6d[_0x910d('0x19')]=qs[_0x910d('0x19')](_0x393b13[_0x910d('0x28')]['offset']);}return _0x1bd106[_0x910d('0x4a')](_0x30ea6d);}})[_0x910d('0x21')](function(_0x1f4584){if(_0x1f4584){return _0x1f4584?{'count':_0x152a42,'rows':_0x1f4584}:null;}})['then'](respondWithResult(_0x1d13cc,null))['catch'](handleError(_0x1d13cc,null));};exports[_0x910d('0x4c')]=function(_0x4c4daa,_0x29b4f7,_0x4a3038){var _0x24e2a1={};var _0x51885c={};var _0x3c467d;var _0x326349;return db[_0x910d('0x37')][_0x910d('0x44')]({'where':{'id':_0x4c4daa[_0x910d('0x3e')]['id']}})[_0x910d('0x21')](handleEntityNotFound(_0x29b4f7,null))[_0x910d('0x21')](function(_0x471bf0){if(_0x471bf0){_0x3c467d=_0x471bf0;_0x51885c['model']=_[_0x910d('0x3f')](db['Tag']['rawAttributes']);_0x51885c[_0x910d('0x28')]=_[_0x910d('0x3f')](_0x4c4daa['query']);_0x51885c[_0x910d('0x29')]=_[_0x910d('0x2a')](_0x51885c[_0x910d('0x27')],_0x51885c[_0x910d('0x28')]);_0x24e2a1[_0x910d('0x2c')]=_['intersection'](_0x51885c['model'],qs['fields'](_0x4c4daa[_0x910d('0x28')][_0x910d('0x2b')]));_0x24e2a1[_0x910d('0x2c')]=_0x24e2a1[_0x910d('0x2c')][_0x910d('0x2d')]?_0x24e2a1['attributes']:_0x51885c[_0x910d('0x27')];_0x24e2a1[_0x910d('0x2f')]=qs[_0x910d('0x30')](_0x4c4daa[_0x910d('0x28')][_0x910d('0x30')]);_0x24e2a1[_0x910d('0x31')]=qs[_0x910d('0x29')](_[_0x910d('0x47')](_0x4c4daa['query'],_0x51885c[_0x910d('0x29')]));if(_0x4c4daa[_0x910d('0x28')][_0x910d('0x32')]){_0x24e2a1[_0x910d('0x31')]=_[_0x910d('0x33')](_0x24e2a1[_0x910d('0x31')],{'$or':_[_0x910d('0x4b')](_0x24e2a1[_0x910d('0x2c')],function(_0x564273){var _0x386a98={};_0x386a98[_0x564273]={'$like':'%'+_0x4c4daa['query']['filter']+'%'};return _0x386a98;})});}_0x24e2a1=_[_0x910d('0x33')]({},_0x24e2a1,_0x4c4daa['options']);return _0x3c467d[_0x910d('0x4c')](_0x24e2a1);}})['then'](function(_0x2d5c76){if(_0x2d5c76){_0x326349=_0x2d5c76[_0x910d('0x2d')];if(!_0x4c4daa['query'][_0x910d('0x48')](_0x910d('0x2e'))){_0x24e2a1[_0x910d('0x1b')]=qs[_0x910d('0x1b')](_0x4c4daa[_0x910d('0x28')][_0x910d('0x1b')]);_0x24e2a1['offset']=qs['offset'](_0x4c4daa['query']['offset']);}return _0x3c467d[_0x910d('0x4c')](_0x24e2a1);}})['then'](function(_0x1a286b){if(_0x1a286b){return _0x1a286b?{'count':_0x326349,'rows':_0x1a286b}:null;}})['then'](respondWithResult(_0x29b4f7,null))[_0x910d('0x3d')](handleError(_0x29b4f7,null));};exports[_0x910d('0x4d')]=function(_0xd4185f,_0x124965,_0xc83266){if(_0xd4185f[_0x910d('0x41')]['id']){delete _0xd4185f[_0x910d('0x41')]['id'];}return db[_0x910d('0x37')][_0x910d('0x44')]({'where':{'id':_0xd4185f['params']['id']}})[_0x910d('0x21')](handleEntityNotFound(_0x124965,null))[_0x910d('0x21')](function(_0xacd43f){if(_0xacd43f){return _0xacd43f[_0x910d('0x4d')](_0xd4185f[_0x910d('0x41')][_0x910d('0x4e')]||[]);}return null;})[_0x910d('0x21')](respondWithResult(_0x124965,null))['catch'](handleError(_0x124965,null));};