// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xb43b=['includeAll','include','findAll','rows','catch','show','params','find','describe','body','uniqueid','countContactsQueueCampaignHopperFinal','sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','`state`\x20=\x208,\x201,\x20null','`state`\x20=\x2010\x20,\x201,\x20null','`state`\x20=\x2022,\x201,\x20null','`state`\x20=\x2019,\x201,\x20null','answeringMachine','noSuchContacts','busyContacts','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','reCallContacts','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','VoiceQueueId','createdAt','updatedAt','select','field','ANY_VALUE(calleridnum)','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','from','cm_hopper_final','toString','state\x20=\x20?','calleridnum\x20NOT\x20IN\x20(?)','calleridnum','VoiceQueueId\x20=\x20?','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','Campaign','CampaignId','ANY_VALUE(CampaignId)','calleridnum\x20IS\x20NOT\x20NULL','CampaignId\x20=\x20?','CmHopper','findOne','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','lodash','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','status','end','json','count','offset','limit','Content-Range','apply','save','update','then','destroy','name','index','map','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filters','filter','merge','VIRTUAL','options','CmHopperFinal'];(function(_0x32e54a,_0x59fc0d){var _0x109af4=function(_0x564be8){while(--_0x564be8){_0x32e54a['push'](_0x32e54a['shift']());}};_0x109af4(++_0x59fc0d);}(_0xb43b,0xbf));var _0xbb43=function(_0x276eaf,_0x541331){_0x276eaf=_0x276eaf-0x0;var _0x161262=_0xb43b[_0x276eaf];return _0x161262;};'use strict';var pdf=require(_0xbb43('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xbb43('0x1'));var zipdir=require(_0xbb43('0x2'));var jsonpatch=require(_0xbb43('0x3'));var rp=require(_0xbb43('0x4'));var moment=require(_0xbb43('0x5'));var BPromise=require(_0xbb43('0x6'));var Mustache=require(_0xbb43('0x7'));var util=require(_0xbb43('0x8'));var path=require(_0xbb43('0x9'));var sox=require(_0xbb43('0xa'));var csv=require(_0xbb43('0xb'));var ejs=require('ejs');var fs=require('fs');var _=require(_0xbb43('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xbb43('0xd'));var deskjs=require(_0xbb43('0xe'));var toCsv=require(_0xbb43('0xb'));var querystring=require(_0xbb43('0xf'));var Papa=require(_0xbb43('0x10'));var Redis=require('ioredis');var authService=require(_0xbb43('0x11'));var qs=require(_0xbb43('0x12'));var as=require(_0xbb43('0x13'));var hardwareService=require(_0xbb43('0x14'));var logger=require('../../config/logger')(_0xbb43('0x15'));var utils=require(_0xbb43('0x16'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x2867fb,_0x5d0ccc){_0x5d0ccc=_0x5d0ccc||0xcc;return function(_0x6be368){if(_0x6be368){return _0x2867fb['sendStatus'](_0x5d0ccc);}return _0x2867fb[_0xbb43('0x17')](_0x5d0ccc)[_0xbb43('0x18')]();};}function respondWithResult(_0x3ce968,_0x3327bc){_0x3327bc=_0x3327bc||0xc8;return function(_0x2e2517){if(_0x2e2517){return _0x3ce968['status'](_0x3327bc)[_0xbb43('0x19')](_0x2e2517);}};}function respondWithFilteredResult(_0x4ac25c,_0x199726){return function(_0x32425c){if(_0x32425c){var _0x15182b=_0x32425c[_0xbb43('0x1a')],_0x10c91b=_0x199726[_0xbb43('0x1b')],_0x3be44b=_0x199726[_0xbb43('0x1b')]+_0x199726[_0xbb43('0x1c')],_0x126f61;if(_0x3be44b>=_0x15182b){_0x3be44b=_0x15182b;_0x126f61=0xc8;}else{_0x126f61=0xce;}_0x4ac25c[_0xbb43('0x17')](_0x126f61);return _0x4ac25c['set'](_0xbb43('0x1d'),_0x10c91b+'-'+_0x3be44b+'/'+_0x15182b)['json'](_0x32425c);}return null;};}function patchUpdates(_0x44fd04){return function(_0x5f4b4f){try{jsonpatch[_0xbb43('0x1e')](_0x5f4b4f,_0x44fd04,!![]);}catch(_0x27579a){return BPromise['reject'](_0x27579a);}return _0x5f4b4f[_0xbb43('0x1f')]();};}function saveUpdates(_0x6cdc26,_0x398ce5){return function(_0x6f34d6){if(_0x6f34d6){return _0x6f34d6[_0xbb43('0x20')](_0x6cdc26)[_0xbb43('0x21')](function(_0xee1084){return _0xee1084;});}return null;};}function removeEntity(_0x1e83cd,_0x3409d0){return function(_0x3cb6d1){if(_0x3cb6d1){return _0x3cb6d1[_0xbb43('0x22')]()[_0xbb43('0x21')](function(){_0x1e83cd[_0xbb43('0x17')](0xcc)[_0xbb43('0x18')]();});}};}function handleEntityNotFound(_0x500af4,_0x28b3e4){return function(_0x326864){if(!_0x326864){_0x500af4['sendStatus'](0x194);}return _0x326864;};}function handleError(_0x464b4a,_0x2b07d8){_0x2b07d8=_0x2b07d8||0x1f4;return function(_0x25279b){logger['error'](_0x25279b['stack']);if(_0x25279b[_0xbb43('0x23')]){delete _0x25279b[_0xbb43('0x23')];}_0x464b4a['status'](_0x2b07d8)['send'](_0x25279b);};}exports[_0xbb43('0x24')]=function(_0xb9fe3b,_0x268fb5){var _0x4bb859={},_0x27bb65={},_0x426cec={'count':0x0,'rows':[]};var _0x2dcc60=_[_0xbb43('0x25')](db['CmHopperFinal'][_0xbb43('0x26')],function(_0x170e7a){return{'name':_0x170e7a[_0xbb43('0x27')],'type':_0x170e7a[_0xbb43('0x28')][_0xbb43('0x29')]};});_0x27bb65[_0xbb43('0x2a')]=_[_0xbb43('0x25')](_0x2dcc60,'name');_0x27bb65[_0xbb43('0x2b')]=_[_0xbb43('0x2c')](_0xb9fe3b[_0xbb43('0x2b')]);_0x27bb65['filters']=_[_0xbb43('0x2d')](_0x27bb65[_0xbb43('0x2a')],_0x27bb65[_0xbb43('0x2b')]);_0x4bb859[_0xbb43('0x2e')]=_[_0xbb43('0x2d')](_0x27bb65[_0xbb43('0x2a')],qs[_0xbb43('0x2f')](_0xb9fe3b[_0xbb43('0x2b')][_0xbb43('0x2f')]));_0x4bb859['attributes']=_0x4bb859['attributes']['length']?_0x4bb859['attributes']:_0x27bb65[_0xbb43('0x2a')];if(!_0xb9fe3b[_0xbb43('0x2b')][_0xbb43('0x30')](_0xbb43('0x31'))){_0x4bb859[_0xbb43('0x1c')]=qs[_0xbb43('0x1c')](_0xb9fe3b[_0xbb43('0x2b')][_0xbb43('0x1c')]);_0x4bb859['offset']=qs[_0xbb43('0x1b')](_0xb9fe3b[_0xbb43('0x2b')][_0xbb43('0x1b')]);}_0x4bb859[_0xbb43('0x32')]=qs['sort'](_0xb9fe3b[_0xbb43('0x2b')][_0xbb43('0x33')]);_0x4bb859[_0xbb43('0x34')]=qs[_0xbb43('0x35')](_['pick'](_0xb9fe3b[_0xbb43('0x2b')],_0x27bb65['filters']),_0x2dcc60);if(_0xb9fe3b[_0xbb43('0x2b')][_0xbb43('0x36')]){_0x4bb859[_0xbb43('0x34')]=_[_0xbb43('0x37')](_0x4bb859[_0xbb43('0x34')],{'$or':_[_0xbb43('0x25')](_0x2dcc60,function(_0x316ab1){if(_0x316ab1[_0xbb43('0x28')]!==_0xbb43('0x38')){var _0xa48590={};_0xa48590[_0x316ab1[_0xbb43('0x23')]]={'$like':'%'+_0xb9fe3b[_0xbb43('0x2b')]['filter']+'%'};return _0xa48590;}})});}_0x4bb859=_[_0xbb43('0x37')]({},_0x4bb859,_0xb9fe3b[_0xbb43('0x39')]);var _0x363e1a={'where':_0x4bb859[_0xbb43('0x34')]};return db[_0xbb43('0x3a')][_0xbb43('0x1a')](_0x363e1a)[_0xbb43('0x21')](function(_0x3d7d56){_0x426cec[_0xbb43('0x1a')]=_0x3d7d56;if(_0xb9fe3b[_0xbb43('0x2b')][_0xbb43('0x3b')]){_0x4bb859[_0xbb43('0x3c')]=[{'all':!![]}];}return db[_0xbb43('0x3a')][_0xbb43('0x3d')](_0x4bb859);})[_0xbb43('0x21')](function(_0x4a76a8){_0x426cec[_0xbb43('0x3e')]=_0x4a76a8;return _0x426cec;})[_0xbb43('0x21')](respondWithFilteredResult(_0x268fb5,_0x4bb859))[_0xbb43('0x3f')](handleError(_0x268fb5,null));};exports[_0xbb43('0x40')]=function(_0x60a465,_0x4b32c9){var _0x5e942e={'raw':!![],'where':{'id':_0x60a465[_0xbb43('0x41')]['id']}},_0x13e9f7={};_0x13e9f7['model']=_['keys'](db[_0xbb43('0x3a')][_0xbb43('0x26')]);_0x13e9f7[_0xbb43('0x2b')]=_[_0xbb43('0x2c')](_0x60a465[_0xbb43('0x2b')]);_0x13e9f7['filters']=_['intersection'](_0x13e9f7[_0xbb43('0x2a')],_0x13e9f7[_0xbb43('0x2b')]);_0x5e942e[_0xbb43('0x2e')]=_[_0xbb43('0x2d')](_0x13e9f7[_0xbb43('0x2a')],qs[_0xbb43('0x2f')](_0x60a465[_0xbb43('0x2b')][_0xbb43('0x2f')]));_0x5e942e[_0xbb43('0x2e')]=_0x5e942e[_0xbb43('0x2e')]['length']?_0x5e942e['attributes']:_0x13e9f7[_0xbb43('0x2a')];if(_0x60a465[_0xbb43('0x2b')]['includeAll']){_0x5e942e[_0xbb43('0x3c')]=[{'all':!![]}];}_0x5e942e=_[_0xbb43('0x37')]({},_0x5e942e,_0x60a465[_0xbb43('0x39')]);return db[_0xbb43('0x3a')][_0xbb43('0x42')](_0x5e942e)[_0xbb43('0x21')](handleEntityNotFound(_0x4b32c9,null))[_0xbb43('0x21')](respondWithResult(_0x4b32c9,null))['catch'](handleError(_0x4b32c9,null));};exports[_0xbb43('0x43')]=function(_0x229928,_0x5970cc){return db[_0xbb43('0x3a')][_0xbb43('0x43')]()['then'](respondWithResult(_0x5970cc,null))[_0xbb43('0x3f')](handleError(_0x5970cc,null));};exports[_0xbb43('0x20')]=function(_0xd1f32b,_0x15fab6){if(_0xd1f32b[_0xbb43('0x44')][_0xbb43('0x45')]){delete _0xd1f32b[_0xbb43('0x44')][_0xbb43('0x45')];}return db[_0xbb43('0x3a')][_0xbb43('0x42')]({'where':{'uniqueid':_0xd1f32b[_0xbb43('0x41')]['id']}})[_0xbb43('0x21')](handleEntityNotFound(_0x15fab6,null))['then'](saveUpdates(_0xd1f32b[_0xbb43('0x44')],null))[_0xbb43('0x21')](respondWithResult(_0x15fab6,null))[_0xbb43('0x3f')](handleError(_0x15fab6,null));};exports[_0xbb43('0x46')]=function(_0x4ab63b,_0x33d21b,_0x4998fb){return db[_0xbb43('0x3a')]['findAll']({'raw':![],'where':{'VoiceQueueId':_0x4ab63b[_0xbb43('0x41')]['id']},'attributes':[[db[_0xbb43('0x47')]['fn'](_0xbb43('0x48'),db['sequelize']['fn']('IF',db[_0xbb43('0x47')][_0xbb43('0x49')](_0xbb43('0x4a')))),'noSuchContacts'],[db[_0xbb43('0x47')]['fn'](_0xbb43('0x48'),db['sequelize']['fn']('IF',db[_0xbb43('0x47')]['literal'](_0xbb43('0x4b')))),_0xbb43('0x4c')],[db['sequelize']['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db[_0xbb43('0x47')]['literal'](_0xbb43('0x4d')))),'busyContacts'],[db[_0xbb43('0x47')]['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db['sequelize'][_0xbb43('0x49')](_0xbb43('0x4e')))),'congestionContacts'],[db['sequelize']['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db['sequelize']['literal'](_0xbb43('0x4f')))),'dropContacts'],[db[_0xbb43('0x47')]['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db['sequelize']['literal']('`state`\x20=\x2011\x20,\x201,\x20null'))),'abandonedContacts'],[db['sequelize']['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db[_0xbb43('0x47')][_0xbb43('0x49')](_0xbb43('0x50')))),'reCallContacts'],[db[_0xbb43('0x47')]['fn']('COUNT',db[_0xbb43('0x47')]['fn']('IF',db['sequelize'][_0xbb43('0x49')](_0xbb43('0x51')))),_0xbb43('0x52')]]})[_0xbb43('0x21')](handleEntityNotFound(_0x33d21b,null))['then'](respondWithResult(_0x33d21b,null))[_0xbb43('0x3f')](handleError(_0x33d21b,null));};exports['countContactsIvrCampaignHopperFinal']=function(_0x3f3292,_0x213747,_0x512619){return db[_0xbb43('0x3a')][_0xbb43('0x3d')]({'raw':![],'where':{'CampaignId':_0x3f3292['params']['id']},'attributes':[[db[_0xbb43('0x47')]['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db[_0xbb43('0x47')][_0xbb43('0x49')](_0xbb43('0x4a')))),_0xbb43('0x53')],[db[_0xbb43('0x47')]['fn']('COUNT',db[_0xbb43('0x47')]['fn']('IF',db['sequelize'][_0xbb43('0x49')](_0xbb43('0x4b')))),'noAnswerContacts'],[db[_0xbb43('0x47')]['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db[_0xbb43('0x47')][_0xbb43('0x49')](_0xbb43('0x4d')))),_0xbb43('0x54')],[db[_0xbb43('0x47')]['fn']('COUNT',db[_0xbb43('0x47')]['fn']('IF',db[_0xbb43('0x47')][_0xbb43('0x49')](_0xbb43('0x4e')))),'congestionContacts'],[db[_0xbb43('0x47')]['fn']('COUNT',db[_0xbb43('0x47')]['fn']('IF',db['sequelize'][_0xbb43('0x49')](_0xbb43('0x4f')))),_0xbb43('0x55')],[db[_0xbb43('0x47')]['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db[_0xbb43('0x47')][_0xbb43('0x49')](_0xbb43('0x56')))),_0xbb43('0x57')],[db['sequelize']['fn'](_0xbb43('0x48'),db['sequelize']['fn']('IF',db[_0xbb43('0x47')][_0xbb43('0x49')](_0xbb43('0x50')))),_0xbb43('0x58')],[db[_0xbb43('0x47')]['fn'](_0xbb43('0x48'),db[_0xbb43('0x47')]['fn']('IF',db[_0xbb43('0x47')]['literal'](_0xbb43('0x51')))),'answeringMachine']]})['then'](handleEntityNotFound(_0x213747,null))[_0xbb43('0x21')](respondWithResult(_0x213747,null))['catch'](handleError(_0x213747,null));};exports[_0xbb43('0x59')]=function(_0x212dc9,_0x4eb58f,_0x221727){return db[_0xbb43('0x5a')]['find']({'where':{'id':_0x212dc9[_0xbb43('0x41')]['id']}})[_0xbb43('0x21')](handleEntityNotFound(_0x4eb58f,null))[_0xbb43('0x21')](function(_0x14678c){var _0x40ac8c;if(_0x14678c){_0x40ac8c=squel[_0xbb43('0x5b')]()[_0xbb43('0x5c')](_0xbb43('0x5d'))[_0xbb43('0x5e')]([_0xbb43('0x5f'),_0xbb43('0x60'),_0xbb43('0x61'),_0xbb43('0x62'),_0xbb43('0x63'),_0xbb43('0x64'),_0xbb43('0x65')],squel[_0xbb43('0x66')]()[_0xbb43('0x67')](_0xbb43('0x68'),_0xbb43('0x5f'))[_0xbb43('0x67')](_0xbb43('0x69'),_0xbb43('0x60'))[_0xbb43('0x67')](_0xbb43('0x6a'),_0xbb43('0x61'))[_0xbb43('0x67')](_0xbb43('0x6b'),_0xbb43('0x62'))[_0xbb43('0x67')]('ANY_VALUE(VoiceQueueId)',_0xbb43('0x63'))[_0xbb43('0x67')](_0xbb43('0x69'),_0xbb43('0x64'))[_0xbb43('0x67')](_0xbb43('0x69'),'updatedAt')[_0xbb43('0x6c')](_0xbb43('0x6d'))['where']('VoiceQueueId\x20=\x20?',_0x212dc9['params']['id'][_0xbb43('0x6e')]())[_0xbb43('0x34')](_0xbb43('0x6f'),_0x212dc9[_0xbb43('0x44')]['state']['toString']())[_0xbb43('0x34')]('calleridnum\x20IS\x20NOT\x20NULL')[_0xbb43('0x34')](_0xbb43('0x70'),squel['select']()[_0xbb43('0x67')](_0xbb43('0x5f'))[_0xbb43('0x6c')]('cm_hopper')[_0xbb43('0x34')]('VoiceQueueId\x20=\x20?',_0x212dc9[_0xbb43('0x41')]['id'][_0xbb43('0x6e')]()))['where'](_0xbb43('0x70'),squel[_0xbb43('0x66')]()[_0xbb43('0x67')](_0xbb43('0x71'))[_0xbb43('0x6c')]('cm_hopper_final')['where'](_0xbb43('0x72'),_0x212dc9[_0xbb43('0x41')]['id'][_0xbb43('0x6e')]())[_0xbb43('0x34')](_0xbb43('0x73')))[_0xbb43('0x74')](_0xbb43('0x61')))[_0xbb43('0x6e')]();return db['sequelize'][_0xbb43('0x2b')](_0x40ac8c);}return[];})['then'](respondWithResult(_0x4eb58f,null))[_0xbb43('0x3f')](handleError(_0x4eb58f,null));};exports[_0xbb43('0x75')]=function(_0x4cee24,_0x371a7c,_0x1ba677){return db[_0xbb43('0x76')][_0xbb43('0x42')]({'where':{'id':_0x4cee24[_0xbb43('0x41')]['id']}})[_0xbb43('0x21')](handleEntityNotFound(_0x371a7c,null))['then'](function(_0x3d0182){var _0x2d18e7;if(_0x3d0182){_0x2d18e7=squel['insert']()[_0xbb43('0x5c')]('cm_hopper')[_0xbb43('0x5e')]([_0xbb43('0x5f'),_0xbb43('0x60'),_0xbb43('0x61'),_0xbb43('0x62'),_0xbb43('0x77'),_0xbb43('0x64'),_0xbb43('0x65')],squel[_0xbb43('0x66')]()[_0xbb43('0x67')](_0xbb43('0x68'),'phone')[_0xbb43('0x67')]('NOW()',_0xbb43('0x60'))[_0xbb43('0x67')](_0xbb43('0x6a'),_0xbb43('0x61'))[_0xbb43('0x67')]('ANY_VALUE(ListId)',_0xbb43('0x62'))[_0xbb43('0x67')](_0xbb43('0x78'),_0xbb43('0x77'))[_0xbb43('0x67')]('NOW()',_0xbb43('0x64'))['field'](_0xbb43('0x69'),_0xbb43('0x65'))[_0xbb43('0x6c')](_0xbb43('0x6d'))[_0xbb43('0x34')]('CampaignId\x20=\x20?',_0x4cee24[_0xbb43('0x41')]['id']['toString']())[_0xbb43('0x34')]('state\x20=\x20?',_0x4cee24[_0xbb43('0x44')]['state'][_0xbb43('0x6e')]())[_0xbb43('0x34')](_0xbb43('0x79'))['where'](_0xbb43('0x70'),squel['select']()[_0xbb43('0x67')](_0xbb43('0x5f'))['from'](_0xbb43('0x5d'))[_0xbb43('0x34')](_0xbb43('0x7a'),_0x4cee24[_0xbb43('0x41')]['id']['toString']()))[_0xbb43('0x34')](_0xbb43('0x70'),squel['select']()['field']('calleridnum')[_0xbb43('0x6c')]('cm_hopper_final')[_0xbb43('0x34')](_0xbb43('0x7a'),_0x4cee24[_0xbb43('0x41')]['id']['toString']())['where'](_0xbb43('0x73')))[_0xbb43('0x74')](_0xbb43('0x61')))[_0xbb43('0x6e')]();return db['sequelize'][_0xbb43('0x2b')](_0x2d18e7);}return[];})[_0xbb43('0x21')](respondWithResult(_0x371a7c,null))[_0xbb43('0x3f')](handleError(_0x371a7c,null));};exports['checkContactHopper']=function(_0x202f08,_0xc9623,_0x75999e){return db[_0xbb43('0x7b')][_0xbb43('0x7c')]({'where':{'VoiceQueueId':_0x202f08['body'][_0xbb43('0x63')],'CampaignId':_0x202f08['body'][_0xbb43('0x77')],'ContactId':_0x202f08[_0xbb43('0x44')][_0xbb43('0x61')]}})[_0xbb43('0x21')](handleEntityNotFound(_0xc9623,null))['then'](function(_0x3174ea){if(_0x3174ea){return _0x3174ea;}return null;})['then'](respondWithResult(_0xc9623,null))[_0xbb43('0x3f')](handleError(_0xc9623,null));};
\ No newline at end of file
+var _0xd382=['busyContacts','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','countContactsIvrCampaignHopperFinal','`state`\x20=\x2011\x20,\x201,\x20null','reCallContacts','answeringMachine','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','into','cm_hopper','fromQuery','phone','ContactId','ListId','VoiceQueueId','updatedAt','select','field','ANY_VALUE(calleridnum)','scheduledAt','ANY_VALUE(ContactId)','ANY_VALUE(VoiceQueueId)','NOW()','from','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','state','calleridnum\x20NOT\x20IN\x20(?)','calleridnum','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','CampaignId','createdAt','ANY_VALUE(ListId)','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','calleridnum\x20IS\x20NOT\x20NULL','CmHopper','findOne','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','ejs','lodash','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','apply','reject','update','then','destroy','error','stack','name','index','map','fieldName','type','key','query','keys','intersection','model','fields','attributes','length','nolimit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','CmHopperFinal','includeAll','include','findAll','rows','show','params','rawAttributes','find','describe','catch','uniqueid','body','sequelize','COUNT','literal','noSuchContacts','`state`\x20=\x203,\x201,\x20null','noAnswerContacts'];(function(_0x2d7f0e,_0x3e6fbd){var _0x110b07=function(_0x557b00){while(--_0x557b00){_0x2d7f0e['push'](_0x2d7f0e['shift']());}};_0x110b07(++_0x3e6fbd);}(_0xd382,0x1b6));var _0x2d38=function(_0x18d49f,_0x15211e){_0x18d49f=_0x18d49f-0x0;var _0x52086a=_0xd382[_0x18d49f];return _0x52086a;};'use strict';var pdf=require(_0x2d38('0x0'));var emlformat=require(_0x2d38('0x1'));var rimraf=require(_0x2d38('0x2'));var zipdir=require(_0x2d38('0x3'));var jsonpatch=require(_0x2d38('0x4'));var rp=require(_0x2d38('0x5'));var moment=require(_0x2d38('0x6'));var BPromise=require(_0x2d38('0x7'));var Mustache=require(_0x2d38('0x8'));var util=require(_0x2d38('0x9'));var path=require('path');var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x2d38('0xa'));var fs=require('fs');var _=require(_0x2d38('0xb'));var squel=require('squel');var crypto=require(_0x2d38('0xc'));var jsforce=require(_0x2d38('0xd'));var deskjs=require(_0x2d38('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x2d38('0xf'));var Redis=require(_0x2d38('0x10'));var authService=require(_0x2d38('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0x2d38('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x2d38('0x13'))(_0x2d38('0x14'));var utils=require(_0x2d38('0x15'));var config=require(_0x2d38('0x16'));var licenseUtil=require(_0x2d38('0x17'));var db=require(_0x2d38('0x18'))['db'];function respondWithStatusCode(_0x3c068b,_0x4ed69b){_0x4ed69b=_0x4ed69b||0xcc;return function(_0x3dd2c1){if(_0x3dd2c1){return _0x3c068b[_0x2d38('0x19')](_0x4ed69b);}return _0x3c068b[_0x2d38('0x1a')](_0x4ed69b)[_0x2d38('0x1b')]();};}function respondWithResult(_0x149ac2,_0x5cc0a4){_0x5cc0a4=_0x5cc0a4||0xc8;return function(_0x1c7c1d){if(_0x1c7c1d){return _0x149ac2[_0x2d38('0x1a')](_0x5cc0a4)[_0x2d38('0x1c')](_0x1c7c1d);}};}function respondWithFilteredResult(_0x1a2e74,_0x408141){return function(_0xf346b2){if(_0xf346b2){var _0xc6de5a=_0xf346b2[_0x2d38('0x1d')],_0x2d3cb1=_0x408141[_0x2d38('0x1e')],_0xc17f9e=_0x408141[_0x2d38('0x1e')]+_0x408141[_0x2d38('0x1f')],_0x6d2a9a;if(_0xc17f9e>=_0xc6de5a){_0xc17f9e=_0xc6de5a;_0x6d2a9a=0xc8;}else{_0x6d2a9a=0xce;}_0x1a2e74[_0x2d38('0x1a')](_0x6d2a9a);return _0x1a2e74[_0x2d38('0x20')]('Content-Range',_0x2d3cb1+'-'+_0xc17f9e+'/'+_0xc6de5a)[_0x2d38('0x1c')](_0xf346b2);}return null;};}function patchUpdates(_0x235fb6){return function(_0x508b8b){try{jsonpatch[_0x2d38('0x21')](_0x508b8b,_0x235fb6,!![]);}catch(_0x353874){return BPromise[_0x2d38('0x22')](_0x353874);}return _0x508b8b['save']();};}function saveUpdates(_0x46f8be,_0x5ed42e){return function(_0x4bdac6){if(_0x4bdac6){return _0x4bdac6[_0x2d38('0x23')](_0x46f8be)[_0x2d38('0x24')](function(_0x3713ea){return _0x3713ea;});}return null;};}function removeEntity(_0x3892a5,_0x19e658){return function(_0x3138bc){if(_0x3138bc){return _0x3138bc[_0x2d38('0x25')]()[_0x2d38('0x24')](function(){_0x3892a5[_0x2d38('0x1a')](0xcc)[_0x2d38('0x1b')]();});}};}function handleEntityNotFound(_0x584e1f,_0x3283b4){return function(_0x4826d1){if(!_0x4826d1){_0x584e1f[_0x2d38('0x19')](0x194);}return _0x4826d1;};}function handleError(_0x530fd9,_0x1e3d6a){_0x1e3d6a=_0x1e3d6a||0x1f4;return function(_0xfa9bd){logger[_0x2d38('0x26')](_0xfa9bd[_0x2d38('0x27')]);if(_0xfa9bd[_0x2d38('0x28')]){delete _0xfa9bd[_0x2d38('0x28')];}_0x530fd9[_0x2d38('0x1a')](_0x1e3d6a)['send'](_0xfa9bd);};}exports[_0x2d38('0x29')]=function(_0x3f0f7a,_0x34599a){var _0x3d18cd={},_0x346934={},_0xe73710={'count':0x0,'rows':[]};var _0x81299c=_[_0x2d38('0x2a')](db['CmHopperFinal']['rawAttributes'],function(_0x5570c2){return{'name':_0x5570c2[_0x2d38('0x2b')],'type':_0x5570c2[_0x2d38('0x2c')][_0x2d38('0x2d')]};});_0x346934['model']=_[_0x2d38('0x2a')](_0x81299c,'name');_0x346934[_0x2d38('0x2e')]=_[_0x2d38('0x2f')](_0x3f0f7a[_0x2d38('0x2e')]);_0x346934['filters']=_[_0x2d38('0x30')](_0x346934[_0x2d38('0x31')],_0x346934[_0x2d38('0x2e')]);_0x3d18cd['attributes']=_[_0x2d38('0x30')](_0x346934[_0x2d38('0x31')],qs[_0x2d38('0x32')](_0x3f0f7a[_0x2d38('0x2e')][_0x2d38('0x32')]));_0x3d18cd[_0x2d38('0x33')]=_0x3d18cd['attributes'][_0x2d38('0x34')]?_0x3d18cd[_0x2d38('0x33')]:_0x346934[_0x2d38('0x31')];if(!_0x3f0f7a[_0x2d38('0x2e')]['hasOwnProperty'](_0x2d38('0x35'))){_0x3d18cd[_0x2d38('0x1f')]=qs[_0x2d38('0x1f')](_0x3f0f7a[_0x2d38('0x2e')][_0x2d38('0x1f')]);_0x3d18cd[_0x2d38('0x1e')]=qs[_0x2d38('0x1e')](_0x3f0f7a[_0x2d38('0x2e')][_0x2d38('0x1e')]);}_0x3d18cd[_0x2d38('0x36')]=qs['sort'](_0x3f0f7a['query'][_0x2d38('0x37')]);_0x3d18cd[_0x2d38('0x38')]=qs[_0x2d38('0x39')](_[_0x2d38('0x3a')](_0x3f0f7a[_0x2d38('0x2e')],_0x346934[_0x2d38('0x39')]),_0x81299c);if(_0x3f0f7a[_0x2d38('0x2e')][_0x2d38('0x3b')]){_0x3d18cd[_0x2d38('0x38')]=_[_0x2d38('0x3c')](_0x3d18cd[_0x2d38('0x38')],{'$or':_[_0x2d38('0x2a')](_0x81299c,function(_0x11f5b8){if(_0x11f5b8['type']!==_0x2d38('0x3d')){var _0x1161b1={};_0x1161b1[_0x11f5b8[_0x2d38('0x28')]]={'$like':'%'+_0x3f0f7a[_0x2d38('0x2e')]['filter']+'%'};return _0x1161b1;}})});}_0x3d18cd=_[_0x2d38('0x3c')]({},_0x3d18cd,_0x3f0f7a[_0x2d38('0x3e')]);var _0x213b07={'where':_0x3d18cd[_0x2d38('0x38')]};return db[_0x2d38('0x3f')][_0x2d38('0x1d')](_0x213b07)[_0x2d38('0x24')](function(_0x1084a5){_0xe73710[_0x2d38('0x1d')]=_0x1084a5;if(_0x3f0f7a[_0x2d38('0x2e')][_0x2d38('0x40')]){_0x3d18cd[_0x2d38('0x41')]=[{'all':!![]}];}return db[_0x2d38('0x3f')][_0x2d38('0x42')](_0x3d18cd);})['then'](function(_0x234b9e){_0xe73710[_0x2d38('0x43')]=_0x234b9e;return _0xe73710;})['then'](respondWithFilteredResult(_0x34599a,_0x3d18cd))['catch'](handleError(_0x34599a,null));};exports[_0x2d38('0x44')]=function(_0x3e2631,_0x28110c){var _0x5b1469={'raw':!![],'where':{'id':_0x3e2631[_0x2d38('0x45')]['id']}},_0x6108f1={};_0x6108f1[_0x2d38('0x31')]=_['keys'](db['CmHopperFinal'][_0x2d38('0x46')]);_0x6108f1['query']=_[_0x2d38('0x2f')](_0x3e2631[_0x2d38('0x2e')]);_0x6108f1[_0x2d38('0x39')]=_['intersection'](_0x6108f1['model'],_0x6108f1[_0x2d38('0x2e')]);_0x5b1469[_0x2d38('0x33')]=_[_0x2d38('0x30')](_0x6108f1['model'],qs[_0x2d38('0x32')](_0x3e2631[_0x2d38('0x2e')][_0x2d38('0x32')]));_0x5b1469['attributes']=_0x5b1469[_0x2d38('0x33')][_0x2d38('0x34')]?_0x5b1469[_0x2d38('0x33')]:_0x6108f1['model'];if(_0x3e2631['query'][_0x2d38('0x40')]){_0x5b1469[_0x2d38('0x41')]=[{'all':!![]}];}_0x5b1469=_[_0x2d38('0x3c')]({},_0x5b1469,_0x3e2631[_0x2d38('0x3e')]);return db['CmHopperFinal'][_0x2d38('0x47')](_0x5b1469)[_0x2d38('0x24')](handleEntityNotFound(_0x28110c,null))[_0x2d38('0x24')](respondWithResult(_0x28110c,null))['catch'](handleError(_0x28110c,null));};exports[_0x2d38('0x48')]=function(_0x501637,_0x580d04){return db[_0x2d38('0x3f')][_0x2d38('0x48')]()[_0x2d38('0x24')](respondWithResult(_0x580d04,null))[_0x2d38('0x49')](handleError(_0x580d04,null));};exports['update']=function(_0x4c4c95,_0x132000){if(_0x4c4c95['body'][_0x2d38('0x4a')]){delete _0x4c4c95[_0x2d38('0x4b')][_0x2d38('0x4a')];}return db[_0x2d38('0x3f')][_0x2d38('0x47')]({'where':{'uniqueid':_0x4c4c95[_0x2d38('0x45')]['id']}})[_0x2d38('0x24')](handleEntityNotFound(_0x132000,null))[_0x2d38('0x24')](saveUpdates(_0x4c4c95[_0x2d38('0x4b')],null))['then'](respondWithResult(_0x132000,null))[_0x2d38('0x49')](handleError(_0x132000,null));};exports['countContactsQueueCampaignHopperFinal']=function(_0x260b6a,_0x14eec5,_0x582679){return db[_0x2d38('0x3f')][_0x2d38('0x42')]({'raw':![],'where':{'VoiceQueueId':_0x260b6a[_0x2d38('0x45')]['id']},'attributes':[[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db[_0x2d38('0x4c')]['fn']('IF',db[_0x2d38('0x4c')][_0x2d38('0x4e')]('`state`\x20=\x200,\x201,\x20null'))),_0x2d38('0x4f')],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db[_0x2d38('0x4c')]['fn']('IF',db[_0x2d38('0x4c')][_0x2d38('0x4e')](_0x2d38('0x50')))),_0x2d38('0x51')],[db[_0x2d38('0x4c')]['fn']('COUNT',db[_0x2d38('0x4c')]['fn']('IF',db[_0x2d38('0x4c')]['literal']('`state`\x20=\x205,\x201,\x20null'))),_0x2d38('0x52')],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db[_0x2d38('0x4c')]['fn']('IF',db['sequelize']['literal'](_0x2d38('0x53')))),_0x2d38('0x54')],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db[_0x2d38('0x4c')]['fn']('IF',db[_0x2d38('0x4c')][_0x2d38('0x4e')](_0x2d38('0x55')))),_0x2d38('0x56')],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db['sequelize']['fn']('IF',db[_0x2d38('0x4c')]['literal']('`state`\x20=\x2011\x20,\x201,\x20null'))),_0x2d38('0x57')],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db['sequelize']['fn']('IF',db['sequelize'][_0x2d38('0x4e')](_0x2d38('0x58')))),'reCallContacts'],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db[_0x2d38('0x4c')]['fn']('IF',db[_0x2d38('0x4c')][_0x2d38('0x4e')]('`state`\x20=\x2019,\x201,\x20null'))),'answeringMachine']]})[_0x2d38('0x24')](handleEntityNotFound(_0x14eec5,null))['then'](respondWithResult(_0x14eec5,null))[_0x2d38('0x49')](handleError(_0x14eec5,null));};exports[_0x2d38('0x59')]=function(_0x147a37,_0x227a95,_0x4fa858){return db[_0x2d38('0x3f')][_0x2d38('0x42')]({'raw':![],'where':{'CampaignId':_0x147a37['params']['id']},'attributes':[[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db['sequelize']['fn']('IF',db[_0x2d38('0x4c')]['literal']('`state`\x20=\x200,\x201,\x20null'))),_0x2d38('0x4f')],[db[_0x2d38('0x4c')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0x2d38('0x4c')]['literal'](_0x2d38('0x50')))),_0x2d38('0x51')],[db[_0x2d38('0x4c')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0x2d38('0x4c')][_0x2d38('0x4e')]('`state`\x20=\x205,\x201,\x20null'))),_0x2d38('0x52')],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db[_0x2d38('0x4c')]['fn']('IF',db[_0x2d38('0x4c')]['literal'](_0x2d38('0x53')))),'congestionContacts'],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db['sequelize']['fn']('IF',db['sequelize'][_0x2d38('0x4e')](_0x2d38('0x55')))),_0x2d38('0x56')],[db[_0x2d38('0x4c')]['fn']('COUNT',db[_0x2d38('0x4c')]['fn']('IF',db['sequelize']['literal'](_0x2d38('0x5a')))),_0x2d38('0x57')],[db[_0x2d38('0x4c')]['fn'](_0x2d38('0x4d'),db['sequelize']['fn']('IF',db[_0x2d38('0x4c')][_0x2d38('0x4e')](_0x2d38('0x58')))),_0x2d38('0x5b')],[db['sequelize']['fn']('COUNT',db['sequelize']['fn']('IF',db['sequelize']['literal']('`state`\x20=\x2019,\x201,\x20null'))),_0x2d38('0x5c')]]})[_0x2d38('0x24')](handleEntityNotFound(_0x227a95,null))[_0x2d38('0x24')](respondWithResult(_0x227a95,null))[_0x2d38('0x49')](handleError(_0x227a95,null));};exports[_0x2d38('0x5d')]=function(_0x4c8e78,_0x3781f5,_0x4229d7){return db[_0x2d38('0x5e')][_0x2d38('0x47')]({'where':{'id':_0x4c8e78['params']['id']}})[_0x2d38('0x24')](handleEntityNotFound(_0x3781f5,null))[_0x2d38('0x24')](function(_0x3f1115){var _0x116456;if(_0x3f1115){_0x116456=squel[_0x2d38('0x5f')]()[_0x2d38('0x60')](_0x2d38('0x61'))[_0x2d38('0x62')]([_0x2d38('0x63'),'scheduledAt',_0x2d38('0x64'),_0x2d38('0x65'),_0x2d38('0x66'),'createdAt',_0x2d38('0x67')],squel[_0x2d38('0x68')]()[_0x2d38('0x69')](_0x2d38('0x6a'),_0x2d38('0x63'))[_0x2d38('0x69')]('NOW()',_0x2d38('0x6b'))[_0x2d38('0x69')](_0x2d38('0x6c'),_0x2d38('0x64'))[_0x2d38('0x69')]('ANY_VALUE(ListId)',_0x2d38('0x65'))['field'](_0x2d38('0x6d'),'VoiceQueueId')[_0x2d38('0x69')](_0x2d38('0x6e'),'createdAt')[_0x2d38('0x69')](_0x2d38('0x6e'),_0x2d38('0x67'))[_0x2d38('0x6f')](_0x2d38('0x70'))[_0x2d38('0x38')](_0x2d38('0x71'),_0x4c8e78[_0x2d38('0x45')]['id'][_0x2d38('0x72')]())[_0x2d38('0x38')](_0x2d38('0x73'),_0x4c8e78[_0x2d38('0x4b')][_0x2d38('0x74')][_0x2d38('0x72')]())[_0x2d38('0x38')]('calleridnum\x20IS\x20NOT\x20NULL')[_0x2d38('0x38')](_0x2d38('0x75'),squel[_0x2d38('0x68')]()[_0x2d38('0x69')](_0x2d38('0x63'))[_0x2d38('0x6f')](_0x2d38('0x61'))[_0x2d38('0x38')](_0x2d38('0x71'),_0x4c8e78[_0x2d38('0x45')]['id'][_0x2d38('0x72')]()))[_0x2d38('0x38')](_0x2d38('0x75'),squel['select']()[_0x2d38('0x69')](_0x2d38('0x76'))[_0x2d38('0x6f')](_0x2d38('0x70'))[_0x2d38('0x38')](_0x2d38('0x71'),_0x4c8e78[_0x2d38('0x45')]['id'][_0x2d38('0x72')]())[_0x2d38('0x38')](_0x2d38('0x77')))[_0x2d38('0x78')]('ContactId'))['toString']();return db[_0x2d38('0x4c')][_0x2d38('0x2e')](_0x116456);}return[];})[_0x2d38('0x24')](respondWithResult(_0x3781f5,null))[_0x2d38('0x49')](handleError(_0x3781f5,null));};exports[_0x2d38('0x79')]=function(_0x29d723,_0x3e83aa,_0x15d1eb){return db['Campaign']['find']({'where':{'id':_0x29d723['params']['id']}})[_0x2d38('0x24')](handleEntityNotFound(_0x3e83aa,null))[_0x2d38('0x24')](function(_0x106893){var _0x42f42d;if(_0x106893){_0x42f42d=squel[_0x2d38('0x5f')]()[_0x2d38('0x60')](_0x2d38('0x61'))[_0x2d38('0x62')]([_0x2d38('0x63'),_0x2d38('0x6b'),'ContactId',_0x2d38('0x65'),_0x2d38('0x7a'),_0x2d38('0x7b'),'updatedAt'],squel['select']()['field'](_0x2d38('0x6a'),_0x2d38('0x63'))[_0x2d38('0x69')](_0x2d38('0x6e'),_0x2d38('0x6b'))[_0x2d38('0x69')]('ANY_VALUE(ContactId)','ContactId')[_0x2d38('0x69')](_0x2d38('0x7c'),'ListId')[_0x2d38('0x69')](_0x2d38('0x7d'),_0x2d38('0x7a'))[_0x2d38('0x69')](_0x2d38('0x6e'),'createdAt')[_0x2d38('0x69')]('NOW()',_0x2d38('0x67'))[_0x2d38('0x6f')]('cm_hopper_final')[_0x2d38('0x38')](_0x2d38('0x7e'),_0x29d723[_0x2d38('0x45')]['id'][_0x2d38('0x72')]())[_0x2d38('0x38')](_0x2d38('0x73'),_0x29d723[_0x2d38('0x4b')][_0x2d38('0x74')]['toString']())['where'](_0x2d38('0x7f'))[_0x2d38('0x38')](_0x2d38('0x75'),squel[_0x2d38('0x68')]()[_0x2d38('0x69')](_0x2d38('0x63'))[_0x2d38('0x6f')](_0x2d38('0x61'))[_0x2d38('0x38')](_0x2d38('0x7e'),_0x29d723[_0x2d38('0x45')]['id'][_0x2d38('0x72')]()))['where'](_0x2d38('0x75'),squel[_0x2d38('0x68')]()['field'](_0x2d38('0x76'))[_0x2d38('0x6f')](_0x2d38('0x70'))[_0x2d38('0x38')](_0x2d38('0x7e'),_0x29d723[_0x2d38('0x45')]['id'][_0x2d38('0x72')]())[_0x2d38('0x38')]('state\x20=\x204'))[_0x2d38('0x78')](_0x2d38('0x64')))[_0x2d38('0x72')]();return db[_0x2d38('0x4c')]['query'](_0x42f42d);}return[];})[_0x2d38('0x24')](respondWithResult(_0x3e83aa,null))['catch'](handleError(_0x3e83aa,null));};exports['checkContactHopper']=function(_0x3c61b2,_0xa95c76,_0x5eb21e){return db[_0x2d38('0x80')][_0x2d38('0x81')]({'where':{'VoiceQueueId':_0x3c61b2['body'][_0x2d38('0x66')],'CampaignId':_0x3c61b2['body'][_0x2d38('0x7a')],'ContactId':_0x3c61b2[_0x2d38('0x4b')][_0x2d38('0x64')]}})[_0x2d38('0x24')](handleEntityNotFound(_0xa95c76,null))['then'](function(_0x2bc90d){if(_0x2bc90d){return _0x2bc90d;}return null;})[_0x2d38('0x24')](respondWithResult(_0xa95c76,null))[_0x2d38('0x49')](handleError(_0xa95c76,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff