Built motion from commit (unavailable).|2.5.25
[motion2.git] / server / api / intZohoConfiguration / intZohoConfiguration.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 _0x5f2e=['getDescriptions','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','to-csv','ejs','lodash','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../config/license/util','jayson/promise','http','request','then','ZohoConfiguration,\x20%s,\x20%s','request\x20sent','debug','ZohoConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','message','info','catch','sendStatus','end','status','json','offset','set','reject','save','update','destroy','stack','name','send','index','map','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','merge','type','VIRTUAL','filter','ZohoConfiguration','count','includeAll','show','params','fields','options','find','create','body','getFields','findOne','ZohoField','getSubjects'];(function(_0x233b53,_0x4f3487){var _0x3bf857=function(_0x5b2ef7){while(--_0x5b2ef7){_0x233b53['push'](_0x233b53['shift']());}};_0x3bf857(++_0x4f3487);}(_0x5f2e,0xb1));var _0xe5f2=function(_0x321bb2,_0x202794){_0x321bb2=_0x321bb2-0x0;var _0x9c12ed=_0x5f2e[_0x321bb2];return _0x9c12ed;};'use strict';var pdf=require(_0xe5f2('0x0'));var emlformat=require(_0xe5f2('0x1'));var rimraf=require(_0xe5f2('0x2'));var zipdir=require(_0xe5f2('0x3'));var jsonpatch=require(_0xe5f2('0x4'));var rp=require(_0xe5f2('0x5'));var moment=require('moment');var BPromise=require(_0xe5f2('0x6'));var Mustache=require(_0xe5f2('0x7'));var util=require(_0xe5f2('0x8'));var path=require(_0xe5f2('0x9'));var sox=require('sox');var csv=require(_0xe5f2('0xa'));var ejs=require(_0xe5f2('0xb'));var fs=require('fs');var _=require(_0xe5f2('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xe5f2('0xd'));var deskjs=require(_0xe5f2('0xe'));var toCsv=require(_0xe5f2('0xa'));var querystring=require(_0xe5f2('0xf'));var Papa=require(_0xe5f2('0x10'));var Redis=require(_0xe5f2('0x11'));var authService=require('../../components/auth/service');var qs=require(_0xe5f2('0x12'));var as=require(_0xe5f2('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xe5f2('0x14'))(_0xe5f2('0x15'));var utils=require('../../config/utils');var config=require(_0xe5f2('0x16'));var licenseUtil=require(_0xe5f2('0x17'));var db=require('../../mysqldb')['db'];var jayson=require(_0xe5f2('0x18'));var client=jayson['client'][_0xe5f2('0x19')]({'port':0x232a});function respondWithRpcPromise(_0x589c71,_0x3706c7,_0x28e9ee,_0x3c0dcc){return new BPromise(function(_0x2fc9bc,_0x346f9f){var _0x2ce490=_0x3c0dcc||client;return _0x2ce490[_0xe5f2('0x1a')](_0x589c71,_0x28e9ee)[_0xe5f2('0x1b')](function(_0x1ced14){logger['info'](_0xe5f2('0x1c'),_0x3706c7,_0xe5f2('0x1d'));logger[_0xe5f2('0x1e')](_0xe5f2('0x1f'),_0x3706c7,_0xe5f2('0x1d'),JSON[_0xe5f2('0x20')](_0x1ced14));if(_0x1ced14['error']){if(_0x1ced14[_0xe5f2('0x21')]['code']===0x1f4){logger[_0xe5f2('0x21')](_0xe5f2('0x1c'),_0x3706c7,_0x1ced14[_0xe5f2('0x21')][_0xe5f2('0x22')]);return _0x346f9f(_0x1ced14['error'][_0xe5f2('0x22')]);}logger[_0xe5f2('0x21')]('ZohoConfiguration,\x20%s,\x20%s',_0x3706c7,_0x1ced14[_0xe5f2('0x21')][_0xe5f2('0x22')]);return _0x2fc9bc(_0x1ced14[_0xe5f2('0x21')]['message']);}else{logger[_0xe5f2('0x23')](_0xe5f2('0x1c'),_0x3706c7,_0xe5f2('0x1d'));_0x2fc9bc(_0x1ced14['result'][_0xe5f2('0x22')]);}})[_0xe5f2('0x24')](function(_0x4203af){logger[_0xe5f2('0x21')](_0xe5f2('0x1c'),_0x3706c7,_0x4203af);_0x346f9f(_0x4203af);});});}function respondWithStatusCode(_0x3a3103,_0x20d7e0){_0x20d7e0=_0x20d7e0||0xcc;return function(_0x4db400){if(_0x4db400){return _0x3a3103[_0xe5f2('0x25')](_0x20d7e0);}return _0x3a3103['status'](_0x20d7e0)[_0xe5f2('0x26')]();};}function respondWithResult(_0x244bef,_0x3bb753){_0x3bb753=_0x3bb753||0xc8;return function(_0x23ac1b){if(_0x23ac1b){return _0x244bef[_0xe5f2('0x27')](_0x3bb753)[_0xe5f2('0x28')](_0x23ac1b);}};}function respondWithFilteredResult(_0xd9eb3b,_0x512695){return function(_0x410455){if(_0x410455){var _0x493dfd=_0x410455['count'],_0x1d191=_0x512695[_0xe5f2('0x29')],_0x2f2bbd=_0x512695[_0xe5f2('0x29')]+_0x512695['limit'],_0x103f10;if(_0x2f2bbd>=_0x493dfd){_0x2f2bbd=_0x493dfd;_0x103f10=0xc8;}else{_0x103f10=0xce;}_0xd9eb3b[_0xe5f2('0x27')](_0x103f10);return _0xd9eb3b[_0xe5f2('0x2a')]('Content-Range',_0x1d191+'-'+_0x2f2bbd+'/'+_0x493dfd)[_0xe5f2('0x28')](_0x410455);}return null;};}function patchUpdates(_0x1681af){return function(_0x562099){try{jsonpatch['apply'](_0x562099,_0x1681af,!![]);}catch(_0x571075){return BPromise[_0xe5f2('0x2b')](_0x571075);}return _0x562099[_0xe5f2('0x2c')]();};}function saveUpdates(_0x533be7,_0x272369){return function(_0x5d333d){if(_0x5d333d){return _0x5d333d[_0xe5f2('0x2d')](_0x533be7)[_0xe5f2('0x1b')](function(_0x380208){return _0x380208;});}return null;};}function removeEntity(_0x3a9799,_0x505fac){return function(_0x44cb33){if(_0x44cb33){return _0x44cb33[_0xe5f2('0x2e')]()['then'](function(){_0x3a9799[_0xe5f2('0x27')](0xcc)[_0xe5f2('0x26')]();});}};}function handleEntityNotFound(_0x566cb6,_0xe26914){return function(_0x5cbe01){if(!_0x5cbe01){_0x566cb6[_0xe5f2('0x25')](0x194);}return _0x5cbe01;};}function handleError(_0x270f4b,_0x5cd398){_0x5cd398=_0x5cd398||0x1f4;return function(_0x34ea31){logger[_0xe5f2('0x21')](_0x34ea31[_0xe5f2('0x2f')]);if(_0x34ea31[_0xe5f2('0x30')]){delete _0x34ea31[_0xe5f2('0x30')];}_0x270f4b[_0xe5f2('0x27')](_0x5cd398)[_0xe5f2('0x31')](_0x34ea31);};}exports[_0xe5f2('0x32')]=function(_0x3e0c82,_0x234d2f){var _0x2a5b28={},_0x238fd7={},_0x37e4bb={'count':0x0,'rows':[]};var _0x1e1e29=_[_0xe5f2('0x33')](db['ZohoConfiguration'][_0xe5f2('0x34')],function(_0x6dd275){return{'name':_0x6dd275[_0xe5f2('0x35')],'type':_0x6dd275['type'][_0xe5f2('0x36')]};});_0x238fd7[_0xe5f2('0x37')]=_[_0xe5f2('0x33')](_0x1e1e29,'name');_0x238fd7[_0xe5f2('0x38')]=_[_0xe5f2('0x39')](_0x3e0c82[_0xe5f2('0x38')]);_0x238fd7[_0xe5f2('0x3a')]=_[_0xe5f2('0x3b')](_0x238fd7[_0xe5f2('0x37')],_0x238fd7['query']);_0x2a5b28[_0xe5f2('0x3c')]=_[_0xe5f2('0x3b')](_0x238fd7[_0xe5f2('0x37')],qs['fields'](_0x3e0c82[_0xe5f2('0x38')]['fields']));_0x2a5b28[_0xe5f2('0x3c')]=_0x2a5b28[_0xe5f2('0x3c')][_0xe5f2('0x3d')]?_0x2a5b28['attributes']:_0x238fd7[_0xe5f2('0x37')];if(!_0x3e0c82[_0xe5f2('0x38')][_0xe5f2('0x3e')](_0xe5f2('0x3f'))){_0x2a5b28['limit']=qs[_0xe5f2('0x40')](_0x3e0c82['query']['limit']);_0x2a5b28[_0xe5f2('0x29')]=qs[_0xe5f2('0x29')](_0x3e0c82[_0xe5f2('0x38')][_0xe5f2('0x29')]);}_0x2a5b28[_0xe5f2('0x41')]=qs[_0xe5f2('0x42')](_0x3e0c82[_0xe5f2('0x38')][_0xe5f2('0x42')]);_0x2a5b28[_0xe5f2('0x43')]=qs['filters'](_[_0xe5f2('0x44')](_0x3e0c82[_0xe5f2('0x38')],_0x238fd7[_0xe5f2('0x3a')]),_0x1e1e29);if(_0x3e0c82['query']['filter']){_0x2a5b28['where']=_[_0xe5f2('0x45')](_0x2a5b28[_0xe5f2('0x43')],{'$or':_[_0xe5f2('0x33')](_0x1e1e29,function(_0x38125a){if(_0x38125a[_0xe5f2('0x46')]!==_0xe5f2('0x47')){var _0x56f6f4={};_0x56f6f4[_0x38125a['name']]={'$like':'%'+_0x3e0c82['query'][_0xe5f2('0x48')]+'%'};return _0x56f6f4;}})});}_0x2a5b28=_['merge']({},_0x2a5b28,_0x3e0c82['options']);var _0x33ce7b={'where':_0x2a5b28[_0xe5f2('0x43')]};return db[_0xe5f2('0x49')][_0xe5f2('0x4a')](_0x33ce7b)[_0xe5f2('0x1b')](function(_0xfedfb6){_0x37e4bb['count']=_0xfedfb6;if(_0x3e0c82[_0xe5f2('0x38')][_0xe5f2('0x4b')]){_0x2a5b28['include']=[{'all':!![]}];}return db[_0xe5f2('0x49')]['findAll'](_0x2a5b28);})['then'](function(_0x336be9){_0x37e4bb['rows']=_0x336be9;return _0x37e4bb;})[_0xe5f2('0x1b')](respondWithFilteredResult(_0x234d2f,_0x2a5b28))[_0xe5f2('0x24')](handleError(_0x234d2f,null));};exports[_0xe5f2('0x4c')]=function(_0x31cbc9,_0x53f583){var _0xcadcec={'raw':![],'where':{'id':_0x31cbc9[_0xe5f2('0x4d')]['id']}},_0x22601f={};_0x22601f[_0xe5f2('0x37')]=_['keys'](db[_0xe5f2('0x49')]['rawAttributes']);_0x22601f['query']=_[_0xe5f2('0x39')](_0x31cbc9[_0xe5f2('0x38')]);_0x22601f['filters']=_[_0xe5f2('0x3b')](_0x22601f[_0xe5f2('0x37')],_0x22601f['query']);_0xcadcec[_0xe5f2('0x3c')]=_[_0xe5f2('0x3b')](_0x22601f[_0xe5f2('0x37')],qs[_0xe5f2('0x4e')](_0x31cbc9[_0xe5f2('0x38')][_0xe5f2('0x4e')]));_0xcadcec['attributes']=_0xcadcec[_0xe5f2('0x3c')]['length']?_0xcadcec[_0xe5f2('0x3c')]:_0x22601f[_0xe5f2('0x37')];if(_0x31cbc9[_0xe5f2('0x38')]['includeAll']){_0xcadcec['include']=[{'all':!![]}];}_0xcadcec=_['merge']({},_0xcadcec,_0x31cbc9[_0xe5f2('0x4f')]);return db[_0xe5f2('0x49')][_0xe5f2('0x50')](_0xcadcec)[_0xe5f2('0x1b')](handleEntityNotFound(_0x53f583,null))[_0xe5f2('0x1b')](respondWithResult(_0x53f583,null))['catch'](handleError(_0x53f583,null));};exports[_0xe5f2('0x51')]=function(_0x48c603,_0x6d6f0c){return db[_0xe5f2('0x49')][_0xe5f2('0x51')](_0x48c603[_0xe5f2('0x52')],{})[_0xe5f2('0x1b')](respondWithResult(_0x6d6f0c,0xc9))[_0xe5f2('0x24')](handleError(_0x6d6f0c,null));};exports[_0xe5f2('0x2d')]=function(_0x35c8a6,_0x427290){if(_0x35c8a6['body']['id']){delete _0x35c8a6[_0xe5f2('0x52')]['id'];}return db[_0xe5f2('0x49')][_0xe5f2('0x50')]({'where':{'id':_0x35c8a6[_0xe5f2('0x4d')]['id']}})['then'](handleEntityNotFound(_0x427290,null))[_0xe5f2('0x1b')](saveUpdates(_0x35c8a6[_0xe5f2('0x52')],null))[_0xe5f2('0x1b')](respondWithResult(_0x427290,null))[_0xe5f2('0x24')](handleError(_0x427290,null));};exports[_0xe5f2('0x2e')]=function(_0x42dcac,_0x2e04db){return db[_0xe5f2('0x49')][_0xe5f2('0x50')]({'where':{'id':_0x42dcac['params']['id']}})[_0xe5f2('0x1b')](handleEntityNotFound(_0x2e04db,null))[_0xe5f2('0x1b')](removeEntity(_0x2e04db,null))[_0xe5f2('0x24')](handleError(_0x2e04db,null));};exports[_0xe5f2('0x53')]=function(_0x3dec1a,_0x45ee7f,_0x90d32){var _0x110225={};var _0x5d3aa2={};var _0x402106;var _0x3af4aa;return db[_0xe5f2('0x49')][_0xe5f2('0x54')]({'where':{'id':_0x3dec1a[_0xe5f2('0x4d')]['id']}})[_0xe5f2('0x1b')](handleEntityNotFound(_0x45ee7f,null))[_0xe5f2('0x1b')](function(_0x42eaaf){if(_0x42eaaf){_0x402106=_0x42eaaf;_0x5d3aa2[_0xe5f2('0x37')]=_['keys'](db[_0xe5f2('0x55')][_0xe5f2('0x34')]);_0x5d3aa2['query']=_['keys'](_0x3dec1a[_0xe5f2('0x38')]);_0x5d3aa2['filters']=_[_0xe5f2('0x3b')](_0x5d3aa2['model'],_0x5d3aa2[_0xe5f2('0x38')]);_0x110225[_0xe5f2('0x3c')]=_[_0xe5f2('0x3b')](_0x5d3aa2[_0xe5f2('0x37')],qs[_0xe5f2('0x4e')](_0x3dec1a[_0xe5f2('0x38')]['fields']));_0x110225[_0xe5f2('0x3c')]=_0x110225[_0xe5f2('0x3c')][_0xe5f2('0x3d')]?_0x110225[_0xe5f2('0x3c')]:_0x5d3aa2[_0xe5f2('0x37')];_0x110225[_0xe5f2('0x41')]=qs['sort'](_0x3dec1a[_0xe5f2('0x38')][_0xe5f2('0x42')]);_0x110225[_0xe5f2('0x43')]=qs[_0xe5f2('0x3a')](_[_0xe5f2('0x44')](_0x3dec1a[_0xe5f2('0x38')],_0x5d3aa2[_0xe5f2('0x3a')]));if(_0x3dec1a[_0xe5f2('0x38')][_0xe5f2('0x48')]){_0x110225[_0xe5f2('0x43')]=_[_0xe5f2('0x45')](_0x110225[_0xe5f2('0x43')],{'$or':_[_0xe5f2('0x33')](_0x110225[_0xe5f2('0x3c')],function(_0xf227){var _0x407d93={};_0x407d93[_0xf227]={'$like':'%'+_0x3dec1a['query']['filter']+'%'};return _0x407d93;})});}_0x110225=_[_0xe5f2('0x45')]({},_0x110225,_0x3dec1a[_0xe5f2('0x4f')]);return _0x402106['getFields'](_0x110225);}})['then'](function(_0x1a062e){if(_0x1a062e){_0x3af4aa=_0x1a062e['length'];if(!_0x3dec1a[_0xe5f2('0x38')][_0xe5f2('0x3e')](_0xe5f2('0x3f'))){_0x110225[_0xe5f2('0x40')]=qs[_0xe5f2('0x40')](_0x3dec1a[_0xe5f2('0x38')]['limit']);_0x110225[_0xe5f2('0x29')]=qs[_0xe5f2('0x29')](_0x3dec1a[_0xe5f2('0x38')][_0xe5f2('0x29')]);}return _0x402106['getFields'](_0x110225);}})['then'](function(_0x2e6e6f){if(_0x2e6e6f){return _0x2e6e6f?{'count':_0x3af4aa,'rows':_0x2e6e6f}:null;}})['then'](respondWithResult(_0x45ee7f,null))[_0xe5f2('0x24')](handleError(_0x45ee7f,null));};exports[_0xe5f2('0x56')]=function(_0x5e370e,_0x2f0fa8,_0x420251){var _0x5d76b6={};var _0x3bc385={};var _0xcb39a5;var _0x38ffbc;return db[_0xe5f2('0x49')][_0xe5f2('0x54')]({'where':{'id':_0x5e370e['params']['id']}})[_0xe5f2('0x1b')](handleEntityNotFound(_0x2f0fa8,null))[_0xe5f2('0x1b')](function(_0x5c9664){if(_0x5c9664){_0xcb39a5=_0x5c9664;_0x3bc385[_0xe5f2('0x37')]=_['keys'](db[_0xe5f2('0x55')]['rawAttributes']);_0x3bc385[_0xe5f2('0x38')]=_['keys'](_0x5e370e[_0xe5f2('0x38')]);_0x3bc385['filters']=_['intersection'](_0x3bc385['model'],_0x3bc385[_0xe5f2('0x38')]);_0x5d76b6[_0xe5f2('0x3c')]=_[_0xe5f2('0x3b')](_0x3bc385[_0xe5f2('0x37')],qs['fields'](_0x5e370e[_0xe5f2('0x38')][_0xe5f2('0x4e')]));_0x5d76b6[_0xe5f2('0x3c')]=_0x5d76b6[_0xe5f2('0x3c')]['length']?_0x5d76b6[_0xe5f2('0x3c')]:_0x3bc385[_0xe5f2('0x37')];_0x5d76b6['order']=qs[_0xe5f2('0x42')](_0x5e370e['query'][_0xe5f2('0x42')]);_0x5d76b6[_0xe5f2('0x43')]=qs[_0xe5f2('0x3a')](_[_0xe5f2('0x44')](_0x5e370e[_0xe5f2('0x38')],_0x3bc385['filters']));if(_0x5e370e['query'][_0xe5f2('0x48')]){_0x5d76b6[_0xe5f2('0x43')]=_[_0xe5f2('0x45')](_0x5d76b6[_0xe5f2('0x43')],{'$or':_['map'](_0x5d76b6[_0xe5f2('0x3c')],function(_0x2db9d0){var _0x41b72a={};_0x41b72a[_0x2db9d0]={'$like':'%'+_0x5e370e[_0xe5f2('0x38')]['filter']+'%'};return _0x41b72a;})});}_0x5d76b6=_[_0xe5f2('0x45')]({},_0x5d76b6,_0x5e370e[_0xe5f2('0x4f')]);return _0xcb39a5[_0xe5f2('0x56')](_0x5d76b6);}})['then'](function(_0x32b3e8){if(_0x32b3e8){_0x38ffbc=_0x32b3e8[_0xe5f2('0x3d')];if(!_0x5e370e['query']['hasOwnProperty']('nolimit')){_0x5d76b6['limit']=qs['limit'](_0x5e370e['query'][_0xe5f2('0x40')]);_0x5d76b6[_0xe5f2('0x29')]=qs[_0xe5f2('0x29')](_0x5e370e[_0xe5f2('0x38')][_0xe5f2('0x29')]);}return _0xcb39a5[_0xe5f2('0x56')](_0x5d76b6);}})[_0xe5f2('0x1b')](function(_0xdc530b){if(_0xdc530b){return _0xdc530b?{'count':_0x38ffbc,'rows':_0xdc530b}:null;}})[_0xe5f2('0x1b')](respondWithResult(_0x2f0fa8,null))[_0xe5f2('0x24')](handleError(_0x2f0fa8,null));};exports['getDescriptions']=function(_0x1dbf86,_0x5e77f9,_0x33e39b){var _0x330558={};var _0x62b289={};var _0x225aa0;var _0x38bda5;return db[_0xe5f2('0x49')]['findOne']({'where':{'id':_0x1dbf86[_0xe5f2('0x4d')]['id']}})[_0xe5f2('0x1b')](handleEntityNotFound(_0x5e77f9,null))[_0xe5f2('0x1b')](function(_0x4509d4){if(_0x4509d4){_0x225aa0=_0x4509d4;_0x62b289['model']=_[_0xe5f2('0x39')](db[_0xe5f2('0x55')][_0xe5f2('0x34')]);_0x62b289[_0xe5f2('0x38')]=_[_0xe5f2('0x39')](_0x1dbf86['query']);_0x62b289[_0xe5f2('0x3a')]=_[_0xe5f2('0x3b')](_0x62b289['model'],_0x62b289[_0xe5f2('0x38')]);_0x330558[_0xe5f2('0x3c')]=_[_0xe5f2('0x3b')](_0x62b289[_0xe5f2('0x37')],qs[_0xe5f2('0x4e')](_0x1dbf86['query'][_0xe5f2('0x4e')]));_0x330558[_0xe5f2('0x3c')]=_0x330558[_0xe5f2('0x3c')][_0xe5f2('0x3d')]?_0x330558[_0xe5f2('0x3c')]:_0x62b289['model'];_0x330558[_0xe5f2('0x41')]=qs[_0xe5f2('0x42')](_0x1dbf86[_0xe5f2('0x38')][_0xe5f2('0x42')]);_0x330558[_0xe5f2('0x43')]=qs[_0xe5f2('0x3a')](_[_0xe5f2('0x44')](_0x1dbf86[_0xe5f2('0x38')],_0x62b289[_0xe5f2('0x3a')]));if(_0x1dbf86[_0xe5f2('0x38')]['filter']){_0x330558[_0xe5f2('0x43')]=_[_0xe5f2('0x45')](_0x330558[_0xe5f2('0x43')],{'$or':_[_0xe5f2('0x33')](_0x330558[_0xe5f2('0x3c')],function(_0x23470e){var _0x2dd7df={};_0x2dd7df[_0x23470e]={'$like':'%'+_0x1dbf86[_0xe5f2('0x38')][_0xe5f2('0x48')]+'%'};return _0x2dd7df;})});}_0x330558=_['merge']({},_0x330558,_0x1dbf86[_0xe5f2('0x4f')]);return _0x225aa0[_0xe5f2('0x57')](_0x330558);}})[_0xe5f2('0x1b')](function(_0x4368a3){if(_0x4368a3){_0x38bda5=_0x4368a3[_0xe5f2('0x3d')];if(!_0x1dbf86[_0xe5f2('0x38')][_0xe5f2('0x3e')](_0xe5f2('0x3f'))){_0x330558[_0xe5f2('0x40')]=qs[_0xe5f2('0x40')](_0x1dbf86['query']['limit']);_0x330558[_0xe5f2('0x29')]=qs['offset'](_0x1dbf86['query'][_0xe5f2('0x29')]);}return _0x225aa0[_0xe5f2('0x57')](_0x330558);}})[_0xe5f2('0x1b')](function(_0x9e51d4){if(_0x9e51d4){return _0x9e51d4?{'count':_0x38bda5,'rows':_0x9e51d4}:null;}})['then'](respondWithResult(_0x5e77f9,null))[_0xe5f2('0x24')](handleError(_0x5e77f9,null));};