1 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));};
git://repos.xcallymotion.com / motion-next.git / blob