// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xb878=['reCallContacts','countContactsIvrCampaignHopperFinal','busyContacts','abandonedContacts','answeringMachine','moveContactsQueueCampaignHopperFinal','insert','into','cm_hopper','phone','scheduledAt','ContactId','VoiceQueueId','createdAt','updatedAt','select','field','ANY_VALUE(calleridnum)','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ListId','ANY_VALUE(VoiceQueueId)','from','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','calleridnum\x20NOT\x20IN\x20(?)','calleridnum','state\x20=\x204','group','Campaign','fromQuery','ANY_VALUE(CampaignId)','CampaignId','CampaignId\x20=\x20?','calleridnum\x20IS\x20NOT\x20NULL','checkContactHopper','CmHopper','findOne','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','../../config/utils','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','then','destroy','error','stack','name','send','index','CmHopperFinal','rawAttributes','model','keys','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','map','key','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','length','find','describe','update','body','uniqueid','params','sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','`state`\x20=\x2011\x20,\x201,\x20null','`state`\x20=\x2022,\x201,\x20null'];(function(_0x34021d,_0x753aa6){var _0x16597b=function(_0x2d040a){while(--_0x2d040a){_0x34021d['push'](_0x34021d['shift']());}};_0x16597b(++_0x753aa6);}(_0xb878,0x12b));var _0x8b87=function(_0x167cc1,_0x56ef5a){_0x167cc1=_0x167cc1-0x0;var _0x10bc4b=_0xb878[_0x167cc1];return _0x10bc4b;};'use strict';var pdf=require(_0x8b87('0x0'));var emlformat=require(_0x8b87('0x1'));var rimraf=require(_0x8b87('0x2'));var zipdir=require(_0x8b87('0x3'));var jsonpatch=require(_0x8b87('0x4'));var rp=require('request-promise');var moment=require(_0x8b87('0x5'));var BPromise=require(_0x8b87('0x6'));var Mustache=require(_0x8b87('0x7'));var util=require('util');var path=require(_0x8b87('0x8'));var sox=require('sox');var csv=require(_0x8b87('0x9'));var ejs=require(_0x8b87('0xa'));var fs=require('fs');var _=require(_0x8b87('0xb'));var squel=require(_0x8b87('0xc'));var crypto=require(_0x8b87('0xd'));var jsforce=require(_0x8b87('0xe'));var deskjs=require(_0x8b87('0xf'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x8b87('0x10'));var Redis=require(_0x8b87('0x11'));var authService=require(_0x8b87('0x12'));var qs=require(_0x8b87('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x8b87('0x14'))('api');var utils=require(_0x8b87('0x15'));var config=require('../../config/environment');var db=require(_0x8b87('0x16'))['db'];function respondWithStatusCode(_0xdc68df,_0x1f25c8){_0x1f25c8=_0x1f25c8||0xcc;return function(_0x480ef3){if(_0x480ef3){return _0xdc68df[_0x8b87('0x17')](_0x1f25c8);}return _0xdc68df[_0x8b87('0x18')](_0x1f25c8)[_0x8b87('0x19')]();};}function respondWithResult(_0x21b555,_0x3f8906){_0x3f8906=_0x3f8906||0xc8;return function(_0x40ca66){if(_0x40ca66){return _0x21b555['status'](_0x3f8906)[_0x8b87('0x1a')](_0x40ca66);}};}function respondWithFilteredResult(_0x5f203d,_0xb49749){return function(_0x239635){if(_0x239635){var _0x5592c9=_0x239635[_0x8b87('0x1b')],_0x32c856=_0xb49749[_0x8b87('0x1c')],_0x4bd5b9=_0xb49749['offset']+_0xb49749[_0x8b87('0x1d')],_0x5cfe28;if(_0x4bd5b9>=_0x5592c9){_0x4bd5b9=_0x5592c9;_0x5cfe28=0xc8;}else{_0x5cfe28=0xce;}_0x5f203d[_0x8b87('0x18')](_0x5cfe28);return _0x5f203d[_0x8b87('0x1e')](_0x8b87('0x1f'),_0x32c856+'-'+_0x4bd5b9+'/'+_0x5592c9)['json'](_0x239635);}return null;};}function patchUpdates(_0x3d0c58){return function(_0x40c82c){try{jsonpatch['apply'](_0x40c82c,_0x3d0c58,!![]);}catch(_0x12ab8a){return BPromise[_0x8b87('0x20')](_0x12ab8a);}return _0x40c82c['save']();};}function saveUpdates(_0x37382b,_0x4567dd){return function(_0x5066a9){if(_0x5066a9){return _0x5066a9['update'](_0x37382b)[_0x8b87('0x21')](function(_0x281abc){return _0x281abc;});}return null;};}function removeEntity(_0x26e7d6,_0x1b972e){return function(_0x23e272){if(_0x23e272){return _0x23e272[_0x8b87('0x22')]()['then'](function(){_0x26e7d6[_0x8b87('0x18')](0xcc)[_0x8b87('0x19')]();});}};}function handleEntityNotFound(_0x111d48,_0x461642){return function(_0x1cdc71){if(!_0x1cdc71){_0x111d48[_0x8b87('0x17')](0x194);}return _0x1cdc71;};}function handleError(_0x53aa90,_0x2f208a){_0x2f208a=_0x2f208a||0x1f4;return function(_0x80eaa8){logger[_0x8b87('0x23')](_0x80eaa8[_0x8b87('0x24')]);if(_0x80eaa8[_0x8b87('0x25')]){delete _0x80eaa8['name'];}_0x53aa90[_0x8b87('0x18')](_0x2f208a)[_0x8b87('0x26')](_0x80eaa8);};}exports[_0x8b87('0x27')]=function(_0x93e53,_0x4b556b){var _0x5850bd={},_0x96f4dd={},_0x188588={'count':0x0,'rows':[]};var _0x763615=db[_0x8b87('0x28')][_0x8b87('0x29')];_0x96f4dd[_0x8b87('0x2a')]=_['keys'](_0x763615);_0x96f4dd['query']=_[_0x8b87('0x2b')](_0x93e53[_0x8b87('0x2c')]);_0x96f4dd[_0x8b87('0x2d')]=_[_0x8b87('0x2e')](_0x96f4dd['model'],_0x96f4dd[_0x8b87('0x2c')]);_0x5850bd['attributes']=_[_0x8b87('0x2e')](_0x96f4dd[_0x8b87('0x2a')],qs[_0x8b87('0x2f')](_0x93e53[_0x8b87('0x2c')]['fields']));_0x5850bd[_0x8b87('0x30')]=_0x5850bd[_0x8b87('0x30')]['length']?_0x5850bd[_0x8b87('0x30')]:_0x96f4dd[_0x8b87('0x2a')];if(!_0x93e53[_0x8b87('0x2c')][_0x8b87('0x31')](_0x8b87('0x32'))){_0x5850bd[_0x8b87('0x1d')]=qs[_0x8b87('0x1d')](_0x93e53[_0x8b87('0x2c')]['limit']);_0x5850bd[_0x8b87('0x1c')]=qs['offset'](_0x93e53[_0x8b87('0x2c')]['offset']);}_0x5850bd[_0x8b87('0x33')]=qs[_0x8b87('0x34')](_0x93e53[_0x8b87('0x2c')][_0x8b87('0x34')]);_0x5850bd['where']=qs['filters'](_[_0x8b87('0x35')](_0x93e53[_0x8b87('0x2c')],_0x96f4dd['filters']));if(_0x93e53[_0x8b87('0x2c')][_0x8b87('0x36')]){_0x5850bd[_0x8b87('0x37')]=_[_0x8b87('0x38')](_0x5850bd[_0x8b87('0x37')],{'$or':_[_0x8b87('0x39')](_0x763615,function(_0xd49ee4){if(_0xd49ee4['type'][_0x8b87('0x3a')]!==_0x8b87('0x3b')){var _0x31f31e={};_0x31f31e[_0xd49ee4['field']]={'$like':'%'+_0x93e53['query'][_0x8b87('0x36')]+'%'};return _0x31f31e;}})});}_0x5850bd=_['merge']({},_0x5850bd,_0x93e53[_0x8b87('0x3c')]);var _0x304547={'where':_0x5850bd[_0x8b87('0x37')]};return db['CmHopperFinal'][_0x8b87('0x1b')](_0x304547)[_0x8b87('0x21')](function(_0x4ce317){_0x188588[_0x8b87('0x1b')]=_0x4ce317;if(_0x93e53[_0x8b87('0x2c')][_0x8b87('0x3d')]){_0x5850bd[_0x8b87('0x3e')]=[{'all':!![]}];}return db[_0x8b87('0x28')][_0x8b87('0x3f')](_0x5850bd);})[_0x8b87('0x21')](function(_0x5a0a29){_0x188588[_0x8b87('0x40')]=_0x5a0a29;return _0x188588;})[_0x8b87('0x21')](respondWithFilteredResult(_0x4b556b,_0x5850bd))[_0x8b87('0x41')](handleError(_0x4b556b,null));};exports[_0x8b87('0x42')]=function(_0x35d088,_0x1b4d41){var _0x3c1ca7={'raw':!![],'where':{'id':_0x35d088['params']['id']}},_0x190124={};_0x190124[_0x8b87('0x2a')]=_[_0x8b87('0x2b')](db['CmHopperFinal'][_0x8b87('0x29')]);_0x190124[_0x8b87('0x2c')]=_[_0x8b87('0x2b')](_0x35d088['query']);_0x190124[_0x8b87('0x2d')]=_[_0x8b87('0x2e')](_0x190124['model'],_0x190124[_0x8b87('0x2c')]);_0x3c1ca7[_0x8b87('0x30')]=_['intersection'](_0x190124[_0x8b87('0x2a')],qs[_0x8b87('0x2f')](_0x35d088['query'][_0x8b87('0x2f')]));_0x3c1ca7['attributes']=_0x3c1ca7[_0x8b87('0x30')][_0x8b87('0x43')]?_0x3c1ca7[_0x8b87('0x30')]:_0x190124[_0x8b87('0x2a')];if(_0x35d088[_0x8b87('0x2c')][_0x8b87('0x3d')]){_0x3c1ca7['include']=[{'all':!![]}];}_0x3c1ca7=_[_0x8b87('0x38')]({},_0x3c1ca7,_0x35d088['options']);return db['CmHopperFinal'][_0x8b87('0x44')](_0x3c1ca7)[_0x8b87('0x21')](handleEntityNotFound(_0x1b4d41,null))[_0x8b87('0x21')](respondWithResult(_0x1b4d41,null))[_0x8b87('0x41')](handleError(_0x1b4d41,null));};exports[_0x8b87('0x45')]=function(_0x14b741,_0x208ee9){return db[_0x8b87('0x28')][_0x8b87('0x45')]()['then'](respondWithResult(_0x208ee9,null))[_0x8b87('0x41')](handleError(_0x208ee9,null));};exports[_0x8b87('0x46')]=function(_0x4cb5c2,_0x53d982){if(_0x4cb5c2[_0x8b87('0x47')][_0x8b87('0x48')]){delete _0x4cb5c2[_0x8b87('0x47')][_0x8b87('0x48')];}return db[_0x8b87('0x28')][_0x8b87('0x44')]({'where':{'uniqueid':_0x4cb5c2[_0x8b87('0x49')]['id']}})[_0x8b87('0x21')](handleEntityNotFound(_0x53d982,null))[_0x8b87('0x21')](saveUpdates(_0x4cb5c2[_0x8b87('0x47')],null))['then'](respondWithResult(_0x53d982,null))[_0x8b87('0x41')](handleError(_0x53d982,null));};exports['countContactsQueueCampaignHopperFinal']=function(_0x3a6f18,_0x535f76,_0x1f4090){return db[_0x8b87('0x28')][_0x8b87('0x3f')]({'raw':![],'where':{'VoiceQueueId':_0x3a6f18[_0x8b87('0x49')]['id']},'attributes':[[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')](_0x8b87('0x4d')))),_0x8b87('0x4e')],[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db['sequelize']['fn']('IF',db[_0x8b87('0x4a')]['literal'](_0x8b87('0x4f')))),_0x8b87('0x50')],[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db['sequelize']['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')](_0x8b87('0x51')))),'busyContacts'],[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')]['literal'](_0x8b87('0x52')))),_0x8b87('0x53')],[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db['sequelize']['fn']('IF',db[_0x8b87('0x4a')]['literal'](_0x8b87('0x54')))),_0x8b87('0x55')],[db[_0x8b87('0x4a')]['fn']('COUNT',db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')](_0x8b87('0x56')))),'abandonedContacts'],[db[_0x8b87('0x4a')]['fn']('COUNT',db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')](_0x8b87('0x57')))),_0x8b87('0x58')],[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db['sequelize']['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')]('`state`\x20=\x2019,\x201,\x20null'))),'answeringMachine']]})[_0x8b87('0x21')](handleEntityNotFound(_0x535f76,null))[_0x8b87('0x21')](respondWithResult(_0x535f76,null))[_0x8b87('0x41')](handleError(_0x535f76,null));};exports[_0x8b87('0x59')]=function(_0x5527df,_0x45c081,_0x1b6ccc){return db['CmHopperFinal'][_0x8b87('0x3f')]({'raw':![],'where':{'CampaignId':_0x5527df[_0x8b87('0x49')]['id']},'attributes':[[db['sequelize']['fn']('COUNT',db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')](_0x8b87('0x4d')))),_0x8b87('0x4e')],[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db[_0x8b87('0x4a')]['fn']('IF',db['sequelize'][_0x8b87('0x4c')](_0x8b87('0x4f')))),_0x8b87('0x50')],[db[_0x8b87('0x4a')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')](_0x8b87('0x51')))),_0x8b87('0x5a')],[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')](_0x8b87('0x52')))),_0x8b87('0x53')],[db['sequelize']['fn'](_0x8b87('0x4b'),db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')]['literal'](_0x8b87('0x54')))),'dropContacts'],[db[_0x8b87('0x4a')]['fn'](_0x8b87('0x4b'),db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')][_0x8b87('0x4c')](_0x8b87('0x56')))),_0x8b87('0x5b')],[db[_0x8b87('0x4a')]['fn']('COUNT',db[_0x8b87('0x4a')]['fn']('IF',db[_0x8b87('0x4a')]['literal'](_0x8b87('0x57')))),_0x8b87('0x58')],[db['sequelize']['fn'](_0x8b87('0x4b'),db[_0x8b87('0x4a')]['fn']('IF',db['sequelize'][_0x8b87('0x4c')]('`state`\x20=\x2019,\x201,\x20null'))),_0x8b87('0x5c')]]})[_0x8b87('0x21')](handleEntityNotFound(_0x45c081,null))[_0x8b87('0x21')](respondWithResult(_0x45c081,null))[_0x8b87('0x41')](handleError(_0x45c081,null));};exports[_0x8b87('0x5d')]=function(_0x3a20b6,_0x461005,_0x1f87b6){return db['VoiceQueue'][_0x8b87('0x44')]({'where':{'id':_0x3a20b6['params']['id']}})[_0x8b87('0x21')](handleEntityNotFound(_0x461005,null))[_0x8b87('0x21')](function(_0x18cdc9){var _0x2ed5b0;if(_0x18cdc9){_0x2ed5b0=squel[_0x8b87('0x5e')]()[_0x8b87('0x5f')](_0x8b87('0x60'))['fromQuery']([_0x8b87('0x61'),_0x8b87('0x62'),_0x8b87('0x63'),'ListId',_0x8b87('0x64'),_0x8b87('0x65'),_0x8b87('0x66')],squel[_0x8b87('0x67')]()[_0x8b87('0x68')](_0x8b87('0x69'),'phone')[_0x8b87('0x68')](_0x8b87('0x6a'),'scheduledAt')['field'](_0x8b87('0x6b'),_0x8b87('0x63'))[_0x8b87('0x68')](_0x8b87('0x6c'),_0x8b87('0x6d'))[_0x8b87('0x68')](_0x8b87('0x6e'),'VoiceQueueId')['field'](_0x8b87('0x6a'),_0x8b87('0x65'))[_0x8b87('0x68')](_0x8b87('0x6a'),_0x8b87('0x66'))[_0x8b87('0x6f')](_0x8b87('0x70'))[_0x8b87('0x37')](_0x8b87('0x71'),_0x3a20b6[_0x8b87('0x49')]['id'][_0x8b87('0x72')]())[_0x8b87('0x37')](_0x8b87('0x73'),_0x3a20b6[_0x8b87('0x47')]['state'][_0x8b87('0x72')]())['where']('calleridnum\x20IS\x20NOT\x20NULL')['where']('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x8b87('0x67')]()[_0x8b87('0x68')](_0x8b87('0x61'))[_0x8b87('0x6f')](_0x8b87('0x60'))['where']('VoiceQueueId\x20=\x20?',_0x3a20b6['params']['id'][_0x8b87('0x72')]()))[_0x8b87('0x37')](_0x8b87('0x74'),squel['select']()[_0x8b87('0x68')](_0x8b87('0x75'))[_0x8b87('0x6f')](_0x8b87('0x70'))[_0x8b87('0x37')](_0x8b87('0x71'),_0x3a20b6[_0x8b87('0x49')]['id']['toString']())[_0x8b87('0x37')](_0x8b87('0x76')))[_0x8b87('0x77')](_0x8b87('0x63')))[_0x8b87('0x72')]();return db[_0x8b87('0x4a')][_0x8b87('0x2c')](_0x2ed5b0);}return[];})[_0x8b87('0x21')](respondWithResult(_0x461005,null))['catch'](handleError(_0x461005,null));};exports['moveContactsIvrCampaignHopperFinal']=function(_0x400c61,_0xb361d5,_0x3d6828){return db[_0x8b87('0x78')][_0x8b87('0x44')]({'where':{'id':_0x400c61[_0x8b87('0x49')]['id']}})[_0x8b87('0x21')](handleEntityNotFound(_0xb361d5,null))[_0x8b87('0x21')](function(_0x537cca){var _0x2bc03f;if(_0x537cca){_0x2bc03f=squel['insert']()[_0x8b87('0x5f')]('cm_hopper')[_0x8b87('0x79')]([_0x8b87('0x61'),'scheduledAt',_0x8b87('0x63'),'ListId','CampaignId',_0x8b87('0x65'),_0x8b87('0x66')],squel[_0x8b87('0x67')]()[_0x8b87('0x68')]('ANY_VALUE(calleridnum)','phone')[_0x8b87('0x68')](_0x8b87('0x6a'),_0x8b87('0x62'))[_0x8b87('0x68')](_0x8b87('0x6b'),_0x8b87('0x63'))[_0x8b87('0x68')]('ANY_VALUE(ListId)',_0x8b87('0x6d'))['field'](_0x8b87('0x7a'),_0x8b87('0x7b'))[_0x8b87('0x68')](_0x8b87('0x6a'),'createdAt')[_0x8b87('0x68')](_0x8b87('0x6a'),'updatedAt')[_0x8b87('0x6f')](_0x8b87('0x70'))['where'](_0x8b87('0x7c'),_0x400c61['params']['id']['toString']())[_0x8b87('0x37')]('state\x20=\x20?',_0x400c61['body']['state']['toString']())['where'](_0x8b87('0x7d'))[_0x8b87('0x37')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x8b87('0x67')]()[_0x8b87('0x68')](_0x8b87('0x61'))['from'](_0x8b87('0x60'))[_0x8b87('0x37')](_0x8b87('0x7c'),_0x400c61[_0x8b87('0x49')]['id'][_0x8b87('0x72')]()))[_0x8b87('0x37')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x8b87('0x67')]()[_0x8b87('0x68')](_0x8b87('0x75'))['from'](_0x8b87('0x70'))[_0x8b87('0x37')](_0x8b87('0x7c'),_0x400c61[_0x8b87('0x49')]['id'][_0x8b87('0x72')]())['where'](_0x8b87('0x76')))[_0x8b87('0x77')](_0x8b87('0x63')))['toString']();return db[_0x8b87('0x4a')][_0x8b87('0x2c')](_0x2bc03f);}return[];})['then'](respondWithResult(_0xb361d5,null))[_0x8b87('0x41')](handleError(_0xb361d5,null));};exports[_0x8b87('0x7e')]=function(_0x38ef35,_0x307be2,_0x2d1e17){return db[_0x8b87('0x7f')][_0x8b87('0x80')]({'where':{'VoiceQueueId':_0x38ef35[_0x8b87('0x47')][_0x8b87('0x64')],'CampaignId':_0x38ef35[_0x8b87('0x47')][_0x8b87('0x7b')],'ContactId':_0x38ef35['body'][_0x8b87('0x63')]}})[_0x8b87('0x21')](handleEntityNotFound(_0x307be2,null))['then'](function(_0x8a4ff8){if(_0x8a4ff8){return _0x8a4ff8;}return null;})['then'](respondWithResult(_0x307be2,null))['catch'](handleError(_0x307be2,null));};
\ No newline at end of file
+var _0x287c=['reject','save','update','then','destroy','error','name','send','CmHopperFinal','model','keys','query','filters','attributes','fields','length','nolimit','limit','offset','sort','where','pick','merge','type','key','VIRTUAL','field','filter','options','count','includeAll','catch','show','rawAttributes','intersection','include','describe','body','uniqueid','find','params','countContactsQueueCampaignHopperFinal','findAll','sequelize','`state`\x20=\x200,\x201,\x20null','noSuchContacts','literal','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','COUNT','`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','abandonedContacts','`state`\x20=\x2022,\x201,\x20null','reCallContacts','answeringMachine','countContactsIvrCampaignHopperFinal','`state`\x20=\x2019,\x201,\x20null','VoiceQueue','into','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','VoiceQueueId','updatedAt','ANY_VALUE(calleridnum)','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','cm_hopper_final','VoiceQueueId\x20=\x20?','toString','state\x20=\x20?','state','calleridnum\x20IS\x20NOT\x20NULL','select','from','calleridnum','moveContactsIvrCampaignHopperFinal','Campaign','insert','CampaignId','createdAt','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','calleridnum\x20NOT\x20IN\x20(?)','state\x20=\x204','group','checkContactHopper','CmHopper','findOne','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','sendStatus','status','end','json','set','Content-Range','apply'];(function(_0x3a7155,_0x3683f5){var _0x24b0e1=function(_0x399e7d){while(--_0x399e7d){_0x3a7155['push'](_0x3a7155['shift']());}};_0x24b0e1(++_0x3683f5);}(_0x287c,0xe5));var _0xc287=function(_0x5113f4,_0x54f096){_0x5113f4=_0x5113f4-0x0;var _0x23d1e8=_0x287c[_0x5113f4];return _0x23d1e8;};'use strict';var pdf=require(_0xc287('0x0'));var emlformat=require(_0xc287('0x1'));var rimraf=require('rimraf');var zipdir=require(_0xc287('0x2'));var jsonpatch=require(_0xc287('0x3'));var rp=require(_0xc287('0x4'));var moment=require(_0xc287('0x5'));var BPromise=require(_0xc287('0x6'));var Mustache=require(_0xc287('0x7'));var util=require(_0xc287('0x8'));var path=require('path');var sox=require(_0xc287('0x9'));var csv=require(_0xc287('0xa'));var ejs=require(_0xc287('0xb'));var fs=require('fs');var _=require(_0xc287('0xc'));var squel=require(_0xc287('0xd'));var crypto=require(_0xc287('0xe'));var jsforce=require(_0xc287('0xf'));var deskjs=require(_0xc287('0x10'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xc287('0x11'));var Redis=require(_0xc287('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xc287('0x13'));var hardwareService=require(_0xc287('0x14'));var logger=require(_0xc287('0x15'))(_0xc287('0x16'));var utils=require('../../config/utils');var config=require(_0xc287('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x55f20d,_0x24d49d){_0x24d49d=_0x24d49d||0xcc;return function(_0x55efc4){if(_0x55efc4){return _0x55f20d[_0xc287('0x18')](_0x24d49d);}return _0x55f20d[_0xc287('0x19')](_0x24d49d)[_0xc287('0x1a')]();};}function respondWithResult(_0x185d3c,_0x19fce9){_0x19fce9=_0x19fce9||0xc8;return function(_0x152de3){if(_0x152de3){return _0x185d3c[_0xc287('0x19')](_0x19fce9)[_0xc287('0x1b')](_0x152de3);}};}function respondWithFilteredResult(_0x5a48e7,_0x43f2f5){return function(_0xba786f){if(_0xba786f){var _0x1e99ab=_0xba786f['count'],_0x11e731=_0x43f2f5['offset'],_0x22f651=_0x43f2f5['offset']+_0x43f2f5['limit'],_0x5dcdbd;if(_0x22f651>=_0x1e99ab){_0x22f651=_0x1e99ab;_0x5dcdbd=0xc8;}else{_0x5dcdbd=0xce;}_0x5a48e7[_0xc287('0x19')](_0x5dcdbd);return _0x5a48e7[_0xc287('0x1c')](_0xc287('0x1d'),_0x11e731+'-'+_0x22f651+'/'+_0x1e99ab)[_0xc287('0x1b')](_0xba786f);}return null;};}function patchUpdates(_0x170bdc){return function(_0xccc564){try{jsonpatch[_0xc287('0x1e')](_0xccc564,_0x170bdc,!![]);}catch(_0x30d77a){return BPromise[_0xc287('0x1f')](_0x30d77a);}return _0xccc564[_0xc287('0x20')]();};}function saveUpdates(_0x34c87d,_0xab3f4e){return function(_0x28a3c0){if(_0x28a3c0){return _0x28a3c0[_0xc287('0x21')](_0x34c87d)[_0xc287('0x22')](function(_0x10054e){return _0x10054e;});}return null;};}function removeEntity(_0x1b8014,_0x5d1586){return function(_0x333935){if(_0x333935){return _0x333935[_0xc287('0x23')]()[_0xc287('0x22')](function(){_0x1b8014[_0xc287('0x19')](0xcc)[_0xc287('0x1a')]();});}};}function handleEntityNotFound(_0x52085d,_0x10dd0a){return function(_0x5d3823){if(!_0x5d3823){_0x52085d[_0xc287('0x18')](0x194);}return _0x5d3823;};}function handleError(_0x444668,_0x58fae5){_0x58fae5=_0x58fae5||0x1f4;return function(_0x33e492){logger[_0xc287('0x24')](_0x33e492['stack']);if(_0x33e492['name']){delete _0x33e492[_0xc287('0x25')];}_0x444668[_0xc287('0x19')](_0x58fae5)[_0xc287('0x26')](_0x33e492);};}exports['index']=function(_0x1b4a12,_0xc72e69){var _0x42c13e={},_0x396a4c={},_0xf9ca5={'count':0x0,'rows':[]};var _0x21f57a=db[_0xc287('0x27')]['rawAttributes'];_0x396a4c[_0xc287('0x28')]=_[_0xc287('0x29')](_0x21f57a);_0x396a4c[_0xc287('0x2a')]=_['keys'](_0x1b4a12['query']);_0x396a4c[_0xc287('0x2b')]=_['intersection'](_0x396a4c[_0xc287('0x28')],_0x396a4c[_0xc287('0x2a')]);_0x42c13e[_0xc287('0x2c')]=_['intersection'](_0x396a4c[_0xc287('0x28')],qs[_0xc287('0x2d')](_0x1b4a12['query'][_0xc287('0x2d')]));_0x42c13e[_0xc287('0x2c')]=_0x42c13e['attributes'][_0xc287('0x2e')]?_0x42c13e[_0xc287('0x2c')]:_0x396a4c[_0xc287('0x28')];if(!_0x1b4a12[_0xc287('0x2a')]['hasOwnProperty'](_0xc287('0x2f'))){_0x42c13e['limit']=qs['limit'](_0x1b4a12['query'][_0xc287('0x30')]);_0x42c13e[_0xc287('0x31')]=qs[_0xc287('0x31')](_0x1b4a12[_0xc287('0x2a')]['offset']);}_0x42c13e['order']=qs[_0xc287('0x32')](_0x1b4a12[_0xc287('0x2a')]['sort']);_0x42c13e[_0xc287('0x33')]=qs[_0xc287('0x2b')](_[_0xc287('0x34')](_0x1b4a12['query'],_0x396a4c[_0xc287('0x2b')]));if(_0x1b4a12[_0xc287('0x2a')]['filter']){_0x42c13e[_0xc287('0x33')]=_[_0xc287('0x35')](_0x42c13e['where'],{'$or':_['map'](_0x21f57a,function(_0x448cd8){if(_0x448cd8[_0xc287('0x36')][_0xc287('0x37')]!==_0xc287('0x38')){var _0x2d8b5f={};_0x2d8b5f[_0x448cd8[_0xc287('0x39')]]={'$like':'%'+_0x1b4a12['query'][_0xc287('0x3a')]+'%'};return _0x2d8b5f;}})});}_0x42c13e=_['merge']({},_0x42c13e,_0x1b4a12[_0xc287('0x3b')]);var _0x4692b5={'where':_0x42c13e[_0xc287('0x33')]};return db[_0xc287('0x27')][_0xc287('0x3c')](_0x4692b5)['then'](function(_0x2c8a38){_0xf9ca5[_0xc287('0x3c')]=_0x2c8a38;if(_0x1b4a12['query'][_0xc287('0x3d')]){_0x42c13e['include']=[{'all':!![]}];}return db[_0xc287('0x27')]['findAll'](_0x42c13e);})[_0xc287('0x22')](function(_0x561cd3){_0xf9ca5['rows']=_0x561cd3;return _0xf9ca5;})[_0xc287('0x22')](respondWithFilteredResult(_0xc72e69,_0x42c13e))[_0xc287('0x3e')](handleError(_0xc72e69,null));};exports[_0xc287('0x3f')]=function(_0x2f150f,_0x1f6aa3){var _0x251636={'raw':!![],'where':{'id':_0x2f150f['params']['id']}},_0x1ef0f5={};_0x1ef0f5[_0xc287('0x28')]=_[_0xc287('0x29')](db[_0xc287('0x27')][_0xc287('0x40')]);_0x1ef0f5['query']=_[_0xc287('0x29')](_0x2f150f[_0xc287('0x2a')]);_0x1ef0f5['filters']=_[_0xc287('0x41')](_0x1ef0f5[_0xc287('0x28')],_0x1ef0f5['query']);_0x251636['attributes']=_['intersection'](_0x1ef0f5['model'],qs[_0xc287('0x2d')](_0x2f150f[_0xc287('0x2a')]['fields']));_0x251636['attributes']=_0x251636[_0xc287('0x2c')][_0xc287('0x2e')]?_0x251636[_0xc287('0x2c')]:_0x1ef0f5[_0xc287('0x28')];if(_0x2f150f[_0xc287('0x2a')][_0xc287('0x3d')]){_0x251636[_0xc287('0x42')]=[{'all':!![]}];}_0x251636=_[_0xc287('0x35')]({},_0x251636,_0x2f150f[_0xc287('0x3b')]);return db['CmHopperFinal']['find'](_0x251636)['then'](handleEntityNotFound(_0x1f6aa3,null))[_0xc287('0x22')](respondWithResult(_0x1f6aa3,null))[_0xc287('0x3e')](handleError(_0x1f6aa3,null));};exports[_0xc287('0x43')]=function(_0x54687a,_0x1b317c){return db[_0xc287('0x27')][_0xc287('0x43')]()['then'](respondWithResult(_0x1b317c,null))[_0xc287('0x3e')](handleError(_0x1b317c,null));};exports[_0xc287('0x21')]=function(_0x3f465b,_0x131805){if(_0x3f465b[_0xc287('0x44')][_0xc287('0x45')]){delete _0x3f465b['body'][_0xc287('0x45')];}return db[_0xc287('0x27')][_0xc287('0x46')]({'where':{'uniqueid':_0x3f465b[_0xc287('0x47')]['id']}})[_0xc287('0x22')](handleEntityNotFound(_0x131805,null))[_0xc287('0x22')](saveUpdates(_0x3f465b['body'],null))[_0xc287('0x22')](respondWithResult(_0x131805,null))['catch'](handleError(_0x131805,null));};exports[_0xc287('0x48')]=function(_0x4e4096,_0x2d41e6,_0x5c19d3){return db[_0xc287('0x27')][_0xc287('0x49')]({'raw':![],'where':{'VoiceQueueId':_0x4e4096[_0xc287('0x47')]['id']},'attributes':[[db['sequelize']['fn']('COUNT',db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')]['literal'](_0xc287('0x4b')))),_0xc287('0x4c')],[db[_0xc287('0x4a')]['fn']('COUNT',db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x4e')))),_0xc287('0x4f')],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x51')))),_0xc287('0x52')],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x53')))),_0xc287('0x54')],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x55')))),_0xc287('0x56')],[db['sequelize']['fn'](_0xc287('0x50'),db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x57')))),_0xc287('0x58')],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db['sequelize']['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x59')))),_0xc287('0x5a')],[db[_0xc287('0x4a')]['fn']('COUNT',db[_0xc287('0x4a')]['fn']('IF',db['sequelize'][_0xc287('0x4d')]('`state`\x20=\x2019,\x201,\x20null'))),_0xc287('0x5b')]]})[_0xc287('0x22')](handleEntityNotFound(_0x2d41e6,null))[_0xc287('0x22')](respondWithResult(_0x2d41e6,null))[_0xc287('0x3e')](handleError(_0x2d41e6,null));};exports[_0xc287('0x5c')]=function(_0x2c9921,_0x5b839f,_0x58f7f1){return db['CmHopperFinal'][_0xc287('0x49')]({'raw':![],'where':{'CampaignId':_0x2c9921['params']['id']},'attributes':[[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x4b')))),_0xc287('0x4c')],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db['sequelize']['fn']('IF',db['sequelize'][_0xc287('0x4d')]('`state`\x20=\x203,\x201,\x20null'))),_0xc287('0x4f')],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db['sequelize']['fn']('IF',db['sequelize'][_0xc287('0x4d')](_0xc287('0x51')))),'busyContacts'],[db[_0xc287('0x4a')]['fn']('COUNT',db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')]['literal'](_0xc287('0x53')))),_0xc287('0x54')],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x55')))),'dropContacts'],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x57')))),_0xc287('0x58')],[db['sequelize']['fn'](_0xc287('0x50'),db['sequelize']['fn']('IF',db[_0xc287('0x4a')]['literal'](_0xc287('0x59')))),'reCallContacts'],[db[_0xc287('0x4a')]['fn'](_0xc287('0x50'),db[_0xc287('0x4a')]['fn']('IF',db[_0xc287('0x4a')][_0xc287('0x4d')](_0xc287('0x5d')))),_0xc287('0x5b')]]})[_0xc287('0x22')](handleEntityNotFound(_0x5b839f,null))[_0xc287('0x22')](respondWithResult(_0x5b839f,null))[_0xc287('0x3e')](handleError(_0x5b839f,null));};exports['moveContactsQueueCampaignHopperFinal']=function(_0x5d9d0b,_0x233508,_0x48b05c){return db[_0xc287('0x5e')][_0xc287('0x46')]({'where':{'id':_0x5d9d0b[_0xc287('0x47')]['id']}})[_0xc287('0x22')](handleEntityNotFound(_0x233508,null))[_0xc287('0x22')](function(_0x67a79f){var _0x1959e2;if(_0x67a79f){_0x1959e2=squel['insert']()[_0xc287('0x5f')](_0xc287('0x60'))[_0xc287('0x61')]([_0xc287('0x62'),_0xc287('0x63'),_0xc287('0x64'),_0xc287('0x65'),_0xc287('0x66'),'createdAt',_0xc287('0x67')],squel['select']()['field'](_0xc287('0x68'),'phone')[_0xc287('0x39')](_0xc287('0x69'),'scheduledAt')[_0xc287('0x39')](_0xc287('0x6a'),_0xc287('0x64'))['field'](_0xc287('0x6b'),'ListId')[_0xc287('0x39')]('ANY_VALUE(VoiceQueueId)',_0xc287('0x66'))['field']('NOW()','createdAt')['field'](_0xc287('0x69'),_0xc287('0x67'))['from'](_0xc287('0x6c'))[_0xc287('0x33')](_0xc287('0x6d'),_0x5d9d0b['params']['id'][_0xc287('0x6e')]())[_0xc287('0x33')](_0xc287('0x6f'),_0x5d9d0b[_0xc287('0x44')][_0xc287('0x70')][_0xc287('0x6e')]())[_0xc287('0x33')](_0xc287('0x71'))[_0xc287('0x33')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0xc287('0x72')]()[_0xc287('0x39')](_0xc287('0x62'))[_0xc287('0x73')](_0xc287('0x60'))[_0xc287('0x33')](_0xc287('0x6d'),_0x5d9d0b['params']['id'][_0xc287('0x6e')]()))[_0xc287('0x33')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0xc287('0x72')]()[_0xc287('0x39')](_0xc287('0x74'))[_0xc287('0x73')](_0xc287('0x6c'))[_0xc287('0x33')](_0xc287('0x6d'),_0x5d9d0b[_0xc287('0x47')]['id'][_0xc287('0x6e')]())[_0xc287('0x33')]('state\x20=\x204'))['group']('ContactId'))[_0xc287('0x6e')]();return db['sequelize']['query'](_0x1959e2);}return[];})['then'](respondWithResult(_0x233508,null))['catch'](handleError(_0x233508,null));};exports[_0xc287('0x75')]=function(_0x40bfda,_0x3ead5f,_0x301f93){return db[_0xc287('0x76')][_0xc287('0x46')]({'where':{'id':_0x40bfda[_0xc287('0x47')]['id']}})[_0xc287('0x22')](handleEntityNotFound(_0x3ead5f,null))[_0xc287('0x22')](function(_0x250b1f){var _0x155aad;if(_0x250b1f){_0x155aad=squel[_0xc287('0x77')]()['into'](_0xc287('0x60'))[_0xc287('0x61')]([_0xc287('0x62'),_0xc287('0x63'),_0xc287('0x64'),_0xc287('0x65'),_0xc287('0x78'),_0xc287('0x79'),_0xc287('0x67')],squel[_0xc287('0x72')]()[_0xc287('0x39')](_0xc287('0x68'),'phone')[_0xc287('0x39')](_0xc287('0x69'),_0xc287('0x63'))[_0xc287('0x39')](_0xc287('0x6a'),_0xc287('0x64'))[_0xc287('0x39')]('ANY_VALUE(ListId)','ListId')[_0xc287('0x39')](_0xc287('0x7a'),'CampaignId')[_0xc287('0x39')](_0xc287('0x69'),_0xc287('0x79'))[_0xc287('0x39')](_0xc287('0x69'),_0xc287('0x67'))['from']('cm_hopper_final')[_0xc287('0x33')](_0xc287('0x7b'),_0x40bfda[_0xc287('0x47')]['id'][_0xc287('0x6e')]())[_0xc287('0x33')]('state\x20=\x20?',_0x40bfda[_0xc287('0x44')][_0xc287('0x70')][_0xc287('0x6e')]())[_0xc287('0x33')]('calleridnum\x20IS\x20NOT\x20NULL')[_0xc287('0x33')](_0xc287('0x7c'),squel[_0xc287('0x72')]()[_0xc287('0x39')](_0xc287('0x62'))[_0xc287('0x73')](_0xc287('0x60'))['where'](_0xc287('0x7b'),_0x40bfda['params']['id']['toString']()))[_0xc287('0x33')](_0xc287('0x7c'),squel[_0xc287('0x72')]()['field']('calleridnum')[_0xc287('0x73')]('cm_hopper_final')[_0xc287('0x33')](_0xc287('0x7b'),_0x40bfda[_0xc287('0x47')]['id'][_0xc287('0x6e')]())[_0xc287('0x33')](_0xc287('0x7d')))[_0xc287('0x7e')](_0xc287('0x64')))[_0xc287('0x6e')]();return db[_0xc287('0x4a')]['query'](_0x155aad);}return[];})[_0xc287('0x22')](respondWithResult(_0x3ead5f,null))[_0xc287('0x3e')](handleError(_0x3ead5f,null));};exports[_0xc287('0x7f')]=function(_0x157c94,_0x222b9d,_0x2da159){return db[_0xc287('0x80')][_0xc287('0x81')]({'where':{'VoiceQueueId':_0x157c94[_0xc287('0x44')][_0xc287('0x66')],'CampaignId':_0x157c94[_0xc287('0x44')][_0xc287('0x78')],'ContactId':_0x157c94[_0xc287('0x44')]['ContactId']}})[_0xc287('0x22')](handleEntityNotFound(_0x222b9d,null))[_0xc287('0x22')](function(_0x17349){if(_0x17349){return _0x17349;}return null;})[_0xc287('0x22')](respondWithResult(_0x222b9d,null))[_0xc287('0x3e')](handleError(_0x222b9d,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff