// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x8823=['abandonedContacts','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','VoiceQueueId','select','field','ANY_VALUE(calleridnum)','ANY_VALUE(ContactId)','ANY_VALUE(VoiceQueueId)','from','cm_hopper_final','toString','calleridnum\x20NOT\x20IN\x20(?)','VoiceQueueId\x20=\x20?','calleridnum','group','moveContactsIvrCampaignHopperFinal','Campaign','insert','CampaignId','createdAt','updatedAt','NOW()','ANY_VALUE(ListId)','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','state\x20=\x20?','state','state\x20=\x204','checkContactHopper','findOne','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','error','name','send','index','CmHopperFinal','rawAttributes','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','map','options','includeAll','include','findAll','catch','params','keys','find','describe','uniqueid','body','countContactsQueueCampaignHopperFinal','sequelize','literal','noSuchContacts','COUNT','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','busyContacts','`state`\x20=\x208,\x201,\x20null','`state`\x20=\x2010\x20,\x201,\x20null','`state`\x20=\x2011\x20,\x201,\x20null','`state`\x20=\x2022,\x201,\x20null','reCallContacts','`state`\x20=\x2019,\x201,\x20null','countContactsIvrCampaignHopperFinal','`state`\x20=\x200,\x201,\x20null','congestionContacts'];(function(_0x18feb3,_0x1b9d62){var _0x16e7a0=function(_0x3cb24b){while(--_0x3cb24b){_0x18feb3['push'](_0x18feb3['shift']());}};_0x16e7a0(++_0x1b9d62);}(_0x8823,0x1a7));var _0x3882=function(_0x642029,_0xb900a){_0x642029=_0x642029-0x0;var _0x22596f=_0x8823[_0x642029];return _0x22596f;};'use strict';var emlformat=require(_0x3882('0x0'));var rimraf=require(_0x3882('0x1'));var zipdir=require(_0x3882('0x2'));var jsonpatch=require(_0x3882('0x3'));var rp=require(_0x3882('0x4'));var moment=require(_0x3882('0x5'));var BPromise=require(_0x3882('0x6'));var Mustache=require(_0x3882('0x7'));var util=require(_0x3882('0x8'));var path=require(_0x3882('0x9'));var sox=require('sox');var csv=require(_0x3882('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x3882('0xb'));var _=require(_0x3882('0xc'));var squel=require(_0x3882('0xd'));var crypto=require(_0x3882('0xe'));var jsforce=require(_0x3882('0xf'));var deskjs=require(_0x3882('0x10'));var toCsv=require(_0x3882('0xa'));var querystring=require('querystring');var Papa=require(_0x3882('0x11'));var Redis=require(_0x3882('0x12'));var authService=require(_0x3882('0x13'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x3882('0x14'));var logger=require(_0x3882('0x15'))(_0x3882('0x16'));var utils=require(_0x3882('0x17'));var config=require('../../config/environment');var licenseUtil=require(_0x3882('0x18'));var db=require(_0x3882('0x19'))['db'];function respondWithStatusCode(_0x44a11a,_0x7e961f){_0x7e961f=_0x7e961f||0xcc;return function(_0x1e8899){if(_0x1e8899){return _0x44a11a[_0x3882('0x1a')](_0x7e961f);}return _0x44a11a['status'](_0x7e961f)[_0x3882('0x1b')]();};}function respondWithResult(_0x48ae05,_0x3eb909){_0x3eb909=_0x3eb909||0xc8;return function(_0x5148ee){if(_0x5148ee){return _0x48ae05[_0x3882('0x1c')](_0x3eb909)[_0x3882('0x1d')](_0x5148ee);}};}function respondWithFilteredResult(_0x39759b,_0xb710ae){return function(_0x5c9360){if(_0x5c9360){var _0x5cc328=typeof _0xb710ae[_0x3882('0x1e')]===_0x3882('0x1f')&&typeof _0xb710ae[_0x3882('0x20')]===_0x3882('0x1f');var _0x1d0e82=_0x5c9360[_0x3882('0x21')];var _0x15b081=_0x5cc328?0x0:_0xb710ae['offset'];var _0x3b04a3=_0x5cc328?_0x5c9360[_0x3882('0x21')]:_0xb710ae[_0x3882('0x1e')]+_0xb710ae[_0x3882('0x20')];var _0x1c503b;if(_0x3b04a3>=_0x1d0e82){_0x3b04a3=_0x1d0e82;_0x1c503b=0xc8;}else{_0x1c503b=0xce;}_0x39759b[_0x3882('0x1c')](_0x1c503b);return _0x39759b[_0x3882('0x22')](_0x3882('0x23'),_0x15b081+'-'+_0x3b04a3+'/'+_0x1d0e82)[_0x3882('0x1d')](_0x5c9360);}return null;};}function patchUpdates(_0x11b44b){return function(_0x511f03){try{jsonpatch[_0x3882('0x24')](_0x511f03,_0x11b44b,!![]);}catch(_0x4a927f){return BPromise[_0x3882('0x25')](_0x4a927f);}return _0x511f03[_0x3882('0x26')]();};}function saveUpdates(_0x66d924,_0x2b2ee6){return function(_0x4bf028){if(_0x4bf028){return _0x4bf028[_0x3882('0x27')](_0x66d924)[_0x3882('0x28')](function(_0xab8685){return _0xab8685;});}return null;};}function removeEntity(_0x1324bc,_0x2a53eb){return function(_0x42dedf){if(_0x42dedf){return _0x42dedf['destroy']()[_0x3882('0x28')](function(){_0x1324bc[_0x3882('0x1c')](0xcc)[_0x3882('0x1b')]();});}};}function handleEntityNotFound(_0x2536e0,_0xcc1ed4){return function(_0x1f614c){if(!_0x1f614c){_0x2536e0[_0x3882('0x1a')](0x194);}return _0x1f614c;};}function handleError(_0x3ed29d,_0x398e1c){_0x398e1c=_0x398e1c||0x1f4;return function(_0x240e44){logger[_0x3882('0x29')](_0x240e44['stack']);if(_0x240e44[_0x3882('0x2a')]){delete _0x240e44[_0x3882('0x2a')];}_0x3ed29d[_0x3882('0x1c')](_0x398e1c)[_0x3882('0x2b')](_0x240e44);};}exports[_0x3882('0x2c')]=function(_0x10666c,_0x1ac2b1){var _0xfb78b0={},_0x1e3f07={},_0x17b03b={'count':0x0,'rows':[]};var _0x2fd99f=_['map'](db[_0x3882('0x2d')][_0x3882('0x2e')],function(_0x5d94e0){return{'name':_0x5d94e0['fieldName'],'type':_0x5d94e0[_0x3882('0x2f')][_0x3882('0x30')]};});_0x1e3f07[_0x3882('0x31')]=_['map'](_0x2fd99f,_0x3882('0x2a'));_0x1e3f07[_0x3882('0x32')]=_['keys'](_0x10666c['query']);_0x1e3f07[_0x3882('0x33')]=_[_0x3882('0x34')](_0x1e3f07['model'],_0x1e3f07[_0x3882('0x32')]);_0xfb78b0[_0x3882('0x35')]=_[_0x3882('0x34')](_0x1e3f07['model'],qs[_0x3882('0x36')](_0x10666c['query'][_0x3882('0x36')]));_0xfb78b0[_0x3882('0x35')]=_0xfb78b0[_0x3882('0x35')][_0x3882('0x37')]?_0xfb78b0[_0x3882('0x35')]:_0x1e3f07[_0x3882('0x31')];if(!_0x10666c['query'][_0x3882('0x38')](_0x3882('0x39'))){_0xfb78b0[_0x3882('0x20')]=qs['limit'](_0x10666c[_0x3882('0x32')][_0x3882('0x20')]);_0xfb78b0[_0x3882('0x1e')]=qs[_0x3882('0x1e')](_0x10666c[_0x3882('0x32')]['offset']);}_0xfb78b0[_0x3882('0x3a')]=qs[_0x3882('0x3b')](_0x10666c[_0x3882('0x32')][_0x3882('0x3b')]);_0xfb78b0[_0x3882('0x3c')]=qs[_0x3882('0x33')](_['pick'](_0x10666c[_0x3882('0x32')],_0x1e3f07['filters']),_0x2fd99f);if(_0x10666c[_0x3882('0x32')][_0x3882('0x3d')]){_0xfb78b0['where']=_[_0x3882('0x3e')](_0xfb78b0[_0x3882('0x3c')],{'$or':_[_0x3882('0x3f')](_0x2fd99f,function(_0x174435){if(_0x174435[_0x3882('0x2f')]!=='VIRTUAL'){var _0x475273={};_0x475273[_0x174435[_0x3882('0x2a')]]={'$like':'%'+_0x10666c[_0x3882('0x32')][_0x3882('0x3d')]+'%'};return _0x475273;}})});}_0xfb78b0=_[_0x3882('0x3e')]({},_0xfb78b0,_0x10666c[_0x3882('0x40')]);var _0x585c86={'where':_0xfb78b0[_0x3882('0x3c')]};return db['CmHopperFinal'][_0x3882('0x21')](_0x585c86)[_0x3882('0x28')](function(_0x294b1b){_0x17b03b[_0x3882('0x21')]=_0x294b1b;if(_0x10666c['query'][_0x3882('0x41')]){_0xfb78b0[_0x3882('0x42')]=[{'all':!![]}];}return db[_0x3882('0x2d')][_0x3882('0x43')](_0xfb78b0);})['then'](function(_0x2ad751){_0x17b03b['rows']=_0x2ad751;return _0x17b03b;})[_0x3882('0x28')](respondWithFilteredResult(_0x1ac2b1,_0xfb78b0))[_0x3882('0x44')](handleError(_0x1ac2b1,null));};exports['show']=function(_0x5a5079,_0x120d27){var _0x172dc2={'raw':!![],'where':{'id':_0x5a5079[_0x3882('0x45')]['id']}},_0x127210={};_0x127210[_0x3882('0x31')]=_[_0x3882('0x46')](db[_0x3882('0x2d')]['rawAttributes']);_0x127210[_0x3882('0x32')]=_[_0x3882('0x46')](_0x5a5079['query']);_0x127210[_0x3882('0x33')]=_['intersection'](_0x127210[_0x3882('0x31')],_0x127210[_0x3882('0x32')]);_0x172dc2[_0x3882('0x35')]=_[_0x3882('0x34')](_0x127210['model'],qs[_0x3882('0x36')](_0x5a5079[_0x3882('0x32')][_0x3882('0x36')]));_0x172dc2[_0x3882('0x35')]=_0x172dc2[_0x3882('0x35')][_0x3882('0x37')]?_0x172dc2[_0x3882('0x35')]:_0x127210[_0x3882('0x31')];if(_0x5a5079[_0x3882('0x32')][_0x3882('0x41')]){_0x172dc2['include']=[{'all':!![]}];}_0x172dc2=_[_0x3882('0x3e')]({},_0x172dc2,_0x5a5079[_0x3882('0x40')]);return db[_0x3882('0x2d')][_0x3882('0x47')](_0x172dc2)['then'](handleEntityNotFound(_0x120d27,null))[_0x3882('0x28')](respondWithResult(_0x120d27,null))['catch'](handleError(_0x120d27,null));};exports[_0x3882('0x48')]=function(_0x47dd3b,_0x3da7bd){return db['CmHopperFinal']['describe']()[_0x3882('0x28')](respondWithResult(_0x3da7bd,null))[_0x3882('0x44')](handleError(_0x3da7bd,null));};exports[_0x3882('0x27')]=function(_0x5873f6,_0x301596){if(_0x5873f6['body'][_0x3882('0x49')]){delete _0x5873f6[_0x3882('0x4a')][_0x3882('0x49')];}return db['CmHopperFinal'][_0x3882('0x47')]({'where':{'uniqueid':_0x5873f6['params']['id']}})['then'](handleEntityNotFound(_0x301596,null))[_0x3882('0x28')](saveUpdates(_0x5873f6[_0x3882('0x4a')],null))[_0x3882('0x28')](respondWithResult(_0x301596,null))[_0x3882('0x44')](handleError(_0x301596,null));};exports[_0x3882('0x4b')]=function(_0x3cfcbf,_0x221b26,_0x1421d1){return db['CmHopperFinal'][_0x3882('0x43')]({'raw':![],'where':{'VoiceQueueId':_0x3cfcbf[_0x3882('0x45')]['id']},'attributes':[[db['sequelize']['fn']('COUNT',db[_0x3882('0x4c')]['fn']('IF',db['sequelize'][_0x3882('0x4d')]('`state`\x20=\x200,\x201,\x20null'))),_0x3882('0x4e')],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db['sequelize']['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')](_0x3882('0x50')))),_0x3882('0x51')],[db[_0x3882('0x4c')]['fn']('COUNT',db[_0x3882('0x4c')]['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')](_0x3882('0x52')))),_0x3882('0x53')],[db[_0x3882('0x4c')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0x3882('0x4c')]['literal'](_0x3882('0x54')))),'congestionContacts'],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db[_0x3882('0x4c')]['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')](_0x3882('0x55')))),'dropContacts'],[db['sequelize']['fn']('COUNT',db['sequelize']['fn']('IF',db['sequelize'][_0x3882('0x4d')](_0x3882('0x56')))),'abandonedContacts'],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db[_0x3882('0x4c')]['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')](_0x3882('0x57')))),_0x3882('0x58')],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db['sequelize']['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')](_0x3882('0x59')))),'answeringMachine']]})[_0x3882('0x28')](handleEntityNotFound(_0x221b26,null))[_0x3882('0x28')](respondWithResult(_0x221b26,null))[_0x3882('0x44')](handleError(_0x221b26,null));};exports[_0x3882('0x5a')]=function(_0x455edb,_0x521855,_0x4fb38b){return db[_0x3882('0x2d')]['findAll']({'raw':![],'where':{'CampaignId':_0x455edb[_0x3882('0x45')]['id']},'attributes':[[db[_0x3882('0x4c')]['fn']('COUNT',db[_0x3882('0x4c')]['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')](_0x3882('0x5b')))),_0x3882('0x4e')],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db['sequelize']['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')](_0x3882('0x50')))),_0x3882('0x51')],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db[_0x3882('0x4c')]['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')]('`state`\x20=\x205,\x201,\x20null'))),_0x3882('0x53')],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db[_0x3882('0x4c')]['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')]('`state`\x20=\x208,\x201,\x20null'))),_0x3882('0x5c')],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db['sequelize']['fn']('IF',db[_0x3882('0x4c')]['literal'](_0x3882('0x55')))),'dropContacts'],[db['sequelize']['fn'](_0x3882('0x4f'),db['sequelize']['fn']('IF',db[_0x3882('0x4c')]['literal']('`state`\x20=\x2011\x20,\x201,\x20null'))),_0x3882('0x5d')],[db[_0x3882('0x4c')]['fn']('COUNT',db[_0x3882('0x4c')]['fn']('IF',db[_0x3882('0x4c')]['literal']('`state`\x20=\x2022,\x201,\x20null'))),_0x3882('0x58')],[db[_0x3882('0x4c')]['fn'](_0x3882('0x4f'),db[_0x3882('0x4c')]['fn']('IF',db[_0x3882('0x4c')][_0x3882('0x4d')](_0x3882('0x59')))),'answeringMachine']]})[_0x3882('0x28')](handleEntityNotFound(_0x521855,null))[_0x3882('0x28')](respondWithResult(_0x521855,null))[_0x3882('0x44')](handleError(_0x521855,null));};exports['moveContactsQueueCampaignHopperFinal']=function(_0x2722c6,_0x57f454,_0x3b58e3){return db['VoiceQueue'][_0x3882('0x47')]({'where':{'id':_0x2722c6[_0x3882('0x45')]['id']}})[_0x3882('0x28')](handleEntityNotFound(_0x57f454,null))[_0x3882('0x28')](function(_0x495189){var _0x2d73cd;if(_0x495189){_0x2d73cd=squel['insert']()[_0x3882('0x5e')](_0x3882('0x5f'))[_0x3882('0x60')]([_0x3882('0x61'),_0x3882('0x62'),_0x3882('0x63'),_0x3882('0x64'),_0x3882('0x65'),'createdAt','updatedAt'],squel[_0x3882('0x66')]()[_0x3882('0x67')](_0x3882('0x68'),_0x3882('0x61'))[_0x3882('0x67')]('NOW()',_0x3882('0x62'))['field'](_0x3882('0x69'),_0x3882('0x63'))[_0x3882('0x67')]('ANY_VALUE(ListId)',_0x3882('0x64'))[_0x3882('0x67')](_0x3882('0x6a'),_0x3882('0x65'))[_0x3882('0x67')]('NOW()','createdAt')[_0x3882('0x67')]('NOW()','updatedAt')[_0x3882('0x6b')](_0x3882('0x6c'))['where']('VoiceQueueId\x20=\x20?',_0x2722c6['params']['id'][_0x3882('0x6d')]())[_0x3882('0x3c')]('state\x20=\x20?',_0x2722c6[_0x3882('0x4a')]['state'][_0x3882('0x6d')]())['where']('calleridnum\x20IS\x20NOT\x20NULL')[_0x3882('0x3c')](_0x3882('0x6e'),squel['select']()[_0x3882('0x67')](_0x3882('0x61'))[_0x3882('0x6b')]('cm_hopper')[_0x3882('0x3c')](_0x3882('0x6f'),_0x2722c6[_0x3882('0x45')]['id'][_0x3882('0x6d')]()))[_0x3882('0x3c')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x3882('0x66')]()[_0x3882('0x67')](_0x3882('0x70'))[_0x3882('0x6b')](_0x3882('0x6c'))[_0x3882('0x3c')](_0x3882('0x6f'),_0x2722c6[_0x3882('0x45')]['id']['toString']())[_0x3882('0x3c')]('state\x20=\x204'))[_0x3882('0x71')](_0x3882('0x63')))[_0x3882('0x6d')]();return db['sequelize'][_0x3882('0x32')](_0x2d73cd);}return[];})[_0x3882('0x28')](respondWithResult(_0x57f454,null))[_0x3882('0x44')](handleError(_0x57f454,null));};exports[_0x3882('0x72')]=function(_0xd93fe4,_0xcf8bd0,_0x1a41a1){return db[_0x3882('0x73')]['find']({'where':{'id':_0xd93fe4['params']['id']}})['then'](handleEntityNotFound(_0xcf8bd0,null))[_0x3882('0x28')](function(_0x40f59c){var _0x551693;if(_0x40f59c){_0x551693=squel[_0x3882('0x74')]()[_0x3882('0x5e')](_0x3882('0x5f'))[_0x3882('0x60')]([_0x3882('0x61'),_0x3882('0x62'),'ContactId',_0x3882('0x64'),_0x3882('0x75'),_0x3882('0x76'),_0x3882('0x77')],squel[_0x3882('0x66')]()['field'](_0x3882('0x68'),'phone')['field'](_0x3882('0x78'),_0x3882('0x62'))[_0x3882('0x67')](_0x3882('0x69'),_0x3882('0x63'))[_0x3882('0x67')](_0x3882('0x79'),_0x3882('0x64'))[_0x3882('0x67')](_0x3882('0x7a'),_0x3882('0x75'))['field']('NOW()',_0x3882('0x76'))[_0x3882('0x67')](_0x3882('0x78'),_0x3882('0x77'))[_0x3882('0x6b')](_0x3882('0x6c'))['where'](_0x3882('0x7b'),_0xd93fe4['params']['id'][_0x3882('0x6d')]())['where'](_0x3882('0x7c'),_0xd93fe4[_0x3882('0x4a')][_0x3882('0x7d')]['toString']())[_0x3882('0x3c')]('calleridnum\x20IS\x20NOT\x20NULL')[_0x3882('0x3c')](_0x3882('0x6e'),squel[_0x3882('0x66')]()['field']('phone')[_0x3882('0x6b')](_0x3882('0x5f'))[_0x3882('0x3c')]('CampaignId\x20=\x20?',_0xd93fe4[_0x3882('0x45')]['id']['toString']()))[_0x3882('0x3c')](_0x3882('0x6e'),squel[_0x3882('0x66')]()[_0x3882('0x67')]('calleridnum')[_0x3882('0x6b')](_0x3882('0x6c'))[_0x3882('0x3c')](_0x3882('0x7b'),_0xd93fe4[_0x3882('0x45')]['id'][_0x3882('0x6d')]())[_0x3882('0x3c')](_0x3882('0x7e')))[_0x3882('0x71')](_0x3882('0x63')))[_0x3882('0x6d')]();return db[_0x3882('0x4c')][_0x3882('0x32')](_0x551693);}return[];})[_0x3882('0x28')](respondWithResult(_0xcf8bd0,null))[_0x3882('0x44')](handleError(_0xcf8bd0,null));};exports[_0x3882('0x7f')]=function(_0x4ddd62,_0x1c6011,_0x706b54){return db['CmHopper'][_0x3882('0x80')]({'where':{'VoiceQueueId':_0x4ddd62[_0x3882('0x4a')][_0x3882('0x65')],'CampaignId':_0x4ddd62[_0x3882('0x4a')][_0x3882('0x75')],'ContactId':_0x4ddd62[_0x3882('0x4a')][_0x3882('0x63')]}})[_0x3882('0x28')](handleEntityNotFound(_0x1c6011,null))[_0x3882('0x28')](function(_0x1a5ebb){if(_0x1a5ebb){return _0x1a5ebb;}return null;})[_0x3882('0x28')](respondWithResult(_0x1c6011,null))['catch'](handleError(_0x1c6011,null));};
\ No newline at end of file
+var _0xada1=['sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','busyContacts','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','`state`\x20=\x2022,\x201,\x20null','abandonedContacts','reCallContacts','`state`\x20=\x2019,\x201,\x20null','answeringMachine','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','fromQuery','scheduledAt','ContactId','VoiceQueueId','ANY_VALUE(calleridnum)','field','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ListId','ANY_VALUE(VoiceQueueId)','createdAt','updatedAt','from','cm_hopper_final','toString','state\x20=\x20?','state','calleridnum\x20IS\x20NOT\x20NULL','select','phone','cm_hopper','VoiceQueueId\x20=\x20?','calleridnum\x20NOT\x20IN\x20(?)','calleridnum','state\x20=\x204','group','moveContactsIvrCampaignHopperFinal','Campaign','into','ANY_VALUE(CampaignId)','CampaignId','CampaignId\x20=\x20?','checkContactHopper','findOne','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','sox','ejs','fs-extra','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','status','end','json','offset','undefined','limit','count','Content-Range','apply','reject','save','then','destroy','sendStatus','error','stack','name','send','index','map','CmHopperFinal','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','attributes','length','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','params','include','find','describe','update','body','uniqueid','countContactsQueueCampaignHopperFinal'];(function(_0x1203f,_0x554bbc){var _0x365f0a=function(_0x3531d0){while(--_0x3531d0){_0x1203f['push'](_0x1203f['shift']());}};_0x365f0a(++_0x554bbc);}(_0xada1,0x1c4));var _0x1ada=function(_0x2dadb9,_0x42cfe6){_0x2dadb9=_0x2dadb9-0x0;var _0x2f0097=_0xada1[_0x2dadb9];return _0x2f0097;};'use strict';var emlformat=require(_0x1ada('0x0'));var rimraf=require(_0x1ada('0x1'));var zipdir=require(_0x1ada('0x2'));var jsonpatch=require(_0x1ada('0x3'));var rp=require('request-promise');var moment=require(_0x1ada('0x4'));var BPromise=require(_0x1ada('0x5'));var Mustache=require(_0x1ada('0x6'));var util=require('util');var path=require(_0x1ada('0x7'));var sox=require(_0x1ada('0x8'));var csv=require('to-csv');var ejs=require(_0x1ada('0x9'));var fs=require('fs');var fs_extra=require(_0x1ada('0xa'));var _=require('lodash');var squel=require(_0x1ada('0xb'));var crypto=require('crypto');var jsforce=require(_0x1ada('0xc'));var deskjs=require(_0x1ada('0xd'));var toCsv=require('to-csv');var querystring=require(_0x1ada('0xe'));var Papa=require(_0x1ada('0xf'));var Redis=require('ioredis');var authService=require(_0x1ada('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x1ada('0x11'));var logger=require('../../config/logger')(_0x1ada('0x12'));var utils=require(_0x1ada('0x13'));var config=require('../../config/environment');var licenseUtil=require(_0x1ada('0x14'));var db=require(_0x1ada('0x15'))['db'];function respondWithStatusCode(_0x365d5e,_0x4aff68){_0x4aff68=_0x4aff68||0xcc;return function(_0x7223df){if(_0x7223df){return _0x365d5e['sendStatus'](_0x4aff68);}return _0x365d5e[_0x1ada('0x16')](_0x4aff68)[_0x1ada('0x17')]();};}function respondWithResult(_0x6652d7,_0x4a0ce6){_0x4a0ce6=_0x4a0ce6||0xc8;return function(_0x2933c2){if(_0x2933c2){return _0x6652d7[_0x1ada('0x16')](_0x4a0ce6)[_0x1ada('0x18')](_0x2933c2);}};}function respondWithFilteredResult(_0x42e946,_0xf672fa){return function(_0x4fdb3f){if(_0x4fdb3f){var _0x5abf7c=typeof _0xf672fa[_0x1ada('0x19')]===_0x1ada('0x1a')&&typeof _0xf672fa[_0x1ada('0x1b')]==='undefined';var _0x2a2532=_0x4fdb3f[_0x1ada('0x1c')];var _0x2a3e1f=_0x5abf7c?0x0:_0xf672fa['offset'];var _0x22e389=_0x5abf7c?_0x4fdb3f[_0x1ada('0x1c')]:_0xf672fa[_0x1ada('0x19')]+_0xf672fa[_0x1ada('0x1b')];var _0x322512;if(_0x22e389>=_0x2a2532){_0x22e389=_0x2a2532;_0x322512=0xc8;}else{_0x322512=0xce;}_0x42e946[_0x1ada('0x16')](_0x322512);return _0x42e946['set'](_0x1ada('0x1d'),_0x2a3e1f+'-'+_0x22e389+'/'+_0x2a2532)['json'](_0x4fdb3f);}return null;};}function patchUpdates(_0xfcf0b7){return function(_0x3d7d40){try{jsonpatch[_0x1ada('0x1e')](_0x3d7d40,_0xfcf0b7,!![]);}catch(_0x5cf1e5){return BPromise[_0x1ada('0x1f')](_0x5cf1e5);}return _0x3d7d40[_0x1ada('0x20')]();};}function saveUpdates(_0x344cc6,_0x3ab50c){return function(_0x120581){if(_0x120581){return _0x120581['update'](_0x344cc6)[_0x1ada('0x21')](function(_0x2910cf){return _0x2910cf;});}return null;};}function removeEntity(_0x2a29bd,_0x2b6b40){return function(_0x547270){if(_0x547270){return _0x547270[_0x1ada('0x22')]()[_0x1ada('0x21')](function(){_0x2a29bd[_0x1ada('0x16')](0xcc)['end']();});}};}function handleEntityNotFound(_0x23877f,_0x28856c){return function(_0x22d374){if(!_0x22d374){_0x23877f[_0x1ada('0x23')](0x194);}return _0x22d374;};}function handleError(_0x1a821c,_0x18d299){_0x18d299=_0x18d299||0x1f4;return function(_0x39d7da){logger[_0x1ada('0x24')](_0x39d7da[_0x1ada('0x25')]);if(_0x39d7da[_0x1ada('0x26')]){delete _0x39d7da[_0x1ada('0x26')];}_0x1a821c['status'](_0x18d299)[_0x1ada('0x27')](_0x39d7da);};}exports[_0x1ada('0x28')]=function(_0x33188b,_0x2984d1){var _0x3bc5f4={},_0x29268b={},_0x505f53={'count':0x0,'rows':[]};var _0x3261cb=_[_0x1ada('0x29')](db[_0x1ada('0x2a')][_0x1ada('0x2b')],function(_0x482b2e){return{'name':_0x482b2e[_0x1ada('0x2c')],'type':_0x482b2e[_0x1ada('0x2d')]['key']};});_0x29268b[_0x1ada('0x2e')]=_['map'](_0x3261cb,_0x1ada('0x26'));_0x29268b[_0x1ada('0x2f')]=_[_0x1ada('0x30')](_0x33188b[_0x1ada('0x2f')]);_0x29268b[_0x1ada('0x31')]=_[_0x1ada('0x32')](_0x29268b[_0x1ada('0x2e')],_0x29268b[_0x1ada('0x2f')]);_0x3bc5f4['attributes']=_['intersection'](_0x29268b[_0x1ada('0x2e')],qs[_0x1ada('0x33')](_0x33188b[_0x1ada('0x2f')][_0x1ada('0x33')]));_0x3bc5f4[_0x1ada('0x34')]=_0x3bc5f4[_0x1ada('0x34')][_0x1ada('0x35')]?_0x3bc5f4[_0x1ada('0x34')]:_0x29268b[_0x1ada('0x2e')];if(!_0x33188b[_0x1ada('0x2f')]['hasOwnProperty'](_0x1ada('0x36'))){_0x3bc5f4[_0x1ada('0x1b')]=qs['limit'](_0x33188b[_0x1ada('0x2f')][_0x1ada('0x1b')]);_0x3bc5f4['offset']=qs[_0x1ada('0x19')](_0x33188b['query']['offset']);}_0x3bc5f4[_0x1ada('0x37')]=qs[_0x1ada('0x38')](_0x33188b[_0x1ada('0x2f')]['sort']);_0x3bc5f4[_0x1ada('0x39')]=qs[_0x1ada('0x31')](_[_0x1ada('0x3a')](_0x33188b['query'],_0x29268b[_0x1ada('0x31')]),_0x3261cb);if(_0x33188b['query'][_0x1ada('0x3b')]){_0x3bc5f4['where']=_[_0x1ada('0x3c')](_0x3bc5f4[_0x1ada('0x39')],{'$or':_[_0x1ada('0x29')](_0x3261cb,function(_0x2df976){if(_0x2df976[_0x1ada('0x2d')]!==_0x1ada('0x3d')){var _0x41e89a={};_0x41e89a[_0x2df976[_0x1ada('0x26')]]={'$like':'%'+_0x33188b[_0x1ada('0x2f')][_0x1ada('0x3b')]+'%'};return _0x41e89a;}})});}_0x3bc5f4=_[_0x1ada('0x3c')]({},_0x3bc5f4,_0x33188b[_0x1ada('0x3e')]);var _0x1c364c={'where':_0x3bc5f4['where']};return db[_0x1ada('0x2a')][_0x1ada('0x1c')](_0x1c364c)[_0x1ada('0x21')](function(_0x2fe5a3){_0x505f53[_0x1ada('0x1c')]=_0x2fe5a3;if(_0x33188b[_0x1ada('0x2f')][_0x1ada('0x3f')]){_0x3bc5f4['include']=[{'all':!![]}];}return db[_0x1ada('0x2a')][_0x1ada('0x40')](_0x3bc5f4);})[_0x1ada('0x21')](function(_0x5aca52){_0x505f53[_0x1ada('0x41')]=_0x5aca52;return _0x505f53;})[_0x1ada('0x21')](respondWithFilteredResult(_0x2984d1,_0x3bc5f4))[_0x1ada('0x42')](handleError(_0x2984d1,null));};exports[_0x1ada('0x43')]=function(_0x19d459,_0x4e2aa7){var _0x38285a={'raw':!![],'where':{'id':_0x19d459[_0x1ada('0x44')]['id']}},_0x32d19f={};_0x32d19f[_0x1ada('0x2e')]=_['keys'](db[_0x1ada('0x2a')][_0x1ada('0x2b')]);_0x32d19f[_0x1ada('0x2f')]=_[_0x1ada('0x30')](_0x19d459['query']);_0x32d19f[_0x1ada('0x31')]=_['intersection'](_0x32d19f[_0x1ada('0x2e')],_0x32d19f[_0x1ada('0x2f')]);_0x38285a['attributes']=_[_0x1ada('0x32')](_0x32d19f['model'],qs['fields'](_0x19d459[_0x1ada('0x2f')]['fields']));_0x38285a[_0x1ada('0x34')]=_0x38285a[_0x1ada('0x34')]['length']?_0x38285a[_0x1ada('0x34')]:_0x32d19f['model'];if(_0x19d459['query'][_0x1ada('0x3f')]){_0x38285a[_0x1ada('0x45')]=[{'all':!![]}];}_0x38285a=_['merge']({},_0x38285a,_0x19d459['options']);return db[_0x1ada('0x2a')][_0x1ada('0x46')](_0x38285a)[_0x1ada('0x21')](handleEntityNotFound(_0x4e2aa7,null))[_0x1ada('0x21')](respondWithResult(_0x4e2aa7,null))[_0x1ada('0x42')](handleError(_0x4e2aa7,null));};exports[_0x1ada('0x47')]=function(_0x317e42,_0xae099){return db[_0x1ada('0x2a')][_0x1ada('0x47')]()[_0x1ada('0x21')](respondWithResult(_0xae099,null))[_0x1ada('0x42')](handleError(_0xae099,null));};exports[_0x1ada('0x48')]=function(_0x49352f,_0x2aeee4){if(_0x49352f[_0x1ada('0x49')][_0x1ada('0x4a')]){delete _0x49352f[_0x1ada('0x49')]['uniqueid'];}return db['CmHopperFinal'][_0x1ada('0x46')]({'where':{'uniqueid':_0x49352f[_0x1ada('0x44')]['id']}})['then'](handleEntityNotFound(_0x2aeee4,null))['then'](saveUpdates(_0x49352f[_0x1ada('0x49')],null))[_0x1ada('0x21')](respondWithResult(_0x2aeee4,null))[_0x1ada('0x42')](handleError(_0x2aeee4,null));};exports[_0x1ada('0x4b')]=function(_0x1324b1,_0xa7a1b6,_0x5cd1a1){return db[_0x1ada('0x2a')][_0x1ada('0x40')]({'raw':![],'where':{'VoiceQueueId':_0x1324b1[_0x1ada('0x44')]['id']},'attributes':[[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db['sequelize']['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x4f')))),_0x1ada('0x50')],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db['sequelize'][_0x1ada('0x4e')]('`state`\x20=\x203,\x201,\x20null'))),_0x1ada('0x51')],[db['sequelize']['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x52')))),_0x1ada('0x53')],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x54')))),_0x1ada('0x55')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x56')))),_0x1ada('0x57')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db['sequelize'][_0x1ada('0x4e')](_0x1ada('0x58')))),'abandonedContacts'],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x59')))),'reCallContacts'],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db['sequelize']['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')]('`state`\x20=\x2019,\x201,\x20null'))),'answeringMachine']]})[_0x1ada('0x21')](handleEntityNotFound(_0xa7a1b6,null))['then'](respondWithResult(_0xa7a1b6,null))[_0x1ada('0x42')](handleError(_0xa7a1b6,null));};exports['countContactsIvrCampaignHopperFinal']=function(_0x31ba82,_0x52ad01,_0x3be9f4){return db['CmHopperFinal']['findAll']({'raw':![],'where':{'CampaignId':_0x31ba82[_0x1ada('0x44')]['id']},'attributes':[[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')]['literal'](_0x1ada('0x4f')))),_0x1ada('0x50')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')]('`state`\x20=\x203,\x201,\x20null'))),_0x1ada('0x51')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')]['literal'](_0x1ada('0x52')))),_0x1ada('0x53')],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x54')))),'congestionContacts'],[db['sequelize']['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x56')))),_0x1ada('0x57')],[db['sequelize']['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x58')))),_0x1ada('0x5a')],[db[_0x1ada('0x4c')]['fn']('COUNT',db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x59')))),_0x1ada('0x5b')],[db[_0x1ada('0x4c')]['fn'](_0x1ada('0x4d'),db[_0x1ada('0x4c')]['fn']('IF',db[_0x1ada('0x4c')][_0x1ada('0x4e')](_0x1ada('0x5c')))),_0x1ada('0x5d')]]})[_0x1ada('0x21')](handleEntityNotFound(_0x52ad01,null))[_0x1ada('0x21')](respondWithResult(_0x52ad01,null))['catch'](handleError(_0x52ad01,null));};exports[_0x1ada('0x5e')]=function(_0x5e063b,_0x4a4369,_0x3b5b6b){return db[_0x1ada('0x5f')][_0x1ada('0x46')]({'where':{'id':_0x5e063b[_0x1ada('0x44')]['id']}})[_0x1ada('0x21')](handleEntityNotFound(_0x4a4369,null))[_0x1ada('0x21')](function(_0x34f099){var _0x8ffaec;if(_0x34f099){_0x8ffaec=squel[_0x1ada('0x60')]()['into']('cm_hopper')[_0x1ada('0x61')](['phone',_0x1ada('0x62'),_0x1ada('0x63'),'ListId',_0x1ada('0x64'),'createdAt','updatedAt'],squel['select']()['field'](_0x1ada('0x65'),'phone')[_0x1ada('0x66')](_0x1ada('0x67'),_0x1ada('0x62'))[_0x1ada('0x66')](_0x1ada('0x68'),_0x1ada('0x63'))[_0x1ada('0x66')](_0x1ada('0x69'),_0x1ada('0x6a'))['field'](_0x1ada('0x6b'),_0x1ada('0x64'))[_0x1ada('0x66')](_0x1ada('0x67'),_0x1ada('0x6c'))[_0x1ada('0x66')](_0x1ada('0x67'),_0x1ada('0x6d'))[_0x1ada('0x6e')](_0x1ada('0x6f'))[_0x1ada('0x39')]('VoiceQueueId\x20=\x20?',_0x5e063b['params']['id'][_0x1ada('0x70')]())[_0x1ada('0x39')](_0x1ada('0x71'),_0x5e063b[_0x1ada('0x49')][_0x1ada('0x72')]['toString']())[_0x1ada('0x39')](_0x1ada('0x73'))[_0x1ada('0x39')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x1ada('0x74')]()[_0x1ada('0x66')](_0x1ada('0x75'))[_0x1ada('0x6e')](_0x1ada('0x76'))['where'](_0x1ada('0x77'),_0x5e063b[_0x1ada('0x44')]['id'][_0x1ada('0x70')]()))['where'](_0x1ada('0x78'),squel['select']()[_0x1ada('0x66')](_0x1ada('0x79'))[_0x1ada('0x6e')](_0x1ada('0x6f'))[_0x1ada('0x39')]('VoiceQueueId\x20=\x20?',_0x5e063b[_0x1ada('0x44')]['id'][_0x1ada('0x70')]())[_0x1ada('0x39')](_0x1ada('0x7a')))[_0x1ada('0x7b')](_0x1ada('0x63')))['toString']();return db[_0x1ada('0x4c')]['query'](_0x8ffaec);}return[];})[_0x1ada('0x21')](respondWithResult(_0x4a4369,null))[_0x1ada('0x42')](handleError(_0x4a4369,null));};exports[_0x1ada('0x7c')]=function(_0x14611c,_0x36363e,_0x28326d){return db[_0x1ada('0x7d')][_0x1ada('0x46')]({'where':{'id':_0x14611c[_0x1ada('0x44')]['id']}})['then'](handleEntityNotFound(_0x36363e,null))['then'](function(_0x59214f){var _0x5bad0b;if(_0x59214f){_0x5bad0b=squel[_0x1ada('0x60')]()[_0x1ada('0x7e')](_0x1ada('0x76'))[_0x1ada('0x61')]([_0x1ada('0x75'),'scheduledAt',_0x1ada('0x63'),'ListId','CampaignId',_0x1ada('0x6c'),_0x1ada('0x6d')],squel[_0x1ada('0x74')]()['field'](_0x1ada('0x65'),_0x1ada('0x75'))[_0x1ada('0x66')](_0x1ada('0x67'),_0x1ada('0x62'))[_0x1ada('0x66')]('ANY_VALUE(ContactId)','ContactId')['field'](_0x1ada('0x69'),'ListId')[_0x1ada('0x66')](_0x1ada('0x7f'),_0x1ada('0x80'))['field'](_0x1ada('0x67'),_0x1ada('0x6c'))[_0x1ada('0x66')]('NOW()',_0x1ada('0x6d'))['from']('cm_hopper_final')['where'](_0x1ada('0x81'),_0x14611c[_0x1ada('0x44')]['id'][_0x1ada('0x70')]())[_0x1ada('0x39')](_0x1ada('0x71'),_0x14611c[_0x1ada('0x49')][_0x1ada('0x72')][_0x1ada('0x70')]())['where'](_0x1ada('0x73'))['where'](_0x1ada('0x78'),squel['select']()[_0x1ada('0x66')](_0x1ada('0x75'))['from']('cm_hopper')[_0x1ada('0x39')]('CampaignId\x20=\x20?',_0x14611c[_0x1ada('0x44')]['id'][_0x1ada('0x70')]()))['where'](_0x1ada('0x78'),squel['select']()[_0x1ada('0x66')](_0x1ada('0x79'))[_0x1ada('0x6e')](_0x1ada('0x6f'))[_0x1ada('0x39')](_0x1ada('0x81'),_0x14611c[_0x1ada('0x44')]['id'][_0x1ada('0x70')]())[_0x1ada('0x39')](_0x1ada('0x7a')))['group'](_0x1ada('0x63')))[_0x1ada('0x70')]();return db[_0x1ada('0x4c')]['query'](_0x5bad0b);}return[];})[_0x1ada('0x21')](respondWithResult(_0x36363e,null))['catch'](handleError(_0x36363e,null));};exports[_0x1ada('0x82')]=function(_0x36a957,_0x183650,_0x49da38){return db['CmHopper'][_0x1ada('0x83')]({'where':{'VoiceQueueId':_0x36a957[_0x1ada('0x49')][_0x1ada('0x64')],'CampaignId':_0x36a957[_0x1ada('0x49')][_0x1ada('0x80')],'ContactId':_0x36a957[_0x1ada('0x49')][_0x1ada('0x63')]}})['then'](handleEntityNotFound(_0x183650,null))[_0x1ada('0x21')](function(_0xfe073e){if(_0xfe073e){return _0xfe073e;}return null;})[_0x1ada('0x21')](respondWithResult(_0x183650,null))[_0x1ada('0x42')](handleError(_0x183650,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff