Built motion from commit (unavailable).|2.5.31
[motion2.git] / 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 _0x397c=['SalesforceConfiguration','rawAttributes','fieldName','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filter','options','include','findAll','rows','show','includeAll','find','create','body','params','destroy','getFields','nolimit','SalesforceField','getSubjects','findOne','getDescriptions','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/license/util','jayson/promise','client','http','request','then','SalesforceConfiguration,\x20%s,\x20%s','request\x20sent','SalesforceConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','code','message','info','result','catch','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','stack','name','render','merge','contact','agent','interaction','map'];(function(_0x3b414e,_0x2be10c){var _0x1cb85b=function(_0x58c60b){while(--_0x58c60b){_0x3b414e['push'](_0x3b414e['shift']());}};_0x1cb85b(++_0x2be10c);}(_0x397c,0xdd));var _0xc397=function(_0xbf8ebe,_0x3b69a5){_0xbf8ebe=_0xbf8ebe-0x0;var _0x1e25e8=_0x397c[_0xbf8ebe];return _0x1e25e8;};'use strict';var emlformat=require(_0xc397('0x0'));var rimraf=require(_0xc397('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xc397('0x2'));var rp=require(_0xc397('0x3'));var moment=require(_0xc397('0x4'));var BPromise=require(_0xc397('0x5'));var Mustache=require(_0xc397('0x6'));var util=require(_0xc397('0x7'));var path=require('path');var sox=require(_0xc397('0x8'));var csv=require(_0xc397('0x9'));var ejs=require(_0xc397('0xa'));var fs=require('fs');var fs_extra=require(_0xc397('0xb'));var _=require(_0xc397('0xc'));var squel=require(_0xc397('0xd'));var crypto=require(_0xc397('0xe'));var jsforce=require(_0xc397('0xf'));var deskjs=require('desk.js');var toCsv=require(_0xc397('0x9'));var querystring=require('querystring');var Papa=require(_0xc397('0x10'));var Redis=require(_0xc397('0x11'));var authService=require('../../components/auth/service');var qs=require(_0xc397('0x12'));var as=require(_0xc397('0x13'));var hardwareService=require(_0xc397('0x14'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0xc397('0x15'));var db=require('../../mysqldb')['db'];var jayson=require(_0xc397('0x16'));var client=jayson[_0xc397('0x17')][_0xc397('0x18')]({'port':0x232a});function respondWithRpcPromise(_0x5bf2d7,_0x40030e,_0x1717da,_0x18c476){return new BPromise(function(_0xfeb031,_0x4d5c1a){var _0x38f4c2=_0x18c476||client;return _0x38f4c2[_0xc397('0x19')](_0x5bf2d7,_0x1717da)[_0xc397('0x1a')](function(_0x5098fb){logger['info'](_0xc397('0x1b'),_0x40030e,_0xc397('0x1c'));logger['debug'](_0xc397('0x1d'),_0x40030e,_0xc397('0x1c'),JSON[_0xc397('0x1e')](_0x5098fb));if(_0x5098fb[_0xc397('0x1f')]){if(_0x5098fb['error'][_0xc397('0x20')]===0x1f4){logger[_0xc397('0x1f')]('SalesforceConfiguration,\x20%s,\x20%s',_0x40030e,_0x5098fb[_0xc397('0x1f')][_0xc397('0x21')]);return _0x4d5c1a(_0x5098fb[_0xc397('0x1f')][_0xc397('0x21')]);}logger[_0xc397('0x1f')]('SalesforceConfiguration,\x20%s,\x20%s',_0x40030e,_0x5098fb[_0xc397('0x1f')]['message']);return _0xfeb031(_0x5098fb[_0xc397('0x1f')][_0xc397('0x21')]);}else{logger[_0xc397('0x22')]('SalesforceConfiguration,\x20%s,\x20%s',_0x40030e,_0xc397('0x1c'));_0xfeb031(_0x5098fb[_0xc397('0x23')][_0xc397('0x21')]);}})[_0xc397('0x24')](function(_0x53de49){logger[_0xc397('0x1f')](_0xc397('0x1b'),_0x40030e,_0x53de49);_0x4d5c1a(_0x53de49);});});}function respondWithStatusCode(_0x6852d3,_0x558967){_0x558967=_0x558967||0xcc;return function(_0x30711a){if(_0x30711a){return _0x6852d3[_0xc397('0x25')](_0x558967);}return _0x6852d3[_0xc397('0x26')](_0x558967)['end']();};}function respondWithResult(_0xff2d35,_0x275f60){_0x275f60=_0x275f60||0xc8;return function(_0x1f4f23){if(_0x1f4f23){return _0xff2d35[_0xc397('0x26')](_0x275f60)[_0xc397('0x27')](_0x1f4f23);}};}function respondWithFilteredResult(_0x312778,_0x200780){return function(_0x428ba5){if(_0x428ba5){var _0x4c3a5a=typeof _0x200780[_0xc397('0x28')]===_0xc397('0x29')&&typeof _0x200780[_0xc397('0x2a')]===_0xc397('0x29');var _0x415f9e=_0x428ba5[_0xc397('0x2b')];var _0x53e6da=_0x4c3a5a?0x0:_0x200780[_0xc397('0x28')];var _0x73cd74=_0x4c3a5a?_0x428ba5[_0xc397('0x2b')]:_0x200780[_0xc397('0x28')]+_0x200780[_0xc397('0x2a')];var _0x58855f;if(_0x73cd74>=_0x415f9e){_0x73cd74=_0x415f9e;_0x58855f=0xc8;}else{_0x58855f=0xce;}_0x312778[_0xc397('0x26')](_0x58855f);return _0x312778[_0xc397('0x2c')](_0xc397('0x2d'),_0x53e6da+'-'+_0x73cd74+'/'+_0x415f9e)[_0xc397('0x27')](_0x428ba5);}return null;};}function patchUpdates(_0x151106){return function(_0x23d304){try{jsonpatch[_0xc397('0x2e')](_0x23d304,_0x151106,!![]);}catch(_0x231a90){return BPromise[_0xc397('0x2f')](_0x231a90);}return _0x23d304[_0xc397('0x30')]();};}function saveUpdates(_0x467f12,_0x185ab3){return function(_0x32741e){if(_0x32741e){return _0x32741e[_0xc397('0x31')](_0x467f12)[_0xc397('0x1a')](function(_0x2213ef){return _0x2213ef;});}return null;};}function removeEntity(_0x253a0c,_0x30b0e0){return function(_0x268f75){if(_0x268f75){return _0x268f75['destroy']()['then'](function(){_0x253a0c['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x4fdad5,_0x3debe3){return function(_0x54dd79){if(!_0x54dd79){_0x4fdad5[_0xc397('0x25')](0x194);}return _0x54dd79;};}function handleError(_0x4b07a7,_0x3880b9){_0x3880b9=_0x3880b9||0x1f4;return function(_0x659eee){logger['error'](_0x659eee[_0xc397('0x32')]);if(_0x659eee['name']){delete _0x659eee[_0xc397('0x33')];}_0x4b07a7[_0xc397('0x26')](_0x3880b9)['send'](_0x659eee);};}function getMustacheRender(_0x4a649b,_0x471d5c){return Mustache[_0xc397('0x34')](_0x4a649b,_[_0xc397('0x35')](_0x471d5c['body'],{'contact':_0x471d5c[_0xc397('0x36')],'message':_0x471d5c[_0xc397('0x21')],'agent':_0x471d5c[_0xc397('0x37')],'interaction':_0x471d5c[_0xc397('0x38')],'account':_0x471d5c['account']}))||'';}exports['index']=function(_0x57d2f7,_0x2bb9af){var _0x1e9ee4={},_0x2c7b5c={},_0x435d9a={'count':0x0,'rows':[]};var _0x2b8b03=_[_0xc397('0x39')](db[_0xc397('0x3a')][_0xc397('0x3b')],function(_0x155711){return{'name':_0x155711[_0xc397('0x3c')],'type':_0x155711[_0xc397('0x3d')]['key']};});_0x2c7b5c[_0xc397('0x3e')]=_[_0xc397('0x39')](_0x2b8b03,'name');_0x2c7b5c[_0xc397('0x3f')]=_[_0xc397('0x40')](_0x57d2f7[_0xc397('0x3f')]);_0x2c7b5c[_0xc397('0x41')]=_[_0xc397('0x42')](_0x2c7b5c[_0xc397('0x3e')],_0x2c7b5c[_0xc397('0x3f')]);_0x1e9ee4[_0xc397('0x43')]=_[_0xc397('0x42')](_0x2c7b5c[_0xc397('0x3e')],qs[_0xc397('0x44')](_0x57d2f7[_0xc397('0x3f')][_0xc397('0x44')]));_0x1e9ee4['attributes']=_0x1e9ee4[_0xc397('0x43')][_0xc397('0x45')]?_0x1e9ee4[_0xc397('0x43')]:_0x2c7b5c[_0xc397('0x3e')];if(!_0x57d2f7[_0xc397('0x3f')][_0xc397('0x46')]('nolimit')){_0x1e9ee4[_0xc397('0x2a')]=qs[_0xc397('0x2a')](_0x57d2f7[_0xc397('0x3f')][_0xc397('0x2a')]);_0x1e9ee4[_0xc397('0x28')]=qs[_0xc397('0x28')](_0x57d2f7[_0xc397('0x3f')][_0xc397('0x28')]);}_0x1e9ee4[_0xc397('0x47')]=qs[_0xc397('0x48')](_0x57d2f7['query'][_0xc397('0x48')]);_0x1e9ee4[_0xc397('0x49')]=qs[_0xc397('0x41')](_[_0xc397('0x4a')](_0x57d2f7['query'],_0x2c7b5c['filters']),_0x2b8b03);if(_0x57d2f7['query'][_0xc397('0x4b')]){_0x1e9ee4[_0xc397('0x49')]=_[_0xc397('0x35')](_0x1e9ee4[_0xc397('0x49')],{'$or':_[_0xc397('0x39')](_0x2b8b03,function(_0x6583b3){if(_0x6583b3['type']!=='VIRTUAL'){var _0x24fa46={};_0x24fa46[_0x6583b3[_0xc397('0x33')]]={'$like':'%'+_0x57d2f7[_0xc397('0x3f')][_0xc397('0x4b')]+'%'};return _0x24fa46;}})});}_0x1e9ee4=_['merge']({},_0x1e9ee4,_0x57d2f7[_0xc397('0x4c')]);var _0xeebd1a={'where':_0x1e9ee4[_0xc397('0x49')]};return db['SalesforceConfiguration'][_0xc397('0x2b')](_0xeebd1a)[_0xc397('0x1a')](function(_0x4f3f66){_0x435d9a[_0xc397('0x2b')]=_0x4f3f66;if(_0x57d2f7[_0xc397('0x3f')]['includeAll']){_0x1e9ee4[_0xc397('0x4d')]=[{'all':!![]}];}return db[_0xc397('0x3a')][_0xc397('0x4e')](_0x1e9ee4);})[_0xc397('0x1a')](function(_0x39476c){_0x435d9a[_0xc397('0x4f')]=_0x39476c;return _0x435d9a;})['then'](respondWithFilteredResult(_0x2bb9af,_0x1e9ee4))[_0xc397('0x24')](handleError(_0x2bb9af,null));};exports[_0xc397('0x50')]=function(_0x33c077,_0x114242){var _0x3fd7d9={'raw':![],'where':{'id':_0x33c077['params']['id']}},_0x2c4556={};_0x2c4556[_0xc397('0x3e')]=_[_0xc397('0x40')](db[_0xc397('0x3a')]['rawAttributes']);_0x2c4556[_0xc397('0x3f')]=_[_0xc397('0x40')](_0x33c077[_0xc397('0x3f')]);_0x2c4556[_0xc397('0x41')]=_[_0xc397('0x42')](_0x2c4556['model'],_0x2c4556[_0xc397('0x3f')]);_0x3fd7d9[_0xc397('0x43')]=_[_0xc397('0x42')](_0x2c4556[_0xc397('0x3e')],qs[_0xc397('0x44')](_0x33c077[_0xc397('0x3f')]['fields']));_0x3fd7d9[_0xc397('0x43')]=_0x3fd7d9[_0xc397('0x43')][_0xc397('0x45')]?_0x3fd7d9[_0xc397('0x43')]:_0x2c4556['model'];if(_0x33c077[_0xc397('0x3f')][_0xc397('0x51')]){_0x3fd7d9[_0xc397('0x4d')]=[{'all':!![]}];}_0x3fd7d9=_[_0xc397('0x35')]({},_0x3fd7d9,_0x33c077[_0xc397('0x4c')]);return db[_0xc397('0x3a')][_0xc397('0x52')](_0x3fd7d9)[_0xc397('0x1a')](handleEntityNotFound(_0x114242,null))['then'](respondWithResult(_0x114242,null))[_0xc397('0x24')](handleError(_0x114242,null));};exports[_0xc397('0x53')]=function(_0x19ff46,_0x463d80){return db['SalesforceConfiguration'][_0xc397('0x53')](_0x19ff46['body'],{})[_0xc397('0x1a')](respondWithResult(_0x463d80,0xc9))[_0xc397('0x24')](handleError(_0x463d80,null));};exports[_0xc397('0x31')]=function(_0x548211,_0x416b41){if(_0x548211['body']['id']){delete _0x548211[_0xc397('0x54')]['id'];}return db['SalesforceConfiguration']['find']({'where':{'id':_0x548211[_0xc397('0x55')]['id']}})[_0xc397('0x1a')](handleEntityNotFound(_0x416b41,null))['then'](saveUpdates(_0x548211[_0xc397('0x54')],null))[_0xc397('0x1a')](respondWithResult(_0x416b41,null))['catch'](handleError(_0x416b41,null));};exports[_0xc397('0x56')]=function(_0xd039a0,_0x24072b){return db[_0xc397('0x3a')][_0xc397('0x52')]({'where':{'id':_0xd039a0[_0xc397('0x55')]['id']}})[_0xc397('0x1a')](handleEntityNotFound(_0x24072b,null))[_0xc397('0x1a')](removeEntity(_0x24072b,null))[_0xc397('0x24')](handleError(_0x24072b,null));};exports[_0xc397('0x57')]=function(_0x18e6e4,_0x214b83,_0x14521f){var _0x1dbb26={};var _0x3c78e8={};var _0xe0618;var _0x526fa1;return db['SalesforceConfiguration']['findOne']({'where':{'id':_0x18e6e4[_0xc397('0x55')]['id']}})['then'](handleEntityNotFound(_0x214b83,null))[_0xc397('0x1a')](function(_0x55b1fc){if(_0x55b1fc){_0xe0618=_0x55b1fc;_0x3c78e8[_0xc397('0x3e')]=_['keys'](db['SalesforceField'][_0xc397('0x3b')]);_0x3c78e8[_0xc397('0x3f')]=_[_0xc397('0x40')](_0x18e6e4[_0xc397('0x3f')]);_0x3c78e8[_0xc397('0x41')]=_['intersection'](_0x3c78e8['model'],_0x3c78e8[_0xc397('0x3f')]);_0x1dbb26['attributes']=_['intersection'](_0x3c78e8[_0xc397('0x3e')],qs[_0xc397('0x44')](_0x18e6e4['query'][_0xc397('0x44')]));_0x1dbb26[_0xc397('0x43')]=_0x1dbb26['attributes'][_0xc397('0x45')]?_0x1dbb26[_0xc397('0x43')]:_0x3c78e8[_0xc397('0x3e')];_0x1dbb26[_0xc397('0x47')]=qs[_0xc397('0x48')](_0x18e6e4[_0xc397('0x3f')][_0xc397('0x48')]);_0x1dbb26[_0xc397('0x49')]=qs[_0xc397('0x41')](_[_0xc397('0x4a')](_0x18e6e4[_0xc397('0x3f')],_0x3c78e8['filters']));if(_0x18e6e4[_0xc397('0x3f')]['filter']){_0x1dbb26[_0xc397('0x49')]=_[_0xc397('0x35')](_0x1dbb26[_0xc397('0x49')],{'$or':_['map'](_0x1dbb26[_0xc397('0x43')],function(_0x4d7933){var _0x441683={};_0x441683[_0x4d7933]={'$like':'%'+_0x18e6e4['query'][_0xc397('0x4b')]+'%'};return _0x441683;})});}_0x1dbb26=_[_0xc397('0x35')]({},_0x1dbb26,_0x18e6e4[_0xc397('0x4c')]);return _0xe0618[_0xc397('0x57')](_0x1dbb26);}})['then'](function(_0x40c847){if(_0x40c847){_0x526fa1=_0x40c847[_0xc397('0x45')];if(!_0x18e6e4[_0xc397('0x3f')][_0xc397('0x46')](_0xc397('0x58'))){_0x1dbb26['limit']=qs[_0xc397('0x2a')](_0x18e6e4[_0xc397('0x3f')]['limit']);_0x1dbb26[_0xc397('0x28')]=qs[_0xc397('0x28')](_0x18e6e4[_0xc397('0x3f')][_0xc397('0x28')]);}return _0xe0618[_0xc397('0x57')](_0x1dbb26);}})[_0xc397('0x1a')](function(_0x4ff1aa){if(_0x4ff1aa){return _0x4ff1aa?{'count':_0x526fa1,'rows':_0x4ff1aa}:null;}})[_0xc397('0x1a')](respondWithResult(_0x214b83,null))[_0xc397('0x24')](handleError(_0x214b83,null));};exports['getSubjects']=function(_0x462455,_0x2b8684,_0x4f443c){var _0x550595={};var _0x371371={};var _0x1b7b68;var _0x4fb1bf;return db[_0xc397('0x3a')]['findOne']({'where':{'id':_0x462455[_0xc397('0x55')]['id']}})[_0xc397('0x1a')](handleEntityNotFound(_0x2b8684,null))[_0xc397('0x1a')](function(_0x46a5f5){if(_0x46a5f5){_0x1b7b68=_0x46a5f5;_0x371371[_0xc397('0x3e')]=_[_0xc397('0x40')](db[_0xc397('0x59')][_0xc397('0x3b')]);_0x371371[_0xc397('0x3f')]=_[_0xc397('0x40')](_0x462455['query']);_0x371371[_0xc397('0x41')]=_[_0xc397('0x42')](_0x371371[_0xc397('0x3e')],_0x371371[_0xc397('0x3f')]);_0x550595[_0xc397('0x43')]=_[_0xc397('0x42')](_0x371371[_0xc397('0x3e')],qs[_0xc397('0x44')](_0x462455[_0xc397('0x3f')][_0xc397('0x44')]));_0x550595[_0xc397('0x43')]=_0x550595[_0xc397('0x43')][_0xc397('0x45')]?_0x550595[_0xc397('0x43')]:_0x371371['model'];_0x550595[_0xc397('0x47')]=qs[_0xc397('0x48')](_0x462455[_0xc397('0x3f')][_0xc397('0x48')]);_0x550595['where']=qs[_0xc397('0x41')](_['pick'](_0x462455[_0xc397('0x3f')],_0x371371[_0xc397('0x41')]));if(_0x462455[_0xc397('0x3f')]['filter']){_0x550595[_0xc397('0x49')]=_['merge'](_0x550595[_0xc397('0x49')],{'$or':_['map'](_0x550595[_0xc397('0x43')],function(_0x403ab5){var _0x5ab017={};_0x5ab017[_0x403ab5]={'$like':'%'+_0x462455['query'][_0xc397('0x4b')]+'%'};return _0x5ab017;})});}_0x550595=_[_0xc397('0x35')]({},_0x550595,_0x462455[_0xc397('0x4c')]);return _0x1b7b68[_0xc397('0x5a')](_0x550595);}})['then'](function(_0x164bc5){if(_0x164bc5){_0x4fb1bf=_0x164bc5[_0xc397('0x45')];if(!_0x462455[_0xc397('0x3f')][_0xc397('0x46')](_0xc397('0x58'))){_0x550595[_0xc397('0x2a')]=qs['limit'](_0x462455[_0xc397('0x3f')][_0xc397('0x2a')]);_0x550595['offset']=qs['offset'](_0x462455[_0xc397('0x3f')][_0xc397('0x28')]);}return _0x1b7b68[_0xc397('0x5a')](_0x550595);}})[_0xc397('0x1a')](function(_0x30d4ef){if(_0x30d4ef){return _0x30d4ef?{'count':_0x4fb1bf,'rows':_0x30d4ef}:null;}})[_0xc397('0x1a')](respondWithResult(_0x2b8684,null))[_0xc397('0x24')](handleError(_0x2b8684,null));};exports['getDescriptions']=function(_0xef1c1f,_0x27af59,_0x5ca7b9){var _0x16c410={};var _0x48bdc5={};var _0x2d7752;var _0x9b05ba;return db['SalesforceConfiguration'][_0xc397('0x5b')]({'where':{'id':_0xef1c1f['params']['id']}})[_0xc397('0x1a')](handleEntityNotFound(_0x27af59,null))[_0xc397('0x1a')](function(_0x489082){if(_0x489082){_0x2d7752=_0x489082;_0x48bdc5[_0xc397('0x3e')]=_[_0xc397('0x40')](db[_0xc397('0x59')][_0xc397('0x3b')]);_0x48bdc5[_0xc397('0x3f')]=_[_0xc397('0x40')](_0xef1c1f[_0xc397('0x3f')]);_0x48bdc5[_0xc397('0x41')]=_[_0xc397('0x42')](_0x48bdc5[_0xc397('0x3e')],_0x48bdc5[_0xc397('0x3f')]);_0x16c410['attributes']=_[_0xc397('0x42')](_0x48bdc5[_0xc397('0x3e')],qs['fields'](_0xef1c1f[_0xc397('0x3f')]['fields']));_0x16c410[_0xc397('0x43')]=_0x16c410[_0xc397('0x43')][_0xc397('0x45')]?_0x16c410[_0xc397('0x43')]:_0x48bdc5[_0xc397('0x3e')];_0x16c410[_0xc397('0x47')]=qs[_0xc397('0x48')](_0xef1c1f['query'][_0xc397('0x48')]);_0x16c410[_0xc397('0x49')]=qs[_0xc397('0x41')](_[_0xc397('0x4a')](_0xef1c1f[_0xc397('0x3f')],_0x48bdc5[_0xc397('0x41')]));if(_0xef1c1f[_0xc397('0x3f')][_0xc397('0x4b')]){_0x16c410[_0xc397('0x49')]=_[_0xc397('0x35')](_0x16c410[_0xc397('0x49')],{'$or':_[_0xc397('0x39')](_0x16c410[_0xc397('0x43')],function(_0x2c5eca){var _0x51231a={};_0x51231a[_0x2c5eca]={'$like':'%'+_0xef1c1f[_0xc397('0x3f')][_0xc397('0x4b')]+'%'};return _0x51231a;})});}_0x16c410=_[_0xc397('0x35')]({},_0x16c410,_0xef1c1f[_0xc397('0x4c')]);return _0x2d7752[_0xc397('0x5c')](_0x16c410);}})['then'](function(_0x52431d){if(_0x52431d){_0x9b05ba=_0x52431d[_0xc397('0x45')];if(!_0xef1c1f[_0xc397('0x3f')]['hasOwnProperty'](_0xc397('0x58'))){_0x16c410[_0xc397('0x2a')]=qs[_0xc397('0x2a')](_0xef1c1f['query'][_0xc397('0x2a')]);_0x16c410[_0xc397('0x28')]=qs['offset'](_0xef1c1f['query']['offset']);}return _0x2d7752['getDescriptions'](_0x16c410);}})[_0xc397('0x1a')](function(_0x14003e){if(_0x14003e){return _0x14003e?{'count':_0x9b05ba,'rows':_0x14003e}:null;}})[_0xc397('0x1a')](respondWithResult(_0x27af59,null))[_0xc397('0x24')](handleError(_0x27af59,null));};