Built motion from commit (unavailable).|2.5.31
[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 _0x2aff=['agent','account','index','VoiceQueue','rawAttributes','key','query','keys','filters','model','attributes','intersection','length','nolimit','sort','where','pick','filter','VIRTUAL','options','includeAll','findAll','rows','catch','show','fields','include','find','create','body','user','role','UserProfileSection','userProfileId','autoAssociation','params','omit','createdAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','inbound','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getHoppers','CmHopper','VoiceQueueId','CmHopperHistory','hasOwnProperty','getHopperFinals','findOne','CmHopperFinal','order','CmHopperBlack','getTeams','Team','addTeams','User','Agents','online','interface','flatMap','penalty','sequelize','transaction','each','TeamVoiceQueue','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','SIP/%s','voicePause','forEach','emit','userVoiceQueue:save','removeTeams','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','clone','ut.UserId\x20=\x20?','push','toString','SELECT','union','compact','ids','isEmpty','removeAgents','userVoiceQueue:remove','addAgents','spread','format','all','isArray','getAgents','getMembers','getLists','CmList','addLists','dialCheckDuplicateType','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','select','field','NOW()','CmListId','updatedAt','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','cm_hopper_final','COALESCE(phone,\x27\x27)','onlyIfOpen','cm_contacts','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','./voiceQueue.socket','sendStatus','json','offset','undefined','limit','count','set','apply','save','update','then','destroy','get','VoiceQueues','QueueCampaigns','outbound','ignore','map','value','includes','type','name','UserProfileResource','status','end','error','stack','send','render','merge','contact'];(function(_0x3da1eb,_0x3b50f1){var _0x3ccea2=function(_0x25daa9){while(--_0x25daa9){_0x3da1eb['push'](_0x3da1eb['shift']());}};_0x3ccea2(++_0x3b50f1);}(_0x2aff,0x82));var _0xf2af=function(_0x566608,_0x39e58c){_0x566608=_0x566608-0x0;var _0x449448=_0x2aff[_0x566608];return _0x449448;};'use strict';var emlformat=require(_0xf2af('0x0'));var rimraf=require(_0xf2af('0x1'));var zipdir=require(_0xf2af('0x2'));var jsonpatch=require(_0xf2af('0x3'));var rp=require(_0xf2af('0x4'));var moment=require(_0xf2af('0x5'));var BPromise=require(_0xf2af('0x6'));var Mustache=require(_0xf2af('0x7'));var util=require('util');var path=require('path');var sox=require(_0xf2af('0x8'));var csv=require(_0xf2af('0x9'));var ejs=require(_0xf2af('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xf2af('0xb'));var squel=require(_0xf2af('0xc'));var crypto=require(_0xf2af('0xd'));var jsforce=require(_0xf2af('0xe'));var deskjs=require(_0xf2af('0xf'));var toCsv=require(_0xf2af('0x9'));var querystring=require(_0xf2af('0x10'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xf2af('0x11'));var qs=require(_0xf2af('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xf2af('0x13'));var logger=require(_0xf2af('0x14'))(_0xf2af('0x15'));var utils=require(_0xf2af('0x16'));var config=require(_0xf2af('0x17'));var licenseUtil=require(_0xf2af('0x18'));var db=require(_0xf2af('0x19'))['db'];config['redis']=_['defaults'](config['redis'],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config['redis']));require(_0xf2af('0x1a'))['register'](socket);function respondWithStatusCode(_0x138c23,_0x3298f7){_0x3298f7=_0x3298f7||0xcc;return function(_0x155fbd){if(_0x155fbd){return _0x138c23[_0xf2af('0x1b')](_0x3298f7);}return _0x138c23['status'](_0x3298f7)['end']();};}function respondWithResult(_0xc0293c,_0x36f4ae){_0x36f4ae=_0x36f4ae||0xc8;return function(_0x57ccd3){if(_0x57ccd3){return _0xc0293c['status'](_0x36f4ae)[_0xf2af('0x1c')](_0x57ccd3);}};}function respondWithFilteredResult(_0x4cc627,_0x379b9a){return function(_0x44351c){if(_0x44351c){var _0x38b20a=typeof _0x379b9a[_0xf2af('0x1d')]===_0xf2af('0x1e')&&typeof _0x379b9a[_0xf2af('0x1f')]==='undefined';var _0x24f529=_0x44351c[_0xf2af('0x20')];var _0xc55b91=_0x38b20a?0x0:_0x379b9a['offset'];var _0x185750=_0x38b20a?_0x44351c[_0xf2af('0x20')]:_0x379b9a[_0xf2af('0x1d')]+_0x379b9a[_0xf2af('0x1f')];var _0x4b74bb;if(_0x185750>=_0x24f529){_0x185750=_0x24f529;_0x4b74bb=0xc8;}else{_0x4b74bb=0xce;}_0x4cc627['status'](_0x4b74bb);return _0x4cc627[_0xf2af('0x21')]('Content-Range',_0xc55b91+'-'+_0x185750+'/'+_0x24f529)[_0xf2af('0x1c')](_0x44351c);}return null;};}function patchUpdates(_0x2950ba){return function(_0x4db6b5){try{jsonpatch[_0xf2af('0x22')](_0x4db6b5,_0x2950ba,!![]);}catch(_0x49ece3){return BPromise['reject'](_0x49ece3);}return _0x4db6b5[_0xf2af('0x23')]();};}function saveUpdates(_0x58c01c,_0x55cb20){return function(_0x243651){if(_0x243651){return _0x243651[_0xf2af('0x24')](_0x58c01c)[_0xf2af('0x25')](function(_0x5b6c33){return _0x5b6c33;});}return null;};}function removeEntity(_0x3c1491,_0x7df536){return function(_0x5abbcb){if(_0x5abbcb){return _0x5abbcb[_0xf2af('0x26')]()[_0xf2af('0x25')](function(){var _0x3efc05=_0x5abbcb[_0xf2af('0x27')]({'plain':!![]});var _0x425822=[{'name':_0xf2af('0x28'),'value':'inbound','ignore':![]},{'name':_0xf2af('0x29'),'value':_0xf2af('0x2a'),'ignore':![]}];var _0x1a6d3c=_(_0x425822)['filter'](_0xf2af('0x2b'))[_0xf2af('0x2c')](_0xf2af('0x2d'))[_0xf2af('0x2d')]();if(_[_0xf2af('0x2e')](_0x1a6d3c,_0x3efc05['type'])){return;}var _0x569915=_['find'](_0x425822,[_0xf2af('0x2d'),_0x3efc05[_0xf2af('0x2f')]])[_0xf2af('0x30')];return db[_0xf2af('0x31')][_0xf2af('0x26')]({'where':{'type':_0x569915,'resourceId':_0x3efc05['id']}})[_0xf2af('0x25')](function(){return _0x5abbcb;});})[_0xf2af('0x25')](function(){_0x3c1491[_0xf2af('0x32')](0xcc)[_0xf2af('0x33')]();});}};}function handleEntityNotFound(_0x56d032,_0x833d9c){return function(_0x351f9d){if(!_0x351f9d){_0x56d032[_0xf2af('0x1b')](0x194);}return _0x351f9d;};}function handleError(_0x444dc0,_0x6184d4){_0x6184d4=_0x6184d4||0x1f4;return function(_0x11b9f0){logger[_0xf2af('0x34')](_0x11b9f0[_0xf2af('0x35')]);if(_0x11b9f0[_0xf2af('0x30')]){delete _0x11b9f0[_0xf2af('0x30')];}_0x444dc0[_0xf2af('0x32')](_0x6184d4)[_0xf2af('0x36')](_0x11b9f0);};}function getMustacheRender(_0xe958f0,_0x4c58e1){return Mustache[_0xf2af('0x37')](_0xe958f0,_[_0xf2af('0x38')](_0x4c58e1['body'],{'contact':_0x4c58e1[_0xf2af('0x39')],'message':_0x4c58e1['message'],'agent':_0x4c58e1[_0xf2af('0x3a')],'interaction':_0x4c58e1['interaction'],'account':_0x4c58e1[_0xf2af('0x3b')]}))||'';}exports[_0xf2af('0x3c')]=function(_0x28b0b1,_0x15f2eb){var _0xd6cd8f={},_0x47252b={},_0x1c9122={'count':0x0,'rows':[]};var _0x4bca60=_[_0xf2af('0x2c')](db[_0xf2af('0x3d')][_0xf2af('0x3e')],function(_0x29bf09){return{'name':_0x29bf09['fieldName'],'type':_0x29bf09[_0xf2af('0x2f')][_0xf2af('0x3f')]};});_0x47252b['model']=_['map'](_0x4bca60,_0xf2af('0x30'));_0x47252b[_0xf2af('0x40')]=_[_0xf2af('0x41')](_0x28b0b1[_0xf2af('0x40')]);_0x47252b[_0xf2af('0x42')]=_['intersection'](_0x47252b[_0xf2af('0x43')],_0x47252b[_0xf2af('0x40')]);_0xd6cd8f[_0xf2af('0x44')]=_[_0xf2af('0x45')](_0x47252b['model'],qs['fields'](_0x28b0b1['query']['fields']));_0xd6cd8f['attributes']=_0xd6cd8f[_0xf2af('0x44')][_0xf2af('0x46')]?_0xd6cd8f[_0xf2af('0x44')]:_0x47252b[_0xf2af('0x43')];if(!_0x28b0b1[_0xf2af('0x40')]['hasOwnProperty'](_0xf2af('0x47'))){_0xd6cd8f[_0xf2af('0x1f')]=qs[_0xf2af('0x1f')](_0x28b0b1[_0xf2af('0x40')]['limit']);_0xd6cd8f[_0xf2af('0x1d')]=qs[_0xf2af('0x1d')](_0x28b0b1['query'][_0xf2af('0x1d')]);}_0xd6cd8f['order']=qs[_0xf2af('0x48')](_0x28b0b1['query'][_0xf2af('0x48')]);_0xd6cd8f[_0xf2af('0x49')]=qs['filters'](_[_0xf2af('0x4a')](_0x28b0b1[_0xf2af('0x40')],_0x47252b[_0xf2af('0x42')]),_0x4bca60);if(_0x28b0b1[_0xf2af('0x40')][_0xf2af('0x4b')]){_0xd6cd8f[_0xf2af('0x49')]=_[_0xf2af('0x38')](_0xd6cd8f[_0xf2af('0x49')],{'$or':_[_0xf2af('0x2c')](_0x4bca60,function(_0x2e33d6){if(_0x2e33d6[_0xf2af('0x2f')]!==_0xf2af('0x4c')){var _0x21a024={};_0x21a024[_0x2e33d6[_0xf2af('0x30')]]={'$like':'%'+_0x28b0b1[_0xf2af('0x40')]['filter']+'%'};return _0x21a024;}})});}_0xd6cd8f=_[_0xf2af('0x38')]({},_0xd6cd8f,_0x28b0b1[_0xf2af('0x4d')]);var _0x71479f={'where':_0xd6cd8f['where']};return db[_0xf2af('0x3d')]['count'](_0x71479f)['then'](function(_0x16d1e8){_0x1c9122[_0xf2af('0x20')]=_0x16d1e8;if(_0x28b0b1['query'][_0xf2af('0x4e')]){_0xd6cd8f['include']=[{'all':!![]}];}return db[_0xf2af('0x3d')][_0xf2af('0x4f')](_0xd6cd8f);})[_0xf2af('0x25')](function(_0x2ecbd9){_0x1c9122[_0xf2af('0x50')]=_0x2ecbd9;return _0x1c9122;})[_0xf2af('0x25')](respondWithFilteredResult(_0x15f2eb,_0xd6cd8f))[_0xf2af('0x51')](handleError(_0x15f2eb,null));};exports[_0xf2af('0x52')]=function(_0x2f569b,_0x5125ca){var _0x563e41={'raw':![],'where':{'id':_0x2f569b['params']['id']}},_0x1e0ab2={};_0x1e0ab2[_0xf2af('0x43')]=_['keys'](db['VoiceQueue'][_0xf2af('0x3e')]);_0x1e0ab2[_0xf2af('0x40')]=_[_0xf2af('0x41')](_0x2f569b[_0xf2af('0x40')]);_0x1e0ab2[_0xf2af('0x42')]=_[_0xf2af('0x45')](_0x1e0ab2[_0xf2af('0x43')],_0x1e0ab2[_0xf2af('0x40')]);_0x563e41[_0xf2af('0x44')]=_[_0xf2af('0x45')](_0x1e0ab2['model'],qs[_0xf2af('0x53')](_0x2f569b[_0xf2af('0x40')][_0xf2af('0x53')]));_0x563e41['attributes']=_0x563e41['attributes'][_0xf2af('0x46')]?_0x563e41['attributes']:_0x1e0ab2[_0xf2af('0x43')];if(_0x2f569b[_0xf2af('0x40')]['includeAll']){_0x563e41[_0xf2af('0x54')]=[{'all':!![]}];}_0x563e41=_['merge']({},_0x563e41,_0x2f569b[_0xf2af('0x4d')]);return db[_0xf2af('0x3d')][_0xf2af('0x55')](_0x563e41)['then'](handleEntityNotFound(_0x5125ca,null))[_0xf2af('0x25')](respondWithResult(_0x5125ca,null))[_0xf2af('0x51')](handleError(_0x5125ca,null));};exports['create']=function(_0x3b7126,_0x311736){return db[_0xf2af('0x3d')][_0xf2af('0x56')](_0x3b7126[_0xf2af('0x57')],{})[_0xf2af('0x25')](function(_0x156e94){var _0x234b6f=_0x3b7126[_0xf2af('0x58')]['get']({'plain':!![]});if(!_0x234b6f)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x234b6f[_0xf2af('0x59')]===_0xf2af('0x58')){var _0x572d23=_0x156e94[_0xf2af('0x27')]({'plain':!![]});var _0x27a7d6=[{'name':'VoiceQueues','value':'inbound'},{'name':'QueueCampaigns','value':_0xf2af('0x2a')}];var _0x227866=_[_0xf2af('0x55')](_0x27a7d6,[_0xf2af('0x2d'),_0x572d23['type']])[_0xf2af('0x30')];return db[_0xf2af('0x5a')][_0xf2af('0x55')]({'where':{'name':_0x227866,'userProfileId':_0x234b6f[_0xf2af('0x5b')]},'raw':!![]})[_0xf2af('0x25')](function(_0xbdd512){if(_0xbdd512&&_0xbdd512[_0xf2af('0x5c')]===0x0){return db[_0xf2af('0x31')][_0xf2af('0x56')]({'name':_0x572d23['name'],'resourceId':_0x572d23['id'],'type':_0xbdd512[_0xf2af('0x30')],'sectionId':_0xbdd512['id']},{})['then'](function(){return _0x156e94;});}else{return _0x156e94;}})[_0xf2af('0x51')](function(_0x25f986){logger[_0xf2af('0x34')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x25f986);throw _0x25f986;});}return _0x156e94;})['then'](respondWithResult(_0x311736,0xc9))[_0xf2af('0x51')](handleError(_0x311736,null));};exports['clone']=function(_0x46f552,_0x2f5635){var _0xabd52e={'where':{'id':_0x46f552[_0xf2af('0x5d')]['id']}},_0x854231={};_0x854231[_0xf2af('0x43')]=_[_0xf2af('0x41')](db[_0xf2af('0x3d')]['rawAttributes']);_0xabd52e['attributes']=_[_0xf2af('0x45')](_0x854231[_0xf2af('0x43')],qs['fields'](_0x46f552[_0xf2af('0x40')][_0xf2af('0x53')]));_0xabd52e[_0xf2af('0x44')]=_0xabd52e[_0xf2af('0x44')][_0xf2af('0x46')]?_0xabd52e[_0xf2af('0x44')]:_0x854231[_0xf2af('0x43')];if(_0x46f552['query'][_0xf2af('0x4e')]){_0xabd52e['include']=[{'all':!![]}];}_0xabd52e=_['merge']({},_0xabd52e,_0x46f552[_0xf2af('0x4d')]);return db[_0xf2af('0x3d')]['find'](_0xabd52e)[_0xf2af('0x25')](handleEntityNotFound(_0x2f5635,null))[_0xf2af('0x25')](function(_0x36d8bb){if(_0x36d8bb){var _0x3b54f8=_0x36d8bb[_0xf2af('0x27')]({'plain':!![]});_0x3b54f8=qs[_0xf2af('0x5e')](_0x3b54f8,['id',_0xf2af('0x5f'),'updatedAt']);_0x46f552[_0xf2af('0x57')]=_[_0xf2af('0x5e')](_0x46f552[_0xf2af('0x57')],['id',_0xf2af('0x5f'),'updatedAt']);return db[_0xf2af('0x3d')][_0xf2af('0x56')](_[_0xf2af('0x38')](_0x3b54f8,_0x46f552[_0xf2af('0x57')]),{'include':_0x46f552[_0xf2af('0x40')][_0xf2af('0x4e')]?[{'all':!![]}]:undefined})[_0xf2af('0x25')](function(_0x67afe4){var _0x3bd454=_0x46f552[_0xf2af('0x58')]['get']({'plain':!![]});if(!_0x3bd454)throw new Error(_0xf2af('0x60'));if(_0x3bd454[_0xf2af('0x59')]===_0xf2af('0x58')){var _0x1d4fed=_0x67afe4[_0xf2af('0x27')]({'plain':!![]});var _0x1d880c=[{'name':_0xf2af('0x28'),'value':_0xf2af('0x61')},{'name':_0xf2af('0x29'),'value':_0xf2af('0x2a')}];var _0x24d7c8=_[_0xf2af('0x55')](_0x1d880c,[_0xf2af('0x2d'),_0x1d4fed[_0xf2af('0x2f')]])[_0xf2af('0x30')];return db[_0xf2af('0x5a')][_0xf2af('0x55')]({'where':{'name':_0x24d7c8,'userProfileId':_0x3bd454[_0xf2af('0x5b')]},'raw':!![]})[_0xf2af('0x25')](function(_0x5377d6){if(_0x5377d6&&_0x5377d6['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x1d4fed['name'],'resourceId':_0x1d4fed['id'],'type':_0x5377d6[_0xf2af('0x30')],'sectionId':_0x5377d6['id']},{})[_0xf2af('0x25')](function(){return _0x67afe4;});}else{return _0x67afe4;}})[_0xf2af('0x51')](function(_0x3f2d7f){logger['error'](_0xf2af('0x62'),_0x3f2d7f);throw _0x3f2d7f;});}return _0x67afe4;});}})[_0xf2af('0x25')](respondWithResult(_0x2f5635,0xc9))[_0xf2af('0x51')](handleError(_0x2f5635,null));};exports[_0xf2af('0x24')]=function(_0x20374c,_0xf85743){if(_0x20374c[_0xf2af('0x57')]['id']){delete _0x20374c[_0xf2af('0x57')]['id'];}return db[_0xf2af('0x3d')][_0xf2af('0x55')]({'where':{'id':_0x20374c[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0xf85743,null))[_0xf2af('0x25')](saveUpdates(_0x20374c['body'],null))[_0xf2af('0x25')](respondWithResult(_0xf85743,null))[_0xf2af('0x51')](handleError(_0xf85743,null));};exports[_0xf2af('0x26')]=function(_0x3818ed,_0x213508){return db[_0xf2af('0x3d')][_0xf2af('0x55')]({'where':{'id':_0x3818ed['params']['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0x213508,null))[_0xf2af('0x25')](removeEntity(_0x213508,null))[_0xf2af('0x51')](handleError(_0x213508,null));};exports[_0xf2af('0x63')]=function(_0x38671e,_0x358ab7,_0x5d0c9f){var _0x4a9aa4={'raw':![],'where':{}};var _0x262b5a={};var _0x54595c={'count':0x0,'rows':[]};return db[_0xf2af('0x3d')]['findOne']({'where':{'id':_0x38671e[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0x358ab7,null))[_0xf2af('0x25')](function(_0x1a47c6){if(_0x1a47c6){_0x262b5a[_0xf2af('0x43')]=_[_0xf2af('0x41')](db[_0xf2af('0x64')][_0xf2af('0x3e')]);_0x262b5a[_0xf2af('0x40')]=_[_0xf2af('0x41')](_0x38671e['query']);_0x262b5a[_0xf2af('0x42')]=_['intersection'](_0x262b5a[_0xf2af('0x43')],_0x262b5a[_0xf2af('0x40')]);_0x4a9aa4[_0xf2af('0x44')]=_['intersection'](_0x262b5a['model'],qs[_0xf2af('0x53')](_0x38671e[_0xf2af('0x40')][_0xf2af('0x53')]));_0x4a9aa4[_0xf2af('0x44')]=_0x4a9aa4[_0xf2af('0x44')][_0xf2af('0x46')]?_0x4a9aa4[_0xf2af('0x44')]:_0x262b5a['model'];if(!_0x38671e[_0xf2af('0x40')]['hasOwnProperty'](_0xf2af('0x47'))){_0x4a9aa4[_0xf2af('0x1f')]=qs[_0xf2af('0x1f')](_0x38671e['query'][_0xf2af('0x1f')]);_0x4a9aa4['offset']=qs[_0xf2af('0x1d')](_0x38671e[_0xf2af('0x40')][_0xf2af('0x1d')]);}_0x4a9aa4['order']=qs[_0xf2af('0x48')](_0x38671e[_0xf2af('0x40')][_0xf2af('0x48')]);_0x4a9aa4['where']=qs[_0xf2af('0x42')](_[_0xf2af('0x4a')](_0x38671e[_0xf2af('0x40')],_0x262b5a['filters']));_0x4a9aa4[_0xf2af('0x49')][_0xf2af('0x65')]=_0x1a47c6['id'];if(_0x38671e[_0xf2af('0x40')][_0xf2af('0x4b')]){_0x4a9aa4[_0xf2af('0x49')]=_[_0xf2af('0x38')](_0x4a9aa4[_0xf2af('0x49')],{'$or':_[_0xf2af('0x2c')](_0x4a9aa4[_0xf2af('0x44')],function(_0x18acd9){var _0x2b31c3={};_0x2b31c3[_0x18acd9]={'$like':'%'+_0x38671e['query'][_0xf2af('0x4b')]+'%'};return _0x2b31c3;})});}_0x4a9aa4=_['merge']({},_0x4a9aa4,_0x38671e[_0xf2af('0x4d')]);return db['CmHopper'][_0xf2af('0x20')]({'where':_0x4a9aa4['where']})[_0xf2af('0x25')](function(_0x45060e){_0x54595c[_0xf2af('0x20')]=_0x45060e;if(_0x38671e['query'][_0xf2af('0x4e')]){_0x4a9aa4[_0xf2af('0x54')]=[{'all':!![]}];}return db[_0xf2af('0x64')][_0xf2af('0x4f')](_0x4a9aa4);})['then'](function(_0x2cee85){_0x54595c[_0xf2af('0x50')]=_0x2cee85;return _0x54595c;});}})[_0xf2af('0x25')](respondWithFilteredResult(_0x358ab7,_0x4a9aa4))[_0xf2af('0x51')](handleError(_0x358ab7,null));};exports['getHopperHistories']=function(_0x1a6060,_0x3be5f1,_0x77fa34){var _0x486979={'raw':!![],'where':{}};var _0x4aa7e4={};var _0x3b44d8={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x1a6060[_0xf2af('0x5d')]['id']}})['then'](handleEntityNotFound(_0x3be5f1,null))[_0xf2af('0x25')](function(_0x14923c){if(_0x14923c){_0x4aa7e4[_0xf2af('0x43')]=_[_0xf2af('0x41')](db[_0xf2af('0x66')][_0xf2af('0x3e')]);_0x4aa7e4['query']=_[_0xf2af('0x41')](_0x1a6060['query']);_0x4aa7e4[_0xf2af('0x42')]=_[_0xf2af('0x45')](_0x4aa7e4[_0xf2af('0x43')],_0x4aa7e4[_0xf2af('0x40')]);_0x486979[_0xf2af('0x44')]=_[_0xf2af('0x45')](_0x4aa7e4[_0xf2af('0x43')],qs['fields'](_0x1a6060['query'][_0xf2af('0x53')]));_0x486979[_0xf2af('0x44')]=_0x486979[_0xf2af('0x44')][_0xf2af('0x46')]?_0x486979['attributes']:_0x4aa7e4[_0xf2af('0x43')];if(!_0x1a6060[_0xf2af('0x40')][_0xf2af('0x67')]('nolimit')){_0x486979[_0xf2af('0x1f')]=qs[_0xf2af('0x1f')](_0x1a6060['query'][_0xf2af('0x1f')]);_0x486979[_0xf2af('0x1d')]=qs[_0xf2af('0x1d')](_0x1a6060[_0xf2af('0x40')][_0xf2af('0x1d')]);}_0x486979['order']=qs[_0xf2af('0x48')](_0x1a6060[_0xf2af('0x40')][_0xf2af('0x48')]);_0x486979[_0xf2af('0x49')]=qs['filters'](_[_0xf2af('0x4a')](_0x1a6060[_0xf2af('0x40')],_0x4aa7e4[_0xf2af('0x42')]));_0x486979[_0xf2af('0x49')]['VoiceQueueId']=_0x14923c['id'];if(_0x1a6060[_0xf2af('0x40')][_0xf2af('0x4b')]){_0x486979[_0xf2af('0x49')]=_['merge'](_0x486979[_0xf2af('0x49')],{'$or':_['map'](_0x486979[_0xf2af('0x44')],function(_0x1f05ba){var _0x2d6e3f={};_0x2d6e3f[_0x1f05ba]={'$like':'%'+_0x1a6060[_0xf2af('0x40')][_0xf2af('0x4b')]+'%'};return _0x2d6e3f;})});}_0x486979=_[_0xf2af('0x38')]({},_0x486979,_0x1a6060[_0xf2af('0x4d')]);return db['CmHopperHistory'][_0xf2af('0x20')]({'where':_0x486979[_0xf2af('0x49')]})[_0xf2af('0x25')](function(_0x26706a){_0x3b44d8[_0xf2af('0x20')]=_0x26706a;if(_0x1a6060[_0xf2af('0x40')]['includeAll']){_0x486979[_0xf2af('0x54')]=[{'all':!![]}];}return db[_0xf2af('0x66')][_0xf2af('0x4f')](_0x486979);})[_0xf2af('0x25')](function(_0x407206){_0x3b44d8['rows']=_0x407206;return _0x3b44d8;});}})[_0xf2af('0x25')](respondWithFilteredResult(_0x3be5f1,_0x486979))[_0xf2af('0x51')](handleError(_0x3be5f1,null));};exports[_0xf2af('0x68')]=function(_0x32d3bc,_0x3d189d,_0x3c0aa4){var _0x58cfa1={'raw':!![],'where':{}};var _0x510170={};var _0x510421={'count':0x0,'rows':[]};return db[_0xf2af('0x3d')][_0xf2af('0x69')]({'where':{'id':_0x32d3bc[_0xf2af('0x5d')]['id']}})['then'](handleEntityNotFound(_0x3d189d,null))['then'](function(_0x445e31){if(_0x445e31){_0x510170[_0xf2af('0x43')]=_[_0xf2af('0x41')](db[_0xf2af('0x6a')][_0xf2af('0x3e')]);_0x510170['query']=_[_0xf2af('0x41')](_0x32d3bc[_0xf2af('0x40')]);_0x510170[_0xf2af('0x42')]=_['intersection'](_0x510170[_0xf2af('0x43')],_0x510170[_0xf2af('0x40')]);_0x58cfa1['attributes']=_[_0xf2af('0x45')](_0x510170[_0xf2af('0x43')],qs[_0xf2af('0x53')](_0x32d3bc[_0xf2af('0x40')][_0xf2af('0x53')]));_0x58cfa1[_0xf2af('0x44')]=_0x58cfa1[_0xf2af('0x44')][_0xf2af('0x46')]?_0x58cfa1[_0xf2af('0x44')]:_0x510170[_0xf2af('0x43')];if(!_0x32d3bc[_0xf2af('0x40')][_0xf2af('0x67')](_0xf2af('0x47'))){_0x58cfa1[_0xf2af('0x1f')]=qs[_0xf2af('0x1f')](_0x32d3bc[_0xf2af('0x40')][_0xf2af('0x1f')]);_0x58cfa1[_0xf2af('0x1d')]=qs['offset'](_0x32d3bc['query'][_0xf2af('0x1d')]);}_0x58cfa1[_0xf2af('0x6b')]=qs[_0xf2af('0x48')](_0x32d3bc[_0xf2af('0x40')][_0xf2af('0x48')]);_0x58cfa1[_0xf2af('0x49')]=qs[_0xf2af('0x42')](_[_0xf2af('0x4a')](_0x32d3bc[_0xf2af('0x40')],_0x510170[_0xf2af('0x42')]));_0x58cfa1['where'][_0xf2af('0x65')]=_0x445e31['id'];if(_0x32d3bc[_0xf2af('0x40')][_0xf2af('0x4b')]){_0x58cfa1[_0xf2af('0x49')]=_['merge'](_0x58cfa1[_0xf2af('0x49')],{'$or':_[_0xf2af('0x2c')](_0x58cfa1[_0xf2af('0x44')],function(_0x11aa6d){var _0x1a41dd={};_0x1a41dd[_0x11aa6d]={'$like':'%'+_0x32d3bc['query']['filter']+'%'};return _0x1a41dd;})});}_0x58cfa1=_[_0xf2af('0x38')]({},_0x58cfa1,_0x32d3bc[_0xf2af('0x4d')]);return db['CmHopperFinal'][_0xf2af('0x20')]({'where':_0x58cfa1[_0xf2af('0x49')]})[_0xf2af('0x25')](function(_0x491cc9){_0x510421[_0xf2af('0x20')]=_0x491cc9;if(_0x32d3bc[_0xf2af('0x40')][_0xf2af('0x4e')]){_0x58cfa1[_0xf2af('0x54')]=[{'all':!![]}];}return db[_0xf2af('0x6a')][_0xf2af('0x4f')](_0x58cfa1);})[_0xf2af('0x25')](function(_0xf195c2){_0x510421['rows']=_0xf195c2;return _0x510421;});}})[_0xf2af('0x25')](respondWithFilteredResult(_0x3d189d,_0x58cfa1))[_0xf2af('0x51')](handleError(_0x3d189d,null));};exports['getHopperBlacks']=function(_0x524845,_0x3c6908,_0x9d517e){var _0x485a5e={'raw':!![],'where':{}};var _0x509848={};var _0x13f7f9={'count':0x0,'rows':[]};return db[_0xf2af('0x3d')][_0xf2af('0x69')]({'where':{'id':_0x524845[_0xf2af('0x5d')]['id']}})['then'](handleEntityNotFound(_0x3c6908,null))[_0xf2af('0x25')](function(_0x42757d){if(_0x42757d){_0x509848[_0xf2af('0x43')]=_[_0xf2af('0x41')](db['CmHopperBlack'][_0xf2af('0x3e')]);_0x509848[_0xf2af('0x40')]=_[_0xf2af('0x41')](_0x524845[_0xf2af('0x40')]);_0x509848[_0xf2af('0x42')]=_[_0xf2af('0x45')](_0x509848[_0xf2af('0x43')],_0x509848[_0xf2af('0x40')]);_0x485a5e[_0xf2af('0x44')]=_[_0xf2af('0x45')](_0x509848[_0xf2af('0x43')],qs['fields'](_0x524845[_0xf2af('0x40')][_0xf2af('0x53')]));_0x485a5e[_0xf2af('0x44')]=_0x485a5e[_0xf2af('0x44')]['length']?_0x485a5e[_0xf2af('0x44')]:_0x509848['model'];if(!_0x524845['query'][_0xf2af('0x67')]('nolimit')){_0x485a5e[_0xf2af('0x1f')]=qs[_0xf2af('0x1f')](_0x524845['query']['limit']);_0x485a5e[_0xf2af('0x1d')]=qs[_0xf2af('0x1d')](_0x524845[_0xf2af('0x40')]['offset']);}_0x485a5e[_0xf2af('0x6b')]=qs[_0xf2af('0x48')](_0x524845['query'][_0xf2af('0x48')]);_0x485a5e[_0xf2af('0x49')]=qs[_0xf2af('0x42')](_[_0xf2af('0x4a')](_0x524845[_0xf2af('0x40')],_0x509848[_0xf2af('0x42')]));_0x485a5e[_0xf2af('0x49')][_0xf2af('0x65')]=_0x42757d['id'];if(_0x524845['query'][_0xf2af('0x4b')]){_0x485a5e['where']=_[_0xf2af('0x38')](_0x485a5e['where'],{'$or':_[_0xf2af('0x2c')](_0x485a5e[_0xf2af('0x44')],function(_0x2202f4){var _0x12ab05={};_0x12ab05[_0x2202f4]={'$like':'%'+_0x524845[_0xf2af('0x40')][_0xf2af('0x4b')]+'%'};return _0x12ab05;})});}_0x485a5e=_[_0xf2af('0x38')]({},_0x485a5e,_0x524845[_0xf2af('0x4d')]);return db[_0xf2af('0x6c')][_0xf2af('0x20')]({'where':_0x485a5e[_0xf2af('0x49')]})[_0xf2af('0x25')](function(_0x55c041){_0x13f7f9[_0xf2af('0x20')]=_0x55c041;if(_0x524845[_0xf2af('0x40')][_0xf2af('0x4e')]){_0x485a5e[_0xf2af('0x54')]=[{'all':!![]}];}return db[_0xf2af('0x6c')]['findAll'](_0x485a5e);})[_0xf2af('0x25')](function(_0x4ac431){_0x13f7f9['rows']=_0x4ac431;return _0x13f7f9;});}})['then'](respondWithFilteredResult(_0x3c6908,_0x485a5e))[_0xf2af('0x51')](handleError(_0x3c6908,null));};exports[_0xf2af('0x6d')]=function(_0x3cbca7,_0x12c0e8,_0x55fd9b){var _0xebebee={};var _0x580b85={};var _0x5086fa;var _0x5e5a84;return db[_0xf2af('0x3d')][_0xf2af('0x69')]({'where':{'id':_0x3cbca7[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0x12c0e8,null))[_0xf2af('0x25')](function(_0x56509b){if(_0x56509b){_0x5086fa=_0x56509b;_0x580b85[_0xf2af('0x43')]=_[_0xf2af('0x41')](db[_0xf2af('0x6e')][_0xf2af('0x3e')]);_0x580b85[_0xf2af('0x40')]=_[_0xf2af('0x41')](_0x3cbca7[_0xf2af('0x40')]);_0x580b85['filters']=_[_0xf2af('0x45')](_0x580b85[_0xf2af('0x43')],_0x580b85[_0xf2af('0x40')]);_0xebebee['attributes']=_[_0xf2af('0x45')](_0x580b85['model'],qs[_0xf2af('0x53')](_0x3cbca7[_0xf2af('0x40')][_0xf2af('0x53')]));_0xebebee['attributes']=_0xebebee[_0xf2af('0x44')][_0xf2af('0x46')]?_0xebebee[_0xf2af('0x44')]:_0x580b85[_0xf2af('0x43')];_0xebebee[_0xf2af('0x6b')]=qs['sort'](_0x3cbca7[_0xf2af('0x40')]['sort']);_0xebebee[_0xf2af('0x49')]=qs['filters'](_[_0xf2af('0x4a')](_0x3cbca7['query'],_0x580b85[_0xf2af('0x42')]));if(_0x3cbca7[_0xf2af('0x40')]['filter']){_0xebebee[_0xf2af('0x49')]=_[_0xf2af('0x38')](_0xebebee[_0xf2af('0x49')],{'$or':_[_0xf2af('0x2c')](_0xebebee[_0xf2af('0x44')],function(_0x479d87){var _0x5e5cd9={};_0x5e5cd9[_0x479d87]={'$like':'%'+_0x3cbca7[_0xf2af('0x40')][_0xf2af('0x4b')]+'%'};return _0x5e5cd9;})});}_0xebebee=_[_0xf2af('0x38')]({},_0xebebee,_0x3cbca7[_0xf2af('0x4d')]);return _0x5086fa['getTeams'](_0xebebee);}})[_0xf2af('0x25')](function(_0x4ab69b){if(_0x4ab69b){_0x5e5a84=_0x4ab69b['length'];if(!_0x3cbca7['query'][_0xf2af('0x67')](_0xf2af('0x47'))){_0xebebee[_0xf2af('0x1f')]=qs['limit'](_0x3cbca7[_0xf2af('0x40')][_0xf2af('0x1f')]);_0xebebee['offset']=qs[_0xf2af('0x1d')](_0x3cbca7[_0xf2af('0x40')][_0xf2af('0x1d')]);}return _0x5086fa[_0xf2af('0x6d')](_0xebebee);}})[_0xf2af('0x25')](function(_0x2c2cdd){if(_0x2c2cdd){return _0x2c2cdd?{'count':_0x5e5a84,'rows':_0x2c2cdd}:null;}})['then'](respondWithResult(_0x12c0e8,null))[_0xf2af('0x51')](handleError(_0x12c0e8,null));};exports[_0xf2af('0x6f')]=function(_0x1fbde1,_0x2311c3,_0x2d22a9){var _0x2b9eb5=_0x1fbde1[_0xf2af('0x57')]['teams'];var _0x4dec37=_[_0xf2af('0x2c')](_0x2b9eb5,'id');return db['Team'][_0xf2af('0x4f')]({'where':{'id':_0x4dec37},'attributes':['id'],'include':[{'model':db[_0xf2af('0x70')],'as':_0xf2af('0x71'),'attributes':['id',_0xf2af('0x30'),_0xf2af('0x72'),'voicePause',_0xf2af('0x73')],'raw':!![]}]})['then'](function(_0x25bd82){if(_0x25bd82){var _0x73ff57=_[_0xf2af('0x74')](_0x25bd82,function(_0x46f6b1){var _0x500660=_0x46f6b1[_0xf2af('0x27')]({'plain':!![]});_0x500660[_0xf2af('0x71')]['forEach'](function(_0x223bec){_0x223bec[_0xf2af('0x75')]=_[_0xf2af('0x55')](_0x2b9eb5,{'id':_0x500660['id']})[_0xf2af('0x75')];});return _0x500660['Agents'];});return db[_0xf2af('0x3d')][_0xf2af('0x55')]({'where':{'id':_0x1fbde1[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](function(_0x5f44af){return db[_0xf2af('0x76')][_0xf2af('0x77')](function(_0x4d5051){return _0x5f44af['addTeams'](_0x4dec37,{'transaction':_0x4d5051})[_0xf2af('0x25')](function(){return BPromise[_0xf2af('0x78')](_0x2b9eb5,function(_0x1f12cf){return db[_0xf2af('0x79')][_0xf2af('0x7a')]({'TeamId':_0x1f12cf['id'],'VoiceQueueId':_0x1fbde1['params']['id'],'penalty':_0x1f12cf['penalty']},{'transaction':_0x4d5051});});})[_0xf2af('0x25')](function(){return BPromise['each'](_0x73ff57,function(_0x51f8a5){return db[_0xf2af('0x7b')][_0xf2af('0x7c')]({'where':{'UserId':_0x51f8a5['id'],'VoiceQueueId':_0x1fbde1['params']['id']},'defaults':{'penalty':_0x51f8a5[_0xf2af('0x75')]},'transaction':_0x4d5051});});})[_0xf2af('0x25')](function(){return BPromise[_0xf2af('0x78')](_[_0xf2af('0x4b')](_0x73ff57,{'online':!![]}),function(_0x51909f){return db[_0xf2af('0x7d')]['upsert']({'membername':_0x51909f['name'],'UserId':_0x51909f['id'],'queue_name':_0x5f44af[_0xf2af('0x30')],'VoiceQueueId':_0x5f44af['id'],'interface':_['isNil'](_0x51909f[_0xf2af('0x73')])?util['format'](_0xf2af('0x7e'),_0x51909f[_0xf2af('0x30')]):_0x51909f[_0xf2af('0x73')],'paused':_0x51909f[_0xf2af('0x7f')]||![],'penalty':_0x51909f[_0xf2af('0x75')]},{'transaction':_0x4d5051});});})[_0xf2af('0x25')](function(){_0x73ff57[_0xf2af('0x80')](function(_0x10c0b6){socket[_0xf2af('0x81')](_0xf2af('0x82'),{'UserId':_0x10c0b6['id'],'VoiceQueueId':_0x5f44af['id']});});});});});}})[_0xf2af('0x25')](respondWithStatusCode(_0x2311c3,null))['catch'](handleError(_0x2311c3,null));};exports[_0xf2af('0x83')]=function(_0xc65092,_0x49c1a9,_0xdff4eb){return db[_0xf2af('0x6e')][_0xf2af('0x4f')]({'where':{'id':_0xc65092[_0xf2af('0x40')]['ids']},'attributes':['id'],'include':[{'model':db['User'],'as':'Agents','attributes':['id'],'raw':!![]}]})['then'](handleEntityNotFound(_0x49c1a9,null))[_0xf2af('0x25')](function(_0x2972d9){var _0x37d995=_[_0xf2af('0x2c')](_0x2972d9,'id');var _0x47f1f0=[];var _0x5978d5=[];var _0x1288ce=squel['select']();_0x1288ce['field'](_0xf2af('0x84'))[_0xf2af('0x85')](_0xf2af('0x86'),'tq')[_0xf2af('0x87')](_0xf2af('0x88'),'ut',_0xf2af('0x89'))['where'](_0xf2af('0x8a'),_0xc65092['params']['id']);for(var _0x5c81da=0x0;_0x5c81da<_0x2972d9[_0xf2af('0x46')];_0x5c81da+=0x1){let _0x521071=_0x2972d9[_0x5c81da];for(var _0x2da18d=0x0;_0x2da18d<_0x521071[_0xf2af('0x71')][_0xf2af('0x46')];_0x2da18d+=0x1){let _0x57a18c=_0x521071[_0xf2af('0x71')][_0x2da18d];var _0x2a0fd1=_0x1288ce[_0xf2af('0x8b')]();_0x2a0fd1[_0xf2af('0x49')](_0xf2af('0x8c'),_0x57a18c['id']);_0x5978d5[_0xf2af('0x8d')](db[_0xf2af('0x76')][_0xf2af('0x40')](_0x2a0fd1[_0xf2af('0x8e')](),{'type':db[_0xf2af('0x76')]['QueryTypes'][_0xf2af('0x8f')]})[_0xf2af('0x25')](function(_0x504378){if(_0x504378['length']===0x1){return _0x57a18c['id'];}else{var _0x362455=_['every'](_[_0xf2af('0x2c')](_0x504378,'TeamId'),function(_0x43e927){return _['includes'](_0x37d995,_0x43e927);});if(_0x362455){return _0x57a18c['id'];}}}));}}return BPromise['all'](_0x5978d5)['then'](function(_0x28591b){_0x47f1f0=_(_0x47f1f0)[_0xf2af('0x90')](_0x28591b)[_0xf2af('0x91')]()['value']();return db[_0xf2af('0x3d')][_0xf2af('0x55')]({'where':{'id':_0xc65092[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](function(_0x2d03b8){return db['sequelize'][_0xf2af('0x77')](function(_0x5076b7){return _0x2d03b8[_0xf2af('0x83')](_0xc65092[_0xf2af('0x40')][_0xf2af('0x92')],{'transaction':_0x5076b7})[_0xf2af('0x25')](function(){if(!_[_0xf2af('0x93')](_0x47f1f0)){return _0x2d03b8[_0xf2af('0x94')](_0x47f1f0,{'transaction':_0x5076b7})['then'](function(){return db[_0xf2af('0x7d')][_0xf2af('0x26')]({'where':{'VoiceQueueId':_0xc65092[_0xf2af('0x5d')]['id'],'UserId':_0x47f1f0},'transaction':_0x5076b7});});}})[_0xf2af('0x25')](function(){_0x47f1f0[_0xf2af('0x80')](function(_0x292dec){socket[_0xf2af('0x81')](_0xf2af('0x95'),{'UserId':_0x292dec,'VoiceQueueId':_0x2d03b8['id']});});});});});});})[_0xf2af('0x25')](respondWithStatusCode(_0x49c1a9,null))[_0xf2af('0x51')](handleError(_0x49c1a9,null));};exports[_0xf2af('0x96')]=function(_0x3a6ef2,_0x11ee90,_0x3f1421){var _0xa320ff,_0xdaaa21;return db[_0xf2af('0x3d')][_0xf2af('0x55')]({'where':{'id':_0x3a6ef2[_0xf2af('0x5d')]['id']}})['then'](handleEntityNotFound(_0x11ee90,null))[_0xf2af('0x25')](function(_0x323549){if(_0x323549){_0xdaaa21=_0x323549;return _0x323549[_0xf2af('0x96')](_0x3a6ef2[_0xf2af('0x57')][_0xf2af('0x92')],_[_0xf2af('0x5e')](_0x3a6ef2['body'],[_0xf2af('0x92'),'id'])||{})[_0xf2af('0x97')](function(_0x2f05b2){for(var _0x597a51=0x0;_0x597a51<_0x3a6ef2['body'][_0xf2af('0x92')]['length'];_0x597a51+=0x1){socket[_0xf2af('0x81')](_0xf2af('0x82'),{'UserId':_0x3a6ef2[_0xf2af('0x57')][_0xf2af('0x92')][_0x597a51],'VoiceQueueId':_0x3a6ef2[_0xf2af('0x5d')]['id']});}return _0x2f05b2;});}})[_0xf2af('0x25')](function(_0x3ab4d8){_0xa320ff=_0x3ab4d8||[];if(_0xdaaa21){return db[_0xf2af('0x70')][_0xf2af('0x4f')]({'where':{'id':_0x3a6ef2[_0xf2af('0x57')]['ids']},'attributes':['id',_0xf2af('0x30'),_0xf2af('0x72'),_0xf2af('0x7f'),_0xf2af('0x73')],'raw':!![]});}})[_0xf2af('0x25')](function(_0x179344){if(!_['isEmpty'](_0x179344)){var _0x5f5256=[];for(var _0x3d3389=0x0;_0x3d3389<_0x179344['length'];_0x3d3389++){if(_0x179344[_0x3d3389]['online']){_0x5f5256[_0xf2af('0x8d')](db[_0xf2af('0x7d')][_0xf2af('0x7a')]({'membername':_0x179344[_0x3d3389][_0xf2af('0x30')],'UserId':_0x179344[_0x3d3389]['id'],'queue_name':_0xdaaa21[_0xf2af('0x30')],'VoiceQueueId':_0xdaaa21['id'],'interface':_['isNil'](_0x179344[_0x3d3389][_0xf2af('0x73')])?util[_0xf2af('0x98')]('SIP/%s',_0x179344[_0x3d3389][_0xf2af('0x30')]):_0x179344[_0x3d3389][_0xf2af('0x73')],'paused':_0x179344[_0x3d3389][_0xf2af('0x7f')]||![],'penalty':_0x3a6ef2[_0xf2af('0x57')][_0xf2af('0x75')]||0x0}));}}return BPromise[_0xf2af('0x99')](_0x5f5256);}})[_0xf2af('0x25')](function(){return _0xa320ff;})['then'](respondWithResult(_0x11ee90,null))[_0xf2af('0x51')](handleError(_0x11ee90,null));};exports[_0xf2af('0x94')]=function(_0x455654,_0x168ef3,_0x2b6b3){return db[_0xf2af('0x3d')][_0xf2af('0x55')]({'where':{'id':_0x455654[_0xf2af('0x5d')]['id']}})['then'](handleEntityNotFound(_0x168ef3,null))[_0xf2af('0x25')](function(_0x173c77){if(_0x173c77){return _0x173c77['removeAgents'](_0x455654[_0xf2af('0x40')][_0xf2af('0x92')])[_0xf2af('0x25')](function(){if(_[_0xf2af('0x9a')](_0x455654[_0xf2af('0x40')][_0xf2af('0x92')])){for(var _0x1684a3=0x0;_0x1684a3<_0x455654['query'][_0xf2af('0x92')]['length'];_0x1684a3+=0x1){socket[_0xf2af('0x81')]('userVoiceQueue:remove',{'UserId':Number(_0x455654[_0xf2af('0x40')][_0xf2af('0x92')][_0x1684a3]),'VoiceQueueId':Number(_0x455654[_0xf2af('0x5d')]['id'])});}}else{socket['emit'](_0xf2af('0x95'),{'UserId':Number(_0x455654['query']['ids']),'VoiceQueueId':Number(_0x455654['params']['id'])});}});}})['then'](function(_0x4515b2){return db['UserVoiceQueueRt'][_0xf2af('0x26')]({'where':{'VoiceQueueId':_0x455654[_0xf2af('0x5d')]['id'],'UserId':_0x455654[_0xf2af('0x40')][_0xf2af('0x92')]}})[_0xf2af('0x25')](function(){return _0x4515b2;});})['then'](respondWithStatusCode(_0x168ef3,null))[_0xf2af('0x51')](handleError(_0x168ef3,null));};exports[_0xf2af('0x9b')]=function(_0x2502b8,_0x3d79e8,_0x540fee){var _0x7d89ef={};var _0x2bd874={};var _0x3cd217;var _0x31c95;return db[_0xf2af('0x3d')][_0xf2af('0x69')]({'where':{'id':_0x2502b8[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0x3d79e8,null))[_0xf2af('0x25')](function(_0x597a27){if(_0x597a27){_0x3cd217=_0x597a27;_0x2bd874[_0xf2af('0x43')]=_[_0xf2af('0x41')](db[_0xf2af('0x70')][_0xf2af('0x3e')]);_0x2bd874['query']=_[_0xf2af('0x41')](_0x2502b8[_0xf2af('0x40')]);_0x2bd874[_0xf2af('0x42')]=_['intersection'](_0x2bd874[_0xf2af('0x43')],_0x2bd874[_0xf2af('0x40')]);_0x7d89ef['attributes']=_[_0xf2af('0x45')](_0x2bd874[_0xf2af('0x43')],qs[_0xf2af('0x53')](_0x2502b8[_0xf2af('0x40')][_0xf2af('0x53')]));_0x7d89ef['attributes']=_0x7d89ef['attributes']['length']?_0x7d89ef[_0xf2af('0x44')]:_0x2bd874[_0xf2af('0x43')];_0x7d89ef[_0xf2af('0x6b')]=qs['sort'](_0x2502b8[_0xf2af('0x40')][_0xf2af('0x48')]);_0x7d89ef[_0xf2af('0x49')]=qs[_0xf2af('0x42')](_['pick'](_0x2502b8[_0xf2af('0x40')],_0x2bd874[_0xf2af('0x42')]));if(_0x2502b8['query'][_0xf2af('0x4b')]){_0x7d89ef[_0xf2af('0x49')]=_[_0xf2af('0x38')](_0x7d89ef[_0xf2af('0x49')],{'$or':_[_0xf2af('0x2c')](_0x7d89ef['attributes'],function(_0x51823b){var _0x345d6e={};_0x345d6e[_0x51823b]={'$like':'%'+_0x2502b8[_0xf2af('0x40')][_0xf2af('0x4b')]+'%'};return _0x345d6e;})});}_0x7d89ef=_['merge']({},_0x7d89ef,_0x2502b8[_0xf2af('0x4d')]);return _0x3cd217[_0xf2af('0x9b')](_0x7d89ef);}})[_0xf2af('0x25')](function(_0x59aa12){if(_0x59aa12){_0x31c95=_0x59aa12[_0xf2af('0x46')];if(!_0x2502b8[_0xf2af('0x40')][_0xf2af('0x67')](_0xf2af('0x47'))){_0x7d89ef[_0xf2af('0x1f')]=qs[_0xf2af('0x1f')](_0x2502b8[_0xf2af('0x40')][_0xf2af('0x1f')]);_0x7d89ef[_0xf2af('0x1d')]=qs[_0xf2af('0x1d')](_0x2502b8[_0xf2af('0x40')][_0xf2af('0x1d')]);}return _0x3cd217[_0xf2af('0x9b')](_0x7d89ef);}})['then'](function(_0x3bfe01){if(_0x3bfe01){return _0x3bfe01?{'count':_0x31c95,'rows':_0x3bfe01}:null;}})['then'](respondWithResult(_0x3d79e8,null))['catch'](handleError(_0x3d79e8,null));};exports[_0xf2af('0x9c')]=function(_0x12db87,_0x169e1e,_0x51aa67){var _0x2d654f={};var _0x45d661={};var _0x383dd3;var _0xbf3cf2;return db[_0xf2af('0x3d')][_0xf2af('0x69')]({'where':{'id':_0x12db87[_0xf2af('0x5d')]['id']}})['then'](handleEntityNotFound(_0x169e1e,null))[_0xf2af('0x25')](function(_0x407547){if(_0x407547){_0x383dd3=_0x407547;_0x45d661[_0xf2af('0x43')]=_[_0xf2af('0x41')](db['UserVoiceQueueRt'][_0xf2af('0x3e')]);_0x45d661['query']=_[_0xf2af('0x41')](_0x12db87[_0xf2af('0x40')]);_0x45d661[_0xf2af('0x42')]=_[_0xf2af('0x45')](_0x45d661[_0xf2af('0x43')],_0x45d661[_0xf2af('0x40')]);_0x2d654f[_0xf2af('0x44')]=_[_0xf2af('0x45')](_0x45d661[_0xf2af('0x43')],qs[_0xf2af('0x53')](_0x12db87[_0xf2af('0x40')][_0xf2af('0x53')]));_0x2d654f[_0xf2af('0x44')]=_0x2d654f['attributes'][_0xf2af('0x46')]?_0x2d654f['attributes']:_0x45d661[_0xf2af('0x43')];_0x2d654f[_0xf2af('0x6b')]=qs[_0xf2af('0x48')](_0x12db87[_0xf2af('0x40')][_0xf2af('0x48')]);_0x2d654f['where']=qs['filters'](_[_0xf2af('0x4a')](_0x12db87[_0xf2af('0x40')],_0x45d661[_0xf2af('0x42')]));if(_0x12db87[_0xf2af('0x40')][_0xf2af('0x4b')]){_0x2d654f[_0xf2af('0x49')]=_[_0xf2af('0x38')](_0x2d654f[_0xf2af('0x49')],{'$or':_[_0xf2af('0x2c')](_0x2d654f[_0xf2af('0x44')],function(_0x39f916){var _0x5868c9={};_0x5868c9[_0x39f916]={'$like':'%'+_0x12db87[_0xf2af('0x40')][_0xf2af('0x4b')]+'%'};return _0x5868c9;})});}_0x2d654f=_[_0xf2af('0x38')]({},_0x2d654f,_0x12db87[_0xf2af('0x4d')]);return _0x383dd3[_0xf2af('0x9c')](_0x2d654f);}})[_0xf2af('0x25')](function(_0x301e9c){if(_0x301e9c){_0xbf3cf2=_0x301e9c[_0xf2af('0x46')];if(!_0x12db87[_0xf2af('0x40')]['hasOwnProperty'](_0xf2af('0x47'))){_0x2d654f[_0xf2af('0x1f')]=qs[_0xf2af('0x1f')](_0x12db87[_0xf2af('0x40')]['limit']);_0x2d654f[_0xf2af('0x1d')]=qs[_0xf2af('0x1d')](_0x12db87['query'][_0xf2af('0x1d')]);}return _0x383dd3['getMembers'](_0x2d654f);}})['then'](function(_0x3c311d){return _0x3c311d?{'count':_0xbf3cf2,'rows':_0x3c311d}:null;})['then'](respondWithResult(_0x169e1e,null))[_0xf2af('0x51')](handleError(_0x169e1e,null));};exports[_0xf2af('0x9d')]=function(_0x340d4b,_0x15290f,_0x90c5b8){var _0x400b6e={};var _0x1ad938={};var _0x27d949;var _0x2639df;return db['VoiceQueue'][_0xf2af('0x69')]({'where':{'id':_0x340d4b[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0x15290f,null))[_0xf2af('0x25')](function(_0x17001d){if(_0x17001d){_0x27d949=_0x17001d;_0x1ad938[_0xf2af('0x43')]=_[_0xf2af('0x41')](db[_0xf2af('0x9e')][_0xf2af('0x3e')]);_0x1ad938[_0xf2af('0x40')]=_[_0xf2af('0x41')](_0x340d4b['query']);_0x1ad938[_0xf2af('0x42')]=_[_0xf2af('0x45')](_0x1ad938[_0xf2af('0x43')],_0x1ad938[_0xf2af('0x40')]);_0x400b6e[_0xf2af('0x44')]=_[_0xf2af('0x45')](_0x1ad938['model'],qs[_0xf2af('0x53')](_0x340d4b[_0xf2af('0x40')]['fields']));_0x400b6e['attributes']=_0x400b6e['attributes'][_0xf2af('0x46')]?_0x400b6e['attributes']:_0x1ad938['model'];_0x400b6e[_0xf2af('0x6b')]=qs['sort'](_0x340d4b[_0xf2af('0x40')][_0xf2af('0x48')]);_0x400b6e[_0xf2af('0x49')]=qs[_0xf2af('0x42')](_[_0xf2af('0x4a')](_0x340d4b[_0xf2af('0x40')],_0x1ad938[_0xf2af('0x42')]));if(_0x340d4b[_0xf2af('0x40')][_0xf2af('0x4b')]){_0x400b6e[_0xf2af('0x49')]=_[_0xf2af('0x38')](_0x400b6e[_0xf2af('0x49')],{'$or':_['map'](_0x400b6e['attributes'],function(_0x1cad9d){var _0x2fc916={};_0x2fc916[_0x1cad9d]={'$like':'%'+_0x340d4b['query']['filter']+'%'};return _0x2fc916;})});}_0x400b6e=_[_0xf2af('0x38')]({},_0x400b6e,_0x340d4b[_0xf2af('0x4d')]);return _0x27d949[_0xf2af('0x9d')](_0x400b6e);}})[_0xf2af('0x25')](function(_0x3f4189){if(_0x3f4189){_0x2639df=_0x3f4189[_0xf2af('0x46')];if(!_0x340d4b[_0xf2af('0x40')][_0xf2af('0x67')](_0xf2af('0x47'))){_0x400b6e[_0xf2af('0x1f')]=qs[_0xf2af('0x1f')](_0x340d4b[_0xf2af('0x40')][_0xf2af('0x1f')]);_0x400b6e['offset']=qs[_0xf2af('0x1d')](_0x340d4b[_0xf2af('0x40')][_0xf2af('0x1d')]);}return _0x27d949[_0xf2af('0x9d')](_0x400b6e);}})[_0xf2af('0x25')](function(_0x2f98d6){if(_0x2f98d6){return _0x2f98d6?{'count':_0x2639df,'rows':_0x2f98d6}:null;}})['then'](respondWithResult(_0x15290f,null))[_0xf2af('0x51')](handleError(_0x15290f,null));};exports[_0xf2af('0x9f')]=function(_0x3fca25,_0x19142c,_0x21e6e1){var _0x2daca2,_0xacdb8a;return db['VoiceQueue'][_0xf2af('0x55')]({'where':{'id':_0x3fca25['params']['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0x19142c,null))[_0xf2af('0x25')](function(_0x49bc87){if(_0x49bc87){_0xacdb8a=_0x49bc87;return _0x49bc87[_0xf2af('0x9f')](_0x3fca25[_0xf2af('0x57')][_0xf2af('0x92')],_[_0xf2af('0x5e')](_0x3fca25[_0xf2af('0x57')],['ids','id'])||{});}return null;})[_0xf2af('0x97')](function(_0x487e57){var _0x43ac43;_0x2daca2=_0x487e57||[];var _0x6dcd68=[];if(_0x487e57){for(var _0x2471fb=0x0;_0x2471fb<_0x487e57['length'];_0x2471fb+=0x1){var _0x18d96d=_0x487e57[_0x2471fb][_0xf2af('0x27')]({'plain':!![]});_0xacdb8a[_0xf2af('0xa0')]=_0x3fca25[_0xf2af('0x57')][_0xf2af('0xa0')]?_0x3fca25[_0xf2af('0x57')][_0xf2af('0xa0')]:_0xacdb8a[_0xf2af('0xa0')];switch(_0xacdb8a['dialCheckDuplicateType']){case'always':_0x43ac43=squel[_0xf2af('0xa1')]()[_0xf2af('0xa2')](_0xf2af('0xa3'))[_0xf2af('0xa4')]([_0xf2af('0xa5'),_0xf2af('0xa6'),_0xf2af('0xa7'),_0xf2af('0xa8'),'VoiceQueueId',_0xf2af('0x5f'),'updatedAt'],squel[_0xf2af('0xa9')]()[_0xf2af('0xaa')](_0xf2af('0xa5'),_0xf2af('0xa5'))['field'](_0xf2af('0xab'),'scheduledAt')[_0xf2af('0xaa')]('id','ContactId')[_0xf2af('0xaa')](_0x18d96d[_0xf2af('0xac')][_0xf2af('0x8e')](),'ListId')[_0xf2af('0xaa')](_0x3fca25[_0xf2af('0x5d')]['id']['toString'](),_0xf2af('0x65'))['field'](_0xf2af('0xab'),_0xf2af('0x5f'))['field']('NOW()',_0xf2af('0xad'))[_0xf2af('0x85')]('cm_contacts')['where'](_0xf2af('0xae'))[_0xf2af('0x49')](_0xf2af('0xaf'),_0x18d96d[_0xf2af('0xac')]['toString']())[_0xf2af('0x49')](_0xf2af('0xb0'))['where'](_0xf2af('0xb1'),squel[_0xf2af('0xa9')]()['field'](_0xf2af('0xb2'))[_0xf2af('0x85')](_0xf2af('0xb3'))[_0xf2af('0x49')](_0xf2af('0x8a'),_0x3fca25[_0xf2af('0x5d')]['id'][_0xf2af('0x8e')]()))['where'](_0xf2af('0xb1'),squel[_0xf2af('0xa9')]()[_0xf2af('0xaa')](_0xf2af('0xb4'))[_0xf2af('0x85')]('cm_hopper')['where']('VoiceQueueId\x20=\x20?',_0x3fca25[_0xf2af('0x5d')]['id'][_0xf2af('0x8e')]())))[_0xf2af('0x8e')]();break;case _0xf2af('0xb5'):_0x43ac43=squel[_0xf2af('0xa1')]()[_0xf2af('0xa2')](_0xf2af('0xa3'))[_0xf2af('0xa4')]([_0xf2af('0xa5'),_0xf2af('0xa6'),_0xf2af('0xa7'),'ListId',_0xf2af('0x65'),_0xf2af('0x5f'),_0xf2af('0xad')],squel[_0xf2af('0xa9')]()['field'](_0xf2af('0xa5'),'phone')[_0xf2af('0xaa')](_0xf2af('0xab'),_0xf2af('0xa6'))[_0xf2af('0xaa')]('id','ContactId')[_0xf2af('0xaa')](_0x18d96d[_0xf2af('0xac')][_0xf2af('0x8e')](),_0xf2af('0xa8'))[_0xf2af('0xaa')](_0x3fca25['params']['id']['toString'](),_0xf2af('0x65'))[_0xf2af('0xaa')](_0xf2af('0xab'),'createdAt')[_0xf2af('0xaa')](_0xf2af('0xab'),_0xf2af('0xad'))[_0xf2af('0x85')](_0xf2af('0xb6'))[_0xf2af('0x49')](_0xf2af('0xae'))[_0xf2af('0x49')](_0xf2af('0xaf'),_0x18d96d['CmListId']['toString']())['where'](_0xf2af('0xb0'))[_0xf2af('0x49')]('phone\x20NOT\x20IN\x20(?)',squel[_0xf2af('0xa9')]()['field'](_0xf2af('0xb4'))[_0xf2af('0x85')](_0xf2af('0xa3'))[_0xf2af('0x49')](_0xf2af('0x8a'),_0x3fca25[_0xf2af('0x5d')]['id'][_0xf2af('0x8e')]())))['toString']();break;default:_0x43ac43=squel[_0xf2af('0xa1')]()[_0xf2af('0xa2')](_0xf2af('0xa3'))[_0xf2af('0xa4')]([_0xf2af('0xa5'),_0xf2af('0xa6'),_0xf2af('0xa7'),_0xf2af('0xa8'),_0xf2af('0x65'),'createdAt',_0xf2af('0xad')],squel[_0xf2af('0xa9')]()[_0xf2af('0xaa')](_0xf2af('0xa5'),_0xf2af('0xa5'))[_0xf2af('0xaa')](_0xf2af('0xab'),_0xf2af('0xa6'))['field']('id',_0xf2af('0xa7'))[_0xf2af('0xaa')](_0x18d96d['CmListId']['toString'](),'ListId')[_0xf2af('0xaa')](_0x3fca25['params']['id'][_0xf2af('0x8e')](),_0xf2af('0x65'))[_0xf2af('0xaa')](_0xf2af('0xab'),_0xf2af('0x5f'))[_0xf2af('0xaa')]('NOW()','updatedAt')[_0xf2af('0x85')](_0xf2af('0xb6'))[_0xf2af('0x49')](_0xf2af('0xae'))[_0xf2af('0x49')](_0xf2af('0xaf'),_0x18d96d[_0xf2af('0xac')]['toString']())['where'](_0xf2af('0xb0')))[_0xf2af('0x8e')]();}_0x6dcd68[_0xf2af('0x8d')](db[_0xf2af('0x76')]['query'](_0x43ac43));}return BPromise['all'](_0x6dcd68);}})['then'](function(){return _0x2daca2;})['then'](respondWithResult(_0x19142c,null))[_0xf2af('0x51')](handleError(_0x19142c,null));};exports[_0xf2af('0xb7')]=function(_0x1c354c,_0x5d792f,_0x3d3824){return db[_0xf2af('0x3d')]['find']({'where':{'id':_0x1c354c['params']['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0x5d792f,null))['then'](function(_0x227dcb){if(_0x227dcb){return _0x227dcb[_0xf2af('0xb7')](_0x1c354c[_0xf2af('0x40')][_0xf2af('0x92')]);}})[_0xf2af('0x25')](function(_0x3caf74){if(_0x3caf74){return db[_0xf2af('0x64')][_0xf2af('0x26')]({'where':{'ListId':_0x1c354c['query'][_0xf2af('0x92')],'VoiceQueueId':_0x1c354c['params']['id']}})[_0xf2af('0x25')](function(){return _0x3caf74;});}})[_0xf2af('0x25')](respondWithStatusCode(_0x5d792f,null))[_0xf2af('0x51')](handleError(_0x5d792f,null));};exports[_0xf2af('0xb8')]=function(_0x2f757b,_0x38dc83,_0x164b3a){var _0x5d711c={};var _0x4ce258={};var _0x368a3b;var _0x41f72d;return db[_0xf2af('0x3d')][_0xf2af('0x69')]({'where':{'id':_0x2f757b[_0xf2af('0x5d')]['id']}})['then'](handleEntityNotFound(_0x38dc83,null))['then'](function(_0x1b7472){if(_0x1b7472){_0x368a3b=_0x1b7472;_0x4ce258['model']=_[_0xf2af('0x41')](db['CmList'][_0xf2af('0x3e')]);_0x4ce258[_0xf2af('0x40')]=_[_0xf2af('0x41')](_0x2f757b[_0xf2af('0x40')]);_0x4ce258[_0xf2af('0x42')]=_[_0xf2af('0x45')](_0x4ce258['model'],_0x4ce258[_0xf2af('0x40')]);_0x5d711c['attributes']=_[_0xf2af('0x45')](_0x4ce258[_0xf2af('0x43')],qs[_0xf2af('0x53')](_0x2f757b[_0xf2af('0x40')]['fields']));_0x5d711c['attributes']=_0x5d711c[_0xf2af('0x44')][_0xf2af('0x46')]?_0x5d711c[_0xf2af('0x44')]:_0x4ce258[_0xf2af('0x43')];_0x5d711c['order']=qs[_0xf2af('0x48')](_0x2f757b[_0xf2af('0x40')]['sort']);_0x5d711c[_0xf2af('0x49')]=qs[_0xf2af('0x42')](_[_0xf2af('0x4a')](_0x2f757b['query'],_0x4ce258['filters']));if(_0x2f757b['query'][_0xf2af('0x4b')]){_0x5d711c[_0xf2af('0x49')]=_[_0xf2af('0x38')](_0x5d711c[_0xf2af('0x49')],{'$or':_[_0xf2af('0x2c')](_0x5d711c['attributes'],function(_0x59a175){var _0x87b910={};_0x87b910[_0x59a175]={'$like':'%'+_0x2f757b[_0xf2af('0x40')]['filter']+'%'};return _0x87b910;})});}_0x5d711c=_[_0xf2af('0x38')]({},_0x5d711c,_0x2f757b[_0xf2af('0x4d')]);return _0x368a3b[_0xf2af('0xb8')](_0x5d711c);}})[_0xf2af('0x25')](function(_0x4a8626){if(_0x4a8626){_0x41f72d=_0x4a8626[_0xf2af('0x46')];if(!_0x2f757b['query']['hasOwnProperty']('nolimit')){_0x5d711c['limit']=qs[_0xf2af('0x1f')](_0x2f757b['query']['limit']);_0x5d711c[_0xf2af('0x1d')]=qs[_0xf2af('0x1d')](_0x2f757b[_0xf2af('0x40')][_0xf2af('0x1d')]);}return _0x368a3b[_0xf2af('0xb8')](_0x5d711c);}})['then'](function(_0x13f989){if(_0x13f989){return _0x13f989?{'count':_0x41f72d,'rows':_0x13f989}:null;}})['then'](respondWithResult(_0x38dc83,null))[_0xf2af('0x51')](handleError(_0x38dc83,null));};exports['addBlackLists']=function(_0x15707a,_0x1a9415,_0x7778db){var _0x835379,_0x784fd6;return db[_0xf2af('0x3d')][_0xf2af('0x55')]({'where':{'id':_0x15707a[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](handleEntityNotFound(_0x1a9415,null))['then'](function(_0x4d94b8){if(_0x4d94b8){_0x784fd6=_0x4d94b8;return _0x4d94b8[_0xf2af('0xb9')](_0x15707a[_0xf2af('0x57')]['ids'],_['omit'](_0x15707a['body'],[_0xf2af('0x92'),'id'])||{});}return null;})[_0xf2af('0x97')](function(_0x432aa3){var _0x107af7;_0x835379=_0x432aa3||[];var _0x3be3fd=[];if(_0x432aa3){for(var _0x4b1287=0x0;_0x4b1287<_0x432aa3[_0xf2af('0x46')];_0x4b1287+=0x1){var _0x5f5950=_0x432aa3[_0x4b1287][_0xf2af('0x27')]({'plain':!![]});_0x107af7=squel[_0xf2af('0xa1')]()[_0xf2af('0xa2')](_0xf2af('0xba'))['fromQuery']([_0xf2af('0xa5'),_0xf2af('0xa7'),'ListId',_0xf2af('0x65'),'createdAt',_0xf2af('0xad')],squel[_0xf2af('0xa9')]()[_0xf2af('0xaa')](_0xf2af('0xa5'),_0xf2af('0xa5'))[_0xf2af('0xaa')]('id',_0xf2af('0xa7'))[_0xf2af('0xaa')](_0x5f5950[_0xf2af('0xac')][_0xf2af('0x8e')](),_0xf2af('0xa8'))[_0xf2af('0xaa')](_0x15707a[_0xf2af('0x5d')]['id'][_0xf2af('0x8e')](),_0xf2af('0x65'))['field']('NOW()',_0xf2af('0x5f'))['field']('NOW()','updatedAt')['from'](_0xf2af('0xb6'))[_0xf2af('0x49')]('deletedAt\x20IS\x20NULL')[_0xf2af('0x49')](_0xf2af('0xaf'),_0x5f5950[_0xf2af('0xac')]['toString']())[_0xf2af('0x49')]('phone\x20IS\x20NOT\x20NULL'))['toString']();_0x3be3fd[_0xf2af('0x8d')](db['sequelize']['query'](_0x107af7));}return BPromise[_0xf2af('0x99')](_0x3be3fd);}})[_0xf2af('0x25')](function(){return _0x835379;})[_0xf2af('0x25')](respondWithResult(_0x1a9415,null))[_0xf2af('0x51')](handleError(_0x1a9415,null));};exports[_0xf2af('0xbb')]=function(_0x3c212f,_0x5bb83b,_0x37b15a){return db[_0xf2af('0x3d')][_0xf2af('0x55')]({'where':{'id':_0x3c212f[_0xf2af('0x5d')]['id']}})['then'](handleEntityNotFound(_0x5bb83b,null))[_0xf2af('0x25')](function(_0x540f31){if(_0x540f31){return _0x540f31[_0xf2af('0xbb')](_0x3c212f['query']['ids']);}})[_0xf2af('0x25')](function(_0x286ad6){if(_0x286ad6){return db[_0xf2af('0x6c')][_0xf2af('0x26')]({'where':{'ListId':_0x3c212f['query'][_0xf2af('0x92')],'VoiceQueueId':_0x3c212f[_0xf2af('0x5d')]['id']}})[_0xf2af('0x25')](function(){return _0x286ad6;});}})[_0xf2af('0x25')](respondWithStatusCode(_0x5bb83b,null))[_0xf2af('0x51')](handleError(_0x5bb83b,null));};