// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x14a0=['from','cm_hopper_final','VoiceQueueId\x20=\x20?','state\x20=\x20?','state','toString','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','state\x20=\x204','moveContactsIvrCampaignHopperFinal','Campaign','cm_hopper','CampaignId','ANY_VALUE(calleridnum)','ANY_VALUE(CampaignId)','CampaignId\x20=\x20?','calleridnum','checkContactHopper','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','path','sox','to-csv','squel','crypto','jsforce','querystring','../../components/parsers/qs','api','../../config/utils','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','error','stack','name','send','index','CmHopperFinal','rawAttributes','keys','query','filters','intersection','model','fields','attributes','length','nolimit','order','sort','where','pick','merge','map','type','key','VIRTUAL','field','filter','options','include','rows','catch','show','params','find','describe','body','uniqueid','findAll','sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noSuchContacts','`state`\x20=\x203,\x201,\x20null','noAnswerContacts','busyContacts','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=\x205,\x201,\x20null','moveContactsQueueCampaignHopperFinal','VoiceQueue','insert','into','fromQuery','scheduledAt','ContactId','ListId','VoiceQueueId','createdAt','updatedAt','select','phone','NOW()','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','ANY_VALUE(VoiceQueueId)'];(function(_0x40f8a6,_0x3e34ad){var _0x4fe718=function(_0x41ee8e){while(--_0x41ee8e){_0x40f8a6['push'](_0x40f8a6['shift']());}};_0x4fe718(++_0x3e34ad);}(_0x14a0,0x8e));var _0x014a=function(_0xc48cb8,_0x20bb64){_0xc48cb8=_0xc48cb8-0x0;var _0x28690f=_0x14a0[_0xc48cb8];return _0x28690f;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x014a('0x0'));var rimraf=require(_0x014a('0x1'));var zipdir=require(_0x014a('0x2'));var jsonpatch=require(_0x014a('0x3'));var rp=require(_0x014a('0x4'));var moment=require(_0x014a('0x5'));var BPromise=require(_0x014a('0x6'));var Mustache=require('mustache');var util=require('util');var path=require(_0x014a('0x7'));var sox=require(_0x014a('0x8'));var csv=require(_0x014a('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x014a('0xa'));var crypto=require(_0x014a('0xb'));var jsforce=require(_0x014a('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x014a('0xd'));var Papa=require('papaparse');var authService=require('../../components/auth/service');var hardwareService=require('../../config/license/hardware');var Redis=require('ioredis');var qs=require(_0x014a('0xe'));var logger=require('../../config/logger')(_0x014a('0xf'));var utils=require(_0x014a('0x10'));var config=require('../../config/environment');var db=require(_0x014a('0x11'))['db'];function respondWithStatusCode(_0x166677,_0x2c84ad){_0x2c84ad=_0x2c84ad||0xcc;return function(_0x43bfeb){if(_0x43bfeb){return _0x166677[_0x014a('0x12')](_0x2c84ad);}return _0x166677[_0x014a('0x13')](_0x2c84ad)[_0x014a('0x14')]();};}function respondWithResult(_0x23c917,_0x1e5366){_0x1e5366=_0x1e5366||0xc8;return function(_0x71535d){if(_0x71535d){return _0x23c917[_0x014a('0x13')](_0x1e5366)[_0x014a('0x15')](_0x71535d);}};}function respondWithFilteredResult(_0x4fe87c,_0x130d13){return function(_0x3cf92f){if(_0x3cf92f){var _0x59f207=_0x3cf92f[_0x014a('0x16')],_0x3a836f=_0x130d13[_0x014a('0x17')],_0x128c46=_0x130d13[_0x014a('0x17')]+_0x130d13[_0x014a('0x18')],_0x59a4ea;if(_0x128c46>=_0x59f207){_0x128c46=_0x59f207;_0x59a4ea=0xc8;}else{_0x59a4ea=0xce;}_0x4fe87c[_0x014a('0x13')](_0x59a4ea);return _0x4fe87c[_0x014a('0x19')](_0x014a('0x1a'),_0x3a836f+'-'+_0x128c46+'/'+_0x59f207)[_0x014a('0x15')](_0x3cf92f);}return null;};}function patchUpdates(_0x16490a){return function(_0x3b9341){try{jsonpatch[_0x014a('0x1b')](_0x3b9341,_0x16490a,!![]);}catch(_0x89e132){return BPromise[_0x014a('0x1c')](_0x89e132);}return _0x3b9341[_0x014a('0x1d')]();};}function saveUpdates(_0x5c69c5,_0x359903){return function(_0x109a9c){if(_0x109a9c){return _0x109a9c[_0x014a('0x1e')](_0x5c69c5)[_0x014a('0x1f')](function(_0xc9a563){return _0xc9a563;});}return null;};}function removeEntity(_0x2d7ccd,_0x37c3d1){return function(_0x3dd2d0){if(_0x3dd2d0){return _0x3dd2d0[_0x014a('0x20')]()['then'](function(){_0x2d7ccd[_0x014a('0x13')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1a1318,_0x26718b){return function(_0x44d921){if(!_0x44d921){_0x1a1318[_0x014a('0x12')](0x194);}return _0x44d921;};}function handleError(_0x2b3c10,_0x113b12){_0x113b12=_0x113b12||0x1f4;return function(_0x3fec9f){logger[_0x014a('0x21')](_0x3fec9f[_0x014a('0x22')]);if(_0x3fec9f['name']){delete _0x3fec9f[_0x014a('0x23')];}_0x2b3c10['status'](_0x113b12)[_0x014a('0x24')](_0x3fec9f);};}exports[_0x014a('0x25')]=function(_0x4f1c44,_0x4ee195){var _0x9a901f={},_0x3f9719={},_0x143346={'count':0x0,'rows':[]};var _0x5ed71b=db[_0x014a('0x26')][_0x014a('0x27')];_0x3f9719['model']=_[_0x014a('0x28')](_0x5ed71b);_0x3f9719[_0x014a('0x29')]=_['keys'](_0x4f1c44['query']);_0x3f9719[_0x014a('0x2a')]=_[_0x014a('0x2b')](_0x3f9719[_0x014a('0x2c')],_0x3f9719[_0x014a('0x29')]);_0x9a901f['attributes']=_[_0x014a('0x2b')](_0x3f9719[_0x014a('0x2c')],qs[_0x014a('0x2d')](_0x4f1c44[_0x014a('0x29')][_0x014a('0x2d')]));_0x9a901f[_0x014a('0x2e')]=_0x9a901f[_0x014a('0x2e')][_0x014a('0x2f')]?_0x9a901f[_0x014a('0x2e')]:_0x3f9719[_0x014a('0x2c')];if(!_0x4f1c44[_0x014a('0x29')]['hasOwnProperty'](_0x014a('0x30'))){_0x9a901f[_0x014a('0x18')]=qs[_0x014a('0x18')](_0x4f1c44[_0x014a('0x29')][_0x014a('0x18')]);_0x9a901f[_0x014a('0x17')]=qs[_0x014a('0x17')](_0x4f1c44['query'][_0x014a('0x17')]);}_0x9a901f[_0x014a('0x31')]=qs['sort'](_0x4f1c44[_0x014a('0x29')][_0x014a('0x32')]);_0x9a901f[_0x014a('0x33')]=qs[_0x014a('0x2a')](_[_0x014a('0x34')](_0x4f1c44[_0x014a('0x29')],_0x3f9719[_0x014a('0x2a')]));if(_0x4f1c44[_0x014a('0x29')]['filter']){_0x9a901f[_0x014a('0x33')]=_[_0x014a('0x35')](_0x9a901f[_0x014a('0x33')],{'$or':_[_0x014a('0x36')](_0x5ed71b,function(_0x5127f3){if(_0x5127f3[_0x014a('0x37')][_0x014a('0x38')]!==_0x014a('0x39')){var _0x157bd0={};_0x157bd0[_0x5127f3[_0x014a('0x3a')]]={'$like':'%'+_0x4f1c44[_0x014a('0x29')][_0x014a('0x3b')]+'%'};return _0x157bd0;}})});}_0x9a901f=_[_0x014a('0x35')]({},_0x9a901f,_0x4f1c44[_0x014a('0x3c')]);var _0x5f2f66={'where':_0x9a901f[_0x014a('0x33')]};return db['CmHopperFinal'][_0x014a('0x16')](_0x5f2f66)[_0x014a('0x1f')](function(_0x44958f){_0x143346[_0x014a('0x16')]=_0x44958f;if(_0x4f1c44[_0x014a('0x29')]['includeAll']){_0x9a901f[_0x014a('0x3d')]=[{'all':!![]}];}return db[_0x014a('0x26')]['findAll'](_0x9a901f);})[_0x014a('0x1f')](function(_0x2990df){_0x143346[_0x014a('0x3e')]=_0x2990df;return _0x143346;})[_0x014a('0x1f')](respondWithFilteredResult(_0x4ee195,_0x9a901f))[_0x014a('0x3f')](handleError(_0x4ee195,null));};exports[_0x014a('0x40')]=function(_0x17b1b6,_0x764fbe){var _0x2beddc={'raw':!![],'where':{'id':_0x17b1b6[_0x014a('0x41')]['id']}},_0x537bde={};_0x537bde[_0x014a('0x2c')]=_[_0x014a('0x28')](db[_0x014a('0x26')]['rawAttributes']);_0x537bde[_0x014a('0x29')]=_[_0x014a('0x28')](_0x17b1b6[_0x014a('0x29')]);_0x537bde[_0x014a('0x2a')]=_[_0x014a('0x2b')](_0x537bde[_0x014a('0x2c')],_0x537bde['query']);_0x2beddc[_0x014a('0x2e')]=_[_0x014a('0x2b')](_0x537bde['model'],qs[_0x014a('0x2d')](_0x17b1b6[_0x014a('0x29')][_0x014a('0x2d')]));_0x2beddc['attributes']=_0x2beddc[_0x014a('0x2e')]['length']?_0x2beddc['attributes']:_0x537bde[_0x014a('0x2c')];if(_0x17b1b6[_0x014a('0x29')]['includeAll']){_0x2beddc[_0x014a('0x3d')]=[{'all':!![]}];}_0x2beddc=_[_0x014a('0x35')]({},_0x2beddc,_0x17b1b6[_0x014a('0x3c')]);return db[_0x014a('0x26')][_0x014a('0x42')](_0x2beddc)[_0x014a('0x1f')](handleEntityNotFound(_0x764fbe,null))['then'](respondWithResult(_0x764fbe,null))[_0x014a('0x3f')](handleError(_0x764fbe,null));};exports[_0x014a('0x43')]=function(_0xb29df2,_0x52677e){return db['CmHopperFinal'][_0x014a('0x43')]()['then'](respondWithResult(_0x52677e,null))['catch'](handleError(_0x52677e,null));};exports[_0x014a('0x1e')]=function(_0x47aaac,_0x2a4679){if(_0x47aaac[_0x014a('0x44')][_0x014a('0x45')]){delete _0x47aaac['body'][_0x014a('0x45')];}return db[_0x014a('0x26')][_0x014a('0x42')]({'where':{'uniqueid':_0x47aaac[_0x014a('0x41')]['id']}})[_0x014a('0x1f')](handleEntityNotFound(_0x2a4679,null))[_0x014a('0x1f')](saveUpdates(_0x47aaac['body'],null))[_0x014a('0x1f')](respondWithResult(_0x2a4679,null))[_0x014a('0x3f')](handleError(_0x2a4679,null));};exports['countContactsQueueCampaignHopperFinal']=function(_0x1a4df9,_0x29345b,_0x20bb0c){return db[_0x014a('0x26')][_0x014a('0x46')]({'raw':![],'where':{'VoiceQueueId':_0x1a4df9[_0x014a('0x41')]['id']},'attributes':[[db[_0x014a('0x47')]['fn'](_0x014a('0x48'),db['sequelize']['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')](_0x014a('0x4a')))),_0x014a('0x4b')],[db[_0x014a('0x47')]['fn']('COUNT',db[_0x014a('0x47')]['fn']('IF',db['sequelize'][_0x014a('0x49')](_0x014a('0x4c')))),_0x014a('0x4d')],[db[_0x014a('0x47')]['fn'](_0x014a('0x48'),db['sequelize']['fn']('IF',db['sequelize']['literal']('`state`\x20=\x205,\x201,\x20null'))),_0x014a('0x4e')],[db['sequelize']['fn'](_0x014a('0x48'),db['sequelize']['fn']('IF',db['sequelize'][_0x014a('0x49')]('`state`\x20=\x208,\x201,\x20null'))),_0x014a('0x4f')],[db[_0x014a('0x47')]['fn'](_0x014a('0x48'),db[_0x014a('0x47')]['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')](_0x014a('0x50')))),_0x014a('0x51')],[db[_0x014a('0x47')]['fn'](_0x014a('0x48'),db['sequelize']['fn']('IF',db['sequelize'][_0x014a('0x49')](_0x014a('0x52')))),_0x014a('0x53')],[db['sequelize']['fn']('COUNT',db[_0x014a('0x47')]['fn']('IF',db['sequelize'][_0x014a('0x49')](_0x014a('0x54')))),_0x014a('0x55')],[db[_0x014a('0x47')]['fn']('COUNT',db[_0x014a('0x47')]['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')]('`state`\x20=\x2019,\x201,\x20null'))),_0x014a('0x56')]]})['then'](handleEntityNotFound(_0x29345b,null))[_0x014a('0x1f')](respondWithResult(_0x29345b,null))[_0x014a('0x3f')](handleError(_0x29345b,null));};exports[_0x014a('0x57')]=function(_0x24d433,_0xd0334a,_0x1a308b){return db['CmHopperFinal'][_0x014a('0x46')]({'raw':![],'where':{'CampaignId':_0x24d433[_0x014a('0x41')]['id']},'attributes':[[db[_0x014a('0x47')]['fn']('COUNT',db[_0x014a('0x47')]['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')](_0x014a('0x4a')))),_0x014a('0x4b')],[db['sequelize']['fn'](_0x014a('0x48'),db[_0x014a('0x47')]['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')](_0x014a('0x4c')))),_0x014a('0x4d')],[db[_0x014a('0x47')]['fn'](_0x014a('0x48'),db[_0x014a('0x47')]['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')](_0x014a('0x58')))),'busyContacts'],[db[_0x014a('0x47')]['fn']('COUNT',db['sequelize']['fn']('IF',db['sequelize']['literal']('`state`\x20=\x208,\x201,\x20null'))),_0x014a('0x4f')],[db[_0x014a('0x47')]['fn'](_0x014a('0x48'),db['sequelize']['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')](_0x014a('0x50')))),_0x014a('0x51')],[db['sequelize']['fn']('COUNT',db[_0x014a('0x47')]['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')](_0x014a('0x52')))),_0x014a('0x53')],[db[_0x014a('0x47')]['fn'](_0x014a('0x48'),db[_0x014a('0x47')]['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')](_0x014a('0x54')))),'reCallContacts'],[db[_0x014a('0x47')]['fn'](_0x014a('0x48'),db['sequelize']['fn']('IF',db[_0x014a('0x47')][_0x014a('0x49')]('`state`\x20=\x2019,\x201,\x20null'))),_0x014a('0x56')]]})['then'](handleEntityNotFound(_0xd0334a,null))[_0x014a('0x1f')](respondWithResult(_0xd0334a,null))[_0x014a('0x3f')](handleError(_0xd0334a,null));};exports[_0x014a('0x59')]=function(_0x456d69,_0x37b8f,_0x5e0f22){return db[_0x014a('0x5a')][_0x014a('0x42')]({'where':{'id':_0x456d69[_0x014a('0x41')]['id']}})[_0x014a('0x1f')](handleEntityNotFound(_0x37b8f,null))[_0x014a('0x1f')](function(_0x52e79e){var _0x20cddc;if(_0x52e79e){_0x20cddc=squel[_0x014a('0x5b')]()[_0x014a('0x5c')]('cm_hopper')[_0x014a('0x5d')](['phone',_0x014a('0x5e'),_0x014a('0x5f'),_0x014a('0x60'),_0x014a('0x61'),_0x014a('0x62'),_0x014a('0x63')],squel[_0x014a('0x64')]()['field']('ANY_VALUE(calleridnum)',_0x014a('0x65'))['field'](_0x014a('0x66'),'scheduledAt')[_0x014a('0x3a')](_0x014a('0x67'),'ContactId')['field'](_0x014a('0x68'),_0x014a('0x60'))['field'](_0x014a('0x69'),_0x014a('0x61'))['field']('NOW()',_0x014a('0x62'))[_0x014a('0x3a')](_0x014a('0x66'),_0x014a('0x63'))[_0x014a('0x6a')](_0x014a('0x6b'))['where'](_0x014a('0x6c'),_0x456d69['params']['id']['toString']())[_0x014a('0x33')](_0x014a('0x6d'),_0x456d69['body'][_0x014a('0x6e')][_0x014a('0x6f')]())[_0x014a('0x33')](_0x014a('0x70'))[_0x014a('0x33')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x014a('0x64')]()[_0x014a('0x3a')](_0x014a('0x65'))[_0x014a('0x6a')]('cm_hopper')[_0x014a('0x33')]('VoiceQueueId\x20=\x20?',_0x456d69[_0x014a('0x41')]['id'][_0x014a('0x6f')]()))[_0x014a('0x33')](_0x014a('0x71'),squel[_0x014a('0x64')]()[_0x014a('0x3a')]('calleridnum')[_0x014a('0x6a')](_0x014a('0x6b'))[_0x014a('0x33')](_0x014a('0x6c'),_0x456d69[_0x014a('0x41')]['id'][_0x014a('0x6f')]())[_0x014a('0x33')](_0x014a('0x72')))['group'](_0x014a('0x5f')))[_0x014a('0x6f')]();return db[_0x014a('0x47')]['query'](_0x20cddc);}return[];})[_0x014a('0x1f')](respondWithResult(_0x37b8f,null))[_0x014a('0x3f')](handleError(_0x37b8f,null));};exports[_0x014a('0x73')]=function(_0x63c48e,_0x6f7932,_0x161094){return db[_0x014a('0x74')]['find']({'where':{'id':_0x63c48e['params']['id']}})['then'](handleEntityNotFound(_0x6f7932,null))['then'](function(_0x194c8d){var _0x32683c;if(_0x194c8d){_0x32683c=squel[_0x014a('0x5b')]()[_0x014a('0x5c')](_0x014a('0x75'))[_0x014a('0x5d')]([_0x014a('0x65'),'scheduledAt',_0x014a('0x5f'),_0x014a('0x60'),_0x014a('0x76'),_0x014a('0x62'),'updatedAt'],squel['select']()[_0x014a('0x3a')](_0x014a('0x77'),'phone')['field'](_0x014a('0x66'),'scheduledAt')['field'](_0x014a('0x67'),_0x014a('0x5f'))['field'](_0x014a('0x68'),_0x014a('0x60'))[_0x014a('0x3a')](_0x014a('0x78'),_0x014a('0x76'))[_0x014a('0x3a')](_0x014a('0x66'),_0x014a('0x62'))['field']('NOW()',_0x014a('0x63'))['from']('cm_hopper_final')['where'](_0x014a('0x79'),_0x63c48e[_0x014a('0x41')]['id'][_0x014a('0x6f')]())['where'](_0x014a('0x6d'),_0x63c48e[_0x014a('0x44')][_0x014a('0x6e')][_0x014a('0x6f')]())['where'](_0x014a('0x70'))[_0x014a('0x33')](_0x014a('0x71'),squel['select']()[_0x014a('0x3a')](_0x014a('0x65'))['from'](_0x014a('0x75'))[_0x014a('0x33')](_0x014a('0x79'),_0x63c48e['params']['id'][_0x014a('0x6f')]()))[_0x014a('0x33')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0x014a('0x64')]()[_0x014a('0x3a')](_0x014a('0x7a'))[_0x014a('0x6a')](_0x014a('0x6b'))[_0x014a('0x33')](_0x014a('0x79'),_0x63c48e[_0x014a('0x41')]['id']['toString']())[_0x014a('0x33')](_0x014a('0x72')))['group']('ContactId'))[_0x014a('0x6f')]();return db[_0x014a('0x47')]['query'](_0x32683c);}return[];})[_0x014a('0x1f')](respondWithResult(_0x6f7932,null))[_0x014a('0x3f')](handleError(_0x6f7932,null));};exports[_0x014a('0x7b')]=function(_0x5ddb47,_0x3a0012,_0x2c320f){return db['CmHopper']['findOne']({'where':{'VoiceQueueId':_0x5ddb47[_0x014a('0x44')]['VoiceQueueId'],'CampaignId':_0x5ddb47[_0x014a('0x44')]['CampaignId'],'ContactId':_0x5ddb47[_0x014a('0x44')][_0x014a('0x5f')]}})[_0x014a('0x1f')](handleEntityNotFound(_0x3a0012,null))[_0x014a('0x1f')](function(_0x20b182){if(_0x20b182){return _0x20b182;}return null;})['then'](respondWithResult(_0x3a0012,null))[_0x014a('0x3f')](handleError(_0x3a0012,null));};
\ No newline at end of file
+var _0x36ee=['../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','count','offset','set','json','apply','reject','save','update','then','destroy','error','stack','name','send','index','CmHopperFinal','model','query','fields','attributes','hasOwnProperty','nolimit','limit','order','filters','filter','where','map','type','VIRTUAL','field','merge','includeAll','include','findAll','rows','catch','show','params','keys','rawAttributes','intersection','length','options','find','describe','body','uniqueid','countContactsQueueCampaignHopperFinal','sequelize','COUNT','literal','`state`\x20=\x200,\x201,\x20null','noAnswerContacts','`state`\x20=\x205,\x201,\x20null','busyContacts','`state`\x20=\x208,\x201,\x20null','congestionContacts','`state`\x20=\x2011\x20,\x201,\x20null','abandonedContacts','reCallContacts','`state`\x20=\x2019,\x201,\x20null','answeringMachine','countContactsIvrCampaignHopperFinal','noSuchContacts','`state`\x20=\x203,\x201,\x20null','`state`\x20=\x2010\x20,\x201,\x20null','dropContacts','`state`\x20=\x2022,\x201,\x20null','insert','into','cm_hopper','phone','ContactId','VoiceQueueId','createdAt','updatedAt','select','NOW()','scheduledAt','ANY_VALUE(ContactId)','ANY_VALUE(ListId)','cm_hopper_final','toString','state\x20=\x20?','state','calleridnum\x20IS\x20NOT\x20NULL','calleridnum\x20NOT\x20IN\x20(?)','VoiceQueueId\x20=\x20?','calleridnum','state\x20=\x204','moveContactsIvrCampaignHopperFinal','CampaignId','ANY_VALUE(calleridnum)','ListId','ANY_VALUE(CampaignId)','from','CampaignId\x20=\x20?','checkContactHopper','findOne','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','jsforce','querystring','papaparse','../../config/license/hardware','../../components/parsers/qs','../../config/logger','api'];(function(_0x444c8d,_0x59e159){var _0x237759=function(_0x364858){while(--_0x364858){_0x444c8d['push'](_0x444c8d['shift']());}};_0x237759(++_0x59e159);}(_0x36ee,0xe8));var _0xe36e=function(_0x3b380d,_0x4bf247){_0x3b380d=_0x3b380d-0x0;var _0x54502b=_0x36ee[_0x3b380d];return _0x54502b;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0xe36e('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0xe36e('0x1'));var rp=require(_0xe36e('0x2'));var moment=require(_0xe36e('0x3'));var BPromise=require(_0xe36e('0x4'));var Mustache=require(_0xe36e('0x5'));var util=require(_0xe36e('0x6'));var path=require(_0xe36e('0x7'));var sox=require(_0xe36e('0x8'));var csv=require(_0xe36e('0x9'));var ejs=require(_0xe36e('0xa'));var fs=require('fs');var _=require(_0xe36e('0xb'));var squel=require(_0xe36e('0xc'));var crypto=require('crypto');var jsforce=require(_0xe36e('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xe36e('0x9'));var querystring=require(_0xe36e('0xe'));var Papa=require(_0xe36e('0xf'));var authService=require('../../components/auth/service');var hardwareService=require(_0xe36e('0x10'));var Redis=require('ioredis');var qs=require(_0xe36e('0x11'));var logger=require(_0xe36e('0x12'))(_0xe36e('0x13'));var utils=require(_0xe36e('0x14'));var config=require(_0xe36e('0x15'));var db=require(_0xe36e('0x16'))['db'];function respondWithStatusCode(_0x3f6d7f,_0x265473){_0x265473=_0x265473||0xcc;return function(_0x4fbdb2){if(_0x4fbdb2){return _0x3f6d7f[_0xe36e('0x17')](_0x265473);}return _0x3f6d7f[_0xe36e('0x18')](_0x265473)[_0xe36e('0x19')]();};}function respondWithResult(_0x1fdea2,_0x5c3f3c){_0x5c3f3c=_0x5c3f3c||0xc8;return function(_0x3e264a){if(_0x3e264a){return _0x1fdea2['status'](_0x5c3f3c)['json'](_0x3e264a);}};}function respondWithFilteredResult(_0x27ff47,_0x300f21){return function(_0x26fb37){if(_0x26fb37){var _0x278135=_0x26fb37[_0xe36e('0x1a')],_0xd6828e=_0x300f21[_0xe36e('0x1b')],_0x924cd5=_0x300f21[_0xe36e('0x1b')]+_0x300f21['limit'],_0x2096f6;if(_0x924cd5>=_0x278135){_0x924cd5=_0x278135;_0x2096f6=0xc8;}else{_0x2096f6=0xce;}_0x27ff47[_0xe36e('0x18')](_0x2096f6);return _0x27ff47[_0xe36e('0x1c')]('Content-Range',_0xd6828e+'-'+_0x924cd5+'/'+_0x278135)[_0xe36e('0x1d')](_0x26fb37);}return null;};}function patchUpdates(_0x533c06){return function(_0x471400){try{jsonpatch[_0xe36e('0x1e')](_0x471400,_0x533c06,!![]);}catch(_0x5e15f5){return BPromise[_0xe36e('0x1f')](_0x5e15f5);}return _0x471400[_0xe36e('0x20')]();};}function saveUpdates(_0x21efe7,_0x597331){return function(_0x21e95e){if(_0x21e95e){return _0x21e95e[_0xe36e('0x21')](_0x21efe7)[_0xe36e('0x22')](function(_0x3c4017){return _0x3c4017;});}return null;};}function removeEntity(_0x2c4e30,_0x360b95){return function(_0x4f438a){if(_0x4f438a){return _0x4f438a[_0xe36e('0x23')]()[_0xe36e('0x22')](function(){_0x2c4e30[_0xe36e('0x18')](0xcc)[_0xe36e('0x19')]();});}};}function handleEntityNotFound(_0x437f3f,_0x53e13a){return function(_0x598a7a){if(!_0x598a7a){_0x437f3f[_0xe36e('0x17')](0x194);}return _0x598a7a;};}function handleError(_0x10818d,_0xb0cd85){_0xb0cd85=_0xb0cd85||0x1f4;return function(_0xb32195){logger[_0xe36e('0x24')](_0xb32195[_0xe36e('0x25')]);if(_0xb32195[_0xe36e('0x26')]){delete _0xb32195['name'];}_0x10818d[_0xe36e('0x18')](_0xb0cd85)[_0xe36e('0x27')](_0xb32195);};}exports[_0xe36e('0x28')]=function(_0x262caa,_0x5e58d8){var _0x2d757c={},_0x5a3133={},_0xf7b02e={'count':0x0,'rows':[]};var _0x5993de=db[_0xe36e('0x29')]['rawAttributes'];_0x5a3133[_0xe36e('0x2a')]=_['keys'](_0x5993de);_0x5a3133[_0xe36e('0x2b')]=_['keys'](_0x262caa['query']);_0x5a3133['filters']=_['intersection'](_0x5a3133[_0xe36e('0x2a')],_0x5a3133[_0xe36e('0x2b')]);_0x2d757c['attributes']=_['intersection'](_0x5a3133[_0xe36e('0x2a')],qs[_0xe36e('0x2c')](_0x262caa[_0xe36e('0x2b')][_0xe36e('0x2c')]));_0x2d757c[_0xe36e('0x2d')]=_0x2d757c[_0xe36e('0x2d')]['length']?_0x2d757c[_0xe36e('0x2d')]:_0x5a3133[_0xe36e('0x2a')];if(!_0x262caa['query'][_0xe36e('0x2e')](_0xe36e('0x2f'))){_0x2d757c[_0xe36e('0x30')]=qs[_0xe36e('0x30')](_0x262caa[_0xe36e('0x2b')][_0xe36e('0x30')]);_0x2d757c[_0xe36e('0x1b')]=qs[_0xe36e('0x1b')](_0x262caa[_0xe36e('0x2b')][_0xe36e('0x1b')]);}_0x2d757c[_0xe36e('0x31')]=qs['sort'](_0x262caa[_0xe36e('0x2b')]['sort']);_0x2d757c['where']=qs[_0xe36e('0x32')](_['pick'](_0x262caa[_0xe36e('0x2b')],_0x5a3133[_0xe36e('0x32')]));if(_0x262caa[_0xe36e('0x2b')][_0xe36e('0x33')]){_0x2d757c['where']=_['merge'](_0x2d757c[_0xe36e('0x34')],{'$or':_[_0xe36e('0x35')](_0x5993de,function(_0x19a53f){if(_0x19a53f[_0xe36e('0x36')]['key']!==_0xe36e('0x37')){var _0x2f828e={};_0x2f828e[_0x19a53f[_0xe36e('0x38')]]={'$like':'%'+_0x262caa['query'][_0xe36e('0x33')]+'%'};return _0x2f828e;}})});}_0x2d757c=_[_0xe36e('0x39')]({},_0x2d757c,_0x262caa['options']);var _0x40cbe5={'where':_0x2d757c[_0xe36e('0x34')]};return db[_0xe36e('0x29')][_0xe36e('0x1a')](_0x40cbe5)[_0xe36e('0x22')](function(_0x2fc909){_0xf7b02e[_0xe36e('0x1a')]=_0x2fc909;if(_0x262caa[_0xe36e('0x2b')][_0xe36e('0x3a')]){_0x2d757c[_0xe36e('0x3b')]=[{'all':!![]}];}return db[_0xe36e('0x29')][_0xe36e('0x3c')](_0x2d757c);})[_0xe36e('0x22')](function(_0x5f396c){_0xf7b02e[_0xe36e('0x3d')]=_0x5f396c;return _0xf7b02e;})[_0xe36e('0x22')](respondWithFilteredResult(_0x5e58d8,_0x2d757c))[_0xe36e('0x3e')](handleError(_0x5e58d8,null));};exports[_0xe36e('0x3f')]=function(_0x295feb,_0x4d133b){var _0x591e33={'raw':!![],'where':{'id':_0x295feb[_0xe36e('0x40')]['id']}},_0x4094c6={};_0x4094c6[_0xe36e('0x2a')]=_[_0xe36e('0x41')](db[_0xe36e('0x29')][_0xe36e('0x42')]);_0x4094c6[_0xe36e('0x2b')]=_[_0xe36e('0x41')](_0x295feb['query']);_0x4094c6[_0xe36e('0x32')]=_[_0xe36e('0x43')](_0x4094c6['model'],_0x4094c6[_0xe36e('0x2b')]);_0x591e33['attributes']=_[_0xe36e('0x43')](_0x4094c6[_0xe36e('0x2a')],qs[_0xe36e('0x2c')](_0x295feb[_0xe36e('0x2b')][_0xe36e('0x2c')]));_0x591e33['attributes']=_0x591e33[_0xe36e('0x2d')][_0xe36e('0x44')]?_0x591e33[_0xe36e('0x2d')]:_0x4094c6[_0xe36e('0x2a')];if(_0x295feb[_0xe36e('0x2b')][_0xe36e('0x3a')]){_0x591e33['include']=[{'all':!![]}];}_0x591e33=_[_0xe36e('0x39')]({},_0x591e33,_0x295feb[_0xe36e('0x45')]);return db[_0xe36e('0x29')][_0xe36e('0x46')](_0x591e33)[_0xe36e('0x22')](handleEntityNotFound(_0x4d133b,null))['then'](respondWithResult(_0x4d133b,null))[_0xe36e('0x3e')](handleError(_0x4d133b,null));};exports[_0xe36e('0x47')]=function(_0x390d9d,_0x9debd7){return db[_0xe36e('0x29')][_0xe36e('0x47')]()[_0xe36e('0x22')](respondWithResult(_0x9debd7,null))[_0xe36e('0x3e')](handleError(_0x9debd7,null));};exports[_0xe36e('0x21')]=function(_0x52e744,_0x56956c){if(_0x52e744[_0xe36e('0x48')]['uniqueid']){delete _0x52e744[_0xe36e('0x48')][_0xe36e('0x49')];}return db[_0xe36e('0x29')][_0xe36e('0x46')]({'where':{'uniqueid':_0x52e744['params']['id']}})[_0xe36e('0x22')](handleEntityNotFound(_0x56956c,null))[_0xe36e('0x22')](saveUpdates(_0x52e744['body'],null))[_0xe36e('0x22')](respondWithResult(_0x56956c,null))[_0xe36e('0x3e')](handleError(_0x56956c,null));};exports[_0xe36e('0x4a')]=function(_0x42eae5,_0x15895d,_0x3bc458){return db[_0xe36e('0x29')][_0xe36e('0x3c')]({'raw':![],'where':{'VoiceQueueId':_0x42eae5[_0xe36e('0x40')]['id']},'attributes':[[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')](_0xe36e('0x4e')))),'noSuchContacts'],[db[_0xe36e('0x4b')]['fn']('COUNT',db['sequelize']['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')]('`state`\x20=\x203,\x201,\x20null'))),_0xe36e('0x4f')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')](_0xe36e('0x50')))),_0xe36e('0x51')],[db[_0xe36e('0x4b')]['fn']('COUNT',db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')]['literal'](_0xe36e('0x52')))),_0xe36e('0x53')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db['sequelize']['literal']('`state`\x20=\x2010\x20,\x201,\x20null'))),'dropContacts'],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')](_0xe36e('0x54')))),_0xe36e('0x55')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db['sequelize']['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')]('`state`\x20=\x2022,\x201,\x20null'))),_0xe36e('0x56')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')](_0xe36e('0x57')))),_0xe36e('0x58')]]})[_0xe36e('0x22')](handleEntityNotFound(_0x15895d,null))[_0xe36e('0x22')](respondWithResult(_0x15895d,null))[_0xe36e('0x3e')](handleError(_0x15895d,null));};exports[_0xe36e('0x59')]=function(_0x389e91,_0x6f979f,_0x3512ec){return db[_0xe36e('0x29')][_0xe36e('0x3c')]({'raw':![],'where':{'CampaignId':_0x389e91[_0xe36e('0x40')]['id']},'attributes':[[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')](_0xe36e('0x4e')))),_0xe36e('0x5a')],[db['sequelize']['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db['sequelize'][_0xe36e('0x4d')](_0xe36e('0x5b')))),_0xe36e('0x4f')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db['sequelize'][_0xe36e('0x4d')]('`state`\x20=\x205,\x201,\x20null'))),_0xe36e('0x51')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')](_0xe36e('0x52')))),_0xe36e('0x53')],[db['sequelize']['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db['sequelize'][_0xe36e('0x4d')](_0xe36e('0x5c')))),_0xe36e('0x5d')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')]['literal'](_0xe36e('0x54')))),_0xe36e('0x55')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db[_0xe36e('0x4b')]['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')](_0xe36e('0x5e')))),_0xe36e('0x56')],[db[_0xe36e('0x4b')]['fn'](_0xe36e('0x4c'),db['sequelize']['fn']('IF',db[_0xe36e('0x4b')][_0xe36e('0x4d')](_0xe36e('0x57')))),_0xe36e('0x58')]]})['then'](handleEntityNotFound(_0x6f979f,null))['then'](respondWithResult(_0x6f979f,null))[_0xe36e('0x3e')](handleError(_0x6f979f,null));};exports['moveContactsQueueCampaignHopperFinal']=function(_0x585bd5,_0x59c454,_0xe0a282){return db['VoiceQueue'][_0xe36e('0x46')]({'where':{'id':_0x585bd5[_0xe36e('0x40')]['id']}})[_0xe36e('0x22')](handleEntityNotFound(_0x59c454,null))[_0xe36e('0x22')](function(_0x1bd60d){var _0x46f789;if(_0x1bd60d){_0x46f789=squel[_0xe36e('0x5f')]()[_0xe36e('0x60')](_0xe36e('0x61'))['fromQuery']([_0xe36e('0x62'),'scheduledAt',_0xe36e('0x63'),'ListId',_0xe36e('0x64'),_0xe36e('0x65'),_0xe36e('0x66')],squel[_0xe36e('0x67')]()['field']('ANY_VALUE(calleridnum)',_0xe36e('0x62'))[_0xe36e('0x38')](_0xe36e('0x68'),_0xe36e('0x69'))[_0xe36e('0x38')](_0xe36e('0x6a'),'ContactId')[_0xe36e('0x38')](_0xe36e('0x6b'),'ListId')[_0xe36e('0x38')]('ANY_VALUE(VoiceQueueId)',_0xe36e('0x64'))[_0xe36e('0x38')](_0xe36e('0x68'),_0xe36e('0x65'))['field'](_0xe36e('0x68'),'updatedAt')['from'](_0xe36e('0x6c'))[_0xe36e('0x34')]('VoiceQueueId\x20=\x20?',_0x585bd5['params']['id'][_0xe36e('0x6d')]())['where'](_0xe36e('0x6e'),_0x585bd5[_0xe36e('0x48')][_0xe36e('0x6f')][_0xe36e('0x6d')]())[_0xe36e('0x34')](_0xe36e('0x70'))['where'](_0xe36e('0x71'),squel[_0xe36e('0x67')]()[_0xe36e('0x38')](_0xe36e('0x62'))['from'](_0xe36e('0x61'))[_0xe36e('0x34')](_0xe36e('0x72'),_0x585bd5[_0xe36e('0x40')]['id']['toString']()))[_0xe36e('0x34')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0xe36e('0x67')]()['field'](_0xe36e('0x73'))['from']('cm_hopper_final')[_0xe36e('0x34')](_0xe36e('0x72'),_0x585bd5[_0xe36e('0x40')]['id']['toString']())[_0xe36e('0x34')](_0xe36e('0x74')))['group'](_0xe36e('0x63')))[_0xe36e('0x6d')]();return db[_0xe36e('0x4b')]['query'](_0x46f789);}return[];})['then'](respondWithResult(_0x59c454,null))[_0xe36e('0x3e')](handleError(_0x59c454,null));};exports[_0xe36e('0x75')]=function(_0x3bd3c2,_0x327506,_0x411305){return db['Campaign'][_0xe36e('0x46')]({'where':{'id':_0x3bd3c2[_0xe36e('0x40')]['id']}})[_0xe36e('0x22')](handleEntityNotFound(_0x327506,null))[_0xe36e('0x22')](function(_0xdc59c5){var _0x5bdeea;if(_0xdc59c5){_0x5bdeea=squel[_0xe36e('0x5f')]()[_0xe36e('0x60')](_0xe36e('0x61'))['fromQuery']([_0xe36e('0x62'),'scheduledAt',_0xe36e('0x63'),'ListId',_0xe36e('0x76'),_0xe36e('0x65'),'updatedAt'],squel[_0xe36e('0x67')]()['field'](_0xe36e('0x77'),_0xe36e('0x62'))[_0xe36e('0x38')](_0xe36e('0x68'),_0xe36e('0x69'))['field'](_0xe36e('0x6a'),'ContactId')[_0xe36e('0x38')](_0xe36e('0x6b'),_0xe36e('0x78'))[_0xe36e('0x38')](_0xe36e('0x79'),_0xe36e('0x76'))['field'](_0xe36e('0x68'),_0xe36e('0x65'))[_0xe36e('0x38')]('NOW()',_0xe36e('0x66'))[_0xe36e('0x7a')](_0xe36e('0x6c'))[_0xe36e('0x34')]('CampaignId\x20=\x20?',_0x3bd3c2[_0xe36e('0x40')]['id']['toString']())[_0xe36e('0x34')]('state\x20=\x20?',_0x3bd3c2[_0xe36e('0x48')][_0xe36e('0x6f')][_0xe36e('0x6d')]())['where'](_0xe36e('0x70'))[_0xe36e('0x34')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0xe36e('0x67')]()[_0xe36e('0x38')](_0xe36e('0x62'))['from']('cm_hopper')[_0xe36e('0x34')](_0xe36e('0x7b'),_0x3bd3c2[_0xe36e('0x40')]['id'][_0xe36e('0x6d')]()))[_0xe36e('0x34')]('calleridnum\x20NOT\x20IN\x20(?)',squel[_0xe36e('0x67')]()[_0xe36e('0x38')](_0xe36e('0x73'))[_0xe36e('0x7a')]('cm_hopper_final')[_0xe36e('0x34')](_0xe36e('0x7b'),_0x3bd3c2['params']['id']['toString']())['where'](_0xe36e('0x74')))['group']('ContactId'))[_0xe36e('0x6d')]();return db[_0xe36e('0x4b')][_0xe36e('0x2b')](_0x5bdeea);}return[];})[_0xe36e('0x22')](respondWithResult(_0x327506,null))[_0xe36e('0x3e')](handleError(_0x327506,null));};exports[_0xe36e('0x7c')]=function(_0x48fbed,_0x2ebe8e,_0x4f9354){return db['CmHopper'][_0xe36e('0x7d')]({'where':{'VoiceQueueId':_0x48fbed[_0xe36e('0x48')][_0xe36e('0x64')],'CampaignId':_0x48fbed[_0xe36e('0x48')]['CampaignId'],'ContactId':_0x48fbed[_0xe36e('0x48')][_0xe36e('0x63')]}})[_0xe36e('0x22')](handleEntityNotFound(_0x2ebe8e,null))[_0xe36e('0x22')](function(_0x4d0a75){if(_0x4d0a75){return _0x4d0a75;}return null;})[_0xe36e('0x22')](respondWithResult(_0x2ebe8e,null))['catch'](handleError(_0x2ebe8e,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff