1 const a147_0x282c=['catch','attributes','intersection','countContactsIvrCampaignHopperFinal','length','state\x20=\x204','api','from','CmHopperFinal','ANY_VALUE(VoiceQueueId)','undefined','offset','fromQuery','order','update','busyContacts','Content-Range','VoiceQueueId','findOne','sequelize','type','sort','calleridnum','CampaignId\x20=\x20?','state\x20=\x20?','stack','CampaignId','abandonedContacts','into','noAnswerContacts','ListId','filter','VoiceQueueId\x20=\x20?','body','select','then','moveContactsIvrCampaignHopperFinal','merge','pick','ContactId','`state`\x20=\x2019,\x201,\x20null','describe','dropContacts','phone','group','nolimit','VoiceQueue','congestionContacts','includeAll','findAll','fieldName','send','VIRTUAL','`state`\x20=\x2022,\x201,\x20null','status','include','options','limit','name','calleridnum\x20IS\x20NOT\x20NULL','answeringMachine','fields','map','ANY_VALUE(CampaignId)','`state`\x20=\x2011\x20,\x201,\x20null','model','createdAt','NOW()','`state`\x20=\x208,\x201,\x20null','rows','Campaign','squel','ANY_VALUE(ContactId)','query','insert','where','toString','`state`\x20=\x205,\x201,\x20null','noSuchContacts','countContactsQueueCampaignHopperFinal','updatedAt','COUNT','like','count','calleridnum\x20NOT\x20IN\x20(?)','error','index','reCallContacts','cm_hopper_final','`state`\x20=\x2010\x20,\x201,\x20null','json','uniqueid','rawAttributes','`state`\x20=\x200,\x201,\x20null','cm_hopper','field','state','scheduledAt','params','ANY_VALUE(ListId)','key','`state`\x20=\x203,\x201,\x20null','keys','filters'];(function(_0x2ca019,_0x282c45){const _0x5ded1a=function(_0x506fbd){while(--_0x506fbd){_0x2ca019['push'](_0x2ca019['shift']());}};_0x5ded1a(++_0x282c45);}(a147_0x282c,0x15a));const a147_0x5ded=function(_0x2ca019,_0x282c45){_0x2ca019=_0x2ca019-0x0;let _0x5ded1a=a147_0x282c[_0x2ca019];return _0x5ded1a;};const _0x4301f5=a147_0x5ded;'use strict';const _=require('lodash'),squel=require(_0x4301f5('0x25')),qs=require('../../components/parsers/qs'),logger=require('../../config/logger')(_0x4301f5('0x4c')),db=require('../../mysqldb')['db'],{Op,fn,literal}=require('sequelize');function respondWithResult(_0x506fbd,_0x55bf10){return _0x55bf10=_0x55bf10||0xc8,function(_0x443b42){const _0x5223de=a147_0x5ded;if(_0x443b42)return _0x506fbd[_0x5223de('0x14')](_0x55bf10)[_0x5223de('0x38')](_0x443b42);};}function respondWithFilteredResult(_0x2b2aea,_0x287182){return function(_0x34fef5){const _0x1d0d6c=a147_0x5ded;if(_0x34fef5){const _0x81f8ee=_0x34fef5[_0x1d0d6c('0x31')],_0x5d705b=_0x287182['offset'];let _0x5337f4=_0x287182[_0x1d0d6c('0x51')]+_0x287182[_0x1d0d6c('0x17')],_0x406ec9;return _0x5337f4>=_0x81f8ee?(_0x5337f4=_0x81f8ee,_0x406ec9=0xc8):_0x406ec9=0xce,_0x2b2aea['status'](_0x406ec9),_0x2b2aea['set'](_0x1d0d6c('0x56'),_0x5d705b+'-'+_0x5337f4+'/'+_0x81f8ee)[_0x1d0d6c('0x38')](_0x34fef5);}return null;};}function saveUpdates(_0x57451c){return function(_0x4cd9d7){const _0xc7c419=a147_0x5ded;if(_0x4cd9d7)return _0x4cd9d7[_0xc7c419('0x54')](_0x57451c)[_0xc7c419('0x1')](function(_0x576cd9){return _0x576cd9;});return null;};}function handleEntityNotFound(_0x49cde6){return function(_0x4fd225){return!_0x4fd225&&_0x49cde6['sendStatus'](0x194),_0x4fd225;};}function handleError(_0x2380d0,_0x351653){return _0x351653=_0x351653||0x1f4,function(_0x311b86){const _0x2bea3b=a147_0x5ded;logger[_0x2bea3b('0x33')](_0x311b86[_0x2bea3b('0x5f')]),_0x311b86['name']&&delete _0x311b86[_0x2bea3b('0x18')],_0x2380d0[_0x2bea3b('0x14')](_0x351653)[_0x2bea3b('0x11')](_0x311b86);};}exports[_0x4301f5('0x34')]=function(_0x8411e6,_0x1ecd30){const _0x2f43a3=_0x4301f5;let _0x2183c6={};const _0x194542={},_0x2e3e3b={'count':0x0,'rows':[]},_0x370007=_['map'](db[_0x2f43a3('0x4e')][_0x2f43a3('0x3a')],function(_0x5a1e85){const _0xbb5731=_0x2f43a3;return{'name':_0x5a1e85[_0xbb5731('0x10')],'type':_0x5a1e85[_0xbb5731('0x5a')][_0xbb5731('0x42')]};});_0x194542[_0x2f43a3('0x1f')]=_[_0x2f43a3('0x1c')](_0x370007,_0x2f43a3('0x18')),_0x194542[_0x2f43a3('0x27')]=_[_0x2f43a3('0x44')](_0x8411e6[_0x2f43a3('0x27')]),_0x194542[_0x2f43a3('0x45')]=_[_0x2f43a3('0x48')](_0x194542[_0x2f43a3('0x1f')],_0x194542[_0x2f43a3('0x27')]),_0x2183c6[_0x2f43a3('0x47')]=_[_0x2f43a3('0x48')](_0x194542[_0x2f43a3('0x1f')],qs[_0x2f43a3('0x1b')](_0x8411e6[_0x2f43a3('0x27')][_0x2f43a3('0x1b')])),_0x2183c6[_0x2f43a3('0x47')]=_0x2183c6[_0x2f43a3('0x47')][_0x2f43a3('0x4a')]?_0x2183c6[_0x2f43a3('0x47')]:_0x194542['model'];typeof _0x8411e6[_0x2f43a3('0x27')][_0x2f43a3('0xb')]===_0x2f43a3('0x50')&&(_0x2183c6[_0x2f43a3('0x17')]=qs['limit'](_0x8411e6[_0x2f43a3('0x27')][_0x2f43a3('0x17')]),_0x2183c6[_0x2f43a3('0x51')]=qs['offset'](_0x8411e6[_0x2f43a3('0x27')]['offset']));_0x2183c6[_0x2f43a3('0x53')]=qs[_0x2f43a3('0x5b')](_0x8411e6[_0x2f43a3('0x27')][_0x2f43a3('0x5b')]),_0x2183c6[_0x2f43a3('0x29')]=qs[_0x2f43a3('0x45')](_[_0x2f43a3('0x4')](_0x8411e6[_0x2f43a3('0x27')],_0x194542[_0x2f43a3('0x45')]),_0x370007);_0x8411e6['query'][_0x2f43a3('0x65')]&&(_0x2183c6[_0x2f43a3('0x29')]=_[_0x2f43a3('0x3')](_0x2183c6['where'],{[Op['or']]:_[_0x2f43a3('0x1c')](_0x370007,function(_0x38567d){const _0x395991=_0x2f43a3;if(_0x38567d[_0x395991('0x5a')]!==_0x395991('0x12')){const _0xf665bb={};return _0xf665bb[_0x38567d[_0x395991('0x18')]]={[Op[_0x395991('0x30')]]:'%'+_0x8411e6[_0x395991('0x27')][_0x395991('0x65')]+'%'},_0xf665bb;}})}));_0x2183c6=_['merge']({},_0x2183c6,_0x8411e6['options']);const _0x38dd14={'where':_0x2183c6[_0x2f43a3('0x29')]};return db[_0x2f43a3('0x4e')][_0x2f43a3('0x31')](_0x38dd14)['then'](function(_0x4d8936){const _0x2c092d=_0x2f43a3;return _0x2e3e3b['count']=_0x4d8936,_0x8411e6[_0x2c092d('0x27')][_0x2c092d('0xe')]&&(_0x2183c6[_0x2c092d('0x15')]=[{'all':!![]}]),db[_0x2c092d('0x4e')][_0x2c092d('0xf')](_0x2183c6);})['then'](function(_0x4a3c11){const _0x360094=_0x2f43a3;return _0x2e3e3b[_0x360094('0x23')]=_0x4a3c11,_0x2e3e3b;})[_0x2f43a3('0x1')](respondWithFilteredResult(_0x1ecd30,_0x2183c6))[_0x2f43a3('0x46')](handleError(_0x1ecd30,null));},exports['show']=function(_0x3aa253,_0x4218fe){const _0x54df26=_0x4301f5;let _0x5cb219={'raw':!![],'where':{'id':_0x3aa253[_0x54df26('0x40')]['id']}};const _0x322ffc={};return _0x322ffc[_0x54df26('0x1f')]=_[_0x54df26('0x44')](db[_0x54df26('0x4e')][_0x54df26('0x3a')]),_0x322ffc[_0x54df26('0x27')]=_[_0x54df26('0x44')](_0x3aa253['query']),_0x322ffc[_0x54df26('0x45')]=_[_0x54df26('0x48')](_0x322ffc[_0x54df26('0x1f')],_0x322ffc[_0x54df26('0x27')]),_0x5cb219[_0x54df26('0x47')]=_[_0x54df26('0x48')](_0x322ffc[_0x54df26('0x1f')],qs[_0x54df26('0x1b')](_0x3aa253[_0x54df26('0x27')]['fields'])),_0x5cb219[_0x54df26('0x47')]=_0x5cb219[_0x54df26('0x47')][_0x54df26('0x4a')]?_0x5cb219[_0x54df26('0x47')]:_0x322ffc['model'],_0x3aa253[_0x54df26('0x27')][_0x54df26('0xe')]&&(_0x5cb219[_0x54df26('0x15')]=[{'all':!![]}]),_0x5cb219=_[_0x54df26('0x3')]({},_0x5cb219,_0x3aa253[_0x54df26('0x16')]),db['CmHopperFinal'][_0x54df26('0x58')](_0x5cb219)[_0x54df26('0x1')](handleEntityNotFound(_0x4218fe,null))[_0x54df26('0x1')](respondWithResult(_0x4218fe,null))[_0x54df26('0x46')](handleError(_0x4218fe,null));},exports[_0x4301f5('0x7')]=function(_0x273c20,_0x1547f3){const _0x1e01c5=_0x4301f5;return db[_0x1e01c5('0x4e')]['describe']()[_0x1e01c5('0x1')](respondWithResult(_0x1547f3,null))[_0x1e01c5('0x46')](handleError(_0x1547f3,null));},exports['update']=function(_0x8089fe,_0x438d59){const _0x34805c=_0x4301f5;return _0x8089fe[_0x34805c('0x67')]['uniqueid']&&delete _0x8089fe[_0x34805c('0x67')][_0x34805c('0x39')],db[_0x34805c('0x4e')]['findOne']({'where':{'uniqueid':_0x8089fe['params']['id']}})[_0x34805c('0x1')](handleEntityNotFound(_0x438d59,null))[_0x34805c('0x1')](saveUpdates(_0x8089fe[_0x34805c('0x67')],null))[_0x34805c('0x1')](respondWithResult(_0x438d59,null))[_0x34805c('0x46')](handleError(_0x438d59,null));},exports[_0x4301f5('0x2d')]=function(_0x144269,_0x2c2a7e){const _0x38a21b=_0x4301f5;return db[_0x38a21b('0x4e')]['findAll']({'raw':![],'where':{'VoiceQueueId':_0x144269[_0x38a21b('0x40')]['id']},'attributes':[[fn(_0x38a21b('0x2f'),fn('IF',literal('`state`\x20=\x200,\x201,\x20null'))),_0x38a21b('0x2c')],[fn(_0x38a21b('0x2f'),fn('IF',literal(_0x38a21b('0x43')))),_0x38a21b('0x63')],[fn(_0x38a21b('0x2f'),fn('IF',literal(_0x38a21b('0x2b')))),_0x38a21b('0x55')],[fn(_0x38a21b('0x2f'),fn('IF',literal(_0x38a21b('0x22')))),_0x38a21b('0xd')],[fn('COUNT',fn('IF',literal(_0x38a21b('0x37')))),'dropContacts'],[fn(_0x38a21b('0x2f'),fn('IF',literal('`state`\x20=\x2011\x20,\x201,\x20null'))),_0x38a21b('0x61')],[fn('COUNT',fn('IF',literal('`state`\x20=\x2022,\x201,\x20null'))),_0x38a21b('0x35')],[fn(_0x38a21b('0x2f'),fn('IF',literal(_0x38a21b('0x6')))),_0x38a21b('0x1a')]]})[_0x38a21b('0x1')](handleEntityNotFound(_0x2c2a7e,null))[_0x38a21b('0x1')](respondWithResult(_0x2c2a7e,null))[_0x38a21b('0x46')](handleError(_0x2c2a7e,null));},exports[_0x4301f5('0x49')]=function(_0x132544,_0x5bfd48){const _0x4dc5fd=_0x4301f5;return db[_0x4dc5fd('0x4e')]['findAll']({'raw':![],'where':{'CampaignId':_0x132544[_0x4dc5fd('0x40')]['id']},'attributes':[[fn(_0x4dc5fd('0x2f'),fn('IF',literal(_0x4dc5fd('0x3b')))),_0x4dc5fd('0x2c')],[fn(_0x4dc5fd('0x2f'),fn('IF',literal(_0x4dc5fd('0x43')))),_0x4dc5fd('0x63')],[fn(_0x4dc5fd('0x2f'),fn('IF',literal(_0x4dc5fd('0x2b')))),_0x4dc5fd('0x55')],[fn('COUNT',fn('IF',literal(_0x4dc5fd('0x22')))),'congestionContacts'],[fn(_0x4dc5fd('0x2f'),fn('IF',literal(_0x4dc5fd('0x37')))),_0x4dc5fd('0x8')],[fn(_0x4dc5fd('0x2f'),fn('IF',literal(_0x4dc5fd('0x1e')))),_0x4dc5fd('0x61')],[fn(_0x4dc5fd('0x2f'),fn('IF',literal(_0x4dc5fd('0x13')))),_0x4dc5fd('0x35')],[fn('COUNT',fn('IF',literal(_0x4dc5fd('0x6')))),_0x4dc5fd('0x1a')]]})[_0x4dc5fd('0x1')](handleEntityNotFound(_0x5bfd48,null))[_0x4dc5fd('0x1')](respondWithResult(_0x5bfd48,null))[_0x4dc5fd('0x46')](handleError(_0x5bfd48,null));},exports['moveContactsQueueCampaignHopperFinal']=function(_0x29f9df,_0x5d7449){const _0x268ba1=_0x4301f5;return db[_0x268ba1('0xc')][_0x268ba1('0x58')]({'where':{'id':_0x29f9df[_0x268ba1('0x40')]['id']}})[_0x268ba1('0x1')](handleEntityNotFound(_0x5d7449,null))[_0x268ba1('0x1')](function(_0x178899){const _0x46232a=_0x268ba1;let _0x1d4849;if(_0x178899)return _0x1d4849=squel['insert']()[_0x46232a('0x62')](_0x46232a('0x3c'))[_0x46232a('0x52')]([_0x46232a('0x9'),_0x46232a('0x3f'),_0x46232a('0x5'),'ListId',_0x46232a('0x57'),_0x46232a('0x20'),_0x46232a('0x2e')],squel[_0x46232a('0x0')]()[_0x46232a('0x3d')]('ANY_VALUE(calleridnum)','phone')['field'](_0x46232a('0x21'),_0x46232a('0x3f'))[_0x46232a('0x3d')](_0x46232a('0x26'),'ContactId')['field'](_0x46232a('0x41'),_0x46232a('0x64'))[_0x46232a('0x3d')](_0x46232a('0x4f'),_0x46232a('0x57'))['field']('NOW()',_0x46232a('0x20'))[_0x46232a('0x3d')]('NOW()',_0x46232a('0x2e'))[_0x46232a('0x4d')]('cm_hopper_final')['where'](_0x46232a('0x66'),_0x29f9df[_0x46232a('0x40')]['id'][_0x46232a('0x2a')]())['where'](_0x46232a('0x5e'),_0x29f9df[_0x46232a('0x67')][_0x46232a('0x3e')][_0x46232a('0x2a')]())[_0x46232a('0x29')]('calleridnum\x20IS\x20NOT\x20NULL')[_0x46232a('0x29')](_0x46232a('0x32'),squel[_0x46232a('0x0')]()[_0x46232a('0x3d')](_0x46232a('0x9'))[_0x46232a('0x4d')]('cm_hopper')[_0x46232a('0x29')](_0x46232a('0x66'),_0x29f9df[_0x46232a('0x40')]['id'][_0x46232a('0x2a')]()))[_0x46232a('0x29')](_0x46232a('0x32'),squel['select']()[_0x46232a('0x3d')](_0x46232a('0x5c'))[_0x46232a('0x4d')](_0x46232a('0x36'))[_0x46232a('0x29')](_0x46232a('0x66'),_0x29f9df[_0x46232a('0x40')]['id'][_0x46232a('0x2a')]())[_0x46232a('0x29')](_0x46232a('0x4b')))[_0x46232a('0xa')](_0x46232a('0x5')))[_0x46232a('0x2a')](),db[_0x46232a('0x59')][_0x46232a('0x27')](_0x1d4849);return[];})[_0x268ba1('0x1')](respondWithResult(_0x5d7449,null))[_0x268ba1('0x46')](handleError(_0x5d7449,null));},exports[_0x4301f5('0x2')]=function(_0x175971,_0x495569){const _0x543375=_0x4301f5;return db[_0x543375('0x24')][_0x543375('0x58')]({'where':{'id':_0x175971[_0x543375('0x40')]['id']}})[_0x543375('0x1')](handleEntityNotFound(_0x495569,null))[_0x543375('0x1')](function(_0x477817){const _0x31688c=_0x543375;let _0xdae563;if(_0x477817)return _0xdae563=squel[_0x31688c('0x28')]()['into'](_0x31688c('0x3c'))['fromQuery']([_0x31688c('0x9'),'scheduledAt',_0x31688c('0x5'),_0x31688c('0x64'),_0x31688c('0x60'),_0x31688c('0x20'),_0x31688c('0x2e')],squel[_0x31688c('0x0')]()[_0x31688c('0x3d')]('ANY_VALUE(calleridnum)',_0x31688c('0x9'))[_0x31688c('0x3d')](_0x31688c('0x21'),_0x31688c('0x3f'))[_0x31688c('0x3d')](_0x31688c('0x26'),_0x31688c('0x5'))['field']('ANY_VALUE(ListId)',_0x31688c('0x64'))[_0x31688c('0x3d')](_0x31688c('0x1d'),_0x31688c('0x60'))[_0x31688c('0x3d')]('NOW()',_0x31688c('0x20'))[_0x31688c('0x3d')](_0x31688c('0x21'),'updatedAt')['from'](_0x31688c('0x36'))[_0x31688c('0x29')](_0x31688c('0x5d'),_0x175971[_0x31688c('0x40')]['id'][_0x31688c('0x2a')]())['where'](_0x31688c('0x5e'),_0x175971[_0x31688c('0x67')][_0x31688c('0x3e')][_0x31688c('0x2a')]())[_0x31688c('0x29')](_0x31688c('0x19'))[_0x31688c('0x29')](_0x31688c('0x32'),squel[_0x31688c('0x0')]()[_0x31688c('0x3d')](_0x31688c('0x9'))[_0x31688c('0x4d')](_0x31688c('0x3c'))[_0x31688c('0x29')]('CampaignId\x20=\x20?',_0x175971[_0x31688c('0x40')]['id'][_0x31688c('0x2a')]()))[_0x31688c('0x29')](_0x31688c('0x32'),squel[_0x31688c('0x0')]()['field'](_0x31688c('0x5c'))[_0x31688c('0x4d')]('cm_hopper_final')[_0x31688c('0x29')](_0x31688c('0x5d'),_0x175971[_0x31688c('0x40')]['id'][_0x31688c('0x2a')]())[_0x31688c('0x29')](_0x31688c('0x4b')))[_0x31688c('0xa')]('ContactId'))[_0x31688c('0x2a')](),db[_0x31688c('0x59')]['query'](_0xdae563);return[];})[_0x543375('0x1')](respondWithResult(_0x495569,null))[_0x543375('0x46')](handleError(_0x495569,null));},exports['checkContactHopper']=function(_0x1359b0,_0x32bd6f){const _0x58083a=_0x4301f5;return db['CmHopper']['findOne']({'where':{'VoiceQueueId':_0x1359b0[_0x58083a('0x67')]['VoiceQueueId'],'CampaignId':_0x1359b0[_0x58083a('0x67')][_0x58083a('0x60')],'ContactId':_0x1359b0[_0x58083a('0x67')]['ContactId']}})[_0x58083a('0x1')](handleEntityNotFound(_0x32bd6f,null))[_0x58083a('0x1')](function(_0x5defb7){if(_0x5defb7)return _0x5defb7;return null;})[_0x58083a('0x1')](respondWithResult(_0x32bd6f,null))['catch'](handleError(_0x32bd6f,null));};
git://repos.xcallymotion.com / motion-next.git / blob