Built motion from commit (unavailable).|2.5.28
[motion2.git] / server / api / voiceQueue / voiceQueue.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0x1712=['bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','jsforce','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','register','status','end','json','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','get','VoiceQueues','inbound','outbound','filter','ignore','map','value','includes','type','find','name','UserProfileResource','sendStatus','error','stack','send','index','VoiceQueue','rawAttributes','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','pick','where','merge','VIRTUAL','options','count','include','findAll','rows','catch','params','includeAll','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','QueueCampaigns','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','userProfileId','getHoppers','findOne','CmHopper','order','VoiceQueueId','CmHopperHistory','getHopperFinals','CmHopperFinal','CmHopperBlack','getTeams','Team','teams','User','online','voicePause','interface','Agents','forEach','penalty','sequelize','transaction','upsert','each','UserVoiceQueue','UserVoiceQueueRt','isNil','SIP/%s','userVoiceQueue:save','field','tq.TeamId','from','team_has_voice_queues','join','VoiceQueueId\x20=\x20?','push','toString','QueryTypes','SELECT','every','TeamId','all','union','compact','removeTeams','ids','isEmpty','removeAgents','emit','userVoiceQueue:remove','addAgents','format','isArray','getAgents','getMembers','getLists','CmList','addLists','spread','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','scheduledAt','ContactId','ListId','select','phone','NOW()','CmListId','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','COALESCE(phone,\x27\x27)','onlyIfOpen','cm_contacts','removeLists','getBlackLists','addBlackLists','cm_hopper_black','eml-format','rimraf','zip-dir','request-promise','moment'];(function(_0x2afb44,_0x249a57){var _0x15ccc2=function(_0x180748){while(--_0x180748){_0x2afb44['push'](_0x2afb44['shift']());}};_0x15ccc2(++_0x249a57);}(_0x1712,0x169));var _0x2171=function(_0x65c0bb,_0x82e7b8){_0x65c0bb=_0x65c0bb-0x0;var _0x320bd5=_0x1712[_0x65c0bb];return _0x320bd5;};'use strict';var emlformat=require(_0x2171('0x0'));var rimraf=require(_0x2171('0x1'));var zipdir=require(_0x2171('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x2171('0x3'));var moment=require(_0x2171('0x4'));var BPromise=require(_0x2171('0x5'));var Mustache=require(_0x2171('0x6'));var util=require(_0x2171('0x7'));var path=require(_0x2171('0x8'));var sox=require(_0x2171('0x9'));var csv=require(_0x2171('0xa'));var ejs=require(_0x2171('0xb'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x2171('0xc'));var squel=require(_0x2171('0xd'));var crypto=require('crypto');var jsforce=require(_0x2171('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x2171('0xa'));var querystring=require(_0x2171('0xf'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x2171('0x10'));var qs=require(_0x2171('0x11'));var as=require(_0x2171('0x12'));var hardwareService=require(_0x2171('0x13'));var logger=require(_0x2171('0x14'))('api');var utils=require(_0x2171('0x15'));var config=require(_0x2171('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0x2171('0x17'))['db'];config[_0x2171('0x18')]=_[_0x2171('0x19')](config[_0x2171('0x18')],{'host':_0x2171('0x1a'),'port':0x18eb});var socket=require(_0x2171('0x1b'))(new Redis(config[_0x2171('0x18')]));require(_0x2171('0x1c'))[_0x2171('0x1d')](socket);function respondWithStatusCode(_0x4f2d03,_0x424355){_0x424355=_0x424355||0xcc;return function(_0x50f8ab){if(_0x50f8ab){return _0x4f2d03['sendStatus'](_0x424355);}return _0x4f2d03[_0x2171('0x1e')](_0x424355)[_0x2171('0x1f')]();};}function respondWithResult(_0x1825a4,_0x1c738c){_0x1c738c=_0x1c738c||0xc8;return function(_0x321d63){if(_0x321d63){return _0x1825a4[_0x2171('0x1e')](_0x1c738c)[_0x2171('0x20')](_0x321d63);}};}function respondWithFilteredResult(_0x48bb7c,_0x801029){return function(_0x5446fc){if(_0x5446fc){var _0x322e33=_0x5446fc['count'],_0x4ae8ea=_0x801029['offset'],_0x35e7e6=_0x801029[_0x2171('0x21')]+_0x801029[_0x2171('0x22')],_0x4bb48c;if(_0x35e7e6>=_0x322e33){_0x35e7e6=_0x322e33;_0x4bb48c=0xc8;}else{_0x4bb48c=0xce;}_0x48bb7c[_0x2171('0x1e')](_0x4bb48c);return _0x48bb7c[_0x2171('0x23')](_0x2171('0x24'),_0x4ae8ea+'-'+_0x35e7e6+'/'+_0x322e33)['json'](_0x5446fc);}return null;};}function patchUpdates(_0x790248){return function(_0x5de81b){try{jsonpatch[_0x2171('0x25')](_0x5de81b,_0x790248,!![]);}catch(_0x147809){return BPromise[_0x2171('0x26')](_0x147809);}return _0x5de81b[_0x2171('0x27')]();};}function saveUpdates(_0x9beb04,_0x44aa6a){return function(_0x306c7f){if(_0x306c7f){return _0x306c7f[_0x2171('0x28')](_0x9beb04)[_0x2171('0x29')](function(_0x92c260){return _0x92c260;});}return null;};}function removeEntity(_0x1b525c,_0x14cd31){return function(_0x3c02d5){if(_0x3c02d5){return _0x3c02d5[_0x2171('0x2a')]()['then'](function(){var _0x54aa42=_0x3c02d5[_0x2171('0x2b')]({'plain':!![]});var _0x40b12c=[{'name':_0x2171('0x2c'),'value':_0x2171('0x2d'),'ignore':![]},{'name':'QueueCampaigns','value':_0x2171('0x2e'),'ignore':![]}];var _0x5076bc=_(_0x40b12c)[_0x2171('0x2f')](_0x2171('0x30'))[_0x2171('0x31')](_0x2171('0x32'))[_0x2171('0x32')]();if(_[_0x2171('0x33')](_0x5076bc,_0x54aa42[_0x2171('0x34')])){return;}var _0x161834=_[_0x2171('0x35')](_0x40b12c,['value',_0x54aa42[_0x2171('0x34')]])[_0x2171('0x36')];return db[_0x2171('0x37')]['destroy']({'where':{'type':_0x161834,'resourceId':_0x54aa42['id']}})[_0x2171('0x29')](function(){return _0x3c02d5;});})['then'](function(){_0x1b525c['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0xe19776,_0x493390){return function(_0x454ced){if(!_0x454ced){_0xe19776[_0x2171('0x38')](0x194);}return _0x454ced;};}function handleError(_0x370493,_0x26da2c){_0x26da2c=_0x26da2c||0x1f4;return function(_0x4ddf69){logger[_0x2171('0x39')](_0x4ddf69[_0x2171('0x3a')]);if(_0x4ddf69[_0x2171('0x36')]){delete _0x4ddf69['name'];}_0x370493[_0x2171('0x1e')](_0x26da2c)[_0x2171('0x3b')](_0x4ddf69);};}exports[_0x2171('0x3c')]=function(_0x29f540,_0x22ae38){var _0x5097f9={},_0x4998e5={},_0x4a0608={'count':0x0,'rows':[]};var _0x312163=_[_0x2171('0x31')](db[_0x2171('0x3d')][_0x2171('0x3e')],function(_0x26c736){return{'name':_0x26c736['fieldName'],'type':_0x26c736[_0x2171('0x34')][_0x2171('0x3f')]};});_0x4998e5[_0x2171('0x40')]=_[_0x2171('0x31')](_0x312163,'name');_0x4998e5[_0x2171('0x41')]=_[_0x2171('0x42')](_0x29f540['query']);_0x4998e5[_0x2171('0x43')]=_[_0x2171('0x44')](_0x4998e5[_0x2171('0x40')],_0x4998e5[_0x2171('0x41')]);_0x5097f9[_0x2171('0x45')]=_[_0x2171('0x44')](_0x4998e5[_0x2171('0x40')],qs['fields'](_0x29f540[_0x2171('0x41')][_0x2171('0x46')]));_0x5097f9['attributes']=_0x5097f9[_0x2171('0x45')][_0x2171('0x47')]?_0x5097f9['attributes']:_0x4998e5[_0x2171('0x40')];if(!_0x29f540[_0x2171('0x41')][_0x2171('0x48')](_0x2171('0x49'))){_0x5097f9[_0x2171('0x22')]=qs['limit'](_0x29f540['query'][_0x2171('0x22')]);_0x5097f9['offset']=qs['offset'](_0x29f540['query'][_0x2171('0x21')]);}_0x5097f9['order']=qs[_0x2171('0x4a')](_0x29f540['query']['sort']);_0x5097f9['where']=qs[_0x2171('0x43')](_[_0x2171('0x4b')](_0x29f540[_0x2171('0x41')],_0x4998e5[_0x2171('0x43')]),_0x312163);if(_0x29f540[_0x2171('0x41')][_0x2171('0x2f')]){_0x5097f9[_0x2171('0x4c')]=_[_0x2171('0x4d')](_0x5097f9[_0x2171('0x4c')],{'$or':_[_0x2171('0x31')](_0x312163,function(_0x5ad886){if(_0x5ad886['type']!==_0x2171('0x4e')){var _0x16ad43={};_0x16ad43[_0x5ad886['name']]={'$like':'%'+_0x29f540[_0x2171('0x41')][_0x2171('0x2f')]+'%'};return _0x16ad43;}})});}_0x5097f9=_['merge']({},_0x5097f9,_0x29f540[_0x2171('0x4f')]);var _0x136865={'where':_0x5097f9[_0x2171('0x4c')]};return db[_0x2171('0x3d')][_0x2171('0x50')](_0x136865)[_0x2171('0x29')](function(_0x3cbe41){_0x4a0608[_0x2171('0x50')]=_0x3cbe41;if(_0x29f540[_0x2171('0x41')]['includeAll']){_0x5097f9[_0x2171('0x51')]=[{'all':!![]}];}return db[_0x2171('0x3d')][_0x2171('0x52')](_0x5097f9);})[_0x2171('0x29')](function(_0x54667c){_0x4a0608[_0x2171('0x53')]=_0x54667c;return _0x4a0608;})[_0x2171('0x29')](respondWithFilteredResult(_0x22ae38,_0x5097f9))[_0x2171('0x54')](handleError(_0x22ae38,null));};exports['show']=function(_0x109891,_0x4082da){var _0x3355d0={'raw':![],'where':{'id':_0x109891[_0x2171('0x55')]['id']}},_0x2d65cc={};_0x2d65cc[_0x2171('0x40')]=_[_0x2171('0x42')](db[_0x2171('0x3d')][_0x2171('0x3e')]);_0x2d65cc[_0x2171('0x41')]=_[_0x2171('0x42')](_0x109891['query']);_0x2d65cc[_0x2171('0x43')]=_['intersection'](_0x2d65cc[_0x2171('0x40')],_0x2d65cc[_0x2171('0x41')]);_0x3355d0[_0x2171('0x45')]=_['intersection'](_0x2d65cc['model'],qs[_0x2171('0x46')](_0x109891[_0x2171('0x41')][_0x2171('0x46')]));_0x3355d0[_0x2171('0x45')]=_0x3355d0[_0x2171('0x45')]['length']?_0x3355d0[_0x2171('0x45')]:_0x2d65cc['model'];if(_0x109891[_0x2171('0x41')][_0x2171('0x56')]){_0x3355d0[_0x2171('0x51')]=[{'all':!![]}];}_0x3355d0=_[_0x2171('0x4d')]({},_0x3355d0,_0x109891[_0x2171('0x4f')]);return db[_0x2171('0x3d')]['find'](_0x3355d0)['then'](handleEntityNotFound(_0x4082da,null))[_0x2171('0x29')](respondWithResult(_0x4082da,null))[_0x2171('0x54')](handleError(_0x4082da,null));};exports[_0x2171('0x57')]=function(_0x547aaa,_0x194bd8){return db['VoiceQueue'][_0x2171('0x57')](_0x547aaa[_0x2171('0x58')],{})[_0x2171('0x29')](function(_0x454cc0){var _0xb3c277=_0x547aaa[_0x2171('0x59')]['get']({'plain':!![]});if(!_0xb3c277)throw new Error(_0x2171('0x5a'));if(_0xb3c277[_0x2171('0x5b')]===_0x2171('0x59')){var _0x4611cf=_0x454cc0['get']({'plain':!![]});var _0x4282b8=[{'name':_0x2171('0x2c'),'value':_0x2171('0x2d')},{'name':_0x2171('0x5c'),'value':_0x2171('0x2e')}];var _0x133a1a=_[_0x2171('0x35')](_0x4282b8,['value',_0x4611cf[_0x2171('0x34')]])[_0x2171('0x36')];return db[_0x2171('0x5d')][_0x2171('0x35')]({'where':{'name':_0x133a1a,'userProfileId':_0xb3c277['userProfileId']},'raw':!![]})['then'](function(_0x32008c){if(_0x32008c&&_0x32008c[_0x2171('0x5e')]===0x0){return db['UserProfileResource'][_0x2171('0x57')]({'name':_0x4611cf[_0x2171('0x36')],'resourceId':_0x4611cf['id'],'type':_0x32008c['name'],'sectionId':_0x32008c['id']},{})[_0x2171('0x29')](function(){return _0x454cc0;});}else{return _0x454cc0;}})[_0x2171('0x54')](function(_0x1848b6){logger[_0x2171('0x39')](_0x2171('0x5f'),_0x1848b6);throw _0x1848b6;});}return _0x454cc0;})['then'](respondWithResult(_0x194bd8,0xc9))['catch'](handleError(_0x194bd8,null));};exports[_0x2171('0x60')]=function(_0x5abf4d,_0x4ac3a9){var _0x13b428={'where':{'id':_0x5abf4d[_0x2171('0x55')]['id']}},_0x3f4bd1={};_0x3f4bd1[_0x2171('0x40')]=_['keys'](db[_0x2171('0x3d')][_0x2171('0x3e')]);_0x13b428[_0x2171('0x45')]=_['intersection'](_0x3f4bd1['model'],qs[_0x2171('0x46')](_0x5abf4d[_0x2171('0x41')][_0x2171('0x46')]));_0x13b428['attributes']=_0x13b428['attributes'][_0x2171('0x47')]?_0x13b428[_0x2171('0x45')]:_0x3f4bd1['model'];if(_0x5abf4d[_0x2171('0x41')][_0x2171('0x56')]){_0x13b428[_0x2171('0x51')]=[{'all':!![]}];}_0x13b428=_[_0x2171('0x4d')]({},_0x13b428,_0x5abf4d[_0x2171('0x4f')]);return db['VoiceQueue'][_0x2171('0x35')](_0x13b428)[_0x2171('0x29')](handleEntityNotFound(_0x4ac3a9,null))[_0x2171('0x29')](function(_0x2e1f33){if(_0x2e1f33){var _0x31e183=_0x2e1f33['get']({'plain':!![]});_0x31e183=qs[_0x2171('0x61')](_0x31e183,['id',_0x2171('0x62'),_0x2171('0x63')]);_0x5abf4d['body']=_[_0x2171('0x61')](_0x5abf4d[_0x2171('0x58')],['id',_0x2171('0x62'),_0x2171('0x63')]);return db[_0x2171('0x3d')]['create'](_[_0x2171('0x4d')](_0x31e183,_0x5abf4d['body']),{'include':_0x5abf4d['query']['includeAll']?[{'all':!![]}]:undefined})[_0x2171('0x29')](function(_0x5a6624){var _0x35b41e=_0x5abf4d['user'][_0x2171('0x2b')]({'plain':!![]});if(!_0x35b41e)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x35b41e['role']===_0x2171('0x59')){var _0x3d5bb7=_0x5a6624[_0x2171('0x2b')]({'plain':!![]});var _0x1a01c4=[{'name':_0x2171('0x2c'),'value':_0x2171('0x2d')},{'name':'QueueCampaigns','value':'outbound'}];var _0xfc62f7=_[_0x2171('0x35')](_0x1a01c4,[_0x2171('0x32'),_0x3d5bb7[_0x2171('0x34')]])[_0x2171('0x36')];return db[_0x2171('0x5d')][_0x2171('0x35')]({'where':{'name':_0xfc62f7,'userProfileId':_0x35b41e[_0x2171('0x64')]},'raw':!![]})[_0x2171('0x29')](function(_0x140799){if(_0x140799&&_0x140799[_0x2171('0x5e')]===0x0){return db['UserProfileResource'][_0x2171('0x57')]({'name':_0x3d5bb7[_0x2171('0x36')],'resourceId':_0x3d5bb7['id'],'type':_0x140799[_0x2171('0x36')],'sectionId':_0x140799['id']},{})[_0x2171('0x29')](function(){return _0x5a6624;});}else{return _0x5a6624;}})[_0x2171('0x54')](function(_0x213c04){logger[_0x2171('0x39')](_0x2171('0x5f'),_0x213c04);throw _0x213c04;});}return _0x5a6624;});}})['then'](respondWithResult(_0x4ac3a9,0xc9))[_0x2171('0x54')](handleError(_0x4ac3a9,null));};exports[_0x2171('0x28')]=function(_0x5a28b6,_0x4ff9ff){if(_0x5a28b6[_0x2171('0x58')]['id']){delete _0x5a28b6[_0x2171('0x58')]['id'];}return db[_0x2171('0x3d')][_0x2171('0x35')]({'where':{'id':_0x5a28b6['params']['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x4ff9ff,null))[_0x2171('0x29')](saveUpdates(_0x5a28b6[_0x2171('0x58')],null))[_0x2171('0x29')](respondWithResult(_0x4ff9ff,null))[_0x2171('0x54')](handleError(_0x4ff9ff,null));};exports[_0x2171('0x2a')]=function(_0x569c82,_0x2b131){return db['VoiceQueue']['find']({'where':{'id':_0x569c82[_0x2171('0x55')]['id']}})['then'](handleEntityNotFound(_0x2b131,null))['then'](removeEntity(_0x2b131,null))[_0x2171('0x54')](handleError(_0x2b131,null));};exports[_0x2171('0x65')]=function(_0xabcb6f,_0x55320b,_0x659a26){var _0x4df87f={'raw':![],'where':{}};var _0x64c0fa={};var _0x4d949f={'count':0x0,'rows':[]};return db[_0x2171('0x3d')][_0x2171('0x66')]({'where':{'id':_0xabcb6f[_0x2171('0x55')]['id']}})['then'](handleEntityNotFound(_0x55320b,null))[_0x2171('0x29')](function(_0x345368){if(_0x345368){_0x64c0fa[_0x2171('0x40')]=_[_0x2171('0x42')](db[_0x2171('0x67')][_0x2171('0x3e')]);_0x64c0fa[_0x2171('0x41')]=_[_0x2171('0x42')](_0xabcb6f[_0x2171('0x41')]);_0x64c0fa[_0x2171('0x43')]=_['intersection'](_0x64c0fa['model'],_0x64c0fa[_0x2171('0x41')]);_0x4df87f[_0x2171('0x45')]=_[_0x2171('0x44')](_0x64c0fa[_0x2171('0x40')],qs[_0x2171('0x46')](_0xabcb6f['query']['fields']));_0x4df87f[_0x2171('0x45')]=_0x4df87f[_0x2171('0x45')][_0x2171('0x47')]?_0x4df87f[_0x2171('0x45')]:_0x64c0fa[_0x2171('0x40')];if(!_0xabcb6f[_0x2171('0x41')][_0x2171('0x48')](_0x2171('0x49'))){_0x4df87f['limit']=qs[_0x2171('0x22')](_0xabcb6f[_0x2171('0x41')][_0x2171('0x22')]);_0x4df87f['offset']=qs[_0x2171('0x21')](_0xabcb6f[_0x2171('0x41')]['offset']);}_0x4df87f[_0x2171('0x68')]=qs[_0x2171('0x4a')](_0xabcb6f['query'][_0x2171('0x4a')]);_0x4df87f[_0x2171('0x4c')]=qs[_0x2171('0x43')](_['pick'](_0xabcb6f[_0x2171('0x41')],_0x64c0fa[_0x2171('0x43')]));_0x4df87f[_0x2171('0x4c')][_0x2171('0x69')]=_0x345368['id'];if(_0xabcb6f[_0x2171('0x41')][_0x2171('0x2f')]){_0x4df87f[_0x2171('0x4c')]=_[_0x2171('0x4d')](_0x4df87f[_0x2171('0x4c')],{'$or':_[_0x2171('0x31')](_0x4df87f[_0x2171('0x45')],function(_0x14ecb8){var _0x5abbed={};_0x5abbed[_0x14ecb8]={'$like':'%'+_0xabcb6f[_0x2171('0x41')]['filter']+'%'};return _0x5abbed;})});}_0x4df87f=_['merge']({},_0x4df87f,_0xabcb6f[_0x2171('0x4f')]);return db['CmHopper']['count']({'where':_0x4df87f[_0x2171('0x4c')]})[_0x2171('0x29')](function(_0x33a358){_0x4d949f[_0x2171('0x50')]=_0x33a358;if(_0xabcb6f[_0x2171('0x41')][_0x2171('0x56')]){_0x4df87f[_0x2171('0x51')]=[{'all':!![]}];}return db[_0x2171('0x67')]['findAll'](_0x4df87f);})[_0x2171('0x29')](function(_0x2b057d){_0x4d949f[_0x2171('0x53')]=_0x2b057d;return _0x4d949f;});}})[_0x2171('0x29')](respondWithFilteredResult(_0x55320b,_0x4df87f))[_0x2171('0x54')](handleError(_0x55320b,null));};exports['getHopperHistories']=function(_0x55dbb9,_0x4ffb17,_0xed225a){var _0x3bdcf3={'raw':!![],'where':{}};var _0x5931e0={};var _0x1ad796={'count':0x0,'rows':[]};return db[_0x2171('0x3d')]['findOne']({'where':{'id':_0x55dbb9[_0x2171('0x55')]['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x4ffb17,null))[_0x2171('0x29')](function(_0x36e787){if(_0x36e787){_0x5931e0[_0x2171('0x40')]=_[_0x2171('0x42')](db[_0x2171('0x6a')][_0x2171('0x3e')]);_0x5931e0[_0x2171('0x41')]=_[_0x2171('0x42')](_0x55dbb9['query']);_0x5931e0[_0x2171('0x43')]=_[_0x2171('0x44')](_0x5931e0[_0x2171('0x40')],_0x5931e0[_0x2171('0x41')]);_0x3bdcf3[_0x2171('0x45')]=_[_0x2171('0x44')](_0x5931e0[_0x2171('0x40')],qs[_0x2171('0x46')](_0x55dbb9[_0x2171('0x41')]['fields']));_0x3bdcf3[_0x2171('0x45')]=_0x3bdcf3[_0x2171('0x45')][_0x2171('0x47')]?_0x3bdcf3[_0x2171('0x45')]:_0x5931e0[_0x2171('0x40')];if(!_0x55dbb9[_0x2171('0x41')][_0x2171('0x48')](_0x2171('0x49'))){_0x3bdcf3[_0x2171('0x22')]=qs[_0x2171('0x22')](_0x55dbb9[_0x2171('0x41')]['limit']);_0x3bdcf3[_0x2171('0x21')]=qs[_0x2171('0x21')](_0x55dbb9[_0x2171('0x41')][_0x2171('0x21')]);}_0x3bdcf3[_0x2171('0x68')]=qs['sort'](_0x55dbb9[_0x2171('0x41')][_0x2171('0x4a')]);_0x3bdcf3[_0x2171('0x4c')]=qs[_0x2171('0x43')](_[_0x2171('0x4b')](_0x55dbb9['query'],_0x5931e0['filters']));_0x3bdcf3['where']['VoiceQueueId']=_0x36e787['id'];if(_0x55dbb9['query'][_0x2171('0x2f')]){_0x3bdcf3[_0x2171('0x4c')]=_[_0x2171('0x4d')](_0x3bdcf3['where'],{'$or':_['map'](_0x3bdcf3[_0x2171('0x45')],function(_0x28eb83){var _0x385b22={};_0x385b22[_0x28eb83]={'$like':'%'+_0x55dbb9[_0x2171('0x41')][_0x2171('0x2f')]+'%'};return _0x385b22;})});}_0x3bdcf3=_[_0x2171('0x4d')]({},_0x3bdcf3,_0x55dbb9[_0x2171('0x4f')]);return db[_0x2171('0x6a')]['count']({'where':_0x3bdcf3[_0x2171('0x4c')]})[_0x2171('0x29')](function(_0x5a5564){_0x1ad796[_0x2171('0x50')]=_0x5a5564;if(_0x55dbb9[_0x2171('0x41')][_0x2171('0x56')]){_0x3bdcf3[_0x2171('0x51')]=[{'all':!![]}];}return db['CmHopperHistory'][_0x2171('0x52')](_0x3bdcf3);})[_0x2171('0x29')](function(_0x3f1fd3){_0x1ad796['rows']=_0x3f1fd3;return _0x1ad796;});}})['then'](respondWithFilteredResult(_0x4ffb17,_0x3bdcf3))[_0x2171('0x54')](handleError(_0x4ffb17,null));};exports[_0x2171('0x6b')]=function(_0x2c6cb2,_0x55ee0e,_0x36a252){var _0x34f784={'raw':!![],'where':{}};var _0x12ffe5={};var _0x54b587={'count':0x0,'rows':[]};return db[_0x2171('0x3d')]['findOne']({'where':{'id':_0x2c6cb2[_0x2171('0x55')]['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x55ee0e,null))['then'](function(_0x2ed589){if(_0x2ed589){_0x12ffe5[_0x2171('0x40')]=_['keys'](db[_0x2171('0x6c')][_0x2171('0x3e')]);_0x12ffe5[_0x2171('0x41')]=_['keys'](_0x2c6cb2['query']);_0x12ffe5[_0x2171('0x43')]=_[_0x2171('0x44')](_0x12ffe5[_0x2171('0x40')],_0x12ffe5[_0x2171('0x41')]);_0x34f784['attributes']=_[_0x2171('0x44')](_0x12ffe5[_0x2171('0x40')],qs[_0x2171('0x46')](_0x2c6cb2[_0x2171('0x41')]['fields']));_0x34f784['attributes']=_0x34f784[_0x2171('0x45')][_0x2171('0x47')]?_0x34f784['attributes']:_0x12ffe5[_0x2171('0x40')];if(!_0x2c6cb2[_0x2171('0x41')]['hasOwnProperty'](_0x2171('0x49'))){_0x34f784['limit']=qs[_0x2171('0x22')](_0x2c6cb2['query']['limit']);_0x34f784[_0x2171('0x21')]=qs[_0x2171('0x21')](_0x2c6cb2['query'][_0x2171('0x21')]);}_0x34f784[_0x2171('0x68')]=qs[_0x2171('0x4a')](_0x2c6cb2[_0x2171('0x41')]['sort']);_0x34f784[_0x2171('0x4c')]=qs[_0x2171('0x43')](_[_0x2171('0x4b')](_0x2c6cb2['query'],_0x12ffe5[_0x2171('0x43')]));_0x34f784[_0x2171('0x4c')][_0x2171('0x69')]=_0x2ed589['id'];if(_0x2c6cb2[_0x2171('0x41')][_0x2171('0x2f')]){_0x34f784[_0x2171('0x4c')]=_['merge'](_0x34f784[_0x2171('0x4c')],{'$or':_['map'](_0x34f784[_0x2171('0x45')],function(_0x2bb893){var _0x2b23a8={};_0x2b23a8[_0x2bb893]={'$like':'%'+_0x2c6cb2['query'][_0x2171('0x2f')]+'%'};return _0x2b23a8;})});}_0x34f784=_[_0x2171('0x4d')]({},_0x34f784,_0x2c6cb2['options']);return db[_0x2171('0x6c')]['count']({'where':_0x34f784[_0x2171('0x4c')]})['then'](function(_0x59d1cc){_0x54b587['count']=_0x59d1cc;if(_0x2c6cb2[_0x2171('0x41')][_0x2171('0x56')]){_0x34f784[_0x2171('0x51')]=[{'all':!![]}];}return db[_0x2171('0x6c')][_0x2171('0x52')](_0x34f784);})[_0x2171('0x29')](function(_0x27772d){_0x54b587[_0x2171('0x53')]=_0x27772d;return _0x54b587;});}})[_0x2171('0x29')](respondWithFilteredResult(_0x55ee0e,_0x34f784))[_0x2171('0x54')](handleError(_0x55ee0e,null));};exports['getHopperBlacks']=function(_0x1dcce8,_0x574f64,_0x4647b0){var _0x53ea1f={'raw':!![],'where':{}};var _0x2f9f32={};var _0x12edde={'count':0x0,'rows':[]};return db[_0x2171('0x3d')][_0x2171('0x66')]({'where':{'id':_0x1dcce8[_0x2171('0x55')]['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x574f64,null))['then'](function(_0x918684){if(_0x918684){_0x2f9f32[_0x2171('0x40')]=_[_0x2171('0x42')](db[_0x2171('0x6d')][_0x2171('0x3e')]);_0x2f9f32['query']=_[_0x2171('0x42')](_0x1dcce8['query']);_0x2f9f32['filters']=_['intersection'](_0x2f9f32['model'],_0x2f9f32['query']);_0x53ea1f[_0x2171('0x45')]=_[_0x2171('0x44')](_0x2f9f32[_0x2171('0x40')],qs[_0x2171('0x46')](_0x1dcce8[_0x2171('0x41')][_0x2171('0x46')]));_0x53ea1f['attributes']=_0x53ea1f[_0x2171('0x45')][_0x2171('0x47')]?_0x53ea1f[_0x2171('0x45')]:_0x2f9f32[_0x2171('0x40')];if(!_0x1dcce8[_0x2171('0x41')][_0x2171('0x48')](_0x2171('0x49'))){_0x53ea1f[_0x2171('0x22')]=qs[_0x2171('0x22')](_0x1dcce8[_0x2171('0x41')]['limit']);_0x53ea1f[_0x2171('0x21')]=qs[_0x2171('0x21')](_0x1dcce8[_0x2171('0x41')]['offset']);}_0x53ea1f[_0x2171('0x68')]=qs[_0x2171('0x4a')](_0x1dcce8['query'][_0x2171('0x4a')]);_0x53ea1f[_0x2171('0x4c')]=qs[_0x2171('0x43')](_[_0x2171('0x4b')](_0x1dcce8[_0x2171('0x41')],_0x2f9f32['filters']));_0x53ea1f['where'][_0x2171('0x69')]=_0x918684['id'];if(_0x1dcce8['query']['filter']){_0x53ea1f[_0x2171('0x4c')]=_[_0x2171('0x4d')](_0x53ea1f[_0x2171('0x4c')],{'$or':_[_0x2171('0x31')](_0x53ea1f[_0x2171('0x45')],function(_0x1415ea){var _0x38e8b1={};_0x38e8b1[_0x1415ea]={'$like':'%'+_0x1dcce8[_0x2171('0x41')]['filter']+'%'};return _0x38e8b1;})});}_0x53ea1f=_[_0x2171('0x4d')]({},_0x53ea1f,_0x1dcce8[_0x2171('0x4f')]);return db['CmHopperBlack']['count']({'where':_0x53ea1f[_0x2171('0x4c')]})['then'](function(_0x45c3ec){_0x12edde[_0x2171('0x50')]=_0x45c3ec;if(_0x1dcce8[_0x2171('0x41')]['includeAll']){_0x53ea1f['include']=[{'all':!![]}];}return db[_0x2171('0x6d')][_0x2171('0x52')](_0x53ea1f);})[_0x2171('0x29')](function(_0x17260f){_0x12edde[_0x2171('0x53')]=_0x17260f;return _0x12edde;});}})[_0x2171('0x29')](respondWithFilteredResult(_0x574f64,_0x53ea1f))[_0x2171('0x54')](handleError(_0x574f64,null));};exports[_0x2171('0x6e')]=function(_0x1f76b2,_0x3f9756,_0x3aa3ef){var _0x4fab8c={};var _0x46be2c={};var _0x3f6958;var _0xf99102;return db[_0x2171('0x3d')][_0x2171('0x66')]({'where':{'id':_0x1f76b2['params']['id']}})['then'](handleEntityNotFound(_0x3f9756,null))[_0x2171('0x29')](function(_0x53d26a){if(_0x53d26a){_0x3f6958=_0x53d26a;_0x46be2c['model']=_[_0x2171('0x42')](db[_0x2171('0x6f')][_0x2171('0x3e')]);_0x46be2c[_0x2171('0x41')]=_['keys'](_0x1f76b2['query']);_0x46be2c['filters']=_[_0x2171('0x44')](_0x46be2c[_0x2171('0x40')],_0x46be2c['query']);_0x4fab8c[_0x2171('0x45')]=_[_0x2171('0x44')](_0x46be2c[_0x2171('0x40')],qs[_0x2171('0x46')](_0x1f76b2[_0x2171('0x41')][_0x2171('0x46')]));_0x4fab8c[_0x2171('0x45')]=_0x4fab8c['attributes'][_0x2171('0x47')]?_0x4fab8c['attributes']:_0x46be2c[_0x2171('0x40')];_0x4fab8c[_0x2171('0x68')]=qs[_0x2171('0x4a')](_0x1f76b2['query'][_0x2171('0x4a')]);_0x4fab8c['where']=qs[_0x2171('0x43')](_[_0x2171('0x4b')](_0x1f76b2[_0x2171('0x41')],_0x46be2c[_0x2171('0x43')]));if(_0x1f76b2[_0x2171('0x41')][_0x2171('0x2f')]){_0x4fab8c[_0x2171('0x4c')]=_[_0x2171('0x4d')](_0x4fab8c[_0x2171('0x4c')],{'$or':_['map'](_0x4fab8c[_0x2171('0x45')],function(_0x123319){var _0x33ad66={};_0x33ad66[_0x123319]={'$like':'%'+_0x1f76b2[_0x2171('0x41')][_0x2171('0x2f')]+'%'};return _0x33ad66;})});}_0x4fab8c=_[_0x2171('0x4d')]({},_0x4fab8c,_0x1f76b2[_0x2171('0x4f')]);return _0x3f6958[_0x2171('0x6e')](_0x4fab8c);}})['then'](function(_0x5545da){if(_0x5545da){_0xf99102=_0x5545da[_0x2171('0x47')];if(!_0x1f76b2['query'][_0x2171('0x48')](_0x2171('0x49'))){_0x4fab8c['limit']=qs[_0x2171('0x22')](_0x1f76b2[_0x2171('0x41')][_0x2171('0x22')]);_0x4fab8c['offset']=qs[_0x2171('0x21')](_0x1f76b2[_0x2171('0x41')]['offset']);}return _0x3f6958[_0x2171('0x6e')](_0x4fab8c);}})[_0x2171('0x29')](function(_0x364d11){if(_0x364d11){return _0x364d11?{'count':_0xf99102,'rows':_0x364d11}:null;}})[_0x2171('0x29')](respondWithResult(_0x3f9756,null))['catch'](handleError(_0x3f9756,null));};exports['addTeams']=function(_0xacb449,_0x581c62,_0x18e61c){var _0x58f41b=_0xacb449['body'][_0x2171('0x70')];var _0x10f2a1=_[_0x2171('0x31')](_0x58f41b,'id');return db[_0x2171('0x6f')][_0x2171('0x52')]({'where':{'id':_0x10f2a1},'attributes':['id'],'include':[{'model':db[_0x2171('0x71')],'as':'Agents','attributes':['id','name',_0x2171('0x72'),_0x2171('0x73'),_0x2171('0x74')],'raw':!![]}]})[_0x2171('0x29')](function(_0x3435a6){if(_0x3435a6){var _0x2ab428=_['flatMap'](_0x3435a6,function(_0x181b8d){var _0x26248b=_0x181b8d[_0x2171('0x2b')]({'plain':!![]});_0x26248b[_0x2171('0x75')][_0x2171('0x76')](function(_0x5c84a0){_0x5c84a0[_0x2171('0x77')]=_[_0x2171('0x35')](_0x58f41b,{'id':_0x26248b['id']})[_0x2171('0x77')];});return _0x26248b[_0x2171('0x75')];});return db['VoiceQueue'][_0x2171('0x35')]({'where':{'id':_0xacb449[_0x2171('0x55')]['id']}})[_0x2171('0x29')](function(_0x15daf0){return db[_0x2171('0x78')][_0x2171('0x79')](function(_0x4ddd48){return _0x15daf0['addTeams'](_0x10f2a1,{'transaction':_0x4ddd48})['then'](function(){return BPromise['each'](_0x58f41b,function(_0x4afbaf){return db['TeamVoiceQueue'][_0x2171('0x7a')]({'TeamId':_0x4afbaf['id'],'VoiceQueueId':_0xacb449['params']['id'],'penalty':_0x4afbaf[_0x2171('0x77')]},{'transaction':_0x4ddd48});});})[_0x2171('0x29')](function(){return BPromise[_0x2171('0x7b')](_0x2ab428,function(_0x5e6c81){return db[_0x2171('0x7c')]['findOrCreate']({'where':{'UserId':_0x5e6c81['id'],'VoiceQueueId':_0xacb449['params']['id']},'defaults':{'penalty':_0x5e6c81[_0x2171('0x77')]},'transaction':_0x4ddd48});});})[_0x2171('0x29')](function(){return BPromise[_0x2171('0x7b')](_[_0x2171('0x2f')](_0x2ab428,{'online':!![]}),function(_0x281be5){return db[_0x2171('0x7d')]['upsert']({'membername':_0x281be5['name'],'UserId':_0x281be5['id'],'queue_name':_0x15daf0[_0x2171('0x36')],'VoiceQueueId':_0x15daf0['id'],'interface':_[_0x2171('0x7e')](_0x281be5[_0x2171('0x74')])?util['format'](_0x2171('0x7f'),_0x281be5[_0x2171('0x36')]):_0x281be5[_0x2171('0x74')],'paused':_0x281be5['voicePause']||![],'penalty':_0x281be5['penalty']},{'transaction':_0x4ddd48});});})['then'](function(){_0x2ab428[_0x2171('0x76')](function(_0x5e2481){socket['emit'](_0x2171('0x80'),{'UserId':_0x5e2481['id'],'VoiceQueueId':_0x15daf0['id']});});});});});}})[_0x2171('0x29')](respondWithStatusCode(_0x581c62,null))[_0x2171('0x54')](handleError(_0x581c62,null));};exports['removeTeams']=function(_0x55ca90,_0x529d46,_0xeb9676){return db['Team'][_0x2171('0x52')]({'where':{'id':_0x55ca90['query']['ids']},'attributes':['id'],'include':[{'model':db[_0x2171('0x71')],'as':_0x2171('0x75'),'attributes':['id'],'raw':!![]}]})[_0x2171('0x29')](handleEntityNotFound(_0x529d46,null))[_0x2171('0x29')](function(_0x4da6e4){var _0xfbac09=_[_0x2171('0x31')](_0x4da6e4,'id');var _0x2cf00f=[];var _0x3334fc=[];var _0x3a5a43=squel['select']();_0x3a5a43[_0x2171('0x81')](_0x2171('0x82'))[_0x2171('0x83')](_0x2171('0x84'),'tq')[_0x2171('0x85')]('user_has_teams','ut','ut.TeamId\x20=\x20tq.TeamId')['where'](_0x2171('0x86'),_0x55ca90['params']['id']);for(var _0x460cbe=0x0;_0x460cbe<_0x4da6e4[_0x2171('0x47')];_0x460cbe+=0x1){let _0x61785e=_0x4da6e4[_0x460cbe];for(var _0x257372=0x0;_0x257372<_0x61785e[_0x2171('0x75')][_0x2171('0x47')];_0x257372+=0x1){let _0x9bffe9=_0x61785e[_0x2171('0x75')][_0x257372];var _0x523efd=_0x3a5a43[_0x2171('0x60')]();_0x523efd[_0x2171('0x4c')]('ut.UserId\x20=\x20?',_0x9bffe9['id']);_0x3334fc[_0x2171('0x87')](db['sequelize'][_0x2171('0x41')](_0x523efd[_0x2171('0x88')](),{'type':db[_0x2171('0x78')][_0x2171('0x89')][_0x2171('0x8a')]})['then'](function(_0x2b5c8c){if(_0x2b5c8c[_0x2171('0x47')]===0x1){return _0x9bffe9['id'];}else{var _0xd6b88c=_[_0x2171('0x8b')](_[_0x2171('0x31')](_0x2b5c8c,_0x2171('0x8c')),function(_0x9a6292){return _[_0x2171('0x33')](_0xfbac09,_0x9a6292);});if(_0xd6b88c){return _0x9bffe9['id'];}}}));}}return BPromise[_0x2171('0x8d')](_0x3334fc)[_0x2171('0x29')](function(_0x501a75){_0x2cf00f=_(_0x2cf00f)[_0x2171('0x8e')](_0x501a75)[_0x2171('0x8f')]()[_0x2171('0x32')]();return db[_0x2171('0x3d')][_0x2171('0x35')]({'where':{'id':_0x55ca90[_0x2171('0x55')]['id']}})[_0x2171('0x29')](function(_0x49708c){return db[_0x2171('0x78')][_0x2171('0x79')](function(_0x4bb735){return _0x49708c[_0x2171('0x90')](_0x55ca90[_0x2171('0x41')][_0x2171('0x91')],{'transaction':_0x4bb735})[_0x2171('0x29')](function(){if(!_[_0x2171('0x92')](_0x2cf00f)){return _0x49708c[_0x2171('0x93')](_0x2cf00f,{'transaction':_0x4bb735})[_0x2171('0x29')](function(){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x55ca90[_0x2171('0x55')]['id'],'UserId':_0x2cf00f},'transaction':_0x4bb735});});}})[_0x2171('0x29')](function(){_0x2cf00f[_0x2171('0x76')](function(_0x402afe){socket[_0x2171('0x94')](_0x2171('0x95'),{'UserId':_0x402afe,'VoiceQueueId':_0x49708c['id']});});});});});});})[_0x2171('0x29')](respondWithStatusCode(_0x529d46,null))[_0x2171('0x54')](handleError(_0x529d46,null));};exports[_0x2171('0x96')]=function(_0x17c172,_0x1ccd5c,_0x13abe9){var _0x1112d7,_0x244a23;return db[_0x2171('0x3d')]['find']({'where':{'id':_0x17c172[_0x2171('0x55')]['id']}})['then'](handleEntityNotFound(_0x1ccd5c,null))[_0x2171('0x29')](function(_0x3b9dae){if(_0x3b9dae){_0x244a23=_0x3b9dae;return _0x3b9dae['addAgents'](_0x17c172[_0x2171('0x58')][_0x2171('0x91')],_[_0x2171('0x61')](_0x17c172['body'],[_0x2171('0x91'),'id'])||{})['spread'](function(_0x54a0d7){for(var _0x413512=0x0;_0x413512<_0x17c172['body'][_0x2171('0x91')]['length'];_0x413512+=0x1){socket['emit'](_0x2171('0x80'),{'UserId':_0x17c172[_0x2171('0x58')][_0x2171('0x91')][_0x413512],'VoiceQueueId':_0x17c172[_0x2171('0x55')]['id']});}return _0x54a0d7;});}})[_0x2171('0x29')](function(_0x4c4e9a){_0x1112d7=_0x4c4e9a||[];if(_0x244a23){return db[_0x2171('0x71')][_0x2171('0x52')]({'where':{'id':_0x17c172[_0x2171('0x58')]['ids']},'attributes':['id',_0x2171('0x36'),_0x2171('0x72'),_0x2171('0x73'),'interface'],'raw':!![]});}})[_0x2171('0x29')](function(_0x5a043d){if(!_[_0x2171('0x92')](_0x5a043d)){var _0x13809d=[];for(var _0x2009ab=0x0;_0x2009ab<_0x5a043d[_0x2171('0x47')];_0x2009ab++){if(_0x5a043d[_0x2009ab][_0x2171('0x72')]){_0x13809d['push'](db['UserVoiceQueueRt'][_0x2171('0x7a')]({'membername':_0x5a043d[_0x2009ab][_0x2171('0x36')],'UserId':_0x5a043d[_0x2009ab]['id'],'queue_name':_0x244a23[_0x2171('0x36')],'VoiceQueueId':_0x244a23['id'],'interface':_[_0x2171('0x7e')](_0x5a043d[_0x2009ab][_0x2171('0x74')])?util[_0x2171('0x97')]('SIP/%s',_0x5a043d[_0x2009ab][_0x2171('0x36')]):_0x5a043d[_0x2009ab][_0x2171('0x74')],'paused':_0x5a043d[_0x2009ab][_0x2171('0x73')]||![],'penalty':_0x17c172[_0x2171('0x58')][_0x2171('0x77')]||0x0}));}}return BPromise[_0x2171('0x8d')](_0x13809d);}})[_0x2171('0x29')](function(){return _0x1112d7;})[_0x2171('0x29')](respondWithResult(_0x1ccd5c,null))[_0x2171('0x54')](handleError(_0x1ccd5c,null));};exports[_0x2171('0x93')]=function(_0x430f3e,_0x27ec58,_0x37ef71){return db['VoiceQueue'][_0x2171('0x35')]({'where':{'id':_0x430f3e[_0x2171('0x55')]['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x27ec58,null))[_0x2171('0x29')](function(_0x1e826d){if(_0x1e826d){return _0x1e826d[_0x2171('0x93')](_0x430f3e['query'][_0x2171('0x91')])[_0x2171('0x29')](function(){if(_[_0x2171('0x98')](_0x430f3e[_0x2171('0x41')][_0x2171('0x91')])){for(var _0x2add97=0x0;_0x2add97<_0x430f3e[_0x2171('0x41')][_0x2171('0x91')]['length'];_0x2add97+=0x1){socket[_0x2171('0x94')]('userVoiceQueue:remove',{'UserId':Number(_0x430f3e[_0x2171('0x41')][_0x2171('0x91')][_0x2add97]),'VoiceQueueId':Number(_0x430f3e[_0x2171('0x55')]['id'])});}}else{socket[_0x2171('0x94')](_0x2171('0x95'),{'UserId':Number(_0x430f3e[_0x2171('0x41')][_0x2171('0x91')]),'VoiceQueueId':Number(_0x430f3e['params']['id'])});}});}})[_0x2171('0x29')](function(_0x1ae0e4){return db[_0x2171('0x7d')][_0x2171('0x2a')]({'where':{'VoiceQueueId':_0x430f3e[_0x2171('0x55')]['id'],'UserId':_0x430f3e[_0x2171('0x41')][_0x2171('0x91')]}})[_0x2171('0x29')](function(){return _0x1ae0e4;});})[_0x2171('0x29')](respondWithStatusCode(_0x27ec58,null))[_0x2171('0x54')](handleError(_0x27ec58,null));};exports[_0x2171('0x99')]=function(_0x3aa11a,_0x5da6b6,_0x2f667c){var _0x5bd458={};var _0x14eeb1={};var _0x5d5ea0;var _0x4ebea1;return db['VoiceQueue'][_0x2171('0x66')]({'where':{'id':_0x3aa11a[_0x2171('0x55')]['id']}})['then'](handleEntityNotFound(_0x5da6b6,null))['then'](function(_0x21e147){if(_0x21e147){_0x5d5ea0=_0x21e147;_0x14eeb1['model']=_[_0x2171('0x42')](db[_0x2171('0x71')][_0x2171('0x3e')]);_0x14eeb1[_0x2171('0x41')]=_[_0x2171('0x42')](_0x3aa11a[_0x2171('0x41')]);_0x14eeb1[_0x2171('0x43')]=_[_0x2171('0x44')](_0x14eeb1['model'],_0x14eeb1[_0x2171('0x41')]);_0x5bd458['attributes']=_['intersection'](_0x14eeb1[_0x2171('0x40')],qs[_0x2171('0x46')](_0x3aa11a[_0x2171('0x41')][_0x2171('0x46')]));_0x5bd458['attributes']=_0x5bd458[_0x2171('0x45')][_0x2171('0x47')]?_0x5bd458[_0x2171('0x45')]:_0x14eeb1[_0x2171('0x40')];_0x5bd458[_0x2171('0x68')]=qs[_0x2171('0x4a')](_0x3aa11a[_0x2171('0x41')][_0x2171('0x4a')]);_0x5bd458[_0x2171('0x4c')]=qs['filters'](_[_0x2171('0x4b')](_0x3aa11a['query'],_0x14eeb1[_0x2171('0x43')]));if(_0x3aa11a[_0x2171('0x41')][_0x2171('0x2f')]){_0x5bd458['where']=_[_0x2171('0x4d')](_0x5bd458[_0x2171('0x4c')],{'$or':_[_0x2171('0x31')](_0x5bd458[_0x2171('0x45')],function(_0x5af8af){var _0x28caf8={};_0x28caf8[_0x5af8af]={'$like':'%'+_0x3aa11a[_0x2171('0x41')][_0x2171('0x2f')]+'%'};return _0x28caf8;})});}_0x5bd458=_[_0x2171('0x4d')]({},_0x5bd458,_0x3aa11a[_0x2171('0x4f')]);return _0x5d5ea0[_0x2171('0x99')](_0x5bd458);}})['then'](function(_0x4e1e51){if(_0x4e1e51){_0x4ebea1=_0x4e1e51['length'];if(!_0x3aa11a['query'][_0x2171('0x48')]('nolimit')){_0x5bd458[_0x2171('0x22')]=qs[_0x2171('0x22')](_0x3aa11a[_0x2171('0x41')]['limit']);_0x5bd458['offset']=qs[_0x2171('0x21')](_0x3aa11a[_0x2171('0x41')][_0x2171('0x21')]);}return _0x5d5ea0[_0x2171('0x99')](_0x5bd458);}})[_0x2171('0x29')](function(_0x15efd0){if(_0x15efd0){return _0x15efd0?{'count':_0x4ebea1,'rows':_0x15efd0}:null;}})[_0x2171('0x29')](respondWithResult(_0x5da6b6,null))[_0x2171('0x54')](handleError(_0x5da6b6,null));};exports[_0x2171('0x9a')]=function(_0x214a60,_0x484f8b,_0x37909c){var _0x4baf83={};var _0x576953={};var _0x4b9a72;var _0x56a279;return db[_0x2171('0x3d')]['findOne']({'where':{'id':_0x214a60[_0x2171('0x55')]['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x484f8b,null))['then'](function(_0x3e8efa){if(_0x3e8efa){_0x4b9a72=_0x3e8efa;_0x576953[_0x2171('0x40')]=_[_0x2171('0x42')](db[_0x2171('0x7d')][_0x2171('0x3e')]);_0x576953[_0x2171('0x41')]=_[_0x2171('0x42')](_0x214a60[_0x2171('0x41')]);_0x576953['filters']=_[_0x2171('0x44')](_0x576953[_0x2171('0x40')],_0x576953[_0x2171('0x41')]);_0x4baf83[_0x2171('0x45')]=_[_0x2171('0x44')](_0x576953[_0x2171('0x40')],qs[_0x2171('0x46')](_0x214a60[_0x2171('0x41')]['fields']));_0x4baf83[_0x2171('0x45')]=_0x4baf83[_0x2171('0x45')][_0x2171('0x47')]?_0x4baf83[_0x2171('0x45')]:_0x576953[_0x2171('0x40')];_0x4baf83['order']=qs[_0x2171('0x4a')](_0x214a60[_0x2171('0x41')][_0x2171('0x4a')]);_0x4baf83[_0x2171('0x4c')]=qs[_0x2171('0x43')](_[_0x2171('0x4b')](_0x214a60[_0x2171('0x41')],_0x576953[_0x2171('0x43')]));if(_0x214a60[_0x2171('0x41')]['filter']){_0x4baf83[_0x2171('0x4c')]=_[_0x2171('0x4d')](_0x4baf83[_0x2171('0x4c')],{'$or':_[_0x2171('0x31')](_0x4baf83[_0x2171('0x45')],function(_0x1f3b98){var _0x5ac37d={};_0x5ac37d[_0x1f3b98]={'$like':'%'+_0x214a60[_0x2171('0x41')][_0x2171('0x2f')]+'%'};return _0x5ac37d;})});}_0x4baf83=_[_0x2171('0x4d')]({},_0x4baf83,_0x214a60[_0x2171('0x4f')]);return _0x4b9a72[_0x2171('0x9a')](_0x4baf83);}})['then'](function(_0x1eb8a6){if(_0x1eb8a6){_0x56a279=_0x1eb8a6[_0x2171('0x47')];if(!_0x214a60[_0x2171('0x41')][_0x2171('0x48')](_0x2171('0x49'))){_0x4baf83[_0x2171('0x22')]=qs[_0x2171('0x22')](_0x214a60[_0x2171('0x41')][_0x2171('0x22')]);_0x4baf83[_0x2171('0x21')]=qs[_0x2171('0x21')](_0x214a60[_0x2171('0x41')][_0x2171('0x21')]);}return _0x4b9a72[_0x2171('0x9a')](_0x4baf83);}})['then'](function(_0x231fa7){return _0x231fa7?{'count':_0x56a279,'rows':_0x231fa7}:null;})[_0x2171('0x29')](respondWithResult(_0x484f8b,null))[_0x2171('0x54')](handleError(_0x484f8b,null));};exports[_0x2171('0x9b')]=function(_0x19ae4c,_0x4728f7,_0x24e4d3){var _0x589a8d={};var _0x47a6eb={};var _0x25cec5;var _0x2e64de;return db[_0x2171('0x3d')][_0x2171('0x66')]({'where':{'id':_0x19ae4c['params']['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x4728f7,null))[_0x2171('0x29')](function(_0x547993){if(_0x547993){_0x25cec5=_0x547993;_0x47a6eb[_0x2171('0x40')]=_[_0x2171('0x42')](db[_0x2171('0x9c')][_0x2171('0x3e')]);_0x47a6eb[_0x2171('0x41')]=_[_0x2171('0x42')](_0x19ae4c['query']);_0x47a6eb[_0x2171('0x43')]=_['intersection'](_0x47a6eb[_0x2171('0x40')],_0x47a6eb[_0x2171('0x41')]);_0x589a8d['attributes']=_['intersection'](_0x47a6eb[_0x2171('0x40')],qs[_0x2171('0x46')](_0x19ae4c['query'][_0x2171('0x46')]));_0x589a8d[_0x2171('0x45')]=_0x589a8d[_0x2171('0x45')][_0x2171('0x47')]?_0x589a8d['attributes']:_0x47a6eb[_0x2171('0x40')];_0x589a8d[_0x2171('0x68')]=qs[_0x2171('0x4a')](_0x19ae4c[_0x2171('0x41')][_0x2171('0x4a')]);_0x589a8d[_0x2171('0x4c')]=qs['filters'](_[_0x2171('0x4b')](_0x19ae4c['query'],_0x47a6eb[_0x2171('0x43')]));if(_0x19ae4c[_0x2171('0x41')][_0x2171('0x2f')]){_0x589a8d[_0x2171('0x4c')]=_[_0x2171('0x4d')](_0x589a8d['where'],{'$or':_[_0x2171('0x31')](_0x589a8d[_0x2171('0x45')],function(_0x211a9b){var _0x39ac9e={};_0x39ac9e[_0x211a9b]={'$like':'%'+_0x19ae4c[_0x2171('0x41')][_0x2171('0x2f')]+'%'};return _0x39ac9e;})});}_0x589a8d=_[_0x2171('0x4d')]({},_0x589a8d,_0x19ae4c[_0x2171('0x4f')]);return _0x25cec5['getLists'](_0x589a8d);}})['then'](function(_0x10e989){if(_0x10e989){_0x2e64de=_0x10e989[_0x2171('0x47')];if(!_0x19ae4c[_0x2171('0x41')][_0x2171('0x48')](_0x2171('0x49'))){_0x589a8d[_0x2171('0x22')]=qs['limit'](_0x19ae4c[_0x2171('0x41')][_0x2171('0x22')]);_0x589a8d['offset']=qs['offset'](_0x19ae4c[_0x2171('0x41')][_0x2171('0x21')]);}return _0x25cec5[_0x2171('0x9b')](_0x589a8d);}})[_0x2171('0x29')](function(_0x93ab9a){if(_0x93ab9a){return _0x93ab9a?{'count':_0x2e64de,'rows':_0x93ab9a}:null;}})['then'](respondWithResult(_0x4728f7,null))[_0x2171('0x54')](handleError(_0x4728f7,null));};exports[_0x2171('0x9d')]=function(_0x2153c9,_0x235f26,_0x46e4f1){var _0xb4ebcf,_0x3a66f6;return db[_0x2171('0x3d')][_0x2171('0x35')]({'where':{'id':_0x2153c9['params']['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x235f26,null))[_0x2171('0x29')](function(_0xb6871c){if(_0xb6871c){_0x3a66f6=_0xb6871c;return _0xb6871c['addLists'](_0x2153c9[_0x2171('0x58')][_0x2171('0x91')],_[_0x2171('0x61')](_0x2153c9[_0x2171('0x58')],[_0x2171('0x91'),'id'])||{});}return null;})[_0x2171('0x9e')](function(_0x50ce71){var _0xb252f5;_0xb4ebcf=_0x50ce71||[];var _0x32e033=[];if(_0x50ce71){for(var _0x172d9a=0x0;_0x172d9a<_0x50ce71[_0x2171('0x47')];_0x172d9a+=0x1){var _0x27db94=_0x50ce71[_0x172d9a][_0x2171('0x2b')]({'plain':!![]});_0x3a66f6[_0x2171('0x9f')]=_0x2153c9[_0x2171('0x58')]['dialCheckDuplicateType']?_0x2153c9['body']['dialCheckDuplicateType']:_0x3a66f6['dialCheckDuplicateType'];switch(_0x3a66f6['dialCheckDuplicateType']){case'always':_0xb252f5=squel[_0x2171('0xa0')]()[_0x2171('0xa1')](_0x2171('0xa2'))[_0x2171('0xa3')](['phone',_0x2171('0xa4'),_0x2171('0xa5'),_0x2171('0xa6'),_0x2171('0x69'),'createdAt',_0x2171('0x63')],squel[_0x2171('0xa7')]()[_0x2171('0x81')](_0x2171('0xa8'),_0x2171('0xa8'))[_0x2171('0x81')](_0x2171('0xa9'),_0x2171('0xa4'))[_0x2171('0x81')]('id','ContactId')[_0x2171('0x81')](_0x27db94[_0x2171('0xaa')][_0x2171('0x88')](),_0x2171('0xa6'))[_0x2171('0x81')](_0x2153c9[_0x2171('0x55')]['id'][_0x2171('0x88')](),_0x2171('0x69'))[_0x2171('0x81')](_0x2171('0xa9'),_0x2171('0x62'))['field'](_0x2171('0xa9'),_0x2171('0x63'))[_0x2171('0x83')]('cm_contacts')[_0x2171('0x4c')](_0x2171('0xab'))[_0x2171('0x4c')](_0x2171('0xac'),_0x27db94[_0x2171('0xaa')][_0x2171('0x88')]())[_0x2171('0x4c')](_0x2171('0xad'))[_0x2171('0x4c')](_0x2171('0xae'),squel['select']()[_0x2171('0x81')](_0x2171('0xaf'))[_0x2171('0x83')]('cm_hopper_final')[_0x2171('0x4c')](_0x2171('0x86'),_0x2153c9[_0x2171('0x55')]['id'][_0x2171('0x88')]()))[_0x2171('0x4c')](_0x2171('0xae'),squel[_0x2171('0xa7')]()[_0x2171('0x81')](_0x2171('0xb0'))[_0x2171('0x83')]('cm_hopper')[_0x2171('0x4c')]('VoiceQueueId\x20=\x20?',_0x2153c9[_0x2171('0x55')]['id'][_0x2171('0x88')]())))[_0x2171('0x88')]();break;case _0x2171('0xb1'):_0xb252f5=squel['insert']()['into']('cm_hopper')[_0x2171('0xa3')]([_0x2171('0xa8'),_0x2171('0xa4'),_0x2171('0xa5'),_0x2171('0xa6'),_0x2171('0x69'),'createdAt','updatedAt'],squel[_0x2171('0xa7')]()[_0x2171('0x81')]('phone',_0x2171('0xa8'))[_0x2171('0x81')](_0x2171('0xa9'),_0x2171('0xa4'))[_0x2171('0x81')]('id',_0x2171('0xa5'))['field'](_0x27db94[_0x2171('0xaa')][_0x2171('0x88')](),_0x2171('0xa6'))[_0x2171('0x81')](_0x2153c9[_0x2171('0x55')]['id']['toString'](),_0x2171('0x69'))[_0x2171('0x81')](_0x2171('0xa9'),_0x2171('0x62'))['field']('NOW()',_0x2171('0x63'))['from'](_0x2171('0xb2'))[_0x2171('0x4c')](_0x2171('0xab'))[_0x2171('0x4c')](_0x2171('0xac'),_0x27db94[_0x2171('0xaa')][_0x2171('0x88')]())[_0x2171('0x4c')]('phone\x20IS\x20NOT\x20NULL')[_0x2171('0x4c')](_0x2171('0xae'),squel[_0x2171('0xa7')]()[_0x2171('0x81')](_0x2171('0xb0'))[_0x2171('0x83')](_0x2171('0xa2'))[_0x2171('0x4c')](_0x2171('0x86'),_0x2153c9[_0x2171('0x55')]['id'][_0x2171('0x88')]())))[_0x2171('0x88')]();break;default:_0xb252f5=squel['insert']()[_0x2171('0xa1')]('cm_hopper')[_0x2171('0xa3')]([_0x2171('0xa8'),_0x2171('0xa4'),_0x2171('0xa5'),_0x2171('0xa6'),_0x2171('0x69'),_0x2171('0x62'),_0x2171('0x63')],squel['select']()[_0x2171('0x81')](_0x2171('0xa8'),_0x2171('0xa8'))[_0x2171('0x81')](_0x2171('0xa9'),_0x2171('0xa4'))['field']('id',_0x2171('0xa5'))['field'](_0x27db94['CmListId'][_0x2171('0x88')](),_0x2171('0xa6'))['field'](_0x2153c9[_0x2171('0x55')]['id'][_0x2171('0x88')](),_0x2171('0x69'))['field'](_0x2171('0xa9'),_0x2171('0x62'))['field']('NOW()',_0x2171('0x63'))[_0x2171('0x83')](_0x2171('0xb2'))['where'](_0x2171('0xab'))[_0x2171('0x4c')]('ListId\x20=\x20?',_0x27db94['CmListId'][_0x2171('0x88')]())['where']('phone\x20IS\x20NOT\x20NULL'))['toString']();}_0x32e033[_0x2171('0x87')](db[_0x2171('0x78')][_0x2171('0x41')](_0xb252f5));}return BPromise[_0x2171('0x8d')](_0x32e033);}})['then'](function(){return _0xb4ebcf;})['then'](respondWithResult(_0x235f26,null))[_0x2171('0x54')](handleError(_0x235f26,null));};exports[_0x2171('0xb3')]=function(_0x4b11e5,_0x4e5f96,_0x4920b8){return db[_0x2171('0x3d')]['find']({'where':{'id':_0x4b11e5['params']['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x4e5f96,null))[_0x2171('0x29')](function(_0x2d9f12){if(_0x2d9f12){return _0x2d9f12[_0x2171('0xb3')](_0x4b11e5['query'][_0x2171('0x91')]);}})[_0x2171('0x29')](function(_0xe33377){if(_0xe33377){return db[_0x2171('0x67')][_0x2171('0x2a')]({'where':{'ListId':_0x4b11e5['query'][_0x2171('0x91')],'VoiceQueueId':_0x4b11e5[_0x2171('0x55')]['id']}})[_0x2171('0x29')](function(){return _0xe33377;});}})[_0x2171('0x29')](respondWithStatusCode(_0x4e5f96,null))['catch'](handleError(_0x4e5f96,null));};exports[_0x2171('0xb4')]=function(_0x531fc5,_0x3a2120,_0x4949e8){var _0x4a88a9={};var _0x3df8db={};var _0x3f2187;var _0xa5cd3d;return db[_0x2171('0x3d')][_0x2171('0x66')]({'where':{'id':_0x531fc5[_0x2171('0x55')]['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x3a2120,null))[_0x2171('0x29')](function(_0x42ca03){if(_0x42ca03){_0x3f2187=_0x42ca03;_0x3df8db[_0x2171('0x40')]=_['keys'](db['CmList'][_0x2171('0x3e')]);_0x3df8db[_0x2171('0x41')]=_['keys'](_0x531fc5['query']);_0x3df8db[_0x2171('0x43')]=_[_0x2171('0x44')](_0x3df8db['model'],_0x3df8db[_0x2171('0x41')]);_0x4a88a9['attributes']=_[_0x2171('0x44')](_0x3df8db['model'],qs[_0x2171('0x46')](_0x531fc5[_0x2171('0x41')]['fields']));_0x4a88a9[_0x2171('0x45')]=_0x4a88a9[_0x2171('0x45')][_0x2171('0x47')]?_0x4a88a9[_0x2171('0x45')]:_0x3df8db['model'];_0x4a88a9[_0x2171('0x68')]=qs[_0x2171('0x4a')](_0x531fc5[_0x2171('0x41')][_0x2171('0x4a')]);_0x4a88a9[_0x2171('0x4c')]=qs[_0x2171('0x43')](_['pick'](_0x531fc5[_0x2171('0x41')],_0x3df8db['filters']));if(_0x531fc5[_0x2171('0x41')][_0x2171('0x2f')]){_0x4a88a9[_0x2171('0x4c')]=_[_0x2171('0x4d')](_0x4a88a9[_0x2171('0x4c')],{'$or':_['map'](_0x4a88a9[_0x2171('0x45')],function(_0x12f263){var _0xff6d2c={};_0xff6d2c[_0x12f263]={'$like':'%'+_0x531fc5[_0x2171('0x41')][_0x2171('0x2f')]+'%'};return _0xff6d2c;})});}_0x4a88a9=_[_0x2171('0x4d')]({},_0x4a88a9,_0x531fc5[_0x2171('0x4f')]);return _0x3f2187[_0x2171('0xb4')](_0x4a88a9);}})[_0x2171('0x29')](function(_0x39bffa){if(_0x39bffa){_0xa5cd3d=_0x39bffa[_0x2171('0x47')];if(!_0x531fc5['query']['hasOwnProperty'](_0x2171('0x49'))){_0x4a88a9[_0x2171('0x22')]=qs['limit'](_0x531fc5[_0x2171('0x41')]['limit']);_0x4a88a9[_0x2171('0x21')]=qs[_0x2171('0x21')](_0x531fc5[_0x2171('0x41')]['offset']);}return _0x3f2187[_0x2171('0xb4')](_0x4a88a9);}})[_0x2171('0x29')](function(_0x46482b){if(_0x46482b){return _0x46482b?{'count':_0xa5cd3d,'rows':_0x46482b}:null;}})[_0x2171('0x29')](respondWithResult(_0x3a2120,null))[_0x2171('0x54')](handleError(_0x3a2120,null));};exports[_0x2171('0xb5')]=function(_0x27986f,_0xfc3bcd,_0x313c16){var _0x57a70d,_0x121301;return db['VoiceQueue'][_0x2171('0x35')]({'where':{'id':_0x27986f[_0x2171('0x55')]['id']}})[_0x2171('0x29')](handleEntityNotFound(_0xfc3bcd,null))['then'](function(_0xea5681){if(_0xea5681){_0x121301=_0xea5681;return _0xea5681[_0x2171('0xb5')](_0x27986f[_0x2171('0x58')][_0x2171('0x91')],_[_0x2171('0x61')](_0x27986f[_0x2171('0x58')],[_0x2171('0x91'),'id'])||{});}return null;})[_0x2171('0x9e')](function(_0x2d2b5e){var _0x45bcfd;_0x57a70d=_0x2d2b5e||[];var _0x27e02e=[];if(_0x2d2b5e){for(var _0x17b782=0x0;_0x17b782<_0x2d2b5e[_0x2171('0x47')];_0x17b782+=0x1){var _0x2cf782=_0x2d2b5e[_0x17b782][_0x2171('0x2b')]({'plain':!![]});_0x45bcfd=squel['insert']()[_0x2171('0xa1')](_0x2171('0xb6'))[_0x2171('0xa3')]([_0x2171('0xa8'),_0x2171('0xa5'),_0x2171('0xa6'),'VoiceQueueId',_0x2171('0x62'),_0x2171('0x63')],squel['select']()['field']('phone',_0x2171('0xa8'))[_0x2171('0x81')]('id',_0x2171('0xa5'))[_0x2171('0x81')](_0x2cf782['CmListId']['toString'](),_0x2171('0xa6'))[_0x2171('0x81')](_0x27986f[_0x2171('0x55')]['id'][_0x2171('0x88')](),'VoiceQueueId')[_0x2171('0x81')](_0x2171('0xa9'),'createdAt')[_0x2171('0x81')](_0x2171('0xa9'),_0x2171('0x63'))['from'](_0x2171('0xb2'))[_0x2171('0x4c')](_0x2171('0xab'))['where']('ListId\x20=\x20?',_0x2cf782['CmListId'][_0x2171('0x88')]())[_0x2171('0x4c')](_0x2171('0xad')))[_0x2171('0x88')]();_0x27e02e[_0x2171('0x87')](db['sequelize'][_0x2171('0x41')](_0x45bcfd));}return BPromise[_0x2171('0x8d')](_0x27e02e);}})[_0x2171('0x29')](function(){return _0x57a70d;})[_0x2171('0x29')](respondWithResult(_0xfc3bcd,null))[_0x2171('0x54')](handleError(_0xfc3bcd,null));};exports['removeBlackLists']=function(_0x61a258,_0x542cab,_0xcc5ea7){return db[_0x2171('0x3d')][_0x2171('0x35')]({'where':{'id':_0x61a258[_0x2171('0x55')]['id']}})[_0x2171('0x29')](handleEntityNotFound(_0x542cab,null))['then'](function(_0x3239a2){if(_0x3239a2){return _0x3239a2['removeBlackLists'](_0x61a258[_0x2171('0x41')][_0x2171('0x91')]);}})[_0x2171('0x29')](function(_0x2e3200){if(_0x2e3200){return db['CmHopperBlack'][_0x2171('0x2a')]({'where':{'ListId':_0x61a258[_0x2171('0x41')]['ids'],'VoiceQueueId':_0x61a258['params']['id']}})['then'](function(){return _0x2e3200;});}})[_0x2171('0x29')](respondWithStatusCode(_0x542cab,null))[_0x2171('0x54')](handleError(_0x542cab,null));};