004fda516897c8956f7c863fd8f121a2cd4fdfc6
[motion-next.git] / server / components / import / cm / csv.js
1 const a830_0xa914=['create','get','CSV\x20parsed\x20correctly!','findAll','phone\x20NOT\x20IN\x20(?)','VoiceQueue','then','inspect','CampaignId','catch','createdAt','../../../api/cmContact/cmContact.socket','id\x20IN\x20?','join','message','squel','CompanyId','cm_contacts','api','outbound','NOW()','phone\x20IS\x20NOT\x20NULL','finally','from','generalCheckHopper','parse','null','always','dialCheckDuplicateType','../../../config/logger','email','scheduledAt','push','insert','CmContact','Missing\x20socket_timestamp\x20parameter!','SIGINT','undefined','str','error','firstName','deletedAt\x20IS\x20NULL','emit','papaparse','pick','Missing\x20ListId\x20parameter!','birthDate','firstName\x20not\x20specified!','fromQuery','lodash','zipObject','field','exit','toString','onlyIfOpen','ContactId','stringify','duplicate','index','all','argv','Error\x20executing\x20contact\x20csv\x20import:','Missing\x20filepath\x20parameter!','updatedAt','phone','query','BlackLists','ListId\x20=\x20?','cm_hopper_final','checkHopper','info','calleridnum','birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!','Duplicate\x20Contact','into','util','isValid','Missing\x20binding\x20parameters!','cm_hopper','resume','length','contact','CmList','contact:csv_','sequelize','find','Error\x20processing\x20rows\x20block:','map','resolve','errors','split','phone\x20not\x20specified!','register','CSV\x20parse\x20error','\x20=\x20?','Campaign','VoiceQueueId','select','moment','where','../../../mysqldb','ListId','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','cmContact,\x20%s,\x20%s','unlinkSync'];(function(_0x670b5,_0xa9145){const _0x249977=function(_0x502ac3){while(--_0x502ac3){_0x670b5['push'](_0x670b5['shift']());}};_0x249977(++_0xa9145);}(a830_0xa914,0xd5));const a830_0x2499=function(_0x670b5,_0xa9145){_0x670b5=_0x670b5-0x0;let _0x249977=a830_0xa914[_0x670b5];return _0x249977;};const _0x24d81b=a830_0x2499;'use strict';const util=require(_0x24d81b('0x48')),_=require(_0x24d81b('0x2e')),fs=require('fs'),squel=require(_0x24d81b('0xc')),Papa=require(_0x24d81b('0x28')),moment=require(_0x24d81b('0x5f')),db=require(_0x24d81b('0x61'))['db'],logger=require(_0x24d81b('0x1a'))(_0x24d81b('0xf')),{getSocket}=require('../../../rediscache'),socket=getSocket();require(_0x24d81b('0x8'))[_0x24d81b('0x59')](socket);let FILEPATH,FIELDS,LISTID,COMPANYID,DUPLICATES,SOCKET_TIMESTAMP;try{if(!process[_0x24d81b('0x39')][0x2]||process[_0x24d81b('0x39')][0x2]===_0x24d81b('0x22')||process['argv'][0x2]===_0x24d81b('0x17'))throw new Error(_0x24d81b('0x3b'));FILEPATH=process['argv'][0x2];if(!process['argv'][0x3]||process[_0x24d81b('0x39')][0x3]===_0x24d81b('0x22')||process[_0x24d81b('0x39')][0x3]===_0x24d81b('0x17')||!process[_0x24d81b('0x39')][0x4]||process[_0x24d81b('0x39')][0x4]==='undefined'||process[_0x24d81b('0x39')][0x4]==='null')throw new Error(_0x24d81b('0x4a'));FIELDS=_[_0x24d81b('0x2f')](process[_0x24d81b('0x39')][0x3][_0x24d81b('0x57')](','),process['argv'][0x4]['split'](','));if(!process[_0x24d81b('0x39')][0x5]||process['argv'][0x5]===_0x24d81b('0x22')||process[_0x24d81b('0x39')][0x5]===_0x24d81b('0x17'))throw new Error(_0x24d81b('0x2a'));LISTID=process[_0x24d81b('0x39')][0x5],COMPANYID=process[_0x24d81b('0x39')][0x6]&&process[_0x24d81b('0x39')][0x6]!=='undefined'&&process['argv'][0x6]!==_0x24d81b('0x17')?process[_0x24d81b('0x39')][0x6]:null,DUPLICATES=process[_0x24d81b('0x39')][0x7]&&process[_0x24d81b('0x39')][0x7]!==_0x24d81b('0x22')&&process[_0x24d81b('0x39')][0x7]!==_0x24d81b('0x17')?process[_0x24d81b('0x39')][0x7]:null;if(!process[_0x24d81b('0x39')][0x8]||process[_0x24d81b('0x39')][0x8]==='undefined'||process['argv'][0x8]===_0x24d81b('0x17'))throw new Error(_0x24d81b('0x20'));SOCKET_TIMESTAMP=process[_0x24d81b('0x39')][0x8];}catch(a830_0x502ac3){logger[_0x24d81b('0x24')](a830_0x502ac3),endCsv();}let total=0x0,success=0x0,errors=0x0,duplicates=0x0,rows=[],hopperContacts='',promises=[];function handleCheckRowError(_0x31f92d,_0x4b0663,_0x4177eb,_0x4e6caf){const _0x4e0b8c=_0x24d81b,_0x5bafc6={'message':_0x4b0663};return _0x5bafc6[_0x31f92d]=!![],_0x4177eb&&(_0x5bafc6[_0x4e0b8c('0x4e')]=_0x4177eb),_0x4e6caf&&(_0x5bafc6[_0x4e0b8c('0x37')]=_0x4e6caf),_0x5bafc6;}function isEmail(_0x113f42){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))*$/['test'](_0x113f42);}function checkRow(_0x41f55b,_0x217264,_0x2cddf6){return new Promise(function(_0xe50011,_0x58d0ec){const _0x4f7a93=a830_0x2499;if(_['isNil'](_0x41f55b))return _0x58d0ec(handleCheckRowError(_0x4f7a93('0x24'),_0x4f7a93('0x63'),null,_0x2cddf6));if(_0x41f55b['errors']&&_0x41f55b['errors'][_0x4f7a93('0x4d')]){const _0x5953f6=_[_0x4f7a93('0x54')](_0x41f55b[_0x4f7a93('0x56')],_0x4f7a93('0xb'))[_0x4f7a93('0xa')](';');return _0x58d0ec(handleCheckRowError(_0x4f7a93('0x24'),_0x5953f6,null,_0x2cddf6));}const _0xa7d246={};for(const _0x1a426e in FIELDS){typeof FIELDS[_0x1a426e]!==_0x4f7a93('0x22')&&FIELDS[_0x1a426e]&&(_0xa7d246[_0x1a426e]=_0x41f55b['data'][0x0][FIELDS[_0x1a426e]]||_0x41f55b['data'][0x0]['\ufeff'+FIELDS[_0x1a426e]]);}if(!_0xa7d246[_0x4f7a93('0x25')])return _0x58d0ec(handleCheckRowError(_0x4f7a93('0x24'),_0x4f7a93('0x2c'),null,_0x2cddf6));if(!_0xa7d246[_0x4f7a93('0x3d')])return _0x58d0ec(handleCheckRowError(_0x4f7a93('0x24'),_0x4f7a93('0x58'),null,_0x2cddf6));if(_0xa7d246[_0x4f7a93('0x2b')]){const _0x7a4f5b=moment(_0xa7d246[_0x4f7a93('0x2b')],'YYYY-MM-DD');if(!_0x7a4f5b[_0x4f7a93('0x49')]())return _0x58d0ec(handleCheckRowError(_0x4f7a93('0x24'),_0x4f7a93('0x45'),null,_0x2cddf6));}if(_0xa7d246[_0x4f7a93('0x1b')]){if(!isEmail(_0xa7d246[_0x4f7a93('0x1b')]))return _0x58d0ec(handleCheckRowError(_0x4f7a93('0x24'),'email\x20format\x20is\x20not\x20valid!',null,_0x2cddf6));}_0xa7d246[_0x4f7a93('0x62')]=LISTID,_0xa7d246[_0x4f7a93('0xd')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES[_0x4f7a93('0x4d')]&&_0x217264){const _0xbdc8dd={};for(let _0x288759=0x0,_0x2a6069=DUPLICATES[_0x4f7a93('0x4d')];_0x288759<_0x2a6069;_0x288759+=0x1){_0xbdc8dd[DUPLICATES[_0x288759]]=_0xa7d246[DUPLICATES[_0x288759]];}const _0x2d48fb=_[_0x4f7a93('0x52')](_0x217264,_0xbdc8dd);if(_0x2d48fb)return _0x58d0ec(handleCheckRowError(_0x4f7a93('0x36'),_0x4f7a93('0x46'),_0x2d48fb,_0x2cddf6));}return db[_0x4f7a93('0x1f')][_0x4f7a93('0x66')](_0xa7d246,{'raw':!![],'hooks':![],'fields':_['keys'](_0xa7d246)})['then'](function(_0x32ab91){const _0x6d8111=_0x4f7a93;return DUPLICATES&&DUPLICATES[_0x6d8111('0x4d')]&&_0x217264&&_0x217264['push'](_[_0x6d8111('0x29')](_0xa7d246,DUPLICATES)),hopperContacts+=(hopperContacts?',':'')+_0x32ab91['id'],_0xe50011();})[_0x4f7a93('0x6')](function(_0x4cf2ed){const _0x44e4f9=_0x4f7a93;return _0x58d0ec(handleCheckRowError(_0x44e4f9('0x24'),'Error\x20while\x20creating\x20contact:\x20'+(_0x4cf2ed['message']||JSON['stringify'](_0x4cf2ed)),null,_0x2cddf6));});});}function checkHopper(){const _0x1630ed=_0x24d81b;function _0x41d899(){return function(_0x26c333){const _0xbcc9f9=a830_0x2499;logger[_0xbcc9f9('0x24')]('cmContact',_0xbcc9f9('0x42'),util[_0xbcc9f9('0x4')](_0x26c333,{'showHidden':![],'depth':null}));};}const _0x29adb3=function(_0xe4b2b2,_0x5c1a8d){const _0xad9bf1=a830_0x2499,_0x406648=squel[_0xad9bf1('0x1e')]()[_0xad9bf1('0x47')]('cm_hopper')[_0xad9bf1('0x2d')]([_0xad9bf1('0x3d'),_0xad9bf1('0x1c'),_0xad9bf1('0x34'),'ListId',_0x5c1a8d,_0xad9bf1('0x7'),'updatedAt'],squel[_0xad9bf1('0x5e')]()['field']('phone',_0xad9bf1('0x3d'))[_0xad9bf1('0x30')](_0xad9bf1('0x11'),_0xad9bf1('0x1c'))[_0xad9bf1('0x30')]('id',_0xad9bf1('0x34'))['field'](LISTID[_0xad9bf1('0x32')](),_0xad9bf1('0x62'))['field'](_0xe4b2b2['id'][_0xad9bf1('0x32')](),_0x5c1a8d)[_0xad9bf1('0x30')](_0xad9bf1('0x11'),'createdAt')[_0xad9bf1('0x30')]('NOW()',_0xad9bf1('0x3c'))[_0xad9bf1('0x14')](_0xad9bf1('0xe'))[_0xad9bf1('0x60')](_0xad9bf1('0x26'))['where']('ListId\x20=\x20?',LISTID['toString']())[_0xad9bf1('0x60')]('phone\x20IS\x20NOT\x20NULL')[_0xad9bf1('0x60')](_0xad9bf1('0x1'),squel[_0xad9bf1('0x5e')]()[_0xad9bf1('0x30')]('phone')[_0xad9bf1('0x14')]('cm_hopper')[_0xad9bf1('0x60')](_0x5c1a8d+_0xad9bf1('0x5b'),_0xe4b2b2['id']['toString']())))[_0xad9bf1('0x32')]();return _0x406648;},_0x4d0727=function(_0x4b5571,_0x4701cc){const _0x438e82=a830_0x2499,_0x591dff=squel['insert']()[_0x438e82('0x47')](_0x438e82('0x4b'))[_0x438e82('0x2d')]([_0x438e82('0x3d'),_0x438e82('0x1c'),_0x438e82('0x34'),_0x438e82('0x62'),_0x4701cc,_0x438e82('0x7'),'updatedAt'],squel[_0x438e82('0x5e')]()['field'](_0x438e82('0x3d'),_0x438e82('0x3d'))[_0x438e82('0x30')](_0x438e82('0x11'),_0x438e82('0x1c'))[_0x438e82('0x30')]('id',_0x438e82('0x34'))[_0x438e82('0x30')](LISTID['toString'](),_0x438e82('0x62'))[_0x438e82('0x30')](_0x4b5571['id'][_0x438e82('0x32')](),_0x4701cc)[_0x438e82('0x30')](_0x438e82('0x11'),_0x438e82('0x7'))[_0x438e82('0x30')](_0x438e82('0x11'),_0x438e82('0x3c'))[_0x438e82('0x14')](_0x438e82('0xe'))['where'](_0x438e82('0x26'))[_0x438e82('0x60')](_0x438e82('0x40'),LISTID[_0x438e82('0x32')]())['where'](_0x438e82('0x9'),squel[_0x438e82('0x23')](hopperContacts))['where'](_0x438e82('0x12'))[_0x438e82('0x60')]('phone\x20NOT\x20IN\x20(?)',squel[_0x438e82('0x5e')]()[_0x438e82('0x30')](_0x438e82('0x44'))[_0x438e82('0x14')](_0x438e82('0x41'))[_0x438e82('0x60')](_0x4701cc+_0x438e82('0x5b'),_0x4b5571['id'][_0x438e82('0x32')]()))[_0x438e82('0x60')](_0x438e82('0x1'),squel['select']()[_0x438e82('0x30')](_0x438e82('0x3d'))[_0x438e82('0x14')](_0x438e82('0x4b'))[_0x438e82('0x60')](_0x4701cc+_0x438e82('0x5b'),_0x4b5571['id'][_0x438e82('0x32')]())))[_0x438e82('0x32')]();return _0x591dff;};function _0x35c175(_0x3541ec,_0x44604c){const _0x55e427=a830_0x2499,_0x5db484=squel[_0x55e427('0x1e')]()[_0x55e427('0x47')]('cm_hopper')[_0x55e427('0x2d')]([_0x55e427('0x3d'),_0x55e427('0x1c'),_0x55e427('0x34'),'ListId',_0x44604c,_0x55e427('0x7'),_0x55e427('0x3c')],squel[_0x55e427('0x5e')]()['field'](_0x55e427('0x3d'),_0x55e427('0x3d'))[_0x55e427('0x30')](_0x55e427('0x11'),_0x55e427('0x1c'))['field']('id','ContactId')[_0x55e427('0x30')](LISTID[_0x55e427('0x32')](),_0x55e427('0x62'))[_0x55e427('0x30')](_0x3541ec['id']['toString'](),_0x44604c)[_0x55e427('0x30')](_0x55e427('0x11'),_0x55e427('0x7'))['field'](_0x55e427('0x11'),'updatedAt')['from']('cm_contacts')['where'](_0x55e427('0x26'))['where'](_0x55e427('0x40'),LISTID[_0x55e427('0x32')]())['where'](_0x55e427('0x9'),squel[_0x55e427('0x23')](hopperContacts))['where'](_0x55e427('0x12')))[_0x55e427('0x32')]();return _0x5db484;}function _0x3a2dc8(_0x4dbf1d,_0x1ea69d){const _0x197321=a830_0x2499,_0x26f4f0=squel[_0x197321('0x1e')]()['into']('cm_hopper_black')[_0x197321('0x2d')]([_0x197321('0x3d'),'ContactId',_0x197321('0x62'),_0x1ea69d,_0x197321('0x7'),'updatedAt'],squel[_0x197321('0x5e')]()[_0x197321('0x30')]('phone',_0x197321('0x3d'))[_0x197321('0x30')]('id',_0x197321('0x34'))['field'](LISTID[_0x197321('0x32')](),_0x197321('0x62'))[_0x197321('0x30')](_0x4dbf1d['id'][_0x197321('0x32')](),_0x1ea69d)[_0x197321('0x30')]('NOW()',_0x197321('0x7'))[_0x197321('0x30')](_0x197321('0x11'),_0x197321('0x3c'))['from'](_0x197321('0xe'))[_0x197321('0x60')](_0x197321('0x26'))['where'](_0x197321('0x40'),LISTID[_0x197321('0x32')]())[_0x197321('0x60')](_0x197321('0x9'),squel[_0x197321('0x23')](hopperContacts))[_0x197321('0x60')]('phone\x20IS\x20NOT\x20NULL'))[_0x197321('0x32')]();return _0x26f4f0;}return db['VoiceQueue']['findAll']({'where':{'type':_0x1630ed('0x10')},'attributes':['id',_0x1630ed('0x19')],'include':[{'model':db['CmList'],'as':'Lists','where':{'id':LISTID}}]})[_0x1630ed('0x3')](function(_0x4d8c13){const _0x33cd5e=_0x1630ed,_0x50778b=[];if(_0x4d8c13)for(let _0x14b506=0x0,_0x2c1535;_0x14b506<_0x4d8c13['length'];_0x14b506+=0x1){_0x2c1535=_0x4d8c13[_0x14b506][_0x33cd5e('0x67')]({'plain':!![]});switch(_0x2c1535['dialCheckDuplicateType']){case _0x33cd5e('0x18'):_0x50778b[_0x33cd5e('0x1d')](db[_0x33cd5e('0x51')][_0x33cd5e('0x3e')](_0x4d0727(_0x2c1535,_0x33cd5e('0x5d')))[_0x33cd5e('0x3')](function(){})[_0x33cd5e('0x6')](_0x41d899()));break;case _0x33cd5e('0x33'):_0x50778b[_0x33cd5e('0x1d')](db[_0x33cd5e('0x51')][_0x33cd5e('0x3e')](_0x29adb3(_0x2c1535,'VoiceQueueId'))[_0x33cd5e('0x3')](function(){})[_0x33cd5e('0x6')](_0x41d899()));break;default:_0x50778b[_0x33cd5e('0x1d')](db['sequelize']['query'](_0x35c175(_0x2c1535,_0x33cd5e('0x5d')))['then'](function(){})[_0x33cd5e('0x6')](_0x41d899()));}}return _0x50778b;})[_0x1630ed('0x38')]()[_0x1630ed('0x3')](function(){const _0xb0a16b=_0x1630ed;return db[_0xb0a16b('0x2')][_0xb0a16b('0x0')]({'where':{'type':_0xb0a16b('0x10')},'attributes':['id'],'include':[{'model':db[_0xb0a16b('0x4f')],'as':_0xb0a16b('0x3f'),'where':{'id':LISTID}}]})[_0xb0a16b('0x3')](function(_0x33d1c4){const _0x11aefb=_0xb0a16b,_0x5b79f9=[];if(_0x33d1c4)for(let _0x5ca19b=0x0,_0x2ec8e7;_0x5ca19b<_0x33d1c4[_0x11aefb('0x4d')];_0x5ca19b+=0x1){_0x2ec8e7=_0x33d1c4[_0x5ca19b][_0x11aefb('0x67')]({'plain':!![]}),_0x5b79f9['push'](db[_0x11aefb('0x51')][_0x11aefb('0x3e')](_0x3a2dc8(_0x2ec8e7,'VoiceQueueId'))[_0x11aefb('0x3')](function(){})[_0x11aefb('0x6')](_0x41d899()));}return _0x5b79f9;})['all']();})[_0x1630ed('0x3')](function(){const _0x5dc20b=_0x1630ed;return db[_0x5dc20b('0x5c')][_0x5dc20b('0x0')]({'attributes':['id',_0x5dc20b('0x19')],'include':[{'model':db['CmList'],'as':'Lists','where':{'id':LISTID}}]})[_0x5dc20b('0x3')](function(_0x285f89){const _0x40a42c=_0x5dc20b,_0x387301=[];if(_0x285f89)for(let _0x4fa2d7=0x0,_0x5cfbc4;_0x4fa2d7<_0x285f89[_0x40a42c('0x4d')];_0x4fa2d7+=0x1){_0x5cfbc4=_0x285f89[_0x4fa2d7]['get']({'plain':!![]});switch(_0x5cfbc4[_0x40a42c('0x19')]){case _0x40a42c('0x18'):_0x387301[_0x40a42c('0x1d')](db[_0x40a42c('0x51')]['query'](_0x4d0727(_0x5cfbc4,_0x40a42c('0x5')))[_0x40a42c('0x3')](function(){})[_0x40a42c('0x6')](_0x41d899()));break;case'onlyIfOpen':_0x387301[_0x40a42c('0x1d')](db['sequelize'][_0x40a42c('0x3e')](_0x29adb3(_0x5cfbc4,_0x40a42c('0x5')))[_0x40a42c('0x3')](function(){})[_0x40a42c('0x6')](_0x41d899()));break;default:_0x387301['push'](db['sequelize'][_0x40a42c('0x3e')](_0x35c175(_0x5cfbc4,'CampaignId'))[_0x40a42c('0x3')](function(){})[_0x40a42c('0x6')](_0x41d899()));}}return _0x387301;})[_0x5dc20b('0x38')]();})['then'](function(){const _0x2f794b=_0x1630ed;return db[_0x2f794b('0x5c')]['findAll']({'attributes':['id'],'include':[{'model':db['CmList'],'as':'BlackLists','where':{'id':LISTID}}]})[_0x2f794b('0x3')](function(_0x22939f){const _0x3a517f=_0x2f794b,_0x16cf9e=[];if(_0x22939f)for(let _0x2ad24c=0x0,_0x13572b;_0x2ad24c<_0x22939f[_0x3a517f('0x4d')];_0x2ad24c+=0x1){_0x13572b=_0x22939f[_0x2ad24c][_0x3a517f('0x67')]({'plain':!![]}),_0x16cf9e[_0x3a517f('0x1d')](db[_0x3a517f('0x51')]['query'](_0x3a2dc8(_0x13572b,'CampaignId'))['then'](function(){})[_0x3a517f('0x6')](_0x41d899()));}return _0x16cf9e;})[_0x2f794b('0x38')]();})[_0x1630ed('0x6')](function(_0x921ea6){const _0x1a992e=_0x1630ed;logger[_0x1a992e('0x24')](_0x1a992e('0x64'),_0x1a992e('0x15'),_0x921ea6[_0x1a992e('0xb')]);});}const processPromises=function(_0x11cd53){const _0x2f5771=_0x24d81b;return Promise['all'](promises)['catch'](function(_0x28e915){const _0xd19962=a830_0x2499;logger[_0xd19962('0x24')](_0xd19962('0x53'),JSON['stringify'](_0x28e915));})[_0x2f5771('0x13')](function(){const _0x139c0a=_0x2f5771;socket[_0x139c0a('0x27')]('contact:csv_'+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows}),promises=[],success=0x0,errors=0x0,duplicates=0x0,rows=[];if(_0x11cd53)return _0x11cd53[_0x139c0a('0x4c')]();});},endCsv=function(){const _0x2d04c9=_0x24d81b;return Promise[_0x2d04c9('0x55')]()[_0x2d04c9('0x3')](function(){if(hopperContacts)return checkHopper();})[_0x2d04c9('0x3')](function(){const _0x138184=_0x2d04c9;socket[_0x138184('0x27')](_0x138184('0x50')+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x138184('0x65')](FILEPATH);}catch(_0x51cb05){logger[_0x138184('0x24')]('Unable\x20to\x20delete\x20temp\x20file:',JSON[_0x138184('0x35')](_0x51cb05));}finally{process[_0x138184('0x31')](0x0);}});};process['on'](_0x24d81b('0x21'),function(){logger['info']('CSV\x20import\x20process\x20stopped!'),endCsv();});function main(){const _0x45fba8=_0x24d81b;return Promise[_0x45fba8('0x55')]()[_0x45fba8('0x3')](function(){const _0x30a310=_0x45fba8;if(DUPLICATES)return DUPLICATES=DUPLICATES[_0x30a310('0x57')](','),db[_0x30a310('0x1f')]['findAll']({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});})[_0x45fba8('0x3')](function(_0x314c0e){const _0x1b33c7=_0x45fba8,_0x435e89=fs['createReadStream'](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0x1b33c7('0x16')](_0x435e89,{'header':!![],'skipEmptyLines':!![],'step':function(_0x1b1754,_0x548226){const _0x554177=_0x1b33c7;total+=0x1;const _0x119d20=total;promises[_0x554177('0x1d')](checkRow(_0x1b1754,_0x314c0e,_0x119d20)[_0x554177('0x3')](function(){success+=0x1;})['catch'](function(_0x4b14dd){const _0x52ad58=_0x554177;if(_0x4b14dd[_0x52ad58('0x24')])errors+=0x1,delete _0x4b14dd[_0x52ad58('0x24')];else _0x4b14dd[_0x52ad58('0x36')]&&(duplicates+=0x1,delete _0x4b14dd[_0x52ad58('0x36')]);rows[_0x52ad58('0x1d')](_0x4b14dd);}));if(total%0xc8===0x0)return _0x548226['pause'](),processPromises(_0x548226);},'complete':function(){const _0x240ea0=_0x1b33c7;return processPromises()[_0x240ea0('0x3')](function(){const _0x29cd6a=_0x240ea0;logger[_0x29cd6a('0x43')](_0x29cd6a('0x68')),endCsv();});},'error':function(_0x70a7f3){const _0x3d67bf=_0x1b33c7;logger[_0x3d67bf('0x43')](_0x3d67bf('0x5a'),JSON[_0x3d67bf('0x35')](_0x70a7f3)),endCsv();}});})['catch'](function(_0x129e8e){const _0x5da421=_0x45fba8;logger[_0x5da421('0x24')](_0x5da421('0x3a'),JSON[_0x5da421('0x35')](_0x129e8e));});}main();