// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x3e40=['filters','merge','VIRTUAL','filter','options','includeAll','include','rows','catch','show','params','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','IvrCampaigns','UserProfileSection','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','createdAt','updatedAt','role','userProfileId','findOne','CmHopper','CampaignId','getHopperHistories','CmHopperHistory','pick','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','findAll','getLists','CmList','addLists','format','YYYY-MM-DD\x20HH:mm:ss','ids','spread','dialCheckDuplicateType','always','insert','into','cm_hopper','scheduledAt','ContactId','ListId','field','phone','NOW()','CmListId','from','cm_contacts','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','toString','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','select','cm_hopper_final','CampaignId\x20=\x20?','COALESCE(phone,\x27\x27)','onlyIfOpen','fromQuery','cm_hopper_additional_phones','OrderBy','h.id','ci.item','ci.OrderBY','cm_contact_has_items','join','h.ContactId\x20=\x20ci.CmContactId','h.ListId\x20=\x20?','h.CampaignId=?','h.createdAt\x20=\x20?','sequelize','push','all','removeLists','getBlackLists','addBlackLists','cm_hopper_black','removeBlackLists','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','destroy','then','get','UserProfileResource','stack','name','index','map','Campaign','rawAttributes','fieldName','type','key','model','query','keys','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where'];(function(_0xacb1e2,_0x55e0ab){var _0x463815=function(_0x413c3b){while(--_0x413c3b){_0xacb1e2['push'](_0xacb1e2['shift']());}};_0x463815(++_0x55e0ab);}(_0x3e40,0xef));var _0x03e4=function(_0x34bf97,_0xc60f9d){_0x34bf97=_0x34bf97-0x0;var _0x292719=_0x3e40[_0x34bf97];return _0x292719;};'use strict';var emlformat=require(_0x03e4('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x03e4('0x1'));var jsonpatch=require(_0x03e4('0x2'));var rp=require(_0x03e4('0x3'));var moment=require(_0x03e4('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x03e4('0x5'));var util=require(_0x03e4('0x6'));var path=require('path');var sox=require(_0x03e4('0x7'));var csv=require(_0x03e4('0x8'));var ejs=require(_0x03e4('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x03e4('0xa'));var squel=require(_0x03e4('0xb'));var crypto=require(_0x03e4('0xc'));var jsforce=require(_0x03e4('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x03e4('0x8'));var querystring=require(_0x03e4('0xe'));var Papa=require(_0x03e4('0xf'));var Redis=require(_0x03e4('0x10'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x03e4('0x11'));var hardwareService=require(_0x03e4('0x12'));var logger=require(_0x03e4('0x13'))('api');var utils=require(_0x03e4('0x14'));var config=require(_0x03e4('0x15'));var licenseUtil=require(_0x03e4('0x16'));var db=require(_0x03e4('0x17'))['db'];function respondWithStatusCode(_0x2109cd,_0x170daf){_0x170daf=_0x170daf||0xcc;return function(_0x5d3cc6){if(_0x5d3cc6){return _0x2109cd[_0x03e4('0x18')](_0x170daf);}return _0x2109cd[_0x03e4('0x19')](_0x170daf)[_0x03e4('0x1a')]();};}function respondWithResult(_0x43c40f,_0x1a1203){_0x1a1203=_0x1a1203||0xc8;return function(_0x4f1ead){if(_0x4f1ead){return _0x43c40f[_0x03e4('0x19')](_0x1a1203)[_0x03e4('0x1b')](_0x4f1ead);}};}function respondWithFilteredResult(_0x5c3f8f,_0x521ef6){return function(_0x4d5c70){if(_0x4d5c70){var _0x32c51c=typeof _0x521ef6[_0x03e4('0x1c')]===_0x03e4('0x1d')&&typeof _0x521ef6[_0x03e4('0x1e')]===_0x03e4('0x1d');var _0x1bb524=_0x4d5c70['count'];var _0x4c28ed=_0x32c51c?0x0:_0x521ef6[_0x03e4('0x1c')];var _0x414978=_0x32c51c?_0x4d5c70[_0x03e4('0x1f')]:_0x521ef6[_0x03e4('0x1c')]+_0x521ef6['limit'];var _0x66844b;if(_0x414978>=_0x1bb524){_0x414978=_0x1bb524;_0x66844b=0xc8;}else{_0x66844b=0xce;}_0x5c3f8f['status'](_0x66844b);return _0x5c3f8f[_0x03e4('0x20')](_0x03e4('0x21'),_0x4c28ed+'-'+_0x414978+'/'+_0x1bb524)['json'](_0x4d5c70);}return null;};}function patchUpdates(_0x5a85f2){return function(_0x21c828){try{jsonpatch[_0x03e4('0x22')](_0x21c828,_0x5a85f2,!![]);}catch(_0x90355e){return BPromise[_0x03e4('0x23')](_0x90355e);}return _0x21c828[_0x03e4('0x24')]();};}function saveUpdates(_0x18ecaa,_0x4ac38c){return function(_0x2dd6d7){if(_0x2dd6d7){return _0x2dd6d7[_0x03e4('0x25')](_0x18ecaa)['then'](function(_0x268ee8){return _0x268ee8;});}return null;};}function removeEntity(_0x1abdf7,_0x2e5cd3){return function(_0x4d0ef9){if(_0x4d0ef9){return _0x4d0ef9[_0x03e4('0x26')]()[_0x03e4('0x27')](function(){var _0x231f13=_0x4d0ef9[_0x03e4('0x28')]({'plain':!![]});var _0x1cfc95='IvrCampaigns';return db[_0x03e4('0x29')][_0x03e4('0x26')]({'where':{'type':_0x1cfc95,'resourceId':_0x231f13['id']}})[_0x03e4('0x27')](function(){return _0x4d0ef9;});})[_0x03e4('0x27')](function(){_0x1abdf7[_0x03e4('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5031b1,_0x1666a1){return function(_0x2b95f2){if(!_0x2b95f2){_0x5031b1['sendStatus'](0x194);}return _0x2b95f2;};}function handleError(_0x44cbfd,_0x26cf1d){_0x26cf1d=_0x26cf1d||0x1f4;return function(_0x20c2d0){logger['error'](_0x20c2d0[_0x03e4('0x2a')]);if(_0x20c2d0[_0x03e4('0x2b')]){delete _0x20c2d0[_0x03e4('0x2b')];}_0x44cbfd[_0x03e4('0x19')](_0x26cf1d)['send'](_0x20c2d0);};}exports[_0x03e4('0x2c')]=function(_0x84fe53,_0x2695d6){var _0x137e54={},_0x489982={},_0x4d5210={'count':0x0,'rows':[]};var _0x17c245=_[_0x03e4('0x2d')](db[_0x03e4('0x2e')][_0x03e4('0x2f')],function(_0x3ea009){return{'name':_0x3ea009[_0x03e4('0x30')],'type':_0x3ea009[_0x03e4('0x31')][_0x03e4('0x32')]};});_0x489982[_0x03e4('0x33')]=_[_0x03e4('0x2d')](_0x17c245,_0x03e4('0x2b'));_0x489982[_0x03e4('0x34')]=_[_0x03e4('0x35')](_0x84fe53[_0x03e4('0x34')]);_0x489982['filters']=_[_0x03e4('0x36')](_0x489982[_0x03e4('0x33')],_0x489982['query']);_0x137e54['attributes']=_[_0x03e4('0x36')](_0x489982['model'],qs[_0x03e4('0x37')](_0x84fe53[_0x03e4('0x34')][_0x03e4('0x37')]));_0x137e54[_0x03e4('0x38')]=_0x137e54['attributes'][_0x03e4('0x39')]?_0x137e54[_0x03e4('0x38')]:_0x489982[_0x03e4('0x33')];if(!_0x84fe53[_0x03e4('0x34')][_0x03e4('0x3a')](_0x03e4('0x3b'))){_0x137e54['limit']=qs[_0x03e4('0x1e')](_0x84fe53[_0x03e4('0x34')][_0x03e4('0x1e')]);_0x137e54[_0x03e4('0x1c')]=qs[_0x03e4('0x1c')](_0x84fe53[_0x03e4('0x34')][_0x03e4('0x1c')]);}_0x137e54[_0x03e4('0x3c')]=qs['sort'](_0x84fe53[_0x03e4('0x34')][_0x03e4('0x3d')]);_0x137e54[_0x03e4('0x3e')]=qs[_0x03e4('0x3f')](_['pick'](_0x84fe53['query'],_0x489982[_0x03e4('0x3f')]),_0x17c245);if(_0x84fe53[_0x03e4('0x34')]['filter']){_0x137e54['where']=_[_0x03e4('0x40')](_0x137e54[_0x03e4('0x3e')],{'$or':_[_0x03e4('0x2d')](_0x17c245,function(_0x4a5d31){if(_0x4a5d31[_0x03e4('0x31')]!==_0x03e4('0x41')){var _0xbd5442={};_0xbd5442[_0x4a5d31[_0x03e4('0x2b')]]={'$like':'%'+_0x84fe53[_0x03e4('0x34')][_0x03e4('0x42')]+'%'};return _0xbd5442;}})});}_0x137e54=_['merge']({},_0x137e54,_0x84fe53[_0x03e4('0x43')]);var _0x43bbb0={'where':_0x137e54[_0x03e4('0x3e')]};return db[_0x03e4('0x2e')][_0x03e4('0x1f')](_0x43bbb0)['then'](function(_0x5595ca){_0x4d5210[_0x03e4('0x1f')]=_0x5595ca;if(_0x84fe53[_0x03e4('0x34')][_0x03e4('0x44')]){_0x137e54[_0x03e4('0x45')]=[{'all':!![]}];}return db[_0x03e4('0x2e')]['findAll'](_0x137e54);})[_0x03e4('0x27')](function(_0xacdf3a){_0x4d5210[_0x03e4('0x46')]=_0xacdf3a;return _0x4d5210;})['then'](respondWithFilteredResult(_0x2695d6,_0x137e54))[_0x03e4('0x47')](handleError(_0x2695d6,null));};exports[_0x03e4('0x48')]=function(_0x17a69c,_0xec59a5){var _0x15037c={'raw':![],'where':{'id':_0x17a69c[_0x03e4('0x49')]['id']}},_0x2df559={};_0x2df559['model']=_[_0x03e4('0x35')](db['Campaign'][_0x03e4('0x2f')]);_0x2df559[_0x03e4('0x34')]=_[_0x03e4('0x35')](_0x17a69c['query']);_0x2df559['filters']=_['intersection'](_0x2df559[_0x03e4('0x33')],_0x2df559[_0x03e4('0x34')]);_0x15037c[_0x03e4('0x38')]=_['intersection'](_0x2df559[_0x03e4('0x33')],qs[_0x03e4('0x37')](_0x17a69c['query'][_0x03e4('0x37')]));_0x15037c[_0x03e4('0x38')]=_0x15037c['attributes'][_0x03e4('0x39')]?_0x15037c[_0x03e4('0x38')]:_0x2df559['model'];if(_0x17a69c[_0x03e4('0x34')][_0x03e4('0x44')]){_0x15037c[_0x03e4('0x45')]=[{'all':!![]}];}_0x15037c=_[_0x03e4('0x40')]({},_0x15037c,_0x17a69c['options']);return db[_0x03e4('0x2e')][_0x03e4('0x4a')](_0x15037c)[_0x03e4('0x27')](handleEntityNotFound(_0xec59a5,null))[_0x03e4('0x27')](respondWithResult(_0xec59a5,null))[_0x03e4('0x47')](handleError(_0xec59a5,null));};exports[_0x03e4('0x4b')]=function(_0x20c77a,_0x138b70){return db[_0x03e4('0x2e')]['create'](_0x20c77a[_0x03e4('0x4c')],{})['then'](function(_0x3c2596){var _0x45d49f=_0x20c77a[_0x03e4('0x4d')][_0x03e4('0x28')]({'plain':!![]});if(!_0x45d49f)throw new Error(_0x03e4('0x4e'));if(_0x45d49f['role']===_0x03e4('0x4d')){var _0x5bcded=_0x3c2596['get']({'plain':!![]});var _0x5cccbc=_0x03e4('0x4f');return db[_0x03e4('0x50')]['find']({'where':{'name':_0x5cccbc,'userProfileId':_0x45d49f['userProfileId']},'raw':!![]})[_0x03e4('0x27')](function(_0x141e35){if(_0x141e35&&_0x141e35[_0x03e4('0x51')]===0x0){return db['UserProfileResource']['create']({'name':_0x5bcded['name'],'resourceId':_0x5bcded['id'],'type':_0x141e35[_0x03e4('0x2b')],'sectionId':_0x141e35['id']},{})[_0x03e4('0x27')](function(){return _0x3c2596;});}else{return _0x3c2596;}})[_0x03e4('0x47')](function(_0x1264b9){logger[_0x03e4('0x52')](_0x03e4('0x53'),_0x1264b9);throw _0x1264b9;});}return _0x3c2596;})[_0x03e4('0x27')](respondWithResult(_0x138b70,0xc9))[_0x03e4('0x47')](handleError(_0x138b70,null));};exports['clone']=function(_0x70d74a,_0x154335){var _0x3cc8ae={'where':{'id':_0x70d74a[_0x03e4('0x49')]['id']}},_0x5c3b33={};_0x5c3b33[_0x03e4('0x33')]=_[_0x03e4('0x35')](db[_0x03e4('0x2e')][_0x03e4('0x2f')]);_0x3cc8ae[_0x03e4('0x38')]=_[_0x03e4('0x36')](_0x5c3b33[_0x03e4('0x33')],qs[_0x03e4('0x37')](_0x70d74a[_0x03e4('0x34')][_0x03e4('0x37')]));_0x3cc8ae[_0x03e4('0x38')]=_0x3cc8ae[_0x03e4('0x38')][_0x03e4('0x39')]?_0x3cc8ae[_0x03e4('0x38')]:_0x5c3b33['model'];if(_0x70d74a[_0x03e4('0x34')][_0x03e4('0x44')]){_0x3cc8ae[_0x03e4('0x45')]=[{'all':!![]}];}_0x3cc8ae=_[_0x03e4('0x40')]({},_0x3cc8ae,_0x70d74a[_0x03e4('0x43')]);return db[_0x03e4('0x2e')][_0x03e4('0x4a')](_0x3cc8ae)[_0x03e4('0x27')](handleEntityNotFound(_0x154335,null))[_0x03e4('0x27')](function(_0x168ee1){if(_0x168ee1){var _0x3b3e10=_0x168ee1[_0x03e4('0x28')]({'plain':!![]});_0x3b3e10=qs[_0x03e4('0x54')](_0x3b3e10,['id',_0x03e4('0x55'),'updatedAt']);_0x70d74a[_0x03e4('0x4c')]=_[_0x03e4('0x54')](_0x70d74a[_0x03e4('0x4c')],['id',_0x03e4('0x55'),_0x03e4('0x56')]);return db['Campaign'][_0x03e4('0x4b')](_[_0x03e4('0x40')](_0x3b3e10,_0x70d74a[_0x03e4('0x4c')]),{'include':_0x70d74a[_0x03e4('0x34')][_0x03e4('0x44')]?[{'all':!![]}]:undefined})['then'](function(_0x3b5997){var _0x3f6e23=_0x70d74a[_0x03e4('0x4d')][_0x03e4('0x28')]({'plain':!![]});if(!_0x3f6e23)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3f6e23[_0x03e4('0x57')]===_0x03e4('0x4d')){var _0xcdd070=_0x3b5997[_0x03e4('0x28')]({'plain':!![]});var _0x5a7050='IvrCampaigns';return db[_0x03e4('0x50')]['find']({'where':{'name':_0x5a7050,'userProfileId':_0x3f6e23[_0x03e4('0x58')]},'raw':!![]})['then'](function(_0x445435){if(_0x445435&&_0x445435[_0x03e4('0x51')]===0x0){return db[_0x03e4('0x29')][_0x03e4('0x4b')]({'name':_0xcdd070[_0x03e4('0x2b')],'resourceId':_0xcdd070['id'],'type':_0x445435['name'],'sectionId':_0x445435['id']},{})['then'](function(){return _0x3b5997;});}else{return _0x3b5997;}})[_0x03e4('0x47')](function(_0x41b5f0){logger[_0x03e4('0x52')](_0x03e4('0x53'),_0x41b5f0);throw _0x41b5f0;});}return _0x3b5997;});}})['then'](respondWithResult(_0x154335,0xc9))[_0x03e4('0x47')](handleError(_0x154335,null));};exports['update']=function(_0x2911c7,_0x524923){if(_0x2911c7[_0x03e4('0x4c')]['id']){delete _0x2911c7[_0x03e4('0x4c')]['id'];}return db[_0x03e4('0x2e')][_0x03e4('0x4a')]({'where':{'id':_0x2911c7[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0x524923,null))[_0x03e4('0x27')](saveUpdates(_0x2911c7[_0x03e4('0x4c')],null))[_0x03e4('0x27')](respondWithResult(_0x524923,null))['catch'](handleError(_0x524923,null));};exports['destroy']=function(_0x46a25c,_0x32a04e){return db[_0x03e4('0x2e')][_0x03e4('0x4a')]({'where':{'id':_0x46a25c[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0x32a04e,null))[_0x03e4('0x27')](removeEntity(_0x32a04e,null))['catch'](handleError(_0x32a04e,null));};exports['getHoppers']=function(_0x41b6df,_0x573857,_0x129768){var _0x264d81={'raw':!![],'where':{}};var _0x4b1150={};var _0x31ca39={'count':0x0,'rows':[]};return db[_0x03e4('0x2e')][_0x03e4('0x59')]({'where':{'id':_0x41b6df[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0x573857,null))[_0x03e4('0x27')](function(_0x2d9f06){if(_0x2d9f06){_0x4b1150[_0x03e4('0x33')]=_[_0x03e4('0x35')](db[_0x03e4('0x5a')]['rawAttributes']);_0x4b1150['query']=_[_0x03e4('0x35')](_0x41b6df['query']);_0x4b1150['filters']=_[_0x03e4('0x36')](_0x4b1150[_0x03e4('0x33')],_0x4b1150[_0x03e4('0x34')]);_0x264d81[_0x03e4('0x38')]=_[_0x03e4('0x36')](_0x4b1150[_0x03e4('0x33')],qs[_0x03e4('0x37')](_0x41b6df[_0x03e4('0x34')]['fields']));_0x264d81[_0x03e4('0x38')]=_0x264d81[_0x03e4('0x38')][_0x03e4('0x39')]?_0x264d81[_0x03e4('0x38')]:_0x4b1150[_0x03e4('0x33')];if(!_0x41b6df[_0x03e4('0x34')][_0x03e4('0x3a')](_0x03e4('0x3b'))){_0x264d81[_0x03e4('0x1e')]=qs['limit'](_0x41b6df['query'][_0x03e4('0x1e')]);_0x264d81[_0x03e4('0x1c')]=qs[_0x03e4('0x1c')](_0x41b6df[_0x03e4('0x34')][_0x03e4('0x1c')]);}_0x264d81[_0x03e4('0x3c')]=qs[_0x03e4('0x3d')](_0x41b6df['query'][_0x03e4('0x3d')]);_0x264d81[_0x03e4('0x3e')]=qs[_0x03e4('0x3f')](_['pick'](_0x41b6df['query'],_0x4b1150['filters']));_0x264d81[_0x03e4('0x3e')][_0x03e4('0x5b')]=_0x2d9f06['id'];if(_0x41b6df[_0x03e4('0x34')][_0x03e4('0x42')]){_0x264d81['where']=_['merge'](_0x264d81[_0x03e4('0x3e')],{'$or':_[_0x03e4('0x2d')](_0x264d81['attributes'],function(_0x3d3874){var _0x4c04a1={};_0x4c04a1[_0x3d3874]={'$like':'%'+_0x41b6df[_0x03e4('0x34')][_0x03e4('0x42')]+'%'};return _0x4c04a1;})});}_0x264d81=_[_0x03e4('0x40')]({},_0x264d81,_0x41b6df['options']);return db[_0x03e4('0x5a')][_0x03e4('0x1f')]({'where':_0x264d81[_0x03e4('0x3e')]})[_0x03e4('0x27')](function(_0x49c969){_0x31ca39['count']=_0x49c969;if(_0x41b6df[_0x03e4('0x34')][_0x03e4('0x44')]){_0x264d81['include']=[{'all':!![]}];}return db[_0x03e4('0x5a')]['findAll'](_0x264d81);})[_0x03e4('0x27')](function(_0x376bae){_0x31ca39['rows']=_0x376bae;return _0x31ca39;});}})['then'](respondWithFilteredResult(_0x573857,_0x264d81))[_0x03e4('0x47')](handleError(_0x573857,null));};exports[_0x03e4('0x5c')]=function(_0x17e165,_0x57cf9a,_0x1dc34b){var _0x1907e3={'raw':!![],'where':{}};var _0x37a860={};var _0xa4b21d={'count':0x0,'rows':[]};return db[_0x03e4('0x2e')][_0x03e4('0x59')]({'where':{'id':_0x17e165[_0x03e4('0x49')]['id']}})['then'](handleEntityNotFound(_0x57cf9a,null))['then'](function(_0x5b24e2){if(_0x5b24e2){_0x37a860[_0x03e4('0x33')]=_[_0x03e4('0x35')](db[_0x03e4('0x5d')][_0x03e4('0x2f')]);_0x37a860['query']=_[_0x03e4('0x35')](_0x17e165['query']);_0x37a860[_0x03e4('0x3f')]=_[_0x03e4('0x36')](_0x37a860[_0x03e4('0x33')],_0x37a860[_0x03e4('0x34')]);_0x1907e3[_0x03e4('0x38')]=_[_0x03e4('0x36')](_0x37a860[_0x03e4('0x33')],qs[_0x03e4('0x37')](_0x17e165['query'][_0x03e4('0x37')]));_0x1907e3['attributes']=_0x1907e3[_0x03e4('0x38')][_0x03e4('0x39')]?_0x1907e3[_0x03e4('0x38')]:_0x37a860['model'];if(!_0x17e165[_0x03e4('0x34')][_0x03e4('0x3a')]('nolimit')){_0x1907e3['limit']=qs['limit'](_0x17e165['query'][_0x03e4('0x1e')]);_0x1907e3[_0x03e4('0x1c')]=qs[_0x03e4('0x1c')](_0x17e165[_0x03e4('0x34')][_0x03e4('0x1c')]);}_0x1907e3[_0x03e4('0x3c')]=qs[_0x03e4('0x3d')](_0x17e165[_0x03e4('0x34')][_0x03e4('0x3d')]);_0x1907e3[_0x03e4('0x3e')]=qs[_0x03e4('0x3f')](_[_0x03e4('0x5e')](_0x17e165[_0x03e4('0x34')],_0x37a860[_0x03e4('0x3f')]));_0x1907e3['where'][_0x03e4('0x5b')]=_0x5b24e2['id'];if(_0x17e165[_0x03e4('0x34')][_0x03e4('0x42')]){_0x1907e3[_0x03e4('0x3e')]=_[_0x03e4('0x40')](_0x1907e3[_0x03e4('0x3e')],{'$or':_[_0x03e4('0x2d')](_0x1907e3[_0x03e4('0x38')],function(_0x432836){var _0x50ce7e={};_0x50ce7e[_0x432836]={'$like':'%'+_0x17e165['query'][_0x03e4('0x42')]+'%'};return _0x50ce7e;})});}_0x1907e3=_[_0x03e4('0x40')]({},_0x1907e3,_0x17e165['options']);return db['CmHopperHistory'][_0x03e4('0x1f')]({'where':_0x1907e3[_0x03e4('0x3e')]})[_0x03e4('0x27')](function(_0x217d31){_0xa4b21d[_0x03e4('0x1f')]=_0x217d31;if(_0x17e165[_0x03e4('0x34')]['includeAll']){_0x1907e3[_0x03e4('0x45')]=[{'all':!![]}];}return db[_0x03e4('0x5d')]['findAll'](_0x1907e3);})[_0x03e4('0x27')](function(_0x59e7ea){_0xa4b21d[_0x03e4('0x46')]=_0x59e7ea;return _0xa4b21d;});}})[_0x03e4('0x27')](respondWithFilteredResult(_0x57cf9a,_0x1907e3))[_0x03e4('0x47')](handleError(_0x57cf9a,null));};exports[_0x03e4('0x5f')]=function(_0x25e0c9,_0x5e60c9,_0x2b05bd){var _0x5c7583={'raw':!![],'where':{}};var _0x53f40a={};var _0x2b60af={'count':0x0,'rows':[]};return db['Campaign'][_0x03e4('0x59')]({'where':{'id':_0x25e0c9['params']['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0x5e60c9,null))['then'](function(_0x17a050){if(_0x17a050){_0x53f40a[_0x03e4('0x33')]=_[_0x03e4('0x35')](db[_0x03e4('0x60')][_0x03e4('0x2f')]);_0x53f40a[_0x03e4('0x34')]=_[_0x03e4('0x35')](_0x25e0c9[_0x03e4('0x34')]);_0x53f40a[_0x03e4('0x3f')]=_[_0x03e4('0x36')](_0x53f40a['model'],_0x53f40a[_0x03e4('0x34')]);_0x5c7583['attributes']=_[_0x03e4('0x36')](_0x53f40a[_0x03e4('0x33')],qs[_0x03e4('0x37')](_0x25e0c9['query']['fields']));_0x5c7583[_0x03e4('0x38')]=_0x5c7583[_0x03e4('0x38')][_0x03e4('0x39')]?_0x5c7583[_0x03e4('0x38')]:_0x53f40a[_0x03e4('0x33')];if(!_0x25e0c9['query'][_0x03e4('0x3a')]('nolimit')){_0x5c7583[_0x03e4('0x1e')]=qs[_0x03e4('0x1e')](_0x25e0c9[_0x03e4('0x34')][_0x03e4('0x1e')]);_0x5c7583[_0x03e4('0x1c')]=qs['offset'](_0x25e0c9[_0x03e4('0x34')]['offset']);}_0x5c7583['order']=qs[_0x03e4('0x3d')](_0x25e0c9['query']['sort']);_0x5c7583[_0x03e4('0x3e')]=qs[_0x03e4('0x3f')](_[_0x03e4('0x5e')](_0x25e0c9[_0x03e4('0x34')],_0x53f40a[_0x03e4('0x3f')]));_0x5c7583['where'][_0x03e4('0x5b')]=_0x17a050['id'];if(_0x25e0c9[_0x03e4('0x34')][_0x03e4('0x42')]){_0x5c7583[_0x03e4('0x3e')]=_[_0x03e4('0x40')](_0x5c7583[_0x03e4('0x3e')],{'$or':_[_0x03e4('0x2d')](_0x5c7583[_0x03e4('0x38')],function(_0x3cf49a){var _0x14cf5b={};_0x14cf5b[_0x3cf49a]={'$like':'%'+_0x25e0c9[_0x03e4('0x34')][_0x03e4('0x42')]+'%'};return _0x14cf5b;})});}_0x5c7583=_[_0x03e4('0x40')]({},_0x5c7583,_0x25e0c9['options']);return db['CmHopperFinal'][_0x03e4('0x1f')]({'where':_0x5c7583[_0x03e4('0x3e')]})[_0x03e4('0x27')](function(_0x48de35){_0x2b60af[_0x03e4('0x1f')]=_0x48de35;if(_0x25e0c9[_0x03e4('0x34')][_0x03e4('0x44')]){_0x5c7583['include']=[{'all':!![]}];}return db[_0x03e4('0x60')]['findAll'](_0x5c7583);})[_0x03e4('0x27')](function(_0x2d7882){_0x2b60af[_0x03e4('0x46')]=_0x2d7882;return _0x2b60af;});}})['then'](respondWithFilteredResult(_0x5e60c9,_0x5c7583))[_0x03e4('0x47')](handleError(_0x5e60c9,null));};exports[_0x03e4('0x61')]=function(_0x328061,_0xa279f4,_0x3e07a2){var _0xf7f0ce={'raw':!![],'where':{}};var _0xa69e0c={};var _0x4c1f47={'count':0x0,'rows':[]};return db[_0x03e4('0x2e')][_0x03e4('0x59')]({'where':{'id':_0x328061[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0xa279f4,null))['then'](function(_0x51860e){if(_0x51860e){_0xa69e0c[_0x03e4('0x33')]=_[_0x03e4('0x35')](db[_0x03e4('0x62')]['rawAttributes']);_0xa69e0c['query']=_[_0x03e4('0x35')](_0x328061[_0x03e4('0x34')]);_0xa69e0c['filters']=_[_0x03e4('0x36')](_0xa69e0c[_0x03e4('0x33')],_0xa69e0c[_0x03e4('0x34')]);_0xf7f0ce[_0x03e4('0x38')]=_['intersection'](_0xa69e0c[_0x03e4('0x33')],qs[_0x03e4('0x37')](_0x328061['query']['fields']));_0xf7f0ce[_0x03e4('0x38')]=_0xf7f0ce[_0x03e4('0x38')][_0x03e4('0x39')]?_0xf7f0ce[_0x03e4('0x38')]:_0xa69e0c['model'];if(!_0x328061[_0x03e4('0x34')]['hasOwnProperty'](_0x03e4('0x3b'))){_0xf7f0ce[_0x03e4('0x1e')]=qs[_0x03e4('0x1e')](_0x328061[_0x03e4('0x34')][_0x03e4('0x1e')]);_0xf7f0ce[_0x03e4('0x1c')]=qs[_0x03e4('0x1c')](_0x328061[_0x03e4('0x34')]['offset']);}_0xf7f0ce[_0x03e4('0x3c')]=qs[_0x03e4('0x3d')](_0x328061['query'][_0x03e4('0x3d')]);_0xf7f0ce['where']=qs[_0x03e4('0x3f')](_[_0x03e4('0x5e')](_0x328061['query'],_0xa69e0c[_0x03e4('0x3f')]));_0xf7f0ce['where'][_0x03e4('0x5b')]=_0x51860e['id'];if(_0x328061[_0x03e4('0x34')]['filter']){_0xf7f0ce['where']=_[_0x03e4('0x40')](_0xf7f0ce[_0x03e4('0x3e')],{'$or':_[_0x03e4('0x2d')](_0xf7f0ce[_0x03e4('0x38')],function(_0x27a04c){var _0x361434={};_0x361434[_0x27a04c]={'$like':'%'+_0x328061['query'][_0x03e4('0x42')]+'%'};return _0x361434;})});}_0xf7f0ce=_[_0x03e4('0x40')]({},_0xf7f0ce,_0x328061[_0x03e4('0x43')]);return db[_0x03e4('0x62')][_0x03e4('0x1f')]({'where':_0xf7f0ce[_0x03e4('0x3e')]})[_0x03e4('0x27')](function(_0x5d39d4){_0x4c1f47[_0x03e4('0x1f')]=_0x5d39d4;if(_0x328061[_0x03e4('0x34')]['includeAll']){_0xf7f0ce['include']=[{'all':!![]}];}return db[_0x03e4('0x62')][_0x03e4('0x63')](_0xf7f0ce);})[_0x03e4('0x27')](function(_0x336520){_0x4c1f47[_0x03e4('0x46')]=_0x336520;return _0x4c1f47;});}})[_0x03e4('0x27')](respondWithFilteredResult(_0xa279f4,_0xf7f0ce))[_0x03e4('0x47')](handleError(_0xa279f4,null));};exports[_0x03e4('0x64')]=function(_0x3b8945,_0x3a7736,_0x453b33){var _0x13aa54={};var _0x205492={};var _0x284c2a;var _0x27316d;return db[_0x03e4('0x2e')][_0x03e4('0x59')]({'where':{'id':_0x3b8945[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0x3a7736,null))[_0x03e4('0x27')](function(_0x425701){if(_0x425701){_0x284c2a=_0x425701;_0x205492[_0x03e4('0x33')]=_[_0x03e4('0x35')](db[_0x03e4('0x65')][_0x03e4('0x2f')]);_0x205492[_0x03e4('0x34')]=_[_0x03e4('0x35')](_0x3b8945[_0x03e4('0x34')]);_0x205492[_0x03e4('0x3f')]=_['intersection'](_0x205492['model'],_0x205492[_0x03e4('0x34')]);_0x13aa54['attributes']=_[_0x03e4('0x36')](_0x205492[_0x03e4('0x33')],qs[_0x03e4('0x37')](_0x3b8945['query']['fields']));_0x13aa54[_0x03e4('0x38')]=_0x13aa54[_0x03e4('0x38')]['length']?_0x13aa54['attributes']:_0x205492[_0x03e4('0x33')];_0x13aa54[_0x03e4('0x3c')]=qs['sort'](_0x3b8945[_0x03e4('0x34')][_0x03e4('0x3d')]);_0x13aa54[_0x03e4('0x3e')]=qs['filters'](_['pick'](_0x3b8945['query'],_0x205492[_0x03e4('0x3f')]));if(_0x3b8945[_0x03e4('0x34')][_0x03e4('0x42')]){_0x13aa54['where']=_[_0x03e4('0x40')](_0x13aa54['where'],{'$or':_[_0x03e4('0x2d')](_0x13aa54[_0x03e4('0x38')],function(_0x79a864){var _0x4444fe={};_0x4444fe[_0x79a864]={'$like':'%'+_0x3b8945[_0x03e4('0x34')][_0x03e4('0x42')]+'%'};return _0x4444fe;})});}_0x13aa54=_[_0x03e4('0x40')]({},_0x13aa54,_0x3b8945[_0x03e4('0x43')]);return _0x284c2a[_0x03e4('0x64')](_0x13aa54);}})['then'](function(_0x141014){if(_0x141014){_0x27316d=_0x141014[_0x03e4('0x39')];if(!_0x3b8945[_0x03e4('0x34')]['hasOwnProperty'](_0x03e4('0x3b'))){_0x13aa54[_0x03e4('0x1e')]=qs[_0x03e4('0x1e')](_0x3b8945[_0x03e4('0x34')][_0x03e4('0x1e')]);_0x13aa54[_0x03e4('0x1c')]=qs['offset'](_0x3b8945[_0x03e4('0x34')][_0x03e4('0x1c')]);}return _0x284c2a[_0x03e4('0x64')](_0x13aa54);}})['then'](function(_0x4ebc6a){if(_0x4ebc6a){return _0x4ebc6a?{'count':_0x27316d,'rows':_0x4ebc6a}:null;}})[_0x03e4('0x27')](respondWithResult(_0x3a7736,null))[_0x03e4('0x47')](handleError(_0x3a7736,null));};exports[_0x03e4('0x66')]=function(_0x537596,_0x36a380,_0x3dbebe){var _0x68b374,_0x4fd128;var _0x111efb=[];var _0x1d8d44=moment()[_0x03e4('0x67')](_0x03e4('0x68'));return db['Campaign'][_0x03e4('0x4a')]({'where':{'id':_0x537596[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0x36a380,null))[_0x03e4('0x27')](function(_0x369011){if(_0x369011){_0x4fd128=_0x369011;return _0x369011[_0x03e4('0x66')](_0x537596['body'][_0x03e4('0x69')],_[_0x03e4('0x54')](_0x537596['body'],[_0x03e4('0x69'),'id'])||{});}return null;})[_0x03e4('0x6a')](function(_0x56c5cd){var _0x39faba;var _0x1728a2;_0x68b374=_0x56c5cd||[];var _0x31b148=[];if(_0x56c5cd){for(var _0x5c1dbd=0x0;_0x5c1dbd<_0x56c5cd['length'];_0x5c1dbd+=0x1){var _0x5d95c6=_0x56c5cd[_0x5c1dbd][_0x03e4('0x28')]({'plain':!![]});_0x4fd128[_0x03e4('0x6b')]=_0x537596[_0x03e4('0x4c')][_0x03e4('0x6b')]?_0x537596[_0x03e4('0x4c')][_0x03e4('0x6b')]:_0x4fd128[_0x03e4('0x6b')];switch(_0x4fd128[_0x03e4('0x6b')]){case _0x03e4('0x6c'):_0x39faba=squel[_0x03e4('0x6d')]()[_0x03e4('0x6e')](_0x03e4('0x6f'))['fromQuery'](['phone',_0x03e4('0x70'),_0x03e4('0x71'),_0x03e4('0x72'),_0x03e4('0x5b'),_0x03e4('0x55'),_0x03e4('0x56')],squel['select']()[_0x03e4('0x73')](_0x03e4('0x74'),_0x03e4('0x74'))[_0x03e4('0x73')](_0x03e4('0x75'),_0x03e4('0x70'))[_0x03e4('0x73')]('id',_0x03e4('0x71'))['field'](_0x5d95c6[_0x03e4('0x76')]['toString'](),_0x03e4('0x72'))[_0x03e4('0x73')](_0x537596[_0x03e4('0x49')]['id']['toString'](),'CampaignId')[_0x03e4('0x73')]('\x27'+_0x1d8d44+'\x27',_0x03e4('0x55'))[_0x03e4('0x73')]('\x27'+_0x1d8d44+'\x27','updatedAt')[_0x03e4('0x77')](_0x03e4('0x78'))[_0x03e4('0x3e')](_0x03e4('0x79'))[_0x03e4('0x3e')](_0x03e4('0x7a'),_0x5d95c6[_0x03e4('0x76')][_0x03e4('0x7b')]())[_0x03e4('0x3e')](_0x03e4('0x7c'))[_0x03e4('0x3e')](_0x03e4('0x7d'),squel[_0x03e4('0x7e')]()['field']('COALESCE(calleridnum,\x27\x27)')['from'](_0x03e4('0x7f'))[_0x03e4('0x3e')](_0x03e4('0x80'),_0x537596['params']['id'][_0x03e4('0x7b')]()))[_0x03e4('0x3e')](_0x03e4('0x7d'),squel[_0x03e4('0x7e')]()[_0x03e4('0x73')](_0x03e4('0x81'))[_0x03e4('0x77')](_0x03e4('0x6f'))[_0x03e4('0x3e')](_0x03e4('0x80'),_0x537596[_0x03e4('0x49')]['id'][_0x03e4('0x7b')]())))[_0x03e4('0x7b')]();break;case _0x03e4('0x82'):_0x39faba=squel[_0x03e4('0x6d')]()[_0x03e4('0x6e')]('cm_hopper')[_0x03e4('0x83')]([_0x03e4('0x74'),_0x03e4('0x70'),_0x03e4('0x71'),_0x03e4('0x72'),_0x03e4('0x5b'),_0x03e4('0x55'),_0x03e4('0x56')],squel[_0x03e4('0x7e')]()[_0x03e4('0x73')](_0x03e4('0x74'),_0x03e4('0x74'))[_0x03e4('0x73')](_0x03e4('0x75'),_0x03e4('0x70'))[_0x03e4('0x73')]('id',_0x03e4('0x71'))[_0x03e4('0x73')](_0x5d95c6[_0x03e4('0x76')][_0x03e4('0x7b')](),_0x03e4('0x72'))[_0x03e4('0x73')](_0x537596[_0x03e4('0x49')]['id']['toString'](),_0x03e4('0x5b'))[_0x03e4('0x73')]('\x27'+_0x1d8d44+'\x27',_0x03e4('0x55'))[_0x03e4('0x73')]('\x27'+_0x1d8d44+'\x27',_0x03e4('0x56'))[_0x03e4('0x77')](_0x03e4('0x78'))['where'](_0x03e4('0x79'))['where'](_0x03e4('0x7a'),_0x5d95c6[_0x03e4('0x76')][_0x03e4('0x7b')]())[_0x03e4('0x3e')](_0x03e4('0x7c'))[_0x03e4('0x3e')](_0x03e4('0x7d'),squel[_0x03e4('0x7e')]()[_0x03e4('0x73')]('COALESCE(phone,\x27\x27)')[_0x03e4('0x77')]('cm_hopper')[_0x03e4('0x3e')](_0x03e4('0x80'),_0x537596[_0x03e4('0x49')]['id']['toString']())))[_0x03e4('0x7b')]();break;default:_0x39faba=squel[_0x03e4('0x6d')]()[_0x03e4('0x6e')](_0x03e4('0x6f'))[_0x03e4('0x83')](['phone','scheduledAt',_0x03e4('0x71'),_0x03e4('0x72'),_0x03e4('0x5b'),'createdAt',_0x03e4('0x56')],squel['select']()[_0x03e4('0x73')](_0x03e4('0x74'),_0x03e4('0x74'))['field'](_0x03e4('0x75'),'scheduledAt')[_0x03e4('0x73')]('id',_0x03e4('0x71'))[_0x03e4('0x73')](_0x5d95c6[_0x03e4('0x76')][_0x03e4('0x7b')](),_0x03e4('0x72'))['field'](_0x537596['params']['id'][_0x03e4('0x7b')](),_0x03e4('0x5b'))['field']('\x27'+_0x1d8d44+'\x27',_0x03e4('0x55'))['field']('\x27'+_0x1d8d44+'\x27',_0x03e4('0x56'))[_0x03e4('0x77')]('cm_contacts')['where'](_0x03e4('0x79'))[_0x03e4('0x3e')](_0x03e4('0x7a'),_0x5d95c6[_0x03e4('0x76')][_0x03e4('0x7b')]())[_0x03e4('0x3e')](_0x03e4('0x7c')))['toString']();}_0x1728a2=squel['insert']()[_0x03e4('0x6e')](_0x03e4('0x84'))['fromQuery'](['cmHopperId',_0x03e4('0x70'),'phone',_0x03e4('0x85'),_0x03e4('0x55'),_0x03e4('0x56')],squel[_0x03e4('0x7e')]()[_0x03e4('0x73')](_0x03e4('0x86'),'id')[_0x03e4('0x73')](_0x03e4('0x75'),'scheduledAt')[_0x03e4('0x73')](_0x03e4('0x87'),_0x03e4('0x74'))[_0x03e4('0x73')](_0x03e4('0x88'),_0x03e4('0x85'))[_0x03e4('0x73')]('\x27'+_0x1d8d44+'\x27','createdAt')[_0x03e4('0x73')]('\x27'+_0x1d8d44+'\x27',_0x03e4('0x56'))[_0x03e4('0x77')](_0x03e4('0x89'),'ci')[_0x03e4('0x8a')](_0x03e4('0x6f'),'h',_0x03e4('0x8b'))[_0x03e4('0x3e')](_0x03e4('0x8c'),_0x5d95c6['CmListId'][_0x03e4('0x7b')]())[_0x03e4('0x3e')](_0x03e4('0x8d'),_0x537596[_0x03e4('0x49')]['id'][_0x03e4('0x7b')]())[_0x03e4('0x3e')](_0x03e4('0x8e'),_0x1d8d44))[_0x03e4('0x7b')]();_0x31b148['push'](db[_0x03e4('0x8f')][_0x03e4('0x34')](_0x39faba));_0x111efb[_0x03e4('0x90')](db[_0x03e4('0x8f')]['query'](_0x1728a2));}return BPromise['all'](_0x31b148);}})[_0x03e4('0x27')](function(){return BPromise[_0x03e4('0x91')](_0x111efb);})['then'](function(){return _0x68b374;})[_0x03e4('0x27')](respondWithResult(_0x36a380,null))[_0x03e4('0x47')](handleError(_0x36a380,null));};exports['removeLists']=function(_0x16e799,_0x259a72,_0x2b12c1){return db[_0x03e4('0x2e')][_0x03e4('0x4a')]({'where':{'id':_0x16e799[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0x259a72,null))[_0x03e4('0x27')](function(_0x18ea73){if(_0x18ea73){return _0x18ea73[_0x03e4('0x92')](_0x16e799[_0x03e4('0x34')][_0x03e4('0x69')]);}})['then'](function(_0x1bd386){if(_0x1bd386){return db[_0x03e4('0x5a')][_0x03e4('0x26')]({'where':{'ListId':_0x16e799[_0x03e4('0x34')]['ids'],'CampaignId':_0x16e799[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](function(){return _0x1bd386;});}})[_0x03e4('0x27')](respondWithStatusCode(_0x259a72,null))[_0x03e4('0x47')](handleError(_0x259a72,null));};exports[_0x03e4('0x93')]=function(_0xe6b747,_0xa6eef4,_0x4d8899){var _0x592999={};var _0x1a89d6={};var _0x137d3a;var _0x55ea76;return db[_0x03e4('0x2e')][_0x03e4('0x59')]({'where':{'id':_0xe6b747[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0xa6eef4,null))[_0x03e4('0x27')](function(_0x2de76b){if(_0x2de76b){_0x137d3a=_0x2de76b;_0x1a89d6[_0x03e4('0x33')]=_['keys'](db[_0x03e4('0x65')][_0x03e4('0x2f')]);_0x1a89d6[_0x03e4('0x34')]=_[_0x03e4('0x35')](_0xe6b747[_0x03e4('0x34')]);_0x1a89d6[_0x03e4('0x3f')]=_[_0x03e4('0x36')](_0x1a89d6[_0x03e4('0x33')],_0x1a89d6[_0x03e4('0x34')]);_0x592999[_0x03e4('0x38')]=_[_0x03e4('0x36')](_0x1a89d6[_0x03e4('0x33')],qs[_0x03e4('0x37')](_0xe6b747[_0x03e4('0x34')][_0x03e4('0x37')]));_0x592999[_0x03e4('0x38')]=_0x592999[_0x03e4('0x38')][_0x03e4('0x39')]?_0x592999[_0x03e4('0x38')]:_0x1a89d6[_0x03e4('0x33')];_0x592999[_0x03e4('0x3c')]=qs[_0x03e4('0x3d')](_0xe6b747[_0x03e4('0x34')][_0x03e4('0x3d')]);_0x592999[_0x03e4('0x3e')]=qs[_0x03e4('0x3f')](_[_0x03e4('0x5e')](_0xe6b747[_0x03e4('0x34')],_0x1a89d6[_0x03e4('0x3f')]));if(_0xe6b747[_0x03e4('0x34')][_0x03e4('0x42')]){_0x592999[_0x03e4('0x3e')]=_['merge'](_0x592999[_0x03e4('0x3e')],{'$or':_[_0x03e4('0x2d')](_0x592999['attributes'],function(_0x3320a6){var _0x4b8ca6={};_0x4b8ca6[_0x3320a6]={'$like':'%'+_0xe6b747[_0x03e4('0x34')][_0x03e4('0x42')]+'%'};return _0x4b8ca6;})});}_0x592999=_[_0x03e4('0x40')]({},_0x592999,_0xe6b747['options']);return _0x137d3a[_0x03e4('0x93')](_0x592999);}})[_0x03e4('0x27')](function(_0x4f8350){if(_0x4f8350){_0x55ea76=_0x4f8350[_0x03e4('0x39')];if(!_0xe6b747[_0x03e4('0x34')][_0x03e4('0x3a')](_0x03e4('0x3b'))){_0x592999[_0x03e4('0x1e')]=qs['limit'](_0xe6b747[_0x03e4('0x34')][_0x03e4('0x1e')]);_0x592999[_0x03e4('0x1c')]=qs[_0x03e4('0x1c')](_0xe6b747['query'][_0x03e4('0x1c')]);}return _0x137d3a[_0x03e4('0x93')](_0x592999);}})[_0x03e4('0x27')](function(_0x324ea0){if(_0x324ea0){return _0x324ea0?{'count':_0x55ea76,'rows':_0x324ea0}:null;}})[_0x03e4('0x27')](respondWithResult(_0xa6eef4,null))[_0x03e4('0x47')](handleError(_0xa6eef4,null));};exports[_0x03e4('0x94')]=function(_0x428992,_0x897f35,_0x24fff5){var _0x587dbf,_0x645fa2;var _0x4c978f=[];var _0x25b7f4=moment()[_0x03e4('0x67')](_0x03e4('0x68'));return db[_0x03e4('0x2e')][_0x03e4('0x4a')]({'where':{'id':_0x428992['params']['id']}})[_0x03e4('0x27')](handleEntityNotFound(_0x897f35,null))[_0x03e4('0x27')](function(_0x13d75a){if(_0x13d75a){_0x645fa2=_0x13d75a;return _0x13d75a[_0x03e4('0x94')](_0x428992[_0x03e4('0x4c')][_0x03e4('0x69')],_[_0x03e4('0x54')](_0x428992['body'],['ids','id'])||{});}return null;})[_0x03e4('0x6a')](function(_0x482341){var _0x133616;var _0x271c40;_0x587dbf=_0x482341||[];var _0x5186e0=[];if(_0x482341){for(var _0x53713d=0x0;_0x53713d<_0x482341['length'];_0x53713d+=0x1){var _0x5e619f=_0x482341[_0x53713d][_0x03e4('0x28')]({'plain':!![]});_0x133616=squel['insert']()['into'](_0x03e4('0x95'))[_0x03e4('0x83')]([_0x03e4('0x74'),_0x03e4('0x71'),'ListId',_0x03e4('0x5b'),'createdAt',_0x03e4('0x56')],squel[_0x03e4('0x7e')]()[_0x03e4('0x73')](_0x03e4('0x74'),'phone')[_0x03e4('0x73')]('id',_0x03e4('0x71'))[_0x03e4('0x73')](_0x5e619f[_0x03e4('0x76')][_0x03e4('0x7b')](),'ListId')['field'](_0x428992[_0x03e4('0x49')]['id'][_0x03e4('0x7b')](),'CampaignId')[_0x03e4('0x73')](_0x03e4('0x75'),'createdAt')[_0x03e4('0x73')](_0x03e4('0x75'),_0x03e4('0x56'))[_0x03e4('0x77')](_0x03e4('0x78'))[_0x03e4('0x3e')](_0x03e4('0x79'))['where'](_0x03e4('0x7a'),_0x5e619f['CmListId'][_0x03e4('0x7b')]())[_0x03e4('0x3e')]('phone\x20IS\x20NOT\x20NULL'))[_0x03e4('0x7b')]();_0x5186e0[_0x03e4('0x90')](db['sequelize'][_0x03e4('0x34')](_0x133616));}return BPromise[_0x03e4('0x91')](_0x5186e0);}})[_0x03e4('0x27')](function(){return _0x587dbf;})[_0x03e4('0x27')](respondWithResult(_0x897f35,null))[_0x03e4('0x47')](handleError(_0x897f35,null));};exports[_0x03e4('0x96')]=function(_0x4b5ddd,_0x2358ed,_0x2b94ec){return db[_0x03e4('0x2e')][_0x03e4('0x4a')]({'where':{'id':_0x4b5ddd[_0x03e4('0x49')]['id']}})['then'](handleEntityNotFound(_0x2358ed,null))['then'](function(_0x161a75){if(_0x161a75){return _0x161a75[_0x03e4('0x96')](_0x4b5ddd[_0x03e4('0x34')][_0x03e4('0x69')]);}})[_0x03e4('0x27')](function(_0x2d1ad9){if(_0x2d1ad9){return db[_0x03e4('0x62')][_0x03e4('0x26')]({'where':{'ListId':_0x4b5ddd[_0x03e4('0x34')][_0x03e4('0x69')],'CampaignId':_0x4b5ddd[_0x03e4('0x49')]['id']}})[_0x03e4('0x27')](function(){return _0x2d1ad9;});}})[_0x03e4('0x27')](respondWithStatusCode(_0x2358ed,null))[_0x03e4('0x47')](handleError(_0x2358ed,null));};
\ No newline at end of file
+var _0x0427=['insert','into','ContactId','NOW()','cm_contacts','CampaignId\x20=\x20?','cm_hopper_additional_phones','cmHopperId','ci.OrderBY','cm_contact_has_items','join','h.ContactId\x20=\x20ci.CmContactId','h.CampaignId=?','h.createdAt\x20=\x20?','push','sequelize','all','removeLists','getBlackLists','addBlackLists','spread','cm_hopper_black','removeBlackLists','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','count','offset','limit','set','reject','save','then','destroy','get','UserProfileResource','error','stack','name','send','map','Campaign','fieldName','type','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','catch','show','params','length','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','IvrCampaigns','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','rawAttributes','omit','createdAt','updatedAt','update','getHoppers','CmHopper','order','CampaignId','rows','getHopperHistories','findOne','CmHopperHistory','findAll','getHopperFinals','CmHopperFinal','getHopperBlacks','CmHopperBlack','CmList','getLists','addLists','format','YYYY-MM-DD\x20HH:mm:ss','ids','dialCheckDuplicateType','always','cm_hopper','fromQuery','ListId','select','field','phone','scheduledAt','toString','from','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','CmListId','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','COALESCE(calleridnum,\x27\x27)','COALESCE(phone,\x27\x27)'];(function(_0x34843e,_0x4c4224){var _0x598f7f=function(_0x12a44c){while(--_0x12a44c){_0x34843e['push'](_0x34843e['shift']());}};_0x598f7f(++_0x4c4224);}(_0x0427,0x137));var _0x7042=function(_0x3fb462,_0x5ae278){_0x3fb462=_0x3fb462-0x0;var _0x1b3ebb=_0x0427[_0x3fb462];return _0x1b3ebb;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x7042('0x0'));var jsonpatch=require(_0x7042('0x1'));var rp=require('request-promise');var moment=require(_0x7042('0x2'));var BPromise=require(_0x7042('0x3'));var Mustache=require(_0x7042('0x4'));var util=require(_0x7042('0x5'));var path=require(_0x7042('0x6'));var sox=require(_0x7042('0x7'));var csv=require(_0x7042('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x7042('0x9'));var _=require(_0x7042('0xa'));var squel=require(_0x7042('0xb'));var crypto=require(_0x7042('0xc'));var jsforce=require(_0x7042('0xd'));var deskjs=require(_0x7042('0xe'));var toCsv=require(_0x7042('0x8'));var querystring=require(_0x7042('0xf'));var Papa=require(_0x7042('0x10'));var Redis=require('ioredis');var authService=require(_0x7042('0x11'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x7042('0x12'));var utils=require('../../config/utils');var config=require(_0x7042('0x13'));var licenseUtil=require(_0x7042('0x14'));var db=require(_0x7042('0x15'))['db'];function respondWithStatusCode(_0x5629f2,_0x5c06f0){_0x5c06f0=_0x5c06f0||0xcc;return function(_0x292c4a){if(_0x292c4a){return _0x5629f2[_0x7042('0x16')](_0x5c06f0);}return _0x5629f2[_0x7042('0x17')](_0x5c06f0)[_0x7042('0x18')]();};}function respondWithResult(_0x25dfe5,_0xee4c2){_0xee4c2=_0xee4c2||0xc8;return function(_0x5def25){if(_0x5def25){return _0x25dfe5[_0x7042('0x17')](_0xee4c2)[_0x7042('0x19')](_0x5def25);}};}function respondWithFilteredResult(_0x6ed505,_0x5c1ef0){return function(_0x4c68c4){if(_0x4c68c4){var _0xc7e44e=typeof _0x5c1ef0['offset']===_0x7042('0x1a')&&typeof _0x5c1ef0['limit']==='undefined';var _0x28add7=_0x4c68c4[_0x7042('0x1b')];var _0x1e69aa=_0xc7e44e?0x0:_0x5c1ef0[_0x7042('0x1c')];var _0x6e18fb=_0xc7e44e?_0x4c68c4['count']:_0x5c1ef0[_0x7042('0x1c')]+_0x5c1ef0[_0x7042('0x1d')];var _0x34fda6;if(_0x6e18fb>=_0x28add7){_0x6e18fb=_0x28add7;_0x34fda6=0xc8;}else{_0x34fda6=0xce;}_0x6ed505[_0x7042('0x17')](_0x34fda6);return _0x6ed505[_0x7042('0x1e')]('Content-Range',_0x1e69aa+'-'+_0x6e18fb+'/'+_0x28add7)[_0x7042('0x19')](_0x4c68c4);}return null;};}function patchUpdates(_0x580f84){return function(_0x363f3c){try{jsonpatch['apply'](_0x363f3c,_0x580f84,!![]);}catch(_0x3b8203){return BPromise[_0x7042('0x1f')](_0x3b8203);}return _0x363f3c[_0x7042('0x20')]();};}function saveUpdates(_0x456dfc,_0x484c82){return function(_0x5a224b){if(_0x5a224b){return _0x5a224b['update'](_0x456dfc)[_0x7042('0x21')](function(_0x30a722){return _0x30a722;});}return null;};}function removeEntity(_0x3af8bc,_0x1949fe){return function(_0x48d529){if(_0x48d529){return _0x48d529[_0x7042('0x22')]()[_0x7042('0x21')](function(){var _0x4611f9=_0x48d529[_0x7042('0x23')]({'plain':!![]});var _0x459ff6='IvrCampaigns';return db[_0x7042('0x24')][_0x7042('0x22')]({'where':{'type':_0x459ff6,'resourceId':_0x4611f9['id']}})[_0x7042('0x21')](function(){return _0x48d529;});})[_0x7042('0x21')](function(){_0x3af8bc[_0x7042('0x17')](0xcc)[_0x7042('0x18')]();});}};}function handleEntityNotFound(_0x162ac7,_0x26543a){return function(_0x4568ec){if(!_0x4568ec){_0x162ac7[_0x7042('0x16')](0x194);}return _0x4568ec;};}function handleError(_0xa9ca06,_0x36fec4){_0x36fec4=_0x36fec4||0x1f4;return function(_0x88c156){logger[_0x7042('0x25')](_0x88c156[_0x7042('0x26')]);if(_0x88c156[_0x7042('0x27')]){delete _0x88c156[_0x7042('0x27')];}_0xa9ca06[_0x7042('0x17')](_0x36fec4)[_0x7042('0x28')](_0x88c156);};}exports['index']=function(_0x519e79,_0x37cf52){var _0x160af6={},_0x300be2={},_0x253a8b={'count':0x0,'rows':[]};var _0x2620c3=_[_0x7042('0x29')](db[_0x7042('0x2a')]['rawAttributes'],function(_0x4823c3){return{'name':_0x4823c3[_0x7042('0x2b')],'type':_0x4823c3[_0x7042('0x2c')]['key']};});_0x300be2[_0x7042('0x2d')]=_[_0x7042('0x29')](_0x2620c3,'name');_0x300be2[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x519e79[_0x7042('0x2e')]);_0x300be2[_0x7042('0x30')]=_[_0x7042('0x31')](_0x300be2['model'],_0x300be2[_0x7042('0x2e')]);_0x160af6['attributes']=_['intersection'](_0x300be2[_0x7042('0x2d')],qs['fields'](_0x519e79[_0x7042('0x2e')][_0x7042('0x32')]));_0x160af6['attributes']=_0x160af6[_0x7042('0x33')]['length']?_0x160af6[_0x7042('0x33')]:_0x300be2[_0x7042('0x2d')];if(!_0x519e79[_0x7042('0x2e')][_0x7042('0x34')](_0x7042('0x35'))){_0x160af6[_0x7042('0x1d')]=qs[_0x7042('0x1d')](_0x519e79[_0x7042('0x2e')][_0x7042('0x1d')]);_0x160af6['offset']=qs[_0x7042('0x1c')](_0x519e79[_0x7042('0x2e')][_0x7042('0x1c')]);}_0x160af6['order']=qs['sort'](_0x519e79[_0x7042('0x2e')][_0x7042('0x36')]);_0x160af6['where']=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x519e79[_0x7042('0x2e')],_0x300be2[_0x7042('0x30')]),_0x2620c3);if(_0x519e79[_0x7042('0x2e')][_0x7042('0x38')]){_0x160af6[_0x7042('0x39')]=_[_0x7042('0x3a')](_0x160af6[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x2620c3,function(_0x2b8669){if(_0x2b8669[_0x7042('0x2c')]!==_0x7042('0x3b')){var _0x53a424={};_0x53a424[_0x2b8669['name']]={'$like':'%'+_0x519e79[_0x7042('0x2e')][_0x7042('0x38')]+'%'};return _0x53a424;}})});}_0x160af6=_[_0x7042('0x3a')]({},_0x160af6,_0x519e79[_0x7042('0x3c')]);var _0x4b138b={'where':_0x160af6[_0x7042('0x39')]};return db[_0x7042('0x2a')]['count'](_0x4b138b)['then'](function(_0x1f8e68){_0x253a8b[_0x7042('0x1b')]=_0x1f8e68;if(_0x519e79[_0x7042('0x2e')][_0x7042('0x3d')]){_0x160af6[_0x7042('0x3e')]=[{'all':!![]}];}return db['Campaign']['findAll'](_0x160af6);})[_0x7042('0x21')](function(_0x3897fc){_0x253a8b['rows']=_0x3897fc;return _0x253a8b;})[_0x7042('0x21')](respondWithFilteredResult(_0x37cf52,_0x160af6))[_0x7042('0x3f')](handleError(_0x37cf52,null));};exports[_0x7042('0x40')]=function(_0x59568d,_0x5cffc0){var _0x9c4981={'raw':![],'where':{'id':_0x59568d[_0x7042('0x41')]['id']}},_0x44413e={};_0x44413e['model']=_[_0x7042('0x2f')](db[_0x7042('0x2a')]['rawAttributes']);_0x44413e[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x59568d[_0x7042('0x2e')]);_0x44413e[_0x7042('0x30')]=_[_0x7042('0x31')](_0x44413e[_0x7042('0x2d')],_0x44413e[_0x7042('0x2e')]);_0x9c4981['attributes']=_[_0x7042('0x31')](_0x44413e[_0x7042('0x2d')],qs['fields'](_0x59568d[_0x7042('0x2e')][_0x7042('0x32')]));_0x9c4981[_0x7042('0x33')]=_0x9c4981[_0x7042('0x33')][_0x7042('0x42')]?_0x9c4981[_0x7042('0x33')]:_0x44413e['model'];if(_0x59568d['query']['includeAll']){_0x9c4981[_0x7042('0x3e')]=[{'all':!![]}];}_0x9c4981=_['merge']({},_0x9c4981,_0x59568d['options']);return db[_0x7042('0x2a')]['find'](_0x9c4981)[_0x7042('0x21')](handleEntityNotFound(_0x5cffc0,null))[_0x7042('0x21')](respondWithResult(_0x5cffc0,null))[_0x7042('0x3f')](handleError(_0x5cffc0,null));};exports[_0x7042('0x43')]=function(_0x1a22d5,_0x11e7ce){return db[_0x7042('0x2a')][_0x7042('0x43')](_0x1a22d5[_0x7042('0x44')],{})[_0x7042('0x21')](function(_0x103d68){var _0x14d11a=_0x1a22d5[_0x7042('0x45')]['get']({'plain':!![]});if(!_0x14d11a)throw new Error(_0x7042('0x46'));if(_0x14d11a[_0x7042('0x47')]===_0x7042('0x45')){var _0x81b898=_0x103d68[_0x7042('0x23')]({'plain':!![]});var _0x288a11=_0x7042('0x48');return db[_0x7042('0x49')][_0x7042('0x4a')]({'where':{'name':_0x288a11,'userProfileId':_0x14d11a[_0x7042('0x4b')]},'raw':!![]})[_0x7042('0x21')](function(_0x445689){if(_0x445689&&_0x445689[_0x7042('0x4c')]===0x0){return db['UserProfileResource'][_0x7042('0x43')]({'name':_0x81b898['name'],'resourceId':_0x81b898['id'],'type':_0x445689[_0x7042('0x27')],'sectionId':_0x445689['id']},{})[_0x7042('0x21')](function(){return _0x103d68;});}else{return _0x103d68;}})[_0x7042('0x3f')](function(_0x5a0c85){logger['error'](_0x7042('0x4d'),_0x5a0c85);throw _0x5a0c85;});}return _0x103d68;})[_0x7042('0x21')](respondWithResult(_0x11e7ce,0xc9))[_0x7042('0x3f')](handleError(_0x11e7ce,null));};exports[_0x7042('0x4e')]=function(_0x58f2f2,_0x497188){var _0x280a41={'where':{'id':_0x58f2f2['params']['id']}},_0x3b4d27={};_0x3b4d27[_0x7042('0x2d')]=_[_0x7042('0x2f')](db['Campaign'][_0x7042('0x4f')]);_0x280a41[_0x7042('0x33')]=_['intersection'](_0x3b4d27[_0x7042('0x2d')],qs[_0x7042('0x32')](_0x58f2f2[_0x7042('0x2e')]['fields']));_0x280a41[_0x7042('0x33')]=_0x280a41[_0x7042('0x33')][_0x7042('0x42')]?_0x280a41[_0x7042('0x33')]:_0x3b4d27[_0x7042('0x2d')];if(_0x58f2f2[_0x7042('0x2e')][_0x7042('0x3d')]){_0x280a41[_0x7042('0x3e')]=[{'all':!![]}];}_0x280a41=_[_0x7042('0x3a')]({},_0x280a41,_0x58f2f2[_0x7042('0x3c')]);return db[_0x7042('0x2a')][_0x7042('0x4a')](_0x280a41)['then'](handleEntityNotFound(_0x497188,null))[_0x7042('0x21')](function(_0x318fd5){if(_0x318fd5){var _0x5d41f6=_0x318fd5[_0x7042('0x23')]({'plain':!![]});_0x5d41f6=qs[_0x7042('0x50')](_0x5d41f6,['id',_0x7042('0x51'),'updatedAt']);_0x58f2f2[_0x7042('0x44')]=_[_0x7042('0x50')](_0x58f2f2[_0x7042('0x44')],['id','createdAt',_0x7042('0x52')]);return db[_0x7042('0x2a')][_0x7042('0x43')](_[_0x7042('0x3a')](_0x5d41f6,_0x58f2f2[_0x7042('0x44')]),{'include':_0x58f2f2[_0x7042('0x2e')][_0x7042('0x3d')]?[{'all':!![]}]:undefined})[_0x7042('0x21')](function(_0x4bc8e9){var _0x2d7dbc=_0x58f2f2[_0x7042('0x45')][_0x7042('0x23')]({'plain':!![]});if(!_0x2d7dbc)throw new Error(_0x7042('0x46'));if(_0x2d7dbc[_0x7042('0x47')]===_0x7042('0x45')){var _0x253936=_0x4bc8e9['get']({'plain':!![]});var _0x1872c7='IvrCampaigns';return db[_0x7042('0x49')][_0x7042('0x4a')]({'where':{'name':_0x1872c7,'userProfileId':_0x2d7dbc[_0x7042('0x4b')]},'raw':!![]})[_0x7042('0x21')](function(_0x50f7c5){if(_0x50f7c5&&_0x50f7c5['autoAssociation']===0x0){return db[_0x7042('0x24')][_0x7042('0x43')]({'name':_0x253936['name'],'resourceId':_0x253936['id'],'type':_0x50f7c5[_0x7042('0x27')],'sectionId':_0x50f7c5['id']},{})[_0x7042('0x21')](function(){return _0x4bc8e9;});}else{return _0x4bc8e9;}})[_0x7042('0x3f')](function(_0x195f08){logger[_0x7042('0x25')](_0x7042('0x4d'),_0x195f08);throw _0x195f08;});}return _0x4bc8e9;});}})[_0x7042('0x21')](respondWithResult(_0x497188,0xc9))[_0x7042('0x3f')](handleError(_0x497188,null));};exports[_0x7042('0x53')]=function(_0x5c14ca,_0x2185f3){if(_0x5c14ca[_0x7042('0x44')]['id']){delete _0x5c14ca[_0x7042('0x44')]['id'];}return db[_0x7042('0x2a')]['find']({'where':{'id':_0x5c14ca[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x2185f3,null))[_0x7042('0x21')](saveUpdates(_0x5c14ca[_0x7042('0x44')],null))['then'](respondWithResult(_0x2185f3,null))['catch'](handleError(_0x2185f3,null));};exports[_0x7042('0x22')]=function(_0x5ba91e,_0xc51212){return db[_0x7042('0x2a')][_0x7042('0x4a')]({'where':{'id':_0x5ba91e['params']['id']}})['then'](handleEntityNotFound(_0xc51212,null))['then'](removeEntity(_0xc51212,null))[_0x7042('0x3f')](handleError(_0xc51212,null));};exports[_0x7042('0x54')]=function(_0x5158b6,_0x2256d3,_0x10d2d8){var _0x331b54={'raw':!![],'where':{}};var _0x4c70f4={};var _0x245201={'count':0x0,'rows':[]};return db[_0x7042('0x2a')]['findOne']({'where':{'id':_0x5158b6['params']['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x2256d3,null))['then'](function(_0x59bb93){if(_0x59bb93){_0x4c70f4[_0x7042('0x2d')]=_[_0x7042('0x2f')](db[_0x7042('0x55')][_0x7042('0x4f')]);_0x4c70f4[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x5158b6[_0x7042('0x2e')]);_0x4c70f4[_0x7042('0x30')]=_['intersection'](_0x4c70f4['model'],_0x4c70f4[_0x7042('0x2e')]);_0x331b54[_0x7042('0x33')]=_[_0x7042('0x31')](_0x4c70f4['model'],qs['fields'](_0x5158b6[_0x7042('0x2e')]['fields']));_0x331b54[_0x7042('0x33')]=_0x331b54[_0x7042('0x33')][_0x7042('0x42')]?_0x331b54['attributes']:_0x4c70f4[_0x7042('0x2d')];if(!_0x5158b6[_0x7042('0x2e')]['hasOwnProperty'](_0x7042('0x35'))){_0x331b54[_0x7042('0x1d')]=qs['limit'](_0x5158b6['query'][_0x7042('0x1d')]);_0x331b54[_0x7042('0x1c')]=qs['offset'](_0x5158b6[_0x7042('0x2e')][_0x7042('0x1c')]);}_0x331b54[_0x7042('0x56')]=qs[_0x7042('0x36')](_0x5158b6[_0x7042('0x2e')][_0x7042('0x36')]);_0x331b54[_0x7042('0x39')]=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x5158b6[_0x7042('0x2e')],_0x4c70f4['filters']));_0x331b54[_0x7042('0x39')][_0x7042('0x57')]=_0x59bb93['id'];if(_0x5158b6[_0x7042('0x2e')][_0x7042('0x38')]){_0x331b54['where']=_[_0x7042('0x3a')](_0x331b54[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x331b54[_0x7042('0x33')],function(_0x5e758c){var _0x10bb7a={};_0x10bb7a[_0x5e758c]={'$like':'%'+_0x5158b6[_0x7042('0x2e')][_0x7042('0x38')]+'%'};return _0x10bb7a;})});}_0x331b54=_[_0x7042('0x3a')]({},_0x331b54,_0x5158b6[_0x7042('0x3c')]);return db['CmHopper']['count']({'where':_0x331b54[_0x7042('0x39')]})['then'](function(_0x29fa20){_0x245201[_0x7042('0x1b')]=_0x29fa20;if(_0x5158b6[_0x7042('0x2e')][_0x7042('0x3d')]){_0x331b54[_0x7042('0x3e')]=[{'all':!![]}];}return db[_0x7042('0x55')]['findAll'](_0x331b54);})[_0x7042('0x21')](function(_0x5317c0){_0x245201[_0x7042('0x58')]=_0x5317c0;return _0x245201;});}})[_0x7042('0x21')](respondWithFilteredResult(_0x2256d3,_0x331b54))['catch'](handleError(_0x2256d3,null));};exports[_0x7042('0x59')]=function(_0x400004,_0x29c861,_0x271a62){var _0x54a65a={'raw':!![],'where':{}};var _0x2b3fb1={};var _0x462bb5={'count':0x0,'rows':[]};return db[_0x7042('0x2a')][_0x7042('0x5a')]({'where':{'id':_0x400004[_0x7042('0x41')]['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x29c861,null))[_0x7042('0x21')](function(_0x356841){if(_0x356841){_0x2b3fb1[_0x7042('0x2d')]=_['keys'](db[_0x7042('0x5b')][_0x7042('0x4f')]);_0x2b3fb1[_0x7042('0x2e')]=_['keys'](_0x400004[_0x7042('0x2e')]);_0x2b3fb1['filters']=_['intersection'](_0x2b3fb1[_0x7042('0x2d')],_0x2b3fb1[_0x7042('0x2e')]);_0x54a65a[_0x7042('0x33')]=_['intersection'](_0x2b3fb1[_0x7042('0x2d')],qs[_0x7042('0x32')](_0x400004[_0x7042('0x2e')]['fields']));_0x54a65a[_0x7042('0x33')]=_0x54a65a[_0x7042('0x33')][_0x7042('0x42')]?_0x54a65a[_0x7042('0x33')]:_0x2b3fb1[_0x7042('0x2d')];if(!_0x400004[_0x7042('0x2e')][_0x7042('0x34')]('nolimit')){_0x54a65a['limit']=qs[_0x7042('0x1d')](_0x400004['query'][_0x7042('0x1d')]);_0x54a65a[_0x7042('0x1c')]=qs['offset'](_0x400004['query'][_0x7042('0x1c')]);}_0x54a65a[_0x7042('0x56')]=qs['sort'](_0x400004[_0x7042('0x2e')][_0x7042('0x36')]);_0x54a65a[_0x7042('0x39')]=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x400004[_0x7042('0x2e')],_0x2b3fb1['filters']));_0x54a65a[_0x7042('0x39')][_0x7042('0x57')]=_0x356841['id'];if(_0x400004['query']['filter']){_0x54a65a[_0x7042('0x39')]=_['merge'](_0x54a65a[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x54a65a[_0x7042('0x33')],function(_0x5dd90d){var _0x5e8535={};_0x5e8535[_0x5dd90d]={'$like':'%'+_0x400004['query']['filter']+'%'};return _0x5e8535;})});}_0x54a65a=_[_0x7042('0x3a')]({},_0x54a65a,_0x400004[_0x7042('0x3c')]);return db[_0x7042('0x5b')][_0x7042('0x1b')]({'where':_0x54a65a[_0x7042('0x39')]})[_0x7042('0x21')](function(_0x392343){_0x462bb5['count']=_0x392343;if(_0x400004[_0x7042('0x2e')][_0x7042('0x3d')]){_0x54a65a['include']=[{'all':!![]}];}return db[_0x7042('0x5b')][_0x7042('0x5c')](_0x54a65a);})[_0x7042('0x21')](function(_0xfc46ac){_0x462bb5['rows']=_0xfc46ac;return _0x462bb5;});}})['then'](respondWithFilteredResult(_0x29c861,_0x54a65a))['catch'](handleError(_0x29c861,null));};exports[_0x7042('0x5d')]=function(_0x501a3e,_0x234cba,_0x2314fc){var _0x1ce11d={'raw':!![],'where':{}};var _0x50058b={};var _0x94ea96={'count':0x0,'rows':[]};return db[_0x7042('0x2a')][_0x7042('0x5a')]({'where':{'id':_0x501a3e[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x234cba,null))[_0x7042('0x21')](function(_0x3bdb8b){if(_0x3bdb8b){_0x50058b['model']=_['keys'](db[_0x7042('0x5e')][_0x7042('0x4f')]);_0x50058b[_0x7042('0x2e')]=_['keys'](_0x501a3e[_0x7042('0x2e')]);_0x50058b['filters']=_[_0x7042('0x31')](_0x50058b[_0x7042('0x2d')],_0x50058b[_0x7042('0x2e')]);_0x1ce11d[_0x7042('0x33')]=_[_0x7042('0x31')](_0x50058b[_0x7042('0x2d')],qs[_0x7042('0x32')](_0x501a3e[_0x7042('0x2e')]['fields']));_0x1ce11d[_0x7042('0x33')]=_0x1ce11d[_0x7042('0x33')][_0x7042('0x42')]?_0x1ce11d[_0x7042('0x33')]:_0x50058b[_0x7042('0x2d')];if(!_0x501a3e[_0x7042('0x2e')]['hasOwnProperty']('nolimit')){_0x1ce11d[_0x7042('0x1d')]=qs[_0x7042('0x1d')](_0x501a3e[_0x7042('0x2e')][_0x7042('0x1d')]);_0x1ce11d[_0x7042('0x1c')]=qs[_0x7042('0x1c')](_0x501a3e[_0x7042('0x2e')][_0x7042('0x1c')]);}_0x1ce11d[_0x7042('0x56')]=qs['sort'](_0x501a3e[_0x7042('0x2e')][_0x7042('0x36')]);_0x1ce11d['where']=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x501a3e[_0x7042('0x2e')],_0x50058b[_0x7042('0x30')]));_0x1ce11d[_0x7042('0x39')][_0x7042('0x57')]=_0x3bdb8b['id'];if(_0x501a3e['query'][_0x7042('0x38')]){_0x1ce11d[_0x7042('0x39')]=_['merge'](_0x1ce11d[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x1ce11d[_0x7042('0x33')],function(_0x25dd26){var _0x28dbdc={};_0x28dbdc[_0x25dd26]={'$like':'%'+_0x501a3e['query'][_0x7042('0x38')]+'%'};return _0x28dbdc;})});}_0x1ce11d=_[_0x7042('0x3a')]({},_0x1ce11d,_0x501a3e['options']);return db[_0x7042('0x5e')][_0x7042('0x1b')]({'where':_0x1ce11d[_0x7042('0x39')]})[_0x7042('0x21')](function(_0xf85af2){_0x94ea96['count']=_0xf85af2;if(_0x501a3e[_0x7042('0x2e')][_0x7042('0x3d')]){_0x1ce11d[_0x7042('0x3e')]=[{'all':!![]}];}return db[_0x7042('0x5e')][_0x7042('0x5c')](_0x1ce11d);})[_0x7042('0x21')](function(_0x3e2077){_0x94ea96[_0x7042('0x58')]=_0x3e2077;return _0x94ea96;});}})[_0x7042('0x21')](respondWithFilteredResult(_0x234cba,_0x1ce11d))[_0x7042('0x3f')](handleError(_0x234cba,null));};exports[_0x7042('0x5f')]=function(_0x34a64d,_0x39c85e,_0x5b5f1a){var _0x4a834e={'raw':!![],'where':{}};var _0x5ab8b5={};var _0x60717c={'count':0x0,'rows':[]};return db[_0x7042('0x2a')]['findOne']({'where':{'id':_0x34a64d[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x39c85e,null))[_0x7042('0x21')](function(_0x5a3095){if(_0x5a3095){_0x5ab8b5[_0x7042('0x2d')]=_[_0x7042('0x2f')](db[_0x7042('0x60')][_0x7042('0x4f')]);_0x5ab8b5['query']=_['keys'](_0x34a64d[_0x7042('0x2e')]);_0x5ab8b5[_0x7042('0x30')]=_[_0x7042('0x31')](_0x5ab8b5[_0x7042('0x2d')],_0x5ab8b5[_0x7042('0x2e')]);_0x4a834e['attributes']=_[_0x7042('0x31')](_0x5ab8b5[_0x7042('0x2d')],qs['fields'](_0x34a64d['query'][_0x7042('0x32')]));_0x4a834e[_0x7042('0x33')]=_0x4a834e[_0x7042('0x33')][_0x7042('0x42')]?_0x4a834e[_0x7042('0x33')]:_0x5ab8b5[_0x7042('0x2d')];if(!_0x34a64d[_0x7042('0x2e')][_0x7042('0x34')](_0x7042('0x35'))){_0x4a834e['limit']=qs[_0x7042('0x1d')](_0x34a64d[_0x7042('0x2e')][_0x7042('0x1d')]);_0x4a834e[_0x7042('0x1c')]=qs[_0x7042('0x1c')](_0x34a64d['query']['offset']);}_0x4a834e['order']=qs[_0x7042('0x36')](_0x34a64d[_0x7042('0x2e')]['sort']);_0x4a834e[_0x7042('0x39')]=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x34a64d[_0x7042('0x2e')],_0x5ab8b5['filters']));_0x4a834e[_0x7042('0x39')][_0x7042('0x57')]=_0x5a3095['id'];if(_0x34a64d[_0x7042('0x2e')][_0x7042('0x38')]){_0x4a834e['where']=_[_0x7042('0x3a')](_0x4a834e[_0x7042('0x39')],{'$or':_['map'](_0x4a834e['attributes'],function(_0x31f374){var _0x34dd15={};_0x34dd15[_0x31f374]={'$like':'%'+_0x34a64d[_0x7042('0x2e')][_0x7042('0x38')]+'%'};return _0x34dd15;})});}_0x4a834e=_[_0x7042('0x3a')]({},_0x4a834e,_0x34a64d[_0x7042('0x3c')]);return db[_0x7042('0x60')][_0x7042('0x1b')]({'where':_0x4a834e[_0x7042('0x39')]})[_0x7042('0x21')](function(_0x333ea4){_0x60717c[_0x7042('0x1b')]=_0x333ea4;if(_0x34a64d[_0x7042('0x2e')][_0x7042('0x3d')]){_0x4a834e[_0x7042('0x3e')]=[{'all':!![]}];}return db[_0x7042('0x60')][_0x7042('0x5c')](_0x4a834e);})[_0x7042('0x21')](function(_0x2935dc){_0x60717c[_0x7042('0x58')]=_0x2935dc;return _0x60717c;});}})[_0x7042('0x21')](respondWithFilteredResult(_0x39c85e,_0x4a834e))[_0x7042('0x3f')](handleError(_0x39c85e,null));};exports['getLists']=function(_0x3f3cd1,_0x268042,_0x60ba4f){var _0x5c9a48={};var _0x75fbfe={};var _0x11d0d8;var _0x44d4b6;return db['Campaign'][_0x7042('0x5a')]({'where':{'id':_0x3f3cd1[_0x7042('0x41')]['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x268042,null))[_0x7042('0x21')](function(_0x56ad5b){if(_0x56ad5b){_0x11d0d8=_0x56ad5b;_0x75fbfe[_0x7042('0x2d')]=_[_0x7042('0x2f')](db[_0x7042('0x61')][_0x7042('0x4f')]);_0x75fbfe[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x3f3cd1[_0x7042('0x2e')]);_0x75fbfe[_0x7042('0x30')]=_[_0x7042('0x31')](_0x75fbfe[_0x7042('0x2d')],_0x75fbfe[_0x7042('0x2e')]);_0x5c9a48[_0x7042('0x33')]=_['intersection'](_0x75fbfe[_0x7042('0x2d')],qs[_0x7042('0x32')](_0x3f3cd1[_0x7042('0x2e')][_0x7042('0x32')]));_0x5c9a48[_0x7042('0x33')]=_0x5c9a48['attributes'][_0x7042('0x42')]?_0x5c9a48[_0x7042('0x33')]:_0x75fbfe['model'];_0x5c9a48[_0x7042('0x56')]=qs[_0x7042('0x36')](_0x3f3cd1[_0x7042('0x2e')]['sort']);_0x5c9a48[_0x7042('0x39')]=qs[_0x7042('0x30')](_['pick'](_0x3f3cd1[_0x7042('0x2e')],_0x75fbfe[_0x7042('0x30')]));if(_0x3f3cd1[_0x7042('0x2e')]['filter']){_0x5c9a48[_0x7042('0x39')]=_[_0x7042('0x3a')](_0x5c9a48[_0x7042('0x39')],{'$or':_['map'](_0x5c9a48[_0x7042('0x33')],function(_0x15226f){var _0x51c9da={};_0x51c9da[_0x15226f]={'$like':'%'+_0x3f3cd1[_0x7042('0x2e')]['filter']+'%'};return _0x51c9da;})});}_0x5c9a48=_[_0x7042('0x3a')]({},_0x5c9a48,_0x3f3cd1['options']);return _0x11d0d8['getLists'](_0x5c9a48);}})['then'](function(_0xf0ff98){if(_0xf0ff98){_0x44d4b6=_0xf0ff98['length'];if(!_0x3f3cd1[_0x7042('0x2e')][_0x7042('0x34')](_0x7042('0x35'))){_0x5c9a48[_0x7042('0x1d')]=qs['limit'](_0x3f3cd1[_0x7042('0x2e')][_0x7042('0x1d')]);_0x5c9a48[_0x7042('0x1c')]=qs[_0x7042('0x1c')](_0x3f3cd1[_0x7042('0x2e')][_0x7042('0x1c')]);}return _0x11d0d8[_0x7042('0x62')](_0x5c9a48);}})[_0x7042('0x21')](function(_0x1a4da8){if(_0x1a4da8){return _0x1a4da8?{'count':_0x44d4b6,'rows':_0x1a4da8}:null;}})[_0x7042('0x21')](respondWithResult(_0x268042,null))[_0x7042('0x3f')](handleError(_0x268042,null));};exports[_0x7042('0x63')]=function(_0x484a5e,_0x1ffa4a,_0x29cc7e){var _0x59fe22,_0x5b5c52;var _0x9dfcce=[];var _0x241ef6=moment()[_0x7042('0x64')](_0x7042('0x65'));return db[_0x7042('0x2a')][_0x7042('0x4a')]({'where':{'id':_0x484a5e[_0x7042('0x41')]['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x1ffa4a,null))[_0x7042('0x21')](function(_0x2502fe){if(_0x2502fe){_0x5b5c52=_0x2502fe;return _0x2502fe[_0x7042('0x63')](_0x484a5e['body'][_0x7042('0x66')],_['omit'](_0x484a5e[_0x7042('0x44')],[_0x7042('0x66'),'id'])||{});}return null;})['spread'](function(_0x526699){var _0x305f11;var _0x112e5c;_0x59fe22=_0x526699||[];var _0x291172=[];if(_0x526699){for(var _0x564e1e=0x0;_0x564e1e<_0x526699[_0x7042('0x42')];_0x564e1e+=0x1){var _0x13f8ec=_0x526699[_0x564e1e][_0x7042('0x23')]({'plain':!![]});_0x5b5c52[_0x7042('0x67')]=_0x484a5e[_0x7042('0x44')][_0x7042('0x67')]?_0x484a5e[_0x7042('0x44')]['dialCheckDuplicateType']:_0x5b5c52[_0x7042('0x67')];switch(_0x5b5c52[_0x7042('0x67')]){case _0x7042('0x68'):_0x305f11=squel['insert']()['into'](_0x7042('0x69'))[_0x7042('0x6a')](['phone','scheduledAt','ContactId',_0x7042('0x6b'),_0x7042('0x57'),_0x7042('0x51'),_0x7042('0x52')],squel[_0x7042('0x6c')]()[_0x7042('0x6d')](_0x7042('0x6e'),_0x7042('0x6e'))[_0x7042('0x6d')]('NOW()',_0x7042('0x6f'))[_0x7042('0x6d')]('id','ContactId')[_0x7042('0x6d')](_0x13f8ec['CmListId'][_0x7042('0x70')](),'ListId')[_0x7042('0x6d')](_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')](),_0x7042('0x57'))['field']('\x27'+_0x241ef6+'\x27',_0x7042('0x51'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x52'))[_0x7042('0x71')]('cm_contacts')[_0x7042('0x39')](_0x7042('0x72'))[_0x7042('0x39')](_0x7042('0x73'),_0x13f8ec[_0x7042('0x74')][_0x7042('0x70')]())[_0x7042('0x39')](_0x7042('0x75'))[_0x7042('0x39')](_0x7042('0x76'),squel[_0x7042('0x6c')]()['field'](_0x7042('0x77'))[_0x7042('0x71')]('cm_hopper_final')['where']('CampaignId\x20=\x20?',_0x484a5e['params']['id']['toString']()))['where'](_0x7042('0x76'),squel['select']()[_0x7042('0x6d')](_0x7042('0x78'))[_0x7042('0x71')](_0x7042('0x69'))[_0x7042('0x39')]('CampaignId\x20=\x20?',_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')]())))[_0x7042('0x70')]();break;case'onlyIfOpen':_0x305f11=squel[_0x7042('0x79')]()[_0x7042('0x7a')]('cm_hopper')[_0x7042('0x6a')]([_0x7042('0x6e'),_0x7042('0x6f'),_0x7042('0x7b'),_0x7042('0x6b'),_0x7042('0x57'),_0x7042('0x51'),'updatedAt'],squel[_0x7042('0x6c')]()[_0x7042('0x6d')](_0x7042('0x6e'),'phone')['field'](_0x7042('0x7c'),_0x7042('0x6f'))['field']('id','ContactId')[_0x7042('0x6d')](_0x13f8ec[_0x7042('0x74')][_0x7042('0x70')](),_0x7042('0x6b'))['field'](_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')](),_0x7042('0x57'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x51'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27','updatedAt')[_0x7042('0x71')](_0x7042('0x7d'))[_0x7042('0x39')](_0x7042('0x72'))[_0x7042('0x39')](_0x7042('0x73'),_0x13f8ec[_0x7042('0x74')][_0x7042('0x70')]())['where'](_0x7042('0x75'))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0x7042('0x6c')]()['field'](_0x7042('0x78'))[_0x7042('0x71')](_0x7042('0x69'))[_0x7042('0x39')](_0x7042('0x7e'),_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')]())))[_0x7042('0x70')]();break;default:_0x305f11=squel[_0x7042('0x79')]()['into'](_0x7042('0x69'))[_0x7042('0x6a')]([_0x7042('0x6e'),'scheduledAt',_0x7042('0x7b'),'ListId','CampaignId',_0x7042('0x51'),_0x7042('0x52')],squel['select']()[_0x7042('0x6d')]('phone',_0x7042('0x6e'))[_0x7042('0x6d')](_0x7042('0x7c'),_0x7042('0x6f'))[_0x7042('0x6d')]('id',_0x7042('0x7b'))[_0x7042('0x6d')](_0x13f8ec[_0x7042('0x74')][_0x7042('0x70')](),'ListId')['field'](_0x484a5e[_0x7042('0x41')]['id']['toString'](),_0x7042('0x57'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x51'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x52'))['from']('cm_contacts')['where'](_0x7042('0x72'))['where'](_0x7042('0x73'),_0x13f8ec['CmListId']['toString']())['where'](_0x7042('0x75')))[_0x7042('0x70')]();}_0x112e5c=squel[_0x7042('0x79')]()[_0x7042('0x7a')](_0x7042('0x7f'))[_0x7042('0x6a')]([_0x7042('0x80'),_0x7042('0x6f'),_0x7042('0x6e'),'OrderBy',_0x7042('0x51'),_0x7042('0x52')],squel[_0x7042('0x6c')]()[_0x7042('0x6d')]('h.id','id')[_0x7042('0x6d')]('NOW()',_0x7042('0x6f'))[_0x7042('0x6d')]('ci.item',_0x7042('0x6e'))[_0x7042('0x6d')](_0x7042('0x81'),'OrderBy')[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x51'))[_0x7042('0x6d')]('\x27'+_0x241ef6+'\x27',_0x7042('0x52'))[_0x7042('0x71')](_0x7042('0x82'),'ci')[_0x7042('0x83')](_0x7042('0x69'),'h',_0x7042('0x84'))[_0x7042('0x39')]('h.ListId\x20=\x20?',_0x13f8ec['CmListId'][_0x7042('0x70')]())[_0x7042('0x39')](_0x7042('0x85'),_0x484a5e[_0x7042('0x41')]['id'][_0x7042('0x70')]())[_0x7042('0x39')](_0x7042('0x86'),_0x241ef6))[_0x7042('0x70')]();_0x291172[_0x7042('0x87')](db[_0x7042('0x88')][_0x7042('0x2e')](_0x305f11));_0x9dfcce[_0x7042('0x87')](db[_0x7042('0x88')][_0x7042('0x2e')](_0x112e5c));}return BPromise[_0x7042('0x89')](_0x291172);}})[_0x7042('0x21')](function(){return BPromise[_0x7042('0x89')](_0x9dfcce);})['then'](function(){return _0x59fe22;})['then'](respondWithResult(_0x1ffa4a,null))[_0x7042('0x3f')](handleError(_0x1ffa4a,null));};exports['removeLists']=function(_0x3b407b,_0x3432f7,_0x314db7){return db[_0x7042('0x2a')][_0x7042('0x4a')]({'where':{'id':_0x3b407b[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x3432f7,null))[_0x7042('0x21')](function(_0x43162e){if(_0x43162e){return _0x43162e[_0x7042('0x8a')](_0x3b407b[_0x7042('0x2e')][_0x7042('0x66')]);}})[_0x7042('0x21')](function(_0x5c66fa){if(_0x5c66fa){return db[_0x7042('0x55')]['destroy']({'where':{'ListId':_0x3b407b['query'][_0x7042('0x66')],'CampaignId':_0x3b407b[_0x7042('0x41')]['id']}})[_0x7042('0x21')](function(){return _0x5c66fa;});}})[_0x7042('0x21')](respondWithStatusCode(_0x3432f7,null))[_0x7042('0x3f')](handleError(_0x3432f7,null));};exports[_0x7042('0x8b')]=function(_0x302339,_0x2ab49a,_0x3b37e9){var _0x218b75={};var _0x4fc9e7={};var _0x392ab5;var _0x591d6d;return db[_0x7042('0x2a')][_0x7042('0x5a')]({'where':{'id':_0x302339[_0x7042('0x41')]['id']}})[_0x7042('0x21')](handleEntityNotFound(_0x2ab49a,null))['then'](function(_0x10a106){if(_0x10a106){_0x392ab5=_0x10a106;_0x4fc9e7[_0x7042('0x2d')]=_['keys'](db[_0x7042('0x61')][_0x7042('0x4f')]);_0x4fc9e7[_0x7042('0x2e')]=_[_0x7042('0x2f')](_0x302339[_0x7042('0x2e')]);_0x4fc9e7['filters']=_['intersection'](_0x4fc9e7['model'],_0x4fc9e7[_0x7042('0x2e')]);_0x218b75[_0x7042('0x33')]=_[_0x7042('0x31')](_0x4fc9e7['model'],qs['fields'](_0x302339[_0x7042('0x2e')]['fields']));_0x218b75['attributes']=_0x218b75[_0x7042('0x33')][_0x7042('0x42')]?_0x218b75[_0x7042('0x33')]:_0x4fc9e7[_0x7042('0x2d')];_0x218b75[_0x7042('0x56')]=qs[_0x7042('0x36')](_0x302339['query'][_0x7042('0x36')]);_0x218b75[_0x7042('0x39')]=qs[_0x7042('0x30')](_[_0x7042('0x37')](_0x302339[_0x7042('0x2e')],_0x4fc9e7[_0x7042('0x30')]));if(_0x302339['query'][_0x7042('0x38')]){_0x218b75[_0x7042('0x39')]=_[_0x7042('0x3a')](_0x218b75[_0x7042('0x39')],{'$or':_[_0x7042('0x29')](_0x218b75[_0x7042('0x33')],function(_0x5a4529){var _0x57357e={};_0x57357e[_0x5a4529]={'$like':'%'+_0x302339[_0x7042('0x2e')][_0x7042('0x38')]+'%'};return _0x57357e;})});}_0x218b75=_[_0x7042('0x3a')]({},_0x218b75,_0x302339[_0x7042('0x3c')]);return _0x392ab5['getBlackLists'](_0x218b75);}})[_0x7042('0x21')](function(_0xfba18d){if(_0xfba18d){_0x591d6d=_0xfba18d['length'];if(!_0x302339[_0x7042('0x2e')][_0x7042('0x34')]('nolimit')){_0x218b75[_0x7042('0x1d')]=qs[_0x7042('0x1d')](_0x302339[_0x7042('0x2e')]['limit']);_0x218b75['offset']=qs[_0x7042('0x1c')](_0x302339[_0x7042('0x2e')][_0x7042('0x1c')]);}return _0x392ab5['getBlackLists'](_0x218b75);}})['then'](function(_0x55c18b){if(_0x55c18b){return _0x55c18b?{'count':_0x591d6d,'rows':_0x55c18b}:null;}})[_0x7042('0x21')](respondWithResult(_0x2ab49a,null))[_0x7042('0x3f')](handleError(_0x2ab49a,null));};exports[_0x7042('0x8c')]=function(_0x3239cd,_0x14d90e,_0x310266){var _0x589aed,_0x426ba5;var _0x4fce5a=[];var _0x567233=moment()['format']('YYYY-MM-DD\x20HH:mm:ss');return db[_0x7042('0x2a')]['find']({'where':{'id':_0x3239cd[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x14d90e,null))[_0x7042('0x21')](function(_0x3e7c8e){if(_0x3e7c8e){_0x426ba5=_0x3e7c8e;return _0x3e7c8e[_0x7042('0x8c')](_0x3239cd[_0x7042('0x44')][_0x7042('0x66')],_[_0x7042('0x50')](_0x3239cd['body'],[_0x7042('0x66'),'id'])||{});}return null;})[_0x7042('0x8d')](function(_0x109a24){var _0x464080;var _0x42242b;_0x589aed=_0x109a24||[];var _0x295a93=[];if(_0x109a24){for(var _0x59b1ef=0x0;_0x59b1ef<_0x109a24[_0x7042('0x42')];_0x59b1ef+=0x1){var _0x1aeb73=_0x109a24[_0x59b1ef][_0x7042('0x23')]({'plain':!![]});_0x464080=squel['insert']()['into'](_0x7042('0x8e'))['fromQuery'](['phone',_0x7042('0x7b'),'ListId',_0x7042('0x57'),_0x7042('0x51'),_0x7042('0x52')],squel[_0x7042('0x6c')]()['field']('phone','phone')[_0x7042('0x6d')]('id',_0x7042('0x7b'))[_0x7042('0x6d')](_0x1aeb73[_0x7042('0x74')][_0x7042('0x70')](),_0x7042('0x6b'))[_0x7042('0x6d')](_0x3239cd[_0x7042('0x41')]['id'][_0x7042('0x70')](),_0x7042('0x57'))[_0x7042('0x6d')](_0x7042('0x7c'),_0x7042('0x51'))[_0x7042('0x6d')](_0x7042('0x7c'),_0x7042('0x52'))[_0x7042('0x71')](_0x7042('0x7d'))['where'](_0x7042('0x72'))['where']('ListId\x20=\x20?',_0x1aeb73[_0x7042('0x74')][_0x7042('0x70')]())[_0x7042('0x39')](_0x7042('0x75')))[_0x7042('0x70')]();_0x295a93[_0x7042('0x87')](db[_0x7042('0x88')][_0x7042('0x2e')](_0x464080));}return BPromise[_0x7042('0x89')](_0x295a93);}})['then'](function(){return _0x589aed;})[_0x7042('0x21')](respondWithResult(_0x14d90e,null))[_0x7042('0x3f')](handleError(_0x14d90e,null));};exports['removeBlackLists']=function(_0x18b18d,_0x4aed19,_0x36d558){return db[_0x7042('0x2a')][_0x7042('0x4a')]({'where':{'id':_0x18b18d[_0x7042('0x41')]['id']}})['then'](handleEntityNotFound(_0x4aed19,null))[_0x7042('0x21')](function(_0x5cfdaf){if(_0x5cfdaf){return _0x5cfdaf[_0x7042('0x8f')](_0x18b18d['query']['ids']);}})[_0x7042('0x21')](function(_0x3929db){if(_0x3929db){return db[_0x7042('0x60')][_0x7042('0x22')]({'where':{'ListId':_0x18b18d[_0x7042('0x2e')][_0x7042('0x66')],'CampaignId':_0x18b18d[_0x7042('0x41')]['id']}})[_0x7042('0x21')](function(){return _0x3929db;});}})['then'](respondWithStatusCode(_0x4aed19,null))['catch'](handleError(_0x4aed19,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff