// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xe511=['../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','set','Content-Range','apply','reject','save','then','destroy','name','send','map','rawAttributes','fieldName','type','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','options','CmHopperFinal','count','includeAll','include','findAll','rows','catch','show','params','find','describe','update','uniqueid','body','countContactsQueueCampaignHopperFinal','sequelize','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','COUNT','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','busyContacts','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','`state`\x20=\x2019,\x201,\x20null','answeringMachine','countContactsIvrCampaignHopperFinal','`state`\x20=\x208,\x201,\x20null','congestionContacts','reCallContacts','VoiceQueue','insert','cm_hopper','scheduledAt','ListId','createdAt','select','field','phone','NOW()','ANY_VALUE(ContactId)','ContactId','VoiceQueueId','updatedAt','cm_hopper_final','VoiceQueueId\x20=\x20?','state\x20=\x20?','state','toString','calleridnum\x20NOT\x20IN\x20(?)','from','calleridnum','group','Campaign','into','CampaignId','ANY_VALUE(calleridnum)','CampaignId\x20=\x20?','calleridnum\x20IS\x20NOT\x20NULL','state\x20=\x204','CmHopper','findOne','html-pdf','eml-format','zip-dir','request-promise','moment','mustache','util','path','sox','ejs','fs-extra','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service'];(function(_0x3e5bc8,_0x457d89){var _0xfd84bc=function(_0x1a766c){while(--_0x1a766c){_0x3e5bc8['push'](_0x3e5bc8['shift']());}};_0xfd84bc(++_0x457d89);}(_0xe511,0x16f));var _0x1e51=function(_0x3fd603,_0x5f5b06){_0x3fd603=_0x3fd603-0x0;var _0x5026af=_0xe511[_0x3fd603];return _0x5026af;};'use strict';var pdf=require(_0x1e51('0x0'));var emlformat=require(_0x1e51('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x1e51('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x1e51('0x3'));var moment=require(_0x1e51('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x1e51('0x5'));var util=require(_0x1e51('0x6'));var path=require(_0x1e51('0x7'));var sox=require(_0x1e51('0x8'));var csv=require('to-csv');var ejs=require(_0x1e51('0x9'));var fs=require('fs');var fs_extra=require(_0x1e51('0xa'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x1e51('0xb'));var jsforce=require(_0x1e51('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x1e51('0xd'));var Papa=require(_0x1e51('0xe'));var Redis=require(_0x1e51('0xf'));var authService=require(_0x1e51('0x10'));var qs=require(_0x1e51('0x11'));var as=require(_0x1e51('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x1e51('0x13'))(_0x1e51('0x14'));var utils=require(_0x1e51('0x15'));var config=require(_0x1e51('0x16'));var licenseUtil=require(_0x1e51('0x17'));var db=require(_0x1e51('0x18'))['db'];function respondWithStatusCode(_0x5544eb,_0x408a77){_0x408a77=_0x408a77||0xcc;return function(_0x102f01){if(_0x102f01){return _0x5544eb[_0x1e51('0x19')](_0x408a77);}return _0x5544eb[_0x1e51('0x1a')](_0x408a77)[_0x1e51('0x1b')]();};}function respondWithResult(_0x32945d,_0x441c70){_0x441c70=_0x441c70||0xc8;return function(_0x467e77){if(_0x467e77){return _0x32945d[_0x1e51('0x1a')](_0x441c70)[_0x1e51('0x1c')](_0x467e77);}};}function respondWithFilteredResult(_0x5a5c07,_0x3b01b7){return function(_0x24db4f){if(_0x24db4f){var _0x4526b4=_0x24db4f['count'],_0x5857e2=_0x3b01b7[_0x1e51('0x1d')],_0xa3b410=_0x3b01b7[_0x1e51('0x1d')]+_0x3b01b7[_0x1e51('0x1e')],_0x4f7aaf;if(_0xa3b410>=_0x4526b4){_0xa3b410=_0x4526b4;_0x4f7aaf=0xc8;}else{_0x4f7aaf=0xce;}_0x5a5c07[_0x1e51('0x1a')](_0x4f7aaf);return _0x5a5c07[_0x1e51('0x1f')](_0x1e51('0x20'),_0x5857e2+'-'+_0xa3b410+'/'+_0x4526b4)['json'](_0x24db4f);}return null;};}function patchUpdates(_0x39449b){return function(_0x4a9272){try{jsonpatch[_0x1e51('0x21')](_0x4a9272,_0x39449b,!![]);}catch(_0x1cbd1c){return BPromise[_0x1e51('0x22')](_0x1cbd1c);}return _0x4a9272[_0x1e51('0x23')]();};}function saveUpdates(_0x506f40,_0x5223c3){return function(_0x4e6a49){if(_0x4e6a49){return _0x4e6a49['update'](_0x506f40)[_0x1e51('0x24')](function(_0x4f1f56){return _0x4f1f56;});}return null;};}function removeEntity(_0x3f7340,_0x28aacb){return function(_0x415154){if(_0x415154){return _0x415154[_0x1e51('0x25')]()[_0x1e51('0x24')](function(){_0x3f7340[_0x1e51('0x1a')](0xcc)[_0x1e51('0x1b')]();});}};}function handleEntityNotFound(_0x461d3d,_0x4bcdd3){return function(_0x4d04c0){if(!_0x4d04c0){_0x461d3d[_0x1e51('0x19')](0x194);}return _0x4d04c0;};}function handleError(_0xdf6c02,_0x2e42b1){_0x2e42b1=_0x2e42b1||0x1f4;return function(_0x1386db){logger['error'](_0x1386db['stack']);if(_0x1386db['name']){delete _0x1386db[_0x1e51('0x26')];}_0xdf6c02[_0x1e51('0x1a')](_0x2e42b1)[_0x1e51('0x27')](_0x1386db);};}exports['index']=function(_0x1e7a96,_0x49c507){var _0x5eccee={},_0x3349f0={},_0x5c5bbd={'count':0x0,'rows':[]};var _0x170ec6=_[_0x1e51('0x28')](db['CmHopperFinal'][_0x1e51('0x29')],function(_0x10ee23){return{'name':_0x10ee23[_0x1e51('0x2a')],'type':_0x10ee23[_0x1e51('0x2b')]['key']};});_0x3349f0['model']=_['map'](_0x170ec6,_0x1e51('0x26'));_0x3349f0[_0x1e51('0x2c')]=_[_0x1e51('0x2d')](_0x1e7a96[_0x1e51('0x2c')]);_0x3349f0[_0x1e51('0x2e')]=_[_0x1e51('0x2f')](_0x3349f0[_0x1e51('0x30')],_0x3349f0[_0x1e51('0x2c')]);_0x5eccee[_0x1e51('0x31')]=_[_0x1e51('0x2f')](_0x3349f0[_0x1e51('0x30')],qs['fields'](_0x1e7a96[_0x1e51('0x2c')][_0x1e51('0x32')]));_0x5eccee[_0x1e51('0x31')]=_0x5eccee[_0x1e51('0x31')][_0x1e51('0x33')]?_0x5eccee['attributes']:_0x3349f0[_0x1e51('0x30')];if(!_0x1e7a96['query'][_0x1e51('0x34')](_0x1e51('0x35'))){_0x5eccee[_0x1e51('0x1e')]=qs['limit'](_0x1e7a96[_0x1e51('0x2c')]['limit']);_0x5eccee[_0x1e51('0x1d')]=qs['offset'](_0x1e7a96['query'][_0x1e51('0x1d')]);}_0x5eccee[_0x1e51('0x36')]=qs[_0x1e51('0x37')](_0x1e7a96['query'][_0x1e51('0x37')]);_0x5eccee['where']=qs[_0x1e51('0x2e')](_[_0x1e51('0x38')](_0x1e7a96['query'],_0x3349f0[_0x1e51('0x2e')]),_0x170ec6);if(_0x1e7a96[_0x1e51('0x2c')][_0x1e51('0x39')]){_0x5eccee[_0x1e51('0x3a')]=_[_0x1e51('0x3b')](_0x5eccee[_0x1e51('0x3a')],{'$or':_['map'](_0x170ec6,function(_0x509f7d){if(_0x509f7d[_0x1e51('0x2b')]!=='VIRTUAL'){var _0x3c6c35={};_0x3c6c35[_0x509f7d[_0x1e51('0x26')]]={'$like':'%'+_0x1e7a96[_0x1e51('0x2c')][_0x1e51('0x39')]+'%'};return _0x3c6c35;}})});}_0x5eccee=_[_0x1e51('0x3b')]({},_0x5eccee,_0x1e7a96[_0x1e51('0x3c')]);var _0x845a62={'where':_0x5eccee[_0x1e51('0x3a')]};return db[_0x1e51('0x3d')][_0x1e51('0x3e')](_0x845a62)[_0x1e51('0x24')](function(_0x5360b3){_0x5c5bbd[_0x1e51('0x3e')]=_0x5360b3;if(_0x1e7a96['query'][_0x1e51('0x3f')]){_0x5eccee[_0x1e51('0x40')]=[{'all':!![]}];}return db[_0x1e51('0x3d')][_0x1e51('0x41')](_0x5eccee);})[_0x1e51('0x24')](function(_0x2f8fd9){_0x5c5bbd[_0x1e51('0x42')]=_0x2f8fd9;return _0x5c5bbd;})[_0x1e51('0x24')](respondWithFilteredResult(_0x49c507,_0x5eccee))[_0x1e51('0x43')](handleError(_0x49c507,null));};exports[_0x1e51('0x44')]=function(_0xc40fce,_0x5b4b3f){var _0x56cb66={'raw':!![],'where':{'id':_0xc40fce[_0x1e51('0x45')]['id']}},_0x13da51={};_0x13da51[_0x1e51('0x30')]=_[_0x1e51('0x2d')](db[_0x1e51('0x3d')][_0x1e51('0x29')]);_0x13da51[_0x1e51('0x2c')]=_[_0x1e51('0x2d')](_0xc40fce['query']);_0x13da51[_0x1e51('0x2e')]=_[_0x1e51('0x2f')](_0x13da51[_0x1e51('0x30')],_0x13da51[_0x1e51('0x2c')]);_0x56cb66[_0x1e51('0x31')]=_[_0x1e51('0x2f')](_0x13da51[_0x1e51('0x30')],qs['fields'](_0xc40fce[_0x1e51('0x2c')][_0x1e51('0x32')]));_0x56cb66['attributes']=_0x56cb66[_0x1e51('0x31')][_0x1e51('0x33')]?_0x56cb66[_0x1e51('0x31')]:_0x13da51['model'];if(_0xc40fce[_0x1e51('0x2c')][_0x1e51('0x3f')]){_0x56cb66[_0x1e51('0x40')]=[{'all':!![]}];}_0x56cb66=_[_0x1e51('0x3b')]({},_0x56cb66,_0xc40fce[_0x1e51('0x3c')]);return db[_0x1e51('0x3d')][_0x1e51('0x46')](_0x56cb66)[_0x1e51('0x24')](handleEntityNotFound(_0x5b4b3f,null))[_0x1e51('0x24')](respondWithResult(_0x5b4b3f,null))['catch'](handleError(_0x5b4b3f,null));};exports[_0x1e51('0x47')]=function(_0x22a898,_0x4b5fa7){return db[_0x1e51('0x3d')][_0x1e51('0x47')]()[_0x1e51('0x24')](respondWithResult(_0x4b5fa7,null))['catch'](handleError(_0x4b5fa7,null));};exports[_0x1e51('0x48')]=function(_0x4634de,_0x29233c){if(_0x4634de['body'][_0x1e51('0x49')]){delete _0x4634de['body']['uniqueid'];}return db['CmHopperFinal'][_0x1e51('0x46')]({'where':{'uniqueid':_0x4634de[_0x1e51('0x45')]['id']}})['then'](handleEntityNotFound(_0x29233c,null))['then'](saveUpdates(_0x4634de[_0x1e51('0x4a')],null))[_0x1e51('0x24')](respondWithResult(_0x29233c,null))[_0x1e51('0x43')](handleError(_0x29233c,null));};exports[_0x1e51('0x4b')]=function(_0xf3377b,_0x54ce36,_0x4bb11f){return db[_0x1e51('0x3d')]['findAll']({'raw':![],'where':{'VoiceQueueId':_0xf3377b[_0x1e51('0x45')]['id']},'attributes':[[db[_0x1e51('0x4c')]['fn']('COUNT',db['sequelize']['fn']('IF',db['sequelize'][_0x1e51('0x4d')](_0x1e51('0x4e')))),_0x1e51('0x4f')],[db['sequelize']['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db[_0x1e51('0x4c')][_0x1e51('0x4d')](_0x1e51('0x51')))),_0x1e51('0x52')],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db['sequelize']['fn']('IF',db[_0x1e51('0x4c')][_0x1e51('0x4d')](_0x1e51('0x53')))),_0x1e51('0x54')],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db['sequelize']['fn']('IF',db[_0x1e51('0x4c')]['literal']('`state`\x20=\x208,\x201,\x20null'))),'congestionContacts'],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db['sequelize'][_0x1e51('0x4d')](_0x1e51('0x55')))),_0x1e51('0x56')],[db['sequelize']['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db[_0x1e51('0x4c')]['literal'](_0x1e51('0x57')))),_0x1e51('0x58')],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db[_0x1e51('0x4c')][_0x1e51('0x4d')](_0x1e51('0x59')))),'reCallContacts'],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db['sequelize']['fn']('IF',db['sequelize']['literal'](_0x1e51('0x5a')))),_0x1e51('0x5b')]]})[_0x1e51('0x24')](handleEntityNotFound(_0x54ce36,null))[_0x1e51('0x24')](respondWithResult(_0x54ce36,null))[_0x1e51('0x43')](handleError(_0x54ce36,null));};exports[_0x1e51('0x5c')]=function(_0x45b649,_0x31fe87,_0x8ba6f4){return db['CmHopperFinal']['findAll']({'raw':![],'where':{'CampaignId':_0x45b649['params']['id']},'attributes':[[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db['sequelize']['fn']('IF',db['sequelize'][_0x1e51('0x4d')](_0x1e51('0x4e')))),'noSuchContacts'],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db[_0x1e51('0x4c')][_0x1e51('0x4d')](_0x1e51('0x51')))),_0x1e51('0x52')],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db['sequelize'][_0x1e51('0x4d')](_0x1e51('0x53')))),_0x1e51('0x54')],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db['sequelize']['literal'](_0x1e51('0x5d')))),_0x1e51('0x5e')],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db['sequelize']['fn']('IF',db['sequelize']['literal'](_0x1e51('0x55')))),_0x1e51('0x56')],[db[_0x1e51('0x4c')]['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db['sequelize'][_0x1e51('0x4d')](_0x1e51('0x57')))),_0x1e51('0x58')],[db['sequelize']['fn'](_0x1e51('0x50'),db[_0x1e51('0x4c')]['fn']('IF',db[_0x1e51('0x4c')]['literal'](_0x1e51('0x59')))),_0x1e51('0x5f')],[db['sequelize']['fn']('COUNT',db[_0x1e51('0x4c')]['fn']('IF',db['sequelize'][_0x1e51('0x4d')]('`state`\x20=\x2019,\x201,\x20null'))),_0x1e51('0x5b')]]})[_0x1e51('0x24')](handleEntityNotFound(_0x31fe87,null))[_0x1e51('0x24')](respondWithResult(_0x31fe87,null))[_0x1e51('0x43')](handleError(_0x31fe87,null));};exports['moveContactsQueueCampaignHopperFinal']=function(_0x37f3e6,_0x4c9871,_0x5eaa16){return db[_0x1e51('0x60')][_0x1e51('0x46')]({'where':{'id':_0x37f3e6[_0x1e51('0x45')]['id']}})['then'](handleEntityNotFound(_0x4c9871,null))[_0x1e51('0x24')](function(_0x25ce1d){var _0x15f15b;if(_0x25ce1d){_0x15f15b=squel[_0x1e51('0x61')]()['into'](_0x1e51('0x62'))['fromQuery'](['phone',_0x1e51('0x63'),'ContactId',_0x1e51('0x64'),'VoiceQueueId',_0x1e51('0x65'),'updatedAt'],squel[_0x1e51('0x66')]()[_0x1e51('0x67')]('ANY_VALUE(calleridnum)',_0x1e51('0x68'))['field'](_0x1e51('0x69'),_0x1e51('0x63'))[_0x1e51('0x67')](_0x1e51('0x6a'),_0x1e51('0x6b'))[_0x1e51('0x67')]('ANY_VALUE(ListId)',_0x1e51('0x64'))['field']('ANY_VALUE(VoiceQueueId)',_0x1e51('0x6c'))[_0x1e51('0x67')](_0x1e51('0x69'),_0x1e51('0x65'))[_0x1e51('0x67')](_0x1e51('0x69'),_0x1e51('0x6d'))['from'](_0x1e51('0x6e'))[_0x1e51('0x3a')](_0x1e51('0x6f'),_0x37f3e6['params']['id']['toString']())[_0x1e51('0x3a')](_0x1e51('0x70'),_0x37f3e6['body'][_0x1e51('0x71')][_0x1e51('0x72')]())['where']('calleridnum\x20IS\x20NOT\x20NULL')[_0x1e51('0x3a')](_0x1e51('0x73'),squel[_0x1e51('0x66')]()[_0x1e51('0x67')](_0x1e51('0x68'))[_0x1e51('0x74')](_0x1e51('0x62'))['where']('VoiceQueueId\x20=\x20?',_0x37f3e6[_0x1e51('0x45')]['id'][_0x1e51('0x72')]()))['where'](_0x1e51('0x73'),squel[_0x1e51('0x66')]()['field'](_0x1e51('0x75'))['from'](_0x1e51('0x6e'))['where']('VoiceQueueId\x20=\x20?',_0x37f3e6['params']['id']['toString']())['where']('state\x20=\x204'))[_0x1e51('0x76')]('ContactId'))[_0x1e51('0x72')]();return db['sequelize'][_0x1e51('0x2c')](_0x15f15b);}return[];})[_0x1e51('0x24')](respondWithResult(_0x4c9871,null))[_0x1e51('0x43')](handleError(_0x4c9871,null));};exports['moveContactsIvrCampaignHopperFinal']=function(_0x30336b,_0x3ed4b1,_0x4a2b44){return db[_0x1e51('0x77')]['find']({'where':{'id':_0x30336b[_0x1e51('0x45')]['id']}})['then'](handleEntityNotFound(_0x3ed4b1,null))[_0x1e51('0x24')](function(_0x42318c){var _0x2d5062;if(_0x42318c){_0x2d5062=squel[_0x1e51('0x61')]()[_0x1e51('0x78')](_0x1e51('0x62'))['fromQuery']([_0x1e51('0x68'),'scheduledAt',_0x1e51('0x6b'),_0x1e51('0x64'),_0x1e51('0x79'),_0x1e51('0x65'),'updatedAt'],squel['select']()['field'](_0x1e51('0x7a'),_0x1e51('0x68'))[_0x1e51('0x67')](_0x1e51('0x69'),'scheduledAt')[_0x1e51('0x67')]('ANY_VALUE(ContactId)',_0x1e51('0x6b'))['field']('ANY_VALUE(ListId)',_0x1e51('0x64'))[_0x1e51('0x67')]('ANY_VALUE(CampaignId)',_0x1e51('0x79'))['field'](_0x1e51('0x69'),'createdAt')[_0x1e51('0x67')](_0x1e51('0x69'),'updatedAt')[_0x1e51('0x74')]('cm_hopper_final')[_0x1e51('0x3a')](_0x1e51('0x7b'),_0x30336b[_0x1e51('0x45')]['id'][_0x1e51('0x72')]())['where'](_0x1e51('0x70'),_0x30336b[_0x1e51('0x4a')][_0x1e51('0x71')]['toString']())['where'](_0x1e51('0x7c'))[_0x1e51('0x3a')](_0x1e51('0x73'),squel['select']()['field']('phone')[_0x1e51('0x74')](_0x1e51('0x62'))[_0x1e51('0x3a')]('CampaignId\x20=\x20?',_0x30336b[_0x1e51('0x45')]['id'][_0x1e51('0x72')]()))['where'](_0x1e51('0x73'),squel[_0x1e51('0x66')]()[_0x1e51('0x67')]('calleridnum')[_0x1e51('0x74')]('cm_hopper_final')[_0x1e51('0x3a')](_0x1e51('0x7b'),_0x30336b[_0x1e51('0x45')]['id'][_0x1e51('0x72')]())[_0x1e51('0x3a')](_0x1e51('0x7d')))[_0x1e51('0x76')](_0x1e51('0x6b')))[_0x1e51('0x72')]();return db['sequelize'][_0x1e51('0x2c')](_0x2d5062);}return[];})['then'](respondWithResult(_0x3ed4b1,null))[_0x1e51('0x43')](handleError(_0x3ed4b1,null));};exports['checkContactHopper']=function(_0x4042f4,_0x2b4b7c,_0xe92e54){return db[_0x1e51('0x7e')][_0x1e51('0x7f')]({'where':{'VoiceQueueId':_0x4042f4[_0x1e51('0x4a')][_0x1e51('0x6c')],'CampaignId':_0x4042f4[_0x1e51('0x4a')][_0x1e51('0x79')],'ContactId':_0x4042f4['body'][_0x1e51('0x6b')]}})[_0x1e51('0x24')](handleEntityNotFound(_0x2b4b7c,null))[_0x1e51('0x24')](function(_0x4bcc13){if(_0x4bcc13){return _0x4bcc13;}return null;})[_0x1e51('0x24')](respondWithResult(_0x2b4b7c,null))[_0x1e51('0x43')](handleError(_0x2b4b7c,null));};
\ No newline at end of file
+var _0x76dc=['crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','limit','set','json','apply','save','update','then','destroy','error','stack','name','send','index','map','CmHopperFinal','type','key','query','keys','filters','model','attributes','intersection','length','hasOwnProperty','order','sort','where','pick','filter','merge','count','includeAll','include','findAll','rows','rawAttributes','options','find','catch','describe','body','uniqueid','params','countContactsQueueCampaignHopperFinal','sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','noAnswerContacts','`state`\x20=\x208,\x201,\x20null','dropContacts','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','reCallContacts','`state`\x20=\x2019,\x201,\x20null','answeringMachine','countContactsIvrCampaignHopperFinal','`state`\x20=\x203,\x201,\x20null','`state`\x20=\x205,\x201,\x20null','busyContacts','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','`state`\x20=\x2011\x20,\x201,\x20null','moveContactsQueueCampaignHopperFinal','into','cm_hopper','phone','ContactId','ListId','createdAt','updatedAt','field','ANY_VALUE(calleridnum)','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ANY_VALUE(VoiceQueueId)','VoiceQueueId','from','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','select','calleridnum','state\x20=\x204','moveContactsIvrCampaignHopperFinal','insert','fromQuery','scheduledAt','CampaignId','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','checkContactHopper','CmHopper','findOne','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','mustache','sox','to-csv','ejs'];(function(_0x3be49e,_0x37a7be){var _0x5e82b0=function(_0x1e67ed){while(--_0x1e67ed){_0x3be49e['push'](_0x3be49e['shift']());}};_0x5e82b0(++_0x37a7be);}(_0x76dc,0x1f2));var _0xc76d=function(_0x1f8207,_0x23e21b){_0x1f8207=_0x1f8207-0x0;var _0x3ed36f=_0x76dc[_0x1f8207];return _0x3ed36f;};'use strict';var pdf=require(_0xc76d('0x0'));var emlformat=require(_0xc76d('0x1'));var rimraf=require(_0xc76d('0x2'));var zipdir=require(_0xc76d('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0xc76d('0x4'));var moment=require(_0xc76d('0x5'));var BPromise=require('bluebird');var Mustache=require(_0xc76d('0x6'));var util=require('util');var path=require('path');var sox=require(_0xc76d('0x7'));var csv=require(_0xc76d('0x8'));var ejs=require(_0xc76d('0x9'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0xc76d('0xa'));var jsforce=require(_0xc76d('0xb'));var deskjs=require(_0xc76d('0xc'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xc76d('0xd'));var Redis=require(_0xc76d('0xe'));var authService=require('../../components/auth/service');var qs=require(_0xc76d('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xc76d('0x10'));var logger=require(_0xc76d('0x11'))(_0xc76d('0x12'));var utils=require(_0xc76d('0x13'));var config=require(_0xc76d('0x14'));var licenseUtil=require(_0xc76d('0x15'));var db=require(_0xc76d('0x16'))['db'];function respondWithStatusCode(_0x2e02e9,_0x1722b3){_0x1722b3=_0x1722b3||0xcc;return function(_0x311814){if(_0x311814){return _0x2e02e9[_0xc76d('0x17')](_0x1722b3);}return _0x2e02e9[_0xc76d('0x18')](_0x1722b3)[_0xc76d('0x19')]();};}function respondWithResult(_0x3ed1bd,_0x5cda20){_0x5cda20=_0x5cda20||0xc8;return function(_0x8696db){if(_0x8696db){return _0x3ed1bd[_0xc76d('0x18')](_0x5cda20)['json'](_0x8696db);}};}function respondWithFilteredResult(_0x4741a4,_0x2d23d2){return function(_0x47a4ee){if(_0x47a4ee){var _0x6f94e=_0x47a4ee['count'],_0x5c680c=_0x2d23d2[_0xc76d('0x1a')],_0x32e0a8=_0x2d23d2[_0xc76d('0x1a')]+_0x2d23d2[_0xc76d('0x1b')],_0x5d881c;if(_0x32e0a8>=_0x6f94e){_0x32e0a8=_0x6f94e;_0x5d881c=0xc8;}else{_0x5d881c=0xce;}_0x4741a4[_0xc76d('0x18')](_0x5d881c);return _0x4741a4[_0xc76d('0x1c')]('Content-Range',_0x5c680c+'-'+_0x32e0a8+'/'+_0x6f94e)[_0xc76d('0x1d')](_0x47a4ee);}return null;};}function patchUpdates(_0x361f42){return function(_0xa0c5b6){try{jsonpatch[_0xc76d('0x1e')](_0xa0c5b6,_0x361f42,!![]);}catch(_0x2181dd){return BPromise['reject'](_0x2181dd);}return _0xa0c5b6[_0xc76d('0x1f')]();};}function saveUpdates(_0x324db7,_0x5dffde){return function(_0x455371){if(_0x455371){return _0x455371[_0xc76d('0x20')](_0x324db7)[_0xc76d('0x21')](function(_0xb89876){return _0xb89876;});}return null;};}function removeEntity(_0x18f546,_0x3d357b){return function(_0x42b89c){if(_0x42b89c){return _0x42b89c[_0xc76d('0x22')]()[_0xc76d('0x21')](function(){_0x18f546[_0xc76d('0x18')](0xcc)[_0xc76d('0x19')]();});}};}function handleEntityNotFound(_0x5de11f,_0x11b42f){return function(_0x17b46f){if(!_0x17b46f){_0x5de11f['sendStatus'](0x194);}return _0x17b46f;};}function handleError(_0x637d68,_0x2f194b){_0x2f194b=_0x2f194b||0x1f4;return function(_0x55ca79){logger[_0xc76d('0x23')](_0x55ca79[_0xc76d('0x24')]);if(_0x55ca79[_0xc76d('0x25')]){delete _0x55ca79[_0xc76d('0x25')];}_0x637d68[_0xc76d('0x18')](_0x2f194b)[_0xc76d('0x26')](_0x55ca79);};}exports[_0xc76d('0x27')]=function(_0x59ebd1,_0x59dabf){var _0x285430={},_0x287ae4={},_0x5069ea={'count':0x0,'rows':[]};var _0x31501a=_[_0xc76d('0x28')](db[_0xc76d('0x29')]['rawAttributes'],function(_0x2039f4){return{'name':_0x2039f4['fieldName'],'type':_0x2039f4[_0xc76d('0x2a')][_0xc76d('0x2b')]};});_0x287ae4['model']=_[_0xc76d('0x28')](_0x31501a,_0xc76d('0x25'));_0x287ae4[_0xc76d('0x2c')]=_[_0xc76d('0x2d')](_0x59ebd1['query']);_0x287ae4[_0xc76d('0x2e')]=_['intersection'](_0x287ae4[_0xc76d('0x2f')],_0x287ae4['query']);_0x285430[_0xc76d('0x30')]=_[_0xc76d('0x31')](_0x287ae4['model'],qs['fields'](_0x59ebd1['query']['fields']));_0x285430[_0xc76d('0x30')]=_0x285430[_0xc76d('0x30')][_0xc76d('0x32')]?_0x285430[_0xc76d('0x30')]:_0x287ae4[_0xc76d('0x2f')];if(!_0x59ebd1['query'][_0xc76d('0x33')]('nolimit')){_0x285430[_0xc76d('0x1b')]=qs['limit'](_0x59ebd1[_0xc76d('0x2c')][_0xc76d('0x1b')]);_0x285430[_0xc76d('0x1a')]=qs[_0xc76d('0x1a')](_0x59ebd1[_0xc76d('0x2c')]['offset']);}_0x285430[_0xc76d('0x34')]=qs[_0xc76d('0x35')](_0x59ebd1[_0xc76d('0x2c')]['sort']);_0x285430[_0xc76d('0x36')]=qs[_0xc76d('0x2e')](_[_0xc76d('0x37')](_0x59ebd1['query'],_0x287ae4[_0xc76d('0x2e')]),_0x31501a);if(_0x59ebd1[_0xc76d('0x2c')][_0xc76d('0x38')]){_0x285430[_0xc76d('0x36')]=_[_0xc76d('0x39')](_0x285430[_0xc76d('0x36')],{'$or':_['map'](_0x31501a,function(_0x518945){if(_0x518945[_0xc76d('0x2a')]!=='VIRTUAL'){var _0xc7a140={};_0xc7a140[_0x518945[_0xc76d('0x25')]]={'$like':'%'+_0x59ebd1[_0xc76d('0x2c')][_0xc76d('0x38')]+'%'};return _0xc7a140;}})});}_0x285430=_['merge']({},_0x285430,_0x59ebd1['options']);var _0xc907eb={'where':_0x285430[_0xc76d('0x36')]};return db[_0xc76d('0x29')][_0xc76d('0x3a')](_0xc907eb)[_0xc76d('0x21')](function(_0x58c724){_0x5069ea[_0xc76d('0x3a')]=_0x58c724;if(_0x59ebd1[_0xc76d('0x2c')][_0xc76d('0x3b')]){_0x285430[_0xc76d('0x3c')]=[{'all':!![]}];}return db[_0xc76d('0x29')][_0xc76d('0x3d')](_0x285430);})[_0xc76d('0x21')](function(_0x341094){_0x5069ea[_0xc76d('0x3e')]=_0x341094;return _0x5069ea;})[_0xc76d('0x21')](respondWithFilteredResult(_0x59dabf,_0x285430))['catch'](handleError(_0x59dabf,null));};exports['show']=function(_0x1123a2,_0x2a0759){var _0x1e5118={'raw':!![],'where':{'id':_0x1123a2['params']['id']}},_0x27bdff={};_0x27bdff['model']=_[_0xc76d('0x2d')](db[_0xc76d('0x29')][_0xc76d('0x3f')]);_0x27bdff[_0xc76d('0x2c')]=_[_0xc76d('0x2d')](_0x1123a2[_0xc76d('0x2c')]);_0x27bdff[_0xc76d('0x2e')]=_[_0xc76d('0x31')](_0x27bdff['model'],_0x27bdff[_0xc76d('0x2c')]);_0x1e5118[_0xc76d('0x30')]=_[_0xc76d('0x31')](_0x27bdff[_0xc76d('0x2f')],qs['fields'](_0x1123a2['query']['fields']));_0x1e5118['attributes']=_0x1e5118['attributes']['length']?_0x1e5118['attributes']:_0x27bdff[_0xc76d('0x2f')];if(_0x1123a2[_0xc76d('0x2c')][_0xc76d('0x3b')]){_0x1e5118[_0xc76d('0x3c')]=[{'all':!![]}];}_0x1e5118=_[_0xc76d('0x39')]({},_0x1e5118,_0x1123a2[_0xc76d('0x40')]);return db[_0xc76d('0x29')][_0xc76d('0x41')](_0x1e5118)['then'](handleEntityNotFound(_0x2a0759,null))[_0xc76d('0x21')](respondWithResult(_0x2a0759,null))[_0xc76d('0x42')](handleError(_0x2a0759,null));};exports[_0xc76d('0x43')]=function(_0x387661,_0xb9cca2){return db[_0xc76d('0x29')][_0xc76d('0x43')]()[_0xc76d('0x21')](respondWithResult(_0xb9cca2,null))[_0xc76d('0x42')](handleError(_0xb9cca2,null));};exports['update']=function(_0x5b41d3,_0x144d09){if(_0x5b41d3[_0xc76d('0x44')][_0xc76d('0x45')]){delete _0x5b41d3[_0xc76d('0x44')][_0xc76d('0x45')];}return db['CmHopperFinal'][_0xc76d('0x41')]({'where':{'uniqueid':_0x5b41d3[_0xc76d('0x46')]['id']}})['then'](handleEntityNotFound(_0x144d09,null))['then'](saveUpdates(_0x5b41d3[_0xc76d('0x44')],null))[_0xc76d('0x21')](respondWithResult(_0x144d09,null))['catch'](handleError(_0x144d09,null));};exports[_0xc76d('0x47')]=function(_0x2d267e,_0x8a7363,_0x23f4c8){return db[_0xc76d('0x29')][_0xc76d('0x3d')]({'raw':![],'where':{'VoiceQueueId':_0x2d267e[_0xc76d('0x46')]['id']},'attributes':[[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db['sequelize'][_0xc76d('0x4a')](_0xc76d('0x4b')))),_0xc76d('0x4c')],[db['sequelize']['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db['sequelize'][_0xc76d('0x4a')]('`state`\x20=\x203,\x201,\x20null'))),_0xc76d('0x4d')],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')]['literal']('`state`\x20=\x205,\x201,\x20null'))),'busyContacts'],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')][_0xc76d('0x4a')](_0xc76d('0x4e')))),'congestionContacts'],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')][_0xc76d('0x4a')]('`state`\x20=\x2010\x20,\x201,\x20null'))),_0xc76d('0x4f')],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')][_0xc76d('0x4a')]('`state`\x20=\x2011\x20,\x201,\x20null'))),_0xc76d('0x50')],[db[_0xc76d('0x48')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0xc76d('0x48')]['literal'](_0xc76d('0x51')))),_0xc76d('0x52')],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')][_0xc76d('0x4a')](_0xc76d('0x53')))),_0xc76d('0x54')]]})[_0xc76d('0x21')](handleEntityNotFound(_0x8a7363,null))[_0xc76d('0x21')](respondWithResult(_0x8a7363,null))[_0xc76d('0x42')](handleError(_0x8a7363,null));};exports[_0xc76d('0x55')]=function(_0x3afeb6,_0x4cd7bf,_0x3054e0){return db[_0xc76d('0x29')][_0xc76d('0x3d')]({'raw':![],'where':{'CampaignId':_0x3afeb6[_0xc76d('0x46')]['id']},'attributes':[[db[_0xc76d('0x48')]['fn']('COUNT',db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')]['literal']('`state`\x20=\x200,\x201,\x20null'))),'noSuchContacts'],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')][_0xc76d('0x4a')](_0xc76d('0x56')))),_0xc76d('0x4d')],[db[_0xc76d('0x48')]['fn']('COUNT',db[_0xc76d('0x48')]['fn']('IF',db['sequelize']['literal'](_0xc76d('0x57')))),_0xc76d('0x58')],[db[_0xc76d('0x48')]['fn']('COUNT',db[_0xc76d('0x48')]['fn']('IF',db['sequelize']['literal']('`state`\x20=\x208,\x201,\x20null'))),_0xc76d('0x59')],[db[_0xc76d('0x48')]['fn']('COUNT',db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')][_0xc76d('0x4a')](_0xc76d('0x5a')))),_0xc76d('0x4f')],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db['sequelize']['fn']('IF',db['sequelize']['literal'](_0xc76d('0x5b')))),_0xc76d('0x50')],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db['sequelize'][_0xc76d('0x4a')](_0xc76d('0x51')))),_0xc76d('0x52')],[db[_0xc76d('0x48')]['fn'](_0xc76d('0x49'),db[_0xc76d('0x48')]['fn']('IF',db[_0xc76d('0x48')][_0xc76d('0x4a')]('`state`\x20=\x2019,\x201,\x20null'))),_0xc76d('0x54')]]})['then'](handleEntityNotFound(_0x4cd7bf,null))[_0xc76d('0x21')](respondWithResult(_0x4cd7bf,null))[_0xc76d('0x42')](handleError(_0x4cd7bf,null));};exports[_0xc76d('0x5c')]=function(_0x55dd93,_0x58c3ce,_0xec4a50){return db['VoiceQueue']['find']({'where':{'id':_0x55dd93[_0xc76d('0x46')]['id']}})[_0xc76d('0x21')](handleEntityNotFound(_0x58c3ce,null))['then'](function(_0x483044){var _0x1062ea;if(_0x483044){_0x1062ea=squel['insert']()[_0xc76d('0x5d')](_0xc76d('0x5e'))['fromQuery']([_0xc76d('0x5f'),'scheduledAt',_0xc76d('0x60'),_0xc76d('0x61'),'VoiceQueueId',_0xc76d('0x62'),_0xc76d('0x63')],squel['select']()[_0xc76d('0x64')](_0xc76d('0x65'),_0xc76d('0x5f'))['field'](_0xc76d('0x66'),'scheduledAt')['field'](_0xc76d('0x67'),_0xc76d('0x60'))['field'](_0xc76d('0x68'),_0xc76d('0x61'))[_0xc76d('0x64')](_0xc76d('0x69'),_0xc76d('0x6a'))[_0xc76d('0x64')](_0xc76d('0x66'),_0xc76d('0x62'))[_0xc76d('0x64')](_0xc76d('0x66'),_0xc76d('0x63'))[_0xc76d('0x6b')](_0xc76d('0x6c'))[_0xc76d('0x36')](_0xc76d('0x6d'),_0x55dd93[_0xc76d('0x46')]['id'][_0xc76d('0x6e')]())[_0xc76d('0x36')](_0xc76d('0x6f'),_0x55dd93[_0xc76d('0x44')]['state'][_0xc76d('0x6e')]())[_0xc76d('0x36')](_0xc76d('0x70'))[_0xc76d('0x36')](_0xc76d('0x71'),squel[_0xc76d('0x72')]()[_0xc76d('0x64')](_0xc76d('0x5f'))[_0xc76d('0x6b')](_0xc76d('0x5e'))[_0xc76d('0x36')](_0xc76d('0x6d'),_0x55dd93[_0xc76d('0x46')]['id'][_0xc76d('0x6e')]()))[_0xc76d('0x36')](_0xc76d('0x71'),squel[_0xc76d('0x72')]()[_0xc76d('0x64')](_0xc76d('0x73'))[_0xc76d('0x6b')](_0xc76d('0x6c'))[_0xc76d('0x36')](_0xc76d('0x6d'),_0x55dd93[_0xc76d('0x46')]['id']['toString']())[_0xc76d('0x36')](_0xc76d('0x74')))['group'](_0xc76d('0x60')))[_0xc76d('0x6e')]();return db['sequelize'][_0xc76d('0x2c')](_0x1062ea);}return[];})[_0xc76d('0x21')](respondWithResult(_0x58c3ce,null))[_0xc76d('0x42')](handleError(_0x58c3ce,null));};exports[_0xc76d('0x75')]=function(_0xecd280,_0x39823d,_0x114167){return db['Campaign']['find']({'where':{'id':_0xecd280[_0xc76d('0x46')]['id']}})[_0xc76d('0x21')](handleEntityNotFound(_0x39823d,null))['then'](function(_0x19bc63){var _0x84ee86;if(_0x19bc63){_0x84ee86=squel[_0xc76d('0x76')]()[_0xc76d('0x5d')](_0xc76d('0x5e'))[_0xc76d('0x77')]([_0xc76d('0x5f'),_0xc76d('0x78'),_0xc76d('0x60'),_0xc76d('0x61'),_0xc76d('0x79'),_0xc76d('0x62'),_0xc76d('0x63')],squel[_0xc76d('0x72')]()[_0xc76d('0x64')](_0xc76d('0x65'),_0xc76d('0x5f'))[_0xc76d('0x64')](_0xc76d('0x66'),_0xc76d('0x78'))['field'](_0xc76d('0x67'),'ContactId')[_0xc76d('0x64')](_0xc76d('0x68'),_0xc76d('0x61'))[_0xc76d('0x64')](_0xc76d('0x7a'),'CampaignId')[_0xc76d('0x64')]('NOW()',_0xc76d('0x62'))[_0xc76d('0x64')](_0xc76d('0x66'),_0xc76d('0x63'))[_0xc76d('0x6b')]('cm_hopper_final')['where'](_0xc76d('0x7b'),_0xecd280[_0xc76d('0x46')]['id']['toString']())['where'](_0xc76d('0x6f'),_0xecd280[_0xc76d('0x44')]['state'][_0xc76d('0x6e')]())['where'](_0xc76d('0x70'))['where'](_0xc76d('0x71'),squel[_0xc76d('0x72')]()[_0xc76d('0x64')](_0xc76d('0x5f'))[_0xc76d('0x6b')](_0xc76d('0x5e'))[_0xc76d('0x36')](_0xc76d('0x7b'),_0xecd280[_0xc76d('0x46')]['id'][_0xc76d('0x6e')]()))[_0xc76d('0x36')](_0xc76d('0x71'),squel[_0xc76d('0x72')]()[_0xc76d('0x64')]('calleridnum')[_0xc76d('0x6b')](_0xc76d('0x6c'))[_0xc76d('0x36')](_0xc76d('0x7b'),_0xecd280[_0xc76d('0x46')]['id'][_0xc76d('0x6e')]())['where'](_0xc76d('0x74')))['group'](_0xc76d('0x60')))[_0xc76d('0x6e')]();return db[_0xc76d('0x48')]['query'](_0x84ee86);}return[];})['then'](respondWithResult(_0x39823d,null))[_0xc76d('0x42')](handleError(_0x39823d,null));};exports[_0xc76d('0x7c')]=function(_0x1f87e8,_0x42addf,_0x2445d2){return db[_0xc76d('0x7d')][_0xc76d('0x7e')]({'where':{'VoiceQueueId':_0x1f87e8[_0xc76d('0x44')][_0xc76d('0x6a')],'CampaignId':_0x1f87e8[_0xc76d('0x44')][_0xc76d('0x79')],'ContactId':_0x1f87e8[_0xc76d('0x44')]['ContactId']}})[_0xc76d('0x21')](handleEntityNotFound(_0x42addf,null))['then'](function(_0x25fc4b){if(_0x25fc4b){return _0x25fc4b;}return null;})['then'](respondWithResult(_0x42addf,null))[_0xc76d('0x42')](handleError(_0x42addf,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff