3a72dd9b95e7ad2ce96a8a1cec1ac08d13bad35d
[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 _0x8f6b=['nolimit','order','sort','where','pick','filters','VIRTUAL','merge','options','includeAll','include','rows','catch','show','params','find','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','QueueCampaigns','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','rawAttributes','omit','createdAt','create','user','getHoppers','findOne','CmHopper','VoiceQueueId','findAll','CmHopperHistory','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','getTeams','Team','addTeams','teams','User','online','flatMap','Agents','penalty','sequelize','transaction','each','TeamVoiceQueue','upsert','UserVoiceQueue','findOrCreate','UserVoiceQueueRt','isNil','interface','format','SIP/%s','voicePause','emit','userVoiceQueue:save','removeTeams','select','field','tq.TeamId','from','team_has_voice_queues','join','user_has_teams','ut.TeamId\x20=\x20tq.TeamId','VoiceQueueId\x20=\x20?','ut.UserId\x20=\x20?','QueryTypes','every','TeamId','all','union','isEmpty','userVoiceQueue:remove','addAgents','ids','spread','push','removeAgents','isArray','getAgents','getMembers','CmList','getLists','addLists','dialCheckDuplicateType','always','insert','fromQuery','phone','scheduledAt','ContactId','ListId','updatedAt','toString','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','COALESCE(calleridnum,\x27\x27)','cm_hopper','onlyIfOpen','into','COALESCE(phone,\x27\x27)','CmHopperId','OrderBy','h.id','ci.item','cm_contact_has_items','h.ContactId=ci.CmContactId','h.scheduledat=?','ci.ItemClass=?','PHONE','removeLists','getBlackLists','addBlackLists','cm_hopper_black','NOW()','removeBlackLists','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','sox','ejs','lodash','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','redis','defaults','localhost','socket.io-emitter','register','end','status','json','undefined','limit','count','offset','set','Content-Range','apply','reject','save','update','then','destroy','VoiceQueues','inbound','outbound','filter','ignore','map','includes','value','type','name','UserProfileResource','sendStatus','stack','index','VoiceQueue','key','keys','query','model','attributes','intersection','fields','length','hasOwnProperty'];(function(_0x3a245d,_0x21d769){var _0x4867f2=function(_0x1dd270){while(--_0x1dd270){_0x3a245d['push'](_0x3a245d['shift']());}};_0x4867f2(++_0x21d769);}(_0x8f6b,0x146));var _0xb8f6=function(_0x5447fd,_0x52a6b5){_0x5447fd=_0x5447fd-0x0;var _0x15b28a=_0x8f6b[_0x5447fd];return _0x15b28a;};'use strict';var emlformat=require(_0xb8f6('0x0'));var rimraf=require(_0xb8f6('0x1'));var zipdir=require(_0xb8f6('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xb8f6('0x3'));var moment=require(_0xb8f6('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xb8f6('0x5'));var util=require(_0xb8f6('0x6'));var path=require('path');var sox=require(_0xb8f6('0x7'));var csv=require('to-csv');var ejs=require(_0xb8f6('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xb8f6('0x9'));var squel=require('squel');var crypto=require(_0xb8f6('0xa'));var jsforce=require(_0xb8f6('0xb'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xb8f6('0xc'));var Papa=require(_0xb8f6('0xd'));var Redis=require(_0xb8f6('0xe'));var authService=require(_0xb8f6('0xf'));var qs=require(_0xb8f6('0x10'));var as=require(_0xb8f6('0x11'));var hardwareService=require(_0xb8f6('0x12'));var logger=require(_0xb8f6('0x13'))(_0xb8f6('0x14'));var utils=require(_0xb8f6('0x15'));var config=require(_0xb8f6('0x16'));var licenseUtil=require(_0xb8f6('0x17'));var db=require('../../mysqldb')['db'];config[_0xb8f6('0x18')]=_[_0xb8f6('0x19')](config['redis'],{'host':_0xb8f6('0x1a'),'port':0x18eb});var socket=require(_0xb8f6('0x1b'))(new Redis(config[_0xb8f6('0x18')]));require('./voiceQueue.socket')[_0xb8f6('0x1c')](socket);function respondWithStatusCode(_0x50d3a1,_0x237dc3){_0x237dc3=_0x237dc3||0xcc;return function(_0x2aee53){if(_0x2aee53){return _0x50d3a1['sendStatus'](_0x237dc3);}return _0x50d3a1['status'](_0x237dc3)[_0xb8f6('0x1d')]();};}function respondWithResult(_0x28c214,_0x2db63b){_0x2db63b=_0x2db63b||0xc8;return function(_0x8f42ec){if(_0x8f42ec){return _0x28c214[_0xb8f6('0x1e')](_0x2db63b)[_0xb8f6('0x1f')](_0x8f42ec);}};}function respondWithFilteredResult(_0x2e998b,_0x30c2b3){return function(_0x3592a5){if(_0x3592a5){var _0x537d5e=typeof _0x30c2b3['offset']===_0xb8f6('0x20')&&typeof _0x30c2b3[_0xb8f6('0x21')]===_0xb8f6('0x20');var _0x335e9c=_0x3592a5[_0xb8f6('0x22')];var _0x5c2506=_0x537d5e?0x0:_0x30c2b3[_0xb8f6('0x23')];var _0x13f964=_0x537d5e?_0x3592a5[_0xb8f6('0x22')]:_0x30c2b3[_0xb8f6('0x23')]+_0x30c2b3['limit'];var _0x38c93e;if(_0x13f964>=_0x335e9c){_0x13f964=_0x335e9c;_0x38c93e=0xc8;}else{_0x38c93e=0xce;}_0x2e998b[_0xb8f6('0x1e')](_0x38c93e);return _0x2e998b[_0xb8f6('0x24')](_0xb8f6('0x25'),_0x5c2506+'-'+_0x13f964+'/'+_0x335e9c)[_0xb8f6('0x1f')](_0x3592a5);}return null;};}function patchUpdates(_0x59c5f1){return function(_0x3805d7){try{jsonpatch[_0xb8f6('0x26')](_0x3805d7,_0x59c5f1,!![]);}catch(_0x4e62c0){return BPromise[_0xb8f6('0x27')](_0x4e62c0);}return _0x3805d7[_0xb8f6('0x28')]();};}function saveUpdates(_0x3a4fd2,_0x15e0cb){return function(_0x4ca430){if(_0x4ca430){return _0x4ca430[_0xb8f6('0x29')](_0x3a4fd2)[_0xb8f6('0x2a')](function(_0x4fea2e){return _0x4fea2e;});}return null;};}function removeEntity(_0x3e9b2b,_0x4ee750){return function(_0x126f78){if(_0x126f78){return _0x126f78[_0xb8f6('0x2b')]()[_0xb8f6('0x2a')](function(){var _0x1b0f80=_0x126f78['get']({'plain':!![]});var _0x36ad7a=[{'name':_0xb8f6('0x2c'),'value':_0xb8f6('0x2d'),'ignore':![]},{'name':'QueueCampaigns','value':_0xb8f6('0x2e'),'ignore':![]}];var _0x2c0600=_(_0x36ad7a)[_0xb8f6('0x2f')](_0xb8f6('0x30'))[_0xb8f6('0x31')]('value')['value']();if(_[_0xb8f6('0x32')](_0x2c0600,_0x1b0f80['type'])){return;}var _0x2f98ff=_['find'](_0x36ad7a,[_0xb8f6('0x33'),_0x1b0f80[_0xb8f6('0x34')]])[_0xb8f6('0x35')];return db[_0xb8f6('0x36')][_0xb8f6('0x2b')]({'where':{'type':_0x2f98ff,'resourceId':_0x1b0f80['id']}})[_0xb8f6('0x2a')](function(){return _0x126f78;});})[_0xb8f6('0x2a')](function(){_0x3e9b2b[_0xb8f6('0x1e')](0xcc)[_0xb8f6('0x1d')]();});}};}function handleEntityNotFound(_0x5b509a,_0x23def4){return function(_0x1173cb){if(!_0x1173cb){_0x5b509a[_0xb8f6('0x37')](0x194);}return _0x1173cb;};}function handleError(_0xcb1a51,_0x4c5c52){_0x4c5c52=_0x4c5c52||0x1f4;return function(_0x3bfc5a){logger['error'](_0x3bfc5a[_0xb8f6('0x38')]);if(_0x3bfc5a[_0xb8f6('0x35')]){delete _0x3bfc5a[_0xb8f6('0x35')];}_0xcb1a51[_0xb8f6('0x1e')](_0x4c5c52)['send'](_0x3bfc5a);};}exports[_0xb8f6('0x39')]=function(_0x4b5f65,_0x3b268b){var _0x546081={},_0x238778={},_0x5e9c8f={'count':0x0,'rows':[]};var _0x2bf4d2=_[_0xb8f6('0x31')](db[_0xb8f6('0x3a')]['rawAttributes'],function(_0x2ba31c){return{'name':_0x2ba31c['fieldName'],'type':_0x2ba31c[_0xb8f6('0x34')][_0xb8f6('0x3b')]};});_0x238778['model']=_[_0xb8f6('0x31')](_0x2bf4d2,_0xb8f6('0x35'));_0x238778['query']=_[_0xb8f6('0x3c')](_0x4b5f65[_0xb8f6('0x3d')]);_0x238778['filters']=_['intersection'](_0x238778[_0xb8f6('0x3e')],_0x238778[_0xb8f6('0x3d')]);_0x546081[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x238778[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x4b5f65['query'][_0xb8f6('0x41')]));_0x546081[_0xb8f6('0x3f')]=_0x546081[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x546081[_0xb8f6('0x3f')]:_0x238778[_0xb8f6('0x3e')];if(!_0x4b5f65['query'][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x546081['limit']=qs[_0xb8f6('0x21')](_0x4b5f65[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x546081[_0xb8f6('0x23')]=qs[_0xb8f6('0x23')](_0x4b5f65['query']['offset']);}_0x546081[_0xb8f6('0x45')]=qs['sort'](_0x4b5f65[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x546081[_0xb8f6('0x47')]=qs['filters'](_[_0xb8f6('0x48')](_0x4b5f65[_0xb8f6('0x3d')],_0x238778[_0xb8f6('0x49')]),_0x2bf4d2);if(_0x4b5f65[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x546081[_0xb8f6('0x47')]=_['merge'](_0x546081[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x2bf4d2,function(_0x7fad7c){if(_0x7fad7c[_0xb8f6('0x34')]!==_0xb8f6('0x4a')){var _0x1a1650={};_0x1a1650[_0x7fad7c[_0xb8f6('0x35')]]={'$like':'%'+_0x4b5f65['query'][_0xb8f6('0x2f')]+'%'};return _0x1a1650;}})});}_0x546081=_[_0xb8f6('0x4b')]({},_0x546081,_0x4b5f65[_0xb8f6('0x4c')]);var _0x2d148f={'where':_0x546081[_0xb8f6('0x47')]};return db[_0xb8f6('0x3a')][_0xb8f6('0x22')](_0x2d148f)['then'](function(_0x5c1a54){_0x5e9c8f[_0xb8f6('0x22')]=_0x5c1a54;if(_0x4b5f65[_0xb8f6('0x3d')][_0xb8f6('0x4d')]){_0x546081[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x3a')]['findAll'](_0x546081);})[_0xb8f6('0x2a')](function(_0x47e77c){_0x5e9c8f[_0xb8f6('0x4f')]=_0x47e77c;return _0x5e9c8f;})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x3b268b,_0x546081))[_0xb8f6('0x50')](handleError(_0x3b268b,null));};exports[_0xb8f6('0x51')]=function(_0x331539,_0x2191ae){var _0x5702f4={'raw':![],'where':{'id':_0x331539[_0xb8f6('0x52')]['id']}},_0x47723a={};_0x47723a['model']=_[_0xb8f6('0x3c')](db['VoiceQueue']['rawAttributes']);_0x47723a['query']=_[_0xb8f6('0x3c')](_0x331539[_0xb8f6('0x3d')]);_0x47723a[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x47723a['model'],_0x47723a[_0xb8f6('0x3d')]);_0x5702f4[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x47723a[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x331539[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0x5702f4['attributes']=_0x5702f4['attributes'][_0xb8f6('0x42')]?_0x5702f4[_0xb8f6('0x3f')]:_0x47723a[_0xb8f6('0x3e')];if(_0x331539[_0xb8f6('0x3d')][_0xb8f6('0x4d')]){_0x5702f4[_0xb8f6('0x4e')]=[{'all':!![]}];}_0x5702f4=_[_0xb8f6('0x4b')]({},_0x5702f4,_0x331539[_0xb8f6('0x4c')]);return db[_0xb8f6('0x3a')][_0xb8f6('0x53')](_0x5702f4)[_0xb8f6('0x2a')](handleEntityNotFound(_0x2191ae,null))['then'](respondWithResult(_0x2191ae,null))[_0xb8f6('0x50')](handleError(_0x2191ae,null));};exports['create']=function(_0x17b711,_0x5a5180){return db[_0xb8f6('0x3a')]['create'](_0x17b711[_0xb8f6('0x54')],{})['then'](function(_0x50bb2f){var _0x22ea73=_0x17b711['user']['get']({'plain':!![]});if(!_0x22ea73)throw new Error(_0xb8f6('0x55'));if(_0x22ea73[_0xb8f6('0x56')]==='user'){var _0x9440c8=_0x50bb2f[_0xb8f6('0x57')]({'plain':!![]});var _0x1a2328=[{'name':_0xb8f6('0x2c'),'value':_0xb8f6('0x2d')},{'name':_0xb8f6('0x58'),'value':'outbound'}];var _0x242c89=_['find'](_0x1a2328,[_0xb8f6('0x33'),_0x9440c8[_0xb8f6('0x34')]])[_0xb8f6('0x35')];return db['UserProfileSection']['find']({'where':{'name':_0x242c89,'userProfileId':_0x22ea73[_0xb8f6('0x59')]},'raw':!![]})[_0xb8f6('0x2a')](function(_0x5b397d){if(_0x5b397d&&_0x5b397d[_0xb8f6('0x5a')]===0x0){return db['UserProfileResource']['create']({'name':_0x9440c8['name'],'resourceId':_0x9440c8['id'],'type':_0x5b397d[_0xb8f6('0x35')],'sectionId':_0x5b397d['id']},{})[_0xb8f6('0x2a')](function(){return _0x50bb2f;});}else{return _0x50bb2f;}})['catch'](function(_0x362858){logger[_0xb8f6('0x5b')](_0xb8f6('0x5c'),_0x362858);throw _0x362858;});}return _0x50bb2f;})[_0xb8f6('0x2a')](respondWithResult(_0x5a5180,0xc9))[_0xb8f6('0x50')](handleError(_0x5a5180,null));};exports[_0xb8f6('0x5d')]=function(_0x26ceb6,_0x2463ed){var _0x12b485={'where':{'id':_0x26ceb6[_0xb8f6('0x52')]['id']}},_0x401e9f={};_0x401e9f[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x3a')][_0xb8f6('0x5e')]);_0x12b485[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x401e9f[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x26ceb6[_0xb8f6('0x3d')]['fields']));_0x12b485[_0xb8f6('0x3f')]=_0x12b485['attributes'][_0xb8f6('0x42')]?_0x12b485[_0xb8f6('0x3f')]:_0x401e9f[_0xb8f6('0x3e')];if(_0x26ceb6[_0xb8f6('0x3d')][_0xb8f6('0x4d')]){_0x12b485[_0xb8f6('0x4e')]=[{'all':!![]}];}_0x12b485=_[_0xb8f6('0x4b')]({},_0x12b485,_0x26ceb6[_0xb8f6('0x4c')]);return db['VoiceQueue'][_0xb8f6('0x53')](_0x12b485)[_0xb8f6('0x2a')](handleEntityNotFound(_0x2463ed,null))[_0xb8f6('0x2a')](function(_0x1a1910){if(_0x1a1910){var _0x3587eb=_0x1a1910[_0xb8f6('0x57')]({'plain':!![]});_0x3587eb=qs[_0xb8f6('0x5f')](_0x3587eb,['id',_0xb8f6('0x60'),'updatedAt']);_0x26ceb6[_0xb8f6('0x54')]=_[_0xb8f6('0x5f')](_0x26ceb6[_0xb8f6('0x54')],['id',_0xb8f6('0x60'),'updatedAt']);return db[_0xb8f6('0x3a')][_0xb8f6('0x61')](_[_0xb8f6('0x4b')](_0x3587eb,_0x26ceb6[_0xb8f6('0x54')]),{'include':_0x26ceb6[_0xb8f6('0x3d')][_0xb8f6('0x4d')]?[{'all':!![]}]:undefined})[_0xb8f6('0x2a')](function(_0xce53f){var _0x2312d5=_0x26ceb6[_0xb8f6('0x62')][_0xb8f6('0x57')]({'plain':!![]});if(!_0x2312d5)throw new Error(_0xb8f6('0x55'));if(_0x2312d5[_0xb8f6('0x56')]==='user'){var _0x3dfa2d=_0xce53f['get']({'plain':!![]});var _0x3da374=[{'name':_0xb8f6('0x2c'),'value':_0xb8f6('0x2d')},{'name':'QueueCampaigns','value':_0xb8f6('0x2e')}];var _0x256df0=_[_0xb8f6('0x53')](_0x3da374,['value',_0x3dfa2d[_0xb8f6('0x34')]])['name'];return db['UserProfileSection'][_0xb8f6('0x53')]({'where':{'name':_0x256df0,'userProfileId':_0x2312d5[_0xb8f6('0x59')]},'raw':!![]})[_0xb8f6('0x2a')](function(_0x5556d5){if(_0x5556d5&&_0x5556d5[_0xb8f6('0x5a')]===0x0){return db[_0xb8f6('0x36')][_0xb8f6('0x61')]({'name':_0x3dfa2d[_0xb8f6('0x35')],'resourceId':_0x3dfa2d['id'],'type':_0x5556d5['name'],'sectionId':_0x5556d5['id']},{})['then'](function(){return _0xce53f;});}else{return _0xce53f;}})['catch'](function(_0x37873f){logger[_0xb8f6('0x5b')](_0xb8f6('0x5c'),_0x37873f);throw _0x37873f;});}return _0xce53f;});}})[_0xb8f6('0x2a')](respondWithResult(_0x2463ed,0xc9))[_0xb8f6('0x50')](handleError(_0x2463ed,null));};exports['update']=function(_0x34baf2,_0xf170e3){if(_0x34baf2[_0xb8f6('0x54')]['id']){delete _0x34baf2[_0xb8f6('0x54')]['id'];}return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x34baf2[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0xf170e3,null))[_0xb8f6('0x2a')](saveUpdates(_0x34baf2[_0xb8f6('0x54')],null))[_0xb8f6('0x2a')](respondWithResult(_0xf170e3,null))['catch'](handleError(_0xf170e3,null));};exports[_0xb8f6('0x2b')]=function(_0x55b72e,_0x5b547a){return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x55b72e[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x5b547a,null))['then'](removeEntity(_0x5b547a,null))[_0xb8f6('0x50')](handleError(_0x5b547a,null));};exports[_0xb8f6('0x63')]=function(_0x442b9d,_0x18967c,_0x3f04b2){var _0x454ca0={'raw':![],'where':{}};var _0x4684fb={};var _0x33f846={'count':0x0,'rows':[]};return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x442b9d['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x18967c,null))[_0xb8f6('0x2a')](function(_0x3ae9c4){if(_0x3ae9c4){_0x4684fb[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x65')][_0xb8f6('0x5e')]);_0x4684fb[_0xb8f6('0x3d')]=_[_0xb8f6('0x3c')](_0x442b9d[_0xb8f6('0x3d')]);_0x4684fb[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x4684fb[_0xb8f6('0x3e')],_0x4684fb['query']);_0x454ca0[_0xb8f6('0x3f')]=_['intersection'](_0x4684fb[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0x454ca0[_0xb8f6('0x3f')]=_0x454ca0['attributes'][_0xb8f6('0x42')]?_0x454ca0[_0xb8f6('0x3f')]:_0x4684fb[_0xb8f6('0x3e')];if(!_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x454ca0[_0xb8f6('0x21')]=qs['limit'](_0x442b9d[_0xb8f6('0x3d')]['limit']);_0x454ca0['offset']=qs[_0xb8f6('0x23')](_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x23')]);}_0x454ca0[_0xb8f6('0x45')]=qs['sort'](_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x454ca0['where']=qs['filters'](_[_0xb8f6('0x48')](_0x442b9d[_0xb8f6('0x3d')],_0x4684fb['filters']));_0x454ca0[_0xb8f6('0x47')][_0xb8f6('0x66')]=_0x3ae9c4['id'];if(_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x454ca0[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x454ca0[_0xb8f6('0x47')],{'$or':_['map'](_0x454ca0[_0xb8f6('0x3f')],function(_0x567190){var _0x42180c={};_0x42180c[_0x567190]={'$like':'%'+_0x442b9d[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x42180c;})});}_0x454ca0=_['merge']({},_0x454ca0,_0x442b9d[_0xb8f6('0x4c')]);return db[_0xb8f6('0x65')][_0xb8f6('0x22')]({'where':_0x454ca0[_0xb8f6('0x47')]})[_0xb8f6('0x2a')](function(_0x28998e){_0x33f846['count']=_0x28998e;if(_0x442b9d['query']['includeAll']){_0x454ca0[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x65')][_0xb8f6('0x67')](_0x454ca0);})[_0xb8f6('0x2a')](function(_0x5926c2){_0x33f846[_0xb8f6('0x4f')]=_0x5926c2;return _0x33f846;});}})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x18967c,_0x454ca0))['catch'](handleError(_0x18967c,null));};exports['getHopperHistories']=function(_0x41bf59,_0x2c8055,_0x37e28c){var _0x164219={'raw':!![],'where':{}};var _0x435e8e={};var _0x4ad371={'count':0x0,'rows':[]};return db['VoiceQueue']['findOne']({'where':{'id':_0x41bf59['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x2c8055,null))[_0xb8f6('0x2a')](function(_0x583afa){if(_0x583afa){_0x435e8e[_0xb8f6('0x3e')]=_['keys'](db['CmHopperHistory'][_0xb8f6('0x5e')]);_0x435e8e['query']=_[_0xb8f6('0x3c')](_0x41bf59['query']);_0x435e8e[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x435e8e[_0xb8f6('0x3e')],_0x435e8e[_0xb8f6('0x3d')]);_0x164219[_0xb8f6('0x3f')]=_['intersection'](_0x435e8e[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x41bf59[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0x164219[_0xb8f6('0x3f')]=_0x164219[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x164219['attributes']:_0x435e8e[_0xb8f6('0x3e')];if(!_0x41bf59['query'][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x164219[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x41bf59['query'][_0xb8f6('0x21')]);_0x164219[_0xb8f6('0x23')]=qs[_0xb8f6('0x23')](_0x41bf59[_0xb8f6('0x3d')]['offset']);}_0x164219[_0xb8f6('0x45')]=qs[_0xb8f6('0x46')](_0x41bf59[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x164219['where']=qs['filters'](_[_0xb8f6('0x48')](_0x41bf59[_0xb8f6('0x3d')],_0x435e8e[_0xb8f6('0x49')]));_0x164219[_0xb8f6('0x47')][_0xb8f6('0x66')]=_0x583afa['id'];if(_0x41bf59['query']['filter']){_0x164219[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x164219[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x164219['attributes'],function(_0x5347f5){var _0x27622d={};_0x27622d[_0x5347f5]={'$like':'%'+_0x41bf59[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x27622d;})});}_0x164219=_[_0xb8f6('0x4b')]({},_0x164219,_0x41bf59[_0xb8f6('0x4c')]);return db[_0xb8f6('0x68')][_0xb8f6('0x22')]({'where':_0x164219[_0xb8f6('0x47')]})[_0xb8f6('0x2a')](function(_0x36ad59){_0x4ad371['count']=_0x36ad59;if(_0x41bf59[_0xb8f6('0x3d')][_0xb8f6('0x4d')]){_0x164219[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x68')]['findAll'](_0x164219);})[_0xb8f6('0x2a')](function(_0x47ab85){_0x4ad371[_0xb8f6('0x4f')]=_0x47ab85;return _0x4ad371;});}})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x2c8055,_0x164219))['catch'](handleError(_0x2c8055,null));};exports[_0xb8f6('0x69')]=function(_0x34b15c,_0x8cc47c,_0x343168){var _0x910baa={'raw':!![],'where':{}};var _0x25e482={};var _0x562671={'count':0x0,'rows':[]};return db[_0xb8f6('0x3a')]['findOne']({'where':{'id':_0x34b15c[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x8cc47c,null))[_0xb8f6('0x2a')](function(_0x2feb9c){if(_0x2feb9c){_0x25e482['model']=_['keys'](db[_0xb8f6('0x6a')][_0xb8f6('0x5e')]);_0x25e482['query']=_[_0xb8f6('0x3c')](_0x34b15c[_0xb8f6('0x3d')]);_0x25e482[_0xb8f6('0x49')]=_['intersection'](_0x25e482[_0xb8f6('0x3e')],_0x25e482[_0xb8f6('0x3d')]);_0x910baa['attributes']=_[_0xb8f6('0x40')](_0x25e482[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x34b15c[_0xb8f6('0x3d')]['fields']));_0x910baa['attributes']=_0x910baa[_0xb8f6('0x3f')]['length']?_0x910baa[_0xb8f6('0x3f')]:_0x25e482[_0xb8f6('0x3e')];if(!_0x34b15c[_0xb8f6('0x3d')][_0xb8f6('0x43')]('nolimit')){_0x910baa['limit']=qs[_0xb8f6('0x21')](_0x34b15c[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x910baa[_0xb8f6('0x23')]=qs['offset'](_0x34b15c['query'][_0xb8f6('0x23')]);}_0x910baa[_0xb8f6('0x45')]=qs[_0xb8f6('0x46')](_0x34b15c['query'][_0xb8f6('0x46')]);_0x910baa[_0xb8f6('0x47')]=qs[_0xb8f6('0x49')](_['pick'](_0x34b15c[_0xb8f6('0x3d')],_0x25e482[_0xb8f6('0x49')]));_0x910baa[_0xb8f6('0x47')]['VoiceQueueId']=_0x2feb9c['id'];if(_0x34b15c[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x910baa[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x910baa[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x910baa[_0xb8f6('0x3f')],function(_0x280031){var _0x17aca4={};_0x17aca4[_0x280031]={'$like':'%'+_0x34b15c[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x17aca4;})});}_0x910baa=_[_0xb8f6('0x4b')]({},_0x910baa,_0x34b15c[_0xb8f6('0x4c')]);return db[_0xb8f6('0x6a')][_0xb8f6('0x22')]({'where':_0x910baa[_0xb8f6('0x47')]})[_0xb8f6('0x2a')](function(_0x3c2134){_0x562671['count']=_0x3c2134;if(_0x34b15c[_0xb8f6('0x3d')]['includeAll']){_0x910baa[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x6a')]['findAll'](_0x910baa);})['then'](function(_0x2773f2){_0x562671['rows']=_0x2773f2;return _0x562671;});}})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x8cc47c,_0x910baa))['catch'](handleError(_0x8cc47c,null));};exports[_0xb8f6('0x6b')]=function(_0x240edd,_0x590b72,_0x4433ab){var _0x45addb={'raw':!![],'where':{}};var _0x175cc2={};var _0x380191={'count':0x0,'rows':[]};return db[_0xb8f6('0x3a')]['findOne']({'where':{'id':_0x240edd[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x590b72,null))[_0xb8f6('0x2a')](function(_0x230f75){if(_0x230f75){_0x175cc2[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x6c')][_0xb8f6('0x5e')]);_0x175cc2['query']=_['keys'](_0x240edd['query']);_0x175cc2[_0xb8f6('0x49')]=_['intersection'](_0x175cc2[_0xb8f6('0x3e')],_0x175cc2[_0xb8f6('0x3d')]);_0x45addb[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x175cc2[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x240edd[_0xb8f6('0x3d')]['fields']));_0x45addb[_0xb8f6('0x3f')]=_0x45addb[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x45addb[_0xb8f6('0x3f')]:_0x175cc2[_0xb8f6('0x3e')];if(!_0x240edd[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x45addb[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x240edd[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x45addb[_0xb8f6('0x23')]=qs[_0xb8f6('0x23')](_0x240edd[_0xb8f6('0x3d')]['offset']);}_0x45addb[_0xb8f6('0x45')]=qs[_0xb8f6('0x46')](_0x240edd['query'][_0xb8f6('0x46')]);_0x45addb[_0xb8f6('0x47')]=qs[_0xb8f6('0x49')](_[_0xb8f6('0x48')](_0x240edd['query'],_0x175cc2[_0xb8f6('0x49')]));_0x45addb[_0xb8f6('0x47')][_0xb8f6('0x66')]=_0x230f75['id'];if(_0x240edd['query']['filter']){_0x45addb[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x45addb[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x45addb['attributes'],function(_0x2a63ae){var _0xa4666f={};_0xa4666f[_0x2a63ae]={'$like':'%'+_0x240edd['query'][_0xb8f6('0x2f')]+'%'};return _0xa4666f;})});}_0x45addb=_['merge']({},_0x45addb,_0x240edd[_0xb8f6('0x4c')]);return db[_0xb8f6('0x6c')]['count']({'where':_0x45addb[_0xb8f6('0x47')]})['then'](function(_0x451740){_0x380191[_0xb8f6('0x22')]=_0x451740;if(_0x240edd[_0xb8f6('0x3d')]['includeAll']){_0x45addb[_0xb8f6('0x4e')]=[{'all':!![]}];}return db[_0xb8f6('0x6c')][_0xb8f6('0x67')](_0x45addb);})[_0xb8f6('0x2a')](function(_0x379f58){_0x380191[_0xb8f6('0x4f')]=_0x379f58;return _0x380191;});}})[_0xb8f6('0x2a')](respondWithFilteredResult(_0x590b72,_0x45addb))['catch'](handleError(_0x590b72,null));};exports[_0xb8f6('0x6d')]=function(_0x12b220,_0x49403d,_0x24a2ec){var _0xbab6b3={};var _0x18a0df={};var _0x2187c0;var _0x5677a6;return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x12b220['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x49403d,null))[_0xb8f6('0x2a')](function(_0x4820ac){if(_0x4820ac){_0x2187c0=_0x4820ac;_0x18a0df[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x6e')][_0xb8f6('0x5e')]);_0x18a0df['query']=_[_0xb8f6('0x3c')](_0x12b220[_0xb8f6('0x3d')]);_0x18a0df[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x18a0df[_0xb8f6('0x3e')],_0x18a0df['query']);_0xbab6b3['attributes']=_[_0xb8f6('0x40')](_0x18a0df[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x12b220[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0xbab6b3['attributes']=_0xbab6b3[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0xbab6b3[_0xb8f6('0x3f')]:_0x18a0df[_0xb8f6('0x3e')];_0xbab6b3[_0xb8f6('0x45')]=qs['sort'](_0x12b220[_0xb8f6('0x3d')]['sort']);_0xbab6b3[_0xb8f6('0x47')]=qs[_0xb8f6('0x49')](_[_0xb8f6('0x48')](_0x12b220[_0xb8f6('0x3d')],_0x18a0df[_0xb8f6('0x49')]));if(_0x12b220['query'][_0xb8f6('0x2f')]){_0xbab6b3[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0xbab6b3[_0xb8f6('0x47')],{'$or':_['map'](_0xbab6b3[_0xb8f6('0x3f')],function(_0x566fea){var _0x5b402f={};_0x5b402f[_0x566fea]={'$like':'%'+_0x12b220['query'][_0xb8f6('0x2f')]+'%'};return _0x5b402f;})});}_0xbab6b3=_[_0xb8f6('0x4b')]({},_0xbab6b3,_0x12b220['options']);return _0x2187c0[_0xb8f6('0x6d')](_0xbab6b3);}})[_0xb8f6('0x2a')](function(_0x37109d){if(_0x37109d){_0x5677a6=_0x37109d['length'];if(!_0x12b220['query']['hasOwnProperty']('nolimit')){_0xbab6b3[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x12b220[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0xbab6b3[_0xb8f6('0x23')]=qs['offset'](_0x12b220[_0xb8f6('0x3d')]['offset']);}return _0x2187c0['getTeams'](_0xbab6b3);}})[_0xb8f6('0x2a')](function(_0xa80e81){if(_0xa80e81){return _0xa80e81?{'count':_0x5677a6,'rows':_0xa80e81}:null;}})[_0xb8f6('0x2a')](respondWithResult(_0x49403d,null))['catch'](handleError(_0x49403d,null));};exports[_0xb8f6('0x6f')]=function(_0x9c9558,_0x164f8a,_0x6e4170){var _0x3927e7=_0x9c9558[_0xb8f6('0x54')][_0xb8f6('0x70')];var _0x254e42=_[_0xb8f6('0x31')](_0x3927e7,'id');return db[_0xb8f6('0x6e')][_0xb8f6('0x67')]({'where':{'id':_0x254e42},'attributes':['id'],'include':[{'model':db[_0xb8f6('0x71')],'as':'Agents','attributes':['id',_0xb8f6('0x35'),_0xb8f6('0x72'),'voicePause','interface'],'raw':!![]}]})['then'](function(_0x41dfc0){if(_0x41dfc0){var _0x117c53=_[_0xb8f6('0x73')](_0x41dfc0,function(_0x4e1696){var _0x2e714b=_0x4e1696[_0xb8f6('0x57')]({'plain':!![]});_0x2e714b[_0xb8f6('0x74')]['forEach'](function(_0x1a3c91){_0x1a3c91[_0xb8f6('0x75')]=_[_0xb8f6('0x53')](_0x3927e7,{'id':_0x2e714b['id']})[_0xb8f6('0x75')];});return _0x2e714b[_0xb8f6('0x74')];});return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x9c9558[_0xb8f6('0x52')]['id']}})['then'](function(_0x1685fd){return db[_0xb8f6('0x76')][_0xb8f6('0x77')](function(_0x12f8a){return _0x1685fd[_0xb8f6('0x6f')](_0x254e42,{'transaction':_0x12f8a})['then'](function(){return BPromise[_0xb8f6('0x78')](_0x3927e7,function(_0x55b680){return db[_0xb8f6('0x79')][_0xb8f6('0x7a')]({'TeamId':_0x55b680['id'],'VoiceQueueId':_0x9c9558[_0xb8f6('0x52')]['id'],'penalty':_0x55b680['penalty']},{'transaction':_0x12f8a});});})[_0xb8f6('0x2a')](function(){return BPromise[_0xb8f6('0x78')](_0x117c53,function(_0x437491){return db[_0xb8f6('0x7b')][_0xb8f6('0x7c')]({'where':{'UserId':_0x437491['id'],'VoiceQueueId':_0x9c9558['params']['id']},'defaults':{'penalty':_0x437491[_0xb8f6('0x75')]},'transaction':_0x12f8a});});})['then'](function(){return BPromise[_0xb8f6('0x78')](_[_0xb8f6('0x2f')](_0x117c53,{'online':!![]}),function(_0x1ca744){return db[_0xb8f6('0x7d')][_0xb8f6('0x7a')]({'membername':_0x1ca744[_0xb8f6('0x35')],'UserId':_0x1ca744['id'],'queue_name':_0x1685fd[_0xb8f6('0x35')],'VoiceQueueId':_0x1685fd['id'],'interface':_[_0xb8f6('0x7e')](_0x1ca744[_0xb8f6('0x7f')])?util[_0xb8f6('0x80')](_0xb8f6('0x81'),_0x1ca744['name']):_0x1ca744[_0xb8f6('0x7f')],'paused':_0x1ca744[_0xb8f6('0x82')]||![],'penalty':_0x1ca744[_0xb8f6('0x75')]},{'transaction':_0x12f8a});});})[_0xb8f6('0x2a')](function(){_0x117c53['forEach'](function(_0x2ea673){socket[_0xb8f6('0x83')](_0xb8f6('0x84'),{'UserId':_0x2ea673['id'],'VoiceQueueId':_0x1685fd['id']});});});});});}})[_0xb8f6('0x2a')](respondWithStatusCode(_0x164f8a,null))[_0xb8f6('0x50')](handleError(_0x164f8a,null));};exports[_0xb8f6('0x85')]=function(_0x4c3e2a,_0x2f91cc,_0x5f1cb9){return db[_0xb8f6('0x6e')][_0xb8f6('0x67')]({'where':{'id':_0x4c3e2a[_0xb8f6('0x3d')]['ids']},'attributes':['id'],'include':[{'model':db[_0xb8f6('0x71')],'as':_0xb8f6('0x74'),'attributes':['id'],'raw':!![]}]})[_0xb8f6('0x2a')](handleEntityNotFound(_0x2f91cc,null))[_0xb8f6('0x2a')](function(_0x243b99){var _0x43111a=_[_0xb8f6('0x31')](_0x243b99,'id');var _0x2194c8=[];var _0x2dbbb2=[];var _0x2e585e=squel[_0xb8f6('0x86')]();_0x2e585e[_0xb8f6('0x87')](_0xb8f6('0x88'))[_0xb8f6('0x89')](_0xb8f6('0x8a'),'tq')[_0xb8f6('0x8b')](_0xb8f6('0x8c'),'ut',_0xb8f6('0x8d'))[_0xb8f6('0x47')](_0xb8f6('0x8e'),_0x4c3e2a[_0xb8f6('0x52')]['id']);for(var _0x272257=0x0;_0x272257<_0x243b99[_0xb8f6('0x42')];_0x272257+=0x1){let _0x4bdf28=_0x243b99[_0x272257];for(var _0x27bc7a=0x0;_0x27bc7a<_0x4bdf28[_0xb8f6('0x74')][_0xb8f6('0x42')];_0x27bc7a+=0x1){let _0x58f1c=_0x4bdf28[_0xb8f6('0x74')][_0x27bc7a];var _0x1260fe=_0x2e585e[_0xb8f6('0x5d')]();_0x1260fe['where'](_0xb8f6('0x8f'),_0x58f1c['id']);_0x2dbbb2['push'](db[_0xb8f6('0x76')][_0xb8f6('0x3d')](_0x1260fe['toString'](),{'type':db[_0xb8f6('0x76')][_0xb8f6('0x90')]['SELECT']})['then'](function(_0x24c879){if(_0x24c879[_0xb8f6('0x42')]===0x1){return _0x58f1c['id'];}else{var _0x4fbaa6=_[_0xb8f6('0x91')](_['map'](_0x24c879,_0xb8f6('0x92')),function(_0x4e8c0f){return _[_0xb8f6('0x32')](_0x43111a,_0x4e8c0f);});if(_0x4fbaa6){return _0x58f1c['id'];}}}));}}return BPromise[_0xb8f6('0x93')](_0x2dbbb2)['then'](function(_0x4164f5){_0x2194c8=_(_0x2194c8)[_0xb8f6('0x94')](_0x4164f5)['compact']()[_0xb8f6('0x33')]();return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x4c3e2a[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](function(_0x2ed3d7){return db['sequelize'][_0xb8f6('0x77')](function(_0xdc912f){return _0x2ed3d7[_0xb8f6('0x85')](_0x4c3e2a[_0xb8f6('0x3d')]['ids'],{'transaction':_0xdc912f})[_0xb8f6('0x2a')](function(){if(!_[_0xb8f6('0x95')](_0x2194c8)){return _0x2ed3d7['removeAgents'](_0x2194c8,{'transaction':_0xdc912f})[_0xb8f6('0x2a')](function(){return db['UserVoiceQueueRt']['destroy']({'where':{'VoiceQueueId':_0x4c3e2a['params']['id'],'UserId':_0x2194c8},'transaction':_0xdc912f});});}})[_0xb8f6('0x2a')](function(){_0x2194c8['forEach'](function(_0x4b5007){socket[_0xb8f6('0x83')](_0xb8f6('0x96'),{'UserId':_0x4b5007,'VoiceQueueId':_0x2ed3d7['id']});});});});});});})[_0xb8f6('0x2a')](respondWithStatusCode(_0x2f91cc,null))['catch'](handleError(_0x2f91cc,null));};exports[_0xb8f6('0x97')]=function(_0x2271d4,_0x49c3a6,_0x159c45){var _0x58330f,_0x568960;return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x2271d4[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x49c3a6,null))['then'](function(_0x5a7274){if(_0x5a7274){_0x568960=_0x5a7274;return _0x5a7274[_0xb8f6('0x97')](_0x2271d4[_0xb8f6('0x54')][_0xb8f6('0x98')],_[_0xb8f6('0x5f')](_0x2271d4[_0xb8f6('0x54')],[_0xb8f6('0x98'),'id'])||{})[_0xb8f6('0x99')](function(_0x2cc0f8){for(var _0x2f0270=0x0;_0x2f0270<_0x2271d4[_0xb8f6('0x54')]['ids'][_0xb8f6('0x42')];_0x2f0270+=0x1){socket['emit']('userVoiceQueue:save',{'UserId':Number(_0x2271d4[_0xb8f6('0x54')][_0xb8f6('0x98')][_0x2f0270]),'VoiceQueueId':Number(_0x2271d4[_0xb8f6('0x52')]['id'])});}return _0x2cc0f8;});}})[_0xb8f6('0x2a')](function(_0x4c2b73){_0x58330f=_0x4c2b73||[];if(_0x568960){return db[_0xb8f6('0x71')]['findAll']({'where':{'id':_0x2271d4[_0xb8f6('0x54')]['ids']},'attributes':['id',_0xb8f6('0x35'),'online',_0xb8f6('0x82'),_0xb8f6('0x7f')],'raw':!![]});}})['then'](function(_0x30add6){if(!_[_0xb8f6('0x95')](_0x30add6)){var _0x10423b=[];for(var _0x365532=0x0;_0x365532<_0x30add6['length'];_0x365532++){if(_0x30add6[_0x365532][_0xb8f6('0x72')]){_0x10423b[_0xb8f6('0x9a')](db['UserVoiceQueueRt']['upsert']({'membername':_0x30add6[_0x365532]['name'],'UserId':_0x30add6[_0x365532]['id'],'queue_name':_0x568960[_0xb8f6('0x35')],'VoiceQueueId':_0x568960['id'],'interface':_[_0xb8f6('0x7e')](_0x30add6[_0x365532][_0xb8f6('0x7f')])?util[_0xb8f6('0x80')](_0xb8f6('0x81'),_0x30add6[_0x365532][_0xb8f6('0x35')]):_0x30add6[_0x365532][_0xb8f6('0x7f')],'paused':_0x30add6[_0x365532][_0xb8f6('0x82')]||![],'penalty':_0x2271d4[_0xb8f6('0x54')]['penalty']||0x0}));}}return BPromise[_0xb8f6('0x93')](_0x10423b);}})[_0xb8f6('0x2a')](function(){return _0x58330f;})['then'](respondWithResult(_0x49c3a6,null))['catch'](handleError(_0x49c3a6,null));};exports[_0xb8f6('0x9b')]=function(_0x3a234a,_0xa55633,_0x391b2e){return db['VoiceQueue'][_0xb8f6('0x53')]({'where':{'id':_0x3a234a[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0xa55633,null))[_0xb8f6('0x2a')](function(_0x49365a){if(_0x49365a){return _0x49365a[_0xb8f6('0x9b')](_0x3a234a[_0xb8f6('0x3d')][_0xb8f6('0x98')])[_0xb8f6('0x2a')](function(){if(_[_0xb8f6('0x9c')](_0x3a234a[_0xb8f6('0x3d')][_0xb8f6('0x98')])){for(var _0x801f2e=0x0;_0x801f2e<_0x3a234a[_0xb8f6('0x3d')][_0xb8f6('0x98')][_0xb8f6('0x42')];_0x801f2e+=0x1){socket[_0xb8f6('0x83')](_0xb8f6('0x96'),{'UserId':Number(_0x3a234a[_0xb8f6('0x3d')]['ids'][_0x801f2e]),'VoiceQueueId':Number(_0x3a234a[_0xb8f6('0x52')]['id'])});}}else{socket[_0xb8f6('0x83')](_0xb8f6('0x96'),{'UserId':Number(_0x3a234a['query']['ids']),'VoiceQueueId':Number(_0x3a234a[_0xb8f6('0x52')]['id'])});}});}})[_0xb8f6('0x2a')](function(_0xded28c){return db[_0xb8f6('0x7d')][_0xb8f6('0x2b')]({'where':{'VoiceQueueId':_0x3a234a[_0xb8f6('0x52')]['id'],'UserId':_0x3a234a[_0xb8f6('0x3d')]['ids']}})['then'](function(){return _0xded28c;});})[_0xb8f6('0x2a')](respondWithStatusCode(_0xa55633,null))[_0xb8f6('0x50')](handleError(_0xa55633,null));};exports['getAgents']=function(_0x302960,_0xf4e658,_0xc2d373){var _0x22dd7c={};var _0x2c0d95={};var _0x4c1e01;var _0x51d40e;return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x302960[_0xb8f6('0x52')]['id']}})['then'](handleEntityNotFound(_0xf4e658,null))[_0xb8f6('0x2a')](function(_0x3c8ed5){if(_0x3c8ed5){_0x4c1e01=_0x3c8ed5;_0x2c0d95[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x71')][_0xb8f6('0x5e')]);_0x2c0d95[_0xb8f6('0x3d')]=_['keys'](_0x302960[_0xb8f6('0x3d')]);_0x2c0d95['filters']=_['intersection'](_0x2c0d95[_0xb8f6('0x3e')],_0x2c0d95[_0xb8f6('0x3d')]);_0x22dd7c['attributes']=_[_0xb8f6('0x40')](_0x2c0d95['model'],qs[_0xb8f6('0x41')](_0x302960[_0xb8f6('0x3d')]['fields']));_0x22dd7c[_0xb8f6('0x3f')]=_0x22dd7c[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x22dd7c[_0xb8f6('0x3f')]:_0x2c0d95[_0xb8f6('0x3e')];_0x22dd7c['order']=qs[_0xb8f6('0x46')](_0x302960['query'][_0xb8f6('0x46')]);_0x22dd7c[_0xb8f6('0x47')]=qs['filters'](_[_0xb8f6('0x48')](_0x302960['query'],_0x2c0d95['filters']));if(_0x302960[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x22dd7c['where']=_[_0xb8f6('0x4b')](_0x22dd7c[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x22dd7c['attributes'],function(_0x43a6af){var _0x52d4df={};_0x52d4df[_0x43a6af]={'$like':'%'+_0x302960[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x52d4df;})});}_0x22dd7c=_['merge']({},_0x22dd7c,_0x302960[_0xb8f6('0x4c')]);return _0x4c1e01['getAgents'](_0x22dd7c);}})[_0xb8f6('0x2a')](function(_0x52e0ef){if(_0x52e0ef){_0x51d40e=_0x52e0ef[_0xb8f6('0x42')];if(!_0x302960[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x22dd7c[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x302960[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x22dd7c[_0xb8f6('0x23')]=qs[_0xb8f6('0x23')](_0x302960['query'][_0xb8f6('0x23')]);}return _0x4c1e01[_0xb8f6('0x9d')](_0x22dd7c);}})[_0xb8f6('0x2a')](function(_0x5ac6a8){if(_0x5ac6a8){return _0x5ac6a8?{'count':_0x51d40e,'rows':_0x5ac6a8}:null;}})[_0xb8f6('0x2a')](respondWithResult(_0xf4e658,null))[_0xb8f6('0x50')](handleError(_0xf4e658,null));};exports[_0xb8f6('0x9e')]=function(_0x550a63,_0x50dcbe,_0x4563b1){var _0x3f9b3d={};var _0x2d17f6={};var _0x3f0209;var _0x122e64;return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x550a63[_0xb8f6('0x52')]['id']}})['then'](handleEntityNotFound(_0x50dcbe,null))[_0xb8f6('0x2a')](function(_0x16f845){if(_0x16f845){_0x3f0209=_0x16f845;_0x2d17f6[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x7d')][_0xb8f6('0x5e')]);_0x2d17f6['query']=_[_0xb8f6('0x3c')](_0x550a63[_0xb8f6('0x3d')]);_0x2d17f6['filters']=_['intersection'](_0x2d17f6[_0xb8f6('0x3e')],_0x2d17f6['query']);_0x3f9b3d['attributes']=_[_0xb8f6('0x40')](_0x2d17f6[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x41')]));_0x3f9b3d[_0xb8f6('0x3f')]=_0x3f9b3d[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x3f9b3d[_0xb8f6('0x3f')]:_0x2d17f6['model'];_0x3f9b3d['order']=qs[_0xb8f6('0x46')](_0x550a63[_0xb8f6('0x3d')]['sort']);_0x3f9b3d[_0xb8f6('0x47')]=qs['filters'](_[_0xb8f6('0x48')](_0x550a63['query'],_0x2d17f6[_0xb8f6('0x49')]));if(_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x3f9b3d[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x3f9b3d[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x3f9b3d[_0xb8f6('0x3f')],function(_0x5d8a0b){var _0x20e569={};_0x20e569[_0x5d8a0b]={'$like':'%'+_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x2f')]+'%'};return _0x20e569;})});}_0x3f9b3d=_[_0xb8f6('0x4b')]({},_0x3f9b3d,_0x550a63[_0xb8f6('0x4c')]);return _0x3f0209[_0xb8f6('0x9e')](_0x3f9b3d);}})[_0xb8f6('0x2a')](function(_0x57edb5){if(_0x57edb5){_0x122e64=_0x57edb5[_0xb8f6('0x42')];if(!_0x550a63[_0xb8f6('0x3d')]['hasOwnProperty'](_0xb8f6('0x44'))){_0x3f9b3d[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x21')]);_0x3f9b3d['offset']=qs['offset'](_0x550a63[_0xb8f6('0x3d')][_0xb8f6('0x23')]);}return _0x3f0209[_0xb8f6('0x9e')](_0x3f9b3d);}})[_0xb8f6('0x2a')](function(_0x214b9a){return _0x214b9a?{'count':_0x122e64,'rows':_0x214b9a}:null;})[_0xb8f6('0x2a')](respondWithResult(_0x50dcbe,null))[_0xb8f6('0x50')](handleError(_0x50dcbe,null));};exports['getLists']=function(_0x475791,_0x4cfa57,_0x113a60){var _0x47ebea={};var _0x41db42={};var _0x3c9e30;var _0x2f5bf3;return db[_0xb8f6('0x3a')][_0xb8f6('0x64')]({'where':{'id':_0x475791[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x4cfa57,null))[_0xb8f6('0x2a')](function(_0x528156){if(_0x528156){_0x3c9e30=_0x528156;_0x41db42[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x9f')][_0xb8f6('0x5e')]);_0x41db42[_0xb8f6('0x3d')]=_[_0xb8f6('0x3c')](_0x475791[_0xb8f6('0x3d')]);_0x41db42['filters']=_[_0xb8f6('0x40')](_0x41db42['model'],_0x41db42['query']);_0x47ebea['attributes']=_[_0xb8f6('0x40')](_0x41db42[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x475791[_0xb8f6('0x3d')]['fields']));_0x47ebea[_0xb8f6('0x3f')]=_0x47ebea[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x47ebea[_0xb8f6('0x3f')]:_0x41db42[_0xb8f6('0x3e')];_0x47ebea['order']=qs[_0xb8f6('0x46')](_0x475791[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x47ebea[_0xb8f6('0x47')]=qs[_0xb8f6('0x49')](_[_0xb8f6('0x48')](_0x475791[_0xb8f6('0x3d')],_0x41db42[_0xb8f6('0x49')]));if(_0x475791[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x47ebea[_0xb8f6('0x47')]=_['merge'](_0x47ebea[_0xb8f6('0x47')],{'$or':_['map'](_0x47ebea['attributes'],function(_0x32d87a){var _0x4cbc95={};_0x4cbc95[_0x32d87a]={'$like':'%'+_0x475791[_0xb8f6('0x3d')]['filter']+'%'};return _0x4cbc95;})});}_0x47ebea=_[_0xb8f6('0x4b')]({},_0x47ebea,_0x475791[_0xb8f6('0x4c')]);return _0x3c9e30['getLists'](_0x47ebea);}})[_0xb8f6('0x2a')](function(_0xf54ae9){if(_0xf54ae9){_0x2f5bf3=_0xf54ae9[_0xb8f6('0x42')];if(!_0x475791[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x47ebea[_0xb8f6('0x21')]=qs[_0xb8f6('0x21')](_0x475791[_0xb8f6('0x3d')]['limit']);_0x47ebea[_0xb8f6('0x23')]=qs['offset'](_0x475791['query']['offset']);}return _0x3c9e30[_0xb8f6('0xa0')](_0x47ebea);}})['then'](function(_0x1ad4a3){if(_0x1ad4a3){return _0x1ad4a3?{'count':_0x2f5bf3,'rows':_0x1ad4a3}:null;}})[_0xb8f6('0x2a')](respondWithResult(_0x4cfa57,null))[_0xb8f6('0x50')](handleError(_0x4cfa57,null));};exports[_0xb8f6('0xa1')]=function(_0x44d034,_0x5ba34a,_0xbafd08){var _0x20f45f=moment()['format']('YYYY-MM-DD\x20HH:mm:ss');var _0x1ebb54,_0xcf5610;return db['VoiceQueue']['find']({'where':{'id':_0x44d034['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x5ba34a,null))['then'](function(_0x154f01){if(_0x154f01){_0xcf5610=_0x154f01;return _0x154f01[_0xb8f6('0xa1')](_0x44d034[_0xb8f6('0x54')][_0xb8f6('0x98')],_[_0xb8f6('0x5f')](_0x44d034[_0xb8f6('0x54')],[_0xb8f6('0x98'),'id'])||{});}return null;})[_0xb8f6('0x99')](function(_0x2fb788){var _0x489313;_0x1ebb54=_0x2fb788||[];var _0x33ca2a=[];if(_0x2fb788){for(var _0x575018=0x0;_0x575018<_0x2fb788['length'];_0x575018+=0x1){var _0x2e57da=_0x2fb788[_0x575018][_0xb8f6('0x57')]({'plain':!![]});_0xcf5610[_0xb8f6('0xa2')]=_0x44d034['body']['dialCheckDuplicateType']?_0x44d034[_0xb8f6('0x54')][_0xb8f6('0xa2')]:_0xcf5610[_0xb8f6('0xa2')];switch(_0xcf5610['dialCheckDuplicateType']){case _0xb8f6('0xa3'):_0x489313=squel[_0xb8f6('0xa4')]()['into']('cm_hopper')[_0xb8f6('0xa5')]([_0xb8f6('0xa6'),_0xb8f6('0xa7'),_0xb8f6('0xa8'),_0xb8f6('0xa9'),_0xb8f6('0x66'),_0xb8f6('0x60'),_0xb8f6('0xaa')],squel[_0xb8f6('0x86')]()[_0xb8f6('0x87')](_0xb8f6('0xa6'),'phone')['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0xa7'))[_0xb8f6('0x87')]('id',_0xb8f6('0xa8'))['field'](_0x2e57da['CmListId'][_0xb8f6('0xab')](),'ListId')[_0xb8f6('0x87')](_0x44d034[_0xb8f6('0x52')]['id']['toString'](),_0xb8f6('0x66'))['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0x60'))['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0xaa'))[_0xb8f6('0x89')](_0xb8f6('0xac'))[_0xb8f6('0x47')](_0xb8f6('0xad'))[_0xb8f6('0x47')](_0xb8f6('0xae'),_0x2e57da[_0xb8f6('0xaf')][_0xb8f6('0xab')]())[_0xb8f6('0x47')](_0xb8f6('0xb0'))[_0xb8f6('0x47')]('phone\x20NOT\x20IN\x20(?)',squel[_0xb8f6('0x86')]()[_0xb8f6('0x87')](_0xb8f6('0xb1'))[_0xb8f6('0x89')]('cm_hopper_final')[_0xb8f6('0x47')](_0xb8f6('0x8e'),_0x44d034[_0xb8f6('0x52')]['id'][_0xb8f6('0xab')]()))[_0xb8f6('0x47')]('phone\x20NOT\x20IN\x20(?)',squel[_0xb8f6('0x86')]()['field']('COALESCE(phone,\x27\x27)')[_0xb8f6('0x89')](_0xb8f6('0xb2'))[_0xb8f6('0x47')](_0xb8f6('0x8e'),_0x44d034[_0xb8f6('0x52')]['id']['toString']())))[_0xb8f6('0xab')]();break;case _0xb8f6('0xb3'):_0x489313=squel[_0xb8f6('0xa4')]()[_0xb8f6('0xb4')](_0xb8f6('0xb2'))['fromQuery']([_0xb8f6('0xa6'),_0xb8f6('0xa7'),_0xb8f6('0xa8'),_0xb8f6('0xa9'),'VoiceQueueId',_0xb8f6('0x60'),_0xb8f6('0xaa')],squel['select']()[_0xb8f6('0x87')]('phone',_0xb8f6('0xa6'))[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27',_0xb8f6('0xa7'))[_0xb8f6('0x87')]('id',_0xb8f6('0xa8'))[_0xb8f6('0x87')](_0x2e57da[_0xb8f6('0xaf')]['toString'](),_0xb8f6('0xa9'))[_0xb8f6('0x87')](_0x44d034[_0xb8f6('0x52')]['id']['toString'](),'VoiceQueueId')[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27',_0xb8f6('0x60'))[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27','updatedAt')['from'](_0xb8f6('0xac'))[_0xb8f6('0x47')](_0xb8f6('0xad'))[_0xb8f6('0x47')]('ListId\x20=\x20?',_0x2e57da[_0xb8f6('0xaf')]['toString']())[_0xb8f6('0x47')]('phone\x20IS\x20NOT\x20NULL')['where']('phone\x20NOT\x20IN\x20(?)',squel[_0xb8f6('0x86')]()['field'](_0xb8f6('0xb5'))['from'](_0xb8f6('0xb2'))[_0xb8f6('0x47')](_0xb8f6('0x8e'),_0x44d034[_0xb8f6('0x52')]['id'][_0xb8f6('0xab')]())))[_0xb8f6('0xab')]();break;default:_0x489313=squel[_0xb8f6('0xa4')]()[_0xb8f6('0xb4')]('cm_hopper')['fromQuery'](['phone',_0xb8f6('0xa7'),_0xb8f6('0xa8'),'ListId',_0xb8f6('0x66'),_0xb8f6('0x60'),_0xb8f6('0xaa')],squel['select']()[_0xb8f6('0x87')](_0xb8f6('0xa6'),_0xb8f6('0xa6'))[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27','scheduledAt')[_0xb8f6('0x87')]('id',_0xb8f6('0xa8'))[_0xb8f6('0x87')](_0x2e57da[_0xb8f6('0xaf')][_0xb8f6('0xab')](),_0xb8f6('0xa9'))[_0xb8f6('0x87')](_0x44d034['params']['id'][_0xb8f6('0xab')](),'VoiceQueueId')[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27',_0xb8f6('0x60'))['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0xaa'))['from'](_0xb8f6('0xac'))[_0xb8f6('0x47')](_0xb8f6('0xad'))[_0xb8f6('0x47')]('ListId\x20=\x20?',_0x2e57da['CmListId'][_0xb8f6('0xab')]())['where'](_0xb8f6('0xb0')))[_0xb8f6('0xab')]();}_0x33ca2a[_0xb8f6('0x9a')](db[_0xb8f6('0x76')][_0xb8f6('0x3d')](_0x489313));}return BPromise['all'](_0x33ca2a);}})[_0xb8f6('0x2a')](function(){var _0x3a1dcc=[];var _0x41c30a=squel['insert']()['into']('cm_hopper_additional_phones')[_0xb8f6('0xa5')]([_0xb8f6('0xb6'),_0xb8f6('0xa6'),_0xb8f6('0xb7'),'createdAt',_0xb8f6('0xaa')],squel['select']()['field'](_0xb8f6('0xb8'))[_0xb8f6('0x87')](_0xb8f6('0xb9'))[_0xb8f6('0x87')]('ci.OrderBy+1')[_0xb8f6('0x87')]('\x27'+_0x20f45f+'\x27',_0xb8f6('0x60'))['field']('\x27'+_0x20f45f+'\x27',_0xb8f6('0xaa'))['from'](_0xb8f6('0xba'),'ci')[_0xb8f6('0x8b')]('cm_hopper','h',_0xb8f6('0xbb'))[_0xb8f6('0x47')](_0xb8f6('0xbc'),_0x20f45f)[_0xb8f6('0x47')](_0xb8f6('0xbd'),_0xb8f6('0xbe')))[_0xb8f6('0xab')]();_0x3a1dcc[_0xb8f6('0x9a')](db[_0xb8f6('0x76')][_0xb8f6('0x3d')](_0x41c30a));return BPromise[_0xb8f6('0x93')](_0x3a1dcc);})[_0xb8f6('0x2a')](function(){return _0x1ebb54;})[_0xb8f6('0x2a')](respondWithResult(_0x5ba34a,null))[_0xb8f6('0x50')](handleError(_0x5ba34a,null));};exports['removeLists']=function(_0x579e0e,_0x431240,_0x245f88){return db[_0xb8f6('0x3a')][_0xb8f6('0x53')]({'where':{'id':_0x579e0e['params']['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x431240,null))['then'](function(_0x2aaf49){if(_0x2aaf49){return _0x2aaf49[_0xb8f6('0xbf')](_0x579e0e[_0xb8f6('0x3d')][_0xb8f6('0x98')]);}})[_0xb8f6('0x2a')](function(_0x21c5b6){if(_0x21c5b6){return db[_0xb8f6('0x65')][_0xb8f6('0x2b')]({'where':{'ListId':_0x579e0e[_0xb8f6('0x3d')][_0xb8f6('0x98')],'VoiceQueueId':_0x579e0e['params']['id']}})[_0xb8f6('0x2a')](function(){return _0x21c5b6;});}})[_0xb8f6('0x2a')](respondWithStatusCode(_0x431240,null))['catch'](handleError(_0x431240,null));};exports[_0xb8f6('0xc0')]=function(_0x40d0f0,_0x22da7a,_0x2df9cb){var _0x50d060={};var _0x3cb302={};var _0x433956;var _0xd39fa4;return db['VoiceQueue'][_0xb8f6('0x64')]({'where':{'id':_0x40d0f0[_0xb8f6('0x52')]['id']}})['then'](handleEntityNotFound(_0x22da7a,null))[_0xb8f6('0x2a')](function(_0x239212){if(_0x239212){_0x433956=_0x239212;_0x3cb302[_0xb8f6('0x3e')]=_[_0xb8f6('0x3c')](db[_0xb8f6('0x9f')][_0xb8f6('0x5e')]);_0x3cb302[_0xb8f6('0x3d')]=_[_0xb8f6('0x3c')](_0x40d0f0['query']);_0x3cb302[_0xb8f6('0x49')]=_[_0xb8f6('0x40')](_0x3cb302[_0xb8f6('0x3e')],_0x3cb302[_0xb8f6('0x3d')]);_0x50d060[_0xb8f6('0x3f')]=_[_0xb8f6('0x40')](_0x3cb302[_0xb8f6('0x3e')],qs[_0xb8f6('0x41')](_0x40d0f0[_0xb8f6('0x3d')]['fields']));_0x50d060[_0xb8f6('0x3f')]=_0x50d060[_0xb8f6('0x3f')][_0xb8f6('0x42')]?_0x50d060[_0xb8f6('0x3f')]:_0x3cb302[_0xb8f6('0x3e')];_0x50d060[_0xb8f6('0x45')]=qs[_0xb8f6('0x46')](_0x40d0f0[_0xb8f6('0x3d')][_0xb8f6('0x46')]);_0x50d060[_0xb8f6('0x47')]=qs['filters'](_[_0xb8f6('0x48')](_0x40d0f0[_0xb8f6('0x3d')],_0x3cb302[_0xb8f6('0x49')]));if(_0x40d0f0[_0xb8f6('0x3d')][_0xb8f6('0x2f')]){_0x50d060[_0xb8f6('0x47')]=_[_0xb8f6('0x4b')](_0x50d060[_0xb8f6('0x47')],{'$or':_[_0xb8f6('0x31')](_0x50d060[_0xb8f6('0x3f')],function(_0x293261){var _0x4e41c7={};_0x4e41c7[_0x293261]={'$like':'%'+_0x40d0f0['query'][_0xb8f6('0x2f')]+'%'};return _0x4e41c7;})});}_0x50d060=_[_0xb8f6('0x4b')]({},_0x50d060,_0x40d0f0[_0xb8f6('0x4c')]);return _0x433956[_0xb8f6('0xc0')](_0x50d060);}})[_0xb8f6('0x2a')](function(_0x445fa2){if(_0x445fa2){_0xd39fa4=_0x445fa2[_0xb8f6('0x42')];if(!_0x40d0f0[_0xb8f6('0x3d')][_0xb8f6('0x43')](_0xb8f6('0x44'))){_0x50d060['limit']=qs[_0xb8f6('0x21')](_0x40d0f0[_0xb8f6('0x3d')]['limit']);_0x50d060[_0xb8f6('0x23')]=qs['offset'](_0x40d0f0['query'][_0xb8f6('0x23')]);}return _0x433956[_0xb8f6('0xc0')](_0x50d060);}})[_0xb8f6('0x2a')](function(_0x226d61){if(_0x226d61){return _0x226d61?{'count':_0xd39fa4,'rows':_0x226d61}:null;}})[_0xb8f6('0x2a')](respondWithResult(_0x22da7a,null))[_0xb8f6('0x50')](handleError(_0x22da7a,null));};exports[_0xb8f6('0xc1')]=function(_0x3f4148,_0x1c17d5,_0x33cee2){var _0x5cdd96,_0x15684a;return db['VoiceQueue']['find']({'where':{'id':_0x3f4148[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x1c17d5,null))['then'](function(_0x22c171){if(_0x22c171){_0x15684a=_0x22c171;return _0x22c171[_0xb8f6('0xc1')](_0x3f4148[_0xb8f6('0x54')][_0xb8f6('0x98')],_[_0xb8f6('0x5f')](_0x3f4148[_0xb8f6('0x54')],[_0xb8f6('0x98'),'id'])||{});}return null;})['spread'](function(_0xdc77d7){var _0x2a2c54;_0x5cdd96=_0xdc77d7||[];var _0x80606d=[];if(_0xdc77d7){for(var _0x40a393=0x0;_0x40a393<_0xdc77d7[_0xb8f6('0x42')];_0x40a393+=0x1){var _0x1c2a07=_0xdc77d7[_0x40a393][_0xb8f6('0x57')]({'plain':!![]});_0x2a2c54=squel['insert']()['into'](_0xb8f6('0xc2'))[_0xb8f6('0xa5')]([_0xb8f6('0xa6'),_0xb8f6('0xa8'),_0xb8f6('0xa9'),_0xb8f6('0x66'),_0xb8f6('0x60'),'updatedAt'],squel[_0xb8f6('0x86')]()[_0xb8f6('0x87')](_0xb8f6('0xa6'),'phone')['field']('id',_0xb8f6('0xa8'))[_0xb8f6('0x87')](_0x1c2a07[_0xb8f6('0xaf')][_0xb8f6('0xab')](),_0xb8f6('0xa9'))[_0xb8f6('0x87')](_0x3f4148[_0xb8f6('0x52')]['id'][_0xb8f6('0xab')](),_0xb8f6('0x66'))['field'](_0xb8f6('0xc3'),'createdAt')['field'](_0xb8f6('0xc3'),_0xb8f6('0xaa'))[_0xb8f6('0x89')](_0xb8f6('0xac'))[_0xb8f6('0x47')](_0xb8f6('0xad'))[_0xb8f6('0x47')](_0xb8f6('0xae'),_0x1c2a07[_0xb8f6('0xaf')][_0xb8f6('0xab')]())['where'](_0xb8f6('0xb0')))[_0xb8f6('0xab')]();_0x80606d[_0xb8f6('0x9a')](db[_0xb8f6('0x76')]['query'](_0x2a2c54));}return BPromise[_0xb8f6('0x93')](_0x80606d);}})[_0xb8f6('0x2a')](function(){return _0x5cdd96;})[_0xb8f6('0x2a')](respondWithResult(_0x1c17d5,null))[_0xb8f6('0x50')](handleError(_0x1c17d5,null));};exports['removeBlackLists']=function(_0x33e334,_0x3b7526,_0x1020d7){return db['VoiceQueue'][_0xb8f6('0x53')]({'where':{'id':_0x33e334[_0xb8f6('0x52')]['id']}})[_0xb8f6('0x2a')](handleEntityNotFound(_0x3b7526,null))[_0xb8f6('0x2a')](function(_0x246a2b){if(_0x246a2b){return _0x246a2b[_0xb8f6('0xc4')](_0x33e334['query'][_0xb8f6('0x98')]);}})[_0xb8f6('0x2a')](function(_0xf37127){if(_0xf37127){return db[_0xb8f6('0x6c')][_0xb8f6('0x2b')]({'where':{'ListId':_0x33e334[_0xb8f6('0x3d')][_0xb8f6('0x98')],'VoiceQueueId':_0x33e334[_0xb8f6('0x52')]['id']}})['then'](function(){return _0xf37127;});}})[_0xb8f6('0x2a')](respondWithStatusCode(_0x3b7526,null))['catch'](handleError(_0x3b7526,null));};