Built motion from commit eddce310.|2.6.12

[motion2.git] / server / api / campaign / campaign.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * 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));};