-const a147_0x1fce=['scheduledAt','createdAt','set','../../mysqldb','query','params','catch','calleridnum\x20IS\x20NOT\x20NULL','VoiceQueueId\x20=\x20?','moveContactsIvrCampaignHopperFinal','field','send','dropContacts','busyContacts','name','calleridnum','`state`\x20=\x2019,\x201,\x20null','state\x20=\x20?','count','model','sort','`state`\x20=\x205,\x201,\x20null','describe','answeringMachine','state\x20=\x204','state','`state`\x20=\x203,\x201,\x20null','order','sendStatus','`state`\x20=\x200,\x201,\x20null','show','includeAll','fromQuery','attributes','rawAttributes','where','updatedAt','options','findOne','status','congestionContacts','intersection','phone','insert','`state`\x20=\x2010\x20,\x201,\x20null','noAnswerContacts','findAll','ANY_VALUE(ContactId)','`state`\x20=\x2011\x20,\x201,\x20null','VoiceQueue','type','noSuchContacts','CmHopperFinal','ANY_VALUE(calleridnum)','rows','countContactsQueueCampaignHopperFinal','ANY_VALUE(ListId)','pick','ANY_VALUE(CampaignId)','COUNT','cm_hopper','NOW()','group','abandonedContacts','length','index','`state`\x20=\x2022,\x201,\x20null','stack','countContactsIvrCampaignHopperFinal','CmHopper','from','sequelize','moveContactsQueueCampaignHopperFinal','VoiceQueueId','ContactId','like','select','then','filters','map','fields','include','merge','`state`\x20=\x208,\x201,\x20null','reCallContacts','json','uniqueid','calleridnum\x20NOT\x20IN\x20(?)','ListId','Content-Range','../../config/logger','checkContactHopper','update','keys','CampaignId','lodash','filter','Campaign','offset','limit','toString','body','cm_hopper_final'];(function(_0x172a92,_0x1fce4c){const _0xb47650=function(_0x1e9bfe){while(--_0x1e9bfe){_0x172a92['push'](_0x172a92['shift']());}};_0xb47650(++_0x1fce4c);}(a147_0x1fce,0x123));const a147_0xb476=function(_0x172a92,_0x1fce4c){_0x172a92=_0x172a92-0x0;let _0xb47650=a147_0x1fce[_0x172a92];return _0xb47650;};const _0x2ee6b2=a147_0xb476;'use strict';const _=require(_0x2ee6b2('0xa')),squel=require('squel'),qs=require('../../components/parsers/qs'),logger=require(_0x2ee6b2('0x5'))('api'),db=require(_0x2ee6b2('0x15'))['db'],{Op,fn,literal}=require('sequelize');function respondWithResult(_0x1e9bfe,_0x12c123){return _0x12c123=_0x12c123||0xc8,function(_0x8c4483){const _0x3a7540=a147_0xb476;if(_0x8c4483)return _0x1e9bfe[_0x3a7540('0x39')](_0x12c123)[_0x3a7540('0x0')](_0x8c4483);};}function respondWithFilteredResult(_0xb1ca61,_0x103cf3){return function(_0x450d0e){const _0x318235=a147_0xb476;if(_0x450d0e){const _0x490b63=_0x450d0e[_0x318235('0x24')],_0x438f5c=_0x103cf3[_0x318235('0xd')];let _0x197370=_0x103cf3[_0x318235('0xd')]+_0x103cf3[_0x318235('0xe')],_0x35cdd4;return _0x197370>=_0x490b63?(_0x197370=_0x490b63,_0x35cdd4=0xc8):_0x35cdd4=0xce,_0xb1ca61[_0x318235('0x39')](_0x35cdd4),_0xb1ca61[_0x318235('0x14')](_0x318235('0x4'),_0x438f5c+'-'+_0x197370+'/'+_0x490b63)[_0x318235('0x0')](_0x450d0e);}return null;};}function saveUpdates(_0x44a647){return function(_0x5c5401){const _0x1408a0=a147_0xb476;if(_0x5c5401)return _0x5c5401[_0x1408a0('0x7')](_0x44a647)['then'](function(_0x21d394){return _0x21d394;});return null;};}function handleEntityNotFound(_0xea9b86){return function(_0x2d2146){const _0x9b4f6d=a147_0xb476;return!_0x2d2146&&_0xea9b86[_0x9b4f6d('0x2e')](0x194),_0x2d2146;};}function handleError(_0x74cad1,_0x128f2b){return _0x128f2b=_0x128f2b||0x1f4,function(_0x3bb794){const _0x78d17c=a147_0xb476;logger['error'](_0x3bb794[_0x78d17c('0x55')]),_0x3bb794[_0x78d17c('0x20')]&&delete _0x3bb794[_0x78d17c('0x20')],_0x74cad1[_0x78d17c('0x39')](_0x128f2b)[_0x78d17c('0x1d')](_0x3bb794);};}exports[_0x2ee6b2('0x53')]=function(_0x17298d,_0x3b10f4){const _0x165b5a=_0x2ee6b2;let _0x4f9cc1={};const _0x41c8f9={},_0xb76e68={'count':0x0,'rows':[]},_0x3c9c4c=_[_0x165b5a('0x61')](db[_0x165b5a('0x46')]['rawAttributes'],function(_0x49a9f6){const _0x28a4b5=_0x165b5a;return{'name':_0x49a9f6['fieldName'],'type':_0x49a9f6[_0x28a4b5('0x44')]['key']};});_0x41c8f9[_0x165b5a('0x25')]=_[_0x165b5a('0x61')](_0x3c9c4c,_0x165b5a('0x20')),_0x41c8f9[_0x165b5a('0x16')]=_[_0x165b5a('0x8')](_0x17298d['query']),_0x41c8f9[_0x165b5a('0x60')]=_[_0x165b5a('0x3b')](_0x41c8f9['model'],_0x41c8f9[_0x165b5a('0x16')]),_0x4f9cc1['attributes']=_['intersection'](_0x41c8f9[_0x165b5a('0x25')],qs[_0x165b5a('0x62')](_0x17298d[_0x165b5a('0x16')]['fields'])),_0x4f9cc1[_0x165b5a('0x33')]=_0x4f9cc1[_0x165b5a('0x33')][_0x165b5a('0x52')]?_0x4f9cc1[_0x165b5a('0x33')]:_0x41c8f9[_0x165b5a('0x25')];typeof _0x17298d[_0x165b5a('0x16')]['nolimit']==='undefined'&&(_0x4f9cc1[_0x165b5a('0xe')]=qs[_0x165b5a('0xe')](_0x17298d[_0x165b5a('0x16')][_0x165b5a('0xe')]),_0x4f9cc1[_0x165b5a('0xd')]=qs['offset'](_0x17298d[_0x165b5a('0x16')][_0x165b5a('0xd')]));_0x4f9cc1[_0x165b5a('0x2d')]=qs[_0x165b5a('0x26')](_0x17298d[_0x165b5a('0x16')][_0x165b5a('0x26')]),_0x4f9cc1['where']=qs[_0x165b5a('0x60')](_[_0x165b5a('0x4b')](_0x17298d[_0x165b5a('0x16')],_0x41c8f9[_0x165b5a('0x60')]),_0x3c9c4c);_0x17298d['query'][_0x165b5a('0xb')]&&(_0x4f9cc1[_0x165b5a('0x35')]=_[_0x165b5a('0x64')](_0x4f9cc1['where'],{[Op['or']]:_[_0x165b5a('0x61')](_0x3c9c4c,function(_0x1873d9){const _0x3070da=_0x165b5a;if(_0x1873d9['type']!=='VIRTUAL'){const _0x5bdf3d={};return _0x5bdf3d[_0x1873d9[_0x3070da('0x20')]]={[Op[_0x3070da('0x5d')]]:'%'+_0x17298d[_0x3070da('0x16')][_0x3070da('0xb')]+'%'},_0x5bdf3d;}})}));_0x4f9cc1=_[_0x165b5a('0x64')]({},_0x4f9cc1,_0x17298d[_0x165b5a('0x37')]);const _0x8e2d33={'where':_0x4f9cc1['where']};return db[_0x165b5a('0x46')][_0x165b5a('0x24')](_0x8e2d33)[_0x165b5a('0x5f')](function(_0x52c923){const _0x2dc26b=_0x165b5a;return _0xb76e68['count']=_0x52c923,_0x17298d[_0x2dc26b('0x16')][_0x2dc26b('0x31')]&&(_0x4f9cc1[_0x2dc26b('0x63')]=[{'all':!![]}]),db[_0x2dc26b('0x46')][_0x2dc26b('0x40')](_0x4f9cc1);})[_0x165b5a('0x5f')](function(_0x560db8){const _0xc7df4e=_0x165b5a;return _0xb76e68[_0xc7df4e('0x48')]=_0x560db8,_0xb76e68;})[_0x165b5a('0x5f')](respondWithFilteredResult(_0x3b10f4,_0x4f9cc1))[_0x165b5a('0x18')](handleError(_0x3b10f4,null));},exports[_0x2ee6b2('0x30')]=function(_0x35868a,_0x11cc6b){const _0x3cdc75=_0x2ee6b2;let _0x40d738={'raw':!![],'where':{'id':_0x35868a[_0x3cdc75('0x17')]['id']}};const _0x324639={};return _0x324639[_0x3cdc75('0x25')]=_[_0x3cdc75('0x8')](db['CmHopperFinal'][_0x3cdc75('0x34')]),_0x324639[_0x3cdc75('0x16')]=_[_0x3cdc75('0x8')](_0x35868a[_0x3cdc75('0x16')]),_0x324639['filters']=_['intersection'](_0x324639[_0x3cdc75('0x25')],_0x324639[_0x3cdc75('0x16')]),_0x40d738[_0x3cdc75('0x33')]=_[_0x3cdc75('0x3b')](_0x324639[_0x3cdc75('0x25')],qs[_0x3cdc75('0x62')](_0x35868a[_0x3cdc75('0x16')][_0x3cdc75('0x62')])),_0x40d738[_0x3cdc75('0x33')]=_0x40d738['attributes'][_0x3cdc75('0x52')]?_0x40d738[_0x3cdc75('0x33')]:_0x324639[_0x3cdc75('0x25')],_0x35868a['query'][_0x3cdc75('0x31')]&&(_0x40d738[_0x3cdc75('0x63')]=[{'all':!![]}]),_0x40d738=_[_0x3cdc75('0x64')]({},_0x40d738,_0x35868a[_0x3cdc75('0x37')]),db[_0x3cdc75('0x46')][_0x3cdc75('0x38')](_0x40d738)[_0x3cdc75('0x5f')](handleEntityNotFound(_0x11cc6b,null))[_0x3cdc75('0x5f')](respondWithResult(_0x11cc6b,null))[_0x3cdc75('0x18')](handleError(_0x11cc6b,null));},exports[_0x2ee6b2('0x28')]=function(_0x132f44,_0x34d4cc){const _0x1c6309=_0x2ee6b2;return db[_0x1c6309('0x46')]['describe']()['then'](respondWithResult(_0x34d4cc,null))[_0x1c6309('0x18')](handleError(_0x34d4cc,null));},exports[_0x2ee6b2('0x7')]=function(_0x3b1fa7,_0x2efd7b){const _0x4888b6=_0x2ee6b2;return _0x3b1fa7[_0x4888b6('0x10')][_0x4888b6('0x1')]&&delete _0x3b1fa7[_0x4888b6('0x10')][_0x4888b6('0x1')],db['CmHopperFinal']['findOne']({'where':{'uniqueid':_0x3b1fa7[_0x4888b6('0x17')]['id']}})['then'](handleEntityNotFound(_0x2efd7b,null))[_0x4888b6('0x5f')](saveUpdates(_0x3b1fa7[_0x4888b6('0x10')],null))[_0x4888b6('0x5f')](respondWithResult(_0x2efd7b,null))['catch'](handleError(_0x2efd7b,null));},exports[_0x2ee6b2('0x49')]=function(_0x17f63e,_0x58dd40){const _0x2b09eb=_0x2ee6b2;return db[_0x2b09eb('0x46')][_0x2b09eb('0x40')]({'raw':![],'where':{'VoiceQueueId':_0x17f63e[_0x2b09eb('0x17')]['id']},'attributes':[[fn(_0x2b09eb('0x4d'),fn('IF',literal(_0x2b09eb('0x2f')))),_0x2b09eb('0x45')],[fn(_0x2b09eb('0x4d'),fn('IF',literal(_0x2b09eb('0x2c')))),_0x2b09eb('0x3f')],[fn(_0x2b09eb('0x4d'),fn('IF',literal(_0x2b09eb('0x27')))),_0x2b09eb('0x1f')],[fn(_0x2b09eb('0x4d'),fn('IF',literal(_0x2b09eb('0x65')))),_0x2b09eb('0x3a')],[fn(_0x2b09eb('0x4d'),fn('IF',literal(_0x2b09eb('0x3e')))),_0x2b09eb('0x1e')],[fn(_0x2b09eb('0x4d'),fn('IF',literal(_0x2b09eb('0x42')))),_0x2b09eb('0x51')],[fn(_0x2b09eb('0x4d'),fn('IF',literal('`state`\x20=\x2022,\x201,\x20null'))),_0x2b09eb('0x66')],[fn(_0x2b09eb('0x4d'),fn('IF',literal(_0x2b09eb('0x22')))),_0x2b09eb('0x29')]]})[_0x2b09eb('0x5f')](handleEntityNotFound(_0x58dd40,null))[_0x2b09eb('0x5f')](respondWithResult(_0x58dd40,null))[_0x2b09eb('0x18')](handleError(_0x58dd40,null));},exports[_0x2ee6b2('0x56')]=function(_0x42e711,_0x126135){const _0x227a64=_0x2ee6b2;return db[_0x227a64('0x46')][_0x227a64('0x40')]({'raw':![],'where':{'CampaignId':_0x42e711[_0x227a64('0x17')]['id']},'attributes':[[fn(_0x227a64('0x4d'),fn('IF',literal(_0x227a64('0x2f')))),_0x227a64('0x45')],[fn(_0x227a64('0x4d'),fn('IF',literal(_0x227a64('0x2c')))),_0x227a64('0x3f')],[fn(_0x227a64('0x4d'),fn('IF',literal(_0x227a64('0x27')))),'busyContacts'],[fn(_0x227a64('0x4d'),fn('IF',literal(_0x227a64('0x65')))),_0x227a64('0x3a')],[fn('COUNT',fn('IF',literal('`state`\x20=\x2010\x20,\x201,\x20null'))),_0x227a64('0x1e')],[fn('COUNT',fn('IF',literal(_0x227a64('0x42')))),_0x227a64('0x51')],[fn(_0x227a64('0x4d'),fn('IF',literal(_0x227a64('0x54')))),_0x227a64('0x66')],[fn('COUNT',fn('IF',literal(_0x227a64('0x22')))),'answeringMachine']]})[_0x227a64('0x5f')](handleEntityNotFound(_0x126135,null))[_0x227a64('0x5f')](respondWithResult(_0x126135,null))[_0x227a64('0x18')](handleError(_0x126135,null));},exports[_0x2ee6b2('0x5a')]=function(_0x218697,_0x15164b){const _0x1943ce=_0x2ee6b2;return db[_0x1943ce('0x43')]['findOne']({'where':{'id':_0x218697[_0x1943ce('0x17')]['id']}})[_0x1943ce('0x5f')](handleEntityNotFound(_0x15164b,null))[_0x1943ce('0x5f')](function(_0x34b919){const _0x8e098c=_0x1943ce;let _0x42bb74;if(_0x34b919)return _0x42bb74=squel['insert']()['into'](_0x8e098c('0x4e'))[_0x8e098c('0x32')]([_0x8e098c('0x3c'),_0x8e098c('0x12'),'ContactId',_0x8e098c('0x3'),_0x8e098c('0x5b'),'createdAt',_0x8e098c('0x36')],squel[_0x8e098c('0x5e')]()[_0x8e098c('0x1c')](_0x8e098c('0x47'),_0x8e098c('0x3c'))[_0x8e098c('0x1c')](_0x8e098c('0x4f'),'scheduledAt')[_0x8e098c('0x1c')](_0x8e098c('0x41'),'ContactId')[_0x8e098c('0x1c')](_0x8e098c('0x4a'),_0x8e098c('0x3'))['field']('ANY_VALUE(VoiceQueueId)',_0x8e098c('0x5b'))[_0x8e098c('0x1c')](_0x8e098c('0x4f'),_0x8e098c('0x13'))[_0x8e098c('0x1c')](_0x8e098c('0x4f'),_0x8e098c('0x36'))[_0x8e098c('0x58')](_0x8e098c('0x11'))[_0x8e098c('0x35')](_0x8e098c('0x1a'),_0x218697[_0x8e098c('0x17')]['id'][_0x8e098c('0xf')]())[_0x8e098c('0x35')](_0x8e098c('0x23'),_0x218697[_0x8e098c('0x10')][_0x8e098c('0x2b')][_0x8e098c('0xf')]())[_0x8e098c('0x35')]('calleridnum\x20IS\x20NOT\x20NULL')[_0x8e098c('0x35')](_0x8e098c('0x2'),squel[_0x8e098c('0x5e')]()['field'](_0x8e098c('0x3c'))['from'](_0x8e098c('0x4e'))[_0x8e098c('0x35')](_0x8e098c('0x1a'),_0x218697[_0x8e098c('0x17')]['id'][_0x8e098c('0xf')]()))[_0x8e098c('0x35')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x8e098c('0x5e')]()[_0x8e098c('0x1c')]('calleridnum')[_0x8e098c('0x58')](_0x8e098c('0x11'))[_0x8e098c('0x35')](_0x8e098c('0x1a'),_0x218697[_0x8e098c('0x17')]['id']['toString']())[_0x8e098c('0x35')](_0x8e098c('0x2a')))['group'](_0x8e098c('0x5c')))['toString'](),db['sequelize']['query'](_0x42bb74);return[];})['then'](respondWithResult(_0x15164b,null))[_0x1943ce('0x18')](handleError(_0x15164b,null));},exports[_0x2ee6b2('0x1b')]=function(_0x39c50f,_0x301eb0){const _0x442e15=_0x2ee6b2;return db[_0x442e15('0xc')][_0x442e15('0x38')]({'where':{'id':_0x39c50f[_0x442e15('0x17')]['id']}})['then'](handleEntityNotFound(_0x301eb0,null))[_0x442e15('0x5f')](function(_0x4ac6ac){const _0x30f3e4=_0x442e15;let _0x1c6280;if(_0x4ac6ac)return _0x1c6280=squel[_0x30f3e4('0x3d')]()['into']('cm_hopper')[_0x30f3e4('0x32')]([_0x30f3e4('0x3c'),_0x30f3e4('0x12'),_0x30f3e4('0x5c'),'ListId',_0x30f3e4('0x9'),_0x30f3e4('0x13'),'updatedAt'],squel['select']()[_0x30f3e4('0x1c')](_0x30f3e4('0x47'),_0x30f3e4('0x3c'))[_0x30f3e4('0x1c')]('NOW()',_0x30f3e4('0x12'))[_0x30f3e4('0x1c')](_0x30f3e4('0x41'),_0x30f3e4('0x5c'))[_0x30f3e4('0x1c')](_0x30f3e4('0x4a'),_0x30f3e4('0x3'))[_0x30f3e4('0x1c')](_0x30f3e4('0x4c'),_0x30f3e4('0x9'))[_0x30f3e4('0x1c')]('NOW()',_0x30f3e4('0x13'))['field'](_0x30f3e4('0x4f'),_0x30f3e4('0x36'))[_0x30f3e4('0x58')](_0x30f3e4('0x11'))[_0x30f3e4('0x35')]('CampaignId\x20=\x20?',_0x39c50f[_0x30f3e4('0x17')]['id'][_0x30f3e4('0xf')]())['where'](_0x30f3e4('0x23'),_0x39c50f['body'][_0x30f3e4('0x2b')][_0x30f3e4('0xf')]())[_0x30f3e4('0x35')](_0x30f3e4('0x19'))[_0x30f3e4('0x35')](_0x30f3e4('0x2'),squel[_0x30f3e4('0x5e')]()[_0x30f3e4('0x1c')](_0x30f3e4('0x3c'))[_0x30f3e4('0x58')]('cm_hopper')[_0x30f3e4('0x35')]('CampaignId\x20=\x20?',_0x39c50f[_0x30f3e4('0x17')]['id'][_0x30f3e4('0xf')]()))[_0x30f3e4('0x35')](_0x30f3e4('0x2'),squel['select']()['field'](_0x30f3e4('0x21'))[_0x30f3e4('0x58')](_0x30f3e4('0x11'))[_0x30f3e4('0x35')]('CampaignId\x20=\x20?',_0x39c50f['params']['id'][_0x30f3e4('0xf')]())[_0x30f3e4('0x35')]('state\x20=\x204'))[_0x30f3e4('0x50')](_0x30f3e4('0x5c')))[_0x30f3e4('0xf')](),db[_0x30f3e4('0x59')][_0x30f3e4('0x16')](_0x1c6280);return[];})[_0x442e15('0x5f')](respondWithResult(_0x301eb0,null))[_0x442e15('0x18')](handleError(_0x301eb0,null));},exports[_0x2ee6b2('0x6')]=function(_0x6a721c,_0x28cdf){const _0x1ddcae=_0x2ee6b2;return db[_0x1ddcae('0x57')]['findOne']({'where':{'VoiceQueueId':_0x6a721c[_0x1ddcae('0x10')][_0x1ddcae('0x5b')],'CampaignId':_0x6a721c['body'][_0x1ddcae('0x9')],'ContactId':_0x6a721c['body']['ContactId']}})[_0x1ddcae('0x5f')](handleEntityNotFound(_0x28cdf,null))[_0x1ddcae('0x5f')](function(_0x1f1237){if(_0x1f1237)return _0x1f1237;return null;})[_0x1ddcae('0x5f')](respondWithResult(_0x28cdf,null))['catch'](handleError(_0x28cdf,null));};
\ No newline at end of file
+const a147_0x10db=['from','count','reCallContacts','includeAll','query','`state`\x20=\x2019,\x201,\x20null','ANY_VALUE(ContactId)','limit','offset','`state`\x20=\x2022,\x201,\x20null','rawAttributes','uniqueid','body','error','sequelize','calleridnum\x20NOT\x20IN\x20(?)','send','VoiceQueue','`state`\x20=\x203,\x201,\x20null','cm_hopper','ANY_VALUE(ListId)','abandonedContacts','scheduledAt','findOne','filter','phone','CampaignId','ANY_VALUE(VoiceQueueId)','catch','lodash','sendStatus','`state`\x20=\x208,\x201,\x20null','status','noAnswerContacts','pick','dropContacts','ContactId','group','model','rows','updatedAt','length','filters','Content-Range','createdAt','show','fields','into','ANY_VALUE(calleridnum)','index','calleridnum\x20IS\x20NOT\x20NULL','checkContactHopper','ListId','CampaignId\x20=\x20?','params','busyContacts','answeringMachine','field','attributes','`state`\x20=\x200,\x201,\x20null','countContactsIvrCampaignHopperFinal','include','calleridnum','key','toString','countContactsQueueCampaignHopperFinal','sort','nolimit','describe','COUNT','cm_hopper_final','NOW()','`state`\x20=\x2010\x20,\x201,\x20null','json','state\x20=\x204','api','VoiceQueueId\x20=\x20?','fieldName','keys','findAll','Campaign','select','where','type','squel','name','order','intersection','map','moveContactsQueueCampaignHopperFinal','merge','VoiceQueueId','options','update','../../mysqldb','state\x20=\x20?','moveContactsIvrCampaignHopperFinal','then','congestionContacts','like','CmHopperFinal','`state`\x20=\x2011\x20,\x201,\x20null','set','`state`\x20=\x205,\x201,\x20null'];(function(_0x3205de,_0x10db6e){const _0x285f9f=function(_0x5ddac7){while(--_0x5ddac7){_0x3205de['push'](_0x3205de['shift']());}};_0x285f9f(++_0x10db6e);}(a147_0x10db,0x1c4));const a147_0x285f=function(_0x3205de,_0x10db6e){_0x3205de=_0x3205de-0x0;let _0x285f9f=a147_0x10db[_0x3205de];return _0x285f9f;};const _0x594b1d=a147_0x285f;'use strict';const _=require(_0x594b1d('0x61')),squel=require(_0x594b1d('0x30')),qs=require('../../components/parsers/qs'),logger=require('../../config/logger')(_0x594b1d('0x27')),db=require(_0x594b1d('0x3a'))['db'],{Op,fn,literal}=require(_0x594b1d('0x52'));function respondWithResult(_0x5ddac7,_0x225c17){return _0x225c17=_0x225c17||0xc8,function(_0x483785){const _0x30c21d=a147_0x285f;if(_0x483785)return _0x5ddac7['status'](_0x225c17)[_0x30c21d('0x25')](_0x483785);};}function respondWithFilteredResult(_0x2ce4f1,_0x287b48){return function(_0x5104d2){const _0x34ab3b=a147_0x285f;if(_0x5104d2){const _0x24d0ee=_0x5104d2['count'],_0xbc7159=_0x287b48['offset'];let _0x3ac687=_0x287b48['offset']+_0x287b48[_0x34ab3b('0x4b')],_0x33237a;return _0x3ac687>=_0x24d0ee?(_0x3ac687=_0x24d0ee,_0x33237a=0xc8):_0x33237a=0xce,_0x2ce4f1[_0x34ab3b('0x64')](_0x33237a),_0x2ce4f1[_0x34ab3b('0x42')](_0x34ab3b('0x7'),_0xbc7159+'-'+_0x3ac687+'/'+_0x24d0ee)['json'](_0x5104d2);}return null;};}function saveUpdates(_0x367905){return function(_0xe06aa7){const _0x494542=a147_0x285f;if(_0xe06aa7)return _0xe06aa7[_0x494542('0x39')](_0x367905)[_0x494542('0x3d')](function(_0x2e6a31){return _0x2e6a31;});return null;};}function handleEntityNotFound(_0x81d0aa){return function(_0x43e69a){const _0xaf88f6=a147_0x285f;return!_0x43e69a&&_0x81d0aa[_0xaf88f6('0x62')](0x194),_0x43e69a;};}function handleError(_0x2cd20a,_0x5ea7f8){return _0x5ea7f8=_0x5ea7f8||0x1f4,function(_0x53173d){const _0x4b4ef6=a147_0x285f;logger[_0x4b4ef6('0x51')](_0x53173d['stack']),_0x53173d['name']&&delete _0x53173d[_0x4b4ef6('0x31')],_0x2cd20a[_0x4b4ef6('0x64')](_0x5ea7f8)[_0x4b4ef6('0x54')](_0x53173d);};}exports[_0x594b1d('0xd')]=function(_0x281536,_0x31839a){const _0x59c8ca=_0x594b1d;let _0x2a2fda={};const _0x4eaa08={},_0x41cc66={'count':0x0,'rows':[]},_0x291d9b=_[_0x59c8ca('0x34')](db[_0x59c8ca('0x40')][_0x59c8ca('0x4e')],function(_0x2223c4){const _0x202b62=_0x59c8ca;return{'name':_0x2223c4[_0x202b62('0x29')],'type':_0x2223c4[_0x202b62('0x2f')][_0x202b62('0x1b')]};});_0x4eaa08[_0x59c8ca('0x2')]=_[_0x59c8ca('0x34')](_0x291d9b,_0x59c8ca('0x31')),_0x4eaa08[_0x59c8ca('0x48')]=_[_0x59c8ca('0x2a')](_0x281536[_0x59c8ca('0x48')]),_0x4eaa08[_0x59c8ca('0x6')]=_[_0x59c8ca('0x33')](_0x4eaa08[_0x59c8ca('0x2')],_0x4eaa08['query']),_0x2a2fda[_0x59c8ca('0x16')]=_[_0x59c8ca('0x33')](_0x4eaa08[_0x59c8ca('0x2')],qs['fields'](_0x281536[_0x59c8ca('0x48')][_0x59c8ca('0xa')])),_0x2a2fda[_0x59c8ca('0x16')]=_0x2a2fda[_0x59c8ca('0x16')]['length']?_0x2a2fda[_0x59c8ca('0x16')]:_0x4eaa08[_0x59c8ca('0x2')];typeof _0x281536['query'][_0x59c8ca('0x1f')]==='undefined'&&(_0x2a2fda[_0x59c8ca('0x4b')]=qs['limit'](_0x281536['query'][_0x59c8ca('0x4b')]),_0x2a2fda[_0x59c8ca('0x4c')]=qs[_0x59c8ca('0x4c')](_0x281536[_0x59c8ca('0x48')]['offset']));_0x2a2fda[_0x59c8ca('0x32')]=qs['sort'](_0x281536['query'][_0x59c8ca('0x1e')]),_0x2a2fda[_0x59c8ca('0x2e')]=qs[_0x59c8ca('0x6')](_[_0x59c8ca('0x66')](_0x281536[_0x59c8ca('0x48')],_0x4eaa08[_0x59c8ca('0x6')]),_0x291d9b);_0x281536['query'][_0x59c8ca('0x5c')]&&(_0x2a2fda[_0x59c8ca('0x2e')]=_['merge'](_0x2a2fda[_0x59c8ca('0x2e')],{[Op['or']]:_['map'](_0x291d9b,function(_0x28e74b){const _0x14e8b3=_0x59c8ca;if(_0x28e74b[_0x14e8b3('0x2f')]!=='VIRTUAL'){const _0x3d7fd={};return _0x3d7fd[_0x28e74b['name']]={[Op[_0x14e8b3('0x3f')]]:'%'+_0x281536['query'][_0x14e8b3('0x5c')]+'%'},_0x3d7fd;}})}));_0x2a2fda=_[_0x59c8ca('0x36')]({},_0x2a2fda,_0x281536[_0x59c8ca('0x38')]);const _0x5aa520={'where':_0x2a2fda['where']};return db[_0x59c8ca('0x40')][_0x59c8ca('0x45')](_0x5aa520)[_0x59c8ca('0x3d')](function(_0xb0067b){const _0x317813=_0x59c8ca;return _0x41cc66[_0x317813('0x45')]=_0xb0067b,_0x281536[_0x317813('0x48')][_0x317813('0x47')]&&(_0x2a2fda[_0x317813('0x19')]=[{'all':!![]}]),db[_0x317813('0x40')]['findAll'](_0x2a2fda);})[_0x59c8ca('0x3d')](function(_0x865cd0){const _0x139115=_0x59c8ca;return _0x41cc66[_0x139115('0x3')]=_0x865cd0,_0x41cc66;})[_0x59c8ca('0x3d')](respondWithFilteredResult(_0x31839a,_0x2a2fda))[_0x59c8ca('0x60')](handleError(_0x31839a,null));},exports[_0x594b1d('0x9')]=function(_0x87eacf,_0x59c1a4){const _0x324497=_0x594b1d;let _0x431694={'raw':!![],'where':{'id':_0x87eacf[_0x324497('0x12')]['id']}};const _0xed7ff8={};return _0xed7ff8[_0x324497('0x2')]=_['keys'](db[_0x324497('0x40')][_0x324497('0x4e')]),_0xed7ff8[_0x324497('0x48')]=_[_0x324497('0x2a')](_0x87eacf[_0x324497('0x48')]),_0xed7ff8[_0x324497('0x6')]=_['intersection'](_0xed7ff8[_0x324497('0x2')],_0xed7ff8[_0x324497('0x48')]),_0x431694[_0x324497('0x16')]=_['intersection'](_0xed7ff8['model'],qs[_0x324497('0xa')](_0x87eacf[_0x324497('0x48')][_0x324497('0xa')])),_0x431694[_0x324497('0x16')]=_0x431694[_0x324497('0x16')][_0x324497('0x5')]?_0x431694[_0x324497('0x16')]:_0xed7ff8['model'],_0x87eacf[_0x324497('0x48')][_0x324497('0x47')]&&(_0x431694[_0x324497('0x19')]=[{'all':!![]}]),_0x431694=_[_0x324497('0x36')]({},_0x431694,_0x87eacf[_0x324497('0x38')]),db[_0x324497('0x40')][_0x324497('0x5b')](_0x431694)[_0x324497('0x3d')](handleEntityNotFound(_0x59c1a4,null))[_0x324497('0x3d')](respondWithResult(_0x59c1a4,null))[_0x324497('0x60')](handleError(_0x59c1a4,null));},exports[_0x594b1d('0x20')]=function(_0x38fd5c,_0x4dbbb4){const _0x1cd190=_0x594b1d;return db[_0x1cd190('0x40')][_0x1cd190('0x20')]()['then'](respondWithResult(_0x4dbbb4,null))[_0x1cd190('0x60')](handleError(_0x4dbbb4,null));},exports[_0x594b1d('0x39')]=function(_0x26aa91,_0x36d67c){const _0x3e810c=_0x594b1d;return _0x26aa91[_0x3e810c('0x50')][_0x3e810c('0x4f')]&&delete _0x26aa91['body'][_0x3e810c('0x4f')],db['CmHopperFinal'][_0x3e810c('0x5b')]({'where':{'uniqueid':_0x26aa91[_0x3e810c('0x12')]['id']}})[_0x3e810c('0x3d')](handleEntityNotFound(_0x36d67c,null))['then'](saveUpdates(_0x26aa91['body'],null))['then'](respondWithResult(_0x36d67c,null))[_0x3e810c('0x60')](handleError(_0x36d67c,null));},exports[_0x594b1d('0x1d')]=function(_0x50aa61,_0x431875){const _0x1009a7=_0x594b1d;return db[_0x1009a7('0x40')][_0x1009a7('0x2b')]({'raw':![],'where':{'VoiceQueueId':_0x50aa61[_0x1009a7('0x12')]['id']},'attributes':[[fn(_0x1009a7('0x21'),fn('IF',literal(_0x1009a7('0x17')))),'noSuchContacts'],[fn(_0x1009a7('0x21'),fn('IF',literal(_0x1009a7('0x56')))),_0x1009a7('0x65')],[fn('COUNT',fn('IF',literal('`state`\x20=\x205,\x201,\x20null'))),'busyContacts'],[fn(_0x1009a7('0x21'),fn('IF',literal(_0x1009a7('0x63')))),_0x1009a7('0x3e')],[fn('COUNT',fn('IF',literal('`state`\x20=\x2010\x20,\x201,\x20null'))),'dropContacts'],[fn(_0x1009a7('0x21'),fn('IF',literal(_0x1009a7('0x41')))),_0x1009a7('0x59')],[fn(_0x1009a7('0x21'),fn('IF',literal(_0x1009a7('0x4d')))),_0x1009a7('0x46')],[fn('COUNT',fn('IF',literal(_0x1009a7('0x49')))),'answeringMachine']]})[_0x1009a7('0x3d')](handleEntityNotFound(_0x431875,null))[_0x1009a7('0x3d')](respondWithResult(_0x431875,null))['catch'](handleError(_0x431875,null));},exports[_0x594b1d('0x18')]=function(_0x1b460f,_0xb777a6){const _0x46315b=_0x594b1d;return db[_0x46315b('0x40')]['findAll']({'raw':![],'where':{'CampaignId':_0x1b460f[_0x46315b('0x12')]['id']},'attributes':[[fn(_0x46315b('0x21'),fn('IF',literal('`state`\x20=\x200,\x201,\x20null'))),'noSuchContacts'],[fn('COUNT',fn('IF',literal(_0x46315b('0x56')))),'noAnswerContacts'],[fn(_0x46315b('0x21'),fn('IF',literal(_0x46315b('0x43')))),_0x46315b('0x13')],[fn('COUNT',fn('IF',literal('`state`\x20=\x208,\x201,\x20null'))),'congestionContacts'],[fn(_0x46315b('0x21'),fn('IF',literal(_0x46315b('0x24')))),_0x46315b('0x67')],[fn(_0x46315b('0x21'),fn('IF',literal(_0x46315b('0x41')))),_0x46315b('0x59')],[fn(_0x46315b('0x21'),fn('IF',literal(_0x46315b('0x4d')))),_0x46315b('0x46')],[fn(_0x46315b('0x21'),fn('IF',literal(_0x46315b('0x49')))),_0x46315b('0x14')]]})[_0x46315b('0x3d')](handleEntityNotFound(_0xb777a6,null))[_0x46315b('0x3d')](respondWithResult(_0xb777a6,null))[_0x46315b('0x60')](handleError(_0xb777a6,null));},exports[_0x594b1d('0x35')]=function(_0x99e8f3,_0x399326){const _0x450a5c=_0x594b1d;return db[_0x450a5c('0x55')][_0x450a5c('0x5b')]({'where':{'id':_0x99e8f3[_0x450a5c('0x12')]['id']}})['then'](handleEntityNotFound(_0x399326,null))['then'](function(_0x4662ca){const _0x3da89c=_0x450a5c;let _0x3d41ec;if(_0x4662ca)return _0x3d41ec=squel['insert']()[_0x3da89c('0xb')](_0x3da89c('0x57'))['fromQuery']([_0x3da89c('0x5d'),_0x3da89c('0x5a'),'ContactId',_0x3da89c('0x10'),_0x3da89c('0x37'),_0x3da89c('0x8'),_0x3da89c('0x4')],squel[_0x3da89c('0x2d')]()['field'](_0x3da89c('0xc'),_0x3da89c('0x5d'))[_0x3da89c('0x15')](_0x3da89c('0x23'),'scheduledAt')[_0x3da89c('0x15')](_0x3da89c('0x4a'),_0x3da89c('0x0'))[_0x3da89c('0x15')](_0x3da89c('0x58'),_0x3da89c('0x10'))['field'](_0x3da89c('0x5f'),'VoiceQueueId')[_0x3da89c('0x15')](_0x3da89c('0x23'),_0x3da89c('0x8'))[_0x3da89c('0x15')]('NOW()','updatedAt')['from']('cm_hopper_final')[_0x3da89c('0x2e')](_0x3da89c('0x28'),_0x99e8f3[_0x3da89c('0x12')]['id']['toString']())[_0x3da89c('0x2e')](_0x3da89c('0x3b'),_0x99e8f3[_0x3da89c('0x50')]['state'][_0x3da89c('0x1c')]())['where']('calleridnum\x20IS\x20NOT\x20NULL')[_0x3da89c('0x2e')](_0x3da89c('0x53'),squel[_0x3da89c('0x2d')]()[_0x3da89c('0x15')](_0x3da89c('0x5d'))['from'](_0x3da89c('0x57'))[_0x3da89c('0x2e')]('VoiceQueueId\x20=\x20?',_0x99e8f3[_0x3da89c('0x12')]['id'][_0x3da89c('0x1c')]()))[_0x3da89c('0x2e')](_0x3da89c('0x53'),squel[_0x3da89c('0x2d')]()['field'](_0x3da89c('0x1a'))[_0x3da89c('0x44')](_0x3da89c('0x22'))[_0x3da89c('0x2e')](_0x3da89c('0x28'),_0x99e8f3[_0x3da89c('0x12')]['id'][_0x3da89c('0x1c')]())[_0x3da89c('0x2e')](_0x3da89c('0x26')))[_0x3da89c('0x1')](_0x3da89c('0x0')))[_0x3da89c('0x1c')](),db[_0x3da89c('0x52')][_0x3da89c('0x48')](_0x3d41ec);return[];})[_0x450a5c('0x3d')](respondWithResult(_0x399326,null))['catch'](handleError(_0x399326,null));},exports[_0x594b1d('0x3c')]=function(_0x3a2efb,_0xc718ca){const _0x2c4542=_0x594b1d;return db[_0x2c4542('0x2c')][_0x2c4542('0x5b')]({'where':{'id':_0x3a2efb[_0x2c4542('0x12')]['id']}})['then'](handleEntityNotFound(_0xc718ca,null))['then'](function(_0x13ee64){const _0x4ebeaa=_0x2c4542;let _0x5c0339;if(_0x13ee64)return _0x5c0339=squel['insert']()[_0x4ebeaa('0xb')](_0x4ebeaa('0x57'))['fromQuery']([_0x4ebeaa('0x5d'),'scheduledAt','ContactId',_0x4ebeaa('0x10'),_0x4ebeaa('0x5e'),_0x4ebeaa('0x8'),_0x4ebeaa('0x4')],squel[_0x4ebeaa('0x2d')]()[_0x4ebeaa('0x15')](_0x4ebeaa('0xc'),_0x4ebeaa('0x5d'))[_0x4ebeaa('0x15')]('NOW()',_0x4ebeaa('0x5a'))['field'](_0x4ebeaa('0x4a'),'ContactId')[_0x4ebeaa('0x15')](_0x4ebeaa('0x58'),_0x4ebeaa('0x10'))[_0x4ebeaa('0x15')]('ANY_VALUE(CampaignId)',_0x4ebeaa('0x5e'))['field'](_0x4ebeaa('0x23'),_0x4ebeaa('0x8'))[_0x4ebeaa('0x15')](_0x4ebeaa('0x23'),'updatedAt')['from'](_0x4ebeaa('0x22'))['where'](_0x4ebeaa('0x11'),_0x3a2efb[_0x4ebeaa('0x12')]['id']['toString']())[_0x4ebeaa('0x2e')](_0x4ebeaa('0x3b'),_0x3a2efb[_0x4ebeaa('0x50')]['state']['toString']())['where'](_0x4ebeaa('0xe'))[_0x4ebeaa('0x2e')](_0x4ebeaa('0x53'),squel[_0x4ebeaa('0x2d')]()['field'](_0x4ebeaa('0x5d'))[_0x4ebeaa('0x44')](_0x4ebeaa('0x57'))[_0x4ebeaa('0x2e')]('CampaignId\x20=\x20?',_0x3a2efb[_0x4ebeaa('0x12')]['id'][_0x4ebeaa('0x1c')]()))[_0x4ebeaa('0x2e')](_0x4ebeaa('0x53'),squel[_0x4ebeaa('0x2d')]()['field'](_0x4ebeaa('0x1a'))[_0x4ebeaa('0x44')](_0x4ebeaa('0x22'))[_0x4ebeaa('0x2e')](_0x4ebeaa('0x11'),_0x3a2efb[_0x4ebeaa('0x12')]['id'][_0x4ebeaa('0x1c')]())[_0x4ebeaa('0x2e')](_0x4ebeaa('0x26')))[_0x4ebeaa('0x1')]('ContactId'))[_0x4ebeaa('0x1c')](),db['sequelize'][_0x4ebeaa('0x48')](_0x5c0339);return[];})[_0x2c4542('0x3d')](respondWithResult(_0xc718ca,null))[_0x2c4542('0x60')](handleError(_0xc718ca,null));},exports[_0x594b1d('0xf')]=function(_0x3c6e8e,_0x198b8e){const _0xa4ffd1=_0x594b1d;return db['CmHopper'][_0xa4ffd1('0x5b')]({'where':{'VoiceQueueId':_0x3c6e8e[_0xa4ffd1('0x50')][_0xa4ffd1('0x37')],'CampaignId':_0x3c6e8e[_0xa4ffd1('0x50')][_0xa4ffd1('0x5e')],'ContactId':_0x3c6e8e[_0xa4ffd1('0x50')][_0xa4ffd1('0x0')]}})[_0xa4ffd1('0x3d')](handleEntityNotFound(_0x198b8e,null))[_0xa4ffd1('0x3d')](function(_0xf0120a){if(_0xf0120a)return _0xf0120a;return null;})[_0xa4ffd1('0x3d')](respondWithResult(_0x198b8e,null))['catch'](handleError(_0x198b8e,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff