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 _0x7c1a=['inbound','outbound','filter','ignore','map','value','includes','type','name','UserProfileResource','error','stack','send','index','fieldName','key','model','keys','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','merge','VIRTUAL','options','includeAll','include','VoiceQueue','findAll','rows','catch','show','params','rawAttributes','body','user','get','role','QueueCampaigns','find','UserProfileSection','create','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','createdAt','updatedAt','omit','userProfileId','autoAssociation','getHoppers','findOne','CmHopper','CmHopperHistory','VoiceQueueId','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','Team','getTeams','addTeams','teams','Agents','online','flatMap','forEach','penalty','transaction','each','TeamVoiceQueue','upsert','UserVoiceQueue','UserVoiceQueueRt','interface','SIP/%s','voicePause','userVoiceQueue:save','removeTeams','ids','User','select','field','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','QueryTypes','SELECT','every','TeamId','all','compact','userVoiceQueue:remove','addAgents','spread','emit','push','isNil','format','removeAgents','isArray','getAgents','getMembers','CmList','getLists','addLists','YYYY-MM-DD\x20HH:mm:ss','dialCheckDuplicateType','insert','into','phone','scheduledAt','ContactId','ListId','CmListId','cm_contacts','ListId\x20=\x20?','toString','phone\x20IS\x20NOT\x20NULL','cm_hopper_final','phone\x20NOT\x20IN\x20(?)','COALESCE(phone,\x27\x27)','cm_hopper','onlyIfOpen','fromQuery','deletedAt\x20IS\x20NULL','OrderBy','h.id','ci.item','ci.OrderBy+1','h.ContactId=ci.CmContactId','h.scheduledat=?','PHONE','removeLists','getBlackLists','addBlackLists','cm_hopper_black','NOW()','sequelize','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','sox','ejs','fs-extra','lodash','squel','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueue.socket','register','sendStatus','end','status','undefined','limit','count','offset','Content-Range','json','apply','reject','save','destroy','then','VoiceQueues'];(function(_0x1644e3,_0x50a617){var _0x54617e=function(_0x27d0db){while(--_0x27d0db){_0x1644e3['push'](_0x1644e3['shift']());}};_0x54617e(++_0x50a617);}(_0x7c1a,0x159));var _0xa7c1=function(_0x436989,_0x307d89){_0x436989=_0x436989-0x0;var _0x2e9ce5=_0x7c1a[_0x436989];return _0x2e9ce5;};'use strict';var emlformat=require(_0xa7c1('0x0'));var rimraf=require(_0xa7c1('0x1'));var zipdir=require(_0xa7c1('0x2'));var jsonpatch=require(_0xa7c1('0x3'));var rp=require(_0xa7c1('0x4'));var moment=require(_0xa7c1('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xa7c1('0x6'));var util=require(_0xa7c1('0x7'));var path=require('path');var sox=require(_0xa7c1('0x8'));var csv=require('to-csv');var ejs=require(_0xa7c1('0x9'));var fs=require('fs');var fs_extra=require(_0xa7c1('0xa'));var _=require(_0xa7c1('0xb'));var squel=require(_0xa7c1('0xc'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xa7c1('0xd'));var toCsv=require(_0xa7c1('0xe'));var querystring=require(_0xa7c1('0xf'));var Papa=require('papaparse');var Redis=require(_0xa7c1('0x10'));var authService=require(_0xa7c1('0x11'));var qs=require(_0xa7c1('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xa7c1('0x13'));var logger=require(_0xa7c1('0x14'))('api');var utils=require(_0xa7c1('0x15'));var config=require(_0xa7c1('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0xa7c1('0x17'))['db'];config[_0xa7c1('0x18')]=_[_0xa7c1('0x19')](config[_0xa7c1('0x18')],{'host':_0xa7c1('0x1a'),'port':0x18eb});var socket=require(_0xa7c1('0x1b'))(new Redis(config[_0xa7c1('0x18')]));require(_0xa7c1('0x1c'))[_0xa7c1('0x1d')](socket);function respondWithStatusCode(_0x21ce41,_0x3a4284){_0x3a4284=_0x3a4284||0xcc;return function(_0x30b538){if(_0x30b538){return _0x21ce41[_0xa7c1('0x1e')](_0x3a4284);}return _0x21ce41['status'](_0x3a4284)[_0xa7c1('0x1f')]();};}function respondWithResult(_0x3a6f47,_0x1790c3){_0x1790c3=_0x1790c3||0xc8;return function(_0x1ca843){if(_0x1ca843){return _0x3a6f47[_0xa7c1('0x20')](_0x1790c3)['json'](_0x1ca843);}};}function respondWithFilteredResult(_0x3b77af,_0x554f08){return function(_0x440251){if(_0x440251){var _0x337db4=typeof _0x554f08['offset']===_0xa7c1('0x21')&&typeof _0x554f08[_0xa7c1('0x22')]===_0xa7c1('0x21');var _0x5d3841=_0x440251[_0xa7c1('0x23')];var _0x81396e=_0x337db4?0x0:_0x554f08[_0xa7c1('0x24')];var _0x422447=_0x337db4?_0x440251[_0xa7c1('0x23')]:_0x554f08[_0xa7c1('0x24')]+_0x554f08[_0xa7c1('0x22')];var _0xdfcbd9;if(_0x422447>=_0x5d3841){_0x422447=_0x5d3841;_0xdfcbd9=0xc8;}else{_0xdfcbd9=0xce;}_0x3b77af[_0xa7c1('0x20')](_0xdfcbd9);return _0x3b77af['set'](_0xa7c1('0x25'),_0x81396e+'-'+_0x422447+'/'+_0x5d3841)[_0xa7c1('0x26')](_0x440251);}return null;};}function patchUpdates(_0x1ebcdd){return function(_0x5be37a){try{jsonpatch[_0xa7c1('0x27')](_0x5be37a,_0x1ebcdd,!![]);}catch(_0x7dbe77){return BPromise[_0xa7c1('0x28')](_0x7dbe77);}return _0x5be37a[_0xa7c1('0x29')]();};}function saveUpdates(_0x30cb15,_0x37da75){return function(_0x3c9866){if(_0x3c9866){return _0x3c9866['update'](_0x30cb15)['then'](function(_0x48280a){return _0x48280a;});}return null;};}function removeEntity(_0x1ea97e,_0x40c478){return function(_0xd17267){if(_0xd17267){return _0xd17267[_0xa7c1('0x2a')]()[_0xa7c1('0x2b')](function(){var _0x5d62cb=_0xd17267['get']({'plain':!![]});var _0x465dd1=[{'name':_0xa7c1('0x2c'),'value':_0xa7c1('0x2d'),'ignore':![]},{'name':'QueueCampaigns','value':_0xa7c1('0x2e'),'ignore':![]}];var _0x9a6f55=_(_0x465dd1)[_0xa7c1('0x2f')](_0xa7c1('0x30'))[_0xa7c1('0x31')](_0xa7c1('0x32'))[_0xa7c1('0x32')]();if(_[_0xa7c1('0x33')](_0x9a6f55,_0x5d62cb[_0xa7c1('0x34')])){return;}var _0x197bdc=_['find'](_0x465dd1,[_0xa7c1('0x32'),_0x5d62cb[_0xa7c1('0x34')]])[_0xa7c1('0x35')];return db[_0xa7c1('0x36')][_0xa7c1('0x2a')]({'where':{'type':_0x197bdc,'resourceId':_0x5d62cb['id']}})[_0xa7c1('0x2b')](function(){return _0xd17267;});})[_0xa7c1('0x2b')](function(){_0x1ea97e[_0xa7c1('0x20')](0xcc)[_0xa7c1('0x1f')]();});}};}function handleEntityNotFound(_0x5ab57b,_0x1dc174){return function(_0x97bc0d){if(!_0x97bc0d){_0x5ab57b[_0xa7c1('0x1e')](0x194);}return _0x97bc0d;};}function handleError(_0x27feee,_0x56d94c){_0x56d94c=_0x56d94c||0x1f4;return function(_0x5c8956){logger[_0xa7c1('0x37')](_0x5c8956[_0xa7c1('0x38')]);if(_0x5c8956[_0xa7c1('0x35')]){delete _0x5c8956['name'];}_0x27feee['status'](_0x56d94c)[_0xa7c1('0x39')](_0x5c8956);};}exports[_0xa7c1('0x3a')]=function(_0x5182ca,_0x1dc655){var _0x55e4e0={},_0x2c1569={},_0x55b3ea={'count':0x0,'rows':[]};var _0x46bdb1=_[_0xa7c1('0x31')](db['VoiceQueue']['rawAttributes'],function(_0x1a7261){return{'name':_0x1a7261[_0xa7c1('0x3b')],'type':_0x1a7261[_0xa7c1('0x34')][_0xa7c1('0x3c')]};});_0x2c1569[_0xa7c1('0x3d')]=_[_0xa7c1('0x31')](_0x46bdb1,_0xa7c1('0x35'));_0x2c1569['query']=_[_0xa7c1('0x3e')](_0x5182ca[_0xa7c1('0x3f')]);_0x2c1569[_0xa7c1('0x40')]=_[_0xa7c1('0x41')](_0x2c1569[_0xa7c1('0x3d')],_0x2c1569[_0xa7c1('0x3f')]);_0x55e4e0['attributes']=_[_0xa7c1('0x41')](_0x2c1569[_0xa7c1('0x3d')],qs[_0xa7c1('0x42')](_0x5182ca[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0x55e4e0[_0xa7c1('0x43')]=_0x55e4e0[_0xa7c1('0x43')][_0xa7c1('0x44')]?_0x55e4e0['attributes']:_0x2c1569[_0xa7c1('0x3d')];if(!_0x5182ca[_0xa7c1('0x3f')][_0xa7c1('0x45')](_0xa7c1('0x46'))){_0x55e4e0[_0xa7c1('0x22')]=qs[_0xa7c1('0x22')](_0x5182ca[_0xa7c1('0x3f')][_0xa7c1('0x22')]);_0x55e4e0[_0xa7c1('0x24')]=qs[_0xa7c1('0x24')](_0x5182ca[_0xa7c1('0x3f')][_0xa7c1('0x24')]);}_0x55e4e0[_0xa7c1('0x47')]=qs[_0xa7c1('0x48')](_0x5182ca[_0xa7c1('0x3f')][_0xa7c1('0x48')]);_0x55e4e0[_0xa7c1('0x49')]=qs['filters'](_[_0xa7c1('0x4a')](_0x5182ca[_0xa7c1('0x3f')],_0x2c1569['filters']),_0x46bdb1);if(_0x5182ca[_0xa7c1('0x3f')][_0xa7c1('0x2f')]){_0x55e4e0[_0xa7c1('0x49')]=_[_0xa7c1('0x4b')](_0x55e4e0['where'],{'$or':_[_0xa7c1('0x31')](_0x46bdb1,function(_0x4f6acf){if(_0x4f6acf['type']!==_0xa7c1('0x4c')){var _0x1d131e={};_0x1d131e[_0x4f6acf[_0xa7c1('0x35')]]={'$like':'%'+_0x5182ca[_0xa7c1('0x3f')][_0xa7c1('0x2f')]+'%'};return _0x1d131e;}})});}_0x55e4e0=_['merge']({},_0x55e4e0,_0x5182ca[_0xa7c1('0x4d')]);var _0xf2a7b0={'where':_0x55e4e0[_0xa7c1('0x49')]};return db['VoiceQueue']['count'](_0xf2a7b0)[_0xa7c1('0x2b')](function(_0x2e3f75){_0x55b3ea['count']=_0x2e3f75;if(_0x5182ca[_0xa7c1('0x3f')][_0xa7c1('0x4e')]){_0x55e4e0[_0xa7c1('0x4f')]=[{'all':!![]}];}return db[_0xa7c1('0x50')][_0xa7c1('0x51')](_0x55e4e0);})['then'](function(_0x404362){_0x55b3ea[_0xa7c1('0x52')]=_0x404362;return _0x55b3ea;})[_0xa7c1('0x2b')](respondWithFilteredResult(_0x1dc655,_0x55e4e0))[_0xa7c1('0x53')](handleError(_0x1dc655,null));};exports[_0xa7c1('0x54')]=function(_0x4c3c0a,_0x3a274d){var _0x96b8a0={'raw':![],'where':{'id':_0x4c3c0a[_0xa7c1('0x55')]['id']}},_0x609ac3={};_0x609ac3[_0xa7c1('0x3d')]=_[_0xa7c1('0x3e')](db['VoiceQueue'][_0xa7c1('0x56')]);_0x609ac3[_0xa7c1('0x3f')]=_[_0xa7c1('0x3e')](_0x4c3c0a[_0xa7c1('0x3f')]);_0x609ac3['filters']=_['intersection'](_0x609ac3[_0xa7c1('0x3d')],_0x609ac3['query']);_0x96b8a0[_0xa7c1('0x43')]=_[_0xa7c1('0x41')](_0x609ac3[_0xa7c1('0x3d')],qs['fields'](_0x4c3c0a[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0x96b8a0['attributes']=_0x96b8a0['attributes'][_0xa7c1('0x44')]?_0x96b8a0[_0xa7c1('0x43')]:_0x609ac3[_0xa7c1('0x3d')];if(_0x4c3c0a['query'][_0xa7c1('0x4e')]){_0x96b8a0[_0xa7c1('0x4f')]=[{'all':!![]}];}_0x96b8a0=_[_0xa7c1('0x4b')]({},_0x96b8a0,_0x4c3c0a[_0xa7c1('0x4d')]);return db[_0xa7c1('0x50')]['find'](_0x96b8a0)['then'](handleEntityNotFound(_0x3a274d,null))[_0xa7c1('0x2b')](respondWithResult(_0x3a274d,null))[_0xa7c1('0x53')](handleError(_0x3a274d,null));};exports['create']=function(_0x4b8aaf,_0x183182){return db[_0xa7c1('0x50')]['create'](_0x4b8aaf[_0xa7c1('0x57')],{})['then'](function(_0x598587){var _0x40feb=_0x4b8aaf[_0xa7c1('0x58')][_0xa7c1('0x59')]({'plain':!![]});if(!_0x40feb)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x40feb[_0xa7c1('0x5a')]==='user'){var _0x2169f1=_0x598587[_0xa7c1('0x59')]({'plain':!![]});var _0x544d16=[{'name':_0xa7c1('0x2c'),'value':'inbound'},{'name':_0xa7c1('0x5b'),'value':_0xa7c1('0x2e')}];var _0x4e22bf=_[_0xa7c1('0x5c')](_0x544d16,['value',_0x2169f1[_0xa7c1('0x34')]])[_0xa7c1('0x35')];return db[_0xa7c1('0x5d')][_0xa7c1('0x5c')]({'where':{'name':_0x4e22bf,'userProfileId':_0x40feb['userProfileId']},'raw':!![]})[_0xa7c1('0x2b')](function(_0x1af57d){if(_0x1af57d&&_0x1af57d['autoAssociation']===0x0){return db['UserProfileResource'][_0xa7c1('0x5e')]({'name':_0x2169f1[_0xa7c1('0x35')],'resourceId':_0x2169f1['id'],'type':_0x1af57d[_0xa7c1('0x35')],'sectionId':_0x1af57d['id']},{})[_0xa7c1('0x2b')](function(){return _0x598587;});}else{return _0x598587;}})[_0xa7c1('0x53')](function(_0x402088){logger[_0xa7c1('0x37')](_0xa7c1('0x5f'),_0x402088);throw _0x402088;});}return _0x598587;})[_0xa7c1('0x2b')](respondWithResult(_0x183182,0xc9))['catch'](handleError(_0x183182,null));};exports[_0xa7c1('0x60')]=function(_0x1b6d5e,_0x409d97){var _0x269319={'where':{'id':_0x1b6d5e[_0xa7c1('0x55')]['id']}},_0x4d71dd={};_0x4d71dd['model']=_['keys'](db[_0xa7c1('0x50')][_0xa7c1('0x56')]);_0x269319[_0xa7c1('0x43')]=_[_0xa7c1('0x41')](_0x4d71dd[_0xa7c1('0x3d')],qs[_0xa7c1('0x42')](_0x1b6d5e[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0x269319[_0xa7c1('0x43')]=_0x269319[_0xa7c1('0x43')]['length']?_0x269319[_0xa7c1('0x43')]:_0x4d71dd[_0xa7c1('0x3d')];if(_0x1b6d5e[_0xa7c1('0x3f')]['includeAll']){_0x269319[_0xa7c1('0x4f')]=[{'all':!![]}];}_0x269319=_['merge']({},_0x269319,_0x1b6d5e['options']);return db[_0xa7c1('0x50')][_0xa7c1('0x5c')](_0x269319)[_0xa7c1('0x2b')](handleEntityNotFound(_0x409d97,null))[_0xa7c1('0x2b')](function(_0x17cab1){if(_0x17cab1){var _0x2d9468=_0x17cab1['get']({'plain':!![]});_0x2d9468=qs['omit'](_0x2d9468,['id',_0xa7c1('0x61'),_0xa7c1('0x62')]);_0x1b6d5e['body']=_[_0xa7c1('0x63')](_0x1b6d5e['body'],['id',_0xa7c1('0x61'),_0xa7c1('0x62')]);return db[_0xa7c1('0x50')][_0xa7c1('0x5e')](_[_0xa7c1('0x4b')](_0x2d9468,_0x1b6d5e['body']),{'include':_0x1b6d5e['query'][_0xa7c1('0x4e')]?[{'all':!![]}]:undefined})[_0xa7c1('0x2b')](function(_0x44886e){var _0x1012d3=_0x1b6d5e['user'][_0xa7c1('0x59')]({'plain':!![]});if(!_0x1012d3)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1012d3[_0xa7c1('0x5a')]===_0xa7c1('0x58')){var _0x3b0f9c=_0x44886e[_0xa7c1('0x59')]({'plain':!![]});var _0x45585e=[{'name':_0xa7c1('0x2c'),'value':'inbound'},{'name':'QueueCampaigns','value':'outbound'}];var _0x266f20=_[_0xa7c1('0x5c')](_0x45585e,[_0xa7c1('0x32'),_0x3b0f9c[_0xa7c1('0x34')]])[_0xa7c1('0x35')];return db[_0xa7c1('0x5d')][_0xa7c1('0x5c')]({'where':{'name':_0x266f20,'userProfileId':_0x1012d3[_0xa7c1('0x64')]},'raw':!![]})[_0xa7c1('0x2b')](function(_0x228753){if(_0x228753&&_0x228753[_0xa7c1('0x65')]===0x0){return db[_0xa7c1('0x36')][_0xa7c1('0x5e')]({'name':_0x3b0f9c[_0xa7c1('0x35')],'resourceId':_0x3b0f9c['id'],'type':_0x228753[_0xa7c1('0x35')],'sectionId':_0x228753['id']},{})[_0xa7c1('0x2b')](function(){return _0x44886e;});}else{return _0x44886e;}})['catch'](function(_0xbd5784){logger['error'](_0xa7c1('0x5f'),_0xbd5784);throw _0xbd5784;});}return _0x44886e;});}})[_0xa7c1('0x2b')](respondWithResult(_0x409d97,0xc9))['catch'](handleError(_0x409d97,null));};exports['update']=function(_0x1d4671,_0x9cf732){if(_0x1d4671[_0xa7c1('0x57')]['id']){delete _0x1d4671[_0xa7c1('0x57')]['id'];}return db[_0xa7c1('0x50')][_0xa7c1('0x5c')]({'where':{'id':_0x1d4671[_0xa7c1('0x55')]['id']}})['then'](handleEntityNotFound(_0x9cf732,null))['then'](saveUpdates(_0x1d4671[_0xa7c1('0x57')],null))[_0xa7c1('0x2b')](respondWithResult(_0x9cf732,null))[_0xa7c1('0x53')](handleError(_0x9cf732,null));};exports[_0xa7c1('0x2a')]=function(_0x43bb79,_0x5af423){return db[_0xa7c1('0x50')][_0xa7c1('0x5c')]({'where':{'id':_0x43bb79[_0xa7c1('0x55')]['id']}})['then'](handleEntityNotFound(_0x5af423,null))[_0xa7c1('0x2b')](removeEntity(_0x5af423,null))['catch'](handleError(_0x5af423,null));};exports[_0xa7c1('0x66')]=function(_0x48393b,_0x5cfbc3,_0x24a032){var _0x49d606={'raw':![],'where':{}};var _0x37ab5f={};var _0x2a1ed6={'count':0x0,'rows':[]};return db[_0xa7c1('0x50')][_0xa7c1('0x67')]({'where':{'id':_0x48393b['params']['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x5cfbc3,null))[_0xa7c1('0x2b')](function(_0x2f42e3){if(_0x2f42e3){_0x37ab5f[_0xa7c1('0x3d')]=_[_0xa7c1('0x3e')](db[_0xa7c1('0x68')][_0xa7c1('0x56')]);_0x37ab5f[_0xa7c1('0x3f')]=_[_0xa7c1('0x3e')](_0x48393b[_0xa7c1('0x3f')]);_0x37ab5f['filters']=_['intersection'](_0x37ab5f['model'],_0x37ab5f['query']);_0x49d606['attributes']=_[_0xa7c1('0x41')](_0x37ab5f[_0xa7c1('0x3d')],qs[_0xa7c1('0x42')](_0x48393b[_0xa7c1('0x3f')]['fields']));_0x49d606[_0xa7c1('0x43')]=_0x49d606['attributes'][_0xa7c1('0x44')]?_0x49d606[_0xa7c1('0x43')]:_0x37ab5f[_0xa7c1('0x3d')];if(!_0x48393b[_0xa7c1('0x3f')][_0xa7c1('0x45')](_0xa7c1('0x46'))){_0x49d606[_0xa7c1('0x22')]=qs[_0xa7c1('0x22')](_0x48393b[_0xa7c1('0x3f')][_0xa7c1('0x22')]);_0x49d606[_0xa7c1('0x24')]=qs[_0xa7c1('0x24')](_0x48393b[_0xa7c1('0x3f')][_0xa7c1('0x24')]);}_0x49d606[_0xa7c1('0x47')]=qs[_0xa7c1('0x48')](_0x48393b['query']['sort']);_0x49d606[_0xa7c1('0x49')]=qs[_0xa7c1('0x40')](_[_0xa7c1('0x4a')](_0x48393b[_0xa7c1('0x3f')],_0x37ab5f[_0xa7c1('0x40')]));_0x49d606['where']['VoiceQueueId']=_0x2f42e3['id'];if(_0x48393b[_0xa7c1('0x3f')]['filter']){_0x49d606[_0xa7c1('0x49')]=_[_0xa7c1('0x4b')](_0x49d606[_0xa7c1('0x49')],{'$or':_['map'](_0x49d606[_0xa7c1('0x43')],function(_0x3f53e9){var _0x5c02d0={};_0x5c02d0[_0x3f53e9]={'$like':'%'+_0x48393b[_0xa7c1('0x3f')][_0xa7c1('0x2f')]+'%'};return _0x5c02d0;})});}_0x49d606=_[_0xa7c1('0x4b')]({},_0x49d606,_0x48393b[_0xa7c1('0x4d')]);return db[_0xa7c1('0x68')][_0xa7c1('0x23')]({'where':_0x49d606[_0xa7c1('0x49')]})['then'](function(_0x5cdb1d){_0x2a1ed6[_0xa7c1('0x23')]=_0x5cdb1d;if(_0x48393b[_0xa7c1('0x3f')]['includeAll']){_0x49d606[_0xa7c1('0x4f')]=[{'all':!![]}];}return db[_0xa7c1('0x68')][_0xa7c1('0x51')](_0x49d606);})[_0xa7c1('0x2b')](function(_0x395114){_0x2a1ed6[_0xa7c1('0x52')]=_0x395114;return _0x2a1ed6;});}})['then'](respondWithFilteredResult(_0x5cfbc3,_0x49d606))[_0xa7c1('0x53')](handleError(_0x5cfbc3,null));};exports['getHopperHistories']=function(_0x2d700f,_0x29ecf4,_0xc23dde){var _0xd1f7b1={'raw':!![],'where':{}};var _0x5e5a62={};var _0x4ecdaa={'count':0x0,'rows':[]};return db['VoiceQueue'][_0xa7c1('0x67')]({'where':{'id':_0x2d700f[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x29ecf4,null))[_0xa7c1('0x2b')](function(_0x1f1de1){if(_0x1f1de1){_0x5e5a62[_0xa7c1('0x3d')]=_['keys'](db[_0xa7c1('0x69')]['rawAttributes']);_0x5e5a62['query']=_[_0xa7c1('0x3e')](_0x2d700f[_0xa7c1('0x3f')]);_0x5e5a62[_0xa7c1('0x40')]=_[_0xa7c1('0x41')](_0x5e5a62['model'],_0x5e5a62[_0xa7c1('0x3f')]);_0xd1f7b1[_0xa7c1('0x43')]=_[_0xa7c1('0x41')](_0x5e5a62[_0xa7c1('0x3d')],qs['fields'](_0x2d700f[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0xd1f7b1['attributes']=_0xd1f7b1[_0xa7c1('0x43')][_0xa7c1('0x44')]?_0xd1f7b1[_0xa7c1('0x43')]:_0x5e5a62[_0xa7c1('0x3d')];if(!_0x2d700f[_0xa7c1('0x3f')][_0xa7c1('0x45')](_0xa7c1('0x46'))){_0xd1f7b1['limit']=qs[_0xa7c1('0x22')](_0x2d700f[_0xa7c1('0x3f')]['limit']);_0xd1f7b1['offset']=qs['offset'](_0x2d700f[_0xa7c1('0x3f')][_0xa7c1('0x24')]);}_0xd1f7b1[_0xa7c1('0x47')]=qs[_0xa7c1('0x48')](_0x2d700f[_0xa7c1('0x3f')][_0xa7c1('0x48')]);_0xd1f7b1[_0xa7c1('0x49')]=qs['filters'](_[_0xa7c1('0x4a')](_0x2d700f[_0xa7c1('0x3f')],_0x5e5a62[_0xa7c1('0x40')]));_0xd1f7b1[_0xa7c1('0x49')][_0xa7c1('0x6a')]=_0x1f1de1['id'];if(_0x2d700f[_0xa7c1('0x3f')]['filter']){_0xd1f7b1[_0xa7c1('0x49')]=_['merge'](_0xd1f7b1[_0xa7c1('0x49')],{'$or':_[_0xa7c1('0x31')](_0xd1f7b1[_0xa7c1('0x43')],function(_0x1c1ca2){var _0x26e65f={};_0x26e65f[_0x1c1ca2]={'$like':'%'+_0x2d700f[_0xa7c1('0x3f')][_0xa7c1('0x2f')]+'%'};return _0x26e65f;})});}_0xd1f7b1=_[_0xa7c1('0x4b')]({},_0xd1f7b1,_0x2d700f[_0xa7c1('0x4d')]);return db[_0xa7c1('0x69')][_0xa7c1('0x23')]({'where':_0xd1f7b1[_0xa7c1('0x49')]})[_0xa7c1('0x2b')](function(_0x364212){_0x4ecdaa[_0xa7c1('0x23')]=_0x364212;if(_0x2d700f[_0xa7c1('0x3f')][_0xa7c1('0x4e')]){_0xd1f7b1[_0xa7c1('0x4f')]=[{'all':!![]}];}return db[_0xa7c1('0x69')][_0xa7c1('0x51')](_0xd1f7b1);})[_0xa7c1('0x2b')](function(_0x4b07bc){_0x4ecdaa['rows']=_0x4b07bc;return _0x4ecdaa;});}})[_0xa7c1('0x2b')](respondWithFilteredResult(_0x29ecf4,_0xd1f7b1))[_0xa7c1('0x53')](handleError(_0x29ecf4,null));};exports[_0xa7c1('0x6b')]=function(_0x42991e,_0x5d7a99,_0x27a229){var _0x3de5d2={'raw':!![],'where':{}};var _0x71aab4={};var _0x23a671={'count':0x0,'rows':[]};return db[_0xa7c1('0x50')]['findOne']({'where':{'id':_0x42991e[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x5d7a99,null))[_0xa7c1('0x2b')](function(_0x343542){if(_0x343542){_0x71aab4[_0xa7c1('0x3d')]=_[_0xa7c1('0x3e')](db[_0xa7c1('0x6c')][_0xa7c1('0x56')]);_0x71aab4['query']=_[_0xa7c1('0x3e')](_0x42991e[_0xa7c1('0x3f')]);_0x71aab4[_0xa7c1('0x40')]=_[_0xa7c1('0x41')](_0x71aab4[_0xa7c1('0x3d')],_0x71aab4[_0xa7c1('0x3f')]);_0x3de5d2[_0xa7c1('0x43')]=_['intersection'](_0x71aab4[_0xa7c1('0x3d')],qs['fields'](_0x42991e[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0x3de5d2['attributes']=_0x3de5d2[_0xa7c1('0x43')][_0xa7c1('0x44')]?_0x3de5d2[_0xa7c1('0x43')]:_0x71aab4[_0xa7c1('0x3d')];if(!_0x42991e['query']['hasOwnProperty'](_0xa7c1('0x46'))){_0x3de5d2[_0xa7c1('0x22')]=qs[_0xa7c1('0x22')](_0x42991e[_0xa7c1('0x3f')][_0xa7c1('0x22')]);_0x3de5d2['offset']=qs['offset'](_0x42991e[_0xa7c1('0x3f')][_0xa7c1('0x24')]);}_0x3de5d2[_0xa7c1('0x47')]=qs['sort'](_0x42991e[_0xa7c1('0x3f')]['sort']);_0x3de5d2[_0xa7c1('0x49')]=qs['filters'](_[_0xa7c1('0x4a')](_0x42991e['query'],_0x71aab4[_0xa7c1('0x40')]));_0x3de5d2[_0xa7c1('0x49')][_0xa7c1('0x6a')]=_0x343542['id'];if(_0x42991e[_0xa7c1('0x3f')][_0xa7c1('0x2f')]){_0x3de5d2[_0xa7c1('0x49')]=_[_0xa7c1('0x4b')](_0x3de5d2[_0xa7c1('0x49')],{'$or':_[_0xa7c1('0x31')](_0x3de5d2['attributes'],function(_0xda3fc5){var _0x5ac4e9={};_0x5ac4e9[_0xda3fc5]={'$like':'%'+_0x42991e[_0xa7c1('0x3f')][_0xa7c1('0x2f')]+'%'};return _0x5ac4e9;})});}_0x3de5d2=_['merge']({},_0x3de5d2,_0x42991e[_0xa7c1('0x4d')]);return db[_0xa7c1('0x6c')]['count']({'where':_0x3de5d2[_0xa7c1('0x49')]})[_0xa7c1('0x2b')](function(_0x2f0ba2){_0x23a671['count']=_0x2f0ba2;if(_0x42991e[_0xa7c1('0x3f')][_0xa7c1('0x4e')]){_0x3de5d2['include']=[{'all':!![]}];}return db['CmHopperFinal'][_0xa7c1('0x51')](_0x3de5d2);})[_0xa7c1('0x2b')](function(_0x2bd4fa){_0x23a671[_0xa7c1('0x52')]=_0x2bd4fa;return _0x23a671;});}})[_0xa7c1('0x2b')](respondWithFilteredResult(_0x5d7a99,_0x3de5d2))[_0xa7c1('0x53')](handleError(_0x5d7a99,null));};exports[_0xa7c1('0x6d')]=function(_0x10928d,_0x27feb2,_0x262ad6){var _0xe3aadc={'raw':!![],'where':{}};var _0xe7d8dc={};var _0x589c5a={'count':0x0,'rows':[]};return db[_0xa7c1('0x50')][_0xa7c1('0x67')]({'where':{'id':_0x10928d['params']['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x27feb2,null))[_0xa7c1('0x2b')](function(_0x586ebd){if(_0x586ebd){_0xe7d8dc['model']=_[_0xa7c1('0x3e')](db[_0xa7c1('0x6e')][_0xa7c1('0x56')]);_0xe7d8dc['query']=_[_0xa7c1('0x3e')](_0x10928d[_0xa7c1('0x3f')]);_0xe7d8dc[_0xa7c1('0x40')]=_[_0xa7c1('0x41')](_0xe7d8dc[_0xa7c1('0x3d')],_0xe7d8dc[_0xa7c1('0x3f')]);_0xe3aadc['attributes']=_['intersection'](_0xe7d8dc['model'],qs[_0xa7c1('0x42')](_0x10928d[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0xe3aadc[_0xa7c1('0x43')]=_0xe3aadc[_0xa7c1('0x43')]['length']?_0xe3aadc['attributes']:_0xe7d8dc[_0xa7c1('0x3d')];if(!_0x10928d[_0xa7c1('0x3f')][_0xa7c1('0x45')](_0xa7c1('0x46'))){_0xe3aadc[_0xa7c1('0x22')]=qs[_0xa7c1('0x22')](_0x10928d[_0xa7c1('0x3f')][_0xa7c1('0x22')]);_0xe3aadc[_0xa7c1('0x24')]=qs[_0xa7c1('0x24')](_0x10928d[_0xa7c1('0x3f')]['offset']);}_0xe3aadc[_0xa7c1('0x47')]=qs[_0xa7c1('0x48')](_0x10928d['query'][_0xa7c1('0x48')]);_0xe3aadc[_0xa7c1('0x49')]=qs['filters'](_['pick'](_0x10928d[_0xa7c1('0x3f')],_0xe7d8dc[_0xa7c1('0x40')]));_0xe3aadc[_0xa7c1('0x49')][_0xa7c1('0x6a')]=_0x586ebd['id'];if(_0x10928d[_0xa7c1('0x3f')][_0xa7c1('0x2f')]){_0xe3aadc[_0xa7c1('0x49')]=_[_0xa7c1('0x4b')](_0xe3aadc[_0xa7c1('0x49')],{'$or':_[_0xa7c1('0x31')](_0xe3aadc[_0xa7c1('0x43')],function(_0x5689a5){var _0x6b881e={};_0x6b881e[_0x5689a5]={'$like':'%'+_0x10928d[_0xa7c1('0x3f')]['filter']+'%'};return _0x6b881e;})});}_0xe3aadc=_['merge']({},_0xe3aadc,_0x10928d[_0xa7c1('0x4d')]);return db[_0xa7c1('0x6e')]['count']({'where':_0xe3aadc[_0xa7c1('0x49')]})[_0xa7c1('0x2b')](function(_0xb1903b){_0x589c5a[_0xa7c1('0x23')]=_0xb1903b;if(_0x10928d[_0xa7c1('0x3f')]['includeAll']){_0xe3aadc[_0xa7c1('0x4f')]=[{'all':!![]}];}return db[_0xa7c1('0x6e')][_0xa7c1('0x51')](_0xe3aadc);})[_0xa7c1('0x2b')](function(_0x4452fc){_0x589c5a[_0xa7c1('0x52')]=_0x4452fc;return _0x589c5a;});}})[_0xa7c1('0x2b')](respondWithFilteredResult(_0x27feb2,_0xe3aadc))[_0xa7c1('0x53')](handleError(_0x27feb2,null));};exports['getTeams']=function(_0x5d8d31,_0x3d8031,_0x5b688f){var _0x22e529={};var _0x1ea02f={};var _0x604b0b;var _0x22ab1f;return db[_0xa7c1('0x50')][_0xa7c1('0x67')]({'where':{'id':_0x5d8d31['params']['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x3d8031,null))[_0xa7c1('0x2b')](function(_0x41bf62){if(_0x41bf62){_0x604b0b=_0x41bf62;_0x1ea02f[_0xa7c1('0x3d')]=_[_0xa7c1('0x3e')](db[_0xa7c1('0x6f')][_0xa7c1('0x56')]);_0x1ea02f[_0xa7c1('0x3f')]=_[_0xa7c1('0x3e')](_0x5d8d31[_0xa7c1('0x3f')]);_0x1ea02f[_0xa7c1('0x40')]=_[_0xa7c1('0x41')](_0x1ea02f[_0xa7c1('0x3d')],_0x1ea02f[_0xa7c1('0x3f')]);_0x22e529[_0xa7c1('0x43')]=_[_0xa7c1('0x41')](_0x1ea02f[_0xa7c1('0x3d')],qs[_0xa7c1('0x42')](_0x5d8d31[_0xa7c1('0x3f')]['fields']));_0x22e529['attributes']=_0x22e529[_0xa7c1('0x43')]['length']?_0x22e529[_0xa7c1('0x43')]:_0x1ea02f[_0xa7c1('0x3d')];_0x22e529[_0xa7c1('0x47')]=qs['sort'](_0x5d8d31[_0xa7c1('0x3f')][_0xa7c1('0x48')]);_0x22e529['where']=qs[_0xa7c1('0x40')](_[_0xa7c1('0x4a')](_0x5d8d31[_0xa7c1('0x3f')],_0x1ea02f[_0xa7c1('0x40')]));if(_0x5d8d31[_0xa7c1('0x3f')][_0xa7c1('0x2f')]){_0x22e529['where']=_[_0xa7c1('0x4b')](_0x22e529[_0xa7c1('0x49')],{'$or':_['map'](_0x22e529[_0xa7c1('0x43')],function(_0x1ae239){var _0x5ed5ac={};_0x5ed5ac[_0x1ae239]={'$like':'%'+_0x5d8d31[_0xa7c1('0x3f')][_0xa7c1('0x2f')]+'%'};return _0x5ed5ac;})});}_0x22e529=_[_0xa7c1('0x4b')]({},_0x22e529,_0x5d8d31[_0xa7c1('0x4d')]);return _0x604b0b[_0xa7c1('0x70')](_0x22e529);}})[_0xa7c1('0x2b')](function(_0x1fb8e7){if(_0x1fb8e7){_0x22ab1f=_0x1fb8e7[_0xa7c1('0x44')];if(!_0x5d8d31[_0xa7c1('0x3f')]['hasOwnProperty'](_0xa7c1('0x46'))){_0x22e529[_0xa7c1('0x22')]=qs['limit'](_0x5d8d31[_0xa7c1('0x3f')]['limit']);_0x22e529['offset']=qs['offset'](_0x5d8d31[_0xa7c1('0x3f')][_0xa7c1('0x24')]);}return _0x604b0b[_0xa7c1('0x70')](_0x22e529);}})[_0xa7c1('0x2b')](function(_0x1ef82d){if(_0x1ef82d){return _0x1ef82d?{'count':_0x22ab1f,'rows':_0x1ef82d}:null;}})[_0xa7c1('0x2b')](respondWithResult(_0x3d8031,null))['catch'](handleError(_0x3d8031,null));};exports[_0xa7c1('0x71')]=function(_0x5e3cee,_0x4288da,_0xc27e0e){var _0x5ddd31=_0x5e3cee['body'][_0xa7c1('0x72')];var _0xb9fa5=_[_0xa7c1('0x31')](_0x5ddd31,'id');return db['Team'][_0xa7c1('0x51')]({'where':{'id':_0xb9fa5},'attributes':['id'],'include':[{'model':db['User'],'as':_0xa7c1('0x73'),'attributes':['id',_0xa7c1('0x35'),_0xa7c1('0x74'),'voicePause','interface'],'raw':!![]}]})[_0xa7c1('0x2b')](function(_0x388ffd){if(_0x388ffd){var _0x13e6fd=_[_0xa7c1('0x75')](_0x388ffd,function(_0x4fbcaf){var _0x1e11c2=_0x4fbcaf['get']({'plain':!![]});_0x1e11c2[_0xa7c1('0x73')][_0xa7c1('0x76')](function(_0x5899a5){_0x5899a5[_0xa7c1('0x77')]=_[_0xa7c1('0x5c')](_0x5ddd31,{'id':_0x1e11c2['id']})[_0xa7c1('0x77')];});return _0x1e11c2[_0xa7c1('0x73')];});return db[_0xa7c1('0x50')]['find']({'where':{'id':_0x5e3cee['params']['id']}})[_0xa7c1('0x2b')](function(_0x1d2258){return db['sequelize'][_0xa7c1('0x78')](function(_0x21f025){return _0x1d2258[_0xa7c1('0x71')](_0xb9fa5,{'transaction':_0x21f025})['then'](function(){return BPromise[_0xa7c1('0x79')](_0x5ddd31,function(_0x4702cd){return db[_0xa7c1('0x7a')][_0xa7c1('0x7b')]({'TeamId':_0x4702cd['id'],'VoiceQueueId':_0x5e3cee[_0xa7c1('0x55')]['id'],'penalty':_0x4702cd[_0xa7c1('0x77')]},{'transaction':_0x21f025});});})['then'](function(){return BPromise[_0xa7c1('0x79')](_0x13e6fd,function(_0x2c3710){return db[_0xa7c1('0x7c')]['findOrCreate']({'where':{'UserId':_0x2c3710['id'],'VoiceQueueId':_0x5e3cee[_0xa7c1('0x55')]['id']},'defaults':{'penalty':_0x2c3710['penalty']},'transaction':_0x21f025});});})[_0xa7c1('0x2b')](function(){return BPromise['each'](_[_0xa7c1('0x2f')](_0x13e6fd,{'online':!![]}),function(_0x5744b9){return db[_0xa7c1('0x7d')]['upsert']({'membername':_0x5744b9[_0xa7c1('0x35')],'UserId':_0x5744b9['id'],'queue_name':_0x1d2258['name'],'VoiceQueueId':_0x1d2258['id'],'interface':_['isNil'](_0x5744b9[_0xa7c1('0x7e')])?util['format'](_0xa7c1('0x7f'),_0x5744b9[_0xa7c1('0x35')]):_0x5744b9['interface'],'paused':_0x5744b9[_0xa7c1('0x80')]||![],'penalty':_0x5744b9[_0xa7c1('0x77')]},{'transaction':_0x21f025});});})[_0xa7c1('0x2b')](function(){_0x13e6fd[_0xa7c1('0x76')](function(_0x510075){socket['emit'](_0xa7c1('0x81'),{'UserId':_0x510075['id'],'VoiceQueueId':_0x1d2258['id']});});});});});}})[_0xa7c1('0x2b')](respondWithStatusCode(_0x4288da,null))[_0xa7c1('0x53')](handleError(_0x4288da,null));};exports[_0xa7c1('0x82')]=function(_0xab38c3,_0x1387f5,_0x242245){return db[_0xa7c1('0x6f')][_0xa7c1('0x51')]({'where':{'id':_0xab38c3[_0xa7c1('0x3f')][_0xa7c1('0x83')]},'attributes':['id'],'include':[{'model':db[_0xa7c1('0x84')],'as':'Agents','attributes':['id'],'raw':!![]}]})[_0xa7c1('0x2b')](handleEntityNotFound(_0x1387f5,null))[_0xa7c1('0x2b')](function(_0x2a605f){var _0x3a5476=_[_0xa7c1('0x31')](_0x2a605f,'id');var _0x4c27f7=[];var _0x37564e=[];var _0xae15ad=squel[_0xa7c1('0x85')]();_0xae15ad[_0xa7c1('0x86')]('tq.TeamId')[_0xa7c1('0x87')](_0xa7c1('0x88'),'tq')[_0xa7c1('0x89')](_0xa7c1('0x8a'),'ut',_0xa7c1('0x8b'))[_0xa7c1('0x49')](_0xa7c1('0x8c'),_0xab38c3['params']['id']);for(var _0x5020d9=0x0;_0x5020d9<_0x2a605f[_0xa7c1('0x44')];_0x5020d9+=0x1){let _0x33a100=_0x2a605f[_0x5020d9];for(var _0x5769da=0x0;_0x5769da<_0x33a100['Agents'][_0xa7c1('0x44')];_0x5769da+=0x1){let _0x2703aa=_0x33a100[_0xa7c1('0x73')][_0x5769da];var _0x36077c=_0xae15ad[_0xa7c1('0x60')]();_0x36077c[_0xa7c1('0x49')]('ut.UserId\x20=\x20?',_0x2703aa['id']);_0x37564e['push'](db['sequelize'][_0xa7c1('0x3f')](_0x36077c['toString'](),{'type':db['sequelize'][_0xa7c1('0x8d')][_0xa7c1('0x8e')]})[_0xa7c1('0x2b')](function(_0x21a1df){if(_0x21a1df['length']===0x1){return _0x2703aa['id'];}else{var _0x749781=_[_0xa7c1('0x8f')](_[_0xa7c1('0x31')](_0x21a1df,_0xa7c1('0x90')),function(_0x123ba2){return _[_0xa7c1('0x33')](_0x3a5476,_0x123ba2);});if(_0x749781){return _0x2703aa['id'];}}}));}}return BPromise[_0xa7c1('0x91')](_0x37564e)[_0xa7c1('0x2b')](function(_0x5da6a0){_0x4c27f7=_(_0x4c27f7)['union'](_0x5da6a0)[_0xa7c1('0x92')]()[_0xa7c1('0x32')]();return db[_0xa7c1('0x50')][_0xa7c1('0x5c')]({'where':{'id':_0xab38c3[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](function(_0x48d695){return db['sequelize'][_0xa7c1('0x78')](function(_0xbef497){return _0x48d695[_0xa7c1('0x82')](_0xab38c3[_0xa7c1('0x3f')][_0xa7c1('0x83')],{'transaction':_0xbef497})[_0xa7c1('0x2b')](function(){if(!_['isEmpty'](_0x4c27f7)){return _0x48d695['removeAgents'](_0x4c27f7,{'transaction':_0xbef497})[_0xa7c1('0x2b')](function(){return db[_0xa7c1('0x7d')]['destroy']({'where':{'VoiceQueueId':_0xab38c3[_0xa7c1('0x55')]['id'],'UserId':_0x4c27f7},'transaction':_0xbef497});});}})[_0xa7c1('0x2b')](function(){_0x4c27f7[_0xa7c1('0x76')](function(_0x317000){socket['emit'](_0xa7c1('0x93'),{'UserId':_0x317000,'VoiceQueueId':_0x48d695['id']});});});});});});})[_0xa7c1('0x2b')](respondWithStatusCode(_0x1387f5,null))[_0xa7c1('0x53')](handleError(_0x1387f5,null));};exports[_0xa7c1('0x94')]=function(_0x3aa4a7,_0x334a2b,_0x3459d2){var _0x5c3879,_0x141a73;return db[_0xa7c1('0x50')][_0xa7c1('0x5c')]({'where':{'id':_0x3aa4a7[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x334a2b,null))[_0xa7c1('0x2b')](function(_0x323b4e){if(_0x323b4e){_0x141a73=_0x323b4e;return _0x323b4e['addAgents'](_0x3aa4a7[_0xa7c1('0x57')][_0xa7c1('0x83')],_[_0xa7c1('0x63')](_0x3aa4a7[_0xa7c1('0x57')],[_0xa7c1('0x83'),'id'])||{})[_0xa7c1('0x95')](function(_0x9a3a58){for(var _0x663f02=0x0;_0x663f02<_0x3aa4a7[_0xa7c1('0x57')][_0xa7c1('0x83')]['length'];_0x663f02+=0x1){socket[_0xa7c1('0x96')]('userVoiceQueue:save',{'UserId':Number(_0x3aa4a7[_0xa7c1('0x57')][_0xa7c1('0x83')][_0x663f02]),'VoiceQueueId':Number(_0x3aa4a7[_0xa7c1('0x55')]['id'])});}return _0x9a3a58;});}})[_0xa7c1('0x2b')](function(_0x283a9d){_0x5c3879=_0x283a9d||[];if(_0x141a73){return db[_0xa7c1('0x84')][_0xa7c1('0x51')]({'where':{'id':_0x3aa4a7['body']['ids']},'attributes':['id',_0xa7c1('0x35'),_0xa7c1('0x74'),'voicePause','interface'],'raw':!![]});}})[_0xa7c1('0x2b')](function(_0x514fee){if(!_['isEmpty'](_0x514fee)){var _0x4789a7=[];for(var _0x576b06=0x0;_0x576b06<_0x514fee[_0xa7c1('0x44')];_0x576b06++){if(_0x514fee[_0x576b06][_0xa7c1('0x74')]){_0x4789a7[_0xa7c1('0x97')](db[_0xa7c1('0x7d')]['upsert']({'membername':_0x514fee[_0x576b06][_0xa7c1('0x35')],'UserId':_0x514fee[_0x576b06]['id'],'queue_name':_0x141a73[_0xa7c1('0x35')],'VoiceQueueId':_0x141a73['id'],'interface':_[_0xa7c1('0x98')](_0x514fee[_0x576b06][_0xa7c1('0x7e')])?util[_0xa7c1('0x99')]('SIP/%s',_0x514fee[_0x576b06][_0xa7c1('0x35')]):_0x514fee[_0x576b06][_0xa7c1('0x7e')],'paused':_0x514fee[_0x576b06]['voicePause']||![],'penalty':_0x3aa4a7[_0xa7c1('0x57')][_0xa7c1('0x77')]||0x0}));}}return BPromise[_0xa7c1('0x91')](_0x4789a7);}})[_0xa7c1('0x2b')](function(){return _0x5c3879;})[_0xa7c1('0x2b')](respondWithResult(_0x334a2b,null))[_0xa7c1('0x53')](handleError(_0x334a2b,null));};exports[_0xa7c1('0x9a')]=function(_0x38361f,_0x221166,_0x5f35ad){return db[_0xa7c1('0x50')][_0xa7c1('0x5c')]({'where':{'id':_0x38361f[_0xa7c1('0x55')]['id']}})['then'](handleEntityNotFound(_0x221166,null))['then'](function(_0x50becc){if(_0x50becc){return _0x50becc[_0xa7c1('0x9a')](_0x38361f['query'][_0xa7c1('0x83')])['then'](function(){if(_[_0xa7c1('0x9b')](_0x38361f[_0xa7c1('0x3f')]['ids'])){for(var _0x2a47cf=0x0;_0x2a47cf<_0x38361f['query']['ids'][_0xa7c1('0x44')];_0x2a47cf+=0x1){socket[_0xa7c1('0x96')](_0xa7c1('0x93'),{'UserId':Number(_0x38361f[_0xa7c1('0x3f')]['ids'][_0x2a47cf]),'VoiceQueueId':Number(_0x38361f['params']['id'])});}}else{socket[_0xa7c1('0x96')](_0xa7c1('0x93'),{'UserId':Number(_0x38361f[_0xa7c1('0x3f')]['ids']),'VoiceQueueId':Number(_0x38361f[_0xa7c1('0x55')]['id'])});}});}})[_0xa7c1('0x2b')](function(_0xff25a0){return db[_0xa7c1('0x7d')]['destroy']({'where':{'VoiceQueueId':_0x38361f['params']['id'],'UserId':_0x38361f['query'][_0xa7c1('0x83')]}})['then'](function(){return _0xff25a0;});})[_0xa7c1('0x2b')](respondWithStatusCode(_0x221166,null))[_0xa7c1('0x53')](handleError(_0x221166,null));};exports[_0xa7c1('0x9c')]=function(_0x4dd889,_0x1b5f9a,_0x5591c7){var _0xac829d={};var _0x189f06={};var _0x48a6d8;var _0x468dc6;return db[_0xa7c1('0x50')][_0xa7c1('0x67')]({'where':{'id':_0x4dd889[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x1b5f9a,null))[_0xa7c1('0x2b')](function(_0x1b72af){if(_0x1b72af){_0x48a6d8=_0x1b72af;_0x189f06[_0xa7c1('0x3d')]=_['keys'](db[_0xa7c1('0x84')][_0xa7c1('0x56')]);_0x189f06[_0xa7c1('0x3f')]=_['keys'](_0x4dd889[_0xa7c1('0x3f')]);_0x189f06['filters']=_[_0xa7c1('0x41')](_0x189f06[_0xa7c1('0x3d')],_0x189f06['query']);_0xac829d['attributes']=_[_0xa7c1('0x41')](_0x189f06[_0xa7c1('0x3d')],qs['fields'](_0x4dd889[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0xac829d[_0xa7c1('0x43')]=_0xac829d[_0xa7c1('0x43')][_0xa7c1('0x44')]?_0xac829d[_0xa7c1('0x43')]:_0x189f06[_0xa7c1('0x3d')];_0xac829d['order']=qs[_0xa7c1('0x48')](_0x4dd889[_0xa7c1('0x3f')][_0xa7c1('0x48')]);_0xac829d[_0xa7c1('0x49')]=qs[_0xa7c1('0x40')](_[_0xa7c1('0x4a')](_0x4dd889[_0xa7c1('0x3f')],_0x189f06[_0xa7c1('0x40')]));if(_0x4dd889[_0xa7c1('0x3f')][_0xa7c1('0x2f')]){_0xac829d[_0xa7c1('0x49')]=_[_0xa7c1('0x4b')](_0xac829d['where'],{'$or':_[_0xa7c1('0x31')](_0xac829d['attributes'],function(_0x566db5){var _0x1d2b08={};_0x1d2b08[_0x566db5]={'$like':'%'+_0x4dd889['query'][_0xa7c1('0x2f')]+'%'};return _0x1d2b08;})});}_0xac829d=_[_0xa7c1('0x4b')]({},_0xac829d,_0x4dd889[_0xa7c1('0x4d')]);return _0x48a6d8[_0xa7c1('0x9c')](_0xac829d);}})['then'](function(_0x65f542){if(_0x65f542){_0x468dc6=_0x65f542[_0xa7c1('0x44')];if(!_0x4dd889[_0xa7c1('0x3f')][_0xa7c1('0x45')]('nolimit')){_0xac829d[_0xa7c1('0x22')]=qs[_0xa7c1('0x22')](_0x4dd889[_0xa7c1('0x3f')][_0xa7c1('0x22')]);_0xac829d[_0xa7c1('0x24')]=qs['offset'](_0x4dd889[_0xa7c1('0x3f')]['offset']);}return _0x48a6d8[_0xa7c1('0x9c')](_0xac829d);}})[_0xa7c1('0x2b')](function(_0x54e4f7){if(_0x54e4f7){return _0x54e4f7?{'count':_0x468dc6,'rows':_0x54e4f7}:null;}})[_0xa7c1('0x2b')](respondWithResult(_0x1b5f9a,null))[_0xa7c1('0x53')](handleError(_0x1b5f9a,null));};exports['getMembers']=function(_0x2b6232,_0x5cb7a4,_0x57699f){var _0x93c465={};var _0x1798d={};var _0x1a0f60;var _0x214c7b;return db[_0xa7c1('0x50')]['findOne']({'where':{'id':_0x2b6232['params']['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x5cb7a4,null))[_0xa7c1('0x2b')](function(_0x1cf1ec){if(_0x1cf1ec){_0x1a0f60=_0x1cf1ec;_0x1798d[_0xa7c1('0x3d')]=_[_0xa7c1('0x3e')](db[_0xa7c1('0x7d')][_0xa7c1('0x56')]);_0x1798d[_0xa7c1('0x3f')]=_[_0xa7c1('0x3e')](_0x2b6232['query']);_0x1798d[_0xa7c1('0x40')]=_[_0xa7c1('0x41')](_0x1798d['model'],_0x1798d[_0xa7c1('0x3f')]);_0x93c465[_0xa7c1('0x43')]=_['intersection'](_0x1798d[_0xa7c1('0x3d')],qs[_0xa7c1('0x42')](_0x2b6232[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0x93c465[_0xa7c1('0x43')]=_0x93c465[_0xa7c1('0x43')][_0xa7c1('0x44')]?_0x93c465['attributes']:_0x1798d[_0xa7c1('0x3d')];_0x93c465[_0xa7c1('0x47')]=qs[_0xa7c1('0x48')](_0x2b6232['query'][_0xa7c1('0x48')]);_0x93c465[_0xa7c1('0x49')]=qs['filters'](_[_0xa7c1('0x4a')](_0x2b6232[_0xa7c1('0x3f')],_0x1798d['filters']));if(_0x2b6232[_0xa7c1('0x3f')][_0xa7c1('0x2f')]){_0x93c465['where']=_['merge'](_0x93c465[_0xa7c1('0x49')],{'$or':_[_0xa7c1('0x31')](_0x93c465[_0xa7c1('0x43')],function(_0x4db8c5){var _0x18c28b={};_0x18c28b[_0x4db8c5]={'$like':'%'+_0x2b6232[_0xa7c1('0x3f')][_0xa7c1('0x2f')]+'%'};return _0x18c28b;})});}_0x93c465=_[_0xa7c1('0x4b')]({},_0x93c465,_0x2b6232[_0xa7c1('0x4d')]);return _0x1a0f60['getMembers'](_0x93c465);}})[_0xa7c1('0x2b')](function(_0x9d1ce8){if(_0x9d1ce8){_0x214c7b=_0x9d1ce8[_0xa7c1('0x44')];if(!_0x2b6232[_0xa7c1('0x3f')][_0xa7c1('0x45')]('nolimit')){_0x93c465[_0xa7c1('0x22')]=qs[_0xa7c1('0x22')](_0x2b6232[_0xa7c1('0x3f')]['limit']);_0x93c465[_0xa7c1('0x24')]=qs['offset'](_0x2b6232[_0xa7c1('0x3f')][_0xa7c1('0x24')]);}return _0x1a0f60[_0xa7c1('0x9d')](_0x93c465);}})['then'](function(_0x21bab7){return _0x21bab7?{'count':_0x214c7b,'rows':_0x21bab7}:null;})[_0xa7c1('0x2b')](respondWithResult(_0x5cb7a4,null))[_0xa7c1('0x53')](handleError(_0x5cb7a4,null));};exports['getLists']=function(_0x63208b,_0x1aaece,_0x41b242){var _0x246bb8={};var _0x5828c4={};var _0x4a7ce8;var _0x1e5104;return db[_0xa7c1('0x50')]['findOne']({'where':{'id':_0x63208b[_0xa7c1('0x55')]['id']}})['then'](handleEntityNotFound(_0x1aaece,null))[_0xa7c1('0x2b')](function(_0x2c28f1){if(_0x2c28f1){_0x4a7ce8=_0x2c28f1;_0x5828c4[_0xa7c1('0x3d')]=_[_0xa7c1('0x3e')](db[_0xa7c1('0x9e')][_0xa7c1('0x56')]);_0x5828c4['query']=_['keys'](_0x63208b[_0xa7c1('0x3f')]);_0x5828c4[_0xa7c1('0x40')]=_[_0xa7c1('0x41')](_0x5828c4[_0xa7c1('0x3d')],_0x5828c4[_0xa7c1('0x3f')]);_0x246bb8['attributes']=_[_0xa7c1('0x41')](_0x5828c4[_0xa7c1('0x3d')],qs[_0xa7c1('0x42')](_0x63208b[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0x246bb8[_0xa7c1('0x43')]=_0x246bb8['attributes']['length']?_0x246bb8[_0xa7c1('0x43')]:_0x5828c4[_0xa7c1('0x3d')];_0x246bb8[_0xa7c1('0x47')]=qs['sort'](_0x63208b[_0xa7c1('0x3f')]['sort']);_0x246bb8[_0xa7c1('0x49')]=qs[_0xa7c1('0x40')](_['pick'](_0x63208b[_0xa7c1('0x3f')],_0x5828c4['filters']));if(_0x63208b[_0xa7c1('0x3f')][_0xa7c1('0x2f')]){_0x246bb8['where']=_['merge'](_0x246bb8[_0xa7c1('0x49')],{'$or':_[_0xa7c1('0x31')](_0x246bb8[_0xa7c1('0x43')],function(_0x46e935){var _0x260557={};_0x260557[_0x46e935]={'$like':'%'+_0x63208b[_0xa7c1('0x3f')]['filter']+'%'};return _0x260557;})});}_0x246bb8=_[_0xa7c1('0x4b')]({},_0x246bb8,_0x63208b[_0xa7c1('0x4d')]);return _0x4a7ce8[_0xa7c1('0x9f')](_0x246bb8);}})[_0xa7c1('0x2b')](function(_0x1c96d7){if(_0x1c96d7){_0x1e5104=_0x1c96d7['length'];if(!_0x63208b[_0xa7c1('0x3f')][_0xa7c1('0x45')]('nolimit')){_0x246bb8['limit']=qs[_0xa7c1('0x22')](_0x63208b[_0xa7c1('0x3f')][_0xa7c1('0x22')]);_0x246bb8[_0xa7c1('0x24')]=qs[_0xa7c1('0x24')](_0x63208b['query']['offset']);}return _0x4a7ce8[_0xa7c1('0x9f')](_0x246bb8);}})[_0xa7c1('0x2b')](function(_0x47c4ad){if(_0x47c4ad){return _0x47c4ad?{'count':_0x1e5104,'rows':_0x47c4ad}:null;}})['then'](respondWithResult(_0x1aaece,null))[_0xa7c1('0x53')](handleError(_0x1aaece,null));};exports[_0xa7c1('0xa0')]=function(_0x20aab8,_0x45caa,_0x3c377d){var _0x1a06a2=moment()['format'](_0xa7c1('0xa1'));var _0x12eda0,_0x1fa9f5;return db['VoiceQueue']['find']({'where':{'id':_0x20aab8[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x45caa,null))['then'](function(_0x576cd2){if(_0x576cd2){_0x1fa9f5=_0x576cd2;return _0x576cd2['addLists'](_0x20aab8[_0xa7c1('0x57')][_0xa7c1('0x83')],_[_0xa7c1('0x63')](_0x20aab8[_0xa7c1('0x57')],[_0xa7c1('0x83'),'id'])||{});}return null;})[_0xa7c1('0x95')](function(_0x3c9193){var _0x54327f;_0x12eda0=_0x3c9193||[];var _0x4f48bd=[];if(_0x3c9193){for(var _0x210440=0x0;_0x210440<_0x3c9193[_0xa7c1('0x44')];_0x210440+=0x1){var _0x367aa6=_0x3c9193[_0x210440][_0xa7c1('0x59')]({'plain':!![]});_0x1fa9f5[_0xa7c1('0xa2')]=_0x20aab8[_0xa7c1('0x57')][_0xa7c1('0xa2')]?_0x20aab8[_0xa7c1('0x57')][_0xa7c1('0xa2')]:_0x1fa9f5['dialCheckDuplicateType'];switch(_0x1fa9f5[_0xa7c1('0xa2')]){case'always':_0x54327f=squel[_0xa7c1('0xa3')]()[_0xa7c1('0xa4')]('cm_hopper')['fromQuery']([_0xa7c1('0xa5'),_0xa7c1('0xa6'),_0xa7c1('0xa7'),_0xa7c1('0xa8'),'VoiceQueueId',_0xa7c1('0x61'),_0xa7c1('0x62')],squel[_0xa7c1('0x85')]()[_0xa7c1('0x86')](_0xa7c1('0xa5'),_0xa7c1('0xa5'))['field']('\x27'+_0x1a06a2+'\x27',_0xa7c1('0xa6'))['field']('id',_0xa7c1('0xa7'))['field'](_0x367aa6[_0xa7c1('0xa9')]['toString'](),_0xa7c1('0xa8'))[_0xa7c1('0x86')](_0x20aab8['params']['id']['toString'](),'VoiceQueueId')[_0xa7c1('0x86')]('\x27'+_0x1a06a2+'\x27',_0xa7c1('0x61'))[_0xa7c1('0x86')]('\x27'+_0x1a06a2+'\x27',_0xa7c1('0x62'))['from'](_0xa7c1('0xaa'))[_0xa7c1('0x49')]('deletedAt\x20IS\x20NULL')[_0xa7c1('0x49')](_0xa7c1('0xab'),_0x367aa6[_0xa7c1('0xa9')][_0xa7c1('0xac')]())[_0xa7c1('0x49')](_0xa7c1('0xad'))[_0xa7c1('0x49')]('phone\x20NOT\x20IN\x20(?)',squel[_0xa7c1('0x85')]()[_0xa7c1('0x86')]('COALESCE(calleridnum,\x27\x27)')[_0xa7c1('0x87')](_0xa7c1('0xae'))['where']('VoiceQueueId\x20=\x20?',_0x20aab8[_0xa7c1('0x55')]['id'][_0xa7c1('0xac')]()))[_0xa7c1('0x49')](_0xa7c1('0xaf'),squel[_0xa7c1('0x85')]()[_0xa7c1('0x86')](_0xa7c1('0xb0'))['from'](_0xa7c1('0xb1'))[_0xa7c1('0x49')](_0xa7c1('0x8c'),_0x20aab8[_0xa7c1('0x55')]['id'][_0xa7c1('0xac')]())))[_0xa7c1('0xac')]();break;case _0xa7c1('0xb2'):_0x54327f=squel['insert']()['into'](_0xa7c1('0xb1'))[_0xa7c1('0xb3')]([_0xa7c1('0xa5'),'scheduledAt',_0xa7c1('0xa7'),_0xa7c1('0xa8'),_0xa7c1('0x6a'),'createdAt',_0xa7c1('0x62')],squel[_0xa7c1('0x85')]()[_0xa7c1('0x86')](_0xa7c1('0xa5'),_0xa7c1('0xa5'))[_0xa7c1('0x86')]('\x27'+_0x1a06a2+'\x27',_0xa7c1('0xa6'))[_0xa7c1('0x86')]('id',_0xa7c1('0xa7'))[_0xa7c1('0x86')](_0x367aa6['CmListId'][_0xa7c1('0xac')](),'ListId')[_0xa7c1('0x86')](_0x20aab8[_0xa7c1('0x55')]['id'][_0xa7c1('0xac')](),_0xa7c1('0x6a'))[_0xa7c1('0x86')]('\x27'+_0x1a06a2+'\x27',_0xa7c1('0x61'))[_0xa7c1('0x86')]('\x27'+_0x1a06a2+'\x27',_0xa7c1('0x62'))[_0xa7c1('0x87')](_0xa7c1('0xaa'))[_0xa7c1('0x49')](_0xa7c1('0xb4'))[_0xa7c1('0x49')]('ListId\x20=\x20?',_0x367aa6[_0xa7c1('0xa9')]['toString']())[_0xa7c1('0x49')](_0xa7c1('0xad'))[_0xa7c1('0x49')](_0xa7c1('0xaf'),squel[_0xa7c1('0x85')]()['field'](_0xa7c1('0xb0'))[_0xa7c1('0x87')]('cm_hopper')[_0xa7c1('0x49')](_0xa7c1('0x8c'),_0x20aab8[_0xa7c1('0x55')]['id'][_0xa7c1('0xac')]())))[_0xa7c1('0xac')]();break;default:_0x54327f=squel[_0xa7c1('0xa3')]()[_0xa7c1('0xa4')]('cm_hopper')[_0xa7c1('0xb3')]([_0xa7c1('0xa5'),'scheduledAt',_0xa7c1('0xa7'),_0xa7c1('0xa8'),_0xa7c1('0x6a'),_0xa7c1('0x61'),_0xa7c1('0x62')],squel['select']()[_0xa7c1('0x86')](_0xa7c1('0xa5'),'phone')[_0xa7c1('0x86')]('\x27'+_0x1a06a2+'\x27',_0xa7c1('0xa6'))[_0xa7c1('0x86')]('id',_0xa7c1('0xa7'))['field'](_0x367aa6[_0xa7c1('0xa9')][_0xa7c1('0xac')](),_0xa7c1('0xa8'))[_0xa7c1('0x86')](_0x20aab8[_0xa7c1('0x55')]['id'][_0xa7c1('0xac')](),'VoiceQueueId')['field']('\x27'+_0x1a06a2+'\x27',_0xa7c1('0x61'))[_0xa7c1('0x86')]('\x27'+_0x1a06a2+'\x27',_0xa7c1('0x62'))[_0xa7c1('0x87')]('cm_contacts')[_0xa7c1('0x49')](_0xa7c1('0xb4'))[_0xa7c1('0x49')]('ListId\x20=\x20?',_0x367aa6[_0xa7c1('0xa9')][_0xa7c1('0xac')]())[_0xa7c1('0x49')](_0xa7c1('0xad')))['toString']();}_0x4f48bd['push'](db['sequelize'][_0xa7c1('0x3f')](_0x54327f));}return BPromise[_0xa7c1('0x91')](_0x4f48bd);}})['then'](function(){var _0x51be31=[];var _0x5c0c0f=squel[_0xa7c1('0xa3')]()[_0xa7c1('0xa4')]('cm_hopper_additional_phones')['fromQuery'](['CmHopperId',_0xa7c1('0xa5'),_0xa7c1('0xb5'),'createdAt',_0xa7c1('0x62')],squel['select']()[_0xa7c1('0x86')](_0xa7c1('0xb6'))[_0xa7c1('0x86')](_0xa7c1('0xb7'))['field'](_0xa7c1('0xb8'))[_0xa7c1('0x86')]('\x27'+_0x1a06a2+'\x27',_0xa7c1('0x61'))['field']('\x27'+_0x1a06a2+'\x27','updatedAt')['from']('cm_contact_has_items','ci')[_0xa7c1('0x89')](_0xa7c1('0xb1'),'h',_0xa7c1('0xb9'))['where'](_0xa7c1('0xba'),_0x1a06a2)['where']('ci.ItemClass=?',_0xa7c1('0xbb')))['toString']();_0x51be31[_0xa7c1('0x97')](db['sequelize'][_0xa7c1('0x3f')](_0x5c0c0f));return BPromise[_0xa7c1('0x91')](_0x51be31);})[_0xa7c1('0x2b')](function(){return _0x12eda0;})['then'](respondWithResult(_0x45caa,null))[_0xa7c1('0x53')](handleError(_0x45caa,null));};exports[_0xa7c1('0xbc')]=function(_0x509d7f,_0x29feb8,_0x96ed4b){return db['VoiceQueue'][_0xa7c1('0x5c')]({'where':{'id':_0x509d7f['params']['id']}})['then'](handleEntityNotFound(_0x29feb8,null))[_0xa7c1('0x2b')](function(_0x3c50aa){if(_0x3c50aa){return _0x3c50aa[_0xa7c1('0xbc')](_0x509d7f[_0xa7c1('0x3f')][_0xa7c1('0x83')]);}})[_0xa7c1('0x2b')](function(_0x4ae649){if(_0x4ae649){return db['CmHopper']['destroy']({'where':{'ListId':_0x509d7f[_0xa7c1('0x3f')][_0xa7c1('0x83')],'VoiceQueueId':_0x509d7f[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](function(){return _0x4ae649;});}})[_0xa7c1('0x2b')](respondWithStatusCode(_0x29feb8,null))[_0xa7c1('0x53')](handleError(_0x29feb8,null));};exports[_0xa7c1('0xbd')]=function(_0x2c965e,_0x3531d0,_0x484dd3){var _0x494fc0={};var _0xeaa87a={};var _0x3c86be;var _0x3cd165;return db['VoiceQueue'][_0xa7c1('0x67')]({'where':{'id':_0x2c965e['params']['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x3531d0,null))[_0xa7c1('0x2b')](function(_0x14b678){if(_0x14b678){_0x3c86be=_0x14b678;_0xeaa87a[_0xa7c1('0x3d')]=_['keys'](db[_0xa7c1('0x9e')]['rawAttributes']);_0xeaa87a[_0xa7c1('0x3f')]=_[_0xa7c1('0x3e')](_0x2c965e[_0xa7c1('0x3f')]);_0xeaa87a['filters']=_[_0xa7c1('0x41')](_0xeaa87a[_0xa7c1('0x3d')],_0xeaa87a[_0xa7c1('0x3f')]);_0x494fc0[_0xa7c1('0x43')]=_['intersection'](_0xeaa87a[_0xa7c1('0x3d')],qs['fields'](_0x2c965e[_0xa7c1('0x3f')][_0xa7c1('0x42')]));_0x494fc0[_0xa7c1('0x43')]=_0x494fc0['attributes'][_0xa7c1('0x44')]?_0x494fc0[_0xa7c1('0x43')]:_0xeaa87a['model'];_0x494fc0[_0xa7c1('0x47')]=qs[_0xa7c1('0x48')](_0x2c965e[_0xa7c1('0x3f')][_0xa7c1('0x48')]);_0x494fc0[_0xa7c1('0x49')]=qs['filters'](_[_0xa7c1('0x4a')](_0x2c965e[_0xa7c1('0x3f')],_0xeaa87a[_0xa7c1('0x40')]));if(_0x2c965e[_0xa7c1('0x3f')][_0xa7c1('0x2f')]){_0x494fc0['where']=_[_0xa7c1('0x4b')](_0x494fc0[_0xa7c1('0x49')],{'$or':_[_0xa7c1('0x31')](_0x494fc0['attributes'],function(_0x53d8e4){var _0x52dfdc={};_0x52dfdc[_0x53d8e4]={'$like':'%'+_0x2c965e[_0xa7c1('0x3f')][_0xa7c1('0x2f')]+'%'};return _0x52dfdc;})});}_0x494fc0=_[_0xa7c1('0x4b')]({},_0x494fc0,_0x2c965e[_0xa7c1('0x4d')]);return _0x3c86be[_0xa7c1('0xbd')](_0x494fc0);}})['then'](function(_0xfd1886){if(_0xfd1886){_0x3cd165=_0xfd1886[_0xa7c1('0x44')];if(!_0x2c965e[_0xa7c1('0x3f')][_0xa7c1('0x45')](_0xa7c1('0x46'))){_0x494fc0[_0xa7c1('0x22')]=qs['limit'](_0x2c965e[_0xa7c1('0x3f')][_0xa7c1('0x22')]);_0x494fc0[_0xa7c1('0x24')]=qs[_0xa7c1('0x24')](_0x2c965e[_0xa7c1('0x3f')]['offset']);}return _0x3c86be[_0xa7c1('0xbd')](_0x494fc0);}})[_0xa7c1('0x2b')](function(_0x5e2af5){if(_0x5e2af5){return _0x5e2af5?{'count':_0x3cd165,'rows':_0x5e2af5}:null;}})['then'](respondWithResult(_0x3531d0,null))['catch'](handleError(_0x3531d0,null));};exports[_0xa7c1('0xbe')]=function(_0x2fe2a4,_0x180f20,_0x11eb33){var _0x30181f,_0xd7700f;return db['VoiceQueue'][_0xa7c1('0x5c')]({'where':{'id':_0x2fe2a4[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x180f20,null))[_0xa7c1('0x2b')](function(_0x5e45e6){if(_0x5e45e6){_0xd7700f=_0x5e45e6;return _0x5e45e6[_0xa7c1('0xbe')](_0x2fe2a4['body'][_0xa7c1('0x83')],_[_0xa7c1('0x63')](_0x2fe2a4[_0xa7c1('0x57')],['ids','id'])||{});}return null;})['spread'](function(_0x15512f){var _0x2b1bf6;_0x30181f=_0x15512f||[];var _0x524e0f=[];if(_0x15512f){for(var _0x89d41c=0x0;_0x89d41c<_0x15512f[_0xa7c1('0x44')];_0x89d41c+=0x1){var _0x1c69c2=_0x15512f[_0x89d41c][_0xa7c1('0x59')]({'plain':!![]});_0x2b1bf6=squel['insert']()[_0xa7c1('0xa4')](_0xa7c1('0xbf'))[_0xa7c1('0xb3')](['phone',_0xa7c1('0xa7'),_0xa7c1('0xa8'),_0xa7c1('0x6a'),_0xa7c1('0x61'),'updatedAt'],squel[_0xa7c1('0x85')]()[_0xa7c1('0x86')](_0xa7c1('0xa5'),_0xa7c1('0xa5'))[_0xa7c1('0x86')]('id',_0xa7c1('0xa7'))[_0xa7c1('0x86')](_0x1c69c2[_0xa7c1('0xa9')][_0xa7c1('0xac')](),'ListId')[_0xa7c1('0x86')](_0x2fe2a4[_0xa7c1('0x55')]['id'][_0xa7c1('0xac')](),_0xa7c1('0x6a'))['field'](_0xa7c1('0xc0'),'createdAt')[_0xa7c1('0x86')](_0xa7c1('0xc0'),'updatedAt')[_0xa7c1('0x87')]('cm_contacts')[_0xa7c1('0x49')](_0xa7c1('0xb4'))[_0xa7c1('0x49')](_0xa7c1('0xab'),_0x1c69c2[_0xa7c1('0xa9')]['toString']())[_0xa7c1('0x49')]('phone\x20IS\x20NOT\x20NULL'))[_0xa7c1('0xac')]();_0x524e0f[_0xa7c1('0x97')](db[_0xa7c1('0xc1')][_0xa7c1('0x3f')](_0x2b1bf6));}return BPromise[_0xa7c1('0x91')](_0x524e0f);}})[_0xa7c1('0x2b')](function(){return _0x30181f;})[_0xa7c1('0x2b')](respondWithResult(_0x180f20,null))[_0xa7c1('0x53')](handleError(_0x180f20,null));};exports[_0xa7c1('0xc2')]=function(_0x5609bd,_0x4b5849,_0x2912b3){return db[_0xa7c1('0x50')][_0xa7c1('0x5c')]({'where':{'id':_0x5609bd['params']['id']}})[_0xa7c1('0x2b')](handleEntityNotFound(_0x4b5849,null))[_0xa7c1('0x2b')](function(_0x36d5bb){if(_0x36d5bb){return _0x36d5bb[_0xa7c1('0xc2')](_0x5609bd['query'][_0xa7c1('0x83')]);}})[_0xa7c1('0x2b')](function(_0x34c722){if(_0x34c722){return db['CmHopperBlack'][_0xa7c1('0x2a')]({'where':{'ListId':_0x5609bd[_0xa7c1('0x3f')][_0xa7c1('0x83')],'VoiceQueueId':_0x5609bd[_0xa7c1('0x55')]['id']}})[_0xa7c1('0x2b')](function(){return _0x34c722;});}})['then'](respondWithStatusCode(_0x4b5849,null))['catch'](handleError(_0x4b5849,null));};