Built motion from commit 4c579f6b.|2.5.32
[motion2.git] / server / api / cmHopperFinal / cmHopperFinal.controller.js
index 62916f4..da9dee4 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x5fec=['../../config/environment','../../config/license/util','../../mysqldb','status','end','json','offset','limit','undefined','count','set','Content-Range','apply','reject','save','then','destroy','error','name','send','index','map','CmHopperFinal','rawAttributes','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','where','pick','filter','VIRTUAL','merge','include','findAll','rows','catch','show','params','includeAll','options','find','describe','body','uniqueid','sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','`state`\x20=\x203,\x201,\x20null','`state`\x20=\x205,\x201,\x20null','busyContacts','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','reCallContacts','`state`\x20=\x2019,\x201,\x20null','answeringMachine','countContactsIvrCampaignHopperFinal','noAnswerContacts','VoiceQueue','insert','scheduledAt','ContactId','ListId','createdAt','updatedAt','select','ANY_VALUE(calleridnum)','phone','field','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ANY_VALUE(VoiceQueueId)','VoiceQueueId','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','state','calleridnum\x20NOT\x20IN\x20(?)','from','cm_hopper','calleridnum','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','Campaign','fromQuery','CampaignId','ANY_VALUE(CampaignId)','calleridnum\x20IS\x20NOT\x20NULL','CampaignId\x20=\x20?','checkContactHopper','CmHopper','findOne','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils'];(function(_0x55419f,_0x5af3d3){var _0x3f050b=function(_0x2a13a5){while(--_0x2a13a5){_0x55419f['push'](_0x55419f['shift']());}};_0x3f050b(++_0x5af3d3);}(_0x5fec,0x181));var _0xc5fe=function(_0xdf30dc,_0x470d25){_0xdf30dc=_0xdf30dc-0x0;var _0x9442f1=_0x5fec[_0xdf30dc];return _0x9442f1;};'use strict';var emlformat=require(_0xc5fe('0x0'));var rimraf=require(_0xc5fe('0x1'));var zipdir=require(_0xc5fe('0x2'));var jsonpatch=require(_0xc5fe('0x3'));var rp=require(_0xc5fe('0x4'));var moment=require(_0xc5fe('0x5'));var BPromise=require(_0xc5fe('0x6'));var Mustache=require(_0xc5fe('0x7'));var util=require(_0xc5fe('0x8'));var path=require('path');var sox=require('sox');var csv=require(_0xc5fe('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xc5fe('0xa'));var _=require(_0xc5fe('0xb'));var squel=require(_0xc5fe('0xc'));var crypto=require(_0xc5fe('0xd'));var jsforce=require(_0xc5fe('0xe'));var deskjs=require(_0xc5fe('0xf'));var toCsv=require('to-csv');var querystring=require(_0xc5fe('0x10'));var Papa=require(_0xc5fe('0x11'));var Redis=require(_0xc5fe('0x12'));var authService=require(_0xc5fe('0x13'));var qs=require(_0xc5fe('0x14'));var as=require(_0xc5fe('0x15'));var hardwareService=require(_0xc5fe('0x16'));var logger=require(_0xc5fe('0x17'))(_0xc5fe('0x18'));var utils=require(_0xc5fe('0x19'));var config=require(_0xc5fe('0x1a'));var licenseUtil=require(_0xc5fe('0x1b'));var db=require(_0xc5fe('0x1c'))['db'];function respondWithStatusCode(_0x5a4f01,_0x53529b){_0x53529b=_0x53529b||0xcc;return function(_0x4af78a){if(_0x4af78a){return _0x5a4f01['sendStatus'](_0x53529b);}return _0x5a4f01[_0xc5fe('0x1d')](_0x53529b)[_0xc5fe('0x1e')]();};}function respondWithResult(_0x49901a,_0x5547ae){_0x5547ae=_0x5547ae||0xc8;return function(_0xcb608e){if(_0xcb608e){return _0x49901a['status'](_0x5547ae)[_0xc5fe('0x1f')](_0xcb608e);}};}function respondWithFilteredResult(_0x52d94b,_0x7cae9b){return function(_0xbd607a){if(_0xbd607a){var _0x3fb8a4=typeof _0x7cae9b[_0xc5fe('0x20')]==='undefined'&&typeof _0x7cae9b[_0xc5fe('0x21')]===_0xc5fe('0x22');var _0x5920a8=_0xbd607a[_0xc5fe('0x23')];var _0x110561=_0x3fb8a4?0x0:_0x7cae9b['offset'];var _0x51996d=_0x3fb8a4?_0xbd607a[_0xc5fe('0x23')]:_0x7cae9b[_0xc5fe('0x20')]+_0x7cae9b[_0xc5fe('0x21')];var _0x39d816;if(_0x51996d>=_0x5920a8){_0x51996d=_0x5920a8;_0x39d816=0xc8;}else{_0x39d816=0xce;}_0x52d94b[_0xc5fe('0x1d')](_0x39d816);return _0x52d94b[_0xc5fe('0x24')](_0xc5fe('0x25'),_0x110561+'-'+_0x51996d+'/'+_0x5920a8)['json'](_0xbd607a);}return null;};}function patchUpdates(_0x4c1fd8){return function(_0x1305fc){try{jsonpatch[_0xc5fe('0x26')](_0x1305fc,_0x4c1fd8,!![]);}catch(_0x3ac4f6){return BPromise[_0xc5fe('0x27')](_0x3ac4f6);}return _0x1305fc[_0xc5fe('0x28')]();};}function saveUpdates(_0x23083a,_0x342ec9){return function(_0x18f026){if(_0x18f026){return _0x18f026['update'](_0x23083a)[_0xc5fe('0x29')](function(_0x589769){return _0x589769;});}return null;};}function removeEntity(_0x69f76,_0x5ab005){return function(_0xf3e3a){if(_0xf3e3a){return _0xf3e3a[_0xc5fe('0x2a')]()[_0xc5fe('0x29')](function(){_0x69f76[_0xc5fe('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x59eb14,_0x3b330e){return function(_0x5de0be){if(!_0x5de0be){_0x59eb14['sendStatus'](0x194);}return _0x5de0be;};}function handleError(_0x13ebd6,_0x28260f){_0x28260f=_0x28260f||0x1f4;return function(_0x5d2f0b){logger[_0xc5fe('0x2b')](_0x5d2f0b['stack']);if(_0x5d2f0b[_0xc5fe('0x2c')]){delete _0x5d2f0b[_0xc5fe('0x2c')];}_0x13ebd6[_0xc5fe('0x1d')](_0x28260f)[_0xc5fe('0x2d')](_0x5d2f0b);};}exports[_0xc5fe('0x2e')]=function(_0x5f2db6,_0x1e6ce9){var _0x4d38b7={},_0x5b9f6a={},_0x2e320c={'count':0x0,'rows':[]};var _0x55d726=_[_0xc5fe('0x2f')](db[_0xc5fe('0x30')][_0xc5fe('0x31')],function(_0x368a85){return{'name':_0x368a85['fieldName'],'type':_0x368a85[_0xc5fe('0x32')][_0xc5fe('0x33')]};});_0x5b9f6a[_0xc5fe('0x34')]=_[_0xc5fe('0x2f')](_0x55d726,'name');_0x5b9f6a['query']=_[_0xc5fe('0x35')](_0x5f2db6[_0xc5fe('0x36')]);_0x5b9f6a[_0xc5fe('0x37')]=_[_0xc5fe('0x38')](_0x5b9f6a[_0xc5fe('0x34')],_0x5b9f6a[_0xc5fe('0x36')]);_0x4d38b7[_0xc5fe('0x39')]=_[_0xc5fe('0x38')](_0x5b9f6a[_0xc5fe('0x34')],qs[_0xc5fe('0x3a')](_0x5f2db6['query'][_0xc5fe('0x3a')]));_0x4d38b7[_0xc5fe('0x39')]=_0x4d38b7[_0xc5fe('0x39')][_0xc5fe('0x3b')]?_0x4d38b7['attributes']:_0x5b9f6a[_0xc5fe('0x34')];if(!_0x5f2db6[_0xc5fe('0x36')][_0xc5fe('0x3c')](_0xc5fe('0x3d'))){_0x4d38b7[_0xc5fe('0x21')]=qs['limit'](_0x5f2db6[_0xc5fe('0x36')][_0xc5fe('0x21')]);_0x4d38b7[_0xc5fe('0x20')]=qs[_0xc5fe('0x20')](_0x5f2db6[_0xc5fe('0x36')][_0xc5fe('0x20')]);}_0x4d38b7[_0xc5fe('0x3e')]=qs['sort'](_0x5f2db6[_0xc5fe('0x36')]['sort']);_0x4d38b7[_0xc5fe('0x3f')]=qs[_0xc5fe('0x37')](_[_0xc5fe('0x40')](_0x5f2db6['query'],_0x5b9f6a[_0xc5fe('0x37')]),_0x55d726);if(_0x5f2db6[_0xc5fe('0x36')][_0xc5fe('0x41')]){_0x4d38b7['where']=_['merge'](_0x4d38b7[_0xc5fe('0x3f')],{'$or':_[_0xc5fe('0x2f')](_0x55d726,function(_0x37ad67){if(_0x37ad67[_0xc5fe('0x32')]!==_0xc5fe('0x42')){var _0x437037={};_0x437037[_0x37ad67[_0xc5fe('0x2c')]]={'$like':'%'+_0x5f2db6[_0xc5fe('0x36')][_0xc5fe('0x41')]+'%'};return _0x437037;}})});}_0x4d38b7=_[_0xc5fe('0x43')]({},_0x4d38b7,_0x5f2db6['options']);var _0x527775={'where':_0x4d38b7[_0xc5fe('0x3f')]};return db[_0xc5fe('0x30')][_0xc5fe('0x23')](_0x527775)[_0xc5fe('0x29')](function(_0x2dba8d){_0x2e320c[_0xc5fe('0x23')]=_0x2dba8d;if(_0x5f2db6[_0xc5fe('0x36')]['includeAll']){_0x4d38b7[_0xc5fe('0x44')]=[{'all':!![]}];}return db[_0xc5fe('0x30')][_0xc5fe('0x45')](_0x4d38b7);})[_0xc5fe('0x29')](function(_0x1b8d80){_0x2e320c[_0xc5fe('0x46')]=_0x1b8d80;return _0x2e320c;})['then'](respondWithFilteredResult(_0x1e6ce9,_0x4d38b7))[_0xc5fe('0x47')](handleError(_0x1e6ce9,null));};exports[_0xc5fe('0x48')]=function(_0x3b22a2,_0x1cfd03){var _0x54ba08={'raw':!![],'where':{'id':_0x3b22a2[_0xc5fe('0x49')]['id']}},_0xb53f15={};_0xb53f15[_0xc5fe('0x34')]=_[_0xc5fe('0x35')](db[_0xc5fe('0x30')][_0xc5fe('0x31')]);_0xb53f15[_0xc5fe('0x36')]=_[_0xc5fe('0x35')](_0x3b22a2['query']);_0xb53f15[_0xc5fe('0x37')]=_[_0xc5fe('0x38')](_0xb53f15[_0xc5fe('0x34')],_0xb53f15['query']);_0x54ba08[_0xc5fe('0x39')]=_['intersection'](_0xb53f15['model'],qs[_0xc5fe('0x3a')](_0x3b22a2['query']['fields']));_0x54ba08['attributes']=_0x54ba08['attributes'][_0xc5fe('0x3b')]?_0x54ba08[_0xc5fe('0x39')]:_0xb53f15[_0xc5fe('0x34')];if(_0x3b22a2['query'][_0xc5fe('0x4a')]){_0x54ba08[_0xc5fe('0x44')]=[{'all':!![]}];}_0x54ba08=_[_0xc5fe('0x43')]({},_0x54ba08,_0x3b22a2[_0xc5fe('0x4b')]);return db[_0xc5fe('0x30')][_0xc5fe('0x4c')](_0x54ba08)[_0xc5fe('0x29')](handleEntityNotFound(_0x1cfd03,null))['then'](respondWithResult(_0x1cfd03,null))[_0xc5fe('0x47')](handleError(_0x1cfd03,null));};exports[_0xc5fe('0x4d')]=function(_0x5e1465,_0x3fae4c){return db['CmHopperFinal']['describe']()[_0xc5fe('0x29')](respondWithResult(_0x3fae4c,null))[_0xc5fe('0x47')](handleError(_0x3fae4c,null));};exports['update']=function(_0x8ef031,_0x58c7de){if(_0x8ef031[_0xc5fe('0x4e')]['uniqueid']){delete _0x8ef031[_0xc5fe('0x4e')][_0xc5fe('0x4f')];}return db[_0xc5fe('0x30')]['find']({'where':{'uniqueid':_0x8ef031['params']['id']}})[_0xc5fe('0x29')](handleEntityNotFound(_0x58c7de,null))[_0xc5fe('0x29')](saveUpdates(_0x8ef031[_0xc5fe('0x4e')],null))[_0xc5fe('0x29')](respondWithResult(_0x58c7de,null))[_0xc5fe('0x47')](handleError(_0x58c7de,null));};exports['countContactsQueueCampaignHopperFinal']=function(_0x7fe910,_0x53ae4f,_0x5ce2c4){return db[_0xc5fe('0x30')][_0xc5fe('0x45')]({'raw':![],'where':{'VoiceQueueId':_0x7fe910[_0xc5fe('0x49')]['id']},'attributes':[[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x53')))),_0xc5fe('0x54')],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db['sequelize']['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x55')))),'noAnswerContacts'],[db['sequelize']['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x56')))),_0xc5fe('0x57')],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x58')))),_0xc5fe('0x59')],[db['sequelize']['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db['sequelize'][_0xc5fe('0x52')](_0xc5fe('0x5a')))),_0xc5fe('0x5b')],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db['sequelize']['fn']('IF',db['sequelize'][_0xc5fe('0x52')](_0xc5fe('0x5c')))),_0xc5fe('0x5d')],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x5e')))),_0xc5fe('0x5f')],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')]['literal'](_0xc5fe('0x60')))),_0xc5fe('0x61')]]})[_0xc5fe('0x29')](handleEntityNotFound(_0x53ae4f,null))[_0xc5fe('0x29')](respondWithResult(_0x53ae4f,null))['catch'](handleError(_0x53ae4f,null));};exports[_0xc5fe('0x62')]=function(_0x53859b,_0x1fa9ea,_0x53ac60){return db[_0xc5fe('0x30')]['findAll']({'raw':![],'where':{'CampaignId':_0x53859b[_0xc5fe('0x49')]['id']},'attributes':[[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')]['literal']('`state`\x20=\x200,\x201,\x20null'))),'noSuchContacts'],[db['sequelize']['fn']('COUNT',db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')]['literal'](_0xc5fe('0x55')))),_0xc5fe('0x63')],[db['sequelize']['fn']('COUNT',db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x56')))),'busyContacts'],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db['sequelize']['fn']('IF',db['sequelize']['literal'](_0xc5fe('0x58')))),_0xc5fe('0x59')],[db[_0xc5fe('0x50')]['fn']('COUNT',db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x5a')))),'dropContacts'],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')]['literal']('`state`\x20=\x2011\x20,\x201,\x20null'))),_0xc5fe('0x5d')],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x5e')))),'reCallContacts'],[db[_0xc5fe('0x50')]['fn'](_0xc5fe('0x51'),db[_0xc5fe('0x50')]['fn']('IF',db[_0xc5fe('0x50')][_0xc5fe('0x52')](_0xc5fe('0x60')))),_0xc5fe('0x61')]]})[_0xc5fe('0x29')](handleEntityNotFound(_0x1fa9ea,null))[_0xc5fe('0x29')](respondWithResult(_0x1fa9ea,null))[_0xc5fe('0x47')](handleError(_0x1fa9ea,null));};exports['moveContactsQueueCampaignHopperFinal']=function(_0x3e7055,_0x18d8d8,_0x13f431){return db[_0xc5fe('0x64')]['find']({'where':{'id':_0x3e7055[_0xc5fe('0x49')]['id']}})[_0xc5fe('0x29')](handleEntityNotFound(_0x18d8d8,null))['then'](function(_0x14b934){var _0x18762a;if(_0x14b934){_0x18762a=squel[_0xc5fe('0x65')]()['into']('cm_hopper')['fromQuery'](['phone',_0xc5fe('0x66'),_0xc5fe('0x67'),_0xc5fe('0x68'),'VoiceQueueId',_0xc5fe('0x69'),_0xc5fe('0x6a')],squel[_0xc5fe('0x6b')]()['field'](_0xc5fe('0x6c'),_0xc5fe('0x6d'))[_0xc5fe('0x6e')](_0xc5fe('0x6f'),'scheduledAt')[_0xc5fe('0x6e')](_0xc5fe('0x70'),_0xc5fe('0x67'))[_0xc5fe('0x6e')](_0xc5fe('0x71'),_0xc5fe('0x68'))['field'](_0xc5fe('0x72'),_0xc5fe('0x73'))['field']('NOW()','createdAt')[_0xc5fe('0x6e')](_0xc5fe('0x6f'),_0xc5fe('0x6a'))['from'](_0xc5fe('0x74'))[_0xc5fe('0x3f')](_0xc5fe('0x75'),_0x3e7055[_0xc5fe('0x49')]['id'][_0xc5fe('0x76')]())[_0xc5fe('0x3f')](_0xc5fe('0x77'),_0x3e7055[_0xc5fe('0x4e')][_0xc5fe('0x78')]['toString']())[_0xc5fe('0x3f')]('calleridnum\x20IS\x20NOT\x20NULL')[_0xc5fe('0x3f')](_0xc5fe('0x79'),squel['select']()[_0xc5fe('0x6e')]('phone')[_0xc5fe('0x7a')](_0xc5fe('0x7b'))['where'](_0xc5fe('0x75'),_0x3e7055[_0xc5fe('0x49')]['id'][_0xc5fe('0x76')]()))[_0xc5fe('0x3f')](_0xc5fe('0x79'),squel[_0xc5fe('0x6b')]()[_0xc5fe('0x6e')](_0xc5fe('0x7c'))['from'](_0xc5fe('0x74'))[_0xc5fe('0x3f')](_0xc5fe('0x75'),_0x3e7055[_0xc5fe('0x49')]['id'][_0xc5fe('0x76')]())['where'](_0xc5fe('0x7d')))[_0xc5fe('0x7e')](_0xc5fe('0x67')))[_0xc5fe('0x76')]();return db[_0xc5fe('0x50')][_0xc5fe('0x36')](_0x18762a);}return[];})[_0xc5fe('0x29')](respondWithResult(_0x18d8d8,null))[_0xc5fe('0x47')](handleError(_0x18d8d8,null));};exports[_0xc5fe('0x7f')]=function(_0x62a06e,_0x46ac93,_0x54fd9e){return db[_0xc5fe('0x80')][_0xc5fe('0x4c')]({'where':{'id':_0x62a06e[_0xc5fe('0x49')]['id']}})['then'](handleEntityNotFound(_0x46ac93,null))[_0xc5fe('0x29')](function(_0x3b8aac){var _0x40d229;if(_0x3b8aac){_0x40d229=squel[_0xc5fe('0x65')]()['into']('cm_hopper')[_0xc5fe('0x81')]([_0xc5fe('0x6d'),_0xc5fe('0x66'),_0xc5fe('0x67'),_0xc5fe('0x68'),_0xc5fe('0x82'),_0xc5fe('0x69'),'updatedAt'],squel[_0xc5fe('0x6b')]()[_0xc5fe('0x6e')](_0xc5fe('0x6c'),_0xc5fe('0x6d'))['field'](_0xc5fe('0x6f'),'scheduledAt')[_0xc5fe('0x6e')](_0xc5fe('0x70'),_0xc5fe('0x67'))[_0xc5fe('0x6e')](_0xc5fe('0x71'),'ListId')[_0xc5fe('0x6e')](_0xc5fe('0x83'),'CampaignId')[_0xc5fe('0x6e')](_0xc5fe('0x6f'),'createdAt')[_0xc5fe('0x6e')](_0xc5fe('0x6f'),_0xc5fe('0x6a'))[_0xc5fe('0x7a')]('cm_hopper_final')[_0xc5fe('0x3f')]('CampaignId\x20=\x20?',_0x62a06e['params']['id'][_0xc5fe('0x76')]())[_0xc5fe('0x3f')](_0xc5fe('0x77'),_0x62a06e[_0xc5fe('0x4e')][_0xc5fe('0x78')][_0xc5fe('0x76')]())[_0xc5fe('0x3f')](_0xc5fe('0x84'))[_0xc5fe('0x3f')](_0xc5fe('0x79'),squel[_0xc5fe('0x6b')]()[_0xc5fe('0x6e')]('phone')[_0xc5fe('0x7a')](_0xc5fe('0x7b'))['where'](_0xc5fe('0x85'),_0x62a06e[_0xc5fe('0x49')]['id'][_0xc5fe('0x76')]()))[_0xc5fe('0x3f')](_0xc5fe('0x79'),squel[_0xc5fe('0x6b')]()[_0xc5fe('0x6e')](_0xc5fe('0x7c'))[_0xc5fe('0x7a')](_0xc5fe('0x74'))[_0xc5fe('0x3f')](_0xc5fe('0x85'),_0x62a06e['params']['id'][_0xc5fe('0x76')]())[_0xc5fe('0x3f')](_0xc5fe('0x7d')))[_0xc5fe('0x7e')](_0xc5fe('0x67')))[_0xc5fe('0x76')]();return db[_0xc5fe('0x50')]['query'](_0x40d229);}return[];})[_0xc5fe('0x29')](respondWithResult(_0x46ac93,null))[_0xc5fe('0x47')](handleError(_0x46ac93,null));};exports[_0xc5fe('0x86')]=function(_0x2488ea,_0x3b4743,_0x40d330){return db[_0xc5fe('0x87')][_0xc5fe('0x88')]({'where':{'VoiceQueueId':_0x2488ea[_0xc5fe('0x4e')][_0xc5fe('0x73')],'CampaignId':_0x2488ea[_0xc5fe('0x4e')][_0xc5fe('0x82')],'ContactId':_0x2488ea[_0xc5fe('0x4e')][_0xc5fe('0x67')]}})['then'](handleEntityNotFound(_0x3b4743,null))[_0xc5fe('0x29')](function(_0x2cbfbb){if(_0x2cbfbb){return _0x2cbfbb;}return null;})[_0xc5fe('0x29')](respondWithResult(_0x3b4743,null))['catch'](handleError(_0x3b4743,null));};
\ No newline at end of file
+var _0x4c60=['include','findAll','rows','catch','show','includeAll','find','describe','update','uniqueid','body','params','countContactsQueueCampaignHopperFinal','sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','busyContacts','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','reCallContacts','`state`\x20=\x2019,\x201,\x20null','countContactsIvrCampaignHopperFinal','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','answeringMachine','VoiceQueue','into','cm_hopper','phone','scheduledAt','ContactId','ListId','VoiceQueueId','createdAt','updatedAt','select','field','ANY_VALUE(calleridnum)','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ANY_VALUE(VoiceQueueId)','from','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state','calleridnum\x20NOT\x20IN\x20(?)','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','insert','fromQuery','CampaignId','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','calleridnum\x20IS\x20NOT\x20NULL','calleridnum','CmHopper','findOne','eml-format','rimraf','zip-dir','fast-json-patch','moment','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','Content-Range','apply','reject','then','destroy','end','error','stack','name','index','map','CmHopperFinal','rawAttributes','key','keys','query','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','VIRTUAL','merge','options'];(function(_0x3096fd,_0x541ccd){var _0x159725=function(_0x4815b0){while(--_0x4815b0){_0x3096fd['push'](_0x3096fd['shift']());}};_0x159725(++_0x541ccd);}(_0x4c60,0xc1));var _0x04c6=function(_0x2f136b,_0xb7d793){_0x2f136b=_0x2f136b-0x0;var _0x427929=_0x4c60[_0x2f136b];return _0x427929;};'use strict';var emlformat=require(_0x04c6('0x0'));var rimraf=require(_0x04c6('0x1'));var zipdir=require(_0x04c6('0x2'));var jsonpatch=require(_0x04c6('0x3'));var rp=require('request-promise');var moment=require(_0x04c6('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require('path');var sox=require(_0x04c6('0x5'));var csv=require(_0x04c6('0x6'));var ejs=require(_0x04c6('0x7'));var fs=require('fs');var fs_extra=require(_0x04c6('0x8'));var _=require(_0x04c6('0x9'));var squel=require(_0x04c6('0xa'));var crypto=require(_0x04c6('0xb'));var jsforce=require('jsforce');var deskjs=require(_0x04c6('0xc'));var toCsv=require(_0x04c6('0x6'));var querystring=require(_0x04c6('0xd'));var Papa=require(_0x04c6('0xe'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x04c6('0xf'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x04c6('0x10'))(_0x04c6('0x11'));var utils=require('../../config/utils');var config=require(_0x04c6('0x12'));var licenseUtil=require(_0x04c6('0x13'));var db=require(_0x04c6('0x14'))['db'];function respondWithStatusCode(_0x4e5e6,_0x52cdcf){_0x52cdcf=_0x52cdcf||0xcc;return function(_0x257a0a){if(_0x257a0a){return _0x4e5e6[_0x04c6('0x15')](_0x52cdcf);}return _0x4e5e6[_0x04c6('0x16')](_0x52cdcf)['end']();};}function respondWithResult(_0x12d1c5,_0x15cbe0){_0x15cbe0=_0x15cbe0||0xc8;return function(_0x28632e){if(_0x28632e){return _0x12d1c5[_0x04c6('0x16')](_0x15cbe0)[_0x04c6('0x17')](_0x28632e);}};}function respondWithFilteredResult(_0x19a26f,_0x1cd963){return function(_0x3d46a9){if(_0x3d46a9){var _0x5a5a66=typeof _0x1cd963[_0x04c6('0x18')]===_0x04c6('0x19')&&typeof _0x1cd963[_0x04c6('0x1a')]===_0x04c6('0x19');var _0x43596a=_0x3d46a9[_0x04c6('0x1b')];var _0x21674a=_0x5a5a66?0x0:_0x1cd963[_0x04c6('0x18')];var _0x47f400=_0x5a5a66?_0x3d46a9[_0x04c6('0x1b')]:_0x1cd963[_0x04c6('0x18')]+_0x1cd963[_0x04c6('0x1a')];var _0x558b43;if(_0x47f400>=_0x43596a){_0x47f400=_0x43596a;_0x558b43=0xc8;}else{_0x558b43=0xce;}_0x19a26f['status'](_0x558b43);return _0x19a26f['set'](_0x04c6('0x1c'),_0x21674a+'-'+_0x47f400+'/'+_0x43596a)[_0x04c6('0x17')](_0x3d46a9);}return null;};}function patchUpdates(_0x50dd61){return function(_0x5a5e9e){try{jsonpatch[_0x04c6('0x1d')](_0x5a5e9e,_0x50dd61,!![]);}catch(_0x2eed94){return BPromise[_0x04c6('0x1e')](_0x2eed94);}return _0x5a5e9e['save']();};}function saveUpdates(_0x33a0f7,_0x13f2dc){return function(_0x9d41f8){if(_0x9d41f8){return _0x9d41f8['update'](_0x33a0f7)[_0x04c6('0x1f')](function(_0x41e29f){return _0x41e29f;});}return null;};}function removeEntity(_0x562491,_0x54a8b0){return function(_0x4c8d72){if(_0x4c8d72){return _0x4c8d72[_0x04c6('0x20')]()[_0x04c6('0x1f')](function(){_0x562491[_0x04c6('0x16')](0xcc)[_0x04c6('0x21')]();});}};}function handleEntityNotFound(_0x3e1328,_0x52e5f5){return function(_0x562952){if(!_0x562952){_0x3e1328[_0x04c6('0x15')](0x194);}return _0x562952;};}function handleError(_0x2ab1d2,_0x9acfa){_0x9acfa=_0x9acfa||0x1f4;return function(_0x3233d7){logger[_0x04c6('0x22')](_0x3233d7[_0x04c6('0x23')]);if(_0x3233d7['name']){delete _0x3233d7[_0x04c6('0x24')];}_0x2ab1d2[_0x04c6('0x16')](_0x9acfa)['send'](_0x3233d7);};}exports[_0x04c6('0x25')]=function(_0x1cd16a,_0x5f1331){var _0x5c9003={},_0x115d84={},_0x3a6d92={'count':0x0,'rows':[]};var _0x2a191f=_[_0x04c6('0x26')](db[_0x04c6('0x27')][_0x04c6('0x28')],function(_0x49c4ed){return{'name':_0x49c4ed['fieldName'],'type':_0x49c4ed['type'][_0x04c6('0x29')]};});_0x115d84['model']=_[_0x04c6('0x26')](_0x2a191f,_0x04c6('0x24'));_0x115d84['query']=_[_0x04c6('0x2a')](_0x1cd16a[_0x04c6('0x2b')]);_0x115d84[_0x04c6('0x2c')]=_[_0x04c6('0x2d')](_0x115d84['model'],_0x115d84[_0x04c6('0x2b')]);_0x5c9003[_0x04c6('0x2e')]=_[_0x04c6('0x2d')](_0x115d84[_0x04c6('0x2f')],qs[_0x04c6('0x30')](_0x1cd16a[_0x04c6('0x2b')][_0x04c6('0x30')]));_0x5c9003[_0x04c6('0x2e')]=_0x5c9003[_0x04c6('0x2e')][_0x04c6('0x31')]?_0x5c9003[_0x04c6('0x2e')]:_0x115d84[_0x04c6('0x2f')];if(!_0x1cd16a[_0x04c6('0x2b')][_0x04c6('0x32')](_0x04c6('0x33'))){_0x5c9003['limit']=qs[_0x04c6('0x1a')](_0x1cd16a[_0x04c6('0x2b')][_0x04c6('0x1a')]);_0x5c9003[_0x04c6('0x18')]=qs['offset'](_0x1cd16a[_0x04c6('0x2b')][_0x04c6('0x18')]);}_0x5c9003['order']=qs['sort'](_0x1cd16a['query'][_0x04c6('0x34')]);_0x5c9003[_0x04c6('0x35')]=qs['filters'](_[_0x04c6('0x36')](_0x1cd16a['query'],_0x115d84[_0x04c6('0x2c')]),_0x2a191f);if(_0x1cd16a[_0x04c6('0x2b')][_0x04c6('0x37')]){_0x5c9003[_0x04c6('0x35')]=_['merge'](_0x5c9003['where'],{'$or':_[_0x04c6('0x26')](_0x2a191f,function(_0x3a9a3b){if(_0x3a9a3b['type']!==_0x04c6('0x38')){var _0x5ce4b0={};_0x5ce4b0[_0x3a9a3b['name']]={'$like':'%'+_0x1cd16a[_0x04c6('0x2b')]['filter']+'%'};return _0x5ce4b0;}})});}_0x5c9003=_[_0x04c6('0x39')]({},_0x5c9003,_0x1cd16a[_0x04c6('0x3a')]);var _0x59ca18={'where':_0x5c9003[_0x04c6('0x35')]};return db['CmHopperFinal'][_0x04c6('0x1b')](_0x59ca18)[_0x04c6('0x1f')](function(_0x2d83eb){_0x3a6d92[_0x04c6('0x1b')]=_0x2d83eb;if(_0x1cd16a[_0x04c6('0x2b')]['includeAll']){_0x5c9003[_0x04c6('0x3b')]=[{'all':!![]}];}return db['CmHopperFinal'][_0x04c6('0x3c')](_0x5c9003);})['then'](function(_0x1f7ead){_0x3a6d92[_0x04c6('0x3d')]=_0x1f7ead;return _0x3a6d92;})[_0x04c6('0x1f')](respondWithFilteredResult(_0x5f1331,_0x5c9003))[_0x04c6('0x3e')](handleError(_0x5f1331,null));};exports[_0x04c6('0x3f')]=function(_0x2cdf34,_0x40477f){var _0x4a3c45={'raw':!![],'where':{'id':_0x2cdf34['params']['id']}},_0xdfdc34={};_0xdfdc34[_0x04c6('0x2f')]=_['keys'](db['CmHopperFinal'][_0x04c6('0x28')]);_0xdfdc34['query']=_[_0x04c6('0x2a')](_0x2cdf34[_0x04c6('0x2b')]);_0xdfdc34[_0x04c6('0x2c')]=_['intersection'](_0xdfdc34[_0x04c6('0x2f')],_0xdfdc34[_0x04c6('0x2b')]);_0x4a3c45[_0x04c6('0x2e')]=_[_0x04c6('0x2d')](_0xdfdc34[_0x04c6('0x2f')],qs[_0x04c6('0x30')](_0x2cdf34[_0x04c6('0x2b')]['fields']));_0x4a3c45['attributes']=_0x4a3c45[_0x04c6('0x2e')][_0x04c6('0x31')]?_0x4a3c45[_0x04c6('0x2e')]:_0xdfdc34['model'];if(_0x2cdf34[_0x04c6('0x2b')][_0x04c6('0x40')]){_0x4a3c45[_0x04c6('0x3b')]=[{'all':!![]}];}_0x4a3c45=_['merge']({},_0x4a3c45,_0x2cdf34['options']);return db['CmHopperFinal'][_0x04c6('0x41')](_0x4a3c45)[_0x04c6('0x1f')](handleEntityNotFound(_0x40477f,null))['then'](respondWithResult(_0x40477f,null))[_0x04c6('0x3e')](handleError(_0x40477f,null));};exports[_0x04c6('0x42')]=function(_0x2bd045,_0x4ef366){return db[_0x04c6('0x27')][_0x04c6('0x42')]()['then'](respondWithResult(_0x4ef366,null))[_0x04c6('0x3e')](handleError(_0x4ef366,null));};exports[_0x04c6('0x43')]=function(_0x2472ed,_0xee2822){if(_0x2472ed['body'][_0x04c6('0x44')]){delete _0x2472ed[_0x04c6('0x45')][_0x04c6('0x44')];}return db[_0x04c6('0x27')]['find']({'where':{'uniqueid':_0x2472ed[_0x04c6('0x46')]['id']}})[_0x04c6('0x1f')](handleEntityNotFound(_0xee2822,null))[_0x04c6('0x1f')](saveUpdates(_0x2472ed[_0x04c6('0x45')],null))['then'](respondWithResult(_0xee2822,null))[_0x04c6('0x3e')](handleError(_0xee2822,null));};exports[_0x04c6('0x47')]=function(_0x15ec61,_0x489361,_0x3119f0){return db[_0x04c6('0x27')][_0x04c6('0x3c')]({'raw':![],'where':{'VoiceQueueId':_0x15ec61[_0x04c6('0x46')]['id']},'attributes':[[db[_0x04c6('0x48')]['fn'](_0x04c6('0x49'),db[_0x04c6('0x48')]['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x4b')))),_0x04c6('0x4c')],[db[_0x04c6('0x48')]['fn'](_0x04c6('0x49'),db['sequelize']['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x4d')))),_0x04c6('0x4e')],[db[_0x04c6('0x48')]['fn']('COUNT',db[_0x04c6('0x48')]['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x4f')))),_0x04c6('0x50')],[db[_0x04c6('0x48')]['fn'](_0x04c6('0x49'),db[_0x04c6('0x48')]['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')]('`state`\x20=\x208,\x201,\x20null'))),'congestionContacts'],[db['sequelize']['fn']('COUNT',db[_0x04c6('0x48')]['fn']('IF',db['sequelize'][_0x04c6('0x4a')]('`state`\x20=\x2010\x20,\x201,\x20null'))),_0x04c6('0x51')],[db[_0x04c6('0x48')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x52')))),_0x04c6('0x53')],[db['sequelize']['fn'](_0x04c6('0x49'),db[_0x04c6('0x48')]['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x54')))),_0x04c6('0x55')],[db[_0x04c6('0x48')]['fn']('COUNT',db[_0x04c6('0x48')]['fn']('IF',db['sequelize'][_0x04c6('0x4a')](_0x04c6('0x56')))),'answeringMachine']]})[_0x04c6('0x1f')](handleEntityNotFound(_0x489361,null))[_0x04c6('0x1f')](respondWithResult(_0x489361,null))[_0x04c6('0x3e')](handleError(_0x489361,null));};exports[_0x04c6('0x57')]=function(_0x28299e,_0x5b536f,_0xf073a8){return db[_0x04c6('0x27')]['findAll']({'raw':![],'where':{'CampaignId':_0x28299e[_0x04c6('0x46')]['id']},'attributes':[[db['sequelize']['fn'](_0x04c6('0x49'),db[_0x04c6('0x48')]['fn']('IF',db['sequelize']['literal'](_0x04c6('0x4b')))),'noSuchContacts'],[db[_0x04c6('0x48')]['fn'](_0x04c6('0x49'),db['sequelize']['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x4d')))),_0x04c6('0x4e')],[db[_0x04c6('0x48')]['fn'](_0x04c6('0x49'),db[_0x04c6('0x48')]['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x4f')))),_0x04c6('0x50')],[db['sequelize']['fn'](_0x04c6('0x49'),db[_0x04c6('0x48')]['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')]('`state`\x20=\x208,\x201,\x20null'))),_0x04c6('0x58')],[db[_0x04c6('0x48')]['fn'](_0x04c6('0x49'),db['sequelize']['fn']('IF',db['sequelize'][_0x04c6('0x4a')](_0x04c6('0x59')))),_0x04c6('0x51')],[db[_0x04c6('0x48')]['fn'](_0x04c6('0x49'),db[_0x04c6('0x48')]['fn']('IF',db['sequelize'][_0x04c6('0x4a')](_0x04c6('0x52')))),_0x04c6('0x53')],[db['sequelize']['fn']('COUNT',db[_0x04c6('0x48')]['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x54')))),'reCallContacts'],[db[_0x04c6('0x48')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0x04c6('0x48')][_0x04c6('0x4a')](_0x04c6('0x56')))),_0x04c6('0x5a')]]})[_0x04c6('0x1f')](handleEntityNotFound(_0x5b536f,null))[_0x04c6('0x1f')](respondWithResult(_0x5b536f,null))[_0x04c6('0x3e')](handleError(_0x5b536f,null));};exports['moveContactsQueueCampaignHopperFinal']=function(_0x31cc93,_0x1b6242,_0x1f5b9a){return db[_0x04c6('0x5b')][_0x04c6('0x41')]({'where':{'id':_0x31cc93['params']['id']}})['then'](handleEntityNotFound(_0x1b6242,null))[_0x04c6('0x1f')](function(_0x598941){var _0x2df63b;if(_0x598941){_0x2df63b=squel['insert']()[_0x04c6('0x5c')](_0x04c6('0x5d'))['fromQuery']([_0x04c6('0x5e'),_0x04c6('0x5f'),_0x04c6('0x60'),_0x04c6('0x61'),_0x04c6('0x62'),_0x04c6('0x63'),_0x04c6('0x64')],squel[_0x04c6('0x65')]()[_0x04c6('0x66')](_0x04c6('0x67'),_0x04c6('0x5e'))[_0x04c6('0x66')](_0x04c6('0x68'),'scheduledAt')[_0x04c6('0x66')](_0x04c6('0x69'),'ContactId')[_0x04c6('0x66')](_0x04c6('0x6a'),_0x04c6('0x61'))[_0x04c6('0x66')](_0x04c6('0x6b'),'VoiceQueueId')[_0x04c6('0x66')]('NOW()',_0x04c6('0x63'))['field'](_0x04c6('0x68'),_0x04c6('0x64'))[_0x04c6('0x6c')](_0x04c6('0x6d'))[_0x04c6('0x35')](_0x04c6('0x6e'),_0x31cc93[_0x04c6('0x46')]['id'][_0x04c6('0x6f')]())[_0x04c6('0x35')]('state\x20=\x20?',_0x31cc93[_0x04c6('0x45')][_0x04c6('0x70')]['toString']())[_0x04c6('0x35')]('calleridnum\x20IS\x20NOT\x20NULL')[_0x04c6('0x35')](_0x04c6('0x71'),squel['select']()[_0x04c6('0x66')](_0x04c6('0x5e'))['from'](_0x04c6('0x5d'))[_0x04c6('0x35')]('VoiceQueueId\x20=\x20?',_0x31cc93[_0x04c6('0x46')]['id'][_0x04c6('0x6f')]()))['where'](_0x04c6('0x71'),squel[_0x04c6('0x65')]()['field']('calleridnum')['from'](_0x04c6('0x6d'))[_0x04c6('0x35')](_0x04c6('0x6e'),_0x31cc93[_0x04c6('0x46')]['id'][_0x04c6('0x6f')]())['where'](_0x04c6('0x72')))[_0x04c6('0x73')](_0x04c6('0x60')))[_0x04c6('0x6f')]();return db[_0x04c6('0x48')][_0x04c6('0x2b')](_0x2df63b);}return[];})[_0x04c6('0x1f')](respondWithResult(_0x1b6242,null))['catch'](handleError(_0x1b6242,null));};exports[_0x04c6('0x74')]=function(_0x4f258c,_0x202761,_0x480c74){return db['Campaign'][_0x04c6('0x41')]({'where':{'id':_0x4f258c['params']['id']}})[_0x04c6('0x1f')](handleEntityNotFound(_0x202761,null))[_0x04c6('0x1f')](function(_0x174de6){var _0x425d01;if(_0x174de6){_0x425d01=squel[_0x04c6('0x75')]()['into']('cm_hopper')[_0x04c6('0x76')]([_0x04c6('0x5e'),_0x04c6('0x5f'),_0x04c6('0x60'),_0x04c6('0x61'),_0x04c6('0x77'),'createdAt',_0x04c6('0x64')],squel['select']()['field'](_0x04c6('0x67'),_0x04c6('0x5e'))[_0x04c6('0x66')](_0x04c6('0x68'),_0x04c6('0x5f'))[_0x04c6('0x66')](_0x04c6('0x69'),_0x04c6('0x60'))[_0x04c6('0x66')](_0x04c6('0x6a'),_0x04c6('0x61'))['field'](_0x04c6('0x78'),'CampaignId')['field'](_0x04c6('0x68'),_0x04c6('0x63'))[_0x04c6('0x66')](_0x04c6('0x68'),_0x04c6('0x64'))[_0x04c6('0x6c')](_0x04c6('0x6d'))[_0x04c6('0x35')](_0x04c6('0x79'),_0x4f258c[_0x04c6('0x46')]['id'][_0x04c6('0x6f')]())['where']('state\x20=\x20?',_0x4f258c[_0x04c6('0x45')][_0x04c6('0x70')]['toString']())[_0x04c6('0x35')](_0x04c6('0x7a'))['where'](_0x04c6('0x71'),squel[_0x04c6('0x65')]()[_0x04c6('0x66')](_0x04c6('0x5e'))[_0x04c6('0x6c')](_0x04c6('0x5d'))[_0x04c6('0x35')](_0x04c6('0x79'),_0x4f258c['params']['id'][_0x04c6('0x6f')]()))['where'](_0x04c6('0x71'),squel[_0x04c6('0x65')]()[_0x04c6('0x66')](_0x04c6('0x7b'))[_0x04c6('0x6c')](_0x04c6('0x6d'))['where'](_0x04c6('0x79'),_0x4f258c[_0x04c6('0x46')]['id'][_0x04c6('0x6f')]())['where']('state\x20=\x204'))['group'](_0x04c6('0x60')))[_0x04c6('0x6f')]();return db['sequelize'][_0x04c6('0x2b')](_0x425d01);}return[];})[_0x04c6('0x1f')](respondWithResult(_0x202761,null))[_0x04c6('0x3e')](handleError(_0x202761,null));};exports['checkContactHopper']=function(_0x343c1f,_0x485457,_0x1c0c74){return db[_0x04c6('0x7c')][_0x04c6('0x7d')]({'where':{'VoiceQueueId':_0x343c1f['body']['VoiceQueueId'],'CampaignId':_0x343c1f[_0x04c6('0x45')][_0x04c6('0x77')],'ContactId':_0x343c1f[_0x04c6('0x45')][_0x04c6('0x60')]}})['then'](handleEntityNotFound(_0x485457,null))['then'](function(_0x3e12a4){if(_0x3e12a4){return _0x3e12a4;}return null;})[_0x04c6('0x1f')](respondWithResult(_0x485457,null))[_0x04c6('0x3e')](handleError(_0x485457,null));};
\ No newline at end of file