1fd2d75e873014a33436b4ebbf5ec6dde5518542
[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 _0x56d0=['where','pick','filter','VIRTUAL','merge','include','findAll','rows','catch','show','params','includeAll','create','body','find','getSubjects','findOne','keys','FreshsalesField','map','options','getDescriptions','getFields','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','ejs','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','http','Sequelize','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~!@#$%^&-_=+[{]}.','request','info','request\x20sent','debug','FreshsalesConfiguration,\x20%s,\x20%s,\x20%s','stringify','code','error','FreshsalesConfiguration,\x20%s,\x20%s','message','result','sendStatus','end','status','count','offset','limit','set','Content-Range','json','reject','save','update','then','destroy','name','send','FreshsalesConfiguration','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort'];(function(_0x146a85,_0x529b52){var _0x1b59bf=function(_0x4af0fd){while(--_0x4af0fd){_0x146a85['push'](_0x146a85['shift']());}};_0x1b59bf(++_0x529b52);}(_0x56d0,0x18f));var _0x056d=function(_0x2c3a8f,_0x374e56){_0x2c3a8f=_0x2c3a8f-0x0;var _0x189412=_0x56d0[_0x2c3a8f];return _0x189412;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x056d('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x056d('0x1'));var jsonpatch=require(_0x056d('0x2'));var rp=require(_0x056d('0x3'));var moment=require(_0x056d('0x4'));var BPromise=require(_0x056d('0x5'));var Mustache=require(_0x056d('0x6'));var util=require(_0x056d('0x7'));var path=require(_0x056d('0x8'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x056d('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x056d('0xa'));var crypto=require(_0x056d('0xb'));var jsforce=require(_0x056d('0xc'));var deskjs=require(_0x056d('0xd'));var toCsv=require(_0x056d('0xe'));var querystring=require(_0x056d('0xf'));var Papa=require(_0x056d('0x10'));var Redis=require(_0x056d('0x11'));var authService=require(_0x056d('0x12'));var qs=require(_0x056d('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x056d('0x14'));var logger=require(_0x056d('0x15'))('api');var utils=require(_0x056d('0x16'));var config=require(_0x056d('0x17'));var db=require('../../mysqldb')['db'];var jayson=require('jayson/promise');var client=jayson['client'][_0x056d('0x18')]({'port':0x232a});function checkPasswordPattern(_0x186d41,_0x95934c,_0xe96c06){if(_0xe96c06){var _0x80839e=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x80839e['test'](_0x95934c)){return _0x186d41;}else{throw new db[(_0x056d('0x19'))][(_0x056d('0x1a'))](_0x056d('0x1b'));}}else{return _0x186d41;}}function respondWithRpcPromise(_0x37932f,_0x40c417,_0x195ac0,_0x5420fa){return new BPromise(function(_0x1c739a,_0x318075){var _0x192a27=_0x5420fa||client;return _0x192a27[_0x056d('0x1c')](_0x37932f,_0x195ac0)['then'](function(_0x4a0f66){logger[_0x056d('0x1d')]('FreshsalesConfiguration,\x20%s,\x20%s',_0x40c417,_0x056d('0x1e'));logger[_0x056d('0x1f')](_0x056d('0x20'),_0x40c417,_0x056d('0x1e'),JSON[_0x056d('0x21')](_0x4a0f66));if(_0x4a0f66['error']){if(_0x4a0f66['error'][_0x056d('0x22')]===0x1f4){logger[_0x056d('0x23')](_0x056d('0x24'),_0x40c417,_0x4a0f66[_0x056d('0x23')][_0x056d('0x25')]);return _0x318075(_0x4a0f66[_0x056d('0x23')][_0x056d('0x25')]);}logger['error'](_0x056d('0x24'),_0x40c417,_0x4a0f66['error']['message']);return _0x1c739a(_0x4a0f66['error']['message']);}else{logger[_0x056d('0x1d')](_0x056d('0x24'),_0x40c417,_0x056d('0x1e'));_0x1c739a(_0x4a0f66[_0x056d('0x26')][_0x056d('0x25')]);}})['catch'](function(_0x169f33){logger['error']('FreshsalesConfiguration,\x20%s,\x20%s',_0x40c417,_0x169f33);_0x318075(_0x169f33);});});}function respondWithStatusCode(_0x5ab8eb,_0x52c12c){_0x52c12c=_0x52c12c||0xcc;return function(_0x2c3a33){if(_0x2c3a33){return _0x5ab8eb[_0x056d('0x27')](_0x52c12c);}return _0x5ab8eb['status'](_0x52c12c)[_0x056d('0x28')]();};}function respondWithResult(_0x5b1350,_0x164506){_0x164506=_0x164506||0xc8;return function(_0x4d1b84){if(_0x4d1b84){return _0x5b1350[_0x056d('0x29')](_0x164506)['json'](_0x4d1b84);}};}function respondWithFilteredResult(_0x4d7adb,_0x5a7d6f){return function(_0x5425a1){if(_0x5425a1){var _0x472e8e=_0x5425a1[_0x056d('0x2a')],_0x119c3c=_0x5a7d6f[_0x056d('0x2b')],_0x3e2348=_0x5a7d6f[_0x056d('0x2b')]+_0x5a7d6f[_0x056d('0x2c')],_0x3e53f1;if(_0x3e2348>=_0x472e8e){_0x3e2348=_0x472e8e;_0x3e53f1=0xc8;}else{_0x3e53f1=0xce;}_0x4d7adb[_0x056d('0x29')](_0x3e53f1);return _0x4d7adb[_0x056d('0x2d')](_0x056d('0x2e'),_0x119c3c+'-'+_0x3e2348+'/'+_0x472e8e)[_0x056d('0x2f')](_0x5425a1);}return null;};}function patchUpdates(_0x54f01c){return function(_0x21b869){try{jsonpatch['apply'](_0x21b869,_0x54f01c,!![]);}catch(_0x58206b){return BPromise[_0x056d('0x30')](_0x58206b);}return _0x21b869[_0x056d('0x31')]();};}function saveUpdates(_0x4be93c,_0x59e57f){return function(_0x26d5c3){if(_0x26d5c3){return _0x26d5c3[_0x056d('0x32')](_0x4be93c)[_0x056d('0x33')](function(_0x2ee560){return _0x2ee560;});}return null;};}function removeEntity(_0x4a704c,_0x2352e8){return function(_0x28a662){if(_0x28a662){return _0x28a662[_0x056d('0x34')]()[_0x056d('0x33')](function(){_0x4a704c[_0x056d('0x29')](0xcc)[_0x056d('0x28')]();});}};}function handleEntityNotFound(_0x6009fc,_0x11ab15){return function(_0x51b79c){if(!_0x51b79c){_0x6009fc[_0x056d('0x27')](0x194);}return _0x51b79c;};}function handleError(_0x4c2ba7,_0x412e0b){_0x412e0b=_0x412e0b||0x1f4;return function(_0x334534){logger[_0x056d('0x23')](_0x334534['stack']);if(_0x334534[_0x056d('0x35')]){delete _0x334534[_0x056d('0x35')];}_0x4c2ba7['status'](_0x412e0b)[_0x056d('0x36')](_0x334534);};}exports['index']=function(_0x27e74a,_0x50d5b5){var _0x2e43c4={},_0x2c0477={},_0x4d58a5={'count':0x0,'rows':[]};var _0x10adb1=_['map'](db[_0x056d('0x37')][_0x056d('0x38')],function(_0x15a3ac){return{'name':_0x15a3ac[_0x056d('0x39')],'type':_0x15a3ac[_0x056d('0x3a')][_0x056d('0x3b')]};});_0x2c0477[_0x056d('0x3c')]=_['map'](_0x10adb1,_0x056d('0x35'));_0x2c0477[_0x056d('0x3d')]=_['keys'](_0x27e74a[_0x056d('0x3d')]);_0x2c0477[_0x056d('0x3e')]=_[_0x056d('0x3f')](_0x2c0477[_0x056d('0x3c')],_0x2c0477['query']);_0x2e43c4[_0x056d('0x40')]=_[_0x056d('0x3f')](_0x2c0477[_0x056d('0x3c')],qs['fields'](_0x27e74a[_0x056d('0x3d')][_0x056d('0x41')]));_0x2e43c4[_0x056d('0x40')]=_0x2e43c4['attributes'][_0x056d('0x42')]?_0x2e43c4[_0x056d('0x40')]:_0x2c0477[_0x056d('0x3c')];if(!_0x27e74a[_0x056d('0x3d')][_0x056d('0x43')](_0x056d('0x44'))){_0x2e43c4[_0x056d('0x2c')]=qs[_0x056d('0x2c')](_0x27e74a['query'][_0x056d('0x2c')]);_0x2e43c4[_0x056d('0x2b')]=qs[_0x056d('0x2b')](_0x27e74a[_0x056d('0x3d')][_0x056d('0x2b')]);}_0x2e43c4[_0x056d('0x45')]=qs[_0x056d('0x46')](_0x27e74a[_0x056d('0x3d')][_0x056d('0x46')]);_0x2e43c4[_0x056d('0x47')]=qs[_0x056d('0x3e')](_[_0x056d('0x48')](_0x27e74a[_0x056d('0x3d')],_0x2c0477[_0x056d('0x3e')]),_0x10adb1);if(_0x27e74a[_0x056d('0x3d')][_0x056d('0x49')]){_0x2e43c4[_0x056d('0x47')]=_['merge'](_0x2e43c4['where'],{'$or':_['map'](_0x10adb1,function(_0x20e4d5){if(_0x20e4d5[_0x056d('0x3a')]!==_0x056d('0x4a')){var _0x1ef91c={};_0x1ef91c[_0x20e4d5[_0x056d('0x35')]]={'$like':'%'+_0x27e74a[_0x056d('0x3d')][_0x056d('0x49')]+'%'};return _0x1ef91c;}})});}_0x2e43c4=_[_0x056d('0x4b')]({},_0x2e43c4,_0x27e74a['options']);var _0x5c9e38={'where':_0x2e43c4[_0x056d('0x47')]};return db[_0x056d('0x37')][_0x056d('0x2a')](_0x5c9e38)[_0x056d('0x33')](function(_0x4b7dc6){_0x4d58a5[_0x056d('0x2a')]=_0x4b7dc6;if(_0x27e74a['query']['includeAll']){_0x2e43c4[_0x056d('0x4c')]=[{'all':!![]}];}return db[_0x056d('0x37')][_0x056d('0x4d')](_0x2e43c4);})[_0x056d('0x33')](function(_0x9c533f){_0x4d58a5[_0x056d('0x4e')]=_0x9c533f;return _0x4d58a5;})['then'](respondWithFilteredResult(_0x50d5b5,_0x2e43c4))[_0x056d('0x4f')](handleError(_0x50d5b5,null));};exports[_0x056d('0x50')]=function(_0x4fc375,_0x2b1d6a){var _0x338ff6={'raw':![],'where':{'id':_0x4fc375[_0x056d('0x51')]['id']}},_0x36a3ae={};_0x36a3ae[_0x056d('0x3c')]=_['keys'](db[_0x056d('0x37')][_0x056d('0x38')]);_0x36a3ae[_0x056d('0x3d')]=_['keys'](_0x4fc375['query']);_0x36a3ae[_0x056d('0x3e')]=_['intersection'](_0x36a3ae[_0x056d('0x3c')],_0x36a3ae[_0x056d('0x3d')]);_0x338ff6[_0x056d('0x40')]=_[_0x056d('0x3f')](_0x36a3ae[_0x056d('0x3c')],qs[_0x056d('0x41')](_0x4fc375['query'][_0x056d('0x41')]));_0x338ff6['attributes']=_0x338ff6[_0x056d('0x40')]['length']?_0x338ff6[_0x056d('0x40')]:_0x36a3ae['model'];if(_0x4fc375[_0x056d('0x3d')][_0x056d('0x52')]){_0x338ff6[_0x056d('0x4c')]=[{'all':!![]}];}_0x338ff6=_['merge']({},_0x338ff6,_0x4fc375['options']);return db[_0x056d('0x37')]['find'](_0x338ff6)[_0x056d('0x33')](handleEntityNotFound(_0x2b1d6a,null))[_0x056d('0x33')](respondWithResult(_0x2b1d6a,null))[_0x056d('0x4f')](handleError(_0x2b1d6a,null));};exports[_0x056d('0x53')]=function(_0x2acf40,_0x30b5f1){return db[_0x056d('0x37')][_0x056d('0x53')](_0x2acf40[_0x056d('0x54')],{})[_0x056d('0x33')](respondWithResult(_0x30b5f1,0xc9))[_0x056d('0x4f')](handleError(_0x30b5f1,null));};exports[_0x056d('0x32')]=function(_0x226d92,_0x50c2d7){if(_0x226d92['body']['id']){delete _0x226d92[_0x056d('0x54')]['id'];}return db[_0x056d('0x37')][_0x056d('0x55')]({'where':{'id':_0x226d92[_0x056d('0x51')]['id']}})[_0x056d('0x33')](handleEntityNotFound(_0x50c2d7,null))['then'](saveUpdates(_0x226d92[_0x056d('0x54')],null))[_0x056d('0x33')](respondWithResult(_0x50c2d7,null))[_0x056d('0x4f')](handleError(_0x50c2d7,null));};exports[_0x056d('0x34')]=function(_0x3a1fcd,_0x5c3c1a){return db[_0x056d('0x37')]['find']({'where':{'id':_0x3a1fcd[_0x056d('0x51')]['id']}})[_0x056d('0x33')](handleEntityNotFound(_0x5c3c1a,null))[_0x056d('0x33')](removeEntity(_0x5c3c1a,null))[_0x056d('0x4f')](handleError(_0x5c3c1a,null));};exports[_0x056d('0x56')]=function(_0x482c60,_0x3781a4,_0x21f6ff){var _0x2ad90f={};var _0x5a8433={};var _0x5b5459;var _0xd831e0;return db['FreshsalesConfiguration'][_0x056d('0x57')]({'where':{'id':_0x482c60[_0x056d('0x51')]['id']}})[_0x056d('0x33')](handleEntityNotFound(_0x3781a4,null))[_0x056d('0x33')](function(_0x4c3262){if(_0x4c3262){_0x5b5459=_0x4c3262;_0x5a8433[_0x056d('0x3c')]=_[_0x056d('0x58')](db[_0x056d('0x59')][_0x056d('0x38')]);_0x5a8433['query']=_[_0x056d('0x58')](_0x482c60[_0x056d('0x3d')]);_0x5a8433[_0x056d('0x3e')]=_[_0x056d('0x3f')](_0x5a8433[_0x056d('0x3c')],_0x5a8433[_0x056d('0x3d')]);_0x2ad90f[_0x056d('0x40')]=_[_0x056d('0x3f')](_0x5a8433[_0x056d('0x3c')],qs[_0x056d('0x41')](_0x482c60[_0x056d('0x3d')][_0x056d('0x41')]));_0x2ad90f[_0x056d('0x40')]=_0x2ad90f[_0x056d('0x40')][_0x056d('0x42')]?_0x2ad90f[_0x056d('0x40')]:_0x5a8433[_0x056d('0x3c')];_0x2ad90f[_0x056d('0x45')]=qs[_0x056d('0x46')](_0x482c60['query'][_0x056d('0x46')]);_0x2ad90f[_0x056d('0x47')]=qs[_0x056d('0x3e')](_['pick'](_0x482c60[_0x056d('0x3d')],_0x5a8433['filters']));if(_0x482c60['query']['filter']){_0x2ad90f[_0x056d('0x47')]=_[_0x056d('0x4b')](_0x2ad90f[_0x056d('0x47')],{'$or':_[_0x056d('0x5a')](_0x2ad90f['attributes'],function(_0x59804f){var _0x26950f={};_0x26950f[_0x59804f]={'$like':'%'+_0x482c60[_0x056d('0x3d')][_0x056d('0x49')]+'%'};return _0x26950f;})});}_0x2ad90f=_[_0x056d('0x4b')]({},_0x2ad90f,_0x482c60[_0x056d('0x5b')]);return _0x5b5459['getSubjects'](_0x2ad90f);}})[_0x056d('0x33')](function(_0x4538fd){if(_0x4538fd){_0xd831e0=_0x4538fd[_0x056d('0x42')];if(!_0x482c60[_0x056d('0x3d')][_0x056d('0x43')](_0x056d('0x44'))){_0x2ad90f[_0x056d('0x2c')]=qs[_0x056d('0x2c')](_0x482c60[_0x056d('0x3d')]['limit']);_0x2ad90f[_0x056d('0x2b')]=qs[_0x056d('0x2b')](_0x482c60[_0x056d('0x3d')]['offset']);}return _0x5b5459[_0x056d('0x56')](_0x2ad90f);}})[_0x056d('0x33')](function(_0x25b6b1){if(_0x25b6b1){return _0x25b6b1?{'count':_0xd831e0,'rows':_0x25b6b1}:null;}})[_0x056d('0x33')](respondWithResult(_0x3781a4,null))[_0x056d('0x4f')](handleError(_0x3781a4,null));};exports[_0x056d('0x5c')]=function(_0x4daf10,_0x44b7c4,_0xa041d7){var _0xb0b04b={};var _0x2a0915={};var _0x2e4b91;var _0x31ed68;return db[_0x056d('0x37')][_0x056d('0x57')]({'where':{'id':_0x4daf10[_0x056d('0x51')]['id']}})[_0x056d('0x33')](handleEntityNotFound(_0x44b7c4,null))[_0x056d('0x33')](function(_0x4a2cca){if(_0x4a2cca){_0x2e4b91=_0x4a2cca;_0x2a0915['model']=_[_0x056d('0x58')](db[_0x056d('0x59')][_0x056d('0x38')]);_0x2a0915['query']=_[_0x056d('0x58')](_0x4daf10[_0x056d('0x3d')]);_0x2a0915[_0x056d('0x3e')]=_[_0x056d('0x3f')](_0x2a0915[_0x056d('0x3c')],_0x2a0915[_0x056d('0x3d')]);_0xb0b04b[_0x056d('0x40')]=_[_0x056d('0x3f')](_0x2a0915['model'],qs[_0x056d('0x41')](_0x4daf10[_0x056d('0x3d')][_0x056d('0x41')]));_0xb0b04b['attributes']=_0xb0b04b[_0x056d('0x40')]['length']?_0xb0b04b[_0x056d('0x40')]:_0x2a0915[_0x056d('0x3c')];_0xb0b04b['order']=qs[_0x056d('0x46')](_0x4daf10[_0x056d('0x3d')][_0x056d('0x46')]);_0xb0b04b[_0x056d('0x47')]=qs[_0x056d('0x3e')](_[_0x056d('0x48')](_0x4daf10[_0x056d('0x3d')],_0x2a0915['filters']));if(_0x4daf10[_0x056d('0x3d')][_0x056d('0x49')]){_0xb0b04b['where']=_[_0x056d('0x4b')](_0xb0b04b[_0x056d('0x47')],{'$or':_[_0x056d('0x5a')](_0xb0b04b[_0x056d('0x40')],function(_0x2d5fb6){var _0x12e354={};_0x12e354[_0x2d5fb6]={'$like':'%'+_0x4daf10[_0x056d('0x3d')][_0x056d('0x49')]+'%'};return _0x12e354;})});}_0xb0b04b=_[_0x056d('0x4b')]({},_0xb0b04b,_0x4daf10['options']);return _0x2e4b91[_0x056d('0x5c')](_0xb0b04b);}})[_0x056d('0x33')](function(_0x472a7e){if(_0x472a7e){_0x31ed68=_0x472a7e['length'];if(!_0x4daf10[_0x056d('0x3d')][_0x056d('0x43')]('nolimit')){_0xb0b04b[_0x056d('0x2c')]=qs[_0x056d('0x2c')](_0x4daf10[_0x056d('0x3d')][_0x056d('0x2c')]);_0xb0b04b[_0x056d('0x2b')]=qs[_0x056d('0x2b')](_0x4daf10[_0x056d('0x3d')][_0x056d('0x2b')]);}return _0x2e4b91[_0x056d('0x5c')](_0xb0b04b);}})['then'](function(_0x18dd2e){if(_0x18dd2e){return _0x18dd2e?{'count':_0x31ed68,'rows':_0x18dd2e}:null;}})[_0x056d('0x33')](respondWithResult(_0x44b7c4,null))[_0x056d('0x4f')](handleError(_0x44b7c4,null));};exports['getFields']=function(_0x1fafd0,_0x19422e,_0x269ba7){var _0x3875c0={};var _0x39e0e4={};var _0x41af99;var _0x1dfe7d;return db['FreshsalesConfiguration']['findOne']({'where':{'id':_0x1fafd0[_0x056d('0x51')]['id']}})[_0x056d('0x33')](handleEntityNotFound(_0x19422e,null))[_0x056d('0x33')](function(_0x3feb4c){if(_0x3feb4c){_0x41af99=_0x3feb4c;_0x39e0e4['model']=_['keys'](db[_0x056d('0x59')]['rawAttributes']);_0x39e0e4[_0x056d('0x3d')]=_['keys'](_0x1fafd0[_0x056d('0x3d')]);_0x39e0e4['filters']=_['intersection'](_0x39e0e4[_0x056d('0x3c')],_0x39e0e4[_0x056d('0x3d')]);_0x3875c0[_0x056d('0x40')]=_[_0x056d('0x3f')](_0x39e0e4[_0x056d('0x3c')],qs[_0x056d('0x41')](_0x1fafd0['query']['fields']));_0x3875c0['attributes']=_0x3875c0[_0x056d('0x40')]['length']?_0x3875c0[_0x056d('0x40')]:_0x39e0e4[_0x056d('0x3c')];_0x3875c0['order']=qs[_0x056d('0x46')](_0x1fafd0[_0x056d('0x3d')][_0x056d('0x46')]);_0x3875c0[_0x056d('0x47')]=qs[_0x056d('0x3e')](_['pick'](_0x1fafd0[_0x056d('0x3d')],_0x39e0e4[_0x056d('0x3e')]));if(_0x1fafd0[_0x056d('0x3d')]['filter']){_0x3875c0[_0x056d('0x47')]=_[_0x056d('0x4b')](_0x3875c0['where'],{'$or':_['map'](_0x3875c0[_0x056d('0x40')],function(_0x252956){var _0x1ad44f={};_0x1ad44f[_0x252956]={'$like':'%'+_0x1fafd0[_0x056d('0x3d')][_0x056d('0x49')]+'%'};return _0x1ad44f;})});}_0x3875c0=_[_0x056d('0x4b')]({},_0x3875c0,_0x1fafd0[_0x056d('0x5b')]);return _0x41af99[_0x056d('0x5d')](_0x3875c0);}})['then'](function(_0x471411){if(_0x471411){_0x1dfe7d=_0x471411['length'];if(!_0x1fafd0[_0x056d('0x3d')][_0x056d('0x43')](_0x056d('0x44'))){_0x3875c0[_0x056d('0x2c')]=qs[_0x056d('0x2c')](_0x1fafd0[_0x056d('0x3d')][_0x056d('0x2c')]);_0x3875c0[_0x056d('0x2b')]=qs['offset'](_0x1fafd0['query'][_0x056d('0x2b')]);}return _0x41af99[_0x056d('0x5d')](_0x3875c0);}})[_0x056d('0x33')](function(_0x3517c1){if(_0x3517c1){return _0x3517c1?{'count':_0x1dfe7d,'rows':_0x3517c1}:null;}})[_0x056d('0x33')](respondWithResult(_0x19422e,null))['catch'](handleError(_0x19422e,null));};