Built motion from commit (unavailable).|2.5.28
[motion2.git] / server / api / intVtigerConfiguration / intVtigerConfiguration.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 _0x4b4d=['keys','intersection','query','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','merge','options','includeAll','findAll','catch','show','params','include','find','create','body','getFields','findOne','filter','getSubjects','VtigerField','getDescriptions','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','client','http','request','then','VtigerConfiguration,\x20%s,\x20%s','VtigerConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','code','message','info','request\x20sent','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','destroy','sendStatus','stack','name','send','index','map','VtigerConfiguration','rawAttributes','key','model'];(function(_0x546125,_0xfa3bf){var _0x77b546=function(_0x475555){while(--_0x475555){_0x546125['push'](_0x546125['shift']());}};_0x77b546(++_0xfa3bf);}(_0x4b4d,0x129));var _0xd4b4=function(_0x184609,_0x28ed5c){_0x184609=_0x184609-0x0;var _0x2e8520=_0x4b4d[_0x184609];return _0x2e8520;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xd4b4('0x0'));var rp=require(_0xd4b4('0x1'));var moment=require(_0xd4b4('0x2'));var BPromise=require(_0xd4b4('0x3'));var Mustache=require(_0xd4b4('0x4'));var util=require(_0xd4b4('0x5'));var path=require(_0xd4b4('0x6'));var sox=require('sox');var csv=require(_0xd4b4('0x7'));var ejs=require(_0xd4b4('0x8'));var fs=require('fs');var fs_extra=require(_0xd4b4('0x9'));var _=require(_0xd4b4('0xa'));var squel=require(_0xd4b4('0xb'));var crypto=require('crypto');var jsforce=require(_0xd4b4('0xc'));var deskjs=require(_0xd4b4('0xd'));var toCsv=require(_0xd4b4('0x7'));var querystring=require('querystring');var Papa=require(_0xd4b4('0xe'));var Redis=require(_0xd4b4('0xf'));var authService=require(_0xd4b4('0x10'));var qs=require(_0xd4b4('0x11'));var as=require(_0xd4b4('0x12'));var hardwareService=require(_0xd4b4('0x13'));var logger=require(_0xd4b4('0x14'))('api');var utils=require('../../config/utils');var config=require(_0xd4b4('0x15'));var licenseUtil=require(_0xd4b4('0x16'));var db=require(_0xd4b4('0x17'))['db'];var jayson=require('jayson/promise');var client=jayson[_0xd4b4('0x18')][_0xd4b4('0x19')]({'port':0x232a});function respondWithRpcPromise(_0x5ef676,_0xacbbf,_0x23ef90,_0x2b0207){return new BPromise(function(_0x16e19c,_0x5c9920){var _0x569df8=_0x2b0207||client;return _0x569df8[_0xd4b4('0x1a')](_0x5ef676,_0x23ef90)[_0xd4b4('0x1b')](function(_0x37af8c){logger['info'](_0xd4b4('0x1c'),_0xacbbf,'request\x20sent');logger['debug'](_0xd4b4('0x1d'),_0xacbbf,'request\x20sent',JSON[_0xd4b4('0x1e')](_0x37af8c));if(_0x37af8c[_0xd4b4('0x1f')]){if(_0x37af8c['error'][_0xd4b4('0x20')]===0x1f4){logger[_0xd4b4('0x1f')]('VtigerConfiguration,\x20%s,\x20%s',_0xacbbf,_0x37af8c[_0xd4b4('0x1f')][_0xd4b4('0x21')]);return _0x5c9920(_0x37af8c[_0xd4b4('0x1f')][_0xd4b4('0x21')]);}logger[_0xd4b4('0x1f')](_0xd4b4('0x1c'),_0xacbbf,_0x37af8c[_0xd4b4('0x1f')][_0xd4b4('0x21')]);return _0x16e19c(_0x37af8c[_0xd4b4('0x1f')][_0xd4b4('0x21')]);}else{logger[_0xd4b4('0x22')]('VtigerConfiguration,\x20%s,\x20%s',_0xacbbf,_0xd4b4('0x23'));_0x16e19c(_0x37af8c['result'][_0xd4b4('0x21')]);}})['catch'](function(_0x2d154c){logger['error'](_0xd4b4('0x1c'),_0xacbbf,_0x2d154c);_0x5c9920(_0x2d154c);});});}function respondWithStatusCode(_0x1b98eb,_0x444f67){_0x444f67=_0x444f67||0xcc;return function(_0x588a54){if(_0x588a54){return _0x1b98eb['sendStatus'](_0x444f67);}return _0x1b98eb[_0xd4b4('0x24')](_0x444f67)[_0xd4b4('0x25')]();};}function respondWithResult(_0x4c23d4,_0x418329){_0x418329=_0x418329||0xc8;return function(_0x4a0fbf){if(_0x4a0fbf){return _0x4c23d4['status'](_0x418329)[_0xd4b4('0x26')](_0x4a0fbf);}};}function respondWithFilteredResult(_0x496598,_0x2fb41c){return function(_0x2bad7d){if(_0x2bad7d){var _0x476521=_0x2bad7d[_0xd4b4('0x27')],_0x18eac6=_0x2fb41c['offset'],_0x5c7234=_0x2fb41c[_0xd4b4('0x28')]+_0x2fb41c[_0xd4b4('0x29')],_0xfef1be;if(_0x5c7234>=_0x476521){_0x5c7234=_0x476521;_0xfef1be=0xc8;}else{_0xfef1be=0xce;}_0x496598[_0xd4b4('0x24')](_0xfef1be);return _0x496598[_0xd4b4('0x2a')](_0xd4b4('0x2b'),_0x18eac6+'-'+_0x5c7234+'/'+_0x476521)[_0xd4b4('0x26')](_0x2bad7d);}return null;};}function patchUpdates(_0x3c91f2){return function(_0xccfe67){try{jsonpatch[_0xd4b4('0x2c')](_0xccfe67,_0x3c91f2,!![]);}catch(_0x4abd9a){return BPromise[_0xd4b4('0x2d')](_0x4abd9a);}return _0xccfe67[_0xd4b4('0x2e')]();};}function saveUpdates(_0x8ca31c,_0x3cb855){return function(_0x12597f){if(_0x12597f){return _0x12597f[_0xd4b4('0x2f')](_0x8ca31c)[_0xd4b4('0x1b')](function(_0x21b3d0){return _0x21b3d0;});}return null;};}function removeEntity(_0x4c60c8,_0x1b2e65){return function(_0x4d5322){if(_0x4d5322){return _0x4d5322[_0xd4b4('0x30')]()[_0xd4b4('0x1b')](function(){_0x4c60c8[_0xd4b4('0x24')](0xcc)['end']();});}};}function handleEntityNotFound(_0x518c72,_0x509dc9){return function(_0x3d8a52){if(!_0x3d8a52){_0x518c72[_0xd4b4('0x31')](0x194);}return _0x3d8a52;};}function handleError(_0x110cde,_0x1e4ceb){_0x1e4ceb=_0x1e4ceb||0x1f4;return function(_0x2c0278){logger[_0xd4b4('0x1f')](_0x2c0278[_0xd4b4('0x32')]);if(_0x2c0278['name']){delete _0x2c0278[_0xd4b4('0x33')];}_0x110cde['status'](_0x1e4ceb)[_0xd4b4('0x34')](_0x2c0278);};}exports[_0xd4b4('0x35')]=function(_0xf07252,_0x4230f5){var _0xaac519={},_0x45b119={},_0x207297={'count':0x0,'rows':[]};var _0x13d3c5=_[_0xd4b4('0x36')](db[_0xd4b4('0x37')][_0xd4b4('0x38')],function(_0x31d524){return{'name':_0x31d524['fieldName'],'type':_0x31d524['type'][_0xd4b4('0x39')]};});_0x45b119[_0xd4b4('0x3a')]=_['map'](_0x13d3c5,_0xd4b4('0x33'));_0x45b119['query']=_[_0xd4b4('0x3b')](_0xf07252['query']);_0x45b119['filters']=_[_0xd4b4('0x3c')](_0x45b119['model'],_0x45b119[_0xd4b4('0x3d')]);_0xaac519[_0xd4b4('0x3e')]=_[_0xd4b4('0x3c')](_0x45b119[_0xd4b4('0x3a')],qs[_0xd4b4('0x3f')](_0xf07252['query']['fields']));_0xaac519[_0xd4b4('0x3e')]=_0xaac519[_0xd4b4('0x3e')][_0xd4b4('0x40')]?_0xaac519[_0xd4b4('0x3e')]:_0x45b119['model'];if(!_0xf07252[_0xd4b4('0x3d')][_0xd4b4('0x41')](_0xd4b4('0x42'))){_0xaac519['limit']=qs['limit'](_0xf07252[_0xd4b4('0x3d')][_0xd4b4('0x29')]);_0xaac519['offset']=qs[_0xd4b4('0x28')](_0xf07252['query']['offset']);}_0xaac519[_0xd4b4('0x43')]=qs['sort'](_0xf07252['query'][_0xd4b4('0x44')]);_0xaac519[_0xd4b4('0x45')]=qs[_0xd4b4('0x46')](_[_0xd4b4('0x47')](_0xf07252[_0xd4b4('0x3d')],_0x45b119[_0xd4b4('0x46')]),_0x13d3c5);if(_0xf07252['query']['filter']){_0xaac519[_0xd4b4('0x45')]=_[_0xd4b4('0x48')](_0xaac519[_0xd4b4('0x45')],{'$or':_['map'](_0x13d3c5,function(_0x3b2188){if(_0x3b2188['type']!=='VIRTUAL'){var _0x121c1f={};_0x121c1f[_0x3b2188['name']]={'$like':'%'+_0xf07252['query']['filter']+'%'};return _0x121c1f;}})});}_0xaac519=_[_0xd4b4('0x48')]({},_0xaac519,_0xf07252[_0xd4b4('0x49')]);var _0x560570={'where':_0xaac519['where']};return db[_0xd4b4('0x37')][_0xd4b4('0x27')](_0x560570)['then'](function(_0x3a7224){_0x207297['count']=_0x3a7224;if(_0xf07252[_0xd4b4('0x3d')][_0xd4b4('0x4a')]){_0xaac519['include']=[{'all':!![]}];}return db[_0xd4b4('0x37')][_0xd4b4('0x4b')](_0xaac519);})[_0xd4b4('0x1b')](function(_0x24cde7){_0x207297['rows']=_0x24cde7;return _0x207297;})[_0xd4b4('0x1b')](respondWithFilteredResult(_0x4230f5,_0xaac519))[_0xd4b4('0x4c')](handleError(_0x4230f5,null));};exports[_0xd4b4('0x4d')]=function(_0x35c1c8,_0x3b51b0){var _0x422a29={'raw':![],'where':{'id':_0x35c1c8[_0xd4b4('0x4e')]['id']}},_0x92ad27={};_0x92ad27[_0xd4b4('0x3a')]=_[_0xd4b4('0x3b')](db[_0xd4b4('0x37')][_0xd4b4('0x38')]);_0x92ad27[_0xd4b4('0x3d')]=_[_0xd4b4('0x3b')](_0x35c1c8[_0xd4b4('0x3d')]);_0x92ad27[_0xd4b4('0x46')]=_[_0xd4b4('0x3c')](_0x92ad27[_0xd4b4('0x3a')],_0x92ad27[_0xd4b4('0x3d')]);_0x422a29[_0xd4b4('0x3e')]=_['intersection'](_0x92ad27[_0xd4b4('0x3a')],qs['fields'](_0x35c1c8['query'][_0xd4b4('0x3f')]));_0x422a29['attributes']=_0x422a29[_0xd4b4('0x3e')][_0xd4b4('0x40')]?_0x422a29[_0xd4b4('0x3e')]:_0x92ad27[_0xd4b4('0x3a')];if(_0x35c1c8[_0xd4b4('0x3d')][_0xd4b4('0x4a')]){_0x422a29[_0xd4b4('0x4f')]=[{'all':!![]}];}_0x422a29=_['merge']({},_0x422a29,_0x35c1c8[_0xd4b4('0x49')]);return db[_0xd4b4('0x37')][_0xd4b4('0x50')](_0x422a29)[_0xd4b4('0x1b')](handleEntityNotFound(_0x3b51b0,null))[_0xd4b4('0x1b')](respondWithResult(_0x3b51b0,null))[_0xd4b4('0x4c')](handleError(_0x3b51b0,null));};exports[_0xd4b4('0x51')]=function(_0xce11a3,_0x1b5cb5){return db[_0xd4b4('0x37')][_0xd4b4('0x51')](_0xce11a3[_0xd4b4('0x52')],{})[_0xd4b4('0x1b')](respondWithResult(_0x1b5cb5,0xc9))[_0xd4b4('0x4c')](handleError(_0x1b5cb5,null));};exports[_0xd4b4('0x2f')]=function(_0x4bc374,_0x59e911){if(_0x4bc374[_0xd4b4('0x52')]['id']){delete _0x4bc374[_0xd4b4('0x52')]['id'];}return db[_0xd4b4('0x37')][_0xd4b4('0x50')]({'where':{'id':_0x4bc374[_0xd4b4('0x4e')]['id']}})[_0xd4b4('0x1b')](handleEntityNotFound(_0x59e911,null))[_0xd4b4('0x1b')](saveUpdates(_0x4bc374[_0xd4b4('0x52')],null))['then'](respondWithResult(_0x59e911,null))[_0xd4b4('0x4c')](handleError(_0x59e911,null));};exports[_0xd4b4('0x30')]=function(_0x526f87,_0x310c2d){return db[_0xd4b4('0x37')][_0xd4b4('0x50')]({'where':{'id':_0x526f87[_0xd4b4('0x4e')]['id']}})[_0xd4b4('0x1b')](handleEntityNotFound(_0x310c2d,null))['then'](removeEntity(_0x310c2d,null))[_0xd4b4('0x4c')](handleError(_0x310c2d,null));};exports[_0xd4b4('0x53')]=function(_0x1af4d3,_0x314632,_0x2cf3cd){var _0x4f46ca={};var _0x196c1f={};var _0x463854;var _0x502a77;return db[_0xd4b4('0x37')][_0xd4b4('0x54')]({'where':{'id':_0x1af4d3[_0xd4b4('0x4e')]['id']}})[_0xd4b4('0x1b')](handleEntityNotFound(_0x314632,null))[_0xd4b4('0x1b')](function(_0x3c0a1c){if(_0x3c0a1c){_0x463854=_0x3c0a1c;_0x196c1f[_0xd4b4('0x3a')]=_['keys'](db['VtigerField'][_0xd4b4('0x38')]);_0x196c1f[_0xd4b4('0x3d')]=_[_0xd4b4('0x3b')](_0x1af4d3[_0xd4b4('0x3d')]);_0x196c1f[_0xd4b4('0x46')]=_[_0xd4b4('0x3c')](_0x196c1f[_0xd4b4('0x3a')],_0x196c1f['query']);_0x4f46ca[_0xd4b4('0x3e')]=_[_0xd4b4('0x3c')](_0x196c1f[_0xd4b4('0x3a')],qs[_0xd4b4('0x3f')](_0x1af4d3['query']['fields']));_0x4f46ca[_0xd4b4('0x3e')]=_0x4f46ca['attributes'][_0xd4b4('0x40')]?_0x4f46ca[_0xd4b4('0x3e')]:_0x196c1f[_0xd4b4('0x3a')];_0x4f46ca[_0xd4b4('0x43')]=qs[_0xd4b4('0x44')](_0x1af4d3['query'][_0xd4b4('0x44')]);_0x4f46ca['where']=qs[_0xd4b4('0x46')](_['pick'](_0x1af4d3[_0xd4b4('0x3d')],_0x196c1f[_0xd4b4('0x46')]));if(_0x1af4d3[_0xd4b4('0x3d')][_0xd4b4('0x55')]){_0x4f46ca[_0xd4b4('0x45')]=_[_0xd4b4('0x48')](_0x4f46ca[_0xd4b4('0x45')],{'$or':_['map'](_0x4f46ca[_0xd4b4('0x3e')],function(_0x493678){var _0x5c194a={};_0x5c194a[_0x493678]={'$like':'%'+_0x1af4d3[_0xd4b4('0x3d')]['filter']+'%'};return _0x5c194a;})});}_0x4f46ca=_[_0xd4b4('0x48')]({},_0x4f46ca,_0x1af4d3[_0xd4b4('0x49')]);return _0x463854[_0xd4b4('0x53')](_0x4f46ca);}})[_0xd4b4('0x1b')](function(_0xa6d515){if(_0xa6d515){_0x502a77=_0xa6d515[_0xd4b4('0x40')];if(!_0x1af4d3['query'][_0xd4b4('0x41')](_0xd4b4('0x42'))){_0x4f46ca['limit']=qs[_0xd4b4('0x29')](_0x1af4d3[_0xd4b4('0x3d')][_0xd4b4('0x29')]);_0x4f46ca[_0xd4b4('0x28')]=qs['offset'](_0x1af4d3[_0xd4b4('0x3d')]['offset']);}return _0x463854[_0xd4b4('0x53')](_0x4f46ca);}})[_0xd4b4('0x1b')](function(_0x116ab0){if(_0x116ab0){return _0x116ab0?{'count':_0x502a77,'rows':_0x116ab0}:null;}})[_0xd4b4('0x1b')](respondWithResult(_0x314632,null))[_0xd4b4('0x4c')](handleError(_0x314632,null));};exports[_0xd4b4('0x56')]=function(_0x266ad6,_0x391a04,_0x3e8ac0){var _0x554af7={};var _0x2d1031={};var _0x120df7;var _0x1a62d1;return db['VtigerConfiguration']['findOne']({'where':{'id':_0x266ad6['params']['id']}})['then'](handleEntityNotFound(_0x391a04,null))[_0xd4b4('0x1b')](function(_0x4ff1be){if(_0x4ff1be){_0x120df7=_0x4ff1be;_0x2d1031[_0xd4b4('0x3a')]=_[_0xd4b4('0x3b')](db[_0xd4b4('0x57')][_0xd4b4('0x38')]);_0x2d1031['query']=_[_0xd4b4('0x3b')](_0x266ad6[_0xd4b4('0x3d')]);_0x2d1031[_0xd4b4('0x46')]=_[_0xd4b4('0x3c')](_0x2d1031['model'],_0x2d1031['query']);_0x554af7[_0xd4b4('0x3e')]=_[_0xd4b4('0x3c')](_0x2d1031[_0xd4b4('0x3a')],qs[_0xd4b4('0x3f')](_0x266ad6[_0xd4b4('0x3d')]['fields']));_0x554af7[_0xd4b4('0x3e')]=_0x554af7['attributes'][_0xd4b4('0x40')]?_0x554af7[_0xd4b4('0x3e')]:_0x2d1031['model'];_0x554af7[_0xd4b4('0x43')]=qs[_0xd4b4('0x44')](_0x266ad6[_0xd4b4('0x3d')][_0xd4b4('0x44')]);_0x554af7[_0xd4b4('0x45')]=qs['filters'](_[_0xd4b4('0x47')](_0x266ad6[_0xd4b4('0x3d')],_0x2d1031[_0xd4b4('0x46')]));if(_0x266ad6[_0xd4b4('0x3d')][_0xd4b4('0x55')]){_0x554af7[_0xd4b4('0x45')]=_['merge'](_0x554af7[_0xd4b4('0x45')],{'$or':_[_0xd4b4('0x36')](_0x554af7[_0xd4b4('0x3e')],function(_0x20ae80){var _0x4e580a={};_0x4e580a[_0x20ae80]={'$like':'%'+_0x266ad6[_0xd4b4('0x3d')]['filter']+'%'};return _0x4e580a;})});}_0x554af7=_[_0xd4b4('0x48')]({},_0x554af7,_0x266ad6[_0xd4b4('0x49')]);return _0x120df7['getSubjects'](_0x554af7);}})[_0xd4b4('0x1b')](function(_0x4d4210){if(_0x4d4210){_0x1a62d1=_0x4d4210[_0xd4b4('0x40')];if(!_0x266ad6[_0xd4b4('0x3d')][_0xd4b4('0x41')](_0xd4b4('0x42'))){_0x554af7[_0xd4b4('0x29')]=qs['limit'](_0x266ad6[_0xd4b4('0x3d')]['limit']);_0x554af7[_0xd4b4('0x28')]=qs[_0xd4b4('0x28')](_0x266ad6['query'][_0xd4b4('0x28')]);}return _0x120df7[_0xd4b4('0x56')](_0x554af7);}})[_0xd4b4('0x1b')](function(_0x7c9c1){if(_0x7c9c1){return _0x7c9c1?{'count':_0x1a62d1,'rows':_0x7c9c1}:null;}})['then'](respondWithResult(_0x391a04,null))[_0xd4b4('0x4c')](handleError(_0x391a04,null));};exports[_0xd4b4('0x58')]=function(_0x1ec874,_0x3d913f,_0x54d55c){var _0x31c344={};var _0x5b1f5c={};var _0xdaba85;var _0x5b2a2a;return db[_0xd4b4('0x37')][_0xd4b4('0x54')]({'where':{'id':_0x1ec874[_0xd4b4('0x4e')]['id']}})[_0xd4b4('0x1b')](handleEntityNotFound(_0x3d913f,null))['then'](function(_0x3911f8){if(_0x3911f8){_0xdaba85=_0x3911f8;_0x5b1f5c['model']=_[_0xd4b4('0x3b')](db['VtigerField'][_0xd4b4('0x38')]);_0x5b1f5c[_0xd4b4('0x3d')]=_['keys'](_0x1ec874['query']);_0x5b1f5c[_0xd4b4('0x46')]=_[_0xd4b4('0x3c')](_0x5b1f5c[_0xd4b4('0x3a')],_0x5b1f5c[_0xd4b4('0x3d')]);_0x31c344[_0xd4b4('0x3e')]=_[_0xd4b4('0x3c')](_0x5b1f5c['model'],qs[_0xd4b4('0x3f')](_0x1ec874[_0xd4b4('0x3d')][_0xd4b4('0x3f')]));_0x31c344[_0xd4b4('0x3e')]=_0x31c344[_0xd4b4('0x3e')]['length']?_0x31c344['attributes']:_0x5b1f5c[_0xd4b4('0x3a')];_0x31c344[_0xd4b4('0x43')]=qs[_0xd4b4('0x44')](_0x1ec874[_0xd4b4('0x3d')]['sort']);_0x31c344['where']=qs[_0xd4b4('0x46')](_[_0xd4b4('0x47')](_0x1ec874[_0xd4b4('0x3d')],_0x5b1f5c[_0xd4b4('0x46')]));if(_0x1ec874[_0xd4b4('0x3d')]['filter']){_0x31c344[_0xd4b4('0x45')]=_['merge'](_0x31c344[_0xd4b4('0x45')],{'$or':_[_0xd4b4('0x36')](_0x31c344[_0xd4b4('0x3e')],function(_0x1ad47b){var _0x4b2c8c={};_0x4b2c8c[_0x1ad47b]={'$like':'%'+_0x1ec874[_0xd4b4('0x3d')][_0xd4b4('0x55')]+'%'};return _0x4b2c8c;})});}_0x31c344=_[_0xd4b4('0x48')]({},_0x31c344,_0x1ec874[_0xd4b4('0x49')]);return _0xdaba85[_0xd4b4('0x58')](_0x31c344);}})[_0xd4b4('0x1b')](function(_0x25745b){if(_0x25745b){_0x5b2a2a=_0x25745b[_0xd4b4('0x40')];if(!_0x1ec874[_0xd4b4('0x3d')][_0xd4b4('0x41')]('nolimit')){_0x31c344['limit']=qs['limit'](_0x1ec874[_0xd4b4('0x3d')][_0xd4b4('0x29')]);_0x31c344[_0xd4b4('0x28')]=qs['offset'](_0x1ec874['query'][_0xd4b4('0x28')]);}return _0xdaba85[_0xd4b4('0x58')](_0x31c344);}})[_0xd4b4('0x1b')](function(_0x3e78ce){if(_0x3e78ce){return _0x3e78ce?{'count':_0x5b2a2a,'rows':_0x3e78ce}:null;}})['then'](respondWithResult(_0x3d913f,null))['catch'](handleError(_0x3d913f,null));};