Built motion from commit (unavailable).|2.5.31
[motion2.git] / server / api / intFreshsalesConfiguration / intFreshsalesConfiguration.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 _0x6a94=['options','FreshsalesConfiguration','count','includeAll','findAll','rows','show','params','create','body','find','getSubjects','findOne','FreshsalesField','hasOwnProperty','getDescriptions','getFields','eml-format','rimraf','fast-json-patch','moment','mustache','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','jayson/promise','request','then','info','FreshsalesConfiguration,\x20%s,\x20%s','request\x20sent','FreshsalesConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','code','message','result','catch','sendStatus','status','end','json','offset','undefined','limit','set','save','update','destroy','stack','name','send','render','merge','contact','interaction','account','index','rawAttributes','fieldName','type','key','map','query','keys','intersection','attributes','fields','length','model','nolimit','order','sort','where','filters','pick','filter','VIRTUAL'];(function(_0x511bd1,_0x223e5b){var _0x4c48ec=function(_0x31814e){while(--_0x31814e){_0x511bd1['push'](_0x511bd1['shift']());}};_0x4c48ec(++_0x223e5b);}(_0x6a94,0x1dd));var _0x46a9=function(_0x1236e5,_0xd3d1e9){_0x1236e5=_0x1236e5-0x0;var _0x2dfa5a=_0x6a94[_0x1236e5];return _0x2dfa5a;};'use strict';var emlformat=require(_0x46a9('0x0'));var rimraf=require(_0x46a9('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x46a9('0x2'));var rp=require('request-promise');var moment=require(_0x46a9('0x3'));var BPromise=require('bluebird');var Mustache=require(_0x46a9('0x4'));var util=require('util');var path=require('path');var sox=require(_0x46a9('0x5'));var csv=require('to-csv');var ejs=require(_0x46a9('0x6'));var fs=require('fs');var fs_extra=require(_0x46a9('0x7'));var _=require(_0x46a9('0x8'));var squel=require(_0x46a9('0x9'));var crypto=require(_0x46a9('0xa'));var jsforce=require(_0x46a9('0xb'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x46a9('0xc'));var Papa=require('papaparse');var Redis=require(_0x46a9('0xd'));var authService=require(_0x46a9('0xe'));var qs=require(_0x46a9('0xf'));var as=require(_0x46a9('0x10'));var hardwareService=require(_0x46a9('0x11'));var logger=require('../../config/logger')(_0x46a9('0x12'));var utils=require(_0x46a9('0x13'));var config=require('../../config/environment');var licenseUtil=require(_0x46a9('0x14'));var db=require(_0x46a9('0x15'))['db'];var jayson=require(_0x46a9('0x16'));var client=jayson['client']['http']({'port':0x232a});function respondWithRpcPromise(_0xe78104,_0x2de39d,_0x57bb3e,_0x11dcdb){return new BPromise(function(_0x5c2dac,_0x37e6b7){var _0xf125f=_0x11dcdb||client;return _0xf125f[_0x46a9('0x17')](_0xe78104,_0x57bb3e)[_0x46a9('0x18')](function(_0x249275){logger[_0x46a9('0x19')](_0x46a9('0x1a'),_0x2de39d,_0x46a9('0x1b'));logger['debug'](_0x46a9('0x1c'),_0x2de39d,_0x46a9('0x1b'),JSON[_0x46a9('0x1d')](_0x249275));if(_0x249275[_0x46a9('0x1e')]){if(_0x249275[_0x46a9('0x1e')][_0x46a9('0x1f')]===0x1f4){logger[_0x46a9('0x1e')](_0x46a9('0x1a'),_0x2de39d,_0x249275[_0x46a9('0x1e')][_0x46a9('0x20')]);return _0x37e6b7(_0x249275[_0x46a9('0x1e')][_0x46a9('0x20')]);}logger[_0x46a9('0x1e')](_0x46a9('0x1a'),_0x2de39d,_0x249275['error'][_0x46a9('0x20')]);return _0x5c2dac(_0x249275[_0x46a9('0x1e')]['message']);}else{logger[_0x46a9('0x19')](_0x46a9('0x1a'),_0x2de39d,_0x46a9('0x1b'));_0x5c2dac(_0x249275[_0x46a9('0x21')][_0x46a9('0x20')]);}})[_0x46a9('0x22')](function(_0x2d2bac){logger[_0x46a9('0x1e')]('FreshsalesConfiguration,\x20%s,\x20%s',_0x2de39d,_0x2d2bac);_0x37e6b7(_0x2d2bac);});});}function respondWithStatusCode(_0x54ee37,_0x21e9fb){_0x21e9fb=_0x21e9fb||0xcc;return function(_0x54461d){if(_0x54461d){return _0x54ee37[_0x46a9('0x23')](_0x21e9fb);}return _0x54ee37[_0x46a9('0x24')](_0x21e9fb)[_0x46a9('0x25')]();};}function respondWithResult(_0x4e0909,_0x196265){_0x196265=_0x196265||0xc8;return function(_0x2c267b){if(_0x2c267b){return _0x4e0909[_0x46a9('0x24')](_0x196265)[_0x46a9('0x26')](_0x2c267b);}};}function respondWithFilteredResult(_0x5df33c,_0x278705){return function(_0x4bc6d1){if(_0x4bc6d1){var _0x42108d=typeof _0x278705[_0x46a9('0x27')]===_0x46a9('0x28')&&typeof _0x278705[_0x46a9('0x29')]===_0x46a9('0x28');var _0x5d96c0=_0x4bc6d1['count'];var _0x16748d=_0x42108d?0x0:_0x278705['offset'];var _0x5d0960=_0x42108d?_0x4bc6d1['count']:_0x278705[_0x46a9('0x27')]+_0x278705['limit'];var _0x55fe99;if(_0x5d0960>=_0x5d96c0){_0x5d0960=_0x5d96c0;_0x55fe99=0xc8;}else{_0x55fe99=0xce;}_0x5df33c['status'](_0x55fe99);return _0x5df33c[_0x46a9('0x2a')]('Content-Range',_0x16748d+'-'+_0x5d0960+'/'+_0x5d96c0)['json'](_0x4bc6d1);}return null;};}function patchUpdates(_0x54bca4){return function(_0x39604b){try{jsonpatch['apply'](_0x39604b,_0x54bca4,!![]);}catch(_0x9c1c4c){return BPromise['reject'](_0x9c1c4c);}return _0x39604b[_0x46a9('0x2b')]();};}function saveUpdates(_0x332271,_0xe52065){return function(_0x428b55){if(_0x428b55){return _0x428b55[_0x46a9('0x2c')](_0x332271)[_0x46a9('0x18')](function(_0xdb82aa){return _0xdb82aa;});}return null;};}function removeEntity(_0x453d8e,_0x4e0cd7){return function(_0x1c9ae9){if(_0x1c9ae9){return _0x1c9ae9[_0x46a9('0x2d')]()[_0x46a9('0x18')](function(){_0x453d8e[_0x46a9('0x24')](0xcc)['end']();});}};}function handleEntityNotFound(_0x6cd437,_0x5d6203){return function(_0x347ecd){if(!_0x347ecd){_0x6cd437[_0x46a9('0x23')](0x194);}return _0x347ecd;};}function handleError(_0x2625bc,_0x347c3c){_0x347c3c=_0x347c3c||0x1f4;return function(_0x4e65cc){logger[_0x46a9('0x1e')](_0x4e65cc[_0x46a9('0x2e')]);if(_0x4e65cc[_0x46a9('0x2f')]){delete _0x4e65cc[_0x46a9('0x2f')];}_0x2625bc['status'](_0x347c3c)[_0x46a9('0x30')](_0x4e65cc);};}function getMustacheRender(_0x39e1a9,_0x110a63){return Mustache[_0x46a9('0x31')](_0x39e1a9,_[_0x46a9('0x32')](_0x110a63['body'],{'contact':_0x110a63[_0x46a9('0x33')],'message':_0x110a63[_0x46a9('0x20')],'agent':_0x110a63['agent'],'interaction':_0x110a63[_0x46a9('0x34')],'account':_0x110a63[_0x46a9('0x35')]}))||'';}exports[_0x46a9('0x36')]=function(_0x8d7742,_0x467c66){var _0x105919={},_0x42b14d={},_0xa7b3d2={'count':0x0,'rows':[]};var _0x376eaf=_['map'](db['FreshsalesConfiguration'][_0x46a9('0x37')],function(_0x5b3b75){return{'name':_0x5b3b75[_0x46a9('0x38')],'type':_0x5b3b75[_0x46a9('0x39')][_0x46a9('0x3a')]};});_0x42b14d['model']=_[_0x46a9('0x3b')](_0x376eaf,'name');_0x42b14d[_0x46a9('0x3c')]=_[_0x46a9('0x3d')](_0x8d7742['query']);_0x42b14d['filters']=_[_0x46a9('0x3e')](_0x42b14d['model'],_0x42b14d['query']);_0x105919[_0x46a9('0x3f')]=_[_0x46a9('0x3e')](_0x42b14d['model'],qs[_0x46a9('0x40')](_0x8d7742[_0x46a9('0x3c')][_0x46a9('0x40')]));_0x105919[_0x46a9('0x3f')]=_0x105919[_0x46a9('0x3f')][_0x46a9('0x41')]?_0x105919[_0x46a9('0x3f')]:_0x42b14d[_0x46a9('0x42')];if(!_0x8d7742[_0x46a9('0x3c')]['hasOwnProperty'](_0x46a9('0x43'))){_0x105919[_0x46a9('0x29')]=qs['limit'](_0x8d7742[_0x46a9('0x3c')][_0x46a9('0x29')]);_0x105919[_0x46a9('0x27')]=qs[_0x46a9('0x27')](_0x8d7742[_0x46a9('0x3c')]['offset']);}_0x105919[_0x46a9('0x44')]=qs[_0x46a9('0x45')](_0x8d7742['query'][_0x46a9('0x45')]);_0x105919[_0x46a9('0x46')]=qs[_0x46a9('0x47')](_[_0x46a9('0x48')](_0x8d7742[_0x46a9('0x3c')],_0x42b14d[_0x46a9('0x47')]),_0x376eaf);if(_0x8d7742[_0x46a9('0x3c')][_0x46a9('0x49')]){_0x105919[_0x46a9('0x46')]=_[_0x46a9('0x32')](_0x105919[_0x46a9('0x46')],{'$or':_[_0x46a9('0x3b')](_0x376eaf,function(_0xf40e88){if(_0xf40e88[_0x46a9('0x39')]!==_0x46a9('0x4a')){var _0x1d4890={};_0x1d4890[_0xf40e88[_0x46a9('0x2f')]]={'$like':'%'+_0x8d7742[_0x46a9('0x3c')][_0x46a9('0x49')]+'%'};return _0x1d4890;}})});}_0x105919=_[_0x46a9('0x32')]({},_0x105919,_0x8d7742[_0x46a9('0x4b')]);var _0xacf8a2={'where':_0x105919[_0x46a9('0x46')]};return db[_0x46a9('0x4c')][_0x46a9('0x4d')](_0xacf8a2)['then'](function(_0x1b4224){_0xa7b3d2[_0x46a9('0x4d')]=_0x1b4224;if(_0x8d7742[_0x46a9('0x3c')][_0x46a9('0x4e')]){_0x105919['include']=[{'all':!![]}];}return db[_0x46a9('0x4c')][_0x46a9('0x4f')](_0x105919);})[_0x46a9('0x18')](function(_0x5b42a0){_0xa7b3d2[_0x46a9('0x50')]=_0x5b42a0;return _0xa7b3d2;})[_0x46a9('0x18')](respondWithFilteredResult(_0x467c66,_0x105919))[_0x46a9('0x22')](handleError(_0x467c66,null));};exports[_0x46a9('0x51')]=function(_0x68a01,_0x352de7){var _0x42045e={'raw':![],'where':{'id':_0x68a01[_0x46a9('0x52')]['id']}},_0x148547={};_0x148547['model']=_[_0x46a9('0x3d')](db[_0x46a9('0x4c')]['rawAttributes']);_0x148547[_0x46a9('0x3c')]=_[_0x46a9('0x3d')](_0x68a01['query']);_0x148547['filters']=_['intersection'](_0x148547[_0x46a9('0x42')],_0x148547[_0x46a9('0x3c')]);_0x42045e[_0x46a9('0x3f')]=_[_0x46a9('0x3e')](_0x148547['model'],qs[_0x46a9('0x40')](_0x68a01['query'][_0x46a9('0x40')]));_0x42045e['attributes']=_0x42045e['attributes'][_0x46a9('0x41')]?_0x42045e[_0x46a9('0x3f')]:_0x148547[_0x46a9('0x42')];if(_0x68a01['query']['includeAll']){_0x42045e['include']=[{'all':!![]}];}_0x42045e=_['merge']({},_0x42045e,_0x68a01['options']);return db[_0x46a9('0x4c')]['find'](_0x42045e)['then'](handleEntityNotFound(_0x352de7,null))[_0x46a9('0x18')](respondWithResult(_0x352de7,null))[_0x46a9('0x22')](handleError(_0x352de7,null));};exports[_0x46a9('0x53')]=function(_0xe3be59,_0x4f6f58){return db[_0x46a9('0x4c')][_0x46a9('0x53')](_0xe3be59[_0x46a9('0x54')],{})['then'](respondWithResult(_0x4f6f58,0xc9))[_0x46a9('0x22')](handleError(_0x4f6f58,null));};exports[_0x46a9('0x2c')]=function(_0x5e962f,_0x2dfb01){if(_0x5e962f[_0x46a9('0x54')]['id']){delete _0x5e962f[_0x46a9('0x54')]['id'];}return db['FreshsalesConfiguration'][_0x46a9('0x55')]({'where':{'id':_0x5e962f['params']['id']}})[_0x46a9('0x18')](handleEntityNotFound(_0x2dfb01,null))['then'](saveUpdates(_0x5e962f[_0x46a9('0x54')],null))[_0x46a9('0x18')](respondWithResult(_0x2dfb01,null))[_0x46a9('0x22')](handleError(_0x2dfb01,null));};exports['destroy']=function(_0x2f9ec1,_0x4298ba){return db[_0x46a9('0x4c')][_0x46a9('0x55')]({'where':{'id':_0x2f9ec1['params']['id']}})[_0x46a9('0x18')](handleEntityNotFound(_0x4298ba,null))['then'](removeEntity(_0x4298ba,null))[_0x46a9('0x22')](handleError(_0x4298ba,null));};exports[_0x46a9('0x56')]=function(_0x54e9aa,_0x3ae1c1,_0x528bf8){var _0xc2cc13={};var _0xee1521={};var _0x5bf788;var _0x4c48a6;return db[_0x46a9('0x4c')][_0x46a9('0x57')]({'where':{'id':_0x54e9aa[_0x46a9('0x52')]['id']}})['then'](handleEntityNotFound(_0x3ae1c1,null))[_0x46a9('0x18')](function(_0x4fd8a6){if(_0x4fd8a6){_0x5bf788=_0x4fd8a6;_0xee1521[_0x46a9('0x42')]=_['keys'](db[_0x46a9('0x58')]['rawAttributes']);_0xee1521['query']=_[_0x46a9('0x3d')](_0x54e9aa[_0x46a9('0x3c')]);_0xee1521[_0x46a9('0x47')]=_[_0x46a9('0x3e')](_0xee1521[_0x46a9('0x42')],_0xee1521['query']);_0xc2cc13['attributes']=_[_0x46a9('0x3e')](_0xee1521[_0x46a9('0x42')],qs[_0x46a9('0x40')](_0x54e9aa['query']['fields']));_0xc2cc13[_0x46a9('0x3f')]=_0xc2cc13['attributes']['length']?_0xc2cc13[_0x46a9('0x3f')]:_0xee1521[_0x46a9('0x42')];_0xc2cc13['order']=qs['sort'](_0x54e9aa[_0x46a9('0x3c')]['sort']);_0xc2cc13[_0x46a9('0x46')]=qs['filters'](_[_0x46a9('0x48')](_0x54e9aa[_0x46a9('0x3c')],_0xee1521[_0x46a9('0x47')]));if(_0x54e9aa[_0x46a9('0x3c')][_0x46a9('0x49')]){_0xc2cc13[_0x46a9('0x46')]=_['merge'](_0xc2cc13['where'],{'$or':_[_0x46a9('0x3b')](_0xc2cc13['attributes'],function(_0x1e6c01){var _0x3d0667={};_0x3d0667[_0x1e6c01]={'$like':'%'+_0x54e9aa[_0x46a9('0x3c')][_0x46a9('0x49')]+'%'};return _0x3d0667;})});}_0xc2cc13=_[_0x46a9('0x32')]({},_0xc2cc13,_0x54e9aa['options']);return _0x5bf788[_0x46a9('0x56')](_0xc2cc13);}})['then'](function(_0x1e2180){if(_0x1e2180){_0x4c48a6=_0x1e2180[_0x46a9('0x41')];if(!_0x54e9aa[_0x46a9('0x3c')][_0x46a9('0x59')]('nolimit')){_0xc2cc13[_0x46a9('0x29')]=qs[_0x46a9('0x29')](_0x54e9aa[_0x46a9('0x3c')][_0x46a9('0x29')]);_0xc2cc13[_0x46a9('0x27')]=qs[_0x46a9('0x27')](_0x54e9aa[_0x46a9('0x3c')][_0x46a9('0x27')]);}return _0x5bf788[_0x46a9('0x56')](_0xc2cc13);}})[_0x46a9('0x18')](function(_0x258601){if(_0x258601){return _0x258601?{'count':_0x4c48a6,'rows':_0x258601}:null;}})['then'](respondWithResult(_0x3ae1c1,null))[_0x46a9('0x22')](handleError(_0x3ae1c1,null));};exports[_0x46a9('0x5a')]=function(_0x3b56c8,_0x59c77c,_0x27e9){var _0x7a248={};var _0x4cf0fb={};var _0x135ea6;var _0x486733;return db[_0x46a9('0x4c')][_0x46a9('0x57')]({'where':{'id':_0x3b56c8['params']['id']}})[_0x46a9('0x18')](handleEntityNotFound(_0x59c77c,null))[_0x46a9('0x18')](function(_0x5a4757){if(_0x5a4757){_0x135ea6=_0x5a4757;_0x4cf0fb[_0x46a9('0x42')]=_['keys'](db[_0x46a9('0x58')][_0x46a9('0x37')]);_0x4cf0fb[_0x46a9('0x3c')]=_['keys'](_0x3b56c8[_0x46a9('0x3c')]);_0x4cf0fb[_0x46a9('0x47')]=_[_0x46a9('0x3e')](_0x4cf0fb[_0x46a9('0x42')],_0x4cf0fb[_0x46a9('0x3c')]);_0x7a248[_0x46a9('0x3f')]=_[_0x46a9('0x3e')](_0x4cf0fb[_0x46a9('0x42')],qs[_0x46a9('0x40')](_0x3b56c8[_0x46a9('0x3c')][_0x46a9('0x40')]));_0x7a248[_0x46a9('0x3f')]=_0x7a248[_0x46a9('0x3f')][_0x46a9('0x41')]?_0x7a248['attributes']:_0x4cf0fb[_0x46a9('0x42')];_0x7a248[_0x46a9('0x44')]=qs[_0x46a9('0x45')](_0x3b56c8['query'][_0x46a9('0x45')]);_0x7a248[_0x46a9('0x46')]=qs[_0x46a9('0x47')](_[_0x46a9('0x48')](_0x3b56c8[_0x46a9('0x3c')],_0x4cf0fb[_0x46a9('0x47')]));if(_0x3b56c8[_0x46a9('0x3c')][_0x46a9('0x49')]){_0x7a248[_0x46a9('0x46')]=_['merge'](_0x7a248[_0x46a9('0x46')],{'$or':_['map'](_0x7a248['attributes'],function(_0x2a5b59){var _0xc5d6e5={};_0xc5d6e5[_0x2a5b59]={'$like':'%'+_0x3b56c8[_0x46a9('0x3c')][_0x46a9('0x49')]+'%'};return _0xc5d6e5;})});}_0x7a248=_[_0x46a9('0x32')]({},_0x7a248,_0x3b56c8[_0x46a9('0x4b')]);return _0x135ea6[_0x46a9('0x5a')](_0x7a248);}})[_0x46a9('0x18')](function(_0x1f9693){if(_0x1f9693){_0x486733=_0x1f9693[_0x46a9('0x41')];if(!_0x3b56c8[_0x46a9('0x3c')][_0x46a9('0x59')](_0x46a9('0x43'))){_0x7a248[_0x46a9('0x29')]=qs[_0x46a9('0x29')](_0x3b56c8['query'][_0x46a9('0x29')]);_0x7a248['offset']=qs[_0x46a9('0x27')](_0x3b56c8['query']['offset']);}return _0x135ea6[_0x46a9('0x5a')](_0x7a248);}})[_0x46a9('0x18')](function(_0x1ad924){if(_0x1ad924){return _0x1ad924?{'count':_0x486733,'rows':_0x1ad924}:null;}})['then'](respondWithResult(_0x59c77c,null))[_0x46a9('0x22')](handleError(_0x59c77c,null));};exports[_0x46a9('0x5b')]=function(_0x34fd29,_0x20ba4c,_0x1edb4f){var _0xaf41a6={};var _0x2aff36={};var _0x3debda;var _0x4e0dfd;return db['FreshsalesConfiguration'][_0x46a9('0x57')]({'where':{'id':_0x34fd29['params']['id']}})[_0x46a9('0x18')](handleEntityNotFound(_0x20ba4c,null))[_0x46a9('0x18')](function(_0x4c73a6){if(_0x4c73a6){_0x3debda=_0x4c73a6;_0x2aff36[_0x46a9('0x42')]=_[_0x46a9('0x3d')](db[_0x46a9('0x58')][_0x46a9('0x37')]);_0x2aff36[_0x46a9('0x3c')]=_[_0x46a9('0x3d')](_0x34fd29[_0x46a9('0x3c')]);_0x2aff36[_0x46a9('0x47')]=_[_0x46a9('0x3e')](_0x2aff36[_0x46a9('0x42')],_0x2aff36[_0x46a9('0x3c')]);_0xaf41a6[_0x46a9('0x3f')]=_[_0x46a9('0x3e')](_0x2aff36[_0x46a9('0x42')],qs['fields'](_0x34fd29[_0x46a9('0x3c')][_0x46a9('0x40')]));_0xaf41a6['attributes']=_0xaf41a6['attributes'][_0x46a9('0x41')]?_0xaf41a6[_0x46a9('0x3f')]:_0x2aff36['model'];_0xaf41a6[_0x46a9('0x44')]=qs['sort'](_0x34fd29[_0x46a9('0x3c')]['sort']);_0xaf41a6[_0x46a9('0x46')]=qs[_0x46a9('0x47')](_[_0x46a9('0x48')](_0x34fd29[_0x46a9('0x3c')],_0x2aff36['filters']));if(_0x34fd29[_0x46a9('0x3c')][_0x46a9('0x49')]){_0xaf41a6['where']=_[_0x46a9('0x32')](_0xaf41a6[_0x46a9('0x46')],{'$or':_['map'](_0xaf41a6[_0x46a9('0x3f')],function(_0x1d19db){var _0x115268={};_0x115268[_0x1d19db]={'$like':'%'+_0x34fd29[_0x46a9('0x3c')]['filter']+'%'};return _0x115268;})});}_0xaf41a6=_[_0x46a9('0x32')]({},_0xaf41a6,_0x34fd29['options']);return _0x3debda[_0x46a9('0x5b')](_0xaf41a6);}})[_0x46a9('0x18')](function(_0x15cd93){if(_0x15cd93){_0x4e0dfd=_0x15cd93[_0x46a9('0x41')];if(!_0x34fd29['query'][_0x46a9('0x59')]('nolimit')){_0xaf41a6[_0x46a9('0x29')]=qs[_0x46a9('0x29')](_0x34fd29[_0x46a9('0x3c')]['limit']);_0xaf41a6['offset']=qs[_0x46a9('0x27')](_0x34fd29['query'][_0x46a9('0x27')]);}return _0x3debda[_0x46a9('0x5b')](_0xaf41a6);}})[_0x46a9('0x18')](function(_0x1cb58e){if(_0x1cb58e){return _0x1cb58e?{'count':_0x4e0dfd,'rows':_0x1cb58e}:null;}})['then'](respondWithResult(_0x20ba4c,null))['catch'](handleError(_0x20ba4c,null));};