8660f1245746bdaf8497a57e8c54eb9e46797767
[motion-next.git] / server / components / import / cm / csv.js
1 const a830_0x507f=['stringify','select','inspect','findAll','VoiceQueue','outbound','error','then','CmContact','Error\x20while\x20creating\x20contact:\x20','contact','CSV\x20parsed\x20correctly!','papaparse','phone\x20not\x20specified!','errors','util','onlyIfOpen','message','length','phone','all','argv','insert','dialCheckDuplicateType','../../../rediscache','birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!','fromQuery','cm_hopper_black','undefined','id\x20IN\x20?','duplicate','updatedAt','CSV\x20parse\x20error','firstName','ListId\x20=\x20?','resume','cm_hopper','sequelize','pick','BlackLists','create','Error\x20executing\x20contact\x20csv\x20import:','email\x20format\x20is\x20not\x20valid!','exit','info','scheduledAt','resolve','CmList','finally','Unable\x20to\x20delete\x20temp\x20file:','push','get','keys','data','createReadStream','Lists','email','SIGINT','always','createdAt','moment','query','Missing\x20socket_timestamp\x20parameter!','from','CampaignId','ListId','parse','toString','NOW()','Error\x20processing\x20rows\x20block:','ContactId','split','Missing\x20ListId\x20parameter!','catch','../../../api/cmContact/cmContact.socket','\x20=\x20?','emit','phone\x20IS\x20NOT\x20NULL','deletedAt\x20IS\x20NULL','CSV\x20import\x20process\x20stopped!','field','pause','Missing\x20filepath\x20parameter!','contact:csv_','cmContact','../../../config/logger','firstName\x20not\x20specified!','cm_contacts','VoiceQueueId','zipObject','calleridnum','phone\x20NOT\x20IN\x20(?)','test','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','unlinkSync','null','str','where','into'];(function(_0x279495,_0x507f4f){const _0x3c50fd=function(_0x23123d){while(--_0x23123d){_0x279495['push'](_0x279495['shift']());}};_0x3c50fd(++_0x507f4f);}(a830_0x507f,0x18e));const a830_0x3c50=function(_0x279495,_0x507f4f){_0x279495=_0x279495-0x0;let _0x3c50fd=a830_0x507f[_0x279495];return _0x3c50fd;};const _0x2c28db=a830_0x3c50;'use strict';const util=require(_0x2c28db('0xd')),_=require('lodash'),fs=require('fs'),squel=require('squel'),Papa=require(_0x2c28db('0xa')),moment=require(_0x2c28db('0x3a')),db=require('../../../mysqldb')['db'],logger=require(_0x2c28db('0x53'))('api'),{getSocket}=require(_0x2c28db('0x16')),socket=getSocket();require(_0x2c28db('0x48'))['register'](socket);let FILEPATH,FIELDS,LISTID,COMPANYID,DUPLICATES,SOCKET_TIMESTAMP;try{if(!process['argv'][0x2]||process['argv'][0x2]===_0x2c28db('0x1a')||process[_0x2c28db('0x13')][0x2]===_0x2c28db('0x5d'))throw new Error(_0x2c28db('0x50'));FILEPATH=process[_0x2c28db('0x13')][0x2];if(!process['argv'][0x3]||process[_0x2c28db('0x13')][0x3]===_0x2c28db('0x1a')||process[_0x2c28db('0x13')][0x3]===_0x2c28db('0x5d')||!process[_0x2c28db('0x13')][0x4]||process[_0x2c28db('0x13')][0x4]==='undefined'||process[_0x2c28db('0x13')][0x4]===_0x2c28db('0x5d'))throw new Error('Missing\x20binding\x20parameters!');FIELDS=_[_0x2c28db('0x57')](process['argv'][0x3]['split'](','),process[_0x2c28db('0x13')][0x4]['split'](','));if(!process[_0x2c28db('0x13')][0x5]||process[_0x2c28db('0x13')][0x5]===_0x2c28db('0x1a')||process[_0x2c28db('0x13')][0x5]==='null')throw new Error(_0x2c28db('0x46'));LISTID=process[_0x2c28db('0x13')][0x5],COMPANYID=process[_0x2c28db('0x13')][0x6]&&process[_0x2c28db('0x13')][0x6]!==_0x2c28db('0x1a')&&process[_0x2c28db('0x13')][0x6]!==_0x2c28db('0x5d')?process[_0x2c28db('0x13')][0x6]:null,DUPLICATES=process['argv'][0x7]&&process['argv'][0x7]!=='undefined'&&process[_0x2c28db('0x13')][0x7]!==_0x2c28db('0x5d')?process[_0x2c28db('0x13')][0x7]:null;if(!process[_0x2c28db('0x13')][0x8]||process['argv'][0x8]==='undefined'||process['argv'][0x8]===_0x2c28db('0x5d'))throw new Error(_0x2c28db('0x3c'));SOCKET_TIMESTAMP=process[_0x2c28db('0x13')][0x8];}catch(a830_0x23123d){logger['error'](a830_0x23123d),endCsv();}let total=0x0,success=0x0,errors=0x0,duplicates=0x0,rows=[],hopperContacts='',promises=[];function handleCheckRowError(_0x57b338,_0x4b3764,_0x107f5d,_0x4f7f27){const _0x6dd58c=_0x2c28db,_0xf4280a={'message':_0x4b3764};return _0xf4280a[_0x57b338]=!![],_0x107f5d&&(_0xf4280a[_0x6dd58c('0x8')]=_0x107f5d),_0x4f7f27&&(_0xf4280a['index']=_0x4f7f27),_0xf4280a;}function isEmail(_0x317eb4){const _0x1c544b=_0x2c28db;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))*$/[_0x1c544b('0x5a')](_0x317eb4);}function checkRow(_0x56e1a6,_0x118259,_0x31acc6){return new Promise(function(_0x33a8b5,_0x2e7950){const _0x7b3eac=a830_0x3c50;if(_['isNil'](_0x56e1a6))return _0x2e7950(handleCheckRowError(_0x7b3eac('0x4'),_0x7b3eac('0x5b'),null,_0x31acc6));if(_0x56e1a6['errors']&&_0x56e1a6[_0x7b3eac('0xc')][_0x7b3eac('0x10')]){const _0x24add4=_['map'](_0x56e1a6['errors'],_0x7b3eac('0xf'))['join'](';');return _0x2e7950(handleCheckRowError(_0x7b3eac('0x4'),_0x24add4,null,_0x31acc6));}const _0xa180c6={};for(const _0x4a0c93 in FIELDS){typeof FIELDS[_0x4a0c93]!==_0x7b3eac('0x1a')&&FIELDS[_0x4a0c93]&&(_0xa180c6[_0x4a0c93]=_0x56e1a6['data'][0x0][FIELDS[_0x4a0c93]]||_0x56e1a6[_0x7b3eac('0x33')][0x0]['\ufeff'+FIELDS[_0x4a0c93]]);}if(!_0xa180c6[_0x7b3eac('0x1f')])return _0x2e7950(handleCheckRowError(_0x7b3eac('0x4'),_0x7b3eac('0x54'),null,_0x31acc6));if(!_0xa180c6['phone'])return _0x2e7950(handleCheckRowError(_0x7b3eac('0x4'),_0x7b3eac('0xb'),null,_0x31acc6));if(_0xa180c6['birthDate']){const _0x22a891=moment(_0xa180c6['birthDate'],'YYYY-MM-DD');if(!_0x22a891['isValid']())return _0x2e7950(handleCheckRowError('error',_0x7b3eac('0x17'),null,_0x31acc6));}if(_0xa180c6[_0x7b3eac('0x36')]){if(!isEmail(_0xa180c6[_0x7b3eac('0x36')]))return _0x2e7950(handleCheckRowError('error',_0x7b3eac('0x28'),null,_0x31acc6));}_0xa180c6[_0x7b3eac('0x3f')]=LISTID,_0xa180c6['CompanyId']=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES[_0x7b3eac('0x10')]&&_0x118259){const _0x599963={};for(let _0x51b196=0x0,_0x4919b0=DUPLICATES[_0x7b3eac('0x10')];_0x51b196<_0x4919b0;_0x51b196+=0x1){_0x599963[DUPLICATES[_0x51b196]]=_0xa180c6[DUPLICATES[_0x51b196]];}const _0x182437=_['find'](_0x118259,_0x599963);if(_0x182437)return _0x2e7950(handleCheckRowError(_0x7b3eac('0x1c'),'Duplicate\x20Contact',_0x182437,_0x31acc6));}return db[_0x7b3eac('0x6')][_0x7b3eac('0x26')](_0xa180c6,{'raw':!![],'hooks':![],'fields':_[_0x7b3eac('0x32')](_0xa180c6)})['then'](function(_0x425604){const _0x5e3600=_0x7b3eac;return DUPLICATES&&DUPLICATES[_0x5e3600('0x10')]&&_0x118259&&_0x118259[_0x5e3600('0x30')](_[_0x5e3600('0x24')](_0xa180c6,DUPLICATES)),hopperContacts+=(hopperContacts?',':'')+_0x425604['id'],_0x33a8b5();})[_0x7b3eac('0x47')](function(_0x45bf42){const _0x5ce62c=_0x7b3eac;return _0x2e7950(handleCheckRowError(_0x5ce62c('0x4'),_0x5ce62c('0x7')+(_0x45bf42[_0x5ce62c('0xf')]||JSON[_0x5ce62c('0x61')](_0x45bf42)),null,_0x31acc6));});});}function checkHopper(){const _0x2581d8=_0x2c28db;function _0x3b81e3(){return function(_0x30f0b4){const _0x561244=a830_0x3c50;logger['error'](_0x561244('0x52'),'checkHopper',util[_0x561244('0x0')](_0x30f0b4,{'showHidden':![],'depth':null}));};}const _0x1c7dd7=function(_0x1c199e,_0x5022b6){const _0x46bf4d=a830_0x3c50,_0x13c940=squel[_0x46bf4d('0x14')]()[_0x46bf4d('0x60')](_0x46bf4d('0x22'))[_0x46bf4d('0x18')]([_0x46bf4d('0x11'),_0x46bf4d('0x2b'),_0x46bf4d('0x44'),_0x46bf4d('0x3f'),_0x5022b6,_0x46bf4d('0x39'),'updatedAt'],squel[_0x46bf4d('0x62')]()[_0x46bf4d('0x4e')]('phone',_0x46bf4d('0x11'))[_0x46bf4d('0x4e')](_0x46bf4d('0x42'),_0x46bf4d('0x2b'))[_0x46bf4d('0x4e')]('id','ContactId')[_0x46bf4d('0x4e')](LISTID[_0x46bf4d('0x41')](),'ListId')[_0x46bf4d('0x4e')](_0x1c199e['id']['toString'](),_0x5022b6)['field'](_0x46bf4d('0x42'),_0x46bf4d('0x39'))[_0x46bf4d('0x4e')]('NOW()','updatedAt')[_0x46bf4d('0x3d')](_0x46bf4d('0x55'))['where'](_0x46bf4d('0x4c'))['where']('ListId\x20=\x20?',LISTID['toString']())['where'](_0x46bf4d('0x4b'))[_0x46bf4d('0x5f')](_0x46bf4d('0x59'),squel[_0x46bf4d('0x62')]()['field'](_0x46bf4d('0x11'))['from'](_0x46bf4d('0x22'))[_0x46bf4d('0x5f')](_0x5022b6+_0x46bf4d('0x49'),_0x1c199e['id'][_0x46bf4d('0x41')]())))[_0x46bf4d('0x41')]();return _0x13c940;},_0x33f5c9=function(_0x5b054c,_0x917923){const _0x28ff5f=a830_0x3c50,_0xabbcce=squel[_0x28ff5f('0x14')]()['into'](_0x28ff5f('0x22'))[_0x28ff5f('0x18')]([_0x28ff5f('0x11'),'scheduledAt',_0x28ff5f('0x44'),_0x28ff5f('0x3f'),_0x917923,_0x28ff5f('0x39'),_0x28ff5f('0x1d')],squel[_0x28ff5f('0x62')]()[_0x28ff5f('0x4e')](_0x28ff5f('0x11'),_0x28ff5f('0x11'))[_0x28ff5f('0x4e')]('NOW()',_0x28ff5f('0x2b'))[_0x28ff5f('0x4e')]('id',_0x28ff5f('0x44'))[_0x28ff5f('0x4e')](LISTID[_0x28ff5f('0x41')](),'ListId')[_0x28ff5f('0x4e')](_0x5b054c['id'][_0x28ff5f('0x41')](),_0x917923)[_0x28ff5f('0x4e')](_0x28ff5f('0x42'),'createdAt')[_0x28ff5f('0x4e')](_0x28ff5f('0x42'),_0x28ff5f('0x1d'))['from']('cm_contacts')[_0x28ff5f('0x5f')]('deletedAt\x20IS\x20NULL')[_0x28ff5f('0x5f')](_0x28ff5f('0x20'),LISTID['toString']())[_0x28ff5f('0x5f')]('id\x20IN\x20?',squel[_0x28ff5f('0x5e')](hopperContacts))[_0x28ff5f('0x5f')](_0x28ff5f('0x4b'))[_0x28ff5f('0x5f')](_0x28ff5f('0x59'),squel[_0x28ff5f('0x62')]()[_0x28ff5f('0x4e')](_0x28ff5f('0x58'))['from']('cm_hopper_final')[_0x28ff5f('0x5f')](_0x917923+'\x20=\x20?',_0x5b054c['id'][_0x28ff5f('0x41')]()))['where']('phone\x20NOT\x20IN\x20(?)',squel[_0x28ff5f('0x62')]()[_0x28ff5f('0x4e')](_0x28ff5f('0x11'))['from'](_0x28ff5f('0x22'))[_0x28ff5f('0x5f')](_0x917923+_0x28ff5f('0x49'),_0x5b054c['id'][_0x28ff5f('0x41')]())))['toString']();return _0xabbcce;};function _0x19901c(_0x4535c6,_0x202831){const _0x45d2ab=a830_0x3c50,_0x6595b5=squel[_0x45d2ab('0x14')]()['into'](_0x45d2ab('0x22'))[_0x45d2ab('0x18')]([_0x45d2ab('0x11'),_0x45d2ab('0x2b'),'ContactId',_0x45d2ab('0x3f'),_0x202831,'createdAt','updatedAt'],squel[_0x45d2ab('0x62')]()[_0x45d2ab('0x4e')](_0x45d2ab('0x11'),_0x45d2ab('0x11'))['field'](_0x45d2ab('0x42'),_0x45d2ab('0x2b'))['field']('id','ContactId')['field'](LISTID[_0x45d2ab('0x41')](),_0x45d2ab('0x3f'))[_0x45d2ab('0x4e')](_0x4535c6['id'][_0x45d2ab('0x41')](),_0x202831)[_0x45d2ab('0x4e')]('NOW()',_0x45d2ab('0x39'))[_0x45d2ab('0x4e')](_0x45d2ab('0x42'),_0x45d2ab('0x1d'))['from'](_0x45d2ab('0x55'))[_0x45d2ab('0x5f')](_0x45d2ab('0x4c'))[_0x45d2ab('0x5f')](_0x45d2ab('0x20'),LISTID[_0x45d2ab('0x41')]())[_0x45d2ab('0x5f')](_0x45d2ab('0x1b'),squel[_0x45d2ab('0x5e')](hopperContacts))['where'](_0x45d2ab('0x4b')))['toString']();return _0x6595b5;}function _0x4d72cf(_0x1904fe,_0x1b38d9){const _0x2210c6=a830_0x3c50,_0x42fb2d=squel[_0x2210c6('0x14')]()['into'](_0x2210c6('0x19'))[_0x2210c6('0x18')](['phone','ContactId',_0x2210c6('0x3f'),_0x1b38d9,_0x2210c6('0x39'),_0x2210c6('0x1d')],squel[_0x2210c6('0x62')]()[_0x2210c6('0x4e')](_0x2210c6('0x11'),_0x2210c6('0x11'))[_0x2210c6('0x4e')]('id',_0x2210c6('0x44'))[_0x2210c6('0x4e')](LISTID[_0x2210c6('0x41')](),_0x2210c6('0x3f'))[_0x2210c6('0x4e')](_0x1904fe['id'][_0x2210c6('0x41')](),_0x1b38d9)[_0x2210c6('0x4e')](_0x2210c6('0x42'),_0x2210c6('0x39'))[_0x2210c6('0x4e')]('NOW()','updatedAt')[_0x2210c6('0x3d')](_0x2210c6('0x55'))[_0x2210c6('0x5f')](_0x2210c6('0x4c'))[_0x2210c6('0x5f')](_0x2210c6('0x20'),LISTID[_0x2210c6('0x41')]())[_0x2210c6('0x5f')](_0x2210c6('0x1b'),squel[_0x2210c6('0x5e')](hopperContacts))[_0x2210c6('0x5f')](_0x2210c6('0x4b')))[_0x2210c6('0x41')]();return _0x42fb2d;}return db[_0x2581d8('0x2')][_0x2581d8('0x1')]({'where':{'type':_0x2581d8('0x3')},'attributes':['id',_0x2581d8('0x15')],'include':[{'model':db[_0x2581d8('0x2d')],'as':_0x2581d8('0x35'),'where':{'id':LISTID}}]})[_0x2581d8('0x5')](function(_0x300e43){const _0x581f15=_0x2581d8,_0x4e9619=[];if(_0x300e43)for(let _0x25b48b=0x0,_0x8e5f8a;_0x25b48b<_0x300e43[_0x581f15('0x10')];_0x25b48b+=0x1){_0x8e5f8a=_0x300e43[_0x25b48b][_0x581f15('0x31')]({'plain':!![]});switch(_0x8e5f8a[_0x581f15('0x15')]){case _0x581f15('0x38'):_0x4e9619[_0x581f15('0x30')](db['sequelize']['query'](_0x33f5c9(_0x8e5f8a,_0x581f15('0x56')))['then'](function(){})[_0x581f15('0x47')](_0x3b81e3()));break;case _0x581f15('0xe'):_0x4e9619[_0x581f15('0x30')](db['sequelize'][_0x581f15('0x3b')](_0x1c7dd7(_0x8e5f8a,'VoiceQueueId'))['then'](function(){})[_0x581f15('0x47')](_0x3b81e3()));break;default:_0x4e9619[_0x581f15('0x30')](db[_0x581f15('0x23')][_0x581f15('0x3b')](_0x19901c(_0x8e5f8a,_0x581f15('0x56')))[_0x581f15('0x5')](function(){})[_0x581f15('0x47')](_0x3b81e3()));}}return _0x4e9619;})['all']()['then'](function(){const _0x5ceb58=_0x2581d8;return db[_0x5ceb58('0x2')][_0x5ceb58('0x1')]({'where':{'type':_0x5ceb58('0x3')},'attributes':['id'],'include':[{'model':db[_0x5ceb58('0x2d')],'as':_0x5ceb58('0x25'),'where':{'id':LISTID}}]})[_0x5ceb58('0x5')](function(_0x39f961){const _0x4b81f1=_0x5ceb58,_0x4b0ae6=[];if(_0x39f961)for(let _0x4642a3=0x0,_0x194a6e;_0x4642a3<_0x39f961[_0x4b81f1('0x10')];_0x4642a3+=0x1){_0x194a6e=_0x39f961[_0x4642a3][_0x4b81f1('0x31')]({'plain':!![]}),_0x4b0ae6[_0x4b81f1('0x30')](db['sequelize']['query'](_0x4d72cf(_0x194a6e,_0x4b81f1('0x56')))['then'](function(){})[_0x4b81f1('0x47')](_0x3b81e3()));}return _0x4b0ae6;})[_0x5ceb58('0x12')]();})[_0x2581d8('0x5')](function(){const _0x38c593=_0x2581d8;return db['Campaign'][_0x38c593('0x1')]({'attributes':['id',_0x38c593('0x15')],'include':[{'model':db[_0x38c593('0x2d')],'as':_0x38c593('0x35'),'where':{'id':LISTID}}]})[_0x38c593('0x5')](function(_0x20dceb){const _0x2ba9e2=_0x38c593,_0x35a71c=[];if(_0x20dceb)for(let _0x3a69cb=0x0,_0x364e69;_0x3a69cb<_0x20dceb[_0x2ba9e2('0x10')];_0x3a69cb+=0x1){_0x364e69=_0x20dceb[_0x3a69cb]['get']({'plain':!![]});switch(_0x364e69[_0x2ba9e2('0x15')]){case _0x2ba9e2('0x38'):_0x35a71c[_0x2ba9e2('0x30')](db[_0x2ba9e2('0x23')][_0x2ba9e2('0x3b')](_0x33f5c9(_0x364e69,_0x2ba9e2('0x3e')))[_0x2ba9e2('0x5')](function(){})[_0x2ba9e2('0x47')](_0x3b81e3()));break;case _0x2ba9e2('0xe'):_0x35a71c[_0x2ba9e2('0x30')](db['sequelize'][_0x2ba9e2('0x3b')](_0x1c7dd7(_0x364e69,_0x2ba9e2('0x3e')))[_0x2ba9e2('0x5')](function(){})[_0x2ba9e2('0x47')](_0x3b81e3()));break;default:_0x35a71c[_0x2ba9e2('0x30')](db['sequelize'][_0x2ba9e2('0x3b')](_0x19901c(_0x364e69,_0x2ba9e2('0x3e')))[_0x2ba9e2('0x5')](function(){})['catch'](_0x3b81e3()));}}return _0x35a71c;})[_0x38c593('0x12')]();})[_0x2581d8('0x5')](function(){const _0x150dec=_0x2581d8;return db['Campaign']['findAll']({'attributes':['id'],'include':[{'model':db[_0x150dec('0x2d')],'as':_0x150dec('0x25'),'where':{'id':LISTID}}]})[_0x150dec('0x5')](function(_0x51c90c){const _0x4d6a1c=_0x150dec,_0x30331e=[];if(_0x51c90c)for(let _0x1a62ba=0x0,_0x4a7c60;_0x1a62ba<_0x51c90c['length'];_0x1a62ba+=0x1){_0x4a7c60=_0x51c90c[_0x1a62ba][_0x4d6a1c('0x31')]({'plain':!![]}),_0x30331e[_0x4d6a1c('0x30')](db[_0x4d6a1c('0x23')]['query'](_0x4d72cf(_0x4a7c60,_0x4d6a1c('0x3e')))[_0x4d6a1c('0x5')](function(){})[_0x4d6a1c('0x47')](_0x3b81e3()));}return _0x30331e;})[_0x150dec('0x12')]();})[_0x2581d8('0x47')](function(_0x37a5b0){const _0x191387=_0x2581d8;logger[_0x191387('0x4')]('cmContact,\x20%s,\x20%s','generalCheckHopper',_0x37a5b0[_0x191387('0xf')]);});}const processPromises=function(_0x611e9c){const _0x151093=_0x2c28db;return Promise[_0x151093('0x12')](promises)[_0x151093('0x47')](function(_0x2600f6){const _0x1e2f9c=_0x151093;logger['error'](_0x1e2f9c('0x43'),JSON[_0x1e2f9c('0x61')](_0x2600f6));})[_0x151093('0x2e')](function(){const _0x25d126=_0x151093;socket[_0x25d126('0x4a')]('contact:csv_'+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows}),promises=[],success=0x0,errors=0x0,duplicates=0x0,rows=[];if(_0x611e9c)return _0x611e9c[_0x25d126('0x21')]();});},endCsv=function(){const _0x33c199=_0x2c28db;return Promise['resolve']()[_0x33c199('0x5')](function(){if(hopperContacts)return checkHopper();})[_0x33c199('0x5')](function(){const _0x58deb6=_0x33c199;socket[_0x58deb6('0x4a')](_0x58deb6('0x51')+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x58deb6('0x5c')](FILEPATH);}catch(_0x5252a9){logger['error'](_0x58deb6('0x2f'),JSON[_0x58deb6('0x61')](_0x5252a9));}finally{process[_0x58deb6('0x29')](0x0);}});};process['on'](_0x2c28db('0x37'),function(){const _0x3b2807=_0x2c28db;logger[_0x3b2807('0x2a')](_0x3b2807('0x4d')),endCsv();});function main(){const _0x3e3ca2=_0x2c28db;return Promise[_0x3e3ca2('0x2c')]()['then'](function(){const _0x515d09=_0x3e3ca2;if(DUPLICATES)return DUPLICATES=DUPLICATES[_0x515d09('0x45')](','),db[_0x515d09('0x6')][_0x515d09('0x1')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});})[_0x3e3ca2('0x5')](function(_0x64f1f4){const _0x1ad289=_0x3e3ca2,_0x549686=fs[_0x1ad289('0x34')](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0x1ad289('0x40')](_0x549686,{'header':!![],'skipEmptyLines':!![],'step':function(_0x28f3b3,_0x4335ec){const _0xe43695=_0x1ad289;total+=0x1;const _0x19fc77=total;promises[_0xe43695('0x30')](checkRow(_0x28f3b3,_0x64f1f4,_0x19fc77)[_0xe43695('0x5')](function(){success+=0x1;})[_0xe43695('0x47')](function(_0x2ed3d4){const _0x54a592=_0xe43695;if(_0x2ed3d4[_0x54a592('0x4')])errors+=0x1,delete _0x2ed3d4[_0x54a592('0x4')];else _0x2ed3d4[_0x54a592('0x1c')]&&(duplicates+=0x1,delete _0x2ed3d4[_0x54a592('0x1c')]);rows[_0x54a592('0x30')](_0x2ed3d4);}));if(total%0xc8===0x0)return _0x4335ec[_0xe43695('0x4f')](),processPromises(_0x4335ec);},'complete':function(){const _0x52e411=_0x1ad289;return processPromises()[_0x52e411('0x5')](function(){const _0x3d2a2b=_0x52e411;logger[_0x3d2a2b('0x2a')](_0x3d2a2b('0x9')),endCsv();});},'error':function(_0x2cd5e7){const _0x1e5ee1=_0x1ad289;logger['info'](_0x1e5ee1('0x1e'),JSON[_0x1e5ee1('0x61')](_0x2cd5e7)),endCsv();}});})[_0x3e3ca2('0x47')](function(_0x119d5c){const _0x967f52=_0x3e3ca2;logger[_0x967f52('0x4')](_0x967f52('0x27'),JSON[_0x967f52('0x61')](_0x119d5c));});}main();