// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6778=['field','NOW()','scheduledAt','ContactId','CmListId','toString','from','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','select','cm_hopper_final','VoiceQueueId\x20=\x20?','onlyIfOpen','into','ListId','cm_contacts','deletedAt\x20IS\x20NULL','insert','fromQuery','sequelize','removeLists','getBlackLists','CmList','addBlackLists','removeBlackLists','bluebird','mustache','util','path','sox','to-csv','ejs','squel','jsforce','querystring','../../config/logger','api','../../config/environment','../../mysqldb','socket.io-emitter','localhost','./voiceQueue.socket','register','sendStatus','end','json','count','offset','limit','status','set','Content-Range','save','update','then','stack','name','send','index','VoiceQueue','model','keys','query','dateStart','dateEnd','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','add','day','merge','filter','map','options','includeAll','include','findAll','rows','catch','show','params','find','create','clone','get','omit','body','createdAt','updatedAt','destroy','rawAttributes','CmHopper','findOne','CmHopperHistory','pick','VoiceQueueId','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','ids','User','Agents','union','addAgents','penalty','addTeams','removeTeams','removeAgents','spread','emit','loginInPause','voicePause','push','UserVoiceQueueRt','upsert','format','%s/%s','SIP','all','isArray','userVoiceQueue:remove','realtime','getAgents','getMembers','getLists','addLists','dialCheckDuplicateType','always','cm_hopper','phone'];(function(_0x2e50bc,_0x28b59d){var _0x1deeb4=function(_0x3084f1){while(--_0x3084f1){_0x2e50bc['push'](_0x2e50bc['shift']());}};_0x1deeb4(++_0x28b59d);}(_0x6778,0x134));var _0x8677=function(_0x2cde0a,_0x1f9695){_0x2cde0a=_0x2cde0a-0x0;var _0x260610=_0x6778[_0x2cde0a];return _0x260610;};'use strict';var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x8677('0x0'));var Mustache=require(_0x8677('0x1'));var util=require(_0x8677('0x2'));var path=require(_0x8677('0x3'));var sox=require(_0x8677('0x4'));var csv=require(_0x8677('0x5'));var ejs=require(_0x8677('0x6'));var fs=require('fs');var _=require('lodash');var squel=require(_0x8677('0x7'));var crypto=require('crypto');var jsforce=require(_0x8677('0x8'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x8677('0x9'));var Papa=require('papaparse');var qs=require('../../components/parsers/qs');var logger=require(_0x8677('0xa'))(_0x8677('0xb'));var utils=require('../../config/utils');var config=require(_0x8677('0xc'));var db=require(_0x8677('0xd'))['db'];var socket=require(_0x8677('0xe'))({'host':_0x8677('0xf'),'port':0x18eb});require(_0x8677('0x10'))[_0x8677('0x11')](socket);function respondWithStatusCode(_0x3cfcf8,_0x308d05){_0x308d05=_0x308d05||0xcc;return function(_0x2db6c2){if(_0x2db6c2){return _0x3cfcf8[_0x8677('0x12')](_0x308d05);}return _0x3cfcf8['status'](_0x308d05)[_0x8677('0x13')]();};}function respondWithResult(_0x399e6e,_0x2500bf){_0x2500bf=_0x2500bf||0xc8;return function(_0x285b6a){if(_0x285b6a){return _0x399e6e['status'](_0x2500bf)[_0x8677('0x14')](_0x285b6a);}};}function respondWithFilteredResult(_0x493fbb,_0x56c92b){return function(_0x832a53){if(_0x832a53){var _0x5cbdeb=_0x832a53[_0x8677('0x15')],_0x5e5458=_0x56c92b[_0x8677('0x16')],_0x3a4ad8=_0x56c92b[_0x8677('0x16')]+_0x56c92b[_0x8677('0x17')],_0x3516fa;if(_0x3a4ad8>=_0x5cbdeb){_0x3a4ad8=_0x5cbdeb;_0x3516fa=0xc8;}else{_0x3516fa=0xce;}_0x493fbb[_0x8677('0x18')](_0x3516fa);return _0x493fbb[_0x8677('0x19')](_0x8677('0x1a'),_0x5e5458+'-'+_0x3a4ad8+'/'+_0x5cbdeb)[_0x8677('0x14')](_0x832a53);}return null;};}function patchUpdates(_0x2f481a){return function(_0x2034b9){try{jsonpatch['apply'](_0x2034b9,_0x2f481a,!![]);}catch(_0x1e714d){return BPromise['reject'](_0x1e714d);}return _0x2034b9[_0x8677('0x1b')]();};}function saveUpdates(_0x273173,_0x4e9ad3){return function(_0x322a8f){if(_0x322a8f){return _0x322a8f[_0x8677('0x1c')](_0x273173)[_0x8677('0x1d')](function(_0x1cfa93){return _0x1cfa93;});}return null;};}function removeEntity(_0x3222da,_0x4fb4a2){return function(_0x2ef16a){if(_0x2ef16a){return _0x2ef16a['destroy']()[_0x8677('0x1d')](function(){_0x3222da[_0x8677('0x18')](0xcc)[_0x8677('0x13')]();});}};}function handleEntityNotFound(_0x28a0ac,_0x205cb1){return function(_0x206d88){if(!_0x206d88){_0x28a0ac[_0x8677('0x12')](0x194);}return _0x206d88;};}function handleError(_0x2c4b45,_0x399cf4){_0x399cf4=_0x399cf4||0x1f4;return function(_0x4ed524){logger['error'](_0x4ed524[_0x8677('0x1e')]);if(_0x4ed524[_0x8677('0x1f')]){delete _0x4ed524[_0x8677('0x1f')];}_0x2c4b45['status'](_0x399cf4)[_0x8677('0x20')](_0x4ed524);};}exports[_0x8677('0x21')]=function(_0x2bd318,_0xd1efa1){var _0x2c5438={},_0x41dd0a={},_0x9175f9={'count':0x0,'rows':[]};var _0x113448=db[_0x8677('0x22')]['rawAttributes'];_0x41dd0a[_0x8677('0x23')]=_[_0x8677('0x24')](_0x113448);var _0x23c5ba={'dateStart':_0x2bd318[_0x8677('0x25')][_0x8677('0x26')],'dateEnd':_0x2bd318[_0x8677('0x25')][_0x8677('0x27')]};delete _0x2bd318[_0x8677('0x25')][_0x8677('0x26')];delete _0x2bd318[_0x8677('0x25')]['dateEnd'];_0x41dd0a['query']=_['keys'](_0x2bd318[_0x8677('0x25')]);_0x41dd0a['filters']=_[_0x8677('0x28')](_0x41dd0a[_0x8677('0x23')],_0x41dd0a[_0x8677('0x25')]);_0x2c5438['attributes']=_[_0x8677('0x28')](_0x41dd0a['model'],qs[_0x8677('0x29')](_0x2bd318[_0x8677('0x25')]['fields']));_0x2c5438['attributes']=_0x2c5438[_0x8677('0x2a')][_0x8677('0x2b')]?_0x2c5438[_0x8677('0x2a')]:_0x41dd0a[_0x8677('0x23')];if(!_0x2bd318[_0x8677('0x25')][_0x8677('0x2c')](_0x8677('0x2d'))){_0x2c5438[_0x8677('0x17')]=qs[_0x8677('0x17')](_0x2bd318[_0x8677('0x25')][_0x8677('0x17')]);_0x2c5438['offset']=qs[_0x8677('0x16')](_0x2bd318['query'][_0x8677('0x16')]);}_0x2c5438[_0x8677('0x2e')]=qs[_0x8677('0x2f')](_0x2bd318[_0x8677('0x25')][_0x8677('0x2f')]);_0x2c5438[_0x8677('0x30')]=qs['filters'](_['pick'](_0x2bd318[_0x8677('0x25')],_0x41dd0a[_0x8677('0x31')]));if(_0x23c5ba[_0x8677('0x26')]){if(_0x23c5ba['dateEnd']){_0x23c5ba[_0x8677('0x27')]=moment(_0x23c5ba[_0x8677('0x27')])[_0x8677('0x32')](0x1,_0x8677('0x33'));}else{_0x23c5ba['dateEnd']=moment(_0x23c5ba['dateStart'])[_0x8677('0x32')](0x1,_0x8677('0x33'));}_[_0x8677('0x34')](_0x2c5438[_0x8677('0x30')],{'createdAt':{'$gte':_0x23c5ba[_0x8677('0x26')],'$lte':_0x23c5ba[_0x8677('0x27')]}});}if(_0x2bd318['query'][_0x8677('0x35')]){_0x2c5438[_0x8677('0x30')]=_[_0x8677('0x34')](_0x2c5438['where'],{'$or':_[_0x8677('0x36')](_0x2c5438[_0x8677('0x2a')],function(_0x182241){var _0x44c625={};_0x44c625[_0x182241]={'$like':'%'+_0x2bd318[_0x8677('0x25')][_0x8677('0x35')]+'%'};return _0x44c625;})});}_0x2c5438=_[_0x8677('0x34')]({},_0x2c5438,_0x2bd318[_0x8677('0x37')]);var _0x2c613a={'where':_0x2c5438[_0x8677('0x30')]};return db[_0x8677('0x22')]['count'](_0x2c613a)[_0x8677('0x1d')](function(_0x48c216){_0x9175f9[_0x8677('0x15')]=_0x48c216;if(_0x2bd318[_0x8677('0x25')][_0x8677('0x38')]){_0x2c5438[_0x8677('0x39')]=[{'all':!![]}];}return db[_0x8677('0x22')][_0x8677('0x3a')](_0x2c5438);})[_0x8677('0x1d')](function(_0x20f8f0){_0x9175f9[_0x8677('0x3b')]=_0x20f8f0;return _0x9175f9;})[_0x8677('0x1d')](respondWithFilteredResult(_0xd1efa1,_0x2c5438))[_0x8677('0x3c')](handleError(_0xd1efa1,null));};exports[_0x8677('0x3d')]=function(_0x57568e,_0x1d8803){var _0x11e9a3={'raw':![],'where':{'id':_0x57568e[_0x8677('0x3e')]['id']}},_0x5d9025={};_0x5d9025[_0x8677('0x23')]=_[_0x8677('0x24')](db[_0x8677('0x22')]['rawAttributes']);_0x5d9025[_0x8677('0x25')]=_['keys'](_0x57568e[_0x8677('0x25')]);_0x5d9025[_0x8677('0x31')]=_[_0x8677('0x28')](_0x5d9025[_0x8677('0x23')],_0x5d9025['query']);_0x11e9a3[_0x8677('0x2a')]=_[_0x8677('0x28')](_0x5d9025[_0x8677('0x23')],qs[_0x8677('0x29')](_0x57568e[_0x8677('0x25')]['fields']));_0x11e9a3[_0x8677('0x2a')]=_0x11e9a3[_0x8677('0x2a')][_0x8677('0x2b')]?_0x11e9a3[_0x8677('0x2a')]:_0x5d9025[_0x8677('0x23')];if(_0x57568e[_0x8677('0x25')][_0x8677('0x38')]){_0x11e9a3[_0x8677('0x39')]=[{'all':!![]}];}_0x11e9a3=_[_0x8677('0x34')]({},_0x11e9a3,_0x57568e['options']);return db[_0x8677('0x22')][_0x8677('0x3f')](_0x11e9a3)[_0x8677('0x1d')](handleEntityNotFound(_0x1d8803,null))[_0x8677('0x1d')](respondWithResult(_0x1d8803,null))['catch'](handleError(_0x1d8803,null));};exports[_0x8677('0x40')]=function(_0x45605e,_0x30deb4){return db[_0x8677('0x22')][_0x8677('0x40')](_0x45605e['body'],{})['then'](respondWithResult(_0x30deb4,0xc9))['catch'](handleError(_0x30deb4,null));};exports[_0x8677('0x41')]=function(_0xcd3380,_0x2c6b29){var _0x13cefb={'raw':![],'where':{'id':_0xcd3380['params']['id']}},_0x44c1f5={};_0x44c1f5[_0x8677('0x23')]=_[_0x8677('0x24')](db['VoiceQueue']['rawAttributes']);_0x13cefb['attributes']=_[_0x8677('0x28')](_0x44c1f5[_0x8677('0x23')],qs['fields'](_0xcd3380[_0x8677('0x25')]['fields']));_0x13cefb['attributes']=_0x13cefb[_0x8677('0x2a')][_0x8677('0x2b')]?_0x13cefb['attributes']:_0x44c1f5['model'];if(_0xcd3380[_0x8677('0x25')][_0x8677('0x38')]){_0x13cefb[_0x8677('0x39')]=[{'all':!![]}];}_0x13cefb=_[_0x8677('0x34')]({},_0x13cefb,_0xcd3380[_0x8677('0x37')]);return db['VoiceQueue'][_0x8677('0x3f')](_0x13cefb)['then'](handleEntityNotFound(_0x2c6b29,null))[_0x8677('0x1d')](function(_0x71671e){if(_0x71671e){var _0x3126e7=_0x71671e[_0x8677('0x42')]({'plain':!![]});_0x3126e7=qs[_0x8677('0x43')](_0x3126e7,['id','createdAt','updatedAt']);_0xcd3380[_0x8677('0x44')]=_[_0x8677('0x43')](_0xcd3380[_0x8677('0x44')],['id',_0x8677('0x45'),_0x8677('0x46')]);return db[_0x8677('0x22')]['create'](_[_0x8677('0x34')](_0x3126e7,_0xcd3380[_0x8677('0x44')]),{'include':_0xcd3380[_0x8677('0x25')][_0x8677('0x38')]?[{'all':!![]}]:undefined});}})[_0x8677('0x1d')](respondWithResult(_0x2c6b29,0xc9))['catch'](handleError(_0x2c6b29,null));};exports[_0x8677('0x1c')]=function(_0xfa2d2c,_0x1ff61a){if(_0xfa2d2c[_0x8677('0x44')]['id']){delete _0xfa2d2c[_0x8677('0x44')]['id'];}return db[_0x8677('0x22')][_0x8677('0x3f')]({'where':{'id':_0xfa2d2c[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x1ff61a,null))[_0x8677('0x1d')](saveUpdates(_0xfa2d2c[_0x8677('0x44')],null))[_0x8677('0x1d')](respondWithResult(_0x1ff61a,null))[_0x8677('0x3c')](handleError(_0x1ff61a,null));};exports[_0x8677('0x47')]=function(_0xdde493,_0x3514d2){return db['VoiceQueue'][_0x8677('0x3f')]({'where':{'id':_0xdde493[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x3514d2,null))[_0x8677('0x1d')](removeEntity(_0x3514d2,null))[_0x8677('0x3c')](handleError(_0x3514d2,null));};exports['getHoppers']=function(_0x3528ba,_0x4aaa97,_0x5b41eb){var _0x1de9c8={'raw':![],'where':{}};var _0x2d8e9a={};var _0x3fc9e5={'count':0x0,'rows':[]};return db[_0x8677('0x22')]['findOne']({'where':{'id':_0x3528ba['params']['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x4aaa97,null))[_0x8677('0x1d')](function(_0x202733){if(_0x202733){_0x2d8e9a[_0x8677('0x23')]=_['keys'](db['CmHopper'][_0x8677('0x48')]);_0x2d8e9a[_0x8677('0x25')]=_[_0x8677('0x24')](_0x3528ba[_0x8677('0x25')]);_0x2d8e9a[_0x8677('0x31')]=_['intersection'](_0x2d8e9a[_0x8677('0x23')],_0x2d8e9a[_0x8677('0x25')]);_0x1de9c8['attributes']=_[_0x8677('0x28')](_0x2d8e9a[_0x8677('0x23')],qs['fields'](_0x3528ba['query']['fields']));_0x1de9c8[_0x8677('0x2a')]=_0x1de9c8[_0x8677('0x2a')]['length']?_0x1de9c8['attributes']:_0x2d8e9a[_0x8677('0x23')];if(!_0x3528ba[_0x8677('0x25')][_0x8677('0x2c')]('nolimit')){_0x1de9c8[_0x8677('0x17')]=qs['limit'](_0x3528ba['query'][_0x8677('0x17')]);_0x1de9c8[_0x8677('0x16')]=qs[_0x8677('0x16')](_0x3528ba[_0x8677('0x25')][_0x8677('0x16')]);}_0x1de9c8['order']=qs['sort'](_0x3528ba[_0x8677('0x25')][_0x8677('0x2f')]);_0x1de9c8[_0x8677('0x30')]=qs[_0x8677('0x31')](_['pick'](_0x3528ba[_0x8677('0x25')],_0x2d8e9a[_0x8677('0x31')]));_0x1de9c8[_0x8677('0x30')]['VoiceQueueId']=_0x202733['id'];if(_0x3528ba['query'][_0x8677('0x35')]){_0x1de9c8[_0x8677('0x30')]=_[_0x8677('0x34')](_0x1de9c8['where'],{'$or':_[_0x8677('0x36')](_0x1de9c8[_0x8677('0x2a')],function(_0x55bbc6){var _0x2ad449={};_0x2ad449[_0x55bbc6]={'$like':'%'+_0x3528ba[_0x8677('0x25')][_0x8677('0x35')]+'%'};return _0x2ad449;})});}_0x1de9c8=_[_0x8677('0x34')]({},_0x1de9c8,_0x3528ba[_0x8677('0x37')]);return db[_0x8677('0x49')][_0x8677('0x15')]({'where':_0x1de9c8[_0x8677('0x30')]})[_0x8677('0x1d')](function(_0x16ac6e){_0x3fc9e5[_0x8677('0x15')]=_0x16ac6e;if(_0x3528ba['query'][_0x8677('0x38')]){_0x1de9c8[_0x8677('0x39')]=[{'all':!![]}];}return db['CmHopper'][_0x8677('0x3a')](_0x1de9c8);})[_0x8677('0x1d')](function(_0x358820){_0x3fc9e5['rows']=_0x358820;return _0x3fc9e5;});}})[_0x8677('0x1d')](respondWithFilteredResult(_0x4aaa97,_0x1de9c8))[_0x8677('0x3c')](handleError(_0x4aaa97,null));};exports['getHopperHistories']=function(_0x510fc1,_0x1277c8,_0x3609ae){var _0x78710c={'raw':!![],'where':{}};var _0x53a6b2={};var _0x2a5a70={'count':0x0,'rows':[]};return db[_0x8677('0x22')][_0x8677('0x4a')]({'where':{'id':_0x510fc1[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x1277c8,null))[_0x8677('0x1d')](function(_0x21c7ec){if(_0x21c7ec){_0x53a6b2['model']=_[_0x8677('0x24')](db[_0x8677('0x4b')][_0x8677('0x48')]);_0x53a6b2[_0x8677('0x25')]=_[_0x8677('0x24')](_0x510fc1[_0x8677('0x25')]);_0x53a6b2[_0x8677('0x31')]=_[_0x8677('0x28')](_0x53a6b2[_0x8677('0x23')],_0x53a6b2['query']);_0x78710c['attributes']=_[_0x8677('0x28')](_0x53a6b2[_0x8677('0x23')],qs[_0x8677('0x29')](_0x510fc1[_0x8677('0x25')][_0x8677('0x29')]));_0x78710c['attributes']=_0x78710c[_0x8677('0x2a')][_0x8677('0x2b')]?_0x78710c[_0x8677('0x2a')]:_0x53a6b2[_0x8677('0x23')];if(!_0x510fc1[_0x8677('0x25')][_0x8677('0x2c')](_0x8677('0x2d'))){_0x78710c['limit']=qs[_0x8677('0x17')](_0x510fc1['query'][_0x8677('0x17')]);_0x78710c[_0x8677('0x16')]=qs[_0x8677('0x16')](_0x510fc1['query']['offset']);}_0x78710c[_0x8677('0x2e')]=qs['sort'](_0x510fc1['query']['sort']);_0x78710c['where']=qs['filters'](_[_0x8677('0x4c')](_0x510fc1['query'],_0x53a6b2['filters']));_0x78710c[_0x8677('0x30')][_0x8677('0x4d')]=_0x21c7ec['id'];if(_0x510fc1[_0x8677('0x25')][_0x8677('0x35')]){_0x78710c[_0x8677('0x30')]=_[_0x8677('0x34')](_0x78710c[_0x8677('0x30')],{'$or':_[_0x8677('0x36')](_0x78710c[_0x8677('0x2a')],function(_0x468919){var _0x3e96b5={};_0x3e96b5[_0x468919]={'$like':'%'+_0x510fc1[_0x8677('0x25')][_0x8677('0x35')]+'%'};return _0x3e96b5;})});}_0x78710c=_[_0x8677('0x34')]({},_0x78710c,_0x510fc1[_0x8677('0x37')]);return db[_0x8677('0x4b')][_0x8677('0x15')]({'where':_0x78710c[_0x8677('0x30')]})[_0x8677('0x1d')](function(_0x37f134){_0x2a5a70[_0x8677('0x15')]=_0x37f134;if(_0x510fc1[_0x8677('0x25')][_0x8677('0x38')]){_0x78710c[_0x8677('0x39')]=[{'all':!![]}];}return db[_0x8677('0x4b')][_0x8677('0x3a')](_0x78710c);})[_0x8677('0x1d')](function(_0x24894c){_0x2a5a70[_0x8677('0x3b')]=_0x24894c;return _0x2a5a70;});}})[_0x8677('0x1d')](respondWithFilteredResult(_0x1277c8,_0x78710c))['catch'](handleError(_0x1277c8,null));};exports[_0x8677('0x4e')]=function(_0x26379a,_0x166a9b,_0x2da146){var _0x45de24={'raw':!![],'where':{}};var _0xc64c93={};var _0xa494d6={'count':0x0,'rows':[]};return db[_0x8677('0x22')][_0x8677('0x4a')]({'where':{'id':_0x26379a[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x166a9b,null))[_0x8677('0x1d')](function(_0xb9282a){if(_0xb9282a){_0xc64c93[_0x8677('0x23')]=_[_0x8677('0x24')](db['CmHopperFinal'][_0x8677('0x48')]);_0xc64c93[_0x8677('0x25')]=_[_0x8677('0x24')](_0x26379a[_0x8677('0x25')]);_0xc64c93[_0x8677('0x31')]=_[_0x8677('0x28')](_0xc64c93[_0x8677('0x23')],_0xc64c93[_0x8677('0x25')]);_0x45de24[_0x8677('0x2a')]=_['intersection'](_0xc64c93['model'],qs[_0x8677('0x29')](_0x26379a[_0x8677('0x25')]['fields']));_0x45de24[_0x8677('0x2a')]=_0x45de24[_0x8677('0x2a')]['length']?_0x45de24['attributes']:_0xc64c93[_0x8677('0x23')];if(!_0x26379a[_0x8677('0x25')][_0x8677('0x2c')](_0x8677('0x2d'))){_0x45de24[_0x8677('0x17')]=qs[_0x8677('0x17')](_0x26379a[_0x8677('0x25')][_0x8677('0x17')]);_0x45de24[_0x8677('0x16')]=qs['offset'](_0x26379a[_0x8677('0x25')][_0x8677('0x16')]);}_0x45de24[_0x8677('0x2e')]=qs[_0x8677('0x2f')](_0x26379a[_0x8677('0x25')][_0x8677('0x2f')]);_0x45de24[_0x8677('0x30')]=qs[_0x8677('0x31')](_[_0x8677('0x4c')](_0x26379a['query'],_0xc64c93['filters']));_0x45de24[_0x8677('0x30')]['VoiceQueueId']=_0xb9282a['id'];if(_0x26379a[_0x8677('0x25')][_0x8677('0x35')]){_0x45de24['where']=_[_0x8677('0x34')](_0x45de24[_0x8677('0x30')],{'$or':_[_0x8677('0x36')](_0x45de24[_0x8677('0x2a')],function(_0x280e99){var _0xe986d6={};_0xe986d6[_0x280e99]={'$like':'%'+_0x26379a[_0x8677('0x25')]['filter']+'%'};return _0xe986d6;})});}_0x45de24=_[_0x8677('0x34')]({},_0x45de24,_0x26379a[_0x8677('0x37')]);return db['CmHopperFinal'][_0x8677('0x15')]({'where':_0x45de24[_0x8677('0x30')]})[_0x8677('0x1d')](function(_0x16372d){_0xa494d6['count']=_0x16372d;if(_0x26379a[_0x8677('0x25')][_0x8677('0x38')]){_0x45de24['include']=[{'all':!![]}];}return db[_0x8677('0x4f')][_0x8677('0x3a')](_0x45de24);})[_0x8677('0x1d')](function(_0x275ec7){_0xa494d6[_0x8677('0x3b')]=_0x275ec7;return _0xa494d6;});}})['then'](respondWithFilteredResult(_0x166a9b,_0x45de24))['catch'](handleError(_0x166a9b,null));};exports[_0x8677('0x50')]=function(_0x3d1eb8,_0x34628e,_0x2da60a){var _0x30c095={'raw':!![],'where':{}};var _0x2f5db5={};var _0x397609={'count':0x0,'rows':[]};return db[_0x8677('0x22')][_0x8677('0x4a')]({'where':{'id':_0x3d1eb8[_0x8677('0x3e')]['id']}})['then'](handleEntityNotFound(_0x34628e,null))[_0x8677('0x1d')](function(_0x4b65f3){if(_0x4b65f3){_0x2f5db5['model']=_['keys'](db['CmHopperBlack'][_0x8677('0x48')]);_0x2f5db5[_0x8677('0x25')]=_[_0x8677('0x24')](_0x3d1eb8['query']);_0x2f5db5[_0x8677('0x31')]=_['intersection'](_0x2f5db5['model'],_0x2f5db5[_0x8677('0x25')]);_0x30c095[_0x8677('0x2a')]=_[_0x8677('0x28')](_0x2f5db5[_0x8677('0x23')],qs[_0x8677('0x29')](_0x3d1eb8['query'][_0x8677('0x29')]));_0x30c095['attributes']=_0x30c095[_0x8677('0x2a')][_0x8677('0x2b')]?_0x30c095[_0x8677('0x2a')]:_0x2f5db5[_0x8677('0x23')];if(!_0x3d1eb8['query'][_0x8677('0x2c')](_0x8677('0x2d'))){_0x30c095['limit']=qs['limit'](_0x3d1eb8[_0x8677('0x25')]['limit']);_0x30c095['offset']=qs[_0x8677('0x16')](_0x3d1eb8[_0x8677('0x25')][_0x8677('0x16')]);}_0x30c095[_0x8677('0x2e')]=qs[_0x8677('0x2f')](_0x3d1eb8['query'][_0x8677('0x2f')]);_0x30c095[_0x8677('0x30')]=qs[_0x8677('0x31')](_[_0x8677('0x4c')](_0x3d1eb8[_0x8677('0x25')],_0x2f5db5[_0x8677('0x31')]));_0x30c095['where'][_0x8677('0x4d')]=_0x4b65f3['id'];if(_0x3d1eb8[_0x8677('0x25')][_0x8677('0x35')]){_0x30c095[_0x8677('0x30')]=_[_0x8677('0x34')](_0x30c095[_0x8677('0x30')],{'$or':_[_0x8677('0x36')](_0x30c095['attributes'],function(_0x566a6e){var _0xd01e60={};_0xd01e60[_0x566a6e]={'$like':'%'+_0x3d1eb8['query'][_0x8677('0x35')]+'%'};return _0xd01e60;})});}_0x30c095=_['merge']({},_0x30c095,_0x3d1eb8[_0x8677('0x37')]);return db['CmHopperBlack'][_0x8677('0x15')]({'where':_0x30c095[_0x8677('0x30')]})[_0x8677('0x1d')](function(_0x448bec){_0x397609['count']=_0x448bec;if(_0x3d1eb8[_0x8677('0x25')]['includeAll']){_0x30c095[_0x8677('0x39')]=[{'all':!![]}];}return db[_0x8677('0x51')][_0x8677('0x3a')](_0x30c095);})[_0x8677('0x1d')](function(_0x3f2dd9){_0x397609['rows']=_0x3f2dd9;return _0x397609;});}})['then'](respondWithFilteredResult(_0x34628e,_0x30c095))[_0x8677('0x3c')](handleError(_0x34628e,null));};exports[_0x8677('0x52')]=function(_0x58eb98,_0x4eca10,_0x3eaf78){var _0x4788c4={};var _0x221566={};var _0xd49bf7;var _0xcf127b;return db[_0x8677('0x22')]['findOne']({'where':{'id':_0x58eb98[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x4eca10,null))['then'](function(_0x273190){if(_0x273190){_0xd49bf7=_0x273190;_0x221566[_0x8677('0x23')]=_[_0x8677('0x24')](db[_0x8677('0x53')]['rawAttributes']);_0x221566[_0x8677('0x25')]=_[_0x8677('0x24')](_0x58eb98['query']);_0x221566[_0x8677('0x31')]=_[_0x8677('0x28')](_0x221566[_0x8677('0x23')],_0x221566[_0x8677('0x25')]);_0x4788c4[_0x8677('0x2a')]=_[_0x8677('0x28')](_0x221566[_0x8677('0x23')],qs[_0x8677('0x29')](_0x58eb98[_0x8677('0x25')][_0x8677('0x29')]));_0x4788c4[_0x8677('0x2a')]=_0x4788c4['attributes'][_0x8677('0x2b')]?_0x4788c4['attributes']:_0x221566['model'];_0x4788c4[_0x8677('0x2e')]=qs[_0x8677('0x2f')](_0x58eb98['query'][_0x8677('0x2f')]);_0x4788c4[_0x8677('0x30')]=qs[_0x8677('0x31')](_[_0x8677('0x4c')](_0x58eb98['query'],_0x221566['filters']));if(_0x58eb98[_0x8677('0x25')][_0x8677('0x35')]){_0x4788c4[_0x8677('0x30')]=_[_0x8677('0x34')](_0x4788c4[_0x8677('0x30')],{'$or':_['map'](_0x4788c4[_0x8677('0x2a')],function(_0x2016d7){var _0x5eb180={};_0x5eb180[_0x2016d7]={'$like':'%'+_0x58eb98[_0x8677('0x25')][_0x8677('0x35')]+'%'};return _0x5eb180;})});}_0x4788c4=_[_0x8677('0x34')]({},_0x4788c4,_0x58eb98['options']);return _0xd49bf7[_0x8677('0x52')](_0x4788c4);}})['then'](function(_0x1fd2b6){if(_0x1fd2b6){_0xcf127b=_0x1fd2b6[_0x8677('0x2b')];if(!_0x58eb98['query'][_0x8677('0x2c')](_0x8677('0x2d'))){_0x4788c4[_0x8677('0x17')]=qs[_0x8677('0x17')](_0x58eb98[_0x8677('0x25')][_0x8677('0x17')]);_0x4788c4[_0x8677('0x16')]=qs[_0x8677('0x16')](_0x58eb98[_0x8677('0x25')]['offset']);}return _0xd49bf7[_0x8677('0x52')](_0x4788c4);}})[_0x8677('0x1d')](function(_0x277edc){if(_0x277edc){return _0x277edc?{'count':_0xcf127b,'rows':_0x277edc}:null;}})['then'](respondWithResult(_0x4eca10,null))[_0x8677('0x3c')](handleError(_0x4eca10,null));};exports['addTeams']=function(_0x4e0a99,_0x5533b1,_0xfb8a3d){var _0x46f802=[];var _0x557f95;return db[_0x8677('0x53')][_0x8677('0x3a')]({'where':{'id':_0x4e0a99['body'][_0x8677('0x54')]},'attributes':['id'],'include':[{'model':db[_0x8677('0x55')],'as':_0x8677('0x56'),'attributes':['id'],'raw':!![]}]})[_0x8677('0x1d')](function(_0x474996){if(_0x474996){for(var _0x59ae88=0x0;_0x59ae88<_0x474996['length'];_0x59ae88+=0x1){for(var _0x5ed0fa=0x0;_0x5ed0fa<_0x474996[_0x59ae88][_0x8677('0x56')][_0x8677('0x2b')];_0x5ed0fa+=0x1){_0x46f802=_[_0x8677('0x57')](_0x46f802,[_0x474996[_0x59ae88]['Agents'][_0x5ed0fa]['id']]);}}return _0x46f802;}})['then'](function(_0x59e3c1){if(_0x59e3c1){return db[_0x8677('0x22')][_0x8677('0x3f')]({'where':{'id':_0x4e0a99[_0x8677('0x3e')]['id']}});}})['then'](function(_0x206976){if(_0x206976){_0x557f95=_0x206976;return _0x557f95[_0x8677('0x58')](_0x46f802,{'penalty':_0x4e0a99[_0x8677('0x44')][_0x8677('0x59')]});}})[_0x8677('0x1d')](function(_0x35866a){if(_0x35866a){return _0x557f95[_0x8677('0x5a')](_0x4e0a99[_0x8677('0x44')][_0x8677('0x54')]);}})[_0x8677('0x1d')](handleEntityNotFound(_0x5533b1,null))[_0x8677('0x1d')](respondWithStatusCode(_0x5533b1,null))[_0x8677('0x3c')](handleError(_0x5533b1,null));};exports[_0x8677('0x5b')]=function(_0x4d9b03,_0x55e4b3,_0x244473){var _0x2d96df=[];var _0x4c380c;return db[_0x8677('0x53')][_0x8677('0x3a')]({'where':{'id':_0x4d9b03[_0x8677('0x25')][_0x8677('0x54')]},'attributes':['id'],'include':[{'model':db[_0x8677('0x55')],'as':_0x8677('0x56'),'attributes':['id'],'raw':!![]}]})['then'](function(_0x39791a){if(_0x39791a){for(var _0x30095a=0x0;_0x30095a<_0x39791a[_0x8677('0x2b')];_0x30095a+=0x1){for(var _0xbd9401=0x0;_0xbd9401<_0x39791a[_0x30095a][_0x8677('0x56')][_0x8677('0x2b')];_0xbd9401+=0x1){_0x2d96df=_[_0x8677('0x57')](_0x2d96df,[_0x39791a[_0x30095a][_0x8677('0x56')][_0xbd9401]['id']]);}}return _0x2d96df;}})[_0x8677('0x1d')](function(_0xe32756){if(_0xe32756){return db['VoiceQueue'][_0x8677('0x3f')]({'where':{'id':_0x4d9b03['params']['id']}});}})['then'](function(_0x2114d6){if(_0x2114d6){_0x4c380c=_0x2114d6;return _0x4c380c[_0x8677('0x5c')](_0x2d96df);}})[_0x8677('0x1d')](function(_0x314b17){if(_0x4c380c){return _0x4c380c[_0x8677('0x5b')](_0x4d9b03[_0x8677('0x25')][_0x8677('0x54')]);}})[_0x8677('0x1d')](handleEntityNotFound(_0x55e4b3,null))[_0x8677('0x1d')](respondWithStatusCode(_0x55e4b3,null))[_0x8677('0x3c')](handleError(_0x55e4b3,null));};exports['addAgents']=function(_0x91a760,_0x371137,_0x2c0d1e){var _0x31a327,_0x3df110;return db[_0x8677('0x22')][_0x8677('0x3f')]({'where':{'id':_0x91a760['params']['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x371137,null))[_0x8677('0x1d')](function(_0x55a05b){if(_0x55a05b){_0x3df110=_0x55a05b;return _0x55a05b[_0x8677('0x58')](_0x91a760['body'][_0x8677('0x54')],_[_0x8677('0x43')](_0x91a760['body'],['ids','id'])||{})[_0x8677('0x5d')](function(_0x38e2d2){for(var _0x2501e5=0x0;_0x2501e5<_0x91a760['body'][_0x8677('0x54')][_0x8677('0x2b')];_0x2501e5+=0x1){socket[_0x8677('0x5e')]('userVoiceQueue:save',{'UserId':_0x91a760['body'][_0x8677('0x54')][_0x2501e5],'VoiceQueueId':_0x91a760[_0x8677('0x3e')]['id']});}return _0x38e2d2;});}})[_0x8677('0x1d')](function(_0x59efa5){_0x31a327=_0x59efa5||[];if(_0x3df110){return db[_0x8677('0x55')][_0x8677('0x3a')]({'where':{'id':_0x91a760['body'][_0x8677('0x54')]},'attributes':['id',_0x8677('0x1f'),_0x8677('0x5f'),_0x8677('0x60')],'raw':!![]});}})[_0x8677('0x1d')](function(_0x2ef0aa){if(_0x2ef0aa&&_0x2ef0aa[_0x8677('0x2b')]){var _0x362b59=[];for(var _0x25e468=0x0;_0x25e468<_0x2ef0aa[_0x8677('0x2b')];_0x25e468++){_0x362b59[_0x8677('0x61')](db[_0x8677('0x62')][_0x8677('0x63')]({'membername':_0x2ef0aa[_0x25e468][_0x8677('0x1f')],'UserId':_0x2ef0aa[_0x25e468]['id'],'queue_name':_0x3df110[_0x8677('0x1f')],'VoiceQueueId':_0x3df110['id'],'interface':util[_0x8677('0x64')](_0x8677('0x65'),_0x8677('0x66'),_0x2ef0aa[_0x25e468][_0x8677('0x1f')]),'paused':_0x2ef0aa[_0x25e468][_0x8677('0x60')]||![],'penalty':_0x91a760[_0x8677('0x44')][_0x8677('0x59')]||0x0}));}return BPromise[_0x8677('0x67')](_0x362b59);}})[_0x8677('0x1d')](function(_0x189247){return _0x31a327;})[_0x8677('0x1d')](respondWithResult(_0x371137,null))[_0x8677('0x3c')](handleError(_0x371137,null));};exports['removeAgents']=function(_0x467a32,_0x2cf5d2,_0x236885){var _0x431cf4;return db['VoiceQueue']['find']({'where':{'id':_0x467a32[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x2cf5d2,null))[_0x8677('0x1d')](function(_0x39335b){if(_0x39335b){return _0x39335b['removeAgents'](_0x467a32['query'][_0x8677('0x54')])[_0x8677('0x1d')](function(_0x186d24){if(_[_0x8677('0x68')](_0x467a32['query']['ids'])){for(var _0x3c4fc2=0x0;_0x3c4fc2<_0x467a32[_0x8677('0x25')][_0x8677('0x54')][_0x8677('0x2b')];_0x3c4fc2+=0x1){socket[_0x8677('0x5e')](_0x8677('0x69'),{'UserId':_0x467a32[_0x8677('0x25')][_0x8677('0x54')][_0x3c4fc2],'VoiceQueueId':_0x467a32['params']['id']});}}else{socket['emit'](_0x8677('0x69'),{'UserId':_0x467a32[_0x8677('0x25')][_0x8677('0x54')],'VoiceQueueId':_0x467a32[_0x8677('0x3e')]['id']});}});}})[_0x8677('0x1d')](function(_0x14db0c){if(_0x467a32['query'][_0x8677('0x6a')]){_0x431cf4=_0x14db0c;return db[_0x8677('0x62')][_0x8677('0x47')]({'where':{'VoiceQueueId':_0x467a32[_0x8677('0x3e')]['id'],'UserId':_0x467a32['query'][_0x8677('0x54')]}})[_0x8677('0x1d')](function(){return _0x431cf4;});}})[_0x8677('0x1d')](respondWithStatusCode(_0x2cf5d2,null))[_0x8677('0x3c')](handleError(_0x2cf5d2,null));};exports[_0x8677('0x6b')]=function(_0x442a2f,_0x1ff399,_0x523525){var _0x39780a={};var _0x4a5d2f={};var _0x328631;var _0x525cfa;return db[_0x8677('0x22')][_0x8677('0x4a')]({'where':{'id':_0x442a2f[_0x8677('0x3e')]['id']}})['then'](handleEntityNotFound(_0x1ff399,null))['then'](function(_0x3b2309){if(_0x3b2309){_0x328631=_0x3b2309;_0x4a5d2f[_0x8677('0x23')]=_[_0x8677('0x24')](db[_0x8677('0x55')]['rawAttributes']);_0x4a5d2f['query']=_[_0x8677('0x24')](_0x442a2f[_0x8677('0x25')]);_0x4a5d2f[_0x8677('0x31')]=_[_0x8677('0x28')](_0x4a5d2f[_0x8677('0x23')],_0x4a5d2f[_0x8677('0x25')]);_0x39780a[_0x8677('0x2a')]=_[_0x8677('0x28')](_0x4a5d2f[_0x8677('0x23')],qs[_0x8677('0x29')](_0x442a2f[_0x8677('0x25')]['fields']));_0x39780a['attributes']=_0x39780a[_0x8677('0x2a')][_0x8677('0x2b')]?_0x39780a[_0x8677('0x2a')]:_0x4a5d2f[_0x8677('0x23')];_0x39780a[_0x8677('0x2e')]=qs[_0x8677('0x2f')](_0x442a2f[_0x8677('0x25')][_0x8677('0x2f')]);_0x39780a[_0x8677('0x30')]=qs[_0x8677('0x31')](_[_0x8677('0x4c')](_0x442a2f['query'],_0x4a5d2f[_0x8677('0x31')]));if(_0x442a2f['query']['filter']){_0x39780a['where']=_[_0x8677('0x34')](_0x39780a[_0x8677('0x30')],{'$or':_[_0x8677('0x36')](_0x39780a[_0x8677('0x2a')],function(_0x40729b){var _0x326cd4={};_0x326cd4[_0x40729b]={'$like':'%'+_0x442a2f[_0x8677('0x25')][_0x8677('0x35')]+'%'};return _0x326cd4;})});}_0x39780a=_[_0x8677('0x34')]({},_0x39780a,_0x442a2f[_0x8677('0x37')]);return _0x328631[_0x8677('0x6b')](_0x39780a);}})[_0x8677('0x1d')](function(_0x12a267){if(_0x12a267){_0x525cfa=_0x12a267[_0x8677('0x2b')];if(!_0x442a2f[_0x8677('0x25')][_0x8677('0x2c')]('nolimit')){_0x39780a[_0x8677('0x17')]=qs['limit'](_0x442a2f[_0x8677('0x25')][_0x8677('0x17')]);_0x39780a[_0x8677('0x16')]=qs['offset'](_0x442a2f[_0x8677('0x25')][_0x8677('0x16')]);}return _0x328631[_0x8677('0x6b')](_0x39780a);}})[_0x8677('0x1d')](function(_0xbc15f0){if(_0xbc15f0){return _0xbc15f0?{'count':_0x525cfa,'rows':_0xbc15f0}:null;}})['then'](respondWithResult(_0x1ff399,null))[_0x8677('0x3c')](handleError(_0x1ff399,null));};exports['getMembers']=function(_0x431a06,_0x90dfb4,_0x38a9b3){var _0x4864e3={};var _0x457b88={};var _0x1bafd0;var _0x3af41e;return db[_0x8677('0x22')][_0x8677('0x4a')]({'where':{'id':_0x431a06[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x90dfb4,null))[_0x8677('0x1d')](function(_0x64c74b){if(_0x64c74b){_0x1bafd0=_0x64c74b;_0x457b88['model']=_['keys'](db[_0x8677('0x62')][_0x8677('0x48')]);_0x457b88[_0x8677('0x25')]=_[_0x8677('0x24')](_0x431a06['query']);_0x457b88[_0x8677('0x31')]=_[_0x8677('0x28')](_0x457b88['model'],_0x457b88[_0x8677('0x25')]);_0x4864e3['attributes']=_[_0x8677('0x28')](_0x457b88[_0x8677('0x23')],qs['fields'](_0x431a06[_0x8677('0x25')][_0x8677('0x29')]));_0x4864e3[_0x8677('0x2a')]=_0x4864e3[_0x8677('0x2a')]['length']?_0x4864e3[_0x8677('0x2a')]:_0x457b88['model'];_0x4864e3['order']=qs[_0x8677('0x2f')](_0x431a06['query'][_0x8677('0x2f')]);_0x4864e3[_0x8677('0x30')]=qs[_0x8677('0x31')](_['pick'](_0x431a06[_0x8677('0x25')],_0x457b88['filters']));if(_0x431a06[_0x8677('0x25')][_0x8677('0x35')]){_0x4864e3[_0x8677('0x30')]=_['merge'](_0x4864e3[_0x8677('0x30')],{'$or':_[_0x8677('0x36')](_0x4864e3['attributes'],function(_0x3bebbe){var _0x56334e={};_0x56334e[_0x3bebbe]={'$like':'%'+_0x431a06[_0x8677('0x25')]['filter']+'%'};return _0x56334e;})});}_0x4864e3=_[_0x8677('0x34')]({},_0x4864e3,_0x431a06['options']);return _0x1bafd0[_0x8677('0x6c')](_0x4864e3);}})[_0x8677('0x1d')](function(_0x4c94a8){if(_0x4c94a8){_0x3af41e=_0x4c94a8[_0x8677('0x2b')];if(!_0x431a06[_0x8677('0x25')][_0x8677('0x2c')](_0x8677('0x2d'))){_0x4864e3[_0x8677('0x17')]=qs[_0x8677('0x17')](_0x431a06[_0x8677('0x25')]['limit']);_0x4864e3[_0x8677('0x16')]=qs['offset'](_0x431a06[_0x8677('0x25')]['offset']);}return _0x1bafd0[_0x8677('0x6c')](_0x4864e3);}})['then'](function(_0x20c79b){return _0x20c79b?{'count':_0x3af41e,'rows':_0x20c79b}:null;})[_0x8677('0x1d')](respondWithResult(_0x90dfb4,null))['catch'](handleError(_0x90dfb4,null));};exports[_0x8677('0x6d')]=function(_0x128e3d,_0x5cf10a,_0x19adbc){var _0x5d64e7={};var _0x35b3ae={};var _0x26cd51;var _0x1decf4;return db[_0x8677('0x22')]['findOne']({'where':{'id':_0x128e3d[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x5cf10a,null))[_0x8677('0x1d')](function(_0x3c90de){if(_0x3c90de){_0x26cd51=_0x3c90de;_0x35b3ae[_0x8677('0x23')]=_[_0x8677('0x24')](db['CmList']['rawAttributes']);_0x35b3ae[_0x8677('0x25')]=_[_0x8677('0x24')](_0x128e3d[_0x8677('0x25')]);_0x35b3ae[_0x8677('0x31')]=_[_0x8677('0x28')](_0x35b3ae[_0x8677('0x23')],_0x35b3ae['query']);_0x5d64e7[_0x8677('0x2a')]=_[_0x8677('0x28')](_0x35b3ae['model'],qs[_0x8677('0x29')](_0x128e3d[_0x8677('0x25')][_0x8677('0x29')]));_0x5d64e7[_0x8677('0x2a')]=_0x5d64e7[_0x8677('0x2a')][_0x8677('0x2b')]?_0x5d64e7[_0x8677('0x2a')]:_0x35b3ae[_0x8677('0x23')];_0x5d64e7[_0x8677('0x2e')]=qs[_0x8677('0x2f')](_0x128e3d[_0x8677('0x25')]['sort']);_0x5d64e7[_0x8677('0x30')]=qs['filters'](_[_0x8677('0x4c')](_0x128e3d[_0x8677('0x25')],_0x35b3ae[_0x8677('0x31')]));if(_0x128e3d[_0x8677('0x25')]['filter']){_0x5d64e7['where']=_[_0x8677('0x34')](_0x5d64e7[_0x8677('0x30')],{'$or':_[_0x8677('0x36')](_0x5d64e7['attributes'],function(_0x2dcbf9){var _0x2b5dd2={};_0x2b5dd2[_0x2dcbf9]={'$like':'%'+_0x128e3d[_0x8677('0x25')][_0x8677('0x35')]+'%'};return _0x2b5dd2;})});}_0x5d64e7=_[_0x8677('0x34')]({},_0x5d64e7,_0x128e3d[_0x8677('0x37')]);return _0x26cd51[_0x8677('0x6d')](_0x5d64e7);}})[_0x8677('0x1d')](function(_0x408ac8){if(_0x408ac8){_0x1decf4=_0x408ac8[_0x8677('0x2b')];if(!_0x128e3d['query'][_0x8677('0x2c')](_0x8677('0x2d'))){_0x5d64e7[_0x8677('0x17')]=qs[_0x8677('0x17')](_0x128e3d[_0x8677('0x25')][_0x8677('0x17')]);_0x5d64e7[_0x8677('0x16')]=qs['offset'](_0x128e3d[_0x8677('0x25')][_0x8677('0x16')]);}return _0x26cd51[_0x8677('0x6d')](_0x5d64e7);}})[_0x8677('0x1d')](function(_0x32a02b){if(_0x32a02b){return _0x32a02b?{'count':_0x1decf4,'rows':_0x32a02b}:null;}})[_0x8677('0x1d')](respondWithResult(_0x5cf10a,null))[_0x8677('0x3c')](handleError(_0x5cf10a,null));};exports[_0x8677('0x6e')]=function(_0x98651e,_0x514fbd,_0x188085){var _0x41030e,_0x16ecd2;return db[_0x8677('0x22')][_0x8677('0x3f')]({'where':{'id':_0x98651e[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x514fbd,null))[_0x8677('0x1d')](function(_0x439486){if(_0x439486){_0x16ecd2=_0x439486;return _0x439486[_0x8677('0x6e')](_0x98651e[_0x8677('0x44')][_0x8677('0x54')],_['omit'](_0x98651e[_0x8677('0x44')],[_0x8677('0x54'),'id'])||{});}return null;})[_0x8677('0x5d')](function(_0x56b613){var _0x29b4b6;_0x41030e=_0x56b613||[];var _0x315da2=[];if(_0x56b613){for(var _0x43c5e9=0x0;_0x43c5e9<_0x56b613['length'];_0x43c5e9+=0x1){var _0xce031e=_0x56b613[_0x43c5e9][_0x8677('0x42')]({'plain':!![]});_0x16ecd2[_0x8677('0x6f')]=_0x98651e[_0x8677('0x44')][_0x8677('0x6f')]?_0x98651e[_0x8677('0x44')][_0x8677('0x6f')]:_0x16ecd2[_0x8677('0x6f')];switch(_0x16ecd2[_0x8677('0x6f')]){case _0x8677('0x70'):_0x29b4b6=squel['insert']()['into'](_0x8677('0x71'))['fromQuery']([_0x8677('0x72'),'scheduledAt','ContactId','ListId','VoiceQueueId',_0x8677('0x45'),'updatedAt'],squel['select']()[_0x8677('0x73')](_0x8677('0x72'),'phone')[_0x8677('0x73')](_0x8677('0x74'),_0x8677('0x75'))[_0x8677('0x73')]('id',_0x8677('0x76'))['field'](_0xce031e[_0x8677('0x77')][_0x8677('0x78')](),'ListId')[_0x8677('0x73')](_0x98651e[_0x8677('0x3e')]['id'][_0x8677('0x78')](),_0x8677('0x4d'))['field']('NOW()',_0x8677('0x45'))[_0x8677('0x73')](_0x8677('0x74'),'updatedAt')[_0x8677('0x79')]('cm_contacts')[_0x8677('0x30')]('deletedAt\x20IS\x20NULL')[_0x8677('0x30')](_0x8677('0x7a'),_0xce031e[_0x8677('0x77')][_0x8677('0x78')]())[_0x8677('0x30')](_0x8677('0x7b'))['where'](_0x8677('0x7c'),squel[_0x8677('0x7d')]()['field']('calleridnum')[_0x8677('0x79')](_0x8677('0x7e'))[_0x8677('0x30')]('VoiceQueueId\x20=\x20?',_0x98651e[_0x8677('0x3e')]['id'][_0x8677('0x78')]()))['where'](_0x8677('0x7c'),squel['select']()[_0x8677('0x73')](_0x8677('0x72'))[_0x8677('0x79')](_0x8677('0x71'))['where'](_0x8677('0x7f'),_0x98651e[_0x8677('0x3e')]['id'][_0x8677('0x78')]())))[_0x8677('0x78')]();break;case _0x8677('0x80'):_0x29b4b6=squel['insert']()[_0x8677('0x81')](_0x8677('0x71'))['fromQuery']([_0x8677('0x72'),'scheduledAt',_0x8677('0x76'),_0x8677('0x82'),_0x8677('0x4d'),_0x8677('0x45'),'updatedAt'],squel['select']()[_0x8677('0x73')](_0x8677('0x72'),_0x8677('0x72'))[_0x8677('0x73')](_0x8677('0x74'),_0x8677('0x75'))[_0x8677('0x73')]('id','ContactId')[_0x8677('0x73')](_0xce031e['CmListId'][_0x8677('0x78')](),_0x8677('0x82'))['field'](_0x98651e['params']['id'][_0x8677('0x78')](),'VoiceQueueId')['field']('NOW()','createdAt')[_0x8677('0x73')]('NOW()',_0x8677('0x46'))[_0x8677('0x79')](_0x8677('0x83'))['where'](_0x8677('0x84'))[_0x8677('0x30')](_0x8677('0x7a'),_0xce031e['CmListId'][_0x8677('0x78')]())[_0x8677('0x30')]('phone\x20IS\x20NOT\x20NULL')[_0x8677('0x30')]('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x8677('0x73')](_0x8677('0x72'))[_0x8677('0x79')](_0x8677('0x71'))[_0x8677('0x30')](_0x8677('0x7f'),_0x98651e[_0x8677('0x3e')]['id'][_0x8677('0x78')]())))[_0x8677('0x78')]();break;default:_0x29b4b6=squel[_0x8677('0x85')]()['into'](_0x8677('0x71'))[_0x8677('0x86')]([_0x8677('0x72'),_0x8677('0x75'),_0x8677('0x76'),_0x8677('0x82'),_0x8677('0x4d'),_0x8677('0x45'),_0x8677('0x46')],squel['select']()['field'](_0x8677('0x72'),_0x8677('0x72'))[_0x8677('0x73')](_0x8677('0x74'),'scheduledAt')[_0x8677('0x73')]('id',_0x8677('0x76'))[_0x8677('0x73')](_0xce031e[_0x8677('0x77')][_0x8677('0x78')](),_0x8677('0x82'))['field'](_0x98651e[_0x8677('0x3e')]['id'][_0x8677('0x78')](),_0x8677('0x4d'))[_0x8677('0x73')](_0x8677('0x74'),_0x8677('0x45'))['field'](_0x8677('0x74'),_0x8677('0x46'))[_0x8677('0x79')]('cm_contacts')['where'](_0x8677('0x84'))[_0x8677('0x30')]('ListId\x20=\x20?',_0xce031e[_0x8677('0x77')][_0x8677('0x78')]())[_0x8677('0x30')](_0x8677('0x7b')))[_0x8677('0x78')]();}_0x315da2['push'](db[_0x8677('0x87')][_0x8677('0x25')](_0x29b4b6));}return BPromise[_0x8677('0x67')](_0x315da2);}})[_0x8677('0x1d')](function(){return _0x41030e;})[_0x8677('0x1d')](respondWithResult(_0x514fbd,null))['catch'](handleError(_0x514fbd,null));};exports[_0x8677('0x88')]=function(_0x351a98,_0x279630,_0x5b60b6){var _0x20fd80;return db[_0x8677('0x22')]['find']({'where':{'id':_0x351a98['params']['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x279630,null))[_0x8677('0x1d')](function(_0x4bde75){if(_0x4bde75){return _0x4bde75[_0x8677('0x88')](_0x351a98[_0x8677('0x25')][_0x8677('0x54')]);}})['then'](function(_0x463cb5){if(_0x463cb5){_0x20fd80=_0x463cb5;return db[_0x8677('0x49')][_0x8677('0x47')]({'where':{'ListId':_0x351a98[_0x8677('0x25')][_0x8677('0x54')],'VoiceQueueId':_0x351a98[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](function(){return _0x20fd80;});}})['then'](respondWithStatusCode(_0x279630,null))[_0x8677('0x3c')](handleError(_0x279630,null));};exports[_0x8677('0x89')]=function(_0x217177,_0x2fcba2,_0x5a873d){var _0x3ad253={};var _0x4a4919={};var _0x2f57b8;var _0x1d7895;return db['VoiceQueue'][_0x8677('0x4a')]({'where':{'id':_0x217177[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x2fcba2,null))[_0x8677('0x1d')](function(_0x4e09ed){if(_0x4e09ed){_0x2f57b8=_0x4e09ed;_0x4a4919['model']=_[_0x8677('0x24')](db[_0x8677('0x8a')][_0x8677('0x48')]);_0x4a4919[_0x8677('0x25')]=_[_0x8677('0x24')](_0x217177[_0x8677('0x25')]);_0x4a4919[_0x8677('0x31')]=_['intersection'](_0x4a4919[_0x8677('0x23')],_0x4a4919['query']);_0x3ad253[_0x8677('0x2a')]=_[_0x8677('0x28')](_0x4a4919[_0x8677('0x23')],qs[_0x8677('0x29')](_0x217177[_0x8677('0x25')][_0x8677('0x29')]));_0x3ad253[_0x8677('0x2a')]=_0x3ad253['attributes'][_0x8677('0x2b')]?_0x3ad253[_0x8677('0x2a')]:_0x4a4919[_0x8677('0x23')];_0x3ad253['order']=qs[_0x8677('0x2f')](_0x217177['query'][_0x8677('0x2f')]);_0x3ad253['where']=qs[_0x8677('0x31')](_['pick'](_0x217177[_0x8677('0x25')],_0x4a4919[_0x8677('0x31')]));if(_0x217177[_0x8677('0x25')][_0x8677('0x35')]){_0x3ad253[_0x8677('0x30')]=_[_0x8677('0x34')](_0x3ad253[_0x8677('0x30')],{'$or':_[_0x8677('0x36')](_0x3ad253[_0x8677('0x2a')],function(_0x2db85a){var _0x272632={};_0x272632[_0x2db85a]={'$like':'%'+_0x217177[_0x8677('0x25')][_0x8677('0x35')]+'%'};return _0x272632;})});}_0x3ad253=_[_0x8677('0x34')]({},_0x3ad253,_0x217177[_0x8677('0x37')]);return _0x2f57b8['getBlackLists'](_0x3ad253);}})['then'](function(_0x46d22c){if(_0x46d22c){_0x1d7895=_0x46d22c[_0x8677('0x2b')];if(!_0x217177[_0x8677('0x25')]['hasOwnProperty'](_0x8677('0x2d'))){_0x3ad253[_0x8677('0x17')]=qs[_0x8677('0x17')](_0x217177[_0x8677('0x25')]['limit']);_0x3ad253[_0x8677('0x16')]=qs['offset'](_0x217177[_0x8677('0x25')][_0x8677('0x16')]);}return _0x2f57b8[_0x8677('0x89')](_0x3ad253);}})[_0x8677('0x1d')](function(_0x1ce361){if(_0x1ce361){return _0x1ce361?{'count':_0x1d7895,'rows':_0x1ce361}:null;}})[_0x8677('0x1d')](respondWithResult(_0x2fcba2,null))[_0x8677('0x3c')](handleError(_0x2fcba2,null));};exports[_0x8677('0x8b')]=function(_0x2fca37,_0x15d566,_0x10f0a7){var _0x185e5c,_0x2caa21;return db[_0x8677('0x22')][_0x8677('0x3f')]({'where':{'id':_0x2fca37[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x15d566,null))['then'](function(_0x1e3eb3){if(_0x1e3eb3){_0x2caa21=_0x1e3eb3;return _0x1e3eb3['addBlackLists'](_0x2fca37[_0x8677('0x44')][_0x8677('0x54')],_[_0x8677('0x43')](_0x2fca37[_0x8677('0x44')],[_0x8677('0x54'),'id'])||{});}return null;})[_0x8677('0x5d')](function(_0x4d0f8f){var _0x23dadd;_0x185e5c=_0x4d0f8f||[];var _0x1c1b4e=[];if(_0x4d0f8f){for(var _0x2bffa9=0x0;_0x2bffa9<_0x4d0f8f[_0x8677('0x2b')];_0x2bffa9+=0x1){var _0x38c79d=_0x4d0f8f[_0x2bffa9][_0x8677('0x42')]({'plain':!![]});_0x23dadd=squel['insert']()['into']('cm_hopper_black')[_0x8677('0x86')]([_0x8677('0x72'),'ContactId','ListId',_0x8677('0x4d'),_0x8677('0x45'),_0x8677('0x46')],squel[_0x8677('0x7d')]()[_0x8677('0x73')](_0x8677('0x72'),_0x8677('0x72'))[_0x8677('0x73')]('id','ContactId')['field'](_0x38c79d[_0x8677('0x77')][_0x8677('0x78')](),_0x8677('0x82'))[_0x8677('0x73')](_0x2fca37['params']['id'][_0x8677('0x78')](),_0x8677('0x4d'))[_0x8677('0x73')]('NOW()','createdAt')[_0x8677('0x73')](_0x8677('0x74'),_0x8677('0x46'))[_0x8677('0x79')]('cm_contacts')[_0x8677('0x30')](_0x8677('0x84'))[_0x8677('0x30')](_0x8677('0x7a'),_0x38c79d[_0x8677('0x77')][_0x8677('0x78')]())[_0x8677('0x30')](_0x8677('0x7b')))[_0x8677('0x78')]();_0x1c1b4e['push'](db['sequelize'][_0x8677('0x25')](_0x23dadd));}return BPromise[_0x8677('0x67')](_0x1c1b4e);}})['then'](function(){return _0x185e5c;})[_0x8677('0x1d')](respondWithResult(_0x15d566,null))[_0x8677('0x3c')](handleError(_0x15d566,null));};exports['removeBlackLists']=function(_0x29be2d,_0x5ed5e6,_0x25a491){var _0x1a72bf;return db['VoiceQueue'][_0x8677('0x3f')]({'where':{'id':_0x29be2d[_0x8677('0x3e')]['id']}})[_0x8677('0x1d')](handleEntityNotFound(_0x5ed5e6,null))[_0x8677('0x1d')](function(_0x26eb05){if(_0x26eb05){return _0x26eb05[_0x8677('0x8c')](_0x29be2d[_0x8677('0x25')][_0x8677('0x54')]);}})['then'](function(_0x5bc227){if(_0x5bc227){_0x1a72bf=_0x5bc227;return db[_0x8677('0x51')][_0x8677('0x47')]({'where':{'ListId':_0x29be2d['query']['ids'],'VoiceQueueId':_0x29be2d[_0x8677('0x3e')]['id']}})['then'](function(){return _0x1a72bf;});}})['then'](respondWithStatusCode(_0x5ed5e6,null))[_0x8677('0x3c')](handleError(_0x5ed5e6,null));};
\ No newline at end of file
+var _0xaa23=['getLists','CmList','addLists','dialCheckDuplicateType','always','insert','into','cm_hopper','phone','scheduledAt','ContactId','field','NOW()','CmListId','toString','ListId','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','select','cm_hopper_final','VoiceQueueId\x20=\x20?','onlyIfOpen','from','phone\x20NOT\x20IN\x20(?)','fromQuery','removeLists','getBlackLists','cm_hopper_black','push','sequelize','removeBlackLists','request-promise','moment','bluebird','mustache','util','path','ejs','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','../../components/parsers/qs','../../config/logger','api','../../config/environment','localhost','register','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','then','error','stack','name','index','VoiceQueue','rawAttributes','model','query','dateEnd','dateStart','keys','filters','fields','attributes','hasOwnProperty','nolimit','sort','where','pick','add','day','merge','options','includeAll','rows','catch','show','params','length','find','body','clone','intersection','include','get','omit','updatedAt','createdAt','create','findOne','CmHopper','order','VoiceQueueId','filter','map','findAll','getHopperHistories','CmHopperHistory','getHopperFinals','CmHopperFinal','CmHopperBlack','Team','getTeams','addTeams','ids','User','Agents','union','addAgents','penalty','removeTeams','removeAgents','emit','userVoiceQueue:save','loginInPause','UserVoiceQueueRt','upsert','%s/%s','voicePause','all','userVoiceQueue:remove','destroy','getAgents','getMembers'];(function(_0x469f0c,_0x233e1c){var _0x36a21=function(_0x48110c){while(--_0x48110c){_0x469f0c['push'](_0x469f0c['shift']());}};_0x36a21(++_0x233e1c);}(_0xaa23,0x13b));var _0x3aa2=function(_0x25701b,_0x2a6976){_0x25701b=_0x25701b-0x0;var _0x3a8a2c=_0xaa23[_0x25701b];return _0x3a8a2c;};'use strict';var jsonpatch=require('fast-json-patch');var rp=require(_0x3aa2('0x0'));var moment=require(_0x3aa2('0x1'));var BPromise=require(_0x3aa2('0x2'));var Mustache=require(_0x3aa2('0x3'));var util=require(_0x3aa2('0x4'));var path=require(_0x3aa2('0x5'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x3aa2('0x6'));var fs=require('fs');var _=require(_0x3aa2('0x7'));var squel=require(_0x3aa2('0x8'));var crypto=require(_0x3aa2('0x9'));var jsforce=require(_0x3aa2('0xa'));var deskjs=require(_0x3aa2('0xb'));var toCsv=require(_0x3aa2('0xc'));var querystring=require(_0x3aa2('0xd'));var Papa=require(_0x3aa2('0xe'));var qs=require(_0x3aa2('0xf'));var logger=require(_0x3aa2('0x10'))(_0x3aa2('0x11'));var utils=require('../../config/utils');var config=require(_0x3aa2('0x12'));var db=require('../../mysqldb')['db'];var socket=require('socket.io-emitter')({'host':_0x3aa2('0x13'),'port':0x18eb});require('./voiceQueue.socket')[_0x3aa2('0x14')](socket);function respondWithStatusCode(_0x31a613,_0x3f826a){_0x3f826a=_0x3f826a||0xcc;return function(_0x43affc){if(_0x43affc){return _0x31a613[_0x3aa2('0x15')](_0x3f826a);}return _0x31a613[_0x3aa2('0x16')](_0x3f826a)[_0x3aa2('0x17')]();};}function respondWithResult(_0x595038,_0x306754){_0x306754=_0x306754||0xc8;return function(_0x45f3bb){if(_0x45f3bb){return _0x595038[_0x3aa2('0x16')](_0x306754)[_0x3aa2('0x18')](_0x45f3bb);}};}function respondWithFilteredResult(_0x170485,_0x32f4b5){return function(_0x397776){if(_0x397776){var _0x5d0f9f=_0x397776[_0x3aa2('0x19')],_0x1be8e3=_0x32f4b5[_0x3aa2('0x1a')],_0x5b01c1=_0x32f4b5['offset']+_0x32f4b5[_0x3aa2('0x1b')],_0x383f76;if(_0x5b01c1>=_0x5d0f9f){_0x5b01c1=_0x5d0f9f;_0x383f76=0xc8;}else{_0x383f76=0xce;}_0x170485['status'](_0x383f76);return _0x170485[_0x3aa2('0x1c')](_0x3aa2('0x1d'),_0x1be8e3+'-'+_0x5b01c1+'/'+_0x5d0f9f)[_0x3aa2('0x18')](_0x397776);}return null;};}function patchUpdates(_0x37333a){return function(_0xf9b8d4){try{jsonpatch['apply'](_0xf9b8d4,_0x37333a,!![]);}catch(_0x3831be){return BPromise[_0x3aa2('0x1e')](_0x3831be);}return _0xf9b8d4[_0x3aa2('0x1f')]();};}function saveUpdates(_0x37ed97,_0x2cd8c8){return function(_0x282671){if(_0x282671){return _0x282671[_0x3aa2('0x20')](_0x37ed97)[_0x3aa2('0x21')](function(_0x2e8155){return _0x2e8155;});}return null;};}function removeEntity(_0x368a05,_0x20561d){return function(_0xa8dc8){if(_0xa8dc8){return _0xa8dc8['destroy']()['then'](function(){_0x368a05[_0x3aa2('0x16')](0xcc)[_0x3aa2('0x17')]();});}};}function handleEntityNotFound(_0x50cbe0,_0x89c12a){return function(_0x456e23){if(!_0x456e23){_0x50cbe0['sendStatus'](0x194);}return _0x456e23;};}function handleError(_0x494afd,_0x53f5ae){_0x53f5ae=_0x53f5ae||0x1f4;return function(_0x5874d7){logger[_0x3aa2('0x22')](_0x5874d7[_0x3aa2('0x23')]);if(_0x5874d7[_0x3aa2('0x24')]){delete _0x5874d7[_0x3aa2('0x24')];}_0x494afd[_0x3aa2('0x16')](_0x53f5ae)['send'](_0x5874d7);};}exports[_0x3aa2('0x25')]=function(_0x2ed9f4,_0xeb8f42){var _0x20e078={},_0x4baca2={},_0x404463={'count':0x0,'rows':[]};var _0x307131=db[_0x3aa2('0x26')][_0x3aa2('0x27')];_0x4baca2[_0x3aa2('0x28')]=_['keys'](_0x307131);var _0x158803={'dateStart':_0x2ed9f4[_0x3aa2('0x29')]['dateStart'],'dateEnd':_0x2ed9f4[_0x3aa2('0x29')][_0x3aa2('0x2a')]};delete _0x2ed9f4[_0x3aa2('0x29')][_0x3aa2('0x2b')];delete _0x2ed9f4[_0x3aa2('0x29')][_0x3aa2('0x2a')];_0x4baca2['query']=_[_0x3aa2('0x2c')](_0x2ed9f4[_0x3aa2('0x29')]);_0x4baca2[_0x3aa2('0x2d')]=_['intersection'](_0x4baca2[_0x3aa2('0x28')],_0x4baca2['query']);_0x20e078['attributes']=_['intersection'](_0x4baca2[_0x3aa2('0x28')],qs['fields'](_0x2ed9f4[_0x3aa2('0x29')][_0x3aa2('0x2e')]));_0x20e078[_0x3aa2('0x2f')]=_0x20e078[_0x3aa2('0x2f')]['length']?_0x20e078[_0x3aa2('0x2f')]:_0x4baca2[_0x3aa2('0x28')];if(!_0x2ed9f4[_0x3aa2('0x29')][_0x3aa2('0x30')](_0x3aa2('0x31'))){_0x20e078['limit']=qs[_0x3aa2('0x1b')](_0x2ed9f4[_0x3aa2('0x29')][_0x3aa2('0x1b')]);_0x20e078[_0x3aa2('0x1a')]=qs[_0x3aa2('0x1a')](_0x2ed9f4[_0x3aa2('0x29')][_0x3aa2('0x1a')]);}_0x20e078['order']=qs['sort'](_0x2ed9f4[_0x3aa2('0x29')][_0x3aa2('0x32')]);_0x20e078[_0x3aa2('0x33')]=qs[_0x3aa2('0x2d')](_[_0x3aa2('0x34')](_0x2ed9f4[_0x3aa2('0x29')],_0x4baca2[_0x3aa2('0x2d')]));if(_0x158803['dateStart']){if(_0x158803[_0x3aa2('0x2a')]){_0x158803[_0x3aa2('0x2a')]=moment(_0x158803[_0x3aa2('0x2a')])[_0x3aa2('0x35')](0x1,_0x3aa2('0x36'));}else{_0x158803[_0x3aa2('0x2a')]=moment(_0x158803[_0x3aa2('0x2b')])[_0x3aa2('0x35')](0x1,_0x3aa2('0x36'));}_['merge'](_0x20e078[_0x3aa2('0x33')],{'createdAt':{'$gte':_0x158803[_0x3aa2('0x2b')],'$lte':_0x158803[_0x3aa2('0x2a')]}});}if(_0x2ed9f4[_0x3aa2('0x29')]['filter']){_0x20e078['where']=_['merge'](_0x20e078[_0x3aa2('0x33')],{'$or':_['map'](_0x20e078[_0x3aa2('0x2f')],function(_0xac5d84){var _0x1ca350={};_0x1ca350[_0xac5d84]={'$like':'%'+_0x2ed9f4['query']['filter']+'%'};return _0x1ca350;})});}_0x20e078=_[_0x3aa2('0x37')]({},_0x20e078,_0x2ed9f4[_0x3aa2('0x38')]);var _0x313dd9={'where':_0x20e078['where']};return db['VoiceQueue']['count'](_0x313dd9)['then'](function(_0x81493d){_0x404463[_0x3aa2('0x19')]=_0x81493d;if(_0x2ed9f4['query'][_0x3aa2('0x39')]){_0x20e078['include']=[{'all':!![]}];}return db[_0x3aa2('0x26')]['findAll'](_0x20e078);})[_0x3aa2('0x21')](function(_0x5137ba){_0x404463[_0x3aa2('0x3a')]=_0x5137ba;return _0x404463;})[_0x3aa2('0x21')](respondWithFilteredResult(_0xeb8f42,_0x20e078))[_0x3aa2('0x3b')](handleError(_0xeb8f42,null));};exports[_0x3aa2('0x3c')]=function(_0x3699cb,_0x25c58a){var _0x2188ba={'raw':![],'where':{'id':_0x3699cb[_0x3aa2('0x3d')]['id']}},_0x598cf8={};_0x598cf8[_0x3aa2('0x28')]=_['keys'](db['VoiceQueue'][_0x3aa2('0x27')]);_0x598cf8['query']=_[_0x3aa2('0x2c')](_0x3699cb[_0x3aa2('0x29')]);_0x598cf8['filters']=_['intersection'](_0x598cf8[_0x3aa2('0x28')],_0x598cf8['query']);_0x2188ba[_0x3aa2('0x2f')]=_['intersection'](_0x598cf8[_0x3aa2('0x28')],qs[_0x3aa2('0x2e')](_0x3699cb['query']['fields']));_0x2188ba['attributes']=_0x2188ba['attributes'][_0x3aa2('0x3e')]?_0x2188ba[_0x3aa2('0x2f')]:_0x598cf8['model'];if(_0x3699cb[_0x3aa2('0x29')][_0x3aa2('0x39')]){_0x2188ba['include']=[{'all':!![]}];}_0x2188ba=_[_0x3aa2('0x37')]({},_0x2188ba,_0x3699cb[_0x3aa2('0x38')]);return db['VoiceQueue'][_0x3aa2('0x3f')](_0x2188ba)[_0x3aa2('0x21')](handleEntityNotFound(_0x25c58a,null))['then'](respondWithResult(_0x25c58a,null))[_0x3aa2('0x3b')](handleError(_0x25c58a,null));};exports['create']=function(_0x12a634,_0x5a7bfd){return db['VoiceQueue']['create'](_0x12a634[_0x3aa2('0x40')],{})[_0x3aa2('0x21')](respondWithResult(_0x5a7bfd,0xc9))['catch'](handleError(_0x5a7bfd,null));};exports[_0x3aa2('0x41')]=function(_0x30e103,_0x594039){var _0x52e51b={'raw':![],'where':{'id':_0x30e103[_0x3aa2('0x3d')]['id']}},_0x5ca5a6={};_0x5ca5a6[_0x3aa2('0x28')]=_['keys'](db[_0x3aa2('0x26')]['rawAttributes']);_0x52e51b['attributes']=_[_0x3aa2('0x42')](_0x5ca5a6[_0x3aa2('0x28')],qs[_0x3aa2('0x2e')](_0x30e103[_0x3aa2('0x29')][_0x3aa2('0x2e')]));_0x52e51b['attributes']=_0x52e51b['attributes']['length']?_0x52e51b[_0x3aa2('0x2f')]:_0x5ca5a6['model'];if(_0x30e103[_0x3aa2('0x29')]['includeAll']){_0x52e51b[_0x3aa2('0x43')]=[{'all':!![]}];}_0x52e51b=_[_0x3aa2('0x37')]({},_0x52e51b,_0x30e103['options']);return db['VoiceQueue'][_0x3aa2('0x3f')](_0x52e51b)['then'](handleEntityNotFound(_0x594039,null))[_0x3aa2('0x21')](function(_0x484eb1){if(_0x484eb1){var _0x7a6276=_0x484eb1[_0x3aa2('0x44')]({'plain':!![]});_0x7a6276=qs[_0x3aa2('0x45')](_0x7a6276,['id','createdAt',_0x3aa2('0x46')]);_0x30e103[_0x3aa2('0x40')]=_['omit'](_0x30e103[_0x3aa2('0x40')],['id',_0x3aa2('0x47'),_0x3aa2('0x46')]);return db[_0x3aa2('0x26')][_0x3aa2('0x48')](_['merge'](_0x7a6276,_0x30e103['body']),{'include':_0x30e103[_0x3aa2('0x29')][_0x3aa2('0x39')]?[{'all':!![]}]:undefined});}})[_0x3aa2('0x21')](respondWithResult(_0x594039,0xc9))[_0x3aa2('0x3b')](handleError(_0x594039,null));};exports['update']=function(_0x1217f1,_0x241e6c){if(_0x1217f1['body']['id']){delete _0x1217f1[_0x3aa2('0x40')]['id'];}return db[_0x3aa2('0x26')]['find']({'where':{'id':_0x1217f1[_0x3aa2('0x3d')]['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x241e6c,null))['then'](saveUpdates(_0x1217f1[_0x3aa2('0x40')],null))[_0x3aa2('0x21')](respondWithResult(_0x241e6c,null))[_0x3aa2('0x3b')](handleError(_0x241e6c,null));};exports['destroy']=function(_0x1b1f46,_0xfafcc7){return db[_0x3aa2('0x26')]['find']({'where':{'id':_0x1b1f46[_0x3aa2('0x3d')]['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0xfafcc7,null))['then'](removeEntity(_0xfafcc7,null))[_0x3aa2('0x3b')](handleError(_0xfafcc7,null));};exports['getHoppers']=function(_0x5c54c7,_0x4d4000,_0xa5c411){var _0x1014aa={'raw':![],'where':{}};var _0x5a6a48={};var _0xfad017={'count':0x0,'rows':[]};return db[_0x3aa2('0x26')][_0x3aa2('0x49')]({'where':{'id':_0x5c54c7['params']['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x4d4000,null))[_0x3aa2('0x21')](function(_0x6e4f04){if(_0x6e4f04){_0x5a6a48[_0x3aa2('0x28')]=_[_0x3aa2('0x2c')](db[_0x3aa2('0x4a')][_0x3aa2('0x27')]);_0x5a6a48[_0x3aa2('0x29')]=_[_0x3aa2('0x2c')](_0x5c54c7['query']);_0x5a6a48['filters']=_[_0x3aa2('0x42')](_0x5a6a48[_0x3aa2('0x28')],_0x5a6a48[_0x3aa2('0x29')]);_0x1014aa[_0x3aa2('0x2f')]=_[_0x3aa2('0x42')](_0x5a6a48['model'],qs[_0x3aa2('0x2e')](_0x5c54c7[_0x3aa2('0x29')][_0x3aa2('0x2e')]));_0x1014aa['attributes']=_0x1014aa[_0x3aa2('0x2f')][_0x3aa2('0x3e')]?_0x1014aa[_0x3aa2('0x2f')]:_0x5a6a48[_0x3aa2('0x28')];if(!_0x5c54c7[_0x3aa2('0x29')]['hasOwnProperty']('nolimit')){_0x1014aa['limit']=qs[_0x3aa2('0x1b')](_0x5c54c7[_0x3aa2('0x29')][_0x3aa2('0x1b')]);_0x1014aa[_0x3aa2('0x1a')]=qs[_0x3aa2('0x1a')](_0x5c54c7['query'][_0x3aa2('0x1a')]);}_0x1014aa[_0x3aa2('0x4b')]=qs[_0x3aa2('0x32')](_0x5c54c7[_0x3aa2('0x29')][_0x3aa2('0x32')]);_0x1014aa[_0x3aa2('0x33')]=qs[_0x3aa2('0x2d')](_[_0x3aa2('0x34')](_0x5c54c7['query'],_0x5a6a48[_0x3aa2('0x2d')]));_0x1014aa[_0x3aa2('0x33')][_0x3aa2('0x4c')]=_0x6e4f04['id'];if(_0x5c54c7[_0x3aa2('0x29')][_0x3aa2('0x4d')]){_0x1014aa['where']=_[_0x3aa2('0x37')](_0x1014aa[_0x3aa2('0x33')],{'$or':_[_0x3aa2('0x4e')](_0x1014aa[_0x3aa2('0x2f')],function(_0x145d1a){var _0x5f8673={};_0x5f8673[_0x145d1a]={'$like':'%'+_0x5c54c7[_0x3aa2('0x29')][_0x3aa2('0x4d')]+'%'};return _0x5f8673;})});}_0x1014aa=_[_0x3aa2('0x37')]({},_0x1014aa,_0x5c54c7[_0x3aa2('0x38')]);return db[_0x3aa2('0x4a')][_0x3aa2('0x19')]({'where':_0x1014aa[_0x3aa2('0x33')]})[_0x3aa2('0x21')](function(_0x3f0bc2){_0xfad017[_0x3aa2('0x19')]=_0x3f0bc2;if(_0x5c54c7[_0x3aa2('0x29')][_0x3aa2('0x39')]){_0x1014aa[_0x3aa2('0x43')]=[{'all':!![]}];}return db['CmHopper'][_0x3aa2('0x4f')](_0x1014aa);})[_0x3aa2('0x21')](function(_0x1516fd){_0xfad017['rows']=_0x1516fd;return _0xfad017;});}})[_0x3aa2('0x21')](respondWithFilteredResult(_0x4d4000,_0x1014aa))[_0x3aa2('0x3b')](handleError(_0x4d4000,null));};exports[_0x3aa2('0x50')]=function(_0x1d5a85,_0x3b86be,_0x535441){var _0x5daaa6={'raw':!![],'where':{}};var _0x3cc842={};var _0x540207={'count':0x0,'rows':[]};return db[_0x3aa2('0x26')][_0x3aa2('0x49')]({'where':{'id':_0x1d5a85['params']['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x3b86be,null))[_0x3aa2('0x21')](function(_0x498215){if(_0x498215){_0x3cc842['model']=_[_0x3aa2('0x2c')](db[_0x3aa2('0x51')][_0x3aa2('0x27')]);_0x3cc842['query']=_[_0x3aa2('0x2c')](_0x1d5a85[_0x3aa2('0x29')]);_0x3cc842[_0x3aa2('0x2d')]=_[_0x3aa2('0x42')](_0x3cc842[_0x3aa2('0x28')],_0x3cc842[_0x3aa2('0x29')]);_0x5daaa6[_0x3aa2('0x2f')]=_['intersection'](_0x3cc842[_0x3aa2('0x28')],qs[_0x3aa2('0x2e')](_0x1d5a85['query'][_0x3aa2('0x2e')]));_0x5daaa6[_0x3aa2('0x2f')]=_0x5daaa6['attributes'][_0x3aa2('0x3e')]?_0x5daaa6['attributes']:_0x3cc842[_0x3aa2('0x28')];if(!_0x1d5a85[_0x3aa2('0x29')][_0x3aa2('0x30')](_0x3aa2('0x31'))){_0x5daaa6[_0x3aa2('0x1b')]=qs[_0x3aa2('0x1b')](_0x1d5a85[_0x3aa2('0x29')][_0x3aa2('0x1b')]);_0x5daaa6[_0x3aa2('0x1a')]=qs['offset'](_0x1d5a85['query'][_0x3aa2('0x1a')]);}_0x5daaa6[_0x3aa2('0x4b')]=qs['sort'](_0x1d5a85[_0x3aa2('0x29')][_0x3aa2('0x32')]);_0x5daaa6[_0x3aa2('0x33')]=qs[_0x3aa2('0x2d')](_['pick'](_0x1d5a85['query'],_0x3cc842[_0x3aa2('0x2d')]));_0x5daaa6[_0x3aa2('0x33')][_0x3aa2('0x4c')]=_0x498215['id'];if(_0x1d5a85[_0x3aa2('0x29')][_0x3aa2('0x4d')]){_0x5daaa6[_0x3aa2('0x33')]=_['merge'](_0x5daaa6[_0x3aa2('0x33')],{'$or':_[_0x3aa2('0x4e')](_0x5daaa6[_0x3aa2('0x2f')],function(_0x20ba08){var _0x2b11f1={};_0x2b11f1[_0x20ba08]={'$like':'%'+_0x1d5a85[_0x3aa2('0x29')][_0x3aa2('0x4d')]+'%'};return _0x2b11f1;})});}_0x5daaa6=_[_0x3aa2('0x37')]({},_0x5daaa6,_0x1d5a85['options']);return db['CmHopperHistory']['count']({'where':_0x5daaa6[_0x3aa2('0x33')]})[_0x3aa2('0x21')](function(_0x5929e5){_0x540207[_0x3aa2('0x19')]=_0x5929e5;if(_0x1d5a85[_0x3aa2('0x29')]['includeAll']){_0x5daaa6[_0x3aa2('0x43')]=[{'all':!![]}];}return db['CmHopperHistory']['findAll'](_0x5daaa6);})[_0x3aa2('0x21')](function(_0x337b37){_0x540207[_0x3aa2('0x3a')]=_0x337b37;return _0x540207;});}})[_0x3aa2('0x21')](respondWithFilteredResult(_0x3b86be,_0x5daaa6))[_0x3aa2('0x3b')](handleError(_0x3b86be,null));};exports[_0x3aa2('0x52')]=function(_0x2d9a09,_0x1ea078,_0x37e7ff){var _0x36854b={'raw':!![],'where':{}};var _0x3a1651={};var _0xb897fc={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x3aa2('0x49')]({'where':{'id':_0x2d9a09[_0x3aa2('0x3d')]['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x1ea078,null))[_0x3aa2('0x21')](function(_0xacbffb){if(_0xacbffb){_0x3a1651[_0x3aa2('0x28')]=_['keys'](db[_0x3aa2('0x53')][_0x3aa2('0x27')]);_0x3a1651[_0x3aa2('0x29')]=_[_0x3aa2('0x2c')](_0x2d9a09[_0x3aa2('0x29')]);_0x3a1651['filters']=_[_0x3aa2('0x42')](_0x3a1651[_0x3aa2('0x28')],_0x3a1651['query']);_0x36854b[_0x3aa2('0x2f')]=_['intersection'](_0x3a1651[_0x3aa2('0x28')],qs[_0x3aa2('0x2e')](_0x2d9a09[_0x3aa2('0x29')][_0x3aa2('0x2e')]));_0x36854b[_0x3aa2('0x2f')]=_0x36854b[_0x3aa2('0x2f')]['length']?_0x36854b['attributes']:_0x3a1651['model'];if(!_0x2d9a09['query'][_0x3aa2('0x30')]('nolimit')){_0x36854b['limit']=qs[_0x3aa2('0x1b')](_0x2d9a09[_0x3aa2('0x29')]['limit']);_0x36854b[_0x3aa2('0x1a')]=qs[_0x3aa2('0x1a')](_0x2d9a09[_0x3aa2('0x29')]['offset']);}_0x36854b[_0x3aa2('0x4b')]=qs[_0x3aa2('0x32')](_0x2d9a09[_0x3aa2('0x29')][_0x3aa2('0x32')]);_0x36854b[_0x3aa2('0x33')]=qs[_0x3aa2('0x2d')](_[_0x3aa2('0x34')](_0x2d9a09['query'],_0x3a1651[_0x3aa2('0x2d')]));_0x36854b['where'][_0x3aa2('0x4c')]=_0xacbffb['id'];if(_0x2d9a09['query'][_0x3aa2('0x4d')]){_0x36854b[_0x3aa2('0x33')]=_[_0x3aa2('0x37')](_0x36854b[_0x3aa2('0x33')],{'$or':_[_0x3aa2('0x4e')](_0x36854b[_0x3aa2('0x2f')],function(_0x49a289){var _0x43aa96={};_0x43aa96[_0x49a289]={'$like':'%'+_0x2d9a09[_0x3aa2('0x29')][_0x3aa2('0x4d')]+'%'};return _0x43aa96;})});}_0x36854b=_[_0x3aa2('0x37')]({},_0x36854b,_0x2d9a09[_0x3aa2('0x38')]);return db[_0x3aa2('0x53')][_0x3aa2('0x19')]({'where':_0x36854b[_0x3aa2('0x33')]})['then'](function(_0x4f2b44){_0xb897fc[_0x3aa2('0x19')]=_0x4f2b44;if(_0x2d9a09['query']['includeAll']){_0x36854b[_0x3aa2('0x43')]=[{'all':!![]}];}return db[_0x3aa2('0x53')][_0x3aa2('0x4f')](_0x36854b);})['then'](function(_0xed1c8c){_0xb897fc[_0x3aa2('0x3a')]=_0xed1c8c;return _0xb897fc;});}})[_0x3aa2('0x21')](respondWithFilteredResult(_0x1ea078,_0x36854b))['catch'](handleError(_0x1ea078,null));};exports['getHopperBlacks']=function(_0x28223b,_0x15f780,_0x586406){var _0xe19e27={'raw':!![],'where':{}};var _0x440109={};var _0x503324={'count':0x0,'rows':[]};return db[_0x3aa2('0x26')][_0x3aa2('0x49')]({'where':{'id':_0x28223b[_0x3aa2('0x3d')]['id']}})['then'](handleEntityNotFound(_0x15f780,null))[_0x3aa2('0x21')](function(_0x35fc36){if(_0x35fc36){_0x440109[_0x3aa2('0x28')]=_['keys'](db['CmHopperBlack'][_0x3aa2('0x27')]);_0x440109[_0x3aa2('0x29')]=_[_0x3aa2('0x2c')](_0x28223b['query']);_0x440109[_0x3aa2('0x2d')]=_[_0x3aa2('0x42')](_0x440109['model'],_0x440109[_0x3aa2('0x29')]);_0xe19e27[_0x3aa2('0x2f')]=_['intersection'](_0x440109[_0x3aa2('0x28')],qs[_0x3aa2('0x2e')](_0x28223b[_0x3aa2('0x29')]['fields']));_0xe19e27[_0x3aa2('0x2f')]=_0xe19e27[_0x3aa2('0x2f')]['length']?_0xe19e27[_0x3aa2('0x2f')]:_0x440109[_0x3aa2('0x28')];if(!_0x28223b[_0x3aa2('0x29')][_0x3aa2('0x30')](_0x3aa2('0x31'))){_0xe19e27[_0x3aa2('0x1b')]=qs[_0x3aa2('0x1b')](_0x28223b[_0x3aa2('0x29')][_0x3aa2('0x1b')]);_0xe19e27['offset']=qs[_0x3aa2('0x1a')](_0x28223b['query'][_0x3aa2('0x1a')]);}_0xe19e27[_0x3aa2('0x4b')]=qs[_0x3aa2('0x32')](_0x28223b['query'][_0x3aa2('0x32')]);_0xe19e27[_0x3aa2('0x33')]=qs[_0x3aa2('0x2d')](_[_0x3aa2('0x34')](_0x28223b['query'],_0x440109['filters']));_0xe19e27[_0x3aa2('0x33')][_0x3aa2('0x4c')]=_0x35fc36['id'];if(_0x28223b[_0x3aa2('0x29')][_0x3aa2('0x4d')]){_0xe19e27[_0x3aa2('0x33')]=_['merge'](_0xe19e27[_0x3aa2('0x33')],{'$or':_[_0x3aa2('0x4e')](_0xe19e27['attributes'],function(_0x4383d6){var _0xa2bb48={};_0xa2bb48[_0x4383d6]={'$like':'%'+_0x28223b[_0x3aa2('0x29')][_0x3aa2('0x4d')]+'%'};return _0xa2bb48;})});}_0xe19e27=_[_0x3aa2('0x37')]({},_0xe19e27,_0x28223b[_0x3aa2('0x38')]);return db[_0x3aa2('0x54')][_0x3aa2('0x19')]({'where':_0xe19e27[_0x3aa2('0x33')]})[_0x3aa2('0x21')](function(_0x3aba02){_0x503324[_0x3aa2('0x19')]=_0x3aba02;if(_0x28223b['query'][_0x3aa2('0x39')]){_0xe19e27[_0x3aa2('0x43')]=[{'all':!![]}];}return db[_0x3aa2('0x54')][_0x3aa2('0x4f')](_0xe19e27);})[_0x3aa2('0x21')](function(_0xe6b70b){_0x503324['rows']=_0xe6b70b;return _0x503324;});}})[_0x3aa2('0x21')](respondWithFilteredResult(_0x15f780,_0xe19e27))[_0x3aa2('0x3b')](handleError(_0x15f780,null));};exports['getTeams']=function(_0x570aab,_0x3b96d5,_0xda8990){var _0x18b25c={};var _0x9a8e2b={};var _0x297970;var _0x3c0615;return db[_0x3aa2('0x26')][_0x3aa2('0x49')]({'where':{'id':_0x570aab['params']['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x3b96d5,null))['then'](function(_0xc2cb1){if(_0xc2cb1){_0x297970=_0xc2cb1;_0x9a8e2b['model']=_['keys'](db[_0x3aa2('0x55')]['rawAttributes']);_0x9a8e2b[_0x3aa2('0x29')]=_[_0x3aa2('0x2c')](_0x570aab[_0x3aa2('0x29')]);_0x9a8e2b[_0x3aa2('0x2d')]=_['intersection'](_0x9a8e2b[_0x3aa2('0x28')],_0x9a8e2b[_0x3aa2('0x29')]);_0x18b25c[_0x3aa2('0x2f')]=_['intersection'](_0x9a8e2b[_0x3aa2('0x28')],qs['fields'](_0x570aab['query']['fields']));_0x18b25c['attributes']=_0x18b25c[_0x3aa2('0x2f')][_0x3aa2('0x3e')]?_0x18b25c[_0x3aa2('0x2f')]:_0x9a8e2b[_0x3aa2('0x28')];_0x18b25c[_0x3aa2('0x4b')]=qs['sort'](_0x570aab['query'][_0x3aa2('0x32')]);_0x18b25c[_0x3aa2('0x33')]=qs[_0x3aa2('0x2d')](_[_0x3aa2('0x34')](_0x570aab[_0x3aa2('0x29')],_0x9a8e2b['filters']));if(_0x570aab[_0x3aa2('0x29')]['filter']){_0x18b25c[_0x3aa2('0x33')]=_[_0x3aa2('0x37')](_0x18b25c['where'],{'$or':_['map'](_0x18b25c['attributes'],function(_0x36faaa){var _0x179f91={};_0x179f91[_0x36faaa]={'$like':'%'+_0x570aab[_0x3aa2('0x29')][_0x3aa2('0x4d')]+'%'};return _0x179f91;})});}_0x18b25c=_[_0x3aa2('0x37')]({},_0x18b25c,_0x570aab[_0x3aa2('0x38')]);return _0x297970[_0x3aa2('0x56')](_0x18b25c);}})['then'](function(_0x2ef2c5){if(_0x2ef2c5){_0x3c0615=_0x2ef2c5[_0x3aa2('0x3e')];if(!_0x570aab[_0x3aa2('0x29')][_0x3aa2('0x30')](_0x3aa2('0x31'))){_0x18b25c[_0x3aa2('0x1b')]=qs[_0x3aa2('0x1b')](_0x570aab[_0x3aa2('0x29')][_0x3aa2('0x1b')]);_0x18b25c['offset']=qs[_0x3aa2('0x1a')](_0x570aab['query'][_0x3aa2('0x1a')]);}return _0x297970[_0x3aa2('0x56')](_0x18b25c);}})[_0x3aa2('0x21')](function(_0x1462c2){if(_0x1462c2){return _0x1462c2?{'count':_0x3c0615,'rows':_0x1462c2}:null;}})['then'](respondWithResult(_0x3b96d5,null))[_0x3aa2('0x3b')](handleError(_0x3b96d5,null));};exports[_0x3aa2('0x57')]=function(_0x24440b,_0x56d6d3,_0x56e880){var _0x4e8fa4=[];var _0x82a686;return db[_0x3aa2('0x55')][_0x3aa2('0x4f')]({'where':{'id':_0x24440b[_0x3aa2('0x40')][_0x3aa2('0x58')]},'attributes':['id'],'include':[{'model':db[_0x3aa2('0x59')],'as':_0x3aa2('0x5a'),'attributes':['id'],'raw':!![]}]})['then'](function(_0x3713ab){if(_0x3713ab){for(var _0x52066e=0x0;_0x52066e<_0x3713ab['length'];_0x52066e+=0x1){for(var _0x578bd6=0x0;_0x578bd6<_0x3713ab[_0x52066e][_0x3aa2('0x5a')][_0x3aa2('0x3e')];_0x578bd6+=0x1){_0x4e8fa4=_[_0x3aa2('0x5b')](_0x4e8fa4,[_0x3713ab[_0x52066e][_0x3aa2('0x5a')][_0x578bd6]['id']]);}}return _0x4e8fa4;}})[_0x3aa2('0x21')](function(_0x3196d9){if(_0x3196d9){return db[_0x3aa2('0x26')][_0x3aa2('0x3f')]({'where':{'id':_0x24440b[_0x3aa2('0x3d')]['id']}});}})['then'](function(_0x447bca){if(_0x447bca){_0x82a686=_0x447bca;return _0x82a686[_0x3aa2('0x5c')](_0x4e8fa4,{'penalty':_0x24440b['body'][_0x3aa2('0x5d')]});}})[_0x3aa2('0x21')](function(_0x1c6b55){if(_0x1c6b55){return _0x82a686[_0x3aa2('0x57')](_0x24440b[_0x3aa2('0x40')]['ids']);}})[_0x3aa2('0x21')](handleEntityNotFound(_0x56d6d3,null))[_0x3aa2('0x21')](respondWithStatusCode(_0x56d6d3,null))[_0x3aa2('0x3b')](handleError(_0x56d6d3,null));};exports[_0x3aa2('0x5e')]=function(_0x3f3e72,_0x5a4261,_0x4b324f){var _0x2118b0=[];var _0x2ab33f;return db[_0x3aa2('0x55')][_0x3aa2('0x4f')]({'where':{'id':_0x3f3e72['query'][_0x3aa2('0x58')]},'attributes':['id'],'include':[{'model':db[_0x3aa2('0x59')],'as':_0x3aa2('0x5a'),'attributes':['id'],'raw':!![]}]})[_0x3aa2('0x21')](function(_0x318e70){if(_0x318e70){for(var _0x3c2f43=0x0;_0x3c2f43<_0x318e70[_0x3aa2('0x3e')];_0x3c2f43+=0x1){for(var _0x1cd6e8=0x0;_0x1cd6e8<_0x318e70[_0x3c2f43][_0x3aa2('0x5a')][_0x3aa2('0x3e')];_0x1cd6e8+=0x1){_0x2118b0=_[_0x3aa2('0x5b')](_0x2118b0,[_0x318e70[_0x3c2f43][_0x3aa2('0x5a')][_0x1cd6e8]['id']]);}}return _0x2118b0;}})[_0x3aa2('0x21')](function(_0x4f1dd6){if(_0x4f1dd6){return db[_0x3aa2('0x26')][_0x3aa2('0x3f')]({'where':{'id':_0x3f3e72[_0x3aa2('0x3d')]['id']}});}})[_0x3aa2('0x21')](function(_0x583248){if(_0x583248){_0x2ab33f=_0x583248;return _0x2ab33f[_0x3aa2('0x5f')](_0x2118b0);}})[_0x3aa2('0x21')](function(_0x309f4f){if(_0x2ab33f){return _0x2ab33f[_0x3aa2('0x5e')](_0x3f3e72[_0x3aa2('0x29')]['ids']);}})['then'](handleEntityNotFound(_0x5a4261,null))[_0x3aa2('0x21')](respondWithStatusCode(_0x5a4261,null))[_0x3aa2('0x3b')](handleError(_0x5a4261,null));};exports[_0x3aa2('0x5c')]=function(_0xc03605,_0x3536d2,_0x22507f){var _0x55f7c6,_0x1885cd;return db['VoiceQueue'][_0x3aa2('0x3f')]({'where':{'id':_0xc03605[_0x3aa2('0x3d')]['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x3536d2,null))[_0x3aa2('0x21')](function(_0x5639e3){if(_0x5639e3){_0x1885cd=_0x5639e3;return _0x5639e3[_0x3aa2('0x5c')](_0xc03605[_0x3aa2('0x40')][_0x3aa2('0x58')],_[_0x3aa2('0x45')](_0xc03605[_0x3aa2('0x40')],[_0x3aa2('0x58'),'id'])||{})['spread'](function(_0x5ecaaf){for(var _0x22152b=0x0;_0x22152b<_0xc03605['body'][_0x3aa2('0x58')][_0x3aa2('0x3e')];_0x22152b+=0x1){socket[_0x3aa2('0x60')](_0x3aa2('0x61'),{'UserId':_0xc03605[_0x3aa2('0x40')]['ids'][_0x22152b],'VoiceQueueId':_0xc03605[_0x3aa2('0x3d')]['id']});}return _0x5ecaaf;});}})[_0x3aa2('0x21')](function(_0x10e957){_0x55f7c6=_0x10e957||[];if(_0x1885cd){return db[_0x3aa2('0x59')]['findAll']({'where':{'id':_0xc03605[_0x3aa2('0x40')]['ids']},'attributes':['id',_0x3aa2('0x24'),_0x3aa2('0x62'),'voicePause'],'raw':!![]});}})[_0x3aa2('0x21')](function(_0x18e69d){if(_0x18e69d&&_0x18e69d[_0x3aa2('0x3e')]){var _0x2e44f0=[];for(var _0x2e22e8=0x0;_0x2e22e8<_0x18e69d[_0x3aa2('0x3e')];_0x2e22e8++){_0x2e44f0['push'](db[_0x3aa2('0x63')][_0x3aa2('0x64')]({'membername':_0x18e69d[_0x2e22e8][_0x3aa2('0x24')],'UserId':_0x18e69d[_0x2e22e8]['id'],'queue_name':_0x1885cd[_0x3aa2('0x24')],'VoiceQueueId':_0x1885cd['id'],'interface':util['format'](_0x3aa2('0x65'),'SIP',_0x18e69d[_0x2e22e8][_0x3aa2('0x24')]),'paused':_0x18e69d[_0x2e22e8][_0x3aa2('0x66')]||![],'penalty':_0xc03605[_0x3aa2('0x40')]['penalty']||0x0}));}return BPromise[_0x3aa2('0x67')](_0x2e44f0);}})['then'](function(_0x53a0cd){return _0x55f7c6;})['then'](respondWithResult(_0x3536d2,null))[_0x3aa2('0x3b')](handleError(_0x3536d2,null));};exports[_0x3aa2('0x5f')]=function(_0x158420,_0x363c0d,_0x20bf94){var _0x5b6520;return db[_0x3aa2('0x26')]['find']({'where':{'id':_0x158420[_0x3aa2('0x3d')]['id']}})['then'](handleEntityNotFound(_0x363c0d,null))['then'](function(_0x21b46f){if(_0x21b46f){return _0x21b46f['removeAgents'](_0x158420[_0x3aa2('0x29')][_0x3aa2('0x58')])[_0x3aa2('0x21')](function(_0x152d2e){if(_['isArray'](_0x158420['query'][_0x3aa2('0x58')])){for(var _0xb96912=0x0;_0xb96912<_0x158420[_0x3aa2('0x29')][_0x3aa2('0x58')]['length'];_0xb96912+=0x1){socket[_0x3aa2('0x60')](_0x3aa2('0x68'),{'UserId':_0x158420[_0x3aa2('0x29')][_0x3aa2('0x58')][_0xb96912],'VoiceQueueId':_0x158420[_0x3aa2('0x3d')]['id']});}}else{socket[_0x3aa2('0x60')](_0x3aa2('0x68'),{'UserId':_0x158420[_0x3aa2('0x29')][_0x3aa2('0x58')],'VoiceQueueId':_0x158420[_0x3aa2('0x3d')]['id']});}});}})[_0x3aa2('0x21')](function(_0x2de729){if(_0x158420[_0x3aa2('0x29')]['realtime']){_0x5b6520=_0x2de729;return db[_0x3aa2('0x63')][_0x3aa2('0x69')]({'where':{'VoiceQueueId':_0x158420[_0x3aa2('0x3d')]['id'],'UserId':_0x158420[_0x3aa2('0x29')][_0x3aa2('0x58')]}})[_0x3aa2('0x21')](function(){return _0x5b6520;});}})[_0x3aa2('0x21')](respondWithStatusCode(_0x363c0d,null))[_0x3aa2('0x3b')](handleError(_0x363c0d,null));};exports['getAgents']=function(_0x1decab,_0x3667de,_0x205896){var _0x1d45dc={};var _0x5f406d={};var _0x248f3e;var _0x253c10;return db[_0x3aa2('0x26')][_0x3aa2('0x49')]({'where':{'id':_0x1decab[_0x3aa2('0x3d')]['id']}})['then'](handleEntityNotFound(_0x3667de,null))[_0x3aa2('0x21')](function(_0x35a39d){if(_0x35a39d){_0x248f3e=_0x35a39d;_0x5f406d[_0x3aa2('0x28')]=_[_0x3aa2('0x2c')](db[_0x3aa2('0x59')][_0x3aa2('0x27')]);_0x5f406d[_0x3aa2('0x29')]=_[_0x3aa2('0x2c')](_0x1decab['query']);_0x5f406d[_0x3aa2('0x2d')]=_['intersection'](_0x5f406d[_0x3aa2('0x28')],_0x5f406d[_0x3aa2('0x29')]);_0x1d45dc[_0x3aa2('0x2f')]=_['intersection'](_0x5f406d[_0x3aa2('0x28')],qs[_0x3aa2('0x2e')](_0x1decab[_0x3aa2('0x29')]['fields']));_0x1d45dc[_0x3aa2('0x2f')]=_0x1d45dc[_0x3aa2('0x2f')]['length']?_0x1d45dc['attributes']:_0x5f406d['model'];_0x1d45dc[_0x3aa2('0x4b')]=qs[_0x3aa2('0x32')](_0x1decab['query'][_0x3aa2('0x32')]);_0x1d45dc['where']=qs[_0x3aa2('0x2d')](_[_0x3aa2('0x34')](_0x1decab[_0x3aa2('0x29')],_0x5f406d[_0x3aa2('0x2d')]));if(_0x1decab['query'][_0x3aa2('0x4d')]){_0x1d45dc[_0x3aa2('0x33')]=_[_0x3aa2('0x37')](_0x1d45dc[_0x3aa2('0x33')],{'$or':_[_0x3aa2('0x4e')](_0x1d45dc['attributes'],function(_0x2122cc){var _0x1ceeb7={};_0x1ceeb7[_0x2122cc]={'$like':'%'+_0x1decab['query'][_0x3aa2('0x4d')]+'%'};return _0x1ceeb7;})});}_0x1d45dc=_[_0x3aa2('0x37')]({},_0x1d45dc,_0x1decab['options']);return _0x248f3e[_0x3aa2('0x6a')](_0x1d45dc);}})[_0x3aa2('0x21')](function(_0xfc574e){if(_0xfc574e){_0x253c10=_0xfc574e[_0x3aa2('0x3e')];if(!_0x1decab[_0x3aa2('0x29')][_0x3aa2('0x30')](_0x3aa2('0x31'))){_0x1d45dc[_0x3aa2('0x1b')]=qs[_0x3aa2('0x1b')](_0x1decab[_0x3aa2('0x29')]['limit']);_0x1d45dc[_0x3aa2('0x1a')]=qs[_0x3aa2('0x1a')](_0x1decab['query'][_0x3aa2('0x1a')]);}return _0x248f3e[_0x3aa2('0x6a')](_0x1d45dc);}})[_0x3aa2('0x21')](function(_0x5d7643){if(_0x5d7643){return _0x5d7643?{'count':_0x253c10,'rows':_0x5d7643}:null;}})[_0x3aa2('0x21')](respondWithResult(_0x3667de,null))[_0x3aa2('0x3b')](handleError(_0x3667de,null));};exports[_0x3aa2('0x6b')]=function(_0x166a97,_0x5a757a,_0x13eb2c){var _0x4afb74={};var _0x5ceb75={};var _0x290793;var _0x44e8d1;return db[_0x3aa2('0x26')][_0x3aa2('0x49')]({'where':{'id':_0x166a97[_0x3aa2('0x3d')]['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x5a757a,null))[_0x3aa2('0x21')](function(_0x5aad90){if(_0x5aad90){_0x290793=_0x5aad90;_0x5ceb75[_0x3aa2('0x28')]=_[_0x3aa2('0x2c')](db[_0x3aa2('0x63')]['rawAttributes']);_0x5ceb75[_0x3aa2('0x29')]=_[_0x3aa2('0x2c')](_0x166a97[_0x3aa2('0x29')]);_0x5ceb75[_0x3aa2('0x2d')]=_['intersection'](_0x5ceb75[_0x3aa2('0x28')],_0x5ceb75[_0x3aa2('0x29')]);_0x4afb74[_0x3aa2('0x2f')]=_[_0x3aa2('0x42')](_0x5ceb75['model'],qs[_0x3aa2('0x2e')](_0x166a97[_0x3aa2('0x29')][_0x3aa2('0x2e')]));_0x4afb74[_0x3aa2('0x2f')]=_0x4afb74[_0x3aa2('0x2f')][_0x3aa2('0x3e')]?_0x4afb74[_0x3aa2('0x2f')]:_0x5ceb75['model'];_0x4afb74['order']=qs[_0x3aa2('0x32')](_0x166a97[_0x3aa2('0x29')][_0x3aa2('0x32')]);_0x4afb74[_0x3aa2('0x33')]=qs['filters'](_[_0x3aa2('0x34')](_0x166a97[_0x3aa2('0x29')],_0x5ceb75[_0x3aa2('0x2d')]));if(_0x166a97[_0x3aa2('0x29')]['filter']){_0x4afb74[_0x3aa2('0x33')]=_[_0x3aa2('0x37')](_0x4afb74[_0x3aa2('0x33')],{'$or':_[_0x3aa2('0x4e')](_0x4afb74['attributes'],function(_0xf3eaaa){var _0x213689={};_0x213689[_0xf3eaaa]={'$like':'%'+_0x166a97['query'][_0x3aa2('0x4d')]+'%'};return _0x213689;})});}_0x4afb74=_[_0x3aa2('0x37')]({},_0x4afb74,_0x166a97[_0x3aa2('0x38')]);return _0x290793[_0x3aa2('0x6b')](_0x4afb74);}})[_0x3aa2('0x21')](function(_0x570a25){if(_0x570a25){_0x44e8d1=_0x570a25[_0x3aa2('0x3e')];if(!_0x166a97[_0x3aa2('0x29')][_0x3aa2('0x30')]('nolimit')){_0x4afb74[_0x3aa2('0x1b')]=qs[_0x3aa2('0x1b')](_0x166a97[_0x3aa2('0x29')][_0x3aa2('0x1b')]);_0x4afb74['offset']=qs[_0x3aa2('0x1a')](_0x166a97[_0x3aa2('0x29')][_0x3aa2('0x1a')]);}return _0x290793[_0x3aa2('0x6b')](_0x4afb74);}})[_0x3aa2('0x21')](function(_0x3347c6){return _0x3347c6?{'count':_0x44e8d1,'rows':_0x3347c6}:null;})[_0x3aa2('0x21')](respondWithResult(_0x5a757a,null))[_0x3aa2('0x3b')](handleError(_0x5a757a,null));};exports[_0x3aa2('0x6c')]=function(_0x4381bc,_0x13ccc9,_0x110305){var _0x55ccc1={};var _0x39b163={};var _0x40bf38;var _0x100d60;return db[_0x3aa2('0x26')][_0x3aa2('0x49')]({'where':{'id':_0x4381bc['params']['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x13ccc9,null))[_0x3aa2('0x21')](function(_0x3ca7d1){if(_0x3ca7d1){_0x40bf38=_0x3ca7d1;_0x39b163[_0x3aa2('0x28')]=_[_0x3aa2('0x2c')](db[_0x3aa2('0x6d')][_0x3aa2('0x27')]);_0x39b163[_0x3aa2('0x29')]=_[_0x3aa2('0x2c')](_0x4381bc[_0x3aa2('0x29')]);_0x39b163[_0x3aa2('0x2d')]=_['intersection'](_0x39b163[_0x3aa2('0x28')],_0x39b163['query']);_0x55ccc1[_0x3aa2('0x2f')]=_[_0x3aa2('0x42')](_0x39b163[_0x3aa2('0x28')],qs[_0x3aa2('0x2e')](_0x4381bc[_0x3aa2('0x29')]['fields']));_0x55ccc1[_0x3aa2('0x2f')]=_0x55ccc1[_0x3aa2('0x2f')][_0x3aa2('0x3e')]?_0x55ccc1[_0x3aa2('0x2f')]:_0x39b163['model'];_0x55ccc1['order']=qs[_0x3aa2('0x32')](_0x4381bc[_0x3aa2('0x29')][_0x3aa2('0x32')]);_0x55ccc1['where']=qs[_0x3aa2('0x2d')](_[_0x3aa2('0x34')](_0x4381bc['query'],_0x39b163[_0x3aa2('0x2d')]));if(_0x4381bc[_0x3aa2('0x29')]['filter']){_0x55ccc1['where']=_[_0x3aa2('0x37')](_0x55ccc1[_0x3aa2('0x33')],{'$or':_[_0x3aa2('0x4e')](_0x55ccc1[_0x3aa2('0x2f')],function(_0x266787){var _0x69dc49={};_0x69dc49[_0x266787]={'$like':'%'+_0x4381bc['query'][_0x3aa2('0x4d')]+'%'};return _0x69dc49;})});}_0x55ccc1=_[_0x3aa2('0x37')]({},_0x55ccc1,_0x4381bc[_0x3aa2('0x38')]);return _0x40bf38[_0x3aa2('0x6c')](_0x55ccc1);}})[_0x3aa2('0x21')](function(_0x4f4024){if(_0x4f4024){_0x100d60=_0x4f4024[_0x3aa2('0x3e')];if(!_0x4381bc['query']['hasOwnProperty'](_0x3aa2('0x31'))){_0x55ccc1[_0x3aa2('0x1b')]=qs[_0x3aa2('0x1b')](_0x4381bc[_0x3aa2('0x29')][_0x3aa2('0x1b')]);_0x55ccc1['offset']=qs[_0x3aa2('0x1a')](_0x4381bc[_0x3aa2('0x29')]['offset']);}return _0x40bf38['getLists'](_0x55ccc1);}})[_0x3aa2('0x21')](function(_0x3c8799){if(_0x3c8799){return _0x3c8799?{'count':_0x100d60,'rows':_0x3c8799}:null;}})[_0x3aa2('0x21')](respondWithResult(_0x13ccc9,null))[_0x3aa2('0x3b')](handleError(_0x13ccc9,null));};exports[_0x3aa2('0x6e')]=function(_0x2dc8d4,_0x51b52f,_0x14ab5f){var _0x3cce9f,_0x573b14;return db[_0x3aa2('0x26')][_0x3aa2('0x3f')]({'where':{'id':_0x2dc8d4[_0x3aa2('0x3d')]['id']}})['then'](handleEntityNotFound(_0x51b52f,null))[_0x3aa2('0x21')](function(_0x2b59c4){if(_0x2b59c4){_0x573b14=_0x2b59c4;return _0x2b59c4[_0x3aa2('0x6e')](_0x2dc8d4[_0x3aa2('0x40')][_0x3aa2('0x58')],_['omit'](_0x2dc8d4[_0x3aa2('0x40')],[_0x3aa2('0x58'),'id'])||{});}return null;})['spread'](function(_0x552f49){var _0x509448;_0x3cce9f=_0x552f49||[];var _0x3f40e9=[];if(_0x552f49){for(var _0x30dba9=0x0;_0x30dba9<_0x552f49[_0x3aa2('0x3e')];_0x30dba9+=0x1){var _0x3a74b8=_0x552f49[_0x30dba9]['get']({'plain':!![]});_0x573b14[_0x3aa2('0x6f')]=_0x2dc8d4['body'][_0x3aa2('0x6f')]?_0x2dc8d4[_0x3aa2('0x40')][_0x3aa2('0x6f')]:_0x573b14[_0x3aa2('0x6f')];switch(_0x573b14[_0x3aa2('0x6f')]){case _0x3aa2('0x70'):_0x509448=squel[_0x3aa2('0x71')]()[_0x3aa2('0x72')](_0x3aa2('0x73'))['fromQuery']([_0x3aa2('0x74'),_0x3aa2('0x75'),_0x3aa2('0x76'),'ListId',_0x3aa2('0x4c'),_0x3aa2('0x47'),'updatedAt'],squel['select']()[_0x3aa2('0x77')](_0x3aa2('0x74'),_0x3aa2('0x74'))['field'](_0x3aa2('0x78'),_0x3aa2('0x75'))['field']('id','ContactId')['field'](_0x3a74b8[_0x3aa2('0x79')][_0x3aa2('0x7a')](),_0x3aa2('0x7b'))[_0x3aa2('0x77')](_0x2dc8d4[_0x3aa2('0x3d')]['id'][_0x3aa2('0x7a')](),_0x3aa2('0x4c'))[_0x3aa2('0x77')](_0x3aa2('0x78'),'createdAt')[_0x3aa2('0x77')]('NOW()','updatedAt')['from'](_0x3aa2('0x7c'))[_0x3aa2('0x33')](_0x3aa2('0x7d'))[_0x3aa2('0x33')](_0x3aa2('0x7e'),_0x3a74b8[_0x3aa2('0x79')]['toString']())[_0x3aa2('0x33')](_0x3aa2('0x7f'))[_0x3aa2('0x33')]('phone\x20NOT\x20IN\x20(?)',squel[_0x3aa2('0x80')]()[_0x3aa2('0x77')]('calleridnum')['from'](_0x3aa2('0x81'))[_0x3aa2('0x33')](_0x3aa2('0x82'),_0x2dc8d4['params']['id'][_0x3aa2('0x7a')]()))[_0x3aa2('0x33')]('phone\x20NOT\x20IN\x20(?)',squel[_0x3aa2('0x80')]()[_0x3aa2('0x77')](_0x3aa2('0x74'))['from'](_0x3aa2('0x73'))['where'](_0x3aa2('0x82'),_0x2dc8d4['params']['id'][_0x3aa2('0x7a')]())))[_0x3aa2('0x7a')]();break;case _0x3aa2('0x83'):_0x509448=squel[_0x3aa2('0x71')]()[_0x3aa2('0x72')](_0x3aa2('0x73'))['fromQuery']([_0x3aa2('0x74'),_0x3aa2('0x75'),_0x3aa2('0x76'),_0x3aa2('0x7b'),_0x3aa2('0x4c'),'createdAt',_0x3aa2('0x46')],squel[_0x3aa2('0x80')]()[_0x3aa2('0x77')](_0x3aa2('0x74'),_0x3aa2('0x74'))[_0x3aa2('0x77')](_0x3aa2('0x78'),_0x3aa2('0x75'))[_0x3aa2('0x77')]('id',_0x3aa2('0x76'))[_0x3aa2('0x77')](_0x3a74b8[_0x3aa2('0x79')]['toString'](),_0x3aa2('0x7b'))[_0x3aa2('0x77')](_0x2dc8d4[_0x3aa2('0x3d')]['id']['toString'](),_0x3aa2('0x4c'))[_0x3aa2('0x77')](_0x3aa2('0x78'),_0x3aa2('0x47'))['field'](_0x3aa2('0x78'),_0x3aa2('0x46'))[_0x3aa2('0x84')](_0x3aa2('0x7c'))[_0x3aa2('0x33')]('deletedAt\x20IS\x20NULL')[_0x3aa2('0x33')](_0x3aa2('0x7e'),_0x3a74b8[_0x3aa2('0x79')][_0x3aa2('0x7a')]())[_0x3aa2('0x33')](_0x3aa2('0x7f'))[_0x3aa2('0x33')](_0x3aa2('0x85'),squel[_0x3aa2('0x80')]()[_0x3aa2('0x77')](_0x3aa2('0x74'))[_0x3aa2('0x84')](_0x3aa2('0x73'))[_0x3aa2('0x33')](_0x3aa2('0x82'),_0x2dc8d4['params']['id'][_0x3aa2('0x7a')]())))['toString']();break;default:_0x509448=squel['insert']()['into'](_0x3aa2('0x73'))[_0x3aa2('0x86')](['phone',_0x3aa2('0x75'),_0x3aa2('0x76'),_0x3aa2('0x7b'),'VoiceQueueId','createdAt',_0x3aa2('0x46')],squel[_0x3aa2('0x80')]()['field'](_0x3aa2('0x74'),_0x3aa2('0x74'))[_0x3aa2('0x77')](_0x3aa2('0x78'),'scheduledAt')[_0x3aa2('0x77')]('id',_0x3aa2('0x76'))[_0x3aa2('0x77')](_0x3a74b8[_0x3aa2('0x79')][_0x3aa2('0x7a')](),_0x3aa2('0x7b'))[_0x3aa2('0x77')](_0x2dc8d4[_0x3aa2('0x3d')]['id']['toString'](),_0x3aa2('0x4c'))[_0x3aa2('0x77')](_0x3aa2('0x78'),_0x3aa2('0x47'))[_0x3aa2('0x77')](_0x3aa2('0x78'),_0x3aa2('0x46'))[_0x3aa2('0x84')]('cm_contacts')['where'](_0x3aa2('0x7d'))[_0x3aa2('0x33')](_0x3aa2('0x7e'),_0x3a74b8['CmListId'][_0x3aa2('0x7a')]())['where'](_0x3aa2('0x7f')))[_0x3aa2('0x7a')]();}_0x3f40e9['push'](db['sequelize'][_0x3aa2('0x29')](_0x509448));}return BPromise[_0x3aa2('0x67')](_0x3f40e9);}})[_0x3aa2('0x21')](function(){return _0x3cce9f;})['then'](respondWithResult(_0x51b52f,null))['catch'](handleError(_0x51b52f,null));};exports[_0x3aa2('0x87')]=function(_0x96878c,_0x1ac216,_0x1caf5e){var _0x2ce43a;return db[_0x3aa2('0x26')][_0x3aa2('0x3f')]({'where':{'id':_0x96878c['params']['id']}})[_0x3aa2('0x21')](handleEntityNotFound(_0x1ac216,null))[_0x3aa2('0x21')](function(_0x109bd0){if(_0x109bd0){return _0x109bd0[_0x3aa2('0x87')](_0x96878c['query'][_0x3aa2('0x58')]);}})[_0x3aa2('0x21')](function(_0x2fb3e8){if(_0x2fb3e8){_0x2ce43a=_0x2fb3e8;return db[_0x3aa2('0x4a')][_0x3aa2('0x69')]({'where':{'ListId':_0x96878c[_0x3aa2('0x29')]['ids'],'VoiceQueueId':_0x96878c[_0x3aa2('0x3d')]['id']}})['then'](function(){return _0x2ce43a;});}})['then'](respondWithStatusCode(_0x1ac216,null))[_0x3aa2('0x3b')](handleError(_0x1ac216,null));};exports[_0x3aa2('0x88')]=function(_0x3dc30c,_0x462a31,_0x246e79){var _0x1b45ae={};var _0x155a4f={};var _0x2b72fd;var _0x413266;return db[_0x3aa2('0x26')][_0x3aa2('0x49')]({'where':{'id':_0x3dc30c[_0x3aa2('0x3d')]['id']}})['then'](handleEntityNotFound(_0x462a31,null))[_0x3aa2('0x21')](function(_0x2e0f75){if(_0x2e0f75){_0x2b72fd=_0x2e0f75;_0x155a4f[_0x3aa2('0x28')]=_[_0x3aa2('0x2c')](db[_0x3aa2('0x6d')][_0x3aa2('0x27')]);_0x155a4f[_0x3aa2('0x29')]=_[_0x3aa2('0x2c')](_0x3dc30c['query']);_0x155a4f['filters']=_[_0x3aa2('0x42')](_0x155a4f[_0x3aa2('0x28')],_0x155a4f['query']);_0x1b45ae['attributes']=_[_0x3aa2('0x42')](_0x155a4f[_0x3aa2('0x28')],qs[_0x3aa2('0x2e')](_0x3dc30c['query'][_0x3aa2('0x2e')]));_0x1b45ae[_0x3aa2('0x2f')]=_0x1b45ae[_0x3aa2('0x2f')][_0x3aa2('0x3e')]?_0x1b45ae[_0x3aa2('0x2f')]:_0x155a4f['model'];_0x1b45ae['order']=qs['sort'](_0x3dc30c[_0x3aa2('0x29')]['sort']);_0x1b45ae[_0x3aa2('0x33')]=qs[_0x3aa2('0x2d')](_[_0x3aa2('0x34')](_0x3dc30c['query'],_0x155a4f[_0x3aa2('0x2d')]));if(_0x3dc30c[_0x3aa2('0x29')][_0x3aa2('0x4d')]){_0x1b45ae[_0x3aa2('0x33')]=_[_0x3aa2('0x37')](_0x1b45ae[_0x3aa2('0x33')],{'$or':_[_0x3aa2('0x4e')](_0x1b45ae[_0x3aa2('0x2f')],function(_0x1db9a){var _0x4d3dc3={};_0x4d3dc3[_0x1db9a]={'$like':'%'+_0x3dc30c[_0x3aa2('0x29')]['filter']+'%'};return _0x4d3dc3;})});}_0x1b45ae=_[_0x3aa2('0x37')]({},_0x1b45ae,_0x3dc30c[_0x3aa2('0x38')]);return _0x2b72fd[_0x3aa2('0x88')](_0x1b45ae);}})[_0x3aa2('0x21')](function(_0xce90b0){if(_0xce90b0){_0x413266=_0xce90b0[_0x3aa2('0x3e')];if(!_0x3dc30c[_0x3aa2('0x29')][_0x3aa2('0x30')](_0x3aa2('0x31'))){_0x1b45ae[_0x3aa2('0x1b')]=qs[_0x3aa2('0x1b')](_0x3dc30c['query'][_0x3aa2('0x1b')]);_0x1b45ae['offset']=qs[_0x3aa2('0x1a')](_0x3dc30c[_0x3aa2('0x29')][_0x3aa2('0x1a')]);}return _0x2b72fd[_0x3aa2('0x88')](_0x1b45ae);}})[_0x3aa2('0x21')](function(_0x1ce476){if(_0x1ce476){return _0x1ce476?{'count':_0x413266,'rows':_0x1ce476}:null;}})[_0x3aa2('0x21')](respondWithResult(_0x462a31,null))['catch'](handleError(_0x462a31,null));};exports['addBlackLists']=function(_0x4cf9c9,_0x237aa2,_0x93ceff){var _0x1a7c34,_0x53421e;return db[_0x3aa2('0x26')]['find']({'where':{'id':_0x4cf9c9[_0x3aa2('0x3d')]['id']}})['then'](handleEntityNotFound(_0x237aa2,null))[_0x3aa2('0x21')](function(_0x5b1cf4){if(_0x5b1cf4){_0x53421e=_0x5b1cf4;return _0x5b1cf4['addBlackLists'](_0x4cf9c9[_0x3aa2('0x40')][_0x3aa2('0x58')],_[_0x3aa2('0x45')](_0x4cf9c9[_0x3aa2('0x40')],[_0x3aa2('0x58'),'id'])||{});}return null;})['spread'](function(_0x1ec1c7){var _0x2bc1d6;_0x1a7c34=_0x1ec1c7||[];var _0x17e353=[];if(_0x1ec1c7){for(var _0x32047f=0x0;_0x32047f<_0x1ec1c7[_0x3aa2('0x3e')];_0x32047f+=0x1){var _0xb61261=_0x1ec1c7[_0x32047f][_0x3aa2('0x44')]({'plain':!![]});_0x2bc1d6=squel[_0x3aa2('0x71')]()['into'](_0x3aa2('0x89'))[_0x3aa2('0x86')](['phone',_0x3aa2('0x76'),_0x3aa2('0x7b'),_0x3aa2('0x4c'),_0x3aa2('0x47'),_0x3aa2('0x46')],squel[_0x3aa2('0x80')]()[_0x3aa2('0x77')]('phone','phone')[_0x3aa2('0x77')]('id',_0x3aa2('0x76'))['field'](_0xb61261[_0x3aa2('0x79')][_0x3aa2('0x7a')](),_0x3aa2('0x7b'))['field'](_0x4cf9c9[_0x3aa2('0x3d')]['id'][_0x3aa2('0x7a')](),_0x3aa2('0x4c'))[_0x3aa2('0x77')](_0x3aa2('0x78'),_0x3aa2('0x47'))[_0x3aa2('0x77')](_0x3aa2('0x78'),_0x3aa2('0x46'))[_0x3aa2('0x84')]('cm_contacts')[_0x3aa2('0x33')]('deletedAt\x20IS\x20NULL')[_0x3aa2('0x33')](_0x3aa2('0x7e'),_0xb61261[_0x3aa2('0x79')][_0x3aa2('0x7a')]())[_0x3aa2('0x33')](_0x3aa2('0x7f')))[_0x3aa2('0x7a')]();_0x17e353[_0x3aa2('0x8a')](db[_0x3aa2('0x8b')][_0x3aa2('0x29')](_0x2bc1d6));}return BPromise['all'](_0x17e353);}})[_0x3aa2('0x21')](function(){return _0x1a7c34;})['then'](respondWithResult(_0x237aa2,null))[_0x3aa2('0x3b')](handleError(_0x237aa2,null));};exports[_0x3aa2('0x8c')]=function(_0x3ea3aa,_0x3b7483,_0x2d6c39){var _0x122bd5;return db['VoiceQueue'][_0x3aa2('0x3f')]({'where':{'id':_0x3ea3aa[_0x3aa2('0x3d')]['id']}})['then'](handleEntityNotFound(_0x3b7483,null))[_0x3aa2('0x21')](function(_0x50d688){if(_0x50d688){return _0x50d688['removeBlackLists'](_0x3ea3aa[_0x3aa2('0x29')][_0x3aa2('0x58')]);}})[_0x3aa2('0x21')](function(_0x3b457d){if(_0x3b457d){_0x122bd5=_0x3b457d;return db['CmHopperBlack'][_0x3aa2('0x69')]({'where':{'ListId':_0x3ea3aa['query'][_0x3aa2('0x58')],'VoiceQueueId':_0x3ea3aa[_0x3aa2('0x3d')]['id']}})[_0x3aa2('0x21')](function(){return _0x122bd5;});}})[_0x3aa2('0x21')](respondWithStatusCode(_0x3b7483,null))[_0x3aa2('0x3b')](handleError(_0x3b7483,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff