server/api/voicePrefix/voicePrefix.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 _0x008c=['body','VoiceExtension','VoiceExtensionId','user','UserProfileSection','VoicePrefixes','UserProfileResource','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','exten','app','description','Voice\x20Prefix\x20Extension','priority','NoOp','Voice\x20Prefix','VoicePrefixId','bulkCreate','Extensions\x20creation\x20failed','prefix','push','Set','CDR(prefix)=','callerIdAll','PREFIX-CALLERIDALL=','No\x20callerid\x20available','context','${EXTEN:','charAt','system-','findById','addAgents','ids','spread','userVoicePrefix:save','removeAgents','isArray','userVoicePrefix:remove','emit','getAgents','hasOwnProperty','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','crypto','desk.js','papaparse','ioredis','../../config/logger','api','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','register','sendStatus','status','end','json','count','offset','save','update','then','destroy','get','stack','name','index','VoicePrefix','rawAttributes','model','keys','query','filters','intersection','attributes','fields','length','nolimit','limit','order','sort','pick','where','map','type','key','VIRTUAL','field','filter','merge','options','includeAll','include','findAll','rows','catch','show','params','find','describe','create','transaction'];(function(_0x9b43f0,_0x599c75){var _0x2a9aaf=function(_0x119e18){while(--_0x119e18){_0x9b43f0['push'](_0x9b43f0['shift']());}};_0x2a9aaf(++_0x599c75);}(_0x008c,0x188));var _0xc008=function(_0x1610a9,_0x12b812){_0x1610a9=_0x1610a9-0x0;var _0x33a66e=_0x008c[_0x1610a9];return _0x33a66e;};'use strict';var pdf=require(_0xc008('0x0'));var emlformat=require(_0xc008('0x1'));var rimraf=require(_0xc008('0x2'));var zipdir=require(_0xc008('0x3'));var jsonpatch=require(_0xc008('0x4'));var rp=require('request-promise');var moment=require(_0xc008('0x5'));var BPromise=require(_0xc008('0x6'));var Mustache=require(_0xc008('0x7'));var util=require(_0xc008('0x8'));var path=require(_0xc008('0x9'));var sox=require(_0xc008('0xa'));var csv=require(_0xc008('0xb'));var ejs=require(_0xc008('0xc'));var fs=require('fs');var _=require(_0xc008('0xd'));var squel=require('squel');var crypto=require(_0xc008('0xe'));var jsforce=require('jsforce');var deskjs=require(_0xc008('0xf'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xc008('0x10'));var Redis=require(_0xc008('0x11'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var hardwareService=require('../../config/license/hardware');var logger=require(_0xc008('0x12'))(_0xc008('0x13'));var utils=require('../../config/utils');var config=require(_0xc008('0x14'));var db=require(_0xc008('0x15'))['db'];config[_0xc008('0x16')]=_[_0xc008('0x17')](config[_0xc008('0x16')],{'host':_0xc008('0x18'),'port':0x18eb});var socket=require(_0xc008('0x19'))(new Redis(config['redis']));require('./voicePrefix.socket')[_0xc008('0x1a')](socket);function respondWithStatusCode(_0x50c1ab,_0x25e13f){_0x25e13f=_0x25e13f||0xcc;return function(_0x4584e1){if(_0x4584e1){return _0x50c1ab[_0xc008('0x1b')](_0x25e13f);}return _0x50c1ab[_0xc008('0x1c')](_0x25e13f)[_0xc008('0x1d')]();};}function respondWithResult(_0x5ee00b,_0x5e894e){_0x5e894e=_0x5e894e||0xc8;return function(_0x4bd0f4){if(_0x4bd0f4){return _0x5ee00b[_0xc008('0x1c')](_0x5e894e)[_0xc008('0x1e')](_0x4bd0f4);}};}function respondWithFilteredResult(_0x3cafe3,_0x3eb12a){return function(_0x4fe771){if(_0x4fe771){var _0x53b06e=_0x4fe771[_0xc008('0x1f')],_0x540e45=_0x3eb12a['offset'],_0x5c2668=_0x3eb12a[_0xc008('0x20')]+_0x3eb12a['limit'],_0x46042b;if(_0x5c2668>=_0x53b06e){_0x5c2668=_0x53b06e;_0x46042b=0xc8;}else{_0x46042b=0xce;}_0x3cafe3['status'](_0x46042b);return _0x3cafe3['set']('Content-Range',_0x540e45+'-'+_0x5c2668+'/'+_0x53b06e)[_0xc008('0x1e')](_0x4fe771);}return null;};}function patchUpdates(_0x4b9726){return function(_0x5560b1){try{jsonpatch['apply'](_0x5560b1,_0x4b9726,!![]);}catch(_0x4a582d){return BPromise['reject'](_0x4a582d);}return _0x5560b1[_0xc008('0x21')]();};}function saveUpdates(_0x4777a6,_0x251db2){return function(_0x415af3){if(_0x415af3){return _0x415af3[_0xc008('0x22')](_0x4777a6)[_0xc008('0x23')](function(_0x4f43e2){return _0x4f43e2;});}return null;};}function removeEntity(_0x459fd9,_0x5c85f2){return function(_0x58a6ea){if(_0x58a6ea){return _0x58a6ea[_0xc008('0x24')]()[_0xc008('0x23')](function(){var _0x2e3cfb=_0x58a6ea[_0xc008('0x25')]({'plain':!![]});var _0x5410f5='VoicePrefixes';return db['UserProfileResource'][_0xc008('0x24')]({'where':{'type':_0x5410f5,'resourceId':_0x2e3cfb['id']}})[_0xc008('0x23')](function(){return _0x58a6ea;});})[_0xc008('0x23')](function(){_0x459fd9[_0xc008('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5e2aca,_0x4fce9c){return function(_0x4adbab){if(!_0x4adbab){_0x5e2aca['sendStatus'](0x194);}return _0x4adbab;};}function handleError(_0x3865c0,_0x29ba43){_0x29ba43=_0x29ba43||0x1f4;return function(_0x25eae4){logger['error'](_0x25eae4[_0xc008('0x26')]);if(_0x25eae4[_0xc008('0x27')]){delete _0x25eae4[_0xc008('0x27')];}_0x3865c0[_0xc008('0x1c')](_0x29ba43)['send'](_0x25eae4);};}exports[_0xc008('0x28')]=function(_0x2e0b4e,_0x53ed35){var _0x58db82={},_0x539766={},_0x1032b2={'count':0x0,'rows':[]};var _0x267abd=db[_0xc008('0x29')][_0xc008('0x2a')];_0x539766[_0xc008('0x2b')]=_[_0xc008('0x2c')](_0x267abd);_0x539766[_0xc008('0x2d')]=_[_0xc008('0x2c')](_0x2e0b4e[_0xc008('0x2d')]);_0x539766[_0xc008('0x2e')]=_[_0xc008('0x2f')](_0x539766[_0xc008('0x2b')],_0x539766['query']);_0x58db82[_0xc008('0x30')]=_[_0xc008('0x2f')](_0x539766['model'],qs[_0xc008('0x31')](_0x2e0b4e[_0xc008('0x2d')][_0xc008('0x31')]));_0x58db82[_0xc008('0x30')]=_0x58db82[_0xc008('0x30')][_0xc008('0x32')]?_0x58db82[_0xc008('0x30')]:_0x539766[_0xc008('0x2b')];if(!_0x2e0b4e[_0xc008('0x2d')]['hasOwnProperty'](_0xc008('0x33'))){_0x58db82[_0xc008('0x34')]=qs[_0xc008('0x34')](_0x2e0b4e[_0xc008('0x2d')][_0xc008('0x34')]);_0x58db82[_0xc008('0x20')]=qs[_0xc008('0x20')](_0x2e0b4e['query'][_0xc008('0x20')]);}_0x58db82[_0xc008('0x35')]=qs['sort'](_0x2e0b4e[_0xc008('0x2d')][_0xc008('0x36')]);_0x58db82['where']=qs[_0xc008('0x2e')](_[_0xc008('0x37')](_0x2e0b4e[_0xc008('0x2d')],_0x539766['filters']));if(_0x2e0b4e['query']['filter']){_0x58db82[_0xc008('0x38')]=_['merge'](_0x58db82[_0xc008('0x38')],{'$or':_[_0xc008('0x39')](_0x267abd,function(_0x6a4ccb){if(_0x6a4ccb[_0xc008('0x3a')][_0xc008('0x3b')]!==_0xc008('0x3c')){var _0x472994={};_0x472994[_0x6a4ccb[_0xc008('0x3d')]]={'$like':'%'+_0x2e0b4e[_0xc008('0x2d')][_0xc008('0x3e')]+'%'};return _0x472994;}})});}_0x58db82=_[_0xc008('0x3f')]({},_0x58db82,_0x2e0b4e[_0xc008('0x40')]);var _0x19c8d0={'where':_0x58db82[_0xc008('0x38')]};return db['VoicePrefix'][_0xc008('0x1f')](_0x19c8d0)[_0xc008('0x23')](function(_0x30b7df){_0x1032b2[_0xc008('0x1f')]=_0x30b7df;if(_0x2e0b4e['query'][_0xc008('0x41')]){_0x58db82[_0xc008('0x42')]=[{'all':!![]}];}return db[_0xc008('0x29')][_0xc008('0x43')](_0x58db82);})[_0xc008('0x23')](function(_0x5706bb){_0x1032b2[_0xc008('0x44')]=_0x5706bb;return _0x1032b2;})[_0xc008('0x23')](respondWithFilteredResult(_0x53ed35,_0x58db82))[_0xc008('0x45')](handleError(_0x53ed35,null));};exports[_0xc008('0x46')]=function(_0x7279e8,_0x4f93a4){var _0xf4cc4b={'raw':![],'where':{'id':_0x7279e8[_0xc008('0x47')]['id']}},_0x197854={};_0x197854[_0xc008('0x2b')]=_['keys'](db[_0xc008('0x29')][_0xc008('0x2a')]);_0x197854[_0xc008('0x2d')]=_['keys'](_0x7279e8[_0xc008('0x2d')]);_0x197854['filters']=_[_0xc008('0x2f')](_0x197854['model'],_0x197854[_0xc008('0x2d')]);_0xf4cc4b[_0xc008('0x30')]=_['intersection'](_0x197854[_0xc008('0x2b')],qs[_0xc008('0x31')](_0x7279e8[_0xc008('0x2d')]['fields']));_0xf4cc4b[_0xc008('0x30')]=_0xf4cc4b[_0xc008('0x30')][_0xc008('0x32')]?_0xf4cc4b[_0xc008('0x30')]:_0x197854[_0xc008('0x2b')];if(_0x7279e8[_0xc008('0x2d')]['includeAll']){_0xf4cc4b['include']=[{'all':!![]}];}_0xf4cc4b=_['merge']({},_0xf4cc4b,_0x7279e8[_0xc008('0x40')]);return db[_0xc008('0x29')][_0xc008('0x48')](_0xf4cc4b)[_0xc008('0x23')](handleEntityNotFound(_0x4f93a4,null))[_0xc008('0x23')](respondWithResult(_0x4f93a4,null))[_0xc008('0x45')](handleError(_0x4f93a4,null));};exports[_0xc008('0x24')]=function(_0x33be4f,_0x572593){return db['VoicePrefix']['find']({'where':{'id':_0x33be4f[_0xc008('0x47')]['id']}})[_0xc008('0x23')](handleEntityNotFound(_0x572593,null))[_0xc008('0x23')](removeEntity(_0x572593,null))['catch'](handleError(_0x572593,null));};exports[_0xc008('0x49')]=function(_0x2369c4,_0x17ab1a){return db[_0xc008('0x29')][_0xc008('0x49')]()[_0xc008('0x23')](respondWithResult(_0x17ab1a,null))[_0xc008('0x45')](handleError(_0x17ab1a,null));};exports[_0xc008('0x4a')]=function(_0x3fd7d9,_0x3965b7){var _0x52c444;return db['sequelize'][_0xc008('0x4b')](function(_0x51cb14){return db[_0xc008('0x29')][_0xc008('0x4a')](_0x3fd7d9[_0xc008('0x4c')],{'transaction':_0x51cb14})['then'](function(_0x144ab2){_0x52c444=_0x144ab2[_0xc008('0x25')]({'plain':!![]});return db[_0xc008('0x4d')][_0xc008('0x48')]({'where':{'id':_0x52c444[_0xc008('0x4e')]},'raw':!![]})['then'](function(_0x3a7b3b){return createVoicePrefixExtensions(_0x52c444,_0x3a7b3b,_0x51cb14);});});})[_0xc008('0x23')](function(){var _0x4b4c6d=_0x3fd7d9[_0xc008('0x4f')][_0xc008('0x25')]({'plain':!![]});if(!_0x4b4c6d)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4b4c6d['role']===_0xc008('0x4f')){var _0xd47b74=_0x52c444;return db[_0xc008('0x50')][_0xc008('0x48')]({'where':{'name':_0xc008('0x51'),'userProfileId':_0x4b4c6d['userProfileId']},'raw':!![]})['then'](function(_0x34b72a){if(_0x34b72a&&_0x34b72a['autoAssociation']===0x0){return db[_0xc008('0x52')][_0xc008('0x4a')]({'name':_0xd47b74[_0xc008('0x27')],'resourceId':_0xd47b74['id'],'type':_0x34b72a[_0xc008('0x27')],'sectionId':_0x34b72a['id']},{})[_0xc008('0x23')](function(){return _0x52c444;});}else{return _0x52c444;}})[_0xc008('0x45')](function(_0x49d8b0){logger[_0xc008('0x53')](_0xc008('0x54'),_0x49d8b0);throw _0x49d8b0;});}return _0x52c444;})[_0xc008('0x23')](respondWithResult(_0x3965b7,null))[_0xc008('0x45')](handleError(_0x3965b7,null));};function Extension(_0x4424f5,_0x5aa385,_0x41fae3,_0x4fdab4){this['context']='from-sip';this[_0xc008('0x55')]=_0x4424f5;this[_0xc008('0x56')]=_0x41fae3;this[_0xc008('0x3a')]='system';this[_0xc008('0x57')]=_0xc008('0x58');this[_0xc008('0x59')]=_0x5aa385;this['appdata']=_0x4fdab4;}function createVoicePrefixExtensions(_0x3587c3,_0x1092cb,_0x12ba3f){return new BPromise(function(_0x1b5a22,_0x5baff1){var _0x4022dd=new Extension(formatPrefixName(_0x3587c3['prefix']),0x1,_0xc008('0x5a'),_0xc008('0x5b'));_0x4022dd[_0xc008('0x5c')]=_0x3587c3['id'];return db[_0xc008('0x4d')][_0xc008('0x4a')](_0x4022dd,{'transaction':_0x12ba3f})[_0xc008('0x23')](function(_0x4818c7){var _0x375e71=_0x4818c7['get']({'plain':!![]});var _0x5bf4a9=_[_0xc008('0x39')](addVoicePrefixExtensions(_0x3587c3,_0x1092cb),function(_0x30aa1e){_0x30aa1e['VoiceExtensionId']=_0x375e71['id'];_0x30aa1e[_0xc008('0x5c')]=_0x3587c3['id'];return _0x30aa1e;});return db[_0xc008('0x4d')][_0xc008('0x5d')](_0x5bf4a9,{'transaction':_0x12ba3f})[_0xc008('0x23')](function(_0x21ee6d){if(!_0x21ee6d){return _0x5baff1(_0xc008('0x5e'));}else{return _0x1b5a22(_0x21ee6d);}})[_0xc008('0x45')](function(_0x57ce9a){return _0x5baff1(_0x57ce9a);});});;});};function addVoicePrefixExtensions(_0x16e052,_0x462e1e){var _0x3bfb15=[];var _0x2a60e6=formatPrefixName(_0x16e052[_0xc008('0x5f')]);_0x3bfb15[_0xc008('0x60')](new Extension(_0x2a60e6,0x2,_0xc008('0x61'),_0xc008('0x62')+_0x16e052[_0xc008('0x27')]));if(_0x16e052[_0xc008('0x63')]){_0x3bfb15[_0xc008('0x60')](new Extension(_0x2a60e6,0x3,_0xc008('0x61'),_0xc008('0x64')+_0x16e052[_0xc008('0x63')]));}else{_0x3bfb15['push'](new Extension(_0x2a60e6,0x3,_0xc008('0x5a'),_0xc008('0x65')));}_0x3bfb15[_0xc008('0x60')](new Extension(_0x2a60e6,0x4,'goto',_0x462e1e[_0xc008('0x66')]+','+_0xc008('0x67')+(0x8+_0x16e052['name']['length'])+'}'+','+0x1));return _0x3bfb15;}function formatPrefixName(_0x1a03fd){var _0x2a4c2b='_';for(var _0x7bad14=0x0;_0x7bad14<_0x1a03fd[_0xc008('0x32')];_0x7bad14++){if(_0x1a03fd[_0xc008('0x68')](_0x7bad14)=='-'){_0x2a4c2b+=_0x1a03fd[_0xc008('0x68')](_0x7bad14);}else{_0x2a4c2b+='['+_0x1a03fd[_0xc008('0x68')](_0x7bad14)+']';}}_0x2a4c2b+='.';return _0x2a4c2b;}exports[_0xc008('0x22')]=function(_0x39e219,_0x1b059b,_0x383325){var _0x490a60=_0x39e219[_0xc008('0x4c')];_0x490a60[_0xc008('0x5f')]=_0xc008('0x69')+_0x490a60[_0xc008('0x27')]+'-';return db['sequelize'][_0xc008('0x4b')](function(_0x5975de){return db[_0xc008('0x29')][_0xc008('0x22')](_0x490a60,{'where':{'id':_0x490a60['id']},'transaction':_0x5975de})[_0xc008('0x23')](function(){return db['VoiceExtension'][_0xc008('0x24')]({'where':{'VoicePrefixId':_0x490a60['id']},'transaction':_0x5975de})[_0xc008('0x23')](function(){return db[_0xc008('0x4d')]['find']({'where':{'id':_0x490a60[_0xc008('0x4e')]},'raw':!![]})['then'](function(_0x50ee03){return createVoicePrefixExtensions(_0x490a60,_0x50ee03,_0x5975de);});});});})[_0xc008('0x23')](function(){return db[_0xc008('0x29')][_0xc008('0x6a')](_0x490a60['id']);})[_0xc008('0x23')](respondWithResult(_0x1b059b,null))['catch'](handleError(_0x1b059b,null));};exports[_0xc008('0x6b')]=function(_0x3f2342,_0x49493b,_0x3efb77){return db['VoicePrefix'][_0xc008('0x48')]({'where':{'id':_0x3f2342['params']['id']}})[_0xc008('0x23')](handleEntityNotFound(_0x49493b,null))['then'](function(_0x217791){if(_0x217791){return _0x217791[_0xc008('0x6b')](_0x3f2342[_0xc008('0x4c')][_0xc008('0x6c')],_['omit'](_0x3f2342[_0xc008('0x4c')],[_0xc008('0x6c'),'id'])||{})[_0xc008('0x6d')](function(_0x1d49db){for(var _0x321500=0x0;_0x321500<_0x3f2342[_0xc008('0x4c')][_0xc008('0x6c')][_0xc008('0x32')];_0x321500+=0x1){socket['emit'](_0xc008('0x6e'),{'UserId':_0x3f2342['body']['ids'][_0x321500],'VoicePrefixId':_0x3f2342['params']['id']});}return _0x1d49db;});}})[_0xc008('0x23')](respondWithResult(_0x49493b,null))[_0xc008('0x45')](handleError(_0x49493b,null));};exports[_0xc008('0x6f')]=function(_0x233a85,_0xc2f684,_0x2e9646){return db[_0xc008('0x29')][_0xc008('0x48')]({'where':{'id':_0x233a85[_0xc008('0x47')]['id']}})['then'](handleEntityNotFound(_0xc2f684,null))[_0xc008('0x23')](function(_0x1e6055){if(_0x1e6055){return _0x1e6055[_0xc008('0x6f')](_0x233a85[_0xc008('0x2d')][_0xc008('0x6c')])[_0xc008('0x23')](function(){if(_[_0xc008('0x70')](_0x233a85[_0xc008('0x2d')][_0xc008('0x6c')])){for(var _0x41ac2a=0x0;_0x41ac2a<_0x233a85[_0xc008('0x2d')][_0xc008('0x6c')]['length'];_0x41ac2a+=0x1){socket['emit'](_0xc008('0x71'),{'UserId':Number(_0x233a85[_0xc008('0x2d')][_0xc008('0x6c')][_0x41ac2a]),'VoicePrefixId':Number(_0x233a85['params']['id'])});}}else{socket[_0xc008('0x72')](_0xc008('0x71'),{'UserId':Number(_0x233a85['query']['ids']),'VoicePrefixId':Number(_0x233a85['params']['id'])});}});}})[_0xc008('0x23')](respondWithStatusCode(_0xc2f684,null))[_0xc008('0x45')](handleError(_0xc2f684,null));};exports[_0xc008('0x73')]=function(_0x38ca14,_0x1101b8,_0x44f515){var _0x285c09={};var _0x43ba59={};var _0x1161e6;var _0x1e7a11;return db['VoicePrefix']['findOne']({'where':{'id':_0x38ca14[_0xc008('0x47')]['id']}})[_0xc008('0x23')](handleEntityNotFound(_0x1101b8,null))[_0xc008('0x23')](function(_0x3f1e41){if(_0x3f1e41){_0x1161e6=_0x3f1e41;_0x43ba59[_0xc008('0x2b')]=_[_0xc008('0x2c')](db['User']['rawAttributes']);_0x43ba59[_0xc008('0x2d')]=_[_0xc008('0x2c')](_0x38ca14[_0xc008('0x2d')]);_0x43ba59['filters']=_['intersection'](_0x43ba59['model'],_0x43ba59['query']);_0x285c09['attributes']=_['intersection'](_0x43ba59[_0xc008('0x2b')],qs['fields'](_0x38ca14[_0xc008('0x2d')]['fields']));_0x285c09[_0xc008('0x30')]=_0x285c09[_0xc008('0x30')][_0xc008('0x32')]?_0x285c09['attributes']:_0x43ba59['model'];_0x285c09[_0xc008('0x35')]=qs['sort'](_0x38ca14[_0xc008('0x2d')][_0xc008('0x36')]);_0x285c09['where']=qs[_0xc008('0x2e')](_['pick'](_0x38ca14['query'],_0x43ba59[_0xc008('0x2e')]));if(_0x38ca14[_0xc008('0x2d')]['filter']){_0x285c09[_0xc008('0x38')]=_[_0xc008('0x3f')](_0x285c09[_0xc008('0x38')],{'$or':_['map'](_0x285c09[_0xc008('0x30')],function(_0x17c1d8){var _0x1181c5={};_0x1181c5[_0x17c1d8]={'$like':'%'+_0x38ca14[_0xc008('0x2d')][_0xc008('0x3e')]+'%'};return _0x1181c5;})});}_0x285c09=_[_0xc008('0x3f')]({},_0x285c09,_0x38ca14['options']);return _0x1161e6[_0xc008('0x73')](_0x285c09);}})[_0xc008('0x23')](function(_0x2517c6){if(_0x2517c6){_0x1e7a11=_0x2517c6['length'];if(!_0x38ca14[_0xc008('0x2d')][_0xc008('0x74')](_0xc008('0x33'))){_0x285c09['limit']=qs['limit'](_0x38ca14['query'][_0xc008('0x34')]);_0x285c09[_0xc008('0x20')]=qs[_0xc008('0x20')](_0x38ca14[_0xc008('0x2d')][_0xc008('0x20')]);}return _0x1161e6[_0xc008('0x73')](_0x285c09);}})[_0xc008('0x23')](function(_0x226fa0){if(_0x226fa0){return _0x226fa0?{'count':_0x1e7a11,'rows':_0x226fa0}:null;}})['then'](respondWithResult(_0x1101b8,null))[_0xc008('0x45')](handleError(_0x1101b8,null));};