Built motion from commit (unavailable).|2.5.22
[motion2.git] / server / api / intZohoAccount / intZohoAccount.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 _0x7da6=['data_type','picklist','pick_list_values','statusCode','getFields,\x20%s,\x20%s,\x20%s','stringify','test','Wrong\x20credentials','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','lodash','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','../../components/integrations/configuration','jayson/promise','http','then','info','ZohoAccount,\x20%s,\x20%s','request\x20sent','debug','ZohoAccount,\x20%s,\x20%s,\x20%s','error','code','message','catch','sendStatus','end','status','json','count','offset','limit','set','Content-Range','apply','reject','save','update','destroy','name','send','index','map','ZohoAccount','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','nolimit','order','sort','where','pick','merge','filter','options','includeAll','include','rows','show','params','find','create','body','findOne','ZohoConfiguration','hasOwnProperty','getConfigurations','addConfiguration','AccountId','getSubjects','channel','getDescriptions','ZohoField','Descriptions','zone','https://accounts.zoho.com','https://accounts.zoho.com.au','https://accounts.zoho.in','https://accounts.zoho.com.cn','https://accounts.zoho.eu','/oauth/v2/token','clientId','clientSecret','refresh_token','access_token','Unable\x20to\x20retrieve\x20the\x20access\x20token','getFields','refreshToken','host','zoho.eu','com','serverUrl','slice','substring','lastIndexOf','GET','format','https://www.zohoapis.%s/crm/v2/settings/fields','Calls','Zoho-oauthtoken\x20','response','Owner','Subject','Description','WhoId','Call_Duration','Call_Start_Time','Call_Type','remove','includes','system_mandatory','push','display_label','custom_field'];(function(_0x3accdb,_0x187888){var _0x4dab57=function(_0x2ac22b){while(--_0x2ac22b){_0x3accdb['push'](_0x3accdb['shift']());}};_0x4dab57(++_0x187888);}(_0x7da6,0x124));var _0x67da=function(_0x4eaa9c,_0x3a879a){_0x4eaa9c=_0x4eaa9c-0x0;var _0x46b796=_0x7da6[_0x4eaa9c];return _0x46b796;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0x67da('0x0'));var zipdir=require(_0x67da('0x1'));var jsonpatch=require(_0x67da('0x2'));var rp=require(_0x67da('0x3'));var moment=require('moment');var BPromise=require(_0x67da('0x4'));var Mustache=require(_0x67da('0x5'));var util=require(_0x67da('0x6'));var path=require(_0x67da('0x7'));var sox=require(_0x67da('0x8'));var csv=require(_0x67da('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x67da('0xa'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x67da('0xb'));var deskjs=require('desk.js');var toCsv=require(_0x67da('0x9'));var querystring=require('querystring');var Papa=require(_0x67da('0xc'));var Redis=require(_0x67da('0xd'));var authService=require(_0x67da('0xe'));var qs=require(_0x67da('0xf'));var as=require(_0x67da('0x10'));var hardwareService=require(_0x67da('0x11'));var logger=require(_0x67da('0x12'))('api');var utils=require(_0x67da('0x13'));var config=require(_0x67da('0x14'));var licenseUtil=require(_0x67da('0x15'));var db=require(_0x67da('0x16'))['db'];var integrations=require(_0x67da('0x17'));var jayson=require(_0x67da('0x18'));var client=jayson['client'][_0x67da('0x19')]({'port':0x232a});function respondWithRpcPromise(_0x9beca6,_0x3929fb,_0x12d4d1,_0x13bb5b){return new BPromise(function(_0x508b4a,_0x11c7b5){var _0x33c466=_0x13bb5b||client;return _0x33c466['request'](_0x9beca6,_0x12d4d1)[_0x67da('0x1a')](function(_0x3b7f96){logger[_0x67da('0x1b')](_0x67da('0x1c'),_0x3929fb,_0x67da('0x1d'));logger[_0x67da('0x1e')](_0x67da('0x1f'),_0x3929fb,_0x67da('0x1d'),JSON['stringify'](_0x3b7f96));if(_0x3b7f96[_0x67da('0x20')]){if(_0x3b7f96['error'][_0x67da('0x21')]===0x1f4){logger['error'](_0x67da('0x1c'),_0x3929fb,_0x3b7f96[_0x67da('0x20')][_0x67da('0x22')]);return _0x11c7b5(_0x3b7f96[_0x67da('0x20')]['message']);}logger[_0x67da('0x20')]('ZohoAccount,\x20%s,\x20%s',_0x3929fb,_0x3b7f96['error'][_0x67da('0x22')]);return _0x508b4a(_0x3b7f96[_0x67da('0x20')][_0x67da('0x22')]);}else{logger[_0x67da('0x1b')]('ZohoAccount,\x20%s,\x20%s',_0x3929fb,'request\x20sent');_0x508b4a(_0x3b7f96['result'][_0x67da('0x22')]);}})[_0x67da('0x23')](function(_0x45fe05){logger[_0x67da('0x20')](_0x67da('0x1c'),_0x3929fb,_0x45fe05);_0x11c7b5(_0x45fe05);});});}function respondWithStatusCode(_0x4e6cb1,_0x5f1a47){_0x5f1a47=_0x5f1a47||0xcc;return function(_0xc2667e){if(_0xc2667e){return _0x4e6cb1[_0x67da('0x24')](_0x5f1a47);}return _0x4e6cb1['status'](_0x5f1a47)[_0x67da('0x25')]();};}function respondWithResult(_0x599a9d,_0x4417e5){_0x4417e5=_0x4417e5||0xc8;return function(_0x15207c){if(_0x15207c){return _0x599a9d[_0x67da('0x26')](_0x4417e5)[_0x67da('0x27')](_0x15207c);}};}function respondWithFilteredResult(_0x33a74d,_0x35b1bc){return function(_0x4c4bfe){if(_0x4c4bfe){var _0x2d2549=_0x4c4bfe[_0x67da('0x28')],_0x168a49=_0x35b1bc[_0x67da('0x29')],_0x5875d9=_0x35b1bc[_0x67da('0x29')]+_0x35b1bc[_0x67da('0x2a')],_0x5afdc4;if(_0x5875d9>=_0x2d2549){_0x5875d9=_0x2d2549;_0x5afdc4=0xc8;}else{_0x5afdc4=0xce;}_0x33a74d['status'](_0x5afdc4);return _0x33a74d[_0x67da('0x2b')](_0x67da('0x2c'),_0x168a49+'-'+_0x5875d9+'/'+_0x2d2549)[_0x67da('0x27')](_0x4c4bfe);}return null;};}function patchUpdates(_0x3a40f5){return function(_0x22fa93){try{jsonpatch[_0x67da('0x2d')](_0x22fa93,_0x3a40f5,!![]);}catch(_0x6962a0){return BPromise[_0x67da('0x2e')](_0x6962a0);}return _0x22fa93[_0x67da('0x2f')]();};}function saveUpdates(_0x91fc5c,_0x18dd99){return function(_0x181b99){if(_0x181b99){return _0x181b99[_0x67da('0x30')](_0x91fc5c)[_0x67da('0x1a')](function(_0x48e08a){return _0x48e08a;});}return null;};}function removeEntity(_0x229b6b,_0x2a949a){return function(_0x19e68c){if(_0x19e68c){return _0x19e68c[_0x67da('0x31')]()[_0x67da('0x1a')](function(){_0x229b6b[_0x67da('0x26')](0xcc)['end']();});}};}function handleEntityNotFound(_0x762be5,_0x31f025){return function(_0x6c4b32){if(!_0x6c4b32){_0x762be5['sendStatus'](0x194);}return _0x6c4b32;};}function handleError(_0x5a21e6,_0x5c9ab8){_0x5c9ab8=_0x5c9ab8||0x1f4;return function(_0x4cfcab){logger[_0x67da('0x20')](_0x4cfcab['stack']);if(_0x4cfcab[_0x67da('0x32')]){delete _0x4cfcab[_0x67da('0x32')];}_0x5a21e6[_0x67da('0x26')](_0x5c9ab8)[_0x67da('0x33')](_0x4cfcab);};}exports[_0x67da('0x34')]=function(_0x16b425,_0x2e37cb){var _0x13dbcb={},_0x3a4140={},_0x11ec02={'count':0x0,'rows':[]};var _0x207e63=_[_0x67da('0x35')](db[_0x67da('0x36')][_0x67da('0x37')],function(_0x3e48bf){return{'name':_0x3e48bf[_0x67da('0x38')],'type':_0x3e48bf[_0x67da('0x39')][_0x67da('0x3a')]};});_0x3a4140[_0x67da('0x3b')]=_[_0x67da('0x35')](_0x207e63,_0x67da('0x32'));_0x3a4140[_0x67da('0x3c')]=_[_0x67da('0x3d')](_0x16b425[_0x67da('0x3c')]);_0x3a4140[_0x67da('0x3e')]=_[_0x67da('0x3f')](_0x3a4140['model'],_0x3a4140[_0x67da('0x3c')]);_0x13dbcb[_0x67da('0x40')]=_['intersection'](_0x3a4140[_0x67da('0x3b')],qs[_0x67da('0x41')](_0x16b425['query']['fields']));_0x13dbcb['attributes']=_0x13dbcb[_0x67da('0x40')][_0x67da('0x42')]?_0x13dbcb[_0x67da('0x40')]:_0x3a4140[_0x67da('0x3b')];if(!_0x16b425[_0x67da('0x3c')]['hasOwnProperty'](_0x67da('0x43'))){_0x13dbcb['limit']=qs[_0x67da('0x2a')](_0x16b425[_0x67da('0x3c')][_0x67da('0x2a')]);_0x13dbcb[_0x67da('0x29')]=qs['offset'](_0x16b425[_0x67da('0x3c')]['offset']);}_0x13dbcb[_0x67da('0x44')]=qs[_0x67da('0x45')](_0x16b425[_0x67da('0x3c')]['sort']);_0x13dbcb[_0x67da('0x46')]=qs[_0x67da('0x3e')](_[_0x67da('0x47')](_0x16b425[_0x67da('0x3c')],_0x3a4140[_0x67da('0x3e')]),_0x207e63);if(_0x16b425[_0x67da('0x3c')]['filter']){_0x13dbcb['where']=_[_0x67da('0x48')](_0x13dbcb[_0x67da('0x46')],{'$or':_['map'](_0x207e63,function(_0x2ebc66){if(_0x2ebc66[_0x67da('0x39')]!=='VIRTUAL'){var _0x52840a={};_0x52840a[_0x2ebc66[_0x67da('0x32')]]={'$like':'%'+_0x16b425[_0x67da('0x3c')][_0x67da('0x49')]+'%'};return _0x52840a;}})});}_0x13dbcb=_['merge']({},_0x13dbcb,_0x16b425[_0x67da('0x4a')]);var _0x482734={'where':_0x13dbcb[_0x67da('0x46')]};return db[_0x67da('0x36')][_0x67da('0x28')](_0x482734)['then'](function(_0x883f08){_0x11ec02['count']=_0x883f08;if(_0x16b425[_0x67da('0x3c')][_0x67da('0x4b')]){_0x13dbcb[_0x67da('0x4c')]=[{'all':!![]}];}return db[_0x67da('0x36')]['findAll'](_0x13dbcb);})[_0x67da('0x1a')](function(_0x56671f){_0x11ec02[_0x67da('0x4d')]=_0x56671f;return _0x11ec02;})[_0x67da('0x1a')](respondWithFilteredResult(_0x2e37cb,_0x13dbcb))[_0x67da('0x23')](handleError(_0x2e37cb,null));};exports[_0x67da('0x4e')]=function(_0x446fb3,_0x40420b){var _0x5d9ebc={'raw':![],'where':{'id':_0x446fb3[_0x67da('0x4f')]['id']}},_0x3d4288={};_0x3d4288['model']=_[_0x67da('0x3d')](db[_0x67da('0x36')][_0x67da('0x37')]);_0x3d4288[_0x67da('0x3c')]=_[_0x67da('0x3d')](_0x446fb3['query']);_0x3d4288[_0x67da('0x3e')]=_[_0x67da('0x3f')](_0x3d4288[_0x67da('0x3b')],_0x3d4288[_0x67da('0x3c')]);_0x5d9ebc[_0x67da('0x40')]=_[_0x67da('0x3f')](_0x3d4288[_0x67da('0x3b')],qs[_0x67da('0x41')](_0x446fb3['query'][_0x67da('0x41')]));_0x5d9ebc[_0x67da('0x40')]=_0x5d9ebc[_0x67da('0x40')]['length']?_0x5d9ebc[_0x67da('0x40')]:_0x3d4288[_0x67da('0x3b')];if(_0x446fb3[_0x67da('0x3c')]['includeAll']){_0x5d9ebc[_0x67da('0x4c')]=[{'all':!![]}];}_0x5d9ebc=_[_0x67da('0x48')]({},_0x5d9ebc,_0x446fb3[_0x67da('0x4a')]);return db[_0x67da('0x36')][_0x67da('0x50')](_0x5d9ebc)[_0x67da('0x1a')](handleEntityNotFound(_0x40420b,null))[_0x67da('0x1a')](respondWithResult(_0x40420b,null))['catch'](handleError(_0x40420b,null));};exports[_0x67da('0x51')]=function(_0x28b71a,_0x4efb75){return db[_0x67da('0x36')]['create'](_0x28b71a[_0x67da('0x52')],{})[_0x67da('0x1a')](respondWithResult(_0x4efb75,0xc9))[_0x67da('0x23')](handleError(_0x4efb75,null));};exports['update']=function(_0x1b82f9,_0x54602d){if(_0x1b82f9['body']['id']){delete _0x1b82f9['body']['id'];}return db[_0x67da('0x36')][_0x67da('0x50')]({'where':{'id':_0x1b82f9[_0x67da('0x4f')]['id']}})['then'](handleEntityNotFound(_0x54602d,null))[_0x67da('0x1a')](saveUpdates(_0x1b82f9['body'],null))['then'](respondWithResult(_0x54602d,null))['catch'](handleError(_0x54602d,null));};exports[_0x67da('0x31')]=function(_0x525f1a,_0x4c96ca){return db[_0x67da('0x36')]['find']({'where':{'id':_0x525f1a[_0x67da('0x4f')]['id']}})[_0x67da('0x1a')](handleEntityNotFound(_0x4c96ca,null))[_0x67da('0x1a')](removeEntity(_0x4c96ca,null))[_0x67da('0x23')](handleError(_0x4c96ca,null));};exports['getConfigurations']=function(_0x1c478f,_0x1160b1,_0x4ac3df){var _0x27cebd={};var _0x45f320={};var _0x142518;var _0xbc383c;return db[_0x67da('0x36')][_0x67da('0x53')]({'where':{'id':_0x1c478f[_0x67da('0x4f')]['id']}})['then'](handleEntityNotFound(_0x1160b1,null))[_0x67da('0x1a')](function(_0x542ae2){if(_0x542ae2){_0x142518=_0x542ae2;_0x45f320[_0x67da('0x3b')]=_[_0x67da('0x3d')](db[_0x67da('0x54')]['rawAttributes']);_0x45f320[_0x67da('0x3c')]=_[_0x67da('0x3d')](_0x1c478f[_0x67da('0x3c')]);_0x45f320[_0x67da('0x3e')]=_[_0x67da('0x3f')](_0x45f320[_0x67da('0x3b')],_0x45f320['query']);_0x27cebd['attributes']=_['intersection'](_0x45f320[_0x67da('0x3b')],qs[_0x67da('0x41')](_0x1c478f[_0x67da('0x3c')][_0x67da('0x41')]));_0x27cebd['attributes']=_0x27cebd['attributes'][_0x67da('0x42')]?_0x27cebd[_0x67da('0x40')]:_0x45f320[_0x67da('0x3b')];_0x27cebd[_0x67da('0x44')]=qs['sort'](_0x1c478f[_0x67da('0x3c')][_0x67da('0x45')]);_0x27cebd['where']=qs[_0x67da('0x3e')](_[_0x67da('0x47')](_0x1c478f[_0x67da('0x3c')],_0x45f320[_0x67da('0x3e')]));if(_0x1c478f[_0x67da('0x3c')][_0x67da('0x49')]){_0x27cebd['where']=_[_0x67da('0x48')](_0x27cebd[_0x67da('0x46')],{'$or':_[_0x67da('0x35')](_0x27cebd['attributes'],function(_0x2f265c){var _0x5ceac9={};_0x5ceac9[_0x2f265c]={'$like':'%'+_0x1c478f[_0x67da('0x3c')][_0x67da('0x49')]+'%'};return _0x5ceac9;})});}_0x27cebd=_[_0x67da('0x48')]({},_0x27cebd,_0x1c478f[_0x67da('0x4a')]);return _0x142518['getConfigurations'](_0x27cebd);}})[_0x67da('0x1a')](function(_0x1fa2ab){if(_0x1fa2ab){_0xbc383c=_0x1fa2ab['length'];if(!_0x1c478f['query'][_0x67da('0x55')](_0x67da('0x43'))){_0x27cebd[_0x67da('0x2a')]=qs[_0x67da('0x2a')](_0x1c478f[_0x67da('0x3c')][_0x67da('0x2a')]);_0x27cebd[_0x67da('0x29')]=qs[_0x67da('0x29')](_0x1c478f['query'][_0x67da('0x29')]);}return _0x142518[_0x67da('0x56')](_0x27cebd);}})[_0x67da('0x1a')](function(_0x511448){if(_0x511448){return _0x511448?{'count':_0xbc383c,'rows':_0x511448}:null;}})[_0x67da('0x1a')](respondWithResult(_0x1160b1,null))[_0x67da('0x23')](handleError(_0x1160b1,null));};exports[_0x67da('0x57')]=function(_0xd28cb4,_0x167038,_0x454d30){if(_0xd28cb4[_0x67da('0x52')]['id']){delete _0xd28cb4[_0x67da('0x52')]['id'];}return db[_0x67da('0x36')][_0x67da('0x53')]({'where':{'id':_0xd28cb4[_0x67da('0x4f')]['id']}})[_0x67da('0x1a')](handleEntityNotFound(_0x167038,null))[_0x67da('0x1a')](function(_0x4f2317){if(_0x4f2317){_0xd28cb4[_0x67da('0x52')][_0x67da('0x58')]=_0x4f2317['id'];_0xd28cb4[_0x67da('0x52')]['Subjects']=integrations[_0x67da('0x59')](_0xd28cb4[_0x67da('0x52')][_0x67da('0x5a')],_0xd28cb4[_0x67da('0x52')][_0x67da('0x39')]);_0xd28cb4[_0x67da('0x52')]['Descriptions']=integrations[_0x67da('0x5b')](_0xd28cb4[_0x67da('0x52')][_0x67da('0x5a')],_0xd28cb4['body'][_0x67da('0x39')]);return db[_0x67da('0x54')][_0x67da('0x51')](_0xd28cb4[_0x67da('0x52')],{'include':[{'model':db[_0x67da('0x5c')],'as':'Subjects'},{'model':db[_0x67da('0x5c')],'as':_0x67da('0x5d')}]});}return null;})[_0x67da('0x1a')](respondWithResult(_0x167038,null))['catch'](handleError(_0x167038,null));};function getAccessToken(_0x445634){return new Promise(function(_0x30332e,_0x5154cf){var _0x41f1a2;switch(_0x445634[_0x67da('0x5e')]){case'US':_0x41f1a2=_0x67da('0x5f');break;case'AU':_0x41f1a2=_0x67da('0x60');break;case'EU':_0x41f1a2='https://accounts.zoho.eu';break;case'IN':_0x41f1a2=_0x67da('0x61');break;case'CN':_0x41f1a2=_0x67da('0x62');break;default:_0x41f1a2=_0x67da('0x63');break;}var _0x21be6a={'method':'POST','uri':_0x41f1a2+_0x67da('0x64'),'qs':{'refresh_token':_0x445634['refreshToken'],'client_id':_0x445634[_0x67da('0x65')],'client_secret':_0x445634[_0x67da('0x66')],'grant_type':_0x67da('0x67')},'json':!![]};return rp(_0x21be6a)[_0x67da('0x1a')](function(_0x2ffc32){if(_0x2ffc32[_0x67da('0x68')]){_0x30332e(_0x2ffc32[_0x67da('0x68')]);}else{_0x5154cf(_0x67da('0x69'));}})['catch'](function(_0x41b2f6){_0x5154cf(_0x41b2f6);});});}exports[_0x67da('0x6a')]=function(_0x59ebe9,_0x52c000,_0x2257ab){var _0x5c8ce6,_0x20d037,_0xd8c49,_0x10063f,_0x3c94d8;return db['ZohoAccount']['findOne']({'where':{'id':_0x59ebe9[_0x67da('0x4f')]['id']},'attributes':['id','host',_0x67da('0x5e'),_0x67da('0x65'),_0x67da('0x66'),'serverUrl',_0x67da('0x21'),_0x67da('0x6b')]})[_0x67da('0x1a')](handleEntityNotFound(_0x52c000,null))[_0x67da('0x1a')](function(_0x5b2008){_0x3c94d8=_0x5b2008;_0x5c8ce6=_0x3c94d8[_0x67da('0x6c')];_0x20d037=_0x5c8ce6===_0x67da('0x6d')?'eu':_0x67da('0x6e');_0xd8c49=_0x3c94d8[_0x67da('0x6f')];var _0x4c9a19=_0xd8c49[_0x67da('0x70')](-0x1);if(_0x4c9a19==='/'||_0x4c9a19==='\x5c'||_0x4c9a19===':'){_0xd8c49=_0xd8c49[_0x67da('0x71')](0x0,_0xd8c49[_0x67da('0x72')](_0x4c9a19));}if(!_0x3c94d8['refreshToken']){throw new Error('Refresh\x20Token\x20not\x20available\x20for\x20the\x20account');}return getAccessToken(_0x3c94d8);})[_0x67da('0x1a')](function(_0x434565){if(_0x434565){return rp({'method':_0x67da('0x73'),'uri':util[_0x67da('0x74')](_0x67da('0x75'),_0x20d037),'qs':{'module':_0x67da('0x76')},'headers':{'Authorization':_0x67da('0x77')+_0x434565},'json':!![]});}})['then'](function(_0xd1565e){if(_0xd1565e){if(_0xd1565e[_0x67da('0x78')]&&_0xd1565e[_0x67da('0x78')][_0x67da('0x20')]){throw new Error(_0xd1565e[_0x67da('0x78')][_0x67da('0x20')]['message']);}var _0x132915=[];var _0x490ba2=[];var _0x4f2233=[_0x67da('0x79'),_0x67da('0x7a'),_0x67da('0x7b'),_0x67da('0x7c'),_0x67da('0x7d'),'Call_Result',_0x67da('0x7e'),_0x67da('0x7f')];_0x490ba2=_[_0x67da('0x80')](_0xd1565e[_0x67da('0x41')],function(_0x5687b7){return _0x4f2233[_0x67da('0x81')](_0x5687b7['api_name']);});for(var _0x35c58c=0x0;_0x35c58c<_0x490ba2[_0x67da('0x42')];_0x35c58c++){if(_0x490ba2[_0x35c58c][_0x67da('0x82')]===![]){_0x132915[_0x67da('0x83')]({'id':_0x490ba2[_0x35c58c]['id'],'name':_0x490ba2[_0x35c58c][_0x67da('0x84')],'custom':_0x490ba2[_0x35c58c][_0x67da('0x85')],'options':_0x490ba2[_0x35c58c][_0x67da('0x86')]===_0x67da('0x87')&&_0x490ba2[_0x35c58c][_0x67da('0x88')][_0x67da('0x42')]>-0x1?_[_0x67da('0x35')](_0x490ba2[_0x35c58c][_0x67da('0x88')],function(_0x1d2aa5){return{'name':_0x1d2aa5,'value':_0x1d2aa5};}):[]});}}return{'count':_0x132915[_0x67da('0x42')],'rows':_0x132915};}else{return{'count':0x0,'rows':[]};}})[_0x67da('0x1a')](respondWithResult(_0x52c000,null))['catch'](function(_0x28b9ff){var _0x518888=_0x59ebe9['query']['test']?0x1f4:_0x28b9ff[_0x67da('0x89')]||0x1f4;logger[_0x67da('0x20')](_0x67da('0x8a'),_0x67da('0x6a'),_0x518888,JSON[_0x67da('0x8b')](_0x28b9ff));delete _0x28b9ff[_0x67da('0x32')];if(_0x518888===0x191){_0x518888=0x190;}_0x52c000[_0x67da('0x26')](_0x518888)[_0x67da('0x33')](_0x59ebe9['query'][_0x67da('0x8c')]?{'message':_0x67da('0x8d'),'statusCode':_0x28b9ff[_0x67da('0x89')]}:_0x28b9ff);});};