-const a830_0x2d04=['ListId','../../../rediscache','test','null','length','deletedAt\x20IS\x20NULL','lodash','Missing\x20filepath\x20parameter!','checkHopper','updatedAt','all','Duplicate\x20Contact','resolve','cm_hopper_final','error','errors','always','zipObject','CSV\x20import\x20process\x20stopped!','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','CmContact','generalCheckHopper','exit','find','util','emit','YYYY-MM-DD','ContactId','argv','Missing\x20ListId\x20parameter!','data','phone\x20IS\x20NOT\x20NULL','onlyIfOpen','into','pick','push','../../../mysqldb','sequelize','CompanyId','index','contact:csv_','fromQuery','Campaign','birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!','../../../api/cmContact/cmContact.socket','info','phone\x20NOT\x20IN\x20(?)','email\x20format\x20is\x20not\x20valid!','firstName','select','id\x20IN\x20?','NOW()','contact','CmList','scheduledAt','stringify','resume','calleridnum','duplicate','undefined','isValid','catch','field','from','message','Unable\x20to\x20delete\x20temp\x20file:','createdAt','phone\x20not\x20specified!','split','cmContact','birthDate','insert','parse','where','BlackLists','then','get','Error\x20executing\x20contact\x20csv\x20import:','Missing\x20binding\x20parameters!','SIGINT','toString','map','Error\x20while\x20creating\x20contact:\x20','findAll','query','phone','outbound','papaparse','cm_contacts','VoiceQueueId','register','finally','CampaignId','inspect','ListId\x20=\x20?','Lists','str','unlinkSync','cm_hopper','dialCheckDuplicateType','moment','\x20=\x20?'];(function(_0x5cbbd8,_0x2d0449){const _0x28fa63=function(_0x995ed4){while(--_0x995ed4){_0x5cbbd8['push'](_0x5cbbd8['shift']());}};_0x28fa63(++_0x2d0449);}(a830_0x2d04,0x153));const a830_0x28fa=function(_0x5cbbd8,_0x2d0449){_0x5cbbd8=_0x5cbbd8-0x0;let _0x28fa63=a830_0x2d04[_0x5cbbd8];return _0x28fa63;};const _0x3b13de=a830_0x28fa;'use strict';const util=require(_0x3b13de('0x5d')),_=require(_0x3b13de('0x4b')),fs=require('fs'),squel=require('squel'),Papa=require(_0x3b13de('0x36')),moment=require(_0x3b13de('0x43')),db=require(_0x3b13de('0x3'))['db'],logger=require('../../../config/logger')('api'),{getSocket}=require(_0x3b13de('0x46')),socket=getSocket();require(_0x3b13de('0xb'))[_0x3b13de('0x39')](socket);let FILEPATH,FIELDS,LISTID,COMPANYID,DUPLICATES,SOCKET_TIMESTAMP;try{if(!process[_0x3b13de('0x61')][0x2]||process[_0x3b13de('0x61')][0x2]==='undefined'||process[_0x3b13de('0x61')][0x2]===_0x3b13de('0x48'))throw new Error(_0x3b13de('0x4c'));FILEPATH=process[_0x3b13de('0x61')][0x2];if(!process['argv'][0x3]||process[_0x3b13de('0x61')][0x3]===_0x3b13de('0x1a')||process[_0x3b13de('0x61')][0x3]===_0x3b13de('0x48')||!process[_0x3b13de('0x61')][0x4]||process[_0x3b13de('0x61')][0x4]===_0x3b13de('0x1a')||process[_0x3b13de('0x61')][0x4]==='null')throw new Error(_0x3b13de('0x2d'));FIELDS=_[_0x3b13de('0x56')](process[_0x3b13de('0x61')][0x3][_0x3b13de('0x23')](','),process[_0x3b13de('0x61')][0x4]['split'](','));if(!process[_0x3b13de('0x61')][0x5]||process[_0x3b13de('0x61')][0x5]===_0x3b13de('0x1a')||process['argv'][0x5]===_0x3b13de('0x48'))throw new Error(_0x3b13de('0x62'));LISTID=process[_0x3b13de('0x61')][0x5],COMPANYID=process[_0x3b13de('0x61')][0x6]&&process[_0x3b13de('0x61')][0x6]!==_0x3b13de('0x1a')&&process['argv'][0x6]!==_0x3b13de('0x48')?process['argv'][0x6]:null,DUPLICATES=process[_0x3b13de('0x61')][0x7]&&process['argv'][0x7]!==_0x3b13de('0x1a')&&process[_0x3b13de('0x61')][0x7]!=='null'?process['argv'][0x7]:null;if(!process[_0x3b13de('0x61')][0x8]||process['argv'][0x8]===_0x3b13de('0x1a')||process[_0x3b13de('0x61')][0x8]===_0x3b13de('0x48'))throw new Error('Missing\x20socket_timestamp\x20parameter!');SOCKET_TIMESTAMP=process[_0x3b13de('0x61')][0x8];}catch(a830_0x995ed4){logger[_0x3b13de('0x53')](a830_0x995ed4),endCsv();}let total=0x0,success=0x0,errors=0x0,duplicates=0x0,rows=[],hopperContacts='',promises=[];function handleCheckRowError(_0x175cca,_0x4c4828,_0x33a416,_0x43181a){const _0x2ca43a=_0x3b13de,_0x1ecdbc={'message':_0x4c4828};return _0x1ecdbc[_0x175cca]=!![],_0x33a416&&(_0x1ecdbc[_0x2ca43a('0x13')]=_0x33a416),_0x43181a&&(_0x1ecdbc[_0x2ca43a('0x6')]=_0x43181a),_0x1ecdbc;}function isEmail(_0x12aa45){const _0xb78da9=_0x3b13de;return/^([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x22([^\x0d\x22\x5c\x80-\xff]|\x5c[\x00-\x7f])*\x22)(\x2e([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x22([^\x0d\x22\x5c\x80-\xff]|\x5c[\x00-\x7f])*\x22))*\x40([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x5b([^\x0d\x5b-\x5d\x80-\xff]|\x5c[\x00-\x7f])*\x5d)(\x2e([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x5b([^\x0d\x5b-\x5d\x80-\xff]|\x5c[\x00-\x7f])*\x5d))*$/[_0xb78da9('0x47')](_0x12aa45);}function checkRow(_0xfe39ae,_0x226ffb,_0x2f04de){return new Promise(function(_0x431747,_0x195509){const _0x8c2fdb=a830_0x28fa;if(_['isNil'](_0xfe39ae))return _0x195509(handleCheckRowError('error',_0x8c2fdb('0x58'),null,_0x2f04de));if(_0xfe39ae['errors']&&_0xfe39ae['errors'][_0x8c2fdb('0x49')]){const _0x491f37=_[_0x8c2fdb('0x30')](_0xfe39ae[_0x8c2fdb('0x54')],_0x8c2fdb('0x1f'))['join'](';');return _0x195509(handleCheckRowError(_0x8c2fdb('0x53'),_0x491f37,null,_0x2f04de));}const _0x158bb7={};for(const _0xaa774f in FIELDS){typeof FIELDS[_0xaa774f]!==_0x8c2fdb('0x1a')&&FIELDS[_0xaa774f]&&(_0x158bb7[_0xaa774f]=_0xfe39ae[_0x8c2fdb('0x63')][0x0][FIELDS[_0xaa774f]]||_0xfe39ae['data'][0x0]['\ufeff'+FIELDS[_0xaa774f]]);}if(!_0x158bb7[_0x8c2fdb('0xf')])return _0x195509(handleCheckRowError(_0x8c2fdb('0x53'),'firstName\x20not\x20specified!',null,_0x2f04de));if(!_0x158bb7['phone'])return _0x195509(handleCheckRowError(_0x8c2fdb('0x53'),_0x8c2fdb('0x22'),null,_0x2f04de));if(_0x158bb7[_0x8c2fdb('0x25')]){const _0x477a82=moment(_0x158bb7[_0x8c2fdb('0x25')],_0x8c2fdb('0x5f'));if(!_0x477a82[_0x8c2fdb('0x1b')]())return _0x195509(handleCheckRowError(_0x8c2fdb('0x53'),_0x8c2fdb('0xa'),null,_0x2f04de));}if(_0x158bb7['email']){if(!isEmail(_0x158bb7['email']))return _0x195509(handleCheckRowError(_0x8c2fdb('0x53'),_0x8c2fdb('0xe'),null,_0x2f04de));}_0x158bb7[_0x8c2fdb('0x45')]=LISTID,_0x158bb7[_0x8c2fdb('0x5')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES[_0x8c2fdb('0x49')]&&_0x226ffb){const _0x3b97d4={};for(let _0x59ab62=0x0,_0x48f276=DUPLICATES[_0x8c2fdb('0x49')];_0x59ab62<_0x48f276;_0x59ab62+=0x1){_0x3b97d4[DUPLICATES[_0x59ab62]]=_0x158bb7[DUPLICATES[_0x59ab62]];}const _0x5c3109=_[_0x8c2fdb('0x5c')](_0x226ffb,_0x3b97d4);if(_0x5c3109)return _0x195509(handleCheckRowError(_0x8c2fdb('0x19'),_0x8c2fdb('0x50'),_0x5c3109,_0x2f04de));}return db[_0x8c2fdb('0x59')]['create'](_0x158bb7,{'raw':!![],'hooks':![],'fields':_['keys'](_0x158bb7)})[_0x8c2fdb('0x2a')](function(_0x423965){const _0x2b0eaa=_0x8c2fdb;return DUPLICATES&&DUPLICATES['length']&&_0x226ffb&&_0x226ffb[_0x2b0eaa('0x2')](_[_0x2b0eaa('0x1')](_0x158bb7,DUPLICATES)),hopperContacts+=(hopperContacts?',':'')+_0x423965['id'],_0x431747();})['catch'](function(_0x11d271){const _0x2b77a7=_0x8c2fdb;return _0x195509(handleCheckRowError(_0x2b77a7('0x53'),_0x2b77a7('0x31')+(_0x11d271[_0x2b77a7('0x1f')]||JSON[_0x2b77a7('0x16')](_0x11d271)),null,_0x2f04de));});});}function checkHopper(){const _0x35bd5d=_0x3b13de;function _0x56ef5b(){return function(_0x47027c){const _0x5587ee=a830_0x28fa;logger['error'](_0x5587ee('0x24'),_0x5587ee('0x4d'),util[_0x5587ee('0x3c')](_0x47027c,{'showHidden':![],'depth':null}));};}const _0x9db1c2=function(_0xb7e911,_0x1308cb){const _0x3dda7b=a830_0x28fa,_0x5db3d5=squel[_0x3dda7b('0x26')]()[_0x3dda7b('0x0')](_0x3dda7b('0x41'))['fromQuery']([_0x3dda7b('0x34'),_0x3dda7b('0x15'),_0x3dda7b('0x60'),_0x3dda7b('0x45'),_0x1308cb,_0x3dda7b('0x21'),_0x3dda7b('0x4e')],squel[_0x3dda7b('0x10')]()[_0x3dda7b('0x1d')](_0x3dda7b('0x34'),_0x3dda7b('0x34'))[_0x3dda7b('0x1d')](_0x3dda7b('0x12'),_0x3dda7b('0x15'))[_0x3dda7b('0x1d')]('id','ContactId')[_0x3dda7b('0x1d')](LISTID[_0x3dda7b('0x2f')](),_0x3dda7b('0x45'))[_0x3dda7b('0x1d')](_0xb7e911['id'][_0x3dda7b('0x2f')](),_0x1308cb)['field'](_0x3dda7b('0x12'),_0x3dda7b('0x21'))[_0x3dda7b('0x1d')](_0x3dda7b('0x12'),_0x3dda7b('0x4e'))[_0x3dda7b('0x1e')](_0x3dda7b('0x37'))[_0x3dda7b('0x28')](_0x3dda7b('0x4a'))[_0x3dda7b('0x28')](_0x3dda7b('0x3d'),LISTID[_0x3dda7b('0x2f')]())[_0x3dda7b('0x28')](_0x3dda7b('0x64'))[_0x3dda7b('0x28')](_0x3dda7b('0xd'),squel['select']()[_0x3dda7b('0x1d')](_0x3dda7b('0x34'))[_0x3dda7b('0x1e')](_0x3dda7b('0x41'))['where'](_0x1308cb+'\x20=\x20?',_0xb7e911['id'][_0x3dda7b('0x2f')]())))[_0x3dda7b('0x2f')]();return _0x5db3d5;},_0x3f89ce=function(_0x235f3c,_0x5754df){const _0x443783=a830_0x28fa,_0x4a8cd7=squel[_0x443783('0x26')]()['into']('cm_hopper')[_0x443783('0x8')]([_0x443783('0x34'),_0x443783('0x15'),'ContactId',_0x443783('0x45'),_0x5754df,_0x443783('0x21'),_0x443783('0x4e')],squel['select']()[_0x443783('0x1d')](_0x443783('0x34'),_0x443783('0x34'))[_0x443783('0x1d')](_0x443783('0x12'),_0x443783('0x15'))[_0x443783('0x1d')]('id',_0x443783('0x60'))[_0x443783('0x1d')](LISTID['toString'](),_0x443783('0x45'))[_0x443783('0x1d')](_0x235f3c['id']['toString'](),_0x5754df)[_0x443783('0x1d')](_0x443783('0x12'),'createdAt')['field']('NOW()',_0x443783('0x4e'))['from']('cm_contacts')[_0x443783('0x28')](_0x443783('0x4a'))[_0x443783('0x28')](_0x443783('0x3d'),LISTID[_0x443783('0x2f')]())[_0x443783('0x28')](_0x443783('0x11'),squel['str'](hopperContacts))[_0x443783('0x28')]('phone\x20IS\x20NOT\x20NULL')[_0x443783('0x28')]('phone\x20NOT\x20IN\x20(?)',squel[_0x443783('0x10')]()[_0x443783('0x1d')](_0x443783('0x18'))[_0x443783('0x1e')](_0x443783('0x52'))['where'](_0x5754df+_0x443783('0x44'),_0x235f3c['id'][_0x443783('0x2f')]()))[_0x443783('0x28')](_0x443783('0xd'),squel['select']()['field'](_0x443783('0x34'))['from'](_0x443783('0x41'))['where'](_0x5754df+_0x443783('0x44'),_0x235f3c['id']['toString']())))[_0x443783('0x2f')]();return _0x4a8cd7;};function _0x6ecf41(_0x274739,_0xd5d705){const _0x42c3c7=a830_0x28fa,_0x29e928=squel['insert']()['into']('cm_hopper')[_0x42c3c7('0x8')]([_0x42c3c7('0x34'),_0x42c3c7('0x15'),_0x42c3c7('0x60'),_0x42c3c7('0x45'),_0xd5d705,_0x42c3c7('0x21'),_0x42c3c7('0x4e')],squel[_0x42c3c7('0x10')]()[_0x42c3c7('0x1d')](_0x42c3c7('0x34'),_0x42c3c7('0x34'))[_0x42c3c7('0x1d')](_0x42c3c7('0x12'),_0x42c3c7('0x15'))[_0x42c3c7('0x1d')]('id',_0x42c3c7('0x60'))[_0x42c3c7('0x1d')](LISTID[_0x42c3c7('0x2f')](),_0x42c3c7('0x45'))[_0x42c3c7('0x1d')](_0x274739['id'][_0x42c3c7('0x2f')](),_0xd5d705)['field'](_0x42c3c7('0x12'),_0x42c3c7('0x21'))[_0x42c3c7('0x1d')](_0x42c3c7('0x12'),'updatedAt')[_0x42c3c7('0x1e')](_0x42c3c7('0x37'))['where'](_0x42c3c7('0x4a'))[_0x42c3c7('0x28')](_0x42c3c7('0x3d'),LISTID['toString']())['where'](_0x42c3c7('0x11'),squel['str'](hopperContacts))[_0x42c3c7('0x28')](_0x42c3c7('0x64')))[_0x42c3c7('0x2f')]();return _0x29e928;}function _0x53ff15(_0x35d4f3,_0xcbdd2b){const _0x5c9837=a830_0x28fa,_0x18e86a=squel['insert']()[_0x5c9837('0x0')]('cm_hopper_black')[_0x5c9837('0x8')]([_0x5c9837('0x34'),_0x5c9837('0x60'),_0x5c9837('0x45'),_0xcbdd2b,_0x5c9837('0x21'),_0x5c9837('0x4e')],squel[_0x5c9837('0x10')]()[_0x5c9837('0x1d')](_0x5c9837('0x34'),_0x5c9837('0x34'))[_0x5c9837('0x1d')]('id',_0x5c9837('0x60'))[_0x5c9837('0x1d')](LISTID[_0x5c9837('0x2f')](),_0x5c9837('0x45'))[_0x5c9837('0x1d')](_0x35d4f3['id'][_0x5c9837('0x2f')](),_0xcbdd2b)[_0x5c9837('0x1d')](_0x5c9837('0x12'),_0x5c9837('0x21'))['field']('NOW()',_0x5c9837('0x4e'))[_0x5c9837('0x1e')]('cm_contacts')[_0x5c9837('0x28')]('deletedAt\x20IS\x20NULL')[_0x5c9837('0x28')](_0x5c9837('0x3d'),LISTID['toString']())['where'](_0x5c9837('0x11'),squel[_0x5c9837('0x3f')](hopperContacts))[_0x5c9837('0x28')]('phone\x20IS\x20NOT\x20NULL'))[_0x5c9837('0x2f')]();return _0x18e86a;}return db['VoiceQueue'][_0x35bd5d('0x32')]({'where':{'type':_0x35bd5d('0x35')},'attributes':['id',_0x35bd5d('0x42')],'include':[{'model':db[_0x35bd5d('0x14')],'as':_0x35bd5d('0x3e'),'where':{'id':LISTID}}]})[_0x35bd5d('0x2a')](function(_0x249481){const _0x38c3db=_0x35bd5d,_0x5e3279=[];if(_0x249481)for(let _0x6c5b47=0x0,_0x38b0f9;_0x6c5b47<_0x249481[_0x38c3db('0x49')];_0x6c5b47+=0x1){_0x38b0f9=_0x249481[_0x6c5b47][_0x38c3db('0x2b')]({'plain':!![]});switch(_0x38b0f9[_0x38c3db('0x42')]){case _0x38c3db('0x55'):_0x5e3279[_0x38c3db('0x2')](db[_0x38c3db('0x4')][_0x38c3db('0x33')](_0x3f89ce(_0x38b0f9,_0x38c3db('0x38')))[_0x38c3db('0x2a')](function(){})[_0x38c3db('0x1c')](_0x56ef5b()));break;case _0x38c3db('0x65'):_0x5e3279[_0x38c3db('0x2')](db[_0x38c3db('0x4')][_0x38c3db('0x33')](_0x9db1c2(_0x38b0f9,_0x38c3db('0x38')))[_0x38c3db('0x2a')](function(){})[_0x38c3db('0x1c')](_0x56ef5b()));break;default:_0x5e3279[_0x38c3db('0x2')](db['sequelize']['query'](_0x6ecf41(_0x38b0f9,_0x38c3db('0x38')))['then'](function(){})[_0x38c3db('0x1c')](_0x56ef5b()));}}return _0x5e3279;})['all']()['then'](function(){const _0x170cbf=_0x35bd5d;return db['VoiceQueue'][_0x170cbf('0x32')]({'where':{'type':'outbound'},'attributes':['id'],'include':[{'model':db['CmList'],'as':'BlackLists','where':{'id':LISTID}}]})[_0x170cbf('0x2a')](function(_0xc4ca25){const _0x48395e=_0x170cbf,_0x4c3a32=[];if(_0xc4ca25)for(let _0x246fd2=0x0,_0x371f89;_0x246fd2<_0xc4ca25[_0x48395e('0x49')];_0x246fd2+=0x1){_0x371f89=_0xc4ca25[_0x246fd2]['get']({'plain':!![]}),_0x4c3a32[_0x48395e('0x2')](db[_0x48395e('0x4')][_0x48395e('0x33')](_0x53ff15(_0x371f89,_0x48395e('0x38')))[_0x48395e('0x2a')](function(){})['catch'](_0x56ef5b()));}return _0x4c3a32;})[_0x170cbf('0x4f')]();})[_0x35bd5d('0x2a')](function(){const _0x1ceb58=_0x35bd5d;return db['Campaign'][_0x1ceb58('0x32')]({'attributes':['id',_0x1ceb58('0x42')],'include':[{'model':db[_0x1ceb58('0x14')],'as':'Lists','where':{'id':LISTID}}]})['then'](function(_0x2898ea){const _0xf1544d=_0x1ceb58,_0x36d2a9=[];if(_0x2898ea)for(let _0x25629c=0x0,_0x30e548;_0x25629c<_0x2898ea[_0xf1544d('0x49')];_0x25629c+=0x1){_0x30e548=_0x2898ea[_0x25629c]['get']({'plain':!![]});switch(_0x30e548['dialCheckDuplicateType']){case _0xf1544d('0x55'):_0x36d2a9['push'](db[_0xf1544d('0x4')][_0xf1544d('0x33')](_0x3f89ce(_0x30e548,_0xf1544d('0x3b')))[_0xf1544d('0x2a')](function(){})['catch'](_0x56ef5b()));break;case _0xf1544d('0x65'):_0x36d2a9['push'](db[_0xf1544d('0x4')][_0xf1544d('0x33')](_0x9db1c2(_0x30e548,_0xf1544d('0x3b')))[_0xf1544d('0x2a')](function(){})[_0xf1544d('0x1c')](_0x56ef5b()));break;default:_0x36d2a9[_0xf1544d('0x2')](db[_0xf1544d('0x4')]['query'](_0x6ecf41(_0x30e548,'CampaignId'))[_0xf1544d('0x2a')](function(){})[_0xf1544d('0x1c')](_0x56ef5b()));}}return _0x36d2a9;})[_0x1ceb58('0x4f')]();})['then'](function(){const _0x3ad382=_0x35bd5d;return db[_0x3ad382('0x9')][_0x3ad382('0x32')]({'attributes':['id'],'include':[{'model':db[_0x3ad382('0x14')],'as':_0x3ad382('0x29'),'where':{'id':LISTID}}]})[_0x3ad382('0x2a')](function(_0x581a9a){const _0x2993eb=_0x3ad382,_0x4f379c=[];if(_0x581a9a)for(let _0x25d452=0x0,_0x4ebfdc;_0x25d452<_0x581a9a[_0x2993eb('0x49')];_0x25d452+=0x1){_0x4ebfdc=_0x581a9a[_0x25d452][_0x2993eb('0x2b')]({'plain':!![]}),_0x4f379c[_0x2993eb('0x2')](db[_0x2993eb('0x4')]['query'](_0x53ff15(_0x4ebfdc,'CampaignId'))[_0x2993eb('0x2a')](function(){})[_0x2993eb('0x1c')](_0x56ef5b()));}return _0x4f379c;})['all']();})['catch'](function(_0x23e378){const _0x121cd5=_0x35bd5d;logger[_0x121cd5('0x53')]('cmContact,\x20%s,\x20%s',_0x121cd5('0x5a'),_0x23e378[_0x121cd5('0x1f')]);});}const processPromises=function(_0x4d2b10){const _0x48a708=_0x3b13de;return Promise[_0x48a708('0x4f')](promises)[_0x48a708('0x1c')](function(_0x57f7f9){const _0x5b9eea=_0x48a708;logger[_0x5b9eea('0x53')]('Error\x20processing\x20rows\x20block:',JSON[_0x5b9eea('0x16')](_0x57f7f9));})[_0x48a708('0x3a')](function(){const _0x1a2d98=_0x48a708;socket[_0x1a2d98('0x5e')]('contact:csv_'+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows}),promises=[],success=0x0,errors=0x0,duplicates=0x0,rows=[];if(_0x4d2b10)return _0x4d2b10[_0x1a2d98('0x17')]();});},endCsv=function(){const _0x207590=_0x3b13de;return Promise[_0x207590('0x51')]()[_0x207590('0x2a')](function(){if(hopperContacts)return checkHopper();})['then'](function(){const _0x2d76f7=_0x207590;socket[_0x2d76f7('0x5e')](_0x2d76f7('0x7')+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x2d76f7('0x40')](FILEPATH);}catch(_0x3e3129){logger[_0x2d76f7('0x53')](_0x2d76f7('0x20'),JSON[_0x2d76f7('0x16')](_0x3e3129));}finally{process[_0x2d76f7('0x5b')](0x0);}});};process['on'](_0x3b13de('0x2e'),function(){const _0x1086c0=_0x3b13de;logger[_0x1086c0('0xc')](_0x1086c0('0x57')),endCsv();});function main(){const _0x37553d=_0x3b13de;return Promise[_0x37553d('0x51')]()[_0x37553d('0x2a')](function(){const _0x373708=_0x37553d;if(DUPLICATES)return DUPLICATES=DUPLICATES[_0x373708('0x23')](','),db[_0x373708('0x59')][_0x373708('0x32')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});})[_0x37553d('0x2a')](function(_0xf8965e){const _0x123672=_0x37553d,_0x5863b7=fs['createReadStream'](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0x123672('0x27')](_0x5863b7,{'header':!![],'skipEmptyLines':!![],'step':function(_0x5a0613,_0x181c4a){const _0x13ad1b=_0x123672;total+=0x1;const _0x557374=total;promises[_0x13ad1b('0x2')](checkRow(_0x5a0613,_0xf8965e,_0x557374)[_0x13ad1b('0x2a')](function(){success+=0x1;})[_0x13ad1b('0x1c')](function(_0xef2cce){const _0x26d5ba=_0x13ad1b;if(_0xef2cce[_0x26d5ba('0x53')])errors+=0x1,delete _0xef2cce['error'];else _0xef2cce['duplicate']&&(duplicates+=0x1,delete _0xef2cce['duplicate']);rows[_0x26d5ba('0x2')](_0xef2cce);}));if(total%0xc8===0x0)return _0x181c4a['pause'](),processPromises(_0x181c4a);},'complete':function(){const _0x884d47=_0x123672;return processPromises()[_0x884d47('0x2a')](function(){const _0xc029b4=_0x884d47;logger[_0xc029b4('0xc')]('CSV\x20parsed\x20correctly!'),endCsv();});},'error':function(_0x237371){const _0x33882e=_0x123672;logger[_0x33882e('0xc')]('CSV\x20parse\x20error',JSON[_0x33882e('0x16')](_0x237371)),endCsv();}});})[_0x37553d('0x1c')](function(_0x183079){const _0x1cd17e=_0x37553d;logger[_0x1cd17e('0x53')](_0x1cd17e('0x2c'),JSON[_0x1cd17e('0x16')](_0x183079));});}main();
\ No newline at end of file
+const a830_0x4e3c=['test','CmContact','error','argv','str','CmList','select','ListId','catch','VoiceQueue','register','checkHopper','duplicate','VoiceQueueId','phone','into','CampaignId','resolve','Error\x20processing\x20rows\x20block:','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','cm_contacts','cmContact','CSV\x20parsed\x20correctly!','email','findAll','Error\x20while\x20creating\x20contact:\x20','create','always','cmContact,\x20%s,\x20%s','find','contact:csv_','where','birthDate','cm_hopper_final','Lists','Missing\x20filepath\x20parameter!','Error\x20executing\x20contact\x20csv\x20import:','deletedAt\x20IS\x20NULL','exit','map','contact','dialCheckDuplicateType','CompanyId','ListId\x20=\x20?','Missing\x20ListId\x20parameter!','../../../config/logger','calleridnum','data','cm_hopper','errors','util','firstName','NOW()','emit','join','pause','outbound','get','onlyIfOpen','resume','CSV\x20import\x20process\x20stopped!','Campaign','zipObject','../../../api/cmContact/cmContact.socket','undefined','sequelize','toString','\x20=\x20?','email\x20format\x20is\x20not\x20valid!','index','unlinkSync','stringify','isValid','scheduledAt','push','../../../rediscache','generalCheckHopper','../../../mysqldb','SIGINT','info','squel','from','ContactId','insert','createdAt','Unable\x20to\x20delete\x20temp\x20file:','split','parse','all','updatedAt','BlackLists','id\x20IN\x20?','field','cm_hopper_black','moment','query','message','phone\x20NOT\x20IN\x20(?)','null','api','length','phone\x20not\x20specified!','isNil','lodash','pick','fromQuery','papaparse','birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!','then','phone\x20IS\x20NOT\x20NULL','keys'];(function(_0x2bea9e,_0x4e3c74){const _0x2e6286=function(_0xd78b8e){while(--_0xd78b8e){_0x2bea9e['push'](_0x2bea9e['shift']());}};_0x2e6286(++_0x4e3c74);}(a830_0x4e3c,0x71));const a830_0x2e62=function(_0x2bea9e,_0x4e3c74){_0x2bea9e=_0x2bea9e-0x0;let _0x2e6286=a830_0x4e3c[_0x2bea9e];return _0x2e6286;};const _0x278fe6=a830_0x2e62;'use strict';const util=require(_0x278fe6('0x30')),_=require(_0x278fe6('0x65')),fs=require('fs'),squel=require(_0x278fe6('0x4e')),Papa=require(_0x278fe6('0x68')),moment=require(_0x278fe6('0x5c')),db=require(_0x278fe6('0x4b'))['db'],logger=require(_0x278fe6('0x2b'))(_0x278fe6('0x61')),{getSocket}=require(_0x278fe6('0x49')),socket=getSocket();require(_0x278fe6('0x3d'))[_0x278fe6('0x8')](socket);let FILEPATH,FIELDS,LISTID,COMPANYID,DUPLICATES,SOCKET_TIMESTAMP;try{if(!process['argv'][0x2]||process[_0x278fe6('0x1')][0x2]===_0x278fe6('0x3e')||process[_0x278fe6('0x1')][0x2]===_0x278fe6('0x60'))throw new Error(_0x278fe6('0x21'));FILEPATH=process['argv'][0x2];if(!process[_0x278fe6('0x1')][0x3]||process[_0x278fe6('0x1')][0x3]==='undefined'||process[_0x278fe6('0x1')][0x3]===_0x278fe6('0x60')||!process[_0x278fe6('0x1')][0x4]||process[_0x278fe6('0x1')][0x4]===_0x278fe6('0x3e')||process[_0x278fe6('0x1')][0x4]===_0x278fe6('0x60'))throw new Error('Missing\x20binding\x20parameters!');FIELDS=_[_0x278fe6('0x3c')](process['argv'][0x3]['split'](','),process[_0x278fe6('0x1')][0x4]['split'](','));if(!process[_0x278fe6('0x1')][0x5]||process['argv'][0x5]===_0x278fe6('0x3e')||process['argv'][0x5]==='null')throw new Error(_0x278fe6('0x2a'));LISTID=process[_0x278fe6('0x1')][0x5],COMPANYID=process[_0x278fe6('0x1')][0x6]&&process[_0x278fe6('0x1')][0x6]!==_0x278fe6('0x3e')&&process[_0x278fe6('0x1')][0x6]!=='null'?process[_0x278fe6('0x1')][0x6]:null,DUPLICATES=process[_0x278fe6('0x1')][0x7]&&process[_0x278fe6('0x1')][0x7]!==_0x278fe6('0x3e')&&process[_0x278fe6('0x1')][0x7]!==_0x278fe6('0x60')?process[_0x278fe6('0x1')][0x7]:null;if(!process['argv'][0x8]||process[_0x278fe6('0x1')][0x8]===_0x278fe6('0x3e')||process[_0x278fe6('0x1')][0x8]===_0x278fe6('0x60'))throw new Error('Missing\x20socket_timestamp\x20parameter!');SOCKET_TIMESTAMP=process[_0x278fe6('0x1')][0x8];}catch(a830_0xd78b8e){logger[_0x278fe6('0x0')](a830_0xd78b8e),endCsv();}let total=0x0,success=0x0,errors=0x0,duplicates=0x0,rows=[],hopperContacts='',promises=[];function handleCheckRowError(_0x1ff7cc,_0x4f14f9,_0x16509f,_0x1548f8){const _0x48752c=_0x278fe6,_0x5862ab={'message':_0x4f14f9};return _0x5862ab[_0x1ff7cc]=!![],_0x16509f&&(_0x5862ab[_0x48752c('0x26')]=_0x16509f),_0x1548f8&&(_0x5862ab[_0x48752c('0x43')]=_0x1548f8),_0x5862ab;}function isEmail(_0x29015c){const _0x59e935=_0x278fe6;return/^([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x22([^\x0d\x22\x5c\x80-\xff]|\x5c[\x00-\x7f])*\x22)(\x2e([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x22([^\x0d\x22\x5c\x80-\xff]|\x5c[\x00-\x7f])*\x22))*\x40([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x5b([^\x0d\x5b-\x5d\x80-\xff]|\x5c[\x00-\x7f])*\x5d)(\x2e([^\x00-\x20\x22\x28\x29\x2c\x2e\x3a-\x3c\x3e\x40\x5b-\x5d\x7f-\xff]+|\x5b([^\x0d\x5b-\x5d\x80-\xff]|\x5c[\x00-\x7f])*\x5d))*$/[_0x59e935('0x6d')](_0x29015c);}function checkRow(_0xfb83df,_0x260920,_0x3ef8b1){return new Promise(function(_0x49f1ee,_0x7b2a2c){const _0x244c5a=a830_0x2e62;if(_[_0x244c5a('0x64')](_0xfb83df))return _0x7b2a2c(handleCheckRowError(_0x244c5a('0x0'),_0x244c5a('0x11'),null,_0x3ef8b1));if(_0xfb83df[_0x244c5a('0x2f')]&&_0xfb83df[_0x244c5a('0x2f')][_0x244c5a('0x62')]){const _0x27b2f8=_[_0x244c5a('0x25')](_0xfb83df['errors'],'message')[_0x244c5a('0x34')](';');return _0x7b2a2c(handleCheckRowError(_0x244c5a('0x0'),_0x27b2f8,null,_0x3ef8b1));}const _0x5d076b={};for(const _0x4d45c1 in FIELDS){typeof FIELDS[_0x4d45c1]!==_0x244c5a('0x3e')&&FIELDS[_0x4d45c1]&&(_0x5d076b[_0x4d45c1]=_0xfb83df['data'][0x0][FIELDS[_0x4d45c1]]||_0xfb83df[_0x244c5a('0x2d')][0x0]['\ufeff'+FIELDS[_0x4d45c1]]);}if(!_0x5d076b[_0x244c5a('0x31')])return _0x7b2a2c(handleCheckRowError('error','firstName\x20not\x20specified!',null,_0x3ef8b1));if(!_0x5d076b[_0x244c5a('0xc')])return _0x7b2a2c(handleCheckRowError(_0x244c5a('0x0'),_0x244c5a('0x63'),null,_0x3ef8b1));if(_0x5d076b[_0x244c5a('0x1e')]){const _0x20adad=moment(_0x5d076b['birthDate'],'YYYY-MM-DD');if(!_0x20adad[_0x244c5a('0x46')]())return _0x7b2a2c(handleCheckRowError(_0x244c5a('0x0'),_0x244c5a('0x69'),null,_0x3ef8b1));}if(_0x5d076b[_0x244c5a('0x15')]){if(!isEmail(_0x5d076b[_0x244c5a('0x15')]))return _0x7b2a2c(handleCheckRowError('error',_0x244c5a('0x42'),null,_0x3ef8b1));}_0x5d076b[_0x244c5a('0x5')]=LISTID,_0x5d076b[_0x244c5a('0x28')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES['length']&&_0x260920){const _0x5c514f={};for(let _0x52ef91=0x0,_0x25dcdc=DUPLICATES['length'];_0x52ef91<_0x25dcdc;_0x52ef91+=0x1){_0x5c514f[DUPLICATES[_0x52ef91]]=_0x5d076b[DUPLICATES[_0x52ef91]];}const _0x1820a4=_[_0x244c5a('0x1b')](_0x260920,_0x5c514f);if(_0x1820a4)return _0x7b2a2c(handleCheckRowError(_0x244c5a('0xa'),'Duplicate\x20Contact',_0x1820a4,_0x3ef8b1));}return db[_0x244c5a('0x6e')][_0x244c5a('0x18')](_0x5d076b,{'raw':!![],'hooks':![],'fields':_[_0x244c5a('0x6c')](_0x5d076b)})[_0x244c5a('0x6a')](function(_0x1d3cdc){const _0x178ebe=_0x244c5a;return DUPLICATES&&DUPLICATES[_0x178ebe('0x62')]&&_0x260920&&_0x260920[_0x178ebe('0x48')](_[_0x178ebe('0x66')](_0x5d076b,DUPLICATES)),hopperContacts+=(hopperContacts?',':'')+_0x1d3cdc['id'],_0x49f1ee();})[_0x244c5a('0x6')](function(_0x445d2e){const _0xb9b72b=_0x244c5a;return _0x7b2a2c(handleCheckRowError(_0xb9b72b('0x0'),_0xb9b72b('0x17')+(_0x445d2e['message']||JSON[_0xb9b72b('0x45')](_0x445d2e)),null,_0x3ef8b1));});});}function checkHopper(){const _0x195998=_0x278fe6;function _0x26f7a3(){return function(_0x5fdd4c){const _0x54745e=a830_0x2e62;logger[_0x54745e('0x0')](_0x54745e('0x13'),_0x54745e('0x9'),util['inspect'](_0x5fdd4c,{'showHidden':![],'depth':null}));};}const _0x292f5c=function(_0x5f2e83,_0x3a8802){const _0x397637=a830_0x2e62,_0x1fd29f=squel['insert']()[_0x397637('0xd')](_0x397637('0x2e'))[_0x397637('0x67')]([_0x397637('0xc'),_0x397637('0x47'),_0x397637('0x50'),'ListId',_0x3a8802,'createdAt',_0x397637('0x57')],squel[_0x397637('0x4')]()[_0x397637('0x5a')]('phone','phone')[_0x397637('0x5a')](_0x397637('0x32'),_0x397637('0x47'))[_0x397637('0x5a')]('id','ContactId')[_0x397637('0x5a')](LISTID[_0x397637('0x40')](),_0x397637('0x5'))[_0x397637('0x5a')](_0x5f2e83['id'][_0x397637('0x40')](),_0x3a8802)[_0x397637('0x5a')](_0x397637('0x32'),_0x397637('0x52'))['field'](_0x397637('0x32'),_0x397637('0x57'))[_0x397637('0x4f')](_0x397637('0x12'))[_0x397637('0x1d')](_0x397637('0x23'))['where']('ListId\x20=\x20?',LISTID[_0x397637('0x40')]())[_0x397637('0x1d')](_0x397637('0x6b'))[_0x397637('0x1d')](_0x397637('0x5f'),squel[_0x397637('0x4')]()[_0x397637('0x5a')](_0x397637('0xc'))[_0x397637('0x4f')](_0x397637('0x2e'))[_0x397637('0x1d')](_0x3a8802+_0x397637('0x41'),_0x5f2e83['id'][_0x397637('0x40')]())))['toString']();return _0x1fd29f;},_0x370b40=function(_0x209fe7,_0x1afce4){const _0x134798=a830_0x2e62,_0x190035=squel[_0x134798('0x51')]()[_0x134798('0xd')]('cm_hopper')[_0x134798('0x67')]([_0x134798('0xc'),'scheduledAt',_0x134798('0x50'),_0x134798('0x5'),_0x1afce4,_0x134798('0x52'),_0x134798('0x57')],squel[_0x134798('0x4')]()[_0x134798('0x5a')](_0x134798('0xc'),_0x134798('0xc'))[_0x134798('0x5a')](_0x134798('0x32'),_0x134798('0x47'))[_0x134798('0x5a')]('id',_0x134798('0x50'))['field'](LISTID[_0x134798('0x40')](),_0x134798('0x5'))[_0x134798('0x5a')](_0x209fe7['id'][_0x134798('0x40')](),_0x1afce4)[_0x134798('0x5a')](_0x134798('0x32'),'createdAt')[_0x134798('0x5a')](_0x134798('0x32'),'updatedAt')[_0x134798('0x4f')]('cm_contacts')[_0x134798('0x1d')](_0x134798('0x23'))[_0x134798('0x1d')](_0x134798('0x29'),LISTID[_0x134798('0x40')]())[_0x134798('0x1d')](_0x134798('0x59'),squel[_0x134798('0x2')](hopperContacts))[_0x134798('0x1d')](_0x134798('0x6b'))[_0x134798('0x1d')]('phone\x20NOT\x20IN\x20(?)',squel['select']()['field'](_0x134798('0x2c'))['from'](_0x134798('0x1f'))[_0x134798('0x1d')](_0x1afce4+'\x20=\x20?',_0x209fe7['id'][_0x134798('0x40')]()))['where'](_0x134798('0x5f'),squel['select']()[_0x134798('0x5a')](_0x134798('0xc'))[_0x134798('0x4f')](_0x134798('0x2e'))['where'](_0x1afce4+_0x134798('0x41'),_0x209fe7['id'][_0x134798('0x40')]())))[_0x134798('0x40')]();return _0x190035;};function _0x373330(_0x3a90d3,_0x41e4b0){const _0x40dfdb=a830_0x2e62,_0x16e0cc=squel[_0x40dfdb('0x51')]()[_0x40dfdb('0xd')](_0x40dfdb('0x2e'))[_0x40dfdb('0x67')]([_0x40dfdb('0xc'),'scheduledAt',_0x40dfdb('0x50'),'ListId',_0x41e4b0,_0x40dfdb('0x52'),_0x40dfdb('0x57')],squel[_0x40dfdb('0x4')]()['field'](_0x40dfdb('0xc'),'phone')[_0x40dfdb('0x5a')](_0x40dfdb('0x32'),_0x40dfdb('0x47'))[_0x40dfdb('0x5a')]('id',_0x40dfdb('0x50'))[_0x40dfdb('0x5a')](LISTID[_0x40dfdb('0x40')](),_0x40dfdb('0x5'))[_0x40dfdb('0x5a')](_0x3a90d3['id']['toString'](),_0x41e4b0)[_0x40dfdb('0x5a')](_0x40dfdb('0x32'),'createdAt')[_0x40dfdb('0x5a')](_0x40dfdb('0x32'),_0x40dfdb('0x57'))[_0x40dfdb('0x4f')]('cm_contacts')['where'](_0x40dfdb('0x23'))[_0x40dfdb('0x1d')](_0x40dfdb('0x29'),LISTID[_0x40dfdb('0x40')]())['where'](_0x40dfdb('0x59'),squel[_0x40dfdb('0x2')](hopperContacts))['where'](_0x40dfdb('0x6b')))[_0x40dfdb('0x40')]();return _0x16e0cc;}function _0x4b2e7b(_0x15111,_0x447884){const _0x429485=a830_0x2e62,_0x4f719e=squel[_0x429485('0x51')]()[_0x429485('0xd')](_0x429485('0x5b'))[_0x429485('0x67')]([_0x429485('0xc'),'ContactId',_0x429485('0x5'),_0x447884,_0x429485('0x52'),_0x429485('0x57')],squel[_0x429485('0x4')]()['field'](_0x429485('0xc'),_0x429485('0xc'))[_0x429485('0x5a')]('id',_0x429485('0x50'))[_0x429485('0x5a')](LISTID[_0x429485('0x40')](),_0x429485('0x5'))[_0x429485('0x5a')](_0x15111['id'][_0x429485('0x40')](),_0x447884)[_0x429485('0x5a')](_0x429485('0x32'),_0x429485('0x52'))['field'](_0x429485('0x32'),_0x429485('0x57'))[_0x429485('0x4f')](_0x429485('0x12'))['where'](_0x429485('0x23'))[_0x429485('0x1d')](_0x429485('0x29'),LISTID[_0x429485('0x40')]())['where'](_0x429485('0x59'),squel[_0x429485('0x2')](hopperContacts))['where'](_0x429485('0x6b')))[_0x429485('0x40')]();return _0x4f719e;}return db[_0x195998('0x7')][_0x195998('0x16')]({'where':{'type':_0x195998('0x36')},'attributes':['id',_0x195998('0x27')],'include':[{'model':db[_0x195998('0x3')],'as':_0x195998('0x20'),'where':{'id':LISTID}}]})[_0x195998('0x6a')](function(_0x37fc51){const _0xef939=_0x195998,_0x454d65=[];if(_0x37fc51)for(let _0x3d179c=0x0,_0x2c26ba;_0x3d179c<_0x37fc51[_0xef939('0x62')];_0x3d179c+=0x1){_0x2c26ba=_0x37fc51[_0x3d179c][_0xef939('0x37')]({'plain':!![]});switch(_0x2c26ba['dialCheckDuplicateType']){case _0xef939('0x19'):_0x454d65[_0xef939('0x48')](db[_0xef939('0x3f')][_0xef939('0x5d')](_0x370b40(_0x2c26ba,_0xef939('0xb')))[_0xef939('0x6a')](function(){})[_0xef939('0x6')](_0x26f7a3()));break;case _0xef939('0x38'):_0x454d65['push'](db[_0xef939('0x3f')][_0xef939('0x5d')](_0x292f5c(_0x2c26ba,_0xef939('0xb')))[_0xef939('0x6a')](function(){})['catch'](_0x26f7a3()));break;default:_0x454d65[_0xef939('0x48')](db['sequelize']['query'](_0x373330(_0x2c26ba,_0xef939('0xb')))['then'](function(){})[_0xef939('0x6')](_0x26f7a3()));}}return _0x454d65;})[_0x195998('0x56')]()[_0x195998('0x6a')](function(){const _0x3f88f5=_0x195998;return db[_0x3f88f5('0x7')][_0x3f88f5('0x16')]({'where':{'type':_0x3f88f5('0x36')},'attributes':['id'],'include':[{'model':db['CmList'],'as':_0x3f88f5('0x58'),'where':{'id':LISTID}}]})[_0x3f88f5('0x6a')](function(_0x2ceef1){const _0xc60c2f=_0x3f88f5,_0x55315a=[];if(_0x2ceef1)for(let _0x2f7acd=0x0,_0x3636b6;_0x2f7acd<_0x2ceef1['length'];_0x2f7acd+=0x1){_0x3636b6=_0x2ceef1[_0x2f7acd][_0xc60c2f('0x37')]({'plain':!![]}),_0x55315a[_0xc60c2f('0x48')](db[_0xc60c2f('0x3f')][_0xc60c2f('0x5d')](_0x4b2e7b(_0x3636b6,_0xc60c2f('0xb')))[_0xc60c2f('0x6a')](function(){})['catch'](_0x26f7a3()));}return _0x55315a;})[_0x3f88f5('0x56')]();})[_0x195998('0x6a')](function(){const _0x2d4088=_0x195998;return db[_0x2d4088('0x3b')]['findAll']({'attributes':['id',_0x2d4088('0x27')],'include':[{'model':db[_0x2d4088('0x3')],'as':'Lists','where':{'id':LISTID}}]})['then'](function(_0x868a10){const _0xfea766=_0x2d4088,_0x61ebe7=[];if(_0x868a10)for(let _0x24cc7c=0x0,_0x31ce03;_0x24cc7c<_0x868a10[_0xfea766('0x62')];_0x24cc7c+=0x1){_0x31ce03=_0x868a10[_0x24cc7c][_0xfea766('0x37')]({'plain':!![]});switch(_0x31ce03[_0xfea766('0x27')]){case _0xfea766('0x19'):_0x61ebe7['push'](db['sequelize'][_0xfea766('0x5d')](_0x370b40(_0x31ce03,_0xfea766('0xe')))[_0xfea766('0x6a')](function(){})['catch'](_0x26f7a3()));break;case _0xfea766('0x38'):_0x61ebe7['push'](db[_0xfea766('0x3f')]['query'](_0x292f5c(_0x31ce03,'CampaignId'))[_0xfea766('0x6a')](function(){})['catch'](_0x26f7a3()));break;default:_0x61ebe7[_0xfea766('0x48')](db[_0xfea766('0x3f')][_0xfea766('0x5d')](_0x373330(_0x31ce03,_0xfea766('0xe')))[_0xfea766('0x6a')](function(){})[_0xfea766('0x6')](_0x26f7a3()));}}return _0x61ebe7;})[_0x2d4088('0x56')]();})[_0x195998('0x6a')](function(){const _0x38d608=_0x195998;return db['Campaign'][_0x38d608('0x16')]({'attributes':['id'],'include':[{'model':db['CmList'],'as':'BlackLists','where':{'id':LISTID}}]})['then'](function(_0x21ada2){const _0x4f5371=_0x38d608,_0x3642b1=[];if(_0x21ada2)for(let _0x14315d=0x0,_0x1592ce;_0x14315d<_0x21ada2[_0x4f5371('0x62')];_0x14315d+=0x1){_0x1592ce=_0x21ada2[_0x14315d][_0x4f5371('0x37')]({'plain':!![]}),_0x3642b1[_0x4f5371('0x48')](db[_0x4f5371('0x3f')][_0x4f5371('0x5d')](_0x4b2e7b(_0x1592ce,'CampaignId'))[_0x4f5371('0x6a')](function(){})['catch'](_0x26f7a3()));}return _0x3642b1;})['all']();})[_0x195998('0x6')](function(_0x330435){const _0x1b72d4=_0x195998;logger['error'](_0x1b72d4('0x1a'),_0x1b72d4('0x4a'),_0x330435[_0x1b72d4('0x5e')]);});}const processPromises=function(_0x55f3ff){const _0x312a40=_0x278fe6;return Promise[_0x312a40('0x56')](promises)['catch'](function(_0x4d5d95){const _0x13c96d=_0x312a40;logger[_0x13c96d('0x0')](_0x13c96d('0x10'),JSON['stringify'](_0x4d5d95));})['finally'](function(){const _0x44766e=_0x312a40;socket[_0x44766e('0x33')](_0x44766e('0x1c')+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows}),promises=[],success=0x0,errors=0x0,duplicates=0x0,rows=[];if(_0x55f3ff)return _0x55f3ff[_0x44766e('0x39')]();});},endCsv=function(){const _0x133e6f=_0x278fe6;return Promise['resolve']()['then'](function(){if(hopperContacts)return checkHopper();})[_0x133e6f('0x6a')](function(){const _0x5aea83=_0x133e6f;socket[_0x5aea83('0x33')](_0x5aea83('0x1c')+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x5aea83('0x44')](FILEPATH);}catch(_0x24cfcc){logger[_0x5aea83('0x0')](_0x5aea83('0x53'),JSON['stringify'](_0x24cfcc));}finally{process[_0x5aea83('0x24')](0x0);}});};process['on'](_0x278fe6('0x4c'),function(){const _0x12d7f8=_0x278fe6;logger[_0x12d7f8('0x4d')](_0x12d7f8('0x3a')),endCsv();});function main(){const _0x29e862=_0x278fe6;return Promise[_0x29e862('0xf')]()[_0x29e862('0x6a')](function(){const _0x28e0ea=_0x29e862;if(DUPLICATES)return DUPLICATES=DUPLICATES[_0x28e0ea('0x54')](','),db[_0x28e0ea('0x6e')][_0x28e0ea('0x16')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});})['then'](function(_0x34878f){const _0x72cbd=_0x29e862,_0x41f670=fs['createReadStream'](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0x72cbd('0x55')](_0x41f670,{'header':!![],'skipEmptyLines':!![],'step':function(_0x78b07a,_0x4b9ff1){const _0x1714d9=_0x72cbd;total+=0x1;const _0xc3afd7=total;promises[_0x1714d9('0x48')](checkRow(_0x78b07a,_0x34878f,_0xc3afd7)['then'](function(){success+=0x1;})['catch'](function(_0x4310dc){const _0x1b37cb=_0x1714d9;if(_0x4310dc['error'])errors+=0x1,delete _0x4310dc[_0x1b37cb('0x0')];else _0x4310dc[_0x1b37cb('0xa')]&&(duplicates+=0x1,delete _0x4310dc[_0x1b37cb('0xa')]);rows['push'](_0x4310dc);}));if(total%0xc8===0x0)return _0x4b9ff1[_0x1714d9('0x35')](),processPromises(_0x4b9ff1);},'complete':function(){const _0x1f6857=_0x72cbd;return processPromises()[_0x1f6857('0x6a')](function(){const _0x1f1a2c=_0x1f6857;logger[_0x1f1a2c('0x4d')](_0x1f1a2c('0x14')),endCsv();});},'error':function(_0x2dee66){const _0x1051d1=_0x72cbd;logger[_0x1051d1('0x4d')]('CSV\x20parse\x20error',JSON[_0x1051d1('0x45')](_0x2dee66)),endCsv();}});})[_0x29e862('0x6')](function(_0x4a334b){const _0x21eb17=_0x29e862;logger[_0x21eb17('0x0')](_0x21eb17('0x22'),JSON[_0x21eb17('0x45')](_0x4a334b));});}main();
\ No newline at end of file
git://repos.xcallymotion.com / motion-next.git / blobdiff