[motion2.git] / server / api / intSalesforceConfiguration / intSalesforceConfiguration.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x0f63=['set','Content-Range','json','apply','reject','save','update','destroy','stack','name','send','render','merge','contact','agent','interaction','map','SalesforceConfiguration','rawAttributes','type','key','model','query','keys','filters','attributes','intersection','fields','length','nolimit','order','sort','where','pick','filter','VIRTUAL','options','include','findAll','rows','params','find','catch','create','body','getFields','findOne','hasOwnProperty','getSubjects','SalesforceField','getDescriptions','eml-format','fast-json-patch','request-promise','moment','util','path','to-csv','fs-extra','lodash','squel','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','jayson/promise','client','http','request','then','info','SalesforceConfiguration,\x20%s,\x20%s','request\x20sent','debug','SalesforceConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','code','message','result','sendStatus','status','end','offset','undefined','limit','count'];(function(_0x38ce4c,_0xfdbe8c){var _0x5d4544=function(_0x503537){while(--_0x503537){_0x38ce4c['push'](_0x38ce4c['shift']());}};_0x5d4544(++_0xfdbe8c);}(_0x0f63,0x1ab));var _0x30f6=function(_0x5370dc,_0x186839){_0x5370dc=_0x5370dc-0x0;var _0x338918=_0x0f63[_0x5370dc];return _0x338918;};'use strict';var emlformat=require(_0x30f6('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x30f6('0x1'));var rp=require(_0x30f6('0x2'));var moment=require(_0x30f6('0x3'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x30f6('0x4'));var path=require(_0x30f6('0x5'));var sox=require('sox');var csv=require(_0x30f6('0x6'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x30f6('0x7'));var _=require(_0x30f6('0x8'));var squel=require(_0x30f6('0x9'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x30f6('0xa'));var toCsv=require(_0x30f6('0x6'));var querystring=require(_0x30f6('0xb'));var Papa=require(_0x30f6('0xc'));var Redis=require(_0x30f6('0xd'));var authService=require(_0x30f6('0xe'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x30f6('0xf'))(_0x30f6('0x10'));var utils=require(_0x30f6('0x11'));var config=require(_0x30f6('0x12'));var licenseUtil=require(_0x30f6('0x13'));var db=require(_0x30f6('0x14'))['db'];var jayson=require(_0x30f6('0x15'));var client=jayson[_0x30f6('0x16')][_0x30f6('0x17')]({'port':0x232a});function respondWithRpcPromise(_0x203b3c,_0x203147,_0x28b447,_0x3c2c20){return new BPromise(function(_0x275987,_0x384de8){var _0x2eab50=_0x3c2c20||client;return _0x2eab50[_0x30f6('0x18')](_0x203b3c,_0x28b447)[_0x30f6('0x19')](function(_0x11dcca){logger[_0x30f6('0x1a')](_0x30f6('0x1b'),_0x203147,_0x30f6('0x1c'));logger[_0x30f6('0x1d')](_0x30f6('0x1e'),_0x203147,'request\x20sent',JSON[_0x30f6('0x1f')](_0x11dcca));if(_0x11dcca[_0x30f6('0x20')]){if(_0x11dcca[_0x30f6('0x20')][_0x30f6('0x21')]===0x1f4){logger[_0x30f6('0x20')](_0x30f6('0x1b'),_0x203147,_0x11dcca[_0x30f6('0x20')][_0x30f6('0x22')]);return _0x384de8(_0x11dcca[_0x30f6('0x20')][_0x30f6('0x22')]);}logger[_0x30f6('0x20')]('SalesforceConfiguration,\x20%s,\x20%s',_0x203147,_0x11dcca[_0x30f6('0x20')][_0x30f6('0x22')]);return _0x275987(_0x11dcca[_0x30f6('0x20')][_0x30f6('0x22')]);}else{logger[_0x30f6('0x1a')](_0x30f6('0x1b'),_0x203147,'request\x20sent');_0x275987(_0x11dcca[_0x30f6('0x23')][_0x30f6('0x22')]);}})['catch'](function(_0x546447){logger[_0x30f6('0x20')](_0x30f6('0x1b'),_0x203147,_0x546447);_0x384de8(_0x546447);});});}function respondWithStatusCode(_0x3a6a06,_0x234298){_0x234298=_0x234298||0xcc;return function(_0x604888){if(_0x604888){return _0x3a6a06[_0x30f6('0x24')](_0x234298);}return _0x3a6a06[_0x30f6('0x25')](_0x234298)[_0x30f6('0x26')]();};}function respondWithResult(_0x4a8ec7,_0x771660){_0x771660=_0x771660||0xc8;return function(_0x2d2217){if(_0x2d2217){return _0x4a8ec7['status'](_0x771660)['json'](_0x2d2217);}};}function respondWithFilteredResult(_0x1c894b,_0x647271){return function(_0x1a2db1){if(_0x1a2db1){var _0x1a8a26=typeof _0x647271[_0x30f6('0x27')]===_0x30f6('0x28')&&typeof _0x647271[_0x30f6('0x29')]==='undefined';var _0x453acb=_0x1a2db1[_0x30f6('0x2a')];var _0xb8cea7=_0x1a8a26?0x0:_0x647271['offset'];var _0x197286=_0x1a8a26?_0x1a2db1[_0x30f6('0x2a')]:_0x647271['offset']+_0x647271[_0x30f6('0x29')];var _0x27a08f;if(_0x197286>=_0x453acb){_0x197286=_0x453acb;_0x27a08f=0xc8;}else{_0x27a08f=0xce;}_0x1c894b[_0x30f6('0x25')](_0x27a08f);return _0x1c894b[_0x30f6('0x2b')](_0x30f6('0x2c'),_0xb8cea7+'-'+_0x197286+'/'+_0x453acb)[_0x30f6('0x2d')](_0x1a2db1);}return null;};}function patchUpdates(_0x37cade){return function(_0x1bf2ca){try{jsonpatch[_0x30f6('0x2e')](_0x1bf2ca,_0x37cade,!![]);}catch(_0x5cde23){return BPromise[_0x30f6('0x2f')](_0x5cde23);}return _0x1bf2ca[_0x30f6('0x30')]();};}function saveUpdates(_0x2e862e,_0x3d0697){return function(_0x167588){if(_0x167588){return _0x167588[_0x30f6('0x31')](_0x2e862e)[_0x30f6('0x19')](function(_0x1e5b41){return _0x1e5b41;});}return null;};}function removeEntity(_0x54973a,_0x43a508){return function(_0xf5b37){if(_0xf5b37){return _0xf5b37[_0x30f6('0x32')]()[_0x30f6('0x19')](function(){_0x54973a[_0x30f6('0x25')](0xcc)[_0x30f6('0x26')]();});}};}function handleEntityNotFound(_0x52c871,_0x2fd1bd){return function(_0x1f47e8){if(!_0x1f47e8){_0x52c871[_0x30f6('0x24')](0x194);}return _0x1f47e8;};}function handleError(_0x33857f,_0x29b9b2){_0x29b9b2=_0x29b9b2||0x1f4;return function(_0x396f0d){logger[_0x30f6('0x20')](_0x396f0d[_0x30f6('0x33')]);if(_0x396f0d['name']){delete _0x396f0d[_0x30f6('0x34')];}_0x33857f[_0x30f6('0x25')](_0x29b9b2)[_0x30f6('0x35')](_0x396f0d);};}function getMustacheRender(_0x575055,_0x535b24){return Mustache[_0x30f6('0x36')](_0x575055,_[_0x30f6('0x37')](_0x535b24['body'],{'contact':_0x535b24[_0x30f6('0x38')],'message':_0x535b24[_0x30f6('0x22')],'agent':_0x535b24[_0x30f6('0x39')],'interaction':_0x535b24[_0x30f6('0x3a')],'account':_0x535b24['account']}))||'';}exports['index']=function(_0x176b9d,_0x226dd2){var _0x13c99b={},_0x1a4aaa={},_0xc48f4a={'count':0x0,'rows':[]};var _0x1c1b6c=_[_0x30f6('0x3b')](db[_0x30f6('0x3c')][_0x30f6('0x3d')],function(_0x26a384){return{'name':_0x26a384['fieldName'],'type':_0x26a384[_0x30f6('0x3e')][_0x30f6('0x3f')]};});_0x1a4aaa[_0x30f6('0x40')]=_[_0x30f6('0x3b')](_0x1c1b6c,_0x30f6('0x34'));_0x1a4aaa[_0x30f6('0x41')]=_[_0x30f6('0x42')](_0x176b9d[_0x30f6('0x41')]);_0x1a4aaa[_0x30f6('0x43')]=_['intersection'](_0x1a4aaa[_0x30f6('0x40')],_0x1a4aaa[_0x30f6('0x41')]);_0x13c99b[_0x30f6('0x44')]=_[_0x30f6('0x45')](_0x1a4aaa[_0x30f6('0x40')],qs[_0x30f6('0x46')](_0x176b9d[_0x30f6('0x41')][_0x30f6('0x46')]));_0x13c99b[_0x30f6('0x44')]=_0x13c99b[_0x30f6('0x44')][_0x30f6('0x47')]?_0x13c99b['attributes']:_0x1a4aaa[_0x30f6('0x40')];if(!_0x176b9d[_0x30f6('0x41')]['hasOwnProperty'](_0x30f6('0x48'))){_0x13c99b[_0x30f6('0x29')]=qs['limit'](_0x176b9d[_0x30f6('0x41')][_0x30f6('0x29')]);_0x13c99b[_0x30f6('0x27')]=qs[_0x30f6('0x27')](_0x176b9d['query']['offset']);}_0x13c99b[_0x30f6('0x49')]=qs[_0x30f6('0x4a')](_0x176b9d[_0x30f6('0x41')][_0x30f6('0x4a')]);_0x13c99b[_0x30f6('0x4b')]=qs['filters'](_[_0x30f6('0x4c')](_0x176b9d[_0x30f6('0x41')],_0x1a4aaa[_0x30f6('0x43')]),_0x1c1b6c);if(_0x176b9d['query'][_0x30f6('0x4d')]){_0x13c99b[_0x30f6('0x4b')]=_[_0x30f6('0x37')](_0x13c99b[_0x30f6('0x4b')],{'$or':_[_0x30f6('0x3b')](_0x1c1b6c,function(_0x1d014c){if(_0x1d014c[_0x30f6('0x3e')]!==_0x30f6('0x4e')){var _0x14a6aa={};_0x14a6aa[_0x1d014c[_0x30f6('0x34')]]={'$like':'%'+_0x176b9d[_0x30f6('0x41')]['filter']+'%'};return _0x14a6aa;}})});}_0x13c99b=_[_0x30f6('0x37')]({},_0x13c99b,_0x176b9d[_0x30f6('0x4f')]);var _0x204638={'where':_0x13c99b['where']};return db[_0x30f6('0x3c')][_0x30f6('0x2a')](_0x204638)[_0x30f6('0x19')](function(_0x4cec46){_0xc48f4a[_0x30f6('0x2a')]=_0x4cec46;if(_0x176b9d[_0x30f6('0x41')]['includeAll']){_0x13c99b[_0x30f6('0x50')]=[{'all':!![]}];}return db[_0x30f6('0x3c')][_0x30f6('0x51')](_0x13c99b);})['then'](function(_0x477324){_0xc48f4a[_0x30f6('0x52')]=_0x477324;return _0xc48f4a;})['then'](respondWithFilteredResult(_0x226dd2,_0x13c99b))['catch'](handleError(_0x226dd2,null));};exports['show']=function(_0xcda4a9,_0x103b19){var _0x5c40c3={'raw':![],'where':{'id':_0xcda4a9[_0x30f6('0x53')]['id']}},_0x2724dd={};_0x2724dd[_0x30f6('0x40')]=_['keys'](db['SalesforceConfiguration'][_0x30f6('0x3d')]);_0x2724dd['query']=_[_0x30f6('0x42')](_0xcda4a9[_0x30f6('0x41')]);_0x2724dd[_0x30f6('0x43')]=_[_0x30f6('0x45')](_0x2724dd[_0x30f6('0x40')],_0x2724dd['query']);_0x5c40c3['attributes']=_[_0x30f6('0x45')](_0x2724dd[_0x30f6('0x40')],qs['fields'](_0xcda4a9[_0x30f6('0x41')][_0x30f6('0x46')]));_0x5c40c3[_0x30f6('0x44')]=_0x5c40c3[_0x30f6('0x44')][_0x30f6('0x47')]?_0x5c40c3['attributes']:_0x2724dd[_0x30f6('0x40')];if(_0xcda4a9[_0x30f6('0x41')]['includeAll']){_0x5c40c3[_0x30f6('0x50')]=[{'all':!![]}];}_0x5c40c3=_['merge']({},_0x5c40c3,_0xcda4a9[_0x30f6('0x4f')]);return db[_0x30f6('0x3c')][_0x30f6('0x54')](_0x5c40c3)[_0x30f6('0x19')](handleEntityNotFound(_0x103b19,null))[_0x30f6('0x19')](respondWithResult(_0x103b19,null))[_0x30f6('0x55')](handleError(_0x103b19,null));};exports[_0x30f6('0x56')]=function(_0x579fd3,_0x20e1a1){return db[_0x30f6('0x3c')][_0x30f6('0x56')](_0x579fd3[_0x30f6('0x57')],{})[_0x30f6('0x19')](respondWithResult(_0x20e1a1,0xc9))[_0x30f6('0x55')](handleError(_0x20e1a1,null));};exports[_0x30f6('0x31')]=function(_0x2179f6,_0x4dba58){if(_0x2179f6[_0x30f6('0x57')]['id']){delete _0x2179f6[_0x30f6('0x57')]['id'];}return db[_0x30f6('0x3c')][_0x30f6('0x54')]({'where':{'id':_0x2179f6[_0x30f6('0x53')]['id']}})[_0x30f6('0x19')](handleEntityNotFound(_0x4dba58,null))[_0x30f6('0x19')](saveUpdates(_0x2179f6['body'],null))[_0x30f6('0x19')](respondWithResult(_0x4dba58,null))[_0x30f6('0x55')](handleError(_0x4dba58,null));};exports[_0x30f6('0x32')]=function(_0x348700,_0xa4c87a){return db['SalesforceConfiguration'][_0x30f6('0x54')]({'where':{'id':_0x348700['params']['id']}})[_0x30f6('0x19')](handleEntityNotFound(_0xa4c87a,null))[_0x30f6('0x19')](removeEntity(_0xa4c87a,null))['catch'](handleError(_0xa4c87a,null));};exports[_0x30f6('0x58')]=function(_0x4b6b0a,_0x3715c5,_0x4c53a7){var _0x58ccdd={};var _0x55c409={};var _0x45e2fb;var _0x580959;return db[_0x30f6('0x3c')][_0x30f6('0x59')]({'where':{'id':_0x4b6b0a[_0x30f6('0x53')]['id']}})['then'](handleEntityNotFound(_0x3715c5,null))[_0x30f6('0x19')](function(_0x508749){if(_0x508749){_0x45e2fb=_0x508749;_0x55c409[_0x30f6('0x40')]=_[_0x30f6('0x42')](db['SalesforceField'][_0x30f6('0x3d')]);_0x55c409['query']=_[_0x30f6('0x42')](_0x4b6b0a[_0x30f6('0x41')]);_0x55c409[_0x30f6('0x43')]=_[_0x30f6('0x45')](_0x55c409[_0x30f6('0x40')],_0x55c409[_0x30f6('0x41')]);_0x58ccdd[_0x30f6('0x44')]=_['intersection'](_0x55c409['model'],qs[_0x30f6('0x46')](_0x4b6b0a['query']['fields']));_0x58ccdd[_0x30f6('0x44')]=_0x58ccdd[_0x30f6('0x44')][_0x30f6('0x47')]?_0x58ccdd[_0x30f6('0x44')]:_0x55c409['model'];_0x58ccdd[_0x30f6('0x49')]=qs[_0x30f6('0x4a')](_0x4b6b0a[_0x30f6('0x41')][_0x30f6('0x4a')]);_0x58ccdd[_0x30f6('0x4b')]=qs[_0x30f6('0x43')](_[_0x30f6('0x4c')](_0x4b6b0a[_0x30f6('0x41')],_0x55c409['filters']));if(_0x4b6b0a[_0x30f6('0x41')][_0x30f6('0x4d')]){_0x58ccdd[_0x30f6('0x4b')]=_[_0x30f6('0x37')](_0x58ccdd[_0x30f6('0x4b')],{'$or':_[_0x30f6('0x3b')](_0x58ccdd[_0x30f6('0x44')],function(_0x276f6c){var _0x2d71a7={};_0x2d71a7[_0x276f6c]={'$like':'%'+_0x4b6b0a[_0x30f6('0x41')][_0x30f6('0x4d')]+'%'};return _0x2d71a7;})});}_0x58ccdd=_[_0x30f6('0x37')]({},_0x58ccdd,_0x4b6b0a['options']);return _0x45e2fb['getFields'](_0x58ccdd);}})['then'](function(_0x309945){if(_0x309945){_0x580959=_0x309945[_0x30f6('0x47')];if(!_0x4b6b0a[_0x30f6('0x41')][_0x30f6('0x5a')](_0x30f6('0x48'))){_0x58ccdd[_0x30f6('0x29')]=qs[_0x30f6('0x29')](_0x4b6b0a[_0x30f6('0x41')][_0x30f6('0x29')]);_0x58ccdd['offset']=qs[_0x30f6('0x27')](_0x4b6b0a[_0x30f6('0x41')]['offset']);}return _0x45e2fb['getFields'](_0x58ccdd);}})[_0x30f6('0x19')](function(_0x35e37f){if(_0x35e37f){return _0x35e37f?{'count':_0x580959,'rows':_0x35e37f}:null;}})[_0x30f6('0x19')](respondWithResult(_0x3715c5,null))['catch'](handleError(_0x3715c5,null));};exports[_0x30f6('0x5b')]=function(_0xce726a,_0x5c6cf1,_0x924ab6){var _0x5686ca={};var _0x280feb={};var _0xcf93ad;var _0xdb3267;return db[_0x30f6('0x3c')][_0x30f6('0x59')]({'where':{'id':_0xce726a[_0x30f6('0x53')]['id']}})['then'](handleEntityNotFound(_0x5c6cf1,null))['then'](function(_0x49fa8d){if(_0x49fa8d){_0xcf93ad=_0x49fa8d;_0x280feb[_0x30f6('0x40')]=_[_0x30f6('0x42')](db[_0x30f6('0x5c')][_0x30f6('0x3d')]);_0x280feb[_0x30f6('0x41')]=_[_0x30f6('0x42')](_0xce726a[_0x30f6('0x41')]);_0x280feb[_0x30f6('0x43')]=_['intersection'](_0x280feb['model'],_0x280feb[_0x30f6('0x41')]);_0x5686ca[_0x30f6('0x44')]=_['intersection'](_0x280feb['model'],qs['fields'](_0xce726a[_0x30f6('0x41')][_0x30f6('0x46')]));_0x5686ca[_0x30f6('0x44')]=_0x5686ca['attributes'][_0x30f6('0x47')]?_0x5686ca[_0x30f6('0x44')]:_0x280feb[_0x30f6('0x40')];_0x5686ca[_0x30f6('0x49')]=qs[_0x30f6('0x4a')](_0xce726a['query'][_0x30f6('0x4a')]);_0x5686ca[_0x30f6('0x4b')]=qs['filters'](_[_0x30f6('0x4c')](_0xce726a['query'],_0x280feb[_0x30f6('0x43')]));if(_0xce726a['query']['filter']){_0x5686ca['where']=_[_0x30f6('0x37')](_0x5686ca[_0x30f6('0x4b')],{'$or':_[_0x30f6('0x3b')](_0x5686ca['attributes'],function(_0x42a7fb){var _0x421995={};_0x421995[_0x42a7fb]={'$like':'%'+_0xce726a['query'][_0x30f6('0x4d')]+'%'};return _0x421995;})});}_0x5686ca=_[_0x30f6('0x37')]({},_0x5686ca,_0xce726a[_0x30f6('0x4f')]);return _0xcf93ad[_0x30f6('0x5b')](_0x5686ca);}})[_0x30f6('0x19')](function(_0x539463){if(_0x539463){_0xdb3267=_0x539463[_0x30f6('0x47')];if(!_0xce726a[_0x30f6('0x41')][_0x30f6('0x5a')](_0x30f6('0x48'))){_0x5686ca[_0x30f6('0x29')]=qs[_0x30f6('0x29')](_0xce726a['query'][_0x30f6('0x29')]);_0x5686ca['offset']=qs[_0x30f6('0x27')](_0xce726a[_0x30f6('0x41')]['offset']);}return _0xcf93ad[_0x30f6('0x5b')](_0x5686ca);}})[_0x30f6('0x19')](function(_0x216268){if(_0x216268){return _0x216268?{'count':_0xdb3267,'rows':_0x216268}:null;}})[_0x30f6('0x19')](respondWithResult(_0x5c6cf1,null))[_0x30f6('0x55')](handleError(_0x5c6cf1,null));};exports[_0x30f6('0x5d')]=function(_0x524837,_0xe07b46,_0x34b510){var _0xabb333={};var _0x376494={};var _0x4ef924;var _0x17287f;return db['SalesforceConfiguration'][_0x30f6('0x59')]({'where':{'id':_0x524837[_0x30f6('0x53')]['id']}})['then'](handleEntityNotFound(_0xe07b46,null))[_0x30f6('0x19')](function(_0x56da89){if(_0x56da89){_0x4ef924=_0x56da89;_0x376494[_0x30f6('0x40')]=_['keys'](db[_0x30f6('0x5c')][_0x30f6('0x3d')]);_0x376494[_0x30f6('0x41')]=_[_0x30f6('0x42')](_0x524837[_0x30f6('0x41')]);_0x376494[_0x30f6('0x43')]=_[_0x30f6('0x45')](_0x376494[_0x30f6('0x40')],_0x376494[_0x30f6('0x41')]);_0xabb333[_0x30f6('0x44')]=_[_0x30f6('0x45')](_0x376494[_0x30f6('0x40')],qs[_0x30f6('0x46')](_0x524837[_0x30f6('0x41')][_0x30f6('0x46')]));_0xabb333[_0x30f6('0x44')]=_0xabb333[_0x30f6('0x44')]['length']?_0xabb333[_0x30f6('0x44')]:_0x376494[_0x30f6('0x40')];_0xabb333[_0x30f6('0x49')]=qs['sort'](_0x524837[_0x30f6('0x41')][_0x30f6('0x4a')]);_0xabb333[_0x30f6('0x4b')]=qs['filters'](_[_0x30f6('0x4c')](_0x524837[_0x30f6('0x41')],_0x376494[_0x30f6('0x43')]));if(_0x524837[_0x30f6('0x41')][_0x30f6('0x4d')]){_0xabb333['where']=_[_0x30f6('0x37')](_0xabb333[_0x30f6('0x4b')],{'$or':_[_0x30f6('0x3b')](_0xabb333[_0x30f6('0x44')],function(_0x23dd37){var _0xd184cd={};_0xd184cd[_0x23dd37]={'$like':'%'+_0x524837[_0x30f6('0x41')]['filter']+'%'};return _0xd184cd;})});}_0xabb333=_[_0x30f6('0x37')]({},_0xabb333,_0x524837[_0x30f6('0x4f')]);return _0x4ef924[_0x30f6('0x5d')](_0xabb333);}})['then'](function(_0x5973dc){if(_0x5973dc){_0x17287f=_0x5973dc[_0x30f6('0x47')];if(!_0x524837[_0x30f6('0x41')][_0x30f6('0x5a')](_0x30f6('0x48'))){_0xabb333[_0x30f6('0x29')]=qs[_0x30f6('0x29')](_0x524837['query']['limit']);_0xabb333['offset']=qs[_0x30f6('0x27')](_0x524837[_0x30f6('0x41')]['offset']);}return _0x4ef924[_0x30f6('0x5d')](_0xabb333);}})[_0x30f6('0x19')](function(_0x1158ac){if(_0x1158ac){return _0x1158ac?{'count':_0x17287f,'rows':_0x1158ac}:null;}})['then'](respondWithResult(_0xe07b46,null))[_0x30f6('0x55')](handleError(_0xe07b46,null));};