18 var _0x4753=['order','sort','where','merge','options','include','findAll','rows','catch','params','includeAll','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','QueueCampaigns','outbound','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','clone','omit','createdAt','updatedAt','body','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','findOne','CmHopper','pick','getHopperHistories','VoiceQueueId','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','Team','getTeams','teams','User','Agents','voicePause','interface','flatMap','penalty','sequelize','transaction','addTeams','each','TeamVoiceQueue','upsert','UserVoiceQueueRt','isNil','format','SIP/%s','forEach','emit','userVoiceQueue:save','removeTeams','ids','select','field','tq.TeamId','from','team_has_voice_queues','join','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','push','QueryTypes','TeamId','includes','all','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','online','isArray','getAgents','getMembers','getLists','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','insert','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','CmListId','toString','cm_contacts','deletedAt\x20IS\x20NULL','phone\x20NOT\x20IN\x20(?)','cm_hopper_final','onlyIfOpen','into','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','COALESCE(phone,\x27\x27)','cm_hopper_additional_phones','CmHopperId','OrderBy','h.id','ci.OrderBy+1','cm_contact_has_items','h.scheduledat=?','ci.ItemClass=?','PHONE','removeLists','getBlackLists','CmList','addBlackLists','NOW()','removeBlackLists','eml-format','rimraf','zip-dir','request-promise','moment','mustache','ejs','fs-extra','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','redis','localhost','socket.io-emitter','./voiceQueue.socket','register','sendStatus','status','json','offset','undefined','limit','count','Content-Range','apply','reject','save','update','then','destroy','get','VoiceQueues','inbound','filter','ignore','map','value','type','find','end','error','stack','name','send','index','VoiceQueue','rawAttributes','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit'];(function(_0x1cbb0f,_0x3c6ae6){var _0x3b8532=function(_0x492b29){while(--_0x492b29){_0x1cbb0f['push'](_0x1cbb0f['shift']());}};_0x3b8532(++_0x3c6ae6);}(_0x4753,0x1f4));var _0x3475=function(_0x3028ab,_0x3d59a6){_0x3028ab=_0x3028ab-0x0;var _0x2a787b=_0x4753[_0x3028ab];return _0x2a787b;};'use strict';var emlformat=require(_0x3475('0x0'));var rimraf=require(_0x3475('0x1'));var zipdir=require(_0x3475('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x3475('0x3'));var moment=require(_0x3475('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x3475('0x5'));var util=require('util');var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x3475('0x6'));var fs=require('fs');var fs_extra=require(_0x3475('0x7'));var _=require('lodash');var squel=require(_0x3475('0x8'));var crypto=require(_0x3475('0x9'));var jsforce=require(_0x3475('0xa'));var deskjs=require(_0x3475('0xb'));var toCsv=require(_0x3475('0xc'));var querystring=require(_0x3475('0xd'));var Papa=require(_0x3475('0xe'));var Redis=require(_0x3475('0xf'));var authService=require(_0x3475('0x10'));var qs=require(_0x3475('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x3475('0x12'));var logger=require(_0x3475('0x13'))(_0x3475('0x14'));var utils=require('../../config/utils');var config=require(_0x3475('0x15'));var licenseUtil=require(_0x3475('0x16'));var db=require('../../mysqldb')['db'];config[_0x3475('0x17')]=_['defaults'](config[_0x3475('0x17')],{'host':_0x3475('0x18'),'port':0x18eb});var socket=require(_0x3475('0x19'))(new Redis(config['redis']));require(_0x3475('0x1a'))[_0x3475('0x1b')](socket);function respondWithStatusCode(_0x306cd8,_0x219520){_0x219520=_0x219520||0xcc;return function(_0x4b5bc4){if(_0x4b5bc4){return _0x306cd8[_0x3475('0x1c')](_0x219520);}return _0x306cd8['status'](_0x219520)['end']();};}function respondWithResult(_0x3fd0d2,_0x1dd054){_0x1dd054=_0x1dd054||0xc8;return function(_0x325fe5){if(_0x325fe5){return _0x3fd0d2[_0x3475('0x1d')](_0x1dd054)[_0x3475('0x1e')](_0x325fe5);}};}function respondWithFilteredResult(_0x49ba96,_0x1e1cb0){return function(_0x547009){if(_0x547009){var _0x12a893=typeof _0x1e1cb0[_0x3475('0x1f')]===_0x3475('0x20')&&typeof _0x1e1cb0[_0x3475('0x21')]==='undefined';var _0x3711a1=_0x547009['count'];var _0x3ab7a8=_0x12a893?0x0:_0x1e1cb0[_0x3475('0x1f')];var _0x2e53a9=_0x12a893?_0x547009[_0x3475('0x22')]:_0x1e1cb0['offset']+_0x1e1cb0[_0x3475('0x21')];var _0xdac710;if(_0x2e53a9>=_0x3711a1){_0x2e53a9=_0x3711a1;_0xdac710=0xc8;}else{_0xdac710=0xce;}_0x49ba96[_0x3475('0x1d')](_0xdac710);return _0x49ba96['set'](_0x3475('0x23'),_0x3ab7a8+'-'+_0x2e53a9+'/'+_0x3711a1)[_0x3475('0x1e')](_0x547009);}return null;};}function patchUpdates(_0x438992){return function(_0x38ea14){try{jsonpatch[_0x3475('0x24')](_0x38ea14,_0x438992,!![]);}catch(_0x44b708){return BPromise[_0x3475('0x25')](_0x44b708);}return _0x38ea14[_0x3475('0x26')]();};}function saveUpdates(_0x10746b,_0x3ade34){return function(_0x1d0e95){if(_0x1d0e95){return _0x1d0e95[_0x3475('0x27')](_0x10746b)[_0x3475('0x28')](function(_0x4ff2a1){return _0x4ff2a1;});}return null;};}function removeEntity(_0x4d35f9,_0x52c825){return function(_0x552cc){if(_0x552cc){return _0x552cc[_0x3475('0x29')]()['then'](function(){var _0x1f3481=_0x552cc[_0x3475('0x2a')]({'plain':!![]});var _0x6a0197=[{'name':_0x3475('0x2b'),'value':_0x3475('0x2c'),'ignore':![]},{'name':'QueueCampaigns','value':'outbound','ignore':![]}];var _0x307467=_(_0x6a0197)[_0x3475('0x2d')](_0x3475('0x2e'))[_0x3475('0x2f')](_0x3475('0x30'))[_0x3475('0x30')]();if(_['includes'](_0x307467,_0x1f3481[_0x3475('0x31')])){return;}var _0x1b6ef3=_[_0x3475('0x32')](_0x6a0197,[_0x3475('0x30'),_0x1f3481[_0x3475('0x31')]])['name'];return db['UserProfileResource'][_0x3475('0x29')]({'where':{'type':_0x1b6ef3,'resourceId':_0x1f3481['id']}})[_0x3475('0x28')](function(){return _0x552cc;});})[_0x3475('0x28')](function(){_0x4d35f9['status'](0xcc)[_0x3475('0x33')]();});}};}function handleEntityNotFound(_0x40d37a,_0x2554b5){return function(_0x10ec45){if(!_0x10ec45){_0x40d37a[_0x3475('0x1c')](0x194);}return _0x10ec45;};}function handleError(_0x4362ad,_0xb4cc70){_0xb4cc70=_0xb4cc70||0x1f4;return function(_0x580942){logger[_0x3475('0x34')](_0x580942[_0x3475('0x35')]);if(_0x580942[_0x3475('0x36')]){delete _0x580942[_0x3475('0x36')];}_0x4362ad[_0x3475('0x1d')](_0xb4cc70)[_0x3475('0x37')](_0x580942);};}exports[_0x3475('0x38')]=function(_0x1dfd4c,_0x784ef8){var _0x651d4c={},_0x501775={},_0x49d11d={'count':0x0,'rows':[]};var _0x229124=_[_0x3475('0x2f')](db[_0x3475('0x39')][_0x3475('0x3a')],function(_0x3bc3fd){return{'name':_0x3bc3fd['fieldName'],'type':_0x3bc3fd['type'][_0x3475('0x3b')]};});_0x501775[_0x3475('0x3c')]=_[_0x3475('0x2f')](_0x229124,_0x3475('0x36'));_0x501775['query']=_[_0x3475('0x3d')](_0x1dfd4c[_0x3475('0x3e')]);_0x501775[_0x3475('0x3f')]=_[_0x3475('0x40')](_0x501775[_0x3475('0x3c')],_0x501775[_0x3475('0x3e')]);_0x651d4c[_0x3475('0x41')]=_[_0x3475('0x40')](_0x501775[_0x3475('0x3c')],qs[_0x3475('0x42')](_0x1dfd4c[_0x3475('0x3e')]['fields']));_0x651d4c['attributes']=_0x651d4c[_0x3475('0x41')][_0x3475('0x43')]?_0x651d4c[_0x3475('0x41')]:_0x501775[_0x3475('0x3c')];if(!_0x1dfd4c[_0x3475('0x3e')][_0x3475('0x44')](_0x3475('0x45'))){_0x651d4c[_0x3475('0x21')]=qs['limit'](_0x1dfd4c[_0x3475('0x3e')][_0x3475('0x21')]);_0x651d4c[_0x3475('0x1f')]=qs['offset'](_0x1dfd4c[_0x3475('0x3e')][_0x3475('0x1f')]);}_0x651d4c[_0x3475('0x46')]=qs[_0x3475('0x47')](_0x1dfd4c['query'][_0x3475('0x47')]);_0x651d4c[_0x3475('0x48')]=qs[_0x3475('0x3f')](_['pick'](_0x1dfd4c[_0x3475('0x3e')],_0x501775['filters']),_0x229124);if(_0x1dfd4c[_0x3475('0x3e')][_0x3475('0x2d')]){_0x651d4c[_0x3475('0x48')]=_[_0x3475('0x49')](_0x651d4c[_0x3475('0x48')],{'$or':_['map'](_0x229124,function(_0x264209){if(_0x264209['type']!=='VIRTUAL'){var _0x327288={};_0x327288[_0x264209[_0x3475('0x36')]]={'$like':'%'+_0x1dfd4c['query'][_0x3475('0x2d')]+'%'};return _0x327288;}})});}_0x651d4c=_[_0x3475('0x49')]({},_0x651d4c,_0x1dfd4c[_0x3475('0x4a')]);var _0x394d62={'where':_0x651d4c['where']};return db['VoiceQueue'][_0x3475('0x22')](_0x394d62)['then'](function(_0x492218){_0x49d11d['count']=_0x492218;if(_0x1dfd4c[_0x3475('0x3e')]['includeAll']){_0x651d4c[_0x3475('0x4b')]=[{'all':!![]}];}return db[_0x3475('0x39')][_0x3475('0x4c')](_0x651d4c);})[_0x3475('0x28')](function(_0x2042da){_0x49d11d[_0x3475('0x4d')]=_0x2042da;return _0x49d11d;})['then'](respondWithFilteredResult(_0x784ef8,_0x651d4c))[_0x3475('0x4e')](handleError(_0x784ef8,null));};exports['show']=function(_0x473747,_0x3793c4){var _0x5c5e3e={'raw':![],'where':{'id':_0x473747[_0x3475('0x4f')]['id']}},_0x34e589={};_0x34e589[_0x3475('0x3c')]=_['keys'](db[_0x3475('0x39')]['rawAttributes']);_0x34e589[_0x3475('0x3e')]=_['keys'](_0x473747['query']);_0x34e589[_0x3475('0x3f')]=_[_0x3475('0x40')](_0x34e589[_0x3475('0x3c')],_0x34e589['query']);_0x5c5e3e['attributes']=_[_0x3475('0x40')](_0x34e589['model'],qs[_0x3475('0x42')](_0x473747[_0x3475('0x3e')][_0x3475('0x42')]));_0x5c5e3e[_0x3475('0x41')]=_0x5c5e3e['attributes'][_0x3475('0x43')]?_0x5c5e3e['attributes']:_0x34e589['model'];if(_0x473747['query'][_0x3475('0x50')]){_0x5c5e3e[_0x3475('0x4b')]=[{'all':!![]}];}_0x5c5e3e=_[_0x3475('0x49')]({},_0x5c5e3e,_0x473747['options']);return db[_0x3475('0x39')][_0x3475('0x32')](_0x5c5e3e)['then'](handleEntityNotFound(_0x3793c4,null))[_0x3475('0x28')](respondWithResult(_0x3793c4,null))[_0x3475('0x4e')](handleError(_0x3793c4,null));};exports[_0x3475('0x51')]=function(_0x37e664,_0x36df85){return db['VoiceQueue'][_0x3475('0x51')](_0x37e664['body'],{})[_0x3475('0x28')](function(_0x1000db){var _0x318b98=_0x37e664[_0x3475('0x52')]['get']({'plain':!![]});if(!_0x318b98)throw new Error(_0x3475('0x53'));if(_0x318b98[_0x3475('0x54')]===_0x3475('0x52')){var _0x22c104=_0x1000db[_0x3475('0x2a')]({'plain':!![]});var _0x33aac5=[{'name':_0x3475('0x2b'),'value':'inbound'},{'name':_0x3475('0x55'),'value':_0x3475('0x56')}];var _0x4a77ac=_[_0x3475('0x32')](_0x33aac5,[_0x3475('0x30'),_0x22c104['type']])[_0x3475('0x36')];return db[_0x3475('0x57')]['find']({'where':{'name':_0x4a77ac,'userProfileId':_0x318b98[_0x3475('0x58')]},'raw':!![]})[_0x3475('0x28')](function(_0x4256f9){if(_0x4256f9&&_0x4256f9[_0x3475('0x59')]===0x0){return db[_0x3475('0x5a')][_0x3475('0x51')]({'name':_0x22c104[_0x3475('0x36')],'resourceId':_0x22c104['id'],'type':_0x4256f9[_0x3475('0x36')],'sectionId':_0x4256f9['id']},{})[_0x3475('0x28')](function(){return _0x1000db;});}else{return _0x1000db;}})[_0x3475('0x4e')](function(_0x4439ad){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4439ad);throw _0x4439ad;});}return _0x1000db;})[_0x3475('0x28')](respondWithResult(_0x36df85,0xc9))[_0x3475('0x4e')](handleError(_0x36df85,null));};exports[_0x3475('0x5b')]=function(_0x59e620,_0x281901){var _0x2671da={'where':{'id':_0x59e620[_0x3475('0x4f')]['id']}},_0x3cd513={};_0x3cd513[_0x3475('0x3c')]=_['keys'](db[_0x3475('0x39')][_0x3475('0x3a')]);_0x2671da[_0x3475('0x41')]=_[_0x3475('0x40')](_0x3cd513[_0x3475('0x3c')],qs[_0x3475('0x42')](_0x59e620[_0x3475('0x3e')][_0x3475('0x42')]));_0x2671da[_0x3475('0x41')]=_0x2671da['attributes'][_0x3475('0x43')]?_0x2671da[_0x3475('0x41')]:_0x3cd513[_0x3475('0x3c')];if(_0x59e620[_0x3475('0x3e')][_0x3475('0x50')]){_0x2671da['include']=[{'all':!![]}];}_0x2671da=_[_0x3475('0x49')]({},_0x2671da,_0x59e620['options']);return db[_0x3475('0x39')][_0x3475('0x32')](_0x2671da)[_0x3475('0x28')](handleEntityNotFound(_0x281901,null))['then'](function(_0x280e27){if(_0x280e27){var _0x3a5a7a=_0x280e27[_0x3475('0x2a')]({'plain':!![]});_0x3a5a7a=qs[_0x3475('0x5c')](_0x3a5a7a,['id',_0x3475('0x5d'),_0x3475('0x5e')]);_0x59e620[_0x3475('0x5f')]=_[_0x3475('0x5c')](_0x59e620['body'],['id','createdAt',_0x3475('0x5e')]);return db[_0x3475('0x39')]['create'](_[_0x3475('0x49')](_0x3a5a7a,_0x59e620['body']),{'include':_0x59e620[_0x3475('0x3e')][_0x3475('0x50')]?[{'all':!![]}]:undefined})['then'](function(_0x5ba83f){var _0x58824d=_0x59e620['user']['get']({'plain':!![]});if(!_0x58824d)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x58824d['role']==='user'){var _0x7f47a8=_0x5ba83f['get']({'plain':!![]});var _0x415d1d=[{'name':_0x3475('0x2b'),'value':_0x3475('0x2c')},{'name':_0x3475('0x55'),'value':'outbound'}];var _0x298a10=_[_0x3475('0x32')](_0x415d1d,['value',_0x7f47a8[_0x3475('0x31')]])['name'];return db[_0x3475('0x57')][_0x3475('0x32')]({'where':{'name':_0x298a10,'userProfileId':_0x58824d[_0x3475('0x58')]},'raw':!![]})['then'](function(_0x2773e6){if(_0x2773e6&&_0x2773e6[_0x3475('0x59')]===0x0){return db[_0x3475('0x5a')]['create']({'name':_0x7f47a8[_0x3475('0x36')],'resourceId':_0x7f47a8['id'],'type':_0x2773e6['name'],'sectionId':_0x2773e6['id']},{})[_0x3475('0x28')](function(){return _0x5ba83f;});}else{return _0x5ba83f;}})['catch'](function(_0xdb9407){logger[_0x3475('0x34')](_0x3475('0x60'),_0xdb9407);throw _0xdb9407;});}return _0x5ba83f;});}})[_0x3475('0x28')](respondWithResult(_0x281901,0xc9))[_0x3475('0x4e')](handleError(_0x281901,null));};exports['update']=function(_0x30df25,_0xd228c3){if(_0x30df25[_0x3475('0x5f')]['id']){delete _0x30df25[_0x3475('0x5f')]['id'];}return db['VoiceQueue'][_0x3475('0x32')]({'where':{'id':_0x30df25[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0xd228c3,null))[_0x3475('0x28')](saveUpdates(_0x30df25[_0x3475('0x5f')],null))['then'](respondWithResult(_0xd228c3,null))[_0x3475('0x4e')](handleError(_0xd228c3,null));};exports['destroy']=function(_0x2e78b8,_0x55a3ff){return db['VoiceQueue'][_0x3475('0x32')]({'where':{'id':_0x2e78b8[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x55a3ff,null))[_0x3475('0x28')](removeEntity(_0x55a3ff,null))[_0x3475('0x4e')](handleError(_0x55a3ff,null));};exports['getHoppers']=function(_0x4ef66c,_0x14131a,_0xcc0802){var _0x3f22f7={'raw':![],'where':{}};var _0x393be3={};var _0x5860b0={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x3475('0x61')]({'where':{'id':_0x4ef66c[_0x3475('0x4f')]['id']}})['then'](handleEntityNotFound(_0x14131a,null))[_0x3475('0x28')](function(_0x1ed305){if(_0x1ed305){_0x393be3['model']=_['keys'](db[_0x3475('0x62')][_0x3475('0x3a')]);_0x393be3['query']=_['keys'](_0x4ef66c[_0x3475('0x3e')]);_0x393be3['filters']=_[_0x3475('0x40')](_0x393be3[_0x3475('0x3c')],_0x393be3['query']);_0x3f22f7[_0x3475('0x41')]=_[_0x3475('0x40')](_0x393be3[_0x3475('0x3c')],qs[_0x3475('0x42')](_0x4ef66c[_0x3475('0x3e')][_0x3475('0x42')]));_0x3f22f7[_0x3475('0x41')]=_0x3f22f7[_0x3475('0x41')][_0x3475('0x43')]?_0x3f22f7[_0x3475('0x41')]:_0x393be3['model'];if(!_0x4ef66c[_0x3475('0x3e')][_0x3475('0x44')]('nolimit')){_0x3f22f7[_0x3475('0x21')]=qs[_0x3475('0x21')](_0x4ef66c[_0x3475('0x3e')][_0x3475('0x21')]);_0x3f22f7[_0x3475('0x1f')]=qs[_0x3475('0x1f')](_0x4ef66c[_0x3475('0x3e')][_0x3475('0x1f')]);}_0x3f22f7[_0x3475('0x46')]=qs[_0x3475('0x47')](_0x4ef66c[_0x3475('0x3e')][_0x3475('0x47')]);_0x3f22f7[_0x3475('0x48')]=qs['filters'](_[_0x3475('0x63')](_0x4ef66c[_0x3475('0x3e')],_0x393be3[_0x3475('0x3f')]));_0x3f22f7[_0x3475('0x48')]['VoiceQueueId']=_0x1ed305['id'];if(_0x4ef66c['query']['filter']){_0x3f22f7[_0x3475('0x48')]=_[_0x3475('0x49')](_0x3f22f7[_0x3475('0x48')],{'$or':_[_0x3475('0x2f')](_0x3f22f7[_0x3475('0x41')],function(_0x4289c9){var _0x409099={};_0x409099[_0x4289c9]={'$like':'%'+_0x4ef66c[_0x3475('0x3e')][_0x3475('0x2d')]+'%'};return _0x409099;})});}_0x3f22f7=_[_0x3475('0x49')]({},_0x3f22f7,_0x4ef66c[_0x3475('0x4a')]);return db[_0x3475('0x62')][_0x3475('0x22')]({'where':_0x3f22f7[_0x3475('0x48')]})['then'](function(_0x28fa96){_0x5860b0[_0x3475('0x22')]=_0x28fa96;if(_0x4ef66c['query']['includeAll']){_0x3f22f7['include']=[{'all':!![]}];}return db[_0x3475('0x62')]['findAll'](_0x3f22f7);})[_0x3475('0x28')](function(_0x91abf3){_0x5860b0[_0x3475('0x4d')]=_0x91abf3;return _0x5860b0;});}})[_0x3475('0x28')](respondWithFilteredResult(_0x14131a,_0x3f22f7))[_0x3475('0x4e')](handleError(_0x14131a,null));};exports[_0x3475('0x64')]=function(_0x30e30b,_0x25d092,_0x384490){var _0x392da4={'raw':!![],'where':{}};var _0x2d6986={};var _0x5425c9={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x3475('0x61')]({'where':{'id':_0x30e30b[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x25d092,null))[_0x3475('0x28')](function(_0x5efa7e){if(_0x5efa7e){_0x2d6986[_0x3475('0x3c')]=_[_0x3475('0x3d')](db['CmHopperHistory'][_0x3475('0x3a')]);_0x2d6986[_0x3475('0x3e')]=_['keys'](_0x30e30b[_0x3475('0x3e')]);_0x2d6986[_0x3475('0x3f')]=_[_0x3475('0x40')](_0x2d6986[_0x3475('0x3c')],_0x2d6986[_0x3475('0x3e')]);_0x392da4[_0x3475('0x41')]=_[_0x3475('0x40')](_0x2d6986[_0x3475('0x3c')],qs[_0x3475('0x42')](_0x30e30b[_0x3475('0x3e')]['fields']));_0x392da4[_0x3475('0x41')]=_0x392da4[_0x3475('0x41')][_0x3475('0x43')]?_0x392da4['attributes']:_0x2d6986[_0x3475('0x3c')];if(!_0x30e30b[_0x3475('0x3e')][_0x3475('0x44')](_0x3475('0x45'))){_0x392da4[_0x3475('0x21')]=qs[_0x3475('0x21')](_0x30e30b[_0x3475('0x3e')][_0x3475('0x21')]);_0x392da4['offset']=qs[_0x3475('0x1f')](_0x30e30b[_0x3475('0x3e')]['offset']);}_0x392da4['order']=qs[_0x3475('0x47')](_0x30e30b[_0x3475('0x3e')][_0x3475('0x47')]);_0x392da4[_0x3475('0x48')]=qs[_0x3475('0x3f')](_['pick'](_0x30e30b[_0x3475('0x3e')],_0x2d6986[_0x3475('0x3f')]));_0x392da4[_0x3475('0x48')][_0x3475('0x65')]=_0x5efa7e['id'];if(_0x30e30b['query'][_0x3475('0x2d')]){_0x392da4[_0x3475('0x48')]=_[_0x3475('0x49')](_0x392da4[_0x3475('0x48')],{'$or':_[_0x3475('0x2f')](_0x392da4[_0x3475('0x41')],function(_0x193b83){var _0x442db0={};_0x442db0[_0x193b83]={'$like':'%'+_0x30e30b[_0x3475('0x3e')][_0x3475('0x2d')]+'%'};return _0x442db0;})});}_0x392da4=_[_0x3475('0x49')]({},_0x392da4,_0x30e30b[_0x3475('0x4a')]);return db['CmHopperHistory'][_0x3475('0x22')]({'where':_0x392da4[_0x3475('0x48')]})[_0x3475('0x28')](function(_0x2802a0){_0x5425c9[_0x3475('0x22')]=_0x2802a0;if(_0x30e30b[_0x3475('0x3e')][_0x3475('0x50')]){_0x392da4['include']=[{'all':!![]}];}return db[_0x3475('0x66')][_0x3475('0x4c')](_0x392da4);})[_0x3475('0x28')](function(_0x24bf38){_0x5425c9[_0x3475('0x4d')]=_0x24bf38;return _0x5425c9;});}})[_0x3475('0x28')](respondWithFilteredResult(_0x25d092,_0x392da4))[_0x3475('0x4e')](handleError(_0x25d092,null));};exports[_0x3475('0x67')]=function(_0x1d8e82,_0x3ea7af,_0x4dd301){var _0x1abff8={'raw':!![],'where':{}};var _0x2889fa={};var _0x2a381f={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x1d8e82[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x3ea7af,null))['then'](function(_0x2872af){if(_0x2872af){_0x2889fa[_0x3475('0x3c')]=_['keys'](db[_0x3475('0x68')]['rawAttributes']);_0x2889fa['query']=_[_0x3475('0x3d')](_0x1d8e82[_0x3475('0x3e')]);_0x2889fa[_0x3475('0x3f')]=_[_0x3475('0x40')](_0x2889fa['model'],_0x2889fa[_0x3475('0x3e')]);_0x1abff8['attributes']=_[_0x3475('0x40')](_0x2889fa[_0x3475('0x3c')],qs[_0x3475('0x42')](_0x1d8e82['query'][_0x3475('0x42')]));_0x1abff8[_0x3475('0x41')]=_0x1abff8[_0x3475('0x41')][_0x3475('0x43')]?_0x1abff8[_0x3475('0x41')]:_0x2889fa[_0x3475('0x3c')];if(!_0x1d8e82[_0x3475('0x3e')]['hasOwnProperty'](_0x3475('0x45'))){_0x1abff8[_0x3475('0x21')]=qs[_0x3475('0x21')](_0x1d8e82[_0x3475('0x3e')][_0x3475('0x21')]);_0x1abff8[_0x3475('0x1f')]=qs[_0x3475('0x1f')](_0x1d8e82[_0x3475('0x3e')][_0x3475('0x1f')]);}_0x1abff8[_0x3475('0x46')]=qs[_0x3475('0x47')](_0x1d8e82[_0x3475('0x3e')]['sort']);_0x1abff8[_0x3475('0x48')]=qs[_0x3475('0x3f')](_[_0x3475('0x63')](_0x1d8e82['query'],_0x2889fa[_0x3475('0x3f')]));_0x1abff8[_0x3475('0x48')][_0x3475('0x65')]=_0x2872af['id'];if(_0x1d8e82[_0x3475('0x3e')][_0x3475('0x2d')]){_0x1abff8[_0x3475('0x48')]=_[_0x3475('0x49')](_0x1abff8[_0x3475('0x48')],{'$or':_[_0x3475('0x2f')](_0x1abff8[_0x3475('0x41')],function(_0x485aee){var _0x488251={};_0x488251[_0x485aee]={'$like':'%'+_0x1d8e82['query'][_0x3475('0x2d')]+'%'};return _0x488251;})});}_0x1abff8=_[_0x3475('0x49')]({},_0x1abff8,_0x1d8e82[_0x3475('0x4a')]);return db['CmHopperFinal'][_0x3475('0x22')]({'where':_0x1abff8[_0x3475('0x48')]})[_0x3475('0x28')](function(_0xaef48c){_0x2a381f['count']=_0xaef48c;if(_0x1d8e82['query'][_0x3475('0x50')]){_0x1abff8[_0x3475('0x4b')]=[{'all':!![]}];}return db[_0x3475('0x68')]['findAll'](_0x1abff8);})[_0x3475('0x28')](function(_0x5eb24a){_0x2a381f['rows']=_0x5eb24a;return _0x2a381f;});}})[_0x3475('0x28')](respondWithFilteredResult(_0x3ea7af,_0x1abff8))[_0x3475('0x4e')](handleError(_0x3ea7af,null));};exports[_0x3475('0x69')]=function(_0x2a1e4a,_0x5b2150,_0xf364d5){var _0x5b0e19={'raw':!![],'where':{}};var _0x40151c={};var _0x17ad75={'count':0x0,'rows':[]};return db['VoiceQueue'][_0x3475('0x61')]({'where':{'id':_0x2a1e4a[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x5b2150,null))[_0x3475('0x28')](function(_0x5d35d4){if(_0x5d35d4){_0x40151c[_0x3475('0x3c')]=_[_0x3475('0x3d')](db[_0x3475('0x6a')][_0x3475('0x3a')]);_0x40151c['query']=_[_0x3475('0x3d')](_0x2a1e4a[_0x3475('0x3e')]);_0x40151c[_0x3475('0x3f')]=_['intersection'](_0x40151c[_0x3475('0x3c')],_0x40151c['query']);_0x5b0e19[_0x3475('0x41')]=_['intersection'](_0x40151c['model'],qs[_0x3475('0x42')](_0x2a1e4a['query'][_0x3475('0x42')]));_0x5b0e19[_0x3475('0x41')]=_0x5b0e19[_0x3475('0x41')][_0x3475('0x43')]?_0x5b0e19[_0x3475('0x41')]:_0x40151c[_0x3475('0x3c')];if(!_0x2a1e4a[_0x3475('0x3e')]['hasOwnProperty'](_0x3475('0x45'))){_0x5b0e19[_0x3475('0x21')]=qs[_0x3475('0x21')](_0x2a1e4a[_0x3475('0x3e')][_0x3475('0x21')]);_0x5b0e19['offset']=qs['offset'](_0x2a1e4a[_0x3475('0x3e')]['offset']);}_0x5b0e19[_0x3475('0x46')]=qs[_0x3475('0x47')](_0x2a1e4a['query']['sort']);_0x5b0e19['where']=qs[_0x3475('0x3f')](_['pick'](_0x2a1e4a[_0x3475('0x3e')],_0x40151c[_0x3475('0x3f')]));_0x5b0e19[_0x3475('0x48')]['VoiceQueueId']=_0x5d35d4['id'];if(_0x2a1e4a[_0x3475('0x3e')][_0x3475('0x2d')]){_0x5b0e19[_0x3475('0x48')]=_['merge'](_0x5b0e19['where'],{'$or':_[_0x3475('0x2f')](_0x5b0e19[_0x3475('0x41')],function(_0x4eb43d){var _0x49a3a9={};_0x49a3a9[_0x4eb43d]={'$like':'%'+_0x2a1e4a['query'][_0x3475('0x2d')]+'%'};return _0x49a3a9;})});}_0x5b0e19=_[_0x3475('0x49')]({},_0x5b0e19,_0x2a1e4a['options']);return db[_0x3475('0x6a')]['count']({'where':_0x5b0e19['where']})['then'](function(_0x71563d){_0x17ad75['count']=_0x71563d;if(_0x2a1e4a[_0x3475('0x3e')][_0x3475('0x50')]){_0x5b0e19['include']=[{'all':!![]}];}return db['CmHopperBlack'][_0x3475('0x4c')](_0x5b0e19);})['then'](function(_0x1faf92){_0x17ad75[_0x3475('0x4d')]=_0x1faf92;return _0x17ad75;});}})[_0x3475('0x28')](respondWithFilteredResult(_0x5b2150,_0x5b0e19))[_0x3475('0x4e')](handleError(_0x5b2150,null));};exports['getTeams']=function(_0x1cc1d,_0x411570,_0x30822a){var _0x25970c={};var _0x28148d={};var _0x42f84f;var _0x109cf9;return db[_0x3475('0x39')][_0x3475('0x61')]({'where':{'id':_0x1cc1d[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x411570,null))[_0x3475('0x28')](function(_0x2b13fb){if(_0x2b13fb){_0x42f84f=_0x2b13fb;_0x28148d[_0x3475('0x3c')]=_[_0x3475('0x3d')](db[_0x3475('0x6b')][_0x3475('0x3a')]);_0x28148d[_0x3475('0x3e')]=_[_0x3475('0x3d')](_0x1cc1d[_0x3475('0x3e')]);_0x28148d['filters']=_['intersection'](_0x28148d[_0x3475('0x3c')],_0x28148d['query']);_0x25970c[_0x3475('0x41')]=_[_0x3475('0x40')](_0x28148d[_0x3475('0x3c')],qs[_0x3475('0x42')](_0x1cc1d[_0x3475('0x3e')][_0x3475('0x42')]));_0x25970c[_0x3475('0x41')]=_0x25970c['attributes']['length']?_0x25970c['attributes']:_0x28148d[_0x3475('0x3c')];_0x25970c['order']=qs[_0x3475('0x47')](_0x1cc1d[_0x3475('0x3e')][_0x3475('0x47')]);_0x25970c[_0x3475('0x48')]=qs['filters'](_[_0x3475('0x63')](_0x1cc1d[_0x3475('0x3e')],_0x28148d[_0x3475('0x3f')]));if(_0x1cc1d[_0x3475('0x3e')][_0x3475('0x2d')]){_0x25970c[_0x3475('0x48')]=_['merge'](_0x25970c[_0x3475('0x48')],{'$or':_[_0x3475('0x2f')](_0x25970c[_0x3475('0x41')],function(_0x4306b7){var _0x1df288={};_0x1df288[_0x4306b7]={'$like':'%'+_0x1cc1d['query'][_0x3475('0x2d')]+'%'};return _0x1df288;})});}_0x25970c=_[_0x3475('0x49')]({},_0x25970c,_0x1cc1d[_0x3475('0x4a')]);return _0x42f84f[_0x3475('0x6c')](_0x25970c);}})['then'](function(_0x57d255){if(_0x57d255){_0x109cf9=_0x57d255[_0x3475('0x43')];if(!_0x1cc1d['query'][_0x3475('0x44')]('nolimit')){_0x25970c[_0x3475('0x21')]=qs[_0x3475('0x21')](_0x1cc1d[_0x3475('0x3e')][_0x3475('0x21')]);_0x25970c[_0x3475('0x1f')]=qs['offset'](_0x1cc1d[_0x3475('0x3e')]['offset']);}return _0x42f84f['getTeams'](_0x25970c);}})[_0x3475('0x28')](function(_0x395f92){if(_0x395f92){return _0x395f92?{'count':_0x109cf9,'rows':_0x395f92}:null;}})['then'](respondWithResult(_0x411570,null))[_0x3475('0x4e')](handleError(_0x411570,null));};exports['addTeams']=function(_0x1f100b,_0x1b2415,_0x3f4a53){var _0x1bf064=_0x1f100b['body'][_0x3475('0x6d')];var _0x50f52a=_['map'](_0x1bf064,'id');return db[_0x3475('0x6b')][_0x3475('0x4c')]({'where':{'id':_0x50f52a},'attributes':['id'],'include':[{'model':db[_0x3475('0x6e')],'as':_0x3475('0x6f'),'attributes':['id','name','online',_0x3475('0x70'),_0x3475('0x71')],'raw':!![]}]})[_0x3475('0x28')](function(_0x18efb6){if(_0x18efb6){var _0x61a848=_[_0x3475('0x72')](_0x18efb6,function(_0x3da621){var _0x1b5af1=_0x3da621[_0x3475('0x2a')]({'plain':!![]});_0x1b5af1[_0x3475('0x6f')]['forEach'](function(_0x266f63){_0x266f63[_0x3475('0x73')]=_[_0x3475('0x32')](_0x1bf064,{'id':_0x1b5af1['id']})[_0x3475('0x73')];});return _0x1b5af1['Agents'];});return db[_0x3475('0x39')]['find']({'where':{'id':_0x1f100b['params']['id']}})[_0x3475('0x28')](function(_0x1f9004){return db[_0x3475('0x74')][_0x3475('0x75')](function(_0x355fa3){return _0x1f9004[_0x3475('0x76')](_0x50f52a,{'transaction':_0x355fa3})[_0x3475('0x28')](function(){return BPromise[_0x3475('0x77')](_0x1bf064,function(_0x2596de){return db[_0x3475('0x78')][_0x3475('0x79')]({'TeamId':_0x2596de['id'],'VoiceQueueId':_0x1f100b['params']['id'],'penalty':_0x2596de[_0x3475('0x73')]},{'transaction':_0x355fa3});});})[_0x3475('0x28')](function(){return BPromise[_0x3475('0x77')](_0x61a848,function(_0x109572){return db['UserVoiceQueue']['findOrCreate']({'where':{'UserId':_0x109572['id'],'VoiceQueueId':_0x1f100b[_0x3475('0x4f')]['id']},'defaults':{'penalty':_0x109572[_0x3475('0x73')]},'transaction':_0x355fa3});});})[_0x3475('0x28')](function(){return BPromise['each'](_['filter'](_0x61a848,{'online':!![]}),function(_0x505f5a){return db[_0x3475('0x7a')][_0x3475('0x79')]({'membername':_0x505f5a['name'],'UserId':_0x505f5a['id'],'queue_name':_0x1f9004[_0x3475('0x36')],'VoiceQueueId':_0x1f9004['id'],'interface':_[_0x3475('0x7b')](_0x505f5a['interface'])?util[_0x3475('0x7c')](_0x3475('0x7d'),_0x505f5a[_0x3475('0x36')]):_0x505f5a[_0x3475('0x71')],'paused':_0x505f5a[_0x3475('0x70')]||![],'penalty':_0x505f5a['penalty']},{'transaction':_0x355fa3});});})['then'](function(){_0x61a848[_0x3475('0x7e')](function(_0x5d22d1){socket[_0x3475('0x7f')](_0x3475('0x80'),{'UserId':_0x5d22d1['id'],'VoiceQueueId':_0x1f9004['id']});});});});});}})[_0x3475('0x28')](respondWithStatusCode(_0x1b2415,null))[_0x3475('0x4e')](handleError(_0x1b2415,null));};exports[_0x3475('0x81')]=function(_0x3d84a6,_0x2a40f9,_0x51ce2b){return db[_0x3475('0x6b')][_0x3475('0x4c')]({'where':{'id':_0x3d84a6[_0x3475('0x3e')][_0x3475('0x82')]},'attributes':['id'],'include':[{'model':db[_0x3475('0x6e')],'as':_0x3475('0x6f'),'attributes':['id'],'raw':!![]}]})[_0x3475('0x28')](handleEntityNotFound(_0x2a40f9,null))[_0x3475('0x28')](function(_0x1ab6ee){var _0x475b3d=_[_0x3475('0x2f')](_0x1ab6ee,'id');var _0x35f527=[];var _0x3befac=[];var _0x116dde=squel[_0x3475('0x83')]();_0x116dde[_0x3475('0x84')](_0x3475('0x85'))[_0x3475('0x86')](_0x3475('0x87'),'tq')[_0x3475('0x88')]('user_has_teams','ut','ut.TeamId\x20=\x20tq.TeamId')['where'](_0x3475('0x89'),_0x3d84a6['params']['id']);for(var _0x166df3=0x0;_0x166df3<_0x1ab6ee['length'];_0x166df3+=0x1){let _0x4c61fd=_0x1ab6ee[_0x166df3];for(var _0x533a2d=0x0;_0x533a2d<_0x4c61fd[_0x3475('0x6f')][_0x3475('0x43')];_0x533a2d+=0x1){let _0x3650c6=_0x4c61fd[_0x3475('0x6f')][_0x533a2d];var _0x31bd02=_0x116dde[_0x3475('0x5b')]();_0x31bd02['where'](_0x3475('0x8a'),_0x3650c6['id']);_0x3befac[_0x3475('0x8b')](db['sequelize'][_0x3475('0x3e')](_0x31bd02['toString'](),{'type':db[_0x3475('0x74')][_0x3475('0x8c')]['SELECT']})[_0x3475('0x28')](function(_0x4b5838){if(_0x4b5838['length']===0x1){return _0x3650c6['id'];}else{var _0x28272c=_['every'](_['map'](_0x4b5838,_0x3475('0x8d')),function(_0x5b79b7){return _[_0x3475('0x8e')](_0x475b3d,_0x5b79b7);});if(_0x28272c){return _0x3650c6['id'];}}}));}}return BPromise[_0x3475('0x8f')](_0x3befac)[_0x3475('0x28')](function(_0x1dbbe9){_0x35f527=_(_0x35f527)['union'](_0x1dbbe9)['compact']()[_0x3475('0x30')]();return db['VoiceQueue'][_0x3475('0x32')]({'where':{'id':_0x3d84a6[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](function(_0x118e11){return db[_0x3475('0x74')][_0x3475('0x75')](function(_0x3cf975){return _0x118e11[_0x3475('0x81')](_0x3d84a6['query'][_0x3475('0x82')],{'transaction':_0x3cf975})['then'](function(){if(!_[_0x3475('0x90')](_0x35f527)){return _0x118e11[_0x3475('0x91')](_0x35f527,{'transaction':_0x3cf975})[_0x3475('0x28')](function(){return db[_0x3475('0x7a')][_0x3475('0x29')]({'where':{'VoiceQueueId':_0x3d84a6[_0x3475('0x4f')]['id'],'UserId':_0x35f527},'transaction':_0x3cf975});});}})[_0x3475('0x28')](function(){_0x35f527[_0x3475('0x7e')](function(_0x81b80c){socket[_0x3475('0x7f')](_0x3475('0x92'),{'UserId':_0x81b80c,'VoiceQueueId':_0x118e11['id']});});});});});});})[_0x3475('0x28')](respondWithStatusCode(_0x2a40f9,null))['catch'](handleError(_0x2a40f9,null));};exports[_0x3475('0x93')]=function(_0x149324,_0x59c41f,_0x4e5bf9){var _0x54bfd0,_0xc7385f;return db[_0x3475('0x39')][_0x3475('0x32')]({'where':{'id':_0x149324[_0x3475('0x4f')]['id']}})['then'](handleEntityNotFound(_0x59c41f,null))[_0x3475('0x28')](function(_0x38ce99){if(_0x38ce99){_0xc7385f=_0x38ce99;return _0x38ce99['addAgents'](_0x149324[_0x3475('0x5f')][_0x3475('0x82')],_[_0x3475('0x5c')](_0x149324[_0x3475('0x5f')],[_0x3475('0x82'),'id'])||{})[_0x3475('0x94')](function(_0x5bfde2){for(var _0x3cb345=0x0;_0x3cb345<_0x149324[_0x3475('0x5f')][_0x3475('0x82')][_0x3475('0x43')];_0x3cb345+=0x1){socket['emit']('userVoiceQueue:save',{'UserId':Number(_0x149324[_0x3475('0x5f')][_0x3475('0x82')][_0x3cb345]),'VoiceQueueId':Number(_0x149324['params']['id'])});}return _0x5bfde2;});}})[_0x3475('0x28')](function(_0x588a48){_0x54bfd0=_0x588a48||[];if(_0xc7385f){return db['User'][_0x3475('0x4c')]({'where':{'id':_0x149324[_0x3475('0x5f')]['ids']},'attributes':['id',_0x3475('0x36'),_0x3475('0x95'),'voicePause','interface'],'raw':!![]});}})['then'](function(_0x24c4f8){if(!_[_0x3475('0x90')](_0x24c4f8)){var _0x4eb337=[];for(var _0x372656=0x0;_0x372656<_0x24c4f8['length'];_0x372656++){if(_0x24c4f8[_0x372656][_0x3475('0x95')]){_0x4eb337['push'](db['UserVoiceQueueRt'][_0x3475('0x79')]({'membername':_0x24c4f8[_0x372656][_0x3475('0x36')],'UserId':_0x24c4f8[_0x372656]['id'],'queue_name':_0xc7385f[_0x3475('0x36')],'VoiceQueueId':_0xc7385f['id'],'interface':_[_0x3475('0x7b')](_0x24c4f8[_0x372656][_0x3475('0x71')])?util['format']('SIP/%s',_0x24c4f8[_0x372656][_0x3475('0x36')]):_0x24c4f8[_0x372656]['interface'],'paused':_0x24c4f8[_0x372656][_0x3475('0x70')]||![],'penalty':_0x149324[_0x3475('0x5f')][_0x3475('0x73')]||0x0}));}}return BPromise[_0x3475('0x8f')](_0x4eb337);}})[_0x3475('0x28')](function(){return _0x54bfd0;})[_0x3475('0x28')](respondWithResult(_0x59c41f,null))[_0x3475('0x4e')](handleError(_0x59c41f,null));};exports['removeAgents']=function(_0x2cdeed,_0x359c71,_0x3edb9f){return db[_0x3475('0x39')][_0x3475('0x32')]({'where':{'id':_0x2cdeed[_0x3475('0x4f')]['id']}})['then'](handleEntityNotFound(_0x359c71,null))['then'](function(_0x3f4685){if(_0x3f4685){return _0x3f4685[_0x3475('0x91')](_0x2cdeed[_0x3475('0x3e')][_0x3475('0x82')])[_0x3475('0x28')](function(){if(_[_0x3475('0x96')](_0x2cdeed[_0x3475('0x3e')][_0x3475('0x82')])){for(var _0x4f102c=0x0;_0x4f102c<_0x2cdeed[_0x3475('0x3e')][_0x3475('0x82')]['length'];_0x4f102c+=0x1){socket['emit']('userVoiceQueue:remove',{'UserId':Number(_0x2cdeed['query'][_0x3475('0x82')][_0x4f102c]),'VoiceQueueId':Number(_0x2cdeed[_0x3475('0x4f')]['id'])});}}else{socket[_0x3475('0x7f')]('userVoiceQueue:remove',{'UserId':Number(_0x2cdeed[_0x3475('0x3e')]['ids']),'VoiceQueueId':Number(_0x2cdeed['params']['id'])});}});}})[_0x3475('0x28')](function(_0x3d3b89){return db[_0x3475('0x7a')][_0x3475('0x29')]({'where':{'VoiceQueueId':_0x2cdeed[_0x3475('0x4f')]['id'],'UserId':_0x2cdeed[_0x3475('0x3e')][_0x3475('0x82')]}})[_0x3475('0x28')](function(){return _0x3d3b89;});})[_0x3475('0x28')](respondWithStatusCode(_0x359c71,null))[_0x3475('0x4e')](handleError(_0x359c71,null));};exports['getAgents']=function(_0x259d66,_0xd5f66,_0x389ecc){var _0x45fdf8={};var _0x5903de={};var _0x2ce45d;var _0x3f4097;return db[_0x3475('0x39')][_0x3475('0x61')]({'where':{'id':_0x259d66[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0xd5f66,null))['then'](function(_0x1771bf){if(_0x1771bf){_0x2ce45d=_0x1771bf;_0x5903de[_0x3475('0x3c')]=_[_0x3475('0x3d')](db[_0x3475('0x6e')]['rawAttributes']);_0x5903de[_0x3475('0x3e')]=_[_0x3475('0x3d')](_0x259d66['query']);_0x5903de['filters']=_[_0x3475('0x40')](_0x5903de[_0x3475('0x3c')],_0x5903de[_0x3475('0x3e')]);_0x45fdf8[_0x3475('0x41')]=_[_0x3475('0x40')](_0x5903de[_0x3475('0x3c')],qs[_0x3475('0x42')](_0x259d66['query'][_0x3475('0x42')]));_0x45fdf8[_0x3475('0x41')]=_0x45fdf8[_0x3475('0x41')][_0x3475('0x43')]?_0x45fdf8[_0x3475('0x41')]:_0x5903de['model'];_0x45fdf8['order']=qs[_0x3475('0x47')](_0x259d66[_0x3475('0x3e')]['sort']);_0x45fdf8[_0x3475('0x48')]=qs[_0x3475('0x3f')](_[_0x3475('0x63')](_0x259d66['query'],_0x5903de[_0x3475('0x3f')]));if(_0x259d66[_0x3475('0x3e')][_0x3475('0x2d')]){_0x45fdf8['where']=_[_0x3475('0x49')](_0x45fdf8[_0x3475('0x48')],{'$or':_[_0x3475('0x2f')](_0x45fdf8[_0x3475('0x41')],function(_0x223151){var _0xe9d5d0={};_0xe9d5d0[_0x223151]={'$like':'%'+_0x259d66[_0x3475('0x3e')][_0x3475('0x2d')]+'%'};return _0xe9d5d0;})});}_0x45fdf8=_[_0x3475('0x49')]({},_0x45fdf8,_0x259d66[_0x3475('0x4a')]);return _0x2ce45d[_0x3475('0x97')](_0x45fdf8);}})[_0x3475('0x28')](function(_0x50ad8b){if(_0x50ad8b){_0x3f4097=_0x50ad8b[_0x3475('0x43')];if(!_0x259d66[_0x3475('0x3e')][_0x3475('0x44')](_0x3475('0x45'))){_0x45fdf8[_0x3475('0x21')]=qs[_0x3475('0x21')](_0x259d66[_0x3475('0x3e')][_0x3475('0x21')]);_0x45fdf8[_0x3475('0x1f')]=qs[_0x3475('0x1f')](_0x259d66[_0x3475('0x3e')][_0x3475('0x1f')]);}return _0x2ce45d[_0x3475('0x97')](_0x45fdf8);}})[_0x3475('0x28')](function(_0x495297){if(_0x495297){return _0x495297?{'count':_0x3f4097,'rows':_0x495297}:null;}})[_0x3475('0x28')](respondWithResult(_0xd5f66,null))[_0x3475('0x4e')](handleError(_0xd5f66,null));};exports[_0x3475('0x98')]=function(_0x5b6569,_0x1b00b9,_0x50af02){var _0x43434d={};var _0x452529={};var _0x3dd126;var _0x48c055;return db[_0x3475('0x39')][_0x3475('0x61')]({'where':{'id':_0x5b6569[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x1b00b9,null))[_0x3475('0x28')](function(_0x2e7e62){if(_0x2e7e62){_0x3dd126=_0x2e7e62;_0x452529['model']=_[_0x3475('0x3d')](db[_0x3475('0x7a')][_0x3475('0x3a')]);_0x452529['query']=_['keys'](_0x5b6569['query']);_0x452529['filters']=_['intersection'](_0x452529[_0x3475('0x3c')],_0x452529['query']);_0x43434d[_0x3475('0x41')]=_['intersection'](_0x452529[_0x3475('0x3c')],qs[_0x3475('0x42')](_0x5b6569['query'][_0x3475('0x42')]));_0x43434d[_0x3475('0x41')]=_0x43434d[_0x3475('0x41')][_0x3475('0x43')]?_0x43434d[_0x3475('0x41')]:_0x452529[_0x3475('0x3c')];_0x43434d['order']=qs[_0x3475('0x47')](_0x5b6569[_0x3475('0x3e')][_0x3475('0x47')]);_0x43434d[_0x3475('0x48')]=qs[_0x3475('0x3f')](_[_0x3475('0x63')](_0x5b6569[_0x3475('0x3e')],_0x452529[_0x3475('0x3f')]));if(_0x5b6569['query'][_0x3475('0x2d')]){_0x43434d[_0x3475('0x48')]=_[_0x3475('0x49')](_0x43434d[_0x3475('0x48')],{'$or':_[_0x3475('0x2f')](_0x43434d['attributes'],function(_0x38444b){var _0x15553c={};_0x15553c[_0x38444b]={'$like':'%'+_0x5b6569['query'][_0x3475('0x2d')]+'%'};return _0x15553c;})});}_0x43434d=_['merge']({},_0x43434d,_0x5b6569[_0x3475('0x4a')]);return _0x3dd126['getMembers'](_0x43434d);}})['then'](function(_0x259c90){if(_0x259c90){_0x48c055=_0x259c90[_0x3475('0x43')];if(!_0x5b6569[_0x3475('0x3e')][_0x3475('0x44')](_0x3475('0x45'))){_0x43434d['limit']=qs[_0x3475('0x21')](_0x5b6569['query'][_0x3475('0x21')]);_0x43434d[_0x3475('0x1f')]=qs['offset'](_0x5b6569[_0x3475('0x3e')][_0x3475('0x1f')]);}return _0x3dd126[_0x3475('0x98')](_0x43434d);}})['then'](function(_0x481027){return _0x481027?{'count':_0x48c055,'rows':_0x481027}:null;})[_0x3475('0x28')](respondWithResult(_0x1b00b9,null))[_0x3475('0x4e')](handleError(_0x1b00b9,null));};exports[_0x3475('0x99')]=function(_0x1d333e,_0x1e9343,_0x654a6d){var _0x5d280f={};var _0x3a197f={};var _0x4322c7;var _0x62db6;return db['VoiceQueue'][_0x3475('0x61')]({'where':{'id':_0x1d333e[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x1e9343,null))[_0x3475('0x28')](function(_0x3c8b8a){if(_0x3c8b8a){_0x4322c7=_0x3c8b8a;_0x3a197f['model']=_[_0x3475('0x3d')](db['CmList'][_0x3475('0x3a')]);_0x3a197f[_0x3475('0x3e')]=_[_0x3475('0x3d')](_0x1d333e['query']);_0x3a197f[_0x3475('0x3f')]=_[_0x3475('0x40')](_0x3a197f[_0x3475('0x3c')],_0x3a197f[_0x3475('0x3e')]);_0x5d280f[_0x3475('0x41')]=_['intersection'](_0x3a197f['model'],qs[_0x3475('0x42')](_0x1d333e['query'][_0x3475('0x42')]));_0x5d280f[_0x3475('0x41')]=_0x5d280f[_0x3475('0x41')]['length']?_0x5d280f[_0x3475('0x41')]:_0x3a197f[_0x3475('0x3c')];_0x5d280f['order']=qs['sort'](_0x1d333e[_0x3475('0x3e')][_0x3475('0x47')]);_0x5d280f[_0x3475('0x48')]=qs[_0x3475('0x3f')](_[_0x3475('0x63')](_0x1d333e[_0x3475('0x3e')],_0x3a197f[_0x3475('0x3f')]));if(_0x1d333e[_0x3475('0x3e')][_0x3475('0x2d')]){_0x5d280f[_0x3475('0x48')]=_[_0x3475('0x49')](_0x5d280f[_0x3475('0x48')],{'$or':_[_0x3475('0x2f')](_0x5d280f['attributes'],function(_0x59aeed){var _0x15a627={};_0x15a627[_0x59aeed]={'$like':'%'+_0x1d333e['query'][_0x3475('0x2d')]+'%'};return _0x15a627;})});}_0x5d280f=_[_0x3475('0x49')]({},_0x5d280f,_0x1d333e[_0x3475('0x4a')]);return _0x4322c7[_0x3475('0x99')](_0x5d280f);}})[_0x3475('0x28')](function(_0x214938){if(_0x214938){_0x62db6=_0x214938['length'];if(!_0x1d333e[_0x3475('0x3e')][_0x3475('0x44')](_0x3475('0x45'))){_0x5d280f['limit']=qs[_0x3475('0x21')](_0x1d333e[_0x3475('0x3e')][_0x3475('0x21')]);_0x5d280f['offset']=qs[_0x3475('0x1f')](_0x1d333e[_0x3475('0x3e')][_0x3475('0x1f')]);}return _0x4322c7[_0x3475('0x99')](_0x5d280f);}})['then'](function(_0x20a000){if(_0x20a000){return _0x20a000?{'count':_0x62db6,'rows':_0x20a000}:null;}})['then'](respondWithResult(_0x1e9343,null))[_0x3475('0x4e')](handleError(_0x1e9343,null));};exports[_0x3475('0x9a')]=function(_0x29dab3,_0x2e6d40,_0x23d321){var _0x14b75c=moment()[_0x3475('0x7c')](_0x3475('0x9b'));var _0x30b61a,_0x30f102;return db[_0x3475('0x39')][_0x3475('0x32')]({'where':{'id':_0x29dab3[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x2e6d40,null))[_0x3475('0x28')](function(_0x465ee9){if(_0x465ee9){_0x30f102=_0x465ee9;return _0x465ee9[_0x3475('0x9a')](_0x29dab3[_0x3475('0x5f')]['ids'],_[_0x3475('0x5c')](_0x29dab3[_0x3475('0x5f')],[_0x3475('0x82'),'id'])||{});}return null;})[_0x3475('0x94')](function(_0x4134ad){var _0x4ee8ff;_0x30b61a=_0x4134ad||[];var _0xd3453=[];if(_0x4134ad){for(var _0x53144f=0x0;_0x53144f<_0x4134ad['length'];_0x53144f+=0x1){var _0x303fa3=_0x4134ad[_0x53144f]['get']({'plain':!![]});_0x30f102['dialCheckDuplicateType']=_0x29dab3[_0x3475('0x5f')]['dialCheckDuplicateType']?_0x29dab3[_0x3475('0x5f')][_0x3475('0x9c')]:_0x30f102['dialCheckDuplicateType'];switch(_0x30f102[_0x3475('0x9c')]){case'always':_0x4ee8ff=squel[_0x3475('0x9d')]()['into'](_0x3475('0x9e'))[_0x3475('0x9f')]([_0x3475('0xa0'),_0x3475('0xa1'),_0x3475('0xa2'),_0x3475('0xa3'),'VoiceQueueId',_0x3475('0x5d'),_0x3475('0x5e')],squel[_0x3475('0x83')]()[_0x3475('0x84')](_0x3475('0xa0'),_0x3475('0xa0'))[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27','scheduledAt')[_0x3475('0x84')]('id',_0x3475('0xa2'))['field'](_0x303fa3[_0x3475('0xa4')]['toString'](),_0x3475('0xa3'))[_0x3475('0x84')](_0x29dab3[_0x3475('0x4f')]['id'][_0x3475('0xa5')](),'VoiceQueueId')[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27','createdAt')[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27',_0x3475('0x5e'))['from'](_0x3475('0xa6'))[_0x3475('0x48')](_0x3475('0xa7'))[_0x3475('0x48')]('ListId\x20=\x20?',_0x303fa3[_0x3475('0xa4')][_0x3475('0xa5')]())[_0x3475('0x48')]('phone\x20IS\x20NOT\x20NULL')['where'](_0x3475('0xa8'),squel[_0x3475('0x83')]()[_0x3475('0x84')]('COALESCE(calleridnum,\x27\x27)')[_0x3475('0x86')](_0x3475('0xa9'))[_0x3475('0x48')](_0x3475('0x89'),_0x29dab3[_0x3475('0x4f')]['id']['toString']()))[_0x3475('0x48')]('phone\x20NOT\x20IN\x20(?)',squel[_0x3475('0x83')]()['field']('COALESCE(phone,\x27\x27)')[_0x3475('0x86')](_0x3475('0x9e'))[_0x3475('0x48')]('VoiceQueueId\x20=\x20?',_0x29dab3['params']['id'][_0x3475('0xa5')]())))['toString']();break;case _0x3475('0xaa'):_0x4ee8ff=squel[_0x3475('0x9d')]()[_0x3475('0xab')](_0x3475('0x9e'))['fromQuery']([_0x3475('0xa0'),_0x3475('0xa1'),_0x3475('0xa2'),'ListId',_0x3475('0x65'),_0x3475('0x5d'),_0x3475('0x5e')],squel[_0x3475('0x83')]()['field'](_0x3475('0xa0'),'phone')[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27',_0x3475('0xa1'))[_0x3475('0x84')]('id',_0x3475('0xa2'))[_0x3475('0x84')](_0x303fa3[_0x3475('0xa4')][_0x3475('0xa5')](),'ListId')[_0x3475('0x84')](_0x29dab3[_0x3475('0x4f')]['id'][_0x3475('0xa5')](),'VoiceQueueId')[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27',_0x3475('0x5d'))[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27',_0x3475('0x5e'))[_0x3475('0x86')]('cm_contacts')[_0x3475('0x48')](_0x3475('0xa7'))[_0x3475('0x48')](_0x3475('0xac'),_0x303fa3['CmListId']['toString']())[_0x3475('0x48')](_0x3475('0xad'))[_0x3475('0x48')]('phone\x20NOT\x20IN\x20(?)',squel['select']()[_0x3475('0x84')](_0x3475('0xae'))[_0x3475('0x86')]('cm_hopper')[_0x3475('0x48')](_0x3475('0x89'),_0x29dab3[_0x3475('0x4f')]['id']['toString']())))['toString']();break;default:_0x4ee8ff=squel['insert']()[_0x3475('0xab')](_0x3475('0x9e'))[_0x3475('0x9f')]([_0x3475('0xa0'),_0x3475('0xa1'),_0x3475('0xa2'),'ListId',_0x3475('0x65'),_0x3475('0x5d'),_0x3475('0x5e')],squel[_0x3475('0x83')]()[_0x3475('0x84')](_0x3475('0xa0'),_0x3475('0xa0'))[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27',_0x3475('0xa1'))['field']('id',_0x3475('0xa2'))[_0x3475('0x84')](_0x303fa3['CmListId'][_0x3475('0xa5')](),'ListId')['field'](_0x29dab3[_0x3475('0x4f')]['id']['toString'](),'VoiceQueueId')[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27',_0x3475('0x5d'))[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27',_0x3475('0x5e'))[_0x3475('0x86')](_0x3475('0xa6'))[_0x3475('0x48')](_0x3475('0xa7'))['where'](_0x3475('0xac'),_0x303fa3[_0x3475('0xa4')][_0x3475('0xa5')]())[_0x3475('0x48')](_0x3475('0xad')))[_0x3475('0xa5')]();}_0xd3453[_0x3475('0x8b')](db[_0x3475('0x74')][_0x3475('0x3e')](_0x4ee8ff));}return BPromise['all'](_0xd3453);}})[_0x3475('0x28')](function(){var _0x59a19e=[];var _0x21b6bf=squel['insert']()['into'](_0x3475('0xaf'))[_0x3475('0x9f')]([_0x3475('0xb0'),_0x3475('0xa0'),_0x3475('0xb1'),'createdAt',_0x3475('0x5e')],squel[_0x3475('0x83')]()[_0x3475('0x84')](_0x3475('0xb2'))[_0x3475('0x84')]('ci.item')[_0x3475('0x84')](_0x3475('0xb3'))[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27','createdAt')[_0x3475('0x84')]('\x27'+_0x14b75c+'\x27',_0x3475('0x5e'))['from'](_0x3475('0xb4'),'ci')[_0x3475('0x88')](_0x3475('0x9e'),'h','h.ContactId=ci.CmContactId')['where'](_0x3475('0xb5'),_0x14b75c)[_0x3475('0x48')](_0x3475('0xb6'),_0x3475('0xb7')))[_0x3475('0xa5')]();_0x59a19e[_0x3475('0x8b')](db[_0x3475('0x74')][_0x3475('0x3e')](_0x21b6bf));return BPromise['all'](_0x59a19e);})[_0x3475('0x28')](function(){return _0x30b61a;})[_0x3475('0x28')](respondWithResult(_0x2e6d40,null))[_0x3475('0x4e')](handleError(_0x2e6d40,null));};exports['removeLists']=function(_0x2e541f,_0x2b2894,_0x5de29d){return db['VoiceQueue'][_0x3475('0x32')]({'where':{'id':_0x2e541f[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x2b2894,null))['then'](function(_0x522e4f){if(_0x522e4f){return _0x522e4f[_0x3475('0xb8')](_0x2e541f['query'][_0x3475('0x82')]);}})[_0x3475('0x28')](function(_0x5e5809){if(_0x5e5809){return db[_0x3475('0x62')][_0x3475('0x29')]({'where':{'ListId':_0x2e541f[_0x3475('0x3e')][_0x3475('0x82')],'VoiceQueueId':_0x2e541f[_0x3475('0x4f')]['id']}})[_0x3475('0x28')](function(){return _0x5e5809;});}})[_0x3475('0x28')](respondWithStatusCode(_0x2b2894,null))[_0x3475('0x4e')](handleError(_0x2b2894,null));};exports[_0x3475('0xb9')]=function(_0x4368fb,_0x11ea60,_0x4f64fa){var _0x4cd92b={};var _0x23782f={};var _0x2157a8;var _0x53d2ee;return db['VoiceQueue'][_0x3475('0x61')]({'where':{'id':_0x4368fb[_0x3475('0x4f')]['id']}})['then'](handleEntityNotFound(_0x11ea60,null))[_0x3475('0x28')](function(_0x1950ee){if(_0x1950ee){_0x2157a8=_0x1950ee;_0x23782f['model']=_[_0x3475('0x3d')](db[_0x3475('0xba')][_0x3475('0x3a')]);_0x23782f[_0x3475('0x3e')]=_[_0x3475('0x3d')](_0x4368fb[_0x3475('0x3e')]);_0x23782f[_0x3475('0x3f')]=_['intersection'](_0x23782f['model'],_0x23782f[_0x3475('0x3e')]);_0x4cd92b[_0x3475('0x41')]=_[_0x3475('0x40')](_0x23782f[_0x3475('0x3c')],qs['fields'](_0x4368fb[_0x3475('0x3e')][_0x3475('0x42')]));_0x4cd92b[_0x3475('0x41')]=_0x4cd92b[_0x3475('0x41')][_0x3475('0x43')]?_0x4cd92b[_0x3475('0x41')]:_0x23782f[_0x3475('0x3c')];_0x4cd92b['order']=qs[_0x3475('0x47')](_0x4368fb[_0x3475('0x3e')]['sort']);_0x4cd92b[_0x3475('0x48')]=qs[_0x3475('0x3f')](_[_0x3475('0x63')](_0x4368fb['query'],_0x23782f[_0x3475('0x3f')]));if(_0x4368fb[_0x3475('0x3e')][_0x3475('0x2d')]){_0x4cd92b[_0x3475('0x48')]=_[_0x3475('0x49')](_0x4cd92b[_0x3475('0x48')],{'$or':_[_0x3475('0x2f')](_0x4cd92b[_0x3475('0x41')],function(_0x191e4c){var _0x753426={};_0x753426[_0x191e4c]={'$like':'%'+_0x4368fb[_0x3475('0x3e')]['filter']+'%'};return _0x753426;})});}_0x4cd92b=_[_0x3475('0x49')]({},_0x4cd92b,_0x4368fb[_0x3475('0x4a')]);return _0x2157a8[_0x3475('0xb9')](_0x4cd92b);}})['then'](function(_0x53e4f5){if(_0x53e4f5){_0x53d2ee=_0x53e4f5[_0x3475('0x43')];if(!_0x4368fb[_0x3475('0x3e')]['hasOwnProperty'](_0x3475('0x45'))){_0x4cd92b[_0x3475('0x21')]=qs[_0x3475('0x21')](_0x4368fb['query'][_0x3475('0x21')]);_0x4cd92b['offset']=qs[_0x3475('0x1f')](_0x4368fb[_0x3475('0x3e')][_0x3475('0x1f')]);}return _0x2157a8[_0x3475('0xb9')](_0x4cd92b);}})[_0x3475('0x28')](function(_0x575e12){if(_0x575e12){return _0x575e12?{'count':_0x53d2ee,'rows':_0x575e12}:null;}})[_0x3475('0x28')](respondWithResult(_0x11ea60,null))[_0x3475('0x4e')](handleError(_0x11ea60,null));};exports[_0x3475('0xbb')]=function(_0x58fba1,_0x3ed37c,_0x48415e){var _0x570835,_0xf18e52;return db[_0x3475('0x39')]['find']({'where':{'id':_0x58fba1['params']['id']}})['then'](handleEntityNotFound(_0x3ed37c,null))['then'](function(_0x514aec){if(_0x514aec){_0xf18e52=_0x514aec;return _0x514aec[_0x3475('0xbb')](_0x58fba1[_0x3475('0x5f')][_0x3475('0x82')],_[_0x3475('0x5c')](_0x58fba1['body'],[_0x3475('0x82'),'id'])||{});}return null;})[_0x3475('0x94')](function(_0x3f04ec){var _0x258405;_0x570835=_0x3f04ec||[];var _0x1da7c5=[];if(_0x3f04ec){for(var _0x5885b1=0x0;_0x5885b1<_0x3f04ec[_0x3475('0x43')];_0x5885b1+=0x1){var _0x42de1d=_0x3f04ec[_0x5885b1][_0x3475('0x2a')]({'plain':!![]});_0x258405=squel[_0x3475('0x9d')]()[_0x3475('0xab')]('cm_hopper_black')[_0x3475('0x9f')]([_0x3475('0xa0'),'ContactId','ListId',_0x3475('0x65'),_0x3475('0x5d'),_0x3475('0x5e')],squel['select']()[_0x3475('0x84')](_0x3475('0xa0'),_0x3475('0xa0'))[_0x3475('0x84')]('id',_0x3475('0xa2'))[_0x3475('0x84')](_0x42de1d[_0x3475('0xa4')][_0x3475('0xa5')](),_0x3475('0xa3'))[_0x3475('0x84')](_0x58fba1[_0x3475('0x4f')]['id'][_0x3475('0xa5')](),_0x3475('0x65'))[_0x3475('0x84')](_0x3475('0xbc'),_0x3475('0x5d'))[_0x3475('0x84')]('NOW()',_0x3475('0x5e'))['from'](_0x3475('0xa6'))[_0x3475('0x48')](_0x3475('0xa7'))[_0x3475('0x48')](_0x3475('0xac'),_0x42de1d[_0x3475('0xa4')][_0x3475('0xa5')]())[_0x3475('0x48')](_0x3475('0xad')))['toString']();_0x1da7c5['push'](db[_0x3475('0x74')]['query'](_0x258405));}return BPromise['all'](_0x1da7c5);}})[_0x3475('0x28')](function(){return _0x570835;})[_0x3475('0x28')](respondWithResult(_0x3ed37c,null))['catch'](handleError(_0x3ed37c,null));};exports['removeBlackLists']=function(_0x365f19,_0x44dc85,_0x9f2598){return db[_0x3475('0x39')][_0x3475('0x32')]({'where':{'id':_0x365f19['params']['id']}})[_0x3475('0x28')](handleEntityNotFound(_0x44dc85,null))[_0x3475('0x28')](function(_0xdd99d2){if(_0xdd99d2){return _0xdd99d2[_0x3475('0xbd')](_0x365f19[_0x3475('0x3e')]['ids']);}})[_0x3475('0x28')](function(_0x17da57){if(_0x17da57){return db['CmHopperBlack']['destroy']({'where':{'ListId':_0x365f19['query']['ids'],'VoiceQueueId':_0x365f19['params']['id']}})[_0x3475('0x28')](function(){return _0x17da57;});}})['then'](respondWithStatusCode(_0x44dc85,null))[_0x3475('0x4e')](handleError(_0x44dc85,null));};
git://repos.xcallymotion.com / motion2.git / blob