-const a147_0x2849=['status','findOne','fromQuery','fieldName','cm_hopper_final','error','order','updatedAt','VIRTUAL','congestionContacts','options','calleridnum\x20IS\x20NOT\x20NULL','length','query','dropContacts','cm_hopper','group','noAnswerContacts','uniqueid','attributes','`state`\x20=\x2022,\x201,\x20null','describe','`state`\x20=\x200,\x201,\x20null','VoiceQueueId\x20=\x20?','json','body','ContactId','countContactsQueueCampaignHopperFinal','../../mysqldb','type','busyContacts','createdAt','params','sendStatus','reCallContacts','select','stack','answeringMachine','update','then','fields','ANY_VALUE(ListId)','ListId','offset','state','noSuchContacts','merge','sort','name','NOW()','filter','rows','map','intersection','moveContactsIvrCampaignHopperFinal','state\x20=\x204','`state`\x20=\x205,\x201,\x20null','CmHopperFinal','`state`\x20=\x203,\x201,\x20null','into','Content-Range','where','rawAttributes','ANY_VALUE(calleridnum)','toString','include','lodash','`state`\x20=\x2011\x20,\x201,\x20null','show','includeAll','field','`state`\x20=\x208,\x201,\x20null','count','`state`\x20=\x2010\x20,\x201,\x20null','findAll','from','COUNT','send','keys','catch','set','filters','phone','VoiceQueueId','insert','squel','ANY_VALUE(ContactId)','sequelize','CmHopper','calleridnum','CampaignId\x20=\x20?','calleridnum\x20NOT\x20IN\x20(?)','abandonedContacts','CampaignId','scheduledAt','limit','model'];(function(_0x329d42,_0x2849c1){const _0x1ea10e=function(_0x20e40e){while(--_0x20e40e){_0x329d42['push'](_0x329d42['shift']());}};_0x1ea10e(++_0x2849c1);}(a147_0x2849,0xb0));const a147_0x1ea1=function(_0x329d42,_0x2849c1){_0x329d42=_0x329d42-0x0;let _0x1ea10e=a147_0x2849[_0x329d42];return _0x1ea10e;};const _0x167415=a147_0x1ea1;'use strict';const _=require(_0x167415('0x54')),squel=require(_0x167415('0x6')),qs=require('../../components/parsers/qs'),logger=require('../../config/logger')('api'),db=require(_0x167415('0x2e'))['db'],{Op,fn,literal}=require(_0x167415('0x8'));function respondWithResult(_0x20e40e,_0x3f1cd1){return _0x3f1cd1=_0x3f1cd1||0xc8,function(_0x2ea70d){const _0x281e02=a147_0x1ea1;if(_0x2ea70d)return _0x20e40e['status'](_0x3f1cd1)[_0x281e02('0x2a')](_0x2ea70d);};}function respondWithFilteredResult(_0x58a0a8,_0xa18f1f){return function(_0x1c9230){const _0x34378c=a147_0x1ea1;if(_0x1c9230){const _0x300430=_0x1c9230['count'],_0x3d626f=_0xa18f1f[_0x34378c('0x3d')];let _0xc0fdd0=_0xa18f1f['offset']+_0xa18f1f[_0x34378c('0x10')],_0x598ecf;return _0xc0fdd0>=_0x300430?(_0xc0fdd0=_0x300430,_0x598ecf=0xc8):_0x598ecf=0xce,_0x58a0a8[_0x34378c('0x12')](_0x598ecf),_0x58a0a8[_0x34378c('0x1')](_0x34378c('0x4e'),_0x3d626f+'-'+_0xc0fdd0+'/'+_0x300430)[_0x34378c('0x2a')](_0x1c9230);}return null;};}function saveUpdates(_0x218f35){return function(_0x280876){if(_0x280876)return _0x280876['update'](_0x218f35)['then'](function(_0x2c43f6){return _0x2c43f6;});return null;};}function handleEntityNotFound(_0x30a80c){return function(_0x29d2f5){const _0x33ead2=a147_0x1ea1;return!_0x29d2f5&&_0x30a80c[_0x33ead2('0x33')](0x194),_0x29d2f5;};}function handleError(_0x8ff91e,_0x913849){return _0x913849=_0x913849||0x1f4,function(_0x4b3dd9){const _0xd9879e=a147_0x1ea1;logger[_0xd9879e('0x17')](_0x4b3dd9[_0xd9879e('0x36')]),_0x4b3dd9['name']&&delete _0x4b3dd9[_0xd9879e('0x42')],_0x8ff91e[_0xd9879e('0x12')](_0x913849)[_0xd9879e('0x5f')](_0x4b3dd9);};}exports['index']=function(_0x3673a2,_0x435836){const _0xfa37d2=_0x167415;let _0x2ad43a={};const _0x1b04e7={},_0x1f2b7e={'count':0x0,'rows':[]},_0x5880b4=_[_0xfa37d2('0x46')](db[_0xfa37d2('0x4b')][_0xfa37d2('0x50')],function(_0x5edf22){const _0x20c3fe=_0xfa37d2;return{'name':_0x5edf22[_0x20c3fe('0x15')],'type':_0x5edf22[_0x20c3fe('0x2f')]['key']};});_0x1b04e7[_0xfa37d2('0x11')]=_['map'](_0x5880b4,_0xfa37d2('0x42')),_0x1b04e7[_0xfa37d2('0x1f')]=_['keys'](_0x3673a2[_0xfa37d2('0x1f')]),_0x1b04e7[_0xfa37d2('0x2')]=_[_0xfa37d2('0x47')](_0x1b04e7[_0xfa37d2('0x11')],_0x1b04e7[_0xfa37d2('0x1f')]),_0x2ad43a['attributes']=_['intersection'](_0x1b04e7[_0xfa37d2('0x11')],qs[_0xfa37d2('0x3a')](_0x3673a2[_0xfa37d2('0x1f')][_0xfa37d2('0x3a')])),_0x2ad43a[_0xfa37d2('0x25')]=_0x2ad43a['attributes'][_0xfa37d2('0x1e')]?_0x2ad43a[_0xfa37d2('0x25')]:_0x1b04e7[_0xfa37d2('0x11')];typeof _0x3673a2[_0xfa37d2('0x1f')]['nolimit']==='undefined'&&(_0x2ad43a[_0xfa37d2('0x10')]=qs['limit'](_0x3673a2[_0xfa37d2('0x1f')]['limit']),_0x2ad43a[_0xfa37d2('0x3d')]=qs[_0xfa37d2('0x3d')](_0x3673a2['query']['offset']));_0x2ad43a[_0xfa37d2('0x18')]=qs[_0xfa37d2('0x41')](_0x3673a2[_0xfa37d2('0x1f')][_0xfa37d2('0x41')]),_0x2ad43a[_0xfa37d2('0x4f')]=qs['filters'](_['pick'](_0x3673a2['query'],_0x1b04e7[_0xfa37d2('0x2')]),_0x5880b4);_0x3673a2[_0xfa37d2('0x1f')][_0xfa37d2('0x44')]&&(_0x2ad43a['where']=_[_0xfa37d2('0x40')](_0x2ad43a[_0xfa37d2('0x4f')],{[Op['or']]:_[_0xfa37d2('0x46')](_0x5880b4,function(_0x43f5bc){const _0x4fbb9a=_0xfa37d2;if(_0x43f5bc['type']!==_0x4fbb9a('0x1a')){const _0x2b1e03={};return _0x2b1e03[_0x43f5bc[_0x4fbb9a('0x42')]]={[Op['like']]:'%'+_0x3673a2['query'][_0x4fbb9a('0x44')]+'%'},_0x2b1e03;}})}));_0x2ad43a=_[_0xfa37d2('0x40')]({},_0x2ad43a,_0x3673a2[_0xfa37d2('0x1c')]);const _0x3dc872={'where':_0x2ad43a['where']};return db['CmHopperFinal'][_0xfa37d2('0x5a')](_0x3dc872)['then'](function(_0x27e310){const _0x4adbd8=_0xfa37d2;return _0x1f2b7e[_0x4adbd8('0x5a')]=_0x27e310,_0x3673a2[_0x4adbd8('0x1f')][_0x4adbd8('0x57')]&&(_0x2ad43a[_0x4adbd8('0x53')]=[{'all':!![]}]),db[_0x4adbd8('0x4b')]['findAll'](_0x2ad43a);})[_0xfa37d2('0x39')](function(_0x3b9be8){const _0x4140db=_0xfa37d2;return _0x1f2b7e[_0x4140db('0x45')]=_0x3b9be8,_0x1f2b7e;})[_0xfa37d2('0x39')](respondWithFilteredResult(_0x435836,_0x2ad43a))[_0xfa37d2('0x0')](handleError(_0x435836,null));},exports[_0x167415('0x56')]=function(_0x556832,_0x27db05){const _0x16ce4c=_0x167415;let _0xd42452={'raw':!![],'where':{'id':_0x556832[_0x16ce4c('0x32')]['id']}};const _0x2c2156={};return _0x2c2156['model']=_['keys'](db['CmHopperFinal'][_0x16ce4c('0x50')]),_0x2c2156[_0x16ce4c('0x1f')]=_[_0x16ce4c('0x60')](_0x556832[_0x16ce4c('0x1f')]),_0x2c2156['filters']=_[_0x16ce4c('0x47')](_0x2c2156['model'],_0x2c2156[_0x16ce4c('0x1f')]),_0xd42452[_0x16ce4c('0x25')]=_[_0x16ce4c('0x47')](_0x2c2156['model'],qs[_0x16ce4c('0x3a')](_0x556832[_0x16ce4c('0x1f')][_0x16ce4c('0x3a')])),_0xd42452[_0x16ce4c('0x25')]=_0xd42452[_0x16ce4c('0x25')][_0x16ce4c('0x1e')]?_0xd42452[_0x16ce4c('0x25')]:_0x2c2156[_0x16ce4c('0x11')],_0x556832[_0x16ce4c('0x1f')][_0x16ce4c('0x57')]&&(_0xd42452['include']=[{'all':!![]}]),_0xd42452=_['merge']({},_0xd42452,_0x556832[_0x16ce4c('0x1c')]),db[_0x16ce4c('0x4b')]['findOne'](_0xd42452)[_0x16ce4c('0x39')](handleEntityNotFound(_0x27db05,null))[_0x16ce4c('0x39')](respondWithResult(_0x27db05,null))[_0x16ce4c('0x0')](handleError(_0x27db05,null));},exports[_0x167415('0x27')]=function(_0x5ec863,_0x35bfaf){const _0x51a281=_0x167415;return db[_0x51a281('0x4b')][_0x51a281('0x27')]()[_0x51a281('0x39')](respondWithResult(_0x35bfaf,null))[_0x51a281('0x0')](handleError(_0x35bfaf,null));},exports[_0x167415('0x38')]=function(_0x49b6b3,_0x535f8f){const _0x4dec50=_0x167415;return _0x49b6b3[_0x4dec50('0x2b')][_0x4dec50('0x24')]&&delete _0x49b6b3[_0x4dec50('0x2b')]['uniqueid'],db[_0x4dec50('0x4b')][_0x4dec50('0x13')]({'where':{'uniqueid':_0x49b6b3[_0x4dec50('0x32')]['id']}})['then'](handleEntityNotFound(_0x535f8f,null))['then'](saveUpdates(_0x49b6b3[_0x4dec50('0x2b')],null))['then'](respondWithResult(_0x535f8f,null))['catch'](handleError(_0x535f8f,null));},exports[_0x167415('0x2d')]=function(_0x38feee,_0x3e9eb7){const _0x506382=_0x167415;return db[_0x506382('0x4b')][_0x506382('0x5c')]({'raw':![],'where':{'VoiceQueueId':_0x38feee[_0x506382('0x32')]['id']},'attributes':[[fn('COUNT',fn('IF',literal(_0x506382('0x28')))),_0x506382('0x3f')],[fn(_0x506382('0x5e'),fn('IF',literal('`state`\x20=\x203,\x201,\x20null'))),_0x506382('0x23')],[fn(_0x506382('0x5e'),fn('IF',literal('`state`\x20=\x205,\x201,\x20null'))),'busyContacts'],[fn('COUNT',fn('IF',literal('`state`\x20=\x208,\x201,\x20null'))),_0x506382('0x1b')],[fn(_0x506382('0x5e'),fn('IF',literal(_0x506382('0x5b')))),_0x506382('0x20')],[fn(_0x506382('0x5e'),fn('IF',literal(_0x506382('0x55')))),_0x506382('0xd')],[fn(_0x506382('0x5e'),fn('IF',literal(_0x506382('0x26')))),_0x506382('0x34')],[fn(_0x506382('0x5e'),fn('IF',literal('`state`\x20=\x2019,\x201,\x20null'))),_0x506382('0x37')]]})[_0x506382('0x39')](handleEntityNotFound(_0x3e9eb7,null))[_0x506382('0x39')](respondWithResult(_0x3e9eb7,null))[_0x506382('0x0')](handleError(_0x3e9eb7,null));},exports['countContactsIvrCampaignHopperFinal']=function(_0x321778,_0x65414e){const _0x2597c2=_0x167415;return db[_0x2597c2('0x4b')][_0x2597c2('0x5c')]({'raw':![],'where':{'CampaignId':_0x321778['params']['id']},'attributes':[[fn('COUNT',fn('IF',literal(_0x2597c2('0x28')))),'noSuchContacts'],[fn(_0x2597c2('0x5e'),fn('IF',literal(_0x2597c2('0x4c')))),_0x2597c2('0x23')],[fn('COUNT',fn('IF',literal(_0x2597c2('0x4a')))),_0x2597c2('0x30')],[fn(_0x2597c2('0x5e'),fn('IF',literal(_0x2597c2('0x59')))),_0x2597c2('0x1b')],[fn(_0x2597c2('0x5e'),fn('IF',literal(_0x2597c2('0x5b')))),_0x2597c2('0x20')],[fn('COUNT',fn('IF',literal(_0x2597c2('0x55')))),'abandonedContacts'],[fn('COUNT',fn('IF',literal(_0x2597c2('0x26')))),_0x2597c2('0x34')],[fn(_0x2597c2('0x5e'),fn('IF',literal('`state`\x20=\x2019,\x201,\x20null'))),_0x2597c2('0x37')]]})[_0x2597c2('0x39')](handleEntityNotFound(_0x65414e,null))[_0x2597c2('0x39')](respondWithResult(_0x65414e,null))[_0x2597c2('0x0')](handleError(_0x65414e,null));},exports['moveContactsQueueCampaignHopperFinal']=function(_0x2bc25b,_0x24630d){const _0x48798e=_0x167415;return db['VoiceQueue']['findOne']({'where':{'id':_0x2bc25b[_0x48798e('0x32')]['id']}})[_0x48798e('0x39')](handleEntityNotFound(_0x24630d,null))[_0x48798e('0x39')](function(_0x566769){const _0x42ac8b=_0x48798e;let _0x2bca5b;if(_0x566769)return _0x2bca5b=squel[_0x42ac8b('0x5')]()[_0x42ac8b('0x4d')](_0x42ac8b('0x21'))[_0x42ac8b('0x14')]([_0x42ac8b('0x3'),_0x42ac8b('0xf'),_0x42ac8b('0x2c'),_0x42ac8b('0x3c'),_0x42ac8b('0x4'),_0x42ac8b('0x31'),_0x42ac8b('0x19')],squel[_0x42ac8b('0x35')]()[_0x42ac8b('0x58')]('ANY_VALUE(calleridnum)',_0x42ac8b('0x3'))['field'](_0x42ac8b('0x43'),_0x42ac8b('0xf'))[_0x42ac8b('0x58')]('ANY_VALUE(ContactId)','ContactId')[_0x42ac8b('0x58')]('ANY_VALUE(ListId)','ListId')['field']('ANY_VALUE(VoiceQueueId)',_0x42ac8b('0x4'))[_0x42ac8b('0x58')](_0x42ac8b('0x43'),_0x42ac8b('0x31'))['field'](_0x42ac8b('0x43'),_0x42ac8b('0x19'))[_0x42ac8b('0x5d')](_0x42ac8b('0x16'))['where'](_0x42ac8b('0x29'),_0x2bc25b[_0x42ac8b('0x32')]['id'][_0x42ac8b('0x52')]())[_0x42ac8b('0x4f')]('state\x20=\x20?',_0x2bc25b[_0x42ac8b('0x2b')][_0x42ac8b('0x3e')][_0x42ac8b('0x52')]())[_0x42ac8b('0x4f')]('calleridnum\x20IS\x20NOT\x20NULL')['where']('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x42ac8b('0x35')]()[_0x42ac8b('0x58')](_0x42ac8b('0x3'))[_0x42ac8b('0x5d')](_0x42ac8b('0x21'))[_0x42ac8b('0x4f')](_0x42ac8b('0x29'),_0x2bc25b[_0x42ac8b('0x32')]['id']['toString']()))[_0x42ac8b('0x4f')](_0x42ac8b('0xc'),squel[_0x42ac8b('0x35')]()['field'](_0x42ac8b('0xa'))['from'](_0x42ac8b('0x16'))[_0x42ac8b('0x4f')](_0x42ac8b('0x29'),_0x2bc25b['params']['id']['toString']())['where'](_0x42ac8b('0x49')))[_0x42ac8b('0x22')]('ContactId'))['toString'](),db[_0x42ac8b('0x8')][_0x42ac8b('0x1f')](_0x2bca5b);return[];})['then'](respondWithResult(_0x24630d,null))['catch'](handleError(_0x24630d,null));},exports[_0x167415('0x48')]=function(_0x461cf9,_0x4498b5){const _0x2194c2=_0x167415;return db['Campaign'][_0x2194c2('0x13')]({'where':{'id':_0x461cf9[_0x2194c2('0x32')]['id']}})['then'](handleEntityNotFound(_0x4498b5,null))['then'](function(_0x34ccad){const _0x36f6d7=_0x2194c2;let _0x3a57aa;if(_0x34ccad)return _0x3a57aa=squel[_0x36f6d7('0x5')]()[_0x36f6d7('0x4d')](_0x36f6d7('0x21'))[_0x36f6d7('0x14')](['phone','scheduledAt',_0x36f6d7('0x2c'),_0x36f6d7('0x3c'),'CampaignId',_0x36f6d7('0x31'),_0x36f6d7('0x19')],squel['select']()[_0x36f6d7('0x58')](_0x36f6d7('0x51'),_0x36f6d7('0x3'))['field'](_0x36f6d7('0x43'),_0x36f6d7('0xf'))[_0x36f6d7('0x58')](_0x36f6d7('0x7'),_0x36f6d7('0x2c'))['field'](_0x36f6d7('0x3b'),_0x36f6d7('0x3c'))[_0x36f6d7('0x58')]('ANY_VALUE(CampaignId)',_0x36f6d7('0xe'))['field']('NOW()',_0x36f6d7('0x31'))[_0x36f6d7('0x58')](_0x36f6d7('0x43'),_0x36f6d7('0x19'))[_0x36f6d7('0x5d')](_0x36f6d7('0x16'))[_0x36f6d7('0x4f')](_0x36f6d7('0xb'),_0x461cf9['params']['id']['toString']())[_0x36f6d7('0x4f')]('state\x20=\x20?',_0x461cf9[_0x36f6d7('0x2b')][_0x36f6d7('0x3e')][_0x36f6d7('0x52')]())[_0x36f6d7('0x4f')](_0x36f6d7('0x1d'))[_0x36f6d7('0x4f')](_0x36f6d7('0xc'),squel['select']()[_0x36f6d7('0x58')]('phone')[_0x36f6d7('0x5d')](_0x36f6d7('0x21'))[_0x36f6d7('0x4f')](_0x36f6d7('0xb'),_0x461cf9['params']['id'][_0x36f6d7('0x52')]()))[_0x36f6d7('0x4f')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x36f6d7('0x35')]()['field'](_0x36f6d7('0xa'))[_0x36f6d7('0x5d')](_0x36f6d7('0x16'))[_0x36f6d7('0x4f')]('CampaignId\x20=\x20?',_0x461cf9[_0x36f6d7('0x32')]['id'][_0x36f6d7('0x52')]())['where'](_0x36f6d7('0x49')))[_0x36f6d7('0x22')](_0x36f6d7('0x2c')))[_0x36f6d7('0x52')](),db[_0x36f6d7('0x8')][_0x36f6d7('0x1f')](_0x3a57aa);return[];})[_0x2194c2('0x39')](respondWithResult(_0x4498b5,null))[_0x2194c2('0x0')](handleError(_0x4498b5,null));},exports['checkContactHopper']=function(_0x2b2b92,_0xb6e31d){const _0x7693eb=_0x167415;return db[_0x7693eb('0x9')]['findOne']({'where':{'VoiceQueueId':_0x2b2b92[_0x7693eb('0x2b')][_0x7693eb('0x4')],'CampaignId':_0x2b2b92[_0x7693eb('0x2b')][_0x7693eb('0xe')],'ContactId':_0x2b2b92[_0x7693eb('0x2b')]['ContactId']}})[_0x7693eb('0x39')](handleEntityNotFound(_0xb6e31d,null))['then'](function(_0x261eb4){if(_0x261eb4)return _0x261eb4;return null;})[_0x7693eb('0x39')](respondWithResult(_0xb6e31d,null))[_0x7693eb('0x0')](handleError(_0xb6e31d,null));};
\ No newline at end of file
+const a176_0x1f5d=['nolimit','catch','createdAt','status','NOW()','keys','noAnswerContacts','VoiceQueueId\x20=\x20?','CmHopperFinal','`state`\x20=\x203,\x201,\x20null','busyContacts','VIRTUAL','options','CampaignId','ANY_VALUE(calleridnum)','order','`state`\x20=\x2019,\x201,\x20null','params','fields','calleridnum\x20IS\x20NOT\x20NULL','../../mysqldb','noSuchContacts','CampaignId\x20=\x20?','countContactsIvrCampaignHopperFinal','type','attributes','congestionContacts','VoiceQueueId','countContactsQueueCampaignHopperFinal','sendStatus','ANY_VALUE(VoiceQueueId)','intersection','reCallContacts','lodash','CmHopper','send','show','query','set','ANY_VALUE(ContactId)','abandonedContacts','cm_hopper','findOne','field','findAll','state\x20=\x204','undefined','checkContactHopper','key','Content-Range','`state`\x20=\x2022,\x201,\x20null','squel','index','state','../../components/parsers/qs','stack','state\x20=\x20?','like','uniqueid','pick','fromQuery','calleridnum','phone','includeAll','group','cm_hopper_final','describe','updatedAt','then','answeringMachine','`state`\x20=\x205,\x201,\x20null','sort','filter','model','limit','filters','ANY_VALUE(ListId)','toString','sequelize','error','update','api','`state`\x20=\x208,\x201,\x20null','select','into','ContactId','map','include','from','body','Campaign','`state`\x20=\x200,\x201,\x20null','moveContactsQueueCampaignHopperFinal','offset','moveContactsIvrCampaignHopperFinal','rows','insert','count','`state`\x20=\x2011\x20,\x201,\x20null','scheduledAt','where','calleridnum\x20NOT\x20IN\x20(?)','`state`\x20=\x2010\x20,\x201,\x20null','merge','COUNT','name','VoiceQueue','../../config/logger','ListId','ANY_VALUE(CampaignId)'];(function(_0x5251a2,_0x9e43f6){const _0x1f5db5=function(_0x366aa0){while(--_0x366aa0){_0x5251a2['push'](_0x5251a2['shift']());}};_0x1f5db5(++_0x9e43f6);}(a176_0x1f5d,0x182));const a176_0x366a=function(_0x5251a2,_0x9e43f6){_0x5251a2=_0x5251a2-0x1d1;let _0x1f5db5=a176_0x1f5d[_0x5251a2];return _0x1f5db5;};const a176_0x4e68c3=a176_0x366a;'use strict';const _=require(a176_0x4e68c3(0x228)),squel=require(a176_0x4e68c3(0x23a)),qs=require(a176_0x4e68c3(0x23d)),logger=require(a176_0x4e68c3(0x204))(a176_0x4e68c3(0x1ea)),{db}=require(a176_0x4e68c3(0x21b)),{Op,fn,literal}=require(a176_0x4e68c3(0x1e7));function respondWithResult(_0x4ba9c4,_0x2c9fbc){return _0x2c9fbc=_0x2c9fbc||0xc8,function(_0x3358f9){const _0x138827=a176_0x366a;if(_0x3358f9)return _0x4ba9c4[_0x138827(0x20a)](_0x2c9fbc)['json'](_0x3358f9);};}function respondWithFilteredResult(_0x5a6b01,_0x15c97a){return function(_0x4d626e){const _0x5e8342=a176_0x366a;if(_0x4d626e){const _0x2c565c=_0x4d626e[_0x5e8342(0x1fa)],_0x35e44f=_0x15c97a[_0x5e8342(0x1f6)];let _0x538ee9=_0x15c97a[_0x5e8342(0x1f6)]+_0x15c97a[_0x5e8342(0x1e3)],_0x46b584;return _0x538ee9>=_0x2c565c?(_0x538ee9=_0x2c565c,_0x46b584=0xc8):_0x46b584=0xce,_0x5a6b01['status'](_0x46b584),_0x5a6b01[_0x5e8342(0x22d)](_0x5e8342(0x238),_0x35e44f+'-'+_0x538ee9+'/'+_0x2c565c)['json'](_0x4d626e);}return null;};}function saveUpdates(_0x538432){return function(_0x4ea6c0){const _0x286647=a176_0x366a;if(_0x4ea6c0)return _0x4ea6c0[_0x286647(0x1e9)](_0x538432)[_0x286647(0x1dd)](function(_0x5c4501){return _0x5c4501;});return null;};}function handleEntityNotFound(_0x4a5ff6){return function(_0xd17c73){const _0x2c28b7=a176_0x366a;return!_0xd17c73&&_0x4a5ff6[_0x2c28b7(0x224)](0x194),_0xd17c73;};}function handleError(_0x1aea23,_0x516eae){return _0x516eae=_0x516eae||0x1f4,function(_0x16cf7c){const _0x4483bc=a176_0x366a;logger[_0x4483bc(0x1e8)](_0x16cf7c[_0x4483bc(0x23e)]),_0x16cf7c['name']&&delete _0x16cf7c[_0x4483bc(0x202)],_0x1aea23[_0x4483bc(0x20a)](_0x516eae)[_0x4483bc(0x22a)](_0x16cf7c);};}exports[a176_0x4e68c3(0x23b)]=function(_0x5c3d49,_0x27dbbc){const _0x4a97d5=a176_0x4e68c3;let _0x26f2e7={};const _0x16c585={},_0x1e299a={'count':0x0,'rows':[]},_0x450349=_[_0x4a97d5(0x1ef)](db[_0x4a97d5(0x20f)]['rawAttributes'],function(_0xe9edb8){const _0x15f516=_0x4a97d5;return{'name':_0xe9edb8['fieldName'],'type':_0xe9edb8[_0x15f516(0x21f)][_0x15f516(0x237)]};});_0x16c585['model']=_['map'](_0x450349,_0x4a97d5(0x202)),_0x16c585['query']=_['keys'](_0x5c3d49[_0x4a97d5(0x22c)]),_0x16c585[_0x4a97d5(0x1e4)]=_[_0x4a97d5(0x226)](_0x16c585[_0x4a97d5(0x1e2)],_0x16c585[_0x4a97d5(0x22c)]),_0x26f2e7['attributes']=_[_0x4a97d5(0x226)](_0x16c585[_0x4a97d5(0x1e2)],qs[_0x4a97d5(0x219)](_0x5c3d49[_0x4a97d5(0x22c)][_0x4a97d5(0x219)])),_0x26f2e7[_0x4a97d5(0x220)]=_0x26f2e7[_0x4a97d5(0x220)]['length']?_0x26f2e7[_0x4a97d5(0x220)]:_0x16c585[_0x4a97d5(0x1e2)];typeof _0x5c3d49[_0x4a97d5(0x22c)][_0x4a97d5(0x207)]===_0x4a97d5(0x235)&&(_0x26f2e7['limit']=qs['limit'](_0x5c3d49[_0x4a97d5(0x22c)]['limit']),_0x26f2e7[_0x4a97d5(0x1f6)]=qs[_0x4a97d5(0x1f6)](_0x5c3d49['query'][_0x4a97d5(0x1f6)]));_0x26f2e7[_0x4a97d5(0x216)]=qs[_0x4a97d5(0x1e0)](_0x5c3d49['query'][_0x4a97d5(0x1e0)]),_0x26f2e7[_0x4a97d5(0x1fd)]=qs[_0x4a97d5(0x1e4)](_[_0x4a97d5(0x1d4)](_0x5c3d49[_0x4a97d5(0x22c)],_0x16c585[_0x4a97d5(0x1e4)]),_0x450349);_0x5c3d49[_0x4a97d5(0x22c)][_0x4a97d5(0x1e1)]&&(_0x26f2e7[_0x4a97d5(0x1fd)]=_[_0x4a97d5(0x200)](_0x26f2e7[_0x4a97d5(0x1fd)],{[Op['or']]:_['map'](_0x450349,function(_0x2b30a1){const _0x58b2a4=_0x4a97d5;if(_0x2b30a1[_0x58b2a4(0x21f)]!==_0x58b2a4(0x212)){const _0x242c14={};return _0x242c14[_0x2b30a1[_0x58b2a4(0x202)]]={[Op[_0x58b2a4(0x1d2)]]:'%'+_0x5c3d49[_0x58b2a4(0x22c)][_0x58b2a4(0x1e1)]+'%'},_0x242c14;}})}));_0x26f2e7=_['merge']({},_0x26f2e7,_0x5c3d49[_0x4a97d5(0x213)]);const _0x5c3897={'where':_0x26f2e7['where']};return db[_0x4a97d5(0x20f)][_0x4a97d5(0x1fa)](_0x5c3897)[_0x4a97d5(0x1dd)](function(_0x346efb){const _0x37874=_0x4a97d5;return _0x1e299a[_0x37874(0x1fa)]=_0x346efb,_0x5c3d49['query'][_0x37874(0x1d8)]&&(_0x26f2e7[_0x37874(0x1f0)]=[{'all':!![]}]),db['CmHopperFinal'][_0x37874(0x233)](_0x26f2e7);})[_0x4a97d5(0x1dd)](function(_0x48fd9e){const _0x2fc9b7=_0x4a97d5;return _0x1e299a[_0x2fc9b7(0x1f8)]=_0x48fd9e,_0x1e299a;})[_0x4a97d5(0x1dd)](respondWithFilteredResult(_0x27dbbc,_0x26f2e7))['catch'](handleError(_0x27dbbc,null));},exports[a176_0x4e68c3(0x22b)]=function(_0x1f443c,_0xe16ca5){const _0x2debaa=a176_0x4e68c3;let _0x5dc3a6={'raw':!![],'where':{'id':_0x1f443c[_0x2debaa(0x218)]['id']}};const _0x353188={};return _0x353188[_0x2debaa(0x1e2)]=_[_0x2debaa(0x20c)](db[_0x2debaa(0x20f)]['rawAttributes']),_0x353188[_0x2debaa(0x22c)]=_['keys'](_0x1f443c[_0x2debaa(0x22c)]),_0x353188[_0x2debaa(0x1e4)]=_[_0x2debaa(0x226)](_0x353188[_0x2debaa(0x1e2)],_0x353188[_0x2debaa(0x22c)]),_0x5dc3a6[_0x2debaa(0x220)]=_[_0x2debaa(0x226)](_0x353188[_0x2debaa(0x1e2)],qs[_0x2debaa(0x219)](_0x1f443c[_0x2debaa(0x22c)]['fields'])),_0x5dc3a6['attributes']=_0x5dc3a6[_0x2debaa(0x220)]['length']?_0x5dc3a6[_0x2debaa(0x220)]:_0x353188[_0x2debaa(0x1e2)],_0x1f443c['query']['includeAll']&&(_0x5dc3a6['include']=[{'all':!![]}]),_0x5dc3a6=_[_0x2debaa(0x200)]({},_0x5dc3a6,_0x1f443c['options']),db[_0x2debaa(0x20f)][_0x2debaa(0x231)](_0x5dc3a6)[_0x2debaa(0x1dd)](handleEntityNotFound(_0xe16ca5,null))[_0x2debaa(0x1dd)](respondWithResult(_0xe16ca5,null))[_0x2debaa(0x208)](handleError(_0xe16ca5,null));},exports[a176_0x4e68c3(0x1db)]=function(_0xd88ae8,_0x3d2565){const _0x31466b=a176_0x4e68c3;return db[_0x31466b(0x20f)][_0x31466b(0x1db)]()[_0x31466b(0x1dd)](respondWithResult(_0x3d2565,null))[_0x31466b(0x208)](handleError(_0x3d2565,null));},exports[a176_0x4e68c3(0x1e9)]=function(_0x4bfdbf,_0xfe2a8){const _0x4e6e8c=a176_0x4e68c3;return _0x4bfdbf[_0x4e6e8c(0x1f2)][_0x4e6e8c(0x1d3)]&&delete _0x4bfdbf['body']['uniqueid'],db[_0x4e6e8c(0x20f)]['findOne']({'where':{'uniqueid':_0x4bfdbf[_0x4e6e8c(0x218)]['id']}})[_0x4e6e8c(0x1dd)](handleEntityNotFound(_0xfe2a8,null))[_0x4e6e8c(0x1dd)](saveUpdates(_0x4bfdbf[_0x4e6e8c(0x1f2)],null))['then'](respondWithResult(_0xfe2a8,null))[_0x4e6e8c(0x208)](handleError(_0xfe2a8,null));},exports[a176_0x4e68c3(0x223)]=function(_0x4eee0b,_0x53fee3){const _0x41b68c=a176_0x4e68c3;return db[_0x41b68c(0x20f)][_0x41b68c(0x233)]({'raw':![],'where':{'VoiceQueueId':_0x4eee0b['params']['id']},'attributes':[[fn('COUNT',fn('IF',literal(_0x41b68c(0x1f4)))),_0x41b68c(0x21c)],[fn(_0x41b68c(0x201),fn('IF',literal(_0x41b68c(0x210)))),_0x41b68c(0x20d)],[fn(_0x41b68c(0x201),fn('IF',literal(_0x41b68c(0x1df)))),_0x41b68c(0x211)],[fn(_0x41b68c(0x201),fn('IF',literal(_0x41b68c(0x1eb)))),_0x41b68c(0x221)],[fn(_0x41b68c(0x201),fn('IF',literal(_0x41b68c(0x1ff)))),'dropContacts'],[fn(_0x41b68c(0x201),fn('IF',literal(_0x41b68c(0x1fb)))),'abandonedContacts'],[fn(_0x41b68c(0x201),fn('IF',literal(_0x41b68c(0x239)))),_0x41b68c(0x227)],[fn(_0x41b68c(0x201),fn('IF',literal(_0x41b68c(0x217)))),_0x41b68c(0x1de)]]})['then'](handleEntityNotFound(_0x53fee3,null))[_0x41b68c(0x1dd)](respondWithResult(_0x53fee3,null))[_0x41b68c(0x208)](handleError(_0x53fee3,null));},exports[a176_0x4e68c3(0x21e)]=function(_0x5142a0,_0x130d32){const _0x23a2ad=a176_0x4e68c3;return db[_0x23a2ad(0x20f)][_0x23a2ad(0x233)]({'raw':![],'where':{'CampaignId':_0x5142a0[_0x23a2ad(0x218)]['id']},'attributes':[[fn(_0x23a2ad(0x201),fn('IF',literal(_0x23a2ad(0x1f4)))),'noSuchContacts'],[fn(_0x23a2ad(0x201),fn('IF',literal(_0x23a2ad(0x210)))),_0x23a2ad(0x20d)],[fn(_0x23a2ad(0x201),fn('IF',literal(_0x23a2ad(0x1df)))),_0x23a2ad(0x211)],[fn(_0x23a2ad(0x201),fn('IF',literal(_0x23a2ad(0x1eb)))),_0x23a2ad(0x221)],[fn(_0x23a2ad(0x201),fn('IF',literal('`state`\x20=\x2010\x20,\x201,\x20null'))),'dropContacts'],[fn('COUNT',fn('IF',literal(_0x23a2ad(0x1fb)))),_0x23a2ad(0x22f)],[fn(_0x23a2ad(0x201),fn('IF',literal('`state`\x20=\x2022,\x201,\x20null'))),_0x23a2ad(0x227)],[fn(_0x23a2ad(0x201),fn('IF',literal(_0x23a2ad(0x217)))),_0x23a2ad(0x1de)]]})[_0x23a2ad(0x1dd)](handleEntityNotFound(_0x130d32,null))['then'](respondWithResult(_0x130d32,null))[_0x23a2ad(0x208)](handleError(_0x130d32,null));},exports[a176_0x4e68c3(0x1f5)]=function(_0x16996c,_0x183081){const _0x546908=a176_0x4e68c3;return db[_0x546908(0x203)][_0x546908(0x231)]({'where':{'id':_0x16996c['params']['id']}})[_0x546908(0x1dd)](handleEntityNotFound(_0x183081,null))['then'](function(_0x778217){const _0x15d7ca=_0x546908;let _0x42a521;if(_0x778217)return _0x42a521=squel[_0x15d7ca(0x1f9)]()['into'](_0x15d7ca(0x230))[_0x15d7ca(0x1d5)](['phone',_0x15d7ca(0x1fc),_0x15d7ca(0x1ee),_0x15d7ca(0x205),_0x15d7ca(0x222),_0x15d7ca(0x209),'updatedAt'],squel[_0x15d7ca(0x1ec)]()[_0x15d7ca(0x232)](_0x15d7ca(0x215),'phone')[_0x15d7ca(0x232)](_0x15d7ca(0x20b),_0x15d7ca(0x1fc))[_0x15d7ca(0x232)](_0x15d7ca(0x22e),'ContactId')[_0x15d7ca(0x232)](_0x15d7ca(0x1e5),_0x15d7ca(0x205))[_0x15d7ca(0x232)](_0x15d7ca(0x225),_0x15d7ca(0x222))[_0x15d7ca(0x232)]('NOW()',_0x15d7ca(0x209))[_0x15d7ca(0x232)](_0x15d7ca(0x20b),_0x15d7ca(0x1dc))['from'](_0x15d7ca(0x1da))[_0x15d7ca(0x1fd)](_0x15d7ca(0x20e),_0x16996c[_0x15d7ca(0x218)]['id'][_0x15d7ca(0x1e6)]())[_0x15d7ca(0x1fd)]('state\x20=\x20?',_0x16996c[_0x15d7ca(0x1f2)][_0x15d7ca(0x23c)]['toString']())[_0x15d7ca(0x1fd)]('calleridnum\x20IS\x20NOT\x20NULL')[_0x15d7ca(0x1fd)](_0x15d7ca(0x1fe),squel[_0x15d7ca(0x1ec)]()['field'](_0x15d7ca(0x1d7))[_0x15d7ca(0x1f1)](_0x15d7ca(0x230))[_0x15d7ca(0x1fd)](_0x15d7ca(0x20e),_0x16996c['params']['id'][_0x15d7ca(0x1e6)]()))[_0x15d7ca(0x1fd)]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x15d7ca(0x1ec)]()[_0x15d7ca(0x232)](_0x15d7ca(0x1d6))[_0x15d7ca(0x1f1)](_0x15d7ca(0x1da))[_0x15d7ca(0x1fd)](_0x15d7ca(0x20e),_0x16996c[_0x15d7ca(0x218)]['id'][_0x15d7ca(0x1e6)]())[_0x15d7ca(0x1fd)](_0x15d7ca(0x234)))[_0x15d7ca(0x1d9)](_0x15d7ca(0x1ee)))[_0x15d7ca(0x1e6)](),db[_0x15d7ca(0x1e7)][_0x15d7ca(0x22c)](_0x42a521);return[];})[_0x546908(0x1dd)](respondWithResult(_0x183081,null))[_0x546908(0x208)](handleError(_0x183081,null));},exports[a176_0x4e68c3(0x1f7)]=function(_0x3a98c2,_0x18f1ec){const _0x11f206=a176_0x4e68c3;return db[_0x11f206(0x1f3)][_0x11f206(0x231)]({'where':{'id':_0x3a98c2[_0x11f206(0x218)]['id']}})[_0x11f206(0x1dd)](handleEntityNotFound(_0x18f1ec,null))['then'](function(_0x2502bb){const _0x3cb0ad=_0x11f206;let _0x976bdc;if(_0x2502bb)return _0x976bdc=squel[_0x3cb0ad(0x1f9)]()[_0x3cb0ad(0x1ed)]('cm_hopper')[_0x3cb0ad(0x1d5)]([_0x3cb0ad(0x1d7),_0x3cb0ad(0x1fc),_0x3cb0ad(0x1ee),_0x3cb0ad(0x205),'CampaignId',_0x3cb0ad(0x209),'updatedAt'],squel[_0x3cb0ad(0x1ec)]()[_0x3cb0ad(0x232)](_0x3cb0ad(0x215),_0x3cb0ad(0x1d7))[_0x3cb0ad(0x232)](_0x3cb0ad(0x20b),_0x3cb0ad(0x1fc))[_0x3cb0ad(0x232)]('ANY_VALUE(ContactId)','ContactId')[_0x3cb0ad(0x232)](_0x3cb0ad(0x1e5),'ListId')[_0x3cb0ad(0x232)](_0x3cb0ad(0x206),'CampaignId')[_0x3cb0ad(0x232)]('NOW()',_0x3cb0ad(0x209))[_0x3cb0ad(0x232)](_0x3cb0ad(0x20b),_0x3cb0ad(0x1dc))['from'](_0x3cb0ad(0x1da))[_0x3cb0ad(0x1fd)](_0x3cb0ad(0x21d),_0x3a98c2[_0x3cb0ad(0x218)]['id'][_0x3cb0ad(0x1e6)]())[_0x3cb0ad(0x1fd)](_0x3cb0ad(0x1d1),_0x3a98c2[_0x3cb0ad(0x1f2)][_0x3cb0ad(0x23c)][_0x3cb0ad(0x1e6)]())['where'](_0x3cb0ad(0x21a))[_0x3cb0ad(0x1fd)](_0x3cb0ad(0x1fe),squel[_0x3cb0ad(0x1ec)]()['field']('phone')[_0x3cb0ad(0x1f1)]('cm_hopper')['where'](_0x3cb0ad(0x21d),_0x3a98c2[_0x3cb0ad(0x218)]['id'][_0x3cb0ad(0x1e6)]()))['where']('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x3cb0ad(0x1ec)]()['field']('calleridnum')['from'](_0x3cb0ad(0x1da))['where'](_0x3cb0ad(0x21d),_0x3a98c2[_0x3cb0ad(0x218)]['id'][_0x3cb0ad(0x1e6)]())[_0x3cb0ad(0x1fd)]('state\x20=\x204'))[_0x3cb0ad(0x1d9)](_0x3cb0ad(0x1ee)))[_0x3cb0ad(0x1e6)](),db[_0x3cb0ad(0x1e7)][_0x3cb0ad(0x22c)](_0x976bdc);return[];})['then'](respondWithResult(_0x18f1ec,null))['catch'](handleError(_0x18f1ec,null));},exports[a176_0x4e68c3(0x236)]=function(_0x1fb827,_0x1d0224){const _0x3123b7=a176_0x4e68c3;return db[_0x3123b7(0x229)]['findOne']({'where':{'VoiceQueueId':_0x1fb827['body']['VoiceQueueId'],'CampaignId':_0x1fb827['body'][_0x3123b7(0x214)],'ContactId':_0x1fb827[_0x3123b7(0x1f2)][_0x3123b7(0x1ee)]}})['then'](handleEntityNotFound(_0x1d0224,null))['then'](function(_0x3ceae3){if(_0x3ceae3)return _0x3ceae3;return null;})['then'](respondWithResult(_0x1d0224,null))[_0x3123b7(0x208)](handleError(_0x1d0224,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff