Built motion from commit f67b3b02.|2.6.31
[motion2.git] / server / components / import / cm / csv.js
index ca1a3ec..7da6352 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xb3e0=['resolve','unlinkSync','exit','SIGINT','CSV\x20import\x20process\x20stopped!','CmContact','createReadStream','parse','pause','info','CSV\x20parsed\x20correctly!','CSV\x20parse\x20error','Error\x20executing\x20contact\x20csv\x20import:','util','lodash','squel','papaparse','ioredis','../../../mysqldb','../../../config/environment','../../../config/logger','redis','localhost','socket.io-emitter','register','argv','undefined','null','Missing\x20filepath\x20parameter!','Missing\x20binding\x20parameters!','zipObject','split','Missing\x20ListId\x20parameter!','Missing\x20socket_timestamp\x20parameter!','error','contact','index','test','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','errors','map','hasOwnProperty','data','firstName\x20not\x20specified!','phone','phone\x20not\x20specified!','birthDate','YYYY-MM-DD','isValid','birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!','email','email\x20format\x20is\x20not\x20valid!','ListId','CompanyId','length','find','duplicate','Duplicate\x20Contact','create','keys','then','pick','catch','Error\x20while\x20creating\x20contact:\x20','message','stringify','cmContact','checkHopper','inspect','insert','cm_hopper','scheduledAt','ContactId','createdAt','updatedAt','select','field','toString','NOW()','from','cm_contacts','where','deletedAt\x20IS\x20NULL','ListId\x20=\x20?','phone\x20IS\x20NOT\x20NULL','phone\x20NOT\x20IN\x20(?)','\x20=\x20?','into','fromQuery','calleridnum','cm_hopper_final','id\x20IN\x20?','str','VoiceQueue','outbound','dialCheckDuplicateType','CmList','get','always','push','sequelize','VoiceQueueId','onlyIfOpen','query','all','BlackLists','Campaign','findAll','Lists','CampaignId','cmContact,\x20%s,\x20%s','generalCheckHopper','Error\x20processing\x20rows\x20block:','finally','emit','contact:csv_','resume'];(function(_0x3dc68d,_0x1c1951){var _0xdf7f94=function(_0x339428){while(--_0x339428){_0x3dc68d['push'](_0x3dc68d['shift']());}};_0xdf7f94(++_0x1c1951);}(_0xb3e0,0x1e1));var _0x0b3e=function(_0xf3cd1e,_0xd7bb6f){_0xf3cd1e=_0xf3cd1e-0x0;var _0x2958b8=_0xb3e0[_0xf3cd1e];return _0x2958b8;};'use strict';var BPromise=require('bluebird');var util=require(_0x0b3e('0x0'));var _=require(_0x0b3e('0x1'));var fs=require('fs');var squel=require(_0x0b3e('0x2'));var Papa=require(_0x0b3e('0x3'));var Redis=require(_0x0b3e('0x4'));var db=require(_0x0b3e('0x5'))['db'];var config=require(_0x0b3e('0x6'));var logger=require(_0x0b3e('0x7'))('api');config[_0x0b3e('0x8')]=_['defaults'](config[_0x0b3e('0x8')],{'host':_0x0b3e('0x9'),'port':0x18eb});var socket=require(_0x0b3e('0xa'))(new Redis(config['redis']));require('../../../api/cmContact/cmContact.socket')[_0x0b3e('0xb')](socket);try{if(!process[_0x0b3e('0xc')][0x2]||process[_0x0b3e('0xc')][0x2]===_0x0b3e('0xd')||process[_0x0b3e('0xc')][0x2]===_0x0b3e('0xe')){throw new Error(_0x0b3e('0xf'));}var FILEPATH=process['argv'][0x2];if(!process['argv'][0x3]||process['argv'][0x3]==='undefined'||process[_0x0b3e('0xc')][0x3]===_0x0b3e('0xe')||!process[_0x0b3e('0xc')][0x4]||process[_0x0b3e('0xc')][0x4]===_0x0b3e('0xd')||process[_0x0b3e('0xc')][0x4]===_0x0b3e('0xe')){throw new Error(_0x0b3e('0x10'));}var FIELDS=_[_0x0b3e('0x11')](process[_0x0b3e('0xc')][0x3][_0x0b3e('0x12')](','),process[_0x0b3e('0xc')][0x4][_0x0b3e('0x12')](','));if(!process[_0x0b3e('0xc')][0x5]||process[_0x0b3e('0xc')][0x5]==='undefined'||process[_0x0b3e('0xc')][0x5]===_0x0b3e('0xe')){throw new Error(_0x0b3e('0x13'));}var LISTID=process[_0x0b3e('0xc')][0x5];var COMPANYID=process[_0x0b3e('0xc')][0x6]&&process[_0x0b3e('0xc')][0x6]!==_0x0b3e('0xd')&&process['argv'][0x6]!==_0x0b3e('0xe')?process[_0x0b3e('0xc')][0x6]:null;var DUPLICATES=process['argv'][0x7]&&process[_0x0b3e('0xc')][0x7]!=='undefined'&&process['argv'][0x7]!==_0x0b3e('0xe')?process['argv'][0x7]:null;if(!process[_0x0b3e('0xc')][0x8]||process[_0x0b3e('0xc')][0x8]===_0x0b3e('0xd')||process[_0x0b3e('0xc')][0x8]==='null'){throw new Error(_0x0b3e('0x14'));}var SOCKET_TIMESTAMP=process[_0x0b3e('0xc')][0x8];}catch(_0x440594){logger[_0x0b3e('0x15')](_0x440594);endCsv();}var total=0x0;var pTotal=0x0;var success=0x0;var errors=0x0;var duplicates=0x0;var rows=[];var hopperContacts='';var promises=[];var index=0x0;var alreadyInvalid=![];function handleCheckRowError(_0x3793de,_0x4b1df2,_0x443c08,_0x2112f5){var _0x6d552={'message':_0x4b1df2};_0x6d552[_0x3793de]=!![];if(_0x443c08){_0x6d552[_0x0b3e('0x16')]=_0x443c08;}if(_0x2112f5){_0x6d552[_0x0b3e('0x17')]=_0x2112f5;}return _0x6d552;}function isEmail(_0x39911d){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))*$/[_0x0b3e('0x18')](_0x39911d);}function checkRow(_0x28e813,_0x2e8267,_0x24971f){return new BPromise(function(_0x22fd39,_0x2b0979){if(_['isNil'](_0x28e813)){return _0x2b0979(handleCheckRowError(_0x0b3e('0x15'),_0x0b3e('0x19'),null,_0x24971f));}if(_0x28e813[_0x0b3e('0x1a')]&&_0x28e813[_0x0b3e('0x1a')]['length']){var _0xff3f94=_[_0x0b3e('0x1b')](_0x28e813[_0x0b3e('0x1a')],'message')['join'](';');return _0x2b0979(handleCheckRowError(_0x0b3e('0x15'),_0xff3f94,null,_0x24971f));}var _0x3e1eb1={};for(var _0x5f451c in FIELDS){if(FIELDS[_0x0b3e('0x1c')](_0x5f451c)&&FIELDS[_0x5f451c]){_0x3e1eb1[_0x5f451c]=_0x28e813[_0x0b3e('0x1d')][0x0][FIELDS[_0x5f451c]]||_0x28e813['data'][0x0]['\ufeff'+FIELDS[_0x5f451c]];}}if(!_0x3e1eb1['firstName']){return _0x2b0979(handleCheckRowError(_0x0b3e('0x15'),_0x0b3e('0x1e'),null,_0x24971f));}if(!_0x3e1eb1[_0x0b3e('0x1f')]){return _0x2b0979(handleCheckRowError(_0x0b3e('0x15'),_0x0b3e('0x20'),null,_0x24971f));}if(_0x3e1eb1[_0x0b3e('0x21')]){var _0x129136=moment(_0x3e1eb1[_0x0b3e('0x21')],_0x0b3e('0x22'));if(!_0x129136[_0x0b3e('0x23')]()){return _0x2b0979(handleCheckRowError(_0x0b3e('0x15'),_0x0b3e('0x24'),null,_0x24971f));}}if(_0x3e1eb1[_0x0b3e('0x25')]){if(!isEmail(_0x3e1eb1[_0x0b3e('0x25')])){return _0x2b0979(handleCheckRowError('error',_0x0b3e('0x26'),null,_0x24971f));}}_0x3e1eb1[_0x0b3e('0x27')]=LISTID;_0x3e1eb1[_0x0b3e('0x28')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES[_0x0b3e('0x29')]&&_0x2e8267){var _0x2c7285={};for(var _0x10cd6d=0x0,_0x3a1658=DUPLICATES[_0x0b3e('0x29')];_0x10cd6d<_0x3a1658;_0x10cd6d+=0x1){_0x2c7285[DUPLICATES[_0x10cd6d]]=_0x3e1eb1[DUPLICATES[_0x10cd6d]];}var _0xe17af5=_[_0x0b3e('0x2a')](_0x2e8267,_0x2c7285);if(_0xe17af5){return _0x2b0979(handleCheckRowError(_0x0b3e('0x2b'),_0x0b3e('0x2c'),_0xe17af5,_0x24971f));}}return db['CmContact'][_0x0b3e('0x2d')](_0x3e1eb1,{'raw':!![],'hooks':![],'fields':_[_0x0b3e('0x2e')](_0x3e1eb1)})[_0x0b3e('0x2f')](function(_0x41b80d){if(DUPLICATES&&DUPLICATES[_0x0b3e('0x29')]&&_0x2e8267){_0x2e8267['push'](_[_0x0b3e('0x30')](_0x3e1eb1,DUPLICATES));}hopperContacts+=(hopperContacts?',':'')+_0x41b80d['id'];return _0x22fd39();})[_0x0b3e('0x31')](function(_0x5e70c8){return _0x2b0979(handleCheckRowError(_0x0b3e('0x15'),_0x0b3e('0x32')+(_0x5e70c8[_0x0b3e('0x33')]||JSON[_0x0b3e('0x34')](_0x5e70c8)),null,_0x24971f));});});}function checkHopper(){function _0x27af03(){return function(_0x28b52a){logger[_0x0b3e('0x15')](_0x0b3e('0x35'),_0x0b3e('0x36'),util[_0x0b3e('0x37')](_0x28b52a,{'showHidden':![],'depth':null}));};}var _0x9b6147=function(_0x11bd58,_0x25c024){var _0x2e0b75=squel[_0x0b3e('0x38')]()['into'](_0x0b3e('0x39'))['fromQuery']([_0x0b3e('0x1f'),_0x0b3e('0x3a'),_0x0b3e('0x3b'),'ListId',_0x25c024,_0x0b3e('0x3c'),_0x0b3e('0x3d')],squel[_0x0b3e('0x3e')]()[_0x0b3e('0x3f')](_0x0b3e('0x1f'),_0x0b3e('0x1f'))['field']('NOW()','scheduledAt')[_0x0b3e('0x3f')]('id','ContactId')[_0x0b3e('0x3f')](LISTID[_0x0b3e('0x40')](),_0x0b3e('0x27'))[_0x0b3e('0x3f')](_0x11bd58['id']['toString'](),_0x25c024)[_0x0b3e('0x3f')]('NOW()','createdAt')[_0x0b3e('0x3f')](_0x0b3e('0x41'),_0x0b3e('0x3d'))[_0x0b3e('0x42')](_0x0b3e('0x43'))[_0x0b3e('0x44')](_0x0b3e('0x45'))['where'](_0x0b3e('0x46'),LISTID['toString']())['where'](_0x0b3e('0x47'))[_0x0b3e('0x44')](_0x0b3e('0x48'),squel['select']()['field']('phone')[_0x0b3e('0x42')](_0x0b3e('0x39'))[_0x0b3e('0x44')](_0x25c024+_0x0b3e('0x49'),_0x11bd58['id']['toString']())))['toString']();return _0x2e0b75;};var _0x1df377=function(_0x157c04,_0x30528b){var _0xfcda57=squel[_0x0b3e('0x38')]()[_0x0b3e('0x4a')](_0x0b3e('0x39'))[_0x0b3e('0x4b')]([_0x0b3e('0x1f'),_0x0b3e('0x3a'),'ContactId',_0x0b3e('0x27'),_0x30528b,_0x0b3e('0x3c'),_0x0b3e('0x3d')],squel[_0x0b3e('0x3e')]()[_0x0b3e('0x3f')](_0x0b3e('0x1f'),_0x0b3e('0x1f'))['field'](_0x0b3e('0x41'),'scheduledAt')[_0x0b3e('0x3f')]('id','ContactId')['field'](LISTID[_0x0b3e('0x40')](),_0x0b3e('0x27'))[_0x0b3e('0x3f')](_0x157c04['id'][_0x0b3e('0x40')](),_0x30528b)['field'](_0x0b3e('0x41'),_0x0b3e('0x3c'))[_0x0b3e('0x3f')](_0x0b3e('0x41'),_0x0b3e('0x3d'))[_0x0b3e('0x42')](_0x0b3e('0x43'))['where'](_0x0b3e('0x45'))['where'](_0x0b3e('0x46'),LISTID[_0x0b3e('0x40')]())['where']('id\x20IN\x20?',squel['str'](hopperContacts))[_0x0b3e('0x44')](_0x0b3e('0x47'))[_0x0b3e('0x44')](_0x0b3e('0x48'),squel[_0x0b3e('0x3e')]()['field'](_0x0b3e('0x4c'))['from'](_0x0b3e('0x4d'))[_0x0b3e('0x44')](_0x30528b+'\x20=\x20?',_0x157c04['id'][_0x0b3e('0x40')]()))[_0x0b3e('0x44')](_0x0b3e('0x48'),squel[_0x0b3e('0x3e')]()[_0x0b3e('0x3f')]('phone')['from'](_0x0b3e('0x39'))[_0x0b3e('0x44')](_0x30528b+_0x0b3e('0x49'),_0x157c04['id'][_0x0b3e('0x40')]())))[_0x0b3e('0x40')]();return _0xfcda57;};function _0xc67b89(_0x5a0430,_0x434d73){var _0x416ed4=squel['insert']()['into'](_0x0b3e('0x39'))[_0x0b3e('0x4b')]([_0x0b3e('0x1f'),_0x0b3e('0x3a'),_0x0b3e('0x3b'),_0x0b3e('0x27'),_0x434d73,_0x0b3e('0x3c'),_0x0b3e('0x3d')],squel[_0x0b3e('0x3e')]()[_0x0b3e('0x3f')]('phone',_0x0b3e('0x1f'))[_0x0b3e('0x3f')](_0x0b3e('0x41'),_0x0b3e('0x3a'))['field']('id','ContactId')['field'](LISTID[_0x0b3e('0x40')](),_0x0b3e('0x27'))[_0x0b3e('0x3f')](_0x5a0430['id'][_0x0b3e('0x40')](),_0x434d73)[_0x0b3e('0x3f')](_0x0b3e('0x41'),_0x0b3e('0x3c'))[_0x0b3e('0x3f')]('NOW()',_0x0b3e('0x3d'))['from'](_0x0b3e('0x43'))[_0x0b3e('0x44')](_0x0b3e('0x45'))[_0x0b3e('0x44')](_0x0b3e('0x46'),LISTID[_0x0b3e('0x40')]())['where'](_0x0b3e('0x4e'),squel[_0x0b3e('0x4f')](hopperContacts))[_0x0b3e('0x44')](_0x0b3e('0x47')))[_0x0b3e('0x40')]();return _0x416ed4;}function _0x585d9d(_0x43387a,_0x2f8932){var _0x4e8688=squel[_0x0b3e('0x38')]()['into']('cm_hopper_black')[_0x0b3e('0x4b')]([_0x0b3e('0x1f'),_0x0b3e('0x3b'),_0x0b3e('0x27'),_0x2f8932,_0x0b3e('0x3c'),_0x0b3e('0x3d')],squel[_0x0b3e('0x3e')]()[_0x0b3e('0x3f')](_0x0b3e('0x1f'),_0x0b3e('0x1f'))['field']('id',_0x0b3e('0x3b'))[_0x0b3e('0x3f')](LISTID[_0x0b3e('0x40')](),_0x0b3e('0x27'))[_0x0b3e('0x3f')](_0x43387a['id']['toString'](),_0x2f8932)['field'](_0x0b3e('0x41'),_0x0b3e('0x3c'))[_0x0b3e('0x3f')](_0x0b3e('0x41'),'updatedAt')[_0x0b3e('0x42')](_0x0b3e('0x43'))[_0x0b3e('0x44')](_0x0b3e('0x45'))[_0x0b3e('0x44')](_0x0b3e('0x46'),LISTID[_0x0b3e('0x40')]())[_0x0b3e('0x44')](_0x0b3e('0x4e'),squel[_0x0b3e('0x4f')](hopperContacts))[_0x0b3e('0x44')](_0x0b3e('0x47')))[_0x0b3e('0x40')]();return _0x4e8688;}return db[_0x0b3e('0x50')]['findAll']({'where':{'type':_0x0b3e('0x51')},'attributes':['id',_0x0b3e('0x52')],'include':[{'model':db[_0x0b3e('0x53')],'as':'Lists','where':{'id':LISTID}}]})[_0x0b3e('0x2f')](function(_0x311866){var _0x586acc=[];if(_0x311866){var _0x9a1cb7;for(var _0xcca804=0x0,_0x1faacf;_0xcca804<_0x311866['length'];_0xcca804+=0x1){_0x1faacf=_0x311866[_0xcca804][_0x0b3e('0x54')]({'plain':!![]});switch(_0x1faacf[_0x0b3e('0x52')]){case _0x0b3e('0x55'):_0x586acc[_0x0b3e('0x56')](db[_0x0b3e('0x57')]['query'](_0x1df377(_0x1faacf,_0x0b3e('0x58')))['then'](function(){})[_0x0b3e('0x31')](_0x27af03()));break;case _0x0b3e('0x59'):_0x586acc['push'](db[_0x0b3e('0x57')][_0x0b3e('0x5a')](_0x9b6147(_0x1faacf,'VoiceQueueId'))[_0x0b3e('0x2f')](function(){})['catch'](_0x27af03()));break;default:_0x586acc[_0x0b3e('0x56')](db['sequelize']['query'](_0xc67b89(_0x1faacf,'VoiceQueueId'))[_0x0b3e('0x2f')](function(){})[_0x0b3e('0x31')](_0x27af03()));}}}return _0x586acc;})[_0x0b3e('0x5b')]()[_0x0b3e('0x2f')](function(){return db['VoiceQueue']['findAll']({'where':{'type':'outbound'},'attributes':['id'],'include':[{'model':db['CmList'],'as':_0x0b3e('0x5c'),'where':{'id':LISTID}}]})[_0x0b3e('0x2f')](function(_0x538f2a){var _0x52d7fd=[];if(_0x538f2a){var _0x1cace8;for(var _0x5d18e4=0x0,_0x3c8592;_0x5d18e4<_0x538f2a[_0x0b3e('0x29')];_0x5d18e4+=0x1){_0x3c8592=_0x538f2a[_0x5d18e4][_0x0b3e('0x54')]({'plain':!![]});_0x52d7fd[_0x0b3e('0x56')](db[_0x0b3e('0x57')][_0x0b3e('0x5a')](_0x585d9d(_0x3c8592,_0x0b3e('0x58')))['then'](function(){})[_0x0b3e('0x31')](_0x27af03()));}}return _0x52d7fd;})['all']();})[_0x0b3e('0x2f')](function(){return db[_0x0b3e('0x5d')][_0x0b3e('0x5e')]({'attributes':['id',_0x0b3e('0x52')],'include':[{'model':db[_0x0b3e('0x53')],'as':_0x0b3e('0x5f'),'where':{'id':LISTID}}]})['then'](function(_0x1192f1){var _0x251c18=[];if(_0x1192f1){for(var _0x4a91cd=0x0,_0x4bf6d1;_0x4a91cd<_0x1192f1[_0x0b3e('0x29')];_0x4a91cd+=0x1){_0x4bf6d1=_0x1192f1[_0x4a91cd]['get']({'plain':!![]});switch(_0x4bf6d1[_0x0b3e('0x52')]){case'always':_0x251c18['push'](db[_0x0b3e('0x57')][_0x0b3e('0x5a')](_0x1df377(_0x4bf6d1,'CampaignId'))[_0x0b3e('0x2f')](function(){})[_0x0b3e('0x31')](_0x27af03()));break;case'onlyIfOpen':_0x251c18[_0x0b3e('0x56')](db[_0x0b3e('0x57')][_0x0b3e('0x5a')](_0x9b6147(_0x4bf6d1,_0x0b3e('0x60')))[_0x0b3e('0x2f')](function(){})[_0x0b3e('0x31')](_0x27af03()));break;default:_0x251c18[_0x0b3e('0x56')](db[_0x0b3e('0x57')]['query'](_0xc67b89(_0x4bf6d1,_0x0b3e('0x60')))[_0x0b3e('0x2f')](function(){})[_0x0b3e('0x31')](_0x27af03()));}}}return _0x251c18;})['all']();})[_0x0b3e('0x2f')](function(){return db[_0x0b3e('0x5d')][_0x0b3e('0x5e')]({'attributes':['id'],'include':[{'model':db['CmList'],'as':'BlackLists','where':{'id':LISTID}}]})[_0x0b3e('0x2f')](function(_0x228136){var _0x3f53d9=[];if(_0x228136){for(var _0x359e18=0x0,_0xd64554;_0x359e18<_0x228136[_0x0b3e('0x29')];_0x359e18+=0x1){_0xd64554=_0x228136[_0x359e18][_0x0b3e('0x54')]({'plain':!![]});_0x3f53d9['push'](db[_0x0b3e('0x57')][_0x0b3e('0x5a')](_0x585d9d(_0xd64554,_0x0b3e('0x60')))[_0x0b3e('0x2f')](function(){})[_0x0b3e('0x31')](_0x27af03()));}}return _0x3f53d9;})['all']();})[_0x0b3e('0x31')](function(_0x80e535){logger[_0x0b3e('0x15')](_0x0b3e('0x61'),_0x0b3e('0x62'),_0x80e535['message']);});}var processPromises=function(_0x2f8bc4){return BPromise[_0x0b3e('0x5b')](promises)[_0x0b3e('0x2f')](function(_0x4ca948){})[_0x0b3e('0x31')](function(_0x3e09a7){logger[_0x0b3e('0x15')](_0x0b3e('0x63'),JSON['stringify'](_0x3e09a7));})[_0x0b3e('0x64')](function(){socket[_0x0b3e('0x65')](_0x0b3e('0x66')+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});promises=[];success=0x0;errors=0x0;duplicates=0x0;rows=[];if(_0x2f8bc4){return _0x2f8bc4[_0x0b3e('0x67')]();}});};var endCsv=function(){return BPromise[_0x0b3e('0x68')]()['then'](function(){if(hopperContacts){return checkHopper();}})['then'](function(){socket[_0x0b3e('0x65')]('contact:csv_'+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x0b3e('0x69')](FILEPATH);}catch(_0xd4efa6){logger['error']('Unable\x20to\x20delete\x20temp\x20file:',JSON[_0x0b3e('0x34')](_0xd4efa6));}finally{process[_0x0b3e('0x6a')](0x0);}});};process['on'](_0x0b3e('0x6b'),function(){logger['info'](_0x0b3e('0x6c'));endCsv();});function main(){return BPromise[_0x0b3e('0x68')]()['then'](function(){if(DUPLICATES){DUPLICATES=DUPLICATES['split'](',');return db[_0x0b3e('0x6d')]['findAll']({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});}})[_0x0b3e('0x2f')](function(_0x3086b6){var _0x323e8b=fs[_0x0b3e('0x6e')](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa[_0x0b3e('0x6f')](_0x323e8b,{'header':!![],'skipEmptyLines':!![],'step':function(_0x3e74a3,_0x27d1e6){total+=0x1;var _0x217b0a=total;promises[_0x0b3e('0x56')](checkRow(_0x3e74a3,_0x3086b6,_0x217b0a)[_0x0b3e('0x2f')](function(){success+=0x1;})[_0x0b3e('0x31')](function(_0x5b3a37){if(_0x5b3a37[_0x0b3e('0x15')]){errors+=0x1;delete _0x5b3a37[_0x0b3e('0x15')];}else if(_0x5b3a37[_0x0b3e('0x2b')]){duplicates+=0x1;delete _0x5b3a37['duplicate'];}rows[_0x0b3e('0x56')](_0x5b3a37);}));if(total%0xc8===0x0){_0x27d1e6[_0x0b3e('0x70')]();return processPromises(_0x27d1e6);}},'complete':function(){return processPromises()[_0x0b3e('0x2f')](function(){logger[_0x0b3e('0x71')](_0x0b3e('0x72'));endCsv();});},'error':function(_0x3f8d1b,_0x48aa5e){logger[_0x0b3e('0x71')](_0x0b3e('0x73'),JSON[_0x0b3e('0x34')](_0x3f8d1b));endCsv();}});})[_0x0b3e('0x31')](function(_0x447d9c){logger[_0x0b3e('0x15')](_0x0b3e('0x74'),JSON['stringify'](_0x447d9c));});}main();
\ No newline at end of file
+var _0xe428=['info','CSV\x20import\x20process\x20stopped!','resolve','split','CmContact','createReadStream','CSV\x20parse\x20error','Error\x20executing\x20contact\x20csv\x20import:','bluebird','util','lodash','squel','papaparse','../../../mysqldb','../../../config/logger','api','redis','localhost','socket.io-emitter','../../../api/cmContact/cmContact.socket','argv','undefined','null','Missing\x20binding\x20parameters!','Missing\x20ListId\x20parameter!','index','test','isNil','error','The\x20row\x20is\x20empty\x20or\x20the\x20number\x20of\x20parameters\x20does\x20not\x20match\x20the\x20columns!','errors','length','map','message','join','hasOwnProperty','data','firstName','phone\x20not\x20specified!','birthDate','isValid','birthDate\x20format\x20is\x20invalid,\x20YYYY-MM-DD\x20format\x20is\x20supported!','email','email\x20format\x20is\x20not\x20valid!','CompanyId','find','duplicate','catch','Error\x20while\x20creating\x20contact:\x20','stringify','cmContact','inspect','insert','cm_hopper','fromQuery','phone','scheduledAt','ContactId','ListId','createdAt','updatedAt','select','field','NOW()','toString','from','cm_contacts','deletedAt\x20IS\x20NULL','where','phone\x20IS\x20NOT\x20NULL','\x20=\x20?','ListId\x20=\x20?','id\x20IN\x20?','str','phone\x20NOT\x20IN\x20(?)','calleridnum','cm_hopper_final','into','findAll','outbound','dialCheckDuplicateType','CmList','then','get','always','push','sequelize','VoiceQueueId','query','all','VoiceQueue','BlackLists','Campaign','Lists','onlyIfOpen','cmContact,\x20%s,\x20%s','generalCheckHopper','Error\x20processing\x20rows\x20block:','finally','emit','resume','contact:csv_','unlinkSync','Unable\x20to\x20delete\x20temp\x20file:','exit','SIGINT'];(function(_0x2f574a,_0x5d01c6){var _0x46a47f=function(_0x511baf){while(--_0x511baf){_0x2f574a['push'](_0x2f574a['shift']());}};_0x46a47f(++_0x5d01c6);}(_0xe428,0xdc));var _0x8e42=function(_0x4b30f9,_0x439966){_0x4b30f9=_0x4b30f9-0x0;var _0xc20e9c=_0xe428[_0x4b30f9];return _0xc20e9c;};'use strict';var BPromise=require(_0x8e42('0x0'));var util=require(_0x8e42('0x1'));var _=require(_0x8e42('0x2'));var fs=require('fs');var squel=require(_0x8e42('0x3'));var Papa=require(_0x8e42('0x4'));var Redis=require('ioredis');var db=require(_0x8e42('0x5'))['db'];var config=require('../../../config/environment');var logger=require(_0x8e42('0x6'))(_0x8e42('0x7'));config[_0x8e42('0x8')]=_['defaults'](config[_0x8e42('0x8')],{'host':_0x8e42('0x9'),'port':0x18eb});var socket=require(_0x8e42('0xa'))(new Redis(config[_0x8e42('0x8')]));require(_0x8e42('0xb'))['register'](socket);try{if(!process['argv'][0x2]||process[_0x8e42('0xc')][0x2]===_0x8e42('0xd')||process[_0x8e42('0xc')][0x2]==='null'){throw new Error('Missing\x20filepath\x20parameter!');}var FILEPATH=process['argv'][0x2];if(!process[_0x8e42('0xc')][0x3]||process[_0x8e42('0xc')][0x3]==='undefined'||process[_0x8e42('0xc')][0x3]===_0x8e42('0xe')||!process[_0x8e42('0xc')][0x4]||process[_0x8e42('0xc')][0x4]===_0x8e42('0xd')||process[_0x8e42('0xc')][0x4]===_0x8e42('0xe')){throw new Error(_0x8e42('0xf'));}var FIELDS=_['zipObject'](process[_0x8e42('0xc')][0x3]['split'](','),process[_0x8e42('0xc')][0x4]['split'](','));if(!process[_0x8e42('0xc')][0x5]||process[_0x8e42('0xc')][0x5]==='undefined'||process[_0x8e42('0xc')][0x5]===_0x8e42('0xe')){throw new Error(_0x8e42('0x10'));}var LISTID=process[_0x8e42('0xc')][0x5];var COMPANYID=process[_0x8e42('0xc')][0x6]&&process[_0x8e42('0xc')][0x6]!==_0x8e42('0xd')&&process[_0x8e42('0xc')][0x6]!==_0x8e42('0xe')?process[_0x8e42('0xc')][0x6]:null;var DUPLICATES=process['argv'][0x7]&&process[_0x8e42('0xc')][0x7]!=='undefined'&&process['argv'][0x7]!==_0x8e42('0xe')?process[_0x8e42('0xc')][0x7]:null;if(!process[_0x8e42('0xc')][0x8]||process[_0x8e42('0xc')][0x8]==='undefined'||process[_0x8e42('0xc')][0x8]===_0x8e42('0xe')){throw new Error('Missing\x20socket_timestamp\x20parameter!');}var SOCKET_TIMESTAMP=process[_0x8e42('0xc')][0x8];}catch(_0x589461){logger['error'](_0x589461);endCsv();}var total=0x0;var pTotal=0x0;var success=0x0;var errors=0x0;var duplicates=0x0;var rows=[];var hopperContacts='';var promises=[];var index=0x0;var alreadyInvalid=![];function handleCheckRowError(_0x5a1ccf,_0x2e2e1d,_0x18f655,_0x751c12){var _0x46e465={'message':_0x2e2e1d};_0x46e465[_0x5a1ccf]=!![];if(_0x18f655){_0x46e465['contact']=_0x18f655;}if(_0x751c12){_0x46e465[_0x8e42('0x11')]=_0x751c12;}return _0x46e465;}function isEmail(_0x36b426){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))*$/[_0x8e42('0x12')](_0x36b426);}function checkRow(_0x190022,_0xe97de9,_0x34ce62){return new BPromise(function(_0x2b0308,_0x2a72f4){if(_[_0x8e42('0x13')](_0x190022)){return _0x2a72f4(handleCheckRowError(_0x8e42('0x14'),_0x8e42('0x15'),null,_0x34ce62));}if(_0x190022['errors']&&_0x190022[_0x8e42('0x16')][_0x8e42('0x17')]){var _0x3eb286=_[_0x8e42('0x18')](_0x190022[_0x8e42('0x16')],_0x8e42('0x19'))[_0x8e42('0x1a')](';');return _0x2a72f4(handleCheckRowError(_0x8e42('0x14'),_0x3eb286,null,_0x34ce62));}var _0x30713d={};for(var _0x28adc5 in FIELDS){if(FIELDS[_0x8e42('0x1b')](_0x28adc5)&&FIELDS[_0x28adc5]){_0x30713d[_0x28adc5]=_0x190022[_0x8e42('0x1c')][0x0][FIELDS[_0x28adc5]]||_0x190022[_0x8e42('0x1c')][0x0]['\ufeff'+FIELDS[_0x28adc5]];}}if(!_0x30713d[_0x8e42('0x1d')]){return _0x2a72f4(handleCheckRowError(_0x8e42('0x14'),'firstName\x20not\x20specified!',null,_0x34ce62));}if(!_0x30713d['phone']){return _0x2a72f4(handleCheckRowError(_0x8e42('0x14'),_0x8e42('0x1e'),null,_0x34ce62));}if(_0x30713d[_0x8e42('0x1f')]){var _0x3718b7=moment(_0x30713d['birthDate'],'YYYY-MM-DD');if(!_0x3718b7[_0x8e42('0x20')]()){return _0x2a72f4(handleCheckRowError(_0x8e42('0x14'),_0x8e42('0x21'),null,_0x34ce62));}}if(_0x30713d[_0x8e42('0x22')]){if(!isEmail(_0x30713d[_0x8e42('0x22')])){return _0x2a72f4(handleCheckRowError(_0x8e42('0x14'),_0x8e42('0x23'),null,_0x34ce62));}}_0x30713d['ListId']=LISTID;_0x30713d[_0x8e42('0x24')]=COMPANYID||undefined;if(DUPLICATES&&DUPLICATES['length']&&_0xe97de9){var _0x118b07={};for(var _0x2d7d09=0x0,_0x3c0de2=DUPLICATES[_0x8e42('0x17')];_0x2d7d09<_0x3c0de2;_0x2d7d09+=0x1){_0x118b07[DUPLICATES[_0x2d7d09]]=_0x30713d[DUPLICATES[_0x2d7d09]];}var _0x2afe42=_[_0x8e42('0x25')](_0xe97de9,_0x118b07);if(_0x2afe42){return _0x2a72f4(handleCheckRowError(_0x8e42('0x26'),'Duplicate\x20Contact',_0x2afe42,_0x34ce62));}}return db['CmContact']['create'](_0x30713d,{'raw':!![],'hooks':![],'fields':_['keys'](_0x30713d)})['then'](function(_0x420f39){if(DUPLICATES&&DUPLICATES[_0x8e42('0x17')]&&_0xe97de9){_0xe97de9['push'](_['pick'](_0x30713d,DUPLICATES));}hopperContacts+=(hopperContacts?',':'')+_0x420f39['id'];return _0x2b0308();})[_0x8e42('0x27')](function(_0x5eaeab){return _0x2a72f4(handleCheckRowError('error',_0x8e42('0x28')+(_0x5eaeab[_0x8e42('0x19')]||JSON[_0x8e42('0x29')](_0x5eaeab)),null,_0x34ce62));});});}function checkHopper(){function _0x3aa282(){return function(_0x21628b){logger[_0x8e42('0x14')](_0x8e42('0x2a'),'checkHopper',util[_0x8e42('0x2b')](_0x21628b,{'showHidden':![],'depth':null}));};}var _0x5cc446=function(_0x352a75,_0x29fbd8){var _0x516605=squel[_0x8e42('0x2c')]()['into'](_0x8e42('0x2d'))[_0x8e42('0x2e')]([_0x8e42('0x2f'),_0x8e42('0x30'),_0x8e42('0x31'),_0x8e42('0x32'),_0x29fbd8,_0x8e42('0x33'),_0x8e42('0x34')],squel[_0x8e42('0x35')]()[_0x8e42('0x36')](_0x8e42('0x2f'),'phone')['field'](_0x8e42('0x37'),_0x8e42('0x30'))[_0x8e42('0x36')]('id',_0x8e42('0x31'))['field'](LISTID[_0x8e42('0x38')](),_0x8e42('0x32'))[_0x8e42('0x36')](_0x352a75['id'][_0x8e42('0x38')](),_0x29fbd8)['field'](_0x8e42('0x37'),_0x8e42('0x33'))['field']('NOW()',_0x8e42('0x34'))[_0x8e42('0x39')](_0x8e42('0x3a'))['where'](_0x8e42('0x3b'))[_0x8e42('0x3c')]('ListId\x20=\x20?',LISTID[_0x8e42('0x38')]())[_0x8e42('0x3c')](_0x8e42('0x3d'))[_0x8e42('0x3c')]('phone\x20NOT\x20IN\x20(?)',squel[_0x8e42('0x35')]()[_0x8e42('0x36')](_0x8e42('0x2f'))[_0x8e42('0x39')](_0x8e42('0x2d'))[_0x8e42('0x3c')](_0x29fbd8+_0x8e42('0x3e'),_0x352a75['id'][_0x8e42('0x38')]())))[_0x8e42('0x38')]();return _0x516605;};var _0x443047=function(_0x144fc9,_0x19d5fb){var _0xda7a51=squel[_0x8e42('0x2c')]()['into'](_0x8e42('0x2d'))['fromQuery']([_0x8e42('0x2f'),_0x8e42('0x30'),_0x8e42('0x31'),_0x8e42('0x32'),_0x19d5fb,'createdAt',_0x8e42('0x34')],squel['select']()[_0x8e42('0x36')](_0x8e42('0x2f'),'phone')[_0x8e42('0x36')]('NOW()',_0x8e42('0x30'))['field']('id',_0x8e42('0x31'))[_0x8e42('0x36')](LISTID[_0x8e42('0x38')](),_0x8e42('0x32'))[_0x8e42('0x36')](_0x144fc9['id'][_0x8e42('0x38')](),_0x19d5fb)[_0x8e42('0x36')]('NOW()',_0x8e42('0x33'))[_0x8e42('0x36')](_0x8e42('0x37'),_0x8e42('0x34'))['from'](_0x8e42('0x3a'))['where'](_0x8e42('0x3b'))[_0x8e42('0x3c')](_0x8e42('0x3f'),LISTID[_0x8e42('0x38')]())['where'](_0x8e42('0x40'),squel[_0x8e42('0x41')](hopperContacts))[_0x8e42('0x3c')](_0x8e42('0x3d'))['where'](_0x8e42('0x42'),squel[_0x8e42('0x35')]()[_0x8e42('0x36')](_0x8e42('0x43'))[_0x8e42('0x39')](_0x8e42('0x44'))['where'](_0x19d5fb+_0x8e42('0x3e'),_0x144fc9['id'][_0x8e42('0x38')]()))[_0x8e42('0x3c')]('phone\x20NOT\x20IN\x20(?)',squel[_0x8e42('0x35')]()[_0x8e42('0x36')](_0x8e42('0x2f'))[_0x8e42('0x39')](_0x8e42('0x2d'))[_0x8e42('0x3c')](_0x19d5fb+_0x8e42('0x3e'),_0x144fc9['id'][_0x8e42('0x38')]())))[_0x8e42('0x38')]();return _0xda7a51;};function _0x2ca6bc(_0x40bbf2,_0xd4628b){var _0x59cd33=squel['insert']()[_0x8e42('0x45')](_0x8e42('0x2d'))[_0x8e42('0x2e')]([_0x8e42('0x2f'),'scheduledAt',_0x8e42('0x31'),_0x8e42('0x32'),_0xd4628b,_0x8e42('0x33'),_0x8e42('0x34')],squel[_0x8e42('0x35')]()['field'](_0x8e42('0x2f'),_0x8e42('0x2f'))[_0x8e42('0x36')]('NOW()','scheduledAt')['field']('id',_0x8e42('0x31'))[_0x8e42('0x36')](LISTID[_0x8e42('0x38')](),_0x8e42('0x32'))[_0x8e42('0x36')](_0x40bbf2['id']['toString'](),_0xd4628b)['field']('NOW()',_0x8e42('0x33'))[_0x8e42('0x36')](_0x8e42('0x37'),'updatedAt')[_0x8e42('0x39')](_0x8e42('0x3a'))[_0x8e42('0x3c')]('deletedAt\x20IS\x20NULL')[_0x8e42('0x3c')](_0x8e42('0x3f'),LISTID['toString']())[_0x8e42('0x3c')](_0x8e42('0x40'),squel[_0x8e42('0x41')](hopperContacts))[_0x8e42('0x3c')](_0x8e42('0x3d')))[_0x8e42('0x38')]();return _0x59cd33;}function _0x492e9b(_0x546ce0,_0x4b5a6a){var _0x2fe2a1=squel[_0x8e42('0x2c')]()['into']('cm_hopper_black')['fromQuery']([_0x8e42('0x2f'),_0x8e42('0x31'),'ListId',_0x4b5a6a,_0x8e42('0x33'),_0x8e42('0x34')],squel[_0x8e42('0x35')]()[_0x8e42('0x36')]('phone','phone')[_0x8e42('0x36')]('id','ContactId')[_0x8e42('0x36')](LISTID[_0x8e42('0x38')](),_0x8e42('0x32'))[_0x8e42('0x36')](_0x546ce0['id']['toString'](),_0x4b5a6a)[_0x8e42('0x36')](_0x8e42('0x37'),'createdAt')[_0x8e42('0x36')]('NOW()',_0x8e42('0x34'))[_0x8e42('0x39')](_0x8e42('0x3a'))[_0x8e42('0x3c')]('deletedAt\x20IS\x20NULL')[_0x8e42('0x3c')](_0x8e42('0x3f'),LISTID[_0x8e42('0x38')]())['where']('id\x20IN\x20?',squel['str'](hopperContacts))['where'](_0x8e42('0x3d')))[_0x8e42('0x38')]();return _0x2fe2a1;}return db['VoiceQueue'][_0x8e42('0x46')]({'where':{'type':_0x8e42('0x47')},'attributes':['id',_0x8e42('0x48')],'include':[{'model':db[_0x8e42('0x49')],'as':'Lists','where':{'id':LISTID}}]})[_0x8e42('0x4a')](function(_0x4782b0){var _0xa20b63=[];if(_0x4782b0){var _0x89d809;for(var _0x426392=0x0,_0x1e50e3;_0x426392<_0x4782b0[_0x8e42('0x17')];_0x426392+=0x1){_0x1e50e3=_0x4782b0[_0x426392][_0x8e42('0x4b')]({'plain':!![]});switch(_0x1e50e3['dialCheckDuplicateType']){case _0x8e42('0x4c'):_0xa20b63[_0x8e42('0x4d')](db[_0x8e42('0x4e')]['query'](_0x443047(_0x1e50e3,_0x8e42('0x4f')))[_0x8e42('0x4a')](function(){})[_0x8e42('0x27')](_0x3aa282()));break;case'onlyIfOpen':_0xa20b63[_0x8e42('0x4d')](db[_0x8e42('0x4e')][_0x8e42('0x50')](_0x5cc446(_0x1e50e3,'VoiceQueueId'))[_0x8e42('0x4a')](function(){})[_0x8e42('0x27')](_0x3aa282()));break;default:_0xa20b63[_0x8e42('0x4d')](db[_0x8e42('0x4e')][_0x8e42('0x50')](_0x2ca6bc(_0x1e50e3,'VoiceQueueId'))[_0x8e42('0x4a')](function(){})[_0x8e42('0x27')](_0x3aa282()));}}}return _0xa20b63;})[_0x8e42('0x51')]()[_0x8e42('0x4a')](function(){return db[_0x8e42('0x52')][_0x8e42('0x46')]({'where':{'type':_0x8e42('0x47')},'attributes':['id'],'include':[{'model':db[_0x8e42('0x49')],'as':_0x8e42('0x53'),'where':{'id':LISTID}}]})[_0x8e42('0x4a')](function(_0x213ef6){var _0x539847=[];if(_0x213ef6){var _0xac55ac;for(var _0x5351a0=0x0,_0x13bdfe;_0x5351a0<_0x213ef6[_0x8e42('0x17')];_0x5351a0+=0x1){_0x13bdfe=_0x213ef6[_0x5351a0][_0x8e42('0x4b')]({'plain':!![]});_0x539847[_0x8e42('0x4d')](db[_0x8e42('0x4e')]['query'](_0x492e9b(_0x13bdfe,_0x8e42('0x4f')))[_0x8e42('0x4a')](function(){})[_0x8e42('0x27')](_0x3aa282()));}}return _0x539847;})['all']();})[_0x8e42('0x4a')](function(){return db[_0x8e42('0x54')][_0x8e42('0x46')]({'attributes':['id','dialCheckDuplicateType'],'include':[{'model':db['CmList'],'as':_0x8e42('0x55'),'where':{'id':LISTID}}]})[_0x8e42('0x4a')](function(_0x58d568){var _0x20935f=[];if(_0x58d568){for(var _0x2310b2=0x0,_0x41c854;_0x2310b2<_0x58d568['length'];_0x2310b2+=0x1){_0x41c854=_0x58d568[_0x2310b2][_0x8e42('0x4b')]({'plain':!![]});switch(_0x41c854['dialCheckDuplicateType']){case'always':_0x20935f[_0x8e42('0x4d')](db[_0x8e42('0x4e')]['query'](_0x443047(_0x41c854,'CampaignId'))[_0x8e42('0x4a')](function(){})[_0x8e42('0x27')](_0x3aa282()));break;case _0x8e42('0x56'):_0x20935f['push'](db['sequelize'][_0x8e42('0x50')](_0x5cc446(_0x41c854,'CampaignId'))[_0x8e42('0x4a')](function(){})[_0x8e42('0x27')](_0x3aa282()));break;default:_0x20935f['push'](db['sequelize']['query'](_0x2ca6bc(_0x41c854,'CampaignId'))['then'](function(){})['catch'](_0x3aa282()));}}}return _0x20935f;})[_0x8e42('0x51')]();})['then'](function(){return db['Campaign'][_0x8e42('0x46')]({'attributes':['id'],'include':[{'model':db['CmList'],'as':_0x8e42('0x53'),'where':{'id':LISTID}}]})[_0x8e42('0x4a')](function(_0x56dcd3){var _0x2ce60b=[];if(_0x56dcd3){for(var _0x26fa58=0x0,_0x139856;_0x26fa58<_0x56dcd3[_0x8e42('0x17')];_0x26fa58+=0x1){_0x139856=_0x56dcd3[_0x26fa58]['get']({'plain':!![]});_0x2ce60b[_0x8e42('0x4d')](db[_0x8e42('0x4e')][_0x8e42('0x50')](_0x492e9b(_0x139856,'CampaignId'))[_0x8e42('0x4a')](function(){})[_0x8e42('0x27')](_0x3aa282()));}}return _0x2ce60b;})[_0x8e42('0x51')]();})['catch'](function(_0x2d0ac1){logger[_0x8e42('0x14')](_0x8e42('0x57'),_0x8e42('0x58'),_0x2d0ac1[_0x8e42('0x19')]);});}var processPromises=function(_0x1ccc40){return BPromise[_0x8e42('0x51')](promises)[_0x8e42('0x4a')](function(_0x56072b){})[_0x8e42('0x27')](function(_0x57889d){logger['error'](_0x8e42('0x59'),JSON['stringify'](_0x57889d));})[_0x8e42('0x5a')](function(){socket[_0x8e42('0x5b')]('contact:csv_'+SOCKET_TIMESTAMP,{'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});promises=[];success=0x0;errors=0x0;duplicates=0x0;rows=[];if(_0x1ccc40){return _0x1ccc40[_0x8e42('0x5c')]();}});};var endCsv=function(){return BPromise['resolve']()[_0x8e42('0x4a')](function(){if(hopperContacts){return checkHopper();}})['then'](function(){socket[_0x8e42('0x5b')](_0x8e42('0x5d')+SOCKET_TIMESTAMP,{'finished':!![],'success':success,'errors':errors,'duplicates':duplicates,'rows':rows});try{fs[_0x8e42('0x5e')](FILEPATH);}catch(_0x2d4f12){logger[_0x8e42('0x14')](_0x8e42('0x5f'),JSON['stringify'](_0x2d4f12));}finally{process[_0x8e42('0x60')](0x0);}});};process['on'](_0x8e42('0x61'),function(){logger[_0x8e42('0x62')](_0x8e42('0x63'));endCsv();});function main(){return BPromise[_0x8e42('0x64')]()['then'](function(){if(DUPLICATES){DUPLICATES=DUPLICATES[_0x8e42('0x65')](',');return db[_0x8e42('0x66')][_0x8e42('0x46')]({'where':{'ListId':LISTID},'attributes':DUPLICATES,'raw':!![]});}})[_0x8e42('0x4a')](function(_0x281e0c){var _0x442322=fs[_0x8e42('0x67')](FILEPATH,{'highWaterMark':0xf*0x400*0x400});Papa['parse'](_0x442322,{'header':!![],'skipEmptyLines':!![],'step':function(_0x4245c0,_0x36e5d8){total+=0x1;var _0x2d6e3b=total;promises['push'](checkRow(_0x4245c0,_0x281e0c,_0x2d6e3b)[_0x8e42('0x4a')](function(){success+=0x1;})['catch'](function(_0x1ef494){if(_0x1ef494[_0x8e42('0x14')]){errors+=0x1;delete _0x1ef494[_0x8e42('0x14')];}else if(_0x1ef494[_0x8e42('0x26')]){duplicates+=0x1;delete _0x1ef494[_0x8e42('0x26')];}rows[_0x8e42('0x4d')](_0x1ef494);}));if(total%0xc8===0x0){_0x36e5d8['pause']();return processPromises(_0x36e5d8);}},'complete':function(){return processPromises()[_0x8e42('0x4a')](function(){logger[_0x8e42('0x62')]('CSV\x20parsed\x20correctly!');endCsv();});},'error':function(_0x25bc8e,_0x58eecf){logger['info'](_0x8e42('0x68'),JSON[_0x8e42('0x29')](_0x25bc8e));endCsv();}});})[_0x8e42('0x27')](function(_0x4167f1){logger[_0x8e42('0x14')](_0x8e42('0x69'),JSON[_0x8e42('0x29')](_0x4167f1));});}main();
\ No newline at end of file