18 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));};
git://repos.xcallymotion.com / motion2.git / blob