c0afbb870a6692818ffc993075ccf95d4e859760
[motion2.git] / server / api / intZohoConfiguration / intZohoConfiguration.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 _0x6aa7=['includeAll','include','findAll','show','find','create','body','destroy','params','findOne','ZohoField','order','pick','getFields','getSubjects','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','ejs','lodash','squel','crypto','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','jayson/promise','http','then','ZohoConfiguration,\x20%s,\x20%s','debug','request\x20sent','stringify','error','code','message','result','catch','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','stack','name','index','rawAttributes','fieldName','type','model','map','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','merge','VIRTUAL','filter','options','ZohoConfiguration'];(function(_0x42bb6d,_0x412255){var _0x1db89b=function(_0x5da43a){while(--_0x5da43a){_0x42bb6d['push'](_0x42bb6d['shift']());}};_0x1db89b(++_0x412255);}(_0x6aa7,0x178));var _0x76aa=function(_0x209612,_0x49a2d1){_0x209612=_0x209612-0x0;var _0x3fdc83=_0x6aa7[_0x209612];return _0x3fdc83;};'use strict';var emlformat=require(_0x76aa('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x76aa('0x1'));var jsonpatch=require(_0x76aa('0x2'));var rp=require(_0x76aa('0x3'));var moment=require(_0x76aa('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x76aa('0x5'));var util=require(_0x76aa('0x6'));var path=require(_0x76aa('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x76aa('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x76aa('0x9'));var squel=require(_0x76aa('0xa'));var crypto=require(_0x76aa('0xb'));var jsforce=require('jsforce');var deskjs=require(_0x76aa('0xc'));var toCsv=require(_0x76aa('0xd'));var querystring=require(_0x76aa('0xe'));var Papa=require('papaparse');var Redis=require(_0x76aa('0xf'));var authService=require(_0x76aa('0x10'));var qs=require(_0x76aa('0x11'));var as=require(_0x76aa('0x12'));var hardwareService=require(_0x76aa('0x13'));var logger=require(_0x76aa('0x14'))(_0x76aa('0x15'));var utils=require(_0x76aa('0x16'));var config=require(_0x76aa('0x17'));var licenseUtil=require(_0x76aa('0x18'));var db=require('../../mysqldb')['db'];var jayson=require(_0x76aa('0x19'));var client=jayson['client'][_0x76aa('0x1a')]({'port':0x232a});function respondWithRpcPromise(_0x12dde0,_0x3f8f6b,_0x8e44ed,_0x10432c){return new BPromise(function(_0x4e309f,_0x5f5b59){var _0x2b3b4f=_0x10432c||client;return _0x2b3b4f['request'](_0x12dde0,_0x8e44ed)[_0x76aa('0x1b')](function(_0x319bf1){logger['info'](_0x76aa('0x1c'),_0x3f8f6b,'request\x20sent');logger[_0x76aa('0x1d')]('ZohoConfiguration,\x20%s,\x20%s,\x20%s',_0x3f8f6b,_0x76aa('0x1e'),JSON[_0x76aa('0x1f')](_0x319bf1));if(_0x319bf1[_0x76aa('0x20')]){if(_0x319bf1[_0x76aa('0x20')][_0x76aa('0x21')]===0x1f4){logger[_0x76aa('0x20')]('ZohoConfiguration,\x20%s,\x20%s',_0x3f8f6b,_0x319bf1['error'][_0x76aa('0x22')]);return _0x5f5b59(_0x319bf1[_0x76aa('0x20')][_0x76aa('0x22')]);}logger[_0x76aa('0x20')](_0x76aa('0x1c'),_0x3f8f6b,_0x319bf1[_0x76aa('0x20')][_0x76aa('0x22')]);return _0x4e309f(_0x319bf1[_0x76aa('0x20')][_0x76aa('0x22')]);}else{logger['info'](_0x76aa('0x1c'),_0x3f8f6b,_0x76aa('0x1e'));_0x4e309f(_0x319bf1[_0x76aa('0x23')]['message']);}})[_0x76aa('0x24')](function(_0x189cb6){logger[_0x76aa('0x20')](_0x76aa('0x1c'),_0x3f8f6b,_0x189cb6);_0x5f5b59(_0x189cb6);});});}function respondWithStatusCode(_0x29c50c,_0xc1044c){_0xc1044c=_0xc1044c||0xcc;return function(_0x3cd039){if(_0x3cd039){return _0x29c50c[_0x76aa('0x25')](_0xc1044c);}return _0x29c50c[_0x76aa('0x26')](_0xc1044c)[_0x76aa('0x27')]();};}function respondWithResult(_0x37f1ab,_0x26b75e){_0x26b75e=_0x26b75e||0xc8;return function(_0x3599a9){if(_0x3599a9){return _0x37f1ab['status'](_0x26b75e)[_0x76aa('0x28')](_0x3599a9);}};}function respondWithFilteredResult(_0x1d6d15,_0x25c614){return function(_0x2e7ab4){if(_0x2e7ab4){var _0xa1e6=_0x2e7ab4[_0x76aa('0x29')],_0x2f9316=_0x25c614[_0x76aa('0x2a')],_0x25a803=_0x25c614['offset']+_0x25c614[_0x76aa('0x2b')],_0x282d0a;if(_0x25a803>=_0xa1e6){_0x25a803=_0xa1e6;_0x282d0a=0xc8;}else{_0x282d0a=0xce;}_0x1d6d15['status'](_0x282d0a);return _0x1d6d15[_0x76aa('0x2c')](_0x76aa('0x2d'),_0x2f9316+'-'+_0x25a803+'/'+_0xa1e6)[_0x76aa('0x28')](_0x2e7ab4);}return null;};}function patchUpdates(_0x1e90b9){return function(_0x1eecd9){try{jsonpatch[_0x76aa('0x2e')](_0x1eecd9,_0x1e90b9,!![]);}catch(_0x2ee0f9){return BPromise[_0x76aa('0x2f')](_0x2ee0f9);}return _0x1eecd9[_0x76aa('0x30')]();};}function saveUpdates(_0x3ea05a,_0x5edcd8){return function(_0x430ad6){if(_0x430ad6){return _0x430ad6[_0x76aa('0x31')](_0x3ea05a)[_0x76aa('0x1b')](function(_0x928ccf){return _0x928ccf;});}return null;};}function removeEntity(_0x458ac3,_0x38ecd1){return function(_0x35a705){if(_0x35a705){return _0x35a705['destroy']()[_0x76aa('0x1b')](function(){_0x458ac3[_0x76aa('0x26')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2ee338,_0x58d860){return function(_0x2e2ba3){if(!_0x2e2ba3){_0x2ee338['sendStatus'](0x194);}return _0x2e2ba3;};}function handleError(_0x8479a3,_0x5653e0){_0x5653e0=_0x5653e0||0x1f4;return function(_0x58f135){logger[_0x76aa('0x20')](_0x58f135[_0x76aa('0x32')]);if(_0x58f135[_0x76aa('0x33')]){delete _0x58f135[_0x76aa('0x33')];}_0x8479a3['status'](_0x5653e0)['send'](_0x58f135);};}exports[_0x76aa('0x34')]=function(_0x1c7b6f,_0x58127c){var _0x23e2fd={},_0x23029e={},_0x5b57d8={'count':0x0,'rows':[]};var _0x9ce5f4=_['map'](db['ZohoConfiguration'][_0x76aa('0x35')],function(_0x36d64e){return{'name':_0x36d64e[_0x76aa('0x36')],'type':_0x36d64e[_0x76aa('0x37')]['key']};});_0x23029e[_0x76aa('0x38')]=_[_0x76aa('0x39')](_0x9ce5f4,_0x76aa('0x33'));_0x23029e['query']=_[_0x76aa('0x3a')](_0x1c7b6f[_0x76aa('0x3b')]);_0x23029e[_0x76aa('0x3c')]=_[_0x76aa('0x3d')](_0x23029e[_0x76aa('0x38')],_0x23029e[_0x76aa('0x3b')]);_0x23e2fd[_0x76aa('0x3e')]=_[_0x76aa('0x3d')](_0x23029e[_0x76aa('0x38')],qs['fields'](_0x1c7b6f[_0x76aa('0x3b')][_0x76aa('0x3f')]));_0x23e2fd[_0x76aa('0x3e')]=_0x23e2fd[_0x76aa('0x3e')][_0x76aa('0x40')]?_0x23e2fd[_0x76aa('0x3e')]:_0x23029e['model'];if(!_0x1c7b6f['query'][_0x76aa('0x41')](_0x76aa('0x42'))){_0x23e2fd[_0x76aa('0x2b')]=qs[_0x76aa('0x2b')](_0x1c7b6f['query'][_0x76aa('0x2b')]);_0x23e2fd[_0x76aa('0x2a')]=qs[_0x76aa('0x2a')](_0x1c7b6f[_0x76aa('0x3b')][_0x76aa('0x2a')]);}_0x23e2fd['order']=qs[_0x76aa('0x43')](_0x1c7b6f['query'][_0x76aa('0x43')]);_0x23e2fd['where']=qs['filters'](_['pick'](_0x1c7b6f[_0x76aa('0x3b')],_0x23029e['filters']),_0x9ce5f4);if(_0x1c7b6f['query']['filter']){_0x23e2fd[_0x76aa('0x44')]=_[_0x76aa('0x45')](_0x23e2fd[_0x76aa('0x44')],{'$or':_[_0x76aa('0x39')](_0x9ce5f4,function(_0x27a52e){if(_0x27a52e['type']!==_0x76aa('0x46')){var _0x14df8c={};_0x14df8c[_0x27a52e[_0x76aa('0x33')]]={'$like':'%'+_0x1c7b6f[_0x76aa('0x3b')][_0x76aa('0x47')]+'%'};return _0x14df8c;}})});}_0x23e2fd=_['merge']({},_0x23e2fd,_0x1c7b6f[_0x76aa('0x48')]);var _0x1c62a9={'where':_0x23e2fd['where']};return db[_0x76aa('0x49')]['count'](_0x1c62a9)[_0x76aa('0x1b')](function(_0x24ea05){_0x5b57d8[_0x76aa('0x29')]=_0x24ea05;if(_0x1c7b6f[_0x76aa('0x3b')][_0x76aa('0x4a')]){_0x23e2fd[_0x76aa('0x4b')]=[{'all':!![]}];}return db[_0x76aa('0x49')][_0x76aa('0x4c')](_0x23e2fd);})[_0x76aa('0x1b')](function(_0x3946bd){_0x5b57d8['rows']=_0x3946bd;return _0x5b57d8;})[_0x76aa('0x1b')](respondWithFilteredResult(_0x58127c,_0x23e2fd))['catch'](handleError(_0x58127c,null));};exports[_0x76aa('0x4d')]=function(_0x3d3332,_0x5e95f5){var _0x156d4e={'raw':![],'where':{'id':_0x3d3332['params']['id']}},_0x5ca721={};_0x5ca721[_0x76aa('0x38')]=_['keys'](db[_0x76aa('0x49')][_0x76aa('0x35')]);_0x5ca721[_0x76aa('0x3b')]=_[_0x76aa('0x3a')](_0x3d3332[_0x76aa('0x3b')]);_0x5ca721[_0x76aa('0x3c')]=_['intersection'](_0x5ca721['model'],_0x5ca721[_0x76aa('0x3b')]);_0x156d4e[_0x76aa('0x3e')]=_[_0x76aa('0x3d')](_0x5ca721[_0x76aa('0x38')],qs[_0x76aa('0x3f')](_0x3d3332[_0x76aa('0x3b')]['fields']));_0x156d4e[_0x76aa('0x3e')]=_0x156d4e[_0x76aa('0x3e')][_0x76aa('0x40')]?_0x156d4e['attributes']:_0x5ca721[_0x76aa('0x38')];if(_0x3d3332['query'][_0x76aa('0x4a')]){_0x156d4e['include']=[{'all':!![]}];}_0x156d4e=_[_0x76aa('0x45')]({},_0x156d4e,_0x3d3332[_0x76aa('0x48')]);return db[_0x76aa('0x49')][_0x76aa('0x4e')](_0x156d4e)[_0x76aa('0x1b')](handleEntityNotFound(_0x5e95f5,null))[_0x76aa('0x1b')](respondWithResult(_0x5e95f5,null))[_0x76aa('0x24')](handleError(_0x5e95f5,null));};exports['create']=function(_0x186654,_0x5eeaa5){return db[_0x76aa('0x49')][_0x76aa('0x4f')](_0x186654[_0x76aa('0x50')],{})[_0x76aa('0x1b')](respondWithResult(_0x5eeaa5,0xc9))[_0x76aa('0x24')](handleError(_0x5eeaa5,null));};exports[_0x76aa('0x31')]=function(_0x336024,_0x57941d){if(_0x336024[_0x76aa('0x50')]['id']){delete _0x336024[_0x76aa('0x50')]['id'];}return db[_0x76aa('0x49')][_0x76aa('0x4e')]({'where':{'id':_0x336024['params']['id']}})[_0x76aa('0x1b')](handleEntityNotFound(_0x57941d,null))[_0x76aa('0x1b')](saveUpdates(_0x336024[_0x76aa('0x50')],null))[_0x76aa('0x1b')](respondWithResult(_0x57941d,null))[_0x76aa('0x24')](handleError(_0x57941d,null));};exports[_0x76aa('0x51')]=function(_0x4e6c09,_0x295b2c){return db[_0x76aa('0x49')][_0x76aa('0x4e')]({'where':{'id':_0x4e6c09[_0x76aa('0x52')]['id']}})[_0x76aa('0x1b')](handleEntityNotFound(_0x295b2c,null))[_0x76aa('0x1b')](removeEntity(_0x295b2c,null))[_0x76aa('0x24')](handleError(_0x295b2c,null));};exports['getFields']=function(_0x4910fb,_0x2c59a6,_0x3b0d8a){var _0x5713e7={};var _0x3d7802={};var _0x1e6f3c;var _0x4f832d;return db[_0x76aa('0x49')][_0x76aa('0x53')]({'where':{'id':_0x4910fb[_0x76aa('0x52')]['id']}})[_0x76aa('0x1b')](handleEntityNotFound(_0x2c59a6,null))[_0x76aa('0x1b')](function(_0x1f5010){if(_0x1f5010){_0x1e6f3c=_0x1f5010;_0x3d7802[_0x76aa('0x38')]=_[_0x76aa('0x3a')](db[_0x76aa('0x54')]['rawAttributes']);_0x3d7802[_0x76aa('0x3b')]=_['keys'](_0x4910fb[_0x76aa('0x3b')]);_0x3d7802[_0x76aa('0x3c')]=_[_0x76aa('0x3d')](_0x3d7802[_0x76aa('0x38')],_0x3d7802[_0x76aa('0x3b')]);_0x5713e7[_0x76aa('0x3e')]=_[_0x76aa('0x3d')](_0x3d7802[_0x76aa('0x38')],qs[_0x76aa('0x3f')](_0x4910fb['query'][_0x76aa('0x3f')]));_0x5713e7[_0x76aa('0x3e')]=_0x5713e7[_0x76aa('0x3e')][_0x76aa('0x40')]?_0x5713e7[_0x76aa('0x3e')]:_0x3d7802[_0x76aa('0x38')];_0x5713e7[_0x76aa('0x55')]=qs[_0x76aa('0x43')](_0x4910fb['query'][_0x76aa('0x43')]);_0x5713e7['where']=qs[_0x76aa('0x3c')](_[_0x76aa('0x56')](_0x4910fb[_0x76aa('0x3b')],_0x3d7802[_0x76aa('0x3c')]));if(_0x4910fb[_0x76aa('0x3b')][_0x76aa('0x47')]){_0x5713e7[_0x76aa('0x44')]=_['merge'](_0x5713e7[_0x76aa('0x44')],{'$or':_[_0x76aa('0x39')](_0x5713e7['attributes'],function(_0x54334b){var _0x40429c={};_0x40429c[_0x54334b]={'$like':'%'+_0x4910fb[_0x76aa('0x3b')]['filter']+'%'};return _0x40429c;})});}_0x5713e7=_[_0x76aa('0x45')]({},_0x5713e7,_0x4910fb[_0x76aa('0x48')]);return _0x1e6f3c[_0x76aa('0x57')](_0x5713e7);}})['then'](function(_0x446073){if(_0x446073){_0x4f832d=_0x446073['length'];if(!_0x4910fb[_0x76aa('0x3b')][_0x76aa('0x41')](_0x76aa('0x42'))){_0x5713e7[_0x76aa('0x2b')]=qs['limit'](_0x4910fb['query'][_0x76aa('0x2b')]);_0x5713e7['offset']=qs[_0x76aa('0x2a')](_0x4910fb[_0x76aa('0x3b')][_0x76aa('0x2a')]);}return _0x1e6f3c[_0x76aa('0x57')](_0x5713e7);}})[_0x76aa('0x1b')](function(_0x30837c){if(_0x30837c){return _0x30837c?{'count':_0x4f832d,'rows':_0x30837c}:null;}})[_0x76aa('0x1b')](respondWithResult(_0x2c59a6,null))[_0x76aa('0x24')](handleError(_0x2c59a6,null));};exports[_0x76aa('0x58')]=function(_0x54390f,_0x7d02e7,_0x1eadee){var _0xc6f48d={};var _0x45ae9f={};var _0x4eb2e7;var _0x4c0af4;return db['ZohoConfiguration'][_0x76aa('0x53')]({'where':{'id':_0x54390f['params']['id']}})[_0x76aa('0x1b')](handleEntityNotFound(_0x7d02e7,null))[_0x76aa('0x1b')](function(_0x38faff){if(_0x38faff){_0x4eb2e7=_0x38faff;_0x45ae9f[_0x76aa('0x38')]=_['keys'](db[_0x76aa('0x54')]['rawAttributes']);_0x45ae9f[_0x76aa('0x3b')]=_[_0x76aa('0x3a')](_0x54390f[_0x76aa('0x3b')]);_0x45ae9f[_0x76aa('0x3c')]=_[_0x76aa('0x3d')](_0x45ae9f['model'],_0x45ae9f[_0x76aa('0x3b')]);_0xc6f48d[_0x76aa('0x3e')]=_[_0x76aa('0x3d')](_0x45ae9f[_0x76aa('0x38')],qs[_0x76aa('0x3f')](_0x54390f[_0x76aa('0x3b')][_0x76aa('0x3f')]));_0xc6f48d[_0x76aa('0x3e')]=_0xc6f48d['attributes'][_0x76aa('0x40')]?_0xc6f48d[_0x76aa('0x3e')]:_0x45ae9f['model'];_0xc6f48d[_0x76aa('0x55')]=qs[_0x76aa('0x43')](_0x54390f[_0x76aa('0x3b')][_0x76aa('0x43')]);_0xc6f48d[_0x76aa('0x44')]=qs[_0x76aa('0x3c')](_[_0x76aa('0x56')](_0x54390f['query'],_0x45ae9f[_0x76aa('0x3c')]));if(_0x54390f['query']['filter']){_0xc6f48d[_0x76aa('0x44')]=_[_0x76aa('0x45')](_0xc6f48d['where'],{'$or':_['map'](_0xc6f48d[_0x76aa('0x3e')],function(_0x14b5a2){var _0xd4cbe1={};_0xd4cbe1[_0x14b5a2]={'$like':'%'+_0x54390f['query']['filter']+'%'};return _0xd4cbe1;})});}_0xc6f48d=_[_0x76aa('0x45')]({},_0xc6f48d,_0x54390f[_0x76aa('0x48')]);return _0x4eb2e7[_0x76aa('0x58')](_0xc6f48d);}})['then'](function(_0xb70589){if(_0xb70589){_0x4c0af4=_0xb70589['length'];if(!_0x54390f[_0x76aa('0x3b')][_0x76aa('0x41')](_0x76aa('0x42'))){_0xc6f48d[_0x76aa('0x2b')]=qs[_0x76aa('0x2b')](_0x54390f['query']['limit']);_0xc6f48d[_0x76aa('0x2a')]=qs[_0x76aa('0x2a')](_0x54390f[_0x76aa('0x3b')]['offset']);}return _0x4eb2e7[_0x76aa('0x58')](_0xc6f48d);}})[_0x76aa('0x1b')](function(_0x2ce07f){if(_0x2ce07f){return _0x2ce07f?{'count':_0x4c0af4,'rows':_0x2ce07f}:null;}})[_0x76aa('0x1b')](respondWithResult(_0x7d02e7,null))[_0x76aa('0x24')](handleError(_0x7d02e7,null));};exports['getDescriptions']=function(_0x7a1e76,_0x5d2b9d,_0x213f7f){var _0xca8769={};var _0x2785e4={};var _0x2d9f60;var _0x45f05e;return db[_0x76aa('0x49')]['findOne']({'where':{'id':_0x7a1e76['params']['id']}})['then'](handleEntityNotFound(_0x5d2b9d,null))['then'](function(_0x490fa4){if(_0x490fa4){_0x2d9f60=_0x490fa4;_0x2785e4[_0x76aa('0x38')]=_[_0x76aa('0x3a')](db['ZohoField']['rawAttributes']);_0x2785e4['query']=_[_0x76aa('0x3a')](_0x7a1e76[_0x76aa('0x3b')]);_0x2785e4[_0x76aa('0x3c')]=_['intersection'](_0x2785e4['model'],_0x2785e4[_0x76aa('0x3b')]);_0xca8769[_0x76aa('0x3e')]=_[_0x76aa('0x3d')](_0x2785e4[_0x76aa('0x38')],qs[_0x76aa('0x3f')](_0x7a1e76['query']['fields']));_0xca8769[_0x76aa('0x3e')]=_0xca8769['attributes']['length']?_0xca8769['attributes']:_0x2785e4[_0x76aa('0x38')];_0xca8769[_0x76aa('0x55')]=qs['sort'](_0x7a1e76[_0x76aa('0x3b')][_0x76aa('0x43')]);_0xca8769['where']=qs[_0x76aa('0x3c')](_[_0x76aa('0x56')](_0x7a1e76[_0x76aa('0x3b')],_0x2785e4[_0x76aa('0x3c')]));if(_0x7a1e76[_0x76aa('0x3b')][_0x76aa('0x47')]){_0xca8769[_0x76aa('0x44')]=_[_0x76aa('0x45')](_0xca8769[_0x76aa('0x44')],{'$or':_['map'](_0xca8769[_0x76aa('0x3e')],function(_0xc877b1){var _0x4ed5c6={};_0x4ed5c6[_0xc877b1]={'$like':'%'+_0x7a1e76[_0x76aa('0x3b')][_0x76aa('0x47')]+'%'};return _0x4ed5c6;})});}_0xca8769=_[_0x76aa('0x45')]({},_0xca8769,_0x7a1e76['options']);return _0x2d9f60[_0x76aa('0x59')](_0xca8769);}})[_0x76aa('0x1b')](function(_0x4df4e0){if(_0x4df4e0){_0x45f05e=_0x4df4e0[_0x76aa('0x40')];if(!_0x7a1e76[_0x76aa('0x3b')][_0x76aa('0x41')]('nolimit')){_0xca8769[_0x76aa('0x2b')]=qs[_0x76aa('0x2b')](_0x7a1e76['query']['limit']);_0xca8769['offset']=qs[_0x76aa('0x2a')](_0x7a1e76[_0x76aa('0x3b')][_0x76aa('0x2a')]);}return _0x2d9f60[_0x76aa('0x59')](_0xca8769);}})['then'](function(_0x4ac469){if(_0x4ac469){return _0x4ac469?{'count':_0x45f05e,'rows':_0x4ac469}:null;}})['then'](respondWithResult(_0x5d2b9d,null))[_0x76aa('0x24')](handleError(_0x5d2b9d,null));};