18 var _0x77d4=['penalty','sequelize','transaction','each','TeamVoiceQueue','UserVoiceQueueRt','upsert','isNil','format','SIP/%s','userVoiceQueue:save','removeTeams','select','tq.TeamId','from','join','user_has_teams','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','SELECT','every','TeamId','all','union','compact','ids','isEmpty','removeAgents','emit','addAgents','spread','online','push','isArray','userVoiceQueue:remove','getAgents','getMembers','getLists','addLists','dialCheckDuplicateType','always','insert','into','cm_hopper','fromQuery','phone','ContactId','field','CmListId','toString','ListId','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','COALESCE(phone,\x27\x27)','onlyIfOpen','scheduledAt','cm_hopper_additional_phones','CmHopperId','h.id','ci.item','ci.OrderBy+1','cm_contact_has_items','h.ContactId=ci.CmContactId','ci.ItemClass=?','PHONE','removeLists','getBlackLists','CmList','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','rimraf','fast-json-patch','moment','bluebird','path','sox','to-csv','ejs','fs-extra','lodash','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','redis','localhost','./voiceQueue.socket','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','destroy','get','VoiceQueues','QueueCampaigns','outbound','filter','ignore','value','includes','type','find','name','UserProfileResource','stack','send','index','map','VoiceQueue','fieldName','model','query','filters','intersection','fields','length','attributes','nolimit','order','sort','where','pick','merge','includeAll','include','findAll','rows','catch','params','keys','rawAttributes','options','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','inbound','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','autoAssociation','error','getHoppers','findOne','hasOwnProperty','CmHopper','getHopperHistories','CmHopperHistory','VoiceQueueId','CmHopperFinal','CmHopperBlack','getTeams','Team','addTeams','teams','User','Agents','voicePause','interface','flatMap'];(function(_0x3054be,_0x1bdc8b){var _0x3df150=function(_0x56cfbf){while(--_0x56cfbf){_0x3054be['push'](_0x3054be['shift']());}};_0x3df150(++_0x1bdc8b);}(_0x77d4,0x108));var _0x477d=function(_0x18fbcc,_0x1ec91a){_0x18fbcc=_0x18fbcc-0x0;var _0x50c414=_0x77d4[_0x18fbcc];return _0x50c414;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x477d('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x477d('0x1'));var rp=require('request-promise');var moment=require(_0x477d('0x2'));var BPromise=require(_0x477d('0x3'));var Mustache=require('mustache');var util=require('util');var path=require(_0x477d('0x4'));var sox=require(_0x477d('0x5'));var csv=require(_0x477d('0x6'));var ejs=require(_0x477d('0x7'));var fs=require('fs');var fs_extra=require(_0x477d('0x8'));var _=require(_0x477d('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x477d('0xa'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x477d('0xb'));var Papa=require(_0x477d('0xc'));var Redis=require(_0x477d('0xd'));var authService=require(_0x477d('0xe'));var qs=require(_0x477d('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x477d('0x10'));var logger=require('../../config/logger')(_0x477d('0x11'));var utils=require(_0x477d('0x12'));var config=require('../../config/environment');var licenseUtil=require(_0x477d('0x13'));var db=require(_0x477d('0x14'))['db'];config['redis']=_['defaults'](config[_0x477d('0x15')],{'host':_0x477d('0x16'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x477d('0x15')]));require(_0x477d('0x17'))['register'](socket);function respondWithStatusCode(_0x4b2021,_0x38a0a8){_0x38a0a8=_0x38a0a8||0xcc;return function(_0x4bbfef){if(_0x4bbfef){return _0x4b2021[_0x477d('0x18')](_0x38a0a8);}return _0x4b2021[_0x477d('0x19')](_0x38a0a8)[_0x477d('0x1a')]();};}function respondWithResult(_0x5985b5,_0x116aa7){_0x116aa7=_0x116aa7||0xc8;return function(_0x78d1f2){if(_0x78d1f2){return _0x5985b5[_0x477d('0x19')](_0x116aa7)[_0x477d('0x1b')](_0x78d1f2);}};}function respondWithFilteredResult(_0x57b38e,_0x28f17a){return function(_0x5d5553){if(_0x5d5553){var _0x367965=typeof _0x28f17a[_0x477d('0x1c')]===_0x477d('0x1d')&&typeof _0x28f17a[_0x477d('0x1e')]===_0x477d('0x1d');var _0x2145ce=_0x5d5553['count'];var _0x33db7a=_0x367965?0x0:_0x28f17a['offset'];var _0xe934a7=_0x367965?_0x5d5553[_0x477d('0x1f')]:_0x28f17a[_0x477d('0x1c')]+_0x28f17a[_0x477d('0x1e')];var _0x27b3aa;if(_0xe934a7>=_0x2145ce){_0xe934a7=_0x2145ce;_0x27b3aa=0xc8;}else{_0x27b3aa=0xce;}_0x57b38e[_0x477d('0x19')](_0x27b3aa);return _0x57b38e[_0x477d('0x20')](_0x477d('0x21'),_0x33db7a+'-'+_0xe934a7+'/'+_0x2145ce)[_0x477d('0x1b')](_0x5d5553);}return null;};}function patchUpdates(_0x5981a){return function(_0x3d2943){try{jsonpatch[_0x477d('0x22')](_0x3d2943,_0x5981a,!![]);}catch(_0x43c845){return BPromise[_0x477d('0x23')](_0x43c845);}return _0x3d2943['save']();};}function saveUpdates(_0x4481b0,_0x583444){return function(_0x239b56){if(_0x239b56){return _0x239b56[_0x477d('0x24')](_0x4481b0)[_0x477d('0x25')](function(_0x2287b4){return _0x2287b4;});}return null;};}function removeEntity(_0x4bb50e,_0xd6dca5){return function(_0x2dfa90){if(_0x2dfa90){return _0x2dfa90[_0x477d('0x26')]()['then'](function(){var _0x585648=_0x2dfa90[_0x477d('0x27')]({'plain':!![]});var _0x3c6270=[{'name':_0x477d('0x28'),'value':'inbound','ignore':![]},{'name':_0x477d('0x29'),'value':_0x477d('0x2a'),'ignore':![]}];var _0x74ebb4=_(_0x3c6270)[_0x477d('0x2b')](_0x477d('0x2c'))['map'](_0x477d('0x2d'))[_0x477d('0x2d')]();if(_[_0x477d('0x2e')](_0x74ebb4,_0x585648[_0x477d('0x2f')])){return;}var _0x32c5d7=_[_0x477d('0x30')](_0x3c6270,[_0x477d('0x2d'),_0x585648[_0x477d('0x2f')]])[_0x477d('0x31')];return db[_0x477d('0x32')][_0x477d('0x26')]({'where':{'type':_0x32c5d7,'resourceId':_0x585648['id']}})[_0x477d('0x25')](function(){return _0x2dfa90;});})[_0x477d('0x25')](function(){_0x4bb50e[_0x477d('0x19')](0xcc)[_0x477d('0x1a')]();});}};}function handleEntityNotFound(_0x4127c1,_0x9857c2){return function(_0x3a5509){if(!_0x3a5509){_0x4127c1[_0x477d('0x18')](0x194);}return _0x3a5509;};}function handleError(_0x266dbf,_0x49851b){_0x49851b=_0x49851b||0x1f4;return function(_0x304d25){logger['error'](_0x304d25[_0x477d('0x33')]);if(_0x304d25[_0x477d('0x31')]){delete _0x304d25[_0x477d('0x31')];}_0x266dbf['status'](_0x49851b)[_0x477d('0x34')](_0x304d25);};}exports[_0x477d('0x35')]=function(_0x2b2091,_0x3d34e4){var _0x249b82={},_0x463fca={},_0xca8bf={'count':0x0,'rows':[]};var _0xf84c4c=_[_0x477d('0x36')](db[_0x477d('0x37')]['rawAttributes'],function(_0x36a247){return{'name':_0x36a247[_0x477d('0x38')],'type':_0x36a247[_0x477d('0x2f')]['key']};});_0x463fca[_0x477d('0x39')]=_[_0x477d('0x36')](_0xf84c4c,_0x477d('0x31'));_0x463fca['query']=_['keys'](_0x2b2091[_0x477d('0x3a')]);_0x463fca[_0x477d('0x3b')]=_[_0x477d('0x3c')](_0x463fca[_0x477d('0x39')],_0x463fca[_0x477d('0x3a')]);_0x249b82['attributes']=_[_0x477d('0x3c')](_0x463fca['model'],qs[_0x477d('0x3d')](_0x2b2091[_0x477d('0x3a')][_0x477d('0x3d')]));_0x249b82['attributes']=_0x249b82['attributes'][_0x477d('0x3e')]?_0x249b82[_0x477d('0x3f')]:_0x463fca[_0x477d('0x39')];if(!_0x2b2091[_0x477d('0x3a')]['hasOwnProperty'](_0x477d('0x40'))){_0x249b82[_0x477d('0x1e')]=qs[_0x477d('0x1e')](_0x2b2091[_0x477d('0x3a')][_0x477d('0x1e')]);_0x249b82['offset']=qs[_0x477d('0x1c')](_0x2b2091[_0x477d('0x3a')]['offset']);}_0x249b82[_0x477d('0x41')]=qs['sort'](_0x2b2091[_0x477d('0x3a')][_0x477d('0x42')]);_0x249b82[_0x477d('0x43')]=qs[_0x477d('0x3b')](_[_0x477d('0x44')](_0x2b2091[_0x477d('0x3a')],_0x463fca[_0x477d('0x3b')]),_0xf84c4c);if(_0x2b2091[_0x477d('0x3a')][_0x477d('0x2b')]){_0x249b82['where']=_[_0x477d('0x45')](_0x249b82[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0xf84c4c,function(_0x432985){if(_0x432985['type']!=='VIRTUAL'){var _0x41397b={};_0x41397b[_0x432985[_0x477d('0x31')]]={'$like':'%'+_0x2b2091['query'][_0x477d('0x2b')]+'%'};return _0x41397b;}})});}_0x249b82=_['merge']({},_0x249b82,_0x2b2091['options']);var _0x983c91={'where':_0x249b82[_0x477d('0x43')]};return db[_0x477d('0x37')][_0x477d('0x1f')](_0x983c91)[_0x477d('0x25')](function(_0x26c463){_0xca8bf['count']=_0x26c463;if(_0x2b2091[_0x477d('0x3a')][_0x477d('0x46')]){_0x249b82[_0x477d('0x47')]=[{'all':!![]}];}return db[_0x477d('0x37')][_0x477d('0x48')](_0x249b82);})['then'](function(_0x4aad41){_0xca8bf[_0x477d('0x49')]=_0x4aad41;return _0xca8bf;})[_0x477d('0x25')](respondWithFilteredResult(_0x3d34e4,_0x249b82))[_0x477d('0x4a')](handleError(_0x3d34e4,null));};exports['show']=function(_0x45a5da,_0xf4685b){var _0x3154da={'raw':![],'where':{'id':_0x45a5da[_0x477d('0x4b')]['id']}},_0x1ad4d1={};_0x1ad4d1[_0x477d('0x39')]=_[_0x477d('0x4c')](db['VoiceQueue'][_0x477d('0x4d')]);_0x1ad4d1[_0x477d('0x3a')]=_[_0x477d('0x4c')](_0x45a5da[_0x477d('0x3a')]);_0x1ad4d1[_0x477d('0x3b')]=_[_0x477d('0x3c')](_0x1ad4d1[_0x477d('0x39')],_0x1ad4d1[_0x477d('0x3a')]);_0x3154da[_0x477d('0x3f')]=_[_0x477d('0x3c')](_0x1ad4d1[_0x477d('0x39')],qs[_0x477d('0x3d')](_0x45a5da[_0x477d('0x3a')][_0x477d('0x3d')]));_0x3154da[_0x477d('0x3f')]=_0x3154da['attributes'][_0x477d('0x3e')]?_0x3154da[_0x477d('0x3f')]:_0x1ad4d1['model'];if(_0x45a5da['query']['includeAll']){_0x3154da[_0x477d('0x47')]=[{'all':!![]}];}_0x3154da=_[_0x477d('0x45')]({},_0x3154da,_0x45a5da[_0x477d('0x4e')]);return db[_0x477d('0x37')][_0x477d('0x30')](_0x3154da)[_0x477d('0x25')](handleEntityNotFound(_0xf4685b,null))[_0x477d('0x25')](respondWithResult(_0xf4685b,null))[_0x477d('0x4a')](handleError(_0xf4685b,null));};exports['create']=function(_0x15dcaf,_0x470d3e){return db[_0x477d('0x37')][_0x477d('0x4f')](_0x15dcaf[_0x477d('0x50')],{})[_0x477d('0x25')](function(_0x22fc49){var _0x20e6b1=_0x15dcaf['user'][_0x477d('0x27')]({'plain':!![]});if(!_0x20e6b1)throw new Error(_0x477d('0x51'));if(_0x20e6b1[_0x477d('0x52')]===_0x477d('0x53')){var _0x45cf6d=_0x22fc49['get']({'plain':!![]});var _0x1c496a=[{'name':_0x477d('0x28'),'value':_0x477d('0x54')},{'name':_0x477d('0x29'),'value':_0x477d('0x2a')}];var _0x54c044=_['find'](_0x1c496a,[_0x477d('0x2d'),_0x45cf6d[_0x477d('0x2f')]])[_0x477d('0x31')];return db[_0x477d('0x55')][_0x477d('0x30')]({'where':{'name':_0x54c044,'userProfileId':_0x20e6b1[_0x477d('0x56')]},'raw':!![]})[_0x477d('0x25')](function(_0x39b961){if(_0x39b961&&_0x39b961['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x45cf6d['name'],'resourceId':_0x45cf6d['id'],'type':_0x39b961['name'],'sectionId':_0x39b961['id']},{})[_0x477d('0x25')](function(){return _0x22fc49;});}else{return _0x22fc49;}})['catch'](function(_0x43c3e5){logger['error'](_0x477d('0x57'),_0x43c3e5);throw _0x43c3e5;});}return _0x22fc49;})[_0x477d('0x25')](respondWithResult(_0x470d3e,0xc9))['catch'](handleError(_0x470d3e,null));};exports[_0x477d('0x58')]=function(_0x4739ac,_0x3d8a12){var _0x851020={'where':{'id':_0x4739ac['params']['id']}},_0x5e5e09={};_0x5e5e09[_0x477d('0x39')]=_[_0x477d('0x4c')](db['VoiceQueue'][_0x477d('0x4d')]);_0x851020[_0x477d('0x3f')]=_[_0x477d('0x3c')](_0x5e5e09[_0x477d('0x39')],qs[_0x477d('0x3d')](_0x4739ac['query']['fields']));_0x851020[_0x477d('0x3f')]=_0x851020[_0x477d('0x3f')]['length']?_0x851020[_0x477d('0x3f')]:_0x5e5e09['model'];if(_0x4739ac['query'][_0x477d('0x46')]){_0x851020[_0x477d('0x47')]=[{'all':!![]}];}_0x851020=_[_0x477d('0x45')]({},_0x851020,_0x4739ac[_0x477d('0x4e')]);return db[_0x477d('0x37')]['find'](_0x851020)['then'](handleEntityNotFound(_0x3d8a12,null))[_0x477d('0x25')](function(_0x23c435){if(_0x23c435){var _0x3510db=_0x23c435[_0x477d('0x27')]({'plain':!![]});_0x3510db=qs[_0x477d('0x59')](_0x3510db,['id',_0x477d('0x5a'),_0x477d('0x5b')]);_0x4739ac[_0x477d('0x50')]=_[_0x477d('0x59')](_0x4739ac['body'],['id','createdAt',_0x477d('0x5b')]);return db['VoiceQueue'][_0x477d('0x4f')](_[_0x477d('0x45')](_0x3510db,_0x4739ac[_0x477d('0x50')]),{'include':_0x4739ac['query'][_0x477d('0x46')]?[{'all':!![]}]:undefined})[_0x477d('0x25')](function(_0x5ec335){var _0x2d1e6d=_0x4739ac[_0x477d('0x53')][_0x477d('0x27')]({'plain':!![]});if(!_0x2d1e6d)throw new Error(_0x477d('0x51'));if(_0x2d1e6d[_0x477d('0x52')]===_0x477d('0x53')){var _0x55f1a9=_0x5ec335[_0x477d('0x27')]({'plain':!![]});var _0x36bfa3=[{'name':_0x477d('0x28'),'value':_0x477d('0x54')},{'name':'QueueCampaigns','value':_0x477d('0x2a')}];var _0x543673=_[_0x477d('0x30')](_0x36bfa3,[_0x477d('0x2d'),_0x55f1a9['type']])[_0x477d('0x31')];return db[_0x477d('0x55')][_0x477d('0x30')]({'where':{'name':_0x543673,'userProfileId':_0x2d1e6d['userProfileId']},'raw':!![]})['then'](function(_0x10654d){if(_0x10654d&&_0x10654d[_0x477d('0x5c')]===0x0){return db[_0x477d('0x32')][_0x477d('0x4f')]({'name':_0x55f1a9['name'],'resourceId':_0x55f1a9['id'],'type':_0x10654d[_0x477d('0x31')],'sectionId':_0x10654d['id']},{})[_0x477d('0x25')](function(){return _0x5ec335;});}else{return _0x5ec335;}})['catch'](function(_0x38e06f){logger[_0x477d('0x5d')](_0x477d('0x57'),_0x38e06f);throw _0x38e06f;});}return _0x5ec335;});}})['then'](respondWithResult(_0x3d8a12,0xc9))[_0x477d('0x4a')](handleError(_0x3d8a12,null));};exports[_0x477d('0x24')]=function(_0x120e0e,_0x5ef582){if(_0x120e0e[_0x477d('0x50')]['id']){delete _0x120e0e[_0x477d('0x50')]['id'];}return db[_0x477d('0x37')][_0x477d('0x30')]({'where':{'id':_0x120e0e[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x5ef582,null))[_0x477d('0x25')](saveUpdates(_0x120e0e[_0x477d('0x50')],null))[_0x477d('0x25')](respondWithResult(_0x5ef582,null))['catch'](handleError(_0x5ef582,null));};exports['destroy']=function(_0x3d7f61,_0x48cb39){return db[_0x477d('0x37')]['find']({'where':{'id':_0x3d7f61[_0x477d('0x4b')]['id']}})['then'](handleEntityNotFound(_0x48cb39,null))[_0x477d('0x25')](removeEntity(_0x48cb39,null))[_0x477d('0x4a')](handleError(_0x48cb39,null));};exports[_0x477d('0x5e')]=function(_0x239a3d,_0x5c8fd8,_0x5e9459){var _0x5cd5c4={'raw':![],'where':{}};var _0x54924b={};var _0x4928f8={'count':0x0,'rows':[]};return db[_0x477d('0x37')][_0x477d('0x5f')]({'where':{'id':_0x239a3d[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x5c8fd8,null))[_0x477d('0x25')](function(_0x1a09f8){if(_0x1a09f8){_0x54924b['model']=_[_0x477d('0x4c')](db['CmHopper']['rawAttributes']);_0x54924b[_0x477d('0x3a')]=_[_0x477d('0x4c')](_0x239a3d[_0x477d('0x3a')]);_0x54924b[_0x477d('0x3b')]=_[_0x477d('0x3c')](_0x54924b[_0x477d('0x39')],_0x54924b['query']);_0x5cd5c4['attributes']=_[_0x477d('0x3c')](_0x54924b[_0x477d('0x39')],qs[_0x477d('0x3d')](_0x239a3d['query']['fields']));_0x5cd5c4[_0x477d('0x3f')]=_0x5cd5c4[_0x477d('0x3f')][_0x477d('0x3e')]?_0x5cd5c4[_0x477d('0x3f')]:_0x54924b[_0x477d('0x39')];if(!_0x239a3d[_0x477d('0x3a')][_0x477d('0x60')](_0x477d('0x40'))){_0x5cd5c4[_0x477d('0x1e')]=qs['limit'](_0x239a3d[_0x477d('0x3a')][_0x477d('0x1e')]);_0x5cd5c4['offset']=qs[_0x477d('0x1c')](_0x239a3d[_0x477d('0x3a')][_0x477d('0x1c')]);}_0x5cd5c4[_0x477d('0x41')]=qs[_0x477d('0x42')](_0x239a3d['query'][_0x477d('0x42')]);_0x5cd5c4['where']=qs[_0x477d('0x3b')](_[_0x477d('0x44')](_0x239a3d['query'],_0x54924b[_0x477d('0x3b')]));_0x5cd5c4[_0x477d('0x43')]['VoiceQueueId']=_0x1a09f8['id'];if(_0x239a3d[_0x477d('0x3a')][_0x477d('0x2b')]){_0x5cd5c4['where']=_[_0x477d('0x45')](_0x5cd5c4[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0x5cd5c4[_0x477d('0x3f')],function(_0x1cc5e1){var _0x231db4={};_0x231db4[_0x1cc5e1]={'$like':'%'+_0x239a3d[_0x477d('0x3a')][_0x477d('0x2b')]+'%'};return _0x231db4;})});}_0x5cd5c4=_[_0x477d('0x45')]({},_0x5cd5c4,_0x239a3d[_0x477d('0x4e')]);return db[_0x477d('0x61')][_0x477d('0x1f')]({'where':_0x5cd5c4[_0x477d('0x43')]})[_0x477d('0x25')](function(_0x1fb4cc){_0x4928f8['count']=_0x1fb4cc;if(_0x239a3d[_0x477d('0x3a')]['includeAll']){_0x5cd5c4['include']=[{'all':!![]}];}return db[_0x477d('0x61')][_0x477d('0x48')](_0x5cd5c4);})['then'](function(_0x210c4d){_0x4928f8[_0x477d('0x49')]=_0x210c4d;return _0x4928f8;});}})[_0x477d('0x25')](respondWithFilteredResult(_0x5c8fd8,_0x5cd5c4))[_0x477d('0x4a')](handleError(_0x5c8fd8,null));};exports[_0x477d('0x62')]=function(_0x1a4d12,_0x1731ff,_0x4b23d9){var _0x19e391={'raw':!![],'where':{}};var _0x3d1808={};var _0x5ae446={'count':0x0,'rows':[]};return db[_0x477d('0x37')][_0x477d('0x5f')]({'where':{'id':_0x1a4d12[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x1731ff,null))[_0x477d('0x25')](function(_0x135a69){if(_0x135a69){_0x3d1808[_0x477d('0x39')]=_[_0x477d('0x4c')](db[_0x477d('0x63')][_0x477d('0x4d')]);_0x3d1808[_0x477d('0x3a')]=_[_0x477d('0x4c')](_0x1a4d12[_0x477d('0x3a')]);_0x3d1808[_0x477d('0x3b')]=_[_0x477d('0x3c')](_0x3d1808[_0x477d('0x39')],_0x3d1808['query']);_0x19e391['attributes']=_[_0x477d('0x3c')](_0x3d1808['model'],qs['fields'](_0x1a4d12['query'][_0x477d('0x3d')]));_0x19e391[_0x477d('0x3f')]=_0x19e391['attributes'][_0x477d('0x3e')]?_0x19e391[_0x477d('0x3f')]:_0x3d1808[_0x477d('0x39')];if(!_0x1a4d12[_0x477d('0x3a')][_0x477d('0x60')]('nolimit')){_0x19e391['limit']=qs[_0x477d('0x1e')](_0x1a4d12[_0x477d('0x3a')][_0x477d('0x1e')]);_0x19e391[_0x477d('0x1c')]=qs[_0x477d('0x1c')](_0x1a4d12['query']['offset']);}_0x19e391['order']=qs[_0x477d('0x42')](_0x1a4d12[_0x477d('0x3a')]['sort']);_0x19e391[_0x477d('0x43')]=qs[_0x477d('0x3b')](_[_0x477d('0x44')](_0x1a4d12[_0x477d('0x3a')],_0x3d1808[_0x477d('0x3b')]));_0x19e391[_0x477d('0x43')][_0x477d('0x64')]=_0x135a69['id'];if(_0x1a4d12['query'][_0x477d('0x2b')]){_0x19e391['where']=_[_0x477d('0x45')](_0x19e391[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0x19e391[_0x477d('0x3f')],function(_0x26658d){var _0x266f99={};_0x266f99[_0x26658d]={'$like':'%'+_0x1a4d12[_0x477d('0x3a')]['filter']+'%'};return _0x266f99;})});}_0x19e391=_[_0x477d('0x45')]({},_0x19e391,_0x1a4d12[_0x477d('0x4e')]);return db[_0x477d('0x63')][_0x477d('0x1f')]({'where':_0x19e391['where']})[_0x477d('0x25')](function(_0x56db60){_0x5ae446[_0x477d('0x1f')]=_0x56db60;if(_0x1a4d12[_0x477d('0x3a')][_0x477d('0x46')]){_0x19e391[_0x477d('0x47')]=[{'all':!![]}];}return db[_0x477d('0x63')]['findAll'](_0x19e391);})[_0x477d('0x25')](function(_0x5044c3){_0x5ae446[_0x477d('0x49')]=_0x5044c3;return _0x5ae446;});}})[_0x477d('0x25')](respondWithFilteredResult(_0x1731ff,_0x19e391))[_0x477d('0x4a')](handleError(_0x1731ff,null));};exports['getHopperFinals']=function(_0x40112e,_0x2c7a72,_0x3e70c7){var _0x71cbd5={'raw':!![],'where':{}};var _0x12acd2={};var _0x30ed3a={'count':0x0,'rows':[]};return db[_0x477d('0x37')][_0x477d('0x5f')]({'where':{'id':_0x40112e[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x2c7a72,null))[_0x477d('0x25')](function(_0x104d8b){if(_0x104d8b){_0x12acd2['model']=_['keys'](db[_0x477d('0x65')][_0x477d('0x4d')]);_0x12acd2[_0x477d('0x3a')]=_['keys'](_0x40112e['query']);_0x12acd2['filters']=_['intersection'](_0x12acd2[_0x477d('0x39')],_0x12acd2[_0x477d('0x3a')]);_0x71cbd5[_0x477d('0x3f')]=_[_0x477d('0x3c')](_0x12acd2[_0x477d('0x39')],qs['fields'](_0x40112e[_0x477d('0x3a')][_0x477d('0x3d')]));_0x71cbd5[_0x477d('0x3f')]=_0x71cbd5[_0x477d('0x3f')][_0x477d('0x3e')]?_0x71cbd5[_0x477d('0x3f')]:_0x12acd2['model'];if(!_0x40112e[_0x477d('0x3a')][_0x477d('0x60')](_0x477d('0x40'))){_0x71cbd5['limit']=qs[_0x477d('0x1e')](_0x40112e[_0x477d('0x3a')][_0x477d('0x1e')]);_0x71cbd5[_0x477d('0x1c')]=qs[_0x477d('0x1c')](_0x40112e['query'][_0x477d('0x1c')]);}_0x71cbd5[_0x477d('0x41')]=qs['sort'](_0x40112e[_0x477d('0x3a')][_0x477d('0x42')]);_0x71cbd5[_0x477d('0x43')]=qs[_0x477d('0x3b')](_['pick'](_0x40112e[_0x477d('0x3a')],_0x12acd2['filters']));_0x71cbd5['where'][_0x477d('0x64')]=_0x104d8b['id'];if(_0x40112e[_0x477d('0x3a')]['filter']){_0x71cbd5['where']=_['merge'](_0x71cbd5[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0x71cbd5[_0x477d('0x3f')],function(_0x3ebe19){var _0x57a4cd={};_0x57a4cd[_0x3ebe19]={'$like':'%'+_0x40112e['query'][_0x477d('0x2b')]+'%'};return _0x57a4cd;})});}_0x71cbd5=_[_0x477d('0x45')]({},_0x71cbd5,_0x40112e[_0x477d('0x4e')]);return db[_0x477d('0x65')][_0x477d('0x1f')]({'where':_0x71cbd5['where']})[_0x477d('0x25')](function(_0x458fa5){_0x30ed3a['count']=_0x458fa5;if(_0x40112e['query']['includeAll']){_0x71cbd5[_0x477d('0x47')]=[{'all':!![]}];}return db[_0x477d('0x65')][_0x477d('0x48')](_0x71cbd5);})[_0x477d('0x25')](function(_0x44c2fa){_0x30ed3a[_0x477d('0x49')]=_0x44c2fa;return _0x30ed3a;});}})[_0x477d('0x25')](respondWithFilteredResult(_0x2c7a72,_0x71cbd5))[_0x477d('0x4a')](handleError(_0x2c7a72,null));};exports['getHopperBlacks']=function(_0x40495c,_0x137160,_0x59052e){var _0x451e18={'raw':!![],'where':{}};var _0x1e6db7={};var _0x1ac227={'count':0x0,'rows':[]};return db[_0x477d('0x37')][_0x477d('0x5f')]({'where':{'id':_0x40495c[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x137160,null))[_0x477d('0x25')](function(_0x1821b1){if(_0x1821b1){_0x1e6db7[_0x477d('0x39')]=_['keys'](db['CmHopperBlack']['rawAttributes']);_0x1e6db7[_0x477d('0x3a')]=_[_0x477d('0x4c')](_0x40495c[_0x477d('0x3a')]);_0x1e6db7[_0x477d('0x3b')]=_[_0x477d('0x3c')](_0x1e6db7[_0x477d('0x39')],_0x1e6db7['query']);_0x451e18[_0x477d('0x3f')]=_['intersection'](_0x1e6db7[_0x477d('0x39')],qs[_0x477d('0x3d')](_0x40495c[_0x477d('0x3a')]['fields']));_0x451e18[_0x477d('0x3f')]=_0x451e18['attributes']['length']?_0x451e18['attributes']:_0x1e6db7['model'];if(!_0x40495c['query'][_0x477d('0x60')]('nolimit')){_0x451e18[_0x477d('0x1e')]=qs['limit'](_0x40495c[_0x477d('0x3a')]['limit']);_0x451e18[_0x477d('0x1c')]=qs[_0x477d('0x1c')](_0x40495c['query'][_0x477d('0x1c')]);}_0x451e18[_0x477d('0x41')]=qs[_0x477d('0x42')](_0x40495c[_0x477d('0x3a')]['sort']);_0x451e18[_0x477d('0x43')]=qs[_0x477d('0x3b')](_['pick'](_0x40495c[_0x477d('0x3a')],_0x1e6db7[_0x477d('0x3b')]));_0x451e18[_0x477d('0x43')][_0x477d('0x64')]=_0x1821b1['id'];if(_0x40495c[_0x477d('0x3a')][_0x477d('0x2b')]){_0x451e18[_0x477d('0x43')]=_[_0x477d('0x45')](_0x451e18[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0x451e18[_0x477d('0x3f')],function(_0x42271d){var _0x2cbcc5={};_0x2cbcc5[_0x42271d]={'$like':'%'+_0x40495c[_0x477d('0x3a')][_0x477d('0x2b')]+'%'};return _0x2cbcc5;})});}_0x451e18=_[_0x477d('0x45')]({},_0x451e18,_0x40495c[_0x477d('0x4e')]);return db[_0x477d('0x66')][_0x477d('0x1f')]({'where':_0x451e18['where']})['then'](function(_0x45b405){_0x1ac227[_0x477d('0x1f')]=_0x45b405;if(_0x40495c[_0x477d('0x3a')]['includeAll']){_0x451e18['include']=[{'all':!![]}];}return db[_0x477d('0x66')][_0x477d('0x48')](_0x451e18);})['then'](function(_0x561c87){_0x1ac227[_0x477d('0x49')]=_0x561c87;return _0x1ac227;});}})[_0x477d('0x25')](respondWithFilteredResult(_0x137160,_0x451e18))[_0x477d('0x4a')](handleError(_0x137160,null));};exports[_0x477d('0x67')]=function(_0xb2a31,_0x3498ca,_0xa999e0){var _0x13967e={};var _0x3140d1={};var _0x492ac7;var _0x877a51;return db[_0x477d('0x37')][_0x477d('0x5f')]({'where':{'id':_0xb2a31[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x3498ca,null))['then'](function(_0x15e155){if(_0x15e155){_0x492ac7=_0x15e155;_0x3140d1[_0x477d('0x39')]=_[_0x477d('0x4c')](db[_0x477d('0x68')]['rawAttributes']);_0x3140d1[_0x477d('0x3a')]=_[_0x477d('0x4c')](_0xb2a31['query']);_0x3140d1[_0x477d('0x3b')]=_['intersection'](_0x3140d1['model'],_0x3140d1['query']);_0x13967e['attributes']=_['intersection'](_0x3140d1[_0x477d('0x39')],qs['fields'](_0xb2a31[_0x477d('0x3a')][_0x477d('0x3d')]));_0x13967e[_0x477d('0x3f')]=_0x13967e[_0x477d('0x3f')][_0x477d('0x3e')]?_0x13967e['attributes']:_0x3140d1[_0x477d('0x39')];_0x13967e[_0x477d('0x41')]=qs[_0x477d('0x42')](_0xb2a31[_0x477d('0x3a')][_0x477d('0x42')]);_0x13967e[_0x477d('0x43')]=qs[_0x477d('0x3b')](_[_0x477d('0x44')](_0xb2a31[_0x477d('0x3a')],_0x3140d1[_0x477d('0x3b')]));if(_0xb2a31['query'][_0x477d('0x2b')]){_0x13967e[_0x477d('0x43')]=_[_0x477d('0x45')](_0x13967e[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0x13967e[_0x477d('0x3f')],function(_0x49e480){var _0x4b3974={};_0x4b3974[_0x49e480]={'$like':'%'+_0xb2a31[_0x477d('0x3a')]['filter']+'%'};return _0x4b3974;})});}_0x13967e=_[_0x477d('0x45')]({},_0x13967e,_0xb2a31[_0x477d('0x4e')]);return _0x492ac7['getTeams'](_0x13967e);}})[_0x477d('0x25')](function(_0xb492a7){if(_0xb492a7){_0x877a51=_0xb492a7[_0x477d('0x3e')];if(!_0xb2a31['query'][_0x477d('0x60')](_0x477d('0x40'))){_0x13967e[_0x477d('0x1e')]=qs[_0x477d('0x1e')](_0xb2a31[_0x477d('0x3a')][_0x477d('0x1e')]);_0x13967e[_0x477d('0x1c')]=qs[_0x477d('0x1c')](_0xb2a31[_0x477d('0x3a')]['offset']);}return _0x492ac7[_0x477d('0x67')](_0x13967e);}})['then'](function(_0x45af5a){if(_0x45af5a){return _0x45af5a?{'count':_0x877a51,'rows':_0x45af5a}:null;}})[_0x477d('0x25')](respondWithResult(_0x3498ca,null))[_0x477d('0x4a')](handleError(_0x3498ca,null));};exports[_0x477d('0x69')]=function(_0x4996e6,_0x2fba34,_0x361807){var _0x513519=_0x4996e6[_0x477d('0x50')][_0x477d('0x6a')];var _0x377b3f=_[_0x477d('0x36')](_0x513519,'id');return db[_0x477d('0x68')][_0x477d('0x48')]({'where':{'id':_0x377b3f},'attributes':['id'],'include':[{'model':db[_0x477d('0x6b')],'as':_0x477d('0x6c'),'attributes':['id',_0x477d('0x31'),'online',_0x477d('0x6d'),_0x477d('0x6e')],'raw':!![]}]})[_0x477d('0x25')](function(_0x20281a){if(_0x20281a){var _0xd9fe10=_[_0x477d('0x6f')](_0x20281a,function(_0x44928b){var _0xe309bd=_0x44928b['get']({'plain':!![]});_0xe309bd[_0x477d('0x6c')]['forEach'](function(_0xc1d4bd){_0xc1d4bd[_0x477d('0x70')]=_[_0x477d('0x30')](_0x513519,{'id':_0xe309bd['id']})['penalty'];});return _0xe309bd['Agents'];});return db['VoiceQueue'][_0x477d('0x30')]({'where':{'id':_0x4996e6[_0x477d('0x4b')]['id']}})['then'](function(_0x320666){return db[_0x477d('0x71')][_0x477d('0x72')](function(_0x374539){return _0x320666['addTeams'](_0x377b3f,{'transaction':_0x374539})[_0x477d('0x25')](function(){return BPromise[_0x477d('0x73')](_0x513519,function(_0x36b530){return db[_0x477d('0x74')]['upsert']({'TeamId':_0x36b530['id'],'VoiceQueueId':_0x4996e6[_0x477d('0x4b')]['id'],'penalty':_0x36b530[_0x477d('0x70')]},{'transaction':_0x374539});});})['then'](function(){return BPromise[_0x477d('0x73')](_0xd9fe10,function(_0x21788f){return db['UserVoiceQueue']['findOrCreate']({'where':{'UserId':_0x21788f['id'],'VoiceQueueId':_0x4996e6[_0x477d('0x4b')]['id']},'defaults':{'penalty':_0x21788f['penalty']},'transaction':_0x374539});});})['then'](function(){return BPromise['each'](_[_0x477d('0x2b')](_0xd9fe10,{'online':!![]}),function(_0x77d5af){return db[_0x477d('0x75')][_0x477d('0x76')]({'membername':_0x77d5af['name'],'UserId':_0x77d5af['id'],'queue_name':_0x320666[_0x477d('0x31')],'VoiceQueueId':_0x320666['id'],'interface':_[_0x477d('0x77')](_0x77d5af[_0x477d('0x6e')])?util[_0x477d('0x78')](_0x477d('0x79'),_0x77d5af['name']):_0x77d5af[_0x477d('0x6e')],'paused':_0x77d5af[_0x477d('0x6d')]||![],'penalty':_0x77d5af[_0x477d('0x70')]},{'transaction':_0x374539});});})['then'](function(){_0xd9fe10['forEach'](function(_0x50cb27){socket['emit'](_0x477d('0x7a'),{'UserId':_0x50cb27['id'],'VoiceQueueId':_0x320666['id']});});});});});}})[_0x477d('0x25')](respondWithStatusCode(_0x2fba34,null))[_0x477d('0x4a')](handleError(_0x2fba34,null));};exports[_0x477d('0x7b')]=function(_0x28cd00,_0x41bbd3,_0x79ab31){return db[_0x477d('0x68')][_0x477d('0x48')]({'where':{'id':_0x28cd00[_0x477d('0x3a')]['ids']},'attributes':['id'],'include':[{'model':db[_0x477d('0x6b')],'as':_0x477d('0x6c'),'attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x41bbd3,null))['then'](function(_0x1e4f03){var _0x280860=_['map'](_0x1e4f03,'id');var _0xead4a9=[];var _0x4f1512=[];var _0x12487e=squel[_0x477d('0x7c')]();_0x12487e['field'](_0x477d('0x7d'))[_0x477d('0x7e')]('team_has_voice_queues','tq')[_0x477d('0x7f')](_0x477d('0x80'),'ut','ut.TeamId\x20=\x20tq.TeamId')['where'](_0x477d('0x81'),_0x28cd00[_0x477d('0x4b')]['id']);for(var _0x196ef2=0x0;_0x196ef2<_0x1e4f03[_0x477d('0x3e')];_0x196ef2+=0x1){let _0x3b9d27=_0x1e4f03[_0x196ef2];for(var _0x524c15=0x0;_0x524c15<_0x3b9d27[_0x477d('0x6c')]['length'];_0x524c15+=0x1){let _0xb4000c=_0x3b9d27[_0x477d('0x6c')][_0x524c15];var _0xd4aed2=_0x12487e[_0x477d('0x58')]();_0xd4aed2[_0x477d('0x43')](_0x477d('0x82'),_0xb4000c['id']);_0x4f1512['push'](db[_0x477d('0x71')][_0x477d('0x3a')](_0xd4aed2['toString'](),{'type':db['sequelize']['QueryTypes'][_0x477d('0x83')]})['then'](function(_0x770f1e){if(_0x770f1e[_0x477d('0x3e')]===0x1){return _0xb4000c['id'];}else{var _0x17d484=_[_0x477d('0x84')](_[_0x477d('0x36')](_0x770f1e,_0x477d('0x85')),function(_0x3bb6ce){return _[_0x477d('0x2e')](_0x280860,_0x3bb6ce);});if(_0x17d484){return _0xb4000c['id'];}}}));}}return BPromise[_0x477d('0x86')](_0x4f1512)['then'](function(_0x41baa1){_0xead4a9=_(_0xead4a9)[_0x477d('0x87')](_0x41baa1)[_0x477d('0x88')]()[_0x477d('0x2d')]();return db[_0x477d('0x37')]['find']({'where':{'id':_0x28cd00[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](function(_0x119513){return db[_0x477d('0x71')][_0x477d('0x72')](function(_0x24bb45){return _0x119513[_0x477d('0x7b')](_0x28cd00['query'][_0x477d('0x89')],{'transaction':_0x24bb45})[_0x477d('0x25')](function(){if(!_[_0x477d('0x8a')](_0xead4a9)){return _0x119513[_0x477d('0x8b')](_0xead4a9,{'transaction':_0x24bb45})[_0x477d('0x25')](function(){return db[_0x477d('0x75')][_0x477d('0x26')]({'where':{'VoiceQueueId':_0x28cd00['params']['id'],'UserId':_0xead4a9},'transaction':_0x24bb45});});}})[_0x477d('0x25')](function(){_0xead4a9['forEach'](function(_0x2aee43){socket[_0x477d('0x8c')]('userVoiceQueue:remove',{'UserId':_0x2aee43,'VoiceQueueId':_0x119513['id']});});});});});});})[_0x477d('0x25')](respondWithStatusCode(_0x41bbd3,null))[_0x477d('0x4a')](handleError(_0x41bbd3,null));};exports[_0x477d('0x8d')]=function(_0x109a13,_0x2fe95b,_0x2ccd9a){var _0x12d53f,_0x5257ce;return db[_0x477d('0x37')][_0x477d('0x30')]({'where':{'id':_0x109a13[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x2fe95b,null))[_0x477d('0x25')](function(_0x166181){if(_0x166181){_0x5257ce=_0x166181;return _0x166181['addAgents'](_0x109a13[_0x477d('0x50')][_0x477d('0x89')],_[_0x477d('0x59')](_0x109a13['body'],[_0x477d('0x89'),'id'])||{})[_0x477d('0x8e')](function(_0x3474da){for(var _0x4e0c9c=0x0;_0x4e0c9c<_0x109a13['body'][_0x477d('0x89')]['length'];_0x4e0c9c+=0x1){socket['emit'](_0x477d('0x7a'),{'UserId':Number(_0x109a13[_0x477d('0x50')][_0x477d('0x89')][_0x4e0c9c]),'VoiceQueueId':Number(_0x109a13[_0x477d('0x4b')]['id'])});}return _0x3474da;});}})[_0x477d('0x25')](function(_0x3563c6){_0x12d53f=_0x3563c6||[];if(_0x5257ce){return db['User'][_0x477d('0x48')]({'where':{'id':_0x109a13[_0x477d('0x50')][_0x477d('0x89')]},'attributes':['id',_0x477d('0x31'),_0x477d('0x8f'),_0x477d('0x6d'),_0x477d('0x6e')],'raw':!![]});}})['then'](function(_0x1512ae){if(!_[_0x477d('0x8a')](_0x1512ae)){var _0x26402a=[];for(var _0x3edbf8=0x0;_0x3edbf8<_0x1512ae['length'];_0x3edbf8++){if(_0x1512ae[_0x3edbf8][_0x477d('0x8f')]){_0x26402a[_0x477d('0x90')](db[_0x477d('0x75')][_0x477d('0x76')]({'membername':_0x1512ae[_0x3edbf8]['name'],'UserId':_0x1512ae[_0x3edbf8]['id'],'queue_name':_0x5257ce[_0x477d('0x31')],'VoiceQueueId':_0x5257ce['id'],'interface':_[_0x477d('0x77')](_0x1512ae[_0x3edbf8][_0x477d('0x6e')])?util['format'](_0x477d('0x79'),_0x1512ae[_0x3edbf8][_0x477d('0x31')]):_0x1512ae[_0x3edbf8][_0x477d('0x6e')],'paused':_0x1512ae[_0x3edbf8][_0x477d('0x6d')]||![],'penalty':_0x109a13[_0x477d('0x50')][_0x477d('0x70')]||0x0}));}}return BPromise['all'](_0x26402a);}})['then'](function(){return _0x12d53f;})[_0x477d('0x25')](respondWithResult(_0x2fe95b,null))[_0x477d('0x4a')](handleError(_0x2fe95b,null));};exports[_0x477d('0x8b')]=function(_0x3f61f5,_0x478c2d,_0x1f012b){return db['VoiceQueue'][_0x477d('0x30')]({'where':{'id':_0x3f61f5[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x478c2d,null))[_0x477d('0x25')](function(_0x368930){if(_0x368930){return _0x368930['removeAgents'](_0x3f61f5[_0x477d('0x3a')][_0x477d('0x89')])[_0x477d('0x25')](function(){if(_[_0x477d('0x91')](_0x3f61f5[_0x477d('0x3a')]['ids'])){for(var _0xfe8776=0x0;_0xfe8776<_0x3f61f5[_0x477d('0x3a')][_0x477d('0x89')]['length'];_0xfe8776+=0x1){socket[_0x477d('0x8c')](_0x477d('0x92'),{'UserId':Number(_0x3f61f5[_0x477d('0x3a')][_0x477d('0x89')][_0xfe8776]),'VoiceQueueId':Number(_0x3f61f5['params']['id'])});}}else{socket[_0x477d('0x8c')](_0x477d('0x92'),{'UserId':Number(_0x3f61f5[_0x477d('0x3a')][_0x477d('0x89')]),'VoiceQueueId':Number(_0x3f61f5['params']['id'])});}});}})[_0x477d('0x25')](function(_0x4933ae){return db[_0x477d('0x75')]['destroy']({'where':{'VoiceQueueId':_0x3f61f5[_0x477d('0x4b')]['id'],'UserId':_0x3f61f5[_0x477d('0x3a')][_0x477d('0x89')]}})['then'](function(){return _0x4933ae;});})[_0x477d('0x25')](respondWithStatusCode(_0x478c2d,null))[_0x477d('0x4a')](handleError(_0x478c2d,null));};exports[_0x477d('0x93')]=function(_0xa63cba,_0x15f9ff,_0x1b24c6){var _0x542c21={};var _0x1c2b62={};var _0x3f07d3;var _0x438124;return db[_0x477d('0x37')][_0x477d('0x5f')]({'where':{'id':_0xa63cba[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x15f9ff,null))['then'](function(_0x375867){if(_0x375867){_0x3f07d3=_0x375867;_0x1c2b62[_0x477d('0x39')]=_[_0x477d('0x4c')](db[_0x477d('0x6b')][_0x477d('0x4d')]);_0x1c2b62[_0x477d('0x3a')]=_[_0x477d('0x4c')](_0xa63cba[_0x477d('0x3a')]);_0x1c2b62[_0x477d('0x3b')]=_[_0x477d('0x3c')](_0x1c2b62[_0x477d('0x39')],_0x1c2b62[_0x477d('0x3a')]);_0x542c21[_0x477d('0x3f')]=_[_0x477d('0x3c')](_0x1c2b62[_0x477d('0x39')],qs[_0x477d('0x3d')](_0xa63cba[_0x477d('0x3a')]['fields']));_0x542c21['attributes']=_0x542c21[_0x477d('0x3f')]['length']?_0x542c21[_0x477d('0x3f')]:_0x1c2b62['model'];_0x542c21[_0x477d('0x41')]=qs['sort'](_0xa63cba[_0x477d('0x3a')][_0x477d('0x42')]);_0x542c21['where']=qs[_0x477d('0x3b')](_[_0x477d('0x44')](_0xa63cba[_0x477d('0x3a')],_0x1c2b62[_0x477d('0x3b')]));if(_0xa63cba[_0x477d('0x3a')]['filter']){_0x542c21[_0x477d('0x43')]=_[_0x477d('0x45')](_0x542c21['where'],{'$or':_['map'](_0x542c21[_0x477d('0x3f')],function(_0x581bd1){var _0x96b0da={};_0x96b0da[_0x581bd1]={'$like':'%'+_0xa63cba[_0x477d('0x3a')]['filter']+'%'};return _0x96b0da;})});}_0x542c21=_['merge']({},_0x542c21,_0xa63cba['options']);return _0x3f07d3[_0x477d('0x93')](_0x542c21);}})['then'](function(_0x341307){if(_0x341307){_0x438124=_0x341307[_0x477d('0x3e')];if(!_0xa63cba[_0x477d('0x3a')][_0x477d('0x60')](_0x477d('0x40'))){_0x542c21['limit']=qs[_0x477d('0x1e')](_0xa63cba['query'][_0x477d('0x1e')]);_0x542c21[_0x477d('0x1c')]=qs[_0x477d('0x1c')](_0xa63cba['query'][_0x477d('0x1c')]);}return _0x3f07d3[_0x477d('0x93')](_0x542c21);}})[_0x477d('0x25')](function(_0x534aad){if(_0x534aad){return _0x534aad?{'count':_0x438124,'rows':_0x534aad}:null;}})['then'](respondWithResult(_0x15f9ff,null))[_0x477d('0x4a')](handleError(_0x15f9ff,null));};exports['getMembers']=function(_0x3da01d,_0x17b2e2,_0x579e75){var _0x109acb={};var _0x4dc91e={};var _0x1ea699;var _0x517536;return db[_0x477d('0x37')][_0x477d('0x5f')]({'where':{'id':_0x3da01d[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x17b2e2,null))[_0x477d('0x25')](function(_0x4a3632){if(_0x4a3632){_0x1ea699=_0x4a3632;_0x4dc91e[_0x477d('0x39')]=_[_0x477d('0x4c')](db[_0x477d('0x75')][_0x477d('0x4d')]);_0x4dc91e[_0x477d('0x3a')]=_[_0x477d('0x4c')](_0x3da01d['query']);_0x4dc91e[_0x477d('0x3b')]=_['intersection'](_0x4dc91e[_0x477d('0x39')],_0x4dc91e['query']);_0x109acb[_0x477d('0x3f')]=_[_0x477d('0x3c')](_0x4dc91e['model'],qs[_0x477d('0x3d')](_0x3da01d[_0x477d('0x3a')][_0x477d('0x3d')]));_0x109acb[_0x477d('0x3f')]=_0x109acb[_0x477d('0x3f')]['length']?_0x109acb[_0x477d('0x3f')]:_0x4dc91e[_0x477d('0x39')];_0x109acb['order']=qs['sort'](_0x3da01d[_0x477d('0x3a')]['sort']);_0x109acb[_0x477d('0x43')]=qs['filters'](_[_0x477d('0x44')](_0x3da01d[_0x477d('0x3a')],_0x4dc91e['filters']));if(_0x3da01d['query'][_0x477d('0x2b')]){_0x109acb['where']=_[_0x477d('0x45')](_0x109acb[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0x109acb['attributes'],function(_0x2ef92a){var _0x487640={};_0x487640[_0x2ef92a]={'$like':'%'+_0x3da01d['query'][_0x477d('0x2b')]+'%'};return _0x487640;})});}_0x109acb=_[_0x477d('0x45')]({},_0x109acb,_0x3da01d[_0x477d('0x4e')]);return _0x1ea699[_0x477d('0x94')](_0x109acb);}})['then'](function(_0x3a699b){if(_0x3a699b){_0x517536=_0x3a699b[_0x477d('0x3e')];if(!_0x3da01d[_0x477d('0x3a')][_0x477d('0x60')](_0x477d('0x40'))){_0x109acb[_0x477d('0x1e')]=qs[_0x477d('0x1e')](_0x3da01d[_0x477d('0x3a')][_0x477d('0x1e')]);_0x109acb['offset']=qs[_0x477d('0x1c')](_0x3da01d[_0x477d('0x3a')][_0x477d('0x1c')]);}return _0x1ea699[_0x477d('0x94')](_0x109acb);}})['then'](function(_0x5c03f5){return _0x5c03f5?{'count':_0x517536,'rows':_0x5c03f5}:null;})[_0x477d('0x25')](respondWithResult(_0x17b2e2,null))['catch'](handleError(_0x17b2e2,null));};exports[_0x477d('0x95')]=function(_0x4ac7a7,_0x33f153,_0x29715b){var _0x4212e4={};var _0x48934d={};var _0x9fef79;var _0x2720cb;return db['VoiceQueue'][_0x477d('0x5f')]({'where':{'id':_0x4ac7a7[_0x477d('0x4b')]['id']}})['then'](handleEntityNotFound(_0x33f153,null))[_0x477d('0x25')](function(_0x583deb){if(_0x583deb){_0x9fef79=_0x583deb;_0x48934d[_0x477d('0x39')]=_['keys'](db['CmList']['rawAttributes']);_0x48934d[_0x477d('0x3a')]=_[_0x477d('0x4c')](_0x4ac7a7['query']);_0x48934d[_0x477d('0x3b')]=_[_0x477d('0x3c')](_0x48934d[_0x477d('0x39')],_0x48934d[_0x477d('0x3a')]);_0x4212e4[_0x477d('0x3f')]=_[_0x477d('0x3c')](_0x48934d[_0x477d('0x39')],qs[_0x477d('0x3d')](_0x4ac7a7[_0x477d('0x3a')]['fields']));_0x4212e4[_0x477d('0x3f')]=_0x4212e4['attributes'][_0x477d('0x3e')]?_0x4212e4[_0x477d('0x3f')]:_0x48934d[_0x477d('0x39')];_0x4212e4[_0x477d('0x41')]=qs['sort'](_0x4ac7a7['query'][_0x477d('0x42')]);_0x4212e4['where']=qs[_0x477d('0x3b')](_[_0x477d('0x44')](_0x4ac7a7['query'],_0x48934d[_0x477d('0x3b')]));if(_0x4ac7a7[_0x477d('0x3a')][_0x477d('0x2b')]){_0x4212e4[_0x477d('0x43')]=_[_0x477d('0x45')](_0x4212e4[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0x4212e4[_0x477d('0x3f')],function(_0x3eff80){var _0x1104ba={};_0x1104ba[_0x3eff80]={'$like':'%'+_0x4ac7a7[_0x477d('0x3a')]['filter']+'%'};return _0x1104ba;})});}_0x4212e4=_[_0x477d('0x45')]({},_0x4212e4,_0x4ac7a7[_0x477d('0x4e')]);return _0x9fef79['getLists'](_0x4212e4);}})[_0x477d('0x25')](function(_0x98745){if(_0x98745){_0x2720cb=_0x98745['length'];if(!_0x4ac7a7['query'][_0x477d('0x60')](_0x477d('0x40'))){_0x4212e4[_0x477d('0x1e')]=qs[_0x477d('0x1e')](_0x4ac7a7[_0x477d('0x3a')][_0x477d('0x1e')]);_0x4212e4['offset']=qs['offset'](_0x4ac7a7['query'][_0x477d('0x1c')]);}return _0x9fef79[_0x477d('0x95')](_0x4212e4);}})[_0x477d('0x25')](function(_0x2a14f8){if(_0x2a14f8){return _0x2a14f8?{'count':_0x2720cb,'rows':_0x2a14f8}:null;}})[_0x477d('0x25')](respondWithResult(_0x33f153,null))[_0x477d('0x4a')](handleError(_0x33f153,null));};exports[_0x477d('0x96')]=function(_0x53bae5,_0x12ec9f,_0x2d7844){var _0x493bfa=moment()[_0x477d('0x78')]('YYYY-MM-DD\x20HH:mm:ss');var _0x5e9214,_0x506f4e;return db[_0x477d('0x37')][_0x477d('0x30')]({'where':{'id':_0x53bae5['params']['id']}})['then'](handleEntityNotFound(_0x12ec9f,null))[_0x477d('0x25')](function(_0x5953e4){if(_0x5953e4){_0x506f4e=_0x5953e4;return _0x5953e4['addLists'](_0x53bae5['body']['ids'],_['omit'](_0x53bae5['body'],['ids','id'])||{});}return null;})[_0x477d('0x8e')](function(_0x2b09f2){var _0x547b6d;_0x5e9214=_0x2b09f2||[];var _0x839ef0=[];if(_0x2b09f2){for(var _0x1c46ad=0x0;_0x1c46ad<_0x2b09f2[_0x477d('0x3e')];_0x1c46ad+=0x1){var _0x44b16f=_0x2b09f2[_0x1c46ad]['get']({'plain':!![]});_0x506f4e[_0x477d('0x97')]=_0x53bae5[_0x477d('0x50')][_0x477d('0x97')]?_0x53bae5[_0x477d('0x50')][_0x477d('0x97')]:_0x506f4e[_0x477d('0x97')];switch(_0x506f4e[_0x477d('0x97')]){case _0x477d('0x98'):_0x547b6d=squel[_0x477d('0x99')]()[_0x477d('0x9a')](_0x477d('0x9b'))[_0x477d('0x9c')]([_0x477d('0x9d'),'scheduledAt',_0x477d('0x9e'),'ListId',_0x477d('0x64'),_0x477d('0x5a'),_0x477d('0x5b')],squel[_0x477d('0x7c')]()[_0x477d('0x9f')](_0x477d('0x9d'),_0x477d('0x9d'))['field']('\x27'+_0x493bfa+'\x27','scheduledAt')[_0x477d('0x9f')]('id',_0x477d('0x9e'))[_0x477d('0x9f')](_0x44b16f[_0x477d('0xa0')][_0x477d('0xa1')](),_0x477d('0xa2'))[_0x477d('0x9f')](_0x53bae5[_0x477d('0x4b')]['id'][_0x477d('0xa1')](),_0x477d('0x64'))['field']('\x27'+_0x493bfa+'\x27',_0x477d('0x5a'))[_0x477d('0x9f')]('\x27'+_0x493bfa+'\x27',_0x477d('0x5b'))[_0x477d('0x7e')](_0x477d('0xa3'))[_0x477d('0x43')](_0x477d('0xa4'))[_0x477d('0x43')](_0x477d('0xa5'),_0x44b16f[_0x477d('0xa0')]['toString']())[_0x477d('0x43')](_0x477d('0xa6'))[_0x477d('0x43')](_0x477d('0xa7'),squel[_0x477d('0x7c')]()['field'](_0x477d('0xa8'))['from']('cm_hopper_final')[_0x477d('0x43')](_0x477d('0x81'),_0x53bae5['params']['id']['toString']()))[_0x477d('0x43')](_0x477d('0xa7'),squel[_0x477d('0x7c')]()[_0x477d('0x9f')](_0x477d('0xa9'))[_0x477d('0x7e')]('cm_hopper')[_0x477d('0x43')]('VoiceQueueId\x20=\x20?',_0x53bae5[_0x477d('0x4b')]['id'][_0x477d('0xa1')]())))[_0x477d('0xa1')]();break;case _0x477d('0xaa'):_0x547b6d=squel[_0x477d('0x99')]()[_0x477d('0x9a')](_0x477d('0x9b'))[_0x477d('0x9c')]([_0x477d('0x9d'),_0x477d('0xab'),_0x477d('0x9e'),_0x477d('0xa2'),_0x477d('0x64'),_0x477d('0x5a'),_0x477d('0x5b')],squel[_0x477d('0x7c')]()[_0x477d('0x9f')](_0x477d('0x9d'),'phone')[_0x477d('0x9f')]('\x27'+_0x493bfa+'\x27',_0x477d('0xab'))['field']('id','ContactId')[_0x477d('0x9f')](_0x44b16f['CmListId'][_0x477d('0xa1')](),_0x477d('0xa2'))['field'](_0x53bae5['params']['id']['toString'](),_0x477d('0x64'))[_0x477d('0x9f')]('\x27'+_0x493bfa+'\x27',_0x477d('0x5a'))[_0x477d('0x9f')]('\x27'+_0x493bfa+'\x27',_0x477d('0x5b'))['from']('cm_contacts')[_0x477d('0x43')](_0x477d('0xa4'))['where'](_0x477d('0xa5'),_0x44b16f['CmListId']['toString']())[_0x477d('0x43')](_0x477d('0xa6'))[_0x477d('0x43')](_0x477d('0xa7'),squel[_0x477d('0x7c')]()['field'](_0x477d('0xa9'))[_0x477d('0x7e')](_0x477d('0x9b'))[_0x477d('0x43')](_0x477d('0x81'),_0x53bae5[_0x477d('0x4b')]['id'][_0x477d('0xa1')]())))['toString']();break;default:_0x547b6d=squel[_0x477d('0x99')]()[_0x477d('0x9a')](_0x477d('0x9b'))[_0x477d('0x9c')](['phone',_0x477d('0xab'),_0x477d('0x9e'),_0x477d('0xa2'),'VoiceQueueId',_0x477d('0x5a'),_0x477d('0x5b')],squel[_0x477d('0x7c')]()[_0x477d('0x9f')](_0x477d('0x9d'),'phone')[_0x477d('0x9f')]('\x27'+_0x493bfa+'\x27','scheduledAt')[_0x477d('0x9f')]('id',_0x477d('0x9e'))[_0x477d('0x9f')](_0x44b16f['CmListId']['toString'](),'ListId')['field'](_0x53bae5['params']['id'][_0x477d('0xa1')](),_0x477d('0x64'))['field']('\x27'+_0x493bfa+'\x27',_0x477d('0x5a'))[_0x477d('0x9f')]('\x27'+_0x493bfa+'\x27',_0x477d('0x5b'))[_0x477d('0x7e')](_0x477d('0xa3'))[_0x477d('0x43')](_0x477d('0xa4'))[_0x477d('0x43')](_0x477d('0xa5'),_0x44b16f[_0x477d('0xa0')][_0x477d('0xa1')]())['where'](_0x477d('0xa6')))[_0x477d('0xa1')]();}_0x839ef0[_0x477d('0x90')](db[_0x477d('0x71')]['query'](_0x547b6d));}return BPromise[_0x477d('0x86')](_0x839ef0);}})[_0x477d('0x25')](function(){var _0x1d37d6=[];var _0x256bac=squel['insert']()[_0x477d('0x9a')](_0x477d('0xac'))['fromQuery']([_0x477d('0xad'),_0x477d('0x9d'),'OrderBy',_0x477d('0x5a'),_0x477d('0x5b')],squel[_0x477d('0x7c')]()[_0x477d('0x9f')](_0x477d('0xae'))[_0x477d('0x9f')](_0x477d('0xaf'))[_0x477d('0x9f')](_0x477d('0xb0'))[_0x477d('0x9f')]('\x27'+_0x493bfa+'\x27',_0x477d('0x5a'))[_0x477d('0x9f')]('\x27'+_0x493bfa+'\x27','updatedAt')['from'](_0x477d('0xb1'),'ci')[_0x477d('0x7f')](_0x477d('0x9b'),'h',_0x477d('0xb2'))[_0x477d('0x43')]('h.scheduledat=?',_0x493bfa)[_0x477d('0x43')](_0x477d('0xb3'),_0x477d('0xb4')))[_0x477d('0xa1')]();_0x1d37d6['push'](db[_0x477d('0x71')][_0x477d('0x3a')](_0x256bac));return BPromise['all'](_0x1d37d6);})[_0x477d('0x25')](function(){return _0x5e9214;})[_0x477d('0x25')](respondWithResult(_0x12ec9f,null))[_0x477d('0x4a')](handleError(_0x12ec9f,null));};exports[_0x477d('0xb5')]=function(_0x585f7e,_0x3faf93,_0x3f085d){return db['VoiceQueue'][_0x477d('0x30')]({'where':{'id':_0x585f7e[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x3faf93,null))[_0x477d('0x25')](function(_0xd68325){if(_0xd68325){return _0xd68325[_0x477d('0xb5')](_0x585f7e[_0x477d('0x3a')][_0x477d('0x89')]);}})[_0x477d('0x25')](function(_0x318107){if(_0x318107){return db[_0x477d('0x61')][_0x477d('0x26')]({'where':{'ListId':_0x585f7e['query']['ids'],'VoiceQueueId':_0x585f7e[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](function(){return _0x318107;});}})['then'](respondWithStatusCode(_0x3faf93,null))[_0x477d('0x4a')](handleError(_0x3faf93,null));};exports[_0x477d('0xb6')]=function(_0xb71be6,_0x294394,_0x5dba15){var _0x1eb546={};var _0xc8a414={};var _0x211f74;var _0xc13868;return db['VoiceQueue'][_0x477d('0x5f')]({'where':{'id':_0xb71be6['params']['id']}})['then'](handleEntityNotFound(_0x294394,null))[_0x477d('0x25')](function(_0x2833c3){if(_0x2833c3){_0x211f74=_0x2833c3;_0xc8a414[_0x477d('0x39')]=_['keys'](db[_0x477d('0xb7')][_0x477d('0x4d')]);_0xc8a414['query']=_[_0x477d('0x4c')](_0xb71be6[_0x477d('0x3a')]);_0xc8a414[_0x477d('0x3b')]=_[_0x477d('0x3c')](_0xc8a414[_0x477d('0x39')],_0xc8a414[_0x477d('0x3a')]);_0x1eb546[_0x477d('0x3f')]=_[_0x477d('0x3c')](_0xc8a414['model'],qs[_0x477d('0x3d')](_0xb71be6[_0x477d('0x3a')][_0x477d('0x3d')]));_0x1eb546[_0x477d('0x3f')]=_0x1eb546[_0x477d('0x3f')][_0x477d('0x3e')]?_0x1eb546['attributes']:_0xc8a414[_0x477d('0x39')];_0x1eb546[_0x477d('0x41')]=qs[_0x477d('0x42')](_0xb71be6[_0x477d('0x3a')][_0x477d('0x42')]);_0x1eb546[_0x477d('0x43')]=qs[_0x477d('0x3b')](_[_0x477d('0x44')](_0xb71be6['query'],_0xc8a414[_0x477d('0x3b')]));if(_0xb71be6[_0x477d('0x3a')][_0x477d('0x2b')]){_0x1eb546[_0x477d('0x43')]=_[_0x477d('0x45')](_0x1eb546[_0x477d('0x43')],{'$or':_[_0x477d('0x36')](_0x1eb546[_0x477d('0x3f')],function(_0x2cdbd2){var _0x101d6f={};_0x101d6f[_0x2cdbd2]={'$like':'%'+_0xb71be6[_0x477d('0x3a')][_0x477d('0x2b')]+'%'};return _0x101d6f;})});}_0x1eb546=_[_0x477d('0x45')]({},_0x1eb546,_0xb71be6[_0x477d('0x4e')]);return _0x211f74[_0x477d('0xb6')](_0x1eb546);}})['then'](function(_0x41cd11){if(_0x41cd11){_0xc13868=_0x41cd11[_0x477d('0x3e')];if(!_0xb71be6['query'][_0x477d('0x60')](_0x477d('0x40'))){_0x1eb546[_0x477d('0x1e')]=qs[_0x477d('0x1e')](_0xb71be6['query']['limit']);_0x1eb546[_0x477d('0x1c')]=qs['offset'](_0xb71be6[_0x477d('0x3a')]['offset']);}return _0x211f74['getBlackLists'](_0x1eb546);}})[_0x477d('0x25')](function(_0x500ac0){if(_0x500ac0){return _0x500ac0?{'count':_0xc13868,'rows':_0x500ac0}:null;}})[_0x477d('0x25')](respondWithResult(_0x294394,null))[_0x477d('0x4a')](handleError(_0x294394,null));};exports[_0x477d('0xb8')]=function(_0x42af76,_0x1ef70f,_0xb4dad0){var _0x2b84b9,_0x281a7a;return db[_0x477d('0x37')][_0x477d('0x30')]({'where':{'id':_0x42af76[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x1ef70f,null))[_0x477d('0x25')](function(_0x2d699f){if(_0x2d699f){_0x281a7a=_0x2d699f;return _0x2d699f[_0x477d('0xb8')](_0x42af76['body'][_0x477d('0x89')],_[_0x477d('0x59')](_0x42af76[_0x477d('0x50')],[_0x477d('0x89'),'id'])||{});}return null;})[_0x477d('0x8e')](function(_0x1e8632){var _0x3848dd;_0x2b84b9=_0x1e8632||[];var _0x1666b1=[];if(_0x1e8632){for(var _0x4d88b5=0x0;_0x4d88b5<_0x1e8632[_0x477d('0x3e')];_0x4d88b5+=0x1){var _0x2c5a62=_0x1e8632[_0x4d88b5][_0x477d('0x27')]({'plain':!![]});_0x3848dd=squel[_0x477d('0x99')]()['into'](_0x477d('0xb9'))[_0x477d('0x9c')]([_0x477d('0x9d'),'ContactId',_0x477d('0xa2'),_0x477d('0x64'),_0x477d('0x5a'),_0x477d('0x5b')],squel[_0x477d('0x7c')]()['field'](_0x477d('0x9d'),_0x477d('0x9d'))[_0x477d('0x9f')]('id',_0x477d('0x9e'))[_0x477d('0x9f')](_0x2c5a62[_0x477d('0xa0')][_0x477d('0xa1')](),'ListId')[_0x477d('0x9f')](_0x42af76['params']['id']['toString'](),'VoiceQueueId')[_0x477d('0x9f')]('NOW()',_0x477d('0x5a'))['field'](_0x477d('0xba'),'updatedAt')[_0x477d('0x7e')](_0x477d('0xa3'))[_0x477d('0x43')](_0x477d('0xa4'))[_0x477d('0x43')](_0x477d('0xa5'),_0x2c5a62[_0x477d('0xa0')]['toString']())[_0x477d('0x43')](_0x477d('0xa6')))[_0x477d('0xa1')]();_0x1666b1[_0x477d('0x90')](db[_0x477d('0x71')][_0x477d('0x3a')](_0x3848dd));}return BPromise[_0x477d('0x86')](_0x1666b1);}})[_0x477d('0x25')](function(){return _0x2b84b9;})[_0x477d('0x25')](respondWithResult(_0x1ef70f,null))[_0x477d('0x4a')](handleError(_0x1ef70f,null));};exports[_0x477d('0xbb')]=function(_0x3a26b9,_0x488cf9,_0x3dd854){return db[_0x477d('0x37')]['find']({'where':{'id':_0x3a26b9['params']['id']}})[_0x477d('0x25')](handleEntityNotFound(_0x488cf9,null))[_0x477d('0x25')](function(_0x4095d0){if(_0x4095d0){return _0x4095d0[_0x477d('0xbb')](_0x3a26b9[_0x477d('0x3a')][_0x477d('0x89')]);}})[_0x477d('0x25')](function(_0x46f63c){if(_0x46f63c){return db['CmHopperBlack'][_0x477d('0x26')]({'where':{'ListId':_0x3a26b9[_0x477d('0x3a')][_0x477d('0x89')],'VoiceQueueId':_0x3a26b9[_0x477d('0x4b')]['id']}})[_0x477d('0x25')](function(){return _0x46f63c;});}})[_0x477d('0x25')](respondWithStatusCode(_0x488cf9,null))[_0x477d('0x4a')](handleError(_0x488cf9,null));};
git://repos.xcallymotion.com / motion2.git / blob