server/api/intSalesforceConfiguration/intSalesforceConfiguration.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 _0x54ef=['getDescriptions','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','fs-extra','lodash','squel','jsforce','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','http','request','info','SalesforceConfiguration,\x20%s,\x20%s','SalesforceConfiguration,\x20%s,\x20%s,\x20%s','request\x20sent','stringify','error','code','message','result','catch','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','then','destroy','stack','name','map','SalesforceConfiguration','fieldName','key','model','query','keys','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','type','VIRTUAL','options','includeAll','include','findAll','rows','show','params','rawAttributes','find','create','body','getFields','findOne','SalesforceField','getSubjects'];(function(_0x1deb03,_0xd05ad8){var _0x189fe7=function(_0x321225){while(--_0x321225){_0x1deb03['push'](_0x1deb03['shift']());}};_0x189fe7(++_0xd05ad8);}(_0x54ef,0x112));var _0xf54e=function(_0x260bed,_0x5a7d78){_0x260bed=_0x260bed-0x0;var _0x3c0c1d=_0x54ef[_0x260bed];return _0x3c0c1d;};'use strict';var emlformat=require(_0xf54e('0x0'));var rimraf=require(_0xf54e('0x1'));var zipdir=require(_0xf54e('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xf54e('0x3'));var moment=require(_0xf54e('0x4'));var BPromise=require(_0xf54e('0x5'));var Mustache=require(_0xf54e('0x6'));var util=require(_0xf54e('0x7'));var path=require(_0xf54e('0x8'));var sox=require(_0xf54e('0x9'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xf54e('0xa'));var _=require(_0xf54e('0xb'));var squel=require(_0xf54e('0xc'));var crypto=require('crypto');var jsforce=require(_0xf54e('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xf54e('0xe'));var querystring=require(_0xf54e('0xf'));var Papa=require('papaparse');var Redis=require(_0xf54e('0x10'));var authService=require(_0xf54e('0x11'));var qs=require(_0xf54e('0x12'));var as=require(_0xf54e('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xf54e('0x14'))(_0xf54e('0x15'));var utils=require(_0xf54e('0x16'));var config=require(_0xf54e('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0xf54e('0x18'))['db'];var jayson=require('jayson/promise');var client=jayson['client'][_0xf54e('0x19')]({'port':0x232a});function respondWithRpcPromise(_0x2033e9,_0x28f776,_0x380f26,_0x5644aa){return new BPromise(function(_0x331732,_0x1bbeaa){var _0x1855fe=_0x5644aa||client;return _0x1855fe[_0xf54e('0x1a')](_0x2033e9,_0x380f26)['then'](function(_0x2366ee){logger[_0xf54e('0x1b')](_0xf54e('0x1c'),_0x28f776,'request\x20sent');logger['debug'](_0xf54e('0x1d'),_0x28f776,_0xf54e('0x1e'),JSON[_0xf54e('0x1f')](_0x2366ee));if(_0x2366ee[_0xf54e('0x20')]){if(_0x2366ee[_0xf54e('0x20')][_0xf54e('0x21')]===0x1f4){logger[_0xf54e('0x20')](_0xf54e('0x1c'),_0x28f776,_0x2366ee[_0xf54e('0x20')][_0xf54e('0x22')]);return _0x1bbeaa(_0x2366ee[_0xf54e('0x20')]['message']);}logger['error'](_0xf54e('0x1c'),_0x28f776,_0x2366ee['error'][_0xf54e('0x22')]);return _0x331732(_0x2366ee[_0xf54e('0x20')][_0xf54e('0x22')]);}else{logger[_0xf54e('0x1b')](_0xf54e('0x1c'),_0x28f776,_0xf54e('0x1e'));_0x331732(_0x2366ee[_0xf54e('0x23')][_0xf54e('0x22')]);}})[_0xf54e('0x24')](function(_0x5f9eea){logger[_0xf54e('0x20')]('SalesforceConfiguration,\x20%s,\x20%s',_0x28f776,_0x5f9eea);_0x1bbeaa(_0x5f9eea);});});}function respondWithStatusCode(_0x6f6d29,_0x54f914){_0x54f914=_0x54f914||0xcc;return function(_0x264a8f){if(_0x264a8f){return _0x6f6d29[_0xf54e('0x25')](_0x54f914);}return _0x6f6d29[_0xf54e('0x26')](_0x54f914)[_0xf54e('0x27')]();};}function respondWithResult(_0x3805a7,_0x160160){_0x160160=_0x160160||0xc8;return function(_0x1e08d1){if(_0x1e08d1){return _0x3805a7[_0xf54e('0x26')](_0x160160)[_0xf54e('0x28')](_0x1e08d1);}};}function respondWithFilteredResult(_0x33457f,_0xf6cdd7){return function(_0x39c0ae){if(_0x39c0ae){var _0x2ea001=_0x39c0ae[_0xf54e('0x29')],_0x5390b8=_0xf6cdd7['offset'],_0xb3706e=_0xf6cdd7[_0xf54e('0x2a')]+_0xf6cdd7[_0xf54e('0x2b')],_0x4cbf7c;if(_0xb3706e>=_0x2ea001){_0xb3706e=_0x2ea001;_0x4cbf7c=0xc8;}else{_0x4cbf7c=0xce;}_0x33457f[_0xf54e('0x26')](_0x4cbf7c);return _0x33457f[_0xf54e('0x2c')](_0xf54e('0x2d'),_0x5390b8+'-'+_0xb3706e+'/'+_0x2ea001)[_0xf54e('0x28')](_0x39c0ae);}return null;};}function patchUpdates(_0x36f985){return function(_0x54bd8f){try{jsonpatch['apply'](_0x54bd8f,_0x36f985,!![]);}catch(_0x2f96b1){return BPromise[_0xf54e('0x2e')](_0x2f96b1);}return _0x54bd8f[_0xf54e('0x2f')]();};}function saveUpdates(_0x16d00f,_0xb2d4c4){return function(_0x133cd7){if(_0x133cd7){return _0x133cd7[_0xf54e('0x30')](_0x16d00f)[_0xf54e('0x31')](function(_0x3ae704){return _0x3ae704;});}return null;};}function removeEntity(_0x12edc3,_0x5ea0cc){return function(_0x5f29d3){if(_0x5f29d3){return _0x5f29d3[_0xf54e('0x32')]()[_0xf54e('0x31')](function(){_0x12edc3['status'](0xcc)[_0xf54e('0x27')]();});}};}function handleEntityNotFound(_0x82e313,_0x379110){return function(_0x52ab49){if(!_0x52ab49){_0x82e313['sendStatus'](0x194);}return _0x52ab49;};}function handleError(_0x54bea4,_0x4bb173){_0x4bb173=_0x4bb173||0x1f4;return function(_0x3c0cca){logger[_0xf54e('0x20')](_0x3c0cca[_0xf54e('0x33')]);if(_0x3c0cca[_0xf54e('0x34')]){delete _0x3c0cca[_0xf54e('0x34')];}_0x54bea4[_0xf54e('0x26')](_0x4bb173)['send'](_0x3c0cca);};}exports['index']=function(_0x530cee,_0xc04e04){var _0x734187={},_0x59c003={},_0x4d9b06={'count':0x0,'rows':[]};var _0xda1d10=_[_0xf54e('0x35')](db[_0xf54e('0x36')]['rawAttributes'],function(_0x14ecc8){return{'name':_0x14ecc8[_0xf54e('0x37')],'type':_0x14ecc8['type'][_0xf54e('0x38')]};});_0x59c003[_0xf54e('0x39')]=_[_0xf54e('0x35')](_0xda1d10,_0xf54e('0x34'));_0x59c003[_0xf54e('0x3a')]=_[_0xf54e('0x3b')](_0x530cee['query']);_0x59c003['filters']=_[_0xf54e('0x3c')](_0x59c003[_0xf54e('0x39')],_0x59c003[_0xf54e('0x3a')]);_0x734187['attributes']=_[_0xf54e('0x3c')](_0x59c003[_0xf54e('0x39')],qs[_0xf54e('0x3d')](_0x530cee[_0xf54e('0x3a')][_0xf54e('0x3d')]));_0x734187[_0xf54e('0x3e')]=_0x734187[_0xf54e('0x3e')][_0xf54e('0x3f')]?_0x734187[_0xf54e('0x3e')]:_0x59c003[_0xf54e('0x39')];if(!_0x530cee[_0xf54e('0x3a')][_0xf54e('0x40')](_0xf54e('0x41'))){_0x734187[_0xf54e('0x2b')]=qs[_0xf54e('0x2b')](_0x530cee['query']['limit']);_0x734187['offset']=qs[_0xf54e('0x2a')](_0x530cee[_0xf54e('0x3a')]['offset']);}_0x734187[_0xf54e('0x42')]=qs[_0xf54e('0x43')](_0x530cee[_0xf54e('0x3a')]['sort']);_0x734187[_0xf54e('0x44')]=qs[_0xf54e('0x45')](_[_0xf54e('0x46')](_0x530cee[_0xf54e('0x3a')],_0x59c003[_0xf54e('0x45')]),_0xda1d10);if(_0x530cee[_0xf54e('0x3a')][_0xf54e('0x47')]){_0x734187[_0xf54e('0x44')]=_[_0xf54e('0x48')](_0x734187['where'],{'$or':_[_0xf54e('0x35')](_0xda1d10,function(_0x3447fd){if(_0x3447fd[_0xf54e('0x49')]!==_0xf54e('0x4a')){var _0x2aac11={};_0x2aac11[_0x3447fd[_0xf54e('0x34')]]={'$like':'%'+_0x530cee['query'][_0xf54e('0x47')]+'%'};return _0x2aac11;}})});}_0x734187=_['merge']({},_0x734187,_0x530cee[_0xf54e('0x4b')]);var _0x4a7e3b={'where':_0x734187[_0xf54e('0x44')]};return db[_0xf54e('0x36')][_0xf54e('0x29')](_0x4a7e3b)['then'](function(_0x1af35d){_0x4d9b06[_0xf54e('0x29')]=_0x1af35d;if(_0x530cee[_0xf54e('0x3a')][_0xf54e('0x4c')]){_0x734187[_0xf54e('0x4d')]=[{'all':!![]}];}return db['SalesforceConfiguration'][_0xf54e('0x4e')](_0x734187);})[_0xf54e('0x31')](function(_0x346bb4){_0x4d9b06[_0xf54e('0x4f')]=_0x346bb4;return _0x4d9b06;})['then'](respondWithFilteredResult(_0xc04e04,_0x734187))[_0xf54e('0x24')](handleError(_0xc04e04,null));};exports[_0xf54e('0x50')]=function(_0x554c1f,_0x22c842){var _0xd4d956={'raw':![],'where':{'id':_0x554c1f[_0xf54e('0x51')]['id']}},_0x3d24c7={};_0x3d24c7['model']=_[_0xf54e('0x3b')](db[_0xf54e('0x36')][_0xf54e('0x52')]);_0x3d24c7[_0xf54e('0x3a')]=_[_0xf54e('0x3b')](_0x554c1f[_0xf54e('0x3a')]);_0x3d24c7[_0xf54e('0x45')]=_[_0xf54e('0x3c')](_0x3d24c7[_0xf54e('0x39')],_0x3d24c7[_0xf54e('0x3a')]);_0xd4d956[_0xf54e('0x3e')]=_[_0xf54e('0x3c')](_0x3d24c7[_0xf54e('0x39')],qs[_0xf54e('0x3d')](_0x554c1f[_0xf54e('0x3a')][_0xf54e('0x3d')]));_0xd4d956[_0xf54e('0x3e')]=_0xd4d956[_0xf54e('0x3e')][_0xf54e('0x3f')]?_0xd4d956[_0xf54e('0x3e')]:_0x3d24c7['model'];if(_0x554c1f['query'][_0xf54e('0x4c')]){_0xd4d956[_0xf54e('0x4d')]=[{'all':!![]}];}_0xd4d956=_[_0xf54e('0x48')]({},_0xd4d956,_0x554c1f[_0xf54e('0x4b')]);return db[_0xf54e('0x36')][_0xf54e('0x53')](_0xd4d956)[_0xf54e('0x31')](handleEntityNotFound(_0x22c842,null))[_0xf54e('0x31')](respondWithResult(_0x22c842,null))[_0xf54e('0x24')](handleError(_0x22c842,null));};exports[_0xf54e('0x54')]=function(_0x1df308,_0x59c313){return db[_0xf54e('0x36')][_0xf54e('0x54')](_0x1df308[_0xf54e('0x55')],{})[_0xf54e('0x31')](respondWithResult(_0x59c313,0xc9))[_0xf54e('0x24')](handleError(_0x59c313,null));};exports[_0xf54e('0x30')]=function(_0x18a25f,_0x58988a){if(_0x18a25f[_0xf54e('0x55')]['id']){delete _0x18a25f[_0xf54e('0x55')]['id'];}return db[_0xf54e('0x36')]['find']({'where':{'id':_0x18a25f[_0xf54e('0x51')]['id']}})['then'](handleEntityNotFound(_0x58988a,null))[_0xf54e('0x31')](saveUpdates(_0x18a25f[_0xf54e('0x55')],null))[_0xf54e('0x31')](respondWithResult(_0x58988a,null))['catch'](handleError(_0x58988a,null));};exports[_0xf54e('0x32')]=function(_0x30d10d,_0x2096e5){return db[_0xf54e('0x36')][_0xf54e('0x53')]({'where':{'id':_0x30d10d[_0xf54e('0x51')]['id']}})[_0xf54e('0x31')](handleEntityNotFound(_0x2096e5,null))['then'](removeEntity(_0x2096e5,null))['catch'](handleError(_0x2096e5,null));};exports[_0xf54e('0x56')]=function(_0x9ab4c4,_0x4f17dd,_0x29743e){var _0x49fd97={};var _0xf39552={};var _0x528a64;var _0x324167;return db[_0xf54e('0x36')][_0xf54e('0x57')]({'where':{'id':_0x9ab4c4[_0xf54e('0x51')]['id']}})[_0xf54e('0x31')](handleEntityNotFound(_0x4f17dd,null))[_0xf54e('0x31')](function(_0x556e55){if(_0x556e55){_0x528a64=_0x556e55;_0xf39552['model']=_[_0xf54e('0x3b')](db[_0xf54e('0x58')]['rawAttributes']);_0xf39552['query']=_[_0xf54e('0x3b')](_0x9ab4c4['query']);_0xf39552[_0xf54e('0x45')]=_[_0xf54e('0x3c')](_0xf39552[_0xf54e('0x39')],_0xf39552[_0xf54e('0x3a')]);_0x49fd97[_0xf54e('0x3e')]=_[_0xf54e('0x3c')](_0xf39552[_0xf54e('0x39')],qs[_0xf54e('0x3d')](_0x9ab4c4[_0xf54e('0x3a')][_0xf54e('0x3d')]));_0x49fd97[_0xf54e('0x3e')]=_0x49fd97[_0xf54e('0x3e')][_0xf54e('0x3f')]?_0x49fd97[_0xf54e('0x3e')]:_0xf39552['model'];_0x49fd97[_0xf54e('0x42')]=qs[_0xf54e('0x43')](_0x9ab4c4[_0xf54e('0x3a')][_0xf54e('0x43')]);_0x49fd97[_0xf54e('0x44')]=qs['filters'](_[_0xf54e('0x46')](_0x9ab4c4[_0xf54e('0x3a')],_0xf39552['filters']));if(_0x9ab4c4['query'][_0xf54e('0x47')]){_0x49fd97['where']=_[_0xf54e('0x48')](_0x49fd97[_0xf54e('0x44')],{'$or':_[_0xf54e('0x35')](_0x49fd97[_0xf54e('0x3e')],function(_0x47a84f){var _0x2ecda1={};_0x2ecda1[_0x47a84f]={'$like':'%'+_0x9ab4c4['query'][_0xf54e('0x47')]+'%'};return _0x2ecda1;})});}_0x49fd97=_[_0xf54e('0x48')]({},_0x49fd97,_0x9ab4c4[_0xf54e('0x4b')]);return _0x528a64['getFields'](_0x49fd97);}})[_0xf54e('0x31')](function(_0x504ec7){if(_0x504ec7){_0x324167=_0x504ec7[_0xf54e('0x3f')];if(!_0x9ab4c4[_0xf54e('0x3a')]['hasOwnProperty'](_0xf54e('0x41'))){_0x49fd97['limit']=qs[_0xf54e('0x2b')](_0x9ab4c4[_0xf54e('0x3a')][_0xf54e('0x2b')]);_0x49fd97[_0xf54e('0x2a')]=qs[_0xf54e('0x2a')](_0x9ab4c4['query'][_0xf54e('0x2a')]);}return _0x528a64[_0xf54e('0x56')](_0x49fd97);}})['then'](function(_0x2db742){if(_0x2db742){return _0x2db742?{'count':_0x324167,'rows':_0x2db742}:null;}})[_0xf54e('0x31')](respondWithResult(_0x4f17dd,null))['catch'](handleError(_0x4f17dd,null));};exports[_0xf54e('0x59')]=function(_0x14aaf7,_0x309895,_0x4c72ef){var _0xf4e4d={};var _0x4ae3d0={};var _0x8ed40a;var _0x314f36;return db['SalesforceConfiguration'][_0xf54e('0x57')]({'where':{'id':_0x14aaf7[_0xf54e('0x51')]['id']}})[_0xf54e('0x31')](handleEntityNotFound(_0x309895,null))[_0xf54e('0x31')](function(_0x38bf71){if(_0x38bf71){_0x8ed40a=_0x38bf71;_0x4ae3d0[_0xf54e('0x39')]=_[_0xf54e('0x3b')](db[_0xf54e('0x58')][_0xf54e('0x52')]);_0x4ae3d0[_0xf54e('0x3a')]=_[_0xf54e('0x3b')](_0x14aaf7['query']);_0x4ae3d0[_0xf54e('0x45')]=_[_0xf54e('0x3c')](_0x4ae3d0[_0xf54e('0x39')],_0x4ae3d0['query']);_0xf4e4d[_0xf54e('0x3e')]=_[_0xf54e('0x3c')](_0x4ae3d0[_0xf54e('0x39')],qs[_0xf54e('0x3d')](_0x14aaf7[_0xf54e('0x3a')][_0xf54e('0x3d')]));_0xf4e4d[_0xf54e('0x3e')]=_0xf4e4d['attributes'][_0xf54e('0x3f')]?_0xf4e4d[_0xf54e('0x3e')]:_0x4ae3d0[_0xf54e('0x39')];_0xf4e4d['order']=qs[_0xf54e('0x43')](_0x14aaf7[_0xf54e('0x3a')][_0xf54e('0x43')]);_0xf4e4d[_0xf54e('0x44')]=qs['filters'](_['pick'](_0x14aaf7[_0xf54e('0x3a')],_0x4ae3d0[_0xf54e('0x45')]));if(_0x14aaf7[_0xf54e('0x3a')][_0xf54e('0x47')]){_0xf4e4d[_0xf54e('0x44')]=_[_0xf54e('0x48')](_0xf4e4d[_0xf54e('0x44')],{'$or':_[_0xf54e('0x35')](_0xf4e4d[_0xf54e('0x3e')],function(_0x205b47){var _0x4e6f8f={};_0x4e6f8f[_0x205b47]={'$like':'%'+_0x14aaf7[_0xf54e('0x3a')][_0xf54e('0x47')]+'%'};return _0x4e6f8f;})});}_0xf4e4d=_[_0xf54e('0x48')]({},_0xf4e4d,_0x14aaf7[_0xf54e('0x4b')]);return _0x8ed40a['getSubjects'](_0xf4e4d);}})[_0xf54e('0x31')](function(_0x1de6dd){if(_0x1de6dd){_0x314f36=_0x1de6dd[_0xf54e('0x3f')];if(!_0x14aaf7[_0xf54e('0x3a')]['hasOwnProperty'](_0xf54e('0x41'))){_0xf4e4d[_0xf54e('0x2b')]=qs[_0xf54e('0x2b')](_0x14aaf7['query']['limit']);_0xf4e4d[_0xf54e('0x2a')]=qs[_0xf54e('0x2a')](_0x14aaf7[_0xf54e('0x3a')][_0xf54e('0x2a')]);}return _0x8ed40a[_0xf54e('0x59')](_0xf4e4d);}})[_0xf54e('0x31')](function(_0x2b42f5){if(_0x2b42f5){return _0x2b42f5?{'count':_0x314f36,'rows':_0x2b42f5}:null;}})[_0xf54e('0x31')](respondWithResult(_0x309895,null))[_0xf54e('0x24')](handleError(_0x309895,null));};exports['getDescriptions']=function(_0xa5de47,_0x3edfa0,_0x4ce10){var _0x37a61b={};var _0x395513={};var _0x310ca9;var _0x42c70b;return db[_0xf54e('0x36')][_0xf54e('0x57')]({'where':{'id':_0xa5de47[_0xf54e('0x51')]['id']}})[_0xf54e('0x31')](handleEntityNotFound(_0x3edfa0,null))[_0xf54e('0x31')](function(_0x5b9ff2){if(_0x5b9ff2){_0x310ca9=_0x5b9ff2;_0x395513[_0xf54e('0x39')]=_[_0xf54e('0x3b')](db['SalesforceField']['rawAttributes']);_0x395513[_0xf54e('0x3a')]=_[_0xf54e('0x3b')](_0xa5de47[_0xf54e('0x3a')]);_0x395513[_0xf54e('0x45')]=_[_0xf54e('0x3c')](_0x395513[_0xf54e('0x39')],_0x395513[_0xf54e('0x3a')]);_0x37a61b[_0xf54e('0x3e')]=_[_0xf54e('0x3c')](_0x395513['model'],qs[_0xf54e('0x3d')](_0xa5de47[_0xf54e('0x3a')][_0xf54e('0x3d')]));_0x37a61b['attributes']=_0x37a61b[_0xf54e('0x3e')]['length']?_0x37a61b[_0xf54e('0x3e')]:_0x395513['model'];_0x37a61b[_0xf54e('0x42')]=qs[_0xf54e('0x43')](_0xa5de47['query']['sort']);_0x37a61b[_0xf54e('0x44')]=qs[_0xf54e('0x45')](_[_0xf54e('0x46')](_0xa5de47[_0xf54e('0x3a')],_0x395513[_0xf54e('0x45')]));if(_0xa5de47['query']['filter']){_0x37a61b[_0xf54e('0x44')]=_[_0xf54e('0x48')](_0x37a61b[_0xf54e('0x44')],{'$or':_[_0xf54e('0x35')](_0x37a61b[_0xf54e('0x3e')],function(_0xe1205){var _0x7568bf={};_0x7568bf[_0xe1205]={'$like':'%'+_0xa5de47[_0xf54e('0x3a')][_0xf54e('0x47')]+'%'};return _0x7568bf;})});}_0x37a61b=_[_0xf54e('0x48')]({},_0x37a61b,_0xa5de47['options']);return _0x310ca9[_0xf54e('0x5a')](_0x37a61b);}})[_0xf54e('0x31')](function(_0x4d4667){if(_0x4d4667){_0x42c70b=_0x4d4667['length'];if(!_0xa5de47[_0xf54e('0x3a')][_0xf54e('0x40')](_0xf54e('0x41'))){_0x37a61b[_0xf54e('0x2b')]=qs[_0xf54e('0x2b')](_0xa5de47['query'][_0xf54e('0x2b')]);_0x37a61b[_0xf54e('0x2a')]=qs[_0xf54e('0x2a')](_0xa5de47[_0xf54e('0x3a')]['offset']);}return _0x310ca9[_0xf54e('0x5a')](_0x37a61b);}})[_0xf54e('0x31')](function(_0x16e1cb){if(_0x16e1cb){return _0x16e1cb?{'count':_0x42c70b,'rows':_0x16e1cb}:null;}})[_0xf54e('0x31')](respondWithResult(_0x3edfa0,null))['catch'](handleError(_0x3edfa0,null));};