Built motion from commit (unavailable).|2.5.2
[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 _0xd87d=['limit','set','Content-Range','apply','reject','save','update','destroy','then','end','name','send','index','map','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','offset','order','sort','pick','filter','where','VIRTUAL','merge','options','SalesforceConfiguration','include','findAll','find','create','body','params','getFields','findOne','length','getSubjects','SalesforceField','getDescriptions','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','to-csv','ejs','lodash','squel','crypto','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','client','http','test','Sequelize','info','SalesforceConfiguration,\x20%s,\x20%s','request\x20sent','debug','SalesforceConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','message','result','catch','sendStatus','status','json','count'];(function(_0x1fd6b0,_0x5a40a0){var _0x202a08=function(_0x3a0674){while(--_0x3a0674){_0x1fd6b0['push'](_0x1fd6b0['shift']());}};_0x202a08(++_0x5a40a0);}(_0xd87d,0x19d));var _0xdd87=function(_0x263f85,_0xa94bec){_0x263f85=_0x263f85-0x0;var _0x58fc53=_0xd87d[_0x263f85];return _0x58fc53;};'use strict';var pdf=require(_0xdd87('0x0'));var emlformat=require(_0xdd87('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xdd87('0x2'));var jsonpatch=require(_0xdd87('0x3'));var rp=require(_0xdd87('0x4'));var moment=require(_0xdd87('0x5'));var BPromise=require(_0xdd87('0x6'));var Mustache=require(_0xdd87('0x7'));var util=require('util');var path=require(_0xdd87('0x8'));var sox=require('sox');var csv=require(_0xdd87('0x9'));var ejs=require(_0xdd87('0xa'));var fs=require('fs');var _=require(_0xdd87('0xb'));var squel=require(_0xdd87('0xc'));var crypto=require(_0xdd87('0xd'));var jsforce=require('jsforce');var deskjs=require(_0xdd87('0xe'));var toCsv=require(_0xdd87('0x9'));var querystring=require('querystring');var Papa=require(_0xdd87('0xf'));var Redis=require(_0xdd87('0x10'));var authService=require(_0xdd87('0x11'));var qs=require(_0xdd87('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xdd87('0x13'));var logger=require('../../config/logger')(_0xdd87('0x14'));var utils=require(_0xdd87('0x15'));var config=require(_0xdd87('0x16'));var db=require(_0xdd87('0x17'))['db'];var jayson=require('jayson/promise');var client=jayson[_0xdd87('0x18')][_0xdd87('0x19')]({'port':0x232a});function checkPasswordPattern(_0x491298,_0x3c7f3a,_0x22dff5){if(_0x22dff5){var _0x4b4683=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x4b4683[_0xdd87('0x1a')](_0x3c7f3a)){return _0x491298;}else{throw new db[(_0xdd87('0x1b'))]['ValidationError']('The\x20password\x20must\x20be\x20at\x20least\x208\x20characters\x20long\x20and\x20have\x201\x20lowercase\x20character,\x201\x20uppercase\x20character,\x201\x20number\x20and\x201\x20special\x20character\x20~!@#$%^&-_=+[{]}.');}}else{return _0x491298;}}function respondWithRpcPromise(_0x90234e,_0x230505,_0x53d45d,_0x4557fa){return new BPromise(function(_0x485dd5,_0x28c568){var _0x289010=_0x4557fa||client;return _0x289010['request'](_0x90234e,_0x53d45d)['then'](function(_0x47121e){logger[_0xdd87('0x1c')](_0xdd87('0x1d'),_0x230505,_0xdd87('0x1e'));logger[_0xdd87('0x1f')](_0xdd87('0x20'),_0x230505,_0xdd87('0x1e'),JSON[_0xdd87('0x21')](_0x47121e));if(_0x47121e[_0xdd87('0x22')]){if(_0x47121e['error']['code']===0x1f4){logger[_0xdd87('0x22')](_0xdd87('0x1d'),_0x230505,_0x47121e[_0xdd87('0x22')][_0xdd87('0x23')]);return _0x28c568(_0x47121e[_0xdd87('0x22')][_0xdd87('0x23')]);}logger[_0xdd87('0x22')](_0xdd87('0x1d'),_0x230505,_0x47121e[_0xdd87('0x22')]['message']);return _0x485dd5(_0x47121e[_0xdd87('0x22')][_0xdd87('0x23')]);}else{logger[_0xdd87('0x1c')]('SalesforceConfiguration,\x20%s,\x20%s',_0x230505,'request\x20sent');_0x485dd5(_0x47121e[_0xdd87('0x24')]['message']);}})[_0xdd87('0x25')](function(_0x221e8a){logger[_0xdd87('0x22')](_0xdd87('0x1d'),_0x230505,_0x221e8a);_0x28c568(_0x221e8a);});});}function respondWithStatusCode(_0xd6c555,_0x5fbc34){_0x5fbc34=_0x5fbc34||0xcc;return function(_0x1c5406){if(_0x1c5406){return _0xd6c555[_0xdd87('0x26')](_0x5fbc34);}return _0xd6c555[_0xdd87('0x27')](_0x5fbc34)['end']();};}function respondWithResult(_0x5a1c59,_0x3107db){_0x3107db=_0x3107db||0xc8;return function(_0xc3c420){if(_0xc3c420){return _0x5a1c59['status'](_0x3107db)[_0xdd87('0x28')](_0xc3c420);}};}function respondWithFilteredResult(_0x3deaf1,_0x4bb369){return function(_0x1cde2e){if(_0x1cde2e){var _0x26d759=_0x1cde2e[_0xdd87('0x29')],_0x3ef17b=_0x4bb369['offset'],_0x512e90=_0x4bb369['offset']+_0x4bb369[_0xdd87('0x2a')],_0x4ae397;if(_0x512e90>=_0x26d759){_0x512e90=_0x26d759;_0x4ae397=0xc8;}else{_0x4ae397=0xce;}_0x3deaf1[_0xdd87('0x27')](_0x4ae397);return _0x3deaf1[_0xdd87('0x2b')](_0xdd87('0x2c'),_0x3ef17b+'-'+_0x512e90+'/'+_0x26d759)[_0xdd87('0x28')](_0x1cde2e);}return null;};}function patchUpdates(_0x251798){return function(_0x4d3d36){try{jsonpatch[_0xdd87('0x2d')](_0x4d3d36,_0x251798,!![]);}catch(_0x39c302){return BPromise[_0xdd87('0x2e')](_0x39c302);}return _0x4d3d36[_0xdd87('0x2f')]();};}function saveUpdates(_0x336655,_0x1eddb9){return function(_0x3f4773){if(_0x3f4773){return _0x3f4773[_0xdd87('0x30')](_0x336655)['then'](function(_0x3a22f9){return _0x3a22f9;});}return null;};}function removeEntity(_0x15d424,_0x741876){return function(_0x311ec5){if(_0x311ec5){return _0x311ec5[_0xdd87('0x31')]()[_0xdd87('0x32')](function(){_0x15d424['status'](0xcc)[_0xdd87('0x33')]();});}};}function handleEntityNotFound(_0x21e431,_0x12fcb2){return function(_0x18c543){if(!_0x18c543){_0x21e431[_0xdd87('0x26')](0x194);}return _0x18c543;};}function handleError(_0x27af3a,_0x439b11){_0x439b11=_0x439b11||0x1f4;return function(_0x3ecd54){logger[_0xdd87('0x22')](_0x3ecd54['stack']);if(_0x3ecd54[_0xdd87('0x34')]){delete _0x3ecd54[_0xdd87('0x34')];}_0x27af3a[_0xdd87('0x27')](_0x439b11)[_0xdd87('0x35')](_0x3ecd54);};}exports[_0xdd87('0x36')]=function(_0x5e264a,_0x4e2348){var _0x80fa1b={},_0x1bd39d={},_0xdbba32={'count':0x0,'rows':[]};var _0xc00a63=_[_0xdd87('0x37')](db['SalesforceConfiguration'][_0xdd87('0x38')],function(_0x41536a){return{'name':_0x41536a[_0xdd87('0x39')],'type':_0x41536a[_0xdd87('0x3a')][_0xdd87('0x3b')]};});_0x1bd39d[_0xdd87('0x3c')]=_['map'](_0xc00a63,'name');_0x1bd39d[_0xdd87('0x3d')]=_[_0xdd87('0x3e')](_0x5e264a[_0xdd87('0x3d')]);_0x1bd39d[_0xdd87('0x3f')]=_[_0xdd87('0x40')](_0x1bd39d[_0xdd87('0x3c')],_0x1bd39d[_0xdd87('0x3d')]);_0x80fa1b[_0xdd87('0x41')]=_[_0xdd87('0x40')](_0x1bd39d['model'],qs['fields'](_0x5e264a[_0xdd87('0x3d')][_0xdd87('0x42')]));_0x80fa1b[_0xdd87('0x41')]=_0x80fa1b[_0xdd87('0x41')]['length']?_0x80fa1b['attributes']:_0x1bd39d['model'];if(!_0x5e264a['query'][_0xdd87('0x43')](_0xdd87('0x44'))){_0x80fa1b[_0xdd87('0x2a')]=qs[_0xdd87('0x2a')](_0x5e264a[_0xdd87('0x3d')][_0xdd87('0x2a')]);_0x80fa1b[_0xdd87('0x45')]=qs['offset'](_0x5e264a[_0xdd87('0x3d')][_0xdd87('0x45')]);}_0x80fa1b[_0xdd87('0x46')]=qs[_0xdd87('0x47')](_0x5e264a[_0xdd87('0x3d')]['sort']);_0x80fa1b['where']=qs[_0xdd87('0x3f')](_[_0xdd87('0x48')](_0x5e264a[_0xdd87('0x3d')],_0x1bd39d[_0xdd87('0x3f')]),_0xc00a63);if(_0x5e264a['query'][_0xdd87('0x49')]){_0x80fa1b[_0xdd87('0x4a')]=_['merge'](_0x80fa1b[_0xdd87('0x4a')],{'$or':_[_0xdd87('0x37')](_0xc00a63,function(_0x249374){if(_0x249374[_0xdd87('0x3a')]!==_0xdd87('0x4b')){var _0x144755={};_0x144755[_0x249374[_0xdd87('0x34')]]={'$like':'%'+_0x5e264a[_0xdd87('0x3d')][_0xdd87('0x49')]+'%'};return _0x144755;}})});}_0x80fa1b=_[_0xdd87('0x4c')]({},_0x80fa1b,_0x5e264a[_0xdd87('0x4d')]);var _0x2f92c1={'where':_0x80fa1b[_0xdd87('0x4a')]};return db[_0xdd87('0x4e')]['count'](_0x2f92c1)[_0xdd87('0x32')](function(_0x442ede){_0xdbba32[_0xdd87('0x29')]=_0x442ede;if(_0x5e264a[_0xdd87('0x3d')]['includeAll']){_0x80fa1b[_0xdd87('0x4f')]=[{'all':!![]}];}return db[_0xdd87('0x4e')][_0xdd87('0x50')](_0x80fa1b);})['then'](function(_0x1d0c44){_0xdbba32['rows']=_0x1d0c44;return _0xdbba32;})[_0xdd87('0x32')](respondWithFilteredResult(_0x4e2348,_0x80fa1b))['catch'](handleError(_0x4e2348,null));};exports['show']=function(_0xb5601d,_0x30284e){var _0x4e4082={'raw':![],'where':{'id':_0xb5601d['params']['id']}},_0x20f868={};_0x20f868['model']=_[_0xdd87('0x3e')](db[_0xdd87('0x4e')][_0xdd87('0x38')]);_0x20f868['query']=_[_0xdd87('0x3e')](_0xb5601d['query']);_0x20f868[_0xdd87('0x3f')]=_[_0xdd87('0x40')](_0x20f868['model'],_0x20f868[_0xdd87('0x3d')]);_0x4e4082[_0xdd87('0x41')]=_[_0xdd87('0x40')](_0x20f868['model'],qs[_0xdd87('0x42')](_0xb5601d[_0xdd87('0x3d')][_0xdd87('0x42')]));_0x4e4082['attributes']=_0x4e4082['attributes']['length']?_0x4e4082[_0xdd87('0x41')]:_0x20f868[_0xdd87('0x3c')];if(_0xb5601d[_0xdd87('0x3d')]['includeAll']){_0x4e4082[_0xdd87('0x4f')]=[{'all':!![]}];}_0x4e4082=_[_0xdd87('0x4c')]({},_0x4e4082,_0xb5601d['options']);return db[_0xdd87('0x4e')][_0xdd87('0x51')](_0x4e4082)[_0xdd87('0x32')](handleEntityNotFound(_0x30284e,null))[_0xdd87('0x32')](respondWithResult(_0x30284e,null))[_0xdd87('0x25')](handleError(_0x30284e,null));};exports[_0xdd87('0x52')]=function(_0x33b184,_0xd5de82){return db[_0xdd87('0x4e')]['create'](_0x33b184['body'],{})[_0xdd87('0x32')](respondWithResult(_0xd5de82,0xc9))[_0xdd87('0x25')](handleError(_0xd5de82,null));};exports['update']=function(_0x4edada,_0x55ffb8){if(_0x4edada[_0xdd87('0x53')]['id']){delete _0x4edada[_0xdd87('0x53')]['id'];}return db[_0xdd87('0x4e')]['find']({'where':{'id':_0x4edada['params']['id']}})[_0xdd87('0x32')](handleEntityNotFound(_0x55ffb8,null))[_0xdd87('0x32')](saveUpdates(_0x4edada[_0xdd87('0x53')],null))['then'](respondWithResult(_0x55ffb8,null))[_0xdd87('0x25')](handleError(_0x55ffb8,null));};exports['destroy']=function(_0x1de824,_0x4ebfbb){return db[_0xdd87('0x4e')][_0xdd87('0x51')]({'where':{'id':_0x1de824[_0xdd87('0x54')]['id']}})[_0xdd87('0x32')](handleEntityNotFound(_0x4ebfbb,null))['then'](removeEntity(_0x4ebfbb,null))['catch'](handleError(_0x4ebfbb,null));};exports[_0xdd87('0x55')]=function(_0x7b7410,_0x47a4a0,_0x11e568){var _0x18f256={};var _0x5ac664={};var _0x2680fe;var _0x4b6f3c;return db[_0xdd87('0x4e')][_0xdd87('0x56')]({'where':{'id':_0x7b7410[_0xdd87('0x54')]['id']}})[_0xdd87('0x32')](handleEntityNotFound(_0x47a4a0,null))['then'](function(_0x318851){if(_0x318851){_0x2680fe=_0x318851;_0x5ac664[_0xdd87('0x3c')]=_[_0xdd87('0x3e')](db['SalesforceField'][_0xdd87('0x38')]);_0x5ac664[_0xdd87('0x3d')]=_[_0xdd87('0x3e')](_0x7b7410[_0xdd87('0x3d')]);_0x5ac664['filters']=_[_0xdd87('0x40')](_0x5ac664[_0xdd87('0x3c')],_0x5ac664[_0xdd87('0x3d')]);_0x18f256['attributes']=_['intersection'](_0x5ac664[_0xdd87('0x3c')],qs['fields'](_0x7b7410[_0xdd87('0x3d')][_0xdd87('0x42')]));_0x18f256[_0xdd87('0x41')]=_0x18f256[_0xdd87('0x41')][_0xdd87('0x57')]?_0x18f256[_0xdd87('0x41')]:_0x5ac664[_0xdd87('0x3c')];_0x18f256[_0xdd87('0x46')]=qs['sort'](_0x7b7410[_0xdd87('0x3d')][_0xdd87('0x47')]);_0x18f256['where']=qs[_0xdd87('0x3f')](_[_0xdd87('0x48')](_0x7b7410['query'],_0x5ac664['filters']));if(_0x7b7410[_0xdd87('0x3d')][_0xdd87('0x49')]){_0x18f256[_0xdd87('0x4a')]=_[_0xdd87('0x4c')](_0x18f256[_0xdd87('0x4a')],{'$or':_[_0xdd87('0x37')](_0x18f256[_0xdd87('0x41')],function(_0x3781b9){var _0x3cc0b0={};_0x3cc0b0[_0x3781b9]={'$like':'%'+_0x7b7410[_0xdd87('0x3d')][_0xdd87('0x49')]+'%'};return _0x3cc0b0;})});}_0x18f256=_[_0xdd87('0x4c')]({},_0x18f256,_0x7b7410[_0xdd87('0x4d')]);return _0x2680fe['getFields'](_0x18f256);}})[_0xdd87('0x32')](function(_0xd4574e){if(_0xd4574e){_0x4b6f3c=_0xd4574e[_0xdd87('0x57')];if(!_0x7b7410[_0xdd87('0x3d')]['hasOwnProperty']('nolimit')){_0x18f256[_0xdd87('0x2a')]=qs['limit'](_0x7b7410['query'][_0xdd87('0x2a')]);_0x18f256[_0xdd87('0x45')]=qs['offset'](_0x7b7410[_0xdd87('0x3d')][_0xdd87('0x45')]);}return _0x2680fe[_0xdd87('0x55')](_0x18f256);}})[_0xdd87('0x32')](function(_0x3f35c7){if(_0x3f35c7){return _0x3f35c7?{'count':_0x4b6f3c,'rows':_0x3f35c7}:null;}})[_0xdd87('0x32')](respondWithResult(_0x47a4a0,null))[_0xdd87('0x25')](handleError(_0x47a4a0,null));};exports[_0xdd87('0x58')]=function(_0x5406ca,_0x4ccbe4,_0xcbc908){var _0x26a7d4={};var _0x4a9f52={};var _0x43986d;var _0x5ceba8;return db[_0xdd87('0x4e')][_0xdd87('0x56')]({'where':{'id':_0x5406ca[_0xdd87('0x54')]['id']}})['then'](handleEntityNotFound(_0x4ccbe4,null))['then'](function(_0x1cc1ab){if(_0x1cc1ab){_0x43986d=_0x1cc1ab;_0x4a9f52[_0xdd87('0x3c')]=_['keys'](db[_0xdd87('0x59')]['rawAttributes']);_0x4a9f52[_0xdd87('0x3d')]=_[_0xdd87('0x3e')](_0x5406ca[_0xdd87('0x3d')]);_0x4a9f52[_0xdd87('0x3f')]=_[_0xdd87('0x40')](_0x4a9f52[_0xdd87('0x3c')],_0x4a9f52[_0xdd87('0x3d')]);_0x26a7d4[_0xdd87('0x41')]=_[_0xdd87('0x40')](_0x4a9f52['model'],qs[_0xdd87('0x42')](_0x5406ca[_0xdd87('0x3d')][_0xdd87('0x42')]));_0x26a7d4[_0xdd87('0x41')]=_0x26a7d4[_0xdd87('0x41')]['length']?_0x26a7d4[_0xdd87('0x41')]:_0x4a9f52[_0xdd87('0x3c')];_0x26a7d4[_0xdd87('0x46')]=qs['sort'](_0x5406ca[_0xdd87('0x3d')][_0xdd87('0x47')]);_0x26a7d4[_0xdd87('0x4a')]=qs['filters'](_[_0xdd87('0x48')](_0x5406ca[_0xdd87('0x3d')],_0x4a9f52['filters']));if(_0x5406ca[_0xdd87('0x3d')][_0xdd87('0x49')]){_0x26a7d4[_0xdd87('0x4a')]=_[_0xdd87('0x4c')](_0x26a7d4[_0xdd87('0x4a')],{'$or':_[_0xdd87('0x37')](_0x26a7d4[_0xdd87('0x41')],function(_0x155b9f){var _0x31e93a={};_0x31e93a[_0x155b9f]={'$like':'%'+_0x5406ca[_0xdd87('0x3d')][_0xdd87('0x49')]+'%'};return _0x31e93a;})});}_0x26a7d4=_[_0xdd87('0x4c')]({},_0x26a7d4,_0x5406ca['options']);return _0x43986d['getSubjects'](_0x26a7d4);}})[_0xdd87('0x32')](function(_0x50aa9c){if(_0x50aa9c){_0x5ceba8=_0x50aa9c['length'];if(!_0x5406ca[_0xdd87('0x3d')][_0xdd87('0x43')](_0xdd87('0x44'))){_0x26a7d4[_0xdd87('0x2a')]=qs[_0xdd87('0x2a')](_0x5406ca['query'][_0xdd87('0x2a')]);_0x26a7d4[_0xdd87('0x45')]=qs[_0xdd87('0x45')](_0x5406ca[_0xdd87('0x3d')][_0xdd87('0x45')]);}return _0x43986d['getSubjects'](_0x26a7d4);}})['then'](function(_0x599bd5){if(_0x599bd5){return _0x599bd5?{'count':_0x5ceba8,'rows':_0x599bd5}:null;}})[_0xdd87('0x32')](respondWithResult(_0x4ccbe4,null))[_0xdd87('0x25')](handleError(_0x4ccbe4,null));};exports['getDescriptions']=function(_0x128442,_0x47b53e,_0x27d00e){var _0x56ba54={};var _0xbf0010={};var _0x1cc3f6;var _0x54bcd0;return db[_0xdd87('0x4e')][_0xdd87('0x56')]({'where':{'id':_0x128442[_0xdd87('0x54')]['id']}})[_0xdd87('0x32')](handleEntityNotFound(_0x47b53e,null))['then'](function(_0x171b41){if(_0x171b41){_0x1cc3f6=_0x171b41;_0xbf0010[_0xdd87('0x3c')]=_[_0xdd87('0x3e')](db['SalesforceField'][_0xdd87('0x38')]);_0xbf0010[_0xdd87('0x3d')]=_[_0xdd87('0x3e')](_0x128442['query']);_0xbf0010[_0xdd87('0x3f')]=_['intersection'](_0xbf0010[_0xdd87('0x3c')],_0xbf0010[_0xdd87('0x3d')]);_0x56ba54[_0xdd87('0x41')]=_[_0xdd87('0x40')](_0xbf0010[_0xdd87('0x3c')],qs[_0xdd87('0x42')](_0x128442['query']['fields']));_0x56ba54['attributes']=_0x56ba54[_0xdd87('0x41')][_0xdd87('0x57')]?_0x56ba54[_0xdd87('0x41')]:_0xbf0010[_0xdd87('0x3c')];_0x56ba54[_0xdd87('0x46')]=qs[_0xdd87('0x47')](_0x128442[_0xdd87('0x3d')]['sort']);_0x56ba54[_0xdd87('0x4a')]=qs[_0xdd87('0x3f')](_['pick'](_0x128442[_0xdd87('0x3d')],_0xbf0010[_0xdd87('0x3f')]));if(_0x128442[_0xdd87('0x3d')]['filter']){_0x56ba54['where']=_['merge'](_0x56ba54[_0xdd87('0x4a')],{'$or':_[_0xdd87('0x37')](_0x56ba54['attributes'],function(_0x43852f){var _0x689b14={};_0x689b14[_0x43852f]={'$like':'%'+_0x128442[_0xdd87('0x3d')]['filter']+'%'};return _0x689b14;})});}_0x56ba54=_['merge']({},_0x56ba54,_0x128442['options']);return _0x1cc3f6[_0xdd87('0x5a')](_0x56ba54);}})[_0xdd87('0x32')](function(_0x477cc8){if(_0x477cc8){_0x54bcd0=_0x477cc8[_0xdd87('0x57')];if(!_0x128442['query'][_0xdd87('0x43')](_0xdd87('0x44'))){_0x56ba54[_0xdd87('0x2a')]=qs['limit'](_0x128442[_0xdd87('0x3d')][_0xdd87('0x2a')]);_0x56ba54['offset']=qs[_0xdd87('0x45')](_0x128442[_0xdd87('0x3d')][_0xdd87('0x45')]);}return _0x1cc3f6[_0xdd87('0x5a')](_0x56ba54);}})[_0xdd87('0x32')](function(_0x3096f3){if(_0x3096f3){return _0x3096f3?{'count':_0x54bcd0,'rows':_0x3096f3}:null;}})[_0xdd87('0x32')](respondWithResult(_0x47b53e,null))['catch'](handleError(_0x47b53e,null));};